DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on WF_NOTIFICATION

Line 241: l_nid := WF_NOTIFICATION.Send(l_role_name, 'OENF', 'ORDER_STATUS_UPDATED');

237: AND parent_orig_system = 'HZ_PARTY'
238: AND orig_system_id = l_eid;
239: END IF;
240:
241: l_nid := WF_NOTIFICATION.Send(l_role_name, 'OENF', 'ORDER_STATUS_UPDATED');
242:
243: WF_NOTIFICATION.SetAttrText(l_nid, 'HEADER_TEXT', l_header_text);
244: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_TEXT', l_line_text);
245: WF_NOTIFICATION.SetAttrText(l_nid, 'ORDER_NUMBER', l_order_number);

Line 243: WF_NOTIFICATION.SetAttrText(l_nid, 'HEADER_TEXT', l_header_text);

239: END IF;
240:
241: l_nid := WF_NOTIFICATION.Send(l_role_name, 'OENF', 'ORDER_STATUS_UPDATED');
242:
243: WF_NOTIFICATION.SetAttrText(l_nid, 'HEADER_TEXT', l_header_text);
244: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_TEXT', l_line_text);
245: WF_NOTIFICATION.SetAttrText(l_nid, 'ORDER_NUMBER', l_order_number);
246:
247: Wf_Notification.Denormalize_Notification(nid => l_nid);

Line 244: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_TEXT', l_line_text);

240:
241: l_nid := WF_NOTIFICATION.Send(l_role_name, 'OENF', 'ORDER_STATUS_UPDATED');
242:
243: WF_NOTIFICATION.SetAttrText(l_nid, 'HEADER_TEXT', l_header_text);
244: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_TEXT', l_line_text);
245: WF_NOTIFICATION.SetAttrText(l_nid, 'ORDER_NUMBER', l_order_number);
246:
247: Wf_Notification.Denormalize_Notification(nid => l_nid);
248:

Line 245: WF_NOTIFICATION.SetAttrText(l_nid, 'ORDER_NUMBER', l_order_number);

241: l_nid := WF_NOTIFICATION.Send(l_role_name, 'OENF', 'ORDER_STATUS_UPDATED');
242:
243: WF_NOTIFICATION.SetAttrText(l_nid, 'HEADER_TEXT', l_header_text);
244: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_TEXT', l_line_text);
245: WF_NOTIFICATION.SetAttrText(l_nid, 'ORDER_NUMBER', l_order_number);
246:
247: Wf_Notification.Denormalize_Notification(nid => l_nid);
248:
249: EXCEPTION

Line 247: Wf_Notification.Denormalize_Notification(nid => l_nid);

243: WF_NOTIFICATION.SetAttrText(l_nid, 'HEADER_TEXT', l_header_text);
244: WF_NOTIFICATION.SetAttrText(l_nid, 'LINE_TEXT', l_line_text);
245: WF_NOTIFICATION.SetAttrText(l_nid, 'ORDER_NUMBER', l_order_number);
246:
247: Wf_Notification.Denormalize_Notification(nid => l_nid);
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: IF l_debug_level > 0 THEN