1: PACKAGE BODY xla_cmp_analytic_criteria_pkg AS
2: /* $Header: xlacpanc.pkb 120.14 2005/07/12 22:27:11 awan 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_cmp_analytic_criteria_pkg |
10: | |
11: | DESCRIPTION |
12: | This is a XLA private package, which contains all the logic required |
13: | to generate anlytical criteria from AMB specifcations |
156: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
157: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
158:
159: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
160: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_analytic_criteria_pkg';
161:
162: g_log_level NUMBER;
163: g_log_enabled BOOLEAN;
164:
181: WHEN xla_exceptions_pkg.application_exception THEN
182: RAISE;
183: WHEN OTHERS THEN
184: xla_exceptions_pkg.raise_message
185: (p_location => 'xla_cmp_analytic_criteria_pkg.trace');
186: END trace;
187:
188: /*---------------------------------------------------------------------------+
189: | |
316: RAISE;
317: WHEN OTHERS THEN
318: IF source_cur%ISOPEN THEN CLOSE source_cur; END IF;
319: xla_exceptions_pkg.raise_message
320: (p_location => 'xla_cmp_analytic_criteria_pkg.GetAnalyticalCriteriaSources');
321: END GetAnalyticalCriteriaSources;
322:
323: /*---------------------------------------------------------------------------+
324: | |
503: RETURN NULL;
504: WHEN OTHERS THEN
505: IF analytic_criteria_cur%ISOPEN THEN CLOSE analytic_criteria_cur; END IF;
506: xla_exceptions_pkg.raise_message
507: (p_location => 'xla_cmp_analytic_criteria_pkg.HdrAnalyticCriteria');
508: END HdrAnalyticCriteria;
509:
510: /*---------------------------------------------------------------------------+
511: | |
685: RETURN NULL;
686: WHEN OTHERS THEN
687: IF analytic_criteria_cur%ISOPEN THEN CLOSE analytic_criteria_cur; END IF;
688: xla_exceptions_pkg.raise_message
689: (p_location => 'xla_cmp_analytic_criteria_pkg.GenerateHdrAnalyticCriteria');
690:
691: END GenerateHdrAnalyticCriteria;
692:
693: /*---------------------------------------------------------------------------+
874: RETURN NULL;
875: WHEN OTHERS THEN
876: IF analytic_criteria_cur%ISOPEN THEN CLOSE analytic_criteria_cur; END IF;
877: xla_exceptions_pkg.raise_message
878: (p_location => 'xla_cmp_analytic_criteria_pkg.LineAnalyticCriteria');
879: END LineAnalyticCriteria;
880:
881: /*---------------------------------------------------------------------------+
882: | |
1017: RETURN NULL;
1018: WHEN OTHERS THEN
1019: IF ac_cur%ISOPEN THEN CLOSE ac_cur; END IF;
1020: xla_exceptions_pkg.raise_message
1021: (p_location => 'xla_cmp_analytic_criteria_pkg.GenerateMpaHeaderAC');
1022:
1023: END GenerateMpaHeaderAC;
1024:
1025:
1163: RETURN NULL;
1164: WHEN OTHERS THEN
1165: IF ac_cur%ISOPEN THEN CLOSE ac_cur; END IF;
1166: xla_exceptions_pkg.raise_message
1167: (p_location => 'xla_cmp_analytic_criteria_pkg.GenerateMpaLineAC');
1168:
1169: END GenerateMpaLineAC;
1170:
1171: /*---------------------------------------------------------------------------+
1353: RETURN NULL;
1354: WHEN OTHERS THEN
1355: IF analytic_criteria_cur%ISOPEN THEN CLOSE analytic_criteria_cur; END IF;
1356: xla_exceptions_pkg.raise_message
1357: (p_location => 'xla_cmp_analytic_criteria_pkg.GenerateLineAnalyticCriteria');
1358:
1359: END GenerateLineAnalyticCriteria;
1360:
1361: --=============================================================================
1396: IF NOT g_log_enabled THEN
1397: g_log_level := C_LEVEL_LOG_DISABLED;
1398: END IF;
1399:
1400: END xla_cmp_analytic_criteria_pkg; --