DBA Data[Home] [Help]

APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_TRANSACTION_ERRORS

Line 311: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

307: p_fieldValue IN VARCHAR2,
308: p_isComposite IN BOOLEAN,
309: p_validCharsList IN VARCHAR2,
310: p_invalidCharsList IN VARCHAR2,
311: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
312: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
313: docErrorTabType
314: )
315: IS

Line 676: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,

672: | NOTES:
673: |
674: *---------------------------------------------------------------------*/
675: PROCEDURE createErrorRecord(
676: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
677: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.

Line 691: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

687: calling_app_doc_unique_ref4%TYPE,
688: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
689: calling_app_doc_unique_ref5%TYPE,
690: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
691: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
692: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
693: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
694: DEFAULT NULL,
695: p_error_code IN VARCHAR2 DEFAULT NULL

Line 847: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE

843: PROCEDURE createPmtErrorRecord(
844: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
845: p_pmt_status IN IBY_PAYMENTS_ALL.
846: payment_status%TYPE,
847: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
848: DEFAULT NULL,
849: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
850: DEFAULT NULL,
851: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE

Line 849: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE

845: p_pmt_status IN IBY_PAYMENTS_ALL.
846: payment_status%TYPE,
847: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
848: DEFAULT NULL,
849: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
850: DEFAULT NULL,
851: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
852: )
853: IS

Line 851: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE

847: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
848: DEFAULT NULL,
849: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
850: DEFAULT NULL,
851: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
852: )
853: IS
854:
855: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createPmtErrorRecord';

Line 1254: p_trxn_id IN IBY_TRANSACTION_ERRORS.transaction_id%TYPE,

1250: | NOTES:
1251: |
1252: *---------------------------------------------------------------------*/
1253: PROCEDURE inactivateOldErrors(
1254: p_trxn_id IN IBY_TRANSACTION_ERRORS.transaction_id%TYPE,
1255: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE
1256: )
1257: IS
1258: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.inactivateOldErrors';

Line 1255: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE

1251: |
1252: *---------------------------------------------------------------------*/
1253: PROCEDURE inactivateOldErrors(
1254: p_trxn_id IN IBY_TRANSACTION_ERRORS.transaction_id%TYPE,
1255: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE
1256: )
1257: IS
1258: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.inactivateOldErrors';
1259:

Line 1271: * Set the error status to inactive in the IBY_TRANSACTION_ERRORS

1267: || p_trxn_id
1268: );
1269:
1270: /*
1271: * Set the error status to inactive in the IBY_TRANSACTION_ERRORS
1272: * table for all rows that contain errors against this
1273: * transaction.
1274: */
1275: UPDATE

Line 1276: IBY_TRANSACTION_ERRORS err

1272: * table for all rows that contain errors against this
1273: * transaction.
1274: */
1275: UPDATE
1276: IBY_TRANSACTION_ERRORS err
1277: SET
1278: err.error_status = 'INACTIVE',
1279: err.last_update_date = sysdate,
1280: err.last_updated_by = fnd_global.user_id

Line 1301: IBY_TRANSACTION_ERRORS err

1297: || p_trxn_id
1298: );
1299:
1300: UPDATE
1301: IBY_TRANSACTION_ERRORS err
1302: SET
1303: err.error_status = 'INACTIVE',
1304: err.last_update_date = sysdate,
1305: err.last_updated_by = fnd_global.user_id