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
218: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');
219: l_errMsg := substrb(fnd_message.get, 1, 240);
220: update mtl_transactions_interface mti
221: set last_update_date = sysdate,
222: last_updated_by = fnd_global.user_id,
223: last_update_login = fnd_global.login_id,
224: program_application_id = fnd_global.prog_appl_id,
225: program_id = fnd_global.conc_program_id,
226: program_update_date = sysdate,
219: l_errMsg := substrb(fnd_message.get, 1, 240);
220: update mtl_transactions_interface mti
221: set last_update_date = sysdate,
222: last_updated_by = fnd_global.user_id,
223: last_update_login = fnd_global.login_id,
224: program_application_id = fnd_global.prog_appl_id,
225: program_id = fnd_global.conc_program_id,
226: program_update_date = sysdate,
227: request_id = fnd_global.conc_request_id,
220: update mtl_transactions_interface mti
221: set last_update_date = sysdate,
222: last_updated_by = fnd_global.user_id,
223: last_update_login = fnd_global.login_id,
224: program_application_id = fnd_global.prog_appl_id,
225: program_id = fnd_global.conc_program_id,
226: program_update_date = sysdate,
227: request_id = fnd_global.conc_request_id,
228: process_flag = 3,
221: set last_update_date = sysdate,
222: last_updated_by = fnd_global.user_id,
223: last_update_login = fnd_global.login_id,
224: program_application_id = fnd_global.prog_appl_id,
225: program_id = fnd_global.conc_program_id,
226: program_update_date = sysdate,
227: request_id = fnd_global.conc_request_id,
228: process_flag = 3,
229: lock_flag = 2,
223: last_update_login = fnd_global.login_id,
224: program_application_id = fnd_global.prog_appl_id,
225: program_id = fnd_global.conc_program_id,
226: program_update_date = sysdate,
227: request_id = fnd_global.conc_request_id,
228: process_flag = 3,
229: lock_flag = 2,
230: error_code = 'REBUILD_JOB_NAME',
231: error_explanation = l_errMsg
246: fnd_message.set_name('WIP', 'WIP_MTI_NO_ACTIVITY_ASSOC');
247: l_errMsg := substrb(fnd_message.get, 1, 240);
248: update mtl_transactions_interface mti
249: set last_update_date = sysdate,
250: last_updated_by = fnd_global.user_id,
251: last_update_login = fnd_global.login_id,
252: program_application_id = fnd_global.prog_appl_id,
253: program_id = fnd_global.conc_program_id,
254: program_update_date = sysdate,
247: l_errMsg := substrb(fnd_message.get, 1, 240);
248: update mtl_transactions_interface mti
249: set last_update_date = sysdate,
250: last_updated_by = fnd_global.user_id,
251: last_update_login = fnd_global.login_id,
252: program_application_id = fnd_global.prog_appl_id,
253: program_id = fnd_global.conc_program_id,
254: program_update_date = sysdate,
255: request_id = fnd_global.conc_request_id,
248: update mtl_transactions_interface mti
249: set last_update_date = sysdate,
250: last_updated_by = fnd_global.user_id,
251: last_update_login = fnd_global.login_id,
252: program_application_id = fnd_global.prog_appl_id,
253: program_id = fnd_global.conc_program_id,
254: program_update_date = sysdate,
255: request_id = fnd_global.conc_request_id,
256: process_flag = 3,
249: set last_update_date = sysdate,
250: last_updated_by = fnd_global.user_id,
251: last_update_login = fnd_global.login_id,
252: program_application_id = fnd_global.prog_appl_id,
253: program_id = fnd_global.conc_program_id,
254: program_update_date = sysdate,
255: request_id = fnd_global.conc_request_id,
256: process_flag = 3,
257: lock_flag = 2,
251: last_update_login = fnd_global.login_id,
252: program_application_id = fnd_global.prog_appl_id,
253: program_id = fnd_global.conc_program_id,
254: program_update_date = sysdate,
255: request_id = fnd_global.conc_request_id,
256: process_flag = 3,
257: lock_flag = 2,
258: error_code = 'REBUILD_ACTIVITY_ID',
259: error_explanation = l_errMsg
281: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_SN_CNTRL');
282: l_errMsg := substrb(fnd_message.get, 1, 240);
283: update mtl_transactions_interface mti
284: set last_update_date = sysdate,
285: last_updated_by = fnd_global.user_id,
286: last_update_login = fnd_global.login_id,
287: program_application_id = fnd_global.prog_appl_id,
288: program_id = fnd_global.conc_program_id,
289: program_update_date = sysdate,
282: l_errMsg := substrb(fnd_message.get, 1, 240);
283: update mtl_transactions_interface mti
284: set last_update_date = sysdate,
285: last_updated_by = fnd_global.user_id,
286: last_update_login = fnd_global.login_id,
287: program_application_id = fnd_global.prog_appl_id,
288: program_id = fnd_global.conc_program_id,
289: program_update_date = sysdate,
290: request_id = fnd_global.conc_request_id,
283: update mtl_transactions_interface mti
284: set last_update_date = sysdate,
285: last_updated_by = fnd_global.user_id,
286: last_update_login = fnd_global.login_id,
287: program_application_id = fnd_global.prog_appl_id,
288: program_id = fnd_global.conc_program_id,
289: program_update_date = sysdate,
290: request_id = fnd_global.conc_request_id,
291: process_flag = 3,
284: set last_update_date = sysdate,
285: last_updated_by = fnd_global.user_id,
286: last_update_login = fnd_global.login_id,
287: program_application_id = fnd_global.prog_appl_id,
288: program_id = fnd_global.conc_program_id,
289: program_update_date = sysdate,
290: request_id = fnd_global.conc_request_id,
291: process_flag = 3,
292: lock_flag = 2,
286: last_update_login = fnd_global.login_id,
287: program_application_id = fnd_global.prog_appl_id,
288: program_id = fnd_global.conc_program_id,
289: program_update_date = sysdate,
290: request_id = fnd_global.conc_request_id,
291: process_flag = 3,
292: lock_flag = 2,
293: error_code = 'REBUILD_ITEM_ID',
294: error_explanation = l_errMsg
316: fnd_message.set_name('WIP', 'WIP_ML_EAM_REBUILD_SERIAL');
317: l_errMsg := substrb(fnd_message.get, 1, 240);
318: update mtl_transactions_interface mti
319: set last_update_date = sysdate,
320: last_updated_by = fnd_global.user_id,
321: last_update_login = fnd_global.login_id,
322: program_application_id = fnd_global.prog_appl_id,
323: program_id = fnd_global.conc_program_id,
324: program_update_date = sysdate,
317: l_errMsg := substrb(fnd_message.get, 1, 240);
318: update mtl_transactions_interface mti
319: set last_update_date = sysdate,
320: last_updated_by = fnd_global.user_id,
321: last_update_login = fnd_global.login_id,
322: program_application_id = fnd_global.prog_appl_id,
323: program_id = fnd_global.conc_program_id,
324: program_update_date = sysdate,
325: request_id = fnd_global.conc_request_id,
318: update mtl_transactions_interface mti
319: set last_update_date = sysdate,
320: last_updated_by = fnd_global.user_id,
321: last_update_login = fnd_global.login_id,
322: program_application_id = fnd_global.prog_appl_id,
323: program_id = fnd_global.conc_program_id,
324: program_update_date = sysdate,
325: request_id = fnd_global.conc_request_id,
326: process_flag = 3,
319: set last_update_date = sysdate,
320: last_updated_by = fnd_global.user_id,
321: last_update_login = fnd_global.login_id,
322: program_application_id = fnd_global.prog_appl_id,
323: program_id = fnd_global.conc_program_id,
324: program_update_date = sysdate,
325: request_id = fnd_global.conc_request_id,
326: process_flag = 3,
327: lock_flag = 2,
321: last_update_login = fnd_global.login_id,
322: program_application_id = fnd_global.prog_appl_id,
323: program_id = fnd_global.conc_program_id,
324: program_update_date = sysdate,
325: request_id = fnd_global.conc_request_id,
326: process_flag = 3,
327: lock_flag = 2,
328: error_code = 'REBUILD_ITEM_ID',
329: error_explanation = l_errMsg