DBA Data[Home] [Help]

APPS.BSC_COPY_INDICATOR_PUB dependencies on FND_MSG_PUB

Line 105: FND_MSG_PUB.Initialize;

101: WHERE
102: indicator = p_Indicator;
103:
104: BEGIN
105: FND_MSG_PUB.Initialize;
106: x_return_status := FND_API.G_RET_STS_SUCCESS;
107:
108: SAVEPOINT BscAssignIndGroupTab;
109:

Line 176: FND_MSG_PUB.Count_And_Get

172: EXCEPTION
173: WHEN FND_API.G_EXC_ERROR THEN
174: ROLLBACK TO BscAssignIndGroupTab;
175: IF (x_msg_data IS NULL) THEN
176: FND_MSG_PUB.Count_And_Get
177: ( p_encoded => FND_API.G_FALSE
178: , p_count => x_msg_count
179: , p_data => x_msg_data
180: );

Line 186: FND_MSG_PUB.Count_And_Get

182: x_return_status := FND_API.G_RET_STS_ERROR;
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: ROLLBACK TO BscAssignIndGroupTab;
185: IF (x_msg_data IS NULL) THEN
186: FND_MSG_PUB.Count_And_Get
187: ( p_encoded => FND_API.G_FALSE
188: , p_count => x_msg_count
189: , p_data => x_msg_data
190: );

Line 231: FND_MSG_PUB.Initialize;

227: IS
228: l_Bsc_Kpi_Group_Rec BSC_KPI_GROUP_PUB.Bsc_Kpi_Group_Rec;
229: l_Kpi_Count NUMBER := 0;
230: BEGIN
231: FND_MSG_PUB.Initialize;
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: SAVEPOINT BscUpdateKpiGroupProperties;
235:

Line 283: FND_MSG_PUB.Count_And_Get

279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO BscUpdateKpiGroupProperties;
282: IF (x_msg_data IS NULL) THEN
283: FND_MSG_PUB.Count_And_Get
284: ( p_encoded => FND_API.G_FALSE
285: , p_count => x_msg_count
286: , p_data => x_msg_data
287: );

Line 293: FND_MSG_PUB.Count_And_Get

289: x_return_status := FND_API.G_RET_STS_ERROR;
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: ROLLBACK TO BscUpdateKpiGroupProperties;
292: IF (x_msg_data IS NULL) THEN
293: FND_MSG_PUB.Count_And_Get
294: ( p_encoded => FND_API.G_FALSE
295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );

Line 341: FND_MSG_PUB.Initialize;

337: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
338: l_Old_Indicator_Group bsc_tab_ind_groups_b.ind_group_id%TYPE;
339: BEGIN
340:
341: FND_MSG_PUB.Initialize;
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: SAVEPOINT BscMovIndicatorSavePnt;
345:

Line 395: FND_MSG_PUB.Count_And_Get

391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: ROLLBACK TO BscMovIndicatorSavePnt;
394: IF (x_msg_data IS NULL) THEN
395: FND_MSG_PUB.Count_And_Get
396: ( p_encoded => FND_API.G_FALSE
397: , p_count => x_msg_count
398: , p_data => x_msg_data
399: );

Line 405: FND_MSG_PUB.Count_And_Get

401: x_return_status := FND_API.G_RET_STS_ERROR;
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: ROLLBACK TO BscMovIndicatorSavePnt;
404: IF (x_msg_data IS NULL) THEN
405: FND_MSG_PUB.Count_And_Get
406: ( p_encoded => FND_API.G_FALSE
407: , p_count => x_msg_count
408: , p_data => x_msg_data
409: );

Line 473: FND_MSG_PUB.Initialize;

469: AND prototype_flag <> 2;
470:
471: BEGIN
472:
473: FND_MSG_PUB.Initialize;
474: x_return_status := FND_API.G_RET_STS_SUCCESS;
475:
476: SAVEPOINT BscRepositionIndicatorSavePnt;
477:

Line 553: FND_MSG_PUB.Count_And_Get

549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: ROLLBACK TO BscRepositionIndicatorSavePnt;
552: IF (x_msg_data IS NULL) THEN
553: FND_MSG_PUB.Count_And_Get
554: ( p_encoded => FND_API.G_FALSE
555: , p_count => x_msg_count
556: , p_data => x_msg_data
557: );

Line 563: FND_MSG_PUB.Count_And_Get

559: x_return_status := FND_API.G_RET_STS_ERROR;
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO BscRepositionIndicatorSavePnt;
562: IF (x_msg_data IS NULL) THEN
563: FND_MSG_PUB.Count_And_Get
564: ( p_encoded => FND_API.G_FALSE
565: , p_count => x_msg_count
566: , p_data => x_msg_data
567: );

Line 624: FND_MSG_PUB.Initialize;

620: AND prototype_flag <> 2;
621:
622: BEGIN
623:
624: FND_MSG_PUB.Initialize;
625: x_return_status := FND_API.G_RET_STS_SUCCESS;
626:
627: SAVEPOINT BscMovIndicatorUIWrap;
628:

Line 722: FND_MSG_PUB.Count_And_Get

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO BscMovIndicatorUIWrap;
721: IF (x_msg_data IS NULL) THEN
722: FND_MSG_PUB.Count_And_Get
723: ( p_encoded => FND_API.G_FALSE
724: , p_count => x_msg_count
725: , p_data => x_msg_data
726: );

Line 732: FND_MSG_PUB.Count_And_Get

728: x_return_status := FND_API.G_RET_STS_ERROR;
729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
730: ROLLBACK TO BscMovIndicatorUIWrap;
731: IF (x_msg_data IS NULL) THEN
732: FND_MSG_PUB.Count_And_Get
733: ( p_encoded => FND_API.G_FALSE
734: , p_count => x_msg_count
735: , p_data => x_msg_data
736: );

Line 784: FND_MSG_PUB.Initialize;

780: l_indicator_type bsc_kpis_b.indicator_type%TYPE;
781: l_config_type bsc_kpis_b.config_type%TYPE;
782: BEGIN
783:
784: FND_MSG_PUB.Initialize;
785: x_return_status := FND_API.G_RET_STS_SUCCESS;
786:
787: SAVEPOINT BscValIndCopyUIWrap;
788:

Line 798: FND_MSG_PUB.ADD;

794: FETCH c_cursor INTO l_EDW_Flag;
795: CLOSE c_cursor;
796: IF l_EDW_Flag <> 0 THEN
797: FND_MESSAGE.SET_NAME('BSC','BSC_CAN_NOT_COPY_EDW_KPI');
798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801:
802: l_sql := BSC_DESIGNER_PVT.Format_DbLink_String('SELECT indicator_type,config_type FROM bsc_kpis_b');

Line 817: FND_MSG_PUB.ADD;

813: FETCH c_cursor INTO l_PMF_Meas_Cnt;
814: CLOSE c_cursor;
815: IF l_PMF_Meas_Cnt > 0 THEN
816: FND_MESSAGE.SET_NAME('BSC','BSC_CAN_NOT_COPY_PMF_KPI');
817: FND_MSG_PUB.ADD;
818: RAISE FND_API.G_EXC_ERROR;
819: END IF;
820: END IF;
821:

Line 828: FND_MSG_PUB.Count_And_Get

824: EXCEPTION
825: WHEN FND_API.G_EXC_ERROR THEN
826: ROLLBACK TO BscValIndCopyUIWrap;
827: IF (x_msg_data IS NULL) THEN
828: FND_MSG_PUB.Count_And_Get
829: ( p_encoded => FND_API.G_FALSE
830: , p_count => x_msg_count
831: , p_data => x_msg_data
832: );

Line 838: FND_MSG_PUB.Count_And_Get

834: x_return_status := FND_API.G_RET_STS_ERROR;
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO BscValIndCopyUIWrap;
837: IF (x_msg_data IS NULL) THEN
838: FND_MSG_PUB.Count_And_Get
839: ( p_encoded => FND_API.G_FALSE
840: , p_count => x_msg_count
841: , p_data => x_msg_data
842: );

Line 885: FND_MSG_PUB.Initialize;

881: i NUMBER;
882: l_sql VARCHAR2(32000);
883: BEGIN
884:
885: FND_MSG_PUB.Initialize;
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: FOR i IN 1..p_DataSet_Map.COUNT LOOP
889: BSC_BIS_LOCKS_PUB.Lock_Dataset (

Line 977: FND_MSG_PUB.Initialize;

973: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
974:
975: BEGIN
976:
977: FND_MSG_PUB.Initialize;
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979:
980: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_Indicator_Id;
981: l_Bsc_Kpi_Entity_Rec.Bsc_Responsibility_Id := FND_GLOBAL.RESP_ID;

Line 1003: FND_MSG_PUB.Count_And_Get

999:
1000: EXCEPTION
1001: WHEN FND_API.G_EXC_ERROR THEN
1002: IF (x_msg_data IS NULL) THEN
1003: FND_MSG_PUB.Count_And_Get
1004: ( p_encoded => FND_API.G_FALSE
1005: , p_count => x_msg_count
1006: , p_data => x_msg_data
1007: );

Line 1012: FND_MSG_PUB.Count_And_Get

1008: END IF;
1009: x_return_status := FND_API.G_RET_STS_ERROR;
1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011: IF (x_msg_data IS NULL) THEN
1012: FND_MSG_PUB.Count_And_Get
1013: ( p_encoded => FND_API.G_FALSE
1014: , p_count => x_msg_count
1015: , p_data => x_msg_data
1016: );

Line 1065: FND_MSG_PUB.Initialize;

1061: l_sql VARCHAR2(32000);
1062:
1063: BEGIN
1064:
1065: FND_MSG_PUB.Initialize;
1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067: SAVEPOINT BscCopyIndicAnaMeasPub;
1068:
1069: l_sql := 'SELECT analysis_option0 ,analysis_option1 ,analysis_option2,series_id';

Line 1113: FND_MSG_PUB.Count_And_Get

1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: ROLLBACK TO BscCopyIndicAnaMeasPub;
1112: IF (x_msg_data IS NULL) THEN
1113: FND_MSG_PUB.Count_And_Get
1114: ( p_encoded => FND_API.G_FALSE
1115: , p_count => x_msg_count
1116: , p_data => x_msg_data
1117: );

Line 1123: FND_MSG_PUB.Count_And_Get

1119: x_return_status := FND_API.G_RET_STS_ERROR;
1120: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO BscCopyIndicAnaMeasPub;
1122: IF (x_msg_data IS NULL) THEN
1123: FND_MSG_PUB.Count_And_Get
1124: ( p_encoded => FND_API.G_FALSE
1125: , p_count => x_msg_count
1126: , p_data => x_msg_data
1127: );

Line 1180: FND_MSG_PUB.Initialize;

1176: sc.calendar_id = sp.calendar_id ;
1177:
1178: BEGIN
1179:
1180: FND_MSG_PUB.Initialize;
1181: x_return_status := FND_API.G_RET_STS_SUCCESS;
1182: SAVEPOINT BscUpdAnnCurPeriod;
1183:
1184: FOR cd IN c_Periodicity LOOP

Line 1202: FND_MSG_PUB.Count_And_Get

1198: EXCEPTION
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK TO BscUpdAnnCurPeriod;
1201: IF (x_msg_data IS NULL) THEN
1202: FND_MSG_PUB.Count_And_Get
1203: ( p_encoded => FND_API.G_FALSE
1204: , p_count => x_msg_count
1205: , p_data => x_msg_data
1206: );

Line 1212: FND_MSG_PUB.Count_And_Get

1208: x_return_status := FND_API.G_RET_STS_ERROR;
1209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1210: ROLLBACK TO BscUpdAnnCurPeriod;
1211: IF (x_msg_data IS NULL) THEN
1212: FND_MSG_PUB.Count_And_Get
1213: ( p_encoded => FND_API.G_FALSE
1214: , p_count => x_msg_count
1215: , p_data => x_msg_data
1216: );

Line 1270: FND_MSG_PUB.Initialize;

1266: l_Periodicity_Id bsc_sys_periodicities.periodicity_id%TYPE;
1267: l_Found BOOLEAN := FALSE;
1268: BEGIN
1269:
1270: FND_MSG_PUB.Initialize;
1271: x_return_status := FND_API.G_RET_STS_SUCCESS;
1272: SAVEPOINT BscCopyIndicPeriodsPub;
1273:
1274: IF p_New_Periodicities.COUNT = 0 THEN

Line 1432: FND_MSG_PUB.Count_And_Get

1428: EXCEPTION
1429: WHEN FND_API.G_EXC_ERROR THEN
1430: ROLLBACK TO BscCopyIndicPeriodsPub;
1431: IF (x_msg_data IS NULL) THEN
1432: FND_MSG_PUB.Count_And_Get
1433: ( p_encoded => FND_API.G_FALSE
1434: , p_count => x_msg_count
1435: , p_data => x_msg_data
1436: );

Line 1442: FND_MSG_PUB.Count_And_Get

1438: x_return_status := FND_API.G_RET_STS_ERROR;
1439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1440: ROLLBACK TO BscCopyIndicPeriodsPub;
1441: IF (x_msg_data IS NULL) THEN
1442: FND_MSG_PUB.Count_And_Get
1443: ( p_encoded => FND_API.G_FALSE
1444: , p_count => x_msg_count
1445: , p_data => x_msg_data
1446: );

Line 1487: FND_MSG_PUB.Initialize;

1483: )IS
1484: l_Count NUMBER := 0;
1485: BEGIN
1486:
1487: FND_MSG_PUB.Initialize;
1488: x_return_status := FND_API.G_RET_STS_SUCCESS;
1489: SAVEPOINT BscCopyUpdKpiProps;
1490:
1491: l_Count := 0;

Line 1529: FND_MSG_PUB.Count_And_Get

1525: EXCEPTION
1526: WHEN FND_API.G_EXC_ERROR THEN
1527: ROLLBACK TO BscCopyUpdKpiProps;
1528: IF (x_msg_data IS NULL) THEN
1529: FND_MSG_PUB.Count_And_Get
1530: ( p_encoded => FND_API.G_FALSE
1531: , p_count => x_msg_count
1532: , p_data => x_msg_data
1533: );

Line 1539: FND_MSG_PUB.Count_And_Get

1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1537: ROLLBACK TO BscCopyUpdKpiProps;
1538: IF (x_msg_data IS NULL) THEN
1539: FND_MSG_PUB.Count_And_Get
1540: ( p_encoded => FND_API.G_FALSE
1541: , p_count => x_msg_count
1542: , p_data => x_msg_data
1543: );

Line 1596: FND_MSG_PUB.Initialize;

1592: l_dim_group_index bsc_kpi_dim_groups.dim_group_index%TYPE;
1593:
1594: BEGIN
1595:
1596: FND_MSG_PUB.Initialize;
1597: x_return_status := FND_API.G_RET_STS_SUCCESS;
1598: SAVEPOINT BscCopyDimLevProps;
1599: IF p_Region_Code IS NOT NULL THEN -- Simulation tree
1600: BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group (

Line 1705: FND_MSG_PUB.Count_And_Get

1701: EXCEPTION
1702: WHEN FND_API.G_EXC_ERROR THEN
1703: ROLLBACK TO BscCopyDimLevProps;
1704: IF (x_msg_data IS NULL) THEN
1705: FND_MSG_PUB.Count_And_Get
1706: ( p_encoded => FND_API.G_FALSE
1707: , p_count => x_msg_count
1708: , p_data => x_msg_data
1709: );

Line 1715: FND_MSG_PUB.Count_And_Get

1711: x_return_status := FND_API.G_RET_STS_ERROR;
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713: ROLLBACK TO BscCopyDimLevProps;
1714: IF (x_msg_data IS NULL) THEN
1715: FND_MSG_PUB.Count_And_Get
1716: ( p_encoded => FND_API.G_FALSE
1717: , p_count => x_msg_count
1718: , p_data => x_msg_data
1719: );

Line 1836: FND_MSG_PUB.Initialize;

1832: l_rec c_Check_Config_Change%ROWTYPE;
1833:
1834: BEGIN
1835:
1836: FND_MSG_PUB.Initialize;
1837: x_return_status := FND_API.G_RET_STS_SUCCESS;
1838: SAVEPOINT BscChkKeyItemProps;
1839:
1840: l_sql := 'SELECT kl.dim_set_id,dim_level_index,kl.level_table_name,kl.level_pk_col,dl.dim_level_id,';

Line 1933: FND_MSG_PUB.Count_And_Get

1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN
1931: ROLLBACK TO BscChkKeyItemProps;
1932: IF (x_msg_data IS NULL) THEN
1933: FND_MSG_PUB.Count_And_Get
1934: ( p_encoded => FND_API.G_FALSE
1935: , p_count => x_msg_count
1936: , p_data => x_msg_data
1937: );

Line 1943: FND_MSG_PUB.Count_And_Get

1939: x_return_status := FND_API.G_RET_STS_ERROR;
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: ROLLBACK TO BscChkKeyItemProps;
1942: IF (x_msg_data IS NULL) THEN
1943: FND_MSG_PUB.Count_And_Get
1944: ( p_encoded => FND_API.G_FALSE
1945: , p_count => x_msg_count
1946: , p_data => x_msg_data
1947: );

Line 1988: FND_MSG_PUB.Initialize;

1984: l_count NUMBER := 0;
1985:
1986: BEGIN
1987:
1988: FND_MSG_PUB.Initialize;
1989: x_return_status := FND_API.G_RET_STS_SUCCESS;
1990: SAVEPOINT BscChkColorByTotal;
1991:
1992: SELECT

Line 2045: FND_MSG_PUB.Count_And_Get

2041: EXCEPTION
2042: WHEN FND_API.G_EXC_ERROR THEN
2043: ROLLBACK TO BscChkColorByTotal;
2044: IF (x_msg_data IS NULL) THEN
2045: FND_MSG_PUB.Count_And_Get
2046: ( p_encoded => FND_API.G_FALSE
2047: , p_count => x_msg_count
2048: , p_data => x_msg_data
2049: );

Line 2055: FND_MSG_PUB.Count_And_Get

2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2053: ROLLBACK TO BscChkColorByTotal;
2054: IF (x_msg_data IS NULL) THEN
2055: FND_MSG_PUB.Count_And_Get
2056: ( p_encoded => FND_API.G_FALSE
2057: , p_count => x_msg_count
2058: , p_data => x_msg_data
2059: );

Line 2111: FND_MSG_PUB.Initialize;

2107: l_Count NUMBER := 0;
2108: l_Drill_Flag NUMBER := 0;
2109: BEGIN
2110:
2111: FND_MSG_PUB.Initialize;
2112: x_return_status := FND_API.G_RET_STS_SUCCESS;
2113: SAVEPOINT BscCopyIndicPLUpd;
2114:
2115: OPEN c_Indic;

Line 2157: FND_MSG_PUB.Count_And_Get

2153: EXCEPTION
2154: WHEN FND_API.G_EXC_ERROR THEN
2155: ROLLBACK TO BscCopyIndicPLUpd;
2156: IF (x_msg_data IS NULL) THEN
2157: FND_MSG_PUB.Count_And_Get
2158: ( p_encoded => FND_API.G_FALSE
2159: , p_count => x_msg_count
2160: , p_data => x_msg_data
2161: );

Line 2167: FND_MSG_PUB.Count_And_Get

2163: x_return_status := FND_API.G_RET_STS_ERROR;
2164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2165: ROLLBACK TO BscCopyIndicPLUpd;
2166: IF (x_msg_data IS NULL) THEN
2167: FND_MSG_PUB.Count_And_Get
2168: ( p_encoded => FND_API.G_FALSE
2169: , p_count => x_msg_count
2170: , p_data => x_msg_data
2171: );

Line 2213: FND_MSG_PUB.Initialize;

2209:
2210: l_Count NUMBER := 0;
2211: BEGIN
2212:
2213: FND_MSG_PUB.Initialize;
2214: x_return_status := FND_API.G_RET_STS_SUCCESS;
2215: SAVEPOINT BscCopyDfltDataTbl;
2216:
2217: SELECT

Line 2255: FND_MSG_PUB.Count_And_Get

2251: EXCEPTION
2252: WHEN FND_API.G_EXC_ERROR THEN
2253: ROLLBACK TO BscCopyDfltDataTbl;
2254: IF (x_msg_data IS NULL) THEN
2255: FND_MSG_PUB.Count_And_Get
2256: ( p_encoded => FND_API.G_FALSE
2257: , p_count => x_msg_count
2258: , p_data => x_msg_data
2259: );

Line 2265: FND_MSG_PUB.Count_And_Get

2261: x_return_status := FND_API.G_RET_STS_ERROR;
2262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2263: ROLLBACK TO BscCopyDfltDataTbl;
2264: IF (x_msg_data IS NULL) THEN
2265: FND_MSG_PUB.Count_And_Get
2266: ( p_encoded => FND_API.G_FALSE
2267: , p_count => x_msg_count
2268: , p_data => x_msg_data
2269: );

Line 2321: FND_MSG_PUB.Initialize;

2317: l_name bsc_kpis_tl.name%TYPE;
2318: l_new_name bsc_kpis_tl.name%TYPE;
2319: BEGIN
2320:
2321: FND_MSG_PUB.Initialize;
2322: x_return_status := FND_API.G_RET_STS_SUCCESS;
2323: SAVEPOINT BscCopyIndicChkKpiName;
2324:
2325: l_new_name := p_Name;

Line 2375: FND_MSG_PUB.Count_And_Get

2371: EXCEPTION
2372: WHEN FND_API.G_EXC_ERROR THEN
2373: ROLLBACK TO BscCopyIndicChkKpiName;
2374: IF (x_msg_data IS NULL) THEN
2375: FND_MSG_PUB.Count_And_Get
2376: ( p_encoded => FND_API.G_FALSE
2377: , p_count => x_msg_count
2378: , p_data => x_msg_data
2379: );

Line 2385: FND_MSG_PUB.Count_And_Get

2381: x_return_status := FND_API.G_RET_STS_ERROR;
2382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2383: ROLLBACK TO BscCopyIndicChkKpiName;
2384: IF (x_msg_data IS NULL) THEN
2385: FND_MSG_PUB.Count_And_Get
2386: ( p_encoded => FND_API.G_FALSE
2387: , p_count => x_msg_count
2388: , p_data => x_msg_data
2389: );

Line 2446: FND_MSG_PUB.Initialize;

2442: l_Short_Name bsc_kpis_b.short_name%TYPE;
2443: l_Region_Code ak_regions.region_code%TYPE;
2444: BEGIN
2445:
2446: FND_MSG_PUB.Initialize;
2447: x_return_status := FND_API.G_RET_STS_SUCCESS;
2448:
2449: SAVEPOINT BscCopyIndicatorUIWrap;
2450:

Line 2744: FND_MSG_PUB.Count_And_Get

2740: EXCEPTION
2741: WHEN FND_API.G_EXC_ERROR THEN
2742: ROLLBACK TO BscCopyIndicatorUIWrap;
2743: IF (x_msg_data IS NULL) THEN
2744: FND_MSG_PUB.Count_And_Get
2745: ( p_encoded => FND_API.G_FALSE
2746: , p_count => x_msg_count
2747: , p_data => x_msg_data
2748: );

Line 2754: FND_MSG_PUB.Count_And_Get

2750: x_return_status := FND_API.G_RET_STS_ERROR;
2751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2752: ROLLBACK TO BscCopyIndicatorUIWrap;
2753: IF (x_msg_data IS NULL) THEN
2754: FND_MSG_PUB.Count_And_Get
2755: ( p_encoded => FND_API.G_FALSE
2756: , p_count => x_msg_count
2757: , p_data => x_msg_data
2758: );