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

504: debug_exit(l_proc);
505: RETURN TRUE;
506: EXCEPTION
507: WHEN others THEN
508: IF SQLCODE <> hr_utility.hr_error_number
509: THEN
510: debug_others (l_proc, 10);
511: IF g_debug
512: THEN

Line 613: IF SQLCODE <> hr_utility.hr_error_number

609: debug_exit(l_proc);
610: RETURN l_include;
611: EXCEPTION
612: WHEN others THEN
613: IF SQLCODE <> hr_utility.hr_error_number
614: THEN
615: debug_others (l_proc, 10);
616: IF g_debug
617: THEN

Line 891: IF SQLCODE <> hr_utility.hr_error_number

887: debug_exit(l_proc);
888: return l_include;
889: EXCEPTION
890: WHEN others THEN
891: IF SQLCODE <> hr_utility.hr_error_number
892: THEN
893: debug_others (l_proc, 10);
894: IF g_debug
895: THEN

Line 983: IF SQLCODE <> hr_utility.hr_error_number

979: debug_exit(l_proc);
980: return 0;
981: EXCEPTION
982: WHEN others THEN
983: IF SQLCODE <> hr_utility.hr_error_number
984: THEN
985: debug_others (l_proc, 10);
986: IF g_debug
987: THEN

Line 1033: IF SQLCODE <> hr_utility.hr_error_number

1029: debug_exit(l_proc);
1030: return 0;
1031: EXCEPTION
1032: WHEN others THEN
1033: IF SQLCODE <> hr_utility.hr_error_number
1034: THEN
1035: debug_others (l_proc, 10);
1036: IF g_debug
1037: THEN

Line 1111: IF SQLCODE <> hr_utility.hr_error_number

1107: debug_exit(l_proc);
1108: return l_include;
1109: EXCEPTION
1110: WHEN others THEN
1111: IF SQLCODE <> hr_utility.hr_error_number
1112: THEN
1113: debug_others (l_proc, 10);
1114: IF g_debug
1115: THEN

Line 1147: IF SQLCODE <> hr_utility.hr_error_number

1143: debug_exit(l_proc);
1144: return 0;
1145: EXCEPTION
1146: WHEN others THEN
1147: IF SQLCODE <> hr_utility.hr_error_number
1148: THEN
1149: debug_others (l_proc, 10);
1150: IF g_debug
1151: THEN

Line 1180: IF SQLCODE <> hr_utility.hr_error_number

1176: debug_exit(l_proc);
1177: return 0;
1178: EXCEPTION
1179: WHEN others THEN
1180: IF SQLCODE <> hr_utility.hr_error_number
1181: THEN
1182: debug_others (l_proc, 10);
1183: IF g_debug
1184: THEN

Line 1259: IF SQLCODE <> hr_utility.hr_error_number

1255: debug_exit(l_proc);
1256: return l_include;
1257: EXCEPTION
1258: WHEN others THEN
1259: IF SQLCODE <> hr_utility.hr_error_number
1260: THEN
1261: debug_others (l_proc, 10);
1262: IF g_debug
1263: THEN

Line 1292: IF SQLCODE <> hr_utility.hr_error_number

1288: debug_exit(l_proc);
1289: return 'Y';
1290: EXCEPTION
1291: WHEN others THEN
1292: IF SQLCODE <> hr_utility.hr_error_number
1293: THEN
1294: debug_others (l_proc, 10);
1295: IF g_debug
1296: THEN