210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
211: l_errExp := fnd_message.get;
212: update mtl_transactions_interface
213: set last_update_date = sysdate,
214: last_updated_by = fnd_global.user_id,
215: last_update_login = fnd_global.login_id,
216: program_application_id = fnd_global.prog_appl_id,
217: program_id = fnd_global.conc_program_id,
218: program_update_date = sysdate,
211: l_errExp := fnd_message.get;
212: update mtl_transactions_interface
213: set last_update_date = sysdate,
214: last_updated_by = fnd_global.user_id,
215: last_update_login = fnd_global.login_id,
216: program_application_id = fnd_global.prog_appl_id,
217: program_id = fnd_global.conc_program_id,
218: program_update_date = sysdate,
219: request_id = fnd_global.conc_request_id,
212: update mtl_transactions_interface
213: set last_update_date = sysdate,
214: last_updated_by = fnd_global.user_id,
215: last_update_login = fnd_global.login_id,
216: program_application_id = fnd_global.prog_appl_id,
217: program_id = fnd_global.conc_program_id,
218: program_update_date = sysdate,
219: request_id = fnd_global.conc_request_id,
220: process_flag = 3,
213: set last_update_date = sysdate,
214: last_updated_by = fnd_global.user_id,
215: last_update_login = fnd_global.login_id,
216: program_application_id = fnd_global.prog_appl_id,
217: program_id = fnd_global.conc_program_id,
218: program_update_date = sysdate,
219: request_id = fnd_global.conc_request_id,
220: process_flag = 3,
221: lock_flag = 2,
215: last_update_login = fnd_global.login_id,
216: program_application_id = fnd_global.prog_appl_id,
217: program_id = fnd_global.conc_program_id,
218: program_update_date = sysdate,
219: request_id = fnd_global.conc_request_id,
220: process_flag = 3,
221: lock_flag = 2,
222: error_code = 'wip_mti_pub.preInvWIPProcessing',
223: error_explanation = l_errExp
230: l_tbls.overCplPriQty(i) := l_convOverCplPriQty;
231:
232: update mtl_transactions_interface
233: set last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.login_id,
236: program_application_id = fnd_global.prog_appl_id,
237: program_id = fnd_global.conc_program_id,
238: program_update_date = sysdate,
231:
232: update mtl_transactions_interface
233: set last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.login_id,
236: program_application_id = fnd_global.prog_appl_id,
237: program_id = fnd_global.conc_program_id,
238: program_update_date = sysdate,
239: request_id = fnd_global.conc_request_id,
232: update mtl_transactions_interface
233: set last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.login_id,
236: program_application_id = fnd_global.prog_appl_id,
237: program_id = fnd_global.conc_program_id,
238: program_update_date = sysdate,
239: request_id = fnd_global.conc_request_id,
240: primary_quantity = l_tbls.priQty(i),
233: set last_update_date = sysdate,
234: last_updated_by = fnd_global.user_id,
235: last_update_login = fnd_global.login_id,
236: program_application_id = fnd_global.prog_appl_id,
237: program_id = fnd_global.conc_program_id,
238: program_update_date = sysdate,
239: request_id = fnd_global.conc_request_id,
240: primary_quantity = l_tbls.priQty(i),
241: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
235: last_update_login = fnd_global.login_id,
236: program_application_id = fnd_global.prog_appl_id,
237: program_id = fnd_global.conc_program_id,
238: program_update_date = sysdate,
239: request_id = fnd_global.conc_request_id,
240: primary_quantity = l_tbls.priQty(i),
241: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
242: where transaction_interface_id = l_tbls.txnIntID(i);
243: if(l_logLevel <= wip_constants.full_logging) then
270:
271: forall i in 1..l_errTbls.txnIntID.count
272: update mtl_transactions_interface
273: set last_update_date = sysdate,
274: last_updated_by = fnd_global.user_id,
275: last_update_login = fnd_global.login_id,
276: program_application_id = fnd_global.prog_appl_id,
277: program_id = fnd_global.conc_program_id,
278: program_update_date = sysdate,
271: forall i in 1..l_errTbls.txnIntID.count
272: update mtl_transactions_interface
273: set last_update_date = sysdate,
274: last_updated_by = fnd_global.user_id,
275: last_update_login = fnd_global.login_id,
276: program_application_id = fnd_global.prog_appl_id,
277: program_id = fnd_global.conc_program_id,
278: program_update_date = sysdate,
279: request_id = fnd_global.conc_request_id,
272: update mtl_transactions_interface
273: set last_update_date = sysdate,
274: last_updated_by = fnd_global.user_id,
275: last_update_login = fnd_global.login_id,
276: program_application_id = fnd_global.prog_appl_id,
277: program_id = fnd_global.conc_program_id,
278: program_update_date = sysdate,
279: request_id = fnd_global.conc_request_id,
280: process_flag = wip_constants.mti_error,
273: set last_update_date = sysdate,
274: last_updated_by = fnd_global.user_id,
275: last_update_login = fnd_global.login_id,
276: program_application_id = fnd_global.prog_appl_id,
277: program_id = fnd_global.conc_program_id,
278: program_update_date = sysdate,
279: request_id = fnd_global.conc_request_id,
280: process_flag = wip_constants.mti_error,
281: error_code = l_errTbls.errCode(i),
275: last_update_login = fnd_global.login_id,
276: program_application_id = fnd_global.prog_appl_id,
277: program_id = fnd_global.conc_program_id,
278: program_update_date = sysdate,
279: request_id = fnd_global.conc_request_id,
280: process_flag = wip_constants.mti_error,
281: error_code = l_errTbls.errCode(i),
282: error_explanation = l_errTbls.errExpl(i),
283: lock_flag = 2 --unlock the record so it can be re-submitted
306: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
307:
308: update mtl_transactions_interface
309: set last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,
311: last_update_login = fnd_global.login_id,
312: program_application_id = fnd_global.prog_appl_id,
313: program_id = fnd_global.conc_program_id,
314: program_update_date = sysdate,
307:
308: update mtl_transactions_interface
309: set last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,
311: last_update_login = fnd_global.login_id,
312: program_application_id = fnd_global.prog_appl_id,
313: program_id = fnd_global.conc_program_id,
314: program_update_date = sysdate,
315: request_id = fnd_global.conc_request_id,
308: update mtl_transactions_interface
309: set last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,
311: last_update_login = fnd_global.login_id,
312: program_application_id = fnd_global.prog_appl_id,
313: program_id = fnd_global.conc_program_id,
314: program_update_date = sysdate,
315: request_id = fnd_global.conc_request_id,
316: process_flag = 3,
309: set last_update_date = sysdate,
310: last_updated_by = fnd_global.user_id,
311: last_update_login = fnd_global.login_id,
312: program_application_id = fnd_global.prog_appl_id,
313: program_id = fnd_global.conc_program_id,
314: program_update_date = sysdate,
315: request_id = fnd_global.conc_request_id,
316: process_flag = 3,
317: lock_flag = 2,
311: last_update_login = fnd_global.login_id,
312: program_application_id = fnd_global.prog_appl_id,
313: program_id = fnd_global.conc_program_id,
314: program_update_date = sysdate,
315: request_id = fnd_global.conc_request_id,
316: process_flag = 3,
317: lock_flag = 2,
318: error_code = 'wip_mti_pub.preInvWIPProcessing',
319: error_explanation = l_errExp
790: fnd_message.set_token('ENTITY', 'Transactions');
791: l_errMsg := substrb(fnd_message.get, 1, 240);
792: update mtl_transactions_interface mti
793: set last_update_date = sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id,
796: program_application_id = fnd_global.prog_appl_id,
797: program_id = fnd_global.conc_program_id,
798: program_update_date = sysdate,
791: l_errMsg := substrb(fnd_message.get, 1, 240);
792: update mtl_transactions_interface mti
793: set last_update_date = sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id,
796: program_application_id = fnd_global.prog_appl_id,
797: program_id = fnd_global.conc_program_id,
798: program_update_date = sysdate,
799: request_id = fnd_global.conc_request_id,
792: update mtl_transactions_interface mti
793: set last_update_date = sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id,
796: program_application_id = fnd_global.prog_appl_id,
797: program_id = fnd_global.conc_program_id,
798: program_update_date = sysdate,
799: request_id = fnd_global.conc_request_id,
800: process_flag = 3,
793: set last_update_date = sysdate,
794: last_updated_by = fnd_global.user_id,
795: last_update_login = fnd_global.login_id,
796: program_application_id = fnd_global.prog_appl_id,
797: program_id = fnd_global.conc_program_id,
798: program_update_date = sysdate,
799: request_id = fnd_global.conc_request_id,
800: process_flag = 3,
801: lock_flag = 2,
795: last_update_login = fnd_global.login_id,
796: program_application_id = fnd_global.prog_appl_id,
797: program_id = fnd_global.conc_program_id,
798: program_update_date = sysdate,
799: request_id = fnd_global.conc_request_id,
800: process_flag = 3,
801: lock_flag = 2,
802: error_code = 'Transaction',
803: error_explanation = l_errMsg
812: fnd_message.set_token('ENTITY', 'line');
813: l_errMsg := substrb(fnd_message.get, 1, 240);
814: update mtl_transactions_interface mti
815: set last_update_date = sysdate,
816: last_updated_by = fnd_global.user_id,
817: last_update_login = fnd_global.login_id,
818: program_application_id = fnd_global.prog_appl_id,
819: program_id = fnd_global.conc_program_id,
820: program_update_date = sysdate,
813: l_errMsg := substrb(fnd_message.get, 1, 240);
814: update mtl_transactions_interface mti
815: set last_update_date = sysdate,
816: last_updated_by = fnd_global.user_id,
817: last_update_login = fnd_global.login_id,
818: program_application_id = fnd_global.prog_appl_id,
819: program_id = fnd_global.conc_program_id,
820: program_update_date = sysdate,
821: request_id = fnd_global.conc_request_id,
814: update mtl_transactions_interface mti
815: set last_update_date = sysdate,
816: last_updated_by = fnd_global.user_id,
817: last_update_login = fnd_global.login_id,
818: program_application_id = fnd_global.prog_appl_id,
819: program_id = fnd_global.conc_program_id,
820: program_update_date = sysdate,
821: request_id = fnd_global.conc_request_id,
822: process_flag = 3,
815: set last_update_date = sysdate,
816: last_updated_by = fnd_global.user_id,
817: last_update_login = fnd_global.login_id,
818: program_application_id = fnd_global.prog_appl_id,
819: program_id = fnd_global.conc_program_id,
820: program_update_date = sysdate,
821: request_id = fnd_global.conc_request_id,
822: process_flag = 3,
823: lock_flag = 2,
817: last_update_login = fnd_global.login_id,
818: program_application_id = fnd_global.prog_appl_id,
819: program_id = fnd_global.conc_program_id,
820: program_update_date = sysdate,
821: request_id = fnd_global.conc_request_id,
822: process_flag = 3,
823: lock_flag = 2,
824: error_code = 'repetitive_line_id',
825: error_explanation = l_errMsg
842: fnd_message.set_name('WIP', 'WIP_INVALID_LINE');
843: l_errMsg := substrb(fnd_message.get, 1, 240);
844: update mtl_transactions_interface mti
845: set last_update_date = sysdate,
846: last_updated_by = fnd_global.user_id,
847: last_update_login = fnd_global.login_id,
848: program_application_id = fnd_global.prog_appl_id,
849: program_id = fnd_global.conc_program_id,
850: program_update_date = sysdate,
843: l_errMsg := substrb(fnd_message.get, 1, 240);
844: update mtl_transactions_interface mti
845: set last_update_date = sysdate,
846: last_updated_by = fnd_global.user_id,
847: last_update_login = fnd_global.login_id,
848: program_application_id = fnd_global.prog_appl_id,
849: program_id = fnd_global.conc_program_id,
850: program_update_date = sysdate,
851: request_id = fnd_global.conc_request_id,
844: update mtl_transactions_interface mti
845: set last_update_date = sysdate,
846: last_updated_by = fnd_global.user_id,
847: last_update_login = fnd_global.login_id,
848: program_application_id = fnd_global.prog_appl_id,
849: program_id = fnd_global.conc_program_id,
850: program_update_date = sysdate,
851: request_id = fnd_global.conc_request_id,
852: process_flag = 3,
845: set last_update_date = sysdate,
846: last_updated_by = fnd_global.user_id,
847: last_update_login = fnd_global.login_id,
848: program_application_id = fnd_global.prog_appl_id,
849: program_id = fnd_global.conc_program_id,
850: program_update_date = sysdate,
851: request_id = fnd_global.conc_request_id,
852: process_flag = 3,
853: lock_flag = 2,
847: last_update_login = fnd_global.login_id,
848: program_application_id = fnd_global.prog_appl_id,
849: program_id = fnd_global.conc_program_id,
850: program_update_date = sysdate,
851: request_id = fnd_global.conc_request_id,
852: process_flag = 3,
853: lock_flag = 2,
854: error_code = 'repetitive_line_id',
855: error_explanation = l_errMsg
868: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
869: l_errMsg := substrb(fnd_message.get, 1, 240);
870: update mtl_transactions_interface mti
871: set last_update_date = sysdate,
872: last_updated_by = fnd_global.user_id,
873: last_update_login = fnd_global.login_id,
874: program_application_id = fnd_global.prog_appl_id,
875: program_id = fnd_global.conc_program_id,
876: program_update_date = sysdate,
869: l_errMsg := substrb(fnd_message.get, 1, 240);
870: update mtl_transactions_interface mti
871: set last_update_date = sysdate,
872: last_updated_by = fnd_global.user_id,
873: last_update_login = fnd_global.login_id,
874: program_application_id = fnd_global.prog_appl_id,
875: program_id = fnd_global.conc_program_id,
876: program_update_date = sysdate,
877: request_id = fnd_global.conc_request_id,
870: update mtl_transactions_interface mti
871: set last_update_date = sysdate,
872: last_updated_by = fnd_global.user_id,
873: last_update_login = fnd_global.login_id,
874: program_application_id = fnd_global.prog_appl_id,
875: program_id = fnd_global.conc_program_id,
876: program_update_date = sysdate,
877: request_id = fnd_global.conc_request_id,
878: process_flag = 3,
871: set last_update_date = sysdate,
872: last_updated_by = fnd_global.user_id,
873: last_update_login = fnd_global.login_id,
874: program_application_id = fnd_global.prog_appl_id,
875: program_id = fnd_global.conc_program_id,
876: program_update_date = sysdate,
877: request_id = fnd_global.conc_request_id,
878: process_flag = 3,
879: lock_flag = 2,
873: last_update_login = fnd_global.login_id,
874: program_application_id = fnd_global.prog_appl_id,
875: program_id = fnd_global.conc_program_id,
876: program_update_date = sysdate,
877: request_id = fnd_global.conc_request_id,
878: process_flag = 3,
879: lock_flag = 2,
880: error_code = 'transaction_source_id',
881: error_explanation = l_errMsg
903: fnd_message.set_name('WIP', 'WIP_NO_ASSY_NO_TXN');
904: l_errMsg := substrb(fnd_message.get, 1, 240);
905: update mtl_transactions_interface mti
906: set last_update_date = sysdate,
907: last_updated_by = fnd_global.user_id,
908: last_update_login = fnd_global.login_id,
909: program_application_id = fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate,
904: l_errMsg := substrb(fnd_message.get, 1, 240);
905: update mtl_transactions_interface mti
906: set last_update_date = sysdate,
907: last_updated_by = fnd_global.user_id,
908: last_update_login = fnd_global.login_id,
909: program_application_id = fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate,
912: request_id = fnd_global.conc_request_id,
905: update mtl_transactions_interface mti
906: set last_update_date = sysdate,
907: last_updated_by = fnd_global.user_id,
908: last_update_login = fnd_global.login_id,
909: program_application_id = fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate,
912: request_id = fnd_global.conc_request_id,
913: process_flag = 3,
906: set last_update_date = sysdate,
907: last_updated_by = fnd_global.user_id,
908: last_update_login = fnd_global.login_id,
909: program_application_id = fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate,
912: request_id = fnd_global.conc_request_id,
913: process_flag = 3,
914: lock_flag = 2,
908: last_update_login = fnd_global.login_id,
909: program_application_id = fnd_global.prog_appl_id,
910: program_id = fnd_global.conc_program_id,
911: program_update_date = sysdate,
912: request_id = fnd_global.conc_request_id,
913: process_flag = 3,
914: lock_flag = 2,
915: error_code = 'transaction_source_id',
916: error_explanation = l_errMsg
934:
935: -- derive earliest valid schedule
936: update mtl_transactions_interface mti
937: set last_update_date = sysdate,
938: last_updated_by = fnd_global.user_id,
939: last_update_login = fnd_global.login_id,
940: program_application_id = fnd_global.prog_appl_id,
941: program_id = fnd_global.conc_program_id,
942: program_update_date = sysdate,
935: -- derive earliest valid schedule
936: update mtl_transactions_interface mti
937: set last_update_date = sysdate,
938: last_updated_by = fnd_global.user_id,
939: last_update_login = fnd_global.login_id,
940: program_application_id = fnd_global.prog_appl_id,
941: program_id = fnd_global.conc_program_id,
942: program_update_date = sysdate,
943: request_id = fnd_global.conc_request_id,
936: update mtl_transactions_interface mti
937: set last_update_date = sysdate,
938: last_updated_by = fnd_global.user_id,
939: last_update_login = fnd_global.login_id,
940: program_application_id = fnd_global.prog_appl_id,
941: program_id = fnd_global.conc_program_id,
942: program_update_date = sysdate,
943: request_id = fnd_global.conc_request_id,
944: schedule_id = (select repetitive_schedule_id
937: set last_update_date = sysdate,
938: last_updated_by = fnd_global.user_id,
939: last_update_login = fnd_global.login_id,
940: program_application_id = fnd_global.prog_appl_id,
941: program_id = fnd_global.conc_program_id,
942: program_update_date = sysdate,
943: request_id = fnd_global.conc_request_id,
944: schedule_id = (select repetitive_schedule_id
945: from wip_repetitive_schedules wrs1
939: last_update_login = fnd_global.login_id,
940: program_application_id = fnd_global.prog_appl_id,
941: program_id = fnd_global.conc_program_id,
942: program_update_date = sysdate,
943: request_id = fnd_global.conc_request_id,
944: schedule_id = (select repetitive_schedule_id
945: from wip_repetitive_schedules wrs1
946: where wrs1.organization_id = mti.organization_id
947: and wrs1.wip_entity_id = mti.transaction_source_id
962:
963: -- derive op seq num for completions
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 completions
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 max(operation_seq_num)
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 max(operation_seq_num)
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 max(operation_seq_num)
973: from wip_operations wo
974: where wo.organization_id = mti.organization_id
975: and wo.wip_entity_id = mti.transaction_source_id
985:
986: -- derive op seq num for wip component issue/return
987: update mtl_transactions_interface mti
988: set last_update_date = sysdate,
989: last_updated_by = fnd_global.user_id,
990: last_update_login = fnd_global.login_id,
991: program_application_id = fnd_global.prog_appl_id,
992: program_id = fnd_global.conc_program_id,
993: program_update_date = sysdate,
986: -- derive op seq num for wip component issue/return
987: update mtl_transactions_interface mti
988: set last_update_date = sysdate,
989: last_updated_by = fnd_global.user_id,
990: last_update_login = fnd_global.login_id,
991: program_application_id = fnd_global.prog_appl_id,
992: program_id = fnd_global.conc_program_id,
993: program_update_date = sysdate,
994: request_id = fnd_global.conc_request_id,
987: update mtl_transactions_interface mti
988: set last_update_date = sysdate,
989: last_updated_by = fnd_global.user_id,
990: last_update_login = fnd_global.login_id,
991: program_application_id = fnd_global.prog_appl_id,
992: program_id = fnd_global.conc_program_id,
993: program_update_date = sysdate,
994: request_id = fnd_global.conc_request_id,
995: operation_seq_num = (select nvl(max(operation_seq_num), 1)
988: set last_update_date = sysdate,
989: last_updated_by = fnd_global.user_id,
990: last_update_login = fnd_global.login_id,
991: program_application_id = fnd_global.prog_appl_id,
992: program_id = fnd_global.conc_program_id,
993: program_update_date = sysdate,
994: request_id = fnd_global.conc_request_id,
995: operation_seq_num = (select nvl(max(operation_seq_num), 1)
996: from wip_operations wo
990: last_update_login = fnd_global.login_id,
991: program_application_id = fnd_global.prog_appl_id,
992: program_id = fnd_global.conc_program_id,
993: program_update_date = sysdate,
994: request_id = fnd_global.conc_request_id,
995: operation_seq_num = (select nvl(max(operation_seq_num), 1)
996: from wip_operations wo
997: where wo.organization_id = mti.organization_id
998: and wo.wip_entity_id = mti.transaction_source_id
1012: fnd_message.set_name('WIP', 'WIP_INVALID_OPERATION');
1013: l_errMsg := substrb(fnd_message.get, 1, 240);
1014: update mtl_transactions_interface mti
1015: set last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.login_id,
1018: program_application_id = fnd_global.prog_appl_id,
1019: program_id = fnd_global.conc_program_id,
1020: program_update_date = sysdate,
1013: l_errMsg := substrb(fnd_message.get, 1, 240);
1014: update mtl_transactions_interface mti
1015: set last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.login_id,
1018: program_application_id = fnd_global.prog_appl_id,
1019: program_id = fnd_global.conc_program_id,
1020: program_update_date = sysdate,
1021: request_id = fnd_global.conc_request_id,
1014: update mtl_transactions_interface mti
1015: set last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.login_id,
1018: program_application_id = fnd_global.prog_appl_id,
1019: program_id = fnd_global.conc_program_id,
1020: program_update_date = sysdate,
1021: request_id = fnd_global.conc_request_id,
1022: process_flag = 3,
1015: set last_update_date = sysdate,
1016: last_updated_by = fnd_global.user_id,
1017: last_update_login = fnd_global.login_id,
1018: program_application_id = fnd_global.prog_appl_id,
1019: program_id = fnd_global.conc_program_id,
1020: program_update_date = sysdate,
1021: request_id = fnd_global.conc_request_id,
1022: process_flag = 3,
1023: lock_flag = 2,
1017: last_update_login = fnd_global.login_id,
1018: program_application_id = fnd_global.prog_appl_id,
1019: program_id = fnd_global.conc_program_id,
1020: program_update_date = sysdate,
1021: request_id = fnd_global.conc_request_id,
1022: process_flag = 3,
1023: lock_flag = 2,
1024: error_code = 'operation_seq_num',
1025: error_explanation = l_errMsg
1053: l_engItemFlag := 2; -- default to not an engineering item
1054: end;
1055: update mtl_transactions_interface mti
1056: set last_update_date = sysdate,
1057: last_updated_by = fnd_global.user_id,
1058: last_update_login = fnd_global.login_id,
1059: program_application_id = fnd_global.prog_appl_id,
1060: program_id = fnd_global.conc_program_id,
1061: program_update_date = sysdate,
1054: end;
1055: update mtl_transactions_interface mti
1056: set last_update_date = sysdate,
1057: last_updated_by = fnd_global.user_id,
1058: last_update_login = fnd_global.login_id,
1059: program_application_id = fnd_global.prog_appl_id,
1060: program_id = fnd_global.conc_program_id,
1061: program_update_date = sysdate,
1062: request_id = fnd_global.conc_request_id,
1055: update mtl_transactions_interface mti
1056: set last_update_date = sysdate,
1057: last_updated_by = fnd_global.user_id,
1058: last_update_login = fnd_global.login_id,
1059: program_application_id = fnd_global.prog_appl_id,
1060: program_id = fnd_global.conc_program_id,
1061: program_update_date = sysdate,
1062: request_id = fnd_global.conc_request_id,
1063: process_flag = 3,
1056: set last_update_date = sysdate,
1057: last_updated_by = fnd_global.user_id,
1058: last_update_login = fnd_global.login_id,
1059: program_application_id = fnd_global.prog_appl_id,
1060: program_id = fnd_global.conc_program_id,
1061: program_update_date = sysdate,
1062: request_id = fnd_global.conc_request_id,
1063: process_flag = 3,
1064: lock_flag = 2,
1058: last_update_login = fnd_global.login_id,
1059: program_application_id = fnd_global.prog_appl_id,
1060: program_id = fnd_global.conc_program_id,
1061: program_update_date = sysdate,
1062: request_id = fnd_global.conc_request_id,
1063: process_flag = 3,
1064: lock_flag = 2,
1065: error_code = 'inventory_item_id',
1066: error_explanation = l_errMsg
1153: l_errMsg := substrb(fnd_message.get, 1, 240);
1154:
1155: update mtl_transactions_interface mti
1156: set last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,
1158: last_update_login = fnd_global.login_id,
1159: program_application_id = fnd_global.prog_appl_id,
1160: program_id = fnd_global.conc_program_id,
1161: program_update_date = sysdate,
1154:
1155: update mtl_transactions_interface mti
1156: set last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,
1158: last_update_login = fnd_global.login_id,
1159: program_application_id = fnd_global.prog_appl_id,
1160: program_id = fnd_global.conc_program_id,
1161: program_update_date = sysdate,
1162: request_id = fnd_global.conc_request_id,
1155: update mtl_transactions_interface mti
1156: set last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,
1158: last_update_login = fnd_global.login_id,
1159: program_application_id = fnd_global.prog_appl_id,
1160: program_id = fnd_global.conc_program_id,
1161: program_update_date = sysdate,
1162: request_id = fnd_global.conc_request_id,
1163: process_flag = 3,
1156: set last_update_date = sysdate,
1157: last_updated_by = fnd_global.user_id,
1158: last_update_login = fnd_global.login_id,
1159: program_application_id = fnd_global.prog_appl_id,
1160: program_id = fnd_global.conc_program_id,
1161: program_update_date = sysdate,
1162: request_id = fnd_global.conc_request_id,
1163: process_flag = 3,
1164: lock_flag = 2,
1158: last_update_login = fnd_global.login_id,
1159: program_application_id = fnd_global.prog_appl_id,
1160: program_id = fnd_global.conc_program_id,
1161: program_update_date = sysdate,
1162: request_id = fnd_global.conc_request_id,
1163: process_flag = 3,
1164: lock_flag = 2,
1165: error_code = 'operation_seq_num',
1166: error_explanation = l_errMsg
1174: fnd_message.set_token('ENTITY', 'final_completion_flag');
1175: l_errMsg := substrb(fnd_message.get, 1, 240);
1176: update mtl_transactions_interface mti
1177: set last_update_date = sysdate,
1178: last_updated_by = fnd_global.user_id,
1179: last_update_login = fnd_global.login_id,
1180: program_application_id = fnd_global.prog_appl_id,
1181: program_id = fnd_global.conc_program_id,
1182: program_update_date = sysdate,
1175: l_errMsg := substrb(fnd_message.get, 1, 240);
1176: update mtl_transactions_interface mti
1177: set last_update_date = sysdate,
1178: last_updated_by = fnd_global.user_id,
1179: last_update_login = fnd_global.login_id,
1180: program_application_id = fnd_global.prog_appl_id,
1181: program_id = fnd_global.conc_program_id,
1182: program_update_date = sysdate,
1183: request_id = fnd_global.conc_request_id,
1176: update mtl_transactions_interface mti
1177: set last_update_date = sysdate,
1178: last_updated_by = fnd_global.user_id,
1179: last_update_login = fnd_global.login_id,
1180: program_application_id = fnd_global.prog_appl_id,
1181: program_id = fnd_global.conc_program_id,
1182: program_update_date = sysdate,
1183: request_id = fnd_global.conc_request_id,
1184: process_flag = 3,
1177: set last_update_date = sysdate,
1178: last_updated_by = fnd_global.user_id,
1179: last_update_login = fnd_global.login_id,
1180: program_application_id = fnd_global.prog_appl_id,
1181: program_id = fnd_global.conc_program_id,
1182: program_update_date = sysdate,
1183: request_id = fnd_global.conc_request_id,
1184: process_flag = 3,
1185: lock_flag = 2,
1179: last_update_login = fnd_global.login_id,
1180: program_application_id = fnd_global.prog_appl_id,
1181: program_id = fnd_global.conc_program_id,
1182: program_update_date = sysdate,
1183: request_id = fnd_global.conc_request_id,
1184: process_flag = 3,
1185: lock_flag = 2,
1186: error_code = 'final_completion_flag',
1187: error_explanation = l_errMsg
1195:
1196: -- derive item revision for completion txns for discrete jobs
1197: update mtl_transactions_interface mti
1198: set last_update_date = sysdate,
1199: last_updated_by = fnd_global.user_id,
1200: last_update_login = fnd_global.login_id,
1201: program_application_id = fnd_global.prog_appl_id,
1202: program_id = fnd_global.conc_program_id,
1203: program_update_date = sysdate,
1196: -- derive item revision for completion txns for discrete jobs
1197: update mtl_transactions_interface mti
1198: set last_update_date = sysdate,
1199: last_updated_by = fnd_global.user_id,
1200: last_update_login = fnd_global.login_id,
1201: program_application_id = fnd_global.prog_appl_id,
1202: program_id = fnd_global.conc_program_id,
1203: program_update_date = sysdate,
1204: request_id = fnd_global.conc_request_id,
1197: update mtl_transactions_interface mti
1198: set last_update_date = sysdate,
1199: last_updated_by = fnd_global.user_id,
1200: last_update_login = fnd_global.login_id,
1201: program_application_id = fnd_global.prog_appl_id,
1202: program_id = fnd_global.conc_program_id,
1203: program_update_date = sysdate,
1204: request_id = fnd_global.conc_request_id,
1205: revision = (select nvl(mti.revision, wdj.bom_revision)
1198: set last_update_date = sysdate,
1199: last_updated_by = fnd_global.user_id,
1200: last_update_login = fnd_global.login_id,
1201: program_application_id = fnd_global.prog_appl_id,
1202: program_id = fnd_global.conc_program_id,
1203: program_update_date = sysdate,
1204: request_id = fnd_global.conc_request_id,
1205: revision = (select nvl(mti.revision, wdj.bom_revision)
1206: from wip_discrete_jobs wdj
1200: last_update_login = fnd_global.login_id,
1201: program_application_id = fnd_global.prog_appl_id,
1202: program_id = fnd_global.conc_program_id,
1203: program_update_date = sysdate,
1204: request_id = fnd_global.conc_request_id,
1205: revision = (select nvl(mti.revision, wdj.bom_revision)
1206: from wip_discrete_jobs wdj
1207: where wdj.organization_id = mti.organization_id
1208: and wdj.wip_entity_id = mti.transaction_source_id)
1221:
1222: -- derive item revision for completion txns for repetitive
1223: update mtl_transactions_interface mti
1224: set last_update_date = sysdate,
1225: last_updated_by = fnd_global.user_id,
1226: last_update_login = fnd_global.login_id,
1227: program_application_id = fnd_global.prog_appl_id,
1228: program_id = fnd_global.conc_program_id,
1229: program_update_date = sysdate,
1222: -- derive item revision for completion txns for repetitive
1223: update mtl_transactions_interface mti
1224: set last_update_date = sysdate,
1225: last_updated_by = fnd_global.user_id,
1226: last_update_login = fnd_global.login_id,
1227: program_application_id = fnd_global.prog_appl_id,
1228: program_id = fnd_global.conc_program_id,
1229: program_update_date = sysdate,
1230: request_id = fnd_global.conc_request_id,
1223: update mtl_transactions_interface mti
1224: set last_update_date = sysdate,
1225: last_updated_by = fnd_global.user_id,
1226: last_update_login = fnd_global.login_id,
1227: program_application_id = fnd_global.prog_appl_id,
1228: program_id = fnd_global.conc_program_id,
1229: program_update_date = sysdate,
1230: request_id = fnd_global.conc_request_id,
1231: revision = (select nvl(mti.revision, wrs.bom_revision)
1224: set last_update_date = sysdate,
1225: last_updated_by = fnd_global.user_id,
1226: last_update_login = fnd_global.login_id,
1227: program_application_id = fnd_global.prog_appl_id,
1228: program_id = fnd_global.conc_program_id,
1229: program_update_date = sysdate,
1230: request_id = fnd_global.conc_request_id,
1231: revision = (select nvl(mti.revision, wrs.bom_revision)
1232: from wip_repetitive_schedules wrs
1226: last_update_login = fnd_global.login_id,
1227: program_application_id = fnd_global.prog_appl_id,
1228: program_id = fnd_global.conc_program_id,
1229: program_update_date = sysdate,
1230: request_id = fnd_global.conc_request_id,
1231: revision = (select nvl(mti.revision, wrs.bom_revision)
1232: from wip_repetitive_schedules wrs
1233: where wrs.organization_id = mti.organization_id
1234: and wrs.repetitive_schedule_id = mti.schedule_id)
1246:
1247: -- derive item revision for flow
1248: update mtl_transactions_interface mti
1249: set last_update_date = sysdate,
1250: last_updated_by = fnd_global.user_id,
1251: last_update_login = fnd_global.login_id,
1252: program_application_id = fnd_global.prog_appl_id,
1253: program_id = fnd_global.conc_program_id,
1254: program_update_date = sysdate,
1247: -- derive item revision for flow
1248: update mtl_transactions_interface mti
1249: set last_update_date = sysdate,
1250: last_updated_by = fnd_global.user_id,
1251: last_update_login = fnd_global.login_id,
1252: program_application_id = fnd_global.prog_appl_id,
1253: program_id = fnd_global.conc_program_id,
1254: program_update_date = sysdate,
1255: request_id = fnd_global.conc_request_id,
1248: update mtl_transactions_interface mti
1249: set last_update_date = sysdate,
1250: last_updated_by = fnd_global.user_id,
1251: last_update_login = fnd_global.login_id,
1252: program_application_id = fnd_global.prog_appl_id,
1253: program_id = fnd_global.conc_program_id,
1254: program_update_date = sysdate,
1255: request_id = fnd_global.conc_request_id,
1256: revision = (select nvl(mti.revision, wfs.bom_revision)
1249: set last_update_date = sysdate,
1250: last_updated_by = fnd_global.user_id,
1251: last_update_login = fnd_global.login_id,
1252: program_application_id = fnd_global.prog_appl_id,
1253: program_id = fnd_global.conc_program_id,
1254: program_update_date = sysdate,
1255: request_id = fnd_global.conc_request_id,
1256: revision = (select nvl(mti.revision, wfs.bom_revision)
1257: from wip_flow_schedules wfs
1251: last_update_login = fnd_global.login_id,
1252: program_application_id = fnd_global.prog_appl_id,
1253: program_id = fnd_global.conc_program_id,
1254: program_update_date = sysdate,
1255: request_id = fnd_global.conc_request_id,
1256: revision = (select nvl(mti.revision, wfs.bom_revision)
1257: from wip_flow_schedules wfs
1258: where wfs.organization_id = mti.organization_id
1259: and wfs.wip_entity_id = mti.transaction_source_id)
1272:
1273: -- derive completion_transaction_id for flow components
1274: update mtl_transactions_interface mti
1275: set last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id,
1277: last_update_login = fnd_global.login_id,
1278: program_application_id = fnd_global.prog_appl_id,
1279: program_id = fnd_global.conc_program_id,
1280: program_update_date = sysdate,
1273: -- derive completion_transaction_id for flow components
1274: update mtl_transactions_interface mti
1275: set last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id,
1277: last_update_login = fnd_global.login_id,
1278: program_application_id = fnd_global.prog_appl_id,
1279: program_id = fnd_global.conc_program_id,
1280: program_update_date = sysdate,
1281: request_id = fnd_global.conc_request_id,
1274: update mtl_transactions_interface mti
1275: set last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id,
1277: last_update_login = fnd_global.login_id,
1278: program_application_id = fnd_global.prog_appl_id,
1279: program_id = fnd_global.conc_program_id,
1280: program_update_date = sysdate,
1281: request_id = fnd_global.conc_request_id,
1282: completion_transaction_id = (select completion_transaction_id
1275: set last_update_date = sysdate,
1276: last_updated_by = fnd_global.user_id,
1277: last_update_login = fnd_global.login_id,
1278: program_application_id = fnd_global.prog_appl_id,
1279: program_id = fnd_global.conc_program_id,
1280: program_update_date = sysdate,
1281: request_id = fnd_global.conc_request_id,
1282: completion_transaction_id = (select completion_transaction_id
1283: from mtl_transactions_interface mti2
1277: last_update_login = fnd_global.login_id,
1278: program_application_id = fnd_global.prog_appl_id,
1279: program_id = fnd_global.conc_program_id,
1280: program_update_date = sysdate,
1281: request_id = fnd_global.conc_request_id,
1282: completion_transaction_id = (select completion_transaction_id
1283: from mtl_transactions_interface mti2
1284: where mti.parent_id = mti2.transaction_interface_id)
1285: where transaction_header_id = p_txnHeaderID
1300: fnd_message.set_name('WIP', 'WIP_BOM_ITEM_REVISION');
1301: l_errMsg := substrb(fnd_message.get, 1, 240);
1302: update mtl_transactions_interface mti
1303: set last_update_date = sysdate,
1304: last_updated_by = fnd_global.user_id,
1305: last_update_login = fnd_global.login_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate,
1301: l_errMsg := substrb(fnd_message.get, 1, 240);
1302: update mtl_transactions_interface mti
1303: set last_update_date = sysdate,
1304: last_updated_by = fnd_global.user_id,
1305: last_update_login = fnd_global.login_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate,
1309: request_id = fnd_global.conc_request_id,
1302: update mtl_transactions_interface mti
1303: set last_update_date = sysdate,
1304: last_updated_by = fnd_global.user_id,
1305: last_update_login = fnd_global.login_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate,
1309: request_id = fnd_global.conc_request_id,
1310: process_flag = 3,
1303: set last_update_date = sysdate,
1304: last_updated_by = fnd_global.user_id,
1305: last_update_login = fnd_global.login_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate,
1309: request_id = fnd_global.conc_request_id,
1310: process_flag = 3,
1311: lock_flag = 2,
1305: last_update_login = fnd_global.login_id,
1306: program_application_id = fnd_global.prog_appl_id,
1307: program_id = fnd_global.conc_program_id,
1308: program_update_date = sysdate,
1309: request_id = fnd_global.conc_request_id,
1310: process_flag = 3,
1311: lock_flag = 2,
1312: error_code = 'revision',
1313: error_explanation = l_errMsg
1335: -- then we should include flow entities as well. Otherwise, we should do
1336: -- that especially for it alone.
1337: update mtl_transactions_interface mti
1338: set last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: last_update_login = fnd_global.login_id,
1341: program_application_id = fnd_global.prog_appl_id,
1342: program_id = fnd_global.conc_program_id,
1343: program_update_date = sysdate,
1336: -- that especially for it alone.
1337: update mtl_transactions_interface mti
1338: set last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: last_update_login = fnd_global.login_id,
1341: program_application_id = fnd_global.prog_appl_id,
1342: program_id = fnd_global.conc_program_id,
1343: program_update_date = sysdate,
1344: request_id = fnd_global.conc_request_id,
1337: update mtl_transactions_interface mti
1338: set last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: last_update_login = fnd_global.login_id,
1341: program_application_id = fnd_global.prog_appl_id,
1342: program_id = fnd_global.conc_program_id,
1343: program_update_date = sysdate,
1344: request_id = fnd_global.conc_request_id,
1345: revision = (select nvl(mti.revision, max(mir.revision))
1338: set last_update_date = sysdate,
1339: last_updated_by = fnd_global.user_id,
1340: last_update_login = fnd_global.login_id,
1341: program_application_id = fnd_global.prog_appl_id,
1342: program_id = fnd_global.conc_program_id,
1343: program_update_date = sysdate,
1344: request_id = fnd_global.conc_request_id,
1345: revision = (select nvl(mti.revision, max(mir.revision))
1346: from mtl_item_revisions mir
1340: last_update_login = fnd_global.login_id,
1341: program_application_id = fnd_global.prog_appl_id,
1342: program_id = fnd_global.conc_program_id,
1343: program_update_date = sysdate,
1344: request_id = fnd_global.conc_request_id,
1345: revision = (select nvl(mti.revision, max(mir.revision))
1346: from mtl_item_revisions mir
1347: where mir.organization_id = mti.organization_id
1348: and mir.inventory_item_id = mti.inventory_item_id
1377: fnd_message.set_name('WIP', 'INV_INT_REVCODE');
1378: l_errMsg := substrb(fnd_message.get, 1, 240);
1379: update mtl_transactions_interface mti
1380: set last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id,
1383: program_application_id = fnd_global.prog_appl_id,
1384: program_id = fnd_global.conc_program_id,
1385: program_update_date = sysdate,
1378: l_errMsg := substrb(fnd_message.get, 1, 240);
1379: update mtl_transactions_interface mti
1380: set last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id,
1383: program_application_id = fnd_global.prog_appl_id,
1384: program_id = fnd_global.conc_program_id,
1385: program_update_date = sysdate,
1386: request_id = fnd_global.conc_request_id,
1379: update mtl_transactions_interface mti
1380: set last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id,
1383: program_application_id = fnd_global.prog_appl_id,
1384: program_id = fnd_global.conc_program_id,
1385: program_update_date = sysdate,
1386: request_id = fnd_global.conc_request_id,
1387: process_flag = 3,
1380: set last_update_date = sysdate,
1381: last_updated_by = fnd_global.user_id,
1382: last_update_login = fnd_global.login_id,
1383: program_application_id = fnd_global.prog_appl_id,
1384: program_id = fnd_global.conc_program_id,
1385: program_update_date = sysdate,
1386: request_id = fnd_global.conc_request_id,
1387: process_flag = 3,
1388: lock_flag = 2,
1382: last_update_login = fnd_global.login_id,
1383: program_application_id = fnd_global.prog_appl_id,
1384: program_id = fnd_global.conc_program_id,
1385: program_update_date = sysdate,
1386: request_id = fnd_global.conc_request_id,
1387: process_flag = 3,
1388: lock_flag = 2,
1389: error_code = 'revision',
1390: error_explanation = l_errMsg
1454: fnd_message.set_token('ENTITY2', 'qty avail to complete');
1455: l_errMsg := substrb(fnd_message.get, 1, 240);
1456: update mtl_transactions_interface mti
1457: set last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: program_application_id = fnd_global.prog_appl_id,
1461: program_id = fnd_global.conc_program_id,
1462: program_update_date = sysdate,
1455: l_errMsg := substrb(fnd_message.get, 1, 240);
1456: update mtl_transactions_interface mti
1457: set last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: program_application_id = fnd_global.prog_appl_id,
1461: program_id = fnd_global.conc_program_id,
1462: program_update_date = sysdate,
1463: request_id = fnd_global.conc_request_id,
1456: update mtl_transactions_interface mti
1457: set last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: program_application_id = fnd_global.prog_appl_id,
1461: program_id = fnd_global.conc_program_id,
1462: program_update_date = sysdate,
1463: request_id = fnd_global.conc_request_id,
1464: process_flag = 3,
1457: set last_update_date = sysdate,
1458: last_updated_by = fnd_global.user_id,
1459: last_update_login = fnd_global.login_id,
1460: program_application_id = fnd_global.prog_appl_id,
1461: program_id = fnd_global.conc_program_id,
1462: program_update_date = sysdate,
1463: request_id = fnd_global.conc_request_id,
1464: process_flag = 3,
1465: lock_flag = 2,
1459: last_update_login = fnd_global.login_id,
1460: program_application_id = fnd_global.prog_appl_id,
1461: program_id = fnd_global.conc_program_id,
1462: program_update_date = sysdate,
1463: request_id = fnd_global.conc_request_id,
1464: process_flag = 3,
1465: lock_flag = 2,
1466: error_code = 'transaction_quantity',
1467: error_explanation = l_errMsg
1498: fnd_message.set_token('ENTITY2', 'job compelete quantity');
1499: l_errMsg := substrb(fnd_message.get, 1, 240);
1500: update mtl_transactions_interface mti
1501: set last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id,
1504: program_application_id = fnd_global.prog_appl_id,
1505: program_id = fnd_global.conc_program_id,
1506: program_update_date = sysdate,
1499: l_errMsg := substrb(fnd_message.get, 1, 240);
1500: update mtl_transactions_interface mti
1501: set last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id,
1504: program_application_id = fnd_global.prog_appl_id,
1505: program_id = fnd_global.conc_program_id,
1506: program_update_date = sysdate,
1507: request_id = fnd_global.conc_request_id,
1500: update mtl_transactions_interface mti
1501: set last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id,
1504: program_application_id = fnd_global.prog_appl_id,
1505: program_id = fnd_global.conc_program_id,
1506: program_update_date = sysdate,
1507: request_id = fnd_global.conc_request_id,
1508: process_flag = 3,
1501: set last_update_date = sysdate,
1502: last_updated_by = fnd_global.user_id,
1503: last_update_login = fnd_global.login_id,
1504: program_application_id = fnd_global.prog_appl_id,
1505: program_id = fnd_global.conc_program_id,
1506: program_update_date = sysdate,
1507: request_id = fnd_global.conc_request_id,
1508: process_flag = 3,
1509: lock_flag = 2,
1503: last_update_login = fnd_global.login_id,
1504: program_application_id = fnd_global.prog_appl_id,
1505: program_id = fnd_global.conc_program_id,
1506: program_update_date = sysdate,
1507: request_id = fnd_global.conc_request_id,
1508: process_flag = 3,
1509: lock_flag = 2,
1510: error_code = 'transaction_quantity',
1511: error_explanation = l_errMsg
1531: fnd_message.set_name('WIP', 'WIP_NO_ASSET_ITEM_MOVE');
1532: l_errMsg := substrb(fnd_message.get, 1, 240);
1533: update mtl_transactions_interface mti
1534: set last_update_date = sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id,
1537: program_application_id = fnd_global.prog_appl_id,
1538: program_id = fnd_global.conc_program_id,
1539: program_update_date = sysdate,
1532: l_errMsg := substrb(fnd_message.get, 1, 240);
1533: update mtl_transactions_interface mti
1534: set last_update_date = sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id,
1537: program_application_id = fnd_global.prog_appl_id,
1538: program_id = fnd_global.conc_program_id,
1539: program_update_date = sysdate,
1540: request_id = fnd_global.conc_request_id,
1533: update mtl_transactions_interface mti
1534: set last_update_date = sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id,
1537: program_application_id = fnd_global.prog_appl_id,
1538: program_id = fnd_global.conc_program_id,
1539: program_update_date = sysdate,
1540: request_id = fnd_global.conc_request_id,
1541: process_flag = 3,
1534: set last_update_date = sysdate,
1535: last_updated_by = fnd_global.user_id,
1536: last_update_login = fnd_global.login_id,
1537: program_application_id = fnd_global.prog_appl_id,
1538: program_id = fnd_global.conc_program_id,
1539: program_update_date = sysdate,
1540: request_id = fnd_global.conc_request_id,
1541: process_flag = 3,
1542: lock_flag = 2,
1536: last_update_login = fnd_global.login_id,
1537: program_application_id = fnd_global.prog_appl_id,
1538: program_id = fnd_global.conc_program_id,
1539: program_update_date = sysdate,
1540: request_id = fnd_global.conc_request_id,
1541: process_flag = 3,
1542: lock_flag = 2,
1543: error_code = 'subinventory_code',
1544: error_explanation = l_errMsg
1571: fnd_message.set_name('WIP', 'WIP_RELEASE_DATE');
1572: l_errMsg := substrb(fnd_message.get, 1, 240);
1573: update mtl_transactions_interface mti
1574: set last_update_date = sysdate,
1575: last_updated_by = fnd_global.user_id,
1576: last_update_login = fnd_global.login_id,
1577: program_application_id = fnd_global.prog_appl_id,
1578: program_id = fnd_global.conc_program_id,
1579: program_update_date = sysdate,
1572: l_errMsg := substrb(fnd_message.get, 1, 240);
1573: update mtl_transactions_interface mti
1574: set last_update_date = sysdate,
1575: last_updated_by = fnd_global.user_id,
1576: last_update_login = fnd_global.login_id,
1577: program_application_id = fnd_global.prog_appl_id,
1578: program_id = fnd_global.conc_program_id,
1579: program_update_date = sysdate,
1580: request_id = fnd_global.conc_request_id,
1573: update mtl_transactions_interface mti
1574: set last_update_date = sysdate,
1575: last_updated_by = fnd_global.user_id,
1576: last_update_login = fnd_global.login_id,
1577: program_application_id = fnd_global.prog_appl_id,
1578: program_id = fnd_global.conc_program_id,
1579: program_update_date = sysdate,
1580: request_id = fnd_global.conc_request_id,
1581: process_flag = 3,
1574: set last_update_date = sysdate,
1575: last_updated_by = fnd_global.user_id,
1576: last_update_login = fnd_global.login_id,
1577: program_application_id = fnd_global.prog_appl_id,
1578: program_id = fnd_global.conc_program_id,
1579: program_update_date = sysdate,
1580: request_id = fnd_global.conc_request_id,
1581: process_flag = 3,
1582: lock_flag = 2,
1576: last_update_login = fnd_global.login_id,
1577: program_application_id = fnd_global.prog_appl_id,
1578: program_id = fnd_global.conc_program_id,
1579: program_update_date = sysdate,
1580: request_id = fnd_global.conc_request_id,
1581: process_flag = 3,
1582: lock_flag = 2,
1583: error_code = 'transaction_date',
1584: error_explanation = l_errMsg
1607: fnd_message.set_name('WIP', 'WIP_INVALID_SO');
1608: l_errMsg := substrb(fnd_message.get, 1, 240);
1609: update mtl_transactions_interface mti
1610: set last_update_date = sysdate,
1611: last_updated_by = fnd_global.user_id,
1612: last_update_login = fnd_global.login_id,
1613: program_application_id = fnd_global.prog_appl_id,
1614: program_id = fnd_global.conc_program_id,
1615: program_update_date = sysdate,
1608: l_errMsg := substrb(fnd_message.get, 1, 240);
1609: update mtl_transactions_interface mti
1610: set last_update_date = sysdate,
1611: last_updated_by = fnd_global.user_id,
1612: last_update_login = fnd_global.login_id,
1613: program_application_id = fnd_global.prog_appl_id,
1614: program_id = fnd_global.conc_program_id,
1615: program_update_date = sysdate,
1616: request_id = fnd_global.conc_request_id,
1609: update mtl_transactions_interface mti
1610: set last_update_date = sysdate,
1611: last_updated_by = fnd_global.user_id,
1612: last_update_login = fnd_global.login_id,
1613: program_application_id = fnd_global.prog_appl_id,
1614: program_id = fnd_global.conc_program_id,
1615: program_update_date = sysdate,
1616: request_id = fnd_global.conc_request_id,
1617: process_flag = 3,
1610: set last_update_date = sysdate,
1611: last_updated_by = fnd_global.user_id,
1612: last_update_login = fnd_global.login_id,
1613: program_application_id = fnd_global.prog_appl_id,
1614: program_id = fnd_global.conc_program_id,
1615: program_update_date = sysdate,
1616: request_id = fnd_global.conc_request_id,
1617: process_flag = 3,
1618: lock_flag = 2,
1612: last_update_login = fnd_global.login_id,
1613: program_application_id = fnd_global.prog_appl_id,
1614: program_id = fnd_global.conc_program_id,
1615: program_update_date = sysdate,
1616: request_id = fnd_global.conc_request_id,
1617: process_flag = 3,
1618: lock_flag = 2,
1619: error_code = 'demand_source_header_id',
1620: error_explanation = l_errMsg
1644: fnd_message.set_name('WIP', 'WIP_INVALID_SO_LINE');
1645: l_errMsg := substrb(fnd_message.get, 1, 240);
1646: update mtl_transactions_interface mti
1647: set last_update_date = sysdate,
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,
1650: program_application_id = fnd_global.prog_appl_id,
1651: program_id = fnd_global.conc_program_id,
1652: program_update_date = sysdate,
1645: l_errMsg := substrb(fnd_message.get, 1, 240);
1646: update mtl_transactions_interface mti
1647: set last_update_date = sysdate,
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,
1650: program_application_id = fnd_global.prog_appl_id,
1651: program_id = fnd_global.conc_program_id,
1652: program_update_date = sysdate,
1653: request_id = fnd_global.conc_request_id,
1646: update mtl_transactions_interface mti
1647: set last_update_date = sysdate,
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,
1650: program_application_id = fnd_global.prog_appl_id,
1651: program_id = fnd_global.conc_program_id,
1652: program_update_date = sysdate,
1653: request_id = fnd_global.conc_request_id,
1654: process_flag = 3,
1647: set last_update_date = sysdate,
1648: last_updated_by = fnd_global.user_id,
1649: last_update_login = fnd_global.login_id,
1650: program_application_id = fnd_global.prog_appl_id,
1651: program_id = fnd_global.conc_program_id,
1652: program_update_date = sysdate,
1653: request_id = fnd_global.conc_request_id,
1654: process_flag = 3,
1655: lock_flag = 2,
1649: last_update_login = fnd_global.login_id,
1650: program_application_id = fnd_global.prog_appl_id,
1651: program_id = fnd_global.conc_program_id,
1652: program_update_date = sysdate,
1653: request_id = fnd_global.conc_request_id,
1654: process_flag = 3,
1655: lock_flag = 2,
1656: error_code = 'demand_source_line',
1657: error_explanation = l_errMsg
1685: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_COMP');
1686: l_errMsg := substrb(fnd_message.get, 1, 240);
1687: update mtl_transactions_interface mti
1688: set last_update_date = sysdate,
1689: last_updated_by = fnd_global.user_id,
1690: last_update_login = fnd_global.login_id,
1691: program_application_id = fnd_global.prog_appl_id,
1692: program_id = fnd_global.conc_program_id,
1693: program_update_date = sysdate,
1686: l_errMsg := substrb(fnd_message.get, 1, 240);
1687: update mtl_transactions_interface mti
1688: set last_update_date = sysdate,
1689: last_updated_by = fnd_global.user_id,
1690: last_update_login = fnd_global.login_id,
1691: program_application_id = fnd_global.prog_appl_id,
1692: program_id = fnd_global.conc_program_id,
1693: program_update_date = sysdate,
1694: request_id = fnd_global.conc_request_id,
1687: update mtl_transactions_interface mti
1688: set last_update_date = sysdate,
1689: last_updated_by = fnd_global.user_id,
1690: last_update_login = fnd_global.login_id,
1691: program_application_id = fnd_global.prog_appl_id,
1692: program_id = fnd_global.conc_program_id,
1693: program_update_date = sysdate,
1694: request_id = fnd_global.conc_request_id,
1695: process_flag = 3,
1688: set last_update_date = sysdate,
1689: last_updated_by = fnd_global.user_id,
1690: last_update_login = fnd_global.login_id,
1691: program_application_id = fnd_global.prog_appl_id,
1692: program_id = fnd_global.conc_program_id,
1693: program_update_date = sysdate,
1694: request_id = fnd_global.conc_request_id,
1695: process_flag = 3,
1696: lock_flag = 2,
1690: last_update_login = fnd_global.login_id,
1691: program_application_id = fnd_global.prog_appl_id,
1692: program_id = fnd_global.conc_program_id,
1693: program_update_date = sysdate,
1694: request_id = fnd_global.conc_request_id,
1695: process_flag = 3,
1696: lock_flag = 2,
1697: error_code = 'demand_source_delivery',
1698: error_explanation = l_errMsg
1722: fnd_message.set_name('WIP', 'WIP_INVALID_SO_SHIPNO_RET');
1723: l_errMsg := substrb(fnd_message.get, 1, 240);
1724: update mtl_transactions_interface mti
1725: set last_update_date = sysdate,
1726: last_updated_by = fnd_global.user_id,
1727: last_update_login = fnd_global.login_id,
1728: program_application_id = fnd_global.prog_appl_id,
1729: program_id = fnd_global.conc_program_id,
1730: program_update_date = sysdate,
1723: l_errMsg := substrb(fnd_message.get, 1, 240);
1724: update mtl_transactions_interface mti
1725: set last_update_date = sysdate,
1726: last_updated_by = fnd_global.user_id,
1727: last_update_login = fnd_global.login_id,
1728: program_application_id = fnd_global.prog_appl_id,
1729: program_id = fnd_global.conc_program_id,
1730: program_update_date = sysdate,
1731: request_id = fnd_global.conc_request_id,
1724: update mtl_transactions_interface mti
1725: set last_update_date = sysdate,
1726: last_updated_by = fnd_global.user_id,
1727: last_update_login = fnd_global.login_id,
1728: program_application_id = fnd_global.prog_appl_id,
1729: program_id = fnd_global.conc_program_id,
1730: program_update_date = sysdate,
1731: request_id = fnd_global.conc_request_id,
1732: process_flag = 3,
1725: set last_update_date = sysdate,
1726: last_updated_by = fnd_global.user_id,
1727: last_update_login = fnd_global.login_id,
1728: program_application_id = fnd_global.prog_appl_id,
1729: program_id = fnd_global.conc_program_id,
1730: program_update_date = sysdate,
1731: request_id = fnd_global.conc_request_id,
1732: process_flag = 3,
1733: lock_flag = 2,
1727: last_update_login = fnd_global.login_id,
1728: program_application_id = fnd_global.prog_appl_id,
1729: program_id = fnd_global.conc_program_id,
1730: program_update_date = sysdate,
1731: request_id = fnd_global.conc_request_id,
1732: process_flag = 3,
1733: lock_flag = 2,
1734: error_code = 'demand_source_delivery',
1735: error_explanation = l_errMsg
1762: fnd_message.set_name('WIP', 'WIP_KB_ILLEGAL_CARD');
1763: l_errMsg := substrb(fnd_message.get, 1, 240);
1764: update mtl_transactions_interface mti
1765: set last_update_date = sysdate,
1766: last_updated_by = fnd_global.user_id,
1767: last_update_login = fnd_global.login_id,
1768: program_application_id = fnd_global.prog_appl_id,
1769: program_id = fnd_global.conc_program_id,
1770: program_update_date = sysdate,
1763: l_errMsg := substrb(fnd_message.get, 1, 240);
1764: update mtl_transactions_interface mti
1765: set last_update_date = sysdate,
1766: last_updated_by = fnd_global.user_id,
1767: last_update_login = fnd_global.login_id,
1768: program_application_id = fnd_global.prog_appl_id,
1769: program_id = fnd_global.conc_program_id,
1770: program_update_date = sysdate,
1771: request_id = fnd_global.conc_request_id,
1764: update mtl_transactions_interface mti
1765: set last_update_date = sysdate,
1766: last_updated_by = fnd_global.user_id,
1767: last_update_login = fnd_global.login_id,
1768: program_application_id = fnd_global.prog_appl_id,
1769: program_id = fnd_global.conc_program_id,
1770: program_update_date = sysdate,
1771: request_id = fnd_global.conc_request_id,
1772: process_flag = 3,
1765: set last_update_date = sysdate,
1766: last_updated_by = fnd_global.user_id,
1767: last_update_login = fnd_global.login_id,
1768: program_application_id = fnd_global.prog_appl_id,
1769: program_id = fnd_global.conc_program_id,
1770: program_update_date = sysdate,
1771: request_id = fnd_global.conc_request_id,
1772: process_flag = 3,
1773: lock_flag = 2,
1767: last_update_login = fnd_global.login_id,
1768: program_application_id = fnd_global.prog_appl_id,
1769: program_id = fnd_global.conc_program_id,
1770: program_update_date = sysdate,
1771: request_id = fnd_global.conc_request_id,
1772: process_flag = 3,
1773: lock_flag = 2,
1774: error_code = 'kanban_card',
1775: error_explanation = l_errMsg
1789: fnd_message.set_name('WIP', 'WIP_KB_CPL_SUB_LOC_MISMATCH');
1790: l_errMsg := substrb(fnd_message.get, 1, 240);
1791: update mtl_transactions_interface mti
1792: set last_update_date = sysdate,
1793: last_updated_by = fnd_global.user_id,
1794: last_update_login = fnd_global.login_id,
1795: program_application_id = fnd_global.prog_appl_id,
1796: program_id = fnd_global.conc_program_id,
1797: program_update_date = sysdate,
1790: l_errMsg := substrb(fnd_message.get, 1, 240);
1791: update mtl_transactions_interface mti
1792: set last_update_date = sysdate,
1793: last_updated_by = fnd_global.user_id,
1794: last_update_login = fnd_global.login_id,
1795: program_application_id = fnd_global.prog_appl_id,
1796: program_id = fnd_global.conc_program_id,
1797: program_update_date = sysdate,
1798: request_id = fnd_global.conc_request_id,
1791: update mtl_transactions_interface mti
1792: set last_update_date = sysdate,
1793: last_updated_by = fnd_global.user_id,
1794: last_update_login = fnd_global.login_id,
1795: program_application_id = fnd_global.prog_appl_id,
1796: program_id = fnd_global.conc_program_id,
1797: program_update_date = sysdate,
1798: request_id = fnd_global.conc_request_id,
1799: process_flag = 3,
1792: set last_update_date = sysdate,
1793: last_updated_by = fnd_global.user_id,
1794: last_update_login = fnd_global.login_id,
1795: program_application_id = fnd_global.prog_appl_id,
1796: program_id = fnd_global.conc_program_id,
1797: program_update_date = sysdate,
1798: request_id = fnd_global.conc_request_id,
1799: process_flag = 3,
1800: lock_flag = 2,
1794: last_update_login = fnd_global.login_id,
1795: program_application_id = fnd_global.prog_appl_id,
1796: program_id = fnd_global.conc_program_id,
1797: program_update_date = sysdate,
1798: request_id = fnd_global.conc_request_id,
1799: process_flag = 3,
1800: lock_flag = 2,
1801: error_code = 'kanban_card',
1802: error_explanation = l_errMsg
1820: fnd_message.set_name('WIP', 'WIP_KB_CPL_STATUS_ILLEGAL');
1821: l_errMsg := substrb(fnd_message.get, 1, 240);
1822: update mtl_transactions_interface mti
1823: set last_update_date = sysdate,
1824: last_updated_by = fnd_global.user_id,
1825: last_update_login = fnd_global.login_id,
1826: program_application_id = fnd_global.prog_appl_id,
1827: program_id = fnd_global.conc_program_id,
1828: program_update_date = sysdate,
1821: l_errMsg := substrb(fnd_message.get, 1, 240);
1822: update mtl_transactions_interface mti
1823: set last_update_date = sysdate,
1824: last_updated_by = fnd_global.user_id,
1825: last_update_login = fnd_global.login_id,
1826: program_application_id = fnd_global.prog_appl_id,
1827: program_id = fnd_global.conc_program_id,
1828: program_update_date = sysdate,
1829: request_id = fnd_global.conc_request_id,
1822: update mtl_transactions_interface mti
1823: set last_update_date = sysdate,
1824: last_updated_by = fnd_global.user_id,
1825: last_update_login = fnd_global.login_id,
1826: program_application_id = fnd_global.prog_appl_id,
1827: program_id = fnd_global.conc_program_id,
1828: program_update_date = sysdate,
1829: request_id = fnd_global.conc_request_id,
1830: process_flag = 3,
1823: set last_update_date = sysdate,
1824: last_updated_by = fnd_global.user_id,
1825: last_update_login = fnd_global.login_id,
1826: program_application_id = fnd_global.prog_appl_id,
1827: program_id = fnd_global.conc_program_id,
1828: program_update_date = sysdate,
1829: request_id = fnd_global.conc_request_id,
1830: process_flag = 3,
1831: lock_flag = 2,
1825: last_update_login = fnd_global.login_id,
1826: program_application_id = fnd_global.prog_appl_id,
1827: program_id = fnd_global.conc_program_id,
1828: program_update_date = sysdate,
1829: request_id = fnd_global.conc_request_id,
1830: process_flag = 3,
1831: lock_flag = 2,
1832: error_code = 'kanban_card',
1833: error_explanation = l_errMsg
1855: fnd_message.set_name('WIP', 'WIP_INVALID_NEG_REQ_FLAG');
1856: l_errMsg := substrb(fnd_message.get, 1, 240);
1857: update mtl_transactions_interface mti
1858: set last_update_date = sysdate,
1859: last_updated_by = fnd_global.user_id,
1860: last_update_login = fnd_global.login_id,
1861: program_application_id = fnd_global.prog_appl_id,
1862: program_id = fnd_global.conc_program_id,
1863: program_update_date = sysdate,
1856: l_errMsg := substrb(fnd_message.get, 1, 240);
1857: update mtl_transactions_interface mti
1858: set last_update_date = sysdate,
1859: last_updated_by = fnd_global.user_id,
1860: last_update_login = fnd_global.login_id,
1861: program_application_id = fnd_global.prog_appl_id,
1862: program_id = fnd_global.conc_program_id,
1863: program_update_date = sysdate,
1864: request_id = fnd_global.conc_request_id,
1857: update mtl_transactions_interface mti
1858: set last_update_date = sysdate,
1859: last_updated_by = fnd_global.user_id,
1860: last_update_login = fnd_global.login_id,
1861: program_application_id = fnd_global.prog_appl_id,
1862: program_id = fnd_global.conc_program_id,
1863: program_update_date = sysdate,
1864: request_id = fnd_global.conc_request_id,
1865: process_flag = 3,
1858: set last_update_date = sysdate,
1859: last_updated_by = fnd_global.user_id,
1860: last_update_login = fnd_global.login_id,
1861: program_application_id = fnd_global.prog_appl_id,
1862: program_id = fnd_global.conc_program_id,
1863: program_update_date = sysdate,
1864: request_id = fnd_global.conc_request_id,
1865: process_flag = 3,
1866: lock_flag = 2,
1860: last_update_login = fnd_global.login_id,
1861: program_application_id = fnd_global.prog_appl_id,
1862: program_id = fnd_global.conc_program_id,
1863: program_update_date = sysdate,
1864: request_id = fnd_global.conc_request_id,
1865: process_flag = 3,
1866: lock_flag = 2,
1867: error_code = 'negative_req_flag',
1868: error_explanation = l_errMsg
1884: fnd_message.set_name('WIP', 'WIP_NO_SERIALIZED_JOB_ALLOW');
1885: l_errMsg := substrb(fnd_message.get, 1, 240);
1886: update mtl_transactions_interface mti
1887: set last_update_date = sysdate,
1888: last_updated_by = fnd_global.user_id,
1889: last_update_login = fnd_global.login_id,
1890: program_application_id = fnd_global.prog_appl_id,
1891: program_id = fnd_global.conc_program_id,
1892: program_update_date = sysdate,
1885: l_errMsg := substrb(fnd_message.get, 1, 240);
1886: update mtl_transactions_interface mti
1887: set last_update_date = sysdate,
1888: last_updated_by = fnd_global.user_id,
1889: last_update_login = fnd_global.login_id,
1890: program_application_id = fnd_global.prog_appl_id,
1891: program_id = fnd_global.conc_program_id,
1892: program_update_date = sysdate,
1893: request_id = fnd_global.conc_request_id,
1886: update mtl_transactions_interface mti
1887: set last_update_date = sysdate,
1888: last_updated_by = fnd_global.user_id,
1889: last_update_login = fnd_global.login_id,
1890: program_application_id = fnd_global.prog_appl_id,
1891: program_id = fnd_global.conc_program_id,
1892: program_update_date = sysdate,
1893: request_id = fnd_global.conc_request_id,
1894: process_flag = 3,
1887: set last_update_date = sysdate,
1888: last_updated_by = fnd_global.user_id,
1889: last_update_login = fnd_global.login_id,
1890: program_application_id = fnd_global.prog_appl_id,
1891: program_id = fnd_global.conc_program_id,
1892: program_update_date = sysdate,
1893: request_id = fnd_global.conc_request_id,
1894: process_flag = 3,
1895: lock_flag = 2,
1889: last_update_login = fnd_global.login_id,
1890: program_application_id = fnd_global.prog_appl_id,
1891: program_id = fnd_global.conc_program_id,
1892: program_update_date = sysdate,
1893: request_id = fnd_global.conc_request_id,
1894: process_flag = 3,
1895: lock_flag = 2,
1896: error_code = 'transaction_source_id',
1897: error_explanation = l_errMsg
1914: --for assy completions and returns, project/task must match
1915: --source project/task
1916: update mtl_transactions_interface mti
1917: set last_update_date = sysdate,
1918: last_updated_by = fnd_global.user_id,
1919: last_update_login = fnd_global.login_id,
1920: program_application_id = fnd_global.prog_appl_id,
1921: program_id = fnd_global.conc_program_id,
1922: program_update_date = sysdate,
1915: --source project/task
1916: update mtl_transactions_interface mti
1917: set last_update_date = sysdate,
1918: last_updated_by = fnd_global.user_id,
1919: last_update_login = fnd_global.login_id,
1920: program_application_id = fnd_global.prog_appl_id,
1921: program_id = fnd_global.conc_program_id,
1922: program_update_date = sysdate,
1923: request_id = fnd_global.conc_request_id,
1916: update mtl_transactions_interface mti
1917: set last_update_date = sysdate,
1918: last_updated_by = fnd_global.user_id,
1919: last_update_login = fnd_global.login_id,
1920: program_application_id = fnd_global.prog_appl_id,
1921: program_id = fnd_global.conc_program_id,
1922: program_update_date = sysdate,
1923: request_id = fnd_global.conc_request_id,
1924: project_id = source_project_id,
1917: set last_update_date = sysdate,
1918: last_updated_by = fnd_global.user_id,
1919: last_update_login = fnd_global.login_id,
1920: program_application_id = fnd_global.prog_appl_id,
1921: program_id = fnd_global.conc_program_id,
1922: program_update_date = sysdate,
1923: request_id = fnd_global.conc_request_id,
1924: project_id = source_project_id,
1925: task_id = source_task_id
1919: last_update_login = fnd_global.login_id,
1920: program_application_id = fnd_global.prog_appl_id,
1921: program_id = fnd_global.conc_program_id,
1922: program_update_date = sysdate,
1923: request_id = fnd_global.conc_request_id,
1924: project_id = source_project_id,
1925: task_id = source_task_id
1926: where transaction_header_id = p_txnHeaderID
1927: and process_flag = 1
1999: x_returnStatus => l_returnStatus); --discard logging return status
2000: end if;
2001: update mtl_transactions_interface
2002: set last_update_date = sysdate,
2003: last_updated_by = fnd_global.user_id,
2004: last_update_login = fnd_global.login_id,
2005: program_application_id = fnd_global.prog_appl_id,
2006: program_id = fnd_global.conc_program_id,
2007: program_update_date = sysdate,
2000: end if;
2001: update mtl_transactions_interface
2002: set last_update_date = sysdate,
2003: last_updated_by = fnd_global.user_id,
2004: last_update_login = fnd_global.login_id,
2005: program_application_id = fnd_global.prog_appl_id,
2006: program_id = fnd_global.conc_program_id,
2007: program_update_date = sysdate,
2008: request_id = fnd_global.conc_request_id,
2001: update mtl_transactions_interface
2002: set last_update_date = sysdate,
2003: last_updated_by = fnd_global.user_id,
2004: last_update_login = fnd_global.login_id,
2005: program_application_id = fnd_global.prog_appl_id,
2006: program_id = fnd_global.conc_program_id,
2007: program_update_date = sysdate,
2008: request_id = fnd_global.conc_request_id,
2009: process_flag = 3,
2002: set last_update_date = sysdate,
2003: last_updated_by = fnd_global.user_id,
2004: last_update_login = fnd_global.login_id,
2005: program_application_id = fnd_global.prog_appl_id,
2006: program_id = fnd_global.conc_program_id,
2007: program_update_date = sysdate,
2008: request_id = fnd_global.conc_request_id,
2009: process_flag = 3,
2010: lock_flag = 2
2004: last_update_login = fnd_global.login_id,
2005: program_application_id = fnd_global.prog_appl_id,
2006: program_id = fnd_global.conc_program_id,
2007: program_update_date = sysdate,
2008: request_id = fnd_global.conc_request_id,
2009: process_flag = 3,
2010: lock_flag = 2
2011: where transaction_header_id = p_txnHeaderID;
2012: end postInvWIPValidation;
2022:
2023: begin
2024: update mtl_transactions_interface
2025: set last_update_date = sysdate,
2026: last_updated_by = fnd_global.user_id,
2027: last_update_login = fnd_global.login_id,
2028: program_application_id = fnd_global.prog_appl_id,
2029: program_id = fnd_global.conc_program_id,
2030: program_update_date = sysdate,
2023: begin
2024: update mtl_transactions_interface
2025: set last_update_date = sysdate,
2026: last_updated_by = fnd_global.user_id,
2027: last_update_login = fnd_global.login_id,
2028: program_application_id = fnd_global.prog_appl_id,
2029: program_id = fnd_global.conc_program_id,
2030: program_update_date = sysdate,
2031: request_id = fnd_global.conc_request_id,
2024: update mtl_transactions_interface
2025: set last_update_date = sysdate,
2026: last_updated_by = fnd_global.user_id,
2027: last_update_login = fnd_global.login_id,
2028: program_application_id = fnd_global.prog_appl_id,
2029: program_id = fnd_global.conc_program_id,
2030: program_update_date = sysdate,
2031: request_id = fnd_global.conc_request_id,
2032: process_flag = 3,
2025: set last_update_date = sysdate,
2026: last_updated_by = fnd_global.user_id,
2027: last_update_login = fnd_global.login_id,
2028: program_application_id = fnd_global.prog_appl_id,
2029: program_id = fnd_global.conc_program_id,
2030: program_update_date = sysdate,
2031: request_id = fnd_global.conc_request_id,
2032: process_flag = 3,
2033: lock_flag = 2,
2027: last_update_login = fnd_global.login_id,
2028: program_application_id = fnd_global.prog_appl_id,
2029: program_id = fnd_global.conc_program_id,
2030: program_update_date = sysdate,
2031: request_id = fnd_global.conc_request_id,
2032: process_flag = 3,
2033: lock_flag = 2,
2034: error_code = substrb(p_errCode, 1, 240),
2035: error_explanation = substrb(p_msgData, 1, 240)
2112: -- we need that for the logic that follows. Even though inv validation does
2113: -- the deriviation, we still needs to do that since we call inv afterwards.
2114: update mtl_transactions_interface mti
2115: set last_update_date = sysdate,
2116: last_updated_by = fnd_global.user_id,
2117: last_update_login = fnd_global.login_id,
2118: program_application_id = fnd_global.prog_appl_id,
2119: program_id = fnd_global.conc_program_id,
2120: program_update_date = sysdate,
2113: -- the deriviation, we still needs to do that since we call inv afterwards.
2114: update mtl_transactions_interface mti
2115: set last_update_date = sysdate,
2116: last_updated_by = fnd_global.user_id,
2117: last_update_login = fnd_global.login_id,
2118: program_application_id = fnd_global.prog_appl_id,
2119: program_id = fnd_global.conc_program_id,
2120: program_update_date = sysdate,
2121: request_id = fnd_global.conc_request_id,
2114: update mtl_transactions_interface mti
2115: set last_update_date = sysdate,
2116: last_updated_by = fnd_global.user_id,
2117: last_update_login = fnd_global.login_id,
2118: program_application_id = fnd_global.prog_appl_id,
2119: program_id = fnd_global.conc_program_id,
2120: program_update_date = sysdate,
2121: request_id = fnd_global.conc_request_id,
2122: transaction_action_id = (select mtt.transaction_action_id
2115: set last_update_date = sysdate,
2116: last_updated_by = fnd_global.user_id,
2117: last_update_login = fnd_global.login_id,
2118: program_application_id = fnd_global.prog_appl_id,
2119: program_id = fnd_global.conc_program_id,
2120: program_update_date = sysdate,
2121: request_id = fnd_global.conc_request_id,
2122: transaction_action_id = (select mtt.transaction_action_id
2123: from mtl_transaction_types mtt
2117: last_update_login = fnd_global.login_id,
2118: program_application_id = fnd_global.prog_appl_id,
2119: program_id = fnd_global.conc_program_id,
2120: program_update_date = sysdate,
2121: request_id = fnd_global.conc_request_id,
2122: transaction_action_id = (select mtt.transaction_action_id
2123: from mtl_transaction_types mtt
2124: where mtt.transaction_type_id =
2125: mti.transaction_type_id),
2163: fnd_message.set_name('INV', 'INV_INT_ORGEXP');
2164: l_errMsg := substrb(fnd_message.get, 1, 240);
2165: update mtl_transactions_interface mti
2166: set last_update_date = sysdate,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id,
2169: program_application_id = fnd_global.prog_appl_id,
2170: program_id = fnd_global.conc_program_id,
2171: program_update_date = sysdate,
2164: l_errMsg := substrb(fnd_message.get, 1, 240);
2165: update mtl_transactions_interface mti
2166: set last_update_date = sysdate,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id,
2169: program_application_id = fnd_global.prog_appl_id,
2170: program_id = fnd_global.conc_program_id,
2171: program_update_date = sysdate,
2172: request_id = fnd_global.conc_request_id,
2165: update mtl_transactions_interface mti
2166: set last_update_date = sysdate,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id,
2169: program_application_id = fnd_global.prog_appl_id,
2170: program_id = fnd_global.conc_program_id,
2171: program_update_date = sysdate,
2172: request_id = fnd_global.conc_request_id,
2173: process_flag = 3,
2166: set last_update_date = sysdate,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id,
2169: program_application_id = fnd_global.prog_appl_id,
2170: program_id = fnd_global.conc_program_id,
2171: program_update_date = sysdate,
2172: request_id = fnd_global.conc_request_id,
2173: process_flag = 3,
2174: lock_flag = 2,
2168: last_update_login = fnd_global.login_id,
2169: program_application_id = fnd_global.prog_appl_id,
2170: program_id = fnd_global.conc_program_id,
2171: program_update_date = sysdate,
2172: request_id = fnd_global.conc_request_id,
2173: process_flag = 3,
2174: lock_flag = 2,
2175: error_code = l_errCode,
2176: error_explanation = l_errMsg
2187: fnd_message.set_name('WIP', 'WIP_INVALID_FLOW_SCHED_FLAG');
2188: l_errMsg := substrb(fnd_message.get, 1, 240);
2189: update mtl_transactions_interface mti
2190: set last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id,
2193: program_application_id = fnd_global.prog_appl_id,
2194: program_id = fnd_global.conc_program_id,
2195: program_update_date = sysdate,
2188: l_errMsg := substrb(fnd_message.get, 1, 240);
2189: update mtl_transactions_interface mti
2190: set last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id,
2193: program_application_id = fnd_global.prog_appl_id,
2194: program_id = fnd_global.conc_program_id,
2195: program_update_date = sysdate,
2196: request_id = fnd_global.conc_request_id,
2189: update mtl_transactions_interface mti
2190: set last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id,
2193: program_application_id = fnd_global.prog_appl_id,
2194: program_id = fnd_global.conc_program_id,
2195: program_update_date = sysdate,
2196: request_id = fnd_global.conc_request_id,
2197: process_flag = 3,
2190: set last_update_date = sysdate,
2191: last_updated_by = fnd_global.user_id,
2192: last_update_login = fnd_global.login_id,
2193: program_application_id = fnd_global.prog_appl_id,
2194: program_id = fnd_global.conc_program_id,
2195: program_update_date = sysdate,
2196: request_id = fnd_global.conc_request_id,
2197: process_flag = 3,
2198: lock_flag = 2,
2192: last_update_login = fnd_global.login_id,
2193: program_application_id = fnd_global.prog_appl_id,
2194: program_id = fnd_global.conc_program_id,
2195: program_update_date = sysdate,
2196: request_id = fnd_global.conc_request_id,
2197: process_flag = 3,
2198: lock_flag = 2,
2199: error_code = 'Invalid Scheduled Flag',
2200: error_explanation = l_errMsg
2214: fnd_message.set_token('ENTITY', 'transaction_source_name');
2215: l_errMsg := substrb(fnd_message.get, 1, 240);
2216: update mtl_transactions_interface mti
2217: set last_update_date = sysdate,
2218: last_updated_by = fnd_global.user_id,
2219: last_update_login = fnd_global.login_id,
2220: program_application_id = fnd_global.prog_appl_id,
2221: program_id = fnd_global.conc_program_id,
2222: program_update_date = sysdate,
2215: l_errMsg := substrb(fnd_message.get, 1, 240);
2216: update mtl_transactions_interface mti
2217: set last_update_date = sysdate,
2218: last_updated_by = fnd_global.user_id,
2219: last_update_login = fnd_global.login_id,
2220: program_application_id = fnd_global.prog_appl_id,
2221: program_id = fnd_global.conc_program_id,
2222: program_update_date = sysdate,
2223: request_id = fnd_global.conc_request_id,
2216: update mtl_transactions_interface mti
2217: set last_update_date = sysdate,
2218: last_updated_by = fnd_global.user_id,
2219: last_update_login = fnd_global.login_id,
2220: program_application_id = fnd_global.prog_appl_id,
2221: program_id = fnd_global.conc_program_id,
2222: program_update_date = sysdate,
2223: request_id = fnd_global.conc_request_id,
2224: process_flag = 3,
2217: set last_update_date = sysdate,
2218: last_updated_by = fnd_global.user_id,
2219: last_update_login = fnd_global.login_id,
2220: program_application_id = fnd_global.prog_appl_id,
2221: program_id = fnd_global.conc_program_id,
2222: program_update_date = sysdate,
2223: request_id = fnd_global.conc_request_id,
2224: process_flag = 3,
2225: lock_flag = 2,
2219: last_update_login = fnd_global.login_id,
2220: program_application_id = fnd_global.prog_appl_id,
2221: program_id = fnd_global.conc_program_id,
2222: program_update_date = sysdate,
2223: request_id = fnd_global.conc_request_id,
2224: process_flag = 3,
2225: lock_flag = 2,
2226: error_code = 'transaction_source_name',
2227: error_explanation = l_errMsg
2238:
2239: -- derive transaction source id from transaction source name
2240: update mtl_transactions_interface mti
2241: set last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id,
2246: program_update_date = sysdate,
2239: -- derive transaction source id from transaction source name
2240: update mtl_transactions_interface mti
2241: set last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id,
2246: program_update_date = sysdate,
2247: request_id = fnd_global.conc_request_id,
2240: update mtl_transactions_interface mti
2241: set last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id,
2246: program_update_date = sysdate,
2247: request_id = fnd_global.conc_request_id,
2248: transaction_source_id = (select we.wip_entity_id
2241: set last_update_date = sysdate,
2242: last_updated_by = fnd_global.user_id,
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id,
2246: program_update_date = sysdate,
2247: request_id = fnd_global.conc_request_id,
2248: transaction_source_id = (select we.wip_entity_id
2249: from wip_entities we
2243: last_update_login = fnd_global.login_id,
2244: program_application_id = fnd_global.prog_appl_id,
2245: program_id = fnd_global.conc_program_id,
2246: program_update_date = sysdate,
2247: request_id = fnd_global.conc_request_id,
2248: transaction_source_id = (select we.wip_entity_id
2249: from wip_entities we
2250: where we.organization_id = mti.organization_id
2251: and we.wip_entity_name = mti.transaction_source_name)
2262: fnd_message.set_name('INV', 'INV_INT_TRXACTEXP');
2263: l_errMsg := substrb(fnd_message.get, 1, 240);
2264: update mtl_transactions_interface mti
2265: set last_update_date = sysdate,
2266: last_updated_by = fnd_global.user_id,
2267: last_update_login = fnd_global.login_id,
2268: program_application_id = fnd_global.prog_appl_id,
2269: program_id = fnd_global.conc_program_id,
2270: program_update_date = sysdate,
2263: l_errMsg := substrb(fnd_message.get, 1, 240);
2264: update mtl_transactions_interface mti
2265: set last_update_date = sysdate,
2266: last_updated_by = fnd_global.user_id,
2267: last_update_login = fnd_global.login_id,
2268: program_application_id = fnd_global.prog_appl_id,
2269: program_id = fnd_global.conc_program_id,
2270: program_update_date = sysdate,
2271: request_id = fnd_global.conc_request_id,
2264: update mtl_transactions_interface mti
2265: set last_update_date = sysdate,
2266: last_updated_by = fnd_global.user_id,
2267: last_update_login = fnd_global.login_id,
2268: program_application_id = fnd_global.prog_appl_id,
2269: program_id = fnd_global.conc_program_id,
2270: program_update_date = sysdate,
2271: request_id = fnd_global.conc_request_id,
2272: process_flag = 3,
2265: set last_update_date = sysdate,
2266: last_updated_by = fnd_global.user_id,
2267: last_update_login = fnd_global.login_id,
2268: program_application_id = fnd_global.prog_appl_id,
2269: program_id = fnd_global.conc_program_id,
2270: program_update_date = sysdate,
2271: request_id = fnd_global.conc_request_id,
2272: process_flag = 3,
2273: lock_flag = 2,
2267: last_update_login = fnd_global.login_id,
2268: program_application_id = fnd_global.prog_appl_id,
2269: program_id = fnd_global.conc_program_id,
2270: program_update_date = sysdate,
2271: request_id = fnd_global.conc_request_id,
2272: process_flag = 3,
2273: lock_flag = 2,
2274: error_code = l_errCode,
2275: error_explanation = l_errMsg
2286: fnd_message.set_name('INV', 'INV_INT_SRCWIPEXP');
2287: l_errMsg := substrb(fnd_message.get, 1, 240);
2288: update mtl_transactions_interface mti
2289: set last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id,
2291: last_update_login = fnd_global.login_id,
2292: program_application_id = fnd_global.prog_appl_id,
2293: program_id = fnd_global.conc_program_id,
2294: program_update_date = sysdate,
2287: l_errMsg := substrb(fnd_message.get, 1, 240);
2288: update mtl_transactions_interface mti
2289: set last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id,
2291: last_update_login = fnd_global.login_id,
2292: program_application_id = fnd_global.prog_appl_id,
2293: program_id = fnd_global.conc_program_id,
2294: program_update_date = sysdate,
2295: request_id = fnd_global.conc_request_id,
2288: update mtl_transactions_interface mti
2289: set last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id,
2291: last_update_login = fnd_global.login_id,
2292: program_application_id = fnd_global.prog_appl_id,
2293: program_id = fnd_global.conc_program_id,
2294: program_update_date = sysdate,
2295: request_id = fnd_global.conc_request_id,
2296: process_flag = 3,
2289: set last_update_date = sysdate,
2290: last_updated_by = fnd_global.user_id,
2291: last_update_login = fnd_global.login_id,
2292: program_application_id = fnd_global.prog_appl_id,
2293: program_id = fnd_global.conc_program_id,
2294: program_update_date = sysdate,
2295: request_id = fnd_global.conc_request_id,
2296: process_flag = 3,
2297: lock_flag = 2,
2291: last_update_login = fnd_global.login_id,
2292: program_application_id = fnd_global.prog_appl_id,
2293: program_id = fnd_global.conc_program_id,
2294: program_update_date = sysdate,
2295: request_id = fnd_global.conc_request_id,
2296: process_flag = 3,
2297: lock_flag = 2,
2298: error_code = l_errCode,
2299: error_explanation = l_errMsg
2324: l_errMsg := substrb(fnd_message.get, 1, 240);
2325:
2326: update mtl_transactions_interface mti
2327: set last_update_date = sysdate,
2328: last_updated_by = fnd_global.user_id,
2329: last_update_login = fnd_global.login_id,
2330: program_application_id = fnd_global.prog_appl_id,
2331: program_id = fnd_global.conc_program_id,
2332: program_update_date = sysdate,
2325:
2326: update mtl_transactions_interface mti
2327: set last_update_date = sysdate,
2328: last_updated_by = fnd_global.user_id,
2329: last_update_login = fnd_global.login_id,
2330: program_application_id = fnd_global.prog_appl_id,
2331: program_id = fnd_global.conc_program_id,
2332: program_update_date = sysdate,
2333: request_id = fnd_global.conc_request_id,
2326: update mtl_transactions_interface mti
2327: set last_update_date = sysdate,
2328: last_updated_by = fnd_global.user_id,
2329: last_update_login = fnd_global.login_id,
2330: program_application_id = fnd_global.prog_appl_id,
2331: program_id = fnd_global.conc_program_id,
2332: program_update_date = sysdate,
2333: request_id = fnd_global.conc_request_id,
2334: process_flag = 3,
2327: set last_update_date = sysdate,
2328: last_updated_by = fnd_global.user_id,
2329: last_update_login = fnd_global.login_id,
2330: program_application_id = fnd_global.prog_appl_id,
2331: program_id = fnd_global.conc_program_id,
2332: program_update_date = sysdate,
2333: request_id = fnd_global.conc_request_id,
2334: process_flag = 3,
2335: lock_flag = 2,
2329: last_update_login = fnd_global.login_id,
2330: program_application_id = fnd_global.prog_appl_id,
2331: program_id = fnd_global.conc_program_id,
2332: program_update_date = sysdate,
2333: request_id = fnd_global.conc_request_id,
2334: process_flag = 3,
2335: lock_flag = 2,
2336: error_code = l_errCode,
2337: error_explanation = l_errMsg
2358: l_errMsg := substrb(fnd_message.get, 1, 240);
2359:
2360: update mtl_transactions_interface mti
2361: set last_update_date = sysdate,
2362: last_updated_by = fnd_global.user_id,
2363: last_update_login = fnd_global.login_id,
2364: program_application_id = fnd_global.prog_appl_id,
2365: program_id = fnd_global.conc_program_id,
2366: program_update_date = sysdate,
2359:
2360: update mtl_transactions_interface mti
2361: set last_update_date = sysdate,
2362: last_updated_by = fnd_global.user_id,
2363: last_update_login = fnd_global.login_id,
2364: program_application_id = fnd_global.prog_appl_id,
2365: program_id = fnd_global.conc_program_id,
2366: program_update_date = sysdate,
2367: request_id = fnd_global.conc_request_id,
2360: update mtl_transactions_interface mti
2361: set last_update_date = sysdate,
2362: last_updated_by = fnd_global.user_id,
2363: last_update_login = fnd_global.login_id,
2364: program_application_id = fnd_global.prog_appl_id,
2365: program_id = fnd_global.conc_program_id,
2366: program_update_date = sysdate,
2367: request_id = fnd_global.conc_request_id,
2368: process_flag = 3,
2361: set last_update_date = sysdate,
2362: last_updated_by = fnd_global.user_id,
2363: last_update_login = fnd_global.login_id,
2364: program_application_id = fnd_global.prog_appl_id,
2365: program_id = fnd_global.conc_program_id,
2366: program_update_date = sysdate,
2367: request_id = fnd_global.conc_request_id,
2368: process_flag = 3,
2369: lock_flag = 2,
2363: last_update_login = fnd_global.login_id,
2364: program_application_id = fnd_global.prog_appl_id,
2365: program_id = fnd_global.conc_program_id,
2366: program_update_date = sysdate,
2367: request_id = fnd_global.conc_request_id,
2368: process_flag = 3,
2369: lock_flag = 2,
2370: error_code = l_errCode,
2371: error_explanation = l_errMsg
2383:
2384: -- derive inventory item id if transaction source id is provided
2385: update mtl_transactions_interface mti
2386: set last_update_date = sysdate,
2387: last_updated_by = fnd_global.user_id,
2388: last_update_login = fnd_global.login_id,
2389: program_application_id = fnd_global.prog_appl_id,
2390: program_id = fnd_global.conc_program_id,
2391: program_update_date = sysdate,
2384: -- derive inventory item id if transaction source id is provided
2385: update mtl_transactions_interface mti
2386: set last_update_date = sysdate,
2387: last_updated_by = fnd_global.user_id,
2388: last_update_login = fnd_global.login_id,
2389: program_application_id = fnd_global.prog_appl_id,
2390: program_id = fnd_global.conc_program_id,
2391: program_update_date = sysdate,
2392: request_id = fnd_global.conc_request_id,
2385: update mtl_transactions_interface mti
2386: set last_update_date = sysdate,
2387: last_updated_by = fnd_global.user_id,
2388: last_update_login = fnd_global.login_id,
2389: program_application_id = fnd_global.prog_appl_id,
2390: program_id = fnd_global.conc_program_id,
2391: program_update_date = sysdate,
2392: request_id = fnd_global.conc_request_id,
2393: inventory_item_id = (select primary_item_id
2386: set last_update_date = sysdate,
2387: last_updated_by = fnd_global.user_id,
2388: last_update_login = fnd_global.login_id,
2389: program_application_id = fnd_global.prog_appl_id,
2390: program_id = fnd_global.conc_program_id,
2391: program_update_date = sysdate,
2392: request_id = fnd_global.conc_request_id,
2393: inventory_item_id = (select primary_item_id
2394: from wip_entities we
2388: last_update_login = fnd_global.login_id,
2389: program_application_id = fnd_global.prog_appl_id,
2390: program_id = fnd_global.conc_program_id,
2391: program_update_date = sysdate,
2392: request_id = fnd_global.conc_request_id,
2393: inventory_item_id = (select primary_item_id
2394: from wip_entities we
2395: where we.organization_id = mti.organization_id
2396: and we.wip_entity_id = mti.transaction_source_id)
2479: forall i in 1..l_orgIDTbl.count
2480: /* FP bug 5708701 (base bug 5046732) - No need update locator id on MTI. It will be done in inventory code.*/
2481: update mtl_transactions_interface mti
2482: set last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,
2484: last_update_login = fnd_global.login_id,
2485: program_application_id = fnd_global.prog_appl_id,
2486: program_id = fnd_global.conc_program_id,
2487: program_update_date = sysdate,
2480: /* FP bug 5708701 (base bug 5046732) - No need update locator id on MTI. It will be done in inventory code.*/
2481: update mtl_transactions_interface mti
2482: set last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,
2484: last_update_login = fnd_global.login_id,
2485: program_application_id = fnd_global.prog_appl_id,
2486: program_id = fnd_global.conc_program_id,
2487: program_update_date = sysdate,
2488: request_id = fnd_global.conc_request_id,
2481: update mtl_transactions_interface mti
2482: set last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,
2484: last_update_login = fnd_global.login_id,
2485: program_application_id = fnd_global.prog_appl_id,
2486: program_id = fnd_global.conc_program_id,
2487: program_update_date = sysdate,
2488: request_id = fnd_global.conc_request_id,
2489: inventory_item_id = l_itemIDTbl(i)
2482: set last_update_date = sysdate,
2483: last_updated_by = fnd_global.user_id,
2484: last_update_login = fnd_global.login_id,
2485: program_application_id = fnd_global.prog_appl_id,
2486: program_id = fnd_global.conc_program_id,
2487: program_update_date = sysdate,
2488: request_id = fnd_global.conc_request_id,
2489: inventory_item_id = l_itemIDTbl(i)
2490: --locator_id = l_locIdTbl(i)
2484: last_update_login = fnd_global.login_id,
2485: program_application_id = fnd_global.prog_appl_id,
2486: program_id = fnd_global.conc_program_id,
2487: program_update_date = sysdate,
2488: request_id = fnd_global.conc_request_id,
2489: inventory_item_id = l_itemIDTbl(i)
2490: --locator_id = l_locIdTbl(i)
2491: where rowid = chartorowid(l_rowidTbl(i));
2492:
2493: /* FP bug 5708701 (base bug 5046732) No need update project id/task id on MTI. It will be done in inventory code.
2494: --update the project/task based on the derived locator
2495: update mtl_transactions_interface mti
2496: set last_update_date = sysdate,
2497: last_updated_by = fnd_global.user_id,
2498: last_update_login = fnd_global.login_id,
2499: program_application_id = fnd_global.prog_appl_id,
2500: program_id = fnd_global.conc_program_id,
2501: program_update_date = sysdate,
2494: --update the project/task based on the derived locator
2495: update mtl_transactions_interface mti
2496: set last_update_date = sysdate,
2497: last_updated_by = fnd_global.user_id,
2498: last_update_login = fnd_global.login_id,
2499: program_application_id = fnd_global.prog_appl_id,
2500: program_id = fnd_global.conc_program_id,
2501: program_update_date = sysdate,
2502: request_id = fnd_global.conc_request_id,
2495: update mtl_transactions_interface mti
2496: set last_update_date = sysdate,
2497: last_updated_by = fnd_global.user_id,
2498: last_update_login = fnd_global.login_id,
2499: program_application_id = fnd_global.prog_appl_id,
2500: program_id = fnd_global.conc_program_id,
2501: program_update_date = sysdate,
2502: request_id = fnd_global.conc_request_id,
2503: (project_id, task_id) = (select project_id, task_id
2496: set last_update_date = sysdate,
2497: last_updated_by = fnd_global.user_id,
2498: last_update_login = fnd_global.login_id,
2499: program_application_id = fnd_global.prog_appl_id,
2500: program_id = fnd_global.conc_program_id,
2501: program_update_date = sysdate,
2502: request_id = fnd_global.conc_request_id,
2503: (project_id, task_id) = (select project_id, task_id
2504: from mtl_item_locations mil
2498: last_update_login = fnd_global.login_id,
2499: program_application_id = fnd_global.prog_appl_id,
2500: program_id = fnd_global.conc_program_id,
2501: program_update_date = sysdate,
2502: request_id = fnd_global.conc_request_id,
2503: (project_id, task_id) = (select project_id, task_id
2504: from mtl_item_locations mil
2505: where inventory_location_id = mti.locator_id
2506: and organization_id = mti.organization_id)
2517: fnd_message.set_name('INV', 'INV_INT_ITMEXP');
2518: l_errMsg := substrb(fnd_message.get, 1, 240);
2519: update mtl_transactions_interface mti
2520: set last_update_date = sysdate,
2521: last_updated_by = fnd_global.user_id,
2522: last_update_login = fnd_global.login_id,
2523: program_application_id = fnd_global.prog_appl_id,
2524: program_id = fnd_global.conc_program_id,
2525: program_update_date = sysdate,
2518: l_errMsg := substrb(fnd_message.get, 1, 240);
2519: update mtl_transactions_interface mti
2520: set last_update_date = sysdate,
2521: last_updated_by = fnd_global.user_id,
2522: last_update_login = fnd_global.login_id,
2523: program_application_id = fnd_global.prog_appl_id,
2524: program_id = fnd_global.conc_program_id,
2525: program_update_date = sysdate,
2526: request_id = fnd_global.conc_request_id,
2519: update mtl_transactions_interface mti
2520: set last_update_date = sysdate,
2521: last_updated_by = fnd_global.user_id,
2522: last_update_login = fnd_global.login_id,
2523: program_application_id = fnd_global.prog_appl_id,
2524: program_id = fnd_global.conc_program_id,
2525: program_update_date = sysdate,
2526: request_id = fnd_global.conc_request_id,
2527: process_flag = 3,
2520: set last_update_date = sysdate,
2521: last_updated_by = fnd_global.user_id,
2522: last_update_login = fnd_global.login_id,
2523: program_application_id = fnd_global.prog_appl_id,
2524: program_id = fnd_global.conc_program_id,
2525: program_update_date = sysdate,
2526: request_id = fnd_global.conc_request_id,
2527: process_flag = 3,
2528: lock_flag = 2,
2522: last_update_login = fnd_global.login_id,
2523: program_application_id = fnd_global.prog_appl_id,
2524: program_id = fnd_global.conc_program_id,
2525: program_update_date = sysdate,
2526: request_id = fnd_global.conc_request_id,
2527: process_flag = 3,
2528: lock_flag = 2,
2529: error_code = l_errCode,
2530: error_explanation = l_errMsg
2540:
2541: -- derive wip_entity_type if transaction source id is provided
2542: update mtl_transactions_interface mti
2543: set last_update_date = sysdate,
2544: last_updated_by = fnd_global.user_id,
2545: last_update_login = fnd_global.login_id,
2546: program_application_id = fnd_global.prog_appl_id,
2547: program_id = fnd_global.conc_program_id,
2548: program_update_date = sysdate,
2541: -- derive wip_entity_type if transaction source id is provided
2542: update mtl_transactions_interface mti
2543: set last_update_date = sysdate,
2544: last_updated_by = fnd_global.user_id,
2545: last_update_login = fnd_global.login_id,
2546: program_application_id = fnd_global.prog_appl_id,
2547: program_id = fnd_global.conc_program_id,
2548: program_update_date = sysdate,
2549: request_id = fnd_global.conc_request_id,
2542: update mtl_transactions_interface mti
2543: set last_update_date = sysdate,
2544: last_updated_by = fnd_global.user_id,
2545: last_update_login = fnd_global.login_id,
2546: program_application_id = fnd_global.prog_appl_id,
2547: program_id = fnd_global.conc_program_id,
2548: program_update_date = sysdate,
2549: request_id = fnd_global.conc_request_id,
2550: wip_entity_type = (select entity_type
2543: set last_update_date = sysdate,
2544: last_updated_by = fnd_global.user_id,
2545: last_update_login = fnd_global.login_id,
2546: program_application_id = fnd_global.prog_appl_id,
2547: program_id = fnd_global.conc_program_id,
2548: program_update_date = sysdate,
2549: request_id = fnd_global.conc_request_id,
2550: wip_entity_type = (select entity_type
2551: from wip_entities we
2545: last_update_login = fnd_global.login_id,
2546: program_application_id = fnd_global.prog_appl_id,
2547: program_id = fnd_global.conc_program_id,
2548: program_update_date = sysdate,
2549: request_id = fnd_global.conc_request_id,
2550: wip_entity_type = (select entity_type
2551: from wip_entities we
2552: where we.organization_id = mti.organization_id
2553: and we.wip_entity_id = mti.transaction_source_id)
2558:
2559: --derive the source project id/task id for jobs
2560: update mtl_transactions_interface mti
2561: set last_update_date = sysdate,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id,
2564: program_application_id = fnd_global.prog_appl_id,
2565: program_id = fnd_global.conc_program_id,
2566: program_update_date = sysdate,
2559: --derive the source project id/task id for jobs
2560: update mtl_transactions_interface mti
2561: set last_update_date = sysdate,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id,
2564: program_application_id = fnd_global.prog_appl_id,
2565: program_id = fnd_global.conc_program_id,
2566: program_update_date = sysdate,
2567: request_id = fnd_global.conc_request_id,
2560: update mtl_transactions_interface mti
2561: set last_update_date = sysdate,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id,
2564: program_application_id = fnd_global.prog_appl_id,
2565: program_id = fnd_global.conc_program_id,
2566: program_update_date = sysdate,
2567: request_id = fnd_global.conc_request_id,
2568: (source_project_id, source_task_id) =
2561: set last_update_date = sysdate,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id,
2564: program_application_id = fnd_global.prog_appl_id,
2565: program_id = fnd_global.conc_program_id,
2566: program_update_date = sysdate,
2567: request_id = fnd_global.conc_request_id,
2568: (source_project_id, source_task_id) =
2569: (select project_id,
2563: last_update_login = fnd_global.login_id,
2564: program_application_id = fnd_global.prog_appl_id,
2565: program_id = fnd_global.conc_program_id,
2566: program_update_date = sysdate,
2567: request_id = fnd_global.conc_request_id,
2568: (source_project_id, source_task_id) =
2569: (select project_id,
2570: task_id
2571: from wip_discrete_jobs
2580:
2581: --derive the source project id/task id for flow schedules
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: --derive the source project id/task id for flow schedules
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: (source_project_id, source_task_id) =
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: (source_project_id, source_task_id) =
2591: (select project_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: (source_project_id, source_task_id) =
2591: (select project_id,
2592: task_id
2593: from wip_flow_schedules
2606: fnd_message.set_name('WIP', 'WIP_FLOW_FLAG_ERROR');
2607: l_errMsg := substrb(fnd_message.get, 1, 240);
2608: update mtl_transactions_interface mti
2609: set last_update_date = sysdate,
2610: last_updated_by = fnd_global.user_id,
2611: last_update_login = fnd_global.login_id,
2612: program_application_id = fnd_global.prog_appl_id,
2613: program_id = fnd_global.conc_program_id,
2614: program_update_date = sysdate,
2607: l_errMsg := substrb(fnd_message.get, 1, 240);
2608: update mtl_transactions_interface mti
2609: set last_update_date = sysdate,
2610: last_updated_by = fnd_global.user_id,
2611: last_update_login = fnd_global.login_id,
2612: program_application_id = fnd_global.prog_appl_id,
2613: program_id = fnd_global.conc_program_id,
2614: program_update_date = sysdate,
2615: request_id = fnd_global.conc_request_id,
2608: update mtl_transactions_interface mti
2609: set last_update_date = sysdate,
2610: last_updated_by = fnd_global.user_id,
2611: last_update_login = fnd_global.login_id,
2612: program_application_id = fnd_global.prog_appl_id,
2613: program_id = fnd_global.conc_program_id,
2614: program_update_date = sysdate,
2615: request_id = fnd_global.conc_request_id,
2616: process_flag = 3,
2609: set last_update_date = sysdate,
2610: last_updated_by = fnd_global.user_id,
2611: last_update_login = fnd_global.login_id,
2612: program_application_id = fnd_global.prog_appl_id,
2613: program_id = fnd_global.conc_program_id,
2614: program_update_date = sysdate,
2615: request_id = fnd_global.conc_request_id,
2616: process_flag = 3,
2617: lock_flag = 2,
2611: last_update_login = fnd_global.login_id,
2612: program_application_id = fnd_global.prog_appl_id,
2613: program_id = fnd_global.conc_program_id,
2614: program_update_date = sysdate,
2615: request_id = fnd_global.conc_request_id,
2616: process_flag = 3,
2617: lock_flag = 2,
2618: error_code = 'Invalid flow schedule flag',
2619: error_explanation = l_errMsg
2629: fnd_message.set_name('WIP', 'WIP_NO_CHARGES_ALLOWED');
2630: l_errMsg := substrb(fnd_message.get, 1, 240);
2631: update mtl_transactions_interface mti
2632: set last_update_date = sysdate,
2633: last_updated_by = fnd_global.user_id,
2634: last_update_login = fnd_global.login_id,
2635: program_application_id = fnd_global.prog_appl_id,
2636: program_id = fnd_global.conc_program_id,
2637: program_update_date = sysdate,
2630: l_errMsg := substrb(fnd_message.get, 1, 240);
2631: update mtl_transactions_interface mti
2632: set last_update_date = sysdate,
2633: last_updated_by = fnd_global.user_id,
2634: last_update_login = fnd_global.login_id,
2635: program_application_id = fnd_global.prog_appl_id,
2636: program_id = fnd_global.conc_program_id,
2637: program_update_date = sysdate,
2638: request_id = fnd_global.conc_request_id,
2631: update mtl_transactions_interface mti
2632: set last_update_date = sysdate,
2633: last_updated_by = fnd_global.user_id,
2634: last_update_login = fnd_global.login_id,
2635: program_application_id = fnd_global.prog_appl_id,
2636: program_id = fnd_global.conc_program_id,
2637: program_update_date = sysdate,
2638: request_id = fnd_global.conc_request_id,
2639: process_flag = 3,
2632: set last_update_date = sysdate,
2633: last_updated_by = fnd_global.user_id,
2634: last_update_login = fnd_global.login_id,
2635: program_application_id = fnd_global.prog_appl_id,
2636: program_id = fnd_global.conc_program_id,
2637: program_update_date = sysdate,
2638: request_id = fnd_global.conc_request_id,
2639: process_flag = 3,
2640: lock_flag = 2,
2634: last_update_login = fnd_global.login_id,
2635: program_application_id = fnd_global.prog_appl_id,
2636: program_id = fnd_global.conc_program_id,
2637: program_update_date = sysdate,
2638: request_id = fnd_global.conc_request_id,
2639: process_flag = 3,
2640: lock_flag = 2,
2641: error_code = 'transaction_source_id',
2642: error_explanation = l_errMsg
2664: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2665: l_errMsg := substrb(SQLERRM, 1, 240);
2666: update mtl_transactions_interface
2667: set last_update_date = sysdate,
2668: last_updated_by = fnd_global.user_id,
2669: last_update_login = fnd_global.login_id,
2670: program_application_id = fnd_global.prog_appl_id,
2671: program_id = fnd_global.conc_program_id,
2672: program_update_date = sysdate,
2665: l_errMsg := substrb(SQLERRM, 1, 240);
2666: update mtl_transactions_interface
2667: set last_update_date = sysdate,
2668: last_updated_by = fnd_global.user_id,
2669: last_update_login = fnd_global.login_id,
2670: program_application_id = fnd_global.prog_appl_id,
2671: program_id = fnd_global.conc_program_id,
2672: program_update_date = sysdate,
2673: request_id = fnd_global.conc_request_id,
2666: update mtl_transactions_interface
2667: set last_update_date = sysdate,
2668: last_updated_by = fnd_global.user_id,
2669: last_update_login = fnd_global.login_id,
2670: program_application_id = fnd_global.prog_appl_id,
2671: program_id = fnd_global.conc_program_id,
2672: program_update_date = sysdate,
2673: request_id = fnd_global.conc_request_id,
2674: process_flag = 3,
2667: set last_update_date = sysdate,
2668: last_updated_by = fnd_global.user_id,
2669: last_update_login = fnd_global.login_id,
2670: program_application_id = fnd_global.prog_appl_id,
2671: program_id = fnd_global.conc_program_id,
2672: program_update_date = sysdate,
2673: request_id = fnd_global.conc_request_id,
2674: process_flag = 3,
2675: lock_flag = 2,
2669: last_update_login = fnd_global.login_id,
2670: program_application_id = fnd_global.prog_appl_id,
2671: program_id = fnd_global.conc_program_id,
2672: program_update_date = sysdate,
2673: request_id = fnd_global.conc_request_id,
2674: process_flag = 3,
2675: lock_flag = 2,
2676: error_code = 'wip_mti_pub.doPreProcessingValidations',
2677: error_explanation = l_errMsg
2769: --if any components failed update the parent with the error
2770: forall i in 1..l_errExplTbl.count
2771: update mtl_transactions_interface mti
2772: set last_update_date = sysdate,
2773: last_updated_by = fnd_global.user_id,
2774: last_update_login = fnd_global.login_id,
2775: program_application_id = fnd_global.prog_appl_id,
2776: program_id = fnd_global.conc_program_id,
2777: program_update_date = sysdate,
2770: forall i in 1..l_errExplTbl.count
2771: update mtl_transactions_interface mti
2772: set last_update_date = sysdate,
2773: last_updated_by = fnd_global.user_id,
2774: last_update_login = fnd_global.login_id,
2775: program_application_id = fnd_global.prog_appl_id,
2776: program_id = fnd_global.conc_program_id,
2777: program_update_date = sysdate,
2778: request_id = fnd_global.conc_request_id,
2771: update mtl_transactions_interface mti
2772: set last_update_date = sysdate,
2773: last_updated_by = fnd_global.user_id,
2774: last_update_login = fnd_global.login_id,
2775: program_application_id = fnd_global.prog_appl_id,
2776: program_id = fnd_global.conc_program_id,
2777: program_update_date = sysdate,
2778: request_id = fnd_global.conc_request_id,
2779: error_code = substrb(l_itemNameTbl(i), 1, 240),
2772: set last_update_date = sysdate,
2773: last_updated_by = fnd_global.user_id,
2774: last_update_login = fnd_global.login_id,
2775: program_application_id = fnd_global.prog_appl_id,
2776: program_id = fnd_global.conc_program_id,
2777: program_update_date = sysdate,
2778: request_id = fnd_global.conc_request_id,
2779: error_code = substrb(l_itemNameTbl(i), 1, 240),
2780: error_explanation = l_errExplTbl(i)
2774: last_update_login = fnd_global.login_id,
2775: program_application_id = fnd_global.prog_appl_id,
2776: program_id = fnd_global.conc_program_id,
2777: program_update_date = sysdate,
2778: request_id = fnd_global.conc_request_id,
2779: error_code = substrb(l_itemNameTbl(i), 1, 240),
2780: error_explanation = l_errExplTbl(i)
2781: where transaction_header_id = p_txnHeaderID
2782: and transaction_batch_id = p_txnBatchID