eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.26 2011/06/06 12:30:16 sgullape 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 1180: (p_location => 'xla_analytical_criteria_pkg.add_criterion');

1176: WHEN xla_exceptions_pkg.application_exception THEN
1177: RAISE;
1178: WHEN OTHERS THEN
1179: xla_exceptions_pkg.raise_message
1180: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1181:
1182: END add_criterion;
1183:
1184:

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

1270: || 'cannot be NULL '
1271: ,p_level => C_LEVEL_EXCEPTION);
1272: END IF;
1273: xla_exceptions_pkg.raise_message
1274: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1275: END IF;
1276:
1277: SELECT xah.balancing_flag
1278: INTO l_balancing_flag

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

1399: WHEN xla_exceptions_pkg.application_exception THEN
1400: RAISE;
1401: WHEN OTHERS THEN
1402: xla_exceptions_pkg.raise_message
1403: (p_location => 'xla_analytical_criteria_pkg.add_criterion');
1404:
1405: END add_criterion;
1406:
1407:

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

1513: ,p_level => C_LEVEL_EXCEPTION
1514: );
1515: END IF;
1516: xla_exceptions_pkg.raise_message
1517: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1518: ELSE
1519: IF p_ae_line_num IS NULL
1520: THEN
1521: IF p_analytical_detail_value_id IS NULL

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

1815: ,p_level => C_LEVEL_EXCEPTION
1816: );
1817: END IF;
1818: xla_exceptions_pkg.raise_message
1819: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1820: END IF; --p_anacri_code IS NOT NULL
1821:
1822: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1823: trace

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

1842: WHEN xla_exceptions_pkg.application_exception THEN
1843: RAISE;
1844: WHEN OTHERS THEN
1845: xla_exceptions_pkg.raise_message
1846: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1847:
1848: END remove_criterion;
1849:
1850: FUNCTION remove_criterion

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

1958: ,p_level => C_LEVEL_EXCEPTION
1959: );
1960: END IF;
1961: xla_exceptions_pkg.raise_message
1962: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
1963: ELSE
1964: IF p_ae_line_num IS NULL
1965: THEN
1966: IF (p_anacri_code IS NULL)

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

2193: ,p_level => C_LEVEL_EXCEPTION
2194: );
2195: END IF;
2196: xla_exceptions_pkg.raise_message
2197: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
2198: END IF; --p_anacri_code IS NOT NULL
2199:
2200: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2201: trace

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

2220: WHEN xla_exceptions_pkg.application_exception THEN
2221: RAISE;
2222: WHEN OTHERS THEN
2223: xla_exceptions_pkg.raise_message
2224: (p_location => 'xla_analytical_criteria_pkg.remove_criterion');
2225:
2226: END remove_criterion;
2227:
2228: FUNCTION update_detail_value ( p_application_id IN INTEGER

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

2299: );
2300: END IF;
2301:
2302: xla_exceptions_pkg.raise_message
2303: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2304: END IF;
2305:
2306: --Lock the headers (and the lines if necessary)
2307: IF p_ae_line_num IS NULL

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

2337: ,p_level => C_LEVEL_EXCEPTION
2338: );
2339: END IF;
2340: xla_exceptions_pkg.raise_message
2341: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2342: END IF;
2343:
2344: FOR i IN 1..p_list_of_criteria.LAST
2345: LOOP

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

2358: ,p_level => C_LEVEL_EXCEPTION
2359: );
2360: END IF;
2361: xla_exceptions_pkg.raise_message
2362: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2363: END IF;
2364:
2365: CASE p_list_of_criteria(i).list_of_detail_chars.LAST
2366: WHEN 0

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

2550: ,p_level => C_LEVEL_EXCEPTION
2551: );
2552: END IF;
2553: xla_exceptions_pkg.raise_message
2554: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2555: END CASE;
2556: IF NOT l_return_value
2557: THEN
2558: EXIT;

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

2600: ,p_level => C_LEVEL_EXCEPTION
2601: );
2602: END IF;
2603: xla_exceptions_pkg.raise_message
2604: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2605: END IF;
2606:
2607: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2608: trace

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

2627: WHEN xla_exceptions_pkg.application_exception THEN
2628: RAISE;
2629: WHEN OTHERS THEN
2630: xla_exceptions_pkg.raise_message
2631: (p_location => 'xla_analytical_criteria_pkg.update_detail_value');
2632:
2633: END update_detail_value;
2634:
2635:

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

2725: ,p_level => C_LEVEL_EXCEPTION
2726: );
2727: END IF;
2728: xla_exceptions_pkg.raise_message
2729: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2730: END IF;
2731:
2732: IF p_ae_line_num IS NULL
2733: THEN

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

2764: ,p_level => C_LEVEL_EXCEPTION
2765: );
2766: END IF;
2767: xla_exceptions_pkg.raise_message
2768: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2769: END IF;
2770: IF p_analytical_detail_value_id IS NOT NULL
2771: THEN
2772: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN

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

2778: ,p_level => C_LEVEL_EXCEPTION
2779: );
2780: END IF;
2781: xla_exceptions_pkg.raise_message
2782: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2783: END IF;
2784:
2785: l_return_value :=
2786: add_criterion

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

2819: ,p_level => C_LEVEL_EXCEPTION
2820: );
2821: END IF;
2822: xla_exceptions_pkg.raise_message
2823: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2824: ELSE
2825: IF p_anacri_code IS NOT NULL
2826: OR p_anacri_type_code IS NOT NULL
2827: OR p_amb_context_code IS NOT NULL

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

2835: ,p_level => C_LEVEL_EXCEPTION
2836: );
2837: END IF;
2838: xla_exceptions_pkg.raise_message
2839: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2840: END IF;
2841:
2842: IF p_detail_char_1 IS NOT NULL
2843: OR p_detail_char_2 IS NOT NULL

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

2923: ,p_level => C_LEVEL_EXCEPTION );
2924: END IF;
2925:
2926: xla_exceptions_pkg.raise_message
2927: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2928: END IF;
2929:
2930: l_return_value :=
2931: remove_criterion

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

2948: ,p_level => C_LEVEL_EXCEPTION
2949: );
2950: END IF;
2951: xla_exceptions_pkg.raise_message
2952: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2953: END IF;
2954:
2955: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2956: trace

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

2974: WHEN xla_exceptions_pkg.application_exception THEN
2975: RAISE;
2976: WHEN OTHERS THEN
2977: xla_exceptions_pkg.raise_message
2978: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
2979: END single_update_detail_value;
2980:
2981:
2982: FUNCTION single_update_detail_value

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

3084: ,p_level => C_LEVEL_EXCEPTION
3085: );
3086: END IF;
3087: xla_exceptions_pkg.raise_message
3088: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3089: END IF;
3090:
3091: IF p_ae_line_num IS NULL
3092: THEN

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

3123: ,p_level => C_LEVEL_EXCEPTION
3124: );
3125: END IF;
3126: xla_exceptions_pkg.raise_message
3127: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3128: END IF;
3129:
3130: l_return_value :=
3131: add_criterion

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

3150: ,p_level => C_LEVEL_EXCEPTION
3151: );
3152: END IF;
3153: xla_exceptions_pkg.raise_message
3154: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3155: ELSE
3156: IF p_anacri_code IS NOT NULL
3157: OR p_anacri_type_code IS NOT NULL
3158: OR p_amb_context_code IS NOT NULL

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

3166: ,p_level => C_LEVEL_EXCEPTION
3167: );
3168: END IF;
3169: xla_exceptions_pkg.raise_message
3170: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3171: END IF;
3172:
3173: l_return_value :=
3174: remove_criterion

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

3195: ,p_level => C_LEVEL_EXCEPTION
3196: );
3197: END IF;
3198: xla_exceptions_pkg.raise_message
3199: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3200: END IF;
3201:
3202: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3203: trace

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

3221: WHEN xla_exceptions_pkg.application_exception THEN
3222: RAISE;
3223: WHEN OTHERS THEN
3224: xla_exceptions_pkg.raise_message
3225: (p_location => 'xla_analytical_criteria_pkg.single_update_detail_value');
3226:
3227: END single_update_detail_value;
3228:
3229:

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

3298: ,p_level => C_LEVEL_EXCEPTION
3299: );
3300: END IF;
3301: xla_exceptions_pkg.raise_message
3302: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3303: END IF;
3304:
3305: IF (C_LEVEL_STATEMENT >= g_log_level)
3306: THEN

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

3399: ,p_level => C_LEVEL_EXCEPTION
3400: );
3401: END IF;
3402: xla_exceptions_pkg.raise_message
3403: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3404: END IF;
3405: l_cache_elm_count := ga_anacri_code.COUNT;
3406: l_current_pos := g_anacri_cache_next_avail_pos - 1 ;
3407:

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

3552: WHEN xla_exceptions_pkg.application_exception THEN
3553: RAISE;
3554: WHEN OTHERS THEN
3555: xla_exceptions_pkg.raise_message
3556: (p_location => 'xla_analytical_criteria_pkg.get_detail_value_id');
3557:
3558:
3559: END get_detail_value_id;
3560:

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

3630: ,p_level => C_LEVEL_EXCEPTION
3631: );
3632: END IF;
3633: xla_exceptions_pkg.raise_message
3634: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3635: END IF;
3636:
3637: IF (C_LEVEL_STATEMENT >= g_log_level)
3638: THEN

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

3731: ,p_level => C_LEVEL_EXCEPTION
3732: );
3733: END IF;
3734: xla_exceptions_pkg.raise_message
3735: (p_location => 'xla_analytical_criteria_pkg..get_detail_value_id');
3736: END IF;
3737:
3738: --Retrieve the converted segment values
3739: l_det_1 := format_detail_value (

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

3804: WHEN xla_exceptions_pkg.application_exception THEN
3805: RAISE;
3806: WHEN OTHERS THEN
3807: xla_exceptions_pkg.raise_message
3808: (p_location => 'xla_analytical_criteria_pkg.get_detail_value_id');
3809:
3810:
3811: END concat_detail_values;
3812:

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

3913: ,p_level => C_LEVEL_EXCEPTION
3914: );
3915: END IF;
3916: xla_exceptions_pkg.raise_message
3917: (p_location => 'xla_analytical_criteria_pkg.get_first_free_view_col_number');
3918: END IF;
3919:
3920: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3921: trace

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

4007: WHEN xla_exceptions_pkg.application_exception THEN
4008: RAISE;
4009: WHEN OTHERS THEN
4010: xla_exceptions_pkg.raise_message
4011: (p_location => 'xla_analytical_criteria_pkg.get_first_free_view_col_number');
4012:
4013: END get_first_free_view_col_number;
4014:
4015:

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

4067: WHEN xla_exceptions_pkg.application_exception THEN
4068: RAISE;
4069: WHEN OTHERS THEN
4070: xla_exceptions_pkg.raise_message
4071: (p_location => 'xla_analytical_criteria_pkg.get_view_column_number');
4072:
4073: END get_view_column_number;
4074:
4075:

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

4278: ,p_level => C_LEVEL_EXCEPTION
4279: );
4280: END IF;
4281: xla_exceptions_pkg.raise_message
4282: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');
4283: END IF;
4284: ELSE
4285: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
4286: trace

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

4292: ,p_level => C_LEVEL_EXCEPTION
4293: );
4294: END IF;
4295: xla_exceptions_pkg.raise_message
4296: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');
4297:
4298: END IF;
4299:
4300: IF l_update_required THEN

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

4356: WHEN xla_exceptions_pkg.application_exception THEN
4357: RAISE;
4358: WHEN OTHERS THEN
4359: xla_exceptions_pkg.raise_message
4360: (p_location => 'xla_analytical_criteria_pkg.compile_criterion');
4361:
4362: END compile_criterion;
4363:
4364: FUNCTION build_criteria_view

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

4912: WHEN xla_exceptions_pkg.application_exception THEN
4913: RAISE;
4914: WHEN OTHERS THEN
4915: xla_exceptions_pkg.raise_message
4916: (p_location => 'xla_analytical_criteria_pkg.build_criteria_view');
4917: */
4918:
4919: END build_criteria_view;
4920:

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

5009: WHEN xla_exceptions_pkg.application_exception THEN
5010: RAISE;
5011: WHEN OTHERS THEN
5012: xla_exceptions_pkg.raise_message
5013: (p_location => 'xla_analytical_criteria_pkg.get_hdr_ac_count');
5014:
5015: END get_hdr_ac_count;
5016:
5017: FUNCTION get_line_ac_count

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

5102: WHEN xla_exceptions_pkg.application_exception THEN
5103: RAISE;
5104: WHEN OTHERS THEN
5105: xla_exceptions_pkg.raise_message
5106: (p_location => 'xla_analytical_criteria_pkg.get_line_ac_count');
5107: END get_line_ac_count;
5108:
5109: /*
5110: FUNCTION uncompile_product_rules ( p_anacri_code IN VARCHAR2

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

5187: WHEN xla_exceptions_pkg.application_exception THEN
5188: RAISE;
5189: WHEN OTHERS THEN
5190: xla_exceptions_pkg.raise_message
5191: (p_location => 'xla_analytical_criteria_pkg.uncompile_product_rules');
5192:
5193: END uncompile_product_rules;
5194: */
5195:

Line 5207: END xla_analytical_criteria_pkg;

5203: g_log_level := C_LEVEL_LOG_DISABLED;
5204: END IF;
5205:
5206:
5207: END xla_analytical_criteria_pkg;