[Home] [Help]
PACKAGE: APPS.ONT_MGD_EURO_REPORT_GEN
Source
1 PACKAGE ONT_MGD_EURO_REPORT_GEN AUTHID CURRENT_USER AS
2 /* $Header: ONTREURS.pls 120.0 2005/06/01 00:53:09 appldev noship $ */
3
4 ---+=======================================================================+
5 --| Copyright (c) 2000 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| ONTREURS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Use this package to generate output report for Euro conversion |
14 --| |
15 --| HISTORY |
16 --|
17 --| 12-dec-2001 BUG 2138996
18 --| |
19 --+======================================================================
20
21
22 --===================
23 -- CONSTANTS
24 --===================
25
26 G_OBJECT_TYPE_CUSTOMER CONSTANT VARCHAR2(100) :=
27 FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CUSTOMER');
28
29 G_OBJECT_TYPE_CSITE CONSTANT VARCHAR2(100) :=
30 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_CSITE'),' ');
31
32 G_OBJECT_TYPE_PRICE_LIST CONSTANT VARCHAR2(100) :=
33 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_PRICELIST'),' ');
34
35 G_OBJECT_TYPE_MODIFIER CONSTANT VARCHAR2(100) :=
36 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_MODIFIER'),' ');
37
38 G_OBJECT_TYPE_SO CONSTANT VARCHAR2(100) :=
39 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_SO'),' ');
40
41 G_OBJECT_TYPE_FORMULA CONSTANT VARCHAR2(100) :=
42 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_OBJECT_FORMULA'),' ');
43
44 --------------------------
45 ------- Action Codes
46 --------------------------
47 G_ACTION_CONV CONSTANT VARCHAR2(100) :=
48 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_CONV'),' ');
49
50 G_ACTION_IGNORE CONSTANT VARCHAR2(100) :=
51 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_IGNORE'),' ');
52
53 G_ACTION_COPY CONSTANT VARCHAR2(100) :=
54 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_COPY'),' ');
55
56 G_ACTION_INCOMPLETE CONSTANT VARCHAR2(100) :=
57 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_ACTION_INCOMP'),' ');
58
59
60 --------------------------
61 --- Reason codes---------
62 -------------------------
63
64 G_REASON_EURO CONSTANT VARCHAR2(100) :=
65 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_EURO'),' ');
66
67 G_REASON_CL_SHORT CONSTANT VARCHAR2(100) :=
68 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CL_SHORT'),' ');
69
70 G_REASON_PARTIAL CONSTANT VARCHAR2(100) :=
71 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PARTIAL'),' ');
72
73
74 G_REASON_PROJECT CONSTANT VARCHAR2(100) :=
75 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROJECT'),' ');
76
77 G_REASON_NOTHING CONSTANT VARCHAR2(100) :=
78 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOTHING'),' ');
79
80
81 G_REASON_RATE CONSTANT VARCHAR2(100) :=
82 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RATE'),' ');
83
84 G_REASON_RMA CONSTANT VARCHAR2(100) :=
85 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RMA'),' ');
86
87 G_REASON_USER CONSTANT VARCHAR2(100) :=
88 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_USER'),' ');
89
90 G_REASON_VALIDATION CONSTANT VARCHAR2(100) :=
91 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_VAL'),' ');
92
93 G_REASON_PROCESS CONSTANT VARCHAR2(100) :=
94 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PROCESS'),' ');
95
96 G_REASON_CANCEL CONSTANT VARCHAR2(100) :=
97 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_CANCEL'),' ');
98
99 G_REASON_COPY CONSTANT VARCHAR2(100) :=
100 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_COPY'),' ');
101
102 G_REASON_GET_FAILED CONSTANT VARCHAR2(100) :=
103 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_GET'),' ');
104
105 G_REASON_NOT_ELIGIBLE CONSTANT VARCHAR2(100) :=
106 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NOT_ELG'),' ');
107
108 G_REASON_QUALIFIER CONSTANT VARCHAR2(100) :=
109 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_QUALIFIER'),' ');
110
111 G_REASON_FORMULA CONSTANT VARCHAR2(100) :=
112 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_FORMULA'),' ');
113
114 G_REASON_RLTD CONSTANT VARCHAR2(100) :=
115 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_RLTD'),' ');
116
117 G_REASON_HOLD CONSTANT VARCHAR2(100) :=
118 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_HOLD'),' ');
119
120 G_REASON_PR CONSTANT VARCHAR2(100) :=
121 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_PR'),' ');
122
123 G_REASON_NSTD CONSTANT VARCHAR2(100) :=
124 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_NSTD'),' ');
125
126 G_REASON_SITE CONSTANT VARCHAR2(100) :=
127 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SITE'),' ');
128
129 G_REASON_SHIP CONSTANT VARCHAR2(100) :=
130 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_SHIP'),' ');
131
132 G_REASON_MIXED CONSTANT VARCHAR2(100) :=
133 NVL(FND_MESSAGE.get_string('ONT','OE_EUR_REPORT_REASON_MIXED'),' ');
134
135
136 G_RPT_PAGE_COL CONSTANT INTEGER :=130;
137 G_FORMAT_SPACE CONSTANT INTEGER :=2;
138 --
139 G_LOG_ERROR CONSTANT NUMBER := 1;
140 G_LOG_EXCEPTION CONSTANT NUMBER := 2;
141 G_LOG_EVENT CONSTANT NUMBER := 3;
142 G_LOG_PROCEDURE CONSTANT NUMBER := 4;
143 G_LOG_STATEMENT CONSTANT NUMBER := 5;
144
145 --===================
146 -- PROCEDURE : Initialize PUBLIC
147 -- PARAMETERS: p_program_type customer or vendor program
148 -- COMMENT : This is the procedure to initialize pls/sql tables
149 -- for recording action information.
150 --===================
151 PROCEDURE Initialize ;
152
153
154 --========================================================================
155 -- PROCEDURE : Log PUBLIC
156 -- PARAMETERS: p_level IN priority of the message -
157 -- from highest to lowest:
158 -- G_LOG_ERROR
159 -- G_LOG_EXCEPTION
160 -- G_LOG_EVENT
161 -- G_LOG_PROCEDURE
162 -- G_LOG_STATEMENT
163 -- p_msg IN message to be print on the log file
164 -- COMMENT : Add an entry to the log
165 --=======================================================================--
166 PROCEDURE Log
167 ( p_priority IN NUMBER := 10
168 , p_msg IN VARCHAR2
169 );
170
171
172 --===================
173 -- PROCEDURE : Add_Item PUBLIC
174 -- PARAMETERS: p_object_type converted object
175 -- p_action_code convert,ignore,copy
176 -- p_object_ref name of the converted object
177 -- p_copy_object_ref name of the new object after convertion
178 -- p_reason_code why object wasn't converted
179 -- COMMENT : This is the procedure to record action information.
180 --====================
181 PROCEDURE Add_Item
182 ( p_object_type IN VARCHAR2
183 , p_action_code IN VARCHAR2
184 , p_object_ref IN VARCHAR2
185 , p_copy_object_ref IN VARCHAR2 DEFAULT NULL
186 , p_reason_code IN VARCHAR2 DEFAULT NULL
187 );
188
189 --====================
190 -- PROCEDURE : Generate_Report PUBLIC
191 -- PARAMETERS: p_customer_num customer number
192 -- p_customer_address_id customer site address
193 -- p_convert_so_flag Y/N convert SOs?
194 -- p_so_conversion_ncu SO initial currency
195 -- p_convert_partial_so Y/N convert SO with partial shipment
196 -- p_line_invoice_to_org_id Line level Bill to site
197 -- p_so_reprice_flag Reiprice flag
198
199 -- COMMENT : This is the procedure to print action information.
200 --====================
201 PROCEDURE Generate_Report
202 ( p_customer_num IN VARCHAR2
203 , p_customer_name IN VARCHAR2
204 , p_customer_id IN NUMBER
205 , p_customer_address_id IN NUMBER
206 , p_so_conversion_ncu IN VARCHAR2
207 , p_convert_so_flag IN VARCHAR2
208 , p_convert_partial_so IN VARCHAR2
209 , p_line_invoice_to_org_id IN NUMBER
210 , p_so_reprice_flag IN VARCHAR2
211 );
212
213
214
215 END ONT_MGD_EURO_REPORT_GEN ;