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 CSM_UTIL_PKG

Line 68: CSM_UTIL_PKG.LOG

64:
65: l_pub_item_name_mat CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
66: JTM_HOOK_UTIL_PKG.t_publication_item_list('MTL_MAT_TRANSACTIONS');
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:

Line 126: CSM_UTIL_PKG.LOG

122: );
123:
124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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:

Line 131: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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
134: );
135: END IF;

Line 137: CSM_UTIL_PKG.LOG

133: p_api_error => TRUE
134: );
135: END IF;
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:

Line 143: CSM_UTIL_PKG.LOG

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

Line 149: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
151: p_api_error => TRUE
152: );
153:

Line 167: CSM_UTIL_PKG.LOG

163: p_error_msg OUT NOCOPY VARCHAR2,
164: x_return_status IN OUT NOCOPY VARCHAR2
165: ) IS
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:

Line 175: CSM_UTIL_PKG.LOG

171:
172: -- There is no update possible so returning SUCCESS
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:

Line 181: CSM_UTIL_PKG.LOG

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

Line 187: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
189: p_api_error => TRUE
190: );
191:

Line 209: CSM_UTIL_PKG.LOG

205: /*** initialize return status and message list ***/
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: FND_MSG_PUB.INITIALIZE;
208:
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);

Line 225: CSM_UTIL_PKG.LOG

221: x_return_status
222: );
223: ELSE
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:

Line 230: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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'
233: , p_token_name1 => 'DML'
234: , p_token_value1 => p_record.dmltype$$

Line 240: CSM_UTIL_PKG.LOG

236:
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: END IF;
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:

Line 247: CSM_UTIL_PKG.LOG

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

Line 253: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
255: p_api_error => TRUE
256: );
257:

Line 262: This procedure is called by CSM_UTIL_PKG when publication item MTL_MAT_TRANSACTIONS

258: x_return_status := FND_API.G_RET_STS_ERROR;
259: END APPLY_RECORD;
260:
261: /***
262: This procedure is called by CSM_UTIL_PKG when publication item MTL_MAT_TRANSACTIONS
263: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
264: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
265: public APIs.
266: ***/

Line 280: CSM_UTIL_PKG.LOG

276: l_error_msg VARCHAR2(4000);
277: BEGIN
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
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);

Line 301: CSM_UTIL_PKG.LOG

297: );
298:
299: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
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:

Line 306: CSM_UTIL_PKG.REJECT_RECORD

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,
309: p_tranid,
310: r_material_transaction.seqno$$,

Line 320: CSM_UTIL_PKG.LOG

316: );
317:
318: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
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:

Line 328: CSM_UTIL_PKG.REJECT_RECORD

324:
325: FOR r_lot_number IN c_lot_number( p_user_name,
326: p_tranid,
327: r_material_transaction.transaction_id ) LOOP
328: CSM_UTIL_PKG.REJECT_RECORD
329: (
330: p_user_name,
331: r_lot_number.tranid$$,
332: r_lot_number.seqno$$,

Line 344: CSM_UTIL_PKG.REJECT_RECORD

340:
341: FOR r_unit_transaction IN c_unit_transaction( p_user_name,
342: p_tranid,
343: r_material_transaction.transaction_id ) LOOP
344: CSM_UTIL_PKG.REJECT_RECORD
345: (
346: p_user_name,
347: r_unit_transaction.tranid$$,
348: r_unit_transaction.seqno$$,

Line 361: CSM_UTIL_PKG.LOG

357:
358: /*** was record processed successfully? ***/
359: /*IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN*/
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:

Line 366: CSM_UTIL_PKG.DELETE_RECORD

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,
369: p_tranid,
370: r_material_transaction.seqno$$,

Line 381: CSM_UTIL_PKG.LOG

377:
378: /*** was delete successful? ***/
379: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
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:

Line 391: CSM_UTIL_PKG.DELETE_RECORD

387: END IF;
388:
389: FOR r_lot_number IN c_lot_number( p_user_name, p_tranid, r_material_transaction.transaction_id ) LOOP
390: /* Delete matching contact record(s) */
391: CSM_UTIL_PKG.DELETE_RECORD
392: (
393: p_user_name,
394: p_tranid,
395: r_lot_number.seqno$$,

Line 404: CSM_UTIL_PKG.LOG

400: l_process_status
401: );
402: /*** was delete successful? ***/
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:

Line 409: CSM_UTIL_PKG.DEFER_RECORD

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
412: , p_tranid
413: , r_lot_number.seqno$$

Line 428: CSM_UTIL_PKG.DELETE_RECORD

424: FOR r_unit_transaction IN c_unit_transaction( p_user_name,
425: p_tranid,
426: r_material_transaction.transaction_id ) LOOP
427: /* Delete matching contact record(s) */
428: CSM_UTIL_PKG.DELETE_RECORD
429: (
430: p_user_name,
431: p_tranid,
432: r_unit_transaction.seqno$$,

Line 441: CSM_UTIL_PKG.LOG

437: l_process_status
438: );
439: /*** was delete successful? ***/
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:

Line 446: CSM_UTIL_PKG.DEFER_RECORD

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
449: , p_tranid
450: , r_unit_transaction.seqno$$

Line 465: CSM_UTIL_PKG.LOG

461: END IF;
462:
463: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
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:

Line 470: CSM_UTIL_PKG.DEFER_RECORD

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
473: , p_tranid
474: , r_material_transaction.seqno$$

Line 486: CSM_UTIL_PKG.LOG

482:
483: /*** Was defer successful? ***/
484: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
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:

Line 496: CSM_UTIL_PKG.DEFER_RECORD

492: END IF;
493:
494: FOR r_lot_number IN c_lot_number( p_user_name, p_tranid, r_material_transaction.transaction_id ) LOOP
495: /* Defering matching contact record(s) */
496: CSM_UTIL_PKG.DEFER_RECORD
497: (
498: p_user_name
499: , p_tranid
500: , r_lot_number.seqno$$

Line 514: CSM_UTIL_PKG.DEFER_RECORD

510: FOR r_unit_transaction IN c_unit_transaction( p_user_name,
511: p_tranid,
512: r_material_transaction.transaction_id ) LOOP
513: /* Defering matching contact record(s) */
514: CSM_UTIL_PKG.DEFER_RECORD
515: (
516: p_user_name
517: , p_tranid
518: , r_unit_transaction.seqno$$

Line 530: CSM_UTIL_PKG.LOG

526: END LOOP;
527: END IF;
528: END LOOP;
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:

Line 537: CSM_UTIL_PKG.LOG

533: , log_level => FND_LOG.LEVEL_STATEMENT);
534:
535: EXCEPTION WHEN OTHERS THEN
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: