[Home] [Help]
1: PACKAGE BODY PO_NEGOTIATIONS_SV2 AS
2: /* $Header: POXNEG3B.pls 120.16.12020000.3 2013/02/10 12:06:48 vegajula ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_pdoi_write_to_file VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_PDOI_WRITE_TO_FILE'),'N');
683: -- copied to po_header.
684: /*
685: --copy attachment from negotiation header to the po line
686: x_progress :='001';
687: po_negotiations_sv2.
688: copy_attachments('PON_AUCTION_HEADERS_ALL',
689: x_auction_header_id,
690: null,
691: null,
707: --
708:
709: --copy attachment from negotiation line to the po line
710: x_progress :='002';
711: po_negotiations_sv2.
712: copy_attachments('PON_AUCTION_ITEM_PRICES_ALL',
713: x_auction_header_id,
714: x_auction_line_number,
715: '',
730:
731:
732: --copy attachment from bid header to the po line
733: x_progress :='003';
734: po_negotiations_sv2.
735: copy_attachments('PON_BID_HEADERS',
736: x_auction_header_id,
737: x_bid_number,
738: '',
751: null,
752: 'NEG');
753: --copy attachment from bid line to the po line
754: x_progress :='004';
755: po_negotiations_sv2.
756: copy_attachments('PON_BID_ITEM_PRICES',
757: x_auction_header_id,
758: x_bid_number,
759: x_auction_line_number,
869: --copy attachment from requisition header/line to the po line,
870: --when backed by a req.
871: If x_column1='NEGREQ' then
872: x_progress :='009';
873: po_negotiations_sv2.
874: copy_attachments('REQ_HEADERS',
875: x_requisition_header_id,
876: '',
877: '',
889: '',
890: null,
891: x_column1);
892: x_progress :='010';
893: po_negotiations_sv2.
894: copy_attachments('REQ_LINES',
895: x_requisition_line_id,
896: '',
897: '',
1316: x_language_temp fnd_documents_tl.language%TYPE;
1317: x_datatype_id_tmp NUMBER;
1318: x_description_tmp fnd_documents_tl.description%TYPE;
1319: l_text long;
1320: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1321: c_text CLOB;
1322: l_size NUMBER := 0;
1323: l_max_size NUMBER := 30000;
1324:
1326: x_errormessage varchar2(255);
1327: x_progress varchar2(4);
1328: pon_get_attachment_exception exception;
1329:
1330: d_module VARCHAR2(70) := 'po.plsql.PO_NEGOTIATIONS_SV2.add_attch_dynamic';
1331:
1332: BEGIN
1333:
1334: --
1543: otherwise, we should still continue use attachment type as LONG_TEXT
1544: */
1545: IF (x_from_entity_name = 'PON_BID_HEADER_ATTRIBUTES' AND l_size > l_max_size AND c_text IS NOT NULL) THEN
1546: IF (PO_LOG.d_stmt) THEN
1547: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob ');
1548: END IF;
1549: PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob
1550: ( p_clob_text => c_text
1551: , p_description => x_description_tmp
1545: IF (x_from_entity_name = 'PON_BID_HEADER_ATTRIBUTES' AND l_size > l_max_size AND c_text IS NOT NULL) THEN
1546: IF (PO_LOG.d_stmt) THEN
1547: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob ');
1548: END IF;
1549: PO_NEGOTIATIONS_SV2.convert_text_to_attach_clob
1550: ( p_clob_text => c_text
1551: , p_description => x_description_tmp
1552: , p_category_id => x_category_id_tmp
1553: , p_to_entity_name => x_to_entity_name
1556: , p_who_rec => l_who_rec
1557: );
1558: ELSE
1559: IF (PO_LOG.d_stmt) THEN
1560: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attachment ');
1561: END IF;
1562: PO_NEGOTIATIONS_SV2.convert_text_to_attachment
1563: ( p_long_text => l_text
1564: , p_description => x_description_tmp
1558: ELSE
1559: IF (PO_LOG.d_stmt) THEN
1560: PO_LOG.stmt(d_module, 10, 'calling PO_NEGOTIATIONS_SV2.convert_text_to_attachment ');
1561: END IF;
1562: PO_NEGOTIATIONS_SV2.convert_text_to_attachment
1563: ( p_long_text => l_text
1564: , p_description => x_description_tmp
1565: , p_category_id => x_category_id_tmp
1566: , p_to_entity_name => x_to_entity_name
1717:
1718: EXCEPTION
1719:
1720: WHEN OTHERS THEN
1721: PO_MESSAGE_S.sql_error ( 'PO_NEGOTIATIONS_SV2.CONVERT_TEXT_TO_ATTACHMENT', '000', SQLCODE );
1722: RAISE;
1723:
1724: END convert_text_to_attachment;
1725:
1872: , sysdate
1873: );
1874: EXCEPTION
1875: WHEN OTHERS THEN
1876: PO_MESSAGE_S.sql_error ( 'PO_NEGOTIATIONS_SV2.CONVERT_TEXT_TO_ATTACHMENT_CLOB', '000', SQLCODE );
1877: RAISE;
1878: END convert_text_to_attach_clob;
1879: --
1880: -- Bug 4620207: Take in more parameters
1888: , p_bid_line_number IN NUMBER
1889: )
1890: IS
1891: d_progress NUMBER;
1892: d_module VARCHAR2(70) := 'po.plsql.PO_NEGOTIATIONS_SV2.copy_sourcing_payitem_atts';
1893:
1894: l_bid_payment_id PO_LINE_LOCATIONS_INTERFACE.bid_payment_id%TYPE;
1895: l_auction_payment_id PO_LINE_LOCATIONS_INTERFACE.auction_payment_id%TYPE;
1896:
1994: RAISE;
1995: END copy_sourcing_payitem_atts;
1996: --
1997:
1998: END PO_NEGOTIATIONS_SV2;