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 601: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;

597: --Delete Territory Qualifer records
598: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID = c.Terr_Id;
599:
600: --Delete Territory qual type usgs
601: DELETE from JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID = c.Terr_Id;
602:
603: --Delete Territory usgs
604: DELETE from JTF_TERR_USGS_ALL WHERE TERR_ID = c.Terr_Id;
605:

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

2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:
2012: END IF;
2013: --dbms_output('Create_Terr_QualType_Usage PVT(REC): Before Calling JTF_TERR_QTYPE_USGS_PKG.Insert_Row');
2014:
2015: /* Intialise to NULL if FND_API.G_MISS_NUM,
2016: ** otherwise used passed in value
2017: */

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

2020: END IF;
2021:
2022:
2023: -- Call insert terr_Qual_Type_Usgs table handler
2024: JTF_TERR_QTYPE_USGS_PKG.Insert_Row(x_Rowid => l_rowid,
2025: x_TERR_QTYPE_USG_ID => l_TERR_QUAL_TYPE_USG_ID,
2026: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
2027: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
2028: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

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

3199: --dbms_output('Update_territory_Record: NO-RCORDS-FOUND');
3200: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
3203: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
3204: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(p_terr_all_rec.terr_id));
3205: FND_MSG_PUB.Add;
3206: END IF;
3207: raise FND_API.G_EXC_ERROR;

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

3401: --dbms_output('Update_Territory_Usages PVT: NO-RCORDS-FOUND');
3402: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3403: THEN
3404: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
3405: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
3406: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_Usgs_Rec.terr_usg_id));
3407: FND_MSG_PUB.Add;
3408: END IF;
3409: raise FND_API.G_EXC_ERROR;

Line 3622: From JTF_TERR_QTYPE_USGS_ALL

3618: CREATION_DATE,
3619: LAST_UPDATE_LOGIN,
3620: TERR_ID,
3621: QUAL_TYPE_USG_ID
3622: From JTF_TERR_QTYPE_USGS_ALL
3623: Where terr_qtype_usg_id = l_terr_qual_type_usg_id
3624: FOR Update NOWAIT;
3625: --Local variable declaration
3626: l_api_name CONSTANT VARCHAR2(30) := 'Update_Terr_QualType_Usage';

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

3680: --dbms_output('Update_Terr_QualType_Usage REC: NO-RCORDS-FOUND');
3681: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
3682: THEN
3683: FND_MESSAGE.Set_Name('JTF', 'JTF_TERR_MISSING_UPDT_TARGET');
3684: FND_MESSAGE.Set_Token('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
3685: FND_MESSAGE.Set_Token('PK_ID', TO_CHAR(P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID));
3686: FND_MSG_PUB.Add;
3687: END IF;
3688: raise FND_API.G_EXC_ERROR;

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

3688: raise FND_API.G_EXC_ERROR;
3689: End if;
3690: CLOSE C_GetTerrQualTypeUsgs;
3691:
3692: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
3693: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3694: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
3695: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
3696: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,

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

3689: End if;
3690: CLOSE C_GetTerrQualTypeUsgs;
3691:
3692: --dbms_output('Update_Terr_QualType_Usage REC: Before Calling JTF_TERR_QTYPE_USGS_PKG.Update_Row');
3693: JTF_TERR_QTYPE_USGS_PKG.Update_Row(x_Rowid => l_rowid,
3694: x_TERR_QTYPE_USG_ID => P_Terr_QualTypeUsgs_Rec.TERR_QUAL_TYPE_USG_ID,
3695: x_LAST_UPDATED_BY => P_Terr_QualTypeUsgs_Rec.LAST_UPDATED_BY,
3696: x_LAST_UPDATE_DATE => P_Terr_QualTypeUsgs_Rec.LAST_UPDATE_DATE,
3697: x_CREATED_BY => P_Terr_QualTypeUsgs_Rec.CREATED_BY,

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

4803:
4804: --Initialize the return status to success
4805: x_return_status := FND_API.G_RET_STS_SUCCESS;
4806:
4807: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
4808: --
4809: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
4810: --
4811: --

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

4805: x_return_status := FND_API.G_RET_STS_SUCCESS;
4806:
4807: --dbms_output('Delete_Terr_QualType_Usage: Before Calling JTF_TERR_QTYPE_USGS_PKG.Delete_Row');
4808: --
4809: JTF_TERR_QTYPE_USGS_PKG.Delete_Row(x_terr_qtype_usg_id => P_Terr_Qual_Type_Usg_Id);
4810: --
4811: --
4812: --Prepare message name
4813: FND_MESSAGE.SET_NAME('JTF','JTF_TERR_RECORD_DELETED');

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

4819: END IF;
4820:
4821: --Prepare message token
4822: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
4823: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
4824: FND_MSG_PUB.ADD;
4825:
4826: -- Debug Message
4827: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)

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

4851: l_row_count := 0;
4852:
4853: --Prepare message token
4854: FND_MESSAGE.SET_TOKEN('NO_OF_REC', TO_CHAR(l_row_count));
4855: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'JTF_TERR_QTYPE_USGS');
4856: FND_MSG_PUB.ADD;
4857: --
4858: FND_MSG_PUB.Count_And_Get
4859: ( p_count => x_msg_count,

Line 5215: jtf_terr_qtype_usgs_ALL jtqu

5211: SELECT 'x'
5212: into l_Temp
5213: from jtf_qual_usgs_ALL jqu,
5214: jtf_qual_type_usgs_ALL jqtu,
5215: jtf_terr_qtype_usgs_ALL jtqu
5216: where jtqu.terr_id = p_Terr_Id and
5217: jqtu.qual_type_usg_id = jtqu.qual_type_usg_id and
5218: jqu.qual_usg_id = P_Terr_Qual_Rec.Qual_Usg_Id and
5219: jqu.enabled_flag = 'Y' and

Line 6549: from jtf_terr_qtype_usgs j1

6545: , j1.CREATION_DATE
6546: , j1.CREATED_BY
6547: , j1.LAST_UPDATE_LOGIN
6548: , j1.ORG_ID
6549: from jtf_terr_qtype_usgs j1
6550: WHERE j1.terr_id = p_template_terr_id;
6551:
6552: l_product NUMBER := 1;
6553: l_num_gen_terr NUMBER := 1;

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

8581:
8582: END validate_terr_usgs_UK;
8583:
8584: -- jdochert 09/09
8585: -- check for Unique Key constraint violation on JTF_TERR_QTYPE_USGS table
8586: PROCEDURE validate_terr_qtype_usgs_UK(
8587: p_Terr_Id IN NUMBER,
8588: p_Qual_Type_Usg_Id IN NUMBER,
8589: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 8599: FROM JTF_TERR_QTYPE_USGS_ALL

8595: -- cursor to check that Unique Key constraint not violated
8596: CURSOR csr_chk_uk_violation ( lp_terr_id NUMBER
8597: , lp_qual_type_usg_id NUMBER) IS
8598: SELECT 'X'
8599: FROM JTF_TERR_QTYPE_USGS_ALL
8600: WHERE terr_id = lp_terr_id
8601: AND qual_type_usg_id = lp_qual_type_usg_id;
8602:
8603: l_return_csr VARCHAR2(1);

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

8624:
8625: /* Debug message */
8626: --arpatel 09/18 - set message for form to pick up.
8627: --IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
8628: FND_MESSAGE.Set_Name ('JTF', 'JTF_TERR_QTYPE_USGS_UK_CON');
8629: FND_MSG_PUB.ADD;
8630:
8631: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
8632: p_data => x_msg_data);