DBA Data[Home] [Help]

APPS.ASP_ORDER_CONTENT_PROVIDER dependencies on FND_MESSAGE

Line 158: fnd_message.set_name('ASP', 'ASP_ORDER_SMS_TEXT');

154: l_email_sub := 'INVALID BSA!';
155: END;
156:
157: --Message ASP_ORDER_SMS_TEXT - Blanket Sales Agreement # for customer '' expires on .
158: fnd_message.set_name('ASP', 'ASP_ORDER_SMS_TEXT');
159: fnd_message.set_token('BSANUM', to_char(l_blanket_number));
160: fnd_message.set_token('CUSTNAME', l_customer_name);
161: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
162: l_sms_text := fnd_message.get;

Line 159: fnd_message.set_token('BSANUM', to_char(l_blanket_number));

155: END;
156:
157: --Message ASP_ORDER_SMS_TEXT - Blanket Sales Agreement # for customer '' expires on .
158: fnd_message.set_name('ASP', 'ASP_ORDER_SMS_TEXT');
159: fnd_message.set_token('BSANUM', to_char(l_blanket_number));
160: fnd_message.set_token('CUSTNAME', l_customer_name);
161: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
162: l_sms_text := fnd_message.get;
163:

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

156:
157: --Message ASP_ORDER_SMS_TEXT - Blanket Sales Agreement # for customer '' expires on .
158: fnd_message.set_name('ASP', 'ASP_ORDER_SMS_TEXT');
159: fnd_message.set_token('BSANUM', to_char(l_blanket_number));
160: fnd_message.set_token('CUSTNAME', l_customer_name);
161: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
162: l_sms_text := fnd_message.get;
163:
164: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);

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

157: --Message ASP_ORDER_SMS_TEXT - Blanket Sales Agreement # for customer '' expires on .
158: fnd_message.set_name('ASP', 'ASP_ORDER_SMS_TEXT');
159: fnd_message.set_token('BSANUM', to_char(l_blanket_number));
160: fnd_message.set_token('CUSTNAME', l_customer_name);
161: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
162: l_sms_text := fnd_message.get;
163:
164: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
165: --***Done SMS Content

Line 162: l_sms_text := fnd_message.get;

158: fnd_message.set_name('ASP', 'ASP_ORDER_SMS_TEXT');
159: fnd_message.set_token('BSANUM', to_char(l_blanket_number));
160: fnd_message.set_token('CUSTNAME', l_customer_name);
161: fnd_message.set_token('EXPDATE', to_char( l_expiration_date, 'DD-Mon-YYYY HH24:MI:SS'));
162: l_sms_text := fnd_message.get;
163:
164: wf_engine.SetItemAttrText(itemtype, itemkey, 'SMS_TEXT', l_sms_text);
165: --***Done SMS Content
166: if(l_debug_procedure >= l_debug_runtime) then

Line 173: fnd_message.set_name('ASP', 'ASP_ORDER_EMAIL_SUB');

169:
170: --***EMAIL Content
171: --Message ASP_ORDER_EMAIL_SUB - Blanket Sales Agreement # for customer '' expires shortly
172:
173: fnd_message.set_name('ASP', 'ASP_ORDER_EMAIL_SUB');
174: fnd_message.set_token('BSANUM', l_blanket_number);
175: fnd_message.set_token('CUSTNAME', l_customer_name);
176: l_email_sub := fnd_message.get;
177:

Line 174: fnd_message.set_token('BSANUM', l_blanket_number);

170: --***EMAIL Content
171: --Message ASP_ORDER_EMAIL_SUB - Blanket Sales Agreement # for customer '' expires shortly
172:
173: fnd_message.set_name('ASP', 'ASP_ORDER_EMAIL_SUB');
174: fnd_message.set_token('BSANUM', l_blanket_number);
175: fnd_message.set_token('CUSTNAME', l_customer_name);
176: l_email_sub := fnd_message.get;
177:
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'BLANKETHDRID', l_blanket_header_id);

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

171: --Message ASP_ORDER_EMAIL_SUB - Blanket Sales Agreement # for customer '' expires shortly
172:
173: fnd_message.set_name('ASP', 'ASP_ORDER_EMAIL_SUB');
174: fnd_message.set_token('BSANUM', l_blanket_number);
175: fnd_message.set_token('CUSTNAME', l_customer_name);
176: l_email_sub := fnd_message.get;
177:
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'BLANKETHDRID', l_blanket_header_id);
179: --WF_Attr BLANKETHDRID => Msg_Attr MSG_BLANKETHDRID

Line 176: l_email_sub := fnd_message.get;

172:
173: fnd_message.set_name('ASP', 'ASP_ORDER_EMAIL_SUB');
174: fnd_message.set_token('BSANUM', l_blanket_number);
175: fnd_message.set_token('CUSTNAME', l_customer_name);
176: l_email_sub := fnd_message.get;
177:
178: wf_engine.SetItemAttrText(itemtype, itemkey, 'BLANKETHDRID', l_blanket_header_id);
179: --WF_Attr BLANKETHDRID => Msg_Attr MSG_BLANKETHDRID
180: