DBA Data[Home] [Help]

APPS.ARP_RW_BATCHES_PKG dependencies on ARP_RW_BATCHES_PKG

Line 1: PACKAGE BODY ARP_RW_BATCHES_PKG AS

1: PACKAGE BODY ARP_RW_BATCHES_PKG AS
2: /* $Header: ARERBATB.pls 120.13.12010000.2 2009/08/25 05:58:20 nproddut ship $ */
3: --
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5:

Line 127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );

123: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
124: --
125: BEGIN
126: IF PG_DEBUG in ('Y', 'C') THEN
127: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()+' );
128: arp_util.debug('validate_args_insert_manual: ' || 'Row Id : '||p_row_id );
129: arp_util.debug('validate_args_insert_manual: ' || 'Batch Id : '||p_batch_id );
130: arp_util.debug('validate_args_insert_manual: ' || 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
131: arp_util.debug('validate_args_insert_manual: ' || 'Batch Name : '||p_name );

Line 255: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()-' );

251: --
252: p_batch_applied_status := l_batch_rec.batch_applied_status;
253: --
254: IF PG_DEBUG in ('Y', 'C') THEN
255: arp_util.debug('validate_args_insert_manual: ' || 'arp_rw_batches_pkg.insert_manual_batch()-' );
256: END IF;
257: --
258: EXCEPTION
259: WHEN OTHERS THEN

Line 261: arp_util.debug('validate_args_insert_manual: ' || 'EXCEPTION: arp_rw_batches_pkg.insert_manual_batch' );

257: --
258: EXCEPTION
259: WHEN OTHERS THEN
260: IF PG_DEBUG in ('Y', 'C') THEN
261: arp_util.debug('validate_args_insert_manual: ' || 'EXCEPTION: arp_rw_batches_pkg.insert_manual_batch' );
262: END IF;
263: RAISE;
264: END insert_manual_batch;
265: --

Line 304: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()+' );

300: p_auto_batch_numbering IN ar_batch_sources.auto_batch_numbering%TYPE) IS
301: l_field VARCHAR2(30);
302: BEGIN
303: IF PG_DEBUG in ('Y', 'C') THEN
304: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()+' );
305: END IF;
306: --
307: IF ( p_row_id IS NOT NULL ) THEN
308: l_field := 'ROW_ID';

Line 341: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()-' );

337: APP_EXCEPTION.raise_exception;
338: END IF;
339: --
340: IF PG_DEBUG in ('Y', 'C') THEN
341: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_manual()-' );
342: END IF;
343: --
344: EXCEPTION
345: WHEN OTHERS THEN

Line 348: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_manual' );

344: EXCEPTION
345: WHEN OTHERS THEN
346: IF PG_DEBUG in ('Y', 'C') THEN
347: arp_util.debug('validate_args_insert_manual: ' ||
348: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_manual' );
349: END IF;
350: RAISE;
351: END validate_args_insert_manual;
352: --

Line 464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );

460: l_func_curr_code VARCHAR2(15);
461:
462: BEGIN
463: IF PG_DEBUG in ('Y', 'C') THEN
464: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()+' );
465: arp_util.debug('insert_auto_batch: ' || 'Row Id : '||p_row_id );
466: arp_util.debug('insert_auto_batch: ' || 'Batch Id : '||p_batch_id );
467: arp_util.debug('insert_auto_batch: ' || 'GL Date : '||p_gl_date );
468: arp_util.debug('insert_auto_batch: ' || 'Bank_account_low : '||p_bank_account_low );

Line 683: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()-' );

679: --
680: p_batch_applied_status := l_batch_applied_status;
681: --
682: IF PG_DEBUG in ('Y', 'C') THEN
683: arp_util.debug( 'arp_rw_batches_pkg.insert_auto_batch()-' );
684: END IF;
685: --
686: EXCEPTION
687: WHEN OTHERS THEN

Line 689: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_auto_batch' );

685: --
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF PG_DEBUG in ('Y', 'C') THEN
689: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_auto_batch' );
690: END IF;
691: RAISE;
692: END insert_auto_batch;
693: --

Line 733: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()+' );

729: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
730: l_field VARCHAR2(30);
731: BEGIN
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()+' );
734: END IF;
735: --
736: IF ( p_row_id IS NOT NULL ) THEN
737: l_field := 'ROW_ID';

Line 766: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()-' );

762: APP_EXCEPTION.raise_exception;
763: END IF;
764: --
765: IF PG_DEBUG in ('Y', 'C') THEN
766: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_auto()-' );
767: END IF;
768: --
769: EXCEPTION
770: WHEN OTHERS THEN

Line 773: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_auto' );

769: EXCEPTION
770: WHEN OTHERS THEN
771: IF PG_DEBUG in ('Y', 'C') THEN
772: arp_util.debug('validate_args_insert_auto: ' ||
773: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_auto' );
774: END IF;
775: RAISE;
776: END validate_args_insert_auto;
777: --

Line 946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );

942: l_valid NUMBER;
943:
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()+' );
947: arp_util.debug('insert_remit_batch: ' || 'Row Id : '||p_row_id );
948: arp_util.debug('insert_remit_batch: ' || 'Batch Id : '||p_batch_id );
949: arp_util.debug('insert_remit_batch: ' || 'GL Date : '||p_gl_date );
950: END IF;

Line 1144: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()-' );

1140: p_batch_id );
1141: --
1142: --
1143: IF PG_DEBUG in ('Y', 'C') THEN
1144: arp_util.debug( 'arp_rw_batches_pkg.insert_remit_batch()-' );
1145: END IF;
1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN

Line 1150: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_remit_batch' );

1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: IF PG_DEBUG in ('Y', 'C') THEN
1150: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.insert_remit_batch' );
1151: END IF;
1152: RAISE;
1153: END insert_remit_batch;
1154: --

Line 1193: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()+' );

1189: p_batch_applied_status IN ar_batches.batch_applied_status%TYPE ) IS
1190: l_field VARCHAR2(30);
1191: BEGIN
1192: IF PG_DEBUG in ('Y', 'C') THEN
1193: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()+' );
1194: END IF;
1195: --
1196: IF ( p_row_id IS NOT NULL ) THEN
1197: l_field := 'ROW_ID';

Line 1232: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()-' );

1228: APP_EXCEPTION.raise_exception;
1229: END IF;
1230: --
1231: IF PG_DEBUG in ('Y', 'C') THEN
1232: arp_util.debug( 'arp_rw_batches_pkg.validate_args_insert_remit()-' );
1233: END IF;
1234: --
1235: EXCEPTION
1236: WHEN OTHERS THEN

Line 1239: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_remit' );

1235: EXCEPTION
1236: WHEN OTHERS THEN
1237: IF PG_DEBUG in ('Y', 'C') THEN
1238: arp_util.debug('validate_args_insert_remit: ' ||
1239: 'EXCEPTION: arp_rw_batches_pkg.validate_args_insert_remit' );
1240: END IF;
1241: RAISE;
1242: END validate_args_insert_remit;
1243: --

Line 1269: arp_standard.debug('EXCEPTION: arp_rw_batches_pkg.delete_batch');

1265:
1266: EXCEPTION
1267: WHEN OTHERS THEN
1268: IF PG_DEBUG in ('Y', 'C') THEN
1269: arp_standard.debug('EXCEPTION: arp_rw_batches_pkg.delete_batch');
1270: END IF;
1271: RAISE;
1272: END delete_batch;
1273:

Line 1341: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()+');

1337: l_org_id := NULL;
1338: l_default_org_id := fnd_profile.value('DEFAULT_ORG_ID');
1339: l_defaulted_flag := 'N';
1340: IF PG_DEBUG IN ('Y', 'C') THEN
1341: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()+');
1342: arp_debug.debug(' default_org_id: ' || l_default_org_id);
1343: arp_debug.debug(' p_batch_source_name: ' || p_batch_source_name);
1344: END IF;
1345: /* Fetch Data from Default Batch Source */

Line 1608: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()-');

1604: p_bank_branch_id :=l_bank_branch_id;
1605: p_override_remit_flag :=l_override_remit_flag;
1606: END IF;
1607: IF PG_DEBUG IN ('Y', 'C') THEN
1608: arp_debug.debug('arp_rw_batches_pkg.default_batch_source_pay_mthds()-');
1609: END IF;
1610:
1611: END default_batch_source_pay_mthds;
1612:

Line 1627: arp_debug.debug('arp_rw_batches_pkg.request_lock()+');

1623: v_result NUMBER;
1624:
1625: BEGIN
1626: IF PG_DEBUG IN ('Y', 'C') THEN
1627: arp_debug.debug('arp_rw_batches_pkg.request_lock()+');
1628: arp_debug.debug('p_batch_id '||p_batch_id);
1629: END IF;
1630:
1631: l_lock_name := 'AR_RECEIPTS_BATCH_'||p_batch_id;

Line 1650: arp_debug.debug('arp_rw_batches_pkg.request_lock()-');

1646: END CASE;
1647:
1648: IF PG_DEBUG IN ('Y', 'C') THEN
1649: arp_debug.debug('v_result '||v_result);
1650: arp_debug.debug('arp_rw_batches_pkg.request_lock()-');
1651: END IF;
1652:
1653: IF v_result IN (0,4) THEN
1654: RETURN TRUE;

Line 1672: arp_debug.debug('arp_rw_batches_pkg.release_lock()+');

1668: l_lock_handle VARCHAR2(256);
1669: v_result NUMBER;
1670: BEGIN
1671: IF PG_DEBUG IN ('Y', 'C') THEN
1672: arp_debug.debug('arp_rw_batches_pkg.release_lock()+');
1673: arp_debug.debug('p_batch_id '||p_batch_id);
1674: END IF;
1675:
1676: l_lock_name := 'AR_RECEIPTS_BATCH_'||p_batch_id;

Line 1692: arp_debug.debug('arp_rw_batches_pkg.release_lock()-');

1688: END CASE;
1689:
1690: IF PG_DEBUG IN ('Y', 'C') THEN
1691: arp_debug.debug('v_result '||v_result);
1692: arp_debug.debug('arp_rw_batches_pkg.release_lock()-');
1693: END IF;
1694:
1695: IF v_result = 0 THEN
1696: RETURN TRUE;

Line 1705: END ARP_RW_BATCHES_PKG;

1701: END release_lock;
1702:
1703:
1704:
1705: END ARP_RW_BATCHES_PKG;
1706: