33: fnd_message.set_name('WIP', 'WIP_MTI_REB_COL_NOT_ALLOWED');
34: l_errMsg := substrb(fnd_message.get, 1, 240);
35: update mtl_transactions_interface mti
36: set last_update_date = sysdate,
37: last_updated_by = fnd_global.user_id,
38: last_update_login = fnd_global.login_id,
39: program_application_id = fnd_global.prog_appl_id,
40: program_id = fnd_global.conc_program_id,
41: program_update_date = sysdate,
34: l_errMsg := substrb(fnd_message.get, 1, 240);
35: update mtl_transactions_interface mti
36: set last_update_date = sysdate,
37: last_updated_by = fnd_global.user_id,
38: last_update_login = fnd_global.login_id,
39: program_application_id = fnd_global.prog_appl_id,
40: program_id = fnd_global.conc_program_id,
41: program_update_date = sysdate,
42: request_id = fnd_global.conc_request_id,
35: update mtl_transactions_interface mti
36: set last_update_date = sysdate,
37: last_updated_by = fnd_global.user_id,
38: last_update_login = fnd_global.login_id,
39: program_application_id = fnd_global.prog_appl_id,
40: program_id = fnd_global.conc_program_id,
41: program_update_date = sysdate,
42: request_id = fnd_global.conc_request_id,
43: process_flag = 3,
36: set last_update_date = sysdate,
37: last_updated_by = fnd_global.user_id,
38: last_update_login = fnd_global.login_id,
39: program_application_id = fnd_global.prog_appl_id,
40: program_id = fnd_global.conc_program_id,
41: program_update_date = sysdate,
42: request_id = fnd_global.conc_request_id,
43: process_flag = 3,
44: lock_flag = 2,
38: last_update_login = fnd_global.login_id,
39: program_application_id = fnd_global.prog_appl_id,
40: program_id = fnd_global.conc_program_id,
41: program_update_date = sysdate,
42: request_id = fnd_global.conc_request_id,
43: process_flag = 3,
44: lock_flag = 2,
45: error_code = 'WIP_ENTITY_TYPE',
46: error_explanation = l_errMsg
60: fnd_message.set_name('WIP', 'WIP_MTI_INV_ITEM_NOT_REBLD');
61: l_errMsg := substrb(fnd_message.get, 1, 240);
62: update mtl_transactions_interface mti
63: set last_update_date = sysdate,
64: last_updated_by = fnd_global.user_id,
65: last_update_login = fnd_global.login_id,
66: program_application_id = fnd_global.prog_appl_id,
67: program_id = fnd_global.conc_program_id,
68: program_update_date = sysdate,
61: l_errMsg := substrb(fnd_message.get, 1, 240);
62: update mtl_transactions_interface mti
63: set last_update_date = sysdate,
64: last_updated_by = fnd_global.user_id,
65: last_update_login = fnd_global.login_id,
66: program_application_id = fnd_global.prog_appl_id,
67: program_id = fnd_global.conc_program_id,
68: program_update_date = sysdate,
69: request_id = fnd_global.conc_request_id,
62: update mtl_transactions_interface mti
63: set last_update_date = sysdate,
64: last_updated_by = fnd_global.user_id,
65: last_update_login = fnd_global.login_id,
66: program_application_id = fnd_global.prog_appl_id,
67: program_id = fnd_global.conc_program_id,
68: program_update_date = sysdate,
69: request_id = fnd_global.conc_request_id,
70: process_flag = 3,
63: set last_update_date = sysdate,
64: last_updated_by = fnd_global.user_id,
65: last_update_login = fnd_global.login_id,
66: program_application_id = fnd_global.prog_appl_id,
67: program_id = fnd_global.conc_program_id,
68: program_update_date = sysdate,
69: request_id = fnd_global.conc_request_id,
70: process_flag = 3,
71: lock_flag = 2,
65: last_update_login = fnd_global.login_id,
66: program_application_id = fnd_global.prog_appl_id,
67: program_id = fnd_global.conc_program_id,
68: program_update_date = sysdate,
69: request_id = fnd_global.conc_request_id,
70: process_flag = 3,
71: lock_flag = 2,
72: error_code = 'INVENTORY_ITEM_ID',
73: error_explanation = l_errMsg
85: fnd_message.set_name('WIP', 'WIP_MTI_REB_ITEM_MISSING');
86: l_errMsg := substrb(fnd_message.get, 1, 240);
87: update mtl_transactions_interface mti
88: set last_update_date = sysdate,
89: last_updated_by = fnd_global.user_id,
90: last_update_login = fnd_global.login_id,
91: program_application_id = fnd_global.prog_appl_id,
92: program_id = fnd_global.conc_program_id,
93: program_update_date = sysdate,
86: l_errMsg := substrb(fnd_message.get, 1, 240);
87: update mtl_transactions_interface mti
88: set last_update_date = sysdate,
89: last_updated_by = fnd_global.user_id,
90: last_update_login = fnd_global.login_id,
91: program_application_id = fnd_global.prog_appl_id,
92: program_id = fnd_global.conc_program_id,
93: program_update_date = sysdate,
94: request_id = fnd_global.conc_request_id,
87: update mtl_transactions_interface mti
88: set last_update_date = sysdate,
89: last_updated_by = fnd_global.user_id,
90: last_update_login = fnd_global.login_id,
91: program_application_id = fnd_global.prog_appl_id,
92: program_id = fnd_global.conc_program_id,
93: program_update_date = sysdate,
94: request_id = fnd_global.conc_request_id,
95: process_flag = 3,
88: set last_update_date = sysdate,
89: last_updated_by = fnd_global.user_id,
90: last_update_login = fnd_global.login_id,
91: program_application_id = fnd_global.prog_appl_id,
92: program_id = fnd_global.conc_program_id,
93: program_update_date = sysdate,
94: request_id = fnd_global.conc_request_id,
95: process_flag = 3,
96: lock_flag = 2,
90: last_update_login = fnd_global.login_id,
91: program_application_id = fnd_global.prog_appl_id,
92: program_id = fnd_global.conc_program_id,
93: program_update_date = sysdate,
94: request_id = fnd_global.conc_request_id,
95: process_flag = 3,
96: lock_flag = 2,
97: error_code = 'REBUILD_ITEM_ID',
98: error_explanation = l_errMsg
111: fnd_message.set_name('WIP', 'WIP_ML_EAM_REBUILD_ITEM');
112: l_errMsg := substrb(fnd_message.get, 1, 240);
113: update mtl_transactions_interface mti
114: set last_update_date = sysdate,
115: last_updated_by = fnd_global.user_id,
116: last_update_login = fnd_global.login_id,
117: program_application_id = fnd_global.prog_appl_id,
118: program_id = fnd_global.conc_program_id,
119: program_update_date = sysdate,
112: l_errMsg := substrb(fnd_message.get, 1, 240);
113: update mtl_transactions_interface mti
114: set last_update_date = sysdate,
115: last_updated_by = fnd_global.user_id,
116: last_update_login = fnd_global.login_id,
117: program_application_id = fnd_global.prog_appl_id,
118: program_id = fnd_global.conc_program_id,
119: program_update_date = sysdate,
120: request_id = fnd_global.conc_request_id,
113: update mtl_transactions_interface mti
114: set last_update_date = sysdate,
115: last_updated_by = fnd_global.user_id,
116: last_update_login = fnd_global.login_id,
117: program_application_id = fnd_global.prog_appl_id,
118: program_id = fnd_global.conc_program_id,
119: program_update_date = sysdate,
120: request_id = fnd_global.conc_request_id,
121: process_flag = 3,
114: set last_update_date = sysdate,
115: last_updated_by = fnd_global.user_id,
116: last_update_login = fnd_global.login_id,
117: program_application_id = fnd_global.prog_appl_id,
118: program_id = fnd_global.conc_program_id,
119: program_update_date = sysdate,
120: request_id = fnd_global.conc_request_id,
121: process_flag = 3,
122: lock_flag = 2,
116: last_update_login = fnd_global.login_id,
117: program_application_id = fnd_global.prog_appl_id,
118: program_id = fnd_global.conc_program_id,
119: program_update_date = sysdate,
120: request_id = fnd_global.conc_request_id,
121: process_flag = 3,
122: lock_flag = 2,
123: error_code = 'REBUILD_ITEM_ID',
124: error_explanation = l_errMsg
140: fnd_message.set_name('WIP', 'WIP_ML_EAM_ACTIVITY');
141: l_errMsg := substrb(fnd_message.get, 1, 240);
142: update mtl_transactions_interface mti
143: set last_update_date = sysdate,
144: last_updated_by = fnd_global.user_id,
145: last_update_login = fnd_global.login_id,
146: program_application_id = fnd_global.prog_appl_id,
147: program_id = fnd_global.conc_program_id,
148: program_update_date = sysdate,
141: l_errMsg := substrb(fnd_message.get, 1, 240);
142: update mtl_transactions_interface mti
143: set last_update_date = sysdate,
144: last_updated_by = fnd_global.user_id,
145: last_update_login = fnd_global.login_id,
146: program_application_id = fnd_global.prog_appl_id,
147: program_id = fnd_global.conc_program_id,
148: program_update_date = sysdate,
149: request_id = fnd_global.conc_request_id,
142: update mtl_transactions_interface mti
143: set last_update_date = sysdate,
144: last_updated_by = fnd_global.user_id,
145: last_update_login = fnd_global.login_id,
146: program_application_id = fnd_global.prog_appl_id,
147: program_id = fnd_global.conc_program_id,
148: program_update_date = sysdate,
149: request_id = fnd_global.conc_request_id,
150: process_flag = 3,
143: set last_update_date = sysdate,
144: last_updated_by = fnd_global.user_id,
145: last_update_login = fnd_global.login_id,
146: program_application_id = fnd_global.prog_appl_id,
147: program_id = fnd_global.conc_program_id,
148: program_update_date = sysdate,
149: request_id = fnd_global.conc_request_id,
150: process_flag = 3,
151: lock_flag = 2,
145: last_update_login = fnd_global.login_id,
146: program_application_id = fnd_global.prog_appl_id,
147: program_id = fnd_global.conc_program_id,
148: program_update_date = sysdate,
149: request_id = fnd_global.conc_request_id,
150: process_flag = 3,
151: lock_flag = 2,
152: error_code = 'REBUILD_ACTIVITY_ID',
153: error_explanation = l_errMsg
167: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_TXN_TYPE');
168: l_errMsg := substrb(fnd_message.get, 1, 240);
169: update mtl_transactions_interface mti
170: set last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id,
173: program_application_id = fnd_global.prog_appl_id,
174: program_id = fnd_global.conc_program_id,
175: program_update_date = sysdate,
168: l_errMsg := substrb(fnd_message.get, 1, 240);
169: update mtl_transactions_interface mti
170: set last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id,
173: program_application_id = fnd_global.prog_appl_id,
174: program_id = fnd_global.conc_program_id,
175: program_update_date = sysdate,
176: request_id = fnd_global.conc_request_id,
169: update mtl_transactions_interface mti
170: set last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id,
173: program_application_id = fnd_global.prog_appl_id,
174: program_id = fnd_global.conc_program_id,
175: program_update_date = sysdate,
176: request_id = fnd_global.conc_request_id,
177: process_flag = 3,
170: set last_update_date = sysdate,
171: last_updated_by = fnd_global.user_id,
172: last_update_login = fnd_global.login_id,
173: program_application_id = fnd_global.prog_appl_id,
174: program_id = fnd_global.conc_program_id,
175: program_update_date = sysdate,
176: request_id = fnd_global.conc_request_id,
177: process_flag = 3,
178: lock_flag = 2,
172: last_update_login = fnd_global.login_id,
173: program_application_id = fnd_global.prog_appl_id,
174: program_id = fnd_global.conc_program_id,
175: program_update_date = sysdate,
176: request_id = fnd_global.conc_request_id,
177: process_flag = 3,
178: lock_flag = 2,
179: error_code = 'TRANSACTION_TYPE_ID',
180: error_explanation = l_errMsg
190: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_QTY');
191: l_errMsg := substrb(fnd_message.get, 1, 240);
192: update mtl_transactions_interface mti
193: set last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id,
196: program_application_id = fnd_global.prog_appl_id,
197: program_id = fnd_global.conc_program_id,
198: program_update_date = sysdate,
191: l_errMsg := substrb(fnd_message.get, 1, 240);
192: update mtl_transactions_interface mti
193: set last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id,
196: program_application_id = fnd_global.prog_appl_id,
197: program_id = fnd_global.conc_program_id,
198: program_update_date = sysdate,
199: request_id = fnd_global.conc_request_id,
192: update mtl_transactions_interface mti
193: set last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id,
196: program_application_id = fnd_global.prog_appl_id,
197: program_id = fnd_global.conc_program_id,
198: program_update_date = sysdate,
199: request_id = fnd_global.conc_request_id,
200: process_flag = 3,
193: set last_update_date = sysdate,
194: last_updated_by = fnd_global.user_id,
195: last_update_login = fnd_global.login_id,
196: program_application_id = fnd_global.prog_appl_id,
197: program_id = fnd_global.conc_program_id,
198: program_update_date = sysdate,
199: request_id = fnd_global.conc_request_id,
200: process_flag = 3,
201: lock_flag = 2,
195: last_update_login = fnd_global.login_id,
196: program_application_id = fnd_global.prog_appl_id,
197: program_id = fnd_global.conc_program_id,
198: program_update_date = sysdate,
199: request_id = fnd_global.conc_request_id,
200: process_flag = 3,
201: lock_flag = 2,
202: error_code = 'PRIMARY_QUANTITY',
203: error_explanation = l_errMsg
217: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');
218: l_errMsg := substrb(fnd_message.get, 1, 240);
219: update mtl_transactions_interface mti
220: set last_update_date = sysdate,
221: last_updated_by = fnd_global.user_id,
222: last_update_login = fnd_global.login_id,
223: program_application_id = fnd_global.prog_appl_id,
224: program_id = fnd_global.conc_program_id,
225: program_update_date = sysdate,
218: l_errMsg := substrb(fnd_message.get, 1, 240);
219: update mtl_transactions_interface mti
220: set last_update_date = sysdate,
221: last_updated_by = fnd_global.user_id,
222: last_update_login = fnd_global.login_id,
223: program_application_id = fnd_global.prog_appl_id,
224: program_id = fnd_global.conc_program_id,
225: program_update_date = sysdate,
226: request_id = fnd_global.conc_request_id,
219: update mtl_transactions_interface mti
220: set last_update_date = sysdate,
221: last_updated_by = fnd_global.user_id,
222: last_update_login = fnd_global.login_id,
223: program_application_id = fnd_global.prog_appl_id,
224: program_id = fnd_global.conc_program_id,
225: program_update_date = sysdate,
226: request_id = fnd_global.conc_request_id,
227: process_flag = 3,
220: set last_update_date = sysdate,
221: last_updated_by = fnd_global.user_id,
222: last_update_login = fnd_global.login_id,
223: program_application_id = fnd_global.prog_appl_id,
224: program_id = fnd_global.conc_program_id,
225: program_update_date = sysdate,
226: request_id = fnd_global.conc_request_id,
227: process_flag = 3,
228: lock_flag = 2,
222: last_update_login = fnd_global.login_id,
223: program_application_id = fnd_global.prog_appl_id,
224: program_id = fnd_global.conc_program_id,
225: program_update_date = sysdate,
226: request_id = fnd_global.conc_request_id,
227: process_flag = 3,
228: lock_flag = 2,
229: error_code = 'REBUILD_JOB_NAME',
230: error_explanation = l_errMsg
245: fnd_message.set_name('WIP', 'WIP_MTI_NO_ACTIVITY_ASSOC');
246: l_errMsg := substrb(fnd_message.get, 1, 240);
247: update mtl_transactions_interface mti
248: set last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id,
251: program_application_id = fnd_global.prog_appl_id,
252: program_id = fnd_global.conc_program_id,
253: program_update_date = sysdate,
246: l_errMsg := substrb(fnd_message.get, 1, 240);
247: update mtl_transactions_interface mti
248: set last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id,
251: program_application_id = fnd_global.prog_appl_id,
252: program_id = fnd_global.conc_program_id,
253: program_update_date = sysdate,
254: request_id = fnd_global.conc_request_id,
247: update mtl_transactions_interface mti
248: set last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id,
251: program_application_id = fnd_global.prog_appl_id,
252: program_id = fnd_global.conc_program_id,
253: program_update_date = sysdate,
254: request_id = fnd_global.conc_request_id,
255: process_flag = 3,
248: set last_update_date = sysdate,
249: last_updated_by = fnd_global.user_id,
250: last_update_login = fnd_global.login_id,
251: program_application_id = fnd_global.prog_appl_id,
252: program_id = fnd_global.conc_program_id,
253: program_update_date = sysdate,
254: request_id = fnd_global.conc_request_id,
255: process_flag = 3,
256: lock_flag = 2,
250: last_update_login = fnd_global.login_id,
251: program_application_id = fnd_global.prog_appl_id,
252: program_id = fnd_global.conc_program_id,
253: program_update_date = sysdate,
254: request_id = fnd_global.conc_request_id,
255: process_flag = 3,
256: lock_flag = 2,
257: error_code = 'REBUILD_ACTIVITY_ID',
258: error_explanation = l_errMsg
280: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_SN_CNTRL');
281: l_errMsg := substrb(fnd_message.get, 1, 240);
282: update mtl_transactions_interface mti
283: set last_update_date = sysdate,
284: last_updated_by = fnd_global.user_id,
285: last_update_login = fnd_global.login_id,
286: program_application_id = fnd_global.prog_appl_id,
287: program_id = fnd_global.conc_program_id,
288: program_update_date = sysdate,
281: l_errMsg := substrb(fnd_message.get, 1, 240);
282: update mtl_transactions_interface mti
283: set last_update_date = sysdate,
284: last_updated_by = fnd_global.user_id,
285: last_update_login = fnd_global.login_id,
286: program_application_id = fnd_global.prog_appl_id,
287: program_id = fnd_global.conc_program_id,
288: program_update_date = sysdate,
289: request_id = fnd_global.conc_request_id,
282: update mtl_transactions_interface mti
283: set last_update_date = sysdate,
284: last_updated_by = fnd_global.user_id,
285: last_update_login = fnd_global.login_id,
286: program_application_id = fnd_global.prog_appl_id,
287: program_id = fnd_global.conc_program_id,
288: program_update_date = sysdate,
289: request_id = fnd_global.conc_request_id,
290: process_flag = 3,
283: set last_update_date = sysdate,
284: last_updated_by = fnd_global.user_id,
285: last_update_login = fnd_global.login_id,
286: program_application_id = fnd_global.prog_appl_id,
287: program_id = fnd_global.conc_program_id,
288: program_update_date = sysdate,
289: request_id = fnd_global.conc_request_id,
290: process_flag = 3,
291: lock_flag = 2,
285: last_update_login = fnd_global.login_id,
286: program_application_id = fnd_global.prog_appl_id,
287: program_id = fnd_global.conc_program_id,
288: program_update_date = sysdate,
289: request_id = fnd_global.conc_request_id,
290: process_flag = 3,
291: lock_flag = 2,
292: error_code = 'REBUILD_ITEM_ID',
293: error_explanation = l_errMsg
315: fnd_message.set_name('WIP', 'WIP_ML_EAM_REBUILD_SERIAL');
316: l_errMsg := substrb(fnd_message.get, 1, 240);
317: update mtl_transactions_interface mti
318: set last_update_date = sysdate,
319: last_updated_by = fnd_global.user_id,
320: last_update_login = fnd_global.login_id,
321: program_application_id = fnd_global.prog_appl_id,
322: program_id = fnd_global.conc_program_id,
323: program_update_date = sysdate,
316: l_errMsg := substrb(fnd_message.get, 1, 240);
317: update mtl_transactions_interface mti
318: set last_update_date = sysdate,
319: last_updated_by = fnd_global.user_id,
320: last_update_login = fnd_global.login_id,
321: program_application_id = fnd_global.prog_appl_id,
322: program_id = fnd_global.conc_program_id,
323: program_update_date = sysdate,
324: request_id = fnd_global.conc_request_id,
317: update mtl_transactions_interface mti
318: set last_update_date = sysdate,
319: last_updated_by = fnd_global.user_id,
320: last_update_login = fnd_global.login_id,
321: program_application_id = fnd_global.prog_appl_id,
322: program_id = fnd_global.conc_program_id,
323: program_update_date = sysdate,
324: request_id = fnd_global.conc_request_id,
325: process_flag = 3,
318: set last_update_date = sysdate,
319: last_updated_by = fnd_global.user_id,
320: last_update_login = fnd_global.login_id,
321: program_application_id = fnd_global.prog_appl_id,
322: program_id = fnd_global.conc_program_id,
323: program_update_date = sysdate,
324: request_id = fnd_global.conc_request_id,
325: process_flag = 3,
326: lock_flag = 2,
320: last_update_login = fnd_global.login_id,
321: program_application_id = fnd_global.prog_appl_id,
322: program_id = fnd_global.conc_program_id,
323: program_update_date = sysdate,
324: request_id = fnd_global.conc_request_id,
325: process_flag = 3,
326: lock_flag = 2,
327: error_code = 'REBUILD_ITEM_ID',
328: error_explanation = l_errMsg