[Home] [Help]
609: -- Added for making call to 11.5.10 signature of Create SR public API
610: l_sr_create_out_rec sr_create_out_rec_type;
611:
612: BEGIN
613: -- Standard start of API savepoint
614: SAVEPOINT Create_ServiceRequest_PUB;
615:
616: --BUG 3630159:
617: --Added to clear message cache in case of API call wrong version.
619: IF FND_API.To_Boolean(p_init_msg_list) THEN
620: FND_MSG_PUB.Initialize;
621: END IF;
622:
623: -- Standard call to check for call compatibility
624: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
625: G_PKG_NAME) THEN
626: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; #BUG 3630127
627: RAISE FND_API.G_EXC_ERROR;
1101:
1102: END Validate_Request_Attributes;
1103:
1104: BEGIN
1105: -- Standard start of API savepoint
1106: SAVEPOINT Create_ServiceRequest_PUB;
1107:
1108: --BUG 3630159:
1109: --Added to clear message cache in case of API call wrong version.
1111: IF FND_API.To_Boolean(p_init_msg_list) THEN
1112: FND_MSG_PUB.Initialize;
1113: END IF;
1114:
1115: -- Standard call to check for call compatibility
1116: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
1117: G_PKG_NAME) THEN
1118: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; #BUG 3630127
1119: RAISE FND_API.G_EXC_ERROR;
2156: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: END IF;
2159:
2160: -- Standard check of p_commit
2161: IF FND_API.To_Boolean(p_commit) THEN
2162: COMMIT WORK;
2163: END IF;
2164:
2161: IF FND_API.To_Boolean(p_commit) THEN
2162: COMMIT WORK;
2163: END IF;
2164:
2165: -- Standard call to get message count and if count is 1, get message info
2166: FND_MSG_PUB.Count_And_Get
2167: ( p_count => x_msg_count,
2168: p_data => x_msg_data
2169: );
2244: l_sr_update_out_rec sr_update_out_rec_type;
2245:
2246: BEGIN
2247:
2248: -- Standard start of API savepoint
2249: SAVEPOINT Update_ServiceRequest_PUB;
2250:
2251: -- Standard call to check for call compatibility
2252: -- Added the and condition for backward compatibility project, now
2247:
2248: -- Standard start of API savepoint
2249: SAVEPOINT Update_ServiceRequest_PUB;
2250:
2251: -- Standard call to check for call compatibility
2252: -- Added the and condition for backward compatibility project, now
2253: -- both the version 2.0 and 3.0 are valid as this procedure can be called
2254: -- from both 1158 or 1159 env.
2255:
2307: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2308: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2309: END IF;
2310:
2311: -- Standard check of p_commit
2312: IF FND_API.To_Boolean(p_commit) THEN
2313: COMMIT WORK;
2314: END IF;
2315:
2312: IF FND_API.To_Boolean(p_commit) THEN
2313: COMMIT WORK;
2314: END IF;
2315:
2316: -- Standard call to get message count and if count is 1, get message info
2317: FND_MSG_PUB.Count_And_Get
2318: ( p_count => x_msg_count,
2319: p_data => x_msg_data
2320: );
2443: l_invocation_mode VARCHAR2(51);
2444:
2445: BEGIN
2446:
2447: -- Standard start of API savepoint
2448: SAVEPOINT Update_ServiceRequest_PUB;
2449:
2450: -- Standard call to check for call compatibility
2451: -- Added the and condition for backward compatibility project, now
2446:
2447: -- Standard start of API savepoint
2448: SAVEPOINT Update_ServiceRequest_PUB;
2449:
2450: -- Standard call to check for call compatibility
2451: -- Added the and condition for backward compatibility project, now
2452: -- both the version 2.0 and 3.0 are valid as this procedure can be called
2453: -- from both 1158 or 1159 env.
2454:
3380: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3382: END IF;
3383:
3384: -- Standard check of p_commit
3385: IF FND_API.To_Boolean(p_commit) THEN
3386: COMMIT WORK;
3387: END IF;
3388:
3385: IF FND_API.To_Boolean(p_commit) THEN
3386: COMMIT WORK;
3387: END IF;
3388:
3389: -- Standard call to get message count and if count is 1, get message info
3390: FND_MSG_PUB.Count_And_Get
3391: ( p_count => x_msg_count,
3392: p_data => x_msg_data
3393: );
3470: l_public_comment_flag VARCHAR2(1) := p_public_comment_flag;
3471:
3472: BEGIN
3473: -- ---------------------------------------
3474: -- Standard API stuff
3475: -- ---------------------------------------
3476:
3477: -- Establish savepoint
3478: SAVEPOINT Update_Status_PUB;
3834: l_public_comment_flag VARCHAR2(1) := p_public_comment_flag;
3835:
3836: BEGIN
3837: -- ---------------------------------------
3838: -- Standard API stuff
3839: -- ---------------------------------------
3840:
3841: -- Establish savepoint
3842: SAVEPOINT Update_Owner_PUB;
4981: IF FND_API.To_Boolean(p_init_msg_list) THEN
4982: FND_MSG_PUB.Initialize;
4983: END IF;
4984:
4985: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
4986: IF NOT FND_API.Compatible_API_Call
4987: (
4988: p_current_version_number => l_api_version,
4989: p_caller_version_number => p_api_version,
5076: l_set_link_rec CS_KB_SET_LINKS%ROWTYPE;
5077: l_set_link_id NUMBER;
5078:
5079: l_api_name_full VARCHAR2(70) := G_PKG_NAME || '.LINK_KB_SOLUTION';
5080: --3630159 -- reverts changes for 3288427 to conform to coding standards
5081: l_api_version CONSTANT NUMBER := 1.0;
5082: l_api_name CONSTANT VARCHAR2(17) := 'LINK_KB_SOLUTION';
5083: BEGIN
5084: --Note :
5090: IF FND_API.To_Boolean(p_init_msg_list) THEN
5091: FND_MSG_PUB.Initialize;
5092: END IF;
5093:
5094: --3630159 -- 30th June, 2004 -- Added to conform to public API coding standards
5095: IF NOT FND_API.Compatible_API_Call
5096: (
5097: p_current_version_number => l_api_version,
5098: p_caller_version_number => p_api_version,
5204: l_individual_type VARCHAR2(30);
5205: l_return_status VARCHAR2(1);
5206:
5207: BEGIN
5208: -- Standard start of API savepoint
5209: SAVEPOINT Create_ServiceRequest_PUB;
5210:
5211: --BUG 3630159:
5212: --Added to clear message cache in case of API call wrong version.
5214: IF FND_API.To_Boolean(p_init_msg_list) THEN
5215: FND_MSG_PUB.Initialize;
5216: END IF;
5217:
5218: -- Standard call to check for call compatibility
5219: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
5220: G_PKG_NAME) THEN
5221: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR; #BUG 3630127
5222: RAISE FND_API.G_EXC_ERROR;