167: l_email_sub := 'INVALID SERVICE REQUEST!';
168: END;
169:
170: --Message ASP_SERVICE_SMS_TEXT - Service Request - #
171: fnd_message.set_name('ASP', 'ASP_SERVICE_SMS_TEXT');
172: fnd_message.set_token('SRNUM', l_incident_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
168: END;
169:
170: --Message ASP_SERVICE_SMS_TEXT - Service Request - #
171: fnd_message.set_name('ASP', 'ASP_SERVICE_SMS_TEXT');
172: fnd_message.set_token('SRNUM', l_incident_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
169:
170: --Message ASP_SERVICE_SMS_TEXT - Service Request - #
171: fnd_message.set_name('ASP', 'ASP_SERVICE_SMS_TEXT');
172: fnd_message.set_token('SRNUM', l_incident_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
177: --fnd_message.set_token('CUSTID', to_char(l_customer_id));
170: --Message ASP_SERVICE_SMS_TEXT - Service Request - #
171: fnd_message.set_name('ASP', 'ASP_SERVICE_SMS_TEXT');
172: fnd_message.set_token('SRNUM', l_incident_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
177: --fnd_message.set_token('CUSTID', to_char(l_customer_id));
178: l_sms_text := fnd_message.get;
171: fnd_message.set_name('ASP', 'ASP_SERVICE_SMS_TEXT');
172: fnd_message.set_token('SRNUM', l_incident_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
177: --fnd_message.set_token('CUSTID', to_char(l_customer_id));
178: l_sms_text := fnd_message.get;
179:
172: fnd_message.set_token('SRNUM', l_incident_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
177: --fnd_message.set_token('CUSTID', to_char(l_customer_id));
178: l_sms_text := fnd_message.get;
179:
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
177: --fnd_message.set_token('CUSTID', to_char(l_customer_id));
178: l_sms_text := fnd_message.get;
179:
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
181:
174: fnd_message.set_token('REPNAME', l_sr_owner);
175: fnd_message.set_token('STATUS', l_sr_status);
176: fnd_message.set_token('ESCLEVEL', l_esc_level);
177: --fnd_message.set_token('CUSTID', to_char(l_customer_id));
178: l_sms_text := fnd_message.get;
179:
180: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
181:
182: --***Done SMS Content
187:
188: --***EMAIL Content
189: --Message ASP_SERVICE_EMAIL_SUB - Service Request #
190:
191: fnd_message.set_name('ASP', 'ASP_SERVICE_EMAIL_SUB');
192: fnd_message.set_token('SRNUM', l_incident_number);
193: fnd_message.set_token('CUSTNAME', l_customer_name);
194: l_email_sub := fnd_message.get;
195:
188: --***EMAIL Content
189: --Message ASP_SERVICE_EMAIL_SUB - Service Request #
190:
191: fnd_message.set_name('ASP', 'ASP_SERVICE_EMAIL_SUB');
192: fnd_message.set_token('SRNUM', l_incident_number);
193: fnd_message.set_token('CUSTNAME', l_customer_name);
194: l_email_sub := fnd_message.get;
195:
196:
189: --Message ASP_SERVICE_EMAIL_SUB - Service Request #
190:
191: fnd_message.set_name('ASP', 'ASP_SERVICE_EMAIL_SUB');
192: fnd_message.set_token('SRNUM', l_incident_number);
193: fnd_message.set_token('CUSTNAME', l_customer_name);
194: l_email_sub := fnd_message.get;
195:
196:
197:
190:
191: fnd_message.set_name('ASP', 'ASP_SERVICE_EMAIL_SUB');
192: fnd_message.set_token('SRNUM', l_incident_number);
193: fnd_message.set_token('CUSTNAME', l_customer_name);
194: l_email_sub := fnd_message.get;
195:
196:
197:
198: wf_engine.SetItemAttrText(itemtype, itemkey, 'INCIDENTID', l_incident_id);