APPS.PQP_GB_PSI_LOCATION_CODES dependencies on HR_UTILITY

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

38: BEGIN
39: --
40: IF g_debug THEN
41: IF pqp_utilities.g_nested_level = 0 THEN
42: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
43: END IF;
44: pqp_utilities.debug_enter (
45: p_proc_name => p_proc_name
46: ,p_trace_on => p_trace_on

Line 71: hr_utility.trace_off;

67: ,p_trace_off => p_trace_off
68: );
69:
70: IF pqp_utilities.g_nested_level = 0 THEN
71: hr_utility.trace_off;
72: END IF;
73: END IF;
74: --
75: END debug_exit;

Line 123: IF SQLCODE <> hr_utility.hr_error_number

119: debug_exit(l_proc_name);
120: END IF;
121: EXCEPTION
122: WHEN others THEN
123: IF SQLCODE <> hr_utility.hr_error_number
124: THEN
125: debug_others (l_proc_name, l_proc_step);
126: IF g_debug
127: THEN

Line 229: IF SQLCODE <> hr_utility.hr_error_number

225: return l_return;
226:
227: EXCEPTION
228: WHEN others THEN
229: IF SQLCODE <> hr_utility.hr_error_number
230: THEN
231: debug_others (l_proc_name, 10);
232: IF g_debug
233: THEN

Line 291: IF SQLCODE <> hr_utility.hr_error_number

287: RETURN 0;
288:
289: EXCEPTION
290: WHEN others THEN
291: IF SQLCODE <> hr_utility.hr_error_number
292: THEN
293: debug_others (l_proc_name, 10);
294: IF g_debug
295: THEN

Line 328: IF SQLCODE <> hr_utility.hr_error_number

324:
325:
326: EXCEPTION
327: WHEN others THEN
328: IF SQLCODE <> hr_utility.hr_error_number
329: THEN
330: debug_others (l_proc_name, 10);
331: IF g_debug
332: THEN