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.194 2011/11/28 23:57:26 pshukla 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 409: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.populate_bsv_suspense_ccid'

405: ,p_token_1 => 'MESSAGE'
406: ,p_value_1 => 'Unable to derive valid GL Account for Suspense Account :'||
407: l_account||' with Balance Segment Value ' || l_err.bal_seg_value
408: ,p_token_2 => 'LOCATION'
409: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.populate_bsv_suspense_ccid'
410: ,p_entity_id => l_err.entity_id
411: ,p_event_id => l_err.event_id
412: ,p_ledger_id => g_ledger_id
413: ,p_ae_header_id => l_err.ae_header_id

Line 462: (p_location => 'xla_je_validation_pkg.populate_bsv_suspense_ccid');

458: IF (c_account%ISOPEN) THEN
459: CLOSE c_account;
460: END IF;
461: xla_exceptions_pkg.raise_message
462: (p_location => 'xla_je_validation_pkg.populate_bsv_suspense_ccid');
463: END populate_bsv_suspense_ccid;
464:
465: --=============================================================================
466: --

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

522: IF (c%ISOPEN) THEN
523: CLOSE c;
524: END IF;
525: xla_exceptions_pkg.raise_message
526: (p_location => 'xla_je_validation_pkg.get_period_name');
527: END get_period_name;
528:
529:
530: --=============================================================================

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

600: RAISE;
601:
602: WHEN OTHERS THEN
603: xla_exceptions_pkg.raise_message
604: (p_location => 'xla_je_validation_pkg.validate_period');
605:
606: END validate_period;
607:
608:

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

808: RAISE;
809:
810: WHEN OTHERS THEN
811: xla_exceptions_pkg.raise_message
812: (p_location => 'xla_je_validation_pkg.initialize');
813:
814: END initialize;
815:
816: --=============================================================================

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

937: IF c_full_none%ISOPEN THEN
938: CLOSE c_full_none;
939: END IF;
940: xla_exceptions_pkg.raise_message
941: (p_location => 'xla_je_validation_pkg.validate_ledger_security');
942:
943: END validate_ledger_security;
944:
945: --=============================================================================

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

1292: IF c_mgt_mgt%ISOPEN THEN
1293: CLOSE c_mgt_mgt;
1294: END IF;
1295: xla_exceptions_pkg.raise_message
1296: (p_location => 'xla_je_validation_pkg.validate_segment_security');
1297: END validate_segment_security;
1298:
1299:
1300: --=============================================================================

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

1343: RAISE;
1344:
1345: WHEN OTHERS THEN
1346: xla_exceptions_pkg.raise_message
1347: (p_location => 'xla_je_validation_pkg.validate_access_set_security');
1348: END validate_access_set_security;
1349:
1350:
1351: --=============================================================================

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

2896: RAISE;
2897:
2898: WHEN OTHERS THEN
2899: xla_exceptions_pkg.raise_message
2900: (p_location => 'xla_je_validation_pkg.load_lines');
2901: END load_lines;
2902:
2903: --=============================================================================
2904: --

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

3081: IF (c_standard%ISOPEN) THEN
3082: CLOSE c_standard;
3083: END IF;
3084: xla_exceptions_pkg.raise_message
3085: (p_location => 'xla_je_validation_pkg.validate_doc_sequence');
3086: END validate_doc_sequence;
3087:
3088: --=============================================================================
3089: --

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

3206: IF (c_err%ISOPEN) THEN
3207: CLOSE c_err;
3208: END IF;
3209: xla_exceptions_pkg.raise_message
3210: (p_location => 'xla_je_validation_pkg.validate_encumbrances');
3211: END validate_encumbrances;
3212:
3213: --=============================================================================
3214: --

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

3420: IF (c_standard%ISOPEN) THEN
3421: CLOSE c_standard;
3422: END IF;
3423: xla_exceptions_pkg.raise_message
3424: (p_location => 'xla_je_validation_pkg.validate_budgets');
3425: END validate_budgets;
3426:
3427:
3428: --=============================================================================

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

3547: IF (c_invalid_business_date%ISOPEN) THEN
3548: CLOSE c_invalid_business_date;
3549: END IF;
3550: xla_exceptions_pkg.raise_message
3551: (p_location => 'xla_je_validation_pkg.validate_business_date');
3552: END validate_business_date;
3553:
3554:
3555:

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

3867: IF (c_standard%ISOPEN) THEN
3868: CLOSE c_standard;
3869: END IF;
3870: xla_exceptions_pkg.raise_message
3871: (p_location => 'xla_je_validation_pkg.validate_headers');
3872: END validate_headers;
3873:
3874: --=============================================================================
3875: --

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

3989: IF (c_invalid_bal_segment%ISOPEN) THEN
3990: CLOSE c_invalid_bal_segment;
3991: END IF;
3992: xla_exceptions_pkg.raise_message
3993: (p_location => 'xla_je_validation_pkg.validate_bal_segments');
3994: END;
3995:
3996: --=============================================================================
3997: --

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

4127: IF (c_invalid_mgt_segment%ISOPEN) THEN
4128: CLOSE c_invalid_mgt_segment;
4129: END IF;
4130: xla_exceptions_pkg.raise_message
4131: (p_location => 'xla_je_validation_pkg.validate_mgt_segments');
4132: END;
4133:
4134: --=============================================================================
4135: --

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

4306: CLOSE c_invalid_party;
4307: END IF;
4308:
4309: xla_exceptions_pkg.raise_message
4310: (p_location => 'xla_je_validation_pkg.validate_third_parties');
4311: END validate_third_parties;
4312:
4313: --=============================================================================
4314: --

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

4453: IF (c_invalid_curr%ISOPEN) THEN
4454: CLOSE c_invalid_curr;
4455: END IF;
4456: xla_exceptions_pkg.raise_message
4457: (p_location => 'xla_je_validation_pkg.validate_currencies');
4458: END validate_currencies;
4459:
4460:
4461: --=============================================================================

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

4558: IF (c_invalid_budget_ccids%ISOPEN) THEN
4559: CLOSE c_invalid_budget_ccids;
4560: END IF;
4561: xla_exceptions_pkg.raise_message
4562: (p_location => 'xla_je_validation_pkg.validate_budget_ccids');
4563: END validate_budget_ccids;
4564:
4565:
4566: --=============================================================================

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

4660: IF (c_invalid_accounting_classes%ISOPEN) THEN
4661: CLOSE c_invalid_accounting_classes;
4662: END IF;
4663: xla_exceptions_pkg.raise_message
4664: (p_location => 'xla_je_validation_pkg.validate_accounting_classes');
4665: END validate_accounting_classes;
4666:
4667:
4668: --=============================================================================

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

5532: IF (c_budget_name%ISOPEN) THEN
5533: CLOSE c_budget_name;
5534: END IF;
5535: xla_exceptions_pkg.raise_message
5536: (p_location => 'xla_je_validation_pkg.validate_lines');
5537: END validate_lines;
5538:
5539:
5540: --=============================================================================

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

5637: RAISE;
5638:
5639: WHEN OTHERS THEN
5640: xla_exceptions_pkg.raise_message
5641: (p_location => 'xla_je_validation_pkg.validation');
5642: END validation;
5643:
5644:
5645: --=============================================================================

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

5833: ,p_msg_name => 'XLA_INTERNAL_ERROR'
5834: ,p_token_1 => 'MESSAGE'
5835: ,p_value_1 => 'Invalid balance by ledger currency suspense CCID'
5836: ,p_token_2 => 'LOCATION'
5837: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_bsv_and_ledger_curr'
5838: ,p_entity_id => p_entity_id
5839: ,p_event_id => p_event_id
5840: ,p_ledger_id => g_ledger_id
5841: ,p_ae_header_id => p_ae_header_id

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

5883: ,p_msg_name => 'XLA_INTERNAL_ERROR'
5884: ,p_token_1 => 'MESSAGE'
5885: ,p_value_1 => 'Cannot get valid Code Combination ID'
5886: ,p_token_2 => 'LOCATION'
5887: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_bsv_and_ledger_curr'
5888: ,p_entity_id => p_entity_id
5889: ,p_event_id => p_event_id
5890: ,p_ledger_id => g_ledger_id
5891: ,p_ae_header_id => p_ae_header_id

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

6015: IF (c_sccid_segs%ISOPEN) THEN
6016: CLOSE c_sccid_segs;
6017: END IF;
6018: xla_exceptions_pkg.raise_message
6019: (p_location => 'xla_je_validation_pkg.balance_by_bsv_and_ledger_curr');
6020: END;
6021:
6022: --=============================================================================
6023: --

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

6138: IF (c_bal%ISOPEN) THEN
6139: CLOSE c_bal;
6140: END IF;
6141: xla_exceptions_pkg.raise_message
6142: (p_location => 'xla_je_validation_pkg.balance_single_entered_curr');
6143:
6144: END balance_single_entered_curr;
6145:
6146:

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

6359: IF (c_bal%ISOPEN) THEN
6360: CLOSE c_bal;
6361: END IF;
6362: xla_exceptions_pkg.raise_message
6363: (p_location => 'xla_je_validation_pkg.balance_by_ledger_currency');
6364: END;
6365:
6366:
6367: --=============================================================================

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

6605: ,p_msg_name => 'XLA_INTERNAL_ERROR'
6606: ,p_token_1 => 'MESSAGE'
6607: ,p_value_1 => 'Invalid rounding CCID'
6608: ,p_token_2 => 'LOCATION'
6609: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_journal_rounding'
6610: ,p_entity_id => l_bal.entity_id
6611: ,p_event_id => l_bal.event_id
6612: ,p_ledger_id => g_ledger_id
6613: ,p_ae_header_id => l_bal.ae_header_id

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

6656: ,p_msg_name => 'XLA_INTERNAL_ERROR'
6657: ,p_token_1 => 'MESSAGE'
6658: ,p_value_1 => 'Cannot get valid Code Combination ID'
6659: ,p_token_2 => 'LOCATION'
6660: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.balance_by_journal_rounding'
6661: ,p_entity_id => l_bal.entity_id
6662: ,p_event_id => l_bal.event_id
6663: ,p_ledger_id => g_ledger_id
6664: ,p_ae_header_id => l_bal.ae_header_id

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

6858: IF (c_rccid_segs%ISOPEN) THEN
6859: CLOSE c_rccid_segs;
6860: END IF;
6861: xla_exceptions_pkg.raise_message
6862: (p_location => 'xla_je_validation_pkg.balance_by_journal_rounding');
6863:
6864: END balance_by_journal_rounding;
6865:
6866: --=============================================================================

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

7238: IF (c_error_standard%ISOPEN) THEN
7239: CLOSE c_error_standard;
7240: END IF;
7241: xla_exceptions_pkg.raise_message
7242: (p_location => 'xla_je_validation_pkg.create_intercompany_errors');
7243: END;
7244:
7245:
7246: --=============================================================================

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

7876: IF (c_bal%ISOPEN) THEN
7877: CLOSE c_bal;
7878: END IF;
7879: xla_exceptions_pkg.raise_message
7880: (p_location => 'xla_je_validation_pkg.balance_by_intercompany');
7881: END;
7882: --=============================================================================
7883: --
7884: -- Name: populate_missing_ccid

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

8146: ,p_msg_name => 'XLA_INTERNAL_ERROR'
8147: ,p_token_1 => 'MESSAGE'
8148: ,p_value_1 => 'Cannot get valid code combination id'
8149: ,p_token_2 => 'LOCATION'
8150: ,p_value_2 => 'XLA_JE_VALIDATION_PKG.populate_missing_ccid'
8151: ,p_entity_id => l_err.entity_id
8152: ,p_event_id => l_err.event_id
8153: ,p_ledger_id => g_ledger_id
8154: ,p_ae_header_id => l_err.ae_header_id

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

8192: IF (c_errors%ISOPEN) THEN
8193: CLOSE c_errors;
8194: END IF;
8195: xla_exceptions_pkg.raise_message
8196: (p_location => 'xla_je_validation_pkg.populate_missing_ccid');
8197: END;
8198:
8199: --=============================================================================
8200: --

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

8917: IF (c_no_sus_ccid%ISOPEN) THEN
8918: CLOSE c_no_sus_ccid;
8919: END IF;
8920: xla_exceptions_pkg.raise_message
8921: (p_location => 'xla_je_validation_pkg.balance_by_entered_curr');
8922: END;
8923:
8924:
8925: --=============================================================================

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

9445: IF (c_no_sus_ccid%ISOPEN) THEN
9446: CLOSE c_no_sus_ccid;
9447: END IF;
9448: xla_exceptions_pkg.raise_message
9449: (p_location => 'xla_je_validation_pkg.balance_by_encumberance');
9450: END;
9451:
9452:
9453: --=============================================================================

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

9648: RAISE;
9649:
9650: WHEN OTHERS THEN
9651: xla_exceptions_pkg.raise_message
9652: (p_location => 'xla_je_validation_pkg.populate_balancing_lines');
9653: END populate_balancing_lines;
9654:
9655: --=============================================================================
9656: --

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

9725: RAISE;
9726:
9727: WHEN OTHERS THEN
9728: xla_exceptions_pkg.raise_message
9729: (p_location => 'xla_je_validation_pkg.populate_segment_values');
9730: END populate_segment_values;
9731:
9732: --=============================================================================
9733: --

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

9835: RAISE;
9836:
9837: WHEN OTHERS THEN
9838: xla_exceptions_pkg.raise_message
9839: (p_location => 'xla_je_validation_pkg.post_validation');
9840: END post_validation;
9841:
9842:
9843: --=============================================================================

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

9916: xla_exceptions_pkg.raise_message
9917: (p_appli_s_name => 'XLA'
9918: ,p_msg_name => 'XLA_COMMON_ERROR'
9919: ,p_token_1 => 'LOCATION'
9920: ,p_value_1 => 'xla_je_validation_pkg.budgetary_control'
9921: ,p_token_2 => 'ERROR'
9922: ,p_value_2 => 'PSA_FUNDS_CHECK_PKG.budgetary_control failed');
9923:
9924: ELSE

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

10255: RAISE;
10256:
10257: WHEN OTHERS THEN
10258: xla_exceptions_pkg.raise_message
10259: (p_location => 'xla_je_validation_pkg.budgetary_control');
10260: END budgetary_control;
10261:
10262:
10263:

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

10393: RAISE;
10394:
10395: WHEN OTHERS THEN
10396: xla_exceptions_pkg.raise_message
10397: (p_location => 'xla_je_validation_pkg.update_error_status');
10398: END;
10399:
10400: --=============================================================================
10401: --

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

10446: RAISE;
10447:
10448: WHEN OTHERS THEN
10449: xla_exceptions_pkg.raise_message
10450: (p_location => 'xla_je_validation_pkg.undo_funds_reserve');
10451: END;
10452:
10453:
10454: --=============================================================================

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

10582: IF (c_qualifier_segment%ISOPEN) THEN
10583: CLOSE c_qualifier_segment;
10584: END IF;
10585: xla_exceptions_pkg.raise_message
10586: (p_location => 'xla_je_validation_pkg.populate_ledger_info');
10587: END populate_ledger_info;
10588:
10589:
10590: --=============================================================================

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

10668: RAISE;
10669:
10670: WHEN OTHERS THEN
10671: xla_exceptions_pkg.raise_message
10672: (p_location => 'xla_je_validation_pkg.balance_by_ledger');
10673: END balance_by_ledger;
10674:
10675:
10676: --=============================================================================

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

10808: RAISE;
10809:
10810: WHEN OTHERS THEN
10811: xla_exceptions_pkg.raise_message
10812: (p_location => 'xla_je_validation_pkg.balance_amounts');
10813: END;
10814:
10815: --=============================================================================
10816: --

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

10905: RAISE;
10906:
10907: WHEN OTHERS THEN
10908: xla_exceptions_pkg.raise_message
10909: (p_location => 'xla_je_validation_pkg.balance_amounts');
10910: END;
10911:
10912: --=============================================================================
10913: --

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

11019: RAISE;
11020:
11021: WHEN OTHERS THEN
11022: xla_exceptions_pkg.raise_message
11023: (p_location => 'xla_je_validation_pkg.balance_manual_entry');
11024: END;
11025:
11026:
11027: --=============================================================================

Line 11046: END xla_je_validation_pkg;

11042: IF NOT g_log_enabled THEN
11043: g_log_level := C_LEVEL_LOG_DISABLED;
11044: END IF;
11045:
11046: END xla_je_validation_pkg;