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 2008/01/25 06:53:17 saradhak 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 158: 'CSM_LOBS_PKG.APPLY_INSERT',

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

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

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

Line 444: 'CSM_LOBS_PKG.APPLY_RECORD',

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

Line 461: 'CSM_LOBS_PKG.APPLY_RECORD',

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

Line 478: 'CSM_LOBS_PKG.APPLY_RECORD',

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

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

659: x_return_status := FND_API.G_RET_STS_ERROR;
660: END APPLY_CLIENT_CHANGES;
661:
662:
663: END CSM_LOBS_PKG;