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_PRICE_LIST_PVT dependencies on FND_API

Line 55: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;

51: );
52:
53: -- Set record return status.
54:
55: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: -- Prepare record.
58:
59: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 61: l_PRICE_LIST_rec.db_flag := FND_API.G_FALSE;

57: -- Prepare record.
58:
59: IF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
60:
61: l_PRICE_LIST_rec.db_flag := FND_API.G_FALSE;
62:
63: -- Set missing old record elements to NULL.
64:
65: l_old_PRICE_LIST_rec :=

Line 72: l_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;

68: ELSIF l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_UPDATE
69: OR l_PRICE_LIST_rec.operation = OE_GLOBALS.G_OPR_DELETE
70: THEN
71:
72: l_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;
73:
74: -- Query Old if missing
75:
76: IF l_old_PRICE_LIST_rec.Name = FND_API.G_MISS_CHAR

Line 76: IF l_old_PRICE_LIST_rec.Name = FND_API.G_MISS_CHAR

72: l_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;
73:
74: -- Query Old if missing
75:
76: IF l_old_PRICE_LIST_rec.Name = FND_API.G_MISS_CHAR
77: OR l_old_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
78: THEN
79:
80: l_old_PRICE_LIST_rec := OE_Price_List_Util.Query_Row

Line 77: OR l_old_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM

73:
74: -- Query Old if missing
75:
76: IF l_old_PRICE_LIST_rec.Name = FND_API.G_MISS_CHAR
77: OR l_old_PRICE_LIST_rec.price_list_id = FND_API.G_MISS_NUM
78: THEN
79:
80: l_old_PRICE_LIST_rec := OE_Price_List_Util.Query_Row
81: ( p_name => l_PRICE_LIST_rec.name

Line 109: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

105: IF l_control_rec.default_attributes
106: OR l_control_rec.change_attributes
107: THEN
108:
109: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
110:
111: OE_Validate_Price_List.Attributes
112: ( x_return_status => l_return_status
113: , p_PRICE_LIST_rec => l_PRICE_LIST_rec

Line 117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

113: , p_PRICE_LIST_rec => l_PRICE_LIST_rec
114: , p_old_PRICE_LIST_rec => l_old_PRICE_LIST_rec
115: );
116:
117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

114: , p_old_PRICE_LIST_rec => l_old_PRICE_LIST_rec
115: );
116:
117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:

Line 119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

115: );
116:
117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: END IF;

Line 120: RAISE FND_API.G_EXC_ERROR;

116:
117: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: END IF;
124:

Line 187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

183: );
184:
185: END IF;
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

184:
185: END IF;
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:

Line 189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

185: END IF;
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: END IF;

Line 190: RAISE FND_API.G_EXC_ERROR;

186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: END IF;
194:

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;
235:
236: EXCEPTION
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239:
240: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
241: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
242: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;

Line 240: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;

236: EXCEPTION
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239:
240: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
241: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
242: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;
243: RAISE;
244:

Line 245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

241: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
242: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;
243: RAISE;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
249: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;

Line 247: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: RAISE;
244:
245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
246:
247: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
249: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;
250:
251: RAISE;

Line 263: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: , 'Price_List'
260: );
261: END IF;
262:
263: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
265: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;
266:
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

263: l_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: x_PRICE_LIST_rec := l_PRICE_LIST_rec;
265: x_old_PRICE_LIST_rec := l_old_PRICE_LIST_rec;
266:
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268:
269: END Price_List;
270:
271: -- Price_List_Lines

Line 318: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;

314: );
315:
316: -- Set record return status.
317:
318: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: -- Prepare record.
321:
322: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

Line 324: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_FALSE;

320: -- Prepare record.
321:
322: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
323:
324: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_FALSE;
325:
326: -- Set missing old record elements to NULL.
327:
328: l_old_PRICE_LIST_LINE_rec :=

Line 335: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

331: ELSIF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_UPDATE
332: OR l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_DELETE
333: THEN
334:
335: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
336:
337: -- Query Old if missing
338:
339: IF l_old_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM

Line 339: IF l_old_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM

335: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
336:
337: -- Query Old if missing
338:
339: IF l_old_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM
340: THEN
341:
342: l_old_PRICE_LIST_LINE_rec := OE_Price_List_Line_Util.Query_Row
343: ( p_price_list_line_id => l_PRICE_LIST_LINE_rec.price_list_line_id

Line 371: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

367: IF l_control_rec.default_attributes
368: OR l_control_rec.change_attributes
369: THEN
370:
371: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
372:
373: OE_Validate_Price_List_Line.Attributes
374: ( x_return_status => l_return_status
375: , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec

Line 379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

375: , p_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
376: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
377: );
378:
379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: , p_old_PRICE_LIST_LINE_rec => l_old_PRICE_LIST_LINE_rec
377: );
378:
379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:

Line 381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

377: );
378:
379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:
385: END IF;

Line 382: RAISE FND_API.G_EXC_ERROR;

378:
379: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
382: RAISE FND_API.G_EXC_ERROR;
383: END IF;
384:
385: END IF;
386:

Line 449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

445: );
446:
447: END IF;
448:
449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;

Line 450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

446:
447: END IF;
448:
449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:

Line 451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

447: END IF;
448:
449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:
455: END IF;

Line 452: RAISE FND_API.G_EXC_ERROR;

448:
449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: END IF;
454:
455: END IF;
456:

Line 502: WHEN FND_API.G_EXC_ERROR THEN

498:
499:
500: EXCEPTION
501:
502: WHEN FND_API.G_EXC_ERROR THEN
503:
504: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
505: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
506: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;

Line 504: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;

500: EXCEPTION
501:
502: WHEN FND_API.G_EXC_ERROR THEN
503:
504: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
505: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
506: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
505: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
506: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509:
510: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
512: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;

Line 510: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509:
510: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
512: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514:

Line 513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

509:
510: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
512: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514:
515: WHEN OTHERS THEN
516:
517: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 517: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
514:
515: WHEN OTHERS THEN
516:
517: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: l_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
519: l_old_PRICE_LIST_LINE_tbl(I) := l_old_PRICE_LIST_LINE_rec;
520:
521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

525: , 'Price_List_Lines'
526: );
527: END IF;
528:
529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
530:
531: END;
532: END LOOP;
533:

Line 541: WHEN FND_API.G_EXC_ERROR THEN

537: x_old_PRICE_LIST_LINE_tbl := l_old_PRICE_LIST_LINE_tbl;
538:
539: EXCEPTION
540:
541: WHEN FND_API.G_EXC_ERROR THEN
542:
543: RAISE;
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: WHEN FND_API.G_EXC_ERROR THEN
542:
543: RAISE;
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546:
547:
548: RAISE;
549:

Line 561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

557: );
558: END IF;
559:
560:
561: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
562:
563: END Price_List_Lines;
564:
565: -- Start of Comments

Line 583: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

579: -- End of Comments
580:
581: PROCEDURE Process_Price_List
582: ( p_api_version_number IN NUMBER
583: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
584: , p_commit IN VARCHAR2 := FND_API.G_FALSE
585: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
586: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
587: OE_GLOBALS.G_MISS_CONTROL_REC

Line 584: , p_commit IN VARCHAR2 := FND_API.G_FALSE

580:
581: PROCEDURE Process_Price_List
582: ( p_api_version_number IN NUMBER
583: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
584: , p_commit IN VARCHAR2 := FND_API.G_FALSE
585: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
586: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
587: OE_GLOBALS.G_MISS_CONTROL_REC
588: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 585: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

581: PROCEDURE Process_Price_List
582: ( p_api_version_number IN NUMBER
583: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
584: , p_commit IN VARCHAR2 := FND_API.G_FALSE
585: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
586: , p_control_rec IN OE_GLOBALS.Control_Rec_Type :=
587: OE_GLOBALS.G_MISS_CONTROL_REC
588: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
589: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 621: IF NOT FND_API.Compatible_API_Call

617: BEGIN
618:
619: -- Standard call to check for call compatibility
620:
621: IF NOT FND_API.Compatible_API_Call
622: ( l_api_version_number
623: , p_api_version_number
624: , l_api_name
625: , G_PKG_NAME

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

624: , l_api_name
625: , G_PKG_NAME
626: )
627: THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: -- Initialize message list.
632:

Line 633: IF FND_API.to_Boolean(p_init_msg_list) THEN

629: END IF;
630:
631: -- Initialize message list.
632:
633: IF FND_API.to_Boolean(p_init_msg_list) THEN
634: OE_MSG_PUB.initialize;
635: END IF;
636:
637: -- Init local table variables.

Line 673: -- l_PRICE_LIST_LINE_rec.name = FND_API.G_MISS_CHAR)

669: l_PRICE_LIST_LINE_rec := l_PRICE_LIST_LINE_tbl(I);
670:
671: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE
672: -- AND (l_PRICE_LIST_LINE_rec.name IS NULL OR
673: -- l_PRICE_LIST_LINE_rec.name = FND_API.G_MISS_CHAR)
674: AND (l_PRICE_LIST_LINE_rec.price_list_id IS NULL OR
675: l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM)
676: THEN
677:

Line 675: l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM)

671: IF l_PRICE_LIST_LINE_rec.operation = OE_GLOBALS.G_OPR_CREATE
672: -- AND (l_PRICE_LIST_LINE_rec.name IS NULL OR
673: -- l_PRICE_LIST_LINE_rec.name = FND_API.G_MISS_CHAR)
674: AND (l_PRICE_LIST_LINE_rec.price_list_id IS NULL OR
675: l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM)
676: THEN
677:
678: -- Copy parent_id.
679:

Line 741: x_return_status := FND_API.G_RET_STS_SUCCESS;

737: END IF;
738:
739: -- Derive return status.
740:
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: IF l_PRICE_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: END IF;

Line 743: IF l_PRICE_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN

739: -- Derive return status.
740:
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: IF l_PRICE_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: END IF;
746:
747: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP

Line 744: x_return_status := FND_API.G_RET_STS_ERROR;

740:
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: IF l_PRICE_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: END IF;
746:
747: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
748:

Line 749: IF l_PRICE_LIST_LINE_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

745: END IF;
746:
747: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
748:
749: IF l_PRICE_LIST_LINE_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752:
753: END LOOP;

Line 750: x_return_status := FND_API.G_RET_STS_ERROR;

746:
747: FOR I IN 1..l_PRICE_LIST_LINE_tbl.COUNT LOOP
748:
749: IF l_PRICE_LIST_LINE_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: END IF;
752:
753: END LOOP;
754:

Line 765: WHEN FND_API.G_EXC_ERROR THEN

761:
762:
763: EXCEPTION
764:
765: WHEN FND_API.G_EXC_ERROR THEN
766:
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: -- Get message count and data

Line 767: x_return_status := FND_API.G_RET_STS_ERROR;

763: EXCEPTION
764:
765: WHEN FND_API.G_EXC_ERROR THEN
766:
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: -- Get message count and data
770:
771: OE_MSG_PUB.Count_And_Get

Line 776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

772: ( p_count => x_msg_count
773: , p_data => x_msg_data
774: );
775:
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777:
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779:
780: -- Get message count and data

Line 778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

774: );
775:
776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
777:
778: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
779:
780: -- Get message count and data
781:
782: OE_MSG_PUB.Count_And_Get

Line 789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

785: );
786:
787: WHEN OTHERS THEN
788:
789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
792: THEN
793: OE_MSG_PUB.Add_Exc_Msg

Line 826: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

822: -- End of Comments
823:
824: PROCEDURE Lock_Price_List
825: ( p_api_version_number IN NUMBER
826: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
827: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
828: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
829: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
830: , p_PRICE_LIST_rec IN OE_Price_List_PUB.Price_List_Rec_Type :=

Line 840: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

836: )
837: IS
838: l_api_version_number CONSTANT NUMBER := 1.0;
839: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Price_List';
840: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
841: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
842: BEGIN
843:
844: -- Standard call to check for call compatibility

Line 846: IF NOT FND_API.Compatible_API_Call

842: BEGIN
843:
844: -- Standard call to check for call compatibility
845:
846: IF NOT FND_API.Compatible_API_Call
847: ( l_api_version_number
848: , p_api_version_number
849: , l_api_name
850: , G_PKG_NAME

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

849: , l_api_name
850: , G_PKG_NAME
851: )
852: THEN
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854: END IF;
855:
856: -- Initialize message list.
857:

Line 858: IF FND_API.to_Boolean(p_init_msg_list) THEN

854: END IF;
855:
856: -- Initialize message list.
857:
858: IF FND_API.to_Boolean(p_init_msg_list) THEN
859: OE_MSG_PUB.initialize;
860: END IF;
861:
862: -- Set Savepoint

Line 876: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

872: , x_PRICE_LIST_rec => x_PRICE_LIST_rec
873: , x_return_status => l_return_status
874: );
875:
876: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;

Line 877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

873: , x_return_status => l_return_status
874: );
875:
876: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:

Line 878: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

874: );
875:
876: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882:

Line 879: RAISE FND_API.G_EXC_ERROR;

875:
876: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
879: RAISE FND_API.G_EXC_ERROR;
880: END IF;
881:
882:
883: END IF;

Line 897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

893: , x_PRICE_LIST_LINE_rec => l_PRICE_LIST_LINE_rec
894: , x_return_status => l_return_status
895: );
896:
897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;

Line 898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

894: , x_return_status => l_return_status
895: );
896:
897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:

Line 899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

895: );
896:
897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: x_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;

Line 900: RAISE FND_API.G_EXC_ERROR;

896:
897: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902:
903: x_PRICE_LIST_LINE_tbl(I) := l_PRICE_LIST_LINE_rec;
904:

Line 911: x_return_status := FND_API.G_RET_STS_SUCCESS;

907: END LOOP;
908:
909: -- Set return status
910:
911: x_return_status := FND_API.G_RET_STS_SUCCESS;
912:
913: -- Get message count and data
914:
915: OE_MSG_PUB.Count_And_Get

Line 923: WHEN FND_API.G_EXC_ERROR THEN

919:
920:
921: EXCEPTION
922:
923: WHEN FND_API.G_EXC_ERROR THEN
924:
925: x_return_status := FND_API.G_RET_STS_ERROR;
926:
927: -- Get message count and data

Line 925: x_return_status := FND_API.G_RET_STS_ERROR;

921: EXCEPTION
922:
923: WHEN FND_API.G_EXC_ERROR THEN
924:
925: x_return_status := FND_API.G_RET_STS_ERROR;
926:
927: -- Get message count and data
928:
929: OE_MSG_PUB.Count_And_Get

Line 938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

934: -- Rollback
935:
936: ROLLBACK TO Lock_Price_List_PVT;
937:
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939:
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941:
942: -- Get message count and data

Line 940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

936: ROLLBACK TO Lock_Price_List_PVT;
937:
938: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
939:
940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
941:
942: -- Get message count and data
943:
944: OE_MSG_PUB.Count_And_Get

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

951: ROLLBACK TO Lock_Price_List_PVT;
952:
953: WHEN OTHERS THEN
954:
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956:
957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
958: THEN
959: OE_MSG_PUB.Add_Exc_Msg

Line 996: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

992: -- End of Comments
993:
994: PROCEDURE Get_Price_List
995: ( p_api_version_number IN NUMBER
996: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
997: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
998: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
999: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1000: , p_name IN VARCHAR2

Line 1014: IF NOT FND_API.Compatible_API_Call

1010: BEGIN
1011:
1012: -- Standard call to check for call compatibility
1013:
1014: IF NOT FND_API.Compatible_API_Call
1015: ( l_api_version_number
1016: , p_api_version_number
1017: , l_api_name
1018: , G_PKG_NAME

Line 1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1017: , l_api_name
1018: , G_PKG_NAME
1019: )
1020: THEN
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022: END IF;
1023:
1024: -- Initialize message list.
1025:

Line 1026: IF FND_API.to_Boolean(p_init_msg_list) THEN

1022: END IF;
1023:
1024: -- Initialize message list.
1025:
1026: IF FND_API.to_Boolean(p_init_msg_list) THEN
1027: OE_MSG_PUB.initialize;
1028: END IF;
1029:
1030: -- Get PRICE_LIST ( parent = PRICE_LIST )

Line 1052: x_return_status := FND_API.G_RET_STS_SUCCESS;

1048: x_PRICE_LIST_LINE_tbl := l_PRICE_LIST_LINE_tbl;
1049:
1050: -- Set return status
1051:
1052: x_return_status := FND_API.G_RET_STS_SUCCESS;
1053:
1054: -- Get message count and data
1055:
1056: OE_MSG_PUB.Count_And_Get

Line 1064: WHEN FND_API.G_EXC_ERROR THEN

1060:
1061:
1062: EXCEPTION
1063:
1064: WHEN FND_API.G_EXC_ERROR THEN
1065:
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067:
1068: -- Get message count and data

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

1062: EXCEPTION
1063:
1064: WHEN FND_API.G_EXC_ERROR THEN
1065:
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067:
1068: -- Get message count and data
1069:
1070: OE_MSG_PUB.Count_And_Get

Line 1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1071: ( p_count => x_msg_count
1072: , p_data => x_msg_data
1073: );
1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076:
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078:
1079: -- Get message count and data

Line 1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1073: );
1074:
1075: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1076:
1077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1078:
1079: -- Get message count and data
1080:
1081: OE_MSG_PUB.Count_And_Get

Line 1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1084: );
1085:
1086: WHEN OTHERS THEN
1087:
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089:
1090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1091: THEN
1092: OE_MSG_PUB.Add_Exc_Msg

Line 1109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,

1105: END Get_Price_List;
1106:
1107: PROCEDURE Fetch_List_Price
1108: ( p_api_version_number IN NUMBER ,
1109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1111: p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1112: p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
1113: p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,

Line 1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

1106:
1107: PROCEDURE Fetch_List_Price
1108: ( p_api_version_number IN NUMBER ,
1109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
1111: p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1112: p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
1113: p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
1114: p_price_list_id IN NUMBER := NULL ,

Line 1194: IF p_pricing_attribute1 = FND_API.G_MISS_CHAR THEN

1190:
1191:
1192: --Make sure there is no MISS Charaters
1193:
1194: IF p_pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1195: l_pricing_attribute1 := NULL;
1196: END IF;
1197:
1198: IF (p_pricing_attribute2 = FND_API.G_MISS_CHAR) THEN

Line 1198: IF (p_pricing_attribute2 = FND_API.G_MISS_CHAR) THEN

1194: IF p_pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1195: l_pricing_attribute1 := NULL;
1196: END IF;
1197:
1198: IF (p_pricing_attribute2 = FND_API.G_MISS_CHAR) THEN
1199: l_pricing_attribute2:=NULL;
1200: END IF;
1201:
1202: IF (p_pricing_attribute3 = FND_API.G_MISS_CHAR) THEN

Line 1202: IF (p_pricing_attribute3 = FND_API.G_MISS_CHAR) THEN

1198: IF (p_pricing_attribute2 = FND_API.G_MISS_CHAR) THEN
1199: l_pricing_attribute2:=NULL;
1200: END IF;
1201:
1202: IF (p_pricing_attribute3 = FND_API.G_MISS_CHAR) THEN
1203: l_pricing_attribute3:=NULL;
1204: END IF;
1205:
1206: IF (p_pricing_attribute4 = FND_API.G_MISS_CHAR) THEN

Line 1206: IF (p_pricing_attribute4 = FND_API.G_MISS_CHAR) THEN

1202: IF (p_pricing_attribute3 = FND_API.G_MISS_CHAR) THEN
1203: l_pricing_attribute3:=NULL;
1204: END IF;
1205:
1206: IF (p_pricing_attribute4 = FND_API.G_MISS_CHAR) THEN
1207: l_pricing_attribute4:=NULL;
1208: END IF;
1209:
1210: IF (p_pricing_attribute5 = FND_API.G_MISS_CHAR) THEN

Line 1210: IF (p_pricing_attribute5 = FND_API.G_MISS_CHAR) THEN

1206: IF (p_pricing_attribute4 = FND_API.G_MISS_CHAR) THEN
1207: l_pricing_attribute4:=NULL;
1208: END IF;
1209:
1210: IF (p_pricing_attribute5 = FND_API.G_MISS_CHAR) THEN
1211: l_pricing_attribute5:=NULL;
1212: END IF;
1213:
1214: IF (p_pricing_attribute6 = FND_API.G_MISS_CHAR) THEN

Line 1214: IF (p_pricing_attribute6 = FND_API.G_MISS_CHAR) THEN

1210: IF (p_pricing_attribute5 = FND_API.G_MISS_CHAR) THEN
1211: l_pricing_attribute5:=NULL;
1212: END IF;
1213:
1214: IF (p_pricing_attribute6 = FND_API.G_MISS_CHAR) THEN
1215: l_pricing_attribute6:=NULL;
1216: END IF;
1217:
1218: IF (p_pricing_attribute7 = FND_API.G_MISS_CHAR) THEN

Line 1218: IF (p_pricing_attribute7 = FND_API.G_MISS_CHAR) THEN

1214: IF (p_pricing_attribute6 = FND_API.G_MISS_CHAR) THEN
1215: l_pricing_attribute6:=NULL;
1216: END IF;
1217:
1218: IF (p_pricing_attribute7 = FND_API.G_MISS_CHAR) THEN
1219: l_pricing_attribute7:=NULL;
1220: END IF;
1221:
1222: IF (p_pricing_attribute8 = FND_API.G_MISS_CHAR) THEN

Line 1222: IF (p_pricing_attribute8 = FND_API.G_MISS_CHAR) THEN

1218: IF (p_pricing_attribute7 = FND_API.G_MISS_CHAR) THEN
1219: l_pricing_attribute7:=NULL;
1220: END IF;
1221:
1222: IF (p_pricing_attribute8 = FND_API.G_MISS_CHAR) THEN
1223: l_pricing_attribute8:=NULL;
1224: END IF;
1225:
1226: IF (p_pricing_attribute9 = FND_API.G_MISS_CHAR) THEN

Line 1226: IF (p_pricing_attribute9 = FND_API.G_MISS_CHAR) THEN

1222: IF (p_pricing_attribute8 = FND_API.G_MISS_CHAR) THEN
1223: l_pricing_attribute8:=NULL;
1224: END IF;
1225:
1226: IF (p_pricing_attribute9 = FND_API.G_MISS_CHAR) THEN
1227: l_pricing_attribute9:=NULL;
1228: END IF;
1229:
1230: IF (p_pricing_attribute10 = FND_API.G_MISS_CHAR) THEN

Line 1230: IF (p_pricing_attribute10 = FND_API.G_MISS_CHAR) THEN

1226: IF (p_pricing_attribute9 = FND_API.G_MISS_CHAR) THEN
1227: l_pricing_attribute9:=NULL;
1228: END IF;
1229:
1230: IF (p_pricing_attribute10 = FND_API.G_MISS_CHAR) THEN
1231: l_pricing_attribute10 := NULL;
1232: END IF;
1233:
1234: IF (p_pricing_attribute11 = FND_API.G_MISS_CHAR) THEN

Line 1234: IF (p_pricing_attribute11 = FND_API.G_MISS_CHAR) THEN

1230: IF (p_pricing_attribute10 = FND_API.G_MISS_CHAR) THEN
1231: l_pricing_attribute10 := NULL;
1232: END IF;
1233:
1234: IF (p_pricing_attribute11 = FND_API.G_MISS_CHAR) THEN
1235: l_pricing_attribute11 := NULL;
1236: END IF;
1237:
1238: IF (p_pricing_attribute12 = FND_API.G_MISS_CHAR) THEN

Line 1238: IF (p_pricing_attribute12 = FND_API.G_MISS_CHAR) THEN

1234: IF (p_pricing_attribute11 = FND_API.G_MISS_CHAR) THEN
1235: l_pricing_attribute11 := NULL;
1236: END IF;
1237:
1238: IF (p_pricing_attribute12 = FND_API.G_MISS_CHAR) THEN
1239: l_pricing_attribute12:=NULL;
1240: END IF;
1241:
1242: IF (p_pricing_attribute13 = FND_API.G_MISS_CHAR) THEN

Line 1242: IF (p_pricing_attribute13 = FND_API.G_MISS_CHAR) THEN

1238: IF (p_pricing_attribute12 = FND_API.G_MISS_CHAR) THEN
1239: l_pricing_attribute12:=NULL;
1240: END IF;
1241:
1242: IF (p_pricing_attribute13 = FND_API.G_MISS_CHAR) THEN
1243: l_pricing_attribute13:=NULL;
1244: END IF;
1245:
1246: IF (p_pricing_attribute14 = FND_API.G_MISS_CHAR) THEN

Line 1246: IF (p_pricing_attribute14 = FND_API.G_MISS_CHAR) THEN

1242: IF (p_pricing_attribute13 = FND_API.G_MISS_CHAR) THEN
1243: l_pricing_attribute13:=NULL;
1244: END IF;
1245:
1246: IF (p_pricing_attribute14 = FND_API.G_MISS_CHAR) THEN
1247: l_pricing_attribute14:=NULL;
1248: END IF;
1249:
1250: IF (p_pricing_attribute15 = FND_API.G_MISS_CHAR) THEN

Line 1250: IF (p_pricing_attribute15 = FND_API.G_MISS_CHAR) THEN

1246: IF (p_pricing_attribute14 = FND_API.G_MISS_CHAR) THEN
1247: l_pricing_attribute14:=NULL;
1248: END IF;
1249:
1250: IF (p_pricing_attribute15 = FND_API.G_MISS_CHAR) THEN
1251: l_pricing_attribute15:=NULL;
1252: END IF;
1253:
1254: -- Standard call to check for call compatibility

Line 1310: IF NOT FND_API.Compatible_API_Call

1306:
1307:
1308:
1309:
1310: IF NOT FND_API.Compatible_API_Call
1311: ( l_api_version_number,
1312: p_api_version_number,
1313: l_api_name ,
1314: G_PKG_NAME )

Line 1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1312: p_api_version_number,
1313: l_api_name ,
1314: G_PKG_NAME )
1315: THEN
1316: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1317: END IF;
1318:
1319: -- Initialize message list if p_init_msg_list is set to TRUE
1320:

Line 1321: IF FND_API.to_Boolean(p_init_msg_list) THEN

1317: END IF;
1318:
1319: -- Initialize message list if p_init_msg_list is set to TRUE
1320:
1321: IF FND_API.to_Boolean(p_init_msg_list) THEN
1322:
1323: OE_MSG_PUB.initialize;
1324:
1325: END IF;

Line 1329: p_return_status := FND_API.G_RET_STS_SUCCESS;

1325: END IF;
1326:
1327: -- Initialize p_return_status
1328:
1329: p_return_status := FND_API.G_RET_STS_SUCCESS;
1330:
1331: -- Validate Input. Start with mandatory validation.
1332:
1333: -- Fetch_attempts can not be greater that max attempts allowed

Line 1352: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN

1348:
1349: -- Validation that can be turned off through the use of
1350: -- validation level.
1351:
1352: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL THEN
1353:
1354: -- Validate :
1355: -- price_list_id
1356: -- item_id

Line 1369: RAISE FND_API.G_EXC_ERROR;

1365: END IF;
1366:
1367: IF l_validation_error THEN
1368: --DBMS_output.put_line('validation_error');
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371:
1372: -- Check required parameters.
1373:

Line 1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1694: );
1695:
1696: END IF;
1697:
1698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1699:
1700: END IF; -- prc_method_code
1701:
1702: p_price_list_id_out := p_price_list_id ;

Line 1739: FND_API.G_FALSE ,

1735: -- Call Fetch_List_Price using the sec list.
1736:
1737: Fetch_List_Price
1738: ( p_api_version_number ,
1739: FND_API.G_FALSE ,
1740: FND_API.G_VALID_LEVEL_NONE ,
1741: l_return_status ,
1742: p_msg_count ,
1743: p_msg_data ,

Line 1740: FND_API.G_VALID_LEVEL_NONE ,

1736:
1737: Fetch_List_Price
1738: ( p_api_version_number ,
1739: FND_API.G_FALSE ,
1740: FND_API.G_VALID_LEVEL_NONE ,
1741: l_return_status ,
1742: p_msg_count ,
1743: p_msg_data ,
1744: l_price_list_id ,

Line 1775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1771: p_list_percent ,
1772: p_rounding_factor
1773: );
1774:
1775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776:
1777: -- Unexpected error, abort processing
1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1779:

Line 1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1774:
1775: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776:
1777: -- Unexpected error, abort processing
1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1779:
1780: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1781:
1782: -- Error, abort processing

Line 1780: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1776:
1777: -- Unexpected error, abort processing
1778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1779:
1780: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1781:
1782: -- Error, abort processing
1783: RAISE FND_API.G_EXC_ERROR;
1784:

Line 1783: RAISE FND_API.G_EXC_ERROR;

1779:
1780: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1781:
1782: -- Error, abort processing
1783: RAISE FND_API.G_EXC_ERROR;
1784:
1785: ELSE
1786:
1787: -- Set p_list_price. We don't receive the

Line 1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1820:
1821:
1822: END IF;
1823:
1824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1825:
1826: END; -- BEGIN select list price block.
1827:
1828: -- At this point, All processing is done, and all the secondary

Line 1880: WHEN FND_API.G_EXC_ERROR THEN

1876:
1877:
1878: EXCEPTION
1879:
1880: WHEN FND_API.G_EXC_ERROR THEN
1881:
1882: p_return_status := FND_API.G_RET_STS_ERROR;
1883:
1884: -- Get message count and if 1, return message data

Line 1882: p_return_status := FND_API.G_RET_STS_ERROR;

1878: EXCEPTION
1879:
1880: WHEN FND_API.G_EXC_ERROR THEN
1881:
1882: p_return_status := FND_API.G_RET_STS_ERROR;
1883:
1884: -- Get message count and if 1, return message data
1885:
1886: OE_MSG_PUB.Count_And_Get

Line 1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1891: -- Decement G_Fetch_Level
1892:
1893: G_Fetch_Level := G_Fetch_Level - 1;
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896:
1897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1898:
1899: -- Get message count and if 1, return message data

Line 1897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1893: G_Fetch_Level := G_Fetch_Level - 1;
1894:
1895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1896:
1897: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1898:
1899: -- Get message count and if 1, return message data
1900:
1901: OE_MSG_PUB.Count_And_Get

Line 1913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1909:
1910:
1911: WHEN OTHERS THEN
1912:
1913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1914:
1915: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1916: OE_MSG_PUB.Add_Exc_Msg
1917: ( G_PKG_NAME ,

Line 1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1988: 'Get_Item_Description - p_item_id = '||p_item_id||
1989: ' org_id ='||l_org_id
1990: );
1991:
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993:
1994: END Get_Item_Description;
1995:
1996: FUNCTION Get_Unit_Name

Line 2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2019: ( G_PKG_NAME ,
2020: 'Get_Unit_Name - p_unit_code = '||p_unit_code
2021: );
2022:
2023: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2024:
2025: END Get_Unit_Name;
2026:
2027: