DBA Data[Home] [Help]

APPS.PQP_GB_PSI_STH_HISTORY dependencies on HR_UTILITY

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

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

Line 78: hr_utility.trace_off;

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

Line 247: IF SQLCODE <> hr_utility.hr_error_number

243:
244: debug_exit(l_proc);
245: EXCEPTION
246: WHEN others THEN
247: IF SQLCODE <> hr_utility.hr_error_number
248: THEN
249: debug_others (l_proc, 10);
250: IF g_debug
251: THEN

Line 579: IF SQLCODE <> hr_utility.hr_error_number

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

Line 644: IF SQLCODE <> hr_utility.hr_error_number

640: END IF;
641: debug_exit(l_proc);
642: EXCEPTION
643: WHEN others THEN
644: IF SQLCODE <> hr_utility.hr_error_number
645: THEN
646: debug_others (l_proc, 10);
647: IF g_debug
648: THEN

Line 716: IF SQLCODE <> hr_utility.hr_error_number

712:
713: debug_exit(l_proc);
714: EXCEPTION
715: WHEN others THEN
716: IF SQLCODE <> hr_utility.hr_error_number
717: THEN
718: debug_others (l_proc, 10);
719: IF g_debug
720: THEN

Line 764: IF SQLCODE <> hr_utility.hr_error_number

760: debug('g_business_group_id: '||g_business_group_id,10);
761: debug_exit(l_proc);
762: EXCEPTION
763: WHEN others THEN
764: IF SQLCODE <> hr_utility.hr_error_number
765: THEN
766: debug_others (l_proc, 10);
767: IF g_debug
768: THEN

Line 834: IF SQLCODE <> hr_utility.hr_error_number

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

Line 885: IF SQLCODE <> hr_utility.hr_error_number

881: debug_exit(l_proc);
882: RETURN l_return;
883: EXCEPTION
884: WHEN others THEN
885: IF SQLCODE <> hr_utility.hr_error_number
886: THEN
887: debug_others (l_proc, 10);
888: IF g_debug
889: THEN

Line 952: IF SQLCODE <> hr_utility.hr_error_number

948:
949: debug_exit(l_proc);
950: EXCEPTION
951: WHEN others THEN
952: IF SQLCODE <> hr_utility.hr_error_number
953: THEN
954: debug_others (l_proc, 10);
955: IF g_debug
956: THEN

Line 1222: IF SQLCODE <> hr_utility.hr_error_number

1218: debug_exit(l_proc);
1219: RETURN TRUE;
1220: EXCEPTION
1221: WHEN others THEN
1222: IF SQLCODE <> hr_utility.hr_error_number
1223: THEN
1224: debug_others (l_proc, 10);
1225: IF g_debug
1226: THEN

Line 1397: IF SQLCODE <> hr_utility.hr_error_number

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

Line 1447: IF SQLCODE <> hr_utility.hr_error_number

1443: debug_exit(l_proc);
1444: RETURN l_return;
1445: EXCEPTION
1446: WHEN others THEN
1447: IF SQLCODE <> hr_utility.hr_error_number
1448: THEN
1449: debug_others (l_proc, 10);
1450: IF g_debug
1451: THEN

Line 1497: IF SQLCODE <> hr_utility.hr_error_number

1493: debug_exit(l_proc);
1494: return l_return;
1495: EXCEPTION
1496: WHEN others THEN
1497: IF SQLCODE <> hr_utility.hr_error_number
1498: THEN
1499: debug_others (l_proc, 10);
1500: IF g_debug
1501: THEN

Line 1554: IF SQLCODE <> hr_utility.hr_error_number

1550: debug_exit(l_proc);
1551: return l_return;
1552: EXCEPTION
1553: WHEN others THEN
1554: IF SQLCODE <> hr_utility.hr_error_number
1555: THEN
1556: debug_others (l_proc, 10);
1557: IF g_debug
1558: THEN

Line 1607: IF SQLCODE <> hr_utility.hr_error_number

1603: debug_exit(l_proc);
1604: return l_return;
1605: EXCEPTION
1606: WHEN others THEN
1607: IF SQLCODE <> hr_utility.hr_error_number
1608: THEN
1609: debug_others (l_proc, 10);
1610: IF g_debug
1611: THEN

Line 1648: IF SQLCODE <> hr_utility.hr_error_number

1644: debug_exit(l_proc);
1645: return l_return;
1646: EXCEPTION
1647: WHEN others THEN
1648: IF SQLCODE <> hr_utility.hr_error_number
1649: THEN
1650: debug_others (l_proc, 10);
1651: IF g_debug
1652: THEN

Line 1722: IF SQLCODE <> hr_utility.hr_error_number

1718: debug_exit(l_proc);
1719: return l_return;
1720: EXCEPTION
1721: WHEN others THEN
1722: IF SQLCODE <> hr_utility.hr_error_number
1723: THEN
1724: debug_others (l_proc, 10);
1725: IF g_debug
1726: THEN

Line 1809: IF SQLCODE <> hr_utility.hr_error_number

1805: debug_exit(l_proc);
1806: return l_return;
1807: EXCEPTION
1808: WHEN others THEN
1809: IF SQLCODE <> hr_utility.hr_error_number
1810: THEN
1811: debug_others (l_proc, 10);
1812: IF g_debug
1813: THEN

Line 1852: IF SQLCODE <> hr_utility.hr_error_number

1848: debug_exit(l_proc);
1849: return l_return;
1850: EXCEPTION
1851: WHEN others THEN
1852: IF SQLCODE <> hr_utility.hr_error_number
1853: THEN
1854: debug_others (l_proc, 10);
1855: IF g_debug
1856: THEN

Line 1885: IF SQLCODE <> hr_utility.hr_error_number

1881: debug_exit(l_proc);
1882: return 'Y';
1883: EXCEPTION
1884: WHEN others THEN
1885: IF SQLCODE <> hr_utility.hr_error_number
1886: THEN
1887: debug_others (l_proc, 10);
1888: IF g_debug
1889: THEN