[Home] [Help]
PACKAGE: APPS.ECO_ERROR_HANDLER
Source
1 PACKAGE Eco_Error_Handler AS
2 /* $Header: ENGBOEHS.pls 120.1 2005/07/04 00:42:06 lkasturi noship $ */
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'Error_Handler';
4 G_BO_LEVEL CONSTANT NUMBER := 0;
5 G_ECO_LEVEL CONSTANT NUMBER := 1;
6 G_REV_LEVEL CONSTANT NUMBER := 2;
7 G_RI_LEVEL CONSTANT NUMBER := 3;
8 G_RC_LEVEL CONSTANT NUMBER := 4;
9 G_RD_LEVEL CONSTANT NUMBER := 5;
10 G_SC_LEVEL CONSTANT NUMBER := 6;
11
12
13 /*******************************************************
14 -- Followings are for Routing BO
15 ********************************************************/
16 -- G_RTG_LEVEL CONSTANT NUMBER := 8;
17 G_OP_LEVEL CONSTANT NUMBER := 9;
18 G_RES_LEVEL CONSTANT NUMBER := 10;
19 G_SR_LEVEL CONSTANT NUMBER := 11;
20 -- G_NWK_LEVEL CONSTANT NUMBER := 12;
21 -- Added by MK on 08/23/2000
22
23 G_CL_LEVEL CONSTANT NUMBER := 21;
24 -- Added by MK on 08/13/2002
25
26 G_ATCH_LEVEL CONSTANT NUMBER := 22;
27
28 G_STATUS_WARNING CONSTANT VARCHAR2(1) := 'W';
29 G_STATUS_UNEXPECTED CONSTANT VARCHAR2(1) := 'U';
30 G_STATUS_ERROR CONSTANT VARCHAR2(1) := 'E';
31 G_STATUS_FATAL CONSTANT VARCHAR2(1) := 'F';
32 G_STATUS_NOT_PICKED CONSTANT VARCHAR2(1) := 'N';
33
34 G_SCOPE_ALL CONSTANT VARCHAR2(1) := 'A';
35 G_SCOPE_RECORD CONSTANT VARCHAR2(1) := 'R';
36 G_SCOPE_SIBLINGS CONSTANT VARCHAR2(1) := 'S';
37 G_SCOPE_CHILDREN CONSTANT VARCHAR2(1) := 'C';
38
39
40 /* Comment out by MK on 08/23/2000 ********************************************
41
42 PROCEDURE Log_Error
43 ( p_eco_rec IN ENG_Eco_Pub.Eco_Rec_Type :=
44 Eng_Eco_Pub.G_MISS_ECO_REC
45 , p_eco_revision_tbl IN Eng_Eco_Pub.Eco_Revision_tbl_Type
46 := Eng_Eco_Pub.G_MISS_ECO_REVISION_TBL
47 , p_revised_item_tbl IN Eng_Eco_Pub.Revised_Item_Tbl_Type
48 := Eng_Eco_Pub.G_MISS_REVISED_ITEM_TBL
49 , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type
50 := Eng_Eco_Pub.G_MISS_REV_COMPONENT_TBL
51 , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type
52 := Eng_Eco_Pub.G_MISS_REF_DESIGNATOR_TBL
53 , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type
54 := Eng_Eco_Pub.G_MISS_SUB_COMPONENT_TBL
55 , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
56 := Error_Handler.G_MISS_MESG_TOKEN_TBL
57 , p_error_status IN VARCHAR2
58 , p_error_scope IN VARCHAR2 := NULL
59 , p_other_message IN VARCHAR2 := NULL
60 , p_other_status IN VARCHAR2 := NULL
61 , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
62 := Error_Handler.G_MISS_TOKEN_TBL
63 , p_error_level IN NUMBER
64 , p_entity_index IN NUMBER := NULL
65 , x_eco_rec OUT NOCOPY ENG_Eco_Pub.Eco_Rec_Type
66 , x_eco_revision_tbl OUT NOCOPY Eng_Eco_Pub.Eco_Revision_tbl_Type
67 , x_revised_item_tbl OUT NOCOPY Eng_Eco_Pub.Revised_Item_Tbl_Type
68 , x_rev_component_tbl OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
69 , x_ref_designator_tbl OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
70 , x_sub_component_tbl OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
71 );
72 *******************************************************************************/
73
74
75
76 /*******************************************************
77 -- Log_Error prodedure used for ECO Routing enhancement
78 --
79 -- Added rev op, rev op res and rev sub res error handling
80 -- to existed Log_Error procedure
81 --
82 -- Modified by MK on 08/23/2000
83 ********************************************************/
84 PROCEDURE Log_Error
85 ( p_eco_rec IN ENG_Eco_Pub.Eco_Rec_Type :=
86 Eng_Eco_Pub.G_MISS_ECO_REC
87 , p_eco_revision_tbl IN Eng_Eco_Pub.Eco_Revision_tbl_Type
88 := Eng_Eco_Pub.G_MISS_ECO_REVISION_TBL
89 , p_revised_item_tbl IN Eng_Eco_Pub.Revised_Item_Tbl_Type
90 := Eng_Eco_Pub.G_MISS_REVISED_ITEM_TBL
91
92 -- Followings are for Routing BO
93 , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
94 := Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
95 , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
96 := Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL
97 , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
98 := Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL
99 -- Added by MK on 08/23/2000
100
101 , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type
102 := Eng_Eco_Pub.G_MISS_REV_COMPONENT_TBL
103 , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type
104 := Eng_Eco_Pub.G_MISS_REF_DESIGNATOR_TBL
105 , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type
106 := Eng_Eco_Pub.G_MISS_SUB_COMPONENT_TBL
107 , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
108 := Error_Handler.G_MISS_MESG_TOKEN_TBL
109 , p_error_status IN VARCHAR2
110 , p_error_scope IN VARCHAR2 := NULL
111 , p_other_message IN VARCHAR2 := NULL
112 , p_other_status IN VARCHAR2 := NULL
113 , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
114 := Error_Handler.G_MISS_TOKEN_TBL
115 , p_error_level IN NUMBER
116 , p_entity_index IN NUMBER := 1 -- := NULL
117 , x_eco_rec IN OUT NOCOPY ENG_Eco_Pub.Eco_Rec_Type
118 , x_eco_revision_tbl IN OUT NOCOPY Eng_Eco_Pub.Eco_Revision_tbl_Type
119 , x_revised_item_tbl IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Tbl_Type
120 , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
121 , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
122 , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
123
124 -- Followings are for Routing BO
125 , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
126 , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
127 , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
128 -- Added by MK on 08/23/2000
129
130 );
131
132 /*******************************************************
133 -- Log_Error prodedure used for Eng Change Managmet
134 -- enhancement
135 --
136 -- Added people and change Line error handling
137 -- to existed Log_Error procedure
138 --
139 -- Added by MK on 08/13/2002
140 ********************************************************/
141 PROCEDURE Log_Error
142 ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
143 := Eng_Eco_Pub.G_MISS_ECO_REC
144 , p_eco_revision_tbl IN Eng_Eco_Pub.Eco_Revision_tbl_Type
145 := Eng_Eco_Pub.G_MISS_ECO_REVISION_TBL
146 , p_change_line_tbl IN Eng_Eco_Pub.Change_Line_Tbl_Type -- Eng Change
147 := Eng_Eco_Pub.G_MISS_CHANGE_LINE_TBL
148 , p_revised_item_tbl IN Eng_Eco_Pub.Revised_Item_Tbl_Type
149 := Eng_Eco_Pub.G_MISS_REVISED_ITEM_TBL
150 , p_rev_operation_tbl IN Bom_Rtg_Pub.Rev_Operation_Tbl_Type
151 := Bom_Rtg_Pub.G_MISS_REV_OPERATION_TBL
152 , p_rev_op_resource_tbl IN Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
153 := Bom_Rtg_Pub.G_MISS_REV_OP_RESOURCE_TBL
154 , p_rev_sub_resource_tbl IN Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
155 := Bom_Rtg_Pub.G_MISS_REV_SUB_RESOURCE_TBL
156 , p_rev_component_tbl IN Bom_Bo_Pub.Rev_Component_Tbl_Type
157 := Eng_Eco_Pub.G_MISS_REV_COMPONENT_TBL
158 , p_ref_designator_tbl IN Bom_Bo_Pub.Ref_Designator_Tbl_Type
159 := Eng_Eco_Pub.G_MISS_REF_DESIGNATOR_TBL
160 , p_sub_component_tbl IN Bom_Bo_Pub.Sub_Component_Tbl_Type
161 := Eng_Eco_Pub.G_MISS_SUB_COMPONENT_TBL
162 , p_Mesg_Token_tbl IN Error_Handler.Mesg_Token_Tbl_Type
163 := Error_Handler.G_MISS_MESG_TOKEN_TBL
164 , p_error_status IN VARCHAR2
165 , p_error_scope IN VARCHAR2 := NULL
166 , p_other_message IN VARCHAR2 := NULL
167 , p_other_status IN VARCHAR2 := NULL
168 , p_other_token_tbl IN Error_Handler.Token_Tbl_Type
169 := Error_Handler.G_MISS_TOKEN_TBL
170 , p_error_level IN NUMBER
171 , p_entity_index IN NUMBER := 1 -- := NULL
172 , x_eco_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rec_Type
173 , x_eco_revision_tbl IN OUT NOCOPY Eng_Eco_Pub.Eco_Revision_tbl_Type
174 , x_change_line_tbl IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Tbl_Type -- Eng Change
175 , x_revised_item_tbl IN OUT NOCOPY Eng_Eco_Pub.Revised_Item_Tbl_Type
176 , x_rev_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Rev_Component_Tbl_Type
177 , x_ref_designator_tbl IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Tbl_Type
178 , x_sub_component_tbl IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Tbl_Type
179 , x_rev_operation_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Tbl_Type
180 , x_rev_op_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Tbl_Type
181 , x_rev_sub_resource_tbl IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Tbl_Type
182 );
183
184
185
186 END Eco_Error_Handler;