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.

[Home] [Help]

APPS.PQP_GB_PSI_SERVICE_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 143: IF SQLCODE <> hr_utility.hr_error_number

139: END IF;
140: EXCEPTION
141: WHEN OTHERS
142: THEN
143: IF SQLCODE <> hr_utility.hr_error_number
144: THEN
145: debug_others(l_proc_name, l_proc_step);
146:
147: IF g_debug

Line 188: IF SQLCODE <> hr_utility.hr_error_number

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

Line 263: IF SQLCODE <> hr_utility.hr_error_number

259: WHEN OTHERS
260: THEN
261: clear_cache;
262:
263: IF SQLCODE <> hr_utility.hr_error_number
264: THEN
265: debug_others(l_proc_name, l_proc_step);
266:
267: IF g_debug

Line 341: IF SQLCODE <> hr_utility.hr_error_number

337: WHEN OTHERS
338: THEN
339: clear_cache;
340:
341: IF SQLCODE <> hr_utility.hr_error_number
342: THEN
343: debug_others(l_proc_name, l_proc_step);
344:
345: IF g_debug

Line 408: IF SQLCODE <> hr_utility.hr_error_number

404: WHEN OTHERS
405: THEN
406: clear_cache;
407:
408: IF SQLCODE <> hr_utility.hr_error_number
409: THEN
410: debug_others(l_proc_name, l_proc_step);
411:
412: IF g_debug

Line 489: IF SQLCODE <> hr_utility.hr_error_number

485: WHEN OTHERS
486: THEN
487: clear_cache;
488:
489: IF SQLCODE <> hr_utility.hr_error_number
490: THEN
491: debug_others(l_proc_name, l_proc_step);
492:
493: IF g_debug

Line 567: IF SQLCODE <> hr_utility.hr_error_number

563: WHEN OTHERS
564: THEN
565: clear_cache;
566:
567: IF SQLCODE <> hr_utility.hr_error_number
568: THEN
569: debug_others(l_proc_name, l_proc_step);
570:
571: IF g_debug

Line 676: IF SQLCODE <> hr_utility.hr_error_number

672: WHEN OTHERS
673: THEN
674: clear_cache;
675:
676: IF SQLCODE <> hr_utility.hr_error_number
677: THEN
678: debug_others(l_proc_name, l_proc_step);
679:
680: IF g_debug

Line 737: IF SQLCODE <> hr_utility.hr_error_number

733: WHEN OTHERS
734: THEN
735: clear_cache;
736:
737: IF SQLCODE <> hr_utility.hr_error_number
738: THEN
739: debug_others(l_proc_name, l_proc_step);
740:
741: IF g_debug

Line 797: IF SQLCODE <> hr_utility.hr_error_number

793: WHEN OTHERS
794: THEN
795: clear_cache;
796:
797: IF SQLCODE <> hr_utility.hr_error_number
798: THEN
799: debug_others(l_proc_name, l_proc_step);
800:
801: IF g_debug

Line 857: IF SQLCODE <> hr_utility.hr_error_number

853: WHEN OTHERS
854: THEN
855: clear_cache;
856:
857: IF SQLCODE <> hr_utility.hr_error_number
858: THEN
859: debug_others(l_proc_name, l_proc_step);
860:
861: IF g_debug

Line 953: IF SQLCODE <> hr_utility.hr_error_number

949: WHEN OTHERS
950: THEN
951: clear_cache;
952:
953: IF SQLCODE <> hr_utility.hr_error_number
954: THEN
955: debug_others(l_proc_name, l_proc_step);
956:
957: IF g_debug

Line 1521: IF SQLCODE <> hr_utility.hr_error_number

1517: WHEN OTHERS
1518: THEN
1519: clear_cache;
1520:
1521: IF SQLCODE <> hr_utility.hr_error_number
1522: THEN
1523: debug_others(l_proc_name, l_proc_step);
1524:
1525: IF g_debug

Line 1639: IF SQLCODE <> hr_utility.hr_error_number

1635: WHEN OTHERS
1636: THEN
1637: clear_cache;
1638:
1639: IF SQLCODE <> hr_utility.hr_error_number
1640: THEN
1641: debug_others(l_proc_name, l_proc_step);
1642:
1643: IF g_debug

Line 1767: IF SQLCODE <> hr_utility.hr_error_number

1763: WHEN OTHERS
1764: THEN
1765: clear_cache;
1766:
1767: IF SQLCODE <> hr_utility.hr_error_number
1768: THEN
1769: debug_others(l_proc_name, l_proc_step);
1770:
1771: IF g_debug

Line 1877: IF SQLCODE <> hr_utility.hr_error_number

1873: WHEN OTHERS
1874: THEN
1875: clear_cache;
1876:
1877: IF SQLCODE <> hr_utility.hr_error_number
1878: THEN
1879: debug_others(l_proc_name, l_proc_step);
1880:
1881: IF g_debug

Line 1939: IF SQLCODE <> hr_utility.hr_error_number

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

Line 2082: IF SQLCODE <> hr_utility.hr_error_number

2078: WHEN OTHERS
2079: THEN
2080: clear_cache;
2081:
2082: IF SQLCODE <> hr_utility.hr_error_number
2083: THEN
2084: debug_others(l_proc_name, l_proc_step);
2085:
2086: IF g_debug

Line 2178: IF SQLCODE <> hr_utility.hr_error_number

2174: WHEN OTHERS
2175: THEN
2176: clear_cache;
2177:
2178: IF SQLCODE <> hr_utility.hr_error_number
2179: THEN
2180: debug_others(l_proc_name, l_proc_step);
2181:
2182: IF g_debug

Line 2307: IF SQLCODE <> hr_utility.hr_error_number

2303: WHEN OTHERS
2304: THEN
2305: clear_cache;
2306:
2307: IF SQLCODE <> hr_utility.hr_error_number
2308: THEN
2309: debug_others(l_proc_name, l_proc_step);
2310:
2311: IF g_debug

Line 2383: IF SQLCODE <> hr_utility.hr_error_number

2379: WHEN OTHERS
2380: THEN
2381: clear_cache;
2382:
2383: IF SQLCODE <> hr_utility.hr_error_number
2384: THEN
2385: debug_others(l_proc_name, l_proc_step);
2386:
2387: IF g_debug

Line 2612: IF SQLCODE <> hr_utility.hr_error_number

2608: WHEN OTHERS
2609: THEN
2610: clear_cache;
2611:
2612: IF SQLCODE <> hr_utility.hr_error_number
2613: THEN
2614: debug_others(l_proc_name, l_proc_step);
2615:
2616: IF g_debug

Line 2676: IF SQLCODE <> hr_utility.hr_error_number

2672: WHEN OTHERS
2673: THEN
2674: clear_cache;
2675:
2676: IF SQLCODE <> hr_utility.hr_error_number
2677: THEN
2678: debug_others(l_proc_name, l_proc_step);
2679:
2680: IF g_debug

Line 2756: IF SQLCODE <> hr_utility.hr_error_number

2752: WHEN OTHERS
2753: THEN
2754: clear_cache;
2755:
2756: IF SQLCODE <> hr_utility.hr_error_number
2757: THEN
2758: debug_others(l_proc_name, l_proc_step);
2759:
2760: IF g_debug

Line 2848: IF SQLCODE <> hr_utility.hr_error_number

2844: WHEN OTHERS
2845: THEN
2846: clear_cache;
2847:
2848: IF SQLCODE <> hr_utility.hr_error_number
2849: THEN
2850: debug_others(l_proc_name, l_proc_step);
2851:
2852: IF g_debug

Line 3030: IF SQLCODE <> hr_utility.hr_error_number

3026: WHEN OTHERS
3027: THEN
3028: clear_cache;
3029:
3030: IF SQLCODE <> hr_utility.hr_error_number
3031: THEN
3032: debug_others(l_proc_name, l_proc_step);
3033:
3034: IF g_debug

Line 3169: IF SQLCODE <> hr_utility.hr_error_number

3165: WHEN OTHERS
3166: THEN
3167: clear_cache;
3168:
3169: IF SQLCODE <> hr_utility.hr_error_number
3170: THEN
3171: debug_others(l_proc_name, l_proc_step);
3172:
3173: IF g_debug

Line 4313: IF SQLCODE <> hr_utility.hr_error_number

4309: WHEN OTHERS
4310: THEN
4311: clear_cache;
4312:
4313: IF SQLCODE <> hr_utility.hr_error_number
4314: THEN
4315: debug_others(l_proc_name, l_proc_step);
4316:
4317: IF g_debug

Line 4454: IF SQLCODE <> hr_utility.hr_error_number

4450: WHEN OTHERS
4451: THEN
4452: clear_cache;
4453:
4454: IF SQLCODE <> hr_utility.hr_error_number
4455: THEN
4456: debug_others(l_proc_name, l_proc_step);
4457:
4458: IF g_debug

Line 4694: IF SQLCODE <> hr_utility.hr_error_number

4690: WHEN OTHERS
4691: THEN
4692: clear_cache;
4693:
4694: IF SQLCODE <> hr_utility.hr_error_number
4695: THEN
4696: debug_others(l_proc_name, l_proc_step);
4697:
4698: IF g_debug

Line 4956: IF SQLCODE <> hr_utility.hr_error_number

4952: WHEN OTHERS
4953: THEN
4954: clear_cache;
4955:
4956: IF SQLCODE <> hr_utility.hr_error_number
4957: THEN
4958: debug_others(l_proc_name, l_proc_step);
4959:
4960: IF g_debug

Line 5055: IF SQLCODE <> hr_utility.hr_error_number

5051: WHEN OTHERS
5052: THEN
5053: clear_cache;
5054:
5055: IF SQLCODE <> hr_utility.hr_error_number
5056: THEN
5057: debug_others(l_proc_name, l_proc_step);
5058:
5059: IF g_debug

Line 5759: IF SQLCODE <> hr_utility.hr_error_number

5755: WHEN OTHERS
5756: THEN
5757: clear_cache;
5758:
5759: IF SQLCODE <> hr_utility.hr_error_number
5760: THEN
5761: debug_others(l_proc_name, l_proc_step);
5762:
5763: IF g_debug

Line 6820: IF SQLCODE <> hr_utility.hr_error_number

6816: WHEN OTHERS
6817: THEN
6818: clear_cache;
6819:
6820: IF SQLCODE <> hr_utility.hr_error_number
6821: THEN
6822: debug_others(l_proc_name, l_proc_step);
6823:
6824: IF g_debug

Line 7049: IF SQLCODE <> hr_utility.hr_error_number

7045: WHEN OTHERS
7046: THEN
7047: clear_cache;
7048:
7049: IF SQLCODE <> hr_utility.hr_error_number
7050: THEN
7051: debug_others(l_proc_name, l_proc_step);
7052:
7053: IF g_debug

Line 7241: IF SQLCODE <> hr_utility.hr_error_number

7237: WHEN OTHERS
7238: THEN
7239: clear_cache;
7240:
7241: IF SQLCODE <> hr_utility.hr_error_number
7242: THEN
7243: debug_others(l_proc_name, l_proc_step);
7244:
7245: IF g_debug

Line 7292: IF SQLCODE <> hr_utility.hr_error_number

7288: WHEN OTHERS
7289: THEN
7290: clear_cache;
7291:
7292: IF SQLCODE <> hr_utility.hr_error_number
7293: THEN
7294: debug_others(l_proc_name, l_proc_step);
7295:
7296: IF g_debug