DBA Data[Home] [Help]

APPS.OE_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 143: p_entity_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

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

Line 144: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 145: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 146: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 147: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

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

Line 148: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

144: ,p_entity_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
145: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
146: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
150: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

145: ,p_header_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
146: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
150: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

146: ,p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
147: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
150: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_change_sequence IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

147: ,p_order_source_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
148: ,p_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
150: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_orig_sys_document_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
149: ,p_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
150: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_orig_sys_document_line_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
150: ,p_orig_sys_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_shipment_ref IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
151: ,p_change_sequence 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_change_sequence 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 get_msg_context(

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 get_msg_context(
161: p_msg_index IN NUMBER

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

208: -- procedure Get. It serves as a shortcut for API
209: -- developers. to make one call instead of making a call
210: -- to count, a check, and then another call to get.
211: --
212: -- Parameters p_encoded IN VARCHAR2(1) := FND_API.G_TRUE Optional
213: -- If TRUE the message is returned in an encoded
214: -- format, else it is translated and returned.
215: -- p_count OUT NUMBER
216: -- Message count.

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

218: -- Message data.
219: --
220:
221: PROCEDURE Count_And_Get
222: ( p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
223: p_count OUT NOCOPY NUMBER ,
224:
225: p_data OUT NOCOPY VARCHAR2
226:

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

269: -- nothing, and no exception is raised.
270: -- If delete is passed no parameters it deletes the whole
271: -- message table.
272: --
273: -- Prameters p_msg_index IN NUMBER := FND_API.G_MISS_NUM Optional
274: -- holds the index of the message to be deleted.
275: --
276:
277: PROCEDURE Delete_Msg

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

309: -- p_msg_index_out OUT NUMBER
310:
311: PROCEDURE Get
312: ( p_msg_index IN NUMBER := G_NEXT ,
313: p_encoded IN VARCHAR2 := FND_API.G_TRUE ,
314: p_data OUT NOCOPY VARCHAR2 ,
315:
316: p_msg_index_out OUT NOCOPY NUMBER
317:

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

337: -- G_LAST
338: -- G_PREVIOUS
339: -- Specific message index.
340: --
341: -- p_encoded IN VARCHAR2(1) := FND_API.G_TRUE Optional
342: -- When set to TRUE Get retrieves the message in an
343: -- encoded format. If FALSE, the function calls the
344: -- message dictionary utilities to translate the
345: -- message and do the token substitution, the message

Line 359: p_encoded IN VARCHAR2 := FND_API.G_TRUE

355: -- index i the message list.
356:
357: FUNCTION Get
358: ( p_msg_index IN NUMBER := G_NEXT ,
359: p_encoded IN VARCHAR2 := FND_API.G_TRUE
360: )
361: RETURN VARCHAR2;
362:
363: PROCEDURE Reset

Line 408: -- message 'FND_API_UNEXP_ERROR'.

404: --
405: -- USAGE Used by APIs to issue a standard message when
406: -- encountering an unexpected error.
407: -- Desc The IN parameters are used as tokens to a standard
408: -- message 'FND_API_UNEXP_ERROR'.
409: -- Parameters p_pkg_name IN VARCHAR2 Optional
410: -- p_procedure_name IN VARCHAR2 Optional
411: -- p_error_text IN VARCHAR2(240) Optional
412: -- If p_error_text is missing SQLERRM is used.

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

411: -- p_error_text IN VARCHAR2(240) Optional
412: -- If p_error_text is missing SQLERRM is used.
413:
414: PROCEDURE Build_Exc_Msg
415: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
416: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
417: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
418: );
419:

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

412: -- If p_error_text is missing SQLERRM is used.
413:
414: PROCEDURE Build_Exc_Msg
415: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
416: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
417: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
418: );
419:
420:

Line 417: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR

413:
414: PROCEDURE Build_Exc_Msg
415: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
416: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
417: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR
418: );
419:
420:
421: -- PROCEDURE Add_Exc_Msg()

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

424: -- the messages the procedure Adds it to the global
425: -- mesage table.
426:
427: PROCEDURE Add_Exc_Msg
428: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
429: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
430: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
431: p_context_flag IN VARCHAR2 DEFAULT 'Y'
432: );

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

425: -- mesage table.
426:
427: PROCEDURE Add_Exc_Msg
428: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
429: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
430: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
431: p_context_flag IN VARCHAR2 DEFAULT 'Y'
432: );
433:

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

426:
427: PROCEDURE Add_Exc_Msg
428: ( p_pkg_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
429: p_procedure_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
430: p_error_text IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
431: p_context_flag IN VARCHAR2 DEFAULT 'Y'
432: );
433:
434: -- PROCEDURE Dump_Msg and Dump_List are used for debugging purposes.