11584: THEN
11585: oe_debug_pub.ADD(' Before send notification ', 2);
11586: END IF;
11587:
11588: l_notification_id := wf_notification.send
11589: ( role => l_wfn_to
11590: , msg_type => OE_GLOBALS.g_wfi_hdr
11591: , msg_name => 'ORDER_CREDIT_HOLDS'
11592: );
11596: oe_debug_pub.ADD(' After send notification with ID = '||
11597: l_notification_id, 2 );
11598: END IF;
11599:
11600: wf_notification.setattrtext
11601: ( nid => l_notification_id
11602: , aname => 'ORDER_HOLD_COMMENT'
11603: , avalue => l_order_hold_comment
11604: );
11602: , aname => 'ORDER_HOLD_COMMENT'
11603: , avalue => l_order_hold_comment
11604: );
11605:
11606: wf_notification.setattrtext
11607: ( nid => l_notification_id
11608: , aname => 'ORDER_TYPE'
11609: , avalue => l_order_type
11610: );
11608: , aname => 'ORDER_TYPE'
11609: , avalue => l_order_type
11610: );
11611:
11612: wf_notification.setattrnumber
11613: ( nid => l_notification_id
11614: , aname => 'ORDER_NUMBER'
11615: , avalue => p_header_rec.order_number
11616: );
11614: , aname => 'ORDER_NUMBER'
11615: , avalue => p_header_rec.order_number
11616: );
11617:
11618: wf_notification.setattrnumber
11619: ( nid => l_notification_id
11620: , aname => 'LINE_HOLD_COUNT'
11621: , avalue => l_line_hold_count
11622: );
11626: --
11627: -- Ensure that the notification subject will be properly constructed.
11628: --
11629:
11630: Wf_Notification.Denormalize_Notification(nid => l_notification_id);
11631:
11632: -- End : Bug 7476530 Fix
11633:
11634: