[Home] [Help]
203: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
204: l_errExp := fnd_message.get;
205: update mtl_transactions_interface
206: set last_update_date = sysdate,
207: last_updated_by = fnd_global.user_id,
208: last_update_login = fnd_global.login_id,
209: program_application_id = fnd_global.prog_appl_id,
210: program_id = fnd_global.conc_program_id,
211: program_update_date = sysdate,
204: l_errExp := fnd_message.get;
205: update mtl_transactions_interface
206: set last_update_date = sysdate,
207: last_updated_by = fnd_global.user_id,
208: last_update_login = fnd_global.login_id,
209: program_application_id = fnd_global.prog_appl_id,
210: program_id = fnd_global.conc_program_id,
211: program_update_date = sysdate,
212: request_id = fnd_global.conc_request_id,
205: update mtl_transactions_interface
206: set last_update_date = sysdate,
207: last_updated_by = fnd_global.user_id,
208: last_update_login = fnd_global.login_id,
209: program_application_id = fnd_global.prog_appl_id,
210: program_id = fnd_global.conc_program_id,
211: program_update_date = sysdate,
212: request_id = fnd_global.conc_request_id,
213: process_flag = 3,
206: set last_update_date = sysdate,
207: last_updated_by = fnd_global.user_id,
208: last_update_login = fnd_global.login_id,
209: program_application_id = fnd_global.prog_appl_id,
210: program_id = fnd_global.conc_program_id,
211: program_update_date = sysdate,
212: request_id = fnd_global.conc_request_id,
213: process_flag = 3,
214: lock_flag = 2,
208: last_update_login = fnd_global.login_id,
209: program_application_id = fnd_global.prog_appl_id,
210: program_id = fnd_global.conc_program_id,
211: program_update_date = sysdate,
212: request_id = fnd_global.conc_request_id,
213: process_flag = 3,
214: lock_flag = 2,
215: error_code = 'wip_mti_pub.preInvWIPProcessing',
216: error_explanation = l_errExp
223: l_tbls.overCplPriQty(i) := l_convOverCplPriQty;
224:
225: update mtl_transactions_interface
226: set last_update_date = sysdate,
227: last_updated_by = fnd_global.user_id,
228: last_update_login = fnd_global.login_id,
229: program_application_id = fnd_global.prog_appl_id,
230: program_id = fnd_global.conc_program_id,
231: program_update_date = sysdate,
224:
225: update mtl_transactions_interface
226: set last_update_date = sysdate,
227: last_updated_by = fnd_global.user_id,
228: last_update_login = fnd_global.login_id,
229: program_application_id = fnd_global.prog_appl_id,
230: program_id = fnd_global.conc_program_id,
231: program_update_date = sysdate,
232: request_id = fnd_global.conc_request_id,
225: update mtl_transactions_interface
226: set last_update_date = sysdate,
227: last_updated_by = fnd_global.user_id,
228: last_update_login = fnd_global.login_id,
229: program_application_id = fnd_global.prog_appl_id,
230: program_id = fnd_global.conc_program_id,
231: program_update_date = sysdate,
232: request_id = fnd_global.conc_request_id,
233: primary_quantity = l_tbls.priQty(i),
226: set last_update_date = sysdate,
227: last_updated_by = fnd_global.user_id,
228: last_update_login = fnd_global.login_id,
229: program_application_id = fnd_global.prog_appl_id,
230: program_id = fnd_global.conc_program_id,
231: program_update_date = sysdate,
232: request_id = fnd_global.conc_request_id,
233: primary_quantity = l_tbls.priQty(i),
234: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
228: last_update_login = fnd_global.login_id,
229: program_application_id = fnd_global.prog_appl_id,
230: program_id = fnd_global.conc_program_id,
231: program_update_date = sysdate,
232: request_id = fnd_global.conc_request_id,
233: primary_quantity = l_tbls.priQty(i),
234: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
235: where transaction_interface_id = l_tbls.txnIntID(i);
236: if(l_logLevel <= wip_constants.full_logging) then
263:
264: forall i in 1..l_errTbls.txnIntID.count
265: update mtl_transactions_interface
266: set last_update_date = sysdate,
267: last_updated_by = fnd_global.user_id,
268: last_update_login = fnd_global.login_id,
269: program_application_id = fnd_global.prog_appl_id,
270: program_id = fnd_global.conc_program_id,
271: program_update_date = sysdate,
264: forall i in 1..l_errTbls.txnIntID.count
265: update mtl_transactions_interface
266: set last_update_date = sysdate,
267: last_updated_by = fnd_global.user_id,
268: last_update_login = fnd_global.login_id,
269: program_application_id = fnd_global.prog_appl_id,
270: program_id = fnd_global.conc_program_id,
271: program_update_date = sysdate,
272: request_id = fnd_global.conc_request_id,
265: update mtl_transactions_interface
266: set last_update_date = sysdate,
267: last_updated_by = fnd_global.user_id,
268: last_update_login = fnd_global.login_id,
269: program_application_id = fnd_global.prog_appl_id,
270: program_id = fnd_global.conc_program_id,
271: program_update_date = sysdate,
272: request_id = fnd_global.conc_request_id,
273: process_flag = wip_constants.mti_error,
266: set last_update_date = sysdate,
267: last_updated_by = fnd_global.user_id,
268: last_update_login = fnd_global.login_id,
269: program_application_id = fnd_global.prog_appl_id,
270: program_id = fnd_global.conc_program_id,
271: program_update_date = sysdate,
272: request_id = fnd_global.conc_request_id,
273: process_flag = wip_constants.mti_error,
274: error_code = l_errTbls.errCode(i),
268: last_update_login = fnd_global.login_id,
269: program_application_id = fnd_global.prog_appl_id,
270: program_id = fnd_global.conc_program_id,
271: program_update_date = sysdate,
272: request_id = fnd_global.conc_request_id,
273: process_flag = wip_constants.mti_error,
274: error_code = l_errTbls.errCode(i),
275: error_explanation = l_errTbls.errExpl(i),
276: lock_flag = 2 --unlock the record so it can be re-submitted
299: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
300:
301: update mtl_transactions_interface
302: set last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id,
305: program_application_id = fnd_global.prog_appl_id,
306: program_id = fnd_global.conc_program_id,
307: program_update_date = sysdate,
300:
301: update mtl_transactions_interface
302: set last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id,
305: program_application_id = fnd_global.prog_appl_id,
306: program_id = fnd_global.conc_program_id,
307: program_update_date = sysdate,
308: request_id = fnd_global.conc_request_id,
301: update mtl_transactions_interface
302: set last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id,
305: program_application_id = fnd_global.prog_appl_id,
306: program_id = fnd_global.conc_program_id,
307: program_update_date = sysdate,
308: request_id = fnd_global.conc_request_id,
309: process_flag = 3,
302: set last_update_date = sysdate,
303: last_updated_by = fnd_global.user_id,
304: last_update_login = fnd_global.login_id,
305: program_application_id = fnd_global.prog_appl_id,
306: program_id = fnd_global.conc_program_id,
307: program_update_date = sysdate,
308: request_id = fnd_global.conc_request_id,
309: process_flag = 3,
310: lock_flag = 2,
304: last_update_login = fnd_global.login_id,
305: program_application_id = fnd_global.prog_appl_id,
306: program_id = fnd_global.conc_program_id,
307: program_update_date = sysdate,
308: request_id = fnd_global.conc_request_id,
309: process_flag = 3,
310: lock_flag = 2,
311: error_code = 'wip_mti_pub.preInvWIPProcessing',
312: error_explanation = l_errExp
767: fnd_message.set_token('ENTITY', 'Transactions');
768: l_errMsg := substrb(fnd_message.get, 1, 240);
769: update mtl_transactions_interface mti
770: set last_update_date = sysdate,
771: last_updated_by = fnd_global.user_id,
772: last_update_login = fnd_global.login_id,
773: program_application_id = fnd_global.prog_appl_id,
774: program_id = fnd_global.conc_program_id,
775: program_update_date = sysdate,
768: l_errMsg := substrb(fnd_message.get, 1, 240);
769: update mtl_transactions_interface mti
770: set last_update_date = sysdate,
771: last_updated_by = fnd_global.user_id,
772: last_update_login = fnd_global.login_id,
773: program_application_id = fnd_global.prog_appl_id,
774: program_id = fnd_global.conc_program_id,
775: program_update_date = sysdate,
776: request_id = fnd_global.conc_request_id,
769: update mtl_transactions_interface mti
770: set last_update_date = sysdate,
771: last_updated_by = fnd_global.user_id,
772: last_update_login = fnd_global.login_id,
773: program_application_id = fnd_global.prog_appl_id,
774: program_id = fnd_global.conc_program_id,
775: program_update_date = sysdate,
776: request_id = fnd_global.conc_request_id,
777: process_flag = 3,
770: set last_update_date = sysdate,
771: last_updated_by = fnd_global.user_id,
772: last_update_login = fnd_global.login_id,
773: program_application_id = fnd_global.prog_appl_id,
774: program_id = fnd_global.conc_program_id,
775: program_update_date = sysdate,
776: request_id = fnd_global.conc_request_id,
777: process_flag = 3,
778: lock_flag = 2,
772: last_update_login = fnd_global.login_id,
773: program_application_id = fnd_global.prog_appl_id,
774: program_id = fnd_global.conc_program_id,
775: program_update_date = sysdate,
776: request_id = fnd_global.conc_request_id,
777: process_flag = 3,
778: lock_flag = 2,
779: error_code = 'Transaction',
780: error_explanation = l_errMsg
789: fnd_message.set_token('ENTITY', 'line');
790: l_errMsg := substrb(fnd_message.get, 1, 240);
791: update mtl_transactions_interface mti
792: set last_update_date = sysdate,
793: last_updated_by = fnd_global.user_id,
794: last_update_login = fnd_global.login_id,
795: program_application_id = fnd_global.prog_appl_id,
796: program_id = fnd_global.conc_program_id,
797: program_update_date = sysdate,
790: l_errMsg := substrb(fnd_message.get, 1, 240);
791: update mtl_transactions_interface mti
792: set last_update_date = sysdate,
793: last_updated_by = fnd_global.user_id,
794: last_update_login = fnd_global.login_id,
795: program_application_id = fnd_global.prog_appl_id,
796: program_id = fnd_global.conc_program_id,
797: program_update_date = sysdate,
798: request_id = fnd_global.conc_request_id,
791: update mtl_transactions_interface mti
792: set last_update_date = sysdate,
793: last_updated_by = fnd_global.user_id,
794: last_update_login = fnd_global.login_id,
795: program_application_id = fnd_global.prog_appl_id,
796: program_id = fnd_global.conc_program_id,
797: program_update_date = sysdate,
798: request_id = fnd_global.conc_request_id,
799: process_flag = 3,
792: set last_update_date = sysdate,
793: last_updated_by = fnd_global.user_id,
794: last_update_login = fnd_global.login_id,
795: program_application_id = fnd_global.prog_appl_id,
796: program_id = fnd_global.conc_program_id,
797: program_update_date = sysdate,
798: request_id = fnd_global.conc_request_id,
799: process_flag = 3,
800: lock_flag = 2,
794: last_update_login = fnd_global.login_id,
795: program_application_id = fnd_global.prog_appl_id,
796: program_id = fnd_global.conc_program_id,
797: program_update_date = sysdate,
798: request_id = fnd_global.conc_request_id,
799: process_flag = 3,
800: lock_flag = 2,
801: error_code = 'repetitive_line_id',
802: error_explanation = l_errMsg
819: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
820: l_errMsg := substrb(fnd_message.get, 1, 240);
821: update mtl_transactions_interface mti
822: set last_update_date = sysdate,
823: last_updated_by = fnd_global.user_id,
824: last_update_login = fnd_global.login_id,
825: program_application_id = fnd_global.prog_appl_id,
826: program_id = fnd_global.conc_program_id,
827: program_update_date = sysdate,
820: l_errMsg := substrb(fnd_message.get, 1, 240);
821: update mtl_transactions_interface mti
822: set last_update_date = sysdate,
823: last_updated_by = fnd_global.user_id,
824: last_update_login = fnd_global.login_id,
825: program_application_id = fnd_global.prog_appl_id,
826: program_id = fnd_global.conc_program_id,
827: program_update_date = sysdate,
828: request_id = fnd_global.conc_request_id,
821: update mtl_transactions_interface mti
822: set last_update_date = sysdate,
823: last_updated_by = fnd_global.user_id,
824: last_update_login = fnd_global.login_id,
825: program_application_id = fnd_global.prog_appl_id,
826: program_id = fnd_global.conc_program_id,
827: program_update_date = sysdate,
828: request_id = fnd_global.conc_request_id,
829: process_flag = 3,
822: set last_update_date = sysdate,
823: last_updated_by = fnd_global.user_id,
824: last_update_login = fnd_global.login_id,
825: program_application_id = fnd_global.prog_appl_id,
826: program_id = fnd_global.conc_program_id,
827: program_update_date = sysdate,
828: request_id = fnd_global.conc_request_id,
829: process_flag = 3,
830: lock_flag = 2,
824: last_update_login = fnd_global.login_id,
825: program_application_id = fnd_global.prog_appl_id,
826: program_id = fnd_global.conc_program_id,
827: program_update_date = sysdate,
828: request_id = fnd_global.conc_request_id,
829: process_flag = 3,
830: lock_flag = 2,
831: error_code = 'repetitive_line_id',
832: error_explanation = l_errMsg
845: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
846: l_errMsg := substrb(fnd_message.get, 1, 240);
847: update mtl_transactions_interface mti
848: set last_update_date = sysdate,
849: last_updated_by = fnd_global.user_id,
850: last_update_login = fnd_global.login_id,
851: program_application_id = fnd_global.prog_appl_id,
852: program_id = fnd_global.conc_program_id,
853: program_update_date = sysdate,
846: l_errMsg := substrb(fnd_message.get, 1, 240);
847: update mtl_transactions_interface mti
848: set last_update_date = sysdate,
849: last_updated_by = fnd_global.user_id,
850: last_update_login = fnd_global.login_id,
851: program_application_id = fnd_global.prog_appl_id,
852: program_id = fnd_global.conc_program_id,
853: program_update_date = sysdate,
854: request_id = fnd_global.conc_request_id,
847: update mtl_transactions_interface mti
848: set last_update_date = sysdate,
849: last_updated_by = fnd_global.user_id,
850: last_update_login = fnd_global.login_id,
851: program_application_id = fnd_global.prog_appl_id,
852: program_id = fnd_global.conc_program_id,
853: program_update_date = sysdate,
854: request_id = fnd_global.conc_request_id,
855: process_flag = 3,
848: set last_update_date = sysdate,
849: last_updated_by = fnd_global.user_id,
850: last_update_login = fnd_global.login_id,
851: program_application_id = fnd_global.prog_appl_id,
852: program_id = fnd_global.conc_program_id,
853: program_update_date = sysdate,
854: request_id = fnd_global.conc_request_id,
855: process_flag = 3,
856: lock_flag = 2,
850: last_update_login = fnd_global.login_id,
851: program_application_id = fnd_global.prog_appl_id,
852: program_id = fnd_global.conc_program_id,
853: program_update_date = sysdate,
854: request_id = fnd_global.conc_request_id,
855: process_flag = 3,
856: lock_flag = 2,
857: error_code = 'transaction_source_id',
858: error_explanation = l_errMsg
880: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');
881: l_errMsg := substrb(fnd_message.get, 1, 240);
882: update mtl_transactions_interface mti
883: set last_update_date = sysdate,
884: last_updated_by = fnd_global.user_id,
885: last_update_login = fnd_global.login_id,
886: program_application_id = fnd_global.prog_appl_id,
887: program_id = fnd_global.conc_program_id,
888: program_update_date = sysdate,
881: l_errMsg := substrb(fnd_message.get, 1, 240);
882: update mtl_transactions_interface mti
883: set last_update_date = sysdate,
884: last_updated_by = fnd_global.user_id,
885: last_update_login = fnd_global.login_id,
886: program_application_id = fnd_global.prog_appl_id,
887: program_id = fnd_global.conc_program_id,
888: program_update_date = sysdate,
889: request_id = fnd_global.conc_request_id,
882: update mtl_transactions_interface mti
883: set last_update_date = sysdate,
884: last_updated_by = fnd_global.user_id,
885: last_update_login = fnd_global.login_id,
886: program_application_id = fnd_global.prog_appl_id,
887: program_id = fnd_global.conc_program_id,
888: program_update_date = sysdate,
889: request_id = fnd_global.conc_request_id,
890: process_flag = 3,
883: set last_update_date = sysdate,
884: last_updated_by = fnd_global.user_id,
885: last_update_login = fnd_global.login_id,
886: program_application_id = fnd_global.prog_appl_id,
887: program_id = fnd_global.conc_program_id,
888: program_update_date = sysdate,
889: request_id = fnd_global.conc_request_id,
890: process_flag = 3,
891: lock_flag = 2,
885: last_update_login = fnd_global.login_id,
886: program_application_id = fnd_global.prog_appl_id,
887: program_id = fnd_global.conc_program_id,
888: program_update_date = sysdate,
889: request_id = fnd_global.conc_request_id,
890: process_flag = 3,
891: lock_flag = 2,
892: error_code = 'transaction_source_id',
893: error_explanation = l_errMsg
911:
912: -- derive earliest valid schedule
913: update mtl_transactions_interface mti
914: set last_update_date = sysdate,
915: last_updated_by = fnd_global.user_id,
916: last_update_login = fnd_global.login_id,
917: program_application_id = fnd_global.prog_appl_id,
918: program_id = fnd_global.conc_program_id,
919: program_update_date = sysdate,
912: -- derive earliest valid schedule
913: update mtl_transactions_interface mti
914: set last_update_date = sysdate,
915: last_updated_by = fnd_global.user_id,
916: last_update_login = fnd_global.login_id,
917: program_application_id = fnd_global.prog_appl_id,
918: program_id = fnd_global.conc_program_id,
919: program_update_date = sysdate,
920: request_id = fnd_global.conc_request_id,
913: update mtl_transactions_interface mti
914: set last_update_date = sysdate,
915: last_updated_by = fnd_global.user_id,
916: last_update_login = fnd_global.login_id,
917: program_application_id = fnd_global.prog_appl_id,
918: program_id = fnd_global.conc_program_id,
919: program_update_date = sysdate,
920: request_id = fnd_global.conc_request_id,
921: schedule_id = (select repetitive_schedule_id
914: set last_update_date = sysdate,
915: last_updated_by = fnd_global.user_id,
916: last_update_login = fnd_global.login_id,
917: program_application_id = fnd_global.prog_appl_id,
918: program_id = fnd_global.conc_program_id,
919: program_update_date = sysdate,
920: request_id = fnd_global.conc_request_id,
921: schedule_id = (select repetitive_schedule_id
922: from wip_repetitive_schedules wrs1
916: last_update_login = fnd_global.login_id,
917: program_application_id = fnd_global.prog_appl_id,
918: program_id = fnd_global.conc_program_id,
919: program_update_date = sysdate,
920: request_id = fnd_global.conc_request_id,
921: schedule_id = (select repetitive_schedule_id
922: from wip_repetitive_schedules wrs1
923: where wrs1.organization_id = mti.organization_id
924: and wrs1.wip_entity_id = mti.transaction_source_id
939:
940: -- derive op seq num for completions
941: update mtl_transactions_interface mti
942: set last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id,
945: program_application_id = fnd_global.prog_appl_id,
946: program_id = fnd_global.conc_program_id,
947: program_update_date = sysdate,
940: -- derive op seq num for completions
941: update mtl_transactions_interface mti
942: set last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id,
945: program_application_id = fnd_global.prog_appl_id,
946: program_id = fnd_global.conc_program_id,
947: program_update_date = sysdate,
948: request_id = fnd_global.conc_request_id,
941: update mtl_transactions_interface mti
942: set last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id,
945: program_application_id = fnd_global.prog_appl_id,
946: program_id = fnd_global.conc_program_id,
947: program_update_date = sysdate,
948: request_id = fnd_global.conc_request_id,
949: operation_seq_num = (select max(operation_seq_num)
942: set last_update_date = sysdate,
943: last_updated_by = fnd_global.user_id,
944: last_update_login = fnd_global.login_id,
945: program_application_id = fnd_global.prog_appl_id,
946: program_id = fnd_global.conc_program_id,
947: program_update_date = sysdate,
948: request_id = fnd_global.conc_request_id,
949: operation_seq_num = (select max(operation_seq_num)
950: from wip_operations wo
944: last_update_login = fnd_global.login_id,
945: program_application_id = fnd_global.prog_appl_id,
946: program_id = fnd_global.conc_program_id,
947: program_update_date = sysdate,
948: request_id = fnd_global.conc_request_id,
949: operation_seq_num = (select max(operation_seq_num)
950: from wip_operations wo
951: where wo.organization_id = mti.organization_id
952: and wo.wip_entity_id = mti.transaction_source_id
962:
963: -- derive op seq num for wip component issue/return
964: update mtl_transactions_interface mti
965: set last_update_date = sysdate,
966: last_updated_by = fnd_global.user_id,
967: last_update_login = fnd_global.login_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
963: -- derive op seq num for wip component issue/return
964: update mtl_transactions_interface mti
965: set last_update_date = sysdate,
966: last_updated_by = fnd_global.user_id,
967: last_update_login = fnd_global.login_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: request_id = fnd_global.conc_request_id,
964: update mtl_transactions_interface mti
965: set last_update_date = sysdate,
966: last_updated_by = fnd_global.user_id,
967: last_update_login = fnd_global.login_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: request_id = fnd_global.conc_request_id,
972: operation_seq_num = (select nvl(max(operation_seq_num), 1)
965: set last_update_date = sysdate,
966: last_updated_by = fnd_global.user_id,
967: last_update_login = fnd_global.login_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: request_id = fnd_global.conc_request_id,
972: operation_seq_num = (select nvl(max(operation_seq_num), 1)
973: from wip_operations wo
967: last_update_login = fnd_global.login_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: request_id = fnd_global.conc_request_id,
972: operation_seq_num = (select nvl(max(operation_seq_num), 1)
973: from wip_operations wo
974: where wo.organization_id = mti.organization_id
975: and wo.wip_entity_id = mti.transaction_source_id
989: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
990: l_errMsg := substrb(fnd_message.get, 1, 240);
991: update mtl_transactions_interface mti
992: set last_update_date = sysdate,
993: last_updated_by = fnd_global.user_id,
994: last_update_login = fnd_global.login_id,
995: program_application_id = fnd_global.prog_appl_id,
996: program_id = fnd_global.conc_program_id,
997: program_update_date = sysdate,
990: l_errMsg := substrb(fnd_message.get, 1, 240);
991: update mtl_transactions_interface mti
992: set last_update_date = sysdate,
993: last_updated_by = fnd_global.user_id,
994: last_update_login = fnd_global.login_id,
995: program_application_id = fnd_global.prog_appl_id,
996: program_id = fnd_global.conc_program_id,
997: program_update_date = sysdate,
998: request_id = fnd_global.conc_request_id,
991: update mtl_transactions_interface mti
992: set last_update_date = sysdate,
993: last_updated_by = fnd_global.user_id,
994: last_update_login = fnd_global.login_id,
995: program_application_id = fnd_global.prog_appl_id,
996: program_id = fnd_global.conc_program_id,
997: program_update_date = sysdate,
998: request_id = fnd_global.conc_request_id,
999: process_flag = 3,
992: set last_update_date = sysdate,
993: last_updated_by = fnd_global.user_id,
994: last_update_login = fnd_global.login_id,
995: program_application_id = fnd_global.prog_appl_id,
996: program_id = fnd_global.conc_program_id,
997: program_update_date = sysdate,
998: request_id = fnd_global.conc_request_id,
999: process_flag = 3,
1000: lock_flag = 2,
994: last_update_login = fnd_global.login_id,
995: program_application_id = fnd_global.prog_appl_id,
996: program_id = fnd_global.conc_program_id,
997: program_update_date = sysdate,
998: request_id = fnd_global.conc_request_id,
999: process_flag = 3,
1000: lock_flag = 2,
1001: error_code = 'operation_seq_num',
1002: error_explanation = l_errMsg
1038: l_engItemFlag := 2; -- default to not an engineering item
1039: end;
1040: update mtl_transactions_interface mti
1041: set last_update_date = sysdate,
1042: last_updated_by = fnd_global.user_id,
1043: last_update_login = fnd_global.login_id,
1044: program_application_id = fnd_global.prog_appl_id,
1045: program_id = fnd_global.conc_program_id,
1046: program_update_date = sysdate,
1039: end;
1040: update mtl_transactions_interface mti
1041: set last_update_date = sysdate,
1042: last_updated_by = fnd_global.user_id,
1043: last_update_login = fnd_global.login_id,
1044: program_application_id = fnd_global.prog_appl_id,
1045: program_id = fnd_global.conc_program_id,
1046: program_update_date = sysdate,
1047: request_id = fnd_global.conc_request_id,
1040: update mtl_transactions_interface mti
1041: set last_update_date = sysdate,
1042: last_updated_by = fnd_global.user_id,
1043: last_update_login = fnd_global.login_id,
1044: program_application_id = fnd_global.prog_appl_id,
1045: program_id = fnd_global.conc_program_id,
1046: program_update_date = sysdate,
1047: request_id = fnd_global.conc_request_id,
1048: process_flag = 3,
1041: set last_update_date = sysdate,
1042: last_updated_by = fnd_global.user_id,
1043: last_update_login = fnd_global.login_id,
1044: program_application_id = fnd_global.prog_appl_id,
1045: program_id = fnd_global.conc_program_id,
1046: program_update_date = sysdate,
1047: request_id = fnd_global.conc_request_id,
1048: process_flag = 3,
1049: lock_flag = 2,
1043: last_update_login = fnd_global.login_id,
1044: program_application_id = fnd_global.prog_appl_id,
1045: program_id = fnd_global.conc_program_id,
1046: program_update_date = sysdate,
1047: request_id = fnd_global.conc_request_id,
1048: process_flag = 3,
1049: lock_flag = 2,
1050: error_code = 'inventory_item_id',
1051: error_explanation = l_errMsg
1092: fnd_message.set_name('WIP', 'WIP_STATUS_NO_TXN2');
1093: l_errMsg := substrb(fnd_message.get, 1, 240);
1094: update mtl_transactions_interface mti
1095: set last_update_date = sysdate,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_login = fnd_global.login_id,
1098: program_application_id = fnd_global.prog_appl_id,
1099: program_id = fnd_global.conc_program_id,
1100: program_update_date = sysdate,
1093: l_errMsg := substrb(fnd_message.get, 1, 240);
1094: update mtl_transactions_interface mti
1095: set last_update_date = sysdate,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_login = fnd_global.login_id,
1098: program_application_id = fnd_global.prog_appl_id,
1099: program_id = fnd_global.conc_program_id,
1100: program_update_date = sysdate,
1101: request_id = fnd_global.conc_request_id,
1094: update mtl_transactions_interface mti
1095: set last_update_date = sysdate,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_login = fnd_global.login_id,
1098: program_application_id = fnd_global.prog_appl_id,
1099: program_id = fnd_global.conc_program_id,
1100: program_update_date = sysdate,
1101: request_id = fnd_global.conc_request_id,
1102: process_flag = 3,
1095: set last_update_date = sysdate,
1096: last_updated_by = fnd_global.user_id,
1097: last_update_login = fnd_global.login_id,
1098: program_application_id = fnd_global.prog_appl_id,
1099: program_id = fnd_global.conc_program_id,
1100: program_update_date = sysdate,
1101: request_id = fnd_global.conc_request_id,
1102: process_flag = 3,
1103: lock_flag = 2,
1097: last_update_login = fnd_global.login_id,
1098: program_application_id = fnd_global.prog_appl_id,
1099: program_id = fnd_global.conc_program_id,
1100: program_update_date = sysdate,
1101: request_id = fnd_global.conc_request_id,
1102: process_flag = 3,
1103: lock_flag = 2,
1104: error_code = 'operation_seq_num',
1105: error_explanation = l_errMsg
1128: fnd_message.set_token('ENTITY', 'final_completion_flag');
1129: l_errMsg := substrb(fnd_message.get, 1, 240);
1130: update mtl_transactions_interface mti
1131: set last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id,
1134: program_application_id = fnd_global.prog_appl_id,
1135: program_id = fnd_global.conc_program_id,
1136: program_update_date = sysdate,
1129: l_errMsg := substrb(fnd_message.get, 1, 240);
1130: update mtl_transactions_interface mti
1131: set last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id,
1134: program_application_id = fnd_global.prog_appl_id,
1135: program_id = fnd_global.conc_program_id,
1136: program_update_date = sysdate,
1137: request_id = fnd_global.conc_request_id,
1130: update mtl_transactions_interface mti
1131: set last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id,
1134: program_application_id = fnd_global.prog_appl_id,
1135: program_id = fnd_global.conc_program_id,
1136: program_update_date = sysdate,
1137: request_id = fnd_global.conc_request_id,
1138: process_flag = 3,
1131: set last_update_date = sysdate,
1132: last_updated_by = fnd_global.user_id,
1133: last_update_login = fnd_global.login_id,
1134: program_application_id = fnd_global.prog_appl_id,
1135: program_id = fnd_global.conc_program_id,
1136: program_update_date = sysdate,
1137: request_id = fnd_global.conc_request_id,
1138: process_flag = 3,
1139: lock_flag = 2,
1133: last_update_login = fnd_global.login_id,
1134: program_application_id = fnd_global.prog_appl_id,
1135: program_id = fnd_global.conc_program_id,
1136: program_update_date = sysdate,
1137: request_id = fnd_global.conc_request_id,
1138: process_flag = 3,
1139: lock_flag = 2,
1140: error_code = 'final_completion_flag',
1141: error_explanation = l_errMsg
1149:
1150: -- derive item revision for completion txns for discrete jobs
1151: update mtl_transactions_interface mti
1152: set last_update_date = sysdate,
1153: last_updated_by = fnd_global.user_id,
1154: last_update_login = fnd_global.login_id,
1155: program_application_id = fnd_global.prog_appl_id,
1156: program_id = fnd_global.conc_program_id,
1157: program_update_date = sysdate,
1150: -- derive item revision for completion txns for discrete jobs
1151: update mtl_transactions_interface mti
1152: set last_update_date = sysdate,
1153: last_updated_by = fnd_global.user_id,
1154: last_update_login = fnd_global.login_id,
1155: program_application_id = fnd_global.prog_appl_id,
1156: program_id = fnd_global.conc_program_id,
1157: program_update_date = sysdate,
1158: request_id = fnd_global.conc_request_id,
1151: update mtl_transactions_interface mti
1152: set last_update_date = sysdate,
1153: last_updated_by = fnd_global.user_id,
1154: last_update_login = fnd_global.login_id,
1155: program_application_id = fnd_global.prog_appl_id,
1156: program_id = fnd_global.conc_program_id,
1157: program_update_date = sysdate,
1158: request_id = fnd_global.conc_request_id,
1159: revision = (select nvl(mti.revision, wdj.bom_revision)
1152: set last_update_date = sysdate,
1153: last_updated_by = fnd_global.user_id,
1154: last_update_login = fnd_global.login_id,
1155: program_application_id = fnd_global.prog_appl_id,
1156: program_id = fnd_global.conc_program_id,
1157: program_update_date = sysdate,
1158: request_id = fnd_global.conc_request_id,
1159: revision = (select nvl(mti.revision, wdj.bom_revision)
1160: from wip_discrete_jobs wdj
1154: last_update_login = fnd_global.login_id,
1155: program_application_id = fnd_global.prog_appl_id,
1156: program_id = fnd_global.conc_program_id,
1157: program_update_date = sysdate,
1158: request_id = fnd_global.conc_request_id,
1159: revision = (select nvl(mti.revision, wdj.bom_revision)
1160: from wip_discrete_jobs wdj
1161: where wdj.organization_id = mti.organization_id
1162: and wdj.wip_entity_id = mti.transaction_source_id)
1175:
1176: -- derive item revision for completion txns for repetitive
1177: update mtl_transactions_interface mti
1178: set last_update_date = sysdate,
1179: last_updated_by = fnd_global.user_id,
1180: last_update_login = fnd_global.login_id,
1181: program_application_id = fnd_global.prog_appl_id,
1182: program_id = fnd_global.conc_program_id,
1183: program_update_date = sysdate,
1176: -- derive item revision for completion txns for repetitive
1177: update mtl_transactions_interface mti
1178: set last_update_date = sysdate,
1179: last_updated_by = fnd_global.user_id,
1180: last_update_login = fnd_global.login_id,
1181: program_application_id = fnd_global.prog_appl_id,
1182: program_id = fnd_global.conc_program_id,
1183: program_update_date = sysdate,
1184: request_id = fnd_global.conc_request_id,
1177: update mtl_transactions_interface mti
1178: set last_update_date = sysdate,
1179: last_updated_by = fnd_global.user_id,
1180: last_update_login = fnd_global.login_id,
1181: program_application_id = fnd_global.prog_appl_id,
1182: program_id = fnd_global.conc_program_id,
1183: program_update_date = sysdate,
1184: request_id = fnd_global.conc_request_id,
1185: revision = (select nvl(mti.revision, wrs.bom_revision)
1178: set last_update_date = sysdate,
1179: last_updated_by = fnd_global.user_id,
1180: last_update_login = fnd_global.login_id,
1181: program_application_id = fnd_global.prog_appl_id,
1182: program_id = fnd_global.conc_program_id,
1183: program_update_date = sysdate,
1184: request_id = fnd_global.conc_request_id,
1185: revision = (select nvl(mti.revision, wrs.bom_revision)
1186: from wip_repetitive_schedules wrs
1180: last_update_login = fnd_global.login_id,
1181: program_application_id = fnd_global.prog_appl_id,
1182: program_id = fnd_global.conc_program_id,
1183: program_update_date = sysdate,
1184: request_id = fnd_global.conc_request_id,
1185: revision = (select nvl(mti.revision, wrs.bom_revision)
1186: from wip_repetitive_schedules wrs
1187: where wrs.organization_id = mti.organization_id
1188: and wrs.repetitive_schedule_id = mti.schedule_id)
1200:
1201: -- derive item revision for flow
1202: update mtl_transactions_interface mti
1203: set last_update_date = sysdate,
1204: last_updated_by = fnd_global.user_id,
1205: last_update_login = fnd_global.login_id,
1206: program_application_id = fnd_global.prog_appl_id,
1207: program_id = fnd_global.conc_program_id,
1208: program_update_date = sysdate,
1201: -- derive item revision for flow
1202: update mtl_transactions_interface mti
1203: set last_update_date = sysdate,
1204: last_updated_by = fnd_global.user_id,
1205: last_update_login = fnd_global.login_id,
1206: program_application_id = fnd_global.prog_appl_id,
1207: program_id = fnd_global.conc_program_id,
1208: program_update_date = sysdate,
1209: request_id = fnd_global.conc_request_id,
1202: update mtl_transactions_interface mti
1203: set last_update_date = sysdate,
1204: last_updated_by = fnd_global.user_id,
1205: last_update_login = fnd_global.login_id,
1206: program_application_id = fnd_global.prog_appl_id,
1207: program_id = fnd_global.conc_program_id,
1208: program_update_date = sysdate,
1209: request_id = fnd_global.conc_request_id,
1210: revision = (select nvl(mti.revision, wfs.bom_revision)
1203: set last_update_date = sysdate,
1204: last_updated_by = fnd_global.user_id,
1205: last_update_login = fnd_global.login_id,
1206: program_application_id = fnd_global.prog_appl_id,
1207: program_id = fnd_global.conc_program_id,
1208: program_update_date = sysdate,
1209: request_id = fnd_global.conc_request_id,
1210: revision = (select nvl(mti.revision, wfs.bom_revision)
1211: from wip_flow_schedules wfs
1205: last_update_login = fnd_global.login_id,
1206: program_application_id = fnd_global.prog_appl_id,
1207: program_id = fnd_global.conc_program_id,
1208: program_update_date = sysdate,
1209: request_id = fnd_global.conc_request_id,
1210: revision = (select nvl(mti.revision, wfs.bom_revision)
1211: from wip_flow_schedules wfs
1212: where wfs.organization_id = mti.organization_id
1213: and wfs.wip_entity_id = mti.transaction_source_id)
1226:
1227: -- derive completion_transaction_id for flow components
1228: update mtl_transactions_interface mti
1229: set last_update_date = sysdate,
1230: last_updated_by = fnd_global.user_id,
1231: last_update_login = fnd_global.login_id,
1232: program_application_id = fnd_global.prog_appl_id,
1233: program_id = fnd_global.conc_program_id,
1234: program_update_date = sysdate,
1227: -- derive completion_transaction_id for flow components
1228: update mtl_transactions_interface mti
1229: set last_update_date = sysdate,
1230: last_updated_by = fnd_global.user_id,
1231: last_update_login = fnd_global.login_id,
1232: program_application_id = fnd_global.prog_appl_id,
1233: program_id = fnd_global.conc_program_id,
1234: program_update_date = sysdate,
1235: request_id = fnd_global.conc_request_id,
1228: update mtl_transactions_interface mti
1229: set last_update_date = sysdate,
1230: last_updated_by = fnd_global.user_id,
1231: last_update_login = fnd_global.login_id,
1232: program_application_id = fnd_global.prog_appl_id,
1233: program_id = fnd_global.conc_program_id,
1234: program_update_date = sysdate,
1235: request_id = fnd_global.conc_request_id,
1236: completion_transaction_id = (select completion_transaction_id
1229: set last_update_date = sysdate,
1230: last_updated_by = fnd_global.user_id,
1231: last_update_login = fnd_global.login_id,
1232: program_application_id = fnd_global.prog_appl_id,
1233: program_id = fnd_global.conc_program_id,
1234: program_update_date = sysdate,
1235: request_id = fnd_global.conc_request_id,
1236: completion_transaction_id = (select completion_transaction_id
1237: from mtl_transactions_interface mti2
1231: last_update_login = fnd_global.login_id,
1232: program_application_id = fnd_global.prog_appl_id,
1233: program_id = fnd_global.conc_program_id,
1234: program_update_date = sysdate,
1235: request_id = fnd_global.conc_request_id,
1236: completion_transaction_id = (select completion_transaction_id
1237: from mtl_transactions_interface mti2
1238: where mti.parent_id = mti2.transaction_interface_id)
1239: where transaction_header_id = p_txnHeaderID
1254: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1255: l_errMsg := substrb(fnd_message.get, 1, 240);
1256: update mtl_transactions_interface mti
1257: set last_update_date = sysdate,
1258: last_updated_by = fnd_global.user_id,
1259: last_update_login = fnd_global.login_id,
1260: program_application_id = fnd_global.prog_appl_id,
1261: program_id = fnd_global.conc_program_id,
1262: program_update_date = sysdate,
1255: l_errMsg := substrb(fnd_message.get, 1, 240);
1256: update mtl_transactions_interface mti
1257: set last_update_date = sysdate,
1258: last_updated_by = fnd_global.user_id,
1259: last_update_login = fnd_global.login_id,
1260: program_application_id = fnd_global.prog_appl_id,
1261: program_id = fnd_global.conc_program_id,
1262: program_update_date = sysdate,
1263: request_id = fnd_global.conc_request_id,
1256: update mtl_transactions_interface mti
1257: set last_update_date = sysdate,
1258: last_updated_by = fnd_global.user_id,
1259: last_update_login = fnd_global.login_id,
1260: program_application_id = fnd_global.prog_appl_id,
1261: program_id = fnd_global.conc_program_id,
1262: program_update_date = sysdate,
1263: request_id = fnd_global.conc_request_id,
1264: process_flag = 3,
1257: set last_update_date = sysdate,
1258: last_updated_by = fnd_global.user_id,
1259: last_update_login = fnd_global.login_id,
1260: program_application_id = fnd_global.prog_appl_id,
1261: program_id = fnd_global.conc_program_id,
1262: program_update_date = sysdate,
1263: request_id = fnd_global.conc_request_id,
1264: process_flag = 3,
1265: lock_flag = 2,
1259: last_update_login = fnd_global.login_id,
1260: program_application_id = fnd_global.prog_appl_id,
1261: program_id = fnd_global.conc_program_id,
1262: program_update_date = sysdate,
1263: request_id = fnd_global.conc_request_id,
1264: process_flag = 3,
1265: lock_flag = 2,
1266: error_code = 'revision',
1267: error_explanation = l_errMsg
1289: -- then we should include flow entities as well. Otherwise, we should do
1290: -- that especially for it alone.
1291: update mtl_transactions_interface mti
1292: set last_update_date = sysdate,
1293: last_updated_by = fnd_global.user_id,
1294: last_update_login = fnd_global.login_id,
1295: program_application_id = fnd_global.prog_appl_id,
1296: program_id = fnd_global.conc_program_id,
1297: program_update_date = sysdate,
1290: -- that especially for it alone.
1291: update mtl_transactions_interface mti
1292: set last_update_date = sysdate,
1293: last_updated_by = fnd_global.user_id,
1294: last_update_login = fnd_global.login_id,
1295: program_application_id = fnd_global.prog_appl_id,
1296: program_id = fnd_global.conc_program_id,
1297: program_update_date = sysdate,
1298: request_id = fnd_global.conc_request_id,
1291: update mtl_transactions_interface mti
1292: set last_update_date = sysdate,
1293: last_updated_by = fnd_global.user_id,
1294: last_update_login = fnd_global.login_id,
1295: program_application_id = fnd_global.prog_appl_id,
1296: program_id = fnd_global.conc_program_id,
1297: program_update_date = sysdate,
1298: request_id = fnd_global.conc_request_id,
1299: revision = (select nvl(mti.revision, max(mir.revision))
1292: set last_update_date = sysdate,
1293: last_updated_by = fnd_global.user_id,
1294: last_update_login = fnd_global.login_id,
1295: program_application_id = fnd_global.prog_appl_id,
1296: program_id = fnd_global.conc_program_id,
1297: program_update_date = sysdate,
1298: request_id = fnd_global.conc_request_id,
1299: revision = (select nvl(mti.revision, max(mir.revision))
1300: from mtl_item_revisions mir
1294: last_update_login = fnd_global.login_id,
1295: program_application_id = fnd_global.prog_appl_id,
1296: program_id = fnd_global.conc_program_id,
1297: program_update_date = sysdate,
1298: request_id = fnd_global.conc_request_id,
1299: revision = (select nvl(mti.revision, max(mir.revision))
1300: from mtl_item_revisions mir
1301: where mir.organization_id = mti.organization_id
1302: and mir.inventory_item_id = mti.inventory_item_id
1331: fnd_message.set_name('WIP', 'INV_INT_REVCODE');
1332: l_errMsg := substrb(fnd_message.get, 1, 240);
1333: update mtl_transactions_interface mti
1334: set last_update_date = sysdate,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_login = fnd_global.login_id,
1337: program_application_id = fnd_global.prog_appl_id,
1338: program_id = fnd_global.conc_program_id,
1339: program_update_date = sysdate,
1332: l_errMsg := substrb(fnd_message.get, 1, 240);
1333: update mtl_transactions_interface mti
1334: set last_update_date = sysdate,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_login = fnd_global.login_id,
1337: program_application_id = fnd_global.prog_appl_id,
1338: program_id = fnd_global.conc_program_id,
1339: program_update_date = sysdate,
1340: request_id = fnd_global.conc_request_id,
1333: update mtl_transactions_interface mti
1334: set last_update_date = sysdate,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_login = fnd_global.login_id,
1337: program_application_id = fnd_global.prog_appl_id,
1338: program_id = fnd_global.conc_program_id,
1339: program_update_date = sysdate,
1340: request_id = fnd_global.conc_request_id,
1341: process_flag = 3,
1334: set last_update_date = sysdate,
1335: last_updated_by = fnd_global.user_id,
1336: last_update_login = fnd_global.login_id,
1337: program_application_id = fnd_global.prog_appl_id,
1338: program_id = fnd_global.conc_program_id,
1339: program_update_date = sysdate,
1340: request_id = fnd_global.conc_request_id,
1341: process_flag = 3,
1342: lock_flag = 2,
1336: last_update_login = fnd_global.login_id,
1337: program_application_id = fnd_global.prog_appl_id,
1338: program_id = fnd_global.conc_program_id,
1339: program_update_date = sysdate,
1340: request_id = fnd_global.conc_request_id,
1341: process_flag = 3,
1342: lock_flag = 2,
1343: error_code = 'revision',
1344: error_explanation = l_errMsg
1408: fnd_message.set_token('ENTITY2', 'qty avail to complete');
1409: l_errMsg := substrb(fnd_message.get, 1, 240);
1410: update mtl_transactions_interface mti
1411: set last_update_date = sysdate,
1412: last_updated_by = fnd_global.user_id,
1413: last_update_login = fnd_global.login_id,
1414: program_application_id = fnd_global.prog_appl_id,
1415: program_id = fnd_global.conc_program_id,
1416: program_update_date = sysdate,
1409: l_errMsg := substrb(fnd_message.get, 1, 240);
1410: update mtl_transactions_interface mti
1411: set last_update_date = sysdate,
1412: last_updated_by = fnd_global.user_id,
1413: last_update_login = fnd_global.login_id,
1414: program_application_id = fnd_global.prog_appl_id,
1415: program_id = fnd_global.conc_program_id,
1416: program_update_date = sysdate,
1417: request_id = fnd_global.conc_request_id,
1410: update mtl_transactions_interface mti
1411: set last_update_date = sysdate,
1412: last_updated_by = fnd_global.user_id,
1413: last_update_login = fnd_global.login_id,
1414: program_application_id = fnd_global.prog_appl_id,
1415: program_id = fnd_global.conc_program_id,
1416: program_update_date = sysdate,
1417: request_id = fnd_global.conc_request_id,
1418: process_flag = 3,
1411: set last_update_date = sysdate,
1412: last_updated_by = fnd_global.user_id,
1413: last_update_login = fnd_global.login_id,
1414: program_application_id = fnd_global.prog_appl_id,
1415: program_id = fnd_global.conc_program_id,
1416: program_update_date = sysdate,
1417: request_id = fnd_global.conc_request_id,
1418: process_flag = 3,
1419: lock_flag = 2,
1413: last_update_login = fnd_global.login_id,
1414: program_application_id = fnd_global.prog_appl_id,
1415: program_id = fnd_global.conc_program_id,
1416: program_update_date = sysdate,
1417: request_id = fnd_global.conc_request_id,
1418: process_flag = 3,
1419: lock_flag = 2,
1420: error_code = 'transaction_quantity',
1421: error_explanation = l_errMsg
1452: fnd_message.set_token('ENTITY2', 'job compelete quantity');
1453: l_errMsg := substrb(fnd_message.get, 1, 240);
1454: update mtl_transactions_interface mti
1455: set last_update_date = sysdate,
1456: last_updated_by = fnd_global.user_id,
1457: last_update_login = fnd_global.login_id,
1458: program_application_id = fnd_global.prog_appl_id,
1459: program_id = fnd_global.conc_program_id,
1460: program_update_date = sysdate,
1453: l_errMsg := substrb(fnd_message.get, 1, 240);
1454: update mtl_transactions_interface mti
1455: set last_update_date = sysdate,
1456: last_updated_by = fnd_global.user_id,
1457: last_update_login = fnd_global.login_id,
1458: program_application_id = fnd_global.prog_appl_id,
1459: program_id = fnd_global.conc_program_id,
1460: program_update_date = sysdate,
1461: request_id = fnd_global.conc_request_id,
1454: update mtl_transactions_interface mti
1455: set last_update_date = sysdate,
1456: last_updated_by = fnd_global.user_id,
1457: last_update_login = fnd_global.login_id,
1458: program_application_id = fnd_global.prog_appl_id,
1459: program_id = fnd_global.conc_program_id,
1460: program_update_date = sysdate,
1461: request_id = fnd_global.conc_request_id,
1462: process_flag = 3,
1455: set last_update_date = sysdate,
1456: last_updated_by = fnd_global.user_id,
1457: last_update_login = fnd_global.login_id,
1458: program_application_id = fnd_global.prog_appl_id,
1459: program_id = fnd_global.conc_program_id,
1460: program_update_date = sysdate,
1461: request_id = fnd_global.conc_request_id,
1462: process_flag = 3,
1463: lock_flag = 2,
1457: last_update_login = fnd_global.login_id,
1458: program_application_id = fnd_global.prog_appl_id,
1459: program_id = fnd_global.conc_program_id,
1460: program_update_date = sysdate,
1461: request_id = fnd_global.conc_request_id,
1462: process_flag = 3,
1463: lock_flag = 2,
1464: error_code = 'transaction_quantity',
1465: error_explanation = l_errMsg
1485: fnd_message.set_name('WIP', 'WIP_NO_ASSET_ITEM_MOVE');
1486: l_errMsg := substrb(fnd_message.get, 1, 240);
1487: update mtl_transactions_interface mti
1488: set last_update_date = sysdate,
1489: last_updated_by = fnd_global.user_id,
1490: last_update_login = fnd_global.login_id,
1491: program_application_id = fnd_global.prog_appl_id,
1492: program_id = fnd_global.conc_program_id,
1493: program_update_date = sysdate,
1486: l_errMsg := substrb(fnd_message.get, 1, 240);
1487: update mtl_transactions_interface mti
1488: set last_update_date = sysdate,
1489: last_updated_by = fnd_global.user_id,
1490: last_update_login = fnd_global.login_id,
1491: program_application_id = fnd_global.prog_appl_id,
1492: program_id = fnd_global.conc_program_id,
1493: program_update_date = sysdate,
1494: request_id = fnd_global.conc_request_id,
1487: update mtl_transactions_interface mti
1488: set last_update_date = sysdate,
1489: last_updated_by = fnd_global.user_id,
1490: last_update_login = fnd_global.login_id,
1491: program_application_id = fnd_global.prog_appl_id,
1492: program_id = fnd_global.conc_program_id,
1493: program_update_date = sysdate,
1494: request_id = fnd_global.conc_request_id,
1495: process_flag = 3,
1488: set last_update_date = sysdate,
1489: last_updated_by = fnd_global.user_id,
1490: last_update_login = fnd_global.login_id,
1491: program_application_id = fnd_global.prog_appl_id,
1492: program_id = fnd_global.conc_program_id,
1493: program_update_date = sysdate,
1494: request_id = fnd_global.conc_request_id,
1495: process_flag = 3,
1496: lock_flag = 2,
1490: last_update_login = fnd_global.login_id,
1491: program_application_id = fnd_global.prog_appl_id,
1492: program_id = fnd_global.conc_program_id,
1493: program_update_date = sysdate,
1494: request_id = fnd_global.conc_request_id,
1495: process_flag = 3,
1496: lock_flag = 2,
1497: error_code = 'subinventory_code',
1498: error_explanation = l_errMsg
1525: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');
1526: l_errMsg := substrb(fnd_message.get, 1, 240);
1527: update mtl_transactions_interface mti
1528: set last_update_date = sysdate,
1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id,
1531: program_application_id = fnd_global.prog_appl_id,
1532: program_id = fnd_global.conc_program_id,
1533: program_update_date = sysdate,
1526: l_errMsg := substrb(fnd_message.get, 1, 240);
1527: update mtl_transactions_interface mti
1528: set last_update_date = sysdate,
1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id,
1531: program_application_id = fnd_global.prog_appl_id,
1532: program_id = fnd_global.conc_program_id,
1533: program_update_date = sysdate,
1534: request_id = fnd_global.conc_request_id,
1527: update mtl_transactions_interface mti
1528: set last_update_date = sysdate,
1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id,
1531: program_application_id = fnd_global.prog_appl_id,
1532: program_id = fnd_global.conc_program_id,
1533: program_update_date = sysdate,
1534: request_id = fnd_global.conc_request_id,
1535: process_flag = 3,
1528: set last_update_date = sysdate,
1529: last_updated_by = fnd_global.user_id,
1530: last_update_login = fnd_global.login_id,
1531: program_application_id = fnd_global.prog_appl_id,
1532: program_id = fnd_global.conc_program_id,
1533: program_update_date = sysdate,
1534: request_id = fnd_global.conc_request_id,
1535: process_flag = 3,
1536: lock_flag = 2,
1530: last_update_login = fnd_global.login_id,
1531: program_application_id = fnd_global.prog_appl_id,
1532: program_id = fnd_global.conc_program_id,
1533: program_update_date = sysdate,
1534: request_id = fnd_global.conc_request_id,
1535: process_flag = 3,
1536: lock_flag = 2,
1537: error_code = 'transaction_date',
1538: error_explanation = l_errMsg
1561: fnd_message.set_name('WIP', 'WIP_INVALID_SO');
1562: l_errMsg := substrb(fnd_message.get, 1, 240);
1563: update mtl_transactions_interface mti
1564: set last_update_date = sysdate,
1565: last_updated_by = fnd_global.user_id,
1566: last_update_login = fnd_global.login_id,
1567: program_application_id = fnd_global.prog_appl_id,
1568: program_id = fnd_global.conc_program_id,
1569: program_update_date = sysdate,
1562: l_errMsg := substrb(fnd_message.get, 1, 240);
1563: update mtl_transactions_interface mti
1564: set last_update_date = sysdate,
1565: last_updated_by = fnd_global.user_id,
1566: last_update_login = fnd_global.login_id,
1567: program_application_id = fnd_global.prog_appl_id,
1568: program_id = fnd_global.conc_program_id,
1569: program_update_date = sysdate,
1570: request_id = fnd_global.conc_request_id,
1563: update mtl_transactions_interface mti
1564: set last_update_date = sysdate,
1565: last_updated_by = fnd_global.user_id,
1566: last_update_login = fnd_global.login_id,
1567: program_application_id = fnd_global.prog_appl_id,
1568: program_id = fnd_global.conc_program_id,
1569: program_update_date = sysdate,
1570: request_id = fnd_global.conc_request_id,
1571: process_flag = 3,
1564: set last_update_date = sysdate,
1565: last_updated_by = fnd_global.user_id,
1566: last_update_login = fnd_global.login_id,
1567: program_application_id = fnd_global.prog_appl_id,
1568: program_id = fnd_global.conc_program_id,
1569: program_update_date = sysdate,
1570: request_id = fnd_global.conc_request_id,
1571: process_flag = 3,
1572: lock_flag = 2,
1566: last_update_login = fnd_global.login_id,
1567: program_application_id = fnd_global.prog_appl_id,
1568: program_id = fnd_global.conc_program_id,
1569: program_update_date = sysdate,
1570: request_id = fnd_global.conc_request_id,
1571: process_flag = 3,
1572: lock_flag = 2,
1573: error_code = 'demand_source_header_id',
1574: error_explanation = l_errMsg
1598: fnd_message.set_name('WIP', 'WIP_INVALID_SO_LINE');
1599: l_errMsg := substrb(fnd_message.get, 1, 240);
1600: update mtl_transactions_interface mti
1601: set last_update_date = sysdate,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id,
1604: program_application_id = fnd_global.prog_appl_id,
1605: program_id = fnd_global.conc_program_id,
1606: program_update_date = sysdate,
1599: l_errMsg := substrb(fnd_message.get, 1, 240);
1600: update mtl_transactions_interface mti
1601: set last_update_date = sysdate,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id,
1604: program_application_id = fnd_global.prog_appl_id,
1605: program_id = fnd_global.conc_program_id,
1606: program_update_date = sysdate,
1607: request_id = fnd_global.conc_request_id,
1600: update mtl_transactions_interface mti
1601: set last_update_date = sysdate,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id,
1604: program_application_id = fnd_global.prog_appl_id,
1605: program_id = fnd_global.conc_program_id,
1606: program_update_date = sysdate,
1607: request_id = fnd_global.conc_request_id,
1608: process_flag = 3,
1601: set last_update_date = sysdate,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id,
1604: program_application_id = fnd_global.prog_appl_id,
1605: program_id = fnd_global.conc_program_id,
1606: program_update_date = sysdate,
1607: request_id = fnd_global.conc_request_id,
1608: process_flag = 3,
1609: lock_flag = 2,
1603: last_update_login = fnd_global.login_id,
1604: program_application_id = fnd_global.prog_appl_id,
1605: program_id = fnd_global.conc_program_id,
1606: program_update_date = sysdate,
1607: request_id = fnd_global.conc_request_id,
1608: process_flag = 3,
1609: lock_flag = 2,
1610: error_code = 'demand_source_line',
1611: error_explanation = l_errMsg
1639: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_COMP');
1640: l_errMsg := substrb(fnd_message.get, 1, 240);
1641: update mtl_transactions_interface mti
1642: set last_update_date = sysdate,
1643: last_updated_by = fnd_global.user_id,
1644: last_update_login = fnd_global.login_id,
1645: program_application_id = fnd_global.prog_appl_id,
1646: program_id = fnd_global.conc_program_id,
1647: program_update_date = sysdate,
1640: l_errMsg := substrb(fnd_message.get, 1, 240);
1641: update mtl_transactions_interface mti
1642: set last_update_date = sysdate,
1643: last_updated_by = fnd_global.user_id,
1644: last_update_login = fnd_global.login_id,
1645: program_application_id = fnd_global.prog_appl_id,
1646: program_id = fnd_global.conc_program_id,
1647: program_update_date = sysdate,
1648: request_id = fnd_global.conc_request_id,
1641: update mtl_transactions_interface mti
1642: set last_update_date = sysdate,
1643: last_updated_by = fnd_global.user_id,
1644: last_update_login = fnd_global.login_id,
1645: program_application_id = fnd_global.prog_appl_id,
1646: program_id = fnd_global.conc_program_id,
1647: program_update_date = sysdate,
1648: request_id = fnd_global.conc_request_id,
1649: process_flag = 3,
1642: set last_update_date = sysdate,
1643: last_updated_by = fnd_global.user_id,
1644: last_update_login = fnd_global.login_id,
1645: program_application_id = fnd_global.prog_appl_id,
1646: program_id = fnd_global.conc_program_id,
1647: program_update_date = sysdate,
1648: request_id = fnd_global.conc_request_id,
1649: process_flag = 3,
1650: lock_flag = 2,
1644: last_update_login = fnd_global.login_id,
1645: program_application_id = fnd_global.prog_appl_id,
1646: program_id = fnd_global.conc_program_id,
1647: program_update_date = sysdate,
1648: request_id = fnd_global.conc_request_id,
1649: process_flag = 3,
1650: lock_flag = 2,
1651: error_code = 'demand_source_delivery',
1652: error_explanation = l_errMsg
1676: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_RET');
1677: l_errMsg := substrb(fnd_message.get, 1, 240);
1678: update mtl_transactions_interface mti
1679: set last_update_date = sysdate,
1680: last_updated_by = fnd_global.user_id,
1681: last_update_login = fnd_global.login_id,
1682: program_application_id = fnd_global.prog_appl_id,
1683: program_id = fnd_global.conc_program_id,
1684: program_update_date = sysdate,
1677: l_errMsg := substrb(fnd_message.get, 1, 240);
1678: update mtl_transactions_interface mti
1679: set last_update_date = sysdate,
1680: last_updated_by = fnd_global.user_id,
1681: last_update_login = fnd_global.login_id,
1682: program_application_id = fnd_global.prog_appl_id,
1683: program_id = fnd_global.conc_program_id,
1684: program_update_date = sysdate,
1685: request_id = fnd_global.conc_request_id,
1678: update mtl_transactions_interface mti
1679: set last_update_date = sysdate,
1680: last_updated_by = fnd_global.user_id,
1681: last_update_login = fnd_global.login_id,
1682: program_application_id = fnd_global.prog_appl_id,
1683: program_id = fnd_global.conc_program_id,
1684: program_update_date = sysdate,
1685: request_id = fnd_global.conc_request_id,
1686: process_flag = 3,
1679: set last_update_date = sysdate,
1680: last_updated_by = fnd_global.user_id,
1681: last_update_login = fnd_global.login_id,
1682: program_application_id = fnd_global.prog_appl_id,
1683: program_id = fnd_global.conc_program_id,
1684: program_update_date = sysdate,
1685: request_id = fnd_global.conc_request_id,
1686: process_flag = 3,
1687: lock_flag = 2,
1681: last_update_login = fnd_global.login_id,
1682: program_application_id = fnd_global.prog_appl_id,
1683: program_id = fnd_global.conc_program_id,
1684: program_update_date = sysdate,
1685: request_id = fnd_global.conc_request_id,
1686: process_flag = 3,
1687: lock_flag = 2,
1688: error_code = 'demand_source_delivery',
1689: error_explanation = l_errMsg
1716: fnd_message.set_name('WIP', 'WIP_KB_ILLEGAL_CARD');
1717: l_errMsg := substrb(fnd_message.get, 1, 240);
1718: update mtl_transactions_interface mti
1719: set last_update_date = sysdate,
1720: last_updated_by = fnd_global.user_id,
1721: last_update_login = fnd_global.login_id,
1722: program_application_id = fnd_global.prog_appl_id,
1723: program_id = fnd_global.conc_program_id,
1724: program_update_date = sysdate,
1717: l_errMsg := substrb(fnd_message.get, 1, 240);
1718: update mtl_transactions_interface mti
1719: set last_update_date = sysdate,
1720: last_updated_by = fnd_global.user_id,
1721: last_update_login = fnd_global.login_id,
1722: program_application_id = fnd_global.prog_appl_id,
1723: program_id = fnd_global.conc_program_id,
1724: program_update_date = sysdate,
1725: request_id = fnd_global.conc_request_id,
1718: update mtl_transactions_interface mti
1719: set last_update_date = sysdate,
1720: last_updated_by = fnd_global.user_id,
1721: last_update_login = fnd_global.login_id,
1722: program_application_id = fnd_global.prog_appl_id,
1723: program_id = fnd_global.conc_program_id,
1724: program_update_date = sysdate,
1725: request_id = fnd_global.conc_request_id,
1726: process_flag = 3,
1719: set last_update_date = sysdate,
1720: last_updated_by = fnd_global.user_id,
1721: last_update_login = fnd_global.login_id,
1722: program_application_id = fnd_global.prog_appl_id,
1723: program_id = fnd_global.conc_program_id,
1724: program_update_date = sysdate,
1725: request_id = fnd_global.conc_request_id,
1726: process_flag = 3,
1727: lock_flag = 2,
1721: last_update_login = fnd_global.login_id,
1722: program_application_id = fnd_global.prog_appl_id,
1723: program_id = fnd_global.conc_program_id,
1724: program_update_date = sysdate,
1725: request_id = fnd_global.conc_request_id,
1726: process_flag = 3,
1727: lock_flag = 2,
1728: error_code = 'kanban_card',
1729: error_explanation = l_errMsg
1743: fnd_message.set_name('WIP', 'WIP_KB_CPL_SUB_LOC_MISMATCH');
1744: l_errMsg := substrb(fnd_message.get, 1, 240);
1745: update mtl_transactions_interface mti
1746: set last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.login_id,
1749: program_application_id = fnd_global.prog_appl_id,
1750: program_id = fnd_global.conc_program_id,
1751: program_update_date = sysdate,
1744: l_errMsg := substrb(fnd_message.get, 1, 240);
1745: update mtl_transactions_interface mti
1746: set last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.login_id,
1749: program_application_id = fnd_global.prog_appl_id,
1750: program_id = fnd_global.conc_program_id,
1751: program_update_date = sysdate,
1752: request_id = fnd_global.conc_request_id,
1745: update mtl_transactions_interface mti
1746: set last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.login_id,
1749: program_application_id = fnd_global.prog_appl_id,
1750: program_id = fnd_global.conc_program_id,
1751: program_update_date = sysdate,
1752: request_id = fnd_global.conc_request_id,
1753: process_flag = 3,
1746: set last_update_date = sysdate,
1747: last_updated_by = fnd_global.user_id,
1748: last_update_login = fnd_global.login_id,
1749: program_application_id = fnd_global.prog_appl_id,
1750: program_id = fnd_global.conc_program_id,
1751: program_update_date = sysdate,
1752: request_id = fnd_global.conc_request_id,
1753: process_flag = 3,
1754: lock_flag = 2,
1748: last_update_login = fnd_global.login_id,
1749: program_application_id = fnd_global.prog_appl_id,
1750: program_id = fnd_global.conc_program_id,
1751: program_update_date = sysdate,
1752: request_id = fnd_global.conc_request_id,
1753: process_flag = 3,
1754: lock_flag = 2,
1755: error_code = 'kanban_card',
1756: error_explanation = l_errMsg
1774: fnd_message.set_name('WIP', 'WIP_KB_CPL_STATUS_ILLEGAL');
1775: l_errMsg := substrb(fnd_message.get, 1, 240);
1776: update mtl_transactions_interface mti
1777: set last_update_date = sysdate,
1778: last_updated_by = fnd_global.user_id,
1779: last_update_login = fnd_global.login_id,
1780: program_application_id = fnd_global.prog_appl_id,
1781: program_id = fnd_global.conc_program_id,
1782: program_update_date = sysdate,
1775: l_errMsg := substrb(fnd_message.get, 1, 240);
1776: update mtl_transactions_interface mti
1777: set last_update_date = sysdate,
1778: last_updated_by = fnd_global.user_id,
1779: last_update_login = fnd_global.login_id,
1780: program_application_id = fnd_global.prog_appl_id,
1781: program_id = fnd_global.conc_program_id,
1782: program_update_date = sysdate,
1783: request_id = fnd_global.conc_request_id,
1776: update mtl_transactions_interface mti
1777: set last_update_date = sysdate,
1778: last_updated_by = fnd_global.user_id,
1779: last_update_login = fnd_global.login_id,
1780: program_application_id = fnd_global.prog_appl_id,
1781: program_id = fnd_global.conc_program_id,
1782: program_update_date = sysdate,
1783: request_id = fnd_global.conc_request_id,
1784: process_flag = 3,
1777: set last_update_date = sysdate,
1778: last_updated_by = fnd_global.user_id,
1779: last_update_login = fnd_global.login_id,
1780: program_application_id = fnd_global.prog_appl_id,
1781: program_id = fnd_global.conc_program_id,
1782: program_update_date = sysdate,
1783: request_id = fnd_global.conc_request_id,
1784: process_flag = 3,
1785: lock_flag = 2,
1779: last_update_login = fnd_global.login_id,
1780: program_application_id = fnd_global.prog_appl_id,
1781: program_id = fnd_global.conc_program_id,
1782: program_update_date = sysdate,
1783: request_id = fnd_global.conc_request_id,
1784: process_flag = 3,
1785: lock_flag = 2,
1786: error_code = 'kanban_card',
1787: error_explanation = l_errMsg
1809: fnd_message.set_name('WIP', 'WIP_INVALID_NEG_REQ_FLAG');
1810: l_errMsg := substrb(fnd_message.get, 1, 240);
1811: update mtl_transactions_interface mti
1812: set last_update_date = sysdate,
1813: last_updated_by = fnd_global.user_id,
1814: last_update_login = fnd_global.login_id,
1815: program_application_id = fnd_global.prog_appl_id,
1816: program_id = fnd_global.conc_program_id,
1817: program_update_date = sysdate,
1810: l_errMsg := substrb(fnd_message.get, 1, 240);
1811: update mtl_transactions_interface mti
1812: set last_update_date = sysdate,
1813: last_updated_by = fnd_global.user_id,
1814: last_update_login = fnd_global.login_id,
1815: program_application_id = fnd_global.prog_appl_id,
1816: program_id = fnd_global.conc_program_id,
1817: program_update_date = sysdate,
1818: request_id = fnd_global.conc_request_id,
1811: update mtl_transactions_interface mti
1812: set last_update_date = sysdate,
1813: last_updated_by = fnd_global.user_id,
1814: last_update_login = fnd_global.login_id,
1815: program_application_id = fnd_global.prog_appl_id,
1816: program_id = fnd_global.conc_program_id,
1817: program_update_date = sysdate,
1818: request_id = fnd_global.conc_request_id,
1819: process_flag = 3,
1812: set last_update_date = sysdate,
1813: last_updated_by = fnd_global.user_id,
1814: last_update_login = fnd_global.login_id,
1815: program_application_id = fnd_global.prog_appl_id,
1816: program_id = fnd_global.conc_program_id,
1817: program_update_date = sysdate,
1818: request_id = fnd_global.conc_request_id,
1819: process_flag = 3,
1820: lock_flag = 2,
1814: last_update_login = fnd_global.login_id,
1815: program_application_id = fnd_global.prog_appl_id,
1816: program_id = fnd_global.conc_program_id,
1817: program_update_date = sysdate,
1818: request_id = fnd_global.conc_request_id,
1819: process_flag = 3,
1820: lock_flag = 2,
1821: error_code = 'negative_req_flag',
1822: error_explanation = l_errMsg
1838: fnd_message.set_name('WIP', 'WIP_NO_SERIALIZED_JOB_ALLOW');
1839: l_errMsg := substrb(fnd_message.get, 1, 240);
1840: update mtl_transactions_interface mti
1841: set last_update_date = sysdate,
1842: last_updated_by = fnd_global.user_id,
1843: last_update_login = fnd_global.login_id,
1844: program_application_id = fnd_global.prog_appl_id,
1845: program_id = fnd_global.conc_program_id,
1846: program_update_date = sysdate,
1839: l_errMsg := substrb(fnd_message.get, 1, 240);
1840: update mtl_transactions_interface mti
1841: set last_update_date = sysdate,
1842: last_updated_by = fnd_global.user_id,
1843: last_update_login = fnd_global.login_id,
1844: program_application_id = fnd_global.prog_appl_id,
1845: program_id = fnd_global.conc_program_id,
1846: program_update_date = sysdate,
1847: request_id = fnd_global.conc_request_id,
1840: update mtl_transactions_interface mti
1841: set last_update_date = sysdate,
1842: last_updated_by = fnd_global.user_id,
1843: last_update_login = fnd_global.login_id,
1844: program_application_id = fnd_global.prog_appl_id,
1845: program_id = fnd_global.conc_program_id,
1846: program_update_date = sysdate,
1847: request_id = fnd_global.conc_request_id,
1848: process_flag = 3,
1841: set last_update_date = sysdate,
1842: last_updated_by = fnd_global.user_id,
1843: last_update_login = fnd_global.login_id,
1844: program_application_id = fnd_global.prog_appl_id,
1845: program_id = fnd_global.conc_program_id,
1846: program_update_date = sysdate,
1847: request_id = fnd_global.conc_request_id,
1848: process_flag = 3,
1849: lock_flag = 2,
1843: last_update_login = fnd_global.login_id,
1844: program_application_id = fnd_global.prog_appl_id,
1845: program_id = fnd_global.conc_program_id,
1846: program_update_date = sysdate,
1847: request_id = fnd_global.conc_request_id,
1848: process_flag = 3,
1849: lock_flag = 2,
1850: error_code = 'transaction_source_id',
1851: error_explanation = l_errMsg
1868: --for assy completions and returns, project/task must match
1869: --source project/task
1870: update mtl_transactions_interface mti
1871: set last_update_date = sysdate,
1872: last_updated_by = fnd_global.user_id,
1873: last_update_login = fnd_global.login_id,
1874: program_application_id = fnd_global.prog_appl_id,
1875: program_id = fnd_global.conc_program_id,
1876: program_update_date = sysdate,
1869: --source project/task
1870: update mtl_transactions_interface mti
1871: set last_update_date = sysdate,
1872: last_updated_by = fnd_global.user_id,
1873: last_update_login = fnd_global.login_id,
1874: program_application_id = fnd_global.prog_appl_id,
1875: program_id = fnd_global.conc_program_id,
1876: program_update_date = sysdate,
1877: request_id = fnd_global.conc_request_id,
1870: update mtl_transactions_interface mti
1871: set last_update_date = sysdate,
1872: last_updated_by = fnd_global.user_id,
1873: last_update_login = fnd_global.login_id,
1874: program_application_id = fnd_global.prog_appl_id,
1875: program_id = fnd_global.conc_program_id,
1876: program_update_date = sysdate,
1877: request_id = fnd_global.conc_request_id,
1878: project_id = source_project_id,
1871: set last_update_date = sysdate,
1872: last_updated_by = fnd_global.user_id,
1873: last_update_login = fnd_global.login_id,
1874: program_application_id = fnd_global.prog_appl_id,
1875: program_id = fnd_global.conc_program_id,
1876: program_update_date = sysdate,
1877: request_id = fnd_global.conc_request_id,
1878: project_id = source_project_id,
1879: task_id = source_task_id
1873: last_update_login = fnd_global.login_id,
1874: program_application_id = fnd_global.prog_appl_id,
1875: program_id = fnd_global.conc_program_id,
1876: program_update_date = sysdate,
1877: request_id = fnd_global.conc_request_id,
1878: project_id = source_project_id,
1879: task_id = source_task_id
1880: where transaction_header_id = p_txnHeaderID
1881: and process_flag = 1
1950: x_returnStatus => l_returnStatus); --discard logging return status
1951: end if;
1952: update mtl_transactions_interface
1953: set last_update_date = sysdate,
1954: last_updated_by = fnd_global.user_id,
1955: last_update_login = fnd_global.login_id,
1956: program_application_id = fnd_global.prog_appl_id,
1957: program_id = fnd_global.conc_program_id,
1958: program_update_date = sysdate,
1951: end if;
1952: update mtl_transactions_interface
1953: set last_update_date = sysdate,
1954: last_updated_by = fnd_global.user_id,
1955: last_update_login = fnd_global.login_id,
1956: program_application_id = fnd_global.prog_appl_id,
1957: program_id = fnd_global.conc_program_id,
1958: program_update_date = sysdate,
1959: request_id = fnd_global.conc_request_id,
1952: update mtl_transactions_interface
1953: set last_update_date = sysdate,
1954: last_updated_by = fnd_global.user_id,
1955: last_update_login = fnd_global.login_id,
1956: program_application_id = fnd_global.prog_appl_id,
1957: program_id = fnd_global.conc_program_id,
1958: program_update_date = sysdate,
1959: request_id = fnd_global.conc_request_id,
1960: process_flag = 3,
1953: set last_update_date = sysdate,
1954: last_updated_by = fnd_global.user_id,
1955: last_update_login = fnd_global.login_id,
1956: program_application_id = fnd_global.prog_appl_id,
1957: program_id = fnd_global.conc_program_id,
1958: program_update_date = sysdate,
1959: request_id = fnd_global.conc_request_id,
1960: process_flag = 3,
1961: lock_flag = 2
1955: last_update_login = fnd_global.login_id,
1956: program_application_id = fnd_global.prog_appl_id,
1957: program_id = fnd_global.conc_program_id,
1958: program_update_date = sysdate,
1959: request_id = fnd_global.conc_request_id,
1960: process_flag = 3,
1961: lock_flag = 2
1962: where transaction_header_id = p_txnHeaderID;
1963: end postInvWIPValidation;
1973:
1974: begin
1975: update mtl_transactions_interface
1976: set last_update_date = sysdate,
1977: last_updated_by = fnd_global.user_id,
1978: last_update_login = fnd_global.login_id,
1979: program_application_id = fnd_global.prog_appl_id,
1980: program_id = fnd_global.conc_program_id,
1981: program_update_date = sysdate,
1974: begin
1975: update mtl_transactions_interface
1976: set last_update_date = sysdate,
1977: last_updated_by = fnd_global.user_id,
1978: last_update_login = fnd_global.login_id,
1979: program_application_id = fnd_global.prog_appl_id,
1980: program_id = fnd_global.conc_program_id,
1981: program_update_date = sysdate,
1982: request_id = fnd_global.conc_request_id,
1975: update mtl_transactions_interface
1976: set last_update_date = sysdate,
1977: last_updated_by = fnd_global.user_id,
1978: last_update_login = fnd_global.login_id,
1979: program_application_id = fnd_global.prog_appl_id,
1980: program_id = fnd_global.conc_program_id,
1981: program_update_date = sysdate,
1982: request_id = fnd_global.conc_request_id,
1983: process_flag = 3,
1976: set last_update_date = sysdate,
1977: last_updated_by = fnd_global.user_id,
1978: last_update_login = fnd_global.login_id,
1979: program_application_id = fnd_global.prog_appl_id,
1980: program_id = fnd_global.conc_program_id,
1981: program_update_date = sysdate,
1982: request_id = fnd_global.conc_request_id,
1983: process_flag = 3,
1984: lock_flag = 2,
1978: last_update_login = fnd_global.login_id,
1979: program_application_id = fnd_global.prog_appl_id,
1980: program_id = fnd_global.conc_program_id,
1981: program_update_date = sysdate,
1982: request_id = fnd_global.conc_request_id,
1983: process_flag = 3,
1984: lock_flag = 2,
1985: error_code = substrb(p_errCode, 1, 240),
1986: error_explanation = substrb(p_msgData, 1, 240)
2063: -- we need that for the logic that follows. Even though inv validation does
2064: -- the deriviation, we still needs to do that since we call inv afterwards.
2065: update mtl_transactions_interface mti
2066: set last_update_date = sysdate,
2067: last_updated_by = fnd_global.user_id,
2068: last_update_login = fnd_global.login_id,
2069: program_application_id = fnd_global.prog_appl_id,
2070: program_id = fnd_global.conc_program_id,
2071: program_update_date = sysdate,
2064: -- the deriviation, we still needs to do that since we call inv afterwards.
2065: update mtl_transactions_interface mti
2066: set last_update_date = sysdate,
2067: last_updated_by = fnd_global.user_id,
2068: last_update_login = fnd_global.login_id,
2069: program_application_id = fnd_global.prog_appl_id,
2070: program_id = fnd_global.conc_program_id,
2071: program_update_date = sysdate,
2072: request_id = fnd_global.conc_request_id,
2065: update mtl_transactions_interface mti
2066: set last_update_date = sysdate,
2067: last_updated_by = fnd_global.user_id,
2068: last_update_login = fnd_global.login_id,
2069: program_application_id = fnd_global.prog_appl_id,
2070: program_id = fnd_global.conc_program_id,
2071: program_update_date = sysdate,
2072: request_id = fnd_global.conc_request_id,
2073: transaction_action_id = (select mtt.transaction_action_id
2066: set last_update_date = sysdate,
2067: last_updated_by = fnd_global.user_id,
2068: last_update_login = fnd_global.login_id,
2069: program_application_id = fnd_global.prog_appl_id,
2070: program_id = fnd_global.conc_program_id,
2071: program_update_date = sysdate,
2072: request_id = fnd_global.conc_request_id,
2073: transaction_action_id = (select mtt.transaction_action_id
2074: from mtl_transaction_types mtt
2068: last_update_login = fnd_global.login_id,
2069: program_application_id = fnd_global.prog_appl_id,
2070: program_id = fnd_global.conc_program_id,
2071: program_update_date = sysdate,
2072: request_id = fnd_global.conc_request_id,
2073: transaction_action_id = (select mtt.transaction_action_id
2074: from mtl_transaction_types mtt
2075: where mtt.transaction_type_id =
2076: mti.transaction_type_id),
2114: fnd_message.set_name('INV', 'INV_INT_ORGEXP');
2115: l_errMsg := substrb(fnd_message.get, 1, 240);
2116: update mtl_transactions_interface mti
2117: set last_update_date = sysdate,
2118: last_updated_by = fnd_global.user_id,
2119: last_update_login = fnd_global.login_id,
2120: program_application_id = fnd_global.prog_appl_id,
2121: program_id = fnd_global.conc_program_id,
2122: program_update_date = sysdate,
2115: l_errMsg := substrb(fnd_message.get, 1, 240);
2116: update mtl_transactions_interface mti
2117: set last_update_date = sysdate,
2118: last_updated_by = fnd_global.user_id,
2119: last_update_login = fnd_global.login_id,
2120: program_application_id = fnd_global.prog_appl_id,
2121: program_id = fnd_global.conc_program_id,
2122: program_update_date = sysdate,
2123: request_id = fnd_global.conc_request_id,
2116: update mtl_transactions_interface mti
2117: set last_update_date = sysdate,
2118: last_updated_by = fnd_global.user_id,
2119: last_update_login = fnd_global.login_id,
2120: program_application_id = fnd_global.prog_appl_id,
2121: program_id = fnd_global.conc_program_id,
2122: program_update_date = sysdate,
2123: request_id = fnd_global.conc_request_id,
2124: process_flag = 3,
2117: set last_update_date = sysdate,
2118: last_updated_by = fnd_global.user_id,
2119: last_update_login = fnd_global.login_id,
2120: program_application_id = fnd_global.prog_appl_id,
2121: program_id = fnd_global.conc_program_id,
2122: program_update_date = sysdate,
2123: request_id = fnd_global.conc_request_id,
2124: process_flag = 3,
2125: lock_flag = 2,
2119: last_update_login = fnd_global.login_id,
2120: program_application_id = fnd_global.prog_appl_id,
2121: program_id = fnd_global.conc_program_id,
2122: program_update_date = sysdate,
2123: request_id = fnd_global.conc_request_id,
2124: process_flag = 3,
2125: lock_flag = 2,
2126: error_code = l_errCode,
2127: error_explanation = l_errMsg
2138: fnd_message.set_name('WIP', 'WIP_INVALID_FLOW_SCHED_FLAG');
2139: l_errMsg := substrb(fnd_message.get, 1, 240);
2140: update mtl_transactions_interface mti
2141: set last_update_date = sysdate,
2142: last_updated_by = fnd_global.user_id,
2143: last_update_login = fnd_global.login_id,
2144: program_application_id = fnd_global.prog_appl_id,
2145: program_id = fnd_global.conc_program_id,
2146: program_update_date = sysdate,
2139: l_errMsg := substrb(fnd_message.get, 1, 240);
2140: update mtl_transactions_interface mti
2141: set last_update_date = sysdate,
2142: last_updated_by = fnd_global.user_id,
2143: last_update_login = fnd_global.login_id,
2144: program_application_id = fnd_global.prog_appl_id,
2145: program_id = fnd_global.conc_program_id,
2146: program_update_date = sysdate,
2147: request_id = fnd_global.conc_request_id,
2140: update mtl_transactions_interface mti
2141: set last_update_date = sysdate,
2142: last_updated_by = fnd_global.user_id,
2143: last_update_login = fnd_global.login_id,
2144: program_application_id = fnd_global.prog_appl_id,
2145: program_id = fnd_global.conc_program_id,
2146: program_update_date = sysdate,
2147: request_id = fnd_global.conc_request_id,
2148: process_flag = 3,
2141: set last_update_date = sysdate,
2142: last_updated_by = fnd_global.user_id,
2143: last_update_login = fnd_global.login_id,
2144: program_application_id = fnd_global.prog_appl_id,
2145: program_id = fnd_global.conc_program_id,
2146: program_update_date = sysdate,
2147: request_id = fnd_global.conc_request_id,
2148: process_flag = 3,
2149: lock_flag = 2,
2143: last_update_login = fnd_global.login_id,
2144: program_application_id = fnd_global.prog_appl_id,
2145: program_id = fnd_global.conc_program_id,
2146: program_update_date = sysdate,
2147: request_id = fnd_global.conc_request_id,
2148: process_flag = 3,
2149: lock_flag = 2,
2150: error_code = 'Invalid Scheduled Flag',
2151: error_explanation = l_errMsg
2165: fnd_message.set_token('ENTITY', 'transaction_source_name');
2166: l_errMsg := substrb(fnd_message.get, 1, 240);
2167: update mtl_transactions_interface mti
2168: set last_update_date = sysdate,
2169: last_updated_by = fnd_global.user_id,
2170: last_update_login = fnd_global.login_id,
2171: program_application_id = fnd_global.prog_appl_id,
2172: program_id = fnd_global.conc_program_id,
2173: program_update_date = sysdate,
2166: l_errMsg := substrb(fnd_message.get, 1, 240);
2167: update mtl_transactions_interface mti
2168: set last_update_date = sysdate,
2169: last_updated_by = fnd_global.user_id,
2170: last_update_login = fnd_global.login_id,
2171: program_application_id = fnd_global.prog_appl_id,
2172: program_id = fnd_global.conc_program_id,
2173: program_update_date = sysdate,
2174: request_id = fnd_global.conc_request_id,
2167: update mtl_transactions_interface mti
2168: set last_update_date = sysdate,
2169: last_updated_by = fnd_global.user_id,
2170: last_update_login = fnd_global.login_id,
2171: program_application_id = fnd_global.prog_appl_id,
2172: program_id = fnd_global.conc_program_id,
2173: program_update_date = sysdate,
2174: request_id = fnd_global.conc_request_id,
2175: process_flag = 3,
2168: set last_update_date = sysdate,
2169: last_updated_by = fnd_global.user_id,
2170: last_update_login = fnd_global.login_id,
2171: program_application_id = fnd_global.prog_appl_id,
2172: program_id = fnd_global.conc_program_id,
2173: program_update_date = sysdate,
2174: request_id = fnd_global.conc_request_id,
2175: process_flag = 3,
2176: lock_flag = 2,
2170: last_update_login = fnd_global.login_id,
2171: program_application_id = fnd_global.prog_appl_id,
2172: program_id = fnd_global.conc_program_id,
2173: program_update_date = sysdate,
2174: request_id = fnd_global.conc_request_id,
2175: process_flag = 3,
2176: lock_flag = 2,
2177: error_code = 'transaction_source_name',
2178: error_explanation = l_errMsg
2189:
2190: -- derive transaction source id from transaction source name
2191: update mtl_transactions_interface mti
2192: set last_update_date = sysdate,
2193: last_updated_by = fnd_global.user_id,
2194: last_update_login = fnd_global.login_id,
2195: program_application_id = fnd_global.prog_appl_id,
2196: program_id = fnd_global.conc_program_id,
2197: program_update_date = sysdate,
2190: -- derive transaction source id from transaction source name
2191: update mtl_transactions_interface mti
2192: set last_update_date = sysdate,
2193: last_updated_by = fnd_global.user_id,
2194: last_update_login = fnd_global.login_id,
2195: program_application_id = fnd_global.prog_appl_id,
2196: program_id = fnd_global.conc_program_id,
2197: program_update_date = sysdate,
2198: request_id = fnd_global.conc_request_id,
2191: update mtl_transactions_interface mti
2192: set last_update_date = sysdate,
2193: last_updated_by = fnd_global.user_id,
2194: last_update_login = fnd_global.login_id,
2195: program_application_id = fnd_global.prog_appl_id,
2196: program_id = fnd_global.conc_program_id,
2197: program_update_date = sysdate,
2198: request_id = fnd_global.conc_request_id,
2199: transaction_source_id = (select we.wip_entity_id
2192: set last_update_date = sysdate,
2193: last_updated_by = fnd_global.user_id,
2194: last_update_login = fnd_global.login_id,
2195: program_application_id = fnd_global.prog_appl_id,
2196: program_id = fnd_global.conc_program_id,
2197: program_update_date = sysdate,
2198: request_id = fnd_global.conc_request_id,
2199: transaction_source_id = (select we.wip_entity_id
2200: from wip_entities we
2194: last_update_login = fnd_global.login_id,
2195: program_application_id = fnd_global.prog_appl_id,
2196: program_id = fnd_global.conc_program_id,
2197: program_update_date = sysdate,
2198: request_id = fnd_global.conc_request_id,
2199: transaction_source_id = (select we.wip_entity_id
2200: from wip_entities we
2201: where we.organization_id = mti.organization_id
2202: and we.wip_entity_name = mti.transaction_source_name)
2213: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');
2214: l_errMsg := substrb(fnd_message.get, 1, 240);
2215: update mtl_transactions_interface mti
2216: set last_update_date = sysdate,
2217: last_updated_by = fnd_global.user_id,
2218: last_update_login = fnd_global.login_id,
2219: program_application_id = fnd_global.prog_appl_id,
2220: program_id = fnd_global.conc_program_id,
2221: program_update_date = sysdate,
2214: l_errMsg := substrb(fnd_message.get, 1, 240);
2215: update mtl_transactions_interface mti
2216: set last_update_date = sysdate,
2217: last_updated_by = fnd_global.user_id,
2218: last_update_login = fnd_global.login_id,
2219: program_application_id = fnd_global.prog_appl_id,
2220: program_id = fnd_global.conc_program_id,
2221: program_update_date = sysdate,
2222: request_id = fnd_global.conc_request_id,
2215: update mtl_transactions_interface mti
2216: set last_update_date = sysdate,
2217: last_updated_by = fnd_global.user_id,
2218: last_update_login = fnd_global.login_id,
2219: program_application_id = fnd_global.prog_appl_id,
2220: program_id = fnd_global.conc_program_id,
2221: program_update_date = sysdate,
2222: request_id = fnd_global.conc_request_id,
2223: process_flag = 3,
2216: set last_update_date = sysdate,
2217: last_updated_by = fnd_global.user_id,
2218: last_update_login = fnd_global.login_id,
2219: program_application_id = fnd_global.prog_appl_id,
2220: program_id = fnd_global.conc_program_id,
2221: program_update_date = sysdate,
2222: request_id = fnd_global.conc_request_id,
2223: process_flag = 3,
2224: lock_flag = 2,
2218: last_update_login = fnd_global.login_id,
2219: program_application_id = fnd_global.prog_appl_id,
2220: program_id = fnd_global.conc_program_id,
2221: program_update_date = sysdate,
2222: request_id = fnd_global.conc_request_id,
2223: process_flag = 3,
2224: lock_flag = 2,
2225: error_code = l_errCode,
2226: error_explanation = l_errMsg
2237: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');
2238: l_errMsg := substrb(fnd_message.get, 1, 240);
2239: update mtl_transactions_interface mti
2240: set last_update_date = sysdate,
2241: last_updated_by = fnd_global.user_id,
2242: last_update_login = fnd_global.login_id,
2243: program_application_id = fnd_global.prog_appl_id,
2244: program_id = fnd_global.conc_program_id,
2245: program_update_date = sysdate,
2238: l_errMsg := substrb(fnd_message.get, 1, 240);
2239: update mtl_transactions_interface mti
2240: set last_update_date = sysdate,
2241: last_updated_by = fnd_global.user_id,
2242: last_update_login = fnd_global.login_id,
2243: program_application_id = fnd_global.prog_appl_id,
2244: program_id = fnd_global.conc_program_id,
2245: program_update_date = sysdate,
2246: request_id = fnd_global.conc_request_id,
2239: update mtl_transactions_interface mti
2240: set last_update_date = sysdate,
2241: last_updated_by = fnd_global.user_id,
2242: last_update_login = fnd_global.login_id,
2243: program_application_id = fnd_global.prog_appl_id,
2244: program_id = fnd_global.conc_program_id,
2245: program_update_date = sysdate,
2246: request_id = fnd_global.conc_request_id,
2247: process_flag = 3,
2240: set last_update_date = sysdate,
2241: last_updated_by = fnd_global.user_id,
2242: last_update_login = fnd_global.login_id,
2243: program_application_id = fnd_global.prog_appl_id,
2244: program_id = fnd_global.conc_program_id,
2245: program_update_date = sysdate,
2246: request_id = fnd_global.conc_request_id,
2247: process_flag = 3,
2248: lock_flag = 2,
2242: last_update_login = fnd_global.login_id,
2243: program_application_id = fnd_global.prog_appl_id,
2244: program_id = fnd_global.conc_program_id,
2245: program_update_date = sysdate,
2246: request_id = fnd_global.conc_request_id,
2247: process_flag = 3,
2248: lock_flag = 2,
2249: error_code = l_errCode,
2250: error_explanation = l_errMsg
2275: l_errMsg := substrb(fnd_message.get, 1, 240);
2276:
2277: update mtl_transactions_interface mti
2278: set last_update_date = sysdate,
2279: last_updated_by = fnd_global.user_id,
2280: last_update_login = fnd_global.login_id,
2281: program_application_id = fnd_global.prog_appl_id,
2282: program_id = fnd_global.conc_program_id,
2283: program_update_date = sysdate,
2276:
2277: update mtl_transactions_interface mti
2278: set last_update_date = sysdate,
2279: last_updated_by = fnd_global.user_id,
2280: last_update_login = fnd_global.login_id,
2281: program_application_id = fnd_global.prog_appl_id,
2282: program_id = fnd_global.conc_program_id,
2283: program_update_date = sysdate,
2284: request_id = fnd_global.conc_request_id,
2277: update mtl_transactions_interface mti
2278: set last_update_date = sysdate,
2279: last_updated_by = fnd_global.user_id,
2280: last_update_login = fnd_global.login_id,
2281: program_application_id = fnd_global.prog_appl_id,
2282: program_id = fnd_global.conc_program_id,
2283: program_update_date = sysdate,
2284: request_id = fnd_global.conc_request_id,
2285: process_flag = 3,
2278: set last_update_date = sysdate,
2279: last_updated_by = fnd_global.user_id,
2280: last_update_login = fnd_global.login_id,
2281: program_application_id = fnd_global.prog_appl_id,
2282: program_id = fnd_global.conc_program_id,
2283: program_update_date = sysdate,
2284: request_id = fnd_global.conc_request_id,
2285: process_flag = 3,
2286: lock_flag = 2,
2280: last_update_login = fnd_global.login_id,
2281: program_application_id = fnd_global.prog_appl_id,
2282: program_id = fnd_global.conc_program_id,
2283: program_update_date = sysdate,
2284: request_id = fnd_global.conc_request_id,
2285: process_flag = 3,
2286: lock_flag = 2,
2287: error_code = l_errCode,
2288: error_explanation = l_errMsg
2309: l_errMsg := substrb(fnd_message.get, 1, 240);
2310:
2311: update mtl_transactions_interface mti
2312: set last_update_date = sysdate,
2313: last_updated_by = fnd_global.user_id,
2314: last_update_login = fnd_global.login_id,
2315: program_application_id = fnd_global.prog_appl_id,
2316: program_id = fnd_global.conc_program_id,
2317: program_update_date = sysdate,
2310:
2311: update mtl_transactions_interface mti
2312: set last_update_date = sysdate,
2313: last_updated_by = fnd_global.user_id,
2314: last_update_login = fnd_global.login_id,
2315: program_application_id = fnd_global.prog_appl_id,
2316: program_id = fnd_global.conc_program_id,
2317: program_update_date = sysdate,
2318: request_id = fnd_global.conc_request_id,
2311: update mtl_transactions_interface mti
2312: set last_update_date = sysdate,
2313: last_updated_by = fnd_global.user_id,
2314: last_update_login = fnd_global.login_id,
2315: program_application_id = fnd_global.prog_appl_id,
2316: program_id = fnd_global.conc_program_id,
2317: program_update_date = sysdate,
2318: request_id = fnd_global.conc_request_id,
2319: process_flag = 3,
2312: set last_update_date = sysdate,
2313: last_updated_by = fnd_global.user_id,
2314: last_update_login = fnd_global.login_id,
2315: program_application_id = fnd_global.prog_appl_id,
2316: program_id = fnd_global.conc_program_id,
2317: program_update_date = sysdate,
2318: request_id = fnd_global.conc_request_id,
2319: process_flag = 3,
2320: lock_flag = 2,
2314: last_update_login = fnd_global.login_id,
2315: program_application_id = fnd_global.prog_appl_id,
2316: program_id = fnd_global.conc_program_id,
2317: program_update_date = sysdate,
2318: request_id = fnd_global.conc_request_id,
2319: process_flag = 3,
2320: lock_flag = 2,
2321: error_code = l_errCode,
2322: error_explanation = l_errMsg
2334:
2335: -- derive inventory item id if transaction source id is provided
2336: update mtl_transactions_interface mti
2337: set last_update_date = sysdate,
2338: last_updated_by = fnd_global.user_id,
2339: last_update_login = fnd_global.login_id,
2340: program_application_id = fnd_global.prog_appl_id,
2341: program_id = fnd_global.conc_program_id,
2342: program_update_date = sysdate,
2335: -- derive inventory item id if transaction source id is provided
2336: update mtl_transactions_interface mti
2337: set last_update_date = sysdate,
2338: last_updated_by = fnd_global.user_id,
2339: last_update_login = fnd_global.login_id,
2340: program_application_id = fnd_global.prog_appl_id,
2341: program_id = fnd_global.conc_program_id,
2342: program_update_date = sysdate,
2343: request_id = fnd_global.conc_request_id,
2336: update mtl_transactions_interface mti
2337: set last_update_date = sysdate,
2338: last_updated_by = fnd_global.user_id,
2339: last_update_login = fnd_global.login_id,
2340: program_application_id = fnd_global.prog_appl_id,
2341: program_id = fnd_global.conc_program_id,
2342: program_update_date = sysdate,
2343: request_id = fnd_global.conc_request_id,
2344: inventory_item_id = (select primary_item_id
2337: set last_update_date = sysdate,
2338: last_updated_by = fnd_global.user_id,
2339: last_update_login = fnd_global.login_id,
2340: program_application_id = fnd_global.prog_appl_id,
2341: program_id = fnd_global.conc_program_id,
2342: program_update_date = sysdate,
2343: request_id = fnd_global.conc_request_id,
2344: inventory_item_id = (select primary_item_id
2345: from wip_entities we
2339: last_update_login = fnd_global.login_id,
2340: program_application_id = fnd_global.prog_appl_id,
2341: program_id = fnd_global.conc_program_id,
2342: program_update_date = sysdate,
2343: request_id = fnd_global.conc_request_id,
2344: inventory_item_id = (select primary_item_id
2345: from wip_entities we
2346: where we.organization_id = mti.organization_id
2347: and we.wip_entity_id = mti.transaction_source_id)
2430: forall i in 1..l_orgIDTbl.count
2431: /* FP bug 5708701 (base bug 5046732) - No need update locator id on MTI. It will be done in inventory code.*/
2432: update mtl_transactions_interface mti
2433: set last_update_date = sysdate,
2434: last_updated_by = fnd_global.user_id,
2435: last_update_login = fnd_global.login_id,
2436: program_application_id = fnd_global.prog_appl_id,
2437: program_id = fnd_global.conc_program_id,
2438: program_update_date = sysdate,
2431: /* FP bug 5708701 (base bug 5046732) - No need update locator id on MTI. It will be done in inventory code.*/
2432: update mtl_transactions_interface mti
2433: set last_update_date = sysdate,
2434: last_updated_by = fnd_global.user_id,
2435: last_update_login = fnd_global.login_id,
2436: program_application_id = fnd_global.prog_appl_id,
2437: program_id = fnd_global.conc_program_id,
2438: program_update_date = sysdate,
2439: request_id = fnd_global.conc_request_id,
2432: update mtl_transactions_interface mti
2433: set last_update_date = sysdate,
2434: last_updated_by = fnd_global.user_id,
2435: last_update_login = fnd_global.login_id,
2436: program_application_id = fnd_global.prog_appl_id,
2437: program_id = fnd_global.conc_program_id,
2438: program_update_date = sysdate,
2439: request_id = fnd_global.conc_request_id,
2440: inventory_item_id = l_itemIDTbl(i)
2433: set last_update_date = sysdate,
2434: last_updated_by = fnd_global.user_id,
2435: last_update_login = fnd_global.login_id,
2436: program_application_id = fnd_global.prog_appl_id,
2437: program_id = fnd_global.conc_program_id,
2438: program_update_date = sysdate,
2439: request_id = fnd_global.conc_request_id,
2440: inventory_item_id = l_itemIDTbl(i)
2441: --locator_id = l_locIdTbl(i)
2435: last_update_login = fnd_global.login_id,
2436: program_application_id = fnd_global.prog_appl_id,
2437: program_id = fnd_global.conc_program_id,
2438: program_update_date = sysdate,
2439: request_id = fnd_global.conc_request_id,
2440: inventory_item_id = l_itemIDTbl(i)
2441: --locator_id = l_locIdTbl(i)
2442: where rowid = chartorowid(l_rowidTbl(i));
2443:
2444: /* FP bug 5708701 (base bug 5046732) No need update project id/task id on MTI. It will be done in inventory code.
2445: --update the project/task based on the derived locator
2446: update mtl_transactions_interface mti
2447: set last_update_date = sysdate,
2448: last_updated_by = fnd_global.user_id,
2449: last_update_login = fnd_global.login_id,
2450: program_application_id = fnd_global.prog_appl_id,
2451: program_id = fnd_global.conc_program_id,
2452: program_update_date = sysdate,
2445: --update the project/task based on the derived locator
2446: update mtl_transactions_interface mti
2447: set last_update_date = sysdate,
2448: last_updated_by = fnd_global.user_id,
2449: last_update_login = fnd_global.login_id,
2450: program_application_id = fnd_global.prog_appl_id,
2451: program_id = fnd_global.conc_program_id,
2452: program_update_date = sysdate,
2453: request_id = fnd_global.conc_request_id,
2446: update mtl_transactions_interface mti
2447: set last_update_date = sysdate,
2448: last_updated_by = fnd_global.user_id,
2449: last_update_login = fnd_global.login_id,
2450: program_application_id = fnd_global.prog_appl_id,
2451: program_id = fnd_global.conc_program_id,
2452: program_update_date = sysdate,
2453: request_id = fnd_global.conc_request_id,
2454: (project_id, task_id) = (select project_id, task_id
2447: set last_update_date = sysdate,
2448: last_updated_by = fnd_global.user_id,
2449: last_update_login = fnd_global.login_id,
2450: program_application_id = fnd_global.prog_appl_id,
2451: program_id = fnd_global.conc_program_id,
2452: program_update_date = sysdate,
2453: request_id = fnd_global.conc_request_id,
2454: (project_id, task_id) = (select project_id, task_id
2455: from mtl_item_locations mil
2449: last_update_login = fnd_global.login_id,
2450: program_application_id = fnd_global.prog_appl_id,
2451: program_id = fnd_global.conc_program_id,
2452: program_update_date = sysdate,
2453: request_id = fnd_global.conc_request_id,
2454: (project_id, task_id) = (select project_id, task_id
2455: from mtl_item_locations mil
2456: where inventory_location_id = mti.locator_id
2457: and organization_id = mti.organization_id)
2468: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2469: l_errMsg := substrb(fnd_message.get, 1, 240);
2470: update mtl_transactions_interface mti
2471: set last_update_date = sysdate,
2472: last_updated_by = fnd_global.user_id,
2473: last_update_login = fnd_global.login_id,
2474: program_application_id = fnd_global.prog_appl_id,
2475: program_id = fnd_global.conc_program_id,
2476: program_update_date = sysdate,
2469: l_errMsg := substrb(fnd_message.get, 1, 240);
2470: update mtl_transactions_interface mti
2471: set last_update_date = sysdate,
2472: last_updated_by = fnd_global.user_id,
2473: last_update_login = fnd_global.login_id,
2474: program_application_id = fnd_global.prog_appl_id,
2475: program_id = fnd_global.conc_program_id,
2476: program_update_date = sysdate,
2477: request_id = fnd_global.conc_request_id,
2470: update mtl_transactions_interface mti
2471: set last_update_date = sysdate,
2472: last_updated_by = fnd_global.user_id,
2473: last_update_login = fnd_global.login_id,
2474: program_application_id = fnd_global.prog_appl_id,
2475: program_id = fnd_global.conc_program_id,
2476: program_update_date = sysdate,
2477: request_id = fnd_global.conc_request_id,
2478: process_flag = 3,
2471: set last_update_date = sysdate,
2472: last_updated_by = fnd_global.user_id,
2473: last_update_login = fnd_global.login_id,
2474: program_application_id = fnd_global.prog_appl_id,
2475: program_id = fnd_global.conc_program_id,
2476: program_update_date = sysdate,
2477: request_id = fnd_global.conc_request_id,
2478: process_flag = 3,
2479: lock_flag = 2,
2473: last_update_login = fnd_global.login_id,
2474: program_application_id = fnd_global.prog_appl_id,
2475: program_id = fnd_global.conc_program_id,
2476: program_update_date = sysdate,
2477: request_id = fnd_global.conc_request_id,
2478: process_flag = 3,
2479: lock_flag = 2,
2480: error_code = l_errCode,
2481: error_explanation = l_errMsg
2491:
2492: -- derive wip_entity_type if transaction source id is provided
2493: update mtl_transactions_interface mti
2494: set last_update_date = sysdate,
2495: last_updated_by = fnd_global.user_id,
2496: last_update_login = fnd_global.login_id,
2497: program_application_id = fnd_global.prog_appl_id,
2498: program_id = fnd_global.conc_program_id,
2499: program_update_date = sysdate,
2492: -- derive wip_entity_type if transaction source id is provided
2493: update mtl_transactions_interface mti
2494: set last_update_date = sysdate,
2495: last_updated_by = fnd_global.user_id,
2496: last_update_login = fnd_global.login_id,
2497: program_application_id = fnd_global.prog_appl_id,
2498: program_id = fnd_global.conc_program_id,
2499: program_update_date = sysdate,
2500: request_id = fnd_global.conc_request_id,
2493: update mtl_transactions_interface mti
2494: set last_update_date = sysdate,
2495: last_updated_by = fnd_global.user_id,
2496: last_update_login = fnd_global.login_id,
2497: program_application_id = fnd_global.prog_appl_id,
2498: program_id = fnd_global.conc_program_id,
2499: program_update_date = sysdate,
2500: request_id = fnd_global.conc_request_id,
2501: wip_entity_type = (select entity_type
2494: set last_update_date = sysdate,
2495: last_updated_by = fnd_global.user_id,
2496: last_update_login = fnd_global.login_id,
2497: program_application_id = fnd_global.prog_appl_id,
2498: program_id = fnd_global.conc_program_id,
2499: program_update_date = sysdate,
2500: request_id = fnd_global.conc_request_id,
2501: wip_entity_type = (select entity_type
2502: from wip_entities we
2496: last_update_login = fnd_global.login_id,
2497: program_application_id = fnd_global.prog_appl_id,
2498: program_id = fnd_global.conc_program_id,
2499: program_update_date = sysdate,
2500: request_id = fnd_global.conc_request_id,
2501: wip_entity_type = (select entity_type
2502: from wip_entities we
2503: where we.organization_id = mti.organization_id
2504: and we.wip_entity_id = mti.transaction_source_id)
2509:
2510: --derive the source project id/task id for jobs
2511: update mtl_transactions_interface mti
2512: set last_update_date = sysdate,
2513: last_updated_by = fnd_global.user_id,
2514: last_update_login = fnd_global.login_id,
2515: program_application_id = fnd_global.prog_appl_id,
2516: program_id = fnd_global.conc_program_id,
2517: program_update_date = sysdate,
2510: --derive the source project id/task id for jobs
2511: update mtl_transactions_interface mti
2512: set last_update_date = sysdate,
2513: last_updated_by = fnd_global.user_id,
2514: last_update_login = fnd_global.login_id,
2515: program_application_id = fnd_global.prog_appl_id,
2516: program_id = fnd_global.conc_program_id,
2517: program_update_date = sysdate,
2518: request_id = fnd_global.conc_request_id,
2511: update mtl_transactions_interface mti
2512: set last_update_date = sysdate,
2513: last_updated_by = fnd_global.user_id,
2514: last_update_login = fnd_global.login_id,
2515: program_application_id = fnd_global.prog_appl_id,
2516: program_id = fnd_global.conc_program_id,
2517: program_update_date = sysdate,
2518: request_id = fnd_global.conc_request_id,
2519: (source_project_id, source_task_id) =
2512: set last_update_date = sysdate,
2513: last_updated_by = fnd_global.user_id,
2514: last_update_login = fnd_global.login_id,
2515: program_application_id = fnd_global.prog_appl_id,
2516: program_id = fnd_global.conc_program_id,
2517: program_update_date = sysdate,
2518: request_id = fnd_global.conc_request_id,
2519: (source_project_id, source_task_id) =
2520: (select project_id,
2514: last_update_login = fnd_global.login_id,
2515: program_application_id = fnd_global.prog_appl_id,
2516: program_id = fnd_global.conc_program_id,
2517: program_update_date = sysdate,
2518: request_id = fnd_global.conc_request_id,
2519: (source_project_id, source_task_id) =
2520: (select project_id,
2521: task_id
2522: from wip_discrete_jobs
2531:
2532: --derive the source project id/task id for flow schedules
2533: update mtl_transactions_interface mti
2534: set last_update_date = sysdate,
2535: last_updated_by = fnd_global.user_id,
2536: last_update_login = fnd_global.login_id,
2537: program_application_id = fnd_global.prog_appl_id,
2538: program_id = fnd_global.conc_program_id,
2539: program_update_date = sysdate,
2532: --derive the source project id/task id for flow schedules
2533: update mtl_transactions_interface mti
2534: set last_update_date = sysdate,
2535: last_updated_by = fnd_global.user_id,
2536: last_update_login = fnd_global.login_id,
2537: program_application_id = fnd_global.prog_appl_id,
2538: program_id = fnd_global.conc_program_id,
2539: program_update_date = sysdate,
2540: request_id = fnd_global.conc_request_id,
2533: update mtl_transactions_interface mti
2534: set last_update_date = sysdate,
2535: last_updated_by = fnd_global.user_id,
2536: last_update_login = fnd_global.login_id,
2537: program_application_id = fnd_global.prog_appl_id,
2538: program_id = fnd_global.conc_program_id,
2539: program_update_date = sysdate,
2540: request_id = fnd_global.conc_request_id,
2541: (source_project_id, source_task_id) =
2534: set last_update_date = sysdate,
2535: last_updated_by = fnd_global.user_id,
2536: last_update_login = fnd_global.login_id,
2537: program_application_id = fnd_global.prog_appl_id,
2538: program_id = fnd_global.conc_program_id,
2539: program_update_date = sysdate,
2540: request_id = fnd_global.conc_request_id,
2541: (source_project_id, source_task_id) =
2542: (select project_id,
2536: last_update_login = fnd_global.login_id,
2537: program_application_id = fnd_global.prog_appl_id,
2538: program_id = fnd_global.conc_program_id,
2539: program_update_date = sysdate,
2540: request_id = fnd_global.conc_request_id,
2541: (source_project_id, source_task_id) =
2542: (select project_id,
2543: task_id
2544: from wip_flow_schedules
2557: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
2558: l_errMsg := substrb(fnd_message.get, 1, 240);
2559: update mtl_transactions_interface mti
2560: set last_update_date = sysdate,
2561: last_updated_by = fnd_global.user_id,
2562: last_update_login = fnd_global.login_id,
2563: program_application_id = fnd_global.prog_appl_id,
2564: program_id = fnd_global.conc_program_id,
2565: program_update_date = sysdate,
2558: l_errMsg := substrb(fnd_message.get, 1, 240);
2559: update mtl_transactions_interface mti
2560: set last_update_date = sysdate,
2561: last_updated_by = fnd_global.user_id,
2562: last_update_login = fnd_global.login_id,
2563: program_application_id = fnd_global.prog_appl_id,
2564: program_id = fnd_global.conc_program_id,
2565: program_update_date = sysdate,
2566: request_id = fnd_global.conc_request_id,
2559: update mtl_transactions_interface mti
2560: set last_update_date = sysdate,
2561: last_updated_by = fnd_global.user_id,
2562: last_update_login = fnd_global.login_id,
2563: program_application_id = fnd_global.prog_appl_id,
2564: program_id = fnd_global.conc_program_id,
2565: program_update_date = sysdate,
2566: request_id = fnd_global.conc_request_id,
2567: process_flag = 3,
2560: set last_update_date = sysdate,
2561: last_updated_by = fnd_global.user_id,
2562: last_update_login = fnd_global.login_id,
2563: program_application_id = fnd_global.prog_appl_id,
2564: program_id = fnd_global.conc_program_id,
2565: program_update_date = sysdate,
2566: request_id = fnd_global.conc_request_id,
2567: process_flag = 3,
2568: lock_flag = 2,
2562: last_update_login = fnd_global.login_id,
2563: program_application_id = fnd_global.prog_appl_id,
2564: program_id = fnd_global.conc_program_id,
2565: program_update_date = sysdate,
2566: request_id = fnd_global.conc_request_id,
2567: process_flag = 3,
2568: lock_flag = 2,
2569: error_code = 'Invalid flow schedule flag',
2570: error_explanation = l_errMsg
2580: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
2581: l_errMsg := substrb(fnd_message.get, 1, 240);
2582: update mtl_transactions_interface mti
2583: set last_update_date = sysdate,
2584: last_updated_by = fnd_global.user_id,
2585: last_update_login = fnd_global.login_id,
2586: program_application_id = fnd_global.prog_appl_id,
2587: program_id = fnd_global.conc_program_id,
2588: program_update_date = sysdate,
2581: l_errMsg := substrb(fnd_message.get, 1, 240);
2582: update mtl_transactions_interface mti
2583: set last_update_date = sysdate,
2584: last_updated_by = fnd_global.user_id,
2585: last_update_login = fnd_global.login_id,
2586: program_application_id = fnd_global.prog_appl_id,
2587: program_id = fnd_global.conc_program_id,
2588: program_update_date = sysdate,
2589: request_id = fnd_global.conc_request_id,
2582: update mtl_transactions_interface mti
2583: set last_update_date = sysdate,
2584: last_updated_by = fnd_global.user_id,
2585: last_update_login = fnd_global.login_id,
2586: program_application_id = fnd_global.prog_appl_id,
2587: program_id = fnd_global.conc_program_id,
2588: program_update_date = sysdate,
2589: request_id = fnd_global.conc_request_id,
2590: process_flag = 3,
2583: set last_update_date = sysdate,
2584: last_updated_by = fnd_global.user_id,
2585: last_update_login = fnd_global.login_id,
2586: program_application_id = fnd_global.prog_appl_id,
2587: program_id = fnd_global.conc_program_id,
2588: program_update_date = sysdate,
2589: request_id = fnd_global.conc_request_id,
2590: process_flag = 3,
2591: lock_flag = 2,
2585: last_update_login = fnd_global.login_id,
2586: program_application_id = fnd_global.prog_appl_id,
2587: program_id = fnd_global.conc_program_id,
2588: program_update_date = sysdate,
2589: request_id = fnd_global.conc_request_id,
2590: process_flag = 3,
2591: lock_flag = 2,
2592: error_code = 'transaction_source_id',
2593: error_explanation = l_errMsg
2615: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2616: l_errMsg := substrb(SQLERRM, 1, 240);
2617: update mtl_transactions_interface
2618: set last_update_date = sysdate,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id,
2621: program_application_id = fnd_global.prog_appl_id,
2622: program_id = fnd_global.conc_program_id,
2623: program_update_date = sysdate,
2616: l_errMsg := substrb(SQLERRM, 1, 240);
2617: update mtl_transactions_interface
2618: set last_update_date = sysdate,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id,
2621: program_application_id = fnd_global.prog_appl_id,
2622: program_id = fnd_global.conc_program_id,
2623: program_update_date = sysdate,
2624: request_id = fnd_global.conc_request_id,
2617: update mtl_transactions_interface
2618: set last_update_date = sysdate,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id,
2621: program_application_id = fnd_global.prog_appl_id,
2622: program_id = fnd_global.conc_program_id,
2623: program_update_date = sysdate,
2624: request_id = fnd_global.conc_request_id,
2625: process_flag = 3,
2618: set last_update_date = sysdate,
2619: last_updated_by = fnd_global.user_id,
2620: last_update_login = fnd_global.login_id,
2621: program_application_id = fnd_global.prog_appl_id,
2622: program_id = fnd_global.conc_program_id,
2623: program_update_date = sysdate,
2624: request_id = fnd_global.conc_request_id,
2625: process_flag = 3,
2626: lock_flag = 2,
2620: last_update_login = fnd_global.login_id,
2621: program_application_id = fnd_global.prog_appl_id,
2622: program_id = fnd_global.conc_program_id,
2623: program_update_date = sysdate,
2624: request_id = fnd_global.conc_request_id,
2625: process_flag = 3,
2626: lock_flag = 2,
2627: error_code = 'wip_mti_pub.doPreProcessingValidations',
2628: error_explanation = l_errMsg
2720: --if any components failed update the parent with the error
2721: forall i in 1..l_errExplTbl.count
2722: update mtl_transactions_interface mti
2723: set last_update_date = sysdate,
2724: last_updated_by = fnd_global.user_id,
2725: last_update_login = fnd_global.login_id,
2726: program_application_id = fnd_global.prog_appl_id,
2727: program_id = fnd_global.conc_program_id,
2728: program_update_date = sysdate,
2721: forall i in 1..l_errExplTbl.count
2722: update mtl_transactions_interface mti
2723: set last_update_date = sysdate,
2724: last_updated_by = fnd_global.user_id,
2725: last_update_login = fnd_global.login_id,
2726: program_application_id = fnd_global.prog_appl_id,
2727: program_id = fnd_global.conc_program_id,
2728: program_update_date = sysdate,
2729: request_id = fnd_global.conc_request_id,
2722: update mtl_transactions_interface mti
2723: set last_update_date = sysdate,
2724: last_updated_by = fnd_global.user_id,
2725: last_update_login = fnd_global.login_id,
2726: program_application_id = fnd_global.prog_appl_id,
2727: program_id = fnd_global.conc_program_id,
2728: program_update_date = sysdate,
2729: request_id = fnd_global.conc_request_id,
2730: error_code = substrb(l_itemNameTbl(i), 1, 240),
2723: set last_update_date = sysdate,
2724: last_updated_by = fnd_global.user_id,
2725: last_update_login = fnd_global.login_id,
2726: program_application_id = fnd_global.prog_appl_id,
2727: program_id = fnd_global.conc_program_id,
2728: program_update_date = sysdate,
2729: request_id = fnd_global.conc_request_id,
2730: error_code = substrb(l_itemNameTbl(i), 1, 240),
2731: error_explanation = l_errExplTbl(i)
2725: last_update_login = fnd_global.login_id,
2726: program_application_id = fnd_global.prog_appl_id,
2727: program_id = fnd_global.conc_program_id,
2728: program_update_date = sysdate,
2729: request_id = fnd_global.conc_request_id,
2730: error_code = substrb(l_itemNameTbl(i), 1, 240),
2731: error_explanation = l_errExplTbl(i)
2732: where transaction_header_id = p_txnHeaderID
2733: and transaction_batch_id = p_txnBatchID