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_AUTO_SYNC_LOG_PKG dependencies on CSM_UTIL_PKG

Line 51: CSM_UTIL_PKG.LOG( 'Exception occurred in ' || g_object_name || '.INSERT_AUTO_SYNC_LOG_ACC: '

47: ,P_PK1_NUM_VALUE => p_notification_id
48: ,P_USER_ID => p_user_id
49: );
50: EXCEPTION WHEN OTHERS THEN
51: CSM_UTIL_PKG.LOG( 'Exception occurred in ' || g_object_name || '.INSERT_AUTO_SYNC_LOG_ACC: '
52: || SQLERRM,' for PK ' || to_char(p_notification_id) || g_object_name || '.INSERT_AUTO_SYNC_LOG_ACC',FND_LOG.LEVEL_EXCEPTION);
53:
54: RAISE;
55: END INSERT_AUTO_SYNC_LOG_ACC;-- end INSERT_AUTO_SYNC_LOG_ACC

Line 71: /* CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,

67: SELECT DISTINCT notification_id
68: FROM CSM_AUTO_SYNC_LOG_ACC ACC;
69: */
70: BEGIN
71: /* CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,
72: g_object_name || '.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
73:
74: -- get all notifications in which user is a recipient
75: FOR l_notf_rec IN c_notf(p_user_id)

Line 80: CSM_UTIL_PKG.LOG('Leaving AUTO_SYNC_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,

76: LOOP
77: INSERT_AUTO_SYNC_LOG_ACC (l_notf_rec.notification_id, p_user_id);
78: END LOOP;
79:
80: CSM_UTIL_PKG.LOG('Leaving AUTO_SYNC_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,
81: g_object_name || '.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
82: EXCEPTION
83: WHEN OTHERS THEN
84: l_sqlerrno := to_char(SQLCODE);

Line 88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_LOG_PKG.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

84: l_sqlerrno := to_char(SQLCODE);
85: l_sqlerrmsg := substr(SQLERRM, 1,2000);
86: l_error_msg := ' Exception in AUTO_SYNC_LOG_ACC_PROCESSOR for for user_id: ' || p_user_id
87: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_LOG_PKG.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
89: RAISE;
90: */
91: RETURN;
92: END AUTO_SYNC_LOG_ACC_PROCESSOR;

Line 131: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'

127:
128: BEGIN
129:
130:
131: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
132: || ' for PK ' || p_record.notification_id,
133: 'CSM_AUTO_SYNC_LOG.APPLY_INSERT',
134: FND_LOG.LEVEL_PROCEDURE );
135:

Line 189: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'

185: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
186: THEN
187: x_return_status := FND_API.G_RET_STS_ERROR;
188:
189: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
190: || ' ROOT ERROR: create statement'
191: || ' for PK ' || p_record.NOTIFICATION_ID,
192: g_object_name || '.APPLY_INSERT',
193: FND_LOG.LEVEL_ERROR );

Line 206: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'

202: COMMIT;
203:
204: EXCEPTION
205: WHEN others THEN
206: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
207: || ' for PK ' || p_record.notification_id,
208: g_object_name || '.APPLY_INSERT',
209: FND_LOG.LEVEL_EXCEPTION );
210:

Line 255: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'

251:
252: BEGIN
253:
254:
255: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
256: || ' for PK ' || p_record.notification_id,
257: 'CSM_AUTO_SYNC_LOG.APPLY_UPDATE',
258: FND_LOG.LEVEL_PROCEDURE );
259: /***************************************************************************

Line 332: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'

328: END IF;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330:
331: WHEN others THEN
332: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
333: || ' for PK ' || p_record.notification_id,
334: g_object_name || '.APPLY_UPDATE',
335: FND_LOG.LEVEL_EXCEPTION );
336:

Line 380: CSM_UTIL_PKG.LOG

376: );
377: ELSE
378: -- Process delete and insert;
379: -- Not supported for this entity
380: CSM_UTIL_PKG.LOG
381: ( 'Delete and Update is not supported for this entity'
382: || ' for PK ' || p_record.notification_id ,
383: g_object_name || '.APPLY_RECORD',
384: FND_LOG.LEVEL_ERROR);

Line 386: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

382: || ' for PK ' || p_record.notification_id ,
383: g_object_name || '.APPLY_RECORD',
384: FND_LOG.LEVEL_ERROR);
385:
386: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
387: (
388: p_message => 'CSM_DML_OPERATION'
389: , p_token_name1 => 'DML'
390: , p_token_value1 => p_record.dmltype$$

Line 399: CSM_UTIL_PKG.LOG

395:
396: EXCEPTION
397: WHEN OTHERS THEN
398: /*** defer record when any process exception occurs ***/
399: CSM_UTIL_PKG.LOG
400: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
401: || ' for PK ' || p_record.notification_id ,
402: g_object_name || '.APPLY_RECORD',
403: FND_LOG.LEVEL_EXCEPTION);

Line 406: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

402: g_object_name || '.APPLY_RECORD',
403: FND_LOG.LEVEL_EXCEPTION);
404: -- temp -- find more detail --remove comment
405: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
406: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
407: (
408: p_api_error => TRUE
409: );
410:

Line 433: csm_util_pkg.log ( g_object_name || '.APPLY_CLIENT_CHANGES entered',

429: l_return_status VARCHAR2(1);
430: l_error_msg VARCHAR2(4000);
431: l_reject_row boolean;
432: BEGIN
433: csm_util_pkg.log ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
434: FND_LOG.LEVEL_PROCEDURE);
435: g_debug_level := p_debug_level;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:

Line 456: CSM_UTIL_PKG.REJECT_RECORD

452: /*** was record processed successfully? ***/
453: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
454: /*** If Yes -> delete record from inqueue ***/
455: IF l_reject_row THEN
456: CSM_UTIL_PKG.REJECT_RECORD
457: (
458: p_user_name,
459: p_tranid,
460: r_auto_sync_log.seqno$$,

Line 468: CSM_UTIL_PKG.DELETE_RECORD

464: l_error_msg,
465: l_return_status
466: );
467: ELSE
468: CSM_UTIL_PKG.DELETE_RECORD
469: (
470: p_user_name,
471: p_tranid,
472: r_auto_sync_log.seqno$$,

Line 484: CSM_UTIL_PKG.LOG

480:
481: /*** was delete/reject successful? ***/
482: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483: /*** If No -> rollback ***/
484: CSM_UTIL_PKG.LOG
485: ( 'Deleting from inqueue failed, rolling back to savepoint'
486: || ' for PK ' || r_auto_sync_log.notification_id ,
487: g_object_name || '.APPLY_CLIENT_CHANGES',
488: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 497: CSM_UTIL_PKG.LOG

493:
494: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
495: /*** Record was not processed successfully or delete failed
496: -> defer and reject record ***/
497: CSM_UTIL_PKG.LOG
498: ( 'Record not processed successfully, deferring and rejecting record'
499: || ' for PK ' || r_auto_sync_log.notification_id ,
500: g_object_name || '.APPLY_CLIENT_CHANGES',
501: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 503: CSM_UTIL_PKG.DEFER_RECORD

499: || ' for PK ' || r_auto_sync_log.notification_id ,
500: g_object_name || '.APPLY_CLIENT_CHANGES',
501: FND_LOG.LEVEL_ERROR); -- put PK column here
502:
503: CSM_UTIL_PKG.DEFER_RECORD
504: ( p_user_name
505: , p_tranid
506: , r_auto_sync_log.seqno$$
507: , r_auto_sync_log.notification_id

Line 518: CSM_UTIL_PKG.LOG

514:
515: /*** Was defer successful? ***/
516: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
517: /*** no -> rollback ***/
518: CSM_UTIL_PKG.LOG
519: ( 'Defer record failed, rolling back to savepoint'
520: || ' for PK ' || r_auto_sync_log.notification_id ,
521: g_object_name || '.APPLY_CLIENT_CHANGES',
522: FND_LOG.LEVEL_ERROR); -- put PK column here

Line 532: CSM_UTIL_PKG.LOG

528: END LOOP;
529:
530: EXCEPTION WHEN OTHERS THEN
531: /*** catch and log exceptions ***/
532: CSM_UTIL_PKG.LOG
533: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
534: g_object_name || '.APPLY_CLIENT_CHANGES',
535: FND_LOG.LEVEL_EXCEPTION);
536: x_return_status := FND_API.G_RET_STS_ERROR;