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

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

220: l_One_N_Count NUMBER := 0;
221: l_M_N_Count NUMBER := 0;
222: BEGIN
223: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.get_Original_Relations Procedure');
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: FOR cd IN c_keep_original_rels LOOP
226: --for one to many relations where cd.Relation_Type = 1
227: IF ((l_One_N_Count = 0) AND (cd.Relation_Type = 1)) THEN
228: x_One_N_Table(l_One_N_Count).p_dim_obj_id := cd.Dim_Level_Id;

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: END LOOP;
262: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.get_Original_Relations Procedure');
263: EXCEPTION
264: WHEN NO_DATA_FOUND THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: IF (x_msg_data IS NOT NULL) THEN
267: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.get_Original_Relations ';
268: ELSE
269: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.get_Original_Relations ';

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.get_Original_Relations ';
270: END IF;
271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
272: WHEN OTHERS THEN
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: IF (x_msg_data IS NOT NULL) THEN
275: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.get_Original_Relations ';
276: ELSE
277: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.get_Original_Relations ';

Line 312: x_return_status := FND_API.G_RET_STS_SUCCESS;

308:
309: l_Count NUMBER;
310:
311: BEGIN
312: x_return_status := FND_API.G_RET_STS_SUCCESS;
313: l_Count := 0;
314:
315: FOR cd IN c_relations LOOP
316: x_rel_Table(l_Count).p_Dim_Obj_ID := cd.Dim_Level_Id;

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

322: END LOOP;
323:
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: IF (x_msg_data IS NOT NULL) THEN
328: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.store_Relations ';
329: ELSE
330: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.store_Relations ';

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

330: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.store_Relations ';
331: END IF;
332: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
333: WHEN OTHERS THEN
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: IF (x_msg_data IS NOT NULL) THEN
336: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.store_Relations ';
337: ELSE
338: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.store_Relations ';

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458: l_Sql VARCHAR2(32000);
459: l_cursor BSC_BIS_LOCKS_PUB.t_cursor;
460: BEGIN
461: FND_MSG_PUB.Initialize;
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:
464: IF((p_dim_obj_id IS NOT NULL) AND (p_par_dim_obj_id IS NOT NULL)) THEN
465: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_dim_obj_id)
466: AND(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_par_dim_obj_id)))THEN

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

473: , x_return_status => x_return_status
474: , x_msg_Count => x_msg_count
475: , x_msg_data => x_msg_data
476: );
477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: IF(l_common_tabs IS NOT NULL) THEN

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

474: , x_msg_Count => x_msg_count
475: , x_msg_data => x_msg_data
476: );
477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480:
481: IF(l_common_tabs IS NOT NULL) THEN
482: WHILE (is_more( p_dim_lev_ids => l_common_tabs

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

488: , x_return_status => x_return_status
489: , x_msg_COUNT => x_msg_count
490: , x_msg_data => x_msg_data
491: );
492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END LOOP;
496: END IF;

Line 493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

489: , x_msg_COUNT => x_msg_count
490: , x_msg_data => x_msg_data
491: );
492: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
494: END IF;
495: END LOOP;
496: END IF;
497: ELSIF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_dim_obj_id)

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

523: , x_return_status => x_return_status
524: , x_msg_COUNT => x_msg_count
525: , x_msg_data => x_msg_data
526: );
527: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: END LOOP;
531: END IF;

Line 528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

524: , x_msg_COUNT => x_msg_count
525: , x_msg_data => x_msg_data
526: );
527: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
529: END IF;
530: END LOOP;
531: END IF;
532: END IF;

Line 536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

532: END IF;
533:
534:
535: EXCEPTION
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: IF (x_msg_data IS NULL) THEN
538: FND_MSG_PUB.Count_And_Get
539: ( p_encoded => FND_API.G_FALSE
540: , p_count => x_msg_count

Line 539: ( p_encoded => FND_API.G_FALSE

535: EXCEPTION
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: IF (x_msg_data IS NULL) THEN
538: FND_MSG_PUB.Count_And_Get
539: ( p_encoded => FND_API.G_FALSE
540: , p_count => x_msg_count
541: , p_data => x_msg_data
542: );
543: END IF;

Line 544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

543: END IF;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
546: WHEN NO_DATA_FOUND THEN
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF (x_msg_data IS NOT NULL) THEN
549: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs ';
550: ELSE
551: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs ';

Line 555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593:
594: BEGIN
595:
596: FND_MSG_PUB.Initialize;
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: BSC_APPS.Init_Bsc_Apps;
599:
600: IF(BSC_UTILITY.is_View_Exists(p_level_view_name)) THEN
601: l_Sql := C_SELECT || C_SELECT_CLAUSE

Line 669: x_return_status := FND_API.G_RET_STS_SUCCESS;

665:
666:
667: BEGIN
668: FND_MSG_PUB.Initialize;
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: l_new_count := x_new_rel_Table.COUNT;
672: l_old_count := x_prev_rel_Table.COUNT;
673:

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

688: , x_return_status => x_return_status
689: , x_msg_count => x_msg_count
690: , x_msg_data => x_msg_data
691: );
692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: END IF;
696: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;

Line 693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

689: , x_msg_count => x_msg_count
690: , x_msg_data => x_msg_data
691: );
692: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: END IF;
696: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
697: END LOOP;

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

711: , x_return_status => x_return_status
712: , x_msg_count => x_msg_count
713: , x_msg_data => x_msg_data
714: );
715: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: END IF;
719: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

712: , x_msg_count => x_msg_count
713: , x_msg_data => x_msg_data
714: );
715: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718: END IF;
719: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
720: END LOOP;

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

735: , x_return_status => x_return_status
736: , x_msg_count => x_msg_count
737: , x_msg_data => x_msg_data
738: );
739: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742: END IF;
743: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;

Line 740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

736: , x_msg_count => x_msg_count
737: , x_msg_data => x_msg_data
738: );
739: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
740: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
741: END IF;
742: END IF;
743: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
744: END LOOP;

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

765: , x_return_status => x_return_status
766: , x_msg_count => x_msg_count
767: , x_msg_data => x_msg_data
768: );
769: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772: END IF;
773: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: , x_msg_count => x_msg_count
767: , x_msg_data => x_msg_data
768: );
769: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772: END IF;
773: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
774: END LOOP;

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

788: , x_return_status => x_return_status
789: , x_msg_count => x_msg_count
790: , x_msg_data => x_msg_data
791: );
792: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795: END IF;
796: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;

Line 793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

789: , x_msg_count => x_msg_count
790: , x_msg_data => x_msg_data
791: );
792: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
794: END IF;
795: END IF;
796: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
797: END LOOP;

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

812: , x_return_status => x_return_status
813: , x_msg_count => x_msg_count
814: , x_msg_data => x_msg_data
815: );
816: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819: END IF;
820: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;

Line 817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

813: , x_msg_count => x_msg_count
814: , x_msg_data => x_msg_data
815: );
816: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819: END IF;
820: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
821: END LOOP;

Line 829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

825: END LOOP;
826: END IF;
827:
828: EXCEPTION
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: IF (x_msg_data IS NULL) THEN
831: FND_MSG_PUB.Count_And_Get
832: ( p_encoded => FND_API.G_FALSE
833: , p_count => x_msg_count

Line 832: ( p_encoded => FND_API.G_FALSE

828: EXCEPTION
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: IF (x_msg_data IS NULL) THEN
831: FND_MSG_PUB.Count_And_Get
832: ( p_encoded => FND_API.G_FALSE
833: , p_count => x_msg_count
834: , p_data => x_msg_data
835: );
836: END IF;

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

834: , p_data => x_msg_data
835: );
836: END IF;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
839: WHEN NO_DATA_FOUND THEN
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: IF (x_msg_data IS NOT NULL) THEN
842: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_filter_views ';

Line 840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

836: END IF;
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
839: WHEN NO_DATA_FOUND THEN
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: IF (x_msg_data IS NOT NULL) THEN
842: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_filter_views ';
843: ELSE
844: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_filter_views ';

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 925: x_return_status := FND_API.G_RET_STS_SUCCESS;

921: l_found_count NUMBER;
922:
923: BEGIN
924: FND_MSG_PUB.Initialize;
925: x_return_status := FND_API.G_RET_STS_SUCCESS;
926: l_new_rel_Table := x_new_rel_Table;
927: l_prev_rel_Table := x_prev_rel_Table;
928:
929: l_New_Count := l_new_rel_Table.COUNT;

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

953: , x_return_status => x_return_status
954: , x_msg_count => x_msg_count
955: , x_msg_data => x_msg_data
956: );
957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961: ELSIF((l_new_rel_Table(i_index).p_Dim_Obj_ID<>p_dim_obj_id)

Line 958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

954: , x_msg_count => x_msg_count
955: , x_msg_data => x_msg_data
956: );
957: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
958: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
959: END IF;
960:
961: ELSIF((l_new_rel_Table(i_index).p_Dim_Obj_ID<>p_dim_obj_id)
962: AND (l_new_rel_Table(i_index).p_Parent_Dim_Id = p_dim_obj_id)) THEN

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

968: , x_return_status => x_return_status
969: , x_msg_count => x_msg_count
970: , x_msg_data => x_msg_data
971: );
972: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: END IF;
976: END IF;

Line 973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

969: , x_msg_count => x_msg_count
970: , x_msg_data => x_msg_data
971: );
972: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
974: END IF;
975: END IF;
976: END IF;
977: END LOOP;

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

998: , x_return_status => x_return_status
999: , x_msg_count => x_msg_count
1000: , x_msg_data => x_msg_data
1001: );
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: END IF;
1005:
1006: ELSIF((l_prev_rel_Table(i_index).p_Dim_Obj_ID<>p_dim_obj_id)

Line 1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

999: , x_msg_count => x_msg_count
1000: , x_msg_data => x_msg_data
1001: );
1002: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1004: END IF;
1005:
1006: ELSIF((l_prev_rel_Table(i_index).p_Dim_Obj_ID<>p_dim_obj_id)
1007: AND (l_prev_rel_Table(i_index).p_Parent_Dim_Id =p_dim_obj_id))THEN

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

1013: , x_return_status => x_return_status
1014: , x_msg_count => x_msg_count
1015: , x_msg_data => x_msg_data
1016: );
1017: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020: END IF;
1021: END IF;

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: , x_msg_count => x_msg_count
1015: , x_msg_data => x_msg_data
1016: );
1017: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: END IF;
1020: END IF;
1021: END IF;
1022: END LOOP;

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

1073: , x_return_status => x_return_status
1074: , x_msg_count => x_msg_count
1075: , x_msg_data => x_msg_data
1076: );
1077: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1079: END IF;
1080: ELSIF((l_prev_rel_Table(j).p_Refresh_Flag=TRUE) AND (l_prev_rel_Table(j).p_Refresh_No =1)) THEN
1081:

Line 1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1074: , x_msg_count => x_msg_count
1075: , x_msg_data => x_msg_data
1076: );
1077: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1079: END IF;
1080: ELSIF((l_prev_rel_Table(j).p_Refresh_Flag=TRUE) AND (l_prev_rel_Table(j).p_Refresh_No =1)) THEN
1081:
1082: BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj

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

1084: , x_return_status => x_return_status
1085: , x_msg_Count => x_msg_Count
1086: , x_msg_data => x_msg_data
1087: );
1088: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092: BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj

Line 1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1085: , x_msg_Count => x_msg_Count
1086: , x_msg_data => x_msg_data
1087: );
1088: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1090: END IF;
1091:
1092: BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj
1093: ( p_Dim_Level_Id => l_prev_rel_Table(j).p_Parent_Dim_Id

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

1094: , x_return_status => x_return_status
1095: , x_msg_Count => x_msg_Count
1096: , x_msg_data => x_msg_data
1097: );
1098: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101: END IF;
1102: END LOOP;

Line 1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1095: , x_msg_Count => x_msg_Count
1096: , x_msg_data => x_msg_data
1097: );
1098: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1100: END IF;
1101: END IF;
1102: END LOOP;
1103:

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

1120: , x_return_status => x_return_status
1121: , x_msg_count => x_msg_count
1122: , x_msg_data => x_msg_data
1123: );
1124: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: END IF;
1128: END LOOP;

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: , x_msg_count => x_msg_count
1122: , x_msg_data => x_msg_data
1123: );
1124: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: END IF;
1128: END LOOP;
1129: END IF;

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

1141: , x_return_status => x_return_status
1142: , x_msg_count => x_msg_count
1143: , x_msg_data => x_msg_data
1144: );
1145: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: EXCEPTION

Line 1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1142: , x_msg_count => x_msg_count
1143: , x_msg_data => x_msg_data
1144: );
1145: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1147: END IF;
1148:
1149: EXCEPTION
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: IF (x_msg_data IS NULL) THEN
1152: FND_MSG_PUB.Count_And_Get
1153: ( p_encoded => FND_API.G_FALSE
1154: , p_count => x_msg_count

Line 1153: ( p_encoded => FND_API.G_FALSE

1149: EXCEPTION
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: IF (x_msg_data IS NULL) THEN
1152: FND_MSG_PUB.Count_And_Get
1153: ( p_encoded => FND_API.G_FALSE
1154: , p_count => x_msg_count
1155: , p_data => x_msg_data
1156: );
1157: END IF;

Line 1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1154: , p_count => x_msg_count
1155: , p_data => x_msg_data
1156: );
1157: END IF;
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1160: WHEN NO_DATA_FOUND THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF (x_msg_data IS NOT NULL) THEN

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

1155: , p_data => x_msg_data
1156: );
1157: END IF;
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1160: WHEN NO_DATA_FOUND THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF (x_msg_data IS NOT NULL) THEN
1163: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

Line 1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1157: END IF;
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1160: WHEN NO_DATA_FOUND THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF (x_msg_data IS NOT NULL) THEN
1163: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';
1164: ELSE
1165: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

Line 1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1165: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';
1166: END IF;
1167: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1168: WHEN OTHERS THEN
1169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: IF (x_msg_data IS NOT NULL) THEN
1171: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';
1172: ELSE
1173: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

Line 1205: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

1201: END get_Next_Alias;
1202:
1203: --==============================================================
1204: PROCEDURE Assign_Dim_Obj_Rels
1205: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1206: , p_dim_obj_id IN NUMBER
1207: , p_parent_ids IN VARCHAR2
1208: , p_parent_rel_type IN VARCHAR2
1209: , p_parent_rel_column IN VARCHAR2

Line 1254: x_return_status := FND_API.G_RET_STS_SUCCESS;

1250: AND relation_type = 1;
1251: BEGIN
1252: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');
1253: FND_MSG_PUB.Initialize;
1254: x_return_status := FND_API.G_RET_STS_SUCCESS;
1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1258: FND_MSG_PUB.ADD;

Line 1259: RAISE FND_API.G_EXC_ERROR;

1255: IF (p_dim_obj_id IS NULL) THEN
1256: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1257: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1258: FND_MSG_PUB.ADD;
1259: RAISE FND_API.G_EXC_ERROR;
1260: END IF;
1261: IF (p_parent_ids IS NOT NULL) THEN
1262: l_parent_ids := p_parent_ids;
1263: l_parent_rel_type := NVL(p_parent_rel_type, 'NULL');

Line 1338: --DBMS_OUTPUT.PUT_LINE(' p_commit => FND_API.G_FALSE');

1334: END LOOP;
1335:
1336: --DBMS_OUTPUT.PUT_LINE(' BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
1337: --DBMS_OUTPUT.PUT_LINE(' (');
1338: --DBMS_OUTPUT.PUT_LINE(' p_commit => FND_API.G_FALSE');
1339: --DBMS_OUTPUT.PUT_LINE(' , p_dim_obj_id => '||p_dim_obj_id);
1340: --DBMS_OUTPUT.PUT_LINE(' , p_parent_ids => '''||l_parent_ids||''' ');
1341: --DBMS_OUTPUT.PUT_LINE(' , p_parent_rel_type => '''||l_parent_rel_type||'''');
1342: --DBMS_OUTPUT.PUT_LINE(' , p_parent_rel_column => '''||l_parent_rel_column||'''');

Line 1355: ( p_commit => FND_API.G_FALSE

1351: --DBMS_OUTPUT.PUT_LINE(' , x_msg_count => l_msg_count');
1352: --DBMS_OUTPUT.PUT_LINE(' , x_msg_data => l_msg_data');
1353: --DBMS_OUTPUT.PUT_LINE(' );');
1354: BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels
1355: ( p_commit => FND_API.G_FALSE
1356: , p_dim_obj_id => p_dim_obj_id
1357: , p_parent_ids => l_parent_ids
1358: , p_parent_rel_type => l_parent_rel_type
1359: , p_parent_rel_column => l_parent_rel_column

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

1368: , x_return_status => x_return_status
1369: , x_msg_count => x_msg_count
1370: , x_msg_data => x_msg_data
1371: );
1372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1373: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1375: END IF;
1376: IF (p_commit = FND_API.G_TRUE) THEN

Line 1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1370: , x_msg_data => x_msg_data
1371: );
1372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1373: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1375: END IF;
1376: IF (p_commit = FND_API.G_TRUE) THEN
1377: COMMIT;
1378: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');

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

1372: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1373: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
1374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1375: END IF;
1376: IF (p_commit = FND_API.G_TRUE) THEN
1377: COMMIT;
1378: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');
1379: END IF;
1380: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');

Line 1382: WHEN FND_API.G_EXC_ERROR THEN

1378: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');
1379: END IF;
1380: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');
1381: EXCEPTION
1382: WHEN FND_API.G_EXC_ERROR THEN
1383: IF (x_msg_data IS NULL) THEN
1384: FND_MSG_PUB.Count_And_Get
1385: ( p_encoded => FND_API.G_FALSE
1386: , p_count => x_msg_count

Line 1385: ( p_encoded => FND_API.G_FALSE

1381: EXCEPTION
1382: WHEN FND_API.G_EXC_ERROR THEN
1383: IF (x_msg_data IS NULL) THEN
1384: FND_MSG_PUB.Count_And_Get
1385: ( p_encoded => FND_API.G_FALSE
1386: , p_count => x_msg_count
1387: , p_data => x_msg_data
1388: );
1389: END IF;

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

1386: , p_count => x_msg_count
1387: , p_data => x_msg_data
1388: );
1389: END IF;
1390: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: IF (x_msg_data IS NULL) THEN
1394: FND_MSG_PUB.Count_And_Get

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387: , p_data => x_msg_data
1388: );
1389: END IF;
1390: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: IF (x_msg_data IS NULL) THEN
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_encoded => FND_API.G_FALSE

Line 1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1388: );
1389: END IF;
1390: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: IF (x_msg_data IS NULL) THEN
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_encoded => FND_API.G_FALSE
1396: , p_count => x_msg_count

Line 1395: ( p_encoded => FND_API.G_FALSE

1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1393: IF (x_msg_data IS NULL) THEN
1394: FND_MSG_PUB.Count_And_Get
1395: ( p_encoded => FND_API.G_FALSE
1396: , p_count => x_msg_count
1397: , p_data => x_msg_data
1398: );
1399: END IF;

Line 1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1396: , p_count => x_msg_count
1397: , p_data => x_msg_data
1398: );
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1402: WHEN NO_DATA_FOUND THEN
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: IF (x_msg_data IS NOT NULL) THEN

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

1397: , p_data => x_msg_data
1398: );
1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1402: WHEN NO_DATA_FOUND THEN
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: IF (x_msg_data IS NOT NULL) THEN
1405: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1399: END IF;
1400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1401: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1402: WHEN NO_DATA_FOUND THEN
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404: IF (x_msg_data IS NOT NULL) THEN
1405: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';
1406: ELSE
1407: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

Line 1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1407: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';
1408: END IF;
1409: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1410: WHEN OTHERS THEN
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: IF (x_msg_data IS NOT NULL) THEN
1413: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';
1414: ELSE
1415: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

Line 1435: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

1431: 2. Circularity check must be there.
1432: 3. p_dim_obj_id must not be null.
1433: */
1434: PROCEDURE Assign_New_Dim_Obj_Rels
1435: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
1436: , p_dim_obj_id IN NUMBER
1437: , p_parent_ids IN VARCHAR2
1438: , p_parent_rel_type IN VARCHAR2
1439: , p_parent_rel_column IN VARCHAR2

Line 1553: x_return_status := FND_API.G_RET_STS_SUCCESS;

1549:
1550: BEGIN
1551: SAVEPOINT AssUnassBSCRelsPMD;
1552: FND_MSG_PUB.Initialize;
1553: x_return_status := FND_API.G_RET_STS_SUCCESS;
1554: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');
1555: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||p_dim_obj_id);
1556: --DBMS_OUTPUT.PUT_LINE('p_parent_ids '||p_parent_ids);
1557: --DBMS_OUTPUT.PUT_LINE('p_parent_rel_type '||p_parent_rel_type);

Line 1570: RAISE FND_API.G_EXC_ERROR;

1566: IF (p_dim_obj_id IS NULL) THEN
1567: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1568: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: SELECT COUNT(*) INTO l_count
1573: FROM BSC_SYS_DIM_LEVELS_B
1574: WHERE dim_level_id = p_dim_obj_id;

Line 1580: RAISE FND_API.G_EXC_ERROR;

1576: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
1577: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
1578: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_ERROR;
1581: END IF;
1582:
1583: -- Restrict Period Dim Object from relationship.
1584: IF (p_parent_ids IS NOT NULL) THEN

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

1599: , x_Return_Status => x_return_status
1600: , x_Msg_Count => x_msg_count
1601: , x_Msg_Data => x_msg_data
1602: );
1603: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1605: END IF;
1606: END LOOP;
1607: END IF;

Line 1604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1600: , x_Msg_Count => x_msg_count
1601: , x_Msg_Data => x_msg_data
1602: );
1603: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1605: END IF;
1606: END LOOP;
1607: END IF;
1608: IF (p_child_ids IS NOT NULL) THEN

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

1623: , x_Return_Status => x_return_status
1624: , x_Msg_Count => x_msg_count
1625: , x_Msg_Data => x_msg_data
1626: );
1627: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1629: END IF;
1630: END LOOP;
1631: END IF;

Line 1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1624: , x_Msg_Count => x_msg_count
1625: , x_Msg_Data => x_msg_data
1626: );
1627: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1629: END IF;
1630: END LOOP;
1631: END IF;
1632:

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

1669: , x_return_status => x_return_status
1670: , x_msg_count => x_msg_count
1671: , x_msg_data => x_msg_data
1672: );
1673: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676: END IF;
1677:

Line 1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1670: , x_msg_count => x_msg_count
1671: , x_msg_data => x_msg_data
1672: );
1673: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676: END IF;
1677:
1678: -- END: Granular Locking

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

1687: , x_return_status => x_return_status
1688: , x_msg_count => x_msg_count
1689: , x_msg_data => x_msg_data
1690: );
1691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1692: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.get_Original_Relations Failed: at BSC_BIS_DIM_REL_PUB.get_Original_Relations <'||x_msg_data||'>');
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695:

Line 1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1689: , x_msg_data => x_msg_data
1690: );
1691: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1692: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.get_Original_Relations Failed: at BSC_BIS_DIM_REL_PUB.get_Original_Relations <'||x_msg_data||'>');
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694: END IF;
1695:
1696: -- Added for Bug#5300060
1697: l_original_child_ids := Get_Original_Child_Ids(p_dim_obj_id);

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

1707: , x_return_status => x_return_status
1708: , x_msg_count => x_msg_count
1709: , x_msg_data => x_msg_data
1710: );
1711: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1712: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.store_Prev_Relations <'||x_msg_data||'>');
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: END IF;
1715: END IF;

Line 1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1709: , x_msg_data => x_msg_data
1710: );
1711: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1712: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.store_Prev_Relations <'||x_msg_data||'>');
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: END IF;
1715: END IF;
1716:
1717: --DBMS_OUTPUT.PUT_LINE('AFTER BSC_BIS_DIM_REL_PUB.get_Original_Relations');

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

1754: , x_return_status => x_return_status
1755: , x_msg_count => x_msg_count
1756: , x_msg_data => x_msg_data
1757: );
1758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761: END LOOP;
1762: l_dim_obj_id := p_dim_obj_id;

Line 1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1755: , x_msg_count => x_msg_count
1756: , x_msg_data => x_msg_data
1757: );
1758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761: END LOOP;
1762: l_dim_obj_id := p_dim_obj_id;
1763: FOR pd IN c_par_dim_ids LOOP

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

1768: , x_return_status => x_return_status
1769: , x_msg_count => x_msg_count
1770: , x_msg_data => x_msg_data
1771: );
1772: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1774: END IF;
1775: END LOOP;
1776: END IF;

Line 1773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1769: , x_msg_count => x_msg_count
1770: , x_msg_data => x_msg_data
1771: );
1772: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1774: END IF;
1775: END LOOP;
1776: END IF;
1777: END IF;

Line 1821: RAISE FND_API.G_EXC_ERROR;

1817: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELS_SOURCE');
1818: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1819: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1820: FND_MSG_PUB.ADD;
1821: RAISE FND_API.G_EXC_ERROR;
1822: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1823: END IF;
1824: --DBMS_OUTPUT.PUT_LINE('l_bsc_dim_obj_rec.bsc_level_id <'||l_bsc_dim_obj_rec.bsc_level_id);
1825: --DBMS_OUTPUT.PUT_LINE('l_bsc_dim_obj_rec.bsc_parent_level_id <'||l_bsc_dim_obj_rec.bsc_parent_level_id);

Line 1851: RAISE FND_API.G_EXC_ERROR;

1847: (l_bsc_dim_obj_rec.Bsc_Level_Id = l_bsc_dim_obj_rec.bsc_parent_level_id)) THEN
1848: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1849: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1850: FND_MSG_PUB.ADD;
1851: RAISE FND_API.G_EXC_ERROR;
1852: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1853: END IF;
1854: SELECT COUNT(*) INTO l_count
1855: FROM BSC_SYS_DIM_LEVEL_RELS

Line 1862: ( p_commit => FND_API.G_FALSE

1858: IF (l_count = 0) THEN
1859: IF (l_bsc_dim_obj_rec.bsc_relation_type = 1) THEN
1860: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_DIM_REL_PUB.Is_Valid_Relationship');
1861: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship
1862: ( p_commit => FND_API.G_FALSE
1863: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1864: , x_return_status => x_return_status
1865: , x_msg_count => x_msg_count
1866: , x_msg_data => x_msg_data

Line 1871: RAISE FND_API.G_EXC_ERROR;

1867: );
1868: IF (NOT l_flag) THEN
1869: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship.');
1870: --DBMS_OUTPUT.PUT_LINE(SUBSTR(x_msg_data, 1, 200));
1871: RAISE FND_API.G_EXC_ERROR;
1872: --DBMS_OUTPUT.PUT_LINE('ERROR FOR DELETE QUERY');
1873: END IF;
1874: ELSE
1875: SELECT COUNT(*) INTO l_count

Line 1882: RAISE FND_API.G_EXC_ERROR;

1878: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
1879: IF (l_count <> 0) THEN
1880: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
1881: FND_MSG_PUB.ADD;
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884: END IF;
1885: --DBMS_OUTPUT.PUT_LINE('reached I 6');
1886: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');

Line 1888: ( p_commit => FND_API.G_FALSE

1884: END IF;
1885: --DBMS_OUTPUT.PUT_LINE('reached I 6');
1886: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');
1887: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation
1888: ( p_commit => FND_API.G_FALSE
1889: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
1890: , x_return_status => x_return_status
1891: , x_msg_count => x_msg_count
1892: , x_msg_data => x_msg_data

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

1891: , x_msg_count => x_msg_count
1892: , x_msg_data => x_msg_data
1893: );
1894: --DBMS_OUTPUT.PUT_LINE('reached I 7');
1895: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1896: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899: -- START Granluar Locking

Line 1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1893: );
1894: --DBMS_OUTPUT.PUT_LINE('reached I 7');
1895: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1896: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899: -- START Granluar Locking
1900: -- Change the time stamp of the Child Dimension Level
1901: IF(p_is_not_config) THEN

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

1904: , x_return_status => x_return_status
1905: , x_msg_count => x_msg_count
1906: , x_msg_data => x_msg_data
1907: );
1908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1909: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912: END IF;

Line 1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1906: , x_msg_data => x_msg_data
1907: );
1908: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1909: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
1910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1911: END IF;
1912: END IF;
1913: -- END Granluar Locking
1914: ELSE

Line 1917: RAISE FND_API.G_EXC_ERROR;

1913: -- END Granluar Locking
1914: ELSE
1915: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
1916: FND_MSG_PUB.ADD;
1917: RAISE FND_API.G_EXC_ERROR;
1918: END IF;
1919: END LOOP;
1920: --DBMS_OUTPUT.PUT_LINE('reached I 9');
1921: END IF;

Line 1969: RAISE FND_API.G_EXC_ERROR;

1965: FND_MESSAGE.SET_TOKEN('DIM_OBJ1', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1966: FND_MESSAGE.SET_TOKEN('DIM_OBJ2', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.bsc_parent_level_id));
1967: FND_MSG_PUB.ADD;
1968: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
1969: RAISE FND_API.G_EXC_ERROR;
1970:
1971: END IF;
1972: IF (l_bsc_dim_obj_rec.Bsc_Source = 'PMF') THEN
1973: IF((l_bsc_dim_obj_rec.Bsc_Data_Source_Type IS NULL) OR

Line 2000: RAISE FND_API.G_EXC_ERROR;

1996: (l_bsc_dim_obj_rec.Bsc_Level_Id = l_bsc_dim_obj_rec.bsc_parent_level_id)) THEN
1997: FND_MESSAGE.SET_NAME('BSC','BSC_SAME_DIM_LEVEL_REL');
1998: FND_MESSAGE.SET_TOKEN('LEVEL_CHILD', BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Name(l_bsc_dim_obj_rec.Bsc_Level_Id));
1999: FND_MSG_PUB.ADD;
2000: RAISE FND_API.G_EXC_ERROR;
2001: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
2002: END IF;
2003:
2004: -- Get the Dimension Object Relationship for Bug #3395161

Line 2024: ( p_commit => FND_API.G_FALSE

2020: IF (l_count = 0) THEN
2021: IF (l_bsc_dim_obj_rec.bsc_relation_type = 1) THEN
2022: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');
2023: l_flag := BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship
2024: ( p_commit => FND_API.G_FALSE
2025: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2026: , x_return_status => x_return_status
2027: , x_msg_count => x_msg_count
2028: , x_msg_data => x_msg_data

Line 2032: RAISE FND_API.G_EXC_ERROR;

2028: , x_msg_data => x_msg_data
2029: );
2030: IF (NOT l_flag) THEN
2031: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');
2032: RAISE FND_API.G_EXC_ERROR;
2033: --DBMS_OUTPUT.PUT_LINE('PARENT IDS EXE ERROR');
2034: END IF;
2035: ELSE
2036: SELECT COUNT(*) INTO l_count

Line 2043: RAISE FND_API.G_EXC_ERROR;

2039: AND parent_dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id;
2040: IF (l_count <> 0) THEN
2041: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
2042: FND_MSG_PUB.ADD;
2043: RAISE FND_API.G_EXC_ERROR;
2044: END IF;
2045: END IF;
2046:
2047: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');

Line 2049: ( p_commit => FND_API.G_FALSE

2045: END IF;
2046:
2047: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation');
2048: BSC_DIMENSION_LEVELS_PUB.Create_Dim_Level_Relation
2049: ( p_commit => FND_API.G_FALSE
2050: , p_Dim_Level_Rec => l_bsc_dim_obj_rec
2051: , x_return_status => x_return_status
2052: , x_msg_count => x_msg_count
2053: , x_msg_data => x_msg_data

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

2051: , x_return_status => x_return_status
2052: , x_msg_count => x_msg_count
2053: , x_msg_data => x_msg_data
2054: );
2055: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2056: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2058: END IF;
2059:

Line 2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2053: , x_msg_data => x_msg_data
2054: );
2055: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2056: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
2057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2058: END IF;
2059:
2060: -- START Granluar Locking
2061: -- Change the time stamp of the Parent Dimension Level

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

2065: , x_return_status => x_return_status
2066: , x_msg_count => x_msg_count
2067: , x_msg_data => x_msg_data
2068: );
2069: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2070: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: END IF;

Line 2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2067: , x_msg_data => x_msg_data
2068: );
2069: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2070: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.create_dim_level_relation');
2071: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2072: END IF;
2073: END IF;
2074: --DBMS_OUTPUT.PUT_LINE('PARENT IDS STAGE4');
2075: -- END Granluar Locking

Line 2088: RAISE FND_API.G_EXC_ERROR;

2084:
2085: IF (NOT ((l_db_child_rel_type = 2) AND (l_bsc_dim_obj_rec.bsc_relation_type = 2)) AND l_Is_PMF_Recur_Type = FALSE)THEN
2086: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_RELATIONSHIPS');
2087: FND_MSG_PUB.ADD;
2088: RAISE FND_API.G_EXC_ERROR;
2089: END IF;
2090: END IF;
2091: END LOOP;
2092: END IF;

Line 2220: ( p_commit => FND_API.G_FALSE

2216: FOR cd IN c_kpi_dim_set LOOP
2217: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');
2218: IF(NOT (l_source = 'PMF' AND cd.short_name IS NULL)) THEN
2219: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
2220: ( p_commit => FND_API.G_FALSE
2221: , p_kpi_id => cd.Indicator
2222: , p_dim_set_id => cd.Dim_Set_Id
2223: , p_delete => TRUE -- delete before creating in cascading
2224: , x_return_status => x_return_status

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

2225: , x_msg_count => x_msg_count
2226: , x_msg_data => x_msg_data
2227: );
2228: END IF;
2229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2230: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: END IF;
2233: END LOOP;

Line 2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2227: );
2228: END IF;
2229: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2230: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet');
2231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2232: END IF;
2233: END LOOP;
2234: --DBMS_OUTPUT.PUT_LINE('Cascading changes to KPIs Part Ends Here');
2235: /********************************************************

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

2242: , x_return_status => x_return_status
2243: , x_msg_count => x_msg_count
2244: , x_msg_data => x_msg_data
2245: );
2246: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2247: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_OBJ_PUB.check_indp_dimobjs Failed: at BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level <'||x_msg_data||'>');
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: , x_msg_data => x_msg_data
2245: );
2246: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2247: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_OBJ_PUB.check_indp_dimobjs Failed: at BSC_DIMENSION_LEVELS_PUB.Update_Dim_Level <'||x_msg_data||'>');
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: /*************************************************************
2252: List Button validation.For a list button all the dimension objects

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

2259: , x_return_status => x_return_status
2260: , x_msg_count => x_msg_count
2261: , x_msg_data => x_msg_data
2262: );
2263: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2264: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button');
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2266: END IF;
2267: END IF;

Line 2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2261: , x_msg_data => x_msg_data
2262: );
2263: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2264: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button');
2265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2266: END IF;
2267: END IF;
2268: --DBMS_OUTPUT.PUT_LINE(' --- FINAL TABLE ----');
2269: --DBMS_OUTPUT.PUT_LINE('PRINT OUT OF THE TABLES THAT WE HAVE GOT 1 x N RELATIONS');

Line 2298: RAISE FND_API.G_EXC_ERROR;

2294: AND A.Relation_Type = 1;
2295: IF (l_Count > MAX_PARENTS_RELS_1_N) THEN
2296: FND_MESSAGE.SET_NAME('BSC','BSC_MAX_DIM_OBJ_RELS');
2297: FND_MSG_PUB.ADD;
2298: RAISE FND_API.G_EXC_ERROR;
2299: END IF;
2300: END IF;
2301: END LOOP;
2302: --DBMS_OUTPUT.PUT_LINE('REFRESHING MASTER TABLES PART STARTS HERE');

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: , x_msg_data => x_msg_data
2313: );
2314: IF(NOT l_flag) THEN
2315: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable <'||x_msg_data||'>');
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: END IF;
2319: END LOOP;
2320: --DBMS_OUTPUT.PUT_LINE('--- ******** FOR M x N RELATIONS ******** -----');

Line 2335: RAISE FND_API.G_EXC_ERROR;

2331: , x_msg_data => x_msg_data
2332: );
2333: IF (NOT l_flag) THEN
2334: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable <'||x_msg_data||'>');
2335: RAISE FND_API.G_EXC_ERROR;
2336: END IF;
2337: END IF;
2338: END LOOP;
2339: --DBMS_OUTPUT.PUT_LINE('REFRESHING MASTER TABLES PART ENDS HERE');

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

2346: , x_return_status => x_return_status
2347: , x_msg_count => x_msg_count
2348: , x_msg_data => x_msg_data
2349: );
2350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2351: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.store_Prev_Relations <'||x_msg_data||'>');
2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2353: END IF;
2354:

Line 2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2348: , x_msg_data => x_msg_data
2349: );
2350: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2351: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.store_Prev_Relations <'||x_msg_data||'>');
2352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2353: END IF;
2354:
2355: BSC_BIS_DIM_REL_PUB.Validate_Filter_Button
2356: (

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

2361: , x_msg_count => x_msg_count
2362: , x_msg_data => x_msg_data
2363:
2364: );
2365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2366: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.store_Prev_Relations <'||x_msg_data||'>');
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369: END IF;

Line 2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2363:
2364: );
2365: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2366: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.store_Prev_Relations <'||x_msg_data||'>');
2367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2368: END IF;
2369: END IF;
2370:
2371: -- To delete denormailized table which is created from recursive relationship

Line 2380: IF(BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_TRUE) THEN

2376: the PL/SQL procedure "BSC_PMA_APIS_PUB.sync_dimension_table" dynamic so that
2377: the package gets complied on the pure BIS409 enviornments.
2378: /****************************************************/
2379:
2380: IF(BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_TRUE) THEN
2381: l_is_denorm_deleted := FND_API.G_TRUE;
2382:
2383: SELECT short_name
2384: INTO l_dim_short_name

Line 2381: l_is_denorm_deleted := FND_API.G_TRUE;

2377: the package gets complied on the pure BIS409 enviornments.
2378: /****************************************************/
2379:
2380: IF(BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_TRUE) THEN
2381: l_is_denorm_deleted := FND_API.G_TRUE;
2382:
2383: SELECT short_name
2384: INTO l_dim_short_name
2385: FROM bsc_sys_dim_levels_b

Line 2389: l_Sql := 'BEGIN IF(BSC_PMA_APIS_PUB.sync_dimension_table (:2,:3,:4)) THEN :1 :=FND_API.G_TRUE; ELSE :1:=FND_API.G_FALSE; END IF;END;';

2385: FROM bsc_sys_dim_levels_b
2386: WHERE dim_level_id = p_dim_obj_id;
2387:
2388: BEGIN
2389: l_Sql := 'BEGIN IF(BSC_PMA_APIS_PUB.sync_dimension_table (:2,:3,:4)) THEN :1 :=FND_API.G_TRUE; ELSE :1:=FND_API.G_FALSE; END IF;END;';
2390: EXECUTE IMMEDIATE l_Sql USING IN l_dim_short_name,IN BIS_UTIL.G_ALTER_TABLE,OUT x_msg_data,OUT l_is_denorm_deleted;
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: NULL;

Line 2396: IF(l_is_denorm_deleted=FND_API.G_FALSE) THEN

2392: WHEN OTHERS THEN
2393: NULL;
2394: END;
2395:
2396: IF(l_is_denorm_deleted=FND_API.G_FALSE) THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;
2399: END IF;
2400:

Line 2397: RAISE FND_API.G_EXC_ERROR;

2393: NULL;
2394: END;
2395:
2396: IF(l_is_denorm_deleted=FND_API.G_FALSE) THEN
2397: RAISE FND_API.G_EXC_ERROR;
2398: END IF;
2399: END IF;
2400:
2401: -- Added for Bug#4758995

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

2411: , x_return_status => x_return_status
2412: , x_msg_count => x_msg_count
2413: , x_msg_data => x_msg_data
2414: );
2415: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2417: END IF;
2418:
2419: -- now, refresh all the child dimension object views as well - Bug#5300060

Line 2416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2412: , x_msg_count => x_msg_count
2413: , x_msg_data => x_msg_data
2414: );
2415: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2417: END IF;
2418:
2419: -- now, refresh all the child dimension object views as well - Bug#5300060
2420: -- Create an unique list child IDs ,which has been removed from the relationship, which exist in

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

2436: , x_return_status => x_return_status
2437: , x_msg_count => x_msg_count
2438: , x_msg_data => x_msg_data
2439: );
2440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: END IF;
2443: END LOOP;
2444: END IF;

Line 2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2437: , x_msg_count => x_msg_count
2438: , x_msg_data => x_msg_data
2439: );
2440: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2442: END IF;
2443: END LOOP;
2444: END IF;
2445: END IF;

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

2452: , x_return_status => x_return_status
2453: , x_msg_count => x_msg_count
2454: , x_msg_data => x_msg_data
2455: );
2456: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF;
2459: IF (p_commit = FND_API.G_TRUE) THEN
2460: COMMIT;

Line 2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2453: , x_msg_count => x_msg_count
2454: , x_msg_data => x_msg_data
2455: );
2456: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF;
2459: IF (p_commit = FND_API.G_TRUE) THEN
2460: COMMIT;
2461: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');

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

2455: );
2456: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2457: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2458: END IF;
2459: IF (p_commit = FND_API.G_TRUE) THEN
2460: COMMIT;
2461: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');
2462: END IF;
2463: END IF;

Line 2467: x_return_status := FND_API.G_RET_STS_SUCCESS;

2463: END IF;
2464:
2465: -- END Granluar Locking
2466:
2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');
2469: EXCEPTION
2470: WHEN FND_API.G_EXC_ERROR THEN
2471: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 2470: WHEN FND_API.G_EXC_ERROR THEN

2466:
2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');
2469: EXCEPTION
2470: WHEN FND_API.G_EXC_ERROR THEN
2471: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2472: IF (c_db_child_type%ISOPEN) THEN
2473: CLOSE c_db_child_type;
2474: END IF;

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

2467: x_return_status := FND_API.G_RET_STS_SUCCESS;
2468: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');
2469: EXCEPTION
2470: WHEN FND_API.G_EXC_ERROR THEN
2471: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2472: IF (c_db_child_type%ISOPEN) THEN
2473: CLOSE c_db_child_type;
2474: END IF;
2475: ROLLBACK TO AssUnassBSCRelsPMD;

Line 2478: ( p_encoded => FND_API.G_FALSE

2474: END IF;
2475: ROLLBACK TO AssUnassBSCRelsPMD;
2476: IF (x_msg_data IS NULL) THEN
2477: FND_MSG_PUB.Count_And_Get
2478: ( p_encoded => FND_API.G_FALSE
2479: , p_count => x_msg_count
2480: , p_data => x_msg_data
2481: );
2482: END IF;

Line 2483: x_return_status := FND_API.G_RET_STS_ERROR;

2479: , p_count => x_msg_count
2480: , p_data => x_msg_data
2481: );
2482: END IF;
2483: x_return_status := FND_API.G_RET_STS_ERROR;
2484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2485: IF (c_db_child_type%ISOPEN) THEN
2486: CLOSE c_db_child_type;
2487: END IF;

Line 2484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2480: , p_data => x_msg_data
2481: );
2482: END IF;
2483: x_return_status := FND_API.G_RET_STS_ERROR;
2484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2485: IF (c_db_child_type%ISOPEN) THEN
2486: CLOSE c_db_child_type;
2487: END IF;
2488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

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

2484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2485: IF (c_db_child_type%ISOPEN) THEN
2486: CLOSE c_db_child_type;
2487: END IF;
2488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2489: ROLLBACK TO AssUnassBSCRelsPMD;
2490: IF (x_msg_data IS NULL) THEN
2491: FND_MSG_PUB.Count_And_Get
2492: ( p_encoded => FND_API.G_FALSE

Line 2492: ( p_encoded => FND_API.G_FALSE

2488: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2489: ROLLBACK TO AssUnassBSCRelsPMD;
2490: IF (x_msg_data IS NULL) THEN
2491: FND_MSG_PUB.Count_And_Get
2492: ( p_encoded => FND_API.G_FALSE
2493: , p_count => x_msg_count
2494: , p_data => x_msg_data
2495: );
2496: END IF;

Line 2497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2493: , p_count => x_msg_count
2494: , p_data => x_msg_data
2495: );
2496: END IF;
2497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2498: WHEN NO_DATA_FOUND THEN
2499: IF (c_db_child_type%ISOPEN) THEN
2500: CLOSE c_db_child_type;
2501: END IF;

Line 2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2500: CLOSE c_db_child_type;
2501: END IF;
2502: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2503: ROLLBACK TO AssUnassBSCRelsPMD;
2504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2505: IF (x_msg_data IS NOT NULL) THEN
2506: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';
2507: ELSE
2508: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';

Line 2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2512: CLOSE c_db_child_type;
2513: END IF;
2514: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2515: ROLLBACK TO AssUnassBSCRelsPMD;
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517: IF (x_msg_data IS NOT NULL) THEN
2518: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';
2519: ELSE
2520: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';

Line 2527: ( p_commit IN VARCHAR2 := FND_API.G_TRUE

2523: /*********************************************************************************
2524: UNASSIGN DIMENSION-OBJECTS RELATIONSHIPS
2525: *********************************************************************************/
2526: PROCEDURE UnAssign_Dim_Obj_Rels
2527: ( p_commit IN VARCHAR2 := FND_API.G_TRUE
2528: , p_dim_obj_id IN NUMBER
2529: , p_parent_ids IN VARCHAR2
2530: , p_child_ids IN VARCHAR2
2531: , p_time_stamp IN VARCHAR2 := NULL -- Granular Locking

Line 2572: x_return_status := FND_API.G_RET_STS_SUCCESS;

2568: AND relation_type = 1;
2569: BEGIN
2570: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');
2571: FND_MSG_PUB.Initialize;
2572: x_return_status := FND_API.G_RET_STS_SUCCESS;
2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2576: FND_MSG_PUB.ADD;

Line 2577: RAISE FND_API.G_EXC_ERROR;

2573: IF (p_dim_obj_id IS NULL) THEN
2574: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2575: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2576: FND_MSG_PUB.ADD;
2577: RAISE FND_API.G_EXC_ERROR;
2578: END IF;
2579: FOR cd IN c_parent_ids LOOP
2580: l_dim_obj_ids := p_parent_ids;
2581: l_flag := TRUE;

Line 2662: ( p_commit => FND_API.G_FALSE

2658: END IF;
2659: END IF;
2660: END LOOP;
2661: BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels
2662: ( p_commit => FND_API.G_FALSE
2663: , p_dim_obj_id => p_dim_obj_id
2664: , p_parent_ids => l_parent_ids
2665: , p_parent_rel_type => l_parent_rel_type
2666: , p_parent_rel_column => l_parent_rel_column

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

2675: , x_return_status => x_return_status
2676: , x_msg_count => x_msg_count
2677: , x_msg_data => x_msg_data
2678: );
2679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2680: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2682: END IF;
2683: IF (p_commit = FND_API.G_TRUE) THEN

Line 2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2677: , x_msg_data => x_msg_data
2678: );
2679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2680: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2682: END IF;
2683: IF (p_commit = FND_API.G_TRUE) THEN
2684: COMMIT;
2685: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');

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

2679: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2680: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Failed: at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');
2681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2682: END IF;
2683: IF (p_commit = FND_API.G_TRUE) THEN
2684: COMMIT;
2685: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');
2686: END IF;
2687: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');

Line 2689: WHEN FND_API.G_EXC_ERROR THEN

2685: --DBMS_OUTPUT.PUT_LINE('COMMIT SUCCESSFUL');
2686: END IF;
2687: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');
2688: EXCEPTION
2689: WHEN FND_API.G_EXC_ERROR THEN
2690: IF (x_msg_data IS NULL) THEN
2691: FND_MSG_PUB.Count_And_Get
2692: ( p_encoded => FND_API.G_FALSE
2693: , p_count => x_msg_count

Line 2692: ( p_encoded => FND_API.G_FALSE

2688: EXCEPTION
2689: WHEN FND_API.G_EXC_ERROR THEN
2690: IF (x_msg_data IS NULL) THEN
2691: FND_MSG_PUB.Count_And_Get
2692: ( p_encoded => FND_API.G_FALSE
2693: , p_count => x_msg_count
2694: , p_data => x_msg_data
2695: );
2696: END IF;

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

2693: , p_count => x_msg_count
2694: , p_data => x_msg_data
2695: );
2696: END IF;
2697: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2700: IF (x_msg_data IS NULL) THEN
2701: FND_MSG_PUB.Count_And_Get

Line 2698: x_return_status := FND_API.G_RET_STS_ERROR;

2694: , p_data => x_msg_data
2695: );
2696: END IF;
2697: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2700: IF (x_msg_data IS NULL) THEN
2701: FND_MSG_PUB.Count_And_Get
2702: ( p_encoded => FND_API.G_FALSE

Line 2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2695: );
2696: END IF;
2697: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2700: IF (x_msg_data IS NULL) THEN
2701: FND_MSG_PUB.Count_And_Get
2702: ( p_encoded => FND_API.G_FALSE
2703: , p_count => x_msg_count

Line 2702: ( p_encoded => FND_API.G_FALSE

2698: x_return_status := FND_API.G_RET_STS_ERROR;
2699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2700: IF (x_msg_data IS NULL) THEN
2701: FND_MSG_PUB.Count_And_Get
2702: ( p_encoded => FND_API.G_FALSE
2703: , p_count => x_msg_count
2704: , p_data => x_msg_data
2705: );
2706: END IF;

Line 2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2703: , p_count => x_msg_count
2704: , p_data => x_msg_data
2705: );
2706: END IF;
2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2708: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2709: WHEN NO_DATA_FOUND THEN
2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2711: IF (x_msg_data IS NOT NULL) THEN

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

2704: , p_data => x_msg_data
2705: );
2706: END IF;
2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2708: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2709: WHEN NO_DATA_FOUND THEN
2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2711: IF (x_msg_data IS NOT NULL) THEN
2712: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

Line 2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2706: END IF;
2707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2708: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
2709: WHEN NO_DATA_FOUND THEN
2710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2711: IF (x_msg_data IS NOT NULL) THEN
2712: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';
2713: ELSE
2714: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

Line 2718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2714: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';
2715: END IF;
2716: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2717: WHEN OTHERS THEN
2718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2719: IF (x_msg_data IS NOT NULL) THEN
2720: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';
2721: ELSE
2722: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

Line 2968: x_return_status := FND_API.G_RET_STS_SUCCESS;

2964: AND A.Relation_Type = 1;
2965: BEGIN
2966: SAVEPOINT CreateBSC1toNTabsPMD;
2967: FND_MSG_PUB.Initialize;
2968: x_return_status := FND_API.G_RET_STS_SUCCESS;
2969: BSC_APPS.Init_Bsc_Apps;
2970: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');

Line 2975: RAISE FND_API.G_EXC_ERROR;

2971: IF (p_dim_obj_id IS NULL) THEN
2972: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2973: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2974: FND_MSG_PUB.ADD;
2975: RAISE FND_API.G_EXC_ERROR;
2976: END IF;
2977: IF (p_dim_obj_id IS NOT NULL) THEN
2978: -- Bug #3236356
2979: SELECT COUNT(0) INTO l_count

Line 2988: RAISE FND_API.G_EXC_ERROR;

2984: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
2985: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
2986: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
2987: FND_MSG_PUB.ADD;
2988: RAISE FND_API.G_EXC_ERROR;
2989: END IF;
2990: END IF;
2991: --DBMS_OUTPUT.PUT_LINE('2 ');
2992: SELECT level_table_name

Line 3230: x_return_status := FND_API.G_RET_STS_SUCCESS;

3226: RAISE e_mlog_exception;
3227: END IF;
3228:
3229: COMMIT;
3230: x_return_status := FND_API.G_RET_STS_SUCCESS;
3231: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Create_One_To_N_MTable Function');
3232: RETURN TRUE;
3233: EXCEPTION
3234: WHEN e_mlog_exception THEN

Line 3238: x_return_status := FND_API.G_RET_STS_ERROR;

3234: WHEN e_mlog_exception THEN
3235: ROLLBACK TO CreateBSC1toNTabsPMD;
3236: x_msg_data := NULL;
3237: x_msg_data := l_error_msg || ' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable';
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: RETURN FALSE;
3240: WHEN FND_API.G_EXC_ERROR THEN
3241: ROLLBACK TO CreateBSC1toNTabsPMD;
3242: IF (x_msg_data IS NULL) THEN

Line 3240: WHEN FND_API.G_EXC_ERROR THEN

3236: x_msg_data := NULL;
3237: x_msg_data := l_error_msg || ' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable';
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: RETURN FALSE;
3240: WHEN FND_API.G_EXC_ERROR THEN
3241: ROLLBACK TO CreateBSC1toNTabsPMD;
3242: IF (x_msg_data IS NULL) THEN
3243: FND_MSG_PUB.Count_And_Get
3244: ( p_encoded => FND_API.G_FALSE

Line 3244: ( p_encoded => FND_API.G_FALSE

3240: WHEN FND_API.G_EXC_ERROR THEN
3241: ROLLBACK TO CreateBSC1toNTabsPMD;
3242: IF (x_msg_data IS NULL) THEN
3243: FND_MSG_PUB.Count_And_Get
3244: ( p_encoded => FND_API.G_FALSE
3245: , p_count => x_msg_count
3246: , p_data => x_msg_data
3247: );
3248: END IF;

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

3245: , p_count => x_msg_count
3246: , p_data => x_msg_data
3247: );
3248: END IF;
3249: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3250: x_return_status := FND_API.G_RET_STS_ERROR;
3251: RETURN FALSE;
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: ROLLBACK TO CreateBSC1toNTabsPMD;

Line 3250: x_return_status := FND_API.G_RET_STS_ERROR;

3246: , p_data => x_msg_data
3247: );
3248: END IF;
3249: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3250: x_return_status := FND_API.G_RET_STS_ERROR;
3251: RETURN FALSE;
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: ROLLBACK TO CreateBSC1toNTabsPMD;
3254: IF (x_msg_data IS NULL) THEN

Line 3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3248: END IF;
3249: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3250: x_return_status := FND_API.G_RET_STS_ERROR;
3251: RETURN FALSE;
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: ROLLBACK TO CreateBSC1toNTabsPMD;
3254: IF (x_msg_data IS NULL) THEN
3255: FND_MSG_PUB.Count_And_Get
3256: ( p_encoded => FND_API.G_FALSE

Line 3256: ( p_encoded => FND_API.G_FALSE

3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: ROLLBACK TO CreateBSC1toNTabsPMD;
3254: IF (x_msg_data IS NULL) THEN
3255: FND_MSG_PUB.Count_And_Get
3256: ( p_encoded => FND_API.G_FALSE
3257: , p_count => x_msg_count
3258: , p_data => x_msg_data
3259: );
3260: END IF;

Line 3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3257: , p_count => x_msg_count
3258: , p_data => x_msg_data
3259: );
3260: END IF;
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3262: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3263: RETURN FALSE;
3264: WHEN NO_DATA_FOUND THEN
3265: ROLLBACK TO CreateBSC1toNTabsPMD;

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

3258: , p_data => x_msg_data
3259: );
3260: END IF;
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3262: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3263: RETURN FALSE;
3264: WHEN NO_DATA_FOUND THEN
3265: ROLLBACK TO CreateBSC1toNTabsPMD;
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3262: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3263: RETURN FALSE;
3264: WHEN NO_DATA_FOUND THEN
3265: ROLLBACK TO CreateBSC1toNTabsPMD;
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267: IF (x_msg_data IS NOT NULL) THEN
3268: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';
3269: ELSE
3270: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';

Line 3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3272: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3273: RETURN FALSE;
3274: WHEN OTHERS THEN
3275: ROLLBACK TO CreateBSC1toNTabsPMD;
3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3277: IF (x_msg_data IS NOT NULL) THEN
3278: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';
3279: ELSE
3280: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';

Line 3316: x_return_status := FND_API.G_RET_STS_SUCCESS;

3312: l_input_table VARCHAR2(30);
3313: BEGIN
3314: SAVEPOINT CreateBSCMtoNTabsPMD;
3315: FND_MSG_PUB.Initialize;
3316: x_return_status := FND_API.G_RET_STS_SUCCESS;
3317: BSC_APPS.Init_Bsc_Apps;
3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

Line 3322: RAISE FND_API.G_EXC_ERROR;

3318: IF (p_dim_obj_id IS NULL) THEN
3319: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3320: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3321: FND_MSG_PUB.ADD;
3322: RAISE FND_API.G_EXC_ERROR;
3323: END IF;
3324: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');
3325: IF (p_dim_obj_id IS NOT NULL) THEN
3326:

Line 3337: RAISE FND_API.G_EXC_ERROR;

3333: FND_MESSAGE.SET_NAME('BSC','BSC_INCORRECT_NAME_ENTERED');
3334: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3335: FND_MESSAGE.SET_TOKEN('NAME_VALUE', p_dim_obj_id);
3336: FND_MSG_PUB.ADD;
3337: RAISE FND_API.G_EXC_ERROR;
3338: END IF;
3339: END IF;
3340: SELECT COUNT(*) INTO l_count
3341: FROM BSC_SYS_DIM_LEVEL_RELS

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

3353: , x_return_status => x_return_status
3354: , x_msg_count => x_msg_count
3355: , x_msg_data => x_msg_data
3356: );
3357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3358: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable Failed: at BSC_DIMENSION_LEVELS_PUB.Drop_M_To_N_Unused_Tabs <'||x_msg_data||'>');
3359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3360: END IF;
3361: ELSE

Line 3359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3355: , x_msg_data => x_msg_data
3356: );
3357: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3358: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable Failed: at BSC_DIMENSION_LEVELS_PUB.Drop_M_To_N_Unused_Tabs <'||x_msg_data||'>');
3359: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3360: END IF;
3361: ELSE
3362: SELECT dim_level_id
3363: , abbreviation

Line 3470: x_return_status := FND_API.G_RET_STS_SUCCESS;

3466: END IF;
3467: END IF;
3468:
3469: COMMIT;
3470: x_return_status := FND_API.G_RET_STS_SUCCESS;
3471: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');
3472: RETURN TRUE;
3473: EXCEPTION
3474: WHEN FND_API.G_EXC_ERROR THEN

Line 3474: WHEN FND_API.G_EXC_ERROR THEN

3470: x_return_status := FND_API.G_RET_STS_SUCCESS;
3471: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');
3472: RETURN TRUE;
3473: EXCEPTION
3474: WHEN FND_API.G_EXC_ERROR THEN
3475: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3476: ROLLBACK TO CreateBSCMtoNTabsPMD;
3477: IF (x_msg_data IS NULL) THEN
3478: FND_MSG_PUB.Count_And_Get

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

3471: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Create_M_To_N_MTable Function');
3472: RETURN TRUE;
3473: EXCEPTION
3474: WHEN FND_API.G_EXC_ERROR THEN
3475: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3476: ROLLBACK TO CreateBSCMtoNTabsPMD;
3477: IF (x_msg_data IS NULL) THEN
3478: FND_MSG_PUB.Count_And_Get
3479: ( p_encoded => FND_API.G_FALSE

Line 3479: ( p_encoded => FND_API.G_FALSE

3475: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3476: ROLLBACK TO CreateBSCMtoNTabsPMD;
3477: IF (x_msg_data IS NULL) THEN
3478: FND_MSG_PUB.Count_And_Get
3479: ( p_encoded => FND_API.G_FALSE
3480: , p_count => x_msg_count
3481: , p_data => x_msg_data
3482: );
3483: END IF;

Line 3484: x_return_status := FND_API.G_RET_STS_ERROR;

3480: , p_count => x_msg_count
3481: , p_data => x_msg_data
3482: );
3483: END IF;
3484: x_return_status := FND_API.G_RET_STS_ERROR;
3485: RETURN FALSE;
3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3487: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3488: ROLLBACK TO CreateBSCMtoNTabsPMD;

Line 3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3482: );
3483: END IF;
3484: x_return_status := FND_API.G_RET_STS_ERROR;
3485: RETURN FALSE;
3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3487: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3488: ROLLBACK TO CreateBSCMtoNTabsPMD;
3489: IF (x_msg_data IS NULL) THEN
3490: FND_MSG_PUB.Count_And_Get

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

3483: END IF;
3484: x_return_status := FND_API.G_RET_STS_ERROR;
3485: RETURN FALSE;
3486: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3487: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3488: ROLLBACK TO CreateBSCMtoNTabsPMD;
3489: IF (x_msg_data IS NULL) THEN
3490: FND_MSG_PUB.Count_And_Get
3491: ( p_encoded => FND_API.G_FALSE

Line 3491: ( p_encoded => FND_API.G_FALSE

3487: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3488: ROLLBACK TO CreateBSCMtoNTabsPMD;
3489: IF (x_msg_data IS NULL) THEN
3490: FND_MSG_PUB.Count_And_Get
3491: ( p_encoded => FND_API.G_FALSE
3492: , p_count => x_msg_count
3493: , p_data => x_msg_data
3494: );
3495: END IF;

Line 3496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3492: , p_count => x_msg_count
3493: , p_data => x_msg_data
3494: );
3495: END IF;
3496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3497: RETURN FALSE;
3498: WHEN NO_DATA_FOUND THEN
3499: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3500: ROLLBACK TO CreateBSCMtoNTabsPMD;

Line 3501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3497: RETURN FALSE;
3498: WHEN NO_DATA_FOUND THEN
3499: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3500: ROLLBACK TO CreateBSCMtoNTabsPMD;
3501: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3502: IF (x_msg_data IS NOT NULL) THEN
3503: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';
3504: ELSE
3505: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';

Line 3511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3507: RETURN FALSE;
3508: WHEN OTHERS THEN
3509: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3510: ROLLBACK TO CreateBSCMtoNTabsPMD;
3511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3512: IF (x_msg_data IS NOT NULL) THEN
3513: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';
3514: ELSE
3515: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';

Line 3540: x_return_status := FND_API.G_RET_STS_SUCCESS;

3536: l_p_abbre BSC_SYS_DIM_LEVELS_B.Abbreviation%TYPE;
3537: BEGIN
3538: SAVEPOINT DropBSCMtoNTabsPMD;
3539: FND_MSG_PUB.Initialize;
3540: x_return_status := FND_API.G_RET_STS_SUCCESS;
3541: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);

Line 3546: RAISE FND_API.G_EXC_ERROR;

3542: IF (p_dim_obj_id IS NULL) THEN
3543: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3544: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_ID'), TRUE);
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:
3549: SELECT abbreviation INTO l_p_abbre
3550: FROM BSC_SYS_DIM_LEVELS_B

Line 3594: x_return_status := FND_API.G_RET_STS_SUCCESS;

3590:
3591: DELETE FROM BSC_DB_TABLES_RELS
3592: WHERE Source_Table_Name = l_input_table;
3593:
3594: x_return_status := FND_API.G_RET_STS_SUCCESS;
3595: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3596: EXCEPTION
3597: WHEN FND_API.G_EXC_ERROR THEN
3598: ROLLBACK TO DropBSCMtoNTabsPMD;

Line 3597: WHEN FND_API.G_EXC_ERROR THEN

3593:
3594: x_return_status := FND_API.G_RET_STS_SUCCESS;
3595: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIMENSION_PUB.Drop_M_To_N_Unused_Tabs Procedure');
3596: EXCEPTION
3597: WHEN FND_API.G_EXC_ERROR THEN
3598: ROLLBACK TO DropBSCMtoNTabsPMD;
3599: IF (x_msg_data IS NULL) THEN
3600: FND_MSG_PUB.Count_And_Get
3601: ( p_encoded => FND_API.G_FALSE

Line 3601: ( p_encoded => FND_API.G_FALSE

3597: WHEN FND_API.G_EXC_ERROR THEN
3598: ROLLBACK TO DropBSCMtoNTabsPMD;
3599: IF (x_msg_data IS NULL) THEN
3600: FND_MSG_PUB.Count_And_Get
3601: ( p_encoded => FND_API.G_FALSE
3602: , p_count => x_msg_count
3603: , p_data => x_msg_data
3604: );
3605: END IF;

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

3602: , p_count => x_msg_count
3603: , p_data => x_msg_data
3604: );
3605: END IF;
3606: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3607: x_return_status := FND_API.G_RET_STS_ERROR;
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO DropBSCMtoNTabsPMD;
3610: IF (x_msg_data IS NULL) THEN

Line 3607: x_return_status := FND_API.G_RET_STS_ERROR;

3603: , p_data => x_msg_data
3604: );
3605: END IF;
3606: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3607: x_return_status := FND_API.G_RET_STS_ERROR;
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO DropBSCMtoNTabsPMD;
3610: IF (x_msg_data IS NULL) THEN
3611: FND_MSG_PUB.Count_And_Get

Line 3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3604: );
3605: END IF;
3606: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3607: x_return_status := FND_API.G_RET_STS_ERROR;
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO DropBSCMtoNTabsPMD;
3610: IF (x_msg_data IS NULL) THEN
3611: FND_MSG_PUB.Count_And_Get
3612: ( p_encoded => FND_API.G_FALSE

Line 3612: ( p_encoded => FND_API.G_FALSE

3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO DropBSCMtoNTabsPMD;
3610: IF (x_msg_data IS NULL) THEN
3611: FND_MSG_PUB.Count_And_Get
3612: ( p_encoded => FND_API.G_FALSE
3613: , p_count => x_msg_count
3614: , p_data => x_msg_data
3615: );
3616: END IF;

Line 3617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3613: , p_count => x_msg_count
3614: , p_data => x_msg_data
3615: );
3616: END IF;
3617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3618: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3619: WHEN NO_DATA_FOUND THEN
3620: ROLLBACK TO DropBSCMtoNTabsPMD;
3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3614: , p_data => x_msg_data
3615: );
3616: END IF;
3617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3618: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3619: WHEN NO_DATA_FOUND THEN
3620: ROLLBACK TO DropBSCMtoNTabsPMD;
3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3622: IF (x_msg_data IS NOT NULL) THEN

Line 3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3618: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
3619: WHEN NO_DATA_FOUND THEN
3620: ROLLBACK TO DropBSCMtoNTabsPMD;
3621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3622: IF (x_msg_data IS NOT NULL) THEN
3623: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';
3624: ELSE
3625: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';

Line 3630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3626: END IF;
3627: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3628: WHEN OTHERS THEN
3629: ROLLBACK TO DropBSCMtoNTabsPMD;
3630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3631: IF (x_msg_data IS NOT NULL) THEN
3632: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';
3633: ELSE
3634: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';

Line 3991: RAISE FND_API.G_EXC_ERROR;

3987: IF ((l_strut_flag) AND (l_kpi_names IS NOT NULL)) THEN
3988: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3989: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpi_names);
3990: FND_MSG_PUB.ADD;
3991: RAISE FND_API.G_EXC_ERROR;
3992: END IF;
3993: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');
3994: RETURN NULL;
3995: EXCEPTION

Line 3996: WHEN FND_API.G_EXC_ERROR THEN

3992: END IF;
3993: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');
3994: RETURN NULL;
3995: EXCEPTION
3996: WHEN FND_API.G_EXC_ERROR THEN
3997: IF (l_Msg_Data IS NULL) THEN
3998: FND_MSG_PUB.Count_And_Get
3999: ( p_encoded => FND_API.G_FALSE
4000: , p_count => l_msg_count

Line 3999: ( p_encoded => FND_API.G_FALSE

3995: EXCEPTION
3996: WHEN FND_API.G_EXC_ERROR THEN
3997: IF (l_Msg_Data IS NULL) THEN
3998: FND_MSG_PUB.Count_And_Get
3999: ( p_encoded => FND_API.G_FALSE
4000: , p_count => l_msg_count
4001: , p_data => l_Msg_Data
4002: );
4003: END IF;

Line 4004: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels');

4000: , p_count => l_msg_count
4001: , p_data => l_Msg_Data
4002: );
4003: END IF;
4004: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels');
4005: RETURN l_Msg_Data;
4006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4007: IF (l_Msg_Data IS NULL) THEN
4008: FND_MSG_PUB.Count_And_Get

Line 4006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4002: );
4003: END IF;
4004: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels');
4005: RETURN l_Msg_Data;
4006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4007: IF (l_Msg_Data IS NULL) THEN
4008: FND_MSG_PUB.Count_And_Get
4009: ( p_encoded => FND_API.G_FALSE
4010: , p_count => l_msg_count

Line 4009: ( p_encoded => FND_API.G_FALSE

4005: RETURN l_Msg_Data;
4006: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4007: IF (l_Msg_Data IS NULL) THEN
4008: FND_MSG_PUB.Count_And_Get
4009: ( p_encoded => FND_API.G_FALSE
4010: , p_count => l_msg_count
4011: , p_data => l_Msg_Data
4012: );
4013: END IF;

Line 4014: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels');

4010: , p_count => l_msg_count
4011: , p_data => l_Msg_Data
4012: );
4013: END IF;
4014: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels');
4015: RETURN l_Msg_Data;
4016: WHEN OTHERS THEN
4017: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||SQLERRM);
4018: RETURN NULL;

Line 4090: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4086: , x_msg_count => x_msg_count
4087: , x_msg_data => x_msg_data
4088: );
4089: --DBMS_OUTPUT.PUT_LINE('X RETURN STATUS IS '|| x_return_status );
4090: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4091: OPEN cr_kpi_dim_set;
4092: -- bug#3405498 meastmon 28-jan-2004: The following is not supported in 8i
4093: --FETCH cr_kpi_dim_set BULK COLLECT INTO dim_objs_in_dimset;
4094: dim_objs_in_dimset.delete;

Line 4122: RAISE FND_API.G_EXC_ERROR;

4118: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4119: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4120: FND_MSG_PUB.ADD;
4121: ROLLBACK TO sp_before_rel_config;
4122: RAISE FND_API.G_EXC_ERROR;
4123: END IF;
4124: END LOOP;
4125: END IF;
4126: END IF;

Line 4133: WHEN FND_API.G_EXC_ERROR THEN

4129: CLOSE cr_kpi_dim_set;
4130: END IF ;
4131: RETURN NULL;
4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: IF (l_Msg_Data IS NULL) THEN
4135: FND_MSG_PUB.Count_And_Get
4136: ( p_encoded => FND_API.G_FALSE
4137: , p_count => l_msg_count

Line 4136: ( p_encoded => FND_API.G_FALSE

4132: EXCEPTION
4133: WHEN FND_API.G_EXC_ERROR THEN
4134: IF (l_Msg_Data IS NULL) THEN
4135: FND_MSG_PUB.Count_And_Get
4136: ( p_encoded => FND_API.G_FALSE
4137: , p_count => l_msg_count
4138: , p_data => l_Msg_Data
4139: );
4140: END IF;

Line 4208: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

4204: , x_msg_count => x_msg_count
4205: , x_msg_data => x_msg_data
4206: );
4207: --DBMS_OUTPUT.PUT_LINE('X RETURN STATUS IS '|| x_return_status );
4208: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4209: --DBMS_OUTPUT.PUT_LINE('assign new dim rel is success');
4210: FOR CD IN C_SHORT_NAMES_IDS LOOP
4211: --DBMS_OUTPUT.PUT_LINE('Calling validate pmf view for :-'|| CD.SHORT_NAME);
4212: BSC_BIS_DIM_OBJ_PUB.Validate_PMF_Views

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

4216: , x_Return_Status => x_return_status
4217: , x_Msg_Count => x_msg_count
4218: , x_Msg_Data => x_msg_data
4219: );
4220: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4221: RAISE FND_API.G_EXC_ERROR;
4222: --DBMS_OUTPUT.PUT_LINE('faliled the check for :-'|| CD.SHORT_NAME);
4223: END IF;
4224:

Line 4221: RAISE FND_API.G_EXC_ERROR;

4217: , x_Msg_Count => x_msg_count
4218: , x_Msg_Data => x_msg_data
4219: );
4220: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4221: RAISE FND_API.G_EXC_ERROR;
4222: --DBMS_OUTPUT.PUT_LINE('faliled the check for :-'|| CD.SHORT_NAME);
4223: END IF;
4224:
4225: END LOOP;

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

4237: , x_Return_Status => x_return_status
4238: , x_Msg_Count => x_msg_count
4239: , x_Msg_Data => x_msg_data
4240: );
4241: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4242: RAISE FND_API.G_EXC_ERROR;
4243: --DBMS_OUTPUT.PUT_LINE('ooops faliled the check for present dim :-'|| l_short_name);
4244: END IF;
4245: END IF;

Line 4242: RAISE FND_API.G_EXC_ERROR;

4238: , x_Msg_Count => x_msg_count
4239: , x_Msg_Data => x_msg_data
4240: );
4241: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4242: RAISE FND_API.G_EXC_ERROR;
4243: --DBMS_OUTPUT.PUT_LINE('ooops faliled the check for present dim :-'|| l_short_name);
4244: END IF;
4245: END IF;
4246: ROLLBACK TO sp_before_rel_view;

Line 4249: RETURN FND_API.G_RET_STS_SUCCESS;

4245: END IF;
4246: ROLLBACK TO sp_before_rel_view;
4247: --DBMS_OUTPUT.PUT_LINE('validte view is succeed');
4248: END IF;
4249: RETURN FND_API.G_RET_STS_SUCCESS;
4250: EXCEPTION
4251: WHEN FND_API.G_EXC_ERROR THEN
4252: IF (x_msg_data IS NULL) THEN
4253: FND_MSG_PUB.Count_And_Get

Line 4251: WHEN FND_API.G_EXC_ERROR THEN

4247: --DBMS_OUTPUT.PUT_LINE('validte view is succeed');
4248: END IF;
4249: RETURN FND_API.G_RET_STS_SUCCESS;
4250: EXCEPTION
4251: WHEN FND_API.G_EXC_ERROR THEN
4252: IF (x_msg_data IS NULL) THEN
4253: FND_MSG_PUB.Count_And_Get
4254: ( p_encoded => FND_API.G_FALSE
4255: , p_count => x_msg_count

Line 4254: ( p_encoded => FND_API.G_FALSE

4250: EXCEPTION
4251: WHEN FND_API.G_EXC_ERROR THEN
4252: IF (x_msg_data IS NULL) THEN
4253: FND_MSG_PUB.Count_And_Get
4254: ( p_encoded => FND_API.G_FALSE
4255: , p_count => x_msg_count
4256: , p_data => x_msg_data
4257: );
4258: END IF;

Line 4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4260: CLOSE C_SHORT_NAMES_IDS;
4261: END IF;
4262: ROLLBACK TO sp_before_rel_view;
4263: RETURN x_msg_data;
4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4265: IF (x_msg_data IS NULL) THEN
4266: FND_MSG_PUB.Count_And_Get
4267: ( p_encoded => FND_API.G_FALSE
4268: , p_count => x_msg_count

Line 4267: ( p_encoded => FND_API.G_FALSE

4263: RETURN x_msg_data;
4264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4265: IF (x_msg_data IS NULL) THEN
4266: FND_MSG_PUB.Count_And_Get
4267: ( p_encoded => FND_API.G_FALSE
4268: , p_count => x_msg_count
4269: , p_data => x_msg_data
4270: );
4271: END IF;