APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_CTM_UTILITY_PVT

Line 3573: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then

3569: -- Validate the territory Id
3570: l_Validate_id := p_TerrRsc_Rec.Terr_Id;
3571: If l_Validate_id IS NOT NULL Then
3572: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3573: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then
3574: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3575: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3576: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3577: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

Line 3723: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then

3719: -- Validate the territory Id
3720: l_Validate_id := p_TerrRsc_Rec.Terr_Id;
3721: If l_Validate_id IS NOT NULL Then
3722: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3723: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR') <> FND_API.G_TRUE Then
3724: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3725: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3727: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

Line 3877: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC') <> FND_API.G_TRUE Then

3873: -- Validate the territory Id
3874: l_Validate_id := p_TerrRsc_Id;
3875: If l_Validate_id IS NOT NULL Then
3876: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3877: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC') <> FND_API.G_TRUE Then
3878: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3879: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3880: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3881: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');