DBA Data[Home] [Help]

APPS.BEN_DM_BUSINESS dependencies on BEN_DM_BUSINESS

Line 1: PACKAGE BODY ben_dm_business AS

1: PACKAGE BODY ben_dm_business AS
2: /* $Header: benfdmdbiz.pkb 120.0 2006/06/13 14:54:55 nkkrishn noship $ */
3:
4: /*--------------------------- PRIVATE ROUTINES ---------------------------*/
5:

Line 54: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_8_source', 5);

50:
51: BEGIN
52: --
53:
54: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_8_source', 5);
55: ben_dm_utility.message('PARA','(r_migration_data - record)' ||
56: '(p_valid - ' || p_valid ||
57: ')(p_warning - ' || p_warning || ')', 10);
58:

Line 91: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_8_source', 225);

87:
88:
89: ben_dm_utility.message('INFO','Validated rule 8', 215);
90: ben_dm_utility.message('SUMM','Validated rule 8', 220);
91: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_8_source', 225);
92: ben_dm_utility.message('PARA','(p_valid - ' || p_valid ||
93: ')(p_warning - ' || p_warning || ')', 230);
94:
95:

Line 99: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_8_source',

95:
96: -- error handling
97: EXCEPTION
98: WHEN OTHERS THEN
99: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_8_source',
100: '(none)','R');
101: RAISE;
102:
103: --

Line 143: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_9_source', 5);

139: --
140: BEGIN
141: --
142:
143: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_9_source', 5);
144: ben_dm_utility.message('PARA','(r_migration_data - record)' ||
145: '(p_valid - ' || p_valid ||
146: ')(p_warning - ' || p_warning || ')', 10);
147:

Line 163: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_9_source', 225);

159:
160:
161: ben_dm_utility.message('INFO','Validated rule 9', 215);
162: ben_dm_utility.message('SUMM','Validated rule 9', 220);
163: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_9_source', 225);
164: ben_dm_utility.message('PARA','(p_valid - ' || p_valid ||
165: ')(p_warning - ' || p_warning || ')', 230);
166:
167:

Line 171: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_9_source',

167:
168: -- error handling
169: EXCEPTION
170: WHEN OTHERS THEN
171: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_9_source',
172: '(none)','R');
173: RAISE;
174:
175: --

Line 224: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_10_source', 5);

220: --
221: BEGIN
222: --
223:
224: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_10_source', 5);
225: ben_dm_utility.message('PARA','(r_migration_data - record)' ||
226: '(p_valid - ' || p_valid ||
227: ')(p_warning - ' || p_warning || ')', 10);
228:

Line 257: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_10_source', 225);

253:
254:
255: ben_dm_utility.message('INFO','Validated rule 10', 215);
256: ben_dm_utility.message('SUMM','Validated rule 10', 220);
257: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_10_source', 225);
258: ben_dm_utility.message('PARA','(p_valid - ' || p_valid ||
259: ')(p_warning - ' || p_warning || ')', 230);
260:
261:

Line 265: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_10_source',

261:
262: -- error handling
263: EXCEPTION
264: WHEN OTHERS THEN
265: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_10_source',
266: '(none)','R');
267: RAISE;
268:
269: --

Line 322: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_7_dest', 5);

318: --
319: BEGIN
320: --
321:
322: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_7_dest', 5);
323: ben_dm_utility.message('PARA','(r_migration_data - record)' ||
324: '(p_valid - ' || p_valid ||
325: ')(p_warning - ' || p_warning || ')', 10);
326:

Line 359: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_7_dest', 225);

355:
356:
357: ben_dm_utility.message('INFO','Validated rule 7', 215);
358: ben_dm_utility.message('SUMM','Validated rule 7', 220);
359: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_7_dest', 225);
360: ben_dm_utility.message('PARA','(p_valid - ' || p_valid ||
361: ')(p_warning - ' || p_warning || ')', 230);
362:
363:

Line 367: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_7_dest',

363:
364: -- error handling
365: EXCEPTION
366: WHEN OTHERS THEN
367: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_7_dest',
368: '(none)','R');
369: RAISE;
370:
371: --

Line 418: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_8_dest', 5);

414: --
415: BEGIN
416: --
417:
418: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_8_dest', 5);
419: ben_dm_utility.message('PARA','(r_migration_data - record)' ||
420: '(p_valid - ' || p_valid ||
421: ')(p_warning - ' || p_warning || ')', 10);
422:

Line 437: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_8_dest', 225);

433: END IF;
434:
435: ben_dm_utility.message('INFO','Validated rule 8', 215);
436: ben_dm_utility.message('SUMM','Validated rule 8', 220);
437: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_8_dest', 225);
438: ben_dm_utility.message('PARA','(p_valid - ' || p_valid ||
439: ')(p_warning - ' || p_warning || ')', 230);
440:
441:

Line 445: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_8_dest',

441:
442: -- error handling
443: EXCEPTION
444: WHEN OTHERS THEN
445: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_8_dest',
446: '(none)','R');
447: RAISE;
448:
449: --

Line 492: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_9_dest', 5);

488: --
489: BEGIN
490: --
491:
492: ben_dm_utility.message('ROUT','entry:ben_dm_business.rule_9_dest', 5);
493: ben_dm_utility.message('PARA','(r_migration_data - record)' ||
494: '(p_valid - ' || p_valid ||
495: ')(p_warning - ' || p_warning || ')', 9);
496:

Line 511: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_9_dest', 225);

507: END IF;
508:
509: ben_dm_utility.message('INFO','Validated rule 9', 215);
510: ben_dm_utility.message('SUMM','Validated rule 9', 220);
511: ben_dm_utility.message('ROUT','exit:ben_dm_business.rule_9_dest', 225);
512: ben_dm_utility.message('PARA','(p_valid - ' || p_valid ||
513: ')(p_warning - ' || p_warning || ')', 230);
514:
515:

Line 519: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_9_dest',

515:
516: -- error handling
517: EXCEPTION
518: WHEN OTHERS THEN
519: ben_dm_utility.error(SQLCODE,'ben_dm_business.rule_9_dest',
520: '(none)','R');
521: RAISE;
522:
523: --

Line 574: ben_dm_utility.message('ROUT','entry:ben_dm_business.last_migration_date', 5);

570: --
571: BEGIN
572: --
573:
574: ben_dm_utility.message('ROUT','entry:ben_dm_business.last_migration_date', 5);
575: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
576:
577: l_last_migration_date := NULL;
578:

Line 598: ben_dm_utility.message('ROUT','exit:ben_dm_business.last_migration_date', 25);

594: ben_dm_utility.message('INFO','l_last_mig_date - ' || l_last_mig_date, 10);
595: ben_dm_utility.message('INFO','l_last_date - ' || l_last_date, 10);
596: ben_dm_utility.message('INFO','Found last migration date', 15);
597: ben_dm_utility.message('SUMM','Found last migration date', 20);
598: ben_dm_utility.message('ROUT','exit:ben_dm_business.last_migration_date', 25);
599: ben_dm_utility.message('PARA','(l_last_migration_date - ' ||
600: l_last_migration_date || ')', 30);
601:
602:

Line 609: ben_dm_utility.error(SQLCODE,'ben_dm_business.last_migration_date','(none)',

605:
606: -- error handling
607: EXCEPTION
608: WHEN OTHERS THEN
609: ben_dm_utility.error(SQLCODE,'ben_dm_business.last_migration_date','(none)',
610: 'R');
611: RAISE;
612:
613:

Line 655: ben_dm_utility.message('ROUT','entry:ben_dm_business.validate_migration', 5);

651: --
652: BEGIN
653: --
654:
655: ben_dm_utility.message('ROUT','entry:ben_dm_business.validate_migration', 5);
656: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
657:
658:
659: -- assume that migration is valid - then test to see if there are problems

Line 689: ben_dm_utility.message('ROUT','exit:ben_dm_business.validate_migration', 225);

685: END IF;
686:
687: ben_dm_utility.message('INFO','Validated migration', 215);
688: ben_dm_utility.message('SUMM','Validated migration', 220);
689: ben_dm_utility.message('ROUT','exit:ben_dm_business.validate_migration', 225);
690: ben_dm_utility.message('PARA','(l_valid - ' || l_valid || ')', 230);
691:
692:
693: -- overide

Line 703: ben_dm_utility.error(SQLCODE,'ben_dm_business.validate_migration',

699:
700: -- error handling
701: EXCEPTION
702: WHEN OTHERS THEN
703: ben_dm_utility.error(SQLCODE,'ben_dm_business.validate_migration',
704: '(none)','R');
705: RAISE;
706:
707: --

Line 714: END ben_dm_business;

710:
711:
712:
713:
714: END ben_dm_business;