[Home] [Help]
64: --Start Validation procedures
65:
66: /*
67: * Line validations: The following validations involve only the item_prices_all table and not the
68: * po line types table
69: * 1. The group type for a line should be 'GROUP_LINE' or 'LOT_LINE' if the parent_line_number is populated.
70: * The group type for a line should be 'GROUP' or 'LOT' if the parent_line_number is not populated
71: * 2. The item description should not be an empty string if the doc type rules do not allow
72: * 3. The line_type_id should not be null
1503: END val_item_prices_all;
1504:
1505: /*
1506: * Line validations: The following validations involve the item_prices_all table and the
1507: * po line types table.
1508: * 1. Uom code should not be empty for non fixed price items
1509: * 2. Ship to location should not be NULL for an SPO not coming from a req except in case of RFI
1510: * 3. Job id should not be NULL for temp labor lines
1511: * 4. For temp labor based lines the po agreed amount should be a positive number
1894: PAIP.UNIT_TARGET_PRICE sel_unit_target_price,
1895: PAIP.QUANTITY sel_quantity
1896: FROM
1897: PON_AUCTION_ITEM_PRICES_ALL PAIP,
1898: PO_LINE_TYPES_B PLTB
1899: WHERE
1900: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
1901: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;
1902:
1958: sysdate, -- LAST_UPDATE_DATE
1959: p_login_id -- LAST_UPDATE_LOGIN
1960: FROM
1961: PON_AUCTION_ITEM_PRICES_ALL PAIP,
1962: PO_LINE_TYPES_B PLTB
1963: WHERE
1964: AUCTION_HEADER_ID = p_auction_header_id AND
1965: PAIP.LINE_TYPE_ID = PLTB.LINE_TYPE_ID AND
1966: NVL (PAIP.GROUP_TYPE, g_invalid_string) <> 'GROUP' AND
4313: WHEN
4314: (
4315: SELECTED_LINE_ORIGINATION_CODE = 'BLANKET' AND
4316: NOT EXISTS (SELECT 'X'
4317: FROM PO_LINE_TYPES_B
4318: WHERE LINE_TYPE_ID = SELECTED_LINE_TYPE_ID)
4319: )
4320: THEN INTO PON_INTERFACE_ERRORS
4321: (
4437: NVL(FSP.ORG_ID, -9999) = NVL(SELECTED_ORG_ID, -9999) AND
4438: (MSI.OUTSIDE_OPERATION_FLAG <> 'Y'
4439: OR (MSI.OUTSIDE_OPERATION_FLAG = 'Y'
4440: AND EXISTS (SELECT 'OP LINE TYPE'
4441: FROM PO_LINE_TYPES_B PLT
4442: WHERE PLT.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID
4443: AND PLT.OUTSIDE_OPERATION_FLAG ='Y') ) ) )
4444: )
4445: THEN INTO PON_INTERFACE_ERRORS
4537: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4538: MTL_SYSTEM_ITEMS MSI,
4539: MTL_ITEM_REVISIONS MIR,
4540: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
4541: PO_LINE_TYPES_B PLTB
4542: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4543: FSP.ORG_ID = SELECTED_ORG_ID AND
4544: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND
4545: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) AND
4656: (SELECT OOD.ORGANIZATION_ID
4657: FROM ORG_ORGANIZATION_DEFINITIONS OOD,
4658: MTL_SYSTEM_ITEMS_KFV MSI,
4659: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
4660: PO_LINE_TYPES_B PLTB
4661: WHERE OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND
4662: FSP.ORG_ID = SELECTED_ORG_ID AND
4663: PLTB.LINE_TYPE_ID = SELECTED_LINE_TYPE_ID AND
4664: SYSDATE < NVL(OOD.DISABLE_DATE,SYSDATE+1) AND
4815: p_user_id, -- LAST_UPDATED_BY
4816: sysdate, -- LAST_UPDATE_DATE
4817: p_login_id -- LAST_UPDATE_LOGIN
4818: FROM
4819: PO_LINE_TYPES_B PLTB,
4820: PON_AUCTION_ITEM_PRICES_ALL PAIP
4821: WHERE
4822: PAIP.AUCTION_HEADER_ID=p_auction_header_id AND
4823: PLTB.LINE_TYPE_ID= PAIP.LINE_TYPE_ID AND
4900: paip.ORDER_TYPE_LOOKUP_CODE,
4901: paip.line_number s_line_number,
4902: plt.outside_operation_flag po_outside_operation_flag
4903: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
4904: PO_LINE_TYPES plt
4905: WHERE paip.auction_header_id = p_auction_header_id
4906: AND paip.line_type_id = plt.line_type_id (+)
4907: AND paip.group_type NOT IN ('GROUP','LOT_LINE');
4908:
5288: paip.LINE_ORIGINATION_CODE,
5289: paip.has_payments_flag,
5290: plt.outside_operation_flag po_outside_operation_flag
5291: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
5292: PO_LINE_TYPES plt
5293: WHERE paip.auction_header_id = p_auction_header_id
5294: AND paip.line_type_id = plt.line_type_id (+)
5295: AND paip.group_type NOT IN ('GROUP','LOT_LINE');
5296:
6487:
6488: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6489: FND_LOG.string(log_level => FND_LOG.level_statement,
6490: module => g_module_prefix || l_module_name,
6491: message => 'Validating Lines: Validations that do not require join with po line types');
6492: END IF; --}
6493:
6494: -- Validations that are done in this procedure do not require a join with
6495: -- po_line_types_b
6491: message => 'Validating Lines: Validations that do not require join with po line types');
6492: END IF; --}
6493:
6494: -- Validations that are done in this procedure do not require a join with
6495: -- po_line_types_b
6496: val_item_prices_all (
6497: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
6498: l_login_id, l_batch_id, p_auction_currency_precision,
6499: p_fnd_currency_precision, p_close_bidding_date, p_contract_type,
6502:
6503: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6504: FND_LOG.string(log_level => FND_LOG.level_statement,
6505: module => g_module_prefix || l_module_name,
6506: message => 'Validating Lines: Validations that require join with po line types');
6507: END IF; --}
6508:
6509: -- Validations that are done in this procedure require a join with
6510: -- po_line_types_b
6506: message => 'Validating Lines: Validations that require join with po line types');
6507: END IF; --}
6508:
6509: -- Validations that are done in this procedure require a join with
6510: -- po_line_types_b
6511: val_item_prices_po_lines (
6512: p_auction_header_id, p_request_id, l_expiration_date, l_user_id,
6513: l_login_id, l_batch_id, p_doctype_id, p_contract_type, p_global_agreement_flag,
6514: p_auction_currency_precision, p_fnd_currency_precision);