[Home] [Help]
PACKAGE BODY: APPS.ARP_PROCESS_FREIGHT_COVER
Source
1 PACKAGE BODY ARP_PROCESS_FREIGHT_COVER AS
2 /* $Header: ARTEFR2B.pls 115.4 2003/10/10 14:28:18 mraymond ship $ */
3
4 pg_number_dummy number;
5 pg_date_dummy date;
6
7 /*===========================================================================+
8 | PROCEDURE |
9 | insert_freight_cover |
10 | |
11 | DESCRIPTION |
12 | Cover for the freight entity handler procedure insert_freight |
13 | |
14 | SCOPE - PRIVATE |
15 | |
16 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
17 | arp_util.debug |
18 | arp_process_freight.insert_freight |
19 | |
20 | ARGUMENTS : IN: |
21 | p_form_name |
22 | p_form_version |
23 | p_customer_trx_id |
24 | p_line_type |
25 | p_line_number |
26 | p_extended_amount |
27 | p_revenue_amount |
28 | p_previous_customer_trx_id |
29 | p_previous_cust_trx_line_id |
30 | p_link_to_cust_trx_line_id |
31 | p_attribute_category |
32 | p_attribute1-15 |
33 | p_interface_line_context |
34 | p_interface_line_attribute1-15 |
35 | p_trx_class |
36 | p_gl_date |
37 | p_frt_ccid |
38 | OUT: |
39 | p_customer_trx_line_id |
40 | IN/ OUT: |
41 | |
42 | RETURNS : NONE |
43 | |
44 | NOTES |
45 | |
46 | MODIFICATION HISTORY |
47 | 12-JUL-95 Subash Chadalavada Created |
48 | |
49 +===========================================================================*/
50
51 PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
52
53 PROCEDURE insert_freight_cover(
54 p_form_name IN varchar2,
55 p_form_version IN number,
56 p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
57 p_line_type IN ra_customer_trx_lines.line_type%type,
58 p_line_number IN ra_customer_trx_lines.line_number%type,
59 p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
60 p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
61 p_previous_customer_trx_id IN
62 ra_customer_trx_lines.previous_customer_trx_id%type,
63 p_previous_cust_trx_line_id IN
64 ra_customer_trx_lines.previous_customer_trx_line_id%type,
65 p_link_to_cust_trx_line_id IN
66 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
67 p_attribute_category IN
68 ra_customer_trx_lines.attribute_category%type,
69 p_attribute1 IN ra_customer_trx_lines.attribute1%type,
70 p_attribute2 IN ra_customer_trx_lines.attribute2%type,
71 p_attribute3 IN ra_customer_trx_lines.attribute3%type,
72 p_attribute4 IN ra_customer_trx_lines.attribute4%type,
73 p_attribute5 IN ra_customer_trx_lines.attribute5%type,
74 p_attribute6 IN ra_customer_trx_lines.attribute6%type,
75 p_attribute7 IN ra_customer_trx_lines.attribute7%type,
76 p_attribute8 IN ra_customer_trx_lines.attribute8%type,
77 p_attribute9 IN ra_customer_trx_lines.attribute9%type,
78 p_attribute10 IN ra_customer_trx_lines.attribute10%type,
79 p_attribute11 IN ra_customer_trx_lines.attribute11%type,
80 p_attribute12 IN ra_customer_trx_lines.attribute12%type,
81 p_attribute13 IN ra_customer_trx_lines.attribute13%type,
82 p_attribute14 IN ra_customer_trx_lines.attribute14%type,
83 p_attribute15 IN ra_customer_trx_lines.attribute15%type,
84 p_interface_line_context IN
85 ra_customer_trx_lines.interface_line_context%type,
86 p_interface_line_attribute1 IN
87 ra_customer_trx_lines.interface_line_attribute1%type,
88 p_interface_line_attribute2 IN
89 ra_customer_trx_lines.interface_line_attribute2%type,
90 p_interface_line_attribute3 IN
91 ra_customer_trx_lines.interface_line_attribute3%type,
92 p_interface_line_attribute4 IN
93 ra_customer_trx_lines.interface_line_attribute4%type,
94 p_interface_line_attribute5 IN
95 ra_customer_trx_lines.interface_line_attribute5%type,
96 p_interface_line_attribute6 IN
97 ra_customer_trx_lines.interface_line_attribute6%type,
98 p_interface_line_attribute7 IN
99 ra_customer_trx_lines.interface_line_attribute7%type,
100 p_interface_line_attribute8 IN
101 ra_customer_trx_lines.interface_line_attribute8%type,
102 p_interface_line_attribute9 IN
103 ra_customer_trx_lines.interface_line_attribute9%type,
104 p_interface_line_attribute10 IN
105 ra_customer_trx_lines.interface_line_attribute10%type,
106 p_interface_line_attribute11 IN
107 ra_customer_trx_lines.interface_line_attribute11%type,
108 p_interface_line_attribute12 IN
109 ra_customer_trx_lines.interface_line_attribute12%type,
110 p_interface_line_attribute13 IN
111 ra_customer_trx_lines.interface_line_attribute13%type,
112 p_interface_line_attribute14 IN
113 ra_customer_trx_lines.interface_line_attribute14%type,
114 p_interface_line_attribute15 IN
115 ra_customer_trx_lines.interface_line_attribute15%type,
116 p_default_ussgl_code_context IN
117 ra_customer_trx_lines.default_ussgl_trx_code_context%type,
118 p_default_ussgl_trx_code IN
119 ra_customer_trx_lines.default_ussgl_transaction_code%type,
120 p_trx_class IN ra_cust_trx_types.type%type,
121 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
122 p_frt_ccid IN
123 ra_cust_trx_line_gl_dist.code_combination_id%type,
124 p_customer_trx_line_id OUT NOCOPY
125 ra_customer_trx_lines.customer_trx_line_id%type,
126 p_status OUT NOCOPY varchar2)
127 IS
128
129 l_frt_rec ra_customer_trx_lines%rowtype;
130 l_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%type;
131
132 BEGIN
133
134 IF PG_DEBUG in ('Y', 'C') THEN
135 arp_util.debug('arp_process_freight.insert_freight_cover()+');
136 END IF;
137
138 l_frt_rec.customer_trx_id := p_customer_trx_id;
139 l_frt_rec.line_type := p_line_type;
140 l_frt_rec.line_number := p_line_number;
141 l_frt_rec.extended_amount := p_extended_amount;
142 l_frt_rec.revenue_amount := p_revenue_amount;
143 l_frt_rec.previous_customer_trx_id := p_previous_customer_trx_id;
144 l_frt_rec.previous_customer_trx_line_id := p_previous_cust_trx_line_id;
145 l_frt_rec.link_to_cust_trx_line_id := p_link_to_cust_trx_line_id;
146 l_frt_rec.attribute_category := p_attribute_category;
147 l_frt_rec.attribute1 := p_attribute1;
148 l_frt_rec.attribute2 := p_attribute2;
149 l_frt_rec.attribute3 := p_attribute3;
150 l_frt_rec.attribute4 := p_attribute4;
151 l_frt_rec.attribute5 := p_attribute5;
152 l_frt_rec.attribute6 := p_attribute6;
153 l_frt_rec.attribute7 := p_attribute7;
154 l_frt_rec.attribute8 := p_attribute8;
155 l_frt_rec.attribute9 := p_attribute9;
156 l_frt_rec.attribute10 := p_attribute10;
157 l_frt_rec.attribute11 := p_attribute11;
158 l_frt_rec.attribute12 := p_attribute12;
159 l_frt_rec.attribute13 := p_attribute13;
160 l_frt_rec.attribute14 := p_attribute14;
161 l_frt_rec.attribute15 := p_attribute15;
162
163 l_frt_rec.interface_line_context := p_interface_line_context;
164 l_frt_rec.interface_line_attribute1 := p_interface_line_attribute1;
165 l_frt_rec.interface_line_attribute2 := p_interface_line_attribute2;
166 l_frt_rec.interface_line_attribute3 := p_interface_line_attribute3;
167 l_frt_rec.interface_line_attribute4 := p_interface_line_attribute4;
168 l_frt_rec.interface_line_attribute5 := p_interface_line_attribute5;
169 l_frt_rec.interface_line_attribute6 := p_interface_line_attribute6;
170 l_frt_rec.interface_line_attribute7 := p_interface_line_attribute7;
171 l_frt_rec.interface_line_attribute8 := p_interface_line_attribute8;
172 l_frt_rec.interface_line_attribute9 := p_interface_line_attribute9;
173 l_frt_rec.interface_line_attribute10 := p_interface_line_attribute10;
174 l_frt_rec.interface_line_attribute11 := p_interface_line_attribute11;
175 l_frt_rec.interface_line_attribute12 := p_interface_line_attribute12;
176 l_frt_rec.interface_line_attribute13 := p_interface_line_attribute13;
177 l_frt_rec.interface_line_attribute14 := p_interface_line_attribute14;
178 l_frt_rec.interface_line_attribute15 := p_interface_line_attribute15;
179
180 l_frt_rec.default_ussgl_trx_code_context := p_default_ussgl_code_context;
181 l_frt_rec.default_ussgl_transaction_code := p_default_ussgl_trx_code;
182
183 arp_process_freight.insert_freight(
184 p_form_name,
185 p_form_version,
186 l_frt_rec,
187 p_trx_class,
188 p_gl_date,
189 p_frt_ccid,
190 l_customer_trx_line_id,
191 p_status);
192
193 p_customer_trx_line_id := l_customer_trx_line_id;
194
195 IF PG_DEBUG in ('Y', 'C') THEN
196 arp_util.debug('arp_process_freight.insert_freight_cover()-');
197 END IF;
198
199 EXCEPTION
200
201 WHEN OTHERS THEN
202 IF PG_DEBUG in ('Y', 'C') THEN
203 arp_util.debug('EXCEPTION : arp_process_freight.insert_freight_cover');
204 arp_util.debug('insert_freight_cover: ' || 'p_form_name : '||p_form_name);
205 arp_util.debug('insert_freight_cover: ' || 'p_form_version : '||p_form_version);
206 arp_util.debug('insert_freight_cover: ' || 'p_customer_trx_id : '||p_customer_trx_id);
207 arp_util.debug('insert_freight_cover: ' || 'p_line_type : '||p_line_type);
208 arp_util.debug('insert_freight_cover: ' || 'p_line_number : '||p_line_number);
209 arp_util.debug('insert_freight_cover: ' || 'p_extended_amount : '||p_extended_amount);
210 arp_util.debug('insert_freight_cover: ' || 'p_revenue_amount : '||p_revenue_amount);
211 arp_util.debug('insert_freight_cover: ' || 'p_previous_customer_trx_id : '||p_previous_customer_trx_id);
212 arp_util.debug('insert_freight_cover: ' || 'p_previous_cust_trx_line_id : '||p_previous_cust_trx_line_id);
213 arp_util.debug('insert_freight_cover: ' || 'p_link_to_cust_trx_line_id : '||p_link_to_cust_trx_line_id);
214 arp_util.debug('insert_freight_cover: ' || 'p_attribute_category : '||p_attribute_category);
215 arp_util.debug('insert_freight_cover: ' || 'p_attribute1 : '||p_attribute1);
216 arp_util.debug('insert_freight_cover: ' || 'p_attribute2 : '||p_attribute2);
217 arp_util.debug('insert_freight_cover: ' || 'p_attribute3 : '||p_attribute3);
218 arp_util.debug('insert_freight_cover: ' || 'p_attribute4 : '||p_attribute4);
219 arp_util.debug('insert_freight_cover: ' || 'p_attribute5 : '||p_attribute5);
220 arp_util.debug('insert_freight_cover: ' || 'p_attribute6 : '||p_attribute6);
221 arp_util.debug('insert_freight_cover: ' || 'p_attribute7 : '||p_attribute7);
222 arp_util.debug('insert_freight_cover: ' || 'p_attribute8 : '||p_attribute8);
223 arp_util.debug('insert_freight_cover: ' || 'p_attribute9 : '||p_attribute9);
224 arp_util.debug('insert_freight_cover: ' || 'p_attribute10 : '||p_attribute10);
225 arp_util.debug('insert_freight_cover: ' || 'p_attribute11 : '||p_attribute11);
226 arp_util.debug('insert_freight_cover: ' || 'p_attribute12 : '||p_attribute12);
227 arp_util.debug('insert_freight_cover: ' || 'p_attribute13 : '||p_attribute13);
228 arp_util.debug('insert_freight_cover: ' || 'p_attribute14 : '||p_attribute14);
229 arp_util.debug('insert_freight_cover: ' || 'p_attribute15 : '||p_attribute15);
230 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_context : '||p_interface_line_context);
231 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute1 : '||p_interface_line_attribute1);
232 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute2 : '||p_interface_line_attribute2);
233 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute3 : '||p_interface_line_attribute3);
234 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute4 : '||p_interface_line_attribute4);
235 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute5 : '||p_interface_line_attribute5);
236 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute6 : '||p_interface_line_attribute6);
237 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute7 : '||p_interface_line_attribute7);
238 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute8 : '||p_interface_line_attribute8);
239 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute9 : '||p_interface_line_attribute9);
240 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute10 : '||p_interface_line_attribute10);
241 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute11 : '||p_interface_line_attribute11);
242 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute12 : '||p_interface_line_attribute12);
243 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute13 : '||p_interface_line_attribute13);
244 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute14 : '||p_interface_line_attribute14);
245 arp_util.debug('insert_freight_cover: ' || 'p_interface_line_attribute15 : '||p_interface_line_attribute15);
246 arp_util.debug('insert_freight_cover: ' || 'p_default_ussgl_code_context : '||p_default_ussgl_code_context);
247 arp_util.debug('insert_freight_cover: ' || 'p_default_ussgl_trx_code : '||p_default_ussgl_trx_code);
248 arp_util.debug('insert_freight_cover: ' || 'p_trx_class : '||p_trx_class);
249 arp_util.debug('insert_freight_cover: ' || 'p_gl_date : '||p_gl_date);
250 arp_util.debug('insert_freight_cover: ' || 'p_frt_ccid : '||p_frt_ccid);
251 END IF;
252
253 RAISE;
254
255 END insert_freight_cover;
256
257 /*===========================================================================+
258 | PROCEDURE |
259 | update_freight_cover |
260 | |
261 | DESCRIPTION |
262 | Cover for the freight entity handler procedure update_freight |
263 | |
264 | SCOPE - PRIVATE |
265 | |
266 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
267 | arp_util.debug |
268 | arp_process_freight.update_freight |
269 | |
270 | ARGUMENTS : IN: |
271 | p_form_name |
272 | p_form_version |
273 | p_customer_trx_id |
274 | p_customer_trx_line_id |
275 | p_line_type |
276 | p_line_number |
277 | p_extended_amount |
278 | p_revenue_amount |
279 | p_previous_customer_trx_id |
280 | p_previous_cust_trx_line_id |
281 | p_link_to_cust_trx_line_id |
282 | p_attribute_category |
283 | p_attribute1 - 15 |
284 | p_interface_line_context |
285 | p_interface_line_attribute1 - 15 |
286 | p_default_ussgl_code_context |
287 | p_default_ussgl_trx_code |
288 | p_trx_class |
289 | p_gl_date |
290 | p_frt_ccid |
291 | p_complete_flag |
292 | p_gl_date |
293 | p_open_rec_flag |
294 | OUT: |
295 | IN/ OUT: |
296 | |
297 | RETURNS : NONE |
298 | |
299 | NOTES |
300 | |
301 | MODIFICATION HISTORY |
302 | 12-JUL-95 Subash Chadalavada Created |
303 | |
304 +===========================================================================*/
305
306 PROCEDURE update_freight_cover(
307 p_form_name IN varchar2,
308 p_form_version IN number,
309 p_customer_trx_id IN ra_customer_trx_lines.customer_trx_id%type,
310 p_customer_trx_line_id IN
311 ra_customer_trx_lines.customer_trx_line_id%type,
312 p_line_type IN ra_customer_trx_lines.line_type%type,
313 p_line_number IN ra_customer_trx_lines.line_number%type,
314 p_extended_amount IN ra_customer_trx_lines.extended_amount%type,
315 p_revenue_amount IN ra_customer_trx_lines.revenue_amount%type,
316 p_previous_customer_trx_id IN
317 ra_customer_trx_lines.previous_customer_trx_id%type,
318 p_previous_cust_trx_line_id IN
319 ra_customer_trx_lines.previous_customer_trx_line_id%type,
320 p_link_to_cust_trx_line_id IN
321 ra_customer_trx_lines.link_to_cust_trx_line_id%type,
322 p_attribute_category IN
323 ra_customer_trx_lines.attribute_category%type,
324 p_attribute1 IN ra_customer_trx_lines.attribute1%type,
325 p_attribute2 IN ra_customer_trx_lines.attribute2%type,
326 p_attribute3 IN ra_customer_trx_lines.attribute3%type,
327 p_attribute4 IN ra_customer_trx_lines.attribute4%type,
328 p_attribute5 IN ra_customer_trx_lines.attribute5%type,
329 p_attribute6 IN ra_customer_trx_lines.attribute6%type,
330 p_attribute7 IN ra_customer_trx_lines.attribute7%type,
331 p_attribute8 IN ra_customer_trx_lines.attribute8%type,
332 p_attribute9 IN ra_customer_trx_lines.attribute9%type,
333 p_attribute10 IN ra_customer_trx_lines.attribute10%type,
334 p_attribute11 IN ra_customer_trx_lines.attribute11%type,
335 p_attribute12 IN ra_customer_trx_lines.attribute12%type,
336 p_attribute13 IN ra_customer_trx_lines.attribute13%type,
337 p_attribute14 IN ra_customer_trx_lines.attribute14%type,
338 p_attribute15 IN ra_customer_trx_lines.attribute15%type,
339 p_interface_line_context IN
340 ra_customer_trx_lines.interface_line_context%type,
341 p_interface_line_attribute1 IN
342 ra_customer_trx_lines.interface_line_attribute1%type,
343 p_interface_line_attribute2 IN
344 ra_customer_trx_lines.interface_line_attribute2%type,
345 p_interface_line_attribute3 IN
346 ra_customer_trx_lines.interface_line_attribute3%type,
347 p_interface_line_attribute4 IN
348 ra_customer_trx_lines.interface_line_attribute4%type,
349 p_interface_line_attribute5 IN
350 ra_customer_trx_lines.interface_line_attribute5%type,
351 p_interface_line_attribute6 IN
352 ra_customer_trx_lines.interface_line_attribute6%type,
353 p_interface_line_attribute7 IN
354 ra_customer_trx_lines.interface_line_attribute7%type,
355 p_interface_line_attribute8 IN
356 ra_customer_trx_lines.interface_line_attribute8%type,
357 p_interface_line_attribute9 IN
358 ra_customer_trx_lines.interface_line_attribute9%type,
359 p_interface_line_attribute10 IN
360 ra_customer_trx_lines.interface_line_attribute10%type,
361 p_interface_line_attribute11 IN
362 ra_customer_trx_lines.interface_line_attribute11%type,
363 p_interface_line_attribute12 IN
364 ra_customer_trx_lines.interface_line_attribute12%type,
365 p_interface_line_attribute13 IN
366 ra_customer_trx_lines.interface_line_attribute13%type,
367 p_interface_line_attribute14 IN
368 ra_customer_trx_lines.interface_line_attribute14%type,
369 p_interface_line_attribute15 IN
370 ra_customer_trx_lines.interface_line_attribute15%type,
371 p_default_ussgl_code_context IN
372 ra_customer_trx_lines.default_ussgl_trx_code_context%type,
373 p_default_ussgl_trx_code IN
374 ra_customer_trx_lines.default_ussgl_transaction_code%type,
375 p_trx_class IN ra_cust_trx_types.type%type,
376 p_gl_date IN ra_cust_trx_line_gl_dist.gl_date%type,
377 p_frt_ccid IN
378 ra_cust_trx_line_gl_dist.code_combination_id%type,
379 p_complete_flag IN varchar2,
380 p_open_rec_flag IN varchar2,
381 p_status OUT NOCOPY varchar2)
382 IS
383
384 l_frt_rec ra_customer_trx_lines%rowtype;
385
386 BEGIN
387
388 IF PG_DEBUG in ('Y', 'C') THEN
389 arp_util.debug('arp_process_freight.update_freight_cover()+');
390 END IF;
391
392 arp_ctl_pkg.set_to_dummy(l_frt_rec);
393
394 l_frt_rec.customer_trx_id := p_customer_trx_id;
395 l_frt_rec.customer_trx_line_id := p_customer_trx_line_id;
396 l_frt_rec.line_type := p_line_type;
397 l_frt_rec.line_number := p_line_number;
398 l_frt_rec.extended_amount := p_extended_amount;
399 l_frt_rec.revenue_amount := p_revenue_amount;
400 l_frt_rec.previous_customer_trx_id := p_previous_customer_trx_id;
401 l_frt_rec.previous_customer_trx_line_id := p_previous_cust_trx_line_id;
402 l_frt_rec.link_to_cust_trx_line_id := p_link_to_cust_trx_line_id;
403 l_frt_rec.attribute_category := p_attribute_category;
404 l_frt_rec.attribute1 := p_attribute1;
405 l_frt_rec.attribute2 := p_attribute2;
406 l_frt_rec.attribute3 := p_attribute3;
407 l_frt_rec.attribute4 := p_attribute4;
408 l_frt_rec.attribute5 := p_attribute5;
409 l_frt_rec.attribute6 := p_attribute6;
410 l_frt_rec.attribute7 := p_attribute7;
411 l_frt_rec.attribute8 := p_attribute8;
412 l_frt_rec.attribute9 := p_attribute9;
413 l_frt_rec.attribute10 := p_attribute10;
414 l_frt_rec.attribute11 := p_attribute11;
415 l_frt_rec.attribute12 := p_attribute12;
416 l_frt_rec.attribute13 := p_attribute13;
417 l_frt_rec.attribute14 := p_attribute14;
418 l_frt_rec.attribute15 := p_attribute15;
419
420 l_frt_rec.interface_line_context := p_interface_line_context;
421 l_frt_rec.interface_line_attribute1 := p_interface_line_attribute1;
422 l_frt_rec.interface_line_attribute2 := p_interface_line_attribute2;
423 l_frt_rec.interface_line_attribute3 := p_interface_line_attribute3;
424 l_frt_rec.interface_line_attribute4 := p_interface_line_attribute4;
425 l_frt_rec.interface_line_attribute5 := p_interface_line_attribute5;
426 l_frt_rec.interface_line_attribute6 := p_interface_line_attribute6;
427 l_frt_rec.interface_line_attribute7 := p_interface_line_attribute7;
428 l_frt_rec.interface_line_attribute8 := p_interface_line_attribute8;
429 l_frt_rec.interface_line_attribute9 := p_interface_line_attribute9;
430 l_frt_rec.interface_line_attribute10 := p_interface_line_attribute10;
431 l_frt_rec.interface_line_attribute11 := p_interface_line_attribute11;
432 l_frt_rec.interface_line_attribute12 := p_interface_line_attribute12;
433 l_frt_rec.interface_line_attribute13 := p_interface_line_attribute13;
434 l_frt_rec.interface_line_attribute14 := p_interface_line_attribute14;
435 l_frt_rec.interface_line_attribute15 := p_interface_line_attribute15;
436
437 l_frt_rec.default_ussgl_trx_code_context := p_default_ussgl_code_context;
438 l_frt_rec.default_ussgl_transaction_code := p_default_ussgl_trx_code;
439
440 arp_process_freight.update_freight(
441 p_form_name,
442 p_form_version,
443 p_customer_trx_id,
444 p_customer_trx_line_id,
445 l_frt_rec,
446 p_trx_class,
447 p_gl_date,
448 p_frt_ccid,
449 p_complete_flag,
450 p_open_rec_flag,
451 p_status);
452
453 IF PG_DEBUG in ('Y', 'C') THEN
454 arp_util.debug('arp_process_freight.update_freight_cover()-');
455 END IF;
456
457 EXCEPTION
458 WHEN OTHERS THEN
459
460 IF PG_DEBUG in ('Y', 'C') THEN
461 arp_util.debug('EXCEPTION : arp_process_freight.update_freight_cover');
462 arp_util.debug('update_freight_cover: ' || 'p_form_name : '||p_form_name);
463 arp_util.debug('update_freight_cover: ' || 'p_form_version : '||p_form_version);
464 arp_util.debug('update_freight_cover: ' || 'p_customer_trx_id : '||p_customer_trx_id);
465 arp_util.debug('update_freight_cover: ' || 'p_customer_trx_line_id : '||p_customer_trx_line_id);
466 arp_util.debug('update_freight_cover: ' || 'p_line_type : '||p_line_type);
467 arp_util.debug('update_freight_cover: ' || 'p_line_number : '||p_line_number);
468 arp_util.debug('update_freight_cover: ' || 'p_extended_amount : '||p_extended_amount);
469 arp_util.debug('update_freight_cover: ' || 'p_revenue_amount : '||p_revenue_amount);
470 arp_util.debug('update_freight_cover: ' || 'p_previous_customer_trx_id : '||p_previous_customer_trx_id);
471 arp_util.debug('update_freight_cover: ' || 'p_previous_cust_trx_line_id : '||p_previous_cust_trx_line_id);
472 arp_util.debug('update_freight_cover: ' || 'p_link_to_cust_trx_line_id : '||p_link_to_cust_trx_line_id);
473 arp_util.debug('update_freight_cover: ' || 'p_attribute_category : '||p_attribute_category);
474 arp_util.debug('update_freight_cover: ' || 'p_attribute1 : '||p_attribute1);
475 arp_util.debug('update_freight_cover: ' || 'p_attribute2 : '||p_attribute2);
476 arp_util.debug('update_freight_cover: ' || 'p_attribute3 : '||p_attribute3);
477 arp_util.debug('update_freight_cover: ' || 'p_attribute4 : '||p_attribute4);
478 arp_util.debug('update_freight_cover: ' || 'p_attribute5 : '||p_attribute5);
479 arp_util.debug('update_freight_cover: ' || 'p_attribute6 : '||p_attribute6);
480 arp_util.debug('update_freight_cover: ' || 'p_attribute7 : '||p_attribute7);
481 arp_util.debug('update_freight_cover: ' || 'p_attribute8 : '||p_attribute8);
482 arp_util.debug('update_freight_cover: ' || 'p_attribute9 : '||p_attribute9);
483 arp_util.debug('update_freight_cover: ' || 'p_attribute10 : '||p_attribute10);
484 arp_util.debug('update_freight_cover: ' || 'p_attribute11 : '||p_attribute11);
485 arp_util.debug('update_freight_cover: ' || 'p_attribute12 : '||p_attribute12);
486 arp_util.debug('update_freight_cover: ' || 'p_attribute13 : '||p_attribute13);
487 arp_util.debug('update_freight_cover: ' || 'p_attribute14 : '||p_attribute14);
488 arp_util.debug('update_freight_cover: ' || 'p_attribute15 : '||p_attribute15);
489 arp_util.debug('update_freight_cover: ' || 'p_interface_line_context : '||p_interface_line_context);
490 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute1 : '||p_interface_line_attribute1);
491 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute2 : '||p_interface_line_attribute2);
492 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute3 : '||p_interface_line_attribute3);
493 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute4 : '||p_interface_line_attribute4);
494 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute5 : '||p_interface_line_attribute5);
495 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute6 : '||p_interface_line_attribute6);
496 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute7 : '||p_interface_line_attribute7);
497 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute8 : '||p_interface_line_attribute8);
498 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute9 : '||p_interface_line_attribute9);
499 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute10 : '||p_interface_line_attribute10);
500 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute11 : '||p_interface_line_attribute11);
501 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute12 : '||p_interface_line_attribute12);
502 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute13 : '||p_interface_line_attribute13);
503 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute14 : '||p_interface_line_attribute14);
504 arp_util.debug('update_freight_cover: ' || 'p_interface_line_attribute15 : '||p_interface_line_attribute15);
505 arp_util.debug('update_freight_cover: ' || 'p_default_ussgl_code_context : '||p_default_ussgl_code_context);
506 arp_util.debug('update_freight_cover: ' || 'p_default_ussgl_trx_code : '||p_default_ussgl_trx_code);
507 arp_util.debug('update_freight_cover: ' || 'p_trx_class : '||p_trx_class);
508 arp_util.debug('update_freight_cover: ' || 'p_gl_date : '||p_gl_date);
509 arp_util.debug('update_freight_cover: ' || 'p_frt_ccid : '||p_frt_ccid);
510 arp_util.debug('update_freight_cover: ' || 'p_complete_flag : '||p_complete_flag);
511 arp_util.debug('update_freight_cover: ' || 'p_open_rec_flag : '||p_open_rec_flag);
512 END IF;
513
514 RAISE;
515 END update_freight_cover;
516
517 END ARP_PROCESS_FREIGHT_COVER;