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 |
404:
405: BEGIN
406:
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_util.debug('arp_process_header_updte_cover.update_header_cover()+');
409: END IF;
410:
411: /* manishri, 07-Jun-2010. Bug 9693686 */
412: OPEN c_get_old_complete_flag(p_customer_trx_id);
411: /* manishri, 07-Jun-2010. Bug 9693686 */
412: OPEN c_get_old_complete_flag(p_customer_trx_id);
413: FETCH c_get_old_complete_flag INTO g_old_complete_flag;
414: CLOSE c_get_old_complete_flag;
415: arp_util.debug('Old Complete Flag = ' || g_old_complete_flag);
416: /* End of change, manishri, 07-Jun-2010. Bug 9693686 */
417:
418: arp_ct_pkg.set_to_dummy(l_trx_rec);
419: arp_process_commitment.set_to_dummy(l_commit_rec);
566: l_commit_rec.default_ussgl_transaction_code := p_ctl_default_ussgl_trx_code;
567:
568:
569: IF PG_DEBUG in ('Y', 'C') THEN
570: arp_util.debug( 'p_customer_trx_id = ' ||
571: TO_CHAR(p_customer_trx_id ) );
572: arp_util.debug( 'p_trx_number = ' ||
573: p_trx_number );
574: arp_util.debug( 'p_trx_amount = ' ||
568:
569: IF PG_DEBUG in ('Y', 'C') THEN
570: arp_util.debug( 'p_customer_trx_id = ' ||
571: TO_CHAR(p_customer_trx_id ) );
572: arp_util.debug( 'p_trx_number = ' ||
573: p_trx_number );
574: arp_util.debug( 'p_trx_amount = ' ||
575: TO_CHAR(p_trx_amount ) );
576: arp_util.debug( 'p_open_rec_flag = '||
570: arp_util.debug( 'p_customer_trx_id = ' ||
571: TO_CHAR(p_customer_trx_id ) );
572: arp_util.debug( 'p_trx_number = ' ||
573: p_trx_number );
574: arp_util.debug( 'p_trx_amount = ' ||
575: TO_CHAR(p_trx_amount ) );
576: arp_util.debug( 'p_open_rec_flag = '||
577: p_open_rec_flag);
578: arp_util.debug( 'p_term_in_use_flag = '||
572: arp_util.debug( 'p_trx_number = ' ||
573: p_trx_number );
574: arp_util.debug( 'p_trx_amount = ' ||
575: TO_CHAR(p_trx_amount ) );
576: arp_util.debug( 'p_open_rec_flag = '||
577: p_open_rec_flag);
578: arp_util.debug( 'p_term_in_use_flag = '||
579: p_term_in_use_flag);
580: arp_util.debug( 'p_recalc_tax_flag = '||
574: arp_util.debug( 'p_trx_amount = ' ||
575: TO_CHAR(p_trx_amount ) );
576: arp_util.debug( 'p_open_rec_flag = '||
577: p_open_rec_flag);
578: arp_util.debug( 'p_term_in_use_flag = '||
579: p_term_in_use_flag);
580: arp_util.debug( 'p_recalc_tax_flag = '||
581: p_recalc_tax_flag);
582: arp_util.debug( 'p_rerun_autoacc_flag = '||
576: arp_util.debug( 'p_open_rec_flag = '||
577: p_open_rec_flag);
578: arp_util.debug( 'p_term_in_use_flag = '||
579: p_term_in_use_flag);
580: arp_util.debug( 'p_recalc_tax_flag = '||
581: p_recalc_tax_flag);
582: arp_util.debug( 'p_rerun_autoacc_flag = '||
583: p_rerun_autoacc_flag);
584: arp_util.debug( 'p_posting_control_id = ' ||
578: arp_util.debug( 'p_term_in_use_flag = '||
579: p_term_in_use_flag);
580: arp_util.debug( 'p_recalc_tax_flag = '||
581: p_recalc_tax_flag);
582: arp_util.debug( 'p_rerun_autoacc_flag = '||
583: p_rerun_autoacc_flag);
584: arp_util.debug( 'p_posting_control_id = ' ||
585: TO_CHAR(p_posting_control_id ) );
586: arp_util.debug( 'p_ra_post_loop_number = ' ||
580: arp_util.debug( 'p_recalc_tax_flag = '||
581: p_recalc_tax_flag);
582: arp_util.debug( 'p_rerun_autoacc_flag = '||
583: p_rerun_autoacc_flag);
584: arp_util.debug( 'p_posting_control_id = ' ||
585: TO_CHAR(p_posting_control_id ) );
586: arp_util.debug( 'p_ra_post_loop_number = ' ||
587: p_ra_post_loop_number );
588: arp_util.debug( 'p_complete_flag = ' ||
582: arp_util.debug( 'p_rerun_autoacc_flag = '||
583: p_rerun_autoacc_flag);
584: arp_util.debug( 'p_posting_control_id = ' ||
585: TO_CHAR(p_posting_control_id ) );
586: arp_util.debug( 'p_ra_post_loop_number = ' ||
587: p_ra_post_loop_number );
588: arp_util.debug( 'p_complete_flag = ' ||
589: p_complete_flag );
590: arp_util.debug( 'p_initial_customer_trx_id = ' ||
584: arp_util.debug( 'p_posting_control_id = ' ||
585: TO_CHAR(p_posting_control_id ) );
586: arp_util.debug( 'p_ra_post_loop_number = ' ||
587: p_ra_post_loop_number );
588: arp_util.debug( 'p_complete_flag = ' ||
589: p_complete_flag );
590: arp_util.debug( 'p_initial_customer_trx_id = ' ||
591: TO_CHAR(p_initial_customer_trx_id ) );
592: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
586: arp_util.debug( 'p_ra_post_loop_number = ' ||
587: p_ra_post_loop_number );
588: arp_util.debug( 'p_complete_flag = ' ||
589: p_complete_flag );
590: arp_util.debug( 'p_initial_customer_trx_id = ' ||
591: TO_CHAR(p_initial_customer_trx_id ) );
592: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
593: TO_CHAR(p_initial_customer_trx_line_id ) );
594: arp_util.debug( 'p_previous_customer_trx_id = ' ||
588: arp_util.debug( 'p_complete_flag = ' ||
589: p_complete_flag );
590: arp_util.debug( 'p_initial_customer_trx_id = ' ||
591: TO_CHAR(p_initial_customer_trx_id ) );
592: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
593: TO_CHAR(p_initial_customer_trx_line_id ) );
594: arp_util.debug( 'p_previous_customer_trx_id = ' ||
595: TO_CHAR(p_previous_customer_trx_id ) );
596: arp_util.debug( 'p_related_customer_trx_id = ' ||
590: arp_util.debug( 'p_initial_customer_trx_id = ' ||
591: TO_CHAR(p_initial_customer_trx_id ) );
592: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
593: TO_CHAR(p_initial_customer_trx_line_id ) );
594: arp_util.debug( 'p_previous_customer_trx_id = ' ||
595: TO_CHAR(p_previous_customer_trx_id ) );
596: arp_util.debug( 'p_related_customer_trx_id = ' ||
597: TO_CHAR(p_related_customer_trx_id ) );
598: arp_util.debug( 'p_recurred_from_trx_number = ' ||
592: arp_util.debug( 'p_initial_customer_trx_line_id = ' ||
593: TO_CHAR(p_initial_customer_trx_line_id ) );
594: arp_util.debug( 'p_previous_customer_trx_id = ' ||
595: TO_CHAR(p_previous_customer_trx_id ) );
596: arp_util.debug( 'p_related_customer_trx_id = ' ||
597: TO_CHAR(p_related_customer_trx_id ) );
598: arp_util.debug( 'p_recurred_from_trx_number = ' ||
599: p_recurred_from_trx_number );
600: arp_util.debug( 'p_cust_trx_type_id = ' ||
594: arp_util.debug( 'p_previous_customer_trx_id = ' ||
595: TO_CHAR(p_previous_customer_trx_id ) );
596: arp_util.debug( 'p_related_customer_trx_id = ' ||
597: TO_CHAR(p_related_customer_trx_id ) );
598: arp_util.debug( 'p_recurred_from_trx_number = ' ||
599: p_recurred_from_trx_number );
600: arp_util.debug( 'p_cust_trx_type_id = ' ||
601: TO_CHAR(p_cust_trx_type_id ) );
602: arp_util.debug( 'p_batch_id = ' ||
596: arp_util.debug( 'p_related_customer_trx_id = ' ||
597: TO_CHAR(p_related_customer_trx_id ) );
598: arp_util.debug( 'p_recurred_from_trx_number = ' ||
599: p_recurred_from_trx_number );
600: arp_util.debug( 'p_cust_trx_type_id = ' ||
601: TO_CHAR(p_cust_trx_type_id ) );
602: arp_util.debug( 'p_batch_id = ' ||
603: TO_CHAR(p_batch_id ) );
604: arp_util.debug( 'p_batch_source_id = ' ||
598: arp_util.debug( 'p_recurred_from_trx_number = ' ||
599: p_recurred_from_trx_number );
600: arp_util.debug( 'p_cust_trx_type_id = ' ||
601: TO_CHAR(p_cust_trx_type_id ) );
602: arp_util.debug( 'p_batch_id = ' ||
603: TO_CHAR(p_batch_id ) );
604: arp_util.debug( 'p_batch_source_id = ' ||
605: TO_CHAR(p_batch_source_id ) );
606: arp_util.debug( 'p_agreement_id = ' ||
600: arp_util.debug( 'p_cust_trx_type_id = ' ||
601: TO_CHAR(p_cust_trx_type_id ) );
602: arp_util.debug( 'p_batch_id = ' ||
603: TO_CHAR(p_batch_id ) );
604: arp_util.debug( 'p_batch_source_id = ' ||
605: TO_CHAR(p_batch_source_id ) );
606: arp_util.debug( 'p_agreement_id = ' ||
607: TO_CHAR(p_agreement_id ) );
608: arp_util.debug( 'p_trx_date = ' ||
602: arp_util.debug( 'p_batch_id = ' ||
603: TO_CHAR(p_batch_id ) );
604: arp_util.debug( 'p_batch_source_id = ' ||
605: TO_CHAR(p_batch_source_id ) );
606: arp_util.debug( 'p_agreement_id = ' ||
607: TO_CHAR(p_agreement_id ) );
608: arp_util.debug( 'p_trx_date = ' ||
609: p_trx_date );
610: arp_util.debug( 'p_bill_to_customer_id = ' ||
604: arp_util.debug( 'p_batch_source_id = ' ||
605: TO_CHAR(p_batch_source_id ) );
606: arp_util.debug( 'p_agreement_id = ' ||
607: TO_CHAR(p_agreement_id ) );
608: arp_util.debug( 'p_trx_date = ' ||
609: p_trx_date );
610: arp_util.debug( 'p_bill_to_customer_id = ' ||
611: TO_CHAR(p_bill_to_customer_id ) );
612: arp_util.debug( 'p_bill_to_contact_id = ' ||
606: arp_util.debug( 'p_agreement_id = ' ||
607: TO_CHAR(p_agreement_id ) );
608: arp_util.debug( 'p_trx_date = ' ||
609: p_trx_date );
610: arp_util.debug( 'p_bill_to_customer_id = ' ||
611: TO_CHAR(p_bill_to_customer_id ) );
612: arp_util.debug( 'p_bill_to_contact_id = ' ||
613: TO_CHAR(p_bill_to_contact_id ) );
614: arp_util.debug( 'p_bill_to_site_use_id = ' ||
608: arp_util.debug( 'p_trx_date = ' ||
609: p_trx_date );
610: arp_util.debug( 'p_bill_to_customer_id = ' ||
611: TO_CHAR(p_bill_to_customer_id ) );
612: arp_util.debug( 'p_bill_to_contact_id = ' ||
613: TO_CHAR(p_bill_to_contact_id ) );
614: arp_util.debug( 'p_bill_to_site_use_id = ' ||
615: TO_CHAR(p_bill_to_site_use_id ) );
616: arp_util.debug( 'p_ship_to_customer_id = ' ||
610: arp_util.debug( 'p_bill_to_customer_id = ' ||
611: TO_CHAR(p_bill_to_customer_id ) );
612: arp_util.debug( 'p_bill_to_contact_id = ' ||
613: TO_CHAR(p_bill_to_contact_id ) );
614: arp_util.debug( 'p_bill_to_site_use_id = ' ||
615: TO_CHAR(p_bill_to_site_use_id ) );
616: arp_util.debug( 'p_ship_to_customer_id = ' ||
617: TO_CHAR(p_ship_to_customer_id ) );
618: arp_util.debug( 'p_ship_to_contact_id = ' ||
612: arp_util.debug( 'p_bill_to_contact_id = ' ||
613: TO_CHAR(p_bill_to_contact_id ) );
614: arp_util.debug( 'p_bill_to_site_use_id = ' ||
615: TO_CHAR(p_bill_to_site_use_id ) );
616: arp_util.debug( 'p_ship_to_customer_id = ' ||
617: TO_CHAR(p_ship_to_customer_id ) );
618: arp_util.debug( 'p_ship_to_contact_id = ' ||
619: TO_CHAR(p_ship_to_contact_id ) );
620: arp_util.debug( 'p_ship_to_site_use_id = ' ||
614: arp_util.debug( 'p_bill_to_site_use_id = ' ||
615: TO_CHAR(p_bill_to_site_use_id ) );
616: arp_util.debug( 'p_ship_to_customer_id = ' ||
617: TO_CHAR(p_ship_to_customer_id ) );
618: arp_util.debug( 'p_ship_to_contact_id = ' ||
619: TO_CHAR(p_ship_to_contact_id ) );
620: arp_util.debug( 'p_ship_to_site_use_id = ' ||
621: TO_CHAR(p_ship_to_site_use_id ) );
622: arp_util.debug( 'p_sold_to_customer_id = ' ||
616: arp_util.debug( 'p_ship_to_customer_id = ' ||
617: TO_CHAR(p_ship_to_customer_id ) );
618: arp_util.debug( 'p_ship_to_contact_id = ' ||
619: TO_CHAR(p_ship_to_contact_id ) );
620: arp_util.debug( 'p_ship_to_site_use_id = ' ||
621: TO_CHAR(p_ship_to_site_use_id ) );
622: arp_util.debug( 'p_sold_to_customer_id = ' ||
623: TO_CHAR(p_sold_to_customer_id ) );
624: arp_util.debug( 'p_sold_to_site_use_id = ' ||
618: arp_util.debug( 'p_ship_to_contact_id = ' ||
619: TO_CHAR(p_ship_to_contact_id ) );
620: arp_util.debug( 'p_ship_to_site_use_id = ' ||
621: TO_CHAR(p_ship_to_site_use_id ) );
622: arp_util.debug( 'p_sold_to_customer_id = ' ||
623: TO_CHAR(p_sold_to_customer_id ) );
624: arp_util.debug( 'p_sold_to_site_use_id = ' ||
625: TO_CHAR(p_sold_to_site_use_id ) );
626: arp_util.debug( 'p_sold_to_contact_id = ' ||
620: arp_util.debug( 'p_ship_to_site_use_id = ' ||
621: TO_CHAR(p_ship_to_site_use_id ) );
622: arp_util.debug( 'p_sold_to_customer_id = ' ||
623: TO_CHAR(p_sold_to_customer_id ) );
624: arp_util.debug( 'p_sold_to_site_use_id = ' ||
625: TO_CHAR(p_sold_to_site_use_id ) );
626: arp_util.debug( 'p_sold_to_contact_id = ' ||
627: TO_CHAR(p_sold_to_contact_id ) );
628: arp_util.debug( 'p_customer_reference = ' ||
622: arp_util.debug( 'p_sold_to_customer_id = ' ||
623: TO_CHAR(p_sold_to_customer_id ) );
624: arp_util.debug( 'p_sold_to_site_use_id = ' ||
625: TO_CHAR(p_sold_to_site_use_id ) );
626: arp_util.debug( 'p_sold_to_contact_id = ' ||
627: TO_CHAR(p_sold_to_contact_id ) );
628: arp_util.debug( 'p_customer_reference = ' ||
629: p_customer_reference );
630: arp_util.debug( 'p_customer_reference_date = ' ||
624: arp_util.debug( 'p_sold_to_site_use_id = ' ||
625: TO_CHAR(p_sold_to_site_use_id ) );
626: arp_util.debug( 'p_sold_to_contact_id = ' ||
627: TO_CHAR(p_sold_to_contact_id ) );
628: arp_util.debug( 'p_customer_reference = ' ||
629: p_customer_reference );
630: arp_util.debug( 'p_customer_reference_date = ' ||
631: p_customer_reference_date );
632: arp_util.debug( 'p_cr_method_for_installments = ' ||
626: arp_util.debug( 'p_sold_to_contact_id = ' ||
627: TO_CHAR(p_sold_to_contact_id ) );
628: arp_util.debug( 'p_customer_reference = ' ||
629: p_customer_reference );
630: arp_util.debug( 'p_customer_reference_date = ' ||
631: p_customer_reference_date );
632: arp_util.debug( 'p_cr_method_for_installments = ' ||
633: p_cr_method_for_installments );
634: arp_util.debug( 'p_credit_method_for_rules = ' ||
628: arp_util.debug( 'p_customer_reference = ' ||
629: p_customer_reference );
630: arp_util.debug( 'p_customer_reference_date = ' ||
631: p_customer_reference_date );
632: arp_util.debug( 'p_cr_method_for_installments = ' ||
633: p_cr_method_for_installments );
634: arp_util.debug( 'p_credit_method_for_rules = ' ||
635: p_credit_method_for_rules );
636: arp_util.debug( 'p_start_date_commitment = ' ||
630: arp_util.debug( 'p_customer_reference_date = ' ||
631: p_customer_reference_date );
632: arp_util.debug( 'p_cr_method_for_installments = ' ||
633: p_cr_method_for_installments );
634: arp_util.debug( 'p_credit_method_for_rules = ' ||
635: p_credit_method_for_rules );
636: arp_util.debug( 'p_start_date_commitment = ' ||
637: p_start_date_commitment );
638: arp_util.debug( 'p_end_date_commitment = ' ||
632: arp_util.debug( 'p_cr_method_for_installments = ' ||
633: p_cr_method_for_installments );
634: arp_util.debug( 'p_credit_method_for_rules = ' ||
635: p_credit_method_for_rules );
636: arp_util.debug( 'p_start_date_commitment = ' ||
637: p_start_date_commitment );
638: arp_util.debug( 'p_end_date_commitment = ' ||
639: p_end_date_commitment );
640: arp_util.debug( 'p_exchange_date = ' ||
634: arp_util.debug( 'p_credit_method_for_rules = ' ||
635: p_credit_method_for_rules );
636: arp_util.debug( 'p_start_date_commitment = ' ||
637: p_start_date_commitment );
638: arp_util.debug( 'p_end_date_commitment = ' ||
639: p_end_date_commitment );
640: arp_util.debug( 'p_exchange_date = ' ||
641: p_exchange_date );
642: arp_util.debug( 'p_exchange_rate = ' ||
636: arp_util.debug( 'p_start_date_commitment = ' ||
637: p_start_date_commitment );
638: arp_util.debug( 'p_end_date_commitment = ' ||
639: p_end_date_commitment );
640: arp_util.debug( 'p_exchange_date = ' ||
641: p_exchange_date );
642: arp_util.debug( 'p_exchange_rate = ' ||
643: p_exchange_rate );
644: arp_util.debug( 'p_exchange_rate_type = ' ||
638: arp_util.debug( 'p_end_date_commitment = ' ||
639: p_end_date_commitment );
640: arp_util.debug( 'p_exchange_date = ' ||
641: p_exchange_date );
642: arp_util.debug( 'p_exchange_rate = ' ||
643: p_exchange_rate );
644: arp_util.debug( 'p_exchange_rate_type = ' ||
645: p_exchange_rate_type );
646: arp_util.debug( 'p_customer_bank_account_id = ' ||
640: arp_util.debug( 'p_exchange_date = ' ||
641: p_exchange_date );
642: arp_util.debug( 'p_exchange_rate = ' ||
643: p_exchange_rate );
644: arp_util.debug( 'p_exchange_rate_type = ' ||
645: p_exchange_rate_type );
646: arp_util.debug( 'p_customer_bank_account_id = ' ||
647: p_customer_bank_account_id );
648: arp_util.debug( 'p_finance_charges = ' ||
642: arp_util.debug( 'p_exchange_rate = ' ||
643: p_exchange_rate );
644: arp_util.debug( 'p_exchange_rate_type = ' ||
645: p_exchange_rate_type );
646: arp_util.debug( 'p_customer_bank_account_id = ' ||
647: p_customer_bank_account_id );
648: arp_util.debug( 'p_finance_charges = ' ||
649: p_finance_charges );
650: arp_util.debug( 'p_fob_point = ' ||
644: arp_util.debug( 'p_exchange_rate_type = ' ||
645: p_exchange_rate_type );
646: arp_util.debug( 'p_customer_bank_account_id = ' ||
647: p_customer_bank_account_id );
648: arp_util.debug( 'p_finance_charges = ' ||
649: p_finance_charges );
650: arp_util.debug( 'p_fob_point = ' ||
651: p_fob_point );
652: arp_util.debug( 'p_comments = ' ||
646: arp_util.debug( 'p_customer_bank_account_id = ' ||
647: p_customer_bank_account_id );
648: arp_util.debug( 'p_finance_charges = ' ||
649: p_finance_charges );
650: arp_util.debug( 'p_fob_point = ' ||
651: p_fob_point );
652: arp_util.debug( 'p_comments = ' ||
653: p_comments );
654: arp_util.debug( 'p_internal_notes = ' ||
648: arp_util.debug( 'p_finance_charges = ' ||
649: p_finance_charges );
650: arp_util.debug( 'p_fob_point = ' ||
651: p_fob_point );
652: arp_util.debug( 'p_comments = ' ||
653: p_comments );
654: arp_util.debug( 'p_internal_notes = ' ||
655: p_internal_notes );
656: arp_util.debug( 'p_invoice_currency_code = ' ||
650: arp_util.debug( 'p_fob_point = ' ||
651: p_fob_point );
652: arp_util.debug( 'p_comments = ' ||
653: p_comments );
654: arp_util.debug( 'p_internal_notes = ' ||
655: p_internal_notes );
656: arp_util.debug( 'p_invoice_currency_code = ' ||
657: p_invoice_currency_code );
658: arp_util.debug( 'p_invoicing_rule_id = ' ||
652: arp_util.debug( 'p_comments = ' ||
653: p_comments );
654: arp_util.debug( 'p_internal_notes = ' ||
655: p_internal_notes );
656: arp_util.debug( 'p_invoice_currency_code = ' ||
657: p_invoice_currency_code );
658: arp_util.debug( 'p_invoicing_rule_id = ' ||
659: TO_CHAR(p_invoicing_rule_id ) );
660: arp_util.debug( 'p_last_printed_sequence_num = ' ||
654: arp_util.debug( 'p_internal_notes = ' ||
655: p_internal_notes );
656: arp_util.debug( 'p_invoice_currency_code = ' ||
657: p_invoice_currency_code );
658: arp_util.debug( 'p_invoicing_rule_id = ' ||
659: TO_CHAR(p_invoicing_rule_id ) );
660: arp_util.debug( 'p_last_printed_sequence_num = ' ||
661: p_last_printed_sequence_num );
662: arp_util.debug( 'p_orig_system_batch_name = ' ||
656: arp_util.debug( 'p_invoice_currency_code = ' ||
657: p_invoice_currency_code );
658: arp_util.debug( 'p_invoicing_rule_id = ' ||
659: TO_CHAR(p_invoicing_rule_id ) );
660: arp_util.debug( 'p_last_printed_sequence_num = ' ||
661: p_last_printed_sequence_num );
662: arp_util.debug( 'p_orig_system_batch_name = ' ||
663: p_orig_system_batch_name );
664: arp_util.debug( 'p_primary_salesrep_id = ' ||
658: arp_util.debug( 'p_invoicing_rule_id = ' ||
659: TO_CHAR(p_invoicing_rule_id ) );
660: arp_util.debug( 'p_last_printed_sequence_num = ' ||
661: p_last_printed_sequence_num );
662: arp_util.debug( 'p_orig_system_batch_name = ' ||
663: p_orig_system_batch_name );
664: arp_util.debug( 'p_primary_salesrep_id = ' ||
665: TO_CHAR(p_primary_salesrep_id ) );
666: arp_util.debug( 'p_printing_count = ' ||
660: arp_util.debug( 'p_last_printed_sequence_num = ' ||
661: p_last_printed_sequence_num );
662: arp_util.debug( 'p_orig_system_batch_name = ' ||
663: p_orig_system_batch_name );
664: arp_util.debug( 'p_primary_salesrep_id = ' ||
665: TO_CHAR(p_primary_salesrep_id ) );
666: arp_util.debug( 'p_printing_count = ' ||
667: p_printing_count );
668: arp_util.debug( 'p_printing_last_printed = ' ||
662: arp_util.debug( 'p_orig_system_batch_name = ' ||
663: p_orig_system_batch_name );
664: arp_util.debug( 'p_primary_salesrep_id = ' ||
665: TO_CHAR(p_primary_salesrep_id ) );
666: arp_util.debug( 'p_printing_count = ' ||
667: p_printing_count );
668: arp_util.debug( 'p_printing_last_printed = ' ||
669: p_printing_last_printed );
670: arp_util.debug( 'p_printing_option = ' ||
664: arp_util.debug( 'p_primary_salesrep_id = ' ||
665: TO_CHAR(p_primary_salesrep_id ) );
666: arp_util.debug( 'p_printing_count = ' ||
667: p_printing_count );
668: arp_util.debug( 'p_printing_last_printed = ' ||
669: p_printing_last_printed );
670: arp_util.debug( 'p_printing_option = ' ||
671: p_printing_option );
672: arp_util.debug( 'p_printing_original_date = ' ||
666: arp_util.debug( 'p_printing_count = ' ||
667: p_printing_count );
668: arp_util.debug( 'p_printing_last_printed = ' ||
669: p_printing_last_printed );
670: arp_util.debug( 'p_printing_option = ' ||
671: p_printing_option );
672: arp_util.debug( 'p_printing_original_date = ' ||
673: p_printing_original_date );
674: arp_util.debug( 'p_printing_pending = ' ||
668: arp_util.debug( 'p_printing_last_printed = ' ||
669: p_printing_last_printed );
670: arp_util.debug( 'p_printing_option = ' ||
671: p_printing_option );
672: arp_util.debug( 'p_printing_original_date = ' ||
673: p_printing_original_date );
674: arp_util.debug( 'p_printing_pending = ' ||
675: p_printing_pending );
676: arp_util.debug( 'p_purchase_order = ' ||
670: arp_util.debug( 'p_printing_option = ' ||
671: p_printing_option );
672: arp_util.debug( 'p_printing_original_date = ' ||
673: p_printing_original_date );
674: arp_util.debug( 'p_printing_pending = ' ||
675: p_printing_pending );
676: arp_util.debug( 'p_purchase_order = ' ||
677: p_purchase_order );
678: arp_util.debug( 'p_purchase_order_date = ' ||
672: arp_util.debug( 'p_printing_original_date = ' ||
673: p_printing_original_date );
674: arp_util.debug( 'p_printing_pending = ' ||
675: p_printing_pending );
676: arp_util.debug( 'p_purchase_order = ' ||
677: p_purchase_order );
678: arp_util.debug( 'p_purchase_order_date = ' ||
679: p_purchase_order_date );
680: arp_util.debug( 'p_purchase_order_revision = ' ||
674: arp_util.debug( 'p_printing_pending = ' ||
675: p_printing_pending );
676: arp_util.debug( 'p_purchase_order = ' ||
677: p_purchase_order );
678: arp_util.debug( 'p_purchase_order_date = ' ||
679: p_purchase_order_date );
680: arp_util.debug( 'p_purchase_order_revision = ' ||
681: p_purchase_order_revision );
682: arp_util.debug( 'p_receipt_method_id = ' ||
676: arp_util.debug( 'p_purchase_order = ' ||
677: p_purchase_order );
678: arp_util.debug( 'p_purchase_order_date = ' ||
679: p_purchase_order_date );
680: arp_util.debug( 'p_purchase_order_revision = ' ||
681: p_purchase_order_revision );
682: arp_util.debug( 'p_receipt_method_id = ' ||
683: TO_CHAR(p_receipt_method_id ) );
684: arp_util.debug( 'p_remit_to_address_id = ' ||
678: arp_util.debug( 'p_purchase_order_date = ' ||
679: p_purchase_order_date );
680: arp_util.debug( 'p_purchase_order_revision = ' ||
681: p_purchase_order_revision );
682: arp_util.debug( 'p_receipt_method_id = ' ||
683: TO_CHAR(p_receipt_method_id ) );
684: arp_util.debug( 'p_remit_to_address_id = ' ||
685: TO_CHAR(p_remit_to_address_id ) );
686: arp_util.debug( 'p_shipment_id = ' ||
680: arp_util.debug( 'p_purchase_order_revision = ' ||
681: p_purchase_order_revision );
682: arp_util.debug( 'p_receipt_method_id = ' ||
683: TO_CHAR(p_receipt_method_id ) );
684: arp_util.debug( 'p_remit_to_address_id = ' ||
685: TO_CHAR(p_remit_to_address_id ) );
686: arp_util.debug( 'p_shipment_id = ' ||
687: TO_CHAR(p_shipment_id ) );
688: arp_util.debug( 'p_ship_date_actual = ' ||
682: arp_util.debug( 'p_receipt_method_id = ' ||
683: TO_CHAR(p_receipt_method_id ) );
684: arp_util.debug( 'p_remit_to_address_id = ' ||
685: TO_CHAR(p_remit_to_address_id ) );
686: arp_util.debug( 'p_shipment_id = ' ||
687: TO_CHAR(p_shipment_id ) );
688: arp_util.debug( 'p_ship_date_actual = ' ||
689: p_ship_date_actual );
690: arp_util.debug( 'p_ship_via = ' ||
684: arp_util.debug( 'p_remit_to_address_id = ' ||
685: TO_CHAR(p_remit_to_address_id ) );
686: arp_util.debug( 'p_shipment_id = ' ||
687: TO_CHAR(p_shipment_id ) );
688: arp_util.debug( 'p_ship_date_actual = ' ||
689: p_ship_date_actual );
690: arp_util.debug( 'p_ship_via = ' ||
691: p_ship_via );
692: arp_util.debug( 'p_term_due_date = ' ||
686: arp_util.debug( 'p_shipment_id = ' ||
687: TO_CHAR(p_shipment_id ) );
688: arp_util.debug( 'p_ship_date_actual = ' ||
689: p_ship_date_actual );
690: arp_util.debug( 'p_ship_via = ' ||
691: p_ship_via );
692: arp_util.debug( 'p_term_due_date = ' ||
693: p_term_due_date );
694: arp_util.debug( 'p_term_id = ' ||
688: arp_util.debug( 'p_ship_date_actual = ' ||
689: p_ship_date_actual );
690: arp_util.debug( 'p_ship_via = ' ||
691: p_ship_via );
692: arp_util.debug( 'p_term_due_date = ' ||
693: p_term_due_date );
694: arp_util.debug( 'p_term_id = ' ||
695: TO_CHAR(p_term_id ) );
696: arp_util.debug( 'p_territory_id = ' ||
690: arp_util.debug( 'p_ship_via = ' ||
691: p_ship_via );
692: arp_util.debug( 'p_term_due_date = ' ||
693: p_term_due_date );
694: arp_util.debug( 'p_term_id = ' ||
695: TO_CHAR(p_term_id ) );
696: arp_util.debug( 'p_territory_id = ' ||
697: p_territory_id );
698: arp_util.debug( 'p_waybill_number = ' ||
692: arp_util.debug( 'p_term_due_date = ' ||
693: p_term_due_date );
694: arp_util.debug( 'p_term_id = ' ||
695: TO_CHAR(p_term_id ) );
696: arp_util.debug( 'p_territory_id = ' ||
697: p_territory_id );
698: arp_util.debug( 'p_waybill_number = ' ||
699: p_waybill_number );
700: arp_util.debug( 'p_status_trx = ' ||
694: arp_util.debug( 'p_term_id = ' ||
695: TO_CHAR(p_term_id ) );
696: arp_util.debug( 'p_territory_id = ' ||
697: p_territory_id );
698: arp_util.debug( 'p_waybill_number = ' ||
699: p_waybill_number );
700: arp_util.debug( 'p_status_trx = ' ||
701: p_status_trx );
702: arp_util.debug( 'p_reason_code = ' ||
696: arp_util.debug( 'p_territory_id = ' ||
697: p_territory_id );
698: arp_util.debug( 'p_waybill_number = ' ||
699: p_waybill_number );
700: arp_util.debug( 'p_status_trx = ' ||
701: p_status_trx );
702: arp_util.debug( 'p_reason_code = ' ||
703: p_reason_code );
704: arp_util.debug( 'p_doc_sequence_id = ' ||
698: arp_util.debug( 'p_waybill_number = ' ||
699: p_waybill_number );
700: arp_util.debug( 'p_status_trx = ' ||
701: p_status_trx );
702: arp_util.debug( 'p_reason_code = ' ||
703: p_reason_code );
704: arp_util.debug( 'p_doc_sequence_id = ' ||
705: p_doc_sequence_id );
706: arp_util.debug( 'p_doc_sequence_value = ' ||
700: arp_util.debug( 'p_status_trx = ' ||
701: p_status_trx );
702: arp_util.debug( 'p_reason_code = ' ||
703: p_reason_code );
704: arp_util.debug( 'p_doc_sequence_id = ' ||
705: p_doc_sequence_id );
706: arp_util.debug( 'p_doc_sequence_value = ' ||
707: p_doc_sequence_value );
708: arp_util.debug( 'p_paying_customer_id = ' ||
702: arp_util.debug( 'p_reason_code = ' ||
703: p_reason_code );
704: arp_util.debug( 'p_doc_sequence_id = ' ||
705: p_doc_sequence_id );
706: arp_util.debug( 'p_doc_sequence_value = ' ||
707: p_doc_sequence_value );
708: arp_util.debug( 'p_paying_customer_id = ' ||
709: TO_CHAR(p_paying_customer_id ) );
710: arp_util.debug( 'p_paying_site_use_id = ' ||
704: arp_util.debug( 'p_doc_sequence_id = ' ||
705: p_doc_sequence_id );
706: arp_util.debug( 'p_doc_sequence_value = ' ||
707: p_doc_sequence_value );
708: arp_util.debug( 'p_paying_customer_id = ' ||
709: TO_CHAR(p_paying_customer_id ) );
710: arp_util.debug( 'p_paying_site_use_id = ' ||
711: TO_CHAR(p_paying_site_use_id ) );
712: arp_util.debug( 'p_related_batch_source_id = ' ||
706: arp_util.debug( 'p_doc_sequence_value = ' ||
707: p_doc_sequence_value );
708: arp_util.debug( 'p_paying_customer_id = ' ||
709: TO_CHAR(p_paying_customer_id ) );
710: arp_util.debug( 'p_paying_site_use_id = ' ||
711: TO_CHAR(p_paying_site_use_id ) );
712: arp_util.debug( 'p_related_batch_source_id = ' ||
713: p_related_batch_source_id );
714: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
708: arp_util.debug( 'p_paying_customer_id = ' ||
709: TO_CHAR(p_paying_customer_id ) );
710: arp_util.debug( 'p_paying_site_use_id = ' ||
711: TO_CHAR(p_paying_site_use_id ) );
712: arp_util.debug( 'p_related_batch_source_id = ' ||
713: p_related_batch_source_id );
714: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
715: p_default_tax_exempt_flag );
716: arp_util.debug( 'p_created_from = ' ||
710: arp_util.debug( 'p_paying_site_use_id = ' ||
711: TO_CHAR(p_paying_site_use_id ) );
712: arp_util.debug( 'p_related_batch_source_id = ' ||
713: p_related_batch_source_id );
714: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
715: p_default_tax_exempt_flag );
716: arp_util.debug( 'p_created_from = ' ||
717: p_created_from );
718: arp_util.debug( 'p_ps_dispute_amount = ' ||
712: arp_util.debug( 'p_related_batch_source_id = ' ||
713: p_related_batch_source_id );
714: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
715: p_default_tax_exempt_flag );
716: arp_util.debug( 'p_created_from = ' ||
717: p_created_from );
718: arp_util.debug( 'p_ps_dispute_amount = ' ||
719: p_ps_dispute_amount );
720: arp_util.debug( 'p_ps_dispute_date = ' ||
714: arp_util.debug( 'p_default_tax_exempt_flag = ' ||
715: p_default_tax_exempt_flag );
716: arp_util.debug( 'p_created_from = ' ||
717: p_created_from );
718: arp_util.debug( 'p_ps_dispute_amount = ' ||
719: p_ps_dispute_amount );
720: arp_util.debug( 'p_ps_dispute_date = ' ||
721: p_ps_dispute_date );
722: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
716: arp_util.debug( 'p_created_from = ' ||
717: p_created_from );
718: arp_util.debug( 'p_ps_dispute_amount = ' ||
719: p_ps_dispute_amount );
720: arp_util.debug( 'p_ps_dispute_date = ' ||
721: p_ps_dispute_date );
722: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
723: p_deflt_ussgl_trx_code_context );
724: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
718: arp_util.debug( 'p_ps_dispute_amount = ' ||
719: p_ps_dispute_amount );
720: arp_util.debug( 'p_ps_dispute_date = ' ||
721: p_ps_dispute_date );
722: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
723: p_deflt_ussgl_trx_code_context );
724: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
725: p_deflt_ussgl_transaction_code );
726: arp_util.debug( 'p_old_trx_number = ' ||
720: arp_util.debug( 'p_ps_dispute_date = ' ||
721: p_ps_dispute_date );
722: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
723: p_deflt_ussgl_trx_code_context );
724: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
725: p_deflt_ussgl_transaction_code );
726: arp_util.debug( 'p_old_trx_number = ' ||
727: p_old_trx_number );
728: arp_util.debug( 'p_interface_header_context = ' ||
722: arp_util.debug( 'p_deflt_ussgl_trx_code_context = ' ||
723: p_deflt_ussgl_trx_code_context );
724: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
725: p_deflt_ussgl_transaction_code );
726: arp_util.debug( 'p_old_trx_number = ' ||
727: p_old_trx_number );
728: arp_util.debug( 'p_interface_header_context = ' ||
729: p_interface_header_context );
730: arp_util.debug( 'p_interface_header_attribute1 = ' ||
724: arp_util.debug( 'p_deflt_ussgl_transaction_code = ' ||
725: p_deflt_ussgl_transaction_code );
726: arp_util.debug( 'p_old_trx_number = ' ||
727: p_old_trx_number );
728: arp_util.debug( 'p_interface_header_context = ' ||
729: p_interface_header_context );
730: arp_util.debug( 'p_interface_header_attribute1 = ' ||
731: p_interface_header_attribute1 );
732: arp_util.debug( 'p_interface_header_attribute2 = ' ||
726: arp_util.debug( 'p_old_trx_number = ' ||
727: p_old_trx_number );
728: arp_util.debug( 'p_interface_header_context = ' ||
729: p_interface_header_context );
730: arp_util.debug( 'p_interface_header_attribute1 = ' ||
731: p_interface_header_attribute1 );
732: arp_util.debug( 'p_interface_header_attribute2 = ' ||
733: p_interface_header_attribute2 );
734: arp_util.debug( 'p_interface_header_attribute3 = ' ||
728: arp_util.debug( 'p_interface_header_context = ' ||
729: p_interface_header_context );
730: arp_util.debug( 'p_interface_header_attribute1 = ' ||
731: p_interface_header_attribute1 );
732: arp_util.debug( 'p_interface_header_attribute2 = ' ||
733: p_interface_header_attribute2 );
734: arp_util.debug( 'p_interface_header_attribute3 = ' ||
735: p_interface_header_attribute3 );
736: arp_util.debug( 'p_interface_header_attribute4 = ' ||
730: arp_util.debug( 'p_interface_header_attribute1 = ' ||
731: p_interface_header_attribute1 );
732: arp_util.debug( 'p_interface_header_attribute2 = ' ||
733: p_interface_header_attribute2 );
734: arp_util.debug( 'p_interface_header_attribute3 = ' ||
735: p_interface_header_attribute3 );
736: arp_util.debug( 'p_interface_header_attribute4 = ' ||
737: p_interface_header_attribute4 );
738: arp_util.debug( 'p_interface_header_attribute5 = ' ||
732: arp_util.debug( 'p_interface_header_attribute2 = ' ||
733: p_interface_header_attribute2 );
734: arp_util.debug( 'p_interface_header_attribute3 = ' ||
735: p_interface_header_attribute3 );
736: arp_util.debug( 'p_interface_header_attribute4 = ' ||
737: p_interface_header_attribute4 );
738: arp_util.debug( 'p_interface_header_attribute5 = ' ||
739: p_interface_header_attribute5 );
740: arp_util.debug( 'p_interface_header_attribute6 = ' ||
734: arp_util.debug( 'p_interface_header_attribute3 = ' ||
735: p_interface_header_attribute3 );
736: arp_util.debug( 'p_interface_header_attribute4 = ' ||
737: p_interface_header_attribute4 );
738: arp_util.debug( 'p_interface_header_attribute5 = ' ||
739: p_interface_header_attribute5 );
740: arp_util.debug( 'p_interface_header_attribute6 = ' ||
741: p_interface_header_attribute6 );
742: arp_util.debug( 'p_interface_header_attribute7 = ' ||
736: arp_util.debug( 'p_interface_header_attribute4 = ' ||
737: p_interface_header_attribute4 );
738: arp_util.debug( 'p_interface_header_attribute5 = ' ||
739: p_interface_header_attribute5 );
740: arp_util.debug( 'p_interface_header_attribute6 = ' ||
741: p_interface_header_attribute6 );
742: arp_util.debug( 'p_interface_header_attribute7 = ' ||
743: p_interface_header_attribute7 );
744: arp_util.debug( 'p_interface_header_attribute8 = ' ||
738: arp_util.debug( 'p_interface_header_attribute5 = ' ||
739: p_interface_header_attribute5 );
740: arp_util.debug( 'p_interface_header_attribute6 = ' ||
741: p_interface_header_attribute6 );
742: arp_util.debug( 'p_interface_header_attribute7 = ' ||
743: p_interface_header_attribute7 );
744: arp_util.debug( 'p_interface_header_attribute8 = ' ||
745: p_interface_header_attribute8 );
746: arp_util.debug( 'p_interface_header_attribute9 = ' ||
740: arp_util.debug( 'p_interface_header_attribute6 = ' ||
741: p_interface_header_attribute6 );
742: arp_util.debug( 'p_interface_header_attribute7 = ' ||
743: p_interface_header_attribute7 );
744: arp_util.debug( 'p_interface_header_attribute8 = ' ||
745: p_interface_header_attribute8 );
746: arp_util.debug( 'p_interface_header_attribute9 = ' ||
747: p_interface_header_attribute9 );
748: arp_util.debug( 'p_interface_header_attribute10 = ' ||
742: arp_util.debug( 'p_interface_header_attribute7 = ' ||
743: p_interface_header_attribute7 );
744: arp_util.debug( 'p_interface_header_attribute8 = ' ||
745: p_interface_header_attribute8 );
746: arp_util.debug( 'p_interface_header_attribute9 = ' ||
747: p_interface_header_attribute9 );
748: arp_util.debug( 'p_interface_header_attribute10 = ' ||
749: p_interface_header_attribute10 );
750: arp_util.debug( 'p_interface_header_attribute11 = ' ||
744: arp_util.debug( 'p_interface_header_attribute8 = ' ||
745: p_interface_header_attribute8 );
746: arp_util.debug( 'p_interface_header_attribute9 = ' ||
747: p_interface_header_attribute9 );
748: arp_util.debug( 'p_interface_header_attribute10 = ' ||
749: p_interface_header_attribute10 );
750: arp_util.debug( 'p_interface_header_attribute11 = ' ||
751: p_interface_header_attribute11 );
752: arp_util.debug( 'p_interface_header_attribute12 = ' ||
746: arp_util.debug( 'p_interface_header_attribute9 = ' ||
747: p_interface_header_attribute9 );
748: arp_util.debug( 'p_interface_header_attribute10 = ' ||
749: p_interface_header_attribute10 );
750: arp_util.debug( 'p_interface_header_attribute11 = ' ||
751: p_interface_header_attribute11 );
752: arp_util.debug( 'p_interface_header_attribute12 = ' ||
753: p_interface_header_attribute12 );
754: arp_util.debug( 'p_interface_header_attribute13 = ' ||
748: arp_util.debug( 'p_interface_header_attribute10 = ' ||
749: p_interface_header_attribute10 );
750: arp_util.debug( 'p_interface_header_attribute11 = ' ||
751: p_interface_header_attribute11 );
752: arp_util.debug( 'p_interface_header_attribute12 = ' ||
753: p_interface_header_attribute12 );
754: arp_util.debug( 'p_interface_header_attribute13 = ' ||
755: p_interface_header_attribute13 );
756: arp_util.debug( 'p_interface_header_attribute14 = ' ||
750: arp_util.debug( 'p_interface_header_attribute11 = ' ||
751: p_interface_header_attribute11 );
752: arp_util.debug( 'p_interface_header_attribute12 = ' ||
753: p_interface_header_attribute12 );
754: arp_util.debug( 'p_interface_header_attribute13 = ' ||
755: p_interface_header_attribute13 );
756: arp_util.debug( 'p_interface_header_attribute14 = ' ||
757: p_interface_header_attribute14 );
758: arp_util.debug( 'p_interface_header_attribute15 = ' ||
752: arp_util.debug( 'p_interface_header_attribute12 = ' ||
753: p_interface_header_attribute12 );
754: arp_util.debug( 'p_interface_header_attribute13 = ' ||
755: p_interface_header_attribute13 );
756: arp_util.debug( 'p_interface_header_attribute14 = ' ||
757: p_interface_header_attribute14 );
758: arp_util.debug( 'p_interface_header_attribute15 = ' ||
759: p_interface_header_attribute15 );
760: arp_util.debug( 'p_attribute_category = ' ||
754: arp_util.debug( 'p_interface_header_attribute13 = ' ||
755: p_interface_header_attribute13 );
756: arp_util.debug( 'p_interface_header_attribute14 = ' ||
757: p_interface_header_attribute14 );
758: arp_util.debug( 'p_interface_header_attribute15 = ' ||
759: p_interface_header_attribute15 );
760: arp_util.debug( 'p_attribute_category = ' ||
761: p_attribute_category );
762: arp_util.debug( 'p_attribute1 = ' ||
756: arp_util.debug( 'p_interface_header_attribute14 = ' ||
757: p_interface_header_attribute14 );
758: arp_util.debug( 'p_interface_header_attribute15 = ' ||
759: p_interface_header_attribute15 );
760: arp_util.debug( 'p_attribute_category = ' ||
761: p_attribute_category );
762: arp_util.debug( 'p_attribute1 = ' ||
763: p_attribute1 );
764: arp_util.debug( 'p_attribute2 = ' ||
758: arp_util.debug( 'p_interface_header_attribute15 = ' ||
759: p_interface_header_attribute15 );
760: arp_util.debug( 'p_attribute_category = ' ||
761: p_attribute_category );
762: arp_util.debug( 'p_attribute1 = ' ||
763: p_attribute1 );
764: arp_util.debug( 'p_attribute2 = ' ||
765: p_attribute2 );
766: arp_util.debug( 'p_attribute3 = ' ||
760: arp_util.debug( 'p_attribute_category = ' ||
761: p_attribute_category );
762: arp_util.debug( 'p_attribute1 = ' ||
763: p_attribute1 );
764: arp_util.debug( 'p_attribute2 = ' ||
765: p_attribute2 );
766: arp_util.debug( 'p_attribute3 = ' ||
767: p_attribute3 );
768: arp_util.debug( 'p_attribute4 = ' ||
762: arp_util.debug( 'p_attribute1 = ' ||
763: p_attribute1 );
764: arp_util.debug( 'p_attribute2 = ' ||
765: p_attribute2 );
766: arp_util.debug( 'p_attribute3 = ' ||
767: p_attribute3 );
768: arp_util.debug( 'p_attribute4 = ' ||
769: p_attribute4 );
770: arp_util.debug( 'p_attribute5 = ' ||
764: arp_util.debug( 'p_attribute2 = ' ||
765: p_attribute2 );
766: arp_util.debug( 'p_attribute3 = ' ||
767: p_attribute3 );
768: arp_util.debug( 'p_attribute4 = ' ||
769: p_attribute4 );
770: arp_util.debug( 'p_attribute5 = ' ||
771: p_attribute5 );
772: arp_util.debug( 'p_attribute6 = ' ||
766: arp_util.debug( 'p_attribute3 = ' ||
767: p_attribute3 );
768: arp_util.debug( 'p_attribute4 = ' ||
769: p_attribute4 );
770: arp_util.debug( 'p_attribute5 = ' ||
771: p_attribute5 );
772: arp_util.debug( 'p_attribute6 = ' ||
773: p_attribute6 );
774: arp_util.debug( 'p_attribute7 = ' ||
768: arp_util.debug( 'p_attribute4 = ' ||
769: p_attribute4 );
770: arp_util.debug( 'p_attribute5 = ' ||
771: p_attribute5 );
772: arp_util.debug( 'p_attribute6 = ' ||
773: p_attribute6 );
774: arp_util.debug( 'p_attribute7 = ' ||
775: p_attribute7 );
776: arp_util.debug( 'p_attribute8 = ' ||
770: arp_util.debug( 'p_attribute5 = ' ||
771: p_attribute5 );
772: arp_util.debug( 'p_attribute6 = ' ||
773: p_attribute6 );
774: arp_util.debug( 'p_attribute7 = ' ||
775: p_attribute7 );
776: arp_util.debug( 'p_attribute8 = ' ||
777: p_attribute8 );
778: arp_util.debug( 'p_attribute9 = ' ||
772: arp_util.debug( 'p_attribute6 = ' ||
773: p_attribute6 );
774: arp_util.debug( 'p_attribute7 = ' ||
775: p_attribute7 );
776: arp_util.debug( 'p_attribute8 = ' ||
777: p_attribute8 );
778: arp_util.debug( 'p_attribute9 = ' ||
779: p_attribute9 );
780: arp_util.debug( 'p_attribute10 = ' ||
774: arp_util.debug( 'p_attribute7 = ' ||
775: p_attribute7 );
776: arp_util.debug( 'p_attribute8 = ' ||
777: p_attribute8 );
778: arp_util.debug( 'p_attribute9 = ' ||
779: p_attribute9 );
780: arp_util.debug( 'p_attribute10 = ' ||
781: p_attribute10 );
782: arp_util.debug( 'p_attribute11 = ' ||
776: arp_util.debug( 'p_attribute8 = ' ||
777: p_attribute8 );
778: arp_util.debug( 'p_attribute9 = ' ||
779: p_attribute9 );
780: arp_util.debug( 'p_attribute10 = ' ||
781: p_attribute10 );
782: arp_util.debug( 'p_attribute11 = ' ||
783: p_attribute11 );
784: arp_util.debug( 'p_attribute12 = ' ||
778: arp_util.debug( 'p_attribute9 = ' ||
779: p_attribute9 );
780: arp_util.debug( 'p_attribute10 = ' ||
781: p_attribute10 );
782: arp_util.debug( 'p_attribute11 = ' ||
783: p_attribute11 );
784: arp_util.debug( 'p_attribute12 = ' ||
785: p_attribute12 );
786: arp_util.debug( 'p_attribute13 = ' ||
780: arp_util.debug( 'p_attribute10 = ' ||
781: p_attribute10 );
782: arp_util.debug( 'p_attribute11 = ' ||
783: p_attribute11 );
784: arp_util.debug( 'p_attribute12 = ' ||
785: p_attribute12 );
786: arp_util.debug( 'p_attribute13 = ' ||
787: p_attribute13 );
788: arp_util.debug( 'p_attribute14 = ' ||
782: arp_util.debug( 'p_attribute11 = ' ||
783: p_attribute11 );
784: arp_util.debug( 'p_attribute12 = ' ||
785: p_attribute12 );
786: arp_util.debug( 'p_attribute13 = ' ||
787: p_attribute13 );
788: arp_util.debug( 'p_attribute14 = ' ||
789: p_attribute14 );
790: arp_util.debug( 'p_attribute15 = ' ||
784: arp_util.debug( 'p_attribute12 = ' ||
785: p_attribute12 );
786: arp_util.debug( 'p_attribute13 = ' ||
787: p_attribute13 );
788: arp_util.debug( 'p_attribute14 = ' ||
789: p_attribute14 );
790: arp_util.debug( 'p_attribute15 = ' ||
791: p_attribute15 );
792: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
786: arp_util.debug( 'p_attribute13 = ' ||
787: p_attribute13 );
788: arp_util.debug( 'p_attribute14 = ' ||
789: p_attribute14 );
790: arp_util.debug( 'p_attribute15 = ' ||
791: p_attribute15 );
792: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
793: TO_CHAR(p_commit_customer_trx_line_id ) );
794: arp_util.debug( 'p_commit_inventory_item_id = ' ||
788: arp_util.debug( 'p_attribute14 = ' ||
789: p_attribute14 );
790: arp_util.debug( 'p_attribute15 = ' ||
791: p_attribute15 );
792: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
793: TO_CHAR(p_commit_customer_trx_line_id ) );
794: arp_util.debug( 'p_commit_inventory_item_id = ' ||
795: TO_CHAR(p_commit_inventory_item_id ) );
796: arp_util.debug( 'p_commit_memo_line_id = ' ||
790: arp_util.debug( 'p_attribute15 = ' ||
791: p_attribute15 );
792: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
793: TO_CHAR(p_commit_customer_trx_line_id ) );
794: arp_util.debug( 'p_commit_inventory_item_id = ' ||
795: TO_CHAR(p_commit_inventory_item_id ) );
796: arp_util.debug( 'p_commit_memo_line_id = ' ||
797: TO_CHAR(p_commit_memo_line_id ) );
798: arp_util.debug( 'p_commit_description = ' ||
792: arp_util.debug( 'p_commit_customer_trx_line_id = ' ||
793: TO_CHAR(p_commit_customer_trx_line_id ) );
794: arp_util.debug( 'p_commit_inventory_item_id = ' ||
795: TO_CHAR(p_commit_inventory_item_id ) );
796: arp_util.debug( 'p_commit_memo_line_id = ' ||
797: TO_CHAR(p_commit_memo_line_id ) );
798: arp_util.debug( 'p_commit_description = ' ||
799: p_commit_description );
800: arp_util.debug( 'p_commit_extended_amount = ' ||
794: arp_util.debug( 'p_commit_inventory_item_id = ' ||
795: TO_CHAR(p_commit_inventory_item_id ) );
796: arp_util.debug( 'p_commit_memo_line_id = ' ||
797: TO_CHAR(p_commit_memo_line_id ) );
798: arp_util.debug( 'p_commit_description = ' ||
799: p_commit_description );
800: arp_util.debug( 'p_commit_extended_amount = ' ||
801: p_commit_extended_amount );
802: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
796: arp_util.debug( 'p_commit_memo_line_id = ' ||
797: TO_CHAR(p_commit_memo_line_id ) );
798: arp_util.debug( 'p_commit_description = ' ||
799: p_commit_description );
800: arp_util.debug( 'p_commit_extended_amount = ' ||
801: p_commit_extended_amount );
802: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
803: p_commit_interface_line_attr1 );
804: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
798: arp_util.debug( 'p_commit_description = ' ||
799: p_commit_description );
800: arp_util.debug( 'p_commit_extended_amount = ' ||
801: p_commit_extended_amount );
802: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
803: p_commit_interface_line_attr1 );
804: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
805: p_commit_interface_line_attr2 );
806: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
800: arp_util.debug( 'p_commit_extended_amount = ' ||
801: p_commit_extended_amount );
802: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
803: p_commit_interface_line_attr1 );
804: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
805: p_commit_interface_line_attr2 );
806: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
807: p_commit_interface_line_attr3 );
808: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
802: arp_util.debug( 'p_commit_interface_line_attr1 = ' ||
803: p_commit_interface_line_attr1 );
804: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
805: p_commit_interface_line_attr2 );
806: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
807: p_commit_interface_line_attr3 );
808: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
809: p_commit_interface_line_attr4 );
810: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
804: arp_util.debug( 'p_commit_interface_line_attr2 = ' ||
805: p_commit_interface_line_attr2 );
806: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
807: p_commit_interface_line_attr3 );
808: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
809: p_commit_interface_line_attr4 );
810: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
811: p_commit_interface_line_attr5 );
812: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
806: arp_util.debug( 'p_commit_interface_line_attr3 = ' ||
807: p_commit_interface_line_attr3 );
808: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
809: p_commit_interface_line_attr4 );
810: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
811: p_commit_interface_line_attr5 );
812: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
813: p_commit_interface_line_attr6 );
814: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
808: arp_util.debug( 'p_commit_interface_line_attr4 = ' ||
809: p_commit_interface_line_attr4 );
810: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
811: p_commit_interface_line_attr5 );
812: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
813: p_commit_interface_line_attr6 );
814: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
815: p_commit_interface_line_attr7 );
816: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
810: arp_util.debug( 'p_commit_interface_line_attr5 = ' ||
811: p_commit_interface_line_attr5 );
812: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
813: p_commit_interface_line_attr6 );
814: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
815: p_commit_interface_line_attr7 );
816: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
817: p_commit_interface_line_attr8 );
818: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
812: arp_util.debug( 'p_commit_interface_line_attr6 = ' ||
813: p_commit_interface_line_attr6 );
814: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
815: p_commit_interface_line_attr7 );
816: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
817: p_commit_interface_line_attr8 );
818: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
819: p_commit_interface_line_attr9 );
820: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
814: arp_util.debug( 'p_commit_interface_line_attr7 = ' ||
815: p_commit_interface_line_attr7 );
816: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
817: p_commit_interface_line_attr8 );
818: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
819: p_commit_interface_line_attr9 );
820: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
821: p_commit_interface_line_attr10 );
822: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
816: arp_util.debug( 'p_commit_interface_line_attr8 = ' ||
817: p_commit_interface_line_attr8 );
818: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
819: p_commit_interface_line_attr9 );
820: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
821: p_commit_interface_line_attr10 );
822: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
823: p_commit_interface_line_attr11 );
824: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
818: arp_util.debug( 'p_commit_interface_line_attr9 = ' ||
819: p_commit_interface_line_attr9 );
820: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
821: p_commit_interface_line_attr10 );
822: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
823: p_commit_interface_line_attr11 );
824: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
825: p_commit_interface_line_attr12 );
826: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
820: arp_util.debug( 'p_commit_interface_line_attr10 = ' ||
821: p_commit_interface_line_attr10 );
822: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
823: p_commit_interface_line_attr11 );
824: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
825: p_commit_interface_line_attr12 );
826: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
827: p_commit_interface_line_attr13 );
828: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
822: arp_util.debug( 'p_commit_interface_line_attr11 = ' ||
823: p_commit_interface_line_attr11 );
824: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
825: p_commit_interface_line_attr12 );
826: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
827: p_commit_interface_line_attr13 );
828: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
829: p_commit_interface_line_attr14 );
830: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
824: arp_util.debug( 'p_commit_interface_line_attr12 = ' ||
825: p_commit_interface_line_attr12 );
826: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
827: p_commit_interface_line_attr13 );
828: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
829: p_commit_interface_line_attr14 );
830: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
831: p_commit_interface_line_attr15 );
832: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
826: arp_util.debug( 'p_commit_interface_line_attr13 = ' ||
827: p_commit_interface_line_attr13 );
828: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
829: p_commit_interface_line_attr14 );
830: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
831: p_commit_interface_line_attr15 );
832: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
833: p_commit_interface_line_contxt );
834: arp_util.debug( 'p_commit_attribute_category = ' ||
828: arp_util.debug( 'p_commit_interface_line_attr14 = ' ||
829: p_commit_interface_line_attr14 );
830: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
831: p_commit_interface_line_attr15 );
832: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
833: p_commit_interface_line_contxt );
834: arp_util.debug( 'p_commit_attribute_category = ' ||
835: p_commit_attribute_category );
836: arp_util.debug( 'p_commit_attribute1 = ' ||
830: arp_util.debug( 'p_commit_interface_line_attr15 = ' ||
831: p_commit_interface_line_attr15 );
832: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
833: p_commit_interface_line_contxt );
834: arp_util.debug( 'p_commit_attribute_category = ' ||
835: p_commit_attribute_category );
836: arp_util.debug( 'p_commit_attribute1 = ' ||
837: p_commit_attribute1 );
838: arp_util.debug( 'p_commit_attribute2 = ' ||
832: arp_util.debug( 'p_commit_interface_line_contxt = ' ||
833: p_commit_interface_line_contxt );
834: arp_util.debug( 'p_commit_attribute_category = ' ||
835: p_commit_attribute_category );
836: arp_util.debug( 'p_commit_attribute1 = ' ||
837: p_commit_attribute1 );
838: arp_util.debug( 'p_commit_attribute2 = ' ||
839: p_commit_attribute2 );
840: arp_util.debug( 'p_commit_attribute3 = ' ||
834: arp_util.debug( 'p_commit_attribute_category = ' ||
835: p_commit_attribute_category );
836: arp_util.debug( 'p_commit_attribute1 = ' ||
837: p_commit_attribute1 );
838: arp_util.debug( 'p_commit_attribute2 = ' ||
839: p_commit_attribute2 );
840: arp_util.debug( 'p_commit_attribute3 = ' ||
841: p_commit_attribute3 );
842: arp_util.debug( 'p_commit_attribute4 = ' ||
836: arp_util.debug( 'p_commit_attribute1 = ' ||
837: p_commit_attribute1 );
838: arp_util.debug( 'p_commit_attribute2 = ' ||
839: p_commit_attribute2 );
840: arp_util.debug( 'p_commit_attribute3 = ' ||
841: p_commit_attribute3 );
842: arp_util.debug( 'p_commit_attribute4 = ' ||
843: p_commit_attribute4 );
844: arp_util.debug( 'p_commit_attribute5 = ' ||
838: arp_util.debug( 'p_commit_attribute2 = ' ||
839: p_commit_attribute2 );
840: arp_util.debug( 'p_commit_attribute3 = ' ||
841: p_commit_attribute3 );
842: arp_util.debug( 'p_commit_attribute4 = ' ||
843: p_commit_attribute4 );
844: arp_util.debug( 'p_commit_attribute5 = ' ||
845: p_commit_attribute5 );
846: arp_util.debug( 'p_commit_attribute6 = ' ||
840: arp_util.debug( 'p_commit_attribute3 = ' ||
841: p_commit_attribute3 );
842: arp_util.debug( 'p_commit_attribute4 = ' ||
843: p_commit_attribute4 );
844: arp_util.debug( 'p_commit_attribute5 = ' ||
845: p_commit_attribute5 );
846: arp_util.debug( 'p_commit_attribute6 = ' ||
847: p_commit_attribute6 );
848: arp_util.debug( 'p_commit_attribute7 = ' ||
842: arp_util.debug( 'p_commit_attribute4 = ' ||
843: p_commit_attribute4 );
844: arp_util.debug( 'p_commit_attribute5 = ' ||
845: p_commit_attribute5 );
846: arp_util.debug( 'p_commit_attribute6 = ' ||
847: p_commit_attribute6 );
848: arp_util.debug( 'p_commit_attribute7 = ' ||
849: p_commit_attribute7 );
850: arp_util.debug( 'p_commit_attribute8 = ' ||
844: arp_util.debug( 'p_commit_attribute5 = ' ||
845: p_commit_attribute5 );
846: arp_util.debug( 'p_commit_attribute6 = ' ||
847: p_commit_attribute6 );
848: arp_util.debug( 'p_commit_attribute7 = ' ||
849: p_commit_attribute7 );
850: arp_util.debug( 'p_commit_attribute8 = ' ||
851: p_commit_attribute8 );
852: arp_util.debug( 'p_commit_attribute9 = ' ||
846: arp_util.debug( 'p_commit_attribute6 = ' ||
847: p_commit_attribute6 );
848: arp_util.debug( 'p_commit_attribute7 = ' ||
849: p_commit_attribute7 );
850: arp_util.debug( 'p_commit_attribute8 = ' ||
851: p_commit_attribute8 );
852: arp_util.debug( 'p_commit_attribute9 = ' ||
853: p_commit_attribute9 );
854: arp_util.debug( 'p_commit_attribute10 = ' ||
848: arp_util.debug( 'p_commit_attribute7 = ' ||
849: p_commit_attribute7 );
850: arp_util.debug( 'p_commit_attribute8 = ' ||
851: p_commit_attribute8 );
852: arp_util.debug( 'p_commit_attribute9 = ' ||
853: p_commit_attribute9 );
854: arp_util.debug( 'p_commit_attribute10 = ' ||
855: p_commit_attribute10 );
856: arp_util.debug( 'p_commit_attribute11 = ' ||
850: arp_util.debug( 'p_commit_attribute8 = ' ||
851: p_commit_attribute8 );
852: arp_util.debug( 'p_commit_attribute9 = ' ||
853: p_commit_attribute9 );
854: arp_util.debug( 'p_commit_attribute10 = ' ||
855: p_commit_attribute10 );
856: arp_util.debug( 'p_commit_attribute11 = ' ||
857: p_commit_attribute11 );
858: arp_util.debug( 'p_commit_attribute12 = ' ||
852: arp_util.debug( 'p_commit_attribute9 = ' ||
853: p_commit_attribute9 );
854: arp_util.debug( 'p_commit_attribute10 = ' ||
855: p_commit_attribute10 );
856: arp_util.debug( 'p_commit_attribute11 = ' ||
857: p_commit_attribute11 );
858: arp_util.debug( 'p_commit_attribute12 = ' ||
859: p_commit_attribute12 );
860: arp_util.debug( 'p_commit_attribute13 = ' ||
854: arp_util.debug( 'p_commit_attribute10 = ' ||
855: p_commit_attribute10 );
856: arp_util.debug( 'p_commit_attribute11 = ' ||
857: p_commit_attribute11 );
858: arp_util.debug( 'p_commit_attribute12 = ' ||
859: p_commit_attribute12 );
860: arp_util.debug( 'p_commit_attribute13 = ' ||
861: p_commit_attribute13 );
862: arp_util.debug( 'p_commit_attribute14 = ' ||
856: arp_util.debug( 'p_commit_attribute11 = ' ||
857: p_commit_attribute11 );
858: arp_util.debug( 'p_commit_attribute12 = ' ||
859: p_commit_attribute12 );
860: arp_util.debug( 'p_commit_attribute13 = ' ||
861: p_commit_attribute13 );
862: arp_util.debug( 'p_commit_attribute14 = ' ||
863: p_commit_attribute14 );
864: arp_util.debug( 'p_commit_attribute15 = ' ||
858: arp_util.debug( 'p_commit_attribute12 = ' ||
859: p_commit_attribute12 );
860: arp_util.debug( 'p_commit_attribute13 = ' ||
861: p_commit_attribute13 );
862: arp_util.debug( 'p_commit_attribute14 = ' ||
863: p_commit_attribute14 );
864: arp_util.debug( 'p_commit_attribute15 = ' ||
865: p_commit_attribute15 );
866: arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
860: arp_util.debug( 'p_commit_attribute13 = ' ||
861: p_commit_attribute13 );
862: arp_util.debug( 'p_commit_attribute14 = ' ||
863: p_commit_attribute14 );
864: arp_util.debug( 'p_commit_attribute15 = ' ||
865: p_commit_attribute15 );
866: arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
867: p_ctl_default_ussgl_trx_code );
868: END IF;
862: arp_util.debug( 'p_commit_attribute14 = ' ||
863: p_commit_attribute14 );
864: arp_util.debug( 'p_commit_attribute15 = ' ||
865: p_commit_attribute15 );
866: arp_util.debug( 'p_ctl_default_ussgl_trx_code = ' ||
867: p_ctl_default_ussgl_trx_code );
868: END IF;
869:
870: --{BUG#4897183
897: p_curr_trx_date => l_trx_date,
898: p_transaction_date => p_trx_date,
899: x_event_id => x_event_id);
900:
901: arp_util.debug( 'x_event_id = ' ||x_event_id );
902: END IF;
903: --}
904:
905:
962: END IF; -- END IF for p_complete_flag chack
963:
964: IF PG_DEBUG in ('Y','C')
965: THEN
966: arp_util.debug('Header exists (lf = TRUE) ');
967: arp_util.debug(' old term_id = ' || l_term_id);
968: arp_util.debug(' new term_id = ' || p_term_id);
969: arp_util.debug(' old_gl_date = ' || l_gl_date);
970: arp_util.debug(' new_gl_date = ' || p_gl_date);
963:
964: IF PG_DEBUG in ('Y','C')
965: THEN
966: arp_util.debug('Header exists (lf = TRUE) ');
967: arp_util.debug(' old term_id = ' || l_term_id);
968: arp_util.debug(' new term_id = ' || p_term_id);
969: arp_util.debug(' old_gl_date = ' || l_gl_date);
970: arp_util.debug(' new_gl_date = ' || p_gl_date);
971: END IF;
964: IF PG_DEBUG in ('Y','C')
965: THEN
966: arp_util.debug('Header exists (lf = TRUE) ');
967: arp_util.debug(' old term_id = ' || l_term_id);
968: arp_util.debug(' new term_id = ' || p_term_id);
969: arp_util.debug(' old_gl_date = ' || l_gl_date);
970: arp_util.debug(' new_gl_date = ' || p_gl_date);
971: END IF;
972:
965: THEN
966: arp_util.debug('Header exists (lf = TRUE) ');
967: arp_util.debug(' old term_id = ' || l_term_id);
968: arp_util.debug(' new term_id = ' || p_term_id);
969: arp_util.debug(' old_gl_date = ' || l_gl_date);
970: arp_util.debug(' new_gl_date = ' || p_gl_date);
971: END IF;
972:
973: IF NVL(p_term_id, l_term_id) <> l_term_id
966: arp_util.debug('Header exists (lf = TRUE) ');
967: arp_util.debug(' old term_id = ' || l_term_id);
968: arp_util.debug(' new term_id = ' || p_term_id);
969: arp_util.debug(' old_gl_date = ' || l_gl_date);
970: arp_util.debug(' new_gl_date = ' || p_gl_date);
971: END IF;
972:
973: IF NVL(p_term_id, l_term_id) <> l_term_id
974: THEN
992: When the payment term is changed for a completed
993: transaction, ETAX validate_for_tax should be called */
994:
995: IF PG_DEBUG in ('Y', 'C') THEN
996: arp_util.debug('l_db_complete_flag = '||l_db_complete_flag);
997: END IF;
998:
999: IF l_db_complete_flag = 'Y' AND p_complete_flag = 'Y' THEN
1000:
1004: p_valid_for_tax => l_tax_validation_status,
1005: p_number_of_errors=> l_error_count);
1006:
1007: IF PG_DEBUG in ('Y', 'C') THEN
1008: arp_util.debug('num of etax validation errors = '||l_error_count);
1009: END IF;
1010:
1011: END IF;
1012:
1023: NULL,
1024: 'Y');
1025: IF l_return_status > 0
1026: THEN
1027: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
1028: l_return_status);
1029: arp_util.debug('Please review the plsql debug log for additional details.');
1030: p_status := 'SYNCH_DOC_SEQ_ERROR';
1031: END IF;
1025: IF l_return_status > 0
1026: THEN
1027: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
1028: l_return_status);
1029: arp_util.debug('Please review the plsql debug log for additional details.');
1030: p_status := 'SYNCH_DOC_SEQ_ERROR';
1031: END IF;
1032: ELSE
1033: /* execute synchronize w/out line update */
1039: arp_etax_util.synchronize_for_doc_seq(p_customer_trx_id,l_return_status);
1040:
1041: IF l_return_status > 0
1042: THEN
1043: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
1044: l_return_status);
1045: arp_util.debug('Please review the plsql debug log for additional details.');
1046: p_status := 'SYNCH_DOC_SEQ_ERROR';
1047: END IF;
1041: IF l_return_status > 0
1042: THEN
1043: arp_util.debug('EXCEPTION: error calling eBusiness Tax, status = ' ||
1044: l_return_status);
1045: arp_util.debug('Please review the plsql debug log for additional details.');
1046: p_status := 'SYNCH_DOC_SEQ_ERROR';
1047: END IF;
1048: END IF;
1049: END IF;
1048: END IF;
1049: END IF;
1050:
1051: IF PG_DEBUG in ('Y', 'C') THEN
1052: arp_util.debug('arp_process_header_updte_cover.update_header_cover()-');
1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: IF PG_DEBUG in ('Y', 'C') THEN
1058: arp_util.debug(
1059: 'exception: arp_process_header_updte_cover.update_header_cover()');
1060: END IF;
1061: RAISE;
1062: