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_DATABASE_UTIL_PKG dependencies on FEM_ENGINES_PKG

Line 115: FEM_ENGINES_PKG.Put_Message(

111: END CASE;
112:
113: EXCEPTION
114: WHEN e_bad_p_api_ver THEN
115: FEM_ENGINES_PKG.Put_Message(
116: p_app_name => 'FEM',
117: p_msg_name => 'FEM_BAD_P_API_VER_ERR',
118: p_token1 => 'VALUE',
119: p_value1 => p_api_version);

Line 123: FEM_ENGINES_PKG.Put_Message(

119: p_value1 => p_api_version);
120: x_return_status := c_error;
121:
122: WHEN e_bad_p_init_msg_list THEN
123: FEM_ENGINES_PKG.Put_Message(
124: p_app_name => 'FEM',
125: p_msg_name => 'FEM_BAD_P_INIT_MSG_LIST_ERR');
126: x_return_status := c_error;
127:

Line 129: FEM_ENGINES_PKG.Put_Message(

125: p_msg_name => 'FEM_BAD_P_INIT_MSG_LIST_ERR');
126: x_return_status := c_error;
127:
128: WHEN e_bad_p_encoded THEN
129: FEM_ENGINES_PKG.Put_Message(
130: p_app_name => 'FEM',
131: p_msg_name => 'FEM_BAD_P_ENCODED_ERR');
132: x_return_status := c_error;
133:

Line 135: FEM_ENGINES_PKG.Put_Message(

131: p_msg_name => 'FEM_BAD_P_ENCODED_ERR');
132: x_return_status := c_error;
133:
134: WHEN e_bad_p_commit THEN
135: FEM_ENGINES_PKG.Put_Message(
136: p_app_name => 'FEM',
137: p_msg_name => 'FEM_BAD_P_COMMIT_ERR');
138: x_return_status := c_error;
139:

Line 193: FEM_ENGINES_PKG.TECH_MESSAGE(

189: EXECUTE IMMEDIATE p_command;
190:
191: -- Log to Debug Log
192:
193: FEM_ENGINES_PKG.TECH_MESSAGE(
194: p_severity => c_log_level_1,
195: p_module => 'fem.plsql.fem_database_util_pkg.' || lower(p_proc_name) || '.exec',
196: p_msg_text => 'SUCCESSFUL DDL: ' || v_command_short );
197:

Line 242: FEM_ENGINES_PKG.TECH_MESSAGE(

238: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
239:
240: -- Log to Debug Log
241:
242: FEM_ENGINES_PKG.TECH_MESSAGE(
243: p_severity => c_log_level_5,
244: p_module => 'fem.plsql.fem_database_util_pkg.' || lower(p_proc_name) || '.exec',
245: p_msg_text => v_sqlerrm );
246:

Line 260: FEM_ENGINES_PKG.TECH_MESSAGE(

256: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
257:
258: -- Log to Debug Log
259:
260: FEM_ENGINES_PKG.TECH_MESSAGE(
261: p_severity => c_log_level_5,
262: p_module => 'fem.plsql.fem_database_util_pkg.' || lower(p_proc_name) || '.exec',
263: p_msg_text => 'FAILED DDL: ' || v_command_short );
264:

Line 265: FEM_ENGINES_PKG.TECH_MESSAGE(

261: p_severity => c_log_level_5,
262: p_module => 'fem.plsql.fem_database_util_pkg.' || lower(p_proc_name) || '.exec',
263: p_msg_text => 'FAILED DDL: ' || v_command_short );
264:
265: FEM_ENGINES_PKG.TECH_MESSAGE(
266: p_severity => c_log_level_5,
267: p_module => 'fem.plsql.fem_database_util_pkg.' || lower(p_proc_name) || '.exec',
268: p_msg_text => v_sqlerrm );
269:

Line 314: FEM_ENGINES_PKG.TECH_MESSAGE(

310: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
311:
312: -- Log to Debug Log
313:
314: FEM_ENGINES_PKG.TECH_MESSAGE(
315: p_severity => c_log_level_5,
316: p_module => 'fem.plsql.fem_database_util_pkg.' || lower(p_proc_name) || '.exec',
317: p_msg_text => v_sqlerrm );
318:

Line 369: FEM_ENGINES_PKG.Put_Message(

365:
366: EXCEPTION
367:
368: WHEN no_data_found THEN
369: FEM_ENGINES_PKG.Put_Message(
370: p_app_name => 'FEM',
371: p_msg_name => 'FEM_DB_BAD_SYNONYM_ERR',
372: p_token1 => 'SYN_NAME',
373: p_value1 => p_syn_name);

Line 722: FEM_ENGINES_PKG.Get_PB_Param_Value

718: INTO v_pb_object_type
719: FROM fem_object_catalog_b
720: WHERE object_id = v_pb_object_id;
721:
722: FEM_ENGINES_PKG.Get_PB_Param_Value
723: (p_api_version => p_api_version,
724: p_init_msg_list => p_init_msg_list,
725: p_commit => p_commit,
726: p_encoded => p_encoded,

Line 743: FEM_ENGINES_PKG.Get_PB_Param_Value

739: END IF;
740:
741: -- Get tablespace, initial extent, and next extent parameter values
742:
743: FEM_ENGINES_PKG.Get_PB_Param_Value
744: (p_api_version => p_api_version,
745: p_init_msg_list => p_init_msg_list,
746: p_commit => p_commit,
747: p_encoded => p_encoded,

Line 765: FEM_ENGINES_PKG.Get_PB_Param_Value

761: FROM user_users
762: WHERE username = USER;
763: END IF;
764:
765: FEM_ENGINES_PKG.Get_PB_Param_Value
766: (p_api_version => p_api_version,
767: p_init_msg_list => p_init_msg_list,
768: p_commit => p_commit,
769: p_encoded => p_encoded,

Line 787: FEM_ENGINES_PKG.Get_PB_Param_Value

783: FROM user_tablespaces
784: WHERE tablespace_name = v_tablespace;
785: END IF;
786:
787: FEM_ENGINES_PKG.Get_PB_Param_Value
788: (p_api_version => p_api_version,
789: p_init_msg_list => p_init_msg_list,
790: p_commit => p_commit,
791: p_encoded => p_encoded,

Line 852: FEM_ENGINES_PKG.Put_Message(

848: -- "Failed to create temporary table: TABLE_NAME"
849:
850: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
851:
852: FEM_ENGINES_PKG.Put_Message(
853: p_app_name => 'FEM',
854: p_msg_name => 'FEM_CREATE_TEMP_TABLE_FAILURE',
855: p_token1 => 'ORACLE_ERROR_MSG',
856: p_value1 => v_sqlerrm,

Line 915: FEM_ENGINES_PKG.Put_Message(

911: -- "Failed to create synonym for temporary table: TABLE_NAME"
912:
913: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
914:
915: FEM_ENGINES_PKG.Put_Message(
916: p_app_name => 'FEM',
917: p_msg_name => 'FEM_CREATE_TEMP_SYN_FAILURE',
918: p_token1 => 'ORACLE_ERROR_MSG',
919: p_value1 => v_sqlerrm,

Line 1081: FEM_ENGINES_PKG.Get_PB_Param_Value

1077: INTO v_pb_object_type
1078: FROM fem_object_catalog_b
1079: WHERE object_id = v_pb_object_id;
1080:
1081: FEM_ENGINES_PKG.Get_PB_Param_Value
1082: (p_api_version => p_api_version,
1083: p_init_msg_list => p_init_msg_list,
1084: p_commit => p_commit,
1085: p_encoded => p_encoded,

Line 1102: FEM_ENGINES_PKG.Get_PB_Param_Value

1098: END IF;
1099:
1100: -- Get tablespace, initial extent, and next extent parameter values
1101:
1102: FEM_ENGINES_PKG.Get_PB_Param_Value
1103: (p_api_version => p_api_version,
1104: p_init_msg_list => p_init_msg_list,
1105: p_commit => p_commit,
1106: p_encoded => p_encoded,

Line 1124: FEM_ENGINES_PKG.Get_PB_Param_Value

1120: FROM user_users
1121: WHERE username = USER;
1122: END IF;
1123:
1124: FEM_ENGINES_PKG.Get_PB_Param_Value
1125: (p_api_version => p_api_version,
1126: p_init_msg_list => p_init_msg_list,
1127: p_commit => p_commit,
1128: p_encoded => p_encoded,

Line 1146: FEM_ENGINES_PKG.Get_PB_Param_Value

1142: FROM user_tablespaces
1143: WHERE tablespace_name = v_tablespace;
1144: END IF;
1145:
1146: FEM_ENGINES_PKG.Get_PB_Param_Value
1147: (p_api_version => p_api_version,
1148: p_init_msg_list => p_init_msg_list,
1149: p_commit => p_commit,
1150: p_encoded => p_encoded,

Line 1208: FEM_ENGINES_PKG.Put_Message(

1204: -- "Failed to create temporary index: INDEX_NAME on table: TABLE_NAME"
1205:
1206: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1207:
1208: FEM_ENGINES_PKG.Put_Message(
1209: p_app_name => 'FEM',
1210: p_msg_name => 'FEM_CREATE_TEMP_INDEX_FAILURE',
1211: p_token1 => 'ORACLE_ERROR_MSG',
1212: p_value1 => v_sqlerrm,

Line 1394: FEM_ENGINES_PKG.Get_PB_Param_Value

1390: INTO v_pb_object_type
1391: FROM fem_object_catalog_b
1392: WHERE object_id = v_pb_object_id;
1393:
1394: FEM_ENGINES_PKG.Get_PB_Param_Value
1395: (p_api_version => p_api_version,
1396: p_init_msg_list => p_init_msg_list,
1397: p_commit => p_commit,
1398: p_encoded => p_encoded,

Line 1427: FEM_ENGINES_PKG.Put_Message(

1423: -- "Failed to create temporary view: VIEW_NAME"
1424:
1425: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1426:
1427: FEM_ENGINES_PKG.Put_Message(
1428: p_app_name => 'FEM',
1429: p_msg_name => 'FEM_CREATE_TEMP_VIEW_FAILURE',
1430: p_token1 => 'ORACLE_ERROR_MSG',
1431: p_value1 => v_sqlerrm,

Line 1627: FEM_ENGINES_PKG.Get_PB_Param_Value

1623: INTO v_pb_object_type
1624: FROM fem_object_catalog_b
1625: WHERE object_id = v_pb_object_id;
1626:
1627: FEM_ENGINES_PKG.Get_PB_Param_Value
1628: (p_api_version => p_api_version,
1629: p_init_msg_list => p_init_msg_list,
1630: p_commit => p_commit,
1631: p_encoded => p_encoded,

Line 1677: FEM_ENGINES_PKG.Put_Message(

1673: -- "Failed to drop temporary database object. Object Type: VIEW. Object Name: DB_OBJECT_NAME"
1674:
1675: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1676:
1677: FEM_ENGINES_PKG.Put_Message(
1678: p_app_name => 'FEM',
1679: p_msg_name => 'FEM_DROP_TEMP_DB_OBJ_FAILURE',
1680: p_token1 => 'ORACLE_ERROR_MSG',
1681: p_value1 => v_sqlerrm,

Line 1722: FEM_ENGINES_PKG.Put_Message(

1718: -- "Failed to drop temporary database object: OBJECT_NAME. Object Type: INDEX"
1719:
1720: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1721:
1722: FEM_ENGINES_PKG.Put_Message(
1723: p_app_name => 'FEM',
1724: p_msg_name => 'FEM_DROP_TEMP_DB_OBJ_FAILURE',
1725: p_token1 => 'ORACLE_ERROR_MSG',
1726: p_value1 => v_sqlerrm,

Line 1767: FEM_ENGINES_PKG.Put_Message(

1763: -- "Failed to drop temporary database object. Object Type: SYNONYM. Object Name: OBJECT_NAME"
1764:
1765: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1766:
1767: FEM_ENGINES_PKG.Put_Message(
1768: p_app_name => 'FEM',
1769: p_msg_name => 'FEM_DROP_TEMP_DB_OBJ_FAILURE',
1770: p_token1 => 'ORACLE_ERROR_MSG',
1771: p_value1 => v_sqlerrm,

Line 1795: FEM_ENGINES_PKG.Put_Message(

1791: -- "Failed to drop temporary database object. Object Type: TABLE. Object Name: OBJECT_NAME"
1792:
1793: v_sqlerrm := SUBSTR(SQLERRM, 1, 255);
1794:
1795: FEM_ENGINES_PKG.Put_Message(
1796: p_app_name => 'FEM',
1797: p_msg_name => 'FEM_DROP_TEMP_DB_OBJ_FAILURE',
1798: p_token1 => 'ORACLE_ERROR_MSG',
1799: p_value1 => v_sqlerrm,

Line 1827: FEM_ENGINES_PKG.TECH_MESSAGE(

1823: p_data => x_msg_data);
1824:
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: FEM_ENGINES_PKG.TECH_MESSAGE(
1828: p_severity => c_log_level_6,
1829: p_module => 'fem.plsql.fem_database_util_pkg.drop_temp_db_objects',
1830: p_msg_text => SUBSTR(SQLERRM, 1, 255) );
1831: