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

Line 55: -- Transaction type (for inserting into IBY_TRANSACTION_ERRORS table)

51: REQ_STATUS_VALIDATED CONSTANT VARCHAR2(100) := 'DOCUMENTS_VALIDATED';
52: REQ_STATUS_USER_REVW_ERR CONSTANT VARCHAR2(100) :=
53: 'PENDING_REVIEW_DOC_VAL_ERRORS';
54:
55: -- Transaction type (for inserting into IBY_TRANSACTION_ERRORS table)
56: TRXN_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
57:
58: -- Dummy record
59: l_dummy_err_token_tab trxnErrTokenTabType;

Line 444: * IBY_TRANSACTION_ERRORS table.

440:
441: /*
442: * We have collected all the error messages against the failed
443: * documents in a PLSQL table. Use this to update the
444: * IBY_TRANSACTION_ERRORS table.
445: */
446: insert_transaction_errors('N', x_txnErrorsTab, x_errTokenTab);
447:
448: /*

Line 640: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

636:
637: --l_bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;
638:
639: l_print_var VARCHAR2(1) := '';
640: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
641: l_doc_token_tab trxnErrTokenTabType;
642: l_ext_bank_acct_id IBY_EXT_BANK_ACCOUNTS_V.ext_bank_account_id%TYPE;
643: l_end_date IBY_EXT_BANK_ACCOUNTS_V.end_date%TYPE;
644: l_country_code IBY_EXT_BANK_ACCOUNTS_V.country_code%TYPE;

Line 870: * status in the IBY_TRANSACTION_ERRORS table.

866: *
867: * Before doing any validations, set any
868: * existing validation error messages that
869: * exist against this document to 'inactive'
870: * status in the IBY_TRANSACTION_ERRORS table.
871: *
872: * Unless we do this, the old errors will
873: * continue to show up against this document
874: * in the IBY UI even if the document is validated

Line 3270: | IBY_TRANSACTION_ERRORS_GT; for deferred validations, the

Line 3271: | error messages are inserted into IBY_TRANSACTION_ERRORS

3267: | PURPOSE:
3268: | Inserts the error messages into the errors table. For
3269: | online validations, the error messages are inserted into
3270: | IBY_TRANSACTION_ERRORS_GT; for deferred validations, the
3271: | error messages are inserted into IBY_TRANSACTION_ERRORS
3272: | table.
3273: |
3274: | Validation sets populate the transaction errors into a PLSQL
3275: | table. This method performs a bulk insert of the given records

Line 3300: * Column types for insertion into IBY_TRANSACTION_ERRORS table.

3296: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3297: '.insert_transaction_errors';
3298:
3299: /*
3300: * Column types for insertion into IBY_TRANSACTION_ERRORS table.
3301: */
3302: TYPE t_transaction_error_id IS TABLE OF
3303: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE
3304: INDEX BY BINARY_INTEGER;

Line 3303: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE

3299: /*
3300: * Column types for insertion into IBY_TRANSACTION_ERRORS table.
3301: */
3302: TYPE t_transaction_error_id IS TABLE OF
3303: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE
3304: INDEX BY BINARY_INTEGER;
3305: TYPE t_transaction_type IS TABLE OF
3306: IBY_TRANSACTION_ERRORS.transaction_type%TYPE
3307: INDEX BY BINARY_INTEGER;

Line 3306: IBY_TRANSACTION_ERRORS.transaction_type%TYPE

3302: TYPE t_transaction_error_id IS TABLE OF
3303: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE
3304: INDEX BY BINARY_INTEGER;
3305: TYPE t_transaction_type IS TABLE OF
3306: IBY_TRANSACTION_ERRORS.transaction_type%TYPE
3307: INDEX BY BINARY_INTEGER;
3308: TYPE t_transaction_id IS TABLE OF
3309: IBY_TRANSACTION_ERRORS.transaction_id%TYPE
3310: INDEX BY BINARY_INTEGER;

Line 3309: IBY_TRANSACTION_ERRORS.transaction_id%TYPE

3305: TYPE t_transaction_type IS TABLE OF
3306: IBY_TRANSACTION_ERRORS.transaction_type%TYPE
3307: INDEX BY BINARY_INTEGER;
3308: TYPE t_transaction_id IS TABLE OF
3309: IBY_TRANSACTION_ERRORS.transaction_id%TYPE
3310: INDEX BY BINARY_INTEGER;
3311: TYPE t_error_code IS TABLE OF
3312: IBY_TRANSACTION_ERRORS.error_code%TYPE
3313: INDEX BY BINARY_INTEGER;

Line 3312: IBY_TRANSACTION_ERRORS.error_code%TYPE

3308: TYPE t_transaction_id IS TABLE OF
3309: IBY_TRANSACTION_ERRORS.transaction_id%TYPE
3310: INDEX BY BINARY_INTEGER;
3311: TYPE t_error_code IS TABLE OF
3312: IBY_TRANSACTION_ERRORS.error_code%TYPE
3313: INDEX BY BINARY_INTEGER;
3314: TYPE t_error_date IS TABLE OF
3315: IBY_TRANSACTION_ERRORS.error_date%TYPE
3316: INDEX BY BINARY_INTEGER;

Line 3315: IBY_TRANSACTION_ERRORS.error_date%TYPE

3311: TYPE t_error_code IS TABLE OF
3312: IBY_TRANSACTION_ERRORS.error_code%TYPE
3313: INDEX BY BINARY_INTEGER;
3314: TYPE t_error_date IS TABLE OF
3315: IBY_TRANSACTION_ERRORS.error_date%TYPE
3316: INDEX BY BINARY_INTEGER;
3317: TYPE t_error_status IS TABLE OF
3318: IBY_TRANSACTION_ERRORS.error_status%TYPE
3319: INDEX BY BINARY_INTEGER;

Line 3318: IBY_TRANSACTION_ERRORS.error_status%TYPE

3314: TYPE t_error_date IS TABLE OF
3315: IBY_TRANSACTION_ERRORS.error_date%TYPE
3316: INDEX BY BINARY_INTEGER;
3317: TYPE t_error_status IS TABLE OF
3318: IBY_TRANSACTION_ERRORS.error_status%TYPE
3319: INDEX BY BINARY_INTEGER;
3320: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
3321: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE
3322: INDEX BY BINARY_INTEGER;

Line 3321: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE

3317: TYPE t_error_status IS TABLE OF
3318: IBY_TRANSACTION_ERRORS.error_status%TYPE
3319: INDEX BY BINARY_INTEGER;
3320: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
3321: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE
3322: INDEX BY BINARY_INTEGER;
3323: TYPE t_ovrride_allowed_on_err_flg IS TABLE OF
3324: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE
3325: INDEX BY BINARY_INTEGER;

Line 3324: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE

3320: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
3321: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE
3322: INDEX BY BINARY_INTEGER;
3323: TYPE t_ovrride_allowed_on_err_flg IS TABLE OF
3324: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE
3325: INDEX BY BINARY_INTEGER;
3326: TYPE t_do_not_apply_error_flag IS TABLE OF
3327: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE
3328: INDEX BY BINARY_INTEGER;

Line 3327: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE

3323: TYPE t_ovrride_allowed_on_err_flg IS TABLE OF
3324: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE
3325: INDEX BY BINARY_INTEGER;
3326: TYPE t_do_not_apply_error_flag IS TABLE OF
3327: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE
3328: INDEX BY BINARY_INTEGER;
3329: TYPE t_created_by IS TABLE OF
3330: IBY_TRANSACTION_ERRORS.created_by%TYPE
3331: INDEX BY BINARY_INTEGER;

Line 3330: IBY_TRANSACTION_ERRORS.created_by%TYPE

3326: TYPE t_do_not_apply_error_flag IS TABLE OF
3327: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE
3328: INDEX BY BINARY_INTEGER;
3329: TYPE t_created_by IS TABLE OF
3330: IBY_TRANSACTION_ERRORS.created_by%TYPE
3331: INDEX BY BINARY_INTEGER;
3332: TYPE t_creation_date IS TABLE OF
3333: IBY_TRANSACTION_ERRORS.creation_date%TYPE
3334: INDEX BY BINARY_INTEGER;

Line 3333: IBY_TRANSACTION_ERRORS.creation_date%TYPE

3329: TYPE t_created_by IS TABLE OF
3330: IBY_TRANSACTION_ERRORS.created_by%TYPE
3331: INDEX BY BINARY_INTEGER;
3332: TYPE t_creation_date IS TABLE OF
3333: IBY_TRANSACTION_ERRORS.creation_date%TYPE
3334: INDEX BY BINARY_INTEGER;
3335: TYPE t_last_updated_by IS TABLE OF
3336: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE
3337: INDEX BY BINARY_INTEGER;

Line 3336: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE

3332: TYPE t_creation_date IS TABLE OF
3333: IBY_TRANSACTION_ERRORS.creation_date%TYPE
3334: INDEX BY BINARY_INTEGER;
3335: TYPE t_last_updated_by IS TABLE OF
3336: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE
3337: INDEX BY BINARY_INTEGER;
3338: TYPE t_last_update_date IS TABLE OF
3339: IBY_TRANSACTION_ERRORS.last_update_date%TYPE
3340: INDEX BY BINARY_INTEGER;

Line 3339: IBY_TRANSACTION_ERRORS.last_update_date%TYPE

3335: TYPE t_last_updated_by IS TABLE OF
3336: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE
3337: INDEX BY BINARY_INTEGER;
3338: TYPE t_last_update_date IS TABLE OF
3339: IBY_TRANSACTION_ERRORS.last_update_date%TYPE
3340: INDEX BY BINARY_INTEGER;
3341: TYPE t_object_version_number IS TABLE OF
3342: IBY_TRANSACTION_ERRORS.object_version_number%TYPE
3343: INDEX BY BINARY_INTEGER;

Line 3342: IBY_TRANSACTION_ERRORS.object_version_number%TYPE

3338: TYPE t_last_update_date IS TABLE OF
3339: IBY_TRANSACTION_ERRORS.last_update_date%TYPE
3340: INDEX BY BINARY_INTEGER;
3341: TYPE t_object_version_number IS TABLE OF
3342: IBY_TRANSACTION_ERRORS.object_version_number%TYPE
3343: INDEX BY BINARY_INTEGER;
3344: TYPE t_last_update_login IS TABLE OF
3345: IBY_TRANSACTION_ERRORS.last_update_login%TYPE
3346: INDEX BY BINARY_INTEGER;

Line 3345: IBY_TRANSACTION_ERRORS.last_update_login%TYPE

3341: TYPE t_object_version_number IS TABLE OF
3342: IBY_TRANSACTION_ERRORS.object_version_number%TYPE
3343: INDEX BY BINARY_INTEGER;
3344: TYPE t_last_update_login IS TABLE OF
3345: IBY_TRANSACTION_ERRORS.last_update_login%TYPE
3346: INDEX BY BINARY_INTEGER;
3347: TYPE t_calling_app_id IS TABLE OF
3348: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE
3349: INDEX BY BINARY_INTEGER;

Line 3348: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE

3344: TYPE t_last_update_login IS TABLE OF
3345: IBY_TRANSACTION_ERRORS.last_update_login%TYPE
3346: INDEX BY BINARY_INTEGER;
3347: TYPE t_calling_app_id IS TABLE OF
3348: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE
3349: INDEX BY BINARY_INTEGER;
3350: TYPE t_pay_proc_trxn_type_code IS TABLE OF
3351: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE
3352: INDEX BY BINARY_INTEGER;

Line 3351: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE

3347: TYPE t_calling_app_id IS TABLE OF
3348: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE
3349: INDEX BY BINARY_INTEGER;
3350: TYPE t_pay_proc_trxn_type_code IS TABLE OF
3351: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE
3352: INDEX BY BINARY_INTEGER;
3353: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
3354: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE
3355: INDEX BY BINARY_INTEGER;

Line 3354: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE

3350: TYPE t_pay_proc_trxn_type_code IS TABLE OF
3351: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE
3352: INDEX BY BINARY_INTEGER;
3353: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
3354: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE
3355: INDEX BY BINARY_INTEGER;
3356: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
3357: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE
3358: INDEX BY BINARY_INTEGER;

Line 3357: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE

3353: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
3354: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE
3355: INDEX BY BINARY_INTEGER;
3356: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
3357: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE
3358: INDEX BY BINARY_INTEGER;
3359: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
3360: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE
3361: INDEX BY BINARY_INTEGER;

Line 3360: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE

3356: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
3357: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE
3358: INDEX BY BINARY_INTEGER;
3359: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
3360: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE
3361: INDEX BY BINARY_INTEGER;
3362: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
3363: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE
3364: INDEX BY BINARY_INTEGER;

Line 3363: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE

3359: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
3360: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE
3361: INDEX BY BINARY_INTEGER;
3362: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
3363: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE
3364: INDEX BY BINARY_INTEGER;
3365: TYPE t_error_type IS TABLE OF
3366: IBY_TRANSACTION_ERRORS.error_type%TYPE
3367: INDEX BY BINARY_INTEGER;

Line 3366: IBY_TRANSACTION_ERRORS.error_type%TYPE

3362: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
3363: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE
3364: INDEX BY BINARY_INTEGER;
3365: TYPE t_error_type IS TABLE OF
3366: IBY_TRANSACTION_ERRORS.error_type%TYPE
3367: INDEX BY BINARY_INTEGER;
3368: TYPE t_error_message IS TABLE OF
3369: IBY_TRANSACTION_ERRORS.error_message%TYPE
3370: INDEX BY BINARY_INTEGER;

Line 3369: IBY_TRANSACTION_ERRORS.error_message%TYPE

3365: TYPE t_error_type IS TABLE OF
3366: IBY_TRANSACTION_ERRORS.error_type%TYPE
3367: INDEX BY BINARY_INTEGER;
3368: TYPE t_error_message IS TABLE OF
3369: IBY_TRANSACTION_ERRORS.error_message%TYPE
3370: INDEX BY BINARY_INTEGER;
3371: TYPE t_validation_set_code IS TABLE OF
3372: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE
3373: INDEX BY BINARY_INTEGER;

Line 3372: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE

3368: TYPE t_error_message IS TABLE OF
3369: IBY_TRANSACTION_ERRORS.error_message%TYPE
3370: INDEX BY BINARY_INTEGER;
3371: TYPE t_validation_set_code IS TABLE OF
3372: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE
3373: INDEX BY BINARY_INTEGER;
3374: TYPE t_pass_date IS TABLE OF
3375: IBY_TRANSACTION_ERRORS.pass_date%TYPE
3376: INDEX BY BINARY_INTEGER;

Line 3375: IBY_TRANSACTION_ERRORS.pass_date%TYPE

3371: TYPE t_validation_set_code IS TABLE OF
3372: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE
3373: INDEX BY BINARY_INTEGER;
3374: TYPE t_pass_date IS TABLE OF
3375: IBY_TRANSACTION_ERRORS.pass_date%TYPE
3376: INDEX BY BINARY_INTEGER;
3377: TYPE t_override_justification IS TABLE OF
3378: IBY_TRANSACTION_ERRORS.override_justification%TYPE
3379: INDEX BY BINARY_INTEGER;

Line 3378: IBY_TRANSACTION_ERRORS.override_justification%TYPE

3374: TYPE t_pass_date IS TABLE OF
3375: IBY_TRANSACTION_ERRORS.pass_date%TYPE
3376: INDEX BY BINARY_INTEGER;
3377: TYPE t_override_justification IS TABLE OF
3378: IBY_TRANSACTION_ERRORS.override_justification%TYPE
3379: INDEX BY BINARY_INTEGER;
3380: TYPE t_override_date IS TABLE OF
3381: IBY_TRANSACTION_ERRORS.override_date%TYPE
3382: INDEX BY BINARY_INTEGER;

Line 3381: IBY_TRANSACTION_ERRORS.override_date%TYPE

3377: TYPE t_override_justification IS TABLE OF
3378: IBY_TRANSACTION_ERRORS.override_justification%TYPE
3379: INDEX BY BINARY_INTEGER;
3380: TYPE t_override_date IS TABLE OF
3381: IBY_TRANSACTION_ERRORS.override_date%TYPE
3382: INDEX BY BINARY_INTEGER;
3383:
3384: l_transaction_error_id t_transaction_error_id;
3385: l_transaction_type t_transaction_type;

Line 3561: * Insert error messages into IBY_TRANSACTION_ERRORS table.

3557:
3558: IF (UPPER(p_isOnlineVal) = 'N') THEN
3559:
3560: /*
3561: * Insert error messages into IBY_TRANSACTION_ERRORS table.
3562: */
3563:
3564: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3565: print_debuginfo(l_module_name, 'Bulk inserting errors into '

Line 3566: || 'IBY_TRANSACTION_ERRORS.');

3562: */
3563:
3564: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3565: print_debuginfo(l_module_name, 'Bulk inserting errors into '
3566: || 'IBY_TRANSACTION_ERRORS.');
3567:
3568: END IF;
3569: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3570: -- INSERT INTO IBY_TRANSACTION_ERRORS VALUES x_docErrorTab(i);

Line 3570: -- INSERT INTO IBY_TRANSACTION_ERRORS VALUES x_docErrorTab(i);

3566: || 'IBY_TRANSACTION_ERRORS.');
3567:
3568: END IF;
3569: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3570: -- INSERT INTO IBY_TRANSACTION_ERRORS VALUES x_docErrorTab(i);
3571:
3572:
3573: /*
3574: * Use named columns in bulk insert syntax to avoid any

Line 3578: INSERT INTO IBY_TRANSACTION_ERRORS

3574: * Use named columns in bulk insert syntax to avoid any
3575: * dependencies on the order of the columns in the table.
3576: */
3577: FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3578: INSERT INTO IBY_TRANSACTION_ERRORS
3579: (
3580: transaction_error_id,
3581: transaction_type,
3582: transaction_id,

Line 3642: || 'IBY_TRANSACTION_ERRORS.');

3638: ;
3639:
3640: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3641: print_debuginfo(l_module_name, 'Finished populating '
3642: || 'IBY_TRANSACTION_ERRORS.');
3643:
3644:
3645: END IF;
3646: ELSE

Line 3649: * Insert error messages into IBY_TRANSACTION_ERRORS_GT table.

3645: END IF;
3646: ELSE
3647:
3648: /*
3649: * Insert error messages into IBY_TRANSACTION_ERRORS_GT table.
3650: */
3651:
3652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3653: print_debuginfo(l_module_name, 'Bulk Inserting errors into '

Line 3654: || 'IBY_TRANSACTION_ERRORS_GT.');

3650: */
3651:
3652: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3653: print_debuginfo(l_module_name, 'Bulk Inserting errors into '
3654: || 'IBY_TRANSACTION_ERRORS_GT.');
3655:
3656: END IF;
3657: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3658: -- INSERT INTO IBY_TRANSACTION_ERRORS_GT VALUES x_docErrorTab(i);

Line 3658: -- INSERT INTO IBY_TRANSACTION_ERRORS_GT VALUES x_docErrorTab(i);

3654: || 'IBY_TRANSACTION_ERRORS_GT.');
3655:
3656: END IF;
3657: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3658: -- INSERT INTO IBY_TRANSACTION_ERRORS_GT VALUES x_docErrorTab(i);
3659:
3660: /*
3661: * Use named columns in bulk insert syntax to avoid any
3662: * dependencies on the order of the columns in the table.

Line 3665: INSERT INTO IBY_TRANSACTION_ERRORS_GT

3661: * Use named columns in bulk insert syntax to avoid any
3662: * dependencies on the order of the columns in the table.
3663: */
3664: FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3665: INSERT INTO IBY_TRANSACTION_ERRORS_GT
3666: (
3667: transaction_error_id,
3668: transaction_type,
3669: transaction_id,

Line 3729: || 'IBY_TRANSACTION_ERRORS_GT.');

3725: ;
3726:
3727: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3728: print_debuginfo(l_module_name, 'Finished populating '
3729: || 'IBY_TRANSACTION_ERRORS_GT.');
3730:
3731:
3732: END IF;
3733: END IF; -- p_isOnlineVal = 'N'

Line 3892: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

3888: | NOTES:
3889: |
3890: *---------------------------------------------------------------------*/
3891: PROCEDURE insertIntoErrorTable(
3892: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
3893: x_docErrorTab IN OUT NOCOPY docErrorTabType,
3894: x_trxnErrTokenTab IN OUT NOCOPY trxnErrTokenTabType
3895: )
3896: IS

Line 3898: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;

3894: x_trxnErrTokenTab IN OUT NOCOPY trxnErrTokenTabType
3895: )
3896: IS
3897:
3898: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
3899: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertIntoErrorTable';
3900: l_index NUMBER;
3901:
3902: BEGIN

Line 3907: /* Get the next sequence value from IBY_TRANSACTION_ERRORS_S */

3903:
3904: print_debuginfo (l_module_name, 'Validation Failed: '
3905: || x_docErrorRec.error_message);
3906:
3907: /* Get the next sequence value from IBY_TRANSACTION_ERRORS_S */
3908: IF x_docErrorRec.transaction_error_id IS NULL THEN
3909:
3910: SELECT
3911: IBY_TRANSACTION_ERRORS_S.NEXTVAL

Line 3911: IBY_TRANSACTION_ERRORS_S.NEXTVAL

3907: /* Get the next sequence value from IBY_TRANSACTION_ERRORS_S */
3908: IF x_docErrorRec.transaction_error_id IS NULL THEN
3909:
3910: SELECT
3911: IBY_TRANSACTION_ERRORS_S.NEXTVAL
3912: INTO
3913: l_transaction_error_id
3914: FROM
3915: DUAL

Line 3959: * IBY_TRANSACTION_ERRORS table and cannot be reused for a

3955:
3956: /*
3957: * Reset the transaction error id on the x_docErrorRec object.
3958: * The transaction error id is the primary key of the
3959: * IBY_TRANSACTION_ERRORS table and cannot be reused for a
3960: * new error message.
3961: *
3962: * Since it is the callers responsibility to initialize the
3963: * transaction error id (if need be) on x_docErrorRec, we

Line 3974: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

3970: /*
3971: * The original procedure is overloaded
3972: */
3973: PROCEDURE insertIntoErrorTable(
3974: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
3975: x_docErrorTab IN OUT NOCOPY docErrorTabType
3976: )
3977: IS
3978:

Line 3979: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;

3975: x_docErrorTab IN OUT NOCOPY docErrorTabType
3976: )
3977: IS
3978:
3979: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
3980: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertIntoErrorTable';
3981:
3982: BEGIN
3983: print_debuginfo (l_module_name, 'Old Method - Validation Failed: '

Line 4080: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE

4076: p_token IN VARCHAR2,
4077: p_char_value IN VARCHAR2,
4078: p_num_value IN NUMBER,
4079: x_valResult OUT NOCOPY BOOLEAN,
4080: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
4081: )
4082: IS
4083:
4084: l_stmt VARCHAR2(200);

Line 4092: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;

4088: l_temp_num NUMBER;
4089: l_num_flag VARCHAR2(1);
4090: l_lookup_code_cnt NUMBER;
4091: l_error_msg VARCHAR2(2000);
4092: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
4093:
4094: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.evaluateCondition';
4095:
4096: BEGIN

Line 4339: IBY_TRANSACTION_ERRORS_S.NEXTVAL

4335:
4336: IF NOT x_valResult THEN
4337:
4338: SELECT
4339: IBY_TRANSACTION_ERRORS_S.NEXTVAL
4340: INTO
4341: l_transaction_error_id
4342: FROM
4343: DUAL

Line 5126: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5122:
5123: l_newlyFailedDocsTab docStatusTabType;
5124: l_invalidDocRec docStatusRecType;
5125: --l_doc_err_rec docErrorRecType;
5126: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5127:
5128: TYPE pmtGrpNumTabType is TABLE OF
5129: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
5130: INDEX BY BINARY_INTEGER;

Line 5332: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5328: '.failAllDocsForPayee';
5329:
5330: l_newlyFailedDocsTab docStatusTabType;
5331: l_invalidDocRec docStatusRecType;
5332: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5333: l_doc_token_tab trxnErrTokenTabType;
5334:
5335: TYPE payeeTabType is TABLE OF
5336: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

Line 5564: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5560:
5561: l_invalidDocRec docStatusRecType;
5562: l_already_failed_flag BOOLEAN := FALSE;
5563: l_print_var VARCHAR2(1) := '';
5564: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5565: l_doc_token_tab trxnErrTokenTabType;
5566: l_index NUMBER := 0;
5567: l_triggering_doc IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE;
5568:

Line 5714: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5710: '.failAllAwtDocs';
5711:
5712: l_newlyFailedDocsTab docStatusTabType;
5713: l_invalidDocRec docStatusRecType;
5714: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5715: l_doc_token_tab trxnErrTokenTabType;
5716: l_already_processed_flag BOOLEAN := FALSE;
5717: l_already_failed_flag BOOLEAN := FALSE;
5718: l_print_var VARCHAR2(1) := '';