207:
208: l_instrGrpCriTab instrGroupCriteriaTabType;
209:
210: /* holds the error messages against failed instructions */
211: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
212: l_errTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
213:
214: /* previous payment attributes */
215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
208: l_instrGrpCriTab instrGroupCriteriaTabType;
209:
210: /* holds the error messages against failed instructions */
211: l_docErrorTab IBY_VALIDATIONSETS_PUB.docErrorTabType;
212: l_errTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
213:
214: /* previous payment attributes */
215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
216: prev_pmt_id iby_payments_all.payment_id%TYPE;
1549: *---------------------------------------------------------------------*/
1550: PROCEDURE recreatePaymentInstruction(
1551: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%
1552: ROWTYPE,
1553: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
1554: docErrorTabType,
1555: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
1556: trxnErrTokenTabType,
1557: x_return_status IN OUT NOCOPY NUMBER)
1551: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%
1552: ROWTYPE,
1553: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
1554: docErrorTabType,
1555: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
1556: trxnErrTokenTabType,
1557: x_return_status IN OUT NOCOPY NUMBER)
1558: IS
1559:
3051: *---------------------------------------------------------------------*/
3052: PROCEDURE performInstructionValidations(
3053: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
3054: x_pmtsInPmtInstrTab IN OUT NOCOPY pmtsInPmtInstrTabType,
3055: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3056: docErrorTabType,
3057: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3058: trxnErrTokenTabType
3059: )
3053: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
3054: x_pmtsInPmtInstrTab IN OUT NOCOPY pmtsInPmtInstrTabType,
3055: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3056: docErrorTabType,
3057: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3058: trxnErrTokenTabType
3059: )
3060: IS
3061:
3115: *---------------------------------------------------------------------*/
3116: PROCEDURE performDBUpdates(
3117: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
3118: x_pmtsInPmtInstrTab IN OUT NOCOPY pmtsInPmtInstrTabType,
3119: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3120: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3121: trxnErrTokenTabType,
3122: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
3123: x_return_status IN OUT NOCOPY VARCHAR2
3116: PROCEDURE performDBUpdates(
3117: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
3118: x_pmtsInPmtInstrTab IN OUT NOCOPY pmtsInPmtInstrTabType,
3119: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3120: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
3121: trxnErrTokenTabType,
3122: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
3123: x_return_status IN OUT NOCOPY VARCHAR2
3124: )
3167: * If any payment instructions/payments were failed, the
3168: * IBY_TRANSACTION_ERRORS table must be populated with the
3169: * corresponding error messages.
3170: */
3171: IBY_VALIDATIONSETS_PUB.insert_transaction_errors('N', x_docErrorTab,
3172: x_errTokenTab);
3173:
3174: /* Pass back the return status to the caller */
3175: x_return_status := FND_API.G_RET_STS_SUCCESS;
3216: |
3217: *---------------------------------------------------------------------*/
3218: PROCEDURE applyPayInstrValidationSets(
3219: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
3220: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3221: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3222: )
3223: IS
3224:
3217: *---------------------------------------------------------------------*/
3218: PROCEDURE applyPayInstrValidationSets(
3219: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
3220: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3221: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3222: )
3223: IS
3224:
3225: l_module_name VARCHAR2(200) := G_PKG_NAME || '.applyPayInstrValidationSets';
3354: |
3355: *---------------------------------------------------------------------*/
3356: PROCEDURE reApplyPayInstrValidationSets(
3357: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3358: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3359: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3360: )
3361: IS
3362:
3355: *---------------------------------------------------------------------*/
3356: PROCEDURE reApplyPayInstrValidationSets(
3357: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3358: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3359: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3360: )
3361: IS
3362:
3363: l_module_name VARCHAR2(200) := G_PKG_NAME ||
3574: PROCEDURE executeValidationsForInstr(
3575: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3576: p_valSetsTab IN instructionValSetsTab,
3577: p_isReval IN BOOLEAN,
3578: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3579: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3580: )
3581: IS
3582:
3575: x_pmtInstrRec IN OUT NOCOPY IBY_PAY_INSTRUCTIONS_ALL%ROWTYPE,
3576: p_valSetsTab IN instructionValSetsTab,
3577: p_isReval IN BOOLEAN,
3578: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3579: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3580: )
3581: IS
3582:
3583: l_module_name VARCHAR2(200) := G_PKG_NAME || '.executeValidationsForInstr';
4038: PROCEDURE performSortedPaymentNumbering(
4039: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
4040: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType,
4041: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
4042: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4043: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4044: )
4045: IS
4046:
4039: x_pmtInstrTab IN OUT NOCOPY pmtInstrTabType,
4040: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType,
4041: p_profileMap IN IBY_BUILD_UTILS_PKG.profileIdToCodeMapTabType,
4042: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4043: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4044: )
4045: IS
4046:
4047: l_module_name VARCHAR2(200) := G_PKG_NAME || '.performSortedPaymentNumbering';
4526: |
4527: *---------------------------------------------------------------------*/
4528: PROCEDURE performDocSequenceNumbering(
4529: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType,
4530: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4531: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4532: )
4533: IS
4534:
4527: *---------------------------------------------------------------------*/
4528: PROCEDURE performDocSequenceNumbering(
4529: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType,
4530: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4531: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4532: )
4533: IS
4534:
4535: l_module_name VARCHAR2(200) := G_PKG_NAME || '.performDocSequenceNumbering';
4765: |
4766: *---------------------------------------------------------------------*/
4767: PROCEDURE assignSequenceNumbers(
4768: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType,
4769: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4770: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4771: )
4772:
4773: IS
4766: *---------------------------------------------------------------------*/
4767: PROCEDURE assignSequenceNumbers(
4768: x_sortedPmtTab IN OUT NOCOPY sortedPmtTabType,
4769: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
4770: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
4771: )
4772:
4773: IS
4774: