[Home] [Help]
5808: AND p_Terr_All_Rec.PARENT_TERRITORY_ID IS NOT NULL THEN
5809:
5810: Select count(*) INTO l_ter_name_count
5811: FROM JTF_TERR_ALL childterr,
5812: HR_OPERATING_UNITS hr,
5813: JTF_TERR_ALL parentterr
5814: WHERE childterr.org_id = hr.organization_id
5815: AND childterr.parent_territory_id = parentTerr.terr_id
5816: AND childterr.org_id = parentTerr.org_id
6150: AND l_parent_territory_id IS NOT NULL THEN
6151:
6152: Select count(*) INTO l_ter_name_count
6153: FROM JTF_TERR_ALL childterr,
6154: HR_OPERATING_UNITS hr,
6155: JTF_TERR_ALL parentterr
6156: WHERE childterr.org_id = hr.organization_id
6157: AND childterr.parent_territory_id = parentTerr.terr_id
6158: AND childterr.org_id = parentTerr.org_id
6424: --
6425: If (p_Terr_All_Rec.ORG_ID is not null) AND
6426: (p_Terr_All_Rec.ORG_ID <> FND_API.G_MISS_NUM)
6427: then
6428: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.ORG_ID, 'ORGANIZATION_ID', 'HR_OPERATING_UNITS');
6429: If l_status <> FND_API.G_TRUE Then
6430: x_return_status := FND_API.G_RET_STS_ERROR;
6431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6432: --dbms_output('TERR TYPE: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6543:
6544:
6545:
6546: -- Check for ORG_ID
6547: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_Usgs_rec.ORG_ID, 'ORGANIZATION_ID', 'HR_OPERATING_UNITS') <> FND_API.G_TRUE THEN
6548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6549: --dbms_output('TERR TYPE: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6550: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_TERR_TYPE');
6551: FND_MESSAGE.Set_Token('ORG_ID', to_char(p_Terr_Usgs_rec.ORG_ID));