[Home] [Help]
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',
2084: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
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',
2094: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
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',
2104: p_message_name => 'PO_PDOI_COLUMN_NULL',
2104: p_message_name => 'PO_PDOI_COLUMN_NULL',
2105: p_token1_name => 'COLUMN_NAME',
2106: p_token1_value => 'PO_RELEASE_ID',
2107: p_token2_name => 'VALUE',
2108: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
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',
2118: p_message_name => 'PO_PDOI_COLUMN_NULL',
2118: p_message_name => 'PO_PDOI_COLUMN_NULL',
2119: p_token1_name => 'COLUMN_NAME',
2120: p_token1_value => 'RELEASE_NUM',
2121: p_token2_name => 'VALUE',
2122: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
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',
2132: p_message_name => 'PO_PDOI_COLUMN_NULL',
2132: p_message_name => 'PO_PDOI_COLUMN_NULL',
2133: p_token1_name => 'COLUMN_NAME',
2134: p_token1_value => 'RELEASE_DATE',
2135: p_token2_name => 'VALUE',
2136: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
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',
2146: p_message_name => 'PO_PDOI_COLUMN_NULL',
2146: p_message_name => 'PO_PDOI_COLUMN_NULL',
2147: p_token1_name => 'COLUMN_NAME',
2148: p_token1_value => 'REVISED_DATE',
2149: p_token2_name => 'VALUE',
2150: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
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',
2160: p_message_name => 'PO_PDOI_COLUMN_NULL',
2160: p_message_name => 'PO_PDOI_COLUMN_NULL',
2161: p_token1_name => 'COLUMN_NAME',
2162: p_token1_value => 'PRINTED_DATE',
2163: p_token2_name => 'VALUE',
2164: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
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',
2174: p_message_name => 'PO_PDOI_COLUMN_NULL',
2174: p_message_name => 'PO_PDOI_COLUMN_NULL',
2175: p_token1_name => 'COLUMN_NAME',
2176: p_token1_value => 'CLOSED_DATE',
2177: p_token2_name => 'VALUE',
2178: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
2217: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2218: p_token1_name => 'COLUMN_NAME',
2219: p_token1_value => 'CONFIRMING_ORDER_FLAG',
2220: p_token2_name => 'VALUE',
2221: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.confirming_order_flag),
2222: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,
2223: x_results => x_results,
2224: x_result_type => l_result_type);
2225: WHEN c_acceptance_due_date THEN
2238: p_message_name => 'PO_PDOI_LT_ZERO',
2239: p_token1_name => 'COLUMN_NAME',
2240: p_token1_value => 'AMOUNT_AGREED',
2241: p_token2_name => 'VALUE',
2242: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.amount_agreed),
2243: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed,
2244: x_results => x_results,
2245: x_result_type => l_result_type);
2246: WHEN c_amount_limit THEN
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',
2262: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2262: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2263: p_token1_name => 'COLUMN_NAME',
2264: p_token1_value => 'FIRM_STATUS_LOOKUP_CODE',
2265: p_token2_name => 'VALUE',
2266: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.firm_status_lookup_code),
2267: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,
2268: x_results => x_results,
2269: x_result_type => l_result_type);
2270: WHEN c_cancel_flag THEN
2293: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2294: p_token1_name => 'COLUMN_NAME',
2295: p_token1_value => 'FROZEN_FLAG',
2296: p_token2_name => 'VALUE',
2297: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.frozen_flag),
2298: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,
2299: x_results => x_results,
2300: x_result_type => l_result_type);
2301: WHEN c_approval_status THEN
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',
2317: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2317: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2318: p_token1_name => 'COLUMN_NAME',
2319: p_token1_value => 'QUOTE_WARNING_DELAY',
2320: p_token2_name => 'VALUE',
2321: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.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
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',
2331: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2331: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2332: p_token1_name => 'COLUMN_NAME',
2333: p_token1_value => 'APPROVAL_REQUIRED_FLAG',
2334: p_token2_name => 'VALUE',
2335: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.approval_required_flag),
2336: p_validation_id => PO_VAL_CONSTANTS.c_approval_required_flag,
2337: x_results => x_results,
2338: x_result_type => l_result_type);
2339:
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',
3124: p_message_name => 'PO_PDOI_COLUMN_NULL',
3124: p_message_name => 'PO_PDOI_COLUMN_NULL',
3125: p_token1_name => 'COLUMN_NAME',
3126: p_token1_value => 'NEGOTIATED_BY_PREPARER',
3127: p_token2_name => 'VALUE',
3128: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
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
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',
3138: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3138: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3139: p_token1_name => 'COLUMN_NAME',
3140: p_token1_value => 'CATEGORY_ID',
3141: p_token2_name => 'VALUE',
3142: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.category_id),
3143: p_validation_id => PO_VAL_CONSTANTS.c_category_id_not_null,
3144: x_results => x_results,
3145: x_result_type => l_result_type);
3146: WHEN c_ip_category_id_null THEN
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',
3153: p_message_name => 'PO_PDOI_COLUMN_NULL',
3153: p_message_name => 'PO_PDOI_COLUMN_NULL',
3154: p_token1_name => 'COLUMN_NAME',
3155: p_token1_value => 'IP_CATEGORY_ID',
3156: p_token2_name => 'VALUE',
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,
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',
3201: p_message_name => 'PO_PDOI_COLUMN_NULL',
3201: p_message_name => 'PO_PDOI_COLUMN_NULL',
3202: p_token1_name => 'COLUMN_NAME',
3203: p_token1_value => 'RELEASE_NUM',
3204: p_token2_name => 'VALUE',
3205: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3215: p_message_name => 'PO_PDOI_COLUMN_NULL',
3215: p_message_name => 'PO_PDOI_COLUMN_NULL',
3216: p_token1_name => 'COLUMN_NAME',
3217: p_token1_value => 'PO_RELEASE_ID',
3218: p_token2_name => 'VALUE',
3219: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3229: p_message_name => 'PO_PDOI_COLUMN_NULL',
3229: p_message_name => 'PO_PDOI_COLUMN_NULL',
3230: p_token1_name => 'COLUMN_NAME',
3231: p_token1_value => 'SOURCE_SHIPMENT_ID',
3232: p_token2_name => 'VALUE',
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,
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',
3242: p_message_name => 'PO_PDOI_COLUMN_NULL',
3242: p_message_name => 'PO_PDOI_COLUMN_NULL',
3243: p_token1_name => 'COLUMN_NAME',
3244: p_token1_value => 'CONTRACT_NUM',
3245: p_token2_name => 'VALUE',
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,
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',
3255: p_message_name => 'PO_PDOI_COLUMN_NULL',
3255: p_message_name => 'PO_PDOI_COLUMN_NULL',
3256: p_token1_name => 'COLUMN_NAME',
3257: p_token1_value => 'CONTRACT_ID',
3258: p_token2_name => 'VALUE',
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,
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',
3268: p_message_name => 'PO_PDOI_COLUMN_NULL',
3268: p_message_name => 'PO_PDOI_COLUMN_NULL',
3269: p_token1_name => 'COLUMN_NAME',
3270: p_token1_value => 'TYPE_1099',
3271: p_token2_name => 'VALUE',
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,
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',
3281: p_message_name => 'PO_PDOI_COLUMN_NULL',
3281: p_message_name => 'PO_PDOI_COLUMN_NULL',
3282: p_token1_name => 'COLUMN_NAME',
3283: p_token1_value => 'CLOSED_CODE',
3284: p_token2_name => 'VALUE',
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,
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',
3294: p_message_name => 'PO_PDOI_COLUMN_NULL',
3294: p_message_name => 'PO_PDOI_COLUMN_NULL',
3295: p_token1_name => 'COLUMN_NAME',
3296: p_token1_value => 'CLOSED_DATE',
3297: p_token2_name => 'VALUE',
3298: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3308: p_message_name => 'PO_PDOI_COLUMN_NULL',
3308: p_message_name => 'PO_PDOI_COLUMN_NULL',
3309: p_token1_name => 'COLUMN_NAME',
3310: p_token1_value => 'CLOSED_BY',
3311: p_token2_name => 'VALUE',
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,
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',
3321: p_message_name => 'PO_PDOI_COLUMN_NULL',
3321: p_message_name => 'PO_PDOI_COLUMN_NULL',
3322: p_token1_name => 'COLUMN_NAME',
3323: p_token1_value => 'OVER_TOLERANCE_ERROR_FLAG',
3324: p_token2_name => 'VALUE',
3325: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3335: p_message_name => 'PO_PDOI_COLUMN_NULL',
3335: p_message_name => 'PO_PDOI_COLUMN_NULL',
3336: p_token1_name => 'COLUMN_NAME',
3337: p_token1_value => 'COMMITTED_AMOUNT',
3338: p_token2_name => 'VALUE',
3339: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3349: p_message_name => 'PO_PDOI_COLUMN_NULL',
3349: p_message_name => 'PO_PDOI_COLUMN_NULL',
3350: p_token1_name => 'COLUMN_NAME',
3351: p_token1_value => 'ALLOW_PRICE_OVERRIDE_FLAG',
3352: p_token2_name => 'VALUE',
3353: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3363: p_message_name => 'PO_PDOI_COLUMN_NULL',
3363: p_message_name => 'PO_PDOI_COLUMN_NULL',
3364: p_token1_name => 'COLUMN_NAME',
3365: p_token1_value => 'NEGOTIATED_BY_PREPARER_FLAG',
3366: p_token2_name => 'VALUE',
3367: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3377: p_message_name => 'PO_PDOI_COLUMN_NULL',
3377: p_message_name => 'PO_PDOI_COLUMN_NULL',
3378: p_token1_name => 'COLUMN_NAME',
3379: p_token1_value => 'CAPITAL_EXPENSE_FLAG',
3380: p_token2_name => 'VALUE',
3381: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.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
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',
3391: p_message_name => 'PO_PDOI_COLUMN_NULL',
3391: p_message_name => 'PO_PDOI_COLUMN_NULL',
3392: p_token1_name => 'COLUMN_NAME',
3393: p_token1_value => 'MIN_RELEASE_AMOUNT',
3394: p_token2_name => 'VALUE',
3395: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.min_release_amount),
3396: p_validation_id => PO_VAL_CONSTANTS.c_min_release_amount_null,
3397: x_results => x_results,
3398: x_result_type => l_result_type);
3399: WHEN c_qty_rcv_exception_code_null THEN
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',
3406: p_message_name => 'PO_PDOI_COLUMN_NULL',
3406: p_message_name => 'PO_PDOI_COLUMN_NULL',
3407: p_token1_name => 'COLUMN_NAME',
3408: p_token1_value => 'QTY_RCV_EXCEPTION_CODE',
3409: p_token2_name => 'VALUE',
3410: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.qty_rcv_exception_code),
3411: x_results => x_results,
3412: x_result_type => l_result_type);
3413: END IF;
3414: WHEN c_market_price_null THEN
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',
3421: p_message_name => 'PO_PDOI_COLUMN_NULL',
3421: p_message_name => 'PO_PDOI_COLUMN_NULL',
3422: p_token1_name => 'COLUMN_NAME',
3423: p_token1_value => 'MARKET_PRICE',
3424: p_token2_name => 'VALUE',
3425: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.market_price),
3426: p_validation_id => PO_VAL_CONSTANTS.c_market_price_null,
3427: x_results => x_results,
3428: x_result_type => l_result_type);
3429: END IF;
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',
3913: p_message_name => 'PO_PDOI_COLUMN_NULL',
3913: p_message_name => 'PO_PDOI_COLUMN_NULL',
3914: p_token1_name => 'COLUMN_NAME',
3915: p_token1_value => 'FIRM_FLAG',
3916: p_token2_name => 'VALUE',
3917: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.firm_status_lookup_code),
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
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',
3927: p_message_name => 'PO_PDOI_COLUMN_NULL',
3927: p_message_name => 'PO_PDOI_COLUMN_NULL',
3928: p_token1_name => 'COLUMN_NAME',
3929: p_token1_value => 'FREIGHT_CARRIER',
3930: p_token2_name => 'VALUE',
3931: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.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
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',
3941: p_message_name => 'PO_PDOI_COLUMN_NULL',
3941: p_message_name => 'PO_PDOI_COLUMN_NULL',
3942: p_token1_name => 'COLUMN_NAME',
3943: p_token1_value => 'FOB_LOOKUP_CODE',
3944: p_token2_name => 'VALUE',
3945: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.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
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',
3955: p_message_name => 'PO_PDOI_COLUMN_NULL',
3955: p_message_name => 'PO_PDOI_COLUMN_NULL',
3956: p_token1_name => 'COLUMN_NAME',
3957: p_token1_value => 'FREIGHT_TERMS_LOOKUP_CODE',
3958: p_token2_name => 'VALUE',
3959: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_terms_lookup_code),
3960: p_validation_id => PO_VAL_CONSTANTS.c_freight_terms_null,
3961: x_results => x_results,
3962: x_result_type => l_result_type);
3963: WHEN c_qty_rcv_tolerance_null THEN
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',
3970: p_message_name => 'PO_PDOI_COLUMN_NULL',
3970: p_message_name => 'PO_PDOI_COLUMN_NULL',
3971: p_token1_name => 'COLUMN_NAME',
3972: p_token1_value => 'QTY_RCV_TOLERANCE',
3973: p_token2_name => 'VALUE',
3974: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.qty_rcv_tolerance),
3975: p_validation_id => PO_VAL_CONSTANTS.c_qty_rcv_tolerance_null,
3976: x_results => x_results,
3977: x_result_type => l_result_type);
3978: END IF;
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',
3986: p_message_name => 'PO_PDOI_COLUMN_NULL',
3986: p_message_name => 'PO_PDOI_COLUMN_NULL',
3987: p_token1_name => 'COLUMN_NAME',
3988: p_token1_value => 'RECEIPT_REQUIRED_FLAG',
3989: p_token2_name => 'VALUE',
3990: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_required_flag),
3991: p_validation_id => PO_VAL_CONSTANTS.c_receipt_reqd_flag_null,
3992: x_results => x_results,
3993: x_result_type => l_result_type);
3994: END IF;
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',
4002: p_message_name => 'PO_PDOI_COLUMN_NULL',
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',
4014: p_message_name => 'PO_PDOI_COLUMN_NULL',
4014: p_message_name => 'PO_PDOI_COLUMN_NULL',
4015: p_token1_name => 'COLUMN_NAME',
4016: p_token1_value => 'RECEIPT_DAYS_EXCEPTION_CODE',
4017: p_token2_name => 'VALUE',
4018: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_days_exception_code),
4019: p_validation_id => PO_VAL_CONSTANTS.c_receipt_days_except_null,
4020: x_results => x_results,
4021: x_result_type => l_result_type);
4022: END IF;
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',
4030: p_message_name => 'PO_PDOI_COLUMN_NULL',
4030: p_message_name => 'PO_PDOI_COLUMN_NULL',
4031: p_token1_name => 'COLUMN_NAME',
4032: p_token1_value => 'INVOICE_CLOSE_TOLERANCE',
4033: p_token2_name => 'VALUE',
4034: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.invoice_close_tolerance),
4035: p_validation_id => PO_VAL_CONSTANTS.c_invoice_close_toler_null,
4036: x_results => x_results,
4037: x_result_type => l_result_type);
4038: END IF;
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',
4046: p_message_name => 'PO_PDOI_COLUMN_NULL',
4046: p_message_name => 'PO_PDOI_COLUMN_NULL',
4047: p_token1_name => 'COLUMN_NAME',
4048: p_token1_value => 'RECEIVE_CLOSE_TOLERANCE',
4049: p_token2_name => 'VALUE',
4050: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receive_close_tolerance),
4051: p_validation_id => PO_VAL_CONSTANTS.c_receive_close_toler_null,
4052: x_results => x_results,
4053: x_result_type => l_result_type);
4054: END IF;
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',
4062: p_message_name => 'PO_PDOI_COLUMN_NULL',
4062: p_message_name => 'PO_PDOI_COLUMN_NULL',
4063: p_token1_name => 'COLUMN_NAME',
4064: p_token1_value => 'DAYS_EARLY_RECEIPT_ALLOWED',
4065: p_token2_name => 'VALUE',
4066: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_early_receipt_allowed),
4067: p_validation_id => PO_VAL_CONSTANTS.c_days_early_rcpt_allowed_null,
4068: x_results => x_results,
4069: x_result_type => l_result_type);
4070: END IF;
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',
4078: p_message_name => 'PO_PDOI_COLUMN_NULL',
4078: p_message_name => 'PO_PDOI_COLUMN_NULL',
4079: p_token1_name => 'COLUMN_NAME',
4080: p_token1_value => 'DAYS_LATE_RECEIPT_ALLOWED',
4081: p_token2_name => 'VALUE',
4082: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_late_receipt_allowed),
4083: p_validation_id => PO_VAL_CONSTANTS.c_days_late_rcpt_allowed_null,
4084: x_results => x_results,
4085: x_result_type => l_result_type);
4086: END IF;
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',
4094: p_message_name => 'PO_PDOI_COLUMN_NULL',
4094: p_message_name => 'PO_PDOI_COLUMN_NULL',
4095: p_token1_name => 'COLUMN_NAME',
4096: p_token1_value => 'ENFORCE_SHIP_TO_LOCATION_CODE',
4097: p_token2_name => 'VALUE',
4098: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.enforce_ship_to_location_code),
4099: p_validation_id => PO_VAL_CONSTANTS.c_enforce_shipto_loc_code_null,
4100: x_results => x_results,
4101: x_result_type => l_result_type);
4102: END IF;
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',
4110: p_message_name => 'PO_PDOI_COLUMN_NULL',
4110: p_message_name => 'PO_PDOI_COLUMN_NULL',
4111: p_token1_name => 'COLUMN_NAME',
4112: p_token1_value => 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
4113: p_token2_name => 'VALUE',
4114: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.allow_substitute_receipts_flag),
4115: p_validation_id => PO_VAL_CONSTANTS.c_allow_sub_receipts_flag_null,
4116: x_results => x_results,
4117: x_result_type => l_result_type);
4118: END IF;
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',
4126: p_message_name => 'PO_PDOI_COLUMN_NULL',
4126: p_message_name => 'PO_PDOI_COLUMN_NULL',
4127: p_token1_name => 'COLUMN_NAME',
4128: p_token1_value => 'RECEIVING_ROUTING_ID',
4129: p_token2_name => 'VALUE',
4130: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receiving_routing_id),
4131: p_validation_id => PO_VAL_CONSTANTS.c_receiving_routing_null,
4132: x_results => x_results,
4133: x_result_type => l_result_type);
4134: END IF;
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',
4141: p_message_name => 'PO_PDOI_COLUMN_NULL',
4141: p_message_name => 'PO_PDOI_COLUMN_NULL',
4142: p_token1_name => 'COLUMN_NAME',
4143: p_token1_value => 'NEED_BY_DATE',
4144: p_token2_name => 'VALUE',
4145: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.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
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',
4155: p_message_name => 'PO_PDOI_COLUMN_NULL',
4155: p_message_name => 'PO_PDOI_COLUMN_NULL',
4156: p_token1_name => 'COLUMN_NAME',
4157: p_token1_value => 'PROMISED_DATE',
4158: p_token2_name => 'VALUE',
4159: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.promised_date),
4160: p_validation_id => PO_VAL_CONSTANTS.c_promised_date_null,
4161: x_results => x_results,
4162: x_result_type => l_result_type);
4163: