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

APPS.QP_QP_FORM_PRICE_LIST_LINE dependencies on FND_API

Line 191: , p_init_msg_list => FND_API.G_TRUE

187: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
188:
189: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
190: ( p_api_version_number => 1.0
191: , p_init_msg_list => FND_API.G_TRUE
192: , x_return_status => l_return_status
193: , x_msg_count => x_msg_count
194: , x_msg_data => x_msg_data
195: , p_control_rec => l_control_rec

Line 204: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

200: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
201: );
202:
203: oe_debug_pub.add('after process price list 0');
204: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201: );
202:
203: oe_debug_pub.add('after process price list 0');
204: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:

Line 206: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

202:
203: oe_debug_pub.add('after process price list 0');
204: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: oe_debug_pub.add('after process price list 1');

Line 207: RAISE FND_API.G_EXC_ERROR;

203: oe_debug_pub.add('after process price list 0');
204: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: oe_debug_pub.add('after process price list 1');
211: -- Unload out tbl

Line 314: l_x_PRICE_LIST_LINE_rec.db_flag := FND_API.G_FALSE;

310: -- Set db_flag to False before writing to cache
311:
312: oe_debug_pub.add('after get values');
313:
314: l_x_PRICE_LIST_LINE_rec.db_flag := FND_API.G_FALSE;
315:
316: Write_PRICE_LIST_LINE
317: ( p_PRICE_LIST_LINE_rec => l_x_PRICE_LIST_LINE_rec
318: );

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: oe_debug_pub.add('after write price list line');
321:
322: -- Set return status.
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: -- Get message count and data
327:
328: oe_msg_pub.Count_And_Get

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333: oe_debug_pub.add('msg data is : ' || x_msg_data);
334:
335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338:
339: x_return_status := FND_API.G_RET_STS_ERROR;
340:
341: -- Get message count and data

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338:
339: x_return_status := FND_API.G_RET_STS_ERROR;
340:
341: -- Get message count and data
342:
343: oe_msg_pub.Count_And_Get

Line 348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

344: ( p_count => x_msg_count
345: , p_data => x_msg_data
346: );
347:
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349:
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351:
352: -- Get message count and data

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

346: );
347:
348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
349:
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351:
352: -- Get message count and data
353:
354: oe_msg_pub.Count_And_Get

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

357: );
358:
359: WHEN OTHERS THEN
360:
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
364: THEN
365: oe_msg_pub.Add_Exc_Msg

Line 675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

671: , 'Unrecognized attribute'
672: );
673: END IF;
674:
675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
676:
677: END IF;
678:
679: -- Set Operation.

Line 681: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN

677: END IF;
678:
679: -- Set Operation.
680:
681: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN
682: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
683: ELSE
684: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
685: END IF;

Line 696: , p_init_msg_list => FND_API.G_TRUE

692: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
693:
694: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
695: ( p_api_version_number => 1.0
696: , p_init_msg_list => FND_API.G_TRUE
697: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
698: , x_return_status => l_return_status
699: , x_msg_count => x_msg_count
700: , x_msg_data => x_msg_data

Line 697: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

693:
694: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
695: ( p_api_version_number => 1.0
696: , p_init_msg_list => FND_API.G_TRUE
697: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
698: , x_return_status => l_return_status
699: , x_msg_count => x_msg_count
700: , x_msg_data => x_msg_data
701: , p_control_rec => l_control_rec

Line 710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

706: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
707: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
708: );
709:
710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;

Line 711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

707: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
708: );
709:
710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715:

Line 712: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

708: );
709:
710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715:
716:

Line 713: RAISE FND_API.G_EXC_ERROR;

709:
710: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
713: RAISE FND_API.G_EXC_ERROR;
714: END IF;
715:
716:
717: -- Unload out tbl

Line 723: x_accrual_qty := FND_API.G_MISS_NUM;

719: l_x_PRICE_LIST_LINE_rec := l_x_PRICE_LIST_LINE_tbl(1);
720:
721: -- Init OUT parameters to missing.
722:
723: x_accrual_qty := FND_API.G_MISS_NUM;
724: x_accrual_uom_code := FND_API.G_MISS_CHAR;
725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;

Line 724: x_accrual_uom_code := FND_API.G_MISS_CHAR;

720:
721: -- Init OUT parameters to missing.
722:
723: x_accrual_qty := FND_API.G_MISS_NUM;
724: x_accrual_uom_code := FND_API.G_MISS_CHAR;
725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;

Line 725: x_arithmetic_operator := FND_API.G_MISS_CHAR;

721: -- Init OUT parameters to missing.
722:
723: x_accrual_qty := FND_API.G_MISS_NUM;
724: x_accrual_uom_code := FND_API.G_MISS_CHAR;
725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;

Line 726: x_attribute1 := FND_API.G_MISS_CHAR;

722:
723: x_accrual_qty := FND_API.G_MISS_NUM;
724: x_accrual_uom_code := FND_API.G_MISS_CHAR;
725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;

Line 727: x_attribute10 := FND_API.G_MISS_CHAR;

723: x_accrual_qty := FND_API.G_MISS_NUM;
724: x_accrual_uom_code := FND_API.G_MISS_CHAR;
725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;

Line 728: x_attribute11 := FND_API.G_MISS_CHAR;

724: x_accrual_uom_code := FND_API.G_MISS_CHAR;
725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;

Line 729: x_attribute12 := FND_API.G_MISS_CHAR;

725: x_arithmetic_operator := FND_API.G_MISS_CHAR;
726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;

Line 730: x_attribute13 := FND_API.G_MISS_CHAR;

726: x_attribute1 := FND_API.G_MISS_CHAR;
727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;

Line 731: x_attribute14 := FND_API.G_MISS_CHAR;

727: x_attribute10 := FND_API.G_MISS_CHAR;
728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;

Line 732: x_attribute15 := FND_API.G_MISS_CHAR;

728: x_attribute11 := FND_API.G_MISS_CHAR;
729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;

Line 733: x_attribute2 := FND_API.G_MISS_CHAR;

729: x_attribute12 := FND_API.G_MISS_CHAR;
730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;

Line 734: x_attribute3 := FND_API.G_MISS_CHAR;

730: x_attribute13 := FND_API.G_MISS_CHAR;
731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;

Line 735: x_attribute4 := FND_API.G_MISS_CHAR;

731: x_attribute14 := FND_API.G_MISS_CHAR;
732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;

Line 736: x_attribute5 := FND_API.G_MISS_CHAR;

732: x_attribute15 := FND_API.G_MISS_CHAR;
733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;

Line 737: x_attribute6 := FND_API.G_MISS_CHAR;

733: x_attribute2 := FND_API.G_MISS_CHAR;
734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;

Line 738: x_attribute7 := FND_API.G_MISS_CHAR;

734: x_attribute3 := FND_API.G_MISS_CHAR;
735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;

Line 739: x_attribute8 := FND_API.G_MISS_CHAR;

735: x_attribute4 := FND_API.G_MISS_CHAR;
736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;

Line 740: x_attribute9 := FND_API.G_MISS_CHAR;

736: x_attribute5 := FND_API.G_MISS_CHAR;
737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;

Line 741: x_automatic_flag := FND_API.G_MISS_CHAR;

737: x_attribute6 := FND_API.G_MISS_CHAR;
738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;

Line 742: x_base_qty := FND_API.G_MISS_NUM;

738: x_attribute7 := FND_API.G_MISS_CHAR;
739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;

Line 743: x_base_uom_code := FND_API.G_MISS_CHAR;

739: x_attribute8 := FND_API.G_MISS_CHAR;
740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;

Line 744: x_comments := FND_API.G_MISS_CHAR;

740: x_attribute9 := FND_API.G_MISS_CHAR;
741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;

Line 745: x_context := FND_API.G_MISS_CHAR;

741: x_automatic_flag := FND_API.G_MISS_CHAR;
742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;

Line 746: x_effective_period_uom := FND_API.G_MISS_CHAR;

742: x_base_qty := FND_API.G_MISS_NUM;
743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;

Line 747: x_end_date_active := FND_API.G_MISS_DATE;

743: x_base_uom_code := FND_API.G_MISS_CHAR;
744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;

Line 748: x_estim_accrual_rate := FND_API.G_MISS_NUM;

744: x_comments := FND_API.G_MISS_CHAR;
745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;

Line 749: x_generate_using_formula_id := FND_API.G_MISS_NUM;

745: x_context := FND_API.G_MISS_CHAR;
746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;

Line 750: x_inventory_item_id := FND_API.G_MISS_NUM;

746: x_effective_period_uom := FND_API.G_MISS_CHAR;
747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;

Line 751: x_list_header_id := FND_API.G_MISS_NUM;

747: x_end_date_active := FND_API.G_MISS_DATE;
748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;

Line 752: x_list_line_id := FND_API.G_MISS_NUM;

748: x_estim_accrual_rate := FND_API.G_MISS_NUM;
749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;

Line 753: x_list_line_type_code := FND_API.G_MISS_CHAR;

749: x_generate_using_formula_id := FND_API.G_MISS_NUM;
750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;

Line 754: x_list_price := FND_API.G_MISS_NUM;

750: x_inventory_item_id := FND_API.G_MISS_NUM;
751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;

Line 755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;

751: x_list_header_id := FND_API.G_MISS_NUM;
752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;

Line 756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;

752: x_list_line_id := FND_API.G_MISS_NUM;
753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;

Line 757: x_product_precedence := FND_API.G_MISS_NUM;

753: x_list_line_type_code := FND_API.G_MISS_CHAR;
754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;

Line 758: x_modifier_level_code := FND_API.G_MISS_CHAR;

754: x_list_price := FND_API.G_MISS_NUM;
755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;

Line 759: x_number_effective_periods := FND_API.G_MISS_NUM;

755: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;

Line 760: x_operand := FND_API.G_MISS_NUM;

756: x_rltd_modifier_group_no := FND_API.G_MISS_NUM;
757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;

Line 761: x_organization_id := FND_API.G_MISS_NUM;

757: x_product_precedence := FND_API.G_MISS_NUM;
758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;

Line 762: x_override_flag := FND_API.G_MISS_CHAR;

758: x_modifier_level_code := FND_API.G_MISS_CHAR;
759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;

Line 763: x_percent_price := FND_API.G_MISS_NUM;

759: x_number_effective_periods := FND_API.G_MISS_NUM;
760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;

Line 764: x_price_break_type_code := FND_API.G_MISS_CHAR;

760: x_operand := FND_API.G_MISS_NUM;
761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;

Line 765: x_price_by_formula_id := FND_API.G_MISS_NUM;

761: x_organization_id := FND_API.G_MISS_NUM;
762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;

Line 766: x_primary_uom_flag := FND_API.G_MISS_CHAR;

762: x_override_flag := FND_API.G_MISS_CHAR;
763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;

Line 767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;

763: x_percent_price := FND_API.G_MISS_NUM;
764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;

Line 768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;

764: x_price_break_type_code := FND_API.G_MISS_CHAR;
765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;

Line 769: x_related_item_id := FND_API.G_MISS_NUM;

765: x_price_by_formula_id := FND_API.G_MISS_NUM;
766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;

Line 770: x_relationship_type_id := FND_API.G_MISS_NUM;

766: x_primary_uom_flag := FND_API.G_MISS_CHAR;
767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;

Line 771: x_reprice_flag := FND_API.G_MISS_CHAR;

767: x_print_on_invoice_flag := FND_API.G_MISS_CHAR;
768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;

Line 772: x_revision := FND_API.G_MISS_CHAR;

768: x_rebate_trxn_type_code := FND_API.G_MISS_CHAR;
769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;

Line 773: x_revision_date := FND_API.G_MISS_DATE;

769: x_related_item_id := FND_API.G_MISS_NUM;
770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;

Line 774: x_revision_reason_code := FND_API.G_MISS_CHAR;

770: x_relationship_type_id := FND_API.G_MISS_NUM;
771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;

Line 775: x_start_date_active := FND_API.G_MISS_DATE;

771: x_reprice_flag := FND_API.G_MISS_CHAR;
772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;

Line 776: x_substitution_attribute := FND_API.G_MISS_CHAR;

772: x_revision := FND_API.G_MISS_CHAR;
773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;

Line 777: x_substitution_context := FND_API.G_MISS_CHAR;

773: x_revision_date := FND_API.G_MISS_DATE;
774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;

Line 778: x_substitution_value := FND_API.G_MISS_CHAR;

774: x_revision_reason_code := FND_API.G_MISS_CHAR;
775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;

Line 779: x_accrual_uom := FND_API.G_MISS_CHAR;

775: x_start_date_active := FND_API.G_MISS_DATE;
776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;

Line 780: x_automatic := FND_API.G_MISS_CHAR;

776: x_substitution_attribute := FND_API.G_MISS_CHAR;
777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;

Line 781: x_base_uom := FND_API.G_MISS_CHAR;

777: x_substitution_context := FND_API.G_MISS_CHAR;
778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;

Line 782: x_generate_using_formula := FND_API.G_MISS_CHAR;

778: x_substitution_value := FND_API.G_MISS_CHAR;
779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;

Line 783: x_inventory_item := FND_API.G_MISS_CHAR;

779: x_accrual_uom := FND_API.G_MISS_CHAR;
780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;

Line 784: x_list_header := FND_API.G_MISS_CHAR;

780: x_automatic := FND_API.G_MISS_CHAR;
781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;

Line 785: x_list_line := FND_API.G_MISS_CHAR;

781: x_base_uom := FND_API.G_MISS_CHAR;
782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;

Line 786: x_list_line_type := FND_API.G_MISS_CHAR;

782: x_generate_using_formula := FND_API.G_MISS_CHAR;
783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;

Line 787: x_modifier_level := FND_API.G_MISS_CHAR;

783: x_inventory_item := FND_API.G_MISS_CHAR;
784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;

Line 788: x_organization := FND_API.G_MISS_CHAR;

784: x_list_header := FND_API.G_MISS_CHAR;
785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;

Line 789: x_override := FND_API.G_MISS_CHAR;

785: x_list_line := FND_API.G_MISS_CHAR;
786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;

Line 790: x_price_break_type := FND_API.G_MISS_CHAR;

786: x_list_line_type := FND_API.G_MISS_CHAR;
787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;

Line 791: x_price_by_formula := FND_API.G_MISS_CHAR;

787: x_modifier_level := FND_API.G_MISS_CHAR;
788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;

Line 792: x_primary_uom := FND_API.G_MISS_CHAR;

788: x_organization := FND_API.G_MISS_CHAR;
789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;

Line 793: x_print_on_invoice := FND_API.G_MISS_CHAR;

789: x_override := FND_API.G_MISS_CHAR;
790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;

Line 794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;

790: x_price_break_type := FND_API.G_MISS_CHAR;
791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;

Line 795: x_related_item := FND_API.G_MISS_CHAR;

791: x_price_by_formula := FND_API.G_MISS_CHAR;
792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing

Line 796: x_relationship_type := FND_API.G_MISS_CHAR;

792: x_primary_uom := FND_API.G_MISS_CHAR;
793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;

Line 797: x_reprice := FND_API.G_MISS_CHAR;

793: x_print_on_invoice := FND_API.G_MISS_CHAR;
794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration

Line 798: x_revision_reason := FND_API.G_MISS_CHAR;

794: x_rebate_transaction_type := FND_API.G_MISS_CHAR;
795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration

Line 799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing

795: x_related_item := FND_API.G_MISS_CHAR;
796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration
803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration

Line 800: x_customer_item_id := FND_API.G_MISS_NUM;

796: x_relationship_type := FND_API.G_MISS_CHAR;
797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration
803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration
804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks

Line 801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration

797: x_reprice := FND_API.G_MISS_CHAR;
798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration
803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration
804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
805:

Line 802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration

798: x_revision_reason := FND_API.G_MISS_CHAR;
799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration
803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration
804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
805:
806: -- Load display out parameters if any

Line 803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration

799: x_recurring_value := FND_API.G_MISS_NUM; -- block pricing
800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration
803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration
804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
805:
806: -- Load display out parameters if any
807:

Line 804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks

800: x_customer_item_id := FND_API.G_MISS_NUM;
801: x_break_uom_code := FND_API.G_MISS_CHAR; -- OKS proration
802: x_break_uom_context := FND_API.G_MISS_CHAR; -- OKS proration
803: x_break_uom_attribute := FND_API.G_MISS_CHAR; -- OKS proration
804: x_continuous_price_break_flag := FND_API.G_MISS_CHAR; --Continuous Price Breaks
805:
806: -- Load display out parameters if any
807:
808: l_PRICE_LIST_LINE_val_rec := QP_Price_List_Line_Util.Get_Values

Line 1220: x_return_status := FND_API.G_RET_STS_SUCCESS;

1216: oe_debug_pub.add('prog app id in ca pll 2 is: ' || l_x_PRICE_LIST_LINE_rec.program_application_id);
1217: oe_debug_pub.add('prog id in ca pll 2 is: ' || l_x_PRICE_LIST_LINE_rec.program_id);
1218: -- Set return status.
1219:
1220: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221:
1222: -- Get message count and data
1223:
1224: oe_msg_pub.Count_And_Get

Line 1232: WHEN FND_API.G_EXC_ERROR THEN

1228:
1229:
1230: EXCEPTION
1231:
1232: WHEN FND_API.G_EXC_ERROR THEN
1233:
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: -- Get message count and data

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR;

1230: EXCEPTION
1231:
1232: WHEN FND_API.G_EXC_ERROR THEN
1233:
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: -- Get message count and data
1237:
1238: oe_msg_pub.Count_And_Get

Line 1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1239: ( p_count => x_msg_count
1240: , p_data => x_msg_data
1241: );
1242:
1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1246:
1247: -- Get message count and data

Line 1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1241: );
1242:
1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1244:
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1246:
1247: -- Get message count and data
1248:
1249: oe_msg_pub.Count_And_Get

Line 1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1252: );
1253:
1254: WHEN OTHERS THEN
1255:
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1257:
1258: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1259: THEN
1260: oe_msg_pub.Add_Exc_Msg

Line 1337: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN

1333: );
1334:
1335: -- Set Operation.
1336:
1337: IF FND_API.To_Boolean(l_PRICE_LIST_LINE_rec.db_flag) THEN
1338: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1339: ELSE
1340: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1341: END IF;

Line 1352: , p_init_msg_list => FND_API.G_TRUE

1348: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1349:
1350: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1351: ( p_api_version_number => 1.0
1352: , p_init_msg_list => FND_API.G_TRUE
1353: , x_return_status => l_return_status
1354: , x_msg_count => x_msg_count
1355: , x_msg_data => x_msg_data
1356: , p_control_rec => l_control_rec

Line 1365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1361: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1362: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1363: );
1364:
1365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;

Line 1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1362: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1363: );
1364:
1365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370:

Line 1367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1363: );
1364:
1365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370:
1371:

Line 1368: RAISE FND_API.G_EXC_ERROR;

1364:
1365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370:
1371:
1372: -- Load OUT parameters.

Line 1397: x_return_status := FND_API.G_RET_STS_SUCCESS;

1393:
1394:
1395: -- Set return status.
1396:
1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:
1399: -- Get message count and data
1400:
1401: oe_msg_pub.Count_And_Get

Line 1409: WHEN FND_API.G_EXC_ERROR THEN

1405:
1406:
1407: EXCEPTION
1408:
1409: WHEN FND_API.G_EXC_ERROR THEN
1410:
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412:
1413: -- Get message count and data

Line 1411: x_return_status := FND_API.G_RET_STS_ERROR;

1407: EXCEPTION
1408:
1409: WHEN FND_API.G_EXC_ERROR THEN
1410:
1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412:
1413: -- Get message count and data
1414:
1415: oe_msg_pub.Count_And_Get

Line 1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1416: ( p_count => x_msg_count
1417: , p_data => x_msg_data
1418: );
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421:
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1423:
1424: -- Get message count and data

Line 1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1418: );
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421:
1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1423:
1424: -- Get message count and data
1425:
1426: oe_msg_pub.Count_And_Get

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1429: );
1430:
1431: WHEN OTHERS THEN
1432:
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434:
1435: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: oe_msg_pub.Add_Exc_Msg

Line 1509: , p_init_msg_list => FND_API.G_TRUE

1505: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1506:
1507: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1508: ( p_api_version_number => 1.0
1509: , p_init_msg_list => FND_API.G_TRUE
1510: , x_return_status => l_return_status
1511: , x_msg_count => x_msg_count
1512: , x_msg_data => x_msg_data
1513: , p_control_rec => l_control_rec

Line 1521: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1517: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1518: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1519: );
1520:
1521: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;

Line 1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1518: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1519: );
1520:
1521: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:

Line 1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1519: );
1520:
1521: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527:

Line 1524: RAISE FND_API.G_EXC_ERROR;

1520:
1521: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527:
1528: -- Clear PRICE_LIST_LINE record cache

Line 1534: x_return_status := FND_API.G_RET_STS_SUCCESS;

1530: Clear_PRICE_LIST_LINE;
1531:
1532: -- Set return status.
1533:
1534: x_return_status := FND_API.G_RET_STS_SUCCESS;
1535:
1536: -- Get message count and data
1537:
1538: oe_msg_pub.Count_And_Get

Line 1546: WHEN FND_API.G_EXC_ERROR THEN

1542:
1543:
1544: EXCEPTION
1545:
1546: WHEN FND_API.G_EXC_ERROR THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549:
1550: -- Get message count and data

Line 1548: x_return_status := FND_API.G_RET_STS_ERROR;

1544: EXCEPTION
1545:
1546: WHEN FND_API.G_EXC_ERROR THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549:
1550: -- Get message count and data
1551:
1552: oe_msg_pub.Count_And_Get

Line 1557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1553: ( p_count => x_msg_count
1554: , p_data => x_msg_data
1555: );
1556:
1557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1558:
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1560:
1561: -- Get message count and data

Line 1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1555: );
1556:
1557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1558:
1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1560:
1561: -- Get message count and data
1562:
1563: oe_msg_pub.Count_And_Get

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1566: );
1567:
1568: WHEN OTHERS THEN
1569:
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1573: THEN
1574: oe_msg_pub.Add_Exc_Msg

Line 1629: , p_init_msg_list => FND_API.G_TRUE

1625: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1626:
1627: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1628: ( p_api_version_number => 1.0
1629: , p_init_msg_list => FND_API.G_TRUE
1630: , x_return_status => l_return_status
1631: , x_msg_count => x_msg_count
1632: , x_msg_data => x_msg_data
1633: , p_control_rec => l_control_rec

Line 1640: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1636: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1637: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1638: );
1639:
1640: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643: RAISE FND_API.G_EXC_ERROR;
1644: END IF;

Line 1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1637: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1638: );
1639:
1640: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643: RAISE FND_API.G_EXC_ERROR;
1644: END IF;
1645:

Line 1642: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1638: );
1639:
1640: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643: RAISE FND_API.G_EXC_ERROR;
1644: END IF;
1645:
1646:

Line 1643: RAISE FND_API.G_EXC_ERROR;

1639:
1640: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1642: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1643: RAISE FND_API.G_EXC_ERROR;
1644: END IF;
1645:
1646:
1647: -- Set return status.

Line 1649: x_return_status := FND_API.G_RET_STS_SUCCESS;

1645:
1646:
1647: -- Set return status.
1648:
1649: x_return_status := FND_API.G_RET_STS_SUCCESS;
1650:
1651: -- Get message count and data
1652:
1653: oe_msg_pub.Count_And_Get

Line 1661: WHEN FND_API.G_EXC_ERROR THEN

1657:
1658:
1659: EXCEPTION
1660:
1661: WHEN FND_API.G_EXC_ERROR THEN
1662:
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664:
1665: -- Get message count and data

Line 1663: x_return_status := FND_API.G_RET_STS_ERROR;

1659: EXCEPTION
1660:
1661: WHEN FND_API.G_EXC_ERROR THEN
1662:
1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664:
1665: -- Get message count and data
1666:
1667: oe_msg_pub.Count_And_Get

Line 1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1668: ( p_count => x_msg_count
1669: , p_data => x_msg_data
1670: );
1671:
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673:
1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1675:
1676: -- Get message count and data

Line 1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1670: );
1671:
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1673:
1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1675:
1676: -- Get message count and data
1677:
1678: oe_msg_pub.Count_And_Get

Line 1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1681: );
1682:
1683: WHEN OTHERS THEN
1684:
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686:
1687: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689: oe_msg_pub.Add_Exc_Msg

Line 1883: , p_init_msg_list => FND_API.G_TRUE

1879: oe_debug_pub.add('before calling lock price list');
1880:
1881: QP_LIST_HEADERS_PVT.Lock_PRICE_LIST
1882: ( p_api_version_number => 1.0
1883: , p_init_msg_list => FND_API.G_TRUE
1884: , x_return_status => l_return_status
1885: , x_msg_count => x_msg_count
1886: , x_msg_data => x_msg_data
1887: , p_PRICE_LIST_LINE_tbl => l_PRICE_LIST_LINE_tbl

Line 1896: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1892: );
1893:
1894: oe_debug_pub.add('after calling lock price list');
1895:
1896: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1897:
1898: -- Set DB flag and write record to cache.
1899:
1900: l_x_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

Line 1900: l_x_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

1896: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1897:
1898: -- Set DB flag and write record to cache.
1899:
1900: l_x_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
1901:
1902: Write_PRICE_LIST_LINE
1903: ( p_PRICE_LIST_LINE_rec => l_x_PRICE_LIST_LINE_rec
1904: , p_db_record => TRUE

Line 1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1931: , 'Lock_Row'
1932: );
1933: END IF;
1934:
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936:
1937: -- Get message count and data
1938:
1939: oe_msg_pub.Count_And_Get

Line 1985: g_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

1981: g_PRICE_LIST_LINE_rec := QP_Price_List_Line_Util.Query_Row
1982: ( p_list_line_id => p_list_line_id
1983: );
1984:
1985: g_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
1986:
1987: -- Load DB record
1988:
1989: g_db_PRICE_LIST_LINE_rec := g_PRICE_LIST_LINE_rec;

Line 2026: x_return_status := FND_API.G_RET_STS_SUCCESS;

2022: IS
2023: l_return_status Varchar2(30);
2024: BEGIN
2025: OE_MSG_PUB.initialize;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2028: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
2029: ,p_entity_id => p_list_line_id
2030: ,x_return_status => l_return_status);

Line 2054: x_return_status := FND_API.G_RET_STS_ERROR;

2050: OE_MSG_PUB.Count_And_Get
2051: ( p_count => x_msg_count
2052: , p_data => x_msg_data
2053: );
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055:
2056: END Clear_Record;
2057:
2058:

Line 2070: x_return_status := FND_API.G_RET_STS_SUCCESS;

2066: IS
2067: l_return_status Varchar2(30);
2068: BEGIN
2069: OE_MSG_PUB.initialize;
2070: x_return_status := FND_API.G_RET_STS_SUCCESS;
2071: QP_DELAYED_REQUESTS_PVT.Clear_Request(
2072: x_return_status => l_return_status);
2073:
2074: EXCEPTION

Line 2088: x_return_status := FND_API.G_RET_STS_ERROR;

2084: OE_MSG_PUB.Count_And_Get
2085: ( p_count => x_msg_count
2086: , p_data => x_msg_data
2087: );
2088: x_return_status := FND_API.G_RET_STS_ERROR;
2089:
2090: END Delete_All_Requests;
2091:
2092: