eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TERRITORY_PVT dependencies on JTF_CTM_UTILITY_PVT

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

2878:
2879: -- Validate the territory Id
2880: If ( P_Terr_Qual_Rec.TERR_ID IS NOT NULL )AND (P_Terr_Qual_Rec.TERR_ID = FND_API.G_MISS_NUM ) Then
2881: --dbms_output('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
2882: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(P_Terr_Qual_Rec.TERR_ID, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
2883: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
2884: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2885: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
2886: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');

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

6104:
6105: -- Validate the territory Id
6106: l_Validate_id := p_Terr_All_Rec.TERR_ID;
6107: If l_Validate_id IS NOT NULL THEN
6108: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6109: --dbms_output('Validate_Territory_Usage: l_status <> FND_API.G_TRUE');
6110: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6111: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
6112: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

Line 6365: --dbms_output('Validate_Foreign_Key: Returned from JTF_CTM_UTILITY_PVT.fk_id_is_valid');

6361: (p_Terr_All_Rec.PARENT_TERRITORY_ID <> FND_API.G_MISS_NUM)
6362: Then
6363: --
6364: l_parent_terr_id := p_Terr_All_Rec.parent_territory_Id;
6365: --dbms_output('Validate_Foreign_Key: Returned from JTF_CTM_UTILITY_PVT.fk_id_is_valid');
6366: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_parent_terr_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6368: --dbms_output('PARENT Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6369: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_PARENT_TERR');

Line 6366: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_parent_terr_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then

6362: Then
6363: --
6364: l_parent_terr_id := p_Terr_All_Rec.parent_territory_Id;
6365: --dbms_output('Validate_Foreign_Key: Returned from JTF_CTM_UTILITY_PVT.fk_id_is_valid');
6366: IF JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_parent_terr_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6367: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6368: --dbms_output('PARENT Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6369: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_PARENT_TERR');
6370: FND_MESSAGE.Set_Token('TERR_ID', to_char(l_parent_terr_id));

Line 6411: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TERRITORY_TYPE_ID, 'TERR_TYPE_ID', 'JTF_TERR_TYPES_ALL');

6407: --
6408: If (p_Terr_All_Rec.TERRITORY_TYPE_ID is not null) AND
6409: (p_Terr_All_Rec.TERRITORY_TYPE_ID <> FND_API.G_MISS_NUM)
6410: then
6411: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TERRITORY_TYPE_ID, 'TERR_TYPE_ID', 'JTF_TERR_TYPES_ALL');
6412: If l_status <> FND_API.G_TRUE Then
6413: x_return_status := FND_API.G_RET_STS_ERROR;
6414: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6415: --dbms_output('TERR TYPE: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

Line 6428: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.ORG_ID, 'ORGANIZATION_ID', 'HR_OPERATING_UNITS');

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');

Line 6445: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TEMPLATE_TERRITORY_ID, 'TERR_ID', 'JTF_TERR_ALL');

6441: --dbms_output('Validate_Foreign_Key: Checking for TEMPLATE_TERRITORY_ID');
6442: --
6443: iF (p_Terr_All_Rec.TEMPLATE_TERRITORY_ID is not null) AND
6444: (p_Terr_All_Rec.TEMPLATE_TERRITORY_ID <> FND_API.G_MISS_NUM) Then
6445: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.TEMPLATE_TERRITORY_ID, 'TERR_ID', 'JTF_TERR_ALL');
6446: if l_status <> FND_API.G_TRUE Then
6447: x_return_status := FND_API.G_RET_STS_ERROR;
6448: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6449: --dbms_output('TEMP: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

Line 6461: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.escalation_territory_id, 'TERR_ID', 'JTF_TERR_ALL');

6457: --dbms_output('Validate_Foreign_Key: Checking for ESCALATION_TERRITORY_ID');
6458: --
6459: If (p_Terr_All_Rec.ESCALATION_TERRITORY_ID is not null) AND
6460: (p_Terr_All_Rec.ESCALATION_TERRITORY_ID <> FND_API.G_MISS_NUM) Then
6461: l_status := JTF_CTM_UTILITY_PVT.fk_id_is_valid(p_Terr_All_Rec.escalation_territory_id, 'TERR_ID', 'JTF_TERR_ALL');
6462: if l_status <> FND_API.G_TRUE Then
6463: x_return_status := FND_API.G_RET_STS_ERROR;
6464: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6465: --dbms_output('ESC TERR: Validate_Foreign_Key: l_status <> FND_API.G_TRUE');

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

6515:
6516: -- Validate the territory Id
6517: If p_Terr_Id IS NOT NULL THEN
6518: l_Validate_id := p_Terr_Id;
6519: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6520: --dbms_output('Validate_Territory_Usage: l_status <> FND_API.G_TRUE');
6521: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6522: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR');
6523: FND_MESSAGE.Set_Token('COLUMN_NAME', 'TERR_ID');

Line 6533: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'SOURCE_ID', 'JTF_SOURCES_ALL') <> FND_API.G_TRUE Then

6529:
6530: -- Validate the source_id
6531: l_Validate_id := p_Terr_Usgs_rec.SOURCE_ID;
6532: -- Make sure the foreign key source_id is valid
6533: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'SOURCE_ID', 'JTF_SOURCES_ALL') <> FND_API.G_TRUE Then
6534: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6535: --dbms_output('Validate_Territory_Usage: FND_MSG_PUB.ADD');
6536: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6537: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_SOURCES');

Line 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

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));

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

6694: -- Validate the territory Id
6695: l_Validate_id := p_Terr_Id;
6696: If p_Terr_Id IS NOT NULL Then
6697: --dbms_output('Validate_Terr_Qtype_Usage: TERR_ID(' || to_char(l_Validate_id) || ')');
6698: If JTF_CTM_UTILITY_PVT.fk_id_is_valid(l_Validate_id, 'TERR_ID', 'JTF_TERR_ALL') <> FND_API.G_TRUE Then
6699: --dbms_output('Validate_Foreign_Key: l_status <> FND_API.G_TRUE');
6700: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6701: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_INVALID_FOREIGN_KEY');
6702: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_ALL');