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 FEM_ENGINES_PKG

Line 37: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
41: END IF;

Line 50: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
54: END IF;

Line 137: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
141: END IF;

Line 161: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
165: END IF;

Line 202: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
206: END IF;

Line 246: FEM_ENGINES_PKG.TECH_MESSAGE(

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 '
250: ||'did not return successfully: status = '

Line 267: FEM_ENGINES_PKG.TECH_MESSAGE(

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
271: ||' , object def id = '||v_obj_def_id);

Line 324: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
328: END IF;

Line 335: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
339: END IF;

Line 388: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
392: END IF;

Line 394: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
398: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 398: FEM_ENGINES_PKG.TECH_MESSAGE(

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,
400: p_module => C_MODULE,
401: p_msg_text => 'p_tab_class_cd = '||p_tab_class_cd);
402: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 402: FEM_ENGINES_PKG.TECH_MESSAGE(

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,
404: p_module => C_MODULE,
405: p_msg_text => 'p_tab_prop_cd = '||p_tab_prop_cd);
406: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 406: FEM_ENGINES_PKG.TECH_MESSAGE(

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,
408: p_module => C_MODULE,
409: p_msg_text => 'p_prop_type = '||p_prop_type);
410: FEM_ENGINES_PKG.TECH_MESSAGE(

Line 410: FEM_ENGINES_PKG.TECH_MESSAGE(

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,
412: p_module => C_MODULE,
413: p_msg_text => 'p_col_req_type = '||p_col_req_type);
414: END IF;

Line 449: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
453: END IF;

Line 494: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
498: END IF;

Line 542: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
546: END IF;

Line 606: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
610: END IF;

Line 678: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
682: END IF;

Line 684: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
688: END IF;

Line 693: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
697: END IF;

Line 734: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
738: END IF;

Line 764: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
768: END IF;

Line 770: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
774: END IF;

Line 778: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
782: END IF;

Line 801: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
805: END IF;

Line 813: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
817: END IF;

Line 844: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
848: END IF;

Line 850: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
854: END IF;

Line 858: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
862: END IF;

Line 881: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
885: END IF;

Line 902: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
906: END IF;

Line 910: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
914: END IF;

Line 1045: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1049: END IF;

Line 1074: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1078: END IF;

Line 1082: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1086: END IF;

Line 1088: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1092: END IF;

Line 1159: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1163: END IF;

Line 1256: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1260: END IF;

Line 1264: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1268: END IF;

Line 1270: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1274: END IF;

Line 1446: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1450: END IF;

Line 1452: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1456: END IF;

Line 1463: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1467: END IF;

Line 1520: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1524: END IF;

Line 1537: FEM_ENGINES_PKG.TECH_MESSAGE(

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 '
1541: ||'passed in version ('||p_api_version||')');

Line 1595: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1599: END IF;

Line 1604: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1608: END IF;

Line 1610: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1614: END IF;

Line 1703: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1707: END IF;

Line 1709: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1713: END IF;

Line 1783: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1787: END IF;

Line 1789: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1793: END IF;

Line 1797: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1801: END IF;

Line 1851: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1855: END IF;

Line 1867: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1871: END IF;

Line 1952: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1956: END IF;

Line 1958: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
1962: END IF;

Line 1989: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
1993: END IF;

Line 2067: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2071: END IF;

Line 2125: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2129: END IF;

Line 2131: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2135: END IF;

Line 2142: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2146: END IF;

Line 2213: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2217: END IF;

Line 2234: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2238: END IF;

Line 2322: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2326: END IF;

Line 2340: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2344: END IF;

Line 2383: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2387: END IF;

Line 2399: FEM_ENGINES_PKG.TECH_MESSAGE(

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 '
2403: ||'passed in version ('||p_api_version||')');

Line 2435: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2439: END IF;

Line 2444: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2448: END IF;

Line 2450: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2454: END IF;

Line 2537: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2541: END IF;

Line 2553: FEM_ENGINES_PKG.TECH_MESSAGE(

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 '
2557: ||'passed in version ('||p_api_version||')');

Line 2592: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2596: END IF;

Line 2604: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2608: END IF;

Line 2610: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2614: END IF;

Line 2678: FEM_ENGINES_PKG.TECH_MESSAGE(

2674: x_tab_name:= NULL;
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:

Line 2743: FEM_ENGINES_PKG.TECH_MESSAGE(

2739: x_tab_owner:= NULL;
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:

Line 2804: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2808: END IF;

Line 2829: FEM_ENGINES_PKG.TECH_MESSAGE(

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');
2833: END IF;

Line 2898: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2902:

Line 2918: FEM_ENGINES_PKG.TECH_MESSAGE(

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);
2922: END IF;