DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on STANDARD

Line 3458: -- Standard Start of API savepoint

3454: FROM ozf_sd_request_headers_all_b
3455: WHERE request_number =p_request_number;
3456:
3457: BEGIN
3458: -- Standard Start of API savepoint
3459: SAVEPOINT CREATE_SDR_PUB;
3460: -- Standard call to check for call compatibility.
3461: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3462: p_api_version_number,

Line 3460: -- Standard call to check for call compatibility.

3456:
3457: BEGIN
3458: -- Standard Start of API savepoint
3459: SAVEPOINT CREATE_SDR_PUB;
3460: -- Standard call to check for call compatibility.
3461: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3462: p_api_version_number,
3463: l_api_name,
3464: G_PKG_NAME)

Line 3815: -- Standard call to get message count and if count=1, get the message

3811: EXCEPTION
3812: WHEN FND_API.G_EXC_ERROR THEN
3813: ROLLBACK TO CREATE_SDR_PUB;
3814: x_return_status := FND_API.G_RET_STS_ERROR;
3815: -- Standard call to get message count and if count=1, get the message
3816: FND_MSG_PUB.Count_And_Get (
3817: p_encoded => FND_API.G_FALSE,
3818: p_count => x_msg_count,
3819: p_data => x_msg_data

Line 3824: -- Standard call to get message count and if count=1, get the message

3820: );
3821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3822: ROLLBACK TO CREATE_SDR_PUB;
3823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3824: -- Standard call to get message count and if count=1, get the message
3825: FND_MSG_PUB.Count_And_Get (
3826: p_encoded => FND_API.G_FALSE,
3827: p_count => x_msg_count,
3828: p_data => x_msg_data

Line 3836: -- Standard call to get message count and if count=1, get the message

3832: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3833: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3834: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3835: END IF;
3836: -- Standard call to get message count and if count=1, get the message
3837: FND_MSG_PUB.Count_And_Get (
3838: p_encoded => FND_API.G_FALSE,
3839: p_count => x_msg_count,
3840: p_data => x_msg_data

Line 4010: -- Standard Start of API savepoint

4006: FROM ozf_sd_request_headers_all_b
4007: WHERE request_header_id =p_request_header_id;
4008:
4009: BEGIN
4010: -- Standard Start of API savepoint
4011: SAVEPOINT UPDATE_SDR_PUB;
4012: -- Standard call to check for call compatibility.
4013: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4014: p_api_version_number,

Line 4012: -- Standard call to check for call compatibility.

4008:
4009: BEGIN
4010: -- Standard Start of API savepoint
4011: SAVEPOINT UPDATE_SDR_PUB;
4012: -- Standard call to check for call compatibility.
4013: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4014: p_api_version_number,
4015: l_api_name,
4016: G_PKG_NAME)

Line 4929: -- Standard call to get message count and if count=1, get the message

4925: EXCEPTION
4926: WHEN FND_API.G_EXC_ERROR THEN
4927: ROLLBACK TO UPDATE_SDR_PUB;
4928: x_return_status := FND_API.G_RET_STS_ERROR;
4929: -- Standard call to get message count and if count=1, get the message
4930: FND_MSG_PUB.Count_And_Get (
4931: p_encoded => FND_API.G_FALSE,
4932: p_count => x_msg_count,
4933: p_data => x_msg_data

Line 4938: -- Standard call to get message count and if count=1, get the message

4934: );
4935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4936: ROLLBACK TO UPDATE_SDR_PUB;
4937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4938: -- Standard call to get message count and if count=1, get the message
4939: FND_MSG_PUB.Count_And_Get (
4940: p_encoded => FND_API.G_FALSE,
4941: p_count => x_msg_count,
4942: p_data => x_msg_data

Line 4950: -- Standard call to get message count and if count=1, get the message

4946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4947: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4948: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4949: END IF;
4950: -- Standard call to get message count and if count=1, get the message
4951: FND_MSG_PUB.Count_And_Get (
4952: p_encoded => FND_API.G_FALSE,
4953: p_count => x_msg_count,
4954: p_data => x_msg_data

Line 5174: -- Standard Start of API savepoint

5170: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')
5171: AND user_id = p_user_id;
5172:
5173: BEGIN
5174: -- Standard Start of API savepoint
5175: SAVEPOINT COPY_SDR_PUB;
5176: -- Standard call to check for call compatibility.
5177: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5178: p_api_version_number,

Line 5176: -- Standard call to check for call compatibility.

5172:
5173: BEGIN
5174: -- Standard Start of API savepoint
5175: SAVEPOINT COPY_SDR_PUB;
5176: -- Standard call to check for call compatibility.
5177: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
5178: p_api_version_number,
5179: l_api_name,
5180: G_PKG_NAME)

Line 5736: -- Standard call to get message count and if count=1, get the message

5732: EXCEPTION
5733: WHEN FND_API.G_EXC_ERROR THEN
5734: ROLLBACK TO COPY_SDR_PUB;
5735: x_return_status := FND_API.G_RET_STS_ERROR;
5736: -- Standard call to get message count and if count=1, get the message
5737: FND_MSG_PUB.Count_And_Get (
5738: p_encoded => FND_API.G_FALSE,
5739: p_count => x_msg_count,
5740: p_data => x_msg_data

Line 5745: -- Standard call to get message count and if count=1, get the message

5741: );
5742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5743: ROLLBACK TO COPY_SDR_PUB;
5744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5745: -- Standard call to get message count and if count=1, get the message
5746: FND_MSG_PUB.Count_And_Get (
5747: p_encoded => FND_API.G_FALSE,
5748: p_count => x_msg_count,
5749: p_data => x_msg_data

Line 5757: -- Standard call to get message count and if count=1, get the message

5753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5754: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5755: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5756: END IF;
5757: -- Standard call to get message count and if count=1, get the message
5758: FND_MSG_PUB.Count_And_Get (
5759: p_encoded => FND_API.G_FALSE,
5760: p_count => x_msg_count,
5761: p_data => x_msg_data