APPS.INV_OPM_LOT_MIGRATION dependencies on FND_API

Line 169: p_commit => FND_API.G_TRUE,

165: p_migration_run_id => p_migration_run_id,
166: p_item_id => p_item_id,
167: p_organization_id => p_organization_id,
168: p_mode => NULL,
169: p_commit => FND_API.G_TRUE,
170: x_inventory_item_id => l_inventory_item_id,
171: x_failure_count => x_failure_count);
172: IF (x_failure_count > 0) THEN
173: -- Log Error

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

434: p_source => NULL,
435: p_api_version => 1.0,
436: p_origin_txn_id => NULL);
437:
438: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
439: -- Log Error
440: x_failure_count := x_failure_count + 1;
441: FOR i in 1..l_msg_count LOOP
442: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

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

486: item_id = p_item_id and -- Added this to use index.
487: lot_id = p_lot_id; -- Added this to use index.
488:
489: -- Autonomous transaction commit
490: IF (p_commit <> FND_API.G_FALSE) THEN
491: COMMIT;
492: ELSE
493: ROLLBACK;
494: END IF;

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

701: -- p_lot_no => l_lot_no,
702: -- p_sublot_no => l_sublot_no,
703: -- p_organization_id => l_organization_id,
704: -- p_locator_id => l_locator_id,
705: -- p_commit => FND_API.G_TRUE,
706: -- x_lot_number => l_lot_number,
707: -- x_parent_lot_number => l_parent_lot_number,
708: -- x_failure_count => l_failure_count);
709: --

Line 1290: WHEN FND_API.G_EXC_ERROR THEN

1286: END IF;
1287: END IF;
1288:
1289: EXCEPTION
1290: WHEN FND_API.G_EXC_ERROR THEN
1291: x_failure_count := x_failure_count + 1;
1292: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1293: FOR i in 1..l_msg_count LOOP
1294: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));

Line 1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1307: p_db_error => NULL,
1308: p_app_short_name => 'GMI');
1309: END LOOP;
1310:
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_failure_count := x_failure_count + 1;
1313: FND_MSG_PUB.Count_AND_GET (p_count => l_msg_count, p_data => l_msg_data);
1314: FOR i in 1..l_msg_count LOOP
1315: -- dbms_output.put_line (substr(fnd_msg_pub.get_detail(i, NULL),1,255));