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 CSM_UTIL_PKG

Line 51: CSM_UTIL_PKG.LOG( 'Exception occurred in ' || g_object_name || '.INSERT_AUTO_SYNC_NFN_ACC: '

47: ,P_PK1_NUM_VALUE => p_notification_id
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

Line 72: CSM_UTIL_PKG.LOG('Entering AUTO_SYNC_NFN_ACC_PROCESSOR for user_id: ' || p_user_id,

68: FROM CSM_AUTO_SYNC_NFN
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

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

120: WHERE notification_id = b_notification_id;
121:
122: BEGIN
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:

Line 158: CSM_UTIL_PKG.log( 'Test message ' || l_user_id||' , '|| p_record.notification_id||' , '||p_record.object_id ||' , '||p_record.object_name||' , '||p_record.command_id ||' , '||p_record.sync_id );

154:
155: /***************************************************************************
156: ** Check whether the insert was succesfull
157: ***************************************************************************/
158: CSM_UTIL_PKG.log( 'Test message ' || l_user_id||' , '|| p_record.notification_id||' , '||p_record.object_id ||' , '||p_record.object_name||' , '||p_record.command_id ||' , '||p_record.sync_id );
159: /*
160: IF (SQL%NOTFOUND)
161: THEN
162: RAISE NO_DATA_FOUND;

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

184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
185: THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
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 );

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

197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198:
199: 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:

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

247:
248: BEGIN
249:
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: /***************************************************************************

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

326: END IF;
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328:
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:

Line 379: CSM_UTIL_PKG.LOG

375: );
376: ELSE
377: -- Process delete and insert;
378: -- Not supported for this entity
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);

Line 385: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 398: CSM_UTIL_PKG.LOG

394:
395: EXCEPTION
396: WHEN OTHERS THEN
397: /*** defer record when any process exception occurs ***/
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);

Line 405: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
407: p_api_error => TRUE
408: );
409:

Line 433: csm_util_pkg.log ( g_object_name || '.APPLY_CLIENT_CHANGES entered',

429: l_error_msg VARCHAR2(4000);
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:

Line 454: CSM_UTIL_PKG.DELETE_RECORD

450: /***--------------------------------------------------------------**/
451: /*** was record processed successfully? ***/
452: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
453: /*** If Yes -> delete record from inqueue ***/
454: CSM_UTIL_PKG.DELETE_RECORD
455: (
456: p_user_name,
457: p_tranid,
458: r_auto_sync_nfn.seqno$$,

Line 469: CSM_UTIL_PKG.REJECT_RECORD

465:
466: /*
467:
468: IF l_reject_row THEN
469: CSM_UTIL_PKG.REJECT_RECORD
470: (
471: p_user_name,
472: p_tranid,
473: r_auto_sync_nfn.seqno$$,

Line 481: CSM_UTIL_PKG.DELETE_RECORD

477: l_error_msg,
478: l_return_status
479: );
480: ELSE
481: CSM_UTIL_PKG.DELETE_RECORD
482: (
483: p_user_name,
484: p_tranid,
485: r_auto_sync_nfn.seqno$$,

Line 500: CSM_UTIL_PKG.LOG

496:
497: /*** was delete/reject successful? ***/
498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
499: /*** If No -> rollback ***/
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

Line 513: CSM_UTIL_PKG.LOG

509:
510: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
511: /*** Record was not processed successfully or delete failed
512: -> defer and reject record ***/
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

Line 519: CSM_UTIL_PKG.DEFER_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
522: , r_auto_sync_nfn.seqno$$
523: , r_auto_sync_nfn.notification_id

Line 534: CSM_UTIL_PKG.LOG

530:
531: /*** Was defer successful? ***/
532: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
533: /*** no -> rollback ***/
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

Line 548: CSM_UTIL_PKG.LOG

544: END LOOP;
545:
546: EXCEPTION WHEN OTHERS THEN
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;