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 53: -- Transaction type (for inserting into IBY_TRANSACTION_ERRORS table)

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

Line 382: * IBY_TRANSACTION_ERRORS table.

378:
379: /*
380: * We have collected all the error messages against the failed
381: * documents in a PLSQL table. Use this to update the
382: * IBY_TRANSACTION_ERRORS table.
383: */
384: insert_transaction_errors('N', x_txnErrorsTab, x_errTokenTab);
385:
386: /*

Line 555: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

551:
552: l_bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;
553:
554: l_print_var VARCHAR2(1) := '';
555: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
556: l_doc_token_tab trxnErrTokenTabType;
557:
558: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
559: '.applyDocumentValidationSets';

Line 800: * status in the IBY_TRANSACTION_ERRORS table.

796: *
797: * Before doing any validations, set any
798: * existing validation error messages that
799: * exist against this document to 'inactive'
800: * status in the IBY_TRANSACTION_ERRORS table.
801: *
802: * Unless we do this, the old errors will
803: * continue to show up against this document
804: * in the IBY UI even if the document is validated

Line 3217: | IBY_TRANSACTION_ERRORS_GT; for deferred validations, the

Line 3218: | error messages are inserted into IBY_TRANSACTION_ERRORS

3214: | PURPOSE:
3215: | Inserts the error messages into the errors table. For
3216: | online validations, the error messages are inserted into
3217: | IBY_TRANSACTION_ERRORS_GT; for deferred validations, the
3218: | error messages are inserted into IBY_TRANSACTION_ERRORS
3219: | table.
3220: |
3221: | Validation sets populate the transaction errors into a PLSQL
3222: | table. This method performs a bulk insert of the given records

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

3243: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3244: '.insert_transaction_errors';
3245:
3246: /*
3247: * Column types for insertion into IBY_TRANSACTION_ERRORS table.
3248: */
3249: TYPE t_transaction_error_id IS TABLE OF
3250: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE
3251: INDEX BY BINARY_INTEGER;

Line 3250: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE

3246: /*
3247: * Column types for insertion into IBY_TRANSACTION_ERRORS table.
3248: */
3249: TYPE t_transaction_error_id IS TABLE OF
3250: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE
3251: INDEX BY BINARY_INTEGER;
3252: TYPE t_transaction_type IS TABLE OF
3253: IBY_TRANSACTION_ERRORS.transaction_type%TYPE
3254: INDEX BY BINARY_INTEGER;

Line 3253: IBY_TRANSACTION_ERRORS.transaction_type%TYPE

3249: TYPE t_transaction_error_id IS TABLE OF
3250: IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE
3251: INDEX BY BINARY_INTEGER;
3252: TYPE t_transaction_type IS TABLE OF
3253: IBY_TRANSACTION_ERRORS.transaction_type%TYPE
3254: INDEX BY BINARY_INTEGER;
3255: TYPE t_transaction_id IS TABLE OF
3256: IBY_TRANSACTION_ERRORS.transaction_id%TYPE
3257: INDEX BY BINARY_INTEGER;

Line 3256: IBY_TRANSACTION_ERRORS.transaction_id%TYPE

3252: TYPE t_transaction_type IS TABLE OF
3253: IBY_TRANSACTION_ERRORS.transaction_type%TYPE
3254: INDEX BY BINARY_INTEGER;
3255: TYPE t_transaction_id IS TABLE OF
3256: IBY_TRANSACTION_ERRORS.transaction_id%TYPE
3257: INDEX BY BINARY_INTEGER;
3258: TYPE t_error_code IS TABLE OF
3259: IBY_TRANSACTION_ERRORS.error_code%TYPE
3260: INDEX BY BINARY_INTEGER;

Line 3259: IBY_TRANSACTION_ERRORS.error_code%TYPE

3255: TYPE t_transaction_id IS TABLE OF
3256: IBY_TRANSACTION_ERRORS.transaction_id%TYPE
3257: INDEX BY BINARY_INTEGER;
3258: TYPE t_error_code IS TABLE OF
3259: IBY_TRANSACTION_ERRORS.error_code%TYPE
3260: INDEX BY BINARY_INTEGER;
3261: TYPE t_error_date IS TABLE OF
3262: IBY_TRANSACTION_ERRORS.error_date%TYPE
3263: INDEX BY BINARY_INTEGER;

Line 3262: IBY_TRANSACTION_ERRORS.error_date%TYPE

3258: TYPE t_error_code IS TABLE OF
3259: IBY_TRANSACTION_ERRORS.error_code%TYPE
3260: INDEX BY BINARY_INTEGER;
3261: TYPE t_error_date IS TABLE OF
3262: IBY_TRANSACTION_ERRORS.error_date%TYPE
3263: INDEX BY BINARY_INTEGER;
3264: TYPE t_error_status IS TABLE OF
3265: IBY_TRANSACTION_ERRORS.error_status%TYPE
3266: INDEX BY BINARY_INTEGER;

Line 3265: IBY_TRANSACTION_ERRORS.error_status%TYPE

3261: TYPE t_error_date IS TABLE OF
3262: IBY_TRANSACTION_ERRORS.error_date%TYPE
3263: INDEX BY BINARY_INTEGER;
3264: TYPE t_error_status IS TABLE OF
3265: IBY_TRANSACTION_ERRORS.error_status%TYPE
3266: INDEX BY BINARY_INTEGER;
3267: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
3268: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE
3269: INDEX BY BINARY_INTEGER;

Line 3268: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE

3264: TYPE t_error_status IS TABLE OF
3265: IBY_TRANSACTION_ERRORS.error_status%TYPE
3266: INDEX BY BINARY_INTEGER;
3267: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
3268: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE
3269: INDEX BY BINARY_INTEGER;
3270: TYPE t_ovrride_allowed_on_err_flg IS TABLE OF
3271: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE
3272: INDEX BY BINARY_INTEGER;

Line 3271: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE

3267: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
3268: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref1%TYPE
3269: INDEX BY BINARY_INTEGER;
3270: TYPE t_ovrride_allowed_on_err_flg IS TABLE OF
3271: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE
3272: INDEX BY BINARY_INTEGER;
3273: TYPE t_do_not_apply_error_flag IS TABLE OF
3274: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE
3275: INDEX BY BINARY_INTEGER;

Line 3274: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE

3270: TYPE t_ovrride_allowed_on_err_flg IS TABLE OF
3271: IBY_TRANSACTION_ERRORS.override_allowed_on_error_flag%TYPE
3272: INDEX BY BINARY_INTEGER;
3273: TYPE t_do_not_apply_error_flag IS TABLE OF
3274: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE
3275: INDEX BY BINARY_INTEGER;
3276: TYPE t_created_by IS TABLE OF
3277: IBY_TRANSACTION_ERRORS.created_by%TYPE
3278: INDEX BY BINARY_INTEGER;

Line 3277: IBY_TRANSACTION_ERRORS.created_by%TYPE

3273: TYPE t_do_not_apply_error_flag IS TABLE OF
3274: IBY_TRANSACTION_ERRORS.do_not_apply_error_flag%TYPE
3275: INDEX BY BINARY_INTEGER;
3276: TYPE t_created_by IS TABLE OF
3277: IBY_TRANSACTION_ERRORS.created_by%TYPE
3278: INDEX BY BINARY_INTEGER;
3279: TYPE t_creation_date IS TABLE OF
3280: IBY_TRANSACTION_ERRORS.creation_date%TYPE
3281: INDEX BY BINARY_INTEGER;

Line 3280: IBY_TRANSACTION_ERRORS.creation_date%TYPE

3276: TYPE t_created_by IS TABLE OF
3277: IBY_TRANSACTION_ERRORS.created_by%TYPE
3278: INDEX BY BINARY_INTEGER;
3279: TYPE t_creation_date IS TABLE OF
3280: IBY_TRANSACTION_ERRORS.creation_date%TYPE
3281: INDEX BY BINARY_INTEGER;
3282: TYPE t_last_updated_by IS TABLE OF
3283: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE
3284: INDEX BY BINARY_INTEGER;

Line 3283: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE

3279: TYPE t_creation_date IS TABLE OF
3280: IBY_TRANSACTION_ERRORS.creation_date%TYPE
3281: INDEX BY BINARY_INTEGER;
3282: TYPE t_last_updated_by IS TABLE OF
3283: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE
3284: INDEX BY BINARY_INTEGER;
3285: TYPE t_last_update_date IS TABLE OF
3286: IBY_TRANSACTION_ERRORS.last_update_date%TYPE
3287: INDEX BY BINARY_INTEGER;

Line 3286: IBY_TRANSACTION_ERRORS.last_update_date%TYPE

3282: TYPE t_last_updated_by IS TABLE OF
3283: IBY_TRANSACTION_ERRORS.last_updated_by%TYPE
3284: INDEX BY BINARY_INTEGER;
3285: TYPE t_last_update_date IS TABLE OF
3286: IBY_TRANSACTION_ERRORS.last_update_date%TYPE
3287: INDEX BY BINARY_INTEGER;
3288: TYPE t_object_version_number IS TABLE OF
3289: IBY_TRANSACTION_ERRORS.object_version_number%TYPE
3290: INDEX BY BINARY_INTEGER;

Line 3289: IBY_TRANSACTION_ERRORS.object_version_number%TYPE

3285: TYPE t_last_update_date IS TABLE OF
3286: IBY_TRANSACTION_ERRORS.last_update_date%TYPE
3287: INDEX BY BINARY_INTEGER;
3288: TYPE t_object_version_number IS TABLE OF
3289: IBY_TRANSACTION_ERRORS.object_version_number%TYPE
3290: INDEX BY BINARY_INTEGER;
3291: TYPE t_last_update_login IS TABLE OF
3292: IBY_TRANSACTION_ERRORS.last_update_login%TYPE
3293: INDEX BY BINARY_INTEGER;

Line 3292: IBY_TRANSACTION_ERRORS.last_update_login%TYPE

3288: TYPE t_object_version_number IS TABLE OF
3289: IBY_TRANSACTION_ERRORS.object_version_number%TYPE
3290: INDEX BY BINARY_INTEGER;
3291: TYPE t_last_update_login IS TABLE OF
3292: IBY_TRANSACTION_ERRORS.last_update_login%TYPE
3293: INDEX BY BINARY_INTEGER;
3294: TYPE t_calling_app_id IS TABLE OF
3295: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE
3296: INDEX BY BINARY_INTEGER;

Line 3295: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE

3291: TYPE t_last_update_login IS TABLE OF
3292: IBY_TRANSACTION_ERRORS.last_update_login%TYPE
3293: INDEX BY BINARY_INTEGER;
3294: TYPE t_calling_app_id IS TABLE OF
3295: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE
3296: INDEX BY BINARY_INTEGER;
3297: TYPE t_pay_proc_trxn_type_code IS TABLE OF
3298: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE
3299: INDEX BY BINARY_INTEGER;

Line 3298: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE

3294: TYPE t_calling_app_id IS TABLE OF
3295: IBY_TRANSACTION_ERRORS.calling_app_id%TYPE
3296: INDEX BY BINARY_INTEGER;
3297: TYPE t_pay_proc_trxn_type_code IS TABLE OF
3298: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE
3299: INDEX BY BINARY_INTEGER;
3300: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
3301: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE
3302: INDEX BY BINARY_INTEGER;

Line 3301: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE

3297: TYPE t_pay_proc_trxn_type_code IS TABLE OF
3298: IBY_TRANSACTION_ERRORS.pay_proc_trxn_type_code%TYPE
3299: INDEX BY BINARY_INTEGER;
3300: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
3301: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE
3302: INDEX BY BINARY_INTEGER;
3303: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
3304: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE
3305: INDEX BY BINARY_INTEGER;

Line 3304: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE

3300: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
3301: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref2%TYPE
3302: INDEX BY BINARY_INTEGER;
3303: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
3304: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE
3305: INDEX BY BINARY_INTEGER;
3306: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
3307: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE
3308: INDEX BY BINARY_INTEGER;

Line 3307: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE

3303: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
3304: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref3%TYPE
3305: INDEX BY BINARY_INTEGER;
3306: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
3307: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE
3308: INDEX BY BINARY_INTEGER;
3309: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
3310: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE
3311: INDEX BY BINARY_INTEGER;

Line 3310: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE

3306: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
3307: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref4%TYPE
3308: INDEX BY BINARY_INTEGER;
3309: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
3310: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE
3311: INDEX BY BINARY_INTEGER;
3312: TYPE t_error_type IS TABLE OF
3313: IBY_TRANSACTION_ERRORS.error_type%TYPE
3314: INDEX BY BINARY_INTEGER;

Line 3313: IBY_TRANSACTION_ERRORS.error_type%TYPE

3309: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
3310: IBY_TRANSACTION_ERRORS.calling_app_doc_unique_ref5%TYPE
3311: INDEX BY BINARY_INTEGER;
3312: TYPE t_error_type IS TABLE OF
3313: IBY_TRANSACTION_ERRORS.error_type%TYPE
3314: INDEX BY BINARY_INTEGER;
3315: TYPE t_error_message IS TABLE OF
3316: IBY_TRANSACTION_ERRORS.error_message%TYPE
3317: INDEX BY BINARY_INTEGER;

Line 3316: IBY_TRANSACTION_ERRORS.error_message%TYPE

3312: TYPE t_error_type IS TABLE OF
3313: IBY_TRANSACTION_ERRORS.error_type%TYPE
3314: INDEX BY BINARY_INTEGER;
3315: TYPE t_error_message IS TABLE OF
3316: IBY_TRANSACTION_ERRORS.error_message%TYPE
3317: INDEX BY BINARY_INTEGER;
3318: TYPE t_validation_set_code IS TABLE OF
3319: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE
3320: INDEX BY BINARY_INTEGER;

Line 3319: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE

3315: TYPE t_error_message IS TABLE OF
3316: IBY_TRANSACTION_ERRORS.error_message%TYPE
3317: INDEX BY BINARY_INTEGER;
3318: TYPE t_validation_set_code IS TABLE OF
3319: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE
3320: INDEX BY BINARY_INTEGER;
3321: TYPE t_pass_date IS TABLE OF
3322: IBY_TRANSACTION_ERRORS.pass_date%TYPE
3323: INDEX BY BINARY_INTEGER;

Line 3322: IBY_TRANSACTION_ERRORS.pass_date%TYPE

3318: TYPE t_validation_set_code IS TABLE OF
3319: IBY_TRANSACTION_ERRORS.validation_set_code%TYPE
3320: INDEX BY BINARY_INTEGER;
3321: TYPE t_pass_date IS TABLE OF
3322: IBY_TRANSACTION_ERRORS.pass_date%TYPE
3323: INDEX BY BINARY_INTEGER;
3324: TYPE t_override_justification IS TABLE OF
3325: IBY_TRANSACTION_ERRORS.override_justification%TYPE
3326: INDEX BY BINARY_INTEGER;

Line 3325: IBY_TRANSACTION_ERRORS.override_justification%TYPE

3321: TYPE t_pass_date IS TABLE OF
3322: IBY_TRANSACTION_ERRORS.pass_date%TYPE
3323: INDEX BY BINARY_INTEGER;
3324: TYPE t_override_justification IS TABLE OF
3325: IBY_TRANSACTION_ERRORS.override_justification%TYPE
3326: INDEX BY BINARY_INTEGER;
3327: TYPE t_override_date IS TABLE OF
3328: IBY_TRANSACTION_ERRORS.override_date%TYPE
3329: INDEX BY BINARY_INTEGER;

Line 3328: IBY_TRANSACTION_ERRORS.override_date%TYPE

3324: TYPE t_override_justification IS TABLE OF
3325: IBY_TRANSACTION_ERRORS.override_justification%TYPE
3326: INDEX BY BINARY_INTEGER;
3327: TYPE t_override_date IS TABLE OF
3328: IBY_TRANSACTION_ERRORS.override_date%TYPE
3329: INDEX BY BINARY_INTEGER;
3330:
3331: l_transaction_error_id t_transaction_error_id;
3332: l_transaction_type t_transaction_type;

Line 3506: * Insert error messages into IBY_TRANSACTION_ERRORS table.

3502:
3503: IF (UPPER(p_isOnlineVal) = 'N') THEN
3504:
3505: /*
3506: * Insert error messages into IBY_TRANSACTION_ERRORS table.
3507: */
3508:
3509: print_debuginfo(l_module_name, 'Bulk inserting errors into '
3510: || 'IBY_TRANSACTION_ERRORS.');

Line 3510: || 'IBY_TRANSACTION_ERRORS.');

3506: * Insert error messages into IBY_TRANSACTION_ERRORS table.
3507: */
3508:
3509: print_debuginfo(l_module_name, 'Bulk inserting errors into '
3510: || 'IBY_TRANSACTION_ERRORS.');
3511:
3512: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3513: -- INSERT INTO IBY_TRANSACTION_ERRORS VALUES x_docErrorTab(i);
3514:

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

3509: print_debuginfo(l_module_name, 'Bulk inserting errors into '
3510: || 'IBY_TRANSACTION_ERRORS.');
3511:
3512: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3513: -- INSERT INTO IBY_TRANSACTION_ERRORS VALUES x_docErrorTab(i);
3514:
3515:
3516: /*
3517: * Use named columns in bulk insert syntax to avoid any

Line 3521: INSERT INTO IBY_TRANSACTION_ERRORS

3517: * Use named columns in bulk insert syntax to avoid any
3518: * dependencies on the order of the columns in the table.
3519: */
3520: FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3521: INSERT INTO IBY_TRANSACTION_ERRORS
3522: (
3523: transaction_error_id,
3524: transaction_type,
3525: transaction_id,

Line 3584: || 'IBY_TRANSACTION_ERRORS.');

3580: )
3581: ;
3582:
3583: print_debuginfo(l_module_name, 'Finished populating '
3584: || 'IBY_TRANSACTION_ERRORS.');
3585:
3586:
3587: ELSE
3588:

Line 3590: * Insert error messages into IBY_TRANSACTION_ERRORS_GT table.

3586:
3587: ELSE
3588:
3589: /*
3590: * Insert error messages into IBY_TRANSACTION_ERRORS_GT table.
3591: */
3592:
3593: print_debuginfo(l_module_name, 'Bulk Inserting errors into '
3594: || 'IBY_TRANSACTION_ERRORS_GT.');

Line 3594: || 'IBY_TRANSACTION_ERRORS_GT.');

3590: * Insert error messages into IBY_TRANSACTION_ERRORS_GT table.
3591: */
3592:
3593: print_debuginfo(l_module_name, 'Bulk Inserting errors into '
3594: || 'IBY_TRANSACTION_ERRORS_GT.');
3595:
3596: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3597: -- INSERT INTO IBY_TRANSACTION_ERRORS_GT VALUES x_docErrorTab(i);
3598:

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

3593: print_debuginfo(l_module_name, 'Bulk Inserting errors into '
3594: || 'IBY_TRANSACTION_ERRORS_GT.');
3595:
3596: --FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3597: -- INSERT INTO IBY_TRANSACTION_ERRORS_GT VALUES x_docErrorTab(i);
3598:
3599: /*
3600: * Use named columns in bulk insert syntax to avoid any
3601: * dependencies on the order of the columns in the table.

Line 3604: INSERT INTO IBY_TRANSACTION_ERRORS_GT

3600: * Use named columns in bulk insert syntax to avoid any
3601: * dependencies on the order of the columns in the table.
3602: */
3603: FORALL i in x_docErrorTab.FIRST..x_docErrorTab.LAST
3604: INSERT INTO IBY_TRANSACTION_ERRORS_GT
3605: (
3606: transaction_error_id,
3607: transaction_type,
3608: transaction_id,

Line 3667: || 'IBY_TRANSACTION_ERRORS_GT.');

3663: )
3664: ;
3665:
3666: print_debuginfo(l_module_name, 'Finished populating '
3667: || 'IBY_TRANSACTION_ERRORS_GT.');
3668:
3669:
3670: END IF; -- p_isOnlineVal = 'N'
3671:

Line 3821: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

3817: | NOTES:
3818: |
3819: *---------------------------------------------------------------------*/
3820: PROCEDURE insertIntoErrorTable(
3821: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
3822: x_docErrorTab IN OUT NOCOPY docErrorTabType,
3823: x_trxnErrTokenTab IN OUT NOCOPY trxnErrTokenTabType
3824: )
3825: IS

Line 3827: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;

3823: x_trxnErrTokenTab IN OUT NOCOPY trxnErrTokenTabType
3824: )
3825: IS
3826:
3827: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
3828: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertIntoErrorTable';
3829: l_index NUMBER;
3830:
3831: BEGIN

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

3832:
3833: print_debuginfo (l_module_name, 'Validation Failed: '
3834: || x_docErrorRec.error_message);
3835:
3836: /* Get the next sequence value from IBY_TRANSACTION_ERRORS_S */
3837: IF x_docErrorRec.transaction_error_id IS NULL THEN
3838:
3839: SELECT
3840: IBY_TRANSACTION_ERRORS_S.NEXTVAL

Line 3840: IBY_TRANSACTION_ERRORS_S.NEXTVAL

3836: /* Get the next sequence value from IBY_TRANSACTION_ERRORS_S */
3837: IF x_docErrorRec.transaction_error_id IS NULL THEN
3838:
3839: SELECT
3840: IBY_TRANSACTION_ERRORS_S.NEXTVAL
3841: INTO
3842: l_transaction_error_id
3843: FROM
3844: DUAL

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

3878:
3879: /*
3880: * Reset the transaction error id on the x_docErrorRec object.
3881: * The transaction error id is the primary key of the
3882: * IBY_TRANSACTION_ERRORS table and cannot be reused for a
3883: * new error message.
3884: *
3885: * Since it is the callers responsibility to initialize the
3886: * transaction error id (if need be) on x_docErrorRec, we

Line 3897: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,

3893: /*
3894: * The original procedure is overloaded
3895: */
3896: PROCEDURE insertIntoErrorTable(
3897: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
3898: x_docErrorTab IN OUT NOCOPY docErrorTabType
3899: )
3900: IS
3901:

Line 3902: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;

3898: x_docErrorTab IN OUT NOCOPY docErrorTabType
3899: )
3900: IS
3901:
3902: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
3903: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insertIntoErrorTable';
3904:
3905: BEGIN
3906: print_debuginfo (l_module_name, 'Old Method - Validation Failed: '

Line 4001: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE

3997: p_token IN VARCHAR2,
3998: p_char_value IN VARCHAR2,
3999: p_num_value IN NUMBER,
4000: x_valResult OUT NOCOPY BOOLEAN,
4001: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE
4002: )
4003: IS
4004:
4005: l_stmt VARCHAR2(200);

Line 4013: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;

4009: l_temp_num NUMBER;
4010: l_num_flag VARCHAR2(1);
4011: l_lookup_code_cnt NUMBER;
4012: l_error_msg VARCHAR2(2000);
4013: l_transaction_error_id IBY_TRANSACTION_ERRORS.transaction_error_id%TYPE;
4014:
4015: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.evaluateCondition';
4016:
4017: BEGIN

Line 4258: IBY_TRANSACTION_ERRORS_S.NEXTVAL

4254:
4255: IF NOT x_valResult THEN
4256:
4257: SELECT
4258: IBY_TRANSACTION_ERRORS_S.NEXTVAL
4259: INTO
4260: l_transaction_error_id
4261: FROM
4262: DUAL

Line 4997: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

4993:
4994: l_newlyFailedDocsTab docStatusTabType;
4995: l_invalidDocRec docStatusRecType;
4996: --l_doc_err_rec docErrorRecType;
4997: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
4998:
4999: TYPE pmtGrpNumTabType is TABLE OF
5000: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
5001: INDEX BY BINARY_INTEGER;

Line 5193: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5189: '.failAllDocsForPayee';
5190:
5191: l_newlyFailedDocsTab docStatusTabType;
5192: l_invalidDocRec docStatusRecType;
5193: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5194: l_doc_token_tab trxnErrTokenTabType;
5195:
5196: TYPE payeeTabType is TABLE OF
5197: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

Line 5411: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5407:
5408: l_invalidDocRec docStatusRecType;
5409: l_already_failed_flag BOOLEAN := FALSE;
5410: l_print_var VARCHAR2(1) := '';
5411: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5412: l_doc_token_tab trxnErrTokenTabType;
5413: l_index NUMBER := 0;
5414: l_triggering_doc IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
5415: