APPS.JTY_TERR_TRIGGER_HANDLERS dependencies on JTF_TERR_QUAL

Line 11: -- JTF_TERR, JTF_TERR_VALUES, JTF_TERR_RSC, JTF_TERR_RSC_ACCESS, JTF_TERR_QTYPE_USGS, JTF_TERR_QUAL

7: -- ---------------------------------------------------
8: -- PURPOSE
9: -- This package defines Territory Trigger handlers.
10: -- Trigger handler API Spec for TABLES:
11: -- JTF_TERR, JTF_TERR_VALUES, JTF_TERR_RSC, JTF_TERR_RSC_ACCESS, JTF_TERR_QTYPE_USGS, JTF_TERR_QUAL
12: --
13: -- Procedures:
14: -- (see below for specification)
15: --

Line 622: FROM jtf_terr_qual

618:
619: BEGIN
620: SELECT terr_id
621: INTO l_terr_id
622: FROM jtf_terr_qual
623: WHERE terr_qual_id = p_terr_qual_id;
624: EXCEPTION
625: WHEN NO_DATA_FOUND then
626: -- this should never happen since terr_qual_id req'd in jtf_terr_values

Line 627: -- and terr_id terr_qual_id required in jtf_terr_qual

623: WHERE terr_qual_id = p_terr_qual_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);

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: