eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_DB_HR_INT_PKG dependencies on AP_WEB_DB_UTIL_PKG

Line 24: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUserIdForEmpCursor' );

20: WHEN NO_DATA_FOUND THEN
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;

Line 56: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetWorkerListForWebUserCursor' );

52: WHEN NO_DATA_FOUND THEN
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;

Line 87: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpListForWebUserCursor' );

83: WHEN NO_DATA_FOUND THEN
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;

Line 165: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmployeeInfoCursor' );

161: WHEN NO_DATA_FOUND THEN
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;

Line 201: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetNumOfEmpForWebUser' );

197: WHEN NO_DATA_FOUND THEN
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;

Line 229: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorID' );

225: WHEN NO_DATA_FOUND THEN
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;

Line 266: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpOrgId' );

262: WHEN NO_DATA_FOUND THEN
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:

Line 342: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmployeeInfo' );

338: WHEN NO_DATA_FOUND THEN
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;

Line 368: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpIdForUser' );

364: WHEN NO_DATA_FOUND THEN
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;

Line 417: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSecurAttrCount' );

413: WHEN NO_DATA_FOUND THEN
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:

Line 451: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorName' );

447: WHEN NO_DATA_FOUND THEN
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;

Line 482: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorDetails' );

478: WHEN NO_DATA_FOUND THEN
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;

Line 540: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorInfo' );

536: WHEN NO_DATA_FOUND THEN
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;

Line 785: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetSupervisorInfo' );

781: WHEN NO_DATA_FOUND THEN
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:

Line 831: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetEmpOrgId' );

827: WHEN NO_DATA_FOUND THEN
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:

Line 913: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_CUST_AME_PKG.getFinalActiveManager',

909: end if;
910:
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:

Line 936: AP_WEB_DB_UTIL_PKG.RaiseException('AP_WEB_DB_HR_INT_PKG.GetEmpNameNumber',

932: END IF;
933:
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:

Line 956: AP_WEB_DB_UTIL_PKG.RaiseException( 'GetUserIdFromName' );

952: 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;