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_MATERIAL_TRANSACTION_PKG dependencies on FND_LOG

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

67: BEGIN
68: CSM_UTIL_PKG.LOG
69: ( module => g_object_name
70: , message => p_record.TRANSACTION_ID || ' Entering ' || g_object_name || '.APPLY_INSERT'
71: , log_level => FND_LOG.LEVEL_STATEMENT);
72:
73: -- Initialization
74: l_transaction_id := p_record.transaction_id;
75:

Line 129: , log_level => FND_LOG.LEVEL_PROCEDURE);

125: /*** exception occurred in API -> return errmsg ***/
126: CSM_UTIL_PKG.LOG
127: ( module => g_object_name
128: , message => 'transaction_id ' || l_transaction_id || ' errored out with msg: ' || l_msg_data
129: , log_level => FND_LOG.LEVEL_PROCEDURE);
130:
131: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
132: (
133: p_api_error => TRUE

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

136:
137: CSM_UTIL_PKG.LOG
138: ( module => g_object_name
139: , message => p_record.TRANSACTION_ID || ' Leaving ' || g_object_name || '.APPLY_INSERT'
140: , log_level => FND_LOG.LEVEL_STATEMENT);
141:
142: EXCEPTION WHEN OTHERS THEN
143: CSM_UTIL_PKG.LOG
144: ( module => g_object_name

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

142: EXCEPTION WHEN OTHERS THEN
143: CSM_UTIL_PKG.LOG
144: ( module => g_object_name
145: , message => p_record.TRANSACTION_ID || ' Exception occurred in APPLY_INSERT:' || fnd_global.local_chr(10) || sqlerrm
146: , log_level => FND_LOG.LEVEL_ERROR);
147:
148: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
149: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
150: (

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

166: BEGIN
167: CSM_UTIL_PKG.LOG
168: ( module => g_object_name
169: , message => p_record.TRANSACTION_ID || ' Entering ' || g_object_name || '.APPLY_UPDATE'
170: , log_level => FND_LOG.LEVEL_STATEMENT);
171:
172: -- There is no update possible so returning SUCCESS
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:

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

174:
175: CSM_UTIL_PKG.LOG
176: ( module => g_object_name
177: , message => p_record.TRANSACTION_ID || ' Leaving ' || g_object_name || '.APPLY_UPDATE'
178: , log_level => FND_LOG.LEVEL_STATEMENT);
179:
180: EXCEPTION WHEN OTHERS THEN
181: CSM_UTIL_PKG.LOG
182: ( module => g_object_name

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

180: EXCEPTION WHEN OTHERS THEN
181: CSM_UTIL_PKG.LOG
182: ( module => g_object_name
183: , message => p_record.TRANSACTION_ID || ' Exception occurred in APPLY_UPDATE:' || fnd_global.local_chr(10) || sqlerrm
184: , log_level => FND_LOG.LEVEL_ERROR);
185:
186: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_UPDATE', sqlerrm);
187: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
188: (

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

209: CSM_UTIL_PKG.LOG
210: ( module => g_object_name
211: , message => 'Entering ' || g_object_name || '.APPLY_RECORD and processing TRANSACTION_ID = ' || p_record.TRANSACTION_ID || fnd_global.local_chr(10) ||
212: 'DMLTYPE = ' || p_record.dmltype$$
213: , log_level => FND_LOG.LEVEL_STATEMENT);
214:
215: IF p_record.dmltype$$='I' THEN
216: -- Process insert
217: APPLY_INSERT

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

224: -- Updates/Deletes are not supported for this entity
225: CSM_UTIL_PKG.LOG
226: ( module => g_object_name
227: , message => p_record.TRANSACTION_ID || ' Updates and Deletes is not supported for this entity'
228: , log_level => FND_LOG.LEVEL_ERROR);
229:
230: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
231: (
232: p_message => 'CSL_DML_OPERATION'

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

239:
240: CSM_UTIL_PKG.LOG
241: ( module => g_object_name
242: , message => p_record.TRANSACTION_ID || ' Leaving ' || g_object_name || '.APPLY_RECORD'
243: , log_level => FND_LOG.LEVEL_STATEMENT);
244:
245: EXCEPTION WHEN OTHERS THEN
246: /*** defer record when any process exception occurs ***/
247: CSM_UTIL_PKG.LOG

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

246: /*** defer record when any process exception occurs ***/
247: CSM_UTIL_PKG.LOG
248: ( module => g_object_name
249: , message => p_record.TRANSACTION_ID || ' Exception occurred in APPLY_RECORD:' || fnd_global.local_chr(10) || sqlerrm
250: , log_level => FND_LOG.LEVEL_ERROR);
251:
252: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
253: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
254: (

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

280: CSM_UTIL_PKG.LOG
281: ( module => g_object_name
282: , message => ' Entering ' || g_object_name || '.Apply_Client_Changes for user: ' ||
283: p_user_name || ' and tran id: ' || p_tranid
284: , log_level => FND_LOG.LEVEL_STATEMENT);
285:
286: /*** loop through MTL_MAT_TRANSACTIONS records in inqueue ***/
287: FOR r_material_transaction IN c_material_transaction( p_user_name, p_tranid) LOOP
288:

Line 304: , log_level => FND_LOG.LEVEL_PROCEDURE);

300: /*** Yes -> reject record because of changed pk ***/
301: CSM_UTIL_PKG.LOG
302: ( module => g_object_name
303: , message => r_material_transaction.TRANSACTION_ID || ' Record successfully processed, rejecting record because pk is changed'
304: , log_level => FND_LOG.LEVEL_PROCEDURE);
305:
306: CSM_UTIL_PKG.REJECT_RECORD
307: (
308: p_user_name,

Line 323: , log_level => FND_LOG.LEVEL_PROCEDURE);

319: /*** Reject successfull now rejecting matching serial/lotnumber records ***/
320: CSM_UTIL_PKG.LOG
321: ( module => g_object_name
322: , message => r_material_transaction.TRANSACTION_ID || ' Record rejected, now rejecting available matching lot-/serialnumber records'
323: , log_level => FND_LOG.LEVEL_PROCEDURE);
324:
325: FOR r_lot_number IN c_lot_number( p_user_name,
326: p_tranid,
327: r_material_transaction.transaction_id ) LOOP

Line 364: , log_level => FND_LOG.LEVEL_PROCEDURE);

360: /*** Yes -> delete record from inqueue ***/
361: CSM_UTIL_PKG.LOG
362: ( module => g_object_name
363: , message => r_material_transaction.TRANSACTION_ID || ' Record successfully processed, deleting from inqueue'
364: , log_level => FND_LOG.LEVEL_PROCEDURE);
365:
366: CSM_UTIL_PKG.DELETE_RECORD
367: (
368: p_user_name,

Line 384: , log_level => FND_LOG.LEVEL_PROCEDURE);

380: /*** no -> rollback ***/
381: CSM_UTIL_PKG.LOG
382: ( module => g_object_name
383: , message => r_material_transaction.TRANSACTION_ID || ' Deleting from inqueue failed, rolling back to savepoint'
384: , log_level => FND_LOG.LEVEL_PROCEDURE);
385:
386: ROLLBACK TO save_rec;
387: END IF;
388:

Line 407: , log_level => FND_LOG.LEVEL_PROCEDURE);

403: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
404: CSM_UTIL_PKG.LOG
405: ( module => g_object_name
406: , message => r_lot_number.tranid$$ || ' Deleting from inqueue failed, Defer and reject record'
407: , log_level => FND_LOG.LEVEL_PROCEDURE);
408:
409: CSM_UTIL_PKG.DEFER_RECORD
410: (
411: p_user_name

Line 444: , log_level => FND_LOG.LEVEL_PROCEDURE);

440: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
441: CSM_UTIL_PKG.LOG
442: ( module => g_object_name || 'MTL_UNIT_TRANSACTIONS'
443: , message => r_unit_transaction.TRANSACTION_ID || ' Deleting from inqueue failed, Defer and reject record'
444: , log_level => FND_LOG.LEVEL_PROCEDURE);
445:
446: CSM_UTIL_PKG.DEFER_RECORD
447: (
448: p_user_name

Line 468: , log_level => FND_LOG.LEVEL_PROCEDURE);

464: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
465: CSM_UTIL_PKG.LOG
466: ( module => g_object_name
467: , message => r_material_transaction.TRANSACTION_ID || ' Record not processed successfully, deferring and rejecting record'
468: , log_level => FND_LOG.LEVEL_PROCEDURE);
469:
470: CSM_UTIL_PKG.DEFER_RECORD
471: (
472: p_user_name

Line 489: , log_level => FND_LOG.LEVEL_PROCEDURE);

485: /*** no -> rollback ***/
486: CSM_UTIL_PKG.LOG
487: ( module => g_object_name
488: , message => r_material_transaction.TRANSACTION_ID || ' Defer record failed, rolling back to savepoint'
489: , log_level => FND_LOG.LEVEL_PROCEDURE);
490:
491: ROLLBACK TO save_rec;
492: END IF;
493:

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

529:
530: CSM_UTIL_PKG.LOG
531: ( module => g_object_name
532: , message => 'Leaving ' || g_object_name || '.Apply_Client_Changes'
533: , log_level => FND_LOG.LEVEL_STATEMENT);
534:
535: EXCEPTION WHEN OTHERS THEN
536: /*** catch and log exceptions ***/
537: CSM_UTIL_PKG.LOG

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

536: /*** catch and log exceptions ***/
537: CSM_UTIL_PKG.LOG
538: ( module => g_object_name
539: , message => 'Exception occurred in APPLY_CLIENT_CHANGES:' || fnd_global.local_chr(10) || sqlerrm
540: , log_level => FND_LOG.LEVEL_ERROR);
541:
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: END APPLY_CLIENT_CHANGES;
544: