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.BSC_MIGRATION dependencies on BSC_MESSAGE

Line 121: BSC_MESSAGE.Add(x_message => 'Error in syncup dataset ids'||sqlerrm,

117: COMMIT;
118: EXCEPTION --ignore the exception if any
119: WHEN OTHERS THEN
120: ROLLBACK;
121: BSC_MESSAGE.Add(x_message => 'Error in syncup dataset ids'||sqlerrm,
122: x_source => 'BSC_MIGRATION.Migrate_System');
123: COMMIT;
124: IF(h_cursor%ISOPEN) THEN
125: CLOSE h_cursor;

Line 288: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),

284: RETURN TRUE;
285:
286: EXCEPTION
287: WHEN e_unexpected_error THEN
288: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),
289: x_source => 'BSC_MIGRATION.Assign_Target_Responsibilities');
290: RETURN FALSE;
291:
292: WHEN e_add_roles_scorecard THEN

Line 293: BSC_MESSAGE.Add (x_message => h_error_msg,

289: x_source => 'BSC_MIGRATION.Assign_Target_Responsibilities');
290: RETURN FALSE;
291:
292: WHEN e_add_roles_scorecard THEN
293: BSC_MESSAGE.Add (x_message => h_error_msg,
294: x_source => 'BSC_MIGRATION.Assign_Target_Responsibilities');
295: RETURN FALSE;
296:
297: WHEN OTHERS THEN

Line 298: BSC_MESSAGE.Add (x_message => SQLERRM,

294: x_source => 'BSC_MIGRATION.Assign_Target_Responsibilities');
295: RETURN FALSE;
296:
297: WHEN OTHERS THEN
298: BSC_MESSAGE.Add (x_message => SQLERRM,
299: x_source => 'BSC_MIGRATION.Assign_Target_Responsibilities');
300: RETURN FALSE;
301:
302: END Assign_Target_Responsibilities;

Line 562: BSC_MESSAGE.Add (x_message => SQLERRM,

558: RETURN TRUE;
559:
560: EXCEPTION
561: WHEN OTHERS THEN
562: BSC_MESSAGE.Add (x_message => SQLERRM,
563: x_source => 'BSC_MIGRATION.Check_Languages_TL_Tables');
564: RETURN FALSE;
565: END Check_Languages_TL_Tables;
566:

Line 930: BSC_MESSAGE.Add (x_message => SQLERRM,

926: RETURN TRUE;
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: BSC_MESSAGE.Add (x_message => SQLERRM,
931: x_source => 'BSC_MIGRATION.Create_Copy_Of_Table_Def');
932: RETURN FALSE;
933:
934: END Create_Copy_Of_Table_Def;

Line 1007: BSC_MESSAGE.Add (x_message => SQLERRM,

1003: NULL; -- Ignore, success with compilation error
1004: ELSIF (SQLCODE = -00955) THEN
1005: NULL; -- view already exists on the target do not oeverwrite
1006: ELSE
1007: BSC_MESSAGE.Add (x_message => SQLERRM,
1008: x_source => 'BSC_MIGRATION.Create_Copy_Of_View_Def');
1009: RETURN FALSE;
1010: END IF;
1011: END;

Line 1020: BSC_MESSAGE.Add (x_message => SQLERRM,

1016: RETURN TRUE;
1017:
1018: EXCEPTION
1019: WHEN OTHERS THEN
1020: BSC_MESSAGE.Add (x_message => SQLERRM,
1021: x_source => 'BSC_MIGRATION.Create_Copy_Of_View_Def');
1022: RETURN FALSE;
1023:
1024: END Create_Copy_Of_View_Def;

Line 1324: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_CREATE_OBJS'),

1320: RETURN TRUE;
1321:
1322: EXCEPTION
1323: WHEN e_unexpected_error THEN
1324: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_CREATE_OBJS'),
1325: x_source => 'BSC_MIGRATION.Create_Dynamic_Objects');
1326: RETURN FALSE;
1327:
1328: WHEN OTHERS THEN

Line 1329: BSC_MESSAGE.Add (x_message => SQLERRM,

1325: x_source => 'BSC_MIGRATION.Create_Dynamic_Objects');
1326: RETURN FALSE;
1327:
1328: WHEN OTHERS THEN
1329: BSC_MESSAGE.Add (x_message => SQLERRM,
1330: x_source => 'BSC_MIGRATION.Create_Dynamic_Objects');
1331: RETURN FALSE;
1332: END Create_Dynamic_Objects;
1333:

Line 1514: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_CREATE_OBJS'),

1510: RETURN TRUE;
1511:
1512: EXCEPTION
1513: WHEN e_unexpected_error THEN
1514: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_CREATE_OBJS'),
1515: x_source => 'BSC_MIGRATION.Create_Indexes_Dynamic_Tables');
1516: RETURN FALSE;
1517:
1518: WHEN OTHERS THEN

Line 1519: BSC_MESSAGE.Add (x_message => SQLERRM,

1515: x_source => 'BSC_MIGRATION.Create_Indexes_Dynamic_Tables');
1516: RETURN FALSE;
1517:
1518: WHEN OTHERS THEN
1519: BSC_MESSAGE.Add (x_message => SQLERRM,
1520: x_source => 'BSC_MIGRATION.Create_Indexes_Dynamic_Tables');
1521: RETURN FALSE;
1522: END Create_Indexes_Dynamic_Tables;
1523:

Line 1567: BSC_MESSAGE.Add (x_message => SQLERRM,

1563: RETURN TRUE;
1564:
1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: BSC_MESSAGE.Add (x_message => SQLERRM,
1568: x_source => 'BSC_MIGRATION.Analyze_Base_And_Dim_Tables');
1569: RETURN FALSE;
1570: END Analyze_Base_And_Dim_Tables;
1571:

Line 1736: BSC_MESSAGE.Add (x_message => SQLERRM,

1732: RETURN TRUE;
1733:
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: BSC_MESSAGE.Add (x_message => SQLERRM,
1737: x_source => 'BSC_MIGRATION.Create_Table_Indexes');
1738: RETURN FALSE;
1739:
1740: END Create_Table_Indexes;

Line 1828: BSC_MESSAGE.Add (x_message => SQLERRM,

1824: RETURN TRUE;
1825:
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: BSC_MESSAGE.Add (x_message => SQLERRM,
1829: x_source => 'BSC_MIGRATION.Delete_Metadata_Tables');
1830: RETURN FALSE;
1831: END Delete_Metadata_Tables;
1832:

Line 2133: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_ERROR_DROPPING_OLD_DB_OBJ'),

2129: RETURN TRUE;
2130:
2131: EXCEPTION
2132: WHEN e_unexpected_error THEN
2133: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_ERROR_DROPPING_OLD_DB_OBJ'),
2134: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2135: RETURN FALSE;
2136:
2137: WHEN e_error_drop_mv THEN

Line 2138: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Drop_Summary_MV: '||h_mv_name||' '||h_error_message_drop_mv,

2134: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2135: RETURN FALSE;
2136:
2137: WHEN e_error_drop_mv THEN
2138: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Drop_Summary_MV: '||h_mv_name||' '||h_error_message_drop_mv,
2139: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2140: RETURN FALSE;
2141:
2142: WHEN OTHERS THEN

Line 2143: BSC_MESSAGE.Add (x_message => SQLERRM,

2139: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2140: RETURN FALSE;
2141:
2142: WHEN OTHERS THEN
2143: BSC_MESSAGE.Add (x_message => SQLERRM,
2144: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2145: RETURN FALSE;
2146:
2147: END Drop_Dynamic_Objects;

Line 2360: BSC_MESSAGE.Init(g_debug_flag);

2356: -- LOCKING: call this api
2357: FND_MSG_PUB.Initialize;
2358:
2359: -- Initializes the error message stack
2360: BSC_MESSAGE.Init(g_debug_flag);
2361:
2362: -- Initialize the temporal table used for big 'in' conditions
2363: BSC_APPS.Init_Big_In_Cond_Table;
2364:

Line 2437: FROM bsc_message_logs

2433: COMMIT;
2434:
2435: SELECT count(*)
2436: INTO h_count
2437: FROM bsc_message_logs
2438: WHERE type = 0
2439: AND UPPER(source) = 'BSC_MIGRATION.MIGRATE_SYSTEM'
2440: AND last_update_login = USERENV('SESSIONID');
2441:

Line 2494: BSC_MESSAGE.flush;

2490: execute immediate h_sql;
2491:
2492: WHEN g_error_synch_bsc_pmf THEN
2493: ROLLBACK;
2494: BSC_MESSAGE.flush;
2495: BSC_MESSAGE.Add(x_message => h_error_msg,
2496: x_source => 'BSC_MIGRATION.Migrate_System',
2497: x_mode => 'I');
2498: COMMIT;

Line 2495: BSC_MESSAGE.Add(x_message => h_error_msg,

2491:
2492: WHEN g_error_synch_bsc_pmf THEN
2493: ROLLBACK;
2494: BSC_MESSAGE.flush;
2495: BSC_MESSAGE.Add(x_message => h_error_msg,
2496: x_source => 'BSC_MIGRATION.Migrate_System',
2497: x_mode => 'I');
2498: COMMIT;
2499:

Line 2515: BSC_MESSAGE.Add(x_message => SQLERRM,

2511: h_sql := 'BEGIN BSC_LOCKS_PUB.Remove_System_Lock@'||g_db_link||'; END;';
2512: execute immediate h_sql;
2513:
2514: WHEN OTHERS THEN
2515: BSC_MESSAGE.Add(x_message => SQLERRM,
2516: x_source => 'BSC_MIGRATION.Execute_Migration',
2517: x_mode => 'I');
2518: COMMIT;
2519:

Line 4026: -- BSC_MESSAGE_LOGS

4022: -- BSC_USER_TAB_ACCESS
4023:
4024: -- This table is not deleted from the target and is not copied from source
4025: -- because the migration program use this table.
4026: -- BSC_MESSAGE_LOGS
4027:
4028: -- Ignored tables.
4029: -- BSC_INSTALL_LOGS
4030: -- BSC_UPGRADE_TASK

Line 4198: BSC_MESSAGE.Add (x_message => SQLERRM,

4194: RETURN TRUE;
4195:
4196: EXCEPTION
4197: WHEN OTHERS THEN
4198: BSC_MESSAGE.Add (x_message => SQLERRM,
4199: x_source => 'BSC_MIGRATION.Init_Migration_Objects_Arrays');
4200: RETURN FALSE;
4201:
4202: END Init_Migration_Objects_Arrays;

Line 4608: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_UNEXPECTED_ERROR'),

4604: RETURN TRUE;
4605:
4606: EXCEPTION
4607: WHEN e_unexpected_error THEN
4608: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_UNEXPECTED_ERROR'),
4609: x_source => 'BSC_MIGRATION.Migrate_Dynamic_Tables_Data');
4610: RETURN FALSE;
4611:
4612: WHEN OTHERS THEN

Line 4613: BSC_MESSAGE.Add (x_message => SQLERRM,

4609: x_source => 'BSC_MIGRATION.Migrate_Dynamic_Tables_Data');
4610: RETURN FALSE;
4611:
4612: WHEN OTHERS THEN
4613: BSC_MESSAGE.Add (x_message => SQLERRM,
4614: x_source => 'BSC_MIGRATION.Migrate_Dynamic_Tables_Data');
4615: RETURN FALSE;
4616:
4617: END Migrate_Dynamic_Tables_Data;

Line 5099: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),

5095: RETURN TRUE;
5096:
5097: EXCEPTION
5098: WHEN e_unexpected_error THEN
5099: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),
5100: x_source => 'BSC_MIGRATION.Migrate_Metadata');
5101: RETURN FALSE;
5102:
5103: WHEN OTHERS THEN

Line 5104: BSC_MESSAGE.Add (x_message => SQLERRM,

5100: x_source => 'BSC_MIGRATION.Migrate_Metadata');
5101: RETURN FALSE;
5102:
5103: WHEN OTHERS THEN
5104: BSC_MESSAGE.Add (x_message => SQLERRM,
5105: x_source => 'BSC_MIGRATION.Migrate_Metadata');
5106: RETURN FALSE;
5107: END Migrate_Metadata;
5108:

Line 5183: BSC_MESSAGE.Add (x_message => SQLERRM,

5179:
5180: BSC_APPS.Do_DDL(l_stmt, AD_DDL.CREATE_TABLE, c_comments_bak);
5181: EXCEPTION
5182: WHEN OTHERS THEN
5183: BSC_MESSAGE.Add (x_message => SQLERRM,
5184: x_source => 'BSC_MIGRATION.create_comment_backup_table');
5185: RAISE e_unexpected_error;
5186:
5187: END;

Line 5213: BSC_MESSAGE.Add (x_message => SQLERRM,

5209: execute immediate l_stmt USING fnd_global.CONC_REQUEST_ID, sysdate;
5210:
5211: EXCEPTION
5212: WHEN OTHERS THEN
5213: BSC_MESSAGE.Add (x_message => SQLERRM,
5214: x_source => 'BSC_MIGRATION.update_comment_backup_table');
5215: RAISE e_unexpected_error;
5216:
5217: END;

Line 5248: BSC_MESSAGE.Add (x_message => SQLERRM,

5244:
5245: return true;
5246: EXCEPTION
5247: WHEN OTHERS THEN
5248: BSC_MESSAGE.Add (x_message => SQLERRM,
5249: x_source => 'BSC_MIGRATION.Backup_Comments');
5250: raise;
5251: RAISE e_unexpected_error;
5252: END;

Line 5328: BSC_MESSAGE.Add (x_message => SQLERRM,

5324: return true;
5325:
5326: EXCEPTION
5327: WHEN OTHERS THEN
5328: BSC_MESSAGE.Add (x_message => SQLERRM,
5329: x_source => 'BSC_MIGRATION.Restore_Comments');
5330: RAISE e_unexpected_error;
5331: return false;
5332: END;

Line 5423: BSC_MESSAGE.Init(g_debug_flag);

5419: -- Initialize BSC/APPS global variables
5420: BSC_APPS.Init_Bsc_Apps;
5421:
5422: -- Initializes the error message stack
5423: BSC_MESSAGE.Init(g_debug_flag);
5424:
5425: -- Initialize the temporal table used for big 'in' conditions
5426: BSC_APPS.Init_Big_In_Cond_Table;
5427:

Line 5431: BSC_MESSAGE.Add(x_message => h_error_msg,

5427:
5428: -- Initiliaze log file
5429: h_log_file_name := 'bscmig40.log';
5430: IF NOT BSC_APPS.Init_Log_File(h_log_file_name, h_error_msg) THEN
5431: BSC_MESSAGE.Add(x_message => h_error_msg,
5432: x_source => 'BSC_MIGRATION.Migrate_System');
5433: RAISE e_unexpected_error;
5434: END IF;
5435:

Line 5491: BSC_MESSAGE.Add(x_message => h_error_msg,

5487: if(BSC_OLAP_MAIN.create_tmp_col_type_table(h_error_msg)) then
5488: BSC_OLAP_MAIN.b_table_col_type_created := true;
5489: else
5490: --Raise exception;
5491: BSC_MESSAGE.Add(x_message => h_error_msg,
5492: x_source => 'BSC_MIGRATION.Migrate_System');
5493: RAISE e_unexpected_error;
5494: end if;
5495: end if;

Line 5503: BSC_MESSAGE.Add(x_message => h_validation_error,

5499: -- Validate x_overwrite is 'Y'
5500: IF h_overwrite <> 'Y' THEN
5501: h_validation_error := BSC_APPS.Get_Message('BSC_MIG_CONFIRM_OVERW');
5502: BSC_APPS.Write_Line_Log(h_validation_error, BSC_APPS.OUTPUT_FILE);
5503: BSC_MESSAGE.Add(x_message => h_validation_error,
5504: x_source => 'BSC_MIGRATION.Migrate_System');
5505: RAISE e_unexpected_error;
5506: END IF;
5507:

Line 5511: BSC_MESSAGE.Add(x_message => h_validation_error,

5507:
5508: -- Validate that the source and target system are same version
5509: IF NOT Validate_System_Versions(h_validation_error) THEN
5510: BSC_APPS.Write_Line_Log(h_validation_error, BSC_APPS.OUTPUT_FILE);
5511: BSC_MESSAGE.Add(x_message => h_validation_error,
5512: x_source => 'BSC_MIGRATION.Migrate_System');
5513: RAISE e_unexpected_error;
5514: END IF;
5515:

Line 5522: BSC_MESSAGE.Add(x_message => h_validation_error,

5518: IF NOT Validate_Responsibilities(h_src_responsibilities,
5519: h_trg_responsibilities,
5520: h_validation_error) THEN
5521: BSC_APPS.Write_Line_Log(h_validation_error, BSC_APPS.OUTPUT_FILE);
5522: BSC_MESSAGE.Add(x_message => h_validation_error,
5523: x_source => 'BSC_MIGRATION.Migrate_System');
5524: RAISE e_unexpected_error;
5525: END IF;
5526:

Line 5533: BSC_MESSAGE.Add(x_message => h_validation_error,

5529: IF NOT Validate_Filters(h_tab_filter,
5530: h_kpi_filter,
5531: h_validation_error) THEN
5532: BSC_APPS.Write_Line_Log(h_validation_error, BSC_APPS.OUTPUT_FILE);
5533: BSC_MESSAGE.Add(x_message => h_validation_error,
5534: x_source => 'BSC_MIGRATION.Migrate_System');
5535: RAISE e_unexpected_error;
5536: END IF;
5537:

Line 5618: BSC_MESSAGE.Add(x_message => h_validation_error,

5614: -- filters, in this case migration should finish with warning.
5615: IF g_num_no_mig_kpis = 0 THEN
5616: h_validation_error := BSC_APPS.Get_Message('BSC_MIG_NO_INDICATORS');
5617: BSC_APPS.Write_Line_Log(h_validation_error, BSC_APPS.OUTPUT_FILE);
5618: BSC_MESSAGE.Add(x_message => h_validation_error,
5619: x_source => 'BSC_MIGRATION.Migrate_System');
5620: RAISE e_unexpected_error;
5621: ELSE
5622: RAISE e_warning_raised;

Line 6062: BSC_MESSAGE.flush;

6058:
6059: -- Delete records in the temporal table used for big 'in' conditions
6060: BSC_APPS.Init_Big_In_Cond_Table;
6061:
6062: BSC_MESSAGE.flush;
6063: BSC_MESSAGE.Add(x_message => 'Error in BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_calendar_id||' '||h_error_msg,
6064: x_source => 'BSC_MIGRATION.Migrate_System',
6065: x_mode => 'I');
6066: COMMIT;

Line 6063: BSC_MESSAGE.Add(x_message => 'Error in BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_calendar_id||' '||h_error_msg,

6059: -- Delete records in the temporal table used for big 'in' conditions
6060: BSC_APPS.Init_Big_In_Cond_Table;
6061:
6062: BSC_MESSAGE.flush;
6063: BSC_MESSAGE.Add(x_message => 'Error in BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_calendar_id||' '||h_error_msg,
6064: x_source => 'BSC_MIGRATION.Migrate_System',
6065: x_mode => 'I');
6066: COMMIT;
6067:

Line 6082: BSC_MESSAGE.flush;

6078:
6079: -- Delete records in the temporal table used for big 'in' conditions
6080: BSC_APPS.Init_Big_In_Cond_Table;
6081:
6082: BSC_MESSAGE.flush;
6083: BSC_MESSAGE.Add(x_message => 'Error in BSC_UPDATE_DIM.Create_Dbi_Dim_Tables: '||h_error_msg,
6084: x_source => 'BSC_MIGRATION.Migrate_System',
6085: x_mode => 'I');
6086: COMMIT;

Line 6083: BSC_MESSAGE.Add(x_message => 'Error in BSC_UPDATE_DIM.Create_Dbi_Dim_Tables: '||h_error_msg,

6079: -- Delete records in the temporal table used for big 'in' conditions
6080: BSC_APPS.Init_Big_In_Cond_Table;
6081:
6082: BSC_MESSAGE.flush;
6083: BSC_MESSAGE.Add(x_message => 'Error in BSC_UPDATE_DIM.Create_Dbi_Dim_Tables: '||h_error_msg,
6084: x_source => 'BSC_MIGRATION.Migrate_System',
6085: x_mode => 'I');
6086: COMMIT;
6087:

Line 6102: BSC_MESSAGE.flush;

6098:
6099: -- Delete records in the temporal table used for big 'in' conditions
6100: BSC_APPS.Init_Big_In_Cond_Table;
6101:
6102: BSC_MESSAGE.flush;
6103: BSC_MESSAGE.Add(x_message => h_error_msg,
6104: x_source => 'BSC_MIGRATION.Migrate_System',
6105: x_mode => 'I');
6106: COMMIT;

Line 6103: BSC_MESSAGE.Add(x_message => h_error_msg,

6099: -- Delete records in the temporal table used for big 'in' conditions
6100: BSC_APPS.Init_Big_In_Cond_Table;
6101:
6102: BSC_MESSAGE.flush;
6103: BSC_MESSAGE.Add(x_message => h_error_msg,
6104: x_source => 'BSC_MIGRATION.Migrate_System',
6105: x_mode => 'I');
6106: COMMIT;
6107:

Line 6121: BSC_MESSAGE.flush;

6117:
6118: -- Delete records in the temporal table used for big 'in' conditions
6119: BSC_APPS.Init_Big_In_Cond_Table;
6120:
6121: BSC_MESSAGE.flush;
6122: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Implement_Bsc_MV '||g_mig_kpis(h_i)||' '||h_error_implement_mv,
6123: x_source => 'BSC_MIGRATION.Migrate_System',
6124: x_mode => 'I');
6125: COMMIT;

Line 6122: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Implement_Bsc_MV '||g_mig_kpis(h_i)||' '||h_error_implement_mv,

6118: -- Delete records in the temporal table used for big 'in' conditions
6119: BSC_APPS.Init_Big_In_Cond_Table;
6120:
6121: BSC_MESSAGE.flush;
6122: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Implement_Bsc_MV '||g_mig_kpis(h_i)||' '||h_error_implement_mv,
6123: x_source => 'BSC_MIGRATION.Migrate_System',
6124: x_mode => 'I');
6125: COMMIT;
6126:

Line 6140: BSC_MESSAGE.flush;

6136:
6137: -- Delete records in the temporal table used for big 'in' conditions
6138: BSC_APPS.Init_Big_In_Cond_Table;
6139:
6140: BSC_MESSAGE.flush;
6141: BSC_MESSAGE.Add(x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),
6142: x_source => 'BSC_MIGRATION.Migrate_System',
6143: x_mode => 'I');
6144: COMMIT;

Line 6141: BSC_MESSAGE.Add(x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),

6137: -- Delete records in the temporal table used for big 'in' conditions
6138: BSC_APPS.Init_Big_In_Cond_Table;
6139:
6140: BSC_MESSAGE.flush;
6141: BSC_MESSAGE.Add(x_message => BSC_APPS.Get_Message('BSC_MIG_FAIL_EXEC'),
6142: x_source => 'BSC_MIGRATION.Migrate_System',
6143: x_mode => 'I');
6144: COMMIT;
6145:

Line 6158: BSC_MESSAGE.flush;

6154: ROLLBACK;
6155: -- Delete records in the temporal table used for big 'in' conditions
6156: BSC_APPS.Init_Big_In_Cond_Table;
6157:
6158: BSC_MESSAGE.flush;
6159:
6160: COMMIT ;
6161:
6162: WHEN OTHERS THEN

Line 6168: BSC_MESSAGE.flush;

6164:
6165: -- Delete records in the temporal table used for big 'in' conditions
6166: BSC_APPS.Init_Big_In_Cond_Table;
6167:
6168: BSC_MESSAGE.flush;
6169: BSC_MESSAGE.Add(x_message => SQLERRM,
6170: x_source => 'BSC_MIGRATION.Migrate_System',
6171: x_mode => 'I');
6172: COMMIT;

Line 6169: BSC_MESSAGE.Add(x_message => SQLERRM,

6165: -- Delete records in the temporal table used for big 'in' conditions
6166: BSC_APPS.Init_Big_In_Cond_Table;
6167:
6168: BSC_MESSAGE.flush;
6169: BSC_MESSAGE.Add(x_message => SQLERRM,
6170: x_source => 'BSC_MIGRATION.Migrate_System',
6171: x_mode => 'I');
6172: COMMIT;
6173:

Line 6269: BSC_MESSAGE.Add(x_message => h_msg_data,

6265: IF (h_msg_data is null) THEN
6266: h_msg_data := SQLERRM;
6267: END IF;
6268:
6269: BSC_MESSAGE.Add(x_message => h_msg_data,
6270: x_source => 'BSC_MIGRATION.Remove_Custom_Dim_Objs_In_PMF');
6271: RETURN FALSE;
6272:
6273: END Remove_Custom_Dim_Objs_In_PMF;

Line 6346: BSC_MESSAGE.Add(x_message => h_msg_data,

6342: IF (h_msg_data is null) THEN
6343: h_msg_data := SQLERRM;
6344: END IF;
6345:
6346: BSC_MESSAGE.Add(x_message => h_msg_data,
6347: x_source => 'BSC_MIGRATION.Remove_Custom_Dims_In_PMF');
6348: RETURN FALSE;
6349:
6350: END Remove_Custom_Dims_In_PMF;

Line 6420: BSC_MESSAGE.Add(x_message => h_msg_data,

6416: IF (h_msg_data is null) THEN
6417: h_msg_data := SQLERRM;
6418: END IF;
6419:
6420: BSC_MESSAGE.Add(x_message => h_msg_data,
6421: x_source => 'BSC_MIGRATION.Remove_Custom_Measures_In_PMF');
6422: RETURN FALSE;
6423:
6424: END Remove_Custom_Measures_In_PMF;

Line 6523: BSC_MESSAGE.Add(x_message => SQLERRM,

6519: EXCEPTION
6520: WHEN OTHERS THEN
6521: ROLLBACK;
6522:
6523: BSC_MESSAGE.Add(x_message => SQLERRM,
6524: x_source => 'BSC_MIGRATION.Update_BSC_Dimensions_In_PMF');
6525: RETURN FALSE;
6526:
6527: END Update_BSC_Dimensions_In_PMF;

Line 7061: BSC_MESSAGE.Add (x_message => SQLERRM,

7057: RETURN FALSE;
7058:
7059: EXCEPTION
7060: WHEN OTHERS THEN
7061: BSC_MESSAGE.Add (x_message => SQLERRM,
7062: x_source => 'BSC_MIGRATION.Validate_Tables');
7063: RETURN FALSE;
7064: END Validate_Tables;
7065:

Line 8290: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_UNEXPECTED_ERROR'),

8286: RETURN TRUE;
8287:
8288: EXCEPTION
8289: WHEN e_unexpected_error THEN
8290: BSC_MESSAGE.Add (x_message => BSC_APPS.Get_Message('BSC_UNEXPECTED_ERROR'),
8291: x_source => 'BSC_MIGRATION.Migrate_BTable_With_Partitions');
8292: RETURN FALSE;
8293:
8294: WHEN OTHERS THEN

Line 8295: BSC_MESSAGE.Add (x_message => SQLERRM,

8291: x_source => 'BSC_MIGRATION.Migrate_BTable_With_Partitions');
8292: RETURN FALSE;
8293:
8294: WHEN OTHERS THEN
8295: BSC_MESSAGE.Add (x_message => SQLERRM,
8296: x_source => 'BSC_MIGRATION.Migrate_BTable_With_Partitions');
8297: RETURN FALSE;
8298: END Migrate_BTable_With_Partitions;
8299: