221: fnd_log.string(p_level, p_module, p_msg);
222: END IF;
223:
224: EXCEPTION
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');
224: EXCEPTION
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: /*======================================================================+
288: END LOOP;
289: END IF;
290:
291: EXCEPTION
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');
291: EXCEPTION
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: --
525: RETURN l_name;
526: EXCEPTION
527: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
528: RETURN TO_CHAR(p_flex_application_id);
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');
528: RETURN TO_CHAR(p_flex_application_id);
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: /*---------------------------------------------------------------+
570: RETURN l_name;
571: EXCEPTION
572: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
573: RETURN NULL;
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');
573: RETURN NULL;
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: /*---------------------------------------------------------------+
653: reset_flexfield_cache;
654: g_array_appl_short_name:= g_array_appl_short_null ;
655: --
656: EXCEPTION
657: WHEN xla_exceptions_pkg.application_exception THEN
658: RAISE;
659: WHEN OTHERS THEN
660: xla_exceptions_pkg.raise_message
661: (p_location => 'xla_ae_journal_entry_pkg.refreshCcidCache');
656: EXCEPTION
657: WHEN xla_exceptions_pkg.application_exception THEN
658: RAISE;
659: WHEN OTHERS THEN
660: xla_exceptions_pkg.raise_message
661: (p_location => 'xla_ae_journal_entry_pkg.refreshCcidCache');
662: END refreshCcidCache;
663:
664: /*------------------------------------------------------------------+
730: ,p_module => l_log_module);
731:
732: END IF;
733: EXCEPTION
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');
733: EXCEPTION
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: /*------------------------------------------------------------------+
804: ,p_level => C_LEVEL_PROCEDURE
805: ,p_module => l_log_module);
806: END IF;
807: EXCEPTION
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');
807: EXCEPTION
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: /*------------------------------------------------------------------+
907: ,p_module => l_log_module);
908: END IF;
909: p_id_flex_num := l_id_flex_num;
910: EXCEPTION
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');
910: EXCEPTION
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: /*---------------------------------------------------------+
963: ,p_module => l_log_module);
964:
965: END IF;
966: EXCEPTION
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');
966: EXCEPTION
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: /*---------------------------------------------------------+
1017: ,p_level => C_LEVEL_PROCEDURE
1018: ,p_module => l_log_module);
1019: END IF;
1020: EXCEPTION
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');
1020: EXCEPTION
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: /*---------------------------------------------------------+
1278:
1279: END IF;
1280: RETURN l_SegmentArray;
1281: EXCEPTION
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');
1281: EXCEPTION
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: /*---------------------------------------------------+
1577: (p_msg => 'ERROR: XLA_AP_INVALID_AOL_CCID'
1578: ,p_level => C_LEVEL_ERROR
1579: ,p_module => l_log_module);
1580: END IF;
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');
1580: END IF;
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: /*-----------------------------------------------------+
1689: ,p_module => l_log_module);
1690: END IF;
1691: RETURN l_ConcatKey;
1692: EXCEPTION
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');
1692: EXCEPTION
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: --======================================================================
1886: ,p_level => C_LEVEL_ERROR
1887: ,p_module => l_log_module);
1888: END IF;
1889: RETURN NULL;
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');
1889: RETURN NULL;
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:
2270: ,p_level => C_LEVEL_ERROR
2271: ,p_module => l_log_module);
2272: END IF;
2273: RETURN NULL;
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');
2273: RETURN NULL;
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: /*-------------------------------------------------------------+
2445: ,p_module => l_log_module);
2446: END IF;
2447: RETURN l_segment_description;
2448: EXCEPTION
2449: WHEN xla_exceptions_pkg.application_exception THEN
2450: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
2451: trace
2452: (p_msg => 'Error. = '||sqlerrm
2453: ,p_level => C_LEVEL_PROCEDURE
2460: (p_msg => 'Error. = '||sqlerrm
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:
2624: ,p_module => l_log_module);
2625: END IF;
2626: --
2627: EXCEPTION
2628: WHEN xla_exceptions_pkg.application_exception THEN
2629: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
2630: trace
2631: (p_msg => 'Error. = '||sqlerrm
2632: ,p_level => C_LEVEL_PROCEDURE
2639: (p_msg => 'Error. = '||sqlerrm
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: /*-------------------------------------------------------------+
2856: ,p_level => C_LEVEL_PROCEDURE
2857: ,p_module => l_log_module);
2858: END IF;
2859: EXCEPTION
2860: WHEN xla_exceptions_pkg.application_exception THEN
2861: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
2862: trace
2863: (p_msg => 'Error. = '||sqlerrm
2864: ,p_level => C_LEVEL_PROCEDURE
2871: (p_msg => 'Error. = '||sqlerrm
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: /*-------------------------------------------------------------+
3088:
3089: RETURN l_Ccid;
3090: END IF;
3091: EXCEPTION
3092: WHEN xla_exceptions_pkg.application_exception THEN
3093: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
3094: trace
3095: (p_msg => 'Error. = '||sqlerrm
3096: ,p_level => C_LEVEL_PROCEDURE
3103: (p_msg => 'Error. = '||sqlerrm
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: /*------------------------------------------------------------------+
3293: ,p_module => l_log_module);
3294: END IF;
3295: RETURN l_count;
3296: EXCEPTION
3297: WHEN xla_exceptions_pkg.application_exception THEN
3298: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
3299: trace
3300: (p_msg => 'Error. = '||sqlerrm
3301: ,p_level => C_LEVEL_PROCEDURE
3308: (p_msg => 'Error. = '||sqlerrm
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: /*------------------------------------------------------------------+
3538: ,p_module => l_log_module);
3539: END IF;
3540: RETURN l_return;
3541: EXCEPTION
3542: WHEN xla_exceptions_pkg.application_exception THEN
3543: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
3544: trace
3545: (p_msg => 'Error. = '||sqlerrm
3546: ,p_level => C_LEVEL_PROCEDURE
3553: (p_msg => 'Error. = '||sqlerrm
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: /*-----------------------------------------------------------------------+
3859: ,p_module => l_log_module);
3860: END IF;
3861: RETURN l_count;
3862: EXCEPTION
3863: WHEN xla_exceptions_pkg.application_exception THEN
3864: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
3865: trace
3866: (p_msg => 'Error. = '||sqlerrm
3867: ,p_level => C_LEVEL_PROCEDURE
3874: (p_msg => 'Error. = '||sqlerrm
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: /*---------------------------------------------------------------+
4054: END IF;
4055: --
4056: RETURN l_count;
4057: EXCEPTION
4058: WHEN xla_exceptions_pkg.application_exception THEN
4059: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
4060: trace
4061: (p_msg => 'Error. = '||sqlerrm
4062: ,p_level => C_LEVEL_PROCEDURE
4069: (p_msg => 'Error. = '||sqlerrm
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: /*---------------------------------------------------------------+
5015: ,p_module => l_log_module);
5016: END IF;
5017: RAISE;
5018:
5019: WHEN xla_exceptions_pkg.application_exception THEN
5020: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
5021: trace
5022: (p_msg => 'Error. = '||sqlerrm
5023: ,p_level => C_LEVEL_PROCEDURE
5030: (p_msg => 'Error. = '||sqlerrm
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:
5506: ,p_module => l_log_module);
5507: END IF;
5508: RETURN l_count;
5509: EXCEPTION
5510: WHEN xla_exceptions_pkg.application_exception THEN
5511: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
5512: trace
5513: (p_msg => 'Error. = '||sqlerrm
5514: ,p_level => C_LEVEL_PROCEDURE
5521: (p_msg => 'Error. = '||sqlerrm
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: /*-----------------------------------------------------------------------+
5592: END IF;
5593: --
5594: RETURN l_count;
5595: EXCEPTION
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');
5595: EXCEPTION
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:
5715: END IF;
5716: --
5717: RETURN 0;
5718: EXCEPTION
5719: WHEN xla_exceptions_pkg.application_exception THEN
5720: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
5721: trace
5722: (p_msg => 'Error. = '||sqlerrm
5723: ,p_level => C_LEVEL_PROCEDURE
5730: (p_msg => 'Error. = '||sqlerrm
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: --=============================================================================