35: procedure Get_Day_Uom(X_day_uom_code IN VARCHAR2,
36: X_day_uom OUT NOCOPY VARCHAR2) is
37: BEGIN
38: select unit_of_measure into X_day_uom
39: from mtl_units_of_measure
40: where uom_code = X_day_uom_code;
41: exception
42: when NO_DATA_FOUND then
43: Fnd_Message.Set_Name('CS','CS_ALL_INVALID_UOM_CODE');
48: procedure Get_Month_Uom(X_month_uom_code IN VARCHAR2,
49: X_month_uom OUT NOCOPY VARCHAR2) is
50: BEGIN
51: select unit_of_measure into X_month_uom
52: from mtl_units_of_measure
53: where uom_code = X_month_uom_code;
54: exception
55: when NO_DATA_FOUND then
56: Fnd_Message.Set_Name('CS','CS_ALL_INVALID_UOM_CODE');