eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on FND_API

Line 23: IF l_debug = FND_API.G_TRUE THEN

19:
20: BEGIN
21: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
22: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
23: IF l_debug = FND_API.G_TRUE THEN
24: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine not Installed ----------');
25: END IF;
26: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
27: Update qp_npreq_ldets_tmp set price_adjustment_id =

Line 37: IF l_debug = FND_API.G_TRUE THEN

33: and nvl(created_from_list_type_code,'NULL') not in
34: (QP_PREQ_PUB.G_PRICE_LIST_HEADER, QP_PREQ_PUB.G_AGR_LIST_HEADER);
35: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
36: ELSE
37: IF l_debug = FND_API.G_TRUE THEN
38: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine is Installed ----------');
39: END IF;
40: IF (QP_UTIL_PUB.HVOP_Pricing_ON = 'Y') THEN
41: Update qp_int_ldets set price_adjustment_id =

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: (QP_PREQ_PUB.G_PRICE_LIST_HEADER, QP_PREQ_PUB.G_AGR_LIST_HEADER);
61: END IF;
62: END IF;
63: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: Exception
66: When OTHERS Then
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_return_status_text := 'QP_CLEANUP_ADJUSTMENTS_PVT.Populate_Price_Adj_ID '||SQLERRM;

Line 67: x_return_status := FND_API.G_RET_STS_ERROR;

63: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65: Exception
66: When OTHERS Then
67: x_return_status := FND_API.G_RET_STS_ERROR;
68: x_return_status_text := 'QP_CLEANUP_ADJUSTMENTS_PVT.Populate_Price_Adj_ID '||SQLERRM;
69: END Populate_Price_Adj_ID;
70:
71: --This is used on PUB to get the sum of operand to see if the sum of

Line 92: IF l_debug = FND_API.G_TRUE THEN

88: IF l_adj_sum_operand is null
89: THEN
90: l_adj_sum_operand := 0;
91: END IF;
92: IF l_debug = FND_API.G_TRUE THEN
93: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
94: END IF;
95: RETURN l_adj_sum_operand;
96:

Line 100: IF l_debug = FND_API.G_TRUE THEN

96:
97: EXCEPTION
98: When NO_DATA_FOUND Then
99: l_adj_sum_operand := 0;
100: IF l_debug = FND_API.G_TRUE THEN
101: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
102: END IF;
103: RETURN l_adj_sum_operand;
104: When OTHERS Then

Line 105: l_adj_sum_operand := FND_API.G_MISS_NUM;

101: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
102: END IF;
103: RETURN l_adj_sum_operand;
104: When OTHERS Then
105: l_adj_sum_operand := FND_API.G_MISS_NUM;
106: IF l_debug = FND_API.G_TRUE THEN
107: QP_PREQ_GRP.engine_debug(' Exception adj operand '||SQLERRM);
108: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
109: END IF;

Line 106: IF l_debug = FND_API.G_TRUE THEN

102: END IF;
103: RETURN l_adj_sum_operand;
104: When OTHERS Then
105: l_adj_sum_operand := FND_API.G_MISS_NUM;
106: IF l_debug = FND_API.G_TRUE THEN
107: QP_PREQ_GRP.engine_debug(' Exception adj operand '||SQLERRM);
108: QP_PREQ_GRP.engine_debug(' Sum of adj operand '||l_adj_sum_operand);
109: END IF;
110: RETURN l_adj_sum_operand;

Line 776: IF l_debug = FND_API.G_TRUE THEN

772: BEGIN
773:
774: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
775: x:=0;
776: IF l_debug = FND_API.G_TRUE THEN
777: qp_preq_grp.engine_debug('begin update check clnup '||p_cleanup_flag);
778: qp_preq_grp.engine_debug('begin update check reqtype '||p_request_type_code);
779: qp_preq_grp.engine_debug('begin update check viewcode '||p_view_code);
780: END IF; --Bug No 4033618

Line 788: IF l_debug = FND_API.G_TRUE THEN

784: --bug 3085453 handle pricing availability UI
785: -- they pass reqtype ONT and insert adj into ldets
786: and QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
787: THEN
788: IF l_debug = FND_API.G_TRUE THEN
789: qp_preq_grp.engine_debug('in update cleanup '||p_cleanup_flag);
790: END IF; -- Bug No 4033618
791: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
792: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN

Line 793: IF l_debug = FND_API.G_TRUE THEN

789: qp_preq_grp.engine_debug('in update cleanup '||p_cleanup_flag);
790: END IF; -- Bug No 4033618
791: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
792: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
793: IF l_debug = FND_API.G_TRUE THEN
794: QP_PREQ_GRP.ENGINE_DEBUG('cleanup_adjustments Java Engine not Installed ----------');
795: END IF;
796: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
797:

Line 930: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE

926:
927: FOR i IN l_cur_dtl_index_tbl.FIRST..l_cur_dtl_index_tbl.LAST
928: LOOP
929:
930: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
931: THEN
932: qp_preq_grp.engine_debug('loop update cur line ind '
933: ||l_cur_line_index_tbl(i)||' line_dtl_index '
934: ||l_cur_dtl_index_tbl(i)||' price_adj_id '

Line 988: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =

984: END IF;--debug
985:
986:
987: IF
988: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
989: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
990: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
991: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
992: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =

Line 989: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)

985:
986:
987: IF
988: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
989: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
990: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
991: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
992: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =
993: nvl(l_adj_pricing_grp_seq_tbl(i),-1)

Line 990: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =

986:
987: IF
988: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
989: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
990: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
991: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
992: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =
993: nvl(l_adj_pricing_grp_seq_tbl(i),-1)
994: AND nvl(l_cur_charge_type_tbl(i),'NULL') =

Line 991: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)

987: IF
988: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
989: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
990: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
991: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
992: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =
993: nvl(l_adj_pricing_grp_seq_tbl(i),-1)
994: AND nvl(l_cur_charge_type_tbl(i),'NULL') =
995: nvl(l_adj_charge_type_tbl(i),'NULL')

Line 1026: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =

1022: AND nvl(l_cur_prorat_type_tbl(i),'NULL') =
1023: nvl(l_adj_prorat_type_tbl(i),'NULL')
1024: AND nvl(l_cur_include_ret_flag_tbl(i), ' ') =
1025: nvl(l_adj_include_ret_flag_tbl(i),' ')
1026: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =

Line 1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)

1023: nvl(l_adj_prorat_type_tbl(i),'NULL')
1024: AND nvl(l_cur_include_ret_flag_tbl(i), ' ') =
1025: nvl(l_adj_include_ret_flag_tbl(i),' ')
1026: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)

Line 1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =

1024: AND nvl(l_cur_include_ret_flag_tbl(i), ' ') =
1025: nvl(l_adj_include_ret_flag_tbl(i),' ')
1026: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =

Line 1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)

1025: nvl(l_adj_include_ret_flag_tbl(i),' ')
1026: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)

Line 1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =

1026: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN

Line 1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)

1027: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN
1035: x:=x+1;

Line 1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =

1028: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN
1035: x:=x+1;
1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)

1029: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1030: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1031: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN
1035: x:=x+1;
1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1037: qp_preq_grp.engine_debug('if update check '||x);

Line 1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

1032: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1033: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1034: THEN
1035: x:=x+1;
1036: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1037: qp_preq_grp.engine_debug('if update check '||x);
1038: qp_preq_grp.engine_debug('update check dtls '
1039: ||l_cur_dtl_index_tbl(i)||' adj_id '
1040: ||l_cur_price_adj_id_tbl(i)||' id '

Line 1052: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

1048: l_process_code_tbl(x) := QP_PREQ_PUB.G_STATUS_UNCHANGED;
1049: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1050: ELSE
1051: x:=x+1;
1052: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1053: qp_preq_grp.engine_debug('else update check '||x);
1054: qp_preq_grp.engine_debug('update check dtls '
1055: ||l_cur_dtl_index_tbl(i)||' adj_id '
1056: ||l_cur_price_adj_id_tbl(i)||' id '

Line 1074: IF l_debug = FND_API.G_TRUE THEN

1070: END LOOP;--bulk fetch
1071: CLOSE l_update_cur;
1072: ELSE
1073: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1074: IF l_debug = FND_API.G_TRUE THEN
1075: QP_PREQ_GRP.ENGINE_DEBUG('cleanup_adjustments() Java Engine is Installed ----------');
1076: END IF;
1077: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1078:

Line 1211: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE

1207:
1208: FOR i IN l_cur_dtl_index_tbl.FIRST..l_cur_dtl_index_tbl.LAST
1209: LOOP
1210:
1211: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1212: THEN
1213: qp_preq_grp.engine_debug('loop update cur line ind '
1214: ||l_cur_line_index_tbl(i)||' line_dtl_index '
1215: ||l_cur_dtl_index_tbl(i)||' price_adj_id '

Line 1269: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =

1265: END IF;--debug
1266:
1267:
1268: IF
1269: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
1270: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
1271: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
1272: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
1273: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =

Line 1270: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)

1266:
1267:
1268: IF
1269: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
1270: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
1271: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
1272: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
1273: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =
1274: nvl(l_adj_pricing_grp_seq_tbl(i),-1)

Line 1271: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =

1267:
1268: IF
1269: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
1270: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
1271: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
1272: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
1273: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =
1274: nvl(l_adj_pricing_grp_seq_tbl(i),-1)
1275: AND nvl(l_cur_charge_type_tbl(i),'NULL') =

Line 1272: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)

1268: IF
1269: nvl(l_cur_adj_amt_tbl(i),FND_API.G_MISS_NUM) =
1270: nvl(l_adj_adj_amt_pqty_tbl(i),FND_API.G_MISS_NUM)
1271: AND nvl(l_cur_operand_tbl(i),FND_API.G_MISS_NUM) =
1272: nvl(l_adj_operand_pqty_tbl(i),FND_API.G_MISS_NUM)
1273: AND nvl(l_cur_pricing_grp_seq_tbl(i),-1) =
1274: nvl(l_adj_pricing_grp_seq_tbl(i),-1)
1275: AND nvl(l_cur_charge_type_tbl(i),'NULL') =
1276: nvl(l_adj_charge_type_tbl(i),'NULL')

Line 1307: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =

1303: AND nvl(l_cur_prorat_type_tbl(i),'NULL') =
1304: nvl(l_adj_prorat_type_tbl(i),'NULL')
1305: AND nvl(l_cur_include_ret_flag_tbl(i), ' ') =
1306: nvl(l_adj_include_ret_flag_tbl(i),' ')
1307: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =

Line 1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)

1304: nvl(l_adj_prorat_type_tbl(i),'NULL')
1305: AND nvl(l_cur_include_ret_flag_tbl(i), ' ') =
1306: nvl(l_adj_include_ret_flag_tbl(i),' ')
1307: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)

Line 1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =

1305: AND nvl(l_cur_include_ret_flag_tbl(i), ' ') =
1306: nvl(l_adj_include_ret_flag_tbl(i),' ')
1307: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =

Line 1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)

1306: nvl(l_adj_include_ret_flag_tbl(i),' ')
1307: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)

Line 1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =

1307: AND nvl(l_cur_exp_date_tbl(i),FND_API.G_MISS_DATE) =
1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN

Line 1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)

1308: nvl(l_adj_exp_date_tbl(i), FND_API.G_MISS_DATE)
1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN
1316: x:=x+1;

Line 1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =

1309: AND nvl(l_cur_line_qty_tbl(i),FND_API.G_MISS_NUM) =
1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN
1316: x:=x+1;
1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)

1310: nvl(l_adj_range_break_qty_tbl(i), FND_API.G_MISS_NUM)
1311: AND nvl(l_cur_ord_qty_adjamt(i),FND_API.G_MISS_NUM) =
1312: nvl(l_adj_ord_qty_adjamt(i), FND_API.G_MISS_NUM)
1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN
1316: x:=x+1;
1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1318: qp_preq_grp.engine_debug('if update check '||x);

Line 1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

1313: AND nvl(l_cur_ord_qty_operand(i),FND_API.G_MISS_NUM) =
1314: nvl(l_adj_ord_qty_operand(i), FND_API.G_MISS_NUM)
1315: THEN
1316: x:=x+1;
1317: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1318: qp_preq_grp.engine_debug('if update check '||x);
1319: qp_preq_grp.engine_debug('update check dtls '
1320: ||l_cur_dtl_index_tbl(i)||' adj_id '
1321: ||l_cur_price_adj_id_tbl(i)||' id '

Line 1333: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

1329: l_process_code_tbl(x) := QP_PREQ_PUB.G_STATUS_UNCHANGED;
1330: l_pricing_sts_text_tbl(x) := 'ADJUSTMENT INFO UNCHANGED';
1331: ELSE
1332: x:=x+1;
1333: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1334: qp_preq_grp.engine_debug('else update check '||x);
1335: qp_preq_grp.engine_debug('update check dtls '
1336: ||l_cur_dtl_index_tbl(i)||' adj_id '
1337: ||l_cur_price_adj_id_tbl(i)||' id '

Line 1359: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE

1355:
1356: IF l_line_dtl_index_tbl.COUNT > 0
1357: THEN
1358:
1359: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1360: THEN
1361: FOR x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1362: LOOP
1363: IF l_debug = FND_API.G_TRUE THEN

Line 1363: IF l_debug = FND_API.G_TRUE THEN

1359: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1360: THEN
1361: FOR x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1362: LOOP
1363: IF l_debug = FND_API.G_TRUE THEN
1364: QP_PREQ_GRP.engine_debug('Cleanup debug '
1365: ||' line index '||l_line_index_tbl(x)
1366: ||' line dtl index '||l_line_dtl_index_tbl(x)
1367: ||' price_adj_id '||l_price_adj_id_tbl(x)

Line 1375: IF l_debug = FND_API.G_TRUE THEN

1371: END LOOP;
1372: END IF;
1373: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1374: IF QP_JAVA_ENGINE_UTIL_PUB.Java_Engine_Running = 'N' THEN
1375: IF l_debug = FND_API.G_TRUE THEN
1376: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine not Installed ----------');
1377: END IF;
1378: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1379:

Line 1389: IF l_debug = FND_API.G_TRUE THEN

1385: WHERE line_index = l_line_index_tbl(x)
1386: and line_detail_index = l_line_dtl_index_tbl(x);
1387: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1388: ELSE
1389: IF l_debug = FND_API.G_TRUE THEN
1390: QP_PREQ_GRP.ENGINE_DEBUG('Java Engine is Installed ----------');
1391: END IF;
1392: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1393: UPDATE qp_int_ldets

Line 1448: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE

1444: and attr.pricing_attribute = lattr.attribute
1445: and attr.pricing_attr_value_from = lattr.value_from);
1446:
1447:
1448: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
1449: THEN
1450: for cl in l_attr_cur
1451: loop
1452: qp_preq_grp.engine_debug('attr details '

Line 1464: IF l_debug = FND_API.G_TRUE THEN

1460:
1461:
1462:
1463: END IF;
1464: IF l_debug = FND_API.G_TRUE THEN
1465: QP_PREQ_GRP.engine_debug('Completed QP_CLEANUP.cleanup_adjustments');
1466: END IF;
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:

Line 1467: x_return_status := FND_API.G_RET_STS_SUCCESS;

1463: END IF;
1464: IF l_debug = FND_API.G_TRUE THEN
1465: QP_PREQ_GRP.engine_debug('Completed QP_CLEANUP.cleanup_adjustments');
1466: END IF;
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: EXCEPTION
1470: When OTHERS Then
1471: IF l_debug = FND_API.G_TRUE THEN

Line 1471: IF l_debug = FND_API.G_TRUE THEN

1467: x_return_status := FND_API.G_RET_STS_SUCCESS;
1468:
1469: EXCEPTION
1470: When OTHERS Then
1471: IF l_debug = FND_API.G_TRUE THEN
1472: QP_PREQ_GRP.engine_debug('error in QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM);
1473: END IF;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: --x_return_status_text := 'error QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM';

Line 1474: x_return_status := FND_API.G_RET_STS_ERROR;

1470: When OTHERS Then
1471: IF l_debug = FND_API.G_TRUE THEN
1472: QP_PREQ_GRP.engine_debug('error in QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM);
1473: END IF;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: --x_return_status_text := 'error QP_CLEANUP_ADJ.cleanup_adjustments '||SQLERRM';
1476:
1477: END cleanup_adjustments;
1478:

Line 1485: IF l_debug = FND_API.G_TRUE THEN

1481: RETURN NUMBER IS
1482: BEGIN
1483: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1484: IF G_PBH_PLSQL_IND.EXISTS(p_price_adj_id) THEN
1485: IF l_debug = FND_API.G_TRUE THEN
1486: QP_PREQ_GRP.engine_debug('begin get loop ');
1487: END IF;--l_debug
1488: FOR i IN G_PBH_LINE_DTL_INDEX.FIRST..G_PBH_LINE_DTL_INDEX.LAST
1489: LOOP

Line 1490: IF l_debug = FND_API.G_TRUE THEN

1486: QP_PREQ_GRP.engine_debug('begin get loop ');
1487: END IF;--l_debug
1488: FOR i IN G_PBH_LINE_DTL_INDEX.FIRST..G_PBH_LINE_DTL_INDEX.LAST
1489: LOOP
1490: IF l_debug = FND_API.G_TRUE THEN
1491: QP_PREQ_GRP.engine_debug('in get loop '||G_PBH_LINE_INDEX(i)||' '
1492: ||G_PBH_PRICE_ADJ_ID(i));
1493: END IF;--l_debug
1494: IF G_PBH_LINE_INDEX(i) = p_line_index

Line 1756: IF l_debug = FND_API.G_TRUE THEN

1752: l_pbh_adj_exists VARCHAR2(1) := QP_PREQ_PUB.G_NO;
1753: N pls_integer;
1754: BEGIN
1755: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1756: IF l_debug = FND_API.G_TRUE THEN
1757: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines rqtyp '||p_request_type_code);
1758: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines calcflag '||p_calculate_flag);
1759: QP_PREQ_GRP.engine_debug('Begin Insert_rltd_lines event '||p_event_code);
1760:

Line 1766: IF l_debug = FND_API.G_TRUE THEN

1762: OPEN l_pbh_adj_exists_cur;
1763: FETCH l_pbh_adj_exists_cur INTO l_pbh_adj_exists;
1764: CLOSE l_pbh_adj_exists_cur;
1765:
1766: IF l_debug = FND_API.G_TRUE THEN
1767: QP_PREQ_GRP.engine_debug('Check l_pbh_adj_exists '||l_pbh_adj_exists);
1768:
1769: END IF;
1770: N := 0;

Line 1799: IF l_debug = FND_API.G_TRUE THEN

1795: l_list_line_no_tbl.delete;
1796:
1797: FOR I IN l_rltd_line_info_cur
1798: LOOP
1799: IF l_debug = FND_API.G_TRUE THEN
1800: QP_PREQ_GRP.engine_debug('In l_rltd_line_info_cur');
1801: END IF;
1802: N := N+1;
1803: l_line_index_tbl(N):=I.line_index;

Line 1810: IF l_debug = FND_API.G_TRUE THEN

1806: l_rltd_line_index_tbl(N):=I.related_line_index;
1807:
1808: l_rltd_line_dtl_index_tbl(N):=
1809: Get_line_detail_index(I.related_line_index, I.related_line_detail_index);
1810: IF l_debug = FND_API.G_TRUE THEN
1811: QP_PREQ_GRP.engine_debug('Pbh dtl_index '
1812: ||l_line_dtl_index_tbl(N)
1813: ||' rltd_dtl_index '
1814: ||l_rltd_line_dtl_index_tbl(N));

Line 1837: IF l_debug = FND_API.G_TRUE THEN

1833: l_updated_flag_tbl(N) := I.updated_flag;
1834: l_list_hdr_id_tbl(N) := I.list_header_id;
1835: l_list_line_no_tbl(N) := I.list_line_no;
1836:
1837: IF l_debug = FND_API.G_TRUE THEN
1838: QP_PREQ_GRP.engine_debug('price brk child details '
1839: ||l_line_dtl_index_tbl(N)||' rltd_dtl '
1840: ||l_rltd_line_dtl_index_tbl(N)||' bucket '
1841: ||l_pricing_group_seq_tbl(N)||' '

Line 1853: IF l_debug = FND_API.G_TRUE THEN

1849: ||l_qualifier_value_tbl(N));
1850: END IF;
1851: END LOOP;
1852:
1853: IF l_debug = FND_API.G_TRUE THEN
1854: QP_PREQ_GRP.engine_debug('price brk after loop ');
1855: END IF;
1856: IF l_line_dtl_index_tbl.COUNT > 0
1857: THEN

Line 1858: IF l_debug = FND_API.G_TRUE THEN

1854: QP_PREQ_GRP.engine_debug('price brk after loop ');
1855: END IF;
1856: IF l_line_dtl_index_tbl.COUNT > 0
1857: THEN
1858: IF l_debug = FND_API.G_TRUE THEN
1859: QP_PREQ_GRP.engine_debug('price brk before insert ');
1860: END IF;
1861: FORALL I IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1862: INSERT INTO qp_npreq_rltd_lines_tmp

Line 1955: IF l_debug = FND_API.G_TRUE THEN

1951: ,l_updated_flag_tbl(I) --QP_PREQ_PUB.G_YES
1952: ,l_auto_flag_tbl(I) --QP_PREQ_PUB.G_NO
1953: ,l_pricing_phase_id_tbl(I));
1954:
1955: IF l_debug = FND_API.G_TRUE THEN
1956: QP_PREQ_GRP.engine_debug('price brk after insert ');
1957:
1958: END IF;
1959: END IF;

Line 1961: IF l_debug = FND_API.G_TRUE THEN

1957:
1958: END IF;
1959: END IF;
1960: END IF;
1961: IF l_debug = FND_API.G_TRUE THEN
1962: QP_PREQ_GRP.engine_debug('End Insert_rltd_lines');
1963: END IF;
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: EXCEPTION

Line 1964: x_return_status := FND_API.G_RET_STS_SUCCESS;

1960: END IF;
1961: IF l_debug = FND_API.G_TRUE THEN
1962: QP_PREQ_GRP.engine_debug('End Insert_rltd_lines');
1963: END IF;
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: EXCEPTION
1966: When OTHERS Then
1967: IF l_debug = FND_API.G_TRUE THEN
1968: QP_PREQ_GRP.engine_debug('Error Insert_rltd_lines'||SQLERRM);

Line 1967: IF l_debug = FND_API.G_TRUE THEN

1963: END IF;
1964: x_return_status := FND_API.G_RET_STS_SUCCESS;
1965: EXCEPTION
1966: When OTHERS Then
1967: IF l_debug = FND_API.G_TRUE THEN
1968: QP_PREQ_GRP.engine_debug('Error Insert_rltd_lines'||SQLERRM);
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: x_return_status_text := 'Error in QP_CLEANUP_ADJUSTMENTS.Insert_Rltd_Lines '||SQLERRM;

Line 1970: x_return_status := FND_API.G_RET_STS_ERROR;

1966: When OTHERS Then
1967: IF l_debug = FND_API.G_TRUE THEN
1968: QP_PREQ_GRP.engine_debug('Error Insert_rltd_lines'||SQLERRM);
1969: END IF;
1970: x_return_status := FND_API.G_RET_STS_ERROR;
1971: x_return_status_text := 'Error in QP_CLEANUP_ADJUSTMENTS.Insert_Rltd_Lines '||SQLERRM;
1972: END Insert_Rltd_Lines;
1973:
1974:

Line 2622: l_curr_line_index number := -1;--fnd_api.g_miss_num;

2618: d Pls_Integer;
2619: g Pls_Integer;
2620: n Pls_Integer;
2621:
2622: l_curr_line_index number := -1;--fnd_api.g_miss_num;
2623: l_auto_line_dtl_index_tbl qp_preq_grp.number_type;
2624: l_auto_override_dtl_id_tbl qp_preq_grp.number_type;
2625:
2626: l_adj_tbl QP_PREQ_PUB.adj_tbl_type;

Line 2698: IF l_debug = FND_API.G_TRUE THEN

2694: BEGIN
2695:
2696: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2697:
2698: IF l_debug = FND_API.G_TRUE THEN
2699: QP_PREQ_GRP.engine_debug('begin fetch adj event'||p_event_code);
2700: QP_PREQ_GRP.engine_debug('begin fetch adj reqtype '||p_request_type_code);
2701: --bug 3085453 handle pricing availability UI
2702: -- they pass reqtype ONT and insert adj into ldets

Line 2745: IF l_debug = FND_API.G_TRUE THEN

2741: G_PBH_PRICE_ADJ_ID.delete;
2742: G_PBH_PLSQL_IND.delete;
2743: G_ORD_LVL_LDET_INDEX.delete; -- 3031108
2744:
2745: IF l_debug = FND_API.G_TRUE THEN
2746: QP_PREQ_GRP.engine_debug('G_MAX_DTL_INDEX '||G_MAX_DTL_INDEX);
2747:
2748: END IF;
2749:

Line 2764: IF (l_debug = FND_API.G_TRUE) THEN

2760: and ldet.line_index = ldet2.line_index
2761: and ldet.created_from_list_line_id =
2762: ldet2.created_from_list_line_id);
2763:
2764: IF (l_debug = FND_API.G_TRUE) THEN
2765: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2766: END IF;
2767:
2768: -- bug 3359924 - AFTER APPLYING MANUAL PBH ENGINE RETURNS DUPLICATE RELATIONSHIP RECORDS

Line 2778: IF (l_debug = FND_API.G_TRUE) THEN

2774: from qp_npreq_ldets_tmp ldet
2775: where ldet.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
2776: and ldet.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_PUB.G_BY_PBH);
2777:
2778: IF (l_debug = FND_API.G_TRUE) THEN
2779: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
2780: END IF;
2781:
2782: -- IF p_event_code IS NULL

Line 2789: IF l_debug = FND_API.G_TRUE THEN

2785:
2786: -- IF p_request_type_code = 'ONT'
2787: -- and p_view_code = 'ONTVIEW'
2788: -- THEN
2789: IF l_debug = FND_API.G_TRUE THEN
2790: -- QP_PREQ_GRP.engine_debug('open ONT cur'||p_request_type_code);
2791: QP_PREQ_GRP.engine_debug('open ONT cur'||QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG);
2792: END IF;
2793:

Line 2869: IF l_debug = FND_API.G_TRUE THEN

2865: g := 0;
2866: l_prev_line_start_index := 0;
2867:
2868:
2869: IF l_debug = FND_API.G_TRUE THEN
2870: QP_PREQ_GRP.engine_debug('fetch cur');
2871: END IF;
2872:
2873:

Line 2931: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE

2927: -- LIMIT nrows;
2928: EXIT WHEN l_list_line_id_tbl.COUNT = 0;
2929:
2930: IF l_list_line_id_tbl.COUNT > 0
2931: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
2932: and l_debug = FND_API.G_TRUE
2933: THEN
2934: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2935: LOOP

Line 2932: and l_debug = FND_API.G_TRUE

2928: EXIT WHEN l_list_line_id_tbl.COUNT = 0;
2929:
2930: IF l_list_line_id_tbl.COUNT > 0
2931: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
2932: and l_debug = FND_API.G_TRUE
2933: THEN
2934: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2935: LOOP
2936: IF l_debug = FND_API.G_TRUE THEN

Line 2936: IF l_debug = FND_API.G_TRUE THEN

2932: and l_debug = FND_API.G_TRUE
2933: THEN
2934: for i in l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2935: LOOP
2936: IF l_debug = FND_API.G_TRUE THEN
2937: QP_PREQ_GRP.engine_debug('list_line_id '||l_list_line_id_tbl(i)||
2938: 'line index '||l_line_index_tbl(i)||' is ldet '||
2939: l_is_ldet_rec_tbl(i)||' linetype '||l_line_type_code_tbl(i) ||
2940: 'line detail type code ' || l_line_detail_type_code_tbl(i)||

Line 2953: IF l_debug = FND_API.G_TRUE THEN

2949: THEN
2950: FOR i IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
2951: LOOP
2952: d := d + 1;
2953: IF l_debug = FND_API.G_TRUE THEN
2954: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
2955: QP_PREQ_GRP.engine_debug('loop cur '||i);
2956:
2957: END IF;

Line 2958: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

2954: QP_PREQ_GRP.engine_debug('adj_tbl count '||d);
2955: QP_PREQ_GRP.engine_debug('loop cur '||i);
2956:
2957: END IF;
2958: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
2959: qp_preq_grp.engine_debug('display details '
2960: ||l_list_line_id_tbl(i)||' line index '||l_line_index_tbl(i)
2961: ||' line detail index '||l_line_dtl_index_tbl(i)
2962: ||' auto '||l_automatic_flag_tbl(i)

Line 3001: IF l_debug = FND_API.G_TRUE THEN

2997: --added to check for duplicate list_line_ids
2998: /*
2999: l_dup_ind := l_line_index_tbl(i) + l_list_line_id_tbl(i);
3000:
3001: IF l_debug = FND_API.G_TRUE THEN
3002: QP_PREQ_GRP.engine_debug('Duplicate list line check '
3003: ||' line_index+list_line_id val: '||l_dup_ind);
3004: END IF;--l_debug
3005:

Line 3007: IF l_debug = FND_API.G_TRUE THEN

3003: ||' line_index+list_line_id val: '||l_dup_ind);
3004: END IF;--l_debug
3005:
3006: IF l_dup_updated_flag.exists(l_dup_ind) THEN
3007: IF l_debug = FND_API.G_TRUE THEN
3008: QP_PREQ_GRP.engine_debug('Duplicate list line exists ');
3009: END IF;--l_debug
3010:
3011: IF l_dup_updated_flag(l_dup_ind) = QP_PREQ_PUB.G_YES

Line 3015: IF l_debug = FND_API.G_TRUE THEN

3011: IF l_dup_updated_flag(l_dup_ind) = QP_PREQ_PUB.G_YES
3012: and l_updated_flag_tbl(i) = QP_PREQ_PUB.G_NO THEN
3013: --in this case the oe_price_adj record must be applied
3014: --so engine selected needs to be marked as deleted
3015: IF l_debug = FND_API.G_TRUE THEN
3016: QP_PREQ_GRP.engine_debug('Duplicate adj overridden ');
3017: END IF;--l_debug
3018: IF l_is_ldet_rec_tbl(i) in (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3019: QP_PREQ_PUB.G_LDET_LINE_TYPE) THEN

Line 3020: IF l_debug = FND_API.G_TRUE THEN

3016: QP_PREQ_GRP.engine_debug('Duplicate adj overridden ');
3017: END IF;--l_debug
3018: IF l_is_ldet_rec_tbl(i) in (QP_PREQ_PUB.G_LDET_ORDER_TYPE,
3019: QP_PREQ_PUB.G_LDET_LINE_TYPE) THEN
3020: IF l_debug = FND_API.G_TRUE THEN
3021: QP_PREQ_GRP.engine_debug('Marking non-overrdn adj '
3022: ||'as deleted ');
3023: END IF;--l_debug
3024: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;

Line 3034: IF l_debug = FND_API.G_TRUE THEN

3030: l_adj_tbl(l_dup_plsql_ind(l_dup_ind)).pricing_status_code
3031: := QP_PREQ_PUB.G_STATUS_DELETED;
3032: l_adj_tbl(l_dup_plsql_ind(l_dup_ind)).pricing_status_text
3033: := 'DUPLICATE MODIFIER PICKED UP';
3034: IF l_debug = FND_API.G_TRUE THEN
3035: QP_PREQ_GRP.engine_debug('Marking prev overdn deltd ');
3036: END IF;--l_debug
3037: --replace l_dup values w/current values
3038: l_dup_updated_flag(l_dup_ind) := l_updated_flag_tbl(i);

Line 3044: IF l_debug = FND_API.G_TRUE THEN

3040: l_dup_plsql_ind(l_dup_ind) := d;
3041: ELSE --updated_flag is 'N'
3042: --in this case the engine selected record must be applied
3043: --so adj from oe_price_adj needs to be marked as deleted
3044: IF l_debug = FND_API.G_TRUE THEN
3045: QP_PREQ_GRP.engine_debug('Duplicate adj not overridden ');
3046: QP_PREQ_GRP.engine_debug('Prev adj is_ldet: '
3047: ||l_dup_is_ldet_rec(l_dup_ind));
3048: QP_PREQ_GRP.engine_debug('Current adj is_ldet: '

Line 3061: IF l_debug = FND_API.G_TRUE THEN

3057: --mark the current record as deleted as
3058: --it is from oe_price_adj
3059: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3060: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3061: IF l_debug = FND_API.G_TRUE THEN
3062: QP_PREQ_GRP.engine_debug('Marking curr adj deleted ');
3063: END IF;--l_debug
3064: ELSIF l_is_ldet_rec_tbl(i) in
3065: (QP_PREQ_PUB.G_LDET_ORDER_TYPE,

Line 3078: IF l_debug = FND_API.G_TRUE THEN

3074: --replace l_dup values w/current values
3075: l_dup_updated_flag(l_dup_ind) := l_updated_flag_tbl(i);
3076: l_dup_is_ldet_rec(l_dup_ind) := l_is_ldet_rec_tbl(i);
3077: l_dup_plsql_ind(l_dup_ind) := d;
3078: IF l_debug = FND_API.G_TRUE THEN
3079: QP_PREQ_GRP.engine_debug('Marking prev adj deleted ');
3080: END IF;--l_debug
3081: ELSE--both the records have same is_ldet so delete one
3082: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;

Line 3084: IF l_debug = FND_API.G_TRUE THEN

3080: END IF;--l_debug
3081: ELSE--both the records have same is_ldet so delete one
3082: l_status_code_tbl(i) := QP_PREQ_PUB.G_STATUS_DELETED;
3083: l_status_text_tbl(i) := 'DUPLICATE MODIFIER PICKED UP';
3084: IF l_debug = FND_API.G_TRUE THEN
3085: QP_PREQ_GRP.engine_debug('Marking else curr adj deltd');
3086: END IF;--l_debug
3087: END IF;--l_is_ldet_rec_tbl(i)
3088: END IF;--l_dup_updated_flag

Line 3116: IF l_debug = FND_API.G_TRUE THEN

3112: --for bug2897524 retain line_quantity for zerounitprice
3113: IF (l_adj_tbl(d).priced_quantity = 0
3114: and l_adj_tbl(d).unit_price <> 0)
3115: THEN
3116: IF l_debug = FND_API.G_TRUE THEN
3117: QP_PREQ_GRP.engine_debug('ldet.line_qty is zero');
3118: END IF;
3119: l_adj_tbl(d).priced_quantity := null;
3120: ELSE

Line 3121: IF l_debug = FND_API.G_TRUE THEN

3117: QP_PREQ_GRP.engine_debug('ldet.line_qty is zero');
3118: END IF;
3119: l_adj_tbl(d).priced_quantity := null;
3120: ELSE
3121: IF l_debug = FND_API.G_TRUE THEN
3122: QP_PREQ_GRP.engine_debug('ldet.line_qty not zero');
3123: END IF;
3124: END IF;
3125: l_adj_tbl(d).line_priced_quantity := l_line_priced_qty_tbl(i);

Line 3175: IF l_debug = FND_API.G_TRUE THEN

3171:
3172: IF l_curr_line_index <> l_line_index_tbl(i)
3173: THEN
3174: l_prev_line_start_index := i;
3175: IF l_debug = FND_API.G_TRUE THEN
3176: qp_preq_grp.engine_debug('auto_overr: new line');
3177: END IF; --Bug No 4033618
3178: l_curr_line_index := l_line_index_tbl(i);
3179: x := 0;

Line 3215: IF l_debug = FND_API.G_TRUE THEN

3211: l_auto_line_dtl_index_tbl(x) := l_line_dtl_index_tbl(i);
3212: l_auto_override_dtl_id_tbl(x) := l_list_line_id_tbl(i);
3213: -- l_adj_tbl(d).pricing_status_code :=
3214: -- QP_PREQ_PUB.G_STATUS_UPDATED;
3215: IF l_debug = FND_API.G_TRUE THEN
3216: qp_preq_grp.engine_debug('auto_overr: from adj tbl '
3217: ||l_line_dtl_index_tbl(i)||' adj id '
3218: ||l_list_line_id_tbl(i));
3219: END IF; --Bug No 4033618

Line 3238: IF l_debug = FND_API.G_TRUE THEN

3234: and nvl(l_applied_flag_tbl(i),QP_PREQ_PUB.G_NO) =
3235: QP_PREQ_PUB.G_NO))
3236: */
3237: THEN
3238: IF l_debug = FND_API.G_TRUE THEN
3239: qp_preq_grp.engine_debug('auto_overr: from ldet tbl '
3240: ||l_adj_tbl(d).created_from_list_line_id
3241: ||' adj index '||l_adj_tbl(d).line_detail_index);
3242: END IF; --Bug No 4033618

Line 3247: IF l_debug = FND_API.G_TRUE THEN

3243: m := l_auto_line_dtl_index_tbl.FIRST;
3244: WHILE (m IS NOT NULL
3245: and l_auto_line_dtl_index_tbl.COUNT > 0)
3246: LOOP
3247: IF l_debug = FND_API.G_TRUE THEN
3248: qp_preq_grp.engine_debug('auto_overr: from auto_ov tbl '
3249: ||m||' adj id '||l_auto_override_dtl_id_tbl(m)
3250: ||' dtl index '||l_auto_line_dtl_index_tbl(m));
3251: END IF; --Bug No 4033618

Line 3255: IF l_debug = FND_API.G_TRUE THEN

3251: END IF; --Bug No 4033618
3252: IF l_list_line_id_tbl(i) =
3253: l_auto_override_dtl_id_tbl(m)
3254: THEN
3255: IF l_debug = FND_API.G_TRUE THEN
3256: QP_PREQ_GRP.engine_debug('duplicate hit'
3257: ||' '||l_list_line_id_tbl(i));
3258: END IF;
3259: l_adj_tbl(d).pricing_status_code :=

Line 3286: IF l_debug = FND_API.G_TRUE THEN

3282: When OTHERS Then
3283: QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id) := null;
3284: END;
3285:
3286: IF l_debug = FND_API.G_TRUE THEN
3287: QP_PREQ_GRP.engine_debug(' PBH vol attr for list_line_id '
3288: ||l_adj_tbl(d).created_from_list_line_id||' attr '
3289: ||QP_PREQ_PUB.G_pbhvolattr_attribute(l_adj_tbl(d).created_from_list_line_id));
3290: END IF;--l_debug

Line 3337: IF l_debug = FND_API.G_TRUE THEN

3333: l_line_dtl_index_tbl(i);
3334: G_PBH_PLSQL_IND(l_line_dtl_index_tbl(i)) :=
3335: G_PBH_LINE_INDEX.COUNT;
3336: END IF;--l_adj_tbl(d).created_from_list_line_type
3337: IF l_debug = FND_API.G_TRUE THEN
3338: QP_PREQ_GRP.engine_debug('figuring out line_dtl_index '
3339: ||l_adj_tbl(d).line_detail_index);
3340: END IF;--l_debug
3341: END IF;--nvl(l_adj_tbl(d).is_ldet_rec

Line 3345: IF l_debug = FND_API.G_TRUE THEN

3341: END IF;--nvl(l_adj_tbl(d).is_ldet_rec
3342:
3343:
3344:
3345: IF l_debug = FND_API.G_TRUE THEN
3346: QP_PREQ_GRP.engine_debug('load tbl'||l_adj_tbl(d).line_detail_index
3347: ||' list_line_id '||l_adj_tbl(d).created_from_list_line_id
3348: ||' list_hdr_id '||l_adj_tbl(d).created_from_list_header_id
3349: ||' line dtl index '||l_adj_tbl(d).line_detail_index

Line 3361: IF l_debug = FND_API.G_TRUE THEN

3357:
3358: /*
3359: i := l_adj_tbl.NEXT(l_prev_line_start_index-1);
3360: g := 0;
3361: IF l_debug = FND_API.G_TRUE THEN
3362: QP_PREQ_GRP.engine_debug('last line starts at '||l_prev_line_start_index);
3363: END IF;
3364: WHILE i IS NOT NULL
3365: LOOP

Line 3374: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE

3370:
3371: l_adj_tbl.delete(l_prev_line_start_index,l_adj_tbl.COUNT);
3372:
3373: IF l_adj_tbl.COUNT > 0
3374: and QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE
3375: THEN
3376: i := l_adj_tbl.first;
3377: WHILE i IS NOT NULL
3378: LOOP

Line 3379: IF l_debug = FND_API.G_TRUE THEN

3375: THEN
3376: i := l_adj_tbl.first;
3377: WHILE i IS NOT NULL
3378: LOOP
3379: IF l_debug = FND_API.G_TRUE THEN
3380: QP_PREQ_GRP.engine_debug('list_line_id '||l_adj_tbl(i).line_detail_index);--||
3381: END IF;
3382: i := l_adj_tbl.next(i);
3383: END LOOP;

Line 3389: IF l_debug = FND_API.G_TRUE THEN

3385: */
3386: n:=G_PBH_LINE_DTL_INDEX.FIRST;
3387: WHILE n IS NOT NULL
3388: LOOP
3389: IF l_debug = FND_API.G_TRUE THEN
3390: QP_PREQ_GRP.engine_debug('G_PBH_LINE_DTL_INDEX loop '
3391: ||' lineindex '||G_PBH_LINE_INDEX(n)
3392: ||' price_adj_id '||G_PBH_PRICE_ADJ_ID(n)
3393: ||' linedtlind '||G_PBH_LINE_DTL_INDEX(n));

Line 3415: IF x_return_status = FND_API.G_RET_STS_ERROR

3411: QP_PREQ_PUB.Update_passed_in_pbh(x_return_status, x_return_status_text);
3412: */
3413: END IF;--p_request_type_code
3414:
3415: IF x_return_status = FND_API.G_RET_STS_ERROR
3416: THEN
3417: Raise Pricing_Exception;
3418: END IF;
3419:

Line 3430: IF x_return_status = FND_API.G_RET_STS_ERROR

3426: ,p_event_code => p_event_code
3427: ,p_adj_tbl => l_adj_tbl
3428: ,x_return_status => x_return_status
3429: ,x_return_status_text => x_return_status_text);
3430: IF x_return_status = FND_API.G_RET_STS_ERROR
3431: THEN
3432: Raise Pricing_Exception;
3433: END IF;
3434: END IF;

Line 3443: IF l_debug = FND_API.G_TRUE THEN

3439: -- IF p_request_type_code = 'ONT'
3440: -- and p_view_name = 'ONTVIEW'
3441: -- THEN
3442: CLOSE l_calculate_cur;
3443: IF l_debug = FND_API.G_TRUE THEN
3444: QP_PREQ_GRP.engine_debug('close cur');
3445: END IF;
3446: -- END IF;
3447:

Line 3452: IF l_debug = FND_API.G_TRUE THEN

3448: --commenting to do the delete at all times
3449: -- IF p_event_code = ','
3450: -- and p_calculate_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
3451: -- THEN
3452: IF l_debug = FND_API.G_TRUE THEN
3453: QP_PREQ_GRP.engine_debug('deleting related lines');
3454: END IF;
3455: delete from qp_npreq_rltd_lines_tmp
3456: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW

Line 3459: IF l_debug = FND_API.G_TRUE THEN

3455: delete from qp_npreq_rltd_lines_tmp
3456: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3457: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
3458: and pricing_status_text = G_CALC_INSERT;
3459: IF l_debug = FND_API.G_TRUE THEN
3460: QP_PREQ_GRP.engine_debug('deleted related lines '||SQL%ROWCOUNT);
3461: END IF;
3462: -- END IF;
3463:

Line 3483: IF (l_debug = FND_API.G_TRUE) THEN

3479: and ldet.line_index = ldet2.line_index
3480: and ldet.created_from_list_line_id =
3481: ldet2.created_from_list_line_id);
3482:
3483: IF (l_debug = FND_API.G_TRUE) THEN
3484: QP_PREQ_GRP.engine_debug('DUPLICATE MANUAL-OVERR '||SQL%ROWCOUNT);
3485: END IF;
3486:
3487: -- 4528043, mark any newly picked-up manual modifiers as 'deleted'

Line 3501: IF (l_debug = FND_API.G_TRUE) THEN

3497: AND automatic_flag = QP_PREQ_PUB.G_NO
3498: AND applied_flag = QP_PREQ_PUB.G_NO
3499: and updated_flag = QP_PREQ_PUB.G_NO; -- 5413797
3500:
3501: IF (l_debug = FND_API.G_TRUE) THEN
3502: QP_PREQ_GRP.engine_debug(SQL%ROWCOUNT||' new manual modifier(s) marked as DELETED');
3503: END IF;
3504: END IF;
3505:

Line 3511: IF x_return_status = FND_API.G_RET_STS_ERROR

3507: --the adjustments have changed
3508: QP_PREQ_PUB.Update_Line_Status(x_return_status,x_return_status_text);
3509:
3510:
3511: IF x_return_status = FND_API.G_RET_STS_ERROR
3512: THEN
3513: Raise Pricing_Exception;
3514: END IF;
3515:

Line 3524: IF l_debug = FND_API.G_TRUE THEN

3520: --if the line does not qualify for the only discount anymore, this
3521: --update needs to be done
3522: -- IF p_calculate_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
3523: -- THEN
3524: IF l_debug = FND_API.G_TRUE THEN
3525: QP_PREQ_GRP.engine_debug('calculate_only call check to see'
3526: ||' if there are adjustments');
3527: END IF;
3528: QP_PREQ_PUB.update_unit_price(x_return_status,

Line 3531: IF x_return_status = FND_API.G_RET_STS_ERROR

3527: END IF;
3528: QP_PREQ_PUB.update_unit_price(x_return_status,
3529: x_return_status_text);
3530:
3531: IF x_return_status = FND_API.G_RET_STS_ERROR
3532: THEN
3533: Raise Pricing_Exception;
3534: END IF;
3535: -- END IF;--p_calculate_flag

Line 3545: IF x_return_status = FND_API.G_RET_STS_ERROR

3541: p_request_type_code,
3542: l_cleanup_flag,
3543: x_return_status,
3544: x_return_status_text);
3545: IF x_return_status = FND_API.G_RET_STS_ERROR
3546: THEN
3547: Raise Pricing_Exception;
3548: END IF;
3549: END IF;--l_cleanup_flag

Line 3558: IF x_return_status = FND_API.G_RET_STS_ERROR

3554: -- they pass reqtype ONT and insert adj into ldets
3555: IF QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES THEN
3556: Populate_Price_Adj_ID(x_return_status,x_return_status_text);
3557:
3558: IF x_return_status = FND_API.G_RET_STS_ERROR
3559: THEN
3560: Raise Pricing_Exception;
3561: END IF;
3562: END IF;--QP_PREQ_PUB.G_REQUEST_TYPE_CODE

Line 3570: IF x_return_status = FND_API.G_RET_STS_ERROR

3566: THEN
3567: QP_PREQ_PUB.check_gsa_violation(
3568: x_return_status => x_return_status,
3569: x_return_status_text => x_return_status_text);
3570: IF x_return_status = FND_API.G_RET_STS_ERROR
3571: THEN
3572: Raise Pricing_Exception;
3573: END IF;
3574: END IF;--GSA_INDICATOR

Line 3578: IF l_debug = FND_API.G_TRUE THEN

3574: END IF;--GSA_INDICATOR
3575:
3576:
3577:
3578: IF l_debug = FND_API.G_TRUE THEN
3579: QP_PREQ_GRP.engine_debug('end fetch adjustments');
3580:
3581:
3582: END IF;

Line 3585: x_return_status := FND_API.G_RET_STS_ERROR;

3581:
3582: END IF;
3583: EXCEPTION
3584: When PRICING_EXCEPTION Then
3585: x_return_status := FND_API.G_RET_STS_ERROR;
3586: IF l_debug = FND_API.G_TRUE THEN
3587: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3588: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3589: END IF;

Line 3586: IF l_debug = FND_API.G_TRUE THEN

3582: END IF;
3583: EXCEPTION
3584: When PRICING_EXCEPTION Then
3585: x_return_status := FND_API.G_RET_STS_ERROR;
3586: IF l_debug = FND_API.G_TRUE THEN
3587: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3588: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3589: END IF;
3590: When OTHERS Then

Line 3591: x_return_status := FND_API.G_RET_STS_ERROR;

3587: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3588: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||x_return_status_text);
3589: END IF;
3590: When OTHERS Then
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: x_return_status_text := 'Error in fetch_adjustments: '||SQLERRM;
3593: IF l_debug = FND_API.G_TRUE THEN
3594: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3595: END IF;

Line 3593: IF l_debug = FND_API.G_TRUE THEN

3589: END IF;
3590: When OTHERS Then
3591: x_return_status := FND_API.G_RET_STS_ERROR;
3592: x_return_status_text := 'Error in fetch_adjustments: '||SQLERRM;
3593: IF l_debug = FND_API.G_TRUE THEN
3594: QP_PREQ_GRP.engine_debug('error in fetch_adjustments: '||SQLERRM);
3595: END IF;
3596: END fetch_adjustments;
3597: