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