APPS.AP_WEB_DB_HR_INT_PKG dependencies on APP_EXCEPTION

Line 25: APP_EXCEPTION.RAISE_EXCEPTION;

21: RETURN FALSE;
22:
23: WHEN OTHERS THEN
24: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUserIdForEmpCursor' );
25: APP_EXCEPTION.RAISE_EXCEPTION;
26: return FALSE;
27:
28: END GetUserIdForEmpCursor;
29:

Line 57: APP_EXCEPTION.RAISE_EXCEPTION;

53: RETURN FALSE;
54:
55: WHEN OTHERS THEN
56: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetWorkerListForWebUserCursor' );
57: APP_EXCEPTION.RAISE_EXCEPTION;
58: return FALSE;
59:
60: END GetAllEmpListForWebUserCursor;
61:

Line 88: APP_EXCEPTION.RAISE_EXCEPTION;

84: RETURN FALSE;
85:
86: WHEN OTHERS THEN
87: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpListForWebUserCursor' );
88: APP_EXCEPTION.RAISE_EXCEPTION;
89: return FALSE;
90:
91: END GetEmpListForWebUserCursor;
92:

Line 166: APP_EXCEPTION.RAISE_EXCEPTION;

162: RETURN FALSE;
163:
164: WHEN OTHERS THEN
165: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmployeeInfoCursor' );
166: APP_EXCEPTION.RAISE_EXCEPTION;
167: return FALSE;
168:
169: END GetEmployeeInfoCursor;
170:

Line 202: APP_EXCEPTION.RAISE_EXCEPTION;

198: RETURN FALSE;
199:
200: WHEN OTHERS THEN
201: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetNumOfEmpForWebUser' );
202: APP_EXCEPTION.RAISE_EXCEPTION;
203: return FALSE;
204:
205: END GetNumOfEmpForWebUser;
206:

Line 230: APP_EXCEPTION.RAISE_EXCEPTION;

226: RETURN FALSE;
227:
228: WHEN OTHERS THEN
229: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorID' );
230: APP_EXCEPTION.RAISE_EXCEPTION;
231: return FALSE;
232:
233: END GetSupervisorID;
234:

Line 267: APP_EXCEPTION.RAISE_EXCEPTION;

263: RETURN FALSE;
264:
265: WHEN OTHERS THEN
266: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpOrgId' );
267: APP_EXCEPTION.RAISE_EXCEPTION;
268: return FALSE;
269: END GetEmpOrgId;
270:
271: -------------------------------------------------------------------

Line 344: APP_EXCEPTION.RAISE_EXCEPTION;

340: RETURN FALSE;
341:
342: WHEN OTHERS THEN
343: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmployeeInfo' );
344: APP_EXCEPTION.RAISE_EXCEPTION;
345: return FALSE;
346:
347: END GetEmployeeInfo;
348:

Line 370: APP_EXCEPTION.RAISE_EXCEPTION;

366: RETURN FALSE;
367:
368: WHEN OTHERS THEN
369: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpIdForUser' );
370: APP_EXCEPTION.RAISE_EXCEPTION;
371: return FALSE;
372:
373: END GetEmpIdForUser;
374:

Line 419: APP_EXCEPTION.RAISE_EXCEPTION;

415: RETURN 0;
416:
417: WHEN OTHERS THEN
418: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSecurAttrCount' );
419: APP_EXCEPTION.RAISE_EXCEPTION;
420: return 0;
421: END;
422:
423: /*------------------------------------------------------------+

Line 453: APP_EXCEPTION.RAISE_EXCEPTION;

449: RETURN NULL;
450:
451: WHEN OTHERS THEN
452: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorName' );
453: APP_EXCEPTION.RAISE_EXCEPTION;
454: RETURN NULL;
455:
456: END GetSupervisorName;
457:

Line 484: APP_EXCEPTION.RAISE_EXCEPTION;

480: p_supervisor_id :=NULL;
481: p_supervisor_name :=NULL;
482: WHEN OTHERS THEN
483: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorDetails' );
484: APP_EXCEPTION.RAISE_EXCEPTION;
485:
486:
487: END GetSupervisorDetails;
488:

Line 542: APP_EXCEPTION.RAISE_EXCEPTION;

538: RETURN FALSE;
539:
540: WHEN OTHERS THEN
541: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorInfo' );
542: APP_EXCEPTION.RAISE_EXCEPTION;
543: return FALSE;
544:
545: END GetSupervisorInfo;
546:

Line 787: APP_EXCEPTION.RAISE_EXCEPTION;

783: null;
784:
785: WHEN OTHERS THEN
786: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorInfo' );
787: APP_EXCEPTION.RAISE_EXCEPTION;
788:
789: END GetManagerIdAndStatus;
790:
791: FUNCTION GetEmployeeName(

Line 833: APP_EXCEPTION.RAISE_EXCEPTION;

829: RETURN FALSE;
830:
831: WHEN OTHERS THEN
832: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpOrgId' );
833: APP_EXCEPTION.RAISE_EXCEPTION;
834: return FALSE;
835: END GetEmpOrgId;
836:
837: --

Line 916: APP_EXCEPTION.RAISE_EXCEPTION;

912: EXCEPTION
913: WHEN OTHERS THEN
914: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getFinalActiveManager',
915: l_debug_info);
916: APP_EXCEPTION.RAISE_EXCEPTION;
917: END getFinalActiveManager;
918:
919: PROCEDURE GetEmpNameNumber(
920: p_employee_id IN NUMBER,

Line 939: APP_EXCEPTION.RAISE_EXCEPTION;

935: EXCEPTION
936: WHEN OTHERS THEN
937: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_DB_HR_INT_PKG.GetEmpNameNumber',
938: l_debug_info);
939: APP_EXCEPTION.RAISE_EXCEPTION;
940: END GetEmpNameNumber;
941:
942: PROCEDURE GetUserIdFromName(
943: p_user_name IN VARCHAR2,

Line 958: APP_EXCEPTION.RAISE_EXCEPTION;

954: WHEN NO_DATA_FOUND THEN
955: p_user_id := -1;
956: WHEN OTHERS THEN
957: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUserIdFromName' );
958: APP_EXCEPTION.RAISE_EXCEPTION;
959: END GetUserIdFromName;
960:
961: END AP_WEB_DB_HR_INT_PKG;