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 CSM_UTIL_PKG

Line 19: CSM_UTIL_PKG.LOG

15: )
16: IS
17:
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:

Line 43: CSM_UTIL_PKG.LOG

39: CSM_MTL_UNIT_TXN_ACC_PKG.Insert_MTL_Unit_Trans(
40: p_user_id => p_user_id,
41: p_transaction_id => p_transaction_id
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:

Line 59: CSM_UTIL_PKG.LOG

55: IS
56: l_acc_id NUMBER;
57: BEGIN
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:

Line 100: CSM_UTIL_PKG.LOG

96: CSM_MTL_UNIT_TXN_ACC_PKG.Update_MTL_Unit_Trans(
97: p_user_id => p_user_id,
98: p_transaction_id => p_transaction_id
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:

Line 115: CSM_UTIL_PKG.LOG

111: )
112: IS
113: BEGIN
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:

Line 138: CSM_UTIL_PKG.LOG

134: CSM_MTL_UNIT_TXN_ACC_PKG.Delete_MTL_Unit_Trans(
135: p_user_id => p_user_id,
136: p_transaction_id => p_transaction_id
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:

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 161: CSM_UTIL_PKG.LOG

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

Line 170: CSM_UTIL_PKG.LOG

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

Line 274: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ',

270:
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:

Line 291: CSM_UTIL_PKG.LOG('Processing Material Trasaction Delete',

287: IF l_tran_id_lst.COUNT > 0 THEN
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;

Line 322: CSM_UTIL_PKG.LOG('Processing Material Trasaction Update',

318: IF l_tran_id_lst.COUNT > 0 THEN
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;

Line 352: CSM_UTIL_PKG.LOG('Processing Material Trasaction Insert',

348: IF l_tran_id_lst.COUNT > 0 THEN
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

Line 386: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ',

382:
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);

Line 395: csm_util_pkg.LOG('CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

391: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
392: p_status := 'ERROR';
393: p_message := 'Error in CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
394: ROLLBACK;
395: csm_util_pkg.LOG('CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
396: END Refresh_Mat_Txn_Acc;
397:
398: --Called when a new user is created
399: PROCEDURE get_new_user_mat_txn(p_user_id IN NUMBER)

Line 442: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',

438:
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

Line 460: CSM_UTIL_PKG.LOG('Leaving CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ',

456:
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);

Line 467: csm_util_pkg.LOG('CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);

463: WHEN OTHERS THEN
464: l_sqlerrno := TO_CHAR(SQLCODE);
465: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
466: ROLLBACK;
467: csm_util_pkg.LOG('CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
468: END get_new_user_mat_txn;
469:
470: END CSM_MTL_MATERIAL_TXN_ACC_PKG;