APPS.PO_CHANGEORDERWF_PVT dependencies on FND_MESSAGE

Line 700: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');

696: l_can_doc_subtype po_document_types_all.document_subtype%TYPE;
697: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
698: l_return_status varchar2(1);
699: x_progress varchar2(3);
700: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');
701: l_hdr_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_HDR_ERR');
702: /* Code changes for bug 13114334 - Start */
703: l_cancel_count number;
704: l_cancel_index number;

Line 701: l_hdr_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_HDR_ERR');

697: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
698: l_return_status varchar2(1);
699: x_progress varchar2(3);
700: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');
701: l_hdr_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_HDR_ERR');
702: /* Code changes for bug 13114334 - Start */
703: l_cancel_count number;
704: l_cancel_index number;
705: l_launch_approvals_flag varchar2(1) := 'N';

Line 1111: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');

1107: aname => 'ORG_ID');
1108:
1109: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1110:
1111: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');
1112: l_acceptance_result := fnd_message.get;
1113:
1114: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1115: itemkey => itemkey,

Line 1112: l_acceptance_result := fnd_message.get;

1108:
1109: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1110:
1111: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');
1112: l_acceptance_result := fnd_message.get;
1113:
1114: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1115: itemkey => itemkey,
1116: aname => 'DOCUMENT_ID');

Line 1174: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_REJ') );

1170: IF (l_acceptance_result is NULL) THEN
1171: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
1172: itemkey => itemkey,
1173: aname => 'ACCEPTANCE_RESULT',
1174: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_REJ') );
1175: END IF;
1176:
1177: if (l_document_type_code <> 'RELEASE') then
1178:

Line 1713: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),

1709: pla.quantity OLD_QTY,
1710: to_number(null) NEW_QTY,
1711: pla.unit_price OLD_PRICE,
1712: pcr.new_price NEW_PRICE,
1713: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),
1714: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1715: pla.item_description ITEM_DESCRIPTION,
1716: pla.unit_meas_lookup_code UOM,
1717: null SHIP_TO_LOCATION,

Line 1714: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,

1710: to_number(null) NEW_QTY,
1711: pla.unit_price OLD_PRICE,
1712: pcr.new_price NEW_PRICE,
1713: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),
1714: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1715: pla.item_description ITEM_DESCRIPTION,
1716: pla.unit_meas_lookup_code UOM,
1717: null SHIP_TO_LOCATION,
1718: pcr.ACTION_TYPE ACTION_CODE,

Line 1753: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',

1749: plla.quantity OLD_QTY,
1750: pcr.new_quantity NEW_QTY,
1751: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',nvl(pcr.old_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE,
1752: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE,
1753: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1754: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1755: pla.item_description ITEM_DESCRIPTION,
1756: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1757: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,

Line 1754: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,

1750: pcr.new_quantity NEW_QTY,
1751: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',nvl(pcr.old_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE,
1752: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE,
1753: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1754: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1755: pla.item_description ITEM_DESCRIPTION,
1756: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1757: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
1758: pcr.ACTION_TYPE ACTION_CODE,

Line 1799: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',

1795: plla.quantity OLD_QTY,
1796: pcr.new_quantity NEW_QTY,
1797: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',nvl(pcr.new_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE,
1798: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE,
1799: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1800: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1801: pla.item_description ITEM_DESCRIPTION,
1802: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1803: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,

Line 1800: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,

1796: pcr.new_quantity NEW_QTY,
1797: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',nvl(pcr.new_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE,
1798: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE,
1799: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1800: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1801: pla.item_description ITEM_DESCRIPTION,
1802: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1803: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
1804: pcr.ACTION_TYPE ACTION_CODE,

Line 1806: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT

1802: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1803: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
1804: pcr.ACTION_TYPE ACTION_CODE,
1805: pcr.REQUEST_REASON REASON,
1806: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
1807: from
1808: po_change_requests pcr,
1809: po_lines_archive_all pla,
1810: po_line_locations_archive_all plla,

Line 1915: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');

1911: from po_headers_all
1912: where po_header_id = l_header_id;
1913:
1914: if(l_type_lookup_code = 'STANDARD') then
1915: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1916: elsif(l_type_lookup_code = 'PLANNED') then
1917: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1918: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1919: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');

Line 1917: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');

1913:
1914: if(l_type_lookup_code = 'STANDARD') then
1915: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1916: elsif(l_type_lookup_code = 'PLANNED') then
1917: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1918: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1919: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1920: elsif(l_type_lookup_code = 'BLANKET') then
1921: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');

Line 1919: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');

1915: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1916: elsif(l_type_lookup_code = 'PLANNED') then
1917: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1918: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1919: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1920: elsif(l_type_lookup_code = 'BLANKET') then
1921: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
1922: elsif(l_type_lookup_code = 'CONTRACT') then
1923: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');

Line 1921: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');

1917: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1918: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1919: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1920: elsif(l_type_lookup_code = 'BLANKET') then
1921: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
1922: elsif(l_type_lookup_code = 'CONTRACT') then
1923: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');
1924: else
1925: l_document_type := 'Error';

Line 1923: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');

1919: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1920: elsif(l_type_lookup_code = 'BLANKET') then
1921: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
1922: elsif(l_type_lookup_code = 'CONTRACT') then
1923: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');
1924: else
1925: l_document_type := 'Error';
1926: end if;
1927:

Line 1964: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');

1960: and pr.po_header_id = ph.po_header_id;
1961: /*Modified as part of bug 7550964 changing date format*/
1962:
1963: if(l_type_lookup_code = 'BLANKET') then
1964: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');
1965: elsif(l_type_lookup_code = 'PLANNED') then
1966: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');
1967: else
1968: l_document_type := 'Error';

Line 1966: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');

1962:
1963: if(l_type_lookup_code = 'BLANKET') then
1964: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');
1965: elsif(l_type_lookup_code = 'PLANNED') then
1966: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');
1967: else
1968: l_document_type := 'Error';
1969: end if;
1970:

Line 2019: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')

2015:
2016: if(l_release_id is null) then
2017: l_document := l_base_url_tag||
2018: '
2019: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
2020: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
2021: l_po_currency||') '||
2022: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
2023: ||')

Line 2041: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||'

2037:
2038:
2039:
2040:
2042:
2043:
2044:
2045:

2042:

2043:
2044:
2045:
2047:

2060: '
2061:

2062:
2063:
2065:
2067:
2068:

Line 2072: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||'

2068:
2069:
2070:

2071:
2073:
2075:
2076:

2041: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||'	'||l_supplier_name||'
Line 2046: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||'	'||l_supplier_name||'
2046: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||'	'; 2048: 2049: if(l_sup_address_line1 is not null) then 2050: l_document := l_document || l_sup_address_line1||' '; Line 2064: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||'
2064: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||'	'||l_fob|| 2066: '
2072: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||'	'||l_carrier|| 2074: '

Line 2082: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||'

2078:
2079:
2080:
2081:
2083:
2085:
2086:

Line 2089: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||'

2085:
2086:
2087:

2088:
2090:

2082: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||'

'||l_order_date|| 2084: '

2089: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||'

2091: '|| 2092: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| 2093: l_ship_city||', '||l_ship_state||' '||l_ship_zip Line 2130: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 2126: lc_split; 2127: close l_po_chg_req_csr; 2128: if(lc_line_num is not null) then 2129: l_document := ''|| 2130: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 2131: ' '; 2132: l_document := l_document||''|| NL; 2133: l_document:= l_document||' '|| 2134: '' Line 2135: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 2131: ' '; 2132: l_document := l_document||''|| NL; 2133: l_document:= l_document||'' || NL; 2137: l_document := l_document || ''|| NL; 2138: l_document:= l_document||'' || NL; 2137: l_document := l_document || ''|| NL; 2138: l_document:= l_document||'' || NL; 2142: l_document := l_document || ' '|| 2134: '' 2135: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 2136: l_document := l_document || ' '|| 2139: '' Line 2140: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 2136: l_document := l_document || ' '|| 2139: '' 2140: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 2141: l_document := l_document || ' ' || NL; 2143: l_document := l_document ||' 2144: Line 2146: 2142: l_document := l_document || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' ' || NL; 2143: l_document := l_document ||' 2144: 2145: 2146: 2147: 2148: 2149: 2150: Line 2147: 2143: l_document := l_document ||' 2144: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' 2145: 2146: 2147: 2148: 2149: 2150: 2151: '; Line 2148: 2144: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' 2145: 2146: 2147: 2148: 2149: 2150: 2151: '; 2152: if (l_type_lookup_code = 'BLANKET') then Line 2149: 2145: 2146: 2147: 2148: 2149: 2150: 2151: '; 2152: if (l_type_lookup_code = 'BLANKET') then 2153: l_document := l_document || ' '; Line 2150: 2146: 2147: 2148: 2149: 2150: 2151: '; 2152: if (l_type_lookup_code = 'BLANKET') then 2153: l_document := l_document || ' '; 2154: else Line 2151: '; 2147: 2148: 2149: 2150: 2151: '; 2152: if (l_type_lookup_code = 'BLANKET') then 2153: l_document := l_document || ' '; 2154: else 2155: l_document := l_document || ' '; Line 2153: l_document := l_document || ' '; 2149: 2150: 2151: '; 2152: if (l_type_lookup_code = 'BLANKET') then 2153: l_document := l_document || ' '; 2154: else 2155: l_document := l_document || ' '; 2156: end if; 2157: l_document := l_document || Line 2155: l_document := l_document || ' '; 2151: '; 2152: if (l_type_lookup_code = 'BLANKET') then 2153: l_document := l_document || ' '; 2154: else 2155: l_document := l_document || ' '; 2156: end if; 2157: l_document := l_document || 2158: ' 2159: Line 2158: ' 2154: else 2155: l_document := l_document || ' '; 2156: end if; 2157: l_document := l_document || 2158: ' 2159: 2160: 2161: 2162: Line 2159: 2155: l_document := l_document || ' '; 2156: end if; 2157: l_document := l_document || 2158: ' 2159: 2160: 2161: 2162: 2163: Line 2160: 2156: end if; 2157: l_document := l_document || 2158: ' 2159: 2160: 2161: 2162: 2163: 2164: Line 2161: 2157: l_document := l_document || 2158: ' 2159: 2160: 2161: 2162: 2163: 2164: 2165: '; Line 2162: 2158: ' 2159: 2160: 2161: 2162: 2163: 2164: 2165: '; 2166: Line 2163: 2159: 2160: 2161: 2162: 2163: 2164: 2165: '; 2166: 2167: WF_NOTIFICATION.WriteToClob(document,l_document); Line 2415: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 2411: fetch l_header_changes_csr into l_additional_changes; 2412: close l_header_changes_csr; 2413: 2414: if(l_additional_changes is not null) then 2415: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 2416: ' `  '||l_additional_changes||' '; 2417: WF_NOTIFICATION.WriteToClob(document,l_document); 2418: end if; 2419: Line 2421: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2417: WF_NOTIFICATION.WriteToClob(document,l_document); 2418: end if; 2419: 2420: else 2421: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2422: fnd_message.set_token('DOC',l_document_type); 2423: l_document := fnd_message.get; 2424: WF_NOTIFICATION.WriteToClob(document,l_document); 2425: end if; Line 2422: fnd_message.set_token('DOC',l_document_type); 2418: end if; 2419: 2420: else 2421: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2422: fnd_message.set_token('DOC',l_document_type); 2423: l_document := fnd_message.get; 2424: WF_NOTIFICATION.WriteToClob(document,l_document); 2425: end if; 2426: exception when others then Line 2423: l_document := fnd_message.get; 2419: 2420: else 2421: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2422: fnd_message.set_token('DOC',l_document_type); 2423: l_document := fnd_message.get; 2424: WF_NOTIFICATION.WriteToClob(document,l_document); 2425: end if; 2426: exception when others then 2427: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); Line 2546: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 2542: pla.quantity OLD_QTY, 2543: to_number(null) NEW_QTY, 2544: pla.unit_price OLD_PRICE, 2545: pcr.new_price NEW_PRICE, 2546: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 2547: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2548: pla.item_description ITEM_DESCRIPTION, 2549: pla.unit_meas_lookup_code UOM, 2550: null SHIP_TO_LOCATION, Line 2547: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2543: to_number(null) NEW_QTY, 2544: pla.unit_price OLD_PRICE, 2545: pcr.new_price NEW_PRICE, 2546: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 2547: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2548: pla.item_description ITEM_DESCRIPTION, 2549: pla.unit_meas_lookup_code UOM, 2550: null SHIP_TO_LOCATION, 2551: pcr.ACTION_TYPE ACTION_CODE, Line 2588: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2584: plla.quantity OLD_QTY, 2585: pcr.new_quantity NEW_QTY, 2586: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',nvl(pcr.old_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE, 2587: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE, 2588: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2589: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2590: pla.item_description ITEM_DESCRIPTION, 2591: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2592: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 2589: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2585: pcr.new_quantity NEW_QTY, 2586: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',nvl(pcr.old_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE, 2587: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE, 2588: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2589: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2590: pla.item_description ITEM_DESCRIPTION, 2591: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2592: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 2593: pcr.ACTION_TYPE ACTION_CODE, Line 2637: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2633: plla.quantity OLD_QTY, 2634: pcr.new_quantity NEW_QTY, 2635: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',nvl(pcr.new_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE, 2636: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE, 2637: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2638: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2639: pla.item_description ITEM_DESCRIPTION, 2640: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2641: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 2638: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2634: pcr.new_quantity NEW_QTY, 2635: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',nvl(pcr.new_price,plla.price_override),nvl(pcr.old_amount,plla.amount)),nvl(pcr.old_price,plla.price_override)) OLD_PRICE, 2636: decode(pla.matching_basis,'AMOUNT',DECODE(nvl(pcr.new_progress_type,plla.payment_type),'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE, 2637: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2638: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2639: pla.item_description ITEM_DESCRIPTION, 2640: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2641: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 2642: pcr.ACTION_TYPE ACTION_CODE, Line 2644: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 2640: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2641: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 2642: pcr.ACTION_TYPE ACTION_CODE, 2643: pcr.REQUEST_REASON REASON, 2644: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 2645: from 2646: po_change_requests pcr, 2647: po_lines_archive_all pla, 2648: po_line_locations_archive_all plla, Line 2753: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2749: from po_headers_all 2750: where po_header_id = l_header_id; 2751: 2752: if(l_type_lookup_code = 'STANDARD') then 2753: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2754: elsif(l_type_lookup_code = 'PLANNED') then 2755: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2756: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2757: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); Line 2755: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2751: 2752: if(l_type_lookup_code = 'STANDARD') then 2753: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2754: elsif(l_type_lookup_code = 'PLANNED') then 2755: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2756: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2757: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2758: elsif(l_type_lookup_code = 'BLANKET') then 2759: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); Line 2757: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2753: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2754: elsif(l_type_lookup_code = 'PLANNED') then 2755: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2756: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2757: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2758: elsif(l_type_lookup_code = 'BLANKET') then 2759: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2760: elsif(l_type_lookup_code = 'CONTRACT') then 2761: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); Line 2759: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2755: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2756: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2757: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2758: elsif(l_type_lookup_code = 'BLANKET') then 2759: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2760: elsif(l_type_lookup_code = 'CONTRACT') then 2761: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 2762: else 2763: l_document_type := 'Error'; Line 2761: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 2757: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2758: elsif(l_type_lookup_code = 'BLANKET') then 2759: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2760: elsif(l_type_lookup_code = 'CONTRACT') then 2761: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 2762: else 2763: l_document_type := 'Error'; 2764: end if; 2765: Line 2801: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 2797: where pr.po_release_id = l_release_id 2798: and pr.po_header_id = ph.po_header_id; 2799: 2800: if(l_type_lookup_code = 'BLANKET') then 2801: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 2802: elsif(l_type_lookup_code = 'PLANNED') then 2803: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 2804: else 2805: l_document_type := 'Error'; Line 2803: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 2799: 2800: if(l_type_lookup_code = 'BLANKET') then 2801: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 2802: elsif(l_type_lookup_code = 'PLANNED') then 2803: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 2804: else 2805: l_document_type := 'Error'; 2806: end if; 2807: Line 2855: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 2851: 2852: if(l_release_id is null) then 2853: l_document :=l_base_url_tag|| 2854: ' 2855: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 2856: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2857: l_po_currency||') '|| 2858: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2859: ||') '; Line 2856: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2852: if(l_release_id is null) then 2853: l_document :=l_base_url_tag|| 2854: ' 2855: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 2856: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2857: l_po_currency||') '|| 2858: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2859: ||') '; 2860: else Line 2863: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 2859: ||') '; 2860: else 2861: l_document :=l_base_url_tag|| 2862: ' 2863: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 2864: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2865: l_po_currency||') '|| 2866: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2867: ||') '; Line 2864: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2860: else 2861: l_document :=l_base_url_tag|| 2862: ' 2863: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 2864: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2865: l_po_currency||') '|| 2866: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2867: ||') '; 2868: end if; Line 2877: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' 2873: 2914: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','POS_PRICE_BREAK')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','POS_PRICE_BREAK')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','POS_PRICE_BREAK')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','POS_PRICE_BREAK')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','POS_PRICE_BREAK')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','POS_PRICE_BREAK')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' 2874: 2875: 2876: 2878: 2879: 2880: 2881: 2878: 2879: 2880: 2881: 2883: 2896: ' 2897: 2898: 2899: 2901: 2903: 2904: Line 2908: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' 2904: 2905: 2906: 2907: 2909: 2911: 2912: 2877: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||' Line 2882: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_supplier_name||' 2882: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '; 2884: 2885: if(l_sup_address_line1 is not null) then 2886: l_document := l_document || l_sup_address_line1||' '; Line 2900: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' 2900: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob|| 2902: ' 2908: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier|| 2910: ' Line 2918: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' 2915: 2916: 2917: 2919: 2921: 2922: Line 2925: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 2921: 2922: 2923: 2924: 2926: 2918: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date|| 2920: ' 2925: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 2927: '|| 2928: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| 2929: l_ship_city||', '||l_ship_state||' '||l_ship_zip Line 2966: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 2962: lc_split; 2963: close l_po_chg_req_csr; 2964: if(lc_line_num is not null) then 2965: l_document := ''|| 2966: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 2967: ' '; 2968: l_document := l_document||''|| NL; 2969: l_document:= l_document||' '|| 2970: '' Line 2971: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 2967: ' '; 2968: l_document := l_document||''|| NL; 2969: l_document:= l_document||'' || NL; 2973: l_document := l_document || ''|| NL; 2974: l_document:= l_document||'' || NL; 2973: l_document := l_document || ''|| NL; 2974: l_document:= l_document||'' || NL; 2978: l_document := l_document || ' '|| 2970: '' 2971: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 2972: l_document := l_document || ' '|| 2975: '' Line 2976: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 2972: l_document := l_document || ' '|| 2975: '' 2976: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 2977: l_document := l_document || ' ' || NL; 2979: l_document := l_document ||' 2980: Line 2982: 2978: l_document := l_document || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' ' || NL; 2979: l_document := l_document ||' 2980: 2981: 2982: 2983: 2984: 2985: 2986: Line 2983: 2979: l_document := l_document ||' 2980: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' 2981: 2982: 2983: 2984: 2985: 2986: 2987: Line 2984: 2980: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' 2981: 2982: 2983: 2984: 2985: 2986: 2987: 2988: Line 2985: 2981: 2982: 2983: 2984: 2985: 2986: 2987: 2988: 2989: Line 2986: 2982: 2983: 2984: 2985: 2986: 2987: 2988: 2989: 2990: Line 2987: 2983: 2984: 2985: 2986: 2987: 2988: 2989: 2990: 2991: Line 2988: 2984: 2985: 2986: 2987: 2988: 2989: 2990: 2991: 2992: Line 2989: 2985: 2986: 2987: 2988: 2989: 2990: 2991: 2992: 2993: Line 2990: 2986: 2987: 2988: 2989: 2990: 2991: 2992: 2993: 2994: Line 2991: 2987: 2988: 2989: 2990: 2991: 2992: 2993: 2994: 2995: Line 2992: 2988: 2989: 2990: 2991: 2992: 2993: 2994: 2995: 2996: '; Line 2993: 2989: 2990: 2991: 2992: 2993: 2994: 2995: 2996: '; 2997: Line 2994: 2990: 2991: 2992: 2993: 2994: 2995: 2996: '; 2997: 2998: WF_NOTIFICATION.WriteToClob(document,l_document); Line 3239: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 3235: fetch l_header_changes_csr into l_additional_changes; 3236: close l_header_changes_csr; 3237: 3238: if(l_additional_changes is not null) then 3239: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 3240: ' `  '||l_additional_changes||' '; 3241: WF_NOTIFICATION.WriteToClob(document,l_document); 3242: end if; 3243: Line 3245: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3241: WF_NOTIFICATION.WriteToClob(document,l_document); 3242: end if; 3243: 3244: else 3245: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3246: fnd_message.set_token('DOC',l_document_type); 3247: l_document := fnd_message.get; 3248: WF_NOTIFICATION.WriteToClob(document,l_document); 3249: end if; Line 3246: fnd_message.set_token('DOC',l_document_type); 3242: end if; 3243: 3244: else 3245: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3246: fnd_message.set_token('DOC',l_document_type); 3247: l_document := fnd_message.get; 3248: WF_NOTIFICATION.WriteToClob(document,l_document); 3249: end if; 3250: exception when others then Line 3247: l_document := fnd_message.get; 3243: 3244: else 3245: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3246: fnd_message.set_token('DOC',l_document_type); 3247: l_document := fnd_message.get; 3248: WF_NOTIFICATION.WriteToClob(document,l_document); 3249: end if; 3250: exception when others then 3251: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); Line 3371: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 3367: pla.quantity OLD_QTY, 3368: to_number(null) NEW_QTY, 3369: pla.unit_price OLD_PRICE, 3370: pcr.new_price NEW_PRICE, 3371: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 3372: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3373: pla.item_description ITEM_DESCRIPTION, 3374: pla.unit_meas_lookup_code UOM, 3375: null SHIP_TO_LOCATION, Line 3372: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3368: to_number(null) NEW_QTY, 3369: pla.unit_price OLD_PRICE, 3370: pcr.new_price NEW_PRICE, 3371: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 3372: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3373: pla.item_description ITEM_DESCRIPTION, 3374: pla.unit_meas_lookup_code UOM, 3375: null SHIP_TO_LOCATION, 3376: pcr.ACTION_TYPE ACTION_CODE, Line 3408: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3404: plla.quantity OLD_QTY, 3405: pcr.new_quantity NEW_QTY, 3406: plla.price_override OLD_PRICE, 3407: pcr.new_price NEW_PRICE, 3408: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3409: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3410: pla.item_description ITEM_DESCRIPTION, 3411: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3412: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 3409: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3405: pcr.new_quantity NEW_QTY, 3406: plla.price_override OLD_PRICE, 3407: pcr.new_price NEW_PRICE, 3408: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3409: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3410: pla.item_description ITEM_DESCRIPTION, 3411: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3412: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3413: pcr.ACTION_TYPE ACTION_CODE, Line 3451: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3447: plla.quantity OLD_QTY, 3448: pcr.new_quantity NEW_QTY, 3449: plla.price_override OLD_PRICE, 3450: pcr.new_price NEW_PRICE, 3451: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3452: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3453: pla.item_description ITEM_DESCRIPTION, 3454: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3455: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 3452: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3448: pcr.new_quantity NEW_QTY, 3449: plla.price_override OLD_PRICE, 3450: pcr.new_price NEW_PRICE, 3451: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3452: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3453: pla.item_description ITEM_DESCRIPTION, 3454: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3455: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3456: pcr.ACTION_TYPE ACTION_CODE, Line 3458: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 3454: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3455: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3456: pcr.ACTION_TYPE ACTION_CODE, 3457: pcr.REQUEST_REASON REASON, 3458: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 3459: from 3460: po_change_requests pcr, 3461: po_lines_archive_all pla, 3462: po_line_locations_archive_all plla, Line 3515: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'), 3511: plla.quantity OLD_QTY, 3512: to_number(null) NEW_QTY, 3513: plla.price_override OLD_PRICE, 3514: to_number(null) NEW_PRICE, 3515: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'), 3516: 'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3517: pla.item_description ITEM_DESCRIPTION, 3518: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3519: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 3516: 'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3512: to_number(null) NEW_QTY, 3513: plla.price_override OLD_PRICE, 3514: to_number(null) NEW_PRICE, 3515: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'), 3516: 'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3517: pla.item_description ITEM_DESCRIPTION, 3518: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3519: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3520: pa.note NOTE Line 3559: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'),'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3555: plla.quantity OLD_QTY, 3556: to_number(null) NEW_QTY, 3557: plla.price_override OLD_PRICE, 3558: to_number(null) NEW_PRICE, 3559: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'),'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3560: pla.item_description ITEM_DESCRIPTION, 3561: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3562: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3563: pa.NOTE NOTE Line 3671: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3667: from po_headers_all 3668: where po_header_id = l_header_id; 3669: 3670: if(l_type_lookup_code = 'STANDARD') then 3671: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3672: elsif(l_type_lookup_code = 'PLANNED') then 3673: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3674: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3675: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); Line 3673: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3669: 3670: if(l_type_lookup_code = 'STANDARD') then 3671: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3672: elsif(l_type_lookup_code = 'PLANNED') then 3673: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3674: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3675: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3676: elsif(l_type_lookup_code = 'BLANKET') then 3677: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); Line 3675: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3671: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3672: elsif(l_type_lookup_code = 'PLANNED') then 3673: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3674: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3675: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3676: elsif(l_type_lookup_code = 'BLANKET') then 3677: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3678: elsif(l_type_lookup_code = 'CONTRACT') then 3679: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); Line 3677: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3673: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3674: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3675: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3676: elsif(l_type_lookup_code = 'BLANKET') then 3677: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3678: elsif(l_type_lookup_code = 'CONTRACT') then 3679: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 3680: else 3681: l_document_type := 'Error'; Line 3679: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 3675: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3676: elsif(l_type_lookup_code = 'BLANKET') then 3677: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3678: elsif(l_type_lookup_code = 'CONTRACT') then 3679: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 3680: else 3681: l_document_type := 'Error'; 3682: end if; 3683: Line 3724: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 3720: where pr.po_release_id = l_release_id 3721: and pr.po_header_id = ph.po_header_id; 3722: 3723: if(l_type_lookup_code = 'BLANKET') then 3724: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 3725: elsif(l_type_lookup_code = 'PLANNED') then 3726: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 3727: else 3728: l_document_type := 'Error'; Line 3726: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 3722: 3723: if(l_type_lookup_code = 'BLANKET') then 3724: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 3725: elsif(l_type_lookup_code = 'PLANNED') then 3726: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 3727: else 3728: l_document_type := 'Error'; 3729: end if; 3730: Line 3784: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 3780: 3781: if(l_release_id is null) then 3782: l_document :=l_base_url_tag|| 3783: ' 3784: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 3785: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3786: l_po_currency||') '|| 3787: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 3788: ||') '; */ Line 3785: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3781: if(l_release_id is null) then 3782: l_document :=l_base_url_tag|| 3783: ' 3784: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 3785: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3786: l_po_currency||') '|| 3787: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 3788: ||') '; */ 3789: /* Line 3792: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3788: ||') '; */ 3789: /* 3790: if(l_acc_req_flag <> 'Y') then 3791: l_document := l_document || 3792: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3793: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3794: end if; */ 3795: /* 3796: else Line 3793: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3789: /* 3790: if(l_acc_req_flag <> 'Y') then 3791: l_document := l_document || 3792: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3793: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3794: end if; */ 3795: /* 3796: else 3797: l_document :=l_base_url_tag|| Line 3799: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 3795: /* 3796: else 3797: l_document :=l_base_url_tag|| 3798: ' 3799: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 3800: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3801: l_rel_currency||') '|| 3802: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 3803: ||') '; */ Line 3800: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3796: else 3797: l_document :=l_base_url_tag|| 3798: ' 3799: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 3800: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3801: l_rel_currency||') '|| 3802: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 3803: ||') '; */ 3804: /* Line 3807: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3803: ||') '; */ 3804: /* 3805: if(l_acc_req_flag <> 'Y') then 3806: l_document := l_document || 3807: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3808: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3809: end if;*/ 3810: /* 3811: end if; Line 3808: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3804: /* 3805: if(l_acc_req_flag <> 'Y') then 3806: l_document := l_document || 3807: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3808: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3809: end if;*/ 3810: /* 3811: end if; 3812: Line 3820: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' 3816: 3857: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' 3817: 3818: 3819: 3821: 3822: 3823: 3824: 3821: 3822: 3823: 3824: 3826: 3839: ' 3840: 3841: 3842: 3844: 3846: 3847: Line 3851: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' 3847: 3848: 3849: 3850: 3852: 3854: 3855: 3820: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||' Line 3825: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_supplier_name||' 3825: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '; 3827: 3828: if(l_sup_address_line1 is not null) then 3829: l_document := l_document || l_sup_address_line1||' '; Line 3843: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' 3843: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob|| 3845: ' 3851: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier|| 3853: ' Line 3861: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' 3858: 3859: 3860: 3862: 3864: 3865: Line 3868: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 3864: 3865: 3866: 3867: 3869: 3861: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date|| 3863: ' 3868: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 3870: '|| 3871: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| 3872: l_ship_city||', '||l_ship_state||' '||l_ship_zip Line 3904: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3900: lc_ship_to_location, 3901: lc_reason; 3902: close l_po_ack_csr; 3903: if(lc_line_num is not null) then 3904: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3905: 3906: 3907: 3908: Line 3907: 3903: if(lc_line_num is not null) then 3904: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3905: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' 3906: 3907: 3908: 3909: 3910: 3911: Line 3908: 3904: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3905: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' 3906: 3907: 3908: 3909: 3910: 3911: 3912: Line 3909: 3905: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' 3906: 3907: 3908: 3909: 3910: 3911: 3912: 3913: Line 3910: 3906: 3907: 3908: 3909: 3910: 3911: 3912: 3913: 3914: Line 3911: 3907: 3908: 3909: 3910: 3911: 3912: 3913: 3914: 3915: Line 3912: 3908: 3909: 3910: 3911: 3912: 3913: 3914: 3915: 3916: Line 3913: 3909: 3910: 3911: 3912: 3913: 3914: 3915: 3916: 3917: Line 3914: 3910: 3911: 3912: 3913: 3914: 3915: 3916: 3917: 3918: Line 3915: 3911: 3912: 3913: 3914: 3915: 3916: 3917: 3918: 3919: Line 3916: 3912: 3913: 3914: 3915: 3916: 3917: 3918: 3919: 3920: '; Line 3917: 3913: 3914: 3915: 3916: 3917: 3918: 3919: 3920: '; 3921: Line 3918: 3914: 3915: 3916: 3917: 3918: 3919: 3920: '; 3921: 3922: WF_NOTIFICATION.WriteToClob(document,l_document); Line 4030: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 4026: lc_split; 4027: close l_po_chg_req_csr; 4028: if(lc_line_num is not null) then 4029: l_document := ''|| 4030: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 4031: ' '; 4032: l_document := l_document||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '|| NL; 4033: l_document:= l_document||' '|| 4034: '' Line 4035: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 4031: ' '; 4032: l_document := l_document||''|| NL; 4033: l_document:= l_document||'' || NL; 4037: l_document := l_document || ''|| NL; 4038: l_document:= l_document||'' || NL; 4037: l_document := l_document || ''|| NL; 4038: l_document:= l_document||'' || NL; 4042: l_document := l_document || ' '|| 4034: '' 4035: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 4036: l_document := l_document || ' '|| 4039: '' Line 4040: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 4036: l_document := l_document || ' '|| 4039: '' 4040: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 4041: l_document := l_document || ' ' || NL; 4043: l_document := l_document ||' 4044: Line 4046: 4042: l_document := l_document || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' ' || NL; 4043: l_document := l_document ||' 4044: 4045: 4046: 4047: 4048: 4049: 4050: Line 4047: 4043: l_document := l_document ||' 4044: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' 4045: 4046: 4047: 4048: 4049: 4050: 4051: Line 4048: 4044: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' 4045: 4046: 4047: 4048: 4049: 4050: 4051: 4052: Line 4049: 4045: 4046: 4047: 4048: 4049: 4050: 4051: 4052: 4053: Line 4050: 4046: 4047: 4048: 4049: 4050: 4051: 4052: 4053: 4054: Line 4051: 4047: 4048: 4049: 4050: 4051: 4052: 4053: 4054: 4055: Line 4052: 4048: 4049: 4050: 4051: 4052: 4053: 4054: 4055: 4056: Line 4053: 4049: 4050: 4051: 4052: 4053: 4054: 4055: 4056: 4057: Line 4054: 4050: 4051: 4052: 4053: 4054: 4055: 4056: 4057: 4058: Line 4055: 4051: 4052: 4053: 4054: 4055: 4056: 4057: 4058: 4059: Line 4056: 4052: 4053: 4054: 4055: 4056: 4057: 4058: 4059: 4060: '; Line 4057: 4053: 4054: 4055: 4056: 4057: 4058: 4059: 4060: '; 4061: Line 4058: 4054: 4055: 4056: 4057: 4058: 4059: 4060: '; 4061: 4062: WF_NOTIFICATION.WriteToClob(document,l_document); Line 4313: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 4309: fetch l_header_changes_csr into l_additional_changes; 4310: close l_header_changes_csr; 4311: 4312: if(l_additional_changes is not null) then 4313: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 4314: ' `  '||l_additional_changes||' '; 4315: WF_NOTIFICATION.WriteToClob(document,l_document); 4316: end if; 4317: else Line 4318: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4314: ' `  '||l_additional_changes||' '; 4315: WF_NOTIFICATION.WriteToClob(document,l_document); 4316: end if; 4317: else 4318: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4319: fnd_message.set_token('DOC',l_document_type); 4320: l_document := fnd_message.get; 4321: WF_NOTIFICATION.WriteToClob(document,l_document); 4322: end if; Line 4319: fnd_message.set_token('DOC',l_document_type); 4315: WF_NOTIFICATION.WriteToClob(document,l_document); 4316: end if; 4317: else 4318: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4319: fnd_message.set_token('DOC',l_document_type); 4320: l_document := fnd_message.get; 4321: WF_NOTIFICATION.WriteToClob(document,l_document); 4322: end if; 4323: exception when others then Line 4320: l_document := fnd_message.get; 4316: end if; 4317: else 4318: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4319: fnd_message.set_token('DOC',l_document_type); 4320: l_document := fnd_message.get; 4321: WF_NOTIFICATION.WriteToClob(document,l_document); 4322: end if; 4323: exception when others then 4324: IF g_fnd_debug = 'Y' THEN Line 4441: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4437: nvl(pcr.old_quantity, pla.quantity) OLD_QTY, 4438: to_number(null) NEW_QTY, 4439: nvl(pcr.old_price,pla.unit_price) OLD_PRICE, 4440: pcr.new_price NEW_PRICE, 4441: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4442: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4443: pla.item_description ITEM_DESCRIPTION, 4444: pla.unit_meas_lookup_code UOM, 4445: null SHIP_TO_LOCATION, Line 4442: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4438: to_number(null) NEW_QTY, 4439: nvl(pcr.old_price,pla.unit_price) OLD_PRICE, 4440: pcr.new_price NEW_PRICE, 4441: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4442: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4443: pla.item_description ITEM_DESCRIPTION, 4444: pla.unit_meas_lookup_code UOM, 4445: null SHIP_TO_LOCATION, 4446: pcr.response_reason REASON, Line 4468: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4464: nvl(pcr.old_quantity,plla.quantity) OLD_QTY, 4465: pcr.new_quantity NEW_QTY, 4466: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4467: pcr.new_price NEW_PRICE, 4468: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4469: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4470: pla.item_description ITEM_DESCRIPTION, 4471: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4472: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 4469: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4465: pcr.new_quantity NEW_QTY, 4466: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4467: pcr.new_price NEW_PRICE, 4468: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4469: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4470: pla.item_description ITEM_DESCRIPTION, 4471: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4472: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4473: pcr.response_reason REASON, Line 4474: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4470: pla.item_description ITEM_DESCRIPTION, 4471: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4472: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4473: pcr.response_reason REASON, 4474: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4475: pcr.action_type ACTION_CODE 4476: 4477: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla, 4478: hr_locations_all hla, hz_locations hz Line 4504: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4500: pcr.old_quantity OLD_QTY, 4501: pcr.new_quantity NEW_QTY, 4502: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4503: pcr.new_price NEW_PRICE, 4504: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4505: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4506: pla.item_description ITEM_DESCRIPTION, 4507: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4508: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 4505: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4501: pcr.new_quantity NEW_QTY, 4502: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4503: pcr.new_price NEW_PRICE, 4504: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4505: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4506: pla.item_description ITEM_DESCRIPTION, 4507: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4508: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4509: pcr.response_reason REASON, Line 4510: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4506: pla.item_description ITEM_DESCRIPTION, 4507: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4508: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4509: pcr.response_reason REASON, 4510: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4511: pcr.action_type ACTION_CODE 4512: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla, 4513: hr_locations_all hla, hz_locations hz 4514: where change_request_group_id =grp_id Line 4684: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4680: if (display_type = 'text/html') then 4681: 4682: if(l_po_release_id is null) then 4683: if(l_type_lookup_code = 'STANDARD') then 4684: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4685: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 4686: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4687: elsif(l_type_lookup_code = 'BLANKET') then 4688: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; Line 4686: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4682: if(l_po_release_id is null) then 4683: if(l_type_lookup_code = 'STANDARD') then 4684: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4685: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 4686: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4687: elsif(l_type_lookup_code = 'BLANKET') then 4688: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4689: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num, 4690: l_type_lookup_code ); Line 4688: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4684: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4685: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 4686: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4687: elsif(l_type_lookup_code = 'BLANKET') then 4688: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4689: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num, 4690: l_type_lookup_code ); 4691: elsif(l_type_lookup_code = 'CONTRACT') then 4692: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; Line 4692: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 4688: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4689: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num, 4690: l_type_lookup_code ); 4691: elsif(l_type_lookup_code = 'CONTRACT') then 4692: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 4693: elsif(l_type_lookup_code = 'PLANNED') then 4694: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4695: end if; 4696: l_document :=l_base_url_tag|| ' Line 4694: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4690: l_type_lookup_code ); 4691: elsif(l_type_lookup_code = 'CONTRACT') then 4692: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 4693: elsif(l_type_lookup_code = 'PLANNED') then 4694: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4695: end if; 4696: l_document :=l_base_url_tag|| ' 4697: '||l_doc_hdr_info||' '|| 4698: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' Line 4698: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4694: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4695: end if; 4696: l_document :=l_base_url_tag|| ' 4697: '||l_doc_hdr_info||' '|| 4698: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4699: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'|| 4700: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 4701: ||') '; 4702: Line 4699: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'|| 4695: end if; 4696: l_document :=l_base_url_tag|| ' 4697: '||l_doc_hdr_info||' '|| 4698: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4699: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'|| 4700: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 4701: ||') '; 4702: 4703: else Line 4705: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 4701: ||') '; 4702: 4703: else 4704: if(l_type_lookup_code = 'BLANKET') then 4705: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 4706: elsif(l_type_lookup_code = 'PLANNED') then 4707: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4708: end if; 4709: l_document :=l_base_url_tag|| ' Line 4707: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4703: else 4704: if(l_type_lookup_code = 'BLANKET') then 4705: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 4706: elsif(l_type_lookup_code = 'PLANNED') then 4707: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4708: end if; 4709: l_document :=l_base_url_tag|| ' 4710: '||l_doc_hdr_info|| 4711: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' Line 4711: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4707: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4708: end if; 4709: l_document :=l_base_url_tag|| ' 4710: '||l_doc_hdr_info|| 4711: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 4713: l_rel_currency||')'|| 4714: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 4715: ||') '; Line 4712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 4708: end if; 4709: l_document :=l_base_url_tag|| ' 4710: '||l_doc_hdr_info|| 4711: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 4713: l_rel_currency||')'|| 4714: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 4715: ||') '; 4716: Line 4726: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' 4722: 4752: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_ACTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' 4723: 4724: 4725: 4727: 4728: 4729: 4730: 4727: 4728: 4729: 4730: 4732: 4735: Line 4738: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' 4734: ' 4735: 4736: 4737: 4739: 4741: 4742: Line 4746: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' 4742: 4743: 4744: 4745: 4747: 4749: 4750: 4726: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||' Line 4731: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_supplier_name||' 4731: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_sup_address_line1||' '||l_sup_address_line2||' '|| 4733: l_sup_address_line3||' '||l_sup_city||', '||l_sup_state||' '||l_sup_zip|| 4734: ' 4738: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob|| 4740: ' 4746: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier|| 4748: ' Line 4756: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' 4753: 4754: 4755: 4757: 4759: 4760: Line 4763: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 4759: 4760: 4761: 4762: 4764: 4756: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date|| 4758: ' 4763: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' '; 4765: if(l_ship_addr_l1 is not null) then 4766: l_document := l_document || l_ship_addr_l1||' '; 4767: end if; Line 4787: l_document := ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_DETAILS')||' '; 4783: '; 4784: 4785: WF_Notification.WriteToClob(document,l_document); 4786: if(l_header_cancel = 'N') then 4787: l_document := ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_DETAILS')||' '; 4788: --LEGENDS 4789: l_document := l_document||''|| NL; 4790: l_document:= l_document||' 4800: 4801: l_document := l_document || 4802: ' '|| 4791: '' Line 4792: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 4788: --LEGENDS 4789: l_document := l_document||''|| NL; 4790: l_document:= l_document||'' || NL; 4794: l_document := l_document || ''|| NL; 4795: l_document:= l_document||'' || NL; 4794: l_document := l_document || ''|| NL; 4795: l_document:= l_document||'' || NL; 4799: l_document := l_document || ' '|| 4791: '' 4792: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 4793: l_document := l_document || ' '|| 4796: '' Line 4797: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 4793: l_document := l_document || ' '|| 4796: '' 4797: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 4798: l_document := l_document || ' ' || NL; 4800: 4801: l_document := l_document || Line 4804: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' 4803: 4804: 4805: 4806: 4807: 4808: Line 4805: 4801: l_document := l_document || 4802: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' 4803: 4804: 4805: 4806: 4807: 4808: 4809: Line 4806: 4802: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' 4803: 4804: 4805: 4806: 4807: 4808: 4809: 4810: Line 4807: 4803: 4804: 4805: 4806: 4807: 4808: 4809: 4810: 4811: Line 4808: 4804: 4805: 4806: 4807: 4808: 4809: 4810: 4811: 4812: Line 4809: 4805: 4806: 4807: 4808: 4809: 4810: 4811: 4812: 4813: Line 4810: 4806: 4807: 4808: 4809: 4810: 4811: 4812: 4813: 4814: Line 4811: 4807: 4808: 4809: 4810: 4811: 4812: 4813: 4814: 4815: Line 4812: 4808: 4809: 4810: 4811: 4812: 4813: 4814: 4815: 4816: Line 4813: 4809: 4810: 4811: 4812: 4813: 4814: 4815: 4816: 4817: '; Line 4814: 4810: 4811: 4812: 4813: 4814: 4815: 4816: 4817: '; 4818: WF_NOTIFICATION.WriteToClob(document,l_document); Line 4815: 4811: 4812: 4813: 4814: 4815: 4816: 4817: '; 4818: WF_NOTIFICATION.WriteToClob(document,l_document); 4819: open l_po_chg_req_csr(p_chg_req_grp_id); Line 5059: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'); 5055: close l_header_changes_csr; 5056: 5057: if(l_additional_changes is not null) then 5058: if(l_header_response = 'ACCEPTED') then 5059: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'); 5060: else 5061: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 5062: end if; 5063: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPMENT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SUP_ITEM')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_DOC_DESCRIPTION')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_UNIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PRICE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_QTY_ORDERED')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_PROM_DATE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SHIPTO')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||' '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||' ' || Line 5061: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 5057: if(l_additional_changes is not null) then 5058: if(l_header_response = 'ACCEPTED') then 5059: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'); 5060: else 5061: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 5062: end if; 5063: l_document := ' ' || 5064: '' || 5065: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| Line 5065: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| 5061: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 5062: end if; 5063: l_document := ' ' || 5064: '' || 5065: '' || 5067: '' || 5069: '' || Line 5067: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| 5066: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')|| 5068: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')|| 5063: l_document := ' ' || 5064: '' || 5065: '' || 5067: '' || 5069: '' || 5070: '' || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| 5066: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')|| 5068: ' ' || l_additional_changes || 5071: ' ' || l_header_response || Line 5081: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 5077: end if; 5078: 5079: else --if header_cnacel = N 5080: if(l_header_response = 'ACCEPTED') then 5081: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 5082: else 5083: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 5084: end if; 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); Line 5083: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 5079: else --if header_cnacel = N 5080: if(l_header_response = 'ACCEPTED') then 5081: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 5082: else 5083: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 5084: end if; 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 5086: fnd_message.set_token('DOC',l_doc_hdr_info); 5087: fnd_message.set_token('RESPONSE',l_header_response); Line 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 5081: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 5082: else 5083: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 5084: end if; 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 5086: fnd_message.set_token('DOC',l_doc_hdr_info); 5087: fnd_message.set_token('RESPONSE',l_header_response); 5088: l_document := fnd_message.get; 5089: WF_NOTIFICATION.WriteToClob(document,l_document); Line 5086: fnd_message.set_token('DOC',l_doc_hdr_info); 5082: else 5083: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 5084: end if; 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 5086: fnd_message.set_token('DOC',l_doc_hdr_info); 5087: fnd_message.set_token('RESPONSE',l_header_response); 5088: l_document := fnd_message.get; 5089: WF_NOTIFICATION.WriteToClob(document,l_document); 5090: end if; Line 5087: fnd_message.set_token('RESPONSE',l_header_response); 5083: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 5084: end if; 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 5086: fnd_message.set_token('DOC',l_doc_hdr_info); 5087: fnd_message.set_token('RESPONSE',l_header_response); 5088: l_document := fnd_message.get; 5089: WF_NOTIFICATION.WriteToClob(document,l_document); 5090: end if; 5091: else Line 5088: l_document := fnd_message.get; 5084: end if; 5085: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 5086: fnd_message.set_token('DOC',l_doc_hdr_info); 5087: fnd_message.set_token('RESPONSE',l_header_response); 5088: l_document := fnd_message.get; 5089: WF_NOTIFICATION.WriteToClob(document,l_document); 5090: end if; 5091: else 5092: WF_NOTIFICATION.WriteToClob(document,'GEN_NTF_FOR_SUP_BUY_RP for no html customer'); Line 5242: fnd_message.set_name('PO', l_message_name); 5238: else 5239: return; 5240: end if; 5241: 5242: fnd_message.set_name('PO', l_message_name); 5243: l_msg_header := fnd_message.get; 5244: ELSIF( l_display_name IS NOT NULL) THEN 5245: l_msg_header := l_display_name; 5246: END IF; Line 5243: l_msg_header := fnd_message.get; 5239: return; 5240: end if; 5241: 5242: fnd_message.set_name('PO', l_message_name); 5243: l_msg_header := fnd_message.get; 5244: ELSIF( l_display_name IS NOT NULL) THEN 5245: l_msg_header := l_display_name; 5246: END IF; 5247: Line 5248: --fnd_message.set_token('PO_NUMBER', l_po_num); 5244: ELSIF( l_display_name IS NOT NULL) THEN 5245: l_msg_header := l_display_name; 5246: END IF; 5247: 5248: --fnd_message.set_token('PO_NUMBER', l_po_num); 5249: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message 5250: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || 5251: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5252: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || Line 5251: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5247: 5248: --fnd_message.set_token('PO_NUMBER', l_po_num); 5249: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message 5250: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || 5251: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5252: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || 5253: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5254: ELSE 5255: IF(l_type_lookup_code = 'BLANKET') THEN Line 5253: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5249: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message 5250: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || 5251: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5252: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || 5253: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5254: ELSE 5255: IF(l_type_lookup_code = 'BLANKET') THEN 5256: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num; -- RDP if Blanket don't display Total 5257: ELSE Line 5258: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL') 5254: ELSE 5255: IF(l_type_lookup_code = 'BLANKET') THEN 5256: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num; -- RDP if Blanket don't display Total 5257: ELSE 5258: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL') 5259: ||' '||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) 5260: || ' ' || l_currency_code || ') '; 5261: END IF; 5262: END IF; Line 5297: fnd_message.set_name('PO', l_message_name); 5293: else 5294: return; 5295: end if; 5296: 5297: fnd_message.set_name('PO', l_message_name); 5298: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5299: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5300: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' Line 5298: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5294: return; 5295: end if; 5296: 5297: fnd_message.set_name('PO', l_message_name); 5298: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5299: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5300: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); Line 5299: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5295: end if; 5296: 5297: fnd_message.set_name('PO', l_message_name); 5298: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5299: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5300: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5303: ELSE Line 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5297: fnd_message.set_name('PO', l_message_name); 5298: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5299: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5300: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5303: ELSE 5304: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5305: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')'; Line 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5298: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5299: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5300: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5303: ELSE 5304: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5305: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')'; 5306: END IF; Line 5304: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5300: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5303: ELSE 5304: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5305: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')'; 5306: END IF; 5307: 5308: END IF; Line 5305: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')'; 5301: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5302: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||') '|| fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5303: ELSE 5304: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5305: ||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')|| ' '|| TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency_code, 30))||' '||l_rel_currency_code||')'; 5306: END IF; 5307: 5308: END IF; 5309: Line 5323: fnd_message.set_name('PO', l_message_name); 5319: ELSE 5320: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5321: END IF; 5322: 5323: fnd_message.set_name('PO', l_message_name); 5324: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5325: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5326: document := fnd_message.get; 5327: Line 5324: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5320: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5321: END IF; 5322: 5323: fnd_message.set_name('PO', l_message_name); 5324: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5325: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5326: document := fnd_message.get; 5327: 5328: END GEN_NTF_FOR_BUYER_SUBJECT; Line 5325: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5321: END IF; 5322: 5323: fnd_message.set_name('PO', l_message_name); 5324: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5325: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5326: document := fnd_message.get; 5327: 5328: END GEN_NTF_FOR_BUYER_SUBJECT; 5329: Line 5326: document := fnd_message.get; 5322: 5323: fnd_message.set_name('PO', l_message_name); 5324: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5325: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5326: document := fnd_message.get; 5327: 5328: END GEN_NTF_FOR_BUYER_SUBJECT; 5329: 5330: --------------------------------------------------------- Line 5447: fnd_message.set_name('PO', l_message_name); 5443: else 5444: RETURN; 5445: end if; 5446: 5447: fnd_message.set_name('PO', l_message_name); 5448: l_msg_header := fnd_message.get; 5449: ELSIF(l_display_name IS NOT NULL) THEN 5450: l_msg_header := l_display_name; 5451: END IF; Line 5448: l_msg_header := fnd_message.get; 5444: RETURN; 5445: end if; 5446: 5447: fnd_message.set_name('PO', l_message_name); 5448: l_msg_header := fnd_message.get; 5449: ELSIF(l_display_name IS NOT NULL) THEN 5450: l_msg_header := l_display_name; 5451: END IF; 5452: --fnd_message.set_token('PO_NUMBER', l_po_num); Line 5452: --fnd_message.set_token('PO_NUMBER', l_po_num); 5448: l_msg_header := fnd_message.get; 5449: ELSIF(l_display_name IS NOT NULL) THEN 5450: l_msg_header := l_display_name; 5451: END IF; 5452: --fnd_message.set_token('PO_NUMBER', l_po_num); 5453: l_doc_hdr_info := l_msg_header || ' ' || l_po_num || ',' || l_revision_num; -- RDP changes (generating subject for Supplier Notification) 5454: 5455: ELSE 5456: select pha.segment1, Line 5480: fnd_message.set_name('PO', l_message_name); 5476: else 5477: RETURN; 5478: end if; 5479: 5480: fnd_message.set_name('PO', l_message_name); 5481: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5482: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5483: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5484: Line 5481: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5477: RETURN; 5478: end if; 5479: 5480: fnd_message.set_name('PO', l_message_name); 5481: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5482: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5483: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5484: 5485: END IF; Line 5482: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5478: end if; 5479: 5480: fnd_message.set_name('PO', l_message_name); 5481: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5482: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5483: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5484: 5485: END IF; 5486: Line 5483: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5479: 5480: fnd_message.set_name('PO', l_message_name); 5481: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5482: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5483: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5484: 5485: END IF; 5486: 5487: if(l_header_cancel = 'N') then Line 5490: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5486: 5487: if(l_header_cancel = 'N') then 5488: 5489: 5490: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5491: fnd_message.set_token('DOC',l_doc_hdr_info); 5492: fnd_message.set_token('BUYER',l_buyer_name); 5493: document := fnd_message.get; */ 5494: Line 5491: fnd_message.set_token('DOC',l_doc_hdr_info); 5487: if(l_header_cancel = 'N') then 5488: 5489: 5490: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5491: fnd_message.set_token('DOC',l_doc_hdr_info); 5492: fnd_message.set_token('BUYER',l_buyer_name); 5493: document := fnd_message.get; */ 5494: 5495: l_temp_message := l_buyer_name || ' - '; Line 5492: fnd_message.set_token('BUYER',l_buyer_name); 5488: 5489: 5490: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5491: fnd_message.set_token('DOC',l_doc_hdr_info); 5492: fnd_message.set_token('BUYER',l_buyer_name); 5493: document := fnd_message.get; */ 5494: 5495: l_temp_message := l_buyer_name || ' - '; 5496: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); Line 5493: document := fnd_message.get; */ 5489: 5490: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5491: fnd_message.set_token('DOC',l_doc_hdr_info); 5492: fnd_message.set_token('BUYER',l_buyer_name); 5493: document := fnd_message.get; */ 5494: 5495: l_temp_message := l_buyer_name || ' - '; 5496: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5497: fnd_message.set_token('DOC',l_doc_hdr_info); Line 5496: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5492: fnd_message.set_token('BUYER',l_buyer_name); 5493: document := fnd_message.get; */ 5494: 5495: l_temp_message := l_buyer_name || ' - '; 5496: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5497: fnd_message.set_token('DOC',l_doc_hdr_info); 5498: document := l_temp_message || fnd_message.get; -- RDP changes 5499: 5500: else Line 5497: fnd_message.set_token('DOC',l_doc_hdr_info); 5493: document := fnd_message.get; */ 5494: 5495: l_temp_message := l_buyer_name || ' - '; 5496: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5497: fnd_message.set_token('DOC',l_doc_hdr_info); 5498: document := l_temp_message || fnd_message.get; -- RDP changes 5499: 5500: else 5501: Line 5498: document := l_temp_message || fnd_message.get; -- RDP changes 5494: 5495: l_temp_message := l_buyer_name || ' - '; 5496: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5497: fnd_message.set_token('DOC',l_doc_hdr_info); 5498: document := l_temp_message || fnd_message.get; -- RDP changes 5499: 5500: else 5501: 5502: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); Line 5502: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5498: document := l_temp_message || fnd_message.get; -- RDP changes 5499: 5500: else 5501: 5502: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5503: fnd_message.set_token('DOC',l_doc_hdr_info); 5504: fnd_message.set_token('BUYER',l_buyer_name); 5505: document := fnd_message.get; */ 5506: Line 5503: fnd_message.set_token('DOC',l_doc_hdr_info); 5499: 5500: else 5501: 5502: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5503: fnd_message.set_token('DOC',l_doc_hdr_info); 5504: fnd_message.set_token('BUYER',l_buyer_name); 5505: document := fnd_message.get; */ 5506: 5507: l_temp_message := l_buyer_name || ' - '; Line 5504: fnd_message.set_token('BUYER',l_buyer_name); 5500: else 5501: 5502: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5503: fnd_message.set_token('DOC',l_doc_hdr_info); 5504: fnd_message.set_token('BUYER',l_buyer_name); 5505: document := fnd_message.get; */ 5506: 5507: l_temp_message := l_buyer_name || ' - '; 5508: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); Line 5505: document := fnd_message.get; */ 5501: 5502: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5503: fnd_message.set_token('DOC',l_doc_hdr_info); 5504: fnd_message.set_token('BUYER',l_buyer_name); 5505: document := fnd_message.get; */ 5506: 5507: l_temp_message := l_buyer_name || ' - '; 5508: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5509: fnd_message.set_token('DOC',l_doc_hdr_info); Line 5508: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5504: fnd_message.set_token('BUYER',l_buyer_name); 5505: document := fnd_message.get; */ 5506: 5507: l_temp_message := l_buyer_name || ' - '; 5508: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5509: fnd_message.set_token('DOC',l_doc_hdr_info); 5510: document := l_temp_message || fnd_message.get; -- RDP changes 5511: 5512: end if; Line 5509: fnd_message.set_token('DOC',l_doc_hdr_info); 5505: document := fnd_message.get; */ 5506: 5507: l_temp_message := l_buyer_name || ' - '; 5508: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5509: fnd_message.set_token('DOC',l_doc_hdr_info); 5510: document := l_temp_message || fnd_message.get; -- RDP changes 5511: 5512: end if; 5513: Line 5510: document := l_temp_message || fnd_message.get; -- RDP changes 5506: 5507: l_temp_message := l_buyer_name || ' - '; 5508: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5509: fnd_message.set_token('DOC',l_doc_hdr_info); 5510: document := l_temp_message || fnd_message.get; -- RDP changes 5511: 5512: end if; 5513: 5514: END GEN_NTF_FOR_SUP_SUBJECT; Line 5612: fnd_message.set_name('PO', l_message_name); 5608: elsif(l_type_lookup_code = 'CONTRACT') then 5609: l_message_name := 'PO_POTYPE_CNTR'; 5610: end if; 5611: 5612: fnd_message.set_name('PO', l_message_name); 5613: l_msg_header := fnd_message.get; 5614: ELSIF(l_display_name IS NOT NULL) THEN 5615: l_msg_header := l_display_name; 5616: END IF; Line 5613: l_msg_header := fnd_message.get; 5609: l_message_name := 'PO_POTYPE_CNTR'; 5610: end if; 5611: 5612: fnd_message.set_name('PO', l_message_name); 5613: l_msg_header := fnd_message.get; 5614: ELSIF(l_display_name IS NOT NULL) THEN 5615: l_msg_header := l_display_name; 5616: END IF; 5617: --fnd_message.set_token('PO_NUMBER', l_po_num); Line 5617: --fnd_message.set_token('PO_NUMBER', l_po_num); 5613: l_msg_header := fnd_message.get; 5614: ELSIF(l_display_name IS NOT NULL) THEN 5615: l_msg_header := l_display_name; 5616: END IF; 5617: --fnd_message.set_token('PO_NUMBER', l_po_num); 5618: l_document_header_info := l_msg_header || ' ' || l_po_num; 5619: 5620: ELSE 5621: select pha.type_lookup_code, Line 5642: fnd_message.set_name('PO', l_message_name); 5638: elsif(l_type_lookup_code = 'PLANNED') then 5639: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5640: end if; 5641: 5642: fnd_message.set_name('PO', l_message_name); 5643: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5644: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5645: l_document_header_info := fnd_message.get; 5646: Line 5643: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5639: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5640: end if; 5641: 5642: fnd_message.set_name('PO', l_message_name); 5643: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5644: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5645: l_document_header_info := fnd_message.get; 5646: 5647: END IF; Line 5644: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5640: end if; 5641: 5642: fnd_message.set_name('PO', l_message_name); 5643: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5644: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5645: l_document_header_info := fnd_message.get; 5646: 5647: END IF; 5648: Line 5645: l_document_header_info := fnd_message.get; 5641: 5642: fnd_message.set_name('PO', l_message_name); 5643: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5644: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5645: l_document_header_info := fnd_message.get; 5646: 5647: END IF; 5648: 5649: l_header_cancel := 'N'; Line 5666: fnd_message.set_name('PO', l_message_name); 5662: else 5663: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5664: end if; 5665: 5666: fnd_message.set_name('PO', l_message_name); 5667: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5668: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5669: document := fnd_message.get; 5670: Line 5667: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5663: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5664: end if; 5665: 5666: fnd_message.set_name('PO', l_message_name); 5667: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5668: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5669: document := fnd_message.get; 5670: 5671: END GEN_NTF_FOR_PLAN_SUBJECT; Line 5668: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5664: end if; 5665: 5666: fnd_message.set_name('PO', l_message_name); 5667: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5668: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5669: document := fnd_message.get; 5670: 5671: END GEN_NTF_FOR_PLAN_SUBJECT; 5672: Line 5669: document := fnd_message.get; 5665: 5666: fnd_message.set_name('PO', l_message_name); 5667: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5668: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5669: document := fnd_message.get; 5670: 5671: END GEN_NTF_FOR_PLAN_SUBJECT; 5672: 5673: --------------------------------------------------------- Line 5768: fnd_message.set_name('PO', l_message_name); 5764: elsif(l_type_lookup_code = 'CONTRACT') then 5765: l_message_name := 'PO_POTYPE_CNTR'; 5766: end if; 5767: 5768: fnd_message.set_name('PO', l_message_name); 5769: l_msg_header := fnd_message.get; 5770: ELSIF(l_display_name IS NOT NULL) THEN 5771: l_msg_header := l_display_name; 5772: END IF; Line 5769: l_msg_header := fnd_message.get; 5765: l_message_name := 'PO_POTYPE_CNTR'; 5766: end if; 5767: 5768: fnd_message.set_name('PO', l_message_name); 5769: l_msg_header := fnd_message.get; 5770: ELSIF(l_display_name IS NOT NULL) THEN 5771: l_msg_header := l_display_name; 5772: END IF; 5773: --fnd_message.set_token('PO_NUMBER', l_po_num); Line 5773: --fnd_message.set_token('PO_NUMBER', l_po_num); 5769: l_msg_header := fnd_message.get; 5770: ELSIF(l_display_name IS NOT NULL) THEN 5771: l_msg_header := l_display_name; 5772: END IF; 5773: --fnd_message.set_token('PO_NUMBER', l_po_num); 5774: l_document_header_info := l_msg_header || ' ' || l_po_num; 5775: 5776: ELSE 5777: select pha.type_lookup_code, Line 5798: fnd_message.set_name('PO', l_message_name); 5794: elsif(l_type_lookup_code = 'PLANNED') then 5795: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5796: end if; 5797: 5798: fnd_message.set_name('PO', l_message_name); 5799: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5800: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5801: l_document_header_info := fnd_message.get; 5802: Line 5799: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5795: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5796: end if; 5797: 5798: fnd_message.set_name('PO', l_message_name); 5799: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5800: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5801: l_document_header_info := fnd_message.get; 5802: 5803: end if; Line 5800: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5796: end if; 5797: 5798: fnd_message.set_name('PO', l_message_name); 5799: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5800: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5801: l_document_header_info := fnd_message.get; 5802: 5803: end if; 5804: Line 5801: l_document_header_info := fnd_message.get; 5797: 5798: fnd_message.set_name('PO', l_message_name); 5799: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5800: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5801: l_document_header_info := fnd_message.get; 5802: 5803: end if; 5804: 5805: l_header_cancel := 'N'; Line 5822: fnd_message.set_name('PO', l_message_name); 5818: else 5819: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5820: end if; 5821: 5822: fnd_message.set_name('PO', l_message_name); 5823: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5824: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5825: document := fnd_message.get; 5826: Line 5823: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5819: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5820: end if; 5821: 5822: fnd_message.set_name('PO', l_message_name); 5823: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5824: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5825: document := fnd_message.get; 5826: 5827: END GEN_NTF_FOR_REQ_SUBJECT; Line 5824: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5820: end if; 5821: 5822: fnd_message.set_name('PO', l_message_name); 5823: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5824: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5825: document := fnd_message.get; 5826: 5827: END GEN_NTF_FOR_REQ_SUBJECT; 5828: Line 5825: document := fnd_message.get; 5821: 5822: fnd_message.set_name('PO', l_message_name); 5823: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5824: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5825: document := fnd_message.get; 5826: 5827: END GEN_NTF_FOR_REQ_SUBJECT; 5828: 5829: /* Line 5898: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI')); 5894: if(l_header_change = 0) then -- RDP means no ADDITIONAL changes but PRORATE is required, set EXPLAIN_FYI 5895: wf_engine.SetItemAttrText ( itemtype => itemtype, 5896: itemkey => itemkey, 5897: aname => 'EXPLAIN_FYI', 5898: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI')); 5899: else 5900: wf_engine.SetItemAttrText ( itemtype => itemtype, 5901: itemkey => itemkey, 5902: aname => 'EXPLAIN_FYI', Line 6348: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 6344: end if; 6345: end if; 6346: 6347: if(l_type_lookup_code = 'PLANNED') then 6348: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 6349: elsif(l_type_lookup_code = 'BLANKET') then 6350: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6351: end if; 6352: Line 6350: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6346: 6347: if(l_type_lookup_code = 'PLANNED') then 6348: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 6349: elsif(l_type_lookup_code = 'BLANKET') then 6350: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6351: end if; 6352: 6353: if(l_header_cancel = 'N') then 6354: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); Line 6354: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6350: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6351: end if; 6352: 6353: if(l_header_cancel = 'N') then 6354: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6355: fnd_message.set_token('DOC',l_doc_hdr_info); 6356: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else Line 6355: fnd_message.set_token('DOC',l_doc_hdr_info); 6351: end if; 6352: 6353: if(l_header_cancel = 'N') then 6354: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6355: fnd_message.set_token('DOC',l_doc_hdr_info); 6356: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); Line 6356: fnd_message.set_token('BUYER',l_buyer_name); 6352: 6353: if(l_header_cancel = 'N') then 6354: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6355: fnd_message.set_token('DOC',l_doc_hdr_info); 6356: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6360: fnd_message.set_token('DOC',l_doc_hdr_info); Line 6357: l_notification_subject := fnd_message.get; 6353: if(l_header_cancel = 'N') then 6354: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6355: fnd_message.set_token('DOC',l_doc_hdr_info); 6356: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6360: fnd_message.set_token('DOC',l_doc_hdr_info); 6361: fnd_message.set_token('BUYER',l_buyer_name); Line 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6355: fnd_message.set_token('DOC',l_doc_hdr_info); 6356: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6360: fnd_message.set_token('DOC',l_doc_hdr_info); 6361: fnd_message.set_token('BUYER',l_buyer_name); 6362: l_notification_subject := fnd_message.get; 6363: end if; Line 6360: fnd_message.set_token('DOC',l_doc_hdr_info); 6356: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6360: fnd_message.set_token('DOC',l_doc_hdr_info); 6361: fnd_message.set_token('BUYER',l_buyer_name); 6362: l_notification_subject := fnd_message.get; 6363: end if; 6364: Line 6361: fnd_message.set_token('BUYER',l_buyer_name); 6357: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6360: fnd_message.set_token('DOC',l_doc_hdr_info); 6361: fnd_message.set_token('BUYER',l_buyer_name); 6362: l_notification_subject := fnd_message.get; 6363: end if; 6364: 6365: /* Line 6362: l_notification_subject := fnd_message.get; 6358: else 6359: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6360: fnd_message.set_token('DOC',l_doc_hdr_info); 6361: fnd_message.set_token('BUYER',l_buyer_name); 6362: l_notification_subject := fnd_message.get; 6363: end if; 6364: 6365: /* 6366: update po_releases_all Line 6446: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6442: end if; 6443: end if; 6444: 6445: if(l_type_lookup_code = 'STANDARD') then 6446: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6447: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 6448: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6449: elsif(l_type_lookup_code = 'BLANKET') then 6450: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; Line 6448: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6444: 6445: if(l_type_lookup_code = 'STANDARD') then 6446: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6447: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 6448: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6449: elsif(l_type_lookup_code = 'BLANKET') then 6450: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6451: elsif(l_type_lookup_code = 'CONTRACT') then 6452: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; Line 6450: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6446: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6447: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 6448: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6449: elsif(l_type_lookup_code = 'BLANKET') then 6450: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6451: elsif(l_type_lookup_code = 'CONTRACT') then 6452: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6453: elsif(l_type_lookup_code = 'PLANNED') then 6454: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; Line 6452: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6448: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6449: elsif(l_type_lookup_code = 'BLANKET') then 6450: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6451: elsif(l_type_lookup_code = 'CONTRACT') then 6452: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6453: elsif(l_type_lookup_code = 'PLANNED') then 6454: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6455: end if; 6456: Line 6454: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6450: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6451: elsif(l_type_lookup_code = 'CONTRACT') then 6452: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6453: elsif(l_type_lookup_code = 'PLANNED') then 6454: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6455: end if; 6456: 6457: if(l_header_cancel = 'N') then 6458: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); Line 6458: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6454: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6455: end if; 6456: 6457: if(l_header_cancel = 'N') then 6458: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6459: fnd_message.set_token('DOC',l_doc_hdr_info); 6460: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else Line 6459: fnd_message.set_token('DOC',l_doc_hdr_info); 6455: end if; 6456: 6457: if(l_header_cancel = 'N') then 6458: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6459: fnd_message.set_token('DOC',l_doc_hdr_info); 6460: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); Line 6460: fnd_message.set_token('BUYER',l_buyer_name); 6456: 6457: if(l_header_cancel = 'N') then 6458: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6459: fnd_message.set_token('DOC',l_doc_hdr_info); 6460: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6464: fnd_message.set_token('DOC',l_doc_hdr_info); Line 6461: l_notification_subject := fnd_message.get; 6457: if(l_header_cancel = 'N') then 6458: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6459: fnd_message.set_token('DOC',l_doc_hdr_info); 6460: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6464: fnd_message.set_token('DOC',l_doc_hdr_info); 6465: fnd_message.set_token('BUYER',l_buyer_name); Line 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6459: fnd_message.set_token('DOC',l_doc_hdr_info); 6460: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6464: fnd_message.set_token('DOC',l_doc_hdr_info); 6465: fnd_message.set_token('BUYER',l_buyer_name); 6466: l_notification_subject := fnd_message.get; 6467: end if; Line 6464: fnd_message.set_token('DOC',l_doc_hdr_info); 6460: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6464: fnd_message.set_token('DOC',l_doc_hdr_info); 6465: fnd_message.set_token('BUYER',l_buyer_name); 6466: l_notification_subject := fnd_message.get; 6467: end if; 6468: Line 6465: fnd_message.set_token('BUYER',l_buyer_name); 6461: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6464: fnd_message.set_token('DOC',l_doc_hdr_info); 6465: fnd_message.set_token('BUYER',l_buyer_name); 6466: l_notification_subject := fnd_message.get; 6467: end if; 6468: 6469: /* Line 6466: l_notification_subject := fnd_message.get; 6462: else 6463: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6464: fnd_message.set_token('DOC',l_doc_hdr_info); 6465: fnd_message.set_token('BUYER',l_buyer_name); 6466: l_notification_subject := fnd_message.get; 6467: end if; 6468: 6469: /* 6470: update po_headers_all Line 8762: fnd_message.set_name('ICX', 'ICX_POR_WF_NOTIF_NO_USER'); 8758: itemkey => p_itemkey, 8759: aname => 'FORWARD_TO_USERNAME_RESPONSE'); 8760: 8761: if(l_forwardTo is null) then 8762: fnd_message.set_name('ICX', 'ICX_POR_WF_NOTIF_NO_USER'); 8763: app_exception.raise_exception; 8764: end if; 8765: end if; 8766: