eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_MATCH_REV_COGS_GRP dependencies on ARP_DEBUG

Line 81: arp_debug.debug( 'ar_match_rev_cogs_grp.period_status()+ ');

77:
78: BEGIN
79:
80: IF PG_DEBUG in ('Y', 'C') THEN
81: arp_debug.debug( 'ar_match_rev_cogs_grp.period_status()+ ');
82: END IF;
83:
84: -- Standard Start of API savepoint
85: SAVEPOINT period_status_grp;

Line 111: arp_debug.debug( 'ar_match_rev_cogs_grp.period_status()- ');

107: FETCH status INTO x_status;
108: CLOSE status;
109:
110: IF PG_DEBUG in ('Y', 'C') THEN
111: arp_debug.debug( 'ar_match_rev_cogs_grp.period_status()- ');
112: END IF;
113:
114: EXCEPTION
115: WHEN fnd_api.g_exc_error THEN

Line 166: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()+ ');

162:
163: BEGIN
164:
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()+ ');
167: END IF;
168:
169: OPEN epm;
170: FETCH epm INTO l_eff_period_num, l_set_of_books_id;

Line 189: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()- ');

185:
186: --l_status := 'C';
187:
188: IF PG_DEBUG in ('Y', 'C') THEN
189: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()- ');
190: END IF;
191:
192: RETURN l_status;
193:

Line 340: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');

336:
337: BEGIN
338:
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');
341: arp_debug.debug(' p_ledger_id = ' || p_ledger_id);
342: arp_debug.debug(' p_gl_date = ' || p_from_gl_date ||
343: ' to ' || p_to_gl_date);
344:

Line 341: arp_debug.debug(' p_ledger_id = ' || p_ledger_id);

337: BEGIN
338:
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');
341: arp_debug.debug(' p_ledger_id = ' || p_ledger_id);
342: arp_debug.debug(' p_gl_date = ' || p_from_gl_date ||
343: ' to ' || p_to_gl_date);
344:
345: END IF;

Line 342: arp_debug.debug(' p_gl_date = ' || p_from_gl_date ||

338:
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');
341: arp_debug.debug(' p_ledger_id = ' || p_ledger_id);
342: arp_debug.debug(' p_gl_date = ' || p_from_gl_date ||
343: ' to ' || p_to_gl_date);
344:
345: END IF;
346:

Line 381: arp_debug.debug(' cogs_request_id = ' || l_request_id);

377: l_original_org := mo_global.get_current_org_id;
378: l_original_context := mo_global.get_access_mode;
379:
380: IF PG_DEBUG in ('Y', 'C') THEN
381: arp_debug.debug(' cogs_request_id = ' || l_request_id);
382: END IF;
383:
384: /* PROGRAM FLOW
385: This program now executes in 4 steps or stages. They are:

Line 420: arp_debug.debug('Processing org_id =' || c_org.org_id || ', sob_id = ' ||

416: FOR c_org IN ar_operations(p_ledger_id)
417: LOOP
418:
419: IF PG_DEBUG in ('Y', 'C') THEN
420: arp_debug.debug('Processing org_id =' || c_org.org_id || ', sob_id = ' ||
421: c_org.set_of_books_id);
422: END IF;
423:
424: /* Step 1 - Tag eligible gl_dist rows based on date range.

Line 462: arp_debug.debug(' fetched ' || gld_rowids.count ||

458: END IF;
459:
460: IF PG_DEBUG in ('Y', 'C')
461: THEN
462: arp_debug.debug(' fetched ' || gld_rowids.count ||
463: ' distinct gld row(s) for update.');
464: END IF;
465:
466: /* If no rows at all, skip to next org */

Line 471: arp_debug.debug(' skipping to next org');

467: IF l_rows = 0
468: THEN
469: IF PG_DEBUG in ('Y','C')
470: THEN
471: arp_debug.debug(' skipping to next org');
472: END IF;
473: CLOSE gld_rows_c; -- need to close it before we skip
474: goto next_org;
475: END IF;

Line 482: arp_debug.debug(' last fetch for this org. Exiting fetch loop');

478: IF gld_rowids.count = 0 AND l_last_fetch
479: THEN
480: IF PG_DEBUG in ('Y','C')
481: THEN
482: arp_debug.debug(' last fetch for this org. Exiting fetch loop');
483: END IF;
484: EXIT;
485: END IF;
486:

Line 501: arp_debug.debug(' updated ' || l_rows ||

497:
498: IF PG_DEBUG in ('Y', 'C')
499: THEN
500: l_rows := SQL%ROWCOUNT;
501: arp_debug.debug(' updated ' || l_rows ||
502: ' distinct gld row(s).');
503: END IF;
504:
505: END LOOP;

Line 547: arp_debug.debug(' no sales orders to process - skip to next org');

543: IF l_so_rows = 0
544: THEN
545: IF PG_DEBUG in ('Y','C')
546: THEN
547: arp_debug.debug(' no sales orders to process - skip to next org');
548: END IF;
549: CLOSE so_numbers_c;
550: goto next_org;
551: END IF;

Line 629: arp_debug.debug(' inserted ' || l_so_rows_inserted ||

625: l_so_rows_inserted := SQL%ROWCOUNT;
626:
627: IF PG_DEBUG in ('Y','C')
628: THEN
629: arp_debug.debug(' inserted ' || l_so_rows_inserted ||
630: ' row(s) into ar_trx_cogs_gt');
631: END IF;
632:
633: END LOOP;

Line 639: arp_debug.debug(' processed ' || l_so_rows ||

635: CLOSE so_numbers_c;
636:
637: IF PG_DEBUG in ('Y', 'C')
638: THEN
639: arp_debug.debug(' processed ' || l_so_rows ||
640: ' distinct orders.');
641: END IF;
642:
643: /* debug logic +/

Line 646: arp_debug.debug('start - dump of ar_trx_cogs_gt');

642:
643: /* debug logic +/
644: IF PG_DEBUG in ('Y', 'C')
645: THEN
646: arp_debug.debug('start - dump of ar_trx_cogs_gt');
647: FOR gt IN trx_gt LOOP
648: arp_debug.debug(gt.customer_trx_id || '~' ||
649: gt.customer_trx_line_id || '~' ||
650: gt.previous_customer_trx_line_id || '~' ||

Line 648: arp_debug.debug(gt.customer_trx_id || '~' ||

644: IF PG_DEBUG in ('Y', 'C')
645: THEN
646: arp_debug.debug('start - dump of ar_trx_cogs_gt');
647: FOR gt IN trx_gt LOOP
648: arp_debug.debug(gt.customer_trx_id || '~' ||
649: gt.customer_trx_line_id || '~' ||
650: gt.previous_customer_trx_line_id || '~' ||
651: gt.so_line_id);
652: END LOOP;

Line 653: arp_debug.debug('end - dump of ar_trx_cogs_gt');

649: gt.customer_trx_line_id || '~' ||
650: gt.previous_customer_trx_line_id || '~' ||
651: gt.so_line_id);
652: END LOOP;
653: arp_debug.debug('end - dump of ar_trx_cogs_gt');
654: END IF;
655: /+ end - debug logic */
656:
657: IF PG_DEBUG in ('Y', 'C') THEN

Line 658: arp_debug.debug(c_org.org_id ||

654: END IF;
655: /+ end - debug logic */
656:
657: IF PG_DEBUG in ('Y', 'C') THEN
658: arp_debug.debug(c_org.org_id ||
659: ': completed..' );
660: END IF;
661:
662: /* 7291422 - Diagnostics to identify missed or bad orders */

Line 668: arp_debug.debug(c_problem_rows.meaning || '(' ||

664: THEN
665: FOR c_problem_rows IN bad_rows(c_org.org_id,
666: p_from_gl_date, p_to_gl_date)
667: LOOP
668: arp_debug.debug(c_problem_rows.meaning || '(' ||
669: c_problem_rows.cogs_request_id || ') count=' ||
670: c_problem_rows.error_count);
671: END LOOP;
672: END IF;

Line 718: arp_debug.debug(' Merging into cst_revenue_recognition_lines');

714: */
715:
716: IF PG_DEBUG in ('Y','C')
717: THEN
718: arp_debug.debug(' Merging into cst_revenue_recognition_lines');
719: END IF;
720:
721: MERGE INTO cst_revenue_recognition_lines crrl
722: USING

Line 806: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');

802: , p_data => x_msg_data
803: );
804:
805: IF PG_DEBUG in ('Y', 'C') THEN
806: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');
807: END IF;
808:
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN

Line 847: arp_debug.debug( SQLCODE);

843: FND_MSG_PUB.Add;
844: END IF;
845:
846: IF PG_DEBUG in ('Y', 'C') THEN
847: arp_debug.debug( SQLCODE);
848: arp_debug.debug( SQLERRM);
849: END IF;
850:
851: ROLLBACK TO populate_cst_tables_grp;

Line 848: arp_debug.debug( SQLERRM);

844: END IF;
845:
846: IF PG_DEBUG in ('Y', 'C') THEN
847: arp_debug.debug( SQLCODE);
848: arp_debug.debug( SQLERRM);
849: END IF;
850:
851: ROLLBACK TO populate_cst_tables_grp;
852: fnd_msg_pub.count_and_get (