DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on HR_UTILITY

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

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

Line 76: hr_utility.trace_off;

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

Line 253: IF SQLCODE <> hr_utility.hr_error_number

249:
250: debug_exit(l_proc);
251: EXCEPTION
252: WHEN others THEN
253: IF SQLCODE <> hr_utility.hr_error_number
254: THEN
255: debug_others (l_proc, 10);
256: IF g_debug
257: THEN

Line 306: IF SQLCODE <> hr_utility.hr_error_number

302:
303: debug_exit(l_proc);
304: EXCEPTION
305: WHEN others THEN
306: IF SQLCODE <> hr_utility.hr_error_number
307: THEN
308: debug_others (l_proc, 10);
309: IF g_debug
310: THEN

Line 400: IF SQLCODE <> hr_utility.hr_error_number

396: debug_exit(l_proc);
397: return l_include;
398: EXCEPTION
399: WHEN others THEN
400: IF SQLCODE <> hr_utility.hr_error_number
401: THEN
402: debug_others (l_proc, 10);
403: IF g_debug
404: THEN

Line 596: IF SQLCODE <> hr_utility.hr_error_number

592: debug_exit(l_proc);
593: return l_include;
594: EXCEPTION
595: WHEN others THEN
596: IF SQLCODE <> hr_utility.hr_error_number
597: THEN
598: debug_others (l_proc, 10);
599: IF g_debug
600: THEN

Line 666: IF SQLCODE <> hr_utility.hr_error_number

662: debug_exit(l_proc);
663: return 0;
664: EXCEPTION
665: WHEN others THEN
666: IF SQLCODE <> hr_utility.hr_error_number
667: THEN
668: debug_others (l_proc, 10);
669: IF g_debug
670: THEN

Line 706: IF SQLCODE <> hr_utility.hr_error_number

702: debug_exit(l_proc);
703: return 0;
704: EXCEPTION
705: WHEN others THEN
706: IF SQLCODE <> hr_utility.hr_error_number
707: THEN
708: debug_others (l_proc, 10);
709: IF g_debug
710: THEN

Line 752: IF SQLCODE <> hr_utility.hr_error_number

748: debug_exit(l_proc);
749: return l_error;
750: EXCEPTION
751: WHEN others THEN
752: IF SQLCODE <> hr_utility.hr_error_number
753: THEN
754: debug_others (l_proc, 10);
755: IF g_debug
756: THEN

Line 835: IF SQLCODE <> hr_utility.hr_error_number

831: return 0;
832: ----------------------------------------------
833: EXCEPTION
834: WHEN others THEN
835: IF SQLCODE <> hr_utility.hr_error_number
836: THEN
837: debug_others (l_proc, 10);
838: IF g_debug
839: THEN

Line 957: IF SQLCODE <> hr_utility.hr_error_number

953: debug_exit(l_proc);
954: return 0;
955: EXCEPTION
956: WHEN others THEN
957: IF SQLCODE <> hr_utility.hr_error_number
958: THEN
959: debug_others (l_proc, 10);
960: IF g_debug
961: THEN

Line 1014: IF SQLCODE <> hr_utility.hr_error_number

1010: debug_exit(l_proc);
1011: return l_grade_code;
1012: EXCEPTION
1013: WHEN others THEN
1014: IF SQLCODE <> hr_utility.hr_error_number
1015: THEN
1016: debug_others (l_proc, 10);
1017: IF g_debug
1018: THEN

Line 1265: IF SQLCODE <> hr_utility.hr_error_number

1261: debug_exit(l_proc);
1262: return 0;
1263: EXCEPTION
1264: WHEN others THEN
1265: IF SQLCODE <> hr_utility.hr_error_number
1266: THEN
1267: debug_others (l_proc, 10);
1268: IF g_debug
1269: THEN

Line 1316: IF SQLCODE <> hr_utility.hr_error_number

1312: debug_exit(l_proc);
1313: return l_error;
1314: EXCEPTION
1315: WHEN others THEN
1316: IF SQLCODE <> hr_utility.hr_error_number
1317: THEN
1318: debug_others (l_proc, 10);
1319: IF g_debug
1320: THEN

Line 1395: IF SQLCODE <> hr_utility.hr_error_number

1391: debug_exit(l_proc);
1392: return l_error;
1393: EXCEPTION
1394: WHEN others THEN
1395: IF SQLCODE <> hr_utility.hr_error_number
1396: THEN
1397: debug_others (l_proc, 10);
1398: IF g_debug
1399: THEN

Line 1429: IF SQLCODE <> hr_utility.hr_error_number

1425: debug_exit(l_proc);
1426: return 'Y';
1427: EXCEPTION
1428: WHEN others THEN
1429: IF SQLCODE <> hr_utility.hr_error_number
1430: THEN
1431: debug_others (l_proc, 10);
1432: IF g_debug
1433: THEN