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 38: CSM_UTIL_PKG.LOG('Entered DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);

34: OPEN l_last_run_date_csr;
35: FETCH l_last_run_date_csr INTO l_upd_date;
36: CLOSE l_last_run_date_csr;
37:
38: CSM_UTIL_PKG.LOG('Entered DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);
39: -- set the program update date in jtm_con_request_data to sysdate
40:
41: FOR l_notf_rec IN ( SELECT DISTINCT wfn.notification_id ,au.USER_ID
42: FROM wf_notifications wfn,asg_user au

Line 64: CSM_UTIL_PKG.LOG('Leaving DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);

60: COMMIT;
61:
62: p_status := 'FINE';
63: p_message := 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN Executed successfully';
64: CSM_UTIL_PKG.LOG('Leaving DOWNLOAD_MULTIPLAT_NFN', 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);
65:
66: EXCEPTION
67: WHEN others THEN
68: l_sqlerrno := to_char(SQLCODE);

Line 72: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);

68: l_sqlerrno := to_char(SQLCODE);
69: l_sqlerrmsg := substr(SQLERRM, 1,3000);
70: p_status := 'ERROR';
71: p_message := 'Error in CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN: ' || l_sqlerrno || ':' || l_sqlerrmsg;
72: CSM_UTIL_PKG.LOG('Exception: '||p_message, 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN', FND_LOG.LEVEL_PROCEDURE);
73: ROLLBACK;
74: fnd_file.put_line(fnd_file.log, 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_MULTIPLAT_NFN ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
75: END DOWNLOAD_MULTIPLAT_NFN;
76:

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

114: ,P_PK1_NUM_VALUE => p_notification_id
115: ,P_USER_ID => p_user_id
116: );
117: EXCEPTION WHEN OTHERS THEN
118: CSM_UTIL_PKG.LOG( 'Exception occurred in CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC: '
119: || sqlerrm|| ' for PK ' || to_char(p_notification_id),
120: 'CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC',FND_LOG.LEVEL_EXCEPTION);
121: RAISE;
122: END INSERT_NOTIFICATIONS_ACC;-- end INSERT_NOTIFICATIONS_ACC

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

153: WHERE au.user_id=b_user_id
154: AND wfn.STATUS='OPEN'
155: AND wfn.MESSAGE_TYPE='CSM_MSGS'
156: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
157: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
158: AND au.enabled='Y'
159: AND (nvl(wfn.begin_date, sysdate) between
160: (sysdate - csm_profile_pkg.get_task_history_days(b_user_id))and sysdate)
161: AND NOT EXISTS(SELECT 1

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

163: WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
164: AND ACC.USER_ID = AU.USER_ID);
165:
166: BEGIN
167: CSM_UTIL_PKG.LOG('Entering NOTIFICATIONS_ACC_PROCESSOR for user_id: ' || p_user_id,
168: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
169:
170:
171: -- get all notifications in which user is a recipient

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

179: LOOP
180: INSERT_NOTIFICATIONS_ACC (l_notf_rec.notification_id, p_user_id);
181: END LOOP;
182:
183: CSM_UTIL_PKG.LOG('Leaving NOTIFICATIONS_ACC_PROCESSOR for user_id: ' || p_user_id,
184: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
185: EXCEPTION
186: WHEN OTHERS THEN
187: l_sqlerrno := to_char(SQLCODE);

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

187: l_sqlerrno := to_char(SQLCODE);
188: l_sqlerrmsg := substr(SQLERRM, 1,2000);
189: l_error_msg := ' Exception in NOTIFICATIONS_ACC_PROCESSOR for for user_id: ' || p_user_id
190: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
191: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATIONS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
192: RAISE;
193: END NOTIFICATIONS_ACC_PROCESSOR;
194:
195: --Bug 5337816

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

219: WHERE wfn.NOTIFICATION_ID=b_nid
220: AND wfn.STATUS='OPEN'
221: AND wfn.MESSAGE_TYPE='CSM_MSGS'
222: AND RECIPIENT_ROLE LIKE 'JRES_GRP:%'
223: AND au.user_id =CSM_UTIL_PKG.get_group_owner(substr(WFN.RECIPIENT_ROLE,instr(WFN.RECIPIENT_ROLE,':')+1))
224: AND au.enabled='Y'
225: AND (nvl(wfn.begin_date, sysdate) between
226: (sysdate - csm_profile_pkg.get_task_history_days(au.user_id))and sysdate)
227: AND NOT EXISTS(SELECT 1

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

234: l_error_msg VARCHAR2(4000);
235:
236: BEGIN
237:
238: CSM_UTIL_PKG.LOG('Entering DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,
239: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);
240:
241: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
242: x_return_status :='SUCCESS';

Line 241: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

237:
238: CSM_UTIL_PKG.LOG('Entering DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,
239: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);
240:
241: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
242: x_return_status :='SUCCESS';
243: RETURN;
244: END IF;
245:

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

253: LOOP
254: INSERT_NOTIFICATIONS_ACC (p_notification_id, r_rec.user_id);
255: END LOOP;
256:
257: CSM_UTIL_PKG.LOG('Leaving DOWNLOAD_NOTIFICATION for notification_id: ' || p_notification_id,
258: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);
259: x_return_status :='SUCCESS';
260: EXCEPTION
261: WHEN OTHERS THEN

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

262: l_sqlerrno := TO_CHAR(SQLCODE);
263: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
264: l_error_msg := ' Exception in DOWNLOAD_NOTIFICATION for notification_id:' || to_char(p_notification_id)
265: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
266: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_EXCEPTION);
267: x_return_status :='ERROR';
268: END DOWNLOAD_NOTIFICATION;
269:
270:

Line 284: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',

280:
281: l_notification_id wf_notifications.notification_id%TYPE;
282:
283: BEGIN
284: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',
285: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
286:
287: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
288: RETURN 'SUCCESS';

Line 287: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

283: BEGIN
284: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_ATTR_WF_EVENT_SUB',
285: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
286:
287: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
288: RETURN 'SUCCESS';
289: END IF;
290:
291: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');

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

291: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');
292:
293: DOWNLOAD_NOTIFICATION(l_notification_id,l_return_status);
294:
295: CSM_UTIL_PKG.LOG('Leaving NOTIFICATION_ATTR_WF_EVENT_SUB for notification_id: ' || TO_CHAR(l_notification_id),
296: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
297:
298: RETURN l_return_status;
299: EXCEPTION

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

301: l_sqlerrno := TO_CHAR(SQLCODE);
302: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
303: l_error_msg := ' Exception in NOTIFICATION_ATTR_WF_EVENT_SUB for notification_id:' || to_char(l_notification_id)
304: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
305: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
306: RETURN 'ERROR';
307: END NOTIFICATION_ATTR_WF_EVENT_SUB;
308:
309: --Bug 5337816

Line 328: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_DEL_WF_EVENT_SUB',

324: WHERE acc.NOTIFICATION_ID=b_nid;
325:
326:
327: BEGIN
328: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_DEL_WF_EVENT_SUB',
329: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
330:
331: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
332: RETURN 'SUCCESS';

Line 331: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

327: BEGIN
328: CSM_UTIL_PKG.LOG('Entering NOTIFICATION_DEL_WF_EVENT_SUB',
329: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
330:
331: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
332: RETURN 'SUCCESS';
333: END IF;
334:
335: l_notification_id := p_event.GetValueForParameter('NOTIFICATION_ID');

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

343: ,P_USER_ID => r_notification_rec.user_id
344: );
345: END LOOP;
346:
347: CSM_UTIL_PKG.LOG('Leaving NOTIFICATION_DEL_WF_EVENT_SUB for notification_id: ' || TO_CHAR(l_notification_id),
348: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);
349:
350: RETURN 'SUCCESS';
351: EXCEPTION

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

353: l_sqlerrno := TO_CHAR(SQLCODE);
354: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
355: l_error_msg := ' Exception in NOTIFICATION_DEL_WF_EVENT_SUB for notification_id:' || to_char(l_notification_id)
356: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
357: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_EXCEPTION);
358: RETURN 'ERROR';
359: END NOTIFICATION_DEL_WF_EVENT_SUB;
360:
361: PROCEDURE PURGE_NOTIFICATION_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)

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

511: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
512: ROLLBACK;
513: l_error_msg := ' Exception in PURGE_NOTIFICATION_CONC for notification:' || to_char(l_notification_id)
514: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
515: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC',FND_LOG.LEVEL_EVENT);
516: p_status := 'ERROR';
517: p_message := 'Error in CSM_NOTIFICATION_EVENT_PKG.PURGE_NOTIFICATION_CONC: ' || l_error_msg;
518: END PURGE_NOTIFICATION_CONC;
519:

Line 550: CSM_UTIL_PKG.LOG('Mailer by name: '||l_comp_name || ' ,with email id: '||l_email_id ||' and status: '

546: OPEN c_mailer_email;
547: FETCH c_mailer_email INTO l_comp_name,l_email_id,l_status,l_dummy;
548: CLOSE c_mailer_email;
549:
550: CSM_UTIL_PKG.LOG('Mailer by name: '||l_comp_name || ' ,with email id: '||l_email_id ||' and status: '
551: || l_status, 'CSM_NOTIFICATION_EVENT_PKG.get_Mailer_EmailId',FND_LOG.LEVEL_PROCEDURE);
552:
553: IF l_email_id IS NULL OR l_email_id ='' THEN
554: OPEN c_seeded_mailer;

Line 558: CSM_UTIL_PKG.LOG('Email Id of running mailer is null so trying with seeded Mailer''s email address ='||l_email_id,

554: OPEN c_seeded_mailer;
555: FETCH c_seeded_mailer INTO l_email_id;
556: CLOSE c_seeded_mailer;
557:
558: CSM_UTIL_PKG.LOG('Email Id of running mailer is null so trying with seeded Mailer''s email address ='||l_email_id,
559: 'CSM_NOTIFICATION_EVENT_PKG.get_Mailer_EmailId',FND_LOG.LEVEL_PROCEDURE);
560:
561: END IF;
562:

Line 600: CSM_UTIL_PKG.LOG('Creating WF Process for recipient :'||p_recipient_role||' with item key:'||l_item_key,

596: l_template := p_wf_param.getValueForParameter('TEMPLATE'); --wf_msg_name
597:
598: l_item_key := l_template||'<->'||to_char(systimestamp)||'<->'||p_recipient_role;
599:
600: CSM_UTIL_PKG.LOG('Creating WF Process for recipient :'||p_recipient_role||' with item key:'||l_item_key,
601: 'CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess',FND_LOG.LEVEL_PROCEDURE);
602:
603: IF l_template <> 'DOWNLOAD_INIT_MSG' THEN
604: l_processName := 'CSM_NFN_PROCESS';

Line 820: CSM_UTIL_PKG.LOG('Error in WF Process with item key:'||l_item_key ||' . Failed with status '||l_status

816: AND ITEM_KEY = l_item_key;
817: EXCEPTION
818: WHEN OTHERS THEN
819: wf_engine.itemStatus(g_ItemType,l_item_key,l_status,l_result);
820: CSM_UTIL_PKG.LOG('Error in WF Process with item key:'||l_item_key ||' . Failed with status '||l_status
821: ||' , and result: '||l_result,'CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess',FND_LOG.LEVEL_PROCEDURE);
822: return -1;
823: END;
824:

Line 851: CSM_UTIL_PKG.LOG('No FND Email found for user CSM_'||b_user_name||'_ROLE in createMobileWFUser',

847: FROM FND_USER WHERE USER_NAME=b_user_name
848: AND sysdate between nvl(start_date,sysdate-1) and nvl(end_date,sysdate+1);
849:
850: IF(l_fnd_email is NULL) THEN
851: CSM_UTIL_PKG.LOG('No FND Email found for user CSM_'||b_user_name||'_ROLE in createMobileWFUser',
852: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
853: RETURN FALSE;
854: END IF;
855:

Line 884: CSM_UTIL_PKG.LOG('No FND Email found for user '||b_user_name||' in createMobileWFUser.',

880: AND sysdate between nvl(fu.start_date,sysdate-1) and nvl(fu.end_date,sysdate+1)
881: AND wf.name=fu.USER_NAME AND au.USER_NAME=fu.USER_NAME AND au.ENABLED='Y' ;
882:
883: IF(l_fnd_email is NULL) THEN
884: CSM_UTIL_PKG.LOG('No FND Email found for user '||b_user_name||' in createMobileWFUser.',
885: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
886: RETURN FALSE;
887: END IF;
888:

Line 897: CSM_UTIL_PKG.LOG('Exception in createMobileWFUser for user'||b_user_name||': '||l_err_msg,

893: RETURN TRUE;
894: EXCEPTION
895: WHEN OTHERS THEN
896: l_err_msg := TO_CHAR(SQLCODE)|| ':'||SUBSTR(SQLERRM, 1,2000);
897: CSM_UTIL_PKG.LOG('Exception in createMobileWFUser for user'||b_user_name||': '||l_err_msg,
898: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
899: CSM_UTIL_PKG.LOG('If SQL DATA NOT FOUND error, then reason is that User '||b_user_name||' is not an active FND nor a mobile enabled user.',
900: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
901: RETURN FALSE;

Line 899: CSM_UTIL_PKG.LOG('If SQL DATA NOT FOUND error, then reason is that User '||b_user_name||' is not an active FND nor a mobile enabled user.',

895: WHEN OTHERS THEN
896: l_err_msg := TO_CHAR(SQLCODE)|| ':'||SUBSTR(SQLERRM, 1,2000);
897: CSM_UTIL_PKG.LOG('Exception in createMobileWFUser for user'||b_user_name||': '||l_err_msg,
898: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
899: CSM_UTIL_PKG.LOG('If SQL DATA NOT FOUND error, then reason is that User '||b_user_name||' is not an active FND nor a mobile enabled user.',
900: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);
901: RETURN FALSE;
902: END createMobileWFUser;
903:

Line 911: IF CSM_UTIL_PKG.is_new_mmu_user(b_user_name) THEN

907: l_err_msg VARCHAR2(2000);
908: l_wf_param wf_event_t;
909: BEGIN
910:
911: IF CSM_UTIL_PKG.is_new_mmu_user(b_user_name) THEN
912: CSM_UTIL_PKG.LOG(b_user_name||' is a new or not a mobile user, so skip sending notification.','CSM_NOTIFICATION_EVENT_PKG.SEND_EMAIL',FND_LOG.LEVEL_PROCEDURE);
913: RETURN -1;
914: END IF;
915:

Line 912: CSM_UTIL_PKG.LOG(b_user_name||' is a new or not a mobile user, so skip sending notification.','CSM_NOTIFICATION_EVENT_PKG.SEND_EMAIL',FND_LOG.LEVEL_PROCEDURE);

908: l_wf_param wf_event_t;
909: BEGIN
910:
911: IF CSM_UTIL_PKG.is_new_mmu_user(b_user_name) THEN
912: CSM_UTIL_PKG.LOG(b_user_name||' is a new or not a mobile user, so skip sending notification.','CSM_NOTIFICATION_EVENT_PKG.SEND_EMAIL',FND_LOG.LEVEL_PROCEDURE);
913: RETURN -1;
914: END IF;
915:
916: IF NOT createMobileWFUser(b_user_name) THEN

Line 932: CSM_UTIL_PKG.LOG('Exception in send_email while sending notification for user'||b_user_name||': '||l_err_msg,

928:
929: EXCEPTION
930: WHEN OTHERS THEN
931: l_err_msg := TO_CHAR(SQLCODE)|| ':'||SUBSTR(SQLERRM, 1,2000);
932: CSM_UTIL_PKG.LOG('Exception in send_email while sending notification for user'||b_user_name||': '||l_err_msg,
933: 'CSM_NOTIFICATION_EVENT_PKG.SEND_EMAIL',FND_LOG.LEVEL_PROCEDURE);
934: return -1;
935: END send_email;
936:

Line 1056: CSM_UTIL_PKG.LOG('Email Optimized for '||p_entity||'-'||p_pk||'-'||p_user_id,

1052: close c_task_asg;
1053: END IF;
1054:
1055: IF l_result=1 THEN
1056: CSM_UTIL_PKG.LOG('Email Optimized for '||p_entity||'-'||p_pk||'-'||p_user_id,
1057: 'CSM_NOTIFICATION_EVENT_PKG.email_optimization',FND_LOG.LEVEL_PROCEDURE);
1058: RETURN TRUE;
1059: END IF;
1060:

Line 1296: CSM_UTIL_PKG.LOG('Entering NOTIFY USER for NOTIFY '||l_mode||' OF:' || l_entity || ' for PK:'||l_pk_value,

1292:
1293: l_pk_value := to_number(p_wf_param.getValueForParameter('PK_VALUE'));
1294: l_mode := p_wf_param.getValueForParameter('MODE');
1295:
1296: CSM_UTIL_PKG.LOG('Entering NOTIFY USER for NOTIFY '||l_mode||' OF:' || l_entity || ' for PK:'||l_pk_value,
1297: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1298:
1299: IF(l_entity= 'CSM_TASKS') THEN -- Only Update mode (Called from csmewfb.pls)
1300: l_entity:='TASK';

Line 1385: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER as there is no email found for user - '||l_user_id,

1381: END IF;
1382:
1383: IF l_email_address IS NULL THEN
1384:
1385: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER as there is no email found for user - '||l_user_id,
1386: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1387: RETURN;
1388: END IF;
1389:

Line 1448: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER as there is no email found for user - '||l_user_id,

1444: FETCH c_parts INTO l_user_id,l_user_name,l_email_address,l_item_name,l_item_desc,l_inv_code,l_qty,l_uom;
1445: CLOSE c_parts;
1446:
1447: IF l_email_address IS NULL THEN
1448: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER as there is no email found for user - '||l_user_id,
1449: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1450: RETURN;
1451: END IF;
1452:

Line 1477: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER as there is no email found for user - '||l_user_id,

1473: l_order_number,l_order_status,l_arrival_date;
1474: CLOSE c_req_lines;
1475:
1476: IF l_email_address IS NULL THEN
1477: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER as there is no email found for user - '||l_user_id,
1478: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1479: RETURN;
1480: END IF;
1481:

Line 1542: CSM_UTIL_PKG.LOG('Invoke timer for '||l_not_tab(I),

1538: ,P_PK1_NUM_VALUE => l_not_tab(I)
1539: ,P_USER_ID => l_usr_tab(I)
1540: );
1541:
1542: CSM_UTIL_PKG.LOG('Invoke timer for '||l_not_tab(I),
1543: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1544:
1545: OPEN c_get_resp_id(l_usr_tab(I));
1546: FETCH c_get_resp_id INTO l_app_id,l_resp_id;

Line 1566: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER after notifying users to start sync',

1562: END IF;
1563: END LOOP;
1564:
1565: IF l_cnt > 0 THEN
1566: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER after notifying users to start sync',
1567: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1568: ELSE
1569: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER. There was no entity or non-multi-platform User found to be notified',
1570: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

Line 1569: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER. There was no entity or non-multi-platform User found to be notified',

1565: IF l_cnt > 0 THEN
1566: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER after notifying users to start sync',
1567: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1568: ELSE
1569: CSM_UTIL_PKG.LOG('Leaving NOTIFY_USER. There was no entity or non-multi-platform User found to be notified',
1570: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);
1571: END IF;
1572:
1573: END NOTIFY_USER;

Line 1583: CSM_UTIL_PKG.LOG( 'In NOTIFY_RESPONSE for command:"'||command||'" with item_key :' || p_item_key

1579: l_text_value VARCHAR2(100);
1580: l_nid NUMBER;
1581: BEGIN
1582:
1583: CSM_UTIL_PKG.LOG( 'In NOTIFY_RESPONSE for command:"'||command||'" with item_key :' || p_item_key
1584: ||' and activity_id :'||activity_id,'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_RESPONSE',FND_LOG.LEVEL_PROCEDURE);
1585:
1586: IF(item_type='CSM_MSGS' and command = 'RESPOND') THEN
1587:

Line 1597: CSM_UTIL_PKG.LOG( 'Exception occurred in NOTIFY_RESPONSE for item_key :' || p_item_key ||' and activity_id :'

1593: and item_key=p_item_key) and name='RESULT';
1594:
1595: EXCEPTION
1596: WHEN Others THEN
1597: CSM_UTIL_PKG.LOG( 'Exception occurred in NOTIFY_RESPONSE for item_key :' || p_item_key ||' and activity_id :'
1598: ||activity_id|| '->'|| sqlerrm, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_RESPONSE',FND_LOG.LEVEL_EXCEPTION);
1599: RETURN;
1600: END;
1601:

Line 1649: CSM_UTIL_PKG.LOG('TIMER MODULE ENTERED on '|| to_char(sysdate,'DD-MON-YY HH:MI:SS AM') ||' with nid:'||l_nid||' and try:'||l_try,

1645: l_nid := to_number(p_event.GetValueForParameter('NOTIFICATION_ID'));
1646: l_try := to_number(p_event.GetValueForParameter('TRIES'));
1647: l_role := p_event.GetValueForParameter('SENT_TO');
1648:
1649: CSM_UTIL_PKG.LOG('TIMER MODULE ENTERED on '|| to_char(sysdate,'DD-MON-YY HH:MI:SS AM') ||' with nid:'||l_nid||' and try:'||l_try,
1650: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);
1651:
1652: OPEN c_response(l_nid);
1653: FETCH c_response INTO l_check;

Line 1657: CSM_UTIL_PKG.LOG('Response received in try#'||l_try ||' for nid: '||l_nid,

1653: FETCH c_response INTO l_check;
1654: CLOSE c_response;
1655:
1656: IF l_check = 1 THEN
1657: CSM_UTIL_PKG.LOG('Response received in try#'||l_try ||' for nid: '||l_nid,
1658: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);
1659: RETURN 'SUCCESS';
1660: END IF;
1661:

Line 1697: CSM_UTIL_PKG.LOG('Email Id '||l_nid||' is not answered by '||substr(l_role,5,length(l_role)-9),

1693: p_event_key=>to_char(l_nid),p_parameters=>l_wftimer.getParameterList,
1694: p_event_data=>null,p_send_date=>(sysdate+(l_timeout*60*0.000011574)));
1695: ELSE
1696:
1697: CSM_UTIL_PKG.LOG('Email Id '||l_nid||' is not answered by '||substr(l_role,5,length(l_role)-9),
1698: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);
1699:
1700: wf_event_t.initialize(l_wftimer);
1701: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_nid));

Line 1713: CSM_UTIL_PKG.LOG('exception while processing '||l_nid||' : '||l_sql_code||':'||l_err_msg,

1709: EXCEPTION
1710: WHEN Others THEN
1711: l_sql_code:= SQLCODE;
1712: l_err_msg:= substr(SQLERRM,1,2000);
1713: CSM_UTIL_PKG.LOG('exception while processing '||l_nid||' : '||l_sql_code||':'||l_err_msg,
1714: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);
1715:
1716: RETURN 'ERROR';
1717: END NOTIFICATION_TIMER_SUB;

Line 1815: IF CSM_UTIL_PKG.IS_HTML5_USER(l_client_id) THEN --for htm users send report

1811:
1812: SELECT fnd_profile.value_specific('CSM_NOTIFY_DEFERRED',NULL,l_resp_id,l_app_id)
1813: INTO l_user_string FROM DUAL;
1814:
1815: IF CSM_UTIL_PKG.IS_HTML5_USER(l_client_id) THEN --for htm users send report
1816: IF l_user_string IS NULL THEN
1817: l_user_string:=l_client_id;
1818: ELSIF INSTR(l_user_string,l_client_id)<1 THEN
1819: l_user_string:=l_user_string||','||l_client_id;

Line 1847: CSM_UTIL_PKG.LOG('Sending deferred report email to '||l_user_list(I),

1843:
1844: FOR I IN 1..l_user_list.COUNT
1845: LOOP
1846: BEGIN
1847: CSM_UTIL_PKG.LOG('Sending deferred report email to '||l_user_list(I),
1848: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_PROCEDURE);
1849:
1850: l_notification_id := invoke_WF_NotifyProcess(l_user_list(I),l_wf_param);
1851:

Line 1852: IF CSM_UTIL_PKG.IS_HTML5_USER(l_user_list(I)) THEN

1848: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_PROCEDURE);
1849:
1850: l_notification_id := invoke_WF_NotifyProcess(l_user_list(I),l_wf_param);
1851:
1852: IF CSM_UTIL_PKG.IS_HTML5_USER(l_user_list(I)) THEN
1853: DOWNLOAD_NOTIFICATION(l_notification_id,l_sql_err_msg); --download notification to client
1854: END IF;
1855:
1856: EXCEPTION

Line 1860: CSM_UTIL_PKG.LOG('exception while sending notification to '||l_user_list(I)||' : '||l_sql_code||':'||l_sql_err_msg,

1856: EXCEPTION
1857: WHEN OTHERS THEN
1858: l_sql_code:= SQLCODE;
1859: l_sql_err_msg:= substr(SQLERRM,1,2000);
1860: CSM_UTIL_PKG.LOG('exception while sending notification to '||l_user_list(I)||' : '||l_sql_code||':'||l_sql_err_msg,
1861: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_EXCEPTION);
1862: END;
1863: END LOOP;
1864:

Line 1867: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NOTIFY_DEFERRED is NULL',

1863: END LOOP;
1864:
1865: EXCEPTION
1866: WHEN NO_DATA_FOUND THEN
1867: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NOTIFY_DEFERRED is NULL',
1868: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_PROCEDURE);
1869: WHEN Others THEN
1870: l_sql_code:= SQLCODE;
1871: l_sql_err_msg:= substr(SQLERRM,1,2000);

Line 1872: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,

1868: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_PROCEDURE);
1869: WHEN Others THEN
1870: l_sql_code:= SQLCODE;
1871: l_sql_err_msg:= substr(SQLERRM,1,2000);
1872: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,
1873: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_EXCEPTION);
1874:
1875: END email_deferred_admin;
1876:

Line 1999: CSM_UTIL_PKG.LOG('This deferred record ('||l_sql||') is already being tracked by Id -'||l_tracking_id,

1995: END;
1996:
1997: IF l_tracking_id<>-1 THEN
1998: l_sql:=p_user_name||' ,'||p_tranid||' ,'||p_sequence;
1999: CSM_UTIL_PKG.LOG('This deferred record ('||l_sql||') is already being tracked by Id -'||l_tracking_id,
2000: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2001: RETURN;
2002: END IF;
2003:

Line 2010: CSM_UTIL_PKG.LOG('Mulitple Pks in '||p_pubitem||' is not supported in MFS Updatable PIs',

2006: FROM ASG_PUB_ITEM
2007: WHERE item_id=p_pubitem;
2008:
2009: IF instr(l_pk_col,',')<> 0 THEN
2010: CSM_UTIL_PKG.LOG('Mulitple Pks in '||p_pubitem||' is not supported in MFS Updatable PIs',
2011: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2012: RETURN;
2013: END IF;
2014:

Line 2045: IF isRoot AND NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_name) THEN --notify/email user

2041:
2042: select CSM_DEFERRED_NFN_INFO_S.nextval into l_tracking_id from dual;
2043:
2044:
2045: IF isRoot AND NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_name) THEN --notify/email user
2046: --Check if auto sync is enabled
2047: BEGIN
2048: select STATUS INTO l_autosync_enabled from wf_events
2049: where name='oracle.apps.csm.download.startsync';

Line 2087: CSM_UTIL_PKG.LOG('Invoke timer for '||l_notification_id,

2083: ,P_PK1_NUM_VALUE => l_notification_id
2084: ,P_USER_ID => asg_base.get_user_id(p_user_name)
2085: );
2086:
2087: CSM_UTIL_PKG.LOG('Invoke timer for '||l_notification_id,
2088: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2089:
2090:
2091: OPEN c_get_resp_id(p_user_name);

Line 2114: CSM_UTIL_PKG.LOG('exception while sending/tracking deferred Auto Sync email in NFN table: '||l_sql_code||':'||l_err_msg,

2110: EXCEPTION
2111: WHEN Others THEN
2112: l_sql_code:= SQLCODE;
2113: l_err_msg:= substr(SQLERRM,1,2000);
2114: CSM_UTIL_PKG.LOG('exception while sending/tracking deferred Auto Sync email in NFN table: '||l_sql_code||':'||l_err_msg,
2115: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2116: END;
2117: END IF; --auto sync enabled ?
2118: END IF; --is ROOT

Line 2142: CSM_UTIL_PKG.LOG('Inserted Tracking Id - '||l_tracking_id,'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

2138: IF isROOT THEN
2139: email_deferred_admin(l_tracking_id); --Email Admin & only html5 Techs about the root error.
2140: END IF;
2141:
2142: CSM_UTIL_PKG.LOG('Inserted Tracking Id - '||l_tracking_id,'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2143:
2144: EXCEPTION
2145: WHEN Others THEN
2146: l_sql_code:= SQLCODE;

Line 2148: CSM_UTIL_PKG.LOG('exception while processing '||NVL(l_notification_id,l_tracking_id)||' : '||l_sql_code||':'||l_err_msg,

2144: EXCEPTION
2145: WHEN Others THEN
2146: l_sql_code:= SQLCODE;
2147: l_err_msg:= substr(SQLERRM,1,2000);
2148: CSM_UTIL_PKG.LOG('exception while processing '||NVL(l_notification_id,l_tracking_id)||' : '||l_sql_code||':'||l_err_msg,
2149: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2150: CSM_UTIL_PKG.LOG('Dynamic SQL query is: '||l_sql,
2151: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2152: END NOTIFY_DEFERRED;

Line 2150: CSM_UTIL_PKG.LOG('Dynamic SQL query is: '||l_sql,

2146: l_sql_code:= SQLCODE;
2147: l_err_msg:= substr(SQLERRM,1,2000);
2148: CSM_UTIL_PKG.LOG('exception while processing '||NVL(l_notification_id,l_tracking_id)||' : '||l_sql_code||':'||l_err_msg,
2149: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2150: CSM_UTIL_PKG.LOG('Dynamic SQL query is: '||l_sql,
2151: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);
2152: END NOTIFY_DEFERRED;
2153:
2154: PROCEDURE PURGE_USER(p_user_id IN NUMBER)

Line 2162: delete from csm_deferred_nfn_info where client_id=csm_util_pkg.get_user_name(p_user_id);

2158: delete from csm_auto_sync_nfn_acc where user_id=p_user_id;
2159:
2160: delete from csm_deferred_transactions_acc where user_id=p_user_id;
2161:
2162: delete from csm_deferred_nfn_info where client_id=csm_util_pkg.get_user_name(p_user_id);
2163:
2164: for rec in (select nfn.notification_id from csm_auto_sync_nfn nfn, wf_notifications wfn
2165: where nfn.user_id=p_user_id and nfn.notification_id = wfn.notification_id
2166: and wfn.status='OPEN')

Line 2176: delete from CSM_SYNC_ERROR_NFN_INFO where client_id=csm_util_pkg.get_user_name(p_user_id);

2172: WHERE EXISTS (SELECT 1 FROM csm_auto_sync_nfn b WHERE b.NOTIFICATION_ID=cl.NOTIFICATION_ID and user_id=p_user_id);
2173:
2174: delete from csm_auto_sync_nfn where user_id=p_user_id;
2175:
2176: delete from CSM_SYNC_ERROR_NFN_INFO where client_id=csm_util_pkg.get_user_name(p_user_id);
2177:
2178: END PURGE_USER;
2179:
2180: --Subscription to event "oracle.apps.asg.sync.failure"

Line 2237: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'

2233: SELECT fnd_profile.value_specific('CSM_NFN_SYNC_ERROR',NULL,l_resp_id,l_app_id)
2234: INTO l_user_string FROM DUAL;
2235:
2236: IF l_user_string IS NULL THEN
2237: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'
2238: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);
2239: l_user_string:= l_client_id;
2240: ELSIF(instr(l_user_string,l_client_id) = 0) THEN
2241: l_user_string:=l_user_string||','||l_client_id;

Line 2245: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL.'

2241: l_user_string:=l_user_string||','||l_client_id;
2242: END IF;
2243: EXCEPTION
2244: WHEN Others THEN
2245: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL.'
2246: ||' Sending email only to Technician '||l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);
2247:
2248: l_user_string :=l_client_id;
2249: END;

Line 2267: CSM_UTIL_PKG.LOG('Sending sync error report email to '||l_user_list(I),

2263:
2264: FOR I IN 1..l_user_list.COUNT
2265: LOOP
2266: BEGIN
2267: CSM_UTIL_PKG.LOG('Sending sync error report email to '||l_user_list(I),
2268: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);
2269:
2270: l_notification_id := invoke_WF_NotifyProcess(l_user_list(I),l_wf_param);
2271:

Line 2278: CSM_UTIL_PKG.LOG('Invoke Wf process returns -1. No notification sent to '||l_user_list(I),

2274: VALUES(l_notification_id,l_user_list(I),l_session_id,l_client_id);
2275:
2276: DOWNLOAD_NOTIFICATION(l_notification_id,l_sql_err_msg); --download notification to client
2277: ELSE
2278: CSM_UTIL_PKG.LOG('Invoke Wf process returns -1. No notification sent to '||l_user_list(I),
2279: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2280: END IF;
2281: EXCEPTION
2282: WHEN OTHERS THEN

Line 2285: CSM_UTIL_PKG.LOG('exception while sending notification to '||l_user_list(I)||' : '||l_sql_code||':'||l_sql_err_msg,

2281: EXCEPTION
2282: WHEN OTHERS THEN
2283: l_sql_code:= SQLCODE;
2284: l_sql_err_msg:= substr(SQLERRM,1,2000);
2285: CSM_UTIL_PKG.LOG('exception while sending notification to '||l_user_list(I)||' : '||l_sql_code||':'||l_sql_err_msg,
2286: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2287: END;
2288: END LOOP;
2289:

Line 2295: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,

2291: EXCEPTION
2292: WHEN Others THEN
2293: l_sql_code:= SQLCODE;
2294: l_sql_err_msg:= substr(SQLERRM,1,2000);
2295: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,
2296: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2297: CSM_UTIL_PKG.LOG('Dynamic SQL query composed is :'||l_sql,
2298: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2299: RETURN 'ERROR';

Line 2297: CSM_UTIL_PKG.LOG('Dynamic SQL query composed is :'||l_sql,

2293: l_sql_code:= SQLCODE;
2294: l_sql_err_msg:= substr(SQLERRM,1,2000);
2295: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,
2296: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2297: CSM_UTIL_PKG.LOG('Dynamic SQL query composed is :'||l_sql,
2298: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2299: RETURN 'ERROR';
2300: END EMAIL_SYNC_ERROR_ADMIN_SUB;
2301:

Line 2361: CSM_UTIL_PKG.LOG('Processing for user '||l_client_id,

2357:
2358:
2359: IF(l_curr_client_id IS NULL OR l_curr_client_id<>l_client_id) THEN
2360:
2361: CSM_UTIL_PKG.LOG('Processing for user '||l_client_id,
2362: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);
2363:
2364: l_curr_client_id := l_client_id;
2365: BEGIN

Line 2385: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'

2381: SELECT fnd_profile.value_specific('CSM_NFN_SYNC_ERROR',NULL,l_resp_id,l_app_id)
2382: INTO l_user_string FROM DUAL;
2383:
2384: IF l_user_string IS NULL THEN
2385: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'
2386: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);
2387: l_user_string:= l_client_id;
2388: ELSIF(instr(l_user_string,l_client_id) = 0) THEN
2389: l_user_string:=l_user_string||','||l_client_id;

Line 2393: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'

2389: l_user_string:=l_user_string||','||l_client_id;
2390: END IF;
2391: EXCEPTION
2392: WHEN Others THEN
2393: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'
2394: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);
2395: l_user_string:= l_client_id;
2396: END;
2397:

Line 2419: CSM_UTIL_PKG.LOG('Sending sync error report email on session '||l_session_id||' to '||l_user_list(I),

2415:
2416: FOR I IN 1..l_user_list.COUNT
2417: LOOP
2418: BEGIN
2419: CSM_UTIL_PKG.LOG('Sending sync error report email on session '||l_session_id||' to '||l_user_list(I),
2420: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);
2421:
2422: l_notification_id := invoke_WF_NotifyProcess(l_user_list(I),l_wf_param);
2423:

Line 2431: CSM_UTIL_PKG.LOG('Invoke Wf process returns -1. No notification sent to '||l_user_list(I),

2427: VALUES(l_notification_id,l_user_list(I),l_session_id,l_client_id);
2428:
2429: DOWNLOAD_NOTIFICATION(l_notification_id,l_sql_err_msg); --download notification to client
2430: ELSE
2431: CSM_UTIL_PKG.LOG('Invoke Wf process returns -1. No notification sent to '||l_user_list(I),
2432: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);
2433: END IF;
2434:
2435: EXCEPTION

Line 2439: CSM_UTIL_PKG.LOG('exception while sending notification on session '||l_session_id||' to '||l_user_list(I)||' : '||l_sql_code||':'||l_sql_err_msg,

2435: EXCEPTION
2436: WHEN OTHERS THEN
2437: l_sql_code:= SQLCODE;
2438: l_sql_err_msg:= substr(SQLERRM,1,2000);
2439: CSM_UTIL_PKG.LOG('exception while sending notification on session '||l_session_id||' to '||l_user_list(I)||' : '||l_sql_code||':'||l_sql_err_msg,
2440: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_EXCEPTION);
2441: END;
2442: END LOOP;
2443:

Line 2462: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,

2458: EXCEPTION
2459: WHEN Others THEN
2460: l_sql_code:= SQLCODE;
2461: l_sql_err_msg:= substr(SQLERRM,1,2000);
2462: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,
2463: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_EXCEPTION);
2464: p_status := 'ERROR';
2465: p_message := 'Error in CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC: ' ||l_sql_err_msg;
2466: ROLLBACK;