DBA Data[Home] [Help]

APPS.ARP_PROCESS_FREIGHT_UTIL dependencies on ARP_PROCESS_FREIGHT

Line 1: PACKAGE BODY ARP_PROCESS_FREIGHT_UTIL AS

1: PACKAGE BODY ARP_PROCESS_FREIGHT_UTIL AS
2: /* $Header: ARTEFR1B.pls 115.6 2003/10/10 14:28:17 mraymond ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: pg_number_dummy number;

Line 102: arp_util.debug('get_default_fob: ' || 'arp_process_freight.default_freight_line()+');

98:
99: BEGIN
100:
101: IF PG_DEBUG in ('Y', 'C') THEN
102: arp_util.debug('get_default_fob: ' || 'arp_process_freight.default_freight_line()+');
103: END IF;
104:
105: --
106: -- get the line_id that the parent line is crediting, if one is not passed

Line 236: arp_util.debug('get_default_fob: ' || 'arp_process_freight.default_freight_line()-');

232:
233: p_amount := l_amount;
234:
235: IF PG_DEBUG in ('Y', 'C') THEN
236: arp_util.debug('get_default_fob: ' || 'arp_process_freight.default_freight_line()-');
237: END IF;
238:
239: EXCEPTION
240: WHEN OTHERS THEN

Line 243: arp_util.debug('get_default_fob: ' || 'EXCEPTION : arp_process_freight.default_freight_line()');

239: EXCEPTION
240: WHEN OTHERS THEN
241:
242: IF PG_DEBUG in ('Y', 'C') THEN
243: arp_util.debug('get_default_fob: ' || 'EXCEPTION : arp_process_freight.default_freight_line()');
244: arp_util.debug('get_default_fob: ' || 'p_form_name : '||p_form_name);
245: arp_util.debug('get_default_fob: ' || 'p_form_version : '||p_form_version);
246: arp_util.debug('get_default_fob: ' || 'p_ct_id : '||p_ct_id);
247: arp_util.debug('get_default_fob: ' || 'p_line_ctl_id : '||p_line_ctl_id);

Line 296: arp_util.debug('get_default_fob: ' || 'arp_process_freight.get_freight_type()+');

292: l_frt_type varchar2(1);
293: BEGIN
294:
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_util.debug('get_default_fob: ' || 'arp_process_freight.get_freight_type()+');
297: END IF;
298:
299: SELECT decode(count(*),
300: 0, null,

Line 312: arp_util.debug('get_default_fob: ' || 'arp_process_freight.get_freight_type()-');

308:
309: return(l_frt_type);
310:
311: IF PG_DEBUG in ('Y', 'C') THEN
312: arp_util.debug('get_default_fob: ' || 'arp_process_freight.get_freight_type()-');
313: END IF;
314:
315: EXCEPTION
316: WHEN OTHERS THEN

Line 318: arp_util.debug('get_default_fob: ' || 'EXCEPTION : arp_process_freight.get_freight_type()');

314:
315: EXCEPTION
316: WHEN OTHERS THEN
317: IF PG_DEBUG in ('Y', 'C') THEN
318: arp_util.debug('get_default_fob: ' || 'EXCEPTION : arp_process_freight.get_freight_type()');
319: arp_util.debug('get_default_fob: ' || 'p_customer_trx_id : '||p_customer_trx_id);
320: END IF;
321:
322: RAISE;

Line 375: arp_util.debug('get_default_fob: ' || 'arp_process_freight_util.delete_frt_lines()+');

371:
372: BEGIN
373:
374: IF PG_DEBUG in ('Y', 'C') THEN
375: arp_util.debug('get_default_fob: ' || 'arp_process_freight_util.delete_frt_lines()+');
376: END IF;
377:
378: /*--------------------------------------------------------+
379: | call the delete handler for each of the freight lines |

Line 383: arp_process_freight.delete_freight(

379: | call the delete handler for each of the freight lines |
380: +--------------------------------------------------------*/
381: FOR frt_line_rec IN frt_lines(p_customer_trx_id) LOOP
382:
383: arp_process_freight.delete_freight(
384: p_form_name,
385: p_form_version,
386: p_trx_class,
387: p_complete_flag,

Line 395: arp_util.debug('get_default_fob: ' || 'arp_process_freight_util.delete_frt_lines()-');

391:
392: END LOOP;
393:
394: IF PG_DEBUG in ('Y', 'C') THEN
395: arp_util.debug('get_default_fob: ' || 'arp_process_freight_util.delete_frt_lines()-');
396: END IF;
397:
398: EXCEPTION
399: WHEN OTHERS THEN

Line 401: arp_util.debug('get_default_fob: ' || 'EXCEPTION : arp_process_freight_util.delete_frt_lines');

397:
398: EXCEPTION
399: WHEN OTHERS THEN
400: IF PG_DEBUG in ('Y', 'C') THEN
401: arp_util.debug('get_default_fob: ' || 'EXCEPTION : arp_process_freight_util.delete_frt_lines');
402: arp_util.debug('get_default_fob: ' || 'p_form_name : '||p_form_name);
403: arp_util.debug('get_default_fob: ' || 'p_form_version : '||p_form_version);
404: arp_util.debug('get_default_fob: ' || 'p_trx_class : '||p_trx_class);
405: arp_util.debug('get_default_fob: ' || 'p_complete_flag : '||p_complete_flag);

Line 607: arp_util.debug('EXCEPTION : arp_process_freight_util.get_default_fob');

603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: IF PG_DEBUG in ('Y', 'C') THEN
607: arp_util.debug('EXCEPTION : arp_process_freight_util.get_default_fob');
608: arp_util.debug('get_default_fob: ' || 'pn_SHIP_TO_SITE_USE_ID :'||to_char(pn_SHIP_TO_SITE_USE_ID));
609: arp_util.debug('get_default_fob: ' || 'pn_BILL_TO_SITE_USE_ID :'||to_char(pn_BILL_TO_SITE_USE_ID));
610: arp_util.debug('get_default_fob: ' || 'pn_SHIP_TO_CUSTOMER_ID :'||to_char(pn_SHIP_TO_CUSTOMER_ID));
611: arp_util.debug('get_default_fob: ' || 'pn_BILL_TO_CUSTOMER_ID :'||to_char(pn_BILL_TO_CUSTOMER_ID));

Line 618: END ARP_PROCESS_FREIGHT_UTIL;

614: RAISE;
615:
616: end get_default_fob;
617:
618: END ARP_PROCESS_FREIGHT_UTIL;