DBA Data[Home] [Help]

APPS.ARP_PROCESS_CHARGEBACK dependencies on ARP_STANDARD

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 109: arp_standard.debug('reverse_chargeback: ' || to_char( p_cb_ct_id ) );

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
113: validate_args_revcb( p_cb_ct_id, p_reversal_gl_date,

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 266: arp_standard.debug('reverse_chargeback: ' ||

262:
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;

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 317: arp_standard.debug('validate_args_revcb: ' ||

313: --
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;

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 364: arp_standard.debug( to_char( p_ps_id ) );

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: --
368: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

Line 365: arp_standard.debug( to_char( p_ass_cr_id ) );

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: --
368: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
369: validate_args_cbrev_group( p_ps_id, p_ass_cr_id, p_ct_count );

Line 375: arp_standard.debug('before BEGIN SELECT NVL in app_delete' );

371: --
372: -- Validate that the net of applications to the chargeback is zero.
373: --
374: IF PG_DEBUG in ('Y', 'C') THEN
375: arp_standard.debug('before BEGIN SELECT NVL in app_delete' );
376: END IF;
377: SELECT NVL( sum( ra.amount_applied), 0 )
378: INTO l_sum
379: FROM ar_receivable_applications ra

Line 393: arp_standard.debug( 'before 1st sum' );

389: AND b.customer_trx_id(+) = a.chargeback_customer_trx_id
390: AND b.customer_trx_id is NULL );
391: --
392: IF PG_DEBUG in ('Y', 'C') THEN
393: arp_standard.debug( 'before 1st sum' );
394: arp_standard.debug( to_char( l_sum ) );
395: END IF;
396: IF ( l_sum <> 0 ) THEN
397: IF PG_DEBUG in ('Y', 'C') THEN

Line 394: arp_standard.debug( to_char( l_sum ) );

390: AND b.customer_trx_id is NULL );
391: --
392: IF PG_DEBUG in ('Y', 'C') THEN
393: arp_standard.debug( 'before 1st sum' );
394: arp_standard.debug( to_char( l_sum ) );
395: END IF;
396: IF ( l_sum <> 0 ) THEN
397: IF PG_DEBUG in ('Y', 'C') THEN
398: arp_standard.debug( 'Sum of Charge back applications is non-zero');

Line 398: arp_standard.debug( 'Sum of Charge back applications is non-zero');

394: arp_standard.debug( to_char( l_sum ) );
395: END IF;
396: IF ( l_sum <> 0 ) THEN
397: IF PG_DEBUG in ('Y', 'C') THEN
398: arp_standard.debug( 'Sum of Charge back applications is non-zero');
399: END IF;
400: l_test_failed := FALSE;
401: END IF;
402: --

Line 408: arp_standard.debug( 'inside SELECT nvl 2nd in app_delete' );

404: --
405: -- Validate that the net of adjustments to the chargeback is zero.
406: --
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_standard.debug( 'inside SELECT nvl 2nd in app_delete' );
409: END IF;
410: SELECT NVL( sum( amount ), 0 )
411: INTO l_sum
412: FROM ar_adjustments

Line 427: arp_standard.debug( 'before 2nd sum' );

423: AND b.customer_trx_id is NULL )
424: AND NVL( postable, 'Y') = 'Y';
425: --
426: IF PG_DEBUG in ('Y', 'C') THEN
427: arp_standard.debug( 'before 2nd sum' );
428: arp_standard.debug( to_char( l_sum ) );
429: END IF;
430: --
431: IF ( l_sum <> 0 ) THEN

Line 428: arp_standard.debug( to_char( l_sum ) );

424: AND NVL( postable, 'Y') = 'Y';
425: --
426: IF PG_DEBUG in ('Y', 'C') THEN
427: arp_standard.debug( 'before 2nd sum' );
428: arp_standard.debug( to_char( l_sum ) );
429: END IF;
430: --
431: IF ( l_sum <> 0 ) THEN
432: IF PG_DEBUG in ('Y', 'C') THEN

Line 433: arp_standard.debug( 'Sum of Charge back applications is non-zero');

429: END IF;
430: --
431: IF ( l_sum <> 0 ) THEN
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug( 'Sum of Charge back applications is non-zero');
434: END IF;
435: l_test_failed := FALSE;
436: END IF;
437: --

Line 445: arp_standard.debug( 'before SELECT COUNT(*) in app_delete' );

441: --
442: -- Check if specified chargeback exist
443: --
444: IF PG_DEBUG in ('Y', 'C') THEN
445: arp_standard.debug( 'before SELECT COUNT(*) in app_delete' );
446: END IF;
447: --
448: SELECT count( distinct ct.customer_trx_id )
449: INTO l_count

Line 469: arp_standard.debug( 'passed in count does not match selected count' );

465: AND ps.class = 'CB';
466:
467: IF ( l_count <> p_ct_count ) THEN
468: IF PG_DEBUG in ('Y', 'C') THEN
469: arp_standard.debug( 'passed in count does not match selected count' );
470: END IF;
471: RETURN FALSE;
472: END IF;
473:

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 482: arp_standard.debug(

478:
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;

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 524: arp_standard.debug( to_char( p_ct_id ) );

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
528: validate_args_cbrev_ct( p_ct_id );

Line 536: arp_standard.debug( 'inside BEGIN SELECT NVL in app_delete' );

532: --
533: -- Validate that the net of applications to the chargeback is zero.
534: --
535: IF PG_DEBUG in ('Y', 'C') THEN
536: arp_standard.debug( 'inside BEGIN SELECT NVL in app_delete' );
537: END IF;
538: SELECT NVL( sum( amount_applied), 0 )
539: INTO l_sum
540: FROM ar_receivable_applications

Line 546: arp_standard.debug(

542: --
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: --

Line 552: arp_standard.debug( 'before 1st sum' );

548: END IF;
549: END;
550: --
551: IF PG_DEBUG in ('Y', 'C') THEN
552: arp_standard.debug( 'before 1st sum' );
553: arp_standard.debug( to_char( l_sum ) );
554: END IF;
555: --
556: IF ( l_sum <> 0 ) THEN

Line 553: arp_standard.debug( to_char( l_sum ) );

549: END;
550: --
551: IF PG_DEBUG in ('Y', 'C') THEN
552: arp_standard.debug( 'before 1st sum' );
553: arp_standard.debug( to_char( l_sum ) );
554: END IF;
555: --
556: IF ( l_sum <> 0 ) THEN
557: IF PG_DEBUG in ('Y', 'C') THEN

Line 558: arp_standard.debug( 'Sum of Charge back applications is non-zero');

554: END IF;
555: --
556: IF ( l_sum <> 0 ) THEN
557: IF PG_DEBUG in ('Y', 'C') THEN
558: arp_standard.debug( 'Sum of Charge back applications is non-zero');
559: END IF;
560: l_test_failed := FALSE;
561: END IF;
562: --

Line 569: arp_standard.debug( 'inside SELECT nvl 2nd in app_delete' );

565: -- Validate that the net of adjustments to the chargeback is zero.
566: --
567: BEGIN
568: IF PG_DEBUG in ('Y', 'C') THEN
569: arp_standard.debug( 'inside SELECT nvl 2nd in app_delete' );
570: END IF;
571: SELECT NVL( sum( amount ), 0 )
572: INTO l_sum
573: FROM ar_adjustments

Line 580: arp_standard.debug(

576: --
577: EXCEPTION
578: WHEN NO_DATA_FOUND THEN
579: IF PG_DEBUG in ('Y', 'C') THEN
580: arp_standard.debug(
581: 'No data found in RA table - validate_cb_reversal ' );
582: END IF;
583: END;
584: --

Line 586: arp_standard.debug( 'before 2nd sum' );

582: END IF;
583: END;
584: --
585: IF PG_DEBUG in ('Y', 'C') THEN
586: arp_standard.debug( 'before 2nd sum' );
587: arp_standard.debug( to_char( l_sum ) );
588: END IF;
589: --
590: IF ( l_sum <> 0 ) THEN

Line 587: arp_standard.debug( to_char( l_sum ) );

583: END;
584: --
585: IF PG_DEBUG in ('Y', 'C') THEN
586: arp_standard.debug( 'before 2nd sum' );
587: arp_standard.debug( to_char( l_sum ) );
588: END IF;
589: --
590: IF ( l_sum <> 0 ) THEN
591: IF PG_DEBUG in ('Y', 'C') THEN

Line 592: arp_standard.debug( 'Sum of Charge back applications is non-zero');

588: END IF;
589: --
590: IF ( l_sum <> 0 ) THEN
591: IF PG_DEBUG in ('Y', 'C') THEN
592: arp_standard.debug( 'Sum of Charge back applications is non-zero');
593: END IF;
594: l_test_failed := FALSE;
595: END IF;
596: --

Line 604: arp_standard.debug( 'before SELECT COUNT(*) in app_delete' );

600: --
601: -- Check if specified chargeback exist
602: --
603: IF PG_DEBUG in ('Y', 'C') THEN
604: arp_standard.debug( 'before SELECT COUNT(*) in app_delete' );
605: END IF;
606: BEGIN
607: SELECT count(*)
608: INTO l_count

Line 617: arp_standard.debug(

613: AND ps.class = 'CB';
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;

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 636: arp_standard.debug(

632: --
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;

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 675: arp_standard.debug(

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' );
677: RAISE;
678: END;
679: /*===========================================================================+

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 724: arp_standard.debug('validate_args_cbrev_group: ' ||

720: END IF;
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;

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 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 803: arp_standard.debug('-- Exception: Others: validate.args_create_cb');

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');
804: app_exception.raise_exception;
805: END;
806:
807: /*

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 1294: arp_standard.debug('arp_process_chargeback.create_chargeback()+');

1290: l_prev_cust_old_state AR_BUS_EVENT_COVER.prev_cust_old_state_tab;
1291:
1292: BEGIN
1293: IF PG_DEBUG in ('Y', 'C') THEN
1294: arp_standard.debug('arp_process_chargeback.create_chargeback()+');
1295: END IF;
1296:
1297: l_chargeback_gl_date := p_gl_date;
1298: -- ----------------------------------------------------------

Line 1425: arp_standard.debug( '-- Exception: Select default values from old invoice');

1421:
1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: IF PG_DEBUG in ('Y', 'C') THEN
1425: arp_standard.debug( '-- Exception: Select default values from old invoice');
1426: arp_standard.debug( '-- p_app_customer_trx_id='||
1427: TO_CHAR(p_app_customer_trx_id));
1428: END IF;
1429: RAISE;

Line 1426: arp_standard.debug( '-- p_app_customer_trx_id='||

1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: IF PG_DEBUG in ('Y', 'C') THEN
1425: arp_standard.debug( '-- Exception: Select default values from old invoice');
1426: arp_standard.debug( '-- p_app_customer_trx_id='||
1427: TO_CHAR(p_app_customer_trx_id));
1428: END IF;
1429: RAISE;
1430: END;

Line 1451: arp_standard.debug( '-- Exception: Select default values from the receipt');

1447: cr.cash_receipt_id = p_cash_receipt_id;
1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: IF PG_DEBUG in ('Y', 'C') THEN
1451: arp_standard.debug( '-- Exception: Select default values from the receipt');
1452: arp_standard.debug( '-- p_cash_receipt_id='|| TO_CHAR(p_cash_receipt_id));
1453: END IF;
1454: RAISE;
1455: END;

Line 1452: arp_standard.debug( '-- p_cash_receipt_id='|| TO_CHAR(p_cash_receipt_id));

1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: IF PG_DEBUG in ('Y', 'C') THEN
1451: arp_standard.debug( '-- Exception: Select default values from the receipt');
1452: arp_standard.debug( '-- p_cash_receipt_id='|| TO_CHAR(p_cash_receipt_id));
1453: END IF;
1454: RAISE;
1455: END;
1456: --app_customer_trx_id -4 is passed only in case of chargeback

Line 1555: arp_standard.debug('-- Exception: Setting Paying Site use Id');

1551: and su.primary_flag = 'Y';
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: IF PG_DEBUG in ('Y', 'C') THEN
1555: arp_standard.debug('-- Exception: Setting Paying Site use Id');
1556: END IF;
1557: RAISE;
1558: END;
1559:

Line 1591: arp_standard.debug( '-- Select printing option');

1587: -- --------------------------------------------------
1588:
1589: BEGIN -- Select printing option
1590: IF PG_DEBUG in ('Y', 'C') THEN
1591: arp_standard.debug( '-- Select printing option');
1592: END IF;
1593:
1594: SELECT NVL(ctt.default_printing_option,'PRI')
1595: , DECODE(ctt.default_printing_option

Line 1617: arp_standard.debug( '-- Exception: Select printing option from DB');

1613:
1614: EXCEPTION
1615: WHEN OTHERS THEN
1616: IF PG_DEBUG in ('Y', 'C') THEN
1617: arp_standard.debug( '-- Exception: Select printing option from DB');
1618: arp_standard.debug( '-- ctt.cust_trx_type_id='||
1619: TO_CHAR(p_cust_trx_type_id));
1620: END IF;
1621: RAISE;

Line 1618: arp_standard.debug( '-- ctt.cust_trx_type_id='||

1614: EXCEPTION
1615: WHEN OTHERS THEN
1616: IF PG_DEBUG in ('Y', 'C') THEN
1617: arp_standard.debug( '-- Exception: Select printing option from DB');
1618: arp_standard.debug( '-- ctt.cust_trx_type_id='||
1619: TO_CHAR(p_cust_trx_type_id));
1620: END IF;
1621: RAISE;
1622: END; -- Select printing option

Line 1643: arp_standard.debug ( '-- Transaction number and internal id values returned from');

1639: p_out_trx_number := l_ct_row.trx_number;
1640: p_out_customer_trx_id := l_ct_row.customer_trx_id;
1641:
1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1644: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1645: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1646: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1647: arp_standard.debug ( '');

Line 1644: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');

1640: p_out_customer_trx_id := l_ct_row.customer_trx_id;
1641:
1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1644: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1645: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1646: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1647: arp_standard.debug ( '');
1648: END IF;

Line 1645: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);

1641:
1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1644: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1645: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1646: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1647: arp_standard.debug ( '');
1648: END IF;
1649:

Line 1646: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));

1642: IF PG_DEBUG in ('Y', 'C') THEN
1643: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1644: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1645: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1646: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1647: arp_standard.debug ( '');
1648: END IF;
1649:
1650: /*Bug 13788971 - Payment Intrument details population - Start*/

Line 1647: arp_standard.debug ( '');

1643: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1644: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1645: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1646: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1647: arp_standard.debug ( '');
1648: END IF;
1649:
1650: /*Bug 13788971 - Payment Intrument details population - Start*/
1651: IF p_app_customer_trx_id <> -4 AND l_ct_row.receipt_method_id is not null THEN

Line 1673: arp_standard.debug( '-- Exception: no data found ');

1669: WHERE customer_trx_id = l_ct_row.customer_trx_id;
1670: EXCEPTION
1671: WHEN NO_DATA_FOUND THEN
1672: IF PG_DEBUG in ('Y', 'C') THEN
1673: arp_standard.debug( '-- Exception: no data found ');
1674: END IF;
1675: WHEN OTHERS THEN
1676: IF PG_DEBUG in ('Y', 'C') THEN
1677: arp_standard.debug('-- Exception: Error getting Payment instrument details for chargeback');

Line 1677: arp_standard.debug('-- Exception: Error getting Payment instrument details for chargeback');

1673: arp_standard.debug( '-- Exception: no data found ');
1674: END IF;
1675: WHEN OTHERS THEN
1676: IF PG_DEBUG in ('Y', 'C') THEN
1677: arp_standard.debug('-- Exception: Error getting Payment instrument details for chargeback');
1678: END IF;
1679: RAISE;
1680: END;
1681:

Line 1722: arp_standard.debug( '-- Get line type info');

1718: -- ---------------------------------------------------
1719: IF p_app_customer_trx_id <> -4 THEN
1720: BEGIN
1721: IF PG_DEBUG in ('Y', 'C') THEN
1722: arp_standard.debug( '-- Get line type info');
1723: END IF;
1724: SELECT ml.memo_line_id
1725: , ml.line_type
1726: , REPLACE(REPLACE(REPLACE(

Line 1746: arp_standard.debug( '-- Exception: SELECT FROM AR_MEMO_LINES');

1742:
1743: EXCEPTION
1744: WHEN OTHERS THEN
1745: IF PG_DEBUG in ('Y', 'C') THEN
1746: arp_standard.debug( '-- Exception: SELECT FROM AR_MEMO_LINES');
1747: END IF;
1748: app_exception.raise_exception;
1749: END;
1750: ELSE

Line 1752: arp_standard.debug( '-- Get line type info');

1748: app_exception.raise_exception;
1749: END;
1750: ELSE
1751: IF PG_DEBUG in ('Y', 'C') THEN
1752: arp_standard.debug( '-- Get line type info');
1753: END IF;
1754: --snambiar in receipt chargeback case,put the receipt details in
1755: --the description instead of invoice details
1756: BEGIN

Line 1772: arp_standard.debug( '-- Exception: SELECT FROM AR_MEMO_LINES');

1768:
1769: EXCEPTION
1770: WHEN OTHERS THEN
1771: IF PG_DEBUG in ('Y', 'C') THEN
1772: arp_standard.debug( '-- Exception: SELECT FROM AR_MEMO_LINES');
1773: END IF;
1774: app_exception.raise_exception;
1775: END;
1776: END IF;

Line 1861: arp_standard.debug( '-- Get CB_ADJ activity accounting code combination');

1857: -- Get CB_ADJ activity accounting code combination
1858: -- ---------------------------------------------------
1859: BEGIN
1860: IF PG_DEBUG in ('Y', 'C') THEN
1861: arp_standard.debug( '-- Get CB_ADJ activity accounting code combination');
1862: END IF;
1863: SELECT rt.code_combination_id
1864: INTO l_cb_activity_ccid
1865: FROM ar_receivables_trx rt

Line 1874: arp_standard.debug( '-- Exception: select from ar_receivables_trx');

1870: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );
1871: app_exception.raise_exception;
1872: WHEN OTHERS THEN
1873: IF PG_DEBUG in ('Y', 'C') THEN
1874: arp_standard.debug( '-- Exception: select from ar_receivables_trx');
1875: END IF;
1876: END;
1877:
1878: l_ctlgd_row.code_combination_id := l_cb_activity_ccid;

Line 2169: arp_standard.application_id

2165: -- proper AOL API GET_NEXT_SEQUENCE to get sequence number.
2166:
2167: /*
2168: FND_SEQNUM.GET_SEQ_NAME(
2169: arp_standard.application_id
2170: , l_rec_name -- category code
2171: , arp_global.set_of_books_id
2172: , 'A'
2173: , l_adj_row.apply_date

Line 2188: appid => arp_standard.application_id,

2184: BEGIN
2185:
2186: l_adj_row.doc_sequence_value :=
2187: FND_SEQNUM.GET_NEXT_SEQUENCE(
2188: appid => arp_standard.application_id,
2189: cat_code => l_rec_name,
2190: sobid => arp_global.set_of_books_id,
2191: met_code => 'A',
2192: trx_date => l_adj_row.apply_date,

Line 2197: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);

2193: dbseqnm => l_sequence_name,
2194: dbseqid => l_adj_row.doc_sequence_id);
2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
2198: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);
2199: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);
2200: END IF;
2201: EXCEPTION

Line 2198: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);

2194: dbseqid => l_adj_row.doc_sequence_id);
2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
2198: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);
2199: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);
2200: END IF;
2201: EXCEPTION
2202: WHEN OTHERS THEN

Line 2199: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);

2195:
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
2198: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);
2199: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);
2200: END IF;
2201: EXCEPTION
2202: WHEN OTHERS THEN
2203: --Fix for Bug 1421614: For 'Partial' we should not raise the exception.

Line 2238: arp_standard.debug('calling: jg_zz_ar_trx_pkg.is_reg_loc_enabled');

2234: l_ct_row.customer_trx_id,
2235: l_prev_cust_old_state);
2236: /* bug 10349867 PT ER */
2237: IF jg_zz_ar_trx_pkg.is_reg_loc_enabled THEN
2238: arp_standard.debug('calling: jg_zz_ar_trx_pkg.is_reg_loc_enabled');
2239: DECLARE
2240: p_return_flag boolean;
2241: p_return_code number;
2242: p_return_message varchar2(1024);

Line 2249: arp_standard.debug('Creating the Credit memo in Complete Status ');

2245:
2246: jg_zz_ar_trx_pkg.do_trx_complete(null,l_ct_row.customer_trx_id,'CHARGEBACK',p_return_flag, p_return_code,p_return_message);
2247:
2248: IF (p_return_flag = FALSE) THEN
2249: arp_standard.debug('Creating the Credit memo in Complete Status ');
2250: arp_standard.debug('Issue at the time of signature generation for localization');
2251: arp_standard.debug('Message : '||p_return_message);
2252:
2253: END IF;

Line 2250: arp_standard.debug('Issue at the time of signature generation for localization');

2246: jg_zz_ar_trx_pkg.do_trx_complete(null,l_ct_row.customer_trx_id,'CHARGEBACK',p_return_flag, p_return_code,p_return_message);
2247:
2248: IF (p_return_flag = FALSE) THEN
2249: arp_standard.debug('Creating the Credit memo in Complete Status ');
2250: arp_standard.debug('Issue at the time of signature generation for localization');
2251: arp_standard.debug('Message : '||p_return_message);
2252:
2253: END IF;
2254: EXCEPTION

Line 2251: arp_standard.debug('Message : '||p_return_message);

2247:
2248: IF (p_return_flag = FALSE) THEN
2249: arp_standard.debug('Creating the Credit memo in Complete Status ');
2250: arp_standard.debug('Issue at the time of signature generation for localization');
2251: arp_standard.debug('Message : '||p_return_message);
2252:
2253: END IF;
2254: EXCEPTION
2255: WHEN OTHERS THEN

Line 2256: arp_standard.debug(' error from jg_zz_ar_trx_pkg.is_reg_loc_enabled Call');

2252:
2253: END IF;
2254: EXCEPTION
2255: WHEN OTHERS THEN
2256: arp_standard.debug(' error from jg_zz_ar_trx_pkg.is_reg_loc_enabled Call');
2257:
2258: END;
2259: arp_standard.debug(' Exiting from PT Code Hook');
2260: END IF;

Line 2259: arp_standard.debug(' Exiting from PT Code Hook');

2255: WHEN OTHERS THEN
2256: arp_standard.debug(' error from jg_zz_ar_trx_pkg.is_reg_loc_enabled Call');
2257:
2258: END;
2259: arp_standard.debug(' Exiting from PT Code Hook');
2260: END IF;
2261:
2262: EXCEPTION
2263: WHEN OTHERS THEN

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

2261:
2262: EXCEPTION
2263: WHEN OTHERS THEN
2264: IF PG_DEBUG in ('Y', 'C') THEN
2265: arp_standard.debug ('ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK: Exception');
2266: arp_standard.debug ( 'Printing the contents of procedure parameters:');
2267: END IF;
2268: -- Print debug info
2269: IF PG_DEBUG in ('Y', 'C') THEN

Line 2266: arp_standard.debug ( 'Printing the contents of procedure parameters:');

2262: EXCEPTION
2263: WHEN OTHERS THEN
2264: IF PG_DEBUG in ('Y', 'C') THEN
2265: arp_standard.debug ('ARP_PROCESS_CHARGEBACK.CREATE_CHARGEBACK: Exception');
2266: arp_standard.debug ( 'Printing the contents of procedure parameters:');
2267: END IF;
2268: -- Print debug info
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));

Line 2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));

2266: arp_standard.debug ( 'Printing the contents of procedure parameters:');
2267: END IF;
2268: -- Print debug info
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));

Line 2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));

2267: END IF;
2268: -- Print debug info
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );

Line 2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));

2268: -- Print debug info
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );

Line 2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));

2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );

Line 2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));

2270: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );

Line 2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );

2271: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );

Line 2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );

2272: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );

Line 2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );

2273: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );

Line 2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );

2274: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );

Line 2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );

2275: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );

Line 2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );

2276: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );

Line 2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );

2277: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );

Line 2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );

2278: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );

Line 2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );

2279: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );

Line 2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );

2280: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );

Line 2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );

2281: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );

Line 2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );

2282: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );

Line 2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );

2283: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));

Line 2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );

2284: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));

Line 2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );

2285: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );

Line 2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );

2286: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );

Line 2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));

2287: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);

Line 2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));

2288: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);

Line 2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );

2289: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));

Line 2294: arp_standard.debug ( ' p_comments = '||p_comments );

2290: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));

Line 2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);

2291: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );

Line 2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);

2292: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));

Line 2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));

2293: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );

Line 2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));

2294: arp_standard.debug ( ' p_comments = '||p_comments );
2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));

Line 2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );

2295: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));

Line 2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));

2296: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));

Line 2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );

2297: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));

Line 2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));

2298: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );

Line 2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));

2299: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );
2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));

Line 2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));

2300: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );
2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2308: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));

Line 2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));

2301: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );
2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2308: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2309: END IF;

Line 2306: arp_standard.debug ( ' p_form_name = '||p_form_name );

2302: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );
2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2308: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2309: END IF;
2310:

Line 2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));

2303: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );
2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2308: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2309: END IF;
2310:
2311: RAISE;

Line 2308: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));

2304: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2305: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2306: arp_standard.debug ( ' p_form_name = '||p_form_name );
2307: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2308: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2309: END IF;
2310:
2311: RAISE;
2312:

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

2310:
2311: RAISE;
2312:
2313: IF PG_DEBUG in ('Y', 'C') THEN
2314: arp_standard.debug('arp_process_chargeback.create_chargeback()-');
2315: END IF;
2316:
2317: END create_chargeback;
2318:

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

2375:
2376: BEGIN
2377:
2378: IF PG_DEBUG in ('Y', 'C') THEN
2379: arp_standard.debug ('arp_process_chargeback.update_chargeback()+');
2380: END IF;
2381:
2382: -- ---------------------------------------------------
2383: -- First set all record parameters to dummy

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

2413: l_trx_rec
2414: , p_customer_trx_id);
2415:
2416: IF PG_DEBUG in ('Y', 'C') THEN
2417: arp_standard.debug ('arp_process_chargeback.update_chargeback()-');
2418: END IF;
2419:
2420: EXCEPTION
2421: WHEN OTHERS THEN

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

2419:
2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: IF PG_DEBUG in ('Y', 'C') THEN
2423: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');
2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2426: arp_standard.debug ( ' p_comments = '||p_comments);
2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);

Line 2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');

2420: EXCEPTION
2421: WHEN OTHERS THEN
2422: IF PG_DEBUG in ('Y', 'C') THEN
2423: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');
2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2426: arp_standard.debug ( ' p_comments = '||p_comments);
2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);
2428: arp_standard.debug ( ' p_reason_code = '||p_reason_code);

Line 2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));

2421: WHEN OTHERS THEN
2422: IF PG_DEBUG in ('Y', 'C') THEN
2423: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');
2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2426: arp_standard.debug ( ' p_comments = '||p_comments);
2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);
2428: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2429: END IF;

Line 2426: arp_standard.debug ( ' p_comments = '||p_comments);

2422: IF PG_DEBUG in ('Y', 'C') THEN
2423: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');
2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2426: arp_standard.debug ( ' p_comments = '||p_comments);
2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);
2428: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2429: END IF;
2430: RAISE;

Line 2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);

2423: arp_standard.debug ('EXCEPTION: arp_process_chargeback.update_chargeback()');
2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2426: arp_standard.debug ( ' p_comments = '||p_comments);
2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);
2428: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2429: END IF;
2430: RAISE;
2431: END update_chargeback;

Line 2428: arp_standard.debug ( ' p_reason_code = '||p_reason_code);

2424: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');
2425: arp_standard.debug ( ' p_customer_trx_id = '||TO_CHAR(p_customer_trx_id));
2426: arp_standard.debug ( ' p_comments = '||p_comments);
2427: arp_standard.debug ( ' p_DEFAULT_USSGL_TRX_CODE = '||p_DEFAULT_USSGL_TRX_CODE);
2428: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2429: END IF;
2430: RAISE;
2431: END update_chargeback;
2432:

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

2594: END IF;
2595: EXCEPTION
2596: WHEN OTHERS THEN
2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');
2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));

Line 2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');

2595: EXCEPTION
2596: WHEN OTHERS THEN
2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');
2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));
2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);

Line 2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));

2596: WHEN OTHERS THEN
2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');
2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));
2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2604: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);

Line 2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));

2597: IF PG_DEBUG in ('Y', 'C') THEN
2598: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');
2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));
2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2604: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2605: END IF;

Line 2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));

2598: arp_standard.debug ('EXCEPTION: arp_process_chargeback.delete_chargeback()');
2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));
2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2604: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2605: END IF;
2606: RAISE;

Line 2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);

2599: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');
2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));
2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2604: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2605: END IF;
2606: RAISE;
2607:

Line 2604: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);

2600: arp_standard.debug ('delete_chargeback: ' || ' p_customer_trx_id = '|| TO_CHAR(p_customer_trx_id));
2601: arp_standard.debug ('delete_chargeback: ' || ' p_gl_date = '|| TO_CHAR(p_gl_date));
2602: arp_standard.debug ('delete_chargeback: ' || ' p_apply_date = '|| TO_CHAR(p_apply_date));
2603: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2604: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2605: END IF;
2606: RAISE;
2607:
2608: END delete_chargeback;

Line 2669: arp_standard.debug('arp_process_chargeback.create_payment_extension(+)');

2665: l_end_date DATE;
2666:
2667: BEGIN
2668:
2669: arp_standard.debug('arp_process_chargeback.create_payment_extension(+)');
2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);
2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);

Line 2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);

2666:
2667: BEGIN
2668:
2669: arp_standard.debug('arp_process_chargeback.create_payment_extension(+)');
2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);
2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);

Line 2671: arp_standard.debug('p_customer_id: '|| p_customer_id);

2667: BEGIN
2668:
2669: arp_standard.debug('arp_process_chargeback.create_payment_extension(+)');
2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);
2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);

Line 2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);

2668:
2669: arp_standard.debug('arp_process_chargeback.create_payment_extension(+)');
2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);
2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);
2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);

Line 2673: arp_standard.debug('p_org_id: '|| p_org_id);

2669: arp_standard.debug('arp_process_chargeback.create_payment_extension(+)');
2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);
2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);
2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);
2677: arp_standard.debug('p_chargeback_date: '|| p_chargeback_date);

Line 2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);

2670: arp_standard.debug('p_assignment_id: ' ||p_assignment_id);
2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);
2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);
2677: arp_standard.debug('p_chargeback_date: '|| p_chargeback_date);
2678:

Line 2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);

2671: arp_standard.debug('p_customer_id: '|| p_customer_id);
2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);
2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);
2677: arp_standard.debug('p_chargeback_date: '|| p_chargeback_date);
2678:
2679: l_customer_id := p_customer_id;

Line 2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);

2672: arp_standard.debug('p_receipt_method_id: '|| p_receipt_method_id);
2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);
2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);
2677: arp_standard.debug('p_chargeback_date: '|| p_chargeback_date);
2678:
2679: l_customer_id := p_customer_id;
2680:

Line 2677: arp_standard.debug('p_chargeback_date: '|| p_chargeback_date);

2673: arp_standard.debug('p_org_id: '|| p_org_id);
2674: arp_standard.debug('p_customer_site_use_id: '|| p_customer_site_use_id);
2675: arp_standard.debug('p_chargeback_number: '|| p_chargeback_number);
2676: arp_standard.debug('p_customer_trx_id: '|| p_customer_trx_id);
2677: arp_standard.debug('p_chargeback_date: '|| p_chargeback_date);
2678:
2679: l_customer_id := p_customer_id;
2680:
2681: SELECT party.party_id

Line 2687: arp_standard.debug('l_party_id: '|| l_party_id);

2683: FROM hz_cust_accounts hca, hz_parties party
2684: WHERE hca.party_id = party.party_id
2685: AND hca.cust_account_id = l_customer_id;
2686:
2687: arp_standard.debug('l_party_id: '|| l_party_id);
2688:
2689: SELECT payment_channel_code
2690: INTO l_payment_channel_code
2691: from ar_receipt_methods

Line 2694: arp_standard.debug('l_payment_channel_code: '|| l_payment_channel_code);

2690: INTO l_payment_channel_code
2691: from ar_receipt_methods
2692: where receipt_method_id = p_receipt_method_id;
2693:
2694: arp_standard.debug('l_payment_channel_code: '|| l_payment_channel_code);
2695:
2696: /* pouplate values into the variables */
2697:
2698: l_payer_rec.Payment_Function := 'CUSTOMER_PAYMENT';

Line 2711: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;

2707: l_payer_rec.org_id := NULL;
2708: l_payer_rec.org_type := NULL;
2709:
2710: end if;
2711: l_trxn_attribs_rec.Originating_Application_Id := arp_standard.application_id;
2712: l_trxn_attribs_rec.order_id := p_chargeback_number;
2713: l_trxn_attribs_rec.Trxn_Ref_Number1 := 'TRANSACTION';
2714: l_trxn_attribs_rec.Trxn_Ref_Number2 := p_customer_trx_id;
2715: l_assignment_id := p_assignment_id;

Line 2734: arp_standard.debug('Payment Transaction Extension Id: '|| o_payment_trxn_extension_id);

2730:
2731: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2732:
2733: o_payment_trxn_extension_id := l_extension_id;
2734: arp_standard.debug('Payment Transaction Extension Id: '|| o_payment_trxn_extension_id);
2735:
2736: arp_standard.debug(to_char(SQL%ROWCOUNT) ||
2737: 'PMT_EXTN_ID row(s) updated.');
2738:

Line 2736: arp_standard.debug(to_char(SQL%ROWCOUNT) ||

2732:
2733: o_payment_trxn_extension_id := l_extension_id;
2734: arp_standard.debug('Payment Transaction Extension Id: '|| o_payment_trxn_extension_id);
2735:
2736: arp_standard.debug(to_char(SQL%ROWCOUNT) ||
2737: 'PMT_EXTN_ID row(s) updated.');
2738:
2739: END IF;
2740:

Line 2742: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||

2738:
2739: END IF;
2740:
2741: FOR i IN 1 .. l_msg_count LOOP
2742: arp_standard.debug('x_msg #' || TO_CHAR(i) || ' = <' ||
2743: SUBSTR(fnd_msg_pub.get(p_msg_index => i,
2744: p_encoded => FND_API.G_FALSE),
2745: 1,
2746: 150) || '>');

Line 2750: arp_standard.debug('FAILED: ' || l_result_rec.result_code);

2746: 150) || '>');
2747: END LOOP;
2748:
2749: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2750: arp_standard.debug('FAILED: ' || l_result_rec.result_code);
2751: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||
2752: l_payer_rec.Payment_Function);
2753: arp_standard.debug('PARM-l_payer_rec.party_id ' ||
2754: l_payer_rec.Party_Id);

Line 2751: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||

2747: END LOOP;
2748:
2749: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2750: arp_standard.debug('FAILED: ' || l_result_rec.result_code);
2751: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||
2752: l_payer_rec.Payment_Function);
2753: arp_standard.debug('PARM-l_payer_rec.party_id ' ||
2754: l_payer_rec.Party_Id);
2755: arp_standard.debug('PARM-l_payer_rec.org_id ' || l_payer_rec.org_id);

Line 2753: arp_standard.debug('PARM-l_payer_rec.party_id ' ||

2749: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2750: arp_standard.debug('FAILED: ' || l_result_rec.result_code);
2751: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||
2752: l_payer_rec.Payment_Function);
2753: arp_standard.debug('PARM-l_payer_rec.party_id ' ||
2754: l_payer_rec.Party_Id);
2755: arp_standard.debug('PARM-l_payer_rec.org_id ' || l_payer_rec.org_id);
2756: arp_standard.debug('PARM-l_payer_rec.org_type ' ||
2757: l_payer_rec.org_type);

Line 2755: arp_standard.debug('PARM-l_payer_rec.org_id ' || l_payer_rec.org_id);

2751: arp_standard.debug('PARM-l_payer_rec.Payment_Function ' ||
2752: l_payer_rec.Payment_Function);
2753: arp_standard.debug('PARM-l_payer_rec.party_id ' ||
2754: l_payer_rec.Party_Id);
2755: arp_standard.debug('PARM-l_payer_rec.org_id ' || l_payer_rec.org_id);
2756: arp_standard.debug('PARM-l_payer_rec.org_type ' ||
2757: l_payer_rec.org_type);
2758: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||
2759: l_payer_rec.Cust_Account_Id);

Line 2756: arp_standard.debug('PARM-l_payer_rec.org_type ' ||

2752: l_payer_rec.Payment_Function);
2753: arp_standard.debug('PARM-l_payer_rec.party_id ' ||
2754: l_payer_rec.Party_Id);
2755: arp_standard.debug('PARM-l_payer_rec.org_id ' || l_payer_rec.org_id);
2756: arp_standard.debug('PARM-l_payer_rec.org_type ' ||
2757: l_payer_rec.org_type);
2758: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||
2759: l_payer_rec.Cust_Account_Id);
2760: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||

Line 2758: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||

2754: l_payer_rec.Party_Id);
2755: arp_standard.debug('PARM-l_payer_rec.org_id ' || l_payer_rec.org_id);
2756: arp_standard.debug('PARM-l_payer_rec.org_type ' ||
2757: l_payer_rec.org_type);
2758: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||
2759: l_payer_rec.Cust_Account_Id);
2760: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||
2761: l_payer_rec.Account_Site_Id);
2762: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||

Line 2760: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||

2756: arp_standard.debug('PARM-l_payer_rec.org_type ' ||
2757: l_payer_rec.org_type);
2758: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||
2759: l_payer_rec.Cust_Account_Id);
2760: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||
2761: l_payer_rec.Account_Site_Id);
2762: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||
2763: l_trxn_attribs_rec.Originating_Application_Id);
2764: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||

Line 2762: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||

2758: arp_standard.debug('PARM-l_payer_rec.customer_id ' ||
2759: l_payer_rec.Cust_Account_Id);
2760: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||
2761: l_payer_rec.Account_Site_Id);
2762: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||
2763: l_trxn_attribs_rec.Originating_Application_Id);
2764: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||
2765: l_trxn_attribs_rec.order_id);
2766: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||

Line 2764: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||

2760: arp_standard.debug('PARM-l_payer_rec.customer_site_id ' ||
2761: l_payer_rec.Account_Site_Id);
2762: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||
2763: l_trxn_attribs_rec.Originating_Application_Id);
2764: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||
2765: l_trxn_attribs_rec.order_id);
2766: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||
2767: l_trxn_attribs_rec.Trxn_Ref_Number1);
2768: arp_standard.debug('PARM-l_assignment_id ' || l_assignment_id);

Line 2766: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||

2762: arp_standard.debug('PARM-l_trxn_attribs_rec.Originating_Application_Id ' ||
2763: l_trxn_attribs_rec.Originating_Application_Id);
2764: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||
2765: l_trxn_attribs_rec.order_id);
2766: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||
2767: l_trxn_attribs_rec.Trxn_Ref_Number1);
2768: arp_standard.debug('PARM-l_assignment_id ' || l_assignment_id);
2769:
2770: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2768: arp_standard.debug('PARM-l_assignment_id ' || l_assignment_id);

2764: arp_standard.debug('PARM- l_trxn_attribs_rec.order_id ' ||
2765: l_trxn_attribs_rec.order_id);
2766: arp_standard.debug('PARM-l_trxn_attribs_rec.Trxn_Ref_Number1 ' ||
2767: l_trxn_attribs_rec.Trxn_Ref_Number1);
2768: arp_standard.debug('PARM-l_assignment_id ' || l_assignment_id);
2769:
2770: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2771: p_count => x_msg_count,
2772: p_data => x_msg_data);

Line 2775: arp_standard.debug('arp_process_chargeback.create_payment_extension(-)');

2771: p_count => x_msg_count,
2772: p_data => x_msg_data);
2773:
2774: x_return_status := l_return_status;
2775: arp_standard.debug('arp_process_chargeback.create_payment_extension(-)');
2776: RETURN;
2777:
2778: END IF;
2779:

Line 2782: arp_standard.debug('arp_process_chargeback.create_payment_extension - ERROR IN CREATION ');

2778: END IF;
2779:
2780: EXCEPTION
2781: WHEN OTHERS THEN
2782: arp_standard.debug('arp_process_chargeback.create_payment_extension - ERROR IN CREATION ');
2783: RAISE;
2784: END Create_payment_extension;
2785:
2786: