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 XLA_JE_VALIDATION_PKG

Line 1: PACKAGE BODY xla_je_validation_pkg AS

1: PACKAGE BODY xla_je_validation_pkg AS
2: /* $Header: xlajebal.pkb 120.158.12010000.3 2008/09/25 12:44:14 svellani ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************

Line 167: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_je_validation_pkg';

163: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
164: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
165:
166: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
167: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_je_validation_pkg';
168:
169: g_log_level NUMBER;
170: g_log_enabled BOOLEAN;
171:

Line 192: (p_location => 'xla_je_validation_pkg.trace');

188: RAISE;
189:
190: WHEN OTHERS THEN
191: xla_exceptions_pkg.raise_message
192: (p_location => 'xla_je_validation_pkg.trace');
193: END trace;
194:
195:
196: --=============================================================================

Line 261: (p_location => 'xla_je_validation_pkg.get_period_name');

257: IF (c%ISOPEN) THEN
258: CLOSE c;
259: END IF;
260: xla_exceptions_pkg.raise_message
261: (p_location => 'xla_je_validation_pkg.get_period_name');
262: END get_period_name;
263:
264:
265: --=============================================================================

Line 339: (p_location => 'xla_je_validation_pkg.validate_period');

335: RAISE;
336:
337: WHEN OTHERS THEN
338: xla_exceptions_pkg.raise_message
339: (p_location => 'xla_je_validation_pkg.validate_period');
340:
341: END validate_period;
342:
343:

Line 547: (p_location => 'xla_je_validation_pkg.initialize');

543: RAISE;
544:
545: WHEN OTHERS THEN
546: xla_exceptions_pkg.raise_message
547: (p_location => 'xla_je_validation_pkg.initialize');
548:
549: END initialize;
550:
551: --=============================================================================

Line 676: (p_location => 'xla_je_validation_pkg.validate_ledger_security');

672: IF c_full_none%ISOPEN THEN
673: CLOSE c_full_none;
674: END IF;
675: xla_exceptions_pkg.raise_message
676: (p_location => 'xla_je_validation_pkg.validate_ledger_security');
677:
678: END validate_ledger_security;
679:
680: --=============================================================================

Line 1031: (p_location => 'xla_je_validation_pkg.validate_segment_security');

1027: IF c_mgt_mgt%ISOPEN THEN
1028: CLOSE c_mgt_mgt;
1029: END IF;
1030: xla_exceptions_pkg.raise_message
1031: (p_location => 'xla_je_validation_pkg.validate_segment_security');
1032: END validate_segment_security;
1033:
1034:
1035: --=============================================================================

Line 1082: (p_location => 'xla_je_validation_pkg.validate_access_set_security');

1078: RAISE;
1079:
1080: WHEN OTHERS THEN
1081: xla_exceptions_pkg.raise_message
1082: (p_location => 'xla_je_validation_pkg.validate_access_set_security');
1083: END validate_access_set_security;
1084:
1085:
1086: --=============================================================================

Line 2625: (p_location => 'xla_je_validation_pkg.load_lines');

2621: RAISE;
2622:
2623: WHEN OTHERS THEN
2624: xla_exceptions_pkg.raise_message
2625: (p_location => 'xla_je_validation_pkg.load_lines');
2626: END load_lines;
2627:
2628: --=============================================================================
2629: --

Line 2810: (p_location => 'xla_je_validation_pkg.validate_doc_sequence');

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;
2812:
2813: --=============================================================================
2814: --

Line 2935: (p_location => 'xla_je_validation_pkg.validate_encumbrances');

2931: IF (c_err%ISOPEN) THEN
2932: CLOSE c_err;
2933: END IF;
2934: xla_exceptions_pkg.raise_message
2935: (p_location => 'xla_je_validation_pkg.validate_encumbrances');
2936: END validate_encumbrances;
2937:
2938: --=============================================================================
2939: --

Line 3149: (p_location => 'xla_je_validation_pkg.validate_budgets');

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;
3151:
3152:
3153: --=============================================================================

Line 3272: (p_location => 'xla_je_validation_pkg.validate_business_date');

3268: IF (c_invalid_business_date%ISOPEN) THEN
3269: CLOSE c_invalid_business_date;
3270: END IF;
3271: xla_exceptions_pkg.raise_message
3272: (p_location => 'xla_je_validation_pkg.validate_business_date');
3273: END validate_business_date;
3274:
3275:
3276:

Line 3590: (p_location => 'xla_je_validation_pkg.validate_headers');

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;
3592:
3593: --=============================================================================
3594: --

Line 3712: (p_location => 'xla_je_validation_pkg.validate_bal_segments');

3708: IF (c_invalid_bal_segment%ISOPEN) THEN
3709: CLOSE c_invalid_bal_segment;
3710: END IF;
3711: xla_exceptions_pkg.raise_message
3712: (p_location => 'xla_je_validation_pkg.validate_bal_segments');
3713: END;
3714:
3715: --=============================================================================
3716: --

Line 3850: (p_location => 'xla_je_validation_pkg.validate_mgt_segments');

3846: IF (c_invalid_mgt_segment%ISOPEN) THEN
3847: CLOSE c_invalid_mgt_segment;
3848: END IF;
3849: xla_exceptions_pkg.raise_message
3850: (p_location => 'xla_je_validation_pkg.validate_mgt_segments');
3851: END;
3852:
3853: --=============================================================================
3854: --

Line 4025: (p_location => 'xla_je_validation_pkg.validate_third_parties');

4021: CLOSE c_invalid_party;
4022: END IF;
4023:
4024: xla_exceptions_pkg.raise_message
4025: (p_location => 'xla_je_validation_pkg.validate_third_parties');
4026: END validate_third_parties;
4027:
4028: --=============================================================================
4029: --

Line 4170: (p_location => 'xla_je_validation_pkg.validate_currencies');

4166: IF (c_invalid_curr%ISOPEN) THEN
4167: CLOSE c_invalid_curr;
4168: END IF;
4169: xla_exceptions_pkg.raise_message
4170: (p_location => 'xla_je_validation_pkg.validate_currencies');
4171: END validate_currencies;
4172:
4173:
4174: --=============================================================================

Line 4275: (p_location => 'xla_je_validation_pkg.validate_budget_ccids');

4271: IF (c_invalid_budget_ccids%ISOPEN) THEN
4272: CLOSE c_invalid_budget_ccids;
4273: END IF;
4274: xla_exceptions_pkg.raise_message
4275: (p_location => 'xla_je_validation_pkg.validate_budget_ccids');
4276: END validate_budget_ccids;
4277:
4278:
4279: --=============================================================================

Line 4377: (p_location => 'xla_je_validation_pkg.validate_accounting_classes');

4373: IF (c_invalid_accounting_classes%ISOPEN) THEN
4374: CLOSE c_invalid_accounting_classes;
4375: END IF;
4376: xla_exceptions_pkg.raise_message
4377: (p_location => 'xla_je_validation_pkg.validate_accounting_classes');
4378: END validate_accounting_classes;
4379:
4380:
4381: --=============================================================================

Line 5234: (p_location => 'xla_je_validation_pkg.validate_lines');

5230: IF (c_budget_name%ISOPEN) THEN
5231: CLOSE c_budget_name;
5232: END IF;
5233: xla_exceptions_pkg.raise_message
5234: (p_location => 'xla_je_validation_pkg.validate_lines');
5235: END validate_lines;
5236:
5237:
5238: --=============================================================================

Line 5338: (p_location => 'xla_je_validation_pkg.validation');

5334: RAISE;
5335:
5336: WHEN OTHERS THEN
5337: xla_exceptions_pkg.raise_message
5338: (p_location => 'xla_je_validation_pkg.validation');
5339: END validation;
5340:
5341:
5342: --=============================================================================

Line 5533: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_bsv_and_ledger_curr'

5529: ,p_msg_name => 'XLA_INTERNAL_ERROR'
5530: ,p_token_1 => 'MESSAGE'
5531: ,p_value_1 => 'Invalid balance by ledger currency suspense CCID'
5532: ,p_token_2 => 'LOCATION'
5533: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_bsv_and_ledger_curr'
5534: ,p_entity_id => p_entity_id
5535: ,p_event_id => p_event_id
5536: ,p_ledger_id => g_ledger_id
5537: ,p_ae_header_id => p_ae_header_id

Line 5583: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_bsv_and_ledger_curr'

5579: ,p_msg_name => 'XLA_INTERNAL_ERROR'
5580: ,p_token_1 => 'MESSAGE'
5581: ,p_value_1 => 'Cannot get valid Code Combination ID'
5582: ,p_token_2 => 'LOCATION'
5583: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_bsv_and_ledger_curr'
5584: ,p_entity_id => p_entity_id
5585: ,p_event_id => p_event_id
5586: ,p_ledger_id => g_ledger_id
5587: ,p_ae_header_id => p_ae_header_id

Line 5707: (p_location => 'xla_je_validation_pkg.balance_by_bsv_and_ledger_curr');

5703: IF (c_sccid_segs%ISOPEN) THEN
5704: CLOSE c_sccid_segs;
5705: END IF;
5706: xla_exceptions_pkg.raise_message
5707: (p_location => 'xla_je_validation_pkg.balance_by_bsv_and_ledger_curr');
5708: END;
5709:
5710: --=============================================================================
5711: --

Line 5830: (p_location => 'xla_je_validation_pkg.balance_single_entered_curr');

5826: IF (c_bal%ISOPEN) THEN
5827: CLOSE c_bal;
5828: END IF;
5829: xla_exceptions_pkg.raise_message
5830: (p_location => 'xla_je_validation_pkg.balance_single_entered_curr');
5831:
5832: END balance_single_entered_curr;
5833:
5834:

Line 6051: (p_location => 'xla_je_validation_pkg.balance_by_ledger_currency');

6047: IF (c_bal%ISOPEN) THEN
6048: CLOSE c_bal;
6049: END IF;
6050: xla_exceptions_pkg.raise_message
6051: (p_location => 'xla_je_validation_pkg.balance_by_ledger_currency');
6052: END;
6053:
6054:
6055: --=============================================================================

Line 6295: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_journal_rounding'

6291: ,p_msg_name => 'XLA_INTERNAL_ERROR'
6292: ,p_token_1 => 'MESSAGE'
6293: ,p_value_1 => 'Invalid rounding CCID'
6294: ,p_token_2 => 'LOCATION'
6295: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_journal_rounding'
6296: ,p_entity_id => l_bal.entity_id
6297: ,p_event_id => l_bal.event_id
6298: ,p_ledger_id => g_ledger_id
6299: ,p_ae_header_id => l_bal.ae_header_id

Line 6346: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_journal_rounding'

6342: ,p_msg_name => 'XLA_INTERNAL_ERROR'
6343: ,p_token_1 => 'MESSAGE'
6344: ,p_value_1 => 'Cannot get valid Code Combination ID'
6345: ,p_token_2 => 'LOCATION'
6346: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_journal_rounding'
6347: ,p_entity_id => l_bal.entity_id
6348: ,p_event_id => l_bal.event_id
6349: ,p_ledger_id => g_ledger_id
6350: ,p_ae_header_id => l_bal.ae_header_id

Line 6508: (p_location => 'xla_je_validation_pkg.balance_by_journal_rounding');

6504: IF (c_rccid_segs%ISOPEN) THEN
6505: CLOSE c_rccid_segs;
6506: END IF;
6507: xla_exceptions_pkg.raise_message
6508: (p_location => 'xla_je_validation_pkg.balance_by_journal_rounding');
6509:
6510: END balance_by_journal_rounding;
6511:
6512: --=============================================================================

Line 6859: (p_location => 'xla_je_validation_pkg.create_intercompany_errors');

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;
6861:
6862:
6863: --=============================================================================

Line 7428: (p_location => 'xla_je_validation_pkg.balance_by_intercompany');

7424: IF (c_bal%ISOPEN) THEN
7425: CLOSE c_bal;
7426: END IF;
7427: xla_exceptions_pkg.raise_message
7428: (p_location => 'xla_je_validation_pkg.balance_by_intercompany');
7429: END;
7430:
7431:
7432: --=============================================================================

Line 7700: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.populate_missing_ccid'

7696: ,p_msg_name => 'XLA_INTERNAL_ERROR'
7697: ,p_token_1 => 'MESSAGE'
7698: ,p_value_1 => 'Cannot get valid code combination id'
7699: ,p_token_2 => 'LOCATION'
7700: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.populate_missing_ccid'
7701: ,p_entity_id => l_err.entity_id
7702: ,p_event_id => l_err.event_id
7703: ,p_ledger_id => g_ledger_id
7704: ,p_ae_header_id => l_err.ae_header_id

Line 7746: (p_location => 'xla_je_validation_pkg.populate_missing_ccid');

7742: IF (c_errors%ISOPEN) THEN
7743: CLOSE c_errors;
7744: END IF;
7745: xla_exceptions_pkg.raise_message
7746: (p_location => 'xla_je_validation_pkg.populate_missing_ccid');
7747: END;
7748:
7749: --=============================================================================
7750: --

Line 8323: (p_location => 'xla_je_validation_pkg.balance_by_entered_curr');

8319: IF (c_no_sus_ccid%ISOPEN) THEN
8320: CLOSE c_no_sus_ccid;
8321: END IF;
8322: xla_exceptions_pkg.raise_message
8323: (p_location => 'xla_je_validation_pkg.balance_by_entered_curr');
8324: END;
8325:
8326:
8327: --=============================================================================

Line 8768: (p_location => 'xla_je_validation_pkg.balance_by_encumberance');

8764: IF (c_no_sus_ccid%ISOPEN) THEN
8765: CLOSE c_no_sus_ccid;
8766: END IF;
8767: xla_exceptions_pkg.raise_message
8768: (p_location => 'xla_je_validation_pkg.balance_by_encumberance');
8769: END;
8770:
8771:
8772: --=============================================================================

Line 8971: (p_location => 'xla_je_validation_pkg.populate_balancing_lines');

8967: RAISE;
8968:
8969: WHEN OTHERS THEN
8970: xla_exceptions_pkg.raise_message
8971: (p_location => 'xla_je_validation_pkg.populate_balancing_lines');
8972: END populate_balancing_lines;
8973:
8974: --=============================================================================
8975: --

Line 9048: (p_location => 'xla_je_validation_pkg.populate_segment_values');

9044: RAISE;
9045:
9046: WHEN OTHERS THEN
9047: xla_exceptions_pkg.raise_message
9048: (p_location => 'xla_je_validation_pkg.populate_segment_values');
9049: END populate_segment_values;
9050:
9051: --=============================================================================
9052: --

Line 9158: (p_location => 'xla_je_validation_pkg.post_validation');

9154: RAISE;
9155:
9156: WHEN OTHERS THEN
9157: xla_exceptions_pkg.raise_message
9158: (p_location => 'xla_je_validation_pkg.post_validation');
9159: END post_validation;
9160:
9161:
9162: --=============================================================================

Line 9239: ,p_value_1 => 'xla_je_validation_pkg.budgetary_control'

9235: xla_exceptions_pkg.raise_message
9236: (p_appli_s_name => 'XLA'
9237: ,p_msg_name => 'XLA_COMMON_ERROR'
9238: ,p_token_1 => 'LOCATION'
9239: ,p_value_1 => 'xla_je_validation_pkg.budgetary_control'
9240: ,p_token_2 => 'ERROR'
9241: ,p_value_2 => 'PSA_FUNDS_CHECK_PKG.budgetary_control failed');
9242:
9243: ELSE

Line 9578: (p_location => 'xla_je_validation_pkg.budgetary_control');

9574: RAISE;
9575:
9576: WHEN OTHERS THEN
9577: xla_exceptions_pkg.raise_message
9578: (p_location => 'xla_je_validation_pkg.budgetary_control');
9579: END budgetary_control;
9580:
9581:
9582:

Line 9712: (p_location => 'xla_je_validation_pkg.update_error_status');

9708: RAISE;
9709:
9710: WHEN OTHERS THEN
9711: xla_exceptions_pkg.raise_message
9712: (p_location => 'xla_je_validation_pkg.update_error_status');
9713: END;
9714:
9715: --=============================================================================
9716: --

Line 9765: (p_location => 'xla_je_validation_pkg.undo_funds_reserve');

9761: RAISE;
9762:
9763: WHEN OTHERS THEN
9764: xla_exceptions_pkg.raise_message
9765: (p_location => 'xla_je_validation_pkg.undo_funds_reserve');
9766: END;
9767:
9768:
9769: --=============================================================================

Line 9901: (p_location => 'xla_je_validation_pkg.populate_ledger_info');

9897: IF (c_qualifier_segment%ISOPEN) THEN
9898: CLOSE c_qualifier_segment;
9899: END IF;
9900: xla_exceptions_pkg.raise_message
9901: (p_location => 'xla_je_validation_pkg.populate_ledger_info');
9902: END populate_ledger_info;
9903:
9904:
9905: --=============================================================================

Line 9987: (p_location => 'xla_je_validation_pkg.balance_by_ledger');

9983: RAISE;
9984:
9985: WHEN OTHERS THEN
9986: xla_exceptions_pkg.raise_message
9987: (p_location => 'xla_je_validation_pkg.balance_by_ledger');
9988: END balance_by_ledger;
9989:
9990:
9991: --=============================================================================

Line 10114: (p_location => 'xla_je_validation_pkg.balance_amounts');

10110: RAISE;
10111:
10112: WHEN OTHERS THEN
10113: xla_exceptions_pkg.raise_message
10114: (p_location => 'xla_je_validation_pkg.balance_amounts');
10115: END;
10116:
10117: --=============================================================================
10118: --

Line 10205: (p_location => 'xla_je_validation_pkg.balance_amounts');

10201: RAISE;
10202:
10203: WHEN OTHERS THEN
10204: xla_exceptions_pkg.raise_message
10205: (p_location => 'xla_je_validation_pkg.balance_amounts');
10206: END;
10207:
10208: --=============================================================================
10209: --

Line 10314: (p_location => 'xla_je_validation_pkg.balance_manual_entry');

10310: RAISE;
10311:
10312: WHEN OTHERS THEN
10313: xla_exceptions_pkg.raise_message
10314: (p_location => 'xla_je_validation_pkg.balance_manual_entry');
10315: END;
10316:
10317:
10318: --=============================================================================

Line 10337: END xla_je_validation_pkg;

10333: IF NOT g_log_enabled THEN
10334: g_log_level := C_LEVEL_LOG_DISABLED;
10335: END IF;
10336:
10337: END xla_je_validation_pkg;