[Home] [Help]
1708: BEGIN
1709: --------------------- initialize -----------------------
1710: SAVEPOINT Update_Claim_From_Settlement;
1711:
1712: -- Standard call to check for call compatibility.
1713: IF NOT FND_API.Compatible_API_Call (
1714: l_api_version_number,
1715: p_api_version_number,
1716: l_api_name,
2912: BEGIN
2913: --------------------- initialize -----------------------
2914: SAVEPOINT Get_RMA_Settlement;
2915:
2916: -- Standard call to check for call compatibility.
2917: IF NOT FND_API.Compatible_API_Call (
2918: l_api_version,
2919: p_api_version_number,
2920: l_api_name,
3435: BEGIN
3436: --------------------- initialize -----------------------
3437: SAVEPOINT Get_Receivable_Settlement;
3438:
3439: -- Standard call to check for call compatibility.
3440: IF NOT FND_API.Compatible_API_Call (
3441: l_api_version,
3442: p_api_version_number,
3443: l_api_name,
4093: BEGIN
4094: --------------------- initialize -----------------------
4095: SAVEPOINT Get_Payable_Settlement;
4096:
4097: -- Standard call to check for call compatibility.
4098: IF NOT FND_API.Compatible_API_Call (
4099: l_api_version_number,
4100: p_api_version_number,
4101: l_api_name,
6508: l_return_status varchar2(30);
6509:
6510: BEGIN
6511:
6512: -- Standard begin of API savepoint
6513: SAVEPOINT Create_Settlement_Doc_Tbl;
6514: -- Standard call to check for call compatibility.
6515: IF NOT FND_API.Compatible_API_Call (
6516: l_api_version,
6510: BEGIN
6511:
6512: -- Standard begin of API savepoint
6513: SAVEPOINT Create_Settlement_Doc_Tbl;
6514: -- Standard call to check for call compatibility.
6515: IF NOT FND_API.Compatible_API_Call (
6516: l_api_version,
6517: p_api_version_number,
6518: l_api_name,
6571: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6572: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6573: FND_MSG_PUB.Add;
6574: END IF;
6575: --Standard call to get message count and if count=1, get the message
6576: FND_MSG_PUB.Count_And_Get (
6577: p_encoded => FND_API.G_FALSE,
6578: p_count => x_msg_count,
6579: p_data => x_msg_data
6581: EXCEPTION
6582: WHEN FND_API.G_EXC_ERROR THEN
6583: ROLLBACK TO Create_Settlement_Doc_Tbl;
6584: x_return_status := FND_API.G_RET_STS_ERROR;
6585: -- Standard call to get message count and if count=1, get the message
6586: FND_MSG_PUB.Count_And_Get (
6587: p_encoded => FND_API.G_FALSE,
6588: p_count => x_msg_count,
6589: p_data => x_msg_data
6590: );
6591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6592: ROLLBACK TO Create_Settlement_Doc_Tbl;
6593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6594: -- Standard call to get message count and if count=1, get the message
6595: FND_MSG_PUB.Count_And_Get (
6596: p_encoded => FND_API.G_FALSE,
6597: p_count => x_msg_count,
6598: p_data => x_msg_data
6599: );
6600: WHEN OTHERS THEN
6601: ROLLBACK TO Create_Settlement_Doc_Tbl;
6602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6603: -- Standard call to get message count and if count=1, get the message
6604: FND_MSG_PUB.Count_And_Get (
6605: p_encoded => FND_API.G_FALSE,
6606: p_count => x_msg_count,
6607: p_data => x_msg_data );
6630: l_msg_data varchar2(2000);
6631: l_msg_count number;
6632: l_return_status varchar2(30);
6633: BEGIN
6634: -- Standard begin of API savepoint
6635: SAVEPOINT Update_Settlement_Doc_Tbl;
6636: -- Standard call to check for call compatibility.
6637: IF NOT FND_API.Compatible_API_Call (
6638: l_api_version,
6632: l_return_status varchar2(30);
6633: BEGIN
6634: -- Standard begin of API savepoint
6635: SAVEPOINT Update_Settlement_Doc_Tbl;
6636: -- Standard call to check for call compatibility.
6637: IF NOT FND_API.Compatible_API_Call (
6638: l_api_version,
6639: p_api_version_number,
6640: l_api_name,
6686: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
6687: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
6688: FND_MSG_PUB.Add;
6689: END IF;
6690: --Standard call to get message count and if count=1, get the message
6691: FND_MSG_PUB.Count_And_Get (
6692: p_encoded => FND_API.G_FALSE,
6693: p_count => x_msg_count,
6694: p_data => x_msg_data
6696: EXCEPTION
6697: WHEN FND_API.G_EXC_ERROR THEN
6698: ROLLBACK TO Update_Settlement_Doc_Tbl;
6699: x_return_status := FND_API.G_RET_STS_ERROR;
6700: -- Standard call to get message count and if count=1, get the message
6701: FND_MSG_PUB.Count_And_Get (
6702: p_encoded => FND_API.G_FALSE,
6703: p_count => x_msg_count,
6704: p_data => x_msg_data
6705: );
6706: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6707: ROLLBACK TO Update_Settlement_Doc_Tbl;
6708: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6709: -- Standard call to get message count and if count=1, get the message
6710: FND_MSG_PUB.Count_And_Get (
6711: p_encoded => FND_API.G_FALSE,
6712: p_count => x_msg_count,
6713: p_data => x_msg_data
6714: );
6715: WHEN OTHERS THEN
6716: ROLLBACK TO Update_Settlement_Doc_Tbl;
6717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6718: -- Standard call to get message count and if count=1, get the message
6719: FND_MSG_PUB.Count_And_Get (
6720: p_encoded => FND_API.G_FALSE,
6721: p_count => x_msg_count,
6722: p_data => x_msg_data