DBA Data[Home] [Help]

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on FND_MESSAGE

Line 272: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');

268:
269: BEGIN
270: if p_bom_item_type in (1, 2, 3, 5) then
271: -- Models/Option Classes cannot be released
272: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');
273: end if;
274:
275: if p_order_type = 79 AND p_plan_type = 1 THEN
276: open validate_repair_module;

Line 281: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_RELEASE');

277: fetch validate_repair_module into l_repair_module;
278: close validate_repair_module;
279:
280: if l_repair_module is null then
281: p_rel_error := FND_MESSAGE.GET_STRING('MSC', 'MSC_RELEASE');
282: end if;
283: end if;
284:
285:

Line 289: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');

285:
286: if p_release_time_fence_code = 6 then
287: -- Kanban Items Cannot be Released.
288: p_rel_error := p_rel_error ||' '||
289: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');
290: end if;
291:
292: if p_in_source_plan = 1 then
293: p_rel_schd_OK :=

Line 305: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IN_SOURCE_PLAN');

301: p_new_order_qty =0 and -- for supply schedule
302: p_rel_schd_OK = 'N') then
303:
304: p_rel_error := p_rel_error ||' '||
305: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IN_SOURCE_PLAN');
306: end if;
307: end if; -- if p_in_source_plan = 1 then
308:
309: if p_action = msc_get_name.lookup_meaning('MRP_ACTIONS',6) then -- None

Line 314: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ACTION_NONE');

310: if (p_plan_type = 8 and p_order_type = 51) then
311: null;
312: else
313: p_rel_error := p_rel_error ||' '||
314: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ACTION_NONE');
315: end if;
316: end if;
317:
318:

Line 321: FND_MESSAGE.GET_STRING('MSC', 'MSC_NO_FLOW_SCHEDULE');

317:
318:
319: if p_cfm_routing_flag = 1 and p_order_type = 5 then
320: p_rel_error := p_rel_error ||' '||
321: FND_MESSAGE.GET_STRING('MSC', 'MSC_NO_FLOW_SCHEDULE');
322: end if;
323:
324: if p_effectivity_control=2 and
325: p_unit_number is null and

Line 328: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_UNIT_NUMBER');

324: if p_effectivity_control=2 and
325: p_unit_number is null and
326: p_order_type = 5 then
327: p_rel_error := p_rel_error || ' '||
328: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_UNIT_NUMBER');
329: end if;
330:
331: if p_project_id is not null then
332: p_valid := msc_rel_wf.is_pjm_valid(p_org_id,

Line 340: FND_MESSAGE.GET_STRING('MSC', 'MSC_PJM_VALIDATION1');

336: null,
337: p_inst_id);
338: if p_valid = 0 then
339: p_rel_error := p_rel_error || ' '||
340: FND_MESSAGE.GET_STRING('MSC', 'MSC_PJM_VALIDATION1');
341:
342: end if;
343: end if; -- if p_project_id is not null then
344:

Line 356: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');

352: p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
353: p_plan_id, p_transaction_id);
354: if p_valid > 0 then
355: p_rel_error := p_rel_error ||' '||
356: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');
357: end if;
358:
359: end if; -- if nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y'
360:

Line 388: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_LOCATION');

384: CLOSE loc_c;
385: /*
386: if p_loc_id is null then
387: p_rel_error := p_rel_error ||' '||
388: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_LOCATION');
389: end if;
390: */
391: end if; -- if p_impl_as in (2,5) or p_order_type = 2 then
392:

Line 402: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_EMPLOYEE');

398: CLOSE empl_C;
399:
400: if p_empl_id is null then
401: p_rel_error := p_rel_error ||' '||
402: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_EMPLOYEE');
403: end if;
404: end if; -- if p_impl_as in (2,5) then
405:
406: end if; -- if p_rel_error is null then

Line 868: p_rel_error := FND_MESSAGE.GET_STRING('MSC',p_mesg);

864: p_mesg := null;
865: p_mesg :=
866: msc_rel_wf.verify_so_release(p_plan_id, p_transaction_id, p_inst_id);
867: if p_mesg is not null then
868: p_rel_error := FND_MESSAGE.GET_STRING('MSC',p_mesg);
869: update_dmd_rel_error;
870: p_error_rows := p_error_rows +1;
871: else -- if l_mesg is null then
872: p_succ_rows := p_succ_rows +1;