285: into x_org_id
286: from po_system_parameters;
287: exception
288: when others then
289: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
290: end;
291: --
292: ELSE
293: x_org_id := p_document_org_id;
604: END IF;
605:
606: /* exception
607: when others then
608: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
609: end;*/
610:
611: /* begin
612: x_progress := '006';
615: from po_requisition_headers_all --
616: where requisition_header_id=x_req_header_id;
617: exception
618: when others then
619: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
620: end;*/
621: --Bug 5841426
622:
623: /*
744: where requisition_line_id = x_req_line_id; --5841426
745:
746: exception
747: when others then
748: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
749: end;
750:
751: --
752: -- call Sourcing API to add it.
855: IF (x_error_message IS NULL) THEN
856: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;
857: END IF;
858: --
859: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
860: END;
861:
862: /*============================================================================
863: Name: DELETE_NEGOTIATION_REF