DBA Data[Home] [Help]

APPS.PAY_DYT_ELEMENT_ENTRIES_PKG dependencies on HR_UTILITY

Line 152: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER:

148: /* LOCAL VARIABLE DECLARATIONS */
149: L_BUSINESS_GROUP_ID NUMBER;
150: L_LEGISLATION_CODE VARCHAR2(10);
151: BEGIN
152: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER:
153: PAY_ELEMENT_ENTRIES_F_ARD');
154: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
155: RETURN;
156: END IF;

Line 191: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARD_ARD',ABS(SQLCODE));

187: --
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARD_ARD',ABS(SQLCODE));
192: RAISE;
193: --
194: END PAY_ELEMENT_ENTRIES_F_ARD_ARD;
195:

Line 318: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARI');

314: L_BUSINESS_GROUP_ID NUMBER;
315:
316: L_LEGISLATION_CODE VARCHAR2(10);
317: BEGIN
318: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARI');
319: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
320: RETURN;
321: END IF;
322: /* INITIALISING LOCAL

Line 357: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARI_ARI',ABS(SQLCODE));

353: --
354: EXCEPTION
355: WHEN OTHERS THEN
356:
357: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARI_ARI',ABS(SQLCODE));
358: RAISE;
359: --
360: END PAY_ELEMENT_ENTRIES_F_ARI_ARI;
361:

Line 571: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARU');

567:
568: L_BUSINESS_GROUP_ID NUMBER;
569: L_LEGISLATION_CODE VARCHAR2(10);
570: BEGIN
571: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_ELEMENT_ENTRIES_F_ARU');
572: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
573:
574: RETURN;
575: END IF;

Line 610: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARU_ARU',ABS(SQLCODE));

606: --
607: EXCEPTION
608: WHEN OTHERS THEN
609:
610: HR_UTILITY.SET_LOCATION('PAY_ELEMENT_ENTRIES_F_ARU_ARU',ABS(SQLCODE));
611: RAISE;
612: --
613: END PAY_ELEMENT_ENTRIES_F_ARU_ARU;
614:

Line 739: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_PEE_LOG_ARI');

735: NUMBER;
736: L_EFFECTIVE_START_DATE DATE;
737: L_LEGISLATION_CODE VARCHAR2(30);
738: BEGIN
739: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PQP_PEE_LOG_ARI');
740: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
741: RETURN;
742:
743: END IF;

Line 790: HR_UTILITY.SET_LOCATION('PQP_PEE_LOG_ARI_ARI',ABS(SQLCODE));

786: /* PAYROLL SPECIFIC COMPONENT CALLS */
787: --
788: EXCEPTION
789: WHEN OTHERS THEN
790: HR_UTILITY.SET_LOCATION('PQP_PEE_LOG_ARI_ARI',ABS(SQLCODE));
791: RAISE;
792: --
793: END PQP_PEE_LOG_ARI_ARI;
794:

Line 921: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');

917: --
918: BEGIN
919:
920: --
921: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
922: /* Mechanism for event capture to know whats occurred */
923: l_mode :=
924: pay_dyn_triggers.g_dyt_mode;
925: pay_dyn_triggers.g_dyt_mode := hr_api.g_insert;

Line 1139: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));

1135:
1136: --
1137: EXCEPTION
1138: WHEN OTHERS THEN
1139: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
1140: pay_dyn_triggers.g_dyt_mode := l_mode;
1141: RAISE;
1142: --
1143: END AFTER_INSERT;

Line 1361: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');

1357: --
1358: BEGIN
1359:
1360: --
1361: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
1362: /* Mechanism for event capture to know whats occurred */
1363: l_mode := pay_dyn_triggers.g_dyt_mode;
1364: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1365:

Line 1566: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));

1562:
1563: --
1564: EXCEPTION
1565: WHEN OTHERS THEN
1566: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
1567: pay_dyn_triggers.g_dyt_mode := l_mode;
1568: RAISE;
1569: --
1570: END

Line 1703: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');

1699: --
1700: BEGIN
1701:
1702: --
1703: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_DELETE');
1704: /* Mechanism for event capture to know whats occurred */
1705: l_mode := pay_dyn_triggers.g_dyt_mode;
1706: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;
1707:

Line 1820: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));

1816:
1817: --
1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
1821: pay_dyn_triggers.g_dyt_mode
1822: := l_mode;
1823: RAISE;
1824: --