DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on STANDARD

Line 2885: -- Standard Start of API savepoint

2881: FROM ozf_sd_request_headers_all_b
2882: WHERE request_number =p_request_number;
2883:
2884: BEGIN
2885: -- Standard Start of API savepoint
2886: SAVEPOINT CREATE_SDR_PUB;
2887: -- Standard call to check for call compatibility.
2888: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2889: p_api_version_number,

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

2883:
2884: BEGIN
2885: -- Standard Start of API savepoint
2886: SAVEPOINT CREATE_SDR_PUB;
2887: -- Standard call to check for call compatibility.
2888: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2889: p_api_version_number,
2890: l_api_name,
2891: G_PKG_NAME)

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

3238: EXCEPTION
3239: WHEN FND_API.G_EXC_ERROR THEN
3240: ROLLBACK TO CREATE_SDR_PUB;
3241: x_return_status := FND_API.G_RET_STS_ERROR;
3242: -- Standard call to get message count and if count=1, get the message
3243: FND_MSG_PUB.Count_And_Get (
3244: p_encoded => FND_API.G_FALSE,
3245: p_count => x_msg_count,
3246: p_data => x_msg_data

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

3247: );
3248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3249: ROLLBACK TO CREATE_SDR_PUB;
3250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3251: -- Standard call to get message count and if count=1, get the message
3252: FND_MSG_PUB.Count_And_Get (
3253: p_encoded => FND_API.G_FALSE,
3254: p_count => x_msg_count,
3255: p_data => x_msg_data

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

3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3260: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3261: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3262: END IF;
3263: -- Standard call to get message count and if count=1, get the message
3264: FND_MSG_PUB.Count_And_Get (
3265: p_encoded => FND_API.G_FALSE,
3266: p_count => x_msg_count,
3267: p_data => x_msg_data

Line 3440: -- Standard Start of API savepoint

3436: FROM ozf_sd_request_headers_all_b
3437: WHERE request_header_id =p_request_header_id;
3438:
3439: BEGIN
3440: -- Standard Start of API savepoint
3441: SAVEPOINT UPDATE_SDR_PUB;
3442: -- Standard call to check for call compatibility.
3443: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3444: p_api_version_number,

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

3438:
3439: BEGIN
3440: -- Standard Start of API savepoint
3441: SAVEPOINT UPDATE_SDR_PUB;
3442: -- Standard call to check for call compatibility.
3443: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
3444: p_api_version_number,
3445: l_api_name,
3446: G_PKG_NAME)

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

4341: EXCEPTION
4342: WHEN FND_API.G_EXC_ERROR THEN
4343: ROLLBACK TO UPDATE_SDR_PUB;
4344: x_return_status := FND_API.G_RET_STS_ERROR;
4345: -- Standard call to get message count and if count=1, get the message
4346: FND_MSG_PUB.Count_And_Get (
4347: p_encoded => FND_API.G_FALSE,
4348: p_count => x_msg_count,
4349: p_data => x_msg_data

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

4350: );
4351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4352: ROLLBACK TO UPDATE_SDR_PUB;
4353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4354: -- Standard call to get message count and if count=1, get the message
4355: FND_MSG_PUB.Count_And_Get (
4356: p_encoded => FND_API.G_FALSE,
4357: p_count => x_msg_count,
4358: p_data => x_msg_data

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

4362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4363: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4364: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
4365: END IF;
4366: -- Standard call to get message count and if count=1, get the message
4367: FND_MSG_PUB.Count_And_Get (
4368: p_encoded => FND_API.G_FALSE,
4369: p_count => x_msg_count,
4370: p_data => x_msg_data

Line 4589: -- Standard Start of API savepoint

4585: AND (category = 'EMPLOYEE' OR category = 'PARTNER' OR category = 'PARTY')
4586: AND user_id = p_user_id;
4587:
4588: BEGIN
4589: -- Standard Start of API savepoint
4590: SAVEPOINT COPY_SDR_PUB;
4591: -- Standard call to check for call compatibility.
4592: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4593: p_api_version_number,

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

4587:
4588: BEGIN
4589: -- Standard Start of API savepoint
4590: SAVEPOINT COPY_SDR_PUB;
4591: -- Standard call to check for call compatibility.
4592: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
4593: p_api_version_number,
4594: l_api_name,
4595: G_PKG_NAME)

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

5145: EXCEPTION
5146: WHEN FND_API.G_EXC_ERROR THEN
5147: ROLLBACK TO COPY_SDR_PUB;
5148: x_return_status := FND_API.G_RET_STS_ERROR;
5149: -- Standard call to get message count and if count=1, get the message
5150: FND_MSG_PUB.Count_And_Get (
5151: p_encoded => FND_API.G_FALSE,
5152: p_count => x_msg_count,
5153: p_data => x_msg_data

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

5154: );
5155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5156: ROLLBACK TO COPY_SDR_PUB;
5157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5158: -- Standard call to get message count and if count=1, get the message
5159: FND_MSG_PUB.Count_And_Get (
5160: p_encoded => FND_API.G_FALSE,
5161: p_count => x_msg_count,
5162: p_data => x_msg_data

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

5166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5167: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5168: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
5169: END IF;
5170: -- Standard call to get message count and if count=1, get the message
5171: FND_MSG_PUB.Count_And_Get (
5172: p_encoded => FND_API.G_FALSE,
5173: p_count => x_msg_count,
5174: p_data => x_msg_data