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 159: FND_LOG.LEVEL_PROCEDURE );

155:
156: l_error_msg := 'Entering ' || g_object_name || '.APPLY_INSERT'|| ' for PK ' || to_char( p_record.file_id);
157: CSM_UTIL_PKG.LOG ( l_error_msg ,
158: 'CSM_LOBS_PKG.APPLY_INSERT',
159: FND_LOG.LEVEL_PROCEDURE );
160:
161: --if attachments are not part of what we support then we leave
162: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN
163:

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

162: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN
163:
164: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT'||
165: ' as we are not supporting Attachment for the entity' || TO_CHAR(p_record.entity_name);
166: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_PROCEDURE );
167: RETURN;
168:
169: END IF;
170:

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

227: FETCH l_lobs_fileid_csr into l_dummy;
228:
229: IF l_lobs_fileid_csr%FOUND THEN
230: 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';
231: CSM_UTIL_PKG.LOG( p_error_msg ,'CSM_LOBS_PKG.UPLOAD_SR_TASK_LOB', FND_LOG.LEVEL_ERROR );
232: l_file_id := NULL;
233: --get the file id from the sequence diretly.As the client sent file id is not proper.
234: SELECT fnd_lobs_s.nextval
235: INTO l_file_id

Line 382: FND_LOG.LEVEL_PROCEDURE );

378:
379: l_error_msg := 'The record is going to get rejected as its successfully inserted into the Base Table.';
380:
381: CSM_UTIL_PKG.LOG ( l_error_msg , 'CSM_LOBS_PKG.APPLY_INSERT',
382: FND_LOG.LEVEL_PROCEDURE );
383:
384: --The attachment is added successfully to the apps.so deferring the original record
385: IF l_data_type_id =5 OR l_data_type_id =1 OR (l_data_type_id = 6 AND l_dodirty = TRUE) THEN
386: --Reject the record for url,short text and for lobs which has new file id

Line 403: FND_LOG.LEVEL_PROCEDURE );

399: END IF;
400:
401: l_error_msg := 'Leaving ' || g_object_name || '.APPLY_INSERT' || ' for PK ' || to_char (p_record.file_id);
402: CSM_UTIL_PKG.LOG ( l_error_msg , 'CSM_LOBS_PKG.APPLY_INSERT',
403: FND_LOG.LEVEL_PROCEDURE );
404:
405:
406: EXCEPTION WHEN OTHERS THEN
407:

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

406: EXCEPTION WHEN OTHERS THEN
407:
408: l_error_msg := 'Exception occurred in ' || g_object_name || '.APPLY_INSERT and hence leaving it:' || ' ' || sqlerrm
409: || ' for PK ' || to_char (p_record.file_id );
410: CSM_UTIL_PKG.LOG ( l_error_msg ,'CSM_LOBS_PKG.APPLY_INSERT',FND_LOG.LEVEL_ERROR );
411: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_INSERT', sqlerrm);
412:
413: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE );
414: x_return_status := FND_API.G_RET_STS_ERROR;

Line 438: FND_LOG.LEVEL_PROCEDURE );

434: l_error_msg := 'Entering ' || g_object_name || '.APPLY_RECORD'
435: || ' for PK ' || to_char (p_record.FILE_ID );
436: CSM_UTIL_PKG.LOG ( l_error_msg ,
437: 'CSM_LOBS_PKG.APPLY_RECORD',
438: FND_LOG.LEVEL_PROCEDURE );
439:
440: l_error_msg := 'Processing ' || g_object_name || ' for PK ' || to_char (p_record.FILE_ID) || ' ' ||
441: 'DMLTYPE = ' || p_record.dmltype$$ ;
442:

Line 445: FND_LOG.LEVEL_EVENT );

441: 'DMLTYPE = ' || p_record.dmltype$$ ;
442:
443: CSM_UTIL_PKG.LOG ( l_error_msg ,
444: 'CSM_LOBS_PKG.APPLY_RECORD',
445: FND_LOG.LEVEL_EVENT );
446:
447: IF p_record.dmltype$$='I' THEN
448: -- Process insert
449: APPLY_INSERT

Line 462: FND_LOG.LEVEL_EVENT );

458:
459: l_error_msg := 'Update is not supported for this entity ' || g_object_name;
460: CSM_UTIL_PKG.LOG (l_error_msg,
461: 'CSM_LOBS_PKG.APPLY_RECORD',
462: FND_LOG.LEVEL_EVENT );
463:
464: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
465: (
466: p_message => 'CSM_DML_OPERATION'

Line 479: FND_LOG.LEVEL_EVENT );

475:
476: l_error_msg := 'Delete is not supported for this entity ' || g_object_name ;
477: CSM_UTIL_PKG.LOG( l_error_msg,
478: 'CSM_LOBS_PKG.APPLY_RECORD',
479: FND_LOG.LEVEL_EVENT );
480:
481:
482: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
483: (

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

491: -- invalid dml type
492:
493: CSM_UTIL_PKG.LOG
494: ( 'Invalid DML type: ' || p_record.dmltype$$ || ' for this entity '
495: || g_object_name, 'CSM_LOBS_PKG.APPLY_RECORD', FND_LOG.LEVEL_ERROR);
496:
497: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT
498: (
499: p_message => 'CSM_DML_OPERATION'

Line 509: FND_LOG.LEVEL_PROCEDURE );

505: END IF;
506:
507: CSM_UTIL_PKG.LOG ( 'Leaving ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || p_record.FILE_ID,
508: 'CSM_LOBS_LOBS.APPLY_RECORD',
509: FND_LOG.LEVEL_PROCEDURE );
510:
511:
512: EXCEPTION WHEN OTHERS THEN
513: /*** defer record when any process exception occurs ***/

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

513: /*** defer record when any process exception occurs ***/
514:
515: CSM_UTIL_PKG.LOG
516: ( 'Exception occurred in ' || g_object_name || '.APPLY_RECORD:' || ' ' || sqlerrm
517: || ' for PK ' || p_record.FILE_ID,'CSM_LOBS_LOBS.APPLY_RECORD',FND_LOG.LEVEL_ERROR );
518:
519:
520: fnd_msg_pub.Add_Exc_Msg( g_object_name, 'APPLY_RECORD', sqlerrm);
521: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

Line 530: FND_LOG.LEVEL_ERROR );

526:
527: CSM_UTIL_PKG.LOG
528: ( 'Leaving ' || g_object_name || '.APPLY_RECORD'|| ' for PK ' || p_record.FILE_ID,
529: 'CSM_LOBS_LOBS.APPLY_RECORD',
530: FND_LOG.LEVEL_ERROR );
531:
532:
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: END APPLY_RECORD;

Line 558: FND_LOG.LEVEL_PROCEDURE);

554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555:
556: CSM_UTIL_PKG.LOG ( 'Entering ' || g_object_name || '.Apply_Client_Changes',
557: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
558: FND_LOG.LEVEL_PROCEDURE);
559:
560:
561: /*** loop through CSF_M_LOBS records in inqueue ***/
562: FOR r_FND_LOBS IN c_FND_LOBS( p_user_name, p_tranid) LOOP

Line 582: FND_LOG.LEVEL_EVENT );

578: CSM_UTIL_PKG.LOG
579: ( 'Record successfully processed, deleting from inqueue ' || g_object_name
580: || ' for PK ' || r_FND_LOBS.FILE_ID,
581: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
582: FND_LOG.LEVEL_EVENT );
583:
584:
585: CSM_UTIL_PKG.DELETE_RECORD
586: (

Line 604: FND_LOG.LEVEL_EVENT);

600: CSM_UTIL_PKG.LOG
601: ( 'Deleting from inqueue failed, rolling back to savepoint for entity ' || g_object_name
602: || ' and PK ' || r_FND_LOBS.FILE_ID,
603: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES' ,
604: FND_LOG.LEVEL_EVENT);
605:
606: ROLLBACK TO save_rec;
607: END IF;
608: END IF;

Line 617: FND_LOG.LEVEL_EVENT );

613: CSM_UTIL_PKG.LOG
614: ( 'Record not processed successfully, deferring and rejecting record for entity ' || g_object_name
615: || ' and PK ' || r_FND_LOBS.FILE_ID,
616: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
617: FND_LOG.LEVEL_EVENT );
618:
619:
620: CSM_UTIL_PKG.DEFER_RECORD
621: (

Line 640: FND_LOG.LEVEL_EVENT );

636: CSM_UTIL_PKG.LOG
637: ( 'Defer record failed, rolling back to savepoint for entity ' || g_object_name
638: || ' and PK ' || r_FND_LOBS.FILE_ID,
639: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
640: FND_LOG.LEVEL_EVENT );
641:
642: ROLLBACK TO save_rec;
643: END IF;
644: END IF;

Line 651: FND_LOG.LEVEL_PROCEDURE);

647:
648:
649: CSM_UTIL_PKG.LOG( 'Leaving ' || g_object_name || '.Apply_Client_Changes',
650: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
651: FND_LOG.LEVEL_PROCEDURE);
652:
653:
654: EXCEPTION WHEN OTHERS THEN
655: /*** catch and log exceptions ***/

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

653:
654: EXCEPTION WHEN OTHERS THEN
655: /*** catch and log exceptions ***/
656: CSM_UTIL_PKG.LOG ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,
657: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES', FND_LOG.LEVEL_ERROR);
658:
659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END APPLY_CLIENT_CHANGES;
661: