4161: l_excess_supply_by_dc := NVL(FND_PROFILE.VALUE('MSC_EXCESS_SUPPLY_BY_DC'), 'N');
4162: msc_util.msc_log('l_excess_supply_by_dc := ' || l_excess_supply_by_dc);
4163:
4164: BEGIN
4165: msc_util.msc_log('Calling custom procedure MSC_ATP_CUSTOM.Custom_Pre_Allocation...');
4166: MSC_ATP_CUSTOM.Custom_Pre_Allocation(p_plan_id);
4167: msc_util.msc_log('End MSC_ATP_CUSTOM.Custom_Pre_Allocation.');
4168: EXCEPTION
4169: WHEN OTHERS THEN
4162: msc_util.msc_log('l_excess_supply_by_dc := ' || l_excess_supply_by_dc);
4163:
4164: BEGIN
4165: msc_util.msc_log('Calling custom procedure MSC_ATP_CUSTOM.Custom_Pre_Allocation...');
4166: MSC_ATP_CUSTOM.Custom_Pre_Allocation(p_plan_id);
4167: msc_util.msc_log('End MSC_ATP_CUSTOM.Custom_Pre_Allocation.');
4168: EXCEPTION
4169: WHEN OTHERS THEN
4170: msc_util.msc_log('Error in custom procedure call');
4163:
4164: BEGIN
4165: msc_util.msc_log('Calling custom procedure MSC_ATP_CUSTOM.Custom_Pre_Allocation...');
4166: MSC_ATP_CUSTOM.Custom_Pre_Allocation(p_plan_id);
4167: msc_util.msc_log('End MSC_ATP_CUSTOM.Custom_Pre_Allocation.');
4168: EXCEPTION
4169: WHEN OTHERS THEN
4170: msc_util.msc_log('Error in custom procedure call');
4171: msc_util.msc_log('Error Code: '|| sqlerrm);