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 939: l_two_part_general_msg fnd_new_messages.message_text%TYPE;

935: -- 3 (`FromSupplierTechnical', `FromSupplierCommercial')
936: l_attach_categ_option NUMBER := 1;
937:
938: -- three variables to store two-part messages.
939: l_two_part_general_msg fnd_new_messages.message_text%TYPE;
940: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;
941: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;
942:
943: BEGIN

Line 940: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;

936: l_attach_categ_option NUMBER := 1;
937:
938: -- three variables to store two-part messages.
939: l_two_part_general_msg fnd_new_messages.message_text%TYPE;
940: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;
941: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;
942:
943: BEGIN
944: IF p_bid_number <= 0 THEN

Line 941: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;

937:
938: -- three variables to store two-part messages.
939: l_two_part_general_msg fnd_new_messages.message_text%TYPE;
940: l_two_part_tech_msg fnd_new_messages.message_text%TYPE;
941: l_two_part_comm_msg fnd_new_messages.message_text%TYPE;
942:
943: BEGIN
944: IF p_bid_number <= 0 THEN
945: l_is_bidpdf := 'N';

Line 2810: fnd_new_messages

2806: cursor (
2807: select message_name,
2808: message_text
2809: from
2810: fnd_new_messages
2811: where message_name in ('PON_AUC_TITLE', --title
2812: 'PON_AUCTS_OPEN', -- Open Date
2813: 'PON_AUCTS_CLOSE', -- Close Date
2814: 'PON_AUCTS_PREVIEW', -- Preview Date

Line 3123: fnd_new_messages

3119: cursor ( -- this will have all messages that are specific to sourcing type
3120: select substr(message_name,1,length(message_name)-2) message_name,
3121: message_text
3122: from
3123: fnd_new_messages
3124: where message_name in (
3125: 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.
3126: pon_printing_pkg.get_document_message_name('PON_RESPONSE_STYLE',doctypes.message_suffix) -- Response Style
3127: ) and application_id =396