APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on FND_PROFILE

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

222: end if;
223:
224: if p_in_source_plan = 1 then
225: p_rel_schd_OK :=
226: nvl(fnd_profile.value('MSC_DRP_RELEASE_FROM_MRP'),'N');
227: -- Record was generated as part of some other plan/schedule.
228: if (p_lots_exist = 2 and -- can not release supply schedule
229: p_new_order_qty <> 0) or -- which is generated by plan
230: (p_lots_exist = 1 and -- demand schedule

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

274: end if;
275: end if; -- if p_project_id is not null then
276:
277: p_valid := null;
278: if nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y' and
279: p_order_type = 5 and p_org_id = p_source_org_id then
280:
281: -- 4417550, make planned order can be released only when
282: -- child supply are on hand or make planned order

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

287: p_rel_error := p_rel_error ||' '||
288: FND_MESSAGE.GET_STRING('MSC', 'MSC_REL_ONLY_ONHAND_WARN2');
289: end if;
290:
291: end if; -- if nvl(FND_PROFILE.VALUE('MSC_REL_ONLY_ONHAND_SUPPLY'),'N') = 'Y'
292:
293: if p_rel_error is null then
294: if p_order_type in (5,13,51,76,77,78) then
295: --pabram.srp.changes added 76,77,78