APPS.PO_WF_REQ_NOTIFICATION_R11 dependencies on FND_MESSAGE

Line 103: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');

99: (itemtype => l_item_type,
100: itemkey => l_item_key,
101: aname => 'REQ_AMOUNT_DSP');
102:
103: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
104:
105:
106: l_description := wf_engine.GetItemAttrText
107: (itemtype => l_item_type,

Line 138: l_document := l_document || '' || NL;

134: if (display_type = 'text/html') then
135:
136: -- l_document := '';
137:
138: l_document := l_document || '

' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') || '

' || NL;
139:
140: l_document := l_document || '' || NL;
141:
142: l_document := l_document || '';

Line 145: l_document := l_document || '

' || NL || '
';

141:
142: l_document := l_document || '

';
143:
144: l_document := l_document || '

' || NL;
145: l_document := l_document || '

' || NL || '
';
146: l_document := l_document || '';
147:
148: l_document := l_document || '

' || NL;
149:

Line 152: l_document := l_document || '

' || NL;
149:
150: l_document := l_document || '';
151:
152: l_document := l_document || '

' || NL;
154: l_document := l_document || '

' || NL;
155:
156: l_document := l_document || '';

Line 158: l_document := l_document || '

' || NL;

154: l_document := l_document || '

' || NL;
155:
156: l_document := l_document || '';
157:
158: l_document := l_document || '

' || NL;
159: l_document := l_document || '

' || NL;
160:
161: l_document := l_document || '';
162:

Line 166: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') ||

162:
163: else
164:
165: l_document := NL1 ||
166: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') ||
167: NL1 || NL1;
168: /*
169: l_document := document || l_document || l_header_msg || NL1 || NL1;
170:

Line 171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');

167: NL1 || NL1;
168: /*
169: l_document := document || l_document || l_header_msg || NL1 || NL1;
170:
171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
172: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL1;
173:
174: if l_description is not null then
175: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;

Line 175: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;

171: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
172: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL1;
173:
174: if l_description is not null then
175: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;
176: l_document := l_document || l_description || NL1;
177: end if;
178:
179: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');

Line 179: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');

175: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;
176: l_document := l_document || l_description || NL1;
177: end if;
178:
179: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');
180: l_document := l_document || ' ' || l_approver || NL1;
181:
182: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
183: l_document := l_document || ' ' || l_preparer || NL1;

Line 182: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');

178:
179: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');
180: l_document := l_document || ' ' || l_approver || NL1;
181:
182: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
183: l_document := l_document || ' ' || l_preparer || NL1;
184:
185: if l_note is not null then
186: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL1;

Line 186: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL1;

182: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
183: l_document := l_document || ' ' || l_preparer || NL1;
184:
185: if l_note is not null then
186: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL1;
187: l_document := l_document || l_note || NL1;
188: end if;
189:
190: */

Line 280: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');

276: (itemtype => l_item_type,
277: itemkey => l_item_key,
278: aname => 'REQ_AMOUNT_DSP');
279:
280: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
281:
282:
283: l_description := wf_engine.GetItemAttrText
284: (itemtype => l_item_type,

Line 315: l_document := l_document || '

' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') || '	' || '(' || l_currency_code || ')' || ' ' || l_req_amount || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || '	' || l_description || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') || 148: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') || 153: '	' || l_preparer || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || '	' || l_preparer || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || '	' || l_note || '

' || NL;

311: if (display_type = 'text/html') then
312:
313: -- l_document := '';
314:
315: l_document := l_document || '

' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') || '

' || NL;
316:
317: l_document := l_document || '' || NL;
318:
319: l_document := l_document || '';

Line 322: l_document := l_document || '

' || NL || '
';

318:
319: l_document := l_document || '

';
320:
321: l_document := l_document || '

' || NL;
322: l_document := l_document || '

' || NL || '
';
323: l_document := l_document || '';
324: l_document := l_document || '

' || NL;
325:
326: l_document := l_document || '';

Line 328: l_document := l_document || '

' || NL;
325:
326: l_document := l_document || '';
327:
328: l_document := l_document || '

' || NL;
330: l_document := l_document || '

' || NL;
331:
332: l_document := l_document || '';

Line 334: l_document := l_document || '

' || NL;

330: l_document := l_document || '

' || NL;
331:
332: l_document := l_document || '';
333:
334: l_document := l_document || '

' || NL;
335: l_document := l_document || '

' || NL;
336:
337: l_document := l_document || '';
338:

Line 349: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') ||

345: 'specified next to Requisition Details. ' || NL1 || NL1;
346: */
347:
348: l_document := NL1 ||
349: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') ||
350: NL1 || NL1;
351: /*
352: l_document := document || l_document || l_header_msg || NL1 || NL1;
353:

Line 354: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');

350: NL1 || NL1;
351: /*
352: l_document := document || l_document || l_header_msg || NL1 || NL1;
353:
354: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
355: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL1;
356:
357: if l_description is not null then
358: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;

Line 358: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;

354: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
355: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL1;
356:
357: if l_description is not null then
358: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;
359: l_document := l_document || l_description || NL1;
360: end if;
361:
362: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');

Line 362: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');

358: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL1;
359: l_document := l_document || l_description || NL1;
360: end if;
361:
362: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');
363: l_document := l_document || ' ' || l_approver || NL1;
364:
365: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
366: l_document := l_document || ' ' || l_preparer || NL1;

Line 365: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');

361:
362: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');
363: l_document := l_document || ' ' || l_approver || NL1;
364:
365: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
366: l_document := l_document || ' ' || l_preparer || NL1;
367:
368: if l_note is not null then
369: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL1;

Line 369: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL1;

365: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
366: l_document := l_document || ' ' || l_preparer || NL1;
367:
368: if l_note is not null then
369: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL1;
370: l_document := l_document || l_note || NL1;
371: end if;
372:
373: */

Line 459: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');

455: (itemtype => l_item_type,
456: itemkey => l_item_key,
457: aname => 'REQ_AMOUNT_DSP');
458:
459: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
460:
461: l_req_amount := wf_engine.GetItemAttrText
462: (itemtype => l_item_type,
463: itemkey => l_item_key,

Line 501: fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') ||

497:
498: l_document := l_document || '

' || NL;
499:
500: l_document := l_document || '

' || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') || '	' || '(' || l_currency_code || ')' || ' ' || l_req_amount || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || '	' || l_description || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') || 324: l_document := l_document || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') || 329: '	' || l_preparer || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || '	' || l_preparer || '
' || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || '	' || l_note || '

' || NL;
503:
504: l_document := l_document || '' || NL;
505:

Line 508: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';

504: l_document := l_document || '

' || NL;
505:
506: if l_description is not null then
507: l_document := l_document || '

' || NL;
508: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';
509: l_document := l_document || l_description;
510: l_document := l_document || '

' || NL;
511: end if;
512:

Line 514: fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER') ||

510: l_document := l_document || '

' || NL;
511: end if;
512:
513: l_document := l_document || '

' || NL || 501: fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') || 502: '	' || l_currency_code || ' ' || l_req_amount || '
' || l_currency_code || ' ' || l_req_amount || '

' || NL;
516:
517: l_document := l_document || '' || NL;
518:

Line 520: fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') ||

516:
517: l_document := l_document || '

' || NL;
518:
519: l_document := l_document || '' || NL;
522:
523: l_document := l_document || '

' || 514: fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER') || 515: '	' || l_approver || '
' || l_approver || '
' || 520: fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') || 521: '	' || l_preparer || '

' || NL;
524:

Line 527: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL || '
' || NL;

523: l_document := l_document || '' || l_preparer || '

' || NL;
524:
525: if l_note is not null then
526: l_document := l_document || '

' || NL;
527: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL || '
' || NL;
528: l_document := l_document || l_note;
529: l_document := l_document || '

' || NL;
530: end if;
531:

Line 536: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');

532: else
533:
534: l_document := l_document || l_header_msg || NL || NL;
535:
536: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
537: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
538:
539: if l_description is not null then
540: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;

Line 540: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;

536: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
537: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
538:
539: if l_description is not null then
540: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
541: l_document := l_document || l_description || NL;
542: end if;
543:
544: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');

Line 544: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');

540: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
541: l_document := l_document || l_description || NL;
542: end if;
543:
544: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');
545: l_document := l_document || ' ' || l_approver || NL;
546:
547: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
548: l_document := l_document || ' ' || l_preparer || NL;

Line 547: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');

543:
544: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');
545: l_document := l_document || ' ' || l_approver || NL;
546:
547: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
548: l_document := l_document || ' ' || l_preparer || NL;
549:
550: if l_note is not null then
551: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

Line 551: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

547: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
548: l_document := l_document || ' ' || l_preparer || NL;
549:
550: if l_note is not null then
551: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;
552: l_document := l_document || l_note || NL;
553: end if;
554:
555: end if;

Line 640: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_WEB');

636: (itemtype => l_item_type,
637: itemkey => l_item_key,
638: aname => 'REQ_AMOUNT_DSP');
639:
640: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_WEB');
641:
642: l_req_amount := wf_engine.GetItemAttrText
643: (itemtype => l_item_type,
644: itemkey => l_item_key,

Line 682: fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') ||

678:
679: l_document := l_document || '

' || NL;
680:
681: l_document := l_document || '

' || NL;
684:
685: l_document := l_document || '' || NL;
686:

Line 689: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';

685: l_document := l_document || '

' || NL;
686:
687: if l_description is not null then
688: l_document := l_document || '

' || NL;
689: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL || '
';
690: l_document := l_document || l_description;
691: l_document := l_document || '

' || NL;
692: end if;
693:

Line 695: fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY') ||

691: l_document := l_document || '

' || NL;
692: end if;
693:
694: l_document := l_document || '

' || NL || 682: fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT') || 683: '	' || l_currency_code || ' ' || l_req_amount || '
' || l_currency_code || ' ' || l_req_amount || '

' || NL;
697:
698: l_document := l_document || '' || NL;
699:

Line 701: fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') ||

697:
698: l_document := l_document || '

' || NL;
699:
700: l_document := l_document || '' || NL;
703:
704: l_document := l_document || '

' || 695: fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY') || 696: '	' || l_rejected_by || '
' || l_rejected_by || '
' || 701: fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') || 702: '	' || l_preparer || '

' || NL;
705:

Line 708: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL || '
' || NL;

704: l_document := l_document || '' || l_preparer || '

' || NL;
705:
706: if l_note is not null then
707: l_document := l_document || '

' || NL;
708: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL || '
' || NL;
709: l_document := l_document || l_note;
710: l_document := l_document || '

' || NL;
711: end if;
712:

Line 717: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');

713: else
714:
715: l_document := l_document || l_header_msg || NL || NL;
716:
717: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
718: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
719:
720:
721: if l_description is not null then

Line 722: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;

718: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
719:
720:
721: if l_description is not null then
722: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
723: l_document := l_document || l_description || NL;
724: end if;
725:
726: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');

Line 726: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');

722: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
723: l_document := l_document || l_description || NL;
724: end if;
725:
726: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');
727: l_document := l_document || ' ' || l_rejected_by || NL;
728:
729: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
730: l_document := l_document || ' ' || l_preparer || NL;

Line 729: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');

725:
726: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');
727: l_document := l_document || ' ' || l_rejected_by || NL;
728:
729: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
730: l_document := l_document || ' ' || l_preparer || NL;
731:
732: if l_note is not null then
733: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

Line 733: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

729: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
730: l_document := l_document || ' ' || l_preparer || NL;
731:
732: if l_note is not null then
733: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;
734: l_document := l_document || l_note || NL;
735: end if;
736:
737: end if;

Line 865: l_document := l_document || ''|| fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');

861: -- l_document := '';
862: l_document := l_document || NL || NL || ''|| NL || NL || '

';
863:
864: l_document := l_document ||''||NL;
865: l_document := l_document || ''|| fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');
866: l_document := l_document || '';
867:
868: /* horizontal line */
869: l_document := l_document || '' || NL;

Line 879: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' '

875: l_document := l_document || ''||NL;
876:
877: /* View req details link */
878: l_req_line_msg := ''
879: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' '
880: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');
881:
882: l_req_details_url := '' ||
883: fnd_message.get_string('PO', 'PO_WF_NOTIF_VIEW_REQ_URL') || '';

Line 880: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');

876:
877: /* View req details link */
878: l_req_line_msg := ''
879: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' '
880: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');
881:
882: l_req_details_url := '' ||
883: fnd_message.get_string('PO', 'PO_WF_NOTIF_VIEW_REQ_URL') || '';
884: /* l_req_line_msg := replace(l_req_line_msg, '&REQ_DTL_LINK', l_req_details_url);

Line 883: fnd_message.get_string('PO', 'PO_WF_NOTIF_VIEW_REQ_URL') || '';

879: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' '
880: || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');
881:
882: l_req_details_url := '' ||
883: fnd_message.get_string('PO', 'PO_WF_NOTIF_VIEW_REQ_URL') || '';
884: /* l_req_line_msg := replace(l_req_line_msg, '&REQ_DTL_LINK', l_req_details_url);
885: */
886:
887:

Line 891: fnd_message.get_string('PO', 'PO_WF_NOTIF_EDIT_REQ_URL') || '';

887:
888: l_document := l_document || l_req_line_msg || NL ;
889:
890: l_req_updates_url := '' ||
891: fnd_message.get_string('PO', 'PO_WF_NOTIF_EDIT_REQ_URL') || '';
892:
893: l_document := l_document || '' || NL;
894: l_document := l_document || '';
895:

Line 910: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;

906:
907: l_document := l_document || '' || NL;
908:
909: l_document := l_document || '' ||
910: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;
911:
912: l_document := l_document || '' ||
913: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
914:

Line 913: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;

909: l_document := l_document || '' ||
910: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;
911:
912: l_document := l_document || '' ||
913: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
914:
915: l_document := l_document || '' ||
916: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;
917:

Line 916: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;

912: l_document := l_document || '' ||
913: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
914:
915: l_document := l_document || '' ||
916: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;
917:
918: l_document := l_document || '' ||
919: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
920:

Line 919: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;

915: l_document := l_document || '' ||
916: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;
917:
918: l_document := l_document || '' ||
919: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
920:
921: l_document := l_document || '' ||
922: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;
923:

Line 922: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;

918: l_document := l_document || '' ||
919: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
920:
921: l_document := l_document || '' ||
922: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;
923:
924: l_document := l_document || '' ||
925: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;
926:

Line 925: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;

921: l_document := l_document || '' ||
922: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;
923:
924: l_document := l_document || '' ||
925: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;
926:
927: l_document := l_document || '' ||
928: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') ||
929: ' (' || l_currency_code || ')' || '' || NL;

Line 928: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') ||

924: l_document := l_document || '' ||
925: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;
926:
927: l_document := l_document || '' ||
928: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') ||
929: ' (' || l_currency_code || ')' || '' || NL;
930:
931: l_document := l_document || '' || NL;
932:

Line 973: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS') || NL1 || NL1;

969: l_document := l_document || '

' || NL;
970:
971: else
972:
973: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS') || NL1 || NL1;
974:
975: open line_csr(l_document_id);
976:
977: loop

Line 984: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;

980: i := i + 1;
981:
982: exit when line_csr%notfound;
983:
984: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;

Line 985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;

981:
982: exit when line_csr%notfound;
983:
984: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;

Line 986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;

982: exit when line_csr%notfound;
983:
984: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '

Line 987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;

983:
984: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;

Line 988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;

984: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '

Line 989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;

985: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
993: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;

Line 990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '

986: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
987: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
993: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
994:

Line 992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '

988: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
989: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
990: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
991: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
992: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
993: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
994:
995: exit when i = 5;
996: end loop;

Line 1002: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_DTLS') || ': ' ||

998: l_req_details_url := substr(l_req_details_url,
999: instr(l_req_details_url,'''',1,1)+1,
1000: instr(l_req_details_url,'''',1,2)- instr(l_req_details_url,'''',1)-1);
1001:
1002: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_DTLS') || ': ' ||
1003: l_req_details_url || NL1;
1004:
1005: l_req_updates_url := substr(l_req_updates_url,
1006: instr(l_req_updates_url,'''',1,1)+1,

Line 1009: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_EDIT_REQ') || ': ' ||

1005: l_req_updates_url := substr(l_req_updates_url,
1006: instr(l_req_updates_url,'''',1,1)+1,
1007: instr(l_req_updates_url,'''',1,2)- instr(l_req_updates_url,'''',1)-1);
1008:
1009: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_EDIT_REQ') || ': ' ||
1010: l_req_updates_url || NL1;
1011:
1012: end if;
1013:

Line 1128: l_document := l_document || ''|| fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');

1124: -- l_document := '';
1125: l_document := l_document || NL || NL || ''|| NL || NL || '

';
1126:
1127: l_document := l_document ||''||NL;
1128: l_document := l_document || ''|| fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS');
1129: l_document := l_document || '';
1130:
1131: /* horizontal line */
1132: l_document := l_document || '' || NL;

Line 1145: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' ' ||

1141: l_document := l_document || ''||NL;
1142:
1143: /* View req details link */
1144: l_req_line_msg := ''
1145: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' ' ||
1146: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');
1147: l_req_details_url := 'View Requisition Details';
1148: -- l_req_line_msg := replace(l_req_line_msg, '&REQ_DTL_LINK', l_req_details_url);
1149:

Line 1146: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');

1142:
1143: /* View req details link */
1144: l_req_line_msg := ''
1145: ||fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP') || ' ' ||
1146: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP1');
1147: l_req_details_url := 'View Requisition Details';
1148: -- l_req_line_msg := replace(l_req_line_msg, '&REQ_DTL_LINK', l_req_details_url);
1149:
1150: l_document := l_document || l_req_line_msg || NL ;

Line 1171: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;

1167:
1168: l_document := l_document || '' || NL;
1169:
1170: l_document := l_document || '' ||
1171: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;
1172:
1173: l_document := l_document || '' ||
1174: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
1175:

Line 1174: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;

1170: l_document := l_document || '' ||
1171: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '' || NL;
1172:
1173: l_document := l_document || '' ||
1174: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
1175:
1176: l_document := l_document || '' ||
1177: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;
1178:

Line 1177: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;

1173: l_document := l_document || '' ||
1174: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '' || NL;
1175:
1176: l_document := l_document || '' ||
1177: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;
1178:
1179: l_document := l_document || '' ||
1180: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
1181:

Line 1180: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;

1176: l_document := l_document || '' ||
1177: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '' || NL;
1178:
1179: l_document := l_document || '' ||
1180: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
1181:
1182: l_document := l_document || '' ||
1183: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;
1184:

Line 1183: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;

1179: l_document := l_document || '' ||
1180: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '' || NL;
1181:
1182: l_document := l_document || '' ||
1183: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;
1184:
1185: l_document := l_document || '' ||
1186: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;
1187:

Line 1186: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;

1182: l_document := l_document || '' ||
1183: fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || '' || NL;
1184:
1185: l_document := l_document || '' ||
1186: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;
1187:
1188: l_document := l_document || '' ||
1189: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT')|| ' (' || l_currency_code || ')' || '' || NL;
1190:

Line 1189: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT')|| ' (' || l_currency_code || ')' || '' || NL;

1185: l_document := l_document || '' ||
1186: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '' || NL;
1187:
1188: l_document := l_document || '' ||
1189: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT')|| ' (' || l_currency_code || ')' || '' || NL;
1190:
1191:
1192: l_document := l_document || '' || NL;
1193:

Line 1233: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS') || NL1 || NL1;

1229: l_document := l_document || '

' || NL;
1230:
1231: else
1232:
1233: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS') || NL1 || NL1;
1234:
1235: open line_csr(l_document_id);
1236:
1237: loop

Line 1244: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;

1240:
1241: i := i + 1;
1242: exit when line_csr%notfound;
1243:
1244: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;

Line 1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;

1241: i := i + 1;
1242: exit when line_csr%notfound;
1243:
1244: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;

Line 1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;

1242: exit when line_csr%notfound;
1243:
1244: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '

Line 1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;

1243:
1244: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;

Line 1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;

1244: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL1;
1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '

Line 1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;

1245: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL1;
1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1253: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;

Line 1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '

1246: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL1;
1247: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL1;
1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1253: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
1254:

Line 1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '

1248: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL1;
1249: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL1;
1250: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1251: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1;
1252: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1253: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL1 || NL1;
1254:
1255: exit when i = 5;
1256: end loop;

Line 1263: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_DTLS') || ': ' ||

1259: l_req_details_url := substr(l_req_details_url,
1260: instr(l_req_details_url,'''',1,1)+1,
1261: instr(l_req_details_url,'''',1,2)- instr(l_req_details_url,'''',1)-1);
1262:
1263: l_document := l_document || NL1 || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_DTLS') || ': ' ||
1264: l_req_details_url || NL1;
1265: end if;
1266:
1267: document := l_document;

Line 1362: l_document := l_document || ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;

1358:
1359: -- l_document := '';
1360: l_document := NL || NL || ''|| NL || NL || '

';
1361: l_document := l_document || ''||NL;
1362: l_document := l_document || ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY') || NL;
1363: l_document := l_document || '' || NL;
1364:
1365: l_document := l_document || '';
1366:

Line 1372: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '' || NL;

1368: l_document := l_document || ''||NL;
1369: l_document := l_document || '' || NL;
1370:
1371: l_document := l_document || '' || NL;
1373:
1374: l_document := l_document || '' || NL;
1376:

Line 1375: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '' || NL;

1371: l_document := l_document || '

' || NL;
1373:
1374: l_document := l_document || '' || NL;
1376:
1377: l_document := l_document || '' || NL;
1379:

Line 1378: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '' || NL;

1374: l_document := l_document || '

' || NL;
1376:
1377: l_document := l_document || '' || NL;
1379:
1380: l_document := l_document || '' || NL;
1382:

Line 1381: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '' || NL;

1377: l_document := l_document || '

' || NL;
1379:
1380: l_document := l_document || '' || NL;
1382:
1383: l_document := l_document || '' || NL;
1384:
1385: open history_csr(l_document_id, l_object_type);

Line 1435: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');

1431:
1432: -- Don't allow transfer
1433: if (funcmode = 'TRANSFER') then
1434:
1435: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
1436: app_exception.raise_exception;
1437:
1438: end if; -- end if for funcmode = 'TRANSFER'
1439:

' || 1372: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '

' || 1375: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '

' || 1372: fnd_message.get_string('PO', 'PO_WF_NOTIF_SEQ_NUM') || '

' || 1375: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '

' || 1378: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '

' || 1375: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '

' || 1378: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '

' || 1381: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '

' || 1378: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '

' || 1381: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '