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

APPS.PO_VALIDATIONS dependencies on PO_VAL_LINES

Line 2848: PO_VAL_LINES.amt_agreed_ge_zero(

2844: -- Line Validations
2845: ---------------------------------------------------------------
2846:
2847: WHEN c_amt_agreed_ge_zero THEN
2848: PO_VAL_LINES.amt_agreed_ge_zero(
2849: p_line_id_tbl => p_lines.po_line_id
2850: , p_committed_amount_tbl => p_lines.committed_amount
2851: , x_results => x_results
2852: , x_result_type => l_result_type

Line 2856: PO_VAL_LINES.min_rel_amt_ge_zero(

2852: , x_result_type => l_result_type
2853: );
2854:
2855: WHEN c_min_rel_amt_ge_zero THEN
2856: PO_VAL_LINES.min_rel_amt_ge_zero(
2857: p_line_id_tbl => p_lines.po_line_id
2858: , p_min_release_amount_tbl => p_lines.min_release_amount
2859: , x_results => x_results
2860: , x_result_type => l_result_type

Line 2864: PO_VAL_LINES.quantity_gt_zero(

2860: , x_result_type => l_result_type
2861: );
2862:
2863: WHEN c_line_qty_gt_zero THEN
2864: PO_VAL_LINES.quantity_gt_zero(
2865: p_line_id_tbl => p_lines.po_line_id
2866: , p_quantity_tbl => p_lines.quantity
2867: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2868: , p_clm_info_flag_tbl => p_lines.clm_info_flag --CLM Changes

Line 2877: PO_VAL_LINES2.category_combination_valid(

2873: );
2874:
2875: -- bug 8633959 start
2876: WHEN c_validate_category THEN
2877: PO_VAL_LINES2.category_combination_valid(
2878: p_po_line_id_tbl => p_lines.po_line_id
2879: , p_category_id_tbl => p_lines.category_id
2880: , p_clm_info_flag_tbl => p_lines.clm_info_flag --Bug 12768893
2881: , x_results => x_results

Line 2888: PO_VAL_LINES.quantity_ge_quantity_exec(

2884: -- bug 8633959 end
2885:
2886: -- : Consolidate qty rcvd/billed check
2887: WHEN c_line_qty_ge_qty_exec THEN
2888: PO_VAL_LINES.quantity_ge_quantity_exec(
2889: p_line_id_tbl => p_lines.po_line_id
2890: , p_quantity_tbl => p_lines.quantity
2891: , x_result_set_id => l_result_set_id
2892: , x_result_type => l_result_type

Line 2897: PO_VAL_LINES.quantity_ge_quantity_enc(

2893: );
2894: --
2895:
2896: WHEN c_line_qty_ge_qty_enc THEN
2897: PO_VAL_LINES.quantity_ge_quantity_enc(
2898: p_line_id_tbl => p_lines.po_line_id
2899: , p_quantity_tbl => p_lines.quantity
2900: , x_result_set_id => l_result_set_id
2901: , x_result_type => l_result_type

Line 2905: PO_VAL_LINES.quantity_notif_change(

2901: , x_result_type => l_result_type
2902: );
2903:
2904: WHEN c_quantity_notif_change THEN
2905: PO_VAL_LINES.quantity_notif_change(
2906: p_line_id_tbl => p_lines.po_line_id
2907: , p_quantity_tbl => p_lines.quantity
2908: , x_result_set_id => l_result_set_id
2909: , x_result_type => l_result_type

Line 2913: PO_VAL_LINES.amount_gt_zero(

2909: , x_result_type => l_result_type
2910: );
2911:
2912: WHEN c_line_amt_gt_zero THEN
2913: PO_VAL_LINES.amount_gt_zero(
2914: p_line_id_tbl => p_lines.po_line_id
2915: , p_amount_tbl => p_lines.amount
2916: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
2917: , p_clm_info_flag_tbl => p_lines.clm_info_flag

Line 2926: PO_VAL_LINES.amount_ge_amount_exec(

2922: );
2923:
2924: -- : Consolidate amt rcvd/billed check
2925: WHEN c_line_amt_ge_amt_exec THEN
2926: PO_VAL_LINES.amount_ge_amount_exec(
2927: p_line_id_tbl => p_lines.po_line_id
2928: , p_amount_tbl => p_lines.amount
2929: , p_currency_code_tbl => p_lines.hdr_currency_code
2930: , x_result_set_id => l_result_set_id

Line 2936: PO_VAL_LINES.amount_ge_timecard(

2932: );
2933: --
2934:
2935: WHEN c_line_amt_ge_timecard THEN
2936: PO_VAL_LINES.amount_ge_timecard(
2937: p_line_id_tbl => p_lines.po_line_id
2938: , p_amount_tbl => p_lines.amount
2939: , x_results => x_results
2940: , x_result_type => l_result_type

Line 2944: PO_VAL_LINES.line_num_unique(

2940: , x_result_type => l_result_type
2941: );
2942:
2943: WHEN c_line_num_unique THEN
2944: PO_VAL_LINES.line_num_unique(
2945: p_line_id_tbl => p_lines.po_line_id
2946: , p_header_id_tbl => p_lines.po_header_id
2947: , p_line_num_tbl => p_lines.line_num
2948: , p_par_draft_id_tbl => p_lines.PAR_DRAFT_ID --

Line 2955: PO_VAL_LINES.line_num_gt_zero(

2951: , x_result_type => l_result_type
2952: );
2953:
2954: WHEN c_line_num_gt_zero THEN
2955: PO_VAL_LINES.line_num_gt_zero(
2956: p_line_id_tbl => p_lines.po_line_id
2957: , p_line_num_tbl => p_lines.line_num
2958: , x_results => x_results
2959: , x_result_type => l_result_type

Line 2963: PO_VAL_LINES.vmi_asl_exists(

2959: , x_result_type => l_result_type
2960: );
2961:
2962: WHEN c_vmi_asl_exists THEN
2963: PO_VAL_LINES.vmi_asl_exists(
2964: p_line_id_tbl => p_lines.po_line_id
2965: , p_type_lookup_code_tbl => p_lines.hdr_type_lookup_code
2966: , p_item_id_tbl => p_lines.item_id
2967: -- Bug# 4634769: Pass in the inventory org id

Line 2976: PO_VAL_LINES.start_date_le_end_date(

2972: , x_result_type => l_result_type
2973: );
2974:
2975: WHEN c_start_date_le_end_date THEN
2976: PO_VAL_LINES.start_date_le_end_date(
2977: p_line_id_tbl => p_lines.po_line_id
2978: , p_start_date_tbl => p_lines.start_date
2979: , p_expiration_date_tbl => p_lines.expiration_date
2980: , x_results => x_results

Line 2985: PO_VAL_LINES.otl_invalid_start_date_change(

2981: , x_result_type => l_result_type
2982: );
2983:
2984: WHEN c_otl_inv_start_date_change THEN
2985: PO_VAL_LINES.otl_invalid_start_date_change(
2986: p_line_id_tbl => p_lines.po_line_id
2987: , p_start_date_tbl => p_lines.start_date
2988: , x_results => x_results
2989: , x_result_type => l_result_type

Line 2993: PO_VAL_LINES.otl_invalid_end_date_change(

2989: , x_result_type => l_result_type
2990: );
2991:
2992: WHEN c_otl_inv_end_date_change THEN
2993: PO_VAL_LINES.otl_invalid_end_date_change(
2994: p_line_id_tbl => p_lines.po_line_id
2995: , p_expiration_date_tbl => p_lines.expiration_date
2996: , x_results => x_results
2997: , x_result_type => l_result_type

Line 3001: PO_VAL_LINES.unit_price_ge_zero(

2997: , x_result_type => l_result_type
2998: );
2999:
3000: WHEN c_unit_price_ge_zero THEN
3001: PO_VAL_LINES.unit_price_ge_zero(
3002: p_line_id_tbl => p_lines.po_line_id
3003: , p_unit_price_tbl => p_lines.unit_price
3004: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3005: , p_clm_info_flag_tbl => p_lines.clm_info_flag

Line 3011: PO_VAL_LINES.list_price_ge_zero(

3007: , x_result_type => l_result_type
3008: );
3009:
3010: WHEN c_list_price_ge_zero THEN
3011: PO_VAL_LINES.list_price_ge_zero(
3012: p_line_id_tbl => p_lines.po_line_id
3013: , p_list_price_per_unit_tbl => p_lines.list_price_per_unit
3014: , x_results => x_results
3015: , x_result_type => l_result_type

Line 3019: PO_VAL_LINES.market_price_ge_zero(

3015: , x_result_type => l_result_type
3016: );
3017:
3018: WHEN c_market_price_ge_zero THEN
3019: PO_VAL_LINES.market_price_ge_zero(
3020: p_line_id_tbl => p_lines.po_line_id
3021: , p_market_price_tbl => p_lines.market_price
3022: , x_results => x_results
3023: , x_result_type => l_result_type

Line 3027: PO_VAL_LINES.validate_unit_price_change(

3023: , x_result_type => l_result_type
3024: );
3025:
3026: WHEN c_validate_unit_price_change THEN
3027: PO_VAL_LINES.validate_unit_price_change(
3028: p_line_id_tbl => p_lines.po_line_id
3029: , p_unit_price_tbl => p_lines.unit_price
3030: , p_price_break_lookup_code_tbl => p_lines.price_break_lookup_code
3031: , p_amt_changed_flag_tbl => p_lines.amount_changed_flag -- --

Line 3038: PO_VAL_LINES.expiration_ge_blanket_start(

3034: , x_result_type => l_result_type
3035: );
3036:
3037: WHEN c_expiration_ge_blanket_start THEN
3038: PO_VAL_LINES.expiration_ge_blanket_start(
3039: p_line_id_tbl => p_lines.po_line_id
3040: , p_blanket_start_date_tbl => p_lines.hdr_start_date
3041: , p_expiration_date_tbl => p_lines.expiration_date
3042: , x_results => x_results

Line 3047: PO_VAL_LINES.expiration_le_blanket_end(

3043: , x_result_type => l_result_type
3044: );
3045:
3046: WHEN c_expiration_le_blanket_end THEN
3047: PO_VAL_LINES.expiration_le_blanket_end(
3048: p_line_id_tbl => p_lines.po_line_id
3049: , p_blanket_end_date_tbl => p_lines.hdr_end_date
3050: , p_expiration_date_tbl => p_lines.expiration_date
3051: , x_results => x_results

Line 3057: PO_VAL_LINES.qty_ge_qty_milestone_exec(

3053: );
3054:
3055: --
3056: WHEN c_qty_ge_qty_milestone_exec THEN
3057: PO_VAL_LINES.qty_ge_qty_milestone_exec(
3058: p_line_id_tbl => p_lines.po_line_id
3059: , p_quantity_tbl => p_lines.quantity
3060: , x_result_set_id => l_result_set_id
3061: , x_result_type => l_result_type

Line 3065: PO_VAL_LINES.price_ge_price_milestone_exec(

3061: , x_result_type => l_result_type
3062: );
3063:
3064: WHEN c_price_ge_price_mstone_exec THEN
3065: PO_VAL_LINES.price_ge_price_milestone_exec(
3066: p_line_id_tbl => p_lines.po_line_id
3067: , p_price_tbl => p_lines.unit_price
3068: , x_result_set_id => l_result_set_id
3069: , x_result_type => l_result_type

Line 3074: PO_VAL_LINES.recoupment_rate_range_check(

3070: );
3071:
3072: -- Bug 5072189 START
3073: WHEN c_recoupment_rate_range_check THEN
3074: PO_VAL_LINES.recoupment_rate_range_check(
3075: p_line_id_tbl => p_lines.po_line_id
3076: , p_recoupment_rate_tbl => p_lines.recoupment_rate
3077: , x_results => x_results
3078: , x_result_type => l_result_type

Line 3082: PO_VAL_LINES.retainage_rate_range_check(

3078: , x_result_type => l_result_type
3079: );
3080:
3081: WHEN c_retainage_rate_range_check THEN
3082: PO_VAL_LINES.retainage_rate_range_check(
3083: p_line_id_tbl => p_lines.po_line_id
3084: , p_retainage_rate_tbl => p_lines.retainage_rate
3085: , x_results => x_results
3086: , x_result_type => l_result_type

Line 3090: PO_VAL_LINES.prog_pay_rate_range_check(

3086: , x_result_type => l_result_type
3087: );
3088:
3089: WHEN c_prog_pay_rate_range_check THEN
3090: PO_VAL_LINES.prog_pay_rate_range_check(
3091: p_line_id_tbl => p_lines.po_line_id
3092: , p_prog_pay_rate_tbl => p_lines.progress_payment_rate
3093: , x_results => x_results
3094: , x_result_type => l_result_type

Line 3100: PO_VAL_LINES.max_retain_amt_ge_zero (

3096: -- Bug 5072189 END
3097:
3098: -- Bug 5221843 START
3099: WHEN c_max_retain_amt_ge_zero THEN
3100: PO_VAL_LINES.max_retain_amt_ge_zero (
3101: p_line_id_tbl => p_lines.po_line_id
3102: , p_max_retain_amt_tbl => p_lines.max_retainage_amount
3103: , x_results => x_results
3104: , x_result_type => l_result_type

Line 3110: PO_VAL_LINES.max_retain_amt_ge_retained (

3106: -- Bug 5221843 END
3107:
3108: -- Bug 5453079 START
3109: WHEN c_max_retain_amt_ge_retained THEN
3110: PO_VAL_LINES.max_retain_amt_ge_retained (
3111: p_line_id_tbl => p_lines.po_line_id
3112: , p_max_retain_amt_tbl => p_lines.max_retainage_amount
3113: , x_result_set_id => l_result_set_id
3114: , x_result_type => l_result_type

Line 3121: PO_VAL_LINES.unit_meas_not_null(

3117:
3118: --
3119:
3120: WHEN c_unit_meas_not_null THEN
3121: PO_VAL_LINES.unit_meas_not_null(
3122: p_line_id_tbl => p_lines.po_line_id
3123: , p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code
3124: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3125: , p_clm_info_flag_tbl => p_lines.clm_info_flag

Line 3131: PO_VAL_LINES.item_description_not_null(

3127: , x_result_type => l_result_type
3128: );
3129:
3130: WHEN c_item_description_not_null THEN
3131: PO_VAL_LINES.item_description_not_null(
3132: p_line_id_tbl => p_lines.po_line_id
3133: , p_item_description_tbl => p_lines.item_description
3134: , x_results => x_results
3135: , x_result_type => l_result_type

Line 3139: PO_VAL_LINES.category_id_not_null(

3135: , x_result_type => l_result_type
3136: );
3137:
3138: WHEN c_category_id_not_null THEN
3139: PO_VAL_LINES.category_id_not_null(
3140: p_line_id_tbl => p_lines.po_line_id
3141: , p_category_id_tbl => p_lines.category_id
3142: , p_clm_info_flag_tbl => p_lines.clm_info_flag
3143: , x_results => x_results

Line 3149: PO_VAL_LINES.item_id_not_null(

3145: );
3146:
3147: WHEN c_item_id_not_null THEN
3148: IF (p_calling_program = c_program_PDOI) THEN
3149: PO_VAL_LINES.item_id_not_null(
3150: p_id_tbl => p_lines.interface_id
3151: , p_item_id_tbl => p_lines.item_id
3152: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3153: , p_line_type_id_tbl => p_lines.line_type_id

Line 3160: PO_VAL_LINES.item_id_not_null(

3156: , x_result_set_id => l_result_set_id
3157: , x_result_type => l_result_type
3158: );
3159: ELSE
3160: PO_VAL_LINES.item_id_not_null(
3161: p_id_tbl => p_lines.po_line_id
3162: , p_item_id_tbl => p_lines.item_id
3163: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3164: , p_line_type_id_tbl => p_lines.line_type_id

Line 3173: PO_VAL_LINES.temp_labor_job_id_not_null(

3169: );
3170: END IF;
3171:
3172: WHEN c_temp_labor_job_id_not_null THEN
3173: PO_VAL_LINES.temp_labor_job_id_not_null(
3174: p_line_id_tbl => p_lines.po_line_id
3175: , p_job_id_tbl => p_lines.job_id
3176: , p_purchase_basis_tbl => p_lines.purchase_basis
3177: , x_results => x_results

Line 3182: PO_VAL_LINES.line_type_id_not_null(

3178: , x_result_type => l_result_type
3179: );
3180:
3181: WHEN c_line_type_id_not_null THEN
3182: PO_VAL_LINES.line_type_id_not_null(
3183: p_line_id_tbl => p_lines.po_line_id
3184: , p_line_type_id_tbl => p_lines.line_type_id
3185: , p_clm_info_flag_tbl => p_lines.clm_info_flag
3186: , x_results => x_results

Line 3191: PO_VAL_LINES.temp_lbr_start_date_not_null(

3187: , x_result_type => l_result_type
3188: );
3189:
3190: WHEN c_temp_lbr_start_date_not_null THEN
3191: PO_VAL_LINES.temp_lbr_start_date_not_null(
3192: p_line_id_tbl => p_lines.po_line_id
3193: , p_start_date_tbl => p_lines.start_date
3194: , p_purchase_basis_tbl => p_lines.purchase_basis
3195: , x_results => x_results

Line 3200: PO_VAL_LINES.src_doc_line_not_null(

3196: , x_result_type => l_result_type
3197: );
3198:
3199: WHEN c_src_doc_line_not_null THEN
3200: PO_VAL_LINES.src_doc_line_not_null(
3201: p_line_id_tbl => p_lines.po_line_id
3202: , p_from_header_id_tbl => p_lines.from_header_id
3203: , p_from_line_id_tbl => p_lines.from_line_id
3204: , x_results => x_results

Line 3210: PO_VAL_LINES.line_sec_quantity_gt_zero(

3206: );
3207:
3208: -- Opm related validation : OPM Integration R12 Start
3209: WHEN c_line_sec_qty_gt_zero THEN
3210: PO_VAL_LINES.line_sec_quantity_gt_zero(
3211: p_line_id_tbl => p_lines.po_line_id
3212: , p_item_id_tbl => p_lines.item_id
3213: , p_sec_quantity_tbl => p_lines.secondary_quantity
3214: , x_results => x_results

Line 3219: PO_VAL_LINES.line_qtys_within_deviation(

3215: , x_result_type => l_result_type
3216: );
3217:
3218: WHEN c_line_qtys_within_deviation THEN
3219: PO_VAL_LINES.line_qtys_within_deviation(
3220: p_line_id_tbl => p_lines.po_line_id
3221: , p_item_id_tbl => p_lines.item_id
3222: , p_quantity_tbl => p_lines.quantity
3223: , p_primary_uom_tbl => p_lines.unit_meas_lookup_code

Line 3232: PO_VAL_LINES.from_line_id_not_null(

3228: );
3229: -- Opm related validation : OPM Integration R12 End
3230:
3231: WHEN c_from_line_id_not_null THEN
3232: PO_VAL_LINES.from_line_id_not_null(
3233: p_line_id_tbl => p_lines.po_line_id
3234: , p_from_header_id_tbl => p_lines.from_header_id
3235: , p_from_line_id_tbl => p_lines.from_line_id
3236: , x_results => x_results

Line 3242: PO_VAL_LINES.advance_amt_le_amt(

3238: );
3239:
3240: -- Bug 5070210 Start
3241: WHEN c_amt_ge_advance_amt THEN
3242: PO_VAL_LINES.advance_amt_le_amt(
3243: p_line_id_tbl => p_lines.po_line_id,
3244: p_advance_tbl => p_lines.advance_amount,
3245: p_amount_tbl => p_lines.amount,
3246: p_quantity_tbl => p_lines.quantity,

Line 3255: PO_VAL_LINES.mod_no_cancel_shp_complt(

3251: -- Bug 5070210 End
3252:
3253: -- Mod Project
3254: WHEN c_lmod_no_cancel_shp_complt THEN
3255: PO_VAL_LINES.mod_no_cancel_shp_complt(
3256: p_line_id_tbl => p_lines.po_line_id
3257: , p_control_action_tbl => p_lines.control_action
3258: , x_result_set_id => l_result_set_id
3259: , x_result_type => l_result_type

Line 3264: PO_VAL_LINES.option_from_date_not_null(

3260: );
3261:
3262: -- CLM Changes Start
3263: WHEN c_option_from_date_not_null THEN
3264: PO_VAL_LINES.option_from_date_not_null(
3265: p_line_id_tbl => p_lines.po_line_id
3266: , p_option_ind_tbl => p_lines.clm_option_indicator
3267: , p_option_from_date_tbl => p_lines.clm_option_from_date
3268: , x_results => x_results

Line 3273: PO_VAL_LINES.option_to_date_not_null(

3269: , x_result_type => l_result_type
3270: );
3271:
3272: WHEN c_option_to_date_not_null THEN
3273: PO_VAL_LINES.option_to_date_not_null(
3274: p_line_id_tbl => p_lines.po_line_id
3275: , p_option_ind_tbl => p_lines.clm_option_indicator
3276: , p_option_to_date_tbl => p_lines.clm_option_to_date
3277: , x_results => x_results

Line 3281: PO_VAL_LINES.line_num_disp_check(

3277: , x_results => x_results
3278: , x_result_type => l_result_type
3279: );
3280: WHEN c_line_num_disp_check THEN
3281: PO_VAL_LINES.line_num_disp_check(
3282: p_line_id_tbl => p_lines.po_line_id
3283: , p_line_num_disp_tbl => p_lines.line_num_display
3284: , p_group_line_id_tbl => p_lines.group_line_id
3285: , p_clm_exhibit_name_tbl => p_lines.clm_exhibit_name

Line 3290: PO_VAL_LINES.option_to_date_le_from_date(

3286: , x_results => x_results
3287: , x_result_type => l_result_type
3288: );
3289: WHEN c_option_to_date_le_from_date THEN
3290: PO_VAL_LINES.option_to_date_le_from_date(
3291: p_line_id_tbl => p_lines.po_line_id
3292: , p_option_ind_tbl => p_lines.clm_option_indicator
3293: , p_option_from_date_tbl => p_lines.clm_option_from_date
3294: , p_option_to_Date_tbl => p_lines.clm_option_to_date

Line 3300: PO_VAL_LINES.option_from_date_le_sysdate(

3296: , x_result_type => l_result_type
3297: );
3298:
3299: WHEN c_option_from_date_le_sysdate THEN
3300: PO_VAL_LINES.option_from_date_le_sysdate(
3301: p_line_id_tbl => p_lines.po_line_id
3302: , p_option_ind_tbl => p_lines.clm_option_indicator
3303: , p_option_from_date_tbl => p_lines.clm_option_from_date
3304: , p_draft_id_tbl => p_lines.draft_id --bug 9785519

Line 3309: PO_VAL_LINES.option_fm_date_le_ex_date(

3305: , x_results => x_results
3306: , x_result_type => l_result_type
3307: );
3308: WHEN c_option_fm_date_le_ex_date THEN
3309: PO_VAL_LINES.option_fm_date_le_ex_date(
3310: p_line_id_tbl => p_lines.po_line_id
3311: , p_exer_flag_tbl => p_lines.clm_exercised_flag
3312: , p_option_from_date_tbl => p_lines.clm_option_from_date
3313: , p_option_exer_date_tbl => p_lines.clm_exercised_date

Line 3320: PO_VAL_LINES.order_start_date_le_end_date

3316: );
3317: -- CLM Changes End
3318: -- For PO Fed Fileds CLM
3319: WHEN c_order_start_date_le_end_date THEN
3320: PO_VAL_LINES.order_start_date_le_end_date
3321: (
3322: p_line_id_tbl => p_lines.po_line_id
3323: , p_start_date_tbl => p_lines.clm_order_start_date
3324: , p_expiration_date_tbl => p_lines.clm_order_end_date

Line 3329: PO_VAL_LINES.order_start_date_gt_sysdate

3325: , x_results => x_results
3326: , x_result_type => l_result_type
3327: );
3328: WHEN c_order_start_date_gt_sysdate THEN
3329: PO_VAL_LINES.order_start_date_gt_sysdate
3330: (
3331: p_line_id_tbl => p_lines.po_line_id
3332: , p_order_from_date_tbl => p_lines.clm_order_start_date
3333: , p_draft_id_tbl => p_lines.draft_id --bug 9785519

Line 3338: PO_VAL_LINES.max_tot_amt_le_line_tot_amt

3334: , x_results => x_results
3335: , x_result_type => l_result_type
3336: );
3337: WHEN c_max_tot_amt_le_line_tot_amt THEN
3338: PO_VAL_LINES.max_tot_amt_le_line_tot_amt
3339: (
3340: p_line_id_tbl => p_lines.po_line_id
3341: , p_max_total_amt_tbl => p_lines.CLM_MAX_TOTAL_AMOUNT
3342: , p_line_amount_tbl => p_lines.AMOUNT

Line 3347: PO_VAL_LINES.max_tot_amt_ge_min_tot_amt

3343: , x_results => x_results
3344: , x_result_type => l_result_type
3345: );
3346: WHEN c_max_tot_amt_ge_min_tot_amt THEN
3347: PO_VAL_LINES.max_tot_amt_ge_min_tot_amt
3348: (
3349: p_line_id_tbl => p_lines.po_line_id
3350: , p_max_total_amt_tbl => p_lines.CLM_MAX_TOTAL_AMOUNT
3351: , p_min_total_amt_tbl => p_lines.CLM_MIN_TOTAL_AMOUNT

Line 3356: PO_VAL_LINES.max_tot_qty_le_line_tot_qty

3352: , x_results => x_results
3353: , x_result_type => l_result_type
3354: );
3355: WHEN c_max_tot_qty_le_line_tot_qty THEN
3356: PO_VAL_LINES.max_tot_qty_le_line_tot_qty
3357: (
3358: p_line_id_tbl => p_lines.po_line_id
3359: , p_max_total_qty_tbl => p_lines.CLM_MAX_TOTAL_QUANTITY
3360: , p_line_qty_tbl => p_lines.QUANTITY_COMMITTED

Line 3365: PO_VAL_LINES.max_tot_qty_ge_min_tot_qty

3361: , x_results => x_results
3362: , x_result_type => l_result_type
3363: );
3364: WHEN c_max_tot_qty_ge_min_tot_qty THEN
3365: PO_VAL_LINES.max_tot_qty_ge_min_tot_qty
3366: (
3367: p_line_id_tbl => p_lines.po_line_id
3368: , p_max_total_qty_tbl => p_lines.CLM_MAX_TOTAL_QUANTITY
3369: , p_min_total_qty_tbl => p_lines.CLM_MIN_TOTAL_QUANTITY

Line 3374: PO_VAL_LINES.max_ord_amt_le_max_tot_amt

3370: , x_results => x_results
3371: , x_result_type => l_result_type
3372: );
3373: WHEN c_max_ord_amt_le_max_tot_amt THEN
3374: PO_VAL_LINES.max_ord_amt_le_max_tot_amt
3375: (
3376: p_line_id_tbl => p_lines.po_line_id
3377: , p_max_order_amt_tbl => p_lines.CLM_MAX_ORDER_AMOUNT
3378: , p_max_tot_amount_tbl => p_lines.CLM_MAX_TOTAL_AMOUNT

Line 3383: PO_VAL_LINES.max_ord_amt_ge_min_ord_amt

3379: , x_results => x_results
3380: , x_result_type => l_result_type
3381: );
3382: WHEN c_max_ord_amt_ge_min_ord_amt THEN
3383: PO_VAL_LINES.max_ord_amt_ge_min_ord_amt
3384: (
3385: p_line_id_tbl => p_lines.po_line_id
3386: , p_max_ord_amt_tbl => p_lines.CLM_MAX_ORDER_AMOUNT
3387: , p_min_ord_amt_tbl => p_lines.CLM_MIN_ORDER_AMOUNT

Line 3392: PO_VAL_LINES.max_ord_qty_le_max_tot_qty

3388: , x_results => x_results
3389: , x_result_type => l_result_type
3390: );
3391: WHEN c_max_ord_qty_le_max_tot_qty THEN
3392: PO_VAL_LINES.max_ord_qty_le_max_tot_qty
3393: (
3394: p_line_id_tbl => p_lines.po_line_id
3395: , p_max_order_qty_tbl => p_lines.CLM_MAX_ORDER_QUANTITY
3396: , p_max_tot_qty_tbl => p_lines.CLM_MAX_TOTAL_QUANTITY

Line 3401: PO_VAL_LINES.max_ord_qty_ge_min_ord_qty

3397: , x_results => x_results
3398: , x_result_type => l_result_type
3399: );
3400: WHEN c_max_ord_qty_ge_min_ord_qty THEN
3401: PO_VAL_LINES.max_ord_qty_ge_min_ord_qty
3402: (
3403: p_line_id_tbl => p_lines.po_line_id
3404: , p_max_ord_qty_tbl => p_lines.CLM_MAX_ORDER_QUANTITY
3405: , p_min_ord_qty_tbl => p_lines.CLM_MIN_ORDER_QUANTITY

Line 3410: PO_VAL_LINES.clin_slin_num_check(

3406: , x_results => x_results
3407: , x_result_type => l_result_type
3408: );
3409: WHEN c_clin_slin_num_check THEN --
3410: PO_VAL_LINES.clin_slin_num_check(
3411: p_header_id_tbl => p_lines.po_header_id,
3412: p_draft_id_tbl => p_lines.draft_id,
3413: p_line_id_tbl => p_lines.po_line_id,
3414: p_group_line_id_tbl => p_lines.group_line_id,

Line 3422: PO_VAL_LINES.validate_comments_not_null(

3418: x_result_type => l_result_type
3419: );
3420:
3421: WHEN c_par_line_comments_not_null THEN --
3422: PO_VAL_LINES.validate_comments_not_null(
3423: p_line_id_tbl => p_lines.po_line_id
3424: , p_draft_id_tbl => p_lines.draft_id
3425: , p_draft_type_tbl => p_lines.draft_type
3426: , p_comments_tbl => p_lines.comments

Line 3433: PO_VAL_LINES.clin_slin_structure(

3429: );
3430: --PDOI CLM Integration : Validation for proper clin structure
3431: --Priced slin not allowed under a priced clin
3432: WHEN c_pdoi_clin_slin_structure THEN
3433: PO_VAL_LINES.clin_slin_structure(
3434: p_line_id_tbl => p_lines.po_line_id,
3435: --p_draft_id_tbl => p_lines.draft_id,
3436: p_intf_line_id_tbl => p_lines.interface_id,
3437: p_group_line_id_tbl => p_lines.group_line_id,

Line 3442: PO_VAL_LINES.validate_contract_type(

3438: x_results => x_results,
3439: x_result_type => l_result_type
3440: );
3441: WHEN c_validate_contract_type THEN
3442: PO_VAL_LINES.validate_contract_type(
3443: p_intf_line_id_tbl => p_lines.interface_id
3444: , p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code
3445: , p_contract_type_tbl => p_lines.contract_type
3446: , x_results => x_results

Line 3451: PO_VAL_LINES.validate_cost_constraint(

3447: , x_result_type => l_result_type
3448: );
3449:
3450: WHEN c_validate_cost_constraint THEN
3451: PO_VAL_LINES.validate_cost_constraint(
3452: p_intf_line_id_tbl => p_lines.interface_id
3453: , p_cost_constraint_tbl => p_lines.cost_constraint
3454: , x_results => x_results
3455: , x_result_type => l_result_type

Line 3458: PO_VAL_LINES.check_contract_num_and_ver(

3454: , x_results => x_results
3455: , x_result_type => l_result_type
3456: );
3457: WHEN c_check_contract_num_and_ver THEN
3458: PO_VAL_LINES.check_contract_num_and_ver(
3459: p_intf_line_id_tbl => p_lines.interface_id
3460: , p_oke_contract_header_id_tbl => p_lines.oke_contract_header_id
3461: , p_oke_contract_header_num_tbl => p_lines.oke_contract_header_num
3462: , p_oke_contract_version_id_tbl => p_lines.oke_contract_version_id

Line 3467: PO_VAL_LINES.validate_option_indicator(

3463: , x_results => x_results
3464: , x_result_type => l_result_type
3465: );
3466: WHEN c_validate_option_indicator THEN
3467: PO_VAL_LINES.validate_option_indicator(
3468: p_intf_line_id_tbl => p_lines.interface_id
3469: , p_clm_option_indicator_tbl => p_lines.clm_option_indicator
3470: , x_results => x_results
3471: , x_result_type => l_result_type

Line 3474: PO_VAL_LINES.validate_clm_base_line_num(

3470: , x_results => x_results
3471: , x_result_type => l_result_type
3472: );
3473: WHEN c_validate_clm_base_line_num THEN
3474: PO_VAL_LINES.validate_clm_base_line_num(
3475: p_intf_line_id_tbl => p_lines.interface_id
3476: , p_clm_option_indicator_tbl => p_lines.clm_option_indicator
3477: , p_clm_base_line_num_tbl => p_lines.clm_base_line_num
3478: , x_results => x_results

Line 3482: PO_VAL_LINES.validate_clm_option_num(

3478: , x_results => x_results
3479: , x_result_type => l_result_type
3480: );
3481: WHEN c_validate_clm_option_num THEN
3482: PO_VAL_LINES.validate_clm_option_num(
3483: p_intf_line_id_tbl => p_lines.interface_id
3484: , p_clm_option_indicator_tbl => p_lines.clm_option_indicator
3485: , p_clm_base_line_num_tbl => p_lines.clm_base_line_num
3486: , p_clm_option_num_tbl => p_lines.clm_option_num

Line 3491: PO_VAL_LINES.validate_clm_idc_type(

3487: , x_results => x_results
3488: , x_result_type => l_result_type
3489: );
3490: WHEN c_validate_clm_idc_type THEN
3491: PO_VAL_LINES.validate_clm_idc_type(
3492: p_intf_line_id_tbl => p_lines.interface_id
3493: , p_clm_idc_type_tbl => p_lines.clm_idc_type
3494: , x_results => x_results
3495: , x_result_type => l_result_type

Line 3498: PO_VAL_LINES.validate_clin_line_num_disp(

3494: , x_results => x_results
3495: , x_result_type => l_result_type
3496: );
3497: WHEN c_validate_clin_line_num_disp THEN
3498: PO_VAL_LINES.validate_clin_line_num_disp(
3499: p_intf_line_id_tbl => p_lines.interface_id
3500: , p_line_num_disp_tbl => p_lines.line_num_display
3501: , p_group_line_id_tbl => p_lines.group_line_id
3502: , p_intf_header_id_tbl => p_lines.interface_header_id

Line 3507: PO_VAL_LINES.idv_reference_equal_check(

3503: , x_results => x_results
3504: , x_result_type => l_result_type
3505: );
3506: WHEN c_idv_reference_equal_check THEN
3507: PO_VAL_LINES.idv_reference_equal_check(
3508: p_intf_line_id_tbl => p_lines.interface_id
3509: , p_from_header_id_tbl => p_lines.from_header_id
3510: , x_results => x_results
3511: , x_result_type => l_result_type

Line 3514: PO_VAL_LINES.validate_clm_line_type_id(

3510: , x_results => x_results
3511: , x_result_type => l_result_type
3512: );
3513: WHEN c_validate_clm_line_type_id THEN
3514: PO_VAL_LINES.validate_clm_line_type_id(
3515: p_intf_line_id_tbl => p_lines.interface_id
3516: , p_line_type_id_tbl => p_lines.line_type_id
3517: , x_results => x_results
3518: , x_result_type => l_result_type

Line 3532: PO_VAL_LINES2.over_tolerance_err_flag(p_id_tbl => p_lines.interface_id,

3528: WHEN c_over_tolerance_error_flag THEN
3529: -- The lookup code specified in over_tolerance_error_flag with the lookup type
3530: -- 'RECEIVING CONTROL LEVEL' has to exist in po_lookup_codes and still active.
3531: -- This method is called only for Standard PO and quotation documents
3532: PO_VAL_LINES2.over_tolerance_err_flag(p_id_tbl => p_lines.interface_id,
3533: p_over_tolerance_err_flag_tbl => p_lines.over_tolerance_error_flag,
3534: x_result_set_id => l_result_set_id,
3535: x_result_type => l_result_type);
3536: WHEN c_expiration_date_blanket THEN

Line 3538: PO_VAL_LINES2.expiration_date_blanket(p_id_tbl => p_lines.interface_id,

3534: x_result_set_id => l_result_set_id,
3535: x_result_type => l_result_type);
3536: WHEN c_expiration_date_blanket THEN
3537: -- Expiration date on the line cannot be earlier than the header effective start date and cannot be later than header effective end date
3538: PO_VAL_LINES2.expiration_date_blanket(p_id_tbl => p_lines.interface_id,
3539: p_expiration_date_tbl => p_lines.expiration_date,
3540: p_header_start_date_tbl => p_lines.hdr_start_date,
3541: p_header_end_date_tbl => p_lines.hdr_end_date,
3542: x_results => x_results,

Line 3547: PO_VAL_LINES2.global_agreement_flag(p_id_tbl => p_lines.interface_id,

3543: x_result_type => l_result_type);
3544: WHEN c_global_agreement_flag THEN
3545: -- For blanket document with purchase type 'TEMP LABOR', the global agreement
3546: -- flag has to be 'Y'. Global_agreement_flag and outside operation flag cannot both be 'Y'
3547: PO_VAL_LINES2.global_agreement_flag(p_id_tbl => p_lines.interface_id,
3548: p_global_agreement_flag_tbl => p_lines.global_agreement_flag,
3549: p_purchase_basis_tbl => p_lines.purchase_basis,
3550: p_line_type_id_tbl => p_lines.line_type_id,
3551: x_result_set_id => l_result_set_id,

Line 3556: PO_VAL_LINES2.amount_blanket(p_id_tbl => p_lines.interface_id,

3552: x_results => x_results,
3553: x_result_type => l_result_type);
3554: WHEN c_amount_blanket THEN
3555: -- If order_type_lookup_code is 'RATE', amount has to be null
3556: PO_VAL_LINES2.amount_blanket(p_id_tbl => p_lines.interface_id,
3557: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3558: p_amount_tbl => p_lines.amount,
3559: x_results => x_results,
3560: x_result_type => l_result_type);

Line 3564: PO_VAL_LINES2.order_type_lookup_code(p_id_tbl => p_lines.interface_id,

3560: x_result_type => l_result_type);
3561: WHEN c_order_type_lookup_code THEN
3562: -- If services procurement is not enabled, the order_type_lookup_code cannot
3563: -- be 'FIXED PRICE' or 'RATE'.
3564: PO_VAL_LINES2.order_type_lookup_code(p_id_tbl => p_lines.interface_id,
3565: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3566: x_results => x_results,
3567: x_result_type => l_result_type);
3568: WHEN c_contractor_name THEN

Line 3571: PO_VAL_LINES2.contractor_name(p_id_tbl => p_lines.interface_id,

3567: x_result_type => l_result_type);
3568: WHEN c_contractor_name THEN
3569: -- If purchase basis is not 'TEMP LABOR' or document type is not STANDARD,
3570: -- contractor first name and last name fields should be empty
3571: PO_VAL_LINES2.contractor_name(p_id_tbl => p_lines.interface_id,
3572: p_doc_type => l_doc_type,
3573: p_purchase_basis_tbl => p_lines.purchase_basis,
3574: p_contractor_last_name_tbl => p_lines.contractor_last_name,
3575: p_contractor_first_name_tbl => p_lines.contractor_first_name,

Line 3580: PO_VAL_LINES2.job_id(p_id_tbl => p_lines.interface_id,

3576: x_results => x_results,
3577: x_result_type => l_result_type);
3578: WHEN c_job_id THEN
3579: -- If purchase basis is TEMP LABOR, then job id must be null
3580: PO_VAL_LINES2.job_id(p_id_tbl => p_lines.interface_id,
3581: p_job_id_tbl => p_lines.job_id,
3582: p_job_business_group_id_tbl => p_lines.job_business_group_id,
3583: p_purchase_basis_tbl => p_lines.purchase_basis,
3584: p_category_id_tbl => p_lines.category_id,

Line 3591: PO_VAL_LINES2.job_business_group_id(p_id_tbl => p_lines.interface_id,

3587: x_result_type => l_result_type);
3588: WHEN c_job_business_group_id THEN
3589: -- If services procurement not enabled, order_type_lookup_code cannot be
3590: -- 'FIXED PRICE' or 'RATE'
3591: PO_VAL_LINES2.job_business_group_id(p_id_tbl => p_lines.interface_id,
3592: p_job_id_tbl => p_lines.job_id,
3593: p_job_business_group_id_tbl => p_lines.job_business_group_id,
3594: p_purchase_basis_tbl => p_lines.purchase_basis,
3595: x_result_set_id => l_result_set_id,

Line 3599: PO_VAL_LINES2.capital_expense_flag(p_id_tbl => p_lines.interface_id,

3595: x_result_set_id => l_result_set_id,
3596: x_result_type => l_result_type);
3597: WHEN c_capital_expense_flag THEN
3598: -- If purchase_basis = 'TEMP LABOR', then capital_expense_flag cannot = 'Y'
3599: PO_VAL_LINES2.capital_expense_flag(p_id_tbl => p_lines.interface_id,
3600: p_purchase_basis_tbl => p_lines.purchase_basis,
3601: p_capital_expense_flag_tbl => p_lines.capital_expense_flag,
3602: x_results => x_results,
3603: x_result_type => l_result_type);

Line 3606: PO_VAL_LINES2.un_number_id(p_id_tbl => p_lines.interface_id,

3602: x_results => x_results,
3603: x_result_type => l_result_type);
3604: WHEN c_un_number_id THEN
3605: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
3606: PO_VAL_LINES2.un_number_id(p_id_tbl => p_lines.interface_id,
3607: p_purchase_basis_tbl => p_lines.purchase_basis,
3608: p_un_number_id_tbl => p_lines.un_number_id,
3609: x_result_set_id => l_result_set_id,
3610: x_results => x_results,

Line 3614: PO_VAL_LINES2.hazard_class_id(p_id_tbl => p_lines.interface_id,

3610: x_results => x_results,
3611: x_result_type => l_result_type);
3612: WHEN c_hazard_class_id THEN
3613: -- If purchase_basis = 'TEMP LABOR', then un_number must be null
3614: PO_VAL_LINES2.hazard_class_id(p_id_tbl => p_lines.interface_id,
3615: p_purchase_basis_tbl => p_lines.purchase_basis,
3616: p_hazard_class_id_tbl => p_lines.hazard_class_id,
3617: x_result_set_id => l_result_set_id,
3618: x_results => x_results,

Line 3622: PO_VAL_LINES2.item_id(p_id_tbl => p_lines.interface_id,

3618: x_results => x_results,
3619: x_result_type => l_result_type);
3620: WHEN c_item_id THEN
3621: -- If order_type_lookup_code is 'FIXED PRICE', 'RATE', or 'AMOUNT', item_id has to be null
3622: PO_VAL_LINES2.item_id(p_id_tbl => p_lines.interface_id,
3623: p_item_id_tbl => p_lines.item_id,
3624: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3625: p_line_type_id_tbl => p_lines.line_type_id,
3626: p_inventory_org_id => l_inventory_org_id,

Line 3634: PO_VAL_LINES2.item_description(p_id_tbl => p_lines.interface_id,

3630: WHEN c_item_description THEN
3631: -- Make sure that the item_description is populated, and also need to find out if it is different from
3632: -- what is setup for the item. Would not allow item_description update if item attribute
3633: -- allow_item_desc_update_flag is N.
3634: PO_VAL_LINES2.item_description(p_id_tbl => p_lines.interface_id,
3635: p_item_description_tbl => p_lines.item_description,
3636: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3637: p_item_id_tbl => p_lines.item_id,
3638: p_create_or_update_item => l_create_or_update_item,

Line 3644: PO_VAL_LINES2.unit_meas_lookup_code(p_id_tbl => p_lines.interface_id,

3640: x_result_set_id => l_result_set_id,
3641: x_result_type => l_result_type);
3642: WHEN c_unit_meas_lookup_code THEN
3643: -- check to see if x_item_unit_of_measure is valid
3644: PO_VAL_LINES2.unit_meas_lookup_code(p_id_tbl => p_lines.interface_id,
3645: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
3646: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3647: p_item_id_tbl => p_lines.item_id,
3648: p_line_type_id_tbl => p_lines.line_type_id,

Line 3656: PO_VAL_LINES2.item_revision(p_id_tbl => p_lines.interface_id,

3652: x_result_type => l_result_type);
3653: WHEN c_item_revision THEN
3654: -- if order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
3655: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
3656: PO_VAL_LINES2.item_revision(p_id_tbl => p_lines.interface_id,
3657: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3658: p_item_revision_tbl => p_lines.item_revision,
3659: p_item_id_tbl => p_lines.item_id,
3660: x_result_set_id => l_result_set_id,

Line 3668: PO_VAL_LINES2.category_id(p_id_tbl => p_lines.interface_id,

3664: -- Validate and make sure category_id is a valid category within the default category set for Purchasing.
3665: -- Validate if X_category_id belong to the X_item. Check if the Purchasing Category set has
3666: -- 'Validate flag' ON. If Yes, we will validate the Category to exist in the 'Valid Category List'.
3667: -- If No, we will just validate if the category is Enable and Active.
3668: PO_VAL_LINES2.category_id(p_id_tbl => p_lines.interface_id,
3669: p_category_id_tbl => p_lines.category_id,
3670: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3671: p_item_id_tbl => p_lines.item_id,
3672: p_inventory_org_id => l_inventory_org_id,

Line 3679: PO_VAL_LINES2.ip_category_id(p_id_tbl => p_lines.interface_id,

3675: x_result_type => l_result_type);
3676: WHEN c_ip_category_id THEN
3677: -- Validate ip_category_id is not empty
3678: -- Validate ip_category_id is valid if not empty.
3679: PO_VAL_LINES2.ip_category_id(p_id_tbl => p_lines.interface_id,
3680: p_ip_category_id_tbl => p_lines.ip_category_id,
3681: x_result_set_id => l_result_set_id,
3682: x_results => x_results,
3683: x_result_type => l_result_type);

Line 3688: PO_VAL_LINES2.unit_price(p_id_tbl => p_lines.interface_id,

3684: WHEN c_unit_price THEN
3685: --If order_type_lookup_code is not 'FIXED PRICE', unit_price cannot be null and cannot be less than zero.
3686: --If line_type_id is not null and order_type_lookup_code is 'AMOUNT', unit_price should be the same as the one defined in the line_type.
3687: --If order_type_lookup_code is 'FIXED PRICE', unit_price has to be null.
3688: PO_VAL_LINES2.unit_price(p_id_tbl => p_lines.interface_id,
3689: p_unit_price_tbl => p_lines.unit_price,
3690: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3691: p_line_type_id_tbl => p_lines.line_type_id,
3692: x_result_set_id => l_result_set_id,

Line 3698: PO_VAL_LINES2.quantity(p_id_tbl => p_lines.interface_id,

3694: x_result_type => l_result_type);
3695: WHEN c_quantity THEN
3696: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', quantity cannot be less than zero
3697: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', quantity has to be null.
3698: PO_VAL_LINES2.quantity(p_id_tbl => p_lines.interface_id,
3699: p_quantity_tbl => p_lines.quantity,
3700: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3701: x_results => x_results,
3702: x_result_type => l_result_type);

Line 3705: PO_VAL_LINES2.amount(p_id_tbl => p_lines.interface_id,

3701: x_results => x_results,
3702: x_result_type => l_result_type);
3703: WHEN c_amount THEN
3704: -- If order_type_lookup_code is not 'FIXED PRICE' or 'RATE', amount has to be null
3705: PO_VAL_LINES2.amount(p_id_tbl => p_lines.interface_id,
3706: p_amount_tbl => p_lines.amount,
3707: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3708: x_results => x_results,
3709: x_result_type => l_result_type);

Line 3712: PO_VAL_LINES2.rate_type(p_id_tbl => p_lines.interface_id,

3708: x_results => x_results,
3709: x_result_type => l_result_type);
3710: WHEN c_rate_type THEN
3711: -- For rate based temp labor line, the currency rate_type cannot be 'user'
3712: PO_VAL_LINES2.rate_type(p_id_tbl => p_lines.interface_id,
3713: p_rate_type_tbl => p_lines.hdr_rate_type,
3714: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3715: x_results => x_results,
3716: x_result_type => l_result_type);

Line 3720: PO_VAL_LINES2.line_num(p_id_tbl => p_lines.interface_id,

3716: x_result_type => l_result_type);
3717: WHEN c_line_num THEN
3718: -- Line num must be populated and cannot be <= 0.
3719: -- Line num has to be unique in a requisition.
3720: PO_VAL_LINES2.line_num(p_id_tbl => p_lines.interface_id,
3721: p_po_header_id_tbl => p_lines.po_header_id,
3722: p_line_num_tbl => p_lines.line_num,
3723: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3724: p_draft_id_tbl => p_lines.draft_id, -- bug5129752

Line 3730: PO_VAL_LINES2.po_line_id(p_id_tbl => p_lines.interface_id,

3726: x_results => x_results,
3727: x_result_type => l_result_type);
3728: WHEN c_po_line_id THEN
3729: -- Po_line_id must be populated and unique.
3730: PO_VAL_LINES2.po_line_id(p_id_tbl => p_lines.interface_id,
3731: p_po_line_id_tbl => p_lines.po_line_id,
3732: p_po_header_id_tbl => p_lines.po_header_id,
3733: x_result_set_id => l_result_set_id,
3734: x_result_type => l_result_type);

Line 3737: PO_VAL_LINES2.line_type_id(p_id_tbl => p_lines.interface_id,

3733: x_result_set_id => l_result_set_id,
3734: x_result_type => l_result_type);
3735: WHEN c_line_type_id THEN
3736: -- Line type id must be populated and exist in po_line_types_val_v
3737: PO_VAL_LINES2.line_type_id(p_id_tbl => p_lines.interface_id,
3738: p_line_type_id_tbl => p_lines.line_type_id,
3739: x_result_set_id => l_result_set_id,
3740: x_result_type => l_result_type);
3741: WHEN c_line_style_related_info THEN

Line 3742: PO_VAL_LINES2.style_related_info(p_id_tbl => p_lines.interface_id,

3738: p_line_type_id_tbl => p_lines.line_type_id,
3739: x_result_set_id => l_result_set_id,
3740: x_result_type => l_result_type);
3741: WHEN c_line_style_related_info THEN
3742: PO_VAL_LINES2.style_related_info(p_id_tbl => p_lines.interface_id,
3743: p_style_id_tbl => p_lines.hdr_style_id,
3744: p_line_type_id_tbl => p_lines.line_type_id,
3745: p_purchase_basis_tbl => p_lines.purchase_basis,
3746: x_result_set_id => l_result_set_id,

Line 3750: PO_VAL_LINES2.price_type_lookup_code(p_id_tbl => p_lines.interface_id,

3746: x_result_set_id => l_result_set_id,
3747: x_result_type => l_result_type);
3748: WHEN c_price_type_lookup_code THEN
3749: -- If price_type_lookup_code is not null, it has to be a valid price type in po_lookup_codes
3750: PO_VAL_LINES2.price_type_lookup_code(p_id_tbl => p_lines.interface_id,
3751: p_price_type_lookup_code_tbl => p_lines.price_type_lookup_code,
3752: x_result_set_id => l_result_set_id,
3753: x_result_type => l_result_type);
3754: WHEN c_start_date_standard THEN

Line 3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,

3754: WHEN c_start_date_standard THEN
3755: -- Start date is required for Standard PO with purchase basis 'TEMP LABOR'
3756: -- Expiration date if provided should be later than the start date
3757: -- If purchase basis is not 'TEMP LABOR', start_date and expiration_date have to be null
3758: PO_VAL_LINES2.start_date_standard(p_id_tbl => p_lines.interface_id,
3759: p_start_date_tbl => p_lines.start_date,
3760: p_expiration_date_tbl => p_lines.expiration_date,
3761: p_purchase_basis_tbl => p_lines.purchase_basis,
3762: x_results => x_results,

Line 3766: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,

3762: x_results => x_results,
3763: x_result_type => l_result_type);
3764: WHEN c_item_id_standard THEN
3765: -- If order_type_lookup_code is not 'RATE' or 'FIXED PRICE', and item_id is not null, then bom_item_type cannot be 1 or 2.
3766: PO_VAL_LINES2.item_id_standard(p_id_tbl => p_lines.interface_id,
3767: p_item_id_tbl => p_lines.item_id,
3768: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3769: p_inventory_org_id => l_inventory_org_id,
3770: x_result_set_id => l_result_set_id,

Line 3775: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,

3771: x_result_type => l_result_type);
3772: WHEN c_quantity_standard THEN
3773: -- Quantity cannot be zero for SPO
3774: -- And qiantity cannot be empty for SPO if order type is QUANTITY/AMOUNT
3775: PO_VAL_LINES2.quantity_standard(p_id_tbl => p_lines.interface_id,
3776: p_quantity_tbl => p_lines.quantity,
3777: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3778: x_results => x_results,
3779: x_result_type => l_result_type);

Line 3782: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,

3778: x_results => x_results,
3779: x_result_type => l_result_type);
3780: WHEN c_amount_standard THEN
3781: -- If order_type_lookup_code is 'FIXED PRICE' or 'RATE', amount cannot be null
3782: PO_VAL_LINES2.amount_standard(p_id_tbl => p_lines.interface_id,
3783: p_amount_tbl => p_lines.amount,
3784: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3785: x_results => x_results,
3786: x_result_type => l_result_type);

Line 3789: PO_VAL_LINES2.price_break_lookup_code(p_id_tbl => p_lines.interface_id,

3785: x_results => x_results,
3786: x_result_type => l_result_type);
3787: WHEN c_price_break_lookup_code THEN
3788: -- bug5016163
3789: PO_VAL_LINES2.price_break_lookup_code(p_id_tbl => p_lines.interface_id,
3790: p_price_break_lookup_code_tbl => p_lines.price_break_lookup_code,
3791: p_global_agreement_flag_tbl => p_lines.global_agreement_flag,
3792: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3793: p_purchase_basis_tbl => p_lines.purchase_basis,

Line 3800: PO_VAL_LINES2.not_to_exceed_price(p_id_tbl => p_lines.interface_id,

3796: x_result_type => l_result_type);
3797: WHEN c_not_to_exceed_price THEN
3798: -- If allow_price_override_flag is 'N', then not_to_exceed_price has to be null.
3799: -- If not_to_exceed_price is not null, then it cannot be less than unit_price.
3800: PO_VAL_LINES2.not_to_exceed_price(p_id_tbl => p_lines.interface_id,
3801: p_not_to_exceed_price_tbl => p_lines.not_to_exceed_price,
3802: p_allow_price_override_tbl => p_lines.allow_price_override_flag,
3803: p_unit_price_tbl => p_lines.unit_price,
3804: x_results => x_results,

Line 3809: PO_VAL_LINES2.uom_update(p_id_tbl => p_lines.interface_id,

3805: x_result_type => l_result_type);
3806: WHEN c_uom_update THEN
3807: -- validate unit_meas_lookup_code against po_lines_all and po_units_of_measure_val_v
3808: -- for the Update case
3809: PO_VAL_LINES2.uom_update(p_id_tbl => p_lines.interface_id,
3810: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
3811: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3812: p_po_header_id_tbl => p_lines.po_header_id,
3813: p_po_line_id_tbl => p_lines.po_line_id,

Line 3819: PO_VAL_LINES2.unit_price_update

3815: x_result_set_id => l_result_set_id,
3816: x_result_type => l_result_type);
3817: WHEN c_unit_price_update THEN
3818: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3819: PO_VAL_LINES2.unit_price_update
3820: ( p_id_tbl => p_lines.interface_id,
3821: p_po_line_id_tbl => p_lines.po_line_id, -- bug5008206
3822: p_draft_id_tbl => p_lines.draft_id, -- bug5258790
3823: p_unit_price_tbl => p_lines.unit_price,

Line 3831: PO_VAL_LINES2.amount_update

3827: );
3828:
3829: WHEN c_amount_update THEN
3830: -- In the UPDATE case, unit_price cannot be negative. Also handle #DEL.
3831: PO_VAL_LINES2.amount_update
3832: ( p_id_tbl => p_lines.interface_id,
3833: p_po_line_id_tbl => p_lines.po_line_id, -- bug5008206
3834: p_draft_id_tbl => p_lines.draft_id, -- bug5258790
3835: p_amount_tbl => p_lines.amount,

Line 3842: PO_VAL_LINES2.item_desc_update(p_id_tbl => p_lines.interface_id,

3838: x_result_type => l_result_type
3839: );
3840:
3841: WHEN c_item_desc_update THEN
3842: PO_VAL_LINES2.item_desc_update(p_id_tbl => p_lines.interface_id,
3843: p_item_description_tbl => p_lines.item_description,
3844: p_item_id_tbl => p_lines.item_id,
3845: p_inventory_org_id => l_inventory_org_id,
3846: p_po_header_id_tbl => p_lines.po_header_id,

Line 3853: PO_VAL_LINES2.ip_category_id_update(p_id_tbl => p_lines.interface_id,

3849: x_result_set_id => l_result_set_id,
3850: x_result_type => l_result_type);
3851: WHEN c_ip_category_id_update THEN
3852: -- Validate ip_category_id is valid if not empty.
3853: PO_VAL_LINES2.ip_category_id_update(p_id_tbl => p_lines.interface_id,
3854: p_ip_category_id_tbl => p_lines.ip_category_id,
3855: x_result_set_id => l_result_set_id,
3856: x_results => x_results,
3857: x_result_type => l_result_type);

Line 3862: PO_VAL_LINES2.negotiated_by_preparer(p_id_tbl => p_lines.interface_id,

3858: WHEN c_negotiated_by_preparer THEN
3859: ----------------------------------------------------------------------------------------
3860: -- Called in create case for Blanket AND SPO, negotiated_by_preparer must be 'Y' or 'N'.
3861: ----------------------------------------------------------------------------------------
3862: PO_VAL_LINES2.negotiated_by_preparer(p_id_tbl => p_lines.interface_id,
3863: p_negotiated_by_preparer_tbl => p_lines.negotiated_by_preparer_flag,
3864: x_results => x_results,
3865: x_result_type => l_result_type);
3866: WHEN c_negotiated_by_prep_update THEN

Line 3870: PO_VAL_LINES2.negotiated_by_prep_update(p_id_tbl => p_lines.interface_id,

3866: WHEN c_negotiated_by_prep_update THEN
3867: --------------------------------------------------------------------------------------
3868: -- Called in update case for Blanket, negotiated_by_preparer must be NULL, 'Y' or 'N'.
3869: --------------------------------------------------------------------------------------
3870: PO_VAL_LINES2.negotiated_by_prep_update(p_id_tbl => p_lines.interface_id,
3871: p_negotiated_by_preparer_tbl => p_lines.negotiated_by_preparer_flag,
3872: x_results => x_results,
3873: x_result_type => l_result_type);
3874: WHEN c_category_id_update THEN

Line 3879: PO_VAL_LINES2.category_id_update(p_id_tbl => p_lines.interface_id,

3875: -------------------------------------------------------------------------
3876: -- If either item_id or job_id are populated, then you are not allowed to change the po_category_id
3877: -- If change is allowed, the new category_id must be valid.
3878: -------------------------------------------------------------------------
3879: PO_VAL_LINES2.category_id_update(p_id_tbl => p_lines.interface_id,
3880: p_category_id_tbl => p_lines.category_id,
3881: p_po_line_id_tbl => p_lines.po_line_id,
3882: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,
3883: p_item_id_tbl => p_lines.item_id,

Line 4176: PO_VAL_LINES.qty_ge_qty_milestone_exec(

4172: x_results => x_results,
4173: x_result_type => l_result_type);
4174: --
4175: WHEN c_pdoi_qty_ge_qty_mstone_exec THEN
4176: PO_VAL_LINES.qty_ge_qty_milestone_exec(
4177: p_line_id_tbl => p_lines.interface_id
4178: , p_quantity_tbl => p_lines.quantity
4179: , x_result_set_id => l_result_set_id
4180: , x_result_type => l_result_type

Line 4183: PO_VAL_LINES.price_ge_price_milestone_exec(

4179: , x_result_set_id => l_result_set_id
4180: , x_result_type => l_result_type
4181: );
4182: WHEN c_pdoi_prc_ge_prc_mstone_exec THEN
4183: PO_VAL_LINES.price_ge_price_milestone_exec(
4184: p_line_id_tbl => p_lines.interface_id
4185: , p_price_tbl => p_lines.unit_price
4186: , x_result_set_id => l_result_set_id
4187: , x_result_type => l_result_type

Line 4190: PO_VAL_LINES.recoupment_rate_range_check(

4186: , x_result_set_id => l_result_set_id
4187: , x_result_type => l_result_type
4188: );
4189: WHEN c_pdoi_recoupment_range_check THEN
4190: PO_VAL_LINES.recoupment_rate_range_check(
4191: p_line_id_tbl => p_lines.interface_id
4192: , p_recoupment_rate_tbl => p_lines.recoupment_rate
4193: , x_results => x_results
4194: , x_result_type => l_result_type

Line 4197: PO_VAL_LINES.retainage_rate_range_check(

4193: , x_results => x_results
4194: , x_result_type => l_result_type
4195: );
4196: WHEN c_pdoi_retainage_range_check THEN
4197: PO_VAL_LINES.retainage_rate_range_check(
4198: p_line_id_tbl => p_lines.interface_id
4199: , p_retainage_rate_tbl => p_lines.retainage_rate
4200: , x_results => x_results
4201: , x_result_type => l_result_type

Line 4204: PO_VAL_LINES.prog_pay_rate_range_check(

4200: , x_results => x_results
4201: , x_result_type => l_result_type
4202: );
4203: WHEN c_pdoi_prog_pay_range_check THEN
4204: PO_VAL_LINES.prog_pay_rate_range_check(
4205: p_line_id_tbl => p_lines.interface_id
4206: , p_prog_pay_rate_tbl => p_lines.progress_payment_rate
4207: , x_results => x_results
4208: , x_result_type => l_result_type

Line 4211: PO_VAL_LINES.max_retain_amt_ge_zero (

4207: , x_results => x_results
4208: , x_result_type => l_result_type
4209: );
4210: WHEN c_pdoi_max_retain_amt_ge_zero THEN
4211: PO_VAL_LINES.max_retain_amt_ge_zero (
4212: p_line_id_tbl => p_lines.interface_id
4213: , p_max_retain_amt_tbl => p_lines.max_retainage_amount
4214: , x_results => x_results
4215: , x_result_type => l_result_type

Line 4218: PO_VAL_LINES.max_retain_amt_ge_retained (

4214: , x_results => x_results
4215: , x_result_type => l_result_type
4216: );
4217: WHEN c_pdoi_max_retain_amt_ge_retnd THEN
4218: PO_VAL_LINES.max_retain_amt_ge_retained (
4219: p_line_id_tbl => p_lines.interface_id
4220: , p_max_retain_amt_tbl => p_lines.max_retainage_amount
4221: , x_result_set_id => l_result_set_id
4222: , x_result_type => l_result_type

Line 4225: PO_VAL_LINES.advance_amt_le_amt(

4221: , x_result_set_id => l_result_set_id
4222: , x_result_type => l_result_type
4223: );
4224: WHEN c_pdoi_amt_ge_line_advance_amt THEN
4225: PO_VAL_LINES.advance_amt_le_amt(
4226: p_line_id_tbl => p_lines.interface_id
4227: , p_advance_tbl => p_lines.advance_amount
4228: , p_amount_tbl => p_lines.amount
4229: , p_quantity_tbl => p_lines.quantity

Line 4235: PO_VAL_LINES.complex_po_attributes_check(

4231: , x_results => x_results
4232: , x_result_type => l_result_type
4233: );
4234: WHEN c_pdoi_complex_po_att_check THEN
4235: PO_VAL_LINES.complex_po_attributes_check(
4236: p_line_id_tbl => p_lines.interface_id
4237: , p_style_id_tbl => p_lines.hdr_style_id
4238: , p_retainage_rate_tbl => p_lines.retainage_rate
4239: , p_max_retain_amt_tbl => p_lines.max_retainage_amount

Line 6023: PO_VAL_LINES.validate_undef_amt_le_line_amt(

6019: , x_results => x_results
6020: , x_result_type => l_result_type);
6021: WHEN c_undef_amt_le_line_amt THEN
6022: -- bug 16461105
6023: PO_VAL_LINES.validate_undef_amt_le_line_amt(
6024: p_po_line_id => p_lines.po_line_id ,
6025: p_order_type_lookup_code => p_lines.order_type_lookup_code,
6026: p_unit_price => p_lines.unit_price,
6027: p_quantity => p_lines.quantity,

Line 6044: PO_VAL_LINES.validate_exhibit_name(

6040: --UCA Project - CLMR4 Changes End
6041: -- CLM Phase 4 - Elins project
6042: WHEN c_validate_exhibit_name THEN
6043:
6044: PO_VAL_LINES.validate_exhibit_name(
6045: p_header_id_tbl => p_lines.po_header_id,
6046: p_draft_id_tbl => p_lines.draft_id,
6047: p_line_id_tbl => p_lines.po_line_id,
6048: p_exhibit_name_tbl => p_lines.clm_exhibit_name,