APPS.CSM_MTL_TXN_LOT_NUM_ACC_PKG dependencies on CSM_UTIL_PKG

Line 31: CSM_UTIL_PKG.LOG

27: FROM MTL_TRANSACTION_LOT_NUMBERS
28: WHERE TRANSACTION_ID = b_transaction_id;
29:
30: BEGIN
31: CSM_UTIL_PKG.LOG
32: ( module => g_table_name
33: , message => 'Entering Insert_MTL_trans_lot_num Procedure for TRAN ID :' || p_transaction_id
34: , log_level => FND_LOG.LEVEL_STATEMENT);
35:

Line 72: CSM_UTIL_PKG.LOG

68: END IF;
69: IF l_lot_number_lst.COUNT >0 THEN
70: l_lot_number_lst.DELETE;
71: END IF;
72: CSM_UTIL_PKG.LOG
73: ( module => g_table_name
74: , message => 'Leaving Insert_MTL_trans_lot_num Procedure for TRAN ID :' || p_transaction_id
75: , log_level => FND_LOG.LEVEL_STATEMENT);
76: END Insert_MTL_trans_lot_num;

Line 92: CSM_UTIL_PKG.LOG

88: l_acc_id NUMBER;
89:
90: BEGIN
91:
92: CSM_UTIL_PKG.LOG
93: ( module => g_table_name
94: , message => ' Entering Update_MTL_trans_lot_num Procedure forTRAN ID :' || p_transaction_id
95: , log_level => FND_LOG.LEVEL_STATEMENT);
96:

Line 150: CSM_UTIL_PKG.LOG

146: IF l_lot_number_lst.COUNT >0 THEN
147: l_lot_number_lst.DELETE;
148: END IF;
149:
150: CSM_UTIL_PKG.LOG
151: ( module => g_table_name
152: , message => ' Leaving Update_MTL_trans_lot_num Procedure for TRAN ID :' || p_transaction_id
153: , log_level => FND_LOG.LEVEL_STATEMENT);
154:

Line 172: CSM_UTIL_PKG.LOG

168: r_transaction_lot_number c_transaction_lot_number%ROWTYPE;
169:
170: BEGIN
171:
172: CSM_UTIL_PKG.LOG
173: ( module => g_table_name
174: , message => ' Entering Delete_MTL_trans_lot_num Procedure for TRAN ID :' || p_transaction_id
175: , log_level => FND_LOG.LEVEL_STATEMENT);
176:

Line 211: CSM_UTIL_PKG.LOG

207: END IF;
208: IF l_lot_number_lst.COUNT >0 THEN
209: l_lot_number_lst.DELETE;
210: END IF;
211: CSM_UTIL_PKG.LOG
212: ( module => g_table_name
213: , message => ' Leaving Delete_MTL_trans_lot_num Procedure for TRAN ID :' || p_transaction_id
214: , log_level => FND_LOG.LEVEL_STATEMENT);
215:

Line 223: CSM_UTIL_PKG.LOG

219: PROCEDURE DELETE_ALL_ACC_RECORDS( p_user_id IN NUMBER
220: , x_return_status OUT NOCOPY VARCHAR2 )
221: IS
222: BEGIN
223: CSM_UTIL_PKG.LOG
224: ( module => g_table_name
225: , message => 'Entering DELETE_ALL_ACC_RECORDS'
226: , log_level => FND_LOG.LEVEL_STATEMENT);
227:

Line 233: CSM_UTIL_PKG.LOG

229: WHERE USER_ID = p_user_id;
230:
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: CSM_UTIL_PKG.LOG
234: ( module => g_table_name
235: , message => 'Leaving DELETE_ALL_ACC_RECORDS'
236: , log_level => FND_LOG.LEVEL_STATEMENT);
237:

Line 242: CSM_UTIL_PKG.LOG

238: EXCEPTION WHEN OTHERS THEN
239: /*** hook failed -> log error ***/
240: -- x_return_status := FND_API.G_RET_STS_ERROR;
241: x_return_status := FND_API.G_RET_STS_SUCCESS;
242: CSM_UTIL_PKG.LOG
243: ( module => g_table_name
244: , message => 'Caught exception in DELETE_ALL_ACC_RECORDS hook:' || fnd_global.local_chr(10) || sqlerrm
245: , log_level => FND_LOG.LEVEL_ERROR);
246: fnd_msg_pub.Add_Exc_Msg('CSM_MTL_TXN_LOT_NUM_ACC_PKG','PROCESS_ACC',sqlerrm);