DBA Data[Home] [Help]

APPS.HR_DM_BUSINESS dependencies on HR_DM_BUSINESS

Line 1: PACKAGE BODY hr_dm_business AS

1: PACKAGE BODY hr_dm_business AS
2: /* $Header: perdmbiz.pkb 120.0 2005/05/31 17:04:52 appldev noship $ */
3:
4: /*--------------------------- PRIVATE ROUTINES ---------------------------*/
5:

Line 38: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_1_source', 5);

34: --
35: BEGIN
36: --
37:
38: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_1_source', 5);
39: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
40: '(p_valid - ' || p_valid ||
41: ')(p_warning - ' || p_warning || ')', 10);
42:

Line 57: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_1_source', 225);

53:
54:
55: hr_dm_utility.message('INFO','Validated rule 1', 215);
56: hr_dm_utility.message('SUMM','Validated rule 1', 220);
57: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_1_source', 225);
58: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
59: ')(p_warning - ' || p_warning || ')', 230);
60:
61:

Line 65: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_1_source',

61:
62: -- error handling
63: EXCEPTION
64: WHEN OTHERS THEN
65: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_1_source',
66: '(none)','R');
67: RAISE;
68:
69: --

Line 110: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_2_source', 5);

106: --
107: BEGIN
108: --
109:
110: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_2_source', 5);
111: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
112: '(p_valid - ' || p_valid ||
113: ')(p_warning - ' || p_warning || ')', 10);
114:

Line 130: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_2_source', 225);

126: END IF;
127:
128: hr_dm_utility.message('INFO','Validated rule 2', 215);
129: hr_dm_utility.message('SUMM','Validated rule 2', 220);
130: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_2_source', 225);
131: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
132: ')(p_warning - ' || p_warning || ')', 230);
133:
134:

Line 138: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_2_source',

134:
135: -- error handling
136: EXCEPTION
137: WHEN OTHERS THEN
138: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_2_source',
139: '(none)','R');
140: RAISE;
141:
142: --

Line 187: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_8_source', 5);

183: --
184: BEGIN
185: --
186:
187: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_8_source', 5);
188: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
189: '(p_valid - ' || p_valid ||
190: ')(p_warning - ' || p_warning || ')', 10);
191:

Line 214: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_8_source', 225);

210:
211:
212: hr_dm_utility.message('INFO','Validated rule 8', 215);
213: hr_dm_utility.message('SUMM','Validated rule 8', 220);
214: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_8_source', 225);
215: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
216: ')(p_warning - ' || p_warning || ')', 230);
217:
218:

Line 222: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_8_source',

218:
219: -- error handling
220: EXCEPTION
221: WHEN OTHERS THEN
222: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_8_source',
223: '(none)','R');
224: RAISE;
225:
226: --

Line 266: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_9_source', 5);

262: --
263: BEGIN
264: --
265:
266: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_9_source', 5);
267: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
268: '(p_valid - ' || p_valid ||
269: ')(p_warning - ' || p_warning || ')', 10);
270:

Line 286: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_9_source', 225);

282:
283:
284: hr_dm_utility.message('INFO','Validated rule 9', 215);
285: hr_dm_utility.message('SUMM','Validated rule 9', 220);
286: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_9_source', 225);
287: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
288: ')(p_warning - ' || p_warning || ')', 230);
289:
290:

Line 294: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_9_source',

290:
291: -- error handling
292: EXCEPTION
293: WHEN OTHERS THEN
294: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_9_source',
295: '(none)','R');
296: RAISE;
297:
298: --

Line 347: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_10_source', 5);

343: --
344: BEGIN
345: --
346:
347: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_10_source', 5);
348: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
349: '(p_valid - ' || p_valid ||
350: ')(p_warning - ' || p_warning || ')', 10);
351:

Line 380: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_10_source', 225);

376:
377:
378: hr_dm_utility.message('INFO','Validated rule 10', 215);
379: hr_dm_utility.message('SUMM','Validated rule 10', 220);
380: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_10_source', 225);
381: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
382: ')(p_warning - ' || p_warning || ')', 230);
383:
384:

Line 388: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_10_source',

384:
385: -- error handling
386: EXCEPTION
387: WHEN OTHERS THEN
388: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_10_source',
389: '(none)','R');
390: RAISE;
391:
392: --

Line 429: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_1_dest', 5);

425: --
426: BEGIN
427: --
428:
429: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_1_dest', 5);
430: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
431: '(p_valid - ' || p_valid ||
432: ')(p_warning - ' || p_warning || ')', 10);
433:

Line 448: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_1_dest', 225);

444:
445:
446: hr_dm_utility.message('INFO','Validated rule 1', 215);
447: hr_dm_utility.message('SUMM','Validated rule 1', 220);
448: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_1_dest', 225);
449: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
450: ')(p_warning - ' || p_warning || ')', 230);
451:
452:

Line 456: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_1_dest',

452:
453: -- error handling
454: EXCEPTION
455: WHEN OTHERS THEN
456: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_1_dest',
457: '(none)','R');
458: RAISE;
459:
460: --

Line 502: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_2_dest', 5);

498: --
499: BEGIN
500: --
501:
502: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_2_dest', 5);
503: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
504: '(p_valid - ' || p_valid ||
505: ')(p_warning - ' || p_warning || ')', 10);
506:

Line 525: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_2_dest', 225);

521:
522:
523: hr_dm_utility.message('INFO','Validated rule 2', 215);
524: hr_dm_utility.message('SUMM','Validated rule 2', 220);
525: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_2_dest', 225);
526: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
527: ')(p_warning - ' || p_warning || ')', 230);
528:
529:

Line 533: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_2_dest',

529:
530: -- error handling
531: EXCEPTION
532: WHEN OTHERS THEN
533: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_2_dest',
534: '(none)','R');
535: RAISE;
536:
537: --

Line 586: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_6_dest', 5);

582: --
583: BEGIN
584: --
585:
586: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_6_dest', 5);
587: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
588: '(p_valid - ' || p_valid ||
589: ')(p_warning - ' || p_warning || ')', 10);
590:

Line 632: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_7_dest', 225);

628: END IF;
629:
630: hr_dm_utility.message('INFO','Validated rule 6', 215);
631: hr_dm_utility.message('SUMM','Validated rule 6', 220);
632: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_7_dest', 225);
633: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
634: ')(p_warning - ' || p_warning || ')', 230);
635:
636:

Line 640: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_6_dest',

636:
637: -- error handling
638: EXCEPTION
639: WHEN OTHERS THEN
640: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_6_dest',
641: '(none)','R');
642: RAISE;
643:
644: --

Line 692: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_7_dest', 5);

688: --
689: BEGIN
690: --
691:
692: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_7_dest', 5);
693: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
694: '(p_valid - ' || p_valid ||
695: ')(p_warning - ' || p_warning || ')', 10);
696:

Line 720: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_7_dest', 225);

716:
717:
718: hr_dm_utility.message('INFO','Validated rule 7', 215);
719: hr_dm_utility.message('SUMM','Validated rule 7', 220);
720: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_7_dest', 225);
721: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
722: ')(p_warning - ' || p_warning || ')', 230);
723:
724:

Line 728: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_7_dest',

724:
725: -- error handling
726: EXCEPTION
727: WHEN OTHERS THEN
728: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_7_dest',
729: '(none)','R');
730: RAISE;
731:
732: --

Line 779: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_8_dest', 5);

775: --
776: BEGIN
777: --
778:
779: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_8_dest', 5);
780: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
781: '(p_valid - ' || p_valid ||
782: ')(p_warning - ' || p_warning || ')', 10);
783:

Line 798: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_8_dest', 225);

794: END IF;
795:
796: hr_dm_utility.message('INFO','Validated rule 8', 215);
797: hr_dm_utility.message('SUMM','Validated rule 8', 220);
798: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_8_dest', 225);
799: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
800: ')(p_warning - ' || p_warning || ')', 230);
801:
802:

Line 806: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_8_dest',

802:
803: -- error handling
804: EXCEPTION
805: WHEN OTHERS THEN
806: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_8_dest',
807: '(none)','R');
808: RAISE;
809:
810: --

Line 853: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_9_dest', 5);

849: --
850: BEGIN
851: --
852:
853: hr_dm_utility.message('ROUT','entry:hr_dm_business.rule_9_dest', 5);
854: hr_dm_utility.message('PARA','(r_migration_data - record)' ||
855: '(p_valid - ' || p_valid ||
856: ')(p_warning - ' || p_warning || ')', 9);
857:

Line 872: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_9_dest', 225);

868: END IF;
869:
870: hr_dm_utility.message('INFO','Validated rule 9', 215);
871: hr_dm_utility.message('SUMM','Validated rule 9', 220);
872: hr_dm_utility.message('ROUT','exit:hr_dm_business.rule_9_dest', 225);
873: hr_dm_utility.message('PARA','(p_valid - ' || p_valid ||
874: ')(p_warning - ' || p_warning || ')', 230);
875:
876:

Line 880: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_9_dest',

876:
877: -- error handling
878: EXCEPTION
879: WHEN OTHERS THEN
880: hr_dm_utility.error(SQLCODE,'hr_dm_business.rule_9_dest',
881: '(none)','R');
882: RAISE;
883:
884: --

Line 1000: hr_dm_utility.message('ROUT','entry:hr_dm_business.last_migration_date', 5);

996: --
997: BEGIN
998: --
999:
1000: hr_dm_utility.message('ROUT','entry:hr_dm_business.last_migration_date', 5);
1001: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1002:
1003: -- if we are doing an FW / SR migration, then we want to migrate all
1004: -- data, so last migration date is null

Line 1071: hr_dm_utility.message('ROUT','exit:hr_dm_business.last_migration_date', 25);

1067:
1068:
1069: hr_dm_utility.message('INFO','Found last migration date', 15);
1070: hr_dm_utility.message('SUMM','Found last migration date', 20);
1071: hr_dm_utility.message('ROUT','exit:hr_dm_business.last_migration_date', 25);
1072: hr_dm_utility.message('PARA','(l_last_migration_date - ' ||
1073: l_last_migration_date || ')', 30);
1074:
1075:

Line 1082: hr_dm_utility.error(SQLCODE,'hr_dm_business.last_migration_date','(none)',

1078:
1079: -- error handling
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: hr_dm_utility.error(SQLCODE,'hr_dm_business.last_migration_date','(none)',
1083: 'R');
1084: RAISE;
1085:
1086:

Line 1134: hr_dm_utility.message('ROUT','entry:hr_dm_business.validate_migration', 5);

1130: --
1131: BEGIN
1132: --
1133:
1134: hr_dm_utility.message('ROUT','entry:hr_dm_business.validate_migration', 5);
1135: hr_dm_utility.message('PARA','(r_migration_data - record)', 10);
1136:
1137:
1138: -- assume that migration is valid - then test to see if there are problems

Line 1182: hr_dm_utility.message('ROUT','exit:hr_dm_business.validate_migration', 225);

1178: END IF;
1179:
1180: hr_dm_utility.message('INFO','Validated migration', 215);
1181: hr_dm_utility.message('SUMM','Validated migration', 220);
1182: hr_dm_utility.message('ROUT','exit:hr_dm_business.validate_migration', 225);
1183: hr_dm_utility.message('PARA','(l_valid - ' || l_valid || ')', 230);
1184:
1185:
1186: -- overide

Line 1196: hr_dm_utility.error(SQLCODE,'hr_dm_business.validate_migration',

1192:
1193: -- error handling
1194: EXCEPTION
1195: WHEN OTHERS THEN
1196: hr_dm_utility.error(SQLCODE,'hr_dm_business.validate_migration',
1197: '(none)','R');
1198: RAISE;
1199:
1200: --

Line 1207: END hr_dm_business;

1203:
1204:
1205:
1206:
1207: END hr_dm_business;