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

576:
577:
578: EXCEPTION
579: WHEN others THEN
580: IF SQLCODE <> hr_utility.hr_error_number
581: THEN
582: debug_others (l_proc_name, 10);
583: IF g_debug
584: THEN

Line 721: IF SQLCODE <> hr_utility.hr_error_number

717: RETURN 0;
718:
719: EXCEPTION
720: WHEN others THEN
721: IF SQLCODE <> hr_utility.hr_error_number
722: THEN
723: debug_others (l_proc_name, 10);
724: IF g_debug
725: THEN

Line 779: IF SQLCODE <> hr_utility.hr_error_number

775: RETURN 0;
776:
777: EXCEPTION
778: WHEN others THEN
779: IF SQLCODE <> hr_utility.hr_error_number
780: THEN
781: debug_others (l_proc_name, 10);
782: IF g_debug
783: THEN

Line 879: IF SQLCODE <> hr_utility.hr_error_number

875: return 0; -- For Bug 8790100
876:
877: EXCEPTION
878: WHEN others THEN
879: IF SQLCODE <> hr_utility.hr_error_number
880: THEN
881: debug_others (l_proc_name, 10);
882: IF g_debug
883: THEN

Line 991: IF SQLCODE <> hr_utility.hr_error_number

987: return 0;
988:
989: EXCEPTION
990: WHEN others THEN
991: IF SQLCODE <> hr_utility.hr_error_number
992: THEN
993: debug_others (l_proc_name, 10);
994: IF g_debug
995: THEN

Line 1121: IF SQLCODE <> hr_utility.hr_error_number

1117: RETURN 0;
1118:
1119: EXCEPTION
1120: WHEN others THEN
1121: IF SQLCODE <> hr_utility.hr_error_number
1122: THEN
1123: debug_others (l_proc_name, 10);
1124: IF g_debug
1125: THEN

Line 1265: IF SQLCODE <> hr_utility.hr_error_number

1261: RETURN 0;
1262:
1263: EXCEPTION
1264: WHEN others THEN
1265: IF SQLCODE <> hr_utility.hr_error_number
1266: THEN
1267: debug_others (l_proc_name, 10);
1268: IF g_debug
1269: 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 1437: IF SQLCODE <> hr_utility.hr_error_number

1433: RETURN 0;
1434:
1435: EXCEPTION
1436: WHEN others THEN
1437: IF SQLCODE <> hr_utility.hr_error_number
1438: THEN
1439: debug_others (l_proc_name, 10);
1440: IF g_debug
1441: THEN

Line 1740: IF SQLCODE <> hr_utility.hr_error_number

1736:
1737:
1738: EXCEPTION
1739: WHEN others THEN
1740: IF SQLCODE <> hr_utility.hr_error_number
1741: THEN
1742: debug_others (l_proc_name, 10);
1743: IF g_debug
1744: THEN

Line 1782: IF SQLCODE <> hr_utility.hr_error_number

1778: RETURN 'Y';
1779:
1780: EXCEPTION
1781: WHEN others THEN
1782: IF SQLCODE <> hr_utility.hr_error_number
1783: THEN
1784: debug_others (l_proc_name, 10);
1785: IF g_debug
1786: THEN