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_VALIDATION_HELPER dependencies on PO_VAL_CONSTANTS

Line 2891: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;

2887: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
2888: (p_create_or_update_item_flag = 'N' and p_item_id_tbl(i) IS NULL)) AND
2889: p_secondary_unit_of_meas_tbl(i) IS NOT NULL THEN
2890: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2891: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2892: ELSE
2893: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2894: END IF;
2895: x_results.add_result(p_entity_type => p_entity_type,

Line 2893: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;

2889: p_secondary_unit_of_meas_tbl(i) IS NOT NULL THEN
2890: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2891: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2892: ELSE
2893: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2894: END IF;
2895: x_results.add_result(p_entity_type => p_entity_type,
2896: p_entity_id => p_id_tbl(i),
2897: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2908: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;

2904: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2905: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN
2906: -- Item is not dual control
2907: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2908: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2909: ELSE
2910: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2911: END IF;
2912: x_results.add_result(p_entity_type => p_entity_type,

Line 2910: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;

2906: -- Item is not dual control
2907: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2908: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2909: ELSE
2910: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2911: END IF;
2912: x_results.add_result(p_entity_type => p_entity_type,
2913: p_entity_id => p_id_tbl(i),
2914: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2924: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;

2920: ELSE -- l_secondary_unit_of_measure is not null
2921: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2922: -- Secondary UOM missing for dual control item
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2927: END IF;
2928: x_results.add_result(p_entity_type => p_entity_type,

Line 2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;

2922: -- Secondary UOM missing for dual control item
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2927: END IF;
2928: x_results.add_result(p_entity_type => p_entity_type,
2929: p_entity_id => p_id_tbl(i),
2930: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2940: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;

2936:
2937: IF l_secondary_unit_of_meas_tbl(i) <> p_secondary_unit_of_meas_tbl(i) THEN
2938: -- Secondary UOM specified is incorrect.
2939: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2940: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;
2941: ELSE
2942: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;
2943: END IF;
2944: x_results.add_result(p_entity_type => p_entity_type,

Line 2942: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;

2938: -- Secondary UOM specified is incorrect.
2939: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2940: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;
2941: ELSE
2942: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;
2943: END IF;
2944: x_results.add_result(p_entity_type => p_entity_type,
2945: p_entity_id => p_id_tbl(i),
2946: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 3027: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;

3023: FOR i IN 1 .. p_id_tbl.COUNT LOOP
3024: IF p_order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') AND
3025: p_secondary_quantity_tbl(i) IS NOT NULL THEN
3026: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3027: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;
3028: ELSE
3029: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;
3030: END IF;
3031: x_results.add_result(p_entity_type => p_entity_type,

Line 3029: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;

3025: p_secondary_quantity_tbl(i) IS NOT NULL THEN
3026: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3027: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;
3028: ELSE
3029: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;
3030: END IF;
3031: x_results.add_result(p_entity_type => p_entity_type,
3032: p_entity_id => p_id_tbl(i),
3033: p_column_name => 'SECONDARY_QUANTITY',

Line 3047: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;

3043: p_secondary_quantity_tbl(i) IS NOT NULL AND
3044: p_secondary_quantity_tbl(i) < 0
3045: THEN
3046: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3047: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;
3048: ELSE
3049: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;
3050: END IF;
3051: x_results.add_result(p_entity_type => p_entity_type,

Line 3049: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;

3045: THEN
3046: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3047: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;
3048: ELSE
3049: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;
3050: END IF;
3051: x_results.add_result(p_entity_type => p_entity_type,
3052: p_entity_id => p_id_tbl(i),
3053: p_column_name => 'SECONDARY_QUANTITY',

Line 3067: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;

3063: p_secondary_quantity_tbl(i) IS NOT NULL AND
3064: p_secondary_quantity_tbl(i) = 0
3065: THEN
3066: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3067: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;
3068: ELSE
3069: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;
3070: END IF;
3071: x_results.add_result(p_entity_type => p_entity_type,

Line 3069: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;

3065: THEN
3066: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3067: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;
3068: ELSE
3069: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;
3070: END IF;
3071: x_results.add_result(p_entity_type => p_entity_type,
3072: p_entity_id => p_id_tbl(i),
3073: p_column_name => 'SECONDARY_QUANTITY',

Line 3089: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;

3085: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
3086: p_secondary_quantity_tbl(i) IS NOT NULL AND
3087: p_doc_type IN ('STANDARD', 'BLANKET') THEN
3088: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3089: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;
3090: ELSE
3091: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;
3092: END IF;
3093: x_results.add_result(p_entity_type => p_entity_type,

Line 3091: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;

3087: p_doc_type IN ('STANDARD', 'BLANKET') THEN
3088: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3089: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;
3090: ELSE
3091: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;
3092: END IF;
3093: x_results.add_result(p_entity_type => p_entity_type,
3094: p_entity_id => p_id_tbl(i),
3095: p_column_name => 'SECONDARY_QUANTITY',

Line 3111: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;

3107:
3108: IF p_secondary_quantity_tbl(i) IS NOT NULL AND p_doc_type IN ('STANDARD', 'BLANKET') THEN
3109: -- Item is not dual control
3110: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3111: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
3112: ELSE
3113: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
3114: END IF;
3115: x_results.add_result(p_entity_type => p_entity_type,

Line 3113: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;

3109: -- Item is not dual control
3110: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3111: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
3112: ELSE
3113: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
3114: END IF;
3115: x_results.add_result(p_entity_type => p_entity_type,
3116: p_entity_id => p_id_tbl(i),
3117: p_column_name => 'SECONDARY_QUANTITY',

Line 3130: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;

3126:
3127: IF p_secondary_quantity_tbl(i) IS NULL AND p_doc_type='STANDARD' THEN
3128: -- Secondary Quantity missing for dual control item
3129: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3130: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
3131: ELSE
3132: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
3133: END IF;
3134: x_results.add_result(p_entity_type => p_entity_type,

Line 3132: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;

3128: -- Secondary Quantity missing for dual control item
3129: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
3130: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
3131: ELSE
3132: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
3133: END IF;
3134: x_results.add_result(p_entity_type => p_entity_type,
3135: p_entity_id => p_id_tbl(i),
3136: p_column_name => 'SECONDARY_QUANTITY',

Line 3305: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN

3301: -- x_item is not derived for existing items..
3302: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
3303: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
3304: p_preferred_grade_tbl(i) IS NOT NULL THEN
3305: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN
3306: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;
3307: ELSE
3308: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;
3309: END IF;

Line 3306: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;

3302: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
3303: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
3304: p_preferred_grade_tbl(i) IS NOT NULL THEN
3305: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN
3306: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;
3307: ELSE
3308: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;
3309: END IF;
3310: x_results.add_result(p_entity_type => p_entity_type,

Line 3308: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;

3304: p_preferred_grade_tbl(i) IS NOT NULL THEN
3305: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN
3306: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;
3307: ELSE
3308: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;
3309: END IF;
3310: x_results.add_result(p_entity_type => p_entity_type,
3311: p_entity_id => p_id_tbl(i),
3312: p_column_name => 'PREFERRED_GRADE',

Line 3337: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,

3333: p_id_tbl(i),
3334: 'PO_ITEM_NOT_GRADE_CTRL',
3335: 'PREFERRED_GRADE',
3336: p_preferred_grade_tbl(i),
3337: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3338: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3339: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3340: FROM DUAL
3341: WHERE p_preferred_grade_tbl(i) IS NOT NULL

Line 3338: PO_VAL_CONSTANTS.c_line_preferred_grade_item,

3334: 'PO_ITEM_NOT_GRADE_CTRL',
3335: 'PREFERRED_GRADE',
3336: p_preferred_grade_tbl(i),
3337: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3338: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3339: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3340: FROM DUAL
3341: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3342: AND p_item_id_tbl(i) IS NOT NULL

Line 3339: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)

3335: 'PREFERRED_GRADE',
3336: p_preferred_grade_tbl(i),
3337: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3338: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3339: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3340: FROM DUAL
3341: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3342: AND p_item_id_tbl(i) IS NOT NULL
3343: AND EXISTS(

Line 3371: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,

3367: p_id_tbl(i),
3368: 'PO_INVALID_GRADE_CODE',
3369: 'PREFERRED_GRADE',
3370: p_preferred_grade_tbl(i),
3371: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3372: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3373: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3374: FROM DUAL
3375: WHERE p_preferred_grade_tbl(i) IS NOT NULL

Line 3372: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,

3368: 'PO_INVALID_GRADE_CODE',
3369: 'PREFERRED_GRADE',
3370: p_preferred_grade_tbl(i),
3371: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3372: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3373: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3374: FROM DUAL
3375: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3376: AND NOT EXISTS(

Line 3373: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)

3369: 'PREFERRED_GRADE',
3370: p_preferred_grade_tbl(i),
3371: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3372: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3373: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3374: FROM DUAL
3375: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3376: AND NOT EXISTS(
3377: SELECT 1