DBA Data[Home] [Help]

APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on HR_UTILITY

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

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

Line 74: hr_utility.trace_off;

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

Line 145: IF SQLCODE <> hr_utility.hr_error_number

141: debug_exit(l_proc_name);
142: END IF;
143: EXCEPTION
144: WHEN others THEN
145: IF SQLCODE <> hr_utility.hr_error_number
146: THEN
147: debug_others (l_proc_name, l_proc_step);
148: IF g_debug
149: THEN

Line 213: IF SQLCODE <> hr_utility.hr_error_number

209: debug_exit(l_proc_name);
210:
211: EXCEPTION
212: WHEN others THEN
213: IF SQLCODE <> hr_utility.hr_error_number
214: THEN
215: debug_others (l_proc_name, 10);
216: IF g_debug
217: THEN

Line 277: IF SQLCODE <> hr_utility.hr_error_number

273:
274: debug_exit(l_proc_name);
275: EXCEPTION
276: WHEN others THEN
277: IF SQLCODE <> hr_utility.hr_error_number
278: THEN
279: debug_others (l_proc_name, 10);
280: IF g_debug
281: THEN

Line 452: IF SQLCODE <> hr_utility.hr_error_number

448: debug_exit(l_proc_name);
449: RETURN l_include;
450: EXCEPTION
451: WHEN others THEN
452: IF SQLCODE <> hr_utility.hr_error_number
453: THEN
454: debug_others (l_proc_name, 10);
455: IF g_debug
456: THEN

Line 732: IF SQLCODE <> hr_utility.hr_error_number

728: RETURN l_return;
729:
730: EXCEPTION
731: WHEN others THEN
732: IF SQLCODE <> hr_utility.hr_error_number
733: THEN
734: debug_others (l_proc_name, 10);
735: IF g_debug
736: THEN

Line 786: IF SQLCODE <> hr_utility.hr_error_number

782: debug_exit(l_proc_name);
783: return 0;
784: EXCEPTION
785: WHEN others THEN
786: IF SQLCODE <> hr_utility.hr_error_number
787: THEN
788: debug_others (l_proc_name, 10);
789: IF g_debug
790: THEN

Line 852: IF SQLCODE <> hr_utility.hr_error_number

848: debug_exit(l_proc_name);
849: return 0;
850: EXCEPTION
851: WHEN others THEN
852: IF SQLCODE <> hr_utility.hr_error_number
853: THEN
854: debug_others (l_proc_name, 10);
855: IF g_debug
856: THEN

Line 893: IF SQLCODE <> hr_utility.hr_error_number

889: debug_exit(l_proc_name);
890: return 0;
891: EXCEPTION
892: WHEN others THEN
893: IF SQLCODE <> hr_utility.hr_error_number
894: THEN
895: debug_others (l_proc_name, 10);
896: IF g_debug
897: THEN

Line 965: IF SQLCODE <> hr_utility.hr_error_number

961: debug_exit(l_proc_name);
962: return 0;
963: EXCEPTION
964: WHEN others THEN
965: IF SQLCODE <> hr_utility.hr_error_number
966: THEN
967: debug_others (l_proc_name, 10);
968: IF g_debug
969: THEN

Line 1020: IF SQLCODE <> hr_utility.hr_error_number

1016: debug_exit(l_proc_name);
1017: return 0;
1018: EXCEPTION
1019: WHEN others THEN
1020: IF SQLCODE <> hr_utility.hr_error_number
1021: THEN
1022: debug_others (l_proc_name, 10);
1023: IF g_debug
1024: THEN

Line 1113: IF SQLCODE <> hr_utility.hr_error_number

1109: debug_exit(l_proc_name);
1110: return 0;
1111: EXCEPTION
1112: WHEN others THEN
1113: IF SQLCODE <> hr_utility.hr_error_number
1114: THEN
1115: debug_others (l_proc_name, 10);
1116: IF g_debug
1117: THEN

Line 1176: IF SQLCODE <> hr_utility.hr_error_number

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

Line 1368: IF SQLCODE <> hr_utility.hr_error_number

1364:
1365:
1366: EXCEPTION
1367: WHEN others THEN
1368: IF SQLCODE <> hr_utility.hr_error_number
1369: THEN
1370: debug_others (l_proc_name, 10);
1371: IF g_debug
1372: THEN

Line 1405: IF SQLCODE <> hr_utility.hr_error_number

1401: RETURN 'Y';
1402:
1403: EXCEPTION
1404: WHEN others THEN
1405: IF SQLCODE <> hr_utility.hr_error_number
1406: THEN
1407: debug_others (l_proc_name, 10);
1408: IF g_debug
1409: THEN