APPS.QP_PRICE_BOOK_PVT dependencies on FND_API

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

241: p_pb_input_lines_tbl IN QP_PRICE_BOOK_UTIL.pb_input_lines_tbl,
242: p_price_book_header_id IN NUMBER
243: )
244: IS
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: -- Changes for bug 7034445
539: -- SNIMMAGA.

Line 677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

673:
674: fnd_file.put_line(FND_FILE.LOG, 'insert_lines2 return status '||l_return_status);
675: fnd_file.put_line(FND_FILE.LOG, 'insert_lines2 return text'||l_return_status_text);
676:
677: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
678: fnd_file.put_line(fnd_file.Log, ' Raising SQL Exception...'); --bug 7034445
679: RAISE SQL_EXCEPTION;
680: END IF;
681:

Line 1130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1126:
1127: fnd_file.put_line(FND_FILE.LOG, 'insert_line_attrs2 return status '||l_return_status);
1128: fnd_file.put_line(FND_FILE.LOG, 'insert_line_attrs2 return text'||l_return_status_text);
1129:
1130: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1131: RAISE SQL_EXCEPTION;
1132: END IF;
1133:
1134: END IF; -- If l_attrs_line_index_tbl.count > 0

Line 1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1191: fnd_file.put_line(fnd_file.Log, 'After Pricing Engine Call...');
1192: fnd_file.put_line(FND_FILE.LOG, 'Price_Request return status '||l_return_status);
1193: fnd_file.put_line(FND_FILE.LOG, 'Price_Request return text'||l_return_status_text);
1194:
1195: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1196: RAISE SQL_EXCEPTION;
1197: END IF;
1198:
1199: OPEN lines_cur;

Line 1457: WHEN FND_API.G_EXC_ERROR THEN

1453: END LOOP; --Loop over cursor insert_lines2_cur
1454: CLOSE insert_lines2_cur;
1455:
1456: EXCEPTION
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: RAISE;
1459: WHEN OTHERS THEN
1460: RAISE;
1461: END Insert_Price_Book_Content;

Line 1976: WHEN FND_API.G_EXC_ERROR THEN

1972:
1973: fnd_file.put_line(FND_FILE.LOG, 'After inserting price book header'||
1974: to_char(l_publish_price_book_header_id));
1975: EXCEPTION
1976: WHEN FND_API.G_EXC_ERROR THEN
1977: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
1978: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
1979: l_pb_input_header_rec.price_book_name);
1980: l_message_text := FND_MESSAGE.GET;

Line 2025: WHEN FND_API.G_EXC_ERROR THEN

2021: QP_PRICE_BOOK_UTIL.Insert_Price_Book_Header(
2022: p_pb_input_header_rec => l_pb_input_header_rec,
2023: x_price_book_header_id => l_publish_price_book_header_id);
2024: EXCEPTION
2025: WHEN FND_API.G_EXC_ERROR THEN
2026: FND_MESSAGE.SET_NAME('QP', 'QP_PB_EXISTS_IN_ANOTHER_ORG');
2027: FND_MESSAGE.SET_TOKEN('PRICE_BOOK_NAME',
2028: l_pb_input_header_rec.price_book_name);
2029: l_message_text := FND_MESSAGE.GET;

Line 2415: WHEN FND_API.G_EXC_ERROR THEN

2411: p_pb_input_header_rec => l_pb_input_header_rec,
2412: p_pb_input_lines_tbl => l_pb_input_lines_tbl,
2413: p_price_book_header_id => p_price_book_header_id);
2414: EXCEPTION
2415: WHEN FND_API.G_EXC_ERROR THEN
2416: l_price_book_messages_tbl(i).message_code :=
2417: 'QP_NO_PB_LINES_TO_PRICE';
2418: FND_MESSAGE.SET_NAME('FND', 'QP_NO_PB_LINES_TO_PRICE');
2419: l_message_text := FND_MESSAGE.GET;

Line 2579: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2575: fnd_file.put_line(FND_FILE.LOG, 'Publish_and_Deliver return text'||l_return_status_text);
2576:
2577: END IF;
2578:
2579: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2580: retcode := 1;
2581: errbuf := l_return_status_text;
2582: END IF;
2583:

Line 2593: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2589: x_return_status_text => l_return_status_text);
2590: fnd_file.put_line(FND_FILE.LOG, 'XML Message return status '||l_return_status);
2591: fnd_file.put_line(FND_FILE.LOG, 'XML Message return text'||l_return_status_text);
2592:
2593: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2594: l_price_book_messages_tbl(i).message_code := 'SYNC_CATALOG_ERROR';
2595: l_price_book_messages_tbl(i).message_text := l_return_status_text;
2596: l_price_book_messages_tbl(i).pb_input_header_id := p_pb_input_header_id;
2597: l_price_book_messages_tbl(i).price_book_header_id := p_price_book_header_id;