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_MOVE_VALIDATOR dependencies on WIP_MOVE_TXN_INTERFACE

Line 82: FROM wip_move_txn_interface

78: request_id,
79: program_application_id,
80: program_id,
81: program_update_date
82: FROM wip_move_txn_interface
83: WHERE transaction_id = current_errors(error_no).transaction_id
84: AND group_id = g_group_id;
85:
86: error_no := error_no + 1;

Line 108: UPDATE wip_move_txn_interface wmti

104:
105: PROCEDURE organization_id(p_count_of_errored OUT NOCOPY NUMBER) IS
106: BEGIN
107: -- Derive ORGANIZATIOIN_ID if user provided only ORGANIZATION_CODE
108: UPDATE wip_move_txn_interface wmti
109: SET wmti.organization_id =
110: (SELECT mp.organization_id
111: FROM mtl_parameters mp
112: WHERE mp.organization_code = wmti.organization_code) --Fix by bug 9220479

Line 123: UPDATE wip_move_txn_interface wmti

119: enums.delete;
120:
121: -- If cannot derive ORGANIZATION_ID or ORGANIZATION_ID not corresponding to
122: -- ORGANIZATION_CODE provided, error out.
123: UPDATE wip_move_txn_interface wmti
124: SET wmti.process_status = WIP_CONSTANTS.ERROR
125: WHERE wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
126: AND wmti.process_status = WIP_CONSTANTS.PENDING
127: AND ((wmti.organization_id IS NULL) -- cannot derive ORGANIZATION_ID

Line 175: UPDATE wip_move_txn_interface wmti

171: -- transaction for background.
172: PROCEDURE wip_entity_id IS
173: BEGIN
174: -- Derive WIP_ENTITY_ID if user provided only WIP_ENTITY_NAME
175: UPDATE wip_move_txn_interface wmti
176: SET wmti.wip_entity_id =
177: (SELECT we.wip_entity_id
178: FROM wip_entities we
179: WHERE we.wip_entity_name = wmti.wip_entity_name

Line 194: UPDATE wip_move_txn_interface wmti

190: -- reset enums table
191: enums.delete;
192: -- If unable to derive WIP_ENTITY_ID or WIP_ENTITY_ID not conresponding
193: -- to WIP_ENTITY_NAME specified, error out.
194: UPDATE wip_move_txn_interface wmti
195: SET wmti.process_status = WIP_CONSTANTS.ERROR
196: WHERE wmti.group_id = g_group_id
197: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
198: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 222: UPDATE wip_move_txn_interface wmti

218: p_err_col => 'WIP_ENTITY_ID/NAME',
219: p_err_msg => fnd_message.get);
220:
221: -- Derive ENTITY_TYPE and PRIMARY_ITEM_ID from WIP_ENTITY_ID
222: UPDATE wip_move_txn_interface wmti
223: SET (wmti.entity_type, wmti.primary_item_id) =
224: (SELECT we.entity_type,
225: we.primary_item_id
226: FROM wip_entities we

Line 235: UPDATE wip_move_txn_interface wmti

231:
232: -- reset enums table
233: enums.delete;
234: -- If non-standard job and no assembly defined, error out
235: UPDATE wip_move_txn_interface wmti
236: SET wmti.process_status = WIP_CONSTANTS.ERROR
237: WHERE wmti.group_id = g_group_id
238: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
239: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 252: UPDATE wip_move_txn_interface wmti

248: /************************
249: * Start Repetitive Check
250: ************************/
251: -- Derive LINE_ID if user provided only LINE_CODE.
252: UPDATE wip_move_txn_interface wmti
253: SET wmti.line_id =
254: (SELECT wl.line_id
255: FROM wip_lines wl
256: WHERE wl.line_code = wmti.line_code

Line 270: UPDATE wip_move_txn_interface wmti

266: -- reset enums table
267: enums.delete;
268: -- If unable to derive LINE_ID or LINE_ID not conresponding to LINE_CODE
269: -- specified, error out.
270: UPDATE wip_move_txn_interface wmti
271: SET wmti.process_status = WIP_CONSTANTS.ERROR
272: WHERE wmti.group_id = g_group_id
273: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
274: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 295: UPDATE wip_move_txn_interface wmti

291: p_err_col => 'LINE_ID/CODE',
292: p_err_msg => fnd_message.get);
293:
294: -- derive the first transactable schedule if REPETITIVE_SCHEDULE_ID is null
295: UPDATE wip_move_txn_interface wmti
296: SET wmti.repetitive_schedule_id =
297: (SELECT wrs1.repetitive_schedule_id
298: FROM wip_repetitive_schedules wrs1
299: WHERE wrs1.wip_entity_id = wmti.wip_entity_id

Line 322: UPDATE wip_move_txn_interface wmti

318: -- reset enums table
319: enums.delete;
320: -- By this time, all repetive transaction should have REPETITIVE_SCHEDULE_ID
321: -- Otherwise, error out
322: UPDATE wip_move_txn_interface wmti
323: SET wmti.process_status = WIP_CONSTANTS.ERROR
324: WHERE wmti.group_id = g_group_id
325: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
326: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 346: UPDATE wip_move_txn_interface wmti

342: ************************/
343: -- reset enums table
344: enums.delete;
345: -- For Discrete and Lotbased, user should not provide these 3 values
346: UPDATE wip_move_txn_interface wmti
347: SET wmti.process_status = WIP_CONSTANTS.ERROR
348: WHERE wmti.group_id = g_group_id
349: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
350: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 369: UPDATE wip_move_txn_interface wmti

365: ************************/
366: -- reset enums table
367: enums.delete;
368: -- Check job status not either Complete or Release, error out.
369: UPDATE wip_move_txn_interface wmti
370: SET wmti.process_status = WIP_CONSTANTS.ERROR
371: WHERE wmti.group_id = g_group_id
372: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
373: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 403: UPDATE wip_move_txn_interface wmti

399:
400: -- reset enums table
401: enums.delete;
402: -- If job/schedule specified has no routing, error out
403: UPDATE wip_move_txn_interface wmti
404: SET wmti.process_status = WIP_CONSTANTS.ERROR
405: WHERE wmti.group_id = g_group_id
406: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
407: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 435: UPDATE wip_move_txn_interface wmti

431: -- For repetitive, if the assembly is under lot control, it will error out.
432: PROCEDURE transaction_type IS
433: BEGIN
434: -- Default TRANSACTION_TYPE to Move if users do not provide one
435: UPDATE wip_move_txn_interface wmti
436: SET wmti.transaction_type = WIP_CONSTANTS.MOVE_TXN
437: WHERE wmti.group_id = g_group_id
438: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
439: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 446: UPDATE wip_move_txn_interface wmti

442: -- reset enums table
443: enums.delete;
444: -- Errot out, if transaction type not either Move or EZ Complete or
445: -- EZ Return
446: UPDATE wip_move_txn_interface wmti
447: SET wmti.process_status = WIP_CONSTANTS.ERROR
448: WHERE wmti.group_id = g_group_id
449: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
450: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 467: UPDATE wip_move_txn_interface wmti

463: enums.delete;
464: -- Error out if easy completion/return and the assembly is under serial
465: -- control because we cannot gather or derive serial number for background
466: -- txns
467: UPDATE wip_move_txn_interface wmti
468: SET wmti.process_status = WIP_CONSTANTS.ERROR
469: WHERE wmti.group_id = g_group_id
470: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
471: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 495: UPDATE wip_move_txn_interface wmti

491: -- reset enums table
492: enums.delete;
493: -- Error out if easy completion/return and no default completion subinventory
494: -- locator defined for both Discrete and Repetitive Schedule
495: UPDATE wip_move_txn_interface wmti
496: SET wmti.process_status = WIP_CONSTANTS.ERROR
497: WHERE wmti.group_id = g_group_id
498: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
499: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 529: UPDATE wip_move_txn_interface wmti

525:
526: -- reset enums table
527: enums.delete;
528: -- Error out if item revision does not exist as a BOM revision
529: UPDATE wip_move_txn_interface wmti
530: SET wmti.process_status = WIP_CONSTANTS.ERROR
531: WHERE wmti.group_id = g_group_id
532: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
533: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 580: UPDATE wip_move_txn_interface wmti

576: -- reset enums table
577: enums.delete;
578: -- Error out if easy completion /return for repetitive schedule
579: -- and the assembly is under lot control
580: UPDATE wip_move_txn_interface wmti
581: SET wmti.process_status = WIP_CONSTANTS.ERROR
582: WHERE wmti.group_id = g_group_id
583: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
584: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 605: UPDATE wip_move_txn_interface wmti

601: -- reset enums table
602: enums.delete;
603: -- Error out if easy completion /return for Discrete job and the assembly
604: -- is under lot control and there is no default completion lot defined
605: UPDATE wip_move_txn_interface wmti
606: SET wmti.process_status = WIP_CONSTANTS.ERROR
607: WHERE wmti.group_id = g_group_id
608: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
609: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 637: UPDATE wip_move_txn_interface wmti

633: -- reset enums table
634: enums.delete;
635: -- Error out if easy completion to the new lot number and and either this
636: -- item or this item category requires "Lot Attributes".
637: UPDATE wip_move_txn_interface wmti
638: SET wmti.process_status = WIP_CONSTANTS.ERROR
639: WHERE wmti.group_id = g_group_id
640: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
641: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 677: UPDATE wip_move_txn_interface wmti

673: -- reset enums table
674: enums.delete;
675: -- Error out if easy completion to the new lot number and lot expiration date
676: -- was set to user-defined
677: UPDATE wip_move_txn_interface wmti
678: SET wmti.process_status = WIP_CONSTANTS.ERROR
679: WHERE wmti.group_id = g_group_id
680: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
681: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 718: UPDATE wip_move_txn_interface wmti

714: BEGIN
715: -- reset enums table
716: enums.delete;
717: -- Error out if TRANSACTION_DATE is the future date
718: UPDATE wip_move_txn_interface wmti
719: SET wmti.process_status = WIP_CONSTANTS.ERROR
720: WHERE wmti.group_id = g_group_id
721: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
722: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 735: UPDATE wip_move_txn_interface wmti

731: /* Fix for bug 5685099 : Validate if TRANSACTION_DATE falls in open accounting period. */
732: -- reset enums table
733: enums.delete;
734: -- Error out if TRANSACTION_DATE does not fall in open period
735: UPDATE wip_move_txn_interface wmti
736: SET wmti.process_status = WIP_CONSTANTS.ERROR
737: WHERE wmti.group_id = g_group_id
738: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
739: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 763: UPDATE wip_move_txn_interface wmti

759:
760: -- reset enums table
761: enums.delete;
762: -- Error out if TRANSACTION_DATE is before released date
763: UPDATE wip_move_txn_interface wmti
764: SET wmti.process_status = WIP_CONSTANTS.ERROR
765: WHERE wmti.group_id = g_group_id
766: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
767: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 792: UPDATE wip_move_txn_interface wmti

788: p_err_col => 'TRANSACTION_DATE',
789: p_err_msg => fnd_message.get);
790:
791: -- Derive ACCT_PERIOD_ID from TRANSACTION_DATE
792: UPDATE wip_move_txn_interface wmti
793: SET wmti.acct_period_id =
794: (SELECT oap.acct_period_id
795: FROM org_acct_periods oap
796: WHERE oap.organization_id = wmti.organization_id

Line 811: UPDATE wip_move_txn_interface wmti

807: -- reset enums table
808: enums.delete;
809: -- Error out if there is no open accout period for the TRANSACTION_DATE
810: -- specified or there is no WIP_PERIOD_BALANCES
811: UPDATE wip_move_txn_interface wmti
812: SET wmti.process_status = WIP_CONSTANTS.ERROR
813: WHERE wmti.group_id = g_group_id
814: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
815: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 853: UPDATE wip_move_txn_interface wmti

849: l_last_op NUMBER;
850: BEGIN
851: -- Set FM_OPERATION_SEQ_NUM to last_operation if TRANSACTION_TYPE is
852: -- EZ Return and FM_OPERATION_SEQ_NUM is null
853: UPDATE wip_move_txn_interface wmti
854: SET wmti.fm_operation_seq_num =
855: (SELECT wo.operation_seq_num
856: FROM wip_operations wo
857: WHERE wo.wip_entity_id = wmti.wip_entity_id

Line 872: UPDATE wip_move_txn_interface wmti

868: -- reset enums table
869: enums.delete;
870: -- Error out if FM_OPERATION_SEQ_NUM is null or FM_OPERATION_SEQ_NUM
871: -- is invalid
872: UPDATE wip_move_txn_interface wmti
873: SET wmti.process_status = WIP_CONSTANTS.ERROR
874: WHERE wmti.group_id = g_group_id
875: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
876: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 898: UPDATE wip_move_txn_interface wmti

894: -- reset enums table
895: enums.delete;
896: -- Error out if TRANSACTION_TYPE is EZ Return and FM_OPERATION_SEQ_NUM
897: -- is not equal to the last operation.
898: UPDATE wip_move_txn_interface wmti
899: SET wmti.process_status = WIP_CONSTANTS.ERROR
900: WHERE wmti.group_id = g_group_id
901: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
902: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 931: UPDATE wip_move_txn_interface wmti

927: l_sf_status VARCHAR2(100); /*Fix Bug 9758848*/
928: BEGIN
929: -- Set FM_INTRAOPERATION_STEP_TYPE to Tomove if TRANSACTION_TYPE is
930: -- EZ Return and FM_INTRAOPERATION_STEP_TYPE is null
931: UPDATE wip_move_txn_interface wmti
932: SET wmti.fm_intraoperation_step_type = WIP_CONSTANTS.TOMOVE
933: WHERE wmti.group_id = g_group_id
934: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
935: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 942: UPDATE wip_move_txn_interface wmti

938:
939: -- reset enums table
940: enums.delete;
941: -- Error out if FM_INTRAOPERATION_STEP_TYPE is null or invalid
942: UPDATE wip_move_txn_interface wmti
943: SET wmti.process_status = WIP_CONSTANTS.ERROR
944: WHERE wmti.group_id = g_group_id
945: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
946: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 977: UPDATE wip_move_txn_interface wmti

973: -- reset enums table
974: enums.delete;
975: -- Error out if FM_OPERATION_SEQ_NUM/FM_INTRAOPERATION_STEP_TYPE has
976: -- no move shop floor status attached
977: UPDATE wip_move_txn_interface wmti
978: SET wmti.process_status = WIP_CONSTANTS.ERROR
979: WHERE wmti.group_id = g_group_id
980: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
981: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1013: wip_move_txn_interface wmti

1009: SELECT ws.shop_floor_status_code
1010: into l_sf_status
1011: FROM wip_shop_floor_status_codes wsc,
1012: wip_shop_floor_statuses ws,
1013: wip_move_txn_interface wmti
1014: WHERE wsc.organization_id = wmti.organization_id
1015: AND ws.organization_id = wmti.organization_id
1016: AND ws.wip_entity_id = wmti.wip_entity_id
1017: AND wmti.transaction_id = enums(i)

Line 1038: UPDATE wip_move_txn_interface wmti

1034: -- reset enums table
1035: enums.delete;
1036: -- Error out if users try to perform easy completion from Tomove of the
1037: -- last operation
1038: UPDATE wip_move_txn_interface wmti
1039: SET wmti.process_status = WIP_CONSTANTS.ERROR
1040: WHERE wmti.group_id = g_group_id
1041: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1042: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1064: UPDATE wip_move_txn_interface wmti

1060: -- reset enums table
1061: enums.delete;
1062: -- Error out if TRANSACTION_TYPE is EZ Return and
1063: -- FM_INTRAOPERATION_STEP_TYPE not equal to Tomove
1064: UPDATE wip_move_txn_interface wmti
1065: SET wmti.process_status = WIP_CONSTANTS.ERROR
1066: WHERE wmti.group_id = g_group_id
1067: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1068: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1088: UPDATE wip_move_txn_interface wmti

1084: PROCEDURE to_operation IS
1085: BEGIN
1086: -- Set TO_OPERATION_SEQ_NUM to last_operation if TRANSACTION_TYPE is
1087: -- EZ Completion and TO_OPERATION_SEQ_NUM is null
1088: UPDATE wip_move_txn_interface wmti
1089: SET wmti.to_operation_seq_num =
1090: (SELECT wo.operation_seq_num
1091: FROM wip_operations wo
1092: WHERE wo.wip_entity_id = wmti.wip_entity_id

Line 1105: UPDATE wip_move_txn_interface wmti

1101: AND wmti.to_operation_seq_num IS NULL;
1102:
1103: /*Bug 4421485->Even for plain moves we will derive to_operation as
1104: next count point operation */
1105: UPDATE wip_move_txn_interface wmti
1106: SET wmti.to_operation_seq_num =
1107: (SELECT MIN(wo.operation_seq_num)
1108: FROM wip_operations wo
1109: WHERE wo.organization_id = wmti.organization_id

Line 1125: UPDATE wip_move_txn_interface wmti

1121: -- reset enums table
1122: enums.delete;
1123: -- Error out if TO_OPERATION_SEQ_NUM is null or TO_OPERATION_SEQ_NUM
1124: -- is invalid
1125: UPDATE wip_move_txn_interface wmti
1126: SET wmti.process_status = WIP_CONSTANTS.ERROR
1127: WHERE wmti.group_id = g_group_id
1128: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1129: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1151: UPDATE wip_move_txn_interface wmti

1147: -- reset enums table
1148: enums.delete;
1149: -- Error out if TRANSACTION_TYPE is EZ Ccmplete and TO_OPERATION_SEQ_NUM
1150: -- is not equal to the last operation.
1151: UPDATE wip_move_txn_interface wmti
1152: SET wmti.process_status = WIP_CONSTANTS.ERROR
1153: WHERE wmti.group_id = g_group_id
1154: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1155: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1183: UPDATE wip_move_txn_interface wmti

1179: l_sf_status VARCHAR2(100); /*Fix Bug 9758848*/
1180: BEGIN
1181: -- Set TO_INTRAOPERATION_STEP_TYPE to Tomove if TRANSACTION_TYPE is
1182: -- EZ Complete and TO_INTRAOPERATION_STEP_TYPE is null
1183: UPDATE wip_move_txn_interface wmti
1184: /*Bug Bug 4421485*/
1185: SET wmti.to_intraoperation_step_type =
1186: DECODE(wmti.transaction_type,
1187: WIP_CONSTANTS.COMP_TXN,WIP_CONSTANTS.TOMOVE, WIP_CONSTANTS.QUEUE)

Line 1199: UPDATE wip_move_txn_interface wmti

1195:
1196: -- reset enums table
1197: enums.delete;
1198: -- Error out if TO_INTRAOPERATION_STEP_TYPE is null or invalid
1199: UPDATE wip_move_txn_interface wmti
1200: SET wmti.process_status = WIP_CONSTANTS.ERROR
1201: WHERE wmti.group_id = g_group_id
1202: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1203: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1249: UPDATE wip_move_txn_interface wmti

1245: -- reset enums table
1246: enums.delete;
1247: -- Error out if users try to move to the same operation and step as the
1248: -- FM_OPERATION_SEQ_NUM and FM_INTRAOPERATION_STEP_TYPE
1249: UPDATE wip_move_txn_interface wmti
1250: SET wmti.process_status = WIP_CONSTANTS.ERROR
1251: WHERE wmti.group_id = g_group_id
1252: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1253: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1267: UPDATE wip_move_txn_interface wmti

1263: -- reset enums table
1264: enums.delete;
1265: -- Error out if TRANSACTION_TYPE is EZ Complete and
1266: -- TO_INTRAOPERATION_STEP_TYPE not equal to Tomove
1267: UPDATE wip_move_txn_interface wmti
1268: SET wmti.process_status = WIP_CONSTANTS.ERROR
1269: WHERE wmti.group_id = g_group_id
1270: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1271: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1285: UPDATE wip_move_txn_interface wmti

1281: -- reset enums table
1282: enums.delete;
1283: -- Error out if user try to easy complete job/schedule that has No Move shop
1284: -- floor status attached to Tomove of the last operation
1285: UPDATE wip_move_txn_interface wmti
1286: SET wmti.process_status = WIP_CONSTANTS.ERROR
1287: WHERE wmti.group_id = g_group_id
1288: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1289: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1313: wip_move_txn_interface wmti

1309: SELECT ws.shop_floor_status_code
1310: INTO l_sf_status
1311: FROM wip_shop_floor_status_codes wsc,
1312: wip_shop_floor_statuses ws,
1313: wip_move_txn_interface wmti
1314: WHERE wsc.organization_id = wmti.organization_id
1315: AND ws.organization_id = wmti.organization_id
1316: AND ws.wip_entity_id = wmti.wip_entity_id
1317: AND wmti.transaction_id = enums(i)

Line 1338: UPDATE wip_move_txn_interface wmti

1334: -- reset enums table
1335: enums.delete;
1336: -- Error out if wip_parameter do not allow move over no_move shop floor
1337: -- status, and there are no_move status in between
1338: UPDATE wip_move_txn_interface wmti
1339: SET wmti.process_status = WIP_CONSTANTS.ERROR
1340: WHERE wmti.group_id = g_group_id
1341: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1342: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1370: from wip_move_txn_interface wmti

1366: wmti.to_operation_seq_num, -- p_to_op
1367: wmti.to_intraoperation_step_type, -- p_to_step
1368: wmti.source_code)
1369: into l_sf_status
1370: from wip_move_txn_interface wmti
1371: where wmti.transaction_id = enums(i)
1372: and wmti.process_status = WIP_CONSTANTS.ERROR;
1373: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
1374: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

Line 1389: UPDATE wip_move_txn_interface wmti

1385: -- reset enums table
1386: enums.delete;
1387:
1388: -- Error out if TRANSACTION_QUANTITY is negative or zero
1389: UPDATE wip_move_txn_interface wmti
1390: SET wmti.process_status = WIP_CONSTANTS.ERROR
1391: WHERE wmti.group_id = g_group_id
1392: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1393: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1413: UPDATE wip_move_txn_interface wmti

1409: BEGIN
1410: -- reset enums table
1411: enums.delete;
1412: -- Error out if TRANSACTION_UOM is invalid
1413: UPDATE wip_move_txn_interface wmti
1414: SET wmti.process_status = WIP_CONSTANTS.ERROR
1415: WHERE wmti.group_id = g_group_id
1416: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1417: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1445: UPDATE wip_move_txn_interface wmti

1441: -- reset enums table
1442: enums.delete;
1443:
1444: -- Error out if OVERCOMPLETION_TRANSACTION_QTY is negative or zero
1445: UPDATE wip_move_txn_interface wmti
1446: SET wmti.process_status = WIP_CONSTANTS.ERROR
1447: WHERE wmti.group_id = g_group_id
1448: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1449: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1465: UPDATE wip_move_txn_interface wmti

1461: -- reset enums table
1462: enums.delete;
1463: -- Error out if OVERCOMPLETION_TRANSACTION_QTY is greater than
1464: -- TRANSACTION_QUANTITY
1465: UPDATE wip_move_txn_interface wmti
1466: SET wmti.process_status = WIP_CONSTANTS.ERROR
1467: WHERE wmti.group_id = g_group_id
1468: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1469: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1484: UPDATE wip_move_txn_interface wmti

1480:
1481: -- reset enums table
1482: enums.delete;
1483: -- Error out if user try to do over Return
1484: UPDATE wip_move_txn_interface wmti
1485: SET wmti.process_status = WIP_CONSTANTS.ERROR
1486: WHERE wmti.group_id = g_group_id
1487: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1488: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1501: UPDATE wip_move_txn_interface wmti

1497:
1498: -- reset enums table
1499: enums.delete;
1500: -- Error out if user try to do over Return from Scrap/Return from Reject
1501: UPDATE wip_move_txn_interface wmti
1502: SET wmti.process_status = WIP_CONSTANTS.ERROR
1503: WHERE wmti.group_id = g_group_id
1504: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1505: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1520: UPDATE wip_move_txn_interface wmti

1516: -- reset enums table
1517: enums.delete;
1518: -- Error out if OVERCOMPLETION_TRANSACTION_QTY is specified for backward
1519: -- move txns
1520: UPDATE wip_move_txn_interface wmti
1521: SET wmti.process_status = WIP_CONSTANTS.ERROR
1522: WHERE wmti.group_id = g_group_id
1523: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1524: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1540: -- WIP_MOVE_TXN_INTERFACE. This value need to be unique.

1536:
1537: END ocpl_txn_qty;
1538:
1539: -- validate transaction_id against the one in WIP_MOVE_TRANSACTIONS, and
1540: -- WIP_MOVE_TXN_INTERFACE. This value need to be unique.
1541: PROCEDURE transaction_id IS
1542: l_errMsg VARCHAR2(240);
1543: BEGIN
1544: -- Generate TRANSACTION_ID if user does not provide this value

Line 1545: UPDATE wip_move_txn_interface wmti

1541: PROCEDURE transaction_id IS
1542: l_errMsg VARCHAR2(240);
1543: BEGIN
1544: -- Generate TRANSACTION_ID if user does not provide this value
1545: UPDATE wip_move_txn_interface wmti
1546: SET wmti.transaction_id = wip_transactions_s.nextval
1547: WHERE wmti.group_id = g_group_id
1548: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1549: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 1583: FROM wip_move_txn_interface wmti1

1579: wmti1.request_id,
1580: wmti1.program_application_id,
1581: wmti1.program_id,
1582: wmti1.program_update_date
1583: FROM wip_move_txn_interface wmti1
1584: WHERE wmti1.group_id = g_group_id
1585: AND wmti1.process_phase = WIP_CONSTANTS.MOVE_VAL
1586: AND wmti1.process_status = WIP_CONSTANTS.RUNNING
1587: AND (EXISTS

Line 1594: FROM wip_move_txn_interface wmti2

1590: WHERE wmt.transaction_id = wmti1.transaction_id)
1591: OR
1592: (1 <>
1593: (SELECT count(*)
1594: FROM wip_move_txn_interface wmti2
1595: WHERE wmti2.transaction_id = wmti1.transaction_id)));
1596:
1597: END transaction_id;
1598:

Line 1638: wip_move_txn_interface wmti

1634: msik.concatenated_segments assembly_name
1635: FROM wip_discrete_jobs wdj,
1636: mtl_system_items_kfv msik,
1637: mtl_parameters mp,
1638: wip_move_txn_interface wmti
1639: WHERE wdj.primary_item_id = msik.inventory_item_id
1640: AND wdj.organization_id = msik.organization_id
1641: AND wdj.organization_id = mp.organization_id
1642: AND wmti.wip_entity_id = wdj.wip_entity_id

Line 1686: wip_move_txn_interface wmti

1682: FROM wip_repetitive_schedules wrs,
1683: wip_repetitive_items wri,
1684: mtl_system_items_kfv msik,
1685: mtl_parameters mp,
1686: wip_move_txn_interface wmti
1687: WHERE wmti.primary_item_id = msik.inventory_item_id
1688: AND wmti.organization_id = msik.organization_id
1689: AND wmti.organization_id = mp.organization_id
1690: AND wrs.wip_entity_id = wmti.wip_entity_id

Line 1723: UPDATE wip_move_txn_interface wmti

1719: /** Bug fix 5000113. primary_quantity should be updated in sync with
1720: * transaction_quantity, and not just when primary_quantity is null.
1721: */
1722:
1723: UPDATE wip_move_txn_interface wmti
1724: SET wmti.primary_quantity =
1725: (SELECT ROUND(wmti.transaction_quantity * mucv.conversion_rate,
1726: WIP_CONSTANTS.INV_MAX_PRECISION)
1727: FROM mtl_uom_conversions_view mucv

Line 1774: FROM wip_move_txn_interface wmti

1770: wmti.request_id,
1771: wmti.program_application_id,
1772: wmti.program_id,
1773: wmti.program_update_date
1774: FROM wip_move_txn_interface wmti
1775: WHERE wmti.group_id = g_group_id
1776: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1777: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1778: AND wmti.primary_quantity = 0;

Line 1816: FROM wip_move_txn_interface wmti,

1812: wmti.request_id,
1813: wmti.program_application_id,
1814: wmti.program_id,
1815: wmti.program_update_date
1816: FROM wip_move_txn_interface wmti,
1817: mtl_uom_conversions_view mucv
1818: WHERE mucv.organization_id = wmti.organization_id
1819: AND mucv.inventory_item_id = wmti.primary_item_id
1820: AND mucv.uom_code = wmti.transaction_uom

Line 1867: FROM wip_move_txn_interface wmti,

1863: wmti.request_id,
1864: wmti.program_application_id,
1865: wmti.program_id,
1866: wmti.program_update_date
1867: FROM wip_move_txn_interface wmti,
1868: wip_operations wo
1869: WHERE wo.organization_id = wmti.organization_id
1870: AND wo.wip_entity_id = wmti.wip_entity_id
1871: AND NVL(wo.repetitive_schedule_id, -1) =

Line 1983: UPDATE wip_move_txn_interface wmti

1979: PROCEDURE primary_uom IS
1980: l_errMsg VARCHAR2(240);
1981: BEGIN
1982: -- Derive PRIMARY_UOM from PRIMARY_ITEM_ID provided if PRIMARY_UOM is null
1983: UPDATE wip_move_txn_interface wmti
1984: SET wmti.primary_uom =
1985: (SELECT msi.primary_uom_code
1986: FROM mtl_system_items msi
1987: WHERE msi.organization_id = wmti.organization_id

Line 2028: FROM wip_move_txn_interface wmti,

2024: wmti.request_id,
2025: wmti.program_application_id,
2026: wmti.program_id,
2027: wmti.program_update_date
2028: FROM wip_move_txn_interface wmti,
2029: mtl_system_items msi
2030: WHERE msi.organization_id = wmti.organization_id
2031: AND msi.inventory_item_id = wmti.primary_item_id
2032: AND wmti.group_id = g_group_id

Line 2051: UPDATE wip_move_txn_interface wmti

2047: /** Bug fix 5000113. overcompletion_primary_qty should be updated in sync with
2048: * transaction_quantity, and not just when overcompletion_quantity is null.
2049: */
2050:
2051: UPDATE wip_move_txn_interface wmti
2052: SET wmti.overcompletion_primary_qty =
2053: (SELECT ROUND(wmti.overcompletion_transaction_qty *
2054: mucv.conversion_rate, WIP_CONSTANTS.INV_MAX_PRECISION)
2055: FROM mtl_uom_conversions_view mucv

Line 2103: FROM wip_move_txn_interface wmti

2099: wmti.request_id,
2100: wmti.program_application_id,
2101: wmti.program_id,
2102: wmti.program_update_date
2103: FROM wip_move_txn_interface wmti
2104: WHERE wmti.group_id = g_group_id
2105: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2106: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2107: AND wmti.overcompletion_primary_qty = 0;

Line 2143: FROM wip_move_txn_interface wmti,

2139: wmti.request_id,
2140: wmti.program_application_id,
2141: wmti.program_id,
2142: wmti.program_update_date
2143: FROM wip_move_txn_interface wmti,
2144: mtl_uom_conversions_view mucv
2145: WHERE mucv.organization_id = wmti.organization_id
2146: AND mucv.inventory_item_id = wmti.primary_item_id
2147: AND mucv.uom_code = wmti.transaction_uom

Line 2198: FROM wip_move_txn_interface wmti

2194: wmti.request_id,
2195: wmti.program_application_id,
2196: wmti.program_id,
2197: wmti.program_update_date
2198: FROM wip_move_txn_interface wmti
2199: WHERE wmti.group_id = g_group_id
2200: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2201: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2202: AND wmti.overcompletion_transaction_id IS NOT NULL;

Line 2214: UPDATE wip_move_txn_interface wmti

2210: PROCEDURE reason_id IS
2211: l_errMsg VARCHAR2(240);
2212: BEGIN
2213: -- Derive REASON_ID from REASON_NAME provided
2214: UPDATE wip_move_txn_interface wmti
2215: SET wmti.reason_id =
2216: (SELECT mtr.reason_id
2217: FROM mtl_transaction_reasons mtr
2218: WHERE mtr.reason_name = wmti.reason_name

Line 2260: FROM wip_move_txn_interface wmti

2256: wmti.request_id,
2257: wmti.program_application_id,
2258: wmti.program_id,
2259: wmti.program_update_date
2260: FROM wip_move_txn_interface wmti
2261: WHERE wmti.group_id = g_group_id
2262: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2263: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2264: AND (wmti.reason_id IS NOT NULL OR wmti.reason_name IS NOT NULL)

Line 2313: FROM wip_move_txn_interface wmti,

2309: wmti.request_id,
2310: wmti.program_application_id,
2311: wmti.program_id,
2312: wmti.program_update_date
2313: FROM wip_move_txn_interface wmti,
2314: wip_parameters wp
2315: WHERE wp.organization_id = wmti.organization_id
2316: AND wmti.group_id = g_group_id
2317: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2362: UPDATE wip_move_txn_interface wmti

2358: PROCEDURE last_updated_by IS
2359: l_errMsg VARCHAR2(240);
2360: BEGIN
2361: -- Derive LAST_UPDATED_BY if user provided only LAST_UPDATED_BY_NAME
2362: UPDATE wip_move_txn_interface wmti
2363: SET wmti.last_updated_by =
2364: (SELECT fu.user_id
2365: FROM fnd_user fu
2366: WHERE fu.user_name = wmti.last_updated_by_name

Line 2407: FROM wip_move_txn_interface wmti

2403: wmti.request_id,
2404: wmti.program_application_id,
2405: wmti.program_id,
2406: wmti.program_update_date
2407: FROM wip_move_txn_interface wmti
2408: WHERE wmti.group_id = g_group_id
2409: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2410: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2411: AND wmti.last_updated_by IS NULL; -- cannot derive LAST_UPDATED_BY

Line 2424: UPDATE wip_move_txn_interface wmti

2420: PROCEDURE created_by IS
2421: l_errMsg VARCHAR2(240);
2422: BEGIN
2423: -- Derive CREATED_BY if user provided only CREATED_BY_NAME
2424: UPDATE wip_move_txn_interface wmti
2425: SET wmti.created_by =
2426: (SELECT fu.user_id
2427: FROM fnd_user fu
2428: WHERE fu.user_name = wmti.created_by_name

Line 2469: FROM wip_move_txn_interface wmti

2465: wmti.request_id,
2466: wmti.program_application_id,
2467: wmti.program_id,
2468: wmti.program_update_date
2469: FROM wip_move_txn_interface wmti
2470: WHERE wmti.group_id = g_group_id
2471: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2472: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2473: AND ((wmti.created_by IS NULL) -- cannot derive LAST_UPDATED_BY

Line 2529: FROM wip_move_txn_interface wmti

2525: wmti.request_id,
2526: wmti.program_application_id,
2527: wmti.program_id,
2528: wmti.program_update_date
2529: FROM wip_move_txn_interface wmti
2530: WHERE wmti.group_id = g_group_id
2531: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2532: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2533: AND EXISTS

Line 2609: FROM wip_move_txn_interface wmti

2605: wmti.request_id,
2606: wmti.program_application_id,
2607: wmti.program_id,
2608: wmti.program_update_date
2609: FROM wip_move_txn_interface wmti
2610: WHERE wmti.group_id = g_group_id
2611: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2612: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2613: AND EXISTS

Line 2653: UPDATE wip_move_txn_interface wmti

2649: enums.delete;
2650: -- Users cannot move cross 'Queue' of serialization start op. User need to
2651: -- move 2 step. The first time move to Queue of serialization start op, then
2652: -- serial move. For backward move, do serial move first.
2653: UPDATE wip_move_txn_interface wmti
2654: SET wmti.process_status = WIP_CONSTANTS.ERROR
2655: WHERE wmti.group_id = g_group_id
2656: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2657: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2692: UPDATE wip_move_txn_interface wmti

2688: enums.delete;
2689: -- If user try to do serialized transaction, primary_quantity must be 1.
2690: -- This validation is only for serialized discrete job. For serialized
2691: -- OSFM job, primary_quantity can be more than 1.
2692: UPDATE wip_move_txn_interface wmti
2693: SET wmti.process_status = WIP_CONSTANTS.ERROR
2694: WHERE wmti.group_id = g_group_id
2695: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2696: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2720: UPDATE wip_move_txn_interface wmti

2716: -- reset enums table
2717: enums.delete;
2718: -- if user provide serial number information for non-serialized job, or
2719: -- serialized job with non-serialized move, error out.
2720: UPDATE wip_move_txn_interface wmti
2721: SET wmti.process_status = WIP_CONSTANTS.ERROR
2722: WHERE wmti.group_id = g_group_id
2723: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2724: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2757: UPDATE wip_move_txn_interface wmti

2753: -- reset enums table
2754: enums.delete;
2755: -- if user try to do serialized transaction, number of serial records must be
2756: -- equal to wmti.primary_quantity
2757: UPDATE wip_move_txn_interface wmti
2758: SET wmti.process_status = WIP_CONSTANTS.ERROR
2759: WHERE wmti.group_id = g_group_id
2760: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2761: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2810: UPDATE wip_move_txn_interface wmti

2806: -- reset enums table
2807: enums.delete;
2808: -- if user try to do serialized transaction, the status of the serial
2809: -- must correspond to the transaction type.
2810: UPDATE wip_move_txn_interface wmti
2811: SET wmti.process_status = WIP_CONSTANTS.ERROR
2812: WHERE wmti.group_id = g_group_id
2813: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2814: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2860: UPDATE wip_move_txn_interface wmti

2856: PROCEDURE update_interface_tbl IS
2857: BEGIN
2858: -- there are some errors occur, so set the process_status to error so that
2859: -- move processor will not pick up this record
2860: UPDATE wip_move_txn_interface wmti
2861: SET wmti.process_status = WIP_CONSTANTS.ERROR
2862: WHERE wmti.group_id = g_group_id
2863: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2864: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2887: UPDATE wip_move_txn_interface wmti

2883: -- reset enums table
2884: enums.delete;
2885: -- Users cannot do EZ Completion/EZ Return if an assembly is not transactable
2886: -- or an assembly is not an inventory item.
2887: UPDATE wip_move_txn_interface wmti
2888: SET wmti.process_status = WIP_CONSTANTS.ERROR
2889: WHERE wmti.group_id = g_group_id
2890: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2891: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 2923: UPDATE wip_move_txn_interface wmti

2919: l_NextOpSeq NUMBER;
2920: l_OpExists BOOLEAN;
2921: BEGIN
2922:
2923: UPDATE wip_move_txn_interface wmti
2924: SET (wmti.fm_operation_code,
2925: wmti.fm_department_id,
2926: wmti.fm_department_code,
2927: wmti.to_operation_code,

Line 3165: UPDATE wip_move_txn_interface wmti

3161: g_group_id := p_group_id;
3162: enums.delete;
3163:
3164: -- Derive ACCT_PERIOD_ID from TRANSACTION_DATE
3165: UPDATE wip_move_txn_interface wmti
3166: SET wmti.acct_period_id =
3167: (SELECT oap.acct_period_id
3168: FROM org_acct_periods oap
3169: WHERE oap.organization_id = wmti.organization_id

Line 3184: UPDATE wip_move_txn_interface wmti

3180: -- reset enums table
3181: enums.delete;
3182: -- Error out if there is no open accout period for the TRANSACTION_DATE
3183: -- specified or there is no WIP_PERIOD_BALANCES
3184: UPDATE wip_move_txn_interface wmti
3185: SET wmti.process_status = WIP_CONSTANTS.ERROR
3186: WHERE wmti.group_id = g_group_id
3187: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3188: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3209: UPDATE wip_move_txn_interface wmti

3205: -- reset enums table
3206: enums.delete;
3207: -- Error out if FM_OPERATION_SEQ_NUM/FM_INTRAOPERATION_STEP_TYPE has
3208: -- no move shop floor status attached
3209: UPDATE wip_move_txn_interface wmti
3210: SET wmti.process_status = WIP_CONSTANTS.ERROR
3211: WHERE wmti.group_id = g_group_id
3212: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3213: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3245: wip_move_txn_interface wmti

3241: SELECT ws.shop_floor_status_code
3242: INTO l_sf_status
3243: FROM wip_shop_floor_status_codes wsc,
3244: wip_shop_floor_statuses ws,
3245: wip_move_txn_interface wmti
3246: WHERE wsc.organization_id = wmti.organization_id
3247: AND ws.organization_id = wmti.organization_id
3248: AND ws.wip_entity_id = wmti.wip_entity_id
3249: AND wmti.transaction_id = enums(i)

Line 3269: UPDATE wip_move_txn_interface wmti

3265: -- reset enums table
3266: enums.delete;
3267: -- Error out if user try to easy complete job/schedule that has No Move shop
3268: -- floor status attached to Tomove of the last operation
3269: UPDATE wip_move_txn_interface wmti
3270: SET wmti.process_status = WIP_CONSTANTS.ERROR
3271: WHERE wmti.group_id = g_group_id
3272: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3273: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3297: wip_move_txn_interface wmti

3293: SELECT ws.shop_floor_status_code
3294: INTO l_sf_status
3295: FROM wip_shop_floor_status_codes wsc,
3296: wip_shop_floor_statuses ws,
3297: wip_move_txn_interface wmti
3298: WHERE wsc.organization_id = wmti.organization_id
3299: AND ws.organization_id = wmti.organization_id
3300: AND ws.wip_entity_id = wmti.wip_entity_id
3301: AND wmti.transaction_id = enums(i)

Line 3324: UPDATE wip_move_txn_interface wmti

3320: -- reset enums table
3321: enums.delete;
3322: -- Error out if wip_parameter do not allow move over no_move shop floor
3323: -- status, and there are no_move status in between
3324: UPDATE wip_move_txn_interface wmti
3325: SET wmti.process_status = WIP_CONSTANTS.ERROR
3326: WHERE wmti.group_id = g_group_id
3327: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3328: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3356: from wip_move_txn_interface wmti

3352: wmti.to_operation_seq_num, -- p_to_op
3353: wmti.to_intraoperation_step_type, -- p_to_step
3354: wmti.source_code)
3355: into l_sf_status
3356: from wip_move_txn_interface wmti
3357: where wmti.transaction_id = enums(i)
3358: and wmti.process_status = WIP_CONSTANTS.ERROR;
3359: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_STATUS_BETWEEN');
3360: fnd_message.set_token('SF_STATUS', to_char(l_sf_status));

Line 3376: UPDATE wip_move_txn_interface wmti

3372: update_interface_tbl;
3373:
3374: -- Set WMTI.PROCESS_PHASE to WIP_CONSTANTS.MOVE_PROC so that move processing
3375: -- code can process these records.
3376: UPDATE wip_move_txn_interface wmti
3377: SET process_phase = WIP_CONSTANTS.MOVE_PROC
3378: WHERE wmti.group_id = g_group_id
3379: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3380: AND wmti.process_status = WIP_CONSTANTS.RUNNING;