DBA Data[Home] [Help]

APPS.ARRX_COGS_REP_INNER dependencies on ARRX_COGS_REP_INNER

Line 1: PACKAGE BODY arrx_cogs_rep_inner AS

1: PACKAGE BODY arrx_cogs_rep_inner AS
2: /* $Header: ARRXRCGB.pls 120.1 2005/10/30 04:45:55 appldev noship $ */
3:
4:
5: /*========================================================================

Line 140: fnd_file.put_line(fnd_file.log, 'ARRX_COGS_REP_INNER.POPULATE_ROWS()+');

136: -- This routine populate the interface table so the detail RXi report
137: -- can publish the report based on the data in the interface table.
138:
139: IF pg_debug in ('Y', 'C') THEN
140: fnd_file.put_line(fnd_file.log, 'ARRX_COGS_REP_INNER.POPULATE_ROWS()+');
141: END IF;
142:
143: fnd_file.put_line(fnd_file.log, 'request id: ' || p_request_id);
144: fnd_file.put_line(fnd_file.log, 'user id : ' || p_user_id);

Line 224: ( arrx_cogs_rep_inner.get_cost(

220: lines.line_number trx_line_number,
221: ROUND((SUM(lines.revenue_amount)/
222: count(dist.cust_trx_line_gl_dist_id)), l_precision) orig_revenue,
223: SUM
224: ( arrx_cogs_rep_inner.get_cost(
225: dist.account_class,
226: dist.rec_offset_flag,
227: lines.customer_trx_line_id,
228: mta.base_transaction_value)) orig_cost,

Line 237: 2, arrx_cogs_rep_inner.get_cost(

233: (DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_low)), -1, 0, 1)
234: +
235: DECODE(sign(mmt.transaction_date -fnd_date.chardate_to_date(p_gl_date_high)), 1, 0, 1)
236: ),
237: 2, arrx_cogs_rep_inner.get_cost(
238: dist.account_class,
239: dist.rec_offset_flag,
240: lines.customer_trx_line_id, mta.base_transaction_value), 0
241: )

Line 366: fnd_file.put_line(fnd_file.log, 'ARRX_COGS_REP_INNER.POPULATE_ROWS()-');

362:
363: fnd_file.put_line(fnd_file.log, 'description populated');
364:
365: IF pg_debug in ('Y', 'C') THEN
366: fnd_file.put_line(fnd_file.log, 'ARRX_COGS_REP_INNER.POPULATE_ROWS()-');
367: END IF;
368:
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN

Line 372: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');

368:
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: IF pg_debug in ('Y', 'C') THEN
372: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
373: END IF;
374: RAISE;
375:
376: WHEN OTHERS THEN

Line 378: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');

374: RAISE;
375:
376: WHEN OTHERS THEN
377: IF pg_debug in ('Y', 'C') THEN
378: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
379: END IF;
380: RAISE;
381:
382: END populate_rows;

Line 527: fnd_file.put_line(fnd_file.log, 'ARRX_COGS_REP_INNER.POPULATE_SUMMARY()-');

523:
524: END IF;
525:
526: IF pg_debug in ('Y', 'C') THEN
527: fnd_file.put_line(fnd_file.log, 'ARRX_COGS_REP_INNER.POPULATE_SUMMARY()-');
528: END IF;
529:
530: EXCEPTION
531: WHEN NO_DATA_FOUND THEN

Line 533: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');

529:
530: EXCEPTION
531: WHEN NO_DATA_FOUND THEN
532: IF pg_debug in ('Y', 'C') THEN
533: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
534: END IF;
535: RAISE;
536:
537: WHEN OTHERS THEN

Line 539: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');

535: RAISE;
536:
537: WHEN OTHERS THEN
538: IF pg_debug in ('Y', 'C') THEN
539: arp_standard.debug('EXCEPTION: arrx_cogs_rep_inner.populate_rows()');
540: END IF;
541: RAISE;
542:
543: END populate_summary;

Line 559: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');

555: NULL;
556:
557: EXCEPTION
558: WHEN NO_DATA_FOUND THEN
559: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
560: RAISE;
561:
562: WHEN OTHERS THEN
563: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');

Line 563: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');

559: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
560: RAISE;
561:
562: WHEN OTHERS THEN
563: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
564: RAISE;
565:
566: END arrx_cogs_rep_inner;

Line 566: END arrx_cogs_rep_inner;

562: WHEN OTHERS THEN
563: arp_standard.debug('exception: arrx_cogs_rep_inner.initialize()');
564: RAISE;
565:
566: END arrx_cogs_rep_inner;