DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_MESSAGE

Line 383: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVAL_MSG');

379: if wf_engine.GetItemAttrText(itemtype => l_item_type,
380: itemkey => l_item_key,
381: aname => 'REQUIRES_APPROVAL_MSG') is not null then
382:
383: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVAL_MSG');
384:
385: else
386:
387: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_INVALID_PERSON_MSG');

Line 387: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_INVALID_PERSON_MSG');

383: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVAL_MSG');
384:
385: else
386:
387: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_INVALID_PERSON_MSG');
388:
389: end if;
390:
391: -- l_header_msg := replace(l_header_msg, '&DOCUMENT_SUBTYPE_DISP', l_document_subtype);

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

396: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
397:
398: l_document := l_document || l_header_msg || NL || NL;
399:
400: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
401: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
402:
403: if l_tax_amt > 0 then
404:

Line 405: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');

401: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
402:
403: if l_tax_amt > 0 then
404:
405: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');
406: l_document := l_document || ' ' || l_currency_code || ' ' || l_tax_amount || NL;
407:
408: end if;
409:

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

407:
408: end if;
409:
410: if l_description is not null then
411: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
412: l_document := l_document || l_description || NL;
413: end if;
414:
415: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_FORWARDED_FROM');

Line 415: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_FORWARDED_FROM');

411: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
412: l_document := l_document || l_description || NL;
413: end if;
414:
415: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_FORWARDED_FROM');
416: l_document := l_document || ' ' || l_forwarded_from || NL;
417:
418: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
419: l_document := l_document || ' ' || l_preparer || NL;

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

414:
415: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_FORWARDED_FROM');
416: l_document := l_document || ' ' || l_forwarded_from || NL;
417:
418: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
419: l_document := l_document || ' ' || l_preparer || NL;
420:
421: if l_note is not null then
422: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

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

418: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
419: l_document := l_document || ' ' || l_preparer || NL;
420:
421: if l_note is not null then
422: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;
423: l_document := l_document || l_note || NL;
424: end if;
425:
426: end if;

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

649: itemkey => l_item_key,
650: p_document_id => l_document_id,
651: p_currency_code => l_currency_code);
652:
653: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
654:
655: -- l_header_msg := replace(l_header_msg, '&DOCUMENT_SUBTYPE_DISP', l_document_subtype);
656: l_header_msg := replace(l_header_msg, '&DOCUMENT_TYPE_DISP', l_document_type);
657: l_header_msg := replace(l_header_msg, '&DOCUMENT_NUMBER', l_document_number);

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

659: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
660:
661: l_document := l_document || l_header_msg || NL || NL;
662:
663: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
664: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
665:
666: if l_tax_amt > 0 then
667:

Line 668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');

664: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
665:
666: if l_tax_amt > 0 then
667:
668: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');
669: l_document := l_document || ' ' || l_currency_code || ' ' || l_tax_amount || NL;
670:
671: end if;
672:

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

670:
671: end if;
672:
673: if l_description is not null then
674: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
675: l_document := l_document || l_description || NL;
676: end if;
677:
678: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');

Line 678: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');

674: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
675: l_document := l_document || l_description || NL;
676: end if;
677:
678: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');
679: l_document := l_document || ' ' || l_approver || NL;
680:
681: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
682: l_document := l_document || ' ' || l_preparer || NL;

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

677:
678: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVER');
679: l_document := l_document || ' ' || l_approver || NL;
680:
681: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
682: l_document := l_document || ' ' || l_preparer || NL;
683:
684: if l_note is not null then
685: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

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

681: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
682: l_document := l_document || ' ' || l_preparer || NL;
683:
684: if l_note is not null then
685: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;
686: l_document := l_document || l_note || NL;
687: end if;
688:
689: /* Bug# 1666013 */

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

881: itemkey => l_item_key,
882: p_document_id => l_document_id,
883: p_currency_code => l_currency_code);
884:
885: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
886:
887: -- l_header_msg := replace(l_header_msg, '&DOCUMENT_SUBTYPE_DISP', l_document_subtype);
888: l_header_msg := replace(l_header_msg, '&DOCUMENT_TYPE_DISP', l_document_type);
889: l_header_msg := replace(l_header_msg, '&DOCUMENT_NUMBER', l_document_number);

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

891: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
892:
893: l_document := l_document || l_header_msg || NL || NL;
894:
895: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
896: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
897:
898: if l_tax_amt > 0 then
899:

Line 900: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');

896: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
897:
898: if l_tax_amt > 0 then
899:
900: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');
901: l_document := l_document || ' ' || l_currency_code || ' ' || l_tax_amount || NL;
902:
903: end if;
904:

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

902:
903: end if;
904:
905: if l_description is not null then
906: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
907: l_document := l_document || l_description || NL;
908: end if;
909:
910: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');

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

906: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
907: l_document := l_document || l_description || NL;
908: end if;
909:
910: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');
911: l_document := l_document || ' ' || l_approver || NL;
912:
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
914: l_document := l_document || ' ' || l_preparer || NL;

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

909:
910: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_LAST_APPROVER');
911: l_document := l_document || ' ' || l_approver || NL;
912:
913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
914: l_document := l_document || ' ' || l_preparer || NL;
915:
916: if l_note is not null then
917: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

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

913: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
914: l_document := l_document || ' ' || l_preparer || NL;
915:
916: if l_note is not null then
917: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;
918: l_document := l_document || l_note || NL;
919: end if;
920:
921: end if;

Line 1112: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED');

1108: itemkey => l_item_key,
1109: p_document_id => l_document_id,
1110: p_currency_code => l_currency_code);
1111:
1112: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED');
1113:
1114: -- l_header_msg := replace(l_header_msg, '&DOCUMENT_SUBTYPE_DISP', l_document_subtype);
1115: l_header_msg := replace(l_header_msg, '&DOCUMENT_TYPE_DISP', l_document_type);
1116: l_header_msg := replace(l_header_msg, '&DOCUMENT_NUMBER', l_document_number);

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

1118: l_header_msg := replace(l_header_msg, '&TOTAL_AMOUNT_DSP', l_total_amount);
1119:
1120: l_document := l_document || l_header_msg || NL || NL;
1121:
1122: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT');
1123: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
1124:
1125: if l_tax_amt > 0 then
1126:

Line 1127: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');

1123: l_document := l_document || ' ' || l_currency_code || ' ' || l_req_amount || NL;
1124:
1125: if l_tax_amt > 0 then
1126:
1127: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT');
1128: l_document := l_document || ' ' || l_currency_code || ' ' || l_tax_amount || NL;
1129:
1130: end if;
1131:

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

1129:
1130: end if;
1131:
1132: if l_description is not null then
1133: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
1134: l_document := l_document || l_description || NL;
1135: end if;
1136:
1137: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');

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

1133: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION') || NL;
1134: l_document := l_document || l_description || NL;
1135: end if;
1136:
1137: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');
1138: l_document := l_document || ' ' || l_rejected_by || NL;
1139:
1140: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
1141: l_document := l_document || ' ' || l_preparer || NL;

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

1136:
1137: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_BY');
1138: l_document := l_document || ' ' || l_rejected_by || NL;
1139:
1140: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
1141: l_document := l_document || ' ' || l_preparer || NL;
1142:
1143: if l_note is not null then
1144: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;

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

1140: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER');
1141: l_document := l_document || ' ' || l_preparer || NL;
1142:
1143: if l_note is not null then
1144: l_document := l_document || NL || fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || NL;
1145: l_document := l_document || l_note || NL;
1146: end if;
1147:
1148: end if;

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

1308: return;
1309:
1310: else
1311:
1312: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS') || NL || NL;
1313:
1314: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') || NL;
1315:
1316: open line_csr(l_document_id);

Line 1314: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') || NL;

1310: else
1311:
1312: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS') || NL || NL;
1313:
1314: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DTLS_DESP') || NL;
1315:
1316: open line_csr(l_document_id);
1317:
1318: loop

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

1324: i := i + 1;
1325:
1326: exit when line_csr%notfound;
1327:
1328: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL;
1329: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL;
1330: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL;
1331: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL;
1332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL;

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

1325:
1326: exit when line_csr%notfound;
1327:
1328: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL;
1329: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL;
1330: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL;
1331: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL;
1332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL;
1333: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL;

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

1326: exit when line_csr%notfound;
1327:
1328: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL;
1329: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL;
1330: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL;
1331: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL;
1332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL;
1333: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL;
1334:

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

1327:
1328: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL;
1329: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL;
1330: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL;
1331: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL;
1332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL;
1333: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL;
1334:
1335: /* display the transaction currency in the notification if the profile is set */

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

1328: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || ':' || to_char(l_line.line_num) || NL;
1329: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL;
1330: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL;
1331: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL;
1332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL;
1333: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL;
1334:
1335: /* display the transaction currency in the notification if the profile is set */
1336: IF (display_txn_curr = 'Y' AND

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

1329: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') || ': ' || l_line.item_num || NL;
1330: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') || ': ' || l_line.item_revision || NL;
1331: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || ': ' || l_line.item_desc || NL;
1332: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || ': ' || l_line.uom || NL;
1333: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || ': ' || to_char(l_line.quantity) || NL;
1334:
1335: /* display the transaction currency in the notification if the profile is set */
1336: IF (display_txn_curr = 'Y' AND
1337: l_line.txn_curr_code is not null AND

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

1336: IF (display_txn_curr = 'Y' AND
1337: l_line.txn_curr_code is not null AND
1338: l_currency_code <> l_line.txn_curr_code) THEN
1339:
1340: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1341: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30))
1342: || ' ' || l_currency_code || ' ('
1343: || to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30))
1344: || ' ' || l_line.txn_curr_code || ')' || NL;

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

1343: || to_char(l_line.curr_unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_line.txn_curr_code, 30))
1344: || ' ' || l_line.txn_curr_code || ')' || NL;
1345:
1346: ELSE
1347: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_UNIT_PRICE') || ': '
1348: || to_char(l_line.unit_price, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL;
1349: END IF;
1350:
1351:

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

1349: END IF;
1350:
1351:
1352:
1353: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') || ': '
1354: || to_char(l_line.line_amount, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || NL || NL;
1355:
1356: exit when i = 5;
1357:

Line 1572: multiple_cost_center := fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE');

1568:
1569: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1570:
1571:
1572: multiple_cost_center := fnd_message.get_string('PO', 'PO_WF_NOTIF_MULTIPLE');
1573:
1574: l_currency_code := PO_CORE_S2.get_base_currency;
1575:
1576: /* Bug 2480327

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

1610: if (display_type = 'text/html') then
1611:
1612: l_document := l_document || NL || NL || ''|| NL || NL || '

';
1613:
1614: l_document := l_document || print_heading(fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS'));
1615: -- Bug 3592883
1616: l_document_pre_lmt := l_document;
1617: l_document := null;
1618: g_req_line_allowed_length := g_req_line_allowed_length - nvl(lengthb(l_document_pre_lmt),0);

Line 1648: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP');

1644: ** message does not refer to View Requisition Link but to Open Document
1645: ** icon for additional line details.
1646: */
1647:
1648: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP');
1649:
1650: ELSE
1651: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NTF_LINE_DET_NO_SSP_DSP');
1652: END IF;

Line 1651: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NTF_LINE_DET_NO_SSP_DSP');

1647:
1648: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_DETAILS_DESP');
1649:
1650: ELSE
1651: l_req_line_msg := fnd_message.get_string('PO', 'PO_WF_NTF_LINE_DET_NO_SSP_DSP');
1652: END IF;
1653:
1654: -- l_req_line_msg := replace(l_req_line_msg, '&LIMIT', to_char(l_max_lines));
1655: -- Bug 3592883 DO NOT replace the limit now.

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

1669: l_document := null;
1670: g_req_line_allowed_length := g_req_line_allowed_length - nvl(lengthb(l_req_line_msg),0);
1671:
1672: -- Now Construct the lines
1673: l_document := l_document || '

'|| NL;
1674:
1675: l_document := l_document || '' || NL;
1677:

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

1672: -- Now Construct the lines
1673: l_document := l_document || '

' ||
1676: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
'|| NL;
1674:
1675: l_document := l_document || '' || NL;
1677:
1678: l_document := l_document || '' || NL;
1680:

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

1675: l_document := l_document || '

' || NL;
1677:
1678: l_document := l_document || '' || NL;
1680:
1681: If(l_disp_item = 'Y') Then
1682: l_document := l_document || '' || NL;
1686:
1687: l_document := l_document || '' || NL;
1686:
1687: l_document := l_document || '' || NL;
1691:
1692: l_document := l_document || '' || NL;

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

1689: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') ||
1690: '' || NL;
1691:
1692: l_document := l_document || '

' || NL;
1694:
1695: l_document := l_document || '' || NL;
1697:

Line 1696: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '' || NL;

1692: l_document := l_document || '

' || NL;
1694:
1695: l_document := l_document || '' || NL;
1697:
1698: l_document := l_document || '' || NL;
1700:

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

1695: l_document := l_document || '

' || NL;
1697:
1698: l_document := l_document || '' || NL;
1700:
1701: l_document := l_document || '' || NL;
1703:

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

1698: l_document := l_document || '

' || NL;
1700:
1701: l_document := l_document || '' || NL;
1703:
1704: /* Bug 2480327
1705: ** notification UI enhancement
1706: */

Line 1709: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '' || NL;

1705: ** notification UI enhancement
1706: */
1707: IF (l_display_currency_price_cell = true) THEN
1708: l_document := l_document || '

' || NL;
1710: END IF;
1711:
1712: l_document := l_document || '' || NL;
1710: END IF;
1711:
1712: l_document := l_document || '' || NL;
1715:
1716: l_document := l_document || '' || NL;
1715:
1716: l_document := l_document || '' || NL;
1719:
1720: l_document := l_document || '' || NL;
1721:

Line 1960: l_document := l_document || print_heading(fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY'));

1956: if (display_type = 'text/html') then
1957:
1958: l_document := NL || NL || ''|| NL || NL || '

';
1959:
1960: l_document := l_document || print_heading(fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY'));
1961:
1962: l_document := l_document || '

' ||
1676: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
' ||
1679: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '
' ||
1676: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_NUMBER') || '
' ||
1679: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_DESC') || '
1683: ' width=15% id ="item_1">' ||

Line 1684: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') ||

1680:
1681: If(l_disp_item = 'Y') Then
1682: l_document := l_document || '

1683: ' width=15% id ="item_1">' ||
1684: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_NUMBER') ||
1685: '
1688: ' width=3% id ="itemRev_1">' ||

Line 1689: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') ||

1685: '

1688: ' width=3% id ="itemRev_1">' ||
1689: fnd_message.get_string('PO', 'PO_WF_NOTIF_ITEM_REVISION') ||
1690: '
' ||
1693: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '
' ||
1693: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '
' ||
1696: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '
' ||
1693: fnd_message.get_string('PO', 'PO_WF_NOTIF_SUPPLIER') || '
' ||
1696: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '
' ||
1699: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '
' ||
1696: fnd_message.get_string('PO', 'PO_WF_NOTIF_COST_CENTER') || '
' ||
1699: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '
' ||
1702: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '
' ||
1699: fnd_message.get_string('PO', 'PO_WF_NOTIF_UOM') || '
' ||
1702: fnd_message.get_string('PO', 'PO_WF_NOTIF_QUANTITY') || '
' ||
1709: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '
' ||
1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') ||

Line 1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') ||

1709: fnd_message.get_string('PO', 'PO_WF_NOTIF_TRANS_PRICE') || '

' ||
1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') ||
1714: ' ' || '(' || l_currency_code || ')'|| '
' ||
1717: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') ||

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

1713: fnd_message.get_string('PO', 'PO_WF_NOTIF_PRICE') ||
1714: ' ' || '(' || l_currency_code || ')'|| '

' ||
1717: fnd_message.get_string('PO', 'PO_WF_NOTIF_LINE_AMOUNT') ||
1718: ' ' || '(' || l_currency_code || ')' || '
' || NL;
1963:
1964: l_document := l_document || '' || NL;

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

1958: l_document := NL || NL || ''|| NL || NL || '

';
1959:
1960: l_document := l_document || print_heading(fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_HISTORY'));
1961:
1962: l_document := l_document || '

' || NL;
1963:
1964: l_document := l_document || '' || NL;
1965:
1966: l_document := l_document || '' || NL;

1963:
1964: l_document := l_document || '

' || NL;
1965:
1966: l_document := l_document || '' || NL;
1968:
1969: l_document := l_document || '' || NL;
1971:

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

1966: l_document := l_document || '

' || NL;
1968:
1969: l_document := l_document || '' || NL;
1971:
1972: l_document := l_document || '' || NL;
1974:

Line 1973: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '' || NL;

1969: l_document := l_document || '

' || NL;
1971:
1972: l_document := l_document || '' || NL;
1974:
1975: l_document := l_document || '' || NL;
1977:

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

1972: l_document := l_document || '

' || NL;
1974:
1975: l_document := l_document || '' || NL;
1977:
1978: l_document := l_document || '' || NL;
1979:
1980: open history_csr(l_document_id, l_object_type);

Line 2370: l_document := l_document || print_heading(fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_SUMMARY'));

2366: end if;
2367:
2368: l_document := l_document || NL || ''|| NL || NL || '

';
2369:
2370: l_document := l_document || print_heading(fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_SUMMARY'));
2371:
2372: -- New Table Style
2373:
2374: l_document := l_document || '

 ' ||

Line 1967: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '
 ' ||
1967: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '
' ||
1970: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '
' ||
1967: fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || '
' ||
1970: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '
' ||
1973: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '
' ||
1970: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION') || '
' ||
1973: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '
' ||
1976: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '
' ||
1973: fnd_message.get_string('PO', 'PO_WF_NOTIF_DATE') || '
' ||
1976: fnd_message.get_string('PO', 'PO_WF_NOTIF_ACTION_NOTE') || '

Line 2376: fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT')

2372: -- New Table Style
2373:
2374: l_document := l_document || '


2375: ' || NL;
2378:
2379: l_document := l_document || '' || NL;

Line 2385: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT') || ' ' || NL;

2381:
2382: if l_tax_amt > 0 then
2383:
2384: l_document := l_document || '

' || NL;
2386:
2387: l_document := l_document || '' || NL;
2389:

Line 2395: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION')

2391:
2392: l_document := l_document || NL;
2393:
2394: l_document := l_document || '

' || NL;
2397:
2398: l_document := l_document || '' || NL;
2399:

Line 2403: fnd_message.get_string('PO', 'PO_WF_NOTIF_FROM') ||' ' || NL;

2399:
2400: if l_forwarded_from is not null then
2401:
2402: l_document := l_document || '

' || NL;
2404:
2405: l_document := l_document || '' || NL;
2406:
2407: end if;

Line 2410: fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') ||' ' || NL;

2406:
2407: end if;
2408:
2409: l_document := l_document || '

' || NL;
2411:
2412: l_document := l_document || '' || NL;
2413:
2414: l_document := l_document || '' || NL;

2411:
2412: l_document := l_document || '

' || NL;
2413:
2414: l_document := l_document || '' || NL;
2416:
2417: l_document := l_document || '' || NL;
2418:
2419: l_document := l_document || '
' ||
2376: fnd_message.get_string('PO', 'PO_WF_NOTIF_REQ_AMOUNT')
2377: || ' 
'
2380: || l_req_amount || ' ' || l_currency_code || '
' ||
2385: fnd_message.get_string('PO', 'PO_WF_NOTIF_TAX_AMOUNT') || ' 
'
2388: || l_tax_amount || ' ' || l_currency_code || '
' ||
2395: fnd_message.get_string('PO', 'PO_WF_NOTIF_DOC_DESCRIPTION')
2396: || ' 
' || l_description || '
' ||
2403: fnd_message.get_string('PO', 'PO_WF_NOTIF_FROM') ||' 
' || l_forwarded_from || '
' ||
2410: fnd_message.get_string('PO', 'PO_WF_NOTIF_PREPARER') ||' 
' || l_preparer || '
' ||

Line 2415: fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || ' 
' || l_preparer || '
' ||
2415: fnd_message.get_string('PO', 'PO_WF_NOTIF_NOTE') || ' 
' || l_note || '
' || NL;

Line 2624: fnd_message.set_name('PO', 'PO_INVALID_USER_FOR_REASSIGN');

2620: /* bug 4667656 : We should not be allowing the delegation of a notication
2621: to a user who is not an employee. */
2622:
2623: if((funcmode = 'FORWARD') AND (l_origsys <> 'PER')) then
2624: fnd_message.set_name('PO', 'PO_INVALID_USER_FOR_REASSIGN');
2625: app_exception.raise_exception;
2626: end if;
2627:
2628: l_progress := '002';

Line 2686: fnd_message.set_name('ICX', 'ICX_POR_WF_NOTIF_NO_USER');

2682: itemkey => itemkey,
2683: aname => 'FORWARD_TO_USERNAME_RESPONSE');
2684:
2685: if(l_forwardTo is null) then
2686: fnd_message.set_name('ICX', 'ICX_POR_WF_NOTIF_NO_USER');
2687: app_exception.raise_exception;
2688: end if;
2689: end if;
2690:

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

2861: end if;
2862:
2863: -- Don't allow transfer
2864: if (funcmode = 'TRANSFER') then
2865: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
2866: app_exception.raise_exception;
2867: resultout := wf_engine.eng_completed;
2868: return;
2869: end if; -- end if for funcmode = 'TRANSFER'