639:
640: BEGIN
641: IF PG_DEBUG in ('Y', 'C')
642: THEN
643: arp_debug.debug('arp_etax_util.synchronize_for_doc_seq()+');
644: arp_debug.debug(' p_sync_line_data = ' || p_sync_line_data);
645: END IF;
646:
647: l_sync_trx_rec.application_id := 222;
640: BEGIN
641: IF PG_DEBUG in ('Y', 'C')
642: THEN
643: arp_debug.debug('arp_etax_util.synchronize_for_doc_seq()+');
644: arp_debug.debug(' p_sync_line_data = ' || p_sync_line_data);
645: END IF;
646:
647: l_sync_trx_rec.application_id := 222;
648: l_sync_trx_rec.entity_code := 'TRANSACTIONS';
668: l_sync_trx_rec.trx_due_date;
669:
670: IF PG_DEBUG in ('Y', 'C')
671: THEN
672: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
673: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
669:
670: IF PG_DEBUG in ('Y', 'C')
671: THEN
672: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
673: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
670: IF PG_DEBUG in ('Y', 'C')
671: THEN
672: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
673: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
671: THEN
672: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
673: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
672: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
673: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
673: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
674: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
675: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
683: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
676: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
683: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
684: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
677: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
683: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
684: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
685: END IF;
678: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
683: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
684: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
685: END IF;
686:
679: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
683: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
684: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
685: END IF;
686:
687: /* 5748090 - preserve values in columns that are not
680: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
681: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
682: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
683: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
684: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
685: END IF;
686:
687: /* 5748090 - preserve values in columns that are not
688: directly used by AR */
778: l_sync_trx_rec.trx_due_date := trx.term_due_date;
779:
780: IF PG_DEBUG in ('Y', 'C')
781: THEN
782: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
783: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
779:
780: IF PG_DEBUG in ('Y', 'C')
781: THEN
782: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
783: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
780: IF PG_DEBUG in ('Y', 'C')
781: THEN
782: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
783: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
781: THEN
782: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
783: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
782: arp_debug.debug('event_class_code: '||l_sync_trx_rec.event_class_code);
783: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
783: arp_debug.debug('event_type_code: '||l_sync_trx_rec.event_type_code);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
784: arp_debug.debug('trx_id: '||l_sync_trx_rec.trx_id);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
785: arp_debug.debug('trx_number: '||l_sync_trx_rec.trx_number);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
793: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
786: arp_debug.debug('trx_description: '||l_sync_trx_rec.trx_description);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
793: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
794: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
787: arp_debug.debug('doc_seq_id: '||l_sync_trx_rec.doc_seq_id);
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
793: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
794: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
795: END IF;
788: arp_debug.debug('doc_seq_name: '||l_sync_trx_rec.doc_seq_name);
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
793: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
794: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
795: END IF;
796:
789: arp_debug.debug('doc_seq_value: '||l_sync_trx_rec.doc_seq_value);
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
793: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
794: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
795: END IF;
796:
797: /* Now call the API to synchronize the repository */
790: arp_debug.debug('batch_source_id: '||l_sync_trx_rec.batch_source_id);
791: arp_debug.debug('batch_source_name: '||l_sync_trx_rec.batch_source_name);
792: arp_debug.debug('trx_type_description: '||l_sync_trx_rec.trx_type_description);
793: arp_debug.debug('trx_communicated_date: '||l_sync_trx_rec.trx_communicated_date);
794: arp_debug.debug('trx_due_date: '||l_sync_trx_rec.trx_due_date);
795: END IF;
796:
797: /* Now call the API to synchronize the repository */
798: ZX_API_PUB.synchronize_tax_repository(
2193:
2194:
2195: BEGIN
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_debug.debug('arp_etax_debug.prorate_recoverable()+');
2198: arp_debug.debug(' p_adj_id = ' || p_adj_id);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2194:
2195: BEGIN
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_debug.debug('arp_etax_debug.prorate_recoverable()+');
2198: arp_debug.debug(' p_adj_id = ' || p_adj_id);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2195: BEGIN
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_debug.debug('arp_etax_debug.prorate_recoverable()+');
2198: arp_debug.debug(' p_adj_id = ' || p_adj_id);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2196: IF PG_DEBUG in ('Y', 'C') THEN
2197: arp_debug.debug('arp_etax_debug.prorate_recoverable()+');
2198: arp_debug.debug(' p_adj_id = ' || p_adj_id);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2197: arp_debug.debug('arp_etax_debug.prorate_recoverable()+');
2198: arp_debug.debug(' p_adj_id = ' || p_adj_id);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2198: arp_debug.debug(' p_adj_id = ' || p_adj_id);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2206: arp_debug.debug(' p_quote = ' || p_quote);
2199: arp_debug.debug(' p_target_id = ' || p_target_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2206: arp_debug.debug(' p_quote = ' || p_quote);
2207: arp_debug.debug(' p_ra_app_id = ' || p_ra_app_id);
2200: arp_debug.debug(' p_target_line_id = ' || p_target_line_id);
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2206: arp_debug.debug(' p_quote = ' || p_quote);
2207: arp_debug.debug(' p_ra_app_id = ' || p_ra_app_id);
2208: END IF;
2201: arp_debug.debug(' p_amount = ' || p_amount);
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2206: arp_debug.debug(' p_quote = ' || p_quote);
2207: arp_debug.debug(' p_ra_app_id = ' || p_ra_app_id);
2208: END IF;
2209:
2202: arp_debug.debug(' p_apply_date = ' || p_apply_date);
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2206: arp_debug.debug(' p_quote = ' || p_quote);
2207: arp_debug.debug(' p_ra_app_id = ' || p_ra_app_id);
2208: END IF;
2209:
2210: /* Set pg_so_org_id any time it is not set or
2203: arp_debug.debug(' p_mode = ' || p_mode);
2204: arp_debug.debug(' p_upd_adj_and_ps = ' || p_upd_adj_and_ps);
2205: arp_debug.debug(' p_gt_id = ' || p_gt_id);
2206: arp_debug.debug(' p_quote = ' || p_quote);
2207: arp_debug.debug(' p_ra_app_id = ' || p_ra_app_id);
2208: END IF;
2209:
2210: /* Set pg_so_org_id any time it is not set or
2211: any time the OU changes. This supports cases where
2262: FROM DUAL;
2263:
2264: IF PG_DEBUG IN ('Y','C')
2265: THEN
2266: arp_debug.debug('assigned p_ra_app_id = ' ||
2267: p_ra_app_id);
2268: END IF;
2269: ELSIF p_ra_app_id = -1
2270: THEN
2269: ELSIF p_ra_app_id = -1
2270: THEN
2271: /* we have a problem -- wrong prorate_recoverable routine
2272: was called and -1 was defaulted */
2273: arp_debug.debug('EXCEPTION: p_ra_app_id is -1 for a receipt');
2274: ELSE
2275: /* application_id passed in, don't change a thing */
2276: NULL;
2277: END IF;
2854: p_prorated_tax := p_prorated_tax + l_prorated_tax;
2855: p_prorated_line := p_prorated_line + l_prorated_line;
2856:
2857: IF PG_DEBUG in ('Y', 'C') THEN
2858: arp_debug.debug(c_tax_lines.adjusted_doc_line_id ||
2859: ' line=' || l_prorated_line ||
2860: ' tax=' || l_prorated_tax);
2861: END IF;
2862:
2863: END LOOP;
2864:
2865: IF l_lines_processed = FALSE
2866: THEN
2867: arp_debug.debug('initializing prorated_line to adj amt');
2868:
2869: /* initalize the outbound parameters as LINE=amt, TAX=0
2870: In a situation where etax does nothing, then we should
2871: act as if there was no tax in our proration logic. */
2876: END IF;
2877:
2878: IF PG_DEBUG in ('Y','C')
2879: THEN
2880: arp_debug.debug('returned values');
2881: arp_debug.debug(' p_prorated_line = ' || p_prorated_line);
2882: arp_debug.debug(' p_prorated_tax = ' || p_prorated_tax);
2883: END IF;
2884:
2877:
2878: IF PG_DEBUG in ('Y','C')
2879: THEN
2880: arp_debug.debug('returned values');
2881: arp_debug.debug(' p_prorated_line = ' || p_prorated_line);
2882: arp_debug.debug(' p_prorated_tax = ' || p_prorated_tax);
2883: END IF;
2884:
2885: ELSE
2878: IF PG_DEBUG in ('Y','C')
2879: THEN
2880: arp_debug.debug('returned values');
2881: arp_debug.debug(' p_prorated_line = ' || p_prorated_line);
2882: arp_debug.debug(' p_prorated_tax = ' || p_prorated_tax);
2883: END IF;
2884:
2885: ELSE
2886: /* When the API returns a failure, do something bad! */
2883: END IF;
2884:
2885: ELSE
2886: /* When the API returns a failure, do something bad! */
2887: arp_debug.debug('EXCEPTION: Unable to calculate tax ');
2888:
2889: p_prorated_tax := 0;
2890: RETURN;
2891: END IF;
2890: RETURN;
2891: END IF;
2892:
2893: IF PG_DEBUG in ('Y', 'C') THEN
2894: arp_debug.debug('arp_etax_util.prorate_recoverable()-');
2895: END IF;
2896:
2897: END prorate_recoverable;
2898:
3034: FOR trx IN c_trx(p_trx_id) LOOP
3035:
3036: IF PG_DEBUG IN ('C','Y')
3037: THEN
3038: arp_debug.debug(trx.customer_trx_line_id || ':' ||
3039: trx.inclusive_amount);
3040: END IF;
3041:
3042: arp_ctl_pkg.update_amount_f_ctl_id(
3073: FOR trx IN c_req(p_request_id) LOOP
3074:
3075: IF PG_DEBUG IN ('C','Y')
3076: THEN
3077: arp_debug.debug(trx.customer_trx_line_id || ':' ||
3078: trx.inclusive_amount);
3079: END IF;
3080:
3081: arp_ctl_pkg.update_amount_f_ctl_id(
3702: */
3703: BEGIN
3704: IF PG_DEBUG in ('Y', 'C')
3705: THEN
3706: arp_debug.debug('arp_etax_util.validate_for_tax()+');
3707: END IF;
3708:
3709:
3710: DELETE from ZX_TRX_HEADERS_GT zx
3720: AND trx.org_id = t.org_id);
3721:
3722:
3723: IF PG_DEBUG in ('Y', 'C') THEN
3724: arp_debug.debug('before calling etax bulk processing api ');
3725: END IF;
3726: zx_api_pub.validate_document_for_tax(
3727: p_api_version => 1.0,
3728: p_init_msg_list => FND_API.G_TRUE,
3731: x_return_status => l_return_status,
3732: x_msg_count => l_msg_count,
3733: x_msg_data => l_msg_data);
3734: IF PG_DEBUG in ('Y', 'C') THEN
3735: arp_debug.debug('after calling etax bulk processing api');
3736: END IF;
3737:
3738: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
3739: THEN
3739: THEN
3740: /* Retrieve and log errors */
3741: IF l_msg_count = 1
3742: THEN
3743: arp_debug.debug(l_msg_data);
3744: ELSIF l_msg_count > 1
3745: THEN
3746: LOOP
3747: l_msg := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,
3749: IF l_msg IS NULL
3750: THEN
3751: EXIT;
3752: ELSE
3753: arp_debug.debug(l_msg);
3754: END IF;
3755: END LOOP;
3756: END IF;
3757: END IF;
3757: END IF;
3758:
3759: IF PG_DEBUG in ('Y', 'C')
3760: THEN
3761: arp_debug.debug('arp_etax_util.validate_for_tax()-');
3762: END IF;
3763:
3764: END validate_for_tax;
3765: