DBA Data[Home] [Help]

APPS.CSM_LOBS_EVENT_PKG dependencies on FND_LOG

Line 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);

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:
412: --Bug 4938130

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