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_PMF_UI_API_PUB dependencies on FND_MSG_PUB

Line 84: FND_MSG_PUB.ADD;

80:
81: if p_Bsc_Pmf_Ui_Rec.Kpi_Id is null then
82: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
83: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Pmf_Ui_Rec.Kpi_Id);
84: FND_MSG_PUB.ADD;
85: RAISE FND_API.G_EXC_ERROR;
86: end if;
87:
88: g_Bsc_Pmf_Ui_Rec.Kpi_Id := p_Bsc_Pmf_Ui_Rec.Kpi_Id;

Line 149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

145: -- level, else raise.
146: if(g_invalid_level is not null) then
147: x_bad_level := g_invalid_level;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
150: ,p_data => x_msg_data);
151: else
152: x_bad_level := null;
153: x_return_status := FND_API.G_RET_STS_ERROR;

Line 154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

150: ,p_data => x_msg_data);
151: else
152: x_bad_level := null;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
155: ,p_data => x_msg_data);
156: raise;
157: end if;
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 161: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

157: end if;
158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
159: rollback;
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
162: ,p_data => x_msg_data);
163: raise;
164: WHEN NO_DATA_FOUND THEN
165: rollback;

Line 167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

163: raise;
164: WHEN NO_DATA_FOUND THEN
165: rollback;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
168: ,p_data => x_msg_data);
169: raise;
170: WHEN OTHERS THEN
171: rollback;

Line 173: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

169: raise;
170: WHEN OTHERS THEN
171: rollback;
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
174: ,p_data => x_msg_data);
175: raise;
176:
177: end Bsc_Pmf_Ui_Api;

Line 195: FND_MSG_PUB.ADD;

191:
192: if p_Bsc_Pmf_Ui_Rec.Measure_Short_Name is null then
193: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SHORT_NAME');
194: FND_MESSAGE.SET_TOKEN('BSC_SHORT_NAME', p_Bsc_Pmf_Ui_Rec.Measure_Short_Name);
195: FND_MSG_PUB.ADD;
196: RAISE FND_API.G_EXC_ERROR;
197: end if;
198:
199: g_Bsc_Pmf_Ui_Rec.Measure_Short_Name := p_Bsc_Pmf_Ui_Rec.Measure_Short_Name;

Line 215: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: rollback;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
216: ,p_data => x_msg_data);
217: raise;
218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
219: rollback;

Line 221: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

217: raise;
218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
219: rollback;
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
222: ,p_data => x_msg_data);
223: raise;
224: WHEN NO_DATA_FOUND THEN
225: rollback;

Line 227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

223: raise;
224: WHEN NO_DATA_FOUND THEN
225: rollback;
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
228: ,p_data => x_msg_data);
229: raise;
230: WHEN OTHERS THEN
231: rollback;

Line 233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

229: raise;
230: WHEN OTHERS THEN
231: rollback;
232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
234: ,p_data => x_msg_data);
235: raise;
236:
237: end Get_Measure_Long_Name;

Line 264: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

260: EXCEPTION
261: WHEN FND_API.G_EXC_ERROR THEN
262: rollback;
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
265: ,p_data => x_msg_data);
266: raise;
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: rollback;

Line 270: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

266: raise;
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: rollback;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
271: ,p_data => x_msg_data);
272: raise;
273: WHEN NO_DATA_FOUND THEN
274: rollback;

Line 276: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

272: raise;
273: WHEN NO_DATA_FOUND THEN
274: rollback;
275: x_return_status := FND_API.G_RET_STS_ERROR;
276: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
277: ,p_data => x_msg_data);
278: raise;
279: WHEN OTHERS THEN
280: rollback;

Line 282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

278: raise;
279: WHEN OTHERS THEN
280: rollback;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
283: ,p_data => x_msg_data);
284: raise;
285:
286: end Get_Dimension_Long_Name;

Line 308: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

304: EXCEPTION
305: WHEN FND_API.G_EXC_ERROR THEN
306: rollback;
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
309: ,p_data => x_msg_data);
310: raise;
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: rollback;

Line 314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

310: raise;
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: rollback;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
315: ,p_data => x_msg_data);
316: raise;
317: WHEN NO_DATA_FOUND THEN
318: rollback;

Line 320: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

316: raise;
317: WHEN NO_DATA_FOUND THEN
318: rollback;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
321: ,p_data => x_msg_data);
322: raise;
323: WHEN OTHERS THEN
324: rollback;

Line 326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

322: raise;
323: WHEN OTHERS THEN
324: rollback;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
327: ,p_data => x_msg_data);
328: raise;
329:
330: end Get_Dimension_Level_Name;

Line 497: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

493: EXCEPTION
494: WHEN FND_API.G_EXC_ERROR THEN
495: rollback;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
498: ,p_data => x_msg_data);
499: raise;
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: rollback;

Line 503: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

499: raise;
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: rollback;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
504: ,p_data => x_msg_data);
505: raise;
506: WHEN NO_DATA_FOUND THEN
507: rollback;

Line 509: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

505: raise;
506: WHEN NO_DATA_FOUND THEN
507: rollback;
508: x_return_status := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
510: ,p_data => x_msg_data);
511: raise;
512: WHEN OTHERS THEN
513: rollback;

Line 517: FND_MSG_PUB.ADD;

513: rollback;
514: if g_invalid_level is not null then
515: FND_MESSAGE.SET_NAME('BSC','BSC_UNAVAILABLE_LEVEL');
516: FND_MESSAGE.SET_TOKEN('BSC_LEVEL', g_invalid_level);
517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: else
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 521: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

517: FND_MSG_PUB.ADD;
518: RAISE FND_API.G_EXC_ERROR;
519: else
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
522: ,p_data => x_msg_data);
523: raise;
524: end if;
525:

Line 622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: rollback;
621: x_return_status := FND_API.G_RET_STS_ERROR;
622: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
623: ,p_data => x_msg_data);
624: raise;
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: rollback;

Line 628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

624: raise;
625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
626: rollback;
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
629: ,p_data => x_msg_data);
630: raise;
631: WHEN NO_DATA_FOUND THEN
632: rollback;

Line 634: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

630: raise;
631: WHEN NO_DATA_FOUND THEN
632: rollback;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
635: ,p_data => x_msg_data);
636: raise;
637: WHEN OTHERS THEN
638: rollback;

Line 640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

636: raise;
637: WHEN OTHERS THEN
638: rollback;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
641: ,p_data => x_msg_data);
642: raise;
643:
644: end Create_Bsc_Dimension;

Line 730: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

726: CLOSE c_language;
727: END IF;
728: rollback;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
731: ,p_data => x_msg_data);
732: raise;
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: IF (c_language%ISOPEN) THEN

Line 740: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

736: END IF;
737:
738: rollback;
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
740: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
741: ,p_data => x_msg_data);
742: raise;
743: WHEN NO_DATA_FOUND THEN
744: IF (c_language%ISOPEN) THEN

Line 750: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

746: END IF;
747:
748: rollback;
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
751: ,p_data => x_msg_data);
752: raise;
753: WHEN OTHERS THEN
754: IF (c_language%ISOPEN) THEN

Line 759: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

755: CLOSE c_language;
756: END IF;
757: rollback;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
760: ,p_data => x_msg_data);
761: raise;
762:
763: END Update_Bsc_Dataset;

Line 814: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: rollback;
813: x_return_status := FND_API.G_RET_STS_ERROR;
814: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
815: ,p_data => x_msg_data);
816: raise;
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: rollback;

Line 820: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

816: raise;
817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
818: rollback;
819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
820: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
821: ,p_data => x_msg_data);
822: raise;
823: WHEN NO_DATA_FOUND THEN
824: rollback;

Line 826: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

822: raise;
823: WHEN NO_DATA_FOUND THEN
824: rollback;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
827: ,p_data => x_msg_data);
828: raise;
829: WHEN OTHERS THEN
830: rollback;

Line 832: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

828: raise;
829: WHEN OTHERS THEN
830: rollback;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
833: ,p_data => x_msg_data);
834: raise;
835:
836: end Create_Bsc_Dataset;

Line 930: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

926: EXCEPTION
927: WHEN FND_API.G_EXC_ERROR THEN
928: rollback;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
931: ,p_data => x_msg_data);
932: raise;
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: rollback;

Line 936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

932: raise;
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: rollback;
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
937: ,p_data => x_msg_data);
938: raise;
939: WHEN NO_DATA_FOUND THEN
940: rollback;

Line 942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

938: raise;
939: WHEN NO_DATA_FOUND THEN
940: rollback;
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
943: ,p_data => x_msg_data);
944: raise;
945: WHEN OTHERS THEN
946: rollback;

Line 948: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

944: raise;
945: WHEN OTHERS THEN
946: rollback;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
949: ,p_data => x_msg_data);
950: raise;
951:
952: end Create_Bsc_Dimension_Set;

Line 1057: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: rollback;
1056: x_return_status := FND_API.G_RET_STS_ERROR;
1057: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1058: ,p_data => x_msg_data);
1059: raise;
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: rollback;

Line 1063: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1059: raise;
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: rollback;
1062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1064: ,p_data => x_msg_data);
1065: raise;
1066: WHEN NO_DATA_FOUND THEN
1067: rollback;

Line 1069: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1065: raise;
1066: WHEN NO_DATA_FOUND THEN
1067: rollback;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1070: ,p_data => x_msg_data);
1071: raise;
1072: WHEN OTHERS THEN
1073: rollback;

Line 1075: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1071: raise;
1072: WHEN OTHERS THEN
1073: rollback;
1074: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1075: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1076: ,p_data => x_msg_data);
1077: raise;
1078:
1079: end Create_Bsc_Analysis_Option;

Line 1184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1180: EXCEPTION
1181: WHEN FND_API.G_EXC_ERROR THEN
1182: rollback;
1183: x_return_status := FND_API.G_RET_STS_ERROR;
1184: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1185: ,p_data => x_msg_data);
1186: raise;
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: rollback;

Line 1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1186: raise;
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: rollback;
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1191: ,p_data => x_msg_data);
1192: raise;
1193: WHEN NO_DATA_FOUND THEN
1194: rollback;

Line 1196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1192: raise;
1193: WHEN NO_DATA_FOUND THEN
1194: rollback;
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1197: ,p_data => x_msg_data);
1198: raise;
1199: WHEN OTHERS THEN
1200: rollback;

Line 1202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1198: raise;
1199: WHEN OTHERS THEN
1200: rollback;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1203: ,p_data => x_msg_data);
1204: raise;
1205:
1206: end Import_PMF_Dim_Level;

Line 1328: FND_MSG_PUB.ADD;

1324: -- Included to fixed bug 2382059
1325: IF (NOT BSC_UTILITY.is_Table_View_Exists(x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name)) THEN
1326: FND_MESSAGE.SET_NAME('BSC','BSC_PMF_LEVEL_NOT_EXISTS');
1327: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_NAME', x_Bsc_Pmf_Dim_Rec.Dimension_Level_View_Name);
1328: FND_MSG_PUB.ADD;
1329: RAISE FND_API.G_EXC_ERROR;
1330: END IF;
1331: -- Included to fixed bug 2382059
1332:

Line 1358: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1354: EXCEPTION
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: rollback;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1359: ,p_data => x_msg_data);
1360: raise;
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: rollback;

Line 1364: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1360: raise;
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: rollback;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1365: ,p_data => x_msg_data);
1366:
1367: raise;
1368: WHEN NO_DATA_FOUND THEN

Line 1371: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1367: raise;
1368: WHEN NO_DATA_FOUND THEN
1369: rollback;
1370: x_return_status := FND_API.G_RET_STS_ERROR;
1371: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1372: ,p_data => x_msg_data);
1373: raise;
1374: WHEN OTHERS THEN
1375: rollback;

Line 1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1373: raise;
1374: WHEN OTHERS THEN
1375: rollback;
1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1378: ,p_data => x_msg_data);
1379: raise;
1380:
1381:

Line 1665: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1661: EXCEPTION
1662: WHEN FND_API.G_EXC_ERROR THEN
1663: rollback;
1664: x_return_status := FND_API.G_RET_STS_ERROR;
1665: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1666: ,p_data => x_msg_data);
1667: raise;
1668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1669: rollback;

Line 1671: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1667: raise;
1668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1669: rollback;
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1671: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1672: ,p_data => x_msg_data);
1673:
1674: raise;
1675: WHEN NO_DATA_FOUND THEN

Line 1678: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1674: raise;
1675: WHEN NO_DATA_FOUND THEN
1676: rollback;
1677: x_return_status := FND_API.G_RET_STS_ERROR;
1678: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1679: ,p_data => x_msg_data);
1680: raise;
1681: WHEN OTHERS THEN
1682: rollback;

Line 1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1680: raise;
1681: WHEN OTHERS THEN
1682: rollback;
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1685: ,p_data => x_msg_data);
1686: raise;
1687:
1688: end Get_DimLevel_Viewby;