DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PUB dependencies on STANDARD

Line 594: -- Standard start of API savepoint

590: -- Added for making call to 11.5.10 signature of Create SR public API
591: l_sr_create_out_rec sr_create_out_rec_type;
592:
593: BEGIN
594: -- Standard start of API savepoint
595: SAVEPOINT Create_ServiceRequest_PUB;
596:
597: --BUG 3630159:
598: --Added to clear message cache in case of API call wrong version.

Line 604: -- Standard call to check for call compatibility

600: IF FND_API.To_Boolean(p_init_msg_list) THEN
601: FND_MSG_PUB.Initialize;
602: END IF;
603:
604: -- Standard call to check for call compatibility
605: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
606: G_PKG_NAME) THEN
607: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; #BUG 3630127
608: RAISE FND_API.G_EXC_ERROR;

Line 1081: -- Standard start of API savepoint

1077:
1078: END Validate_Request_Attributes;
1079:
1080: BEGIN
1081: -- Standard start of API savepoint
1082: SAVEPOINT Create_ServiceRequest_PUB;
1083:
1084: --BUG 3630159:
1085: --Added to clear message cache in case of API call wrong version.

Line 1091: -- Standard call to check for call compatibility

1087: IF FND_API.To_Boolean(p_init_msg_list) THEN
1088: FND_MSG_PUB.Initialize;
1089: END IF;
1090:
1091: -- Standard call to check for call compatibility
1092: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1093: G_PKG_NAME) THEN
1094: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; #BUG 3630127
1095: RAISE FND_API.G_EXC_ERROR;

Line 2100: -- Standard check of p_commit

2096: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2098: END IF;
2099:
2100: -- Standard check of p_commit
2101: IF FND_API.To_Boolean(p_commit) THEN
2102: COMMIT WORK;
2103: END IF;
2104:

Line 2105: -- Standard call to get message count and if count is 1, get message info

2101: IF FND_API.To_Boolean(p_commit) THEN
2102: COMMIT WORK;
2103: END IF;
2104:
2105: -- Standard call to get message count and if count is 1, get message info
2106: FND_MSG_PUB.Count_And_Get
2107: ( p_count => x_msg_count,
2108: p_data => x_msg_data
2109: );

Line 2188: -- Standard start of API savepoint

2184: l_sr_update_out_rec sr_update_out_rec_type;
2185:
2186: BEGIN
2187:
2188: -- Standard start of API savepoint
2189: SAVEPOINT Update_ServiceRequest_PUB;
2190:
2191: -- Standard call to check for call compatibility
2192: -- Added the and condition for backward compatibility project, now

Line 2191: -- Standard call to check for call compatibility

2187:
2188: -- Standard start of API savepoint
2189: SAVEPOINT Update_ServiceRequest_PUB;
2190:
2191: -- Standard call to check for call compatibility
2192: -- Added the and condition for backward compatibility project, now
2193: -- both the version 2.0 and 3.0 are valid as this procedure can be called
2194: -- from both 1158 or 1159 env.
2195:

Line 2251: -- Standard check of p_commit

2247: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2248: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END IF;
2250:
2251: -- Standard check of p_commit
2252: IF FND_API.To_Boolean(p_commit) THEN
2253: COMMIT WORK;
2254: END IF;
2255:

Line 2256: -- Standard call to get message count and if count is 1, get message info

2252: IF FND_API.To_Boolean(p_commit) THEN
2253: COMMIT WORK;
2254: END IF;
2255:
2256: -- Standard call to get message count and if count is 1, get message info
2257: FND_MSG_PUB.Count_And_Get
2258: ( p_count => x_msg_count,
2259: p_data => x_msg_data
2260: );

Line 2382: -- Standard start of API savepoint

2378: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
2379:
2380: BEGIN
2381:
2382: -- Standard start of API savepoint
2383: SAVEPOINT Update_ServiceRequest_PUB;
2384:
2385: -- Standard call to check for call compatibility
2386: -- Added the and condition for backward compatibility project, now

Line 2385: -- Standard call to check for call compatibility

2381:
2382: -- Standard start of API savepoint
2383: SAVEPOINT Update_ServiceRequest_PUB;
2384:
2385: -- Standard call to check for call compatibility
2386: -- Added the and condition for backward compatibility project, now
2387: -- both the version 2.0 and 3.0 are valid as this procedure can be called
2388: -- from both 1158 or 1159 env.
2389:

Line 3277: -- Standard check of p_commit

3273: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3274: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END IF;
3276:
3277: -- Standard check of p_commit
3278: IF FND_API.To_Boolean(p_commit) THEN
3279: COMMIT WORK;
3280: END IF;
3281:

Line 3282: -- Standard call to get message count and if count is 1, get message info

3278: IF FND_API.To_Boolean(p_commit) THEN
3279: COMMIT WORK;
3280: END IF;
3281:
3282: -- Standard call to get message count and if count is 1, get message info
3283: FND_MSG_PUB.Count_And_Get
3284: ( p_count => x_msg_count,
3285: p_data => x_msg_data
3286: );

Line 3365: -- Standard API stuff

3361: l_public_comment_flag VARCHAR2(1) := p_public_comment_flag;
3362:
3363: BEGIN
3364: -- ---------------------------------------
3365: -- Standard API stuff
3366: -- ---------------------------------------
3367:
3368: -- Establish savepoint
3369: SAVEPOINT Update_Status_PUB;

Line 3723: -- Standard API stuff

3719: l_public_comment_flag VARCHAR2(1) := p_public_comment_flag;
3720:
3721: BEGIN
3722: -- ---------------------------------------
3723: -- Standard API stuff
3724: -- ---------------------------------------
3725:
3726: -- Establish savepoint
3727: SAVEPOINT Update_Owner_PUB;

Line 4866: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards

4862: IF FND_API.To_Boolean(p_init_msg_list) THEN
4863: FND_MSG_PUB.Initialize;
4864: END IF;
4865:
4866: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
4867: IF NOT FND_API.Compatible_API_Call
4868: (
4869: p_current_version_number => l_api_version,
4870: p_caller_version_number => p_api_version,

Line 4961: --3630159 -- reverts changes for 3288427 to conform to coding standards

4957: l_set_link_rec CS_KB_SET_LINKS%ROWTYPE;
4958: l_set_link_id NUMBER;
4959:
4960: l_api_name_full VARCHAR2(70) := G_PKG_NAME || '.LINK_KB_SOLUTION';
4961: --3630159 -- reverts changes for 3288427 to conform to coding standards
4962: l_api_version CONSTANT NUMBER := 1.0;
4963: l_api_name CONSTANT VARCHAR2(17) := 'LINK_KB_SOLUTION';
4964: BEGIN
4965: --Note :

Line 4975: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards

4971: IF FND_API.To_Boolean(p_init_msg_list) THEN
4972: FND_MSG_PUB.Initialize;
4973: END IF;
4974:
4975: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
4976: IF NOT FND_API.Compatible_API_Call
4977: (
4978: p_current_version_number => l_api_version,
4979: p_caller_version_number => p_api_version,

Line 5089: -- Standard start of API savepoint

5085: l_individual_type VARCHAR2(30);
5086: l_return_status VARCHAR2(1);
5087:
5088: BEGIN
5089: -- Standard start of API savepoint
5090: SAVEPOINT Create_ServiceRequest_PUB;
5091:
5092: --BUG 3630159:
5093: --Added to clear message cache in case of API call wrong version.

Line 5099: -- Standard call to check for call compatibility

5095: IF FND_API.To_Boolean(p_init_msg_list) THEN
5096: FND_MSG_PUB.Initialize;
5097: END IF;
5098:
5099: -- Standard call to check for call compatibility
5100: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
5101: G_PKG_NAME) THEN
5102: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; #BUG 3630127
5103: RAISE FND_API.G_EXC_ERROR;