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 CSM_UTIL_PKG

Line 61: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC: '

57: ,P_PK1_NUM_VALUE => p_notification_id
58: ,P_USER_ID => p_user_id
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

Line 96: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))

92: FROM WF_NOTIFICATIONS wfn,
93: ASG_USER au
94: WHERE au.user_id=b_user_id
95: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
96: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
97: AND au.enabled='Y'
98: AND (nvl(wfn.begin_date, sysdate) between
99: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
100: AND NOT EXISTS(SELECT 1

Line 106: CSM_UTIL_PKG.LOG('Entering NOTIFICATIONS_ACC_PROCESSOR for user_id: ' || p_user_id,

102: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
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

Line 122: CSM_UTIL_PKG.LOG('Leaving NOTIFICATIONS_ACC_PROCESSOR for user_id: ' || p_user_id,

118: LOOP
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);

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 158: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))

154: FROM WF_NOTIFICATIONS wfn,
155: ASG_USER au
156: WHERE wfn.NOTIFICATION_ID=b_nid
157: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
158: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
159: AND au.enabled='Y'
160: AND (nvl(wfn.begin_date, sysdate) between
161: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
162: AND NOT EXISTS(SELECT 1

Line 172: CSM_UTIL_PKG.LOG('Entering DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,

168: l_sqlerrmsg VARCHAR2(4000);
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';

Line 175: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

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;
178: END IF;
179:

Line 191: CSM_UTIL_PKG.LOG('Leaving DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,

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

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 217: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',

213: l_return_status VARCHAR2(80);
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';

Line 220: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

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;
223:
224: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');

Line 228: CSM_UTIL_PKG.LOG('Leaving NOTIFICATION_ATTR_WF_EVENT_SUB for notification_id: ' || TO_CHAR(l_notification_id),

224: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');
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

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 261: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_DEL_WF_EVENT_SUB',

257: WHERE acc.NOTIFICATION_ID=b_nid;
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';

Line 264: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

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;
267:
268: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');

Line 280: CSM_UTIL_PKG.LOG('Leaving NOTIFICATION_DEL_WF_EVENT_SUB for notification_id: ' || TO_CHAR(l_notification_id),

276: ,P_USER_ID => r_notification_rec.user_id
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

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;