275: AND (p_rev_op_res_unexp_rec.activity_id = p_old_rev_op_res_unexp_rec.activity_id
276: OR ( p_rev_op_res_unexp_rec.activity_id IS NULL
277: AND p_old_rev_op_res_unexp_rec.activity_id IS NULL )
278: )
279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag
280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL
281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )
282: )
283: AND (p_rev_op_resource_rec.assigned_units = p_old_rev_op_resource_rec.assigned_units
276: OR ( p_rev_op_res_unexp_rec.activity_id IS NULL
277: AND p_old_rev_op_res_unexp_rec.activity_id IS NULL )
278: )
279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag
280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL
281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )
282: )
283: AND (p_rev_op_resource_rec.assigned_units = p_old_rev_op_resource_rec.assigned_units
284: OR ( p_rev_op_resource_rec.assigned_units IS NULL
277: AND p_old_rev_op_res_unexp_rec.activity_id IS NULL )
278: )
279: AND (p_rev_op_resource_rec.standard_rate_flag = p_old_rev_op_resource_rec.standard_rate_flag
280: OR ( p_rev_op_resource_rec.standard_rate_flag IS NULL
281: AND p_old_rev_op_resource_rec.standard_rate_flag IS NULL )
282: )
283: AND (p_rev_op_resource_rec.assigned_units = p_old_rev_op_resource_rec.assigned_units
284: OR ( p_rev_op_resource_rec.assigned_units IS NULL
285: AND p_old_rev_op_resource_rec.assigned_units IS NULL )
1660: l_return_status := FND_API.G_RET_STS_ERROR;
1661: END IF ;
1662:
1663:
1664: -- Standard Rate Flag
1665: IF p_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1666: THEN
1667: Error_Handler.Add_Error_Token
1668: ( p_Message_Name => 'BOM_RES_STD_RATE_MISSING'
1661: END IF ;
1662:
1663:
1664: -- Standard Rate Flag
1665: IF p_rev_op_resource_rec.standard_rate_flag = FND_API.G_MISS_NUM
1666: THEN
1667: Error_Handler.Add_Error_Token
1668: ( p_Message_Name => 'BOM_RES_STD_RATE_MISSING'
1669: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1776: l_return_status := FND_API.G_RET_STS_ERROR;
1777: END IF;
1778:
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1777: END IF;
1778:
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1785: Error_Handler.Add_Error_Token
1778:
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1785: Error_Handler.Add_Error_Token
1786: ( p_Message_Name => 'BOM_RES_STD_RATE_INVALID'
1779:
1780: -- Standard Rate Flag
1781: IF p_rev_op_resource_rec.standard_rate_flag IS NOT NULL AND
1782: p_rev_op_resource_rec.standard_rate_flag NOT IN (1,2)
1783: AND p_rev_op_resource_rec.standard_rate_flag <> FND_API.G_MISS_NUM
1784: THEN
1785: Error_Handler.Add_Error_Token
1786: ( p_Message_Name => 'BOM_RES_STD_RATE_INVALID'
1787: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl