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

Line 170: FND_LOG.LEVEL_PROCEDURE );

166:
167: l_error_msg := 'Entering ' || g_object_name || '.APPLY_INSERT'|| ' for PK ' || to_char( p_record.file_id);
168: CSM_UTIL_PKG.LOG ( l_error_msg ,
169: 'CSM_LOBS_PKG.APPLY_INSERT',
170: FND_LOG.LEVEL_PROCEDURE );
171:
172: --if attachments are not part of what we support then we leave
173: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN
174:

Line 177: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE );

173: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN
174:
175: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT'||
176: ' as we are not supporting Attachment for the entity' || TO_CHAR(p_record.entity_name);
177: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE );
178: RETURN;
179:
180: END IF;
181:

Line 242: CSM_UTIL_PKG.LOG( p_error_msg ,'CSM_LOBS_PKG.UPLOAD_SR_TASK_LOB', FND_LOG.LEVEL_ERROR );

238: FETCH l_lobs_fileid_csr into l_dummy;
239:
240: IF l_lobs_fileid_csr%FOUND THEN
241: p_error_msg := 'Duplicate Record: File id ' || to_char(l_file_id)|| ' already exists in fnd_lobs table.So generating a new from fnd sequence';
242: CSM_UTIL_PKG.LOG( p_error_msg ,'CSM_LOBS_PKG.UPLOAD_SR_TASK_LOB', FND_LOG.LEVEL_ERROR );
243: l_file_id := NULL;
244: --get the file id from the sequence diretly.As the client sent file id is not proper.
245: SELECT fnd_lobs_s.nextval
246: INTO l_file_id

Line 393: FND_LOG.LEVEL_PROCEDURE );

389:
390: l_error_msg := 'The record is going to get rejected as its successfully inserted into the Base Table.';
391:
392: CSM_UTIL_PKG.LOG ( l_error_msg , 'CSM_LOBS_PKG.APPLY_INSERT',
393: FND_LOG.LEVEL_PROCEDURE );
394:
395: --The attachment is added successfully to the apps.so deferring the original record
396: IF l_data_type_id =5 OR l_data_type_id =1 OR (l_data_type_id = 6 AND l_dodirty = TRUE) THEN
397: --Reject the record for url,short text and for lobs which has new file id

Line 414: FND_LOG.LEVEL_PROCEDURE );

410: END IF;
411:
412: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char (p_record.file_id);
413: CSM_UTIL_PKG.LOG ( l_error_msg , 'CSM_LOBS_PKG.APPLY_INSERT',
414: FND_LOG.LEVEL_PROCEDURE );
415:
416:
417: EXCEPTION WHEN OTHERS THEN
418:

Line 421: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );

417: EXCEPTION WHEN OTHERS THEN
418:
419: l_error_msg := 'Exception occurred in ' || g_object_name || '.APPLY_INSERT and hence leaving it:' || ' ' || sqlerrm
420: || ' for PK ' || to_char (p_record.file_id );
421: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
422: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
423:
424: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE );
425: x_return_status := FND_API.G_RET_STS_ERROR;

Line 449: FND_LOG.LEVEL_PROCEDURE );

445: l_error_msg := 'Entering ' || g_object_name || '.APPLY_RECORD'
446: || ' for PK ' || to_char (p_record.FILE_ID );
447: CSM_UTIL_PKG.LOG ( l_error_msg ,
448: 'CSM_LOBS_PKG.APPLY_RECORD',
449: FND_LOG.LEVEL_PROCEDURE );
450:
451: l_error_msg := 'Processing ' || g_object_name || ' for PK ' || to_char (p_record.FILE_ID) || ' ' ||
452: 'DMLTYPE = ' || p_record.dmltype$$ ;
453:

Line 456: FND_LOG.LEVEL_EVENT );

452: 'DMLTYPE = ' || p_record.dmltype$$ ;
453:
454: CSM_UTIL_PKG.LOG ( l_error_msg ,
455: 'CSM_LOBS_PKG.APPLY_RECORD',
456: FND_LOG.LEVEL_EVENT );
457:
458: IF p_record.dmltype$$='I' THEN
459: -- Process insert
460: APPLY_INSERT

Line 473: FND_LOG.LEVEL_EVENT );

469:
470: l_error_msg := 'Update is not supported for this entity ' || g_object_name;
471: CSM_UTIL_PKG.LOG (l_error_msg,
472: 'CSM_LOBS_PKG.APPLY_RECORD',
473: FND_LOG.LEVEL_EVENT );
474:
475: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
476: (
477: p_message => 'CSM_DML_OPERATION'

Line 490: FND_LOG.LEVEL_EVENT );

486:
487: l_error_msg := 'Delete is not supported for this entity ' || g_object_name ;
488: CSM_UTIL_PKG.LOG( l_error_msg,
489: 'CSM_LOBS_PKG.APPLY_RECORD',
490: FND_LOG.LEVEL_EVENT );
491:
492:
493: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
494: (

Line 506: || g_object_name, 'CSM_LOBS_PKG.APPLY_RECORD', FND_LOG.LEVEL_ERROR);

502: -- invalid dml type
503:
504: CSM_UTIL_PKG.LOG
505: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' for this entity '
506: || g_object_name, 'CSM_LOBS_PKG.APPLY_RECORD', FND_LOG.LEVEL_ERROR);
507:
508: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
509: (
510: p_message => 'CSM_DML_OPERATION'

Line 520: FND_LOG.LEVEL_PROCEDURE );

516: END IF;
517:
518: CSM_UTIL_PKG.LOG ( 'Leaving ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || p_record.FILE_ID,
519: 'CSM_LOBS_LOBS.APPLY_RECORD',
520: FND_LOG.LEVEL_PROCEDURE );
521:
522:
523: EXCEPTION WHEN OTHERS THEN
524: /*** defer record when any process exception occurs ***/

Line 528: || ' for PK ' || p_record.FILE_ID,'CSM_LOBS_LOBS.APPLY_RECORD',FND_LOG.LEVEL_ERROR );

524: /*** defer record when any process exception occurs ***/
525:
526: CSM_UTIL_PKG.LOG
527: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || sqlerrm
528: || ' for PK ' || p_record.FILE_ID,'CSM_LOBS_LOBS.APPLY_RECORD',FND_LOG.LEVEL_ERROR );
529:
530:
531: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
532: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 541: FND_LOG.LEVEL_ERROR );

537:
538: CSM_UTIL_PKG.LOG
539: ( 'Leaving ' || g_object_name || '.APPLY_RECORD'|| ' for PK ' || p_record.FILE_ID,
540: 'CSM_LOBS_LOBS.APPLY_RECORD',
541: FND_LOG.LEVEL_ERROR );
542:
543:
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: END APPLY_RECORD;

Line 569: FND_LOG.LEVEL_PROCEDURE);

565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: CSM_UTIL_PKG.LOG ( 'Entering ' || g_object_name || '.Apply_Client_Changes',
568: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
569: FND_LOG.LEVEL_PROCEDURE);
570:
571:
572: /*** loop through CSF_M_LOBS records in inqueue ***/
573: FOR r_FND_LOBS IN c_FND_LOBS( p_user_name, p_tranid) LOOP

Line 593: FND_LOG.LEVEL_EVENT );

589: CSM_UTIL_PKG.LOG
590: ( 'Record successfully processed, deleting from inqueue ' || g_object_name
591: || ' for PK ' || r_FND_LOBS.FILE_ID,
592: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
593: FND_LOG.LEVEL_EVENT );
594:
595:
596: CSM_UTIL_PKG.DELETE_RECORD
597: (

Line 615: FND_LOG.LEVEL_EVENT);

611: CSM_UTIL_PKG.LOG
612: ( 'Deleting from inqueue failed, rolling back to savepoint for entity ' || g_object_name
613: || ' and PK ' || r_FND_LOBS.FILE_ID,
614: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES' ,
615: FND_LOG.LEVEL_EVENT);
616:
617: ROLLBACK TO save_rec;
618: END IF;
619: END IF;

Line 628: FND_LOG.LEVEL_EVENT );

624: CSM_UTIL_PKG.LOG
625: ( 'Record not processed successfully, deferring and rejecting record for entity ' || g_object_name
626: || ' and PK ' || r_FND_LOBS.FILE_ID,
627: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
628: FND_LOG.LEVEL_EVENT );
629:
630:
631: CSM_UTIL_PKG.DEFER_RECORD
632: (

Line 651: FND_LOG.LEVEL_EVENT );

647: CSM_UTIL_PKG.LOG
648: ( 'Defer record failed, rolling back to savepoint for entity ' || g_object_name
649: || ' and PK ' || r_FND_LOBS.FILE_ID,
650: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
651: FND_LOG.LEVEL_EVENT );
652:
653: ROLLBACK TO save_rec;
654: END IF;
655: END IF;

Line 662: FND_LOG.LEVEL_PROCEDURE);

658:
659:
660: CSM_UTIL_PKG.LOG( 'Leaving ' || g_object_name || '.Apply_Client_Changes',
661: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
662: FND_LOG.LEVEL_PROCEDURE);
663:
664:
665: EXCEPTION WHEN OTHERS THEN
666: /*** catch and log exceptions ***/

Line 668: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES', FND_LOG.LEVEL_ERROR);

664:
665: EXCEPTION WHEN OTHERS THEN
666: /*** catch and log exceptions ***/
667: CSM_UTIL_PKG.LOG ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,
668: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES', FND_LOG.LEVEL_ERROR);
669:
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: END APPLY_CLIENT_CHANGES;
672: