eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_KNOWLEDGE_PVT dependencies on FND_API

Line 173: return FND_API.G_TRUE;

169: l_count := 1;
170: end if;
171: else
172: fnd_message.set_name('CS','CS_KB_C_MISS_PARAM');
173: return FND_API.G_TRUE;
174: end if;
175: i1 := p_ele_def_tbl.NEXT(i1);
176: end loop;
177: if(l_count = 0) then

Line 178: return FND_API.G_TRUE;

174: end if;
175: i1 := p_ele_def_tbl.NEXT(i1);
176: end loop;
177: if(l_count = 0) then
178: return FND_API.G_TRUE;
179: end if;
180:
181: i2 := l_types_tbl.NEXT(i2);
182: end loop;

Line 185: return FND_API.G_FALSE;

181: i2 := l_types_tbl.NEXT(i2);
182: end loop;
183:
184:
185: return FND_API.G_FALSE;
186:
187: <>
188: return FND_API.G_TRUE;
189:

Line 188: return FND_API.G_TRUE;

184:
185: return FND_API.G_FALSE;
186:
187: <>
188: return FND_API.G_TRUE;
189:
190: end Is_Required_Type_Missing;
191:
192: /*

Line 201: if(p_char =FND_API.G_MISS_CHAR) then

197: p_char in varchar2,
198: x_char OUT NOCOPY varchar2
199: ) is
200: begin
201: if(p_char =FND_API.G_MISS_CHAR) then
202: x_char := null;
203: else
204: x_char := p_char;
205: end if;

Line 564: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

560: -- Add external link
561: --
562: PROCEDURE Add_External_Links(
563: p_api_version in number,
564: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
565: p_commit in varchar2, -- := FND_API.G_FALSE,
566: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
567: x_return_status OUT NOCOPY varchar2,
568: x_msg_count OUT NOCOPY number,

Line 565: p_commit in varchar2, -- := FND_API.G_FALSE,

561: --
562: PROCEDURE Add_External_Links(
563: p_api_version in number,
564: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
565: p_commit in varchar2, -- := FND_API.G_FALSE,
566: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
567: x_return_status OUT NOCOPY varchar2,
568: x_msg_count OUT NOCOPY number,
569: x_msg_data OUT NOCOPY varchar2,

Line 566: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

562: PROCEDURE Add_External_Links(
563: p_api_version in number,
564: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
565: p_commit in varchar2, -- := FND_API.G_FALSE,
566: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
567: x_return_status OUT NOCOPY varchar2,
568: x_msg_count OUT NOCOPY number,
569: x_msg_data OUT NOCOPY varchar2,
570: p_usage_code in varchar2,

Line 585: if not FND_API.Compatible_API_Call(

581: l_id number;
582: begin
583: savepoint Add_External_Links_Pvt;
584:
585: if not FND_API.Compatible_API_Call(
586: l_api_version,
587: p_api_version,
588: l_api_name,
589: G_PKG_NAME) then

Line 590: raise FND_API.G_EXC_UNEXPECTED_ERROR;

586: l_api_version,
587: p_api_version,
588: l_api_name,
589: G_PKG_NAME) then
590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
591: end if;
592:
593: if FND_API.to_Boolean(p_init_msg_list) then
594: FND_MSG_PUB.initialize;

Line 593: if FND_API.to_Boolean(p_init_msg_list) then

589: G_PKG_NAME) then
590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
591: end if;
592:
593: if FND_API.to_Boolean(p_init_msg_list) then
594: FND_MSG_PUB.initialize;
595: end if;
596:
597: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 597: x_return_status := FND_API.G_RET_STS_SUCCESS;

593: if FND_API.to_Boolean(p_init_msg_list) then
594: FND_MSG_PUB.initialize;
595: end if;
596:
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: -- -- -- -- begin my code -- -- -- -- --
599:
600: -- Check params
601: if(p_usage_code is null or p_id is null or

Line 610: raise FND_API.G_EXC_ERROR;

606: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
607: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
608: fnd_msg_pub.Add;
609: end if;
610: raise FND_API.G_EXC_ERROR;
611: end if;
612:
613: i1 := p_other_id_tbl.FIRST;
614: while i1 is not null loop

Line 651: raise FND_API.G_EXC_UNEXPECTED_ERROR;

647: end if;
648: end if;
649:
650: if(not l_id>0) then
651: raise FND_API.G_EXC_UNEXPECTED_ERROR;
652: end if;
653:
654: i1 := p_other_id_tbl.NEXT(i1);
655: end loop;

Line 660: IF FND_API.To_Boolean( p_commit ) THEN

656:
657:
658: -- -- -- -- end of code -- -- --
659:
660: IF FND_API.To_Boolean( p_commit ) THEN
661: COMMIT WORK;
662: END IF;
663:
664: -- Standard call to get message count. if count=1, get message info.

Line 670: WHEN FND_API.G_EXC_ERROR THEN

666: p_count => x_msg_count,
667: p_data => x_msg_data );
668:
669: EXCEPTION
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO Add_External_Links_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR ;
673: FND_MSG_PUB.Count_And_Get(
674: p_count => x_msg_count,

Line 672: x_return_status := FND_API.G_RET_STS_ERROR ;

668:
669: EXCEPTION
670: WHEN FND_API.G_EXC_ERROR THEN
671: ROLLBACK TO Add_External_Links_PVT;
672: x_return_status := FND_API.G_RET_STS_ERROR ;
673: FND_MSG_PUB.Count_And_Get(
674: p_count => x_msg_count,
675: p_data => x_msg_data );
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

672: x_return_status := FND_API.G_RET_STS_ERROR ;
673: FND_MSG_PUB.Count_And_Get(
674: p_count => x_msg_count,
675: p_data => x_msg_data );
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: ROLLBACK TO Add_External_Links_PVT;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: FND_MSG_PUB.Count_And_Get(
680: p_count => x_msg_count,

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

674: p_count => x_msg_count,
675: p_data => x_msg_data );
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677: ROLLBACK TO Add_External_Links_PVT;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: FND_MSG_PUB.Count_And_Get(
680: p_count => x_msg_count,
681: p_data => x_msg_data);
682: WHEN OTHERS THEN

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

680: p_count => x_msg_count,
681: p_data => x_msg_data);
682: WHEN OTHERS THEN
683: ROLLBACK TO Add_External_Links_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: IF FND_MSG_PUB.Check_Msg_Level
686: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
687: FND_MSG_PUB.Add_Exc_Msg(
688: G_PKG_NAME,

Line 705: p_init_msg_list in varchar2 := FND_API.G_FALSE,

701: -- If new id <= 0, remove link
702: --
703: PROCEDURE Change_Ele_Type_Links(
704: p_api_version in number,
705: p_init_msg_list in varchar2 := FND_API.G_FALSE,
706: p_commit in varchar2 := FND_API.G_FALSE,
707: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
708: x_return_status OUT NOCOPY varchar2,
709: x_msg_count OUT NOCOPY number,

Line 706: p_commit in varchar2 := FND_API.G_FALSE,

702: --
703: PROCEDURE Change_Ele_Type_Links(
704: p_api_version in number,
705: p_init_msg_list in varchar2 := FND_API.G_FALSE,
706: p_commit in varchar2 := FND_API.G_FALSE,
707: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
708: x_return_status OUT NOCOPY varchar2,
709: x_msg_count OUT NOCOPY number,
710: x_msg_data OUT NOCOPY varchar2,

Line 707: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

703: PROCEDURE Change_Ele_Type_Links(
704: p_api_version in number,
705: p_init_msg_list in varchar2 := FND_API.G_FALSE,
706: p_commit in varchar2 := FND_API.G_FALSE,
707: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
708: x_return_status OUT NOCOPY varchar2,
709: x_msg_count OUT NOCOPY number,
710: x_msg_data OUT NOCOPY varchar2,
711: p_link_id_tbl in cs_kb_number_tbl_type,

Line 722: if not FND_API.Compatible_API_Call(

718: l_count pls_integer;
719: begin
720: savepoint Change_Ele_Type_Links_PVT;
721:
722: if not FND_API.Compatible_API_Call(
723: l_api_version,
724: p_api_version,
725: l_api_name,
726: G_PKG_NAME) then

Line 727: raise FND_API.G_EXC_UNEXPECTED_ERROR;

723: l_api_version,
724: p_api_version,
725: l_api_name,
726: G_PKG_NAME) then
727: raise FND_API.G_EXC_UNEXPECTED_ERROR;
728: end if;
729:
730: if FND_API.to_Boolean(p_init_msg_list) then
731: FND_MSG_PUB.initialize;

Line 730: if FND_API.to_Boolean(p_init_msg_list) then

726: G_PKG_NAME) then
727: raise FND_API.G_EXC_UNEXPECTED_ERROR;
728: end if;
729:
730: if FND_API.to_Boolean(p_init_msg_list) then
731: FND_MSG_PUB.initialize;
732: end if;
733:
734: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 734: x_return_status := FND_API.G_RET_STS_SUCCESS;

730: if FND_API.to_Boolean(p_init_msg_list) then
731: FND_MSG_PUB.initialize;
732: end if;
733:
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735: -- -- -- -- begin my code -- -- -- -- --
736:
737: -- Check params
738: if(p_link_id_tbl is null or p_ele_type_id_tbl is null or

Line 746: raise FND_API.G_EXC_ERROR;

742: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
743: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
744: fnd_msg_pub.Add;
745: end if;
746: raise FND_API.G_EXC_ERROR;
747:
748: end if;
749:
750: i1 := p_link_id_tbl.FIRST;

Line 766: raise FND_API.G_EXC_ERROR;

762: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
763: fnd_msg_pub.Add;
764: end if;
765:
766: raise FND_API.G_EXC_ERROR;
767: end if;
768:
769: update cs_kb_ele_type_links set
770: element_type_id = l_ele_type_id

Line 782: IF FND_API.To_Boolean( p_commit ) THEN

778: end loop;
779:
780: -- -- -- -- end of code -- -- --
781:
782: IF FND_API.To_Boolean( p_commit ) THEN
783: COMMIT WORK;
784: END IF;
785:
786: -- Standard call to get message count. if count=1, get message info.

Line 792: WHEN FND_API.G_EXC_ERROR THEN

788: p_count => x_msg_count,
789: p_data => x_msg_data );
790:
791: EXCEPTION
792: WHEN FND_API.G_EXC_ERROR THEN
793: ROLLBACK TO Change_Ele_Type_Links_PVT;
794: x_return_status := FND_API.G_RET_STS_ERROR ;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,

Line 794: x_return_status := FND_API.G_RET_STS_ERROR ;

790:
791: EXCEPTION
792: WHEN FND_API.G_EXC_ERROR THEN
793: ROLLBACK TO Change_Ele_Type_Links_PVT;
794: x_return_status := FND_API.G_RET_STS_ERROR ;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data );
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

794: x_return_status := FND_API.G_RET_STS_ERROR ;
795: FND_MSG_PUB.Count_And_Get(
796: p_count => x_msg_count,
797: p_data => x_msg_data );
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO Change_Ele_Type_Links_PVT;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,

Line 800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

796: p_count => x_msg_count,
797: p_data => x_msg_data );
798: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO Change_Ele_Type_Links_PVT;
800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
801: FND_MSG_PUB.Count_And_Get(
802: p_count => x_msg_count,
803: p_data => x_msg_data);
804: WHEN OTHERS THEN

Line 806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

802: p_count => x_msg_count,
803: p_data => x_msg_data);
804: WHEN OTHERS THEN
805: ROLLBACK TO Change_Ele_Type_Links_PVT;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: IF FND_MSG_PUB.Check_Msg_Level
808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
809: FND_MSG_PUB.Add_Exc_Msg(
810: G_PKG_NAME,

Line 826: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

822: -- If new set id <= 0, remove link
823: --
824: PROCEDURE Change_Set_Links(
825: p_api_version in number,
826: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
827: p_commit in varchar2, -- := FND_API.G_FALSE,
828: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
829: x_return_status OUT NOCOPY varchar2,
830: x_msg_count OUT NOCOPY number,

Line 827: p_commit in varchar2, -- := FND_API.G_FALSE,

823: --
824: PROCEDURE Change_Set_Links(
825: p_api_version in number,
826: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
827: p_commit in varchar2, -- := FND_API.G_FALSE,
828: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
829: x_return_status OUT NOCOPY varchar2,
830: x_msg_count OUT NOCOPY number,
831: x_msg_data OUT NOCOPY varchar2,

Line 828: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

824: PROCEDURE Change_Set_Links(
825: p_api_version in number,
826: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
827: p_commit in varchar2, -- := FND_API.G_FALSE,
828: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
829: x_return_status OUT NOCOPY varchar2,
830: x_msg_count OUT NOCOPY number,
831: x_msg_data OUT NOCOPY varchar2,
832: p_link_id_tbl in cs_kb_number_tbl_type,

Line 843: if not FND_API.Compatible_API_Call(

839: l_count pls_integer;
840: begin
841: savepoint Change_Set_Links_PVT;
842:
843: if not FND_API.Compatible_API_Call(
844: l_api_version,
845: p_api_version,
846: l_api_name,
847: G_PKG_NAME) then

Line 848: raise FND_API.G_EXC_UNEXPECTED_ERROR;

844: l_api_version,
845: p_api_version,
846: l_api_name,
847: G_PKG_NAME) then
848: raise FND_API.G_EXC_UNEXPECTED_ERROR;
849: end if;
850:
851: if FND_API.to_Boolean(p_init_msg_list) then
852: FND_MSG_PUB.initialize;

Line 851: if FND_API.to_Boolean(p_init_msg_list) then

847: G_PKG_NAME) then
848: raise FND_API.G_EXC_UNEXPECTED_ERROR;
849: end if;
850:
851: if FND_API.to_Boolean(p_init_msg_list) then
852: FND_MSG_PUB.initialize;
853: end if;
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 855: x_return_status := FND_API.G_RET_STS_SUCCESS;

851: if FND_API.to_Boolean(p_init_msg_list) then
852: FND_MSG_PUB.initialize;
853: end if;
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: -- -- -- -- begin my code -- -- -- -- --
857:
858: -- Check params
859: if(p_link_id_tbl is null or p_set_id_tbl is null or

Line 867: raise FND_API.G_EXC_ERROR;

863: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
864: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
865: fnd_msg_pub.Add;
866: end if;
867: raise FND_API.G_EXC_ERROR;
868: end if;
869:
870: i1 := p_link_id_tbl.FIRST;
871: while i1 is not null loop

Line 885: raise FND_API.G_EXC_ERROR;

881: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
882: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
883: fnd_msg_pub.Add;
884: end if;
885: raise FND_API.G_EXC_ERROR;
886: end if;
887:
888: update cs_kb_set_links set
889: set_id = l_set_id

Line 901: IF FND_API.To_Boolean( p_commit ) THEN

897: end loop;
898:
899: -- -- -- -- end of code -- -- --
900:
901: IF FND_API.To_Boolean( p_commit ) THEN
902: COMMIT WORK;
903: END IF;
904:
905: -- Standard call to get message count. if count=1, get message info.

Line 911: WHEN FND_API.G_EXC_ERROR THEN

907: p_count => x_msg_count,
908: p_data => x_msg_data );
909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO Change_Set_Links_PVT;
913: x_return_status := FND_API.G_RET_STS_ERROR ;
914: FND_MSG_PUB.Count_And_Get(
915: p_count => x_msg_count,

Line 913: x_return_status := FND_API.G_RET_STS_ERROR ;

909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO Change_Set_Links_PVT;
913: x_return_status := FND_API.G_RET_STS_ERROR ;
914: FND_MSG_PUB.Count_And_Get(
915: p_count => x_msg_count,
916: p_data => x_msg_data );
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

913: x_return_status := FND_API.G_RET_STS_ERROR ;
914: FND_MSG_PUB.Count_And_Get(
915: p_count => x_msg_count,
916: p_data => x_msg_data );
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO Change_Set_Links_PVT;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_And_Get(
921: p_count => x_msg_count,

Line 919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

915: p_count => x_msg_count,
916: p_data => x_msg_data );
917: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
918: ROLLBACK TO Change_Set_Links_PVT;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: FND_MSG_PUB.Count_And_Get(
921: p_count => x_msg_count,
922: p_data => x_msg_data);
923: WHEN OTHERS THEN

Line 925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

921: p_count => x_msg_count,
922: p_data => x_msg_data);
923: WHEN OTHERS THEN
924: ROLLBACK TO Change_Set_Links_PVT;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926: IF FND_MSG_PUB.Check_Msg_Level
927: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
928: FND_MSG_PUB.Add_Exc_Msg(
929: G_PKG_NAME,

Line 943: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

939: -- Delete link to set or change link to new element id
940: --
941: PROCEDURE Change_Element_To_Sets(
942: p_api_version in number,
943: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
944: p_commit in varchar2, -- := FND_API.G_FALSE,
945: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY varchar2,
947: x_msg_count OUT NOCOPY number,

Line 944: p_commit in varchar2, -- := FND_API.G_FALSE,

940: --
941: PROCEDURE Change_Element_To_Sets(
942: p_api_version in number,
943: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
944: p_commit in varchar2, -- := FND_API.G_FALSE,
945: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY varchar2,
947: x_msg_count OUT NOCOPY number,
948: x_msg_data OUT NOCOPY varchar2,

Line 945: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

941: PROCEDURE Change_Element_To_Sets(
942: p_api_version in number,
943: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
944: p_commit in varchar2, -- := FND_API.G_FALSE,
945: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
946: x_return_status OUT NOCOPY varchar2,
947: x_msg_count OUT NOCOPY number,
948: x_msg_data OUT NOCOPY varchar2,
949: p_element_id in number,

Line 963: if not FND_API.Compatible_API_Call(

959:
960: begin
961: savepoint Change_Element_To_Sets_PVT;
962:
963: if not FND_API.Compatible_API_Call(
964: l_api_version,
965: p_api_version,
966: l_api_name,
967: G_PKG_NAME) then

Line 968: raise FND_API.G_EXC_UNEXPECTED_ERROR;

964: l_api_version,
965: p_api_version,
966: l_api_name,
967: G_PKG_NAME) then
968: raise FND_API.G_EXC_UNEXPECTED_ERROR;
969: end if;
970:
971: if FND_API.to_Boolean(p_init_msg_list) then
972: FND_MSG_PUB.initialize;

Line 971: if FND_API.to_Boolean(p_init_msg_list) then

967: G_PKG_NAME) then
968: raise FND_API.G_EXC_UNEXPECTED_ERROR;
969: end if;
970:
971: if FND_API.to_Boolean(p_init_msg_list) then
972: FND_MSG_PUB.initialize;
973: end if;
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 975: x_return_status := FND_API.G_RET_STS_SUCCESS;

971: if FND_API.to_Boolean(p_init_msg_list) then
972: FND_MSG_PUB.initialize;
973: end if;
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976: -- -- -- -- begin my code -- -- -- -- --
977:
978: -- Check params
979: if(p_set_id_tbl is null or p_new_ele_id_tbl is null or

Line 988: raise FND_API.G_EXC_ERROR;

984: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
985: fnd_msg_pub.Add;
986: end if;
987:
988: raise FND_API.G_EXC_ERROR;
989: end if;
990:
991: i1 := p_set_id_tbl.FIRST;
992: while i1 is not null loop

Line 1008: raise FND_API.G_EXC_ERROR;

1004: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1005: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1006: fnd_msg_pub.Add;
1007: end if;
1008: raise FND_API.G_EXC_ERROR;
1009: end if;
1010:
1011: -- new ele and old ele cannot be in same set
1012: select count(*) into l_count

Line 1021: raise FND_API.G_EXC_ERROR;

1017: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1018: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1019: fnd_msg_pub.Add;
1020: end if;
1021: raise FND_API.G_EXC_ERROR;
1022: end if;
1023:
1024: -- add new element, then delete old ele.
1025: -- checking of type compatibility and required types handled by apis

Line 1032: raise FND_API.G_EXC_ERROR;

1028: p_ele_id => l_element_id,
1029: p_set_id => p_set_id_tbl(i1));
1030: if(l_retnum <> OKAY_STATUS) then
1031: fnd_msg_pub.Add;
1032: raise FND_API.G_EXC_ERROR;
1033: end if;
1034:
1035: l_retnum := Del_Element_From_Set(
1036: p_ele_id => p_element_id,

Line 1040: raise FND_API.G_EXC_ERROR;

1036: p_ele_id => p_element_id,
1037: p_set_id => p_set_id_tbl(i1));
1038: if(l_retnum <> OKAY_STATUS) then
1039: fnd_msg_pub.Add;
1040: raise FND_API.G_EXC_ERROR;
1041: end if;
1042:
1043:
1044: -- update

Line 1053: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1049: l_retnum := CS_Knowledge_Pvt.Del_Element_From_Set(
1050: p_ele_id => p_element_id,
1051: p_set_id => p_set_id_tbl(i1));
1052: if(l_retnum = ERROR_STATUS) then
1053: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1054: end if;
1055: end if;
1056:
1057: end if;

Line 1064: IF FND_API.To_Boolean( p_commit ) THEN

1060: end loop;
1061:
1062: -- -- -- -- end of code -- -- --
1063:
1064: IF FND_API.To_Boolean( p_commit ) THEN
1065: COMMIT WORK;
1066: END IF;
1067:
1068: -- Standard call to get message count. if count=1, get message info.

Line 1074: WHEN FND_API.G_EXC_ERROR THEN

1070: p_count => x_msg_count,
1071: p_data => x_msg_data );
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO Change_Element_To_Sets_PVT;
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: FND_MSG_PUB.Count_And_Get(
1078: p_count => x_msg_count,

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR ;

1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO Change_Element_To_Sets_PVT;
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: FND_MSG_PUB.Count_And_Get(
1078: p_count => x_msg_count,
1079: p_data => x_msg_data );
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: FND_MSG_PUB.Count_And_Get(
1078: p_count => x_msg_count,
1079: p_data => x_msg_data );
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: ROLLBACK TO Change_Element_To_Sets_PVT;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1083: FND_MSG_PUB.Count_And_Get(
1084: p_count => x_msg_count,

Line 1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1078: p_count => x_msg_count,
1079: p_data => x_msg_data );
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: ROLLBACK TO Change_Element_To_Sets_PVT;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1083: FND_MSG_PUB.Count_And_Get(
1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086: WHEN OTHERS THEN

Line 1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086: WHEN OTHERS THEN
1087: ROLLBACK TO Change_Element_To_Sets_PVT;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: IF FND_MSG_PUB.Check_Msg_Level
1090: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1091: FND_MSG_PUB.Add_Exc_Msg(
1092: G_PKG_NAME,

Line 1108: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

1104: -- If new element id <= 0, remove link
1105: --
1106: PROCEDURE Change_Element_Links(
1107: p_api_version in number,
1108: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
1109: p_commit in varchar2, -- := FND_API.G_FALSE,
1110: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
1111: x_return_status OUT NOCOPY varchar2,
1112: x_msg_count OUT NOCOPY number,

Line 1109: p_commit in varchar2, -- := FND_API.G_FALSE,

1105: --
1106: PROCEDURE Change_Element_Links(
1107: p_api_version in number,
1108: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
1109: p_commit in varchar2, -- := FND_API.G_FALSE,
1110: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
1111: x_return_status OUT NOCOPY varchar2,
1112: x_msg_count OUT NOCOPY number,
1113: x_msg_data OUT NOCOPY varchar2,

Line 1110: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

1106: PROCEDURE Change_Element_Links(
1107: p_api_version in number,
1108: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
1109: p_commit in varchar2, -- := FND_API.G_FALSE,
1110: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
1111: x_return_status OUT NOCOPY varchar2,
1112: x_msg_count OUT NOCOPY number,
1113: x_msg_data OUT NOCOPY varchar2,
1114: p_link_id_tbl in cs_kb_number_tbl_type,

Line 1125: if not FND_API.Compatible_API_Call(

1121: l_count pls_integer;
1122: begin
1123: savepoint Change_Element_Links_PVT;
1124:
1125: if not FND_API.Compatible_API_Call(
1126: l_api_version,
1127: p_api_version,
1128: l_api_name,
1129: G_PKG_NAME) then

Line 1130: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1126: l_api_version,
1127: p_api_version,
1128: l_api_name,
1129: G_PKG_NAME) then
1130: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1131: end if;
1132:
1133: if FND_API.to_Boolean(p_init_msg_list) then
1134: FND_MSG_PUB.initialize;

Line 1133: if FND_API.to_Boolean(p_init_msg_list) then

1129: G_PKG_NAME) then
1130: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1131: end if;
1132:
1133: if FND_API.to_Boolean(p_init_msg_list) then
1134: FND_MSG_PUB.initialize;
1135: end if;
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1137: x_return_status := FND_API.G_RET_STS_SUCCESS;

1133: if FND_API.to_Boolean(p_init_msg_list) then
1134: FND_MSG_PUB.initialize;
1135: end if;
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138: -- -- -- -- begin my code -- -- -- -- --
1139:
1140: -- Check params
1141: if(p_link_id_tbl is null or p_element_id_tbl is null or

Line 1149: raise FND_API.G_EXC_ERROR;

1145: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1146: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1147: fnd_msg_pub.Add;
1148: end if;
1149: raise FND_API.G_EXC_ERROR;
1150: end if;
1151:
1152: i1 := p_link_id_tbl.FIRST;
1153: while i1 is not null loop

Line 1167: raise FND_API.G_EXC_ERROR;

1163: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1164: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1165: fnd_msg_pub.Add;
1166: end if;
1167: raise FND_API.G_EXC_ERROR;
1168: end if;
1169:
1170: update cs_kb_element_links set
1171: element_id = l_element_id

Line 1183: IF FND_API.To_Boolean( p_commit ) THEN

1179: end loop;
1180:
1181: -- -- -- -- end of code -- -- --
1182:
1183: IF FND_API.To_Boolean( p_commit ) THEN
1184: COMMIT WORK;
1185: END IF;
1186:
1187: -- Standard call to get message count. if count=1, get message info.

Line 1193: WHEN FND_API.G_EXC_ERROR THEN

1189: p_count => x_msg_count,
1190: p_data => x_msg_data );
1191:
1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO Change_Element_Links_PVT;
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: FND_MSG_PUB.Count_And_Get(
1197: p_count => x_msg_count,

Line 1195: x_return_status := FND_API.G_RET_STS_ERROR ;

1191:
1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO Change_Element_Links_PVT;
1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: FND_MSG_PUB.Count_And_Get(
1197: p_count => x_msg_count,
1198: p_data => x_msg_data );
1199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1195: x_return_status := FND_API.G_RET_STS_ERROR ;
1196: FND_MSG_PUB.Count_And_Get(
1197: p_count => x_msg_count,
1198: p_data => x_msg_data );
1199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1200: ROLLBACK TO Change_Element_Links_PVT;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: FND_MSG_PUB.Count_And_Get(
1203: p_count => x_msg_count,

Line 1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1197: p_count => x_msg_count,
1198: p_data => x_msg_data );
1199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1200: ROLLBACK TO Change_Element_Links_PVT;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: FND_MSG_PUB.Count_And_Get(
1203: p_count => x_msg_count,
1204: p_data => x_msg_data);
1205: WHEN OTHERS THEN

Line 1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1203: p_count => x_msg_count,
1204: p_data => x_msg_data);
1205: WHEN OTHERS THEN
1206: ROLLBACK TO Change_Element_Links_PVT;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: IF FND_MSG_PUB.Check_Msg_Level
1209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: FND_MSG_PUB.Add_Exc_Msg(
1211: G_PKG_NAME,

Line 1523: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1519: -- Original (Pre 8/03/00) Contributed element ids not passed back
1520: --
1521: PROCEDURE Create_Set_And_Elements(
1522: p_api_version in number,
1523: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1524: p_commit in varchar2 := FND_API.G_FALSE,
1525: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1526: x_return_status OUT NOCOPY varchar2,
1527: x_msg_count OUT NOCOPY number,

Line 1524: p_commit in varchar2 := FND_API.G_FALSE,

1520: --
1521: PROCEDURE Create_Set_And_Elements(
1522: p_api_version in number,
1523: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1524: p_commit in varchar2 := FND_API.G_FALSE,
1525: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1526: x_return_status OUT NOCOPY varchar2,
1527: x_msg_count OUT NOCOPY number,
1528: x_msg_data OUT NOCOPY varchar2,

Line 1525: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1521: PROCEDURE Create_Set_And_Elements(
1522: p_api_version in number,
1523: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1524: p_commit in varchar2 := FND_API.G_FALSE,
1525: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1526: x_return_status OUT NOCOPY varchar2,
1527: x_msg_count OUT NOCOPY number,
1528: x_msg_data OUT NOCOPY varchar2,
1529: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 1558: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1554: -- Wrapper - calls (4)
1555: -- New (Post 8/03/00) Contributed element ids passed back
1556: PROCEDURE Create_Set_And_Elements(
1557: p_api_version in number,
1558: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1559: p_commit in varchar2 := FND_API.G_FALSE,
1560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY varchar2,
1562: x_msg_count OUT NOCOPY number,

Line 1559: p_commit in varchar2 := FND_API.G_FALSE,

1555: -- New (Post 8/03/00) Contributed element ids passed back
1556: PROCEDURE Create_Set_And_Elements(
1557: p_api_version in number,
1558: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1559: p_commit in varchar2 := FND_API.G_FALSE,
1560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY varchar2,
1562: x_msg_count OUT NOCOPY number,
1563: x_msg_data OUT NOCOPY varchar2,

Line 1560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1556: PROCEDURE Create_Set_And_Elements(
1557: p_api_version in number,
1558: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1559: p_commit in varchar2 := FND_API.G_FALSE,
1560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1561: x_return_status OUT NOCOPY varchar2,
1562: x_msg_count OUT NOCOPY number,
1563: x_msg_data OUT NOCOPY varchar2,
1564: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 1605: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)

1601: x_set_id => x_set_id,
1602: x_element_id_tbl => l_element_id_tbl);
1603:
1604:
1605: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1606: then
1607: raise FND_API.G_EXC_ERROR;
1608: end if;
1609:

Line 1607: raise FND_API.G_EXC_ERROR;

1603:
1604:
1605: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1606: then
1607: raise FND_API.G_EXC_ERROR;
1608: end if;
1609:
1610: -- Create new element id table out param if it's not there
1611: if ( x_element_id_tbl is null) then

Line 1626: WHEN FND_API.G_EXC_ERROR THEN

1622: end loop;
1623: end if;
1624:
1625: exception
1626: WHEN FND_API.G_EXC_ERROR THEN
1627: x_return_status := FND_API.G_RET_STS_ERROR ;
1628: FND_MSG_PUB.Count_And_Get(
1629: p_encoded => FND_API.G_FALSE ,
1630: p_count => x_msg_count,

Line 1627: x_return_status := FND_API.G_RET_STS_ERROR ;

1623: end if;
1624:
1625: exception
1626: WHEN FND_API.G_EXC_ERROR THEN
1627: x_return_status := FND_API.G_RET_STS_ERROR ;
1628: FND_MSG_PUB.Count_And_Get(
1629: p_encoded => FND_API.G_FALSE ,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data );

Line 1629: p_encoded => FND_API.G_FALSE ,

1625: exception
1626: WHEN FND_API.G_EXC_ERROR THEN
1627: x_return_status := FND_API.G_RET_STS_ERROR ;
1628: FND_MSG_PUB.Count_And_Get(
1629: p_encoded => FND_API.G_FALSE ,
1630: p_count => x_msg_count,
1631: p_data => x_msg_data );
1632: end Create_Set_And_Elements;
1633:

Line 1642: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1638: -- Original (Pre 8/03/00) Contributed element ids not passed back
1639: --
1640: PROCEDURE Create_Set_And_Elements(
1641: p_api_version in number,
1642: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1643: p_commit in varchar2 := FND_API.G_FALSE,
1644: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1645: x_return_status OUT NOCOPY varchar2,
1646: x_msg_count OUT NOCOPY number,

Line 1643: p_commit in varchar2 := FND_API.G_FALSE,

1639: --
1640: PROCEDURE Create_Set_And_Elements(
1641: p_api_version in number,
1642: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1643: p_commit in varchar2 := FND_API.G_FALSE,
1644: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1645: x_return_status OUT NOCOPY varchar2,
1646: x_msg_count OUT NOCOPY number,
1647: x_msg_data OUT NOCOPY varchar2,

Line 1644: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1640: PROCEDURE Create_Set_And_Elements(
1641: p_api_version in number,
1642: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1643: p_commit in varchar2 := FND_API.G_FALSE,
1644: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1645: x_return_status OUT NOCOPY varchar2,
1646: x_msg_count OUT NOCOPY number,
1647: x_msg_data OUT NOCOPY varchar2,
1648: p_set_def_obj in cs_kb_set_def_obj_type,

Line 1680: if not FND_API.Compatible_API_Call(

1676: -- incr_ele_ele for all possible links
1677:
1678: savepoint Create_Set_And_Elements_PVT;
1679:
1680: if not FND_API.Compatible_API_Call(
1681: l_api_version,
1682: p_api_version,
1683: l_api_name,
1684: G_PKG_NAME) then

Line 1685: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1681: l_api_version,
1682: p_api_version,
1683: l_api_name,
1684: G_PKG_NAME) then
1685: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1686: end if;
1687:
1688: if FND_API.to_Boolean(p_init_msg_list) then
1689: FND_MSG_PUB.initialize;

Line 1688: if FND_API.to_Boolean(p_init_msg_list) then

1684: G_PKG_NAME) then
1685: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1686: end if;
1687:
1688: if FND_API.to_Boolean(p_init_msg_list) then
1689: FND_MSG_PUB.initialize;
1690: end if;
1691:
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1692: x_return_status := FND_API.G_RET_STS_SUCCESS;

1688: if FND_API.to_Boolean(p_init_msg_list) then
1689: FND_MSG_PUB.initialize;
1690: end if;
1691:
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;
1693:
1694:
1695: -- -- -- -- begin my code -- -- -- -- --
1696:

Line 1714: IF FND_API.To_Boolean( p_commit ) THEN

1710:
1711:
1712: -- -- -- -- end of code -- -- --
1713:
1714: IF FND_API.To_Boolean( p_commit ) THEN
1715: COMMIT WORK;
1716: END IF;
1717:
1718: -- Standard call to get message count. if count=1, get message info.

Line 1724: WHEN FND_API.G_EXC_ERROR THEN

1720: p_count => x_msg_count,
1721: p_data => x_msg_data );
1722:
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: ROLLBACK TO Create_Set_And_Elements_PVT;
1726: x_return_status := FND_API.G_RET_STS_ERROR ;
1727: FND_MSG_PUB.Count_And_Get(
1728: p_count => x_msg_count,

Line 1726: x_return_status := FND_API.G_RET_STS_ERROR ;

1722:
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: ROLLBACK TO Create_Set_And_Elements_PVT;
1726: x_return_status := FND_API.G_RET_STS_ERROR ;
1727: FND_MSG_PUB.Count_And_Get(
1728: p_count => x_msg_count,
1729: p_data => x_msg_data );
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1726: x_return_status := FND_API.G_RET_STS_ERROR ;
1727: FND_MSG_PUB.Count_And_Get(
1728: p_count => x_msg_count,
1729: p_data => x_msg_data );
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1731: ROLLBACK TO Create_Set_And_Elements_PVT;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1733: FND_MSG_PUB.Count_And_Get(
1734: p_count => x_msg_count,

Line 1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1728: p_count => x_msg_count,
1729: p_data => x_msg_data );
1730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1731: ROLLBACK TO Create_Set_And_Elements_PVT;
1732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1733: FND_MSG_PUB.Count_And_Get(
1734: p_count => x_msg_count,
1735: p_data => x_msg_data);
1736: WHEN OTHERS THEN

Line 1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1734: p_count => x_msg_count,
1735: p_data => x_msg_data);
1736: WHEN OTHERS THEN
1737: ROLLBACK TO Create_Set_And_Elements_PVT;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1739: IF FND_MSG_PUB.Check_Msg_Level
1740: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1741: FND_MSG_PUB.Add_Exc_Msg(
1742: G_PKG_NAME,

Line 1757: p_init_msg_list in varchar2 := FND_API.G_FALSE,

1753: -- New (Post 8/03/00) Contributed element ids passed back
1754: --
1755: PROCEDURE Create_Set_And_Elements(
1756: p_api_version in number,
1757: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1758: p_commit in varchar2 := FND_API.G_FALSE,
1759: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1760: x_return_status OUT NOCOPY varchar2,
1761: x_msg_count OUT NOCOPY number,

Line 1758: p_commit in varchar2 := FND_API.G_FALSE,

1754: --
1755: PROCEDURE Create_Set_And_Elements(
1756: p_api_version in number,
1757: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1758: p_commit in varchar2 := FND_API.G_FALSE,
1759: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1760: x_return_status OUT NOCOPY varchar2,
1761: x_msg_count OUT NOCOPY number,
1762: x_msg_data OUT NOCOPY varchar2,

Line 1759: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

1755: PROCEDURE Create_Set_And_Elements(
1756: p_api_version in number,
1757: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1758: p_commit in varchar2 := FND_API.G_FALSE,
1759: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1760: x_return_status OUT NOCOPY varchar2,
1761: x_msg_count OUT NOCOPY number,
1762: x_msg_data OUT NOCOPY varchar2,
1763: p_set_def_obj in cs_kb_set_def_obj_type,

Line 1822: if not FND_API.Compatible_API_Call(

1818:
1819:
1820: savepoint Create_Set_And_Elements_PVT;
1821:
1822: if not FND_API.Compatible_API_Call(
1823: l_api_version,
1824: p_api_version,
1825: l_api_name,
1826: G_PKG_NAME) then

Line 1827: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1823: l_api_version,
1824: p_api_version,
1825: l_api_name,
1826: G_PKG_NAME) then
1827: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1828: end if;
1829:
1830: if FND_API.to_Boolean(p_init_msg_list) then
1831: FND_MSG_PUB.initialize;

Line 1830: if FND_API.to_Boolean(p_init_msg_list) then

1826: G_PKG_NAME) then
1827: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1828: end if;
1829:
1830: if FND_API.to_Boolean(p_init_msg_list) then
1831: FND_MSG_PUB.initialize;
1832: end if;
1833:
1834: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1834: x_return_status := FND_API.G_RET_STS_SUCCESS;

1830: if FND_API.to_Boolean(p_init_msg_list) then
1831: FND_MSG_PUB.initialize;
1832: end if;
1833:
1834: x_return_status := FND_API.G_RET_STS_SUCCESS;
1835:
1836:
1837: -- -- -- -- begin my code -- -- -- -- --
1838:

Line 1851: raise FND_API.G_EXC_ERROR;

1847: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1848: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1849: fnd_msg_pub.Add;
1850: end if;
1851: raise FND_API.G_EXC_ERROR;
1852:
1853: end if;
1854:
1855: IF(p_set_def_obj.status is not null AND

Line 1865: RAISE FND_API.G_EXC_ERROR;

1861: fnd_message.set_name('CS', 'CS_KB_INV_API_STATUS');
1862: fnd_msg_pub.Add;
1863:
1864: END IF;
1865: RAISE FND_API.G_EXC_ERROR;
1866:
1867: END IF;
1868:
1869: OPEN Get_Defaulted_Category;

Line 1887: RAISE FND_API.G_EXC_ERROR;

1883: TRANSLATE => true);
1884: fnd_msg_pub.Add;
1885:
1886: END IF;
1887: RAISE FND_API.G_EXC_ERROR;
1888: END IF;
1889:
1890: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1891:

Line 1896: raise FND_API.G_EXC_ERROR;

1892: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1893: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1894: fnd_msg_pub.Add;
1895: end if;
1896: raise FND_API.G_EXC_ERROR;
1897:
1898: end if;
1899:
1900: CS_Knowledge_PVT.Get_Who(l_date, l_created_by, l_login);

Line 1937: raise FND_API.G_EXC_ERROR;

1933: p_attribute15 => p_ele_def_tbl(i1).dff_obj.attribute15);
1934:
1935: if not (l_ele_id > 0)
1936: then
1937: raise FND_API.G_EXC_ERROR;
1938: else
1939: x_element_id_tbl(j) := l_ele_id;
1940: end if;
1941:

Line 1954: RAISE FND_API.G_EXC_ERROR;

1950: x_element_id_tbl(j) := p_ele_def_tbl(i1).element_id;
1951: ELSE
1952: FND_MESSAGE.set_name('CS', 'CS_KB_INV_API_ELE_ID');
1953: FND_MSG_PUB.Add;
1954: RAISE FND_API.G_EXC_ERROR;
1955: END IF;
1956:
1957: end if;
1958:

Line 1978: raise FND_API.G_EXC_ERROR;

1974: x_set_id => x_set_id);
1975:
1976: if not (x_set_id > 0)
1977: then
1978: raise FND_API.G_EXC_ERROR;
1979: ELSE --Create_Set was successful
1980:
1981: INSERT INTO CS_KB_SET_CATEGORIES (
1982: SET_ID,

Line 2001: IF FND_API.To_Boolean( p_commit ) THEN

1997: end if;
1998:
1999: -- -- -- -- end of code -- -- --
2000:
2001: IF FND_API.To_Boolean( p_commit ) THEN
2002: COMMIT WORK;
2003: END IF;
2004:
2005: -- Standard call to get message count. if count=1, get message info.

Line 2011: WHEN FND_API.G_EXC_ERROR THEN

2007: p_count => x_msg_count,
2008: p_data => x_msg_data );
2009:
2010: EXCEPTION
2011: WHEN FND_API.G_EXC_ERROR THEN
2012: ROLLBACK TO Create_Set_And_Elements_PVT;
2013: x_return_status := FND_API.G_RET_STS_ERROR ;
2014: FND_MSG_PUB.Count_And_Get(
2015: p_encoded => FND_API.G_FALSE ,

Line 2013: x_return_status := FND_API.G_RET_STS_ERROR ;

2009:
2010: EXCEPTION
2011: WHEN FND_API.G_EXC_ERROR THEN
2012: ROLLBACK TO Create_Set_And_Elements_PVT;
2013: x_return_status := FND_API.G_RET_STS_ERROR ;
2014: FND_MSG_PUB.Count_And_Get(
2015: p_encoded => FND_API.G_FALSE ,
2016: p_count => x_msg_count,
2017: p_data => x_msg_data );

Line 2015: p_encoded => FND_API.G_FALSE ,

2011: WHEN FND_API.G_EXC_ERROR THEN
2012: ROLLBACK TO Create_Set_And_Elements_PVT;
2013: x_return_status := FND_API.G_RET_STS_ERROR ;
2014: FND_MSG_PUB.Count_And_Get(
2015: p_encoded => FND_API.G_FALSE ,
2016: p_count => x_msg_count,
2017: p_data => x_msg_data );
2018:
2019:

Line 2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2016: p_count => x_msg_count,
2017: p_data => x_msg_data );
2018:
2019:
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2021: ROLLBACK TO Create_Set_And_Elements_PVT;
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2023: FND_MSG_PUB.Count_And_Get(
2024: p_count => x_msg_count,

Line 2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2018:
2019:
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2021: ROLLBACK TO Create_Set_And_Elements_PVT;
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2023: FND_MSG_PUB.Count_And_Get(
2024: p_count => x_msg_count,
2025: p_data => x_msg_data);
2026: WHEN OTHERS THEN

Line 2028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2024: p_count => x_msg_count,
2025: p_data => x_msg_data);
2026: WHEN OTHERS THEN
2027: ROLLBACK TO Create_Set_And_Elements_PVT;
2028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2029: IF FND_MSG_PUB.Check_Msg_Level
2030: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2031: FND_MSG_PUB.Add_Exc_Msg(
2032: G_PKG_NAME,

Line 2046: p_init_msg_list in varchar2 := FND_API.G_FALSE,

2042: -- done
2043: --
2044: PROCEDURE Create_Set(
2045: p_api_version in number,
2046: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2047: p_commit in varchar2 := FND_API.G_FALSE,
2048: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2049: x_return_status OUT NOCOPY varchar2,
2050: x_msg_count OUT NOCOPY number,

Line 2047: p_commit in varchar2 := FND_API.G_FALSE,

2043: --
2044: PROCEDURE Create_Set(
2045: p_api_version in number,
2046: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2047: p_commit in varchar2 := FND_API.G_FALSE,
2048: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2049: x_return_status OUT NOCOPY varchar2,
2050: x_msg_count OUT NOCOPY number,
2051: x_msg_data OUT NOCOPY varchar2,

Line 2048: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

2044: PROCEDURE Create_Set(
2045: p_api_version in number,
2046: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2047: p_commit in varchar2 := FND_API.G_FALSE,
2048: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2049: x_return_status OUT NOCOPY varchar2,
2050: x_msg_count OUT NOCOPY number,
2051: x_msg_data OUT NOCOPY varchar2,
2052: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 2068: raise FND_API.G_EXC_ERROR;

2064: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2065: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2066: fnd_msg_pub.Add;
2067: end if;
2068: raise FND_API.G_EXC_ERROR;
2069: end if;
2070:
2071: Copy_SetDef_To_Obj(p_set_def_rec, l_set_def_obj);
2072:

Line 2101: p_init_msg_list in varchar2 := FND_API.G_FALSE,

2097: -- Create a set for the given element_ids.
2098: --
2099: PROCEDURE Create_Set(
2100: p_api_version in number,
2101: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2102: p_commit in varchar2 := FND_API.G_FALSE,
2103: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2104: x_return_status OUT NOCOPY varchar2,
2105: x_msg_count OUT NOCOPY number,

Line 2102: p_commit in varchar2 := FND_API.G_FALSE,

2098: --
2099: PROCEDURE Create_Set(
2100: p_api_version in number,
2101: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2102: p_commit in varchar2 := FND_API.G_FALSE,
2103: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2104: x_return_status OUT NOCOPY varchar2,
2105: x_msg_count OUT NOCOPY number,
2106: x_msg_data OUT NOCOPY varchar2,

Line 2103: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

2099: PROCEDURE Create_Set(
2100: p_api_version in number,
2101: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2102: p_commit in varchar2 := FND_API.G_FALSE,
2103: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2104: x_return_status OUT NOCOPY varchar2,
2105: x_msg_count OUT NOCOPY number,
2106: x_msg_data OUT NOCOPY varchar2,
2107: p_set_def_obj in cs_kb_set_def_obj_type,

Line 2162: if not FND_API.Compatible_API_Call(

2158: -- incr_ele_ele for all possible links
2159:
2160: savepoint Create_Set_PVT;
2161:
2162: if not FND_API.Compatible_API_Call(
2163: l_api_version,
2164: p_api_version,
2165: l_api_name,
2166: G_PKG_NAME) then

Line 2167: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2163: l_api_version,
2164: p_api_version,
2165: l_api_name,
2166: G_PKG_NAME) then
2167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2168: end if;
2169:
2170: if FND_API.to_Boolean(p_init_msg_list) then
2171: FND_MSG_PUB.initialize;

Line 2170: if FND_API.to_Boolean(p_init_msg_list) then

2166: G_PKG_NAME) then
2167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2168: end if;
2169:
2170: if FND_API.to_Boolean(p_init_msg_list) then
2171: FND_MSG_PUB.initialize;
2172: end if;
2173:
2174: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2174: x_return_status := FND_API.G_RET_STS_SUCCESS;

2170: if FND_API.to_Boolean(p_init_msg_list) then
2171: FND_MSG_PUB.initialize;
2172: end if;
2173:
2174: x_return_status := FND_API.G_RET_STS_SUCCESS;
2175: -- -- -- -- begin my code -- -- -- -- --
2176: -- Check params
2177: if(p_set_def_obj.set_type_id is null or
2178: p_set_def_obj.set_type_id <= 0 or

Line 2186: RAISE FND_API.G_EXC_ERROR; -- goto error_found;

2182: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2183: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2184: fnd_msg_pub.Add;
2185: end if;
2186: RAISE FND_API.G_EXC_ERROR; -- goto error_found;
2187: end if;
2188:
2189: if(p_ele_id_tbl is null or p_ele_id_tbl.COUNT <= 0) then
2190:

Line 2195: raise FND_API.G_EXC_ERROR;

2191: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2192: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2193: fnd_msg_pub.Add;
2194: end if;
2195: raise FND_API.G_EXC_ERROR;
2196: end if;
2197:
2198: --check types compatible
2199: i3 := p_ele_id_tbl.FIRST;

Line 2211: RAISE FND_API.G_EXC_ERROR;

2207: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
2208: fnd_msg_pub.Add;
2209:
2210: end if;
2211: RAISE FND_API.G_EXC_ERROR;
2212: end if;
2213: i3 := p_ele_id_tbl.NEXT(i3);
2214: end loop;
2215:

Line 2227: p_set_def_obj.set_type_id,l_ele_def_tbl)=FND_API.G_TRUE) then

2223: null, null, null, null);
2224: i3 := p_ele_id_tbl.NEXT(i3);
2225: end loop;
2226: if(Is_Required_Type_Missing(
2227: p_set_def_obj.set_type_id,l_ele_def_tbl)=FND_API.G_TRUE) then
2228: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2229: fnd_message.set_name('CS', 'CS_KB_C_MISS_REQ_TYPE');
2230: fnd_msg_pub.Add;
2231:

Line 2233: raise FND_API.G_EXC_ERROR;

2229: fnd_message.set_name('CS', 'CS_KB_C_MISS_REQ_TYPE');
2230: fnd_msg_pub.Add;
2231:
2232: end if;
2233: raise FND_API.G_EXC_ERROR;
2234: end if;
2235:
2236: OPEN Get_Min_Visibility;
2237: FETCH Get_Min_Visibility INTO l_visibility_id;

Line 2267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2263: x_msg_count => l_msg_count,
2264: p_visibility_id => l_visibility_id);
2265:
2266:
2267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2268: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2269: END IF;
2270:
2271: x_set_id := l_set_id;

Line 2268: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2264: p_visibility_id => l_visibility_id);
2265:
2266:
2267: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2268: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2269: END IF;
2270:
2271: x_set_id := l_set_id;
2272:

Line 2287: RAISE FND_API.G_EXC_ERROR;

2283: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2284: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2285: fnd_msg_pub.Add;
2286: end if;
2287: RAISE FND_API.G_EXC_ERROR;
2288: end if;
2289:
2290:
2291: if(p_ele_assoc_tbl is null or p_ele_assoc_tbl.count<1 or

Line 2322: IF FND_API.To_Boolean( p_commit ) THEN

2318: end if;
2319:
2320: -- -- -- -- end of code -- -- --
2321:
2322: IF FND_API.To_Boolean( p_commit ) THEN
2323: COMMIT WORK;
2324: END IF;
2325:
2326: -- Standard call to get message count. if count=1, get message info.

Line 2332: WHEN FND_API.G_EXC_ERROR THEN

2328: p_count => x_msg_count,
2329: p_data => x_msg_data );
2330:
2331: EXCEPTION
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: ROLLBACK TO Create_Set_PVT;
2334: x_set_id := -1;
2335: x_return_status := FND_API.G_RET_STS_ERROR ;
2336: FND_MSG_PUB.Count_And_Get(

Line 2335: x_return_status := FND_API.G_RET_STS_ERROR ;

2331: EXCEPTION
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: ROLLBACK TO Create_Set_PVT;
2334: x_set_id := -1;
2335: x_return_status := FND_API.G_RET_STS_ERROR ;
2336: FND_MSG_PUB.Count_And_Get(
2337: p_count => x_msg_count,
2338: p_data => x_msg_data );
2339:

Line 2340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2336: FND_MSG_PUB.Count_And_Get(
2337: p_count => x_msg_count,
2338: p_data => x_msg_data );
2339:
2340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2341: ROLLBACK TO Create_Set_PVT;
2342: x_set_id := -1;
2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2344: FND_MSG_PUB.Count_And_Get(

Line 2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2339:
2340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2341: ROLLBACK TO Create_Set_PVT;
2342: x_set_id := -1;
2343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2344: FND_MSG_PUB.Count_And_Get(
2345: p_count => x_msg_count,
2346: p_data => x_msg_data);
2347: WHEN OTHERS THEN

Line 2349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2345: p_count => x_msg_count,
2346: p_data => x_msg_data);
2347: WHEN OTHERS THEN
2348: ROLLBACK TO Create_Set_PVT;
2349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2350: IF FND_MSG_PUB.Check_Msg_Level
2351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2352: FND_MSG_PUB.Add_Exc_Msg(
2353: G_PKG_NAME,

Line 2368: p_init_msg_list in varchar2 := FND_API.G_FALSE,

2364: wrapper using records
2365: */
2366: PROCEDURE Create_Element(
2367: p_api_version in number,
2368: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2369: p_commit in varchar2 := FND_API.G_FALSE,
2370: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2371: x_return_status OUT NOCOPY varchar2,
2372: x_msg_count OUT NOCOPY number,

Line 2369: p_commit in varchar2 := FND_API.G_FALSE,

2365: */
2366: PROCEDURE Create_Element(
2367: p_api_version in number,
2368: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2369: p_commit in varchar2 := FND_API.G_FALSE,
2370: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2371: x_return_status OUT NOCOPY varchar2,
2372: x_msg_count OUT NOCOPY number,
2373: x_msg_data OUT NOCOPY varchar2,

Line 2370: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

2366: PROCEDURE Create_Element(
2367: p_api_version in number,
2368: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2369: p_commit in varchar2 := FND_API.G_FALSE,
2370: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2371: x_return_status OUT NOCOPY varchar2,
2372: x_msg_count OUT NOCOPY number,
2373: x_msg_data OUT NOCOPY varchar2,
2374: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

Line 2404: p_init_msg_list in varchar2 := FND_API.G_FALSE,

2400: -- Other params are not used for now.
2401: --
2402: PROCEDURE Create_Element(
2403: p_api_version in number,
2404: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2405: p_commit in varchar2 := FND_API.G_FALSE,
2406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2407: x_return_status OUT NOCOPY varchar2,
2408: x_msg_count OUT NOCOPY number,

Line 2405: p_commit in varchar2 := FND_API.G_FALSE,

2401: --
2402: PROCEDURE Create_Element(
2403: p_api_version in number,
2404: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2405: p_commit in varchar2 := FND_API.G_FALSE,
2406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2407: x_return_status OUT NOCOPY varchar2,
2408: x_msg_count OUT NOCOPY number,
2409: x_msg_data OUT NOCOPY varchar2,

Line 2406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

2402: PROCEDURE Create_Element(
2403: p_api_version in number,
2404: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2405: p_commit in varchar2 := FND_API.G_FALSE,
2406: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2407: x_return_status OUT NOCOPY varchar2,
2408: x_msg_count OUT NOCOPY number,
2409: x_msg_data OUT NOCOPY varchar2,
2410: p_ele_def_obj in cs_kb_ele_def_obj_type,

Line 2427: if not FND_API.Compatible_API_Call(

2423: begin
2424:
2425: savepoint Create_Element_PVT;
2426:
2427: if not FND_API.Compatible_API_Call(
2428: l_api_version,
2429: p_api_version,
2430: l_api_name,
2431: G_PKG_NAME) then

Line 2432: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2428: l_api_version,
2429: p_api_version,
2430: l_api_name,
2431: G_PKG_NAME) then
2432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2433: end if;
2434:
2435: if FND_API.to_Boolean(p_init_msg_list) then
2436: FND_MSG_PUB.initialize;

Line 2435: if FND_API.to_Boolean(p_init_msg_list) then

2431: G_PKG_NAME) then
2432: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2433: end if;
2434:
2435: if FND_API.to_Boolean(p_init_msg_list) then
2436: FND_MSG_PUB.initialize;
2437: end if;
2438:
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2439: x_return_status := FND_API.G_RET_STS_SUCCESS;

2435: if FND_API.to_Boolean(p_init_msg_list) then
2436: FND_MSG_PUB.initialize;
2437: end if;
2438:
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;
2440:
2441:
2442: -- -- -- -- begin my code -- -- -- -- --
2443: -- if type exists

Line 2455: raise FND_API.G_EXC_ERROR; -- goto error_found;

2451: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2452: fnd_msg_pub.Add;
2453: end if;
2454:
2455: raise FND_API.G_EXC_ERROR; -- goto error_found;
2456: end if;
2457:
2458: l_ele_id := CS_KB_ELEMENTS_AUDIT_PKG.Create_Element(
2459: p_element_type_id => p_ele_def_obj.element_type_id,

Line 2485: raise FND_API.G_EXC_ERROR;

2481: if not (l_ele_id>0) then
2482: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2483: fnd_msg_pub.Add;
2484: end if;
2485: raise FND_API.G_EXC_ERROR;
2486: end if;
2487:
2488: <>
2489: null;

Line 2492: IF FND_API.To_Boolean( p_commit ) THEN

2488: <>
2489: null;
2490: -- -- -- -- end of code -- -- --
2491:
2492: IF FND_API.To_Boolean( p_commit ) THEN
2493: COMMIT WORK;
2494: END IF;
2495:
2496: -- Standard call to get message count. if count=1, get message info.

Line 2502: WHEN FND_API.G_EXC_ERROR THEN

2498: p_count => x_msg_count,
2499: p_data => x_msg_data );
2500:
2501: EXCEPTION
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: ROLLBACK TO Create_Element_PVT;
2504: x_return_status := FND_API.G_RET_STS_ERROR ;
2505: FND_MSG_PUB.Count_And_Get(
2506: p_count => x_msg_count,

Line 2504: x_return_status := FND_API.G_RET_STS_ERROR ;

2500:
2501: EXCEPTION
2502: WHEN FND_API.G_EXC_ERROR THEN
2503: ROLLBACK TO Create_Element_PVT;
2504: x_return_status := FND_API.G_RET_STS_ERROR ;
2505: FND_MSG_PUB.Count_And_Get(
2506: p_count => x_msg_count,
2507: p_data => x_msg_data );
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2504: x_return_status := FND_API.G_RET_STS_ERROR ;
2505: FND_MSG_PUB.Count_And_Get(
2506: p_count => x_msg_count,
2507: p_data => x_msg_data );
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: ROLLBACK TO Create_Element_PVT;
2510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2511: FND_MSG_PUB.Count_And_Get(
2512: p_count => x_msg_count,

Line 2510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2506: p_count => x_msg_count,
2507: p_data => x_msg_data );
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: ROLLBACK TO Create_Element_PVT;
2510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2511: FND_MSG_PUB.Count_And_Get(
2512: p_count => x_msg_count,
2513: p_data => x_msg_data);
2514: WHEN OTHERS THEN

Line 2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2512: p_count => x_msg_count,
2513: p_data => x_msg_data);
2514: WHEN OTHERS THEN
2515: ROLLBACK TO Create_Element_PVT;
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2517: IF FND_MSG_PUB.Check_Msg_Level
2518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg(
2520: G_PKG_NAME,

Line 2536: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

2532: -- wt_code indicates which column in ele_ele to update. - just use set_count.
2533: --
2534: PROCEDURE Incr_Set_Useful(
2535: p_api_version in number,
2536: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
2537: p_commit in varchar2, -- := FND_API.G_FALSE,
2538: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
2539: x_return_status OUT NOCOPY varchar2,
2540: x_msg_count OUT NOCOPY number,

Line 2537: p_commit in varchar2, -- := FND_API.G_FALSE,

2533: --
2534: PROCEDURE Incr_Set_Useful(
2535: p_api_version in number,
2536: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
2537: p_commit in varchar2, -- := FND_API.G_FALSE,
2538: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
2539: x_return_status OUT NOCOPY varchar2,
2540: x_msg_count OUT NOCOPY number,
2541: x_msg_data OUT NOCOPY varchar2,

Line 2538: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

2534: PROCEDURE Incr_Set_Useful(
2535: p_api_version in number,
2536: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
2537: p_commit in varchar2, -- := FND_API.G_FALSE,
2538: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
2539: x_return_status OUT NOCOPY varchar2,
2540: x_msg_count OUT NOCOPY number,
2541: x_msg_data OUT NOCOPY varchar2,
2542: p_set_id in number,

Line 2557: if not FND_API.Compatible_API_Call(

2553: l_rowid varchar2(30);
2554: begin
2555: savepoint Incr_Set_Useful_PVT;
2556:
2557: if not FND_API.Compatible_API_Call(
2558: l_api_version,
2559: p_api_version,
2560: l_api_name,
2561: G_PKG_NAME) then

Line 2562: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2558: l_api_version,
2559: p_api_version,
2560: l_api_name,
2561: G_PKG_NAME) then
2562: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2563: end if;
2564:
2565: if FND_API.to_Boolean(p_init_msg_list) then
2566: FND_MSG_PUB.initialize;

Line 2565: if FND_API.to_Boolean(p_init_msg_list) then

2561: G_PKG_NAME) then
2562: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2563: end if;
2564:
2565: if FND_API.to_Boolean(p_init_msg_list) then
2566: FND_MSG_PUB.initialize;
2567: end if;
2568:
2569: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2569: x_return_status := FND_API.G_RET_STS_SUCCESS;

2565: if FND_API.to_Boolean(p_init_msg_list) then
2566: FND_MSG_PUB.initialize;
2567: end if;
2568:
2569: x_return_status := FND_API.G_RET_STS_SUCCESS;
2570:
2571: -- -- -- -- begin my code -- -- -- -- --
2572: -- Check params
2573: if(p_set_id is null) then

Line 2578: raise FND_API.G_EXC_ERROR; --goto error_found;

2574: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2575: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2576: fnd_msg_pub.Add;
2577: end if;
2578: raise FND_API.G_EXC_ERROR; --goto error_found;
2579: end if;
2580:
2581: -- incr history tables
2582: -- insert into histories table (who, when)

Line 2613: IF FND_API.To_Boolean( p_commit ) THEN

2609: l_created_by, l_login, p_used_type, p_session_id );
2610:
2611: -- -- -- -- end of code -- -- --
2612:
2613: IF FND_API.To_Boolean( p_commit ) THEN
2614: COMMIT WORK;
2615: END IF;
2616:
2617: -- Standard call to get message count. if count=1, get message info.

Line 2623: WHEN FND_API.G_EXC_ERROR THEN

2619: p_count => x_msg_count,
2620: p_data => x_msg_data );
2621:
2622: EXCEPTION
2623: WHEN FND_API.G_EXC_ERROR THEN
2624: ROLLBACK TO Incr_Set_Useful_PVT;
2625: x_return_status := FND_API.G_RET_STS_ERROR ;
2626: FND_MSG_PUB.Count_And_Get(
2627: p_count => x_msg_count,

Line 2625: x_return_status := FND_API.G_RET_STS_ERROR ;

2621:
2622: EXCEPTION
2623: WHEN FND_API.G_EXC_ERROR THEN
2624: ROLLBACK TO Incr_Set_Useful_PVT;
2625: x_return_status := FND_API.G_RET_STS_ERROR ;
2626: FND_MSG_PUB.Count_And_Get(
2627: p_count => x_msg_count,
2628: p_data => x_msg_data );
2629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2625: x_return_status := FND_API.G_RET_STS_ERROR ;
2626: FND_MSG_PUB.Count_And_Get(
2627: p_count => x_msg_count,
2628: p_data => x_msg_data );
2629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2630: ROLLBACK TO Incr_Set_Useful_PVT;
2631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2632: FND_MSG_PUB.Count_And_Get(
2633: p_count => x_msg_count,

Line 2631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2627: p_count => x_msg_count,
2628: p_data => x_msg_data );
2629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2630: ROLLBACK TO Incr_Set_Useful_PVT;
2631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2632: FND_MSG_PUB.Count_And_Get(
2633: p_count => x_msg_count,
2634: p_data => x_msg_data);
2635: WHEN OTHERS THEN

Line 2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2633: p_count => x_msg_count,
2634: p_data => x_msg_data);
2635: WHEN OTHERS THEN
2636: ROLLBACK TO Incr_Set_Useful_PVT;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2638: IF FND_MSG_PUB.Check_Msg_Level
2639: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg(
2641: G_PKG_NAME,

Line 3390: p_init_msg_list => FND_API.G_TRUE,

3386: -- Call Customer User Hook to customize the Intermedia query string
3387: CS_KNOWLEDGE_CUHK.Text_Query_Rewrite_Post
3388: (
3389: p_api_version => 1.0,
3390: p_init_msg_list => FND_API.G_TRUE,
3391: p_commit => FND_API.G_FALSE,
3392: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3393: x_return_status => l_return_status,
3394: x_msg_count => l_msg_count,

Line 3391: p_commit => FND_API.G_FALSE,

3387: CS_KNOWLEDGE_CUHK.Text_Query_Rewrite_Post
3388: (
3389: p_api_version => 1.0,
3390: p_init_msg_list => FND_API.G_TRUE,
3391: p_commit => FND_API.G_FALSE,
3392: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3393: x_return_status => l_return_status,
3394: x_msg_count => l_msg_count,
3395: x_msg_data => l_msg_data,

Line 3392: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3388: (
3389: p_api_version => 1.0,
3390: p_init_msg_list => FND_API.G_TRUE,
3391: p_commit => FND_API.G_FALSE,
3392: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3393: x_return_status => l_return_status,
3394: x_msg_count => l_msg_count,
3395: x_msg_data => l_msg_data,
3396: p_raw_query_text => p_raw_text,

Line 3401: if( l_return_status = FND_API.G_RET_STS_SUCCESS AND

3397: p_processed_text_query => l_query_str,
3398: p_search_option => p_search_option,
3399: x_custom_text_query => l_custom_query_str
3400: );
3401: if( l_return_status = FND_API.G_RET_STS_SUCCESS AND
3402: l_custom_query_str is not null )
3403: then
3404: l_query_str := l_custom_query_str;
3405: end if;

Line 3794: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

3790: -- NOTE: This api code has been duplicated to Find_Sets_Matching2 for bug 4304939
3791: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching2
3792: PROCEDURE Find_Sets_Matching (
3793: p_api_version in number,
3794: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
3795: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
3796: x_return_status OUT NOCOPY varchar2,
3797: x_msg_count OUT NOCOPY number,
3798: x_msg_data OUT NOCOPY varchar2,

Line 3795: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

3791: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching2
3792: PROCEDURE Find_Sets_Matching (
3793: p_api_version in number,
3794: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
3795: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
3796: x_return_status OUT NOCOPY varchar2,
3797: x_msg_count OUT NOCOPY number,
3798: x_msg_data OUT NOCOPY varchar2,
3799: p_pos_query_str in varchar2,

Line 3807: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,

3803: p_rows in number,
3804: p_start_score in number := null,
3805: p_start_id in number := null,
3806: p_start_row in number, -- := 1,
3807: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
3808: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
3809: x_total_rows OUT NOCOPY number,
3810: p_search_option in number := null
3811: )is

Line 3860: if not FND_API.Compatible_API_Call(

3856:
3857: begin
3858: savepoint Find_Sets_Matching_PVT;
3859:
3860: if not FND_API.Compatible_API_Call(
3861: l_api_version,
3862: p_api_version,
3863: l_api_name,
3864: G_PKG_NAME) then

Line 3865: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3861: l_api_version,
3862: p_api_version,
3863: l_api_name,
3864: G_PKG_NAME) then
3865: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3866: end if;
3867:
3868: if FND_API.to_Boolean(p_init_msg_list) then
3869: FND_MSG_PUB.initialize;

Line 3868: if FND_API.to_Boolean(p_init_msg_list) then

3864: G_PKG_NAME) then
3865: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3866: end if;
3867:
3868: if FND_API.to_Boolean(p_init_msg_list) then
3869: FND_MSG_PUB.initialize;
3870: end if;
3871:
3872: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3872: x_return_status := FND_API.G_RET_STS_SUCCESS;

3868: if FND_API.to_Boolean(p_init_msg_list) then
3869: FND_MSG_PUB.initialize;
3870: end if;
3871:
3872: x_return_status := FND_API.G_RET_STS_SUCCESS;
3873:
3874: -- -- -- -- begin my code -- -- -- -- --
3875:
3876: if(x_set_tbl is null) then

Line 3894: raise FND_API.G_EXC_ERROR; --goto error_found;

3890: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
3891: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
3892: fnd_msg_pub.Add;
3893: end if;
3894: raise FND_API.G_EXC_ERROR; --goto error_found;
3895: end if;
3896:
3897: l_sql_contains := Build_Solution_Text_Query
3898: ( p_raw_text => l_sql_contains,

Line 3921: if(p_get_total_flag = FND_API.G_TRUE) then

3917: end loop;
3918: close l_sets_csr;
3919:
3920: -- if get total rowcount
3921: if(p_get_total_flag = FND_API.G_TRUE) then
3922:
3923: OPEN l_sets_csr FOR
3924: l_sql_srows || l_sql_f1 ||l_sql_w1 || l_sql_w ||
3925: p_other_criteria

Line 3939: WHEN FND_API.G_EXC_ERROR THEN

3935: p_count => x_msg_count,
3936: p_data => x_msg_data );
3937:
3938: EXCEPTION
3939: WHEN FND_API.G_EXC_ERROR THEN
3940: ROLLBACK TO Find_Sets_Matching_PVT;
3941: x_return_status := FND_API.G_RET_STS_ERROR ;
3942: FND_MSG_PUB.Count_And_Get(
3943: p_count => x_msg_count,

Line 3941: x_return_status := FND_API.G_RET_STS_ERROR ;

3937:
3938: EXCEPTION
3939: WHEN FND_API.G_EXC_ERROR THEN
3940: ROLLBACK TO Find_Sets_Matching_PVT;
3941: x_return_status := FND_API.G_RET_STS_ERROR ;
3942: FND_MSG_PUB.Count_And_Get(
3943: p_count => x_msg_count,
3944: p_data => x_msg_data );
3945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3941: x_return_status := FND_API.G_RET_STS_ERROR ;
3942: FND_MSG_PUB.Count_And_Get(
3943: p_count => x_msg_count,
3944: p_data => x_msg_data );
3945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3946: ROLLBACK TO Find_Sets_Matching_PVT;
3947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3948: FND_MSG_PUB.Count_And_Get(
3949: p_count => x_msg_count,

Line 3947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3943: p_count => x_msg_count,
3944: p_data => x_msg_data );
3945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3946: ROLLBACK TO Find_Sets_Matching_PVT;
3947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3948: FND_MSG_PUB.Count_And_Get(
3949: p_count => x_msg_count,
3950: p_data => x_msg_data);
3951: WHEN OTHERS THEN

Line 3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3980: x_total_rows => x_total_rows,
3981: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
3982: else
3983: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3985: IF FND_MSG_PUB.Check_Msg_Level
3986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3987: FND_MSG_PUB.Add_Exc_Msg(
3988: G_PKG_NAME,

Line 4002: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,

3998: -- NOTE: This api code has been duplicated from Find_Sets_Matching for bug 4304939
3999: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching
4000: PROCEDURE Find_Sets_Matching2 (
4001: p_api_version in number,
4002: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
4003: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
4004: x_return_status OUT NOCOPY varchar2,
4005: x_msg_count OUT NOCOPY number,
4006: x_msg_data OUT NOCOPY varchar2,

Line 4003: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,

3999: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching
4000: PROCEDURE Find_Sets_Matching2 (
4001: p_api_version in number,
4002: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
4003: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
4004: x_return_status OUT NOCOPY varchar2,
4005: x_msg_count OUT NOCOPY number,
4006: x_msg_data OUT NOCOPY varchar2,
4007: p_pos_query_str in varchar2,

Line 4016: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,

4012: p_rows in number,
4013: p_start_score in number := null,
4014: p_start_id in number := null,
4015: p_start_row in number, -- := 1,
4016: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
4017: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
4018: x_total_rows OUT NOCOPY number,
4019: p_search_option in number := null
4020: )is

Line 4066: if not FND_API.Compatible_API_Call(

4062:
4063: begin
4064: savepoint Find_Sets_Matching_PVT;
4065:
4066: if not FND_API.Compatible_API_Call(
4067: l_api_version,
4068: p_api_version,
4069: l_api_name,
4070: G_PKG_NAME) then

Line 4071: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4067: l_api_version,
4068: p_api_version,
4069: l_api_name,
4070: G_PKG_NAME) then
4071: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4072: end if;
4073:
4074: if FND_API.to_Boolean(p_init_msg_list) then
4075: FND_MSG_PUB.initialize;

Line 4074: if FND_API.to_Boolean(p_init_msg_list) then

4070: G_PKG_NAME) then
4071: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4072: end if;
4073:
4074: if FND_API.to_Boolean(p_init_msg_list) then
4075: FND_MSG_PUB.initialize;
4076: end if;
4077:
4078: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4078: x_return_status := FND_API.G_RET_STS_SUCCESS;

4074: if FND_API.to_Boolean(p_init_msg_list) then
4075: FND_MSG_PUB.initialize;
4076: end if;
4077:
4078: x_return_status := FND_API.G_RET_STS_SUCCESS;
4079:
4080: -- -- -- -- begin my code -- -- -- -- --
4081:
4082: if(x_set_tbl is null) then

Line 4096: raise FND_API.G_EXC_ERROR; --goto error_found;

4092: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
4093: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
4094: fnd_msg_pub.Add;
4095: end if;
4096: raise FND_API.G_EXC_ERROR; --goto error_found;
4097: end if;
4098:
4099: l_sql_contains := Build_Solution_Text_Query
4100: ( p_raw_text => l_sql_contains,

Line 4122: if(p_get_total_flag = FND_API.G_TRUE) then

4118: end loop;
4119: close l_sets_csr;
4120:
4121: -- if get total rowcount
4122: if(p_get_total_flag = FND_API.G_TRUE) then
4123:
4124: OPEN l_sets_csr FOR
4125: l_sql_srows || l_sql_f1 ||l_sql_w1 || l_sql_w ||
4126: p_other_criteria

Line 4140: WHEN FND_API.G_EXC_ERROR THEN

4136: p_count => x_msg_count,
4137: p_data => x_msg_data );
4138:
4139: EXCEPTION
4140: WHEN FND_API.G_EXC_ERROR THEN
4141: ROLLBACK TO Find_Sets_Matching_PVT;
4142: x_return_status := FND_API.G_RET_STS_ERROR ;
4143: FND_MSG_PUB.Count_And_Get(
4144: p_count => x_msg_count,

Line 4142: x_return_status := FND_API.G_RET_STS_ERROR ;

4138:
4139: EXCEPTION
4140: WHEN FND_API.G_EXC_ERROR THEN
4141: ROLLBACK TO Find_Sets_Matching_PVT;
4142: x_return_status := FND_API.G_RET_STS_ERROR ;
4143: FND_MSG_PUB.Count_And_Get(
4144: p_count => x_msg_count,
4145: p_data => x_msg_data );
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4142: x_return_status := FND_API.G_RET_STS_ERROR ;
4143: FND_MSG_PUB.Count_And_Get(
4144: p_count => x_msg_count,
4145: p_data => x_msg_data );
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4147:
4148: ROLLBACK TO Find_Sets_Matching_PVT;
4149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4150: FND_MSG_PUB.Count_And_Get(

Line 4149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4145: p_data => x_msg_data );
4146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4147:
4148: ROLLBACK TO Find_Sets_Matching_PVT;
4149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4150: FND_MSG_PUB.Count_And_Get(
4151: p_count => x_msg_count,
4152: p_data => x_msg_data);
4153: WHEN OTHERS THEN

Line 4187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4183: x_total_rows => x_total_rows,
4184: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
4185: else
4186: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
4187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4188: IF FND_MSG_PUB.Check_Msg_Level
4189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4190: FND_MSG_PUB.Add_Exc_Msg(
4191: G_PKG_NAME,