1: PACKAGE BODY PO_NEGOTIATIONS_SV2 AS
2: /* $Header: POXNEG3B.pls 120.11.12000000.4 2007/10/17 12:54:42 bisdas 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:
1322:
1323: x_errorcode varchar2(10);
1324: x_errormessage varchar2(255);
1324: x_errormessage varchar2(255);
1325: x_progress varchar2(4);
1326: pon_get_attachment_exception exception;
1327:
1328: d_module VARCHAR2(70) := 'po.plsql.PO_NEGOTIATIONS_SV2.add_attch_dynamic';
1329:
1330: BEGIN
1331:
1332: --
1480: l_who_rec.last_update_date := sysdate;
1481: l_who_rec.last_updated_by := nvl(x_created_by, 0);
1482: l_who_rec.last_update_login := x_last_update_login;
1483:
1484: PO_NEGOTIATIONS_SV2.convert_text_to_attachment
1485: ( p_long_text => l_text
1486: , p_description => x_description_tmp
1487: , p_category_id => x_category_id_tmp
1488: , p_to_entity_name => x_to_entity_name
1627:
1628: EXCEPTION
1629:
1630: WHEN OTHERS THEN
1631: PO_MESSAGE_S.sql_error ( 'PO_NEGOTIATIONS_SV2.CONVERT_TEXT_TO_ATTACHMENT', '000', SQLCODE );
1632: RAISE;
1633:
1634: END convert_text_to_attachment;
1635:
1645: , p_bid_line_number IN NUMBER
1646: )
1647: IS
1648: d_progress NUMBER;
1649: d_module VARCHAR2(70) := 'po.plsql.PO_NEGOTIATIONS_SV2.copy_sourcing_payitem_atts';
1650:
1651: l_bid_payment_id PO_LINE_LOCATIONS_INTERFACE.bid_payment_id%TYPE;
1652: l_auction_payment_id PO_LINE_LOCATIONS_INTERFACE.auction_payment_id%TYPE;
1653:
1749: RAISE;
1750: END copy_sourcing_payitem_atts;
1751: --
1752:
1753: END PO_NEGOTIATIONS_SV2;