DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LOADER_UTIL_PVT

Line 1: PACKAGE BODY xla_aad_loader_util_pvt AS

1: PACKAGE BODY xla_aad_loader_util_pvt AS
2: /* $Header: xlaalutl.pkb 120.16 2008/07/21 15:34:47 krsankar ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************

Line 35: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_loader_util_pvt';

31: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
32: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
33:
34: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
35: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_loader_util_pvt';
36:
37: g_log_level NUMBER;
38: g_log_enabled BOOLEAN;
39:

Line 59: (p_location => 'xla_aad_loader_util_pvt.trace');

55: RAISE;
56:
57: WHEN OTHERS THEN
58: xla_exceptions_pkg.raise_message
59: (p_location => 'xla_aad_loader_util_pvt.trace');
60: END trace;
61:
62:
63: --=============================================================================

Line 161: xla_aad_loader_util_pvt.stack_error

157: END IF;
158: return l_code;
159: EXCEPTION
160: WHEN OTHERS THEN
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_loader_util_pvt.create_staging_context_code'

Line 165: ,p_value_1 => 'xla_aad_loader_util_pvt.create_staging_context_code'

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_loader_util_pvt.create_staging_context_code'
166: ,p_token_2 => 'ERROR'
167: ,p_value_2 => 'unhandled exception');
168: RAISE;
169:

Line 533: xla_aad_loader_util_pvt.stack_error

529: p_level => C_LEVEL_PROCEDURE);
530: END IF;
531: EXCEPTION
532: WHEN OTHERS THEN
533: xla_aad_loader_util_pvt.stack_error
534: (p_appli_s_name => 'XLA'
535: ,p_msg_name => 'XLA_COMMON_ERROR'
536: ,p_token_1 => 'LOCATION'
537: ,p_value_1 => 'xla_aad_loader_util_pvt.purge'

Line 537: ,p_value_1 => 'xla_aad_loader_util_pvt.purge'

533: xla_aad_loader_util_pvt.stack_error
534: (p_appli_s_name => 'XLA'
535: ,p_msg_name => 'XLA_COMMON_ERROR'
536: ,p_token_1 => 'LOCATION'
537: ,p_value_1 => 'xla_aad_loader_util_pvt.purge'
538: ,p_token_2 => 'ERROR'
539: ,p_value_2 => 'unhandled exception');
540: RAISE;
541:

Line 1248: xla_aad_loader_util_pvt.stack_error

1244: END IF;
1245: return l_staging_amb_context_code;
1246: EXCEPTION
1247: WHEN OTHERS THEN
1248: xla_aad_loader_util_pvt.stack_error
1249: (p_appli_s_name => 'XLA'
1250: ,p_msg_name => 'XLA_COMMON_ERROR'
1251: ,p_token_1 => 'LOCATION'
1252: ,p_value_1 => 'xla_aad_loader_util_pvt.get_staging_context_code'

Line 1252: ,p_value_1 => 'xla_aad_loader_util_pvt.get_staging_context_code'

1248: xla_aad_loader_util_pvt.stack_error
1249: (p_appli_s_name => 'XLA'
1250: ,p_msg_name => 'XLA_COMMON_ERROR'
1251: ,p_token_1 => 'LOCATION'
1252: ,p_value_1 => 'xla_aad_loader_util_pvt.get_staging_context_code'
1253: ,p_token_2 => 'ERROR'
1254: ,p_value_2 => 'unhandled exception');
1255: RAISE;
1256:

Line 1482: xla_aad_loader_util_pvt.stack_error

1478: END IF;
1479:
1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: xla_aad_loader_util_pvt.stack_error
1483: (p_appli_s_name => 'XLA'
1484: ,p_msg_name => 'XLA_COMMON_ERROR'
1485: ,p_token_1 => 'LOCATION'
1486: ,p_value_1 => 'xla_aad_loader_util_pvt.merge_history'

Line 1486: ,p_value_1 => 'xla_aad_loader_util_pvt.merge_history'

1482: xla_aad_loader_util_pvt.stack_error
1483: (p_appli_s_name => 'XLA'
1484: ,p_msg_name => 'XLA_COMMON_ERROR'
1485: ,p_token_1 => 'LOCATION'
1486: ,p_value_1 => 'xla_aad_loader_util_pvt.merge_history'
1487: ,p_token_2 => 'ERROR'
1488: ,p_value_2 => 'unhandled exception');
1489: RAISE;
1490:

Line 1541: xla_aad_loader_util_pvt.stack_error

1537: RETURN l_ret_segment;
1538:
1539: EXCEPTION
1540: WHEN OTHERS THEN
1541: xla_aad_loader_util_pvt.stack_error
1542: (p_appli_s_name => 'XLA'
1543: ,p_msg_name => 'XLA_COMMON_ERROR'
1544: ,p_token_1 => 'LOCATION'
1545: ,p_value_1 => 'xla_aad_loader_util_pvt.get_segment'

Line 1545: ,p_value_1 => 'xla_aad_loader_util_pvt.get_segment'

1541: xla_aad_loader_util_pvt.stack_error
1542: (p_appli_s_name => 'XLA'
1543: ,p_msg_name => 'XLA_COMMON_ERROR'
1544: ,p_token_1 => 'LOCATION'
1545: ,p_value_1 => 'xla_aad_loader_util_pvt.get_segment'
1546: ,p_token_2 => 'ERROR'
1547: ,p_value_2 => 'unhandled exception');
1548: RAISE;
1549:

Line 1605: xla_aad_loader_util_pvt.stack_error

1601: p_level => C_LEVEL_PROCEDURE);
1602: END IF;
1603: EXCEPTION
1604: WHEN OTHERS THEN
1605: xla_aad_loader_util_pvt.stack_error
1606: (p_appli_s_name => 'XLA'
1607: ,p_msg_name => 'XLA_COMMON_ERROR'
1608: ,p_token_1 => 'LOCATION'
1609: ,p_value_1 => 'xla_aad_loader_util_pvt.reset_errors'

Line 1609: ,p_value_1 => 'xla_aad_loader_util_pvt.reset_errors'

1605: xla_aad_loader_util_pvt.stack_error
1606: (p_appli_s_name => 'XLA'
1607: ,p_msg_name => 'XLA_COMMON_ERROR'
1608: ,p_token_1 => 'LOCATION'
1609: ,p_value_1 => 'xla_aad_loader_util_pvt.reset_errors'
1610: ,p_token_2 => 'ERROR'
1611: ,p_value_2 => 'unhandled exception');
1612: RAISE;
1613:

Line 1874: (p_location => 'xla_aad_loader_util_pvt.stack_error');

1870: RAISE;
1871:
1872: WHEN OTHERS THEN
1873: xla_exceptions_pkg.raise_message
1874: (p_location => 'xla_aad_loader_util_pvt.stack_error');
1875:
1876: END stack_error;
1877:
1878: --=============================================================================

Line 1952: xla_aad_loader_util_pvt.stack_error

1948: ,p_level => C_LEVEL_PROCEDURE);
1949: END IF;
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952: xla_aad_loader_util_pvt.stack_error
1953: (p_appli_s_name => 'XLA'
1954: ,p_msg_name => 'XLA_COMMON_ERROR'
1955: ,p_token_1 => 'LOCATION'
1956: ,p_value_1 => 'xla_aad_loader_util_pvt.insert_errors'

Line 1956: ,p_value_1 => 'xla_aad_loader_util_pvt.insert_errors'

1952: xla_aad_loader_util_pvt.stack_error
1953: (p_appli_s_name => 'XLA'
1954: ,p_msg_name => 'XLA_COMMON_ERROR'
1955: ,p_token_1 => 'LOCATION'
1956: ,p_value_1 => 'xla_aad_loader_util_pvt.insert_errors'
1957: ,p_token_2 => 'ERROR'
1958: ,p_value_2 => 'unhandled exception');
1959: RAISE;
1960:

Line 2012: xla_aad_loader_util_pvt.stack_error

2008: ,p_module => l_log_module);
2009: END IF;
2010:
2011: l_retcode := 'ERROR';
2012: xla_aad_loader_util_pvt.stack_error
2013: (p_appli_s_name => 'XLA'
2014: ,p_msg_name => 'XLA_COMMON_ERROR'
2015: ,p_token_1 => 'LOCATION'
2016: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

Line 2016: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

2012: xla_aad_loader_util_pvt.stack_error
2013: (p_appli_s_name => 'XLA'
2014: ,p_msg_name => 'XLA_COMMON_ERROR'
2015: ,p_token_1 => 'LOCATION'
2016: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'
2017: ,p_token_2 => 'ERROR'
2018: ,p_value_2 =>
2019: 'Technical problem : FND_CONCURRENT.WAIT_FOR_REQUEST returned FALSE');
2020: ELSE

Line 2047: xla_aad_loader_util_pvt.stack_error

2043: END IF;
2044: return l_retcode;
2045: EXCEPTION
2046: WHEN OTHERS THEN
2047: xla_aad_loader_util_pvt.stack_error
2048: (p_appli_s_name => 'XLA'
2049: ,p_msg_name => 'XLA_COMMON_ERROR'
2050: ,p_token_1 => 'LOCATION'
2051: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

Line 2051: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'

2047: xla_aad_loader_util_pvt.stack_error
2048: (p_appli_s_name => 'XLA'
2049: ,p_msg_name => 'XLA_COMMON_ERROR'
2050: ,p_token_1 => 'LOCATION'
2051: ,p_value_1 => 'xla_aad_loader_util_pvt.wait_for_request'
2052: ,p_token_2 => 'ERROR'
2053: ,p_value_2 => 'unhandled exception');
2054: RAISE;
2055:

Line 2104: xla_aad_loader_util_pvt.stack_error

2100:
2101: RETURN l_req_id;
2102: EXCEPTION
2103: WHEN OTHERS THEN
2104: xla_aad_loader_util_pvt.stack_error
2105: (p_appli_s_name => 'XLA'
2106: ,p_msg_name => 'XLA_COMMON_ERROR'
2107: ,p_token_1 => 'LOCATION'
2108: ,p_value_1 => 'xla_aad_loader_util_pvt.submit_compile_report_request'

Line 2108: ,p_value_1 => 'xla_aad_loader_util_pvt.submit_compile_report_request'

2104: xla_aad_loader_util_pvt.stack_error
2105: (p_appli_s_name => 'XLA'
2106: ,p_msg_name => 'XLA_COMMON_ERROR'
2107: ,p_token_1 => 'LOCATION'
2108: ,p_value_1 => 'xla_aad_loader_util_pvt.submit_compile_report_request'
2109: ,p_token_2 => 'ERROR'
2110: ,p_value_2 => 'unhandled exception');
2111: RAISE;
2112:

Line 2149: xla_aad_loader_util_pvt.stack_error

2145: (p_application_id => p_application_id);
2146:
2147: IF (l_req_id = 0) THEN
2148: l_retcode := FALSE;
2149: xla_aad_loader_util_pvt.stack_error
2150: (p_appli_s_name => 'XLA'
2151: ,p_msg_name => 'XLA_COMMON_ERROR'
2152: ,p_token_1 => 'LOCATION'
2153: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

Line 2153: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

2149: xla_aad_loader_util_pvt.stack_error
2150: (p_appli_s_name => 'XLA'
2151: ,p_msg_name => 'XLA_COMMON_ERROR'
2152: ,p_token_1 => 'LOCATION'
2153: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'
2154: ,p_token_2 => 'ERROR'
2155: ,p_value_2 => 'Unable to submit compilation report request');
2156: END IF;
2157:

Line 2169: xla_aad_loader_util_pvt.stack_error

2165: RETURN l_retcode;
2166: EXCEPTION
2167:
2168: WHEN OTHERS THEN
2169: xla_aad_loader_util_pvt.stack_error
2170: (p_appli_s_name => 'XLA'
2171: ,p_msg_name => 'XLA_COMMON_ERROR'
2172: ,p_token_1 => 'LOCATION'
2173: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

Line 2173: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'

2169: xla_aad_loader_util_pvt.stack_error
2170: (p_appli_s_name => 'XLA'
2171: ,p_msg_name => 'XLA_COMMON_ERROR'
2172: ,p_token_1 => 'LOCATION'
2173: ,p_value_1 => 'xla_aad_loader_util_pvt.compile'
2174: ,p_token_2 => 'ERROR'
2175: ,p_value_2 => 'unhandled exception');
2176: RAISE;
2177:

Line 2218: xla_aad_loader_util_pvt.stack_error

2214: ,p_pkg_name => p_pkg_name)) THEN
2215:
2216: l_error_text := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE);
2217:
2218: xla_aad_loader_util_pvt.stack_error
2219: (p_appli_s_name => 'XLA'
2220: ,p_msg_name => 'XLA_COMMON_ERROR'
2221: ,p_token_1 => 'LOCATION'
2222: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

Line 2222: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

2218: xla_aad_loader_util_pvt.stack_error
2219: (p_appli_s_name => 'XLA'
2220: ,p_msg_name => 'XLA_COMMON_ERROR'
2221: ,p_token_1 => 'LOCATION'
2222: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'
2223: ,p_token_2 => 'ERROR'
2224: ,p_value_2 => l_error_text);
2225:
2226: l_retcode := FALSE;

Line 2237: xla_aad_loader_util_pvt.stack_error

2233: END IF;
2234: RETURN l_retcode;
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: xla_aad_loader_util_pvt.stack_error
2238: (p_appli_s_name => 'XLA'
2239: ,p_msg_name => 'XLA_COMMON_ERROR'
2240: ,p_token_1 => 'LOCATION'
2241: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

Line 2241: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'

2237: xla_aad_loader_util_pvt.stack_error
2238: (p_appli_s_name => 'XLA'
2239: ,p_msg_name => 'XLA_COMMON_ERROR'
2240: ,p_token_1 => 'LOCATION'
2241: ,p_value_1 => 'xla_aad_loader_util_pvt.compatible_api_call'
2242: ,p_token_2 => 'ERROR'
2243: ,p_value_2 => 'unhandled exception');
2244: RAISE;
2245:

Line 2281: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

2277: p_level => C_LEVEL_PROCEDURE);
2278: END IF;
2279:
2280: -- Standard call to check for call compatibility.
2281: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
2282: (p_current_version_number => l_api_version
2283: ,p_caller_version_number => p_api_version
2284: ,p_api_name => l_api_name
2285: ,p_pkg_name => C_DEFAULT_MODULE))

Line 2403: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

2399: ', p_amb_context_code = '||p_amb_context_code,
2400: p_module => l_log_module,
2401: p_level => C_LEVEL_PROCEDURE);
2402: END IF;
2403: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
2404: (p_current_version_number => l_api_version
2405: ,p_caller_version_number => p_api_version
2406: ,p_api_name => l_api_name
2407: ,p_pkg_name => C_DEFAULT_MODULE))

Line 2888: xla_aad_loader_util_pvt.stack_error

2884: WHEN OTHERS THEN
2885: ROLLBACK;
2886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2887:
2888: xla_aad_loader_util_pvt.stack_error
2889: (p_appli_s_name => 'XLA'
2890: ,p_msg_name => 'XLA_COMMON_ERROR'
2891: ,p_token_1 => 'LOCATION'
2892: ,p_value_1 => 'xla_aad_util_pvt.purge_aad'

Line 2946: xla_aad_loader_util_pvt.stack_error

2942: END IF;
2943: EXCEPTION
2944:
2945: WHEN OTHERS THEN
2946: xla_aad_loader_util_pvt.stack_error
2947: (p_appli_s_name => 'XLA'
2948: ,p_msg_name => 'XLA_COMMON_ERROR'
2949: ,p_token_1 => 'LOCATION'
2950: ,p_value_1 => 'xla_aad_util_pvt.rebuild_ac_views'

Line 3055: xla_aad_loader_util_pvt.stack_error

3051: p_level => C_LEVEL_PROCEDURE);
3052: END IF;
3053:
3054: l_retcode := 'ERROR';
3055: xla_aad_loader_util_pvt.stack_error
3056: (p_appli_s_name => 'XLA'
3057: ,p_msg_name => 'XLA_AAD_INCOMPATIBLE_ADR_VERS'
3058: ,p_token_1 => 'APP_NAME'
3059: ,p_value_1 => l_err.application_name

Line 3085: xla_aad_loader_util_pvt.stack_error

3081: return l_retcode;
3082: EXCEPTION
3083:
3084: WHEN OTHERS THEN
3085: xla_aad_loader_util_pvt.stack_error
3086: (p_appli_s_name => 'XLA'
3087: ,p_msg_name => 'XLA_COMMON_ERROR'
3088: ,p_token_1 => 'LOCATION'
3089: ,p_value_1 => 'xla_aad_util_pvt.validate_adr_compatibility'

Line 3123: IF (NOT xla_aad_loader_util_pvt.compatible_api_call

3119: p_module => l_log_module,
3120: p_level => C_LEVEL_PROCEDURE);
3121: END IF;
3122:
3123: IF (NOT xla_aad_loader_util_pvt.compatible_api_call
3124: (p_current_version_number => l_api_version
3125: ,p_caller_version_number => p_api_version
3126: ,p_api_name => l_api_name
3127: ,p_pkg_name => C_DEFAULT_MODULE))

Line 3197: END xla_aad_loader_util_pvt;

3193: IF NOT g_log_enabled THEN
3194: g_log_level := C_LEVEL_LOG_DISABLED;
3195: END IF;
3196:
3197: END xla_aad_loader_util_pvt;