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_AAD_MERGE_PVT dependencies on XLA_AAD_MERGE_PVT

Line 1: PACKAGE BODY xla_aad_merge_pvt AS

1: PACKAGE BODY xla_aad_merge_pvt AS
2: /* $Header: xlaalmer.pkb 120.32.12020000.3 2012/08/02 11:37:17 sgullape ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************

Line 48: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_merge_pvt';

44: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
45: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
46:
47: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
48: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_merge_pvt';
49:
50: g_log_level NUMBER;
51: g_log_enabled BOOLEAN;
52:

Line 70: (p_location => 'xla_aad_merge_pvt.trace');

66: END IF;
67: EXCEPTION
68: WHEN OTHERS THEN
69: xla_exceptions_pkg.raise_message
70: (p_location => 'xla_aad_merge_pvt.trace');
71:
72: END trace;
73:
74:

Line 165: ,p_value_1 => 'xla_aad_merge_pvt.pre_merge'

161: xla_aad_loader_util_pvt.stack_error
162: (p_appli_s_name => 'XLA'
163: ,p_msg_name => 'XLA_COMMON_ERROR'
164: ,p_token_1 => 'LOCATION'
165: ,p_value_1 => 'xla_aad_merge_pvt.pre_merge'
166: ,p_token_2 => 'ERROR'
167: ,p_value_2 => 'unhandled exception');
168: RAISE;
169: END IF;

Line 286: ,p_value_1 => 'xla_aad_merge_pvt.validation'

282: xla_aad_loader_util_pvt.stack_error
283: (p_appli_s_name => 'XLA'
284: ,p_msg_name => 'XLA_COMMON_ERROR'
285: ,p_token_1 => 'LOCATION'
286: ,p_value_1 => 'xla_aad_merge_pvt.validation'
287: ,p_token_2 => 'ERROR'
288: ,p_value_2 => 'Unhandled exception');
289: RAISE;
290:

Line 567: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_aads'

563: xla_aad_loader_util_pvt.stack_error
564: (p_appli_s_name => 'XLA'
565: ,p_msg_name => 'XLA_COMMON_ERROR'
566: ,p_token_1 => 'LOCATION'
567: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_aads'
568: ,p_token_2 => 'ERROR'
569: ,p_value_2 => 'unhandled exception');
570: RAISE;
571:

Line 941: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlds'

937: xla_aad_loader_util_pvt.stack_error
938: (p_appli_s_name => 'XLA'
939: ,p_msg_name => 'XLA_COMMON_ERROR'
940: ,p_token_1 => 'LOCATION'
941: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlds'
942: ,p_token_2 => 'ERROR'
943: ,p_value_2 => 'unhandled exception');
944: RAISE;
945:

Line 1242: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlts'

1238: xla_aad_loader_util_pvt.stack_error
1239: (p_appli_s_name => 'XLA'
1240: ,p_msg_name => 'XLA_COMMON_ERROR'
1241: ,p_token_1 => 'LOCATION'
1242: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlts'
1243: ,p_token_2 => 'ERROR'
1244: ,p_value_2 => 'unhandled exception');
1245: RAISE;
1246:

Line 1476: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_descriptions'

1472: xla_aad_loader_util_pvt.stack_error
1473: (p_appli_s_name => 'XLA'
1474: ,p_msg_name => 'XLA_COMMON_ERROR'
1475: ,p_token_1 => 'LOCATION'
1476: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_descriptions'
1477: ,p_token_2 => 'ERROR'
1478: ,p_value_2 => 'unhandled exception');
1479: RAISE;
1480:

Line 1775: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_adrs'

1771: xla_aad_loader_util_pvt.stack_error
1772: (p_appli_s_name => 'XLA'
1773: ,p_msg_name => 'XLA_COMMON_ERROR'
1774: ,p_token_1 => 'LOCATION'
1775: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_adrs'
1776: ,p_token_2 => 'ERROR'
1777: ,p_value_2 => 'unhandled exception');
1778: RAISE;
1779:

Line 1983: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_acs'

1979: xla_aad_loader_util_pvt.stack_error
1980: (p_appli_s_name => 'XLA'
1981: ,p_msg_name => 'XLA_COMMON_ERROR'
1982: ,p_token_1 => 'LOCATION'
1983: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_acs'
1984: ,p_token_2 => 'ERROR'
1985: ,p_value_2 => 'unhandled exception');
1986: RAISE;
1987:

Line 2084: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_components'

2080: xla_aad_loader_util_pvt.stack_error
2081: (p_appli_s_name => 'XLA'
2082: ,p_msg_name => 'XLA_COMMON_ERROR'
2083: ,p_token_1 => 'LOCATION'
2084: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_components'
2085: ,p_token_2 => 'ERROR'
2086: ,p_value_2 => 'unhandled exception');
2087: RAISE;
2088:

Line 2696: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads'

2692: xla_aad_loader_util_pvt.stack_error
2693: (p_appli_s_name => 'XLA'
2694: ,p_msg_name => 'XLA_COMMON_ERROR'
2695: ,p_token_1 => 'LOCATION'
2696: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads'
2697: ,p_token_2 => 'ERROR'
2698: ,p_value_2 => 'unhandled exception');
2699: RAISE;
2700:

Line 3858: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_defns'

3854: xla_aad_loader_util_pvt.stack_error
3855: (p_appli_s_name => 'XLA'
3856: ,p_msg_name => 'XLA_COMMON_ERROR'
3857: ,p_token_1 => 'LOCATION'
3858: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_defns'
3859: ,p_token_2 => 'ERROR'
3860: ,p_value_2 => 'unhandled exception');
3861: RAISE;
3862:

Line 4315: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_types'

4311: xla_aad_loader_util_pvt.stack_error
4312: (p_appli_s_name => 'XLA'
4313: ,p_msg_name => 'XLA_COMMON_ERROR'
4314: ,p_token_1 => 'LOCATION'
4315: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_types'
4316: ,p_token_2 => 'ERROR'
4317: ,p_value_2 => 'unhandled exception');
4318: RAISE;
4319:

Line 4820: ,p_value_1 => 'xla_aad_merge_pvt.merge_descriptions'

4816: xla_aad_loader_util_pvt.stack_error
4817: (p_appli_s_name => 'XLA'
4818: ,p_msg_name => 'XLA_COMMON_ERROR'
4819: ,p_token_1 => 'LOCATION'
4820: ,p_value_1 => 'xla_aad_merge_pvt.merge_descriptions'
4821: ,p_token_2 => 'ERROR'
4822: ,p_value_2 => 'unhandled exception');
4823: RAISE;
4824:

Line 5464: trace(p_msg => 'In exception of xla_aad_merge_pvt.merge_analytical_criteria',

5460: l_exception := substr(sqlerrm,1,240);
5461: l_excp_code := sqlcode;
5462:
5463: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5464: trace(p_msg => 'In exception of xla_aad_merge_pvt.merge_analytical_criteria',
5465: p_module => l_log_module,
5466: p_level => C_LEVEL_PROCEDURE);
5467: END IF;
5468:

Line 5479: ,p_value_1 => 'xla_aad_merge_pvt.merge_analytical_criteria'

5475: xla_aad_loader_util_pvt.stack_error
5476: (p_appli_s_name => 'XLA'
5477: ,p_msg_name => 'XLA_COMMON_ERROR'
5478: ,p_token_1 => 'LOCATION'
5479: ,p_value_1 => 'xla_aad_merge_pvt.merge_analytical_criteria'
5480: ,p_token_2 => 'ERROR'
5481: ,p_value_2 => 'unhandled exception');
5482:
5483: RAISE;

Line 5852: ,p_value_1 => 'xla_aad_merge_pvt.merge_adrs'

5848: xla_aad_loader_util_pvt.stack_error
5849: (p_appli_s_name => 'XLA'
5850: ,p_msg_name => 'XLA_COMMON_ERROR'
5851: ,p_token_1 => 'LOCATION'
5852: ,p_value_1 => 'xla_aad_merge_pvt.merge_adrs'
5853: ,p_token_2 => 'ERROR'
5854: ,p_value_2 => 'unhandled exception');
5855: RAISE;
5856:

Line 6080: ,p_value_1 => 'xla_aad_merge_pvt.merge_mapping_sets'

6076: xla_aad_loader_util_pvt.stack_error
6077: (p_appli_s_name => 'XLA'
6078: ,p_msg_name => 'XLA_COMMON_ERROR'
6079: ,p_token_1 => 'LOCATION'
6080: ,p_value_1 => 'xla_aad_merge_pvt.merge_mapping_sets'
6081: ,p_token_2 => 'ERROR'
6082: ,p_value_2 => 'unhandled exception');
6083: RAISE;
6084:

Line 6372: ,p_value_1 => 'xla_aad_merge_pvt.merge_acctg_methods'

6368: xla_aad_loader_util_pvt.stack_error
6369: (p_appli_s_name => 'XLA'
6370: ,p_msg_name => 'XLA_COMMON_ERROR'
6371: ,p_token_1 => 'LOCATION'
6372: ,p_value_1 => 'xla_aad_merge_pvt.merge_acctg_methods'
6373: ,p_token_2 => 'ERROR'
6374: ,p_value_2 => 'unhandled exception');
6375: RAISE;
6376:

Line 6442: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads_and_setups'

6438: xla_aad_loader_util_pvt.stack_error
6439: (p_appli_s_name => 'XLA'
6440: ,p_msg_name => 'XLA_COMMON_ERROR'
6441: ,p_token_1 => 'LOCATION'
6442: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads_and_setups'
6443: ,p_token_2 => 'ERROR'
6444: ,p_value_2 => 'Unhandled exception');
6445: RAISE;
6446:

Line 6534: ,p_value_1 => 'xla_aad_merge_pvt.purge_mapping_sets'

6530: xla_aad_loader_util_pvt.stack_error
6531: (p_appli_s_name => 'XLA'
6532: ,p_msg_name => 'XLA_COMMON_ERROR'
6533: ,p_token_1 => 'LOCATION'
6534: ,p_value_1 => 'xla_aad_merge_pvt.purge_mapping_sets'
6535: ,p_token_2 => 'ERROR'
6536: ,p_value_2 => 'unhandled exception');
6537: RAISE;
6538:

Line 6660: ,p_value_1 => 'xla_aad_merge_pvt.purge_analytical_criteria'

6656: xla_aad_loader_util_pvt.stack_error
6657: (p_appli_s_name => 'XLA'
6658: ,p_msg_name => 'XLA_COMMON_ERROR'
6659: ,p_token_1 => 'LOCATION'
6660: ,p_value_1 => 'xla_aad_merge_pvt.purge_analytical_criteria'
6661: ,p_token_2 => 'ERROR'
6662: ,p_value_2 => 'unhandled exception');
6663: RAISE;
6664:

Line 6773: ,p_value_1 => 'xla_aad_merge_pvt.purge_adrs'

6769: xla_aad_loader_util_pvt.stack_error
6770: (p_appli_s_name => 'XLA'
6771: ,p_msg_name => 'XLA_COMMON_ERROR'
6772: ,p_token_1 => 'LOCATION'
6773: ,p_value_1 => 'xla_aad_merge_pvt.purge_adrs'
6774: ,p_token_2 => 'ERROR'
6775: ,p_value_2 => 'unhandled exception');
6776: RAISE;
6777:

Line 6821: ,p_value_1 => 'xla_aad_merge_pvt.purge_staging_area'

6817: xla_aad_loader_util_pvt.stack_error
6818: (p_appli_s_name => 'XLA'
6819: ,p_msg_name => 'XLA_COMMON_ERROR'
6820: ,p_token_1 => 'LOCATION'
6821: ,p_value_1 => 'xla_aad_merge_pvt.purge_staging_area'
6822: ,p_token_2 => 'ERROR'
6823: ,p_value_2 => 'unhandled exception');
6824: RAISE;
6825:

Line 6861: ,p_value_1 => 'xla_aad_merge_pvt.template_api'

6857: xla_aad_loader_util_pvt.stack_error
6858: (p_appli_s_name => 'XLA'
6859: ,p_msg_name => 'XLA_COMMON_ERROR'
6860: ,p_token_1 => 'LOCATION'
6861: ,p_value_1 => 'xla_aad_merge_pvt.template_api'
6862: ,p_token_2 => 'ERROR'
6863: ,p_value_2 => 'unhandled exception');
6864: RAISE;
6865:

Line 6918: xla_aad_merge_pvt.merge

6914: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
6915: (p_application_id => p_application_id
6916: ,p_amb_context_code => p_amb_context_code);
6917:
6918: xla_aad_merge_pvt.merge
6919: (p_api_version => p_api_version
6920: ,x_return_status => x_return_status
6921: ,p_application_id => p_application_id
6922: ,p_amb_context_code => p_amb_context_code

Line 6957: ,p_value_1 => 'xla_aad_merge_pvt.merge'

6953: xla_aad_loader_util_pvt.stack_error
6954: (p_appli_s_name => 'XLA'
6955: ,p_msg_name => 'XLA_COMMON_ERROR'
6956: ,p_token_1 => 'LOCATION'
6957: ,p_value_1 => 'xla_aad_merge_pvt.merge'
6958: ,p_token_2 => 'ERROR'
6959: ,p_value_2 => 'unhandled exception');
6960:
6961: --RAISE;

Line 7087: ,p_value_1 => 'xla_aad_merge_pvt.merge'

7083: xla_aad_loader_util_pvt.stack_error
7084: (p_appli_s_name => 'XLA'
7085: ,p_msg_name => 'XLA_COMMON_ERROR'
7086: ,p_token_1 => 'LOCATION'
7087: ,p_value_1 => 'xla_aad_merge_pvt.merge'
7088: ,p_token_2 => 'ERROR'
7089: ,p_value_2 => 'unhandled exception');
7090:
7091: --RAISE;

Line 7111: END xla_aad_merge_pvt;

7107: IF NOT g_log_enabled THEN
7108: g_log_level := C_LEVEL_LOG_DISABLED;
7109: END IF;
7110:
7111: END xla_aad_merge_pvt;