DBA Data[Home] [Help]

APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_ANALYTICAL_CRITERIA_PKG

Line 1: PACKAGE BODY XLA_ANALYTICAL_CRITERIA_PKG AS

1: PACKAGE BODY XLA_ANALYTICAL_CRITERIA_PKG AS
2: /* $Header: xlabaacr.pkb 120.23 2008/01/29 06:17:36 samejain ship $ */
3: /*======================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_analytical_criteria_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +=======================================================================+
8: | PACKAGE NAME |
9: | xla_analytical_criteria_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Analytical Criteria Package |
13: | |

Line 159: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_analytical_criteria_pkg';

155: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
156: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
157:
158: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
159: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_analytical_criteria_pkg';
160:
161: g_log_level NUMBER;
162: g_log_enabled BOOLEAN;
163:

Line 183: (p_location => 'xla_analytical_criteria_pkg.trace');

179: WHEN xla_exceptions_pkg.application_exception THEN
180: RAISE;
181: WHEN OTHERS THEN
182: xla_exceptions_pkg.raise_message
183: (p_location => 'xla_analytical_criteria_pkg.trace');
184: END trace;
185:
186: /*
187:

Line 383: (p_location => 'xla_analytical_criteria_pkg.insert_detail_value');

379: WHEN xla_exceptions_pkg.application_exception THEN
380: RAISE;
381: WHEN OTHERS THEN
382: xla_exceptions_pkg.raise_message
383: (p_location => 'xla_analytical_criteria_pkg.insert_detail_value');
384: END insert_detail_value;
385:
386:
387: FUNCTION format_detail_value ( p_detail_char VARCHAR2

Line 436: (p_location => 'xla_analytical_criteria_pkg.format_detail_value');

432: WHEN xla_exceptions_pkg.application_exception THEN
433: RAISE;
434: WHEN OTHERS THEN
435: xla_exceptions_pkg.raise_message
436: (p_location => 'xla_analytical_criteria_pkg.format_detail_value');
437: END format_detail_value;
438:
439:
440: FUNCTION maintain_detail_values

Line 677: (p_location => 'xla_analytical_criteria_pkg.maintain_detail_values');

673: WHEN xla_exceptions_pkg.application_exception THEN
674: RAISE;
675: WHEN OTHERS THEN
676: xla_exceptions_pkg.raise_message
677: (p_location => 'xla_analytical_criteria_pkg.maintain_detail_values');
678: END maintain_detail_values;
679:
680:
681: PROCEDURE insert_header_detail

Line 737: (p_location => 'xla_analytical_criteria_pkg.insert_header_detail');

733: WHEN xla_exceptions_pkg.application_exception THEN
734: RAISE;
735: WHEN OTHERS THEN
736: xla_exceptions_pkg.raise_message
737: (p_location => 'xla_analytical_criteria_pkg.insert_header_detail');
738: END insert_header_detail;
739:
740:
741: PROCEDURE insert_line_detail

Line 803: (p_location => 'xla_analytical_criteria_pkg.insert_line_detail');

799: WHEN xla_exceptions_pkg.application_exception THEN
800: RAISE;
801: WHEN OTHERS THEN
802: xla_exceptions_pkg.raise_message
803: (p_location => 'xla_analytical_criteria_pkg.insert_line_detail');
804: END insert_line_detail;
805:
806:
807: PROCEDURE delete_line_details

Line 889: (p_location => 'xla_analytical_criteria_pkg.delete_line_details');

885: WHEN xla_exceptions_pkg.application_exception THEN
886: RAISE;
887: WHEN OTHERS THEN
888: xla_exceptions_pkg.raise_message
889: (p_location => 'xla_analytical_criteria_pkg.delete_line_details');
890: END delete_line_details;
891:
892:
893: FUNCTION add_criterion

Line 999: (p_location => 'xla_analytical_criteria_pkg.add_criterion');

995: || 'cannot be NULL '
996: ,p_level => C_LEVEL_EXCEPTION);
997: END IF;
998: xla_exceptions_pkg.raise_message
999: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1000: END IF;
1001:
1002: SELECT xah.balancing_flag
1003: INTO l_balancing_flag

Line 1152: (p_location => 'xla_analytical_criteria_pkg.add_criterion');

1148: WHEN xla_exceptions_pkg.application_exception THEN
1149: RAISE;
1150: WHEN OTHERS THEN
1151: xla_exceptions_pkg.raise_message
1152: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1153:
1154: END add_criterion;
1155:
1156:

Line 1246: (p_location => 'xla_analytical_criteria_pkg.add_criterion');

1242: || 'cannot be NULL '
1243: ,p_level => C_LEVEL_EXCEPTION);
1244: END IF;
1245: xla_exceptions_pkg.raise_message
1246: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1247: END IF;
1248:
1249: SELECT xah.balancing_flag
1250: INTO l_balancing_flag

Line 1347: (p_location => 'xla_analytical_criteria_pkg.add_criterion');

1343: WHEN xla_exceptions_pkg.application_exception THEN
1344: RAISE;
1345: WHEN OTHERS THEN
1346: xla_exceptions_pkg.raise_message
1347: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1348:
1349: END add_criterion;
1350:
1351:

Line 1461: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');

1457: ,p_level => C_LEVEL_EXCEPTION
1458: );
1459: END IF;
1460: xla_exceptions_pkg.raise_message
1461: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1462: ELSE
1463: IF p_ae_line_num IS NULL
1464: THEN
1465: IF p_analytical_detail_value_id IS NULL

Line 1709: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');

1705: ,p_level => C_LEVEL_EXCEPTION
1706: );
1707: END IF;
1708: xla_exceptions_pkg.raise_message
1709: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1710: END IF; --p_anacri_code IS NOT NULL
1711:
1712: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1713: trace

Line 1736: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');

1732: WHEN xla_exceptions_pkg.application_exception THEN
1733: RAISE;
1734: WHEN OTHERS THEN
1735: xla_exceptions_pkg.raise_message
1736: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1737:
1738: END remove_criterion;
1739:
1740: FUNCTION remove_criterion

Line 1851: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');

1847: ,p_level => C_LEVEL_EXCEPTION
1848: );
1849: END IF;
1850: xla_exceptions_pkg.raise_message
1851: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1852: ELSE
1853: IF p_ae_line_num IS NULL
1854: THEN
1855: IF (p_anacri_code IS NULL)

Line 2032: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');

2028: ,p_level => C_LEVEL_EXCEPTION
2029: );
2030: END IF;
2031: xla_exceptions_pkg.raise_message
2032: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
2033: END IF; --p_anacri_code IS NOT NULL
2034:
2035: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2036: trace

Line 2059: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');

2055: WHEN xla_exceptions_pkg.application_exception THEN
2056: RAISE;
2057: WHEN OTHERS THEN
2058: xla_exceptions_pkg.raise_message
2059: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
2060:
2061: END remove_criterion;
2062:
2063: FUNCTION update_detail_value ( p_application_id IN INTEGER

Line 2138: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');

2134: );
2135: END IF;
2136:
2137: xla_exceptions_pkg.raise_message
2138: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2139: END IF;
2140:
2141: --Lock the headers (and the lines if necessary)
2142: IF p_ae_line_num IS NULL

Line 2176: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');

2172: ,p_level => C_LEVEL_EXCEPTION
2173: );
2174: END IF;
2175: xla_exceptions_pkg.raise_message
2176: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2177: END IF;
2178:
2179: FOR i IN 1..p_list_of_criteria.LAST
2180: LOOP

Line 2197: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');

2193: ,p_level => C_LEVEL_EXCEPTION
2194: );
2195: END IF;
2196: xla_exceptions_pkg.raise_message
2197: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2198: END IF;
2199:
2200: CASE p_list_of_criteria(i).list_of_detail_chars.LAST
2201: WHEN 0

Line 2389: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');

2385: ,p_level => C_LEVEL_EXCEPTION
2386: );
2387: END IF;
2388: xla_exceptions_pkg.raise_message
2389: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2390: END CASE;
2391: IF NOT l_return_value
2392: THEN
2393: EXIT;

Line 2439: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');

2435: ,p_level => C_LEVEL_EXCEPTION
2436: );
2437: END IF;
2438: xla_exceptions_pkg.raise_message
2439: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2440: END IF;
2441:
2442: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2443: trace

Line 2466: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');

2462: WHEN xla_exceptions_pkg.application_exception THEN
2463: RAISE;
2464: WHEN OTHERS THEN
2465: xla_exceptions_pkg.raise_message
2466: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2467:
2468: END update_detail_value;
2469:
2470:

Line 2564: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2560: ,p_level => C_LEVEL_EXCEPTION
2561: );
2562: END IF;
2563: xla_exceptions_pkg.raise_message
2564: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2565: END IF;
2566:
2567: IF p_ae_line_num IS NULL
2568: THEN

Line 2603: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2599: ,p_level => C_LEVEL_EXCEPTION
2600: );
2601: END IF;
2602: xla_exceptions_pkg.raise_message
2603: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2604: END IF;
2605: IF p_analytical_detail_value_id IS NOT NULL
2606: THEN
2607: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN

Line 2617: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2613: ,p_level => C_LEVEL_EXCEPTION
2614: );
2615: END IF;
2616: xla_exceptions_pkg.raise_message
2617: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2618: END IF;
2619:
2620: l_return_value :=
2621: add_criterion

Line 2658: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2654: ,p_level => C_LEVEL_EXCEPTION
2655: );
2656: END IF;
2657: xla_exceptions_pkg.raise_message
2658: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2659: ELSE
2660: IF p_anacri_code IS NOT NULL
2661: OR p_anacri_type_code IS NOT NULL
2662: OR p_amb_context_code IS NOT NULL

Line 2674: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2670: ,p_level => C_LEVEL_EXCEPTION
2671: );
2672: END IF;
2673: xla_exceptions_pkg.raise_message
2674: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2675: END IF;
2676:
2677: IF p_detail_char_1 IS NOT NULL
2678: OR p_detail_char_2 IS NOT NULL

Line 2762: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2758: ,p_level => C_LEVEL_EXCEPTION );
2759: END IF;
2760:
2761: xla_exceptions_pkg.raise_message
2762: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2763: END IF;
2764:
2765: l_return_value :=
2766: remove_criterion

Line 2787: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2783: ,p_level => C_LEVEL_EXCEPTION
2784: );
2785: END IF;
2786: xla_exceptions_pkg.raise_message
2787: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2788: END IF;
2789:
2790: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2791: trace

Line 2813: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2809: WHEN xla_exceptions_pkg.application_exception THEN
2810: RAISE;
2811: WHEN OTHERS THEN
2812: xla_exceptions_pkg.raise_message
2813: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2814: END single_update_detail_value;
2815:
2816:
2817: FUNCTION single_update_detail_value

Line 2923: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2919: ,p_level => C_LEVEL_EXCEPTION
2920: );
2921: END IF;
2922: xla_exceptions_pkg.raise_message
2923: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2924: END IF;
2925:
2926: IF p_ae_line_num IS NULL
2927: THEN

Line 2962: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2958: ,p_level => C_LEVEL_EXCEPTION
2959: );
2960: END IF;
2961: xla_exceptions_pkg.raise_message
2962: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2963: END IF;
2964:
2965: l_return_value :=
2966: add_criterion

Line 2989: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

2985: ,p_level => C_LEVEL_EXCEPTION
2986: );
2987: END IF;
2988: xla_exceptions_pkg.raise_message
2989: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2990: ELSE
2991: IF p_anacri_code IS NOT NULL
2992: OR p_anacri_type_code IS NOT NULL
2993: OR p_amb_context_code IS NOT NULL

Line 3005: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

3001: ,p_level => C_LEVEL_EXCEPTION
3002: );
3003: END IF;
3004: xla_exceptions_pkg.raise_message
3005: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3006: END IF;
3007:
3008: l_return_value :=
3009: remove_criterion

Line 3034: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

3030: ,p_level => C_LEVEL_EXCEPTION
3031: );
3032: END IF;
3033: xla_exceptions_pkg.raise_message
3034: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3035: END IF;
3036:
3037: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3038: trace

Line 3060: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');

3056: WHEN xla_exceptions_pkg.application_exception THEN
3057: RAISE;
3058: WHEN OTHERS THEN
3059: xla_exceptions_pkg.raise_message
3060: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3061:
3062: END single_update_detail_value;
3063:
3064:

Line 3137: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');

3133: ,p_level => C_LEVEL_EXCEPTION
3134: );
3135: END IF;
3136: xla_exceptions_pkg.raise_message
3137: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3138: END IF;
3139:
3140: IF (C_LEVEL_STATEMENT >= g_log_level)
3141: THEN

Line 3238: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');

3234: ,p_level => C_LEVEL_EXCEPTION
3235: );
3236: END IF;
3237: xla_exceptions_pkg.raise_message
3238: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3239: END IF;
3240: l_cache_elm_count := ga_anacri_code.COUNT;
3241: l_current_pos := g_anacri_cache_next_avail_pos - 1 ;
3242:

Line 3391: (p_location => 'xla_analytical_criteria_pkg.get_detail_value_id');

3387: WHEN xla_exceptions_pkg.application_exception THEN
3388: RAISE;
3389: WHEN OTHERS THEN
3390: xla_exceptions_pkg.raise_message
3391: (p_location => 'xla_analytical_criteria_pkg.get_detail_value_id');
3392:
3393:
3394: END get_detail_value_id;
3395:

Line 3469: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');

3465: ,p_level => C_LEVEL_EXCEPTION
3466: );
3467: END IF;
3468: xla_exceptions_pkg.raise_message
3469: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3470: END IF;
3471:
3472: IF (C_LEVEL_STATEMENT >= g_log_level)
3473: THEN

Line 3570: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');

3566: ,p_level => C_LEVEL_EXCEPTION
3567: );
3568: END IF;
3569: xla_exceptions_pkg.raise_message
3570: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3571: END IF;
3572:
3573: --Retrieve the converted segment values
3574: l_det_1 := format_detail_value (

Line 3643: (p_location => 'xla_analytical_criteria_pkg.get_detail_value_id');

3639: WHEN xla_exceptions_pkg.application_exception THEN
3640: RAISE;
3641: WHEN OTHERS THEN
3642: xla_exceptions_pkg.raise_message
3643: (p_location => 'xla_analytical_criteria_pkg.get_detail_value_id');
3644:
3645:
3646: END concat_detail_values;
3647:

Line 3752: (p_location => 'xla_analytical_criteria_pkg.get_first_free_view_col_number');

3748: ,p_level => C_LEVEL_EXCEPTION
3749: );
3750: END IF;
3751: xla_exceptions_pkg.raise_message
3752: (p_location => 'xla_analytical_criteria_pkg.get_first_free_view_col_number');
3753: END IF;
3754:
3755: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3756: trace

Line 3846: (p_location => 'xla_analytical_criteria_pkg.get_first_free_view_col_number');

3842: WHEN xla_exceptions_pkg.application_exception THEN
3843: RAISE;
3844: WHEN OTHERS THEN
3845: xla_exceptions_pkg.raise_message
3846: (p_location => 'xla_analytical_criteria_pkg.get_first_free_view_col_number');
3847:
3848: END get_first_free_view_col_number;
3849:
3850:

Line 3906: (p_location => 'xla_analytical_criteria_pkg.get_view_column_number');

3902: WHEN xla_exceptions_pkg.application_exception THEN
3903: RAISE;
3904: WHEN OTHERS THEN
3905: xla_exceptions_pkg.raise_message
3906: (p_location => 'xla_analytical_criteria_pkg.get_view_column_number');
3907:
3908: END get_view_column_number;
3909:
3910:

Line 4117: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');

4113: ,p_level => C_LEVEL_EXCEPTION
4114: );
4115: END IF;
4116: xla_exceptions_pkg.raise_message
4117: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');
4118: END IF;
4119: ELSE
4120: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
4121: trace

Line 4131: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');

4127: ,p_level => C_LEVEL_EXCEPTION
4128: );
4129: END IF;
4130: xla_exceptions_pkg.raise_message
4131: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');
4132:
4133: END IF;
4134:
4135: IF l_update_required THEN

Line 4195: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');

4191: WHEN xla_exceptions_pkg.application_exception THEN
4192: RAISE;
4193: WHEN OTHERS THEN
4194: xla_exceptions_pkg.raise_message
4195: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');
4196:
4197: END compile_criterion;
4198:
4199: FUNCTION build_criteria_view

Line 4720: (p_location => 'xla_analytical_criteria_pkg.build_criteria_view');

4716: WHEN xla_exceptions_pkg.application_exception THEN
4717: RAISE;
4718: WHEN OTHERS THEN
4719: xla_exceptions_pkg.raise_message
4720: (p_location => 'xla_analytical_criteria_pkg.build_criteria_view');
4721:
4722: END build_criteria_view;
4723:
4724: FUNCTION get_hdr_ac_count

Line 4816: (p_location => 'xla_analytical_criteria_pkg.get_hdr_ac_count');

4812: WHEN xla_exceptions_pkg.application_exception THEN
4813: RAISE;
4814: WHEN OTHERS THEN
4815: xla_exceptions_pkg.raise_message
4816: (p_location => 'xla_analytical_criteria_pkg.get_hdr_ac_count');
4817:
4818: END get_hdr_ac_count;
4819:
4820: FUNCTION get_line_ac_count

Line 4909: (p_location => 'xla_analytical_criteria_pkg.get_line_ac_count');

4905: WHEN xla_exceptions_pkg.application_exception THEN
4906: RAISE;
4907: WHEN OTHERS THEN
4908: xla_exceptions_pkg.raise_message
4909: (p_location => 'xla_analytical_criteria_pkg.get_line_ac_count');
4910: END get_line_ac_count;
4911:
4912: /*
4913: FUNCTION uncompile_product_rules ( p_anacri_code IN VARCHAR2

Line 4994: (p_location => 'xla_analytical_criteria_pkg.uncompile_product_rules');

4990: WHEN xla_exceptions_pkg.application_exception THEN
4991: RAISE;
4992: WHEN OTHERS THEN
4993: xla_exceptions_pkg.raise_message
4994: (p_location => 'xla_analytical_criteria_pkg.uncompile_product_rules');
4995:
4996: END uncompile_product_rules;
4997: */
4998:

Line 5010: END xla_analytical_criteria_pkg;

5006: g_log_level := C_LEVEL_LOG_DISABLED;
5007: END IF;
5008:
5009:
5010: END xla_analytical_criteria_pkg;