479: into x_org_id
480: from po_system_parameters;
481: exception
482: when others then
483: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
484: end;
485: --
486: ELSE
487: x_org_id := p_document_org_id;
923: END IF;
924:
925: /* exception
926: when others then
927: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
928: end;*/
929:
930: /* begin
931: x_progress := '006';
934: from po_requisition_headers_all --
935: where requisition_header_id=x_req_header_id;
936: exception
937: when others then
938: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
939: end;*/
940: --Bug 5841426
941:
942: /*
1162: END IF;
1163:
1164: exception
1165: when others then
1166: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
1167: end;
1168: -- logme(' after update');
1169: --
1170: -- call Sourcing API to add it.
1392: IF (x_error_message IS NULL) THEN
1393: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;
1394: END IF;
1395: --
1396: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
1397: -- logme( 'In Exception of create_negotiation() - progress is ' || x_progress || ' sqlcode is ' || SQLCODE);
1398: END;
1399:
1400: /*============================================================================
3009: where requisition_line_id = x_req_line_id ;
3010: END IF;
3011: exception
3012: when others then
3013: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
3014: end;
3015:
3016: IF ( l_has_price_diff_flag = 'Y' ) THEN
3017: -- logme( ' in price differentials');
3142:
3143: IF (x_error_message IS NULL) THEN
3144: x_error_message := 'In Exception of create_negotiation:' || x_progress || ':' || fnd_message.get;
3145: END IF;
3146: po_message_s.sql_error('In Exception of create_negotiation()', x_progress, sqlcode);
3147: -- logme( 'In Exception of create_negotiation() - progress is ' || x_progress || ' sqlcode is ' || SQLCODE);
3148: END add_line_to_negotiation;
3149:
3150: /* Bug 9881440 - Start */