78:
79: --=============================================================================
80: -- *********** Local Trace Routine **********
81: --=============================================================================
82: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
83: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
79: --=============================================================================
80: -- *********** Local Trace Routine **********
81: --=============================================================================
82: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
83: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
80: -- *********** Local Trace Routine **********
81: --=============================================================================
82: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
83: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
88:
81: --=============================================================================
82: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
83: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
88:
89: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
82: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
83: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
88:
89: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
90:
83: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
84: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
85: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
86: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
87: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
88:
89: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_extract_integrity_pkg';
90:
91: g_trace_label VARCHAR2(240);
99: l_module VARCHAR2(240);
100: BEGIN
101:
102: IF (g_log_level is NULL) THEN
103: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
104: END IF;
105:
106: IF (g_log_level is NULL) THEN
107: g_log_enabled := fnd_log.test
103: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
104: END IF;
105:
106: IF (g_log_level is NULL) THEN
107: g_log_enabled := fnd_log.test
108: (log_level => g_log_level
109: ,module => C_DEFAULT_MODULE);
110: END IF;
111:
111:
112: l_module := C_DEFAULT_MODULE||'.'||g_trace_label;
113:
114: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
115: fnd_log.message(p_level, l_module);
116: ELSIF p_level >= g_log_level THEN
117: fnd_log.string(p_level, l_module, p_msg);
118: END IF;
119: EXCEPTION
113:
114: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
115: fnd_log.message(p_level, l_module);
116: ELSIF p_level >= g_log_level THEN
117: fnd_log.string(p_level, l_module, p_msg);
118: END IF;
119: EXCEPTION
120: WHEN xla_exceptions_pkg.application_exception THEN
121: RAISE;
168: l_entity_code := p_entity_code;
169: l_event_class_code := p_event_class_code;
170:
171: IF (g_log_level is NULL) THEN
172: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
173: END IF;
174:
175: IF (g_log_level is NULL) THEN
176: g_log_enabled := fnd_log.test
172: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
173: END IF;
174:
175: IF (g_log_level is NULL) THEN
176: g_log_enabled := fnd_log.test
177: (log_level => g_log_level
178: ,module => C_DEFAULT_MODULE);
179: END IF;
180:
178: ,module => C_DEFAULT_MODULE);
179: END IF;
180:
181: IF (g_log_level is NULL) THEN
182: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
183: END IF;
184:
185: IF (g_log_level is NULL) THEN
186: g_log_enabled := fnd_log.test
182: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
183: END IF;
184:
185: IF (g_log_level is NULL) THEN
186: g_log_enabled := fnd_log.test
187: (log_level => g_log_level
188: ,module => C_DEFAULT_MODULE);
189: END IF;
190:
455: l_product_rule_code := p_product_rule_code;
456: l_product_rule_type_code := p_product_rule_type_code;
457:
458: IF (g_log_level is NULL) THEN
459: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
460: END IF;
461:
462: IF (g_log_level is NULL) THEN
463: g_log_enabled := fnd_log.test
459: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
460: END IF;
461:
462: IF (g_log_level is NULL) THEN
463: g_log_enabled := fnd_log.test
464: (log_level => g_log_level
465: ,module => C_DEFAULT_MODULE);
466: END IF;
467:
658: l_entity_code := p_entity_code;
659: l_event_class_code := p_event_class_code;
660:
661: IF (g_log_level is NULL) THEN
662: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
663: END IF;
664:
665: IF (g_log_level is NULL) THEN
666: g_log_enabled := fnd_log.test
662: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
663: END IF;
664:
665: IF (g_log_level is NULL) THEN
666: g_log_enabled := fnd_log.test
667: (log_level => g_log_level
668: ,module => C_DEFAULT_MODULE);
669: END IF;
670:
1068:
1069: g_trace_label :='Validate_sources_with_extract';
1070:
1071: IF (g_log_level is NULL) THEN
1072: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1073: END IF;
1074:
1075: IF (g_log_level is NULL) THEN
1076: g_log_enabled := fnd_log.test
1072: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1073: END IF;
1074:
1075: IF (g_log_level is NULL) THEN
1076: g_log_enabled := fnd_log.test
1077: (log_level => g_log_level
1078: ,module => C_DEFAULT_MODULE);
1079: END IF;
1080:
1457:
1458: g_trace_label :='Set_extract_object_owner';
1459:
1460: IF (g_log_level is NULL) THEN
1461: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1462: END IF;
1463:
1464: IF (g_log_level is NULL) THEN
1465: g_log_enabled := fnd_log.test
1461: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1462: END IF;
1463:
1464: IF (g_log_level is NULL) THEN
1465: g_log_enabled := fnd_log.test
1466: (log_level => g_log_level
1467: ,module => C_DEFAULT_MODULE);
1468: END IF;
1469:
1963:
1964: g_trace_label :='Check_primary_keys_exist';
1965:
1966: IF (g_log_level is NULL) THEN
1967: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1968: END IF;
1969:
1970: IF (g_log_level is NULL) THEN
1971: g_log_enabled := fnd_log.test
1967: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1968: END IF;
1969:
1970: IF (g_log_level is NULL) THEN
1971: g_log_enabled := fnd_log.test
1972: (log_level => g_log_level
1973: ,module => C_DEFAULT_MODULE);
1974: END IF;
1975:
2480:
2481: g_trace_label :='Validate_accounting_sources';
2482:
2483: IF (g_log_level is NULL) THEN
2484: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2485: END IF;
2486:
2487: IF (g_log_level is NULL) THEN
2488: g_log_enabled := fnd_log.test
2484: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2485: END IF;
2486:
2487: IF (g_log_level is NULL) THEN
2488: g_log_enabled := fnd_log.test
2489: (log_level => g_log_level
2490: ,module => C_DEFAULT_MODULE);
2491: END IF;
2492:
2993: g_last_updated_by := xla_environment_pkg.g_usr_id;
2994: END IF;
2995:
2996: IF (g_log_level is NULL) THEN
2997: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2998: END IF;
2999:
3000: IF (g_log_level is NULL) THEN
3001: g_log_enabled := fnd_log.test
2997: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2998: END IF;
2999:
3000: IF (g_log_level is NULL) THEN
3001: g_log_enabled := fnd_log.test
3002: (log_level => g_log_level
3003: ,module => C_DEFAULT_MODULE);
3004: END IF;
3005:
3344: g_last_updated_by := xla_environment_pkg.g_usr_id;
3345: END IF;
3346:
3347: IF (g_log_level is NULL) THEN
3348: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3349: END IF;
3350:
3351: IF (g_log_level is NULL) THEN
3352: g_log_enabled := fnd_log.test
3348: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3349: END IF;
3350:
3351: IF (g_log_level is NULL) THEN
3352: g_log_enabled := fnd_log.test
3353: (log_level => g_log_level
3354: ,module => C_DEFAULT_MODULE);
3355: END IF;
3356: