[Home] [Help]
195: | Update Error Message that Models/Option Classes |
196: | cannot be released. |
197: +--------------------------------------------------- --*/
198:
199: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');
200:
201: update mrp_recommendations mr
202: set release_errors = l_mesg_str
203: where transaction_id IN
210: from mrp_system_items msi
211: where msi.compile_designator = mr.compile_designator
212: AND msi.bom_item_type in (1, 2, 3, 5));
213: --Bug3294041 Do not let user release Action=none records.
214: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ACTION_NONE');
215: update mrp_recommendations mr
216: set release_errors = l_mesg_str
217: where transaction_id IN
218: (SELECT number1 from mrp_form_query
240: /*-------------------------------------------------------+
241: | Add Error Message that Kanban Items Cannot be Released.|
242: +--------------------------------------------------------*/
243:
244: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');
245:
246: update mrp_recommendations mr
247: set release_errors = release_errors||l_mesg_str
248: where transaction_id IN
263: | Add Error Message that Items in Orgs modelled as Customer or |
264: | Supplier cannot be released. |
265: +---------------------------------------------------------------*/
266:
267: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_CUST_SUPP');
268:
269: update mrp_recommendations mr
270: set release_errors = release_errors||l_mesg_str
271: where transaction_id IN
279: | Add Error Message that Record was generated as part of some |
280: | other plan/schedule. |
281: +----------------------------------------------------------------*/
282:
283: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IN_SOURCE_PLAN');
284:
285: update mrp_recommendations mr
286: set release_errors = release_errors||l_mesg_str
287: where transaction_id IN
295: and msi.inventory_item_id = mr.inventory_item_id
296: and msi.organization_id = mr.organization_id
297: and msi.in_source_plan = 1);
298:
299: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_NO_FLOW_ROUTING');
300: -- bug 5462184: added check of source_vendor_id and organization_id in where clause
301: -- This will not allow release of recommendations whose source type is Make-At
302:
303: update mrp_recommendations mr
335: | Update Error Message that Models/Option Classes |
336: | cannot be released. |
337: +--------------------------------------------------- --*/
338:
339: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');
340:
341: update mrp_sugg_rep_schedules msrs
342: set release_errors = l_mesg_str
343: where rowid IN
356: | Add Error Message that Items in Orgs modelled as Customer or |
357: | Supplier cannot be released. |
358: +---------------------------------------------------------------*/
359:
360: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_CUST_SUPP');
361:
362: update mrp_sugg_rep_schedules msrs
363: set release_errors = release_errors||l_mesg_str
364: where rowid IN
373: | Add Error Message that Record was generated as part of some |
374: | other plan/schedule. |
375: +----------------------------------------------------------------*/
376:
377: l_mesg_str := FND_MESSAGE.GET_STRING('MRP',
378: 'MRP_REL_ALL_IN_SOURCE_PLAN');
379:
380: update mrp_sugg_rep_schedules msrs
381: set release_errors = release_errors||l_mesg_str
671: | add error message if implement_unit_number is null |
672: | for planned order which is unit number control |
673: ---------------------------------------------------------------*/
674:
675: l_mesg_str := fnd_message.get_string('MRP', 'MRP_REL_ALL_UNIT_NUMBER');
676: update mrp_recommendations mr
677: set release_errors = release_errors || l_mesg_str
678: where transaction_id in
679: (select number1 from mrp_form_query
713: | Set Error Messages and Update release status to no for records|
714: | which fail certain criteria. |
715: +---------------------------------------------------------------*/
716:
717: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_LOCATION');
718:
719: update mrp_recommendations mr
720: set release_errors = release_errors || l_mesg_str
721: where transaction_id IN
727: AND mr.implement_location_id is NULL;
728:
729: if(l_employee_id is NULL) then
730:
731: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_EMPLOYEE');
732:
733: update mrp_recommendations mr
734: set release_errors = release_errors || l_mesg_str,
735: implement_as = NULL,
789: | Update Error Message for Records with implement date equals |
790: | to NULL. |
791: +---------------------------------------------------------------*/
792:
793: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IMPL_DATE');
794:
795: update mrp_recommendations mr
796: set release_errors = release_errors || l_mesg_str
797: where transaction_id IN
806: | Update Project Control Level Specific Error Messages |
807: | |
808: +---------------------------------------------------------------*/
809:
810: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_NO_PROJECT');
811:
812: update mrp_recommendations mr
813: set release_errors = release_errors || l_mesg_str
814: where transaction_id IN
823: where mp.project_control_level = 1
824: and mp.project_reference_enabled = 1
825: and mp.organization_id = mr.organization_id);
826:
827: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_NO_TASK');
828:
829: update mrp_recommendations mr
830: set release_errors = release_errors || l_mesg_str
831: where transaction_id IN
1042: | to NULL. |
1043: +---------------------------------------------------------------*/
1044:
1045:
1046: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IMPL_DATE');
1047:
1048: update mrp_sugg_rep_schedules msrs
1049: set release_errors = release_errors || l_mesg_str,
1050: release_status = 2