DBA Data[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on FND_MESSAGE

Line 371: x_progress := fnd_message.get;

367: WHEN submission_error THEN
368: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : Exception submitting concurrent request';
369: IF (g_po_wf_debug = 'Y') THEN
370: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
371: x_progress := fnd_message.get;
372: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
373: END IF;
374: wf_core.context('PO_COMMUNICATION_PVT', 'GENERATE_PDF', itemtype, itemkey, 'PO', x_progress);
375: RAISE;

Line 808: avalue => FND_MESSAGE.GET_STRING('PO', 'PO_PDF_EMAIL_TEXT'));

804:
805: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
806: itemkey => l_itemkey,
807: aname => 'EMAIL_TEXT_WITH_PDF',
808: avalue => FND_MESSAGE.GET_STRING('PO', 'PO_PDF_EMAIL_TEXT'));
809:
810: l_orgid := po_moac_utils_pvt.get_current_org_id; --
811:
812: IF l_orgid is not null THEN

Line 858: select DECODE(p_document_subtype, 'BLANKET', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKT'),

854: aname => 'DOCUMENT_NUMBER',
855: avalue => l_docNumber);
856:
857:
858: select DECODE(p_document_subtype, 'BLANKET', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKT'),
859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),
860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),
861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;
862: if l_ga_flag = 'Y' then

Line 859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),

855: avalue => l_docNumber);
856:
857:
858: select DECODE(p_document_subtype, 'BLANKET', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKT'),
859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),
860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),
861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;
862: if l_ga_flag = 'Y' then
863: l_doc_display_name := FND_MESSAGE.GET_STRING('PO', 'PO_GA_TYPE');

Line 860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),

856:
857:
858: select DECODE(p_document_subtype, 'BLANKET', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKT'),
859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),
860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),
861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;
862: if l_ga_flag = 'Y' then
863: l_doc_display_name := FND_MESSAGE.GET_STRING('PO', 'PO_GA_TYPE');
864: end if;

Line 861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;

857:
858: select DECODE(p_document_subtype, 'BLANKET', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKT'),
859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),
860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),
861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;
862: if l_ga_flag = 'Y' then
863: l_doc_display_name := FND_MESSAGE.GET_STRING('PO', 'PO_GA_TYPE');
864: end if;
865:

Line 863: l_doc_display_name := FND_MESSAGE.GET_STRING('PO', 'PO_GA_TYPE');

859: 'CONTRACT', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_CNTR'),
860: 'STANDARD', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_STD'),
861: 'PLANNED', FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_PLND')) into l_doc_display_name from dual;
862: if l_ga_flag = 'Y' then
863: l_doc_display_name := FND_MESSAGE.GET_STRING('PO', 'PO_GA_TYPE');
864: end if;
865:
866: if p_document_type = 'RELEASE' then
867: l_doc_num_rel := l_docNumber || '-' || l_release_num;

Line 868: l_doc_display_name := FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKTR');

864: end if;
865:
866: if p_document_type = 'RELEASE' then
867: l_doc_num_rel := l_docNumber || '-' || l_release_num;
868: l_doc_display_name := FND_MESSAGE.GET_STRING('POS', 'POS_POTYPE_BLKTR');
869: else
870: l_doc_num_rel := l_docNumber;
871: end if;
872: if l_doc_num_rel is not null then

Line 1302: x_progress := fnd_message.get;

1298: WHEN submission_error THEN
1299: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : Exception submitting concurrent request';
1300: IF (g_po_wf_debug = 'Y') THEN
1301: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1302: x_progress := fnd_message.get;
1303: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
1304: END IF;
1305: wf_core.context('PO_COMMUNICATION_PVT', 'GENERATE_PDF', itemtype, itemkey, 'PO', x_progress);
1306: RAISE;

Line 2122: x_progress := fnd_message.get;

2118: WHEN submission_error THEN
2119: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : Exception submitting concurrent request';
2120: IF (g_po_wf_debug = 'Y') THEN
2121: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
2122: x_progress := fnd_message.get;
2123: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
2124: END IF;
2125: wf_core.context('PO_COMMUNICATION_PVT', 'GENERATE_PDF', itemtype, itemkey, 'PO', x_progress);
2126: RAISE;

Line 2328: x_progress := fnd_message.get;

2324: WHEN submission_error THEN
2325: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF : Exception submitting concurrent request';
2326: IF (g_po_wf_debug = 'Y') THEN
2327: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
2328: x_progress := fnd_message.get;
2329: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
2330: END IF;
2331: wf_core.context('PO_COMMUNICATION_PVT', 'GENERATE_PDF', itemtype, itemkey, 'PO', x_progress);
2332: RAISE;

Line 3661: --l_document:=fnd_message.get_string('PO','PO_PDF_FAILED');

3657: document_type :='application/pdf; name='|| l_filename;
3658:
3659: EXCEPTION
3660: WHEN OTHERS THEN
3661: --l_document:=fnd_message.get_string('PO','PO_PDF_FAILED');
3662: --WF_NOTIFICATION.WriteToBlob(document, l_document);
3663: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach_app-Exception ';
3664:
3665: IF (g_po_wf_debug = 'Y') THEN

Line 3671: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');

3667: END IF;
3668:
3669: --Bug#3274081 Display the message to the user incase the pdf fails.
3670: document_type :='text/html; name='|| l_filename;
3671: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
3672: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3673:
3674: END pdf_attach_app;
3675:

Line 3790: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');

3786: -- Display the message to the user incase the pdf fails.
3787: -- Bug 4047688
3788: -- Removed concatenation of l_filename from document_type
3789: document_type := 'text/html';
3790: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
3791: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3792: END pdf_attach_supp;
3793:
3794:

Line 3999: --l_document:=fnd_message.get_string('PO','PO_PDF_FAILED');

3995: document_type :='application/pdf; name='|| l_filename;
3996:
3997: EXCEPTION
3998: WHEN OTHERS THEN
3999: --l_document:=fnd_message.get_string('PO','PO_PDF_FAILED');
4000: --WF_NOTIFICATION.WriteToBlob(document, l_document);
4001: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach - Exception ';
4002:
4003: IF (g_po_wf_debug = 'Y') THEN

Line 4010: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');

4006:
4007: --Bug#3274081 Display the message to the user incase the pdf fails.
4008: --Bug 4047688: Removed concatenation of l_filename from document_type
4009: document_type := 'text/html';
4010: l_message := fnd_message.get_string('PO', 'PO_PDF_FAILED');
4011: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
4012:
4013: END pdf_attach;
4014:

Line 4192: l_message := fnd_message.get_string('PO', 'PO_OKC_DOC_FAILED');

4188: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, x_progress);
4189: END IF;
4190:
4191: document_type :='text/html; name='|| l_okc_file_name;
4192: l_message := fnd_message.get_string('PO', 'PO_OKC_DOC_FAILED');
4193: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
4194:
4195: END okc_doc_attach;
4196:

Line 4340: l_message := fnd_message.get_string('PO', 'PO_ZIP_FAILED');

4336: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey, l_progress ||' '|| SQLERRM);
4337: END IF;
4338:
4339: document_type :='text/html; name='|| l_filename;
4340: l_message := fnd_message.get_string('PO', 'PO_ZIP_FAILED');
4341: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
4342:
4343: END zip_attach;
4344:

Line 5138: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVERING_MESSAGE');

5134: -- contract terms are structured and/or mergeable
5135: -- so, show old cover page message (with no mention to look elsewhere for terms)
5136:
5137: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5138: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVERING_MESSAGE');
5139: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5140: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5142:

Line 5139: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);

5135: -- so, show old cover page message (with no mention to look elsewhere for terms)
5136:
5137: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5138: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVERING_MESSAGE');
5139: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5140: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5142:
5143:

Line 5140: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);

5136:
5137: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5138: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVERING_MESSAGE');
5139: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5140: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5142:
5143:
5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');

Line 5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;

5137: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5138: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVERING_MESSAGE');
5139: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5140: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5142:
5143:
5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');
5145: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);

Line 5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');

5140: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5142:
5143:
5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');
5145: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5146: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5147: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5148:

Line 5145: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);

5141: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5142:
5143:
5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');
5145: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5146: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5147: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5148:
5149: g_is_contract_attached_doc := 'N'; -- bug4026592

Line 5146: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);

5142:
5143:
5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');
5145: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5146: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5147: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5148:
5149: g_is_contract_attached_doc := 'N'; -- bug4026592
5150:

Line 5147: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;

5143:
5144: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMENDMENT_MESSAGE');
5145: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5146: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5147: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5148:
5149: g_is_contract_attached_doc := 'N'; -- bug4026592
5150:
5151: ELSIF (- 1 <> OKC_TERMS_UTIL_GRP.get_primary_terms_doc_file_id(p_document_id => p_document_id

Line 5158: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVER_MSG_NOT_MERGED');

5154:
5155: -- Primary document exists, but is not mergeable
5156:
5157: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5158: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVER_MSG_NOT_MERGED');
5159: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5160: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5162:

Line 5159: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);

5155: -- Primary document exists, but is not mergeable
5156:
5157: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5158: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVER_MSG_NOT_MERGED');
5159: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5160: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5162:
5163:

Line 5160: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);

5156:
5157: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5158: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVER_MSG_NOT_MERGED');
5159: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5160: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5162:
5163:
5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');

Line 5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;

5157: /*Get the messages in covering page by replacing the tokens with correponding value.*/
5158: FND_MESSAGE.SET_NAME('PO', 'PO_FO_COVER_MSG_NOT_MERGED');
5159: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5160: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5162:
5163:
5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');
5165: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);

Line 5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');

5160: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5162:
5163:
5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');
5165: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5166: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5167: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5168:

Line 5165: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);

5161: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5162:
5163:
5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');
5165: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5166: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5167: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5168:
5169: g_is_contract_attached_doc := 'Y'; -- bug4026592

Line 5166: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);

5162:
5163:
5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');
5165: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5166: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5167: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5168:
5169: g_is_contract_attached_doc := 'Y'; -- bug4026592
5170:

Line 5167: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;

5163:
5164: FND_MESSAGE.SET_NAME('PO', 'PO_FO_AMEND_MSG_NOT_MERGED');
5165: FND_MESSAGE.SET_TOKEN('PO_NUM', l_po_number);
5166: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY', l_change_summary);
5167: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5168:
5169: g_is_contract_attached_doc := 'Y'; -- bug4026592
5170:
5171: ELSE

Line 5176: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');

5172:
5173: -- Primary attached document does not exist!
5174: -- Bug 4014230: Get buyer and supplier org tokens
5175:
5176: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5177: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:

Line 5177: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);

5173: -- Primary attached document does not exist!
5174: -- Bug 4014230: Get buyer and supplier org tokens
5175:
5176: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5177: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');

Line 5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);

5174: -- Bug 4014230: Get buyer and supplier org tokens
5175:
5176: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5177: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);

Line 5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;

5175:
5176: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5177: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5183: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);

Line 5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');

5177: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5183: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5184: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5185:

Line 5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);

5178: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5183: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5184: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5185:
5186: g_is_contract_attached_doc := 'Y'; -- bug4026592

Line 5183: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);

5179: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5183: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5184: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5185:
5186: g_is_contract_attached_doc := 'Y'; -- bug4026592
5187:

Line 5184: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;

5180:
5181: FND_MESSAGE.SET_NAME('PO', 'PO_FO_MSG_TERMS_DOC_MISSING');
5182: FND_MESSAGE.SET_TOKEN('BUYER_ORG', po_communication_pvt.g_buyer_org);
5183: FND_MESSAGE.SET_TOKEN('SUPP_ORG', l_supp_org);
5184: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
5185:
5186: g_is_contract_attached_doc := 'Y'; -- bug4026592
5187:
5188: END IF;

Line 5207: FND_MESSAGE.SET_NAME('PO', 'PO_FO_TIMEZONE');

5203: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');
5204: END IF;
5205: RAISE;
5206: END;
5207: FND_MESSAGE.SET_NAME('PO', 'PO_FO_TIMEZONE');
5208: FND_MESSAGE.SET_TOKEN('TIME_OFFSET', l_offset);
5209: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME', l_timezone);
5210: PO_COMMUNICATION_PVT.g_timezone := FND_MESSAGE.GET;
5211: END IF;

Line 5208: FND_MESSAGE.SET_TOKEN('TIME_OFFSET', l_offset);

5204: END IF;
5205: RAISE;
5206: END;
5207: FND_MESSAGE.SET_NAME('PO', 'PO_FO_TIMEZONE');
5208: FND_MESSAGE.SET_TOKEN('TIME_OFFSET', l_offset);
5209: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME', l_timezone);
5210: PO_COMMUNICATION_PVT.g_timezone := FND_MESSAGE.GET;
5211: END IF;
5212:

Line 5209: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME', l_timezone);

5205: RAISE;
5206: END;
5207: FND_MESSAGE.SET_NAME('PO', 'PO_FO_TIMEZONE');
5208: FND_MESSAGE.SET_TOKEN('TIME_OFFSET', l_offset);
5209: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME', l_timezone);
5210: PO_COMMUNICATION_PVT.g_timezone := FND_MESSAGE.GET;
5211: END IF;
5212:
5213: PO_COMMUNICATION_PVT.g_vendor_id := l_vendor_id;

Line 5210: PO_COMMUNICATION_PVT.g_timezone := FND_MESSAGE.GET;

5206: END;
5207: FND_MESSAGE.SET_NAME('PO', 'PO_FO_TIMEZONE');
5208: FND_MESSAGE.SET_TOKEN('TIME_OFFSET', l_offset);
5209: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME', l_timezone);
5210: PO_COMMUNICATION_PVT.g_timezone := FND_MESSAGE.GET;
5211: END IF;
5212:
5213: PO_COMMUNICATION_PVT.g_vendor_id := l_vendor_id;
5214:

Line 5218: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DOCUMENT_NAME');

5214:
5215: /*bug#3630737.
5216: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing
5217: DocumentType, po number and revision number as tokens*/
5218: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DOCUMENT_NAME');
5219: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE', PO_COMMUNICATION_PVT.g_documentType);
5220: FND_MESSAGE.SET_TOKEN('PO_NUMBER', l_po_number);
5221: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER', PO_COMMUNICATION_PVT.g_revision_num);
5222: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;

Line 5219: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE', PO_COMMUNICATION_PVT.g_documentType);

5215: /*bug#3630737.
5216: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing
5217: DocumentType, po number and revision number as tokens*/
5218: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DOCUMENT_NAME');
5219: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE', PO_COMMUNICATION_PVT.g_documentType);
5220: FND_MESSAGE.SET_TOKEN('PO_NUMBER', l_po_number);
5221: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER', PO_COMMUNICATION_PVT.g_revision_num);
5222: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
5223:

Line 5220: FND_MESSAGE.SET_TOKEN('PO_NUMBER', l_po_number);

5216: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing
5217: DocumentType, po number and revision number as tokens*/
5218: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DOCUMENT_NAME');
5219: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE', PO_COMMUNICATION_PVT.g_documentType);
5220: FND_MESSAGE.SET_TOKEN('PO_NUMBER', l_po_number);
5221: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER', PO_COMMUNICATION_PVT.g_revision_num);
5222: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
5223:
5224: -- SQl What: Querying for header short attachments

Line 5221: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER', PO_COMMUNICATION_PVT.g_revision_num);

5217: DocumentType, po number and revision number as tokens*/
5218: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DOCUMENT_NAME');
5219: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE', PO_COMMUNICATION_PVT.g_documentType);
5220: FND_MESSAGE.SET_TOKEN('PO_NUMBER', l_po_number);
5221: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER', PO_COMMUNICATION_PVT.g_revision_num);
5222: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
5223:
5224: -- SQl What: Querying for header short attachments
5225: -- SQL why: To display note to supplier data in header part of pdf document.

Line 5222: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;

5218: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DOCUMENT_NAME');
5219: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE', PO_COMMUNICATION_PVT.g_documentType);
5220: FND_MESSAGE.SET_TOKEN('PO_NUMBER', l_po_number);
5221: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER', PO_COMMUNICATION_PVT.g_revision_num);
5222: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
5223:
5224: -- SQl What: Querying for header short attachments
5225: -- SQL why: To display note to supplier data in header part of pdf document.
5226: -- SQL Join: vendor_id and header_id

Line 8113: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DRAFT');

8109:
8110: -- Bug 4044904 : Moved query above
8111:
8112: --retrieve draf from fnd_new_messages.
8113: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DRAFT');
8114: x_draft := FND_MESSAGE.GET;
8115:
8116: EXCEPTION
8117: WHEN OTHERS THEN

Line 8114: x_draft := FND_MESSAGE.GET;

8110: -- Bug 4044904 : Moved query above
8111:
8112: --retrieve draf from fnd_new_messages.
8113: FND_MESSAGE.SET_NAME('PO', 'PO_FO_DRAFT');
8114: x_draft := FND_MESSAGE.GET;
8115:
8116: EXCEPTION
8117: WHEN OTHERS THEN
8118: x_pendingSignatureFlag := 'N';