DBA Data[Home] [Help]

APPS.ASP_INVOICE_CONTENT_PROVIDER dependencies on FND_MESSAGE

Line 156: fnd_message.set_name('ASP', 'ASP_INVOICE_SMS_TEXT');

152: l_email_sub := 'INVALID DELINQUENT INVOICE!';
153: END;
154:
155: --Message ASP_INVOICE_SMS_TEXT - Customer '' has overdue invoice. Transaction is past due date
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;

Line 157: fnd_message.set_token('CUSTNAME', l_customer_name);

153: END;
154:
155: --Message ASP_INVOICE_SMS_TEXT - Customer '' has overdue invoice. Transaction is past due date
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:

Line 158: fnd_message.set_token('TXNNUM', l_transaction_number);

154:
155: --Message ASP_INVOICE_SMS_TEXT - Customer '' has overdue invoice. Transaction is past due date
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);

Line 159: fnd_message.set_token('DUEDATE', to_char( l_due_date, 'DD-Mon-YYYY HH24:MI:SS'));

155: --Message ASP_INVOICE_SMS_TEXT - Customer '' has overdue invoice. Transaction is past due date
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

Line 160: l_sms_text := fnd_message.get;

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

Line 171: fnd_message.set_name('ASP', 'ASP_INVOICE_EMAIL_SUB');

167:
168: --***EMAIL Content
169: --Message ASP_INVOICE_EMAIL_SUB - Overdue invoice # for
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:

Line 172: fnd_message.set_token('TXNNUM', l_transaction_number);

168: --***EMAIL Content
169: --Message ASP_INVOICE_EMAIL_SUB - Overdue invoice # for
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);

Line 173: fnd_message.set_token('CUSTNAME', l_customer_name);

169: --Message ASP_INVOICE_EMAIL_SUB - Overdue invoice # for
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

Line 174: l_email_sub := fnd_message.get;

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: