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 308: FROM jtf_terr_qual

304:
305: BEGIN
306: SELECT terr_id
307: INTO l_terr_id
308: FROM jtf_terr_qual
309: WHERE terr_qual_id = p_terr_qual_id;
310: EXCEPTION
311: WHEN NO_DATA_FOUND then
312: -- this should never happen since terr_qual_id req'd in jtf_terr_values

Line 313: -- and terr_id terr_qual_id required in jtf_terr_qual

309: WHERE terr_qual_id = p_terr_qual_id;
310: EXCEPTION
311: WHEN NO_DATA_FOUND then
312: -- this should never happen since terr_qual_id req'd in jtf_terr_values
313: -- and terr_id terr_qual_id required in jtf_terr_qual
314: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
315: RAISE;
316: WHEN OTHERS then
317: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);

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

633: ,'Y'
634: ,'N');
635:
636: WHEN OTHERS THEN
637: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Error updating the record: ' || sqlerrm);
638: RAISE;
639: END;
640:
641: EXCEPTION

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

639: END;
640:
641: EXCEPTION
642: When OTHERS then
643: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_QUAL_BIUD-Handler', 'Problems: ' || sqlerrm);
644: RAISE;
645:
646: END Terr_Qual_Trigger_Handler;
647: