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.

[Home] [Help]

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 2008/02/07 07:07:17 anaraman ship $*/
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 190: WHERE package_name = 'CSM_LOBS_EVENT_PKG'

186: --If the max size of attachment is less than 1, then exit.
187: IF (TO_NUMBER(FND_PROFILE.Value('CSM_MAX_ATTACHMENT_SIZE')) < 1) THEN
188: /*Update the last run date*/
189: UPDATE jtm_con_request_data SET last_run_date = l_run_date
190: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
191: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
192:
193: COMMIT;
194:

Line 196: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '

192:
193: COMMIT;
194:
195: p_status := 'FINE';
196: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '
197: || ' Executed successfully';
198:
199: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
200: jtm_message_log_pkg.Log_Msg

Line 392: WHERE package_name = 'CSM_LOBS_EVENT_PKG'

388:
389: -- set the program update date in jtm_con_request_data to sysdate
390: UPDATE jtm_con_request_data
391: SET last_run_date = l_run_date
392: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
393: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
394:
395: COMMIT;
396:

Line 398: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '

394:
395: COMMIT;
396:
397: p_status := 'FINE';
398: p_message := 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS '
399: || ' Executed successfully';
400:
401: EXCEPTION
402: WHEN others THEN

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

403: l_sqlerrno := to_char(SQLCODE);
404: l_sqlerrmsg := substr(SQLERRM, 1,2000);
405: p_status := 'ERROR';
406: p_message := 'Error in '||
407: 'CSM_LOBS_EVENT_PKG.CONC_DOWNLOAD_ATTACHMENTS: ' || l_sqlerrno || ':' || l_sqlerrmsg;
408: 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);
409: ROLLBACK;
410: END CONC_DOWNLOAD_ATTACHMENTS;
411:

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

935: l_language_user VARCHAR(10);
936:
937: BEGIN
938: CSM_UTIL_PKG.LOG('Entering INSERT_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
939: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
940:
941: l_publicationitemname := 'CSF_M_LOBS';
942:
943:

Line 956: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'

952: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
953: jtm_message_log_pkg.Log_Msg
954: ( 0
955: , g_table_name
956: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD'
957: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
958: );
959: END IF;
960:

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

1025: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1026: jtm_message_log_pkg.Log_Msg
1027: ( 0
1028: , g_table_name
1029: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD - Max att download size is less than 1'
1030: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1031: );
1032: END IF;
1033: RETURN;

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

1167:
1168: END IF;
1169:
1170: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1171: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1172: EXCEPTION
1173: WHEN l_excep_markdirty_failed THEN
1174: l_error_msg := ' FAILED MarkDirty in INSERT_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);
1175: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

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

1171: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1172: EXCEPTION
1173: WHEN l_excep_markdirty_failed THEN
1174: l_error_msg := ' FAILED MarkDirty in INSERT_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);
1175: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1176: RAISE;
1177:
1178: WHEN OTHERS THEN
1179: l_sqlerrno := to_char(SQLCODE);

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

1179: l_sqlerrno := to_char(SQLCODE);
1180: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1181: l_error_msg := ' Exception in INSERT_ACC_RECORD for task_assignment_id:'
1182: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1183: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1184: RAISE;
1185: END INSERT_ACC_RECORD;
1186:
1187: --Bug 4938130

Line 1254: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

1250: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1251: jtm_message_log_pkg.Log_Msg
1252: ( p_task_assignment_id
1253: , g_table_name
1254: , 'Entering CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1256: END IF;
1257:
1258: --cursor to get language

Line 1381: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'

1377: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1378: jtm_message_log_pkg.Log_Msg
1379: ( p_task_assignment_id
1380: , g_table_name
1381: , 'Exiting CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD'
1382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1383: END IF;
1384:
1385: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,

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

1382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
1383: END IF;
1384:
1385: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC_RECORD for task_assignment_id: ' || p_task_assignment_id,
1386: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1387: EXCEPTION
1388: WHEN l_excep_markdirty_failed THEN
1389: l_error_msg := ' FAILED MarkDirty in DELETE_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);
1390: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);

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

1386: 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_PROCEDURE);
1387: EXCEPTION
1388: WHEN l_excep_markdirty_failed THEN
1389: l_error_msg := ' FAILED MarkDirty in DELETE_ACC_RECORD for task_assignment_id:' || to_char(p_task_assignment_id);
1390: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1391: RAISE;
1392:
1393: WHEN OTHERS THEN
1394: l_sqlerrno := to_char(SQLCODE);

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

1394: l_sqlerrno := to_char(SQLCODE);
1395: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1396: l_error_msg := ' Exception in DELETE_ACC_RECORD for task_assignment_id:'
1397: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1398: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.DELETE_ACC_RECORD',FND_LOG.LEVEL_EXCEPTION);
1399: RAISE;
1400: END DELETE_ACC_RECORD;
1401:
1402:

Line 1545: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_PROCEDURE);

1541: g_debug_level NUMBER;
1542:
1543: BEGIN
1544: CSM_UTIL_PKG.LOG('Entering INSERT_ACC_ON_UPLOAD for task_assignment_id: ' || p_PK1_value,
1545: 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_PROCEDURE);
1546:
1547: l_publicationitemname := 'CSF_M_LOBS';
1548:
1549: ---DOWNLOAD SR AND TASK Attachments

Line 1556: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'

1552: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1553: jtm_message_log_pkg.Log_Msg
1554: ( 0
1555: , g_table_name
1556: , 'Entering CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD'
1557: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1558: );
1559: END IF;
1560: --If the max size of attachment is less than 1, then exit.(this should be done only

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

1563: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1564: jtm_message_log_pkg.Log_Msg
1565: ( 0
1566: , g_table_name
1567: , 'Leaving CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD - Max att download size is less than 1'
1568: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
1569: );
1570: END IF;
1571: RETURN;

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

1676: l_sqlerrno := to_char(SQLCODE);
1677: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1678: l_error_msg := ' Exception in INSERT_ACC_ON_UPLOAD for PK1_value:'
1679: || to_char(p_PK1_value) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1680: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_LOBS_EVENT_PKG.INSERT_ACC_ON_UPLOAD',FND_LOG.LEVEL_EXCEPTION);
1681: RAISE;
1682:
1683: END INSERT_ACC_ON_UPLOAD;
1684:

Line 1686: END CSM_LOBS_EVENT_PKG;

1682:
1683: END INSERT_ACC_ON_UPLOAD;
1684:
1685:
1686: END CSM_LOBS_EVENT_PKG;