APPS.PQP_GB_PSI_BASIC_DATA 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 147: IF SQLCODE <> hr_utility.hr_error_number

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

Line 273: IF SQLCODE <> hr_utility.hr_error_number

269: debug_exit(l_proc_name);
270:
271: EXCEPTION
272: WHEN others THEN
273: IF SQLCODE <> hr_utility.hr_error_number
274: THEN
275: debug_others (l_proc_name, 10);
276: IF g_debug
277: THEN

Line 393: IF SQLCODE <> hr_utility.hr_error_number

389: return l_return;
390:
391: EXCEPTION
392: WHEN others THEN
393: IF SQLCODE <> hr_utility.hr_error_number
394: THEN
395: debug_others (l_proc_name, 10);
396: IF g_debug
397: THEN

Line 571: IF SQLCODE <> hr_utility.hr_error_number

567:
568:
569: EXCEPTION
570: WHEN others THEN
571: IF SQLCODE <> hr_utility.hr_error_number
572: THEN
573: debug_others (l_proc_name, 10);
574: IF g_debug
575: THEN

Line 740: IF SQLCODE <> hr_utility.hr_error_number

736: RETURN 0;
737:
738: EXCEPTION
739: WHEN others THEN
740: IF SQLCODE <> hr_utility.hr_error_number
741: THEN
742: debug_others (l_proc_name, 10);
743: IF g_debug
744: THEN

Line 800: IF SQLCODE <> hr_utility.hr_error_number

796: RETURN 0;
797:
798: EXCEPTION
799: WHEN others THEN
800: IF SQLCODE <> hr_utility.hr_error_number
801: THEN
802: debug_others (l_proc_name, 10);
803: IF g_debug
804: THEN

Line 862: IF SQLCODE <> hr_utility.hr_error_number

858: debug_exit(l_proc_name);
859:
860: EXCEPTION
861: WHEN others THEN
862: IF SQLCODE <> hr_utility.hr_error_number
863: THEN
864: debug_others (l_proc_name, 10);
865: IF g_debug
866: THEN

Line 922: IF SQLCODE <> hr_utility.hr_error_number

918: return 0;
919:
920: EXCEPTION
921: WHEN others THEN
922: IF SQLCODE <> hr_utility.hr_error_number
923: THEN
924: debug_others (l_proc_name, 10);
925: IF g_debug
926: THEN

Line 1025: IF SQLCODE <> hr_utility.hr_error_number

1021: RETURN 0;
1022:
1023: EXCEPTION
1024: WHEN others THEN
1025: IF SQLCODE <> hr_utility.hr_error_number
1026: THEN
1027: debug_others (l_proc_name, 10);
1028: IF g_debug
1029: THEN

Line 1169: IF SQLCODE <> hr_utility.hr_error_number

1165: RETURN 0;
1166:
1167: EXCEPTION
1168: WHEN others THEN
1169: IF SQLCODE <> hr_utility.hr_error_number
1170: THEN
1171: debug_others (l_proc_name, 10);
1172: IF g_debug
1173: THEN

Line 1239: IF SQLCODE <> hr_utility.hr_error_number

1235: RETURN 0;
1236:
1237: EXCEPTION
1238: WHEN others THEN
1239: IF SQLCODE <> hr_utility.hr_error_number
1240: THEN
1241: debug_others (l_proc_name, 10);
1242: IF g_debug
1243: THEN

Line 1338: IF SQLCODE <> hr_utility.hr_error_number

1334: RETURN 0;
1335:
1336: EXCEPTION
1337: WHEN others THEN
1338: IF SQLCODE <> hr_utility.hr_error_number
1339: THEN
1340: debug_others (l_proc_name, 10);
1341: IF g_debug
1342: THEN

Line 1549: IF SQLCODE <> hr_utility.hr_error_number

1545:
1546:
1547: EXCEPTION
1548: WHEN others THEN
1549: IF SQLCODE <> hr_utility.hr_error_number
1550: THEN
1551: debug_others (l_proc_name, 10);
1552: IF g_debug
1553: THEN

Line 1591: IF SQLCODE <> hr_utility.hr_error_number

1587: RETURN 'Y';
1588:
1589: EXCEPTION
1590: WHEN others THEN
1591: IF SQLCODE <> hr_utility.hr_error_number
1592: THEN
1593: debug_others (l_proc_name, 10);
1594: IF g_debug
1595: THEN