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.XLA_JE_VALIDATION_PKG dependencies on STANDARD

Line 2662: CURSOR c_standard IS

2658: AND h.application_id = g_application_id
2659: AND ((h.doc_category_code IS NOT NULL AND cat.code IS NULL) OR
2660: (h.doc_sequence_id IS NOT NULL AND doc.doc_sequence_id IS NULL));
2661:
2662: CURSOR c_standard IS
2663: SELECT h.ae_header_id
2664: ,h.entity_id
2665: ,h.event_id
2666: ,h.doc_sequence_id

Line 2687: l_err c_standard%ROWTYPE;

2683: AND ((h.doc_category_code IS NOT NULL AND cat.code IS NULL) OR
2684: (h.doc_sequence_id IS NOT NULL AND doc.doc_sequence_id IS NULL));
2685:
2686: l_app_name VARCHAR2(240);
2687: l_err c_standard%ROWTYPE;
2688:
2689: l_log_module VARCHAR2(240);
2690: BEGIN
2691: IF g_log_enabled THEN

Line 2704: OPEN c_standard;

2700:
2701: IF (g_caller = C_CALLER_MANUAL) THEN
2702: OPEN c_manual;
2703: ELSE
2704: OPEN c_standard;
2705: END IF;
2706:
2707: IF (C_LEVEL_EVENT >= g_log_level) THEN
2708: trace(p_msg => 'BEGIN LOOP - invalid doc sequence',

Line 2718: FETCH c_standard INTO l_err;

2714: IF (g_caller = C_CALLER_MANUAL) THEN
2715: FETCH c_manual INTO l_err;
2716: EXIT WHEN c_manual%NOTFOUND;
2717: ELSE
2718: FETCH c_standard INTO l_err;
2719: EXIT WHEN c_standard%NOTFOUND;
2720: END IF;
2721:
2722: IF (C_LEVEL_ERROR >= g_log_level) THEN

Line 2719: EXIT WHEN c_standard%NOTFOUND;

2715: FETCH c_manual INTO l_err;
2716: EXIT WHEN c_manual%NOTFOUND;
2717: ELSE
2718: FETCH c_standard INTO l_err;
2719: EXIT WHEN c_standard%NOTFOUND;
2720: END IF;
2721:
2722: IF (C_LEVEL_ERROR >= g_log_level) THEN
2723: trace(p_msg => 'LOOP invalid headers: ae_header_id = '||l_err.ae_header_id,

Line 2784: CLOSE c_standard;

2780:
2781: IF (g_caller = C_CALLER_MANUAL) THEN
2782: CLOSE c_manual;
2783: ELSE
2784: CLOSE c_standard;
2785: END IF;
2786:
2787: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2788: trace(p_msg => 'End of function validate_doc_sequence',

Line 2797: IF (c_standard%ISOPEN) THEN

2793: WHEN xla_exceptions_pkg.application_exception THEN
2794: IF (c_manual%ISOPEN) THEN
2795: CLOSE c_manual;
2796: END IF;
2797: IF (c_standard%ISOPEN) THEN
2798: CLOSE c_standard;
2799: END IF;
2800: RAISE;
2801:

Line 2798: CLOSE c_standard;

2794: IF (c_manual%ISOPEN) THEN
2795: CLOSE c_manual;
2796: END IF;
2797: IF (c_standard%ISOPEN) THEN
2798: CLOSE c_standard;
2799: END IF;
2800: RAISE;
2801:
2802: WHEN OTHERS THEN

Line 2806: IF (c_standard%ISOPEN) THEN

2802: WHEN OTHERS THEN
2803: IF (c_manual%ISOPEN) THEN
2804: CLOSE c_manual;
2805: END IF;
2806: IF (c_standard%ISOPEN) THEN
2807: CLOSE c_standard;
2808: END IF;
2809: xla_exceptions_pkg.raise_message
2810: (p_location => 'xla_je_validation_pkg.validate_doc_sequence');

Line 2807: CLOSE c_standard;

2803: IF (c_manual%ISOPEN) THEN
2804: CLOSE c_manual;
2805: END IF;
2806: IF (c_standard%ISOPEN) THEN
2807: CLOSE c_standard;
2808: END IF;
2809: xla_exceptions_pkg.raise_message
2810: (p_location => 'xla_je_validation_pkg.validate_doc_sequence');
2811: END validate_doc_sequence;

Line 2979: CURSOR c_standard IS

2975: AND (bv.status IS NULL OR
2976: nvl(bv.status,'I') in ('I', 'F') OR
2977: gp.period_year > b.latest_opened_year);
2978:
2979: CURSOR c_standard IS
2980: SELECT h.ae_header_id
2981: ,h.entity_id
2982: ,h.event_id
2983: ,h.budget_version_id

Line 3006: l_err c_standard%ROWTYPE;

3002: b.ledger_id <> h.ledger_id OR -- 5592776
3003: h.period_year > b.latest_opened_year);
3004:
3005: l_budget_name VARCHAR2(30);
3006: l_err c_standard%ROWTYPE;
3007: l_log_module VARCHAR2(240);
3008: BEGIN
3009: IF g_log_enabled THEN
3010: l_log_module := C_DEFAULT_MODULE||'.validate_budgets';

Line 3022: OPEN c_standard;

3018:
3019: IF (g_caller = C_CALLER_MANUAL) THEN
3020: OPEN c_manual;
3021: ELSE
3022: OPEN c_standard;
3023: END IF;
3024:
3025: IF (C_LEVEL_EVENT >= g_log_level) THEN
3026: trace(p_msg => 'BEGIN LOOP - invalid budgets',

Line 3036: FETCH c_standard INTO l_err;

3032: IF (g_caller = C_CALLER_MANUAL) THEN
3033: FETCH c_manual INTO l_err;
3034: EXIT WHEN c_manual%NOTFOUND;
3035: ELSE
3036: FETCH c_standard INTO l_err;
3037: EXIT WHEN c_standard%NOTFOUND;
3038: END IF;
3039:
3040: IF (C_LEVEL_ERROR >= g_log_level) THEN

Line 3037: EXIT WHEN c_standard%NOTFOUND;

3033: FETCH c_manual INTO l_err;
3034: EXIT WHEN c_manual%NOTFOUND;
3035: ELSE
3036: FETCH c_standard INTO l_err;
3037: EXIT WHEN c_standard%NOTFOUND;
3038: END IF;
3039:
3040: IF (C_LEVEL_ERROR >= g_log_level) THEN
3041: trace(p_msg => 'LOOP invalid budgets: ae_header_id = '||l_err.ae_header_id,

Line 3123: CLOSE c_standard;

3119:
3120: IF (g_caller = C_CALLER_MANUAL) THEN
3121: CLOSE c_manual;
3122: ELSE
3123: CLOSE c_standard;
3124: END IF;
3125:
3126: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3127: trace(p_msg => 'End of function validate_budgets',

Line 3136: IF (c_standard%ISOPEN) THEN

3132: WHEN xla_exceptions_pkg.application_exception THEN
3133: IF (c_manual%ISOPEN) THEN
3134: CLOSE c_manual;
3135: END IF;
3136: IF (c_standard%ISOPEN) THEN
3137: CLOSE c_standard;
3138: END IF;
3139: RAISE;
3140:

Line 3137: CLOSE c_standard;

3133: IF (c_manual%ISOPEN) THEN
3134: CLOSE c_manual;
3135: END IF;
3136: IF (c_standard%ISOPEN) THEN
3137: CLOSE c_standard;
3138: END IF;
3139: RAISE;
3140:
3141: WHEN OTHERS THEN

Line 3145: IF (c_standard%ISOPEN) THEN

3141: WHEN OTHERS THEN
3142: IF (c_manual%ISOPEN) THEN
3143: CLOSE c_manual;
3144: END IF;
3145: IF (c_standard%ISOPEN) THEN
3146: CLOSE c_standard;
3147: END IF;
3148: xla_exceptions_pkg.raise_message
3149: (p_location => 'xla_je_validation_pkg.validate_budgets');

Line 3146: CLOSE c_standard;

3142: IF (c_manual%ISOPEN) THEN
3143: CLOSE c_manual;
3144: END IF;
3145: IF (c_standard%ISOPEN) THEN
3146: CLOSE c_standard;
3147: END IF;
3148: xla_exceptions_pkg.raise_message
3149: (p_location => 'xla_je_validation_pkg.validate_budgets');
3150: END validate_budgets;

Line 3331: CURSOR c_standard IS

3327: (h.balance_type_code = 'E' AND gp.period_year > g.latest_encumbrance_year) OR
3328: (h.balance_type_code = 'A' AND gp.closing_status NOT IN ('O', 'F')) OR
3329: (h.reference_date IS NOT NULL AND nvl(rp.closing_status,'C') NOT IN ('O', 'F')));
3330:
3331: CURSOR c_standard IS
3332: SELECT /*+ index(gp, GL_PERIOD_STATUSES_U3) */
3333: h.ae_header_id
3334: ,h.entity_id
3335: ,h.event_id

Line 3368: l_err c_standard%ROWTYPE;

3364: (h.balance_type_code = 'A' AND NVL(h.period_closing_status,'X') NOT IN ('O', 'F')));
3365: --(h.balance_type_code = 'E' AND h.period_year > g_latest_encumbrance_year) OR
3366: --(h.balance_type_code = 'A' AND h.period_closing_status NOT IN ('O', 'F')));
3367:
3368: l_err c_standard%ROWTYPE;
3369: l_log_module VARCHAR2(240);
3370: BEGIN
3371: IF g_log_enabled THEN
3372: l_log_module := C_DEFAULT_MODULE||'.validate_headers';

Line 3384: OPEN c_standard;

3380:
3381: IF (g_caller = C_CALLER_MANUAL) THEN
3382: OPEN c_manual;
3383: ELSE
3384: OPEN c_standard;
3385: END IF;
3386:
3387: IF (C_LEVEL_EVENT >= g_log_level) THEN
3388: trace(p_msg => 'BEGIN LOOP - invalid header',

Line 3399: FETCH c_standard INTO l_err;

3395: IF (g_caller = C_CALLER_MANUAL) THEN
3396: FETCH c_manual INTO l_err;
3397: EXIT WHEN c_manual%NOTFOUND;
3398: ELSE
3399: FETCH c_standard INTO l_err;
3400: EXIT WHEN c_standard%NOTFOUND;
3401: END IF;
3402:
3403:

Line 3400: EXIT WHEN c_standard%NOTFOUND;

3396: FETCH c_manual INTO l_err;
3397: EXIT WHEN c_manual%NOTFOUND;
3398: ELSE
3399: FETCH c_standard INTO l_err;
3400: EXIT WHEN c_standard%NOTFOUND;
3401: END IF;
3402:
3403:
3404: IF (l_err.balance_type_code = 'A' AND l_err.gl_date_valid_flag = 'N' AND l_err.gl_transfer_status_code = 'NT') THEN

Line 3557: CLOSE c_standard;

3553:
3554: IF (g_caller = C_CALLER_MANUAL) THEN
3555: CLOSE c_manual;
3556: ELSE
3557: CLOSE c_standard;
3558: END IF;
3559:
3560: IF g_caller <> C_CALLER_MPA_PROGRAM THEN -- 4262811
3561: --validate_encumbrances; -- 4458381

Line 3577: IF (c_standard%ISOPEN) THEN

3573: WHEN xla_exceptions_pkg.application_exception THEN
3574: IF (c_manual%ISOPEN) THEN
3575: CLOSE c_manual;
3576: END IF;
3577: IF (c_standard%ISOPEN) THEN
3578: CLOSE c_standard;
3579: END IF;
3580: RAISE;
3581:

Line 3578: CLOSE c_standard;

3574: IF (c_manual%ISOPEN) THEN
3575: CLOSE c_manual;
3576: END IF;
3577: IF (c_standard%ISOPEN) THEN
3578: CLOSE c_standard;
3579: END IF;
3580: RAISE;
3581:
3582: WHEN OTHERS THEN

Line 3586: IF (c_standard%ISOPEN) THEN

3582: WHEN OTHERS THEN
3583: IF (c_manual%ISOPEN) THEN
3584: CLOSE c_manual;
3585: END IF;
3586: IF (c_standard%ISOPEN) THEN
3587: CLOSE c_standard;
3588: END IF;
3589: xla_exceptions_pkg.raise_message
3590: (p_location => 'xla_je_validation_pkg.validate_headers');

Line 3587: CLOSE c_standard;

3583: IF (c_manual%ISOPEN) THEN
3584: CLOSE c_manual;
3585: END IF;
3586: IF (c_standard%ISOPEN) THEN
3587: CLOSE c_standard;
3588: END IF;
3589: xla_exceptions_pkg.raise_message
3590: (p_location => 'xla_je_validation_pkg.validate_headers');
3591: END validate_headers;

Line 6523: CURSOR c_error_standard IS

6519: PROCEDURE create_intercompany_errors
6520: (p_err_count IN OUT NOCOPY INTEGER
6521: ,p_err_ae_header_ids IN OUT NOCOPY t_array_int)
6522: IS
6523: CURSOR c_error_standard IS
6524: SELECT distinct
6525: err.error_code
6526: , le2.name from_le_name
6527: , le3.name to_le_name

Line 6592: OPEN c_error_standard;

6588: p_level => C_LEVEL_EVENT);
6589: END IF;
6590:
6591: IF (g_caller in( C_CALLER_ACCT_PROGRAM, C_CALLER_THIRD_PARTY_MERGE, C_CALLER_MPA_PROGRAM)) THEN
6592: OPEN c_error_standard;
6593: ELSE
6594: OPEN c_error_manual;
6595: END IF;
6596:

Line 6599: FETCH c_error_standard INTO l_err;

6595: END IF;
6596:
6597: LOOP
6598: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_THIRD_PARTY_MERGE, C_CALLER_MPA_PROGRAM)) THEN
6599: FETCH c_error_standard INTO l_err;
6600: EXIT WHEN c_error_standard%NOTFOUND;
6601: ELSE
6602: FETCH c_error_manual INTO l_err;
6603: EXIT WHEN c_error_manual%NOTFOUND;

Line 6600: EXIT WHEN c_error_standard%NOTFOUND;

6596:
6597: LOOP
6598: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_THIRD_PARTY_MERGE, C_CALLER_MPA_PROGRAM)) THEN
6599: FETCH c_error_standard INTO l_err;
6600: EXIT WHEN c_error_standard%NOTFOUND;
6601: ELSE
6602: FETCH c_error_manual INTO l_err;
6603: EXIT WHEN c_error_manual%NOTFOUND;
6604: END IF;

Line 6831: CLOSE c_error_standard;

6827: p_level => C_LEVEL_EVENT);
6828: END IF;
6829:
6830: IF (g_caller in (C_CALLER_ACCT_PROGRAM, C_CALLER_THIRD_PARTY_MERGE, C_CALLER_MPA_PROGRAM)) THEN
6831: CLOSE c_error_standard;
6832: ELSE
6833: CLOSE c_error_manual;
6834: END IF;
6835:

Line 6846: IF (c_error_standard%ISOPEN) THEN

6842: WHEN xla_exceptions_pkg.application_exception THEN
6843: IF (c_error_manual%ISOPEN) THEN
6844: CLOSE c_error_manual;
6845: END IF;
6846: IF (c_error_standard%ISOPEN) THEN
6847: CLOSE c_error_standard;
6848: END IF;
6849: RAISE;
6850:

Line 6847: CLOSE c_error_standard;

6843: IF (c_error_manual%ISOPEN) THEN
6844: CLOSE c_error_manual;
6845: END IF;
6846: IF (c_error_standard%ISOPEN) THEN
6847: CLOSE c_error_standard;
6848: END IF;
6849: RAISE;
6850:
6851: WHEN OTHERS THEN

Line 6855: IF (c_error_standard%ISOPEN) THEN

6851: WHEN OTHERS THEN
6852: IF (c_error_manual%ISOPEN) THEN
6853: CLOSE c_error_manual;
6854: END IF;
6855: IF (c_error_standard%ISOPEN) THEN
6856: CLOSE c_error_standard;
6857: END IF;
6858: xla_exceptions_pkg.raise_message
6859: (p_location => 'xla_je_validation_pkg.create_intercompany_errors');

Line 6856: CLOSE c_error_standard;

6852: IF (c_error_manual%ISOPEN) THEN
6853: CLOSE c_error_manual;
6854: END IF;
6855: IF (c_error_standard%ISOPEN) THEN
6856: CLOSE c_error_standard;
6857: END IF;
6858: xla_exceptions_pkg.raise_message
6859: (p_location => 'xla_je_validation_pkg.create_intercompany_errors');
6860: END;

Line 10009: -- requirement for a standard journal entry.

10005: --=============================================================================
10006: --
10007: -- Name: balance_amounts
10008: -- Description: This function handle the validation and the balancing
10009: -- requirement for a standard journal entry.
10010: -- Parameters:
10011: -- p_application_id - the application id (required)
10012: -- p_ledger_id - the transaction ledger id (required)
10013: -- Result:

Line 10121: -- requirement for a standard journal entry.

10117: --=============================================================================
10118: --
10119: -- Name: balance_tpm_amounts
10120: -- Description: This function handle the validation and the balancing
10121: -- requirement for a standard journal entry.
10122: -- Parameters:
10123: -- p_application_id - the application id (required)
10124: -- p_ledger_id - the transaction ledger id (required)
10125: -- Result: