eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_MTI_PUB dependencies on FND_MESSAGE

Line 210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');

206: wip_logger.log('uom conversion failed.', l_returnStatus);
207: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
208: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
209: end if;
210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
211: l_errExp := fnd_message.get;
212: update mtl_transactions_interface
213: set last_update_date = sysdate,
214: last_updated_by = fnd_global.user_id,

Line 211: l_errExp := fnd_message.get;

207: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
208: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
209: end if;
210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
211: l_errExp := fnd_message.get;
212: update mtl_transactions_interface
213: set last_update_date = sysdate,
214: last_updated_by = fnd_global.user_id,
215: last_update_login = fnd_global.login_id,

Line 452: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');

448: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
449: raise fnd_api.g_exc_error;
450: end if;
451: if(l_lsRequired = wip_constants.yes) then
452: fnd_message.set_name('WIP', 'WIP_NO_LOT_SER_COMP_BKGND');
453: fnd_msg_pub.add;
454: raise fnd_api.g_exc_error;
455: end if;
456:

Line 717: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');

713: end if;
714:
715:
716: if ( not l_success ) then
717: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
718: setMtiError(pt_rec.transaction_interface_id,
719: 'locator_id',
720: fnd_message.get);
721: end if;

Line 720: fnd_message.get);

716: if ( not l_success ) then
717: fnd_message.set_name('INV', 'INV_INT_LOCSEGCODE');
718: setMtiError(pt_rec.transaction_interface_id,
719: 'locator_id',
720: fnd_message.get);
721: end if;
722:
723: end if;
724:

Line 789: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

785: -- for the parent record. We don't do that for scrap
786: validateLocatorForProject(p_txnHeaderID);
787:
788: -- check if it is an assembly completion/return for lot based job. If so error out
789: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
790: fnd_message.set_token('ENTITY', 'Transactions');
791: l_errMsg := substrb(fnd_message.get, 1, 240);
792: update mtl_transactions_interface mti
793: set last_update_date = sysdate,

Line 790: fnd_message.set_token('ENTITY', 'Transactions');

786: validateLocatorForProject(p_txnHeaderID);
787:
788: -- check if it is an assembly completion/return for lot based job. If so error out
789: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
790: fnd_message.set_token('ENTITY', 'Transactions');
791: l_errMsg := substrb(fnd_message.get, 1, 240);
792: update mtl_transactions_interface mti
793: set last_update_date = sysdate,
794: last_updated_by = fnd_global.user_id,

Line 791: l_errMsg := substrb(fnd_message.get, 1, 240);

787:
788: -- check if it is an assembly completion/return for lot based job. If so error out
789: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
790: fnd_message.set_token('ENTITY', 'Transactions');
791: l_errMsg := substrb(fnd_message.get, 1, 240);
792: update mtl_transactions_interface mti
793: set last_update_date = sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id,

Line 811: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

807: and transaction_type_id in (44, 17)
808: and wip_entity_type = 5;
809:
810: -- check existence of line for repetitive schedules, job and flow schedule
811: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
812: fnd_message.set_token('ENTITY', 'line');
813: l_errMsg := substrb(fnd_message.get, 1, 240);
814: update mtl_transactions_interface mti
815: set last_update_date = sysdate,

Line 812: fnd_message.set_token('ENTITY', 'line');

808: and wip_entity_type = 5;
809:
810: -- check existence of line for repetitive schedules, job and flow schedule
811: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
812: fnd_message.set_token('ENTITY', 'line');
813: l_errMsg := substrb(fnd_message.get, 1, 240);
814: update mtl_transactions_interface mti
815: set last_update_date = sysdate,
816: last_updated_by = fnd_global.user_id,

Line 813: l_errMsg := substrb(fnd_message.get, 1, 240);

809:
810: -- check existence of line for repetitive schedules, job and flow schedule
811: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
812: fnd_message.set_token('ENTITY', 'line');
813: l_errMsg := substrb(fnd_message.get, 1, 240);
814: update mtl_transactions_interface mti
815: set last_update_date = sysdate,
816: last_updated_by = fnd_global.user_id,
817: last_update_login = fnd_global.login_id,

Line 842: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');

838: where wl.line_id = mti.repetitive_line_id
839: and wl.organization_id = mti.organization_id)));
840:
841: -- check valid line for assembly
842: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
843: l_errMsg := substrb(fnd_message.get, 1, 240);
844: update mtl_transactions_interface mti
845: set last_update_date = sysdate,
846: last_updated_by = fnd_global.user_id,

Line 843: l_errMsg := substrb(fnd_message.get, 1, 240);

839: and wl.organization_id = mti.organization_id)));
840:
841: -- check valid line for assembly
842: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
843: l_errMsg := substrb(fnd_message.get, 1, 240);
844: update mtl_transactions_interface mti
845: set last_update_date = sysdate,
846: last_updated_by = fnd_global.user_id,
847: last_update_login = fnd_global.login_id,

Line 868: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');

864: and wri.organization_id = mti.organization_id);
865:
866:
867: -- check that job/schedule, etc. is transactable, flow is checked before
868: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
869: l_errMsg := substrb(fnd_message.get, 1, 240);
870: update mtl_transactions_interface mti
871: set last_update_date = sysdate,
872: last_updated_by = fnd_global.user_id,

Line 869: l_errMsg := substrb(fnd_message.get, 1, 240);

865:
866:
867: -- check that job/schedule, etc. is transactable, flow is checked before
868: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
869: l_errMsg := substrb(fnd_message.get, 1, 240);
870: update mtl_transactions_interface mti
871: set last_update_date = sysdate,
872: last_updated_by = fnd_global.user_id,
873: last_update_login = fnd_global.login_id,

Line 903: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');

899:
900:
901: -- check to see if job/flow has an assembly associated with it
902: -- validate this only for completion transactions
903: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');
904: l_errMsg := substrb(fnd_message.get, 1, 240);
905: update mtl_transactions_interface mti
906: set last_update_date = sysdate,
907: last_updated_by = fnd_global.user_id,

Line 904: l_errMsg := substrb(fnd_message.get, 1, 240);

900:
901: -- check to see if job/flow has an assembly associated with it
902: -- validate this only for completion transactions
903: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');
904: l_errMsg := substrb(fnd_message.get, 1, 240);
905: update mtl_transactions_interface mti
906: set last_update_date = sysdate,
907: last_updated_by = fnd_global.user_id,
908: last_update_login = fnd_global.login_id,

Line 1012: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');

1008: WIP_CONSTANTS.RETCOMP_ACTION);
1009:
1010: -- Added Additional Validation of Operation Disable Date for Lot based jobs for Bug 14065582.
1011: -- validate operation seq num
1012: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
1013: l_errMsg := substrb(fnd_message.get, 1, 240);
1014: update mtl_transactions_interface mti
1015: set last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,

Line 1013: l_errMsg := substrb(fnd_message.get, 1, 240);

1009:
1010: -- Added Additional Validation of Operation Disable Date for Lot based jobs for Bug 14065582.
1011: -- validate operation seq num
1012: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
1013: l_errMsg := substrb(fnd_message.get, 1, 240);
1014: update mtl_transactions_interface mti
1015: set last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.login_id,

Line 1047: fnd_message.set_name('WIP', 'WIP_ITEM_NOT_TRANSACTABLE');

1043: or ( mti.wip_entity_type = 2 and wo.repetitive_schedule_id = mti.schedule_id)));
1044:
1045:
1046: -- check item transactable
1047: fnd_message.set_name('WIP', 'WIP_ITEM_NOT_TRANSACTABLE');
1048: l_errMsg := substrb(fnd_message.get, 1, 240);
1049: begin
1050: l_engItemFlag := to_number(fnd_profile.value('WIP_SEE_ENG_ITEMS'));
1051: exception

Line 1048: l_errMsg := substrb(fnd_message.get, 1, 240);

1044:
1045:
1046: -- check item transactable
1047: fnd_message.set_name('WIP', 'WIP_ITEM_NOT_TRANSACTABLE');
1048: l_errMsg := substrb(fnd_message.get, 1, 240);
1049: begin
1050: l_engItemFlag := to_number(fnd_profile.value('WIP_SEE_ENG_ITEMS'));
1051: exception
1052: when others then

Line 1151: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');

1147: and wsfsc.status_move_flag = WIP_CONSTANTS.NO
1148: and nvl(wsfsc.disable_date, sysdate+1) > sysdate
1149: and rownum = 1;
1150:
1151: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1152: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1153: l_errMsg := substrb(fnd_message.get, 1, 240);
1154:
1155: update mtl_transactions_interface mti

Line 1152: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

1148: and nvl(wsfsc.disable_date, sysdate+1) > sysdate
1149: and rownum = 1;
1150:
1151: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1152: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1153: l_errMsg := substrb(fnd_message.get, 1, 240);
1154:
1155: update mtl_transactions_interface mti
1156: set last_update_date = sysdate,

Line 1153: l_errMsg := substrb(fnd_message.get, 1, 240);

1149: and rownum = 1;
1150:
1151: fnd_message.set_name('WIP', 'WIP_SF_STATUS_NO_TXN2');
1152: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));
1153: l_errMsg := substrb(fnd_message.get, 1, 240);
1154:
1155: update mtl_transactions_interface mti
1156: set last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,

Line 1173: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

1169: end loop;
1170: end if;
1171:
1172: -- check for valid final completion flag, this is not required for flow schedules
1173: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1174: fnd_message.set_token('ENTITY', 'final_completion_flag');
1175: l_errMsg := substrb(fnd_message.get, 1, 240);
1176: update mtl_transactions_interface mti
1177: set last_update_date = sysdate,

Line 1174: fnd_message.set_token('ENTITY', 'final_completion_flag');

1170: end if;
1171:
1172: -- check for valid final completion flag, this is not required for flow schedules
1173: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1174: fnd_message.set_token('ENTITY', 'final_completion_flag');
1175: l_errMsg := substrb(fnd_message.get, 1, 240);
1176: update mtl_transactions_interface mti
1177: set last_update_date = sysdate,
1178: last_updated_by = fnd_global.user_id,

Line 1175: l_errMsg := substrb(fnd_message.get, 1, 240);

1171:
1172: -- check for valid final completion flag, this is not required for flow schedules
1173: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
1174: fnd_message.set_token('ENTITY', 'final_completion_flag');
1175: l_errMsg := substrb(fnd_message.get, 1, 240);
1176: update mtl_transactions_interface mti
1177: set last_update_date = sysdate,
1178: last_updated_by = fnd_global.user_id,
1179: last_update_login = fnd_global.login_id,

Line 1300: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');

1296: and flow_schedule = 'Y';
1297:
1298:
1299: -- validate revision for completion/return/scrap
1300: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1301: l_errMsg := substrb(fnd_message.get, 1, 240);
1302: update mtl_transactions_interface mti
1303: set last_update_date = sysdate,
1304: last_updated_by = fnd_global.user_id,

Line 1301: l_errMsg := substrb(fnd_message.get, 1, 240);

1297:
1298:
1299: -- validate revision for completion/return/scrap
1300: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1301: l_errMsg := substrb(fnd_message.get, 1, 240);
1302: update mtl_transactions_interface mti
1303: set last_update_date = sysdate,
1304: last_updated_by = fnd_global.user_id,
1305: last_update_login = fnd_global.login_id,

Line 1377: fnd_message.set_name('WIP', 'INV_INT_REVCODE');

1373: /* Fixed Performance bug 4890679 -
1374: Replaced bom_bill_released_revisions_v with base tables
1375: by removing the group by clauses
1376: which was causing non mergeable views */
1377: fnd_message.set_name('WIP', 'INV_INT_REVCODE');
1378: l_errMsg := substrb(fnd_message.get, 1, 240);
1379: update mtl_transactions_interface mti
1380: set last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,

Line 1378: l_errMsg := substrb(fnd_message.get, 1, 240);

1374: Replaced bom_bill_released_revisions_v with base tables
1375: by removing the group by clauses
1376: which was causing non mergeable views */
1377: fnd_message.set_name('WIP', 'INV_INT_REVCODE');
1378: l_errMsg := substrb(fnd_message.get, 1, 240);
1379: update mtl_transactions_interface mti
1380: set last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id,

Line 1452: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

1448: -- validate transaction qty for wip completions.
1449: -- if there is no routing, then can over complete
1450: -- we do allow overcomplete for flow schedules, so we don't need to validation
1451: -- it for flow.
1452: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1453: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1454: fnd_message.set_token('ENTITY2', 'qty avail to complete');
1455: l_errMsg := substrb(fnd_message.get, 1, 240);
1456: update mtl_transactions_interface mti

Line 1453: fnd_message.set_token('ENTITY1', 'total txn qty-cap');

1449: -- if there is no routing, then can over complete
1450: -- we do allow overcomplete for flow schedules, so we don't need to validation
1451: -- it for flow.
1452: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1453: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1454: fnd_message.set_token('ENTITY2', 'qty avail to complete');
1455: l_errMsg := substrb(fnd_message.get, 1, 240);
1456: update mtl_transactions_interface mti
1457: set last_update_date = sysdate,

Line 1454: fnd_message.set_token('ENTITY2', 'qty avail to complete');

1450: -- we do allow overcomplete for flow schedules, so we don't need to validation
1451: -- it for flow.
1452: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1453: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1454: fnd_message.set_token('ENTITY2', 'qty avail to complete');
1455: l_errMsg := substrb(fnd_message.get, 1, 240);
1456: update mtl_transactions_interface mti
1457: set last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,

Line 1455: l_errMsg := substrb(fnd_message.get, 1, 240);

1451: -- it for flow.
1452: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1453: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1454: fnd_message.set_token('ENTITY2', 'qty avail to complete');
1455: l_errMsg := substrb(fnd_message.get, 1, 240);
1456: update mtl_transactions_interface mti
1457: set last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,

Line 1496: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');

1492: -- validate transaction qty for returns against jobs.
1493: -- 1. This is done only for scheduled flow completions
1494: -- 2. according to the comments in inltwv, mmodi, jgu, nsyed, dssosai decided to
1495: -- drive the completed qty negative for flow schedules
1496: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1497: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1498: fnd_message.set_token('ENTITY2', 'job compelete quantity');
1499: l_errMsg := substrb(fnd_message.get, 1, 240);
1500: update mtl_transactions_interface mti

Line 1497: fnd_message.set_token('ENTITY1', 'total txn qty-cap');

1493: -- 1. This is done only for scheduled flow completions
1494: -- 2. according to the comments in inltwv, mmodi, jgu, nsyed, dssosai decided to
1495: -- drive the completed qty negative for flow schedules
1496: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1497: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1498: fnd_message.set_token('ENTITY2', 'job compelete quantity');
1499: l_errMsg := substrb(fnd_message.get, 1, 240);
1500: update mtl_transactions_interface mti
1501: set last_update_date = sysdate,

Line 1498: fnd_message.set_token('ENTITY2', 'job compelete quantity');

1494: -- 2. according to the comments in inltwv, mmodi, jgu, nsyed, dssosai decided to
1495: -- drive the completed qty negative for flow schedules
1496: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1497: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1498: fnd_message.set_token('ENTITY2', 'job compelete quantity');
1499: l_errMsg := substrb(fnd_message.get, 1, 240);
1500: update mtl_transactions_interface mti
1501: set last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,

Line 1499: l_errMsg := substrb(fnd_message.get, 1, 240);

1495: -- drive the completed qty negative for flow schedules
1496: fnd_message.set_name('WIP', 'WIP_LESS_OR_EQUAL');
1497: fnd_message.set_token('ENTITY1', 'total txn qty-cap');
1498: fnd_message.set_token('ENTITY2', 'job compelete quantity');
1499: l_errMsg := substrb(fnd_message.get, 1, 240);
1500: update mtl_transactions_interface mti
1501: set last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id,

Line 1531: fnd_message.set_name('WIP', 'WIP_NO_ASSET_ITEM_MOVE');

1527: exception
1528: when others then
1529: l_poExpToAssetTnsf := 2;
1530: end;
1531: fnd_message.set_name('WIP', 'WIP_NO_ASSET_ITEM_MOVE');
1532: l_errMsg := substrb(fnd_message.get, 1, 240);
1533: update mtl_transactions_interface mti
1534: set last_update_date = sysdate,
1535: last_updated_by = fnd_global.user_id,

Line 1532: l_errMsg := substrb(fnd_message.get, 1, 240);

1528: when others then
1529: l_poExpToAssetTnsf := 2;
1530: end;
1531: fnd_message.set_name('WIP', 'WIP_NO_ASSET_ITEM_MOVE');
1532: l_errMsg := substrb(fnd_message.get, 1, 240);
1533: update mtl_transactions_interface mti
1534: set last_update_date = sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id,

Line 1571: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');

1567: and sub.quantity_tracked = 1 )));
1568:
1569:
1570: -- transaction must occure after job/schedule is released.
1571: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');
1572: l_errMsg := substrb(fnd_message.get, 1, 240);
1573: update mtl_transactions_interface mti
1574: set last_update_date = sysdate,
1575: last_updated_by = fnd_global.user_id,

Line 1572: l_errMsg := substrb(fnd_message.get, 1, 240);

1568:
1569:
1570: -- transaction must occure after job/schedule is released.
1571: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');
1572: l_errMsg := substrb(fnd_message.get, 1, 240);
1573: update mtl_transactions_interface mti
1574: set last_update_date = sysdate,
1575: last_updated_by = fnd_global.user_id,
1576: last_update_login = fnd_global.login_id,

Line 1607: fnd_message.set_name('WIP', 'WIP_INVALID_SO');

1603:
1604:
1605: -- validate sales order demand for completions and returns
1606: -- **** do we need to do that for flow? ****
1607: fnd_message.set_name('WIP', 'WIP_INVALID_SO');
1608: l_errMsg := substrb(fnd_message.get, 1, 240);
1609: update mtl_transactions_interface mti
1610: set last_update_date = sysdate,
1611: last_updated_by = fnd_global.user_id,

Line 1608: l_errMsg := substrb(fnd_message.get, 1, 240);

1604:
1605: -- validate sales order demand for completions and returns
1606: -- **** do we need to do that for flow? ****
1607: fnd_message.set_name('WIP', 'WIP_INVALID_SO');
1608: l_errMsg := substrb(fnd_message.get, 1, 240);
1609: update mtl_transactions_interface mti
1610: set last_update_date = sysdate,
1611: last_updated_by = fnd_global.user_id,
1612: last_update_login = fnd_global.login_id,

Line 1644: fnd_message.set_name('WIP', 'WIP_INVALID_SO_LINE');

1640: and subinventory_code = mti.subinventory_code
1641: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1642:
1643: -- validate demand so line
1644: fnd_message.set_name('WIP', 'WIP_INVALID_SO_LINE');
1645: l_errMsg := substrb(fnd_message.get, 1, 240);
1646: update mtl_transactions_interface mti
1647: set last_update_date = sysdate,
1648: last_updated_by = fnd_global.user_id,

Line 1645: l_errMsg := substrb(fnd_message.get, 1, 240);

1641: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1642:
1643: -- validate demand so line
1644: fnd_message.set_name('WIP', 'WIP_INVALID_SO_LINE');
1645: l_errMsg := substrb(fnd_message.get, 1, 240);
1646: update mtl_transactions_interface mti
1647: set last_update_date = sysdate,
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,

Line 1685: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_COMP');

1681: and nvl(locator_id, -1) = nvl(mti.locator_id, -1) )));
1682:
1683:
1684: -- validate demand so shipment number for completions
1685: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_COMP');
1686: l_errMsg := substrb(fnd_message.get, 1, 240);
1687: update mtl_transactions_interface mti
1688: set last_update_date = sysdate,
1689: last_updated_by = fnd_global.user_id,

Line 1686: l_errMsg := substrb(fnd_message.get, 1, 240);

1682:
1683:
1684: -- validate demand so shipment number for completions
1685: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_COMP');
1686: l_errMsg := substrb(fnd_message.get, 1, 240);
1687: update mtl_transactions_interface mti
1688: set last_update_date = sysdate,
1689: last_updated_by = fnd_global.user_id,
1690: last_update_login = fnd_global.login_id,

Line 1722: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_RET');

1718: and primary_reservation_quantity >= mti.primary_quantity);
1719:
1720:
1721: -- validate demand so shipment number for returns
1722: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_RET');
1723: l_errMsg := substrb(fnd_message.get, 1, 240);
1724: update mtl_transactions_interface mti
1725: set last_update_date = sysdate,
1726: last_updated_by = fnd_global.user_id,

Line 1723: l_errMsg := substrb(fnd_message.get, 1, 240);

1719:
1720:
1721: -- validate demand so shipment number for returns
1722: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_RET');
1723: l_errMsg := substrb(fnd_message.get, 1, 240);
1724: update mtl_transactions_interface mti
1725: set last_update_date = sysdate,
1726: last_updated_by = fnd_global.user_id,
1727: last_update_login = fnd_global.login_id,

Line 1762: fnd_message.set_name('WIP', 'WIP_KB_ILLEGAL_CARD');

1758:
1759: -- validate the kanban card
1760: -- check that a completion txn does not have both, a kanban card and a sales
1761: -- order attached. Also only a completion txn can have a kanban card attached
1762: fnd_message.set_name('WIP', 'WIP_KB_ILLEGAL_CARD');
1763: l_errMsg := substrb(fnd_message.get, 1, 240);
1764: update mtl_transactions_interface mti
1765: set last_update_date = sysdate,
1766: last_updated_by = fnd_global.user_id,

Line 1763: l_errMsg := substrb(fnd_message.get, 1, 240);

1759: -- validate the kanban card
1760: -- check that a completion txn does not have both, a kanban card and a sales
1761: -- order attached. Also only a completion txn can have a kanban card attached
1762: fnd_message.set_name('WIP', 'WIP_KB_ILLEGAL_CARD');
1763: l_errMsg := substrb(fnd_message.get, 1, 240);
1764: update mtl_transactions_interface mti
1765: set last_update_date = sysdate,
1766: last_updated_by = fnd_global.user_id,
1767: last_update_login = fnd_global.login_id,

Line 1789: fnd_message.set_name('WIP', 'WIP_KB_CPL_SUB_LOC_MISMATCH');

1785:
1786: -- validate the kanban card
1787: -- check that the completion subinv, locator, inventory_item_id of the
1788: -- completion txn against the kanban card
1789: fnd_message.set_name('WIP', 'WIP_KB_CPL_SUB_LOC_MISMATCH');
1790: l_errMsg := substrb(fnd_message.get, 1, 240);
1791: update mtl_transactions_interface mti
1792: set last_update_date = sysdate,
1793: last_updated_by = fnd_global.user_id,

Line 1790: l_errMsg := substrb(fnd_message.get, 1, 240);

1786: -- validate the kanban card
1787: -- check that the completion subinv, locator, inventory_item_id of the
1788: -- completion txn against the kanban card
1789: fnd_message.set_name('WIP', 'WIP_KB_CPL_SUB_LOC_MISMATCH');
1790: l_errMsg := substrb(fnd_message.get, 1, 240);
1791: update mtl_transactions_interface mti
1792: set last_update_date = sysdate,
1793: last_updated_by = fnd_global.user_id,
1794: last_update_login = fnd_global.login_id,

Line 1820: fnd_message.set_name('WIP', 'WIP_KB_CPL_STATUS_ILLEGAL');

1816:
1817:
1818: -- validate the kanban card.
1819: -- check the status of the kanban card
1820: fnd_message.set_name('WIP', 'WIP_KB_CPL_STATUS_ILLEGAL');
1821: l_errMsg := substrb(fnd_message.get, 1, 240);
1822: update mtl_transactions_interface mti
1823: set last_update_date = sysdate,
1824: last_updated_by = fnd_global.user_id,

Line 1821: l_errMsg := substrb(fnd_message.get, 1, 240);

1817:
1818: -- validate the kanban card.
1819: -- check the status of the kanban card
1820: fnd_message.set_name('WIP', 'WIP_KB_CPL_STATUS_ILLEGAL');
1821: l_errMsg := substrb(fnd_message.get, 1, 240);
1822: update mtl_transactions_interface mti
1823: set last_update_date = sysdate,
1824: last_updated_by = fnd_global.user_id,
1825: last_update_login = fnd_global.login_id,

Line 1855: fnd_message.set_name('WIP', 'WIP_INVALID_NEG_REQ_FLAG');

1851: mti.transaction_source_id))));
1852:
1853: -- validate negative requirement flag for rep scheds
1854: -- this is not required for flow
1855: fnd_message.set_name('WIP', 'WIP_INVALID_NEG_REQ_FLAG');
1856: l_errMsg := substrb(fnd_message.get, 1, 240);
1857: update mtl_transactions_interface mti
1858: set last_update_date = sysdate,
1859: last_updated_by = fnd_global.user_id,

Line 1856: l_errMsg := substrb(fnd_message.get, 1, 240);

1852:
1853: -- validate negative requirement flag for rep scheds
1854: -- this is not required for flow
1855: fnd_message.set_name('WIP', 'WIP_INVALID_NEG_REQ_FLAG');
1856: l_errMsg := substrb(fnd_message.get, 1, 240);
1857: update mtl_transactions_interface mti
1858: set last_update_date = sysdate,
1859: last_updated_by = fnd_global.user_id,
1860: last_update_login = fnd_global.login_id,

Line 1884: fnd_message.set_name('WIP', 'WIP_NO_SERIALIZED_JOB_ALLOW');

1880: end if;
1881:
1882: -- for discrete job, we do not support background transactions for
1883: -- serialized job
1884: fnd_message.set_name('WIP', 'WIP_NO_SERIALIZED_JOB_ALLOW');
1885: l_errMsg := substrb(fnd_message.get, 1, 240);
1886: update mtl_transactions_interface mti
1887: set last_update_date = sysdate,
1888: last_updated_by = fnd_global.user_id,

Line 1885: l_errMsg := substrb(fnd_message.get, 1, 240);

1881:
1882: -- for discrete job, we do not support background transactions for
1883: -- serialized job
1884: fnd_message.set_name('WIP', 'WIP_NO_SERIALIZED_JOB_ALLOW');
1885: l_errMsg := substrb(fnd_message.get, 1, 240);
1886: update mtl_transactions_interface mti
1887: set last_update_date = sysdate,
1888: last_updated_by = fnd_global.user_id,
1889: last_update_login = fnd_global.login_id,

Line 2161: fnd_message.set_name('INV', 'INV_INT_ORGCODE');

2157: and transaction_source_type_id = 5;
2158:
2159:
2160: -- validate organization id
2161: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2162: l_errCode := substrb(fnd_message.get, 1, 240);
2163: fnd_message.set_name('INV', 'INV_INT_ORGEXP');
2164: l_errMsg := substrb(fnd_message.get, 1, 240);
2165: update mtl_transactions_interface mti

Line 2162: l_errCode := substrb(fnd_message.get, 1, 240);

2158:
2159:
2160: -- validate organization id
2161: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2162: l_errCode := substrb(fnd_message.get, 1, 240);
2163: fnd_message.set_name('INV', 'INV_INT_ORGEXP');
2164: l_errMsg := substrb(fnd_message.get, 1, 240);
2165: update mtl_transactions_interface mti
2166: set last_update_date = sysdate,

Line 2163: fnd_message.set_name('INV', 'INV_INT_ORGEXP');

2159:
2160: -- validate organization id
2161: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2162: l_errCode := substrb(fnd_message.get, 1, 240);
2163: fnd_message.set_name('INV', 'INV_INT_ORGEXP');
2164: l_errMsg := substrb(fnd_message.get, 1, 240);
2165: update mtl_transactions_interface mti
2166: set last_update_date = sysdate,
2167: last_updated_by = fnd_global.user_id,

Line 2164: l_errMsg := substrb(fnd_message.get, 1, 240);

2160: -- validate organization id
2161: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
2162: l_errCode := substrb(fnd_message.get, 1, 240);
2163: fnd_message.set_name('INV', 'INV_INT_ORGEXP');
2164: l_errMsg := substrb(fnd_message.get, 1, 240);
2165: update mtl_transactions_interface mti
2166: set last_update_date = sysdate,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id,

Line 2187: fnd_message.set_name('WIP', 'WIP_INVALID_FLOW_SCHED_FLAG');

2183: and nvl(ood.disable_date, sysdate+1) > sysdate);
2184:
2185:
2186: --validate scheduled_flag
2187: fnd_message.set_name('WIP', 'WIP_INVALID_FLOW_SCHED_FLAG');
2188: l_errMsg := substrb(fnd_message.get, 1, 240);
2189: update mtl_transactions_interface mti
2190: set last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,

Line 2188: l_errMsg := substrb(fnd_message.get, 1, 240);

2184:
2185:
2186: --validate scheduled_flag
2187: fnd_message.set_name('WIP', 'WIP_INVALID_FLOW_SCHED_FLAG');
2188: l_errMsg := substrb(fnd_message.get, 1, 240);
2189: update mtl_transactions_interface mti
2190: set last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id,

Line 2213: fnd_message.set_name('WIP', 'WIP_NOT_VALID');

2209:
2210:
2211: -- validate transaction source name if provided, we won't do
2212: -- the validation for that if id is provided since id overrides name anyway
2213: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2214: fnd_message.set_token('ENTITY', 'transaction_source_name');
2215: l_errMsg := substrb(fnd_message.get, 1, 240);
2216: update mtl_transactions_interface mti
2217: set last_update_date = sysdate,

Line 2214: fnd_message.set_token('ENTITY', 'transaction_source_name');

2210:
2211: -- validate transaction source name if provided, we won't do
2212: -- the validation for that if id is provided since id overrides name anyway
2213: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2214: fnd_message.set_token('ENTITY', 'transaction_source_name');
2215: l_errMsg := substrb(fnd_message.get, 1, 240);
2216: update mtl_transactions_interface mti
2217: set last_update_date = sysdate,
2218: last_updated_by = fnd_global.user_id,

Line 2215: l_errMsg := substrb(fnd_message.get, 1, 240);

2211: -- validate transaction source name if provided, we won't do
2212: -- the validation for that if id is provided since id overrides name anyway
2213: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
2214: fnd_message.set_token('ENTITY', 'transaction_source_name');
2215: l_errMsg := substrb(fnd_message.get, 1, 240);
2216: update mtl_transactions_interface mti
2217: set last_update_date = sysdate,
2218: last_updated_by = fnd_global.user_id,
2219: last_update_login = fnd_global.login_id,

Line 2260: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');

2256: and transaction_source_id is null;
2257:
2258:
2259: -- validate transaction action
2260: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
2261: l_errCode := substrb(fnd_message.get, 1, 240);
2262: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');
2263: l_errMsg := substrb(fnd_message.get, 1, 240);
2264: update mtl_transactions_interface mti

Line 2261: l_errCode := substrb(fnd_message.get, 1, 240);

2257:
2258:
2259: -- validate transaction action
2260: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
2261: l_errCode := substrb(fnd_message.get, 1, 240);
2262: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');
2263: l_errMsg := substrb(fnd_message.get, 1, 240);
2264: update mtl_transactions_interface mti
2265: set last_update_date = sysdate,

Line 2262: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');

2258:
2259: -- validate transaction action
2260: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
2261: l_errCode := substrb(fnd_message.get, 1, 240);
2262: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');
2263: l_errMsg := substrb(fnd_message.get, 1, 240);
2264: update mtl_transactions_interface mti
2265: set last_update_date = sysdate,
2266: last_updated_by = fnd_global.user_id,

Line 2263: l_errMsg := substrb(fnd_message.get, 1, 240);

2259: -- validate transaction action
2260: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
2261: l_errCode := substrb(fnd_message.get, 1, 240);
2262: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');
2263: l_errMsg := substrb(fnd_message.get, 1, 240);
2264: update mtl_transactions_interface mti
2265: set last_update_date = sysdate,
2266: last_updated_by = fnd_global.user_id,
2267: last_update_login = fnd_global.login_id,

Line 2284: fnd_message.set_name('INV', 'INV_INT_SRCCODE');

2280: and upper(nvl(flow_schedule, 'N')) <> 'Y';
2281:
2282:
2283: -- validate transaction source id
2284: fnd_message.set_name('INV', 'INV_INT_SRCCODE');
2285: l_errCode := substrb(fnd_message.get, 1, 240);
2286: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');
2287: l_errMsg := substrb(fnd_message.get, 1, 240);
2288: update mtl_transactions_interface mti

Line 2285: l_errCode := substrb(fnd_message.get, 1, 240);

2281:
2282:
2283: -- validate transaction source id
2284: fnd_message.set_name('INV', 'INV_INT_SRCCODE');
2285: l_errCode := substrb(fnd_message.get, 1, 240);
2286: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');
2287: l_errMsg := substrb(fnd_message.get, 1, 240);
2288: update mtl_transactions_interface mti
2289: set last_update_date = sysdate,

Line 2286: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');

2282:
2283: -- validate transaction source id
2284: fnd_message.set_name('INV', 'INV_INT_SRCCODE');
2285: l_errCode := substrb(fnd_message.get, 1, 240);
2286: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');
2287: l_errMsg := substrb(fnd_message.get, 1, 240);
2288: update mtl_transactions_interface mti
2289: set last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id,

Line 2287: l_errMsg := substrb(fnd_message.get, 1, 240);

2283: -- validate transaction source id
2284: fnd_message.set_name('INV', 'INV_INT_SRCCODE');
2285: l_errCode := substrb(fnd_message.get, 1, 240);
2286: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');
2287: l_errMsg := substrb(fnd_message.get, 1, 240);
2288: update mtl_transactions_interface mti
2289: set last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id,
2291: last_update_login = fnd_global.login_id,

Line 2320: fnd_message.set_name('INV', 'INV_INT_PROCCODE');

2316: /* Fix for Bug#4893215 . Make sure that Flow and Work Order-less transaction
2317: * is processed as one batch - parent+components
2318: * */
2319:
2320: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2321: l_errCode := substrb(fnd_message.get, 1, 240);
2322:
2323: fnd_message.set_name('WIP', 'WIP_NO_PARENT_TRANSACTION');
2324: l_errMsg := substrb(fnd_message.get, 1, 240);

Line 2321: l_errCode := substrb(fnd_message.get, 1, 240);

2317: * is processed as one batch - parent+components
2318: * */
2319:
2320: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2321: l_errCode := substrb(fnd_message.get, 1, 240);
2322:
2323: fnd_message.set_name('WIP', 'WIP_NO_PARENT_TRANSACTION');
2324: l_errMsg := substrb(fnd_message.get, 1, 240);
2325:

Line 2323: fnd_message.set_name('WIP', 'WIP_NO_PARENT_TRANSACTION');

2319:
2320: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2321: l_errCode := substrb(fnd_message.get, 1, 240);
2322:
2323: fnd_message.set_name('WIP', 'WIP_NO_PARENT_TRANSACTION');
2324: l_errMsg := substrb(fnd_message.get, 1, 240);
2325:
2326: update mtl_transactions_interface mti
2327: set last_update_date = sysdate,

Line 2324: l_errMsg := substrb(fnd_message.get, 1, 240);

2320: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2321: l_errCode := substrb(fnd_message.get, 1, 240);
2322:
2323: fnd_message.set_name('WIP', 'WIP_NO_PARENT_TRANSACTION');
2324: l_errMsg := substrb(fnd_message.get, 1, 240);
2325:
2326: update mtl_transactions_interface mti
2327: set last_update_date = sysdate,
2328: last_updated_by = fnd_global.user_id,

Line 2354: fnd_message.set_name('INV', 'INV_INT_PROCCODE');

2350: ) ;
2351:
2352: /* Bug 5306902 - Parent WOLC resubmitted without all child component transactions. */
2353:
2354: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2355: l_errCode := substrb(fnd_message.get, 1, 240);
2356:
2357: fnd_message.set_name('WIP', 'WIP_PENDING_CHILD_TRANSACTION');
2358: l_errMsg := substrb(fnd_message.get, 1, 240);

Line 2355: l_errCode := substrb(fnd_message.get, 1, 240);

2351:
2352: /* Bug 5306902 - Parent WOLC resubmitted without all child component transactions. */
2353:
2354: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2355: l_errCode := substrb(fnd_message.get, 1, 240);
2356:
2357: fnd_message.set_name('WIP', 'WIP_PENDING_CHILD_TRANSACTION');
2358: l_errMsg := substrb(fnd_message.get, 1, 240);
2359:

Line 2357: fnd_message.set_name('WIP', 'WIP_PENDING_CHILD_TRANSACTION');

2353:
2354: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2355: l_errCode := substrb(fnd_message.get, 1, 240);
2356:
2357: fnd_message.set_name('WIP', 'WIP_PENDING_CHILD_TRANSACTION');
2358: l_errMsg := substrb(fnd_message.get, 1, 240);
2359:
2360: update mtl_transactions_interface mti
2361: set last_update_date = sysdate,

Line 2358: l_errMsg := substrb(fnd_message.get, 1, 240);

2354: fnd_message.set_name('INV', 'INV_INT_PROCCODE');
2355: l_errCode := substrb(fnd_message.get, 1, 240);
2356:
2357: fnd_message.set_name('WIP', 'WIP_PENDING_CHILD_TRANSACTION');
2358: l_errMsg := substrb(fnd_message.get, 1, 240);
2359:
2360: update mtl_transactions_interface mti
2361: set last_update_date = sysdate,
2362: last_updated_by = fnd_global.user_id,

Line 2515: fnd_message.set_name('INV', 'INV_INT_ITMCODE');

2511: and process_flag = wip_constants.mti_inventory;
2512: */
2513:
2514: -- validate inventory item id
2515: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2516: l_errCode := substrb(fnd_message.get, 1, 240);
2517: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2518: l_errMsg := substrb(fnd_message.get, 1, 240);
2519: update mtl_transactions_interface mti

Line 2516: l_errCode := substrb(fnd_message.get, 1, 240);

2512: */
2513:
2514: -- validate inventory item id
2515: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2516: l_errCode := substrb(fnd_message.get, 1, 240);
2517: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2518: l_errMsg := substrb(fnd_message.get, 1, 240);
2519: update mtl_transactions_interface mti
2520: set last_update_date = sysdate,

Line 2517: fnd_message.set_name('INV', 'INV_INT_ITMEXP');

2513:
2514: -- validate inventory item id
2515: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2516: l_errCode := substrb(fnd_message.get, 1, 240);
2517: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2518: l_errMsg := substrb(fnd_message.get, 1, 240);
2519: update mtl_transactions_interface mti
2520: set last_update_date = sysdate,
2521: last_updated_by = fnd_global.user_id,

Line 2518: l_errMsg := substrb(fnd_message.get, 1, 240);

2514: -- validate inventory item id
2515: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
2516: l_errCode := substrb(fnd_message.get, 1, 240);
2517: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2518: l_errMsg := substrb(fnd_message.get, 1, 240);
2519: update mtl_transactions_interface mti
2520: set last_update_date = sysdate,
2521: last_updated_by = fnd_global.user_id,
2522: last_update_login = fnd_global.login_id,

Line 2606: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');

2602:
2603:
2604: -- make sure that flow_schedule flag is 'N' or NULL for job/repetitive and
2605: -- is Y for flow schedules
2606: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
2607: l_errMsg := substrb(fnd_message.get, 1, 240);
2608: update mtl_transactions_interface mti
2609: set last_update_date = sysdate,
2610: last_updated_by = fnd_global.user_id,

Line 2607: l_errMsg := substrb(fnd_message.get, 1, 240);

2603:
2604: -- make sure that flow_schedule flag is 'N' or NULL for job/repetitive and
2605: -- is Y for flow schedules
2606: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
2607: l_errMsg := substrb(fnd_message.get, 1, 240);
2608: update mtl_transactions_interface mti
2609: set last_update_date = sysdate,
2610: last_updated_by = fnd_global.user_id,
2611: last_update_login = fnd_global.login_id,

Line 2629: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');

2625: or ( wip_entity_type = 4
2626: and upper(nvl(flow_schedule, 'N')) <> 'Y') );
2627:
2628: -- for flow schedule, we can't do complete/scrap against a closed schedule
2629: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
2630: l_errMsg := substrb(fnd_message.get, 1, 240);
2631: update mtl_transactions_interface mti
2632: set last_update_date = sysdate,
2633: last_updated_by = fnd_global.user_id,

Line 2630: l_errMsg := substrb(fnd_message.get, 1, 240);

2626: and upper(nvl(flow_schedule, 'N')) <> 'Y') );
2627:
2628: -- for flow schedule, we can't do complete/scrap against a closed schedule
2629: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
2630: l_errMsg := substrb(fnd_message.get, 1, 240);
2631: update mtl_transactions_interface mti
2632: set last_update_date = sysdate,
2633: last_updated_by = fnd_global.user_id,
2634: last_update_login = fnd_global.login_id,