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 168: CSM_UTIL_PKG.LOG ( l_error_msg ,

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

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

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

Line 399: CSM_UTIL_PKG.REJECT_RECORD (

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
398: --from server instead of one from the client
399: CSM_UTIL_PKG.REJECT_RECORD (
400: p_user_name => p_record.CLID$$CS,
401: p_tranid => p_record.TRANID$$,
402: p_seqno => p_record.SEQNO$$,
403: p_pk => p_record.document_id,

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

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

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

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;
426:
427: END APPLY_INSERT;
428:

Line 447: CSM_UTIL_PKG.LOG ( l_error_msg ,

443:
444:
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) || ' ' ||

Line 454: CSM_UTIL_PKG.LOG ( l_error_msg ,

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

Line 471: CSM_UTIL_PKG.LOG (l_error_msg,

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

Line 475: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

Line 488: CSM_UTIL_PKG.LOG( l_error_msg,

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

Line 493: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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: (
495: p_message => 'CSM_DML_OPERATION'
496: , p_token_name1 => 'DML'
497: , p_token_value1 => p_record.dmltype$$

Line 504: CSM_UTIL_PKG.LOG

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

Line 508: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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

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

514:
515: x_return_status := FND_API.G_RET_STS_ERROR;
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:

Line 526: CSM_UTIL_PKG.LOG

522:
523: EXCEPTION WHEN OTHERS THEN
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:

Line 532: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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
533: (
534: p_api_error => TRUE
535: );
536:

Line 538: CSM_UTIL_PKG.LOG

534: p_api_error => TRUE
535: );
536:
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:

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

563: BEGIN
564: g_debug_level := p_debug_level;
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:

Line 589: CSM_UTIL_PKG.LOG

585:
586: /*** was record processed successfully? ***/
587: IF l_process_status = FND_API.G_RET_STS_SUCCESS THEN
588: /*** Yes -> delete record from inqueue ***/
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 );

Line 596: CSM_UTIL_PKG.DELETE_RECORD

592: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
593: FND_LOG.LEVEL_EVENT );
594:
595:
596: CSM_UTIL_PKG.DELETE_RECORD
597: (
598: p_user_name,
599: p_tranid,
600: r_FND_LOBS.seqno$$,

Line 611: CSM_UTIL_PKG.LOG

607:
608: /*** was delete successful? ***/
609: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
610: /*** no -> rollback ***/
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);

Line 624: CSM_UTIL_PKG.LOG

620:
621: IF l_process_Status <> FND_API.G_RET_STS_SUCCESS THEN
622: /*** Record was not processed successfully or delete failed -> defer and reject record ***/
623:
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 );

Line 631: CSM_UTIL_PKG.DEFER_RECORD

627: 'CSM_LOBS_LOBS.APPLY_CLIENT_CHANGES',
628: FND_LOG.LEVEL_EVENT );
629:
630:
631: CSM_UTIL_PKG.DEFER_RECORD
632: (
633: p_user_name
634: , p_tranid
635: , r_FND_LOBS.seqno$$

Line 647: CSM_UTIL_PKG.LOG

643:
644: /*** Was defer successful? ***/
645: IF l_process_status <> FND_API.G_RET_STS_SUCCESS THEN
646: /*** no -> rollback ***/
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 );

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

656:
657: END LOOP;
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:

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

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