DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on FND_API

Line 98: IF NOT FND_API.Compatible_API_Call( l_api_version ,

94: BEGIN
95: -- Standard start of API savepoint
96: SAVEPOINT create_negotiation_bulk_SP;
97: -- Standard call to check for call compatibility
98: IF NOT FND_API.Compatible_API_Call( l_api_version ,
99: p_api_version ,
100: l_api_name ,
101: G_PKG_NAME)
102: THEN

Line 103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

99: p_api_version ,
100: l_api_name ,
101: G_PKG_NAME)
102: THEN
103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
104: END IF;
105:
106: -- API Body
107: -- Get the number of lines being passed in.

Line 144: RAISE FND_API.G_EXC_ERROR;

140:
141: -- End of API Body
142: -- Standard check to see if there is any error
143: IF(x_result = -1) THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146: EXCEPTION
147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO create_negotiation_bulk_SP;

Line 147: WHEN FND_API.G_EXC_ERROR THEN

143: IF(x_result = -1) THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146: EXCEPTION
147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO create_negotiation_bulk_SP;
149: x_result := -1;
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ROLLBACK TO create_negotiation_bulk_SP;

Line 150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

146: EXCEPTION
147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO create_negotiation_bulk_SP;
149: x_result := -1;
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ROLLBACK TO create_negotiation_bulk_SP;
152: x_result := -1;
153: x_error_message := 'Unexpected error in create_negotiaton_bulk';
154: WHEN OTHERS THEN

Line 310: p_init_msg_list => FND_API.G_TRUE,

306: l_destination_type_table(i):= t_req_lines(i).destination_type_code;
307: l_purchase_basis_table(i):= t_req_lines(i).purchase_basis;
308: end loop;
309: PO_DOC_STYLE_PVT.populate_gt_and_validate(p_api_version => 1.0,
310: p_init_msg_list => FND_API.G_TRUE,
311: X_return_status => l_return_status,
312: X_msg_count => l_msg_count,
313: x_msg_data => l_msg_data,
314: p_req_line_id_table => l_req_line_id_table,

Line 816: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

812: , p_document_number => x_negotiation_id -- IN
813: , p_buyer_id => to_number(FND_PROFILE.VALUE('user_id')) -- IN
814: );
815:
816: if l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
817: x_progress := '020';
818: x_result := -1;
819: x_error_message := l_msg_data;
820:

Line 836: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

832: , x_msg_count => l_msg_count
833: , x_msg_data => l_msg_data
834: );
835:
836: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
837: x_progress := '030';
838: x_result := -1;
839: x_error_message := l_msg_data;
840:

Line 987: FND_API.G_RET_STS_SUCCESS

983: p_new_negotiation_line_num : new negotiation line where reference has
984: to be added
985: Output parameters :
986: x_return_status: The return status of the API. Valid values are:
987: FND_API.G_RET_STS_SUCCESS
988: FND_API.G_RET_STS_ERROR
989: FND_API.G_RET_STS_UNEXP_ERROR
990: x_error_message: Contain translated error message in case the return status
991: is G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR

Line 988: FND_API.G_RET_STS_ERROR

984: to be added
985: Output parameters :
986: x_return_status: The return status of the API. Valid values are:
987: FND_API.G_RET_STS_SUCCESS
988: FND_API.G_RET_STS_ERROR
989: FND_API.G_RET_STS_UNEXP_ERROR
990: x_error_message: Contain translated error message in case the return status
991: is G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR
992: Version: Current Version 1.0

Line 989: FND_API.G_RET_STS_UNEXP_ERROR

985: Output parameters :
986: x_return_status: The return status of the API. Valid values are:
987: FND_API.G_RET_STS_SUCCESS
988: FND_API.G_RET_STS_ERROR
989: FND_API.G_RET_STS_UNEXP_ERROR
990: x_error_message: Contain translated error message in case the return status
991: is G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR
992: Version: Current Version 1.0
993: Changed: Initial design 1/27/2003

Line 1015: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1011: BEGIN
1012: l_progress := '000';
1013:
1014: -- Standard call to check for call compatibility
1015: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1016: THEN
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019:

Line 1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1013:
1014: -- Standard call to check for call compatibility
1015: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1016: THEN
1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019:
1020: l_progress := '001';
1021:

Line 1029: x_return_status := FND_API.G_RET_STS_SUCCESS;

1025: auction_line_number = p_new_negotiation_line_num
1026: where auction_header_id = p_old_negotiation_id and
1027: auction_line_number = p_old_negotiation_line_num;
1028:
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030:
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1028:
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030:
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1034: p_encoded => 'F');
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR;

1031: EXCEPTION
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1034: p_encoded => 'F');
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: WHEN OTHERS THEN
1037: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1038: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name,
1039: SUBSTRB (SQLERRM , 1 , 200) || ' at location ' || l_progress);

Line 1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1040: END IF;
1041:
1042: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1043: p_encoded => 'F');
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045:
1046: END UPDATE_NEGOTIATION_LINE_REF;
1047: --
1048:

Line 1280: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

1276: -- Standard start of API savepoint
1277: SAVEPOINT renegotiate_blanket_grp;
1278:
1279: -- Standard call to check for call compatibility
1280: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1281: THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1278:
1279: -- Standard call to check for call compatibility
1280: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
1281: THEN
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: END IF;
1284:
1285: l_progress := '001';
1286:

Line 1720: if FND_API.To_Boolean(p_commit) then

1716: end if;
1717: --
1718:
1719: -- Committing the changes to the database
1720: if FND_API.To_Boolean(p_commit) then
1721: commit;
1722: end if;
1723:
1724: EXCEPTION

Line 1725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1721: commit;
1722: end if;
1723:
1724: EXCEPTION
1725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1726: ROLLBACK TO renegotiate_blanket_grp;
1727: x_error_message := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
1728: p_encoded => 'F');
1729: x_return_status := l_ret_sts_error;

Line 1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1800: x_return_status => l_return_status,
1801: x_msg_count => l_msg_count,
1802: x_msg_data => l_msg_data);
1803:
1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1805: l_progress := '010';
1806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1807: END IF;
1808:

Line 1806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1802: x_msg_data => l_msg_data);
1803:
1804: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1805: l_progress := '010';
1806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1807: END IF;
1808:
1809: l_progress := '020';
1810: IF g_debug_stmt THEN