DBA Data[Home] [Help]

APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on FND_LOG

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

18: BEGIN
19: CSM_UTIL_PKG.LOG
20: ( module => g_table_name
21: , message => 'Entering Insert_MTL_Mat_Transaction Procedure to process TRAN ID : ' || p_transaction_id
22: , log_level => FND_LOG.LEVEL_STATEMENT);
23:
24: /*** Call common package to insert record into ACC table ***/
25: CSM_ACC_PKG.Insert_Acc
26: ( p_publication_item_names => g_publication_item_name

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

42: );
43: CSM_UTIL_PKG.LOG
44: ( module => g_table_name
45: , message => ' Leaving Insert_MTL_Mat_Transaction procedure for TRAN ID :' || p_transaction_id
46: , log_level => FND_LOG.LEVEL_STATEMENT);
47:
48: END Insert_MTL_Mat_Transaction;
49:
50:

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

58:
59: CSM_UTIL_PKG.LOG
60: ( module => g_table_name
61: , message => ' Entering Update_CSP_Sec_Inventory procedure to process TRAN ID :'|| p_transaction_id
62: , log_level => FND_LOG.LEVEL_STATEMENT);
63:
64: /*** Call common package to insert record into ACC table ***/
65: l_acc_id := CSM_ACC_PKG.Get_Acc_Id
66: ( P_ACC_TABLE_NAME => g_acc_table_name

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

99: );
100: CSM_UTIL_PKG.LOG
101: ( module => g_table_name
102: , message => ' Leaving Update_MTL_Mat_Transaction Procedure for TRAN ID :' || p_transaction_id
103: , log_level => FND_LOG.LEVEL_STATEMENT);
104:
105: END Update_MTL_Mat_Transaction;
106:
107:

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

114:
115: CSM_UTIL_PKG.LOG
116: ( module => g_table_name
117: , message =>' Entering Delete_MTL_Mat_Transaction Procedure for TRAN ID :'|| p_transaction_id
118: , log_level => FND_LOG.LEVEL_STATEMENT);
119:
120: /*** Call common package to insert record into ACC table ***/
121: CSM_ACC_PKG.Delete_Acc
122: ( p_publication_item_names => g_publication_item_name

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

137: );
138: CSM_UTIL_PKG.LOG
139: ( module => g_table_name
140: , message =>' Leaving Delete_MTL_Mat_Transaction Procedure for TRAN ID :'|| p_transaction_id
141: , log_level => FND_LOG.LEVEL_STATEMENT);
142:
143: END Delete_MTL_Mat_Transaction;
144:
145:

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: DELETE CSM_MTL_MATERIAL_TXN_ACC
157: WHERE user_id = p_user_id;
158:

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

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

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

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

Line 275: g_table_name,FND_LOG.LEVEL_PROCEDURE);

271: l_dummy boolean;
272:
273: BEGIN
274: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ',
275: g_table_name,FND_LOG.LEVEL_PROCEDURE);
276:
277: l_current_date := SYSDATE;
278:
279: -- get the last run date

Line 292: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);

288: l_tran_id_lst.DELETE;
289: END IF;
290:
291: CSM_UTIL_PKG.LOG('Processing Material Trasaction Delete',
292: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);
293:
294: --Processing Deletes
295: OPEN l_mat_delete_csr;
296: LOOP

Line 323: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);

319: l_tran_id_lst.DELETE;
320: END IF;
321:
322: CSM_UTIL_PKG.LOG('Processing Material Trasaction Update',
323: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);
324: OPEN l_mat_update_csr (l_last_run_date);
325: LOOP
326: FETCH l_mat_update_csr BULK COLLECT INTO l_user_id_lst , l_tran_id_lst LIMIT 1000;
327: EXIT WHEN l_user_id_lst.COUNT = 0;

Line 353: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);

349: l_tran_id_lst.DELETE;
350: END IF;
351:
352: CSM_UTIL_PKG.LOG('Processing Material Trasaction Insert',
353: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);
354:
355: OPEN l_mat_insert_csr;
356: LOOP
357: FETCH l_mat_insert_csr BULK COLLECT INTO l_user_id_lst, l_tran_id_lst LIMIT 1000;

Line 387: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_PROCEDURE);

383: p_status := 'FINE';
384: p_message := 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc executed successfully';
385:
386: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ',
387: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_PROCEDURE);
388: EXCEPTION
389: WHEN OTHERS THEN
390: l_sqlerrno := TO_CHAR(SQLCODE);
391: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 443: g_table_name,FND_LOG.LEVEL_PROCEDURE);

439: l_dummy boolean;
440:
441: BEGIN
442: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',
443: g_table_name,FND_LOG.LEVEL_PROCEDURE);
444:
445: OPEN l_mat_insert_csr(p_user_id);
446: LOOP
447: IF l_tran_id_lst.COUNT > 0 THEN

Line 461: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn',FND_LOG.LEVEL_PROCEDURE);

457: END LOOP;
458: CLOSE l_mat_insert_csr;
459:
460: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',
461: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn',FND_LOG.LEVEL_PROCEDURE);
462: EXCEPTION
463: WHEN OTHERS THEN
464: l_sqlerrno := TO_CHAR(SQLCODE);
465: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);