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 FND_MSG_PUB

Line 93: FND_MSG_PUB.Initialize;

89: l_dim_level_short_name varchar2(30);
90:
91: begin
92: SAVEPOINT CreateBSCDimGrpPVT;
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);

Line 101: FND_MSG_PUB.ADD;

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;
102: RAISE FND_API.G_EXC_ERROR;
103: end if;
104: else
105: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');

Line 107: FND_MSG_PUB.ADD;

103: end if;
104: else
105: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');
106: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
107: FND_MSG_PUB.ADD;
108: RAISE FND_API.G_EXC_ERROR;
109: end if;
110:
111: -- Assign all values in the passed "Record" parameter to the locally defined

Line 174: FND_MSG_PUB.Count_And_Get

170:
171: EXCEPTION
172: WHEN FND_API.G_EXC_ERROR THEN
173: ROLLBACK TO CreateBSCDimGrpPVT;
174: FND_MSG_PUB.Count_And_Get
175: ( p_encoded => 'F'
176: , p_count => x_msg_count
177: , p_data => x_msg_data
178: );

Line 184: FND_MSG_PUB.Count_And_Get

180: x_return_status := FND_API.G_RET_STS_ERROR;
181: RAISE;
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO CreateBSCDimGrpPVT;
184: FND_MSG_PUB.Count_And_Get
185: ( p_encoded => 'F'
186: , p_count => x_msg_count
187: , p_data => x_msg_data
188: );

Line 208: FND_MSG_PUB.ADD;

204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: if (SQLCODE = -01400) then
206: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
207: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
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 ';

Line 235: FND_MSG_PUB.Initialize;

231:
232: begin
233:
234: g_db_object := 'Retrieve_Dimension_Group';
235: FND_MSG_PUB.Initialize;
236: x_return_status := FND_API.G_RET_STS_SUCCESS;
237: select distinct name
238: into x_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name
239: from BSC_SYS_DIM_GROUPS_VL

Line 248: FND_MSG_PUB.Count_And_Get

244: end if;
245:
246: EXCEPTION
247: WHEN FND_API.G_EXC_ERROR THEN
248: FND_MSG_PUB.Count_And_Get
249: ( p_encoded => 'F'
250: , p_count => x_msg_count
251: , p_data => x_msg_data
252: );

Line 257: FND_MSG_PUB.Count_And_Get

253: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: RAISE;
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: FND_MSG_PUB.Count_And_Get
258: ( p_encoded => 'F'
259: , p_count => x_msg_count
260: , p_data => x_msg_data
261: );

Line 307: FND_MSG_PUB.Initialize;

303: WHERE SHORT_NAME = p_grp_short_name;
304:
305: begin
306: SAVEPOINT UpdateBSCDimGrpPVT;
307: FND_MSG_PUB.Initialize;
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309: -- Assign all values in the passed "Record" parameter to the locally defined
310: -- "Record" variable.
311: l_Dim_Grp_Rec := p_Dim_Grp_Rec;

Line 319: FND_MSG_PUB.ADD;

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;
320: RAISE FND_API.G_EXC_ERROR;
321: end if;
322: -- if id is null then check for short name name is not null
323: elsif (l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name is not null) then

Line 332: FND_MSG_PUB.ADD;

328: FETCH c_dim_lvls_by_group INTO l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
329: IF (c_dim_lvls_by_group%NOTFOUND) THEN
330: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
331: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME',l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name);
332: FND_MSG_PUB.ADD;
333: RAISE FND_API.G_EXC_ERROR;
334: END IF;
335: CLOSE c_dim_lvls_by_group;
336: else

Line 339: FND_MSG_PUB.ADD;

335: CLOSE c_dim_lvls_by_group;
336: else
337: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_ID_ENTERED');
338: FND_MESSAGE.SET_TOKEN('BSC_GROUP_ID', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id);
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: end if;
342:
343: -- In this case there is only one column that may be updated, therefore there is no

Line 378: FND_MSG_PUB.Count_And_Get

374: IF (c_dim_lvls_by_group%ISOPEN) THEN
375: CLOSE c_dim_lvls_by_group;
376: END IF;
377: ROLLBACK TO UpdateBSCDimGrpPVT;
378: FND_MSG_PUB.Count_And_Get
379: ( p_encoded => 'F'
380: , p_count => x_msg_count
381: , p_data => x_msg_data
382: );

Line 391: FND_MSG_PUB.Count_And_Get

387: IF (c_dim_lvls_by_group%ISOPEN) THEN
388: CLOSE c_dim_lvls_by_group;
389: END IF;
390: ROLLBACK TO UpdateBSCDimGrpPVT;
391: FND_MSG_PUB.Count_And_Get
392: ( p_encoded => 'F'
393: , p_count => x_msg_count
394: , p_data => x_msg_data
395: );

Line 450: FND_MSG_PUB.Initialize;

446: WHERE SHORT_NAME = p_grp_short_name;
447:
448: begin
449: SAVEPOINT DeleteBSCDimGrpPVT;
450: FND_MSG_PUB.Initialize;
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452: -- Assign all values in the passed "Record" parameter to the locally defined
453: -- "Record" variable.
454: l_Dim_Grp_Rec := p_Dim_Grp_Rec;

Line 461: FND_MSG_PUB.ADD;

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;
462: RAISE FND_API.G_EXC_ERROR;
463: end if;
464: -- if id is null then check that short name is not null
465: elsif (l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name is not null) then

Line 474: FND_MSG_PUB.ADD;

470: FETCH c_dim_lvls_by_group INTO l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
471: IF (c_dim_lvls_by_group%NOTFOUND) THEN
472: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
473: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME',l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name);
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477: CLOSE c_dim_lvls_by_group;
478: else

Line 488: FND_MSG_PUB.ADD;

484: where name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
485: if l_count = 0 then
486: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
487: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
488: FND_MSG_PUB.ADD;
489: RAISE FND_API.G_EXC_ERROR;
490: else -- get id for this name
491: select distinct dim_group_id
492: into l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id

Line 499: FND_MSG_PUB.ADD;

495: end if;
496: else
497: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_NAME_ENTERED');
498: FND_MESSAGE.SET_TOKEN('BSC_NO_GROUP', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
499: FND_MSG_PUB.ADD;
500: RAISE FND_API.G_EXC_ERROR;
501: end if;
502: end if;
503:

Line 525: FND_MSG_PUB.Count_And_Get

521: IF (c_dim_lvls_by_group%ISOPEN) THEN
522: CLOSE c_dim_lvls_by_group;
523: END IF;
524: ROLLBACK TO DeleteBSCDimGrpPVT;
525: FND_MSG_PUB.Count_And_Get
526: ( p_encoded => 'F'
527: , p_count => x_msg_count
528: , p_data => x_msg_data
529: );

Line 538: FND_MSG_PUB.Count_And_Get

534: IF (c_dim_lvls_by_group%ISOPEN) THEN
535: CLOSE c_dim_lvls_by_group;
536: END IF;
537: ROLLBACK TO DeleteBSCDimGrpPVT;
538: FND_MSG_PUB.Count_And_Get
539: ( p_encoded => 'F'
540: , p_count => x_msg_count
541: , p_data => x_msg_data
542: );

Line 600: FND_MSG_PUB.Initialize;

596: WHERE SHORT_NAME = p_grp_short_name;
597:
598: begin
599: SAVEPOINT CreateBSCDimLevInGrpPVT;
600: FND_MSG_PUB.Initialize;
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602: -- Assign all values in the passed "Record" parameter to the locally defined
603: -- "Record" variable.
604: l_Dim_Grp_Rec := p_Dim_Grp_Rec;

Line 612: FND_MSG_PUB.ADD;

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;
613: RAISE FND_API.G_EXC_ERROR;
614: end if;
615: -- if id is null then check that short name is not null
616: elsif l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name is not null then

Line 625: FND_MSG_PUB.ADD;

621: FETCH c_dim_lvls_by_group INTO l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
622: IF (c_dim_lvls_by_group%NOTFOUND) THEN
623: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
624: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME',l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name);
625: FND_MSG_PUB.ADD;
626: RAISE FND_API.G_EXC_ERROR;
627: END IF;
628: CLOSE c_dim_lvls_by_group;
629: else

Line 639: FND_MSG_PUB.ADD;

635: where name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
636: if l_count = 0 then
637: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
638: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_ERROR;
641: else -- get id for this name
642: select distinct dim_group_id
643: into l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id

Line 650: FND_MSG_PUB.ADD;

646: end if;
647: else
648: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_NAME_ENTERED');
649: FND_MESSAGE.SET_TOKEN('BSC_NO_GROUP', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: end if;
653: end if;
654:

Line 661: FND_MSG_PUB.ADD;

657: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Dim_Level_Id(l_Dim_Grp_Rec.Bsc_Level_Id);
658: if l_count = 0 then
659: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
660: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', l_Dim_Grp_Rec.Bsc_Level_Id);
661: FND_MSG_PUB.ADD;
662: RAISE FND_API.G_EXC_ERROR;
663: end if;
664: else
665: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 667: FND_MSG_PUB.ADD;

663: end if;
664: else
665: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
666: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', l_Dim_Grp_Rec.Bsc_Level_Id);
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: end if;
670:
671:

Line 730: FND_MSG_PUB.Count_And_Get

726:
727: EXCEPTION
728: WHEN FND_API.G_EXC_ERROR THEN
729: ROLLBACK TO CreateBSCDimLevInGrpPVT;
730: FND_MSG_PUB.Count_And_Get
731: ( p_encoded => 'F'
732: , p_count => x_msg_count
733: , p_data => x_msg_data
734: );

Line 740: FND_MSG_PUB.Count_And_Get

736: x_return_status := FND_API.G_RET_STS_ERROR;
737: RAISE;
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: ROLLBACK TO CreateBSCDimLevInGrpPVT;
740: FND_MSG_PUB.Count_And_Get
741: ( p_encoded => 'F'
742: , p_count => x_msg_count
743: , p_data => x_msg_data
744: );

Line 763: FND_MSG_PUB.ADD;

759: ROLLBACK TO CreateBSCDimLevInGrpPVT;
760: if (SQLCODE = -01400) then
761: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
762: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
763: FND_MSG_PUB.ADD;
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

Line 791: FND_MSG_PUB.Initialize;

787:
788: begin
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791: FND_MSG_PUB.Initialize;
792: g_db_object := 'Retrieve_Dim_Levels_In_Group';
793: -- Code added for ALL start here
794: -- PMF passes dimension level short name and dimension short name.
795: -- dim_level_id is found from bsc_sys_dim_levels_tl table.

Line 830: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
831: ,p_data => x_msg_data);
832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 834: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

830: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
831: ,p_data => x_msg_data);
832: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
835: ,p_data => x_msg_data);
836: WHEN NO_DATA_FOUND THEN
837: FND_MSG_PUB.Initialize;
838: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');

Line 837: FND_MSG_PUB.Initialize;

833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
835: ,p_data => x_msg_data);
836: WHEN NO_DATA_FOUND THEN
837: FND_MSG_PUB.Initialize;
838: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
839: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_ERROR;

Line 840: FND_MSG_PUB.ADD;

836: WHEN NO_DATA_FOUND THEN
837: FND_MSG_PUB.Initialize;
838: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
839: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_ERROR;
842: WHEN OTHERS THEN
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 844: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

840: FND_MSG_PUB.ADD;
841: RAISE FND_API.G_EXC_ERROR;
842: WHEN OTHERS THEN
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
845: ,p_data => x_msg_data);
846:
847: end Retrieve_Dim_Levels_In_Group;
848:

Line 873: FND_MSG_PUB.Initialize;

869: WHERE SHORT_NAME = p_grp_short_name;
870:
871: begin
872: SAVEPOINT UpdateBSCDimLevInGrpPVT;
873: FND_MSG_PUB.Initialize;
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

Line 882: FND_MSG_PUB.ADD;

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;
883: RAISE FND_API.G_EXC_ERROR;
884: end if;
885: -- if id is null then check that short name is not null
886: elsif p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name is not null then

Line 895: FND_MSG_PUB.ADD;

891: FETCH c_dim_lvls_by_group INTO l_Dim_Grp_Rec_in.Bsc_Dim_Level_Group_Id;
892: IF (c_dim_lvls_by_group%NOTFOUND) THEN
893: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
894: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME',l_Dim_Grp_Rec_in.Bsc_Dim_Level_Group_Short_Name);
895: FND_MSG_PUB.ADD;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898: CLOSE c_dim_lvls_by_group;
899: else

Line 909: FND_MSG_PUB.ADD;

905: where name = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
906: if l_count = 0 then
907: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
908: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
909: FND_MSG_PUB.ADD;
910: RAISE FND_API.G_EXC_ERROR;
911: else -- get id for this name
912: select distinct dim_group_id
913: into l_Dim_Grp_Rec_in.Bsc_Dim_Level_Group_Id

Line 920: FND_MSG_PUB.ADD;

916: end if;
917: else
918: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_NAME_ENTERED');
919: FND_MESSAGE.SET_TOKEN('BSC_NO_GROUP', p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
920: FND_MSG_PUB.ADD;
921: RAISE FND_API.G_EXC_ERROR;
922: end if;
923: end if;
924:

Line 931: FND_MSG_PUB.ADD;

927: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Dim_Level_Id(p_Dim_Grp_Rec.Bsc_Level_Id);
928: if l_count = 0 then
929: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
930: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Grp_Rec.Bsc_Level_Id);
931: FND_MSG_PUB.ADD;
932: RAISE FND_API.G_EXC_ERROR;
933: end if;
934: else
935: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');

Line 937: FND_MSG_PUB.ADD;

933: end if;
934: else
935: FND_MESSAGE.SET_NAME('BSC','BSC_NO_LEVEL_ID_ENTERED');
936: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Grp_Rec.Bsc_Level_Id);
937: FND_MSG_PUB.ADD;
938: RAISE FND_API.G_EXC_ERROR;
939: end if;
940:
941: -- Not all values will be passed. We need to make sure values not passed are not

Line 1012: FND_MSG_PUB.Count_And_Get

1008: EXCEPTION
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: ROLLBACK TO UpdateBSCDimLevInGrpPVT;
1011: CLOSE c_dim_lvls_by_group;
1012: FND_MSG_PUB.Count_And_Get
1013: ( p_encoded => 'F'
1014: , p_count => x_msg_count
1015: , p_data => x_msg_data
1016: );

Line 1023: FND_MSG_PUB.Count_And_Get

1019: RAISE;
1020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1021: ROLLBACK TO UpdateBSCDimLevInGrpPVT;
1022: CLOSE c_dim_lvls_by_group;
1023: FND_MSG_PUB.Count_And_Get
1024: ( p_encoded => 'F'
1025: , p_count => x_msg_count
1026: , p_data => x_msg_data
1027: );

Line 1078: FND_MSG_PUB.Initialize;

1074: WHERE SHORT_NAME = p_grp_short_name;
1075:
1076: begin
1077: SAVEPOINT DeleteBSCDimLevInGrpPVT;
1078: FND_MSG_PUB.Initialize;
1079: x_return_status := FND_API.G_RET_STS_SUCCESS;
1080: -- Assign all values in the passed "Record" parameter to the locally defined
1081: -- "Record" variable.
1082: l_Dim_Grp_Rec := p_Dim_Grp_Rec;

Line 1090: FND_MSG_PUB.ADD;

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;
1091: RAISE FND_API.G_EXC_ERROR;
1092: end if;
1093: -- if id is null then check for short name name is not null
1094: elsif l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name is not null then

Line 1103: FND_MSG_PUB.ADD;

1099: FETCH c_dim_lvls_by_group INTO l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id;
1100: IF (c_dim_lvls_by_group%NOTFOUND) THEN
1101: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_SHORT_NAME');
1102: FND_MESSAGE.SET_TOKEN('BSC_GROUP_SHORT_NAME',l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Short_Name);
1103: FND_MSG_PUB.ADD;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106: CLOSE c_dim_lvls_by_group;
1107: else

Line 1117: FND_MSG_PUB.ADD;

1113: where name = l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name;
1114: if l_count = 0 then
1115: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_GROUP_NAME');
1116: FND_MESSAGE.SET_TOKEN('BSC_GROUP_NAME', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
1117: FND_MSG_PUB.ADD;
1118: RAISE FND_API.G_EXC_ERROR;
1119: else -- get id for this name
1120: select distinct dim_group_id
1121: into l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Id

Line 1128: FND_MSG_PUB.ADD;

1124: end if;
1125: else
1126: FND_MESSAGE.SET_NAME('BSC','BSC_NO_GROUP_NAME_ENTERED');
1127: FND_MESSAGE.SET_TOKEN('BSC_NO_GROUP', l_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name);
1128: FND_MSG_PUB.ADD;
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;
1131: end if;
1132:

Line 1139: FND_MSG_PUB.ADD;

1135: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Dim_Level_Id(l_Dim_Grp_Rec.Bsc_Level_Id);
1136: if l_count = 0 then
1137: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1138: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', l_Dim_Grp_Rec.Bsc_Level_Id);
1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_ERROR;
1141: end if;
1142:
1143: delete from BSC_SYS_DIM_LEVELS_BY_GROUP

Line 1158: FND_MSG_PUB.Count_And_Get

1154: EXCEPTION
1155: WHEN FND_API.G_EXC_ERROR THEN
1156: CLOSE c_dim_lvls_by_group;
1157: ROLLBACK TO DeleteBSCDimLevInGrpPVT;
1158: FND_MSG_PUB.Count_And_Get
1159: ( p_encoded => 'F'
1160: , p_count => x_msg_count
1161: , p_data => x_msg_data
1162: );

Line 1169: FND_MSG_PUB.Count_And_Get

1165: RAISE;
1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1167: CLOSE c_dim_lvls_by_group;
1168: ROLLBACK TO DeleteBSCDimLevInGrpPVT;
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_encoded => 'F'
1171: , p_count => x_msg_count
1172: , p_data => x_msg_data
1173: );

Line 1274: FND_MSG_PUB.Count_And_Get(

1270:
1271: EXCEPTION
1272: WHEN FND_API.G_EXC_ERROR THEN
1273: ROLLBACK TO TranslateBSCDimGrpPVT;
1274: FND_MSG_PUB.Count_And_Get(
1275: p_encoded => 'F'
1276: ,p_count => x_msg_count
1277: ,p_data => x_msg_data
1278: );

Line 1283: FND_MSG_PUB.Count_And_Get(

1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: RAISE;
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: ROLLBACK TO TranslateBSCDimGrpPVT;
1283: FND_MSG_PUB.Count_And_Get(
1284: p_encoded => 'F'
1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data
1287: );

Line 1335: FND_MSG_PUB.Count_And_Get(

1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: FND_MSG_PUB.Count_And_Get(
1336: p_encoded => 'F'
1337: ,p_count => x_msg_count
1338: ,p_data => x_msg_data
1339: );

Line 1342: FND_MSG_PUB.Count_And_Get(

1338: ,p_data => x_msg_data
1339: );
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: FND_MSG_PUB.Count_And_Get(
1343: p_encoded => 'F'
1344: ,p_count => x_msg_count
1345: ,p_data => x_msg_data
1346: );

Line 1388: FND_MSG_PUB.Initialize;

1384: SAVEPOINT TransDimByLangBsc;
1385:
1386: x_return_status := FND_API.G_RET_STS_SUCCESS;
1387:
1388: FND_MSG_PUB.Initialize;
1389:
1390: UPDATE BSC_SYS_DIM_GROUPS_TL
1391: SET NAME = p_Dim_Grp_Rec.Bsc_Dim_Level_Group_Name
1392: ,SOURCE_LANG = p_Dim_Grp_Rec.Bsc_Source_Language

Line 1406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1402: EXCEPTION
1403: WHEN FND_API.G_EXC_ERROR THEN
1404: ROLLBACK TO TransDimByLangBsc;
1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1407: ,p_data => x_msg_data);
1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO TransDimByLangBsc;

Line 1412: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO TransDimByLangBsc;
1411: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1412: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1413: ,p_data => x_msg_data);
1414: WHEN NO_DATA_FOUND THEN
1415: ROLLBACK TO TransDimByLangBsc;
1416: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1413: ,p_data => x_msg_data);
1414: WHEN NO_DATA_FOUND THEN
1415: ROLLBACK TO TransDimByLangBsc;
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1418: ,p_data => x_msg_data);
1419: WHEN OTHERS THEN
1420: ROLLBACK TO TransDimByLangBsc;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1422: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1418: ,p_data => x_msg_data);
1419: WHEN OTHERS THEN
1420: ROLLBACK TO TransDimByLangBsc;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1423: ,p_data => x_msg_data);
1424: END Translate_Dim_by_given_lang;
1425:
1426: /******************************************************************************/