2202: Oe_Debug_Pub.ADD('p_operand_type = ' || p_operand_type);
2203:
2204: END IF;
2205: IF p_operand_type <> 'R' AND p_operand IS NULL THEN
2206: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_ERROR) THEN
2207: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2208: Fnd_Message.SET_TOKEN('ATTRIBUTE','Operand');
2209: Oe_Msg_Pub.ADD;
2210: END IF;
2205: IF p_operand_type <> 'R' AND p_operand IS NULL THEN
2206: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_ERROR) THEN
2207: Fnd_Message.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2208: Fnd_Message.SET_TOKEN('ATTRIBUTE','Operand');
2209: Oe_Msg_Pub.ADD;
2210: END IF;
2211: RAISE Fnd_Api.G_EXC_ERROR;
2212: END IF;
2213:
3006: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
3007:
3008: -- Get message count and data
3009:
3010: Oe_Msg_Pub.Count_And_Get
3011: ( p_count => x_msg_count
3012: , p_data => x_msg_data
3013: );
3014:
3016: EXCEPTION
3017: WHEN NO_DATA_FOUND THEN
3018: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3019:
3020: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3021: THEN
3022: Oe_Msg_Pub.Add_Exc_Msg
3023: ( G_PKG_NAME
3024: , 'Get_Blanket_Pricelist_Modifier'
3018: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3019:
3020: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3021: THEN
3022: Oe_Msg_Pub.Add_Exc_Msg
3023: ( G_PKG_NAME
3024: , 'Get_Blanket_Pricelist_Modifier'
3025: );
3026: END IF;
3026: END IF;
3027:
3028: -- Get message count and data
3029:
3030: Oe_Msg_Pub.Count_And_Get
3031: ( p_count => x_msg_count
3032: , p_data => x_msg_data
3033: );
3034:
3037: WHEN OTHERS THEN
3038:
3039: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3040:
3041: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3042: THEN
3043: Oe_Msg_Pub.Add_Exc_Msg
3044: ( G_PKG_NAME
3045: , 'Get_Blanket_Pricelist_Modifier'
3039: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
3040:
3041: IF Oe_Msg_Pub.Check_Msg_Level(Oe_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
3042: THEN
3043: Oe_Msg_Pub.Add_Exc_Msg
3044: ( G_PKG_NAME
3045: , 'Get_Blanket_Pricelist_Modifier'
3046: );
3047: END IF;
3047: END IF;
3048:
3049: -- Get message count and data
3050:
3051: Oe_Msg_Pub.Count_And_Get
3052: ( p_count => x_msg_count
3053: , p_data => x_msg_data
3054: );
3055: