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_BULK_MSG_PUB dependencies on FND_API

Line 14: G_msg_level_threshold NUMBER := FND_API.G_MISS_NUM;

10: G_PREVIOUS CONSTANT NUMBER := -4 ;
11:
12: -- global that holds the value of the message level profile option.
13:
14: G_msg_level_threshold NUMBER := FND_API.G_MISS_NUM;
15:
16: --message context record group
17: TYPE G_MSG_CONTEXT_REC_TYPE IS RECORD
18: (ENTITY_CODE VARCHAR2(30)

Line 145: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

141:
142: PROCEDURE Reset_Msg_Context(p_entity_code IN VARCHAR2);
143:
144: PROCEDURE Update_Msg_Context (
145: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

142: PROCEDURE Reset_Msg_Context(p_entity_code IN VARCHAR2);
143:
144: PROCEDURE Update_Msg_Context (
145: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

143:
144: PROCEDURE Update_Msg_Context (
145: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

144: PROCEDURE Update_Msg_Context (
145: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

145: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

146: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

147: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

Line 152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

148: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

149: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
157: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM

Line 154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

150: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
157: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
158: );

Line 155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

151: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
157: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
158: );
159:

Line 156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

152: ,p_source_document_type_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
157: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
158: );
159:
160: -- PROCEDURE Count_And_Get

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

153: ,p_source_document_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
154: ,p_source_document_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
155: ,p_attribute_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
156: ,p_constraint_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
157: -- ,p_process_activity IN NUMBER DEFAULT FND_API.G_MISS_NUM
158: );
159:
160: -- PROCEDURE Count_And_Get
161: --

Line 172: -- Parameters p_encoded IN VARCHAR2(1) := FND_API.G_TRUE Optional

168: -- procedure Get. It serves as a shortcut for API
169: -- developers. to make one call instead of making a call
170: -- to count, a check, and then another call to get.
171: --
172: -- Parameters p_encoded IN VARCHAR2(1) := FND_API.G_TRUE Optional
173: -- If TRUE the message is returned in an encoded
174: -- format, else it is translated and returned.
175: -- p_count OUT NUMBER
176: -- Message count.

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

178: -- Message data.
179: --
180:
181: PROCEDURE Count_And_Get
182: ( p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
183: p_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
184: p_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
185: );
186:

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

228: -- nothing, and no exception is raised.
229: -- If delete is passed no parameters it deletes the whole
230: -- message table.
231: --
232: -- Prameters p_msg_index IN NUMBER := FND_API.G_MISS_NUM Optional
233: -- holds the index of the message to be deleted.
234: --
235:
236: PROCEDURE Delete_Msg

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

268: -- p_msg_index_out OUT NUMBER
269:
270: PROCEDURE Get
271: ( p_msg_index IN NUMBER := G_NEXT ,
272: p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
273: p_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
274: p_msg_index_out OUT NOCOPY /* file.sql.39 change */ NUMBER
275: );
276:

Line 298: -- p_encoded IN VARCHAR2(1) := FND_API.G_TRUE Optional

294: -- G_LAST
295: -- G_PREVIOUS
296: -- Specific message index.
297: --
298: -- p_encoded IN VARCHAR2(1) := FND_API.G_TRUE Optional
299: -- When set to TRUE Get retrieves the message in an
300: -- encoded format. If FALSE, the function calls the
301: -- message dictionary utilities to translate the
302: -- message and do the token substitution, the message

Line 316: p_encoded IN VARCHAR2 := FND_API.G_TRUE

312: -- index i the message list.
313:
314: FUNCTION Get
315: ( p_msg_index IN NUMBER := G_NEXT ,
316: p_encoded IN VARCHAR2 := FND_API.G_TRUE
317: )
318: RETURN VARCHAR2;
319:
320: PROCEDURE Reset

Line 365: -- message 'FND_API_UNEXP_ERROR'.

361: --
362: -- USAGE Used by APIs to issue a standard message when
363: -- encountering an unexpected error.
364: -- Desc The IN parameters are used as tokens to a standard
365: -- message 'FND_API_UNEXP_ERROR'.
366: -- Parameters p_pkg_name IN VARCHAR2 Optional
367: -- p_procedure_name IN VARCHAR2 Optional
368: -- p_error_text IN VARCHAR2(240) Optional
369: -- If p_error_text is missing SQLERRM is used.

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

368: -- p_error_text IN VARCHAR2(240) Optional
369: -- If p_error_text is missing SQLERRM is used.
370:
371: PROCEDURE Build_Exc_Msg
372: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
373: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
374: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
375: );
376:

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

369: -- If p_error_text is missing SQLERRM is used.
370:
371: PROCEDURE Build_Exc_Msg
372: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
373: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
374: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
375: );
376:
377:

Line 374: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR

370:
371: PROCEDURE Build_Exc_Msg
372: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
373: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
374: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
375: );
376:
377:
378: -- PROCEDURE Add_Exc_Msg()

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

381: -- the messages the procedure Adds it to the global
382: -- mesage table.
383:
384: PROCEDURE Add_Exc_Msg
385: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
386: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
387: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
388: p_context_flag IN VARCHAR2 DEFAULT 'Y'
389: );

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

382: -- mesage table.
383:
384: PROCEDURE Add_Exc_Msg
385: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
386: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
387: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
388: p_context_flag IN VARCHAR2 DEFAULT 'Y'
389: );
390:

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

383:
384: PROCEDURE Add_Exc_Msg
385: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
386: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
387: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
388: p_context_flag IN VARCHAR2 DEFAULT 'Y'
389: );
390:
391: -- PROCEDURE Dump_Msg and Dump_List are used for debugging purposes.