[Home] [Help]
1969: x_result_set_id => l_result_set_id,
1970: x_result_type => l_result_type);
1971: WHEN c_end_date THEN
1972: -- validate end date not earlier than start date.
1973: PO_VALIDATION_HELPER.start_date_le_end_date(p_calling_module => p_calling_program,
1974: p_start_date_tbl => p_headers.start_date,
1975: p_end_date_tbl => p_headers.end_date,
1976: p_entity_id_tbl => p_headers.interface_id,
1977: p_entity_type => c_entity_type_header,
2012:
2013:
2014: WHEN c_revision_num THEN
2015: -- validate revision_num is zero.
2016: PO_VALIDATION_HELPER.zero(p_calling_module => p_calling_program,
2017: p_value_tbl => p_headers.revision_num,
2018: p_entity_id_tbl => p_headers.interface_id,
2019: p_entity_type => c_entity_type_header,
2020: p_column_name => 'REVISION_NUM',
2075: p_style_id_tbl => p_headers.style_id,
2076: x_result_set_id => l_result_set_id,
2077: x_result_type => l_result_type);
2078: WHEN c_last_update_date THEN
2079: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2080: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.last_update_date),
2081: p_entity_id_tbl => p_headers.interface_id,
2082: p_entity_type => c_entity_type_header,
2083: p_column_name => 'LAST_UPDATE_DATE',
2085: p_validation_id => PO_VAL_CONSTANTS.c_last_update_date,
2086: x_results => x_results,
2087: x_result_type => l_result_type);
2088: WHEN c_last_updated_by THEN
2089: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2090: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.last_updated_by),
2091: p_entity_id_tbl => p_headers.interface_id,
2092: p_entity_type => c_entity_type_header,
2093: p_column_name => 'LAST_UPDATED_BY',
2095: p_validation_id => PO_VAL_CONSTANTS.c_last_updated_by,
2096: x_results => x_results,
2097: x_result_type => l_result_type);
2098: WHEN c_po_release_id THEN
2099: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2100: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.po_release_id),
2101: p_entity_id_tbl => p_headers.interface_id,
2102: p_entity_type => c_entity_type_header,
2103: p_column_name => 'PO_RELEASE_ID',
2109: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id,
2110: x_results => x_results,
2111: x_result_type => l_result_type);
2112: WHEN c_release_num THEN
2113: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2114: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_num),
2115: p_entity_id_tbl => p_headers.interface_id,
2116: p_entity_type => c_entity_type_header,
2117: p_column_name => 'RELEASE_NUM',
2123: p_validation_id => PO_VAL_CONSTANTS.c_release_num,
2124: x_results => x_results,
2125: x_result_type => l_result_type);
2126: WHEN c_release_date THEN
2127: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2128: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_date),
2129: p_entity_id_tbl => p_headers.interface_id,
2130: p_entity_type => c_entity_type_header,
2131: p_column_name => 'RELEASE_DATE',
2137: p_validation_id => PO_VAL_CONSTANTS.c_release_date,
2138: x_results => x_results,
2139: x_result_type => l_result_type);
2140: WHEN c_revised_date THEN
2141: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2142: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.revised_date),
2143: p_entity_id_tbl => p_headers.interface_id,
2144: p_entity_type => c_entity_type_header,
2145: p_column_name => 'REVISED_DATE',
2151: p_validation_id => PO_VAL_CONSTANTS.c_revised_date,
2152: x_results => x_results,
2153: x_result_type => l_result_type);
2154: WHEN c_printed_date THEN
2155: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2156: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.printed_date),
2157: p_entity_id_tbl => p_headers.interface_id,
2158: p_entity_type => c_entity_type_header,
2159: p_column_name => 'PRINTED_DATE',
2165: p_validation_id => PO_VAL_CONSTANTS.c_printed_date,
2166: x_results => x_results,
2167: x_result_type => l_result_type);
2168: WHEN c_closed_date THEN
2169: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2170: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.closed_date),
2171: p_entity_id_tbl => p_headers.interface_id,
2172: p_entity_type => c_entity_type_header,
2173: p_column_name => 'CLOSED_DATE',
2179: p_validation_id => PO_VAL_CONSTANTS.c_closed_date,
2180: x_results => x_results,
2181: x_result_type => l_result_type);
2182: WHEN c_terms_id_header THEN
2183: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
2184: p_terms_id_tbl => p_headers.terms_id,
2185: p_entity_id_tbl => p_headers.interface_id,
2186: p_entity_type => c_entity_type_header,
2187: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,
2208: p_shipping_control_tbl => p_headers.shipping_control,
2209: x_result_set_id => l_result_set_id,
2210: x_result_type => l_result_type);
2211: WHEN c_confirming_order_flag THEN
2212: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,
2213: p_flag_value_tbl => p_headers.confirming_order_flag,
2214: p_entity_id_tbl => p_headers.interface_id,
2215: p_entity_type => c_entity_type_header,
2216: p_column_name => 'CONFIRMING_ORDER_FLAG',
2228: p_acceptance_due_date_tbl => p_headers.acceptance_due_date,
2229: x_results => x_results,
2230: x_result_type => l_result_type);
2231: WHEN c_amount_agreed THEN
2232: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,
2233: p_null_allowed_flag => PO_CORE_S.g_parameter_YES, -- bug5008206
2234: p_value_tbl => p_headers.amount_agreed,
2235: p_entity_id_tbl => p_headers.interface_id,
2236: p_entity_type => c_entity_type_header,
2253: x_result_type => l_result_type
2254: );
2255:
2256: WHEN c_firm_status_lookup_header THEN
2257: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,
2258: p_flag_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar1(p_headers.firm_status_lookup_code),
2259: p_entity_id_tbl => p_headers.interface_id,
2260: p_entity_type => c_entity_type_header,
2261: p_column_name => 'FIRM_STATUS_LOOKUP_CODE',
2284: p_approval_status_tbl => p_headers.approval_status,
2285: x_results => x_results,
2286: x_result_type => l_result_type);
2287: WHEN c_frozen_flag THEN
2288: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,
2289: p_flag_value_tbl => p_headers.frozen_flag,
2290: p_entity_id_tbl => p_headers.interface_id,
2291: p_entity_type => c_entity_type_header,
2292: p_column_name => 'FROZEN_FLAG',
2308: p_amount_to_encumber_tbl => p_headers.amount_to_encumber,
2309: x_results => x_results,
2310: x_result_type => l_result_type);
2311: WHEN c_quote_warning_delay THEN
2312: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2313: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.quote_warning_delay),
2314: p_entity_id_tbl => p_headers.interface_id,
2315: p_entity_type => c_entity_type_header,
2316: p_column_name => 'QUOTE_WARNING_DELAY',
2322: p_validation_id => PO_VAL_CONSTANTS.c_quote_warning_delay,
2323: x_results => x_results,
2324: x_result_type => l_result_type);
2325: WHEN c_approval_required_flag THEN
2326: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2327: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.approval_required_flag),
2328: p_entity_id_tbl => p_headers.interface_id,
2329: p_entity_type => c_entity_type_header,
2330: p_column_name => 'APPROVAL_REQUIRED_FLAG',
2722: -- Bug 5070210 End
2723:
2724: -- Bug 7516824: Validate PO_LINES DFF
2725: WHEN c_line_dff_validate THEN
2726: PO_VALIDATION_HELPER.validate_desc_flex(
2727: p_calling_module => p_calling_program,
2728: p_id_tbl => p_lines.po_line_id,
2729: p_desc_flex_name => 'PO_LINES',
2730: p_attribute_category_tbl => p_lines.attribute_category,
3115: WHEN c_negotiated_by_preparer_null THEN
3116: --------------------------------------------------------------------------------------
3117: -- Negotiated by preparer flag must be Null for Quotation.
3118: --------------------------------------------------------------------------------------
3119: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3120: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
3121: p_entity_id_tbl => p_lines.interface_id,
3122: p_entity_type => c_entity_type_line,
3123: p_column_name => 'NEGOTIATED_BY_PREPARER',
3129: x_results => x_results,
3130: x_result_type => l_result_type);
3131: WHEN c_category_id_null THEN
3132: -- Validate category_id cannot be Null
3133: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
3134: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.category_id),
3135: p_entity_id_tbl => p_lines.interface_id,
3136: p_entity_type => c_entity_type_line,
3137: p_column_name => 'CATEGORY_ID',
3144: x_results => x_results,
3145: x_result_type => l_result_type);
3146: WHEN c_ip_category_id_null THEN
3147: -- Validate ip_category_id is empty
3148: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3149: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.ip_category_id),
3150: p_entity_id_tbl => p_lines.interface_id,
3151: p_entity_type => c_entity_type_line,
3152: p_column_name => 'IP_CATEGORY_ID',
3157: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.ip_category_id),
3158: x_results => x_results,
3159: x_result_type => l_result_type);
3160: WHEN c_line_secondary_uom THEN
3161: PO_VALIDATION_HELPER.secondary_unit_of_measure(p_id_tbl => p_lines.interface_id,
3162: p_entity_type => c_entity_type_line,
3163: p_secondary_unit_of_meas_tbl => p_lines.secondary_unit_of_measure,
3164: p_item_id_tbl => p_lines.item_id,
3165: p_item_tbl => p_lines.item,
3168: p_create_or_update_item_flag => l_create_or_update_item,
3169: x_results => x_results,
3170: x_result_type => l_result_type);
3171: WHEN c_line_secondary_quantity THEN
3172: PO_VALIDATION_HELPER.secondary_quantity(p_id_tbl => p_lines.interface_id,
3173: p_entity_type => c_entity_type_line,
3174: p_secondary_quantity_tbl => p_lines.secondary_quantity,
3175: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3176: p_item_id_tbl => p_lines.item_id,
3180: p_create_or_update_item_flag => l_create_or_update_item,
3181: x_results => x_results,
3182: x_result_type => l_result_type);
3183: WHEN c_line_preferred_grade THEN
3184: PO_VALIDATION_HELPER.preferred_grade(p_id_tbl => p_lines.interface_id,
3185: p_entity_type => c_entity_type_line,
3186: p_preferred_grade_tbl => p_lines.preferred_grade,
3187: p_item_id_tbl => p_lines.item_id,
3188: p_item_tbl => p_lines.item,
3192: x_results => x_results,
3193: x_result_set_id => l_result_set_id,
3194: x_result_type => l_result_type);
3195: WHEN c_release_num_null THEN
3196: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3197: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.release_num),
3198: p_entity_id_tbl => p_lines.interface_id,
3199: p_entity_type => c_entity_type_line,
3200: p_column_name => 'RELEASE_NUM',
3206: p_validation_id => PO_VAL_CONSTANTS.c_release_num_null,
3207: x_results => x_results,
3208: x_result_type => l_result_type);
3209: WHEN c_po_release_id_null THEN
3210: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3211: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.po_release_id),
3212: p_entity_id_tbl => p_lines.interface_id,
3213: p_entity_type => c_entity_type_line,
3214: p_column_name => 'PO_RELEASE_ID',
3220: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id_null,
3221: x_results => x_results,
3222: x_result_type => l_result_type);
3223: WHEN c_source_shipment_id_null THEN
3224: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3225: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.source_shipment_id),
3226: p_entity_id_tbl => p_lines.interface_id,
3227: p_entity_type => c_entity_type_line,
3228: p_column_name => 'SOURCE_SHIPMENT_ID',
3233: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.source_shipment_id),
3234: x_results => x_results,
3235: x_result_type => l_result_type);
3236: WHEN c_contract_num_null THEN
3237: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3238: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_num),
3239: p_entity_id_tbl => p_lines.interface_id,
3240: p_entity_type => c_entity_type_line,
3241: p_column_name => 'CONTRACT_NUM',
3246: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_num),
3247: x_results => x_results,
3248: x_result_type => l_result_type);
3249: WHEN c_contract_id_null THEN
3250: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3251: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_id),
3252: p_entity_id_tbl => p_lines.interface_id,
3253: p_entity_type => c_entity_type_line,
3254: p_column_name => 'CONTRACT_ID',
3259: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_id),
3260: x_results => x_results,
3261: x_result_type => l_result_type);
3262: WHEN c_type_1099_null THEN
3263: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3264: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.type_1099),
3265: p_entity_id_tbl => p_lines.interface_id,
3266: p_entity_type => c_entity_type_line,
3267: p_column_name => 'TYPE_1099',
3272: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.type_1099),
3273: x_results => x_results,
3274: x_result_type => l_result_type);
3275: WHEN c_closed_code_null THEN
3276: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3277: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_code),
3278: p_entity_id_tbl => p_lines.interface_id,
3279: p_entity_type => c_entity_type_line,
3280: p_column_name => 'CLOSED_CODE',
3285: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_code),
3286: x_results => x_results,
3287: x_result_type => l_result_type);
3288: WHEN c_closed_date_null THEN
3289: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3290: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_date),
3291: p_entity_id_tbl => p_lines.interface_id,
3292: p_entity_type => c_entity_type_line,
3293: p_column_name => 'CLOSED_DATE',
3299: p_validation_id => PO_VAL_CONSTANTS.c_closed_date_null,
3300: x_results => x_results,
3301: x_result_type => l_result_type);
3302: WHEN c_closed_by_null THEN
3303: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3304: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_by),
3305: p_entity_id_tbl => p_lines.interface_id,
3306: p_entity_type => c_entity_type_line,
3307: p_column_name => 'CLOSED_BY',
3312: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_by),
3313: x_results => x_results,
3314: x_result_type => l_result_type);
3315: WHEN c_over_tolerance_err_flag_null THEN
3316: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3317: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.over_tolerance_error_flag),
3318: p_entity_id_tbl => p_lines.interface_id,
3319: p_entity_type => c_entity_type_line,
3320: p_column_name => 'OVER_TOLERANCE_ERROR_FLAG',
3326: p_validation_id => PO_VAL_CONSTANTS.c_over_tolerance_err_flag_null,
3327: x_results => x_results,
3328: x_result_type => l_result_type);
3329: WHEN c_committed_amount_null THEN
3330: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3331: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.committed_amount),
3332: p_entity_id_tbl => p_lines.interface_id,
3333: p_entity_type => c_entity_type_line,
3334: p_column_name => 'COMMITTED_AMOUNT',
3340: p_validation_id => PO_VAL_CONSTANTS.c_committed_amount_null,
3341: x_results => x_results,
3342: x_result_type => l_result_type);
3343: WHEN c_allow_price_override_null THEN
3344: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3345: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.allow_price_override_flag),
3346: p_entity_id_tbl => p_lines.interface_id,
3347: p_entity_type => c_entity_type_line,
3348: p_column_name => 'ALLOW_PRICE_OVERRIDE_FLAG',
3354: p_validation_id => PO_VAL_CONSTANTS.c_allow_price_override_null,
3355: x_results => x_results,
3356: x_result_type => l_result_type);
3357: WHEN c_negotiated_by_preparer_null THEN
3358: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3359: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
3360: p_entity_id_tbl => p_lines.interface_id,
3361: p_entity_type => c_entity_type_line,
3362: p_column_name => 'NEGOTIATED_BY_PREPARER_FLAG',
3368: p_validation_id => PO_VAL_CONSTANTS.c_negotiated_by_preparer_null,
3369: x_results => x_results,
3370: x_result_type => l_result_type);
3371: WHEN c_capital_expense_flag_null THEN
3372: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3373: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.capital_expense_flag),
3374: p_entity_id_tbl => p_lines.interface_id,
3375: p_entity_type => c_entity_type_line,
3376: p_column_name => 'CAPITAL_EXPENSE_FLAG',
3382: p_validation_id => PO_VAL_CONSTANTS.c_capital_expense_flag_null,
3383: x_results => x_results,
3384: x_result_type => l_result_type);
3385: WHEN c_min_release_amount_null THEN
3386: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3387: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.min_release_amount),
3388: p_entity_id_tbl => p_lines.interface_id,
3389: p_entity_type => c_entity_type_line,
3390: p_column_name => 'MIN_RELEASE_AMOUNT',
3397: x_results => x_results,
3398: x_result_type => l_result_type);
3399: WHEN c_qty_rcv_exception_code_null THEN
3400: IF l_create_or_update_item <> 'Y' THEN
3401: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3402: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.qty_rcv_exception_code),
3403: p_entity_id_tbl => p_lines.interface_id,
3404: p_entity_type => c_entity_type_line,
3405: p_column_name => 'QTY_RCV_EXCEPTION_CODE',
3412: x_result_type => l_result_type);
3413: END IF;
3414: WHEN c_market_price_null THEN
3415: IF l_create_or_update_item <> 'Y' THEN
3416: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3417: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.market_price),
3418: p_entity_id_tbl => p_lines.interface_id,
3419: p_entity_type => c_entity_type_line,
3420: p_column_name => 'MARKET_PRICE',
3636: );
3637:
3638: -- Bug 7516824: Validate PO_LINE_LOCATIONS DFF
3639: WHEN c_ship_dff_validate THEN
3640: PO_VALIDATION_HELPER.validate_desc_flex(
3641: p_calling_module => p_calling_program,
3642: p_id_tbl => p_line_locations.line_location_id,
3643: p_desc_flex_name => 'PO_LINE_LOCATIONS',
3644: p_attribute_category_tbl => p_line_locations.attribute_category,
3712: x_result_set_id => l_result_set_id,
3713: x_results => x_results,
3714: x_result_type => l_result_type);
3715: WHEN c_terms_id_line_loc THEN
3716: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
3717: p_terms_id_tbl => p_line_locations.terms_id,
3718: p_entity_id_tbl => p_line_locations.interface_id,
3719: p_entity_type => c_entity_type_line_location,
3720: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_line_loc,
3869: p_operating_unit => l_operating_unit,
3870: x_result_set_id => l_result_set_id,
3871: x_result_type => l_result_type);
3872: WHEN c_line_loc_secondary_uom THEN
3873: PO_VALIDATION_HELPER.secondary_unit_of_measure(p_id_tbl => p_line_locations.interface_id,
3874: p_entity_type => c_entity_type_line_location,
3875: p_secondary_unit_of_meas_tbl => p_line_locations.secondary_unit_of_measure,
3876: p_item_id_tbl => p_line_locations.item_id,
3877: p_item_tbl => p_line_locations.item,
3880: p_create_or_update_item_flag => l_create_or_update_item,
3881: x_results => x_results,
3882: x_result_type => l_result_type);
3883: WHEN c_line_loc_secondary_quantity THEN
3884: PO_VALIDATION_HELPER.secondary_quantity(p_id_tbl => p_line_locations.interface_id,
3885: p_entity_type => c_entity_type_line_location,
3886: p_secondary_quantity_tbl => p_line_locations.secondary_quantity,
3887: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
3888: p_item_id_tbl => p_line_locations.item_id,
3892: p_create_or_update_item_flag => l_create_or_update_item,
3893: x_results => x_results,
3894: x_result_type => l_result_type);
3895: WHEN c_line_loc_preferred_grade THEN
3896: PO_VALIDATION_HELPER.preferred_grade(p_id_tbl => p_line_locations.interface_id,
3897: p_entity_type => c_entity_type_line_location,
3898: p_preferred_grade_tbl => p_line_locations.preferred_grade,
3899: p_item_id_tbl => p_line_locations.item_id,
3900: p_item_tbl => p_line_locations.item,
3904: x_results => x_results,
3905: x_result_set_id => l_result_set_id,
3906: x_result_type => l_result_type);
3907: WHEN c_firm_flag_null THEN
3908: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3909: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.firm_status_lookup_code),
3910: p_entity_id_tbl => p_line_locations.interface_id,
3911: p_entity_type => c_entity_type_line_location,
3912: p_column_name => 'FIRM_FLAG',
3918: p_validation_id => PO_VAL_CONSTANTS.c_firm_flag_null,
3919: x_results => x_results,
3920: x_result_type => l_result_type);
3921: WHEN c_freight_carrier_null THEN
3922: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3923: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_carrier),
3924: p_entity_id_tbl => p_line_locations.interface_id,
3925: p_entity_type => c_entity_type_line_location,
3926: p_column_name => 'FREIGHT_CARRIER',
3932: p_validation_id => PO_VAL_CONSTANTS.c_freight_carrier_null,
3933: x_results => x_results,
3934: x_result_type => l_result_type);
3935: WHEN c_fob_lookup_code_null THEN
3936: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3937: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.fob_lookup_code),
3938: p_entity_id_tbl => p_line_locations.interface_id,
3939: p_entity_type => c_entity_type_line_location,
3940: p_column_name => 'FOB_LOOKUP_CODE',
3946: p_validation_id => PO_VAL_CONSTANTS.c_fob_lookup_code_null,
3947: x_results => x_results,
3948: x_result_type => l_result_type);
3949: WHEN c_freight_terms_lookup_null THEN
3950: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3951: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_terms_lookup_code),
3952: p_entity_id_tbl => p_line_locations.interface_id,
3953: p_entity_type => c_entity_type_line_location,
3954: p_column_name => 'FREIGHT_TERMS_LOOKUP_CODE',
3961: x_results => x_results,
3962: x_result_type => l_result_type);
3963: WHEN c_qty_rcv_tolerance_null THEN
3964: IF l_create_or_update_item <> 'Y' THEN
3965: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3966: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.qty_rcv_tolerance),
3967: p_entity_id_tbl => p_line_locations.interface_id,
3968: p_entity_type => c_entity_type_line_location,
3969: p_column_name => 'QTY_RCV_TOLERANCE',
3977: x_result_type => l_result_type);
3978: END IF;
3979: WHEN c_receipt_required_flag_null THEN
3980: IF l_create_or_update_item <> 'Y' THEN
3981: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3982: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_required_flag),
3983: p_entity_id_tbl => p_line_locations.interface_id,
3984: p_entity_type => c_entity_type_line_location,
3985: p_column_name => 'RECEIPT_REQUIRED_FLAG',
3993: x_result_type => l_result_type);
3994: END IF;
3995: WHEN c_inspection_reqd_flag_null THEN
3996: IF l_create_or_update_item <> 'Y' THEN
3997: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3998: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.inspection_required_flag),
3999: p_entity_id_tbl => p_line_locations.interface_id,
4000: p_entity_type => c_entity_type_line_location,
4001: p_column_name => 'INSPECTION_REQUIRED_FLAG',
4005: x_result_type => l_result_type);
4006: END IF;
4007: WHEN c_receipt_days_exception_null THEN
4008: IF l_create_or_update_item <> 'Y' THEN
4009: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4010: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_days_exception_code),
4011: p_entity_id_tbl => p_line_locations.interface_id,
4012: p_entity_type => c_entity_type_line_location,
4013: p_column_name => 'RECEIPT_DAYS_EXCEPTION_CODE',
4021: x_result_type => l_result_type);
4022: END IF;
4023: WHEN c_invoice_close_toler_null THEN
4024: IF l_create_or_update_item <> 'Y' THEN
4025: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4026: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.invoice_close_tolerance),
4027: p_entity_id_tbl => p_line_locations.interface_id,
4028: p_entity_type => c_entity_type_line_location,
4029: p_column_name => 'INVOICE_CLOSE_TOLERANCE',
4037: x_result_type => l_result_type);
4038: END IF;
4039: WHEN c_receive_close_toler_null THEN
4040: IF l_create_or_update_item <> 'Y' THEN
4041: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4042: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receive_close_tolerance),
4043: p_entity_id_tbl => p_line_locations.interface_id,
4044: p_entity_type => c_entity_type_line_location,
4045: p_column_name => 'RECEIVE_CLOSE_TOLERANCE',
4053: x_result_type => l_result_type);
4054: END IF;
4055: WHEN c_days_early_rcpt_allowed_null THEN
4056: IF l_create_or_update_item <> 'Y' THEN
4057: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4058: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_early_receipt_allowed),
4059: p_entity_id_tbl => p_line_locations.interface_id,
4060: p_entity_type => c_entity_type_line_location,
4061: p_column_name => 'DAYS_EARLY_RECEIPT_ALLOWED',
4069: x_result_type => l_result_type);
4070: END IF;
4071: WHEN c_days_late_rcpt_allowed_null THEN
4072: IF l_create_or_update_item <> 'Y' THEN
4073: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4074: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_late_receipt_allowed),
4075: p_entity_id_tbl => p_line_locations.interface_id,
4076: p_entity_type => c_entity_type_line_location,
4077: p_column_name => 'DAYS_LATE_RECEIPT_ALLOWED',
4085: x_result_type => l_result_type);
4086: END IF;
4087: WHEN c_enfrce_ship_to_loc_code_null THEN
4088: IF l_create_or_update_item <> 'Y' THEN
4089: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4090: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.enforce_ship_to_location_code),
4091: p_entity_id_tbl => p_line_locations.interface_id,
4092: p_entity_type => c_entity_type_line_location,
4093: p_column_name => 'ENFORCE_SHIP_TO_LOCATION_CODE',
4101: x_result_type => l_result_type);
4102: END IF;
4103: WHEN c_allow_sub_receipts_flag_null THEN
4104: IF l_create_or_update_item <> 'Y' THEN
4105: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4106: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.allow_substitute_receipts_flag),
4107: p_entity_id_tbl => p_line_locations.interface_id,
4108: p_entity_type => c_entity_type_line_location,
4109: p_column_name => 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
4117: x_result_type => l_result_type);
4118: END IF;
4119: WHEN c_receiving_routing_null THEN
4120: IF l_create_or_update_item <> 'Y' THEN
4121: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4122: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receiving_routing_id),
4123: p_entity_id_tbl => p_line_locations.interface_id,
4124: p_entity_type => c_entity_type_line_location,
4125: p_column_name => 'RECEIVING_ROUTING_ID',
4132: x_results => x_results,
4133: x_result_type => l_result_type);
4134: END IF;
4135: WHEN c_need_by_date_null THEN
4136: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4137: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.need_by_date),
4138: p_entity_id_tbl => p_line_locations.interface_id,
4139: p_entity_type => c_entity_type_line_location,
4140: p_column_name => 'NEED_BY_DATE',
4146: p_validation_id => PO_VAL_CONSTANTS.c_need_by_date_null,
4147: x_results => x_results,
4148: x_result_type => l_result_type);
4149: WHEN c_promised_date_null THEN
4150: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4151: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.promised_date),
4152: p_entity_id_tbl => p_line_locations.interface_id,
4153: p_entity_type => c_entity_type_line_location,
4154: p_column_name => 'PROMISED_DATE',
4466: );
4467:
4468: -- Bug 7516824: Validate PO_DISTRIBUTIONS DFF
4469: WHEN c_dist_dff_validate THEN
4470: PO_VALIDATION_HELPER.validate_desc_flex(
4471: p_calling_module => p_calling_program,
4472: p_id_tbl => p_distributions.po_distribution_id,
4473: p_desc_flex_name => 'PO_DISTRIBUTIONS',
4474: p_attribute_category_tbl => p_distributions.attribute_category,