DBA Data[Home] [Help]

APPS.CS_KB_SET_LINKS_PKG dependencies on FND_API

Line 182: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

178:
179: BEGIN
180: SAVEPOINT CREATE_LINK_SP;
181:
182: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
183:
184: -- Begin Validation
185: -- validate params
186: if( P_OBJECT_CODE is null

Line 192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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);
195: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
196: return;

Line 195: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
195: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
196: return;
197: end if;
198:
199: OPEN Validate_Solution;

Line 205: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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,
208: p_data => X_MSG_DATA);
209: return;

Line 206: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
208: p_data => X_MSG_DATA);
209: return;
210: END IF;

Line 243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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,
246: p_data => X_MSG_DATA);
247: return;

Line 244: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
246: p_data => X_MSG_DATA);
247: return;
248: END IF;

Line 257: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

253:
254: IF l_dup_count > 0 THEN
255: -- Bug fix 3350231: Used to return error.
256: -- Now just return success if the link is already there.
257: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
258: return;
259: END IF;
260:
261: IF ( P_LINK_TYPE not in ('PS', 'S', 'NS') ) THEN

Line 264: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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,
267: p_data => X_MSG_DATA);
268: return;

Line 265: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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,
267: p_data => X_MSG_DATA);
268: return;
269: END IF;

Line 393: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

389: END IF;
390: END IF;
391: END IF;
392: x_link_id := l_id;
393: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
394:
395:
396: EXCEPTION
397: WHEN OTHERS THEN

Line 405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
408: p_data => x_msg_data);
409: end Create_Set_Link;

Line 406: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
408: p_data => x_msg_data);
409: end Create_Set_Link;
410:

Line 531: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then

527: x_link_id => l_link_id ,
528: x_return_status => l_return_status ,
529: x_msg_data => l_msg_data ,
530: x_msg_count => l_msg_count);
531: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then
532: return l_link_id;
533: else
534: return ERROR_STATUS;
535: end if;

Line 592: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then

588: x_link_id => l_link_id ,
589: x_return_status => l_return_status ,
590: x_msg_data => l_msg_data ,
591: x_msg_count => l_msg_count);
592: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then
593: return l_link_id;
594: else
595: return ERROR_STATUS;
596: end if;

Line 737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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);
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: return;

Line 740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
740: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
741: return;
742: end if;
743:
744: -- validate the link type

Line 748: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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);
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: return;

Line 751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
751: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
752: return;
753: END IF;
754:
755: -- validate that the link being updated exists and the link being

Line 764: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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);
767: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
768: return;

Line 767: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
767: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
768: return;
769: ELSE
770: CLOSE Validate_Link;
771: END IF;

Line 782: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE ,

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);
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: return;

Line 785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
785: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
786: return;
787: END IF;
788: -- End Validation
789:

Line 880: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

876: X_ATTRIBUTE13 => P_ATTRIBUTE13,
877: X_ATTRIBUTE14 => P_ATTRIBUTE14,
878: X_ATTRIBUTE15 => P_ATTRIBUTE15);
879: END IF;
880: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
881:
882: exception
883: when others then
884: ROLLBACK TO Update_Link_SP;

Line 890: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

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,
893: p_count => x_msg_count,
894: p_data => x_msg_data);

Line 892: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
893: p_count => x_msg_count,
894: p_data => x_msg_data);
895: END Update_Set_Link;
896:

Line 950: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

946: P_ATTRIBUTE15 => P_ATTRIBUTE15 ,
947: x_return_status => l_return_status ,
948: x_msg_data => l_msg_data ,
949: x_msg_count => l_msg_count);
950: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
951: return ERROR_STATUS;
952: end if;
953: return OKAY_STATUS;
954: end Update_Set_Link;