DBA Data[Home] [Help]

APPS.ARP_RW_BATCHES_CHECK_PKG dependencies on ARP_STANDARD

Line 646: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: Before locking');

642: Finally prevented updation of batch for status as currently
643: status field is not significant for remittance batch. Prevented for call from prepayment only
644: Also didnot get for lock in case of exisitng code to avoid any regression*/
645:
646: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: Before locking');
647: l_exists := NULL;
648: BEGIN
649: SELECT 'Y',TYPE
650: INTO l_exists,l_type

Line 656: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: No data with new status');

652: WHERE batch_id = p_batch_id;
653: EXCEPTION
654: WHEN NO_DATA_FOUND THEN
655: NULL;
656: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: No data with new status');
657: WHEN OTHERS THEN
658: arp_standard.debug( 'EXCEPTION: arp_rw_batches_check_pkg.update_batch_status lock batch' );
659: RAISE;
660: END;

Line 658: arp_standard.debug( 'EXCEPTION: arp_rw_batches_check_pkg.update_batch_status lock batch' );

654: WHEN NO_DATA_FOUND THEN
655: NULL;
656: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: No data with new status');
657: WHEN OTHERS THEN
658: arp_standard.debug( 'EXCEPTION: arp_rw_batches_check_pkg.update_batch_status lock batch' );
659: RAISE;
660: END;
661:
662: IF nvl(p_called_from,'NONE') = 'PREPAYMENT' AND l_type = 'REMITTANCE' THEN

Line 673: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: Before calling update for batch');

669: FROM ar_batches
670: WHERE batch_id = p_batch_id
671: FOR UPDATE OF STATUS;
672: */
673: arp_standard.debug('arp_rw_batches_check_pkg.update_batch_status: Before calling update for batch');
674: arp_cr_batches_pkg.update_p( l_batch_rec, p_batch_id );
675: END IF;
676: --Bug7194951 Changes End Here (FP of 7138001 and 7146916)
677:

Line 1251: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()+');

1247: l_request_id ar_batches.request_id%TYPE;
1248: l_org_id number;
1249: BEGIN
1250: IF PG_DEBUG in ('Y', 'C') THEN
1251: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()+');
1252: END IF;
1253: --
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_standard.debug( 'Batch Id '||p_batch_id );

Line 1255: arp_standard.debug( 'Batch Id '||p_batch_id );

1251: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()+');
1252: END IF;
1253: --
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_standard.debug( 'Batch Id '||p_batch_id );
1256: arp_standard.debug( 'Set Of Books Id '||p_set_of_books_id );
1257: arp_standard.debug( 'Transmission_id = '||p_transmission_id );
1258: END IF;
1259: --

Line 1256: arp_standard.debug( 'Set Of Books Id '||p_set_of_books_id );

1252: END IF;
1253: --
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_standard.debug( 'Batch Id '||p_batch_id );
1256: arp_standard.debug( 'Set Of Books Id '||p_set_of_books_id );
1257: arp_standard.debug( 'Transmission_id = '||p_transmission_id );
1258: END IF;
1259: --
1260: -- Make sure that a batch id has been passed.

Line 1257: arp_standard.debug( 'Transmission_id = '||p_transmission_id );

1253: --
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_standard.debug( 'Batch Id '||p_batch_id );
1256: arp_standard.debug( 'Set Of Books Id '||p_set_of_books_id );
1257: arp_standard.debug( 'Transmission_id = '||p_transmission_id );
1258: END IF;
1259: --
1260: -- Make sure that a batch id has been passed.
1261: --

Line 1289: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()-');

1285: p_request_id := l_request_id;
1286: p_batch_applied_status := 'IN_PROCESS';
1287: --
1288: IF PG_DEBUG in ('Y', 'C') THEN
1289: arp_standard.debug( 'arp_rw_batches_check_pkg.post_batch_conc_req()-');
1290: END IF;
1291: --
1292: EXCEPTION
1293: WHEN OTHERS THEN

Line 1295: arp_standard.debug(

1291: --
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: IF PG_DEBUG in ('Y', 'C') THEN
1295: arp_standard.debug(
1296: 'EXCEPTION: arp_rw_batches_check_pkg.post_batch_conc_req' );
1297: END IF;
1298: RAISE;
1299: --

Line 1377: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()+');

1373: l_onacct_count_total_lines NUMBER := 0;
1374: --
1375: BEGIN
1376: IF PG_DEBUG in ('Y', 'C') THEN
1377: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()+');
1378: END IF;
1379: --
1380: IF PG_DEBUG in ('Y', 'C') THEN
1381: arp_standard.debug('get_quick_amount_totals: ' || 'Batch Id '||p_batch_id );

Line 1381: arp_standard.debug('get_quick_amount_totals: ' || 'Batch Id '||p_batch_id );

1377: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()+');
1378: END IF;
1379: --
1380: IF PG_DEBUG in ('Y', 'C') THEN
1381: arp_standard.debug('get_quick_amount_totals: ' || 'Batch Id '||p_batch_id );
1382: END IF;
1383: --
1384: IF ( p_batch_id IS NULL ) THEN
1385: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1552: arp_standard.debug('Get Quick Cash Totals - Claim Count Header='||to_char(l_claim_count_total_header));

1548: p_unapplied_amount_total := nvl(l_unapplied_amount_total,0);
1549: p_unapplied_count_total := nvl(l_unapplied_count_total,0);
1550: --
1551: IF PG_DEBUG in ('Y', 'C') THEN
1552: arp_standard.debug('Get Quick Cash Totals - Claim Count Header='||to_char(l_claim_count_total_header));
1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));
1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));
1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));
1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));

Line 1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));

1549: p_unapplied_count_total := nvl(l_unapplied_count_total,0);
1550: --
1551: IF PG_DEBUG in ('Y', 'C') THEN
1552: arp_standard.debug('Get Quick Cash Totals - Claim Count Header='||to_char(l_claim_count_total_header));
1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));
1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));
1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));
1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));
1557: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()-');

Line 1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));

1550: --
1551: IF PG_DEBUG in ('Y', 'C') THEN
1552: arp_standard.debug('Get Quick Cash Totals - Claim Count Header='||to_char(l_claim_count_total_header));
1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));
1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));
1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));
1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));
1557: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()-');
1558: END IF;

Line 1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));

1551: IF PG_DEBUG in ('Y', 'C') THEN
1552: arp_standard.debug('Get Quick Cash Totals - Claim Count Header='||to_char(l_claim_count_total_header));
1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));
1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));
1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));
1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));
1557: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()-');
1558: END IF;
1559: --

Line 1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));

1552: arp_standard.debug('Get Quick Cash Totals - Claim Count Header='||to_char(l_claim_count_total_header));
1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));
1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));
1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));
1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));
1557: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()-');
1558: END IF;
1559: --
1560: EXCEPTION

Line 1557: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()-');

1553: arp_standard.debug('Get Quick Cash Totals - Claim Count Lines='||to_char(l_claim_count_total_lines));
1554: arp_standard.debug('Get Quick Cash Totals - onacct Count Header='||to_char(l_onacct_count_total_header));
1555: arp_standard.debug('Get Quick Cash Totals - Onacct Count Lines='||to_char(l_onacct_count_total_lines));
1556: arp_standard.debug('Get Quick Cash Totals - Claim Count='||to_char(p_claim_count_total));
1557: arp_standard.debug( 'arp_rw_batches_check_pkg.get_quick_amount_totals()-');
1558: END IF;
1559: --
1560: EXCEPTION
1561: WHEN OTHERS THEN

Line 1563: arp_standard.debug('get_quick_amount_totals: ' ||

1559: --
1560: EXCEPTION
1561: WHEN OTHERS THEN
1562: IF PG_DEBUG in ('Y', 'C') THEN
1563: arp_standard.debug('get_quick_amount_totals: ' ||
1564: 'EXCEPTION: arp_rw_batches_check_pkg.get_quick_amount_totals '||
1565: l_break_point );
1566: END IF;
1567: RAISE;

Line 1614: arp_standard.debug( 'arp_rw_batches_check_pkg.get_reg_amount_totals()+');

1610: l_break_point VARCHAR2(20);
1611: --
1612: BEGIN
1613: IF PG_DEBUG in ('Y', 'C') THEN
1614: arp_standard.debug( 'arp_rw_batches_check_pkg.get_reg_amount_totals()+');
1615: END IF;
1616: --
1617: IF PG_DEBUG in ('Y', 'C') THEN
1618: arp_standard.debug('get_reg_amount_totals: ' || 'Batch Id '||p_batch_id );

Line 1618: arp_standard.debug('get_reg_amount_totals: ' || 'Batch Id '||p_batch_id );

1614: arp_standard.debug( 'arp_rw_batches_check_pkg.get_reg_amount_totals()+');
1615: END IF;
1616: --
1617: IF PG_DEBUG in ('Y', 'C') THEN
1618: arp_standard.debug('get_reg_amount_totals: ' || 'Batch Id '||p_batch_id );
1619: END IF;
1620: --
1621: IF ( p_batch_id IS NULL ) THEN
1622: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1833: arp_standard.debug( 'arp_rw_batches_check_pkg.get_reg_amount_totals()-');

1829: p_misc_amount_total := l_misc_amount_total;
1830: p_misc_count_total := l_misc_count_total;
1831: --
1832: IF PG_DEBUG in ('Y', 'C') THEN
1833: arp_standard.debug( 'arp_rw_batches_check_pkg.get_reg_amount_totals()-');
1834: END IF;
1835: --
1836: EXCEPTION
1837: WHEN OTHERS THEN

Line 1839: arp_standard.debug('get_reg_amount_totals: ' ||

1835: --
1836: EXCEPTION
1837: WHEN OTHERS THEN
1838: IF PG_DEBUG in ('Y', 'C') THEN
1839: arp_standard.debug('get_reg_amount_totals: ' ||
1840: 'EXCEPTION: arp_rw_batches_check_pkg.get_reg_amount_totals '||
1841: l_break_point );
1842: END IF;
1843: RAISE;