DBA Data[Home] [Help]

APPS.PQP_GB_PSI_HRS_HISTORY dependencies on HR_UTILITY

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

30: BEGIN
31: --
32: IF pqp_utilities.g_nested_level = 0
33: THEN
34: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
35: END IF;
36:
37: pqp_utilities.debug_enter(p_proc_name => p_proc_name
38: ,p_trace_on => p_trace_on);

Line 60: hr_utility.trace_off;

56: -- so we must turn it off for the same condition
57: -- Also turn off tracing when the override flag of p_trace_off has been passed as Y
58: IF pqp_utilities.g_nested_level = 0
59: THEN
60: hr_utility.trace_off;
61: END IF; -- (g_nested_level = 0
62:
63: --
64: END debug_exit;

Line 125: IF SQLCODE <> hr_utility.hr_error_number

121: END IF;
122: EXCEPTION
123: WHEN OTHERS
124: THEN
125: IF SQLCODE <> hr_utility.hr_error_number
126: THEN
127: debug_others(l_proc_name, l_proc_step);
128:
129: IF g_debug

Line 185: IF SQLCODE <> hr_utility.hr_error_number

181: WHEN OTHERS
182: THEN
183: clear_cache;
184:
185: IF SQLCODE <> hr_utility.hr_error_number
186: THEN
187: debug_others(l_proc_name, l_proc_step);
188:
189: IF g_debug

Line 245: IF SQLCODE <> hr_utility.hr_error_number

241: WHEN OTHERS
242: THEN
243: clear_cache;
244:
245: IF SQLCODE <> hr_utility.hr_error_number
246: THEN
247: debug_others(l_proc_name, l_proc_step);
248:
249: IF g_debug

Line 336: IF SQLCODE <> hr_utility.hr_error_number

332: WHEN OTHERS
333: THEN
334: clear_cache;
335:
336: IF SQLCODE <> hr_utility.hr_error_number
337: THEN
338: debug_others(l_proc_name, l_proc_step);
339:
340: IF g_debug

Line 445: IF SQLCODE <> hr_utility.hr_error_number

441: WHEN OTHERS
442: THEN
443: clear_cache;
444:
445: IF SQLCODE <> hr_utility.hr_error_number
446: THEN
447: debug_others(l_proc_name, l_proc_step);
448:
449: IF g_debug

Line 570: IF SQLCODE <> hr_utility.hr_error_number

566: WHEN OTHERS
567: THEN
568: clear_cache;
569:
570: IF SQLCODE <> hr_utility.hr_error_number
571: THEN
572: debug_others(l_proc_name, l_proc_step);
573:
574: IF g_debug

Line 651: IF SQLCODE <> hr_utility.hr_error_number

647: WHEN OTHERS
648: THEN
649: clear_cache;
650:
651: IF SQLCODE <> hr_utility.hr_error_number
652: THEN
653: debug_others(l_proc_name, l_proc_step);
654:
655: IF g_debug

Line 728: IF SQLCODE <> hr_utility.hr_error_number

724: WHEN OTHERS
725: THEN
726: clear_cache;
727:
728: IF SQLCODE <> hr_utility.hr_error_number
729: THEN
730: debug_others(l_proc_name, l_proc_step);
731:
732: IF g_debug

Line 962: IF SQLCODE <> hr_utility.hr_error_number

958: WHEN OTHERS
959: THEN
960: clear_cache;
961:
962: IF SQLCODE <> hr_utility.hr_error_number
963: THEN
964: debug_others(l_proc_name, l_proc_step);
965:
966: IF g_debug

Line 1068: IF SQLCODE <> hr_utility.hr_error_number

1064: WHEN OTHERS
1065: THEN
1066: clear_cache;
1067:
1068: IF SQLCODE <> hr_utility.hr_error_number
1069: THEN
1070: debug_others(l_proc_name, l_proc_step);
1071:
1072: IF g_debug

Line 1192: IF SQLCODE <> hr_utility.hr_error_number

1188: WHEN OTHERS
1189: THEN
1190: clear_cache;
1191:
1192: IF SQLCODE <> hr_utility.hr_error_number
1193: THEN
1194: debug_others(l_proc_name, l_proc_step);
1195:
1196: IF g_debug

Line 1557: IF SQLCODE <> hr_utility.hr_error_number

1553: WHEN OTHERS
1554: THEN
1555: clear_cache;
1556:
1557: IF SQLCODE <> hr_utility.hr_error_number
1558: THEN
1559: debug_others(l_proc_name, l_proc_step);
1560:
1561: IF g_debug

Line 1712: IF SQLCODE <> hr_utility.hr_error_number

1708: WHEN OTHERS
1709: THEN
1710: clear_cache;
1711:
1712: IF SQLCODE <> hr_utility.hr_error_number
1713: THEN
1714: debug_others(l_proc_name, l_proc_step);
1715:
1716: IF g_debug

Line 1882: IF SQLCODE <> hr_utility.hr_error_number

1878: WHEN OTHERS
1879: THEN
1880: clear_cache;
1881:
1882: IF SQLCODE <> hr_utility.hr_error_number
1883: THEN
1884: debug_others(l_proc_name, l_proc_step);
1885:
1886: IF g_debug

Line 2006: IF SQLCODE <> hr_utility.hr_error_number

2002: WHEN OTHERS
2003: THEN
2004: clear_cache;
2005:
2006: IF SQLCODE <> hr_utility.hr_error_number
2007: THEN
2008: debug_others(l_proc_name, l_proc_step);
2009:
2010: IF g_debug

Line 2059: IF SQLCODE <> hr_utility.hr_error_number

2055: WHEN OTHERS
2056: THEN
2057: clear_cache;
2058:
2059: IF SQLCODE <> hr_utility.hr_error_number
2060: THEN
2061: debug_others(l_proc_name, l_proc_step);
2062:
2063: IF g_debug