APPS.PAY_DYT_USER_COLUMN_INSTA_PKG dependencies on HR_UTILITY

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

72: /* LOCAL VARIABLE DECLARATIONS */
73: L_BUSINESS_GROUP_ID NUMBER;
74: L_LEGISLATION_CODE VARCHAR2(10);
75: BEGIN
76: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_USER_COLUMN_INSTANCES_F_ARD');
77: IF NOT
78: (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
79: RETURN;
80: END IF;

Line 125: HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARD',ABS(SQLCODE));

121: /* PAYROLL SPECIFIC COMPONENT CALLS */
122: --
123: EXCEPTION
124: WHEN OTHERS THEN
125: HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARD',ABS(SQLCODE));
126: RAISE;
127: --
128: END
129: PAY_USER_COLUMN_INSTANCES__ARD;

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

172: L_BUSINESS_GROUP_ID NUMBER;
173: L_LEGISLATION_CODE VARCHAR2(10);
174: BEGIN
175:
176: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_USER_COLUMN_INSTANCES_F_ARI');
177: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
178: RETURN;
179: END IF;
180: /* INITIALISING LOCAL VARIABLES */

Line 221: HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARI',ABS(SQLCODE));

217: /* PAYROLL SPECIFIC COMPONENT CALLS */
218: --
219: EXCEPTION
220: WHEN OTHERS THEN
221: HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARI',ABS(SQLCODE));
222: RAISE;
223: --
224: END PAY_USER_COLUMN_INSTANCES__ARI;
225:

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

273: L_BUSINESS_GROUP_ID NUMBER;
274: L_LEGISLATION_CODE
275: VARCHAR2(10);
276: BEGIN
277: HR_UTILITY.TRACE(' >DYT: EXECUTE PROCEDURE VERSION OF DYNAMIC TRIGGER: PAY_USER_COLUMN_INSTANCES_F_ARU');
278: IF NOT (HR_GENERAL.G_DATA_MIGRATOR_MODE <> 'Y') THEN
279: RETURN;
280: END IF;
281: /* INITIALISING LOCAL VARIABLES */

Line 342: HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARU',ABS(SQLCODE));

338: --
339: EXCEPTION
340: WHEN OTHERS
341: THEN
342: HR_UTILITY.SET_LOCATION('PAY_USER_COLUMN_INSTANCES__ARU',ABS(SQLCODE));
343: RAISE;
344: --
345: END PAY_USER_COLUMN_INSTANCES__ARU;
346:

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

387: --
388: BEGIN
389:
390: --
391: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_INSERT');
392: /* Mechanism for event capture to know whats occurred */
393: l_mode := pay_dyn_triggers.g_dyt_mode;
394: pay_dyn_triggers.g_dyt_mode :=
395: hr_api.g_insert;

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

422:
423: --
424: EXCEPTION
425: WHEN OTHERS THEN
426: hr_utility.set_location('AFTER_INSERT',ABS(SQLCODE));
427: pay_dyn_triggers.g_dyt_mode := l_mode;
428: RAISE;
429: --
430: END AFTER_INSERT;

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

478: --
479: BEGIN
480:
481: --
482: hr_utility.trace(' >DYT: Main entry point from row handler, AFTER_UPDATE');
483: /* Mechanism for event capture to know whats occurred */
484: l_mode := pay_dyn_triggers.g_dyt_mode;
485:
486: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;

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

519:
520: --
521: EXCEPTION
522: WHEN OTHERS THEN
523: hr_utility.set_location('AFTER_UPDATE',ABS(SQLCODE));
524: pay_dyn_triggers.g_dyt_mode := l_mode;
525:
526: RAISE;
527: --

Line 577: hr_utility.trace(' >DYT: Main entry point from row handler,

573: --
574: BEGIN
575:
576: --
577: hr_utility.trace(' >DYT: Main entry point from row handler,
578: AFTER_DELETE');
579: /* Mechanism for event capture to know whats occurred */
580: l_mode := pay_dyn_triggers.g_dyt_mode;
581: pay_dyn_triggers.g_dyt_mode := p_datetrack_mode;

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

612: --
613: EXCEPTION
614: WHEN OTHERS
615: THEN
616: hr_utility.set_location('AFTER_DELETE',ABS(SQLCODE));
617: pay_dyn_triggers.g_dyt_mode := l_mode;
618: RAISE;
619: --
620: END AFTER_DELETE;