DBA Data[Home] [Help]

APPS.ASP_SVCCONT_CONTENT_PROVIDER dependencies on FND_MESSAGE

Line 154: fnd_message.set_name('ASP', 'ASP_SVCCON_SMS_TEXT');

150: l_email_sub := 'INVALID SERVICE CONTRACT!';
151: END;
152:
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract # for customer '' expires on .
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;

Line 155: fnd_message.set_token('CONTRACTNUM', l_contract_number);

151: END;
152:
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract # for customer '' expires on .
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:

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

152:
153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract # for customer '' expires on .
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);

Line 157: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));

153: --Message ASP_SVCCON_SMS_TEXT - Non-renewed contract # for customer '' expires on .
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

Line 158: l_sms_text := fnd_message.get;

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

Line 169: fnd_message.set_name('ASP', 'ASP_SVCCON_EMAIL_SUB');

165:
166: --***EMAIL Content
167: --Message ASP_SVCCON_EMAIL_SUB - Contract # for customer '' expires shortly
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:

Line 170: fnd_message.set_token('CONTRACTNUM', l_contract_number);

166: --***EMAIL Content
167: --Message ASP_SVCCON_EMAIL_SUB - Contract # for customer '' expires shortly
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);

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

167: --Message ASP_SVCCON_EMAIL_SUB - Contract # for customer '' expires shortly
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

Line 172: l_email_sub := fnd_message.get;

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: