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