136:
137: end if;
138:
139: -- get the message subject to be sent
140: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_S');
141: fnd_message.set_token('NEG_NUM', NegotiationNum);
142: l_message_sub := fnd_message.get;
143:
144: IF Source = 'MRP' THEN
137: end if;
138:
139: -- get the message subject to be sent
140: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_S');
141: fnd_message.set_token('NEG_NUM', NegotiationNum);
142: l_message_sub := fnd_message.get;
143:
144: IF Source = 'MRP' THEN
145: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SM');
138:
139: -- get the message subject to be sent
140: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_S');
141: fnd_message.set_token('NEG_NUM', NegotiationNum);
142: l_message_sub := fnd_message.get;
143:
144: IF Source = 'MRP' THEN
145: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SM');
146: fnd_message.set_token('NEG_NUM', NegotiationNum);
141: fnd_message.set_token('NEG_NUM', NegotiationNum);
142: l_message_sub := fnd_message.get;
143:
144: IF Source = 'MRP' THEN
145: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SM');
146: fnd_message.set_token('NEG_NUM', NegotiationNum);
147: l_message_sub1 := fnd_message.get;
148: ELSIF Source = 'WITHDRAW' THEN
149: select segment1 into x_req_num
142: l_message_sub := fnd_message.get;
143:
144: IF Source = 'MRP' THEN
145: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SM');
146: fnd_message.set_token('NEG_NUM', NegotiationNum);
147: l_message_sub1 := fnd_message.get;
148: ELSIF Source = 'WITHDRAW' THEN
149: select segment1 into x_req_num
150: from po_requisition_headers_all
143:
144: IF Source = 'MRP' THEN
145: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SM');
146: fnd_message.set_token('NEG_NUM', NegotiationNum);
147: l_message_sub1 := fnd_message.get;
148: ELSIF Source = 'WITHDRAW' THEN
149: select segment1 into x_req_num
150: from po_requisition_headers_all
151: where requisition_header_id = DocumentId;
149: select segment1 into x_req_num
150: from po_requisition_headers_all
151: where requisition_header_id = DocumentId;
152:
153: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SW');
154: fnd_message.set_token('NEG_NUM', NegotiationNum);
155: fnd_message.set_token('REQ_NUM', x_req_num);
156: l_message_sub1 := fnd_message.get;
157: END IF;
150: from po_requisition_headers_all
151: where requisition_header_id = DocumentId;
152:
153: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SW');
154: fnd_message.set_token('NEG_NUM', NegotiationNum);
155: fnd_message.set_token('REQ_NUM', x_req_num);
156: l_message_sub1 := fnd_message.get;
157: END IF;
158:
151: where requisition_header_id = DocumentId;
152:
153: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SW');
154: fnd_message.set_token('NEG_NUM', NegotiationNum);
155: fnd_message.set_token('REQ_NUM', x_req_num);
156: l_message_sub1 := fnd_message.get;
157: END IF;
158:
159: /* get the current org_id */
152:
153: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_SW');
154: fnd_message.set_token('NEG_NUM', NegotiationNum);
155: fnd_message.set_token('REQ_NUM', x_req_num);
156: l_message_sub1 := fnd_message.get;
157: END IF;
158:
159: /* get the current org_id */
160: begin
379: aname => 'SOURCE');
380:
381: x_progress := '004';
382:
383: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B');
384: fnd_message.set_token('NEG_NUM', l_negotiation_num);
385: l_message_text := fnd_message.get;
386:
387: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B1');
380:
381: x_progress := '004';
382:
383: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B');
384: fnd_message.set_token('NEG_NUM', l_negotiation_num);
385: l_message_text := fnd_message.get;
386:
387: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B1');
388: fnd_message.set_token('NEG_NUM', l_negotiation_num);
381: x_progress := '004';
382:
383: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B');
384: fnd_message.set_token('NEG_NUM', l_negotiation_num);
385: l_message_text := fnd_message.get;
386:
387: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B1');
388: fnd_message.set_token('NEG_NUM', l_negotiation_num);
389: l_message_text1 := fnd_message.get;
383: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B');
384: fnd_message.set_token('NEG_NUM', l_negotiation_num);
385: l_message_text := fnd_message.get;
386:
387: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B1');
388: fnd_message.set_token('NEG_NUM', l_negotiation_num);
389: l_message_text1 := fnd_message.get;
390:
391: x_progress := '006';
384: fnd_message.set_token('NEG_NUM', l_negotiation_num);
385: l_message_text := fnd_message.get;
386:
387: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B1');
388: fnd_message.set_token('NEG_NUM', l_negotiation_num);
389: l_message_text1 := fnd_message.get;
390:
391: x_progress := '006';
392: if (display_type = 'text/html') then
385: l_message_text := fnd_message.get;
386:
387: fnd_message.set_name ('PO','PO_SOURCING_NOTIF_MSG_B1');
388: fnd_message.set_token('NEG_NUM', l_negotiation_num);
389: l_message_text1 := fnd_message.get;
390:
391: x_progress := '006';
392: if (display_type = 'text/html') then
393:
394: /* Construct the table header */
395:
396: l_document := l_document || '
' || l_message_text || '
' || 405: fnd_message.get_string('PO', 'PO_SOURCING_NEG_LINE_NUMBER') || ' | ' || NL;' 408: || fnd_message.get_string('PO', 'PO_SOURCING_REQ_NUMBER') || ' | ' || NL;' || 405: fnd_message.get_string('PO', 'PO_SOURCING_NEG_LINE_NUMBER') || ' | ' || NL;' 408: || fnd_message.get_string('PO', 'PO_SOURCING_REQ_NUMBER') || ' | ' || NL;' || 411: fnd_message.get_string('PO', 'PO_SOURCING_LINE_NUMBER') || ' | ' || NL;' 408: || fnd_message.get_string('PO', 'PO_SOURCING_REQ_NUMBER') || ' | ' || NL;' || 411: fnd_message.get_string('PO', 'PO_SOURCING_LINE_NUMBER') || ' | ' || NL;' || 414: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_NUMBER') || ' | ' || NL;' || 411: fnd_message.get_string('PO', 'PO_SOURCING_LINE_NUMBER') || ' | ' || NL;' || 414: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_NUMBER') || ' | ' || NL;' || 417: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_DESC') || ' | ' || NL;' || 414: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_NUMBER') || ' | ' || NL;' || 417: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_DESC') || ' | ' || NL;' || 420: fnd_message.get_string('PO', 'PO_SOURCING_UOM') || ' | ' || NL;' || 417: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_DESC') || ' | ' || NL;' || 420: fnd_message.get_string('PO', 'PO_SOURCING_UOM') || ' | ' || NL;' || 423: fnd_message.get_string('PO', 'PO_SOURCING_QUANTITY') || ' | ' || NL;' || 420: fnd_message.get_string('PO', 'PO_SOURCING_UOM') || ' | ' || NL;' || 423: fnd_message.get_string('PO', 'PO_SOURCING_QUANTITY') || ' | ' || NL;' || 426: fnd_message.get_string('PO', 'PO_SOURCING_NEED_BY_DATE') ||' | ' || NL;' || 423: fnd_message.get_string('PO', 'PO_SOURCING_QUANTITY') || ' | ' || NL;' || 426: fnd_message.get_string('PO', 'PO_SOURCING_NEED_BY_DATE') ||' | ' || NL;' || 429: fnd_message.get_string('PO', 'PO_SOURCING_STATUS') || ' | ' || NL;' || 426: fnd_message.get_string('PO', 'PO_SOURCING_NEED_BY_DATE') ||' | ' || NL;' || 429: fnd_message.get_string('PO', 'PO_SOURCING_STATUS') || ' | ' || NL;
---|
' || 683: fnd_message.get_string('PO', 'PO_SOURCING_NEG_LINE_NUMBER') || ' | ' || NL;' 687: || fnd_message.get_string('PO', 'PO_SOURCING_REQ_NUMBER') || ' | ' || NL;' 687: || fnd_message.get_string('PO', 'PO_SOURCING_REQ_NUMBER') || ' | ' || NL;' || 691: fnd_message.get_string('PO', 'PO_SOURCING_LINE_NUMBER') || ' | '|| NL;' || 691: fnd_message.get_string('PO', 'PO_SOURCING_LINE_NUMBER') || ' | '|| NL;' || 694: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_NUMBER') || ' | '|| NL;' || 691: fnd_message.get_string('PO', 'PO_SOURCING_LINE_NUMBER') || ' | '|| NL;' || 694: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_NUMBER') || ' | '|| NL;' || 697: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_DESC') || ' | '|| NL;' || 694: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_NUMBER') || ' | '|| NL;' || 697: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_DESC') || ' | '|| NL;' || 700: fnd_message.get_string('PO', 'PO_SOURCING_UOM') || ' | ' || NL;' || 697: fnd_message.get_string('PO', 'PO_SOURCING_ITEM_DESC') || ' | '|| NL;' || 700: fnd_message.get_string('PO', 'PO_SOURCING_UOM') || ' | ' || NL;' || 703: fnd_message.get_string('PO', 'PO_SOURCING_QUANTITY') || ' | ' || NL;' || 700: fnd_message.get_string('PO', 'PO_SOURCING_UOM') || ' | ' || NL;' || 703: fnd_message.get_string('PO', 'PO_SOURCING_QUANTITY') || ' | ' || NL;' || 706: fnd_message.get_string('PO', 'PO_SOURCING_NEED_BY_DATE') ||' | ' || NL;' || 703: fnd_message.get_string('PO', 'PO_SOURCING_QUANTITY') || ' | ' || NL;' || 706: fnd_message.get_string('PO', 'PO_SOURCING_NEED_BY_DATE') ||' | ' || NL;' ||Line 711: fnd_message.get_string('PO', 'PO_SOURCING_NEW_QUANTITY') || ' | ' || NL;' || 711: fnd_message.get_string('PO', 'PO_SOURCING_NEW_QUANTITY') || ' | ' || NL;' || 714: fnd_message.get_string('PO', 'PO_SOURCING_NEW_NEED_BY_DATE') ||' | ' || NL;' || 711: fnd_message.get_string('PO', 'PO_SOURCING_NEW_QUANTITY') || ' | ' || NL;' || 714: fnd_message.get_string('PO', 'PO_SOURCING_NEW_NEED_BY_DATE') ||' | ' || NL;' || 718: fnd_message.get_string('PO', 'PO_SOURCING_STATUS') || ' | ' || NL;' || 718: fnd_message.get_string('PO', 'PO_SOURCING_STATUS') || ' | ' || NL;' || |
---|