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 594: FND_MSG_PUB.initialize;

590: raise FND_API.G_EXC_UNEXPECTED_ERROR;
591: end if;
592:
593: if FND_API.to_Boolean(p_init_msg_list) then
594: FND_MSG_PUB.initialize;
595: end if;
596:
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: -- -- -- -- begin my code -- -- -- -- --

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

602: p_object_code is null or
603: p_other_id_tbl is null or p_other_code_tbl is null or
604: p_other_id_tbl.COUNT <> p_other_code_tbl.COUNT) then
605:
606: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
607: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
608: fnd_msg_pub.Add;
609: end if;
610: raise FND_API.G_EXC_ERROR;

Line 608: fnd_msg_pub.Add;

604: p_other_id_tbl.COUNT <> p_other_code_tbl.COUNT) then
605:
606: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
607: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
608: fnd_msg_pub.Add;
609: end if;
610: raise FND_API.G_EXC_ERROR;
611: end if;
612:

Line 665: FND_MSG_PUB.Count_And_Get(

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

Line 673: FND_MSG_PUB.Count_And_Get(

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

Line 679: FND_MSG_PUB.Count_And_Get(

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

Line 685: IF FND_MSG_PUB.Check_Msg_Level

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

Line 686: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

682: WHEN OTHERS THEN
683: ROLLBACK TO Add_External_Links_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: IF FND_MSG_PUB.Check_Msg_Level
686: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
687: FND_MSG_PUB.Add_Exc_Msg(
688: G_PKG_NAME,
689: l_api_name);
690: END IF;

Line 687: FND_MSG_PUB.Add_Exc_Msg(

683: ROLLBACK TO Add_External_Links_PVT;
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
685: IF FND_MSG_PUB.Check_Msg_Level
686: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
687: FND_MSG_PUB.Add_Exc_Msg(
688: G_PKG_NAME,
689: l_api_name);
690: END IF;
691: FND_MSG_PUB.Count_And_Get(

Line 691: FND_MSG_PUB.Count_And_Get(

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

Line 731: FND_MSG_PUB.initialize;

727: raise FND_API.G_EXC_UNEXPECTED_ERROR;
728: end if;
729:
730: if FND_API.to_Boolean(p_init_msg_list) then
731: FND_MSG_PUB.initialize;
732: end if;
733:
734: x_return_status := FND_API.G_RET_STS_SUCCESS;
735: -- -- -- -- begin my code -- -- -- -- --

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

738: if(p_link_id_tbl is null or p_ele_type_id_tbl is null or
739: p_link_id_tbl.COUNT =0 or p_ele_type_id_tbl.COUNT =0 or
740: p_ele_type_id_tbl.COUNT < p_link_id_tbl.COUNT) then
741:
742: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
743: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
744: fnd_msg_pub.Add;
745: end if;
746: raise FND_API.G_EXC_ERROR;

Line 744: fnd_msg_pub.Add;

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

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

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

Line 763: fnd_msg_pub.Add;

759: if(l_count<1) then
760:
761: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
762: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_TYPE_ID');
763: fnd_msg_pub.Add;
764: end if;
765:
766: raise FND_API.G_EXC_ERROR;
767: end if;

Line 787: FND_MSG_PUB.Count_And_Get(

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

Line 795: FND_MSG_PUB.Count_And_Get(

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

Line 801: FND_MSG_PUB.Count_And_Get(

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

Line 807: IF FND_MSG_PUB.Check_Msg_Level

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

Line 808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

804: WHEN OTHERS THEN
805: ROLLBACK TO Change_Ele_Type_Links_PVT;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: IF FND_MSG_PUB.Check_Msg_Level
808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
809: FND_MSG_PUB.Add_Exc_Msg(
810: G_PKG_NAME,
811: l_api_name);
812: END IF;

Line 809: FND_MSG_PUB.Add_Exc_Msg(

805: ROLLBACK TO Change_Ele_Type_Links_PVT;
806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
807: IF FND_MSG_PUB.Check_Msg_Level
808: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
809: FND_MSG_PUB.Add_Exc_Msg(
810: G_PKG_NAME,
811: l_api_name);
812: END IF;
813: FND_MSG_PUB.Count_And_Get(

Line 813: FND_MSG_PUB.Count_And_Get(

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

Line 852: FND_MSG_PUB.initialize;

848: raise FND_API.G_EXC_UNEXPECTED_ERROR;
849: end if;
850:
851: if FND_API.to_Boolean(p_init_msg_list) then
852: FND_MSG_PUB.initialize;
853: end if;
854:
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: -- -- -- -- begin my code -- -- -- -- --

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

859: if(p_link_id_tbl is null or p_set_id_tbl is null or
860: p_link_id_tbl.COUNT =0 or p_set_id_tbl.COUNT =0 or
861: p_set_id_tbl.COUNT < p_link_id_tbl.COUNT) then
862:
863: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
864: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
865: fnd_msg_pub.Add;
866: end if;
867: raise FND_API.G_EXC_ERROR;

Line 865: fnd_msg_pub.Add;

861: p_set_id_tbl.COUNT < p_link_id_tbl.COUNT) then
862:
863: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
864: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
865: fnd_msg_pub.Add;
866: end if;
867: raise FND_API.G_EXC_ERROR;
868: end if;
869:

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

877: from cs_kb_sets_b
878: where set_id = l_set_id;
879: if(l_count<1) then
880:
881: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
882: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
883: fnd_msg_pub.Add;
884: end if;
885: raise FND_API.G_EXC_ERROR;

Line 883: fnd_msg_pub.Add;

879: if(l_count<1) then
880:
881: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
882: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
883: fnd_msg_pub.Add;
884: end if;
885: raise FND_API.G_EXC_ERROR;
886: end if;
887:

Line 906: FND_MSG_PUB.Count_And_Get(

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

Line 914: FND_MSG_PUB.Count_And_Get(

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

Line 920: FND_MSG_PUB.Count_And_Get(

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

Line 926: IF FND_MSG_PUB.Check_Msg_Level

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

Line 927: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

923: WHEN OTHERS THEN
924: ROLLBACK TO Change_Set_Links_PVT;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926: IF FND_MSG_PUB.Check_Msg_Level
927: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
928: FND_MSG_PUB.Add_Exc_Msg(
929: G_PKG_NAME,
930: l_api_name);
931: END IF;

Line 928: FND_MSG_PUB.Add_Exc_Msg(

924: ROLLBACK TO Change_Set_Links_PVT;
925: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
926: IF FND_MSG_PUB.Check_Msg_Level
927: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
928: FND_MSG_PUB.Add_Exc_Msg(
929: G_PKG_NAME,
930: l_api_name);
931: END IF;
932: FND_MSG_PUB.Count_And_Get(

Line 932: FND_MSG_PUB.Count_And_Get(

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

Line 972: FND_MSG_PUB.initialize;

968: raise FND_API.G_EXC_UNEXPECTED_ERROR;
969: end if;
970:
971: if FND_API.to_Boolean(p_init_msg_list) then
972: FND_MSG_PUB.initialize;
973: end if;
974:
975: x_return_status := FND_API.G_RET_STS_SUCCESS;
976: -- -- -- -- begin my code -- -- -- -- --

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

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

Line 985: fnd_msg_pub.Add;

981: p_new_ele_id_tbl.COUNT < p_set_id_tbl.COUNT) then
982:
983: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
984: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
985: fnd_msg_pub.Add;
986: end if;
987:
988: raise FND_API.G_EXC_ERROR;
989: end if;

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

1000: select count(*) into l_count
1001: from cs_kb_elements_b
1002: where element_id = l_element_id;
1003: if(l_count<1) then
1004: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1005: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1006: fnd_msg_pub.Add;
1007: end if;
1008: raise FND_API.G_EXC_ERROR;

Line 1006: fnd_msg_pub.Add;

1002: where element_id = l_element_id;
1003: if(l_count<1) then
1004: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1005: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1006: fnd_msg_pub.Add;
1007: end if;
1008: raise FND_API.G_EXC_ERROR;
1009: end if;
1010:

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

1013: from cs_kb_set_eles
1014: where set_id = p_set_id_tbl(i1)
1015: and element_id = l_element_id;
1016: if(l_count>0) then
1017: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1018: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1019: fnd_msg_pub.Add;
1020: end if;
1021: raise FND_API.G_EXC_ERROR;

Line 1019: fnd_msg_pub.Add;

1015: and element_id = l_element_id;
1016: if(l_count>0) then
1017: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1018: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1019: fnd_msg_pub.Add;
1020: end if;
1021: raise FND_API.G_EXC_ERROR;
1022: end if;
1023:

Line 1031: fnd_msg_pub.Add;

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

Line 1039: fnd_msg_pub.Add;

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

Line 1069: FND_MSG_PUB.Count_And_Get(

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

Line 1077: FND_MSG_PUB.Count_And_Get(

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

Line 1083: FND_MSG_PUB.Count_And_Get(

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

Line 1089: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1090: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1086: WHEN OTHERS THEN
1087: ROLLBACK TO Change_Element_To_Sets_PVT;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: IF FND_MSG_PUB.Check_Msg_Level
1090: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1091: FND_MSG_PUB.Add_Exc_Msg(
1092: G_PKG_NAME,
1093: l_api_name);
1094: END IF;

Line 1091: FND_MSG_PUB.Add_Exc_Msg(

1087: ROLLBACK TO Change_Element_To_Sets_PVT;
1088: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1089: IF FND_MSG_PUB.Check_Msg_Level
1090: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1091: FND_MSG_PUB.Add_Exc_Msg(
1092: G_PKG_NAME,
1093: l_api_name);
1094: END IF;
1095: FND_MSG_PUB.Count_And_Get(

Line 1095: FND_MSG_PUB.Count_And_Get(

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

Line 1134: FND_MSG_PUB.initialize;

1130: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1131: end if;
1132:
1133: if FND_API.to_Boolean(p_init_msg_list) then
1134: FND_MSG_PUB.initialize;
1135: end if;
1136:
1137: x_return_status := FND_API.G_RET_STS_SUCCESS;
1138: -- -- -- -- begin my code -- -- -- -- --

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

1141: if(p_link_id_tbl is null or p_element_id_tbl is null or
1142: p_link_id_tbl.COUNT =0 or p_element_id_tbl.COUNT =0 or
1143: p_element_id_tbl.COUNT < p_link_id_tbl.COUNT) then
1144:
1145: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1146: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1147: fnd_msg_pub.Add;
1148: end if;
1149: raise FND_API.G_EXC_ERROR;

Line 1147: fnd_msg_pub.Add;

1143: p_element_id_tbl.COUNT < p_link_id_tbl.COUNT) then
1144:
1145: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1146: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1147: fnd_msg_pub.Add;
1148: end if;
1149: raise FND_API.G_EXC_ERROR;
1150: end if;
1151:

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

1159: select count(*) into l_count
1160: from cs_kb_elements_b
1161: where element_id = l_element_id;
1162: if(l_count<1) then
1163: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1164: fnd_message.set_name('CS', 'CS_KB_C_INVALID_ELE_ID');
1165: fnd_msg_pub.Add;
1166: end if;
1167: raise FND_API.G_EXC_ERROR;

Line 1165: fnd_msg_pub.Add;

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

Line 1188: FND_MSG_PUB.Count_And_Get(

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

Line 1196: FND_MSG_PUB.Count_And_Get(

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

Line 1202: FND_MSG_PUB.Count_And_Get(

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

Line 1208: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1205: WHEN OTHERS THEN
1206: ROLLBACK TO Change_Element_Links_PVT;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: IF FND_MSG_PUB.Check_Msg_Level
1209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: FND_MSG_PUB.Add_Exc_Msg(
1211: G_PKG_NAME,
1212: l_api_name);
1213: END IF;

Line 1210: FND_MSG_PUB.Add_Exc_Msg(

1206: ROLLBACK TO Change_Element_Links_PVT;
1207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1208: IF FND_MSG_PUB.Check_Msg_Level
1209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1210: FND_MSG_PUB.Add_Exc_Msg(
1211: G_PKG_NAME,
1212: l_api_name);
1213: END IF;
1214: FND_MSG_PUB.Count_And_Get(

Line 1214: FND_MSG_PUB.Count_And_Get(

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

Line 1628: FND_MSG_PUB.Count_And_Get(

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

Line 1689: FND_MSG_PUB.initialize;

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

Line 1719: FND_MSG_PUB.Count_And_Get(

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

Line 1727: FND_MSG_PUB.Count_And_Get(

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

Line 1733: FND_MSG_PUB.Count_And_Get(

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

Line 1739: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1740: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1736: WHEN OTHERS THEN
1737: ROLLBACK TO Create_Set_And_Elements_PVT;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1739: IF FND_MSG_PUB.Check_Msg_Level
1740: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1741: FND_MSG_PUB.Add_Exc_Msg(
1742: G_PKG_NAME,
1743: l_api_name);
1744: END IF;

Line 1741: FND_MSG_PUB.Add_Exc_Msg(

1737: ROLLBACK TO Create_Set_And_Elements_PVT;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1739: IF FND_MSG_PUB.Check_Msg_Level
1740: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1741: FND_MSG_PUB.Add_Exc_Msg(
1742: G_PKG_NAME,
1743: l_api_name);
1744: END IF;
1745: FND_MSG_PUB.Count_And_Get(

Line 1745: FND_MSG_PUB.Count_And_Get(

1741: FND_MSG_PUB.Add_Exc_Msg(
1742: G_PKG_NAME,
1743: l_api_name);
1744: END IF;
1745: FND_MSG_PUB.Count_And_Get(
1746: p_count => x_msg_count,
1747: p_data => x_msg_data);
1748: end Create_Set_And_Elements;
1749:

Line 1831: FND_MSG_PUB.initialize;

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

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

1843: if(p_set_def_obj.set_type_id is null or
1844: p_set_def_obj.set_type_id <=0 or
1845: p_set_def_obj.name is null) then
1846:
1847: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1848: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1849: fnd_msg_pub.Add;
1850: end if;
1851: raise FND_API.G_EXC_ERROR;

Line 1849: fnd_msg_pub.Add;

1845: p_set_def_obj.name is null) then
1846:
1847: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1848: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1849: fnd_msg_pub.Add;
1850: end if;
1851: raise FND_API.G_EXC_ERROR;
1852:
1853: end if;

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

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

Line 1862: fnd_msg_pub.Add;

1858: -- This Create api only creates Draft Solutions
1859: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1860:
1861: fnd_message.set_name('CS', 'CS_KB_INV_API_STATUS');
1862: fnd_msg_pub.Add;
1863:
1864: END IF;
1865: RAISE FND_API.G_EXC_ERROR;
1866:

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

1870: FETCH Get_Defaulted_Category INTO l_defaulted_category;
1871: CLOSE Get_Defaulted_Category;
1872:
1873: IF l_defaulted_category IS NULL THEN
1874: IF fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1875:
1876: OPEN Get_Profile_Name;
1877: FETCH Get_Profile_Name INTO l_profile_name;
1878: CLOSE Get_Profile_Name;

Line 1884: fnd_msg_pub.Add;

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

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

1888: END IF;
1889:
1890: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1891:
1892: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1893: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1894: fnd_msg_pub.Add;
1895: end if;
1896: raise FND_API.G_EXC_ERROR;

Line 1894: fnd_msg_pub.Add;

1890: if(p_ele_def_tbl is null or p_ele_def_tbl.COUNT <= 0) then
1891:
1892: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1893: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
1894: fnd_msg_pub.Add;
1895: end if;
1896: raise FND_API.G_EXC_ERROR;
1897:
1898: end if;

Line 1953: FND_MSG_PUB.Add;

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

Line 2006: FND_MSG_PUB.Count_And_Get(

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

Line 2014: FND_MSG_PUB.Count_And_Get(

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

Line 2023: FND_MSG_PUB.Count_And_Get(

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

Line 2029: IF FND_MSG_PUB.Check_Msg_Level

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

Line 2030: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2026: WHEN OTHERS THEN
2027: ROLLBACK TO Create_Set_And_Elements_PVT;
2028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2029: IF FND_MSG_PUB.Check_Msg_Level
2030: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2031: FND_MSG_PUB.Add_Exc_Msg(
2032: G_PKG_NAME,
2033: l_api_name);
2034: END IF;

Line 2031: FND_MSG_PUB.Add_Exc_Msg(

2027: ROLLBACK TO Create_Set_And_Elements_PVT;
2028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2029: IF FND_MSG_PUB.Check_Msg_Level
2030: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2031: FND_MSG_PUB.Add_Exc_Msg(
2032: G_PKG_NAME,
2033: l_api_name);
2034: END IF;
2035: FND_MSG_PUB.Count_And_Get(

Line 2035: FND_MSG_PUB.Count_And_Get(

2031: FND_MSG_PUB.Add_Exc_Msg(
2032: G_PKG_NAME,
2033: l_api_name);
2034: END IF;
2035: FND_MSG_PUB.Count_And_Get(
2036: p_count => x_msg_count,
2037: p_data => x_msg_data);
2038: END Create_Set_And_Elements;
2039:

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

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

Line 2066: fnd_msg_pub.Add;

2062: if(p_ele_id_tbl is null ) then
2063:
2064: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2065: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2066: fnd_msg_pub.Add;
2067: end if;
2068: raise FND_API.G_EXC_ERROR;
2069: end if;
2070:

Line 2171: FND_MSG_PUB.initialize;

2167: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2168: end if;
2169:
2170: if FND_API.to_Boolean(p_init_msg_list) then
2171: FND_MSG_PUB.initialize;
2172: end if;
2173:
2174: x_return_status := FND_API.G_RET_STS_SUCCESS;
2175: -- -- -- -- begin my code -- -- -- -- --

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

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

Line 2184: fnd_msg_pub.Add;

2180: ) then
2181:
2182: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2183: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2184: fnd_msg_pub.Add;
2185: end if;
2186: RAISE FND_API.G_EXC_ERROR; -- goto error_found;
2187: end if;
2188:

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

2187: end if;
2188:
2189: if(p_ele_id_tbl is null or p_ele_id_tbl.COUNT <= 0) then
2190:
2191: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2192: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2193: fnd_msg_pub.Add;
2194: end if;
2195: raise FND_API.G_EXC_ERROR;

Line 2193: fnd_msg_pub.Add;

2189: if(p_ele_id_tbl is null or p_ele_id_tbl.COUNT <= 0) then
2190:
2191: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2192: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2193: fnd_msg_pub.Add;
2194: end if;
2195: raise FND_API.G_EXC_ERROR;
2196: end if;
2197:

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

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

Line 2208: fnd_msg_pub.Add;

2204: p_ele_id => p_ele_id_tbl(i3))
2205: = G_FALSE) then
2206: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2207: fnd_message.set_name('CS', 'CS_KB_C_INCOMPATIBLE_TYPES');
2208: fnd_msg_pub.Add;
2209:
2210: end if;
2211: RAISE FND_API.G_EXC_ERROR;
2212: end if;

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

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

Line 2230: fnd_msg_pub.Add;

2226: if(Is_Required_Type_Missing(
2227: p_set_def_obj.set_type_id,l_ele_def_tbl)=FND_API.G_TRUE) then
2228: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2229: fnd_message.set_name('CS', 'CS_KB_C_MISS_REQ_TYPE');
2230: fnd_msg_pub.Add;
2231:
2232: end if;
2233: raise FND_API.G_EXC_ERROR;
2234: end if;

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

2279: i1 := p_ele_id_tbl.FIRST;
2280: while i1 is not null loop
2281: --validate element
2282: if(p_ele_id_tbl(i1) is null or p_ele_id_tbl(i1) < 0) then
2283: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2284: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2285: fnd_msg_pub.Add;
2286: end if;
2287: RAISE FND_API.G_EXC_ERROR;

Line 2285: fnd_msg_pub.Add;

2281: --validate element
2282: if(p_ele_id_tbl(i1) is null or p_ele_id_tbl(i1) < 0) then
2283: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2284: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2285: fnd_msg_pub.Add;
2286: end if;
2287: RAISE FND_API.G_EXC_ERROR;
2288: end if;
2289:

Line 2327: FND_MSG_PUB.Count_And_Get(

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

Line 2336: FND_MSG_PUB.Count_And_Get(

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

Line 2344: FND_MSG_PUB.Count_And_Get(

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

Line 2350: IF FND_MSG_PUB.Check_Msg_Level

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

Line 2351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2347: WHEN OTHERS THEN
2348: ROLLBACK TO Create_Set_PVT;
2349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2350: IF FND_MSG_PUB.Check_Msg_Level
2351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2352: FND_MSG_PUB.Add_Exc_Msg(
2353: G_PKG_NAME,
2354: l_api_name);
2355: END IF;

Line 2352: FND_MSG_PUB.Add_Exc_Msg(

2348: ROLLBACK TO Create_Set_PVT;
2349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2350: IF FND_MSG_PUB.Check_Msg_Level
2351: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2352: FND_MSG_PUB.Add_Exc_Msg(
2353: G_PKG_NAME,
2354: l_api_name);
2355: END IF;
2356: FND_MSG_PUB.Count_And_Get(

Line 2356: FND_MSG_PUB.Count_And_Get(

2352: FND_MSG_PUB.Add_Exc_Msg(
2353: G_PKG_NAME,
2354: l_api_name);
2355: END IF;
2356: FND_MSG_PUB.Count_And_Get(
2357: p_count => x_msg_count,
2358: p_data => x_msg_data);
2359:
2360: end Create_Set;

Line 2436: FND_MSG_PUB.initialize;

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

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

2446:
2447: -- Check params
2448: if(p_ele_def_obj.element_type_id is null
2449: ) then
2450: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2451: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2452: fnd_msg_pub.Add;
2453: end if;
2454:

Line 2452: fnd_msg_pub.Add;

2448: if(p_ele_def_obj.element_type_id is null
2449: ) then
2450: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2451: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2452: fnd_msg_pub.Add;
2453: end if;
2454:
2455: raise FND_API.G_EXC_ERROR; -- goto error_found;
2456: end if;

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

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

Line 2483: fnd_msg_pub.Add;

2479: x_element_id := l_ele_id;
2480:
2481: if not (l_ele_id>0) then
2482: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2483: fnd_msg_pub.Add;
2484: end if;
2485: raise FND_API.G_EXC_ERROR;
2486: end if;
2487:

Line 2497: FND_MSG_PUB.Count_And_Get(

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

Line 2505: FND_MSG_PUB.Count_And_Get(

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

Line 2511: FND_MSG_PUB.Count_And_Get(

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

Line 2517: IF FND_MSG_PUB.Check_Msg_Level

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

Line 2518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2514: WHEN OTHERS THEN
2515: ROLLBACK TO Create_Element_PVT;
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2517: IF FND_MSG_PUB.Check_Msg_Level
2518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg(
2520: G_PKG_NAME,
2521: l_api_name);
2522: END IF;

Line 2519: FND_MSG_PUB.Add_Exc_Msg(

2515: ROLLBACK TO Create_Element_PVT;
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2517: IF FND_MSG_PUB.Check_Msg_Level
2518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2519: FND_MSG_PUB.Add_Exc_Msg(
2520: G_PKG_NAME,
2521: l_api_name);
2522: END IF;
2523: FND_MSG_PUB.Count_And_Get(

Line 2523: FND_MSG_PUB.Count_And_Get(

2519: FND_MSG_PUB.Add_Exc_Msg(
2520: G_PKG_NAME,
2521: l_api_name);
2522: END IF;
2523: FND_MSG_PUB.Count_And_Get(
2524: p_count => x_msg_count,
2525: p_data => x_msg_data);
2526: end Create_Element;
2527:

Line 2566: FND_MSG_PUB.initialize;

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

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

2570:
2571: -- -- -- -- begin my code -- -- -- -- --
2572: -- Check params
2573: if(p_set_id is null) then
2574: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2575: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2576: fnd_msg_pub.Add;
2577: end if;
2578: raise FND_API.G_EXC_ERROR; --goto error_found;

Line 2576: fnd_msg_pub.Add;

2572: -- Check params
2573: if(p_set_id is null) then
2574: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
2575: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
2576: fnd_msg_pub.Add;
2577: end if;
2578: raise FND_API.G_EXC_ERROR; --goto error_found;
2579: end if;
2580:

Line 2618: FND_MSG_PUB.Count_And_Get(

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

Line 2626: FND_MSG_PUB.Count_And_Get(

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

Line 2632: FND_MSG_PUB.Count_And_Get(

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

Line 2638: IF FND_MSG_PUB.Check_Msg_Level

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

Line 2639: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2635: WHEN OTHERS THEN
2636: ROLLBACK TO Incr_Set_Useful_PVT;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2638: IF FND_MSG_PUB.Check_Msg_Level
2639: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg(
2641: G_PKG_NAME,
2642: l_api_name);
2643: END IF;

Line 2640: FND_MSG_PUB.Add_Exc_Msg(

2636: ROLLBACK TO Incr_Set_Useful_PVT;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2638: IF FND_MSG_PUB.Check_Msg_Level
2639: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2640: FND_MSG_PUB.Add_Exc_Msg(
2641: G_PKG_NAME,
2642: l_api_name);
2643: END IF;
2644: FND_MSG_PUB.Count_And_Get(

Line 2644: FND_MSG_PUB.Count_And_Get(

2640: FND_MSG_PUB.Add_Exc_Msg(
2641: G_PKG_NAME,
2642: l_api_name);
2643: END IF;
2644: FND_MSG_PUB.Count_And_Get(
2645: p_count => x_msg_count,
2646: p_data => x_msg_data);
2647: end Incr_Set_Useful;
2648:

Line 3869: FND_MSG_PUB.initialize;

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

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

3886: end if;
3887:
3888:
3889: if l_sql_contains is null then
3890: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
3891: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
3892: fnd_msg_pub.Add;
3893: end if;
3894: raise FND_API.G_EXC_ERROR; --goto error_found;

Line 3892: fnd_msg_pub.Add;

3888:
3889: if l_sql_contains is null then
3890: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
3891: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
3892: fnd_msg_pub.Add;
3893: end if;
3894: raise FND_API.G_EXC_ERROR; --goto error_found;
3895: end if;
3896:

Line 3934: FND_MSG_PUB.Count_And_Get(

3930: end if;
3931: -- -- -- -- end of code -- -- --
3932:
3933: -- Standard call to get message count. if count=1, get message info.
3934: FND_MSG_PUB.Count_And_Get(
3935: p_count => x_msg_count,
3936: p_data => x_msg_data );
3937:
3938: EXCEPTION

Line 3942: FND_MSG_PUB.Count_And_Get(

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

Line 3948: FND_MSG_PUB.Count_And_Get(

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

Line 3985: IF FND_MSG_PUB.Check_Msg_Level

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

Line 3986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3982: else
3983: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3985: IF FND_MSG_PUB.Check_Msg_Level
3986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3987: FND_MSG_PUB.Add_Exc_Msg(
3988: G_PKG_NAME,
3989: l_api_name);
3990: END IF;

Line 3987: FND_MSG_PUB.Add_Exc_Msg(

3983: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3985: IF FND_MSG_PUB.Check_Msg_Level
3986: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3987: FND_MSG_PUB.Add_Exc_Msg(
3988: G_PKG_NAME,
3989: l_api_name);
3990: END IF;
3991: FND_MSG_PUB.Count_And_Get(

Line 3991: FND_MSG_PUB.Count_And_Get(

3987: FND_MSG_PUB.Add_Exc_Msg(
3988: G_PKG_NAME,
3989: l_api_name);
3990: END IF;
3991: FND_MSG_PUB.Count_And_Get(
3992: p_count => x_msg_count,
3993: p_data => x_msg_data);
3994: end if;
3995:

Line 4075: FND_MSG_PUB.initialize;

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

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

4088: l_sql_contains := p_pos_query_str;
4089: end if;
4090:
4091: if l_sql_contains is null then
4092: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
4093: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
4094: fnd_msg_pub.Add;
4095: end if;
4096: raise FND_API.G_EXC_ERROR; --goto error_found;

Line 4094: fnd_msg_pub.Add;

4090:
4091: if l_sql_contains is null then
4092: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
4093: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');
4094: fnd_msg_pub.Add;
4095: end if;
4096: raise FND_API.G_EXC_ERROR; --goto error_found;
4097: end if;
4098:

Line 4135: FND_MSG_PUB.Count_And_Get(

4131: end if;
4132: -- -- -- -- end of code -- -- --
4133:
4134: -- Standard call to get message count. if count=1, get message info.
4135: FND_MSG_PUB.Count_And_Get(
4136: p_count => x_msg_count,
4137: p_data => x_msg_data );
4138:
4139: EXCEPTION

Line 4143: FND_MSG_PUB.Count_And_Get(

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

Line 4150: FND_MSG_PUB.Count_And_Get(

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

Line 4188: IF FND_MSG_PUB.Check_Msg_Level

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

Line 4189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4185: else
4186: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
4187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4188: IF FND_MSG_PUB.Check_Msg_Level
4189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4190: FND_MSG_PUB.Add_Exc_Msg(
4191: G_PKG_NAME,
4192: l_api_name);
4193: END IF;

Line 4190: FND_MSG_PUB.Add_Exc_Msg(

4186: --no data to rollback in query api ROLLBACK TO Find_Sets_Matching_PVT;
4187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4188: IF FND_MSG_PUB.Check_Msg_Level
4189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4190: FND_MSG_PUB.Add_Exc_Msg(
4191: G_PKG_NAME,
4192: l_api_name);
4193: END IF;
4194: FND_MSG_PUB.Count_And_Get(

Line 4194: FND_MSG_PUB.Count_And_Get(

4190: FND_MSG_PUB.Add_Exc_Msg(
4191: G_PKG_NAME,
4192: l_api_name);
4193: END IF;
4194: FND_MSG_PUB.Count_And_Get(
4195: p_count => x_msg_count,
4196: p_data => x_msg_data);
4197: end if;
4198: