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 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 120: 'CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC',FND_LOG.LEVEL_EXCEPTION);

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
123:
124: --Bug 5337816

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

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
172: FOR l_notf_rec IN c_notf(p_user_id)

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

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);
188: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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 239: 'CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION',FND_LOG.LEVEL_PROCEDURE);

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';
243: RETURN;

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

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
262: l_sqlerrno := TO_CHAR(SQLCODE);

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 285: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_ATTR_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

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';
289: END IF;

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

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
300: WHEN OTHERS THEN

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 329: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_DEL_WF_EVENT_SUB',FND_LOG.LEVEL_PROCEDURE);

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';
333: END IF;

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

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
352: WHEN OTHERS THEN

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 551: || l_status, 'CSM_NOTIFICATION_EVENT_PKG.get_Mailer_EmailId',FND_LOG.LEVEL_PROCEDURE);

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;
555: FETCH c_seeded_mailer INTO l_email_id;

Line 559: 'CSM_NOTIFICATION_EVENT_PKG.get_Mailer_EmailId',FND_LOG.LEVEL_PROCEDURE);

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:
563: RETURN l_email_id;

Line 601: 'CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess',FND_LOG.LEVEL_PROCEDURE);

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';
605: ELSE

Line 821: ||' , and result: '||l_result,'CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess',FND_LOG.LEVEL_PROCEDURE);

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:
825: return l_nid;

Line 852: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);

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:
856: l_stmt:= 'UPDATE WF_LOCAL_ROLES SET DESCRIPTION=DESCRIPTION ';

Line 885: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);

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:
889: wf_directory.CreateAdHocUser(name => role_name, display_name =>role_display_name,

Line 898: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);

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;
902: END createMobileWFUser;

Line 900: 'CSM_NOTIFICATION_EVENT_PKG.createMobileWFUser',FND_LOG.LEVEL_PROCEDURE);

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:
904: FUNCTION send_email(b_user_name IN VARCHAR2, subject VARCHAR2, message_body VARCHAR2) return NUMBER

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 933: 'CSM_NOTIFICATION_EVENT_PKG.SEND_EMAIL',FND_LOG.LEVEL_PROCEDURE);

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:
937: FUNCTION GET_LOCATION(p_loc_id NUMBER) RETURN VARCHAR2

Line 1057: 'CSM_NOTIFICATION_EVENT_PKG.email_optimization',FND_LOG.LEVEL_PROCEDURE);

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:
1061: RETURN FALSE;

Line 1297: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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';
1301:

Line 1386: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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:
1390: IF email_optimization(l_user_id,'CSM_TASK_ASSIGNMENTS',l_pk_value) THEN

Line 1449: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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:
1453: IF l_mode='UPDATE' THEN

Line 1478: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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

Line 1543: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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;
1547: CLOSE c_get_resp_id;

Line 1567: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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);
1571: END IF;

Line 1570: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_USER',FND_LOG.LEVEL_PROCEDURE);

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

Line 1584: ||' and activity_id :'||activity_id,'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_RESPONSE',FND_LOG.LEVEL_PROCEDURE);

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

Line 1598: ||activity_id|| '->'|| sqlerrm, 'CSM_NOTIFICATION_EVENT_PKG.NOTIFY_RESPONSE',FND_LOG.LEVEL_EXCEPTION);

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

Line 1650: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);

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;
1654: CLOSE c_response;

Line 1658: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);

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

Line 1698: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);

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));
1702: l_wftimer.AddParameterToList('RECIPIENT',substr(l_role,5,length(l_role)-9));

Line 1714: 'CSM_NOTIFICATION_EVENT_PKG.NOTIFICATION_TIMER_SUB',FND_LOG.LEVEL_PROCEDURE);

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

Line 1848: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_PROCEDURE);

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:
1852: IF CSM_UTIL_PKG.IS_HTML5_USER(l_user_list(I)) THEN

Line 1861: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_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:
1865: EXCEPTION

Line 1868: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_PROCEDURE);

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);
1872: CSM_UTIL_PKG.LOG('exception while emailing admin : '||l_sql_code||':'||l_sql_err_msg,

Line 1873: 'CSM_NOTIFICATION_EVENT_PKG.email_deferred_admin',FND_LOG.LEVEL_EXCEPTION);

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

Line 2000: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

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

Line 2011: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

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

Line 2088: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

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);
2092: FETCH c_get_resp_id INTO l_app_id,l_resp_id;

Line 2115: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

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

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 2149: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

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

Line 2151: 'CSM_NOTIFICATION_EVENT_PKG.notify_deferred',FND_LOG.LEVEL_PROCEDURE);

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)
2155: IS

Line 2238: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);

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

Line 2246: ||' Sending email only to Technician '||l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);

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

Line 2268: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);

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:
2272: IF l_notification_id <> -1 THEN

Line 2279: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);

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
2283: l_sql_code:= SQLCODE;

Line 2286: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_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:
2290: RETURN 'SUCCESS';

Line 2296: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_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';
2300: END EMAIL_SYNC_ERROR_ADMIN_SUB;

Line 2298: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);

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:
2302: PROCEDURE EMAIL_SYNC_ERRORS_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)

Line 2362: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);

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
2366: l_sql:= 'select upper(device_name) from (select a.NAME as DEVICE_NAME '

Line 2386: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);

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

Line 2394: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);

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:
2398: IF(l_user_list.COUNT>0) THEN

Line 2420: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);

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:
2424: IF l_notification_id <> -1 THEN

Line 2432: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_EXCEPTION);

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
2436: WHEN OTHERS THEN

Line 2440: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_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:
2444: COMMIT; -- commit after every session is notified.

Line 2463: 'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_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;
2467: END EMAIL_SYNC_ERRORS_CONC;