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_PMF_UI_WRAPPER dependencies on BSC_PMF_UI_WRAPPER

Line 1: package body BSC_PMF_UI_WRAPPER as

1: package body BSC_PMF_UI_WRAPPER as
2: /* $Header: BSCPMFWB.pls 120.21 2007/06/01 06:49:24 ashankar ship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 59: G_PKG_NAME varchar2(30) := 'BSC_PMF_UI_WRAPPER';

55: | VB to Html |
56: +======================================================================================+
57: */
58:
59: G_PKG_NAME varchar2(30) := 'BSC_PMF_UI_WRAPPER';
60:
61: C_COL_M1_LEVEL1 CONSTANT VARCHAR2(20):= 'COL_M1_LEVEL1';
62: C_COL_M1_LEVEL2 CONSTANT VARCHAR2(20):= 'COL_M1_LEVEL2';
63: C_COL_M2_LEVEL1 CONSTANT VARCHAR2(20):= 'COL_M2_LEVEL1';

Line 434: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';

430: WHEN NO_DATA_FOUND THEN
431: ROLLBACK;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: IF (x_msg_data IS NOT NULL) THEN
434: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
435: ELSE
436: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
437: END IF;
438: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 436: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';

432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: IF (x_msg_data IS NOT NULL) THEN
434: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
435: ELSE
436: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
437: END IF;
438: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
439: WHEN OTHERS THEN
440: ROLLBACK;

Line 443: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';

439: WHEN OTHERS THEN
440: ROLLBACK;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF (x_msg_data IS NOT NULL) THEN
443: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
444: ELSE
445: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
446: END IF;
447: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 445: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';

441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
442: IF (x_msg_data IS NOT NULL) THEN
443: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
444: ELSE
445: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Add_Analysis_Option ';
446: END IF;
447: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
448: END Add_Analysis_Option;
449:

Line 583: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';

579: WHEN NO_DATA_FOUND THEN
580: ROLLBACK TO BSCCrtKPIGrpWrapper;
581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF (x_msg_data IS NOT NULL) THEN
583: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
584: ELSE
585: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
586: END IF;
587: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 585: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';

581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
582: IF (x_msg_data IS NOT NULL) THEN
583: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
584: ELSE
585: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
586: END IF;
587: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
588: WHEN OTHERS THEN
589: ROLLBACK TO BSCCrtKPIGrpWrapper;

Line 592: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';

588: WHEN OTHERS THEN
589: ROLLBACK TO BSCCrtKPIGrpWrapper;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: IF (x_msg_data IS NOT NULL) THEN
592: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
593: ELSE
594: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
595: END IF;
596: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 594: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';

590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: IF (x_msg_data IS NOT NULL) THEN
592: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
593: ELSE
594: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group ';
595: END IF;
596: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
597:
598: end Create_Kpi_Group;

Line 706: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';

702: WHEN NO_DATA_FOUND THEN
703: ROLLBACK TO BSCCrtKPIGrpWrapper;
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF (x_msg_data IS NOT NULL) THEN
706: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
707: ELSE
708: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
709: END IF;
710: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 708: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';

704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: IF (x_msg_data IS NOT NULL) THEN
706: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
707: ELSE
708: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
709: END IF;
710: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
711: WHEN OTHERS THEN
712: ROLLBACK TO BSCCrtKPIGrpWrapper;

Line 715: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';

711: WHEN OTHERS THEN
712: ROLLBACK TO BSCCrtKPIGrpWrapper;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: IF (x_msg_data IS NOT NULL) THEN
715: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
716: ELSE
717: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
718: END IF;
719: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 717: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';

713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: IF (x_msg_data IS NOT NULL) THEN
715: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
716: ELSE
717: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi_Group with parameter x_kpi_group_id ';
718: END IF;
719: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
720:
721: end Create_Kpi_Group;

Line 799: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';

795: WHEN NO_DATA_FOUND THEN
796: ROLLBACK TO BSCUpdKPIGrpWrapper;
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: IF (x_msg_data IS NOT NULL) THEN
799: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
800: ELSE
801: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
802: END IF;
803: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 801: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';

797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798: IF (x_msg_data IS NOT NULL) THEN
799: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
800: ELSE
801: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
802: END IF;
803: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
804: WHEN OTHERS THEN
805: ROLLBACK TO BSCUpdKPIGrpWrapper;

Line 808: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';

804: WHEN OTHERS THEN
805: ROLLBACK TO BSCUpdKPIGrpWrapper;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: IF (x_msg_data IS NOT NULL) THEN
808: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
809: ELSE
810: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
811: END IF;
812: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 810: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';

806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
807: IF (x_msg_data IS NOT NULL) THEN
808: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
809: ELSE
810: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Group ';
811: END IF;
812: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
813: end Update_Kpi_Group;
814:

Line 898: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi ';

894: WHEN NO_DATA_FOUND THEN
895: ROLLBACK TO BSCCreateKPIWrapper;
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: IF (x_msg_data IS NOT NULL) THEN
898: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi ';
899: ELSE
900: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi ';
901: END IF;
902: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 900: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi ';

896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: IF (x_msg_data IS NOT NULL) THEN
898: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi ';
899: ELSE
900: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi ';
901: END IF;
902: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
903: WHEN OTHERS THEN
904: ROLLBACK TO BSCCreateKPIWrapper;

Line 907: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi ';

903: WHEN OTHERS THEN
904: ROLLBACK TO BSCCreateKPIWrapper;
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF (x_msg_data IS NOT NULL) THEN
907: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi ';
908: ELSE
909: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi ';
910: END IF;
911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 909: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi ';

905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF (x_msg_data IS NOT NULL) THEN
907: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi ';
908: ELSE
909: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi ';
910: END IF;
911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
912: end Create_Kpi;
913:

Line 1016: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';

1012: WHEN NO_DATA_FOUND THEN
1013: ROLLBACK TO BSCCreateKPIWrapper;
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: IF (x_msg_data IS NOT NULL) THEN
1016: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1017: ELSE
1018: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1019: END IF;
1020: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1018: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';

1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: IF (x_msg_data IS NOT NULL) THEN
1016: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1017: ELSE
1018: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1019: END IF;
1020: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1021: WHEN OTHERS THEN
1022: ROLLBACK TO BSCCreateKPIWrapper;

Line 1025: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';

1021: WHEN OTHERS THEN
1022: ROLLBACK TO BSCCreateKPIWrapper;
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1024: IF (x_msg_data IS NOT NULL) THEN
1025: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1026: ELSE
1027: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1028: END IF;
1029: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1027: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';

1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1024: IF (x_msg_data IS NOT NULL) THEN
1025: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1026: ELSE
1027: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Kpi with parameter x_kpi_id ';
1028: END IF;
1029: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1030: end Create_Kpi;
1031:

Line 1193: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi ';

1189: WHEN NO_DATA_FOUND THEN
1190: ROLLBACK TO BSCUpdateKPIWrapper;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF (x_msg_data IS NOT NULL) THEN
1193: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi ';
1194: ELSE
1195: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi ';
1196: END IF;
1197: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1195: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi ';

1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF (x_msg_data IS NOT NULL) THEN
1193: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi ';
1194: ELSE
1195: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi ';
1196: END IF;
1197: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1198: WHEN OTHERS THEN
1199: ROLLBACK TO BSCUpdateKPIWrapper;

Line 1202: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi ';

1198: WHEN OTHERS THEN
1199: ROLLBACK TO BSCUpdateKPIWrapper;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: IF (x_msg_data IS NOT NULL) THEN
1202: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi ';
1203: ELSE
1204: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi ';
1205: END IF;
1206: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1204: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi ';

1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: IF (x_msg_data IS NOT NULL) THEN
1202: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi ';
1203: ELSE
1204: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi ';
1205: END IF;
1206: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1207:
1208: end Update_Kpi;

Line 1231: BSC_PMF_UI_WRAPPER.Create_Tab

1227: FND_MSG_PUB.Initialize;
1228: x_return_status := FND_API.G_RET_STS_SUCCESS;
1229: SAVEPOINT BSCPMFUICrtTab;
1230: l_commit := FND_API.G_TRUE;
1231: BSC_PMF_UI_WRAPPER.Create_Tab
1232: ( p_commit => FND_API.G_FALSE
1233: , p_responsibility_id => p_responsibility_id
1234: , p_parent_tab_id => NULL
1235: , p_owner_id => NULL

Line 1278: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';

1274: WHEN NO_DATA_FOUND THEN
1275: ROLLBACK TO BSCPMFUICrtTab;
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: IF (x_msg_data IS NOT NULL) THEN
1278: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1279: ELSE
1280: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1281: END IF;
1282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1280: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';

1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: IF (x_msg_data IS NOT NULL) THEN
1278: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1279: ELSE
1280: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1281: END IF;
1282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1283: WHEN OTHERS THEN
1284: ROLLBACK TO BSCPMFUICrtTab;

Line 1287: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';

1283: WHEN OTHERS THEN
1284: ROLLBACK TO BSCPMFUICrtTab;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: IF (x_msg_data IS NOT NULL) THEN
1287: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1288: ELSE
1289: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1290: END IF;
1291: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1289: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';

1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: IF (x_msg_data IS NOT NULL) THEN
1287: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1288: ELSE
1289: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1290: END IF;
1291: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1292: end Create_Tab;
1293:

Line 1422: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';

1418: WHEN NO_DATA_FOUND THEN
1419: ROLLBACK TO BSCPMFUICrtTab1;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1421: IF (x_msg_data IS NOT NULL) THEN
1422: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1423: ELSE
1424: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1425: END IF;
1426: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1424: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';

1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1421: IF (x_msg_data IS NOT NULL) THEN
1422: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1423: ELSE
1424: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1425: END IF;
1426: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1427: WHEN OTHERS THEN
1428: ROLLBACK TO BSCPMFUICrtTab1;

Line 1431: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';

1427: WHEN OTHERS THEN
1428: ROLLBACK TO BSCPMFUICrtTab1;
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF (x_msg_data IS NOT NULL) THEN
1431: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1432: ELSE
1433: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1434: END IF;
1435: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1433: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';

1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF (x_msg_data IS NOT NULL) THEN
1431: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Tab ';
1432: ELSE
1433: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Tab ';
1434: END IF;
1435: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1436:
1437: end Create_Tab;

Line 1465: BSC_PMF_UI_WRAPPER.Update_Tab

1461: begin
1462: FND_MSG_PUB.Initialize;
1463: x_return_status := FND_API.G_RET_STS_SUCCESS;
1464: SAVEPOINT BSCPMFUIUpdTab;
1465: BSC_PMF_UI_WRAPPER.Update_Tab
1466: ( p_commit => FND_API.G_FALSE
1467: , p_tab_id => p_tab_id
1468: , p_owner_id => NULL
1469: , p_tab_name => p_tab_name

Line 1513: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';

1509: WHEN NO_DATA_FOUND THEN
1510: ROLLBACK TO BSCPMFUIUpdTab;
1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1512: IF (x_msg_data IS NOT NULL) THEN
1513: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1514: ELSE
1515: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1516: END IF;
1517: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1515: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';

1511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1512: IF (x_msg_data IS NOT NULL) THEN
1513: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1514: ELSE
1515: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1516: END IF;
1517: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1518: WHEN OTHERS THEN
1519: ROLLBACK TO BSCPMFUIUpdTab;

Line 1522: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';

1518: WHEN OTHERS THEN
1519: ROLLBACK TO BSCPMFUIUpdTab;
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: IF (x_msg_data IS NOT NULL) THEN
1522: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1523: ELSE
1524: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1525: END IF;
1526: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1524: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';

1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: IF (x_msg_data IS NOT NULL) THEN
1522: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1523: ELSE
1524: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1525: END IF;
1526: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1527:
1528: end Update_Tab;

Line 1685: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';

1681: CLOSE c_Tab_Name;
1682: END IF;
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: IF (x_msg_data IS NOT NULL) THEN
1685: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1686: ELSE
1687: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1688: END IF;
1689: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1687: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';

1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: IF (x_msg_data IS NOT NULL) THEN
1685: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1686: ELSE
1687: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1688: END IF;
1689: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1690: WHEN OTHERS THEN
1691: ROLLBACK TO BSCPMFUIUpdTab1;

Line 1697: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';

1693: CLOSE c_Tab_Name;
1694: END IF;
1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1696: IF (x_msg_data IS NOT NULL) THEN
1697: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1698: ELSE
1699: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1700: END IF;
1701: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1699: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';

1695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1696: IF (x_msg_data IS NOT NULL) THEN
1697: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab ';
1698: ELSE
1699: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab ';
1700: END IF;
1701: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1702:
1703: end Update_Tab;

Line 2052: l_Tabs_Tbl_Type BSC_PMF_UI_WRAPPER.Bsc_Tabs_Tbl_Rec;

2048: l_commit VARCHAR2(10);
2049: l_count NUMBER;
2050: l_Tab_Id BSC_TABS_B.Tab_Id%TYPE;
2051: l_Row_Count NUMBER;
2052: l_Tabs_Tbl_Type BSC_PMF_UI_WRAPPER.Bsc_Tabs_Tbl_Rec;
2053:
2054:
2055: CURSOR c_Tab_Id IS
2056: SELECT DISTINCT A.Tab_Id

Line 2113: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Delete_Kpi Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');

2109: , x_msg_count => x_msg_count
2110: , x_msg_data => x_msg_data
2111: );
2112: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2113: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Delete_Kpi Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116: END LOOP;
2117:

Line 2176: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi ';

2172: END IF;
2173: ROLLBACK TO BSCDelKPIWrapper;
2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2175: IF (x_msg_data IS NOT NULL) THEN
2176: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2177: ELSE
2178: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2179: END IF;
2180: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2178: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi ';

2174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2175: IF (x_msg_data IS NOT NULL) THEN
2176: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2177: ELSE
2178: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2179: END IF;
2180: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2181: WHEN OTHERS THEN
2182:

Line 2189: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi ';

2185: END IF;
2186: ROLLBACK TO BSCDelKPIWrapper;
2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2188: IF (x_msg_data IS NOT NULL) THEN
2189: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2190: ELSE
2191: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2192: END IF;
2193: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2191: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi ';

2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2188: IF (x_msg_data IS NOT NULL) THEN
2189: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2190: ELSE
2191: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi ';
2192: END IF;
2193: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2194: end Delete_Kpi;
2195:

Line 2262: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';

2258: WHEN NO_DATA_FOUND THEN
2259: ROLLBACK TO BSCDelKPIGrpWrapper;
2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: IF (x_msg_data IS NOT NULL) THEN
2262: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2263: ELSE
2264: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2265: END IF;
2266: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2264: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';

2260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2261: IF (x_msg_data IS NOT NULL) THEN
2262: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2263: ELSE
2264: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2265: END IF;
2266: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2267: WHEN OTHERS THEN
2268: ROLLBACK TO BSCDelKPIGrpWrapper;

Line 2271: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';

2267: WHEN OTHERS THEN
2268: ROLLBACK TO BSCDelKPIGrpWrapper;
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: IF (x_msg_data IS NOT NULL) THEN
2271: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2272: ELSE
2273: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2274: END IF;
2275: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2273: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';

2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: IF (x_msg_data IS NOT NULL) THEN
2271: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2272: ELSE
2273: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Kpi_Group ';
2274: END IF;
2275: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2276:
2277: end Delete_Kpi_Group;

Line 2393: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';

2389: WHEN NO_DATA_FOUND THEN
2390: ROLLBACK TO BSCPMFUIDelete;
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2392: IF (x_msg_data IS NOT NULL) THEN
2393: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
2394: ELSE
2395: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
2396: END IF;
2397: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2395: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';

2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2392: IF (x_msg_data IS NOT NULL) THEN
2393: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
2394: ELSE
2395: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
2396: END IF;
2397: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2398: WHEN OTHERS THEN
2399: ROLLBACK TO BSCPMFUIDelete;

Line 2402: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';

2398: WHEN OTHERS THEN
2399: ROLLBACK TO BSCPMFUIDelete;
2400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2401: IF (x_msg_data IS NOT NULL) THEN
2402: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
2403: ELSE
2404: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
2405: END IF;
2406: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2404: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';

2400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2401: IF (x_msg_data IS NOT NULL) THEN
2402: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
2403: ELSE
2404: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
2405: END IF;
2406: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2407:
2408: end Delete_Tab;

Line 2558: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 7');

2554: -- if count is zero then ussigned KPI will be the master, else will be the shared one.
2555: if l_count = 0 then
2556: -- about to create master KPI
2557:
2558: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 7');
2559:
2560:
2561:
2562:

Line 2575: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 8');

2571:
2572: else
2573: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind := l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2574:
2575: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 8');
2576: --DBMS_OUTPUT.PUT_LINE('l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind -'||l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Source_Ind );
2577:
2578:
2579: BSC_KPI_PUB.Create_Shared_Kpi( FND_API.G_FALSE

Line 2606: --BSC_DEBUG.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 11');

2602:
2603:
2604: end if;
2605:
2606: --BSC_DEBUG.PUT_LINE('BSC_PMF_UI_WRAPPER.Assign_KPI - Flag 11');
2607:
2608: -- Need to call procedure for list button logic.
2609:
2610:

Line 2648: --BSC_DEBUG.PUT_LINE('End BSC_PMF_UI_WRAPPER.Assign_KPI' );

2644: COMMIT;
2645: END IF;
2646:
2647:
2648: --BSC_DEBUG.PUT_LINE('End BSC_PMF_UI_WRAPPER.Assign_KPI' );
2649: --BSC_DEBUG.finish;
2650:
2651: EXCEPTION
2652: WHEN FND_API.G_EXC_ERROR THEN

Line 2678: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_KPI ';

2674: WHEN NO_DATA_FOUND THEN
2675: ROLLBACK TO BscPmfUIAssignKpi;
2676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2677: IF (x_msg_data IS NOT NULL) THEN
2678: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_KPI ';
2679: ELSE
2680: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_KPI ';
2681: END IF;
2682: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2680: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_KPI ';

2676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2677: IF (x_msg_data IS NOT NULL) THEN
2678: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_KPI ';
2679: ELSE
2680: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_KPI ';
2681: END IF;
2682: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2683: WHEN OTHERS THEN
2684: ROLLBACK TO BscPmfUIAssignKpi;

Line 2687: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_KPI ';

2683: WHEN OTHERS THEN
2684: ROLLBACK TO BscPmfUIAssignKpi;
2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: IF (x_msg_data IS NOT NULL) THEN
2687: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_KPI ';
2688: ELSE
2689: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_KPI ';
2690: END IF;
2691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2689: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_KPI ';

2685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2686: IF (x_msg_data IS NOT NULL) THEN
2687: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_KPI ';
2688: ELSE
2689: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_KPI ';
2690: END IF;
2691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2692:
2693: end Assign_KPI;

Line 3008: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Unassign_KPI Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');

3004: , x_msg_count => x_msg_count
3005: , x_msg_data => x_msg_data
3006: );
3007: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3008: --DBMS_OUTPUT.PUT_LINE('BSC_PMF_UI_WRAPPER.Unassign_KPI Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');
3009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3010: END IF;
3011:
3012: -- Need to fix bug 3543675

Line 3079: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Unassign_KPI ';

3075: WHEN NO_DATA_FOUND THEN
3076: ROLLBACK TO BscPmfUIUnAssignKpi;
3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3078: IF (x_msg_data IS NOT NULL) THEN
3079: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3080: ELSE
3081: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3082: END IF;
3083: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3081: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Unassign_KPI ';

3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3078: IF (x_msg_data IS NOT NULL) THEN
3079: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3080: ELSE
3081: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3082: END IF;
3083: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3084: WHEN OTHERS THEN
3085: ROLLBACK TO BscPmfUIUnAssignKpi;

Line 3088: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Unassign_KPI ';

3084: WHEN OTHERS THEN
3085: ROLLBACK TO BscPmfUIUnAssignKpi;
3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3089: ELSE
3090: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3091: END IF;
3092: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3090: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Unassign_KPI ';

3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3089: ELSE
3090: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Unassign_KPI ';
3091: END IF;
3092: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3093:
3094: end Unassign_KPI;

Line 3209: BSC_PMF_UI_WRAPPER.Assign_KPI(

3205: FETCH c_kpis INTO l_kpi_id;
3206: EXIT WHEN c_kpis%NOTFOUND;
3207:
3208:
3209: BSC_PMF_UI_WRAPPER.Assign_KPI(
3210: p_Commit => FND_API.G_FALSE
3211: ,p_kpi_id => l_kpi_id
3212: ,p_tab_id => p_tab_id
3213: ,x_return_status => x_return_status

Line 3283: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Assign_Analysis_Option');

3279: Begin
3280: FND_MSG_PUB.Initialize;
3281: x_return_status := FND_API.G_RET_STS_SUCCESS;
3282: SAVEPOINT BscPmfUIUAssignAnaOpt;
3283: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Assign_Analysis_Option');
3284: FND_MSG_PUB.Initialize;
3285:
3286: IF p_time_stamp_to_check IS NOT NULL then
3287: l_time_stamp := get_KPI_Time_Stamp(p_kpi_id);

Line 3333: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Assign_Analysis_Option');

3329:
3330: END IF;
3331:
3332:
3333: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Assign_Analysis_Option');
3334:
3335: EXCEPTION
3336: WHEN FND_API.G_EXC_ERROR THEN
3337: rollback to BscPmfUIUAssignAnaOpt;

Line 3434: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Unassign_Analysis_Option');

3430:
3431: END IF;
3432:
3433:
3434: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Unassign_Analysis_Option');
3435:
3436: EXCEPTION
3437: WHEN FND_API.G_EXC_ERROR THEN
3438: rollback to BscPmfUIUnAssignAnaOpt;

Line 3480: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Is_Analysis_Option_Selected');

3476:
3477: Begin
3478: FND_MSG_PUB.Initialize;
3479: x_return_status := FND_API.G_RET_STS_SUCCESS;
3480: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Is_Analysis_Option_Selected');
3481:
3482: -- it return Empty if option does not exist
3483: temp := '';
3484: -- populate the record l_Bsc_kpi_Entity_Rec with the parameters

Line 3506: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Is_Analysis_Option_Selected - return ' || temp);

3502: ,x_return_status
3503: ,x_msg_count
3504: ,x_msg_data );
3505:
3506: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Is_Analysis_Option_Selected - return ' || temp);
3507:
3508: return temp;
3509:
3510: EXCEPTION

Line 3537: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Is_Leaf_Analysis_Option ');

3533:
3534: Begin
3535: FND_MSG_PUB.Initialize;
3536: x_return_status := FND_API.G_RET_STS_SUCCESS;
3537: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Is_Leaf_Analysis_Option ');
3538:
3539:
3540: l_Bsc_kpi_Entity_Rec.Bsc_kpi_Id := p_kpi_id;
3541: l_Bsc_kpi_Entity_Rec.Bsc_kpi_Group_Id := p_analysis_group_id;

Line 3579: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Is_Leaf_Analysis_Option - return ' || temp);

3575: temp := '';
3576: end if;
3577:
3578:
3579: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Is_Leaf_Analysis_Option - return ' || temp);
3580:
3581: return temp;
3582:
3583: EXCEPTION

Line 3609: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec');

3605: l_count number;
3606: Begin
3607: FND_MSG_PUB.Initialize;
3608: x_return_status := FND_API.G_RET_STS_SUCCESS;
3609: --DBMS_OUTPUT.PUT_LINE('Begin BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec');
3610:
3611: -- Evaluate if the Analysis option Exist in the Metadata
3612: select count(option_id)
3613: into l_count

Line 3623: --DBMS_OUTPUT.PUT_LINE('--BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec - BSC_NO_VALUE_FOUND ');

3619: and grandparent_option_id = p_grandparent_option_id;
3620:
3621: if l_count = 0 then
3622: -- l_count = 0 means the option does not exist
3623: --DBMS_OUTPUT.PUT_LINE('--BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec - BSC_NO_VALUE_FOUND ');
3624: FND_MSG_PUB.Initialize;
3625: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3626: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', 'Populate_Option_Dependency_Rec');
3627: FND_MSG_PUB.ADD;

Line 3676: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec');

3672: end if;
3673: p_Bsc_kpi_Entity_Rec.Bsc_kpi_Analysis_Option2 := p_option_id;
3674: end if;
3675:
3676: --DBMS_OUTPUT.PUT_LINE('End BSC_PMF_UI_WRAPPER.Populate_Option_Dependency_Rec');
3677:
3678:
3679: EXCEPTION
3680:

Line 4333: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Order_Tab_Index ';

4329: WHEN NO_DATA_FOUND THEN
4330: ROLLBACK TO BscPmfUIOrdTabIndex;
4331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4332: IF (x_msg_data IS NOT NULL) THEN
4333: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4334: ELSE
4335: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4336: END IF;
4337: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 4335: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Order_Tab_Index ';

4331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4332: IF (x_msg_data IS NOT NULL) THEN
4333: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4334: ELSE
4335: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4336: END IF;
4337: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4338: WHEN OTHERS THEN
4339: ROLLBACK TO BscPmfUIOrdTabIndex;

Line 4342: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Order_Tab_Index ';

4338: WHEN OTHERS THEN
4339: ROLLBACK TO BscPmfUIOrdTabIndex;
4340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4341: IF (x_msg_data IS NOT NULL) THEN
4342: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4343: ELSE
4344: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4345: END IF;
4346: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 4344: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Order_Tab_Index ';

4340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4341: IF (x_msg_data IS NOT NULL) THEN
4342: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4343: ELSE
4344: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Order_Tab_Index ';
4345: END IF;
4346: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
4347:
4348: end Order_Tab_Index;

Line 4529: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';

4525: WHEN NO_DATA_FOUND THEN
4526: ROLLBACK TO BscPmfUIUptTabParent;
4527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4528: IF (x_msg_data IS NOT NULL) THEN
4529: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4530: ELSE
4531: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4532: END IF;
4533: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 4531: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';

4527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4528: IF (x_msg_data IS NOT NULL) THEN
4529: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4530: ELSE
4531: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4532: END IF;
4533: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4534: WHEN OTHERS THEN
4535: ROLLBACK TO BscPmfUIUptTabParent;

Line 4538: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';

4534: WHEN OTHERS THEN
4535: ROLLBACK TO BscPmfUIUptTabParent;
4536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4537: IF (x_msg_data IS NOT NULL) THEN
4538: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4539: ELSE
4540: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4541: END IF;
4542: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 4540: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';

4536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4537: IF (x_msg_data IS NOT NULL) THEN
4538: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4539: ELSE
4540: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Tab_Parent ';
4541: END IF;
4542: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
4543:
4544:

Line 4628: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Measure ';

4624: WHEN NO_DATA_FOUND THEN
4625: ROLLBACK TO BscPmfUICrtMeas;
4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627: IF (x_msg_data IS NOT NULL) THEN
4628: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Measure ';
4629: ELSE
4630: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Measure ';
4631: END IF;
4632: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 4630: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Measure ';

4626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4627: IF (x_msg_data IS NOT NULL) THEN
4628: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Measure ';
4629: ELSE
4630: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Measure ';
4631: END IF;
4632: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4633: WHEN OTHERS THEN
4634: ROLLBACK TO BscPmfUICrtMeas;

Line 4637: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Measure ';

4633: WHEN OTHERS THEN
4634: ROLLBACK TO BscPmfUICrtMeas;
4635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4636: IF (x_msg_data IS NOT NULL) THEN
4637: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Measure ';
4638: ELSE
4639: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Measure ';
4640: END IF;
4641: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 4639: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Measure ';

4635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4636: IF (x_msg_data IS NOT NULL) THEN
4637: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Create_Measure ';
4638: ELSE
4639: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Create_Measure ';
4640: END IF;
4641: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
4642:
4643:

Line 4692: x_source => 'BSC_PMF_UI_WRAPPER.Create_Measure_Vb',

4688:
4689: EXCEPTION
4690: WHEN e_error THEN
4691: BSC_MESSAGE.Add(x_message => bsc_apps.get_message('BSC_MEASURE_NOT_IMPORTED'),
4692: x_source => 'BSC_PMF_UI_WRAPPER.Create_Measure_Vb',
4693: x_mode => 'I');
4694: COMMIT;
4695: WHEN OTHERS THEN
4696: BSC_MESSAGE.Add(x_message => SQLERRM,

Line 4697: x_source => 'BSC_PMF_UI_WRAPPER.Create_Measure_Vb',

4693: x_mode => 'I');
4694: COMMIT;
4695: WHEN OTHERS THEN
4696: BSC_MESSAGE.Add(x_message => SQLERRM,
4697: x_source => 'BSC_PMF_UI_WRAPPER.Create_Measure_Vb',
4698: x_mode => 'I');
4699: COMMIT;
4700: end Create_Measure_VB;
4701:

Line 5105: BSC_PMF_UI_WRAPPER.Assign_KPI

5101: WHILE (is_more( p_dim_short_names => l_kpi_ids
5102: ,p_dim_name => l_kpi_id)
5103: ) LOOP
5104:
5105: BSC_PMF_UI_WRAPPER.Assign_KPI
5106: (
5107: p_commit => FND_API.G_FALSE
5108: , p_kpi_id => l_kpi_id
5109: , p_tab_id => p_tab_id

Line 5154: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_Kpi_Tab ';

5150: WHEN OTHERS THEN
5151: rollback TO BscPmfUIAssignKpiTab;
5152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5153: IF (x_msg_data IS NOT NULL) THEN
5154: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_Kpi_Tab ';
5155: ELSE
5156: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_Kpi_Tab ';
5157: END IF;
5158:

Line 5156: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_Kpi_Tab ';

5152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5153: IF (x_msg_data IS NOT NULL) THEN
5154: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Assign_Kpi_Tab ';
5155: ELSE
5156: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Assign_Kpi_Tab ';
5157: END IF;
5158:
5159: END Assign_Kpi_Tab;
5160:

Line 5413: x_msg_data := x_msg_data||' ->BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';

5409: WHEN NO_DATA_FOUND THEN
5410: ROLLBACK TO UpdatePeriodicityPropsPUB;
5411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5412: IF (x_msg_data IS NOT NULL) THEN
5413: x_msg_data := x_msg_data||' ->BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5414: ELSE
5415: x_msg_data := SQLERRM||'BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5416: END IF;
5417: WHEN OTHERS THEN

Line 5415: x_msg_data := SQLERRM||'BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';

5411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5412: IF (x_msg_data IS NOT NULL) THEN
5413: x_msg_data := x_msg_data||' ->BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5414: ELSE
5415: x_msg_data := SQLERRM||'BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5416: END IF;
5417: WHEN OTHERS THEN
5418: ROLLBACK TO UpdatePeriodicityPropsPUB;
5419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5421: x_msg_data := x_msg_data||' ->BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';

5417: WHEN OTHERS THEN
5418: ROLLBACK TO UpdatePeriodicityPropsPUB;
5419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5420: IF (x_msg_data IS NOT NULL) THEN
5421: x_msg_data := x_msg_data||' ->BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5422: ELSE
5423: x_msg_data := SQLERRM||'BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5424: END IF;
5425: END Update_Periodicity_Props;

Line 5423: x_msg_data := SQLERRM||'BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';

5419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5420: IF (x_msg_data IS NOT NULL) THEN
5421: x_msg_data := x_msg_data||' ->BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5422: ELSE
5423: x_msg_data := SQLERRM||'BSC_PMF_UI_WRAPPER.Update_Periodicity_Props ';
5424: END IF;
5425: END Update_Periodicity_Props;
5426:
5427:

Line 5896: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities ';

5892: CLOSE c_share_kpis;
5893: END IF;
5894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5895: IF (x_msg_data IS NOT NULL) THEN
5896: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities ';
5897: ELSE
5898: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities ';
5899: END IF;
5900: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 5898: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities ';

5894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5895: IF (x_msg_data IS NOT NULL) THEN
5896: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities ';
5897: ELSE
5898: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Update_Kpi_Periodicities ';
5899: END IF;
5900: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
5901:
5902: end Update_Kpi_Periodicities;

Line 5956: BSC_PMF_UI_WRAPPER.Check_Tabviews(

5952: OPEN c_scr;
5953: FETCH c_scr INTO l_scr_name,l_scr_short_name;
5954: CLOSE c_scr;
5955:
5956: BSC_PMF_UI_WRAPPER.Check_Tabviews(
5957: p_tab_id => p_tab_id
5958: , p_list_dependency => FND_API.G_TRUE
5959: , x_exist_dependency => l_exist_dependency
5960: , x_dep_obj_list => l_dep_obj_list

Line 6072: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';

6068: CLOSE c_scr;
6069: END IF;
6070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6071: IF (x_msg_data IS NOT NULL) THEN
6072: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
6073: ELSE
6074: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
6075: END IF;
6076: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 6074: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';

6070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6071: IF (x_msg_data IS NOT NULL) THEN
6072: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
6073: ELSE
6074: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
6075: END IF;
6076: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
6077: WHEN OTHERS THEN
6078: IF (c_scr%ISOPEN) THEN

Line 6083: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';

6079: CLOSE c_scr;
6080: END IF;
6081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6082: IF (x_msg_data IS NOT NULL) THEN
6083: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
6084: ELSE
6085: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
6086: END IF;
6087: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 6085: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';

6081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6082: IF (x_msg_data IS NOT NULL) THEN
6083: x_msg_data := x_msg_data||' -> BSC_PMF_UI_WRAPPER.Delete_Tab ';
6084: ELSE
6085: x_msg_data := SQLERRM||' at BSC_PMF_UI_WRAPPER.Delete_Tab ';
6086: END IF;
6087: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
6088: end Check_Tab;
6089:

Line 6122: BSC_PMF_UI_WRAPPER.Check_Tabview_Dependency( p_tab_id => p_tab_id

6118: FOR cd_tab_view IN c_tab_views LOOP
6119: l_tab_view_id := cd_tab_view.tab_view_id;
6120: l_tab_view_name := cd_tab_view.NAME;
6121:
6122: BSC_PMF_UI_WRAPPER.Check_Tabview_Dependency( p_tab_id => p_tab_id
6123: ,p_tab_view_id => l_tab_view_id
6124: ,p_list_dependency => p_list_dependency
6125: ,x_exist_dependency => l_exist_dependency
6126: ,x_dep_obj_list => l_temp_list

Line 6270: WHERE bsim.source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6266: SELECT COUNT(0)
6267: INTO l_count
6268: FROM bsc_sys_images bsi,
6269: bsc_sys_images_map_vl bsim
6270: WHERE bsim.source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6271: AND bsim.source_code = p_tab_id
6272: AND bsim.type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6273: AND bsim.image_id = p_image_id
6274: AND bsim.image_id = bsi.image_id;

Line 6272: AND bsim.type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6268: FROM bsc_sys_images bsi,
6269: bsc_sys_images_map_vl bsim
6270: WHERE bsim.source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6271: AND bsim.source_code = p_tab_id
6272: AND bsim.type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6273: AND bsim.image_id = p_image_id
6274: AND bsim.image_id = bsi.image_id;
6275:
6276:

Line 6283: WHERE source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6279:
6280: SELECT COUNT(0)
6281: INTO l_count
6282: FROM bsc_sys_images_map_TL
6283: WHERE source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6284: AND source_code = p_tab_id
6285: AND type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6286: AND image_id = p_image_id
6287: AND source_lang = USERENV('LANG');

Line 6285: AND type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6281: INTO l_count
6282: FROM bsc_sys_images_map_TL
6283: WHERE source_type =BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6284: AND source_code = p_tab_id
6285: AND type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6286: AND image_id = p_image_id
6287: AND source_lang = USERENV('LANG');
6288:
6289: IF (l_count > 0) THEN

Line 6315: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6311: END;
6312:
6313: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
6314: (
6315: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6316: ,X_SOURCE_CODE => p_tab_id
6317: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6318: ,X_IMAGE_ID => p_image_id
6319: ,X_CREATION_DATE => SYSDATE

Line 6317: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6313: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
6314: (
6315: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6316: ,X_SOURCE_CODE => p_tab_id
6317: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6318: ,X_IMAGE_ID => p_image_id
6319: ,X_CREATION_DATE => SYSDATE
6320: ,X_CREATED_BY => fnd_global.user_id
6321: ,X_LAST_UPDATE_DATE => SYSDATE

Line 6358: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6354: END;
6355:
6356: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
6357: (
6358: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6359: ,X_SOURCE_CODE => p_tab_id
6360: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6361: ,X_IMAGE_ID => p_image_id
6362: ,X_CREATION_DATE => SYSDATE

Line 6360: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6356: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
6357: (
6358: X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6359: ,X_SOURCE_CODE => p_tab_id
6360: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6361: ,X_IMAGE_ID => p_image_id
6362: ,X_CREATION_DATE => SYSDATE
6363: ,X_CREATED_BY => fnd_global.user_id
6364: ,X_LAST_UPDATE_DATE => SYSDATE

Line 6446: ,X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6442:
6443: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW
6444: (
6445: X_ROWID => l_str
6446: ,X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6447: ,X_SOURCE_CODE => p_obj_id
6448: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6449: ,X_IMAGE_ID => l_next_image_id
6450: ,X_CREATION_DATE => SYSDATE

Line 6448: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6444: (
6445: X_ROWID => l_str
6446: ,X_SOURCE_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6447: ,X_SOURCE_CODE => p_obj_id
6448: ,X_TYPE => BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6449: ,X_IMAGE_ID => l_next_image_id
6450: ,X_CREATION_DATE => SYSDATE
6451: ,X_CREATED_BY => fnd_global.user_id
6452: ,X_LAST_UPDATE_DATE => SYSDATE

Line 6478: WHERE source_type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE

6474: )IS
6475: CURSOR c_tab_logo IS
6476: SELECT image_id
6477: FROM bsc_sys_images_map_tl
6478: WHERE source_type = BSC_PMF_UI_WRAPPER.C_SCORECARD_LOGO_TYPE
6479: AND source_code = p_tab_id;
6480:
6481: l_image_id BSC_SYS_IMAGES_MAP_TL.image_id%TYPE;
6482:

Line 6509: END BSC_PMF_UI_WRAPPER;

6505: END Delete_Tab_Logo;
6506:
6507:
6508:
6509: END BSC_PMF_UI_WRAPPER;