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 220: update mtl_transactions_interface mti

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

Line 248: update mtl_transactions_interface mti

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

Line 283: update mtl_transactions_interface mti

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

Line 318: update mtl_transactions_interface mti

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