APPS.JTF_TERR_TRIGGER_HANDLERS dependencies on JTF_TERR_QUAL

Line 365: from jtf_terr_qual where terr_qual_id = l_terr_qual_id;

361: --dbms_output.put_line('JTDT- l_terr_qual_id = ' || l_terr_qual_id);
362: --Get the territory_id for the values record
363: BEGIN
364: Select terr_id into l_terr_id
365: from jtf_terr_qual where terr_qual_id = l_terr_qual_id;
366: EXCEPTION
367: WHEN NO_DATA_FOUND then
368: --dbms_output.put_line('JTDT- No data found error with extracting terr_qual_id or terr_id: ' || sqlerrm);
369: -- this should never happen since terr_qual_id req'd in jtf_terr_values

Line 370: -- and terr_id terr_qual_id required in jtf_terr_qual

366: EXCEPTION
367: WHEN NO_DATA_FOUND then
368: --dbms_output.put_line('JTDT- No data found error with extracting terr_qual_id or terr_id: ' || sqlerrm);
369: -- this should never happen since terr_qual_id req'd in jtf_terr_values
370: -- and terr_id terr_qual_id required in jtf_terr_qual
371: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'terr_id does not exist for terr_value_id');
372: WHEN OTHERS then
373: --dbms_output.put_line('JTDT- Terr_val_trigger error with extracting terr_qual_id or terr_id: ' || sqlerrm);
374: FND_MSG_PUB.Add_Exc_Msg( 'JTF_TERR_VALUES_BIUD-Handler', 'Error while fetching terr_id from terr_value_id: ' || sqlerrm);