DBA Data[Home] [Help]

APPS.PON_AUCTION_INTERFACE_PKG dependencies on FND_API

Line 1200: p_commit => fnd_api.g_false,

1196:
1197:
1198: PO_NEGOTIATIONS4_GRP.insert_attributes(
1199: p_api_version => 1.0,
1200: p_commit => fnd_api.g_false,
1201: p_init_msg_list => fnd_api.g_false,
1202: p_validation_level => fnd_api.g_valid_level_full,
1203: p_auction_header_id => p_document_number,
1204: x_return_status => v_return_status,

Line 1201: p_init_msg_list => fnd_api.g_false,

1197:
1198: PO_NEGOTIATIONS4_GRP.insert_attributes(
1199: p_api_version => 1.0,
1200: p_commit => fnd_api.g_false,
1201: p_init_msg_list => fnd_api.g_false,
1202: p_validation_level => fnd_api.g_valid_level_full,
1203: p_auction_header_id => p_document_number,
1204: x_return_status => v_return_status,
1205: x_msg_count => v_msg_count,

Line 1202: p_validation_level => fnd_api.g_valid_level_full,

1198: PO_NEGOTIATIONS4_GRP.insert_attributes(
1199: p_api_version => 1.0,
1200: p_commit => fnd_api.g_false,
1201: p_init_msg_list => fnd_api.g_false,
1202: p_validation_level => fnd_api.g_valid_level_full,
1203: p_auction_header_id => p_document_number,
1204: x_return_status => v_return_status,
1205: x_msg_count => v_msg_count,
1206: x_msg_data => v_msg_data);

Line 1379: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1375: ORDER BY nvl(sequence, v_max_seq_number) asc);
1376:
1377: END LOOP;
1378:
1379: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1380: X_MSG_COUNT := 0;
1381: X_MSG_DATA := NULL;
1382:
1383: EXCEPTION

Line 1385: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;

1381: X_MSG_DATA := NULL;
1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR ;
1386: X_MSG_COUNT := 1;
1387: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1388: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1389: fnd_message.set_token('PROCEDURE','Add_Catalog_Descriptors');

Line 1625: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR

1621: /*===================================================================
1622: PROCEDURE: add_negotiation_invitees PUBLIC
1623: PARAMETERS:
1624: p_api_version IN version of the api
1625: x_return_status OUT FND_API.G_RET_STS_SUCCESS or FND_API.G_RET_STS_ERROR
1626: x_msg_count OUT Internal code for error
1627: x_msg_data OUT Displayable error message
1628: P_DOCUMENT_NUMBER IN Negotiation Document number
1629: P_BUYER_ID IN FND_USER_ID of the creator

Line 1649: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

1645:
1646: BEGIN
1647:
1648: -- Check for call compatibility.
1649: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1650: l_api_name, g_pkg_name)
1651: THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;

Line 1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1648: -- Check for call compatibility.
1649: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1650: l_api_name, g_pkg_name)
1651: THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654:
1655: IF (P_DOCUMENT_NUMBER IS NULL) THEN
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: END IF;
1654:
1655: IF (P_DOCUMENT_NUMBER IS NULL) THEN
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657: x_msg_count := 0;
1658: x_msg_data := 'Please provide a DOCUMENT_NUMBER';
1659: RETURN;
1660: END IF;

Line 1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

1660: END IF;
1661:
1662:
1663: IF (P_BUYER_ID IS NULL) THEN
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665: x_msg_count := 0;
1666: x_msg_data := 'Please specify a BUYER_ID';
1667: RETURN;
1668: END IF;

Line 1733: x_return_status := FND_API.G_RET_STS_SUCCESS;

1729: and ps.vendor_site_id(+) = prl.vendor_site_id )
1730: ORDER BY vendor_name;
1731:
1732:
1733: x_return_status := FND_API.G_RET_STS_SUCCESS;
1734: x_msg_count := 0;
1735: x_msg_data := NULL;
1736:
1737: EXCEPTION

Line 1739: x_return_status := FND_API.G_RET_STS_SUCCESS;

1735: x_msg_data := NULL;
1736:
1737: EXCEPTION
1738: WHEN NO_DATA_FOUND THEN
1739: x_return_status := FND_API.G_RET_STS_SUCCESS;
1740: x_msg_count := 0;
1741: x_msg_data := NULL;
1742: RETURN;
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1739: x_return_status := FND_API.G_RET_STS_SUCCESS;
1740: x_msg_count := 0;
1741: x_msg_data := NULL;
1742: RETURN;
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: x_msg_count := 1;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');

Line 1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1740: x_msg_count := 0;
1741: x_msg_data := NULL;
1742: RETURN;
1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1745: x_msg_count := 1;
1746: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1747: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1748: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');

Line 1753: x_return_status := FND_API.G_RET_STS_ERROR ;

1749: fnd_message.set_token('ERROR', ' [' || SQLERRM || ']');
1750: fnd_message.retrieve(x_msg_data);
1751: RETURN;
1752: WHEN OTHERS THEN
1753: x_return_status := FND_API.G_RET_STS_ERROR ;
1754: x_msg_count := 1;
1755: fnd_message.set_name('PON', 'PON_AUC_PLSQL_ERR');
1756: fnd_message.set_token('PACKAGE','pon_auction_interface_pkg');
1757: fnd_message.set_token('PROCEDURE','add_negotiation_invitees');