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_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 167: CSM_UTIL_PKG.LOG( 'HA Tracking of Attachments','CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS', FND_LOG.LEVEL_PROCEDURE);

163: BEGIN
164: l_ha_mode:= CSM_HA_SERVICE_PUB.GET_HA_STATUS;
165:
166: IF(l_ha_mode='HA_RECORD') THEN
167: CSM_UTIL_PKG.LOG( 'HA Tracking of Attachments','CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS', FND_LOG.LEVEL_PROCEDURE);
168: CSM_HA_EVENT_PKG.TRACK_HA_ATTACHMENTS;
169: END IF;
170:
171: -- data program is run

Line 473: CSM_UTIL_PKG.LOG('CSM_CSI_ITEM_ATTR_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_CSI_ITEM_ATTR_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);

469: l_sqlerrmsg := substr(SQLERRM, 1,2000);
470: p_status := 'ERROR';
471: p_message := 'Error in '||
472: 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS: ' || l_sqlerrno || ':' || l_sqlerrmsg;
473: CSM_UTIL_PKG.LOG('CSM_CSI_ITEM_ATTR_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_CSI_ITEM_ATTR_EVENT_PKG.Refresh_acc',FND_LOG.LEVEL_EXCEPTION);
474: ROLLBACK;
475: END CONC_DOWNLOAD_ATTACHMENTS;
476:
477: --Bug 4938130

Line 1003: CSM_UTIL_PKG.LOG('Entering INSERT_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,

999: l_excep_markdirty_failed EXCEPTION;
1000: l_language_user VARCHAR(10);
1001:
1002: BEGIN
1003: CSM_UTIL_PKG.LOG('Entering INSERT_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1004: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1005:
1006: l_publicationitemname := 'CSF_M_LOBS';
1007:

Line 1235: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,

1231: COMMIT;
1232:
1233: END IF;
1234:
1235: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1236: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1237: EXCEPTION
1238: WHEN l_excep_markdirty_failed THEN
1239: l_error_msg := ' FAILED MarkDirty in INSERT_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);

Line 1240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

1236: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1237: EXCEPTION
1238: WHEN l_excep_markdirty_failed THEN
1239: l_error_msg := ' FAILED MarkDirty in INSERT_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);
1240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1241: RAISE;
1242:
1243: WHEN OTHERS THEN
1244: l_sqlerrno := to_char(SQLCODE);

Line 1248: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

1244: l_sqlerrno := to_char(SQLCODE);
1245: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1246: l_error_msg := ' Exception in INSERT_ACC_RECORD for task_assignment_id:'
1247: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1248: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1249: RAISE;
1250: END INSERT_ACC_RECORD;
1251:
1252: --Bug 4938130

Line 1450: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,

1446: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1448: END IF;
1449:
1450: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1451: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1452: EXCEPTION
1453: WHEN l_excep_markdirty_failed THEN
1454: l_error_msg := ' FAILED MarkDirty in DELETE_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);

Line 1455: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

1451: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1452: EXCEPTION
1453: WHEN l_excep_markdirty_failed THEN
1454: l_error_msg := ' FAILED MarkDirty in DELETE_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);
1455: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1456: RAISE;
1457:
1458: WHEN OTHERS THEN
1459: l_sqlerrno := to_char(SQLCODE);

Line 1463: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

1459: l_sqlerrno := to_char(SQLCODE);
1460: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1461: l_error_msg := ' Exception in DELETE_ACC_RECORD for task_assignment_id:'
1462: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1463: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1464: RAISE;
1465: END DELETE_ACC_RECORD;
1466:
1467:

Line 1609: CSM_UTIL_PKG.LOG('Entering INSERT_ACC_ON_UPLOAD for task_assignment_id: ' || p_PK1_value,

1605: l_dummy BOOLEAN;
1606: g_debug_level NUMBER;
1607:
1608: BEGIN
1609: CSM_UTIL_PKG.LOG('Entering INSERT_ACC_ON_UPLOAD for task_assignment_id: ' || p_PK1_value,
1610: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_PROCEDURE);
1611:
1612: l_publicationitemname := 'CSF_M_LOBS';
1613:

Line 1745: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_EXCEPTION);

1741: l_sqlerrno := to_char(SQLCODE);
1742: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1743: l_error_msg := ' Exception in INSERT_ACC_ON_UPLOAD for PK1_value:'
1744: || to_char(p_PK1_value) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1745: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_EXCEPTION);
1746: RAISE;
1747:
1748: END INSERT_ACC_ON_UPLOAD;
1749: