DBA Data[Home] [Help]

APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on HR_UTILITY

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

30: BEGIN
31: --
32: IF pqp_utilities.g_nested_level = 0
33: THEN
34: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
35: END IF;
36:
37: -- g_nested_level := g_nested_level + 1;
38: -- debug('Entering: ' || NVL(p_proc_name, g_proc_name)

Line 71: hr_utility.trace_off;

67: -- so we must turn it off for the same condition
68: -- Also turn off tracing when the override flag of p_trace_off has been passed as Y
69: IF pqp_utilities.g_nested_level = 0
70: THEN
71: hr_utility.trace_off;
72: END IF; -- (g_nested_level = 0
73:
74: --
75: END debug_exit;

Line 180: IF SQLCODE <> hr_utility.hr_error_number

176: END IF;
177: EXCEPTION
178: WHEN OTHERS
179: THEN
180: IF SQLCODE <> hr_utility.hr_error_number
181: THEN
182: debug_others(l_proc_name, l_proc_step);
183:
184: IF g_debug

Line 226: IF SQLCODE <> hr_utility.hr_error_number

222: END IF;
223: EXCEPTION
224: WHEN OTHERS
225: THEN
226: IF SQLCODE <> hr_utility.hr_error_number
227: THEN
228: debug_others(l_proc_name, l_proc_step);
229:
230: IF g_debug

Line 296: IF SQLCODE <> hr_utility.hr_error_number

292: WHEN OTHERS
293: THEN
294: clear_cache;
295:
296: IF SQLCODE <> hr_utility.hr_error_number
297: THEN
298: debug_others(l_proc_name, l_proc_step);
299:
300: IF g_debug

Line 384: IF SQLCODE <> hr_utility.hr_error_number

380: WHEN OTHERS
381: THEN
382: clear_cache;
383:
384: IF SQLCODE <> hr_utility.hr_error_number
385: THEN
386: debug_others(l_proc_name, l_proc_step);
387:
388: IF g_debug

Line 461: IF SQLCODE <> hr_utility.hr_error_number

457: WHEN OTHERS
458: THEN
459: clear_cache;
460:
461: IF SQLCODE <> hr_utility.hr_error_number
462: THEN
463: debug_others(l_proc_name, l_proc_step);
464:
465: IF g_debug

Line 619: IF SQLCODE <> hr_utility.hr_error_number

615: WHEN OTHERS
616: THEN
617: clear_cache;
618:
619: IF SQLCODE <> hr_utility.hr_error_number
620: THEN
621: debug_others(l_proc_name, l_proc_step);
622:
623: IF g_debug

Line 706: IF SQLCODE <> hr_utility.hr_error_number

702: WHEN OTHERS
703: THEN
704: clear_cache;
705:
706: IF SQLCODE <> hr_utility.hr_error_number
707: THEN
708: debug_others(l_proc_name, l_proc_step);
709:
710: IF g_debug

Line 894: IF SQLCODE <> hr_utility.hr_error_number

890: WHEN OTHERS
891: THEN
892: clear_cache;
893:
894: IF SQLCODE <> hr_utility.hr_error_number
895: THEN
896: debug_others(l_proc_name, l_proc_step);
897:
898: IF g_debug

Line 989: IF SQLCODE <> hr_utility.hr_error_number

985: WHEN OTHERS
986: THEN
987: clear_cache;
988:
989: IF SQLCODE <> hr_utility.hr_error_number
990: THEN
991: debug_others(l_proc_name, l_proc_step);
992:
993: IF g_debug

Line 1081: IF SQLCODE <> hr_utility.hr_error_number

1077: WHEN OTHERS
1078: THEN
1079: clear_cache;
1080:
1081: IF SQLCODE <> hr_utility.hr_error_number
1082: THEN
1083: debug_others(l_proc_name, l_proc_step);
1084:
1085: IF g_debug

Line 1161: IF SQLCODE <> hr_utility.hr_error_number

1157: WHEN OTHERS
1158: THEN
1159: clear_cache;
1160:
1161: IF SQLCODE <> hr_utility.hr_error_number
1162: THEN
1163: debug_others(l_proc_name, l_proc_step);
1164:
1165: IF g_debug

Line 1239: IF SQLCODE <> hr_utility.hr_error_number

1235: WHEN OTHERS
1236: THEN
1237: clear_cache;
1238:
1239: IF SQLCODE <> hr_utility.hr_error_number
1240: THEN
1241: debug_others(l_proc_name, l_proc_step);
1242:
1243: IF g_debug

Line 1320: IF SQLCODE <> hr_utility.hr_error_number

1316: WHEN OTHERS
1317: THEN
1318: clear_cache;
1319:
1320: IF SQLCODE <> hr_utility.hr_error_number
1321: THEN
1322: debug_others(l_proc_name, l_proc_step);
1323:
1324: IF g_debug

Line 1401: IF SQLCODE <> hr_utility.hr_error_number

1397: WHEN OTHERS
1398: THEN
1399: clear_cache;
1400:
1401: IF SQLCODE <> hr_utility.hr_error_number
1402: THEN
1403: debug_others(l_proc_name, l_proc_step);
1404:
1405: IF g_debug

Line 1497: IF SQLCODE <> hr_utility.hr_error_number

1493: WHEN OTHERS
1494: THEN
1495: clear_cache;
1496:
1497: IF SQLCODE <> hr_utility.hr_error_number
1498: THEN
1499: debug_others(l_proc_name, l_proc_step);
1500:
1501: IF g_debug

Line 1626: IF SQLCODE <> hr_utility.hr_error_number

1622: WHEN OTHERS
1623: THEN
1624: clear_cache;
1625:
1626: IF SQLCODE <> hr_utility.hr_error_number
1627: THEN
1628: debug_others(l_proc_name, l_proc_step);
1629:
1630: IF g_debug

Line 1688: IF SQLCODE <> hr_utility.hr_error_number

1684: WHEN OTHERS
1685: THEN
1686: clear_cache;
1687:
1688: IF SQLCODE <> hr_utility.hr_error_number
1689: THEN
1690: debug_others(l_proc_name, l_proc_step);
1691:
1692: IF g_debug

Line 1822: IF SQLCODE <> hr_utility.hr_error_number

1818: WHEN OTHERS
1819: THEN
1820: clear_cache;
1821:
1822: IF SQLCODE <> hr_utility.hr_error_number
1823: THEN
1824: debug_others(l_proc_name, l_proc_step);
1825:
1826: IF g_debug

Line 1942: IF SQLCODE <> hr_utility.hr_error_number

1938: WHEN OTHERS
1939: THEN
1940: clear_cache;
1941:
1942: IF SQLCODE <> hr_utility.hr_error_number
1943: THEN
1944: debug_others(l_proc_name, l_proc_step);
1945:
1946: IF g_debug

Line 2291: IF SQLCODE <> hr_utility.hr_error_number

2287: WHEN OTHERS
2288: THEN
2289: clear_cache;
2290:
2291: IF SQLCODE <> hr_utility.hr_error_number
2292: THEN
2293: debug_others(l_proc_name, l_proc_step);
2294:
2295: IF g_debug

Line 2487: IF SQLCODE <> hr_utility.hr_error_number

2483: WHEN OTHERS
2484: THEN
2485: clear_cache;
2486:
2487: IF SQLCODE <> hr_utility.hr_error_number
2488: THEN
2489: debug_others(l_proc_name, l_proc_step);
2490:
2491: IF g_debug

Line 3101: IF SQLCODE <> hr_utility.hr_error_number

3097: WHEN OTHERS
3098: THEN
3099: clear_cache;
3100:
3101: IF SQLCODE <> hr_utility.hr_error_number
3102: THEN
3103: debug_others(l_proc_name, l_proc_step);
3104:
3105: IF g_debug

Line 3350: IF SQLCODE <> hr_utility.hr_error_number

3346: WHEN OTHERS
3347: THEN
3348: clear_cache;
3349:
3350: IF SQLCODE <> hr_utility.hr_error_number
3351: THEN
3352: debug_others(l_proc_name, l_proc_step);
3353:
3354: IF g_debug

Line 3461: IF SQLCODE <> hr_utility.hr_error_number

3457: WHEN OTHERS
3458: THEN
3459: clear_cache;
3460:
3461: IF SQLCODE <> hr_utility.hr_error_number
3462: THEN
3463: debug_others(l_proc_name, l_proc_step);
3464:
3465: IF g_debug

Line 3802: IF SQLCODE <> hr_utility.hr_error_number

3798: WHEN OTHERS
3799: THEN
3800: clear_cache;
3801:
3802: IF SQLCODE <> hr_utility.hr_error_number
3803: THEN
3804: debug_others(l_proc_name, l_proc_step);
3805:
3806: IF g_debug

Line 4037: IF SQLCODE <> hr_utility.hr_error_number

4033: WHEN OTHERS
4034: THEN
4035: clear_cache;
4036:
4037: IF SQLCODE <> hr_utility.hr_error_number
4038: THEN
4039: debug_others(l_proc_name, l_proc_step);
4040:
4041: IF g_debug

Line 4241: IF SQLCODE <> hr_utility.hr_error_number

4237: WHEN OTHERS
4238: THEN
4239: clear_cache;
4240:
4241: IF SQLCODE <> hr_utility.hr_error_number
4242: THEN
4243: debug_others(l_proc_name, l_proc_step);
4244:
4245: IF g_debug

Line 4419: IF SQLCODE <> hr_utility.hr_error_number

4415: WHEN OTHERS
4416: THEN
4417: clear_cache;
4418:
4419: IF SQLCODE <> hr_utility.hr_error_number
4420: THEN
4421: debug_others(l_proc_name, l_proc_step);
4422:
4423: IF g_debug

Line 4611: IF SQLCODE <> hr_utility.hr_error_number

4607: WHEN OTHERS
4608: THEN
4609: clear_cache;
4610:
4611: IF SQLCODE <> hr_utility.hr_error_number
4612: THEN
4613: debug_others(l_proc_name, l_proc_step);
4614:
4615: IF g_debug

Line 4779: IF SQLCODE <> hr_utility.hr_error_number

4775: WHEN OTHERS
4776: THEN
4777: clear_cache;
4778:
4779: IF SQLCODE <> hr_utility.hr_error_number
4780: THEN
4781: debug_others(l_proc_name, l_proc_step);
4782:
4783: IF g_debug

Line 4949: IF SQLCODE <> hr_utility.hr_error_number

4945: WHEN OTHERS
4946: THEN
4947: clear_cache;
4948:
4949: IF SQLCODE <> hr_utility.hr_error_number
4950: THEN
4951: debug_others(l_proc_name, l_proc_step);
4952:
4953: IF g_debug

Line 5901: IF SQLCODE <> hr_utility.hr_error_number

5897: WHEN OTHERS
5898: THEN
5899: clear_cache;
5900:
5901: IF SQLCODE <> hr_utility.hr_error_number
5902: THEN
5903: debug_others(l_proc_name, l_proc_step);
5904:
5905: IF g_debug

Line 5952: IF SQLCODE <> hr_utility.hr_error_number

5948: WHEN OTHERS
5949: THEN
5950: clear_cache;
5951:
5952: IF SQLCODE <> hr_utility.hr_error_number
5953: THEN
5954: debug_others(l_proc_name, l_proc_step);
5955:
5956: IF g_debug