[Home] [Help]
1201: BEGIN
1202:
1203: x_return_status := FND_API.G_RET_STS_SUCCESS;
1204:
1205: QP_Maintain_Denormalized_Data.Update_Qualifiers(err_buff => l_err_buf,
1206: retcode => l_ret_code,
1207: p_list_header_id => p_list_header_id,
1208: p_update_type => 'DELAYED_REQ');
1209:
1225: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1226: THEN
1227: OE_MSG_PUB.Add_Exc_Msg
1228: ( G_PKG_NAME
1229: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');
1230: END IF;
1231:
1232: WHEN OTHERS THEN
1233:
1527:
1528: --made the change to call this API to update the basic_modifiers_setup profile
1529: --when a limit gets created so the OM calls old code path
1530: IF QP_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110509' THEN
1531: QP_Maintain_Denormalized_Data.Update_Pricing_Phases
1532: (p_update_type => 'DELAYED_REQ'
1533: --,p_pricing_phase_id => p_pricing_phase_id
1534: -- commenting out as suggested by SPGOPAL
1535: ,x_return_status => x_return_status
2028: , PH.line_group_exists =
2029: decode(l_level,'N',PH.line_group_exists,'Y',l_level)
2030: where pricing_phase_id = p_pricing_phase_id;
2031: */
2032: QP_Maintain_Denormalized_Data.Update_Pricing_Phases
2033: (p_update_type => 'DELAYED_REQ'
2034: ,p_pricing_phase_id => p_pricing_phase_id
2035: ,p_automatic_flag => p_automatic_flag --fix for bug 3756625
2036: ,p_count => p_count
2817: l_return_status_text VARCHAR2(200);
2818: procedure_error Exception;
2819: BEGIN
2820:
2821: QP_Maintain_Denormalized_Data.Set_HVOP_Pricing (x_return_status, l_return_status_text);
2822: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
2823: raise procedure_error;
2824: END IF;
2825:
2826: EXCEPTION
2827: WHEN procedure_error THEN
2828: OE_MSG_PUB.Add_Exc_Msg
2829: ( G_PKG_NAME
2830: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2831:
2832: WHEN FND_API.G_EXC_ERROR THEN
2833: x_return_status := FND_API.G_RET_STS_ERROR;
2834: OE_MSG_PUB.Add_Exc_Msg