eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BSC_BIS_DIM_REL_PUB dependencies on BSC_BIS_DIM_REL_PUB

Line 1: PACKAGE BODY BSC_BIS_DIM_REL_PUB AS

1: PACKAGE BODY BSC_BIS_DIM_REL_PUB AS
2: /* $Header: BSCRPMDB.pls 120.12 2006/07/17 07:14:34 ppandey ship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 204: , x_One_N_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type

200: END Is_More;
201: --==============================================================
202: PROCEDURE get_Original_Relations
203: ( p_dim_obj_id IN NUMBER
204: , x_One_N_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type
205: , x_M_N_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_msg_count OUT NOCOPY NUMBER
208: , x_msg_data OUT NOCOPY VARCHAR2

Line 205: , x_M_N_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type

201: --==============================================================
202: PROCEDURE get_Original_Relations
203: ( p_dim_obj_id IN NUMBER
204: , x_One_N_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type
205: , x_M_N_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_msg_count OUT NOCOPY NUMBER
208: , x_msg_data OUT NOCOPY VARCHAR2
209: ) IS

Line 223: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.get_Original_Relations Procedure');

219:
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

Line 262: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.get_Original_Relations Procedure');

258: l_M_N_Count := l_M_N_Count + 1;
259: END IF;
260: END IF;
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

Line 267: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.get_Original_Relations ';

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 ';
270: END IF;
271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 269: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.get_Original_Relations ';

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 ';
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;

Line 275: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.get_Original_Relations ';

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 ';
278: END IF;
279: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 277: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.get_Original_Relations ';

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 ';
278: END IF;
279: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
280: END get_Original_Relations;
281:

Line 295: , x_rel_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.Relation_Table_Type

291: /*******************************************************************/
292:
293: PROCEDURE store_Relations
294: ( p_dim_obj_id IN NUMBER
295: , x_rel_Table OUT NOCOPY BSC_BIS_DIM_REL_PUB.Relation_Table_Type
296: , x_return_status OUT NOCOPY VARCHAR2
297: , x_msg_count OUT NOCOPY NUMBER
298: , x_msg_data OUT NOCOPY VARCHAR2
299: )IS

Line 328: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.store_Relations ';

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 ';
331: END IF;
332: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 330: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.store_Relations ';

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 ';
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;

Line 336: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.store_Relations ';

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 ';
339: END IF;
340: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 338: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.store_Relations ';

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 ';
339: END IF;
340: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
341: END store_Relations;
342:

Line 465: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_dim_obj_id)

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
467:
468: BSC_BIS_DIM_REL_PUB.get_Filtered_Tabs
469: (

Line 466: AND(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_par_dim_obj_id)))THEN

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
467:
468: BSC_BIS_DIM_REL_PUB.get_Filtered_Tabs
469: (
470: p_dim_level_id => p_dim_obj_id

Line 468: BSC_BIS_DIM_REL_PUB.get_Filtered_Tabs

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
467:
468: BSC_BIS_DIM_REL_PUB.get_Filtered_Tabs
469: (
470: p_dim_level_id => p_dim_obj_id
471: , p_par_dim_level_id => p_par_dim_obj_id
472: , p_common_tabs => l_common_tabs

Line 497: ELSIF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_dim_obj_id)

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)
498: AND(NOT BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_par_dim_obj_id)))THEN
499: /*********************************************************
500: Its not possible to have filter applied on child and parent is not
501: having the filter applied.If this condition exists then we have to remove

Line 498: AND(NOT BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_par_dim_obj_id)))THEN

494: END IF;
495: END LOOP;
496: END IF;
497: ELSIF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_dim_obj_id)
498: AND(NOT BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(p_par_dim_obj_id)))THEN
499: /*********************************************************
500: Its not possible to have filter applied on child and parent is not
501: having the filter applied.If this condition exists then we have to remove
502: the filter on the child.

Line 549: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs ';

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 ';
552: END IF;
553: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 551: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs ';

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 ';
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;

Line 557: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs ';

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 ';
560: END IF;
561: END Validate_Filtered_Tabs;

Line 559: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs ';

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 ';
560: END IF;
561: END Validate_Filtered_Tabs;
562:
563: /********************************************************************

Line 647: , x_new_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type

643:
644: PROCEDURE Validate_filter_views
645: (
646: p_dim_obj_id IN NUMBER
647: , x_new_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
648: , x_prev_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
649: , x_return_status OUT NOCOPY VARCHAR2
650: , x_msg_count OUT NOCOPY NUMBER
651: , x_msg_data OUT NOCOPY VARCHAR2

Line 648: , x_prev_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type

644: PROCEDURE Validate_filter_views
645: (
646: p_dim_obj_id IN NUMBER
647: , x_new_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
648: , x_prev_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
649: , x_return_status OUT NOCOPY VARCHAR2
650: , x_msg_count OUT NOCOPY NUMBER
651: , x_msg_data OUT NOCOPY VARCHAR2
652: )IS

Line 678: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_prev_rel_Table(i).p_Parent_Dim_Id))THEN

674: -- for old relationships
675: IF(l_old_count>0) THEN
676: FOR i IN 0..l_old_count -1 LOOP
677: IF(x_prev_rel_Table(i).p_Relation_Type=1) THEN
678: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_prev_rel_Table(i).p_Parent_Dim_Id))THEN
679: OPEN c_filter_tabs(x_prev_rel_Table(i).p_Parent_Dim_Id);
680: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
681: WHILE(c_filter_tabs%FOUND)LOOP
682: IF(l_level_view_name IS NOT NULL)THEN

Line 683: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views

679: OPEN c_filter_tabs(x_prev_rel_Table(i).p_Parent_Dim_Id);
680: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
681: WHILE(c_filter_tabs%FOUND)LOOP
682: IF(l_level_view_name IS NOT NULL)THEN
683: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views
684: (
685: p_source => l_tab
686: , p_level_view_name => l_level_view_name
687: , p_dim_level_id => l_dim_level_id

Line 701: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_prev_rel_Table(i).p_Dim_Obj_ID))THEN

697: END LOOP;
698: CLOSE c_filter_tabs;
699: END IF;
700: ELSE
701: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_prev_rel_Table(i).p_Dim_Obj_ID))THEN
702: OPEN c_filter_tabs(x_prev_rel_Table(i).p_Dim_Obj_ID);
703: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
704: WHILE(c_filter_tabs%FOUND)LOOP
705: IF(l_level_view_name IS NOT NULL)THEN

Line 706: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views

702: OPEN c_filter_tabs(x_prev_rel_Table(i).p_Dim_Obj_ID);
703: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
704: WHILE(c_filter_tabs%FOUND)LOOP
705: IF(l_level_view_name IS NOT NULL)THEN
706: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views
707: (
708: p_source => l_tab
709: , p_level_view_name => l_level_view_name
710: , p_dim_level_id => l_dim_level_id

Line 725: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_prev_rel_Table(i).p_Parent_Dim_Id))THEN

721: CLOSE c_filter_tabs;
722: END IF;
723:
724: --Now for parent
725: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_prev_rel_Table(i).p_Parent_Dim_Id))THEN
726: OPEN c_filter_tabs(x_prev_rel_Table(i).p_Parent_Dim_Id);
727: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
728: WHILE(c_filter_tabs%FOUND)LOOP
729: IF(l_level_view_name IS NOT NULL)THEN

Line 730: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views

726: OPEN c_filter_tabs(x_prev_rel_Table(i).p_Parent_Dim_Id);
727: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
728: WHILE(c_filter_tabs%FOUND)LOOP
729: IF(l_level_view_name IS NOT NULL)THEN
730: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views
731: (
732: p_source => l_tab
733: , p_level_view_name => l_level_view_name
734: , p_dim_level_id => l_dim_level_id

Line 755: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_new_rel_Table(j).p_Parent_Dim_Id))THEN

751: -- for new relationships
752: IF(l_new_count>0) THEN
753: FOR j IN 0..l_new_count -1 LOOP
754: IF(x_new_rel_Table(j).p_Relation_Type=1) THEN
755: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_new_rel_Table(j).p_Parent_Dim_Id))THEN
756: OPEN c_filter_tabs(x_new_rel_Table(j).p_Parent_Dim_Id);
757: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
758: WHILE(c_filter_tabs%FOUND)LOOP
759: IF(l_level_view_name IS NOT NULL)THEN

Line 760: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views

756: OPEN c_filter_tabs(x_new_rel_Table(j).p_Parent_Dim_Id);
757: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
758: WHILE(c_filter_tabs%FOUND)LOOP
759: IF(l_level_view_name IS NOT NULL)THEN
760: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views
761: (
762: p_source => l_tab
763: , p_level_view_name => l_level_view_name
764: , p_dim_level_id => l_dim_level_id

Line 778: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_new_rel_Table(j).p_Dim_Obj_ID))THEN

774: END LOOP;
775: CLOSE c_filter_tabs;
776: END IF;
777: ELSE
778: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_new_rel_Table(j).p_Dim_Obj_ID))THEN
779: OPEN c_filter_tabs(x_new_rel_Table(j).p_Dim_Obj_ID);
780: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
781: WHILE(c_filter_tabs%FOUND)LOOP
782: IF(l_level_view_name IS NOT NULL)THEN

Line 783: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views

779: OPEN c_filter_tabs(x_new_rel_Table(j).p_Dim_Obj_ID);
780: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
781: WHILE(c_filter_tabs%FOUND)LOOP
782: IF(l_level_view_name IS NOT NULL)THEN
783: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views
784: (
785: p_source => l_tab
786: , p_level_view_name => l_level_view_name
787: , p_dim_level_id => l_dim_level_id

Line 802: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_new_rel_Table(j).p_Parent_Dim_Id))THEN

798: CLOSE c_filter_tabs;
799: END IF;
800:
801: --Now for parent
802: IF(BSC_BIS_DIM_REL_PUB.is_Filtered_Applied(x_new_rel_Table(j).p_Parent_Dim_Id))THEN
803: OPEN c_filter_tabs(x_new_rel_Table(j).p_Parent_Dim_Id);
804: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
805: WHILE(c_filter_tabs%FOUND)LOOP
806: IF(l_level_view_name IS NOT NULL)THEN

Line 807: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views

803: OPEN c_filter_tabs(x_new_rel_Table(j).p_Parent_Dim_Id);
804: FETCH c_filter_tabs INTO l_tab,l_level_view_name,l_dim_level_id;
805: WHILE(c_filter_tabs%FOUND)LOOP
806: IF(l_level_view_name IS NOT NULL)THEN
807: BSC_BIS_DIM_REL_PUB.Verify_Recreate_Filter_Views
808: (
809: p_source => l_tab
810: , p_level_view_name => l_level_view_name
811: , p_dim_level_id => l_dim_level_id

Line 842: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_filter_views ';

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 ';
845: END IF;
846: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 844: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_filter_views ';

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 ';
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;

Line 850: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_filter_views ';

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 ';
853: END IF;
854: END Validate_filter_views;

Line 852: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_filter_views ';

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 ';
853: END IF;
854: END Validate_filter_views;
855:
856: /********************************************************************

Line 900: , x_new_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type

896: /*******************************************************************/
897: PROCEDURE Validate_Filter_Button
898: (
899: p_dim_obj_id IN NUMBER
900: , x_new_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
901: , x_prev_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
902: , x_return_status OUT NOCOPY VARCHAR2
903: , x_msg_count OUT NOCOPY NUMBER
904: , x_msg_data OUT NOCOPY VARCHAR2

Line 901: , x_prev_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type

897: PROCEDURE Validate_Filter_Button
898: (
899: p_dim_obj_id IN NUMBER
900: , x_new_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
901: , x_prev_rel_Table IN BSC_BIS_DIM_REL_PUB.Relation_Table_Type
902: , x_return_status OUT NOCOPY VARCHAR2
903: , x_msg_count OUT NOCOPY NUMBER
904: , x_msg_data OUT NOCOPY VARCHAR2
905:

Line 907: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;

903: , x_msg_count OUT NOCOPY NUMBER
904: , x_msg_data OUT NOCOPY VARCHAR2
905:
906: )IS
907: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
908: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
909: l_dim_obj_tbls BSC_UTILITY.varchar_tabletype;
910:
911:

Line 908: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;

904: , x_msg_data OUT NOCOPY VARCHAR2
905:
906: )IS
907: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
908: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
909: l_dim_obj_tbls BSC_UTILITY.varchar_tabletype;
910:
911:
912: l_New_Count NUMBER;

Line 949: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs

945: IF(l_new_rel_Table(i_index).p_Relation_Type =1) THEN
946: IF((l_new_rel_Table(i_index).p_Dim_Obj_ID=p_dim_obj_id)
947: AND (l_new_rel_Table(i_index).p_Parent_Dim_Id<> p_dim_obj_id)) THEN
948:
949: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs
950: (
951: p_dim_obj_id => l_new_rel_Table(i_index).p_Dim_Obj_ID
952: , p_par_dim_obj_id => l_new_rel_Table(i_index).p_Parent_Dim_Id
953: , x_return_status => x_return_status

Line 964: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs

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
963:
964: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs
965: (
966: p_dim_obj_id => l_new_rel_Table(i_index).p_Dim_Obj_ID
967: , p_par_dim_obj_id => l_new_rel_Table(i_index).p_Parent_Dim_Id
968: , x_return_status => x_return_status

Line 994: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs

990: IF(l_prev_rel_Table(i_index).p_Relation_Type =1) THEN
991: IF((l_prev_rel_Table(i_index).p_Dim_Obj_ID=p_dim_obj_id)
992: AND (l_prev_rel_Table(i_index).p_Parent_Dim_Id<> p_dim_obj_id)) THEN
993:
994: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs
995: (
996: p_dim_obj_id => l_prev_rel_Table(i_index).p_Dim_Obj_ID
997: , p_par_dim_obj_id => l_prev_rel_Table(i_index).p_Parent_Dim_Id
998: , x_return_status => x_return_status

Line 1009: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs

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
1008:
1009: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs
1010: (
1011: p_dim_obj_id => l_prev_rel_Table(i_index).p_Dim_Obj_ID
1012: , p_par_dim_obj_id => l_prev_rel_Table(i_index).p_Parent_Dim_Id
1013: , x_return_status => x_return_status

Line 1069: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs

1065: END LOOP;--out_index
1066:
1067: FOR j IN 0..l_prev_rel_Table.COUNT -1 LOOP
1068: IF((l_prev_rel_Table(j).p_Refresh_Flag=TRUE) AND (l_prev_rel_Table(j).p_Refresh_No =-1))THEN
1069: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs
1070: (
1071: p_dim_obj_id => l_prev_rel_Table(j).p_Dim_Obj_ID
1072: , p_par_dim_obj_id => l_prev_rel_Table(j).p_Parent_Dim_Id
1073: , x_return_status => x_return_status

Line 1116: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs

1112: /****************************************************************/
1113:
1114: FOR i IN 0..l_new_rel_Table.COUNT -1 LOOP
1115: IF((l_new_rel_Table(i).p_Refresh_No = -1) AND (l_new_rel_Table(i).p_Relation_Type=1)) THEN
1116: BSC_BIS_DIM_REL_PUB.Validate_Filtered_Tabs
1117: (
1118: p_dim_obj_id => l_new_rel_Table(i).p_Dim_Obj_ID
1119: , p_par_dim_obj_id => l_new_rel_Table(i).p_Parent_Dim_Id
1120: , x_return_status => x_return_status

Line 1136: BSC_BIS_DIM_REL_PUB.Validate_filter_views

1132: invalidated when relationship type is changed. If yes then
1133: it will recreate the filter views.
1134: /***********************************************************/
1135:
1136: BSC_BIS_DIM_REL_PUB.Validate_filter_views
1137: (
1138: p_dim_obj_id => p_dim_obj_id
1139: , x_new_rel_Table => l_new_rel_Table
1140: , x_prev_rel_Table => l_prev_rel_Table

Line 1163: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

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 ';
1166: END IF;
1167: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1165: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

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 ';
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;

Line 1171: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

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 ';
1174: END IF;
1175: END Validate_Filter_Button;

Line 1173: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Validate_Filter_Button ';

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 ';
1174: END IF;
1175: END Validate_Filter_Button;
1176:
1177: --=====================================================================================*/

Line 1252: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');

1248: FROM BSC_SYS_DIM_LEVEL_RELS
1249: WHERE parent_dim_level_id = p_dim_obj_id
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');

Line 1336: --DBMS_OUTPUT.PUT_LINE(' BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels');

1332: END IF;
1333: END IF;
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||''' ');

Line 1354: BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels

1350: --DBMS_OUTPUT.PUT_LINE(' , x_return_status => l_return_status');
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

Line 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');

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
1377: COMMIT;

Line 1380: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels Procedure');

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');
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

Line 1405: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

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 ';
1408: END IF;
1409: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1407: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

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 ';
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;

Line 1413: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

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 ';
1416: END IF;
1417: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1415: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_Dim_Obj_Rels ';

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 ';
1416: END IF;
1417: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1418: END Assign_Dim_Obj_Rels;
1419: /*********************************************************************************

Line 1453: l_One_N_Table BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type;

1449: , x_return_status OUT NOCOPY VARCHAR2
1450: , x_msg_count OUT NOCOPY NUMBER
1451: , x_msg_data OUT NOCOPY VARCHAR2
1452: ) IS
1453: l_One_N_Table BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type;
1454: l_M_N_Table BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type;
1455:
1456: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1457: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;

Line 1454: l_M_N_Table BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type;

1450: , x_msg_count OUT NOCOPY NUMBER
1451: , x_msg_data OUT NOCOPY VARCHAR2
1452: ) IS
1453: l_One_N_Table BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type;
1454: l_M_N_Table BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type;
1455:
1456: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1457: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1458:

Line 1456: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;

1452: ) IS
1453: l_One_N_Table BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type;
1454: l_M_N_Table BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type;
1455:
1456: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1457: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1458:
1459: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1460:

Line 1457: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;

1453: l_One_N_Table BSC_BIS_DIM_REL_PUB.One_To_N_Org_Table_Type;
1454: l_M_N_Table BSC_BIS_DIM_REL_PUB.M_To_N_Org_Table_Type;
1455:
1456: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1457: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
1458:
1459: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
1460:
1461: l_count NUMBER;

Line 1554: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');

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);
1558: --DBMS_OUTPUT.PUT_LINE('p_parent_rel_column '||p_parent_rel_column);

Line 1682: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_DIM_REL_PUB.get_Original_Relations');

1678: -- END: Granular Locking
1679: --find out all the initial childs first
1680: --for relation type 2, which are not needed
1681: --if dimension objects are of type 'BSC'
1682: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_DIM_REL_PUB.get_Original_Relations');
1683: BSC_BIS_DIM_REL_PUB.get_Original_Relations
1684: ( p_dim_obj_id => p_dim_obj_id
1685: , x_One_N_Table => l_One_N_Table
1686: , x_M_N_Table => l_M_N_Table

Line 1683: BSC_BIS_DIM_REL_PUB.get_Original_Relations

1679: --find out all the initial childs first
1680: --for relation type 2, which are not needed
1681: --if dimension objects are of type 'BSC'
1682: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_DIM_REL_PUB.get_Original_Relations');
1683: BSC_BIS_DIM_REL_PUB.get_Original_Relations
1684: ( p_dim_obj_id => p_dim_obj_id
1685: , x_One_N_Table => l_One_N_Table
1686: , x_M_N_Table => l_M_N_Table
1687: , x_return_status => x_return_status

Line 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||'>');

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:
1696: -- Added for Bug#5300060

Line 1704: BSC_BIS_DIM_REL_PUB.store_Relations

1700: Store the original relationships for the filter view validation
1701: /****************************************************/
1702: IF((p_is_not_config) AND (l_source = 'BSC'))THEN
1703:
1704: BSC_BIS_DIM_REL_PUB.store_Relations
1705: ( p_dim_obj_id => p_dim_obj_id
1706: , x_rel_Table => l_prev_rel_Table
1707: , x_return_status => x_return_status
1708: , x_msg_count => x_msg_count

Line 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||'>');

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;
1716:

Line 1717: --DBMS_OUTPUT.PUT_LINE('AFTER BSC_BIS_DIM_REL_PUB.get_Original_Relations');

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');
1718: --DBMS_OUTPUT.PUT_LINE(' --- INITIAL TABLE ----');
1719: --DBMS_OUTPUT.PUT_LINE('PRINT OUT OF THE TABLES THAT WE HAVE GOT 1 x N RELATIONS');
1720: /*FOR i IN 0..(l_One_N_Table.COUNT-1) LOOP
1721: --DBMS_OUTPUT.PUT_LINE('l_One_N_Table('||i||').p_dim_obj_id '||l_One_N_Table(i).p_dim_obj_id);

Line 1860: --DBMS_OUTPUT.PUT_LINE('BEFORE BSC_BIS_DIM_REL_PUB.Is_Valid_Relationship');

1856: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id
1857: AND parent_dim_level_id = l_bsc_dim_obj_rec.bsc_parent_level_id;
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

Line 1869: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship.');

1865: , x_msg_count => x_msg_count
1866: , x_msg_data => x_msg_data
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;

Line 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');

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
1900: -- Change the time stamp of the Child Dimension Level

Line 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');

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;
1913: -- END Granluar Locking

Line 2031: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Failed: at BSC_DIMENSION_LEVELS_PUB.Is_Valid_Relationship');

2027: , x_msg_count => x_msg_count
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

Line 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');

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:
2060: -- START Granluar Locking

Line 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');

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;
2074: --DBMS_OUTPUT.PUT_LINE('PARENT IDS STAGE4');

Line 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');

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;
2234: --DBMS_OUTPUT.PUT_LINE('Cascading changes to KPIs Part Ends Here');

Line 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');

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;
2268: --DBMS_OUTPUT.PUT_LINE(' --- FINAL TABLE ----');

Line 2306: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable');

2302: --DBMS_OUTPUT.PUT_LINE('REFRESHING MASTER TABLES PART STARTS HERE');
2303: --DBMS_OUTPUT.PUT_LINE('--- ******** FOR 1 x N RELATIONS ******** -----');
2304: FOR i IN 0..(l_One_N_Table.COUNT-1) LOOP
2305: IF (l_One_N_Table(i).p_refresh_flag) THEN
2306: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable');
2307: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||l_One_N_Table(i).p_dim_obj_id);
2308: l_flag := BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable
2309: ( p_dim_obj_id => l_One_N_Table(i).p_dim_obj_id
2310: , x_return_status => x_return_status

Line 2308: l_flag := BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable

2304: FOR i IN 0..(l_One_N_Table.COUNT-1) LOOP
2305: IF (l_One_N_Table(i).p_refresh_flag) THEN
2306: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable');
2307: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||l_One_N_Table(i).p_dim_obj_id);
2308: l_flag := BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable
2309: ( p_dim_obj_id => l_One_N_Table(i).p_dim_obj_id
2310: , x_return_status => x_return_status
2311: , x_msg_count => x_msg_count
2312: , x_msg_data => x_msg_data

Line 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||'>');

2311: , x_msg_count => x_msg_count
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;

Line 2323: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable');

2319: END LOOP;
2320: --DBMS_OUTPUT.PUT_LINE('--- ******** FOR M x N RELATIONS ******** -----');
2321: FOR i IN 0..(l_M_N_Table.COUNT-1) LOOP
2322: IF (l_M_N_Table(i).p_refresh_flag) THEN
2323: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable');
2324: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||l_M_N_Table(i).p_dim_obj_id);
2325: --DBMS_OUTPUT.PUT_LINE('p_parent_ids '||l_M_N_Table(i).p_Parent_dim_id);
2326: l_flag := BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable
2327: ( p_dim_obj_id => l_M_N_Table(i).p_dim_obj_id

Line 2326: l_flag := BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable

2322: IF (l_M_N_Table(i).p_refresh_flag) THEN
2323: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable');
2324: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||l_M_N_Table(i).p_dim_obj_id);
2325: --DBMS_OUTPUT.PUT_LINE('p_parent_ids '||l_M_N_Table(i).p_Parent_dim_id);
2326: l_flag := BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable
2327: ( p_dim_obj_id => l_M_N_Table(i).p_dim_obj_id
2328: , p_parent_id => l_M_N_Table(i).p_Parent_dim_id
2329: , x_return_status => x_return_status
2330: , x_msg_count => x_msg_count

Line 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||'>');

2330: , x_msg_count => x_msg_count
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;

Line 2343: BSC_BIS_DIM_REL_PUB.store_Relations

2339: --DBMS_OUTPUT.PUT_LINE('REFRESHING MASTER TABLES PART ENDS HERE');
2340: END IF;
2341:
2342: IF((p_is_not_config) AND (l_source = 'BSC'))THEN
2343: BSC_BIS_DIM_REL_PUB.store_Relations
2344: ( p_dim_obj_id => p_dim_obj_id
2345: , x_rel_Table => l_new_rel_Table
2346: , x_return_status => x_return_status
2347: , x_msg_count => x_msg_count

Line 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||'>');

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:
2355: BSC_BIS_DIM_REL_PUB.Validate_Filter_Button

Line 2355: BSC_BIS_DIM_REL_PUB.Validate_Filter_Button

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: (
2357: p_dim_obj_id => p_dim_obj_id
2358: , x_new_rel_Table => l_new_rel_Table
2359: , x_prev_rel_Table => l_prev_rel_Table

Line 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||'>');

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;
2370:

Line 2468: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels Procedure');

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);
2472: IF (c_db_child_type%ISOPEN) THEN

Line 2506: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';

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 ';
2509: END IF;
2510: WHEN OTHERS THEN

Line 2508: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';

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 ';
2509: END IF;
2510: WHEN OTHERS THEN
2511: IF (c_db_child_type%ISOPEN) THEN
2512: CLOSE c_db_child_type;

Line 2518: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';

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 ';
2521: END IF;
2522: END Assign_New_Dim_Obj_Rels;

Line 2520: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels ';

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 ';
2521: END IF;
2522: END Assign_New_Dim_Obj_Rels;
2523: /*********************************************************************************
2524: UNASSIGN DIMENSION-OBJECTS RELATIONSHIPS

Line 2570: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');

2566: FROM BSC_SYS_DIM_LEVEL_RELS
2567: WHERE parent_dim_level_id = p_dim_obj_id
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');

Line 2661: BSC_BIS_DIM_REL_PUB.Assign_New_Dim_Obj_Rels

2657: l_child_data_source := l_child_data_source||', '||NVL(cd.data_source, 'NULL');
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

Line 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');

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
2684: COMMIT;

Line 2687: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels Procedure');

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');
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

Line 2712: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

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 ';
2715: END IF;
2716: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2714: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

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 ';
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;

Line 2720: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

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 ';
2723: END IF;
2724: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2722: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.UnAssign_Dim_Obj_Rels ';

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 ';
2723: END IF;
2724: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2725: END UnAssign_Dim_Obj_Rels;
2726:

Line 2941: l_index_Table BSC_BIS_DIM_REL_PUB.One_To_N_Index_Table;

2937: l_temp_table VARCHAR2(30);
2938:
2939: l_level_pk_col BSC_SYS_DIM_LEVELS_B.Level_Pk_Col%TYPE;
2940: l_label_table_name BSC_SYS_DIM_LEVELS_B.Level_Table_Name%TYPE;
2941: l_index_Table BSC_BIS_DIM_REL_PUB.One_To_N_Index_Table;
2942: l_index_Count NUMBER;
2943:
2944: l_alias VARCHAR2(4);
2945: l_flag BOOLEAN;

Line 3018: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(l_alias);

3014: IF (l_count = 0) THEN
3015: l_flag := FALSE;
3016: l_dummy_table := UPPER(l_temp_table);
3017: END IF;
3018: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(l_alias);
3019: l_temp_table := l_dummy_table||l_alias;
3020: END LOOP;
3021: --DBMS_OUTPUT.PUT_LINE('l_dummy_table <'||l_dummy_table||'>');
3022:

Line 3028: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(NULL);

3024: l_view_columns := 'CODE, USER_CODE, NAME ';
3025: l_input_col_names := 'USER_CODE, NAME ';
3026:
3027: --DBMS_OUTPUT.PUT_LINE('Original Master Columns <'||l_col_names||'>');
3028: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(NULL);
3029: l_level_pk_cols := NULL;
3030: l_index_Count := 0;
3031: l_sql_stmt := 'CREATE TABLE '||l_dummy_table||' '||' TABLESPACE '||
3032: BSC_APPS.Get_Tablespace_Name(BSC_APPS.Dimension_Table_Tbs_Type)||' '||BSC_APPS.bsc_storage_clause||

Line 3046: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(l_alias);

3042: l_level_pk_cols := l_level_pk_cols||', '||''''||l_level_pk_col||'''';
3043: END IF;
3044: l_sql_stmt1 := 'SELECT code,user_code FROM '||l_label_table_name||' WHERE code = (SELECT MAX(a.code) FROM '||l_label_table_name ||' a) AND ROWNUM <2';
3045: EXECUTE IMMEDIATE l_sql_stmt1 INTO l_max_code,l_max_usr_code ;
3046: l_alias := BSC_BIS_DIM_REL_PUB.get_Next_Alias(l_alias);
3047: --DBMS_OUTPUT.PUT_LINE('l_alias <'||l_alias||'>');
3048: l_sql_stmt := l_sql_stmt||' , ';
3049: l_sql_stmt := l_sql_stmt||' '||'NVL('||l_alias||'.CODE,'||l_max_code||') AS '||l_level_pk_col||', '||'NVL('||
3050: l_alias||'.USER_CODE,'''||l_max_usr_code||''') AS '||l_level_pk_col||'_USR ';

Line 3237: x_msg_data := l_error_msg || ' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable';

3233: EXCEPTION
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;

Line 3268: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';

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 ';
3271: END IF;
3272: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3270: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';

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 ';
3271: END IF;
3272: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3273: RETURN FALSE;
3274: WHEN OTHERS THEN

Line 3278: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';

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 ';
3281: END IF;
3282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3280: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_One_To_N_MTable ';

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 ';
3281: END IF;
3282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3283: RETURN FALSE;
3284: END Create_One_To_N_MTable;

Line 3347: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs');

3343: AND parent_dim_level_id = p_parent_id
3344: AND relation_type = 2;
3345: --DBMS_OUTPUT.PUT_LINE('After');
3346: IF (l_count = 0) THEN
3347: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs');
3348: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||p_dim_obj_id);
3349: --DBMS_OUTPUT.PUT_LINE('p_parent_ids '||p_parent_id);
3350: BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs
3351: ( p_dim_obj_id => p_dim_obj_id

Line 3350: BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs

3346: IF (l_count = 0) THEN
3347: --DBMS_OUTPUT.PUT_LINE('Parameters to BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs');
3348: --DBMS_OUTPUT.PUT_LINE('p_dim_obj_id '||p_dim_obj_id);
3349: --DBMS_OUTPUT.PUT_LINE('p_parent_ids '||p_parent_id);
3350: BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs
3351: ( p_dim_obj_id => p_dim_obj_id
3352: , p_parent_id => p_parent_id
3353: , x_return_status => x_return_status
3354: , x_msg_count => x_msg_count

Line 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||'>');

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
3362: SELECT dim_level_id

Line 3503: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';

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 ';
3506: END IF;
3507: RETURN FALSE;

Line 3505: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';

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 ';
3506: END IF;
3507: RETURN FALSE;
3508: WHEN OTHERS THEN
3509: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3513: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';

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 ';
3516: END IF;
3517: RETURN FALSE;

Line 3515: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Create_M_To_N_MTable ';

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 ';
3516: END IF;
3517: RETURN FALSE;
3518: END Create_M_To_N_MTable;
3519: /*******************************************************************************

Line 3623: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';

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 ';
3626: END IF;
3627: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3625: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';

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 ';
3626: END IF;
3627: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3628: WHEN OTHERS THEN
3629: ROLLBACK TO DropBSCMtoNTabsPMD;

Line 3632: x_msg_data := x_msg_data||' -> BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';

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 ';
3635: END IF;
3636: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3634: x_msg_data := SQLERRM||' at BSC_BIS_DIM_REL_PUB.Drop_M_To_N_Unused_Tabs ';

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 ';
3635: END IF;
3636: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3637: END Drop_M_To_N_Unused_Tabs;
3638:

Line 3725: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');

3721: AND C.SHARE_FLAG <> 2
3722: AND INSTR(', '||l_final_chd_ids||',', ', '||b.dim_level_id||',') > 0;
3723:
3724: BEGIN
3725: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');
3726:
3727: FND_MSG_PUB.Initialize;
3728: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
3729: RETURN NULL;

Line 3993: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');

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
3996: WHEN FND_API.G_EXC_ERROR THEN
3997: IF (l_Msg_Data IS NULL) THEN

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 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 4286: END BSC_BIS_DIM_REL_PUB;

4282: END check_invalid_pmf_view_inrel;
4283:
4284: --***************************************************************
4285:
4286: END BSC_BIS_DIM_REL_PUB;