APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on FND_PROFILE

Line 294: nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');

290: end if;
291:
292: if p_in_source_plan = 1 then
293: p_rel_schd_OK :=
294: nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');
295: -- Record was generated as part of some other plan/schedule.
296: if (p_lots_exist = 2 and -- can not release supply schedule
297: p_new_order_qty <> 0) or -- which is generated by plan
298: (p_lots_exist = 1 and -- demand schedule

Line 346: if nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y' and

342: end if;
343: end if; -- if p_project_id is not null then
344:
345: p_valid := null;
346: if nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y' and
347: p_order_type = 5 and p_org_id = p_source_org_id then
348:
349: -- 4417550, make planned order can be released only when
350: -- child supply are on hand or make planned order

Line 359: end if; -- if nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y'

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:
361: if p_rel_error is null then
362: if p_order_type in (5,13,51,76,77,78,53) then
363: --pabram.srp.changes added 76,77,78