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_UTILITY dependencies on BEN_DM_UTILITY

Line 1: PACKAGE BODY ben_dm_utility AS

1: PACKAGE BODY ben_dm_utility AS
2: /* $Header: benfdmutil.pkb 120.0 2006/05/11 05:04:12 nkkrishn noship $ */
3:
4: /*--------------------------- GLOBAL VARIABLES ----------------------------*/
5:

Line 60: message('ROUT','entry:ben_dm_utility.number_of_threads', 5);

56: --
57: BEGIN
58: --
59:
60: message('ROUT','entry:ben_dm_utility.number_of_threads', 5);
61: message('PARA','(p_business_group_id - ' || p_business_group_id || ')', 10);
62:
63:
64: OPEN csr_threads;

Line 87: message('ROUT','exit:ben_dm_utility.number_of_threads', 25);

83: END IF;
84:
85: message('INFO','Found number of threads', 15);
86: message('SUMM','Found number of threads', 20);
87: message('ROUT','exit:ben_dm_utility.number_of_threads', 25);
88: message('PARA','(l_threads - ' || l_threads || ')', 30);
89:
90:
91: RETURN(l_threads);

Line 96: -- error(SQLCODE,'ben_dm_utility.number_of_threads','(none)','R');

92:
93: -- error handling
94: EXCEPTION
95: WHEN OTHERS THEN
96: -- error(SQLCODE,'ben_dm_utility.number_of_threads','(none)','R');
97: RAISE;
98:
99: --
100: END number_of_threads;

Line 141: message('ROUT','entry:ben_dm_utility.get_phase_status', 5);

137: --
138: BEGIN
139: --
140:
141: message('ROUT','entry:ben_dm_utility.get_phase_status', 5);
142: message('PARA','(p_phase - ' || p_phase ||
143: ')(p_migration_id - ' || p_migration_id || ')', 10);
144:
145: OPEN csr_status;

Line 158: message('ROUT','exit:ben_dm_utility.get_phase_status', 25);

154:
155:
156: message('INFO','Find Phase Status', 15);
157: message('SUMM','Find Phase Status', 20);
158: message('ROUT','exit:ben_dm_utility.get_phase_status', 25);
159: message('PARA','(l_phase_status - ' || l_phase_status || ')', 30);
160:
161: RETURN(l_phase_status);
162:

Line 166: error(SQLCODE,'ben_dm_utility.get_phase_status','(none)','R');

162:
163: -- error handling
164: EXCEPTION
165: WHEN OTHERS THEN
166: error(SQLCODE,'ben_dm_utility.get_phase_status','(none)','R');
167: RAISE;
168:
169: --
170: END get_phase_status;

Line 212: message('ROUT','entry:ben_dm_utility.get_phase_id', 5);

208: --
209: BEGIN
210: --
211:
212: message('ROUT','entry:ben_dm_utility.get_phase_id', 5);
213: message('PARA','(p_phase - ' || p_phase ||
214: ')(p_migration_id - ' || p_migration_id || ')', 10);
215:
216:

Line 227: message('ROUT','exit:ben_dm_utility.get_phase_id', 25);

223:
224:
225: message('INFO','Find Phase ID', 15);
226: message('SUMM','Find Phase ID', 20);
227: message('ROUT','exit:ben_dm_utility.get_phase_id', 25);
228: message('PARA','(l_phase_id - ' || l_phase_id || ')', 30);
229:
230: RETURN(l_phase_id);
231:

Line 235: error(SQLCODE,'ben_dm_utility.get_phase_id','(none)','R');

231:
232: -- error handling
233: EXCEPTION
234: WHEN OTHERS THEN
235: error(SQLCODE,'ben_dm_utility.get_phase_id','(none)','R');
236: RAISE;
237:
238: --
239: END get_phase_id;

Line 278: message('ROUT','entry:ben_dm_utility.error', 5);

274: --
275: BEGIN
276: --
277:
278: message('ROUT','entry:ben_dm_utility.error', 5);
279: message('PARA','(p_sqlcode - ' || p_sqlcode ||
280: ')(p_procedure - ' || p_procedure || ')', 10);
281:
282: message('FAIL',p_sqlcode || ':' || SQLERRM(p_sqlcode) || ':'

Line 294: message('ROUT','exit:ben_dm_utility.error', 30);

290: END IF;
291:
292: message('INFO','Error Handler - ' || p_procedure, 20);
293: message('SUMM','Error Handler - ' || p_procedure, 25);
294: message('ROUT','exit:ben_dm_utility.error', 30);
295: message('PARA','(none)', 35);
296:
297: -- error handling
298: EXCEPTION

Line 300: error(SQLCODE,'ben_dm_utility.error','(none)','R');

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

Line 375: error(SQLCODE,'ben_dm_utility.message_init','(none)','R');

371:
372: -- error handling
373: EXCEPTION
374: WHEN OTHERS THEN
375: error(SQLCODE,'ben_dm_utility.message_init','(none)','R');
376: RAISE;
377:
378: --
379: END message_init;

Line 462: error(SQLCODE,'ben_dm_utility.message','(none)','R');

458:
459: -- error handling
460: EXCEPTION
461: WHEN OTHERS THEN
462: error(SQLCODE,'ben_dm_utility.message','(none)','R');
463: RAISE;
464:
465: --
466: END message;

Line 511: message('ROUT','entry:ben_dm_utility.update_migrations', 5);

507: --
508: BEGIN
509: --
510:
511: message('ROUT','entry:ben_dm_utility.update_migrations', 5);
512: message('PARA','(p_new_status - ' || p_new_status ||
513: ')(p_id - ' || p_id || ')', 10);
514:
515: -- set start date for 'S'

Line 552: message('ROUT','exit:ben_dm_utility.update_migrations', 25);

548: END IF;
549:
550: message('INFO','Update status - update_migrations', 15);
551: message('SUMM','Update status - update_migrations', 20);
552: message('ROUT','exit:ben_dm_utility.update_migrations', 25);
553: message('PARA','(none)', 30);
554:
555: -- error handling
556: EXCEPTION

Line 558: error(SQLCODE,'ben_dm_utility.update_migrations','(none)','R');

554:
555: -- error handling
556: EXCEPTION
557: WHEN OTHERS THEN
558: error(SQLCODE,'ben_dm_utility.update_migrations','(none)','R');
559: RAISE;
560:
561: --
562: END update_migrations;

Line 604: message('ROUT','entry:ben_dm_utility.update_phase_items', 5);

600: --
601: BEGIN
602: --
603:
604: message('ROUT','entry:ben_dm_utility.update_phase_items', 5);
605: message('PARA','(p_new_status - ' || p_new_status ||
606: ')(p_id - ' || p_id || ')', 10);
607:
608: -- set start time for 'S'

Line 636: message('ROUT','exit:ben_dm_utility.update_phase_items', 25);

632: END IF;
633:
634: message('INFO','Update status - update_phase_items', 15);
635: message('SUMM','Update status - update_phase_items', 20);
636: message('ROUT','exit:ben_dm_utility.update_phase_items', 25);
637: message('PARA','(none)', 30);
638:
639: -- error handling
640: EXCEPTION

Line 642: error(SQLCODE,'ben_dm_utility.update_phase_items','(none)','R');

638:
639: -- error handling
640: EXCEPTION
641: WHEN OTHERS THEN
642: error(SQLCODE,'ben_dm_utility.update_phase_items','(none)','R');
643: RAISE;
644:
645: --
646: END update_phase_items;

Line 698: message('ROUT','entry:ben_dm_utility.update_phases', 5);

694: --
695: BEGIN
696: --
697:
698: message('ROUT','entry:ben_dm_utility.update_phases', 5);
699: message('PARA','(p_new_status - ' || p_new_status ||
700: ')(p_id - ' || p_id || ')', 10);
701:
702: l_new_status := p_new_status;

Line 752: message('ROUT','exit:ben_dm_utility.update_phases', 25);

748:
749:
750: message('INFO','Update status - update_phases', 15);
751: message('SUMM','Update status - update_phases', 20);
752: message('ROUT','exit:ben_dm_utility.update_phases', 25);
753: message('PARA','(none)', 30);
754:
755: -- error handling
756: EXCEPTION

Line 758: error(SQLCODE,'ben_dm_utility.update_phases','(none)','R');

754:
755: -- error handling
756: EXCEPTION
757: WHEN OTHERS THEN
758: error(SQLCODE,'ben_dm_utility.update_phases','(none)','R');
759: RAISE;
760:
761: --
762: END update_phases;

Line 797: message('ROUT','entry:ben_dm_utility.rollback', 5);

793: --
794: BEGIN
795: --
796:
797: message('ROUT','entry:ben_dm_utility.rollback', 5);
798: message('PARA','(p_phase - ' || p_phase ||
799: ')(p_masterslave - ' || p_masterslave || ')', 10);
800:
801: -- what type of rollback?

Line 828: message('ROUT','exit:ben_dm_utility.rollback', 25);

824:
825:
826: message('INFO','Rollback', 15);
827: message('SUMM','Rollback', 20);
828: message('ROUT','exit:ben_dm_utility.rollback', 25);
829: message('PARA','(none)', 30);
830:
831: -- error handling
832: EXCEPTION

Line 834: error(SQLCODE,'ben_dm_utility.rollback','(none)','R');

830:
831: -- error handling
832: EXCEPTION
833: WHEN OTHERS THEN
834: error(SQLCODE,'ben_dm_utility.rollback','(none)','R');
835: RAISE;
836: --
837: END rollback;
838: --

Line 877: message('ROUT','entry:ben_dm_utility.rollback_download_master', 5);

873: --
874: BEGIN
875: --
876:
877: message('ROUT','entry:ben_dm_utility.rollback_download_master', 5);
878: message('PARA','(p_migration_id - ' || p_migration_id || ')', 10);
879:
880: -- find the DP phase id
881: l_phase_id := get_phase_id('DP', p_migration_id);

Line 905: message('ROUT','exit:ben_dm_utility.rollback_download_master', 25);

901: CLOSE csr_c1;
902:
903: message('INFO','Rollback', 15);
904: message('SUMM','Rollback', 20);
905: message('ROUT','exit:ben_dm_utility.rollback_download_master', 25);
906: message('PARA','(none)', 30);
907:
908: -- error handling
909: EXCEPTION

Line 911: error(SQLCODE,'ben_dm_utility.rollback_download_master','(none)','R');

907:
908: -- error handling
909: EXCEPTION
910: WHEN OTHERS THEN
911: error(SQLCODE,'ben_dm_utility.rollback_download_master','(none)','R');
912: RAISE;
913: --
914: END rollback_download_master;
915: --

Line 949: message('ROUT','entry:ben_dm_utility.rollback_init', 5);

945: --
946: BEGIN
947: --
948:
949: message('ROUT','entry:ben_dm_utility.rollback_init', 5);
950: message('PARA','(p_migration_id - ' || p_migration_id || ')', 10);
951:
952: -- find all init phases for this migration that are started or in error
953: OPEN csr_c1;

Line 974: message('ROUT','exit:ben_dm_utility.rollback_init', 25);

970:
971:
972: message('INFO','Rollback - init', 15);
973: message('SUMM','Rollback - init', 20);
974: message('ROUT','exit:ben_dm_utility.rollback_init', 25);
975: message('PARA','(none)', 30);
976:
977: -- error handling
978: EXCEPTION

Line 980: error(SQLCODE,'ben_dm_utility.rollback_init','(none)','R');

976:
977: -- error handling
978: EXCEPTION
979: WHEN OTHERS THEN
980: error(SQLCODE,'ben_dm_utility.rollback_init','(none)','R');
981: RAISE;
982: --
983: END rollback_init;
984: --

Line 1021: message('ROUT','entry:ben_dm_utility.rollback_generator', 5);

1017: --
1018: BEGIN
1019: --
1020:
1021: message('ROUT','entry:ben_dm_utility.rollback_generator', 5);
1022: message('PARA','(p_migration_id - ' || p_migration_id || ')', 10);
1023:
1024: -- find all generator phases for this migration that are started or in error
1025: OPEN csr_c1;

Line 1036: message('ROUT','exit:ben_dm_utility.rollback_generator', 25);

1032: CLOSE csr_c1;
1033:
1034: message('INFO','Rollback - generator', 15);
1035: message('SUMM','Rollback - generator', 20);
1036: message('ROUT','exit:ben_dm_utility.rollback_generator', 25);
1037: message('PARA','(none)', 30);
1038:
1039: -- error handling
1040: EXCEPTION

Line 1042: error(SQLCODE,'ben_dm_utility.rollback_generator','(none)','R');

1038:
1039: -- error handling
1040: EXCEPTION
1041: WHEN OTHERS THEN
1042: error(SQLCODE,'ben_dm_utility.rollback_generator','(none)','R');
1043: RAISE;
1044: --
1045: END rollback_generator;
1046: --

Line 1102: message('ROUT','entry:ben_dm_utility.rollback_upload', 5);

1098: --
1099: BEGIN
1100: --
1101:
1102: message('ROUT','entry:ben_dm_utility.rollback_upload', 5);
1103: message('PARA','(p_migration_id - ' || p_migration_id || ')', 10);
1104:
1105: -- find all upload phases for this migration that are started or in error
1106: OPEN csr_c1;

Line 1117: message('ROUT','exit:ben_dm_utility.rollback_upload', 25);

1113: CLOSE csr_c1;
1114:
1115: message('INFO','Rollback - upload', 15);
1116: message('SUMM','Rollback - upload', 20);
1117: message('ROUT','exit:ben_dm_utility.rollback_upload', 25);
1118: message('PARA','(none)', 30);
1119:
1120: -- error handling
1121: EXCEPTION

Line 1123: error(SQLCODE,'ben_dm_utility.rollback_upload','(none)','R');

1119:
1120: -- error handling
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: error(SQLCODE,'ben_dm_utility.rollback_upload','(none)','R');
1124: RAISE;
1125: --
1126: END rollback_upload;
1127: --

Line 1145: -- message('ROUT','entry:ben_dm_utility.number_of_threads', 5);

1141: --
1142: BEGIN
1143: --
1144:
1145: -- message('ROUT','entry:ben_dm_utility.number_of_threads', 5);
1146: -- message('PARA','(p_business_group_id - ' || p_business_group_id || ')', 10);
1147: OPEN csr_tables;
1148: FETCH csr_tables INTO l_table_id;
1149: CLOSE csr_tables;

Line 1159: -- message('ROUT','exit:ben_dm_utility.get_table_id', 25);

1155: END IF;
1156:
1157: -- message('INFO','Found Table ID', 15);
1158: -- message('SUMM','Found Table ID', 20);
1159: -- message('ROUT','exit:ben_dm_utility.get_table_id', 25);
1160: -- message('PARA','(l_table_id - ' || ')', 30);
1161:
1162: RETURN(l_table_id);
1163:

Line 1167: -- error(SQLCODE,'ben_dm_utility.get_table_id','(none)','R');

1163:
1164: -- error handling
1165: EXCEPTION
1166: WHEN OTHERS THEN
1167: -- error(SQLCODE,'ben_dm_utility.get_table_id','(none)','R');
1168: RAISE;
1169:
1170: --
1171: END get_table_id;

Line 1228: -- message('ROUT','entry:ben_dm_utility.seed_column_mapping', 5);

1224: --
1225: BEGIN
1226: --
1227:
1228: -- message('ROUT','entry:ben_dm_utility.seed_column_mapping', 5);
1229: -- message('PARA','(p_table_name - ' || p_table_name ||'), 10);
1230: -- get_table_id
1231:
1232: l_table_id := get_table_id(p_table_name);

Line 1268: -- message('ROUT','exit:ben_dm_utility.seed_column_maping', 25);

1264: END LOOP;
1265:
1266: -- message('INFO','seed_column_maping', 15);
1267: -- message('SUMM','seed_column_maping', 20);
1268: -- message('ROUT','exit:ben_dm_utility.seed_column_maping', 25);
1269: -- message('PARA','(p_table_name - ' || p_table_name ||'), 10);
1270:
1271: -- error handling
1272: EXCEPTION

Line 1274: -- error(SQLCODE,'ben_dm_utility.seed_column_maping','(none)','R');

1270:
1271: -- error handling
1272: EXCEPTION
1273: WHEN OTHERS THEN
1274: -- error(SQLCODE,'ben_dm_utility.seed_column_maping','(none)','R');
1275: RAISE;
1276: --
1277: END seed_column_mapping;
1278: --

Line 1302: -- message('ROUT','entry:ben_dm_utility.seed_table_order', 5);

1298: --
1299: BEGIN
1300: --
1301:
1302: -- message('ROUT','entry:ben_dm_utility.seed_table_order', 5);
1303: -- message('PARA','(p_table_name - ' || p_table_name ||'), 10);
1304: -- get_table_id
1305:
1306: l_table_id := get_table_id(p_table_name);

Line 1332: -- message('ROUT','exit:ben_dm_utility.seed_table_order', 25);

1328: ,sysdate);
1329:
1330: -- message('INFO','seed_table_order', 15);
1331: -- message('SUMM','seed_table_order', 20);
1332: -- message('ROUT','exit:ben_dm_utility.seed_table_order', 25);
1333: -- message('PARA','(p_table_name - ' || p_table_name ||'), 10);
1334:
1335: -- error handling
1336: EXCEPTION

Line 1338: -- error(SQLCODE,'ben_dm_utility.seed_column_maping','(none)','R');

1334:
1335: -- error handling
1336: EXCEPTION
1337: WHEN OTHERS THEN
1338: -- error(SQLCODE,'ben_dm_utility.seed_column_maping','(none)','R');
1339: RAISE;
1340: --
1341: END seed_table_order;
1342: --

Line 1445: end ben_dm_utility;

1441: || ''' - ' || p_table_name );
1442: END ins_hir;
1443:
1444:
1445: end ben_dm_utility;