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.

[Home] [Help]

APPS.BSC_UPGRADES dependencies on FND_API

Line 133: -- WHEN FND_API.G_EXC_ERROR THEN

129: , x_measure_name => l_return_name);
130: l_flag := 'T';
131: EXCEPTION
132: -- Exception is thrown when the measure name fails during validation
133: -- WHEN FND_API.G_EXC_ERROR THEN
134: WHEN OTHERS THEN
135: l_dataset_name := BSC_UTILITY.get_Next_DispName(l_dataset_name);
136: END;
137: END LOOP;

Line 197: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_Measure(c_meas.short_name) = FND_API.G_TRUE) THEN -- custom KPI

193: IF (l_max_ds_id_bis <> l_max_ds_id_bsc) THEN -- dataset ids are out of synch
194: -- remove BSC measures from pmf repository
195: -- Exclude non-corrupt s2e measures.
196: FOR c_meas IN c_bsc_measures_in_pmf LOOP
197: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_Measure(c_meas.short_name) = FND_API.G_TRUE) THEN -- custom KPI
198: OPEN c_s2e_kpis(c_meas.indicator_id);
199: FETCH c_s2e_kpis INTO l_count;
200: IF (l_count = 0) THEN -- custom KPI is corrupt, delete it from PMF side (should not happen ideally)
201: l_num_ids := l_num_ids + 1;

Line 219: ,p_commit => FND_API.G_FALSE

215: l_bis_measure_rec.measure_id := l_arr_ids(i);
216:
217: BIS_MEASURE_PUB.Delete_Measure(
218: p_api_version => 1.0
219: ,p_commit => FND_API.G_FALSE
220: ,p_Measure_Rec => l_bis_measure_rec
221: ,x_return_status => l_return_status
222: ,x_error_Tbl => l_error_tbl);
223: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

Line 223: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

219: ,p_commit => FND_API.G_FALSE
220: ,p_Measure_Rec => l_bis_measure_rec
221: ,x_return_status => l_return_status
222: ,x_error_Tbl => l_error_tbl);
223: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: BEGIN

Line 224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

220: ,p_Measure_Rec => l_bis_measure_rec
221: ,x_return_status => l_return_status
222: ,x_error_Tbl => l_error_tbl);
223: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226:
227: BEGIN
228: BSC_MESSAGE.Add(x_message => 'Deleted measure: ' || l_arr_short_name(i) || ' : Successfully',

Line 326: p_commit => FND_API.G_FALSE

322: l_Dataset_Rec.Bsc_Measure_Short_Name
323: );
324: l_Dataset_Rec.Bsc_Measure_Col := l_Measure_Col;
325: BSC_DATASETS_PUB.Create_Measures(
326: p_commit => FND_API.G_FALSE
327: ,p_Dataset_Rec => l_Dataset_Rec
328: ,x_Dataset_Id => l_Dataset_Id
329: ,x_return_status => l_return_status
330: ,x_msg_count => l_msg_count

Line 332: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

328: ,x_Dataset_Id => l_Dataset_Id
329: ,x_return_status => l_return_status
330: ,x_msg_count => l_msg_count
331: ,x_msg_data => l_msg_data);
332: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336: l_Dataset_Rec.Bsc_Dataset_Id := l_Dataset_Id;

Line 333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

329: ,x_return_status => l_return_status
330: ,x_msg_count => l_msg_count
331: ,x_msg_data => l_msg_data);
332: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336: l_Dataset_Rec.Bsc_Dataset_Id := l_Dataset_Id;
337: BSC_DATASETS_PUB.Create_Dataset_Calc(FND_API.G_FALSE

Line 337: BSC_DATASETS_PUB.Create_Dataset_Calc(FND_API.G_FALSE

333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
334: END IF;
335:
336: l_Dataset_Rec.Bsc_Dataset_Id := l_Dataset_Id;
337: BSC_DATASETS_PUB.Create_Dataset_Calc(FND_API.G_FALSE
338: ,l_Dataset_Rec
339: ,l_return_status
340: ,l_msg_count
341: ,l_msg_data);

Line 342: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

338: ,l_Dataset_Rec
339: ,l_return_status
340: ,l_msg_count
341: ,l_msg_data);
342: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345: -- added for Enhancement#4239216
346: BEGIN

Line 343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

339: ,l_return_status
340: ,l_msg_count
341: ,l_msg_data);
342: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345: -- added for Enhancement#4239216
346: BEGIN
347: IF (l_Measure_Col IS NOT NULL) THEN

Line 397: p_encoded => FND_API.G_FALSE

393: WHEN OTHERS THEN
394: l_num := l_num + 1;
395: IF (l_msg_data IS NULL) THEN
396: FND_MSG_PUB.Count_And_Get (
397: p_encoded => FND_API.G_FALSE
398: , p_count => l_msg_count
399: , p_data => l_msg_data );
400: END IF;
401: l_arr_short_name(l_num) := icr.measure_short_name || ' : ' || l_msg_data;

Line 484: ,p_commit => FND_API.G_FALSE

480: l_measure_rec.Last_Update_Login := cr.last_update_login;
481:
482: BIS_MEASURE_PUB.Create_Measure(
483: p_api_version => 1.0
484: ,p_commit => FND_API.G_FALSE
485: ,p_Measure_Rec => l_measure_rec
486: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)
487: ,x_return_status => l_return_status
488: ,x_error_tbl => l_error_tbl);

Line 489: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

485: ,p_Measure_Rec => l_measure_rec
486: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)
487: ,x_return_status => l_return_status
488: ,x_error_tbl => l_error_tbl);
489: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:
493: UPDATE bsc_sys_measures

Line 490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)
487: ,x_return_status => l_return_status
488: ,x_error_tbl => l_error_tbl);
489: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491: END IF;
492:
493: UPDATE bsc_sys_measures
494: SET short_name = l_measure_rec.Measure_Short_Name

Line 691: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_Measure(cr.Measure_Id) = FND_API.G_TRUE) THEN

687: l_measure_rec.Last_Updated_By := cr.last_updated_by;
688: l_measure_rec.Last_Update_Login := cr.last_update_login;
689:
690: -- Get the actual_data_source, actual_data_source_type and function name for custom KPIs
691: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_KPI_EndToEnd_Measure(cr.Measure_Id) = FND_API.G_TRUE) THEN
692: BEGIN
693: BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Pmf_Metadata_By_Objective (
694: p_Dataset_Id => cr.dataset_Id
695: , p_Measure_Short_Name => cr.short_name

Line 712: ,p_commit => FND_API.G_FALSE

708: END IF;
709:
710: BIS_MEASURE_PUB.Create_Measure(
711: p_api_version => 1.0
712: ,p_commit => FND_API.G_FALSE
713: ,p_Measure_Rec => l_measure_rec
714: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)
715: ,x_return_status => l_return_status
716: ,x_error_tbl => l_error_tbl);

Line 717: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

713: ,p_Measure_Rec => l_measure_rec
714: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)
715: ,x_return_status => l_return_status
716: ,x_error_tbl => l_error_tbl);
717: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720:
721: UPDATE BSC_SYS_MEASURES

Line 718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

714: ,p_owner => FND_LOAD_UTIL.OWNER_NAME(cr.created_by)
715: ,x_return_status => l_return_status
716: ,x_error_tbl => l_error_tbl);
717: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719: END IF;
720:
721: UPDATE BSC_SYS_MEASURES
722: SET short_name = l_measure_rec.Measure_Short_Name

Line 899: IF (l_return_status IS NOT NULL AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

895: ,x_return_status => l_return_status
896: ,x_msg_count => l_msg_count
897: ,x_msg_data => l_msg_data);
898:
899: IF (l_return_status IS NOT NULL AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: COMMIT;

Line 900: RAISE FND_API.G_EXC_ERROR;

896: ,x_msg_count => l_msg_count
897: ,x_msg_data => l_msg_data);
898:
899: IF (l_return_status IS NOT NULL AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: COMMIT;
904: RETURN TRUE;

Line 958: , p_commit => FND_API.G_FALSE

954: l_measure_rec.Measure_name := l_measure_rec.Measure_short_name;
955:
956: BIS_MEASURE_PUB.Translate_Measure_By_lang
957: ( p_api_version => 1.0
958: , p_commit => FND_API.G_FALSE
959: , p_Measure_Rec => l_Measure_Rec
960: , p_lang => cr.language_code
961: , p_source_lang => l_source_lang
962: , x_return_status => x_return_status

Line 972: WHEN FND_API.G_EXC_ERROR THEN

968: CLOSE installed_languages_cursor;
969: end if;
970:
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973: x_return_status := FND_API.G_RET_STS_ERROR;
974: if installed_languages_cursor%ISOPEN THEN
975: CLOSE installed_languages_cursor;
976: end if;

Line 973: x_return_status := FND_API.G_RET_STS_ERROR;

969: end if;
970:
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973: x_return_status := FND_API.G_RET_STS_ERROR;
974: if installed_languages_cursor%ISOPEN THEN
975: CLOSE installed_languages_cursor;
976: end if;
977: RAISE;

Line 978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

974: if installed_languages_cursor%ISOPEN THEN
975: CLOSE installed_languages_cursor;
976: end if;
977: RAISE;
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: if installed_languages_cursor%ISOPEN THEN
981: CLOSE installed_languages_cursor;
982: end if;

Line 979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

975: CLOSE installed_languages_cursor;
976: end if;
977: RAISE;
978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
980: if installed_languages_cursor%ISOPEN THEN
981: CLOSE installed_languages_cursor;
982: end if;
983: RAISE;

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

981: CLOSE installed_languages_cursor;
982: end if;
983: RAISE;
984: WHEN NO_DATA_FOUND THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: if installed_languages_cursor%ISOPEN THEN
987: CLOSE installed_languages_cursor;
988: end if;
989: RAISE;

Line 991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

987: CLOSE installed_languages_cursor;
988: end if;
989: RAISE;
990: WHEN OTHERS THEN
991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
992: if installed_languages_cursor%ISOPEN THEN
993: CLOSE installed_languages_cursor;
994: end if;
995: RAISE;

Line 1045: ( p_commit => FND_API.G_FALSE

1041: END IF;
1042: l_dataset_rec.Bsc_Dataset_help := l_description;
1043:
1044: BSC_DATASETS_PUB.Translate_Measure_By_Lang
1045: ( p_commit => FND_API.G_FALSE
1046: , p_Dataset_Rec => l_Dataset_Rec
1047: , p_lang => cr.language_code
1048: , p_source_lang => l_source_lang
1049: , x_return_status => x_return_status

Line 1060: WHEN FND_API.G_EXC_ERROR THEN

1056: CLOSE installed_languages_cursor;
1057: end if;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: if installed_languages_cursor%ISOPEN THEN
1063: CLOSE installed_languages_cursor;
1064: end if;

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057: end if;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: if installed_languages_cursor%ISOPEN THEN
1063: CLOSE installed_languages_cursor;
1064: end if;
1065: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1064: end if;
1065: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1066: ,p_data => x_msg_data);
1067: RAISE;
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: if installed_languages_cursor%ISOPEN THEN
1071: CLOSE installed_languages_cursor;
1072: end if;

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1066: ,p_data => x_msg_data);
1067: RAISE;
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: if installed_languages_cursor%ISOPEN THEN
1071: CLOSE installed_languages_cursor;
1072: end if;
1073: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1077: x_return_status := FND_API.G_RET_STS_ERROR;

1073: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1074: ,p_data => x_msg_data);
1075: RAISE;
1076: WHEN NO_DATA_FOUND THEN
1077: x_return_status := FND_API.G_RET_STS_ERROR;
1078: if installed_languages_cursor%ISOPEN THEN
1079: CLOSE installed_languages_cursor;
1080: end if;
1081: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1081: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1082: ,p_data => x_msg_data);
1083: RAISE;
1084: WHEN OTHERS THEN
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: if installed_languages_cursor%ISOPEN THEN
1087: CLOSE installed_languages_cursor;
1088: end if;
1089: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1133: , p_commit => FND_API.G_FALSE

1129: l_measure_rec.Measure_name := scr.short_name;
1130:
1131: BIS_MEASURE_PUB.Translate_Measure_By_lang
1132: ( p_api_version => 1.0
1133: , p_commit => FND_API.G_FALSE
1134: , p_Measure_Rec => l_Measure_Rec
1135: , p_lang => scr.language
1136: , p_source_lang => scr.source_lang
1137: , x_return_status => x_return_status

Line 1161: ( p_commit => FND_API.G_FALSE

1157: l_dataset_rec.bsc_dataset_help := scr.description;
1158: end if;
1159:
1160: BSC_DATASETS_PUB.Translate_Measure_By_Lang
1161: ( p_commit => FND_API.G_FALSE
1162: , p_Dataset_Rec => l_Dataset_Rec
1163: , p_lang => scr.language
1164: , p_source_lang => scr.source_lang
1165: , x_return_status => x_return_status

Line 1177: WHEN FND_API.G_EXC_ERROR THEN

1173: CLOSE synch_lang_cursor;
1174: end if;
1175:
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: if synch_lang_cursor%ISOPEN THEN
1180: CLOSE synch_lang_cursor;
1181: end if;

Line 1178: x_return_status := FND_API.G_RET_STS_ERROR;

1174: end if;
1175:
1176: EXCEPTION
1177: WHEN FND_API.G_EXC_ERROR THEN
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: if synch_lang_cursor%ISOPEN THEN
1180: CLOSE synch_lang_cursor;
1181: end if;
1182: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1181: end if;
1182: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1183: ,p_data => x_msg_data);
1184: RAISE;
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: if synch_lang_cursor%ISOPEN THEN
1188: CLOSE synch_lang_cursor;
1189: end if;

Line 1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1182: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1183: ,p_data => x_msg_data);
1184: RAISE;
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: if synch_lang_cursor%ISOPEN THEN
1188: CLOSE synch_lang_cursor;
1189: end if;
1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1191: ,p_data => x_msg_data);
1192: RAISE;
1193: WHEN NO_DATA_FOUND THEN
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: if synch_lang_cursor%ISOPEN THEN
1196: CLOSE synch_lang_cursor;
1197: end if;
1198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1199: ,p_data => x_msg_data);
1200: RAISE;
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: if synch_lang_cursor%ISOPEN THEN
1204: CLOSE synch_lang_cursor;
1205: end if;
1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1372: l_bis_dim_level_rec.enabled := FND_API.G_TRUE;

1368: l_bis_dim_level_rec.Last_Updated_By := cd.Last_Updated_By;
1369: l_bis_dim_level_rec.Last_Update_Date := cd.Last_Update_Date;
1370: l_bis_dim_level_rec.Last_Update_Login := cd.Last_Update_Login;
1371: -- ankgoel: bug#4625611 - dim object should be enabled by default
1372: l_bis_dim_level_rec.enabled := FND_API.G_TRUE;
1373:
1374: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level
1375: (
1376: p_api_version => 1.0

Line 1377: , p_commit => FND_API.G_FALSE

1373:
1374: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level
1375: (
1376: p_api_version => 1.0
1377: , p_commit => FND_API.G_FALSE
1378: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1379: , p_Dimension_Level_Rec => l_bis_dim_level_rec
1380: , x_return_status => l_return_status
1381: , x_error_Tbl => l_error_tbl

Line 1378: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1374: BIS_DIMENSION_LEVEL_PUB.Create_Dimension_Level
1375: (
1376: p_api_version => 1.0
1377: , p_commit => FND_API.G_FALSE
1378: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1379: , p_Dimension_Level_Rec => l_bis_dim_level_rec
1380: , x_return_status => l_return_status
1381: , x_error_Tbl => l_error_tbl
1382: );

Line 1434: p_commit => FND_API.G_FALSE

1430:
1431: l_bsc_dim_obj_rec.Bsc_Level_Name := l_bsc_dim_obj_rec.Bsc_Level_View_Name;
1432: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level
1433: (
1434: p_commit => FND_API.G_FALSE
1435: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1436: , p_create_tables => FALSE
1437: , x_return_status => l_return_status
1438: , x_msg_count => l_msg_count

Line 1457: WHEN FND_API.G_EXC_ERROR THEN

1453: COMMIT;
1454: x_error_msg := 'BSC_UPGRADES.Synchronize_Dim_Objects Successfully Completed';
1455: RETURN TRUE;
1456: EXCEPTION
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: IF (c_bis_dim_objs%ISOPEN) THEN
1459: CLOSE c_bis_dim_objs;
1460: END IF;
1461: IF (c_bsc_dim_objs%ISOPEN) THEN

Line 1472: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_error_msg);

1468: , p_count => l_msg_count
1469: , p_data => x_error_msg
1470: );
1471: END IF;
1472: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_error_msg);
1473: RETURN FALSE;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: IF (c_bis_dim_objs%ISOPEN) THEN
1476: CLOSE c_bis_dim_objs;

Line 1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1470: );
1471: END IF;
1472: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_error_msg);
1473: RETURN FALSE;
1474: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1475: IF (c_bis_dim_objs%ISOPEN) THEN
1476: CLOSE c_bis_dim_objs;
1477: END IF;
1478: IF (c_bsc_dim_objs%ISOPEN) THEN

Line 1489: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_error_msg);

1485: , p_count => l_msg_count
1486: , p_data => x_error_msg
1487: );
1488: END IF;
1489: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_error_msg);
1490: RETURN FALSE;
1491: WHEN NO_DATA_FOUND THEN
1492: IF (c_bis_dim_objs%ISOPEN) THEN
1493: CLOSE c_bis_dim_objs;

Line 1620: p_commit => FND_API.G_FALSE

1616: l_bsc_dimension_rec.Bsc_Last_Update_Login := cd.Last_Update_Login;
1617:
1618: BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group
1619: (
1620: p_commit => FND_API.G_FALSE
1621: , p_Dim_Grp_Rec => l_bsc_dimension_rec
1622: , p_create_Dim_Levels => FALSE
1623: , x_return_status => l_return_status
1624: , x_msg_count => l_msg_count

Line 1657: p_commit => FND_API.G_FALSE

1653:
1654: IF (l_count = 0) THEN
1655: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Object
1656: (
1657: p_commit => FND_API.G_FALSE
1658: , p_dim_short_name => cd.Short_Name
1659: , p_dim_obj_short_name => dim_cn.Short_Name
1660: , p_comp_flag => -1
1661: , p_no_items => 0

Line 1707: , p_commit => FND_API.G_FALSE

1703: l_bis_dimension_rec.Last_Update_Login := cd.Last_Update_Login;
1704:
1705: BIS_DIMENSION_PUB.Create_Dimension
1706: ( p_api_version => 1.0
1707: , p_commit => FND_API.G_FALSE
1708: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1709: , p_Dimension_Rec => l_bis_dimension_rec
1710: , x_return_status => l_return_status
1711: , x_error_Tbl => l_error_tbl

Line 1708: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1704:
1705: BIS_DIMENSION_PUB.Create_Dimension
1706: ( p_api_version => 1.0
1707: , p_commit => FND_API.G_FALSE
1708: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1709: , p_Dimension_Rec => l_bis_dimension_rec
1710: , x_return_status => l_return_status
1711: , x_error_Tbl => l_error_tbl
1712: );

Line 1738: WHEN FND_API.G_EXC_ERROR THEN

1734: COMMIT;
1735: x_error_msg := 'BSC_UPGRADES.Synchronize_Dimensions Successfully Completed';
1736: RETURN TRUE;
1737: EXCEPTION
1738: WHEN FND_API.G_EXC_ERROR THEN
1739: IF (c_bsc_dims%ISOPEN) THEN
1740: CLOSE c_bsc_dims;
1741: END IF;
1742: IF (c_bis_dims%ISOPEN) THEN

Line 1756: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_error_msg);

1752: , p_count => l_msg_count
1753: , p_data => x_error_msg
1754: );
1755: END IF;
1756: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_error_msg);
1757: RETURN FALSE;
1758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1759: IF (c_bsc_dims%ISOPEN) THEN
1760: CLOSE c_bsc_dims;

Line 1758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1754: );
1755: END IF;
1756: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_error_msg);
1757: RETURN FALSE;
1758: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1759: IF (c_bsc_dims%ISOPEN) THEN
1760: CLOSE c_bsc_dims;
1761: END IF;
1762: IF (c_bis_dims%ISOPEN) THEN

Line 1776: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_error_msg);

1772: , p_count => l_msg_count
1773: , p_data => x_error_msg
1774: );
1775: END IF;
1776: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_error_msg);
1777: RETURN FALSE;
1778: WHEN NO_DATA_FOUND THEN
1779: IF (c_bsc_dims%ISOPEN) THEN
1780: CLOSE c_bsc_dims;

Line 1860: p_commit => FND_API.G_FALSE

1856: AND LANGUAGE = cd.language_code;
1857:
1858: BIS_DIMENSION_LEVEL_PUB.Trans_DimObj_By_Given_Lang
1859: (
1860: p_commit => FND_API.G_FALSE
1861: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1862: , p_Dimension_Level_Rec => l_Dim_Level_Rec
1863: , x_return_status => x_return_status
1864: , x_error_Tbl => x_error_tbl

Line 1861: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1857:
1858: BIS_DIMENSION_LEVEL_PUB.Trans_DimObj_By_Given_Lang
1859: (
1860: p_commit => FND_API.G_FALSE
1861: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1862: , p_Dimension_Level_Rec => l_Dim_Level_Rec
1863: , x_return_status => x_return_status
1864: , x_error_Tbl => x_error_tbl
1865: );

Line 1871: x_return_status := FND_API.G_RET_STS_ERROR ;

1867:
1868: EXCEPTION
1869:
1870: WHEN NO_DATA_FOUND THEN
1871: x_return_status := FND_API.G_RET_STS_ERROR ;
1872: if installed_languages_cursor%ISOPEN THEN
1873: CLOSE installed_languages_cursor;
1874: end if;
1875: when FND_API.G_EXC_ERROR then

Line 1875: when FND_API.G_EXC_ERROR then

1871: x_return_status := FND_API.G_RET_STS_ERROR ;
1872: if installed_languages_cursor%ISOPEN THEN
1873: CLOSE installed_languages_cursor;
1874: end if;
1875: when FND_API.G_EXC_ERROR then
1876: x_return_status := FND_API.G_RET_STS_ERROR ;
1877: if installed_languages_cursor%ISOPEN THEN
1878: CLOSE installed_languages_cursor;
1879: end if;

Line 1876: x_return_status := FND_API.G_RET_STS_ERROR ;

1872: if installed_languages_cursor%ISOPEN THEN
1873: CLOSE installed_languages_cursor;
1874: end if;
1875: when FND_API.G_EXC_ERROR then
1876: x_return_status := FND_API.G_RET_STS_ERROR ;
1877: if installed_languages_cursor%ISOPEN THEN
1878: CLOSE installed_languages_cursor;
1879: end if;
1880: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1880: when FND_API.G_EXC_UNEXPECTED_ERROR then

1876: x_return_status := FND_API.G_RET_STS_ERROR ;
1877: if installed_languages_cursor%ISOPEN THEN
1878: CLOSE installed_languages_cursor;
1879: end if;
1880: when FND_API.G_EXC_UNEXPECTED_ERROR then
1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1882: if installed_languages_cursor%ISOPEN THEN
1883: CLOSE installed_languages_cursor;
1884: end if;

Line 1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1877: if installed_languages_cursor%ISOPEN THEN
1878: CLOSE installed_languages_cursor;
1879: end if;
1880: when FND_API.G_EXC_UNEXPECTED_ERROR then
1881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1882: if installed_languages_cursor%ISOPEN THEN
1883: CLOSE installed_languages_cursor;
1884: end if;
1885: when others then

Line 1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1882: if installed_languages_cursor%ISOPEN THEN
1883: CLOSE installed_languages_cursor;
1884: end if;
1885: when others then
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1887: l_error_tbl := x_error_Tbl;
1888: if installed_languages_cursor%ISOPEN THEN
1889: CLOSE installed_languages_cursor;
1890: end if;

Line 1947: p_commit => FND_API.G_FALSE

1943: AND LANGUAGE = cd.language_code;
1944:
1945: BSC_DIMENSION_LEVELS_PUB.Trans_DimObj_By_Given_Lang
1946: (
1947: p_commit => FND_API.G_FALSE
1948: , p_dim_level_rec => l_Dim_Level_Rec
1949: , x_return_status => x_return_status
1950: , x_msg_count => x_msg_count
1951: , x_msg_data => x_msg_data

Line 1956: WHEN FND_API.G_EXC_ERROR THEN

1952: );
1953:
1954: END LOOP;
1955: EXCEPTION
1956: WHEN FND_API.G_EXC_ERROR THEN
1957: x_return_status := FND_API.G_RET_STS_ERROR;
1958: if installed_languages_cursor%ISOPEN THEN
1959: CLOSE installed_languages_cursor;
1960: end if;

Line 1957: x_return_status := FND_API.G_RET_STS_ERROR;

1953:
1954: END LOOP;
1955: EXCEPTION
1956: WHEN FND_API.G_EXC_ERROR THEN
1957: x_return_status := FND_API.G_RET_STS_ERROR;
1958: if installed_languages_cursor%ISOPEN THEN
1959: CLOSE installed_languages_cursor;
1960: end if;
1961: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1960: end if;
1961: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1962: ,p_data => x_msg_data);
1963: RAISE;
1964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: if installed_languages_cursor%ISOPEN THEN
1967: CLOSE installed_languages_cursor;
1968: end if;

Line 1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1961: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1962: ,p_data => x_msg_data);
1963: RAISE;
1964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: if installed_languages_cursor%ISOPEN THEN
1967: CLOSE installed_languages_cursor;
1968: end if;
1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1973: x_return_status := FND_API.G_RET_STS_ERROR;

1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1970: ,p_data => x_msg_data);
1971: RAISE;
1972: WHEN NO_DATA_FOUND THEN
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: if installed_languages_cursor%ISOPEN THEN
1975: CLOSE installed_languages_cursor;
1976: end if;
1977: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1977: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1978: ,p_data => x_msg_data);
1979: RAISE;
1980: WHEN OTHERS THEN
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: if installed_languages_cursor%ISOPEN THEN
1983: CLOSE installed_languages_cursor;
1984: end if;
1985: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2028: p_commit => FND_API.G_FALSE

2024: AND LANGUAGE = cd.language_code;
2025:
2026: BIS_DIMENSION_PUB.Translate_Dim_By_Given_Lang
2027: (
2028: p_commit => FND_API.G_FALSE
2029: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2030: , p_Dimension_Rec => l_Dim_Grp_Rec
2031: , x_return_status => x_return_status
2032: , x_error_Tbl => x_error_tbl

Line 2029: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2025:
2026: BIS_DIMENSION_PUB.Translate_Dim_By_Given_Lang
2027: (
2028: p_commit => FND_API.G_FALSE
2029: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2030: , p_Dimension_Rec => l_Dim_Grp_Rec
2031: , x_return_status => x_return_status
2032: , x_error_Tbl => x_error_tbl
2033: );

Line 2039: x_return_status := FND_API.G_RET_STS_ERROR ;

2035: END LOOP;
2036:
2037: EXCEPTION
2038: WHEN NO_DATA_FOUND THEN
2039: x_return_status := FND_API.G_RET_STS_ERROR ;
2040: if installed_languages_cursor%ISOPEN THEN
2041: CLOSE installed_languages_cursor;
2042: end if;
2043: when FND_API.G_EXC_ERROR then

Line 2043: when FND_API.G_EXC_ERROR then

2039: x_return_status := FND_API.G_RET_STS_ERROR ;
2040: if installed_languages_cursor%ISOPEN THEN
2041: CLOSE installed_languages_cursor;
2042: end if;
2043: when FND_API.G_EXC_ERROR then
2044: x_return_status := FND_API.G_RET_STS_ERROR ;
2045: if installed_languages_cursor%ISOPEN THEN
2046: CLOSE installed_languages_cursor;
2047: end if;

Line 2044: x_return_status := FND_API.G_RET_STS_ERROR ;

2040: if installed_languages_cursor%ISOPEN THEN
2041: CLOSE installed_languages_cursor;
2042: end if;
2043: when FND_API.G_EXC_ERROR then
2044: x_return_status := FND_API.G_RET_STS_ERROR ;
2045: if installed_languages_cursor%ISOPEN THEN
2046: CLOSE installed_languages_cursor;
2047: end if;
2048: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2048: when FND_API.G_EXC_UNEXPECTED_ERROR then

2044: x_return_status := FND_API.G_RET_STS_ERROR ;
2045: if installed_languages_cursor%ISOPEN THEN
2046: CLOSE installed_languages_cursor;
2047: end if;
2048: when FND_API.G_EXC_UNEXPECTED_ERROR then
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2050: if installed_languages_cursor%ISOPEN THEN
2051: CLOSE installed_languages_cursor;
2052: end if;

Line 2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2045: if installed_languages_cursor%ISOPEN THEN
2046: CLOSE installed_languages_cursor;
2047: end if;
2048: when FND_API.G_EXC_UNEXPECTED_ERROR then
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2050: if installed_languages_cursor%ISOPEN THEN
2051: CLOSE installed_languages_cursor;
2052: end if;
2053: when others then

Line 2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2050: if installed_languages_cursor%ISOPEN THEN
2051: CLOSE installed_languages_cursor;
2052: end if;
2053: when others then
2054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2055: l_error_tbl := x_error_Tbl;
2056: if installed_languages_cursor%ISOPEN THEN
2057: CLOSE installed_languages_cursor;
2058: end if;

Line 2115: p_commit => FND_API.G_FALSE

2111: AND LANGUAGE = cd.language_code;
2112:
2113: BSC_DIMENSION_GROUPS_PUB.Translate_Dim_By_Given_Lang
2114: (
2115: p_commit => FND_API.G_FALSE
2116: , p_Dim_Grp_Rec => l_Dim_Grp_Rec
2117: , x_return_status => x_return_status
2118: , x_msg_count => x_msg_count
2119: , x_msg_data => x_msg_data

Line 2124: WHEN FND_API.G_EXC_ERROR THEN

2120: );
2121:
2122: END LOOP;
2123: EXCEPTION
2124: WHEN FND_API.G_EXC_ERROR THEN
2125: x_return_status := FND_API.G_RET_STS_ERROR;
2126: if installed_languages_cursor%ISOPEN THEN
2127: CLOSE installed_languages_cursor;
2128: end if;

Line 2125: x_return_status := FND_API.G_RET_STS_ERROR;

2121:
2122: END LOOP;
2123: EXCEPTION
2124: WHEN FND_API.G_EXC_ERROR THEN
2125: x_return_status := FND_API.G_RET_STS_ERROR;
2126: if installed_languages_cursor%ISOPEN THEN
2127: CLOSE installed_languages_cursor;
2128: end if;
2129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2128: end if;
2129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2130: ,p_data => x_msg_data);
2131: RAISE;
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: if installed_languages_cursor%ISOPEN THEN
2135: CLOSE installed_languages_cursor;
2136: end if;

Line 2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2130: ,p_data => x_msg_data);
2131: RAISE;
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: if installed_languages_cursor%ISOPEN THEN
2135: CLOSE installed_languages_cursor;
2136: end if;
2137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2141: x_return_status := FND_API.G_RET_STS_ERROR;

2137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2138: ,p_data => x_msg_data);
2139: RAISE;
2140: WHEN NO_DATA_FOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: if installed_languages_cursor%ISOPEN THEN
2143: CLOSE installed_languages_cursor;
2144: end if;
2145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2146: ,p_data => x_msg_data);
2147: RAISE;
2148: WHEN OTHERS THEN
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2150: if installed_languages_cursor%ISOPEN THEN
2151: CLOSE installed_languages_cursor;
2152: end if;
2153: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2221: ( FND_API.G_FALSE

2217: l_Bsc_Tab_Entity_Rec.Bsc_Last_Update_Login := c_tab_recs.LAST_UPDATE_LOGIN;
2218: l_Bsc_Tab_Entity_Rec.Bsc_Resp_End_Date := c_tab_recs.END_DATE;
2219: BEGIN
2220: BSC_SCORECARD_PVT.Create_Tab_Access
2221: ( FND_API.G_FALSE
2222: , l_Bsc_Tab_Entity_Rec
2223: , x_return_status
2224: , x_msg_count
2225: , x_msg_data

Line 2255: ( FND_API.G_FALSE

2251: l_Bsc_Kpi_Entity_Rec.Bsc_Resp_Start_Date := c_kpi_recs.START_DATE;
2252: l_Bsc_Kpi_Entity_Rec.Bsc_Resp_End_Date := c_kpi_recs.END_DATE;
2253: BEGIN
2254: BSC_KPI_PVT.Create_Kpi_User_Access
2255: ( FND_API.G_FALSE
2256: , l_Bsc_Kpi_Entity_Rec
2257: , x_return_status
2258: , x_msg_count
2259: , x_msg_data

Line 2628: p_commit => FND_API.G_FALSE

2624: IF(l_Measure_Col IS NOT NULL) THEN
2625: l_Dataset_Rec.Bsc_Measure_Id := cPMFM.MEASURE_ID;
2626: l_Dataset_Rec.Bsc_Measure_Col := l_Measure_Col;
2627: BSC_DATASETS_PVT.Update_Measures(
2628: p_commit => FND_API.G_FALSE
2629: ,p_Dataset_Rec => l_Dataset_Rec
2630: ,x_return_status => l_Return_Status
2631: ,x_msg_count => l_Msg_Count
2632: ,x_msg_data => l_Msg_Data

Line 2634: IF ((l_Return_Status IS NOT NULL) AND (l_Return_Status <> FND_API.G_RET_STS_SUCCESS)) THEN

2630: ,x_return_status => l_Return_Status
2631: ,x_msg_count => l_Msg_Count
2632: ,x_msg_data => l_Msg_Data
2633: );
2634: IF ((l_Return_Status IS NOT NULL) AND (l_Return_Status <> FND_API.G_RET_STS_SUCCESS)) THEN
2635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2636: END IF;
2637: END IF;
2638: END LOOP;

Line 2635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2631: ,x_msg_count => l_Msg_Count
2632: ,x_msg_data => l_Msg_Data
2633: );
2634: IF ((l_Return_Status IS NOT NULL) AND (l_Return_Status <> FND_API.G_RET_STS_SUCCESS)) THEN
2635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2636: END IF;
2637: END IF;
2638: END LOOP;
2639: COMMIT;

Line 2764: x_return_status := FND_API.G_RET_STS_ERROR ;

2760: END LOOP;
2761:
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: WHEN FND_API.G_EXC_ERROR THEN
2766: x_return_status := FND_API.G_RET_STS_ERROR ;
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2765: WHEN FND_API.G_EXC_ERROR THEN

2761:
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: WHEN FND_API.G_EXC_ERROR THEN
2766: x_return_status := FND_API.G_RET_STS_ERROR ;
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2769: WHEN OTHERS THEN

Line 2766: x_return_status := FND_API.G_RET_STS_ERROR ;

2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: WHEN FND_API.G_EXC_ERROR THEN
2766: x_return_status := FND_API.G_RET_STS_ERROR ;
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2769: WHEN OTHERS THEN
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2763: WHEN NO_DATA_FOUND THEN
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: WHEN FND_API.G_EXC_ERROR THEN
2766: x_return_status := FND_API.G_RET_STS_ERROR ;
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2769: WHEN OTHERS THEN
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2771: l_error_tbl := x_error_Tbl;

Line 2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: WHEN FND_API.G_EXC_ERROR THEN
2766: x_return_status := FND_API.G_RET_STS_ERROR ;
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2769: WHEN OTHERS THEN
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2771: l_error_tbl := x_error_Tbl;
2772: BIS_UTILITIES_PVT.Add_Error_Message

Line 2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2766: x_return_status := FND_API.G_RET_STS_ERROR ;
2767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2769: WHEN OTHERS THEN
2770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2771: l_error_tbl := x_error_Tbl;
2772: BIS_UTILITIES_PVT.Add_Error_Message
2773: ( p_error_msg_id => SQLCODE
2774: , p_error_description => SQLERRM

Line 2813: SET HIDE_IN_DESIGN = FND_API.G_TRUE

2809: l_row_count := cr_internal_dimensions%ROWCOUNT;
2810:
2811: FORALL i in 1..l_dim_short_names.COUNT
2812: UPDATE BIS_DIMENSIONS
2813: SET HIDE_IN_DESIGN = FND_API.G_TRUE
2814: WHERE SHORT_NAME = l_dim_short_names(i);
2815: END LOOP;
2816:
2817: CLOSE cr_internal_dimensions;

Line 2871: SET HIDE_IN_DESIGN = FND_API.G_TRUE

2867: l_row_count := cr_pmf_import_dims%ROWCOUNT;
2868:
2869: FOR i in 1..l_dim_short_names.COUNT LOOP
2870: UPDATE BIS_DIMENSIONS
2871: SET HIDE_IN_DESIGN = FND_API.G_TRUE
2872: WHERE SHORT_NAME = l_dim_short_names(i);
2873: END LOOP;
2874: END LOOP;
2875: CLOSE cr_pmf_import_dims;

Line 2909: x_return_status := FND_API.G_RET_STS_SUCCESS;

2905: WHERE short_name = p_sht_name;
2906:
2907: BEGIN
2908: FND_MSG_PUB.Initialize;
2909: x_return_status := FND_API.G_RET_STS_SUCCESS;
2910:
2911: FOR i in p_Dim_Obj_Sht_Name.FIRST..p_Dim_Obj_Sht_Name.LAST
2912: LOOP
2913: l_level_view_name := NULL;

Line 2932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2928: END IF;
2929: END LOOP;
2930: EXCEPTION
2931: WHEN OTHERS THEN
2932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: IF (x_msg_data IS NOT NULL) THEN
2934: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_OBJ_PUB.Drop_Update_Dim_Obj_Views ';
2935: ELSE
2936: x_msg_data := SQLERRM||' at BSC_BIS_DIM_OBJ_PUB.Drop_Update_Dim_Obj_Views ';