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 FND_LOG

Line 52: || SQLERRM,' for PK ' || to_char(p_notification_id) || g_object_name || '.INSERT_AUTO_SYNC_LOG_ACC',FND_LOG.LEVEL_EXCEPTION);

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

Line 72: g_object_name || '.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

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)
76: LOOP

Line 81: g_object_name || '.AUTO_SYNC_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

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);
85: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 134: FND_LOG.LEVEL_PROCEDURE );

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:
136: /***************************************************************************
137: ** Initialize API return status to success
138: ***************************************************************************/

Line 193: FND_LOG.LEVEL_ERROR );

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 );
194: RETURN ;
195: END IF;
196:
197:

Line 209: FND_LOG.LEVEL_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:
211: x_return_status := FND_API.G_RET_STS_ERROR;
212:
213: END APPLY_INSERT;

Line 258: FND_LOG.LEVEL_PROCEDURE );

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: /***************************************************************************
260: ** Initialize API return status to success
261: ***************************************************************************/
262: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 335: FND_LOG.LEVEL_EXCEPTION );

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:
337: x_return_status := FND_API.G_RET_STS_ERROR;
338:
339: END APPLY_UPDATE;

Line 384: FND_LOG.LEVEL_ERROR);

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);
385:
386: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
387: (
388: p_message => 'CSM_DML_OPERATION'

Line 403: FND_LOG.LEVEL_EXCEPTION);

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

Line 434: FND_LOG.LEVEL_PROCEDURE);

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:
438: /*** loop through records in inqueue ***/

Line 488: FND_LOG.LEVEL_ERROR); -- put PK column here

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
489: ROLLBACK TO save_rec;
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: END IF;
492: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/

Line 501: FND_LOG.LEVEL_ERROR); -- put PK column here

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
502:
503: CSM_UTIL_PKG.DEFER_RECORD
504: ( p_user_name
505: , p_tranid

Line 522: FND_LOG.LEVEL_ERROR); -- put PK column here

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
523: ROLLBACK TO save_rec;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: END IF;
526: END IF;

Line 535: FND_LOG.LEVEL_EXCEPTION);

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;
537:
538: END APPLY_CLIENT_CHANGES;
539: