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 276: CSM_UTIL_PKG.LOG('Entering CSM_MTL_MATERIAL_TXN_ACC_PKG.Refresh_Mat_Txn_Acc ',

272: l_profile_value NUMBER;
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.

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

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

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

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

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

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

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

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

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

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

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

448: l_profile_value NUMBER;
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);

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

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

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

474: WHEN OTHERS THEN
475: l_sqlerrno := TO_CHAR(SQLCODE);
476: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
477: ROLLBACK;
478: csm_util_pkg.LOG('CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
479: END get_new_user_mat_txn;
480:
481: END CSM_MTL_MATERIAL_TXN_ACC_PKG;