DBA Data[Home] [Help]

APPS.BSC_UPGRADES dependencies on FND_MSG_PUB

Line 396: FND_MSG_PUB.Count_And_Get (

392: EXCEPTION
393: WHEN OTHERS THEN
394: l_num := l_num + 1;
395: IF (l_msg_data IS NULL) THEN
396: FND_MSG_PUB.Count_And_Get (
397: p_encoded => FND_API.G_FALSE
398: , p_count => l_msg_count
399: , p_data => l_msg_data );
400: END IF;

Line 909: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: ROLLBACK;
909: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
910: ,p_data => l_msg_data);
911: IF (l_msg_data IS NULL) THEN
912: l_msg_data := SQLERRM;
913: END IF;

Line 1065: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: if installed_languages_cursor%ISOPEN THEN
1063: CLOSE installed_languages_cursor;
1064: end if;
1065: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1066: ,p_data => x_msg_data);
1067: RAISE;
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1073: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: if installed_languages_cursor%ISOPEN THEN
1071: CLOSE installed_languages_cursor;
1072: end if;
1073: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1074: ,p_data => x_msg_data);
1075: RAISE;
1076: WHEN NO_DATA_FOUND THEN
1077: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1081: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1077: x_return_status := FND_API.G_RET_STS_ERROR;
1078: if installed_languages_cursor%ISOPEN THEN
1079: CLOSE installed_languages_cursor;
1080: end if;
1081: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1082: ,p_data => x_msg_data);
1083: RAISE;
1084: WHEN OTHERS THEN
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1089: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: if installed_languages_cursor%ISOPEN THEN
1087: CLOSE installed_languages_cursor;
1088: end if;
1089: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1090: ,p_data => x_msg_data);
1091: RAISE;
1092:
1093: END lang_synch_PMF_To_BSC_measure;

Line 1182: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: if synch_lang_cursor%ISOPEN THEN
1180: CLOSE synch_lang_cursor;
1181: end if;
1182: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1183: ,p_data => x_msg_data);
1184: RAISE;
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1190: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1187: if synch_lang_cursor%ISOPEN THEN
1188: CLOSE synch_lang_cursor;
1189: end if;
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: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: if synch_lang_cursor%ISOPEN THEN
1196: CLOSE synch_lang_cursor;
1197: end if;
1198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1199: ,p_data => x_msg_data);
1200: RAISE;
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1203: if synch_lang_cursor%ISOPEN THEN
1204: CLOSE synch_lang_cursor;
1205: end if;
1206: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1207: ,p_data => x_msg_data);
1208: RAISE;
1209:
1210: END lang_synch_existing_measures;

Line 1317: FND_MSG_PUB.Initialize;

1313: AND level_values_view_name NOT LIKE 'BSC_D_%'
1314: AND level_values_view_name IS NOT NULL;
1315: BEGIN
1316: BSC_APPS.Init_Bsc_Apps;
1317: FND_MSG_PUB.Initialize;
1318: SAVEPOINT BscSyncDimeObjects;
1319:
1320: --Modify level_table_names in BSC tables to Upper case
1321: UPDATE BSC_SYS_DIM_LEVELS_B

Line 1466: FND_MSG_PUB.Count_And_Get

1462: CLOSE c_bsc_dim_objs;
1463: END IF;
1464: ROLLBACK TO BscSyncDimeObjects;
1465: IF (x_error_msg IS NULL) THEN
1466: FND_MSG_PUB.Count_And_Get
1467: ( p_encoded => 'F'
1468: , p_count => l_msg_count
1469: , p_data => x_error_msg
1470: );

Line 1483: FND_MSG_PUB.Count_And_Get

1479: CLOSE c_bsc_dim_objs;
1480: END IF;
1481: ROLLBACK TO BscSyncDimeObjects;
1482: IF (x_error_msg IS NULL) THEN
1483: FND_MSG_PUB.Count_And_Get
1484: ( p_encoded => 'F'
1485: , p_count => l_msg_count
1486: , p_data => x_error_msg
1487: );

Line 1574: FND_MSG_PUB.Initialize;

1570:
1571: l_flag BOOLEAN;
1572: l_count NUMBER;
1573: BEGIN
1574: FND_MSG_PUB.Initialize;
1575: SAVEPOINT BscSyncDimensions;
1576:
1577: UPDATE BSC_SYS_DIM_GROUPS_TL
1578: SET SHORT_NAME = 'BSC_DIM_'||Dim_Group_Id

Line 1750: FND_MSG_PUB.Count_And_Get

1746: CLOSE dim_obj_short_name;
1747: END IF;
1748: ROLLBACK TO BscSyncDimensions;
1749: IF (x_error_msg IS NULL) THEN
1750: FND_MSG_PUB.Count_And_Get
1751: ( p_encoded => 'F'
1752: , p_count => l_msg_count
1753: , p_data => x_error_msg
1754: );

Line 1770: FND_MSG_PUB.Count_And_Get

1766: CLOSE dim_obj_short_name;
1767: END IF;
1768: ROLLBACK TO BscSyncDimensions;
1769: IF (x_error_msg IS NULL) THEN
1770: FND_MSG_PUB.Count_And_Get
1771: ( p_encoded => 'F'
1772: , p_count => l_msg_count
1773: , p_data => x_error_msg
1774: );

Line 1961: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1957: x_return_status := FND_API.G_RET_STS_ERROR;
1958: if installed_languages_cursor%ISOPEN THEN
1959: CLOSE installed_languages_cursor;
1960: end if;
1961: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1962: ,p_data => x_msg_data);
1963: RAISE;
1964: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: if installed_languages_cursor%ISOPEN THEN
1967: CLOSE installed_languages_cursor;
1968: end if;
1969: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1970: ,p_data => x_msg_data);
1971: RAISE;
1972: WHEN NO_DATA_FOUND THEN
1973: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1977: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974: if installed_languages_cursor%ISOPEN THEN
1975: CLOSE installed_languages_cursor;
1976: end if;
1977: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1978: ,p_data => x_msg_data);
1979: RAISE;
1980: WHEN OTHERS THEN
1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1985: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1982: if installed_languages_cursor%ISOPEN THEN
1983: CLOSE installed_languages_cursor;
1984: end if;
1985: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1986: ,p_data => x_msg_data);
1987: RAISE;
1988:
1989: END Lang_Synch_PMF_To_BSC_DimObj;

Line 2129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2125: x_return_status := FND_API.G_RET_STS_ERROR;
2126: if installed_languages_cursor%ISOPEN THEN
2127: CLOSE installed_languages_cursor;
2128: end if;
2129: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2130: ,p_data => x_msg_data);
2131: RAISE;
2132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2134: if installed_languages_cursor%ISOPEN THEN
2135: CLOSE installed_languages_cursor;
2136: end if;
2137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2138: ,p_data => x_msg_data);
2139: RAISE;
2140: WHEN NO_DATA_FOUND THEN
2141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2141: x_return_status := FND_API.G_RET_STS_ERROR;
2142: if installed_languages_cursor%ISOPEN THEN
2143: CLOSE installed_languages_cursor;
2144: end if;
2145: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2146: ,p_data => x_msg_data);
2147: RAISE;
2148: WHEN OTHERS THEN
2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2153: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2150: if installed_languages_cursor%ISOPEN THEN
2151: CLOSE installed_languages_cursor;
2152: end if;
2153: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2154: ,p_data => x_msg_data);
2155: RAISE;
2156:
2157: END Lang_Synch_PMF_To_BSC_Dim;

Line 2272: FND_MSG_PUB.Count_And_Get

2268: RETURN TRUE;
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: ROLLBACK;
2272: FND_MSG_PUB.Count_And_Get
2273: ( p_count => l_msg_count
2274: ,p_data => l_msg_data
2275: );
2276: IF (l_msg_data IS NULL) THEN

Line 2419: FND_MSG_PUB.Count_And_Get

2415: CLOSE c_synch_launchpad;
2416: END IF;
2417:
2418: ROLLBACK;
2419: FND_MSG_PUB.Count_And_Get
2420: ( p_count => l_msg_count
2421: ,p_data => l_msg_data
2422: );
2423: IF (l_msg_data IS NULL) THEN

Line 2801: FND_MSG_PUB.Initialize;

2797: bsc_utility.Is_Internal_WKPI_Dim(short_name) IS NOT NULL)
2798: AND bis_util.is_Seeded(created_by,'T','F') = 'F'
2799: AND NVL(hide_in_design,'F') = 'F';
2800: BEGIN
2801: FND_MSG_PUB.Initialize;
2802: SAVEPOINT BisHideInDesignUpdate;
2803: OPEN cr_internal_dimensions;
2804: LOOP
2805: FETCH cr_internal_dimensions

Line 2859: FND_MSG_PUB.Initialize;

2855: name = short_name AND
2856: bis_util.is_seeded(created_by,'T','F') = 'F' AND
2857: (SELECT COUNT(1) FROM bsc_kpi_dim_groups WHERE dim_group_id = grp.dim_group_id) = 0;
2858: BEGIN
2859: FND_MSG_PUB.Initialize;
2860: SAVEPOINT BisUpdateImportDim;
2861: OPEN cr_pmf_import_dims;
2862: LOOP
2863: FETCH cr_pmf_import_dims

Line 2908: FND_MSG_PUB.Initialize;

2904: FROM bsc_sys_dim_levels_b
2905: WHERE short_name = p_sht_name;
2906:
2907: BEGIN
2908: FND_MSG_PUB.Initialize;
2909: x_return_status := FND_API.G_RET_STS_SUCCESS;
2910:
2911: FOR i in p_Dim_Obj_Sht_Name.FIRST..p_Dim_Obj_Sht_Name.LAST
2912: LOOP