[Home] [Help]
534: , last_update_date
535: , last_update_login
536: )
537: VALUES ( 'AWARDBID'
538: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
539: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
540: , s_award_quantity
541: , 'NUM'
542: , 'PON_AWARD_ITEMS_INTERFACE'
535: , last_update_login
536: )
537: VALUES ( 'AWARDBID'
538: , decode(l_contract_type, 'STANDARD', fnd_message.get_string('PON','PON_AUCTION_AWARD_QTY'), fnd_message.get_string('PON','PON_AUCTS_AGREED_QUANTITY'))
539: , decode(l_contract_type, 'STANDARD', 'PON_AUC_AWARD_QTY_COL_NEG', 'PON_AUC_QTY_AGREED_COL_NEG')
540: , s_award_quantity
541: , 'NUM'
542: , 'PON_AWARD_ITEMS_INTERFACE'
543: , s_batch_id
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
564: THEN
728: po_line_types_tl pltt
729: WHERE paii.batch_id = p_batch_id
730: AND paii.award_status = 'Y'
731: AND ah.auction_header_id = paii.auction_header_id
732: AND ah.contract_type = 'STANDARD'
733: AND ai.line_number = paii.auction_line_number
734: AND ai.auction_header_id = paii.auction_header_id
735: AND ai.order_type_lookup_code = 'FIXED PRICE'
736: AND ai.line_type_id = pltt.line_type_id (+)
825: WHERE batch_id = p_batch_id
826: AND pipi.line_type_id = plt.line_type_id (+)
827: AND pipi.group_type NOT IN ('GROUP','LOT_LINE');
828:
829: ELSIF p_contract_type = 'STANDARD' THEN
830:
831: INSERT ALL
832: WHEN S_CLM_INFO_FLAG = 'N' AND
833: retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
1337: FROM FND_USER fu
1338: WHERE pipi.work_approver_user_name = fu.user_name)
1339: WHERE batch_id = p_batch_id;
1340:
1341: END IF; -- End of if p_contract_type = 'STANDARD'
1342:
1343: --Validate project fields with PATC
1344: FOR l_proj_record IN l_proj_cursor LOOP
1345: PON_NEGOTIATION_PUBLISH_PVT.VALIDATE_PROJECTS_DETAILS (
1894: --
1895: -- Begin major services lines validation
1896: --
1897: -- First, make sure no services lines
1898: -- are on a standard outcome document
1899: --
1900: IF(p_contract_type = 'STANDARD') THEN
1901: --
1902: INSERT INTO pon_interface_errors
1896: --
1897: -- First, make sure no services lines
1898: -- are on a standard outcome document
1899: --
1900: IF(p_contract_type = 'STANDARD') THEN
1901: --
1902: INSERT INTO pon_interface_errors
1903: (interface_type,
1904: column_name,
1909: interface_line_id)
1910: SELECT interface_type,
1911: fnd_message.get_string('PON','PON_AUC_LINE_TYPE'),
1912: line_type,
1913: 'PON_STANDARD_LINE_TYPES',
1914: 'PON_ITEM_PRICES_INTERFACE',
1915: batch_id,
1916: interface_line_id
1917: FROM pon_item_prices_interface
2399: , interface_line_id
2400: )
2401: SELECT
2402: INTERFACE_TYPE
2403: , fnd_message.get_string('PON',decode(p_contract_type,'STANDARD','PON_AUCTS_QUANTITY','PON_AUCTS_EST_QUANTITY'))
2404: , quantity
2405: , 'PON_AUC_LINE_QUAN_ERR'
2406: , 'PON_ITEM_PRICES_INTERFACE'
2407: , BATCH_ID
2828: -- bug 3353248
2829: -- check quantity can't be null under certain conditions.
2830: --
2831: --
2832: if (p_contract_type = 'STANDARD' or p_contract_type is null) then
2833: insert into PON_INTERFACE_ERRORS
2834: (interface_type,
2835: column_name,
2836: error_message_name,
2951: batch_id,
2952: interface_line_id
2953: from pon_item_prices_interface
2954: where ( (nvl(l_is_fed,'N')='Y') and
2955: (p_contract_type = 'STANDARD') and
2956: ( (clm_need_by_date is not null and need_by_start_date is not null and need_by_date is not null)
2957: /* Bug : 13700330 : Need By or POP dates are not mandatory for non-inventory lines. */
2958: --or (clm_need_by_date is null and ( (need_by_start_date is null and need_by_date is null))
2959: or (clm_need_by_date is not null and ( (need_by_start_date is null and need_by_date is not null)
2983: batch_id,
2984: interface_line_id
2985: from pon_item_prices_interface
2986: where ( (nvl(l_is_fed,'N')='Y') and
2987: (p_contract_type = 'STANDARD') and
2988: ( (clm_need_by_date is null and (need_by_start_date is null and need_by_date is not null)))
2989: )
2990: and batch_id = p_batch_id
2991: and nvl(clm_info_flag,'N') = 'N';
3009: batch_id,
3010: interface_line_id
3011: from pon_item_prices_interface
3012: where ( (nvl(l_is_fed,'N')='Y') and
3013: (p_contract_type = 'STANDARD') and
3014: ( (clm_need_by_date is null and (need_by_start_date is not null and need_by_date is null)))
3015: )
3016: and batch_id = p_batch_id
3017: and nvl(clm_info_flag,'N') = 'N';
3104: --
3105: -- need by required for planned inventory items for SPO
3106: /*Bug : 13700330 : We need this validation for clm also.
3107: For clm, clm_need_by_date field is mandatory for inventory item lines. */
3108: IF(p_contract_type = 'STANDARD') THEN --and nvl(l_is_fed,'N')<>'Y') THEN
3109: insert into PON_INTERFACE_ERRORS
3110: (interface_type,
3111: column_name,
3112: error_value,
3217:
3218: END IF;
3219: --
3220: -- Ship to location, validating non null, auction only --
3221: -- The validation is needed for standard po only as ship-to location is
3222: -- removed for blanket/contract purchase agreement.
3223: --
3224: IF (is_valid_rule(p_doctype_Id, 'SHIP_TO_LOCATION') and (p_contract_type is null or p_contract_type = 'STANDARD')) THEN
3225:
3220: -- Ship to location, validating non null, auction only --
3221: -- The validation is needed for standard po only as ship-to location is
3222: -- removed for blanket/contract purchase agreement.
3223: --
3224: IF (is_valid_rule(p_doctype_Id, 'SHIP_TO_LOCATION') and (p_contract_type is null or p_contract_type = 'STANDARD')) THEN
3225:
3226: IF (is_required_rule(p_doctype_Id, 'SHIP_TO_LOCATION')) THEN
3227: insert into PON_INTERFACE_ERRORS
3228: ( interface_type
3601: and batch_id = p_batch_id;
3602:
3603:
3604: --R12 - Added for Complex work
3605: IF p_contract_type IN ('STANDARD','CONTRACT') AND l_progress_payment_type <> 'NONE' THEN
3606: -- Call complex work validations only if progress_payment_type
3607: -- is NOT NONE
3608: validate_complexwork(p_batch_id, l_progress_payment_type, p_contract_type, l_advance_negotiable_flag, l_recoupment_negotiable_flag);
3609: END IF;