631: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);
632: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
633:
634: /* Read in Parameter Values supplied by user */
635: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);
636: IF retval = -1 THEN
637: p_org_id := NULL;
638: ELSE
639: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
635: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);
636: IF retval = -1 THEN
637: p_org_id := NULL;
638: ELSE
639: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
640: END IF;
641: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);
642:
643: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
639: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
640: END IF;
641: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);
642:
643: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
644: IF retval = -1 THEN
645: p_job_size:= NULL;
646: ELSE
647: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
643: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
644: IF retval = -1 THEN
645: p_job_size:= NULL;
646: ELSE
647: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
648: END IF;
649: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);
650:
651: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transactions to Print',parm_number);
647: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
648: END IF;
649: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);
650:
651: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transactions to Print',parm_number);
652: IF retval = -1 THEN
653: p_choice:= NULL;
654: ELSE
655: p_choice:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
651: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transactions to Print',parm_number);
652: IF retval = -1 THEN
653: p_choice:= NULL;
654: ELSE
655: p_choice:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
656: END IF;
657: fnd_file.put_line( fnd_file.log, 'p_choice: ' || p_choice);
658:
659: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order By',parm_number);
655: p_choice:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
656: END IF;
657: fnd_file.put_line( fnd_file.log, 'p_choice: ' || p_choice);
658:
659: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order By',parm_number);
660: IF retval = -1 THEN
661: p_order_by:= NULL;
662: ELSE
663: p_order_by:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
659: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order By',parm_number);
660: IF retval = -1 THEN
661: p_order_by:= NULL;
662: ELSE
663: p_order_by:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
664: END IF;
665: fnd_file.put_line( fnd_file.log, 'p_order_by: ' || p_order_by);
666:
667: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
663: p_order_by:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
664: END IF;
665: fnd_file.put_line( fnd_file.log, 'p_order_by: ' || p_order_by);
666:
667: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
668: IF retval = -1 THEN
669: p_BATCH_ID := NULL;
670: ELSE
671: p_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
667: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
668: IF retval = -1 THEN
669: p_BATCH_ID := NULL;
670: ELSE
671: p_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
672: filter_exists := true;
673: END IF;
674: fnd_file.put_line( fnd_file.log, 'p_BATCH_ID: ' || p_BATCH_ID);
675:
672: filter_exists := true;
673: END IF;
674: fnd_file.put_line( fnd_file.log, 'p_BATCH_ID: ' || p_BATCH_ID);
675:
676: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);
677: IF retval = -1 THEN
678: p_cust_trx_class := NULL;
679: ELSE
680: p_cust_trx_class := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
676: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);
677: IF retval = -1 THEN
678: p_cust_trx_class := NULL;
679: ELSE
680: p_cust_trx_class := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
681: END IF;
682: fnd_file.put_line( fnd_file.log, 'p_cust_trx_class: ' || p_cust_trx_class);
683:
684: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
680: p_cust_trx_class := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
681: END IF;
682: fnd_file.put_line( fnd_file.log, 'p_cust_trx_class: ' || p_cust_trx_class);
683:
684: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
685: IF retval = -1 THEN
686: p_TRX_TYPE_ID := NULL;
687: ELSE
688: p_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
684: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
685: IF retval = -1 THEN
686: p_TRX_TYPE_ID := NULL;
687: ELSE
688: p_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
689: END IF;
690: fnd_file.put_line( fnd_file.log, 'p_TRX_TYPE_ID: ' || p_TRX_TYPE_ID);
691:
692: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
688: p_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
689: END IF;
690: fnd_file.put_line( fnd_file.log, 'p_TRX_TYPE_ID: ' || p_TRX_TYPE_ID);
691:
692: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
693: IF retval = -1 THEN
694: p_customer_class_code:= NULL;
695: ELSE
696: p_customer_class_code:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
692: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
693: IF retval = -1 THEN
694: p_customer_class_code:= NULL;
695: ELSE
696: p_customer_class_code:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
697: END IF;
698: fnd_file.put_line( fnd_file.log, 'p_customer_class_code: ' || p_customer_class_code);
699:
700: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(From) Bill To Customer Name',parm_number);
696: p_customer_class_code:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
697: END IF;
698: fnd_file.put_line( fnd_file.log, 'p_customer_class_code: ' || p_customer_class_code);
699:
700: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(From) Bill To Customer Name',parm_number);
701: IF retval = -1 THEN
702: p_customer_name_low:= NULL;
703: ELSE
704: p_customer_name_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
700: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(From) Bill To Customer Name',parm_number);
701: IF retval = -1 THEN
702: p_customer_name_low:= NULL;
703: ELSE
704: p_customer_name_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
705: END IF;
706: fnd_file.put_line( fnd_file.log, 'p_customer_name_low: ' || p_customer_name_low);
707:
708: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(To) Bill To Customer Name',parm_number);
704: p_customer_name_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
705: END IF;
706: fnd_file.put_line( fnd_file.log, 'p_customer_name_low: ' || p_customer_name_low);
707:
708: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(To) Bill To Customer Name',parm_number);
709: IF retval = -1 THEN
710: p_CUSTOMER_NAME_HIGH := NULL;
711: ELSE
712: p_CUSTOMER_NAME_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
708: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(To) Bill To Customer Name',parm_number);
709: IF retval = -1 THEN
710: p_CUSTOMER_NAME_HIGH := NULL;
711: ELSE
712: p_CUSTOMER_NAME_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
713: END IF;
714: fnd_file.put_line( fnd_file.log, 'p_CUSTOMER_NAME_HIGH: ' || p_CUSTOMER_NAME_HIGH);
715:
716: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Bill To Customer Number',parm_number);
712: p_CUSTOMER_NAME_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
713: END IF;
714: fnd_file.put_line( fnd_file.log, 'p_CUSTOMER_NAME_HIGH: ' || p_CUSTOMER_NAME_HIGH);
715:
716: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Bill To Customer Number',parm_number);
717: IF retval = -1 THEN
718: p_customer_no_low:= NULL;
719: ELSE
720: p_customer_no_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
716: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Bill To Customer Number',parm_number);
717: IF retval = -1 THEN
718: p_customer_no_low:= NULL;
719: ELSE
720: p_customer_no_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
721: END IF;
722: fnd_file.put_line( fnd_file.log, 'p_customer_no_low: ' || p_customer_no_low);
723:
724: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Bill To Customer Number',parm_number);
720: p_customer_no_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
721: END IF;
722: fnd_file.put_line( fnd_file.log, 'p_customer_no_low: ' || p_customer_no_low);
723:
724: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Bill To Customer Number',parm_number);
725: IF retval = -1 THEN
726: p_customer_no_high := NULL;
727: ELSE
728: p_customer_no_high := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
724: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Bill To Customer Number',parm_number);
725: IF retval = -1 THEN
726: p_customer_no_high := NULL;
727: ELSE
728: p_customer_no_high := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
729: END IF;
730: fnd_file.put_line( fnd_file.log, 'p_customer_no_high: ' || p_customer_no_high);
731:
732: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Transaction Number',parm_number);
728: p_customer_no_high := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
729: END IF;
730: fnd_file.put_line( fnd_file.log, 'p_customer_no_high: ' || p_customer_no_high);
731:
732: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Transaction Number',parm_number);
733: IF retval = -1 THEN
734: p_TRX_NUMBER_LOW := NULL;
735: ELSE
736: p_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
732: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Transaction Number',parm_number);
733: IF retval = -1 THEN
734: p_TRX_NUMBER_LOW := NULL;
735: ELSE
736: p_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
737: END IF;
738: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_LOW: ' || p_TRX_NUMBER_LOW);
739:
740: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Transaction Number',parm_number);
736: p_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
737: END IF;
738: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_LOW: ' || p_TRX_NUMBER_LOW);
739:
740: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Transaction Number',parm_number);
741: IF retval = -1 THEN
742: p_TRX_NUMBER_HIGH := NULL;
743: ELSE
744: p_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
740: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Transaction Number',parm_number);
741: IF retval = -1 THEN
742: p_TRX_NUMBER_HIGH := NULL;
743: ELSE
744: p_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
745: END IF;
746: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_HIGH: ' || p_TRX_NUMBER_HIGH);
747:
748: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
744: p_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
745: END IF;
746: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_HIGH: ' || p_TRX_NUMBER_HIGH);
747:
748: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
749: IF retval = -1 THEN
750: p_INSTALLMENT_NO := NULL;
751: ELSE
752: p_INSTALLMENT_NO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
748: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
749: IF retval = -1 THEN
750: p_INSTALLMENT_NO := NULL;
751: ELSE
752: p_INSTALLMENT_NO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
753: END IF;
754: fnd_file.put_line( fnd_file.log, 'p_INSTALLMENT_NO: ' || p_INSTALLMENT_NO);
755:
756: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Print Date',parm_number);
752: p_INSTALLMENT_NO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
753: END IF;
754: fnd_file.put_line( fnd_file.log, 'p_INSTALLMENT_NO: ' || p_INSTALLMENT_NO);
755:
756: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Print Date',parm_number);
757: IF retval = -1 THEN
758: p_PRINT_DATE_LOW := NULL;
759: ELSE
760: p_PRINT_DATE_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
756: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Print Date',parm_number);
757: IF retval = -1 THEN
758: p_PRINT_DATE_LOW := NULL;
759: ELSE
760: p_PRINT_DATE_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
761: END IF;
762: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_LOW: ' || p_PRINT_DATE_LOW);
763:
764: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Print Date',parm_number);
760: p_PRINT_DATE_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
761: END IF;
762: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_LOW: ' || p_PRINT_DATE_LOW);
763:
764: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Print Date',parm_number);
765: IF retval = -1 THEN
766: p_PRINT_DATE_HIGH := NULL;
767: ELSE
768: p_PRINT_DATE_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
764: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Print Date',parm_number);
765: IF retval = -1 THEN
766: p_PRINT_DATE_HIGH := NULL;
767: ELSE
768: p_PRINT_DATE_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
769: END IF;
770: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_HIGH: ' || p_PRINT_DATE_HIGH);
771:
772: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
768: p_PRINT_DATE_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
769: END IF;
770: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_HIGH: ' || p_PRINT_DATE_HIGH);
771:
772: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
773: IF retval = -1 THEN
774: p_OPEN_INVOICE_FLAG := NULL;
775: ELSE
776: p_OPEN_INVOICE_FLAG := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
772: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
773: IF retval = -1 THEN
774: p_OPEN_INVOICE_FLAG := NULL;
775: ELSE
776: p_OPEN_INVOICE_FLAG := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
777: END IF;
778: fnd_file.put_line( fnd_file.log, 'p_OPEN_INVOICE_FLAG: ' || p_OPEN_INVOICE_FLAG);
779:
780: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Invoice Trx Id List',parm_number);
776: p_OPEN_INVOICE_FLAG := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
777: END IF;
778: fnd_file.put_line( fnd_file.log, 'p_OPEN_INVOICE_FLAG: ' || p_OPEN_INVOICE_FLAG);
779:
780: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Invoice Trx Id List',parm_number);
781: IF retval = -1 THEN
782: p_INVOICE_LIST_STRING := NULL;
783: ELSE
784: p_INVOICE_LIST_STRING := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
780: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Invoice Trx Id List',parm_number);
781: IF retval = -1 THEN
782: p_INVOICE_LIST_STRING := NULL;
783: ELSE
784: p_INVOICE_LIST_STRING := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
785: END IF;
786: fnd_file.put_line( fnd_file.log, 'p_INVOICE_LIST_STRING: ' || p_INVOICE_LIST_STRING);
787:
788: