[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,
423: ROLLBACK TO Create_Link_SP;
424: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
425: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.create_set_link', SQLERRM );
426: end if;
427: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
428: FND_MSG_PUB.Add;
429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
431: p_count => x_msg_count,
755: OR P_OBJECT_CODE is null
756: OR P_SET_ID is NULL
757: OR P_OTHER_ID is null
758: OR p_link_type is null ) THEN
759: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
760: fnd_msg_pub.Add;
761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
762: p_count => X_MSG_COUNT,
763: p_data => X_MSG_DATA);
766: end if;
767:
768: -- validate the link type
769: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN
770: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_LINK_TYPE');
771: FND_MSG_PUB.ADD;
772: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
773: p_count => X_MSG_COUNT,
774: p_data => X_MSG_DATA);
782: FETCH Validate_Link INTO l_orig_set_id, l_orig_object_code, l_orig_other_id,
783: l_orig_soln_number, l_orig_soln_status;
784: IF ( Validate_Link%NOTFOUND ) THEN
785: CLOSE Validate_Link;
786: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
787: FND_MSG_PUB.ADD;
788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
789: p_count => X_MSG_COUNT,
790: p_data => X_MSG_DATA);
800: -- update the link type for an existing link.
801: IF ( l_orig_set_id <> P_SET_ID
802: OR l_orig_object_code <> P_OBJECT_CODE
803: OR l_orig_other_id <> P_OTHER_ID ) THEN
804: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_UPDATE');
805: FND_MSG_PUB.ADD;
806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,
807: p_count => X_MSG_COUNT,
808: p_data => X_MSG_DATA);
908: ROLLBACK TO Update_Link_SP;
909: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
910: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );
911: end if;
912: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
913: FND_MSG_PUB.Add;
914: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;
915:
916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
995: begin
996: if(P_SET_ID is null or
997: P_OBJECT_CODE is null OR P_OTHER_ID is NULL ) then
998: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
999: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1000: fnd_msg_pub.Add;
1001: end if;
1002: return ERROR_STATUS;
1003: end if;
1013: return l_ret_val;
1014: END IF;
1015: EXCEPTION
1016: WHEN OTHERS THEN
1017: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1018: return ERROR_STATUS;
1019: end Delete_Set_Link_W_Obj_Code;
1020:
1021:
1054:
1055: -- validate parameter
1056: if (P_LINK_ID is null ) then
1057: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1058: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1059: fnd_msg_pub.Add;
1060: end if;
1061: return ERROR_STATUS;
1062: end if;
1068: l_link_other_id;
1069: IF( Valid_Link%NOTFOUND ) THEN
1070: CLOSE Valid_Link;
1071: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1072: fnd_message.set_name('CS', 'CS_KB_INV_API_SOLN_LINK_ID');
1073: fnd_msg_pub.Add;
1074: end if;
1075: return ERROR_STATUS;
1076: END IF;
1108: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1109: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1110: end if;
1111: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1112: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1113: FND_MSG_PUB.Add;
1114: END IF;
1115: return ERROR_STATUS;
1116: end Delete_Set_Link;