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 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 1411: arp_standard.debug( '-- Exception: Select default values from old invoice');

1407:
1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: IF PG_DEBUG in ('Y', 'C') THEN
1411: arp_standard.debug( '-- Exception: Select default values from old invoice');
1412: arp_standard.debug( '-- p_app_customer_trx_id='||
1413: TO_CHAR(p_app_customer_trx_id));
1414: END IF;
1415: RAISE;

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

1408: EXCEPTION
1409: WHEN OTHERS THEN
1410: IF PG_DEBUG in ('Y', 'C') THEN
1411: arp_standard.debug( '-- Exception: Select default values from old invoice');
1412: arp_standard.debug( '-- p_app_customer_trx_id='||
1413: TO_CHAR(p_app_customer_trx_id));
1414: END IF;
1415: RAISE;
1416: END;

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

1433: cr.cash_receipt_id = p_cash_receipt_id;
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: IF PG_DEBUG in ('Y', 'C') THEN
1437: arp_standard.debug( '-- Exception: Select default values from the receipt');
1438: arp_standard.debug( '-- p_cash_receipt_id='|| TO_CHAR(p_cash_receipt_id));
1439: END IF;
1440: RAISE;
1441: END;

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

1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: IF PG_DEBUG in ('Y', 'C') THEN
1437: arp_standard.debug( '-- Exception: Select default values from the receipt');
1438: arp_standard.debug( '-- p_cash_receipt_id='|| TO_CHAR(p_cash_receipt_id));
1439: END IF;
1440: RAISE;
1441: END;
1442: --app_customer_trx_id -4 is passed only in case of chargeback

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

1525: -- --------------------------------------------------
1526:
1527: BEGIN -- Select printing option
1528: IF PG_DEBUG in ('Y', 'C') THEN
1529: arp_standard.debug( '-- Select printing option');
1530: END IF;
1531:
1532: SELECT NVL(ctt.default_printing_option,'PRI')
1533: , DECODE(ctt.default_printing_option

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

1551:
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: IF PG_DEBUG in ('Y', 'C') THEN
1555: arp_standard.debug( '-- Exception: Select printing option from DB');
1556: arp_standard.debug( '-- ctt.cust_trx_type_id='||
1557: TO_CHAR(p_cust_trx_type_id));
1558: END IF;
1559: RAISE;

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

1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: IF PG_DEBUG in ('Y', 'C') THEN
1555: arp_standard.debug( '-- Exception: Select printing option from DB');
1556: arp_standard.debug( '-- ctt.cust_trx_type_id='||
1557: TO_CHAR(p_cust_trx_type_id));
1558: END IF;
1559: RAISE;
1560: END; -- Select printing option

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

1577: p_out_trx_number := l_ct_row.trx_number;
1578: p_out_customer_trx_id := l_ct_row.customer_trx_id;
1579:
1580: IF PG_DEBUG in ('Y', 'C') THEN
1581: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1582: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1583: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1584: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1585: arp_standard.debug ( '');

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

1578: p_out_customer_trx_id := l_ct_row.customer_trx_id;
1579:
1580: IF PG_DEBUG in ('Y', 'C') THEN
1581: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1582: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1583: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1584: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1585: arp_standard.debug ( '');
1586: END IF;

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

1579:
1580: IF PG_DEBUG in ('Y', 'C') THEN
1581: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1582: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1583: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1584: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1585: arp_standard.debug ( '');
1586: END IF;
1587:

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

1580: IF PG_DEBUG in ('Y', 'C') THEN
1581: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1582: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1583: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1584: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1585: arp_standard.debug ( '');
1586: END IF;
1587:
1588: -- ---------------------------------------------------

Line 1585: arp_standard.debug ( '');

1581: arp_standard.debug ( '-- Transaction number and internal id values returned from');
1582: arp_standard.debug ( '-- table handler arp_ct_pkg.insert_p:');
1583: arp_standard.debug ( 'trx_number = '||l_ct_row.trx_number);
1584: arp_standard.debug ( 'customer_trx_id = '|| to_char(l_ct_row.customer_trx_id));
1585: arp_standard.debug ( '');
1586: END IF;
1587:
1588: -- ---------------------------------------------------
1589: -- Get line type info for RA_CUSTOMER_TRX_LINES columns

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

1591: -- ---------------------------------------------------
1592: IF p_app_customer_trx_id <> -4 THEN
1593: BEGIN
1594: IF PG_DEBUG in ('Y', 'C') THEN
1595: arp_standard.debug( '-- Get line type info');
1596: END IF;
1597: SELECT ml.memo_line_id
1598: , ml.line_type
1599: , REPLACE(REPLACE(REPLACE(

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

1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: IF PG_DEBUG in ('Y', 'C') THEN
1619: arp_standard.debug( '-- Exception: SELECT FROM AR_MEMO_LINES');
1620: END IF;
1621: app_exception.raise_exception;
1622: END;
1623: ELSE

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

1621: app_exception.raise_exception;
1622: END;
1623: ELSE
1624: IF PG_DEBUG in ('Y', 'C') THEN
1625: arp_standard.debug( '-- Get line type info');
1626: END IF;
1627: --snambiar in receipt chargeback case,put the receipt details in
1628: --the description instead of invoice details
1629: BEGIN

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

1641:
1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: IF PG_DEBUG in ('Y', 'C') THEN
1645: arp_standard.debug( '-- Exception: SELECT FROM AR_MEMO_LINES');
1646: END IF;
1647: app_exception.raise_exception;
1648: END;
1649: END IF;

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

1730: -- Get CB_ADJ activity accounting code combination
1731: -- ---------------------------------------------------
1732: BEGIN
1733: IF PG_DEBUG in ('Y', 'C') THEN
1734: arp_standard.debug( '-- Get CB_ADJ activity accounting code combination');
1735: END IF;
1736: SELECT rt.code_combination_id
1737: INTO l_cb_activity_ccid
1738: FROM ar_receivables_trx rt

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

1743: FND_MESSAGE.set_name('AR', 'AR_RW_NO_GL_ACCT' );
1744: app_exception.raise_exception;
1745: WHEN OTHERS THEN
1746: IF PG_DEBUG in ('Y', 'C') THEN
1747: arp_standard.debug( '-- Exception: select from ar_receivables_trx');
1748: END IF;
1749: END;
1750:
1751: l_ctlgd_row.code_combination_id := l_cb_activity_ccid;

Line 2042: arp_standard.application_id

2038: -- proper AOL API GET_NEXT_SEQUENCE to get sequence number.
2039:
2040: /*
2041: FND_SEQNUM.GET_SEQ_NAME(
2042: arp_standard.application_id
2043: , l_rec_name -- category code
2044: , arp_global.set_of_books_id
2045: , 'A'
2046: , l_adj_row.apply_date

Line 2061: appid => arp_standard.application_id,

2057: BEGIN
2058:
2059: l_adj_row.doc_sequence_value :=
2060: FND_SEQNUM.GET_NEXT_SEQUENCE(
2061: appid => arp_standard.application_id,
2062: cat_code => l_rec_name,
2063: sobid => arp_global.set_of_books_id,
2064: met_code => 'A',
2065: trx_date => l_adj_row.apply_date,

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

2066: dbseqnm => l_sequence_name,
2067: dbseqid => l_adj_row.doc_sequence_id);
2068:
2069: IF PG_DEBUG in ('Y', 'C') THEN
2070: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
2071: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);
2072: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);
2073: END IF;
2074: EXCEPTION

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

2067: dbseqid => l_adj_row.doc_sequence_id);
2068:
2069: IF PG_DEBUG in ('Y', 'C') THEN
2070: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
2071: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);
2072: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);
2073: END IF;
2074: EXCEPTION
2075: WHEN OTHERS THEN

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

2068:
2069: IF PG_DEBUG in ('Y', 'C') THEN
2070: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
2071: arp_standard.debug( 'doc sequence id = ' || l_adj_row.doc_sequence_id);
2072: arp_standard.debug( 'doc sequence value = ' || l_adj_row.doc_sequence_value);
2073: END IF;
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: --Fix for Bug 1421614: For 'Partial' we should not raise the exception.

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 2114: arp_standard.debug ( 'Printing the contents of procedure parameters:');

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
2118: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));

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

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
2118: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2119: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));

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

2115: END IF;
2116: -- Print debug info
2117: IF PG_DEBUG in ('Y', 'C') THEN
2118: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2119: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );

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

2116: -- Print debug info
2117: IF PG_DEBUG in ('Y', 'C') THEN
2118: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2119: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );

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

2117: IF PG_DEBUG in ('Y', 'C') THEN
2118: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2119: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );

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

2118: arp_standard.debug ( ' p_amount = '||TO_CHAR( p_amount ));
2119: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );

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

2119: arp_standard.debug ( ' p_acctd_amount = '||TO_CHAR( p_acctd_amount ));
2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );

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

2120: arp_standard.debug ( ' p_trx_date = '||TO_CHAR( p_trx_date ));
2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );

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

2121: arp_standard.debug ( ' p_gl_id_ar_trade = '||TO_CHAR( p_gl_id_ar_trade ));
2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );

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

2122: arp_standard.debug ( ' p_gl_date = '||TO_CHAR( l_chargeback_gl_date ));
2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );

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

2123: arp_standard.debug ( ' p_attribute_category = '||p_attribute_category );
2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );

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

2124: arp_standard.debug ( ' p_attribute1 = '||p_attribute1 );
2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );

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

2125: arp_standard.debug ( ' p_attribute2 = '||p_attribute2 );
2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );

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

2126: arp_standard.debug ( ' p_attribute3 = '||p_attribute3 );
2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );

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

2127: arp_standard.debug ( ' p_attribute4 = '||p_attribute4 );
2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );

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

2128: arp_standard.debug ( ' p_attribute5 = '||p_attribute5 );
2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );

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

2129: arp_standard.debug ( ' p_attribute6 = '||p_attribute6 );
2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );

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

2130: arp_standard.debug ( ' p_attribute7 = '||p_attribute7 );
2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );

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

2131: arp_standard.debug ( ' p_attribute8 = '||p_attribute8 );
2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));

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

2132: arp_standard.debug ( ' p_attribute9 = '||p_attribute9 );
2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));

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

2133: arp_standard.debug ( ' p_attribute10 = '||p_attribute10 );
2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );

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

2134: arp_standard.debug ( ' p_attribute11 = '||p_attribute11 );
2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );

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

2135: arp_standard.debug ( ' p_attribute12 = '||p_attribute12 );
2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);

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

2136: arp_standard.debug ( ' p_attribute13 = '||p_attribute13 );
2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);

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

2137: arp_standard.debug ( ' p_attribute14 = '||p_attribute14 );
2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));

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

2138: arp_standard.debug ( ' p_attribute15 = '||p_attribute15 );
2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));

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

2139: arp_standard.debug ( ' p_cust_trx_type_id = '||TO_CHAR( p_cust_trx_type_id ));
2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );

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

2140: arp_standard.debug ( ' p_set_of_books_id = '||TO_CHAR( p_set_of_books_id ));
2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));

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

2141: arp_standard.debug ( ' p_reason_code = '||p_reason_code );
2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );

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

2142: arp_standard.debug ( ' p_comments = '||p_comments );
2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));

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

2143: arp_standard.debug ( ' p_def_ussgl_trx_code_contex = '||p_def_ussgl_trx_code_context);
2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));

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

2144: arp_standard.debug ( ' p_def_ussgl_transaction_cod = '||p_def_ussgl_transaction_code);
2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));

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

2145: arp_standard.debug ( ' p_due_date = '||TO_CHAR( p_due_date ));
2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));

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

2146: arp_standard.debug ( ' p_customer_id = '||TO_CHAR( p_customer_id ));
2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );

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

2147: arp_standard.debug ( ' p_cr_trx_number = '||p_cr_trx_number );
2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );
2155: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));

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

2148: arp_standard.debug ( ' p_cash_receipt_id = '||TO_CHAR( p_cash_receipt_id ));
2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );
2155: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2156: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));

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

2149: arp_standard.debug ( ' p_inv_trx_number = '||p_inv_trx_number );
2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );
2155: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2156: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2157: END IF;

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

2150: arp_standard.debug ( ' p_apply_date = '||TO_CHAR( p_apply_date ));
2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );
2155: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2156: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2157: END IF;
2158:

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

2151: arp_standard.debug ( ' p_receipt_gl_date = '||TO_CHAR( p_receipt_gl_date ));
2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );
2155: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2156: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2157: END IF;
2158:
2159: RAISE;

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

2152: arp_standard.debug ( ' p_app_customer_trx_id = '||TO_CHAR( p_app_customer_trx_id ));
2153: arp_standard.debug ( ' p_app_terms_sequence_number = '||TO_CHAR( p_app_terms_sequence_number ));
2154: arp_standard.debug ( ' p_form_name = '||p_form_name );
2155: arp_standard.debug ( ' p_doc_sequence_value = '||TO_CHAR( p_doc_sequence_value));
2156: arp_standard.debug ( ' p_doc_sequence_id = '||TO_CHAR( p_doc_sequence_id));
2157: END IF;
2158:
2159: RAISE;
2160:

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 2272: arp_standard.debug ( 'ERROR in the program! Dump of parameter values:');

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);
2276: arp_standard.debug ( ' p_reason_code = '||p_reason_code);

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

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);
2276: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2277: END IF;

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

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);
2276: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2277: END IF;
2278: RAISE;

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

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);
2276: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2277: END IF;
2278: RAISE;
2279: END update_chargeback;

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

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);
2276: arp_standard.debug ( ' p_reason_code = '||p_reason_code);
2277: END IF;
2278: RAISE;
2279: END update_chargeback;
2280:

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 2447: arp_standard.debug ('delete_chargeback: ' || 'ERROR in the program! Dump of parameter values:');

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));
2451: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);

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

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));
2451: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2452: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);

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

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));
2451: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2452: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2453: END IF;

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

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));
2451: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2452: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2453: END IF;
2454: RAISE;

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

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));
2451: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2452: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2453: END IF;
2454: RAISE;
2455:

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

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));
2451: arp_standard.debug ('delete_chargeback: ' || ' p_module_name = '|| p_module_name);
2452: arp_standard.debug ('delete_chargeback: ' || ' p_module_version = '|| p_module_version);
2453: END IF;
2454: RAISE;
2455:
2456: END delete_chargeback;