936: if (x_num_lines < 1) then
937: l_document := '';
938: l_document := fnd_message.get_string('POS', 'POS_ASN_NOTIF_CANCELLED');
939:
940: WF_NOTIFICATION.WriteToClob(document, l_document);
941:
942: else
943: OPEN asn_lines(x_shipment_num,x_buyer_id,x_vendor_id,x_vendor_site_id);
944:
1034: nvl(l_asn_lines.ship_to_org, ' ') || ' ' || NL;
1035:
1036: l_document := l_document || '' || NL;
1037:
1038: WF_NOTIFICATION.WriteToClob(document, l_document);
1039: l_document := null;
1040: END LOOP;
1041:
1042: CLOSE asn_lines;
1042: CLOSE asn_lines;
1043:
1044: l_document := l_document || '