1: PACKAGE BODY xla_cmp_hash_pkg AS
2: /* $Header: xlacphsh.pkb 120.19 2005/08/31 21:46:13 wychan 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_hash_pkg |
10: | |
11: | DESCRIPTION |
12: | |
13: | |
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
52:
53: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
54: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_hash_pkg';
55:
56: g_log_level NUMBER;
57: g_log_enabled BOOLEAN;
58:
74: WHEN xla_exceptions_pkg.application_exception THEN
75: RAISE;
76: WHEN OTHERS THEN
77: xla_exceptions_pkg.raise_message
78: (p_location => 'xla_cmp_hash_pkg.trace');
79: END trace;
80: --+==========================================================================+
81: --| |
82: --| OVERVIEW of private procedures and functions |
158:
159: END IF;
160:
161: -- Fix bug 4585458
162: -- When this is called by xla_cmp_hash_pkg.BuildPADName in the
163: -- xla_accounting_cashe_pkg.load_application_ledgers, it error with ORA-14551
164: /*
165: UPDATE xla_product_rules_b xprb
166: SET xprb.product_rule_hash_id = (SELECT NVL(MAX(xpr.product_rule_hash_id),0) + 1
213: END IF;
214: RAISE;
215: WHEN OTHERS THEN
216: xla_exceptions_pkg.raise_message
217: (p_location => 'xla_cmp_hash_pkg.GetPADHashId');
218: END GetPADHashId;
219: --
220:
221: --
287: WHEN xla_exceptions_pkg.application_exception THEN
288: RAISE;
289: WHEN OTHERS THEN
290: xla_exceptions_pkg.raise_message
291: (p_location => 'xla_cmp_hash_pkg.GetPackageName');
292: END GetPackageName;
293: --
294: --
295: /*======================================================================+
361: WHEN xla_exceptions_pkg.application_exception THEN
362: RAISE;
363: WHEN OTHERS THEN
364: xla_exceptions_pkg.raise_message
365: (p_location => 'xla_cmp_hash_pkg.SearchPAD');
366: END SearchPAD;
367: --
368: /*======================================================================+
369: | |
516: WHEN xla_exceptions_pkg.application_exception THEN
517: RAISE;
518: WHEN OTHERS THEN
519: xla_exceptions_pkg.raise_message
520: (p_location => 'xla_cmp_hash_pkg.DropPadPkg');
521: END DropPadPkg;
522: --
523: --
524: /*======================================================================+
690: WHEN xla_exceptions_pkg.application_exception THEN
691: RAISE;
692: WHEN OTHERS THEN
693: xla_exceptions_pkg.raise_message
694: (p_location => 'xla_cmp_hash_pkg.BuildPackageName');
695: END BuildPackageName;
696: --=============================================================================
697: --
698: --
731: IF NOT g_log_enabled THEN
732: g_log_level := C_LEVEL_LOG_DISABLED;
733: END IF;
734:
735: END xla_cmp_hash_pkg; --