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 CSM_UTIL_PKG

Line 157: CSM_UTIL_PKG.LOG ( l_error_msg ,

153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: l_dodirty := FALSE;--mark dirty for datatypeid =6 is not necessary
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

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 381: CSM_UTIL_PKG.LOG ( l_error_msg , 'CSM_LOBS_PKG.APPLY_INSERT',

377: CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD(l_task_assignment_id,l_user_id,l_entity_name,l_data_type_id,l_dodirty);
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

Line 388: CSM_UTIL_PKG.REJECT_RECORD (

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
387: --from server instead of one from the client
388: CSM_UTIL_PKG.REJECT_RECORD (
389: p_user_name => p_record.CLID$$CS,
390: p_tranid => p_record.TRANID$$,
391: p_seqno => p_record.SEQNO$$,
392: p_pk => p_record.document_id,

Line 402: CSM_UTIL_PKG.LOG ( l_error_msg , 'CSM_LOBS_PKG.APPLY_INSERT',

398:
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

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 413: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT(p_api_error => TRUE );

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;
415:
416: END APPLY_INSERT;
417:

Line 436: CSM_UTIL_PKG.LOG ( l_error_msg ,

432:
433:
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) || ' ' ||

Line 443: CSM_UTIL_PKG.LOG ( l_error_msg ,

439:
440: l_error_msg := 'Processing ' || g_object_name || ' for PK ' || to_char (p_record.FILE_ID) || ' ' ||
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

Line 460: CSM_UTIL_PKG.LOG (l_error_msg,

456:
457: -- Process update; not supported for this entity
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

Line 464: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 477: CSM_UTIL_PKG.LOG( l_error_msg,

473: ELSIF p_record.dmltype$$='D' THEN
474: -- Process delete; not supported for this entity
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:

Line 482: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
484: p_message => 'CSM_DML_OPERATION'
485: , p_token_name1 => 'DML'
486: , p_token_value1 => p_record.dmltype$$

Line 493: CSM_UTIL_PKG.LOG

489: x_return_status := FND_API.G_RET_STS_ERROR;
490: ELSE
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

Line 497: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 507: CSM_UTIL_PKG.LOG ( 'Leaving ' || g_object_name || '.APPLY_RECORD' || ' for PK ' || p_record.FILE_ID,

503:
504: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 515: CSM_UTIL_PKG.LOG

511:
512: EXCEPTION WHEN OTHERS THEN
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:

Line 521: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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
522: (
523: p_api_error => TRUE
524: );
525:

Line 527: CSM_UTIL_PKG.LOG

523: p_api_error => TRUE
524: );
525:
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:

Line 556: CSM_UTIL_PKG.LOG ( 'Entering ' || g_object_name || '.Apply_Client_Changes',

552: BEGIN
553: g_debug_level := p_debug_level;
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:

Line 578: CSM_UTIL_PKG.LOG

574:
575: /*** was record processed successfully? ***/
576: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
577: /*** Yes -> delete record from inqueue ***/
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 );

Line 585: CSM_UTIL_PKG.DELETE_RECORD

581: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
582: FND_LOG.LEVEL_EVENT );
583:
584:
585: CSM_UTIL_PKG.DELETE_RECORD
586: (
587: p_user_name,
588: p_tranid,
589: r_FND_LOBS.seqno$$,

Line 600: CSM_UTIL_PKG.LOG

596:
597: /*** was delete successful? ***/
598: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
599: /*** no -> rollback ***/
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);

Line 613: CSM_UTIL_PKG.LOG

609:
610: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
611: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
612:
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 );

Line 620: CSM_UTIL_PKG.DEFER_RECORD

616: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
617: FND_LOG.LEVEL_EVENT );
618:
619:
620: CSM_UTIL_PKG.DEFER_RECORD
621: (
622: p_user_name
623: , p_tranid
624: , r_FND_LOBS.seqno$$

Line 636: CSM_UTIL_PKG.LOG

632:
633: /*** Was defer successful? ***/
634: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
635: /*** no -> rollback ***/
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 );

Line 649: CSM_UTIL_PKG.LOG( 'Leaving ' || g_object_name || '.Apply_Client_Changes',

645:
646: END LOOP;
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:

Line 656: CSM_UTIL_PKG.LOG ( 'Exception occurred in ' || g_object_name || '.APPLY_CLIENT_CHANGES:' || ' ' || sqlerrm ,

652:
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;