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.OE_OE_FORM_PRICE_BREAK dependencies on FND_API

Line 164: , p_init_msg_list => FND_API.G_TRUE

160: END IF;
161:
162: OE_Pricing_Cont_PVT.Process_Pricing_Cont
163: ( p_api_version_number => 1.0
164: , p_init_msg_list => FND_API.G_TRUE
165: , x_return_status => l_return_status
166: , x_msg_count => x_msg_count
167: , x_msg_data => x_msg_data
168: , p_control_rec => l_control_rec

Line 180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

176: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
177: , x_Price_Break_tbl => l_x_Price_Break_tbl
178: );
179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: , x_Price_Break_tbl => l_x_Price_Break_tbl
178: );
179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:

Line 182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

178: );
179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186:

Line 183: RAISE FND_API.G_EXC_ERROR;

179:
180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185:
186:
187: -- Unload out tbl

Line 232: l_x_Price_Break_rec.db_flag := FND_API.G_FALSE;

228:
229: -- Write to cache.
230: -- Set db_flag to False before writing to cache
231:
232: l_x_Price_Break_rec.db_flag := FND_API.G_FALSE;
233:
234: Write_Price_Break
235: ( p_Price_Break_rec => l_x_Price_Break_rec
236: );

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: );
237:
238: -- Set return status.
239:
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: -- Get message count and data
243:
244: OE_MSG_PUB.Count_And_Get

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248:
249:
250: EXCEPTION
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253:
254: x_return_status := FND_API.G_RET_STS_ERROR;
255:
256: -- Get message count and data

Line 254: x_return_status := FND_API.G_RET_STS_ERROR;

250: EXCEPTION
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253:
254: x_return_status := FND_API.G_RET_STS_ERROR;
255:
256: -- Get message count and data
257:
258: OE_MSG_PUB.Count_And_Get

Line 263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

259: ( p_count => x_msg_count
260: , p_data => x_msg_data
261: );
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
266:
267: -- Get message count and data

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

261: );
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264:
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
266:
267: -- Get message count and data
268:
269: OE_MSG_PUB.Count_And_Get

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

272: );
273:
274: WHEN OTHERS THEN
275:
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277:
278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
279: THEN
280: OE_MSG_PUB.Add_Exc_Msg

Line 469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

465: , 'Unrecognized attribute'
466: );
467: END IF;
468:
469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
470:
471: END IF;
472:
473: -- Set Operation.

Line 475: IF FND_API.To_Boolean(l_Price_Break_rec.db_flag) THEN

471: END IF;
472:
473: -- Set Operation.
474:
475: IF FND_API.To_Boolean(l_Price_Break_rec.db_flag) THEN
476: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
477: ELSE
478: l_Price_Break_rec.operation := OE_GLOBALS.G_OPR_CREATE;
479: END IF;

Line 490: , p_init_msg_list => FND_API.G_TRUE

486: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
487:
488: OE_Pricing_Cont_PVT.Process_Pricing_Cont
489: ( p_api_version_number => 1.0
490: , p_init_msg_list => FND_API.G_TRUE
491: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
492: , x_return_status => l_return_status
493: , x_msg_count => x_msg_count
494: , x_msg_data => x_msg_data

Line 491: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

487:
488: OE_Pricing_Cont_PVT.Process_Pricing_Cont
489: ( p_api_version_number => 1.0
490: , p_init_msg_list => FND_API.G_TRUE
491: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
492: , x_return_status => l_return_status
493: , x_msg_count => x_msg_count
494: , x_msg_data => x_msg_data
495: , p_control_rec => l_control_rec

Line 508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

504: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
505: , x_Price_Break_tbl => l_x_Price_Break_tbl
506: );
507:
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

505: , x_Price_Break_tbl => l_x_Price_Break_tbl
506: );
507:
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:

Line 510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

506: );
507:
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:
514:

Line 511: RAISE FND_API.G_EXC_ERROR;

507:
508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
511: RAISE FND_API.G_EXC_ERROR;
512: END IF;
513:
514:
515: -- Unload out tbl

Line 521: x_amount := FND_API.G_MISS_NUM;

517: l_x_Price_Break_rec := l_x_Price_Break_tbl(1);
518:
519: -- Init OUT parameters to missing.
520:
521: x_amount := FND_API.G_MISS_NUM;
522: x_attribute1 := FND_API.G_MISS_CHAR;
523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;

Line 522: x_attribute1 := FND_API.G_MISS_CHAR;

518:
519: -- Init OUT parameters to missing.
520:
521: x_amount := FND_API.G_MISS_NUM;
522: x_attribute1 := FND_API.G_MISS_CHAR;
523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;

Line 523: x_attribute10 := FND_API.G_MISS_CHAR;

519: -- Init OUT parameters to missing.
520:
521: x_amount := FND_API.G_MISS_NUM;
522: x_attribute1 := FND_API.G_MISS_CHAR;
523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;

Line 524: x_attribute11 := FND_API.G_MISS_CHAR;

520:
521: x_amount := FND_API.G_MISS_NUM;
522: x_attribute1 := FND_API.G_MISS_CHAR;
523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;

Line 525: x_attribute12 := FND_API.G_MISS_CHAR;

521: x_amount := FND_API.G_MISS_NUM;
522: x_attribute1 := FND_API.G_MISS_CHAR;
523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;

Line 526: x_attribute13 := FND_API.G_MISS_CHAR;

522: x_attribute1 := FND_API.G_MISS_CHAR;
523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;

Line 527: x_attribute14 := FND_API.G_MISS_CHAR;

523: x_attribute10 := FND_API.G_MISS_CHAR;
524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;

Line 528: x_attribute15 := FND_API.G_MISS_CHAR;

524: x_attribute11 := FND_API.G_MISS_CHAR;
525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;

Line 529: x_attribute2 := FND_API.G_MISS_CHAR;

525: x_attribute12 := FND_API.G_MISS_CHAR;
526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;

Line 530: x_attribute3 := FND_API.G_MISS_CHAR;

526: x_attribute13 := FND_API.G_MISS_CHAR;
527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;

Line 531: x_attribute4 := FND_API.G_MISS_CHAR;

527: x_attribute14 := FND_API.G_MISS_CHAR;
528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;

Line 532: x_attribute5 := FND_API.G_MISS_CHAR;

528: x_attribute15 := FND_API.G_MISS_CHAR;
529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;

Line 533: x_attribute6 := FND_API.G_MISS_CHAR;

529: x_attribute2 := FND_API.G_MISS_CHAR;
530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;

Line 534: x_attribute7 := FND_API.G_MISS_CHAR;

530: x_attribute3 := FND_API.G_MISS_CHAR;
531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;

Line 535: x_attribute8 := FND_API.G_MISS_CHAR;

531: x_attribute4 := FND_API.G_MISS_CHAR;
532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;

Line 536: x_attribute9 := FND_API.G_MISS_CHAR;

532: x_attribute5 := FND_API.G_MISS_CHAR;
533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;

Line 537: x_context := FND_API.G_MISS_CHAR;

533: x_attribute6 := FND_API.G_MISS_CHAR;
534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;

Line 538: x_discount_line_id := FND_API.G_MISS_NUM;

534: x_attribute7 := FND_API.G_MISS_CHAR;
535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;

Line 539: x_end_date_active := FND_API.G_MISS_DATE;

535: x_attribute8 := FND_API.G_MISS_CHAR;
536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;

Line 540: x_method_type_code := FND_API.G_MISS_CHAR;

536: x_attribute9 := FND_API.G_MISS_CHAR;
537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;

Line 541: x_percent := FND_API.G_MISS_NUM;

537: x_context := FND_API.G_MISS_CHAR;
538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;

Line 542: x_price := FND_API.G_MISS_NUM;

538: x_discount_line_id := FND_API.G_MISS_NUM;
539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;

Line 543: x_price_break_high := FND_API.G_MISS_NUM;

539: x_end_date_active := FND_API.G_MISS_DATE;
540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;

Line 544: x_price_break_low := FND_API.G_MISS_NUM;

540: x_method_type_code := FND_API.G_MISS_CHAR;
541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;
548: x_method_type := FND_API.G_MISS_CHAR;

Line 545: x_start_date_active := FND_API.G_MISS_DATE;

541: x_percent := FND_API.G_MISS_NUM;
542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;
548: x_method_type := FND_API.G_MISS_CHAR;
549: x_unit := FND_API.G_MISS_CHAR;

Line 546: x_unit_code := FND_API.G_MISS_CHAR;

542: x_price := FND_API.G_MISS_NUM;
543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;
548: x_method_type := FND_API.G_MISS_CHAR;
549: x_unit := FND_API.G_MISS_CHAR;
550:

Line 547: x_discount_line := FND_API.G_MISS_CHAR;

543: x_price_break_high := FND_API.G_MISS_NUM;
544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;
548: x_method_type := FND_API.G_MISS_CHAR;
549: x_unit := FND_API.G_MISS_CHAR;
550:
551: -- Load display out parameters if any

Line 548: x_method_type := FND_API.G_MISS_CHAR;

544: x_price_break_low := FND_API.G_MISS_NUM;
545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;
548: x_method_type := FND_API.G_MISS_CHAR;
549: x_unit := FND_API.G_MISS_CHAR;
550:
551: -- Load display out parameters if any
552:

Line 549: x_unit := FND_API.G_MISS_CHAR;

545: x_start_date_active := FND_API.G_MISS_DATE;
546: x_unit_code := FND_API.G_MISS_CHAR;
547: x_discount_line := FND_API.G_MISS_CHAR;
548: x_method_type := FND_API.G_MISS_CHAR;
549: x_unit := FND_API.G_MISS_CHAR;
550:
551: -- Load display out parameters if any
552:
553: l_Price_Break_val_rec := OE_Price_Break_Util.Get_Values

Line 728: x_return_status := FND_API.G_RET_STS_SUCCESS;

724: );
725:
726: -- Set return status.
727:
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: -- Get message count and data
731:
732: OE_MSG_PUB.Count_And_Get

Line 740: WHEN FND_API.G_EXC_ERROR THEN

736:
737:
738: EXCEPTION
739:
740: WHEN FND_API.G_EXC_ERROR THEN
741:
742: x_return_status := FND_API.G_RET_STS_ERROR;
743:
744: -- Get message count and data

Line 742: x_return_status := FND_API.G_RET_STS_ERROR;

738: EXCEPTION
739:
740: WHEN FND_API.G_EXC_ERROR THEN
741:
742: x_return_status := FND_API.G_RET_STS_ERROR;
743:
744: -- Get message count and data
745:
746: OE_MSG_PUB.Count_And_Get

Line 751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

747: ( p_count => x_msg_count
748: , p_data => x_msg_data
749: );
750:
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752:
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: -- Get message count and data

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

749: );
750:
751: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
752:
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: -- Get message count and data
756:
757: OE_MSG_PUB.Count_And_Get

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

760: );
761:
762: WHEN OTHERS THEN
763:
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765:
766: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: OE_MSG_PUB.Add_Exc_Msg

Line 878: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;

874: -- Load Price List Line records for price breaks
875: ---------------------------------------------
876:
877: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
878: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;
879:
880: select sysdate into l_Price_LLine_rec.creation_date
881: from dual;
882:

Line 909: , p_init_msg_list => FND_API.G_TRUE

905: oe_debug_pub.add('Price List IDS' || l_Price_LLine_rec.price_list_line_id );
906:
907: OE_Pricing_Cont_PVT.Process_Pricing_Cont
908: ( p_api_version_number => 1.0
909: , p_init_msg_list => FND_API.G_TRUE
910: , x_return_status => l_return_status
911: , x_msg_count => x_msg_count
912: , x_msg_data => x_msg_data
913: , p_control_rec => l_control_rec

Line 942: x_return_status := FND_API.G_RET_STS_SUCCESS;

938:
939:
940: -- Set return status.
941:
942: x_return_status := FND_API.G_RET_STS_SUCCESS;
943:
944: -- Get message count and data
945:
946: OE_MSG_PUB.Count_And_Get

Line 954: WHEN FND_API.G_EXC_ERROR THEN

950:
951:
952: EXCEPTION
953:
954: WHEN FND_API.G_EXC_ERROR THEN
955:
956: x_return_status := FND_API.G_RET_STS_ERROR;
957:
958: -- Get message count and data

Line 956: x_return_status := FND_API.G_RET_STS_ERROR;

952: EXCEPTION
953:
954: WHEN FND_API.G_EXC_ERROR THEN
955:
956: x_return_status := FND_API.G_RET_STS_ERROR;
957:
958: -- Get message count and data
959:
960: OE_MSG_PUB.Count_And_Get

Line 965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

961: ( p_count => x_msg_count
962: , p_data => x_msg_data
963: );
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966:
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
968:
969: -- Get message count and data

Line 967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

963: );
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966:
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
968:
969: -- Get message count and data
970:
971: OE_MSG_PUB.Count_And_Get

Line 979: /* x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

975:
976: WHEN OTHERS THEN
977:
978: null;
979: /* x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
980:
981: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
982: THEN
983: OE_MSG_PUB.Add_Exc_Msg

Line 1217: , p_init_msg_list => FND_API.G_TRUE

1213: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1214:
1215: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1216: ( p_api_version_number => 1.0
1217: , p_init_msg_list => FND_API.G_TRUE
1218: , x_return_status => l_return_status
1219: , x_msg_count => x_msg_count
1220: , x_msg_data => x_msg_data
1221: , p_control_rec => l_control_rec

Line 1233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1229: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1230: , x_Price_Break_tbl => l_x_Price_Break_tbl
1231: );
1232:
1233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;

Line 1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1230: , x_Price_Break_tbl => l_x_Price_Break_tbl
1231: );
1232:
1233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238:

Line 1235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1231: );
1232:
1233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238:
1239:

Line 1236: RAISE FND_API.G_EXC_ERROR;

1232:
1233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238:
1239:
1240: -- Clear Price_Break record cache

Line 1246: x_return_status := FND_API.G_RET_STS_SUCCESS;

1242: Clear_Price_Break;
1243:
1244: -- Set return status.
1245:
1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247:
1248: -- Get message count and data
1249:
1250: OE_MSG_PUB.Count_And_Get

Line 1258: WHEN FND_API.G_EXC_ERROR THEN

1254:
1255:
1256: EXCEPTION
1257:
1258: WHEN FND_API.G_EXC_ERROR THEN
1259:
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261:
1262: -- Get message count and data

Line 1260: x_return_status := FND_API.G_RET_STS_ERROR;

1256: EXCEPTION
1257:
1258: WHEN FND_API.G_EXC_ERROR THEN
1259:
1260: x_return_status := FND_API.G_RET_STS_ERROR;
1261:
1262: -- Get message count and data
1263:
1264: OE_MSG_PUB.Count_And_Get

Line 1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1265: ( p_count => x_msg_count
1266: , p_data => x_msg_data
1267: );
1268:
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270:
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272:
1273: -- Get message count and data

Line 1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1267: );
1268:
1269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1270:
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1272:
1273: -- Get message count and data
1274:
1275: OE_MSG_PUB.Count_And_Get

Line 1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1278: );
1279:
1280: WHEN OTHERS THEN
1281:
1282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1283:
1284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1285: THEN
1286: OE_MSG_PUB.Add_Exc_Msg

Line 1346: , p_init_msg_list => FND_API.G_TRUE

1342: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1343:
1344: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1345: ( p_api_version_number => 1.0
1346: , p_init_msg_list => FND_API.G_TRUE
1347: , x_return_status => l_return_status
1348: , x_msg_count => x_msg_count
1349: , x_msg_data => x_msg_data
1350: , p_control_rec => l_control_rec

Line 1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1357: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1358: , x_Price_Break_tbl => l_x_Price_Break_tbl
1359: );
1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;

Line 1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1358: , x_Price_Break_tbl => l_x_Price_Break_tbl
1359: );
1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:

Line 1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1359: );
1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:
1367:

Line 1364: RAISE FND_API.G_EXC_ERROR;

1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:
1367:
1368: -- Set return status.

Line 1370: x_return_status := FND_API.G_RET_STS_SUCCESS;

1366:
1367:
1368: -- Set return status.
1369:
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: -- Get message count and data
1373:
1374: OE_MSG_PUB.Count_And_Get

Line 1382: WHEN FND_API.G_EXC_ERROR THEN

1378:
1379:
1380: EXCEPTION
1381:
1382: WHEN FND_API.G_EXC_ERROR THEN
1383:
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385:
1386: -- Get message count and data

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR;

1380: EXCEPTION
1381:
1382: WHEN FND_API.G_EXC_ERROR THEN
1383:
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385:
1386: -- Get message count and data
1387:
1388: OE_MSG_PUB.Count_And_Get

Line 1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1389: ( p_count => x_msg_count
1390: , p_data => x_msg_data
1391: );
1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394:
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396:
1397: -- Get message count and data

Line 1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1391: );
1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394:
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396:
1397: -- Get message count and data
1398:
1399: OE_MSG_PUB.Count_And_Get

Line 1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1402: );
1403:
1404: WHEN OTHERS THEN
1405:
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1407:
1408: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1409: THEN
1410: OE_MSG_PUB.Add_Exc_Msg

Line 1532: , p_init_msg_list => FND_API.G_TRUE

1528: -- Call OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1529:
1530: OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1531: ( p_api_version_number => 1.0
1532: , p_init_msg_list => FND_API.G_TRUE
1533: , x_return_status => l_return_status
1534: , x_msg_count => x_msg_count
1535: , x_msg_data => x_msg_data
1536: , p_Price_Break_tbl => l_Price_Break_tbl

Line 1547: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1543: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1544: , x_Price_Break_tbl => l_x_Price_Break_tbl
1545: );
1546:
1547: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1548:
1549: -- Set DB flag and write record to cache.
1550:
1551: l_x_Price_Break_rec.db_flag := FND_API.G_TRUE;

Line 1551: l_x_Price_Break_rec.db_flag := FND_API.G_TRUE;

1547: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1548:
1549: -- Set DB flag and write record to cache.
1550:
1551: l_x_Price_Break_rec.db_flag := FND_API.G_TRUE;
1552:
1553: Write_Price_Break
1554: ( p_Price_Break_rec => l_x_Price_Break_rec
1555: , p_db_record => TRUE

Line 1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1580: , 'Lock_Row'
1581: );
1582: END IF;
1583:
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1585:
1586: -- Get message count and data
1587:
1588: OE_MSG_PUB.Count_And_Get

Line 1638: g_Price_Break_rec.db_flag := FND_API.G_TRUE;

1634: , p_price_break_high => p_price_break_high
1635: , p_price_break_low => p_price_break_low
1636: );
1637:
1638: g_Price_Break_rec.db_flag := FND_API.G_TRUE;
1639:
1640: -- Load DB record
1641:
1642: g_db_Price_Break_rec := g_Price_Break_rec;