5903765: 11i Applications Technology: Linux x86: failed on FAILED: file afgstusr.sql on worker 1

Problem Summary
---------------------------------------------------
Patch 5903765 failed on FAILED: file afgstusr.sql on worker  1

Problem Description
---------------------------------------------------
Patch 5903765 failed on FAILED: file afgstusr.sql on worker  1

checked the status of apps.FND_WEB_SEC  and package body was showing invalid
I tried to compile package body and got errors.

SQL> alter package apps.FND_WEB_SEC compile body;

Warning: Package Body altered with compilation errors.


show errors showing the following errors.

SQL> show errors
Errors for PACKAGE BODY APPS.FND_WEB_SEC:

LINE/COL ERROR
-------- -----------------------------------------------------------------
241/10   PLS-00323: subprogram or cursor 'GET_GUEST_USERNAME_PWD' is
        declared in a package specification and must be defined in the