82:
83: --=============================================================================
84: -- *********** Local Trace Routine **********
85: --=============================================================================
86: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
87: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
88: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
89: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
90: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
83: --=============================================================================
84: -- *********** Local Trace Routine **********
85: --=============================================================================
86: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
87: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
88: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
89: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
90: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
91: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
84: -- *********** Local Trace Routine **********
85: --=============================================================================
86: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
87: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
88: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
89: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
90: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
91: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
92:
85: --=============================================================================
86: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
87: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
88: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
89: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
90: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
91: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
92:
93: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
86: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
87: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
88: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
89: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
90: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
91: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
92:
93: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
94:
87: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
88: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
89: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
90: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
91: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
92:
93: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
94:
95: g_trace_label VARCHAR2(240);
103: l_module VARCHAR2(240);
104: BEGIN
105:
106: IF (g_log_level is NULL) THEN
107: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
108: END IF;
109:
110: IF (g_log_level is NULL) THEN
111: g_log_enabled := fnd_log.test
107: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
108: END IF;
109:
110: IF (g_log_level is NULL) THEN
111: g_log_enabled := fnd_log.test
112: (log_level => g_log_level
113: ,module => C_DEFAULT_MODULE);
114: END IF;
115:
115:
116: l_module := C_DEFAULT_MODULE||'.'||g_trace_label;
117:
118: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
119: fnd_log.message(p_level, l_module);
120: ELSIF p_level >= g_log_level THEN
121: fnd_log.string(p_level, l_module, p_msg);
122: END IF;
123: EXCEPTION
117:
118: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
119: fnd_log.message(p_level, l_module);
120: ELSIF p_level >= g_log_level THEN
121: fnd_log.string(p_level, l_module, p_msg);
122: END IF;
123: EXCEPTION
124: WHEN xla_exceptions_pkg.application_exception THEN
125: RAISE;
172: l_entity_code := p_entity_code;
173: l_event_class_code := p_event_class_code;
174:
175: IF (g_log_level is NULL) THEN
176: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
177: END IF;
178:
179: IF (g_log_level is NULL) THEN
180: g_log_enabled := fnd_log.test
176: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
177: END IF;
178:
179: IF (g_log_level is NULL) THEN
180: g_log_enabled := fnd_log.test
181: (log_level => g_log_level
182: ,module => C_DEFAULT_MODULE);
183: END IF;
184:
182: ,module => C_DEFAULT_MODULE);
183: END IF;
184:
185: IF (g_log_level is NULL) THEN
186: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
187: END IF;
188:
189: IF (g_log_level is NULL) THEN
190: g_log_enabled := fnd_log.test
186: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
187: END IF;
188:
189: IF (g_log_level is NULL) THEN
190: g_log_enabled := fnd_log.test
191: (log_level => g_log_level
192: ,module => C_DEFAULT_MODULE);
193: END IF;
194:
459: l_product_rule_code := p_product_rule_code;
460: l_product_rule_type_code := p_product_rule_type_code;
461:
462: IF (g_log_level is NULL) THEN
463: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
464: END IF;
465:
466: IF (g_log_level is NULL) THEN
467: g_log_enabled := fnd_log.test
463: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
464: END IF;
465:
466: IF (g_log_level is NULL) THEN
467: g_log_enabled := fnd_log.test
468: (log_level => g_log_level
469: ,module => C_DEFAULT_MODULE);
470: END IF;
471:
662: l_entity_code := p_entity_code;
663: l_event_class_code := p_event_class_code;
664:
665: IF (g_log_level is NULL) THEN
666: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
667: END IF;
668:
669: IF (g_log_level is NULL) THEN
670: g_log_enabled := fnd_log.test
666: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
667: END IF;
668:
669: IF (g_log_level is NULL) THEN
670: g_log_enabled := fnd_log.test
671: (log_level => g_log_level
672: ,module => C_DEFAULT_MODULE);
673: END IF;
674:
1447:
1448: g_trace_label :='Validate_sources_with_extract';
1449:
1450: IF (g_log_level is NULL) THEN
1451: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1452: END IF;
1453:
1454: IF (g_log_level is NULL) THEN
1455: g_log_enabled := fnd_log.test
1451: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1452: END IF;
1453:
1454: IF (g_log_level is NULL) THEN
1455: g_log_enabled := fnd_log.test
1456: (log_level => g_log_level
1457: ,module => C_DEFAULT_MODULE);
1458: END IF;
1459:
1836:
1837: g_trace_label :='Set_extract_object_owner';
1838:
1839: IF (g_log_level is NULL) THEN
1840: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1841: END IF;
1842:
1843: IF (g_log_level is NULL) THEN
1844: g_log_enabled := fnd_log.test
1840: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1841: END IF;
1842:
1843: IF (g_log_level is NULL) THEN
1844: g_log_enabled := fnd_log.test
1845: (log_level => g_log_level
1846: ,module => C_DEFAULT_MODULE);
1847: END IF;
1848:
2718:
2719: g_trace_label :='Check_primary_keys_exist';
2720:
2721: IF (g_log_level is NULL) THEN
2722: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2723: END IF;
2724:
2725: IF (g_log_level is NULL) THEN
2726: g_log_enabled := fnd_log.test
2722: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2723: END IF;
2724:
2725: IF (g_log_level is NULL) THEN
2726: g_log_enabled := fnd_log.test
2727: (log_level => g_log_level
2728: ,module => C_DEFAULT_MODULE);
2729: END IF;
2730:
3235:
3236: g_trace_label :='Validate_accounting_sources';
3237:
3238: IF (g_log_level is NULL) THEN
3239: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3240: END IF;
3241:
3242: IF (g_log_level is NULL) THEN
3243: g_log_enabled := fnd_log.test
3239: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3240: END IF;
3241:
3242: IF (g_log_level is NULL) THEN
3243: g_log_enabled := fnd_log.test
3244: (log_level => g_log_level
3245: ,module => C_DEFAULT_MODULE);
3246: END IF;
3247:
3929: g_last_updated_by := xla_environment_pkg.g_usr_id;
3930: END IF;
3931:
3932: IF (g_log_level is NULL) THEN
3933: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3934: END IF;
3935:
3936: IF (g_log_level is NULL) THEN
3937: g_log_enabled := fnd_log.test
3933: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3934: END IF;
3935:
3936: IF (g_log_level is NULL) THEN
3937: g_log_enabled := fnd_log.test
3938: (log_level => g_log_level
3939: ,module => C_DEFAULT_MODULE);
3940: END IF;
3941:
4280: g_last_updated_by := xla_environment_pkg.g_usr_id;
4281: END IF;
4282:
4283: IF (g_log_level is NULL) THEN
4284: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4285: END IF;
4286:
4287: IF (g_log_level is NULL) THEN
4288: g_log_enabled := fnd_log.test
4284: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4285: END IF;
4286:
4287: IF (g_log_level is NULL) THEN
4288: g_log_enabled := fnd_log.test
4289: (log_level => g_log_level
4290: ,module => C_DEFAULT_MODULE);
4291: END IF;
4292: