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_LOBS_EVENT_PKG

Line 1: PACKAGE BODY CSM_LOBS_EVENT_PKG AS

1: PACKAGE BODY CSM_LOBS_EVENT_PKG AS
2: /* $Header: csmelobb.pls 120.10.12010000.2 2010/04/08 06:44:33 saradhak ship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

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 207: WHERE package_name = 'CSM_LOBS_EVENT_PKG'

203: --If the max size of attachment is less than 1, then exit.
204: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
205: /*Update the last run date*/
206: UPDATE jtm_con_request_data SET last_run_date = l_run_date
207: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
208: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
209:
210: COMMIT;
211:

Line 213: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '

209:
210: COMMIT;
211:
212: p_status := 'FINE';
213: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '
214: || ' Executed successfully';
215:
216: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
217: jtm_message_log_pkg.Log_Msg

Line 458: WHERE package_name = 'CSM_LOBS_EVENT_PKG'

454:
455: -- set the program update date in jtm_con_request_data to sysdate
456: UPDATE jtm_con_request_data
457: SET last_run_date = l_run_date
458: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
459: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
460:
461: COMMIT;
462:

Line 464: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS'||' Executed successfully';

460:
461: COMMIT;
462:
463: p_status := 'FINE';
464: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS'||' Executed successfully';
465:
466: EXCEPTION
467: WHEN others THEN
468: l_sqlerrno := to_char(SQLCODE);

Line 472: 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS: ' || l_sqlerrno || ':' || l_sqlerrmsg;

468: l_sqlerrno := to_char(SQLCODE);
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:

Line 1004: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);

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

Line 1021: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'

1017: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1018: jtm_message_log_pkg.Log_Msg
1019: ( 0
1020: , g_table_name
1021: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'
1022: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1023: );
1024: END IF;
1025:

Line 1094: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'

1090: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1091: jtm_message_log_pkg.Log_Msg
1092: ( 0
1093: , g_table_name
1094: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'
1095: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1096: );
1097: END IF;
1098: RETURN;

Line 1236: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);

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);
1240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

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 1319: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

1315: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1316: jtm_message_log_pkg.Log_Msg
1317: ( p_task_assignment_id
1318: , g_table_name
1319: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1320: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1321: END IF;
1322:
1323: --cursor to get language

Line 1446: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

1442: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1443: jtm_message_log_pkg.Log_Msg
1444: ( p_task_assignment_id
1445: , g_table_name
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,

Line 1451: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);

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);
1455: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

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 1610: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_PROCEDURE);

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:
1614: ---DOWNLOAD SR AND TASK Attachments

Line 1621: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'

1617: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1618: jtm_message_log_pkg.Log_Msg
1619: ( 0
1620: , g_table_name
1621: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'
1622: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1623: );
1624: END IF;
1625: --If the max size of attachment is less than 1, then exit.(this should be done only

Line 1632: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'

1628: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1629: jtm_message_log_pkg.Log_Msg
1630: ( 0
1631: , g_table_name
1632: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'
1633: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1634: );
1635: END IF;
1636: RETURN;

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:

Line 1751: END CSM_LOBS_EVENT_PKG;

1747:
1748: END INSERT_ACC_ON_UPLOAD;
1749:
1750:
1751: END CSM_LOBS_EVENT_PKG;