DBA Data[Home] [Help]

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 1872: ||' '||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

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: ||')

';
1876: else

Line 1879: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '

1875: ||')

';
1876: else
1877: l_document := l_base_url_tag||
1878: '
1879: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
1880: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
1881: l_po_currency||') '||
1882: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
1883: ||')
';

Line 1880: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||

1876: else
1877: l_document := l_base_url_tag||
1878: '
1879: '||l_document_type||' '||l_blanket_num||'-'||l_release_num||' '||fnd_message.get_string('PO','PO_WF_NOTIF_REV')||' '
1880: ||l_revision_num||' ('||fnd_message.get_string('PO','PO_WF_NOTIF_TOTAL')||'('||
1881: l_po_currency||') '||
1882: TO_CHAR(l_po_total, FND_CURRENCY.GET_FORMAT_MASK(l_po_currency, 30))
1883: ||')

';
1884: end if;

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