eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DM_INIT dependencies on BEN_DM_UTILITY

Line 20: ben_dm_utility.r_migration_rec) IS

16: --
17: -- ------------------------------------------------------------------------
18: --
19: PROCEDURE populate_pi_table_i(r_migration_data IN
20: ben_dm_utility.r_migration_rec) IS
21: --
22:
23: --
24: BEGIN

Line 27: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_i', 5);

23: --
24: BEGIN
25: --
26:
27: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_i', 5);
28: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
29:
30: --
31: -- phase specific code to be inserted here

Line 28: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

24: BEGIN
25: --
26:
27: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_i', 5);
28: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
29:
30: --
31: -- phase specific code to be inserted here
32: --

Line 36: ben_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);

32: --
33: -- no code required
34: --
35:
36: ben_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);
37: ben_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);
38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);
39: ben_dm_utility.message('PARA','(none)', 30);
40:

Line 37: ben_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);

33: -- no code required
34: --
35:
36: ben_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);
37: ben_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);
38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);
39: ben_dm_utility.message('PARA','(none)', 30);
40:
41: -- error handling

Line 38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);

34: --
35:
36: ben_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);
37: ben_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);
38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);
39: ben_dm_utility.message('PARA','(none)', 30);
40:
41: -- error handling
42: EXCEPTION

Line 39: ben_dm_utility.message('PARA','(none)', 30);

35:
36: ben_dm_utility.message('INFO','Populate Phase Items table - I phase', 15);
37: ben_dm_utility.message('SUMM','Populate Phase Items table - I phase', 20);
38: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_i', 25);
39: ben_dm_utility.message('PARA','(none)', 30);
40:
41: -- error handling
42: EXCEPTION
43: WHEN OTHERS THEN

Line 44: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_i','(none)',

40:
41: -- error handling
42: EXCEPTION
43: WHEN OTHERS THEN
44: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_i','(none)',
45: 'R');
46: RAISE;
47:
48: --

Line 69: ben_dm_utility.r_migration_rec) IS

65: -- ------------------------------------------------------------------------
66:
67: --
68: PROCEDURE populate_pi_table_g(r_migration_data IN
69: ben_dm_utility.r_migration_rec) IS
70: --
71:
72: l_phase_id NUMBER;
73: l_loader_name VARCHAR2(30);

Line 131: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_g', 5);

127: --
128: BEGIN
129: --
130:
131: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_g', 5);
132: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
133:
134: -- get phase id
135: l_phase_id := ben_dm_utility.get_phase_id('G',

Line 132: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

128: BEGIN
129: --
130:
131: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_g', 5);
132: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
133:
134: -- get phase id
135: l_phase_id := ben_dm_utility.get_phase_id('G',
136: r_migration_data.migration_id);

Line 135: l_phase_id := ben_dm_utility.get_phase_id('G',

131: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_g', 5);
132: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
133:
134: -- get phase id
135: l_phase_id := ben_dm_utility.get_phase_id('G',
136: r_migration_data.migration_id);
137:
138: -- read generator version (Tilak)
139: -- hr_dm_library.get_generator_version(p_generator_version =>

Line 179: ben_dm_utility.message('INFO','Seeding ' || l_table_name, 11);

175: AND (table_name = l_table_name)));
176:
177: COMMIT;
178:
179: ben_dm_utility.message('INFO','Seeding ' || l_table_name, 11);
180:
181: END LOOP;
182: CLOSE csr_select_pi;
183:

Line 184: ben_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);

180:
181: END LOOP;
182: CLOSE csr_select_pi;
183:
184: ben_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);
185: ben_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);
186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);
187: ben_dm_utility.message('PARA','(none)', 30);
188:

Line 185: ben_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);

181: END LOOP;
182: CLOSE csr_select_pi;
183:
184: ben_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);
185: ben_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);
186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);
187: ben_dm_utility.message('PARA','(none)', 30);
188:
189: -- error handling

Line 186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);

182: CLOSE csr_select_pi;
183:
184: ben_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);
185: ben_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);
186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);
187: ben_dm_utility.message('PARA','(none)', 30);
188:
189: -- error handling
190: EXCEPTION

Line 187: ben_dm_utility.message('PARA','(none)', 30);

183:
184: ben_dm_utility.message('INFO','Populate Phase Items table - G phase', 15);
185: ben_dm_utility.message('SUMM','Populate Phase Items table - G phase', 20);
186: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_g', 25);
187: ben_dm_utility.message('PARA','(none)', 30);
188:
189: -- error handling
190: EXCEPTION
191: WHEN OTHERS THEN

Line 192: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_g','(none)',

188:
189: -- error handling
190: EXCEPTION
191: WHEN OTHERS THEN
192: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_g','(none)',
193: 'R');
194: RAISE;
195:
196: --

Line 220: ben_dm_utility.r_migration_rec) IS

216:
217:
218: --
219: PROCEDURE populate_pi_table_dp(r_migration_data IN
220: ben_dm_utility.r_migration_rec) IS
221: --
222:
223: --
224:

Line 238: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_dp', 5);

234: --
235: BEGIN
236: --
237:
238: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_dp', 5);
239: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
240:
241: l_phase_id := ben_dm_utility.get_phase_id('DP',
242: r_migration_data.migration_id);

Line 239: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

235: BEGIN
236: --
237:
238: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_dp', 5);
239: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
240:
241: l_phase_id := ben_dm_utility.get_phase_id('DP',
242: r_migration_data.migration_id);
243:

Line 241: l_phase_id := ben_dm_utility.get_phase_id('DP',

237:
238: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_dp', 5);
239: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
240:
241: l_phase_id := ben_dm_utility.get_phase_id('DP',
242: r_migration_data.migration_id);
243:
244:
245: OPEN csr_select_pi;

Line 284: ben_dm_utility.message('INFO','Seeding ' || l_input_file_id, 11);

280: AND (input_file_id = l_input_file_id)));
281:
282: COMMIT;
283:
284: ben_dm_utility.message('INFO','Seeding ' || l_input_file_id, 11);
285:
286:
287: END LOOP;
288: CLOSE csr_select_pi;

Line 291: ben_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);

287: END LOOP;
288: CLOSE csr_select_pi;
289:
290:
291: ben_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);
292: ben_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);
293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);
294: ben_dm_utility.message('PARA','(none)', 30);
295:

Line 292: ben_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);

288: CLOSE csr_select_pi;
289:
290:
291: ben_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);
292: ben_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);
293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);
294: ben_dm_utility.message('PARA','(none)', 30);
295:
296: -- error handling

Line 293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);

289:
290:
291: ben_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);
292: ben_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);
293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);
294: ben_dm_utility.message('PARA','(none)', 30);
295:
296: -- error handling
297: EXCEPTION

Line 294: ben_dm_utility.message('PARA','(none)', 30);

290:
291: ben_dm_utility.message('INFO','Populate Phase Items table - DP phase', 15);
292: ben_dm_utility.message('SUMM','Populate Phase Items table - DP phase', 20);
293: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table_dp', 25);
294: ben_dm_utility.message('PARA','(none)', 30);
295:
296: -- error handling
297: EXCEPTION
298: WHEN OTHERS THEN

Line 299: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_dp','(none)',

295:
296: -- error handling
297: EXCEPTION
298: WHEN OTHERS THEN
299: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_dp','(none)',
300: 'R');
301: RAISE;
302:
303: --

Line 326: ben_dm_utility.r_migration_rec) IS

322:
323:
324: --
325: PROCEDURE populate_pi_table_up(r_migration_data IN
326: ben_dm_utility.r_migration_rec) IS
327: --
328:
329: l_phase_id NUMBER;
330: l_group_order NUMBER;

Line 342: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_up', 5);

338: --
339: BEGIN
340: --
341:
342: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_up', 5);
343: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
344:
345: l_phase_id := ben_dm_utility.get_phase_id('UP',
346: r_migration_data.migration_id);

Line 343: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

339: BEGIN
340: --
341:
342: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_up', 5);
343: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
344:
345: l_phase_id := ben_dm_utility.get_phase_id('UP',
346: r_migration_data.migration_id);
347:

Line 345: l_phase_id := ben_dm_utility.get_phase_id('UP',

341:
342: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table_up', 5);
343: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
344:
345: l_phase_id := ben_dm_utility.get_phase_id('UP',
346: r_migration_data.migration_id);
347:
348: OPEN csr_select_pi;
349: LOOP

Line 385: ben_dm_utility.message('INFO','Seeding ' || l_group_order, 11);

381: AND (group_order = l_group_order)));
382:
383: COMMIT;
384:
385: ben_dm_utility.message('INFO','Seeding ' || l_group_order, 11);
386:
387: END LOOP;
388: CLOSE csr_select_pi;
389:

Line 393: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_up','(none)',

389:
390: -- error handling
391: EXCEPTION
392: WHEN OTHERS THEN
393: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table_up','(none)',
394: 'R');
395: RAISE;
396:
397: --

Line 419: ben_dm_utility.r_migration_rec,

415:
416:
417: --
418: PROCEDURE populate_pi_table(r_migration_data IN
419: ben_dm_utility.r_migration_rec,
420: p_phase_name IN VARCHAR2) IS
421: --
422:
423: --

Line 427: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table', 5);

423: --
424: BEGIN
425: --
426:
427: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table', 5);
428: ben_dm_utility.message('PARA','(r_migration_data - record' ||
429: ')(p_phase_name - ' || p_phase_name || ')', 10);
430:
431: IF (p_phase_name = 'I') THEN

Line 428: ben_dm_utility.message('PARA','(r_migration_data - record' ||

424: BEGIN
425: --
426:
427: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_pi_table', 5);
428: ben_dm_utility.message('PARA','(r_migration_data - record' ||
429: ')(p_phase_name - ' || p_phase_name || ')', 10);
430:
431: IF (p_phase_name = 'I') THEN
432: populate_pi_table_i(r_migration_data);

Line 441: ben_dm_utility.message('INFO','Populate Phase Items table -' ||

437: ELSIF (p_phase_name = 'UP') THEN
438: populate_pi_table_up(r_migration_data);
439: END IF;
440:
441: ben_dm_utility.message('INFO','Populate Phase Items table -' ||
442: ' calling phase code', 15);
443: ben_dm_utility.message('SUMM','Populate Phase Items table -' ||
444: ' calling phase code', 20);
445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);

Line 443: ben_dm_utility.message('SUMM','Populate Phase Items table -' ||

439: END IF;
440:
441: ben_dm_utility.message('INFO','Populate Phase Items table -' ||
442: ' calling phase code', 15);
443: ben_dm_utility.message('SUMM','Populate Phase Items table -' ||
444: ' calling phase code', 20);
445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);
446: ben_dm_utility.message('PARA','(none)', 30);
447:

Line 445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);

441: ben_dm_utility.message('INFO','Populate Phase Items table -' ||
442: ' calling phase code', 15);
443: ben_dm_utility.message('SUMM','Populate Phase Items table -' ||
444: ' calling phase code', 20);
445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);
446: ben_dm_utility.message('PARA','(none)', 30);
447:
448: -- error handling
449: EXCEPTION

Line 446: ben_dm_utility.message('PARA','(none)', 30);

442: ' calling phase code', 15);
443: ben_dm_utility.message('SUMM','Populate Phase Items table -' ||
444: ' calling phase code', 20);
445: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_pi_table', 25);
446: ben_dm_utility.message('PARA','(none)', 30);
447:
448: -- error handling
449: EXCEPTION
450: WHEN OTHERS THEN

Line 451: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table','(none)','R');

447:
448: -- error handling
449: EXCEPTION
450: WHEN OTHERS THEN
451: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_pi_table','(none)','R');
452: RAISE;
453:
454: --
455: END populate_pi_table;

Line 477: ben_dm_utility.r_migration_rec) IS

473: -- ------------------------------------------------------------------------
474:
475: --
476: PROCEDURE populate_phase_items(r_migration_data IN
477: ben_dm_utility.r_migration_rec) IS
478:
479: --
480:
481: l_search_phase VARCHAR2(30);

Line 497: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phase_items', 5);

493: --
494: BEGIN
495: --
496:
497: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phase_items', 5);
498: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
499:
500: -- seed first phase
501: l_search_phase := 'START';

Line 498: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

494: BEGIN
495: --
496:
497: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phase_items', 5);
498: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
499:
500: -- seed first phase
501: l_search_phase := 'START';
502: l_next_phase := '?';

Line 518: ben_dm_utility.message('INFO','Populate Phase Items table', 15);

514: END IF;
515: l_search_phase := l_phase_name;
516: CLOSE csr_phase_rule;
517: END LOOP;
518: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
519: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);
521: ben_dm_utility.message('PARA','(none)', 30);
522:

Line 519: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);

515: l_search_phase := l_phase_name;
516: CLOSE csr_phase_rule;
517: END LOOP;
518: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
519: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);
521: ben_dm_utility.message('PARA','(none)', 30);
522:
523: -- error handling

Line 520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);

516: CLOSE csr_phase_rule;
517: END LOOP;
518: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
519: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);
521: ben_dm_utility.message('PARA','(none)', 30);
522:
523: -- error handling
524: EXCEPTION

Line 521: ben_dm_utility.message('PARA','(none)', 30);

517: END LOOP;
518: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
519: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
520: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phase_items', 25);
521: ben_dm_utility.message('PARA','(none)', 30);
522:
523: -- error handling
524: EXCEPTION
525: WHEN OTHERS THEN

Line 526: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phase_items',

522:
523: -- error handling
524: EXCEPTION
525: WHEN OTHERS THEN
526: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phase_items',
527: '(none)','R');
528: RAISE;
529:
530: --

Line 551: PROCEDURE populate_p_table(r_migration_data IN ben_dm_utility.r_migration_rec,

547: --
548: -- ------------------------------------------------------------------------
549:
550: --
551: PROCEDURE populate_p_table(r_migration_data IN ben_dm_utility.r_migration_rec,
552: p_phase_name IN VARCHAR2) IS
553: --
554:
555: --

Line 559: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_p_table', 5);

555: --
556: BEGIN
557: --
558:
559: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_p_table', 5);
560: ben_dm_utility.message('PARA','(r_migration_data - record' ||
561: ')(p_phase_name - ' || p_phase_name || ')', 10);
562:
563: INSERT INTO ben_dm_phases (PHASE_ID,

Line 560: ben_dm_utility.message('PARA','(r_migration_data - record' ||

556: BEGIN
557: --
558:
559: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_p_table', 5);
560: ben_dm_utility.message('PARA','(r_migration_data - record' ||
561: ')(p_phase_name - ' || p_phase_name || ')', 10);
562:
563: INSERT INTO ben_dm_phases (PHASE_ID,
564: MIGRATION_ID,

Line 593: ben_dm_utility.message('INFO','Populate Phases table', 15);

589: AND (phase_name = p_phase_name)));
590:
591: COMMIT;
592:
593: ben_dm_utility.message('INFO','Populate Phases table', 15);
594: ben_dm_utility.message('SUMM','Populate Phases table', 20);
595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);
596: ben_dm_utility.message('PARA','(none)', 30);
597:

Line 594: ben_dm_utility.message('SUMM','Populate Phases table', 20);

590:
591: COMMIT;
592:
593: ben_dm_utility.message('INFO','Populate Phases table', 15);
594: ben_dm_utility.message('SUMM','Populate Phases table', 20);
595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);
596: ben_dm_utility.message('PARA','(none)', 30);
597:
598: -- error handling

Line 595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);

591: COMMIT;
592:
593: ben_dm_utility.message('INFO','Populate Phases table', 15);
594: ben_dm_utility.message('SUMM','Populate Phases table', 20);
595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);
596: ben_dm_utility.message('PARA','(none)', 30);
597:
598: -- error handling
599: EXCEPTION

Line 596: ben_dm_utility.message('PARA','(none)', 30);

592:
593: ben_dm_utility.message('INFO','Populate Phases table', 15);
594: ben_dm_utility.message('SUMM','Populate Phases table', 20);
595: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_p_table', 25);
596: ben_dm_utility.message('PARA','(none)', 30);
597:
598: -- error handling
599: EXCEPTION
600: WHEN OTHERS THEN

Line 601: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_p_table','(none)','R');

597:
598: -- error handling
599: EXCEPTION
600: WHEN OTHERS THEN
601: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_p_table','(none)','R');
602: RAISE;
603:
604: --
605: END populate_p_table;

Line 627: ben_dm_utility.r_migration_rec) IS

623: -- ------------------------------------------------------------------------
624:
625: --
626: PROCEDURE populate_phases(r_migration_data IN
627: ben_dm_utility.r_migration_rec) IS
628: --
629:
630: l_phase_name VARCHAR2(30);
631: l_database_location VARCHAR2(30);

Line 645: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phases', 5);

641: --
642: BEGIN
643: --
644:
645: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phases', 5);
646: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
647:
648:
649: OPEN csr_phase_rule;

Line 646: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

642: BEGIN
643: --
644:
645: ben_dm_utility.message('ROUT','entry:ben_dm_init.populate_phases', 5);
646: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
647:
648:
649: OPEN csr_phase_rule;
650: LOOP

Line 657: ben_dm_utility.message('INFO','Populate Phase Items table', 15);

653: populate_p_table(r_migration_data, l_phase_name);
654: END LOOP;
655: CLOSE csr_phase_rule;
656:
657: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
658: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);
660: ben_dm_utility.message('PARA','(none)', 30);
661:

Line 658: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);

654: END LOOP;
655: CLOSE csr_phase_rule;
656:
657: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
658: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);
660: ben_dm_utility.message('PARA','(none)', 30);
661:
662: -- error handling

Line 659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);

655: CLOSE csr_phase_rule;
656:
657: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
658: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);
660: ben_dm_utility.message('PARA','(none)', 30);
661:
662: -- error handling
663: EXCEPTION

Line 660: ben_dm_utility.message('PARA','(none)', 30);

656:
657: ben_dm_utility.message('INFO','Populate Phase Items table', 15);
658: ben_dm_utility.message('SUMM','Populate Phase Items table', 20);
659: ben_dm_utility.message('ROUT','exit:ben_dm_init.populate_phases', 25);
660: ben_dm_utility.message('PARA','(none)', 30);
661:
662: -- error handling
663: EXCEPTION
664: WHEN OTHERS THEN

Line 665: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phases','(none)','R');

661:
662: -- error handling
663: EXCEPTION
664: WHEN OTHERS THEN
665: ben_dm_utility.error(SQLCODE,'ben_dm_init.populate_phases','(none)','R');
666: RAISE;
667:
668: --
669: END populate_phases;

Line 693: PROCEDURE main(r_migration_data IN ben_dm_utility.r_migration_rec) IS

689: --
690: --
691: -- ------------------------------------------------------------------------
692: --
693: PROCEDURE main(r_migration_data IN ben_dm_utility.r_migration_rec) IS
694: --
695:
696: l_current_phase_status VARCHAR2(30);
697:

Line 702: ben_dm_utility.message('ROUT','entry:ben_dm_init.main', 5);

698: --
699: BEGIN
700: --
701:
702: ben_dm_utility.message('ROUT','entry:ben_dm_init.main', 5);
703: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
704:
705:
706: -- get status of initialization phase, is phase completed?

Line 703: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);

699: BEGIN
700: --
701:
702: ben_dm_utility.message('ROUT','entry:ben_dm_init.main', 5);
703: ben_dm_utility.message('PARA','(r_migration_data - record)', 10);
704:
705:
706: -- get status of initialization phase, is phase completed?
707: -- if null returned, then assume it is NS.

Line 708: l_current_phase_status := NVL(ben_dm_utility.get_phase_status('I',

704:
705:
706: -- get status of initialization phase, is phase completed?
707: -- if null returned, then assume it is NS.
708: l_current_phase_status := NVL(ben_dm_utility.get_phase_status('I',
709: r_migration_data.migration_id), 'NS');
710:
711: -- is phase complete?
712: -- if so, skip all processing

Line 716: ben_dm_utility.rollback(p_phase => 'I',

712: -- if so, skip all processing
713: IF (l_current_phase_status <> 'C') THEN
714: -- do we need to explicitly rollback using rollback utility?
715: IF (l_current_phase_status IN('S', 'E')) THEN
716: ben_dm_utility.rollback(p_phase => 'I',
717: p_migration_id => r_migration_data.migration_id);
718: END IF;
719:
720: -- populate phases table

Line 725: ben_dm_utility.update_phases(p_new_status => 'S',

721: populate_phases(r_migration_data);
722:
723:
724: -- update status to started
725: ben_dm_utility.update_phases(p_new_status => 'S',
726: p_id => ben_dm_utility.get_phase_id('I',
727: r_migration_data.migration_id));
728:
729: -- populate phase_items table

Line 726: p_id => ben_dm_utility.get_phase_id('I',

722:
723:
724: -- update status to started
725: ben_dm_utility.update_phases(p_new_status => 'S',
726: p_id => ben_dm_utility.get_phase_id('I',
727: r_migration_data.migration_id));
728:
729: -- populate phase_items table
730: populate_phase_items(r_migration_data);

Line 740: ben_dm_utility.update_phases(p_new_status => 'C',

736: COMMIT;
737: END IF;
738:
739: -- update status to completed
740: ben_dm_utility.update_phases(p_new_status => 'C',
741: p_id => ben_dm_utility.get_phase_id('I',
742: r_migration_data.migration_id));
743:
744: END IF;

Line 741: p_id => ben_dm_utility.get_phase_id('I',

737: END IF;
738:
739: -- update status to completed
740: ben_dm_utility.update_phases(p_new_status => 'C',
741: p_id => ben_dm_utility.get_phase_id('I',
742: r_migration_data.migration_id));
743:
744: END IF;
745:

Line 746: ben_dm_utility.message('INFO','Initialization Phase', 15);

742: r_migration_data.migration_id));
743:
744: END IF;
745:
746: ben_dm_utility.message('INFO','Initialization Phase', 15);
747: ben_dm_utility.message('SUMM','Initialization Phase', 20);
748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);
749: ben_dm_utility.message('PARA','(none)', 30);
750:

Line 747: ben_dm_utility.message('SUMM','Initialization Phase', 20);

743:
744: END IF;
745:
746: ben_dm_utility.message('INFO','Initialization Phase', 15);
747: ben_dm_utility.message('SUMM','Initialization Phase', 20);
748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);
749: ben_dm_utility.message('PARA','(none)', 30);
750:
751: -- error handling

Line 748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);

744: END IF;
745:
746: ben_dm_utility.message('INFO','Initialization Phase', 15);
747: ben_dm_utility.message('SUMM','Initialization Phase', 20);
748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);
749: ben_dm_utility.message('PARA','(none)', 30);
750:
751: -- error handling
752: EXCEPTION

Line 749: ben_dm_utility.message('PARA','(none)', 30);

745:
746: ben_dm_utility.message('INFO','Initialization Phase', 15);
747: ben_dm_utility.message('SUMM','Initialization Phase', 20);
748: ben_dm_utility.message('ROUT','exit:ben_dm_init.main', 25);
749: ben_dm_utility.message('PARA','(none)', 30);
750:
751: -- error handling
752: EXCEPTION
753: WHEN OTHERS THEN

Line 754: ben_dm_utility.error(SQLCODE,'ben_dm_init.main','(none)','R');

750:
751: -- error handling
752: EXCEPTION
753: WHEN OTHERS THEN
754: ben_dm_utility.error(SQLCODE,'ben_dm_init.main','(none)','R');
755: RAISE;
756:
757: --
758: END main;