DBA Data[Home] [Help]

APPS.OE_SHIPPING_WF dependencies on WF_NOTIFICATION

Line 415: l_nid := WF_NOTIFICATION.Send(role_name, 'OEOL', 'WORKFLOW_SKIPPED_MSG');

411:
412: -- notification to the skipper
413: wf_engine.SetItemAttrText(itemtype, itemkey, 'NOTIFICATION_FROM_ROLE', l_from_role);
414:
415: l_nid := WF_NOTIFICATION.Send(role_name, 'OEOL', 'WORKFLOW_SKIPPED_MSG');
416:
417: OE_ORDER_WF_UTIL.Set_Line_Descriptor(l_nid, null, l_descriptor, l_doc_type);
418: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);
419:

Line 418: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);

414:
415: l_nid := WF_NOTIFICATION.Send(role_name, 'OEOL', 'WORKFLOW_SKIPPED_MSG');
416:
417: OE_ORDER_WF_UTIL.Set_Line_Descriptor(l_nid, null, l_descriptor, l_doc_type);
418: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);
419:
420:
421: -- l_from_role = SYSADMIN
422: -- notification to SYSADMIN

Line 423: l_nid := WF_NOTIFICATION.Send(l_from_role, 'OEOL', 'WORKFLOW_SKIPPED_ADMIN_MSG');

419:
420:
421: -- l_from_role = SYSADMIN
422: -- notification to SYSADMIN
423: l_nid := WF_NOTIFICATION.Send(l_from_role, 'OEOL', 'WORKFLOW_SKIPPED_ADMIN_MSG');
424:
425: OE_ORDER_WF_UTIL.Set_Line_Descriptor(l_nid, null, l_descriptor, l_doc_type);
426:
427: WF_NOTIFICATION.SetAttrText(l_nid, 'USER_NAME', role_name);

Line 427: WF_NOTIFICATION.SetAttrText(l_nid, 'USER_NAME', role_name);

423: l_nid := WF_NOTIFICATION.Send(l_from_role, 'OEOL', 'WORKFLOW_SKIPPED_ADMIN_MSG');
424:
425: OE_ORDER_WF_UTIL.Set_Line_Descriptor(l_nid, null, l_descriptor, l_doc_type);
426:
427: WF_NOTIFICATION.SetAttrText(l_nid, 'USER_NAME', role_name);
428: WF_NOTIFICATION.SetAttrText(l_nid, 'RESP_NAME', l_resp_name);
429: WF_NOTIFICATION.SetAttrText(l_nid, 'APPL_NAME', l_appl_name);
430: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);
431: END IF; --G_DEV_SKIP == 'N'

Line 428: WF_NOTIFICATION.SetAttrText(l_nid, 'RESP_NAME', l_resp_name);

424:
425: OE_ORDER_WF_UTIL.Set_Line_Descriptor(l_nid, null, l_descriptor, l_doc_type);
426:
427: WF_NOTIFICATION.SetAttrText(l_nid, 'USER_NAME', role_name);
428: WF_NOTIFICATION.SetAttrText(l_nid, 'RESP_NAME', l_resp_name);
429: WF_NOTIFICATION.SetAttrText(l_nid, 'APPL_NAME', l_appl_name);
430: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);
431: END IF; --G_DEV_SKIP == 'N'
432:

Line 429: WF_NOTIFICATION.SetAttrText(l_nid, 'APPL_NAME', l_appl_name);

425: OE_ORDER_WF_UTIL.Set_Line_Descriptor(l_nid, null, l_descriptor, l_doc_type);
426:
427: WF_NOTIFICATION.SetAttrText(l_nid, 'USER_NAME', role_name);
428: WF_NOTIFICATION.SetAttrText(l_nid, 'RESP_NAME', l_resp_name);
429: WF_NOTIFICATION.SetAttrText(l_nid, 'APPL_NAME', l_appl_name);
430: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);
431: END IF; --G_DEV_SKIP == 'N'
432:
433: EXCEPTION

Line 430: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);

426:
427: WF_NOTIFICATION.SetAttrText(l_nid, 'USER_NAME', role_name);
428: WF_NOTIFICATION.SetAttrText(l_nid, 'RESP_NAME', l_resp_name);
429: WF_NOTIFICATION.SetAttrText(l_nid, 'APPL_NAME', l_appl_name);
430: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_DESCRIPTOR', l_descriptor);
431: END IF; --G_DEV_SKIP == 'N'
432:
433: EXCEPTION
434: WHEN OTHERS THEN