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_MSG_PUB

Line 592: FND_MSG_PUB.initialize;

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;
596: -- -- -- -- begin my code -- -- -- -- --

Line 604: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

600: p_object_code is null or
601: p_other_id_tbl is null or p_other_code_tbl is null or
602: p_other_id_tbl.COUNT <> p_other_code_tbl.COUNT) then
603:
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;

Line 606: fnd_msg_pub.Add;

602: p_other_id_tbl.COUNT <> p_other_code_tbl.COUNT) then
603:
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:

Line 663: FND_MSG_PUB.Count_And_Get(

659: COMMIT WORK;
660: END IF;
661:
662: -- Standard call to get message count. if count=1, get message info.
663: FND_MSG_PUB.Count_And_Get(
664: p_count => x_msg_count,
665: p_data => x_msg_data );
666:
667: EXCEPTION

Line 671: FND_MSG_PUB.Count_And_Get(

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
675: ROLLBACK TO Add_External_Links_PVT;

Line 677: FND_MSG_PUB.Count_And_Get(

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
681: ROLLBACK TO Add_External_Links_PVT;

Line 683: IF FND_MSG_PUB.Check_Msg_Level

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,
687: l_api_name);

Line 684: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
687: l_api_name);
688: END IF;

Line 685: FND_MSG_PUB.Add_Exc_Msg(

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,
687: l_api_name);
688: END IF;
689: FND_MSG_PUB.Count_And_Get(

Line 689: FND_MSG_PUB.Count_And_Get(

685: FND_MSG_PUB.Add_Exc_Msg(
686: G_PKG_NAME,
687: l_api_name);
688: END IF;
689: FND_MSG_PUB.Count_And_Get(
690: p_count => x_msg_count,
691: p_data => x_msg_data);
692:
693: end Add_External_Links;

Line 729: FND_MSG_PUB.initialize;

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;
733: -- -- -- -- begin my code -- -- -- -- --

Line 740: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

736: if(p_link_id_tbl is null or p_ele_type_id_tbl is null or
737: p_link_id_tbl.COUNT =0 or p_ele_type_id_tbl.COUNT =0 or
738: p_ele_type_id_tbl.COUNT < p_link_id_tbl.COUNT) then
739:
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;

Line 742: fnd_msg_pub.Add;

738: p_ele_type_id_tbl.COUNT < p_link_id_tbl.COUNT) then
739:
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;

Line 759: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

755: from cs_kb_element_types_b
756: where element_type_id = l_ele_type_id;
757: if(l_count<1) then
758:
759: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
760: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
761: fnd_msg_pub.Add;
762: end if;
763:

Line 761: fnd_msg_pub.Add;

757: if(l_count<1) then
758:
759: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
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;

Line 785: FND_MSG_PUB.Count_And_Get(

781: COMMIT WORK;
782: END IF;
783:
784: -- Standard call to get message count. if count=1, get message info.
785: FND_MSG_PUB.Count_And_Get(
786: p_count => x_msg_count,
787: p_data => x_msg_data );
788:
789: EXCEPTION

Line 793: FND_MSG_PUB.Count_And_Get(

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
797: ROLLBACK TO Change_Ele_Type_Links_PVT;

Line 799: FND_MSG_PUB.Count_And_Get(

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
803: ROLLBACK TO Change_Ele_Type_Links_PVT;

Line 805: IF FND_MSG_PUB.Check_Msg_Level

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,
809: l_api_name);

Line 806: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
809: l_api_name);
810: END IF;

Line 807: FND_MSG_PUB.Add_Exc_Msg(

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,
809: l_api_name);
810: END IF;
811: FND_MSG_PUB.Count_And_Get(

Line 811: FND_MSG_PUB.Count_And_Get(

807: FND_MSG_PUB.Add_Exc_Msg(
808: G_PKG_NAME,
809: l_api_name);
810: END IF;
811: FND_MSG_PUB.Count_And_Get(
812: p_count => x_msg_count,
813: p_data => x_msg_data);
814:
815: end Change_Ele_Type_Links;

Line 850: FND_MSG_PUB.initialize;

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;
854: -- -- -- -- begin my code -- -- -- -- --

Line 861: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

857: if(p_link_id_tbl is null or p_set_id_tbl is null or
858: p_link_id_tbl.COUNT =0 or p_set_id_tbl.COUNT =0 or
859: p_set_id_tbl.COUNT < p_link_id_tbl.COUNT) then
860:
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;

Line 863: fnd_msg_pub.Add;

859: p_set_id_tbl.COUNT < p_link_id_tbl.COUNT) then
860:
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:

Line 879: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

875: from cs_kb_sets_b
876: where set_id = l_set_id;
877: if(l_count<1) then
878:
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;

Line 881: fnd_msg_pub.Add;

877: if(l_count<1) then
878:
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:

Line 904: FND_MSG_PUB.Count_And_Get(

900: COMMIT WORK;
901: END IF;
902:
903: -- Standard call to get message count. if count=1, get message info.
904: FND_MSG_PUB.Count_And_Get(
905: p_count => x_msg_count,
906: p_data => x_msg_data );
907:
908: EXCEPTION

Line 912: FND_MSG_PUB.Count_And_Get(

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
916: ROLLBACK TO Change_Set_Links_PVT;

Line 918: FND_MSG_PUB.Count_And_Get(

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
922: ROLLBACK TO Change_Set_Links_PVT;

Line 924: IF FND_MSG_PUB.Check_Msg_Level

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,
928: l_api_name);

Line 925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
928: l_api_name);
929: END IF;

Line 926: FND_MSG_PUB.Add_Exc_Msg(

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,
928: l_api_name);
929: END IF;
930: FND_MSG_PUB.Count_And_Get(

Line 930: FND_MSG_PUB.Count_And_Get(

926: FND_MSG_PUB.Add_Exc_Msg(
927: G_PKG_NAME,
928: l_api_name);
929: END IF;
930: FND_MSG_PUB.Count_And_Get(
931: p_count => x_msg_count,
932: p_data => x_msg_data);
933:
934: end Change_Set_Links;

Line 970: FND_MSG_PUB.initialize;

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;
974: -- -- -- -- begin my code -- -- -- -- --

Line 981: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

977: if(p_set_id_tbl is null or p_new_ele_id_tbl is null or
978: p_set_id_tbl.COUNT =0 or p_new_ele_id_tbl.COUNT =0 or
979: p_new_ele_id_tbl.COUNT < p_set_id_tbl.COUNT) then
980:
981: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
982: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
983: fnd_msg_pub.Add;
984: end if;
985:

Line 983: fnd_msg_pub.Add;

979: p_new_ele_id_tbl.COUNT < p_set_id_tbl.COUNT) then
980:
981: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
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;

Line 1002: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

998: select count(*) into l_count
999: from cs_kb_elements_b
1000: where element_id = l_element_id;
1001: if(l_count<1) then
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;

Line 1004: fnd_msg_pub.Add;

1000: where element_id = l_element_id;
1001: if(l_count<1) then
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:

Line 1015: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1011: from cs_kb_set_eles
1012: where set_id = p_set_id_tbl(i1)
1013: and element_id = l_element_id;
1014: if(l_count>0) then
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;

Line 1017: fnd_msg_pub.Add;

1013: and element_id = l_element_id;
1014: if(l_count>0) then
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:

Line 1029: fnd_msg_pub.Add;

1025: l_retnum := Add_Element_To_Set(
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(

Line 1037: fnd_msg_pub.Add;

1033: l_retnum := Del_Element_From_Set(
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:

Line 1067: FND_MSG_PUB.Count_And_Get(

1063: COMMIT WORK;
1064: END IF;
1065:
1066: -- Standard call to get message count. if count=1, get message info.
1067: FND_MSG_PUB.Count_And_Get(
1068: p_count => x_msg_count,
1069: p_data => x_msg_data );
1070:
1071: EXCEPTION

Line 1075: FND_MSG_PUB.Count_And_Get(

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
1079: ROLLBACK TO Change_Element_To_Sets_PVT;

Line 1081: FND_MSG_PUB.Count_And_Get(

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
1085: ROLLBACK TO Change_Element_To_Sets_PVT;

Line 1087: IF FND_MSG_PUB.Check_Msg_Level

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,
1091: l_api_name);

Line 1088: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
1091: l_api_name);
1092: END IF;

Line 1089: FND_MSG_PUB.Add_Exc_Msg(

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,
1091: l_api_name);
1092: END IF;
1093: FND_MSG_PUB.Count_And_Get(

Line 1093: FND_MSG_PUB.Count_And_Get(

1089: FND_MSG_PUB.Add_Exc_Msg(
1090: G_PKG_NAME,
1091: l_api_name);
1092: END IF;
1093: FND_MSG_PUB.Count_And_Get(
1094: p_count => x_msg_count,
1095: p_data => x_msg_data);
1096:
1097: end Change_Element_To_Sets;

Line 1132: FND_MSG_PUB.initialize;

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;
1136: -- -- -- -- begin my code -- -- -- -- --

Line 1143: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1139: if(p_link_id_tbl is null or p_element_id_tbl is null or
1140: p_link_id_tbl.COUNT =0 or p_element_id_tbl.COUNT =0 or
1141: p_element_id_tbl.COUNT < p_link_id_tbl.COUNT) then
1142:
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;

Line 1145: fnd_msg_pub.Add;

1141: p_element_id_tbl.COUNT < p_link_id_tbl.COUNT) then
1142:
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:

Line 1161: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1157: select count(*) into l_count
1158: from cs_kb_elements_b
1159: where element_id = l_element_id;
1160: if(l_count<1) then
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;

Line 1163: fnd_msg_pub.Add;

1159: where element_id = l_element_id;
1160: if(l_count<1) then
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:

Line 1186: FND_MSG_PUB.Count_And_Get(

1182: COMMIT WORK;
1183: END IF;
1184:
1185: -- Standard call to get message count. if count=1, get message info.
1186: FND_MSG_PUB.Count_And_Get(
1187: p_count => x_msg_count,
1188: p_data => x_msg_data );
1189:
1190: EXCEPTION

Line 1194: FND_MSG_PUB.Count_And_Get(

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
1198: ROLLBACK TO Change_Element_Links_PVT;

Line 1200: FND_MSG_PUB.Count_And_Get(

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
1204: ROLLBACK TO Change_Element_Links_PVT;

Line 1206: IF FND_MSG_PUB.Check_Msg_Level

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,
1210: l_api_name);

Line 1207: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
1210: l_api_name);
1211: END IF;

Line 1208: FND_MSG_PUB.Add_Exc_Msg(

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,
1210: l_api_name);
1211: END IF;
1212: FND_MSG_PUB.Count_And_Get(

Line 1212: FND_MSG_PUB.Count_And_Get(

1208: FND_MSG_PUB.Add_Exc_Msg(
1209: G_PKG_NAME,
1210: l_api_name);
1211: END IF;
1212: FND_MSG_PUB.Count_And_Get(
1213: p_count => x_msg_count,
1214: p_data => x_msg_data);
1215:
1216: end Change_Element_Links;

Line 1624: FND_MSG_PUB.Count_And_Get(

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 );
1628: end Create_Set_And_Elements;

Line 1685: FND_MSG_PUB.initialize;

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;
1689:

Line 1715: FND_MSG_PUB.Count_And_Get(

1711: COMMIT WORK;
1712: END IF;
1713:
1714: -- Standard call to get message count. if count=1, get message info.
1715: FND_MSG_PUB.Count_And_Get(
1716: p_count => x_msg_count,
1717: p_data => x_msg_data );
1718:
1719: EXCEPTION

Line 1723: FND_MSG_PUB.Count_And_Get(

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
1727: ROLLBACK TO Create_Set_And_Elements_PVT;

Line 1729: FND_MSG_PUB.Count_And_Get(

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
1733: ROLLBACK TO Create_Set_And_Elements_PVT;

Line 1735: IF FND_MSG_PUB.Check_Msg_Level

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,
1739: l_api_name);

Line 1736: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
1739: l_api_name);
1740: END IF;

Line 1737: FND_MSG_PUB.Add_Exc_Msg(

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,
1739: l_api_name);
1740: END IF;
1741: FND_MSG_PUB.Count_And_Get(

Line 1741: FND_MSG_PUB.Count_And_Get(

1737: FND_MSG_PUB.Add_Exc_Msg(
1738: G_PKG_NAME,
1739: l_api_name);
1740: END IF;
1741: FND_MSG_PUB.Count_And_Get(
1742: p_count => x_msg_count,
1743: p_data => x_msg_data);
1744: end Create_Set_And_Elements;
1745:

Line 1827: FND_MSG_PUB.initialize;

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;
1831:

Line 1843: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1839: if(p_set_def_obj.set_type_id is null or
1840: p_set_def_obj.set_type_id <=0 or
1841: p_set_def_obj.name is null) then
1842:
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;

Line 1845: fnd_msg_pub.Add;

1841: p_set_def_obj.name is null) then
1842:
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;

Line 1855: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1851: IF(p_set_def_obj.status is not null AND
1852: p_set_def_obj.status <> 'SAV' )THEN
1853:
1854: -- This Create api only creates Draft Solutions
1855: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1856:
1857: fnd_message.set_name('CS', 'CS_KB_INV_API_STATUS');
1858: fnd_msg_pub.Add;
1859:

Line 1858: fnd_msg_pub.Add;

1854: -- This Create api only creates Draft Solutions
1855: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1856:
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:

Line 1870: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1866: FETCH Get_Defaulted_Category INTO l_defaulted_category;
1867: CLOSE Get_Defaulted_Category;
1868:
1869: IF l_defaulted_category IS NULL THEN
1870: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1871:
1872: OPEN Get_Profile_Name;
1873: FETCH Get_Profile_Name INTO l_profile_name;
1874: CLOSE Get_Profile_Name;

Line 1880: fnd_msg_pub.Add;

1876: fnd_message.set_name('CS', 'CS_KB_INV_CAT_PROFILE');
1877: FND_MESSAGE.SET_TOKEN(TOKEN => 'PROFILE',
1878: VALUE => l_profile_name,
1879: TRANSLATE => true);
1880: fnd_msg_pub.Add;
1881:
1882: END IF;
1883: RAISE FND_API.G_EXC_ERROR;
1884: END IF;

Line 1888: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

1884: END IF;
1885:
1886: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1887:
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;

Line 1890: fnd_msg_pub.Add;

1886: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1887:
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;

Line 1949: FND_MSG_PUB.Add;

1945: IF l_ele_check = 1 THEN
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;

Line 2002: FND_MSG_PUB.Count_And_Get(

1998: COMMIT WORK;
1999: END IF;
2000:
2001: -- Standard call to get message count. if count=1, get message info.
2002: FND_MSG_PUB.Count_And_Get(
2003: p_count => x_msg_count,
2004: p_data => x_msg_data );
2005:
2006: EXCEPTION

Line 2010: FND_MSG_PUB.Count_And_Get(

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 );
2014:

Line 2019: FND_MSG_PUB.Count_And_Get(

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
2023: ROLLBACK TO Create_Set_And_Elements_PVT;

Line 2025: IF FND_MSG_PUB.Check_Msg_Level

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,
2029: l_api_name);

Line 2026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
2029: l_api_name);
2030: END IF;

Line 2027: FND_MSG_PUB.Add_Exc_Msg(

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,
2029: l_api_name);
2030: END IF;
2031: FND_MSG_PUB.Count_And_Get(

Line 2031: FND_MSG_PUB.Count_And_Get(

2027: FND_MSG_PUB.Add_Exc_Msg(
2028: G_PKG_NAME,
2029: l_api_name);
2030: END IF;
2031: FND_MSG_PUB.Count_And_Get(
2032: p_count => x_msg_count,
2033: p_data => x_msg_data);
2034: END Create_Set_And_Elements;
2035:

Line 2060: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2056: begin
2057:
2058: if(p_ele_id_tbl is null ) then
2059:
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;

Line 2062: fnd_msg_pub.Add;

2058: if(p_ele_id_tbl is null ) then
2059:
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:

Line 2167: FND_MSG_PUB.initialize;

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;
2171: -- -- -- -- begin my code -- -- -- -- --

Line 2178: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2174: p_set_def_obj.set_type_id <= 0 or
2175: p_set_def_obj.name is null
2176: ) then
2177:
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;

Line 2180: fnd_msg_pub.Add;

2176: ) then
2177:
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:

Line 2187: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2183: end if;
2184:
2185: if(p_ele_id_tbl is null or p_ele_id_tbl.COUNT <= 0) then
2186:
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;

Line 2189: fnd_msg_pub.Add;

2185: if(p_ele_id_tbl is null or p_ele_id_tbl.COUNT <= 0) then
2186:
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:

Line 2202: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2198: if( Is_Set_Ele_Type_Valid(
2199: p_set_type_id => p_set_def_obj.set_type_id,
2200: p_ele_id => p_ele_id_tbl(i3))
2201: = G_FALSE) then
2202: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2203: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
2204: fnd_msg_pub.Add;
2205:
2206: end if;

Line 2204: fnd_msg_pub.Add;

2200: p_ele_id => p_ele_id_tbl(i3))
2201: = G_FALSE) then
2202: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
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;

Line 2224: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

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:
2228: end if;

Line 2226: fnd_msg_pub.Add;

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:
2228: end if;
2229: raise FND_API.G_EXC_ERROR;
2230: end if;

Line 2279: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2275: i1 := p_ele_id_tbl.FIRST;
2276: while i1 is not null loop
2277: --validate element
2278: if(p_ele_id_tbl(i1) is null or p_ele_id_tbl(i1) < 0) then
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;

Line 2281: fnd_msg_pub.Add;

2277: --validate element
2278: if(p_ele_id_tbl(i1) is null or p_ele_id_tbl(i1) < 0) then
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:

Line 2323: FND_MSG_PUB.Count_And_Get(

2319: COMMIT WORK;
2320: END IF;
2321:
2322: -- Standard call to get message count. if count=1, get message info.
2323: FND_MSG_PUB.Count_And_Get(
2324: p_count => x_msg_count,
2325: p_data => x_msg_data );
2326:
2327: EXCEPTION

Line 2332: FND_MSG_PUB.Count_And_Get(

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:
2336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2340: FND_MSG_PUB.Count_And_Get(

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
2344: ROLLBACK TO Create_Set_PVT;

Line 2346: IF FND_MSG_PUB.Check_Msg_Level

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,
2350: l_api_name);

Line 2347: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
2350: l_api_name);
2351: END IF;

Line 2348: FND_MSG_PUB.Add_Exc_Msg(

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,
2350: l_api_name);
2351: END IF;
2352: FND_MSG_PUB.Count_And_Get(

Line 2352: FND_MSG_PUB.Count_And_Get(

2348: FND_MSG_PUB.Add_Exc_Msg(
2349: G_PKG_NAME,
2350: l_api_name);
2351: END IF;
2352: FND_MSG_PUB.Count_And_Get(
2353: p_count => x_msg_count,
2354: p_data => x_msg_data);
2355:
2356: end Create_Set;

Line 2432: FND_MSG_PUB.initialize;

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;
2436:

Line 2446: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2442:
2443: -- Check params
2444: if(p_ele_def_obj.element_type_id is null
2445: ) then
2446: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2447: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2448: fnd_msg_pub.Add;
2449: end if;
2450:

Line 2448: fnd_msg_pub.Add;

2444: if(p_ele_def_obj.element_type_id is null
2445: ) then
2446: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
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;

Line 2478: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2474:
2475: x_element_id := l_ele_id;
2476:
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;

Line 2479: fnd_msg_pub.Add;

2475: x_element_id := l_ele_id;
2476:
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:

Line 2493: FND_MSG_PUB.Count_And_Get(

2489: COMMIT WORK;
2490: END IF;
2491:
2492: -- Standard call to get message count. if count=1, get message info.
2493: FND_MSG_PUB.Count_And_Get(
2494: p_count => x_msg_count,
2495: p_data => x_msg_data );
2496:
2497: EXCEPTION

Line 2501: FND_MSG_PUB.Count_And_Get(

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
2505: ROLLBACK TO Create_Element_PVT;

Line 2507: FND_MSG_PUB.Count_And_Get(

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
2511: ROLLBACK TO Create_Element_PVT;

Line 2513: IF FND_MSG_PUB.Check_Msg_Level

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,
2517: l_api_name);

Line 2514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
2517: l_api_name);
2518: END IF;

Line 2515: FND_MSG_PUB.Add_Exc_Msg(

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,
2517: l_api_name);
2518: END IF;
2519: FND_MSG_PUB.Count_And_Get(

Line 2519: FND_MSG_PUB.Count_And_Get(

2515: FND_MSG_PUB.Add_Exc_Msg(
2516: G_PKG_NAME,
2517: l_api_name);
2518: END IF;
2519: FND_MSG_PUB.Count_And_Get(
2520: p_count => x_msg_count,
2521: p_data => x_msg_data);
2522: end Create_Element;
2523:

Line 2562: FND_MSG_PUB.initialize;

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;
2566:

Line 2570: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

2566:
2567: -- -- -- -- begin my code -- -- -- -- --
2568: -- Check params
2569: if(p_set_id is null) then
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;

Line 2572: fnd_msg_pub.Add;

2568: -- Check params
2569: if(p_set_id is null) then
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:

Line 2614: FND_MSG_PUB.Count_And_Get(

2610: COMMIT WORK;
2611: END IF;
2612:
2613: -- Standard call to get message count. if count=1, get message info.
2614: FND_MSG_PUB.Count_And_Get(
2615: p_count => x_msg_count,
2616: p_data => x_msg_data );
2617:
2618: EXCEPTION

Line 2622: FND_MSG_PUB.Count_And_Get(

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
2626: ROLLBACK TO Incr_Set_Useful_PVT;

Line 2628: FND_MSG_PUB.Count_And_Get(

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
2632: ROLLBACK TO Incr_Set_Useful_PVT;

Line 2634: IF FND_MSG_PUB.Check_Msg_Level

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,
2638: l_api_name);

Line 2635: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
2638: l_api_name);
2639: END IF;

Line 2636: FND_MSG_PUB.Add_Exc_Msg(

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,
2638: l_api_name);
2639: END IF;
2640: FND_MSG_PUB.Count_And_Get(

Line 2640: FND_MSG_PUB.Count_And_Get(

2636: FND_MSG_PUB.Add_Exc_Msg(
2637: G_PKG_NAME,
2638: l_api_name);
2639: END IF;
2640: FND_MSG_PUB.Count_And_Get(
2641: p_count => x_msg_count,
2642: p_data => x_msg_data);
2643: end Incr_Set_Useful;
2644:

Line 3844: FND_MSG_PUB.initialize;

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;
3848:

Line 3865: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

3861: end if;
3862:
3863:
3864: if l_sql_contains is null then
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;

Line 3867: fnd_msg_pub.Add;

3863:
3864: if l_sql_contains is null then
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:

Line 3909: FND_MSG_PUB.Count_And_Get(

3905: end if;
3906: -- -- -- -- end of code -- -- --
3907:
3908: -- Standard call to get message count. if count=1, get message info.
3909: FND_MSG_PUB.Count_And_Get(
3910: p_count => x_msg_count,
3911: p_data => x_msg_data );
3912:
3913: EXCEPTION

Line 3917: FND_MSG_PUB.Count_And_Get(

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
3921: ROLLBACK TO Find_Sets_Matching_PVT;

Line 3923: FND_MSG_PUB.Count_And_Get(

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
3927:

Line 3960: IF FND_MSG_PUB.Check_Msg_Level

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,
3964: l_api_name);

Line 3961: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
3964: l_api_name);
3965: END IF;

Line 3962: FND_MSG_PUB.Add_Exc_Msg(

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,
3964: l_api_name);
3965: END IF;
3966: FND_MSG_PUB.Count_And_Get(

Line 3966: FND_MSG_PUB.Count_And_Get(

3962: FND_MSG_PUB.Add_Exc_Msg(
3963: G_PKG_NAME,
3964: l_api_name);
3965: END IF;
3966: FND_MSG_PUB.Count_And_Get(
3967: p_count => x_msg_count,
3968: p_data => x_msg_data);
3969: end if;
3970:

Line 4050: FND_MSG_PUB.initialize;

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;
4054:

Line 4067: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then

4063: l_sql_contains := p_pos_query_str;
4064: end if;
4065:
4066: if l_sql_contains is null then
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;

Line 4069: fnd_msg_pub.Add;

4065:
4066: if l_sql_contains is null then
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:

Line 4110: FND_MSG_PUB.Count_And_Get(

4106: end if;
4107: -- -- -- -- end of code -- -- --
4108:
4109: -- Standard call to get message count. if count=1, get message info.
4110: FND_MSG_PUB.Count_And_Get(
4111: p_count => x_msg_count,
4112: p_data => x_msg_data );
4113:
4114: EXCEPTION

Line 4118: FND_MSG_PUB.Count_And_Get(

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
4122:

Line 4125: FND_MSG_PUB.Count_And_Get(

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
4129:

Line 4163: IF FND_MSG_PUB.Check_Msg_Level

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,
4167: l_api_name);

Line 4164: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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,
4167: l_api_name);
4168: END IF;

Line 4165: FND_MSG_PUB.Add_Exc_Msg(

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,
4167: l_api_name);
4168: END IF;
4169: FND_MSG_PUB.Count_And_Get(

Line 4169: FND_MSG_PUB.Count_And_Get(

4165: FND_MSG_PUB.Add_Exc_Msg(
4166: G_PKG_NAME,
4167: l_api_name);
4168: END IF;
4169: FND_MSG_PUB.Count_And_Get(
4170: p_count => x_msg_count,
4171: p_data => x_msg_data);
4172: end if;
4173: