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 343: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 369: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 418: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 452: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 483: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 541: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 786: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 832: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 915: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 938: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 957: APP_EXCEPTION.RAISE_EXCEPTION;

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