1: PACKAGE BODY xla_aad_overwrite_pvt AS
2: /* $Header: xlaalovw.pkb 120.14 2006/06/28 19:36:32 wychan ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35:
36: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
37: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_overwrite_pvt';
38:
39: g_log_level NUMBER;
40: g_log_enabled BOOLEAN;
41:
55: END IF;
56: EXCEPTION
57: WHEN OTHERS THEN
58: xla_exceptions_pkg.raise_message
59: (p_location => 'xla_aad_overwrite_pvt.trace');
60:
61: END trace;
62:
63:
285: xla_aad_loader_util_pvt.stack_error
286: (p_appli_s_name => 'XLA'
287: ,p_msg_name => 'XLA_COMMON_ERROR'
288: ,p_token_1 => 'LOCATION'
289: ,p_value_1 => 'xla_aad_overwrite_pvt.validation'
290: ,p_token_2 => 'ERROR'
291: ,p_value_2 => 'unhandled exception');
292: RAISE;
293:
375: xla_aad_loader_util_pvt.stack_error
376: (p_appli_s_name => 'XLA'
377: ,p_msg_name => 'XLA_COMMON_ERROR'
378: ,p_token_1 => 'LOCATION'
379: ,p_value_1 => 'xla_aad_overwrite_pvt.record_log'
380: ,p_token_2 => 'ERROR'
381: ,p_value_2 => 'unhandled exception');
382: RAISE;
383:
467: xla_aad_loader_util_pvt.stack_error
468: (p_appli_s_name => 'XLA'
469: ,p_msg_name => 'XLA_COMMON_ERROR'
470: ,p_token_1 => 'LOCATION'
471: ,p_value_1 => 'xla_aad_overwrite_pvt.pre_overwrite'
472: ,p_token_2 => 'ERROR'
473: ,p_value_2 => 'unhandled exception');
474: RAISE;
475: END IF;
646: xla_aad_loader_util_pvt.stack_error
647: (p_appli_s_name => 'XLA'
648: ,p_msg_name => 'XLA_COMMON_ERROR'
649: ,p_token_1 => 'LOCATION'
650: ,p_value_1 => 'xla_aad_overwrite_pvt.purge_mapping_sets'
651: ,p_token_2 => 'ERROR'
652: ,p_value_2 => 'unhandled exception');
653: RAISE;
654:
891: xla_aad_loader_util_pvt.stack_error
892: (p_appli_s_name => 'XLA'
893: ,p_msg_name => 'XLA_COMMON_ERROR'
894: ,p_token_1 => 'LOCATION'
895: ,p_value_1 => 'xla_aad_overwrite_pvt.purge_analytical_criteria'
896: ,p_token_2 => 'ERROR'
897: ,p_value_2 => 'unhandled exception');
898: RAISE;
899:
1131: xla_aad_loader_util_pvt.stack_error
1132: (p_appli_s_name => 'XLA'
1133: ,p_msg_name => 'XLA_COMMON_ERROR'
1134: ,p_token_1 => 'LOCATION'
1135: ,p_value_1 => 'xla_aad_overwrite_pvt.purge_adr'
1136: ,p_token_2 => 'ERROR'
1137: ,p_value_2 => 'unhandled exception');
1138: RAISE;
1139:
1246: xla_aad_loader_util_pvt.stack_error
1247: (p_appli_s_name => 'XLA'
1248: ,p_msg_name => 'XLA_COMMON_ERROR'
1249: ,p_token_1 => 'LOCATION'
1250: ,p_value_1 => 'xla_aad_overwrite_pvt.purge_adr_reference'
1251: ,p_token_2 => 'ERROR'
1252: ,p_value_2 => 'unhandled exception');
1253: RAISE;
1254:
1504: xla_aad_loader_util_pvt.stack_error
1505: (p_appli_s_name => 'XLA'
1506: ,p_msg_name => 'XLA_COMMON_ERROR'
1507: ,p_token_1 => 'LOCATION'
1508: ,p_value_1 => 'xla_aad_overwrite_pvt.move_components'
1509: ,p_token_2 => 'ERROR'
1510: ,p_value_2 => 'unhandled exception');
1511: RAISE;
1512:
1634: xla_aad_loader_util_pvt.stack_error
1635: (p_appli_s_name => 'XLA'
1636: ,p_msg_name => 'XLA_COMMON_ERROR'
1637: ,p_token_1 => 'LOCATION'
1638: ,p_value_1 => 'xla_aad_overwrite_pvt.move_jlds'
1639: ,p_token_2 => 'ERROR'
1640: ,p_value_2 => 'unhandled exception');
1641: RAISE;
1642:
1737: xla_aad_loader_util_pvt.stack_error
1738: (p_appli_s_name => 'XLA'
1739: ,p_msg_name => 'XLA_COMMON_ERROR'
1740: ,p_token_1 => 'LOCATION'
1741: ,p_value_1 => 'xla_aad_overwrite_pvt.move_aads'
1742: ,p_token_2 => 'ERROR'
1743: ,p_value_2 => 'unhandled exception');
1744: RAISE;
1745:
1863: xla_aad_loader_util_pvt.stack_error
1864: (p_appli_s_name => 'XLA'
1865: ,p_msg_name => 'XLA_COMMON_ERROR'
1866: ,p_token_1 => 'LOCATION'
1867: ,p_value_1 => 'xla_aad_overwrite_pvt.move_acctg_methods'
1868: ,p_token_2 => 'ERROR'
1869: ,p_value_2 => 'unhandled exception');
1870: RAISE;
1871:
1924: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
1925: (p_application_id => p_application_id
1926: ,p_amb_context_code => p_amb_context_code);
1927:
1928: xla_aad_overwrite_pvt.overwrite
1929: (p_api_version => p_api_version
1930: ,x_return_status => x_return_status
1931: ,p_application_id => p_application_id
1932: ,p_amb_context_code => p_amb_context_code
1962: xla_aad_loader_util_pvt.stack_error
1963: (p_appli_s_name => 'XLA'
1964: ,p_msg_name => 'XLA_COMMON_ERROR'
1965: ,p_token_1 => 'LOCATION'
1966: ,p_value_1 => 'xla_aad_overwrite_pvt.overwrite'
1967: ,p_token_2 => 'ERROR'
1968: ,p_value_2 => 'unhandled exception');
1969: END overwrite;
1970:
2101: xla_aad_loader_util_pvt.stack_error
2102: (p_appli_s_name => 'XLA'
2103: ,p_msg_name => 'XLA_COMMON_ERROR'
2104: ,p_token_1 => 'LOCATION'
2105: ,p_value_1 => 'xla_aad_overwrite_pvt.overwrite'
2106: ,p_token_2 => 'ERROR'
2107: ,p_value_2 => 'unhandled exception');
2108: END overwrite;
2109:
2122: IF NOT g_log_enabled THEN
2123: g_log_level := C_LEVEL_LOG_DISABLED;
2124: END IF;
2125:
2126: END xla_aad_overwrite_pvt;