[Home] [Help]
59: | Entry point for payment creation flow. All payment grouping
60: | rules are handled within this method.
61: |
62: | This method is very similar to createPayments(..) in the
63: | IBY_PAYGROUP_PUB package. That package is meant for normal
64: | build program flow, whereas this package is meant for single
65: | payments flow.
66: |
67: | PARAMETERS:
98: l_decl_curr_code VARCHAR2(10) := '';
99: l_decl_threshold_amount NUMBER(15) := 0;
100:
101: /* Bug 5709596 */
102: -- l_cbrTab IBY_PAYGROUP_PUB.centralBankReportTabType;
103:
104: l_ca_payreq_cd VARCHAR2(255) := '';
105: l_ca_id NUMBER(15) := 0;
106: l_all_pmts_success_flag BOOLEAN := FALSE;
109: /* rejection level system options */
110: l_rejection_level VARCHAR2(200);
111: l_review_pmts_flag VARCHAR2(1) := 'N';
112:
113: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;
114: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
115:
116: /* these two are passed to calling app via hook */
117: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
110: l_rejection_level VARCHAR2(200);
111: l_review_pmts_flag VARCHAR2(1) := 'N';
112:
113: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;
114: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
115:
116: /* these two are passed to calling app via hook */
117: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
118: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
113: l_paymentTab IBY_PAYGROUP_PUB.paymentTabType;
114: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
115:
116: /* these two are passed to calling app via hook */
117: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
118: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
119:
120: /* holds the error messages against failed documents */
121: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
114: l_docsInPmtTab IBY_PAYGROUP_PUB.docsInPaymentTabType;
115:
116: /* these two are passed to calling app via hook */
117: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
118: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
119:
120: /* holds the error messages against failed documents */
121: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
122: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
122: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
123:
124: /* payment request imposed limits on payments */
125: /* not used but needs to be passed into performDocumentGrouping() method */
126: l_payReqCriteria IBY_PAYGROUP_PUB.payReqImposedCriteria;
127:
128: BEGIN
129:
130: print_debuginfo(l_module_name, 'ENTER');
134:
135: /*
136: * Group the documents of the payment request into payments.
137: */
138: IBY_PAYGROUP_PUB.performDocumentGrouping(p_payment_request_id
139: , l_paymentTab
140: , l_docsInPmtTab
141: , l_ca_id
142: , l_ca_payreq_cd
183: * of each payment, and set the corresponding
184: * attribute on the parent payment itself if
185: * such a common attribute is found.
186: */
187: IBY_PAYGROUP_PUB.sweepCommonPmtAttributes(l_paymentTab, l_docsInPmtTab);
188:
189: /*
190: * Set the default attributes for the created payments.
191: */
268: * that is expecting payments to be populated in
269: * IBY_PAYMENTS_ALL table. Therefore, payments need to
270: * inserted before performing central bank reporting as well.
271: */
272: IBY_PAYGROUP_PUB.insertPayments(l_paymentTab);
273:
274: /*
275: * Fix for bug 5972585:
276: *
288: * again the customer could potentially want to retrieve
289: * documents that are part of the created payments in the
290: * central bank reporting hook.
291: */
292: IBY_PAYGROUP_PUB.updateDocsWithPaymentID(l_docsInPmtTab);
293:
294: /*
295: * Fix for bug 5972585:
296: *
314: *
315: * This information is also used by the extract and format
316: * logic.
317: */
318: IBY_PAYGROUP_PUB.auditPaymentData(l_paymentTab);
319:
320: /*
321: * Fix for bug 5337671:
322: *
330:
331: /*
332: * Perform declarations / central bank reporting.
333: */
334: IBY_PAYGROUP_PUB.performCentralBankReporting(
335: l_paymentTab
336: , l_docsInPmtTab
337: -- , l_cbrTab
338: );
345: * payments by the hook. Therefore, we need to
346: * update the payments in IBY_PAYMENTS_ALL table
347: * so that this flag is accessible for validation.
348: */
349: IBY_PAYGROUP_PUB.updatePayments(l_paymentTab);
350:
351:
352: /*
353: * Payment validations
351:
352: /*
353: * Payment validations
354: */
355: IBY_PAYGROUP_PUB.applyPaymentValidationSets(l_paymentTab,
356: l_docsInPmtTab, l_docErrorTab, l_docTokenTab);
357:
358:
359: /* Validation check for negative payment amounts
369: /*
370: * Commented out because of performance impact
371: * - Ramesh, Nov 17 2006.
372: */
373: --IBY_PAYGROUP_PUB.performPmtGrpNumberValidation(l_paymentTab,
374: -- l_docsInPmtTab, l_docErrorTab, l_docTokenTab);
375:
376: /*
377: * Payment validation might have failed some payments (and by
379: *
380: * Make sure to fail related documents whenever documents are
381: * failed.
382: */
383: IBY_PAYGROUP_PUB.adjustSisterDocsAndPmts(l_paymentTab,
384: l_docsInPmtTab, l_docErrorTab, l_docTokenTab);
385:
386: /*
387: * Call post-payment creation hook. This hook will pass
407: * calling application.
408: *
409: * This method writes the payment data to global temp tables.
410: */
411: IBY_PAYGROUP_PUB.performPreHookProcess(
412: l_ca_payreq_cd, l_ca_id, l_paymentTab,
413: l_docsInPmtTab, l_hookPaymentTab,
414: l_hookDocsInPmtTab);
415:
422: *
423: * Any other miscellaneous correction of payment/document data
424: * is also allowed in the hook.
425: */
426: IBY_PAYGROUP_PUB.callHook(p_payment_request_id);
427:
428: /*
429: * The external app may decide not to pay a document(s)
430: * within a payment, or may decide not to make a payment(s).
440: * constituent payment amounts must be adjusted
441: *
442: * This method reads the payment data from global temp tables.
443: */
444: IBY_PAYGROUP_PUB.performPostHookProcess(
445: l_paymentTab, l_docsInPmtTab,
446: l_hookPaymentTab, l_hookDocsInPmtTab,
447: l_docErrorTab, l_docTokenTab);
448:
467: /*
468: * Flag payments that require separate remittance
469: * advice.
470: */
471: IBY_PAYGROUP_PUB.flagSeparateRemitAdvicePmts(l_paymentTab,
472: l_docsInPmtTab);
473:
474: /*
475: * Get the rejection level system option and pass
559: payment_service_request_id%type,
560: p_rej_level IN VARCHAR2,
561: p_review_pmts_flag IN VARCHAR2,
562: p_override_compl_pt IN VARCHAR2,
563: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
564: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
565: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
566: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
567: x_return_status IN OUT NOCOPY VARCHAR2,
560: p_rej_level IN VARCHAR2,
561: p_review_pmts_flag IN VARCHAR2,
562: p_override_compl_pt IN VARCHAR2,
563: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
564: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
565: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
566: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
567: x_return_status IN OUT NOCOPY VARCHAR2,
568: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
668:
669: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
670: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
671:
672: IBY_PAYGROUP_PUB.failDocsOfPayment(
673: x_paymentTab(i).payment_id,
674: DOC_STATUS_PAY_VAL_FAIL,
675: x_docsInPmtTab, x_docErrorTab,
676: x_errTokenTab);
765: * All payments for this payment request have been
766: * created and stored in a PLSQL table. Now write these
767: * payments to the database.
768: */
769: IBY_PAYGROUP_PUB.updatePayments(x_paymentTab);
770:
771: /*
772: * Update the documents table by providing a payment id to
773: * each document.
771: /*
772: * Update the documents table by providing a payment id to
773: * each document.
774: */
775: IBY_PAYGROUP_PUB.updateDocsWithPaymentID(x_docsInPmtTab);
776:
777: /*
778: * If any payments/documents were failed, the IBY_TRANSACTION_
779: * ERRORS table must be populated with the corresponding error
847: | NOTES:
848: |
849: *---------------------------------------------------------------------*/
850: PROCEDURE initializePmts(
851: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType
852: )
853: IS
854: BEGIN
855:
901: | NOTES: Added for the bug 7344352
902: |
903: *---------------------------------------------------------------------*/
904: PROCEDURE negativePmtAmountCheck(
905: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
906: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
907: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
908: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
909: )
902: |
903: *---------------------------------------------------------------------*/
904: PROCEDURE negativePmtAmountCheck(
905: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
906: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
907: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
908: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
909: )
910: IS
959: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
960: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
961:
962: /* fail the docs of this payment */
963: IBY_PAYGROUP_PUB.failDocsOfPayment(x_paymentTab(i).payment_id,
964: DOC_STATUS_PAY_VAL_FAIL, x_docsInPmtTab,
965: x_docErrorTab, x_errTokenTab);
966:
967: END IF;