DBA Data[Home] [Help]

APPS.HR_DM_INIT dependencies on HR_DM_INIT

Line 1: PACKAGE BODY hr_dm_init AS

1: PACKAGE BODY hr_dm_init AS
2: /* $Header: perdmini.pkb 115.19 2004/03/24 08:29:10 mmudigon ship $ */
3:
4: -- ------------------------- check_custom_flex ------------------------
5: -- Description: Check if custom flex code use is enabled. This is determined

Line 33: hr_dm_utility.message('ROUT','entry:hr_dm_init.check_custom_flex', 5);

29: --
30: BEGIN
31: --
32:
33: hr_dm_utility.message('ROUT','entry:hr_dm_init.check_custom_flex', 5);
34: hr_dm_utility.message('PARA','(none)', 10);
35:
36: -- read values from pay_action_parameters
37:

Line 53: hr_dm_utility.message('ROUT','exit:hr_dm_init.check_custom_flex', 25);

49:
50:
51: hr_dm_utility.message('INFO','Checked custom flex setting', 15);
52: hr_dm_utility.message('SUMM','Checked custom flex setting', 20);
53: hr_dm_utility.message('ROUT','exit:hr_dm_init.check_custom_flex', 25);
54: hr_dm_utility.message('PARA','(l_retval - ' || l_retval || ')', 30);
55:
56:
57: RETURN(l_retval);

Line 62: hr_dm_utility.error(SQLCODE,'hr_dm_init.check_custom_flex','(none)','R');

58:
59: -- error handling
60: EXCEPTION
61: WHEN OTHERS THEN
62: hr_dm_utility.error(SQLCODE,'hr_dm_init.check_custom_flex','(none)','R');
63: RAISE;
64:
65: --
66: END check_custom_flex;

Line 96: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_i', 5);

92: --
93: BEGIN
94: --
95:
96: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_i', 5);
97: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
98:
99: --
100: -- phase specific code to be inserted here

Line 107: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_i', 25);

103: --
104:
105: hr_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);
106: hr_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);
107: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_i', 25);
108: hr_dm_utility.message('PARA','(none)', 30);
109:
110: -- error handling
111: EXCEPTION

Line 113: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_i','(none)',

109:
110: -- error handling
111: EXCEPTION
112: WHEN OTHERS THEN
113: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_i','(none)',
114: 'R');
115: RAISE;
116:
117: --

Line 246: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_g', 5);

242: --
243: BEGIN
244: --
245:
246: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_g', 5);
247: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
248:
249: -- get phase id
250: l_phase_id := hr_dm_utility.get_phase_id('G',

Line 314: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_g', 25);

310:
311:
312: hr_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);
313: hr_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);
314: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_g', 25);
315: hr_dm_utility.message('PARA','(none)', 30);
316:
317: -- error handling
318: EXCEPTION

Line 320: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_g','(none)',

316:
317: -- error handling
318: EXCEPTION
319: WHEN OTHERS THEN
320: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_g','(none)',
321: 'R');
322: RAISE;
323:
324: --

Line 369: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_r', 5);

365: --
366: BEGIN
367: --
368:
369: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_r', 5);
370: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
371:
372: l_phase_id := hr_dm_utility.get_phase_id('R',
373: r_migration_data.migration_id);

Line 423: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_r', 25);

419: CLOSE csr_select_pi;
420:
421: hr_dm_utility.message('INFO','Populate Phase Items table - R phase', 15);
422: hr_dm_utility.message('SUMM','Populate Phase Items table - R phase', 20);
423: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_r', 25);
424: hr_dm_utility.message('PARA','(none)', 30);
425:
426: -- error handling
427: EXCEPTION

Line 429: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_r','(none)',

425:
426: -- error handling
427: EXCEPTION
428: WHEN OTHERS THEN
429: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_r','(none)',
430: 'R');
431: RAISE;
432:
433: --

Line 467: hr_dm_utility.message('ROUT','entry:hr_dm_init.get_filename', 5);

463: --
464: BEGIN
465: --
466:
467: hr_dm_utility.message('ROUT','entry:hr_dm_init.get_filename', 5);
468: hr_dm_utility.message('PARA','(p_phase_item_id - ' || p_phase_item_id ||
469: ')(p_loader_conc_program - ' || p_loader_conc_program ||
470: ')', 10);
471:

Line 489: hr_dm_utility.message('ROUT','exit:hr_dm_init.get_filename', 25);

485: END IF;
486:
487: hr_dm_utility.message('INFO','Generated filename', 15);
488: hr_dm_utility.message('SUMM','Generated filename', 20);
489: hr_dm_utility.message('ROUT','exit:hr_dm_init.get_filename', 25);
490: hr_dm_utility.message('PARA','(l_filename - ' || l_filename || ')', 30);
491:
492:
493: RETURN(l_filename);

Line 498: hr_dm_utility.error(SQLCODE,'hr_dm_init.get_filename','(none)','R');

494:
495: -- error handling
496: EXCEPTION
497: WHEN OTHERS THEN
498: hr_dm_utility.error(SQLCODE,'hr_dm_init.get_filename','(none)','R');
499: RAISE;
500:
501: --
502: END get_filename;

Line 536: hr_dm_utility.message('ROUT','entry:hr_dm_init.seed_ua_da_data', 5);

532: --
533: BEGIN
534: --
535:
536: hr_dm_utility.message('ROUT','entry:hr_dm_init.seed_ua_da_data', 5);
537: hr_dm_utility.message('PARA','(p_param_rec - record)', 10);
538:
539: hr_dm_utility.message('INFO','Seeding ' || p_param_rec.loader_name , 10);
540:

Line 646: hr_dm_utility.message('ROUT','exit:hr_dm_init.seed_ua_da_data', 25);

642: COMMIT;
643:
644: hr_dm_utility.message('INFO','Seeded UA/DA phase item', 15);
645: hr_dm_utility.message('SUMM','Seeded UA/DA phase item', 20);
646: hr_dm_utility.message('ROUT','exit:hr_dm_init.seed_ua_da_data', 25);
647: hr_dm_utility.message('PARA','(none)', 30);
648:
649: -- error handling
650: EXCEPTION

Line 652: hr_dm_utility.error(SQLCODE,'hr_dm_init.seed_ua_da_data','(none)','R');

648:
649: -- error handling
650: EXCEPTION
651: WHEN OTHERS THEN
652: hr_dm_utility.error(SQLCODE,'hr_dm_init.seed_ua_da_data','(none)','R');
653: RAISE;
654:
655: --
656: END seed_ua_da_data;

Line 688: hr_dm_utility.message('ROUT','entry:hr_dm_init.custom_specified', 5);

684: --
685: BEGIN
686: --
687:
688: hr_dm_utility.message('ROUT','entry:hr_dm_init.custom_specified', 5);
689: hr_dm_utility.message('PARA','(p_check_custom_flex_call - ' ||
690: p_check_custom_flex_call ||
691: ')(r_migration_data - record)' ||
692: '(r_flexfield_rec - record)', 10);

Line 727: hr_dm_utility.message('ROUT','exit:hr_dm_init.custom_specified', 25);

723:
724:
725: hr_dm_utility.message('INFO','Checked custom flex', 15);
726: hr_dm_utility.message('SUMM','Checked custom flex', 20);
727: hr_dm_utility.message('ROUT','exit:hr_dm_init.custom_specified', 25);
728: IF l_retval THEN
729: hr_dm_utility.message('PARA','(l_retval - TRUE)', 30);
730: ELSE
731: hr_dm_utility.message('PARA','(l_retval - FALSE)', 30);

Line 739: hr_dm_utility.error(SQLCODE,'hr_dm_init.custom_specified','(none)','R');

735:
736: -- error handling
737: EXCEPTION
738: WHEN OTHERS THEN
739: hr_dm_utility.error(SQLCODE,'hr_dm_init.custom_specified','(none)','R');
740: RAISE;
741:
742: --
743: END custom_specified;

Line 797: hr_dm_utility.message('ROUT','entry:hr_dm_init.seed_data', 5);

793: --
794: BEGIN
795: --
796:
797: hr_dm_utility.message('ROUT','entry:hr_dm_init.seed_data', 5);
798: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
799: '(r_flexfield_data - record)' ||
800: '(p_phase_id_da - ' || p_phase_id_da ||
801: ')(p_phase_id_ua - ' || p_phase_id_ua ||

Line 888: hr_dm_utility.message('ROUT','exit:hr_dm_init.seed_ua_da_data', 25);

884: p_phase_id_ua);
885:
886: hr_dm_utility.message('INFO','Seeded UA/DA phase item', 15);
887: hr_dm_utility.message('SUMM','Seeded UA/DA phase item', 20);
888: hr_dm_utility.message('ROUT','exit:hr_dm_init.seed_ua_da_data', 25);
889: hr_dm_utility.message('PARA','(none)', 30);
890:
891: -- error handling
892: EXCEPTION

Line 894: hr_dm_utility.error(SQLCODE,'hr_dm_init.seed_data','(none)','R');

890:
891: -- error handling
892: EXCEPTION
893: WHEN OTHERS THEN
894: hr_dm_utility.error(SQLCODE,'hr_dm_init.seed_data','(none)','R');
895: RAISE;
896:
897: --
898: END seed_data;

Line 1019: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_da', 5);

1015: --
1016: BEGIN
1017: --
1018:
1019: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_da', 5);
1020: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1021:
1022: l_phase_id_da := hr_dm_utility.get_phase_id('DA',
1023: r_migration_data.migration_id);

Line 1162: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_da', 25);

1158: END IF;
1159:
1160: hr_dm_utility.message('INFO','Populate Phase Items table - DA phase', 15);
1161: hr_dm_utility.message('SUMM','Populate Phase Items table - DA phase', 20);
1162: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_da', 25);
1163: hr_dm_utility.message('PARA','(none)', 30);
1164:
1165: -- error handling
1166: EXCEPTION

Line 1168: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_da','(none)',

1164:
1165: -- error handling
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_da','(none)',
1169: 'R');
1170: RAISE;
1171:
1172: --

Line 1227: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_dp', 5);

1223: --
1224: BEGIN
1225: --
1226:
1227: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_dp', 5);
1228: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1229:
1230: l_phase_id := hr_dm_utility.get_phase_id('DP',
1231: r_migration_data.migration_id);

Line 1308: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_dp', 25);

1304:
1305:
1306: hr_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);
1307: hr_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);
1308: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_dp', 25);
1309: hr_dm_utility.message('PARA','(none)', 30);
1310:
1311: -- error handling
1312: EXCEPTION

Line 1314: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_dp','(none)',

1310:
1311: -- error handling
1312: EXCEPTION
1313: WHEN OTHERS THEN
1314: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_dp','(none)',
1315: 'R');
1316: RAISE;
1317:
1318: --

Line 1347: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_cp', 5);

1343: --
1344: BEGIN
1345: --
1346:
1347: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_cp', 5);
1348: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1349:
1350: --
1351: -- phase specific code to be inserted here

Line 1360: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_cp', 25);

1356: --
1357:
1358: hr_dm_utility.message('INFO','Populate Phase Items table - CP phase', 15);
1359: hr_dm_utility.message('SUMM','Populate Phase Items table - CP phase', 20);
1360: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_cp', 25);
1361: hr_dm_utility.message('PARA','(none)', 30);
1362:
1363: -- error handling
1364: EXCEPTION

Line 1366: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_cp','(none)',

1362:
1363: -- error handling
1364: EXCEPTION
1365: WHEN OTHERS THEN
1366: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_cp','(none)',
1367: 'R');
1368: RAISE;
1369:
1370: --

Line 1433: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_up', 5);

1429: --
1430: BEGIN
1431: --
1432:
1433: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_up', 5);
1434: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1435:
1436: l_phase_id := hr_dm_utility.get_phase_id('UP',
1437: r_migration_data.migration_id);

Line 1535: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_up', 25);

1531:
1532:
1533: hr_dm_utility.message('INFO','Populate Phase Items table - UP phase', 15);
1534: hr_dm_utility.message('SUMM','Populate Phase Items table - UP phase', 20);
1535: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_up', 25);
1536: hr_dm_utility.message('PARA','(none)', 30);
1537:
1538: -- error handling
1539: EXCEPTION

Line 1541: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_up','(none)',

1537:
1538: -- error handling
1539: EXCEPTION
1540: WHEN OTHERS THEN
1541: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_up','(none)',
1542: 'R');
1543: RAISE;
1544:
1545: --

Line 1602: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_ua', 5);

1598: --
1599: BEGIN
1600: --
1601:
1602: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_ua', 5);
1603: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1604:
1605: l_phase_id := hr_dm_utility.get_phase_id('UA',
1606: r_migration_data.migration_id);

Line 1615: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_ua', 25);

1611:
1612:
1613: hr_dm_utility.message('INFO','Populate Phase Items table - UA phase', 15);
1614: hr_dm_utility.message('SUMM','Populate Phase Items table - UA phase', 20);
1615: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_ua', 25);
1616: hr_dm_utility.message('PARA','(none)', 30);
1617:
1618: -- error handling
1619: EXCEPTION

Line 1621: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_ua','(none)',

1617:
1618: -- error handling
1619: EXCEPTION
1620: WHEN OTHERS THEN
1621: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_ua','(none)',
1622: 'R');
1623: RAISE;
1624:
1625:

Line 1670: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_d', 5);

1666: --
1667: BEGIN
1668: --
1669:
1670: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_d', 5);
1671: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1672:
1673: l_phase_id := hr_dm_utility.get_phase_id('D',
1674: r_migration_data.migration_id);

Line 1726: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_d', 25);

1722:
1723:
1724: hr_dm_utility.message('INFO','Populate Phase Items table - D phase', 15);
1725: hr_dm_utility.message('SUMM','Populate Phase Items table - D phase', 20);
1726: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_d', 25);
1727: hr_dm_utility.message('PARA','(none)', 30);
1728:
1729: -- error handling
1730: EXCEPTION

Line 1732: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_d','(none)',

1728:
1729: -- error handling
1730: EXCEPTION
1731: WHEN OTHERS THEN
1732: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_d','(none)',
1733: 'R');
1734: RAISE;
1735:
1736: --

Line 1792: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_c', 5);

1788: --
1789: BEGIN
1790: --
1791:
1792: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table_c', 5);
1793: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1794:
1795: l_phase_id := hr_dm_utility.get_phase_id('C',
1796: r_migration_data.migration_id);

Line 1849: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_c', 25);

1845:
1846:
1847: hr_dm_utility.message('INFO','Populate Phase Items table - C phase', 15);
1848: hr_dm_utility.message('SUMM','Populate Phase Items table - C phase', 20);
1849: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table_c', 25);
1850: hr_dm_utility.message('PARA','(none)', 30);
1851:
1852: -- error handling
1853: EXCEPTION

Line 1855: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_c','(none)'

1851:
1852: -- error handling
1853: EXCEPTION
1854: WHEN OTHERS THEN
1855: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table_c','(none)'
1856: ,'R');
1857: RAISE;
1858:
1859: --

Line 1891: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table', 5);

1887: --
1888: BEGIN
1889: --
1890:
1891: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_pi_table', 5);
1892: hr_dm_utility.message('PARA','(r_migration_data - record' ||
1893: ')(p_phase_name - ' || p_phase_name || ')', 10);
1894:
1895: IF (p_phase_name = 'I') THEN

Line 1921: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table', 25);

1917: hr_dm_utility.message('INFO','Populate Phase Items table -' ||
1918: ' calling phase code', 15);
1919: hr_dm_utility.message('SUMM','Populate Phase Items table -' ||
1920: ' calling phase code', 20);
1921: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_pi_table', 25);
1922: hr_dm_utility.message('PARA','(none)', 30);
1923:
1924: -- error handling
1925: EXCEPTION

Line 1927: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table','(none)','R');

1923:
1924: -- error handling
1925: EXCEPTION
1926: WHEN OTHERS THEN
1927: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_pi_table','(none)','R');
1928: RAISE;
1929:
1930: --
1931: END populate_pi_table;

Line 1974: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_phase_items', 5);

1970: --
1971: BEGIN
1972: --
1973:
1974: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_phase_items', 5);
1975: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1976:
1977: -- seed first phase
1978: l_search_phase := 'START';

Line 1998: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_phase_items', 25);

1994: END LOOP;
1995:
1996: hr_dm_utility.message('INFO','Populate Phase Items table', 15);
1997: hr_dm_utility.message('SUMM','Populate Phase Items table', 20);
1998: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_phase_items', 25);
1999: hr_dm_utility.message('PARA','(none)', 30);
2000:
2001: -- error handling
2002: EXCEPTION

Line 2004: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_phase_items',

2000:
2001: -- error handling
2002: EXCEPTION
2003: WHEN OTHERS THEN
2004: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_phase_items',
2005: '(none)','R');
2006: RAISE;
2007:
2008: --

Line 2037: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_p_table', 5);

2033: --
2034: BEGIN
2035: --
2036:
2037: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_p_table', 5);
2038: hr_dm_utility.message('PARA','(r_migration_data - record' ||
2039: ')(p_phase_name - ' || p_phase_name || ')', 10);
2040:
2041: INSERT INTO hr_dm_phases (PHASE_ID,

Line 2073: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_p_table', 25);

2069: COMMIT;
2070:
2071: hr_dm_utility.message('INFO','Populate Phases table', 15);
2072: hr_dm_utility.message('SUMM','Populate Phases table', 20);
2073: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_p_table', 25);
2074: hr_dm_utility.message('PARA','(none)', 30);
2075:
2076: -- error handling
2077: EXCEPTION

Line 2079: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_p_table','(none)','R');

2075:
2076: -- error handling
2077: EXCEPTION
2078: WHEN OTHERS THEN
2079: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_p_table','(none)','R');
2080: RAISE;
2081:
2082: --
2083: END populate_p_table;

Line 2122: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_phases', 5);

2118: --
2119: BEGIN
2120: --
2121:
2122: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_phases', 5);
2123: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
2124:
2125:
2126: OPEN csr_phase_rule;

Line 2136: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_phases', 25);

2132: CLOSE csr_phase_rule;
2133:
2134: hr_dm_utility.message('INFO','Populate Phase Items table', 15);
2135: hr_dm_utility.message('SUMM','Populate Phase Items table', 20);
2136: hr_dm_utility.message('ROUT','exit:hr_dm_init.populate_phases', 25);
2137: hr_dm_utility.message('PARA','(none)', 30);
2138:
2139: -- error handling
2140: EXCEPTION

Line 2142: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_phases','(none)','R');

2138:
2139: -- error handling
2140: EXCEPTION
2141: WHEN OTHERS THEN
2142: hr_dm_utility.error(SQLCODE,'hr_dm_init.populate_phases','(none)','R');
2143: RAISE;
2144:
2145: --
2146: END populate_phases;

Line 2180: hr_dm_utility.message('ROUT','entry:hr_dm_init.main', 5);

2176: --
2177: BEGIN
2178: --
2179:
2180: hr_dm_utility.message('ROUT','entry:hr_dm_init.main', 5);
2181: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
2182:
2183:
2184: -- get status of initialization phase, is phase completed?

Line 2228: hr_dm_utility.message('ROUT','exit:hr_dm_init.main', 25);

2224:
2225:
2226: hr_dm_utility.message('INFO','Initialization Phase', 15);
2227: hr_dm_utility.message('SUMM','Initialization Phase', 20);
2228: hr_dm_utility.message('ROUT','exit:hr_dm_init.main', 25);
2229: hr_dm_utility.message('PARA','(none)', 30);
2230:
2231: -- error handling
2232: EXCEPTION

Line 2234: hr_dm_utility.error(SQLCODE,'hr_dm_init.main','(none)','R');

2230:
2231: -- error handling
2232: EXCEPTION
2233: WHEN OTHERS THEN
2234: hr_dm_utility.error(SQLCODE,'hr_dm_init.main','(none)','R');
2235: RAISE;
2236:
2237: --
2238: END main;

Line 2243: END hr_dm_init;

2239: --
2240:
2241:
2242:
2243: END hr_dm_init;