[Home] [Help]
1: PACKAGE BODY xla_ae_code_combination_pkg AS
2: /* $Header: xlajecci.pkb 120.74.12020000.2 2012/07/23 13:32:46 vgopiset ship $ */
3: /*===========================================================================+
4: | Copyright (c) 2001-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |
5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +============================================================================+
8: | PACKAGE NAME |
9: | xla_ae_code_combination_pkg |
10: | |
11: | DESCRIPTION |
12: | |
13: | |
204: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
205: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
206:
207: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
208: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_ae_code_combination_pkg';
209:
210: g_log_level NUMBER;
211: g_log_enabled BOOLEAN;
212:
225: WHEN xla_exceptions_pkg.application_exception THEN
226: RAISE;
227: WHEN OTHERS THEN
228: xla_exceptions_pkg.raise_message
229: (p_location => 'xla_ae_code_combination_pkg.trace');
230: END trace;
231:
232: /*======================================================================+
233: | |
292: WHEN xla_exceptions_pkg.application_exception THEN
293: RAISE;
294: WHEN OTHERS THEN
295: xla_exceptions_pkg.raise_message
296: (p_location => 'xla_ae_code_combination_pkg.dump_text');
297: END dump_text;
298:
299: --
300: --====================================================================
529: WHEN xla_exceptions_pkg.application_exception THEN
530: RETURN TO_CHAR(p_flex_application_id);
531: WHEN OTHERS THEN
532: xla_exceptions_pkg.raise_message
533: (p_location => 'xla_ae_code_combination_pkg.get_application_name');
534: END get_application_name;
535:
536: /*---------------------------------------------------------------+
537: | |
574: WHEN xla_exceptions_pkg.application_exception THEN
575: RETURN NULL;
576: WHEN OTHERS THEN
577: xla_exceptions_pkg.raise_message
578: (p_location => 'xla_ae_code_combination_pkg.get_flex_structure_name');
579: END get_flex_structure_name;
580:
581: /*---------------------------------------------------------------+
582: | |
734: WHEN xla_exceptions_pkg.application_exception THEN
735: RAISE;
736: WHEN OTHERS THEN
737: xla_exceptions_pkg.raise_message
738: (p_location => 'xla_ae_code_combination_pkg.cache_flex_qualifier');
739: END cache_flex_qualifier;
740:
741: /*------------------------------------------------------------------+
742: | |
808: WHEN xla_exceptions_pkg.application_exception THEN
809: RAISE;
810: WHEN OTHERS THEN
811: xla_exceptions_pkg.raise_message
812: (p_location => 'xla_ae_code_combination_pkg.cache_flex_segment');
813: END cache_flex_segment;
814:
815: /*------------------------------------------------------------------+
816: | |
911: WHEN xla_exceptions_pkg.application_exception THEN
912: RAISE;
913: WHEN OTHERS THEN
914: xla_exceptions_pkg.raise_message
915: (p_location => 'xla_ae_code_combination_pkg.cache_key_flexfield');
916: END cache_key_flexfield;
917:
918: /*---------------------------------------------------------+
919: | |
967: WHEN xla_exceptions_pkg.application_exception THEN
968: RAISE;
969: WHEN OTHERS THEN
970: xla_exceptions_pkg.raise_message
971: (p_location => 'xla_ae_code_combination_pkg.cache_coa');
972: END cache_coa;
973:
974: /*---------------------------------------------------------+
975: | |
1021: WHEN xla_exceptions_pkg.application_exception THEN
1022: RAISE;
1023: WHEN OTHERS THEN
1024: xla_exceptions_pkg.raise_message
1025: (p_location => 'xla_ae_code_combination_pkg.cache_coa');
1026: END cache_coa;
1027:
1028: /*---------------------------------------------------------+
1029: | |
1282: WHEN xla_exceptions_pkg.application_exception THEN
1283: RAISE;
1284: WHEN OTHERS THEN
1285: xla_exceptions_pkg.raise_message
1286: (p_location => 'xla_ae_code_combination_pkg.init_SegmentArray');
1287: END init_SegmentArray;
1288:
1289: /*---------------------------------------------------+
1290: | |
1581: WHEN xla_exceptions_pkg.application_exception THEN
1582: RAISE;
1583: WHEN OTHERS THEN
1584: xla_exceptions_pkg.raise_message
1585: (p_location => 'xla_ae_code_combination_pkg.cache_combination_id');
1586: END cache_combination_id;
1587:
1588: /*-----------------------------------------------------+
1589: | |
1693: WHEN xla_exceptions_pkg.application_exception THEN
1694: RAISE;
1695: WHEN OTHERS THEN
1696: xla_exceptions_pkg.raise_message
1697: (p_location => 'xla_ae_code_combination_pkg.get_account_value');
1698: END get_account_value;
1699:
1700: --======================================================================
1701: --
1890: WHEN xla_exceptions_pkg.application_exception THEN
1891: RAISE;
1892: WHEN OTHERS THEN
1893: xla_exceptions_pkg.raise_message
1894: (p_location => 'xla_ae_code_combination_pkg.get_segment_code');
1895: END get_segment_code;
1896:
1897:
1898: /*-------------------------------------------------------------+
2274: WHEN xla_exceptions_pkg.application_exception THEN
2275: RETURN NULL;
2276: WHEN OTHERS THEN
2277: xla_exceptions_pkg.raise_message
2278: (p_location => 'xla_ae_code_combination_pkg.get_flex_segment_value');
2279: END get_flex_segment_value;
2280:
2281: /*-------------------------------------------------------------+
2282: | |
2461: ,p_level => C_LEVEL_PROCEDURE
2462: ,p_module => l_log_module);
2463: END IF;
2464: xla_exceptions_pkg.raise_message
2465: (p_location => 'xla_ae_code_combination_pkg.get_flex_segment_desc');
2466: END get_flex_segment_desc;
2467:
2468:
2469: --======================================================================
2640: ,p_level => C_LEVEL_PROCEDURE
2641: ,p_module => l_log_module);
2642: END IF;
2643: xla_exceptions_pkg.raise_message
2644: (p_location => 'xla_ae_code_combination_pkg.build_events_message');
2645: END build_events_message;
2646:
2647: /*-------------------------------------------------------------+
2648: | |
2872: ,p_level => C_LEVEL_PROCEDURE
2873: ,p_module => l_log_module);
2874: END IF;
2875: xla_exceptions_pkg.raise_message
2876: (p_location => 'xla_ae_code_combination_pkg.get_ccid_errors');
2877: END get_ccid_errors;
2878:
2879: /*-------------------------------------------------------------+
2880: | |
3104: ,p_level => C_LEVEL_PROCEDURE
3105: ,p_module => l_log_module);
3106: END IF;
3107: xla_exceptions_pkg.raise_message
3108: (p_location => 'xla_ae_code_combination_pkg.GetCcid');
3109: END GetCcid;
3110:
3111: /*------------------------------------------------------------------+
3112: | |
3309: ,p_level => C_LEVEL_PROCEDURE
3310: ,p_module => l_log_module);
3311: END IF;
3312: xla_exceptions_pkg.raise_message
3313: (p_location => 'xla_ae_code_combination_pkg.validate_source_ccid');
3314: END validate_source_ccid;
3315:
3316: /*------------------------------------------------------------------+
3317: | |
3554: ,p_level => C_LEVEL_PROCEDURE
3555: ,p_module => l_log_module);
3556: END IF;
3557: xla_exceptions_pkg.raise_message
3558: (p_location => 'xla_ae_code_combination_pkg.override_ccid');
3559: END override_ccid;
3560:
3561: /*-----------------------------------------------------------------------+
3562: | |
3875: ,p_level => C_LEVEL_PROCEDURE
3876: ,p_module => l_log_module);
3877: END IF;
3878: xla_exceptions_pkg.raise_message
3879: (p_location => 'xla_ae_code_combination_pkg.create_ccid');
3880: END create_ccid;
3881:
3882: /*---------------------------------------------------------------+
3883: | |
3919: SET code_combination_id =
3920: CASE
3921: WHEN temp.code_combination_id IS NULL
3922: AND temp.balance_type_code <> 'X'
3923: THEN xla_ae_code_combination_pkg.GetCcid(
3924: temp.segment1
3925: ,temp.segment2
3926: ,temp.segment3
3927: ,temp.segment4
3969: WHEN temp.alt_code_combination_id IS NULL
3970: AND temp.balance_type_code <> 'X'
3971: AND temp.gain_or_loss_flag = 'Y'
3972: AND temp.CALCULATE_G_L_AMTS_FLAG = 'Y' --added for bug11727459
3973: THEN xla_ae_code_combination_pkg.GetCcid(
3974: temp.alt_segment1
3975: ,temp.alt_segment2
3976: ,temp.alt_segment3
3977: ,temp.alt_segment4
4070: ,p_level => C_LEVEL_PROCEDURE
4071: ,p_module => l_log_module);
4072: END IF;
4073: xla_exceptions_pkg.raise_message
4074: (p_location => 'xla_ae_code_combination_pkg.create_new_ccid');
4075: END create_new_ccid;
4076:
4077: /*---------------------------------------------------------------+
4078: | |
5031: ,p_level => C_LEVEL_PROCEDURE
5032: ,p_module => l_log_module);
5033: END IF;
5034: xla_exceptions_pkg.raise_message
5035: (p_location => 'xla_ae_code_combination_pkg.map_ccid');
5036: --
5037: END map_ccid;
5038:
5039:
5522: ,p_level => C_LEVEL_PROCEDURE
5523: ,p_module => l_log_module);
5524: END IF;
5525: xla_exceptions_pkg.raise_message
5526: (p_location => 'xla_ae_code_combination_pkg.map_segment_qualifier');
5527: END map_segment_qualifier;
5528:
5529: /*-----------------------------------------------------------------------+
5530: | |
5596: WHEN xla_exceptions_pkg.application_exception THEN
5597: RAISE;
5598: WHEN OTHERS THEN
5599: xla_exceptions_pkg.raise_message
5600: (p_location => 'xla_ae_code_combination_pkg.map_transaction_accounts');
5601: --
5602: END map_transaction_accounts;
5603:
5604: /*-----------------------------------------------------------------------+
5731: ,p_level => C_LEVEL_PROCEDURE
5732: ,p_module => l_log_module);
5733: END IF;
5734: xla_exceptions_pkg.raise_message
5735: (p_location => 'xla_ae_code_combination_pkg.BuildCcids');
5736: END BuildCcids;
5737: --
5738: --=============================================================================
5739: --
5772:
5773: IF NOT g_log_enabled THEN
5774: g_log_level := C_LEVEL_LOG_DISABLED;
5775: END IF;
5776: END xla_ae_code_combination_pkg; --