APPS.INV_OPM_LOT_MIGRATION dependencies on FND_API

Line 180: p_commit => FND_API.G_TRUE,

176: p_migration_run_id => p_migration_run_id,
177: p_item_id => p_item_id,
178: p_organization_id => p_organization_id,
179: p_mode => NULL,
180: p_commit => FND_API.G_TRUE,
181: x_inventory_item_id => l_inventory_item_id,
182: x_failure_count => x_failure_count);
183: IF (x_failure_count > 0) THEN
184: -- Log Error

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

526: p_source => NULL,
527: p_api_version => 1.0,
528: p_origin_txn_id => NULL);
529:
530: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
531: -- Log Error
532: x_failure_count := x_failure_count + 1;
533: FOR i in 1..l_msg_count LOOP
534: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

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

578: item_id = p_item_id and -- Added this to use index.
579: lot_id = p_lot_id; -- Added this to use index.
580:
581: -- Autonomous transaction commit
582: IF (p_commit <> FND_API.G_FALSE) THEN
583: COMMIT;
584: ELSE
585: ROLLBACK;
586: END IF;

Line 799: -- p_commit => FND_API.G_TRUE,

795: -- p_lot_no => l_lot_no,
796: -- p_sublot_no => l_sublot_no,
797: -- p_organization_id => l_organization_id,
798: -- p_locator_id => l_locator_id,
799: -- p_commit => FND_API.G_TRUE,
800: -- x_lot_number => l_lot_number,
801: -- x_parent_lot_number => l_parent_lot_number,
802: -- x_failure_count => l_failure_count);
803: --

Line 1384: WHEN FND_API.G_EXC_ERROR THEN

1380: END IF;
1381: END IF;
1382:
1383: EXCEPTION
1384: WHEN FND_API.G_EXC_ERROR THEN
1385: x_failure_count := x_failure_count + 1;
1386: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1387: FOR i in 1..l_msg_count LOOP
1388: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

Line 1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1401: p_db_error => NULL,
1402: p_app_short_name => 'GMI');
1403: END LOOP;
1404:
1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: x_failure_count := x_failure_count + 1;
1407: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1408: FOR i in 1..l_msg_count LOOP
1409: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));