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 3795: p_commit => FND_API.G_TRUE,

3791: p_migration_run_id => p_migration_run_id,
3792: p_item_id => i.item_id,
3793: p_organization_id => i.organization_id,
3794: p_mode => NULL,
3795: p_commit => FND_API.G_TRUE,
3796: x_inventory_item_id => l_inventory_item_id,
3797: x_failure_count => l_itm_failure_count
3798: );
3799: END IF;

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

4113: /****************************************************************
4114: * Lets save the changes now based on the commit parameter *
4115: ****************************************************************/
4116:
4117: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
4118: COMMIT;
4119: END IF;
4120:
4121: EXCEPTION

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

4617: /****************************************************************
4618: * Lets save the changes now based on the commit parameter *
4619: ****************************************************************/
4620:
4621: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
4622: COMMIT;
4623: END IF;
4624:
4625: EXCEPTION

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

4865: /****************************************************************
4866: * Lets save the changes now based on the commit parameter *
4867: ****************************************************************/
4868:
4869: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
4870: COMMIT;
4871: END IF;
4872:
4873: EXCEPTION

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

5304: /****************************************************************
5305: * Lets save the changes now based on the commit parameter *
5306: ****************************************************************/
5307:
5308: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
5309: COMMIT;
5310: END IF;
5311:
5312: EXCEPTION

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

5483: /****************************************************************
5484: * Lets save the changes now based on the commit parameter *
5485: ****************************************************************/
5486:
5487: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
5488: COMMIT;
5489: END IF;
5490:
5491: EXCEPTION

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

5864: /****************************************************************
5865: * Lets save the changes now based on the commit parameter *
5866: ****************************************************************/
5867:
5868: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
5869: COMMIT;
5870: END IF;
5871:
5872: EXCEPTION

Line 6009: p_commit => FND_API.G_TRUE,

6005: p_migration_run_id => p_migration_run_id,
6006: p_item_id => i.item_id,
6007: p_organization_id => i.organization_id,
6008: p_mode => NULL,
6009: p_commit => FND_API.G_TRUE,
6010: x_inventory_item_id => l_inventory_item_id,
6011: x_failure_count => l_itm_failure_count
6012: );
6013: END IF;

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

6196: /****************************************************************
6197: * Lets save the changes now based on the commit parameter *
6198: ****************************************************************/
6199:
6200: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
6201: COMMIT;
6202: END IF;
6203:
6204: EXCEPTION

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

6417: /****************************************************************
6418: * Lets save the changes now based on the commit parameter *
6419: ****************************************************************/
6420:
6421: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
6422: COMMIT;
6423: END IF;
6424:
6425: EXCEPTION

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

8566: xla_adr_interface_pkg.upload_rules;
8567: /****************************************************************
8568: * Lets save the changes now based on the commit parameter *
8569: ****************************************************************/
8570: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
8571: COMMIT;
8572: END IF;
8573: /************************************
8574: * ADR Rules Migration Error Logging *

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

8874: /****************************************************************
8875: * Lets save the changes now based on the commit parameter *
8876: ****************************************************************/
8877:
8878: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
8879: COMMIT;
8880: END IF;
8881:
8882: END IF;

Line 9108: p_commit => FND_API.G_TRUE,

9104: p_whse_code => bal.whse_code,
9105: p_orgn_code => NULL,
9106: /* p_location => bal.location, Bug 13942118 */
9107: p_location => NULL, /* Bug 13942118 */
9108: p_commit => FND_API.G_TRUE,
9109: x_lot_number => l_lot_number,
9110: x_parent_lot_number => l_parent_lot_number,
9111: x_failure_count => l_failure_count);
9112:

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

9386: /****************************************************************
9387: * Lets save the changes now based on the commit parameter *
9388: ****************************************************************/
9389:
9390: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9391: COMMIT;
9392: END IF;
9393:
9394: EXCEPTION

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

9652: /****************************************************************
9653: * Lets save the changes now based on the commit parameter *
9654: ****************************************************************/
9655:
9656: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9657: COMMIT;
9658: END IF;
9659:
9660: EXCEPTION

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

9846: /****************************************************************
9847: * Lets save the changes now based on the commit parameter *
9848: ****************************************************************/
9849:
9850: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
9851: COMMIT;
9852: END IF;
9853:
9854: EXCEPTION

Line 10000: p_commit => FND_API.G_TRUE,

9996: p_migration_run_id => p_migration_run_id,
9997: p_item_id => i.item_id,
9998: p_organization_id => i.organization_id,
9999: p_mode => NULL,
10000: p_commit => FND_API.G_TRUE,
10001: x_inventory_item_id => l_inventory_item_id,
10002: x_failure_count => l_itm_failure_count
10003: );
10004: END IF;

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

10109: /****************************************************************
10110: * Lets save the changes now based on the commit parameter *
10111: ****************************************************************/
10112:
10113: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10114: COMMIT;
10115: END IF;
10116:
10117: EXCEPTION

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

10426: /****************************************************************
10427: * Lets save the changes now based on the commit parameter *
10428: ****************************************************************/
10429:
10430: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10431: COMMIT;
10432: END IF;
10433:
10434: EXCEPTION

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

10610: /****************************************************************
10611: * Lets save the changes now based on the commit parameter *
10612: ****************************************************************/
10613:
10614: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10615: COMMIT;
10616: END IF;
10617:
10618: EXCEPTION

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

10840: /****************************************************************
10841: *Lets save the changes now based on the commit parameter *
10842: ****************************************************************/
10843:
10844: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
10845: COMMIT;
10846: END IF;
10847:
10848: EXCEPTION

Line 11062: p_commit => FND_API.G_TRUE,

11058: p_migration_run_id => p_migration_run_id,
11059: p_item_id => i.item_id,
11060: p_organization_id => i.organization_id,
11061: p_mode => NULL,
11062: p_commit => FND_API.G_TRUE,
11063: x_inventory_item_id => l_inventory_item_id,
11064: x_failure_count => l_failure_count
11065: );
11066: END IF;

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

11070: /****************************************************************
11071: * Lets save the changes now based on the commit parameter *
11072: ****************************************************************/
11073:
11074: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11075: COMMIT;
11076: END IF;
11077:
11078: EXCEPTION

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

11258: /****************************************************************
11259: * Lets save the changes now based on the commit parameter *
11260: ****************************************************************/
11261:
11262: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11263: COMMIT;
11264: END IF;
11265:
11266: EXCEPTION

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

11571: /****************************************************************
11572: * Lets save the changes now based on the commit parameter *
11573: ****************************************************************/
11574:
11575: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11576: COMMIT;
11577: END IF;
11578:
11579: EXCEPTION

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

11761: /****************************************************************
11762: * Lets save the changes now based on the commit parameter *
11763: ****************************************************************/
11764:
11765: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
11766: COMMIT;
11767: END IF;
11768:
11769: EXCEPTION

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

12017: /****************************************************************
12018: * Lets save the changes now based on the commit parameter *
12019: ****************************************************************/
12020:
12021: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
12022: COMMIT;
12023: END IF;
12024:
12025: EXCEPTION

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

12290: /****************************************************************
12291: * Lets save the changes now based on the commit parameter *
12292: ****************************************************************/
12293:
12294: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
12295: COMMIT;
12296: END IF;
12297:
12298: EXCEPTION

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

14756: gam.migrated_ind = 1
14757: WHERE gam.vendor_id IS NOT NULL
14758: AND nvl(gam.migrated_ind, -1) <> 1;
14759:
14760: IF NVL(p_commit,'~') = FND_API.G_TRUE THEN
14761: COMMIT;
14762: END IF;
14763: ****************************************************************************************/
14764: NULL;