APPS.QP_PRICE_BOOK_PVT dependencies on FND_API

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

241: p_price_book_header_id IN NUMBER
242: )
243: IS
244:
245: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
246: l_return_status_text VARCHAR2(240) ;
247: l_count NUMBER := 0;
248:
249: TYPE GLOBAL_STRUCT_REC IS RECORD(seeded_value_string VARCHAR2(2000),

Line 535: RAISE FND_API.G_EXC_ERROR;

531: l_pb_line_count := 0;
532: END;
533:
534: IF l_pb_line_count = 0 THEN
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
538: -- SNIMMAGA.
539: --

Line 675: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

671:
672: fnd_file.put_line(FND_FILE.LOG, 'insert_lines2 return status '|| l_return_status);
673: fnd_file.put_line(FND_FILE.LOG, 'insert_lines2 return text'|| l_return_status_text);
674:
675: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
676: fnd_file.put_line(fnd_file.Log, ' Raising SQL Exception...');
677: RAISE SQL_EXCEPTION;
678: END IF;
679: END IF; --if l_line_type_code_tbl.count > 0

Line 1112: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1108:
1109: fnd_file.put_line(FND_FILE.LOG, 'insert_line_attrs2 return status '||l_return_status);
1110: fnd_file.put_line(FND_FILE.LOG, 'insert_line_attrs2 return text'||l_return_status_text);
1111:
1112: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE SQL_EXCEPTION;
1114: END IF;
1115:
1116: END IF; -- If l_attrs_line_index_tbl.count > 0

Line 1176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1172: fnd_file.put_line(fnd_file.Log, 'After Pricing Engine Call...');
1173: fnd_file.put_line(FND_FILE.LOG, 'Price_Request return status: '||l_return_status);
1174: fnd_file.put_line(FND_FILE.LOG, 'Price_Request return text: '||l_return_status_text);
1175:
1176: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE SQL_EXCEPTION;
1178: END IF;
1179:
1180: OPEN lines_cur;

Line 1435: WHEN FND_API.G_EXC_ERROR THEN

1431: END LOOP; --Loop over cursor insert_lines2_cur
1432: CLOSE insert_lines2_cur;
1433:
1434: EXCEPTION
1435: WHEN FND_API.G_EXC_ERROR THEN
1436: RAISE;
1437: WHEN OTHERS THEN
1438: RAISE;
1439: END Insert_Price_Book_Content;

Line 1995: WHEN FND_API.G_EXC_ERROR THEN

1991:
1992: fnd_file.put_line(FND_FILE.LOG, 'After inserting price book header'||
1993: to_char(l_publish_price_book_header_id));
1994: EXCEPTION
1995: WHEN FND_API.G_EXC_ERROR THEN
1996: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1997: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1998: l_pb_input_header_rec.price_book_name);
1999: l_message_text := FND_MESSAGE.GET;

Line 2044: WHEN FND_API.G_EXC_ERROR THEN

2040: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(
2041: p_pb_input_header_rec => l_pb_input_header_rec,
2042: x_price_book_header_id => l_publish_price_book_header_id);
2043: EXCEPTION
2044: WHEN FND_API.G_EXC_ERROR THEN
2045: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2046: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2047: l_pb_input_header_rec.price_book_name);
2048: l_message_text := FND_MESSAGE.GET;

Line 2436: WHEN FND_API.G_EXC_ERROR THEN

2432: p_pb_input_header_rec => l_pb_input_header_rec,
2433: p_pb_input_lines_tbl => l_pb_input_lines_tbl,
2434: p_price_book_header_id => p_price_book_header_id);
2435: EXCEPTION
2436: WHEN FND_API.G_EXC_ERROR THEN
2437: l_price_book_messages_tbl(i).message_code :=
2438: 'QP_NO_PB_LINES_TO_PRICE';
2439: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');
2440: l_message_text := FND_MESSAGE.GET;

Line 2601: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2597: l_return_status,
2598: l_return_status_text
2599: );
2600:
2601: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2603: END IF;
2604:
2605: /** KDURGASI **/

Line 2602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2598: l_return_status_text
2599: );
2600:
2601: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2603: END IF;
2604:
2605: /** KDURGASI **/
2606: --If a template has been specified

Line 2621: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2617: fnd_file.put_line(FND_FILE.LOG, 'Publish_and_Deliver return text'||l_return_status_text);
2618:
2619: END IF;
2620:
2621: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2622: retcode := 1;
2623: errbuf := l_return_status_text;
2624: END IF;
2625:

Line 2635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2631: x_return_status_text => l_return_status_text);
2632: fnd_file.put_line(FND_FILE.LOG, 'XML Message return status '||l_return_status);
2633: fnd_file.put_line(FND_FILE.LOG, 'XML Message return text'||l_return_status_text);
2634:
2635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2636: l_price_book_messages_tbl(i).message_code := 'SYNC_CATALOG_ERROR';
2637: l_price_book_messages_tbl(i).message_text := l_return_status_text;
2638: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;
2639: l_price_book_messages_tbl(i).price_book_header_id := p_price_book_header_id;