94: -- Start API body
95: -- check if atleast one query parameters are passed
96: IF (p_pricing_attribs_query_rec.pricing_attribute_id = FND_API.G_MISS_NUM)
97: AND (p_pricing_attribs_query_rec.instance_id = FND_API.G_MISS_NUM) THEN
98: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
99: FND_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
140: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
141: IF p_time_stamp <= sysdate THEN
142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);
143: ELSE
144: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN('TIME_STAMP',p_time_stamp);
146: FND_MSG_PUB.ADD;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
141: IF p_time_stamp <= sysdate THEN
142: csi_pricing_attribs_pvt.Construct_pri_From_Hist(x_pricing_attribs_tbl, p_time_stamp);
143: ELSE
144: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
145: FND_MESSAGE.SET_TOKEN('TIME_STAMP',p_time_stamp);
146: FND_MSG_PUB.ADD;
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149: END IF;