211: -- Call QP_Modifiers_PVT.Process_MODIFIERS
212:
213: QP_Modifiers_PVT.Process_MODIFIERS
214: ( p_api_version_number => 1.0
215: , p_init_msg_list => FND_API.G_TRUE
216: , x_return_status => l_return_status
217: , x_msg_count => x_msg_count
218: , x_msg_data => x_msg_data
219: , p_control_rec => l_control_rec
223: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
224: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
225: );
226:
227: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
224: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
225: );
226:
227: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
225: );
226:
227: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233:
226:
227: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233:
234: -- Unload out tbl
351:
352: -- Write to cache.
353: -- Set db_flag to False before writing to cache
354:
355: l_x_MODIFIERS_rec.db_flag := FND_API.G_FALSE;
356:
357: Write_MODIFIERS
358: ( p_MODIFIERS_rec => l_x_MODIFIERS_rec
359: );
359: );
360:
361: -- Set return status.
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: -- Get message count and data
366:
367: OE_MSG_PUB.Count_And_Get
372: oe_debug_pub.add('END Default_Attributes in QPXFMLLB');
373:
374: EXCEPTION
375:
376: WHEN FND_API.G_EXC_ERROR THEN
377:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379:
380: -- Get message count and data
374: EXCEPTION
375:
376: WHEN FND_API.G_EXC_ERROR THEN
377:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379:
380: -- Get message count and data
381:
382: OE_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count
384: , p_data => x_msg_data
385: );
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390:
391: -- Get message count and data
385: );
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390:
391: -- Get message count and data
392:
393: OE_MSG_PUB.Count_And_Get
396: );
397:
398: WHEN OTHERS THEN
399:
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: OE_MSG_PUB.Add_Exc_Msg
777: , 'Unrecognized attribute'
778: );
779: END IF;
780:
781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
782:
783: END IF;
784:
785: -- Set Operation.
783: END IF;
784:
785: -- Set Operation.
786:
787: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
788: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
789: ELSE
790: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
791: END IF;
798: -- Call QP_Modifiers_PVT.Process_MODIFIERS
799:
800: QP_Modifiers_PVT.Process_MODIFIERS
801: ( p_api_version_number => 1.0
802: , p_init_msg_list => FND_API.G_TRUE
803: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
804: , x_return_status => l_return_status
805: , x_msg_count => x_msg_count
806: , x_msg_data => x_msg_data
799:
800: QP_Modifiers_PVT.Process_MODIFIERS
801: ( p_api_version_number => 1.0
802: , p_init_msg_list => FND_API.G_TRUE
803: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
804: , x_return_status => l_return_status
805: , x_msg_count => x_msg_count
806: , x_msg_data => x_msg_data
807: , p_control_rec => l_control_rec
812: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
813: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
814: );
815:
816: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
813: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
814: );
815:
816: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:
814: );
815:
816: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:
822:
815:
816: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
819: RAISE FND_API.G_EXC_ERROR;
820: END IF;
821:
822:
823: -- Unload out tbl
825: l_x_MODIFIERS_rec := l_x_MODIFIERS_tbl(1);
826:
827: -- Init OUT parameters to missing.
828:
829: x_arithmetic_operator := FND_API.G_MISS_CHAR;
830: x_attribute1 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
826:
827: -- Init OUT parameters to missing.
828:
829: x_arithmetic_operator := FND_API.G_MISS_CHAR;
830: x_attribute1 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
827: -- Init OUT parameters to missing.
828:
829: x_arithmetic_operator := FND_API.G_MISS_CHAR;
830: x_attribute1 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
828:
829: x_arithmetic_operator := FND_API.G_MISS_CHAR;
830: x_attribute1 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
829: x_arithmetic_operator := FND_API.G_MISS_CHAR;
830: x_attribute1 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
830: x_attribute1 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
831: x_attribute10 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
832: x_attribute11 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
833: x_attribute12 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
834: x_attribute13 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
835: x_attribute14 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
836: x_attribute15 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
837: x_attribute2 := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
838: x_attribute3 := FND_API.G_MISS_CHAR;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
839: x_attribute4 := FND_API.G_MISS_CHAR;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
840: x_attribute5 := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
841: x_attribute6 := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
842: x_attribute7 := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
843: x_attribute8 := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
844: x_attribute9 := FND_API.G_MISS_CHAR;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
845: x_automatic_flag := FND_API.G_MISS_CHAR;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
846: -- x_base_qty := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
847: x_pricing_phase_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
848: -- x_base_uom_code := FND_API.G_MISS_CHAR;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
849: x_comments := FND_API.G_MISS_CHAR;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
850: x_context := FND_API.G_MISS_CHAR;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
851: x_effective_period_uom := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
852: x_end_date_active := FND_API.G_MISS_DATE;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
853: x_estim_accrual_rate := FND_API.G_MISS_NUM;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
854: x_generate_using_formula_id := FND_API.G_MISS_NUM;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
855: -- x_gl_class_id := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
856: x_inventory_item_id := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
857: x_list_header_id := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
858: x_list_line_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
859: x_list_line_type_code := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
860: x_list_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
861: -- x_list_price_uom_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
862: x_modifier_level_code := FND_API.G_MISS_CHAR;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
863: -- x_new_price := FND_API.G_MISS_NUM;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
864: x_number_effective_periods := FND_API.G_MISS_NUM;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
865: x_operand := FND_API.G_MISS_NUM;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
866: x_organization_id := FND_API.G_MISS_NUM;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
867: x_override_flag := FND_API.G_MISS_CHAR;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
868: x_percent_price := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
869: x_price_break_type_code := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
870: x_price_by_formula_id := FND_API.G_MISS_NUM;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
871: x_primary_uom_flag := FND_API.G_MISS_CHAR;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
872: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
873: -- x_rebate_subtype_code := FND_API.G_MISS_CHAR;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
874: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
875: x_related_item_id := FND_API.G_MISS_NUM;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
876: x_relationship_type_id := FND_API.G_MISS_NUM;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
877: x_reprice_flag := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
878: x_revision := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
879: x_revision_date := FND_API.G_MISS_DATE;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
880: x_revision_reason_code := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
881: x_start_date_active := FND_API.G_MISS_DATE;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
882: x_substitution_attribute := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
883: x_substitution_context := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
884: x_substitution_value := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
885: x_automatic := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
886: -- x_base_uom := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
887: x_generate_using_formula := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
888: -- x_gl_class := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
889: x_inventory_item := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
890: x_list_header := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
891: x_list_line := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
892: x_list_line_type := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
893: -- x_list_price_uom := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
894: x_modifier_level := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
895: x_organization := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
896: x_override := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
897: x_price_break_type := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
898: x_price_by_formula := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
899: x_primary_uom := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
900: x_print_on_invoice := FND_API.G_MISS_CHAR;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
901: -- x_rebate_subtype := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
902: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
903: x_related_item := FND_API.G_MISS_CHAR;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
904: x_relationship_type := FND_API.G_MISS_CHAR;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
905: x_reprice := FND_API.G_MISS_CHAR;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
906: x_revision_reason := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
907: x_accrual_flag := FND_API.G_MISS_CHAR;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
908: x_pricing_group_sequence := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
909: x_incompatibility_grp_code := FND_API.G_MISS_CHAR;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
910: x_list_line_no := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
911: x_product_precedence := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
912: x_expiration_period_start_date := FND_API.G_MISS_DATE;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
913: x_number_expiration_periods := FND_API.G_MISS_NUM;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
914: x_expiration_period_uom := FND_API.G_MISS_CHAR;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
915: x_expiration_date := FND_API.G_MISS_DATE;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
916: x_estim_gl_value := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
917: x_benefit_price_list_line_id := FND_API.G_MISS_NUM;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
918: -- x_recurring_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
919: x_benefit_limit := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
920: x_charge_type_code := FND_API.G_MISS_CHAR;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
921: x_charge_subtype_code := FND_API.G_MISS_CHAR;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
922: x_benefit_qty := FND_API.G_MISS_NUM;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
923: x_benefit_uom_code := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
924: x_accrual_conversion_rate := FND_API.G_MISS_NUM;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
932: x_accum_attribute := FND_API.G_MISS_CHAR;
925: x_proration_type_code := FND_API.G_MISS_CHAR;
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
932: x_accum_attribute := FND_API.G_MISS_CHAR;
933: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
926: x_include_on_returns_flag := FND_API.G_MISS_CHAR;
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
932: x_accum_attribute := FND_API.G_MISS_CHAR;
933: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
934:
927: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
932: x_accum_attribute := FND_API.G_MISS_CHAR;
933: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
934:
935: -- Load display out parameters if any
928: x_to_rltd_modifier_id := FND_API.G_MISS_NUM;
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
932: x_accum_attribute := FND_API.G_MISS_CHAR;
933: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
934:
935: -- Load display out parameters if any
936:
929: x_rltd_modifier_grp_no := FND_API.G_MISS_NUM;
930: x_rltd_modifier_grp_type := FND_API.G_MISS_CHAR;
931: x_net_amount_flag := FND_API.G_MISS_CHAR;
932: x_accum_attribute := FND_API.G_MISS_CHAR;
933: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
934:
935: -- Load display out parameters if any
936:
937: l_MODIFIERS_val_rec := QP_Modifiers_Util.Get_Values
1476: );
1477:
1478: -- Set return status.
1479:
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: -- Get message count and data
1483:
1484: OE_MSG_PUB.Count_And_Get
1489: oe_debug_pub.add('END Change_attribute in QPXFMLLB');
1490:
1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494:
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496:
1497: -- Get message count and data
1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494:
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496:
1497: -- Get message count and data
1498:
1499: OE_MSG_PUB.Count_And_Get
1500: ( p_count => x_msg_count
1501: , p_data => x_msg_data
1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1507:
1508: -- Get message count and data
1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1507:
1508: -- Get message count and data
1509:
1510: OE_MSG_PUB.Count_And_Get
1513: );
1514:
1515: WHEN OTHERS THEN
1516:
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1518:
1519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: OE_MSG_PUB.Add_Exc_Msg
1594: );
1595:
1596: -- Set Operation.
1597:
1598: IF FND_API.To_Boolean(l_MODIFIERS_rec.db_flag) THEN
1599: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1600: ELSE
1601: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1602: END IF;
1609: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1610:
1611: QP_Modifiers_PVT.Process_MODIFIERS
1612: ( p_api_version_number => 1.0
1613: , p_init_msg_list => FND_API.G_TRUE
1614: , x_return_status => l_return_status
1615: , x_msg_count => x_msg_count
1616: , x_msg_data => x_msg_data
1617: , p_control_rec => l_control_rec
1622: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1623: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1624: );
1625:
1626: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1623: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1624: );
1625:
1626: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631:
1624: );
1625:
1626: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631:
1632:
1625:
1626: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1628: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1629: RAISE FND_API.G_EXC_ERROR;
1630: END IF;
1631:
1632:
1633: -- Load OUT parameters.
1650:
1651:
1652: -- Set return status.
1653:
1654: x_return_status := FND_API.G_RET_STS_SUCCESS;
1655:
1656: -- Get message count and data
1657:
1658: OE_MSG_PUB.Count_And_Get
1663: oe_debug_pub.add('END Validate_And_Write in QPXFMLLB');
1664:
1665: EXCEPTION
1666:
1667: WHEN FND_API.G_EXC_ERROR THEN
1668:
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: -- Get message count and data
1665: EXCEPTION
1666:
1667: WHEN FND_API.G_EXC_ERROR THEN
1668:
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: -- Get message count and data
1672:
1673: OE_MSG_PUB.Count_And_Get
1674: ( p_count => x_msg_count
1675: , p_data => x_msg_data
1676: );
1677:
1678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1679:
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681:
1682: -- Get message count and data
1676: );
1677:
1678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1679:
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681:
1682: -- Get message count and data
1683:
1684: OE_MSG_PUB.Count_And_Get
1687: );
1688:
1689: WHEN OTHERS THEN
1690:
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1692:
1693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1694: THEN
1695: OE_MSG_PUB.Add_Exc_Msg
1767: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1768:
1769: QP_Modifiers_PVT.Process_MODIFIERS
1770: ( p_api_version_number => 1.0
1771: , p_init_msg_list => FND_API.G_TRUE
1772: , x_return_status => l_return_status
1773: , x_msg_count => x_msg_count
1774: , x_msg_data => x_msg_data
1775: , p_control_rec => l_control_rec
1779: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1780: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1780: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1781: );
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789:
1782:
1783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789:
1790: -- Clear MODIFIERS record cache
1792: Clear_MODIFIERS;
1793:
1794: -- Set return status.
1795:
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;
1797:
1798: -- Get message count and data
1799:
1800: OE_MSG_PUB.Count_And_Get
1805: oe_debug_pub.add('END Delete_Row in QPXFMLLB');
1806:
1807: EXCEPTION
1808:
1809: WHEN FND_API.G_EXC_ERROR THEN
1810:
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812:
1813: -- Get message count and data
1807: EXCEPTION
1808:
1809: WHEN FND_API.G_EXC_ERROR THEN
1810:
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812:
1813: -- Get message count and data
1814:
1815: OE_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count
1817: , p_data => x_msg_data
1818: );
1819:
1820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1823:
1824: -- Get message count and data
1818: );
1819:
1820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1821:
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1823:
1824: -- Get message count and data
1825:
1826: OE_MSG_PUB.Count_And_Get
1829: );
1830:
1831: WHEN OTHERS THEN
1832:
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834:
1835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1836: THEN
1837: OE_MSG_PUB.Add_Exc_Msg
1890: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1891:
1892: QP_Modifiers_PVT.Process_MODIFIERS
1893: ( p_api_version_number => 1.0
1894: , p_init_msg_list => FND_API.G_TRUE
1895: , x_return_status => l_return_status
1896: , x_msg_count => x_msg_count
1897: , x_msg_data => x_msg_data
1898: , p_control_rec => l_control_rec
1901: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1902: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1902: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911:
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911:
1912: -- Set return status.
1910:
1911:
1912: -- Set return status.
1913:
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: -- Get message count and data
1917:
1918: OE_MSG_PUB.Count_And_Get
1923: oe_debug_pub.add('END Process_Entity in QPXFMLLB');
1924:
1925: EXCEPTION
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928:
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: -- Get message count and data
1925: EXCEPTION
1926:
1927: WHEN FND_API.G_EXC_ERROR THEN
1928:
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: -- Get message count and data
1932:
1933: OE_MSG_PUB.Count_And_Get
1934: ( p_count => x_msg_count
1935: , p_data => x_msg_data
1936: );
1937:
1938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1939:
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1941:
1942: -- Get message count and data
1936: );
1937:
1938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1939:
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1941:
1942: -- Get message count and data
1943:
1944: OE_MSG_PUB.Count_And_Get
1947: );
1948:
1949: WHEN OTHERS THEN
1950:
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1952:
1953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1954: THEN
1955: OE_MSG_PUB.Add_Exc_Msg
2188: -- Call QP_Modifiers_PVT.Lock_MODIFIERS
2189:
2190: QP_Modifiers_PVT.Lock_MODIFIERS
2191: ( p_api_version_number => 1.0
2192: , p_init_msg_list => FND_API.G_TRUE
2193: , x_return_status => l_return_status
2194: , x_msg_count => x_msg_count
2195: , x_msg_data => x_msg_data
2196: , p_MODIFIERS_tbl => l_MODIFIERS_tbl
2199: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
2200: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
2201: );
2202:
2203: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2204:
2205: -- Set DB flag and write record to cache.
2206:
2207: l_x_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2203: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2204:
2205: -- Set DB flag and write record to cache.
2206:
2207: l_x_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2208:
2209: Write_MODIFIERS
2210: ( p_MODIFIERS_rec => l_x_MODIFIERS_rec
2211: , p_db_record => TRUE
2237: , 'Lock_Row'
2238: );
2239: END IF;
2240:
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2242:
2243: -- Get message count and data
2244:
2245: OE_MSG_PUB.Count_And_Get
2291: g_MODIFIERS_rec := QP_Modifiers_Util.Query_Row
2292: ( p_list_line_id => p_list_line_id
2293: );
2294:
2295: g_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2296:
2297: -- Load DB record
2298:
2299: g_db_MODIFIERS_rec := g_MODIFIERS_rec;
2341: IS
2342: l_return_status Varchar2(30);
2343: BEGIN
2344: OE_MSG_PUB.initialize;
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;
2346: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2347: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2348: ,p_entity_id => p_list_line_id
2349: ,x_return_status => l_return_status);
2369: OE_MSG_PUB.Count_And_Get
2370: ( p_count => x_msg_count
2371: , p_data => x_msg_data
2372: );
2373: x_return_status := FND_API.G_RET_STS_ERROR;
2374:
2375: END Clear_Record;
2376:
2377:
2840: l_MODIFIERS_rec.TO_RLTD_MODIFIER_ID := l_new_list_line_id;
2841: l_MODIFIERS_rec.RLTD_MODIFIER_GRP_NO := l_implicit_rec.RLTD_MODIFIER_GRP_NO;
2842: l_MODIFIERS_rec.RLTD_MODIFIER_GRP_TYPE := l_implicit_rec.RLTD_MODIFIER_GRP_TYPE;
2843:
2844: l_MODIFIERS_rec.db_flag := FND_API.G_TRUE;
2845: l_MODIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2846:
2847: l_MODIFIERS_tbl(l_MODIFIERS_tbl.COUNT + 1) := l_MODIFIERS_rec;
2848: l_number_of_lines := l_number_of_lines + 1;
3006: oe_debug_pub.add('Before calling Process Modifier');
3007:
3008: QP_Modifiers_PVT.Process_MODIFIERS
3009: ( p_api_version_number => 1.0
3010: , p_init_msg_list => FND_API.G_TRUE
3011: , x_return_status => l_return_status
3012: , x_msg_count => x_msg_count
3013: , x_msg_data => x_msg_data
3014: , p_control_rec => l_control_rec
3050:
3051: END IF;
3052:
3053: oe_debug_pub.add('After calling Process Modifier');
3054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: RAISE FND_API.G_EXC_ERROR;
3058: END IF;
3051: END IF;
3052:
3053: oe_debug_pub.add('After calling Process Modifier');
3054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: RAISE FND_API.G_EXC_ERROR;
3058: END IF;
3059: oe_debug_pub.add('Outside Duplicate Record');
3052:
3053: oe_debug_pub.add('After calling Process Modifier');
3054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: RAISE FND_API.G_EXC_ERROR;
3058: END IF;
3059: oe_debug_pub.add('Outside Duplicate Record');
3060: END IF;
3053: oe_debug_pub.add('After calling Process Modifier');
3054: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3056: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3057: RAISE FND_API.G_EXC_ERROR;
3058: END IF;
3059: oe_debug_pub.add('Outside Duplicate Record');
3060: END IF;
3061: EXCEPTION
3059: oe_debug_pub.add('Outside Duplicate Record');
3060: END IF;
3061: EXCEPTION
3062:
3063: WHEN FND_API.G_EXC_ERROR THEN
3064:
3065: x_return_status := FND_API.G_RET_STS_ERROR;
3066:
3067: -- Get message count and data
3061: EXCEPTION
3062:
3063: WHEN FND_API.G_EXC_ERROR THEN
3064:
3065: x_return_status := FND_API.G_RET_STS_ERROR;
3066:
3067: -- Get message count and data
3068:
3069: oe_msg_pub.Count_And_Get
3070: ( p_count => x_msg_count
3071: , p_data => x_msg_data
3072: );
3073:
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075:
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3077:
3078: -- Get message count and data
3072: );
3073:
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075:
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3077:
3078: -- Get message count and data
3079:
3080: oe_msg_pub.Count_And_Get
3083: );
3084:
3085: WHEN OTHERS THEN
3086:
3087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3088:
3089: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3090: THEN
3091: oe_msg_pub.Add_Exc_Msg