DBA Data[Home] [Help]

APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on FND_MSG_PUB

Line 603: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Problems: ' || sqlerrm);

599: END IF; /* end IF (Trigger_Mode = 'ON-UPDATE') */
600:
601: EXCEPTION
602: When OTHERS then
603: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERRITORIES_BIUD-Handler', 'Problems: ' || sqlerrm);
604: RAISE;
605: END Territory_Trigger_Handler;
606:
607: --**************************************************************

Line 628: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');

624: EXCEPTION
625: WHEN NO_DATA_FOUND then
626: -- this should never happen since terr_qual_id req'd in jtf_terr_values
627: -- and terr_id terr_qual_id required in jtf_terr_qual
628: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
629: RAISE;
630: WHEN OTHERS then
631: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
632: RAISE;

Line 631: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);

627: -- and terr_id terr_qual_id required in jtf_terr_qual
628: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
629: RAISE;
630: WHEN OTHERS then
631: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);
632: RAISE;
633: END;
634:
635: BEGIN

Line 684: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

680: ,'N'
681: ,'N');
682:
683: WHEN OTHERS THEN
684: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
685: RAISE;
686: END;
687:
688: BEGIN

Line 727: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

723: ,'N'
724: ,'N');
725:
726: WHEN OTHERS THEN
727: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
728: RAISE;
729: END;
730:
731:

Line 734: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Problems: ' || sqlerrm);

730:
731:
732: EXCEPTION
733: When OTHERS then
734: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Problems: ' || sqlerrm);
735: RAISE;
736:
737: END Terr_Values_Trigger_Handler;
738:

Line 821: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Problems: ' || sqlerrm);

817:
818:
819: EXCEPTION
820: When OTHERS then
821: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Problems: ' || sqlerrm);
822: RAISE;
823:
824: END Terr_Rsc_Trigger_Handler;
825:

Line 888: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

884: ,'Y'
885: ,'N');
886:
887: WHEN OTHERS THEN
888: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
889: RAISE;
890: END;
891:
892: BEGIN

Line 932: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

928: ,'Y'
929: ,'N');
930:
931: WHEN OTHERS THEN
932: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
933: RAISE;
934: END;
935:
936: EXCEPTION

Line 938: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Problems: ' || sqlerrm);

934: END;
935:
936: EXCEPTION
937: When OTHERS then
938: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QTYPE_BIUD-Handler', 'Problems: ' || sqlerrm);
939: RAISE;
940:
941: END Terr_QType_Trigger_Handler;
942:

Line 962: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error getting terr_id: ' || sqlerrm);

958: from jtf_terr_rsc_all
959: where terr_rsc_id = p_terr_rsc_id;
960: EXCEPTION
961: When OTHERS then
962: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_BIUD-Handler', 'Error getting terr_id: ' || sqlerrm);
963: RAISE;
964: End;
965:
966: BEGIN

Line 1037: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Problems: ' || sqlerrm);

1033:
1034:
1035: EXCEPTION
1036: When OTHERS then
1037: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_RSC_ACCESS_BIUD-Handler', 'Problems: ' || sqlerrm);
1038: RAISE;
1039: END Terr_RscAccess_Trigger_Handler;
1040:
1041:

Line 1099: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

1095: ,'Y'
1096: ,'N');
1097:
1098: WHEN OTHERS THEN
1099: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
1100: RAISE;
1101: END;
1102:
1103: BEGIN

Line 1142: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);

1138: ,'Y'
1139: ,'N');
1140:
1141: WHEN OTHERS THEN
1142: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
1143: RAISE;
1144: END;
1145:
1146: EXCEPTION

Line 1148: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Problems: ' || sqlerrm);

1144: END;
1145:
1146: EXCEPTION
1147: When OTHERS then
1148: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Problems: ' || sqlerrm);
1149: RAISE;
1150:
1151: END Terr_Qual_Trigger_Handler;
1152:

Line 1276: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_USGS_BIUD-Handler', 'Problems: ' || sqlerrm);

1272: END IF;
1273:
1274: EXCEPTION
1275: When OTHERS then
1276: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_USGS_BIUD-Handler', 'Problems: ' || sqlerrm);
1277: RAISE;
1278:
1279: END Terr_Usgs_Trigger_Handler;
1280: