29: RETURN;
30:
31: END IF;
32:
33: validateAwardBid(p_batch_id, PON_AWARD_PKG.g_xml_upload_mode);
34:
35: -- Check if any errors were present
36: SELECT decode(count(interface_type), 0, 'N', 'Y')
37: INTO l_has_errors
467: , last_update_date
468: , last_update_login
469: )
470: VALUES ( 'AWARDBID'
471: , decode(p_spreadsheet_type, PON_AWARD_PKG.g_xml_upload_mode, fnd_message.get_string('PON','PON_ACCTS_SUPPLIER'), fnd_message.get_string('PON','PON_BIDS_BIDDER' || l_suffix))
472: , 'PON_AWARD_INACTIVE_SUPPLIER'
473: , s_trading_partner_name
474: , 'PON_AWARD_ITEMS_INTERFACE'
475: , s_batch_id
486: , l_login_id
487: )
488: -- VALIDATION #6
489: -- Check if award quantity is > 0 when uploading an XML file
490: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode
491: AND s_award_quantity < 0
492: THEN
493: INTO PON_INTERFACE_ERRORS
494: ( interface_type
531: )
532: -- VALIDATION #7
533: -- Check if award quantity is entered when document is of type SPO, award status is Y and
534: -- an XML file is being uploaded
535: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode
536: AND l_contract_type = 'STANDARD'
537: AND s_order_type_lookup_code = 'QUANTITY'
538: AND s_bid_line_award_status = 'Y'
539: AND s_award_quantity is null