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
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,
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
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:
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
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;
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
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
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;
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: --
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
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 );
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
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
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');
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: --
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
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
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
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: --
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
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:
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
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;
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
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 );
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
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: --
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
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
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: --
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
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: --
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
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
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: --
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
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;
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
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;
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;
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' );
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: /*===========================================================================+
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;
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
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;
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: -- ---------------------------------------------------
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');
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: /*
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;
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:
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;
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: /*
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;
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:
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: -- ----------------------------------------------------------
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;
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;
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;
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
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
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;
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
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 ( '');
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;
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:
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: -- ---------------------------------------------------
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
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(
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
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
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;
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
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;
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
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,
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
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
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.
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
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 ));
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 ));
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 );
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 ));
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 ));
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 );
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 );
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);
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);
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 ));
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 ));
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 );
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 ));
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 );
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 ));
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 ));
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 ));
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 ));
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 );
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));
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));
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;
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:
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;
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:
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:
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
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
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);
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);
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;
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;
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;
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:
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));
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);
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);
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;
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;
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:
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;