DBA Data[Home] [Help]

APPS.ARP_PROCESS_CHARGEBACK dependencies on ARP_PROCESS_CHARGEBACK

Line 1: PACKAGE BODY ARP_PROCESS_CHARGEBACK AS

1: PACKAGE BODY ARP_PROCESS_CHARGEBACK AS
2: /* $Header: ARCECBB.pls 120.16 2007/01/12 10:14:29 ugummall ship $*/
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: NULL_VAR ar_payment_schedules%ROWTYPE; /* Added for Bug 460966 - Oracle 8 */

Line 108: arp_standard.debug( 'arp_process_chargeback.reverse_chargeback()+');

104: adj_api_failure exception;
105: --
106: BEGIN
107: IF PG_DEBUG in ('Y', 'C') THEN
108: arp_standard.debug( 'arp_process_chargeback.reverse_chargeback()+');
109: arp_standard.debug('reverse_chargeback: ' || to_char( p_cb_ct_id ) );
110: END IF;
111:
112: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

Line 210: arp_standard.debug('EXCEPTION: arp_process_chargeback.reverse_chargeback

206: RETURN;
207: EXCEPTION
208: WHEN adj_api_failure THEN
209: IF PG_DEBUG in ('Y', 'C') THEN
210: arp_standard.debug('EXCEPTION: arp_process_chargeback.reverse_chargeback
211: receipt CB adjustment API failed' );
212: END IF;
213: RAISE;
214: WHEN OTHERS THEN

Line 216: arp_standard.debug('EXCEPTION: arp_process_chargeback.reverse_chargeback

212: END IF;
213: RAISE;
214: WHEN OTHERS THEN
215: IF PG_DEBUG in ('Y', 'C') THEN
216: arp_standard.debug('EXCEPTION: arp_process_chargeback.reverse_chargeback
217: receipt CB adjustment failed' );
218: END IF;
219: RAISE;
220:

Line 260: arp_standard.debug( 'arp_process_chargeback.reverse_chargeback()-');

256: arp_ps_util.update_reverse_actions( l_app_rec, NULL, NULL);
257: END IF;
258:
259: IF PG_DEBUG in ('Y', 'C') THEN
260: arp_standard.debug( 'arp_process_chargeback.reverse_chargeback()-');
261: END IF;
262:
263: EXCEPTION
264: WHEN OTHERS THEN

Line 267: 'EXCEPTION: arp_process_chargeback.reverse_chargeback' );

263: EXCEPTION
264: WHEN OTHERS THEN
265: IF PG_DEBUG in ('Y', 'C') THEN
266: arp_standard.debug('reverse_chargeback: ' ||
267: 'EXCEPTION: arp_process_chargeback.reverse_chargeback' );
268: END IF;
269: RAISE;
270: END reverse_chargeback;
271: --

Line 302: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_revcb' );

298: p_reversal_gl_date IN DATE,
299: p_reversal_date IN DATE ) IS
300: BEGIN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_revcb' );
303: END IF;
304: --
305: IF ( p_cb_ct_id is NULL OR p_reversal_gl_date is NULL OR
306: p_reversal_date is NULL ) THEN

Line 311: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_revcb' );

307: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
308: APP_EXCEPTION.raise_exception;
309: END IF;
310: IF PG_DEBUG in ('Y', 'C') THEN
311: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_revcb' );
312: END IF;
313: --
314: EXCEPTION
315: WHEN OTHERS THEN

Line 318: 'EXCEPTION: arp_process_chargeback.validate_args_revcb' );

314: EXCEPTION
315: WHEN OTHERS THEN
316: IF PG_DEBUG in ('Y', 'C') THEN
317: arp_standard.debug('validate_args_revcb: ' ||
318: 'EXCEPTION: arp_process_chargeback.validate_args_revcb' );
319: END IF;
320: RAISE;
321: END validate_args_revcb;
322: --

Line 363: arp_standard.debug( 'arp_process_chargeback.validate_cb_reversal()+' );

359: l_test_failed BOOLEAN DEFAULT TRUE;
360: l_count NUMBER;
361: BEGIN
362: IF PG_DEBUG in ('Y', 'C') THEN
363: arp_standard.debug( 'arp_process_chargeback.validate_cb_reversal()+' );
364: arp_standard.debug( to_char( p_ps_id ) );
365: arp_standard.debug( to_char( p_ass_cr_id ) );
366: END IF;
367: --

Line 475: arp_standard.debug( 'arp_process_chargeback.validate_cb_reversal()-');

471: RETURN FALSE;
472: END IF;
473:
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_standard.debug( 'arp_process_chargeback.validate_cb_reversal()-');
476: END IF;
477: RETURN TRUE;
478:
479: EXCEPTION

Line 483: 'EXCEPTION: arp_process_chargeback.validate_cb_reversal' );

479: EXCEPTION
480: WHEN OTHERS THEN
481: IF PG_DEBUG in ('Y', 'C') THEN
482: arp_standard.debug(
483: 'EXCEPTION: arp_process_chargeback.validate_cb_reversal' );
484: END IF;
485: RAISE;
486: END validate_cb_reversal;
487: --

Line 523: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_cb_reversal' );

519: l_test_failed BOOLEAN DEFAULT TRUE;
520: l_count NUMBER;
521: BEGIN
522: IF PG_DEBUG in ('Y', 'C') THEN
523: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_cb_reversal' );
524: arp_standard.debug( to_char( p_ct_id ) );
525: END IF;
526: --
527: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

Line 547: 'arp_process_chargeback.validate_cb_reversal - NO_DATA_FOUND' );

543: EXCEPTION
544: WHEN NO_DATA_FOUND THEN
545: IF PG_DEBUG in ('Y', 'C') THEN
546: arp_standard.debug(
547: 'arp_process_chargeback.validate_cb_reversal - NO_DATA_FOUND' );
548: END IF;
549: END;
550: --
551: IF PG_DEBUG in ('Y', 'C') THEN

Line 618: 'arp_process_chargeback.validate_cb_reversa - NO_DATA_FOUND' );

614: EXCEPTION
615: WHEN NO_DATA_FOUND THEN
616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_standard.debug(
618: 'arp_process_chargeback.validate_cb_reversa - NO_DATA_FOUND' );
619: END IF;
620: RETURN FALSE;
621: END;
622: --

Line 629: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_cb_reversal' );

625: -- level.
626:
627: --
628: IF PG_DEBUG in ('Y', 'C') THEN
629: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_cb_reversal' );
630: END IF;
631: RETURN TRUE;
632: --
633: EXCEPTION

Line 637: 'EXCEPTION: arp_process_chargeback.validate_cb_reversal' );

633: EXCEPTION
634: WHEN OTHERS THEN
635: IF PG_DEBUG in ('Y', 'C') THEN
636: arp_standard.debug(
637: 'EXCEPTION: arp_process_chargeback.validate_cb_reversal' );
638: END IF;
639: RAISE;
640: END validate_cb_reversal;
641: /*===========================================================================+

Line 666: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_ct' );

662: +===========================================================================*/
663: PROCEDURE validate_args_cbrev_ct (
664: p_ct_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
665: BEGIN
666: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_ct' );
667: IF ( p_ct_id is NULL ) THEN
668: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
669: APP_EXCEPTION.raise_exception;
670: END IF;

Line 672: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_cbrev_ct' );

668: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
669: APP_EXCEPTION.raise_exception;
670: END IF;
671: --
672: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_cbrev_ct' );
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_standard.debug(
676: 'EXCEPTION: arp_process_chargeback.validate_args_cbrev_ct' );

Line 676: 'EXCEPTION: arp_process_chargeback.validate_args_cbrev_ct' );

672: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_cbrev_ct' );
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_standard.debug(
676: 'EXCEPTION: arp_process_chargeback.validate_args_cbrev_ct' );
677: RAISE;
678: END;
679: /*===========================================================================+
680: | PROCEDURE |

Line 711: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_group' );

707: p_ass_cr_id IN ar_adjustments.associated_cash_receipt_id%TYPE,
708: p_ct_count IN NUMBER ) IS
709: BEGIN
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_standard.debug( '>>>>>>>> arp_process_chargeback.validate_args_cbrev_group' );
712: END IF;
713: IF ( p_ps_id is NULL OR p_ass_cr_id is NULL OR p_ct_count is NULL ) THEN
714: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
715: APP_EXCEPTION.raise_exception;

Line 719: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_cbrev_group' );

715: APP_EXCEPTION.raise_exception;
716: END IF;
717: --
718: IF PG_DEBUG in ('Y', 'C') THEN
719: arp_standard.debug( '<<<<<<<< arp_process_chargeback.validate_args_cbrev_group' );
720: END IF;
721: EXCEPTION
722: WHEN OTHERS THEN
723: IF PG_DEBUG in ('Y', 'C') THEN

Line 725: 'EXCEPTION: arp_process_chargeback.validate_args_cbrev_group' );

721: EXCEPTION
722: WHEN OTHERS THEN
723: IF PG_DEBUG in ('Y', 'C') THEN
724: arp_standard.debug('validate_args_cbrev_group: ' ||
725: 'EXCEPTION: arp_process_chargeback.validate_args_cbrev_group' );
726: END IF;
727: RAISE;
728: END validate_args_cbrev_group;
729:

Line 770: arp_standard.debug('arp_process_chargeback.validate_args_create_cb(+)' );

766: IS
767: l_parameter_tokens VARCHAR2(100);
768:
769: BEGIN
770: arp_standard.debug('arp_process_chargeback.validate_args_create_cb(+)' );
771:
772: l_parameter_tokens := '';
773:
774: -- ---------------------------------------------------

Line 795: fnd_message.set_token('PROCEDURE','ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK');

791: -- ---------------------------------------------------
792: IF (l_parameter_tokens <> '') THEN
793: fnd_message.set_name('AR','AR_PROCEDURE_VALID_ARGS_FAIL');
794: fnd_message.set_token('PARAMETER',l_parameter_tokens);
795: fnd_message.set_token('PROCEDURE','ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK');
796: app_exception.raise_exception;
797: END IF;
798:
799: arp_standard.debug('arp_process_chargeback.validate_args_create_cb(-)' );

Line 799: arp_standard.debug('arp_process_chargeback.validate_args_create_cb(-)' );

795: fnd_message.set_token('PROCEDURE','ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK');
796: app_exception.raise_exception;
797: END IF;
798:
799: arp_standard.debug('arp_process_chargeback.validate_args_create_cb(-)' );
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_standard.debug('-- Exception: Others: validate.args_create_cb');

Line 828: arp_standard.debug ('arp_process_chargeback.init_adj_struct()+');

824: PROCEDURE init_adj_struct (
825: p_adj_rec IN OUT NOCOPY AR_ADJUSTMENTS%ROWTYPE) IS
826: BEGIN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_standard.debug ('arp_process_chargeback.init_adj_struct()+');
829: END IF;
830: p_adj_rec.adjustment_id := NULL;
831: p_adj_rec.amount := 0;
832: p_adj_rec.acctd_amount := 0;

Line 858: arp_standard.debug ('arp_process_chargeback.init_adj_struct()-');

854: p_adj_rec.program_update_date := NULL;
855: p_adj_rec.program_id := NULL;
856: p_adj_rec.program_application_id := NULL;
857: IF PG_DEBUG in ('Y', 'C') THEN
858: arp_standard.debug ('arp_process_chargeback.init_adj_struct()-');
859: END IF;
860:
861: END init_adj_struct;
862:

Line 886: arp_standard.debug ('arp_process_chargeback.init_ps_struct()+');

882: PROCEDURE init_ps_struct (
883: p_ps_rec IN OUT NOCOPY AR_PAYMENT_SCHEDULES%ROWTYPE) IS
884: BEGIN
885: IF PG_DEBUG in ('Y', 'C') THEN
886: arp_standard.debug ('arp_process_chargeback.init_ps_struct()+');
887: END IF;
888: p_ps_rec.payment_schedule_id := NULL;
889: p_ps_rec.due_date := NULL;
890: p_ps_rec.amount_due_original := NULL;

Line 952: arp_standard.debug ('arp_process_chargeback.init_ps_struct()-');

948: p_ps_rec.call_date_last := NULL;
949: p_ps_rec.trx_number := NULL;
950: p_ps_rec.trx_date := NULL;
951: IF PG_DEBUG in ('Y', 'C') THEN
952: arp_standard.debug ('arp_process_chargeback.init_ps_struct()-');
953: END IF;
954:
955: END init_ps_struct;
956: /*

Line 979: arp_standard.debug ('arp_process_chargeback.init_app_struct()+');

975: PROCEDURE init_app_struct (
976: p_app_rec IN OUT NOCOPY AR_RECEIVABLE_APPLICATIONS%ROWTYPE) IS
977: BEGIN
978: IF PG_DEBUG in ('Y', 'C') THEN
979: arp_standard.debug ('arp_process_chargeback.init_app_struct()+');
980: END IF;
981:
982: p_app_rec.receivable_application_id := NULL;
983: p_app_rec.amount_applied := NULL;

Line 1015: arp_standard.debug ('init_app_struct: ' || 'arp_process_chargeback.init_ps_struct()-');

1011: p_app_rec.application_rule := NULL;
1012: p_app_rec.gl_posted_date := NULL;
1013:
1014: IF PG_DEBUG in ('Y', 'C') THEN
1015: arp_standard.debug ('init_app_struct: ' || 'arp_process_chargeback.init_ps_struct()-');
1016: END IF;
1017:
1018: END init_app_struct;
1019:

Line 1280: arp_standard.debug('arp_process_chargeback.create_chargeback()+');

1276: l_prev_cust_old_state AR_BUS_EVENT_COVER.prev_cust_old_state_tab;
1277:
1278: BEGIN
1279: IF PG_DEBUG in ('Y', 'C') THEN
1280: arp_standard.debug('arp_process_chargeback.create_chargeback()+');
1281: END IF;
1282:
1283: l_chargeback_gl_date := p_gl_date;
1284: -- ----------------------------------------------------------

Line 1316: arp_process_chargeback.validate_args_create_cb(

1312: -- ---------------------------------------------------
1313: -- Validate parameters
1314: -- ---------------------------------------------------
1315:
1316: arp_process_chargeback.validate_args_create_cb(
1317: l_chargeback_gl_date
1318: , p_cust_trx_type_id
1319: , p_app_customer_trx_id
1320: , p_due_date

Line 2113: arp_standard.debug ('ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK: Exception');

2109:
2110: EXCEPTION
2111: WHEN OTHERS THEN
2112: IF PG_DEBUG in ('Y', 'C') THEN
2113: arp_standard.debug ('ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK: Exception');
2114: arp_standard.debug ( 'Printing the contents of procedure parameters:');
2115: END IF;
2116: -- Print debug info
2117: IF PG_DEBUG in ('Y', 'C') THEN

Line 2162: arp_standard.debug('arp_process_chargeback.create_chargeback()-');

2158:
2159: RAISE;
2160:
2161: IF PG_DEBUG in ('Y', 'C') THEN
2162: arp_standard.debug('arp_process_chargeback.create_chargeback()-');
2163: END IF;
2164:
2165: END create_chargeback;
2166:

Line 2227: arp_standard.debug ('arp_process_chargeback.update_chargeback()+');

2223:
2224: BEGIN
2225:
2226: IF PG_DEBUG in ('Y', 'C') THEN
2227: arp_standard.debug ('arp_process_chargeback.update_chargeback()+');
2228: END IF;
2229:
2230: -- ---------------------------------------------------
2231: -- First set all record parameters to dummy

Line 2265: arp_standard.debug ('arp_process_chargeback.update_chargeback()-');

2261: l_trx_rec
2262: , p_customer_trx_id);
2263:
2264: IF PG_DEBUG in ('Y', 'C') THEN
2265: arp_standard.debug ('arp_process_chargeback.update_chargeback()-');
2266: END IF;
2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN

Line 2271: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');

2267:
2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: IF PG_DEBUG in ('Y', 'C') THEN
2271: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');
2272: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2273: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2274: arp_standard.debug ( ' p_comments = '||p_comments);
2275: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);

Line 2351: arp_process_chargeback.reverse_chargeback (

2347: l_charges_adjusted NUMBER;
2348:
2349: BEGIN
2350:
2351: arp_process_chargeback.reverse_chargeback (
2352: p_cb_ct_id => p_customer_trx_id
2353: , p_reversal_gl_date => p_gl_date
2354: , p_reversal_date => p_apply_date
2355: , p_module_name => p_module_name

Line 2446: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');

2442: END IF;
2443: EXCEPTION
2444: WHEN OTHERS THEN
2445: IF PG_DEBUG in ('Y', 'C') THEN
2446: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');
2447: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2448: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2449: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2450: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));

Line 2459: END ARP_PROCESS_CHARGEBACK;

2455:
2456: END delete_chargeback;
2457:
2458:
2459: END ARP_PROCESS_CHARGEBACK;