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

Line 52: || SQLERRM,' for PK ' || to_char(p_notification_id) || g_object_name || '.INSERT_AUTO_SYNC_NFN_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_NFN_ACC: '
52: || SQLERRM,' for PK ' || to_char(p_notification_id) || g_object_name || '.INSERT_AUTO_SYNC_NFN_ACC',FND_LOG.LEVEL_EXCEPTION);
53:
54: RAISE;
55: END INSERT_AUTO_SYNC_NFN_ACC;-- end INSERT_AUTO_SYNC_NFN_ACC
56: -------------------------------------------------------------------------------------------------

Line 73: g_object_name || '.AUTO_SYNC_NFN_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

69: WHERE user_id=b_user_id;
70:
71: BEGIN
72: CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_NFN_ACC_PROCESSOR for user_id: ' || p_user_id,
73: g_object_name || '.AUTO_SYNC_NFN_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
74:
75:
76: -- get all notifications in which user is a recipient
77: FOR l_notf_rec IN c_notf(p_user_id)

Line 88: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_NFN_PKG.AUTO_SYNC_NFN_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_NFN_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_NFN_PKG.AUTO_SYNC_NFN_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
89: RAISE;
90:
91: END AUTO_SYNC_NFN_ACC_PROCESSOR;
92:

Line 127: FND_LOG.LEVEL_PROCEDURE );

123:
124: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_INSERT:'
125: || ' for PK ' || p_record.notification_id,
126: 'CSM_AUTO_SYNC_NFN.APPLY_INSERT',
127: FND_LOG.LEVEL_PROCEDURE );
128:
129: /***************************************************************************
130: ** Initialize API return status to success
131: **************************************************************************/

Line 192: FND_LOG.LEVEL_ERROR );

188: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
189: || ' ROOT ERROR: create statement'
190: || ' for PK ' || p_record.NOTIFICATION_ID,
191: g_object_name || '.APPLY_INSERT',
192: FND_LOG.LEVEL_ERROR );
193: RETURN ;
194: END IF;
195:
196: -- success

Line 204: FND_LOG.LEVEL_EXCEPTION );

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

Line 254: FND_LOG.LEVEL_PROCEDURE );

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

Line 333: FND_LOG.LEVEL_EXCEPTION );

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

Line 383: FND_LOG.LEVEL_ERROR);

379: CSM_UTIL_PKG.LOG
380: ( 'Delete and Update is not supported for this entity'
381: || ' for PK ' || p_record.notification_id ,
382: g_object_name || '.APPLY_RECORD',
383: FND_LOG.LEVEL_ERROR);
384:
385: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
386: (
387: p_message => 'CSM_DML_OPERATION'

Line 402: FND_LOG.LEVEL_EXCEPTION);

398: CSM_UTIL_PKG.LOG
399: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
400: || ' for PK ' || p_record.notification_id ,
401: g_object_name || '.APPLY_RECORD',
402: FND_LOG.LEVEL_EXCEPTION);
403: -- temp -- find more detail --remove comment
404: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
405: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
406: (

Line 434: FND_LOG.LEVEL_PROCEDURE);

430: l_reject_row boolean;
431: BEGIN
432:
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 504: FND_LOG.LEVEL_ERROR); -- put PK column here

500: CSM_UTIL_PKG.LOG
501: ( 'Deleting from inqueue failed, rolling back to savepoint'
502: || ' for PK ' || r_auto_sync_nfn.notification_id ,
503: g_object_name || '.APPLY_CLIENT_CHANGES',
504: FND_LOG.LEVEL_ERROR); -- put PK column here
505: ROLLBACK TO save_rec;
506: x_return_status := FND_API.G_RET_STS_ERROR;
507: END IF;
508: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/

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

513: CSM_UTIL_PKG.LOG
514: ( 'Record not processed successfully, deferring and rejecting record'
515: || ' for PK ' || r_auto_sync_nfn.notification_id ,
516: g_object_name || '.APPLY_CLIENT_CHANGES',
517: FND_LOG.LEVEL_ERROR); -- put PK column here
518:
519: CSM_UTIL_PKG.DEFER_RECORD
520: ( p_user_name
521: , p_tranid

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

534: CSM_UTIL_PKG.LOG
535: ( 'Defer record failed, rolling back to savepoint'
536: || ' for PK ' || r_auto_sync_nfn.notification_id ,
537: g_object_name || '.APPLY_CLIENT_CHANGES',
538: FND_LOG.LEVEL_ERROR); -- put PK column here
539: ROLLBACK TO save_rec;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: END IF;
542: END IF;

Line 551: FND_LOG.LEVEL_EXCEPTION);

547: /*** catch and log exceptions ***/
548: CSM_UTIL_PKG.LOG
549: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
550: g_object_name || '.APPLY_CLIENT_CHANGES',
551: FND_LOG.LEVEL_EXCEPTION);
552: x_return_status := FND_API.G_RET_STS_ERROR;
553:
554: END APPLY_CLIENT_CHANGES;
555: