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_TERR_QTYPE_USGS

Line 45: -- 09/09/00 jdochert Added Unique validation for JTF_TERR_USGS_ALL + JTF_TERR_QTYPE_USGS_ALL

41: -- l_terr_id NUMBER := P_TERR_ALL_REC.TERR_ID;
42: -- 08/08/00 jdochert Removing if statement that causes error when LOW_VALUE_CHAR = FND_API.G_MISS_CHAR
43: -- and ID_USED_FLAG = 'Y": this was an error in logic.
44: -- 08/21/00 jdochert Changing overlap_exists procedure to do an UPPER on comparison operator
45: -- 09/09/00 jdochert Added Unique validation for JTF_TERR_USGS_ALL + JTF_TERR_QTYPE_USGS_ALL
46: -- 09/17/00 jdochert BUG#1408610 FIX
47: --
48: -- 10/04/00 jdochert Added validation for NUM_WINNERS
49: -- 11/02/00 jdochert Added processing for NUM_QUAL

Line 609: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;

605: --Delete Territory Qualifer records
606: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
607:
608: --Delete Territory qual type usgs
609: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;
610:
611: --Delete Territory usgs
612: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;
613:

Line 2114: --dbms_output('Create_Terr_QualType_Usage PVT(REC): Before Calling JTF_TERR_QTYPE_USGS_PKG.Insert_Row');

2110: RAISE FND_API.G_EXC_ERROR;
2111: END IF;
2112:
2113: END IF;
2114: --dbms_output('Create_Terr_QualType_Usage PVT(REC): Before Calling JTF_TERR_QTYPE_USGS_PKG.Insert_Row');
2115:
2116: /* Intialise to NULL if FND_API.G_MISS_NUM,
2117: ** otherwise used passed in value
2118: */

Line 2125: JTF_TERR_QTYPE_USGS_PKG.Insert_Row(x_Rowid => l_rowid,

2121: END IF;
2122:
2123:
2124: -- Call insert terr_Qual_Type_Usgs table handler
2125: JTF_TERR_QTYPE_USGS_PKG.Insert_Row(x_Rowid => l_rowid,
2126: x_TERR_QTYPE_USG_ID => l_TERR_QUAL_TYPE_USG_ID,
2127: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
2128: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
2129: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

Line 3576: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');

3572: --dbms_output('Update_territory_Record: NO-RCORDS-FOUND');
3573: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3574: THEN
3575: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
3576: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
3577: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(p_terr_all_rec.terr_id));
3578: FND_MSG_PUB.Add;
3579: END IF;
3580: raise FND_API.G_EXC_ERROR;

Line 3780: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');

3776: --dbms_output('Update_Territory_Usages PVT: NO-RCORDS-FOUND');
3777: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3778: THEN
3779: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
3780: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
3781: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_Usgs_Rec.terr_usg_id));
3782: FND_MSG_PUB.Add;
3783: END IF;
3784: raise FND_API.G_EXC_ERROR;

Line 3997: From JTF_TERR_QTYPE_USGS_ALL

3993: CREATION_DATE,
3994: LAST_UPDATE_LOGIN,
3995: TERR_ID,
3996: QUAL_TYPE_USG_ID
3997: From JTF_TERR_QTYPE_USGS_ALL
3998: Where terr_qtype_usg_id = l_terr_qual_type_usg_id
3999: FOR Update NOWAIT;
4000: --Local variable declaration
4001: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_QualType_Usage';

Line 4059: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');

4055: --dbms_output('Update_Terr_QualType_Usage REC: NO-RCORDS-FOUND');
4056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
4057: THEN
4058: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
4059: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
4060: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID));
4061: FND_MSG_PUB.Add;
4062: END IF;
4063: raise FND_API.G_EXC_ERROR;

Line 4067: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');

4063: raise FND_API.G_EXC_ERROR;
4064: End if;
4065: CLOSE C_GetTerrQualTypeUsgs;
4066:
4067: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
4068: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
4069: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
4070: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
4071: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,

Line 4068: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,

4064: End if;
4065: CLOSE C_GetTerrQualTypeUsgs;
4066:
4067: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
4068: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
4069: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
4070: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
4071: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
4072: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

Line 5221: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');

5217:
5218: --Initialize the return status to success
5219: x_return_status := FND_API.G_RET_STS_SUCCESS;
5220:
5221: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
5222: --
5223: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
5224: --
5225: --

Line 5223: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);

5219: x_return_status := FND_API.G_RET_STS_SUCCESS;
5220:
5221: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
5222: --
5223: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
5224: --
5225: --
5226: --Prepare message name
5227: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');

Line 5237: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');

5233: END IF;
5234:
5235: --Prepare message token
5236: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
5237: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
5238: FND_MSG_PUB.ADD;
5239:
5240: -- Debug Message
5241: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

Line 5269: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');

5265: l_row_count := 0;
5266:
5267: --Prepare message token
5268: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
5269: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
5270: FND_MSG_PUB.ADD;
5271: --
5272: FND_MSG_PUB.Count_And_Get
5273: ( p_count => x_msg_count,

Line 5642: jtf_terr_qtype_usgs_ALL jtqu

5638: /* SELECT 'x'
5639: into l_Temp
5640: from jtf_qual_usgs_ALL jqu,
5641: jtf_qual_type_usgs_ALL jqtu,
5642: jtf_terr_qtype_usgs_ALL jtqu
5643: where jtqu.terr_id = p_Terr_Id and
5644: jqtu.qual_type_usg_id = jtqu.qual_type_usg_id and
5645: jqu.qual_usg_id = P_Terr_Qual_Rec.Qual_Usg_Id and
5646: jqu.enabled_flag = 'Y' and

Line 8113: from jtf_terr_qtype_usgs j1

8109: , j1.CREATION_DATE
8110: , j1.CREATED_BY
8111: , j1.LAST_UPDATE_LOGIN
8112: , j1.ORG_ID
8113: from jtf_terr_qtype_usgs j1
8114: WHERE j1.terr_id = p_template_terr_id;
8115:
8116: l_product NUMBER := 1;
8117: l_num_gen_terr NUMBER := 1;

Line 10149: -- check for Unique Key constraint violation on JTF_TERR_QTYPE_USGS table

10145:
10146: END validate_terr_usgs_UK;
10147:
10148: -- jdochert 09/09
10149: -- check for Unique Key constraint violation on JTF_TERR_QTYPE_USGS table
10150: PROCEDURE validate_terr_qtype_usgs_UK(
10151: p_Terr_Id IN NUMBER,
10152: p_Qual_Type_Usg_Id IN NUMBER,
10153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 10163: FROM JTF_TERR_QTYPE_USGS_ALL

10159: -- cursor to check that Unique Key constraint not violated
10160: CURSOR csr_chk_uk_violation ( lp_terr_id NUMBER
10161: , lp_qual_type_usg_id NUMBER) IS
10162: SELECT 'X'
10163: FROM JTF_TERR_QTYPE_USGS_ALL
10164: WHERE terr_id = lp_terr_id
10165: AND qual_type_usg_id = lp_qual_type_usg_id;
10166:
10167: l_return_csr VARCHAR2(1);

Line 10192: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_QTYPE_USGS_UK_CON');

10188:
10189: /* Debug message */
10190: --arpatel 09/18 - set message for form to pick up.
10191: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
10192: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_QTYPE_USGS_UK_CON');
10193: FND_MSG_PUB.ADD;
10194:
10195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
10196: p_data => x_msg_data);