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

Line 249: x_return_status := FND_API.G_RET_STS_SUCCESS;

245: BEGIN
246:
247: SAVEPOINT CreateSimTreebg;
248: FND_MSG_PUB.INITIALIZE;
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL
252: INTO l_next_image_id
253: FROM dual;

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: );
270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
275: RAISE;
276: END;
277:

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: );
291: EXCEPTION
292: WHEN others THEN
293: ROLLBACK TO CreateSimTreebg;
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: x_msg_data := SQLERRM;
296: RAISE;
297: END Create_Sim_Tree_bg;
298:

Line 331: x_return_status := FND_API.G_RET_STS_SUCCESS;

327: l_next_image_id BSC_SYS_IMAGES.image_id%TYPE;
328: BEGIN
329: SAVEPOINT AddOrUpdateSimTreeBg;
330: FND_MSG_PUB.INITIALIZE;
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333:
334: SELECT COUNT(0)
335: INTO l_count

Line 376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: WHERE IMAGE_ID = p_image_id;
373: EXCEPTION
374: WHEN OTHERS THEN
375: ROLLBACK TO AddOrUpdateSimTreeBg;
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: x_msg_data := 'Update to BSC_SYS_IMAGES failed' || SQLERRM;
378: RETURN;
379: END;
380:

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

415:
416: EXCEPTION
417: WHEN OTHERS THEN
418: ROLLBACK TO AddOrUpdateSimTreeBg;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_data := 'Insertion to BSC_SYS_IMAGES_PKG failed' || SQLERRM;
421: RETURN;
422: END;
423:

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452:
453: EXCEPTION
454: WHEN OTHERS THEN
455: ROLLBACK TO AddOrUpdateSimTreeBg;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: x_msg_data := SQLERRM;
458:
459: END Add_Or_Update_Sim_Tree_Bg;
460:

Line 482: x_return_status := FND_API.G_RET_STS_SUCCESS;

478: l_count NUMBER := 0;
479: BEGIN
480: --DBMS_OUTPUT.PUT_LINE('entering -->'||l_count);
481: FND_MSG_PUB.INITIALIZE;
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483: --DBMS_OUTPUT.PUT_LINE('entering 1 -->'||l_count);
484:
485: x_indicator := NULL;
486: x_ind_group_id := NULL;

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525: END IF;
526: END IF;
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_ERROR -->');
531: FND_MSG_PUB.Count_And_Get
532: ( p_encoded => FND_API.G_FALSE
533: , p_count => x_msg_count

Line 530: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_ERROR -->');

526: END IF;
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_ERROR -->');
531: FND_MSG_PUB.Count_And_Get
532: ( p_encoded => FND_API.G_FALSE
533: , p_count => x_msg_count
534: , p_data => x_msg_data

Line 532: ( p_encoded => FND_API.G_FALSE

528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_ERROR -->');
531: FND_MSG_PUB.Count_And_Get
532: ( p_encoded => FND_API.G_FALSE
533: , p_count => x_msg_count
534: , p_data => x_msg_data
535: );
536: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

532: ( p_encoded => FND_API.G_FALSE
533: , p_count => x_msg_count
534: , p_data => x_msg_data
535: );
536: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');
540: FND_MSG_PUB.Count_And_Get

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

533: , p_count => x_msg_count
534: , p_data => x_msg_data
535: );
536: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE

Line 538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

534: , p_data => x_msg_data
535: );
536: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count

Line 539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');

535: );
536: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count
543: , p_data => x_msg_data

Line 541: ( p_encoded => FND_API.G_FALSE

537: x_return_status := FND_API.G_RET_STS_ERROR;
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count
543: , p_data => x_msg_data
544: );
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count
543: , p_data => x_msg_data
544: );
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
547: WHEN NO_DATA_FOUND THEN
548: --DBMS_OUTPUT.PUT_LINE('FND_API.NO_DATA_FOUND -->');
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

542: , p_count => x_msg_count
543: , p_data => x_msg_data
544: );
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
547: WHEN NO_DATA_FOUND THEN
548: --DBMS_OUTPUT.PUT_LINE('FND_API.NO_DATA_FOUND -->');
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF (x_msg_data IS NOT NULL) THEN

Line 548: --DBMS_OUTPUT.PUT_LINE('FND_API.NO_DATA_FOUND -->');

544: );
545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
547: WHEN NO_DATA_FOUND THEN
548: --DBMS_OUTPUT.PUT_LINE('FND_API.NO_DATA_FOUND -->');
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF (x_msg_data IS NOT NULL) THEN
551: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
552: ELSE

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
546: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
547: WHEN NO_DATA_FOUND THEN
548: --DBMS_OUTPUT.PUT_LINE('FND_API.NO_DATA_FOUND -->');
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF (x_msg_data IS NOT NULL) THEN
551: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
552: ELSE
553: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';

Line 557: --DBMS_OUTPUT.PUT_LINE('FND_API.OTHERS -->');

553: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
554: END IF;
555: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
556: WHEN OTHERS THEN
557: --DBMS_OUTPUT.PUT_LINE('FND_API.OTHERS -->');
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
561: ELSE

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

554: END IF;
555: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
556: WHEN OTHERS THEN
557: --DBMS_OUTPUT.PUT_LINE('FND_API.OTHERS -->');
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
561: ELSE
562: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';

Line 635: x_return_status := FND_API.G_RET_STS_SUCCESS;

631: l_count NUMBER;
632: l_dataset_id BSC_SYS_DATASETS_B.dataset_id%TYPE;
633: BEGIN
634: FND_MSG_PUB.INITIALIZE;
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:
637: l_dataset_id := p_indicator_id;
638: IF(p_SimulateFlag=BSC_SIMULATION_VIEW_PUB.c_NON_SIM_NODE AND p_Node_Id =BSC_SIMULATION_VIEW_PUB.c_DEFAULT_SIM_NODE_ID)THEN
639: l_dataset_id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Node_Short_Name);

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

676: ,x_msg_count => x_msg_count
677: ,x_msg_data => x_msg_data
678: );
679:
680: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: END IF;
683:
684: --save the color into BSC_TAB_VIEW_LABELS table

Line 681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

677: ,x_msg_data => x_msg_data
678: );
679:
680: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
682: END IF;
683:
684: --save the color into BSC_TAB_VIEW_LABELS table
685:

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

705: , x_msg_count => x_msg_count
706: , x_msg_data => x_msg_data
707: );
708:
709: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
713: --Now save the node properties

Line 710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

706: , x_msg_data => x_msg_data
707: );
708:
709: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
711: END IF;
712:
713: --Now save the node properties
714:

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

735: ,x_msg_count => x_msg_count
736: ,x_msg_data => x_msg_data
737: );
738:
739: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742:
743: --Change the default node and set the objective to

Line 740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

736: ,x_msg_data => x_msg_data
737: );
738:
739: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742:
743: --Change the default node and set the objective to
744: -- the color change

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

750: ,x_return_status => x_return_status
751: ,x_msg_count => x_msg_count
752: ,x_msg_data => x_msg_data
753: );
754: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758: BSC_SIMULATION_VIEW_PUB.Save_Color_Ranges

Line 755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

751: ,x_msg_count => x_msg_count
752: ,x_msg_data => x_msg_data
753: );
754: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758: BSC_SIMULATION_VIEW_PUB.Save_Color_Ranges
759: (

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

763: ,x_return_status => x_return_status
764: ,x_msg_count => x_msg_count
765: ,x_msg_data => x_msg_data
766: );
767: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: --We need to set the color_flag in bsc_kpi_measure_props

Line 768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764: ,x_msg_count => x_msg_count
765: ,x_msg_data => x_msg_data
766: );
767: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: --We need to set the color_flag in bsc_kpi_measure_props
772: --

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

782: ,x_msg_count => x_msg_count
783: ,x_msg_data => x_msg_data
784:
785: );
786: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789: END IF;
790:

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

783: ,x_msg_data => x_msg_data
784:
785: );
786: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: END IF;
789: END IF;
790:
791: BSC_SIMULATION_VIEW_PVT.Set_Kpi_Color_Flag

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

798: ,x_msg_count => x_msg_count
799: ,x_msg_data => x_msg_data
800:
801: );
802: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805:
806: BSC_SIMULATION_VIEW_PVT.Set_Ak_Format_Id

Line 803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

799: ,x_msg_data => x_msg_data
800:
801: );
802: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805:
806: BSC_SIMULATION_VIEW_PVT.Set_Ak_Format_Id
807: (

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

812: ,x_msg_count => x_msg_count
813: ,x_msg_data => x_msg_data
814: );
815:
816: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: EXCEPTION

Line 817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

813: ,x_msg_data => x_msg_data
814: );
815:
816: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN

Line 821: WHEN FND_API.G_EXC_ERROR THEN

817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN
822: FND_MSG_PUB.Count_And_Get
823: ( p_encoded => FND_API.G_FALSE
824: , p_count => x_msg_count
825: , p_data => x_msg_data

Line 823: ( p_encoded => FND_API.G_FALSE

819:
820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN
822: FND_MSG_PUB.Count_And_Get
823: ( p_encoded => FND_API.G_FALSE
824: , p_count => x_msg_count
825: , p_data => x_msg_data
826: );
827: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

823: ( p_encoded => FND_API.G_FALSE
824: , p_count => x_msg_count
825: , p_data => x_msg_data
826: );
827: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: FND_MSG_PUB.Count_And_Get
831: ( p_encoded => FND_API.G_FALSE

Line 828: x_return_status := FND_API.G_RET_STS_ERROR;

824: , p_count => x_msg_count
825: , p_data => x_msg_data
826: );
827: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: FND_MSG_PUB.Count_And_Get
831: ( p_encoded => FND_API.G_FALSE
832: , p_count => x_msg_count

Line 829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

825: , p_data => x_msg_data
826: );
827: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: FND_MSG_PUB.Count_And_Get
831: ( p_encoded => FND_API.G_FALSE
832: , p_count => x_msg_count
833: , p_data => x_msg_data

Line 831: ( p_encoded => FND_API.G_FALSE

827: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: FND_MSG_PUB.Count_And_Get
831: ( p_encoded => FND_API.G_FALSE
832: , p_count => x_msg_count
833: , p_data => x_msg_data
834: );
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

831: ( p_encoded => FND_API.G_FALSE
832: , p_count => x_msg_count
833: , p_data => x_msg_data
834: );
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
837: WHEN NO_DATA_FOUND THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF (x_msg_data IS NOT NULL) THEN

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

832: , p_count => x_msg_count
833: , p_data => x_msg_data
834: );
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
837: WHEN NO_DATA_FOUND THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF (x_msg_data IS NOT NULL) THEN
840: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834: );
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
837: WHEN NO_DATA_FOUND THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF (x_msg_data IS NOT NULL) THEN
840: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
841: ELSE
842: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

Line 846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

842: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
843: END IF;
844: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
845: WHEN OTHERS THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: IF (x_msg_data IS NOT NULL) THEN
848: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
849: ELSE
850: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

Line 886: x_return_status := FND_API.G_RET_STS_SUCCESS;

882:
883: BEGIN
884: SAVEPOINT addorupdatesimnodeprops;
885: fnd_msg_pub.initialize;
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: --Node id will be the same as the dataset id
889: --There cannot be two nodes whose dataset_ids are same.
890:

Line 941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: ROLLBACK TO addorupdatesimnodeprops;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
942: x_msg_data := SQLERRM;
943: END add_or_update_sim_node_props;
944:
945:

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

964: ,x_msg_count => x_msg_count
965: ,x_msg_data => x_msg_data
966: ) ;
967:
968: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

965: ,x_msg_data => x_msg_data
966: ) ;
967:
968: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973:

Line 972: WHEN FND_API.G_EXC_ERROR THEN

968: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973:
974: FND_MSG_PUB.Count_And_Get
975: ( p_encoded => FND_API.G_FALSE
976: , p_count => x_msg_count

Line 975: ( p_encoded => FND_API.G_FALSE

971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973:
974: FND_MSG_PUB.Count_And_Get
975: ( p_encoded => FND_API.G_FALSE
976: , p_count => x_msg_count
977: , p_data => x_msg_data
978: );
979: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

975: ( p_encoded => FND_API.G_FALSE
976: , p_count => x_msg_count
977: , p_data => x_msg_data
978: );
979: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
980: x_return_status := FND_API.G_RET_STS_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982:
983: FND_MSG_PUB.Count_And_Get

Line 980: x_return_status := FND_API.G_RET_STS_ERROR;

976: , p_count => x_msg_count
977: , p_data => x_msg_data
978: );
979: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
980: x_return_status := FND_API.G_RET_STS_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982:
983: FND_MSG_PUB.Count_And_Get
984: ( p_encoded => FND_API.G_FALSE

Line 981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

977: , p_data => x_msg_data
978: );
979: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
980: x_return_status := FND_API.G_RET_STS_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982:
983: FND_MSG_PUB.Count_And_Get
984: ( p_encoded => FND_API.G_FALSE
985: , p_count => x_msg_count

Line 984: ( p_encoded => FND_API.G_FALSE

980: x_return_status := FND_API.G_RET_STS_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982:
983: FND_MSG_PUB.Count_And_Get
984: ( p_encoded => FND_API.G_FALSE
985: , p_count => x_msg_count
986: , p_data => x_msg_data
987: );
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

984: ( p_encoded => FND_API.G_FALSE
985: , p_count => x_msg_count
986: , p_data => x_msg_data
987: );
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
990: WHEN NO_DATA_FOUND THEN
991:
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

985: , p_count => x_msg_count
986: , p_data => x_msg_data
987: );
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
990: WHEN NO_DATA_FOUND THEN
991:
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: IF (x_msg_data IS NOT NULL) THEN

Line 992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
990: WHEN NO_DATA_FOUND THEN
991:
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: IF (x_msg_data IS NOT NULL) THEN
994: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
995: ELSE
996: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';

Line 1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

996: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';
997: END IF;
998: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
999: WHEN OTHERS THEN
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: IF (x_msg_data IS NOT NULL) THEN
1002: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
1003: ELSE
1004: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';

Line 1071: x_return_status := FND_API.G_RET_STS_SUCCESS;

1067: -- if it is then get the link id for it and delete the corresponding entry from
1068: -- BSC_KPI_TREE_NODES_VL
1069: SAVEPOINT removesimviewitems;
1070: FND_MSG_PUB.INITIALIZE;
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072:
1073: l_labels := p_labels;
1074:
1075: WHILE (Is_More(p_list_ids => l_labels, p_id => l_id))

Line 1124: p_commit => FND_API.G_FALSE

1120: l_Anal_Opt_Rec.Bsc_Kpi_Id := p_obj_Id;
1121:
1122: BSC_ANALYSIS_OPTION_PUB.Cascade_Deletion_Color_Props
1123: (
1124: p_commit => FND_API.G_FALSE
1125: ,p_Anal_Opt_Rec => l_Anal_Opt_Rec
1126: ,x_return_status => x_return_status
1127: ,x_msg_count => x_msg_count
1128: ,x_msg_data => x_msg_data

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

1126: ,x_return_status => x_return_status
1127: ,x_msg_count => x_msg_count
1128: ,x_msg_data => x_msg_data
1129: ) ;
1130: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133:
1134:

Line 1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1127: ,x_msg_count => x_msg_count
1128: ,x_msg_data => x_msg_data
1129: ) ;
1130: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132: END IF;
1133:
1134:
1135: --Now we will check if the default node was deleted or not.

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

1152: ,x_msg_count => x_msg_count
1153: ,x_msg_data => x_msg_data
1154: );
1155:
1156: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: END IF;
1159: END IF;
1160: END LOOP;

Line 1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1153: ,x_msg_data => x_msg_data
1154: );
1155:
1156: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: END IF;
1159: END IF;
1160: END LOOP;
1161:

Line 1163: WHEN FND_API.G_EXC_ERROR THEN

1159: END IF;
1160: END LOOP;
1161:
1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: ROLLBACK TO removesimviewitems;
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_encoded => FND_API.G_FALSE
1167: , p_count => x_msg_count

Line 1166: ( p_encoded => FND_API.G_FALSE

1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: ROLLBACK TO removesimviewitems;
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_encoded => FND_API.G_FALSE
1167: , p_count => x_msg_count
1168: , p_data => x_msg_data
1169: );
1170: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1166: ( p_encoded => FND_API.G_FALSE
1167: , p_count => x_msg_count
1168: , p_data => x_msg_data
1169: );
1170: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: ROLLBACK TO removesimviewitems;
1174: FND_MSG_PUB.Count_And_Get

Line 1171: x_return_status := FND_API.G_RET_STS_ERROR;

1167: , p_count => x_msg_count
1168: , p_data => x_msg_data
1169: );
1170: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: ROLLBACK TO removesimviewitems;
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_encoded => FND_API.G_FALSE

Line 1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1168: , p_data => x_msg_data
1169: );
1170: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: ROLLBACK TO removesimviewitems;
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_encoded => FND_API.G_FALSE
1176: , p_count => x_msg_count

Line 1175: ( p_encoded => FND_API.G_FALSE

1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: ROLLBACK TO removesimviewitems;
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_encoded => FND_API.G_FALSE
1176: , p_count => x_msg_count
1177: , p_data => x_msg_data
1178: );
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1175: ( p_encoded => FND_API.G_FALSE
1176: , p_count => x_msg_count
1177: , p_data => x_msg_data
1178: );
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1181: WHEN NO_DATA_FOUND THEN
1182: ROLLBACK TO removesimviewitems;
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1176: , p_count => x_msg_count
1177: , p_data => x_msg_data
1178: );
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1181: WHEN NO_DATA_FOUND THEN
1182: ROLLBACK TO removesimviewitems;
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184: IF (x_msg_data IS NOT NULL) THEN

Line 1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1181: WHEN NO_DATA_FOUND THEN
1182: ROLLBACK TO removesimviewitems;
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184: IF (x_msg_data IS NOT NULL) THEN
1185: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1186: ELSE
1187: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';

Line 1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1213: x_return_status := FND_API.G_RET_STS_SUCCESS;

1209: )IS
1210: BEGIN
1211: SAVEPOINT Duplicatekpimetadata;
1212: FND_MSG_PUB.INITIALIZE;
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: --We need to copy the source indicator data from the following tables
1216: --BSC_SYS_IMAGES
1217: --BSC_SYS_IMAGES_MAP_TL

Line 1225: , p_Full_Lock_Flag => FND_API.G_FALSE

1221: --First validate if both the indicators are valid or not
1222: BSC_BIS_LOCKS_PUB.LOCK_KPI
1223: ( p_Kpi_Id => p_source_kpi
1224: , p_time_stamp => NULL
1225: , p_Full_Lock_Flag => FND_API.G_FALSE
1226: , x_return_status => x_return_status
1227: , x_msg_count => x_msg_count
1228: , x_msg_data => x_msg_data
1229: );

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

1226: , x_return_status => x_return_status
1227: , x_msg_count => x_msg_count
1228: , x_msg_data => x_msg_data
1229: );
1230: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;
1233:
1234: BSC_SIMULATION_VIEW_PVT.Duplicate_sim_metadata

Line 1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1227: , x_msg_count => x_msg_count
1228: , x_msg_data => x_msg_data
1229: );
1230: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1232: END IF;
1233:
1234: BSC_SIMULATION_VIEW_PVT.Duplicate_sim_metadata
1235: (

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

1239: ,x_msg_count => x_msg_count
1240: ,x_msg_data => x_msg_data
1241: );
1242:
1243: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246:
1247: EXCEPTION

Line 1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1240: ,x_msg_data => x_msg_data
1241: );
1242:
1243: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246:
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN

Line 1248: WHEN FND_API.G_EXC_ERROR THEN

1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: END IF;
1246:
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO Duplicatekpimetadata;
1250: FND_MSG_PUB.Count_And_Get
1251: ( p_encoded => FND_API.G_FALSE
1252: , p_count => x_msg_count

Line 1251: ( p_encoded => FND_API.G_FALSE

1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO Duplicatekpimetadata;
1250: FND_MSG_PUB.Count_And_Get
1251: ( p_encoded => FND_API.G_FALSE
1252: , p_count => x_msg_count
1253: , p_data => x_msg_data
1254: );
1255: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1251: ( p_encoded => FND_API.G_FALSE
1252: , p_count => x_msg_count
1253: , p_data => x_msg_data
1254: );
1255: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO Duplicatekpimetadata;
1259: FND_MSG_PUB.Count_And_Get

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: , p_count => x_msg_count
1253: , p_data => x_msg_data
1254: );
1255: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO Duplicatekpimetadata;
1259: FND_MSG_PUB.Count_And_Get
1260: ( p_encoded => FND_API.G_FALSE

Line 1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1253: , p_data => x_msg_data
1254: );
1255: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO Duplicatekpimetadata;
1259: FND_MSG_PUB.Count_And_Get
1260: ( p_encoded => FND_API.G_FALSE
1261: , p_count => x_msg_count

Line 1260: ( p_encoded => FND_API.G_FALSE

1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO Duplicatekpimetadata;
1259: FND_MSG_PUB.Count_And_Get
1260: ( p_encoded => FND_API.G_FALSE
1261: , p_count => x_msg_count
1262: , p_data => x_msg_data
1263: );
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1260: ( p_encoded => FND_API.G_FALSE
1261: , p_count => x_msg_count
1262: , p_data => x_msg_data
1263: );
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1266: WHEN NO_DATA_FOUND THEN
1267: ROLLBACK TO Duplicatekpimetadata;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1261: , p_count => x_msg_count
1262: , p_data => x_msg_data
1263: );
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1266: WHEN NO_DATA_FOUND THEN
1267: ROLLBACK TO Duplicatekpimetadata;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF (x_msg_data IS NOT NULL) THEN

Line 1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1265: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1266: WHEN NO_DATA_FOUND THEN
1267: ROLLBACK TO Duplicatekpimetadata;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF (x_msg_data IS NOT NULL) THEN
1270: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1271: ELSE
1272: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

Line 1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1300: x_return_status := FND_API.G_RET_STS_SUCCESS;

1296: l_same_name NUMBER;
1297: BEGIN
1298:
1299: FND_MSG_PUB.INITIALIZE;
1300: x_return_status := FND_API.G_RET_STS_SUCCESS;
1301:
1302:
1303: SELECT COUNT(0)
1304: INTO l_same_name

Line 1315: RAISE FND_API.G_EXC_ERROR;

1311: IF l_same_name <> 0 then
1312: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
1313: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_name);
1314: FND_MSG_PUB.ADD;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317:
1318:
1319: EXCEPTION

Line 1320: WHEN FND_API.G_EXC_ERROR THEN

1316: END IF;
1317:
1318:
1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: FND_MSG_PUB.Count_And_Get
1323: ( p_encoded => FND_API.G_FALSE
1324: , p_count => x_msg_count

Line 1323: ( p_encoded => FND_API.G_FALSE

1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: FND_MSG_PUB.Count_And_Get
1323: ( p_encoded => FND_API.G_FALSE
1324: , p_count => x_msg_count
1325: , p_data => x_msg_data
1326: );
1327: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1323: ( p_encoded => FND_API.G_FALSE
1324: , p_count => x_msg_count
1325: , p_data => x_msg_data
1326: );
1327: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1330:
1331: FND_MSG_PUB.Count_And_Get

Line 1328: x_return_status := FND_API.G_RET_STS_ERROR;

1324: , p_count => x_msg_count
1325: , p_data => x_msg_data
1326: );
1327: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1330:
1331: FND_MSG_PUB.Count_And_Get
1332: ( p_encoded => FND_API.G_FALSE

Line 1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1325: , p_data => x_msg_data
1326: );
1327: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1330:
1331: FND_MSG_PUB.Count_And_Get
1332: ( p_encoded => FND_API.G_FALSE
1333: , p_count => x_msg_count

Line 1332: ( p_encoded => FND_API.G_FALSE

1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1330:
1331: FND_MSG_PUB.Count_And_Get
1332: ( p_encoded => FND_API.G_FALSE
1333: , p_count => x_msg_count
1334: , p_data => x_msg_data
1335: );
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1332: ( p_encoded => FND_API.G_FALSE
1333: , p_count => x_msg_count
1334: , p_data => x_msg_data
1335: );
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1338: WHEN NO_DATA_FOUND THEN
1339:
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1333: , p_count => x_msg_count
1334: , p_data => x_msg_data
1335: );
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1338: WHEN NO_DATA_FOUND THEN
1339:
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF (x_msg_data IS NOT NULL) THEN

Line 1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1337: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1338: WHEN NO_DATA_FOUND THEN
1339:
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF (x_msg_data IS NOT NULL) THEN
1342: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1343: ELSE
1344: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';

Line 1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1344: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1345: END IF;
1346: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1347: WHEN OTHERS THEN
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1351: ELSE
1352: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';

Line 1371: x_return_status := FND_API.G_RET_STS_SUCCESS;

1367: ,x_msg_data OUT NOCOPY VARCHAR2
1368: ) IS
1369: BEGIN
1370: FND_MSG_PUB.INITIALIZE;
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372:
1373: BSC_SIMULATION_VIEW_PVT.Add_Or_Update_YTD
1374: (
1375: p_indicator => p_indicator

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

1378: ,x_return_status => x_return_status
1379: ,x_msg_count => x_msg_count
1380: ,x_msg_data => x_msg_data
1381: );
1382: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: EXCEPTION

Line 1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1379: ,x_msg_count => x_msg_count
1380: ,x_msg_data => x_msg_data
1381: );
1382: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_ERROR THEN

Line 1387: WHEN FND_API.G_EXC_ERROR THEN

1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: END IF;
1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_ERROR THEN
1388:
1389: FND_MSG_PUB.Count_And_Get
1390: ( p_encoded => FND_API.G_FALSE
1391: , p_count => x_msg_count

Line 1390: ( p_encoded => FND_API.G_FALSE

1386: EXCEPTION
1387: WHEN FND_API.G_EXC_ERROR THEN
1388:
1389: FND_MSG_PUB.Count_And_Get
1390: ( p_encoded => FND_API.G_FALSE
1391: , p_count => x_msg_count
1392: , p_data => x_msg_data
1393: );
1394: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1390: ( p_encoded => FND_API.G_FALSE
1391: , p_count => x_msg_count
1392: , p_data => x_msg_data
1393: );
1394: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1397:
1398: FND_MSG_PUB.Count_And_Get

Line 1395: x_return_status := FND_API.G_RET_STS_ERROR;

1391: , p_count => x_msg_count
1392: , p_data => x_msg_data
1393: );
1394: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1397:
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_encoded => FND_API.G_FALSE

Line 1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1392: , p_data => x_msg_data
1393: );
1394: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1397:
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_encoded => FND_API.G_FALSE
1400: , p_count => x_msg_count

Line 1399: ( p_encoded => FND_API.G_FALSE

1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1397:
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_encoded => FND_API.G_FALSE
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1399: ( p_encoded => FND_API.G_FALSE
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1405: WHEN NO_DATA_FOUND THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1405: WHEN NO_DATA_FOUND THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF (x_msg_data IS NOT NULL) THEN

Line 1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1405: WHEN NO_DATA_FOUND THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF (x_msg_data IS NOT NULL) THEN
1409: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1410: ELSE
1411: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

Line 1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1411: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1412: END IF;
1413: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1414: WHEN OTHERS THEN
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF (x_msg_data IS NOT NULL) THEN
1417: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1418: ELSE
1419: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

Line 1439: l_color_ranges_changed VARCHAR2(2) := FND_API.G_FALSE;

1435: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1436: l_count NUMBER;
1437: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1438: l_Bsc_Kpi_Color_Range_New_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1439: l_color_ranges_changed VARCHAR2(2) := FND_API.G_FALSE;
1440:
1441: CURSOR c_color_ranges IS
1442: SELECT a.color_range_sequence,a.low,a.high,a.color_id
1443: FROM bsc_color_ranges a,

Line 1452: x_return_status := FND_API.G_RET_STS_SUCCESS;

1448: ORDER BY a.color_range_sequence;
1449:
1450: BEGIN
1451: FND_MSG_PUB.INITIALIZE;
1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
1455: (
1456: p_indicator => p_indicator

Line 1471: p_commit => FND_API.G_FALSE

1467: END LOOP;
1468:
1469: BSC_COLOR_RANGES_PUB.Save_Color_Prop_Ranges
1470: (
1471: p_commit => FND_API.G_FALSE
1472: , p_objective_id => p_indicator
1473: , p_kpi_measure_id => l_kpi_measure_id
1474: , p_color_type => BSC_SIMULATION_VIEW_PUB.c_PERCENT_OF_TARGET
1475: , p_threshold_color => p_color_ranges

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

1479: , x_msg_count => x_msg_count
1480: , x_msg_data => x_msg_data
1481: );
1482:
1483: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;
1486:
1487: l_count :=0;

Line 1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1480: , x_msg_data => x_msg_data
1481: );
1482:
1483: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: END IF;
1486:
1487: l_count :=0;
1488: FOR cd IN c_color_ranges LOOP

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

1506: ,x_return_status => x_return_status
1507: ,x_msg_count => x_msg_count
1508: ,x_msg_data => x_msg_data
1509: );
1510: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513:
1514:

Line 1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1507: ,x_msg_count => x_msg_count
1508: ,x_msg_data => x_msg_data
1509: );
1510: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: END IF;
1513:
1514:
1515: ELSE

Line 1519: l_color_ranges_changed := FND_API.G_TRUE;

1515: ELSE
1516: FOR l_count IN 0..l_Bsc_Kpi_Color_Range_Rec.COUNT-1 LOOP
1517: IF((l_Bsc_Kpi_Color_Range_Rec(l_count).low <> l_Bsc_Kpi_Color_Range_New_Rec(l_count).low)
1518: OR (l_Bsc_Kpi_Color_Range_Rec(l_count).high <> l_Bsc_Kpi_Color_Range_New_Rec(l_count).high)) THEN
1519: l_color_ranges_changed := FND_API.G_TRUE;
1520:
1521: EXIT;
1522: END IF;
1523: END LOOP;

Line 1525: IF(l_color_ranges_changed =FND_API.G_TRUE)THEN

1521: EXIT;
1522: END IF;
1523: END LOOP;
1524:
1525: IF(l_color_ranges_changed =FND_API.G_TRUE)THEN
1526:
1527: Set_Obj_Kpi_Prototype
1528: (
1529: p_indicator => p_indicator

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

1531: ,x_return_status => x_return_status
1532: ,x_msg_count => x_msg_count
1533: ,x_msg_data => x_msg_data
1534: );
1535: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538: END IF;
1539: END IF;

Line 1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1532: ,x_msg_count => x_msg_count
1533: ,x_msg_data => x_msg_data
1534: );
1535: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1537: END IF;
1538: END IF;
1539: END IF;
1540:

Line 1543: WHEN FND_API.G_EXC_ERROR THEN

1539: END IF;
1540:
1541:
1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544:
1545: FND_MSG_PUB.Count_And_Get
1546: ( p_encoded => FND_API.G_FALSE
1547: , p_count => x_msg_count

Line 1546: ( p_encoded => FND_API.G_FALSE

1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544:
1545: FND_MSG_PUB.Count_And_Get
1546: ( p_encoded => FND_API.G_FALSE
1547: , p_count => x_msg_count
1548: , p_data => x_msg_data
1549: );
1550: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1546: ( p_encoded => FND_API.G_FALSE
1547: , p_count => x_msg_count
1548: , p_data => x_msg_data
1549: );
1550: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553:
1554: FND_MSG_PUB.Count_And_Get

Line 1551: x_return_status := FND_API.G_RET_STS_ERROR;

1547: , p_count => x_msg_count
1548: , p_data => x_msg_data
1549: );
1550: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553:
1554: FND_MSG_PUB.Count_And_Get
1555: ( p_encoded => FND_API.G_FALSE

Line 1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1548: , p_data => x_msg_data
1549: );
1550: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553:
1554: FND_MSG_PUB.Count_And_Get
1555: ( p_encoded => FND_API.G_FALSE
1556: , p_count => x_msg_count

Line 1555: ( p_encoded => FND_API.G_FALSE

1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553:
1554: FND_MSG_PUB.Count_And_Get
1555: ( p_encoded => FND_API.G_FALSE
1556: , p_count => x_msg_count
1557: , p_data => x_msg_data
1558: );
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1555: ( p_encoded => FND_API.G_FALSE
1556: , p_count => x_msg_count
1557: , p_data => x_msg_data
1558: );
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1561: WHEN NO_DATA_FOUND THEN
1562:
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1556: , p_count => x_msg_count
1557: , p_data => x_msg_data
1558: );
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1561: WHEN NO_DATA_FOUND THEN
1562:
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF (x_msg_data IS NOT NULL) THEN

Line 1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1560: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1561: WHEN NO_DATA_FOUND THEN
1562:
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF (x_msg_data IS NOT NULL) THEN
1565: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1566: ELSE
1567: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';

Line 1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1567: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1568: END IF;
1569: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1570: WHEN OTHERS THEN
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1572: IF (x_msg_data IS NOT NULL) THEN
1573: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1574: ELSE
1575: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';

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

1617: ,x_msg_count => x_msg_count
1618: ,x_msg_data => x_msg_data
1619: );
1620:
1621: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624:
1625: EXCEPTION

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1618: ,x_msg_data => x_msg_data
1619: );
1620:
1621: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624:
1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN

Line 1626: WHEN FND_API.G_EXC_ERROR THEN

1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: END IF;
1624:
1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN
1627:
1628: FND_MSG_PUB.Count_And_Get
1629: ( p_encoded => FND_API.G_FALSE
1630: , p_count => x_msg_count

Line 1629: ( p_encoded => FND_API.G_FALSE

1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN
1627:
1628: FND_MSG_PUB.Count_And_Get
1629: ( p_encoded => FND_API.G_FALSE
1630: , p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );
1633: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1629: ( p_encoded => FND_API.G_FALSE
1630: , p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );
1633: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1636:
1637: FND_MSG_PUB.Count_And_Get

Line 1634: x_return_status := FND_API.G_RET_STS_ERROR;

1630: , p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );
1633: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1636:
1637: FND_MSG_PUB.Count_And_Get
1638: ( p_encoded => FND_API.G_FALSE

Line 1635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1631: , p_data => x_msg_data
1632: );
1633: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1636:
1637: FND_MSG_PUB.Count_And_Get
1638: ( p_encoded => FND_API.G_FALSE
1639: , p_count => x_msg_count

Line 1638: ( p_encoded => FND_API.G_FALSE

1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1636:
1637: FND_MSG_PUB.Count_And_Get
1638: ( p_encoded => FND_API.G_FALSE
1639: , p_count => x_msg_count
1640: , p_data => x_msg_data
1641: );
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1638: ( p_encoded => FND_API.G_FALSE
1639: , p_count => x_msg_count
1640: , p_data => x_msg_data
1641: );
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1644: WHEN NO_DATA_FOUND THEN
1645:
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1639: , p_count => x_msg_count
1640: , p_data => x_msg_data
1641: );
1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1644: WHEN NO_DATA_FOUND THEN
1645:
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF (x_msg_data IS NOT NULL) THEN

Line 1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1643: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1644: WHEN NO_DATA_FOUND THEN
1645:
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF (x_msg_data IS NOT NULL) THEN
1648: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1649: ELSE
1650: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';

Line 1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1650: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1651: END IF;
1652: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1653: WHEN OTHERS THEN
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: IF (x_msg_data IS NOT NULL) THEN
1656: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1657: ELSE
1658: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';

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

1695: ,x_msg_count => x_msg_count
1696: ,x_msg_data => x_msg_data
1697: );
1698:
1699: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702:
1703: --/////////////Handle Shared Objectives /////////////

Line 1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1696: ,x_msg_data => x_msg_data
1697: );
1698:
1699: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1700: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1701: END IF;
1702:
1703: --/////////////Handle Shared Objectives /////////////
1704:

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

1709: ,x_return_status => x_return_status
1710: ,x_msg_count => x_msg_count
1711: ,x_msg_data => x_msg_data
1712: );
1713: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: END IF;
1716:
1717: FOR cd IN c_shared_obj LOOP

Line 1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1710: ,x_msg_count => x_msg_count
1711: ,x_msg_data => x_msg_data
1712: );
1713: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715: END IF;
1716:
1717: FOR cd IN c_shared_obj LOOP
1718: BSC_SIMULATION_VIEW_PVT.Set_Sim_Key_Values

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

1723: ,x_msg_count => x_msg_count
1724: ,x_msg_data => x_msg_data
1725: );
1726:
1727: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730: END LOOP;
1731:

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724: ,x_msg_data => x_msg_data
1725: );
1726:
1727: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730: END LOOP;
1731:
1732: EXCEPTION

Line 1733: WHEN FND_API.G_EXC_ERROR THEN

1729: END IF;
1730: END LOOP;
1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734:
1735: FND_MSG_PUB.Count_And_Get
1736: ( p_encoded => FND_API.G_FALSE
1737: , p_count => x_msg_count

Line 1736: ( p_encoded => FND_API.G_FALSE

1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734:
1735: FND_MSG_PUB.Count_And_Get
1736: ( p_encoded => FND_API.G_FALSE
1737: , p_count => x_msg_count
1738: , p_data => x_msg_data
1739: );
1740: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1736: ( p_encoded => FND_API.G_FALSE
1737: , p_count => x_msg_count
1738: , p_data => x_msg_data
1739: );
1740: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743:
1744: FND_MSG_PUB.Count_And_Get

Line 1741: x_return_status := FND_API.G_RET_STS_ERROR;

1737: , p_count => x_msg_count
1738: , p_data => x_msg_data
1739: );
1740: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743:
1744: FND_MSG_PUB.Count_And_Get
1745: ( p_encoded => FND_API.G_FALSE

Line 1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1738: , p_data => x_msg_data
1739: );
1740: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743:
1744: FND_MSG_PUB.Count_And_Get
1745: ( p_encoded => FND_API.G_FALSE
1746: , p_count => x_msg_count

Line 1745: ( p_encoded => FND_API.G_FALSE

1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743:
1744: FND_MSG_PUB.Count_And_Get
1745: ( p_encoded => FND_API.G_FALSE
1746: , p_count => x_msg_count
1747: , p_data => x_msg_data
1748: );
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1745: ( p_encoded => FND_API.G_FALSE
1746: , p_count => x_msg_count
1747: , p_data => x_msg_data
1748: );
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1751: WHEN NO_DATA_FOUND THEN
1752:
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1746: , p_count => x_msg_count
1747: , p_data => x_msg_data
1748: );
1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1751: WHEN NO_DATA_FOUND THEN
1752:
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: IF (x_msg_data IS NOT NULL) THEN

Line 1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1750: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1751: WHEN NO_DATA_FOUND THEN
1752:
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: IF (x_msg_data IS NOT NULL) THEN
1755: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1756: ELSE
1757: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

Line 1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1757: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1758: END IF;
1759: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: IF (x_msg_data IS NOT NULL) THEN
1763: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1764: ELSE
1765: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

Line 1792: x_return_status := FND_API.G_RET_STS_SUCCESS;

1788: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1789:
1790: BEGIN
1791: FND_MSG_PUB.INITIALIZE;
1792: x_return_status := FND_API.G_RET_STS_SUCCESS;
1793:
1794: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
1795: (
1796: p_indicator => p_indicator

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

1806: , x_msg_count => x_msg_count
1807: , x_msg_data => x_msg_data
1808: );
1809:
1810: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END IF;
1813:
1814: FOR cd IN c_def_node LOOP

Line 1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1807: , x_msg_data => x_msg_data
1808: );
1809:
1810: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812: END IF;
1813:
1814: FOR cd IN c_def_node LOOP
1815: IF(cd.property_value =p_dataset_id) THEN

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

1820: , x_return_status => x_return_status
1821: , x_msg_count => x_msg_count
1822: , x_msg_data => x_msg_data
1823: );
1824: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1826: END IF;
1827: END IF;
1828: END LOOP;

Line 1825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1821: , x_msg_count => x_msg_count
1822: , x_msg_data => x_msg_data
1823: );
1824: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1825: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1826: END IF;
1827: END IF;
1828: END LOOP;
1829: EXCEPTION

Line 1830: WHEN FND_API.G_EXC_ERROR THEN

1826: END IF;
1827: END IF;
1828: END LOOP;
1829: EXCEPTION
1830: WHEN FND_API.G_EXC_ERROR THEN
1831:
1832: FND_MSG_PUB.Count_And_Get
1833: ( p_encoded => FND_API.G_FALSE
1834: , p_count => x_msg_count

Line 1833: ( p_encoded => FND_API.G_FALSE

1829: EXCEPTION
1830: WHEN FND_API.G_EXC_ERROR THEN
1831:
1832: FND_MSG_PUB.Count_And_Get
1833: ( p_encoded => FND_API.G_FALSE
1834: , p_count => x_msg_count
1835: , p_data => x_msg_data
1836: );
1837: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

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

1833: ( p_encoded => FND_API.G_FALSE
1834: , p_count => x_msg_count
1835: , p_data => x_msg_data
1836: );
1837: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840:
1841: FND_MSG_PUB.Count_And_Get

Line 1838: x_return_status := FND_API.G_RET_STS_ERROR;

1834: , p_count => x_msg_count
1835: , p_data => x_msg_data
1836: );
1837: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840:
1841: FND_MSG_PUB.Count_And_Get
1842: ( p_encoded => FND_API.G_FALSE

Line 1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1835: , p_data => x_msg_data
1836: );
1837: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840:
1841: FND_MSG_PUB.Count_And_Get
1842: ( p_encoded => FND_API.G_FALSE
1843: , p_count => x_msg_count

Line 1842: ( p_encoded => FND_API.G_FALSE

1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840:
1841: FND_MSG_PUB.Count_And_Get
1842: ( p_encoded => FND_API.G_FALSE
1843: , p_count => x_msg_count
1844: , p_data => x_msg_data
1845: );
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1842: ( p_encoded => FND_API.G_FALSE
1843: , p_count => x_msg_count
1844: , p_data => x_msg_data
1845: );
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1848: WHEN NO_DATA_FOUND THEN
1849:
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1843: , p_count => x_msg_count
1844: , p_data => x_msg_data
1845: );
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1848: WHEN NO_DATA_FOUND THEN
1849:
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: IF (x_msg_data IS NOT NULL) THEN

Line 1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1847: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1848: WHEN NO_DATA_FOUND THEN
1849:
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: IF (x_msg_data IS NOT NULL) THEN
1852: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1853: ELSE
1854: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';

Line 1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1854: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1855: END IF;
1856: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1857: WHEN OTHERS THEN
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859: IF (x_msg_data IS NOT NULL) THEN
1860: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1861: ELSE
1862: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';