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

[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on FND_MESSAGE

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

695:
696: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
697: itemkey => l_itemkey,
698: aname => 'EMAIL_TEXT_WITH_PDF',
699: avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
700:
701: l_orgid := po_moac_utils_pvt.get_current_org_id; --
702:
703: IF l_orgid is not null THEN

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

745: aname => 'DOCUMENT_NUMBER',
746: avalue => l_docNumber);
747:
748:
749: select DECODE(p_document_subtype,'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
750: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
751: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;
753: if l_ga_flag = 'Y' then

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

746: avalue => l_docNumber);
747:
748:
749: select DECODE(p_document_subtype,'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
750: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
751: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;
753: if l_ga_flag = 'Y' then
754: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');

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

747:
748:
749: select DECODE(p_document_subtype,'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
750: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
751: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;
753: if l_ga_flag = 'Y' then
754: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');
755: end if;

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

748:
749: select DECODE(p_document_subtype,'BLANKET',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKT'),
750: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
751: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;
753: if l_ga_flag = 'Y' then
754: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');
755: end if;
756:

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

750: 'CONTRACT',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_CNTR'),
751: 'STANDARD',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_STD'),
752: 'PLANNED',FND_MESSAGE.GET_STRING('POS','POS_POTYPE_PLND')) into l_doc_display_name from dual;
753: if l_ga_flag = 'Y' then
754: l_doc_display_name := FND_MESSAGE.GET_STRING('PO','PO_GA_TYPE');
755: end if;
756:
757: if p_document_type = 'RELEASE' then
758: l_doc_num_rel := l_docNumber || '-' || l_release_num;

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

755: end if;
756:
757: if p_document_type = 'RELEASE' then
758: l_doc_num_rel := l_docNumber || '-' || l_release_num;
759: l_doc_display_name := FND_MESSAGE.GET_STRING('POS','POS_POTYPE_BLKTR');
760: else
761: l_doc_num_rel := l_docNumber;
762: end if;
763: if l_doc_num_rel is not null then

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

3180: document_type:='application/pdf; name='||l_filename;
3181:
3182: EXCEPTION
3183: WHEN OTHERS THEN
3184: --l_document:=fnd_message.get_string('PO','PO_PDF_FAILED');
3185: --WF_NOTIFICATION.WriteToBlob(document, l_document);
3186: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach_app-Exception ';
3187:
3188: IF (g_po_wf_debug = 'Y') THEN

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

3190: END IF;
3191:
3192: --Bug#3274081 Display the message to the user incase the pdf fails.
3193: document_type:='text/html; name='||l_filename;
3194: l_message := fnd_message.get_string('PO','PO_PDF_FAILED');
3195: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3196:
3197: END pdf_attach_app;
3198:

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

3307: -- Display the message to the user incase the pdf fails.
3308: -- Bug 4047688
3309: -- Removed concatenation of l_filename from document_type
3310: document_type:='text/html';
3311: l_message := fnd_message.get_string('PO','PO_PDF_FAILED');
3312: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3313: END pdf_attach_supp;
3314:
3315:

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

3460: document_type:='application/pdf; name='||l_filename;
3461:
3462: EXCEPTION
3463: WHEN OTHERS THEN
3464: --l_document:=fnd_message.get_string('PO','PO_PDF_FAILED');
3465: --WF_NOTIFICATION.WriteToBlob(document, l_document);
3466: x_progress := 'PO_COMMUNICATION_PVT.pdf_attach - Exception ';
3467:
3468: IF (g_po_wf_debug = 'Y') THEN

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

3471:
3472: --Bug#3274081 Display the message to the user incase the pdf fails.
3473: --Bug 4047688: Removed concatenation of l_filename from document_type
3474: document_type:='text/html';
3475: l_message := fnd_message.get_string('PO','PO_PDF_FAILED');
3476: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3477:
3478: END pdf_attach;
3479:

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

3634: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,x_progress);
3635: END IF;
3636:
3637: document_type:='text/html; name='||l_okc_file_name;
3638: l_message := fnd_message.get_string('PO','PO_OKC_DOC_FAILED');
3639: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3640:
3641: END okc_doc_attach;
3642:

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

3782: PO_WF_DEBUG_PKG.INSERT_DEBUG(l_itemtype, l_itemkey,l_progress||' '||SQLERRM);
3783: END IF;
3784:
3785: document_type:='text/html; name='||l_filename;
3786: l_message := fnd_message.get_string('PO','PO_ZIP_FAILED');
3787: DBMS_LOB.write(document, lengthb(l_message), 1, UTL_RAW.cast_to_raw(l_message));
3788:
3789: END zip_attach;
3790:

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

4376: -- contract terms are structured and/or mergeable
4377: -- so, show old cover page message (with no mention to look elsewhere for terms)
4378:
4379: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4380: FND_MESSAGE.SET_NAME('PO','PO_FO_COVERING_MESSAGE');
4381: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4382: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4383: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4384:

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

4377: -- so, show old cover page message (with no mention to look elsewhere for terms)
4378:
4379: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4380: FND_MESSAGE.SET_NAME('PO','PO_FO_COVERING_MESSAGE');
4381: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4382: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4383: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4384:
4385:

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

4378:
4379: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4380: FND_MESSAGE.SET_NAME('PO','PO_FO_COVERING_MESSAGE');
4381: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4382: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4383: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4384:
4385:
4386: FND_MESSAGE.SET_NAME('PO','PO_FO_AMENDMENT_MESSAGE');

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

4379: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4380: FND_MESSAGE.SET_NAME('PO','PO_FO_COVERING_MESSAGE');
4381: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4382: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4383: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4384:
4385:
4386: FND_MESSAGE.SET_NAME('PO','PO_FO_AMENDMENT_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);

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

4382: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4383: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4384:
4385:
4386: FND_MESSAGE.SET_NAME('PO','PO_FO_AMENDMENT_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4388: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4389: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4390:

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

4383: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4384:
4385:
4386: FND_MESSAGE.SET_NAME('PO','PO_FO_AMENDMENT_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4388: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4389: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4390:
4391: g_is_contract_attached_doc := 'N'; -- bug4026592

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

4384:
4385:
4386: FND_MESSAGE.SET_NAME('PO','PO_FO_AMENDMENT_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4388: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4389: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4390:
4391: g_is_contract_attached_doc := 'N'; -- bug4026592
4392:

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

4385:
4386: FND_MESSAGE.SET_NAME('PO','PO_FO_AMENDMENT_MESSAGE');
4387: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4388: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4389: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4390:
4391: g_is_contract_attached_doc := 'N'; -- bug4026592
4392:
4393: ELSIF (-1 <> OKC_TERMS_UTIL_GRP.get_primary_terms_doc_file_id(p_document_id => p_document_id

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

4396:
4397: -- Primary document exists, but is not mergeable
4398:
4399: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4400: FND_MESSAGE.SET_NAME('PO','PO_FO_COVER_MSG_NOT_MERGED');
4401: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4402: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4403: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4404:

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

4397: -- Primary document exists, but is not mergeable
4398:
4399: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4400: FND_MESSAGE.SET_NAME('PO','PO_FO_COVER_MSG_NOT_MERGED');
4401: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4402: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4403: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4404:
4405:

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

4398:
4399: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4400: FND_MESSAGE.SET_NAME('PO','PO_FO_COVER_MSG_NOT_MERGED');
4401: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4402: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4403: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4404:
4405:
4406: FND_MESSAGE.SET_NAME('PO','PO_FO_AMEND_MSG_NOT_MERGED');

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

4399: /*Get the messages in covering page by replacing the tokens with correponding value.*/
4400: FND_MESSAGE.SET_NAME('PO','PO_FO_COVER_MSG_NOT_MERGED');
4401: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4402: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4403: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4404:
4405:
4406: FND_MESSAGE.SET_NAME('PO','PO_FO_AMEND_MSG_NOT_MERGED');
4407: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);

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

4402: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4403: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4404:
4405:
4406: FND_MESSAGE.SET_NAME('PO','PO_FO_AMEND_MSG_NOT_MERGED');
4407: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4408: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4409: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4410:

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

4403: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4404:
4405:
4406: FND_MESSAGE.SET_NAME('PO','PO_FO_AMEND_MSG_NOT_MERGED');
4407: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4408: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4409: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4410:
4411: g_is_contract_attached_doc := 'Y'; -- bug4026592

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

4404:
4405:
4406: FND_MESSAGE.SET_NAME('PO','PO_FO_AMEND_MSG_NOT_MERGED');
4407: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4408: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4409: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4410:
4411: g_is_contract_attached_doc := 'Y'; -- bug4026592
4412:

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

4405:
4406: FND_MESSAGE.SET_NAME('PO','PO_FO_AMEND_MSG_NOT_MERGED');
4407: FND_MESSAGE.SET_TOKEN('PO_NUM',l_po_number);
4408: FND_MESSAGE.SET_TOKEN('CHANGE_SUMMARY',l_change_summary);
4409: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4410:
4411: g_is_contract_attached_doc := 'Y'; -- bug4026592
4412:
4413: ELSE

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

4414:
4415: -- Primary attached document does not exist!
4416: -- Bug 4014230: Get buyer and supplier org tokens
4417:
4418: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4419: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4420: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:

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

4415: -- Primary attached document does not exist!
4416: -- Bug 4014230: Get buyer and supplier org tokens
4417:
4418: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4419: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4420: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');

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

4416: -- Bug 4014230: Get buyer and supplier org tokens
4417:
4418: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4419: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4420: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4424: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);

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

4417:
4418: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4419: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4420: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4424: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4425: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);

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

4419: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4420: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4424: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4425: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4426: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4427:

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

4420: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4424: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4425: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4426: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4427:
4428: g_is_contract_attached_doc := 'Y'; -- bug4026592

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

4421: PO_COMMUNICATION_PVT.g_cover_message := FND_MESSAGE.GET;
4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4424: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4425: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4426: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4427:
4428: g_is_contract_attached_doc := 'Y'; -- bug4026592
4429:

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

4422:
4423: FND_MESSAGE.SET_NAME('PO','PO_FO_MSG_TERMS_DOC_MISSING');
4424: FND_MESSAGE.SET_TOKEN('BUYER_ORG',po_communication_pvt.g_buyer_org);
4425: FND_MESSAGE.SET_TOKEN('SUPP_ORG',l_supp_org);
4426: PO_COMMUNICATION_PVT.g_amendment_message := FND_MESSAGE.GET;
4427:
4428: g_is_contract_attached_doc := 'Y'; -- bug4026592
4429:
4430: END IF;

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

4445: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_log_head || l_api_name ||'Timezone: ','Inside Timezone Exception Handler');
4446: END IF;
4447: RAISE;
4448: END;
4449: FND_MESSAGE.SET_NAME('PO','PO_FO_TIMEZONE');
4450: FND_MESSAGE.SET_TOKEN('TIME_OFFSET',l_offset);
4451: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME',l_timezone);
4452: PO_COMMUNICATION_PVT.g_timezone :=FND_MESSAGE.GET;
4453: END IF;

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

4446: END IF;
4447: RAISE;
4448: END;
4449: FND_MESSAGE.SET_NAME('PO','PO_FO_TIMEZONE');
4450: FND_MESSAGE.SET_TOKEN('TIME_OFFSET',l_offset);
4451: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME',l_timezone);
4452: PO_COMMUNICATION_PVT.g_timezone :=FND_MESSAGE.GET;
4453: END IF;
4454:

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

4447: RAISE;
4448: END;
4449: FND_MESSAGE.SET_NAME('PO','PO_FO_TIMEZONE');
4450: FND_MESSAGE.SET_TOKEN('TIME_OFFSET',l_offset);
4451: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME',l_timezone);
4452: PO_COMMUNICATION_PVT.g_timezone :=FND_MESSAGE.GET;
4453: END IF;
4454:
4455: PO_COMMUNICATION_PVT.g_vendor_id := l_vendor_id;

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

4448: END;
4449: FND_MESSAGE.SET_NAME('PO','PO_FO_TIMEZONE');
4450: FND_MESSAGE.SET_TOKEN('TIME_OFFSET',l_offset);
4451: FND_MESSAGE.SET_TOKEN('TIMEZONE_NAME',l_timezone);
4452: PO_COMMUNICATION_PVT.g_timezone :=FND_MESSAGE.GET;
4453: END IF;
4454:
4455: PO_COMMUNICATION_PVT.g_vendor_id := l_vendor_id;
4456:

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

4456:
4457: /*bug#3630737.
4458: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing
4459: DocumentType, po number and revision number as tokens*/
4460: FND_MESSAGE.SET_NAME('PO','PO_FO_DOCUMENT_NAME');
4461: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE',PO_COMMUNICATION_PVT.g_documentType);
4462: FND_MESSAGE.SET_TOKEN('PO_NUMBER',l_po_number);
4463: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER',PO_COMMUNICATION_PVT.g_revision_num);
4464: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;

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

4457: /*bug#3630737.
4458: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing
4459: DocumentType, po number and revision number as tokens*/
4460: FND_MESSAGE.SET_NAME('PO','PO_FO_DOCUMENT_NAME');
4461: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE',PO_COMMUNICATION_PVT.g_documentType);
4462: FND_MESSAGE.SET_TOKEN('PO_NUMBER',l_po_number);
4463: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER',PO_COMMUNICATION_PVT.g_revision_num);
4464: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
4465:

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

4458: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing
4459: DocumentType, po number and revision number as tokens*/
4460: FND_MESSAGE.SET_NAME('PO','PO_FO_DOCUMENT_NAME');
4461: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE',PO_COMMUNICATION_PVT.g_documentType);
4462: FND_MESSAGE.SET_TOKEN('PO_NUMBER',l_po_number);
4463: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER',PO_COMMUNICATION_PVT.g_revision_num);
4464: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
4465:
4466: -- SQl What: Querying for header short attachments

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

4459: DocumentType, po number and revision number as tokens*/
4460: FND_MESSAGE.SET_NAME('PO','PO_FO_DOCUMENT_NAME');
4461: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE',PO_COMMUNICATION_PVT.g_documentType);
4462: FND_MESSAGE.SET_TOKEN('PO_NUMBER',l_po_number);
4463: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER',PO_COMMUNICATION_PVT.g_revision_num);
4464: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
4465:
4466: -- SQl What: Querying for header short attachments
4467: -- SQL why: To display note to supplier data in header part of pdf document.

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

4460: FND_MESSAGE.SET_NAME('PO','PO_FO_DOCUMENT_NAME');
4461: FND_MESSAGE.SET_TOKEN('DOCUMENT_TYPE',PO_COMMUNICATION_PVT.g_documentType);
4462: FND_MESSAGE.SET_TOKEN('PO_NUMBER',l_po_number);
4463: FND_MESSAGE.SET_TOKEN('REVISION_NUMBER',PO_COMMUNICATION_PVT.g_revision_num);
4464: PO_COMMUNICATION_PVT.g_documentName := FND_MESSAGE.GET;
4465:
4466: -- SQl What: Querying for header short attachments
4467: -- SQL why: To display note to supplier data in header part of pdf document.
4468: -- SQL Join: vendor_id and header_id

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

6914:
6915: -- Bug 4044904 : Moved query above
6916:
6917: --retrieve draf from fnd_new_messages.
6918: FND_MESSAGE.SET_NAME('PO','PO_FO_DRAFT');
6919: x_draft := FND_MESSAGE.GET;
6920:
6921: EXCEPTION
6922: WHEN OTHERS THEN

Line 6919: x_draft := FND_MESSAGE.GET;

6915: -- Bug 4044904 : Moved query above
6916:
6917: --retrieve draf from fnd_new_messages.
6918: FND_MESSAGE.SET_NAME('PO','PO_FO_DRAFT');
6919: x_draft := FND_MESSAGE.GET;
6920:
6921: EXCEPTION
6922: WHEN OTHERS THEN
6923: x_pendingSignatureFlag := 'N';