APPS.INV_OPM_ITEM_MIGRATION dependencies on FND_API

Line 140: x_return_status := FND_API.G_RET_STS_SUCCESS;

136: INVALID_ITEM EXCEPTION;
137:
138: BEGIN
139:
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141:
142: /* Retrieve Regulatory Item information */
143: OPEN c_get_reg_item;
144: FETCH c_get_reg_item INTO l_reg_rec;

Line 202: x_return_status := FND_API.G_RET_STS_ERROR;

198:
199: WHEN INVALID_ITEM THEN
200: FND_MESSAGE.SET_NAME('GR','GR_INVALID_ITEM');
201: x_msg_data := FND_MESSAGE.GET;
202: x_return_status := FND_API.G_RET_STS_ERROR;
203:
204: WHEN OTHERS THEN
205: x_msg_data := SQLERRM;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

202: x_return_status := FND_API.G_RET_STS_ERROR;
203:
204: WHEN OTHERS THEN
205: x_msg_data := SQLERRM;
206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207:
208: END get_reg_item_info;
209:
210: /*====================================================================

Line 309: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

305: p_item_code => p_item_code,
306: x_reg_item_rec => l_opm_item,
307: x_return_status => l_return_status,
308: x_msg_data => l_msg_data);
309: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
310: -- Log error
311: -- dbms_output.put_line ('Invalid Regulatory Item :' || p_item_code);
312: GMA_COMMON_LOGGING.gma_migration_central_log (
313: p_run_id => p_migration_run_id,

Line 375: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

371: x_return_status => l_return_status,
372: x_msg_count => l_msg_count,
373: x_msg_data => l_msg_data);
374:
375: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
376: l_action := 'U';
377:
378: --BEGIN BUG 14364505
379: --If Inventory Item is existing in the Oracle Inventory,Get Item Long Description.

Line 411: , p_fetch_Master => FND_API.g_TRUE

407: OPEN INV_ITEM_API.Item_TL_csr
408: (
409: p_Item_ID => l_inventory_item_id
410: , p_Org_ID => l_org_id
411: , p_fetch_Master => FND_API.g_TRUE
412: , p_fetch_Orgs => FND_API.g_FALSE
413: );
414: FETCH INV_ITEM_API.Item_TL_csr INTO l_item_tl_rec;
415: CLOSE INV_ITEM_API.Item_TL_csr;

Line 412: , p_fetch_Orgs => FND_API.g_FALSE

408: (
409: p_Item_ID => l_inventory_item_id
410: , p_Org_ID => l_org_id
411: , p_fetch_Master => FND_API.g_TRUE
412: , p_fetch_Orgs => FND_API.g_FALSE
413: );
414: FETCH INV_ITEM_API.Item_TL_csr INTO l_item_tl_rec;
415: CLOSE INV_ITEM_API.Item_TL_csr;
416:

Line 1000: WHEN FND_API.G_EXC_ERROR THEN

996: -- Jatinder - 11/30/06 - Move commit to the main procedure to avoid deadlocks. 5690686.
997: EXCEPTION
998: WHEN e_error THEN
999: ROLLBACK;
1000: WHEN FND_API.G_EXC_ERROR THEN
1001: x_failure_count := x_failure_count + 1;
1002: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1003: FOR i in 1..l_msg_count LOOP
1004: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

Line 1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1018: p_app_short_name => 'FND');
1019: END LOOP;
1020: ROLLBACK;
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023:
1024: x_failure_count := x_failure_count + 1;
1025: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1026: FOR i in 1..l_msg_count LOOP

Line 1612: IF (p_commit <> FND_API.G_FALSE) THEN

1608: END IF;
1609:
1610: -- Jatinder - 11/30/06 - Moved commit here to avoid deadlocks. 5690686.
1611: -- Autonomous transaction commit
1612: IF (p_commit <> FND_API.G_FALSE) THEN
1613: COMMIT;
1614: ELSE
1615: ROLLBACK; -- Since this is an autonomous transaction
1616: END IF;

Line 2022: IF (p_commit <> FND_API.G_FALSE) THEN

2018: NULL
2019: );
2020: END IF;
2021:
2022: IF (p_commit <> FND_API.G_FALSE) THEN
2023: COMMIT;
2024: END IF;
2025: END LOOP;
2026: