DBA Data[Home] [Help]

APPS.JTF_TERRITORY_RESOURCE_PVT dependencies on JTF_CTM_UTILITY_PVT

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

2412: -- Validate the territory Id
2413: l_Validate_id := p_TerrRsc_Rec.Terr_Id;
2414: If l_Validate_id <> FND_API.G_MISS_NUM Then
2415: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
2416: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2417: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2419: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2420: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

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

3487: -- Validate the territory Id
3488: l_Validate_id := p_TerrRsc_Rec.Terr_Id;
3489: If l_Validate_id IS NOT NULL Then
3490: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3491: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
3492: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3493: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3494: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3495: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');

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

3726: -- Validate the territory Id
3727: l_Validate_id := p_TerrRsc_Id;
3728: If l_Validate_id IS NOT NULL Then
3729: -- --dbms_output.put_line('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
3730: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_RSC_ID', 'JTF_TERR_RSC_ALL') <> FND_API.G_TRUE Then
3731: --dbms_output.put_line('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
3732: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3733: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
3734: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_RSC');