DBA Data[Home] [Help]

APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_TAB_CLASS_STATUS_GT

Line 32: DELETE FROM fem_tab_class_status_gt

28: 'fem.plsql.fem_admin_util_pkg.trunc_table_class_log_tables';
29: BEGIN
30:
31: BEGIN
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

Line 40: p_msg_text => 'Delete from FEM_TAB_CLASS_STATUS_GT failed with: '||SQLERRM);

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;
43:
44: BEGIN

Line 153: INSERT INTO fem_tab_class_status_gt

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
154: (TABLE_NAME, TABLE_CLASSIFICATION_CODE, VALID_FLAG)
155: VALUES
156: (p_tab_name, p_tab_class_cd, decode(p_passed_validation,c_true,'Y','N'));
157:

Line 164: p_msg_text => 'Insert into FEM_TAB_CLASS_STATUS_GT failed with: '||SQLERRM);

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;
167:
168: ------------------------------------