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 CSM_UTIL_PKG

Line 52: CSM_UTIL_PKG.LOG

48: ,P_PK1_NUM_VALUE => p_notification_id
49: ,P_USER_ID => p_user_id
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;

Line 73: /* CSM_UTIL_PKG.LOG('Entering CLIENT_NFN_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,

69: SELECT DISTINCT notification_id
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

Line 83: CSM_UTIL_PKG.LOG('Leaving CLIENT_NFN_LOG_ACC_PROCESSOR for user_id: ' || p_user_id,

79: LOOP
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);

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 130: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'

126:
127: BEGIN
128:
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:

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

181: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
182: THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184:
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 );

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

196: COMMIT;
197:
198: 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:

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

244:
245: BEGIN
246:
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: /***************************************************************************

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

320: END IF;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322:
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:

Line 367: CSM_UTIL_PKG.LOG

363: );
364: ELSE
365: -- Process delete and insert;
366: -- Not supported for this entity
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);

Line 373: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 386: CSM_UTIL_PKG.LOG

382:
383: EXCEPTION
384: WHEN OTHERS THEN
385: /*** defer record when any process exception occurs ***/
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);

Line 393: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
395: p_api_error => TRUE
396: );
397:

Line 420: csm_util_pkg.log

416: l_return_status VARCHAR2(1);
417: l_error_msg VARCHAR2(4000);
418: l_reject_row boolean;
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;

Line 445: CSM_UTIL_PKG.REJECT_RECORD

441: /*** was record processed successfully? ***/
442: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
443: /*** If Yes -> delete record from inqueue ***/
444: IF l_reject_row THEN
445: CSM_UTIL_PKG.REJECT_RECORD
446: (
447: p_user_name,
448: p_tranid,
449: r_client_nfn_log.seqno$$,

Line 457: CSM_UTIL_PKG.DELETE_RECORD

453: l_error_msg,
454: l_return_status
455: );
456: ELSE
457: CSM_UTIL_PKG.DELETE_RECORD
458: (
459: p_user_name,
460: p_tranid,
461: r_client_nfn_log.seqno$$,

Line 473: CSM_UTIL_PKG.LOG

469:
470: /*** was delete/reject successful? ***/
471: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
472: /*** If No -> rollback ***/
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

Line 486: CSM_UTIL_PKG.LOG

482:
483: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
484: /*** Record was not processed successfully or delete failed
485: -> defer and reject record ***/
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

Line 492: CSM_UTIL_PKG.DEFER_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
495: , r_client_nfn_log.seqno$$
496: , r_client_nfn_log.notification_id

Line 507: CSM_UTIL_PKG.LOG

503:
504: /*** Was defer successful? ***/
505: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
506: /*** no -> rollback ***/
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

Line 521: CSM_UTIL_PKG.LOG

517: END LOOP;
518:
519: EXCEPTION WHEN OTHERS THEN
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;