eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYGROUP_PUB dependencies on IBY_VALIDATIONSETS_PUB

Line 462: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

458: /* central bank reporting requirements imposed on each payment */
459: --l_cbrTab IBY_PAYGROUP_PUB.centralBankReportTabType;
460:
461: /* holds the error messages against failed documents */
462: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
463: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
464: l_DocsInPmtCount NUMBER;
465:
466: p_trx_pmt_line_index BINARY_INTEGER;

Line 463: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;

459: --l_cbrTab IBY_PAYGROUP_PUB.centralBankReportTabType;
460:
461: /* holds the error messages against failed documents */
462: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
463: l_docTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
464: l_DocsInPmtCount NUMBER;
465:
466: p_trx_pmt_line_index BINARY_INTEGER;
467:

Line 1442: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

1438: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
1439: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
1440:
1441: /* holds the error messages against failed documents */
1442: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
1443:
1444: /* holds list of internal bank accounts with corresponding legal entity id */
1445: l_bankAcctLETab bankAccountLETabType;
1446:

Line 3521: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;

3517: l_hookPaymentTab IBY_PAYGROUP_PUB.hookPaymentTabType;
3518: l_hookDocsInPmtTab IBY_PAYGROUP_PUB.hookDocsInPaymentTabType;
3519:
3520: /* holds the error messages against failed documents */
3521: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
3522:
3523: /* holds list of internal bank accounts with corresponding legal entity id */
3524: l_bankAcctLETab bankAccountLETabType;
3525:

Line 10305: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

10301: PROCEDURE performPaymentValidations(
10302: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
10303: payment_service_request_id%TYPE,
10304: x_paymentTab IN OUT NOCOPY paymentTabType,
10305: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10306: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10307: )
10308: IS
10309:

Line 10306: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

10302: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
10303: payment_service_request_id%TYPE,
10304: x_paymentTab IN OUT NOCOPY paymentTabType,
10305: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10306: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10307: )
10308: IS
10309:
10310: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME

Line 10362: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

10358: *---------------------------------------------------------------------*/
10359: PROCEDURE performPayReqBasedValidations(
10360: p_payReqCriteria IN payReqImposedCriteria,
10361: p_trx_pmt_line_index IN BINARY_INTEGER,
10362: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10363: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10364: )
10365: IS
10366:

Line 10363: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

10359: PROCEDURE performPayReqBasedValidations(
10360: p_payReqCriteria IN payReqImposedCriteria,
10361: p_trx_pmt_line_index IN BINARY_INTEGER,
10362: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10363: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10364: )
10365: IS
10366:
10367: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 10479: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

10475: FND_MESSAGE.get,
10476: l_doc_err_rec
10477: );
10478:
10479: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
10480: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
10481:
10482: /* fail the docs of this payment */
10483: If (l_pmt_failed_flag = 'N') THEN

Line 10557: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

10553: FND_MESSAGE.get,
10554: l_doc_err_rec
10555: );
10556:
10557: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
10558: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
10559:
10560: /* fail the docs of this payment */
10561: If (l_pmt_failed_flag = 'N') THEN

Line 10636: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

10632: FND_MESSAGE.get,
10633: l_doc_err_rec
10634: );
10635:
10636: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
10637: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
10638:
10639: /* fail the docs of this payment */
10640: If (l_pmt_failed_flag = 'N') THEN

Line 10699: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

10695: FND_MESSAGE.get,
10696: l_doc_err_rec
10697: );
10698:
10699: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
10700: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
10701:
10702: /* fail the docs of this payment */
10703: If (l_pmt_failed_flag = 'N') THEN

Line 10823: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

10819: FND_MESSAGE.get,
10820: l_doc_err_rec
10821: );
10822:
10823: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
10824: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
10825:
10826: /* fail the docs of this payment */
10827: If (l_pmt_failed_flag = 'N') THEN

Line 10907: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

10903: FND_MESSAGE.get,
10904: l_doc_err_rec
10905: );
10906:
10907: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
10908: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
10909:
10910: /* fail the docs of this payment */
10911: If (l_pmt_failed_flag = 'N') THEN

Line 10960: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

10956: *---------------------------------------------------------------------*/
10957: PROCEDURE performPmtGrpNumberValidation(
10958: x_paymentTab IN OUT NOCOPY paymentTabType,
10959: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
10960: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10961: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10962: )
10963: IS
10964:

Line 10961: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

10957: PROCEDURE performPmtGrpNumberValidation(
10958: x_paymentTab IN OUT NOCOPY paymentTabType,
10959: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
10960: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10961: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
10962: )
10963: IS
10964:
10965: l_orig_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;

Line 11127: IBY_VALIDATIONSETS_PUB.

11123: l_doc_err_rec,
11124: x_errTokenTab
11125: );
11126:
11127: IBY_VALIDATIONSETS_PUB.
11128: insertIntoErrorTable(
11129: l_doc_err_rec, x_docErrorTab,
11130: x_errTokenTab);
11131:

Line 11165: IBY_VALIDATIONSETS_PUB.

11161: l_doc_err_rec,
11162: x_errTokenTab
11163: );
11164:
11165: IBY_VALIDATIONSETS_PUB.
11166: insertIntoErrorTable(
11167: l_doc_err_rec, x_docErrorTab,
11168: x_errTokenTab);
11169:

Line 12387: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

12383: x_paymentTab IN OUT NOCOPY paymentTabType,
12384: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
12385: x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
12386: x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType,
12387: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
12388: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
12389: trxnErrTokenTabType
12390: )
12391: IS

Line 12388: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

12384: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
12385: x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
12386: x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType,
12387: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
12388: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
12389: trxnErrTokenTabType
12390: )
12391: IS
12392:

Line 12804: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

12800: l_doc_err_rec,
12801: x_errTokenTab
12802: );
12803:
12804: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
12805: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
12806:
12807: /* fail the docs of this payment */
12808: failDocsOfPayment(x_paymentTab(j).payment_id,

Line 12906: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

12902: l_doc_err_rec,
12903: x_errTokenTab
12904: );
12905:
12906: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
12907: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
12908:
12909: END IF;
12910:

Line 12963: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

12959: -- x_hookPaymentTab IN OUT NOCOPY hookPaymentTabType,
12960: -- x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType,
12961: p_cap_payreq_cd IN VARCHAR2,
12962: l_prehook_count IN NUMBER,
12963: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
12964: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
12965: trxnErrTokenTabType
12966: )
12967: IS

Line 12964: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

12960: -- x_hookDocsInPmtTab IN OUT NOCOPY hookDocsInPaymentTabType,
12961: p_cap_payreq_cd IN VARCHAR2,
12962: l_prehook_count IN NUMBER,
12963: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
12964: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
12965: trxnErrTokenTabType
12966: )
12967: IS
12968:

Line 13506: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

13502: l_doc_err_rec,
13503: x_errTokenTab
13504: );
13505:
13506: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
13507: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
13508:
13509: /* fail the docs of this payment */
13510: failDocsOfPayment(hookPmtsTab(j).payment_id,

Line 13569: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

13565: l_doc_err_rec,
13566: x_errTokenTab
13567: );
13568:
13569: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
13570: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
13571:
13572: END LOOP;
13573: END IF; -- IF (l_fail_dop_tbl.COUNT > 0 )

Line 13631: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

13627: *---------------------------------------------------------------------*/
13628: PROCEDURE adjustSisterDocsAndPmts(
13629: x_paymentTab IN OUT NOCOPY paymentTabType,
13630: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
13631: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
13632: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
13633: )
13634: IS
13635:

Line 13632: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

13628: PROCEDURE adjustSisterDocsAndPmts(
13629: x_paymentTab IN OUT NOCOPY paymentTabType,
13630: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
13631: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
13632: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
13633: )
13634: IS
13635:
13636: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

Line 13731: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

13727: l_doc_err_rec,
13728: x_errTokenTab
13729: );
13730:
13731: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
13732: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
13733:
13734: /* b. adjust payment amount */
13735: FOR k in x_paymentTab.FIRST .. x_paymentTab.LAST

Line 13822: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

13818: *---------------------------------------------------------------------*/
13819: PROCEDURE adjustSisterDocsAndPmts(
13820: -- x_paymentTab IN OUT NOCOPY paymentTabType,
13821: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
13822: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
13823: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
13824: )
13825: IS
13826:

Line 13823: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

13819: PROCEDURE adjustSisterDocsAndPmts(
13820: -- x_paymentTab IN OUT NOCOPY paymentTabType,
13821: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
13822: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
13823: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
13824: )
13825: IS
13826:
13827: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

Line 13951: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

13947: l_doc_err_rec,
13948: x_errTokenTab
13949: );
13950:
13951: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
13952: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
13953:
13954:
13955:

Line 14051: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

14047: *---------------------------------------------------------------------*/
14048: PROCEDURE adjustSisterDocsAndPmtsPost(
14049: -- x_paymentTab IN OUT NOCOPY paymentTabType,
14050: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
14051: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
14052: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
14053: )
14054: IS
14055:

Line 14052: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

14048: PROCEDURE adjustSisterDocsAndPmtsPost(
14049: -- x_paymentTab IN OUT NOCOPY paymentTabType,
14050: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
14051: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
14052: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
14053: )
14054: IS
14055:
14056: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

Line 14160: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

14156: l_doc_err_rec,
14157: x_errTokenTab
14158: );
14159:
14160: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
14161: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
14162:
14163:
14164:

Line 15596: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

15592: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15593: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15594: document_status%TYPE,
15595: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
15596: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15597: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15598: )
15599: IS
15600: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 15597: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

15593: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15594: document_status%TYPE,
15595: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
15596: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15597: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15598: )
15599: IS
15600: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
15601: '.failDocsOfPayment';

Line 15655: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

15651:
15652: /*
15653: * Add error record to errors table.
15654: */
15655: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
15656: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
15657:
15658: END IF;
15659:

Line 15693: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

15689: PROCEDURE failDocsOfPayment(
15690: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15691: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15692: document_status%TYPE,
15693: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15694: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15695: )
15696: IS
15697: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 15694: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

15690: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
15691: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
15692: document_status%TYPE,
15693: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
15694: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
15695: )
15696: IS
15697: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
15698: '.failDocsOfPayment';

Line 15783: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

15779:
15780: /*
15781: * Add error record to errors table.
15782: */
15783: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
15784: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
15785:
15786: END IF;
15787:

Line 16587: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

16583: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
16584: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
16585: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
16586: x_return_status IN OUT NOCOPY VARCHAR2,
16587: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
16588: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
16589: trxnErrTokenTabType
16590: )
16591: IS

Line 16588: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

16584: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
16585: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
16586: x_return_status IN OUT NOCOPY VARCHAR2,
16587: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
16588: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
16589: trxnErrTokenTabType
16590: )
16591: IS
16592: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 16705: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

16701: x_errTokenTab,
16702: NULL
16703: );
16704:
16705: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
16706: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
16707:
16708: failDocsOfPayment(x_paymentTab(i).payment_id,
16709: DOC_STATUS_PAY_VAL_FAIL,

Line 16912: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

16908: x_errTokenTab,
16909: NULL
16910: );
16911:
16912: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
16913: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
16914:
16915: failDocsOfPayment(x_paymentTab(i).payment_id,
16916: DOC_STATUS_PAY_VAL_FAIL,

Line 17131: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N', x_docErrorTab,

17127: * If any payments/documents were failed, the IBY_TRANSACTION_
17128: * ERRORS table must be populated with the corresponding error
17129: * messages.
17130: */
17131: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N', x_docErrorTab,
17132: x_errTokenTab);
17133:
17134: /*
17135: * Update the status of the payment request.

Line 17224: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

17220: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
17221: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
17222: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
17223: x_return_status IN OUT NOCOPY VARCHAR2,
17224: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
17225: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
17226: trxnErrTokenTabType
17227: )
17228: IS

Line 17225: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.

17221: x_allPmtsSuccessFlag IN OUT NOCOPY BOOLEAN,
17222: x_allPmtsFailedFlag IN OUT NOCOPY BOOLEAN,
17223: x_return_status IN OUT NOCOPY VARCHAR2,
17224: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
17225: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
17226: trxnErrTokenTabType
17227: )
17228: IS
17229: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 17410: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

17406: x_errTokenTab,
17407: l_triggering_pmt_id
17408: );
17409:
17410: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
17411: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
17412:
17413: failDocsOfPayment(IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
17414: DOC_STATUS_PAY_VAL_FAIL,

Line 17541: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

17537: l_doc_err_rec
17538: );
17539:
17540:
17541: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
17542: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
17543:
17544: failDocsOfPayment(IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
17545: DOC_STATUS_PAY_VAL_FAIL,

Line 17680: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

17676: x_errTokenTab,
17677: l_triggering_pmt_id
17678: );
17679:
17680: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
17681: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
17682:
17683: failDocsOfPayment(IBY_PAYGROUP_PUB.pmtTable.payment_id(i),
17684: DOC_STATUS_PAY_VAL_FAIL,

Line 17986: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N', x_docErrorTab,

17982: * If any payments/documents were failed, the IBY_TRANSACTION_
17983: * ERRORS table must be populated with the corresponding error
17984: * messages.
17985: */
17986: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N', x_docErrorTab,
17987: x_errTokenTab);
17988:
17989:
17990: /*

Line 18083: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

18079: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
18080: payment_service_request_id%TYPE,
18081:
18082: l_trx_valid_index IN BINARY_INTEGER,
18083: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
18084: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
18085: )
18086: IS
18087:

Line 18084: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

18080: payment_service_request_id%TYPE,
18081:
18082: l_trx_valid_index IN BINARY_INTEGER,
18083: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
18084: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
18085: )
18086: IS
18087:
18088: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 18321: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

18317: FND_MESSAGE.get,
18318: l_doc_err_rec
18319: );
18320:
18321: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
18322: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
18323:
18324: /* fail the docs of this payment */
18325: failDocsOfPayment(IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_valid_index),

Line 19381: l_rej_docs_list IBY_VALIDATIONSETS_PUB.rejectedDocTabType;

19377: x_docStatusTab IN OUT NOCOPY IBY_DISBURSE_UI_API_PUB_PKG.docPayStatusTab
19378: )
19379: IS
19380: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getRejectedDocs';
19381: l_rej_docs_list IBY_VALIDATIONSETS_PUB.rejectedDocTabType;
19382:
19383: /*
19384: * Cursor to get list of failed documents which are part of payments
19385: * created for the given payment service request.

Line 21585: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

21581: p_cap_payreq_cd IN VARCHAR2,
21582: p_cap_id IN NUMBER,
21583: x_paymentTab IN OUT NOCOPY paymentTabType,
21584: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
21585: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
21586: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
21587: )
21588: IS
21589:

Line 21586: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

21582: p_cap_id IN NUMBER,
21583: x_paymentTab IN OUT NOCOPY paymentTabType,
21584: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
21585: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
21586: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
21587: )
21588: IS
21589:
21590: /* these two are passed to calling app via hook */

Line 21755: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

21751: p_ppr_id IN NUMBER,
21752: p_cap_id IN NUMBER,
21753: -- x_paymentTab IN OUT NOCOPY paymentTabType,
21754: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
21755: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
21756: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
21757: )
21758: IS
21759:

Line 21756: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

21752: p_cap_id IN NUMBER,
21753: -- x_paymentTab IN OUT NOCOPY paymentTabType,
21754: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
21755: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
21756: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
21757: )
21758: IS
21759:
21760: /* these two are passed to calling app via hook */

Line 21943: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

21939: p_cap_payreq_cd IN VARCHAR2,
21940: p_cap_id IN NUMBER,
21941: x_paymentTab IN OUT NOCOPY paymentTabType,
21942: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
21943: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
21944: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
21945: )
21946: IS
21947:

Line 21944: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

21940: p_cap_id IN NUMBER,
21941: x_paymentTab IN OUT NOCOPY paymentTabType,
21942: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
21943: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
21944: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
21945: )
21946: IS
21947:
21948: /* these two are passed to calling app via hook */

Line 22110: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

22106: p_ppr_id IN NUMBER,
22107: p_cap_id IN NUMBER,
22108: -- x_paymentTab IN OUT NOCOPY paymentTabType,
22109: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
22110: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
22111: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
22112: )
22113: IS
22114:

Line 22111: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

22107: p_cap_id IN NUMBER,
22108: -- x_paymentTab IN OUT NOCOPY paymentTabType,
22109: -- x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
22110: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
22111: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
22112: )
22113: IS
22114:
22115: /* these two are passed to calling app via hook */

Line 26692: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

26688: |
26689: *---------------------------------------------------------------------*/
26690: PROCEDURE negativePmtAmountCheck(
26691: p_trx_pmt_line_index IN BINARY_INTEGER,
26692: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
26693: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
26694: )
26695: IS
26696: l_module_name VARCHAR2(200) := G_PKG_NAME || '.negativePmtAmountCheck';

Line 26693: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

26689: *---------------------------------------------------------------------*/
26690: PROCEDURE negativePmtAmountCheck(
26691: p_trx_pmt_line_index IN BINARY_INTEGER,
26692: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
26693: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
26694: )
26695: IS
26696: l_module_name VARCHAR2(200) := G_PKG_NAME || '.negativePmtAmountCheck';
26697: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

Line 26745: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(

26741: FND_MESSAGE.get,
26742: l_doc_err_rec
26743: );
26744:
26745: IBY_VALIDATIONSETS_PUB.insertIntoErrorTable(
26746: l_doc_err_rec, x_docErrorTab, x_errTokenTab);
26747:
26748: failDocsOfPayment(IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_pmt_line_index),
26749: DOC_STATUS_PAY_VAL_FAIL,