[Home] [Help]
PACKAGE: APPS.ENG_PROPAGATION_LOG_UTIL
Source
1 PACKAGE Eng_Propagation_Log_Util AUTHID CURRENT_USER AS
2 /* $Header: ENGVPRLS.pls 120.3 2005/12/12 02:21:00 lkasturi noship $ */
3
4 ---------------------------------------------------------------
5 -- Propagation Processing Status constants --
6 ---------------------------------------------------------------
7 G_PRP_PRC_STS_NOACTION CONSTANT NUMBER := 0;
8 G_PRP_PRC_STS_SUCCESS CONSTANT NUMBER := 1;
9 G_PRP_PRC_STS_ERROR CONSTANT NUMBER := 2;
10 G_PRP_PRC_STS_EXCLUDE CONSTANT NUMBER := 3;
11 G_PRP_PRC_STS_EXCL_TTM CONSTANT NUMBER := 4;
12 ---------------------------------------------------------------
13 -- Revised line type constants --
14 ---------------------------------------------------------------
15
16 G_REV_LINE_CMP_CHG CONSTANT VARCHAR2(20) := 'COMPONENT_CHANGE';
17 G_REV_LINE_ATCH_CHG CONSTANT VARCHAR2(20) := 'ATTACHMENT_CHANGE';
18 ---------------------------------------------------------------
19 -- Map entity name constants --
20 ---------------------------------------------------------------
21
22 G_ENTITY_CHANGE CONSTANT VARCHAR2(20) := 'ENG_CHANGE';
23 G_ENTITY_REVISED_ITEM CONSTANT VARCHAR2(20) := 'ENG_REVISED_ITEM';
24 G_ENTITY_REVISED_LINE CONSTANT VARCHAR2(20) := 'ENG_REVISED_LINE';
25
26 ---------------------------------------------------------------
27 -- Log Type constants --
28 ---------------------------------------------------------------
29 G_LOG_TYPE_INFO CONSTANT VARCHAR2(10) := 'INFO';
30 G_LOG_TYPE_WARNING CONSTANT VARCHAR2(10) := 'WARNING';
31 G_LOG_TYPE_ERROR CONSTANT VARCHAR2(10) := 'ERROR';
32
33 ---------------------------------------------------------------
34 -- Log constants --
35 ---------------------------------------------------------------
36 G_LOG_PRINT CONSTANT NUMBER := 6;
37
38 G_LOG_ERROR CONSTANT NUMBER := 5;
39 G_LOG_EXCEPTION CONSTANT NUMBER := 4;
40 G_LOG_EVENT CONSTANT NUMBER := 3;
41 G_LOG_PROCEDURE CONSTANT NUMBER := 2;
42 G_LOG_STATEMENT CONSTANT NUMBER := 1;
43
44 ---------------------------------------------------------------
45 -- Record and Table definition --
46 ---------------------------------------------------------------
47 TYPE Entity_Map_Log_Rec_Type IS RECORD (
48 change_propagation_map_id NUMBER
49 , change_id NUMBER
50 , revised_item_sequence_id NUMBER
51 , revised_line_type eng_change_propagation_maps.revised_line_type%TYPE
52 , revised_line_id1 eng_change_propagation_maps.revised_line_id1%TYPE
53 , revised_line_id2 eng_change_propagation_maps.revised_line_id2%TYPE
54 , revised_line_id3 eng_change_propagation_maps.revised_line_id3%TYPE
55 , revised_line_id4 eng_change_propagation_maps.revised_line_id4%TYPE
56 , revised_line_id5 eng_change_propagation_maps.revised_line_id5%TYPE
57 , local_organization_id NUMBER
58 , local_change_id NUMBER
59 , local_revised_item_seq_id NUMBER
60 , local_revised_line_id1 eng_change_propagation_maps.local_revised_line_id1%TYPE
61 , local_revised_line_id2 eng_change_propagation_maps.local_revised_line_id2%TYPE
62 , local_revised_line_id3 eng_change_propagation_maps.local_revised_line_id3%TYPE
63 , local_revised_line_id4 eng_change_propagation_maps.local_revised_line_id4%TYPE
64 , local_revised_line_id5 eng_change_propagation_maps.local_revised_line_id5%TYPE
65 , entity_name eng_change_propagation_maps.entity_name%TYPE
66 , entity_action_status NUMBER
67 , message_list Error_Handler.Error_Tbl_Type
68 );
69
70 TYPE Entity_Map_Log_Tbl_Type IS TABLE OF Entity_Map_Log_Rec_Type
71 INDEX BY BINARY_INTEGER;
72
73 ---------------------------------------------------------------
74 -- Exposed APIS begin here --
75 ---------------------------------------------------------------
76
77 PROCEDURE Write_Propagation_Log;
78
79 PROCEDURE Check_Entity_Map_Existance (
80 p_change_id IN NUMBER
81 , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
82 , p_revised_item_sequence_id IN NUMBER := NULL
83 , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
84 , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
85 , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
86 , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
87 , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
88 , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
89 , p_local_organization_id IN NUMBER
90 , x_change_map_id OUT NOCOPY NUMBER
91 );
92
93 PROCEDURE Add_Entity_Map (
94 p_change_id IN NUMBER
95 , p_revised_item_sequence_id IN NUMBER := NULL
96 , p_revised_line_type IN eng_change_propagation_maps.revised_line_type%TYPE := NULL
97 , p_revised_line_id1 IN eng_change_propagation_maps.revised_line_id1%TYPE := NULL
98 , p_revised_line_id2 IN eng_change_propagation_maps.revised_line_id2%TYPE := NULL
99 , p_revised_line_id3 IN eng_change_propagation_maps.revised_line_id3%TYPE := NULL
100 , p_revised_line_id4 IN eng_change_propagation_maps.revised_line_id4%TYPE := NULL
101 , p_revised_line_id5 IN eng_change_propagation_maps.revised_line_id5%TYPE := NULL
102 , p_local_organization_id IN NUMBER
103 , p_local_change_id IN NUMBER := NULL
104 , p_local_revised_item_seq_id IN NUMBER := NULL
105 , p_local_revised_line_id1 IN eng_change_propagation_maps.local_revised_line_id1%TYPE := NULL
106 , p_local_revised_line_id2 IN eng_change_propagation_maps.local_revised_line_id2%TYPE := NULL
107 , p_local_revised_line_id3 IN eng_change_propagation_maps.local_revised_line_id3%TYPE := NULL
108 , p_local_revised_line_id4 IN eng_change_propagation_maps.local_revised_line_id4%TYPE := NULL
109 , p_local_revised_line_id5 IN eng_change_propagation_maps.local_revised_line_id5%TYPE := NULL
110 , p_entity_name IN eng_change_propagation_maps.entity_name%TYPE
111 , p_entity_action_status IN NUMBER
112 , p_bo_entity_identifier IN VARCHAR2
113 );
114
115 PROCEDURE Initialize;
116
117 PROCEDURE Mark_Component_Change_Transfer (
118 p_api_version IN NUMBER
119 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
120 , p_commit IN VARCHAR2 := FND_API.G_FALSE
121 , x_return_status OUT NOCOPY VARCHAR2 --
122 , x_msg_count OUT NOCOPY NUMBER --
123 , x_msg_data OUT NOCOPY VARCHAR2 --
124 , p_change_id IN NUMBER
125 , p_revised_item_sequence_id IN NUMBER
126 , p_component_sequence_id IN NUMBER
127 , p_local_organization_id IN NUMBER
128 );
129
130 FUNCTION Get_Composite_Logs_For_Map (
131 p_change_propagation_map_id IN NUMBER
132 ) RETURN VARCHAR2;
133
134 PROCEDURE Debug_Log (
135 p_priority IN NUMBER
136 , p_msg IN VARCHAR2
137 );
138
139 -- bug 4704390
140 /******************************************************************************
141 * Procedure : Get_Propagate_Action_Flag
142 * Parameters : p_conc_request_phase_code IN VARCHAR2
143 * , p_entity_action_status IN NUMBER
144 * , p_global_change_id IN NUMBER
145 * , p_local_organization_id IN NUMBER
146 *
147 * Purpose : This function is used to fetch the propagate action flag to
148 * determine if propagation is to be allowed or not for a given
149 * header and a local organization.
150 *******************************************************************************/
151
152 FUNCTION Get_Propagate_Action_Flag (
153 p_conc_request_phase_code IN VARCHAR2
154 , p_entity_action_status IN NUMBER
155 , p_global_change_id IN NUMBER
156 , p_local_organization_id IN NUMBER
157 )RETURN VARCHAR2;
158
159 END ENG_PROPAGATION_LOG_UTIL;