DBA Data[Home] [Help]

APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_MAINTAIN_DENORMALIZED_DATA

Line 1197: QP_Maintain_Denormalized_Data.Update_Qualifiers(err_buff => l_err_buf,

1193: BEGIN
1194:
1195: x_return_status := FND_API.G_RET_STS_SUCCESS;
1196:
1197: QP_Maintain_Denormalized_Data.Update_Qualifiers(err_buff => l_err_buf,
1198: retcode => l_ret_code,
1199: p_list_header_id => p_list_header_id,
1200: p_update_type => 'DELAYED_REQ');
1201:

Line 1221: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');

1217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: OE_MSG_PUB.Add_Exc_Msg
1220: ( G_PKG_NAME
1221: , 'Unexpected error occured in the procedure : QP_Maintain_Denormalized_Data.Update_Qualifiers');
1222: END IF;
1223:
1224: WHEN OTHERS THEN
1225:

Line 1523: QP_Maintain_Denormalized_Data.Update_Pricing_Phases

1519:
1520: --made the change to call this API to update the basic_modifiers_setup profile
1521: --when a limit gets created so the OM calls old code path
1522: IF QP_CODE_CONTROL.GET_CODE_RELEASE_LEVEL < '110509' THEN
1523: QP_Maintain_Denormalized_Data.Update_Pricing_Phases
1524: (p_update_type => 'DELAYED_REQ'
1525: --,p_pricing_phase_id => p_pricing_phase_id
1526: -- commenting out as suggested by SPGOPAL
1527: ,x_return_status => x_return_status

Line 2024: QP_Maintain_Denormalized_Data.Update_Pricing_Phases

2020: , PH.line_group_exists =
2021: decode(l_level,'N',PH.line_group_exists,'Y',l_level)
2022: where pricing_phase_id = p_pricing_phase_id;
2023: */
2024: QP_Maintain_Denormalized_Data.Update_Pricing_Phases
2025: (p_update_type => 'DELAYED_REQ'
2026: ,p_pricing_phase_id => p_pricing_phase_id
2027: ,p_automatic_flag => p_automatic_flag --fix for bug 3756625
2028: ,p_count => p_count

Line 2810: QP_Maintain_Denormalized_Data.Set_HVOP_Pricing (x_return_status, l_return_status_text);

2806: l_return_status_text VARCHAR2(200);
2807: procedure_error Exception;
2808: BEGIN
2809:
2810: QP_Maintain_Denormalized_Data.Set_HVOP_Pricing (x_return_status, l_return_status_text);
2811: IF(x_return_status=FND_API.G_RET_STS_ERROR) THEN
2812: raise procedure_error;
2813: END IF;
2814:

Line 2819: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);

2815: EXCEPTION
2816: WHEN procedure_error THEN
2817: OE_MSG_PUB.Add_Exc_Msg
2818: ( G_PKG_NAME
2819: , 'Error while executing the process QP_Maintain_Denormalized_Data.Set_HVOP_Pricing : '|| l_return_status_text);
2820:
2821: WHEN FND_API.G_EXC_ERROR THEN
2822: x_return_status := FND_API.G_RET_STS_ERROR;
2823: OE_MSG_PUB.Add_Exc_Msg