[Home] [Help]
1435: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1436: sel_need_by_start_date IS NOT NULL AND
1437: sel_need_by_date IS NOT NULL AND
1438: clm_need_by_date IS NOT NULL AND
1439: p_contract_type = 'STANDARD'
1440: )
1441:
1442: THEN INTO PON_INTERFACE_ERRORS
1443: (
1470: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1471: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1472: sel_need_by_start_date IS NOT NULL AND
1473: sel_need_by_date IS NULL AND
1474: p_contract_type = 'STANDARD'
1475: )
1476:
1477: THEN INTO PON_INTERFACE_ERRORS
1478: (
1505: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1506: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1507: sel_need_by_start_date IS NULL AND
1508: sel_need_by_date IS NOT NULL AND
1509: p_contract_type = 'STANDARD'
1510: )
1511:
1512: THEN INTO PON_INTERFACE_ERRORS
1513: (
1542: -- no need to check for Group in federal it will always be line
1543: -- NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1544: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1545: clm_need_by_date IS NULL AND
1546: p_contract_type = 'STANDARD' AND
1547: EXISTS (
1548: SELECT
1549: 'X'
1550: FROM
1650: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1651: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1652: sel_need_by_start_date IS NOT NULL AND
1653: sel_need_by_start_date < nvl (p_close_bidding_date, SYSDATE) AND
1654: p_contract_type = 'STANDARD'
1655: )
1656:
1657: THEN INTO PON_INTERFACE_ERRORS
1658: (
1689: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
1690: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1691: clm_need_by_date IS NOT NULL AND
1692: clm_need_by_date < nvl (p_close_bidding_date, SYSDATE) AND
1693: p_contract_type = 'STANDARD'
1694: )
1695:
1696: THEN INTO PON_INTERFACE_ERRORS
1697: (
1728: -- no need to check for info flag for commercial
1729: -- sel_is_info_line <> 'Y' AND -- Clin Slin Changes
1730: sel_need_by_date IS NULL AND
1731: sel_need_by_start_date IS NULL AND
1732: p_contract_type = 'STANDARD' AND
1733: -- for the bug 13580432
1734: g_is_fed <> 'Y' AND
1735: EXISTS (
1736: SELECT
2185: WHEN
2186: (
2187: g_document_type_required_rule('SHIP_TO_LOCATION') = 'Y' AND
2188: g_document_type_names (p_doctype_id) <> PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION AND
2189: p_contract_type = 'STANDARD' AND
2190: NVL (sel_group_type, g_invalid_string) <> 'GROUP' AND
2191: sel_is_info_line <> 'Y' AND -- Clin Slin Changes
2192: nvl (sel_line_origination_code,g_invalid_string) <> 'REQUISITION' AND
2193: sel_ship_to_location_id IS NULL
2420: nvl (sel_line_origination_code,g_invalid_string) <> 'REQUISITION' AND
2421: g_document_type_required_rule('SHIP_TO_LOCATION') = 'Y' AND
2422: ((nvl (sel_purchase_basis,g_invalid_string) <> g_temp_labor AND
2423: g_document_type_names (p_doctype_id) = PON_CONTERMS_UTL_PVT.SRC_REQUEST_FOR_INFORMATION) OR
2424: p_contract_type = 'STANDARD')
2425: )
2426: THEN INTO PON_INTERFACE_ERRORS
2427: (
2428: INTERFACE_TYPE, ERROR_MESSAGE_NAME, REQUEST_ID, BATCH_ID, ENTITY_TYPE,
5757: WHERE paip.auction_header_id = p_auction_header_id
5758: AND paip.line_type_id = plt.line_type_id (+)
5759: AND paip.group_type NOT IN ('GROUP','LOT_LINE');
5760:
5761: ELSIF l_contract_type = 'STANDARD' THEN
5762:
5763: INSERT ALL
5764: WHEN s_clm_info_flag = 'N' AND retainage_rate_percent IS NOT NULL AND (retainage_rate_percent < 0 OR retainage_rate_percent > 100) THEN
5765: INTO pon_interface_errors
6428: END IF;
6429: Raise;
6430: END;
6431:
6432: END IF; -- End of if l_contract_type = 'STANDARD'
6433: END validate_complexwork_lines;
6434:
6435: PROCEDURE validate_payments (
6436: p_auction_header_id IN NUMBER,
7586: validate_complexwork_lines (
7587: p_auction_header_id, p_request_id, l_expiration_date, l_user_id, l_login_id,
7588: l_batch_id, p_fnd_currency_precision);
7589:
7590: IF p_progress_payment_type <> 'NONE' AND p_contract_type = 'STANDARD' THEN
7591: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
7592: FND_LOG.string(log_level => FND_LOG.level_statement,
7593: module => g_module_prefix || 'VALIDATE_LINES',
7594: message => 'Validating payments:');
8031: WHERE AUCTION_HEADER_ID = p_auction_header_id
8032: AND LINE_NUMBER = PAIP.LINE_NUMBER
8033: AND SEQUENCE_NUMBER = -10
8034: AND ROWNUM = 1), 'N'),
8035: -- standard who columns
8036: last_update_date = sysdate,
8037: last_update_login = p_login_id,
8038: last_updated_by = p_user_id
8039: WHERE
8275: PROJECT_AWARD_ID = null,
8276: PROJECT_EXPENDITURE_TYPE = null,
8277: PROJECT_EXP_ORGANIZATION_ID = null,
8278: PROJECT_EXPENDITURE_ITEM_DATE = null,
8279: -- standard who columns
8280: last_update_date = sysdate,
8281: last_update_login = p_login_id,
8282: last_updated_by = p_user_id
8283: WHERE