[Home] [Help]
510: , last_update_date
511: , last_update_login
512: )
513: VALUES ( 'AWARDBID'
514: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
515: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
516: , s_award_quantity
517: , 'NUM'
518: , 'PON_AWARD_ITEMS_INTERFACE'
511: , last_update_login
512: )
513: VALUES ( 'AWARDBID'
514: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
515: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
516: , s_award_quantity
517: , 'NUM'
518: , 'PON_AWARD_ITEMS_INTERFACE'
519: , s_batch_id
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
540: THEN
704: po_line_types_tl pltt
705: WHERE paii.batch_id = p_batch_id
706: AND paii.award_status = 'Y'
707: AND ah.auction_header_id = paii.auction_header_id
708: AND ah.contract_type = 'STANDARD'
709: AND ai.line_number = paii.auction_line_number
710: AND ai.auction_header_id = paii.auction_header_id
711: AND ai.order_type_lookup_code = 'FIXED PRICE'
712: AND ai.line_type_id = pltt.line_type_id (+)
793: WHERE batch_id = p_batch_id
794: AND pipi.line_type_id = plt.line_type_id (+)
795: AND pipi.group_type NOT IN ('GROUP','LOT_LINE');
796:
797: ELSIF p_contract_type = 'STANDARD' THEN
798:
799: INSERT ALL
800: WHEN retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
801: INTO pon_interface_errors
1286: FROM FND_USER fu
1287: WHERE pipi.work_approver_user_name = fu.user_name)
1288: WHERE batch_id = p_batch_id;
1289:
1290: END IF; -- End of if p_contract_type = 'STANDARD'
1291:
1292: --Validate project fields with PATC
1293: FOR l_proj_record IN l_proj_cursor LOOP
1294: PON_NEGOTIATION_PUBLISH_PVT.VALIDATE_PROJECTS_DETAILS (
1704: --
1705: -- Begin major services lines validation
1706: --
1707: -- First, make sure no services lines
1708: -- are on a standard outcome document
1709: --
1710: IF(p_contract_type = 'STANDARD') THEN
1711: --
1712: INSERT INTO pon_interface_errors
1706: --
1707: -- First, make sure no services lines
1708: -- are on a standard outcome document
1709: --
1710: IF(p_contract_type = 'STANDARD') THEN
1711: --
1712: INSERT INTO pon_interface_errors
1713: (interface_type,
1714: column_name,
1719: interface_line_id)
1720: SELECT interface_type,
1721: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1722: line_type,
1723: 'PON_STANDARD_LINE_TYPES',
1724: 'PON_ITEM_PRICES_INTERFACE',
1725: batch_id,
1726: interface_line_id
1727: FROM pon_item_prices_interface
2200: , interface_line_id
2201: )
2202: SELECT
2203: INTERFACE_TYPE
2204: , fnd_message.get_string('PON',decode(p_contract_type,'STANDARD','PON_AUCTS_QUANTITY','PON_AUCTS_EST_QUANTITY'))
2205: , quantity
2206: , 'PON_AUC_LINE_QUAN_ERR'
2207: , 'PON_ITEM_PRICES_INTERFACE'
2208: , BATCH_ID
2623: -- bug 3353248
2624: -- check quantity can't be null under certain conditions.
2625: --
2626: --
2627: if (p_contract_type = 'STANDARD' or p_contract_type is null) then
2628: insert into PON_INTERFACE_ERRORS
2629: (interface_type,
2630: column_name,
2631: error_message_name,
2785: where need_by_date < need_by_start_date
2786: and batch_id = p_batch_id;
2787: --
2788: -- need by required for planned inventory items for SPO
2789: IF(p_contract_type = 'STANDARD') THEN
2790: insert into PON_INTERFACE_ERRORS
2791: (interface_type,
2792: column_name,
2793: error_value,
2819: END IF;
2820: END IF;
2821: --
2822: -- Ship to location, validating non null, auction only --
2823: -- The validation is needed for standard po only as ship-to location is
2824: -- removed for blanket/contract purchase agreement.
2825: --
2826: IF (is_valid_rule(p_doctype_Id, 'SHIP_TO_LOCATION') and (p_contract_type is null or p_contract_type = 'STANDARD')) THEN
2827:
2822: -- Ship to location, validating non null, auction only --
2823: -- The validation is needed for standard po only as ship-to location is
2824: -- removed for blanket/contract purchase agreement.
2825: --
2826: IF (is_valid_rule(p_doctype_Id, 'SHIP_TO_LOCATION') and (p_contract_type is null or p_contract_type = 'STANDARD')) THEN
2827:
2828: IF (is_required_rule(p_doctype_Id, 'SHIP_TO_LOCATION')) THEN
2829: insert into PON_INTERFACE_ERRORS
2830: ( interface_type
3124: and nvl(price_and_quantity_apply, 'Y') = 'Y'
3125: and batch_id = p_batch_id;
3126:
3127: --R12 - Added for Complex work
3128: IF p_contract_type IN ('STANDARD','CONTRACT') AND l_progress_payment_type <> 'NONE' THEN
3129: -- Call complex work validations only if progress_payment_type
3130: -- is NOT NONE
3131: validate_complexwork(p_batch_id, l_progress_payment_type, p_contract_type, l_advance_negotiable_flag, l_recoupment_negotiable_flag);
3132: END IF;