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 218: fnd_message.set_name('WIP', 'WIP_ML_JOB_NAME');

214:
215:
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,

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

215:
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,

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

242:
243:
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,

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

243:
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,

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

277:
278:
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,

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

278:
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,

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

312: --serial number must exist in organization
313: -- must be:
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,

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

313: -- must be:
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,

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

514: --If genealogy of one asset fails
515: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
516: l_errMsg := 'genealogy failed';
517: if(l_msgData is not null) then
518: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
519: fnd_message.set_token('MESSAGE', l_msgData);
520: fnd_msg_pub.add; --add the returned error message to the stack.
521: end if;
522: raise fnd_api.g_exc_unexpected_error;

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

515: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
516: l_errMsg := 'genealogy failed';
517: if(l_msgData is not null) then
518: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
519: fnd_message.set_token('MESSAGE', l_msgData);
520: fnd_msg_pub.add; --add the returned error message to the stack.
521: end if;
522: raise fnd_api.g_exc_unexpected_error;
523: end if;

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

569:
570: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
571: l_errMsg := 'genealogy failed';
572: if(l_msgData is not null) then
573: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
574: fnd_message.set_token('MESSAGE', l_msgData);
575: fnd_msg_pub.add; --add the returned error message to the stack.
576: end if;
577: raise fnd_api.g_exc_unexpected_error;

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

570: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
571: l_errMsg := 'genealogy failed';
572: if(l_msgData is not null) then
573: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
574: fnd_message.set_token('MESSAGE', l_msgData);
575: fnd_msg_pub.add; --add the returned error message to the stack.
576: end if;
577: raise fnd_api.g_exc_unexpected_error;
578: end if;

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

590: eam_rebuild.create_rebuild_job(p_tempId => p_compRec.txnTmpID,
591: x_retVal => x_returnStatus,
592: x_errMsg => l_msgData);
593: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
594: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
595: fnd_message.set_token('MESSAGE', l_msgData);
596: fnd_msg_pub.add; --add the returned error message to the stack.
597: l_errMsg := 'rebuild job creation failed';
598: raise fnd_api.g_exc_unexpected_error;

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

591: x_retVal => x_returnStatus,
592: x_errMsg => l_msgData);
593: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
594: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
595: fnd_message.set_token('MESSAGE', l_msgData);
596: fnd_msg_pub.add; --add the returned error message to the stack.
597: l_errMsg := 'rebuild job creation failed';
598: raise fnd_api.g_exc_unexpected_error;
599: end if;