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 FND_API

Line 2199: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2195: x_return_status => h_return_status,
2196: x_msg_count => h_msg_count,
2197: x_msg_data => h_msg_data
2198: );
2199: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2200: RAISE e_system_lock;
2201: END IF;
2202:
2203: --In the source, lock the indicators or scorecards or the whole system according to the filters

Line 2255: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2251: execute immediate h_sql
2252: using h_object_key, h_object_type, h_lock_type, h_query_time, h_program_id,
2253: h_user_id, h_cascade_lock_level, OUT h_return_status, OUT h_msg_count, OUT h_msg_data;
2254:
2255: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2256: RAISE e_system_lock;
2257: END IF;
2258: END LOOP;
2259:

Line 2282: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2278: execute immediate h_sql
2279: using h_object_key, h_object_type, h_lock_type, h_query_time, h_program_id,
2280: h_user_id, h_cascade_lock_level, OUT h_return_status, OUT h_msg_count, OUT h_msg_data;
2281:
2282: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2283: RAISE e_system_lock;
2284: END IF;
2285: END LOOP;
2286:

Line 2301: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2297: ',x_msg_data => :5); END;';
2298: execute immediate h_sql
2299: using h_program_id, h_user_id, OUT h_return_status, OUT h_msg_count, OUT h_msg_data;
2300:
2301: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2302: RAISE e_system_lock;
2303: END IF;
2304: END IF;
2305:

Line 2390: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2386: x_return_status => h_return_status,
2387: x_msg_count => h_msg_count,
2388: x_msg_data => h_msg_data
2389: );
2390: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2391: RAISE e_system_lock;
2392: END IF;
2393:
2394: --Fix bug#4873385 if the user BSC_APPS.apps_user_id does not exists in the source system

Line 2414: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2410: 'x_msg_data => :6); END;';
2411: -- Fix bug#4648979: Migration should run with iViewer in the source system. Passign new program -802
2412: execute immediate h_sql
2413: using -802, h_source_user_id, h_null, OUT h_return_status, OUT h_msg_count, OUT h_msg_data;
2414: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2415: RAISE e_system_lock;
2416: END IF;
2417:
2418: --LOCKING: Lock the whole target system and the kpis to be migrated in the source

Line 6248: p_commit => FND_API.G_FALSE

6244: FOR i IN 1..h_num_ids LOOP
6245: h_bis_dim_level_rec.dimension_level_id := h_arr_ids(i);
6246:
6247: BIS_DIMENSION_LEVEL_PUB.Delete_Dimension_Level (
6248: p_commit => FND_API.G_FALSE
6249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
6250: ,p_Dimension_Level_Rec => h_bis_dim_level_rec
6251: ,x_return_status => h_return_status
6252: ,x_error_Tbl => h_error_tbl

Line 6249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

6245: h_bis_dim_level_rec.dimension_level_id := h_arr_ids(i);
6246:
6247: BIS_DIMENSION_LEVEL_PUB.Delete_Dimension_Level (
6248: p_commit => FND_API.G_FALSE
6249: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
6250: ,p_Dimension_Level_Rec => h_bis_dim_level_rec
6251: ,x_return_status => h_return_status
6252: ,x_error_Tbl => h_error_tbl
6253: );

Line 6318: p_commit => FND_API.G_FALSE

6314: FOR i IN 1..h_num_ids LOOP
6315: h_bis_dimension_rec.dimension_id := h_arr_ids(i);
6316:
6317: BIS_DIMENSION_PUB.Delete_Dimension(
6318: p_commit => FND_API.G_FALSE
6319: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
6320: ,p_Dimension_Rec => h_bis_dimension_rec
6321: ,x_return_status => h_return_status
6322: ,x_error_Tbl => h_error_tbl

Line 6319: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

6315: h_bis_dimension_rec.dimension_id := h_arr_ids(i);
6316:
6317: BIS_DIMENSION_PUB.Delete_Dimension(
6318: p_commit => FND_API.G_FALSE
6319: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
6320: ,p_Dimension_Rec => h_bis_dimension_rec
6321: ,x_return_status => h_return_status
6322: ,x_error_Tbl => h_error_tbl
6323: );

Line 6396: ,p_commit => FND_API.G_FALSE

6392: h_measure_rec.measure_id := h_arr_ids(i);
6393:
6394: BIS_MEASURE_PUB.Delete_Measure(
6395: p_api_version => 1.0
6396: ,p_commit => FND_API.G_FALSE
6397: ,p_Measure_Rec => h_measure_rec
6398: ,x_return_status => h_return_status
6399: ,x_error_Tbl => h_error_tbl);
6400: END LOOP;

Line 7335: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7331: using h_dimension_short_name, OUT h_dimension_name,
7332: OUT h_description, OUT h_application_id,
7333: OUT h_return_status, OUT h_error_msg, OUT h_hide;
7334:
7335: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7336: BSC_APPS.Write_Line_Log('Error retrieving dimension: '||h_error_msg, BSC_APPS.OUTPUT_FILE);
7337: ELSE
7338: h_dimension_rec.Dimension_Short_Name := h_dimension_short_name;
7339: h_dimension_rec.Dimension_Name := h_dimension_name;

Line 7355: , p_commit => FND_API.G_FALSE

7351: IF h_count = 0 THEN
7352: -- Dimension does not exists, create it
7353: BIS_DIMENSION_PUB.Create_Dimension(
7354: p_api_version => 1.0
7355: , p_commit => FND_API.G_FALSE
7356: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7357: , p_Dimension_Rec => h_dimension_rec
7358: , x_return_status => h_return_status
7359: , x_error_Tbl => h_error_tbl

Line 7356: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7352: -- Dimension does not exists, create it
7353: BIS_DIMENSION_PUB.Create_Dimension(
7354: p_api_version => 1.0
7355: , p_commit => FND_API.G_FALSE
7356: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7357: , p_Dimension_Rec => h_dimension_rec
7358: , x_return_status => h_return_status
7359: , x_error_Tbl => h_error_tbl
7360: );

Line 7363: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7359: , x_error_Tbl => h_error_tbl
7360: );
7361: commit;
7362:
7363: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7364: BSC_APPS.Write_Line_Log('Error creating dimension: '||h_error_tbl(1).Error_Description, BSC_APPS.OUTPUT_FILE);
7365: END IF;
7366: ELSE
7367: -- Dimension exists, update it

Line 7370: , p_commit => FND_API.G_FALSE

7366: ELSE
7367: -- Dimension exists, update it
7368: BIS_DIMENSION_PUB.Update_Dimension(
7369: p_api_version => 1.0
7370: , p_commit => FND_API.G_FALSE
7371: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7372: , p_Dimension_Rec => h_dimension_rec
7373: , x_return_status => h_return_status
7374: , x_error_Tbl => h_error_tbl

Line 7371: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7367: -- Dimension exists, update it
7368: BIS_DIMENSION_PUB.Update_Dimension(
7369: p_api_version => 1.0
7370: , p_commit => FND_API.G_FALSE
7371: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7372: , p_Dimension_Rec => h_dimension_rec
7373: , x_return_status => h_return_status
7374: , x_error_Tbl => h_error_tbl
7375: );

Line 7378: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7374: , x_error_Tbl => h_error_tbl
7375: );
7376: commit;
7377:
7378: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7379: BSC_APPS.Write_Line_Log('Error updating dimension: '||h_error_tbl(1).Error_Description, BSC_APPS.OUTPUT_FILE);
7380: END IF;
7381: END IF;
7382: END IF;

Line 7484: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7480: OUT h_view_object_name, OUT h_default_values_api, OUT h_enabled,
7481: OUT h_drill_to_form_function, OUT h_primary_dim,
7482: OUT h_return_status, OUT h_error_msg, OUT h_hide;
7483:
7484: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7485: BSC_APPS.Write_Line_Log('Error retrieving dimension object: '||h_error_msg, BSC_APPS.OUTPUT_FILE);
7486: ELSE
7487: h_dimension_level_rec.dimension_level_short_name := h_dimension_level_short_name;
7488: h_dimension_level_rec.dimension_short_name := h_dimension_short_name;

Line 7546: , p_commit => FND_API.G_FALSE

7542: IF h_count = 0 THEN
7543: -- Dimension level does not exists, create it
7544: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level(
7545: p_api_version => 1.0
7546: , p_commit => FND_API.G_FALSE
7547: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7548: , p_Dimension_Level_Rec => h_dimension_level_rec
7549: , x_return_status => h_return_status
7550: , x_error_Tbl => h_error_tbl

Line 7547: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7543: -- Dimension level does not exists, create it
7544: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level(
7545: p_api_version => 1.0
7546: , p_commit => FND_API.G_FALSE
7547: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7548: , p_Dimension_Level_Rec => h_dimension_level_rec
7549: , x_return_status => h_return_status
7550: , x_error_Tbl => h_error_tbl
7551: );

Line 7554: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7550: , x_error_Tbl => h_error_tbl
7551: );
7552: commit;
7553:
7554: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7555: BSC_APPS.Write_Line_Log('Error creating dimension object: '||h_error_tbl(1).Error_Description,
7556: BSC_APPS.OUTPUT_FILE);
7557: END IF;
7558: ELSE

Line 7562: , p_commit => FND_API.G_FALSE

7558: ELSE
7559: -- Dimension level exists, update it
7560: BIS_DIMENSION_LEVEL_PUB.Update_Dimension_Level(
7561: p_api_version => 1.0
7562: , p_commit => FND_API.G_FALSE
7563: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7564: , p_Dimension_Level_Rec => h_dimension_level_rec
7565: , x_return_status => h_return_status
7566: , x_error_Tbl => h_error_tbl

Line 7563: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

7559: -- Dimension level exists, update it
7560: BIS_DIMENSION_LEVEL_PUB.Update_Dimension_Level(
7561: p_api_version => 1.0
7562: , p_commit => FND_API.G_FALSE
7563: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
7564: , p_Dimension_Level_Rec => h_dimension_level_rec
7565: , x_return_status => h_return_status
7566: , x_error_Tbl => h_error_tbl
7567: );

Line 7570: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7566: , x_error_Tbl => h_error_tbl
7567: );
7568: commit;
7569:
7570: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7571: BSC_APPS.Write_Line_Log('Error updating dimension level: '||h_error_tbl(1).Error_Description,
7572: BSC_APPS.OUTPUT_FILE);
7573: END IF;
7574: END IF;

Line 7710: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7706: OUT h_dimension6_name, OUT h_dimension7_short_name, OUT h_dimension7_name,
7707: OUT h_unit_of_measure_class, OUT h_application_id, OUT h_is_validate,
7708: OUT h_func_area_short_name, OUT h_return_status, OUT h_error_msg;
7709:
7710: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7711: BSC_APPS.Write_Line_Log('Error retrieving measure: '||h_error_msg, BSC_APPS.OUTPUT_FILE);
7712: ELSE
7713: h_measure_rec.measure_short_name := h_measure_short_name;
7714: h_measure_rec.measure_name := h_measure_name;

Line 7784: , p_commit => FND_API.G_FALSE

7780: IF h_count = 0 THEN
7781: -- Measure does not exists, create it
7782: BIS_MEASURE_PUB.Create_Measure(
7783: p_api_version => 1.0
7784: , p_commit => FND_API.G_FALSE
7785: , p_Measure_Rec => h_measure_rec
7786: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
7787: , x_return_status => h_return_status
7788: , x_error_Tbl => h_error_tbl

Line 7792: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7788: , x_error_Tbl => h_error_tbl
7789: );
7790: commit;
7791:
7792: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7793: BSC_APPS.Write_Line_Log('Error creating measure: '||h_error_tbl(1).Error_Description,
7794: BSC_APPS.OUTPUT_FILE);
7795: END IF;
7796: ELSE

Line 7800: , p_commit => FND_API.G_FALSE

7796: ELSE
7797: -- Measure exists, update it
7798: BIS_MEASURE_PUB.Update_Measure(
7799: p_api_version => 1.0
7800: , p_commit => FND_API.G_FALSE
7801: , p_Measure_Rec => h_measure_rec
7802: , p_owner => BIS_UTILITIES_PUB.G_CUSTOM_OWNER
7803: , x_return_status => h_return_status
7804: , x_error_Tbl => h_error_tbl

Line 7808: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7804: , x_error_Tbl => h_error_tbl
7805: );
7806: commit;
7807:
7808: IF h_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7809: BSC_APPS.Write_Line_Log('Error updating measure: '||h_error_tbl(1).Error_Description,
7810: BSC_APPS.OUTPUT_FILE);
7811: END IF;
7812: END IF;

Line 7850: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7846: ,x_return_status => x_return_status
7847: ,x_error_Tbl => h_error_tbl
7848: );
7849:
7850: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7851: RAISE e_error;
7852: END IF;
7853:
7854: x_dimension_name := h_dimension_rec_out.dimension_name;

Line 7864: x_return_status := FND_API.G_RET_STS_ERROR;

7860: WHEN e_error THEN
7861: x_error_msg := h_error_tbl(1).Error_Description;
7862: WHEN others THEN
7863: x_error_msg := SQLERRM;
7864: x_return_status := FND_API.G_RET_STS_ERROR;
7865: END Retrieve_Dimension;
7866:
7867:
7868: /*===========================================================================+

Line 7913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

7909: ,x_return_status => x_return_status
7910: ,x_error_Tbl => h_error_tbl
7911: );
7912:
7913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7914: RAISE e_error;
7915: END IF;
7916:
7917: x_dimension_short_name := h_dimension_level_rec_out.dimension_short_name;

Line 7942: x_return_status := FND_API.G_RET_STS_ERROR;

7938: WHEN e_error THEN
7939: x_error_msg := h_error_tbl(1).Error_Description;
7940: WHEN others THEN
7941: x_error_msg := SQLERRM;
7942: x_return_status := FND_API.G_RET_STS_ERROR;
7943: END Retrieve_Dimension_Level;
7944:
7945:
7946: /*===========================================================================+

Line 7997: h_all_info := FND_API.G_TRUE;

7993: BEGIN
7994:
7995: h_measure_rec_in.measure_short_name := p_measure_short_name;
7996: h_api_version := 1.0;
7997: h_all_info := FND_API.G_TRUE;
7998:
7999: BIS_MEASURE_PUB.Retrieve_Measure(
8000: p_api_version => h_api_version
8001: , p_Measure_Rec => h_measure_rec_in

Line 8008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

8004: , x_return_status => x_return_status
8005: , x_error_Tbl => h_error_tbl
8006: );
8007:
8008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
8009: RAISE e_error;
8010: END IF;
8011:
8012: x_measure_name := h_measure_rec_out.measure_name;

Line 8050: x_return_status := FND_API.G_RET_STS_ERROR;

8046: WHEN e_error THEN
8047: x_error_msg := h_error_tbl(1).Error_Description;
8048: WHEN others THEN
8049: x_error_msg := SQLERRM;
8050: x_return_status := FND_API.G_RET_STS_ERROR;
8051: END Retrieve_Measure;
8052:
8053:
8054: -- ENH_B_TABLES_PERF: new function

Line 8444: IF (h_return_status IS NOT NULL) AND (h_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8440: ,x_msg_count => h_msg_count
8441: ,x_msg_data => h_msg_data
8442: );
8443:
8444: IF (h_return_status IS NOT NULL) AND (h_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8445: RAISE e_delete_ak_region_error;
8446: END IF;
8447: END IF;
8448:

Line 8496: p_commit => FND_API.G_FALSE

8492: h_attribute34, h_attribute35, h_attribute36, h_attribute37, h_attribute38, h_attribute39,
8493: h_attribute40;
8494: IF h_cursor%FOUND THEN
8495: BIS_REGION_EXTENSION_PVT.CREATE_REGION_EXTN_RECORD(
8496: p_commit => FND_API.G_FALSE
8497: ,pRegionCode => p_region_code
8498: ,pRegionAppId => h_region_application_id
8499: ,pAttribute16 => h_attribute16
8500: ,pAttribute17 => h_attribute17

Line 8837: p_commit IN VARCHAR2 := FND_API.G_FALSE

8833: -- Function :
8834: ************************************************************************************/
8835:
8836: PROCEDURE Update_AK_Item_Props (
8837: p_commit IN VARCHAR2 := FND_API.G_FALSE
8838: ,p_region_code IN VARCHAR2
8839: ,p_region_application_id IN NUMBER
8840: ,p_Attribute_Code IN AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE
8841: ,p_Attribute_Application_Id IN AK_REGION_ITEMS.ATTRIBUTE_APPLICATION_ID%TYPE

Line 8851: x_return_status := FND_API.G_RET_STS_SUCCESS;

8847:
8848: l_Ak_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
8849: BEGIN
8850: FND_MSG_PUB.INITIALIZE;
8851: x_return_status := FND_API.G_RET_STS_SUCCESS;
8852:
8853: SAVEPOINT BscUpdAKItemProps;
8854: BIS_AK_REGION_PUB.Get_Region_Item_Rec (
8855: p_region_code => p_region_code

Line 8864: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8860: ,x_return_status => x_return_status
8861: ,x_msg_count => x_msg_count
8862: ,x_msg_data => x_msg_data
8863: );
8864: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8866: END IF;
8867:
8868: l_Ak_Region_Item_Rec.Measure_Level := p_Attribute2;

Line 8865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8861: ,x_msg_count => x_msg_count
8862: ,x_msg_data => x_msg_data
8863: );
8864: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8866: END IF;
8867:
8868: l_Ak_Region_Item_Rec.Measure_Level := p_Attribute2;
8869:

Line 8878: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

8874: ,x_return_status => x_return_status
8875: ,x_msg_count => x_msg_count
8876: ,x_msg_data => x_msg_data
8877: );
8878: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8880: END IF;
8881:
8882: IF (p_commit = FND_API.G_TRUE) THEN

Line 8879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

8875: ,x_msg_count => x_msg_count
8876: ,x_msg_data => x_msg_data
8877: );
8878: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8880: END IF;
8881:
8882: IF (p_commit = FND_API.G_TRUE) THEN
8883: COMMIT;

Line 8882: IF (p_commit = FND_API.G_TRUE) THEN

8878: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8880: END IF;
8881:
8882: IF (p_commit = FND_API.G_TRUE) THEN
8883: COMMIT;
8884: END IF;
8885:
8886: EXCEPTION

Line 8887: WHEN FND_API.G_EXC_ERROR THEN

8883: COMMIT;
8884: END IF;
8885:
8886: EXCEPTION
8887: WHEN FND_API.G_EXC_ERROR THEN
8888: ROLLBACK TO BscUpdAKItemProps;
8889: FND_MSG_PUB.Count_And_Get
8890: ( p_encoded => FND_API.G_FALSE
8891: , p_count => x_msg_count

Line 8890: ( p_encoded => FND_API.G_FALSE

8886: EXCEPTION
8887: WHEN FND_API.G_EXC_ERROR THEN
8888: ROLLBACK TO BscUpdAKItemProps;
8889: FND_MSG_PUB.Count_And_Get
8890: ( p_encoded => FND_API.G_FALSE
8891: , p_count => x_msg_count
8892: , p_data => x_msg_data
8893: );
8894: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8894: x_return_status := FND_API.G_RET_STS_ERROR;

8890: ( p_encoded => FND_API.G_FALSE
8891: , p_count => x_msg_count
8892: , p_data => x_msg_data
8893: );
8894: x_return_status := FND_API.G_RET_STS_ERROR;
8895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8896: ROLLBACK TO BscUpdAKItemProps;
8897: FND_MSG_PUB.Count_And_Get
8898: ( p_encoded => FND_API.G_FALSE

Line 8895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

8891: , p_count => x_msg_count
8892: , p_data => x_msg_data
8893: );
8894: x_return_status := FND_API.G_RET_STS_ERROR;
8895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8896: ROLLBACK TO BscUpdAKItemProps;
8897: FND_MSG_PUB.Count_And_Get
8898: ( p_encoded => FND_API.G_FALSE
8899: , p_count => x_msg_count

Line 8898: ( p_encoded => FND_API.G_FALSE

8894: x_return_status := FND_API.G_RET_STS_ERROR;
8895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8896: ROLLBACK TO BscUpdAKItemProps;
8897: FND_MSG_PUB.Count_And_Get
8898: ( p_encoded => FND_API.G_FALSE
8899: , p_count => x_msg_count
8900: , p_data => x_msg_data
8901: );
8902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 8902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8898: ( p_encoded => FND_API.G_FALSE
8899: , p_count => x_msg_count
8900: , p_data => x_msg_data
8901: );
8902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 8905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8901: );
8902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 ';

Line 8913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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 ';

Line 8932: p_commit IN VARCHAR2 := FND_API.G_FALSE

8928: ************************************************************************************/
8929:
8930:
8931: PROCEDURE Synchronize_AK_BSC_Metadata (
8932: p_commit IN VARCHAR2 := FND_API.G_FALSE
8933: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
8934: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
8935: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
8936: ,p_Old_Dim_Levels IN FND_TABLE_OF_NUMBER

Line 8985: x_return_status := FND_API.G_RET_STS_SUCCESS;

8981: property_code = 'S_NODE_ID';
8982:
8983: BEGIN
8984: FND_MSG_PUB.INITIALIZE;
8985: x_return_status := FND_API.G_RET_STS_SUCCESS;
8986:
8987: SAVEPOINT BscSyncAKBscMetadata;
8988: -- DataSet Sync Up
8989: l_sql := 'SELECT ak_item.region_code,ak_item.region_application_id,ak_item.attribute_code,ak_item.attribute_application_id, i.comparison_source,i.enable_link, ';

Line 9031: p_commit => FND_API.G_FALSE

9027: END IF;
9028:
9029: IF l_New_Attribute2 <> l_Attribute2 OR p_New_DataSet_Map(i) <> p_Old_DataSet_Map(i) THEN
9030: Update_AK_Item_Props (
9031: p_commit => FND_API.G_FALSE
9032: ,p_region_code => p_short_name
9033: ,p_region_application_id => l_Region_Att_Id
9034: ,p_Attribute_Code => l_Item_Att_Code
9035: ,p_Attribute_Application_Id => l_Item_Att_App_Id

Line 9041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9037: ,x_return_status => x_return_status
9038: ,x_msg_count => x_msg_count
9039: ,x_msg_data => x_msg_data
9040: );
9041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9043: END IF;
9044:
9045: UPDATE

Line 9042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9038: ,x_msg_count => x_msg_count
9039: ,x_msg_data => x_msg_data
9040: );
9041: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9043: END IF;
9044:
9045: UPDATE
9046: ak_region_items_tl ak_item

Line 9155: p_commit => FND_API.G_FALSE

9151: periodicity_id = p_New_Periodicities(i);
9152:
9153: l_New_Attribute2 := l_Calendar_Sht_Name || '+' || l_Periodicity_Sht_Name;
9154: Update_AK_Item_Props (
9155: p_commit => FND_API.G_FALSE
9156: ,p_region_code => p_short_name
9157: ,p_region_application_id => l_Region_Att_Id
9158: ,p_Attribute_Code => l_Item_Att_Code
9159: ,p_Attribute_Application_Id => l_Item_Att_App_Id

Line 9165: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9161: ,x_return_status => x_return_status
9162: ,x_msg_count => x_msg_count
9163: ,x_msg_data => x_msg_data
9164: );
9165: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9167: END IF;
9168:
9169: l_Retain_Dim_Att2.EXTEND(1);

Line 9166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9162: ,x_msg_count => x_msg_count
9163: ,x_msg_data => x_msg_data
9164: );
9165: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9167: END IF;
9168:
9169: l_Retain_Dim_Att2.EXTEND(1);
9170: l_Retain_Dim_Att2(l_Retain_Dim_Att2.LAST) := l_Item_Att_Code;

Line 9254: p_commit => FND_API.G_FALSE

9250:
9251: IF l_Dim_Lev_Sht_Name IS NOT NULL THEN
9252: l_New_Attribute2 := l_Dim_Short_Name||'+'||l_Dim_Lev_Sht_Name;
9253: Update_AK_Item_Props (
9254: p_commit => FND_API.G_FALSE
9255: ,p_region_code => p_short_name
9256: ,p_region_application_id => l_Region_Att_Id
9257: ,p_Attribute_Code => l_Item_Att_Code
9258: ,p_Attribute_Application_Id => l_Item_Att_App_Id

Line 9264: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9260: ,x_return_status => x_return_status
9261: ,x_msg_count => x_msg_count
9262: ,x_msg_data => x_msg_data
9263: );
9264: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9266: END IF;
9267:
9268: l_Retain_Dim_Att2.EXTEND(1);

Line 9265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9261: ,x_msg_count => x_msg_count
9262: ,x_msg_data => x_msg_data
9263: );
9264: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9266: END IF;
9267:
9268: l_Retain_Dim_Att2.EXTEND(1);
9269: l_Retain_Dim_Att2(l_Retain_Dim_Att2.LAST) := l_Item_Att_Code;

Line 9337: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9333: ,x_return_status => x_return_status
9334: ,x_msg_count => x_msg_count
9335: ,x_msg_data => x_msg_data
9336: );
9337: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9339: END IF;
9340:
9341: END IF;

Line 9338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9334: ,x_msg_count => x_msg_count
9335: ,x_msg_data => x_msg_data
9336: );
9337: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9339: END IF;
9340:
9341: END IF;
9342:

Line 9343: IF (p_commit = FND_API.G_TRUE) THEN

9339: END IF;
9340:
9341: END IF;
9342:
9343: IF (p_commit = FND_API.G_TRUE) THEN
9344: COMMIT;
9345: END IF;
9346:
9347: EXCEPTION

Line 9348: WHEN FND_API.G_EXC_ERROR THEN

9344: COMMIT;
9345: END IF;
9346:
9347: EXCEPTION
9348: WHEN FND_API.G_EXC_ERROR THEN
9349: ROLLBACK TO BscSyncAKBscMetadata;
9350: FND_MSG_PUB.Count_And_Get
9351: ( p_encoded => FND_API.G_FALSE
9352: , p_count => x_msg_count

Line 9351: ( p_encoded => FND_API.G_FALSE

9347: EXCEPTION
9348: WHEN FND_API.G_EXC_ERROR THEN
9349: ROLLBACK TO BscSyncAKBscMetadata;
9350: FND_MSG_PUB.Count_And_Get
9351: ( p_encoded => FND_API.G_FALSE
9352: , p_count => x_msg_count
9353: , p_data => x_msg_data
9354: );
9355: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9355: x_return_status := FND_API.G_RET_STS_ERROR;

9351: ( p_encoded => FND_API.G_FALSE
9352: , p_count => x_msg_count
9353: , p_data => x_msg_data
9354: );
9355: x_return_status := FND_API.G_RET_STS_ERROR;
9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9357: ROLLBACK TO BscSyncAKBscMetadata;
9358: FND_MSG_PUB.Count_And_Get
9359: ( p_encoded => FND_API.G_FALSE

Line 9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9352: , p_count => x_msg_count
9353: , p_data => x_msg_data
9354: );
9355: x_return_status := FND_API.G_RET_STS_ERROR;
9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9357: ROLLBACK TO BscSyncAKBscMetadata;
9358: FND_MSG_PUB.Count_And_Get
9359: ( p_encoded => FND_API.G_FALSE
9360: , p_count => x_msg_count

Line 9359: ( p_encoded => FND_API.G_FALSE

9355: x_return_status := FND_API.G_RET_STS_ERROR;
9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9357: ROLLBACK TO BscSyncAKBscMetadata;
9358: FND_MSG_PUB.Count_And_Get
9359: ( p_encoded => FND_API.G_FALSE
9360: , p_count => x_msg_count
9361: , p_data => x_msg_data
9362: );
9363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9359: ( p_encoded => FND_API.G_FALSE
9360: , p_count => x_msg_count
9361: , p_data => x_msg_data
9362: );
9363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 9366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9362: );
9363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 ';

Line 9374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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 ';

Line 9392: p_commit IN VARCHAR2 := FND_API.G_FALSE

9388: ************************************************************************************/
9389:
9390:
9391: PROCEDURE Copy_AK_Attributes_Metadata (
9392: p_commit IN VARCHAR2 := FND_API.G_FALSE
9393: ,p_short_name IN BSC_KPIS_B.short_name%TYPE
9394: ,x_return_status OUT NOCOPY VARCHAR2
9395: ,x_msg_count OUT NOCOPY NUMBER
9396: ,x_msg_data OUT NOCOPY VARCHAR2

Line 9410: x_return_status := FND_API.G_RET_STS_SUCCESS;

9406: c_cursor c_cur_type;
9407:
9408: BEGIN
9409: FND_MSG_PUB.INITIALIZE;
9410: x_return_status := FND_API.G_RET_STS_SUCCESS;
9411:
9412: SAVEPOINT BscCopyAKAttrMetadata;
9413: -- DataSet Sync Up
9414: l_sql := 'SELECT attribute_code,attribute_application_id,item_style,attribute_category ';

Line 9488: IF (p_commit = FND_API.G_TRUE) THEN

9484: END LOOP;
9485: CLOSE c_cursor;
9486:
9487:
9488: IF (p_commit = FND_API.G_TRUE) THEN
9489: COMMIT;
9490: END IF;
9491:
9492: EXCEPTION

Line 9493: WHEN FND_API.G_EXC_ERROR THEN

9489: COMMIT;
9490: END IF;
9491:
9492: EXCEPTION
9493: WHEN FND_API.G_EXC_ERROR THEN
9494: ROLLBACK TO BscCopyAKAttrMetadata;
9495: FND_MSG_PUB.Count_And_Get
9496: ( p_encoded => FND_API.G_FALSE
9497: , p_count => x_msg_count

Line 9496: ( p_encoded => FND_API.G_FALSE

9492: EXCEPTION
9493: WHEN FND_API.G_EXC_ERROR THEN
9494: ROLLBACK TO BscCopyAKAttrMetadata;
9495: FND_MSG_PUB.Count_And_Get
9496: ( p_encoded => FND_API.G_FALSE
9497: , p_count => x_msg_count
9498: , p_data => x_msg_data
9499: );
9500: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9500: x_return_status := FND_API.G_RET_STS_ERROR;

9496: ( p_encoded => FND_API.G_FALSE
9497: , p_count => x_msg_count
9498: , p_data => x_msg_data
9499: );
9500: x_return_status := FND_API.G_RET_STS_ERROR;
9501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9502: ROLLBACK TO BscCopyAKAttrMetadata;
9503: FND_MSG_PUB.Count_And_Get
9504: ( p_encoded => FND_API.G_FALSE

Line 9501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9497: , p_count => x_msg_count
9498: , p_data => x_msg_data
9499: );
9500: x_return_status := FND_API.G_RET_STS_ERROR;
9501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9502: ROLLBACK TO BscCopyAKAttrMetadata;
9503: FND_MSG_PUB.Count_And_Get
9504: ( p_encoded => FND_API.G_FALSE
9505: , p_count => x_msg_count

Line 9504: ( p_encoded => FND_API.G_FALSE

9500: x_return_status := FND_API.G_RET_STS_ERROR;
9501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9502: ROLLBACK TO BscCopyAKAttrMetadata;
9503: FND_MSG_PUB.Count_And_Get
9504: ( p_encoded => FND_API.G_FALSE
9505: , p_count => x_msg_count
9506: , p_data => x_msg_data
9507: );
9508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9504: ( p_encoded => FND_API.G_FALSE
9505: , p_count => x_msg_count
9506: , p_data => x_msg_data
9507: );
9508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 9511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9507: );
9508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 ';

Line 9519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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 ';

Line 9539: p_commit IN VARCHAR2 := FND_API.G_FALSE

9535: ************************************************************************************/
9536:
9537: PROCEDURE Migrate_Sim_Data
9538: (
9539: p_commit IN VARCHAR2 := FND_API.G_FALSE
9540: ,p_Trg_indicator IN BSC_KPIS_B.indicator%TYPE
9541: ,p_Src_indicator IN BSC_KPIS_B.indicator%TYPE
9542: ,p_Region_Code IN VARCHAR2
9543: ,p_Old_Region_Code IN BSC_KPIS_B.short_name%TYPE

Line 9602: x_return_status := FND_API.G_RET_STS_SUCCESS;

9598: --First we will check if the region_code exists on the target system
9599: -- if yes then we cannot migrate and log it
9600: -- if the short_name is not there
9601: FND_MSG_PUB.INITIALIZE;
9602: x_return_status := FND_API.G_RET_STS_SUCCESS;
9603:
9604: SAVEPOINT BscMigSimDataPub;
9605: g_db_link := BSC_DESIGNER_PVT.g_DbLink_Name;
9606: SELECT COUNT(0)

Line 9618: p_commit => FND_API.G_FALSE

9614: -- and also call the migration of ak region api
9615: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_Trg_indicator;
9616: BSC_KPI_PUB.Delete_Sim_Tree_Data
9617: (
9618: p_commit => FND_API.G_FALSE
9619: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
9620: , x_return_status => x_return_status
9621: , x_msg_count => x_msg_count
9622: , x_msg_data => x_msg_data

Line 9624: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9620: , x_return_status => x_return_status
9621: , x_msg_count => x_msg_count
9622: , x_msg_data => x_msg_data
9623: );
9624: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9625: BSC_APPS.Write_Line_Log('Error Deleting SimTree Data ', BSC_APPS.OUTPUT_FILE);
9626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9627: END IF;
9628: END IF;

Line 9626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9622: , x_msg_data => x_msg_data
9623: );
9624: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9625: BSC_APPS.Write_Line_Log('Error Deleting SimTree Data ', BSC_APPS.OUTPUT_FILE);
9626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9627: END IF;
9628: END IF;
9629:
9630: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array

Line 9632: p_copy_Ak_Tables => FND_API.G_TRUE

9628: END IF;
9629:
9630: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
9631: (
9632: p_copy_Ak_Tables => FND_API.G_TRUE
9633: ,x_Table_Number => l_Table_Number
9634: ,x_kpi_metadata_tables => l_kpi_metadata_tables
9635: );
9636:

Line 9734: p_commit => FND_API.G_FALSE

9730:
9731: IF l_kpi_metadata_tables(h_i).mls_table IS NOT NULL AND
9732: l_kpi_metadata_tables(h_i).mls_table = bsc_utility.YES THEN
9733: BSC_DESIGNER_PVT.Process_TL_Table(
9734: p_commit => FND_API.G_FALSE
9735: ,p_DbLink_Name => g_db_link
9736: ,p_Table_Name => l_table_name
9737: ,p_Table_column => l_key_name
9738: ,p_Target_Value => p_Trg_indicator

Line 9744: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9740: ,x_return_status => x_return_status
9741: ,x_msg_count => x_msg_count
9742: ,x_msg_data => x_msg_data
9743: );
9744: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9746: END IF;
9747: END IF;
9748:

Line 9745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9741: ,x_msg_count => x_msg_count
9742: ,x_msg_data => x_msg_data
9743: );
9744: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9746: END IF;
9747: END IF;
9748:
9749: END IF;

Line 9774: p_commit => FND_API.G_FALSE

9770: );
9771: IF l_kpi_metadata_tables(h_i).mls_table IS NOT NULL AND
9772: l_kpi_metadata_tables(h_i).mls_table = bsc_utility.YES THEN
9773: BSC_DESIGNER_PVT.Process_TL_Table(
9774: p_commit => FND_API.G_FALSE
9775: ,p_DbLink_Name => g_db_link
9776: ,p_Table_Name => l_kpi_metadata_tables(h_i).table_name
9777: ,p_Table_column => l_kpi_metadata_tables(h_i).table_column
9778: ,p_Target_Value => NULL

Line 9784: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9780: ,x_return_status => x_return_status
9781: ,x_msg_count => x_msg_count
9782: ,x_msg_data => x_msg_data
9783: );
9784: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9786: END IF;
9787: END IF;
9788: ELSIF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND

Line 9785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9781: ,x_msg_count => x_msg_count
9782: ,x_msg_data => x_msg_data
9783: );
9784: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9786: END IF;
9787: END IF;
9788: ELSIF(l_kpi_metadata_tables(h_i).duplicate_data = bsc_utility.YES AND
9789: l_kpi_metadata_tables(h_i).table_type=BSC_SIMULATION_VIEW_PVT.C_FORM_TABLE)THEN

Line 9803: p_commit => FND_API.G_FALSE

9799: );
9800: IF l_kpi_metadata_tables(h_i).mls_table IS NOT NULL AND
9801: l_kpi_metadata_tables(h_i).mls_table = bsc_utility.YES THEN
9802: BSC_DESIGNER_PVT.Process_TL_Table(
9803: p_commit => FND_API.G_FALSE
9804: ,p_DbLink_Name => g_db_link
9805: ,p_Table_Name => l_kpi_metadata_tables(h_i).table_name
9806: ,p_Table_column => 'FUNCTION_ID'
9807: ,p_Target_Value => l_new_function_id

Line 9813: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9809: ,x_return_status => x_return_status
9810: ,x_msg_count => x_msg_count
9811: ,x_msg_data => x_msg_data
9812: );
9813: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9815: END IF;
9816:
9817: END IF;

Line 9814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9810: ,x_msg_count => x_msg_count
9811: ,x_msg_data => x_msg_data
9812: );
9813: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9815: END IF;
9816:
9817: END IF;
9818: END IF;

Line 9850: p_commit => FND_API.G_FALSE

9846: IF p_Region_Code IS NOT NULL THEN
9847: -- By design there is a form function and ak region called as the short name
9848: BSC_APPS.Write_Line_Log('Migrating report '||p_Old_Region_Code, BSC_APPS.OUTPUT_FILE);
9849: Synchronize_AK_BSC_Metadata (
9850: p_commit => FND_API.G_FALSE
9851: ,p_Src_indicator => p_Src_indicator
9852: ,p_Trg_indicator => p_Trg_indicator
9853: ,p_short_name => p_Region_Code
9854: ,p_Old_Dim_Levels => p_Old_Dim_Levels

Line 9867: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

9863: ,x_return_status => x_return_status
9864: ,x_msg_count => x_msg_count
9865: ,x_msg_data => x_msg_data
9866: );
9867: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9869: END IF;
9870:
9871: UPDATE

Line 9868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

9864: ,x_msg_count => x_msg_count
9865: ,x_msg_data => x_msg_data
9866: );
9867: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9868: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9869: END IF;
9870:
9871: UPDATE
9872: ak_regions

Line 9878: p_commit => FND_API.G_FALSE

9874: attribute12 = p_Region_Code
9875: WHERE
9876: region_code = p_Region_Code;
9877: Copy_AK_Attributes_Metadata (
9878: p_commit => FND_API.G_FALSE
9879: ,p_short_name => p_Old_Region_Code
9880: ,x_return_status => x_return_status
9881: ,x_msg_count => x_msg_count
9882: ,x_msg_data => x_msg_data

Line 9886: IF (p_commit = FND_API.G_TRUE) THEN

9882: ,x_msg_data => x_msg_data
9883: );
9884: END IF;
9885:
9886: IF (p_commit = FND_API.G_TRUE) THEN
9887: COMMIT;
9888: END IF;
9889:
9890: EXCEPTION

Line 9891: WHEN FND_API.G_EXC_ERROR THEN

9887: COMMIT;
9888: END IF;
9889:
9890: EXCEPTION
9891: WHEN FND_API.G_EXC_ERROR THEN
9892: ROLLBACK TO BscMigSimDataPub;
9893: FND_MSG_PUB.Count_And_Get
9894: ( p_encoded => FND_API.G_FALSE
9895: , p_count => x_msg_count

Line 9894: ( p_encoded => FND_API.G_FALSE

9890: EXCEPTION
9891: WHEN FND_API.G_EXC_ERROR THEN
9892: ROLLBACK TO BscMigSimDataPub;
9893: FND_MSG_PUB.Count_And_Get
9894: ( p_encoded => FND_API.G_FALSE
9895: , p_count => x_msg_count
9896: , p_data => x_msg_data
9897: );
9898: x_return_status := FND_API.G_RET_STS_ERROR;

Line 9898: x_return_status := FND_API.G_RET_STS_ERROR;

9894: ( p_encoded => FND_API.G_FALSE
9895: , p_count => x_msg_count
9896: , p_data => x_msg_data
9897: );
9898: x_return_status := FND_API.G_RET_STS_ERROR;
9899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9900: ROLLBACK TO BscMigSimDataPub;
9901: FND_MSG_PUB.Count_And_Get
9902: ( p_encoded => FND_API.G_FALSE

Line 9899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9895: , p_count => x_msg_count
9896: , p_data => x_msg_data
9897: );
9898: x_return_status := FND_API.G_RET_STS_ERROR;
9899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9900: ROLLBACK TO BscMigSimDataPub;
9901: FND_MSG_PUB.Count_And_Get
9902: ( p_encoded => FND_API.G_FALSE
9903: , p_count => x_msg_count

Line 9902: ( p_encoded => FND_API.G_FALSE

9898: x_return_status := FND_API.G_RET_STS_ERROR;
9899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9900: ROLLBACK TO BscMigSimDataPub;
9901: FND_MSG_PUB.Count_And_Get
9902: ( p_encoded => FND_API.G_FALSE
9903: , p_count => x_msg_count
9904: , p_data => x_msg_data
9905: );
9906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 9906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9902: ( p_encoded => FND_API.G_FALSE
9903: , p_count => x_msg_count
9904: , p_data => x_msg_data
9905: );
9906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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

Line 9909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

9905: );
9906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 ';

Line 9917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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 ';