APPS.PQP_GB_PSI_BON_HISTORY dependencies on HR_UTILITY

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

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

Line 81: hr_utility.trace_off;

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

Line 143: IF SQLCODE <> hr_utility.hr_error_number

139: END IF;
140: debug_exit(l_proc);
141: EXCEPTION
142: WHEN others THEN
143: IF SQLCODE <> hr_utility.hr_error_number
144: THEN
145: debug_others (l_proc, 10);
146: IF g_debug
147: THEN

Line 190: IF SQLCODE <> hr_utility.hr_error_number

186:
187: debug_exit(l_proc);
188: EXCEPTION
189: WHEN others THEN
190: IF SQLCODE <> hr_utility.hr_error_number
191: THEN
192: debug_others (l_proc, 10);
193: IF g_debug
194: THEN

Line 260: IF SQLCODE <> hr_utility.hr_error_number

256:
257: debug_exit(l_proc);
258: EXCEPTION
259: WHEN others THEN
260: IF SQLCODE <> hr_utility.hr_error_number
261: THEN
262: debug_others (l_proc, 10);
263: IF g_debug
264: THEN

Line 342: IF SQLCODE <> hr_utility.hr_error_number

338:
339: debug_exit(l_proc);
340: EXCEPTION
341: WHEN others THEN
342: IF SQLCODE <> hr_utility.hr_error_number
343: THEN
344: debug_others (l_proc, 10);
345: IF g_debug
346: THEN

Line 504: IF SQLCODE <> hr_utility.hr_error_number

500: debug_exit(l_proc);
501: RETURN TRUE;
502: EXCEPTION
503: WHEN others THEN
504: IF SQLCODE <> hr_utility.hr_error_number
505: THEN
506: debug_others (l_proc, 10);
507: IF g_debug
508: THEN

Line 609: IF SQLCODE <> hr_utility.hr_error_number

605: debug_exit(l_proc);
606: RETURN l_include;
607: EXCEPTION
608: WHEN others THEN
609: IF SQLCODE <> hr_utility.hr_error_number
610: THEN
611: debug_others (l_proc, 10);
612: IF g_debug
613: THEN

Line 887: IF SQLCODE <> hr_utility.hr_error_number

883: debug_exit(l_proc);
884: return l_include;
885: EXCEPTION
886: WHEN others THEN
887: IF SQLCODE <> hr_utility.hr_error_number
888: THEN
889: debug_others (l_proc, 10);
890: IF g_debug
891: THEN

Line 979: IF SQLCODE <> hr_utility.hr_error_number

975: debug_exit(l_proc);
976: return 0;
977: EXCEPTION
978: WHEN others THEN
979: IF SQLCODE <> hr_utility.hr_error_number
980: THEN
981: debug_others (l_proc, 10);
982: IF g_debug
983: THEN

Line 1029: IF SQLCODE <> hr_utility.hr_error_number

1025: debug_exit(l_proc);
1026: return 0;
1027: EXCEPTION
1028: WHEN others THEN
1029: IF SQLCODE <> hr_utility.hr_error_number
1030: THEN
1031: debug_others (l_proc, 10);
1032: IF g_debug
1033: THEN

Line 1107: IF SQLCODE <> hr_utility.hr_error_number

1103: debug_exit(l_proc);
1104: return l_include;
1105: EXCEPTION
1106: WHEN others THEN
1107: IF SQLCODE <> hr_utility.hr_error_number
1108: THEN
1109: debug_others (l_proc, 10);
1110: IF g_debug
1111: THEN

Line 1143: IF SQLCODE <> hr_utility.hr_error_number

1139: debug_exit(l_proc);
1140: return 0;
1141: EXCEPTION
1142: WHEN others THEN
1143: IF SQLCODE <> hr_utility.hr_error_number
1144: THEN
1145: debug_others (l_proc, 10);
1146: IF g_debug
1147: THEN

Line 1176: IF SQLCODE <> hr_utility.hr_error_number

1172: debug_exit(l_proc);
1173: return 0;
1174: EXCEPTION
1175: WHEN others THEN
1176: IF SQLCODE <> hr_utility.hr_error_number
1177: THEN
1178: debug_others (l_proc, 10);
1179: IF g_debug
1180: THEN

Line 1255: IF SQLCODE <> hr_utility.hr_error_number

1251: debug_exit(l_proc);
1252: return l_include;
1253: EXCEPTION
1254: WHEN others THEN
1255: IF SQLCODE <> hr_utility.hr_error_number
1256: THEN
1257: debug_others (l_proc, 10);
1258: IF g_debug
1259: THEN

Line 1288: IF SQLCODE <> hr_utility.hr_error_number

1284: debug_exit(l_proc);
1285: return 'Y';
1286: EXCEPTION
1287: WHEN others THEN
1288: IF SQLCODE <> hr_utility.hr_error_number
1289: THEN
1290: debug_others (l_proc, 10);
1291: IF g_debug
1292: THEN