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)
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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(
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
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.
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:
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
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:
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
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
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.
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:
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:
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()
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: );
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:
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.