eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_ADMIN_UTIL_PKG dependencies on FND_LOG

Line 27: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

23: -- Logging global temporary tables.
24:
25: PROCEDURE Trunc_Table_Class_Log_Tables (
26: p_tab_name IN VARCHAR2) IS
27: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
28: 'fem.plsql.fem_admin_util_pkg.trunc_table_class_log_tables';
29: BEGIN
30:
31: BEGIN

Line 36: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

32: DELETE FROM fem_tab_class_status_gt
33: WHERE table_name = p_tab_name;
34: EXCEPTION
35: WHEN others THEN
36: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
37: FEM_ENGINES_PKG.TECH_MESSAGE(
38: p_severity => FND_LOG.level_exception,
39: p_module => C_MODULE,
40: p_msg_text => 'Delete from FEM_TAB_CLASS_STATUS_GT failed with: '||SQLERRM);

Line 38: p_severity => FND_LOG.level_exception,

34: EXCEPTION
35: WHEN others THEN
36: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
37: FEM_ENGINES_PKG.TECH_MESSAGE(
38: p_severity => FND_LOG.level_exception,
39: p_module => C_MODULE,
40: p_msg_text => 'Delete from FEM_TAB_CLASS_STATUS_GT failed with: '||SQLERRM);
41: END IF;
42: END;

Line 49: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

45: DELETE FROM fem_tab_class_errors_gt
46: WHERE table_name = p_tab_name;
47: EXCEPTION
48: WHEN others THEN
49: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
50: FEM_ENGINES_PKG.TECH_MESSAGE(
51: p_severity => FND_LOG.level_exception,
52: p_module => C_MODULE,
53: p_msg_text => 'Delete from FEM_TAB_CLASS_ERRORS_GT failed with: '||SQLERRM);

Line 51: p_severity => FND_LOG.level_exception,

47: EXCEPTION
48: WHEN others THEN
49: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
50: FEM_ENGINES_PKG.TECH_MESSAGE(
51: p_severity => FND_LOG.level_exception,
52: p_module => C_MODULE,
53: p_msg_text => 'Delete from FEM_TAB_CLASS_ERRORS_GT failed with: '||SQLERRM);
54: END IF;
55: END;

Line 74: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

70: p_value3 IN VARCHAR2 DEFAULT NULL,
71: p_token4 IN VARCHAR2 DEFAULT NULL,
72: p_value4 IN VARCHAR2 DEFAULT NULL
73: ) IS
74: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
75: 'fem.plsql.fem_admin_util_pkg.log_table_class_error';
76:
77: TYPE msg_array IS VARRAY(8) OF VARCHAR2(2000);
78: tokens_values msg_array;

Line 136: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

132: END IF; -- p_msg_txt IS NOT NULL
133:
134: EXCEPTION
135: WHEN others THEN
136: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
137: FEM_ENGINES_PKG.TECH_MESSAGE(
138: p_severity => FND_LOG.level_exception,
139: p_module => C_MODULE,
140: p_msg_text => 'Insert into FEM_TAB_CLASS_ERRORS_GT failed with: '||SQLERRM);

Line 138: p_severity => FND_LOG.level_exception,

134: EXCEPTION
135: WHEN others THEN
136: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
137: FEM_ENGINES_PKG.TECH_MESSAGE(
138: p_severity => FND_LOG.level_exception,
139: p_module => C_MODULE,
140: p_msg_text => 'Insert into FEM_TAB_CLASS_ERRORS_GT failed with: '||SQLERRM);
141: END IF;
142: END Log_Table_Class_Error;

Line 149: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

145: PROCEDURE Log_Table_Class_Status (
146: p_tab_name IN VARCHAR2,
147: p_tab_class_cd IN VARCHAR2,
148: p_passed_validation IN VARCHAR2) IS
149: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
150: 'fem.plsql.fem_admin_util_pkg.log_table_class_status';
151: BEGIN
152:
153: INSERT INTO fem_tab_class_status_gt

Line 160: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

156: (p_tab_name, p_tab_class_cd, decode(p_passed_validation,c_true,'Y','N'));
157:
158: EXCEPTION
159: WHEN others THEN
160: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
161: FEM_ENGINES_PKG.TECH_MESSAGE(
162: p_severity => FND_LOG.level_exception,
163: p_module => C_MODULE,
164: p_msg_text => 'Insert into FEM_TAB_CLASS_STATUS_GT failed with: '||SQLERRM);

Line 162: p_severity => FND_LOG.level_exception,

158: EXCEPTION
159: WHEN others THEN
160: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
161: FEM_ENGINES_PKG.TECH_MESSAGE(
162: p_severity => FND_LOG.level_exception,
163: p_module => C_MODULE,
164: p_msg_text => 'Insert into FEM_TAB_CLASS_STATUS_GT failed with: '||SQLERRM);
165: END IF;
166: END Log_Table_Class_Status;

Line 186: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

182: p_tab_name IN VARCHAR2,
183: p_tab_class_cd IN VARCHAR2
184: ) RETURN VARCHAR2
185: AS
186: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
187: 'fem.plsql.fem_admin_util_pkg.create_data_loader_rule';
188:
189: v_count INTEGER;
190: v_obj_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;

Line 201: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

197: BEGIN
198:
199: SAVEPOINT create_data_loader_rule_pub;
200:
201: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
202: FEM_ENGINES_PKG.TECH_MESSAGE(
203: p_severity => FND_LOG.level_procedure,
204: p_module => C_MODULE,
205: p_msg_text => 'Begin Procedure');

Line 203: p_severity => FND_LOG.level_procedure,

199: SAVEPOINT create_data_loader_rule_pub;
200:
201: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
202: FEM_ENGINES_PKG.TECH_MESSAGE(
203: p_severity => FND_LOG.level_procedure,
204: p_module => C_MODULE,
205: p_msg_text => 'Begin Procedure');
206: END IF;
207:

Line 245: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

241: x_msg_data => v_msg_data,
242: x_return_status => v_return_status);
243:
244: IF v_return_status <> c_success THEN
245: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
246: FEM_ENGINES_PKG.TECH_MESSAGE(
247: p_severity => FND_LOG.level_error,
248: p_module => C_MODULE,
249: p_msg_text => 'Call to fem_object_catalog_util_pkg.create_object '

Line 247: p_severity => FND_LOG.level_error,

243:
244: IF v_return_status <> c_success THEN
245: IF FND_LOG.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
246: FEM_ENGINES_PKG.TECH_MESSAGE(
247: p_severity => FND_LOG.level_error,
248: p_module => C_MODULE,
249: p_msg_text => 'Call to fem_object_catalog_util_pkg.create_object '
250: ||'did not return successfully: status = '
251: ||v_return_status);

Line 266: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

262: p_msg_count => v_msg_count);
263:
264: RETURN c_false;
265: ELSE
266: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
267: FEM_ENGINES_PKG.TECH_MESSAGE(
268: p_severity => FND_LOG.level_statement,
269: p_module => C_MODULE,
270: p_msg_text => 'New loader object id = '||v_obj_id

Line 268: p_severity => FND_LOG.level_statement,

264: RETURN c_false;
265: ELSE
266: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
267: FEM_ENGINES_PKG.TECH_MESSAGE(
268: p_severity => FND_LOG.level_statement,
269: p_module => C_MODULE,
270: p_msg_text => 'New loader object id = '||v_obj_id
271: ||' , object def id = '||v_obj_def_id);
272: END IF;

Line 323: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

319:
320: END IF;
321: END IF; -- v_count = 0
322:
323: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
324: FEM_ENGINES_PKG.TECH_MESSAGE(
325: p_severity => FND_LOG.level_procedure,
326: p_module => C_MODULE,
327: p_msg_text => 'End Procedure');

Line 325: p_severity => FND_LOG.level_procedure,

321: END IF; -- v_count = 0
322:
323: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
324: FEM_ENGINES_PKG.TECH_MESSAGE(
325: p_severity => FND_LOG.level_procedure,
326: p_module => C_MODULE,
327: p_msg_text => 'End Procedure');
328: END IF;
329:

Line 334: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

330: RETURN c_true;
331:
332: EXCEPTION
333: WHEN others THEN
334: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
335: FEM_ENGINES_PKG.TECH_MESSAGE(
336: p_severity => FND_LOG.level_exception,
337: p_module => C_MODULE,
338: p_msg_text => 'Create_Data_Loader_Rule failed unexpectedly: '||SQLERRM);

Line 336: p_severity => FND_LOG.level_exception,

332: EXCEPTION
333: WHEN others THEN
334: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
335: FEM_ENGINES_PKG.TECH_MESSAGE(
336: p_severity => FND_LOG.level_exception,
337: p_module => C_MODULE,
338: p_msg_text => 'Create_Data_Loader_Rule failed unexpectedly: '||SQLERRM);
339: END IF;
340: Log_Table_Class_Error(

Line 364: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

360: p_prop_type IN VARCHAR2,
361: p_col_req_type IN VARCHAR2,
362: x_passed_validation OUT NOCOPY VARCHAR2
363: ) IS
364: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
365: 'fem.plsql.fem_admin_util_pkg.validate_prop_col_req';
366:
367: TYPE CurTyp IS REF CURSOR;
368: cols_cv CurTyp;

Line 387: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

383: v_count NUMBER;
384: v_vsr_count NUMBER;
385: v_passed_valid VARCHAR2(1);
386: BEGIN
387: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
388: FEM_ENGINES_PKG.TECH_MESSAGE(
389: p_severity => FND_LOG.level_procedure,
390: p_module => C_MODULE,
391: p_msg_text => 'Begin Procedure');

Line 389: p_severity => FND_LOG.level_procedure,

385: v_passed_valid VARCHAR2(1);
386: BEGIN
387: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
388: FEM_ENGINES_PKG.TECH_MESSAGE(
389: p_severity => FND_LOG.level_procedure,
390: p_module => C_MODULE,
391: p_msg_text => 'Begin Procedure');
392: END IF;
393: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 393: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

389: p_severity => FND_LOG.level_procedure,
390: p_module => C_MODULE,
391: p_msg_text => 'Begin Procedure');
392: END IF;
393: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
394: FEM_ENGINES_PKG.TECH_MESSAGE(
395: p_severity => FND_LOG.level_statement,
396: p_module => C_MODULE,
397: p_msg_text => 'p_tab_name = '||p_tab_name);

Line 395: p_severity => FND_LOG.level_statement,

391: p_msg_text => 'Begin Procedure');
392: END IF;
393: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
394: FEM_ENGINES_PKG.TECH_MESSAGE(
395: p_severity => FND_LOG.level_statement,
396: p_module => C_MODULE,
397: p_msg_text => 'p_tab_name = '||p_tab_name);
398: FEM_ENGINES_PKG.TECH_MESSAGE(
399: p_severity => FND_LOG.level_statement,

Line 399: p_severity => FND_LOG.level_statement,

395: p_severity => FND_LOG.level_statement,
396: p_module => C_MODULE,
397: p_msg_text => 'p_tab_name = '||p_tab_name);
398: FEM_ENGINES_PKG.TECH_MESSAGE(
399: p_severity => FND_LOG.level_statement,
400: p_module => C_MODULE,
401: p_msg_text => 'p_tab_class_cd = '||p_tab_class_cd);
402: FEM_ENGINES_PKG.TECH_MESSAGE(
403: p_severity => FND_LOG.level_statement,

Line 403: p_severity => FND_LOG.level_statement,

399: p_severity => FND_LOG.level_statement,
400: p_module => C_MODULE,
401: p_msg_text => 'p_tab_class_cd = '||p_tab_class_cd);
402: FEM_ENGINES_PKG.TECH_MESSAGE(
403: p_severity => FND_LOG.level_statement,
404: p_module => C_MODULE,
405: p_msg_text => 'p_tab_prop_cd = '||p_tab_prop_cd);
406: FEM_ENGINES_PKG.TECH_MESSAGE(
407: p_severity => FND_LOG.level_statement,

Line 407: p_severity => FND_LOG.level_statement,

403: p_severity => FND_LOG.level_statement,
404: p_module => C_MODULE,
405: p_msg_text => 'p_tab_prop_cd = '||p_tab_prop_cd);
406: FEM_ENGINES_PKG.TECH_MESSAGE(
407: p_severity => FND_LOG.level_statement,
408: p_module => C_MODULE,
409: p_msg_text => 'p_prop_type = '||p_prop_type);
410: FEM_ENGINES_PKG.TECH_MESSAGE(
411: p_severity => FND_LOG.level_statement,

Line 411: p_severity => FND_LOG.level_statement,

407: p_severity => FND_LOG.level_statement,
408: p_module => C_MODULE,
409: p_msg_text => 'p_prop_type = '||p_prop_type);
410: FEM_ENGINES_PKG.TECH_MESSAGE(
411: p_severity => FND_LOG.level_statement,
412: p_module => C_MODULE,
413: p_msg_text => 'p_col_req_type = '||p_col_req_type);
414: END IF;
415:

Line 448: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

444: ||' WHERE table_name = :2'
445: ||' AND column_property_code = '''||v_col_prop_cd||''')';
446: END IF; -- p_prop_type
447:
448: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
449: FEM_ENGINES_PKG.TECH_MESSAGE(
450: p_severity => FND_LOG.level_statement,
451: p_module => C_MODULE,
452: p_msg_text => 'v_sql(10) = '||v_sql);

Line 450: p_severity => FND_LOG.level_statement,

446: END IF; -- p_prop_type
447:
448: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
449: FEM_ENGINES_PKG.TECH_MESSAGE(
450: p_severity => FND_LOG.level_statement,
451: p_module => C_MODULE,
452: p_msg_text => 'v_sql(10) = '||v_sql);
453: END IF;
454:

Line 493: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

489: ||' WHERE table_name = :1'
490: ||' AND column_property_code = '''||v_col_prop_cd||'''';
491: END IF; -- p_prop_type
492:
493: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
494: FEM_ENGINES_PKG.TECH_MESSAGE(
495: p_severity => FND_LOG.level_statement,
496: p_module => C_MODULE,
497: p_msg_text => 'v_sql(20) = '||v_sql);

Line 495: p_severity => FND_LOG.level_statement,

491: END IF; -- p_prop_type
492:
493: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
494: FEM_ENGINES_PKG.TECH_MESSAGE(
495: p_severity => FND_LOG.level_statement,
496: p_module => C_MODULE,
497: p_msg_text => 'v_sql(20) = '||v_sql);
498: END IF;
499:

Line 541: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

537: ELSIF p_col_req_type = 'FIXED_AND_ANY_VSR_DIM_COL' THEN
538: v_sql := v_sql||' AND nvl(x.value_set_required_flag,''N'') = ''N''';
539: END IF;
540:
541: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FEM_ENGINES_PKG.TECH_MESSAGE(
543: p_severity => FND_LOG.level_statement,
544: p_module => C_MODULE,
545: p_msg_text => 'v_sql(30) = '||v_sql);

Line 543: p_severity => FND_LOG.level_statement,

539: END IF;
540:
541: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FEM_ENGINES_PKG.TECH_MESSAGE(
543: p_severity => FND_LOG.level_statement,
544: p_module => C_MODULE,
545: p_msg_text => 'v_sql(30) = '||v_sql);
546: END IF;
547:

Line 605: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

601: END IF; -- p_col_req_type
602: END LOOP;
603: CLOSE cols_cv;
604:
605: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
606: FEM_ENGINES_PKG.TECH_MESSAGE(
607: p_severity => FND_LOG.level_statement,
608: p_module => C_MODULE,
609: p_msg_text => 'v_count = '||v_count||'; v_vsr_count = '||v_vsr_count);

Line 607: p_severity => FND_LOG.level_statement,

603: CLOSE cols_cv;
604:
605: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
606: FEM_ENGINES_PKG.TECH_MESSAGE(
607: p_severity => FND_LOG.level_statement,
608: p_module => C_MODULE,
609: p_msg_text => 'v_count = '||v_count||'; v_vsr_count = '||v_vsr_count);
610: END IF;
611:

Line 677: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

673: END IF; -- p_col_req_type NOT IN ('FIXED_ANY','ONE_ANY')
674:
675: x_passed_validation := v_passed_valid;
676:
677: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
678: FEM_ENGINES_PKG.TECH_MESSAGE(
679: p_severity => FND_LOG.level_statement,
680: p_module => C_MODULE,
681: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 679: p_severity => FND_LOG.level_statement,

675: x_passed_validation := v_passed_valid;
676:
677: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
678: FEM_ENGINES_PKG.TECH_MESSAGE(
679: p_severity => FND_LOG.level_statement,
680: p_module => C_MODULE,
681: p_msg_text => 'x_passed_validation = '||x_passed_validation);
682: END IF;
683: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 683: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

679: p_severity => FND_LOG.level_statement,
680: p_module => C_MODULE,
681: p_msg_text => 'x_passed_validation = '||x_passed_validation);
682: END IF;
683: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
684: FEM_ENGINES_PKG.TECH_MESSAGE(
685: p_severity => FND_LOG.level_procedure,
686: p_module => C_MODULE,
687: p_msg_text => 'End Procedure');

Line 685: p_severity => FND_LOG.level_procedure,

681: p_msg_text => 'x_passed_validation = '||x_passed_validation);
682: END IF;
683: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
684: FEM_ENGINES_PKG.TECH_MESSAGE(
685: p_severity => FND_LOG.level_procedure,
686: p_module => C_MODULE,
687: p_msg_text => 'End Procedure');
688: END IF;
689:

Line 692: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

688: END IF;
689:
690: EXCEPTION
691: WHEN others THEN
692: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: FEM_ENGINES_PKG.TECH_MESSAGE(
694: p_severity => FND_LOG.level_exception,
695: p_module => C_MODULE,
696: p_msg_text => 'Validate_Prop_Col_Req failed unexpectedly: '||SQLERRM);

Line 694: p_severity => FND_LOG.level_exception,

690: EXCEPTION
691: WHEN others THEN
692: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: FEM_ENGINES_PKG.TECH_MESSAGE(
694: p_severity => FND_LOG.level_exception,
695: p_module => C_MODULE,
696: p_msg_text => 'Validate_Prop_Col_Req failed unexpectedly: '||SQLERRM);
697: END IF;
698: x_passed_validation := c_false;

Line 716: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

712: p_tab_class_cd IN VARCHAR2,
713: p_tab_owner IN VARCHAR2,
714: p_db_tab_name IN VARCHAR2,
715: x_passed_validation OUT NOCOPY VARCHAR2) IS
716: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
717: 'fem.plsql.fem_admin_util_pkg.validate_pk_cols_not_null';
718:
719: CURSOR c_null_cols (p_tab_name VARCHAR2, p_owner VARCHAR2) IS
720: SELECT a.column_name

Line 733: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

729:
730: v_count NUMBER;
731: v_col_list VARCHAR2(2000);
732: BEGIN
733: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
734: FEM_ENGINES_PKG.TECH_MESSAGE(
735: p_severity => FND_LOG.level_procedure,
736: p_module => C_MODULE,
737: p_msg_text => 'Begin Procedure');

Line 735: p_severity => FND_LOG.level_procedure,

731: v_col_list VARCHAR2(2000);
732: BEGIN
733: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
734: FEM_ENGINES_PKG.TECH_MESSAGE(
735: p_severity => FND_LOG.level_procedure,
736: p_module => C_MODULE,
737: p_msg_text => 'Begin Procedure');
738: END IF;
739:

Line 763: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

759: p_value1 => v_col_list);
760: x_passed_validation := c_false;
761: END IF;
762:
763: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
764: FEM_ENGINES_PKG.TECH_MESSAGE(
765: p_severity => FND_LOG.level_statement,
766: p_module => C_MODULE,
767: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 765: p_severity => FND_LOG.level_statement,

761: END IF;
762:
763: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
764: FEM_ENGINES_PKG.TECH_MESSAGE(
765: p_severity => FND_LOG.level_statement,
766: p_module => C_MODULE,
767: p_msg_text => 'x_passed_validation = '||x_passed_validation);
768: END IF;
769: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 769: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

765: p_severity => FND_LOG.level_statement,
766: p_module => C_MODULE,
767: p_msg_text => 'x_passed_validation = '||x_passed_validation);
768: END IF;
769: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
770: FEM_ENGINES_PKG.TECH_MESSAGE(
771: p_severity => FND_LOG.level_procedure,
772: p_module => C_MODULE,
773: p_msg_text => 'End Procedure');

Line 771: p_severity => FND_LOG.level_procedure,

767: p_msg_text => 'x_passed_validation = '||x_passed_validation);
768: END IF;
769: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
770: FEM_ENGINES_PKG.TECH_MESSAGE(
771: p_severity => FND_LOG.level_procedure,
772: p_module => C_MODULE,
773: p_msg_text => 'End Procedure');
774: END IF;
775: EXCEPTION

Line 777: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

773: p_msg_text => 'End Procedure');
774: END IF;
775: EXCEPTION
776: WHEN others THEN
777: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
778: FEM_ENGINES_PKG.TECH_MESSAGE(
779: p_severity => FND_LOG.level_exception,
780: p_module => C_MODULE,
781: p_msg_text => 'Validate_PK_Cols_Not_Null failed unexpectedly: '||SQLERRM);

Line 779: p_severity => FND_LOG.level_exception,

775: EXCEPTION
776: WHEN others THEN
777: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
778: FEM_ENGINES_PKG.TECH_MESSAGE(
779: p_severity => FND_LOG.level_exception,
780: p_module => C_MODULE,
781: p_msg_text => 'Validate_PK_Cols_Not_Null failed unexpectedly: '||SQLERRM);
782: END IF;
783: x_passed_validation := c_false;

Line 794: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

790: PROCEDURE Validate_Editable (
791: p_tab_name IN VARCHAR2,
792: p_tab_class_cd IN VARCHAR2,
793: x_passed_validation OUT NOCOPY VARCHAR2) IS
794: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
795: 'fem.plsql.fem_admin_util_pkg.validate_editable';
796:
797: v_obj_type USER_OBJECTS.object_type%TYPE;
798: v_count NUMBER;

Line 800: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

796:
797: v_obj_type USER_OBJECTS.object_type%TYPE;
798: v_count NUMBER;
799: BEGIN
800: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
801: FEM_ENGINES_PKG.TECH_MESSAGE(
802: p_severity => FND_LOG.level_procedure,
803: p_module => C_MODULE,
804: p_msg_text => 'Begin Procedure');

Line 802: p_severity => FND_LOG.level_procedure,

798: v_count NUMBER;
799: BEGIN
800: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
801: FEM_ENGINES_PKG.TECH_MESSAGE(
802: p_severity => FND_LOG.level_procedure,
803: p_module => C_MODULE,
804: p_msg_text => 'Begin Procedure');
805: END IF;
806:

Line 812: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

808: INTO v_obj_type
809: FROM user_objects
810: WHERE object_name = p_tab_name;
811:
812: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
813: FEM_ENGINES_PKG.TECH_MESSAGE(
814: p_severity => FND_LOG.level_statement,
815: p_module => C_MODULE,
816: p_msg_text => 'v_obj_type = '||v_obj_type);

Line 814: p_severity => FND_LOG.level_statement,

810: WHERE object_name = p_tab_name;
811:
812: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
813: FEM_ENGINES_PKG.TECH_MESSAGE(
814: p_severity => FND_LOG.level_statement,
815: p_module => C_MODULE,
816: p_msg_text => 'v_obj_type = '||v_obj_type);
817: END IF;
818:

Line 843: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

839: ELSE
840: x_passed_validation := c_false;
841: END IF; -- v_obj_type
842:
843: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
844: FEM_ENGINES_PKG.TECH_MESSAGE(
845: p_severity => FND_LOG.level_statement,
846: p_module => C_MODULE,
847: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 845: p_severity => FND_LOG.level_statement,

841: END IF; -- v_obj_type
842:
843: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
844: FEM_ENGINES_PKG.TECH_MESSAGE(
845: p_severity => FND_LOG.level_statement,
846: p_module => C_MODULE,
847: p_msg_text => 'x_passed_validation = '||x_passed_validation);
848: END IF;
849: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 849: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

845: p_severity => FND_LOG.level_statement,
846: p_module => C_MODULE,
847: p_msg_text => 'x_passed_validation = '||x_passed_validation);
848: END IF;
849: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
850: FEM_ENGINES_PKG.TECH_MESSAGE(
851: p_severity => FND_LOG.level_procedure,
852: p_module => C_MODULE,
853: p_msg_text => 'End Procedure');

Line 851: p_severity => FND_LOG.level_procedure,

847: p_msg_text => 'x_passed_validation = '||x_passed_validation);
848: END IF;
849: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
850: FEM_ENGINES_PKG.TECH_MESSAGE(
851: p_severity => FND_LOG.level_procedure,
852: p_module => C_MODULE,
853: p_msg_text => 'End Procedure');
854: END IF;
855: EXCEPTION

Line 857: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

853: p_msg_text => 'End Procedure');
854: END IF;
855: EXCEPTION
856: WHEN others THEN
857: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
858: FEM_ENGINES_PKG.TECH_MESSAGE(
859: p_severity => FND_LOG.level_exception,
860: p_module => C_MODULE,
861: p_msg_text => 'Validate_Editable failed unexpectedly: '||SQLERRM);

Line 859: p_severity => FND_LOG.level_exception,

855: EXCEPTION
856: WHEN others THEN
857: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
858: FEM_ENGINES_PKG.TECH_MESSAGE(
859: p_severity => FND_LOG.level_exception,
860: p_module => C_MODULE,
861: p_msg_text => 'Validate_Editable failed unexpectedly: '||SQLERRM);
862: END IF;
863: x_passed_validation := c_false;

Line 877: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

873: PROCEDURE Validate_Table_Name_Restrict (
874: p_tab_name IN VARCHAR2,
875: p_tab_class_cd IN VARCHAR2,
876: x_passed_validation OUT NOCOPY VARCHAR2) IS
877: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
878: 'fem.plsql.fem_admin_util_pkg.validate_table_name_restriction';
879: BEGIN
880: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
881: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 880: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

876: x_passed_validation OUT NOCOPY VARCHAR2) IS
877: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
878: 'fem.plsql.fem_admin_util_pkg.validate_table_name_restriction';
879: BEGIN
880: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
881: FEM_ENGINES_PKG.TECH_MESSAGE(
882: p_severity => FND_LOG.level_procedure,
883: p_module => C_MODULE,
884: p_msg_text => 'Begin Procedure');

Line 882: p_severity => FND_LOG.level_procedure,

878: 'fem.plsql.fem_admin_util_pkg.validate_table_name_restriction';
879: BEGIN
880: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
881: FEM_ENGINES_PKG.TECH_MESSAGE(
882: p_severity => FND_LOG.level_procedure,
883: p_module => C_MODULE,
884: p_msg_text => 'Begin Procedure');
885: END IF;
886:

Line 901: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

897:
898: x_passed_validation := c_false;
899: END IF;
900:
901: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
902: FEM_ENGINES_PKG.TECH_MESSAGE(
903: p_severity => FND_LOG.level_procedure,
904: p_module => C_MODULE,
905: p_msg_text => 'End Procedure');

Line 903: p_severity => FND_LOG.level_procedure,

899: END IF;
900:
901: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
902: FEM_ENGINES_PKG.TECH_MESSAGE(
903: p_severity => FND_LOG.level_procedure,
904: p_module => C_MODULE,
905: p_msg_text => 'End Procedure');
906: END IF;
907: EXCEPTION

Line 909: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

905: p_msg_text => 'End Procedure');
906: END IF;
907: EXCEPTION
908: WHEN others THEN
909: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
910: FEM_ENGINES_PKG.TECH_MESSAGE(
911: p_severity => FND_LOG.level_exception,
912: p_module => C_MODULE,
913: p_msg_text => 'Validate_Table_Name_Restriction failed unexpectedly: '||SQLERRM);

Line 911: p_severity => FND_LOG.level_exception,

907: EXCEPTION
908: WHEN others THEN
909: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
910: FEM_ENGINES_PKG.TECH_MESSAGE(
911: p_severity => FND_LOG.level_exception,
912: p_module => C_MODULE,
913: p_msg_text => 'Validate_Table_Name_Restriction failed unexpectedly: '||SQLERRM);
914: END IF;
915: x_passed_validation := c_false;

Line 958: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

954: p_tab_class_cd IN VARCHAR2,
955: p_tab_owner IN VARCHAR2,
956: p_db_tab_name IN VARCHAR2,
957: x_passed_validation OUT NOCOPY VARCHAR2) IS
958: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
959: 'fem.plsql.fem_admin_util_pkg.validate_data_loader';
960:
961: CURSOR c_uniq_idx(p_owner VARCHAR2, p_name VARCHAR2) IS
962: SELECT index_name

Line 1044: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1040: v_dim_dc_data_type ALL_TAB_COLUMNS.data_type%TYPE;
1041: v_mbr_b_owner ALL_TABLES.owner%TYPE;
1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;
1043: BEGIN
1044: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1045: FEM_ENGINES_PKG.TECH_MESSAGE(
1046: p_severity => FND_LOG.level_procedure,
1047: p_module => C_MODULE,
1048: p_msg_text => 'Begin Procedure');

Line 1046: p_severity => FND_LOG.level_procedure,

1042: v_mbr_b_table_name ALL_TABLES.table_name%TYPE;
1043: BEGIN
1044: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1045: FEM_ENGINES_PKG.TECH_MESSAGE(
1046: p_severity => FND_LOG.level_procedure,
1047: p_module => C_MODULE,
1048: p_msg_text => 'Begin Procedure');
1049: END IF;
1050:

Line 1073: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1069: x_tab_name => v_int_db_tab_name,
1070: x_tab_owner => v_int_owner);
1071:
1072: IF v_return_status <> c_success THEN
1073: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1074: FEM_ENGINES_PKG.TECH_MESSAGE(
1075: p_severity => FND_LOG.level_statement,
1076: p_module => C_MODULE,
1077: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');

Line 1075: p_severity => FND_LOG.level_statement,

1071:
1072: IF v_return_status <> c_success THEN
1073: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1074: FEM_ENGINES_PKG.TECH_MESSAGE(
1075: p_severity => FND_LOG.level_statement,
1076: p_module => C_MODULE,
1077: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1078: END IF;
1079: RAISE e_unexp;

Line 1081: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1077: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1078: END IF;
1079: RAISE e_unexp;
1080: ELSE
1081: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1082: FEM_ENGINES_PKG.TECH_MESSAGE(
1083: p_severity => FND_LOG.level_statement,
1084: p_module => C_MODULE,
1085: p_msg_text => 'v_int_db_tab_name = '||v_int_db_tab_name);

Line 1083: p_severity => FND_LOG.level_statement,

1079: RAISE e_unexp;
1080: ELSE
1081: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1082: FEM_ENGINES_PKG.TECH_MESSAGE(
1083: p_severity => FND_LOG.level_statement,
1084: p_module => C_MODULE,
1085: p_msg_text => 'v_int_db_tab_name = '||v_int_db_tab_name);
1086: END IF;
1087: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1087: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1083: p_severity => FND_LOG.level_statement,
1084: p_module => C_MODULE,
1085: p_msg_text => 'v_int_db_tab_name = '||v_int_db_tab_name);
1086: END IF;
1087: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1088: FEM_ENGINES_PKG.TECH_MESSAGE(
1089: p_severity => FND_LOG.level_statement,
1090: p_module => C_MODULE,
1091: p_msg_text => 'v_int_owner = '||v_int_owner);

Line 1089: p_severity => FND_LOG.level_statement,

1085: p_msg_text => 'v_int_db_tab_name = '||v_int_db_tab_name);
1086: END IF;
1087: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1088: FEM_ENGINES_PKG.TECH_MESSAGE(
1089: p_severity => FND_LOG.level_statement,
1090: p_module => C_MODULE,
1091: p_msg_text => 'v_int_owner = '||v_int_owner);
1092: END IF;
1093: END IF;

Line 1158: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1154: END IF;
1155: END LOOP;
1156:
1157: IF v_count <> 1111 THEN
1158: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1159: FEM_ENGINES_PKG.TECH_MESSAGE(
1160: p_severity => FND_LOG.level_statement,
1161: p_module => C_MODULE,
1162: p_msg_text => 'v_count (int_reqcol) = '||v_count);

Line 1160: p_severity => FND_LOG.level_statement,

1156:
1157: IF v_count <> 1111 THEN
1158: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1159: FEM_ENGINES_PKG.TECH_MESSAGE(
1160: p_severity => FND_LOG.level_statement,
1161: p_module => C_MODULE,
1162: p_msg_text => 'v_count (int_reqcol) = '||v_count);
1163: END IF;
1164: Log_Table_Class_Error(

Line 1255: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1251: x_tab_name => v_mbr_b_table_name,
1252: x_tab_owner => v_mbr_b_owner);
1253:
1254: IF v_return_status <> c_success THEN
1255: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: FEM_ENGINES_PKG.TECH_MESSAGE(
1257: p_severity => FND_LOG.level_statement,
1258: p_module => C_MODULE,
1259: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');

Line 1257: p_severity => FND_LOG.level_statement,

1253:
1254: IF v_return_status <> c_success THEN
1255: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1256: FEM_ENGINES_PKG.TECH_MESSAGE(
1257: p_severity => FND_LOG.level_statement,
1258: p_module => C_MODULE,
1259: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1260: END IF;
1261: RAISE e_unexp;

Line 1263: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1259: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
1260: END IF;
1261: RAISE e_unexp;
1262: ELSE
1263: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1264: FEM_ENGINES_PKG.TECH_MESSAGE(
1265: p_severity => FND_LOG.level_statement,
1266: p_module => C_MODULE,
1267: p_msg_text => 'v_mbr_b_table_name = '||v_mbr_b_table_name);

Line 1265: p_severity => FND_LOG.level_statement,

1261: RAISE e_unexp;
1262: ELSE
1263: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1264: FEM_ENGINES_PKG.TECH_MESSAGE(
1265: p_severity => FND_LOG.level_statement,
1266: p_module => C_MODULE,
1267: p_msg_text => 'v_mbr_b_table_name = '||v_mbr_b_table_name);
1268: END IF;
1269: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1269: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1265: p_severity => FND_LOG.level_statement,
1266: p_module => C_MODULE,
1267: p_msg_text => 'v_mbr_b_table_name = '||v_mbr_b_table_name);
1268: END IF;
1269: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1270: FEM_ENGINES_PKG.TECH_MESSAGE(
1271: p_severity => FND_LOG.level_statement,
1272: p_module => C_MODULE,
1273: p_msg_text => 'v_mbr_b_owner = '||v_mbr_b_owner);

Line 1271: p_severity => FND_LOG.level_statement,

1267: p_msg_text => 'v_mbr_b_table_name = '||v_mbr_b_table_name);
1268: END IF;
1269: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1270: FEM_ENGINES_PKG.TECH_MESSAGE(
1271: p_severity => FND_LOG.level_statement,
1272: p_module => C_MODULE,
1273: p_msg_text => 'v_mbr_b_owner = '||v_mbr_b_owner);
1274: END IF;
1275: END IF;

Line 1445: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1441: END IF;
1442:
1443: x_passed_validation := v_passed_valid;
1444:
1445: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1446: FEM_ENGINES_PKG.TECH_MESSAGE(
1447: p_severity => FND_LOG.level_statement,
1448: p_module => C_MODULE,
1449: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 1447: p_severity => FND_LOG.level_statement,

1443: x_passed_validation := v_passed_valid;
1444:
1445: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1446: FEM_ENGINES_PKG.TECH_MESSAGE(
1447: p_severity => FND_LOG.level_statement,
1448: p_module => C_MODULE,
1449: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1450: END IF;
1451: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1451: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1447: p_severity => FND_LOG.level_statement,
1448: p_module => C_MODULE,
1449: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1450: END IF;
1451: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1452: FEM_ENGINES_PKG.TECH_MESSAGE(
1453: p_severity => FND_LOG.level_procedure,
1454: p_module => C_MODULE,
1455: p_msg_text => 'End Procedure');

Line 1453: p_severity => FND_LOG.level_procedure,

1449: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1450: END IF;
1451: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1452: FEM_ENGINES_PKG.TECH_MESSAGE(
1453: p_severity => FND_LOG.level_procedure,
1454: p_module => C_MODULE,
1455: p_msg_text => 'End Procedure');
1456: END IF;
1457: EXCEPTION

Line 1462: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1458: WHEN e_error THEN
1459: x_passed_validation := c_false;
1460:
1461: WHEN others THEN
1462: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1463: FEM_ENGINES_PKG.TECH_MESSAGE(
1464: p_severity => FND_LOG.level_exception,
1465: p_module => C_MODULE,
1466: p_msg_text => 'Validate_Data_Loader failed unexpectedly: '||SQLERRM);

Line 1464: p_severity => FND_LOG.level_exception,

1460:
1461: WHEN others THEN
1462: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1463: FEM_ENGINES_PKG.TECH_MESSAGE(
1464: p_severity => FND_LOG.level_exception,
1465: p_module => C_MODULE,
1466: p_msg_text => 'Validate_Data_Loader failed unexpectedly: '||SQLERRM);
1467: END IF;
1468: Log_Table_Class_Error(

Line 1501: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1497: x_msg_data OUT NOCOPY VARCHAR2,
1498: p_object_id IN NUMBER
1499: ) IS
1500:
1501: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1502: 'fem.plsql.fem_admin_util_pkg.delete_obj_tuning_options';
1503: C_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Obj_Tuning_Options';
1504:
1505: v_process_ds_cd NUMBER;

Line 1519: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1515:
1516: -- Initialize return status to unexpected error
1517: x_return_status := c_unexp;
1518:
1519: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1520: FEM_ENGINES_PKG.TECH_MESSAGE(
1521: p_severity => FND_LOG.level_procedure,
1522: p_module => C_MODULE,
1523: p_msg_text => 'Begin Procedure');

Line 1521: p_severity => FND_LOG.level_procedure,

1517: x_return_status := c_unexp;
1518:
1519: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1520: FEM_ENGINES_PKG.TECH_MESSAGE(
1521: p_severity => FND_LOG.level_procedure,
1522: p_module => C_MODULE,
1523: p_msg_text => 'Begin Procedure');
1524: END IF;
1525:

Line 1536: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1532: p_api_version,
1533: C_API_NAME,
1534: G_PKG_NAME)
1535: THEN
1536: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1537: FEM_ENGINES_PKG.TECH_MESSAGE(
1538: p_severity => FND_LOG.level_statement,
1539: p_module => C_MODULE,
1540: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 1538: p_severity => FND_LOG.level_statement,

1534: G_PKG_NAME)
1535: THEN
1536: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1537: FEM_ENGINES_PKG.TECH_MESSAGE(
1538: p_severity => FND_LOG.level_statement,
1539: p_module => C_MODULE,
1540: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
1541: ||'passed in version ('||p_api_version||')');
1542: END IF;

Line 1594: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1590: p_data => x_msg_data);
1591:
1592: x_return_status := c_success;
1593:
1594: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1595: FEM_ENGINES_PKG.TECH_MESSAGE(
1596: p_severity => FND_LOG.level_procedure,
1597: p_module => C_MODULE,
1598: p_msg_text => 'End Procedure');

Line 1596: p_severity => FND_LOG.level_procedure,

1592: x_return_status := c_success;
1593:
1594: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1595: FEM_ENGINES_PKG.TECH_MESSAGE(
1596: p_severity => FND_LOG.level_procedure,
1597: p_module => C_MODULE,
1598: p_msg_text => 'End Procedure');
1599: END IF;
1600:

Line 1603: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1599: END IF;
1600:
1601: EXCEPTION
1602: WHEN others THEN
1603: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1604: FEM_ENGINES_PKG.TECH_MESSAGE(
1605: p_severity => FND_LOG.level_exception,
1606: p_module => C_MODULE,
1607: p_msg_text => 'Unexpected error: '||SQLERRM);

Line 1605: p_severity => FND_LOG.level_exception,

1601: EXCEPTION
1602: WHEN others THEN
1603: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1604: FEM_ENGINES_PKG.TECH_MESSAGE(
1605: p_severity => FND_LOG.level_exception,
1606: p_module => C_MODULE,
1607: p_msg_text => 'Unexpected error: '||SQLERRM);
1608: END IF;
1609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1605: p_severity => FND_LOG.level_exception,
1606: p_module => C_MODULE,
1607: p_msg_text => 'Unexpected error: '||SQLERRM);
1608: END IF;
1609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FEM_ENGINES_PKG.TECH_MESSAGE(
1611: p_severity => FND_LOG.level_procedure,
1612: p_module => C_MODULE,
1613: p_msg_text => 'End Procedure');

Line 1611: p_severity => FND_LOG.level_procedure,

1607: p_msg_text => 'Unexpected error: '||SQLERRM);
1608: END IF;
1609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1610: FEM_ENGINES_PKG.TECH_MESSAGE(
1611: p_severity => FND_LOG.level_procedure,
1612: p_module => C_MODULE,
1613: p_msg_text => 'End Procedure');
1614: END IF;
1615: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 1673: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1669: p_db_tab_name IN VARCHAR2,
1670: x_passed_validation OUT NOCOPY VARCHAR2
1671: )
1672: IS
1673: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1674: 'fem.plsql.fem_admin_util_pkg.validate_column_req';
1675:
1676: -- Cursor to fetch all registered columns that match
1677: -- those in FEM_COLUMN_REQUIREMNT_B

Line 1702: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1698: v_passed_valid VARCHAR2(1);
1699: v_fem_data_type_name FEM_TAB_COLUMNS_B.fem_data_type_code%TYPE;
1700: BEGIN
1701:
1702: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1703: FEM_ENGINES_PKG.TECH_MESSAGE(
1704: p_severity => FND_LOG.level_procedure,
1705: p_module => C_MODULE,
1706: p_msg_text => 'Begin Procedure');

Line 1704: p_severity => FND_LOG.level_procedure,

1700: BEGIN
1701:
1702: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1703: FEM_ENGINES_PKG.TECH_MESSAGE(
1704: p_severity => FND_LOG.level_procedure,
1705: p_module => C_MODULE,
1706: p_msg_text => 'Begin Procedure');
1707: END IF;
1708: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1708: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1704: p_severity => FND_LOG.level_procedure,
1705: p_module => C_MODULE,
1706: p_msg_text => 'Begin Procedure');
1707: END IF;
1708: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: FEM_ENGINES_PKG.TECH_MESSAGE(
1710: p_severity => FND_LOG.level_statement,
1711: p_module => C_MODULE,
1712: p_msg_text => 'p_tab_class_cd = '||p_tab_class_cd);

Line 1710: p_severity => FND_LOG.level_statement,

1706: p_msg_text => 'Begin Procedure');
1707: END IF;
1708: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1709: FEM_ENGINES_PKG.TECH_MESSAGE(
1710: p_severity => FND_LOG.level_statement,
1711: p_module => C_MODULE,
1712: p_msg_text => 'p_tab_class_cd = '||p_tab_class_cd);
1713: END IF;
1714:

Line 1782: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1778: END LOOP; -- c_req_col
1779:
1780: x_passed_validation := v_passed_valid;
1781:
1782: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1783: FEM_ENGINES_PKG.TECH_MESSAGE(
1784: p_severity => FND_LOG.level_statement,
1785: p_module => C_MODULE,
1786: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 1784: p_severity => FND_LOG.level_statement,

1780: x_passed_validation := v_passed_valid;
1781:
1782: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1783: FEM_ENGINES_PKG.TECH_MESSAGE(
1784: p_severity => FND_LOG.level_statement,
1785: p_module => C_MODULE,
1786: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1787: END IF;
1788: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1788: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1784: p_severity => FND_LOG.level_statement,
1785: p_module => C_MODULE,
1786: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1787: END IF;
1788: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1789: FEM_ENGINES_PKG.TECH_MESSAGE(
1790: p_severity => FND_LOG.level_procedure,
1791: p_module => C_MODULE,
1792: p_msg_text => 'End Procedure');

Line 1790: p_severity => FND_LOG.level_procedure,

1786: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1787: END IF;
1788: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1789: FEM_ENGINES_PKG.TECH_MESSAGE(
1790: p_severity => FND_LOG.level_procedure,
1791: p_module => C_MODULE,
1792: p_msg_text => 'End Procedure');
1793: END IF;
1794: EXCEPTION

Line 1796: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1792: p_msg_text => 'End Procedure');
1793: END IF;
1794: EXCEPTION
1795: WHEN others THEN
1796: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1797: FEM_ENGINES_PKG.TECH_MESSAGE(
1798: p_severity => FND_LOG.level_exception,
1799: p_module => C_MODULE,
1800: p_msg_text => 'Validate_Column_Req failed unexpectedly: '||SQLERRM);

Line 1798: p_severity => FND_LOG.level_exception,

1794: EXCEPTION
1795: WHEN others THEN
1796: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1797: FEM_ENGINES_PKG.TECH_MESSAGE(
1798: p_severity => FND_LOG.level_exception,
1799: p_module => C_MODULE,
1800: p_msg_text => 'Validate_Column_Req failed unexpectedly: '||SQLERRM);
1801: END IF;
1802: Log_Table_Class_Error(

Line 1837: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

1833: p_db_tab_name IN VARCHAR2,
1834: x_passed_validation OUT NOCOPY VARCHAR2
1835: )
1836: IS
1837: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
1838: 'fem.plsql.fem_admin_util_pkg.validate_processing_key_idx';
1839:
1840: v_count NUMBER;
1841: v_idx_name FEM_TABLES_B.proc_key_index_name%TYPE;

Line 1850: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1846: e_exit_successfully EXCEPTION;
1847: e_mismatch_idx EXCEPTION;
1848: BEGIN
1849:
1850: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1851: FEM_ENGINES_PKG.TECH_MESSAGE(
1852: p_severity => FND_LOG.level_procedure,
1853: p_module => C_MODULE,
1854: p_msg_text => 'Begin Procedure');

Line 1852: p_severity => FND_LOG.level_procedure,

1848: BEGIN
1849:
1850: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1851: FEM_ENGINES_PKG.TECH_MESSAGE(
1852: p_severity => FND_LOG.level_procedure,
1853: p_module => C_MODULE,
1854: p_msg_text => 'Begin Procedure');
1855: END IF;
1856:

Line 1866: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1862: INTO v_idx_name, v_idx_owner
1863: FROM fem_tables_b
1864: WHERE table_name = p_tab_name;
1865:
1866: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FEM_ENGINES_PKG.TECH_MESSAGE(
1868: p_severity => FND_LOG.level_statement,
1869: p_module => C_MODULE,
1870: p_msg_text => 'Processing key index = '||v_idx_owner||'.'||v_idx_name);

Line 1868: p_severity => FND_LOG.level_statement,

1864: WHERE table_name = p_tab_name;
1865:
1866: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1867: FEM_ENGINES_PKG.TECH_MESSAGE(
1868: p_severity => FND_LOG.level_statement,
1869: p_module => C_MODULE,
1870: p_msg_text => 'Processing key index = '||v_idx_owner||'.'||v_idx_name);
1871: END IF;
1872:

Line 1951: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1947: END IF;
1948:
1949: x_passed_validation := v_matched;
1950:
1951: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1952: FEM_ENGINES_PKG.TECH_MESSAGE(
1953: p_severity => FND_LOG.level_statement,
1954: p_module => C_MODULE,
1955: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 1953: p_severity => FND_LOG.level_statement,

1949: x_passed_validation := v_matched;
1950:
1951: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1952: FEM_ENGINES_PKG.TECH_MESSAGE(
1953: p_severity => FND_LOG.level_statement,
1954: p_module => C_MODULE,
1955: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1956: END IF;
1957: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1957: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1953: p_severity => FND_LOG.level_statement,
1954: p_module => C_MODULE,
1955: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1956: END IF;
1957: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1958: FEM_ENGINES_PKG.TECH_MESSAGE(
1959: p_severity => FND_LOG.level_procedure,
1960: p_module => C_MODULE,
1961: p_msg_text => 'End Procedure');

Line 1959: p_severity => FND_LOG.level_procedure,

1955: p_msg_text => 'x_passed_validation = '||x_passed_validation);
1956: END IF;
1957: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1958: FEM_ENGINES_PKG.TECH_MESSAGE(
1959: p_severity => FND_LOG.level_procedure,
1960: p_module => C_MODULE,
1961: p_msg_text => 'End Procedure');
1962: END IF;
1963: EXCEPTION

Line 1988: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1984:
1985: x_passed_validation := c_false;
1986:
1987: WHEN others THEN
1988: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1989: FEM_ENGINES_PKG.TECH_MESSAGE(
1990: p_severity => FND_LOG.level_exception,
1991: p_module => C_MODULE,
1992: p_msg_text => 'Validate_Column_Req failed unexpectedly: '||SQLERRM);

Line 1990: p_severity => FND_LOG.level_exception,

1986:
1987: WHEN others THEN
1988: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1989: FEM_ENGINES_PKG.TECH_MESSAGE(
1990: p_severity => FND_LOG.level_exception,
1991: p_module => C_MODULE,
1992: p_msg_text => 'Validate_Column_Req failed unexpectedly: '||SQLERRM);
1993: END IF;
1994: Log_Table_Class_Error(

Line 2025: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2021: PROCEDURE Validate_OGL_Dimcol (
2022: p_tab_name IN VARCHAR2,
2023: p_tab_class_cd IN VARCHAR2,
2024: x_passed_validation OUT NOCOPY VARCHAR2) IS
2025: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2026: 'fem.plsql.fem_admin_util_pkg.validate_ogl_dimcol';
2027:
2028: CURSOR c_dimcol (p_name VARCHAR2) IS
2029: SELECT column_name, dimension_id

Line 2066: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2062: v_matched VARCHAR2(1);
2063: v_msg_data VARCHAR2(2000);
2064:
2065: BEGIN
2066: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2067: FEM_ENGINES_PKG.TECH_MESSAGE(
2068: p_severity => FND_LOG.level_procedure,
2069: p_module => C_MODULE,
2070: p_msg_text => 'Begin Procedure');

Line 2068: p_severity => FND_LOG.level_procedure,

2064:
2065: BEGIN
2066: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2067: FEM_ENGINES_PKG.TECH_MESSAGE(
2068: p_severity => FND_LOG.level_procedure,
2069: p_module => C_MODULE,
2070: p_msg_text => 'Begin Procedure');
2071: END IF;
2072:

Line 2124: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2120:
2121:
2122: x_passed_validation := v_passed_valid;
2123:
2124: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2125: FEM_ENGINES_PKG.TECH_MESSAGE(
2126: p_severity => FND_LOG.level_statement,
2127: p_module => C_MODULE,
2128: p_msg_text => 'x_passed_validation = '||x_passed_validation);

Line 2126: p_severity => FND_LOG.level_statement,

2122: x_passed_validation := v_passed_valid;
2123:
2124: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2125: FEM_ENGINES_PKG.TECH_MESSAGE(
2126: p_severity => FND_LOG.level_statement,
2127: p_module => C_MODULE,
2128: p_msg_text => 'x_passed_validation = '||x_passed_validation);
2129: END IF;
2130: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2130: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2126: p_severity => FND_LOG.level_statement,
2127: p_module => C_MODULE,
2128: p_msg_text => 'x_passed_validation = '||x_passed_validation);
2129: END IF;
2130: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2131: FEM_ENGINES_PKG.TECH_MESSAGE(
2132: p_severity => FND_LOG.level_procedure,
2133: p_module => C_MODULE,
2134: p_msg_text => 'End Procedure');

Line 2132: p_severity => FND_LOG.level_procedure,

2128: p_msg_text => 'x_passed_validation = '||x_passed_validation);
2129: END IF;
2130: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2131: FEM_ENGINES_PKG.TECH_MESSAGE(
2132: p_severity => FND_LOG.level_procedure,
2133: p_module => C_MODULE,
2134: p_msg_text => 'End Procedure');
2135: END IF;
2136: EXCEPTION

Line 2141: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2137: WHEN e_error THEN
2138: x_passed_validation := c_false;
2139:
2140: WHEN others THEN
2141: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2142: FEM_ENGINES_PKG.TECH_MESSAGE(
2143: p_severity => FND_LOG.level_exception,
2144: p_module => C_MODULE,
2145: p_msg_text => 'Validate_OGL_Dimcol failed unexpectedly: '||SQLERRM);

Line 2143: p_severity => FND_LOG.level_exception,

2139:
2140: WHEN others THEN
2141: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2142: FEM_ENGINES_PKG.TECH_MESSAGE(
2143: p_severity => FND_LOG.level_exception,
2144: p_module => C_MODULE,
2145: p_msg_text => 'Validate_OGL_Dimcol failed unexpectedly: '||SQLERRM);
2146: END IF;
2147: Log_Table_Class_Error(

Line 2185: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2181: p_tab_class_cd IN VARCHAR2,
2182: x_passed_validation OUT NOCOPY VARCHAR2
2183: )
2184: IS
2185: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2186: 'fem.plsql.fem_admin_util_pkg.validate_tab_class';
2187:
2188: CURSOR c_class_prop (p_class VARCHAR2) IS
2189: SELECT p.table_property_code, p.property_type, p.column_req_type

Line 2212: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2208: v_db_tab_name ALL_TABLES.table_name%TYPE;
2209: v_tab_owner ALL_TABLES.owner%TYPE;
2210: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2211: BEGIN
2212: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2213: FEM_ENGINES_PKG.TECH_MESSAGE(
2214: p_severity => FND_LOG.level_procedure,
2215: p_module => C_MODULE,
2216: p_msg_text => 'Begin Procedure');

Line 2214: p_severity => FND_LOG.level_procedure,

2210: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2211: BEGIN
2212: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2213: FEM_ENGINES_PKG.TECH_MESSAGE(
2214: p_severity => FND_LOG.level_procedure,
2215: p_module => C_MODULE,
2216: p_msg_text => 'Begin Procedure');
2217: END IF;
2218:

Line 2233: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2229: x_tab_name => v_db_tab_name,
2230: x_tab_owner => v_tab_owner);
2231:
2232: IF v_return_status <> c_success THEN
2233: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2234: FEM_ENGINES_PKG.TECH_MESSAGE(
2235: p_severity => FND_LOG.level_statement,
2236: p_module => C_MODULE,
2237: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');

Line 2235: p_severity => FND_LOG.level_statement,

2231:
2232: IF v_return_status <> c_success THEN
2233: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2234: FEM_ENGINES_PKG.TECH_MESSAGE(
2235: p_severity => FND_LOG.level_statement,
2236: p_module => C_MODULE,
2237: p_msg_text => 'Call to FEM_Database_Util_Pkg.Get_Table_Owner failed');
2238: END IF;
2239: RAISE e_unexp;

Line 2321: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2317: p_tab_owner => v_tab_owner,
2318: p_db_tab_name => v_db_tab_name,
2319: x_passed_validation => v_passed_valid_out);
2320: ELSE
2321: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2322: FEM_ENGINES_PKG.TECH_MESSAGE(
2323: p_severity => FND_LOG.level_statement,
2324: p_module => C_MODULE,
2325: p_msg_text => 'No such procedure: '||v_procedure);

Line 2323: p_severity => FND_LOG.level_statement,

2319: x_passed_validation => v_passed_valid_out);
2320: ELSE
2321: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2322: FEM_ENGINES_PKG.TECH_MESSAGE(
2323: p_severity => FND_LOG.level_statement,
2324: p_module => C_MODULE,
2325: p_msg_text => 'No such procedure: '||v_procedure);
2326: END IF;
2327: RAISE e_unexp;

Line 2339: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2335: x_passed_validation := v_passed;
2336:
2337: EXCEPTION
2338: WHEN others THEN
2339: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2340: FEM_ENGINES_PKG.TECH_MESSAGE(
2341: p_severity => FND_LOG.level_exception,
2342: p_module => C_MODULE,
2343: p_msg_text => 'Validate_Tab_Class failed unexpectedly: '||SQLERRM);

Line 2341: p_severity => FND_LOG.level_exception,

2337: EXCEPTION
2338: WHEN others THEN
2339: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2340: FEM_ENGINES_PKG.TECH_MESSAGE(
2341: p_severity => FND_LOG.level_exception,
2342: p_module => C_MODULE,
2343: p_msg_text => 'Validate_Tab_Class failed unexpectedly: '||SQLERRM);
2344: END IF;
2345: Log_Table_Class_Error(

Line 2368: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2364: x_msg_data OUT NOCOPY VARCHAR2,
2365: p_tab_name IN VARCHAR2
2366: )
2367: IS
2368: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2369: 'fem.plsql.fem_admin_util_pkg.validate_tab_class_assignmt';
2370: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Tab_Class_Assignmt';
2371:
2372: v_passed_validation VARCHAR2(1);

Line 2382: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2378: WHERE lookup_type = 'FEM_TABLE_CLASSIFICATION_DSC';
2379:
2380:
2381: BEGIN
2382: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2383: FEM_ENGINES_PKG.TECH_MESSAGE(
2384: p_severity => FND_LOG.level_procedure,
2385: p_module => C_MODULE,
2386: p_msg_text => 'Begin Procedure');

Line 2384: p_severity => FND_LOG.level_procedure,

2380:
2381: BEGIN
2382: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2383: FEM_ENGINES_PKG.TECH_MESSAGE(
2384: p_severity => FND_LOG.level_procedure,
2385: p_module => C_MODULE,
2386: p_msg_text => 'Begin Procedure');
2387: END IF;
2388:

Line 2398: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2394: p_api_version,
2395: C_API_NAME,
2396: G_PKG_NAME)
2397: THEN
2398: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2399: FEM_ENGINES_PKG.TECH_MESSAGE(
2400: p_severity => FND_LOG.level_statement,
2401: p_module => C_MODULE,
2402: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 2400: p_severity => FND_LOG.level_statement,

2396: G_PKG_NAME)
2397: THEN
2398: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2399: FEM_ENGINES_PKG.TECH_MESSAGE(
2400: p_severity => FND_LOG.level_statement,
2401: p_module => C_MODULE,
2402: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
2403: ||'passed in version ('||p_api_version||')');
2404: END IF;

Line 2434: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2430: p_data => x_msg_data);
2431:
2432: x_return_status := c_success;
2433:
2434: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2435: FEM_ENGINES_PKG.TECH_MESSAGE(
2436: p_severity => FND_LOG.level_procedure,
2437: p_module => C_MODULE,
2438: p_msg_text => 'End Procedure');

Line 2436: p_severity => FND_LOG.level_procedure,

2432: x_return_status := c_success;
2433:
2434: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2435: FEM_ENGINES_PKG.TECH_MESSAGE(
2436: p_severity => FND_LOG.level_procedure,
2437: p_module => C_MODULE,
2438: p_msg_text => 'End Procedure');
2439: END IF;
2440:

Line 2443: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2439: END IF;
2440:
2441: EXCEPTION
2442: WHEN others THEN
2443: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2444: FEM_ENGINES_PKG.TECH_MESSAGE(
2445: p_severity => FND_LOG.level_statement,
2446: p_module => C_MODULE,
2447: p_msg_text => 'Unexpected error: '||SQLERRM);

Line 2445: p_severity => FND_LOG.level_statement,

2441: EXCEPTION
2442: WHEN others THEN
2443: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2444: FEM_ENGINES_PKG.TECH_MESSAGE(
2445: p_severity => FND_LOG.level_statement,
2446: p_module => C_MODULE,
2447: p_msg_text => 'Unexpected error: '||SQLERRM);
2448: END IF;
2449: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2449: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2445: p_severity => FND_LOG.level_statement,
2446: p_module => C_MODULE,
2447: p_msg_text => 'Unexpected error: '||SQLERRM);
2448: END IF;
2449: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2450: FEM_ENGINES_PKG.TECH_MESSAGE(
2451: p_severity => FND_LOG.level_procedure,
2452: p_module => C_MODULE,
2453: p_msg_text => 'End Procedure');

Line 2451: p_severity => FND_LOG.level_procedure,

2447: p_msg_text => 'Unexpected error: '||SQLERRM);
2448: END IF;
2449: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2450: FEM_ENGINES_PKG.TECH_MESSAGE(
2451: p_severity => FND_LOG.level_procedure,
2452: p_module => C_MODULE,
2453: p_msg_text => 'End Procedure');
2454: END IF;
2455: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 2493: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2489: p_obj_name IN VARCHAR2,
2490: p_obj_type IN VARCHAR2
2491: )
2492: IS
2493: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2494: 'fem.plsql.fem_admin_util_pkg.validate_obj_class_assignmt';
2495: C_API_NAME CONSTANT VARCHAR2(30) := 'Validate_obj_Class_Assignmt';
2496:
2497: v_passed_validation VARCHAR2(1);

Line 2536: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2532: );
2533:
2534: ELSE IF p_obj_type = 'FEM_VIEW' THEN
2535:
2536: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2537: FEM_ENGINES_PKG.TECH_MESSAGE(
2538: p_severity => FND_LOG.level_procedure,
2539: p_module => C_MODULE,
2540: p_msg_text => 'Begin Procedure');

Line 2538: p_severity => FND_LOG.level_procedure,

2534: ELSE IF p_obj_type = 'FEM_VIEW' THEN
2535:
2536: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2537: FEM_ENGINES_PKG.TECH_MESSAGE(
2538: p_severity => FND_LOG.level_procedure,
2539: p_module => C_MODULE,
2540: p_msg_text => 'Begin Procedure');
2541: END IF;
2542:

Line 2552: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2548: p_api_version,
2549: C_API_NAME,
2550: G_PKG_NAME)
2551: THEN
2552: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2553: FEM_ENGINES_PKG.TECH_MESSAGE(
2554: p_severity => FND_LOG.level_statement,
2555: p_module => C_MODULE,
2556: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '

Line 2554: p_severity => FND_LOG.level_statement,

2550: G_PKG_NAME)
2551: THEN
2552: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2553: FEM_ENGINES_PKG.TECH_MESSAGE(
2554: p_severity => FND_LOG.level_statement,
2555: p_module => C_MODULE,
2556: p_msg_text => 'API Version ('||C_API_VERSION||') not compatible with '
2557: ||'passed in version ('||p_api_version||')');
2558: END IF;

Line 2591: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2587: p_data => x_msg_data);
2588:
2589: x_return_status := c_success;
2590:
2591: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2592: FEM_ENGINES_PKG.TECH_MESSAGE(
2593: p_severity => FND_LOG.level_procedure,
2594: p_module => C_MODULE,
2595: p_msg_text => 'End Procedure');

Line 2593: p_severity => FND_LOG.level_procedure,

2589: x_return_status := c_success;
2590:
2591: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2592: FEM_ENGINES_PKG.TECH_MESSAGE(
2593: p_severity => FND_LOG.level_procedure,
2594: p_module => C_MODULE,
2595: p_msg_text => 'End Procedure');
2596: END IF;
2597:

Line 2603: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2599:
2600: END IF;
2601: EXCEPTION
2602: WHEN others THEN
2603: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2604: FEM_ENGINES_PKG.TECH_MESSAGE(
2605: p_severity => FND_LOG.level_statement,
2606: p_module => C_MODULE,
2607: p_msg_text => 'Unexpected error: '||SQLERRM);

Line 2605: p_severity => FND_LOG.level_statement,

2601: EXCEPTION
2602: WHEN others THEN
2603: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2604: FEM_ENGINES_PKG.TECH_MESSAGE(
2605: p_severity => FND_LOG.level_statement,
2606: p_module => C_MODULE,
2607: p_msg_text => 'Unexpected error: '||SQLERRM);
2608: END IF;
2609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2605: p_severity => FND_LOG.level_statement,
2606: p_module => C_MODULE,
2607: p_msg_text => 'Unexpected error: '||SQLERRM);
2608: END IF;
2609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2610: FEM_ENGINES_PKG.TECH_MESSAGE(
2611: p_severity => FND_LOG.level_procedure,
2612: p_module => C_MODULE,
2613: p_msg_text => 'End Procedure');

Line 2611: p_severity => FND_LOG.level_procedure,

2607: p_msg_text => 'Unexpected error: '||SQLERRM);
2608: END IF;
2609: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2610: FEM_ENGINES_PKG.TECH_MESSAGE(
2611: p_severity => FND_LOG.level_procedure,
2612: p_module => C_MODULE,
2613: p_msg_text => 'End Procedure');
2614: END IF;
2615: FND_MSG_PUB.Count_And_Get(p_encoded => p_encoded,

Line 2648: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2644: -- =========================================================================
2645: -- Returns the underlying table name and table owner for a specified user defined view for the selected index.
2646: -- =========================================================================
2647:
2648: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2649: 'fem.plsql.fem_admin_util_pkg.Get_Table_Owner_for_View';
2650: BEGIN
2651:
2652: x_return_status := c_success;

Line 2679: p_severity => FND_LOG.level_procedure,

2675:
2676: WHEN others THEN
2677:
2678: FEM_ENGINES_PKG.TECH_MESSAGE(
2679: p_severity => FND_LOG.level_procedure,
2680: p_module => C_MODULE,
2681: p_msg_text => 'Unexpected Exception: '||SQLERRM);
2682:
2683: x_return_status := c_error;

Line 2714: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2710: -- =========================================================================
2711: -- Returns the underlying table name and Index owner for a specified user defined view and the selected index.
2712: -- =========================================================================
2713:
2714: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2715: 'fem.plsql.fem_admin_util_pkg.Get_Index_Owner_for_View';
2716:
2717:
2718: BEGIN

Line 2744: p_severity => FND_LOG.level_procedure,

2740: x_tab_name:= NULL;
2741:
2742: WHEN others THEN
2743: FEM_ENGINES_PKG.TECH_MESSAGE(
2744: p_severity => FND_LOG.level_procedure,
2745: p_module => C_MODULE,
2746: p_msg_text => 'Unexpected Exception: '||SQLERRM);
2747:
2748: x_return_status := c_error;

Line 2774: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=

2770: p_tab_class_cd IN VARCHAR2,
2771: x_passed_validation OUT NOCOPY VARCHAR2
2772: )
2773: IS
2774: C_MODULE CONSTANT FND_LOG_MESSAGES.module%TYPE :=
2775: 'fem.plsql.fem_admin_util_pkg.validate_view_class';
2776:
2777: CURSOR c_class_prop (p_class VARCHAR2) IS
2778: SELECT p.table_property_code, p.property_type, p.column_req_type

Line 2803: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2799: v_procedure FEM_TABLE_PROP_STP.stored_procedure_name%TYPE;
2800: l_apps VARCHAR2(30):=USER;
2801:
2802: BEGIN
2803: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2804: FEM_ENGINES_PKG.TECH_MESSAGE(
2805: p_severity => FND_LOG.level_procedure,
2806: p_module => C_MODULE,
2807: p_msg_text => 'Begin Procedure');

Line 2805: p_severity => FND_LOG.level_procedure,

2801:
2802: BEGIN
2803: IF FND_LOG.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2804: FEM_ENGINES_PKG.TECH_MESSAGE(
2805: p_severity => FND_LOG.level_procedure,
2806: p_module => C_MODULE,
2807: p_msg_text => 'Begin Procedure');
2808: END IF;
2809:

Line 2828: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2824: x_tab_name => v_db_tab_name,
2825: x_tab_owner => v_tab_owner);
2826:
2827: IF v_return_status <> c_success THEN
2828: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2829: FEM_ENGINES_PKG.TECH_MESSAGE(
2830: p_severity => FND_LOG.level_statement,
2831: p_module => C_MODULE,
2832: p_msg_text => 'Call to Get_Table_Owner_for_view failed');

Line 2830: p_severity => FND_LOG.level_statement,

2826:
2827: IF v_return_status <> c_success THEN
2828: IF FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2829: FEM_ENGINES_PKG.TECH_MESSAGE(
2830: p_severity => FND_LOG.level_statement,
2831: p_module => C_MODULE,
2832: p_msg_text => 'Call to Get_Table_Owner_for_view failed');
2833: END IF;
2834: RAISE e_unexp;

Line 2897: ELSIF(FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2893: p_tab_owner => v_tab_owner,
2894: p_db_tab_name => v_db_tab_name,
2895: x_passed_validation => v_passed_valid_out);
2896:
2897: ELSIF(FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2898: FEM_ENGINES_PKG.TECH_MESSAGE(
2899: p_severity => FND_LOG.level_statement,
2900: p_module => C_MODULE,
2901: p_msg_text => 'No such procedure: '||v_procedure);

Line 2899: p_severity => FND_LOG.level_statement,

2895: x_passed_validation => v_passed_valid_out);
2896:
2897: ELSIF(FND_LOG.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2898: FEM_ENGINES_PKG.TECH_MESSAGE(
2899: p_severity => FND_LOG.level_statement,
2900: p_module => C_MODULE,
2901: p_msg_text => 'No such procedure: '||v_procedure);
2902:
2903: RAISE e_unexp;

Line 2917: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

2913: x_passed_validation := v_passed;
2914:
2915: EXCEPTION
2916: WHEN others THEN
2917: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2918: FEM_ENGINES_PKG.TECH_MESSAGE(
2919: p_severity => FND_LOG.level_exception,
2920: p_module => C_MODULE,
2921: p_msg_text => 'Validate_Tab_Class failed unexpectedly: '||SQLERRM);

Line 2919: p_severity => FND_LOG.level_exception,

2915: EXCEPTION
2916: WHEN others THEN
2917: IF FND_LOG.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2918: FEM_ENGINES_PKG.TECH_MESSAGE(
2919: p_severity => FND_LOG.level_exception,
2920: p_module => C_MODULE,
2921: p_msg_text => 'Validate_Tab_Class failed unexpectedly: '||SQLERRM);
2922: END IF;
2923: Log_Table_Class_Error(