[Home] [Help]
6414: | be called with the list of paper documents that were spoilt (not
6415: | with the list of paper documents that were skipped, issued etc.).
6416: |
6417: | The list of used paper documents numbers will be used to insert
6418: | records into the IBY_USED_PAYMENT_DOCS table.
6419: |
6420: | The list of new paper document numbers will be used to update the
6421: | IBY_PAYMENTS_ALL table with the new paper document numbers for
6422: | the corresponding paments. The payment status will then be set to
6442: | - List of new paper document numbers to print
6443: | the provided payments on.
6444: | p_old_ppr_docs_list
6445: | - List of previously used paper document numbers.
6446: | These will be inserted into IBY_USED_PAYMENT_DOCS
6447: | table indicating that they were spoiled.
6448: | p_printer_name - Printer to use for re-printing payments.
6449: |
6450: |
6602:
6603: /*
6604: * STEP 1:
6605: *
6606: * Update the IBY_USED_PAYMENT_DOCS table with the list of
6607: * used paper document numbers. Since the user invokes this API
6608: * to reprint the paper documents, it follows that the earlier
6609: * used paper document was spoilt. Therefore, set the status of
6610: * the earlier used paper document to SPOILED.
6620: || ' to spoiled status ..'
6621: );
6622:
6623: END IF;
6624: INSERT INTO IBY_USED_PAYMENT_DOCS (
6625: PAYMENT_DOCUMENT_ID,
6626: USED_DOCUMENT_NUMBER,
6627: DATE_USED,
6628: DOCUMENT_USE,
7429: |
7430: | PURPOSE:
7431: | Records the final print status for a set of paper documents. This
7432: | API will insert the given set of paper document numbers into the
7433: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
7434: | whether the paper document was spoiled.
7435: |
7436: | Note that this API should only be invoked with the list of spoiled
7437: | paper documents. The UI should directly handle the successfully
7438: | printed paper documents. For performance reasons, this API is
7439: | designed only to handle the spoiled paper document case.
7440: |
7441: | This API will set the usage reason for each provided document
7442: | to 'SPOILED' in the IBY_USED_PAYMENT_DOCS table, and it will also
7443: | set the status of the corresponding payment to
7444: | REMOVED_DOCUMENT_SPOILED.
7445: |
7446: | Then, this API will set the status of the successfully printed
7510: |
7511: | PURPOSE:
7512: | Records the final print status for a set of paper documents. This
7513: | API will insert the given set of paper document numbers into the
7514: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
7515: | whether the paper document was spoiled.
7516: |
7517: | Note that this API should only be invoked with the list of spoiled
7518: | paper documents. The UI should directly handle the successfully
7519: | printed paper documents. For performance reasons, this API is
7520: | designed only to handle the spoiled paper document case.
7521: |
7522: | This API will set the usage reason for each provided document
7523: | to 'SPOILED' in the IBY_USED_PAYMENT_DOCS table, and it will also
7524: | set the status of the corresponding payment to
7525: | REMOVED_DOCUMENT_SPOILED.
7526: |
7527: | Then, this API will set the status of the successfully printed
7634: | PURPOSE:
7635: | Records the final print status for all the paper documents that
7636: | are part of a payment instruction. This API will insert the paper
7637: | document numbers linked to each payment in the instruction into the
7638: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
7639: | that the paper document was successfully printed.
7640: |
7641: | This API should only invoked when *all* the payments that are part
7642: | of a payment instruction have been printed successfully.
7715: |
7716: | PURPOSE:
7717: | Records the final print status for a set of paper documents. This
7718: | API will insert the given set of paper document numbers into the
7719: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
7720: | whether the paper document was spoiled.
7721: |
7722: | Note that this API should only be invoked with the list of spoiled
7723: | paper documents. The UI should directly handle the successfully
7724: | printed paper documents. For performance reasons, this API is
7725: | designed only to handle the spoiled paper document case.
7726: |
7727: | This API will set the usage reason for each provided document
7728: | to 'SPOILED' in the IBY_USED_PAYMENT_DOCS table, and it will also
7729: | set the status of the corresponding payment to
7730: | REMOVED_DOCUMENT_SPOILED.
7731: |
7732: | Then, this API will set the status of the successfully printed
7929: |
7930: | PURPOSE:
7931: | Records the final print status for a set of paper documents. This
7932: | API will insert the given set of paper document numbers into the
7933: | IBY_USED_PAYMENT_DOCS table along with the usage reason indicating
7934: | whether the paper document was spoiled.
7935: |
7936: | Note that this API should only be invoked with the list of spoiled
7937: | paper documents. The UI should directly handle the successfully
7938: | printed paper documents. For performance reasons, this API is
7939: | designed only to handle the spoiled paper document case.
7940: |
7941: | This API will set the usage reason for each provided document
7942: | to 'SPOILED' in the IBY_USED_PAYMENT_DOCS table, and it will also
7943: | set the status of the corresponding payment to
7944: | REMOVED_DOCUMENT_SPOILED.
7945: |
7946: | Then, this API will set the status of the successfully printed
8213:
8214: -- check if it already exists in the used_documents_table
8215: SELECT cedocs.used_document_number
8216: INTO l_skipped_document_number
8217: FROM iby_used_payment_docs cedocs
8218: WHERE cedocs.payment_document_id = p_pmt_doc_id
8219: AND cedocs.used_document_number = l_skipped_docs_list(i);
8220:
8221: EXCEPTION
8224: -- inserting the document as skipped
8225: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8226: print_debuginfo(l_module_name, 'inserting as skipped ' || l_skipped_docs_list(i));
8227: END IF;
8228: INSERT INTO IBY_USED_PAYMENT_DOCS (
8229: PAYMENT_DOCUMENT_ID,
8230: USED_DOCUMENT_NUMBER,
8231: DATE_USED,
8232: DOCUMENT_USE,
8361:
8362: -- checking if the document is already skipped earlier
8363: SELECT cedocs.used_document_number
8364: INTO l_skipped_document_number
8365: FROM iby_used_payment_docs cedocs
8366: WHERE cedocs.payment_document_id = p_pmt_doc_id
8367: AND cedocs.used_document_number = l_used_docs_list(i)
8368: AND cedocs.document_use = 'SKIPPED';
8369:
8370: EXCEPTION
8371: WHEN NO_DATA_FOUND THEN
8372:
8373: --if the document is not skipped earlier insert new
8374: INSERT INTO IBY_USED_PAYMENT_DOCS (
8375: PAYMENT_DOCUMENT_ID,
8376: USED_DOCUMENT_NUMBER,
8377: DATE_USED,
8378: DOCUMENT_USE,
8401: END IF;
8402: END;
8403:
8404: -- updating the document_use in any case
8405: UPDATE IBY_USED_PAYMENT_DOCS
8406: SET DOCUMENT_USE = decode(l_payment_status_list(i),'REMOVED_DOCUMENT_SPOILED','SPOILED','ISSUED')
8407: WHERE payment_document_id = p_pmt_doc_id
8408: AND used_document_number = l_used_docs_list(i);
8409:
9814: );
9815:
9816: END IF;
9817:
9818: INSERT INTO IBY_USED_PAYMENT_DOCS (
9819: PAYMENT_DOCUMENT_ID,
9820: USED_DOCUMENT_NUMBER,
9821: DATE_USED,
9822: DOCUMENT_USE,
11049: BEGIN
11050:
11051: /*
11052: * Check if this paper document number has already
11053: * been used by searching the the IBY_USED_PAYMENT_DOCS
11054: * table.
11055: */
11056: SELECT
11057: used_document_number
11057: used_document_number
11058: INTO
11059: l_used_paper_doc_number
11060: FROM
11061: IBY_USED_PAYMENT_DOCS
11062: WHERE
11063: payment_document_id = p_pmt_document_id AND
11064: used_document_number = p_paper_doc_num AND
11065: document_use <> 'SKIPPED'
11066: ;
11067:
11068: /*
11069: * If we reached here, it means that a row has been
11070: * found in the IBY_USED_PAYMENT_DOCS table for the
11071: * given (paper doc number, payment document id)
11072: * combination. This means that the paper document
11073: * is used.
11074: *
11107:
11108: print_debuginfo(l_module_name, 'Exception occured when '
11109: || 'attempting to get details of paper document '
11110: || p_paper_doc_num
11111: || ' from IBY_USED_PAYMENT_DOCS table.'
11112: );
11113:
11114: print_debuginfo(l_module_name, 'SQL code: ' || SQLCODE);
11115: print_debuginfo(l_module_name, 'SQL err msg: '|| SQLERRM);