150: l_email_sub := 'INVALID SERVICE CONTRACT!';
151: END;
152:
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract #
154: fnd_message.set_name('ASP', 'ASP_SVCCON_SMS_TEXT');
155: fnd_message.set_token('CONTRACTNUM', l_contract_number);
156: fnd_message.set_token('CUSTNAME', l_customer_name);
157: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
158: l_sms_text := fnd_message.get;
151: END;
152:
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract #
154: fnd_message.set_name('ASP', 'ASP_SVCCON_SMS_TEXT');
155: fnd_message.set_token('CONTRACTNUM', l_contract_number);
156: fnd_message.set_token('CUSTNAME', l_customer_name);
157: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
158: l_sms_text := fnd_message.get;
159:
152:
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract #
154: fnd_message.set_name('ASP', 'ASP_SVCCON_SMS_TEXT');
155: fnd_message.set_token('CONTRACTNUM', l_contract_number);
156: fnd_message.set_token('CUSTNAME', l_customer_name);
157: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
158: l_sms_text := fnd_message.get;
159:
160: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract #
154: fnd_message.set_name('ASP', 'ASP_SVCCON_SMS_TEXT');
155: fnd_message.set_token('CONTRACTNUM', l_contract_number);
156: fnd_message.set_token('CUSTNAME', l_customer_name);
157: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
158: l_sms_text := fnd_message.get;
159:
160: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
161: --***Done SMS Content
154: fnd_message.set_name('ASP', 'ASP_SVCCON_SMS_TEXT');
155: fnd_message.set_token('CONTRACTNUM', l_contract_number);
156: fnd_message.set_token('CUSTNAME', l_customer_name);
157: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
158: l_sms_text := fnd_message.get;
159:
160: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
161: --***Done SMS Content
162: if(l_debug_procedure >= l_debug_runtime) then
165:
166: --***EMAIL Content
167: --Message ASP_SVCCON_EMAIL_SUB - Contract #
168:
169: fnd_message.set_name('ASP', 'ASP_SVCCON_EMAIL_SUB');
170: fnd_message.set_token('CONTRACTNUM', l_contract_number);
171: fnd_message.set_token('CUSTNAME', l_customer_name);
172: l_email_sub := fnd_message.get;
173:
166: --***EMAIL Content
167: --Message ASP_SVCCON_EMAIL_SUB - Contract #
168:
169: fnd_message.set_name('ASP', 'ASP_SVCCON_EMAIL_SUB');
170: fnd_message.set_token('CONTRACTNUM', l_contract_number);
171: fnd_message.set_token('CUSTNAME', l_customer_name);
172: l_email_sub := fnd_message.get;
173:
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'CONTRACTID', l_contract_header_id);
167: --Message ASP_SVCCON_EMAIL_SUB - Contract #
168:
169: fnd_message.set_name('ASP', 'ASP_SVCCON_EMAIL_SUB');
170: fnd_message.set_token('CONTRACTNUM', l_contract_number);
171: fnd_message.set_token('CUSTNAME', l_customer_name);
172: l_email_sub := fnd_message.get;
173:
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'CONTRACTID', l_contract_header_id);
175: --WF_Attr CONTRACTID => Msg_Attr MSG_CONTRACTID
168:
169: fnd_message.set_name('ASP', 'ASP_SVCCON_EMAIL_SUB');
170: fnd_message.set_token('CONTRACTNUM', l_contract_number);
171: fnd_message.set_token('CUSTNAME', l_customer_name);
172: l_email_sub := fnd_message.get;
173:
174: wf_engine.SetItemAttrText(itemtype, itemkey, 'CONTRACTID', l_contract_header_id);
175: --WF_Attr CONTRACTID => Msg_Attr MSG_CONTRACTID
176: