[Home] [Help]
21: select count(*) into l_count
22: from cs_kb_sets_b
23: where set_id = p_set_source_id;
24: if(l_count <= 0) then
25: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
26: fnd_msg_pub.Add;
27: goto error_found;
28: end if;
29:
186: if( P_OBJECT_CODE is null
187: OR P_SET_ID is NULL
188: OR P_OTHER_ID is null
189: OR p_link_type is null ) THEN
190: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
191: fnd_msg_pub.Add;
192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
193: p_count => X_MSG_COUNT,
194: p_data => X_MSG_DATA);
199: OPEN Validate_Solution;
200: FETCH Validate_Solution INTO l_set_number, l_set_status;
201: IF ( Validate_Solution%NOTFOUND ) THEN
202: CLOSE Validate_Solution;
203: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SET_ID');
204: FND_MSG_PUB.ADD;
205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
206: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
207: p_count => X_MSG_COUNT,
237:
238: IF l_ext_obj_count = 0 THEN
239:
240: --dbms_output.put_line('Invalid Ext Object ');
241: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_EXT_OBJ');
242: FND_MSG_PUB.ADD;
243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
245: p_count => X_MSG_COUNT,
258: return;
259: END IF;
260:
261: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
262: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
263: FND_MSG_PUB.ADD;
264: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
266: p_count => X_MSG_COUNT,
399: ROLLBACK TO Create_Link_SP;
400: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
401: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.create_set_link', SQLERRM );
402: end if;
403: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
404: FND_MSG_PUB.Add;
405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
407: p_count => x_msg_count,
731: OR P_OBJECT_CODE is null
732: OR P_SET_ID is NULL
733: OR P_OTHER_ID is null
734: OR p_link_type is null ) THEN
735: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
736: fnd_msg_pub.Add;
737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
738: p_count => X_MSG_COUNT,
739: p_data => X_MSG_DATA);
742: end if;
743:
744: -- validate the link type
745: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
746: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
747: FND_MSG_PUB.ADD;
748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
749: p_count => X_MSG_COUNT,
750: p_data => X_MSG_DATA);
758: FETCH Validate_Link INTO l_orig_set_id, l_orig_object_code, l_orig_other_id,
759: l_orig_soln_number, l_orig_soln_status;
760: IF ( Validate_Link%NOTFOUND ) THEN
761: CLOSE Validate_Link;
762: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
763: FND_MSG_PUB.ADD;
764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
765: p_count => X_MSG_COUNT,
766: p_data => X_MSG_DATA);
776: -- update the link type for an existing link.
777: IF ( l_orig_set_id <> P_SET_ID
778: OR l_orig_object_code <> P_OBJECT_CODE
779: OR l_orig_other_id <> P_OTHER_ID ) THEN
780: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');
781: FND_MSG_PUB.ADD;
782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
783: p_count => X_MSG_COUNT,
784: p_data => X_MSG_DATA);
884: ROLLBACK TO Update_Link_SP;
885: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
886: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );
887: end if;
888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
889: FND_MSG_PUB.Add;
890: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
891:
892: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
971: begin
972: if(P_SET_ID is null or
973: P_OBJECT_CODE is null OR P_OTHER_ID is NULL ) then
974: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
975: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
976: fnd_msg_pub.Add;
977: end if;
978: return ERROR_STATUS;
979: end if;
989: return l_ret_val;
990: END IF;
991: EXCEPTION
992: WHEN OTHERS THEN
993: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
994: return ERROR_STATUS;
995: end Delete_Set_Link_W_Obj_Code;
996:
997:
1030:
1031: -- validate parameter
1032: if (P_LINK_ID is null ) then
1033: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1034: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1035: fnd_msg_pub.Add;
1036: end if;
1037: return ERROR_STATUS;
1038: end if;
1044: l_link_other_id;
1045: IF( Valid_Link%NOTFOUND ) THEN
1046: CLOSE Valid_Link;
1047: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1048: fnd_message.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
1049: fnd_msg_pub.Add;
1050: end if;
1051: return ERROR_STATUS;
1052: END IF;
1084: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1085: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1086: end if;
1087: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1088: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1089: FND_MSG_PUB.Add;
1090: END IF;
1091: return ERROR_STATUS;
1092: end Delete_Set_Link;