APPS.PO_COMMUNICATION_PVT dependencies on FND_NEW_MESSAGES

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

627: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
628: l_doc_num_rel varchar2(30);
629: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186;
630: l_ga_flag varchar2(1) := null; -- Bug # 3290385
631: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186
632: l_attachments_exist VARCHAR2(1); --
633:
634: -- Bug 4099027. length 50 because this variable is a concatenation of
635: -- document_type_code and document_subtype

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

3098: l_itemkey varchar2(60);
3099: l_document blob;
3100: l_withTerms varchar2(1);
3101: l_document_length number;
3102: l_message FND_NEW_MESSAGES.message_text%TYPE; --Bug 3274081
3103: x_progress varchar2(300);
3104:
3105: BEGIN
3106:

Line 3219: l_message FND_NEW_MESSAGES.message_text%TYPE;

3215: l_itemkey varchar2(60);
3216: l_document blob;
3217: l_withTerms varchar2(1);
3218: l_document_length number;
3219: l_message FND_NEW_MESSAGES.message_text%TYPE;
3220:
3221: x_progress varchar2(300);
3222:
3223: BEGIN

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

3328: l_itemkey varchar2(60);
3329: l_document blob;
3330: l_withTerms varchar2(1);
3331: l_document_length number;
3332: l_message FND_NEW_MESSAGES.message_text%TYPE; --Bug#3274081
3333:
3334:
3335: x_progress varchar2(300);
3336:

Line 3522: l_message FND_NEW_MESSAGES.message_text%TYPE;

3518: l_withTerms varchar2(1);
3519:
3520: l_itemtype po_document_types.wf_approval_itemtype%type;
3521: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
3522: l_message FND_NEW_MESSAGES.message_text%TYPE;
3523:
3524: l_okc_doc_length number; -- Bug 4173198
3525:
3526: x_progress varchar2(300);

Line 3694: l_message FND_NEW_MESSAGES.message_text%TYPE;

3690: l_document fnd_lobs.file_data%type;
3691: l_document_length number;
3692: l_progress varchar2(300);
3693: l_filecontent_type fnd_lobs.file_content_type%type;
3694: l_message FND_NEW_MESSAGES.message_text%TYPE;
3695:
3696:
3697: BEGIN
3698: l_progress := 'PO_COMMUNICATION_PVT.zip_attach : Begin';

Line 4458: Retrieve PO_FO_DOCUMENT_NAME from fnd_new_messages by passing

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

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

4687: --Bug 3670603: Added "PO_WF_NOTIF_PROMISED_DATE" message name
4688: --Bug3670603: Added "PO_WF_NOTIF_NEEDBY_DATE" message name
4689: --Bug3836856: Addded "PO_FO_PAGE"for retrieving the page number message
4690:
4691: l_xml_message_query :='CURSOR (SELECT message_name message, message_text text FROM fnd_new_messages WHERE message_name in (
4692: ''PO_WF_NOTIF_REVISION'',
4693: ''PO_WF_NOTIF_VENDOR_NO'',
4694: ''PO_WF_NOTIF_PAYMENT_TERMS'',
4695: ''PO_WF_NOTIF_FREIGHT_TERMS'',

Line 6917: --retrieve draf from fnd_new_messages.

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