[Home] [Help]
5601: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
5602: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
5603: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
5604: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR,
5605: QP_PREQ_PUB.G_BACK_CALCULATION_STS)
5606: then
5607: IF (l_debug = 'Y') THEN
5608: my_debug('15020: some error in request, code-'||p_req_line_tbl(i).status_code);
5609: my_debug('15022: pricelist id on line-'||l_line_rec.pricelist_id);
5796: QP_PREQ_GRP.G_STATUS_NEW,
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then
5802: -- right now this way because of a bug in QP. Later on QP might return this error in retcode on request line
5803: -- also QP_PREQ_PUB.G_BACK_CALCULATION_STS might hold 'BACK CALCULATION ERROR' instaed of
5804: -- 'BACK_CALCULATION_ERROR'. Right now processed code returns 'BACK CALCULATION ERROR'
5797: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5798: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then
5802: -- right now this way because of a bug in QP. Later on QP might return this error in retcode on request line
5803: -- also QP_PREQ_PUB.G_BACK_CALCULATION_STS might hold 'BACK CALCULATION ERROR' instaed of
5804: -- 'BACK_CALCULATION_ERROR'. Right now processed code returns 'BACK CALCULATION ERROR'
5805: -- while QP_PREQ_PUB.G_BACK_CALCULATION_STS has value 'BACK_CALCULATION_ERROR'
5799: QP_PREQ_GRP.G_STATUS_UNCHANGED,
5800: QP_PREQ_PUB.G_BACK_CALCULATION_STS) and
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then
5802: -- right now this way because of a bug in QP. Later on QP might return this error in retcode on request line
5803: -- also QP_PREQ_PUB.G_BACK_CALCULATION_STS might hold 'BACK CALCULATION ERROR' instaed of
5804: -- 'BACK_CALCULATION_ERROR'. Right now processed code returns 'BACK CALCULATION ERROR'
5805: -- while QP_PREQ_PUB.G_BACK_CALCULATION_STS has value 'BACK_CALCULATION_ERROR'
5806: nvl(p_req_line_tbl(i).processed_code,'0') = 'BACK CALCULATION ERROR' then
5807: IF l_line_rec.line_num is null then
5801: --???? change later nvl(p_req_line_tbl(i).processed_code,'0') = QP_PREQ_PUB.G_BACK_CALCULATION_STS then
5802: -- right now this way because of a bug in QP. Later on QP might return this error in retcode on request line
5803: -- also QP_PREQ_PUB.G_BACK_CALCULATION_STS might hold 'BACK CALCULATION ERROR' instaed of
5804: -- 'BACK_CALCULATION_ERROR'. Right now processed code returns 'BACK CALCULATION ERROR'
5805: -- while QP_PREQ_PUB.G_BACK_CALCULATION_STS has value 'BACK_CALCULATION_ERROR'
5806: nvl(p_req_line_tbl(i).processed_code,'0') = 'BACK CALCULATION ERROR' then
5807: IF l_line_rec.line_num is null then
5808: -- get the concatenated line number to show in error message
5809: l_line_rec.line_num := OKC_CONTRACT_PUB.Get_concat_line_no(
5833: QP_PREQ_GRP.G_STATUS_NEW,
5834: QP_PREQ_GRP.G_STATUS_SYSTEM_GENERATED,
5835: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION,
5836: QP_PREQ_GRP.G_STATUS_UNCHANGED) and
5837: nvl(p_req_line_tbl(i).processed_code,'0') <> QP_PREQ_PUB.G_BY_ENGINE--????check this one
5838: and p_req_line_tbl(i).price_flag IN ('Y','P')
5839: then
5840: --??? update line's unit price to null in case of error
5841: --dbms_output.put_line('a2.5');
6981: -- dbmsoutput area*/
6982: IF (l_debug = 'Y') THEN
6983: my_debug('16924:Before Calling Price Request calculate flag'||l_control_rec.calculate_flag);
6984: END IF;
6985: QP_PREQ_PUB.PRICE_REQUEST
6986: --QP_PREQ_GRP.PRICE_REQUEST
6987: (p_control_rec => l_control_rec
6988: ,p_line_tbl => l_Req_line_tbl
6989: ,p_qual_tbl => l_qualifiers_contexts_tbl