eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 277: g_table_name,FND_LOG.LEVEL_PROCEDURE);

273: l_dummy boolean;
274:
275: BEGIN
276: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ',
277: g_table_name,FND_LOG.LEVEL_PROCEDURE);
278:
279: L_Current_Date := Sysdate;
280: --This profile is supported only at site level.
281: --So it is not required to be called for each user

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

292: l_tran_id_lst.DELETE;
293: END IF;
294:
295: CSM_UTIL_PKG.LOG('Processing Material Trasaction Delete',
296: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);
297:
298: --Processing Deletes
299: OPEN l_mat_delete_csr(l_profile_value);
300: LOOP

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

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

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

353: l_tran_id_lst.DELETE;
354: END IF;
355:
356: CSM_UTIL_PKG.LOG('Processing Material Trasaction Insert',
357: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc',FND_LOG.LEVEL_STATEMENT);
358:
359: OPEN l_mat_insert_csr(l_profile_value);
360: LOOP
361: FETCH l_mat_insert_csr BULK COLLECT INTO l_user_id_lst, l_tran_id_lst LIMIT 500;

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

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

Line 453: g_table_name,FND_LOG.LEVEL_PROCEDURE);

449: l_dummy boolean;
450:
451: BEGIN
452: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',
453: g_table_name,FND_LOG.LEVEL_PROCEDURE);
454: l_profile_value := NVL(CSM_PROFILE_PKG.get_task_history_days(p_user_id),0);
455:
456: OPEN l_mat_insert_csr(p_user_id, l_profile_value);
457: LOOP

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

468: END LOOP;
469: CLOSE l_mat_insert_csr;
470:
471: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',
472: 'CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn',FND_LOG.LEVEL_PROCEDURE);
473: EXCEPTION
474: WHEN OTHERS THEN
475: l_sqlerrno := TO_CHAR(SQLCODE);
476: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);