[Home] [Help]
750: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
751: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
752: fnd_message.set_token('VALUE', to_char(p_start_date));
753: fnd_msg_pub.add;
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: IF adjust_date(p_end_date, l_new_end_date, 1, p_workday_control,
757: p_organization_id) = FALSE
758: THEN
759: fnd_message.set_name('MRP', 'GEN-INVALID ENTITY');
760: fnd_message.set_token('ENTITY', 'EC_FORECAST_DATE', TRUE);
761: fnd_message.set_token('VALUE', to_char(p_end_date));
762: fnd_msg_pub.add;
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765:
766: l_count := mrp_calendar.days_between(p_organization_id,1,
767: l_new_start_date,l_new_end_date);
783: CLOSE C1;
784:
785: x_quantity_per_day := l_quantity_per_day;
786:
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788:
789: EXCEPTION
790:
791: WHEN FND_API.G_EXC_ERROR THEN
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788:
789: EXCEPTION
790:
791: WHEN FND_API.G_EXC_ERROR THEN
792:
793: x_return_status := FND_API.G_RET_STS_ERROR;
794:
795: -- Get message count and data
789: EXCEPTION
790:
791: WHEN FND_API.G_EXC_ERROR THEN
792:
793: x_return_status := FND_API.G_RET_STS_ERROR;
794:
795: -- Get message count and data
796:
797: FND_MSG_PUB.Count_And_Get
798: ( p_count => x_msg_count
799: , p_data => x_msg_data
800: );
801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803:
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
805:
806: -- Get message count and data
800: );
801:
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803:
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
805:
806: -- Get message count and data
807:
808: FND_MSG_PUB.Count_And_Get
811: );
812:
813: WHEN OTHERS THEN
814:
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
816:
817: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
818: THEN
819: FND_MSG_PUB.Add_Exc_Msg