APPS.INV_MIGRATE_PROCESS_ORG dependencies on FND_API

Line 325: P_commit => FND_API.G_FALSE,

321: sync_whse_subinventory (P_migration_run_id => l_migration_id,
322: P_whse_code => l_whse_code,
323: P_whse_name => l_whse_name,
324: P_organization_id => l_rec.organization_id,
325: P_commit => FND_API.G_FALSE,
326: X_failure_count => l_failure_count);
327: IF l_failure_count > 0 THEN
328: CLOSE Cur_get_whse;
329: RAISE SYNC_WHSE_ERROR;

Line 338: IF p_commit = FND_API.G_TRUE THEN

334: WHERE mtl_organization_id = l_rec.organization_id;
335: END IF;
336: CLOSE Cur_get_whse;
337: --Lets save the changes now based on the commit parameter
338: IF p_commit = FND_API.G_TRUE THEN
339: COMMIT;
340: END IF;
341: END LOOP;
342:

Line 550: IF p_commit = FND_API.G_TRUE THEN

546: NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,NULL,
547: SYSDATE,0,SYSDATE,0);
548:
549: --Lets save the changes now based on the commit parameter
550: IF p_commit = FND_API.G_TRUE THEN
551: COMMIT;
552: END IF;
553:
554: l_migrate_count := l_migrate_count + 1;

Line 693: P_commit => FND_API.G_FALSE,

689: P_segment19 => l_rec.segment19,
690: P_segment20 => l_rec.segment20,
691: P_loct_desc => l_rec.description,
692: P_start_date_active => l_rec.creation_date,
693: P_commit => FND_API.G_FALSE,
694: X_location_id => l_location_id,
695: X_failure_count => l_failure_count);
696: IF (l_failure_count > 0) THEN
697: RAISE LOCATION_FAILED;

Line 957: P_commit => FND_API.G_FALSE,

953:
954: migrate_location(P_migration_run_id => l_migration_id,
955: P_organization_id => l_organization_id,
956: P_subinventory_code => l_rec.whse_code,
957: P_commit => FND_API.G_FALSE,
958: X_location_id => l_location_id,
959: X_failure_count => l_failure_count);
960: IF l_failure_count > 0 THEN
961: CLOSE Cur_check_subinventory;

Line 1683: P_commit => FND_API.G_FALSE,

1679: WHERE orgn_code = l_rec.orgn_code;
1680:
1681: migrate_subinventory(P_migration_run_id => l_migration_id,
1682: P_orgn_code => l_rec.orgn_code,
1683: P_commit => FND_API.G_FALSE,
1684: X_failure_count => l_failure_count);
1685: IF (l_failure_count > 0) THEN
1686: RAISE WHSE_CODE_ERROR;
1687: END IF;

Line 1691: IF p_commit = FND_API.G_TRUE THEN

1687: END IF;
1688: --Bases on the p_commit flag commit the transaction.
1689: -- Fix for Bug#9143261. Moved following statements if org is being
1690: -- migrated in in-line phase
1691: IF p_commit = FND_API.G_TRUE THEN
1692: COMMIT;
1693: END IF;
1694: l_migrate_count := l_migrate_count + 1;
1695: ELSE -- Fix for Bug#9143261. Added following statements in else clause

Line 1704: IF (p_commit = FND_API.G_TRUE AND SQL%ROWCOUNT > 0 ) THEN

1700: WHERE organization_id = l_rec.organization_id
1701: AND default_status_id IS NULL ;
1702:
1703: --Bases on the p_commit flag commit the transaction.
1704: IF (p_commit = FND_API.G_TRUE AND SQL%ROWCOUNT > 0 ) THEN
1705: COMMIT;
1706: l_migrate_count := l_migrate_count + 1;
1707: END IF;
1708: END IF ;