DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on FND_NEW_MESSAGES

Line 86: l_message fnd_new_messages.message_text%TYPE;

82: FUNCTION GET_MESSAGES(p_message_name in VARCHAR2,
83: p_token_name in VARCHAR2,
84: p_token_value in VARCHAR2) return VARCHAR2 is
85:
86: l_message fnd_new_messages.message_text%TYPE;
87:
88: BEGIN
89:
90: fnd_message.set_name('PON',p_message_name);

Line 108: l_message fnd_new_messages.message_text%TYPE;

104: p_token_value1 in VARCHAR2,
105: p_token_name2 in VARCHAR2,
106: p_token_value2 in VARCHAR2) return VARCHAR2 is
107:
108: l_message fnd_new_messages.message_text%TYPE;
109:
110: BEGIN
111:
112: fnd_message.set_name('PON',p_message_name);

Line 133: l_message fnd_new_messages.message_text%TYPE;

129: p_token_value2 in VARCHAR2,
130: p_token_name3 in VARCHAR2,
131: p_token_value3 in VARCHAR2) return VARCHAR2 is
132:
133: l_message fnd_new_messages.message_text%TYPE;
134:
135: BEGIN
136:
137: fnd_message.set_name('PON',p_message_name);

Line 157: l_message fnd_new_messages.message_text%TYPE;

153: p_message_suffix in VARCHAR2,
154: p_token_name in VARCHAR2,
155: p_token_value in VARCHAR2) return VARCHAR2 is
156:
157: l_message fnd_new_messages.message_text%TYPE;
158:
159: BEGIN
160:
161: l_message := get_messages(p_message_name||p_message_suffix,

Line 682: from fnd_new_messages

678: when others then
679:
680: select message_text
681: into l_printing_text
682: from fnd_new_messages
683: where message_name = 'PON_AUC_CONTACT_BUYER'
684: and language_code = USERENV('LANG')
685: and application_id = 396;
686:

Line 957: from fnd_new_messages

953: AND pbp.AUCTION_HEADER_ID = pet.AUCTION_HEADER_ID(+) --Modify by Chaoqun 05-Mar-2009
954: AND pbp.sequence = pet.supplier_sequence(+)
955: AND decode(pet.current_row_flag,null,'Y',pet.current_row_flag) = 'Y') AS EMD_SUMMARY,
956: CURSOR (select message_name, message_text
957: from fnd_new_messages
958: where message_name in
959: ('PON_NEGOTIATION_NUMBER',
960: 'PON_NEGOTIATION_TITLE', 'PON_NEG_CLOSE_DATE',
961: 'PON_EMD_QUOTE_CURRENCY', 'PON_EMD_TYPE' -- EMD Type

Line 1139: from fnd_new_messages

1135: 'N' as EMD_RECEIVED_FLAG,
1136: 'N' as EMD_REFUNDED_FLAG,
1137: 'N' as EMD_FORFEITED_FLAG,
1138: cursor (select message_name, message_text
1139: from fnd_new_messages
1140: where message_name in
1141: ('PON_EMD_NEGOTIATION_NO',
1142: 'PON_EMD_NEGOTIATION_TITLE',
1143: 'PON_EMD_SUPPLIER_NAME', 'PON_EMD_SUPPLIER_SITE',

Line 1374: from fnd_new_messages

1370: and flv.LOOKUP_CODE(+) = petr.Payment_Type_Code
1371: -----------------------------------
1372: order by TRX_ID) as EMD_DETAILS,
1373: cursor (select message_name, message_text
1374: from fnd_new_messages
1375: where message_name in
1376: ('PON_EMD_NEGOTIATION_NO',
1377: 'PON_EMD_NEGOTIATION_TITLE',
1378: 'PON_EMD_SUPPLIER_NAME', 'PON_EMD_SUPPLIER_SITE',

Line 1600: from fnd_new_messages

1596: ) as EMD_DETAILS,*/
1597: --End: Deleted by Chaoqun on 19-Mar-2009
1598:
1599: cursor (select message_name, message_text
1600: from fnd_new_messages
1601: where message_name in
1602: ('PON_EMD_NEGOTIATION_NO',
1603: 'PON_EMD_NEGOTIATION_TITLE',
1604: 'PON_EMD_SUPPLIER_NAME', 'PON_EMD_SUPPLIER_SITE',

Line 1874: l_two_part_general_msg fnd_new_messages.message_text%TYPE;

1870: -- 3 (`FromSupplierTechnical', `FromSupplierCommercial')
1871: l_attach_categ_option NUMBER := 1;
1872:
1873: -- three variables to store two-part messages.
1874: l_two_part_general_msg fnd_new_messages.message_text%TYPE;
1875: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;
1876: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;
1877:
1878: linesCtx DBMS_XMLGEN.ctxHandle;

Line 1875: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;

1871: l_attach_categ_option NUMBER := 1;
1872:
1873: -- three variables to store two-part messages.
1874: l_two_part_general_msg fnd_new_messages.message_text%TYPE;
1875: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;
1876: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;
1877:
1878: linesCtx DBMS_XMLGEN.ctxHandle;
1879: attrsCtx DBMS_XMLGEN.ctxHandle;

Line 1876: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;

1872:
1873: -- three variables to store two-part messages.
1874: l_two_part_general_msg fnd_new_messages.message_text%TYPE;
1875: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;
1876: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;
1877:
1878: linesCtx DBMS_XMLGEN.ctxHandle;
1879: attrsCtx DBMS_XMLGEN.ctxHandle;
1880: payItemsCtx DBMS_XMLGEN.ctxHandle;

Line 4442: fnd_new_messages

4438: OPEN generic_msgs_cursor FOR
4439: select message_name,
4440: message_text
4441: from
4442: fnd_new_messages
4443: where message_name in ('PON_AUC_TITLE', --title
4444: 'PON_AUCTS_OPEN', -- Open Date
4445: 'PON_AUCTS_CLOSE', -- Close Date
4446: 'PON_AUCTS_PREVIEW', -- Preview Date

Line 4792: fnd_new_messages msgs

4788: message_text
4789: FROM
4790: pon_auction_headers_all pah,
4791: pon_auc_doctypes doctypes,
4792: fnd_new_messages msgs
4793: where pah.auction_header_id = p_auction_header_id
4794: AND doctypes.doctype_id = pah.doctype_id
4795: AND msgs.message_name in (
4796: pon_printing_pkg.get_document_message_name('PON_CONT_MERGE_WARNING',doctypes.message_suffix), -- Note: There are contract terms associated to the RFQ that are not included in this document. The contract terms are an inseparable part of this RFQ.