APPS.CSM_MTL_TXN_LOT_NUM_ACC_PKG dependencies on FND_LOG

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

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:
36: IF l_transaction_id_lst.COUNT >0 THEN
37: l_transaction_id_lst.DELETE;
38: END IF;

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

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;
77:
78:
79: PROCEDURE Update_MTL_trans_lot_num( p_user_id NUMBER,

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

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:
97: IF l_transaction_id_lst.COUNT >0 THEN
98: l_transaction_id_lst.DELETE;
99: END IF;

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

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:
155: END Update_MTL_trans_lot_num;
156:
157:

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

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:
177: IF l_transaction_id_lst.COUNT >0 THEN
178: l_transaction_id_lst.DELETE;
179: END IF;

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

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:
216: END Delete_MTL_trans_lot_num;
217:
218: /*Delete all records for non-existing user ( e.g user was deleted )*/

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

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:
228: DELETE CSM_MTL_TXN_LOT_NUM_ACC
229: WHERE USER_ID = p_user_id;
230:

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

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:
238: EXCEPTION WHEN OTHERS THEN
239: /*** hook failed -> log error ***/
240: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 245: , log_level => FND_LOG.LEVEL_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);
247: END DELETE_ALL_ACC_RECORDS;
248:
249: END CSM_MTL_TXN_LOT_NUM_ACC_PKG;