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_DIMENSION_GROUPS_PVT dependencies on BSC_DIMENSION_GROUPS_PVT

Line 1: package body BSC_DIMENSION_GROUPS_PVT as

1: package body BSC_DIMENSION_GROUPS_PVT as
2: /* $Header: BSCVDMGB.pls 120.0 2005/06/01 14:37:31 appldev noship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 43: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DIMENSION_GROUPS_PVT';

39: | 21-DEC-04 vtulasi Modified for bug#4045278 - Addtion of LUD |
40: | 01-FEB-05 hengliu Modified for bug#4104065 - WHERE_CLAUSE can be null |
41: +======================================================================================+
42: */
43: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_DIMENSION_GROUPS_PVT';
44: g_db_object varchar2(30) := null;
45:
46: --
47: /**********************************************************************************/

Line 97: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);

93: FND_MSG_PUB.Initialize;
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95: -- Validate Group Id does not exist.
96: if p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id is not null then
97: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
98: if l_count <> 0 then
99: FND_MESSAGE.SET_NAME('BSC','BSC_GROUP_ID_EXISTS');
100: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
101: FND_MSG_PUB.ADD;

Line 196: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group ';

192: WHEN NO_DATA_FOUND THEN
193: ROLLBACK TO CreateBSCDimGrpPVT;
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF (x_msg_data IS NOT NULL) THEN
196: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group ';
197: ELSE
198: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group '||SQLERRM;
199: END IF;
200: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 198: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group '||SQLERRM;

194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF (x_msg_data IS NOT NULL) THEN
196: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group ';
197: ELSE
198: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group '||SQLERRM;
199: END IF;
200: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
201: RAISE;
202: WHEN OTHERS THEN

Line 212: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group ';

208: FND_MSG_PUB.ADD;
209: RAISE FND_API.G_EXC_ERROR;
210: end if;
211: IF (x_msg_data IS NOT NULL) THEN
212: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group ';
213: ELSE
214: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group '||SQLERRM;
215: END IF;
216: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 214: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group '||SQLERRM;

210: end if;
211: IF (x_msg_data IS NOT NULL) THEN
212: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group ';
213: ELSE
214: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dimension_Group '||SQLERRM;
215: END IF;
216: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
217: RAISE;
218: end Create_Dimension_Group;

Line 268: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group ';

264: RAISE;
265: WHEN NO_DATA_FOUND THEN
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: IF (x_msg_data IS NOT NULL) THEN
268: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group ';
269: ELSE
270: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group '||SQLERRM;
271: END IF;
272: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 270: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group '||SQLERRM;

266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267: IF (x_msg_data IS NOT NULL) THEN
268: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group ';
269: ELSE
270: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group '||SQLERRM;
271: END IF;
272: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
273: RAISE;
274: WHEN OTHERS THEN

Line 277: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group ';

273: RAISE;
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF (x_msg_data IS NOT NULL) THEN
277: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group ';
278: ELSE
279: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group '||SQLERRM;
280: END IF;
281: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 279: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group '||SQLERRM;

275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF (x_msg_data IS NOT NULL) THEN
277: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group ';
278: ELSE
279: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dimension_Group '||SQLERRM;
280: END IF;
281: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
282: RAISE;
283: end Retrieve_Dimension_Group;

Line 315: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);

311: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
312:
313: -- Check that valid dimension group id was entered.
314: if p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id is not null then
315: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
316: if l_count = 0 then
317: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
318: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
319: FND_MSG_PUB.ADD;

Line 406: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group ';

402: END IF;
403: ROLLBACK TO UpdateBSCDimGrpPVT;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: IF (x_msg_data IS NOT NULL) THEN
406: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group ';
407: ELSE
408: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group '||SQLERRM;
409: END IF;
410: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 408: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group '||SQLERRM;

404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: IF (x_msg_data IS NOT NULL) THEN
406: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group ';
407: ELSE
408: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group '||SQLERRM;
409: END IF;
410: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
411: RAISE;
412: WHEN OTHERS THEN

Line 419: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group ';

415: END IF;
416: ROLLBACK TO UpdateBSCDimGrpPVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group ';
420: ELSE
421: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group '||SQLERRM;
422: END IF;
423: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 421: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group '||SQLERRM;

417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group ';
420: ELSE
421: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dimension_Group '||SQLERRM;
422: END IF;
423: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
424: RAISE;
425: end Update_Dimension_Group;

Line 457: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);

453: -- "Record" variable.
454: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
455:
456: if l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id is not null then
457: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
458: if l_count = 0 then
459: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
460: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
461: FND_MSG_PUB.ADD;

Line 553: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group ';

549: END IF;
550: ROLLBACK TO DeleteBSCDimGrpPVT;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: IF (x_msg_data IS NOT NULL) THEN
553: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group ';
554: ELSE
555: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group '||SQLERRM;
556: END IF;
557: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 555: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group '||SQLERRM;

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

Line 566: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group ';

562: END IF;
563: ROLLBACK TO DeleteBSCDimGrpPVT;
564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: IF (x_msg_data IS NOT NULL) THEN
566: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group ';
567: ELSE
568: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group '||SQLERRM;
569: END IF;
570: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 568: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group '||SQLERRM;

564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
565: IF (x_msg_data IS NOT NULL) THEN
566: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group ';
567: ELSE
568: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dimension_Group '||SQLERRM;
569: END IF;
570: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
571: RAISE;
572: end Delete_Dimension_Group;

Line 608: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);

604: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
605:
606: -- Check that the group id is valid or that the name is valid.
607: if l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id is not null then
608: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
609: if l_count = 0 then
610: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
611: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
612: FND_MSG_PUB.ADD;

Line 752: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group ';

748: WHEN NO_DATA_FOUND THEN
749: ROLLBACK TO CreateBSCDimLevInGrpPVT;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: IF (x_msg_data IS NOT NULL) THEN
752: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group ';
753: ELSE
754: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group '||SQLERRM;
755: END IF;
756: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 754: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group '||SQLERRM;

750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: IF (x_msg_data IS NOT NULL) THEN
752: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group ';
753: ELSE
754: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group '||SQLERRM;
755: END IF;
756: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
757: RAISE;
758: WHEN OTHERS THEN

Line 768: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group ';

764: RAISE FND_API.G_EXC_ERROR;
765: end if;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF (x_msg_data IS NOT NULL) THEN
768: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group ';
769: ELSE
770: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group '||SQLERRM;
771: END IF;
772: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 770: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group '||SQLERRM;

766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
767: IF (x_msg_data IS NOT NULL) THEN
768: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group ';
769: ELSE
770: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Create_Dim_Levels_In_Group '||SQLERRM;
771: END IF;
772: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
773: RAISE;
774: end Create_Dim_Levels_In_Group;

Line 878: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);

874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875: l_Dim_Grp_Rec_in := p_Dim_Grp_Rec;
876: -- Check that the group id is valid or that the name is valid.
877: if p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id is not null then
878: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
879: if l_count = 0 then
880: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
881: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
882: FND_MSG_PUB.ADD;

Line 1036: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group ';

1032: ROLLBACK TO UpdateBSCDimLevInGrpPVT;
1033: CLOSE c_dim_lvls_by_group;
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: IF (x_msg_data IS NOT NULL) THEN
1036: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group ';
1037: ELSE
1038: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group '||SQLERRM;
1039: END IF;
1040: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1038: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group '||SQLERRM;

1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: IF (x_msg_data IS NOT NULL) THEN
1036: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group ';
1037: ELSE
1038: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group '||SQLERRM;
1039: END IF;
1040: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1041: RAISE;
1042: WHEN OTHERS THEN

Line 1047: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group ';

1043: ROLLBACK TO UpdateBSCDimLevInGrpPVT;
1044: CLOSE c_dim_lvls_by_group;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: IF (x_msg_data IS NOT NULL) THEN
1047: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group ';
1048: ELSE
1049: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group '||SQLERRM;
1050: END IF;
1051: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1049: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group '||SQLERRM;

1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: IF (x_msg_data IS NOT NULL) THEN
1047: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group ';
1048: ELSE
1049: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Update_Dim_Levels_In_Group '||SQLERRM;
1050: END IF;
1051: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1052: RAISE;
1053: end Update_Dim_Levels_In_Group;

Line 1086: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);

1082: l_Dim_Grp_Rec := p_Dim_Grp_Rec;
1083:
1084: -- Check that the group id is valid or that the name is valid.
1085: if l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id is not null then
1086: l_count := BSC_DIMENSION_GROUPS_PVT.Validate_Dim_Group_Id(l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
1087: if l_count = 0 then
1088: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_ID');
1089: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
1090: FND_MSG_PUB.ADD;

Line 1182: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group ';

1178: CLOSE c_dim_lvls_by_group;
1179: ROLLBACK TO DeleteBSCDimLevInGrpPVT;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: IF (x_msg_data IS NOT NULL) THEN
1182: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group ';
1183: ELSE
1184: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group '||SQLERRM;
1185: END IF;
1186: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1184: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group '||SQLERRM;

1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1181: IF (x_msg_data IS NOT NULL) THEN
1182: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group ';
1183: ELSE
1184: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group '||SQLERRM;
1185: END IF;
1186: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1187: RAISE;
1188: WHEN OTHERS THEN

Line 1193: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group ';

1189: CLOSE c_dim_lvls_by_group;
1190: ROLLBACK TO DeleteBSCDimLevInGrpPVT;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF (x_msg_data IS NOT NULL) THEN
1193: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group ';
1194: ELSE
1195: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group '||SQLERRM;
1196: END IF;
1197: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1195: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group '||SQLERRM;

1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF (x_msg_data IS NOT NULL) THEN
1193: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group ';
1194: ELSE
1195: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Delete_Dim_Levels_In_Group '||SQLERRM;
1196: END IF;
1197: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1198: RAISE;
1199: end Delete_Dim_Levels_In_Group;

Line 1294: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group ';

1290: WHEN NO_DATA_FOUND THEN
1291: ROLLBACK TO TranslateBSCDimGrpPVT;
1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: IF (x_msg_data IS NOT NULL) THEN
1294: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group ';
1295: ELSE
1296: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group '||SQLERRM;
1297: END IF;
1298: RAISE;

Line 1296: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group '||SQLERRM;

1292: x_return_status := FND_API.G_RET_STS_ERROR;
1293: IF (x_msg_data IS NOT NULL) THEN
1294: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group ';
1295: ELSE
1296: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group '||SQLERRM;
1297: END IF;
1298: RAISE;
1299: WHEN OTHERS THEN
1300: ROLLBACK TO TranslateBSCDimGrpPVT;

Line 1303: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group ';

1299: WHEN OTHERS THEN
1300: ROLLBACK TO TranslateBSCDimGrpPVT;
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: IF (x_msg_data IS NOT NULL) THEN
1303: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group ';
1304: ELSE
1305: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group '||SQLERRM;
1306: END IF;
1307: RAISE;

Line 1305: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group '||SQLERRM;

1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1302: IF (x_msg_data IS NOT NULL) THEN
1303: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group ';
1304: ELSE
1305: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Translate_Dimension_Group '||SQLERRM;
1306: END IF;
1307: RAISE;
1308:
1309: END Translate_Dimension_Group;

Line 1350: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group ';

1346: );
1347: WHEN NO_DATA_FOUND THEN
1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group ';
1351: ELSE
1352: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group '||SQLERRM;
1353: END IF;
1354: RAISE FND_API.G_EXC_ERROR;

Line 1352: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group '||SQLERRM;

1348: x_return_status := FND_API.G_RET_STS_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group ';
1351: ELSE
1352: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group '||SQLERRM;
1353: END IF;
1354: RAISE FND_API.G_EXC_ERROR;
1355: WHEN OTHERS THEN
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1358: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group ';

1354: RAISE FND_API.G_EXC_ERROR;
1355: WHEN OTHERS THEN
1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1357: IF (x_msg_data IS NOT NULL) THEN
1358: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group ';
1359: ELSE
1360: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group '||SQLERRM;
1361: END IF;
1362:

Line 1360: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group '||SQLERRM;

1356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1357: IF (x_msg_data IS NOT NULL) THEN
1358: x_msg_data := x_msg_data||' -> BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group ';
1359: ELSE
1360: x_msg_data := 'BSC_DIMENSION_GROUPS_PVT.Retrieve_Dim_Group '||SQLERRM;
1361: END IF;
1362:
1363: END Retrieve_Dim_Group;
1364:

Line 1428: end BSC_DIMENSION_GROUPS_PVT;

1424: END Translate_Dim_by_given_lang;
1425:
1426: /******************************************************************************/
1427:
1428: end BSC_DIMENSION_GROUPS_PVT;