APPS.PQP_GB_PSI_WPS_HISTORY dependencies on HR_UTILITY

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

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

Line 78: hr_utility.trace_off;

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

Line 148: IF SQLCODE <> hr_utility.hr_error_number

144: debug_exit(l_proc_name);
145: END IF;
146: EXCEPTION
147: WHEN others THEN
148: IF SQLCODE <> hr_utility.hr_error_number
149: THEN
150: debug_others (l_proc_name, l_proc_step);
151: IF g_debug
152: THEN

Line 232: IF SQLCODE <> hr_utility.hr_error_number

228:
229: debug_exit(l_proc_name);
230: EXCEPTION
231: WHEN others THEN
232: IF SQLCODE <> hr_utility.hr_error_number
233: THEN
234: debug_others (l_proc_name, 10);
235: IF g_debug
236: THEN

Line 279: IF SQLCODE <> hr_utility.hr_error_number

275: g_is_terminated := 'N';
276: debug_exit(l_proc_name);
277: EXCEPTION
278: WHEN others THEN
279: IF SQLCODE <> hr_utility.hr_error_number
280: THEN
281: debug_others (l_proc_name, 10);
282: IF g_debug
283: THEN

Line 491: IF SQLCODE <> hr_utility.hr_error_number

487: return l_return;
488:
489: EXCEPTION
490: WHEN others THEN
491: IF SQLCODE <> hr_utility.hr_error_number
492: THEN
493: debug_others (l_proc_name, 10);
494: IF g_debug
495: THEN

Line 987: IF SQLCODE <> hr_utility.hr_error_number

983: return l_return;
984:
985: EXCEPTION
986: WHEN others THEN
987: IF SQLCODE <> hr_utility.hr_error_number
988: THEN
989: debug_others (l_proc_name, 10);
990: IF g_debug
991: THEN

Line 1450: IF SQLCODE <> hr_utility.hr_error_number

1446:
1447:
1448: EXCEPTION
1449: WHEN others THEN
1450: IF SQLCODE <> hr_utility.hr_error_number
1451: THEN
1452: debug_others (l_proc_name, 10);
1453: IF g_debug
1454: THEN

Line 1483: IF SQLCODE <> hr_utility.hr_error_number

1479: debug_exit(l_proc_name);
1480: return 'Y';
1481: EXCEPTION
1482: WHEN others THEN
1483: IF SQLCODE <> hr_utility.hr_error_number
1484: THEN
1485: debug_others (l_proc_name, 10);
1486: IF g_debug
1487: THEN