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.20.12010000.3 2009/02/11 11:31:22 ssawhney 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 507: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_aads'

503: xla_aad_loader_util_pvt.stack_error
504: (p_appli_s_name => 'XLA'
505: ,p_msg_name => 'XLA_COMMON_ERROR'
506: ,p_token_1 => 'LOCATION'
507: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_aads'
508: ,p_token_2 => 'ERROR'
509: ,p_value_2 => 'unhandled exception');
510: RAISE;
511:

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

789: xla_aad_loader_util_pvt.stack_error
790: (p_appli_s_name => 'XLA'
791: ,p_msg_name => 'XLA_COMMON_ERROR'
792: ,p_token_1 => 'LOCATION'
793: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlds'
794: ,p_token_2 => 'ERROR'
795: ,p_value_2 => 'unhandled exception');
796: RAISE;
797:

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

1001: xla_aad_loader_util_pvt.stack_error
1002: (p_appli_s_name => 'XLA'
1003: ,p_msg_name => 'XLA_COMMON_ERROR'
1004: ,p_token_1 => 'LOCATION'
1005: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_jlts'
1006: ,p_token_2 => 'ERROR'
1007: ,p_value_2 => 'unhandled exception');
1008: RAISE;
1009:

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

1171: xla_aad_loader_util_pvt.stack_error
1172: (p_appli_s_name => 'XLA'
1173: ,p_msg_name => 'XLA_COMMON_ERROR'
1174: ,p_token_1 => 'LOCATION'
1175: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_descriptions'
1176: ,p_token_2 => 'ERROR'
1177: ,p_value_2 => 'unhandled exception');
1178: RAISE;
1179:

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

1399: xla_aad_loader_util_pvt.stack_error
1400: (p_appli_s_name => 'XLA'
1401: ,p_msg_name => 'XLA_COMMON_ERROR'
1402: ,p_token_1 => 'LOCATION'
1403: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_adrs'
1404: ,p_token_2 => 'ERROR'
1405: ,p_value_2 => 'unhandled exception');
1406: RAISE;
1407:

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

1596: xla_aad_loader_util_pvt.stack_error
1597: (p_appli_s_name => 'XLA'
1598: ,p_msg_name => 'XLA_COMMON_ERROR'
1599: ,p_token_1 => 'LOCATION'
1600: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_acs'
1601: ,p_token_2 => 'ERROR'
1602: ,p_value_2 => 'unhandled exception');
1603: RAISE;
1604:

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

1643: xla_aad_loader_util_pvt.stack_error
1644: (p_appli_s_name => 'XLA'
1645: ,p_msg_name => 'XLA_COMMON_ERROR'
1646: ,p_token_1 => 'LOCATION'
1647: ,p_value_1 => 'xla_aad_merge_pvt.clean_oracle_components'
1648: ,p_token_2 => 'ERROR'
1649: ,p_value_2 => 'unhandled exception');
1650: RAISE;
1651:

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

1937: xla_aad_loader_util_pvt.stack_error
1938: (p_appli_s_name => 'XLA'
1939: ,p_msg_name => 'XLA_COMMON_ERROR'
1940: ,p_token_1 => 'LOCATION'
1941: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads'
1942: ,p_token_2 => 'ERROR'
1943: ,p_value_2 => 'unhandled exception');
1944: RAISE;
1945:

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

2344: xla_aad_loader_util_pvt.stack_error
2345: (p_appli_s_name => 'XLA'
2346: ,p_msg_name => 'XLA_COMMON_ERROR'
2347: ,p_token_1 => 'LOCATION'
2348: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_defns'
2349: ,p_token_2 => 'ERROR'
2350: ,p_value_2 => 'unhandled exception');
2351: RAISE;
2352:

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

2537: xla_aad_loader_util_pvt.stack_error
2538: (p_appli_s_name => 'XLA'
2539: ,p_msg_name => 'XLA_COMMON_ERROR'
2540: ,p_token_1 => 'LOCATION'
2541: ,p_value_1 => 'xla_aad_merge_pvt.merge_journal_line_types'
2542: ,p_token_2 => 'ERROR'
2543: ,p_value_2 => 'unhandled exception');
2544: RAISE;
2545:

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

2784: xla_aad_loader_util_pvt.stack_error
2785: (p_appli_s_name => 'XLA'
2786: ,p_msg_name => 'XLA_COMMON_ERROR'
2787: ,p_token_1 => 'LOCATION'
2788: ,p_value_1 => 'xla_aad_merge_pvt.merge_descriptions'
2789: ,p_token_2 => 'ERROR'
2790: ,p_value_2 => 'unhandled exception');
2791: RAISE;
2792:

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

3137: xla_aad_loader_util_pvt.stack_error
3138: (p_appli_s_name => 'XLA'
3139: ,p_msg_name => 'XLA_COMMON_ERROR'
3140: ,p_token_1 => 'LOCATION'
3141: ,p_value_1 => 'xla_aad_merge_pvt.merge_analytical_criteria'
3142: ,p_token_2 => 'ERROR'
3143: ,p_value_2 => 'unhandled exception');
3144: RAISE;
3145:

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

3332: xla_aad_loader_util_pvt.stack_error
3333: (p_appli_s_name => 'XLA'
3334: ,p_msg_name => 'XLA_COMMON_ERROR'
3335: ,p_token_1 => 'LOCATION'
3336: ,p_value_1 => 'xla_aad_merge_pvt.merge_adrs'
3337: ,p_token_2 => 'ERROR'
3338: ,p_value_2 => 'unhandled exception');
3339: RAISE;
3340:

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

3495: xla_aad_loader_util_pvt.stack_error
3496: (p_appli_s_name => 'XLA'
3497: ,p_msg_name => 'XLA_COMMON_ERROR'
3498: ,p_token_1 => 'LOCATION'
3499: ,p_value_1 => 'xla_aad_merge_pvt.merge_mapping_sets'
3500: ,p_token_2 => 'ERROR'
3501: ,p_value_2 => 'unhandled exception');
3502: RAISE;
3503:

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

3677: xla_aad_loader_util_pvt.stack_error
3678: (p_appli_s_name => 'XLA'
3679: ,p_msg_name => 'XLA_COMMON_ERROR'
3680: ,p_token_1 => 'LOCATION'
3681: ,p_value_1 => 'xla_aad_merge_pvt.merge_acctg_methods'
3682: ,p_token_2 => 'ERROR'
3683: ,p_value_2 => 'unhandled exception');
3684: RAISE;
3685:

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

3743: xla_aad_loader_util_pvt.stack_error
3744: (p_appli_s_name => 'XLA'
3745: ,p_msg_name => 'XLA_COMMON_ERROR'
3746: ,p_token_1 => 'LOCATION'
3747: ,p_value_1 => 'xla_aad_merge_pvt.merge_aads_and_setups'
3748: ,p_token_2 => 'ERROR'
3749: ,p_value_2 => 'Unhandled exception');
3750: RAISE;
3751:

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

3810: xla_aad_loader_util_pvt.stack_error
3811: (p_appli_s_name => 'XLA'
3812: ,p_msg_name => 'XLA_COMMON_ERROR'
3813: ,p_token_1 => 'LOCATION'
3814: ,p_value_1 => 'xla_aad_merge_pvt.purge_mapping_sets'
3815: ,p_token_2 => 'ERROR'
3816: ,p_value_2 => 'unhandled exception');
3817: RAISE;
3818:

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

3895: xla_aad_loader_util_pvt.stack_error
3896: (p_appli_s_name => 'XLA'
3897: ,p_msg_name => 'XLA_COMMON_ERROR'
3898: ,p_token_1 => 'LOCATION'
3899: ,p_value_1 => 'xla_aad_merge_pvt.purge_analytical_criteria'
3900: ,p_token_2 => 'ERROR'
3901: ,p_value_2 => 'unhandled exception');
3902: RAISE;
3903:

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

3972: xla_aad_loader_util_pvt.stack_error
3973: (p_appli_s_name => 'XLA'
3974: ,p_msg_name => 'XLA_COMMON_ERROR'
3975: ,p_token_1 => 'LOCATION'
3976: ,p_value_1 => 'xla_aad_merge_pvt.purge_adrs'
3977: ,p_token_2 => 'ERROR'
3978: ,p_value_2 => 'unhandled exception');
3979: RAISE;
3980:

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

4020: xla_aad_loader_util_pvt.stack_error
4021: (p_appli_s_name => 'XLA'
4022: ,p_msg_name => 'XLA_COMMON_ERROR'
4023: ,p_token_1 => 'LOCATION'
4024: ,p_value_1 => 'xla_aad_merge_pvt.purge_staging_area'
4025: ,p_token_2 => 'ERROR'
4026: ,p_value_2 => 'unhandled exception');
4027: RAISE;
4028:

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

4060: xla_aad_loader_util_pvt.stack_error
4061: (p_appli_s_name => 'XLA'
4062: ,p_msg_name => 'XLA_COMMON_ERROR'
4063: ,p_token_1 => 'LOCATION'
4064: ,p_value_1 => 'xla_aad_merge_pvt.template_api'
4065: ,p_token_2 => 'ERROR'
4066: ,p_value_2 => 'unhandled exception');
4067: RAISE;
4068:

Line 4121: xla_aad_merge_pvt.merge

4117: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
4118: (p_application_id => p_application_id
4119: ,p_amb_context_code => p_amb_context_code);
4120:
4121: xla_aad_merge_pvt.merge
4122: (p_api_version => p_api_version
4123: ,x_return_status => x_return_status
4124: ,p_application_id => p_application_id
4125: ,p_amb_context_code => p_amb_context_code

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

4156: xla_aad_loader_util_pvt.stack_error
4157: (p_appli_s_name => 'XLA'
4158: ,p_msg_name => 'XLA_COMMON_ERROR'
4159: ,p_token_1 => 'LOCATION'
4160: ,p_value_1 => 'xla_aad_merge_pvt.merge'
4161: ,p_token_2 => 'ERROR'
4162: ,p_value_2 => 'unhandled exception');
4163:
4164: --RAISE;

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

4281: xla_aad_loader_util_pvt.stack_error
4282: (p_appli_s_name => 'XLA'
4283: ,p_msg_name => 'XLA_COMMON_ERROR'
4284: ,p_token_1 => 'LOCATION'
4285: ,p_value_1 => 'xla_aad_merge_pvt.merge'
4286: ,p_token_2 => 'ERROR'
4287: ,p_value_2 => 'unhandled exception');
4288:
4289: --RAISE;

Line 4309: END xla_aad_merge_pvt;

4305: IF NOT g_log_enabled THEN
4306: g_log_level := C_LEVEL_LOG_DISABLED;
4307: END IF;
4308:
4309: END xla_aad_merge_pvt;