DBA Data[Home] [Help]

APPS.ARP_CTL_FREIGHT_PKG dependencies on ARP_CTL_PKG

Line 43: arp_util.debug('arp_ctl_pkg.select_summary_freight()+');

39: p_amount_total_rtot_db OUT NOCOPY number) IS
40: BEGIN
41:
42: IF PG_DEBUG in ('Y', 'C') THEN
43: arp_util.debug('arp_ctl_pkg.select_summary_freight()+');
44: END IF;
45:
46: SELECT NVL( SUM( NVL(extended_amount, 0 ) ), 0),
47: NVL( SUM( NVL(extended_amount, 0 ) ), 0)

Line 55: arp_util.debug('arp_ctl_pkg.select_summary_freight()-');

51: WHERE customer_trx_id = p_customer_trx_id
52: AND line_type = 'FREIGHT';
53:
54: IF PG_DEBUG in ('Y', 'C') THEN
55: arp_util.debug('arp_ctl_pkg.select_summary_freight()-');
56: END IF;
57:
58:
59: EXCEPTION

Line 62: arp_util.debug('EXCEPTION: arp_ctl_pkg.select_summary_freight()');

58:
59: EXCEPTION
60: WHEN OTHERS THEN
61: IF PG_DEBUG in ('Y', 'C') THEN
62: arp_util.debug('EXCEPTION: arp_ctl_pkg.select_summary_freight()');
63: END IF;
64: RAISE;
65:
66: END select_summary_freight;

Line 180: arp_util.debug('arp_ctl_pkg.lock_compare_frt_cover()+');

176: IS
177: l_frt_rec ra_customer_trx_lines%rowtype;
178: BEGIN
179:
180: arp_util.debug('arp_ctl_pkg.lock_compare_frt_cover()+');
181:
182: /*------------------------------------------------+
183: | Populate the line record with the values |
184: | passed in as parameters. |

Line 186: arp_ctl_pkg.set_to_dummy(l_frt_rec);

182: /*------------------------------------------------+
183: | Populate the line record with the values |
184: | passed in as parameters. |
185: +------------------------------------------------*/
186: arp_ctl_pkg.set_to_dummy(l_frt_rec);
187:
188: l_frt_rec.customer_trx_id := p_customer_trx_id;
189: l_frt_rec.customer_trx_line_id := p_customer_trx_line_id;
190: l_frt_rec.line_type := p_line_type;

Line 233: arp_ctl_pkg.lock_compare_p(l_frt_rec, p_customer_trx_line_id);

229:
230: l_frt_rec.default_ussgl_trx_code_context := p_default_ussgl_code_context;
231: l_frt_rec.default_ussgl_transaction_code := p_default_ussgl_trx_code;
232:
233: arp_ctl_pkg.lock_compare_p(l_frt_rec, p_customer_trx_line_id);
234:
235: arp_util.debug('arp_ctl_pkg.lock_compare_frt_cover()-');
236:
237: EXCEPTION

Line 235: arp_util.debug('arp_ctl_pkg.lock_compare_frt_cover()-');

231: l_frt_rec.default_ussgl_transaction_code := p_default_ussgl_trx_code;
232:
233: arp_ctl_pkg.lock_compare_p(l_frt_rec, p_customer_trx_line_id);
234:
235: arp_util.debug('arp_ctl_pkg.lock_compare_frt_cover()-');
236:
237: EXCEPTION
238:
239: WHEN OTHERS THEN

Line 240: arp_util.debug('EXCEPTION : arp_ctl_pkg.lock_compare_frt_cover()');

236:
237: EXCEPTION
238:
239: WHEN OTHERS THEN
240: arp_util.debug('EXCEPTION : arp_ctl_pkg.lock_compare_frt_cover()');
241:
242: arp_util.debug('customer_trx_id : '||p_customer_trx_id);
243: arp_util.debug('customer_trx_line_id : '||p_customer_trx_line_id);
244: arp_util.debug('line_type : '||p_line_type);