2080: /****************************************************************
2081: * Lets save the changes now based on the commit parameter *
2082: ****************************************************************/
2083:
2084: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
2085: COMMIT;
2086: END IF;
2087:
2088: EXCEPTION
2325: /****************************************************************
2326: * Lets save the changes now based on the commit parameter *
2327: ****************************************************************/
2328:
2329: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
2330: COMMIT;
2331: END IF;
2332:
2333: EXCEPTION
2488: /****************************************************************
2489: *Lets save the changes now based on the commit parameter *
2490: ****************************************************************/
2491:
2492: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
2493: COMMIT;
2494: END IF;
2495:
2496: EXCEPTION
2707: /****************************************************************
2708: *Lets save the changes now based on the commit parameter *
2709: ****************************************************************/
2710:
2711: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
2712: COMMIT;
2713: END IF;
2714:
2715: EXCEPTION
3646: /****************************************************************
3647: * Lets save the changes now based on the commit parameter *
3648: ****************************************************************/
3649:
3650: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
3651: COMMIT;
3652: END IF;
3653:
3654: EXCEPTION
3788: p_migration_run_id => p_migration_run_id,
3789: p_item_id => i.item_id,
3790: p_organization_id => i.organization_id,
3791: p_mode => NULL,
3792: p_commit => FND_API.G_TRUE,
3793: x_inventory_item_id => l_inventory_item_id,
3794: x_failure_count => l_itm_failure_count
3795: );
3796: END IF;
4090: /****************************************************************
4091: * Lets save the changes now based on the commit parameter *
4092: ****************************************************************/
4093:
4094: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
4095: COMMIT;
4096: END IF;
4097:
4098: EXCEPTION
4594: /****************************************************************
4595: * Lets save the changes now based on the commit parameter *
4596: ****************************************************************/
4597:
4598: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
4599: COMMIT;
4600: END IF;
4601:
4602: EXCEPTION
4842: /****************************************************************
4843: * Lets save the changes now based on the commit parameter *
4844: ****************************************************************/
4845:
4846: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
4847: COMMIT;
4848: END IF;
4849:
4850: EXCEPTION
5281: /****************************************************************
5282: * Lets save the changes now based on the commit parameter *
5283: ****************************************************************/
5284:
5285: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
5286: COMMIT;
5287: END IF;
5288:
5289: EXCEPTION
5460: /****************************************************************
5461: * Lets save the changes now based on the commit parameter *
5462: ****************************************************************/
5463:
5464: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
5465: COMMIT;
5466: END IF;
5467:
5468: EXCEPTION
5841: /****************************************************************
5842: * Lets save the changes now based on the commit parameter *
5843: ****************************************************************/
5844:
5845: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
5846: COMMIT;
5847: END IF;
5848:
5849: EXCEPTION
5982: p_migration_run_id => p_migration_run_id,
5983: p_item_id => i.item_id,
5984: p_organization_id => i.organization_id,
5985: p_mode => NULL,
5986: p_commit => FND_API.G_TRUE,
5987: x_inventory_item_id => l_inventory_item_id,
5988: x_failure_count => l_itm_failure_count
5989: );
5990: END IF;
6119: /****************************************************************
6120: * Lets save the changes now based on the commit parameter *
6121: ****************************************************************/
6122:
6123: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
6124: COMMIT;
6125: END IF;
6126:
6127: EXCEPTION
6340: /****************************************************************
6341: * Lets save the changes now based on the commit parameter *
6342: ****************************************************************/
6343:
6344: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
6345: COMMIT;
6346: END IF;
6347:
6348: EXCEPTION
8478: xla_adr_interface_pkg.upload_rules;
8479: /****************************************************************
8480: * Lets save the changes now based on the commit parameter *
8481: ****************************************************************/
8482: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
8483: COMMIT;
8484: END IF;
8485: /************************************
8486: * ADR Rules Migration Error Logging *
8786: /****************************************************************
8787: * Lets save the changes now based on the commit parameter *
8788: ****************************************************************/
8789:
8790: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
8791: COMMIT;
8792: END IF;
8793:
8794: END IF;
9119: /****************************************************************
9120: * Lets save the changes now based on the commit parameter *
9121: ****************************************************************/
9122:
9123: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9124: COMMIT;
9125: END IF;
9126:
9127: EXCEPTION
9332: /****************************************************************
9333: * Lets save the changes now based on the commit parameter *
9334: ****************************************************************/
9335:
9336: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9337: COMMIT;
9338: END IF;
9339:
9340: EXCEPTION
9526: /****************************************************************
9527: * Lets save the changes now based on the commit parameter *
9528: ****************************************************************/
9529:
9530: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9531: COMMIT;
9532: END IF;
9533:
9534: EXCEPTION
9669: p_migration_run_id => p_migration_run_id,
9670: p_item_id => i.item_id,
9671: p_organization_id => i.organization_id,
9672: p_mode => NULL,
9673: p_commit => FND_API.G_TRUE,
9674: x_inventory_item_id => l_inventory_item_id,
9675: x_failure_count => l_itm_failure_count
9676: );
9677: END IF;
9782: /****************************************************************
9783: * Lets save the changes now based on the commit parameter *
9784: ****************************************************************/
9785:
9786: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9787: COMMIT;
9788: END IF;
9789:
9790: EXCEPTION
10097: /****************************************************************
10098: * Lets save the changes now based on the commit parameter *
10099: ****************************************************************/
10100:
10101: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10102: COMMIT;
10103: END IF;
10104:
10105: EXCEPTION
10281: /****************************************************************
10282: * Lets save the changes now based on the commit parameter *
10283: ****************************************************************/
10284:
10285: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10286: COMMIT;
10287: END IF;
10288:
10289: EXCEPTION
10511: /****************************************************************
10512: *Lets save the changes now based on the commit parameter *
10513: ****************************************************************/
10514:
10515: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10516: COMMIT;
10517: END IF;
10518:
10519: EXCEPTION
10727: p_migration_run_id => p_migration_run_id,
10728: p_item_id => i.item_id,
10729: p_organization_id => i.organization_id,
10730: p_mode => NULL,
10731: p_commit => FND_API.G_TRUE,
10732: x_inventory_item_id => l_inventory_item_id,
10733: x_failure_count => l_failure_count
10734: );
10735: END IF;
10739: /****************************************************************
10740: * Lets save the changes now based on the commit parameter *
10741: ****************************************************************/
10742:
10743: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10744: COMMIT;
10745: END IF;
10746:
10747: EXCEPTION
10927: /****************************************************************
10928: * Lets save the changes now based on the commit parameter *
10929: ****************************************************************/
10930:
10931: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10932: COMMIT;
10933: END IF;
10934:
10935: EXCEPTION
11240: /****************************************************************
11241: * Lets save the changes now based on the commit parameter *
11242: ****************************************************************/
11243:
11244: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11245: COMMIT;
11246: END IF;
11247:
11248: EXCEPTION
11430: /****************************************************************
11431: * Lets save the changes now based on the commit parameter *
11432: ****************************************************************/
11433:
11434: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11435: COMMIT;
11436: END IF;
11437:
11438: EXCEPTION
11686: /****************************************************************
11687: * Lets save the changes now based on the commit parameter *
11688: ****************************************************************/
11689:
11690: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11691: COMMIT;
11692: END IF;
11693:
11694: EXCEPTION
11959: /****************************************************************
11960: * Lets save the changes now based on the commit parameter *
11961: ****************************************************************/
11962:
11963: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11964: COMMIT;
11965: END IF;
11966:
11967: EXCEPTION
14425: gam.migrated_ind = 1
14426: WHERE gam.vendor_id IS NOT NULL
14427: AND nvl(gam.migrated_ind, -1) <> 1;
14428:
14429: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
14430: COMMIT;
14431: END IF;
14432: ****************************************************************************************/
14433: NULL;