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

Line 54: g_object_name || '.INSERT_CLIENT_NFN_LOG_ACC',FND_LOG.LEVEL_EXCEPTION);

50: );
51: EXCEPTION WHEN OTHERS THEN
52: CSM_UTIL_PKG.LOG
53: ( 'Exception occurred in ' || g_object_name || '.INSERT_CLIENT_NFN_LOG_ACC: ' || SQLERRM,' for PK ' || to_char(p_notification_id) ||
54: g_object_name || '.INSERT_CLIENT_NFN_LOG_ACC',FND_LOG.LEVEL_EXCEPTION);
55:
56: RAISE;
57: END INSERT_CLIENT_NFN_LOG_ACC;-- end INSERT_CLIENT_NFN_LOG_ACC
58: -------------------------------------------------------------------------------------------------

Line 74: g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

70: FROM CSM_CLIENT_NFN_LOG_ACC ACC;
71:
72: BEGIN
73: /* CSM_UTIL_PKG.LOG('Entering CLIENT_NFN_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,
74: g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
75:
76:
77: -- get all notifications in which user is a recipient
78: FOR l_notf_rec IN c_notf(p_user_id)

Line 84: g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

80: INSERT_CLIENT_NFN_LOG_ACC (l_notf_rec.notification_id, p_user_id);
81: END LOOP;
82:
83: CSM_UTIL_PKG.LOG('Leaving CLIENT_NFN_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,
84: g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
85: EXCEPTION
86: WHEN OTHERS THEN
87: l_sqlerrno := to_char(SQLCODE);
88: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 91: CSM_UTIL_PKG.LOG(l_error_msg, g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

87: l_sqlerrno := to_char(SQLCODE);
88: l_sqlerrmsg := substr(SQLERRM, 1,2000);
89: l_error_msg := ' Exception in CLIENT_NFN_LOG_ACC_PROCESSOR for for user_id: ' || p_user_id
90: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
91: CSM_UTIL_PKG.LOG(l_error_msg, g_object_name || '.CLIENT_NFN_LOG_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
92: RAISE;
93: */
94: RETURN;
95: END CLIENT_NFN_LOG_ACC_PROCESSOR;

Line 133: FND_LOG.LEVEL_PROCEDURE );

129:
130: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
131: || ' for PK ' || p_record.notification_id,
132: 'CSM_CLIENT_NFN_LOG.APPLY_INSERT',
133: FND_LOG.LEVEL_PROCEDURE );
134:
135: /***************************************************************************
136: ** Initialize API return status to success
137: ***************************************************************************/

Line 189: FND_LOG.LEVEL_ERROR );

185: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
186: || ' ROOT ERROR: create statement'
187: || ' for PK ' || p_record.NOTIFICATION_ID,
188: g_object_name || '.APPLY_INSERT',
189: FND_LOG.LEVEL_ERROR );
190: RETURN ;
191: END IF;
192:
193: --delete csm_client_nfn_log_inq where clid$$cs = l_user_name and notification_id = l_notification_id;

Line 203: FND_LOG.LEVEL_EXCEPTION );

199: WHEN others THEN
200: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
201: || ' for PK ' || p_record.notification_id,
202: g_object_name || '.APPLY_INSERT',
203: FND_LOG.LEVEL_EXCEPTION );
204:
205: x_return_status := FND_API.G_RET_STS_ERROR;
206:
207: END APPLY_INSERT;

Line 251: FND_LOG.LEVEL_PROCEDURE );

247:
248: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
249: || ' for PK ' || p_record.notification_id,
250: 'CSM_CLIENT_NFN_LOG.APPLY_UPDATE',
251: FND_LOG.LEVEL_PROCEDURE );
252: /***************************************************************************
253: ** Initialize API return status to success
254: ***************************************************************************/
255: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 327: FND_LOG.LEVEL_EXCEPTION );

323: WHEN others THEN
324: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
325: || ' for PK ' || p_record.notification_id,
326: g_object_name || '.APPLY_UPDATE',
327: FND_LOG.LEVEL_EXCEPTION );
328:
329: x_return_status := FND_API.G_RET_STS_ERROR;
330:
331: END APPLY_UPDATE;

Line 371: FND_LOG.LEVEL_ERROR);

367: CSM_UTIL_PKG.LOG
368: ( 'Delete and Update is not supported for this entity'
369: || ' for PK ' || p_record.notification_id ,
370: g_object_name || '.APPLY_RECORD',
371: FND_LOG.LEVEL_ERROR);
372:
373: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
374: (
375: p_message => 'CSM_DML_OPERATION'

Line 390: FND_LOG.LEVEL_EXCEPTION);

386: CSM_UTIL_PKG.LOG
387: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
388: || ' for PK ' || p_record.notification_id ,
389: g_object_name || '.APPLY_RECORD',
390: FND_LOG.LEVEL_EXCEPTION);
391: -- temp -- find more detail --remove comment
392: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
393: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
394: (

Line 423: FND_LOG.LEVEL_PROCEDURE);

419: BEGIN
420: csm_util_pkg.log
421: ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
422: g_object_name || '.APPLY_CLIENT_CHANGES',
423: FND_LOG.LEVEL_PROCEDURE);
424: g_debug_level := p_debug_level;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: /*** loop through records in inqueue ***/

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

473: CSM_UTIL_PKG.LOG
474: ( 'Deleting from inqueue failed, rolling back to savepoint'
475: || ' for PK ' || r_client_nfn_log.notification_id ,
476: g_object_name || '.APPLY_CLIENT_CHANGES',
477: FND_LOG.LEVEL_ERROR); -- put PK column here
478: ROLLBACK TO save_rec;
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: END IF;
481: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/

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

486: CSM_UTIL_PKG.LOG
487: ( 'Record not processed successfully, deferring and rejecting record'
488: || ' for PK ' || r_client_nfn_log.notification_id ,
489: g_object_name || '.APPLY_CLIENT_CHANGES',
490: FND_LOG.LEVEL_ERROR); -- put PK column here
491:
492: CSM_UTIL_PKG.DEFER_RECORD
493: ( p_user_name
494: , p_tranid

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

507: CSM_UTIL_PKG.LOG
508: ( 'Defer record failed, rolling back to savepoint'
509: || ' for PK ' || r_client_nfn_log.notification_id ,
510: g_object_name || '.APPLY_CLIENT_CHANGES',
511: FND_LOG.LEVEL_ERROR); -- put PK column here
512: ROLLBACK TO save_rec;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515: END IF;

Line 524: FND_LOG.LEVEL_EXCEPTION);

520: /*** catch and log exceptions ***/
521: CSM_UTIL_PKG.LOG
522: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
523: g_object_name || '.APPLY_CLIENT_CHANGES',
524: FND_LOG.LEVEL_EXCEPTION);
525: x_return_status := FND_API.G_RET_STS_ERROR;
526:
527: END APPLY_CLIENT_CHANGES;
528: