eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_VALIDATIONS dependencies on PO_VAL_CONSTANTS

Line 1981: p_validation_id => PO_VAL_CONSTANTS.c_end_date,

1977: p_entity_type => c_entity_type_header,
1978: p_column_name => 'END DATE',
1979: p_column_val_selector => 'END_DATE',
1980: p_message_name => 'PO_PDOI_INVALID_END_DATE',
1981: p_validation_id => PO_VAL_CONSTANTS.c_end_date,
1982: x_results => x_results,
1983: x_result_type => l_result_type);
1984:
1985: WHEN c_type_lookup_code THEN

Line 2022: p_validation_id => PO_VAL_CONSTANTS.c_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',
2021: p_message_name => 'PO_PDOI_COLUMN_ZERO',
2022: p_validation_id => PO_VAL_CONSTANTS.c_revision_num,
2023: x_results => x_results,
2024: x_result_type => l_result_type);
2025: WHEN c_currency_code THEN
2026: -- validate currency_code is not null and valid in FND_CURRENCIES.

Line 2085: p_validation_id => PO_VAL_CONSTANTS.c_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',
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,

Line 2095: p_validation_id => PO_VAL_CONSTANTS.c_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',
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,

Line 2109: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id,

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
2113: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 2123: p_validation_id => PO_VAL_CONSTANTS.c_release_num,

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
2127: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 2137: p_validation_id => PO_VAL_CONSTANTS.c_release_date,

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
2141: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 2151: p_validation_id => PO_VAL_CONSTANTS.c_revised_date,

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
2155: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 2165: p_validation_id => PO_VAL_CONSTANTS.c_printed_date,

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
2169: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 2179: p_validation_id => PO_VAL_CONSTANTS.c_closed_date,

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
2183: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,

Line 2187: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,

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,
2188: x_result_set_id => l_result_set_id,
2189: x_result_type => l_result_type);
2190: WHEN c_ship_via_lookup_code THEN
2191: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,

Line 2222: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,

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
2226: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,

Line 2243: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed,

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
2247: -- bug 5352625

Line 2267: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,

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
2271: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,

Line 2298: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,

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
2302: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,

Line 2322: p_validation_id => PO_VAL_CONSTANTS.c_quote_warning_delay,

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
2326: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,

Line 2336: p_validation_id => PO_VAL_CONSTANTS.c_approval_required_flag,

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:
2340: ---------------------------------------------------------------

Line 3143: p_validation_id => PO_VAL_CONSTANTS.c_category_id_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
3147: -- Validate ip_category_id is empty

Line 3191: p_validation_id => PO_VAL_CONSTANTS.c_line_preferred_grade,

3187: p_item_id_tbl => p_lines.item_id,
3188: p_item_tbl => p_lines.item,
3189: p_organization_id_tbl => p_lines.inventory_org_id,
3190: p_create_or_update_item_flag => l_create_or_update_item,
3191: p_validation_id => PO_VAL_CONSTANTS.c_line_preferred_grade,
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

Line 3206: p_validation_id => PO_VAL_CONSTANTS.c_release_num_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
3210: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3220: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id_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
3224: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3299: p_validation_id => PO_VAL_CONSTANTS.c_closed_date_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
3303: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3326: p_validation_id => PO_VAL_CONSTANTS.c_over_tolerance_err_flag_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
3330: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3340: p_validation_id => PO_VAL_CONSTANTS.c_committed_amount_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
3344: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3354: p_validation_id => PO_VAL_CONSTANTS.c_allow_price_override_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
3358: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3368: p_validation_id => PO_VAL_CONSTANTS.c_negotiated_by_preparer_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
3372: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3382: p_validation_id => PO_VAL_CONSTANTS.c_capital_expense_flag_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
3386: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3396: p_validation_id => PO_VAL_CONSTANTS.c_min_release_amount_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
3400: IF l_create_or_update_item <> 'Y' THEN

Line 3426: p_validation_id => PO_VAL_CONSTANTS.c_market_price_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;
3430:

Line 3720: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_line_loc,

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,
3721: x_result_set_id => l_result_set_id,
3722: x_result_type => l_result_type);
3723: WHEN c_shipment_quantity THEN
3724: -- If order_type_lookup_code is RATE or FIXED PRICE, validate quantity is not null

Line 3903: p_validation_id => PO_VAL_CONSTANTS.c_loc_preferred_grade,

3899: p_item_id_tbl => p_line_locations.item_id,
3900: p_item_tbl => p_line_locations.item,
3901: p_organization_id_tbl => p_line_locations.ship_to_organization_id,
3902: p_create_or_update_item_flag => l_create_or_update_item,
3903: p_validation_id => PO_VAL_CONSTANTS.c_loc_preferred_grade,
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

Line 3918: p_validation_id => PO_VAL_CONSTANTS.c_firm_flag_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
3922: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3932: p_validation_id => PO_VAL_CONSTANTS.c_freight_carrier_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
3936: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3946: p_validation_id => PO_VAL_CONSTANTS.c_fob_lookup_code_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
3950: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 3960: p_validation_id => PO_VAL_CONSTANTS.c_freight_terms_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
3964: IF l_create_or_update_item <> 'Y' THEN

Line 3975: p_validation_id => PO_VAL_CONSTANTS.c_qty_rcv_tolerance_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;
3979: WHEN c_receipt_required_flag_null THEN

Line 3991: p_validation_id => PO_VAL_CONSTANTS.c_receipt_reqd_flag_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;
3995: WHEN c_inspection_reqd_flag_null THEN

Line 4003: p_validation_id => PO_VAL_CONSTANTS.c_inspection_reqd_flag_null,

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',
4003: p_validation_id => PO_VAL_CONSTANTS.c_inspection_reqd_flag_null,
4004: x_results => x_results,
4005: x_result_type => l_result_type);
4006: END IF;
4007: WHEN c_receipt_days_exception_null THEN

Line 4019: p_validation_id => PO_VAL_CONSTANTS.c_receipt_days_except_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;
4023: WHEN c_invoice_close_toler_null THEN

Line 4035: p_validation_id => PO_VAL_CONSTANTS.c_invoice_close_toler_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;
4039: WHEN c_receive_close_toler_null THEN

Line 4051: p_validation_id => PO_VAL_CONSTANTS.c_receive_close_toler_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;
4055: WHEN c_days_early_rcpt_allowed_null THEN

Line 4067: p_validation_id => PO_VAL_CONSTANTS.c_days_early_rcpt_allowed_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;
4071: WHEN c_days_late_rcpt_allowed_null THEN

Line 4083: p_validation_id => PO_VAL_CONSTANTS.c_days_late_rcpt_allowed_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;
4087: WHEN c_enfrce_ship_to_loc_code_null THEN

Line 4099: p_validation_id => PO_VAL_CONSTANTS.c_enforce_shipto_loc_code_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;
4103: WHEN c_allow_sub_receipts_flag_null THEN

Line 4115: p_validation_id => PO_VAL_CONSTANTS.c_allow_sub_receipts_flag_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;
4119: WHEN c_receiving_routing_null THEN

Line 4131: p_validation_id => PO_VAL_CONSTANTS.c_receiving_routing_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;
4135: WHEN c_need_by_date_null THEN

Line 4146: p_validation_id => PO_VAL_CONSTANTS.c_need_by_date_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
4150: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

Line 4160: p_validation_id => PO_VAL_CONSTANTS.c_promised_date_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:
4164: