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

Line 54: || SQLERRM,' for PK ' || to_char(p_id) || g_object_name || '.INSERT_AUTO_SYNC_ACC',FND_LOG.LEVEL_EXCEPTION);

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

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

70: FROM csm_auto_sync;
71:
72: BEGIN
73: CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_ACC_PROCESSOR for user_id: ' || p_user_id,
74: g_object_name || '.AUTO_SYNC_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
75:
76:
77: -- get all notifications in which user is a recipient
78: FOR l_rec IN c_id(p_user_id)

Line 85: g_object_name || '.AUTO_SYNC_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

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

Line 92: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_AUTO_SYNC_PKG.AUTO_SYNC_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

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

Line 131: FND_LOG.LEVEL_PROCEDURE );

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

Line 174: FND_LOG.LEVEL_ERROR );

170: CSM_UTIL_PKG.log( 'Error in ' || g_object_name || '.APPLY_INSERT:'
171: || ' ROOT ERROR: create statement'
172: || ' for PK ' || p_record.ID,
173: g_object_name || '.APPLY_INSERT',
174: FND_LOG.LEVEL_ERROR );
175: RETURN ;
176: END IF;
177:
178: -- success

Line 186: FND_LOG.LEVEL_EXCEPTION );

182: WHEN others THEN
183: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_INSERT:'
184: || ' for PK ' || p_record.id,
185: g_object_name || '.APPLY_INSERT',
186: FND_LOG.LEVEL_EXCEPTION );
187:
188: x_return_status := FND_API.G_RET_STS_ERROR;
189:
190: END APPLY_INSERT;

Line 219: FND_LOG.LEVEL_PROCEDURE );

215:
216: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'
217: || ' for PK ' || p_record.id,
218: 'CSM_AUTO_SYNC.APPLY_UPDATE',
219: FND_LOG.LEVEL_PROCEDURE );
220: /***************************************************************************
221: ** Initialize API return status to success
222: ***************************************************************************/
223: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 263: FND_LOG.LEVEL_EXCEPTION );

259: WHEN others THEN
260: CSM_UTIL_PKG.log( 'Exception in ' || g_object_name || '.APPLY_UPDATE:'
261: || ' for PK ' || p_record.id,
262: g_object_name || '.APPLY_UPDATE',
263: FND_LOG.LEVEL_EXCEPTION );
264:
265: x_return_status := FND_API.G_RET_STS_ERROR;
266:
267: END APPLY_UPDATE;

Line 314: FND_LOG.LEVEL_ERROR);

310: CSM_UTIL_PKG.LOG
311: ( 'Delete and Update is not supported for this entity'
312: || ' for PK ' || p_record.id ,
313: g_object_name || '.APPLY_RECORD',
314: FND_LOG.LEVEL_ERROR);
315:
316: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
317: (
318: p_message => 'CSM_DML_OPERATION'

Line 333: FND_LOG.LEVEL_EXCEPTION);

329: CSM_UTIL_PKG.LOG
330: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || SQLERRM
331: || ' for PK ' || p_record.id ,
332: g_object_name || '.APPLY_RECORD',
333: FND_LOG.LEVEL_EXCEPTION);
334: -- temp -- find more detail --remove comment
335: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', SQLERRM);
336: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
337: (

Line 364: FND_LOG.LEVEL_PROCEDURE);

360: l_error_msg VARCHAR2(4000);
361: l_reject_row boolean;
362: BEGIN
363: csm_util_pkg.log ( g_object_name || '.APPLY_CLIENT_CHANGES entered',
364: FND_LOG.LEVEL_PROCEDURE);
365: g_debug_level := p_debug_level;
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367:
368: /*** loop through records in inqueue ***/

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

414: CSM_UTIL_PKG.LOG
415: ( 'Deleting from inqueue failed, rolling back to savepoint'
416: || ' for PK ' || r_auto_sync.id ,
417: g_object_name || '.APPLY_CLIENT_CHANGES',
418: FND_LOG.LEVEL_ERROR); -- put PK column here
419: ROLLBACK TO save_rec;
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422: END IF; /*** end of IF l_process_status = FND_API.G_RET_STS_SUCCESS ***/

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

427: CSM_UTIL_PKG.LOG
428: ( 'Record not processed successfully, deferring and rejecting record'
429: || ' for PK ' || r_auto_sync.id ,
430: g_object_name || '.APPLY_CLIENT_CHANGES',
431: FND_LOG.LEVEL_ERROR); -- put PK column here
432:
433: CSM_UTIL_PKG.DEFER_RECORD
434: ( p_user_name
435: , p_tranid

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

448: CSM_UTIL_PKG.LOG
449: ( 'Defer record failed, rolling back to savepoint'
450: || ' for PK ' || r_auto_sync.id ,
451: g_object_name || '.APPLY_CLIENT_CHANGES',
452: FND_LOG.LEVEL_ERROR); -- put PK column here
453: ROLLBACK TO save_rec;
454: x_return_status := FND_API.G_RET_STS_ERROR;
455: END IF;
456: END IF;

Line 465: FND_LOG.LEVEL_EXCEPTION);

461: /*** catch and log exceptions ***/
462: CSM_UTIL_PKG.LOG
463: ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || SQLERRM,
464: g_object_name || '.APPLY_CLIENT_CHANGES',
465: FND_LOG.LEVEL_EXCEPTION);
466: x_return_status := FND_API.G_RET_STS_ERROR;
467:
468: END APPLY_CLIENT_CHANGES;
469: