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

947: return l_return;
948:
949: EXCEPTION
950: WHEN others THEN
951: IF SQLCODE <> hr_utility.hr_error_number
952: THEN
953: debug_others (l_proc_name, 10);
954: IF g_debug
955: THEN

Line 1414: IF SQLCODE <> hr_utility.hr_error_number

1410:
1411:
1412: EXCEPTION
1413: WHEN others THEN
1414: IF SQLCODE <> hr_utility.hr_error_number
1415: THEN
1416: debug_others (l_proc_name, 10);
1417: IF g_debug
1418: THEN

Line 1447: IF SQLCODE <> hr_utility.hr_error_number

1443: debug_exit(l_proc_name);
1444: return 'Y';
1445: EXCEPTION
1446: WHEN others THEN
1447: IF SQLCODE <> hr_utility.hr_error_number
1448: THEN
1449: debug_others (l_proc_name, 10);
1450: IF g_debug
1451: THEN