eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_MSG_PUB dependencies on FND_API

Line 90: IF p_entity_code = FND_API.G_MISS_CHAR THEN

86: /* IF statements added for 2244395 */
87:
88: -- Write message context.
89:
90: IF p_entity_code = FND_API.G_MISS_CHAR THEN
91: G_msg_context_tbl(G_msg_context_count).ENTITY_CODE := NULL;
92: ELSE
93: G_msg_context_tbl(G_msg_context_count).ENTITY_CODE := p_entity_code;
94: END IF;

Line 96: IF p_entity_id = FND_API.G_MISS_NUM THEN

92: ELSE
93: G_msg_context_tbl(G_msg_context_count).ENTITY_CODE := p_entity_code;
94: END IF;
95:
96: IF p_entity_id = FND_API.G_MISS_NUM THEN
97: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := NULL;
98: ELSE
99: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;
100: END IF;

Line 102: IF p_entity_ref = FND_API.G_MISS_CHAR THEN

98: ELSE
99: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;
100: END IF;
101:
102: IF p_entity_ref = FND_API.G_MISS_CHAR THEN
103: G_msg_context_tbl(G_msg_context_count).ENTITY_REF := NULL;
104: ELSE
105: G_msg_context_tbl(G_msg_context_count).ENTITY_REF := p_entity_ref;
106: END IF;

Line 108: IF p_header_id = FND_API.G_MISS_NUM THEN

104: ELSE
105: G_msg_context_tbl(G_msg_context_count).ENTITY_REF := p_entity_ref;
106: END IF;
107:
108: IF p_header_id = FND_API.G_MISS_NUM THEN
109: G_msg_context_tbl(G_msg_context_count).HEADER_ID := NULL;
110: ELSE
111: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
112: END IF;

Line 114: IF p_line_id = FND_API.G_MISS_NUM THEN

110: ELSE
111: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
112: END IF;
113:
114: IF p_line_id = FND_API.G_MISS_NUM THEN
115: G_msg_context_tbl(G_msg_context_count).LINE_ID := NULL;
116: ELSE
117:
118: IF p_line_id is not null

Line 120: OR p_header_id = FND_API.G_MISS_NUM) THEN

116: ELSE
117:
118: IF p_line_id is not null
119: AND (p_header_id is null
120: OR p_header_id = FND_API.G_MISS_NUM) THEN
121:
122:
123: BEGIN
124: SELECT header_id

Line 138: IF p_order_source_id = FND_API.G_MISS_NUM THEN

134: END IF;
135: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;
136: END IF;
137:
138: IF p_order_source_id = FND_API.G_MISS_NUM THEN
139: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := NULL;
140: ELSE
141: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
142: END IF;

Line 144: IF p_orig_sys_document_ref = FND_API.G_MISS_CHAR THEN

140: ELSE
141: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
142: END IF;
143:
144: IF p_orig_sys_document_ref = FND_API.G_MISS_CHAR THEN
145: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := NULL;
146: ELSE
147: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
148: END IF;

Line 150: IF p_orig_sys_document_line_ref = FND_API.G_MISS_CHAR THEN

146: ELSE
147: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
148: END IF;
149:
150: IF p_orig_sys_document_line_ref = FND_API.G_MISS_CHAR THEN
151: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := NULL;
152: ELSE
153: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
154: END IF;

Line 156: IF p_orig_sys_shipment_ref = FND_API.G_MISS_CHAR THEN

152: ELSE
153: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
154: END IF;
155:
156: IF p_orig_sys_shipment_ref = FND_API.G_MISS_CHAR THEN
157: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_SHIPMENT_REF := NULL;
158: ELSE
159: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_SHIPMENT_REF := p_orig_sys_shipment_ref;
160: END IF;

Line 162: IF p_change_sequence = FND_API.G_MISS_CHAR THEN

158: ELSE
159: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_SHIPMENT_REF := p_orig_sys_shipment_ref;
160: END IF;
161:
162: IF p_change_sequence = FND_API.G_MISS_CHAR THEN
163: G_msg_context_tbl(G_msg_context_count).CHANGE_SEQUENCE := NULL;
164: ELSE
165: G_msg_context_tbl(G_msg_context_count).CHANGE_SEQUENCE := p_change_sequence;
166: END IF;

Line 168: IF p_source_document_type_id = FND_API.G_MISS_NUM THEN

164: ELSE
165: G_msg_context_tbl(G_msg_context_count).CHANGE_SEQUENCE := p_change_sequence;
166: END IF;
167:
168: IF p_source_document_type_id = FND_API.G_MISS_NUM THEN
169: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := NULL;
170: ELSE
171: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
172: END IF;

Line 174: IF p_source_document_id = FND_API.G_MISS_NUM THEN

170: ELSE
171: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
172: END IF;
173:
174: IF p_source_document_id = FND_API.G_MISS_NUM THEN
175: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := NULL;
176: ELSE
177: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
178: END IF;

Line 180: IF p_source_document_line_id = FND_API.G_MISS_NUM THEN

176: ELSE
177: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
178: END IF;
179:
180: IF p_source_document_line_id = FND_API.G_MISS_NUM THEN
181: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := NULL;
182: ELSE
183: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
184: END IF;

Line 186: IF p_attribute_code = FND_API.G_MISS_CHAR THEN

182: ELSE
183: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
184: END IF;
185:
186: IF p_attribute_code = FND_API.G_MISS_CHAR THEN
187: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := NULL;
188: ELSE
189: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
190: END IF;

Line 192: IF p_constraint_id = FND_API.G_MISS_NUM THEN

188: ELSE
189: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
190: END IF;
191:
192: IF p_constraint_id = FND_API.G_MISS_NUM THEN
193: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := NULL;
194: ELSE
195: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := p_constraint_id;
196: END IF;

Line 208: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

204: END IF;
205: END;
206:
207: PROCEDURE Update_Msg_Context (
208: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

205: END;
206:
207: PROCEDURE Update_Msg_Context (
208: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

206:
207: PROCEDURE Update_Msg_Context (
208: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

207: PROCEDURE Update_Msg_Context (
208: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

208: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

209: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

210: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

211: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

212: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

213: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

214: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

215: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
223: ) IS

Line 220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

216: ,p_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
223: ) IS
224: --

Line 221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

217: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
223: ) IS
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM

218: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
219: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
220: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
221: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
222: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
223: ) IS
224: --
225: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
226: --

Line 230: if p_entity_id <> FND_API.G_MISS_NUM then

226: --
227: Begin
228:
229: -- if G_msg_context_tbl(G_msg_context_count).ENTITY_CODE = p_entity_code then
230: if p_entity_id <> FND_API.G_MISS_NUM then
231: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;
232: end if;
233: if p_header_id <> FND_API.G_MISS_NUM then
234: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;

Line 233: if p_header_id <> FND_API.G_MISS_NUM then

229: -- if G_msg_context_tbl(G_msg_context_count).ENTITY_CODE = p_entity_code then
230: if p_entity_id <> FND_API.G_MISS_NUM then
231: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;
232: end if;
233: if p_header_id <> FND_API.G_MISS_NUM then
234: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
235: end if;
236: if p_line_id <> FND_API.G_MISS_NUM then
237: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;

Line 236: if p_line_id <> FND_API.G_MISS_NUM then

232: end if;
233: if p_header_id <> FND_API.G_MISS_NUM then
234: G_msg_context_tbl(G_msg_context_count).HEADER_ID := p_header_id;
235: end if;
236: if p_line_id <> FND_API.G_MISS_NUM then
237: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;
238: end if;
239: if p_order_source_id <> FND_API.G_MISS_NUM then
240: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;

Line 239: if p_order_source_id <> FND_API.G_MISS_NUM then

235: end if;
236: if p_line_id <> FND_API.G_MISS_NUM then
237: G_msg_context_tbl(G_msg_context_count).LINE_ID := p_line_id;
238: end if;
239: if p_order_source_id <> FND_API.G_MISS_NUM then
240: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
241: end if;
242: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then
243: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;

Line 242: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then

238: end if;
239: if p_order_source_id <> FND_API.G_MISS_NUM then
240: G_msg_context_tbl(G_msg_context_count).ORDER_SOURCE_ID := p_order_source_id;
241: end if;
242: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then
243: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
244: end if;
245: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then
246: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;

Line 245: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then

241: end if;
242: if p_orig_sys_document_ref <> FND_API.G_MISS_CHAR then
243: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_REF := p_orig_sys_document_ref;
244: end if;
245: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then
246: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
247: end if;
248: if p_orig_sys_shipment_ref <> FND_API.G_MISS_CHAR then
249: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_SHIPMENT_REF := p_orig_sys_shipment_ref;

Line 248: if p_orig_sys_shipment_ref <> FND_API.G_MISS_CHAR then

244: end if;
245: if p_orig_sys_document_line_ref <> FND_API.G_MISS_CHAR then
246: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_DOCUMENT_LINE_REF := p_orig_sys_document_line_ref;
247: end if;
248: if p_orig_sys_shipment_ref <> FND_API.G_MISS_CHAR then
249: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_SHIPMENT_REF := p_orig_sys_shipment_ref;
250: end if;
251: if p_change_sequence <> FND_API.G_MISS_CHAR then
252: G_msg_context_tbl(G_msg_context_count).CHANGE_SEQUENCE := p_change_sequence;

Line 251: if p_change_sequence <> FND_API.G_MISS_CHAR then

247: end if;
248: if p_orig_sys_shipment_ref <> FND_API.G_MISS_CHAR then
249: G_msg_context_tbl(G_msg_context_count).ORIG_SYS_SHIPMENT_REF := p_orig_sys_shipment_ref;
250: end if;
251: if p_change_sequence <> FND_API.G_MISS_CHAR then
252: G_msg_context_tbl(G_msg_context_count).CHANGE_SEQUENCE := p_change_sequence;
253: end if;
254: if p_source_document_type_id <> FND_API.G_MISS_NUM then
255: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;

Line 254: if p_source_document_type_id <> FND_API.G_MISS_NUM then

250: end if;
251: if p_change_sequence <> FND_API.G_MISS_CHAR then
252: G_msg_context_tbl(G_msg_context_count).CHANGE_SEQUENCE := p_change_sequence;
253: end if;
254: if p_source_document_type_id <> FND_API.G_MISS_NUM then
255: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
256: end if;
257: if p_source_document_id <> FND_API.G_MISS_NUM then
258: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;

Line 257: if p_source_document_id <> FND_API.G_MISS_NUM then

253: end if;
254: if p_source_document_type_id <> FND_API.G_MISS_NUM then
255: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_TYPE_ID := p_source_document_type_id;
256: end if;
257: if p_source_document_id <> FND_API.G_MISS_NUM then
258: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
259: end if;
260: if p_source_document_line_id <> FND_API.G_MISS_NUM then
261: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;

Line 260: if p_source_document_line_id <> FND_API.G_MISS_NUM then

256: end if;
257: if p_source_document_id <> FND_API.G_MISS_NUM then
258: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_ID := p_source_document_id;
259: end if;
260: if p_source_document_line_id <> FND_API.G_MISS_NUM then
261: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
262: end if;
263: if p_attribute_code <> FND_API.G_MISS_CHAR then
264: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;

Line 263: if p_attribute_code <> FND_API.G_MISS_CHAR then

259: end if;
260: if p_source_document_line_id <> FND_API.G_MISS_NUM then
261: G_msg_context_tbl(G_msg_context_count).SOURCE_DOCUMENT_LINE_ID := p_source_document_line_id;
262: end if;
263: if p_attribute_code <> FND_API.G_MISS_CHAR then
264: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
265: end if;
266: if p_constraint_id <> FND_API.G_MISS_NUM then
267: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := p_constraint_id;

Line 266: if p_constraint_id <> FND_API.G_MISS_NUM then

262: end if;
263: if p_attribute_code <> FND_API.G_MISS_CHAR then
264: G_msg_context_tbl(G_msg_context_count).ATTRIBUTE_CODE := p_attribute_code;
265: end if;
266: if p_constraint_id <> FND_API.G_MISS_NUM then
267: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := p_constraint_id;
268: end if;
269: /* if p_process_activity <> FND_API.G_MISS_NUM then
270: G_msg_context_tbl(G_msg_context_count).PROCESS_ACTIVITY := p_process_activity;

Line 269: /* if p_process_activity <> FND_API.G_MISS_NUM then

265: end if;
266: if p_constraint_id <> FND_API.G_MISS_NUM then
267: G_msg_context_tbl(G_msg_context_count).CONSTRAINT_ID := p_constraint_id;
268: end if;
269: /* if p_process_activity <> FND_API.G_MISS_NUM then
270: G_msg_context_tbl(G_msg_context_count).PROCESS_ACTIVITY := p_process_activity;
271: end if;*/
272: /*
273: G_msg_context_tbl(G_msg_context_count).ENTITY_ID := p_entity_id;

Line 342: ( p_encoded IN VARCHAR2 := FND_API.G_TRUE ,

338: -- PROCEDURE Count_And_Get
339: --
340:
341: PROCEDURE Count_And_Get
342: ( p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
343: p_count OUT NOCOPY NUMBER ,
344:
345: p_data OUT NOCOPY VARCHAR2
346:

Line 560: -- Prameters p_msg_index IN NUMBER := FND_API.G_MISS_NUM Optional

556: -- nothing, and no exception is raised.
557: -- If delete is passed no parameters it deletes the whole
558: -- message table.
559: --
560: -- Prameters p_msg_index IN NUMBER := FND_API.G_MISS_NUM Optional
561: -- holds the index of the message to be deleted.
562: --
563:
564: PROCEDURE Delete_Msg

Line 723: p_encoded IN VARCHAR2 := FND_API.G_TRUE ,

719: --
720:
721: PROCEDURE Get
722: ( p_msg_index IN NUMBER := G_NEXT ,
723: p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
724: p_data OUT NOCOPY VARCHAR2 ,
725:
726: p_msg_index_out OUT NOCOPY NUMBER
727:

Line 754: IF FND_API.To_Boolean( p_encoded ) THEN

750:
751: p_data := G_msg_tbl(G_msg_index).Message_Text;
752:
753: ELSE
754: IF FND_API.To_Boolean( p_encoded ) THEN
755:
756: p_data := G_msg_tbl( G_msg_index ).Message;
757:
758: ELSE

Line 790: p_encoded IN VARCHAR2 := FND_API.G_TRUE

786: --
787:
788: FUNCTION Get
789: ( p_msg_index IN NUMBER := G_NEXT ,
790: p_encoded IN VARCHAR2 := FND_API.G_TRUE
791: )
792: RETURN VARCHAR2
793: IS
794: l_data VARCHAR2(2000) ;

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: p_procedure_name => l_procedure_name ,
855: p_error_text => 'Invalid p_mode: '||p_mode
856: );
857:
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859:
860: END IF;
861:
862: EXCEPTION

Line 893: IF G_msg_level_threshold = FND_API.G_MISS_NUM THEN

889: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
890: --
891: BEGIN
892:
893: IF G_msg_level_threshold = FND_API.G_MISS_NUM THEN
894:
895: -- Read the Profile option value.
896:
897: G_msg_level_threshold :=

Line 917: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

913: END IF;
914: END; -- Check_Msg_Level
915:
916: PROCEDURE Build_Exc_Msg
917: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
918: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
919: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
920: )
921: IS

Line 918: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

914: END; -- Check_Msg_Level
915:
916: PROCEDURE Build_Exc_Msg
917: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
918: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
919: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
920: )
921: IS
922: l_error_text VARCHAR2(2000) := p_error_text ;

Line 919: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR

915:
916: PROCEDURE Build_Exc_Msg
917: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
918: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
919: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
920: )
921: IS
922: l_error_text VARCHAR2(2000) := p_error_text ;
923: --

Line 930: IF p_error_text = FND_API.G_MISS_CHAR THEN

926: BEGIN
927:
928: -- If p_error_text is missing use SQLERRM.
929:
930: IF p_error_text = FND_API.G_MISS_CHAR THEN
931:
932: l_error_text := SUBSTR (SQLERRM , 1 , 2000);
933:
934: END IF;

Line 938: IF p_pkg_name <> FND_API.G_MISS_CHAR THEN

934: END IF;
935:
936: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
937:
938: IF p_pkg_name <> FND_API.G_MISS_CHAR THEN
939: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_pkg_name);
940: END IF;
941:
942: IF p_procedure_name <> FND_API.G_MISS_CHAR THEN

Line 942: IF p_procedure_name <> FND_API.G_MISS_CHAR THEN

938: IF p_pkg_name <> FND_API.G_MISS_CHAR THEN
939: FND_MESSAGE.SET_TOKEN('PKG_NAME',p_pkg_name);
940: END IF;
941:
942: IF p_procedure_name <> FND_API.G_MISS_CHAR THEN
943: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure_name);
944: END IF;
945:
946: IF l_error_text <> FND_API.G_MISS_CHAR THEN

Line 946: IF l_error_text <> FND_API.G_MISS_CHAR THEN

942: IF p_procedure_name <> FND_API.G_MISS_CHAR THEN
943: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',p_procedure_name);
944: END IF;
945:
946: IF l_error_text <> FND_API.G_MISS_CHAR THEN
947: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',l_error_text);
948: END IF;
949: EXCEPTION
950: WHEN OTHERS THEN

Line 957: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

953: END IF;
954: END; -- Build_Exc_Msg
955:
956: PROCEDURE Add_Exc_Msg
957: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
958: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
959: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
960: p_context_flag IN VARCHAR2 DEFAULT 'Y'
961: )

Line 958: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

954: END; -- Build_Exc_Msg
955:
956: PROCEDURE Add_Exc_Msg
957: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
958: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
959: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
960: p_context_flag IN VARCHAR2 DEFAULT 'Y'
961: )
962: IS

Line 959: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

955:
956: PROCEDURE Add_Exc_Msg
957: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
958: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
959: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
960: p_context_flag IN VARCHAR2 DEFAULT 'Y'
961: )
962: IS
963: --

Line 1579: x_return_status := FND_API.G_RET_STS_SUCCESS;

1575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1576: --
1577: BEGIN
1578:
1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580:
1581: IF OE_Msg_pub.Count_Msg <> 1 THEN
1582:
1583: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1583: x_return_status := FND_API.G_RET_STS_ERROR;

1579: x_return_status := FND_API.G_RET_STS_SUCCESS;
1580:
1581: IF OE_Msg_pub.Count_Msg <> 1 THEN
1582:
1583: x_return_status := FND_API.G_RET_STS_ERROR;
1584:
1585: ELSE
1586:
1587:

Line 1607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1603: l_WF_Roles_Tbl := Oe_PC_Constraints_Admin_Pub.Get_Authorized_WF_Roles
1604: (p_constraint_id => l_constraint_id
1605: ,x_return_status => l_return_status);
1606:
1607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;

Line 1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1604: (p_constraint_id => l_constraint_id
1605: ,x_return_status => l_return_status);
1606:
1607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612:

Line 1609: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1605: ,x_return_status => l_return_status);
1606:
1607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612:
1613: l_msg_length := length(l_message);

Line 1610: RAISE FND_API.G_EXC_ERROR;

1606:
1607: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1609: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1610: RAISE FND_API.G_EXC_ERROR;
1611: END IF;
1612:
1613: l_msg_length := length(l_message);
1614:

Line 1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1644:
1645: WHEN OTHERS THEN
1646: /* l_message := 'Something wrong';
1647: Return l_message;*/
1648: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1649:
1650:
1651: END Get_Single_Message;
1652: