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 2704: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;

2700: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
2701: (p_create_or_update_item_flag = 'N' and p_item_id_tbl(i) IS NULL)) AND
2702: p_secondary_unit_of_meas_tbl(i) IS NOT NULL THEN
2703: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2704: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2705: ELSE
2706: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2707: END IF;
2708: x_results.add_result(p_entity_type => p_entity_type,

Line 2706: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;

2702: p_secondary_unit_of_meas_tbl(i) IS NOT NULL THEN
2703: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2704: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2705: ELSE
2706: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2707: END IF;
2708: x_results.add_result(p_entity_type => p_entity_type,
2709: p_entity_id => p_id_tbl(i),
2710: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2721: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;

2717: IF l_secondary_unit_of_meas_tbl(i) IS NULL THEN
2718: IF (p_secondary_unit_of_meas_tbl(i) IS NOT NULL) THEN
2719: -- Item is not dual control
2720: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2721: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2722: ELSE
2723: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2724: END IF;
2725: x_results.add_result(p_entity_type => p_entity_type,

Line 2723: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;

2719: -- Item is not dual control
2720: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2721: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_null;
2722: ELSE
2723: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_null;
2724: END IF;
2725: x_results.add_result(p_entity_type => p_entity_type,
2726: p_entity_id => p_id_tbl(i),
2727: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2737: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;

2733: ELSE -- l_secondary_unit_of_measure is not null
2734: IF p_secondary_unit_of_meas_tbl(i) IS NULL THEN
2735: -- Secondary UOM missing for dual control item
2736: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2737: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2738: ELSE
2739: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2740: END IF;
2741: x_results.add_result(p_entity_type => p_entity_type,

Line 2739: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;

2735: -- Secondary UOM missing for dual control item
2736: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2737: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_not_null;
2738: ELSE
2739: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_not_null;
2740: END IF;
2741: x_results.add_result(p_entity_type => p_entity_type,
2742: p_entity_id => p_id_tbl(i),
2743: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2753: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;

2749:
2750: IF l_secondary_unit_of_meas_tbl(i) <> p_secondary_unit_of_meas_tbl(i) THEN
2751: -- Secondary UOM specified is incorrect.
2752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2753: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;
2754: ELSE
2755: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;
2756: END IF;
2757: x_results.add_result(p_entity_type => p_entity_type,

Line 2755: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;

2751: -- Secondary UOM specified is incorrect.
2752: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2753: l_validation_id := PO_VAL_CONSTANTS.c_line_secondary_uom_correct;
2754: ELSE
2755: l_validation_id := PO_VAL_CONSTANTS.c_loc_secondary_uom_correct;
2756: END IF;
2757: x_results.add_result(p_entity_type => p_entity_type,
2758: p_entity_id => p_id_tbl(i),
2759: p_column_name => 'SECONDARY_UNIT_OF_MEASURE',

Line 2840: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;

2836: FOR i IN 1 .. p_id_tbl.COUNT LOOP
2837: IF p_order_type_lookup_code_tbl(i) IN ('FIXED PRICE', 'RATE') AND
2838: p_secondary_quantity_tbl(i) IS NOT NULL THEN
2839: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2840: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;
2841: ELSE
2842: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;
2843: END IF;
2844: x_results.add_result(p_entity_type => p_entity_type,

Line 2842: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;

2838: p_secondary_quantity_tbl(i) IS NOT NULL THEN
2839: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2840: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_null;
2841: ELSE
2842: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_null;
2843: END IF;
2844: x_results.add_result(p_entity_type => p_entity_type,
2845: p_entity_id => p_id_tbl(i),
2846: p_column_name => 'SECONDARY_QUANTITY',

Line 2860: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;

2856: p_secondary_quantity_tbl(i) IS NOT NULL AND
2857: p_secondary_quantity_tbl(i) < 0
2858: THEN
2859: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2860: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;
2861: ELSE
2862: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;
2863: END IF;
2864: x_results.add_result(p_entity_type => p_entity_type,

Line 2862: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;

2858: THEN
2859: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2860: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_ge_zero;
2861: ELSE
2862: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_ge_zero;
2863: END IF;
2864: x_results.add_result(p_entity_type => p_entity_type,
2865: p_entity_id => p_id_tbl(i),
2866: p_column_name => 'SECONDARY_QUANTITY',

Line 2880: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;

2876: p_secondary_quantity_tbl(i) IS NOT NULL AND
2877: p_secondary_quantity_tbl(i) = 0
2878: THEN
2879: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2880: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;
2881: ELSE
2882: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;
2883: END IF;
2884: x_results.add_result(p_entity_type => p_entity_type,

Line 2882: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;

2878: THEN
2879: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2880: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_zero;
2881: ELSE
2882: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_zero;
2883: END IF;
2884: x_results.add_result(p_entity_type => p_entity_type,
2885: p_entity_id => p_id_tbl(i),
2886: p_column_name => 'SECONDARY_QUANTITY',

Line 2902: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;

2898: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
2899: p_secondary_quantity_tbl(i) IS NOT NULL AND
2900: p_doc_type IN ('STANDARD', 'BLANKET') THEN
2901: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2902: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;
2903: ELSE
2904: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;
2905: END IF;
2906: x_results.add_result(p_entity_type => p_entity_type,

Line 2904: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;

2900: p_doc_type IN ('STANDARD', 'BLANKET') THEN
2901: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2902: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_not_reqd;
2903: ELSE
2904: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_reqd;
2905: END IF;
2906: x_results.add_result(p_entity_type => p_entity_type,
2907: p_entity_id => p_id_tbl(i),
2908: p_column_name => 'SECONDARY_QUANTITY',

Line 2924: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;

2920:
2921: IF p_secondary_quantity_tbl(i) IS NOT NULL AND p_doc_type IN ('STANDARD', 'BLANKET') THEN
2922: -- Item is not dual control
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
2927: END IF;
2928: x_results.add_result(p_entity_type => p_entity_type,

Line 2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;

2922: -- Item is not dual control
2923: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2924: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_no_req_uom;
2925: ELSE
2926: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_not_req_uom;
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_QUANTITY',

Line 2943: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;

2939:
2940: IF p_secondary_quantity_tbl(i) IS NULL AND p_doc_type='STANDARD' THEN
2941: -- Secondary Quantity missing for dual control item
2942: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2943: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
2944: ELSE
2945: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
2946: END IF;
2947: x_results.add_result(p_entity_type => p_entity_type,

Line 2945: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;

2941: -- Secondary Quantity missing for dual control item
2942: IF (p_entity_type = PO_VALIDATIONS.c_entity_type_line) THEN
2943: l_validation_id := PO_VAL_CONSTANTS.c_line_sec_quantity_req_uom;
2944: ELSE
2945: l_validation_id := PO_VAL_CONSTANTS.c_loc_sec_quantity_req_uom;
2946: END IF;
2947: x_results.add_result(p_entity_type => p_entity_type,
2948: p_entity_id => p_id_tbl(i),
2949: p_column_name => 'SECONDARY_QUANTITY',

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

3114: -- x_item is not derived for existing items..
3115: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
3116: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
3117: p_preferred_grade_tbl(i) IS NOT NULL THEN
3118: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN
3119: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;
3120: ELSE
3121: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;
3122: END IF;

Line 3119: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;

3115: IF ((p_create_or_update_item_flag = 'Y' AND p_item_id_tbl(i) IS NULL AND p_item_tbl(i) IS NULL) OR
3116: (p_create_or_update_item_flag = 'N' AND p_item_id_tbl(i) IS NULL )) AND
3117: p_preferred_grade_tbl(i) IS NOT NULL THEN
3118: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN
3119: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;
3120: ELSE
3121: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;
3122: END IF;
3123: x_results.add_result(p_entity_type => p_entity_type,

Line 3121: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;

3117: p_preferred_grade_tbl(i) IS NOT NULL THEN
3118: IF (p_validation_id = PO_VAL_CONSTANTS.c_line_preferred_grade) THEN
3119: l_validation_id := PO_VAL_CONSTANTS.c_line_preferred_grade_item;
3120: ELSE
3121: l_validation_id := PO_VAL_CONSTANTS.c_loc_preferred_grade_item;
3122: END IF;
3123: x_results.add_result(p_entity_type => p_entity_type,
3124: p_entity_id => p_id_tbl(i),
3125: p_column_name => 'PREFERRED_GRADE',

Line 3150: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,

3146: p_id_tbl(i),
3147: 'PO_ITEM_NOT_GRADE_CTRL',
3148: 'PREFERRED_GRADE',
3149: p_preferred_grade_tbl(i),
3150: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3151: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3152: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3153: FROM DUAL
3154: WHERE p_preferred_grade_tbl(i) IS NOT NULL

Line 3151: PO_VAL_CONSTANTS.c_line_preferred_grade_item,

3147: 'PO_ITEM_NOT_GRADE_CTRL',
3148: 'PREFERRED_GRADE',
3149: p_preferred_grade_tbl(i),
3150: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3151: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3152: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3153: FROM DUAL
3154: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3155: AND p_item_id_tbl(i) IS NOT NULL

Line 3152: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)

3148: 'PREFERRED_GRADE',
3149: p_preferred_grade_tbl(i),
3150: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3151: PO_VAL_CONSTANTS.c_line_preferred_grade_item,
3152: PO_VAL_CONSTANTS.c_loc_preferred_grade_item)
3153: FROM DUAL
3154: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3155: AND p_item_id_tbl(i) IS NOT NULL
3156: AND EXISTS(

Line 3184: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,

3180: p_id_tbl(i),
3181: 'PO_INVALID_GRADE_CODE',
3182: 'PREFERRED_GRADE',
3183: p_preferred_grade_tbl(i),
3184: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3185: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3186: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3187: FROM DUAL
3188: WHERE p_preferred_grade_tbl(i) IS NOT NULL

Line 3185: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,

3181: 'PO_INVALID_GRADE_CODE',
3182: 'PREFERRED_GRADE',
3183: p_preferred_grade_tbl(i),
3184: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3185: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3186: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3187: FROM DUAL
3188: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3189: AND NOT EXISTS(

Line 3186: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)

3182: 'PREFERRED_GRADE',
3183: p_preferred_grade_tbl(i),
3184: DECODE(p_validation_id, PO_VAL_CONSTANTS.c_line_preferred_grade,
3185: PO_VAL_CONSTANTS.c_line_preferred_grade_valid,
3186: PO_VAL_CONSTANTS.c_loc_preferred_grade_valid)
3187: FROM DUAL
3188: WHERE p_preferred_grade_tbl(i) IS NOT NULL
3189: AND NOT EXISTS(
3190: SELECT 1