eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_PRICELIST_APPROVAL_PVT dependencies on FND_MESSAGE

Line 109: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');

105: , l_status_name
106: , l_status_date;
107: CLOSE c_pricelist_rec;
108:
109: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
110: fnd_message.set_token('PRICELIST_NAME', l_name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext(

Line 110: fnd_message.set_token('PRICELIST_NAME', l_name, false);

106: , l_status_date;
107: CLOSE c_pricelist_rec;
108:
109: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
110: fnd_message.set_token('PRICELIST_NAME', l_name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext(
114: itemtype => l_item_type

Line 111: l_subject := fnd_message.get;

107: CLOSE c_pricelist_rec;
108:
109: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
110: fnd_message.set_token('PRICELIST_NAME', l_name, false);
111: l_subject := fnd_message.get;
112:
113: wf_engine.setitemattrtext(
114: itemtype => l_item_type
115: ,itemkey => l_item_key

Line 120: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_INFO');

116: ,aname => 'FYI_SUBJECT'
117: ,avalue => l_subject
118: );
119:
120: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_INFO');
121: fnd_message.set_token('APPROVER_NAME', l_approver, false);
122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);

Line 121: fnd_message.set_token('APPROVER_NAME', l_approver, false);

117: ,avalue => l_subject
118: );
119:
120: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_INFO');
121: fnd_message.set_token('APPROVER_NAME', l_approver, false);
122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 122: fnd_message.set_token('PRICELIST_NAME', l_name, false);

118: );
119:
120: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_INFO');
121: fnd_message.set_token('APPROVER_NAME', l_approver, false);
122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
126: fnd_message.set_token('DESCRIPTION', l_description, false);

Line 123: fnd_message.set_token('START_DATE', l_start_date, false);

119:
120: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_INFO');
121: fnd_message.set_token('APPROVER_NAME', l_approver, false);
122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
126: fnd_message.set_token('DESCRIPTION', l_description, false);
127:

Line 124: fnd_message.set_token('END_DATE', l_end_date, false);

120: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_INFO');
121: fnd_message.set_token('APPROVER_NAME', l_approver, false);
122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
126: fnd_message.set_token('DESCRIPTION', l_description, false);
127:
128: l_body := fnd_message.get;

Line 125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

121: fnd_message.set_token('APPROVER_NAME', l_approver, false);
122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
126: fnd_message.set_token('DESCRIPTION', l_description, false);
127:
128: l_body := fnd_message.get;
129: l_fyi_notification := l_body;

Line 126: fnd_message.set_token('DESCRIPTION', l_description, false);

122: fnd_message.set_token('PRICELIST_NAME', l_name, false);
123: fnd_message.set_token('START_DATE', l_start_date, false);
124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
126: fnd_message.set_token('DESCRIPTION', l_description, false);
127:
128: l_body := fnd_message.get;
129: l_fyi_notification := l_body;
130: document := document || l_fyi_notification;

Line 128: l_body := fnd_message.get;

124: fnd_message.set_token('END_DATE', l_end_date, false);
125: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
126: fnd_message.set_token('DESCRIPTION', l_description, false);
127:
128: l_body := fnd_message.get;
129: l_fyi_notification := l_body;
130: document := document || l_fyi_notification;
131: document_type := 'text/plain';
132: RETURN;

Line 252: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');

248: , l_status_name
249: , l_status_date;
250: CLOSE c_pricelist_rec;
251:
252: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
253: fnd_message.set_token('PRICELIST_NAME', l_name, false);
254: l_subject := fnd_message.get;
255:
256: wf_engine.setitemattrtext(

Line 253: fnd_message.set_token('PRICELIST_NAME', l_name, false);

249: , l_status_date;
250: CLOSE c_pricelist_rec;
251:
252: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
253: fnd_message.set_token('PRICELIST_NAME', l_name, false);
254: l_subject := fnd_message.get;
255:
256: wf_engine.setitemattrtext(
257: itemtype => l_item_type

Line 254: l_subject := fnd_message.get;

250: CLOSE c_pricelist_rec;
251:
252: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
253: fnd_message.set_token('PRICELIST_NAME', l_name, false);
254: l_subject := fnd_message.get;
255:
256: wf_engine.setitemattrtext(
257: itemtype => l_item_type
258: ,itemkey => l_item_key

Line 263: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_INFO');

259: ,aname => 'APP_SUBJECT'
260: ,avalue => l_subject
261: );
262:
263: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_INFO');
264: fnd_message.set_token('REQUESTER', l_requester, false);
265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);

Line 264: fnd_message.set_token('REQUESTER', l_requester, false);

260: ,avalue => l_subject
261: );
262:
263: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_INFO');
264: fnd_message.set_token('REQUESTER', l_requester, false);
265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 265: fnd_message.set_token('PRICELIST_NAME', l_name, false);

261: );
262:
263: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_INFO');
264: fnd_message.set_token('REQUESTER', l_requester, false);
265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
269: fnd_message.set_token('DESCRIPTION', l_description, false);

Line 266: fnd_message.set_token('START_DATE', l_start_date, false);

262:
263: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_INFO');
264: fnd_message.set_token('REQUESTER', l_requester, false);
265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
269: fnd_message.set_token('DESCRIPTION', l_description, false);
270: l_body := fnd_message.get;

Line 267: fnd_message.set_token('END_DATE', l_end_date, false);

263: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_INFO');
264: fnd_message.set_token('REQUESTER', l_requester, false);
265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
269: fnd_message.set_token('DESCRIPTION', l_description, false);
270: l_body := fnd_message.get;
271:

Line 268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

264: fnd_message.set_token('REQUESTER', l_requester, false);
265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
269: fnd_message.set_token('DESCRIPTION', l_description, false);
270: l_body := fnd_message.get;
271:
272: document := document || l_body;

Line 269: fnd_message.set_token('DESCRIPTION', l_description, false);

265: fnd_message.set_token('PRICELIST_NAME', l_name, false);
266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
269: fnd_message.set_token('DESCRIPTION', l_description, false);
270: l_body := fnd_message.get;
271:
272: document := document || l_body;
273: document_type := 'text/plain';

Line 270: l_body := fnd_message.get;

266: fnd_message.set_token('START_DATE', l_start_date, false);
267: fnd_message.set_token('END_DATE', l_end_date, false);
268: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
269: fnd_message.set_token('DESCRIPTION', l_description, false);
270: l_body := fnd_message.get;
271:
272: document := document || l_body;
273: document_type := 'text/plain';
274: RETURN;

Line 389: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_SUBJ');

385: , l_status_name
386: , l_status_date;
387: CLOSE c_pricelist_rec;
388:
389: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_SUBJ');
390: fnd_message.set_token('PRICELIST_NAME', l_name, false);
391: l_subject := fnd_message.get;
392:
393: wf_engine.setitemattrtext(

Line 390: fnd_message.set_token('PRICELIST_NAME', l_name, false);

386: , l_status_date;
387: CLOSE c_pricelist_rec;
388:
389: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_SUBJ');
390: fnd_message.set_token('PRICELIST_NAME', l_name, false);
391: l_subject := fnd_message.get;
392:
393: wf_engine.setitemattrtext(
394: itemtype => l_item_type

Line 391: l_subject := fnd_message.get;

387: CLOSE c_pricelist_rec;
388:
389: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_SUBJ');
390: fnd_message.set_token('PRICELIST_NAME', l_name, false);
391: l_subject := fnd_message.get;
392:
393: wf_engine.setitemattrtext(
394: itemtype => l_item_type
395: ,itemkey => l_item_key

Line 400: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_INFO');

396: ,aname => 'APP_SUBJECT'
397: ,avalue => l_subject
398: );
399:
400: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_INFO');
401: fnd_message.set_token('REQUESTER', l_requester, false);
402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);

Line 401: fnd_message.set_token('REQUESTER', l_requester, false);

397: ,avalue => l_subject
398: );
399:
400: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_INFO');
401: fnd_message.set_token('REQUESTER', l_requester, false);
402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 402: fnd_message.set_token('PRICELIST_NAME', l_name, false);

398: );
399:
400: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_INFO');
401: fnd_message.set_token('REQUESTER', l_requester, false);
402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
406: fnd_message.set_token('DESCRIPTION', l_description, false);

Line 403: fnd_message.set_token('START_DATE', l_start_date, false);

399:
400: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_INFO');
401: fnd_message.set_token('REQUESTER', l_requester, false);
402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
406: fnd_message.set_token('DESCRIPTION', l_description, false);
407: l_body := fnd_message.get;

Line 404: fnd_message.set_token('END_DATE', l_end_date, false);

400: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPR_REM_INFO');
401: fnd_message.set_token('REQUESTER', l_requester, false);
402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
406: fnd_message.set_token('DESCRIPTION', l_description, false);
407: l_body := fnd_message.get;
408:

Line 405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

401: fnd_message.set_token('REQUESTER', l_requester, false);
402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
406: fnd_message.set_token('DESCRIPTION', l_description, false);
407: l_body := fnd_message.get;
408:
409: document := document || l_body;

Line 406: fnd_message.set_token('DESCRIPTION', l_description, false);

402: fnd_message.set_token('PRICELIST_NAME', l_name, false);
403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
406: fnd_message.set_token('DESCRIPTION', l_description, false);
407: l_body := fnd_message.get;
408:
409: document := document || l_body;
410: document_type := 'text/plain';

Line 407: l_body := fnd_message.get;

403: fnd_message.set_token('START_DATE', l_start_date, false);
404: fnd_message.set_token('END_DATE', l_end_date, false);
405: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
406: fnd_message.set_token('DESCRIPTION', l_description, false);
407: l_body := fnd_message.get;
408:
409: document := document || l_body;
410: document_type := 'text/plain';
411: RETURN;

Line 526: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');

522: , l_status_name
523: , l_status_date;
524: CLOSE c_pricelist_rec;
525:
526: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
527: fnd_message.set_token('PRICELIST_NAME', l_name, false);
528: l_subject := fnd_message.get;
529:
530: wf_engine.setitemattrtext(

Line 527: fnd_message.set_token('PRICELIST_NAME', l_name, false);

523: , l_status_date;
524: CLOSE c_pricelist_rec;
525:
526: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
527: fnd_message.set_token('PRICELIST_NAME', l_name, false);
528: l_subject := fnd_message.get;
529:
530: wf_engine.setitemattrtext(
531: itemtype => l_item_type

Line 528: l_subject := fnd_message.get;

524: CLOSE c_pricelist_rec;
525:
526: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
527: fnd_message.set_token('PRICELIST_NAME', l_name, false);
528: l_subject := fnd_message.get;
529:
530: wf_engine.setitemattrtext(
531: itemtype => l_item_type
532: ,itemkey => l_item_key

Line 537: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_INFO');

533: ,aname => 'APRV_SUBJECT'
534: ,avalue => l_subject
535: );
536:
537: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_INFO');
538: fnd_message.set_token('APPROVER_NAME', l_approver, false);
539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);

Line 538: fnd_message.set_token('APPROVER_NAME', l_approver, false);

534: ,avalue => l_subject
535: );
536:
537: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_INFO');
538: fnd_message.set_token('APPROVER_NAME', l_approver, false);
539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 539: fnd_message.set_token('PRICELIST_NAME', l_name, false);

535: );
536:
537: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_INFO');
538: fnd_message.set_token('APPROVER_NAME', l_approver, false);
539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
543: fnd_message.set_token('DESCRIPTION', l_description, false);

Line 540: fnd_message.set_token('START_DATE', l_start_date, false);

536:
537: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_INFO');
538: fnd_message.set_token('APPROVER_NAME', l_approver, false);
539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
543: fnd_message.set_token('DESCRIPTION', l_description, false);
544: l_body := fnd_message.get;

Line 541: fnd_message.set_token('END_DATE', l_end_date, false);

537: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_INFO');
538: fnd_message.set_token('APPROVER_NAME', l_approver, false);
539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
543: fnd_message.set_token('DESCRIPTION', l_description, false);
544: l_body := fnd_message.get;
545:

Line 542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

538: fnd_message.set_token('APPROVER_NAME', l_approver, false);
539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
543: fnd_message.set_token('DESCRIPTION', l_description, false);
544: l_body := fnd_message.get;
545:
546: document := document || l_body;

Line 543: fnd_message.set_token('DESCRIPTION', l_description, false);

539: fnd_message.set_token('PRICELIST_NAME', l_name, false);
540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
543: fnd_message.set_token('DESCRIPTION', l_description, false);
544: l_body := fnd_message.get;
545:
546: document := document || l_body;
547: document_type := 'text/plain';

Line 544: l_body := fnd_message.get;

540: fnd_message.set_token('START_DATE', l_start_date, false);
541: fnd_message.set_token('END_DATE', l_end_date, false);
542: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
543: fnd_message.set_token('DESCRIPTION', l_description, false);
544: l_body := fnd_message.get;
545:
546: document := document || l_body;
547: document_type := 'text/plain';
548: RETURN;

Line 663: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');

659: , l_status_name
660: , l_status_date;
661: CLOSE c_pricelist_rec;
662:
663: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
664: fnd_message.set_token('PRICELIST_NAME', l_name, false);
665: l_subject := fnd_message.get;
666:
667: wf_engine.setitemattrtext(

Line 664: fnd_message.set_token('PRICELIST_NAME', l_name, false);

660: , l_status_date;
661: CLOSE c_pricelist_rec;
662:
663: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
664: fnd_message.set_token('PRICELIST_NAME', l_name, false);
665: l_subject := fnd_message.get;
666:
667: wf_engine.setitemattrtext(
668: itemtype => l_item_type

Line 665: l_subject := fnd_message.get;

661: CLOSE c_pricelist_rec;
662:
663: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
664: fnd_message.set_token('PRICELIST_NAME', l_name, false);
665: l_subject := fnd_message.get;
666:
667: wf_engine.setitemattrtext(
668: itemtype => l_item_type
669: ,itemkey => l_item_key

Line 674: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_INFO');

670: ,aname => 'REJECT_SUBJECT'
671: ,avalue => l_subject
672: );
673:
674: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_INFO');
675: fnd_message.set_token('APPROVER_NAME', l_approver, false);
676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);

Line 675: fnd_message.set_token('APPROVER_NAME', l_approver, false);

671: ,avalue => l_subject
672: );
673:
674: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_INFO');
675: fnd_message.set_token('APPROVER_NAME', l_approver, false);
676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

Line 676: fnd_message.set_token('PRICELIST_NAME', l_name, false);

672: );
673:
674: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_INFO');
675: fnd_message.set_token('APPROVER_NAME', l_approver, false);
676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
680: fnd_message.set_token('DESCRIPTION', l_description, false);

Line 677: fnd_message.set_token('START_DATE', l_start_date, false);

673:
674: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_INFO');
675: fnd_message.set_token('APPROVER_NAME', l_approver, false);
676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
680: fnd_message.set_token('DESCRIPTION', l_description, false);
681: l_body := fnd_message.get;

Line 678: fnd_message.set_token('END_DATE', l_end_date, false);

674: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_INFO');
675: fnd_message.set_token('APPROVER_NAME', l_approver, false);
676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
680: fnd_message.set_token('DESCRIPTION', l_description, false);
681: l_body := fnd_message.get;
682:

Line 679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);

675: fnd_message.set_token('APPROVER_NAME', l_approver, false);
676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
680: fnd_message.set_token('DESCRIPTION', l_description, false);
681: l_body := fnd_message.get;
682:
683: document := document || l_body;

Line 680: fnd_message.set_token('DESCRIPTION', l_description, false);

676: fnd_message.set_token('PRICELIST_NAME', l_name, false);
677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
680: fnd_message.set_token('DESCRIPTION', l_description, false);
681: l_body := fnd_message.get;
682:
683: document := document || l_body;
684: document_type := 'text/plain';

Line 681: l_body := fnd_message.get;

677: fnd_message.set_token('START_DATE', l_start_date, false);
678: fnd_message.set_token('END_DATE', l_end_date, false);
679: fnd_message.set_token('CURRENCY_CODE', l_currency, false);
680: fnd_message.set_token('DESCRIPTION', l_description, false);
681: l_body := fnd_message.get;
682:
683: document := document || l_body;
684: document_type := 'text/plain';
685: RETURN;

Line 805: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');

801: ,aname => 'AMS_APPROVER_SEQ'
802: ,avalue => l_approver_seq
803: );
804:
805: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
806: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
807: l_subject := fnd_message.get;
808:
809: wf_engine.setitemattrtext(

Line 806: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);

802: ,avalue => l_approver_seq
803: );
804:
805: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
806: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
807: l_subject := fnd_message.get;
808:
809: wf_engine.setitemattrtext(
810: itemtype => itemtype

Line 807: l_subject := fnd_message.get;

803: );
804:
805: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_FORWARD_SUBJ');
806: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
807: l_subject := fnd_message.get;
808:
809: wf_engine.setitemattrtext(
810: itemtype => itemtype
811: ,itemkey => itemkey

Line 816: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');

812: ,aname => 'FYI_SUBJECT'
813: ,avalue => l_subject
814: );
815:
816: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
817: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
818: l_subject := fnd_message.get;
819:
820: wf_engine.setitemattrtext(

Line 817: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);

813: ,avalue => l_subject
814: );
815:
816: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
817: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
818: l_subject := fnd_message.get;
819:
820: wf_engine.setitemattrtext(
821: itemtype => itemtype

Line 818: l_subject := fnd_message.get;

814: );
815:
816: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVAL_SUBJ');
817: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
818: l_subject := fnd_message.get;
819:
820: wf_engine.setitemattrtext(
821: itemtype => itemtype
822: ,itemkey => itemkey

Line 827: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');

823: ,aname => 'APP_SUBJECT'
824: ,avalue => l_subject
825: );
826:
827: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
828: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
829: l_subject := fnd_message.get;
830:
831: wf_engine.setitemattrtext(

Line 828: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);

824: ,avalue => l_subject
825: );
826:
827: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
828: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
829: l_subject := fnd_message.get;
830:
831: wf_engine.setitemattrtext(
832: itemtype => itemtype

Line 829: l_subject := fnd_message.get;

825: );
826:
827: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_APPROVED_SUBJ');
828: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
829: l_subject := fnd_message.get;
830:
831: wf_engine.setitemattrtext(
832: itemtype => itemtype
833: ,itemkey => itemkey

Line 838: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');

834: ,aname => 'APRV_SUBJECT'
835: ,avalue => l_subject
836: );
837:
838: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
839: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
840: l_subject := fnd_message.get;
841:
842: wf_engine.setitemattrtext(

Line 839: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);

835: ,avalue => l_subject
836: );
837:
838: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
839: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
840: l_subject := fnd_message.get;
841:
842: wf_engine.setitemattrtext(
843: itemtype => itemtype

Line 840: l_subject := fnd_message.get;

836: );
837:
838: fnd_message.set_name('OZF', 'OZF_PRICLST_NTF_REJECTED_SUBJ');
839: fnd_message.set_token('PRICELIST_NAME', l_object_details.name, false);
840: l_subject := fnd_message.get;
841:
842: wf_engine.setitemattrtext(
843: itemtype => itemtype
844: ,itemkey => itemkey