[Home] [Help]
1: PACKAGE BODY xla_cmp_hash_pkg AS
2: /* $Header: xlacphsh.pkb 120.19.12010000.4 2010/07/05 13:47:31 karamakr 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: g_product_rule_hash_id NUMBER;
79: WHEN xla_exceptions_pkg.application_exception THEN
80: RAISE;
81: WHEN OTHERS THEN
82: xla_exceptions_pkg.raise_message
83: (p_location => 'xla_cmp_hash_pkg.trace');
84: END trace;
85: --+==========================================================================+
86: --| |
87: --| OVERVIEW of private procedures and functions |
163:
164: END IF;
165:
166: -- Fix bug 4585458
167: -- When this is called by xla_cmp_hash_pkg.BuildPADName in the
168: -- xla_accounting_cashe_pkg.load_application_ledgers, it error with ORA-14551
169: /*
170: UPDATE xla_product_rules_b xprb
171: SET xprb.product_rule_hash_id = (SELECT NVL(MAX(xpr.product_rule_hash_id),0) + 1
247: END IF;
248: RAISE;
249: WHEN OTHERS THEN
250: xla_exceptions_pkg.raise_message
251: (p_location => 'xla_cmp_hash_pkg.GetPADHashId');
252: END GetPADHashId;
253: --
254:
255: --
321: WHEN xla_exceptions_pkg.application_exception THEN
322: RAISE;
323: WHEN OTHERS THEN
324: xla_exceptions_pkg.raise_message
325: (p_location => 'xla_cmp_hash_pkg.GetPackageName');
326: END GetPackageName;
327: --
328: --
329: /*======================================================================+
395: WHEN xla_exceptions_pkg.application_exception THEN
396: RAISE;
397: WHEN OTHERS THEN
398: xla_exceptions_pkg.raise_message
399: (p_location => 'xla_cmp_hash_pkg.SearchPAD');
400: END SearchPAD;
401: --
402: /*======================================================================+
403: | |
550: WHEN xla_exceptions_pkg.application_exception THEN
551: RAISE;
552: WHEN OTHERS THEN
553: xla_exceptions_pkg.raise_message
554: (p_location => 'xla_cmp_hash_pkg.DropPadPkg');
555: END DropPadPkg;
556: --
557: --
558: /*======================================================================+
724: WHEN xla_exceptions_pkg.application_exception THEN
725: RAISE;
726: WHEN OTHERS THEN
727: xla_exceptions_pkg.raise_message
728: (p_location => 'xla_cmp_hash_pkg.BuildPackageName');
729: END BuildPackageName;
730: --=============================================================================
731: --
732: --
765: IF NOT g_log_enabled THEN
766: g_log_level := C_LEVEL_LOG_DISABLED;
767: END IF;
768:
769: END xla_cmp_hash_pkg; --