APPS.CSM_MTL_UNIT_TXN_ACC_PKG dependencies on FND_LOG

Line 33: , log_level => FND_LOG.LEVEL_STATEMENT);

29: BEGIN
30: CSM_UTIL_PKG.LOG
31: ( module => g_table_name
32: , message => p_transaction_id || 'Entering Insert_MTL_Unit_Trans Procedure'
33: , log_level => FND_LOG.LEVEL_STATEMENT);
34:
35: IF l_transaction_id_lst.COUNT >0 THEN
36: l_transaction_id_lst.DELETE;
37: END IF;

Line 72: , log_level => FND_LOG.LEVEL_STATEMENT);

68: END IF;
69: CSM_UTIL_PKG.LOG
70: ( module => g_table_name
71: , message => 'Leaving Insert_MTL_Unit_Trans Procedure after processing tran id:' || p_transaction_id
72: , log_level => FND_LOG.LEVEL_STATEMENT);
73:
74: END Insert_MTL_Unit_Trans;
75:
76:

Line 104: , log_level => FND_LOG.LEVEL_STATEMENT);

100:
101: CSM_UTIL_PKG.LOG
102: ( module => g_table_name
103: , message => ' Entering Delete_MTL_trans_lot_num for Tran id : ' || p_transaction_id
104: , log_level => FND_LOG.LEVEL_STATEMENT);
105:
106: IF l_transaction_id_lst.COUNT >0 THEN
107: l_transaction_id_lst.DELETE;
108: END IF;

Line 142: , log_level => FND_LOG.LEVEL_STATEMENT);

138: END IF;
139: CSM_UTIL_PKG.LOG
140: ( module => g_table_name
141: , message => ' Leaving Delete_MTL_trans_lot_num for Tran id : ' || p_transaction_id
142: , log_level => FND_LOG.LEVEL_STATEMENT);
143:
144: END Delete_MTL_Unit_Trans;
145:
146: /*Delete all records for non-existing user ( e.g user was deleted )*/

Line 154: , log_level => FND_LOG.LEVEL_STATEMENT);

150: BEGIN
151: CSM_UTIL_PKG.LOG
152: ( module => g_table_name
153: , message => 'Entering DELETE_ALL_ACC_RECORDS'
154: , log_level => FND_LOG.LEVEL_STATEMENT);
155:
156:
157: DELETE CSM_MTL_UNIT_TXN_ACC
158: WHERE user_id = p_user_id;

Line 165: , log_level => FND_LOG.LEVEL_STATEMENT);

161:
162: CSM_UTIL_PKG.LOG
163: ( module => g_table_name
164: , message => 'Leaving DELETE_ALL_ACC_RECORDS'
165: , log_level => FND_LOG.LEVEL_STATEMENT);
166:
167: EXCEPTION WHEN OTHERS THEN
168: /*** hook failed -> log error ***/
169: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 174: , log_level => FND_LOG.LEVEL_ERROR);

170: x_return_status := FND_API.G_RET_STS_SUCCESS;
171: CSM_UTIL_PKG.LOG
172: ( module => g_table_name
173: , message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
174: , log_level => FND_LOG.LEVEL_ERROR);
175: fnd_msg_pub.Add_Exc_Msg('CSM_MTL_UNIT_TXN_ACC_PKG','PROCESS_ACC',sqlerrm);
176: END DELETE_ALL_ACC_RECORDS;
177:
178: