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 WF_EVENT

Line 272: -- subscription to the NOTIFICATION_ATTR_INS_RECEIVE WF event

268: END DOWNLOAD_NOTIFICATION;
269:
270:
271: --Bug 5337816
272: -- subscription to the NOTIFICATION_ATTR_INS_RECEIVE WF event
273: FUNCTION NOTIFICATION_ATTR_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
274: RETURN VARCHAR2
275: IS
276: l_sqlerrno VARCHAR2(20);

Line 273: FUNCTION NOTIFICATION_ATTR_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

269:
270:
271: --Bug 5337816
272: -- subscription to the NOTIFICATION_ATTR_INS_RECEIVE WF event
273: FUNCTION NOTIFICATION_ATTR_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
274: RETURN VARCHAR2
275: IS
276: l_sqlerrno VARCHAR2(20);
277: l_sqlerrmsg VARCHAR2(4000);

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 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 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 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 303: l_error_msg := ' Exception in NOTIFICATION_ATTR_WF_EVENT_SUB for notification_id:' || to_char(l_notification_id)

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

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 307: END NOTIFICATION_ATTR_WF_EVENT_SUB;

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
310: FUNCTION NOTIFICATION_DEL_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
311: RETURN VARCHAR2

Line 310: FUNCTION NOTIFICATION_DEL_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

306: RETURN 'ERROR';
307: END NOTIFICATION_ATTR_WF_EVENT_SUB;
308:
309: --Bug 5337816
310: FUNCTION NOTIFICATION_DEL_WF_EVENT_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
311: RETURN VARCHAR2
312: IS
313: l_sqlerrno VARCHAR2(20);
314: l_sqlerrmsg VARCHAR2(4000);

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 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 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 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 355: l_error_msg := ' Exception in NOTIFICATION_DEL_WF_EVENT_SUB for notification_id:' || to_char(l_notification_id)

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

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 359: END NOTIFICATION_DEL_WF_EVENT_SUB;

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)
362: IS
363: PRAGMA AUTONOMOUS_TRANSACTION;

Line 568: FUNCTION invoke_WF_NotifyProcess (p_recipient_role IN VARCHAR2, p_wf_param IN wf_event_t) return NUMBER

564:
565: END get_Mailer_EmailId;
566:
567: --Bug 9435049
568: FUNCTION invoke_WF_NotifyProcess (p_recipient_role IN VARCHAR2, p_wf_param IN wf_event_t) return NUMBER
569: IS
570:
571: l_item_key WF_ITEMS.ITEM_KEY%TYPE;
572: l_item_owner WF_USERS.NAME%TYPE := 'SYSADMIN';

Line 908: l_wf_param wf_event_t;

904: FUNCTION send_email(b_user_name IN VARCHAR2, subject VARCHAR2, message_body VARCHAR2) return NUMBER
905: IS
906: role_name VARCHAR2(30);
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);

Line 922: wf_event_t.initialize(l_wf_param);

918: ELSE
919: role_name := 'CSM_'||b_user_name||'_ROLE';
920: END IF;
921:
922: wf_event_t.initialize(l_wf_param);
923: l_wf_param.AddParameterToList('TEMPLATE','DOWNLOAD_INIT_MSG');
924: l_wf_param.AddParameterToList('SUBJECT',subject);
925: l_wf_param.AddParameterToList('MESSAGE_BODY',message_body);
926:

Line 959: l_wf_param wf_event_t;

955: END;
956:
957: PROCEDURE NOTIFY_USER(entity varchar2, pk_value varchar2,p_mode varchar2)
958: IS
959: l_wf_param wf_event_t;
960: BEGIN
961: wf_event_t.initialize(l_wf_param);
962: l_wf_param.AddParameterToList('ENTITY',entity);
963: l_wf_param.AddParameterToList('PK_VALUE',pk_value);

Line 961: wf_event_t.initialize(l_wf_param);

957: PROCEDURE NOTIFY_USER(entity varchar2, pk_value varchar2,p_mode varchar2)
958: IS
959: l_wf_param wf_event_t;
960: BEGIN
961: wf_event_t.initialize(l_wf_param);
962: l_wf_param.AddParameterToList('ENTITY',entity);
963: l_wf_param.AddParameterToList('PK_VALUE',pk_value);
964: l_wf_param.AddParameterToList('MODE',p_mode);
965: csm_notification_event_pkg.notify_user(l_wf_param);

Line 1081: PROCEDURE NOTIFY_USER(p_wf_param wf_event_t)

1077: WHEN OTHERS THEN
1078: RETURN FALSE;
1079: END is_personal_task;
1080:
1081: PROCEDURE NOTIFY_USER(p_wf_param wf_event_t)
1082: IS
1083:
1084: CURSOR c_user_task_assigned(b_task_ass_id NUMBER)
1085: IS

Line 1278: l_wftimer wf_event_t;

1274: l_uname_tab l_name_type;
1275: l_not_tab l_tab_type;
1276: l_usr_tab l_tab_type;
1277: l_cnt NUMBER :=0;
1278: l_wftimer wf_event_t;
1279: l_timeout NUMBER;
1280: l_resp_id NUMBER;
1281: l_app_id NUMBER;
1282: BEGIN

Line 1553: wf_event_t.initialize(l_wftimer);

1549: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',l_usr_tab(I),l_resp_id,l_app_id));
1550:
1551: IF l_timeout > 0 THEN
1552: --timer logic - Fixed 3 tries + 1 original email
1553: wf_event_t.initialize(l_wftimer);
1554: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_not_tab(I)));
1555: l_wftimer.AddParameterToList('SENT_TO','CSM_'||l_uname_tab(I)||'_ROLE');
1556: l_wftimer.AddParameterToList('TRIES','1');
1557:

Line 1558: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',

1554: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_not_tab(I)));
1555: l_wftimer.AddParameterToList('SENT_TO','CSM_'||l_uname_tab(I)||'_ROLE');
1556: l_wftimer.AddParameterToList('TRIES','1');
1557:
1558: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',
1559: p_event_key=>to_char(l_not_tab(I)),p_parameters=>l_wftimer.getParameterList,
1560: p_event_data=>null,p_send_date=>(sysdate+(l_timeout*60*0.000011574)));
1561: END IF;
1562: END IF;

Line 1616: FUNCTION NOTIFICATION_TIMER_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

1612:
1613:
1614:
1615: --Subscription to event "oracle.apps.csm.download.timer"
1616: FUNCTION NOTIFICATION_TIMER_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
1617: RETURN VARCHAR2
1618: IS
1619: l_nid NUMBER;
1620: l_try NUMBER;

Line 1621: l_wftimer wf_event_t;

1617: RETURN VARCHAR2
1618: IS
1619: l_nid NUMBER;
1620: l_try NUMBER;
1621: l_wftimer wf_event_t;
1622: CURSOR c_response(b_nid NUMBER) IS
1623: SELECT 1
1624: FROM WF_NOTIFICATIONS
1625: WHERE NOTIFICATION_ID=b_nid

Line 1688: wf_event_t.initialize(l_wftimer);

1684: WHERE NOTIFICATION_ID=l_nid;
1685:
1686: l_try := l_try + 1;
1687:
1688: wf_event_t.initialize(l_wftimer);
1689: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_nid));
1690: l_wftimer.AddParameterToList('TRIES',l_try);
1691: l_wftimer.AddParameterToList('SENT_TO',l_role);
1692: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',

Line 1692: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',

1688: wf_event_t.initialize(l_wftimer);
1689: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_nid));
1690: l_wftimer.AddParameterToList('TRIES',l_try);
1691: l_wftimer.AddParameterToList('SENT_TO',l_role);
1692: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',
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:

Line 1700: wf_event_t.initialize(l_wftimer);

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));
1703: wf_event.raise(p_event_name=>'oracle.apps.csm.download.noResponse',
1704: p_event_key=>to_char(l_nid),p_parameters=>l_wftimer.getParameterList,

Line 1703: wf_event.raise(p_event_name=>'oracle.apps.csm.download.noResponse',

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));
1703: wf_event.raise(p_event_name=>'oracle.apps.csm.download.noResponse',
1704: p_event_key=>to_char(l_nid),p_parameters=>l_wftimer.getParameterList,
1705: p_event_data=>null,p_send_date=>null);
1706: END IF;
1707:

Line 1800: l_wf_param wf_event_t;

1796: l_notification_id NUMBER;
1797:
1798: l_sql_err_msg VARCHAR2(2000);
1799: l_sql_code NUMBER;
1800: l_wf_param wf_event_t;
1801: BEGIN
1802:
1803: OPEN c_get_deferred_data(p_tracking_id);
1804: FETCH c_get_deferred_data INTO l_tran_id,l_seq, l_client_id,l_dev_type,l_disp_name,

Line 1829: wf_event_t.initialize(l_wf_param);

1825: END IF;
1826:
1827: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
1828:
1829: wf_event_t.initialize(l_wf_param);
1830: l_wf_param.AddParameterToList('TEMPLATE','DEFERRED_ERROR_REPORT');
1831:
1832: l_wf_param.AddParameterToList( 'USER_NAME', l_client_id);
1833: l_wf_param.AddParameterToList( 'TRAN_ID', to_char(l_tran_id));

Line 1963: l_wftimer wf_event_t;

1959: SELECT APP_ID,RESPONSIBILITY_ID
1960: FROM ASG_USER
1961: WHERE USER_NAME=b_user_name;
1962:
1963: l_wftimer wf_event_t;
1964: l_timeout NUMBER;
1965: l_resp_id NUMBER;
1966: l_app_id NUMBER;
1967:

Line 2048: select STATUS INTO l_autosync_enabled from wf_events

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';
2050: EXCEPTION
2051: WHEN NO_DATA_FOUND THEN
2052: l_autosync_enabled:='DISABLED';

Line 2099: wf_event_t.initialize(l_wftimer);

2095: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',asg_base.get_user_id(p_user_name),l_resp_id,l_app_id));
2096:
2097: IF l_timeout > 0 THEN
2098: --timer logic - Fixed 3 tries + 1 original email
2099: wf_event_t.initialize(l_wftimer);
2100: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_notification_id));
2101: l_wftimer.AddParameterToList('SENT_TO','CSM_'||p_user_name||'_ROLE');
2102: l_wftimer.AddParameterToList('TRIES','1');
2103:

Line 2104: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',

2100: l_wftimer.AddParameterToList('NOTIFICATION_ID',to_char(l_notification_id));
2101: l_wftimer.AddParameterToList('SENT_TO','CSM_'||p_user_name||'_ROLE');
2102: l_wftimer.AddParameterToList('TRIES','1');
2103:
2104: wf_event.raise(p_event_name=>'oracle.apps.csm.download.timer',
2105: p_event_key=>to_char(l_notification_id),p_parameters=>l_wftimer.getParameterList,
2106: p_event_data=>null,p_send_date=>(sysdate+(l_timeout*60*0.000011574)));
2107: END IF;
2108:

Line 2181: FUNCTION EMAIL_SYNC_ERROR_ADMIN_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)

2177:
2178: END PURGE_USER;
2179:
2180: --Subscription to event "oracle.apps.asg.sync.failure"
2181: FUNCTION EMAIL_SYNC_ERROR_ADMIN_SUB(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
2182: RETURN VARCHAR2
2183: IS
2184:
2185: l_session_id NUMBER;

Line 2207: l_wf_param wf_event_t;

2203:
2204: l_sql VARCHAR2(1000);
2205: l_sql_err_msg VARCHAR2(2000);
2206: l_sql_code NUMBER;
2207: l_wf_param wf_event_t;
2208: BEGIN
2209:
2210: l_session_id := to_number(p_event.GetValueForParameter('SESSION_ID'));
2211: l_tran_id := to_number(p_event.GetValueForParameter('TRAN_ID'));

Line 2253: wf_event_t.initialize(l_wf_param);

2249: END;
2250:
2251: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
2252:
2253: wf_event_t.initialize(l_wf_param);
2254: l_wf_param.AddParameterToList('TEMPLATE','SYNC_ERROR_REPORT');
2255:
2256: l_wf_param.AddParameterToList('SESSION_ID', l_session_id);
2257: l_wf_param.AddParameterToList('TRAN_ID', l_tran_id);

Line 2333: l_wf_param wf_event_t;

2329:
2330: type t_curs is ref cursor;
2331: cur t_curs;
2332:
2333: l_wf_param wf_event_t;
2334: BEGIN
2335:
2336: SELECT NVL(LAST_RUN_DATE,TO_DATE(1,'J')) INTO l_last_run_date
2337: FROM jtm_con_request_data

Line 2406: wf_event_t.initialize(l_wf_param);

2402: l_user_list := asg_download.get_listfrom_string(upper(l_user_string));
2403:
2404: END IF;
2405:
2406: wf_event_t.initialize(l_wf_param);
2407: l_wf_param.AddParameterToList('TEMPLATE','SYNC_ERROR_REPORT');
2408:
2409: l_wf_param.AddParameterToList('SESSION_ID', to_char(l_session_id));
2410: l_wf_param.AddParameterToList('USER_NAME', l_client_id);