29:
30:
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,
30:
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,
56:
57:
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,
57:
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,
81: and msi.organization_id = mti.organization_id
82: and msi.eam_item_type = 3);
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,
82: and msi.eam_item_type = 3);
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,
107:
108:
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,
108:
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,
136:
137:
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,
137:
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,
163:
164:
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,
164:
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,
186:
187:
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,
187:
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,
213:
214:
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,
214:
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,
241:
242:
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,
242:
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,
276:
277:
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,
277:
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,
311: --serial number must exist in organization
312: -- must be:
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,
312: -- must be:
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,
503:
504: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
505: l_errMsg := 'genealogy failed';
506: if(l_msgData is not null) then
507: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
508: fnd_message.set_token('MESSAGE', l_msgData);
509: fnd_msg_pub.add; --add the returned error message to the stack.
510: end if;
511: raise fnd_api.g_exc_unexpected_error;
504: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
505: l_errMsg := 'genealogy failed';
506: if(l_msgData is not null) then
507: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
508: fnd_message.set_token('MESSAGE', l_msgData);
509: fnd_msg_pub.add; --add the returned error message to the stack.
510: end if;
511: raise fnd_api.g_exc_unexpected_error;
512: end if;
524: eam_rebuild.create_rebuild_job(p_tempId => p_compRec.txnTmpID,
525: x_retVal => x_returnStatus,
526: x_errMsg => l_msgData);
527: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
528: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
529: fnd_message.set_token('MESSAGE', l_msgData);
530: fnd_msg_pub.add; --add the returned error message to the stack.
531: l_errMsg := 'rebuild job creation failed';
532: raise fnd_api.g_exc_unexpected_error;
525: x_retVal => x_returnStatus,
526: x_errMsg => l_msgData);
527: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
528: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
529: fnd_message.set_token('MESSAGE', l_msgData);
530: fnd_msg_pub.add; --add the returned error message to the stack.
531: l_errMsg := 'rebuild job creation failed';
532: raise fnd_api.g_exc_unexpected_error;
533: end if;