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 417: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

413: END IF;
414: END IF;
415: END IF;
416: x_link_id := l_id;
417: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
418:
419:
420: EXCEPTION
421: WHEN OTHERS THEN

Line 429: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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,
432: p_data => x_msg_data);
433: end Create_Set_Link;
434:

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

551: x_link_id => l_link_id ,
552: x_return_status => l_return_status ,
553: x_msg_data => l_msg_data ,
554: x_msg_count => l_msg_count);
555: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then
556: return l_link_id;
557: else
558: return ERROR_STATUS;
559: end if;

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

612: x_link_id => l_link_id ,
613: x_return_status => l_return_status ,
614: x_msg_data => l_msg_data ,
615: x_msg_count => l_msg_count);
616: if( l_return_status = FND_API.G_RET_STS_SUCCESS ) then
617: return l_link_id;
618: else
619: return ERROR_STATUS;
620: end if;

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

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

Line 764: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
764: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
765: return;
766: end if;
767:
768: -- validate the link type

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

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

Line 775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: return;
777: END IF;
778:
779: -- validate that the link being updated exists and the link being

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

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

Line 791: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
791: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
792: return;
793: ELSE
794: CLOSE Validate_Link;
795: END IF;

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

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

Line 809: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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);
809: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
810: return;
811: END IF;
812: -- End Validation
813:

Line 904: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

900: X_ATTRIBUTE13 => P_ATTRIBUTE13,
901: X_ATTRIBUTE14 => P_ATTRIBUTE14,
902: X_ATTRIBUTE15 => P_ATTRIBUTE15);
903: END IF;
904: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
905:
906: exception
907: when others then
908: ROLLBACK TO Update_Link_SP;

Line 914: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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,
917: p_count => x_msg_count,
918: p_data => x_msg_data);
919: END Update_Set_Link;
920:

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

970: P_ATTRIBUTE15 => P_ATTRIBUTE15 ,
971: x_return_status => l_return_status ,
972: x_msg_data => l_msg_data ,
973: x_msg_count => l_msg_count);
974: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
975: return ERROR_STATUS;
976: end if;
977: return OKAY_STATUS;
978: end Update_Set_Link;