[Home] [Help]
5223: | be called with the list of paper documents that were spoilt (not
5224: | with the list of paper documents that were skipped, issued etc.).
5225: |
5226: | The list of used paper documents numbers will be used to insert
5227: | records into the IBY_USED_PAYMENT_DOCS table.
5228: |
5229: | The list of new paper document numbers will be used to update the
5230: | IBY_PAYMENTS_ALL table with the new paper document numbers for
5231: | the corresponding paments. The payment status will then be set to
5251: | - List of new paper document numbers to print
5252: | the provided payments on.
5253: | p_old_ppr_docs_list
5254: | - List of previously used paper document numbers.
5255: | These will be inserted into IBY_USED_PAYMENT_DOCS
5256: | table indicating that they were spoiled.
5257: | p_printer_name - Printer to use for re-printing payments.
5258: |
5259: |
5399:
5400: /*
5401: * STEP 1:
5402: *
5403: * Update the IBY_USED_PAYMENT_DOCS table with the list of
5404: * used paper document numbers. Since the user invokes this API
5405: * to reprint the paper documents, it follows that the earlier
5406: * used paper document was spoilt. Therefore, set the status of
5407: * the earlier used paper document to SPOILED.
5415: || p_pmt_doc_id
5416: || ' to spoiled status ..'
5417: );
5418:
5419: INSERT INTO IBY_USED_PAYMENT_DOCS (
5420: PAYMENT_DOCUMENT_ID,
5421: USED_DOCUMENT_NUMBER,
5422: DATE_USED,
5423: DOCUMENT_USE,
6122: |
6123: | PURPOSE:
6124: | Records the final print status for a set of paper documents. This
6125: | API will insert the given set of paper document numbers into the
6126: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
6127: | whether the paper document was spoiled.
6128: |
6129: | Note that this API should only be invoked with the list of spoiled
6130: | paper documents. The UI should directly handle the successfully
6131: | printed paper documents. For performance reasons, this API is
6132: | designed only to handle the spoiled paper document case.
6133: |
6134: | This API will set the usage reason for each provided document
6135: | to 'SPOILED' in the IBY_USED_PAYMENT_DOCS table, and it will also
6136: | set the status of the corresponding payment to
6137: | REMOVED_DOCUMENT_SPOILED.
6138: |
6139: | Then, this API will set the status of the successfully printed
6282: * each paper document to 'spoiled'.
6283: */
6284: FOR i IN p_used_docs_list.FIRST .. p_used_docs_list.LAST LOOP
6285:
6286: INSERT INTO IBY_USED_PAYMENT_DOCS (
6287: PAYMENT_DOCUMENT_ID,
6288: USED_DOCUMENT_NUMBER,
6289: DATE_USED,
6290: DOCUMENT_USE,
6599: |
6600: | PURPOSE:
6601: | Records the final print status for a set of paper documents. This
6602: | API will insert the given set of paper document numbers into the
6603: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
6604: | whether the paper document was spoiled.
6605: |
6606: | Note that this API should only be invoked with the list of spoiled
6607: | paper documents. The UI should directly handle the successfully
6608: | printed paper documents. For performance reasons, this API is
6609: | designed only to handle the spoiled paper document case.
6610: |
6611: | This API will set the usage reason for each provided document
6612: | to 'SPOILED' in the IBY_USED_PAYMENT_DOCS table, and it will also
6613: | set the status of the corresponding payment to
6614: | REMOVED_DOCUMENT_SPOILED.
6615: |
6616: | Then, this API will set the status of the successfully printed
6781:
6782: -- checking if the document is already skipped earlier
6783: SELECT cedocs.used_document_number
6784: INTO l_skipped_document_number
6785: FROM iby_used_payment_docs cedocs
6786: WHERE cedocs.payment_document_id = p_pmt_doc_id
6787: AND cedocs.used_document_number = p_used_docs_list(i)
6788: AND cedocs.document_use = 'SKIPPED';
6789:
6790: EXCEPTION
6791: WHEN NO_DATA_FOUND THEN
6792:
6793: --if the document is not skipped earlier insert new
6794: INSERT INTO IBY_USED_PAYMENT_DOCS (
6795: PAYMENT_DOCUMENT_ID,
6796: USED_DOCUMENT_NUMBER,
6797: DATE_USED,
6798: DOCUMENT_USE,
6819: print_debuginfo(l_module_name, 'Document number not found, inserting new');
6820: END;
6821:
6822: -- updating the document_use in any case
6823: UPDATE IBY_USED_PAYMENT_DOCS
6824: SET DOCUMENT_USE = decode(l_payment_status_list(i),'REMOVED_DOCUMENT_SPOILED','SPOILED','ISSUED')
6825: WHERE payment_document_id = p_pmt_doc_id
6826: AND used_document_number = p_used_docs_list(i);
6827:
6863:
6864: -- check if it already exists in the used_documents_table
6865: SELECT cedocs.used_document_number
6866: INTO l_skipped_document_number
6867: FROM iby_used_payment_docs cedocs
6868: WHERE cedocs.payment_document_id = p_pmt_doc_id
6869: AND cedocs.used_document_number = i;
6870:
6871: EXCEPTION
6872: WHEN NO_DATA_FOUND THEN
6873:
6874: -- inserting the document as skipped
6875: print_debuginfo(l_module_name, 'inserting as skipped ' || i);
6876: INSERT INTO IBY_USED_PAYMENT_DOCS (
6877: PAYMENT_DOCUMENT_ID,
6878: USED_DOCUMENT_NUMBER,
6879: DATE_USED,
6880: DOCUMENT_USE,
7237: | PURPOSE:
7238: | Records the final print status for all the paper documents that
7239: | are part of a payment instruction. This API will insert the paper
7240: | document numbers linked to each payment in the instruction into the
7241: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
7242: | that the paper document was successfully printed.
7243: |
7244: | This API should only invoked when *all* the payments that are part
7245: | of a payment instruction have been printed successfully.
7427: BEGIN
7428: -- finding if the document is already skipped earlier
7429: SELECT cedocs.used_document_number
7430: INTO l_skipped_document_number
7431: FROM iby_used_payment_docs cedocs
7432: WHERE cedocs.payment_document_id = l_pmt_doc_id
7433: AND cedocs.used_document_number = l_pmtDocsTab(i)
7434: AND cedocs.document_use = 'SKIPPED';
7435:
7436: EXCEPTION
7437: WHEN NO_DATA_FOUND THEN
7438:
7439: -- if not skipped earlier, inserting new
7440: INSERT INTO IBY_USED_PAYMENT_DOCS (
7441: PAYMENT_DOCUMENT_ID,
7442: USED_DOCUMENT_NUMBER,
7443: DATE_USED,
7444: DOCUMENT_USE,
7465: print_debuginfo(l_module_name, 'Document number not found, inserting new');
7466: END;
7467:
7468: -- updating the document_use in any case
7469: UPDATE IBY_USED_PAYMENT_DOCS
7470: SET DOCUMENT_USE = DOC_USE_ISSUED
7471: WHERE payment_document_id = l_pmt_doc_id
7472: AND used_document_number = l_pmtDocsTab(i);
7473:
9486: BEGIN
9487:
9488: /*
9489: * Check if this paper document number has already
9490: * been used by searching the the IBY_USED_PAYMENT_DOCS
9491: * table.
9492: */
9493: SELECT
9494: used_document_number
9494: used_document_number
9495: INTO
9496: l_used_paper_doc_number
9497: FROM
9498: IBY_USED_PAYMENT_DOCS
9499: WHERE
9500: payment_document_id = p_pmt_document_id AND
9501: used_document_number = p_paper_doc_num AND
9502: document_use <> 'SKIPPED'
9503: ;
9504:
9505: /*
9506: * If we reached here, it means that a row has been
9507: * found in the IBY_USED_PAYMENT_DOCS table for the
9508: * given (paper doc number, payment document id)
9509: * combination. This means that the paper document
9510: * is used.
9511: *
9537:
9538: print_debuginfo(l_module_name, 'Exception occured when '
9539: || 'attempting to get details of paper document '
9540: || p_paper_doc_num
9541: || ' from IBY_USED_PAYMENT_DOCS table.'
9542: );
9543:
9544: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
9545: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);