APPS.WIP_EAMMTLPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 35: update mtl_transactions_interface mti

31: --rebuildable columns(rebuild_item_id, rebuild_serial_number, rebuild_activity_id, rebuild_job_name)
32: --not allowed unless jobs is eam
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,

Line 62: update mtl_transactions_interface mti

58: --rebuildable columns(rebuild_item_id, rebuild_serial_number, rebuild_activity_id, rebuild_job_name)
59: --not allowed unless item being issued is a rebuild item
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,

Line 87: update mtl_transactions_interface mti

83:
84: --rebuild item must be populated if any other columns are populated
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,

Line 113: update mtl_transactions_interface mti

109: --item must exist in organization
110: --item must be rebuildable
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,

Line 142: update mtl_transactions_interface mti

138: --item must exist in organization
139: --item must be an activity
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,

Line 169: update mtl_transactions_interface mti

165:
166: --txn type must be issue when rebuild columns are populated
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,

Line 192: update mtl_transactions_interface mti

188:
189: --primary txn qty must be 1 when transacting rebuildable items
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,

Line 219: update mtl_transactions_interface mti

215:
216: --rebuild job name already exists in this organization
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,

Line 247: update mtl_transactions_interface mti

243: --IB: anjgupta: check this Query one more time!!!!!!!!!!!!!!!!
244: --activity not valid for this rebuild item
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,

Line 282: update mtl_transactions_interface mti

278:
279: --rebuild item must be serial controlled if rebuild serial number provided
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,

Line 317: update mtl_transactions_interface mti

313: -- + defined not used
314: -- + issued out and in the asset's genealogy
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,