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

1535: WHEN OTHERS
1536: THEN
1537: clear_cache;
1538:
1539: IF SQLCODE <> hr_utility.hr_error_number
1540: THEN
1541: debug_others(l_proc_name, l_proc_step);
1542:
1543: IF g_debug

Line 1657: IF SQLCODE <> hr_utility.hr_error_number

1653: WHEN OTHERS
1654: THEN
1655: clear_cache;
1656:
1657: IF SQLCODE <> hr_utility.hr_error_number
1658: THEN
1659: debug_others(l_proc_name, l_proc_step);
1660:
1661: IF g_debug

Line 1785: IF SQLCODE <> hr_utility.hr_error_number

1781: WHEN OTHERS
1782: THEN
1783: clear_cache;
1784:
1785: IF SQLCODE <> hr_utility.hr_error_number
1786: THEN
1787: debug_others(l_proc_name, l_proc_step);
1788:
1789: IF g_debug

Line 1895: IF SQLCODE <> hr_utility.hr_error_number

1891: WHEN OTHERS
1892: THEN
1893: clear_cache;
1894:
1895: IF SQLCODE <> hr_utility.hr_error_number
1896: THEN
1897: debug_others(l_proc_name, l_proc_step);
1898:
1899: IF g_debug

Line 1957: IF SQLCODE <> hr_utility.hr_error_number

1953: WHEN OTHERS
1954: THEN
1955: clear_cache;
1956:
1957: IF SQLCODE <> hr_utility.hr_error_number
1958: THEN
1959: debug_others(l_proc_name, l_proc_step);
1960:
1961: IF g_debug

Line 2100: IF SQLCODE <> hr_utility.hr_error_number

2096: WHEN OTHERS
2097: THEN
2098: clear_cache;
2099:
2100: IF SQLCODE <> hr_utility.hr_error_number
2101: THEN
2102: debug_others(l_proc_name, l_proc_step);
2103:
2104: IF g_debug

Line 2196: IF SQLCODE <> hr_utility.hr_error_number

2192: WHEN OTHERS
2193: THEN
2194: clear_cache;
2195:
2196: IF SQLCODE <> hr_utility.hr_error_number
2197: THEN
2198: debug_others(l_proc_name, l_proc_step);
2199:
2200: IF g_debug

Line 2325: IF SQLCODE <> hr_utility.hr_error_number

2321: WHEN OTHERS
2322: THEN
2323: clear_cache;
2324:
2325: IF SQLCODE <> hr_utility.hr_error_number
2326: THEN
2327: debug_others(l_proc_name, l_proc_step);
2328:
2329: IF g_debug

Line 2401: IF SQLCODE <> hr_utility.hr_error_number

2397: WHEN OTHERS
2398: THEN
2399: clear_cache;
2400:
2401: IF SQLCODE <> hr_utility.hr_error_number
2402: THEN
2403: debug_others(l_proc_name, l_proc_step);
2404:
2405: IF g_debug

Line 2630: IF SQLCODE <> hr_utility.hr_error_number

2626: WHEN OTHERS
2627: THEN
2628: clear_cache;
2629:
2630: IF SQLCODE <> hr_utility.hr_error_number
2631: THEN
2632: debug_others(l_proc_name, l_proc_step);
2633:
2634: IF g_debug

Line 2694: IF SQLCODE <> hr_utility.hr_error_number

2690: WHEN OTHERS
2691: THEN
2692: clear_cache;
2693:
2694: IF SQLCODE <> hr_utility.hr_error_number
2695: THEN
2696: debug_others(l_proc_name, l_proc_step);
2697:
2698: IF g_debug

Line 2774: IF SQLCODE <> hr_utility.hr_error_number

2770: WHEN OTHERS
2771: THEN
2772: clear_cache;
2773:
2774: IF SQLCODE <> hr_utility.hr_error_number
2775: THEN
2776: debug_others(l_proc_name, l_proc_step);
2777:
2778: IF g_debug

Line 2866: IF SQLCODE <> hr_utility.hr_error_number

2862: WHEN OTHERS
2863: THEN
2864: clear_cache;
2865:
2866: IF SQLCODE <> hr_utility.hr_error_number
2867: THEN
2868: debug_others(l_proc_name, l_proc_step);
2869:
2870: IF g_debug

Line 3048: IF SQLCODE <> hr_utility.hr_error_number

3044: WHEN OTHERS
3045: THEN
3046: clear_cache;
3047:
3048: IF SQLCODE <> hr_utility.hr_error_number
3049: THEN
3050: debug_others(l_proc_name, l_proc_step);
3051:
3052: IF g_debug

Line 3187: IF SQLCODE <> hr_utility.hr_error_number

3183: WHEN OTHERS
3184: THEN
3185: clear_cache;
3186:
3187: IF SQLCODE <> hr_utility.hr_error_number
3188: THEN
3189: debug_others(l_proc_name, l_proc_step);
3190:
3191: IF g_debug

Line 4367: IF SQLCODE <> hr_utility.hr_error_number

4363: WHEN OTHERS
4364: THEN
4365: clear_cache;
4366:
4367: IF SQLCODE <> hr_utility.hr_error_number
4368: THEN
4369: debug_others(l_proc_name, l_proc_step);
4370:
4371: IF g_debug

Line 4508: IF SQLCODE <> hr_utility.hr_error_number

4504: WHEN OTHERS
4505: THEN
4506: clear_cache;
4507:
4508: IF SQLCODE <> hr_utility.hr_error_number
4509: THEN
4510: debug_others(l_proc_name, l_proc_step);
4511:
4512: IF g_debug

Line 4748: IF SQLCODE <> hr_utility.hr_error_number

4744: WHEN OTHERS
4745: THEN
4746: clear_cache;
4747:
4748: IF SQLCODE <> hr_utility.hr_error_number
4749: THEN
4750: debug_others(l_proc_name, l_proc_step);
4751:
4752: IF g_debug

Line 5010: IF SQLCODE <> hr_utility.hr_error_number

5006: WHEN OTHERS
5007: THEN
5008: clear_cache;
5009:
5010: IF SQLCODE <> hr_utility.hr_error_number
5011: THEN
5012: debug_others(l_proc_name, l_proc_step);
5013:
5014: IF g_debug

Line 5109: IF SQLCODE <> hr_utility.hr_error_number

5105: WHEN OTHERS
5106: THEN
5107: clear_cache;
5108:
5109: IF SQLCODE <> hr_utility.hr_error_number
5110: THEN
5111: debug_others(l_proc_name, l_proc_step);
5112:
5113: IF g_debug

Line 5821: IF SQLCODE <> hr_utility.hr_error_number

5817: WHEN OTHERS
5818: THEN
5819: clear_cache;
5820:
5821: IF SQLCODE <> hr_utility.hr_error_number
5822: THEN
5823: debug_others(l_proc_name, l_proc_step);
5824:
5825: IF g_debug

Line 6900: IF SQLCODE <> hr_utility.hr_error_number

6896: WHEN OTHERS
6897: THEN
6898: clear_cache;
6899:
6900: IF SQLCODE <> hr_utility.hr_error_number
6901: THEN
6902: debug_others(l_proc_name, l_proc_step);
6903:
6904: IF g_debug

Line 7129: IF SQLCODE <> hr_utility.hr_error_number

7125: WHEN OTHERS
7126: THEN
7127: clear_cache;
7128:
7129: IF SQLCODE <> hr_utility.hr_error_number
7130: THEN
7131: debug_others(l_proc_name, l_proc_step);
7132:
7133: IF g_debug

Line 7321: IF SQLCODE <> hr_utility.hr_error_number

7317: WHEN OTHERS
7318: THEN
7319: clear_cache;
7320:
7321: IF SQLCODE <> hr_utility.hr_error_number
7322: THEN
7323: debug_others(l_proc_name, l_proc_step);
7324:
7325: IF g_debug

Line 7372: IF SQLCODE <> hr_utility.hr_error_number

7368: WHEN OTHERS
7369: THEN
7370: clear_cache;
7371:
7372: IF SQLCODE <> hr_utility.hr_error_number
7373: THEN
7374: debug_others(l_proc_name, l_proc_step);
7375:
7376: IF g_debug