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_CUSTOM_VIEW_UI_WRAPPER dependencies on FND_API

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66:
67: BEGIN
68: SAVEPOINT RollBackPt;
69: fnd_msg_pub.initialize;
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: l_count := 0;
73:
74: FOR l_label_cur IN LABEL_CUR LOOP

Line 93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

89:
90: EXCEPTION
91: WHEN others THEN
92: ROLLBACK TO RollBackPt;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: x_msg_data := SQLERRM;
95: END compact_custom_view_labels;
96:
97: -- Clear BSC_TAB_VIEW_LABELS_TL, BSC_TAB_VIEW_LABELS_B and BSC_TAB_VIEW_KPI_TL with given tab_id and tab_view_id

Line 108: x_return_status := FND_API.G_RET_STS_SUCCESS;

104: ) IS
105: BEGIN
106: SAVEPOINT RollBackPt;
107: fnd_msg_pub.initialize;
108: x_return_status := FND_API.G_RET_STS_SUCCESS;
109:
110: DELETE FROM BSC_TAB_VIEW_LABELS_TL
111: WHERE TAB_ID = p_tab_id
112: AND TAB_VIEW_ID = p_tab_view_id;

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

121:
122: EXCEPTION
123: WHEN others THEN
124: ROLLBACK TO RollBackPt;
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: x_msg_data := SQLERRM;
127: END clear_custom_view_canvas;
128:
129: --Remove all items specified in removedKPIs and removedLabels

Line 164: x_return_status := FND_API.G_RET_STS_SUCCESS;

160:
161: BEGIN
162: SAVEPOINT RollBackPt;
163: fnd_msg_pub.initialize;
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: --convert string of IDs to table lookup
167: l_kpis := p_kpis;
168: WHILE (Is_More(p_list_ids => l_kpis, p_id => l_id))

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

202:
203: EXCEPTION
204: WHEN others THEN
205: ROLLBACK TO RollBackPt;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_msg_data := SQLERRM;
208: END remove_custom_view_items;
209:
210: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

Line 233: x_return_status := FND_API.G_RET_STS_SUCCESS;

229: ) IS
230: BEGIN
231: SAVEPOINT RollBackPt;
232: fnd_msg_pub.initialize;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
236: p_tab_id => p_tab_id
237: ,p_tab_view_id => p_tab_view_id

Line 260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

256:
257: EXCEPTION
258: WHEN others THEN
259: ROLLBACK TO RollBackPt;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: x_msg_data := SQLERRM;
262: END add_or_update_kpi_actual;
263:
264: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: ) IS
284: BEGIN
285: SAVEPOINT RollBackPt;
286: fnd_msg_pub.initialize;
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
290: p_tab_id => p_tab_id
291: ,p_tab_view_id => p_tab_view_id

Line 314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

310:
311: EXCEPTION
312: WHEN others THEN
313: ROLLBACK TO RollBackPt;
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: x_msg_data := SQLERRM;
316: END add_or_update_kpi_change;
317:
318: -- Add specified label to BSC_TAB_VIEW_LABELS_PKG

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: ) IS
338: BEGIN
339: SAVEPOINT RollBackPt;
340: fnd_msg_pub.initialize;
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
344: p_tab_id => p_tab_id
345: ,p_tab_view_id => p_tab_view_id

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

364:
365: EXCEPTION
366: WHEN others THEN
367: ROLLBACK TO RollBackPt;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: x_msg_data := SQLERRM;
370: END add_or_update_kpi_label;
371:
372: -- insert to the following tables:

Line 419: x_return_status := FND_API.G_RET_STS_SUCCESS;

415: ) IS
416: BEGIN
417: SAVEPOINT RollBackPt;
418: fnd_msg_pub.initialize;
419: x_return_status := FND_API.G_RET_STS_SUCCESS;
420:
421: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG
422: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries
423: add_or_update_kpi_label(

Line 533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

529:
530: EXCEPTION
531: WHEN others THEN
532: ROLLBACK TO RollBackPt;
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
534: x_msg_data := SQLERRM;
535: END add_or_update_kpi;
536:
537:

Line 558: x_return_status := FND_API.G_RET_STS_SUCCESS;

554: ) IS
555: BEGIN
556: SAVEPOINT RollBackPt;
557: fnd_msg_pub.initialize;
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:
560: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
561: p_tab_id => p_tab_id
562: ,p_tab_view_id => p_tab_view_id

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

581:
582: EXCEPTION
583: WHEN others THEN
584: ROLLBACK TO RollBackPt;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: x_msg_data := SQLERRM;
587: END add_or_update_label;
588:
589: -- Add specified hotspot to BSC_TAB_VIEW_LABELS_PKG

Line 606: x_return_status := FND_API.G_RET_STS_SUCCESS;

602: ) IS
603: BEGIN
604: SAVEPOINT RollBackPt;
605: fnd_msg_pub.initialize;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
609: p_tab_id => p_tab_id
610: ,p_tab_view_id => p_tab_view_id

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629:
630: EXCEPTION
631: WHEN others THEN
632: ROLLBACK TO RollBackPt;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: x_msg_data := SQLERRM;
635: END add_or_update_hotspot;
636:
637: -- Add specified custom view link to BSC_TAB_VIEW_LABELS_PKG

Line 659: x_return_status := FND_API.G_RET_STS_SUCCESS;

655: ) IS
656: BEGIN
657: SAVEPOINT RollBackPt;
658: fnd_msg_pub.initialize;
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660:
661: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
662: p_tab_id => p_tab_id
663: ,p_tab_view_id => p_tab_view_id

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682:
683: EXCEPTION
684: WHEN others THEN
685: ROLLBACK TO RollBackPt;
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: x_msg_data := SQLERRM;
688: END add_or_update_custom_view_link;
689:
690: -- Add specified launchpad to BSC_TAB_VIEW_LABELS_PKG

Line 709: x_return_status := FND_API.G_RET_STS_SUCCESS;

705: ) IS
706: BEGIN
707: SAVEPOINT RollBackPt;
708: fnd_msg_pub.initialize;
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
712: p_tab_id => p_tab_id
713: ,p_tab_view_id => p_tab_view_id

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

732:
733: EXCEPTION
734: WHEN others THEN
735: ROLLBACK TO RollBackPt;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: x_msg_data := SQLERRM;
738: END add_or_update_launch_pad;
739:
740: -- Add specified measure (existing kpi) to BSC_TAB_VIEW_LABELS_PKG

Line 780: x_return_status := FND_API.G_RET_STS_SUCCESS;

776: ) IS
777: BEGIN
778: SAVEPOINT RollBackPt;
779: fnd_msg_pub.initialize;
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: --add name/hotspot
783: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
784: p_tab_id => p_tab_id

Line 877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

873:
874: EXCEPTION
875: WHEN others THEN
876: ROLLBACK TO RollBackPt;
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
878: x_msg_data := SQLERRM;
879: END add_or_update_measure;
880:
881: -- Wrapper for calling BSC_TAB_VIEW_LABELS_PKG procedures

Line 909: x_return_status := FND_API.G_RET_STS_SUCCESS;

905: l_object_id BSC_TAB_VIEW_LABELS_B.LABEL_ID%TYPE;
906: BEGIN
907: SAVEPOINT RollBackPt;
908: fnd_msg_pub.initialize;
909: x_return_status := FND_API.G_RET_STS_SUCCESS;
910:
911: SELECT count(1) INTO l_count
912: FROM bsc_tab_view_labels_vl
913: WHERE tab_id = p_tab_id

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

982:
983: EXCEPTION
984: WHEN others THEN
985: ROLLBACK TO RollBackPt;
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
987: x_msg_data := SQLERRM;
988: END add_or_update_tab_view_label;
989:
990: -- Wrappers for calling BSC_TAB_VIEW_KPI_PKG

Line 1016: x_return_status := FND_API.G_RET_STS_SUCCESS;

1012: l_str VARCHAR2(100);
1013: BEGIN
1014: SAVEPOINT RollBackPt;
1015: fnd_msg_pub.initialize;
1016: x_return_status := FND_API.G_RET_STS_SUCCESS;
1017:
1018: SELECT count(1) INTO l_count
1019: FROM BSC_TAB_VIEW_KPI_VL
1020: WHERE TAB_ID = p_tab_id

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1076:
1077: EXCEPTION
1078: WHEN others THEN
1079: ROLLBACK TO RollBackPt;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: x_msg_data := SQLERRM;
1082: END add_or_update_tab_view_kpi;
1083:
1084: --Create a new image for the specified p_tab_id and p_tab_view_id

Line 1103: x_return_status := FND_API.G_RET_STS_SUCCESS;

1099: l_str VARCHAR2(100);
1100: BEGIN
1101: SAVEPOINT RollBackPt;
1102: fnd_msg_pub.initialize;
1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:
1105: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL INTO l_next_image_id FROM dual;
1106: x_image_id := l_next_image_id;
1107:

Line 1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1119: );
1120:
1121: EXCEPTION
1122: WHEN others THEN
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1124: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
1125: RAISE;
1126: END;
1127:

Line 1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1139: );
1140: EXCEPTION
1141: WHEN others THEN
1142: ROLLBACK TO RollBackPt;
1143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1144: x_msg_data := SQLERRM;
1145: RAISE;
1146: END create_tab_view_bg;
1147:

Line 1171: x_return_status := FND_API.G_RET_STS_SUCCESS;

1167: l_temp VARCHAR2(100);
1168: BEGIN
1169: SAVEPOINT RollBackPt;
1170: fnd_msg_pub.initialize;
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172:
1173: SELECT count(1) INTO l_count
1174: FROM BSC_SYS_IMAGES bsi, BSC_SYS_IMAGES_MAP_VL bsim
1175: WHERE bsim.source_code = p_tab_id

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1206: AND LAST_UPDATE_DATE <= SYSDATE;
1207: EXCEPTION
1208: WHEN others THEN
1209: ROLLBACK TO RollBackPt;
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
1212: RETURN;
1213: END;
1214:

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1244:
1245: EXCEPTION
1246: WHEN others THEN
1247: ROLLBACK TO RollBackPt;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
1250: RETURN;
1251: END;
1252:

Line 1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1282:
1283: EXCEPTION
1284: WHEN others THEN
1285: ROLLBACK TO RollBackPt;
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1287: x_msg_data := SQLERRM;
1288: END add_or_update_tab_view_bg;
1289:
1290: -- Create or update tab view properties in BSC_TAB_VIEWS_PKG

Line 1313: x_return_status := FND_API.G_RET_STS_SUCCESS;

1309: l_enabled_flag BSC_TAB_VIEWS_B.enabled_flag%TYPE;
1310: BEGIN
1311: SAVEPOINT RollBackPt;
1312: fnd_msg_pub.initialize;
1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314: l_flag := 0;
1315:
1316: IF (is_tab_view_exist(p_tab_id, p_tab_view_id) = 'Y')
1317: THEN

Line 1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1354:
1355: EXCEPTION
1356: WHEN others THEN
1357: ROLLBACK TO RollBackPt;
1358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1359: x_msg_data := 'Insertion to BSC_TAB_VIEWS_PKG failed' || SQLERRM;
1360: RETURN;
1361: END;
1362:

Line 1376: If (p_create_form_Func = FND_API.G_FALSE)Then we will not create the form function

1372: For custom view simulation Enhancement,following are the requirements.
1373: 1.Making CVD an Independent Entity,so that it can be called from Report Designer also.
1374: 2.When called from Report Designer we don't need to create the form function
1375: p_create_form_Func is added to check if we need to create the form fucntion or not.
1376: If (p_create_form_Func = FND_API.G_FALSE)Then we will not create the form function
1377: and when it is set to FND_API.G_TRUE then we will create the form fucntion
1378: /*****************************************************************/
1379: IF (p_create_form_func = FND_API.G_TRUE) THEN
1380: -- Enh 3934298, for each new custom view will create/update a form function to use in DBI

Line 1377: and when it is set to FND_API.G_TRUE then we will create the form fucntion

1373: 1.Making CVD an Independent Entity,so that it can be called from Report Designer also.
1374: 2.When called from Report Designer we don't need to create the form function
1375: p_create_form_Func is added to check if we need to create the form fucntion or not.
1376: If (p_create_form_Func = FND_API.G_FALSE)Then we will not create the form function
1377: and when it is set to FND_API.G_TRUE then we will create the form fucntion
1378: /*****************************************************************/
1379: IF (p_create_form_func = FND_API.G_TRUE) THEN
1380: -- Enh 3934298, for each new custom view will create/update a form function to use in DBI
1381: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function

Line 1379: IF (p_create_form_func = FND_API.G_TRUE) THEN

1375: p_create_form_Func is added to check if we need to create the form fucntion or not.
1376: If (p_create_form_Func = FND_API.G_FALSE)Then we will not create the form function
1377: and when it is set to FND_API.G_TRUE then we will create the form fucntion
1378: /*****************************************************************/
1379: IF (p_create_form_func = FND_API.G_TRUE) THEN
1380: -- Enh 3934298, for each new custom view will create/update a form function to use in DBI
1381: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function
1382: (p_tab_id => p_tab_id,
1383: p_tab_view_id => p_tab_view_id,

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

1389: x_msg_count => x_msg_count,
1390: x_msg_data => x_msg_data
1391: );
1392:
1393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1394: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view Failed: at BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function');
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397:

Line 1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1391: );
1392:
1393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1394: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view Failed: at BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function');
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397:
1398: -- Maps Functional area short name.
1399: IF (p_Func_Area_Short_Name IS NOT NULL) THEN

Line 1402: p_Commit => FND_API.G_FALSE,

1398: -- Maps Functional area short name.
1399: IF (p_Func_Area_Short_Name IS NOT NULL) THEN
1400: BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map
1401: (p_Api_Version => 1.0,
1402: p_Commit => FND_API.G_FALSE,
1403: p_Obj_Type => BSC_UTILITY.BSC_CUSTOM_VIEW,
1404: p_Obj_Name => p_internal_name,
1405: p_App_Id => BSC_UTILITY.BSC_APP_ID,
1406: p_Func_Area_Sht_Name =>p_func_area_short_name,

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

1408: x_msg_count => x_msg_count,
1409: x_msg_data => x_msg_data
1410: );
1411:
1412: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;
1416:

Line 1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1409: x_msg_data => x_msg_data
1410: );
1411:
1412: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: END IF;
1415: END IF;
1416:
1417: END IF;

Line 1419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1415: END IF;
1416:
1417: END IF;
1418: EXCEPTION
1419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1420: ROLLBACK TO RollBackPt;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: if (l_flag = 1)
1423: THEN

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1417: END IF;
1418: EXCEPTION
1419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1420: ROLLBACK TO RollBackPt;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: if (l_flag = 1)
1423: THEN
1424: x_msg_data := 'INVALID_TIMESTAMP';
1425: ELSE

Line 1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1427: END IF;
1428:
1429: WHEN others THEN
1430: ROLLBACK TO RollBackPt;
1431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1432: x_msg_data := SQLERRM;
1433:
1434: END add_or_update_tab_view;
1435:

Line 1467: IF (p_is_default_int_name = FND_API.G_TRUE) THEN

1463: WHERE FUNCTION_NAME = p_internal_name;
1464:
1465: IF (l_count <> 0) THEN
1466: -- If the user has not changed the default internal name then insert the next available
1467: IF (p_is_default_int_name = FND_API.G_TRUE) THEN
1468: l_internal_name := 'BSC_PORTLET_CUSTOM_VIEW_'||p_tab_id||'_'||next_custom_view_id(p_tab_id);
1469: ELSE
1470: -- If the user has changed the internal name and it already exists then will show warning
1471: x_msg_data := BSC_UTILITY.INVALID_CUST_VIEW_NAME;

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1468: l_internal_name := 'BSC_PORTLET_CUSTOM_VIEW_'||p_tab_id||'_'||next_custom_view_id(p_tab_id);
1469: ELSE
1470: -- If the user has changed the internal name and it already exists then will show warning
1471: x_msg_data := BSC_UTILITY.INVALID_CUST_VIEW_NAME;
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: END IF;
1474:
1475: END IF;
1476: END IF;

Line 1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1489: ,x_msg_data => x_msg_data
1490: );
1491:
1492: EXCEPTION
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: WHEN others THEN
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: END add_or_update_tab_view;

Line 1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1490: );
1491:
1492: EXCEPTION
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: WHEN others THEN
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: END add_or_update_tab_view;
1498:

Line 1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1492: EXCEPTION
1493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1495: WHEN others THEN
1496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1497: END add_or_update_tab_view;
1498:
1499: -- Check if the given tab view exists, return 'Y' if it exists, 'N' otherwise
1500: FUNCTION is_tab_view_exist (

Line 1678: x_return_status := FND_API.G_RET_STS_SUCCESS;

1674: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1675: );
1676: END IF;
1677:
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1681: WHEN FND_API.G_EXC_ERROR THEN

1677:
1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1684: ,p_data => x_msg_data);
1685: WHEN OTHERS THEN

Line 1682: x_return_status := FND_API.G_RET_STS_ERROR;

1678: x_return_status := FND_API.G_RET_STS_SUCCESS;
1679:
1680: EXCEPTION
1681: WHEN FND_API.G_EXC_ERROR THEN
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1684: ,p_data => x_msg_data);
1685: WHEN OTHERS THEN
1686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1684: ,p_data => x_msg_data);
1685: WHEN OTHERS THEN
1686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1688: ,p_data => x_msg_data);
1689: if (x_msg_data is null) then
1690: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.create_function' || SQLERRM;

Line 1715: x_return_status := FND_API.G_RET_STS_SUCCESS;

1711: WHERE PARAMETERS LIKE l_param_search_string;
1712:
1713: BEGIN
1714: fnd_msg_pub.initialize;
1715: x_return_status := FND_API.G_RET_STS_SUCCESS;
1716: -- Constracts the PARAMETER to find out FUNCTION_NAME
1717: l_param_search_string := get_param_search_string(p_tab_id,p_tab_view_id);
1718:
1719: FOR cd IN c_verify_function LOOP

Line 1732: p_Commit => FND_API.G_FALSE,

1728: WHERE object_name= l_object_name;
1729:
1730: IF(l_count > 0) THEN
1731: BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map( p_Api_Version => 1.0,
1732: p_Commit => FND_API.G_FALSE,
1733: p_Obj_Type => BSC_UTILITY.BSC_CUSTOM_VIEW,
1734: p_Obj_Name => l_object_name,
1735: p_App_Id => BSC_UTILITY.BSC_APP_ID,
1736: p_Func_Area_Sht_Name =>NULL,

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

1737: x_return_status => x_return_status,
1738: x_msg_count => x_msg_count,
1739: x_msg_data => x_msg_data);
1740:
1741: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: END IF;
1744: END IF;
1745: END LOOP;

Line 1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1738: x_msg_count => x_msg_count,
1739: x_msg_data => x_msg_data);
1740:
1741: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: END IF;
1744: END IF;
1745: END LOOP;
1746:

Line 1749: x_return_status := FND_API.G_RET_STS_ERROR;

1745: END LOOP;
1746:
1747: EXCEPTION
1748: WHEN NO_DATA_FOUND THEN
1749: x_return_status := FND_API.G_RET_STS_ERROR;
1750: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1751: ,p_data => x_msg_data);
1752: if (x_msg_data is null) then
1753: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;

Line 1756: WHEN FND_API.G_EXC_ERROR THEN

1752: if (x_msg_data is null) then
1753: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;
1754: end if;
1755:
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1759: ,p_data => x_msg_data);
1760: WHEN OTHERS THEN

Line 1757: x_return_status := FND_API.G_RET_STS_ERROR;

1753: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;
1754: end if;
1755:
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1759: ,p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1757: x_return_status := FND_API.G_RET_STS_ERROR;
1758: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1759: ,p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1763: ,p_data => x_msg_data);
1764: if (x_msg_data is null) then
1765: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function' || SQLERRM;

Line 1818: x_return_status := FND_API.G_RET_STS_SUCCESS;

1814: -- Date Format used in Report Designer.
1815: l_last_upd_format VARCHAR2(25):= 'YYYY/MM/DD-HH24:MI:SS';
1816: BEGIN
1817: FND_MSG_PUB.INITIALIZE;
1818: x_return_status := FND_API.G_RET_STS_SUCCESS;
1819:
1820: IF (p_time_stamp IS NOT NULL) THEN
1821: SELECT LAST_UPDATE_DATE
1822: INTO l_last_update_date

Line 1831: x_return_status := FND_API.G_RET_STS_ERROR;

1827: IF(p_time_stamp <> TO_CHAR(l_last_update_date, l_last_upd_format)) THEN
1828: FND_MSG_PUB.Initialize;
1829: FND_MESSAGE.SET_NAME('BSC', 'BSC_INVALID_RPT_TIMESTAMP');
1830: FND_MSG_PUB.ADD;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: x_msg_data := 'BSC_INVALID_RPT_TIMESTAMP';
1833: RAISE FND_API.G_EXC_ERROR;
1834: END IF;
1835: END IF;

Line 1833: RAISE FND_API.G_EXC_ERROR;

1829: FND_MESSAGE.SET_NAME('BSC', 'BSC_INVALID_RPT_TIMESTAMP');
1830: FND_MSG_PUB.ADD;
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: x_msg_data := 'BSC_INVALID_RPT_TIMESTAMP';
1833: RAISE FND_API.G_EXC_ERROR;
1834: END IF;
1835: END IF;
1836:
1837: l_Time_Stamp := SYSDATE;

Line 1861: p_Commit => FND_API.G_FALSE

1857:
1858: l_tab_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Name(l_tab_name);
1859: BSC_PMF_UI_WRAPPER.Create_Tab
1860: (
1861: p_Commit => FND_API.G_FALSE
1862: , p_Responsibility_Id => p_resp_Id
1863: , p_Parent_Tab_Id => NULL
1864: , p_Owner_Id => NULL
1865: , p_Short_Name => p_report_sht_name

Line 1874: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN

1870: , p_Tab_Name => l_tab_name
1871: , p_Tab_Help => NULL
1872: , p_Tab_Info => NULL
1873: );
1874: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1876: END IF;
1877: ELSE
1878: SELECT tab_Id

Line 1875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1871: , p_Tab_Help => NULL
1872: , p_Tab_Info => NULL
1873: );
1874: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1876: END IF;
1877: ELSE
1878: SELECT tab_Id
1879: INTO l_tabId

Line 1888: WHEN FND_API.G_EXC_ERROR THEN

1884: x_tab_Id := l_tabId;
1885: x_time_stamp := TO_CHAR(l_Time_Stamp, l_last_upd_format);
1886:
1887: EXCEPTION
1888: WHEN FND_API.G_EXC_ERROR THEN
1889: FND_MSG_PUB.Count_And_Get
1890: ( p_encoded => FND_API.G_FALSE
1891: , p_count => x_msg_count
1892: , p_data => x_msg_data

Line 1890: ( p_encoded => FND_API.G_FALSE

1886:
1887: EXCEPTION
1888: WHEN FND_API.G_EXC_ERROR THEN
1889: FND_MSG_PUB.Count_And_Get
1890: ( p_encoded => FND_API.G_FALSE
1891: , p_count => x_msg_count
1892: , p_data => x_msg_data
1893: );
1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1890: ( p_encoded => FND_API.G_FALSE
1891: , p_count => x_msg_count
1892: , p_data => x_msg_data
1893: );
1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: FND_MSG_PUB.Count_And_Get
1898: ( p_encoded => FND_API.G_FALSE

Line 1895: x_return_status := FND_API.G_RET_STS_ERROR;

1891: , p_count => x_msg_count
1892: , p_data => x_msg_data
1893: );
1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: FND_MSG_PUB.Count_And_Get
1898: ( p_encoded => FND_API.G_FALSE
1899: , p_count => x_msg_count

Line 1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1892: , p_data => x_msg_data
1893: );
1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: FND_MSG_PUB.Count_And_Get
1898: ( p_encoded => FND_API.G_FALSE
1899: , p_count => x_msg_count
1900: , p_data => x_msg_data

Line 1898: ( p_encoded => FND_API.G_FALSE

1894: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1895: x_return_status := FND_API.G_RET_STS_ERROR;
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: FND_MSG_PUB.Count_And_Get
1898: ( p_encoded => FND_API.G_FALSE
1899: , p_count => x_msg_count
1900: , p_data => x_msg_data
1901: );
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1898: ( p_encoded => FND_API.G_FALSE
1899: , p_count => x_msg_count
1900: , p_data => x_msg_data
1901: );
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1904: WHEN NO_DATA_FOUND THEN
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: IF (x_msg_data IS NOT NULL) THEN

Line 1903: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1899: , p_count => x_msg_count
1900: , p_data => x_msg_data
1901: );
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1904: WHEN NO_DATA_FOUND THEN
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: IF (x_msg_data IS NOT NULL) THEN
1907: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

Line 1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1901: );
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1904: WHEN NO_DATA_FOUND THEN
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: IF (x_msg_data IS NOT NULL) THEN
1907: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1908: ELSE
1909: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

Line 1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1909: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1910: END IF;
1911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1912: WHEN OTHERS THEN
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: IF (x_msg_data IS NOT NULL) THEN
1915: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1916: ELSE
1917: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

Line 2128: x_return_status := FND_API.G_RET_STS_SUCCESS;

2124: ) IS
2125: BEGIN
2126: SAVEPOINT addorupdatekpitrend;
2127: fnd_msg_pub.initialize;
2128: x_return_status := FND_API.G_RET_STS_SUCCESS;
2129:
2130: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
2131: p_tab_id => p_tab_id
2132: ,p_tab_view_id => p_tab_view_id

Line 2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2151:
2152: EXCEPTION
2153: WHEN OTHERS THEN
2154: ROLLBACK TO addorupdatekpitrend;
2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2156: x_msg_data := SQLERRM;
2157: END add_or_update_kpi_trend;
2158:
2159: