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_NOTIFICATION_EVENT_PKG dependencies on FND_LOG

Line 63: 'CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC',FND_LOG.LEVEL_EXCEPTION);

59: );
60: EXCEPTION WHEN OTHERS THEN
61: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC: '
62: || sqlerrm|| ' for PK ' || to_char(p_notification_id),
63: 'CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC',FND_LOG.LEVEL_EXCEPTION);
64: RAISE;
65: END INSERT_NOTIFICATIONS_ACC;-- end INSERT_NOTIFICATIONS_ACC
66:
67: --Bug 5337816

Line 107: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

103: AND ACC.USER_ID = AU.USER_ID);
104:
105: BEGIN
106: CSM_UTIL_PKG.LOG('Entering NOTIFICATIONS_ACC_PROCESSOR for user_id: ' || p_user_id,
107: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
108:
109:
110: -- get all notifications in which user is a recipient
111: FOR l_notf_rec IN c_notf(p_user_id)

Line 123: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

119: INSERT_NOTIFICATIONS_ACC (l_notf_rec.notification_id, p_user_id);
120: END LOOP;
121:
122: CSM_UTIL_PKG.LOG('Leaving NOTIFICATIONS_ACC_PROCESSOR for user_id: ' || p_user_id,
123: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
124: EXCEPTION
125: WHEN OTHERS THEN
126: l_sqlerrno := to_char(SQLCODE);
127: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 130: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

126: l_sqlerrno := to_char(SQLCODE);
127: l_sqlerrmsg := substr(SQLERRM, 1,2000);
128: l_error_msg := ' Exception in NOTIFICATIONS_ACC_PROCESSOR for for user_id: ' || p_user_id
129: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
130: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
131: RAISE;
132: END NOTIFICATIONS_ACC_PROCESSOR;
133:
134: --Bug 5337816

Line 173: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);

169: l_error_msg VARCHAR2(4000);
170: BEGIN
171:
172: CSM_UTIL_PKG.LOG('Entering DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,
173: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);
174:
175: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
176: x_return_status :='SUCCESS';
177: RETURN;

Line 192: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);

188: INSERT_NOTIFICATIONS_ACC (p_notification_id, r_rec.user_id);
189: END LOOP;
190:
191: CSM_UTIL_PKG.LOG('Leaving DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,
192: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);
193: x_return_status :='SUCCESS';
194: EXCEPTION
195: WHEN OTHERS THEN
196: l_sqlerrno := TO_CHAR(SQLCODE);

Line 200: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_EXCEPTION);

196: l_sqlerrno := TO_CHAR(SQLCODE);
197: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
198: l_error_msg := ' Exception in DOWNLOAD_NOTIFICATION for notification_id:' || to_char(p_notification_id)
199: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
200: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_EXCEPTION);
201: x_return_status :='ERROR';
202: END DOWNLOAD_NOTIFICATION;
203:
204:

Line 218: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

214:
215: l_notification_id wf_notifications.notification_id%TYPE;
216: BEGIN
217: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',
218: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
219:
220: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
221: RETURN 'SUCCESS';
222: END IF;

Line 229: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

225:
226: DOWNLOAD_NOTIFICATION(l_notification_id,l_return_status);
227:
228: CSM_UTIL_PKG.LOG('Leaving NOTIFICATION_ATTR_WF_EVENT_SUB for notification_id: ' || TO_CHAR(l_notification_id),
229: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
230:
231: RETURN l_return_status;
232: EXCEPTION
233: WHEN OTHERS THEN

Line 238: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);

234: l_sqlerrno := TO_CHAR(SQLCODE);
235: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
236: l_error_msg := ' Exception in NOTIFICATION_ATTR_WF_EVENT_SUB for notification_id:' || to_char(l_notification_id)
237: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
238: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
239: RETURN 'ERROR';
240: END NOTIFICATION_ATTR_WF_EVENT_SUB;
241:
242: --Bug 5337816

Line 262: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

258:
259:
260: BEGIN
261: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_DEL_WF_EVENT_SUB',
262: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
263:
264: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
265: RETURN 'SUCCESS';
266: END IF;

Line 281: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

277: );
278: END LOOP;
279:
280: CSM_UTIL_PKG.LOG('Leaving NOTIFICATION_DEL_WF_EVENT_SUB for notification_id: ' || TO_CHAR(l_notification_id),
281: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
282:
283: RETURN 'SUCCESS';
284: EXCEPTION
285: WHEN OTHERS THEN

Line 290: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);

286: l_sqlerrno := TO_CHAR(SQLCODE);
287: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
288: l_error_msg := ' Exception in NOTIFICATION_DEL_WF_EVENT_SUB for notification_id:' || to_char(l_notification_id)
289: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
290: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
291: RETURN 'ERROR';
292: END NOTIFICATION_DEL_WF_EVENT_SUB;
293:
294: PROCEDURE PURGE_NOTIFICATION_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)

Line 349: CSM_UTIL_PKG.LOG(TO_CHAR(l_purge_notf_tbl.COUNT) || ' records sent for purge', 'CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC',FND_LOG.LEVEL_EVENT);

345: FETCH l_purge_notifications_csr BULK COLLECT INTO l_purge_userid_tbl, l_purge_notf_tbl LIMIT 50;
346: EXIT WHEN l_purge_notf_tbl.COUNT = 0;
347:
348: IF l_purge_notf_tbl.COUNT > 0 THEN
349: CSM_UTIL_PKG.LOG(TO_CHAR(l_purge_notf_tbl.COUNT) || ' records sent for purge', 'CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC',FND_LOG.LEVEL_EVENT);
350: FOR i IN l_purge_notf_tbl.FIRST..l_purge_notf_tbl.LAST LOOP
351: l_notification_id := l_purge_notf_tbl(i);
352: l_user_id := l_purge_userid_tbl(i);
353:

Line 389: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC',FND_LOG.LEVEL_EVENT);

385: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
386: ROLLBACK;
387: l_error_msg := ' Exception in PURGE_NOTIFICATION_CONC for notification:' || to_char(l_notification_id)
388: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
389: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC',FND_LOG.LEVEL_EVENT);
390: p_status := 'ERROR';
391: p_message := 'Error in CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC: ' || l_error_msg;
392: END PURGE_NOTIFICATION_CONC;
393: END CSM_NOTIFICATION_EVENT_PKG;