DBA Data[Home] [Help]

APPS.BSC_MIGRATION dependencies on FND_MSG_PUB

Line 2220: h_sql := 'BEGIN FND_MSG_PUB.Initialize@'||g_db_link||'; END;';

2216:
2217: h_num_tabs_filter := Decompose_Numeric_List(h_tab_filter, h_tabs_filter, ',');
2218: h_num_kpis_filter := Decompose_Numeric_List(h_kpi_filter, h_kpis_filter, ',');
2219:
2220: h_sql := 'BEGIN FND_MSG_PUB.Initialize@'||g_db_link||'; END;';
2221: execute immediate h_sql;
2222:
2223: h_sql := 'BEGIN BSC_APPS.Init_Bsc_Apps@'||g_db_link||'; END;';
2224: execute immediate h_sql;

Line 2357: FND_MSG_PUB.Initialize;

2353: -- Initialize BSC/APPS global variables
2354: BSC_APPS.Init_Bsc_Apps;
2355:
2356: -- LOCKING: call this api
2357: FND_MSG_PUB.Initialize;
2358:
2359: -- Initializes the error message stack
2360: BSC_MESSAGE.Init(g_debug_flag);
2361:

Line 2399: h_sql := 'BEGIN FND_MSG_PUB.Initialize@'||g_db_link||'; END;';

2395: -- then we lock the source system with the user ANONYMOUS
2396: h_source_user_id := Get_Source_User_Id;
2397:
2398: -- Fix bug#4480209 LOCKING: Need to call this api for backward compatibility
2399: h_sql := 'BEGIN FND_MSG_PUB.Initialize@'||g_db_link||'; END;';
2400: execute immediate h_sql;
2401: h_sql := 'BEGIN BSC_APPS.Init_Bsc_Apps@'||g_db_link||'; END;';
2402: execute immediate h_sql;
2403: h_null := NULL;

Line 6263: FND_MSG_PUB.Count_And_Get(p_count => h_msg_count

6259:
6260: EXCEPTION
6261: WHEN OTHERS THEN
6262: ROLLBACK;
6263: FND_MSG_PUB.Count_And_Get(p_count => h_msg_count
6264: ,p_data => h_msg_data);
6265: IF (h_msg_data is null) THEN
6266: h_msg_data := SQLERRM;
6267: END IF;

Line 6340: FND_MSG_PUB.Count_And_Get(p_count => h_msg_count

6336:
6337: EXCEPTION
6338: WHEN OTHERS THEN
6339: ROLLBACK;
6340: FND_MSG_PUB.Count_And_Get(p_count => h_msg_count
6341: ,p_data => h_msg_data);
6342: IF (h_msg_data is null) THEN
6343: h_msg_data := SQLERRM;
6344: END IF;

Line 6414: FND_MSG_PUB.Count_And_Get(p_count => h_msg_count

6410:
6411: EXCEPTION
6412: WHEN OTHERS THEN
6413: ROLLBACK;
6414: FND_MSG_PUB.Count_And_Get(p_count => h_msg_count
6415: ,p_data => h_msg_data);
6416: IF (h_msg_data is null) THEN
6417: h_msg_data := SQLERRM;
6418: END IF;

Line 8850: FND_MSG_PUB.INITIALIZE;

8846: ) IS
8847:
8848: l_Ak_Region_Item_Rec BIS_AK_REGION_PUB.Bis_Region_Item_Rec_Type;
8849: BEGIN
8850: FND_MSG_PUB.INITIALIZE;
8851: x_return_status := FND_API.G_RET_STS_SUCCESS;
8852:
8853: SAVEPOINT BscUpdAKItemProps;
8854: BIS_AK_REGION_PUB.Get_Region_Item_Rec (

Line 8889: FND_MSG_PUB.Count_And_Get

8885:
8886: EXCEPTION
8887: WHEN FND_API.G_EXC_ERROR THEN
8888: ROLLBACK TO BscUpdAKItemProps;
8889: FND_MSG_PUB.Count_And_Get
8890: ( p_encoded => FND_API.G_FALSE
8891: , p_count => x_msg_count
8892: , p_data => x_msg_data
8893: );

Line 8897: FND_MSG_PUB.Count_And_Get

8893: );
8894: x_return_status := FND_API.G_RET_STS_ERROR;
8895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8896: ROLLBACK TO BscUpdAKItemProps;
8897: FND_MSG_PUB.Count_And_Get
8898: ( p_encoded => FND_API.G_FALSE
8899: , p_count => x_msg_count
8900: , p_data => x_msg_data
8901: );

Line 8984: FND_MSG_PUB.INITIALIZE;

8980: indicator = p_Trg_indicator AND
8981: property_code = 'S_NODE_ID';
8982:
8983: BEGIN
8984: FND_MSG_PUB.INITIALIZE;
8985: x_return_status := FND_API.G_RET_STS_SUCCESS;
8986:
8987: SAVEPOINT BscSyncAKBscMetadata;
8988: -- DataSet Sync Up

Line 9350: FND_MSG_PUB.Count_And_Get

9346:
9347: EXCEPTION
9348: WHEN FND_API.G_EXC_ERROR THEN
9349: ROLLBACK TO BscSyncAKBscMetadata;
9350: FND_MSG_PUB.Count_And_Get
9351: ( p_encoded => FND_API.G_FALSE
9352: , p_count => x_msg_count
9353: , p_data => x_msg_data
9354: );

Line 9358: FND_MSG_PUB.Count_And_Get

9354: );
9355: x_return_status := FND_API.G_RET_STS_ERROR;
9356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9357: ROLLBACK TO BscSyncAKBscMetadata;
9358: FND_MSG_PUB.Count_And_Get
9359: ( p_encoded => FND_API.G_FALSE
9360: , p_count => x_msg_count
9361: , p_data => x_msg_data
9362: );

Line 9409: FND_MSG_PUB.INITIALIZE;

9405: TYPE c_cur_type IS REF CURSOR;
9406: c_cursor c_cur_type;
9407:
9408: BEGIN
9409: FND_MSG_PUB.INITIALIZE;
9410: x_return_status := FND_API.G_RET_STS_SUCCESS;
9411:
9412: SAVEPOINT BscCopyAKAttrMetadata;
9413: -- DataSet Sync Up

Line 9495: FND_MSG_PUB.Count_And_Get

9491:
9492: EXCEPTION
9493: WHEN FND_API.G_EXC_ERROR THEN
9494: ROLLBACK TO BscCopyAKAttrMetadata;
9495: FND_MSG_PUB.Count_And_Get
9496: ( p_encoded => FND_API.G_FALSE
9497: , p_count => x_msg_count
9498: , p_data => x_msg_data
9499: );

Line 9503: FND_MSG_PUB.Count_And_Get

9499: );
9500: x_return_status := FND_API.G_RET_STS_ERROR;
9501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9502: ROLLBACK TO BscCopyAKAttrMetadata;
9503: FND_MSG_PUB.Count_And_Get
9504: ( p_encoded => FND_API.G_FALSE
9505: , p_count => x_msg_count
9506: , p_data => x_msg_data
9507: );

Line 9601: FND_MSG_PUB.INITIALIZE;

9597:
9598: --First we will check if the region_code exists on the target system
9599: -- if yes then we cannot migrate and log it
9600: -- if the short_name is not there
9601: FND_MSG_PUB.INITIALIZE;
9602: x_return_status := FND_API.G_RET_STS_SUCCESS;
9603:
9604: SAVEPOINT BscMigSimDataPub;
9605: g_db_link := BSC_DESIGNER_PVT.g_DbLink_Name;

Line 9893: FND_MSG_PUB.Count_And_Get

9889:
9890: EXCEPTION
9891: WHEN FND_API.G_EXC_ERROR THEN
9892: ROLLBACK TO BscMigSimDataPub;
9893: FND_MSG_PUB.Count_And_Get
9894: ( p_encoded => FND_API.G_FALSE
9895: , p_count => x_msg_count
9896: , p_data => x_msg_data
9897: );

Line 9901: FND_MSG_PUB.Count_And_Get

9897: );
9898: x_return_status := FND_API.G_RET_STS_ERROR;
9899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9900: ROLLBACK TO BscMigSimDataPub;
9901: FND_MSG_PUB.Count_And_Get
9902: ( p_encoded => FND_API.G_FALSE
9903: , p_count => x_msg_count
9904: , p_data => x_msg_data
9905: );