APPS.PQP_GB_PSI_SCH dependencies on HR_UTILITY

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

26: BEGIN
27: --
28: if g_debug then
29: IF pqp_utilities.g_nested_level = 0 THEN
30: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
31: END IF;
32: -- g_nested_level := g_nested_level + 1;
33: -- debug('Entering: ' || NVL(p_proc_name, g_proc_name)
34: -- ,g_nested_level * 100);

Line 64: hr_utility.trace_off;

60: -- so we must turn it off for the same condition
61: -- Also turn off tracing when the override flag of p_trace_off has been
62: -- passed as Y
63: IF pqp_utilities.g_nested_level = 0 THEN
64: hr_utility.trace_off;
65: END IF; -- (g_nested_level = 0
66: end if;
67: --
68: END debug_exit;

Line 122: IF SQLCODE <> hr_utility.hr_error_number THEN

118: debug_exit(l_proc_name);
119: END IF;
120: EXCEPTION
121: WHEN OTHERS THEN
122: IF SQLCODE <> hr_utility.hr_error_number THEN
123: debug_others (l_proc_name, l_proc_step);
124: IF g_debug THEN
125: DEBUG ( 'Leaving: ' || l_proc_name, -999);
126: END IF;

Line 262: IF SQLCODE <> hr_utility.hr_error_number THEN

258: END IF;
259: EXCEPTION
260: WHEN OTHERS THEN
261: clear_cache;
262: IF SQLCODE <> hr_utility.hr_error_number THEN
263: debug_others(l_proc_name, l_proc_step);
264: IF g_debug THEN
265: DEBUG('Leaving: ' || l_proc_name, -999);
266: END IF;

Line 361: IF SQLCODE <> hr_utility.hr_error_number THEN

357: RETURN l_pension_category;
358: EXCEPTION
359: WHEN OTHERS THEN
360: clear_cache;
361: IF SQLCODE <> hr_utility.hr_error_number THEN
362: debug_others(l_proc_name, l_proc_step);
363: IF g_debug THEN
364: DEBUG('Leaving: ' || l_proc_name, -999);
365: END IF;

Line 396: IF SQLCODE <> hr_utility.hr_error_number THEN

392: debug('p_effective_date: '||p_effective_date,30);
393: debug_exit(l_proc_name);
394: EXCEPTION
395: WHEN OTHERS THEN
396: IF SQLCODE <> hr_utility.hr_error_number THEN
397: debug_others (l_proc_name, 10);
398: IF g_debug THEN
399: DEBUG ( 'Leaving: ' || l_proc_name, -999);
400: END IF;

Line 427: IF SQLCODE <> hr_utility.hr_error_number THEN

423: g_is_terminated := 'N';
424: debug_exit(l_proc_name);
425: EXCEPTION
426: WHEN OTHERS THEN
427: IF SQLCODE <> hr_utility.hr_error_number THEN
428: debug_others (l_proc_name, 10);
429: IF g_debug THEN
430: DEBUG ( 'Leaving: ' || l_proc_name, -999);
431: END IF;

Line 842: IF SQLCODE <> hr_utility.hr_error_number

838: debug('leaving '||l_proc_name);
839: RETURN p_effective_start_date;
840: EXCEPTION
841: WHEN others THEN
842: IF SQLCODE <> hr_utility.hr_error_number
843: THEN
844: debug_others (l_proc_name, 10);
845: IF g_debug
846: THEN

Line 914: IF SQLCODE <> hr_utility.hr_error_number THEN

910: RETURN 0;
911: EXCEPTION
912: WHEN OTHERS THEN
913: --clear_cache;
914: IF SQLCODE <> hr_utility.hr_error_number THEN
915: debug_others(l_proc_name, l_proc_step);
916: IF g_debug THEN
917: DEBUG('Leaving: ' || l_proc_name, -999);
918: END IF;

Line 946: IF SQLCODE <> hr_utility.hr_error_number THEN

942: RETURN l_return_value;
943: EXCEPTION
944: WHEN OTHERS THEN
945: --clear_cache;
946: IF SQLCODE <> hr_utility.hr_error_number THEN
947: debug_others(l_proc_name, l_proc_step);
948: IF g_debug THEN
949: DEBUG('Leaving: ' || l_proc_name, -999);
950: END IF;