APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PON_AWARD_PKG

Line 33: validateAwardBid(p_batch_id, PON_AWARD_PKG.g_xml_upload_mode);

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

Line 495: , 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))

491: , last_update_date
492: , last_update_login
493: )
494: VALUES ( 'AWARDBID'
495: , 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))
496: , 'PON_AWARD_INACTIVE_SUPPLIER'
497: , s_trading_partner_name
498: , 'PON_AWARD_ITEMS_INTERFACE'
499: , s_batch_id

Line 514: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode

510: , l_login_id
511: )
512: -- VALIDATION #6
513: -- Check if award quantity is > 0 when uploading an XML file
514: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode
515: AND s_award_quantity < 0
516: THEN
517: INTO PON_INTERFACE_ERRORS
518: ( interface_type

Line 559: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode

555: )
556: -- VALIDATION #7
557: -- Check if award quantity is entered when document is of type SPO, award status is Y and
558: -- an XML file is being uploaded
559: WHEN p_spreadsheet_type = PON_AWARD_PKG.g_xml_upload_mode
560: AND l_contract_type = 'STANDARD'
561: AND s_order_type_lookup_code = 'QUANTITY'
562: AND s_bid_line_award_status = 'Y'
563: AND s_award_quantity is null