108:
109: end if;
110:
111: -- Retrieve the notifation message and set the tokens.
112: fnd_message.set_name('CSD','CSD_RMA_RCPT_NOTF_MSG');
113: fnd_message.set_token('CONTACT_NAME',l_contact_name);
114: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
109: end if;
110:
111: -- Retrieve the notifation message and set the tokens.
112: fnd_message.set_name('CSD','CSD_RMA_RCPT_NOTF_MSG');
113: fnd_message.set_token('CONTACT_NAME',l_contact_name);
114: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
117: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
110:
111: -- Retrieve the notifation message and set the tokens.
112: fnd_message.set_name('CSD','CSD_RMA_RCPT_NOTF_MSG');
113: fnd_message.set_token('CONTACT_NAME',l_contact_name);
114: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
117: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
118:
111: -- Retrieve the notifation message and set the tokens.
112: fnd_message.set_name('CSD','CSD_RMA_RCPT_NOTF_MSG');
113: fnd_message.set_token('CONTACT_NAME',l_contact_name);
114: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
117: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
118:
119: l_msg_text := fnd_message.get;
112: fnd_message.set_name('CSD','CSD_RMA_RCPT_NOTF_MSG');
113: fnd_message.set_token('CONTACT_NAME',l_contact_name);
114: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
117: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
118:
119: l_msg_text := fnd_message.get;
120:
113: fnd_message.set_token('CONTACT_NAME',l_contact_name);
114: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
117: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
118:
119: l_msg_text := fnd_message.get;
120:
121: IF l_wf_role IS NOT NULL THEN
115: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
116: fnd_message.set_token('ITEM_NAME',l_item_name);
117: fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
118:
119: l_msg_text := fnd_message.get;
120:
121: IF l_wf_role IS NOT NULL THEN
122:
123: --FND_LOG.STRING(Fnd_Log.Level_Procedure,lc_mod_name,'setItemAttrText');
257:
258: end if;
259:
260: -- Retrieve the notifation message and set the tokens.
261: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
262: fnd_message.set_token('CONTACT_NAME',l_contact_name);
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
258: end if;
259:
260: -- Retrieve the notifation message and set the tokens.
261: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
262: fnd_message.set_token('CONTACT_NAME',l_contact_name);
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
259:
260: -- Retrieve the notifation message and set the tokens.
261: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
262: fnd_message.set_token('CONTACT_NAME',l_contact_name);
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
267: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
260: -- Retrieve the notifation message and set the tokens.
261: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
262: fnd_message.set_token('CONTACT_NAME',l_contact_name);
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
267: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
268:
261: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
262: fnd_message.set_token('CONTACT_NAME',l_contact_name);
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
267: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
268:
269: l_msg_text := fnd_message.get;
262: fnd_message.set_token('CONTACT_NAME',l_contact_name);
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
267: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
268:
269: l_msg_text := fnd_message.get;
270:
263: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
264: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
267: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
268:
269: l_msg_text := fnd_message.get;
270:
271: IF l_wf_role IS NOT NULL THEN
265: fnd_message.set_token('ITEM_NAME',l_item_name);
266: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
267: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
268:
269: l_msg_text := fnd_message.get;
270:
271: IF l_wf_role IS NOT NULL THEN
272:
273: --FND_LOG.STRING(Fnd_Log.Level_Procedure,lc_mod_name,'setItemAttrText');
368:
369: IF (l_wf_role is not null and l_owner_email is not null) THEN
370:
371: -- Retrieve the notifation message and set the tokens.
372: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
373: fnd_message.set_token('CONTACT_NAME',l_contact_name);
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
369: IF (l_wf_role is not null and l_owner_email is not null) THEN
370:
371: -- Retrieve the notifation message and set the tokens.
372: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
373: fnd_message.set_token('CONTACT_NAME',l_contact_name);
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
370:
371: -- Retrieve the notifation message and set the tokens.
372: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
373: fnd_message.set_token('CONTACT_NAME',l_contact_name);
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
378: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
371: -- Retrieve the notifation message and set the tokens.
372: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
373: fnd_message.set_token('CONTACT_NAME',l_contact_name);
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
378: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
379:
372: fnd_message.set_name('CSD','CSD_RO_STATUS_NOTF_MSG');
373: fnd_message.set_token('CONTACT_NAME',l_contact_name);
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
378: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
379:
380: l_msg_text := fnd_message.get;
373: fnd_message.set_token('CONTACT_NAME',l_contact_name);
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
378: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
379:
380: l_msg_text := fnd_message.get;
381:
374: fnd_message.set_token('SERVICE_REQUEST',l_incident_number);
375: fnd_message.set_token('REPAIR_ORDER',l_repair_number);
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
378: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
379:
380: l_msg_text := fnd_message.get;
381:
382: --FND_LOG.STRING(Fnd_Log.Level_Procedure,lc_mod_name,'setItemAttrText');
376: fnd_message.set_token('ITEM_NAME',l_item_name);
377: --fnd_message.set_token('SERIAL_NUMBER',l_serial_number);
378: --fnd_message.set_token('CURRENT_RO_STATUS',l_flow_status);
379:
380: l_msg_text := fnd_message.get;
381:
382: --FND_LOG.STRING(Fnd_Log.Level_Procedure,lc_mod_name,'setItemAttrText');
383:
384: wf_engine.setItemAttrText