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_LOBS_PKG

Line 1: PACKAGE BODY CSM_LOBS_PKG AS

1: PACKAGE BODY CSM_LOBS_PKG AS
2: /* $Header: csmulobb.pls 120.15.12020000.2 2012/11/29 06:57:55 ravir ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

Line 13: g_object_name CONSTANT VARCHAR2(30) := 'CSM_LOBS_PKG'; -- package name

9:
10: error EXCEPTION;
11:
12: /*** Globals ***/
13: g_object_name CONSTANT VARCHAR2(30) := 'CSM_LOBS_PKG'; -- package name
14: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_M_LOBS'; -- publication item name
15: g_debug_level NUMBER; -- debug level
16:
17: CURSOR c_FND_LOBS( b_user_name VARCHAR2, b_tranid NUMBER) is

Line 169: 'CSM_LOBS_PKG.APPLY_INSERT',

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
173: IF p_record.entity_name NOT IN('JTF_TASKS_B','CS_INCIDENTS','CSF_DEBRIEF_HEADERS') THEN

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 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 448: 'CSM_LOBS_PKG.APPLY_RECORD',

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) || ' ' ||
452: 'DMLTYPE = ' || p_record.dmltype$$ ;

Line 455: 'CSM_LOBS_PKG.APPLY_RECORD',

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
459: -- Process insert

Line 472: 'CSM_LOBS_PKG.APPLY_RECORD',

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
476: (

Line 489: 'CSM_LOBS_PKG.APPLY_RECORD',

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:
493: p_error_msg := CSM_UTIL_PKG.GET_ERROR_MESSAGE_TEXT

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 674: END CSM_LOBS_PKG;

670: x_return_status := FND_API.G_RET_STS_ERROR;
671: END APPLY_CLIENT_CHANGES;
672:
673:
674: END CSM_LOBS_PKG;