745: pa_debug.debug(' Login ID = ' || to_char(G_LOGIN_ID));
746: End If;
747: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
748: If g_body_debug_mode ='Y' Then
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
750: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter1 - Project ID : ' || G_PROJECT_ID);
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
746: End If;
747: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
748: If g_body_debug_mode ='Y' Then
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
750: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter1 - Project ID : ' || G_PROJECT_ID);
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
747: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
748: If g_body_debug_mode ='Y' Then
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
750: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter1 - Project ID : ' || G_PROJECT_ID);
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
748: If g_body_debug_mode ='Y' Then
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
750: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter1 - Project ID : ' || G_PROJECT_ID);
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
749: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Validated parameters are as follows:');
750: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter1 - Project ID : ' || G_PROJECT_ID);
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
750: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter1 - Project ID : ' || G_PROJECT_ID);
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Program ID = ' || to_char(G_PROG_ID));
751: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter2 - Batch Name : ' || G_BATCH_NAME);
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Program ID = ' || to_char(G_PROG_ID));
759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Login ID = ' || to_char(G_LOGIN_ID));
752: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter3 - GL Date through : ' || to_char(G_GL_DATE));
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Program ID = ' || to_char(G_PROG_ID));
759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Login ID = ' || to_char(G_LOGIN_ID));
760: End If;
753: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Parameter4 - Transaction Date through : ' || to_char(G_TRANSACTION_DATE));
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Program ID = ' || to_char(G_PROG_ID));
759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Login ID = ' || to_char(G_LOGIN_ID));
760: End If;
761:
754: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Program ID = ' || to_char(G_PROG_ID));
759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Login ID = ' || to_char(G_LOGIN_ID));
760: End If;
761:
762: END IF;
755: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other relevant information:');
756: FND_FILE.PUT_LINE(FND_FILE.LOG, ' User ID = ' || to_char(G_USER_ID));
757: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Request ID = ' || to_char(G_REQUEST_ID));
758: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Program ID = ' || to_char(G_PROG_ID));
759: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Login ID = ' || to_char(G_LOGIN_ID));
760: End If;
761:
762: END IF;
763:
798: pa_debug.debug(p_message);
799:
800: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
801:
802: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
804:
805: END IF;
806:
799:
800: ELSIF (G_OUTPUT = G_OUTPUT_FND) THEN
801:
802: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);
803: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
804:
805: END IF;
806:
807: END IF;
805: END IF;
806:
807: END IF;
808: */
809: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);
810: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
811: EXCEPTION /* When exception occurs, program needs to be aborted. */
812:
813: WHEN OTHERS THEN
806:
807: END IF;
808: */
809: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(sysdate,'HH:MI:SS: ')|| p_message);
810: FND_FILE.NEW_LINE(FND_FILE.LOG, 1);
811: EXCEPTION /* When exception occurs, program needs to be aborted. */
812:
813: WHEN OTHERS THEN
814:
1138: write_log(LOG, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED:'||to_char(G_NUM_RCVTAX_PROCESSED));
1139: end if;
1140:
1141: IF (G_OUTPUT = G_OUTPUT_FND) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICES PROCESSED: ' || to_char(G_NUM_INVOICES_PROCESSED));
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICE DISTRIBUTIONS PROCESSED: ' || to_char(G_NUM_DISTRIBUTIONS_PROCESSED));
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF DISCOUNTS PROCESSED: '||to_char(G_NUM_DISCOUNTS_PROCESSED));
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1139: end if;
1140:
1141: IF (G_OUTPUT = G_OUTPUT_FND) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICES PROCESSED: ' || to_char(G_NUM_INVOICES_PROCESSED));
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICE DISTRIBUTIONS PROCESSED: ' || to_char(G_NUM_DISTRIBUTIONS_PROCESSED));
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF DISCOUNTS PROCESSED: '||to_char(G_NUM_DISCOUNTS_PROCESSED));
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1147:
1140:
1141: IF (G_OUTPUT = G_OUTPUT_FND) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICES PROCESSED: ' || to_char(G_NUM_INVOICES_PROCESSED));
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICE DISTRIBUTIONS PROCESSED: ' || to_char(G_NUM_DISTRIBUTIONS_PROCESSED));
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF DISCOUNTS PROCESSED: '||to_char(G_NUM_DISCOUNTS_PROCESSED));
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------------------------------------');
1141: IF (G_OUTPUT = G_OUTPUT_FND) THEN
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICES PROCESSED: ' || to_char(G_NUM_INVOICES_PROCESSED));
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICE DISTRIBUTIONS PROCESSED: ' || to_char(G_NUM_DISTRIBUTIONS_PROCESSED));
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF DISCOUNTS PROCESSED: '||to_char(G_NUM_DISCOUNTS_PROCESSED));
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------------------------------------');
1149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'For detail information of this interface, please review the following report.');
1142: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICES PROCESSED: ' || to_char(G_NUM_INVOICES_PROCESSED));
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF INVOICE DISTRIBUTIONS PROCESSED: ' || to_char(G_NUM_DISTRIBUTIONS_PROCESSED));
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF DISCOUNTS PROCESSED: '||to_char(G_NUM_DISCOUNTS_PROCESSED));
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------------------------------------');
1149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'For detail information of this interface, please review the following report.');
1150: END IF;
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF DISCOUNTS PROCESSED: '||to_char(G_NUM_DISCOUNTS_PROCESSED));
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------------------------------------');
1149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'For detail information of this interface, please review the following report.');
1150: END IF;
1151:
1152: result_print := FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(G_REQUEST_ID,l_number_of_copies,l_print_style,l_printer,
1145: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPTS PROCESSED: '||to_char(G_NUM_RCV_TXN_PROCESSED));
1146: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'TOTAL NUMBER OF RECEIPT TAX PROCESSED: '||to_char(G_NUM_RCVTAX_PROCESSED));
1147:
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '----------------------------------------------------------------');
1149: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'For detail information of this interface, please review the following report.');
1150: END IF;
1151:
1152: result_print := FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS(G_REQUEST_ID,l_number_of_copies,l_print_style,l_printer,
1153: l_save_output_flag);
1174: WRITE_LOG (LOG, '......Error in submitting request to print report......');
1175: WRITE_LOG (LOG, 'Error Message: ' || v_err_msg || ' END of message.');
1176: End if;
1177: IF (G_OUTPUT = G_OUTPUT_FND) THEN
1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '...An attempt to submit the status report of the process has failed.');
1179: END IF;
1180: ELSE
1181: If g_body_debug_mode = 'Y' Then
1182: WRITE_LOG( LOG, '......Request to print report submitted, Request ID: '
1182: WRITE_LOG( LOG, '......Request to print report submitted, Request ID: '
1183: || to_char(req_id) || '......');
1184: end if;
1185: IF (G_OUTPUT = G_OUTPUT_FND) THEN
1186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'A status report of this process has been submitted. Request ID: '
1187: || to_char(req_id));
1188: END IF;
1189: END IF;
1190: