[Home] [Help]
384: ,'p_product_no or p_product_id');
385: RAISE fnd_api.g_exc_error;
386: END IF;
387: --All error messages will be logged in this procedure itself..
388: gme_material_detail_pvt.validate_item_id(
389: p_org_id => l_batch_header.organization_id
390: ,p_item_id => l_item_id
391: ,x_item_rec => l_item_rec
392: ,x_return_status => l_return_status);
3386: END IF;
3387: END IF;
3388:
3389: --validate batch for insertion of material line
3390: gme_material_detail_pvt.validate_batch_for_matl_ins
3391: (p_batch_header_rec => l_batch_header_rec
3392: ,p_batch_step_rec => l_batch_step_rec
3393: ,x_return_status => x_return_status );
3394:
3422: gme_common_pvt.g_flex_validate_prof := 0;
3423: END IF;
3424:
3425: --validate individual fields
3426: gme_material_detail_pvt.validate_material_for_ins (
3427: p_batch_header_rec => l_batch_header_rec
3428: ,p_material_detail_rec => l_material_detail_rec
3429: ,p_batch_step_rec => l_batch_step_rec
3430: ,x_material_detail_rec => x_material_detail_rec
3631: END IF;
3632:
3633:
3634: --validate batch for update of material line
3635: gme_material_detail_pvt.validate_batch_for_matl_ins
3636: (p_batch_header_rec => l_batch_header_rec
3637: ,p_batch_step_rec => l_batch_step_rec
3638: ,x_return_status => l_return_status );
3639:
3667: gme_common_pvt.g_flex_validate_prof := 0;
3668: END IF;
3669:
3670: --validate and pop material line
3671: gme_material_detail_pvt.val_and_pop_material_for_upd
3672: ( p_batch_header_rec => l_batch_header_rec
3673: ,p_material_detail_rec => l_material_detail_rec
3674: ,p_stored_material_detail_rec => l_stored_material_detail_rec
3675: ,p_batch_step_rec => l_batch_step_rec
3850: CLOSE c_get_step_id;
3851: END IF;
3852:
3853: --calling validate material (includes batch status check)
3854: gme_material_detail_pvt.validate_material_for_del (
3855: p_batch_header_rec => l_batch_header_rec
3856: ,p_material_detail_rec => l_material_detail_rec
3857: ,p_batch_step_rec => l_batch_step_rec
3858: ,x_return_status => x_return_status);