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_MIGRATION

Line 1: PACKAGE BODY BSC_MIGRATION AS

1: PACKAGE BODY BSC_MIGRATION AS
2: /* $Header: BSCSMIGB.pls 120.58.12010000.2 2008/08/11 09:34:46 sirukull ship $ */
3:
4: -- Global variables
5: g_metadata_tables t_metadata_tables;

Line 122: x_source => 'BSC_MIGRATION.Migrate_System');

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;
126: END IF;

Line 289: x_source => 'BSC_MIGRATION.Assign_Target_Responsibilities');

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
293: BSC_MESSAGE.Add (x_message => h_error_msg,

Line 294: 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
298: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 299: 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;
303:

Line 563: x_source => 'BSC_MIGRATION.Check_Languages_TL_Tables');

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:
567:

Line 931: x_source => 'BSC_MIGRATION.Create_Copy_Of_Table_Def');

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;
935:

Line 1008: x_source => 'BSC_MIGRATION.Create_Copy_Of_View_Def');

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;
1012:

Line 1021: x_source => 'BSC_MIGRATION.Create_Copy_Of_View_Def');

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;
1025:

Line 1325: x_source => 'BSC_MIGRATION.Create_Dynamic_Objects');

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
1329: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 1330: 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:
1334:

Line 1515: x_source => 'BSC_MIGRATION.Create_Indexes_Dynamic_Tables');

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
1519: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 1520: 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:
1524:

Line 1568: x_source => 'BSC_MIGRATION.Analyze_Base_And_Dim_Tables');

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:
1572:

Line 1737: x_source => 'BSC_MIGRATION.Create_Table_Indexes');

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;
1741:

Line 1829: x_source => 'BSC_MIGRATION.Delete_Metadata_Tables');

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:
1833:

Line 1858: select bsc_migration.get_rowid_table_name(table_name)

1854: FROM bsc_sys_filters_views;
1855:
1856: -- ENH_B_TABLES_PERF: get rowid tables created for input tables
1857: CURSOR c_rowid_tables IS
1858: select bsc_migration.get_rowid_table_name(table_name)
1859: from bsc_db_tables
1860: where table_type = 0;
1861:
1862: -- ENH_B_TABLES_PERF: get rowid tables created for input tables

Line 1864: select bsc_migration.get_proj_table_name(table_name)

1860: where table_type = 0;
1861:
1862: -- ENH_B_TABLES_PERF: get rowid tables created for input tables
1863: CURSOR c_proj_tables IS
1864: select bsc_migration.get_proj_table_name(table_name)
1865: from bsc_db_tables
1866: where table_type = 1;
1867:
1868: h_table VARCHAR2(30);

Line 2134: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');

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
2138: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Drop_Summary_MV: '||h_mv_name||' '||h_error_message_drop_mv,

Line 2139: 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
2143: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 2144: 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;
2148:

Line 2439: AND UPPER(source) = 'BSC_MIGRATION.MIGRATE_SYSTEM'

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:
2442: IF h_count > 0 THEN
2443: IF NOT g_syncup_done THEN

Line 2496: x_source => 'BSC_MIGRATION.Migrate_System',

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:
2500: BSC_APPS.Write_Errors_To_Log;

Line 2516: x_source => 'BSC_MIGRATION.Execute_Migration',

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:
2520: BSC_APPS.Write_Errors_To_Log;

Line 4199: x_source => 'BSC_MIGRATION.Init_Migration_Objects_Arrays');

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;
4203:

Line 4609: x_source => 'BSC_MIGRATION.Migrate_Dynamic_Tables_Data');

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
4613: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 4614: 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;
4618:

Line 5100: x_source => 'BSC_MIGRATION.Migrate_Metadata');

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
5104: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 5105: 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:
5109: /*===========================================================================+

Line 5184: x_source => 'BSC_MIGRATION.create_comment_backup_table');

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;
5188:

Line 5214: x_source => 'BSC_MIGRATION.update_comment_backup_table');

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;
5218:

Line 5249: x_source => 'BSC_MIGRATION.Backup_Comments');

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;
5253:

Line 5329: x_source => 'BSC_MIGRATION.Restore_Comments');

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;
5333:

Line 5432: x_source => 'BSC_MIGRATION.Migrate_System');

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:
5436: /*

Line 5492: x_source => 'BSC_MIGRATION.Migrate_System');

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;
5496:

Line 5504: x_source => 'BSC_MIGRATION.Migrate_System');

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:
5508: -- Validate that the source and target system are same version

Line 5512: x_source => 'BSC_MIGRATION.Migrate_System');

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:
5516: -- Validate the given source and target responsibilities

Line 5523: x_source => 'BSC_MIGRATION.Migrate_System');

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:
5527: -- Validate the given tab and kpi filters

Line 5534: x_source => 'BSC_MIGRATION.Migrate_System');

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:
5538: --BSC-MV Note: Moved this code here

Line 5619: x_source => 'BSC_MIGRATION.Migrate_System');

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;
5623: END IF;

Line 6064: x_source => 'BSC_MIGRATION.Migrate_System',

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:
6068: BSC_APPS.Write_Errors_To_Log;

Line 6084: x_source => 'BSC_MIGRATION.Migrate_System',

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:
6088: BSC_APPS.Write_Errors_To_Log;

Line 6104: x_source => 'BSC_MIGRATION.Migrate_System',

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:
6108: BSC_APPS.Write_Errors_To_Log;

Line 6123: x_source => 'BSC_MIGRATION.Migrate_System',

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:
6127: BSC_APPS.Write_Errors_To_Log;

Line 6142: x_source => 'BSC_MIGRATION.Migrate_System',

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:
6146: BSC_APPS.Write_Errors_To_Log;

Line 6170: x_source => 'BSC_MIGRATION.Migrate_System',

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:
6174: BSC_APPS.Write_Errors_To_Log;

Line 6270: x_source => 'BSC_MIGRATION.Remove_Custom_Dim_Objs_In_PMF');

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;
6274:

Line 6347: x_source => 'BSC_MIGRATION.Remove_Custom_Dims_In_PMF');

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;
6351:

Line 6421: x_source => 'BSC_MIGRATION.Remove_Custom_Measures_In_PMF');

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;
6425:

Line 6524: x_source => 'BSC_MIGRATION.Update_BSC_Dimensions_In_PMF');

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;
6528:

Line 7062: x_source => 'BSC_MIGRATION.Validate_Tables');

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:
7066:

Line 7321: h_sql := 'BEGIN BSC_MIGRATION.Retrieve_Dimension@'||g_db_link||'('||

7317:
7318: -- Retrieve the dimension from the source system
7319: BSC_APPS.Write_Line_Log('Migrating existing source dimension '||h_dimension_short_name, BSC_APPS.OUTPUT_FILE);
7320:
7321: h_sql := 'BEGIN BSC_MIGRATION.Retrieve_Dimension@'||g_db_link||'('||
7322: ' p_dimension_short_name => :1'||
7323: ', x_dimension_name => :2'||
7324: ', x_description => :3'||
7325: ', x_application_id => :4'||

Line 7450: h_sql := 'BEGIN BSC_MIGRATION.Retrieve_Dimension_Level@'||g_db_link||'('||

7446:
7447: -- Retrieve the dimension level from the source system
7448: BSC_APPS.Write_Line_Log('Migrating existing source dimension object '||h_dimension_level_short_name, BSC_APPS.OUTPUT_FILE);
7449:
7450: h_sql := 'BEGIN BSC_MIGRATION.Retrieve_Dimension_Level@'||g_db_link||'('||
7451: ' p_dimension_level_short_name => :1'||
7452: ', x_dimension_short_name => :2'||
7453: ', x_dimension_name => :3'||
7454: ', x_dimension_level_name => :4'||

Line 7660: h_sql := 'BEGIN BSC_MIGRATION.Retrieve_Measure@'||g_db_link||'('||

7656:
7657: -- Retrieve the measure from the source system
7658: BSC_APPS.Write_Line_Log('Migrating existing source measure '||h_measure_short_name, BSC_APPS.OUTPUT_FILE);
7659:
7660: h_sql := 'BEGIN BSC_MIGRATION.Retrieve_Measure@'||g_db_link||'('||
7661: ' p_measure_short_name => :1'||
7662: ', x_measure_name => :2'||
7663: ', x_description => :3'||
7664: ', x_region_app_id => :4'||

Line 8291: x_source => 'BSC_MIGRATION.Migrate_BTable_With_Partitions');

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
8295: BSC_MESSAGE.Add (x_message => SQLERRM,

Line 8296: 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:
8300:

Line 8907: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Update_AK_Item_Props';

8903: WHEN NO_DATA_FOUND THEN
8904: ROLLBACK TO BscUpdAKItemProps;
8905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8906: IF (x_msg_data IS NOT NULL) THEN
8907: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Update_AK_Item_Props';
8908: ELSE
8909: x_msg_data := SQLERRM||' at BSC_MIGRATION.Update_AK_Item_Props ';
8910: END IF;
8911: WHEN OTHERS THEN

Line 8909: x_msg_data := SQLERRM||' at BSC_MIGRATION.Update_AK_Item_Props ';

8905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8906: IF (x_msg_data IS NOT NULL) THEN
8907: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Update_AK_Item_Props';
8908: ELSE
8909: x_msg_data := SQLERRM||' at BSC_MIGRATION.Update_AK_Item_Props ';
8910: END IF;
8911: WHEN OTHERS THEN
8912: ROLLBACK TO BscUpdAKItemProps;
8913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8915: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Update_AK_Item_Props ';

8911: WHEN OTHERS THEN
8912: ROLLBACK TO BscUpdAKItemProps;
8913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8914: IF (x_msg_data IS NOT NULL) THEN
8915: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Update_AK_Item_Props ';
8916: ELSE
8917: x_msg_data := SQLERRM||' at BSC_MIGRATION.Update_AK_Item_Props ';
8918: END IF;
8919: END Update_AK_Item_Props;

Line 8917: x_msg_data := SQLERRM||' at BSC_MIGRATION.Update_AK_Item_Props ';

8913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8914: IF (x_msg_data IS NOT NULL) THEN
8915: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Update_AK_Item_Props ';
8916: ELSE
8917: x_msg_data := SQLERRM||' at BSC_MIGRATION.Update_AK_Item_Props ';
8918: END IF;
8919: END Update_AK_Item_Props;
8920:
8921: /************************************************************************************

Line 9368: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';

9364: WHEN NO_DATA_FOUND THEN
9365: ROLLBACK TO BscSyncAKBscMetadata;
9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9367: IF (x_msg_data IS NOT NULL) THEN
9368: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9369: ELSE
9370: x_msg_data := SQLERRM||' at BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9371: END IF;
9372: WHEN OTHERS THEN

Line 9370: x_msg_data := SQLERRM||' at BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';

9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9367: IF (x_msg_data IS NOT NULL) THEN
9368: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9369: ELSE
9370: x_msg_data := SQLERRM||' at BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9371: END IF;
9372: WHEN OTHERS THEN
9373: ROLLBACK TO BscSyncAKBscMetadata;
9374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9376: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';

9372: WHEN OTHERS THEN
9373: ROLLBACK TO BscSyncAKBscMetadata;
9374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9375: IF (x_msg_data IS NOT NULL) THEN
9376: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9377: ELSE
9378: x_msg_data := SQLERRM||' at BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9379: END IF;
9380: END Synchronize_AK_BSC_Metadata;

Line 9378: x_msg_data := SQLERRM||' at BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';

9374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9375: IF (x_msg_data IS NOT NULL) THEN
9376: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9377: ELSE
9378: x_msg_data := SQLERRM||' at BSC_MIGRATION.Synchronize_AK_BSC_Metadata ';
9379: END IF;
9380: END Synchronize_AK_BSC_Metadata;
9381:
9382:

Line 9513: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9509: WHEN NO_DATA_FOUND THEN
9510: ROLLBACK TO BscCopyAKAttrMetadata;
9511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9512: IF (x_msg_data IS NOT NULL) THEN
9513: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9514: ELSE
9515: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9516: END IF;
9517: WHEN OTHERS THEN

Line 9515: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9512: IF (x_msg_data IS NOT NULL) THEN
9513: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9514: ELSE
9515: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9516: END IF;
9517: WHEN OTHERS THEN
9518: ROLLBACK TO BscCopyAKAttrMetadata;
9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9517: WHEN OTHERS THEN
9518: ROLLBACK TO BscCopyAKAttrMetadata;
9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9520: IF (x_msg_data IS NOT NULL) THEN
9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9522: ELSE
9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9524: END IF;
9525: END Copy_AK_Attributes_Metadata;

Line 9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';

9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9520: IF (x_msg_data IS NOT NULL) THEN
9521: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9522: ELSE
9523: x_msg_data := SQLERRM||' at BSC_MIGRATION.Copy_AK_Attributes_Metadata ';
9524: END IF;
9525: END Copy_AK_Attributes_Metadata;
9526:
9527: /************************************************************************************

Line 9610: AND region_application_id =BSC_MIGRATION.C_BSC_APP_ID;

9606: SELECT COUNT(0)
9607: INTO l_count
9608: FROM ak_regions
9609: WHERE region_code = p_Old_Region_Code
9610: AND region_application_id =BSC_MIGRATION.C_BSC_APP_ID;
9611:
9612: IF g_db_link IS NULL THEN
9613: --here we will call only the tables which are specific to simulation tree
9614: -- and also call the migration of ak region api

Line 9911: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Migrate_Sim_Data ';

9907: WHEN NO_DATA_FOUND THEN
9908: ROLLBACK TO BscMigSimDataPub;
9909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9910: IF (x_msg_data IS NOT NULL) THEN
9911: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Migrate_Sim_Data ';
9912: ELSE
9913: x_msg_data := SQLERRM||' at BSC_MIGRATION.Migrate_Sim_Data ';
9914: END IF;
9915: WHEN OTHERS THEN

Line 9913: x_msg_data := SQLERRM||' at BSC_MIGRATION.Migrate_Sim_Data ';

9909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9910: IF (x_msg_data IS NOT NULL) THEN
9911: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Migrate_Sim_Data ';
9912: ELSE
9913: x_msg_data := SQLERRM||' at BSC_MIGRATION.Migrate_Sim_Data ';
9914: END IF;
9915: WHEN OTHERS THEN
9916: ROLLBACK TO BscMigSimDataPub;
9917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9919: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Migrate_Sim_Data ';

9915: WHEN OTHERS THEN
9916: ROLLBACK TO BscMigSimDataPub;
9917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9918: IF (x_msg_data IS NOT NULL) THEN
9919: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Migrate_Sim_Data ';
9920: ELSE
9921: x_msg_data := SQLERRM||' at BSC_MIGRATION.Migrate_Sim_Data ';
9922: END IF;
9923: END Migrate_Sim_Data;

Line 9921: x_msg_data := SQLERRM||' at BSC_MIGRATION.Migrate_Sim_Data ';

9917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9918: IF (x_msg_data IS NOT NULL) THEN
9919: x_msg_data := x_msg_data||' -> BSC_MIGRATION.Migrate_Sim_Data ';
9920: ELSE
9921: x_msg_data := SQLERRM||' at BSC_MIGRATION.Migrate_Sim_Data ';
9922: END IF;
9923: END Migrate_Sim_Data;
9924:
9925:

Line 9927: END BSC_MIGRATION;

9923: END Migrate_Sim_Data;
9924:
9925:
9926:
9927: END BSC_MIGRATION;