[Home] [Help]
2411: x_result_set_id => l_result_set_id,
2412: x_result_type => l_result_type);
2413: WHEN c_last_update_date THEN
2414: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2415: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.last_update_date),
2416: p_entity_id_tbl => p_headers.interface_id,
2417: p_entity_type => c_entity_type_header,
2418: p_column_name => 'LAST_UPDATE_DATE',
2419: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2421: x_results => x_results,
2422: x_result_type => l_result_type);
2423: WHEN c_last_updated_by THEN
2424: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2425: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.last_updated_by),
2426: p_entity_id_tbl => p_headers.interface_id,
2427: p_entity_type => c_entity_type_header,
2428: p_column_name => 'LAST_UPDATED_BY',
2429: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2431: x_results => x_results,
2432: x_result_type => l_result_type);
2433: WHEN c_po_release_id THEN
2434: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2435: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.po_release_id),
2436: p_entity_id_tbl => p_headers.interface_id,
2437: p_entity_type => c_entity_type_header,
2438: p_column_name => 'PO_RELEASE_ID',
2439: p_message_name => 'PO_PDOI_COLUMN_NULL',
2439: p_message_name => 'PO_PDOI_COLUMN_NULL',
2440: p_token1_name => 'COLUMN_NAME',
2441: p_token1_value => 'PO_RELEASE_ID',
2442: p_token2_name => 'VALUE',
2443: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.po_release_id),
2444: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id,
2445: x_results => x_results,
2446: x_result_type => l_result_type);
2447: WHEN c_release_num THEN
2445: x_results => x_results,
2446: x_result_type => l_result_type);
2447: WHEN c_release_num THEN
2448: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2449: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_num),
2450: p_entity_id_tbl => p_headers.interface_id,
2451: p_entity_type => c_entity_type_header,
2452: p_column_name => 'RELEASE_NUM',
2453: p_message_name => 'PO_PDOI_COLUMN_NULL',
2453: p_message_name => 'PO_PDOI_COLUMN_NULL',
2454: p_token1_name => 'COLUMN_NAME',
2455: p_token1_value => 'RELEASE_NUM',
2456: p_token2_name => 'VALUE',
2457: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_num),
2458: p_validation_id => PO_VAL_CONSTANTS.c_release_num,
2459: x_results => x_results,
2460: x_result_type => l_result_type);
2461: WHEN c_release_date THEN
2459: x_results => x_results,
2460: x_result_type => l_result_type);
2461: WHEN c_release_date THEN
2462: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2463: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_date),
2464: p_entity_id_tbl => p_headers.interface_id,
2465: p_entity_type => c_entity_type_header,
2466: p_column_name => 'RELEASE_DATE',
2467: p_message_name => 'PO_PDOI_COLUMN_NULL',
2467: p_message_name => 'PO_PDOI_COLUMN_NULL',
2468: p_token1_name => 'COLUMN_NAME',
2469: p_token1_value => 'RELEASE_DATE',
2470: p_token2_name => 'VALUE',
2471: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.release_date),
2472: p_validation_id => PO_VAL_CONSTANTS.c_release_date,
2473: x_results => x_results,
2474: x_result_type => l_result_type);
2475: WHEN c_revised_date THEN
2473: x_results => x_results,
2474: x_result_type => l_result_type);
2475: WHEN c_revised_date THEN
2476: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2477: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.revised_date),
2478: p_entity_id_tbl => p_headers.interface_id,
2479: p_entity_type => c_entity_type_header,
2480: p_column_name => 'REVISED_DATE',
2481: p_message_name => 'PO_PDOI_COLUMN_NULL',
2481: p_message_name => 'PO_PDOI_COLUMN_NULL',
2482: p_token1_name => 'COLUMN_NAME',
2483: p_token1_value => 'REVISED_DATE',
2484: p_token2_name => 'VALUE',
2485: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.revised_date),
2486: p_validation_id => PO_VAL_CONSTANTS.c_revised_date,
2487: x_results => x_results,
2488: x_result_type => l_result_type);
2489: WHEN c_printed_date THEN
2487: x_results => x_results,
2488: x_result_type => l_result_type);
2489: WHEN c_printed_date THEN
2490: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2491: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.printed_date),
2492: p_entity_id_tbl => p_headers.interface_id,
2493: p_entity_type => c_entity_type_header,
2494: p_column_name => 'PRINTED_DATE',
2495: p_message_name => 'PO_PDOI_COLUMN_NULL',
2495: p_message_name => 'PO_PDOI_COLUMN_NULL',
2496: p_token1_name => 'COLUMN_NAME',
2497: p_token1_value => 'PRINTED_DATE',
2498: p_token2_name => 'VALUE',
2499: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.printed_date),
2500: p_validation_id => PO_VAL_CONSTANTS.c_printed_date,
2501: x_results => x_results,
2502: x_result_type => l_result_type);
2503: WHEN c_closed_date THEN
2501: x_results => x_results,
2502: x_result_type => l_result_type);
2503: WHEN c_closed_date THEN
2504: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
2505: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.closed_date),
2506: p_entity_id_tbl => p_headers.interface_id,
2507: p_entity_type => c_entity_type_header,
2508: p_column_name => 'CLOSED_DATE',
2509: p_message_name => 'PO_PDOI_COLUMN_NULL',
2509: p_message_name => 'PO_PDOI_COLUMN_NULL',
2510: p_token1_name => 'COLUMN_NAME',
2511: p_token1_value => 'CLOSED_DATE',
2512: p_token2_name => 'VALUE',
2513: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.closed_date),
2514: p_validation_id => PO_VAL_CONSTANTS.c_closed_date,
2515: x_results => x_results,
2516: x_result_type => l_result_type);
2517: WHEN c_terms_id_header THEN
2552: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2553: p_token1_name => 'COLUMN_NAME',
2554: p_token1_value => 'CONFIRMING_ORDER_FLAG',
2555: p_token2_name => 'VALUE',
2556: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.confirming_order_flag),
2557: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,
2558: x_results => x_results,
2559: x_result_type => l_result_type);
2560: WHEN c_acceptance_due_date THEN
2573: p_message_name => 'PO_PDOI_LT_ZERO',
2574: p_token1_name => 'COLUMN_NAME',
2575: p_token1_value => 'AMOUNT_AGREED',
2576: p_token2_name => 'VALUE',
2577: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.amount_agreed),
2578: p_validation_id => PO_VAL_CONSTANTS.c_amount_agreed,
2579: x_results => x_results,
2580: x_result_type => l_result_type);
2581: WHEN c_amount_limit THEN
2589: );
2590:
2591: WHEN c_firm_status_lookup_header THEN
2592: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,
2593: p_flag_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar1(p_headers.firm_status_lookup_code),
2594: p_entity_id_tbl => p_headers.interface_id,
2595: p_entity_type => c_entity_type_header,
2596: p_column_name => 'FIRM_STATUS_LOOKUP_CODE',
2597: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2597: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2598: p_token1_name => 'COLUMN_NAME',
2599: p_token1_value => 'FIRM_STATUS_LOOKUP_CODE',
2600: p_token2_name => 'VALUE',
2601: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.firm_status_lookup_code),
2602: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,
2603: x_results => x_results,
2604: x_result_type => l_result_type);
2605: WHEN c_cancel_flag THEN
2628: p_message_name => 'PO_PDOI_INVALID_FLAG_VALUE',
2629: p_token1_name => 'COLUMN_NAME',
2630: p_token1_value => 'FROZEN_FLAG',
2631: p_token2_name => 'VALUE',
2632: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.frozen_flag),
2633: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,
2634: x_results => x_results,
2635: x_result_type => l_result_type);
2636: WHEN c_approval_status THEN
2644: x_results => x_results,
2645: x_result_type => l_result_type);
2646: WHEN c_quote_warning_delay THEN
2647: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2648: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.quote_warning_delay),
2649: p_entity_id_tbl => p_headers.interface_id,
2650: p_entity_type => c_entity_type_header,
2651: p_column_name => 'QUOTE_WARNING_DELAY',
2652: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2652: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2653: p_token1_name => 'COLUMN_NAME',
2654: p_token1_value => 'QUOTE_WARNING_DELAY',
2655: p_token2_name => 'VALUE',
2656: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.quote_warning_delay),
2657: p_validation_id => PO_VAL_CONSTANTS.c_quote_warning_delay,
2658: x_results => x_results,
2659: x_result_type => l_result_type);
2660: WHEN c_approval_required_flag THEN
2658: x_results => x_results,
2659: x_result_type => l_result_type);
2660: WHEN c_approval_required_flag THEN
2661: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
2662: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.approval_required_flag),
2663: p_entity_id_tbl => p_headers.interface_id,
2664: p_entity_type => c_entity_type_header,
2665: p_column_name => 'APPROVAL_REQUIRED_FLAG',
2666: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2666: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
2667: p_token1_name => 'COLUMN_NAME',
2668: p_token1_value => 'APPROVAL_REQUIRED_FLAG',
2669: p_token2_name => 'VALUE',
2670: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_headers.approval_required_flag),
2671: p_validation_id => PO_VAL_CONSTANTS.c_approval_required_flag,
2672: x_results => x_results,
2673: x_result_type => l_result_type);
2674:
3891: --------------------------------------------------------------------------------------
3892: -- Negotiated by preparer flag must be Null for Quotation.
3893: --------------------------------------------------------------------------------------
3894: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3895: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
3896: p_entity_id_tbl => p_lines.interface_id,
3897: p_entity_type => c_entity_type_line,
3898: p_column_name => 'NEGOTIATED_BY_PREPARER',
3899: p_message_name => 'PO_PDOI_COLUMN_NULL',
3899: p_message_name => 'PO_PDOI_COLUMN_NULL',
3900: p_token1_name => 'COLUMN_NAME',
3901: p_token1_value => 'NEGOTIATED_BY_PREPARER',
3902: p_token2_name => 'VALUE',
3903: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
3904: x_results => x_results,
3905: x_result_type => l_result_type);
3906: WHEN c_category_id_null THEN
3907: -- Validate category_id cannot be Null
3905: x_result_type => l_result_type);
3906: WHEN c_category_id_null THEN
3907: -- Validate category_id cannot be Null
3908: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,
3909: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.category_id),
3910: p_entity_id_tbl => p_lines.interface_id,
3911: p_entity_type => c_entity_type_line,
3912: p_column_name => 'CATEGORY_ID',
3913: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3913: p_message_name => 'PO_PDOI_COLUMN_NOT_NULL',
3914: p_token1_name => 'COLUMN_NAME',
3915: p_token1_value => 'CATEGORY_ID',
3916: p_token2_name => 'VALUE',
3917: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.category_id),
3918: p_validation_id => PO_VAL_CONSTANTS.c_category_id_not_null,
3919: x_results => x_results,
3920: x_result_type => l_result_type);
3921: WHEN c_ip_category_id_null THEN
3920: x_result_type => l_result_type);
3921: WHEN c_ip_category_id_null THEN
3922: -- Validate ip_category_id is empty
3923: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3924: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.ip_category_id),
3925: p_entity_id_tbl => p_lines.interface_id,
3926: p_entity_type => c_entity_type_line,
3927: p_column_name => 'IP_CATEGORY_ID',
3928: p_message_name => 'PO_PDOI_COLUMN_NULL',
3928: p_message_name => 'PO_PDOI_COLUMN_NULL',
3929: p_token1_name => 'COLUMN_NAME',
3930: p_token1_value => 'IP_CATEGORY_ID',
3931: p_token2_name => 'VALUE',
3932: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.ip_category_id),
3933: x_results => x_results,
3934: x_result_type => l_result_type);
3935: WHEN c_line_secondary_uom THEN
3936: PO_VALIDATION_HELPER.secondary_unit_of_measure(p_id_tbl => p_lines.interface_id,
3968: x_result_set_id => l_result_set_id,
3969: x_result_type => l_result_type);
3970: WHEN c_release_num_null THEN
3971: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3972: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.release_num),
3973: p_entity_id_tbl => p_lines.interface_id,
3974: p_entity_type => c_entity_type_line,
3975: p_column_name => 'RELEASE_NUM',
3976: p_message_name => 'PO_PDOI_COLUMN_NULL',
3976: p_message_name => 'PO_PDOI_COLUMN_NULL',
3977: p_token1_name => 'COLUMN_NAME',
3978: p_token1_value => 'RELEASE_NUM',
3979: p_token2_name => 'VALUE',
3980: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.release_num),
3981: p_validation_id => PO_VAL_CONSTANTS.c_release_num_null,
3982: x_results => x_results,
3983: x_result_type => l_result_type);
3984: WHEN c_po_release_id_null THEN
3982: x_results => x_results,
3983: x_result_type => l_result_type);
3984: WHEN c_po_release_id_null THEN
3985: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
3986: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.po_release_id),
3987: p_entity_id_tbl => p_lines.interface_id,
3988: p_entity_type => c_entity_type_line,
3989: p_column_name => 'PO_RELEASE_ID',
3990: p_message_name => 'PO_PDOI_COLUMN_NULL',
3990: p_message_name => 'PO_PDOI_COLUMN_NULL',
3991: p_token1_name => 'COLUMN_NAME',
3992: p_token1_value => 'PO_RELEASE_ID',
3993: p_token2_name => 'VALUE',
3994: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.po_release_id),
3995: p_validation_id => PO_VAL_CONSTANTS.c_po_release_id_null,
3996: x_results => x_results,
3997: x_result_type => l_result_type);
3998: WHEN c_source_shipment_id_null THEN
3996: x_results => x_results,
3997: x_result_type => l_result_type);
3998: WHEN c_source_shipment_id_null THEN
3999: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4000: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.source_shipment_id),
4001: p_entity_id_tbl => p_lines.interface_id,
4002: p_entity_type => c_entity_type_line,
4003: p_column_name => 'SOURCE_SHIPMENT_ID',
4004: p_message_name => 'PO_PDOI_COLUMN_NULL',
4004: p_message_name => 'PO_PDOI_COLUMN_NULL',
4005: p_token1_name => 'COLUMN_NAME',
4006: p_token1_value => 'SOURCE_SHIPMENT_ID',
4007: p_token2_name => 'VALUE',
4008: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.source_shipment_id),
4009: x_results => x_results,
4010: x_result_type => l_result_type);
4011: WHEN c_contract_num_null THEN
4012: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4009: x_results => x_results,
4010: x_result_type => l_result_type);
4011: WHEN c_contract_num_null THEN
4012: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4013: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_num),
4014: p_entity_id_tbl => p_lines.interface_id,
4015: p_entity_type => c_entity_type_line,
4016: p_column_name => 'CONTRACT_NUM',
4017: p_message_name => 'PO_PDOI_COLUMN_NULL',
4017: p_message_name => 'PO_PDOI_COLUMN_NULL',
4018: p_token1_name => 'COLUMN_NAME',
4019: p_token1_value => 'CONTRACT_NUM',
4020: p_token2_name => 'VALUE',
4021: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_num),
4022: x_results => x_results,
4023: x_result_type => l_result_type);
4024: WHEN c_contract_id_null THEN
4025: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4022: x_results => x_results,
4023: x_result_type => l_result_type);
4024: WHEN c_contract_id_null 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_lines.contract_id),
4027: p_entity_id_tbl => p_lines.interface_id,
4028: p_entity_type => c_entity_type_line,
4029: p_column_name => 'CONTRACT_ID',
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 => 'CONTRACT_ID',
4033: p_token2_name => 'VALUE',
4034: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.contract_id),
4035: x_results => x_results,
4036: x_result_type => l_result_type);
4037: WHEN c_type_1099_null THEN
4038: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4035: x_results => x_results,
4036: x_result_type => l_result_type);
4037: WHEN c_type_1099_null THEN
4038: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4039: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.type_1099),
4040: p_entity_id_tbl => p_lines.interface_id,
4041: p_entity_type => c_entity_type_line,
4042: p_column_name => 'TYPE_1099',
4043: p_message_name => 'PO_PDOI_COLUMN_NULL',
4043: p_message_name => 'PO_PDOI_COLUMN_NULL',
4044: p_token1_name => 'COLUMN_NAME',
4045: p_token1_value => 'TYPE_1099',
4046: p_token2_name => 'VALUE',
4047: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.type_1099),
4048: x_results => x_results,
4049: x_result_type => l_result_type);
4050: WHEN c_closed_code_null THEN
4051: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4048: x_results => x_results,
4049: x_result_type => l_result_type);
4050: WHEN c_closed_code_null THEN
4051: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4052: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_code),
4053: p_entity_id_tbl => p_lines.interface_id,
4054: p_entity_type => c_entity_type_line,
4055: p_column_name => 'CLOSED_CODE',
4056: p_message_name => 'PO_PDOI_COLUMN_NULL',
4056: p_message_name => 'PO_PDOI_COLUMN_NULL',
4057: p_token1_name => 'COLUMN_NAME',
4058: p_token1_value => 'CLOSED_CODE',
4059: p_token2_name => 'VALUE',
4060: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_code),
4061: x_results => x_results,
4062: x_result_type => l_result_type);
4063: WHEN c_closed_date_null THEN
4064: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4061: x_results => x_results,
4062: x_result_type => l_result_type);
4063: WHEN c_closed_date_null THEN
4064: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4065: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_date),
4066: p_entity_id_tbl => p_lines.interface_id,
4067: p_entity_type => c_entity_type_line,
4068: p_column_name => 'CLOSED_DATE',
4069: p_message_name => 'PO_PDOI_COLUMN_NULL',
4069: p_message_name => 'PO_PDOI_COLUMN_NULL',
4070: p_token1_name => 'COLUMN_NAME',
4071: p_token1_value => 'CLOSED_DATE',
4072: p_token2_name => 'VALUE',
4073: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_date),
4074: p_validation_id => PO_VAL_CONSTANTS.c_closed_date_null,
4075: x_results => x_results,
4076: x_result_type => l_result_type);
4077: WHEN c_closed_by_null THEN
4075: x_results => x_results,
4076: x_result_type => l_result_type);
4077: WHEN c_closed_by_null THEN
4078: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4079: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_by),
4080: p_entity_id_tbl => p_lines.interface_id,
4081: p_entity_type => c_entity_type_line,
4082: p_column_name => 'CLOSED_BY',
4083: p_message_name => 'PO_PDOI_COLUMN_NULL',
4083: p_message_name => 'PO_PDOI_COLUMN_NULL',
4084: p_token1_name => 'COLUMN_NAME',
4085: p_token1_value => 'CLOSED_BY',
4086: p_token2_name => 'VALUE',
4087: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.closed_by),
4088: x_results => x_results,
4089: x_result_type => l_result_type);
4090: WHEN c_over_tolerance_err_flag_null THEN
4091: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4088: x_results => x_results,
4089: x_result_type => l_result_type);
4090: WHEN c_over_tolerance_err_flag_null THEN
4091: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4092: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.over_tolerance_error_flag),
4093: p_entity_id_tbl => p_lines.interface_id,
4094: p_entity_type => c_entity_type_line,
4095: p_column_name => 'OVER_TOLERANCE_ERROR_FLAG',
4096: p_message_name => 'PO_PDOI_COLUMN_NULL',
4096: p_message_name => 'PO_PDOI_COLUMN_NULL',
4097: p_token1_name => 'COLUMN_NAME',
4098: p_token1_value => 'OVER_TOLERANCE_ERROR_FLAG',
4099: p_token2_name => 'VALUE',
4100: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.over_tolerance_error_flag),
4101: p_validation_id => PO_VAL_CONSTANTS.c_over_tolerance_err_flag_null,
4102: x_results => x_results,
4103: x_result_type => l_result_type);
4104: WHEN c_committed_amount_null THEN
4102: x_results => x_results,
4103: x_result_type => l_result_type);
4104: WHEN c_committed_amount_null 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_lines.committed_amount),
4107: p_entity_id_tbl => p_lines.interface_id,
4108: p_entity_type => c_entity_type_line,
4109: p_column_name => 'COMMITTED_AMOUNT',
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 => 'COMMITTED_AMOUNT',
4113: p_token2_name => 'VALUE',
4114: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.committed_amount),
4115: p_validation_id => PO_VAL_CONSTANTS.c_committed_amount_null,
4116: x_results => x_results,
4117: x_result_type => l_result_type);
4118: WHEN c_allow_price_override_null THEN
4116: x_results => x_results,
4117: x_result_type => l_result_type);
4118: WHEN c_allow_price_override_null THEN
4119: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4120: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.allow_price_override_flag),
4121: p_entity_id_tbl => p_lines.interface_id,
4122: p_entity_type => c_entity_type_line,
4123: p_column_name => 'ALLOW_PRICE_OVERRIDE_FLAG',
4124: p_message_name => 'PO_PDOI_COLUMN_NULL',
4124: p_message_name => 'PO_PDOI_COLUMN_NULL',
4125: p_token1_name => 'COLUMN_NAME',
4126: p_token1_value => 'ALLOW_PRICE_OVERRIDE_FLAG',
4127: p_token2_name => 'VALUE',
4128: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.allow_price_override_flag),
4129: p_validation_id => PO_VAL_CONSTANTS.c_allow_price_override_null,
4130: x_results => x_results,
4131: x_result_type => l_result_type);
4132: WHEN c_negotiated_by_preparer_null THEN
4130: x_results => x_results,
4131: x_result_type => l_result_type);
4132: WHEN c_negotiated_by_preparer_null THEN
4133: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4134: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
4135: p_entity_id_tbl => p_lines.interface_id,
4136: p_entity_type => c_entity_type_line,
4137: p_column_name => 'NEGOTIATED_BY_PREPARER_FLAG',
4138: p_message_name => 'PO_PDOI_COLUMN_NULL',
4138: p_message_name => 'PO_PDOI_COLUMN_NULL',
4139: p_token1_name => 'COLUMN_NAME',
4140: p_token1_value => 'NEGOTIATED_BY_PREPARER_FLAG',
4141: p_token2_name => 'VALUE',
4142: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.negotiated_by_preparer_flag),
4143: p_validation_id => PO_VAL_CONSTANTS.c_negotiated_by_preparer_null,
4144: x_results => x_results,
4145: x_result_type => l_result_type);
4146: WHEN c_capital_expense_flag_null THEN
4144: x_results => x_results,
4145: x_result_type => l_result_type);
4146: WHEN c_capital_expense_flag_null THEN
4147: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4148: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.capital_expense_flag),
4149: p_entity_id_tbl => p_lines.interface_id,
4150: p_entity_type => c_entity_type_line,
4151: p_column_name => 'CAPITAL_EXPENSE_FLAG',
4152: p_message_name => 'PO_PDOI_COLUMN_NULL',
4152: p_message_name => 'PO_PDOI_COLUMN_NULL',
4153: p_token1_name => 'COLUMN_NAME',
4154: p_token1_value => 'CAPITAL_EXPENSE_FLAG',
4155: p_token2_name => 'VALUE',
4156: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.capital_expense_flag),
4157: p_validation_id => PO_VAL_CONSTANTS.c_capital_expense_flag_null,
4158: x_results => x_results,
4159: x_result_type => l_result_type);
4160: WHEN c_min_release_amount_null THEN
4158: x_results => x_results,
4159: x_result_type => l_result_type);
4160: WHEN c_min_release_amount_null THEN
4161: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4162: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.min_release_amount),
4163: p_entity_id_tbl => p_lines.interface_id,
4164: p_entity_type => c_entity_type_line,
4165: p_column_name => 'MIN_RELEASE_AMOUNT',
4166: p_message_name => 'PO_PDOI_COLUMN_NULL',
4166: p_message_name => 'PO_PDOI_COLUMN_NULL',
4167: p_token1_name => 'COLUMN_NAME',
4168: p_token1_value => 'MIN_RELEASE_AMOUNT',
4169: p_token2_name => 'VALUE',
4170: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.min_release_amount),
4171: p_validation_id => PO_VAL_CONSTANTS.c_min_release_amount_null,
4172: x_results => x_results,
4173: x_result_type => l_result_type);
4174: --
4246: --
4247: WHEN c_qty_rcv_exception_code_null THEN
4248: IF l_create_or_update_item <> 'Y' THEN
4249: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4250: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.qty_rcv_exception_code),
4251: p_entity_id_tbl => p_lines.interface_id,
4252: p_entity_type => c_entity_type_line,
4253: p_column_name => 'QTY_RCV_EXCEPTION_CODE',
4254: p_message_name => 'PO_PDOI_COLUMN_NULL',
4254: p_message_name => 'PO_PDOI_COLUMN_NULL',
4255: p_token1_name => 'COLUMN_NAME',
4256: p_token1_value => 'QTY_RCV_EXCEPTION_CODE',
4257: p_token2_name => 'VALUE',
4258: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.qty_rcv_exception_code),
4259: x_results => x_results,
4260: x_result_type => l_result_type);
4261: END IF;
4262: WHEN c_market_price_null THEN
4261: END IF;
4262: WHEN c_market_price_null THEN
4263: IF l_create_or_update_item <> 'Y' THEN
4264: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4265: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.market_price),
4266: p_entity_id_tbl => p_lines.interface_id,
4267: p_entity_type => c_entity_type_line,
4268: p_column_name => 'MARKET_PRICE',
4269: p_message_name => 'PO_PDOI_COLUMN_NULL',
4269: p_message_name => 'PO_PDOI_COLUMN_NULL',
4270: p_token1_name => 'COLUMN_NAME',
4271: p_token1_value => 'MARKET_PRICE',
4272: p_token2_name => 'VALUE',
4273: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_lines.market_price),
4274: p_validation_id => PO_VAL_CONSTANTS.c_market_price_null,
4275: x_results => x_results,
4276: x_result_type => l_result_type);
4277: END IF;
4821: x_result_set_id => l_result_set_id,
4822: x_result_type => l_result_type);
4823: WHEN c_firm_flag_null THEN
4824: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4825: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.firm_status_lookup_code),
4826: p_entity_id_tbl => p_line_locations.interface_id,
4827: p_entity_type => c_entity_type_line_location,
4828: p_column_name => 'FIRM_FLAG',
4829: p_message_name => 'PO_PDOI_COLUMN_NULL',
4829: p_message_name => 'PO_PDOI_COLUMN_NULL',
4830: p_token1_name => 'COLUMN_NAME',
4831: p_token1_value => 'FIRM_FLAG',
4832: p_token2_name => 'VALUE',
4833: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.firm_status_lookup_code),
4834: p_validation_id => PO_VAL_CONSTANTS.c_firm_flag_null,
4835: x_results => x_results,
4836: x_result_type => l_result_type);
4837: WHEN c_freight_carrier_null THEN
4835: x_results => x_results,
4836: x_result_type => l_result_type);
4837: WHEN c_freight_carrier_null THEN
4838: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4839: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_carrier),
4840: p_entity_id_tbl => p_line_locations.interface_id,
4841: p_entity_type => c_entity_type_line_location,
4842: p_column_name => 'FREIGHT_CARRIER',
4843: p_message_name => 'PO_PDOI_COLUMN_NULL',
4843: p_message_name => 'PO_PDOI_COLUMN_NULL',
4844: p_token1_name => 'COLUMN_NAME',
4845: p_token1_value => 'FREIGHT_CARRIER',
4846: p_token2_name => 'VALUE',
4847: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_carrier),
4848: p_validation_id => PO_VAL_CONSTANTS.c_freight_carrier_null,
4849: x_results => x_results,
4850: x_result_type => l_result_type);
4851: WHEN c_fob_lookup_code_null THEN
4849: x_results => x_results,
4850: x_result_type => l_result_type);
4851: WHEN c_fob_lookup_code_null THEN
4852: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4853: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.fob_lookup_code),
4854: p_entity_id_tbl => p_line_locations.interface_id,
4855: p_entity_type => c_entity_type_line_location,
4856: p_column_name => 'FOB_LOOKUP_CODE',
4857: p_message_name => 'PO_PDOI_COLUMN_NULL',
4857: p_message_name => 'PO_PDOI_COLUMN_NULL',
4858: p_token1_name => 'COLUMN_NAME',
4859: p_token1_value => 'FOB_LOOKUP_CODE',
4860: p_token2_name => 'VALUE',
4861: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.fob_lookup_code),
4862: p_validation_id => PO_VAL_CONSTANTS.c_fob_lookup_code_null,
4863: x_results => x_results,
4864: x_result_type => l_result_type);
4865: WHEN c_freight_terms_lookup_null THEN
4863: x_results => x_results,
4864: x_result_type => l_result_type);
4865: WHEN c_freight_terms_lookup_null THEN
4866: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4867: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_terms_lookup_code),
4868: p_entity_id_tbl => p_line_locations.interface_id,
4869: p_entity_type => c_entity_type_line_location,
4870: p_column_name => 'FREIGHT_TERMS_LOOKUP_CODE',
4871: p_message_name => 'PO_PDOI_COLUMN_NULL',
4871: p_message_name => 'PO_PDOI_COLUMN_NULL',
4872: p_token1_name => 'COLUMN_NAME',
4873: p_token1_value => 'FREIGHT_TERMS_LOOKUP_CODE',
4874: p_token2_name => 'VALUE',
4875: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.freight_terms_lookup_code),
4876: p_validation_id => PO_VAL_CONSTANTS.c_freight_terms_null,
4877: x_results => x_results,
4878: x_result_type => l_result_type);
4879: WHEN c_qty_rcv_tolerance_null THEN
4878: x_result_type => l_result_type);
4879: WHEN c_qty_rcv_tolerance_null THEN
4880: IF l_create_or_update_item <> 'Y' THEN
4881: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4882: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.qty_rcv_tolerance),
4883: p_entity_id_tbl => p_line_locations.interface_id,
4884: p_entity_type => c_entity_type_line_location,
4885: p_column_name => 'QTY_RCV_TOLERANCE',
4886: p_message_name => 'PO_PDOI_COLUMN_NULL',
4886: p_message_name => 'PO_PDOI_COLUMN_NULL',
4887: p_token1_name => 'COLUMN_NAME',
4888: p_token1_value => 'QTY_RCV_TOLERANCE',
4889: p_token2_name => 'VALUE',
4890: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.qty_rcv_tolerance),
4891: p_validation_id => PO_VAL_CONSTANTS.c_qty_rcv_tolerance_null,
4892: x_results => x_results,
4893: x_result_type => l_result_type);
4894: END IF;
4894: END IF;
4895: WHEN c_receipt_required_flag_null THEN
4896: IF l_create_or_update_item <> 'Y' THEN
4897: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4898: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_required_flag),
4899: p_entity_id_tbl => p_line_locations.interface_id,
4900: p_entity_type => c_entity_type_line_location,
4901: p_column_name => 'RECEIPT_REQUIRED_FLAG',
4902: p_message_name => 'PO_PDOI_COLUMN_NULL',
4902: p_message_name => 'PO_PDOI_COLUMN_NULL',
4903: p_token1_name => 'COLUMN_NAME',
4904: p_token1_value => 'RECEIPT_REQUIRED_FLAG',
4905: p_token2_name => 'VALUE',
4906: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_required_flag),
4907: p_validation_id => PO_VAL_CONSTANTS.c_receipt_reqd_flag_null,
4908: x_results => x_results,
4909: x_result_type => l_result_type);
4910: END IF;
4910: END IF;
4911: WHEN c_inspection_reqd_flag_null THEN
4912: IF l_create_or_update_item <> 'Y' THEN
4913: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4914: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.inspection_required_flag),
4915: p_entity_id_tbl => p_line_locations.interface_id,
4916: p_entity_type => c_entity_type_line_location,
4917: p_column_name => 'INSPECTION_REQUIRED_FLAG',
4918: p_message_name => 'PO_PDOI_COLUMN_NULL',
4922: END IF;
4923: WHEN c_receipt_days_exception_null THEN
4924: IF l_create_or_update_item <> 'Y' THEN
4925: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4926: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_days_exception_code),
4927: p_entity_id_tbl => p_line_locations.interface_id,
4928: p_entity_type => c_entity_type_line_location,
4929: p_column_name => 'RECEIPT_DAYS_EXCEPTION_CODE',
4930: p_message_name => 'PO_PDOI_COLUMN_NULL',
4930: p_message_name => 'PO_PDOI_COLUMN_NULL',
4931: p_token1_name => 'COLUMN_NAME',
4932: p_token1_value => 'RECEIPT_DAYS_EXCEPTION_CODE',
4933: p_token2_name => 'VALUE',
4934: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receipt_days_exception_code),
4935: p_validation_id => PO_VAL_CONSTANTS.c_receipt_days_except_null,
4936: x_results => x_results,
4937: x_result_type => l_result_type);
4938: END IF;
4938: END IF;
4939: WHEN c_invoice_close_toler_null THEN
4940: IF l_create_or_update_item <> 'Y' THEN
4941: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4942: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.invoice_close_tolerance),
4943: p_entity_id_tbl => p_line_locations.interface_id,
4944: p_entity_type => c_entity_type_line_location,
4945: p_column_name => 'INVOICE_CLOSE_TOLERANCE',
4946: p_message_name => 'PO_PDOI_COLUMN_NULL',
4946: p_message_name => 'PO_PDOI_COLUMN_NULL',
4947: p_token1_name => 'COLUMN_NAME',
4948: p_token1_value => 'INVOICE_CLOSE_TOLERANCE',
4949: p_token2_name => 'VALUE',
4950: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.invoice_close_tolerance),
4951: p_validation_id => PO_VAL_CONSTANTS.c_invoice_close_toler_null,
4952: x_results => x_results,
4953: x_result_type => l_result_type);
4954: END IF;
4954: END IF;
4955: WHEN c_receive_close_toler_null THEN
4956: IF l_create_or_update_item <> 'Y' THEN
4957: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4958: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receive_close_tolerance),
4959: p_entity_id_tbl => p_line_locations.interface_id,
4960: p_entity_type => c_entity_type_line_location,
4961: p_column_name => 'RECEIVE_CLOSE_TOLERANCE',
4962: p_message_name => 'PO_PDOI_COLUMN_NULL',
4962: p_message_name => 'PO_PDOI_COLUMN_NULL',
4963: p_token1_name => 'COLUMN_NAME',
4964: p_token1_value => 'RECEIVE_CLOSE_TOLERANCE',
4965: p_token2_name => 'VALUE',
4966: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receive_close_tolerance),
4967: p_validation_id => PO_VAL_CONSTANTS.c_receive_close_toler_null,
4968: x_results => x_results,
4969: x_result_type => l_result_type);
4970: END IF;
4970: END IF;
4971: WHEN c_days_early_rcpt_allowed_null THEN
4972: IF l_create_or_update_item <> 'Y' THEN
4973: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4974: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_early_receipt_allowed),
4975: p_entity_id_tbl => p_line_locations.interface_id,
4976: p_entity_type => c_entity_type_line_location,
4977: p_column_name => 'DAYS_EARLY_RECEIPT_ALLOWED',
4978: p_message_name => 'PO_PDOI_COLUMN_NULL',
4978: p_message_name => 'PO_PDOI_COLUMN_NULL',
4979: p_token1_name => 'COLUMN_NAME',
4980: p_token1_value => 'DAYS_EARLY_RECEIPT_ALLOWED',
4981: p_token2_name => 'VALUE',
4982: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_early_receipt_allowed),
4983: p_validation_id => PO_VAL_CONSTANTS.c_days_early_rcpt_allowed_null,
4984: x_results => x_results,
4985: x_result_type => l_result_type);
4986: END IF;
4986: END IF;
4987: WHEN c_days_late_rcpt_allowed_null THEN
4988: IF l_create_or_update_item <> 'Y' THEN
4989: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
4990: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_late_receipt_allowed),
4991: p_entity_id_tbl => p_line_locations.interface_id,
4992: p_entity_type => c_entity_type_line_location,
4993: p_column_name => 'DAYS_LATE_RECEIPT_ALLOWED',
4994: p_message_name => 'PO_PDOI_COLUMN_NULL',
4994: p_message_name => 'PO_PDOI_COLUMN_NULL',
4995: p_token1_name => 'COLUMN_NAME',
4996: p_token1_value => 'DAYS_LATE_RECEIPT_ALLOWED',
4997: p_token2_name => 'VALUE',
4998: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.days_late_receipt_allowed),
4999: p_validation_id => PO_VAL_CONSTANTS.c_days_late_rcpt_allowed_null,
5000: x_results => x_results,
5001: x_result_type => l_result_type);
5002: END IF;
5002: END IF;
5003: WHEN c_enfrce_ship_to_loc_code_null THEN
5004: IF l_create_or_update_item <> 'Y' THEN
5005: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
5006: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.enforce_ship_to_location_code),
5007: p_entity_id_tbl => p_line_locations.interface_id,
5008: p_entity_type => c_entity_type_line_location,
5009: p_column_name => 'ENFORCE_SHIP_TO_LOCATION_CODE',
5010: p_message_name => 'PO_PDOI_COLUMN_NULL',
5010: p_message_name => 'PO_PDOI_COLUMN_NULL',
5011: p_token1_name => 'COLUMN_NAME',
5012: p_token1_value => 'ENFORCE_SHIP_TO_LOCATION_CODE',
5013: p_token2_name => 'VALUE',
5014: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.enforce_ship_to_location_code),
5015: p_validation_id => PO_VAL_CONSTANTS.c_enforce_shipto_loc_code_null,
5016: x_results => x_results,
5017: x_result_type => l_result_type);
5018: END IF;
5018: END IF;
5019: WHEN c_allow_sub_receipts_flag_null THEN
5020: IF l_create_or_update_item <> 'Y' THEN
5021: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
5022: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.allow_substitute_receipts_flag),
5023: p_entity_id_tbl => p_line_locations.interface_id,
5024: p_entity_type => c_entity_type_line_location,
5025: p_column_name => 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
5026: p_message_name => 'PO_PDOI_COLUMN_NULL',
5026: p_message_name => 'PO_PDOI_COLUMN_NULL',
5027: p_token1_name => 'COLUMN_NAME',
5028: p_token1_value => 'ALLOW_SUBSTITUTE_RECEIPTS_FLAG',
5029: p_token2_name => 'VALUE',
5030: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.allow_substitute_receipts_flag),
5031: p_validation_id => PO_VAL_CONSTANTS.c_allow_sub_receipts_flag_null,
5032: x_results => x_results,
5033: x_result_type => l_result_type);
5034: END IF;
5034: END IF;
5035: WHEN c_receiving_routing_null THEN
5036: IF l_create_or_update_item <> 'Y' THEN
5037: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
5038: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receiving_routing_id),
5039: p_entity_id_tbl => p_line_locations.interface_id,
5040: p_entity_type => c_entity_type_line_location,
5041: p_column_name => 'RECEIVING_ROUTING_ID',
5042: p_message_name => 'PO_PDOI_COLUMN_NULL',
5042: p_message_name => 'PO_PDOI_COLUMN_NULL',
5043: p_token1_name => 'COLUMN_NAME',
5044: p_token1_value => 'RECEIVING_ROUTING_ID',
5045: p_token2_name => 'VALUE',
5046: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.receiving_routing_id),
5047: p_validation_id => PO_VAL_CONSTANTS.c_receiving_routing_null,
5048: x_results => x_results,
5049: x_result_type => l_result_type);
5050: END IF;
5049: x_result_type => l_result_type);
5050: END IF;
5051: WHEN c_need_by_date_null THEN
5052: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
5053: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.need_by_date),
5054: p_entity_id_tbl => p_line_locations.interface_id,
5055: p_entity_type => c_entity_type_line_location,
5056: p_column_name => 'NEED_BY_DATE',
5057: p_message_name => 'PO_PDOI_COLUMN_NULL',
5057: p_message_name => 'PO_PDOI_COLUMN_NULL',
5058: p_token1_name => 'COLUMN_NAME',
5059: p_token1_value => 'NEED_BY_DATE',
5060: p_token2_name => 'VALUE',
5061: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.need_by_date),
5062: p_validation_id => PO_VAL_CONSTANTS.c_need_by_date_null,
5063: x_results => x_results,
5064: x_result_type => l_result_type);
5065: WHEN c_promised_date_null THEN
5063: x_results => x_results,
5064: x_result_type => l_result_type);
5065: WHEN c_promised_date_null THEN
5066: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,
5067: p_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.promised_date),
5068: p_entity_id_tbl => p_line_locations.interface_id,
5069: p_entity_type => c_entity_type_line_location,
5070: p_column_name => 'PROMISED_DATE',
5071: p_message_name => 'PO_PDOI_COLUMN_NULL',
5071: p_message_name => 'PO_PDOI_COLUMN_NULL',
5072: p_token1_name => 'COLUMN_NAME',
5073: p_token1_value => 'PROMISED_DATE',
5074: p_token2_name => 'VALUE',
5075: p_token2_value_tbl => PO_TYPE_CONVERTER.to_po_tbl_varchar4000(p_line_locations.promised_date),
5076: p_validation_id => PO_VAL_CONSTANTS.c_promised_date_null,
5077: x_results => x_results,
5078: x_result_type => l_result_type);
5079: