DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on FND_API

Line 2084: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 2329: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 2492: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 2711: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 3650: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 3792: p_commit => FND_API.G_TRUE,

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;

Line 4094: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 4598: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 4846: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 5285: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 5464: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 5845: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 5986: p_commit => FND_API.G_TRUE,

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;

Line 6123: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 6344: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 8482: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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 *

Line 8790: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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;

Line 9123: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 9336: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 9530: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 9673: p_commit => FND_API.G_TRUE,

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;

Line 9786: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 10101: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 10285: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 10515: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 10731: p_commit => FND_API.G_TRUE,

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;

Line 10743: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 10931: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 11244: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 11434: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 11690: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 11963: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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

Line 14429: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN

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;