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 185: IF SQLCODE <> hr_utility.hr_error_number

181: END IF;
182: EXCEPTION
183: WHEN OTHERS
184: THEN
185: IF SQLCODE <> hr_utility.hr_error_number
186: THEN
187: debug_others(l_proc_name, l_proc_step);
188:
189: IF g_debug

Line 231: IF SQLCODE <> hr_utility.hr_error_number

227: END IF;
228: EXCEPTION
229: WHEN OTHERS
230: THEN
231: IF SQLCODE <> hr_utility.hr_error_number
232: THEN
233: debug_others(l_proc_name, l_proc_step);
234:
235: IF g_debug

Line 376: IF SQLCODE <> hr_utility.hr_error_number

372: WHEN OTHERS
373: THEN
374: clear_cache;
375:
376: IF SQLCODE <> hr_utility.hr_error_number
377: THEN
378: debug_others(l_proc_name, l_proc_step);
379:
380: IF g_debug

Line 464: IF SQLCODE <> hr_utility.hr_error_number

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

Line 541: IF SQLCODE <> hr_utility.hr_error_number

537: WHEN OTHERS
538: THEN
539: clear_cache;
540:
541: IF SQLCODE <> hr_utility.hr_error_number
542: THEN
543: debug_others(l_proc_name, l_proc_step);
544:
545: IF g_debug

Line 699: IF SQLCODE <> hr_utility.hr_error_number

695: WHEN OTHERS
696: THEN
697: clear_cache;
698:
699: IF SQLCODE <> hr_utility.hr_error_number
700: THEN
701: debug_others(l_proc_name, l_proc_step);
702:
703: IF g_debug

Line 786: IF SQLCODE <> hr_utility.hr_error_number

782: WHEN OTHERS
783: THEN
784: clear_cache;
785:
786: IF SQLCODE <> hr_utility.hr_error_number
787: THEN
788: debug_others(l_proc_name, l_proc_step);
789:
790: IF g_debug

Line 1010: IF SQLCODE <> hr_utility.hr_error_number

1006: WHEN OTHERS
1007: THEN
1008: clear_cache;
1009:
1010: IF SQLCODE <> hr_utility.hr_error_number
1011: THEN
1012: debug_others(l_proc_name, l_proc_step);
1013:
1014: IF g_debug

Line 1114: IF SQLCODE <> hr_utility.hr_error_number

1110: WHEN OTHERS
1111: THEN
1112: clear_cache;
1113:
1114: IF SQLCODE <> hr_utility.hr_error_number
1115: THEN
1116: debug_others(l_proc_name, l_proc_step);
1117:
1118: IF g_debug

Line 1206: IF SQLCODE <> hr_utility.hr_error_number

1202: WHEN OTHERS
1203: THEN
1204: clear_cache;
1205:
1206: IF SQLCODE <> hr_utility.hr_error_number
1207: THEN
1208: debug_others(l_proc_name, l_proc_step);
1209:
1210: IF g_debug

Line 1286: IF SQLCODE <> hr_utility.hr_error_number

1282: WHEN OTHERS
1283: THEN
1284: clear_cache;
1285:
1286: IF SQLCODE <> hr_utility.hr_error_number
1287: THEN
1288: debug_others(l_proc_name, l_proc_step);
1289:
1290: IF g_debug

Line 1364: IF SQLCODE <> hr_utility.hr_error_number

1360: WHEN OTHERS
1361: THEN
1362: clear_cache;
1363:
1364: IF SQLCODE <> hr_utility.hr_error_number
1365: THEN
1366: debug_others(l_proc_name, l_proc_step);
1367:
1368: IF g_debug

Line 1445: IF SQLCODE <> hr_utility.hr_error_number

1441: WHEN OTHERS
1442: THEN
1443: clear_cache;
1444:
1445: IF SQLCODE <> hr_utility.hr_error_number
1446: THEN
1447: debug_others(l_proc_name, l_proc_step);
1448:
1449: IF g_debug

Line 1526: IF SQLCODE <> hr_utility.hr_error_number

1522: WHEN OTHERS
1523: THEN
1524: clear_cache;
1525:
1526: IF SQLCODE <> hr_utility.hr_error_number
1527: THEN
1528: debug_others(l_proc_name, l_proc_step);
1529:
1530: IF g_debug

Line 1622: IF SQLCODE <> hr_utility.hr_error_number

1618: WHEN OTHERS
1619: THEN
1620: clear_cache;
1621:
1622: IF SQLCODE <> hr_utility.hr_error_number
1623: THEN
1624: debug_others(l_proc_name, l_proc_step);
1625:
1626: IF g_debug

Line 1751: IF SQLCODE <> hr_utility.hr_error_number

1747: WHEN OTHERS
1748: THEN
1749: clear_cache;
1750:
1751: IF SQLCODE <> hr_utility.hr_error_number
1752: THEN
1753: debug_others(l_proc_name, l_proc_step);
1754:
1755: IF g_debug

Line 1813: IF SQLCODE <> hr_utility.hr_error_number

1809: WHEN OTHERS
1810: THEN
1811: clear_cache;
1812:
1813: IF SQLCODE <> hr_utility.hr_error_number
1814: THEN
1815: debug_others(l_proc_name, l_proc_step);
1816:
1817: IF g_debug

Line 1947: IF SQLCODE <> hr_utility.hr_error_number

1943: WHEN OTHERS
1944: THEN
1945: clear_cache;
1946:
1947: IF SQLCODE <> hr_utility.hr_error_number
1948: THEN
1949: debug_others(l_proc_name, l_proc_step);
1950:
1951: IF g_debug

Line 2067: IF SQLCODE <> hr_utility.hr_error_number

2063: WHEN OTHERS
2064: THEN
2065: clear_cache;
2066:
2067: IF SQLCODE <> hr_utility.hr_error_number
2068: THEN
2069: debug_others(l_proc_name, l_proc_step);
2070:
2071: IF g_debug

Line 2447: IF SQLCODE <> hr_utility.hr_error_number

2443: WHEN OTHERS
2444: THEN
2445: clear_cache;
2446:
2447: IF SQLCODE <> hr_utility.hr_error_number
2448: THEN
2449: debug_others(l_proc_name, l_proc_step);
2450:
2451: IF g_debug

Line 2643: IF SQLCODE <> hr_utility.hr_error_number

2639: WHEN OTHERS
2640: THEN
2641: clear_cache;
2642:
2643: IF SQLCODE <> hr_utility.hr_error_number
2644: THEN
2645: debug_others(l_proc_name, l_proc_step);
2646:
2647: IF g_debug

Line 3277: IF SQLCODE <> hr_utility.hr_error_number

3273: WHEN OTHERS
3274: THEN
3275: clear_cache;
3276:
3277: IF SQLCODE <> hr_utility.hr_error_number
3278: THEN
3279: debug_others(l_proc_name, l_proc_step);
3280:
3281: IF g_debug

Line 3541: IF SQLCODE <> hr_utility.hr_error_number

3537: WHEN OTHERS
3538: THEN
3539: clear_cache;
3540:
3541: IF SQLCODE <> hr_utility.hr_error_number
3542: THEN
3543: debug_others(l_proc_name, l_proc_step);
3544:
3545: IF g_debug

Line 3652: IF SQLCODE <> hr_utility.hr_error_number

3648: WHEN OTHERS
3649: THEN
3650: clear_cache;
3651:
3652: IF SQLCODE <> hr_utility.hr_error_number
3653: THEN
3654: debug_others(l_proc_name, l_proc_step);
3655:
3656: IF g_debug

Line 4006: IF SQLCODE <> hr_utility.hr_error_number

4002: WHEN OTHERS
4003: THEN
4004: clear_cache;
4005:
4006: IF SQLCODE <> hr_utility.hr_error_number
4007: THEN
4008: debug_others(l_proc_name, l_proc_step);
4009:
4010: IF g_debug

Line 4246: IF SQLCODE <> hr_utility.hr_error_number

4242: WHEN OTHERS
4243: THEN
4244: clear_cache;
4245:
4246: IF SQLCODE <> hr_utility.hr_error_number
4247: THEN
4248: debug_others(l_proc_name, l_proc_step);
4249:
4250: IF g_debug

Line 4403: IF SQLCODE <> hr_utility.hr_error_number

4399: WHEN OTHERS
4400: THEN
4401: clear_cache;
4402:
4403: IF SQLCODE <> hr_utility.hr_error_number
4404: THEN
4405: debug_others(l_proc_name, l_proc_step);
4406:
4407: IF g_debug

Line 4608: IF SQLCODE <> hr_utility.hr_error_number

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

Line 4794: IF SQLCODE <> hr_utility.hr_error_number

4790: WHEN OTHERS
4791: THEN
4792: clear_cache;
4793:
4794: IF SQLCODE <> hr_utility.hr_error_number
4795: THEN
4796: debug_others(l_proc_name, l_proc_step);
4797:
4798: IF g_debug

Line 4994: IF SQLCODE <> hr_utility.hr_error_number

4990: WHEN OTHERS
4991: THEN
4992: clear_cache;
4993:
4994: IF SQLCODE <> hr_utility.hr_error_number
4995: THEN
4996: debug_others(l_proc_name, l_proc_step);
4997:
4998: IF g_debug

Line 5171: IF SQLCODE <> hr_utility.hr_error_number

5167: WHEN OTHERS
5168: THEN
5169: clear_cache;
5170:
5171: IF SQLCODE <> hr_utility.hr_error_number
5172: THEN
5173: debug_others(l_proc_name, l_proc_step);
5174:
5175: IF g_debug

Line 5349: IF SQLCODE <> hr_utility.hr_error_number

5345: WHEN OTHERS
5346: THEN
5347: clear_cache;
5348:
5349: IF SQLCODE <> hr_utility.hr_error_number
5350: THEN
5351: debug_others(l_proc_name, l_proc_step);
5352:
5353: IF g_debug

Line 6388: IF SQLCODE <> hr_utility.hr_error_number

6384: WHEN OTHERS
6385: THEN
6386: clear_cache;
6387:
6388: IF SQLCODE <> hr_utility.hr_error_number
6389: THEN
6390: debug_others(l_proc_name, l_proc_step);
6391:
6392: IF g_debug

Line 6439: IF SQLCODE <> hr_utility.hr_error_number

6435: WHEN OTHERS
6436: THEN
6437: clear_cache;
6438:
6439: IF SQLCODE <> hr_utility.hr_error_number
6440: THEN
6441: debug_others(l_proc_name, l_proc_step);
6442:
6443: IF g_debug