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_VALIDATION_HELPER

Line 2307: PO_VALIDATION_HELPER.start_date_le_end_date(p_calling_module => p_calling_program,

2303: x_result_set_id => l_result_set_id,
2304: x_result_type => l_result_type);
2305: WHEN c_end_date THEN
2306: -- validate end date not earlier than start date.
2307: PO_VALIDATION_HELPER.start_date_le_end_date(p_calling_module => p_calling_program,
2308: p_start_date_tbl => p_headers.start_date,
2309: p_end_date_tbl => p_headers.end_date,
2310: p_entity_id_tbl => p_headers.interface_id,
2311: p_entity_type => c_entity_type_header,

Line 2350: PO_VALIDATION_HELPER.zero(p_calling_module => p_calling_program,

2346:
2347:
2348: WHEN c_revision_num THEN
2349: -- validate revision_num is zero.
2350: PO_VALIDATION_HELPER.zero(p_calling_module => p_calling_program,
2351: p_value_tbl => p_headers.revision_num,
2352: p_entity_id_tbl => p_headers.interface_id,
2353: p_entity_type => c_entity_type_header,
2354: p_column_name => 'REVISION_NUM',

Line 2414: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,

2410: p_style_id_tbl => p_headers.style_id,
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',

Line 2424: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,

2420: p_validation_id => PO_VAL_CONSTANTS.c_last_update_date,
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',

Line 2434: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

2430: p_validation_id => PO_VAL_CONSTANTS.c_last_updated_by,
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',

Line 2448: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 2462: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 2476: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 2490: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 2504: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 2518: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,

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
2518: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
2519: p_terms_id_tbl => p_headers.terms_id,
2520: p_entity_id_tbl => p_headers.interface_id,
2521: p_entity_type => c_entity_type_header,
2522: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,

Line 2547: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,

2543: p_shipping_control_tbl => p_headers.shipping_control,
2544: x_result_set_id => l_result_set_id,
2545: x_result_type => l_result_type);
2546: WHEN c_confirming_order_flag THEN
2547: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,
2548: p_flag_value_tbl => p_headers.confirming_order_flag,
2549: p_entity_id_tbl => p_headers.interface_id,
2550: p_entity_type => c_entity_type_header,
2551: p_column_name => 'CONFIRMING_ORDER_FLAG',

Line 2567: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,

2563: p_acceptance_due_date_tbl => p_headers.acceptance_due_date,
2564: x_results => x_results,
2565: x_result_type => l_result_type);
2566: WHEN c_amount_agreed THEN
2567: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,
2568: p_null_allowed_flag => PO_CORE_S.g_parameter_YES, -- bug5008206
2569: p_value_tbl => p_headers.amount_agreed,
2570: p_entity_id_tbl => p_headers.interface_id,
2571: p_entity_type => c_entity_type_header,

Line 2592: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,

2588: x_result_type => l_result_type
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',

Line 2623: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,

2619: p_approval_status_tbl => p_headers.approval_status,
2620: x_results => x_results,
2621: x_result_type => l_result_type);
2622: WHEN c_frozen_flag THEN
2623: PO_VALIDATION_HELPER.flag_value_y_n(p_calling_module => p_calling_program,
2624: p_flag_value_tbl => p_headers.frozen_flag,
2625: p_entity_id_tbl => p_headers.interface_id,
2626: p_entity_type => c_entity_type_header,
2627: p_column_name => 'FROZEN_FLAG',

Line 2647: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,

2643: p_amount_to_encumber_tbl => p_headers.amount_to_encumber,
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',

Line 2661: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,

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
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',

Line 3894: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

3890: WHEN c_negotiated_by_preparer_null THEN
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',

Line 3908: PO_VALIDATION_HELPER.not_null(p_calling_module => p_calling_program,

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
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',

Line 3923: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

3919: x_results => x_results,
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',

Line 3936: PO_VALIDATION_HELPER.secondary_unit_of_measure(p_id_tbl => p_lines.interface_id,

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,
3937: p_entity_type => c_entity_type_line,
3938: p_secondary_unit_of_meas_tbl => p_lines.secondary_unit_of_measure,
3939: p_item_id_tbl => p_lines.item_id,
3940: p_item_tbl => p_lines.item,

Line 3947: PO_VALIDATION_HELPER.secondary_quantity(p_id_tbl => p_lines.interface_id,

3943: p_create_or_update_item_flag => l_create_or_update_item,
3944: x_results => x_results,
3945: x_result_type => l_result_type);
3946: WHEN c_line_secondary_quantity THEN
3947: PO_VALIDATION_HELPER.secondary_quantity(p_id_tbl => p_lines.interface_id,
3948: p_entity_type => c_entity_type_line,
3949: p_secondary_quantity_tbl => p_lines.secondary_quantity,
3950: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3951: p_item_id_tbl => p_lines.item_id,

Line 3959: PO_VALIDATION_HELPER.preferred_grade(p_id_tbl => p_lines.interface_id,

3955: p_create_or_update_item_flag => l_create_or_update_item,
3956: x_results => x_results,
3957: x_result_type => l_result_type);
3958: WHEN c_line_preferred_grade THEN
3959: PO_VALIDATION_HELPER.preferred_grade(p_id_tbl => p_lines.interface_id,
3960: p_entity_type => c_entity_type_line,
3961: p_preferred_grade_tbl => p_lines.preferred_grade,
3962: p_item_id_tbl => p_lines.item_id,
3963: p_item_tbl => p_lines.item,

Line 3971: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

3967: x_results => x_results,
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',

Line 3985: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 3999: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4012: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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,
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',

Line 4025: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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,
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',

Line 4038: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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,
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',

Line 4051: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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,
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',

Line 4064: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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,
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',

Line 4078: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4091: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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,
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',

Line 4105: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4119: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4133: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4147: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4161: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4249: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4245: );
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',

Line 4264: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4260: x_result_type => l_result_type);
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',

Line 4593: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,

4589: x_result_set_id => l_result_set_id,
4590: x_results => x_results,
4591: x_result_type => l_result_type);
4592: WHEN c_terms_id_line_loc THEN
4593: PO_VALIDATION_HELPER.terms_id(p_calling_module => p_calling_program,
4594: p_terms_id_tbl => p_line_locations.terms_id,
4595: p_entity_id_tbl => p_line_locations.interface_id,
4596: p_entity_type => c_entity_type_line_location,
4597: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_line_loc,

Line 4789: PO_VALIDATION_HELPER.secondary_unit_of_measure(p_id_tbl => p_line_locations.interface_id,

4785: p_operating_unit => l_operating_unit,
4786: x_result_set_id => l_result_set_id,
4787: x_result_type => l_result_type);
4788: WHEN c_line_loc_secondary_uom THEN
4789: PO_VALIDATION_HELPER.secondary_unit_of_measure(p_id_tbl => p_line_locations.interface_id,
4790: p_entity_type => c_entity_type_line_location,
4791: p_secondary_unit_of_meas_tbl => p_line_locations.secondary_unit_of_measure,
4792: p_item_id_tbl => p_line_locations.item_id,
4793: p_item_tbl => p_line_locations.item,

Line 4800: PO_VALIDATION_HELPER.secondary_quantity(p_id_tbl => p_line_locations.interface_id,

4796: p_create_or_update_item_flag => l_create_or_update_item,
4797: x_results => x_results,
4798: x_result_type => l_result_type);
4799: WHEN c_line_loc_secondary_quantity THEN
4800: PO_VALIDATION_HELPER.secondary_quantity(p_id_tbl => p_line_locations.interface_id,
4801: p_entity_type => c_entity_type_line_location,
4802: p_secondary_quantity_tbl => p_line_locations.secondary_quantity,
4803: p_order_type_lookup_code_tbl => p_line_locations.order_type_lookup_code,
4804: p_item_id_tbl => p_line_locations.item_id,

Line 4812: PO_VALIDATION_HELPER.preferred_grade(p_id_tbl => p_line_locations.interface_id,

4808: p_create_or_update_item_flag => l_create_or_update_item,
4809: x_results => x_results,
4810: x_result_type => l_result_type);
4811: WHEN c_line_loc_preferred_grade THEN
4812: PO_VALIDATION_HELPER.preferred_grade(p_id_tbl => p_line_locations.interface_id,
4813: p_entity_type => c_entity_type_line_location,
4814: p_preferred_grade_tbl => p_line_locations.preferred_grade,
4815: p_item_id_tbl => p_line_locations.item_id,
4816: p_item_tbl => p_line_locations.item,

Line 4824: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4820: x_results => x_results,
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',

Line 4838: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4852: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4866: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 4881: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4877: x_results => x_results,
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',

Line 4897: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4893: x_result_type => l_result_type);
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',

Line 4913: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4909: x_result_type => l_result_type);
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',

Line 4925: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4921: x_result_type => l_result_type);
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',

Line 4941: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4937: x_result_type => l_result_type);
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',

Line 4957: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4953: x_result_type => l_result_type);
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',

Line 4973: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4969: x_result_type => l_result_type);
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',

Line 4989: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

4985: x_result_type => l_result_type);
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',

Line 5005: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

5001: x_result_type => l_result_type);
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',

Line 5021: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

5017: x_result_type => l_result_type);
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',

Line 5037: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

5033: x_result_type => l_result_type);
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',

Line 5052: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

5048: x_results => x_results,
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',

Line 5066: PO_VALIDATION_HELPER.ensure_null(p_calling_module => p_calling_program,

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
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',

Line 5965: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,

5961: );
5962: --Enhanced Pricing End:
5963: --UCA Project - CLMR4 Changes Begin
5964: WHEN c_undef_amt_gt_zero THEN
5965: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,
5966: p_null_allowed_flag => PO_CORE_S.g_parameter_YES,
5967: p_value_tbl => p_po_line_ucas.UNDEF_AMOUNT,
5968: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5969: p_entity_type => c_entity_type_LINE_UCAS,

Line 5977: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,

5973: x_results => x_results,
5974: x_result_type => l_result_type);
5975:
5976: WHEN c_lgl_gt_zero THEN
5977: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,
5978: p_null_allowed_flag => PO_CORE_S.g_parameter_YES,
5979: p_value_tbl => p_po_line_ucas.LIMIT_GOV_LIABILITY_AMT,
5980: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5981: p_entity_type => c_entity_type_LINE_UCAS,

Line 5989: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,

5985: x_results => x_results,
5986: x_result_type => l_result_type);
5987:
5988: WHEN c_nte_gt_zero THEN
5989: PO_VALIDATION_HELPER.greater_or_equal_zero(p_calling_module => p_calling_program,
5990: p_null_allowed_flag => PO_CORE_S.g_parameter_YES,
5991: p_value_tbl => p_po_line_ucas.NOT_TO_EXCEED_AMOUNT,
5992: p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID,
5993: p_entity_type => c_entity_type_LINE_UCAS,

Line 6000: PO_VALIDATION_HELPER.num1_less_or_equal_num2(

5996: p_validation_id => PO_VAL_CONSTANTS.c_nte_gt_zero,
5997: x_results => x_results,
5998: x_result_type => l_result_type);
5999: WHEN c_lgl_le_nte THEN
6000: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
6001: p_calling_module => p_calling_program
6002: , p_num1_tbl => p_po_line_ucas.LIMIT_GOV_LIABILITY_AMT
6003: , p_num2_tbl => p_po_line_ucas.NOT_TO_EXCEED_AMOUNT
6004: , p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID

Line 6011: PO_VALIDATION_HELPER.num1_less_or_equal_num2(

6007: , p_message_name => PO_MESSAGE_S.PO_UCA_LGL_LE_NTE
6008: , x_results => x_results
6009: , x_result_type => l_result_type);
6010: WHEN c_undef_amt_le_nte THEN
6011: PO_VALIDATION_HELPER.num1_less_or_equal_num2(
6012: p_calling_module => p_calling_program
6013: , p_num1_tbl => p_po_line_ucas.UNDEF_AMOUNT
6014: , p_num2_tbl => p_po_line_ucas.NOT_TO_EXCEED_AMOUNT
6015: , p_entity_id_tbl => p_po_line_ucas.PO_LINE_UCA_ID