213: -- Call QP_Modifiers_PVT.Process_MODIFIERS
214:
215: QP_Modifiers_PVT.Process_MODIFIERS
216: ( p_api_version_number => 1.0
217: , p_init_msg_list => FND_API.G_TRUE
218: , x_return_status => l_return_status
219: , x_msg_count => x_msg_count
220: , x_msg_data => x_msg_data
221: , p_control_rec => l_control_rec
225: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
226: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
227: );
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
226: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
227: );
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
227: );
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235:
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235:
236: -- Unload out tbl
356:
357: -- Write to cache.
358: -- Set db_flag to False before writing to cache
359:
360: l_x_MODIFIERS_rec.db_flag := FND_API.G_FALSE;
361:
362: Write_MODIFIERS
363: ( p_MODIFIERS_rec => l_x_MODIFIERS_rec
364: );
364: );
365:
366: -- Set return status.
367:
368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369:
370: -- Get message count and data
371:
372: OE_MSG_PUB.Count_And_Get
377: oe_debug_pub.add('END Default_Attributes in QPXFMLLB');
378:
379: EXCEPTION
380:
381: WHEN FND_API.G_EXC_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: -- Get message count and data
379: EXCEPTION
380:
381: WHEN FND_API.G_EXC_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: -- Get message count and data
386:
387: OE_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count
389: , p_data => x_msg_data
390: );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395:
396: -- Get message count and data
390: );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395:
396: -- Get message count and data
397:
398: OE_MSG_PUB.Count_And_Get
401: );
402:
403: WHEN OTHERS THEN
404:
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
406:
407: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: OE_MSG_PUB.Add_Exc_Msg
791: , 'Unrecognized attribute'
792: );
793: END IF;
794:
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796:
797: END IF;
798:
799: -- Set Operation.
797: END IF;
798:
799: -- Set Operation.
800:
801: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
802: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
803: ELSE
804: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
805: END IF;
812: -- Call QP_Modifiers_PVT.Process_MODIFIERS
813:
814: QP_Modifiers_PVT.Process_MODIFIERS
815: ( p_api_version_number => 1.0
816: , p_init_msg_list => FND_API.G_TRUE
817: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
818: , x_return_status => l_return_status
819: , x_msg_count => x_msg_count
820: , x_msg_data => x_msg_data
813:
814: QP_Modifiers_PVT.Process_MODIFIERS
815: ( p_api_version_number => 1.0
816: , p_init_msg_list => FND_API.G_TRUE
817: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
818: , x_return_status => l_return_status
819: , x_msg_count => x_msg_count
820: , x_msg_data => x_msg_data
821: , p_control_rec => l_control_rec
826: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
827: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
828: );
829:
830: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
827: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
828: );
829:
830: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835:
828: );
829:
830: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835:
836:
829:
830: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
833: RAISE FND_API.G_EXC_ERROR;
834: END IF;
835:
836:
837: -- Unload out tbl
839: l_x_MODIFIERS_rec := l_x_MODIFIERS_tbl(1);
840:
841: -- Init OUT parameters to missing.
842:
843: x_arithmetic_operator := FND_API.G_MISS_CHAR;
844: x_attribute1 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
840:
841: -- Init OUT parameters to missing.
842:
843: x_arithmetic_operator := FND_API.G_MISS_CHAR;
844: x_attribute1 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
841: -- Init OUT parameters to missing.
842:
843: x_arithmetic_operator := FND_API.G_MISS_CHAR;
844: x_attribute1 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
842:
843: x_arithmetic_operator := FND_API.G_MISS_CHAR;
844: x_attribute1 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
843: x_arithmetic_operator := FND_API.G_MISS_CHAR;
844: x_attribute1 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
844: x_attribute1 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
845: x_attribute10 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
846: x_attribute11 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
847: x_attribute12 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
848: x_attribute13 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
849: x_attribute14 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
850: x_attribute15 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
851: x_attribute2 := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
852: x_attribute3 := FND_API.G_MISS_CHAR;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
853: x_attribute4 := FND_API.G_MISS_CHAR;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
854: x_attribute5 := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
855: x_attribute6 := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
856: x_attribute7 := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
857: x_attribute8 := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
858: x_attribute9 := FND_API.G_MISS_CHAR;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
859: x_automatic_flag := FND_API.G_MISS_CHAR;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
860: -- x_base_qty := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
861: x_pricing_phase_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
862: -- x_base_uom_code := FND_API.G_MISS_CHAR;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
863: x_comments := FND_API.G_MISS_CHAR;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
864: x_context := FND_API.G_MISS_CHAR;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
865: x_effective_period_uom := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
866: x_end_date_active := FND_API.G_MISS_DATE;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
867: x_estim_accrual_rate := FND_API.G_MISS_NUM;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
868: x_generate_using_formula_id := FND_API.G_MISS_NUM;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
869: -- x_gl_class_id := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
870: x_inventory_item_id := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
871: x_list_header_id := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
872: x_list_line_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
873: x_list_line_type_code := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
874: x_list_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
875: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
876: x_modifier_level_code := FND_API.G_MISS_CHAR;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
877: -- x_new_price := FND_API.G_MISS_NUM;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
878: x_number_effective_periods := FND_API.G_MISS_NUM;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
879: x_operand := FND_API.G_MISS_NUM;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
880: x_organization_id := FND_API.G_MISS_NUM;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
881: x_override_flag := FND_API.G_MISS_CHAR;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
882: x_percent_price := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
883: x_price_break_type_code := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
884: x_price_by_formula_id := FND_API.G_MISS_NUM;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
885: x_primary_uom_flag := FND_API.G_MISS_CHAR;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
886: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
887: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
888: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
889: x_related_item_id := FND_API.G_MISS_NUM;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
890: x_relationship_type_id := FND_API.G_MISS_NUM;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
891: x_reprice_flag := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
892: x_revision := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
893: x_revision_date := FND_API.G_MISS_DATE;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
894: x_revision_reason_code := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
895: x_start_date_active := FND_API.G_MISS_DATE;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
896: x_substitution_attribute := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
897: x_substitution_context := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
898: x_substitution_value := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
899: x_automatic := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
900: -- x_base_uom := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
901: x_generate_using_formula := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
902: -- x_gl_class := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
903: x_inventory_item := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
904: x_list_header := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
905: x_list_line := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
906: x_list_line_type := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
907: -- x_list_price_uom := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
908: x_modifier_level := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
909: x_organization := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
910: x_override := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
911: x_price_break_type := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
912: x_price_by_formula := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
913: x_primary_uom := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
914: x_print_on_invoice := FND_API.G_MISS_CHAR;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
915: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
916: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
917: x_related_item := FND_API.G_MISS_CHAR;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
918: x_relationship_type := FND_API.G_MISS_CHAR;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
919: x_reprice := FND_API.G_MISS_CHAR;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
920: x_revision_reason := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
921: x_accrual_flag := FND_API.G_MISS_CHAR;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
922: x_pricing_group_sequence := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
923: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
924: x_list_line_no := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
925: x_product_precedence := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
926: x_expiration_period_start_date := FND_API.G_MISS_DATE;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
927: x_number_expiration_periods := FND_API.G_MISS_NUM;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
928: x_expiration_period_uom := FND_API.G_MISS_CHAR;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
929: x_expiration_date := FND_API.G_MISS_DATE;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
930: x_estim_gl_value := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
931: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
932: -- x_recurring_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
933: x_benefit_limit := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
934: x_charge_type_code := FND_API.G_MISS_CHAR;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
935: x_charge_subtype_code := FND_API.G_MISS_CHAR;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
936: x_benefit_qty := FND_API.G_MISS_NUM;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
937: x_benefit_uom_code := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
938: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
939: x_proration_type_code := FND_API.G_MISS_CHAR;
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
940: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
948: x_service_duration := FND_API.G_MISS_NUM; -- service project
941: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
948: x_service_duration := FND_API.G_MISS_NUM; -- service project
949: x_service_period := FND_API.G_MISS_CHAR; -- service project
942: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
948: x_service_duration := FND_API.G_MISS_NUM; -- service project
949: x_service_period := FND_API.G_MISS_CHAR; -- service project
950:
943: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
948: x_service_duration := FND_API.G_MISS_NUM; -- service project
949: x_service_period := FND_API.G_MISS_CHAR; -- service project
950:
951:
944: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
948: x_service_duration := FND_API.G_MISS_NUM; -- service project
949: x_service_period := FND_API.G_MISS_CHAR; -- service project
950:
951:
952: -- Load display out parameters if any
945: x_net_amount_flag := FND_API.G_MISS_CHAR;
946: x_accum_attribute := FND_API.G_MISS_CHAR;
947: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
948: x_service_duration := FND_API.G_MISS_NUM; -- service project
949: x_service_period := FND_API.G_MISS_CHAR; -- service project
950:
951:
952: -- Load display out parameters if any
953:
1507: );
1508:
1509: -- Set return status.
1510:
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: -- Get message count and data
1514:
1515: OE_MSG_PUB.Count_And_Get
1520: oe_debug_pub.add('END Change_attribute in QPXFMLLB');
1521:
1522: EXCEPTION
1523:
1524: WHEN FND_API.G_EXC_ERROR THEN
1525:
1526: x_return_status := FND_API.G_RET_STS_ERROR;
1527:
1528: -- Get message count and data
1522: EXCEPTION
1523:
1524: WHEN FND_API.G_EXC_ERROR THEN
1525:
1526: x_return_status := FND_API.G_RET_STS_ERROR;
1527:
1528: -- Get message count and data
1529:
1530: OE_MSG_PUB.Count_And_Get
1531: ( p_count => x_msg_count
1532: , p_data => x_msg_data
1533: );
1534:
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536:
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1538:
1539: -- Get message count and data
1533: );
1534:
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536:
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1538:
1539: -- Get message count and data
1540:
1541: OE_MSG_PUB.Count_And_Get
1544: );
1545:
1546: WHEN OTHERS THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549:
1550: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1551: THEN
1552: OE_MSG_PUB.Add_Exc_Msg
1625: );
1626:
1627: -- Set Operation.
1628:
1629: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
1630: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1631: ELSE
1632: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1633: END IF;
1640: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1641:
1642: QP_Modifiers_PVT.Process_MODIFIERS
1643: ( p_api_version_number => 1.0
1644: , p_init_msg_list => FND_API.G_TRUE
1645: , x_return_status => l_return_status
1646: , x_msg_count => x_msg_count
1647: , x_msg_data => x_msg_data
1648: , p_control_rec => l_control_rec
1653: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1654: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1655: );
1656:
1657: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1654: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1655: );
1656:
1657: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1662:
1655: );
1656:
1657: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1662:
1663:
1656:
1657: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1659: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1660: RAISE FND_API.G_EXC_ERROR;
1661: END IF;
1662:
1663:
1664: -- Load OUT parameters.
1681:
1682:
1683: -- Set return status.
1684:
1685: x_return_status := FND_API.G_RET_STS_SUCCESS;
1686:
1687: -- Get message count and data
1688:
1689: OE_MSG_PUB.Count_And_Get
1694: oe_debug_pub.add('END Validate_And_Write in QPXFMLLB');
1695:
1696: EXCEPTION
1697:
1698: WHEN FND_API.G_EXC_ERROR THEN
1699:
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701:
1702: -- Get message count and data
1696: EXCEPTION
1697:
1698: WHEN FND_API.G_EXC_ERROR THEN
1699:
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701:
1702: -- Get message count and data
1703:
1704: OE_MSG_PUB.Count_And_Get
1705: ( p_count => x_msg_count
1706: , p_data => x_msg_data
1707: );
1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1710:
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712:
1713: -- Get message count and data
1707: );
1708:
1709: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1710:
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712:
1713: -- Get message count and data
1714:
1715: OE_MSG_PUB.Count_And_Get
1718: );
1719:
1720: WHEN OTHERS THEN
1721:
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1723:
1724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1725: THEN
1726: OE_MSG_PUB.Add_Exc_Msg
1798: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1799:
1800: QP_Modifiers_PVT.Process_MODIFIERS
1801: ( p_api_version_number => 1.0
1802: , p_init_msg_list => FND_API.G_TRUE
1803: , x_return_status => l_return_status
1804: , x_msg_count => x_msg_count
1805: , x_msg_data => x_msg_data
1806: , p_control_rec => l_control_rec
1810: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1811: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1812: );
1813:
1814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1811: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1812: );
1813:
1814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819:
1812: );
1813:
1814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819:
1820:
1813:
1814: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819:
1820:
1821: -- Clear MODIFIERS record cache
1823: Clear_MODIFIERS;
1824:
1825: -- Set return status.
1826:
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828:
1829: -- Get message count and data
1830:
1831: OE_MSG_PUB.Count_And_Get
1836: oe_debug_pub.add('END Delete_Row in QPXFMLLB');
1837:
1838: EXCEPTION
1839:
1840: WHEN FND_API.G_EXC_ERROR THEN
1841:
1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843:
1844: -- Get message count and data
1838: EXCEPTION
1839:
1840: WHEN FND_API.G_EXC_ERROR THEN
1841:
1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843:
1844: -- Get message count and data
1845:
1846: OE_MSG_PUB.Count_And_Get
1847: ( p_count => x_msg_count
1848: , p_data => x_msg_data
1849: );
1850:
1851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1852:
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1854:
1855: -- Get message count and data
1849: );
1850:
1851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1852:
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1854:
1855: -- Get message count and data
1856:
1857: OE_MSG_PUB.Count_And_Get
1860: );
1861:
1862: WHEN OTHERS THEN
1863:
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865:
1866: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1867: THEN
1868: OE_MSG_PUB.Add_Exc_Msg
1921: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1922:
1923: QP_Modifiers_PVT.Process_MODIFIERS
1924: ( p_api_version_number => 1.0
1925: , p_init_msg_list => FND_API.G_TRUE
1926: , x_return_status => l_return_status
1927: , x_msg_count => x_msg_count
1928: , x_msg_data => x_msg_data
1929: , p_control_rec => l_control_rec
1932: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1933: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1934: );
1935:
1936: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1938: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1933: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1934: );
1935:
1936: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1938: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1941:
1934: );
1935:
1936: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1938: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1941:
1942:
1935:
1936: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1938: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1939: RAISE FND_API.G_EXC_ERROR;
1940: END IF;
1941:
1942:
1943: -- Set return status.
1941:
1942:
1943: -- Set return status.
1944:
1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946:
1947: -- Get message count and data
1948:
1949: OE_MSG_PUB.Count_And_Get
1954: oe_debug_pub.add('END Process_Entity in QPXFMLLB');
1955:
1956: EXCEPTION
1957:
1958: WHEN FND_API.G_EXC_ERROR THEN
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: -- Get message count and data
1956: EXCEPTION
1957:
1958: WHEN FND_API.G_EXC_ERROR THEN
1959:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: -- Get message count and data
1963:
1964: OE_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count
1966: , p_data => x_msg_data
1967: );
1968:
1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1970:
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1972:
1973: -- Get message count and data
1967: );
1968:
1969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1970:
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1972:
1973: -- Get message count and data
1974:
1975: OE_MSG_PUB.Count_And_Get
1978: );
1979:
1980: WHEN OTHERS THEN
1981:
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1983:
1984: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985: THEN
1986: OE_MSG_PUB.Add_Exc_Msg
2223: -- Call QP_Modifiers_PVT.Lock_MODIFIERS
2224:
2225: QP_Modifiers_PVT.Lock_MODIFIERS
2226: ( p_api_version_number => 1.0
2227: , p_init_msg_list => FND_API.G_TRUE
2228: , x_return_status => l_return_status
2229: , x_msg_count => x_msg_count
2230: , x_msg_data => x_msg_data
2231: , p_MODIFIERS_tbl => l_MODIFIERS_tbl
2234: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
2235: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
2236: );
2237:
2238: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2239:
2240: -- Set DB flag and write record to cache.
2241:
2242: l_x_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2238: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2239:
2240: -- Set DB flag and write record to cache.
2241:
2242: l_x_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2243:
2244: Write_MODIFIERS
2245: ( p_MODIFIERS_rec => l_x_MODIFIERS_rec
2246: , p_db_record => TRUE
2272: , 'Lock_Row'
2273: );
2274: END IF;
2275:
2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2277:
2278: -- Get message count and data
2279:
2280: OE_MSG_PUB.Count_And_Get
2326: g_MODIFIERS_rec := QP_Modifiers_Util.Query_Row
2327: ( p_list_line_id => p_list_line_id
2328: );
2329:
2330: g_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2331:
2332: -- Load DB record
2333:
2334: g_db_MODIFIERS_rec := g_MODIFIERS_rec;
2376: IS
2377: l_return_status Varchar2(30);
2378: BEGIN
2379: OE_MSG_PUB.initialize;
2380: x_return_status := FND_API.G_RET_STS_SUCCESS;
2381: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2382: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2383: ,p_entity_id => p_list_line_id
2384: ,x_return_status => l_return_status);
2404: OE_MSG_PUB.Count_And_Get
2405: ( p_count => x_msg_count
2406: , p_data => x_msg_data
2407: );
2408: x_return_status := FND_API.G_RET_STS_ERROR;
2409:
2410: END Clear_Record;
2411:
2412:
2878: l_MODIFIERS_rec.TO_RLTD_MODIFIER_ID := l_new_list_line_id;
2879: l_MODIFIERS_rec.RLTD_MODIFIER_GRP_NO := l_implicit_rec.RLTD_MODIFIER_GRP_NO;
2880: l_MODIFIERS_rec.RLTD_MODIFIER_GRP_TYPE := l_implicit_rec.RLTD_MODIFIER_GRP_TYPE;
2881:
2882: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2883: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2884:
2885: l_MODIFIERS_tbl(l_MODIFIERS_tbl.COUNT + 1) := l_MODIFIERS_rec;
2886: l_number_of_lines := l_number_of_lines + 1;
3044: oe_debug_pub.add('Before calling Process Modifier');
3045:
3046: QP_Modifiers_PVT.Process_MODIFIERS
3047: ( p_api_version_number => 1.0
3048: , p_init_msg_list => FND_API.G_TRUE
3049: , x_return_status => l_return_status
3050: , x_msg_count => x_msg_count
3051: , x_msg_data => x_msg_data
3052: , p_control_rec => l_control_rec
3088:
3089: END IF;
3090:
3091: oe_debug_pub.add('After calling Process Modifier');
3092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;
3096: END IF;
3089: END IF;
3090:
3091: oe_debug_pub.add('After calling Process Modifier');
3092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;
3096: END IF;
3097: oe_debug_pub.add('Outside Duplicate Record');
3090:
3091: oe_debug_pub.add('After calling Process Modifier');
3092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;
3096: END IF;
3097: oe_debug_pub.add('Outside Duplicate Record');
3098: END IF;
3091: oe_debug_pub.add('After calling Process Modifier');
3092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3095: RAISE FND_API.G_EXC_ERROR;
3096: END IF;
3097: oe_debug_pub.add('Outside Duplicate Record');
3098: END IF;
3099: EXCEPTION
3097: oe_debug_pub.add('Outside Duplicate Record');
3098: END IF;
3099: EXCEPTION
3100:
3101: WHEN FND_API.G_EXC_ERROR THEN
3102:
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104:
3105: -- Get message count and data
3099: EXCEPTION
3100:
3101: WHEN FND_API.G_EXC_ERROR THEN
3102:
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104:
3105: -- Get message count and data
3106:
3107: oe_msg_pub.Count_And_Get
3108: ( p_count => x_msg_count
3109: , p_data => x_msg_data
3110: );
3111:
3112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3113:
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115:
3116: -- Get message count and data
3110: );
3111:
3112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3113:
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115:
3116: -- Get message count and data
3117:
3118: oe_msg_pub.Count_And_Get
3121: );
3122:
3123: WHEN OTHERS THEN
3124:
3125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3126:
3127: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3128: THEN
3129: oe_msg_pub.Add_Exc_Msg