75: --
76:
77: g_chr_newline CONSTANT VARCHAR2(1) := xla_environment_pkg.g_chr_newline;
78:
79: G_STANDARD_MESSAGE CONSTANT VARCHAR2(1) := xla_exceptions_pkg.C_STANDARD_MESSAGE;
80: G_OA_MESSAGE CONSTANT VARCHAR2(1) := xla_exceptions_pkg.C_OA_MESSAGE;
81:
82: --Set the message mode to use the message stack instead of raising an exception
83: g_msg_mode CONSTANT VARCHAR2(1) := G_OA_MESSAGE;
76:
77: g_chr_newline CONSTANT VARCHAR2(1) := xla_environment_pkg.g_chr_newline;
78:
79: G_STANDARD_MESSAGE CONSTANT VARCHAR2(1) := xla_exceptions_pkg.C_STANDARD_MESSAGE;
80: G_OA_MESSAGE CONSTANT VARCHAR2(1) := xla_exceptions_pkg.C_OA_MESSAGE;
81:
82: --Set the message mode to use the message stack instead of raising an exception
83: g_msg_mode CONSTANT VARCHAR2(1) := G_OA_MESSAGE;
84:
1350: fnd_log.string(p_level, p_module, p_msg);
1351: END IF;
1352:
1353: EXCEPTION
1354: WHEN xla_exceptions_pkg.application_exception THEN
1355: RAISE;
1356: WHEN OTHERS THEN
1357: xla_exceptions_pkg.raise_message
1358: (p_location => 'xla_cmp_tab_pkg.trace');
1353: EXCEPTION
1354: WHEN xla_exceptions_pkg.application_exception THEN
1355: RAISE;
1356: WHEN OTHERS THEN
1357: xla_exceptions_pkg.raise_message
1358: (p_location => 'xla_cmp_tab_pkg.trace');
1359: END trace;
1360:
1361:
1542: ,p_level => C_LEVEL_PROCEDURE);
1543: END IF;
1544:
1545: EXCEPTION
1546: WHEN xla_exceptions_pkg.application_exception
1547: THEN
1548: RAISE;
1549: WHEN OTHERS
1550: THEN
1547: THEN
1548: RAISE;
1549: WHEN OTHERS
1550: THEN
1551: xla_exceptions_pkg.raise_message
1552: (p_location => 'xla_cmp_tab_pkg.compile_api_srs');
1553:
1554: END compile_api_srs;
1555:
1703: ,p_level => C_LEVEL_EXCEPTION);
1704: END IF;
1705: --Push a message in the message stack
1706: --without raising an exception
1707: xla_exceptions_pkg.raise_message
1708: ( p_appli_s_name => 'XLA'
1709: ,p_msg_name => 'XLA_TAB_CMP_TAB_API_FAILED'
1710: ,p_token_1 => 'APPLICATION_NAME'
1711: ,p_value_1 => g_application_info.application_name
1718: ,p_msg => 'END ' || C_DEFAULT_MODULE||'.compile_api'
1719: ,p_level => C_LEVEL_PROCEDURE);
1720: END IF;
1721: RETURN FALSE;
1722: WHEN xla_exceptions_pkg.application_exception
1723: THEN
1724: RAISE;
1725: WHEN OTHERS
1726: THEN
1723: THEN
1724: RAISE;
1725: WHEN OTHERS
1726: THEN
1727: xla_exceptions_pkg.raise_message
1728: (p_location => 'xla_cmp_tab_pkg.compile_api');
1729: END compile_api;
1730:
1731:
1866: ,p_msg => 'END ' || C_DEFAULT_MODULE||'.init_global_variables'
1867: ,p_level => C_LEVEL_PROCEDURE);
1868: END IF;
1869: RETURN FALSE;
1870: WHEN xla_exceptions_pkg.application_exception
1871: THEN
1872: RAISE;
1873: WHEN OTHERS
1874: THEN
1871: THEN
1872: RAISE;
1873: WHEN OTHERS
1874: THEN
1875: xla_exceptions_pkg.raise_message
1876: (p_location => 'xla_cmp_tab_pkg.init_global_variables');
1877:
1878: END init_global_variables;
1879:
1953:
1954: RETURN l_return_value;
1955:
1956: EXCEPTION
1957: WHEN xla_exceptions_pkg.application_exception
1958: THEN
1959: RAISE;
1960: WHEN OTHERS
1961: THEN
1958: THEN
1959: RAISE;
1960: WHEN OTHERS
1961: THEN
1962: xla_exceptions_pkg.raise_message
1963: (p_location => 'xla_cmp_tab_pkg.create_package_spec');
1964:
1965: END create_package_spec;
1966:
2136:
2137: RETURN l_return_value;
2138:
2139: EXCEPTION
2140: WHEN xla_exceptions_pkg.application_exception
2141: THEN
2142: RAISE;
2143: WHEN OTHERS
2144: THEN
2141: THEN
2142: RAISE;
2143: WHEN OTHERS
2144: THEN
2145: xla_exceptions_pkg.raise_message
2146: (p_location => 'xla_cmp_tab_pkg.build_package_spec');
2147:
2148: END build_package_spec;
2149:
2188: END IF;
2189:
2190: RETURN l_return_value;
2191: EXCEPTION
2192: WHEN xla_exceptions_pkg.application_exception
2193: THEN
2194: RAISE;
2195: WHEN OTHERS
2196: THEN
2193: THEN
2194: RAISE;
2195: WHEN OTHERS
2196: THEN
2197: xla_exceptions_pkg.raise_message
2198: (p_location => 'xla_cmp_tab_pkg.build_package_history');
2199:
2200: END build_package_history;
2201:
2572: END IF;
2573:
2574: RETURN l_return_value;
2575: EXCEPTION
2576: WHEN xla_exceptions_pkg.application_exception
2577: THEN
2578: RAISE;
2579: WHEN OTHERS
2580: THEN
2577: THEN
2578: RAISE;
2579: WHEN OTHERS
2580: THEN
2581: xla_exceptions_pkg.raise_message
2582: (p_location => 'xla_cmp_tab_pkg.build_declarations');
2583:
2584: END build_declarations;
2585:
2658: END IF;
2659:
2660: RETURN l_return_value;
2661: EXCEPTION
2662: WHEN xla_exceptions_pkg.application_exception
2663: THEN
2664: RAISE;
2665: WHEN OTHERS
2666: THEN
2663: THEN
2664: RAISE;
2665: WHEN OTHERS
2666: THEN
2667: xla_exceptions_pkg.raise_message
2668: (p_location => 'xla_cmp_tab_pkg.create_package_body');
2669:
2670: END create_package_body;
2671:
2907:
2908: RETURN l_return_value;
2909:
2910: EXCEPTION
2911: WHEN xla_exceptions_pkg.application_exception
2912: THEN
2913: RAISE;
2914: WHEN OTHERS
2915: THEN
2912: THEN
2913: RAISE;
2914: WHEN OTHERS
2915: THEN
2916: xla_exceptions_pkg.raise_message
2917: (p_location => 'xla_cmp_tab_pkg.build_package_body');
2918:
2919: END build_package_body;
2920:
3247: END IF;
3248:
3249: RETURN l_return_value;
3250: EXCEPTION
3251: WHEN xla_exceptions_pkg.application_exception
3252: THEN
3253: RAISE;
3254: WHEN OTHERS
3255: THEN
3252: THEN
3253: RAISE;
3254: WHEN OTHERS
3255: THEN
3256: xla_exceptions_pkg.raise_message
3257: (p_location => 'xla_cmp_tab_pkg.build_implementations');
3258:
3259: END build_implementations;
3260:
3349: END IF;
3350:
3351: RETURN l_return_value;
3352: EXCEPTION
3353: WHEN xla_exceptions_pkg.application_exception
3354: THEN
3355: RAISE;
3356: WHEN OTHERS
3357: THEN
3354: THEN
3355: RAISE;
3356: WHEN OTHERS
3357: THEN
3358: xla_exceptions_pkg.raise_message
3359: (p_location => 'xla_cmp_tab_pkg.create_temp_tables');
3360:
3361: END create_temp_tables;
3362:
3451: END IF;
3452:
3453: RETURN l_return_value;
3454: EXCEPTION
3455: WHEN xla_exceptions_pkg.application_exception
3456: THEN
3457: RAISE;
3458: WHEN OTHERS
3459: THEN
3456: THEN
3457: RAISE;
3458: WHEN OTHERS
3459: THEN
3460: xla_exceptions_pkg.raise_message
3461: (p_location => 'xla_cmp_tab_pkg.get_interface_object_names');
3462:
3463: END get_interface_object_names;
3464:
3554: END IF;
3555:
3556: RETURN l_return_value;
3557: EXCEPTION
3558: WHEN xla_exceptions_pkg.application_exception
3559: THEN
3560: RAISE;
3561: WHEN OTHERS
3562: THEN
3559: THEN
3560: RAISE;
3561: WHEN OTHERS
3562: THEN
3563: xla_exceptions_pkg.raise_message
3564: (p_location => 'xla_cmp_tab_pkg.get_interface_object_names');
3565:
3566: END get_interface_object_names;
3567:
3682: ,p_msg => 'Fatal error'
3683: ,p_level => C_LEVEL_ERROR);
3684: END IF;
3685: RETURN FALSE;
3686: WHEN xla_exceptions_pkg.application_exception
3687: THEN
3688: RAISE;
3689: WHEN OTHERS
3690: THEN
3687: THEN
3688: RAISE;
3689: WHEN OTHERS
3690: THEN
3691: xla_exceptions_pkg.raise_message
3692: (p_location => 'xla_cmp_tab_pkg.get_interface_sources');
3693:
3694: END get_interface_sources;
3695:
3935: ,p_msg => 'END ' || l_log_module
3936: ,p_level => C_LEVEL_PROCEDURE);
3937: END IF;
3938: RETURN FALSE;
3939: WHEN xla_exceptions_pkg.application_exception
3940: THEN
3941: RAISE;
3942: WHEN OTHERS
3943: THEN
3940: THEN
3941: RAISE;
3942: WHEN OTHERS
3943: THEN
3944: xla_exceptions_pkg.raise_message
3945: (p_location => 'xla_cmp_tab_pkg.build_global_temp_table');
3946:
3947: END build_global_temp_table;
3948:
3998:
3999: RETURN TRUE;
4000:
4001: EXCEPTION
4002: WHEN xla_exceptions_pkg.application_exception
4003: THEN
4004: RAISE;
4005: WHEN OTHERS
4006: THEN
4003: THEN
4004: RAISE;
4005: WHEN OTHERS
4006: THEN
4007: xla_exceptions_pkg.raise_message
4008: (p_location => 'xla_cmp_tab_pkg.get_tab_api_package_name');
4009:
4010: END get_tab_api_package_name;
4011:
4086: END IF;
4087:
4088: RETURN l_return_value;
4089: EXCEPTION
4090: WHEN xla_exceptions_pkg.application_exception
4091: THEN
4092: RAISE;
4093: WHEN OTHERS
4094: THEN
4091: THEN
4092: RAISE;
4093: WHEN OTHERS
4094: THEN
4095: xla_exceptions_pkg.raise_message
4096: (p_location => 'xla_cmp_tab_pkg.get_tab_api_package_name');
4097:
4098: END get_tab_api_package_name;
4099:
4232: ,p_msg => 'END ' || l_log_module
4233: ,p_level => C_LEVEL_PROCEDURE);
4234: END IF;
4235: RETURN FALSE;
4236: WHEN xla_exceptions_pkg.application_exception
4237: THEN
4238: RAISE;
4239: WHEN OTHERS
4240: THEN
4237: THEN
4238: RAISE;
4239: WHEN OTHERS
4240: THEN
4241: xla_exceptions_pkg.raise_message
4242: (p_location => 'xla_cmp_tab_pkg.read_distinct_affixes');
4243:
4244: END read_distinct_affixes;
4245:
4293:
4294: RETURN l_return_value;
4295:
4296: EXCEPTION
4297: WHEN xla_exceptions_pkg.application_exception
4298: THEN
4299: RAISE;
4300: WHEN OTHERS
4301: THEN
4298: THEN
4299: RAISE;
4300: WHEN OTHERS
4301: THEN
4302: xla_exceptions_pkg.raise_message
4303: (p_location => 'xla_cmp_tab_pkg.remove_deleted_tats');
4304:
4305: END remove_deleted_tats;
4306:
4486: ,p_msg => 'END ' || l_log_module
4487: ,p_level => C_LEVEL_PROCEDURE);
4488: END IF;
4489: RETURN FALSE;
4490: WHEN xla_exceptions_pkg.application_exception
4491: THEN
4492: RAISE;
4493: WHEN OTHERS
4494: THEN
4491: THEN
4492: RAISE;
4493: WHEN OTHERS
4494: THEN
4495: xla_exceptions_pkg.raise_message
4496: (p_location => 'xla_cmp_tab_pkg.get_tab_api_info_for_tat');
4497: END;
4498:
4499: FUNCTION get_ccid_additional_info
4569: ,p_msg => 'END ' || l_log_module
4570: ,p_level => C_LEVEL_PROCEDURE);
4571: END IF;
4572: RETURN FALSE;
4573: WHEN xla_exceptions_pkg.application_exception
4574: THEN
4575: RAISE;
4576: WHEN OTHERS
4577: THEN
4574: THEN
4575: RAISE;
4576: WHEN OTHERS
4577: THEN
4578: xla_exceptions_pkg.raise_message
4579: (p_location => 'xla_cmp_tab_pkg.get_ccid_additional_info');
4580: END;
4581:
4582: