DBA Data[Home] [Help]

APPS.WIP_EAMMTLPROC_PRIV dependencies on FND_MESSAGE

Line 33: fnd_message.set_name('WIP', 'WIP_MTI_REB_COL_NOT_ALLOWED');

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,

Line 34: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 60: fnd_message.set_name('WIP', 'WIP_MTI_INV_ITEM_NOT_REBLD');

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,

Line 61: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 85: fnd_message.set_name('WIP', 'WIP_MTI_REB_ITEM_MISSING');

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,

Line 86: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 111: fnd_message.set_name('WIP', 'WIP_ML_EAM_REBUILD_ITEM');

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,

Line 112: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 140: fnd_message.set_name('WIP', 'WIP_ML_EAM_ACTIVITY');

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,

Line 141: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 167: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_TXN_TYPE');

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,

Line 168: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 190: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_QTY');

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,

Line 191: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 217: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');

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,

Line 218: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 245: fnd_message.set_name('WIP', 'WIP_MTI_NO_ACTIVITY_ASSOC');

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,

Line 246: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 280: fnd_message.set_name('WIP', 'WIP_MTI_REBUILD_SN_CNTRL');

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,

Line 281: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 315: fnd_message.set_name('WIP', 'WIP_ML_EAM_REBUILD_SERIAL');

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,

Line 316: l_errMsg := substrb(fnd_message.get, 1, 240);

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,

Line 507: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 508: fnd_message.set_token('MESSAGE', l_msgData);

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;

Line 528: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

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;

Line 529: fnd_message.set_token('MESSAGE', l_msgData);

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;