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.PQP_GB_PSI_ADDDRESS dependencies on HR_UTILITY

Line 46: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn

42: BEGIN
43: --
44: IF g_debug THEN
45: IF pqp_utilities.g_nested_level = 0 THEN
46: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
47: END IF;
48: pqp_utilities.debug_enter (
49: p_proc_name => p_proc_name
50: ,p_trace_on => p_trace_on

Line 75: hr_utility.trace_off;

71: ,p_trace_off => p_trace_off
72: );
73:
74: IF pqp_utilities.g_nested_level = 0 THEN
75: hr_utility.trace_off;
76: END IF;
77: END IF;
78: --
79: END debug_exit;

Line 161: IF SQLCODE <> hr_utility.hr_error_number

157:
158: debug_exit(l_proc);
159: EXCEPTION
160: WHEN others THEN
161: IF SQLCODE <> hr_utility.hr_error_number
162: THEN
163: debug_others (l_proc, 10);
164: IF g_debug
165: THEN

Line 326: IF SQLCODE <> hr_utility.hr_error_number

322: END IF;
323: debug_exit(l_proc);
324: EXCEPTION
325: WHEN others THEN
326: IF SQLCODE <> hr_utility.hr_error_number
327: THEN
328: debug_others (l_proc, 10);
329: IF g_debug
330: THEN

Line 439: IF SQLCODE <> hr_utility.hr_error_number

435:
436: RETURN l_include;
437: EXCEPTION
438: WHEN others THEN
439: IF SQLCODE <> hr_utility.hr_error_number
440: THEN
441: debug_others (l_proc, 10);
442: IF g_debug
443: THEN

Line 604: IF SQLCODE <> hr_utility.hr_error_number

600: debug_exit(l_proc);
601: RETURN l_include;
602: EXCEPTION
603: WHEN others THEN
604: IF SQLCODE <> hr_utility.hr_error_number
605: THEN
606: debug_others (l_proc, 10);
607: IF g_debug
608: THEN

Line 700: IF SQLCODE <> hr_utility.hr_error_number

696: debug_exit(l_proc);
697: RETURN g_office_address_changed;
698: EXCEPTION
699: WHEN others THEN
700: IF SQLCODE <> hr_utility.hr_error_number
701: THEN
702: debug_others (l_proc, 10);
703: IF g_debug
704: THEN

Line 795: IF SQLCODE <> hr_utility.hr_error_number

791: debug_exit(l_proc);
792: RETURN g_home_address_changed;
793: EXCEPTION
794: WHEN others THEN
795: IF SQLCODE <> hr_utility.hr_error_number
796: THEN
797: debug_others (l_proc, 10);
798: IF g_debug
799: THEN

Line 944: IF SQLCODE <> hr_utility.hr_error_number

940: debug_exit(l_proc);
941: return 0;
942: EXCEPTION
943: WHEN others THEN
944: IF SQLCODE <> hr_utility.hr_error_number
945: THEN
946: debug_others (l_proc, 10);
947: IF g_debug
948: THEN

Line 993: IF SQLCODE <> hr_utility.hr_error_number

989: debug_exit(l_proc);
990: return 0;
991: EXCEPTION
992: WHEN others THEN
993: IF SQLCODE <> hr_utility.hr_error_number
994: THEN
995: debug_others (l_proc, 10);
996: IF g_debug
997: THEN

Line 1054: IF SQLCODE <> hr_utility.hr_error_number

1050: debug_exit(l_proc);
1051: return 0;
1052: EXCEPTION
1053: WHEN others THEN
1054: IF SQLCODE <> hr_utility.hr_error_number
1055: THEN
1056: debug_others (l_proc, 10);
1057: IF g_debug
1058: THEN

Line 1115: IF SQLCODE <> hr_utility.hr_error_number

1111: debug_exit(l_proc);
1112: return 0;
1113: EXCEPTION
1114: WHEN others THEN
1115: IF SQLCODE <> hr_utility.hr_error_number
1116: THEN
1117: debug_others (l_proc, 10);
1118: IF g_debug
1119: THEN

Line 1176: IF SQLCODE <> hr_utility.hr_error_number

1172: debug_exit(l_proc);
1173: return 0;
1174: EXCEPTION
1175: WHEN others THEN
1176: IF SQLCODE <> hr_utility.hr_error_number
1177: THEN
1178: debug_others (l_proc, 10);
1179: IF g_debug
1180: THEN

Line 1251: IF SQLCODE <> hr_utility.hr_error_number

1247: debug_exit(l_proc);
1248: return 0;
1249: EXCEPTION
1250: WHEN others THEN
1251: IF SQLCODE <> hr_utility.hr_error_number
1252: THEN
1253: debug_others (l_proc, 10);
1254: IF g_debug
1255: THEN

Line 1324: IF SQLCODE <> hr_utility.hr_error_number

1320: debug_exit(l_proc);
1321: return 0;
1322: EXCEPTION
1323: WHEN others THEN
1324: IF SQLCODE <> hr_utility.hr_error_number
1325: THEN
1326: debug_others (l_proc, 10);
1327: IF g_debug
1328: THEN

Line 1373: IF SQLCODE <> hr_utility.hr_error_number

1369: debug_exit(l_proc);
1370: return 0;
1371: EXCEPTION
1372: WHEN others THEN
1373: IF SQLCODE <> hr_utility.hr_error_number
1374: THEN
1375: debug_others (l_proc, 10);
1376: IF g_debug
1377: THEN

Line 1442: IF SQLCODE <> hr_utility.hr_error_number

1438: debug_exit(l_proc);
1439: return 0;
1440: EXCEPTION
1441: WHEN others THEN
1442: IF SQLCODE <> hr_utility.hr_error_number
1443: THEN
1444: debug_others (l_proc, 10);
1445: IF g_debug
1446: THEN

Line 1497: IF SQLCODE <> hr_utility.hr_error_number

1493: debug_exit(l_proc);
1494: return 0;
1495: EXCEPTION
1496: WHEN others THEN
1497: IF SQLCODE <> hr_utility.hr_error_number
1498: THEN
1499: debug_others (l_proc, 10);
1500: IF g_debug
1501: THEN

Line 1558: IF SQLCODE <> hr_utility.hr_error_number

1554: debug_exit(l_proc);
1555: return 0;
1556: EXCEPTION
1557: WHEN others THEN
1558: IF SQLCODE <> hr_utility.hr_error_number
1559: THEN
1560: debug_others (l_proc, 10);
1561: IF g_debug
1562: THEN

Line 1620: IF SQLCODE <> hr_utility.hr_error_number

1616: debug_exit(l_proc);
1617: return 0;
1618: EXCEPTION
1619: WHEN others THEN
1620: IF SQLCODE <> hr_utility.hr_error_number
1621: THEN
1622: debug_others (l_proc, 10);
1623: IF g_debug
1624: THEN

Line 1833: IF SQLCODE <> hr_utility.hr_error_number

1829: debug_exit(l_proc);
1830: return l_error;
1831: EXCEPTION
1832: WHEN others THEN
1833: IF SQLCODE <> hr_utility.hr_error_number
1834: THEN
1835: debug_others (l_proc, 10);
1836: IF g_debug
1837: THEN

Line 1868: IF SQLCODE <> hr_utility.hr_error_number

1864: debug_exit(l_proc);
1865: return 'Y';
1866: EXCEPTION
1867: WHEN others THEN
1868: IF SQLCODE <> hr_utility.hr_error_number
1869: THEN
1870: debug_others (l_proc, 10);
1871: IF g_debug
1872: THEN

Line 1918: IF SQLCODE <> hr_utility.hr_error_number

1914: debug_exit(l_proc);
1915: return FALSE;
1916: EXCEPTION
1917: WHEN others THEN
1918: IF SQLCODE <> hr_utility.hr_error_number
1919: THEN
1920: debug_others (l_proc, 10);
1921: IF g_debug
1922: THEN