[Home] [Help]
102: BEGIN
103:
104: SAVEPOINT Get_Settlement_Trx_Type;
105:
106: -- Standard call to check for call compatibility.
107: IF NOT FND_API.Compatible_API_Call (
108: l_api_version_number,
109: p_api_version_number,
110: l_api_name,
2079: BEGIN
2080: --------------------- initialize -----------------------
2081: SAVEPOINT Update_Claim_From_Settlement;
2082:
2083: -- Standard call to check for call compatibility.
2084: IF NOT FND_API.Compatible_API_Call (
2085: l_api_version_number,
2086: p_api_version_number,
2087: l_api_name,
3384: BEGIN
3385: --------------------- initialize -----------------------
3386: SAVEPOINT Get_RMA_Settlement;
3387:
3388: -- Standard call to check for call compatibility.
3389: IF NOT FND_API.Compatible_API_Call (
3390: l_api_version,
3391: p_api_version_number,
3392: l_api_name,
3907: BEGIN
3908: --------------------- initialize -----------------------
3909: SAVEPOINT Get_Receivable_Settlement;
3910:
3911: -- Standard call to check for call compatibility.
3912: IF NOT FND_API.Compatible_API_Call (
3913: l_api_version,
3914: p_api_version_number,
3915: l_api_name,
4580: BEGIN
4581: --------------------- initialize -----------------------
4582: SAVEPOINT Get_Payable_Settlement;
4583:
4584: -- Standard call to check for call compatibility.
4585: IF NOT FND_API.Compatible_API_Call (
4586: l_api_version_number,
4587: p_api_version_number,
4588: l_api_name,
7046: l_return_status varchar2(30);
7047:
7048: BEGIN
7049:
7050: -- Standard begin of API savepoint
7051: SAVEPOINT Create_Settlement_Doc_Tbl;
7052: -- Standard call to check for call compatibility.
7053: IF NOT FND_API.Compatible_API_Call (
7054: l_api_version,
7048: BEGIN
7049:
7050: -- Standard begin of API savepoint
7051: SAVEPOINT Create_Settlement_Doc_Tbl;
7052: -- Standard call to check for call compatibility.
7053: IF NOT FND_API.Compatible_API_Call (
7054: l_api_version,
7055: p_api_version_number,
7056: l_api_name,
7109: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7110: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7111: FND_MSG_PUB.Add;
7112: END IF;
7113: --Standard call to get message count and if count=1, get the message
7114: FND_MSG_PUB.Count_And_Get (
7115: p_encoded => FND_API.G_FALSE,
7116: p_count => x_msg_count,
7117: p_data => x_msg_data
7119: EXCEPTION
7120: WHEN FND_API.G_EXC_ERROR THEN
7121: ROLLBACK TO Create_Settlement_Doc_Tbl;
7122: x_return_status := FND_API.G_RET_STS_ERROR;
7123: -- Standard call to get message count and if count=1, get the message
7124: FND_MSG_PUB.Count_And_Get (
7125: p_encoded => FND_API.G_FALSE,
7126: p_count => x_msg_count,
7127: p_data => x_msg_data
7128: );
7129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7130: ROLLBACK TO Create_Settlement_Doc_Tbl;
7131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7132: -- Standard call to get message count and if count=1, get the message
7133: FND_MSG_PUB.Count_And_Get (
7134: p_encoded => FND_API.G_FALSE,
7135: p_count => x_msg_count,
7136: p_data => x_msg_data
7137: );
7138: WHEN OTHERS THEN
7139: ROLLBACK TO Create_Settlement_Doc_Tbl;
7140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7141: -- Standard call to get message count and if count=1, get the message
7142: FND_MSG_PUB.Count_And_Get (
7143: p_encoded => FND_API.G_FALSE,
7144: p_count => x_msg_count,
7145: p_data => x_msg_data );
7168: l_msg_data varchar2(2000);
7169: l_msg_count number;
7170: l_return_status varchar2(30);
7171: BEGIN
7172: -- Standard begin of API savepoint
7173: SAVEPOINT Update_Settlement_Doc_Tbl;
7174: -- Standard call to check for call compatibility.
7175: IF NOT FND_API.Compatible_API_Call (
7176: l_api_version,
7170: l_return_status varchar2(30);
7171: BEGIN
7172: -- Standard begin of API savepoint
7173: SAVEPOINT Update_Settlement_Doc_Tbl;
7174: -- Standard call to check for call compatibility.
7175: IF NOT FND_API.Compatible_API_Call (
7176: l_api_version,
7177: p_api_version_number,
7178: l_api_name,
7224: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
7225: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
7226: FND_MSG_PUB.Add;
7227: END IF;
7228: --Standard call to get message count and if count=1, get the message
7229: FND_MSG_PUB.Count_And_Get (
7230: p_encoded => FND_API.G_FALSE,
7231: p_count => x_msg_count,
7232: p_data => x_msg_data
7234: EXCEPTION
7235: WHEN FND_API.G_EXC_ERROR THEN
7236: ROLLBACK TO Update_Settlement_Doc_Tbl;
7237: x_return_status := FND_API.G_RET_STS_ERROR;
7238: -- Standard call to get message count and if count=1, get the message
7239: FND_MSG_PUB.Count_And_Get (
7240: p_encoded => FND_API.G_FALSE,
7241: p_count => x_msg_count,
7242: p_data => x_msg_data
7243: );
7244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7245: ROLLBACK TO Update_Settlement_Doc_Tbl;
7246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7247: -- Standard call to get message count and if count=1, get the message
7248: FND_MSG_PUB.Count_And_Get (
7249: p_encoded => FND_API.G_FALSE,
7250: p_count => x_msg_count,
7251: p_data => x_msg_data
7252: );
7253: WHEN OTHERS THEN
7254: ROLLBACK TO Update_Settlement_Doc_Tbl;
7255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7256: -- Standard call to get message count and if count=1, get the message
7257: FND_MSG_PUB.Count_And_Get (
7258: p_encoded => FND_API.G_FALSE,
7259: p_count => x_msg_count,
7260: p_data => x_msg_data