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 171: return FND_API.G_TRUE;

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

Line 176: return FND_API.G_TRUE;

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

Line 183: return FND_API.G_FALSE;

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

Line 186: return FND_API.G_TRUE;

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

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

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

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

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

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

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

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

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

Line 583: if not FND_API.Compatible_API_Call(

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

Line 588: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 591: if FND_API.to_Boolean(p_init_msg_list) then

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

Line 595: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 608: raise FND_API.G_EXC_ERROR;

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

Line 649: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 658: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 668: WHEN FND_API.G_EXC_ERROR THEN

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

Line 670: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

Line 720: if not FND_API.Compatible_API_Call(

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

Line 725: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 728: if FND_API.to_Boolean(p_init_msg_list) then

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

Line 732: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 744: raise FND_API.G_EXC_ERROR;

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

Line 764: raise FND_API.G_EXC_ERROR;

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

Line 780: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 790: WHEN FND_API.G_EXC_ERROR THEN

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

Line 792: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

Line 841: if not FND_API.Compatible_API_Call(

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

Line 846: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 849: if FND_API.to_Boolean(p_init_msg_list) then

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

Line 853: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 865: raise FND_API.G_EXC_ERROR;

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

Line 883: raise FND_API.G_EXC_ERROR;

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

Line 899: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 909: WHEN FND_API.G_EXC_ERROR THEN

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

Line 911: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

Line 961: if not FND_API.Compatible_API_Call(

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

Line 966: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 969: if FND_API.to_Boolean(p_init_msg_list) then

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

Line 973: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 986: raise FND_API.G_EXC_ERROR;

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

Line 1006: raise FND_API.G_EXC_ERROR;

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

Line 1019: raise FND_API.G_EXC_ERROR;

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

Line 1030: raise FND_API.G_EXC_ERROR;

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

Line 1038: raise FND_API.G_EXC_ERROR;

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

Line 1051: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1062: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1072: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1074: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

Line 1123: if not FND_API.Compatible_API_Call(

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

Line 1128: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1131: if FND_API.to_Boolean(p_init_msg_list) then

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

Line 1135: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1147: raise FND_API.G_EXC_ERROR;

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

Line 1165: raise FND_API.G_EXC_ERROR;

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

Line 1181: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1191: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

1516: --
1517: PROCEDURE Create_Set_And_Elements(
1518: p_api_version in number,
1519: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1520: p_commit in varchar2 := FND_API.G_FALSE,
1521: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1522: x_return_status OUT NOCOPY varchar2,
1523: x_msg_count OUT NOCOPY number,
1524: x_msg_data OUT NOCOPY varchar2,

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

1517: PROCEDURE Create_Set_And_Elements(
1518: p_api_version in number,
1519: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1520: p_commit in varchar2 := FND_API.G_FALSE,
1521: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1522: x_return_status OUT NOCOPY varchar2,
1523: x_msg_count OUT NOCOPY number,
1524: x_msg_data OUT NOCOPY varchar2,
1525: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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

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

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

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

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

1552: PROCEDURE Create_Set_And_Elements(
1553: p_api_version in number,
1554: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1555: p_commit in varchar2 := FND_API.G_FALSE,
1556: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1557: x_return_status OUT NOCOPY varchar2,
1558: x_msg_count OUT NOCOPY number,
1559: x_msg_data OUT NOCOPY varchar2,
1560: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

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

1597: x_set_id => x_set_id,
1598: x_element_id_tbl => l_element_id_tbl);
1599:
1600:
1601: if (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1602: then
1603: raise FND_API.G_EXC_ERROR;
1604: end if;
1605:

Line 1603: raise FND_API.G_EXC_ERROR;

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

Line 1622: WHEN FND_API.G_EXC_ERROR THEN

1618: end loop;
1619: end if;
1620:
1621: exception
1622: WHEN FND_API.G_EXC_ERROR THEN
1623: x_return_status := FND_API.G_RET_STS_ERROR ;
1624: FND_MSG_PUB.Count_And_Get(
1625: p_encoded => FND_API.G_FALSE ,
1626: p_count => x_msg_count,

Line 1623: x_return_status := FND_API.G_RET_STS_ERROR ;

1619: end if;
1620:
1621: exception
1622: WHEN FND_API.G_EXC_ERROR THEN
1623: x_return_status := FND_API.G_RET_STS_ERROR ;
1624: FND_MSG_PUB.Count_And_Get(
1625: p_encoded => FND_API.G_FALSE ,
1626: p_count => x_msg_count,
1627: p_data => x_msg_data );

Line 1625: p_encoded => FND_API.G_FALSE ,

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

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

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

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

1635: --
1636: PROCEDURE Create_Set_And_Elements(
1637: p_api_version in number,
1638: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1639: p_commit in varchar2 := FND_API.G_FALSE,
1640: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1641: x_return_status OUT NOCOPY varchar2,
1642: x_msg_count OUT NOCOPY number,
1643: x_msg_data OUT NOCOPY varchar2,

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

1636: PROCEDURE Create_Set_And_Elements(
1637: p_api_version in number,
1638: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1639: p_commit in varchar2 := FND_API.G_FALSE,
1640: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1641: x_return_status OUT NOCOPY varchar2,
1642: x_msg_count OUT NOCOPY number,
1643: x_msg_data OUT NOCOPY varchar2,
1644: p_set_def_obj in cs_kb_set_def_obj_type,

Line 1676: if not FND_API.Compatible_API_Call(

1672: -- incr_ele_ele for all possible links
1673:
1674: savepoint Create_Set_And_Elements_PVT;
1675:
1676: if not FND_API.Compatible_API_Call(
1677: l_api_version,
1678: p_api_version,
1679: l_api_name,
1680: G_PKG_NAME) then

Line 1681: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1677: l_api_version,
1678: p_api_version,
1679: l_api_name,
1680: G_PKG_NAME) then
1681: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1682: end if;
1683:
1684: if FND_API.to_Boolean(p_init_msg_list) then
1685: FND_MSG_PUB.initialize;

Line 1684: if FND_API.to_Boolean(p_init_msg_list) then

1680: G_PKG_NAME) then
1681: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1682: end if;
1683:
1684: if FND_API.to_Boolean(p_init_msg_list) then
1685: FND_MSG_PUB.initialize;
1686: end if;
1687:
1688: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1688: x_return_status := FND_API.G_RET_STS_SUCCESS;

1684: if FND_API.to_Boolean(p_init_msg_list) then
1685: FND_MSG_PUB.initialize;
1686: end if;
1687:
1688: x_return_status := FND_API.G_RET_STS_SUCCESS;
1689:
1690:
1691: -- -- -- -- begin my code -- -- -- -- --
1692:

Line 1710: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1720: WHEN FND_API.G_EXC_ERROR THEN

1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:
1719: EXCEPTION
1720: WHEN FND_API.G_EXC_ERROR THEN
1721: ROLLBACK TO Create_Set_And_Elements_PVT;
1722: x_return_status := FND_API.G_RET_STS_ERROR ;
1723: FND_MSG_PUB.Count_And_Get(
1724: p_count => x_msg_count,

Line 1722: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

1750: --
1751: PROCEDURE Create_Set_And_Elements(
1752: p_api_version in number,
1753: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1754: p_commit in varchar2 := FND_API.G_FALSE,
1755: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1756: x_return_status OUT NOCOPY varchar2,
1757: x_msg_count OUT NOCOPY number,
1758: x_msg_data OUT NOCOPY varchar2,

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

1751: PROCEDURE Create_Set_And_Elements(
1752: p_api_version in number,
1753: p_init_msg_list in varchar2 := FND_API.G_FALSE,
1754: p_commit in varchar2 := FND_API.G_FALSE,
1755: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
1756: x_return_status OUT NOCOPY varchar2,
1757: x_msg_count OUT NOCOPY number,
1758: x_msg_data OUT NOCOPY varchar2,
1759: p_set_def_obj in cs_kb_set_def_obj_type,

Line 1818: if not FND_API.Compatible_API_Call(

1814:
1815:
1816: savepoint Create_Set_And_Elements_PVT;
1817:
1818: if not FND_API.Compatible_API_Call(
1819: l_api_version,
1820: p_api_version,
1821: l_api_name,
1822: G_PKG_NAME) then

Line 1823: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1819: l_api_version,
1820: p_api_version,
1821: l_api_name,
1822: G_PKG_NAME) then
1823: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1824: end if;
1825:
1826: if FND_API.to_Boolean(p_init_msg_list) then
1827: FND_MSG_PUB.initialize;

Line 1826: if FND_API.to_Boolean(p_init_msg_list) then

1822: G_PKG_NAME) then
1823: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1824: end if;
1825:
1826: if FND_API.to_Boolean(p_init_msg_list) then
1827: FND_MSG_PUB.initialize;
1828: end if;
1829:
1830: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1830: x_return_status := FND_API.G_RET_STS_SUCCESS;

1826: if FND_API.to_Boolean(p_init_msg_list) then
1827: FND_MSG_PUB.initialize;
1828: end if;
1829:
1830: x_return_status := FND_API.G_RET_STS_SUCCESS;
1831:
1832:
1833: -- -- -- -- begin my code -- -- -- -- --
1834:

Line 1847: raise FND_API.G_EXC_ERROR;

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

Line 1861: RAISE FND_API.G_EXC_ERROR;

1857: fnd_message.set_name('CS', 'CS_KB_INV_API_STATUS');
1858: fnd_msg_pub.Add;
1859:
1860: END IF;
1861: RAISE FND_API.G_EXC_ERROR;
1862:
1863: END IF;
1864:
1865: OPEN Get_Defaulted_Category;

Line 1883: RAISE FND_API.G_EXC_ERROR;

1879: TRANSLATE => true);
1880: fnd_msg_pub.Add;
1881:
1882: END IF;
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;
1885:
1886: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1887:

Line 1892: raise FND_API.G_EXC_ERROR;

1888: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1889: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1890: fnd_msg_pub.Add;
1891: end if;
1892: raise FND_API.G_EXC_ERROR;
1893:
1894: end if;
1895:
1896: CS_Knowledge_PVT.Get_Who(l_date, l_created_by, l_login);

Line 1933: raise FND_API.G_EXC_ERROR;

1929: p_attribute15 => p_ele_def_tbl(i1).dff_obj.attribute15);
1930:
1931: if not (l_ele_id > 0)
1932: then
1933: raise FND_API.G_EXC_ERROR;
1934: else
1935: x_element_id_tbl(j) := l_ele_id;
1936: end if;
1937:

Line 1950: RAISE FND_API.G_EXC_ERROR;

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

Line 1974: raise FND_API.G_EXC_ERROR;

1970: x_set_id => x_set_id);
1971:
1972: if not (x_set_id > 0)
1973: then
1974: raise FND_API.G_EXC_ERROR;
1975: ELSE --Create_Set was successful
1976:
1977: INSERT INTO CS_KB_SET_CATEGORIES (
1978: SET_ID,

Line 1997: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 2007: WHEN FND_API.G_EXC_ERROR THEN

2003: p_count => x_msg_count,
2004: p_data => x_msg_data );
2005:
2006: EXCEPTION
2007: WHEN FND_API.G_EXC_ERROR THEN
2008: ROLLBACK TO Create_Set_And_Elements_PVT;
2009: x_return_status := FND_API.G_RET_STS_ERROR ;
2010: FND_MSG_PUB.Count_And_Get(
2011: p_encoded => FND_API.G_FALSE ,

Line 2009: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2011: p_encoded => FND_API.G_FALSE ,

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

Line 2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2012: p_count => x_msg_count,
2013: p_data => x_msg_data );
2014:
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: ROLLBACK TO Create_Set_And_Elements_PVT;
2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2019: FND_MSG_PUB.Count_And_Get(
2020: p_count => x_msg_count,

Line 2018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

2038: -- done
2039: --
2040: PROCEDURE Create_Set(
2041: p_api_version in number,
2042: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2043: p_commit in varchar2 := FND_API.G_FALSE,
2044: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2045: x_return_status OUT NOCOPY varchar2,
2046: x_msg_count OUT NOCOPY number,

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

2039: --
2040: PROCEDURE Create_Set(
2041: p_api_version in number,
2042: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2043: p_commit in varchar2 := FND_API.G_FALSE,
2044: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2045: x_return_status OUT NOCOPY varchar2,
2046: x_msg_count OUT NOCOPY number,
2047: x_msg_data OUT NOCOPY varchar2,

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

2040: PROCEDURE Create_Set(
2041: p_api_version in number,
2042: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2043: p_commit in varchar2 := FND_API.G_FALSE,
2044: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2045: x_return_status OUT NOCOPY varchar2,
2046: x_msg_count OUT NOCOPY number,
2047: x_msg_data OUT NOCOPY varchar2,
2048: p_set_def_rec in CS_Knowledge_PUB.set_def_rec_type,

Line 2064: raise FND_API.G_EXC_ERROR;

2060: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2061: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2062: fnd_msg_pub.Add;
2063: end if;
2064: raise FND_API.G_EXC_ERROR;
2065: end if;
2066:
2067: Copy_SetDef_To_Obj(p_set_def_rec, l_set_def_obj);
2068:

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

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

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

2094: --
2095: PROCEDURE Create_Set(
2096: p_api_version in number,
2097: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2098: p_commit in varchar2 := FND_API.G_FALSE,
2099: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2100: x_return_status OUT NOCOPY varchar2,
2101: x_msg_count OUT NOCOPY number,
2102: x_msg_data OUT NOCOPY varchar2,

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

2095: PROCEDURE Create_Set(
2096: p_api_version in number,
2097: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2098: p_commit in varchar2 := FND_API.G_FALSE,
2099: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2100: x_return_status OUT NOCOPY varchar2,
2101: x_msg_count OUT NOCOPY number,
2102: x_msg_data OUT NOCOPY varchar2,
2103: p_set_def_obj in cs_kb_set_def_obj_type,

Line 2158: if not FND_API.Compatible_API_Call(

2154: -- incr_ele_ele for all possible links
2155:
2156: savepoint Create_Set_PVT;
2157:
2158: if not FND_API.Compatible_API_Call(
2159: l_api_version,
2160: p_api_version,
2161: l_api_name,
2162: G_PKG_NAME) then

Line 2163: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2159: l_api_version,
2160: p_api_version,
2161: l_api_name,
2162: G_PKG_NAME) then
2163: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2164: end if;
2165:
2166: if FND_API.to_Boolean(p_init_msg_list) then
2167: FND_MSG_PUB.initialize;

Line 2166: if FND_API.to_Boolean(p_init_msg_list) then

2162: G_PKG_NAME) then
2163: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2164: end if;
2165:
2166: if FND_API.to_Boolean(p_init_msg_list) then
2167: FND_MSG_PUB.initialize;
2168: end if;
2169:
2170: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2170: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 2191: raise FND_API.G_EXC_ERROR;

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

Line 2207: RAISE FND_API.G_EXC_ERROR;

2203: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
2204: fnd_msg_pub.Add;
2205:
2206: end if;
2207: RAISE FND_API.G_EXC_ERROR;
2208: end if;
2209: i3 := p_ele_id_tbl.NEXT(i3);
2210: end loop;
2211:

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

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

Line 2229: raise FND_API.G_EXC_ERROR;

2225: fnd_message.set_name('CS', 'CS_KB_C_MISS_REQ_TYPE');
2226: fnd_msg_pub.Add;
2227:
2228: end if;
2229: raise FND_API.G_EXC_ERROR;
2230: end if;
2231:
2232: OPEN Get_Min_Visibility;
2233: FETCH Get_Min_Visibility INTO l_visibility_id;

Line 2263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2259: x_msg_count => l_msg_count,
2260: p_visibility_id => l_visibility_id);
2261:
2262:
2263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2265: END IF;
2266:
2267: x_set_id := l_set_id;

Line 2264: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2260: p_visibility_id => l_visibility_id);
2261:
2262:
2263: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2264: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2265: END IF;
2266:
2267: x_set_id := l_set_id;
2268:

Line 2283: RAISE FND_API.G_EXC_ERROR;

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

Line 2318: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 2328: WHEN FND_API.G_EXC_ERROR THEN

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

Line 2331: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

2360: wrapper using records
2361: */
2362: PROCEDURE Create_Element(
2363: p_api_version in number,
2364: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2365: p_commit in varchar2 := FND_API.G_FALSE,
2366: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2367: x_return_status OUT NOCOPY varchar2,
2368: x_msg_count OUT NOCOPY number,

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

2361: */
2362: PROCEDURE Create_Element(
2363: p_api_version in number,
2364: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2365: p_commit in varchar2 := FND_API.G_FALSE,
2366: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2367: x_return_status OUT NOCOPY varchar2,
2368: x_msg_count OUT NOCOPY number,
2369: x_msg_data OUT NOCOPY varchar2,

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

2362: PROCEDURE Create_Element(
2363: p_api_version in number,
2364: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2365: p_commit in varchar2 := FND_API.G_FALSE,
2366: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2367: x_return_status OUT NOCOPY varchar2,
2368: x_msg_count OUT NOCOPY number,
2369: x_msg_data OUT NOCOPY varchar2,
2370: p_ele_def_rec in CS_Knowledge_PUB.ele_def_rec_type,

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

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

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

2397: --
2398: PROCEDURE Create_Element(
2399: p_api_version in number,
2400: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2401: p_commit in varchar2 := FND_API.G_FALSE,
2402: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2403: x_return_status OUT NOCOPY varchar2,
2404: x_msg_count OUT NOCOPY number,
2405: x_msg_data OUT NOCOPY varchar2,

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

2398: PROCEDURE Create_Element(
2399: p_api_version in number,
2400: p_init_msg_list in varchar2 := FND_API.G_FALSE,
2401: p_commit in varchar2 := FND_API.G_FALSE,
2402: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
2403: x_return_status OUT NOCOPY varchar2,
2404: x_msg_count OUT NOCOPY number,
2405: x_msg_data OUT NOCOPY varchar2,
2406: p_ele_def_obj in cs_kb_ele_def_obj_type,

Line 2423: if not FND_API.Compatible_API_Call(

2419: begin
2420:
2421: savepoint Create_Element_PVT;
2422:
2423: if not FND_API.Compatible_API_Call(
2424: l_api_version,
2425: p_api_version,
2426: l_api_name,
2427: G_PKG_NAME) then

Line 2428: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2424: l_api_version,
2425: p_api_version,
2426: l_api_name,
2427: G_PKG_NAME) then
2428: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2429: end if;
2430:
2431: if FND_API.to_Boolean(p_init_msg_list) then
2432: FND_MSG_PUB.initialize;

Line 2431: if FND_API.to_Boolean(p_init_msg_list) then

2427: G_PKG_NAME) then
2428: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2429: end if;
2430:
2431: if FND_API.to_Boolean(p_init_msg_list) then
2432: FND_MSG_PUB.initialize;
2433: end if;
2434:
2435: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2435: x_return_status := FND_API.G_RET_STS_SUCCESS;

2431: if FND_API.to_Boolean(p_init_msg_list) then
2432: FND_MSG_PUB.initialize;
2433: end if;
2434:
2435: x_return_status := FND_API.G_RET_STS_SUCCESS;
2436:
2437:
2438: -- -- -- -- begin my code -- -- -- -- --
2439: -- if type exists

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

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

Line 2481: raise FND_API.G_EXC_ERROR;

2477: if not (l_ele_id>0) then
2478: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2479: fnd_msg_pub.Add;
2480: end if;
2481: raise FND_API.G_EXC_ERROR;
2482: end if;
2483:
2484: <>
2485: null;

Line 2488: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 2498: WHEN FND_API.G_EXC_ERROR THEN

2494: p_count => x_msg_count,
2495: p_data => x_msg_data );
2496:
2497: EXCEPTION
2498: WHEN FND_API.G_EXC_ERROR THEN
2499: ROLLBACK TO Create_Element_PVT;
2500: x_return_status := FND_API.G_RET_STS_ERROR ;
2501: FND_MSG_PUB.Count_And_Get(
2502: p_count => x_msg_count,

Line 2500: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

2529: --
2530: PROCEDURE Incr_Set_Useful(
2531: p_api_version in number,
2532: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
2533: p_commit in varchar2, -- := FND_API.G_FALSE,
2534: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
2535: x_return_status OUT NOCOPY varchar2,
2536: x_msg_count OUT NOCOPY number,
2537: x_msg_data OUT NOCOPY varchar2,

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

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

Line 2553: if not FND_API.Compatible_API_Call(

2549: l_rowid varchar2(30);
2550: begin
2551: savepoint Incr_Set_Useful_PVT;
2552:
2553: if not FND_API.Compatible_API_Call(
2554: l_api_version,
2555: p_api_version,
2556: l_api_name,
2557: G_PKG_NAME) then

Line 2558: raise FND_API.G_EXC_UNEXPECTED_ERROR;

2554: l_api_version,
2555: p_api_version,
2556: l_api_name,
2557: G_PKG_NAME) then
2558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2559: end if;
2560:
2561: if FND_API.to_Boolean(p_init_msg_list) then
2562: FND_MSG_PUB.initialize;

Line 2561: if FND_API.to_Boolean(p_init_msg_list) then

2557: G_PKG_NAME) then
2558: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2559: end if;
2560:
2561: if FND_API.to_Boolean(p_init_msg_list) then
2562: FND_MSG_PUB.initialize;
2563: end if;
2564:
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2565: x_return_status := FND_API.G_RET_STS_SUCCESS;

2561: if FND_API.to_Boolean(p_init_msg_list) then
2562: FND_MSG_PUB.initialize;
2563: end if;
2564:
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: -- -- -- -- begin my code -- -- -- -- --
2568: -- Check params
2569: if(p_set_id is null) then

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

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

Line 2609: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 2619: WHEN FND_API.G_EXC_ERROR THEN

2615: p_count => x_msg_count,
2616: p_data => x_msg_data );
2617:
2618: EXCEPTION
2619: WHEN FND_API.G_EXC_ERROR THEN
2620: ROLLBACK TO Incr_Set_Useful_PVT;
2621: x_return_status := FND_API.G_RET_STS_ERROR ;
2622: FND_MSG_PUB.Count_And_Get(
2623: p_count => x_msg_count,

Line 2621: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 2625: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 2627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 2633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 3365: p_init_msg_list => FND_API.G_TRUE,

3361: -- Call Customer User Hook to customize the Intermedia query string
3362: CS_KNOWLEDGE_CUHK.Text_Query_Rewrite_Post
3363: (
3364: p_api_version => 1.0,
3365: p_init_msg_list => FND_API.G_TRUE,
3366: p_commit => FND_API.G_FALSE,
3367: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3368: x_return_status => l_return_status,
3369: x_msg_count => l_msg_count,

Line 3366: p_commit => FND_API.G_FALSE,

3362: CS_KNOWLEDGE_CUHK.Text_Query_Rewrite_Post
3363: (
3364: p_api_version => 1.0,
3365: p_init_msg_list => FND_API.G_TRUE,
3366: p_commit => FND_API.G_FALSE,
3367: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3368: x_return_status => l_return_status,
3369: x_msg_count => l_msg_count,
3370: x_msg_data => l_msg_data,

Line 3367: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3363: (
3364: p_api_version => 1.0,
3365: p_init_msg_list => FND_API.G_TRUE,
3366: p_commit => FND_API.G_FALSE,
3367: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3368: x_return_status => l_return_status,
3369: x_msg_count => l_msg_count,
3370: x_msg_data => l_msg_data,
3371: p_raw_query_text => p_raw_text,

Line 3376: if( l_return_status = FND_API.G_RET_STS_SUCCESS AND

3372: p_processed_text_query => l_query_str,
3373: p_search_option => p_search_option,
3374: x_custom_text_query => l_custom_query_str
3375: );
3376: if( l_return_status = FND_API.G_RET_STS_SUCCESS AND
3377: l_custom_query_str is not null )
3378: then
3379: l_query_str := l_custom_query_str;
3380: end if;

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

3765: -- NOTE: This api code has been duplicated to Find_Sets_Matching2 for bug 4304939
3766: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching2
3767: PROCEDURE Find_Sets_Matching (
3768: p_api_version in number,
3769: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
3770: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
3771: x_return_status OUT NOCOPY varchar2,
3772: x_msg_count OUT NOCOPY number,
3773: x_msg_data OUT NOCOPY varchar2,

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

3766: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching2
3767: PROCEDURE Find_Sets_Matching (
3768: p_api_version in number,
3769: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
3770: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
3771: x_return_status OUT NOCOPY varchar2,
3772: x_msg_count OUT NOCOPY number,
3773: x_msg_data OUT NOCOPY varchar2,
3774: p_pos_query_str in varchar2,

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

3778: p_rows in number,
3779: p_start_score in number := null,
3780: p_start_id in number := null,
3781: p_start_row in number, -- := 1,
3782: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
3783: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
3784: x_total_rows OUT NOCOPY number,
3785: p_search_option in number := null
3786: )is

Line 3835: if not FND_API.Compatible_API_Call(

3831:
3832: begin
3833: savepoint Find_Sets_Matching_PVT;
3834:
3835: if not FND_API.Compatible_API_Call(
3836: l_api_version,
3837: p_api_version,
3838: l_api_name,
3839: G_PKG_NAME) then

Line 3840: raise FND_API.G_EXC_UNEXPECTED_ERROR;

3836: l_api_version,
3837: p_api_version,
3838: l_api_name,
3839: G_PKG_NAME) then
3840: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3841: end if;
3842:
3843: if FND_API.to_Boolean(p_init_msg_list) then
3844: FND_MSG_PUB.initialize;

Line 3843: if FND_API.to_Boolean(p_init_msg_list) then

3839: G_PKG_NAME) then
3840: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3841: end if;
3842:
3843: if FND_API.to_Boolean(p_init_msg_list) then
3844: FND_MSG_PUB.initialize;
3845: end if;
3846:
3847: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3847: x_return_status := FND_API.G_RET_STS_SUCCESS;

3843: if FND_API.to_Boolean(p_init_msg_list) then
3844: FND_MSG_PUB.initialize;
3845: end if;
3846:
3847: x_return_status := FND_API.G_RET_STS_SUCCESS;
3848:
3849: -- -- -- -- begin my code -- -- -- -- --
3850:
3851: if(x_set_tbl is null) then

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

3865: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
3866: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
3867: fnd_msg_pub.Add;
3868: end if;
3869: raise FND_API.G_EXC_ERROR; --goto error_found;
3870: end if;
3871:
3872: l_sql_contains := Build_Solution_Text_Query
3873: ( p_raw_text => l_sql_contains,

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

3892: end loop;
3893: close l_sets_csr;
3894:
3895: -- if get total rowcount
3896: if(p_get_total_flag = FND_API.G_TRUE) then
3897:
3898: OPEN l_sets_csr FOR
3899: l_sql_srows || l_sql_f1 ||l_sql_w1 || l_sql_w ||
3900: p_other_criteria

Line 3914: WHEN FND_API.G_EXC_ERROR THEN

3910: p_count => x_msg_count,
3911: p_data => x_msg_data );
3912:
3913: EXCEPTION
3914: WHEN FND_API.G_EXC_ERROR THEN
3915: ROLLBACK TO Find_Sets_Matching_PVT;
3916: x_return_status := FND_API.G_RET_STS_ERROR ;
3917: FND_MSG_PUB.Count_And_Get(
3918: p_count => x_msg_count,

Line 3916: x_return_status := FND_API.G_RET_STS_ERROR ;

3912:
3913: EXCEPTION
3914: WHEN FND_API.G_EXC_ERROR THEN
3915: ROLLBACK TO Find_Sets_Matching_PVT;
3916: x_return_status := FND_API.G_RET_STS_ERROR ;
3917: FND_MSG_PUB.Count_And_Get(
3918: p_count => x_msg_count,
3919: p_data => x_msg_data );
3920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3916: x_return_status := FND_API.G_RET_STS_ERROR ;
3917: FND_MSG_PUB.Count_And_Get(
3918: p_count => x_msg_count,
3919: p_data => x_msg_data );
3920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3921: ROLLBACK TO Find_Sets_Matching_PVT;
3922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3923: FND_MSG_PUB.Count_And_Get(
3924: p_count => x_msg_count,

Line 3922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3918: p_count => x_msg_count,
3919: p_data => x_msg_data );
3920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3921: ROLLBACK TO Find_Sets_Matching_PVT;
3922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3923: FND_MSG_PUB.Count_And_Get(
3924: p_count => x_msg_count,
3925: p_data => x_msg_data);
3926: WHEN OTHERS THEN

Line 3959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3955: x_total_rows => x_total_rows,
3956: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
3957: else
3958: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
3959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3960: IF FND_MSG_PUB.Check_Msg_Level
3961: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3962: FND_MSG_PUB.Add_Exc_Msg(
3963: G_PKG_NAME,

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

3973: -- NOTE: This api code has been duplicated from Find_Sets_Matching for bug 4304939
3974: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching
3975: PROCEDURE Find_Sets_Matching2 (
3976: p_api_version in number,
3977: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
3978: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
3979: x_return_status OUT NOCOPY varchar2,
3980: x_msg_count OUT NOCOPY number,
3981: x_msg_data OUT NOCOPY varchar2,

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

3974: -- Any changes made to this api should also be replicated to the new Find_Sets_Matching
3975: PROCEDURE Find_Sets_Matching2 (
3976: p_api_version in number,
3977: p_init_msg_list in varchar2, -- := FND_API.G_FALSE,
3978: p_validation_level in number, -- := FND_API.G_VALID_LEVEL_FULL,
3979: x_return_status OUT NOCOPY varchar2,
3980: x_msg_count OUT NOCOPY number,
3981: x_msg_data OUT NOCOPY varchar2,
3982: p_pos_query_str in varchar2,

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

3987: p_rows in number,
3988: p_start_score in number := null,
3989: p_start_id in number := null,
3990: p_start_row in number, -- := 1,
3991: p_get_total_flag in varchar2, -- := FND_API.G_FALSE,
3992: x_set_tbl in OUT NOCOPY CS_Knowledge_PUB.set_res_tbl_type,
3993: x_total_rows OUT NOCOPY number,
3994: p_search_option in number := null
3995: )is

Line 4041: if not FND_API.Compatible_API_Call(

4037:
4038: begin
4039: savepoint Find_Sets_Matching_PVT;
4040:
4041: if not FND_API.Compatible_API_Call(
4042: l_api_version,
4043: p_api_version,
4044: l_api_name,
4045: G_PKG_NAME) then

Line 4046: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4042: l_api_version,
4043: p_api_version,
4044: l_api_name,
4045: G_PKG_NAME) then
4046: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4047: end if;
4048:
4049: if FND_API.to_Boolean(p_init_msg_list) then
4050: FND_MSG_PUB.initialize;

Line 4049: if FND_API.to_Boolean(p_init_msg_list) then

4045: G_PKG_NAME) then
4046: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4047: end if;
4048:
4049: if FND_API.to_Boolean(p_init_msg_list) then
4050: FND_MSG_PUB.initialize;
4051: end if;
4052:
4053: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4053: x_return_status := FND_API.G_RET_STS_SUCCESS;

4049: if FND_API.to_Boolean(p_init_msg_list) then
4050: FND_MSG_PUB.initialize;
4051: end if;
4052:
4053: x_return_status := FND_API.G_RET_STS_SUCCESS;
4054:
4055: -- -- -- -- begin my code -- -- -- -- --
4056:
4057: if(x_set_tbl is null) then

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

4067: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
4068: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
4069: fnd_msg_pub.Add;
4070: end if;
4071: raise FND_API.G_EXC_ERROR; --goto error_found;
4072: end if;
4073:
4074: l_sql_contains := Build_Solution_Text_Query
4075: ( p_raw_text => l_sql_contains,

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

4093: end loop;
4094: close l_sets_csr;
4095:
4096: -- if get total rowcount
4097: if(p_get_total_flag = FND_API.G_TRUE) then
4098:
4099: OPEN l_sets_csr FOR
4100: l_sql_srows || l_sql_f1 ||l_sql_w1 || l_sql_w ||
4101: p_other_criteria

Line 4115: WHEN FND_API.G_EXC_ERROR THEN

4111: p_count => x_msg_count,
4112: p_data => x_msg_data );
4113:
4114: EXCEPTION
4115: WHEN FND_API.G_EXC_ERROR THEN
4116: ROLLBACK TO Find_Sets_Matching_PVT;
4117: x_return_status := FND_API.G_RET_STS_ERROR ;
4118: FND_MSG_PUB.Count_And_Get(
4119: p_count => x_msg_count,

Line 4117: x_return_status := FND_API.G_RET_STS_ERROR ;

4113:
4114: EXCEPTION
4115: WHEN FND_API.G_EXC_ERROR THEN
4116: ROLLBACK TO Find_Sets_Matching_PVT;
4117: x_return_status := FND_API.G_RET_STS_ERROR ;
4118: FND_MSG_PUB.Count_And_Get(
4119: p_count => x_msg_count,
4120: p_data => x_msg_data );
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4117: x_return_status := FND_API.G_RET_STS_ERROR ;
4118: FND_MSG_PUB.Count_And_Get(
4119: p_count => x_msg_count,
4120: p_data => x_msg_data );
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4122:
4123: ROLLBACK TO Find_Sets_Matching_PVT;
4124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4125: FND_MSG_PUB.Count_And_Get(

Line 4124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4120: p_data => x_msg_data );
4121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4122:
4123: ROLLBACK TO Find_Sets_Matching_PVT;
4124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4125: FND_MSG_PUB.Count_And_Get(
4126: p_count => x_msg_count,
4127: p_data => x_msg_data);
4128: WHEN OTHERS THEN

Line 4162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4158: x_total_rows => x_total_rows,
4159: p_search_option => CS_KNOWLEDGE_PUB.MATCH_ANY);
4160: else
4161: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
4162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4163: IF FND_MSG_PUB.Check_Msg_Level
4164: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4165: FND_MSG_PUB.Add_Exc_Msg(
4166: G_PKG_NAME,