DBA Data[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';