12: | |
13: | SCOPE - PUBLIC |
14: | |
15: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
16: | arp_util.debug |
17: | arp_process_header.update_header |
18: | |
19: | ARGUMENTS : IN: |
20: | p_form_name |
387:
388: BEGIN
389:
390: IF PG_DEBUG in ('Y', 'C') THEN
391: arp_util.debug('arp_process_header_updte_cover.update_header_cover()+');
392: END IF;
393:
394: arp_ct_pkg.set_to_dummy(l_trx_rec);
395: arp_process_commitment.set_to_dummy(l_commit_rec);
542: l_commit_rec.default_ussgl_transaction_code := p_ctl_default_ussgl_trx_code;
543:
544:
545: IF PG_DEBUG in ('Y', 'C') THEN
546: arp_util.debug( 'p_customer_trx_id = ' ||
547: TO_CHAR(p_customer_trx_id ) );
548: arp_util.debug( 'p_trx_number = ' ||
549: p_trx_number );
550: arp_util.debug( 'p_trx_amount = ' ||
544:
545: IF PG_DEBUG in ('Y', 'C') THEN
546: arp_util.debug( 'p_customer_trx_id = ' ||
547: TO_CHAR(p_customer_trx_id ) );
548: arp_util.debug( 'p_trx_number = ' ||
549: p_trx_number );
550: arp_util.debug( 'p_trx_amount = ' ||
551: TO_CHAR(p_trx_amount ) );
552: arp_util.debug( 'p_open_rec_flag = '||
546: arp_util.debug( 'p_customer_trx_id = ' ||
547: TO_CHAR(p_customer_trx_id ) );
548: arp_util.debug( 'p_trx_number = ' ||
549: p_trx_number );
550: arp_util.debug( 'p_trx_amount = ' ||
551: TO_CHAR(p_trx_amount ) );
552: arp_util.debug( 'p_open_rec_flag = '||
553: p_open_rec_flag);
554: arp_util.debug( 'p_term_in_use_flag = '||
548: arp_util.debug( 'p_trx_number = ' ||
549: p_trx_number );
550: arp_util.debug( 'p_trx_amount = ' ||
551: TO_CHAR(p_trx_amount ) );
552: arp_util.debug( 'p_open_rec_flag = '||
553: p_open_rec_flag);
554: arp_util.debug( 'p_term_in_use_flag = '||
555: p_term_in_use_flag);
556: arp_util.debug( 'p_recalc_tax_flag = '||
550: arp_util.debug( 'p_trx_amount = ' ||
551: TO_CHAR(p_trx_amount ) );
552: arp_util.debug( 'p_open_rec_flag = '||
553: p_open_rec_flag);
554: arp_util.debug( 'p_term_in_use_flag = '||
555: p_term_in_use_flag);
556: arp_util.debug( 'p_recalc_tax_flag = '||
557: p_recalc_tax_flag);
558: arp_util.debug( 'p_rerun_autoacc_flag = '||
552: arp_util.debug( 'p_open_rec_flag = '||
553: p_open_rec_flag);
554: arp_util.debug( 'p_term_in_use_flag = '||
555: p_term_in_use_flag);
556: arp_util.debug( 'p_recalc_tax_flag = '||
557: p_recalc_tax_flag);
558: arp_util.debug( 'p_rerun_autoacc_flag = '||
559: p_rerun_autoacc_flag);
560: arp_util.debug( 'p_posting_control_id = ' ||
554: arp_util.debug( 'p_term_in_use_flag = '||
555: p_term_in_use_flag);
556: arp_util.debug( 'p_recalc_tax_flag = '||
557: p_recalc_tax_flag);
558: arp_util.debug( 'p_rerun_autoacc_flag = '||
559: p_rerun_autoacc_flag);
560: arp_util.debug( 'p_posting_control_id = ' ||
561: TO_CHAR(p_posting_control_id ) );
562: arp_util.debug( 'p_ra_post_loop_number = ' ||
556: arp_util.debug( 'p_recalc_tax_flag = '||
557: p_recalc_tax_flag);
558: arp_util.debug( 'p_rerun_autoacc_flag = '||
559: p_rerun_autoacc_flag);
560: arp_util.debug( 'p_posting_control_id = ' ||
561: TO_CHAR(p_posting_control_id ) );
562: arp_util.debug( 'p_ra_post_loop_number = ' ||
563: p_ra_post_loop_number );
564: arp_util.debug( 'p_complete_flag = ' ||
558: arp_util.debug( 'p_rerun_autoacc_flag = '||
559: p_rerun_autoacc_flag);
560: arp_util.debug( 'p_posting_control_id = ' ||
561: TO_CHAR(p_posting_control_id ) );
562: arp_util.debug( 'p_ra_post_loop_number = ' ||
563: p_ra_post_loop_number );
564: arp_util.debug( 'p_complete_flag = ' ||
565: p_complete_flag );
566: arp_util.debug( 'p_initial_customer_trx_id = ' ||
560: arp_util.debug( 'p_posting_control_id = ' ||
561: TO_CHAR(p_posting_control_id ) );
562: arp_util.debug( 'p_ra_post_loop_number = ' ||
563: p_ra_post_loop_number );
564: arp_util.debug( 'p_complete_flag = ' ||
565: p_complete_flag );
566: arp_util.debug( 'p_initial_customer_trx_id = ' ||
567: TO_CHAR(p_initial_customer_trx_id ) );
568: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
562: arp_util.debug( 'p_ra_post_loop_number = ' ||
563: p_ra_post_loop_number );
564: arp_util.debug( 'p_complete_flag = ' ||
565: p_complete_flag );
566: arp_util.debug( 'p_initial_customer_trx_id = ' ||
567: TO_CHAR(p_initial_customer_trx_id ) );
568: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
569: TO_CHAR(p_initial_customer_trx_line_id ) );
570: arp_util.debug( 'p_previous_customer_trx_id = ' ||
564: arp_util.debug( 'p_complete_flag = ' ||
565: p_complete_flag );
566: arp_util.debug( 'p_initial_customer_trx_id = ' ||
567: TO_CHAR(p_initial_customer_trx_id ) );
568: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
569: TO_CHAR(p_initial_customer_trx_line_id ) );
570: arp_util.debug( 'p_previous_customer_trx_id = ' ||
571: TO_CHAR(p_previous_customer_trx_id ) );
572: arp_util.debug( 'p_related_customer_trx_id = ' ||
566: arp_util.debug( 'p_initial_customer_trx_id = ' ||
567: TO_CHAR(p_initial_customer_trx_id ) );
568: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
569: TO_CHAR(p_initial_customer_trx_line_id ) );
570: arp_util.debug( 'p_previous_customer_trx_id = ' ||
571: TO_CHAR(p_previous_customer_trx_id ) );
572: arp_util.debug( 'p_related_customer_trx_id = ' ||
573: TO_CHAR(p_related_customer_trx_id ) );
574: arp_util.debug( 'p_recurred_from_trx_number = ' ||
568: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
569: TO_CHAR(p_initial_customer_trx_line_id ) );
570: arp_util.debug( 'p_previous_customer_trx_id = ' ||
571: TO_CHAR(p_previous_customer_trx_id ) );
572: arp_util.debug( 'p_related_customer_trx_id = ' ||
573: TO_CHAR(p_related_customer_trx_id ) );
574: arp_util.debug( 'p_recurred_from_trx_number = ' ||
575: p_recurred_from_trx_number );
576: arp_util.debug( 'p_cust_trx_type_id = ' ||
570: arp_util.debug( 'p_previous_customer_trx_id = ' ||
571: TO_CHAR(p_previous_customer_trx_id ) );
572: arp_util.debug( 'p_related_customer_trx_id = ' ||
573: TO_CHAR(p_related_customer_trx_id ) );
574: arp_util.debug( 'p_recurred_from_trx_number = ' ||
575: p_recurred_from_trx_number );
576: arp_util.debug( 'p_cust_trx_type_id = ' ||
577: TO_CHAR(p_cust_trx_type_id ) );
578: arp_util.debug( 'p_batch_id = ' ||
572: arp_util.debug( 'p_related_customer_trx_id = ' ||
573: TO_CHAR(p_related_customer_trx_id ) );
574: arp_util.debug( 'p_recurred_from_trx_number = ' ||
575: p_recurred_from_trx_number );
576: arp_util.debug( 'p_cust_trx_type_id = ' ||
577: TO_CHAR(p_cust_trx_type_id ) );
578: arp_util.debug( 'p_batch_id = ' ||
579: TO_CHAR(p_batch_id ) );
580: arp_util.debug( 'p_batch_source_id = ' ||
574: arp_util.debug( 'p_recurred_from_trx_number = ' ||
575: p_recurred_from_trx_number );
576: arp_util.debug( 'p_cust_trx_type_id = ' ||
577: TO_CHAR(p_cust_trx_type_id ) );
578: arp_util.debug( 'p_batch_id = ' ||
579: TO_CHAR(p_batch_id ) );
580: arp_util.debug( 'p_batch_source_id = ' ||
581: TO_CHAR(p_batch_source_id ) );
582: arp_util.debug( 'p_agreement_id = ' ||
576: arp_util.debug( 'p_cust_trx_type_id = ' ||
577: TO_CHAR(p_cust_trx_type_id ) );
578: arp_util.debug( 'p_batch_id = ' ||
579: TO_CHAR(p_batch_id ) );
580: arp_util.debug( 'p_batch_source_id = ' ||
581: TO_CHAR(p_batch_source_id ) );
582: arp_util.debug( 'p_agreement_id = ' ||
583: TO_CHAR(p_agreement_id ) );
584: arp_util.debug( 'p_trx_date = ' ||
578: arp_util.debug( 'p_batch_id = ' ||
579: TO_CHAR(p_batch_id ) );
580: arp_util.debug( 'p_batch_source_id = ' ||
581: TO_CHAR(p_batch_source_id ) );
582: arp_util.debug( 'p_agreement_id = ' ||
583: TO_CHAR(p_agreement_id ) );
584: arp_util.debug( 'p_trx_date = ' ||
585: p_trx_date );
586: arp_util.debug( 'p_bill_to_customer_id = ' ||
580: arp_util.debug( 'p_batch_source_id = ' ||
581: TO_CHAR(p_batch_source_id ) );
582: arp_util.debug( 'p_agreement_id = ' ||
583: TO_CHAR(p_agreement_id ) );
584: arp_util.debug( 'p_trx_date = ' ||
585: p_trx_date );
586: arp_util.debug( 'p_bill_to_customer_id = ' ||
587: TO_CHAR(p_bill_to_customer_id ) );
588: arp_util.debug( 'p_bill_to_contact_id = ' ||
582: arp_util.debug( 'p_agreement_id = ' ||
583: TO_CHAR(p_agreement_id ) );
584: arp_util.debug( 'p_trx_date = ' ||
585: p_trx_date );
586: arp_util.debug( 'p_bill_to_customer_id = ' ||
587: TO_CHAR(p_bill_to_customer_id ) );
588: arp_util.debug( 'p_bill_to_contact_id = ' ||
589: TO_CHAR(p_bill_to_contact_id ) );
590: arp_util.debug( 'p_bill_to_site_use_id = ' ||
584: arp_util.debug( 'p_trx_date = ' ||
585: p_trx_date );
586: arp_util.debug( 'p_bill_to_customer_id = ' ||
587: TO_CHAR(p_bill_to_customer_id ) );
588: arp_util.debug( 'p_bill_to_contact_id = ' ||
589: TO_CHAR(p_bill_to_contact_id ) );
590: arp_util.debug( 'p_bill_to_site_use_id = ' ||
591: TO_CHAR(p_bill_to_site_use_id ) );
592: arp_util.debug( 'p_ship_to_customer_id = ' ||
586: arp_util.debug( 'p_bill_to_customer_id = ' ||
587: TO_CHAR(p_bill_to_customer_id ) );
588: arp_util.debug( 'p_bill_to_contact_id = ' ||
589: TO_CHAR(p_bill_to_contact_id ) );
590: arp_util.debug( 'p_bill_to_site_use_id = ' ||
591: TO_CHAR(p_bill_to_site_use_id ) );
592: arp_util.debug( 'p_ship_to_customer_id = ' ||
593: TO_CHAR(p_ship_to_customer_id ) );
594: arp_util.debug( 'p_ship_to_contact_id = ' ||
588: arp_util.debug( 'p_bill_to_contact_id = ' ||
589: TO_CHAR(p_bill_to_contact_id ) );
590: arp_util.debug( 'p_bill_to_site_use_id = ' ||
591: TO_CHAR(p_bill_to_site_use_id ) );
592: arp_util.debug( 'p_ship_to_customer_id = ' ||
593: TO_CHAR(p_ship_to_customer_id ) );
594: arp_util.debug( 'p_ship_to_contact_id = ' ||
595: TO_CHAR(p_ship_to_contact_id ) );
596: arp_util.debug( 'p_ship_to_site_use_id = ' ||
590: arp_util.debug( 'p_bill_to_site_use_id = ' ||
591: TO_CHAR(p_bill_to_site_use_id ) );
592: arp_util.debug( 'p_ship_to_customer_id = ' ||
593: TO_CHAR(p_ship_to_customer_id ) );
594: arp_util.debug( 'p_ship_to_contact_id = ' ||
595: TO_CHAR(p_ship_to_contact_id ) );
596: arp_util.debug( 'p_ship_to_site_use_id = ' ||
597: TO_CHAR(p_ship_to_site_use_id ) );
598: arp_util.debug( 'p_sold_to_customer_id = ' ||
592: arp_util.debug( 'p_ship_to_customer_id = ' ||
593: TO_CHAR(p_ship_to_customer_id ) );
594: arp_util.debug( 'p_ship_to_contact_id = ' ||
595: TO_CHAR(p_ship_to_contact_id ) );
596: arp_util.debug( 'p_ship_to_site_use_id = ' ||
597: TO_CHAR(p_ship_to_site_use_id ) );
598: arp_util.debug( 'p_sold_to_customer_id = ' ||
599: TO_CHAR(p_sold_to_customer_id ) );
600: arp_util.debug( 'p_sold_to_site_use_id = ' ||
594: arp_util.debug( 'p_ship_to_contact_id = ' ||
595: TO_CHAR(p_ship_to_contact_id ) );
596: arp_util.debug( 'p_ship_to_site_use_id = ' ||
597: TO_CHAR(p_ship_to_site_use_id ) );
598: arp_util.debug( 'p_sold_to_customer_id = ' ||
599: TO_CHAR(p_sold_to_customer_id ) );
600: arp_util.debug( 'p_sold_to_site_use_id = ' ||
601: TO_CHAR(p_sold_to_site_use_id ) );
602: arp_util.debug( 'p_sold_to_contact_id = ' ||
596: arp_util.debug( 'p_ship_to_site_use_id = ' ||
597: TO_CHAR(p_ship_to_site_use_id ) );
598: arp_util.debug( 'p_sold_to_customer_id = ' ||
599: TO_CHAR(p_sold_to_customer_id ) );
600: arp_util.debug( 'p_sold_to_site_use_id = ' ||
601: TO_CHAR(p_sold_to_site_use_id ) );
602: arp_util.debug( 'p_sold_to_contact_id = ' ||
603: TO_CHAR(p_sold_to_contact_id ) );
604: arp_util.debug( 'p_customer_reference = ' ||
598: arp_util.debug( 'p_sold_to_customer_id = ' ||
599: TO_CHAR(p_sold_to_customer_id ) );
600: arp_util.debug( 'p_sold_to_site_use_id = ' ||
601: TO_CHAR(p_sold_to_site_use_id ) );
602: arp_util.debug( 'p_sold_to_contact_id = ' ||
603: TO_CHAR(p_sold_to_contact_id ) );
604: arp_util.debug( 'p_customer_reference = ' ||
605: p_customer_reference );
606: arp_util.debug( 'p_customer_reference_date = ' ||
600: arp_util.debug( 'p_sold_to_site_use_id = ' ||
601: TO_CHAR(p_sold_to_site_use_id ) );
602: arp_util.debug( 'p_sold_to_contact_id = ' ||
603: TO_CHAR(p_sold_to_contact_id ) );
604: arp_util.debug( 'p_customer_reference = ' ||
605: p_customer_reference );
606: arp_util.debug( 'p_customer_reference_date = ' ||
607: p_customer_reference_date );
608: arp_util.debug( 'p_cr_method_for_installments = ' ||
602: arp_util.debug( 'p_sold_to_contact_id = ' ||
603: TO_CHAR(p_sold_to_contact_id ) );
604: arp_util.debug( 'p_customer_reference = ' ||
605: p_customer_reference );
606: arp_util.debug( 'p_customer_reference_date = ' ||
607: p_customer_reference_date );
608: arp_util.debug( 'p_cr_method_for_installments = ' ||
609: p_cr_method_for_installments );
610: arp_util.debug( 'p_credit_method_for_rules = ' ||
604: arp_util.debug( 'p_customer_reference = ' ||
605: p_customer_reference );
606: arp_util.debug( 'p_customer_reference_date = ' ||
607: p_customer_reference_date );
608: arp_util.debug( 'p_cr_method_for_installments = ' ||
609: p_cr_method_for_installments );
610: arp_util.debug( 'p_credit_method_for_rules = ' ||
611: p_credit_method_for_rules );
612: arp_util.debug( 'p_start_date_commitment = ' ||
606: arp_util.debug( 'p_customer_reference_date = ' ||
607: p_customer_reference_date );
608: arp_util.debug( 'p_cr_method_for_installments = ' ||
609: p_cr_method_for_installments );
610: arp_util.debug( 'p_credit_method_for_rules = ' ||
611: p_credit_method_for_rules );
612: arp_util.debug( 'p_start_date_commitment = ' ||
613: p_start_date_commitment );
614: arp_util.debug( 'p_end_date_commitment = ' ||
608: arp_util.debug( 'p_cr_method_for_installments = ' ||
609: p_cr_method_for_installments );
610: arp_util.debug( 'p_credit_method_for_rules = ' ||
611: p_credit_method_for_rules );
612: arp_util.debug( 'p_start_date_commitment = ' ||
613: p_start_date_commitment );
614: arp_util.debug( 'p_end_date_commitment = ' ||
615: p_end_date_commitment );
616: arp_util.debug( 'p_exchange_date = ' ||
610: arp_util.debug( 'p_credit_method_for_rules = ' ||
611: p_credit_method_for_rules );
612: arp_util.debug( 'p_start_date_commitment = ' ||
613: p_start_date_commitment );
614: arp_util.debug( 'p_end_date_commitment = ' ||
615: p_end_date_commitment );
616: arp_util.debug( 'p_exchange_date = ' ||
617: p_exchange_date );
618: arp_util.debug( 'p_exchange_rate = ' ||
612: arp_util.debug( 'p_start_date_commitment = ' ||
613: p_start_date_commitment );
614: arp_util.debug( 'p_end_date_commitment = ' ||
615: p_end_date_commitment );
616: arp_util.debug( 'p_exchange_date = ' ||
617: p_exchange_date );
618: arp_util.debug( 'p_exchange_rate = ' ||
619: p_exchange_rate );
620: arp_util.debug( 'p_exchange_rate_type = ' ||
614: arp_util.debug( 'p_end_date_commitment = ' ||
615: p_end_date_commitment );
616: arp_util.debug( 'p_exchange_date = ' ||
617: p_exchange_date );
618: arp_util.debug( 'p_exchange_rate = ' ||
619: p_exchange_rate );
620: arp_util.debug( 'p_exchange_rate_type = ' ||
621: p_exchange_rate_type );
622: arp_util.debug( 'p_customer_bank_account_id = ' ||
616: arp_util.debug( 'p_exchange_date = ' ||
617: p_exchange_date );
618: arp_util.debug( 'p_exchange_rate = ' ||
619: p_exchange_rate );
620: arp_util.debug( 'p_exchange_rate_type = ' ||
621: p_exchange_rate_type );
622: arp_util.debug( 'p_customer_bank_account_id = ' ||
623: p_customer_bank_account_id );
624: arp_util.debug( 'p_finance_charges = ' ||
618: arp_util.debug( 'p_exchange_rate = ' ||
619: p_exchange_rate );
620: arp_util.debug( 'p_exchange_rate_type = ' ||
621: p_exchange_rate_type );
622: arp_util.debug( 'p_customer_bank_account_id = ' ||
623: p_customer_bank_account_id );
624: arp_util.debug( 'p_finance_charges = ' ||
625: p_finance_charges );
626: arp_util.debug( 'p_fob_point = ' ||
620: arp_util.debug( 'p_exchange_rate_type = ' ||
621: p_exchange_rate_type );
622: arp_util.debug( 'p_customer_bank_account_id = ' ||
623: p_customer_bank_account_id );
624: arp_util.debug( 'p_finance_charges = ' ||
625: p_finance_charges );
626: arp_util.debug( 'p_fob_point = ' ||
627: p_fob_point );
628: arp_util.debug( 'p_comments = ' ||
622: arp_util.debug( 'p_customer_bank_account_id = ' ||
623: p_customer_bank_account_id );
624: arp_util.debug( 'p_finance_charges = ' ||
625: p_finance_charges );
626: arp_util.debug( 'p_fob_point = ' ||
627: p_fob_point );
628: arp_util.debug( 'p_comments = ' ||
629: p_comments );
630: arp_util.debug( 'p_internal_notes = ' ||
624: arp_util.debug( 'p_finance_charges = ' ||
625: p_finance_charges );
626: arp_util.debug( 'p_fob_point = ' ||
627: p_fob_point );
628: arp_util.debug( 'p_comments = ' ||
629: p_comments );
630: arp_util.debug( 'p_internal_notes = ' ||
631: p_internal_notes );
632: arp_util.debug( 'p_invoice_currency_code = ' ||
626: arp_util.debug( 'p_fob_point = ' ||
627: p_fob_point );
628: arp_util.debug( 'p_comments = ' ||
629: p_comments );
630: arp_util.debug( 'p_internal_notes = ' ||
631: p_internal_notes );
632: arp_util.debug( 'p_invoice_currency_code = ' ||
633: p_invoice_currency_code );
634: arp_util.debug( 'p_invoicing_rule_id = ' ||
628: arp_util.debug( 'p_comments = ' ||
629: p_comments );
630: arp_util.debug( 'p_internal_notes = ' ||
631: p_internal_notes );
632: arp_util.debug( 'p_invoice_currency_code = ' ||
633: p_invoice_currency_code );
634: arp_util.debug( 'p_invoicing_rule_id = ' ||
635: TO_CHAR(p_invoicing_rule_id ) );
636: arp_util.debug( 'p_last_printed_sequence_num = ' ||
630: arp_util.debug( 'p_internal_notes = ' ||
631: p_internal_notes );
632: arp_util.debug( 'p_invoice_currency_code = ' ||
633: p_invoice_currency_code );
634: arp_util.debug( 'p_invoicing_rule_id = ' ||
635: TO_CHAR(p_invoicing_rule_id ) );
636: arp_util.debug( 'p_last_printed_sequence_num = ' ||
637: p_last_printed_sequence_num );
638: arp_util.debug( 'p_orig_system_batch_name = ' ||
632: arp_util.debug( 'p_invoice_currency_code = ' ||
633: p_invoice_currency_code );
634: arp_util.debug( 'p_invoicing_rule_id = ' ||
635: TO_CHAR(p_invoicing_rule_id ) );
636: arp_util.debug( 'p_last_printed_sequence_num = ' ||
637: p_last_printed_sequence_num );
638: arp_util.debug( 'p_orig_system_batch_name = ' ||
639: p_orig_system_batch_name );
640: arp_util.debug( 'p_primary_salesrep_id = ' ||
634: arp_util.debug( 'p_invoicing_rule_id = ' ||
635: TO_CHAR(p_invoicing_rule_id ) );
636: arp_util.debug( 'p_last_printed_sequence_num = ' ||
637: p_last_printed_sequence_num );
638: arp_util.debug( 'p_orig_system_batch_name = ' ||
639: p_orig_system_batch_name );
640: arp_util.debug( 'p_primary_salesrep_id = ' ||
641: TO_CHAR(p_primary_salesrep_id ) );
642: arp_util.debug( 'p_printing_count = ' ||
636: arp_util.debug( 'p_last_printed_sequence_num = ' ||
637: p_last_printed_sequence_num );
638: arp_util.debug( 'p_orig_system_batch_name = ' ||
639: p_orig_system_batch_name );
640: arp_util.debug( 'p_primary_salesrep_id = ' ||
641: TO_CHAR(p_primary_salesrep_id ) );
642: arp_util.debug( 'p_printing_count = ' ||
643: p_printing_count );
644: arp_util.debug( 'p_printing_last_printed = ' ||
638: arp_util.debug( 'p_orig_system_batch_name = ' ||
639: p_orig_system_batch_name );
640: arp_util.debug( 'p_primary_salesrep_id = ' ||
641: TO_CHAR(p_primary_salesrep_id ) );
642: arp_util.debug( 'p_printing_count = ' ||
643: p_printing_count );
644: arp_util.debug( 'p_printing_last_printed = ' ||
645: p_printing_last_printed );
646: arp_util.debug( 'p_printing_option = ' ||
640: arp_util.debug( 'p_primary_salesrep_id = ' ||
641: TO_CHAR(p_primary_salesrep_id ) );
642: arp_util.debug( 'p_printing_count = ' ||
643: p_printing_count );
644: arp_util.debug( 'p_printing_last_printed = ' ||
645: p_printing_last_printed );
646: arp_util.debug( 'p_printing_option = ' ||
647: p_printing_option );
648: arp_util.debug( 'p_printing_original_date = ' ||
642: arp_util.debug( 'p_printing_count = ' ||
643: p_printing_count );
644: arp_util.debug( 'p_printing_last_printed = ' ||
645: p_printing_last_printed );
646: arp_util.debug( 'p_printing_option = ' ||
647: p_printing_option );
648: arp_util.debug( 'p_printing_original_date = ' ||
649: p_printing_original_date );
650: arp_util.debug( 'p_printing_pending = ' ||
644: arp_util.debug( 'p_printing_last_printed = ' ||
645: p_printing_last_printed );
646: arp_util.debug( 'p_printing_option = ' ||
647: p_printing_option );
648: arp_util.debug( 'p_printing_original_date = ' ||
649: p_printing_original_date );
650: arp_util.debug( 'p_printing_pending = ' ||
651: p_printing_pending );
652: arp_util.debug( 'p_purchase_order = ' ||
646: arp_util.debug( 'p_printing_option = ' ||
647: p_printing_option );
648: arp_util.debug( 'p_printing_original_date = ' ||
649: p_printing_original_date );
650: arp_util.debug( 'p_printing_pending = ' ||
651: p_printing_pending );
652: arp_util.debug( 'p_purchase_order = ' ||
653: p_purchase_order );
654: arp_util.debug( 'p_purchase_order_date = ' ||
648: arp_util.debug( 'p_printing_original_date = ' ||
649: p_printing_original_date );
650: arp_util.debug( 'p_printing_pending = ' ||
651: p_printing_pending );
652: arp_util.debug( 'p_purchase_order = ' ||
653: p_purchase_order );
654: arp_util.debug( 'p_purchase_order_date = ' ||
655: p_purchase_order_date );
656: arp_util.debug( 'p_purchase_order_revision = ' ||
650: arp_util.debug( 'p_printing_pending = ' ||
651: p_printing_pending );
652: arp_util.debug( 'p_purchase_order = ' ||
653: p_purchase_order );
654: arp_util.debug( 'p_purchase_order_date = ' ||
655: p_purchase_order_date );
656: arp_util.debug( 'p_purchase_order_revision = ' ||
657: p_purchase_order_revision );
658: arp_util.debug( 'p_receipt_method_id = ' ||
652: arp_util.debug( 'p_purchase_order = ' ||
653: p_purchase_order );
654: arp_util.debug( 'p_purchase_order_date = ' ||
655: p_purchase_order_date );
656: arp_util.debug( 'p_purchase_order_revision = ' ||
657: p_purchase_order_revision );
658: arp_util.debug( 'p_receipt_method_id = ' ||
659: TO_CHAR(p_receipt_method_id ) );
660: arp_util.debug( 'p_remit_to_address_id = ' ||
654: arp_util.debug( 'p_purchase_order_date = ' ||
655: p_purchase_order_date );
656: arp_util.debug( 'p_purchase_order_revision = ' ||
657: p_purchase_order_revision );
658: arp_util.debug( 'p_receipt_method_id = ' ||
659: TO_CHAR(p_receipt_method_id ) );
660: arp_util.debug( 'p_remit_to_address_id = ' ||
661: TO_CHAR(p_remit_to_address_id ) );
662: arp_util.debug( 'p_shipment_id = ' ||
656: arp_util.debug( 'p_purchase_order_revision = ' ||
657: p_purchase_order_revision );
658: arp_util.debug( 'p_receipt_method_id = ' ||
659: TO_CHAR(p_receipt_method_id ) );
660: arp_util.debug( 'p_remit_to_address_id = ' ||
661: TO_CHAR(p_remit_to_address_id ) );
662: arp_util.debug( 'p_shipment_id = ' ||
663: TO_CHAR(p_shipment_id ) );
664: arp_util.debug( 'p_ship_date_actual = ' ||
658: arp_util.debug( 'p_receipt_method_id = ' ||
659: TO_CHAR(p_receipt_method_id ) );
660: arp_util.debug( 'p_remit_to_address_id = ' ||
661: TO_CHAR(p_remit_to_address_id ) );
662: arp_util.debug( 'p_shipment_id = ' ||
663: TO_CHAR(p_shipment_id ) );
664: arp_util.debug( 'p_ship_date_actual = ' ||
665: p_ship_date_actual );
666: arp_util.debug( 'p_ship_via = ' ||
660: arp_util.debug( 'p_remit_to_address_id = ' ||
661: TO_CHAR(p_remit_to_address_id ) );
662: arp_util.debug( 'p_shipment_id = ' ||
663: TO_CHAR(p_shipment_id ) );
664: arp_util.debug( 'p_ship_date_actual = ' ||
665: p_ship_date_actual );
666: arp_util.debug( 'p_ship_via = ' ||
667: p_ship_via );
668: arp_util.debug( 'p_term_due_date = ' ||
662: arp_util.debug( 'p_shipment_id = ' ||
663: TO_CHAR(p_shipment_id ) );
664: arp_util.debug( 'p_ship_date_actual = ' ||
665: p_ship_date_actual );
666: arp_util.debug( 'p_ship_via = ' ||
667: p_ship_via );
668: arp_util.debug( 'p_term_due_date = ' ||
669: p_term_due_date );
670: arp_util.debug( 'p_term_id = ' ||
664: arp_util.debug( 'p_ship_date_actual = ' ||
665: p_ship_date_actual );
666: arp_util.debug( 'p_ship_via = ' ||
667: p_ship_via );
668: arp_util.debug( 'p_term_due_date = ' ||
669: p_term_due_date );
670: arp_util.debug( 'p_term_id = ' ||
671: TO_CHAR(p_term_id ) );
672: arp_util.debug( 'p_territory_id = ' ||
666: arp_util.debug( 'p_ship_via = ' ||
667: p_ship_via );
668: arp_util.debug( 'p_term_due_date = ' ||
669: p_term_due_date );
670: arp_util.debug( 'p_term_id = ' ||
671: TO_CHAR(p_term_id ) );
672: arp_util.debug( 'p_territory_id = ' ||
673: p_territory_id );
674: arp_util.debug( 'p_waybill_number = ' ||
668: arp_util.debug( 'p_term_due_date = ' ||
669: p_term_due_date );
670: arp_util.debug( 'p_term_id = ' ||
671: TO_CHAR(p_term_id ) );
672: arp_util.debug( 'p_territory_id = ' ||
673: p_territory_id );
674: arp_util.debug( 'p_waybill_number = ' ||
675: p_waybill_number );
676: arp_util.debug( 'p_status_trx = ' ||
670: arp_util.debug( 'p_term_id = ' ||
671: TO_CHAR(p_term_id ) );
672: arp_util.debug( 'p_territory_id = ' ||
673: p_territory_id );
674: arp_util.debug( 'p_waybill_number = ' ||
675: p_waybill_number );
676: arp_util.debug( 'p_status_trx = ' ||
677: p_status_trx );
678: arp_util.debug( 'p_reason_code = ' ||
672: arp_util.debug( 'p_territory_id = ' ||
673: p_territory_id );
674: arp_util.debug( 'p_waybill_number = ' ||
675: p_waybill_number );
676: arp_util.debug( 'p_status_trx = ' ||
677: p_status_trx );
678: arp_util.debug( 'p_reason_code = ' ||
679: p_reason_code );
680: arp_util.debug( 'p_doc_sequence_id = ' ||
674: arp_util.debug( 'p_waybill_number = ' ||
675: p_waybill_number );
676: arp_util.debug( 'p_status_trx = ' ||
677: p_status_trx );
678: arp_util.debug( 'p_reason_code = ' ||
679: p_reason_code );
680: arp_util.debug( 'p_doc_sequence_id = ' ||
681: p_doc_sequence_id );
682: arp_util.debug( 'p_doc_sequence_value = ' ||
676: arp_util.debug( 'p_status_trx = ' ||
677: p_status_trx );
678: arp_util.debug( 'p_reason_code = ' ||
679: p_reason_code );
680: arp_util.debug( 'p_doc_sequence_id = ' ||
681: p_doc_sequence_id );
682: arp_util.debug( 'p_doc_sequence_value = ' ||
683: p_doc_sequence_value );
684: arp_util.debug( 'p_paying_customer_id = ' ||
678: arp_util.debug( 'p_reason_code = ' ||
679: p_reason_code );
680: arp_util.debug( 'p_doc_sequence_id = ' ||
681: p_doc_sequence_id );
682: arp_util.debug( 'p_doc_sequence_value = ' ||
683: p_doc_sequence_value );
684: arp_util.debug( 'p_paying_customer_id = ' ||
685: TO_CHAR(p_paying_customer_id ) );
686: arp_util.debug( 'p_paying_site_use_id = ' ||
680: arp_util.debug( 'p_doc_sequence_id = ' ||
681: p_doc_sequence_id );
682: arp_util.debug( 'p_doc_sequence_value = ' ||
683: p_doc_sequence_value );
684: arp_util.debug( 'p_paying_customer_id = ' ||
685: TO_CHAR(p_paying_customer_id ) );
686: arp_util.debug( 'p_paying_site_use_id = ' ||
687: TO_CHAR(p_paying_site_use_id ) );
688: arp_util.debug( 'p_related_batch_source_id = ' ||
682: arp_util.debug( 'p_doc_sequence_value = ' ||
683: p_doc_sequence_value );
684: arp_util.debug( 'p_paying_customer_id = ' ||
685: TO_CHAR(p_paying_customer_id ) );
686: arp_util.debug( 'p_paying_site_use_id = ' ||
687: TO_CHAR(p_paying_site_use_id ) );
688: arp_util.debug( 'p_related_batch_source_id = ' ||
689: p_related_batch_source_id );
690: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
684: arp_util.debug( 'p_paying_customer_id = ' ||
685: TO_CHAR(p_paying_customer_id ) );
686: arp_util.debug( 'p_paying_site_use_id = ' ||
687: TO_CHAR(p_paying_site_use_id ) );
688: arp_util.debug( 'p_related_batch_source_id = ' ||
689: p_related_batch_source_id );
690: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
691: p_default_tax_exempt_flag );
692: arp_util.debug( 'p_created_from = ' ||
686: arp_util.debug( 'p_paying_site_use_id = ' ||
687: TO_CHAR(p_paying_site_use_id ) );
688: arp_util.debug( 'p_related_batch_source_id = ' ||
689: p_related_batch_source_id );
690: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
691: p_default_tax_exempt_flag );
692: arp_util.debug( 'p_created_from = ' ||
693: p_created_from );
694: arp_util.debug( 'p_ps_dispute_amount = ' ||
688: arp_util.debug( 'p_related_batch_source_id = ' ||
689: p_related_batch_source_id );
690: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
691: p_default_tax_exempt_flag );
692: arp_util.debug( 'p_created_from = ' ||
693: p_created_from );
694: arp_util.debug( 'p_ps_dispute_amount = ' ||
695: p_ps_dispute_amount );
696: arp_util.debug( 'p_ps_dispute_date = ' ||
690: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
691: p_default_tax_exempt_flag );
692: arp_util.debug( 'p_created_from = ' ||
693: p_created_from );
694: arp_util.debug( 'p_ps_dispute_amount = ' ||
695: p_ps_dispute_amount );
696: arp_util.debug( 'p_ps_dispute_date = ' ||
697: p_ps_dispute_date );
698: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
692: arp_util.debug( 'p_created_from = ' ||
693: p_created_from );
694: arp_util.debug( 'p_ps_dispute_amount = ' ||
695: p_ps_dispute_amount );
696: arp_util.debug( 'p_ps_dispute_date = ' ||
697: p_ps_dispute_date );
698: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
699: p_deflt_ussgl_trx_code_context );
700: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
694: arp_util.debug( 'p_ps_dispute_amount = ' ||
695: p_ps_dispute_amount );
696: arp_util.debug( 'p_ps_dispute_date = ' ||
697: p_ps_dispute_date );
698: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
699: p_deflt_ussgl_trx_code_context );
700: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
701: p_deflt_ussgl_transaction_code );
702: arp_util.debug( 'p_old_trx_number = ' ||
696: arp_util.debug( 'p_ps_dispute_date = ' ||
697: p_ps_dispute_date );
698: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
699: p_deflt_ussgl_trx_code_context );
700: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
701: p_deflt_ussgl_transaction_code );
702: arp_util.debug( 'p_old_trx_number = ' ||
703: p_old_trx_number );
704: arp_util.debug( 'p_interface_header_context = ' ||
698: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
699: p_deflt_ussgl_trx_code_context );
700: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
701: p_deflt_ussgl_transaction_code );
702: arp_util.debug( 'p_old_trx_number = ' ||
703: p_old_trx_number );
704: arp_util.debug( 'p_interface_header_context = ' ||
705: p_interface_header_context );
706: arp_util.debug( 'p_interface_header_attribute1 = ' ||
700: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
701: p_deflt_ussgl_transaction_code );
702: arp_util.debug( 'p_old_trx_number = ' ||
703: p_old_trx_number );
704: arp_util.debug( 'p_interface_header_context = ' ||
705: p_interface_header_context );
706: arp_util.debug( 'p_interface_header_attribute1 = ' ||
707: p_interface_header_attribute1 );
708: arp_util.debug( 'p_interface_header_attribute2 = ' ||
702: arp_util.debug( 'p_old_trx_number = ' ||
703: p_old_trx_number );
704: arp_util.debug( 'p_interface_header_context = ' ||
705: p_interface_header_context );
706: arp_util.debug( 'p_interface_header_attribute1 = ' ||
707: p_interface_header_attribute1 );
708: arp_util.debug( 'p_interface_header_attribute2 = ' ||
709: p_interface_header_attribute2 );
710: arp_util.debug( 'p_interface_header_attribute3 = ' ||
704: arp_util.debug( 'p_interface_header_context = ' ||
705: p_interface_header_context );
706: arp_util.debug( 'p_interface_header_attribute1 = ' ||
707: p_interface_header_attribute1 );
708: arp_util.debug( 'p_interface_header_attribute2 = ' ||
709: p_interface_header_attribute2 );
710: arp_util.debug( 'p_interface_header_attribute3 = ' ||
711: p_interface_header_attribute3 );
712: arp_util.debug( 'p_interface_header_attribute4 = ' ||
706: arp_util.debug( 'p_interface_header_attribute1 = ' ||
707: p_interface_header_attribute1 );
708: arp_util.debug( 'p_interface_header_attribute2 = ' ||
709: p_interface_header_attribute2 );
710: arp_util.debug( 'p_interface_header_attribute3 = ' ||
711: p_interface_header_attribute3 );
712: arp_util.debug( 'p_interface_header_attribute4 = ' ||
713: p_interface_header_attribute4 );
714: arp_util.debug( 'p_interface_header_attribute5 = ' ||
708: arp_util.debug( 'p_interface_header_attribute2 = ' ||
709: p_interface_header_attribute2 );
710: arp_util.debug( 'p_interface_header_attribute3 = ' ||
711: p_interface_header_attribute3 );
712: arp_util.debug( 'p_interface_header_attribute4 = ' ||
713: p_interface_header_attribute4 );
714: arp_util.debug( 'p_interface_header_attribute5 = ' ||
715: p_interface_header_attribute5 );
716: arp_util.debug( 'p_interface_header_attribute6 = ' ||
710: arp_util.debug( 'p_interface_header_attribute3 = ' ||
711: p_interface_header_attribute3 );
712: arp_util.debug( 'p_interface_header_attribute4 = ' ||
713: p_interface_header_attribute4 );
714: arp_util.debug( 'p_interface_header_attribute5 = ' ||
715: p_interface_header_attribute5 );
716: arp_util.debug( 'p_interface_header_attribute6 = ' ||
717: p_interface_header_attribute6 );
718: arp_util.debug( 'p_interface_header_attribute7 = ' ||
712: arp_util.debug( 'p_interface_header_attribute4 = ' ||
713: p_interface_header_attribute4 );
714: arp_util.debug( 'p_interface_header_attribute5 = ' ||
715: p_interface_header_attribute5 );
716: arp_util.debug( 'p_interface_header_attribute6 = ' ||
717: p_interface_header_attribute6 );
718: arp_util.debug( 'p_interface_header_attribute7 = ' ||
719: p_interface_header_attribute7 );
720: arp_util.debug( 'p_interface_header_attribute8 = ' ||
714: arp_util.debug( 'p_interface_header_attribute5 = ' ||
715: p_interface_header_attribute5 );
716: arp_util.debug( 'p_interface_header_attribute6 = ' ||
717: p_interface_header_attribute6 );
718: arp_util.debug( 'p_interface_header_attribute7 = ' ||
719: p_interface_header_attribute7 );
720: arp_util.debug( 'p_interface_header_attribute8 = ' ||
721: p_interface_header_attribute8 );
722: arp_util.debug( 'p_interface_header_attribute9 = ' ||
716: arp_util.debug( 'p_interface_header_attribute6 = ' ||
717: p_interface_header_attribute6 );
718: arp_util.debug( 'p_interface_header_attribute7 = ' ||
719: p_interface_header_attribute7 );
720: arp_util.debug( 'p_interface_header_attribute8 = ' ||
721: p_interface_header_attribute8 );
722: arp_util.debug( 'p_interface_header_attribute9 = ' ||
723: p_interface_header_attribute9 );
724: arp_util.debug( 'p_interface_header_attribute10 = ' ||
718: arp_util.debug( 'p_interface_header_attribute7 = ' ||
719: p_interface_header_attribute7 );
720: arp_util.debug( 'p_interface_header_attribute8 = ' ||
721: p_interface_header_attribute8 );
722: arp_util.debug( 'p_interface_header_attribute9 = ' ||
723: p_interface_header_attribute9 );
724: arp_util.debug( 'p_interface_header_attribute10 = ' ||
725: p_interface_header_attribute10 );
726: arp_util.debug( 'p_interface_header_attribute11 = ' ||
720: arp_util.debug( 'p_interface_header_attribute8 = ' ||
721: p_interface_header_attribute8 );
722: arp_util.debug( 'p_interface_header_attribute9 = ' ||
723: p_interface_header_attribute9 );
724: arp_util.debug( 'p_interface_header_attribute10 = ' ||
725: p_interface_header_attribute10 );
726: arp_util.debug( 'p_interface_header_attribute11 = ' ||
727: p_interface_header_attribute11 );
728: arp_util.debug( 'p_interface_header_attribute12 = ' ||
722: arp_util.debug( 'p_interface_header_attribute9 = ' ||
723: p_interface_header_attribute9 );
724: arp_util.debug( 'p_interface_header_attribute10 = ' ||
725: p_interface_header_attribute10 );
726: arp_util.debug( 'p_interface_header_attribute11 = ' ||
727: p_interface_header_attribute11 );
728: arp_util.debug( 'p_interface_header_attribute12 = ' ||
729: p_interface_header_attribute12 );
730: arp_util.debug( 'p_interface_header_attribute13 = ' ||
724: arp_util.debug( 'p_interface_header_attribute10 = ' ||
725: p_interface_header_attribute10 );
726: arp_util.debug( 'p_interface_header_attribute11 = ' ||
727: p_interface_header_attribute11 );
728: arp_util.debug( 'p_interface_header_attribute12 = ' ||
729: p_interface_header_attribute12 );
730: arp_util.debug( 'p_interface_header_attribute13 = ' ||
731: p_interface_header_attribute13 );
732: arp_util.debug( 'p_interface_header_attribute14 = ' ||
726: arp_util.debug( 'p_interface_header_attribute11 = ' ||
727: p_interface_header_attribute11 );
728: arp_util.debug( 'p_interface_header_attribute12 = ' ||
729: p_interface_header_attribute12 );
730: arp_util.debug( 'p_interface_header_attribute13 = ' ||
731: p_interface_header_attribute13 );
732: arp_util.debug( 'p_interface_header_attribute14 = ' ||
733: p_interface_header_attribute14 );
734: arp_util.debug( 'p_interface_header_attribute15 = ' ||
728: arp_util.debug( 'p_interface_header_attribute12 = ' ||
729: p_interface_header_attribute12 );
730: arp_util.debug( 'p_interface_header_attribute13 = ' ||
731: p_interface_header_attribute13 );
732: arp_util.debug( 'p_interface_header_attribute14 = ' ||
733: p_interface_header_attribute14 );
734: arp_util.debug( 'p_interface_header_attribute15 = ' ||
735: p_interface_header_attribute15 );
736: arp_util.debug( 'p_attribute_category = ' ||
730: arp_util.debug( 'p_interface_header_attribute13 = ' ||
731: p_interface_header_attribute13 );
732: arp_util.debug( 'p_interface_header_attribute14 = ' ||
733: p_interface_header_attribute14 );
734: arp_util.debug( 'p_interface_header_attribute15 = ' ||
735: p_interface_header_attribute15 );
736: arp_util.debug( 'p_attribute_category = ' ||
737: p_attribute_category );
738: arp_util.debug( 'p_attribute1 = ' ||
732: arp_util.debug( 'p_interface_header_attribute14 = ' ||
733: p_interface_header_attribute14 );
734: arp_util.debug( 'p_interface_header_attribute15 = ' ||
735: p_interface_header_attribute15 );
736: arp_util.debug( 'p_attribute_category = ' ||
737: p_attribute_category );
738: arp_util.debug( 'p_attribute1 = ' ||
739: p_attribute1 );
740: arp_util.debug( 'p_attribute2 = ' ||
734: arp_util.debug( 'p_interface_header_attribute15 = ' ||
735: p_interface_header_attribute15 );
736: arp_util.debug( 'p_attribute_category = ' ||
737: p_attribute_category );
738: arp_util.debug( 'p_attribute1 = ' ||
739: p_attribute1 );
740: arp_util.debug( 'p_attribute2 = ' ||
741: p_attribute2 );
742: arp_util.debug( 'p_attribute3 = ' ||
736: arp_util.debug( 'p_attribute_category = ' ||
737: p_attribute_category );
738: arp_util.debug( 'p_attribute1 = ' ||
739: p_attribute1 );
740: arp_util.debug( 'p_attribute2 = ' ||
741: p_attribute2 );
742: arp_util.debug( 'p_attribute3 = ' ||
743: p_attribute3 );
744: arp_util.debug( 'p_attribute4 = ' ||
738: arp_util.debug( 'p_attribute1 = ' ||
739: p_attribute1 );
740: arp_util.debug( 'p_attribute2 = ' ||
741: p_attribute2 );
742: arp_util.debug( 'p_attribute3 = ' ||
743: p_attribute3 );
744: arp_util.debug( 'p_attribute4 = ' ||
745: p_attribute4 );
746: arp_util.debug( 'p_attribute5 = ' ||
740: arp_util.debug( 'p_attribute2 = ' ||
741: p_attribute2 );
742: arp_util.debug( 'p_attribute3 = ' ||
743: p_attribute3 );
744: arp_util.debug( 'p_attribute4 = ' ||
745: p_attribute4 );
746: arp_util.debug( 'p_attribute5 = ' ||
747: p_attribute5 );
748: arp_util.debug( 'p_attribute6 = ' ||
742: arp_util.debug( 'p_attribute3 = ' ||
743: p_attribute3 );
744: arp_util.debug( 'p_attribute4 = ' ||
745: p_attribute4 );
746: arp_util.debug( 'p_attribute5 = ' ||
747: p_attribute5 );
748: arp_util.debug( 'p_attribute6 = ' ||
749: p_attribute6 );
750: arp_util.debug( 'p_attribute7 = ' ||
744: arp_util.debug( 'p_attribute4 = ' ||
745: p_attribute4 );
746: arp_util.debug( 'p_attribute5 = ' ||
747: p_attribute5 );
748: arp_util.debug( 'p_attribute6 = ' ||
749: p_attribute6 );
750: arp_util.debug( 'p_attribute7 = ' ||
751: p_attribute7 );
752: arp_util.debug( 'p_attribute8 = ' ||
746: arp_util.debug( 'p_attribute5 = ' ||
747: p_attribute5 );
748: arp_util.debug( 'p_attribute6 = ' ||
749: p_attribute6 );
750: arp_util.debug( 'p_attribute7 = ' ||
751: p_attribute7 );
752: arp_util.debug( 'p_attribute8 = ' ||
753: p_attribute8 );
754: arp_util.debug( 'p_attribute9 = ' ||
748: arp_util.debug( 'p_attribute6 = ' ||
749: p_attribute6 );
750: arp_util.debug( 'p_attribute7 = ' ||
751: p_attribute7 );
752: arp_util.debug( 'p_attribute8 = ' ||
753: p_attribute8 );
754: arp_util.debug( 'p_attribute9 = ' ||
755: p_attribute9 );
756: arp_util.debug( 'p_attribute10 = ' ||
750: arp_util.debug( 'p_attribute7 = ' ||
751: p_attribute7 );
752: arp_util.debug( 'p_attribute8 = ' ||
753: p_attribute8 );
754: arp_util.debug( 'p_attribute9 = ' ||
755: p_attribute9 );
756: arp_util.debug( 'p_attribute10 = ' ||
757: p_attribute10 );
758: arp_util.debug( 'p_attribute11 = ' ||
752: arp_util.debug( 'p_attribute8 = ' ||
753: p_attribute8 );
754: arp_util.debug( 'p_attribute9 = ' ||
755: p_attribute9 );
756: arp_util.debug( 'p_attribute10 = ' ||
757: p_attribute10 );
758: arp_util.debug( 'p_attribute11 = ' ||
759: p_attribute11 );
760: arp_util.debug( 'p_attribute12 = ' ||
754: arp_util.debug( 'p_attribute9 = ' ||
755: p_attribute9 );
756: arp_util.debug( 'p_attribute10 = ' ||
757: p_attribute10 );
758: arp_util.debug( 'p_attribute11 = ' ||
759: p_attribute11 );
760: arp_util.debug( 'p_attribute12 = ' ||
761: p_attribute12 );
762: arp_util.debug( 'p_attribute13 = ' ||
756: arp_util.debug( 'p_attribute10 = ' ||
757: p_attribute10 );
758: arp_util.debug( 'p_attribute11 = ' ||
759: p_attribute11 );
760: arp_util.debug( 'p_attribute12 = ' ||
761: p_attribute12 );
762: arp_util.debug( 'p_attribute13 = ' ||
763: p_attribute13 );
764: arp_util.debug( 'p_attribute14 = ' ||
758: arp_util.debug( 'p_attribute11 = ' ||
759: p_attribute11 );
760: arp_util.debug( 'p_attribute12 = ' ||
761: p_attribute12 );
762: arp_util.debug( 'p_attribute13 = ' ||
763: p_attribute13 );
764: arp_util.debug( 'p_attribute14 = ' ||
765: p_attribute14 );
766: arp_util.debug( 'p_attribute15 = ' ||
760: arp_util.debug( 'p_attribute12 = ' ||
761: p_attribute12 );
762: arp_util.debug( 'p_attribute13 = ' ||
763: p_attribute13 );
764: arp_util.debug( 'p_attribute14 = ' ||
765: p_attribute14 );
766: arp_util.debug( 'p_attribute15 = ' ||
767: p_attribute15 );
768: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
762: arp_util.debug( 'p_attribute13 = ' ||
763: p_attribute13 );
764: arp_util.debug( 'p_attribute14 = ' ||
765: p_attribute14 );
766: arp_util.debug( 'p_attribute15 = ' ||
767: p_attribute15 );
768: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
769: TO_CHAR(p_commit_customer_trx_line_id ) );
770: arp_util.debug( 'p_commit_inventory_item_id = ' ||
764: arp_util.debug( 'p_attribute14 = ' ||
765: p_attribute14 );
766: arp_util.debug( 'p_attribute15 = ' ||
767: p_attribute15 );
768: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
769: TO_CHAR(p_commit_customer_trx_line_id ) );
770: arp_util.debug( 'p_commit_inventory_item_id = ' ||
771: TO_CHAR(p_commit_inventory_item_id ) );
772: arp_util.debug( 'p_commit_memo_line_id = ' ||
766: arp_util.debug( 'p_attribute15 = ' ||
767: p_attribute15 );
768: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
769: TO_CHAR(p_commit_customer_trx_line_id ) );
770: arp_util.debug( 'p_commit_inventory_item_id = ' ||
771: TO_CHAR(p_commit_inventory_item_id ) );
772: arp_util.debug( 'p_commit_memo_line_id = ' ||
773: TO_CHAR(p_commit_memo_line_id ) );
774: arp_util.debug( 'p_commit_description = ' ||
768: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
769: TO_CHAR(p_commit_customer_trx_line_id ) );
770: arp_util.debug( 'p_commit_inventory_item_id = ' ||
771: TO_CHAR(p_commit_inventory_item_id ) );
772: arp_util.debug( 'p_commit_memo_line_id = ' ||
773: TO_CHAR(p_commit_memo_line_id ) );
774: arp_util.debug( 'p_commit_description = ' ||
775: p_commit_description );
776: arp_util.debug( 'p_commit_extended_amount = ' ||
770: arp_util.debug( 'p_commit_inventory_item_id = ' ||
771: TO_CHAR(p_commit_inventory_item_id ) );
772: arp_util.debug( 'p_commit_memo_line_id = ' ||
773: TO_CHAR(p_commit_memo_line_id ) );
774: arp_util.debug( 'p_commit_description = ' ||
775: p_commit_description );
776: arp_util.debug( 'p_commit_extended_amount = ' ||
777: p_commit_extended_amount );
778: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
772: arp_util.debug( 'p_commit_memo_line_id = ' ||
773: TO_CHAR(p_commit_memo_line_id ) );
774: arp_util.debug( 'p_commit_description = ' ||
775: p_commit_description );
776: arp_util.debug( 'p_commit_extended_amount = ' ||
777: p_commit_extended_amount );
778: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
779: p_commit_interface_line_attr1 );
780: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
774: arp_util.debug( 'p_commit_description = ' ||
775: p_commit_description );
776: arp_util.debug( 'p_commit_extended_amount = ' ||
777: p_commit_extended_amount );
778: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
779: p_commit_interface_line_attr1 );
780: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
781: p_commit_interface_line_attr2 );
782: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
776: arp_util.debug( 'p_commit_extended_amount = ' ||
777: p_commit_extended_amount );
778: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
779: p_commit_interface_line_attr1 );
780: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
781: p_commit_interface_line_attr2 );
782: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
783: p_commit_interface_line_attr3 );
784: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
778: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
779: p_commit_interface_line_attr1 );
780: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
781: p_commit_interface_line_attr2 );
782: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
783: p_commit_interface_line_attr3 );
784: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
785: p_commit_interface_line_attr4 );
786: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
780: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
781: p_commit_interface_line_attr2 );
782: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
783: p_commit_interface_line_attr3 );
784: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
785: p_commit_interface_line_attr4 );
786: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
787: p_commit_interface_line_attr5 );
788: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
782: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
783: p_commit_interface_line_attr3 );
784: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
785: p_commit_interface_line_attr4 );
786: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
787: p_commit_interface_line_attr5 );
788: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
789: p_commit_interface_line_attr6 );
790: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
784: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
785: p_commit_interface_line_attr4 );
786: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
787: p_commit_interface_line_attr5 );
788: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
789: p_commit_interface_line_attr6 );
790: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
791: p_commit_interface_line_attr7 );
792: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
786: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
787: p_commit_interface_line_attr5 );
788: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
789: p_commit_interface_line_attr6 );
790: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
791: p_commit_interface_line_attr7 );
792: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
793: p_commit_interface_line_attr8 );
794: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
788: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
789: p_commit_interface_line_attr6 );
790: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
791: p_commit_interface_line_attr7 );
792: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
793: p_commit_interface_line_attr8 );
794: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
795: p_commit_interface_line_attr9 );
796: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
790: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
791: p_commit_interface_line_attr7 );
792: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
793: p_commit_interface_line_attr8 );
794: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
795: p_commit_interface_line_attr9 );
796: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
797: p_commit_interface_line_attr10 );
798: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
792: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
793: p_commit_interface_line_attr8 );
794: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
795: p_commit_interface_line_attr9 );
796: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
797: p_commit_interface_line_attr10 );
798: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
799: p_commit_interface_line_attr11 );
800: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
794: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
795: p_commit_interface_line_attr9 );
796: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
797: p_commit_interface_line_attr10 );
798: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
799: p_commit_interface_line_attr11 );
800: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
801: p_commit_interface_line_attr12 );
802: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
796: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
797: p_commit_interface_line_attr10 );
798: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
799: p_commit_interface_line_attr11 );
800: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
801: p_commit_interface_line_attr12 );
802: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
803: p_commit_interface_line_attr13 );
804: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
798: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
799: p_commit_interface_line_attr11 );
800: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
801: p_commit_interface_line_attr12 );
802: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
803: p_commit_interface_line_attr13 );
804: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
805: p_commit_interface_line_attr14 );
806: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
800: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
801: p_commit_interface_line_attr12 );
802: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
803: p_commit_interface_line_attr13 );
804: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
805: p_commit_interface_line_attr14 );
806: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
807: p_commit_interface_line_attr15 );
808: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
802: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
803: p_commit_interface_line_attr13 );
804: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
805: p_commit_interface_line_attr14 );
806: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
807: p_commit_interface_line_attr15 );
808: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
809: p_commit_interface_line_contxt );
810: arp_util.debug( 'p_commit_attribute_category = ' ||
804: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
805: p_commit_interface_line_attr14 );
806: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
807: p_commit_interface_line_attr15 );
808: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
809: p_commit_interface_line_contxt );
810: arp_util.debug( 'p_commit_attribute_category = ' ||
811: p_commit_attribute_category );
812: arp_util.debug( 'p_commit_attribute1 = ' ||
806: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
807: p_commit_interface_line_attr15 );
808: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
809: p_commit_interface_line_contxt );
810: arp_util.debug( 'p_commit_attribute_category = ' ||
811: p_commit_attribute_category );
812: arp_util.debug( 'p_commit_attribute1 = ' ||
813: p_commit_attribute1 );
814: arp_util.debug( 'p_commit_attribute2 = ' ||
808: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
809: p_commit_interface_line_contxt );
810: arp_util.debug( 'p_commit_attribute_category = ' ||
811: p_commit_attribute_category );
812: arp_util.debug( 'p_commit_attribute1 = ' ||
813: p_commit_attribute1 );
814: arp_util.debug( 'p_commit_attribute2 = ' ||
815: p_commit_attribute2 );
816: arp_util.debug( 'p_commit_attribute3 = ' ||
810: arp_util.debug( 'p_commit_attribute_category = ' ||
811: p_commit_attribute_category );
812: arp_util.debug( 'p_commit_attribute1 = ' ||
813: p_commit_attribute1 );
814: arp_util.debug( 'p_commit_attribute2 = ' ||
815: p_commit_attribute2 );
816: arp_util.debug( 'p_commit_attribute3 = ' ||
817: p_commit_attribute3 );
818: arp_util.debug( 'p_commit_attribute4 = ' ||
812: arp_util.debug( 'p_commit_attribute1 = ' ||
813: p_commit_attribute1 );
814: arp_util.debug( 'p_commit_attribute2 = ' ||
815: p_commit_attribute2 );
816: arp_util.debug( 'p_commit_attribute3 = ' ||
817: p_commit_attribute3 );
818: arp_util.debug( 'p_commit_attribute4 = ' ||
819: p_commit_attribute4 );
820: arp_util.debug( 'p_commit_attribute5 = ' ||
814: arp_util.debug( 'p_commit_attribute2 = ' ||
815: p_commit_attribute2 );
816: arp_util.debug( 'p_commit_attribute3 = ' ||
817: p_commit_attribute3 );
818: arp_util.debug( 'p_commit_attribute4 = ' ||
819: p_commit_attribute4 );
820: arp_util.debug( 'p_commit_attribute5 = ' ||
821: p_commit_attribute5 );
822: arp_util.debug( 'p_commit_attribute6 = ' ||
816: arp_util.debug( 'p_commit_attribute3 = ' ||
817: p_commit_attribute3 );
818: arp_util.debug( 'p_commit_attribute4 = ' ||
819: p_commit_attribute4 );
820: arp_util.debug( 'p_commit_attribute5 = ' ||
821: p_commit_attribute5 );
822: arp_util.debug( 'p_commit_attribute6 = ' ||
823: p_commit_attribute6 );
824: arp_util.debug( 'p_commit_attribute7 = ' ||
818: arp_util.debug( 'p_commit_attribute4 = ' ||
819: p_commit_attribute4 );
820: arp_util.debug( 'p_commit_attribute5 = ' ||
821: p_commit_attribute5 );
822: arp_util.debug( 'p_commit_attribute6 = ' ||
823: p_commit_attribute6 );
824: arp_util.debug( 'p_commit_attribute7 = ' ||
825: p_commit_attribute7 );
826: arp_util.debug( 'p_commit_attribute8 = ' ||
820: arp_util.debug( 'p_commit_attribute5 = ' ||
821: p_commit_attribute5 );
822: arp_util.debug( 'p_commit_attribute6 = ' ||
823: p_commit_attribute6 );
824: arp_util.debug( 'p_commit_attribute7 = ' ||
825: p_commit_attribute7 );
826: arp_util.debug( 'p_commit_attribute8 = ' ||
827: p_commit_attribute8 );
828: arp_util.debug( 'p_commit_attribute9 = ' ||
822: arp_util.debug( 'p_commit_attribute6 = ' ||
823: p_commit_attribute6 );
824: arp_util.debug( 'p_commit_attribute7 = ' ||
825: p_commit_attribute7 );
826: arp_util.debug( 'p_commit_attribute8 = ' ||
827: p_commit_attribute8 );
828: arp_util.debug( 'p_commit_attribute9 = ' ||
829: p_commit_attribute9 );
830: arp_util.debug( 'p_commit_attribute10 = ' ||
824: arp_util.debug( 'p_commit_attribute7 = ' ||
825: p_commit_attribute7 );
826: arp_util.debug( 'p_commit_attribute8 = ' ||
827: p_commit_attribute8 );
828: arp_util.debug( 'p_commit_attribute9 = ' ||
829: p_commit_attribute9 );
830: arp_util.debug( 'p_commit_attribute10 = ' ||
831: p_commit_attribute10 );
832: arp_util.debug( 'p_commit_attribute11 = ' ||
826: arp_util.debug( 'p_commit_attribute8 = ' ||
827: p_commit_attribute8 );
828: arp_util.debug( 'p_commit_attribute9 = ' ||
829: p_commit_attribute9 );
830: arp_util.debug( 'p_commit_attribute10 = ' ||
831: p_commit_attribute10 );
832: arp_util.debug( 'p_commit_attribute11 = ' ||
833: p_commit_attribute11 );
834: arp_util.debug( 'p_commit_attribute12 = ' ||
828: arp_util.debug( 'p_commit_attribute9 = ' ||
829: p_commit_attribute9 );
830: arp_util.debug( 'p_commit_attribute10 = ' ||
831: p_commit_attribute10 );
832: arp_util.debug( 'p_commit_attribute11 = ' ||
833: p_commit_attribute11 );
834: arp_util.debug( 'p_commit_attribute12 = ' ||
835: p_commit_attribute12 );
836: arp_util.debug( 'p_commit_attribute13 = ' ||
830: arp_util.debug( 'p_commit_attribute10 = ' ||
831: p_commit_attribute10 );
832: arp_util.debug( 'p_commit_attribute11 = ' ||
833: p_commit_attribute11 );
834: arp_util.debug( 'p_commit_attribute12 = ' ||
835: p_commit_attribute12 );
836: arp_util.debug( 'p_commit_attribute13 = ' ||
837: p_commit_attribute13 );
838: arp_util.debug( 'p_commit_attribute14 = ' ||
832: arp_util.debug( 'p_commit_attribute11 = ' ||
833: p_commit_attribute11 );
834: arp_util.debug( 'p_commit_attribute12 = ' ||
835: p_commit_attribute12 );
836: arp_util.debug( 'p_commit_attribute13 = ' ||
837: p_commit_attribute13 );
838: arp_util.debug( 'p_commit_attribute14 = ' ||
839: p_commit_attribute14 );
840: arp_util.debug( 'p_commit_attribute15 = ' ||
834: arp_util.debug( 'p_commit_attribute12 = ' ||
835: p_commit_attribute12 );
836: arp_util.debug( 'p_commit_attribute13 = ' ||
837: p_commit_attribute13 );
838: arp_util.debug( 'p_commit_attribute14 = ' ||
839: p_commit_attribute14 );
840: arp_util.debug( 'p_commit_attribute15 = ' ||
841: p_commit_attribute15 );
842: arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
836: arp_util.debug( 'p_commit_attribute13 = ' ||
837: p_commit_attribute13 );
838: arp_util.debug( 'p_commit_attribute14 = ' ||
839: p_commit_attribute14 );
840: arp_util.debug( 'p_commit_attribute15 = ' ||
841: p_commit_attribute15 );
842: arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
843: p_ctl_default_ussgl_trx_code );
844: END IF;
838: arp_util.debug( 'p_commit_attribute14 = ' ||
839: p_commit_attribute14 );
840: arp_util.debug( 'p_commit_attribute15 = ' ||
841: p_commit_attribute15 );
842: arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
843: p_ctl_default_ussgl_trx_code );
844: END IF;
845:
846: --{BUG#4897183
871: p_curr_trx_date => l_trx_date,
872: p_transaction_date => p_trx_date,
873: x_event_id => x_event_id);
874:
875: arp_util.debug( 'x_event_id = ' ||x_event_id );
876: END IF;
877: --}
878:
879:
921: THEN
922: /* Determine state for etax sync call */
923: IF PG_DEBUG in ('Y','C')
924: THEN
925: arp_util.debug('Header exists (lf = TRUE) ');
926: arp_util.debug(' old term_id = ' || l_term_id);
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
922: /* Determine state for etax sync call */
923: IF PG_DEBUG in ('Y','C')
924: THEN
925: arp_util.debug('Header exists (lf = TRUE) ');
926: arp_util.debug(' old term_id = ' || l_term_id);
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
930: arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
923: IF PG_DEBUG in ('Y','C')
924: THEN
925: arp_util.debug('Header exists (lf = TRUE) ');
926: arp_util.debug(' old term_id = ' || l_term_id);
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
930: arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
931: arp_util.debug(' old initial_customer_trx_id = ' || l_initial_cust_trx_id);
924: THEN
925: arp_util.debug('Header exists (lf = TRUE) ');
926: arp_util.debug(' old term_id = ' || l_term_id);
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
930: arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
931: arp_util.debug(' old initial_customer_trx_id = ' || l_initial_cust_trx_id);
932: END IF;
925: arp_util.debug('Header exists (lf = TRUE) ');
926: arp_util.debug(' old term_id = ' || l_term_id);
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
930: arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
931: arp_util.debug(' old initial_customer_trx_id = ' || l_initial_cust_trx_id);
932: END IF;
933:
926: arp_util.debug(' old term_id = ' || l_term_id);
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
930: arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
931: arp_util.debug(' old initial_customer_trx_id = ' || l_initial_cust_trx_id);
932: END IF;
933:
934: IF NVL(p_term_id, l_term_id) <> l_term_id
927: arp_util.debug(' new term_id = ' || p_term_id);
928: arp_util.debug(' old_gl_date = ' || l_gl_date);
929: arp_util.debug(' new_gl_date = ' || p_gl_date);
930: arp_util.debug(' new initial_customer_trx_id = ' || p_initial_customer_trx_id);
931: arp_util.debug(' old initial_customer_trx_id = ' || l_initial_cust_trx_id);
932: END IF;
933:
934: IF NVL(p_term_id, l_term_id) <> l_term_id
935: THEN
960: NULL,
961: 'Y');
962: IF l_return_status > 0
963: THEN
964: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
965: l_return_status);
966: arp_util.debug('Please review the plsql debug log for additional details.');
967: p_status := 'SYNCH_DOC_SEQ_ERROR';
968: END IF;
962: IF l_return_status > 0
963: THEN
964: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
965: l_return_status);
966: arp_util.debug('Please review the plsql debug log for additional details.');
967: p_status := 'SYNCH_DOC_SEQ_ERROR';
968: END IF;
969: -- bug 6957444 {
970: ELSIF p_initial_customer_trx_id IS NOT NULL and l_initial_cust_trx_id is null then
984: arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_return_status);
985:
986: IF l_return_status > 0
987: THEN
988: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
989: l_return_status);
990: arp_util.debug('Please review the plsql debug log for additional details.');
991: p_status := 'SYNCH_DOC_SEQ_ERROR';
992: END IF;
986: IF l_return_status > 0
987: THEN
988: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
989: l_return_status);
990: arp_util.debug('Please review the plsql debug log for additional details.');
991: p_status := 'SYNCH_DOC_SEQ_ERROR';
992: END IF;
993: END IF;
994: END IF;
993: END IF;
994: END IF;
995:
996: IF PG_DEBUG in ('Y', 'C') THEN
997: arp_util.debug('arp_process_header_updte_cover.update_header_cover()-');
998: END IF;
999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: IF PG_DEBUG in ('Y', 'C') THEN
1003: arp_util.debug(
1004: 'exception: arp_process_header_updte_cover.update_header_cover()');
1005: END IF;
1006: RAISE;
1007: