152: l_email_sub := 'INVALID DELINQUENT INVOICE!';
153: END;
154:
155: --Message ASP_INVOICE_SMS_TEXT - Customer '
156: fnd_message.set_name('ASP', 'ASP_INVOICE_SMS_TEXT');
157: fnd_message.set_token('CUSTNAME', l_customer_name);
158: fnd_message.set_token('TXNNUM', l_transaction_number);
159: fnd_message.set_token('DUEDATE', to_char( l_due_date, 'DD-Mon-YYYY HH24:MI:SS'));
160: l_sms_text := fnd_message.get;
153: END;
154:
155: --Message ASP_INVOICE_SMS_TEXT - Customer '
156: fnd_message.set_name('ASP', 'ASP_INVOICE_SMS_TEXT');
157: fnd_message.set_token('CUSTNAME', l_customer_name);
158: fnd_message.set_token('TXNNUM', l_transaction_number);
159: fnd_message.set_token('DUEDATE', to_char( l_due_date, 'DD-Mon-YYYY HH24:MI:SS'));
160: l_sms_text := fnd_message.get;
161:
154:
155: --Message ASP_INVOICE_SMS_TEXT - Customer '
156: fnd_message.set_name('ASP', 'ASP_INVOICE_SMS_TEXT');
157: fnd_message.set_token('CUSTNAME', l_customer_name);
158: fnd_message.set_token('TXNNUM', l_transaction_number);
159: fnd_message.set_token('DUEDATE', to_char( l_due_date, 'DD-Mon-YYYY HH24:MI:SS'));
160: l_sms_text := fnd_message.get;
161:
162: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
155: --Message ASP_INVOICE_SMS_TEXT - Customer '
156: fnd_message.set_name('ASP', 'ASP_INVOICE_SMS_TEXT');
157: fnd_message.set_token('CUSTNAME', l_customer_name);
158: fnd_message.set_token('TXNNUM', l_transaction_number);
159: fnd_message.set_token('DUEDATE', to_char( l_due_date, 'DD-Mon-YYYY HH24:MI:SS'));
160: l_sms_text := fnd_message.get;
161:
162: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
163: --***Done SMS Content
156: fnd_message.set_name('ASP', 'ASP_INVOICE_SMS_TEXT');
157: fnd_message.set_token('CUSTNAME', l_customer_name);
158: fnd_message.set_token('TXNNUM', l_transaction_number);
159: fnd_message.set_token('DUEDATE', to_char( l_due_date, 'DD-Mon-YYYY HH24:MI:SS'));
160: l_sms_text := fnd_message.get;
161:
162: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
163: --***Done SMS Content
164: if(l_debug_procedure >= l_debug_runtime) then
167:
168: --***EMAIL Content
169: --Message ASP_INVOICE_EMAIL_SUB - Overdue invoice #
170:
171: fnd_message.set_name('ASP', 'ASP_INVOICE_EMAIL_SUB');
172: fnd_message.set_token('TXNNUM', l_transaction_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: l_email_sub := fnd_message.get;
175:
168: --***EMAIL Content
169: --Message ASP_INVOICE_EMAIL_SUB - Overdue invoice #
170:
171: fnd_message.set_name('ASP', 'ASP_INVOICE_EMAIL_SUB');
172: fnd_message.set_token('TXNNUM', l_transaction_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: l_email_sub := fnd_message.get;
175:
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'DELINQUENCYID', l_delinquency_id);
169: --Message ASP_INVOICE_EMAIL_SUB - Overdue invoice #
170:
171: fnd_message.set_name('ASP', 'ASP_INVOICE_EMAIL_SUB');
172: fnd_message.set_token('TXNNUM', l_transaction_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: l_email_sub := fnd_message.get;
175:
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'DELINQUENCYID', l_delinquency_id);
177: --WF_Attr DELINQUENCYID => Msg_Attr MSG_DELINQUENCYID
170:
171: fnd_message.set_name('ASP', 'ASP_INVOICE_EMAIL_SUB');
172: fnd_message.set_token('TXNNUM', l_transaction_number);
173: fnd_message.set_token('CUSTNAME', l_customer_name);
174: l_email_sub := fnd_message.get;
175:
176: wf_engine.SetItemAttrText(itemtype, itemkey, 'DELINQUENCYID', l_delinquency_id);
177: --WF_Attr DELINQUENCYID => Msg_Attr MSG_DELINQUENCYID
178: