1 PACKAGE xla_amb_setup_err_pkg AS
2 -- $Header: xlaamerr.pkh 120.5 2005/06/28 20:10:19 dcshah ship $
3 /*===========================================================================+
4 | Copyright (c) 2001-2002 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +============================================================================+
8 | PACKAGE NAME |
9 | xla_amb_setup_err_pkg |
10 | |
11 | DESCRIPTION |
12 | This is the specification of the package that handles errors for |
13 | accounting methods builder setups. |
14 | |
15 | HISTORY |
16 | 12/10/2003 Dimple Shah Created |
17 | |
18 +===========================================================================*/
19
20 -------------------------------------------------------------------------------
21 -- declaring types
22 -------------------------------------------------------------------------------
23 TYPE t_array_error IS TABLE OF xla_amb_setup_errors%rowtype
24 INDEX BY BINARY_INTEGER;
25
26 -------------------------------------------------------------------------------
27 -- public routines
28 -------------------------------------------------------------------------------
29
30 /*======================================================================+
31 | |
32 | Public Procedure |
33 | |
34 | Initialize |
35 | |
36 | This routine is called in the beginning of the program |
37 | to initialize the array |
38 | |
39 +======================================================================*/
40 PROCEDURE initialize
41 (p_request_id IN NUMBER DEFAULT NULL);
42
43 /*======================================================================+
44 | |
45 | Public Procedure |
46 | |
47 | Stack_Error |
48 | |
49 | This routine is called to stack the error into a plsql array |
50 | |
51 +======================================================================*/
52 PROCEDURE stack_error
53 (p_message_name IN VARCHAR2
54 ,p_message_type IN VARCHAR2
55 ,p_message_category IN VARCHAR2
56 ,p_category_sequence IN NUMBER
57 ,p_application_id IN NUMBER
58 ,p_amb_context_code IN VARCHAR2 DEFAULT NULL
59 ,p_product_rule_type_code IN VARCHAR2 DEFAULT NULL
60 ,p_product_rule_code IN VARCHAR2 DEFAULT NULL
61 ,p_entity_code IN VARCHAR2 DEFAULT NULL
62 ,p_event_class_code IN VARCHAR2 DEFAULT NULL
63 ,p_event_type_code IN VARCHAR2 DEFAULT NULL
64 ,p_line_definition_owner_code IN VARCHAR2 DEFAULT NULL
65 ,p_line_definition_code IN VARCHAR2 DEFAULT NULL
66 ,p_accounting_line_type_code IN VARCHAR2 DEFAULT NULL
67 ,p_accounting_line_code IN VARCHAR2 DEFAULT NULL
68 ,p_description_type_code IN VARCHAR2 DEFAULT NULL
69 ,p_description_code IN VARCHAR2 DEFAULT NULL
70 ,p_anal_criterion_type_code IN VARCHAR2 DEFAULT NULL
71 ,p_anal_criterion_code IN VARCHAR2 DEFAULT NULL
72 ,p_segment_rule_type_code IN VARCHAR2 DEFAULT NULL
73 ,p_segment_rule_code IN VARCHAR2 DEFAULT NULL
74 ,p_mapping_set_code IN VARCHAR2 DEFAULT NULL
75 ,p_source_application_id IN NUMBER DEFAULT NULL
76 ,p_source_type_code IN VARCHAR2 DEFAULT NULL
77 ,p_source_code IN VARCHAR2 DEFAULT NULL
78 ,p_extract_object_name IN VARCHAR2 DEFAULT NULL
79 ,p_extract_object_type IN VARCHAR2 DEFAULT NULL
80 ,p_accounting_source_code IN VARCHAR2 DEFAULT NULL
81 ,p_accounting_group_code IN VARCHAR2 DEFAULT NULL
82 ,p_extract_column_name IN VARCHAR2 DEFAULT NULL
83 ,p_language IN VARCHAR2 DEFAULT NULL
84 ,p_mpa_acct_line_type_code IN VARCHAR2 DEFAULT NULL
85 ,p_mpa_acct_line_code IN VARCHAR2 DEFAULT NULL );
86
87 /*======================================================================+
88 | |
89 | Public Procedure |
90 | |
91 | Insert_Errors |
92 | |
93 | This routine is called at the end of the program to insert all |
94 | errors from the plsql array into the error table |
95 | |
96 +======================================================================*/
97 PROCEDURE insert_errors;
98 END;