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_BUILD_UTILS_PKG dependencies on IBY_TRANSACTION_ERRORS

Line 340: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

336: p_fieldValue IN VARCHAR2,
337: p_isComposite IN BOOLEAN,
338: p_validCharsList IN VARCHAR2,
339: p_invalidCharsList IN VARCHAR2,
340: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
341: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.
342: docErrorTabType
343: )
344: IS

Line 721: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,

717: | NOTES:
718: |
719: *---------------------------------------------------------------------*/
720: PROCEDURE createErrorRecord(
721: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.

Line 736: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

732: calling_app_doc_unique_ref4%TYPE,
733: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
734: calling_app_doc_unique_ref5%TYPE,
735: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
736: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
737: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
738: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE -- AWT Enh 16296267
739: DEFAULT NULL,
740: p_error_code IN VARCHAR2 DEFAULT NULL

Line 902: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE

898: PROCEDURE createPmtErrorRecord(
899: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
900: p_pmt_status IN IBY_PAYMENTS_ALL.
901: payment_status%TYPE,
902: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
903: DEFAULT NULL,
904: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
905: DEFAULT NULL,
906: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE

Line 904: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE

900: p_pmt_status IN IBY_PAYMENTS_ALL.
901: payment_status%TYPE,
902: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
903: DEFAULT NULL,
904: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
905: DEFAULT NULL,
906: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
907: )
908: IS

Line 906: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE

902: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
903: DEFAULT NULL,
904: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
905: DEFAULT NULL,
906: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
907: )
908: IS
909:
910: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createPmtErrorRecord';

Line 1575: p_trxn_id IN IBY_TRANSACTION_ERRORS.transaction_id%TYPE,

1571: | NOTES:
1572: |
1573: *---------------------------------------------------------------------*/
1574: PROCEDURE inactivateOldErrors(
1575: p_trxn_id IN IBY_TRANSACTION_ERRORS.transaction_id%TYPE,
1576: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE
1577: )
1578: IS
1579: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.inactivateOldErrors';

Line 1576: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE

1572: |
1573: *---------------------------------------------------------------------*/
1574: PROCEDURE inactivateOldErrors(
1575: p_trxn_id IN IBY_TRANSACTION_ERRORS.transaction_id%TYPE,
1576: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE
1577: )
1578: IS
1579: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.inactivateOldErrors';
1580:

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

1590: );
1591:
1592: END IF;
1593: /*
1594: * Set the error status to inactive in the IBY_TRANSACTION_ERRORS
1595: * table for all rows that contain errors against this
1596: * transaction.
1597: */
1598: UPDATE

Line 1599: IBY_TRANSACTION_ERRORS err

1595: * table for all rows that contain errors against this
1596: * transaction.
1597: */
1598: UPDATE
1599: IBY_TRANSACTION_ERRORS err
1600: SET
1601: err.error_status = 'INACTIVE',
1602: err.last_update_date = sysdate,
1603: err.last_updated_by = fnd_global.user_id

Line 1626: IBY_TRANSACTION_ERRORS err

1622: );
1623:
1624: END IF;
1625: UPDATE
1626: IBY_TRANSACTION_ERRORS err
1627: SET
1628: err.error_status = 'INACTIVE',
1629: err.last_update_date = sysdate,
1630: err.last_updated_by = fnd_global.user_id

Line 1758: IBY_TRANSACTION_ERRORS err

1754: * We are going to revalidate these payments, so old errors
1755: * need not be persisted at this point.
1756: */
1757: DELETE
1758: IBY_TRANSACTION_ERRORS err
1759: WHERE
1760: err.transaction_type = 'PAYMENT' AND
1761: err.transaction_id IN
1762: (

Line 1792: IBY_TRANSACTION_ERRORS err

1788: * delete errors on underlying documents payable
1789: * as well.
1790: */
1791: DELETE
1792: IBY_TRANSACTION_ERRORS err
1793: WHERE
1794: err.transaction_type = 'DOCUMENT_PAYABLE' AND
1795: err.transaction_id IN
1796: (

Line 1872: IBY_TRANSACTION_ERRORS err

1868: * Delete existing errors against documents payable that
1869: * are to be re-validated
1870: */
1871: DELETE
1872: IBY_TRANSACTION_ERRORS err
1873: WHERE
1874: err.transaction_type = 'DOCUMENT_PAYABLE' AND
1875: err.transaction_id IN
1876: (

Line 1946: IBY_TRANSACTION_ERRORS err

1942: * child elements (like payments) etc. because these
1943: * are untouched by the PICP.
1944: */
1945: DELETE
1946: IBY_TRANSACTION_ERRORS err
1947: WHERE
1948: err.transaction_type = 'PAYMENT_INSTRUCTION' AND
1949: err.transaction_id = p_instr_id
1950: ;