APPS.PO_CHANGEORDERWF_PVT dependencies on FND_MESSAGE

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

626: l_can_doc_subtype po_document_types_all.document_subtype%TYPE;
627: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
628: l_return_status varchar2(1);
629: x_progress varchar2(3);
630: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');
631: l_hdr_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_HDR_ERR');
632: cursor l_cancel_ship_csr(grp_id number) is
633: select
634: change_request_id,

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

627: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
628: l_return_status varchar2(1);
629: x_progress varchar2(3);
630: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');
631: l_hdr_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_HDR_ERR');
632: cursor l_cancel_ship_csr(grp_id number) is
633: select
634: change_request_id,
635: document_header_id,

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

1012: aname => 'ORG_ID');
1013:
1014: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1015:
1016: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');
1017: l_acceptance_result := fnd_message.get;
1018:
1019: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1020: itemkey => itemkey,

Line 1017: l_acceptance_result := fnd_message.get;

1013:
1014: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1015:
1016: fnd_message.set_name ('PO','PO_WF_REJECTED_VALUE');
1017: l_acceptance_result := fnd_message.get;
1018:
1019: l_document_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
1020: itemkey => itemkey,
1021: aname => 'DOCUMENT_ID');

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

1075: IF (l_acceptance_result is NULL) THEN
1076: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
1077: itemkey => itemkey,
1078: aname => 'ACCEPTANCE_RESULT',
1079: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_REJ') );
1080: END IF;
1081:
1082: if (l_document_type_code <> 'RELEASE') then
1083:

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

1565: pla.quantity OLD_QTY,
1566: to_number(null) NEW_QTY,
1567: pla.unit_price OLD_PRICE,
1568: pcr.new_price NEW_PRICE,
1569: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),
1570: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1571: pla.item_description ITEM_DESCRIPTION,
1572: pla.unit_meas_lookup_code UOM,
1573: null SHIP_TO_LOCATION,

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

1566: to_number(null) NEW_QTY,
1567: pla.unit_price OLD_PRICE,
1568: pcr.new_price NEW_PRICE,
1569: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),
1570: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1571: pla.item_description ITEM_DESCRIPTION,
1572: pla.unit_meas_lookup_code UOM,
1573: null SHIP_TO_LOCATION,
1574: pcr.ACTION_TYPE ACTION_CODE,

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

1605: plla.quantity OLD_QTY,
1606: pcr.new_quantity NEW_QTY,
1607: 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,
1608: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE,
1609: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1610: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1611: pla.item_description ITEM_DESCRIPTION,
1612: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1613: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,

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

1606: pcr.new_quantity NEW_QTY,
1607: 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,
1608: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE,
1609: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1610: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1611: pla.item_description ITEM_DESCRIPTION,
1612: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1613: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
1614: pcr.ACTION_TYPE ACTION_CODE,

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

1651: plla.quantity OLD_QTY,
1652: pcr.new_quantity NEW_QTY,
1653: 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,
1654: 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,
1655: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1656: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1657: pla.item_description ITEM_DESCRIPTION,
1658: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1659: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,

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

1652: pcr.new_quantity NEW_QTY,
1653: 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,
1654: 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,
1655: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION',
1656: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE,
1657: pla.item_description ITEM_DESCRIPTION,
1658: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1659: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
1660: pcr.ACTION_TYPE ACTION_CODE,

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

1658: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM,
1659: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION,
1660: pcr.ACTION_TYPE ACTION_CODE,
1661: pcr.REQUEST_REASON REASON,
1662: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT
1663: from
1664: po_change_requests pcr,
1665: po_lines_archive_all pla,
1666: po_line_locations_archive_all plla,

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

1765: from po_headers_all
1766: where po_header_id = l_header_id;
1767:
1768: if(l_type_lookup_code = 'STANDARD') then
1769: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1770: elsif(l_type_lookup_code = 'PLANNED') then
1771: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1772: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1773: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');

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

1767:
1768: if(l_type_lookup_code = 'STANDARD') then
1769: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1770: elsif(l_type_lookup_code = 'PLANNED') then
1771: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1772: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1773: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1774: elsif(l_type_lookup_code = 'BLANKET') then
1775: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');

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

1769: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
1770: elsif(l_type_lookup_code = 'PLANNED') then
1771: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1772: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1773: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1774: elsif(l_type_lookup_code = 'BLANKET') then
1775: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
1776: elsif(l_type_lookup_code = 'CONTRACT') then
1777: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');

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

1771: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO');
1772: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
1773: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1774: elsif(l_type_lookup_code = 'BLANKET') then
1775: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
1776: elsif(l_type_lookup_code = 'CONTRACT') then
1777: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');
1778: else
1779: l_document_type := 'Error';

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

1773: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE');
1774: elsif(l_type_lookup_code = 'BLANKET') then
1775: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET');
1776: elsif(l_type_lookup_code = 'CONTRACT') then
1777: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR');
1778: else
1779: l_document_type := 'Error';
1780: end if;
1781:

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

1812: where pr.po_release_id = l_release_id
1813: and pr.po_header_id = ph.po_header_id;
1814:
1815: if(l_type_lookup_code = 'BLANKET') then
1816: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');
1817: elsif(l_type_lookup_code = 'PLANNED') then
1818: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');
1819: else
1820: l_document_type := 'Error';

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

1814:
1815: if(l_type_lookup_code = 'BLANKET') then
1816: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL');
1817: elsif(l_type_lookup_code = 'PLANNED') then
1818: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL');
1819: else
1820: l_document_type := 'Error';
1821: end if;
1822:

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

1867:
1868: if(l_release_id is null) then
1869: l_document := l_base_url_tag||
1870: '
1871: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')
1872: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
1873: l_po_currency||') '||
1874: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
1875: ||')

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

1889:
1890:
1891:
1892:
1894:
1895:
1896:
1897:

1894:

1895:
1896:
1897:
1899:

1912: '
1913:

1914:
1915:
1917:
1919:
1920:

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

1920:
1921:
1922:

1923:
1925:
1927:
1928:

1893: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||'	'||l_supplier_name||'
Line 1898: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||'	'||l_supplier_name||'
1898: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||'	'; 1900: 1901: if(l_sup_address_line1 is not null) then 1902: l_document := l_document || l_sup_address_line1||' '; Line 1916: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||'
1916: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||'	'||l_fob|| 1918: '
1924: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||'	'||l_carrier|| 1926: '

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

1930:
1931:
1932:
1933:
1935:
1937:
1938:

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

1937:
1938:
1939:

1940:
1942:

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

'||l_order_date|| 1936: '

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

1943: '|| 1944: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| 1945: l_ship_city||', '||l_ship_state||' '||l_ship_zip Line 1982: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 1978: lc_split; 1979: close l_po_chg_req_csr; 1980: if(lc_line_num is not null) then 1981: l_document := ''|| 1982: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 1983: ' '; 1984: l_document := l_document||''|| NL; 1985: l_document:= l_document||' '|| 1986: '' Line 1987: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 1983: ' '; 1984: l_document := l_document||''|| NL; 1985: l_document:= l_document||'' || NL; 1989: l_document := l_document || ''|| NL; 1990: l_document:= l_document||'' || NL; 1989: l_document := l_document || ''|| NL; 1990: l_document:= l_document||'' || NL; 1994: l_document := l_document || ' '|| 1986: '' 1987: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 1988: l_document := l_document || ' '|| 1991: '' Line 1992: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 1988: l_document := l_document || ' '|| 1991: '' 1992: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 1993: l_document := l_document || ' ' || NL; 1995: l_document := l_document ||' 1996: Line 1998: 1994: l_document := l_document || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' ' || NL; 1995: l_document := l_document ||' 1996: 1997: 1998: 1999: 2000: 2001: 2002: Line 1999: 1995: l_document := l_document ||' 1996: '||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')||' 1997: 1998: 1999: 2000: 2001: 2002: 2003: '; Line 2000: 1996: '||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')||' 1997: 1998: 1999: 2000: 2001: 2002: 2003: '; 2004: if (l_type_lookup_code = 'BLANKET') then Line 2001: 1997: 1998: 1999: 2000: 2001: 2002: 2003: '; 2004: if (l_type_lookup_code = 'BLANKET') then 2005: l_document := l_document || ' '; Line 2002: 1998: 1999: 2000: 2001: 2002: 2003: '; 2004: if (l_type_lookup_code = 'BLANKET') then 2005: l_document := l_document || ' '; 2006: else Line 2003: '; 1999: 2000: 2001: 2002: 2003: '; 2004: if (l_type_lookup_code = 'BLANKET') then 2005: l_document := l_document || ' '; 2006: else 2007: l_document := l_document || ' '; Line 2005: l_document := l_document || ' '; 2001: 2002: 2003: '; 2004: if (l_type_lookup_code = 'BLANKET') then 2005: l_document := l_document || ' '; 2006: else 2007: l_document := l_document || ' '; 2008: end if; 2009: l_document := l_document || Line 2007: l_document := l_document || ' '; 2003: '; 2004: if (l_type_lookup_code = 'BLANKET') then 2005: l_document := l_document || ' '; 2006: else 2007: l_document := l_document || ' '; 2008: end if; 2009: l_document := l_document || 2010: ' 2011: Line 2010: ' 2006: else 2007: l_document := l_document || ' '; 2008: end if; 2009: l_document := l_document || 2010: ' 2011: 2012: 2013: 2014: Line 2011: 2007: l_document := l_document || ' '; 2008: end if; 2009: l_document := l_document || 2010: ' 2011: 2012: 2013: 2014: 2015: Line 2012: 2008: end if; 2009: l_document := l_document || 2010: ' 2011: 2012: 2013: 2014: 2015: 2016: Line 2013: 2009: l_document := l_document || 2010: ' 2011: 2012: 2013: 2014: 2015: 2016: 2017: '; Line 2014: 2010: ' 2011: 2012: 2013: 2014: 2015: 2016: 2017: '; 2018: Line 2015: 2011: 2012: 2013: 2014: 2015: 2016: 2017: '; 2018: 2019: WF_NOTIFICATION.WriteToClob(document,l_document); Line 2267: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 2263: fetch l_header_changes_csr into l_additional_changes; 2264: close l_header_changes_csr; 2265: 2266: if(l_additional_changes is not null) then 2267: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 2268: ' `  '||l_additional_changes||' '; 2269: WF_NOTIFICATION.WriteToClob(document,l_document); 2270: end if; 2271: Line 2273: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2269: WF_NOTIFICATION.WriteToClob(document,l_document); 2270: end if; 2271: 2272: else 2273: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2274: fnd_message.set_token('DOC',l_document_type); 2275: l_document := fnd_message.get; 2276: WF_NOTIFICATION.WriteToClob(document,l_document); 2277: end if; Line 2274: fnd_message.set_token('DOC',l_document_type); 2270: end if; 2271: 2272: else 2273: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2274: fnd_message.set_token('DOC',l_document_type); 2275: l_document := fnd_message.get; 2276: WF_NOTIFICATION.WriteToClob(document,l_document); 2277: end if; 2278: exception when others then Line 2275: l_document := fnd_message.get; 2271: 2272: else 2273: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 2274: fnd_message.set_token('DOC',l_document_type); 2275: l_document := fnd_message.get; 2276: WF_NOTIFICATION.WriteToClob(document,l_document); 2277: end if; 2278: exception when others then 2279: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); Line 2396: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 2392: pla.quantity OLD_QTY, 2393: to_number(null) NEW_QTY, 2394: pla.unit_price OLD_PRICE, 2395: pcr.new_price NEW_PRICE, 2396: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 2397: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2398: pla.item_description ITEM_DESCRIPTION, 2399: pla.unit_meas_lookup_code UOM, 2400: null SHIP_TO_LOCATION, Line 2397: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2393: to_number(null) NEW_QTY, 2394: pla.unit_price OLD_PRICE, 2395: pcr.new_price NEW_PRICE, 2396: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 2397: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2398: pla.item_description ITEM_DESCRIPTION, 2399: pla.unit_meas_lookup_code UOM, 2400: null SHIP_TO_LOCATION, 2401: pcr.ACTION_TYPE ACTION_CODE, Line 2438: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2434: plla.quantity OLD_QTY, 2435: pcr.new_quantity NEW_QTY, 2436: 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, 2437: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE, 2438: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2439: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2440: pla.item_description ITEM_DESCRIPTION, 2441: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2442: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 2439: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2435: pcr.new_quantity NEW_QTY, 2436: 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, 2437: decode(pla.matching_basis,'AMOUNT',DECODE(plla.payment_type,'RATE',pcr.new_price,pcr.new_amount),pcr.new_price) NEW_PRICE, 2438: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2439: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2440: pla.item_description ITEM_DESCRIPTION, 2441: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2442: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 2443: pcr.ACTION_TYPE ACTION_CODE, Line 2487: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2483: plla.quantity OLD_QTY, 2484: pcr.new_quantity NEW_QTY, 2485: 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, 2486: 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, 2487: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2488: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2489: pla.item_description ITEM_DESCRIPTION, 2490: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2491: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 2488: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2484: pcr.new_quantity NEW_QTY, 2485: 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, 2486: 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, 2487: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 2488: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 2489: pla.item_description ITEM_DESCRIPTION, 2490: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2491: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 2492: pcr.ACTION_TYPE ACTION_CODE, Line 2494: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 2490: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 2491: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 2492: pcr.ACTION_TYPE ACTION_CODE, 2493: pcr.REQUEST_REASON REASON, 2494: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 2495: from 2496: po_change_requests pcr, 2497: po_lines_archive_all pla, 2498: po_line_locations_archive_all plla, Line 2602: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2598: from po_headers_all 2599: where po_header_id = l_header_id; 2600: 2601: if(l_type_lookup_code = 'STANDARD') then 2602: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2603: elsif(l_type_lookup_code = 'PLANNED') then 2604: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2605: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2606: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); Line 2604: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2600: 2601: if(l_type_lookup_code = 'STANDARD') then 2602: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2603: elsif(l_type_lookup_code = 'PLANNED') then 2604: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2605: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2606: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2607: elsif(l_type_lookup_code = 'BLANKET') then 2608: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); Line 2606: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2602: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 2603: elsif(l_type_lookup_code = 'PLANNED') then 2604: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2605: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2606: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2607: elsif(l_type_lookup_code = 'BLANKET') then 2608: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2609: elsif(l_type_lookup_code = 'CONTRACT') then 2610: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); Line 2608: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2604: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 2605: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 2606: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2607: elsif(l_type_lookup_code = 'BLANKET') then 2608: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2609: elsif(l_type_lookup_code = 'CONTRACT') then 2610: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 2611: else 2612: l_document_type := 'Error'; Line 2610: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 2606: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 2607: elsif(l_type_lookup_code = 'BLANKET') then 2608: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 2609: elsif(l_type_lookup_code = 'CONTRACT') then 2610: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 2611: else 2612: l_document_type := 'Error'; 2613: end if; 2614: Line 2649: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 2645: where pr.po_release_id = l_release_id 2646: and pr.po_header_id = ph.po_header_id; 2647: 2648: if(l_type_lookup_code = 'BLANKET') then 2649: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 2650: elsif(l_type_lookup_code = 'PLANNED') then 2651: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 2652: else 2653: l_document_type := 'Error'; Line 2651: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 2647: 2648: if(l_type_lookup_code = 'BLANKET') then 2649: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 2650: elsif(l_type_lookup_code = 'PLANNED') then 2651: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 2652: else 2653: l_document_type := 'Error'; 2654: end if; 2655: Line 2703: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 2699: 2700: if(l_release_id is null) then 2701: l_document :=l_base_url_tag|| 2702: ' 2703: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 2704: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2705: l_po_currency||') '|| 2706: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2707: ||') '; Line 2704: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2700: if(l_release_id is null) then 2701: l_document :=l_base_url_tag|| 2702: ' 2703: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 2704: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2705: l_po_currency||') '|| 2706: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2707: ||') '; 2708: else Line 2711: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 2707: ||') '; 2708: else 2709: l_document :=l_base_url_tag|| 2710: ' 2711: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 2712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2713: l_po_currency||') '|| 2714: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2715: ||') '; Line 2712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2708: else 2709: l_document :=l_base_url_tag|| 2710: ' 2711: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 2712: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 2713: l_po_currency||') '|| 2714: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 2715: ||') '; 2716: end if; Line 2725: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' 2721: 2762: '||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')||' 2722: 2723: 2724: 2726: 2727: 2728: 2729: 2726: 2727: 2728: 2729: 2731: 2744: ' 2745: 2746: 2747: 2749: 2751: 2752: Line 2756: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' 2752: 2753: 2754: 2755: 2757: 2759: 2760: 2725: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||' Line 2730: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_supplier_name||' 2730: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '; 2732: 2733: if(l_sup_address_line1 is not null) then 2734: l_document := l_document || l_sup_address_line1||' '; Line 2748: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' 2748: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob|| 2750: ' 2756: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier|| 2758: ' Line 2766: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' 2763: 2764: 2765: 2767: 2769: 2770: Line 2773: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 2769: 2770: 2771: 2772: 2774: 2766: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date|| 2768: ' 2773: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 2775: '|| 2776: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| 2777: l_ship_city||', '||l_ship_state||' '||l_ship_zip Line 2814: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 2810: lc_split; 2811: close l_po_chg_req_csr; 2812: if(lc_line_num is not null) then 2813: l_document := ''|| 2814: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 2815: ' '; 2816: l_document := l_document||''|| NL; 2817: l_document:= l_document||' '|| 2818: '' Line 2819: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 2815: ' '; 2816: l_document := l_document||''|| NL; 2817: l_document:= l_document||'' || NL; 2821: l_document := l_document || ''|| NL; 2822: l_document:= l_document||'' || NL; 2821: l_document := l_document || ''|| NL; 2822: l_document:= l_document||'' || NL; 2826: l_document := l_document || ' '|| 2818: '' 2819: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 2820: l_document := l_document || ' '|| 2823: '' Line 2824: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 2820: l_document := l_document || ' '|| 2823: '' 2824: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 2825: l_document := l_document || ' ' || NL; 2827: l_document := l_document ||' 2828: Line 2830: 2826: l_document := l_document || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' ' || NL; 2827: l_document := l_document ||' 2828: 2829: 2830: 2831: 2832: 2833: 2834: Line 2831: 2827: l_document := l_document ||' 2828: '||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')||' 2829: 2830: 2831: 2832: 2833: 2834: 2835: Line 2832: 2828: '||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')||' 2829: 2830: 2831: 2832: 2833: 2834: 2835: 2836: Line 2833: 2829: 2830: 2831: 2832: 2833: 2834: 2835: 2836: 2837: Line 2834: 2830: 2831: 2832: 2833: 2834: 2835: 2836: 2837: 2838: Line 2835: 2831: 2832: 2833: 2834: 2835: 2836: 2837: 2838: 2839: Line 2836: 2832: 2833: 2834: 2835: 2836: 2837: 2838: 2839: 2840: Line 2837: 2833: 2834: 2835: 2836: 2837: 2838: 2839: 2840: 2841: Line 2838: 2834: 2835: 2836: 2837: 2838: 2839: 2840: 2841: 2842: Line 2839: 2835: 2836: 2837: 2838: 2839: 2840: 2841: 2842: 2843: Line 2840: 2836: 2837: 2838: 2839: 2840: 2841: 2842: 2843: 2844: '; Line 2841: 2837: 2838: 2839: 2840: 2841: 2842: 2843: 2844: '; 2845: Line 2842: 2838: 2839: 2840: 2841: 2842: 2843: 2844: '; 2845: 2846: WF_NOTIFICATION.WriteToClob(document,l_document); Line 3087: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 3083: fetch l_header_changes_csr into l_additional_changes; 3084: close l_header_changes_csr; 3085: 3086: if(l_additional_changes is not null) then 3087: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 3088: ' `  '||l_additional_changes||' '; 3089: WF_NOTIFICATION.WriteToClob(document,l_document); 3090: end if; 3091: Line 3093: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3089: WF_NOTIFICATION.WriteToClob(document,l_document); 3090: end if; 3091: 3092: else 3093: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3094: fnd_message.set_token('DOC',l_document_type); 3095: l_document := fnd_message.get; 3096: WF_NOTIFICATION.WriteToClob(document,l_document); 3097: end if; Line 3094: fnd_message.set_token('DOC',l_document_type); 3090: end if; 3091: 3092: else 3093: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3094: fnd_message.set_token('DOC',l_document_type); 3095: l_document := fnd_message.get; 3096: WF_NOTIFICATION.WriteToClob(document,l_document); 3097: end if; 3098: exception when others then Line 3095: l_document := fnd_message.get; 3091: 3092: else 3093: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 3094: fnd_message.set_token('DOC',l_document_type); 3095: l_document := fnd_message.get; 3096: WF_NOTIFICATION.WriteToClob(document,l_document); 3097: end if; 3098: exception when others then 3099: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); Line 3219: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 3215: pla.quantity OLD_QTY, 3216: to_number(null) NEW_QTY, 3217: pla.unit_price OLD_PRICE, 3218: pcr.new_price NEW_PRICE, 3219: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 3220: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3221: pla.item_description ITEM_DESCRIPTION, 3222: pla.unit_meas_lookup_code UOM, 3223: null SHIP_TO_LOCATION, Line 3220: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3216: to_number(null) NEW_QTY, 3217: pla.unit_price OLD_PRICE, 3218: pcr.new_price NEW_PRICE, 3219: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'), 3220: 'CANCELLATION',fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3221: pla.item_description ITEM_DESCRIPTION, 3222: pla.unit_meas_lookup_code UOM, 3223: null SHIP_TO_LOCATION, 3224: pcr.ACTION_TYPE ACTION_CODE, Line 3256: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3252: plla.quantity OLD_QTY, 3253: pcr.new_quantity NEW_QTY, 3254: plla.price_override OLD_PRICE, 3255: pcr.new_price NEW_PRICE, 3256: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3257: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3258: pla.item_description ITEM_DESCRIPTION, 3259: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3260: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 3257: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3253: pcr.new_quantity NEW_QTY, 3254: plla.price_override OLD_PRICE, 3255: pcr.new_price NEW_PRICE, 3256: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3257: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3258: pla.item_description ITEM_DESCRIPTION, 3259: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3260: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3261: pcr.ACTION_TYPE ACTION_CODE, Line 3299: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3295: plla.quantity OLD_QTY, 3296: pcr.new_quantity NEW_QTY, 3297: plla.price_override OLD_PRICE, 3298: pcr.new_price NEW_PRICE, 3299: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3300: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3301: pla.item_description ITEM_DESCRIPTION, 3302: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3303: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 3300: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3296: pcr.new_quantity NEW_QTY, 3297: plla.price_override OLD_PRICE, 3298: pcr.new_price NEW_PRICE, 3299: decode(pcr.ACTION_TYPE,'MODIFICATION',fnd_message.get_string('PO','PO_WF_NOTIF_CHANGE'),'CANCELLATION', 3300: fnd_message.get_string('PO','PO_WF_NOTIF_CANCEL'),'Error') ACTION_TYPE, 3301: pla.item_description ITEM_DESCRIPTION, 3302: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3303: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3304: pcr.ACTION_TYPE ACTION_CODE, Line 3306: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 3302: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3303: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3304: pcr.ACTION_TYPE ACTION_CODE, 3305: pcr.REQUEST_REASON REASON, 3306: fnd_message.get_string('PO','PO_WF_NOTIF_YES') SPLIT 3307: from 3308: po_change_requests pcr, 3309: po_lines_archive_all pla, 3310: po_line_locations_archive_all plla, Line 3363: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'), 3359: plla.quantity OLD_QTY, 3360: to_number(null) NEW_QTY, 3361: plla.price_override OLD_PRICE, 3362: to_number(null) NEW_PRICE, 3363: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'), 3364: 'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3365: pla.item_description ITEM_DESCRIPTION, 3366: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3367: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 3364: 'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3360: to_number(null) NEW_QTY, 3361: plla.price_override OLD_PRICE, 3362: to_number(null) NEW_PRICE, 3363: decode(pa.accepted_flag,'Y',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPT'), 3364: 'N',fnd_message.get_string('PO','PO_WF_NOTIF_REJECT'),'NA') ACTION_TYPE, 3365: pla.item_description ITEM_DESCRIPTION, 3366: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3367: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3368: pa.note NOTE Line 3407: 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, 3403: plla.quantity OLD_QTY, 3404: to_number(null) NEW_QTY, 3405: plla.price_override OLD_PRICE, 3406: to_number(null) NEW_PRICE, 3407: 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, 3408: pla.item_description ITEM_DESCRIPTION, 3409: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 3410: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 3411: pa.NOTE NOTE Line 3519: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3515: from po_headers_all 3516: where po_header_id = l_header_id; 3517: 3518: if(l_type_lookup_code = 'STANDARD') then 3519: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3520: elsif(l_type_lookup_code = 'PLANNED') then 3521: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3522: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3523: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); Line 3521: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3517: 3518: if(l_type_lookup_code = 'STANDARD') then 3519: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3520: elsif(l_type_lookup_code = 'PLANNED') then 3521: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3522: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3523: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3524: elsif(l_type_lookup_code = 'BLANKET') then 3525: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); Line 3523: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3519: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO'); 3520: elsif(l_type_lookup_code = 'PLANNED') then 3521: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3522: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3523: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3524: elsif(l_type_lookup_code = 'BLANKET') then 3525: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3526: elsif(l_type_lookup_code = 'CONTRACT') then 3527: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); Line 3525: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3521: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO'); 3522: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 3523: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3524: elsif(l_type_lookup_code = 'BLANKET') then 3525: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3526: elsif(l_type_lookup_code = 'CONTRACT') then 3527: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 3528: else 3529: l_document_type := 'Error'; Line 3527: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 3523: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE'); 3524: elsif(l_type_lookup_code = 'BLANKET') then 3525: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET'); 3526: elsif(l_type_lookup_code = 'CONTRACT') then 3527: l_document_type := fnd_message.get_string('PO','PO_POTYPE_CNTR'); 3528: else 3529: l_document_type := 'Error'; 3530: end if; 3531: Line 3572: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 3568: where pr.po_release_id = l_release_id 3569: and pr.po_header_id = ph.po_header_id; 3570: 3571: if(l_type_lookup_code = 'BLANKET') then 3572: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 3573: elsif(l_type_lookup_code = 'PLANNED') then 3574: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 3575: else 3576: l_document_type := 'Error'; Line 3574: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 3570: 3571: if(l_type_lookup_code = 'BLANKET') then 3572: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL'); 3573: elsif(l_type_lookup_code = 'PLANNED') then 3574: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL'); 3575: else 3576: l_document_type := 'Error'; 3577: end if; 3578: Line 3632: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 3628: 3629: if(l_release_id is null) then 3630: l_document :=l_base_url_tag|| 3631: ' 3632: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 3633: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3634: l_po_currency||') '|| 3635: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 3636: ||') '; */ Line 3633: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3629: if(l_release_id is null) then 3630: l_document :=l_base_url_tag|| 3631: ' 3632: '||l_document_type||' '||l_po_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV') 3633: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3634: l_po_currency||') '|| 3635: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 3636: ||') '; */ 3637: /* Line 3640: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3636: ||') '; */ 3637: /* 3638: if(l_acc_req_flag <> 'Y') then 3639: l_document := l_document || 3640: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3641: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3642: end if; */ 3643: /* 3644: else Line 3641: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3637: /* 3638: if(l_acc_req_flag <> 'Y') then 3639: l_document := l_document || 3640: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3641: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3642: end if; */ 3643: /* 3644: else 3645: l_document :=l_base_url_tag|| Line 3647: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 3643: /* 3644: else 3645: l_document :=l_base_url_tag|| 3646: ' 3647: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 3648: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3649: l_rel_currency||') '|| 3650: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 3651: ||') '; */ Line 3648: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3644: else 3645: l_document :=l_base_url_tag|| 3646: ' 3647: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 3648: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 3649: l_rel_currency||') '|| 3650: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 3651: ||') '; */ 3652: /* Line 3655: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3651: ||') '; */ 3652: /* 3653: if(l_acc_req_flag <> 'Y') then 3654: l_document := l_document || 3655: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3656: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3657: end if;*/ 3658: /* 3659: end if; Line 3656: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3652: /* 3653: if(l_acc_req_flag <> 'Y') then 3654: l_document := l_document || 3655: '- '||fnd_message.get_string('PO','PO_WF_NOTIF_NUM_OF_CHN')||' - '|| 3656: l_num_of_changes||' '||fnd_message.get_string('PO','PO_WF_NOTIF_CANCELLED')||' - '||l_num_of_cancels||' '; 3657: end if;*/ 3658: /* 3659: end if; 3660: Line 3668: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' 3664: 3705: '||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')||' 3665: 3666: 3667: 3669: 3670: 3671: 3672: 3669: 3670: 3671: 3672: 3674: 3687: ' 3688: 3689: 3690: 3692: 3694: 3695: Line 3699: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' 3695: 3696: 3697: 3698: 3700: 3702: 3703: 3668: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||' Line 3673: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_supplier_name||' 3673: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '; 3675: 3676: if(l_sup_address_line1 is not null) then 3677: l_document := l_document || l_sup_address_line1||' '; Line 3691: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' 3691: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob|| 3693: ' 3699: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier|| 3701: ' Line 3709: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' 3706: 3707: 3708: 3710: 3712: 3713: Line 3716: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 3712: 3713: 3714: 3715: 3717: 3709: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date|| 3711: ' 3716: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 3718: '|| 3719: l_ship_addr_l1||' '||l_ship_addr_l2||' '||l_ship_addr_l3||' '|| 3720: l_ship_city||', '||l_ship_state||' '||l_ship_zip Line 3752: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3748: lc_ship_to_location, 3749: lc_reason; 3750: close l_po_ack_csr; 3751: if(lc_line_num is not null) then 3752: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3753: 3754: 3755: 3756: Line 3755: 3751: if(lc_line_num is not null) then 3752: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3753: '||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')||' 3754: 3755: 3756: 3757: 3758: 3759: Line 3756: 3752: l_document := ''||fnd_message.get_string('PO','PO_WF_NOTIF_ACK_RESPONSE')||' 3753: '||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')||' 3754: 3755: 3756: 3757: 3758: 3759: 3760: Line 3757: 3753: '||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')||' 3754: 3755: 3756: 3757: 3758: 3759: 3760: 3761: Line 3758: 3754: 3755: 3756: 3757: 3758: 3759: 3760: 3761: 3762: Line 3759: 3755: 3756: 3757: 3758: 3759: 3760: 3761: 3762: 3763: Line 3760: 3756: 3757: 3758: 3759: 3760: 3761: 3762: 3763: 3764: Line 3761: 3757: 3758: 3759: 3760: 3761: 3762: 3763: 3764: 3765: Line 3762: 3758: 3759: 3760: 3761: 3762: 3763: 3764: 3765: 3766: Line 3763: 3759: 3760: 3761: 3762: 3763: 3764: 3765: 3766: 3767: Line 3764: 3760: 3761: 3762: 3763: 3764: 3765: 3766: 3767: 3768: '; Line 3765: 3761: 3762: 3763: 3764: 3765: 3766: 3767: 3768: '; 3769: Line 3766: 3762: 3763: 3764: 3765: 3766: 3767: 3768: '; 3769: 3770: WF_NOTIFICATION.WriteToClob(document,l_document); Line 3878: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 3874: lc_split; 3875: close l_po_chg_req_csr; 3876: if(lc_line_num is not null) then 3877: l_document := ''|| 3878: fnd_message.get_string('PO', 'PO_WF_NOTIF_CH_CA_REQ')|| 3879: ' '; 3880: 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; 3881: l_document:= l_document||' '|| 3882: '' Line 3883: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 3879: ' '; 3880: l_document := l_document||''|| NL; 3881: l_document:= l_document||'' || NL; 3885: l_document := l_document || ''|| NL; 3886: l_document:= l_document||'' || NL; 3885: l_document := l_document || ''|| NL; 3886: l_document:= l_document||'' || NL; 3890: l_document := l_document || ' '|| 3882: '' 3883: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 3884: l_document := l_document || ' '|| 3887: '' Line 3888: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 3884: l_document := l_document || ' '|| 3887: '' 3888: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 3889: l_document := l_document || ' ' || NL; 3891: l_document := l_document ||' 3892: Line 3894: 3890: l_document := l_document || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' ' || NL; 3891: l_document := l_document ||' 3892: 3893: 3894: 3895: 3896: 3897: 3898: Line 3895: 3891: l_document := l_document ||' 3892: '||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')||' 3893: 3894: 3895: 3896: 3897: 3898: 3899: Line 3896: 3892: '||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')||' 3893: 3894: 3895: 3896: 3897: 3898: 3899: 3900: Line 3897: 3893: 3894: 3895: 3896: 3897: 3898: 3899: 3900: 3901: Line 3898: 3894: 3895: 3896: 3897: 3898: 3899: 3900: 3901: 3902: Line 3899: 3895: 3896: 3897: 3898: 3899: 3900: 3901: 3902: 3903: Line 3900: 3896: 3897: 3898: 3899: 3900: 3901: 3902: 3903: 3904: Line 3901: 3897: 3898: 3899: 3900: 3901: 3902: 3903: 3904: 3905: Line 3902: 3898: 3899: 3900: 3901: 3902: 3903: 3904: 3905: 3906: Line 3903: 3899: 3900: 3901: 3902: 3903: 3904: 3905: 3906: 3907: Line 3904: 3900: 3901: 3902: 3903: 3904: 3905: 3906: 3907: 3908: '; Line 3905: 3901: 3902: 3903: 3904: 3905: 3906: 3907: 3908: '; 3909: Line 3906: 3902: 3903: 3904: 3905: 3906: 3907: 3908: '; 3909: 3910: WF_NOTIFICATION.WriteToClob(document,l_document); Line 4161: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 4157: fetch l_header_changes_csr into l_additional_changes; 4158: close l_header_changes_csr; 4159: 4160: if(l_additional_changes is not null) then 4161: l_document := ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''|| 4162: ' `  '||l_additional_changes||' '; 4163: WF_NOTIFICATION.WriteToClob(document,l_document); 4164: end if; 4165: else Line 4166: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4162: ' `  '||l_additional_changes||' '; 4163: WF_NOTIFICATION.WriteToClob(document,l_document); 4164: end if; 4165: else 4166: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4167: fnd_message.set_token('DOC',l_document_type); 4168: l_document := fnd_message.get; 4169: WF_NOTIFICATION.WriteToClob(document,l_document); 4170: end if; Line 4167: fnd_message.set_token('DOC',l_document_type); 4163: WF_NOTIFICATION.WriteToClob(document,l_document); 4164: end if; 4165: else 4166: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4167: fnd_message.set_token('DOC',l_document_type); 4168: l_document := fnd_message.get; 4169: WF_NOTIFICATION.WriteToClob(document,l_document); 4170: end if; 4171: exception when others then Line 4168: l_document := fnd_message.get; 4164: end if; 4165: else 4166: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER'); 4167: fnd_message.set_token('DOC',l_document_type); 4168: l_document := fnd_message.get; 4169: WF_NOTIFICATION.WriteToClob(document,l_document); 4170: end if; 4171: exception when others then 4172: IF g_fnd_debug = 'Y' THEN Line 4289: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4285: nvl(pcr.old_quantity, pla.quantity) OLD_QTY, 4286: to_number(null) NEW_QTY, 4287: nvl(pcr.old_price,pla.unit_price) OLD_PRICE, 4288: pcr.new_price NEW_PRICE, 4289: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4290: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4291: pla.item_description ITEM_DESCRIPTION, 4292: pla.unit_meas_lookup_code UOM, 4293: null SHIP_TO_LOCATION, Line 4290: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4286: to_number(null) NEW_QTY, 4287: nvl(pcr.old_price,pla.unit_price) OLD_PRICE, 4288: pcr.new_price NEW_PRICE, 4289: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4290: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4291: pla.item_description ITEM_DESCRIPTION, 4292: pla.unit_meas_lookup_code UOM, 4293: null SHIP_TO_LOCATION, 4294: pcr.response_reason REASON, Line 4316: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4312: nvl(pcr.old_quantity,plla.quantity) OLD_QTY, 4313: pcr.new_quantity NEW_QTY, 4314: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4315: pcr.new_price NEW_PRICE, 4316: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4317: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4318: pla.item_description ITEM_DESCRIPTION, 4319: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4320: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 4317: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4313: pcr.new_quantity NEW_QTY, 4314: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4315: pcr.new_price NEW_PRICE, 4316: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4317: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4318: pla.item_description ITEM_DESCRIPTION, 4319: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4320: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4321: pcr.response_reason REASON, Line 4322: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4318: pla.item_description ITEM_DESCRIPTION, 4319: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4320: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4321: pcr.response_reason REASON, 4322: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4323: pcr.action_type ACTION_CODE 4324: 4325: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla, 4326: hr_locations_all hla, hz_locations hz Line 4352: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4348: pcr.old_quantity OLD_QTY, 4349: pcr.new_quantity NEW_QTY, 4350: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4351: pcr.new_price NEW_PRICE, 4352: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4353: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4354: pla.item_description ITEM_DESCRIPTION, 4355: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4356: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, Line 4353: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4349: pcr.new_quantity NEW_QTY, 4350: nvl(pcr.old_price,plla.price_override) OLD_PRICE, 4351: pcr.new_price NEW_PRICE, 4352: decode(pcr.REQUEST_STATUS,'ACCEPTED',fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'), 4353: 'REJECTED',fnd_message.get_string('PO','PO_WF_NOTIF_REJ'),'Error') RESPONSE, 4354: pla.item_description ITEM_DESCRIPTION, 4355: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4356: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4357: pcr.response_reason REASON, Line 4358: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4354: pla.item_description ITEM_DESCRIPTION, 4355: nvl(plla.unit_meas_lookup_code,pla.unit_meas_lookup_code) UOM, 4356: nvl(hla.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,60)) SHIP_TO_LOCATION, 4357: pcr.response_reason REASON, 4358: decode(pcr.parent_line_location_id, null, null, fnd_message.get_string('PO','PO_WF_NOTIF_YES')) SPLIT, 4359: pcr.action_type ACTION_CODE 4360: from po_change_requests pcr, po_lines_archive_all pla, po_line_locations_archive_all plla, 4361: hr_locations_all hla, hz_locations hz 4362: where change_request_group_id =grp_id Line 4532: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4528: if (display_type = 'text/html') then 4529: 4530: if(l_po_release_id is null) then 4531: if(l_type_lookup_code = 'STANDARD') then 4532: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4533: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 4534: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4535: elsif(l_type_lookup_code = 'BLANKET') then 4536: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; Line 4534: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4530: if(l_po_release_id is null) then 4531: if(l_type_lookup_code = 'STANDARD') then 4532: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4533: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 4534: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4535: elsif(l_type_lookup_code = 'BLANKET') then 4536: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4537: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num, 4538: l_type_lookup_code ); Line 4536: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4532: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 4533: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 4534: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 4535: elsif(l_type_lookup_code = 'BLANKET') then 4536: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4537: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num, 4538: l_type_lookup_code ); 4539: elsif(l_type_lookup_code = 'CONTRACT') then 4540: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; Line 4540: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 4536: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 4537: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num, 4538: l_type_lookup_code ); 4539: elsif(l_type_lookup_code = 'CONTRACT') then 4540: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 4541: elsif(l_type_lookup_code = 'PLANNED') then 4542: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4543: end if; 4544: l_document :=l_base_url_tag|| ' Line 4542: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4538: l_type_lookup_code ); 4539: elsif(l_type_lookup_code = 'CONTRACT') then 4540: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 4541: elsif(l_type_lookup_code = 'PLANNED') then 4542: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4543: end if; 4544: l_document :=l_base_url_tag|| ' 4545: '||l_doc_hdr_info||' '|| 4546: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' Line 4546: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4542: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 4543: end if; 4544: l_document :=l_base_url_tag|| ' 4545: '||l_doc_hdr_info||' '|| 4546: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4547: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'|| 4548: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 4549: ||') '; 4550: Line 4547: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'|| 4543: end if; 4544: l_document :=l_base_url_tag|| ' 4545: '||l_doc_hdr_info||' '|| 4546: fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4547: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||l_po_currency||')'|| 4548: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30)) 4549: ||') '; 4550: 4551: else Line 4553: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 4549: ||') '; 4550: 4551: else 4552: if(l_type_lookup_code = 'BLANKET') then 4553: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 4554: elsif(l_type_lookup_code = 'PLANNED') then 4555: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4556: end if; 4557: l_document :=l_base_url_tag|| ' Line 4555: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4551: else 4552: if(l_type_lookup_code = 'BLANKET') then 4553: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 4554: elsif(l_type_lookup_code = 'PLANNED') then 4555: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4556: end if; 4557: l_document :=l_base_url_tag|| ' 4558: '||l_doc_hdr_info|| 4559: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' Line 4559: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4555: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 4556: end if; 4557: l_document :=l_base_url_tag|| ' 4558: '||l_doc_hdr_info|| 4559: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4560: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 4561: l_rel_currency||')'|| 4562: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 4563: ||') '; Line 4560: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 4556: end if; 4557: l_document :=l_base_url_tag|| ' 4558: '||l_doc_hdr_info|| 4559: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' ' 4560: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('|| 4561: l_rel_currency||')'|| 4562: TO_CHAR(l_rel_total, FND_CURRENCY.GET_FORMAT_MASK(l_rel_currency, 30)) 4563: ||') '; 4564: Line 4574: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' 4570: 4600: '||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')||' 4571: 4572: 4573: 4575: 4576: 4577: 4578: 4575: 4576: 4577: 4578: 4580: 4583: Line 4586: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' 4582: ' 4583: 4584: 4585: 4587: 4589: 4590: Line 4594: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' 4590: 4591: 4592: 4593: 4595: 4597: 4598: 4574: '||fnd_message.get_string('PO','PO_WF_NOTIF_VENDOR')||' '||l_supplier_name||' Line 4579: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_supplier_name||' 4579: '||fnd_message.get_string('PO','PO_WF_NOTIF_ADDRESS')||' '||l_sup_address_line1||' '||l_sup_address_line2||' '|| 4581: l_sup_address_line3||' '||l_sup_city||', '||l_sup_state||' '||l_sup_zip|| 4582: ' 4586: '||fnd_message.get_string('PO','PO_WF_NOTIF_FOB')||' '||l_fob|| 4588: ' 4594: '||fnd_message.get_string('PO','PO_WF_NOTIF_CARRIER')||' '||l_carrier|| 4596: ' Line 4604: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' 4601: 4602: 4603: 4605: 4607: 4608: Line 4611: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' 4607: 4608: 4609: 4610: 4612: 4604: '||fnd_message.get_string('PO','PO_WF_NOTIF_ORDER_DATE')||' '||l_order_date|| 4606: ' 4611: '||fnd_message.get_string('PO','PO_WF_NOTIF_SHPTO_ADD')||' '; 4613: if(l_ship_addr_l1 is not null) then 4614: l_document := l_document || l_ship_addr_l1||' '; 4615: end if; Line 4635: l_document := ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_DETAILS')||' '; 4631: '; 4632: 4633: WF_Notification.WriteToClob(document,l_document); 4634: if(l_header_cancel = 'N') then 4635: l_document := ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_DETAILS')||' '; 4636: --LEGENDS 4637: l_document := l_document||''|| NL; 4638: l_document:= l_document||' 4648: 4649: l_document := l_document || 4650: ' '|| 4639: '' Line 4640: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 4636: --LEGENDS 4637: l_document := l_document||''|| NL; 4638: l_document:= l_document||'' || NL; 4642: l_document := l_document || ''|| NL; 4643: l_document:= l_document||'' || NL; 4642: l_document := l_document || ''|| NL; 4643: l_document:= l_document||'' || NL; 4647: l_document := l_document || ' '|| 4639: '' 4640: || fnd_message.get_string('PO', 'PO_WF_NOTIF_NEW_VALUE'); 4641: l_document := l_document || ' '|| 4644: '' Line 4645: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 4641: l_document := l_document || ' '|| 4644: '' 4645: || fnd_message.get_string('PO', 'PO_WF_NOTIF_CANCEL_PENDING'); 4646: l_document := l_document || ' ' || NL; 4648: 4649: l_document := l_document || Line 4652: '||fnd_message.get_string('PO','PO_WF_NOTIF_LINE_NUMBER')||' 4651: 4652: 4653: 4654: 4655: 4656: Line 4653: 4649: l_document := l_document || 4650: ' '||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')||' 4651: 4652: 4653: 4654: 4655: 4656: 4657: Line 4654: 4650: ' '||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')||' 4651: 4652: 4653: 4654: 4655: 4656: 4657: 4658: Line 4655: 4651: 4652: 4653: 4654: 4655: 4656: 4657: 4658: 4659: Line 4656: 4652: 4653: 4654: 4655: 4656: 4657: 4658: 4659: 4660: Line 4657: 4653: 4654: 4655: 4656: 4657: 4658: 4659: 4660: 4661: Line 4658: 4654: 4655: 4656: 4657: 4658: 4659: 4660: 4661: 4662: Line 4659: 4655: 4656: 4657: 4658: 4659: 4660: 4661: 4662: 4663: Line 4660: 4656: 4657: 4658: 4659: 4660: 4661: 4662: 4663: 4664: Line 4661: 4657: 4658: 4659: 4660: 4661: 4662: 4663: 4664: 4665: '; Line 4662: 4658: 4659: 4660: 4661: 4662: 4663: 4664: 4665: '; 4666: WF_NOTIFICATION.WriteToClob(document,l_document); Line 4663: 4659: 4660: 4661: 4662: 4663: 4664: 4665: '; 4666: WF_NOTIFICATION.WriteToClob(document,l_document); 4667: open l_po_chg_req_csr(p_chg_req_grp_id); Line 4907: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'); 4903: close l_header_changes_csr; 4904: 4905: if(l_additional_changes is not null) then 4906: if(l_header_response = 'ACCEPTED') then 4907: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'); 4908: else 4909: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 4910: end if; 4911: 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 4909: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 4905: if(l_additional_changes is not null) then 4906: if(l_header_response = 'ACCEPTED') then 4907: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_ACCEPTED'); 4908: else 4909: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 4910: end if; 4911: l_document := ' ' || 4912: '' || 4913: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| Line 4913: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| 4909: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_REJ'); 4910: end if; 4911: l_document := ' ' || 4912: '' || 4913: '' || 4915: '' || 4917: '' || Line 4915: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| 4914: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')|| 4916: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')|| 4911: l_document := ' ' || 4912: '' || 4913: '' || 4915: '' || 4917: '' || 4918: '' || ' '||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ_NCOL')|| 4914: ' '||fnd_message.get_string('PO','PO_WF_NOTIF_RESPONSE')|| 4916: ' ' || l_additional_changes || 4919: ' ' || l_header_response || Line 4929: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 4925: end if; 4926: 4927: else --if header_cnacel = N 4928: if(l_header_response = 'ACCEPTED') then 4929: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 4930: else 4931: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 4932: end if; 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); Line 4931: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 4927: else --if header_cnacel = N 4928: if(l_header_response = 'ACCEPTED') then 4929: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 4930: else 4931: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 4932: end if; 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 4934: fnd_message.set_token('DOC',l_doc_hdr_info); 4935: fnd_message.set_token('RESPONSE',l_header_response); Line 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 4929: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SACCEPTED'); 4930: else 4931: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 4932: end if; 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 4934: fnd_message.set_token('DOC',l_doc_hdr_info); 4935: fnd_message.set_token('RESPONSE',l_header_response); 4936: l_document := fnd_message.get; 4937: WF_NOTIFICATION.WriteToClob(document,l_document); Line 4934: fnd_message.set_token('DOC',l_doc_hdr_info); 4930: else 4931: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 4932: end if; 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 4934: fnd_message.set_token('DOC',l_doc_hdr_info); 4935: fnd_message.set_token('RESPONSE',l_header_response); 4936: l_document := fnd_message.get; 4937: WF_NOTIFICATION.WriteToClob(document,l_document); 4938: end if; Line 4935: fnd_message.set_token('RESPONSE',l_header_response); 4931: l_header_response := fnd_message.get_string('PO','PO_WF_NOTIF_SREJECTED'); 4932: end if; 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 4934: fnd_message.set_token('DOC',l_doc_hdr_info); 4935: fnd_message.set_token('RESPONSE',l_header_response); 4936: l_document := fnd_message.get; 4937: WF_NOTIFICATION.WriteToClob(document,l_document); 4938: end if; 4939: else Line 4936: l_document := fnd_message.get; 4932: end if; 4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN'); 4934: fnd_message.set_token('DOC',l_doc_hdr_info); 4935: fnd_message.set_token('RESPONSE',l_header_response); 4936: l_document := fnd_message.get; 4937: WF_NOTIFICATION.WriteToClob(document,l_document); 4938: end if; 4939: else 4940: WF_NOTIFICATION.WriteToClob(document,'GEN_NTF_FOR_SUP_BUY_RP for no html customer'); Line 5090: fnd_message.set_name('PO', l_message_name); 5086: else 5087: return; 5088: end if; 5089: 5090: fnd_message.set_name('PO', l_message_name); 5091: l_msg_header := fnd_message.get; 5092: ELSIF( l_display_name IS NOT NULL) THEN 5093: l_msg_header := l_display_name; 5094: END IF; Line 5091: l_msg_header := fnd_message.get; 5087: return; 5088: end if; 5089: 5090: fnd_message.set_name('PO', l_message_name); 5091: l_msg_header := fnd_message.get; 5092: ELSIF( l_display_name IS NOT NULL) THEN 5093: l_msg_header := l_display_name; 5094: END IF; 5095: Line 5096: --fnd_message.set_token('PO_NUMBER', l_po_num); 5092: ELSIF( l_display_name IS NOT NULL) THEN 5093: l_msg_header := l_display_name; 5094: END IF; 5095: 5096: --fnd_message.set_token('PO_NUMBER', l_po_num); 5097: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message 5098: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || 5099: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5100: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || Line 5099: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5095: 5096: --fnd_message.set_token('PO_NUMBER', l_po_num); 5097: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message 5098: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || 5099: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5100: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || 5101: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5102: ELSE 5103: IF(l_type_lookup_code = 'BLANKET') THEN Line 5101: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5097: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP if Auto Approved add Auto Approve message 5098: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || 5099: l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||' ' 5100: ||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) || 5101: ' ' || l_currency_code || ') ' || fnd_message.get_string('POS','POS_AUTO_APP_MSG'); 5102: ELSE 5103: IF(l_type_lookup_code = 'BLANKET') THEN 5104: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num; -- RDP if Blanket don't display Total 5105: ELSE Line 5106: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL') 5102: ELSE 5103: IF(l_type_lookup_code = 'BLANKET') THEN 5104: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num; -- RDP if Blanket don't display Total 5105: ELSE 5106: l_document_header_info := l_msg_header || ' ' || l_po_num || ', ' || l_revision_num|| ' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL') 5107: ||' '||TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_currency_code, 30)) 5108: || ' ' || l_currency_code || ') '; 5109: END IF; 5110: END IF; Line 5145: fnd_message.set_name('PO', l_message_name); 5141: else 5142: return; 5143: end if; 5144: 5145: fnd_message.set_name('PO', l_message_name); 5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' Line 5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5142: return; 5143: end if; 5144: 5145: fnd_message.set_name('PO', l_message_name); 5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5150: ||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 5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5143: end if; 5144: 5145: fnd_message.set_name('PO', l_message_name); 5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5150: ||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'); 5151: ELSE Line 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5145: fnd_message.set_name('PO', l_message_name); 5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5150: ||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'); 5151: ELSE 5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5153: ||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 5150: ||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'); 5146: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5147: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5150: ||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'); 5151: ELSE 5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5153: ||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||')'; 5154: END IF; Line 5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5148: IF (l_notif_usage = 'BUYER_AUTO_FYI') THEN -- RDP generating subject for releases if auto approved 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5150: ||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'); 5151: ELSE 5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5153: ||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||')'; 5154: END IF; 5155: 5156: END IF; Line 5153: ||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||')'; 5149: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5150: ||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'); 5151: ELSE 5152: l_document_header_info := fnd_message.get || ', ' || l_rel_revision_num ||'(' 5153: ||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||')'; 5154: END IF; 5155: 5156: END IF; 5157: Line 5171: fnd_message.set_name('PO', l_message_name); 5167: ELSE 5168: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5169: END IF; 5170: 5171: fnd_message.set_name('PO', l_message_name); 5172: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5173: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5174: document := fnd_message.get; 5175: Line 5172: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5168: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5169: END IF; 5170: 5171: fnd_message.set_name('PO', l_message_name); 5172: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5173: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5174: document := fnd_message.get; 5175: 5176: END GEN_NTF_FOR_BUYER_SUBJECT; Line 5173: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5169: END IF; 5170: 5171: fnd_message.set_name('PO', l_message_name); 5172: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5173: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5174: document := fnd_message.get; 5175: 5176: END GEN_NTF_FOR_BUYER_SUBJECT; 5177: Line 5174: document := fnd_message.get; 5170: 5171: fnd_message.set_name('PO', l_message_name); 5172: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5173: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5174: document := fnd_message.get; 5175: 5176: END GEN_NTF_FOR_BUYER_SUBJECT; 5177: 5178: --------------------------------------------------------- Line 5293: fnd_message.set_name('PO', l_message_name); 5289: else 5290: RETURN; 5291: end if; 5292: 5293: fnd_message.set_name('PO', l_message_name); 5294: l_msg_header := fnd_message.get; 5295: ELSIF(l_display_name IS NOT NULL) THEN 5296: l_msg_header := l_display_name; 5297: END IF; Line 5294: l_msg_header := fnd_message.get; 5290: RETURN; 5291: end if; 5292: 5293: fnd_message.set_name('PO', l_message_name); 5294: l_msg_header := fnd_message.get; 5295: ELSIF(l_display_name IS NOT NULL) THEN 5296: l_msg_header := l_display_name; 5297: END IF; 5298: --fnd_message.set_token('PO_NUMBER', l_po_num); Line 5298: --fnd_message.set_token('PO_NUMBER', l_po_num); 5294: l_msg_header := fnd_message.get; 5295: ELSIF(l_display_name IS NOT NULL) THEN 5296: l_msg_header := l_display_name; 5297: END IF; 5298: --fnd_message.set_token('PO_NUMBER', l_po_num); 5299: l_doc_hdr_info := l_msg_header || ' ' || l_po_num || ',' || l_revision_num; -- RDP changes (generating subject for Supplier Notification) 5300: 5301: ELSE 5302: select pha.segment1, Line 5326: fnd_message.set_name('PO', l_message_name); 5322: else 5323: RETURN; 5324: end if; 5325: 5326: fnd_message.set_name('PO', l_message_name); 5327: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5328: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5329: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5330: Line 5327: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5323: RETURN; 5324: end if; 5325: 5326: fnd_message.set_name('PO', l_message_name); 5327: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5328: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5329: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5330: 5331: END IF; Line 5328: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5324: end if; 5325: 5326: fnd_message.set_name('PO', l_message_name); 5327: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5328: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5329: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5330: 5331: END IF; 5332: Line 5329: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5325: 5326: fnd_message.set_name('PO', l_message_name); 5327: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5328: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5329: l_doc_hdr_info := fnd_message.get || ',' || l_revision_num; -- RDP changes 5330: 5331: END IF; 5332: 5333: if(l_header_cancel = 'N') then Line 5336: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5332: 5333: if(l_header_cancel = 'N') then 5334: 5335: 5336: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5337: fnd_message.set_token('DOC',l_doc_hdr_info); 5338: fnd_message.set_token('BUYER',l_buyer_name); 5339: document := fnd_message.get; */ 5340: Line 5337: fnd_message.set_token('DOC',l_doc_hdr_info); 5333: if(l_header_cancel = 'N') then 5334: 5335: 5336: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5337: fnd_message.set_token('DOC',l_doc_hdr_info); 5338: fnd_message.set_token('BUYER',l_buyer_name); 5339: document := fnd_message.get; */ 5340: 5341: l_temp_message := l_buyer_name || ' - '; Line 5338: fnd_message.set_token('BUYER',l_buyer_name); 5334: 5335: 5336: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5337: fnd_message.set_token('DOC',l_doc_hdr_info); 5338: fnd_message.set_token('BUYER',l_buyer_name); 5339: document := fnd_message.get; */ 5340: 5341: l_temp_message := l_buyer_name || ' - '; 5342: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); Line 5339: document := fnd_message.get; */ 5335: 5336: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CHG'); 5337: fnd_message.set_token('DOC',l_doc_hdr_info); 5338: fnd_message.set_token('BUYER',l_buyer_name); 5339: document := fnd_message.get; */ 5340: 5341: l_temp_message := l_buyer_name || ' - '; 5342: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5343: fnd_message.set_token('DOC',l_doc_hdr_info); Line 5342: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5338: fnd_message.set_token('BUYER',l_buyer_name); 5339: document := fnd_message.get; */ 5340: 5341: l_temp_message := l_buyer_name || ' - '; 5342: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5343: fnd_message.set_token('DOC',l_doc_hdr_info); 5344: document := l_temp_message || fnd_message.get; -- RDP changes 5345: 5346: else Line 5343: fnd_message.set_token('DOC',l_doc_hdr_info); 5339: document := fnd_message.get; */ 5340: 5341: l_temp_message := l_buyer_name || ' - '; 5342: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5343: fnd_message.set_token('DOC',l_doc_hdr_info); 5344: document := l_temp_message || fnd_message.get; -- RDP changes 5345: 5346: else 5347: Line 5344: document := l_temp_message || fnd_message.get; -- RDP changes 5340: 5341: l_temp_message := l_buyer_name || ' - '; 5342: fnd_message.set_name('POS','POS_SUP_RESP_MSG'); 5343: fnd_message.set_token('DOC',l_doc_hdr_info); 5344: document := l_temp_message || fnd_message.get; -- RDP changes 5345: 5346: else 5347: 5348: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); Line 5348: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5344: document := l_temp_message || fnd_message.get; -- RDP changes 5345: 5346: else 5347: 5348: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5349: fnd_message.set_token('DOC',l_doc_hdr_info); 5350: fnd_message.set_token('BUYER',l_buyer_name); 5351: document := fnd_message.get; */ 5352: Line 5349: fnd_message.set_token('DOC',l_doc_hdr_info); 5345: 5346: else 5347: 5348: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5349: fnd_message.set_token('DOC',l_doc_hdr_info); 5350: fnd_message.set_token('BUYER',l_buyer_name); 5351: document := fnd_message.get; */ 5352: 5353: l_temp_message := l_buyer_name || ' - '; Line 5350: fnd_message.set_token('BUYER',l_buyer_name); 5346: else 5347: 5348: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5349: fnd_message.set_token('DOC',l_doc_hdr_info); 5350: fnd_message.set_token('BUYER',l_buyer_name); 5351: document := fnd_message.get; */ 5352: 5353: l_temp_message := l_buyer_name || ' - '; 5354: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); Line 5351: document := fnd_message.get; */ 5347: 5348: /* fnd_message.set_name('POS','PO_WF_NOTIF_RESP_SUB_CAN'); 5349: fnd_message.set_token('DOC',l_doc_hdr_info); 5350: fnd_message.set_token('BUYER',l_buyer_name); 5351: document := fnd_message.get; */ 5352: 5353: l_temp_message := l_buyer_name || ' - '; 5354: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5355: fnd_message.set_token('DOC',l_doc_hdr_info); Line 5354: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5350: fnd_message.set_token('BUYER',l_buyer_name); 5351: document := fnd_message.get; */ 5352: 5353: l_temp_message := l_buyer_name || ' - '; 5354: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5355: fnd_message.set_token('DOC',l_doc_hdr_info); 5356: document := l_temp_message || fnd_message.get; -- RDP changes 5357: 5358: end if; Line 5355: fnd_message.set_token('DOC',l_doc_hdr_info); 5351: document := fnd_message.get; */ 5352: 5353: l_temp_message := l_buyer_name || ' - '; 5354: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5355: fnd_message.set_token('DOC',l_doc_hdr_info); 5356: document := l_temp_message || fnd_message.get; -- RDP changes 5357: 5358: end if; 5359: Line 5356: document := l_temp_message || fnd_message.get; -- RDP changes 5352: 5353: l_temp_message := l_buyer_name || ' - '; 5354: fnd_message.set_name('POS','POS_SUP_RESP_MSG_CAN'); 5355: fnd_message.set_token('DOC',l_doc_hdr_info); 5356: document := l_temp_message || fnd_message.get; -- RDP changes 5357: 5358: end if; 5359: 5360: END GEN_NTF_FOR_SUP_SUBJECT; Line 5458: fnd_message.set_name('PO', l_message_name); 5454: elsif(l_type_lookup_code = 'CONTRACT') then 5455: l_message_name := 'PO_POTYPE_CNTR'; 5456: end if; 5457: 5458: fnd_message.set_name('PO', l_message_name); 5459: l_msg_header := fnd_message.get; 5460: ELSIF(l_display_name IS NOT NULL) THEN 5461: l_msg_header := l_display_name; 5462: END IF; Line 5459: l_msg_header := fnd_message.get; 5455: l_message_name := 'PO_POTYPE_CNTR'; 5456: end if; 5457: 5458: fnd_message.set_name('PO', l_message_name); 5459: l_msg_header := fnd_message.get; 5460: ELSIF(l_display_name IS NOT NULL) THEN 5461: l_msg_header := l_display_name; 5462: END IF; 5463: --fnd_message.set_token('PO_NUMBER', l_po_num); Line 5463: --fnd_message.set_token('PO_NUMBER', l_po_num); 5459: l_msg_header := fnd_message.get; 5460: ELSIF(l_display_name IS NOT NULL) THEN 5461: l_msg_header := l_display_name; 5462: END IF; 5463: --fnd_message.set_token('PO_NUMBER', l_po_num); 5464: l_document_header_info := l_msg_header || ' ' || l_po_num; 5465: 5466: ELSE 5467: select pha.type_lookup_code, Line 5488: fnd_message.set_name('PO', l_message_name); 5484: elsif(l_type_lookup_code = 'PLANNED') then 5485: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5486: end if; 5487: 5488: fnd_message.set_name('PO', l_message_name); 5489: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5490: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5491: l_document_header_info := fnd_message.get; 5492: Line 5489: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5485: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5486: end if; 5487: 5488: fnd_message.set_name('PO', l_message_name); 5489: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5490: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5491: l_document_header_info := fnd_message.get; 5492: 5493: END IF; Line 5490: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5486: end if; 5487: 5488: fnd_message.set_name('PO', l_message_name); 5489: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5490: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5491: l_document_header_info := fnd_message.get; 5492: 5493: END IF; 5494: Line 5491: l_document_header_info := fnd_message.get; 5487: 5488: fnd_message.set_name('PO', l_message_name); 5489: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5490: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5491: l_document_header_info := fnd_message.get; 5492: 5493: END IF; 5494: 5495: l_header_cancel := 'N'; Line 5512: fnd_message.set_name('PO', l_message_name); 5508: else 5509: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5510: end if; 5511: 5512: fnd_message.set_name('PO', l_message_name); 5513: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5514: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5515: document := fnd_message.get; 5516: Line 5513: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5509: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5510: end if; 5511: 5512: fnd_message.set_name('PO', l_message_name); 5513: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5514: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5515: document := fnd_message.get; 5516: 5517: END GEN_NTF_FOR_PLAN_SUBJECT; Line 5514: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5510: end if; 5511: 5512: fnd_message.set_name('PO', l_message_name); 5513: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5514: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5515: document := fnd_message.get; 5516: 5517: END GEN_NTF_FOR_PLAN_SUBJECT; 5518: Line 5515: document := fnd_message.get; 5511: 5512: fnd_message.set_name('PO', l_message_name); 5513: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5514: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5515: document := fnd_message.get; 5516: 5517: END GEN_NTF_FOR_PLAN_SUBJECT; 5518: 5519: --------------------------------------------------------- Line 5614: fnd_message.set_name('PO', l_message_name); 5610: elsif(l_type_lookup_code = 'CONTRACT') then 5611: l_message_name := 'PO_POTYPE_CNTR'; 5612: end if; 5613: 5614: fnd_message.set_name('PO', l_message_name); 5615: l_msg_header := fnd_message.get; 5616: ELSIF(l_display_name IS NOT NULL) THEN 5617: l_msg_header := l_display_name; 5618: END IF; Line 5615: l_msg_header := fnd_message.get; 5611: l_message_name := 'PO_POTYPE_CNTR'; 5612: end if; 5613: 5614: fnd_message.set_name('PO', l_message_name); 5615: l_msg_header := fnd_message.get; 5616: ELSIF(l_display_name IS NOT NULL) THEN 5617: l_msg_header := l_display_name; 5618: END IF; 5619: --fnd_message.set_token('PO_NUMBER', l_po_num); Line 5619: --fnd_message.set_token('PO_NUMBER', l_po_num); 5615: l_msg_header := fnd_message.get; 5616: ELSIF(l_display_name IS NOT NULL) THEN 5617: l_msg_header := l_display_name; 5618: END IF; 5619: --fnd_message.set_token('PO_NUMBER', l_po_num); 5620: l_document_header_info := l_msg_header || ' ' || l_po_num; 5621: 5622: ELSE 5623: select pha.type_lookup_code, Line 5644: fnd_message.set_name('PO', l_message_name); 5640: elsif(l_type_lookup_code = 'PLANNED') then 5641: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5642: end if; 5643: 5644: fnd_message.set_name('PO', l_message_name); 5645: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5646: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5647: l_document_header_info := fnd_message.get; 5648: Line 5645: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5641: l_message_name := 'PO_WF_NOTIF_SCH_REL2'; 5642: end if; 5643: 5644: fnd_message.set_name('PO', l_message_name); 5645: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5646: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5647: l_document_header_info := fnd_message.get; 5648: 5649: end if; Line 5646: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5642: end if; 5643: 5644: fnd_message.set_name('PO', l_message_name); 5645: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5646: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5647: l_document_header_info := fnd_message.get; 5648: 5649: end if; 5650: Line 5647: l_document_header_info := fnd_message.get; 5643: 5644: fnd_message.set_name('PO', l_message_name); 5645: fnd_message.set_token('BLANKET_NUMBER', l_blanket_num); 5646: fnd_message.set_token('RELEASE_NUMBER', l_release_num); 5647: l_document_header_info := fnd_message.get; 5648: 5649: end if; 5650: 5651: l_header_cancel := 'N'; Line 5668: fnd_message.set_name('PO', l_message_name); 5664: else 5665: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5666: end if; 5667: 5668: fnd_message.set_name('PO', l_message_name); 5669: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5670: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5671: document := fnd_message.get; 5672: Line 5669: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5665: l_message_name := 'PO_WF_NOTIF_CANCEL_REQ_FROM'; 5666: end if; 5667: 5668: fnd_message.set_name('PO', l_message_name); 5669: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5670: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5671: document := fnd_message.get; 5672: 5673: END GEN_NTF_FOR_REQ_SUBJECT; Line 5670: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5666: end if; 5667: 5668: fnd_message.set_name('PO', l_message_name); 5669: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5670: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5671: document := fnd_message.get; 5672: 5673: END GEN_NTF_FOR_REQ_SUBJECT; 5674: Line 5671: document := fnd_message.get; 5667: 5668: fnd_message.set_name('PO', l_message_name); 5669: fnd_message.set_token('SUPPLIER_NAME', l_supplier_name); 5670: fnd_message.set_token('HEADER_INFO', l_document_header_info); 5671: document := fnd_message.get; 5672: 5673: END GEN_NTF_FOR_REQ_SUBJECT; 5674: 5675: /* Line 5744: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI')); 5740: if(l_header_change = 0) then -- RDP means no ADDITIONAL changes but PRORATE is required, set EXPLAIN_FYI 5741: wf_engine.SetItemAttrText ( itemtype => itemtype, 5742: itemkey => itemkey, 5743: aname => 'EXPLAIN_FYI', 5744: avalue => fnd_message.get_string('PO','PO_WF_NOTIF_EXPLAIN_FYI')); 5745: else 5746: wf_engine.SetItemAttrText ( itemtype => itemtype, 5747: itemkey => itemkey, 5748: aname => 'EXPLAIN_FYI', Line 6190: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 6186: end if; 6187: end if; 6188: 6189: if(l_type_lookup_code = 'PLANNED') then 6190: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 6191: elsif(l_type_lookup_code = 'BLANKET') then 6192: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6193: end if; 6194: Line 6192: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6188: 6189: if(l_type_lookup_code = 'PLANNED') then 6190: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_SCH_REL')||' '||l_blanket_num||'-'||l_release_num; 6191: elsif(l_type_lookup_code = 'BLANKET') then 6192: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6193: end if; 6194: 6195: if(l_header_cancel = 'N') then 6196: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); Line 6196: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6192: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BKT_REL')||' '||l_blanket_num||'-'||l_release_num; 6193: end if; 6194: 6195: if(l_header_cancel = 'N') then 6196: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6197: fnd_message.set_token('DOC',l_doc_hdr_info); 6198: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else Line 6197: fnd_message.set_token('DOC',l_doc_hdr_info); 6193: end if; 6194: 6195: if(l_header_cancel = 'N') then 6196: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6197: fnd_message.set_token('DOC',l_doc_hdr_info); 6198: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); Line 6198: fnd_message.set_token('BUYER',l_buyer_name); 6194: 6195: if(l_header_cancel = 'N') then 6196: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6197: fnd_message.set_token('DOC',l_doc_hdr_info); 6198: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6202: fnd_message.set_token('DOC',l_doc_hdr_info); Line 6199: l_notification_subject := fnd_message.get; 6195: if(l_header_cancel = 'N') then 6196: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6197: fnd_message.set_token('DOC',l_doc_hdr_info); 6198: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6202: fnd_message.set_token('DOC',l_doc_hdr_info); 6203: fnd_message.set_token('BUYER',l_buyer_name); Line 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6197: fnd_message.set_token('DOC',l_doc_hdr_info); 6198: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6202: fnd_message.set_token('DOC',l_doc_hdr_info); 6203: fnd_message.set_token('BUYER',l_buyer_name); 6204: l_notification_subject := fnd_message.get; 6205: end if; Line 6202: fnd_message.set_token('DOC',l_doc_hdr_info); 6198: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6202: fnd_message.set_token('DOC',l_doc_hdr_info); 6203: fnd_message.set_token('BUYER',l_buyer_name); 6204: l_notification_subject := fnd_message.get; 6205: end if; 6206: Line 6203: fnd_message.set_token('BUYER',l_buyer_name); 6199: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6202: fnd_message.set_token('DOC',l_doc_hdr_info); 6203: fnd_message.set_token('BUYER',l_buyer_name); 6204: l_notification_subject := fnd_message.get; 6205: end if; 6206: 6207: /* Line 6204: l_notification_subject := fnd_message.get; 6200: else 6201: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6202: fnd_message.set_token('DOC',l_doc_hdr_info); 6203: fnd_message.set_token('BUYER',l_buyer_name); 6204: l_notification_subject := fnd_message.get; 6205: end if; 6206: 6207: /* 6208: update po_releases_all Line 6288: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6284: end if; 6285: end if; 6286: 6287: if(l_type_lookup_code = 'STANDARD') then 6288: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6289: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 6290: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6291: elsif(l_type_lookup_code = 'BLANKET') then 6292: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; Line 6290: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6286: 6287: if(l_type_lookup_code = 'STANDARD') then 6288: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6289: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 6290: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6291: elsif(l_type_lookup_code = 'BLANKET') then 6292: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6293: elsif(l_type_lookup_code = 'CONTRACT') then 6294: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; Line 6292: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6288: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO')||' '||l_po_num; 6289: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then 6290: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6291: elsif(l_type_lookup_code = 'BLANKET') then 6292: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6293: elsif(l_type_lookup_code = 'CONTRACT') then 6294: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6295: elsif(l_type_lookup_code = 'PLANNED') then 6296: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; Line 6294: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6290: l_document_type := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num; 6291: elsif(l_type_lookup_code = 'BLANKET') then 6292: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6293: elsif(l_type_lookup_code = 'CONTRACT') then 6294: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6295: elsif(l_type_lookup_code = 'PLANNED') then 6296: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6297: end if; 6298: Line 6296: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6292: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num; 6293: elsif(l_type_lookup_code = 'CONTRACT') then 6294: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num; 6295: elsif(l_type_lookup_code = 'PLANNED') then 6296: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6297: end if; 6298: 6299: if(l_header_cancel = 'N') then 6300: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); Line 6300: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6296: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_PLAN_PO')||' '||l_po_num; 6297: end if; 6298: 6299: if(l_header_cancel = 'N') then 6300: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6301: fnd_message.set_token('DOC',l_doc_hdr_info); 6302: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else Line 6301: fnd_message.set_token('DOC',l_doc_hdr_info); 6297: end if; 6298: 6299: if(l_header_cancel = 'N') then 6300: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6301: fnd_message.set_token('DOC',l_doc_hdr_info); 6302: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); Line 6302: fnd_message.set_token('BUYER',l_buyer_name); 6298: 6299: if(l_header_cancel = 'N') then 6300: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6301: fnd_message.set_token('DOC',l_doc_hdr_info); 6302: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6306: fnd_message.set_token('DOC',l_doc_hdr_info); Line 6303: l_notification_subject := fnd_message.get; 6299: if(l_header_cancel = 'N') then 6300: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CHG'); 6301: fnd_message.set_token('DOC',l_doc_hdr_info); 6302: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6306: fnd_message.set_token('DOC',l_doc_hdr_info); 6307: fnd_message.set_token('BUYER',l_buyer_name); Line 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6301: fnd_message.set_token('DOC',l_doc_hdr_info); 6302: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6306: fnd_message.set_token('DOC',l_doc_hdr_info); 6307: fnd_message.set_token('BUYER',l_buyer_name); 6308: l_notification_subject := fnd_message.get; 6309: end if; Line 6306: fnd_message.set_token('DOC',l_doc_hdr_info); 6302: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6306: fnd_message.set_token('DOC',l_doc_hdr_info); 6307: fnd_message.set_token('BUYER',l_buyer_name); 6308: l_notification_subject := fnd_message.get; 6309: end if; 6310: Line 6307: fnd_message.set_token('BUYER',l_buyer_name); 6303: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6306: fnd_message.set_token('DOC',l_doc_hdr_info); 6307: fnd_message.set_token('BUYER',l_buyer_name); 6308: l_notification_subject := fnd_message.get; 6309: end if; 6310: 6311: /* Line 6308: l_notification_subject := fnd_message.get; 6304: else 6305: fnd_message.set_name('PO','PO_WF_NOTIF_RESP_SUB_CAN'); 6306: fnd_message.set_token('DOC',l_doc_hdr_info); 6307: fnd_message.set_token('BUYER',l_buyer_name); 6308: l_notification_subject := fnd_message.get; 6309: end if; 6310: 6311: /* 6312: update po_headers_all