APPS.CSM_MTL_UNIT_TXN_ACC_PKG dependencies on CSM_UTIL_PKG

Line 30: CSM_UTIL_PKG.LOG

26: FROM MTL_UNIT_TRANSACTIONS
27: WHERE TRANSACTION_ID = b_transaction_id;
28:
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:

Line 69: CSM_UTIL_PKG.LOG

65: END IF;
66: IF l_serial_lst.COUNT >0 THEN
67: l_serial_lst.DELETE;
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:

Line 101: CSM_UTIL_PKG.LOG

97: AND USER_ID = b_user_id;
98:
99: BEGIN
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:

Line 139: CSM_UTIL_PKG.LOG

135: END IF;
136: IF l_serial_lst.COUNT >0 THEN
137: l_serial_lst.DELETE;
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:

Line 151: CSM_UTIL_PKG.LOG

147: PROCEDURE DELETE_ALL_ACC_RECORDS( p_user_id IN NUMBER
148: , x_return_status OUT NOCOPY VARCHAR2 )
149: IS
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:

Line 162: CSM_UTIL_PKG.LOG

158: WHERE user_id = p_user_id;
159:
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 171: CSM_UTIL_PKG.LOG

167: EXCEPTION WHEN OTHERS THEN
168: /*** hook failed -> log error ***/
169: -- x_return_status := FND_API.G_RET_STS_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);