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

Line 157: FND_MSG_PUB.ADD;

153: AND KPI_GROUP.Dim_Set_Id = l_Dim_Set_Rec.Bsc_Dim_Set_Id
154: GROUP BY SYS_DIM_LEL.Dim_Level_Id);
155: IF (l_count > 1) THEN
156: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_COMMON_DIM_OBJS');
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;
160: END IF;
161:

Line 209: FND_MSG_PUB.Count_And_Get

205: END IF;
206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN
208: IF (x_msg_data IS NULL) THEN
209: FND_MSG_PUB.Count_And_Get
210: ( p_encoded => FND_API.G_FALSE
211: , p_count => x_msg_count
212: , p_data => x_msg_data
213: );

Line 219: FND_MSG_PUB.Count_And_Get

215: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
218: IF (x_msg_data IS NULL) THEN
219: FND_MSG_PUB.Count_And_Get
220: ( p_encoded => FND_API.G_FALSE
221: , p_count => x_msg_count
222: , p_data => x_msg_data
223: );

Line 271: FND_MSG_PUB.Count_And_Get

267: END IF;
268: EXCEPTION
269: WHEN FND_API.G_EXC_ERROR THEN
270: IF (x_msg_data IS NULL) THEN
271: FND_MSG_PUB.Count_And_Get
272: ( p_encoded => FND_API.G_FALSE
273: , p_count => x_msg_count
274: , p_data => x_msg_data
275: );

Line 281: FND_MSG_PUB.Count_And_Get

277: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: IF (x_msg_data IS NULL) THEN
281: FND_MSG_PUB.Count_And_Get
282: ( p_encoded => FND_API.G_FALSE
283: , p_count => x_msg_count
284: , p_data => x_msg_data
285: );

Line 358: FND_MSG_PUB.Count_And_Get

354: END IF;
355: EXCEPTION
356: WHEN FND_API.G_EXC_ERROR THEN
357: IF (x_msg_data IS NULL) THEN
358: FND_MSG_PUB.Count_And_Get
359: ( p_encoded => FND_API.G_FALSE
360: , p_count => x_msg_count
361: , p_data => x_msg_data
362: );

Line 368: FND_MSG_PUB.Count_And_Get

364: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: IF (x_msg_data IS NULL) THEN
368: FND_MSG_PUB.Count_And_Get
369: ( p_encoded => FND_API.G_FALSE
370: , p_count => x_msg_count
371: , p_data => x_msg_data
372: );

Line 425: FND_MSG_PUB.ADD;

421: AND KPI_GROUP.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
422: GROUP BY SYS_DIM_LEL.Dim_Level_Id);
423: IF (l_count > 1) THEN
424: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_COMMON_DIM_OBJS');
425: FND_MSG_PUB.ADD;
426: RAISE FND_API.G_EXC_ERROR;
427: END IF;
428: IF (p_create_Dim_Lev_Grp) THEN
429: Update_Bsc_Kpi_Dim_Sets_Tl( p_commit

Line 457: FND_MSG_PUB.Count_And_Get

453: END IF;
454: EXCEPTION
455: WHEN FND_API.G_EXC_ERROR THEN
456: IF (x_msg_data IS NULL) THEN
457: FND_MSG_PUB.Count_And_Get
458: ( p_encoded => FND_API.G_FALSE
459: , p_count => x_msg_count
460: , p_data => x_msg_data
461: );

Line 467: FND_MSG_PUB.Count_And_Get

463: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
464: x_return_status := FND_API.G_RET_STS_ERROR;
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: IF (x_msg_data IS NULL) THEN
467: FND_MSG_PUB.Count_And_Get
468: ( p_encoded => FND_API.G_FALSE
469: , p_count => x_msg_count
470: , p_data => x_msg_data
471: );

Line 517: FND_MSG_PUB.Count_And_Get

513: END IF;
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: IF (x_msg_data IS NULL) THEN
517: FND_MSG_PUB.Count_And_Get
518: ( p_encoded => FND_API.G_FALSE
519: , p_count => x_msg_count
520: , p_data => x_msg_data
521: );

Line 527: FND_MSG_PUB.Count_And_Get

523: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: IF (x_msg_data IS NULL) THEN
527: FND_MSG_PUB.Count_And_Get
528: ( p_encoded => FND_API.G_FALSE
529: , p_count => x_msg_count
530: , p_data => x_msg_data
531: );

Line 684: FND_MSG_PUB.Count_And_Get

680: END IF;
681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN
683: IF (x_msg_data IS NULL) THEN
684: FND_MSG_PUB.Count_And_Get
685: ( p_encoded => FND_API.G_FALSE
686: , p_count => x_msg_count
687: , p_data => x_msg_data
688: );

Line 694: FND_MSG_PUB.Count_And_Get

690: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
693: IF (x_msg_data IS NULL) THEN
694: FND_MSG_PUB.Count_And_Get
695: ( p_encoded => FND_API.G_FALSE
696: , p_count => x_msg_count
697: , p_data => x_msg_data
698: );

Line 747: FND_MSG_PUB.Count_And_Get

743: END IF;
744: EXCEPTION
745: WHEN FND_API.G_EXC_ERROR THEN
746: IF (x_msg_data IS NULL) THEN
747: FND_MSG_PUB.Count_And_Get
748: ( p_encoded => FND_API.G_FALSE
749: , p_count => x_msg_count
750: , p_data => x_msg_data
751: );

Line 757: FND_MSG_PUB.Count_And_Get

753: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
756: IF (x_msg_data IS NULL) THEN
757: FND_MSG_PUB.Count_And_Get
758: ( p_encoded => FND_API.G_FALSE
759: , p_count => x_msg_count
760: , p_data => x_msg_data
761: );

Line 808: FND_MSG_PUB.Count_And_Get

804:
805: EXCEPTION
806: WHEN FND_API.G_EXC_ERROR THEN
807: IF (x_msg_data IS NULL) THEN
808: FND_MSG_PUB.Count_And_Get
809: ( p_encoded => FND_API.G_FALSE
810: , p_count => x_msg_count
811: , p_data => x_msg_data
812: );

Line 818: FND_MSG_PUB.Count_And_Get

814: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
817: IF (x_msg_data IS NULL) THEN
818: FND_MSG_PUB.Count_And_Get
819: ( p_encoded => FND_API.G_FALSE
820: , p_count => x_msg_count
821: , p_data => x_msg_data
822: );

Line 867: FND_MSG_PUB.Count_And_Get

863: ,x_msg_data);
864: EXCEPTION
865: WHEN FND_API.G_EXC_ERROR THEN
866: IF (x_msg_data IS NULL) THEN
867: FND_MSG_PUB.Count_And_Get
868: ( p_encoded => FND_API.G_FALSE
869: , p_count => x_msg_count
870: , p_data => x_msg_data
871: );

Line 877: FND_MSG_PUB.Count_And_Get

873: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
874: x_return_status := FND_API.G_RET_STS_ERROR;
875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
876: IF (x_msg_data IS NULL) THEN
877: FND_MSG_PUB.Count_And_Get
878: ( p_encoded => FND_API.G_FALSE
879: , p_count => x_msg_count
880: , p_data => x_msg_data
881: );

Line 925: FND_MSG_PUB.Count_And_Get

921:
922: EXCEPTION
923: WHEN FND_API.G_EXC_ERROR THEN
924: IF (x_msg_data IS NULL) THEN
925: FND_MSG_PUB.Count_And_Get
926: ( p_encoded => FND_API.G_FALSE
927: , p_count => x_msg_count
928: , p_data => x_msg_data
929: );

Line 935: FND_MSG_PUB.Count_And_Get

931: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
932: x_return_status := FND_API.G_RET_STS_ERROR;
933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
934: IF (x_msg_data IS NULL) THEN
935: FND_MSG_PUB.Count_And_Get
936: ( p_encoded => FND_API.G_FALSE
937: , p_count => x_msg_count
938: , p_data => x_msg_data
939: );

Line 985: FND_MSG_PUB.Count_And_Get

981:
982: EXCEPTION
983: WHEN FND_API.G_EXC_ERROR THEN
984: IF (x_msg_data IS NULL) THEN
985: FND_MSG_PUB.Count_And_Get
986: ( p_encoded => FND_API.G_FALSE
987: , p_count => x_msg_count
988: , p_data => x_msg_data
989: );

Line 995: FND_MSG_PUB.Count_And_Get

991: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
992: x_return_status := FND_API.G_RET_STS_ERROR;
993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
994: IF (x_msg_data IS NULL) THEN
995: FND_MSG_PUB.Count_And_Get
996: ( p_encoded => FND_API.G_FALSE
997: , p_count => x_msg_count
998: , p_data => x_msg_data
999: );

Line 1117: FND_MSG_PUB.Count_And_Get

1113:
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: IF (x_msg_data IS NULL) THEN
1117: FND_MSG_PUB.Count_And_Get
1118: ( p_encoded => FND_API.G_FALSE
1119: , p_count => x_msg_count
1120: , p_data => x_msg_data
1121: );

Line 1127: FND_MSG_PUB.Count_And_Get

1123: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1126: IF (x_msg_data IS NULL) THEN
1127: FND_MSG_PUB.Count_And_Get
1128: ( p_encoded => FND_API.G_FALSE
1129: , p_count => x_msg_count
1130: , p_data => x_msg_data
1131: );

Line 1177: FND_MSG_PUB.Count_And_Get

1173:
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN
1176: IF (x_msg_data IS NULL) THEN
1177: FND_MSG_PUB.Count_And_Get
1178: ( p_encoded => FND_API.G_FALSE
1179: , p_count => x_msg_count
1180: , p_data => x_msg_data
1181: );

Line 1187: FND_MSG_PUB.Count_And_Get

1183: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: IF (x_msg_data IS NULL) THEN
1187: FND_MSG_PUB.Count_And_Get
1188: ( p_encoded => FND_API.G_FALSE
1189: , p_count => x_msg_count
1190: , p_data => x_msg_data
1191: );

Line 1235: FND_MSG_PUB.Count_And_Get

1231:
1232: EXCEPTION
1233: WHEN FND_API.G_EXC_ERROR THEN
1234: IF (x_msg_data IS NULL) THEN
1235: FND_MSG_PUB.Count_And_Get
1236: ( p_encoded => FND_API.G_FALSE
1237: , p_count => x_msg_count
1238: , p_data => x_msg_data
1239: );

Line 1245: FND_MSG_PUB.Count_And_Get

1241: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1244: IF (x_msg_data IS NULL) THEN
1245: FND_MSG_PUB.Count_And_Get
1246: ( p_encoded => FND_API.G_FALSE
1247: , p_count => x_msg_count
1248: , p_data => x_msg_data
1249: );

Line 1347: FND_MSG_PUB.Count_And_Get

1343:
1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: IF (x_msg_data IS NULL) THEN
1347: FND_MSG_PUB.Count_And_Get
1348: ( p_encoded => FND_API.G_FALSE
1349: , p_count => x_msg_count
1350: , p_data => x_msg_data
1351: );

Line 1357: FND_MSG_PUB.Count_And_Get

1353: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: IF (x_msg_data IS NULL) THEN
1357: FND_MSG_PUB.Count_And_Get
1358: ( p_encoded => FND_API.G_FALSE
1359: , p_count => x_msg_count
1360: , p_data => x_msg_data
1361: );

Line 1452: FND_MSG_PUB.Count_And_Get

1448: EXCEPTION
1449: WHEN FND_API.G_EXC_ERROR THEN
1450: ROLLBACK TO ReorderBSCDimLevsPUB;
1451: IF (x_msg_data IS NULL) THEN
1452: FND_MSG_PUB.Count_And_Get
1453: ( p_encoded => FND_API.G_FALSE
1454: , p_count => x_msg_count
1455: , p_data => x_msg_data
1456: );

Line 1463: FND_MSG_PUB.Count_And_Get

1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1461: ROLLBACK TO ReorderBSCDimLevsPUB;
1462: IF (x_msg_data IS NULL) THEN
1463: FND_MSG_PUB.Count_And_Get
1464: ( p_encoded => FND_API.G_FALSE
1465: , p_count => x_msg_count
1466: , p_data => x_msg_data
1467: );

Line 1597: FND_MSG_PUB.Initialize;

1593: ORDER BY B.Dim_Level_Index;
1594:
1595: BEGIN
1596: SAVEPOINT CreateBSCDimLevsPUB;
1597: FND_MSG_PUB.Initialize;
1598: x_return_status := FND_API.G_RET_STS_SUCCESS;
1599: IF (p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id IS NULL) THEN
1600: -- Call private version of the procedure.
1601: --DBMS_OUTPUT.PUT_LINE(' Step 0');

Line 1797: FND_MSG_PUB.ADD;

1793: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1794: AND Level_Source = 'BSC';
1795: IF (l_count > BSC_UTILITY.MAX_DIM_IN_DIM_SET) THEN
1796: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_SET_OVERFLOW');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800:
1801: --DBMS_OUTPUT.PUT_LINE(' Step 3');

Line 1813: FND_MSG_PUB.ADD;

1809: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1810: AND Level_Source IS NOT NULL;
1811: IF (l_count > 1) THEN
1812: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MIX_DIM_SET_SOURCE');
1813: FND_MSG_PUB.ADD;
1814: RAISE FND_API.G_EXC_ERROR;
1815: END IF;
1816: END IF;
1817:

Line 1827: FND_MSG_PUB.ADD;

1823: AND DEFAULT_VALUE = 'C'
1824: AND Level_Source = 'BSC';
1825: IF (l_count > 1) THEN -- not more that 1 DimObj can be in comparison within a Dimension Set.
1826: FND_MESSAGE.SET_NAME('BSC','BSC_D_ONE_DIM_IN_COMPARISON');
1827: FND_MSG_PUB.ADD;
1828: RAISE FND_API.G_EXC_ERROR;
1829: END IF;
1830: END IF;
1831: IF (p_commit = FND_API.G_TRUE) THEN

Line 1842: FND_MSG_PUB.Count_And_Get

1838: EXCEPTION
1839: WHEN FND_API.G_EXC_ERROR THEN
1840: ROLLBACK TO CreateBSCDimLevsPUB;
1841: IF (x_msg_data IS NULL) THEN
1842: FND_MSG_PUB.Count_And_Get
1843: ( p_encoded => FND_API.G_FALSE
1844: , p_count => x_msg_count
1845: , p_data => x_msg_data
1846: );

Line 1852: FND_MSG_PUB.Count_And_Get

1848: x_return_status := FND_API.G_RET_STS_ERROR;
1849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1850: ROLLBACK TO CreateBSCDimLevsPUB;
1851: IF (x_msg_data IS NULL) THEN
1852: FND_MSG_PUB.Count_And_Get
1853: ( p_encoded => FND_API.G_FALSE
1854: , p_count => x_msg_count
1855: , p_data => x_msg_data
1856: );

Line 1904: FND_MSG_PUB.Count_And_Get

1900:
1901: EXCEPTION
1902: WHEN FND_API.G_EXC_ERROR THEN
1903: IF (x_msg_data IS NULL) THEN
1904: FND_MSG_PUB.Count_And_Get
1905: ( p_encoded => FND_API.G_FALSE
1906: , p_count => x_msg_count
1907: , p_data => x_msg_data
1908: );

Line 1914: FND_MSG_PUB.Count_And_Get

1910: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1913: IF (x_msg_data IS NULL) THEN
1914: FND_MSG_PUB.Count_And_Get
1915: ( p_encoded => FND_API.G_FALSE
1916: , p_count => x_msg_count
1917: , p_data => x_msg_data
1918: );

Line 1952: FND_MSG_PUB.Initialize;

1948: ,x_msg_data OUT NOCOPY varchar2
1949: ) is
1950: l_count NUMBER;
1951: begin
1952: FND_MSG_PUB.Initialize;
1953: x_return_status := FND_API.G_RET_STS_SUCCESS;
1954: BSC_DIMENSION_SETS_PVT.Update_Dim_Levels( p_commit
1955: ,p_Dim_Set_Rec
1956: ,x_return_status

Line 1974: FND_MSG_PUB.ADD;

1970: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1971: AND Level_Source IS NOT NULL;
1972: IF (l_count > 1) THEN
1973: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MIX_DIM_SET_SOURCE');
1974: FND_MSG_PUB.ADD;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977: END IF;
1978:

Line 1988: FND_MSG_PUB.ADD;

1984: AND Level_Source = 'BSC';
1985: IF (l_count > BSC_UTILITY.MAX_DIM_IN_DIM_SET) THEN
1986: FND_MESSAGE.SET_NAME('BSC','BSC_DIM_SET_OVERFLOW');
1987: x_msg_data := x_msg_data || bsc_apps.get_message('BSC_DIM_SET_OVERFLOW');
1988: FND_MSG_PUB.ADD;
1989: RAISE FND_API.G_EXC_ERROR;
1990: END IF;
1991:
1992: SELECT COUNT(0) INTO l_count

Line 2000: FND_MSG_PUB.ADD;

1996: AND DEFAULT_VALUE= 'C';
1997: IF (l_count > 1) THEN -- not more that 1 DimObj can be in comparison within a Dimension Set.
1998: FND_MESSAGE.SET_NAME('BSC','BSC_ONE_DIM_OBJ_IN_COMPARISON'); -- Need to change to a better meaning,
1999: x_msg_data := x_msg_data || bsc_apps.get_message('BSC_ONE_DIM_OBJ_IN_COMPARISON');
2000: FND_MSG_PUB.ADD;
2001: RAISE FND_API.G_EXC_ERROR;
2002: END IF;
2003:
2004: EXCEPTION

Line 2007: FND_MSG_PUB.Count_And_Get

2003:
2004: EXCEPTION
2005: WHEN FND_API.G_EXC_ERROR THEN
2006: IF (x_msg_data IS NULL) THEN
2007: FND_MSG_PUB.Count_And_Get
2008: ( p_encoded => FND_API.G_FALSE
2009: , p_count => x_msg_count
2010: , p_data => x_msg_data
2011: );

Line 2017: FND_MSG_PUB.Count_And_Get

2013: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2016: IF (x_msg_data IS NULL) THEN
2017: FND_MSG_PUB.Count_And_Get
2018: ( p_encoded => FND_API.G_FALSE
2019: , p_count => x_msg_count
2020: , p_data => x_msg_data
2021: );

Line 2154: FND_MSG_PUB.Count_And_Get

2150:
2151: EXCEPTION
2152: WHEN FND_API.G_EXC_ERROR THEN
2153: IF (x_msg_data IS NULL) THEN
2154: FND_MSG_PUB.Count_And_Get
2155: ( p_encoded => FND_API.G_FALSE
2156: , p_count => x_msg_count
2157: , p_data => x_msg_data
2158: );

Line 2164: FND_MSG_PUB.Count_And_Get

2160: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2161: x_return_status := FND_API.G_RET_STS_ERROR;
2162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2163: IF (x_msg_data IS NULL) THEN
2164: FND_MSG_PUB.Count_And_Get
2165: ( p_encoded => FND_API.G_FALSE
2166: , p_count => x_msg_count
2167: , p_data => x_msg_data
2168: );

Line 2215: FND_MSG_PUB.Count_And_Get

2211:
2212: EXCEPTION
2213: WHEN FND_API.G_EXC_ERROR THEN
2214: IF (x_msg_data IS NULL) THEN
2215: FND_MSG_PUB.Count_And_Get
2216: ( p_encoded => FND_API.G_FALSE
2217: , p_count => x_msg_count
2218: , p_data => x_msg_data
2219: );

Line 2225: FND_MSG_PUB.Count_And_Get

2221: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2224: IF (x_msg_data IS NULL) THEN
2225: FND_MSG_PUB.Count_And_Get
2226: ( p_encoded => FND_API.G_FALSE
2227: , p_count => x_msg_count
2228: , p_data => x_msg_data
2229: );