APPS.PO_COMMUNICATION_PVT dependencies on FND_NEW_MESSAGES

Line 734: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186

730: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
731: l_doc_num_rel varchar2(30);
732: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186;
733: l_ga_flag varchar2(1) := null; -- Bug # 3290385
734: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186
735: l_attachments_exist VARCHAR2(1); --
736:
737: -- Bug 4099027. length 50 because this variable is a concatenation of
738: -- document_type_code and document_subtype

Line 3527: l_message FND_NEW_MESSAGES.message_text%TYPE; --Bug 3274081

3523: l_itemkey varchar2(60);
3524: l_document blob;
3525: l_withTerms varchar2(1);
3526: l_document_length number;
3527: l_message FND_NEW_MESSAGES.message_text%TYPE; --Bug 3274081
3528: x_progress varchar2(300);
3529:
3530: l_draft_id number;
3531:

Line 3696: l_message FND_NEW_MESSAGES.message_text%TYPE;

3692: l_itemkey varchar2(60);
3693: l_document blob;
3694: l_withTerms varchar2(1);
3695: l_document_length number;
3696: l_message FND_NEW_MESSAGES.message_text%TYPE;
3697:
3698: x_progress varchar2(300);
3699:
3700: BEGIN

Line 3811: l_message FND_NEW_MESSAGES.message_text%TYPE; --Bug#3274081

3807: l_itemkey varchar2(60);
3808: l_document blob;
3809: l_withTerms varchar2(1);
3810: l_document_length number;
3811: l_message FND_NEW_MESSAGES.message_text%TYPE; --Bug#3274081
3812:
3813:
3814: x_progress varchar2(300);
3815: l_draft_id number;

Line 4057: l_message FND_NEW_MESSAGES.message_text%TYPE;

4053: l_withTerms varchar2(1);
4054:
4055: l_itemtype po_document_types.wf_approval_itemtype%type;
4056: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
4057: l_message FND_NEW_MESSAGES.message_text%TYPE;
4058:
4059: l_okc_doc_length number; -- Bug 4173198
4060:
4061: x_progress varchar2(300);

Line 4248: l_message FND_NEW_MESSAGES.message_text%TYPE;

4244: l_document fnd_lobs.file_data%type;
4245: l_document_length number;
4246: l_progress varchar2(300);
4247: l_filecontent_type fnd_lobs.file_content_type%type;
4248: l_message FND_NEW_MESSAGES.message_text%TYPE;
4249:
4250:
4251: BEGIN
4252: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Begin';

Line 5216: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing

5212:
5213: PO_COMMUNICATION_PVT.g_vendor_id := l_vendor_id;
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);

Line 5522: l_xml_message_query :='CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in (

5518: --Bug 3670603: Added "PO_WF_NOTIF_PROMISED_DATE" message name
5519: --Bug3670603: Added "PO_WF_NOTIF_NEEDBY_DATE" message name
5520: --Bug3836856: Addded "PO_FO_PAGE"for retrieving the page number message
5521:
5522: l_xml_message_query :='CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in (
5523: ''PO_WF_NOTIF_REVISION'',
5524: ''PO_WF_NOTIF_VENDOR_NO'',
5525: ''PO_WF_NOTIF_PAYMENT_TERMS'',
5526: ''PO_WF_NOTIF_FREIGHT_TERMS'',

Line 8112: --retrieve draf from fnd_new_messages.

8108: x_documentName := PO_COMMUNICATION_PVT.g_documentName; -- document name
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