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.PV_TERR_ASSIGN_PUB dependencies on PV_TERR_ASSIGN_PUB

Line 1: PACKAGE BODY PV_TERR_ASSIGN_PUB AS

1: PACKAGE BODY PV_TERR_ASSIGN_PUB AS
2: /* $Header: pvxpptab.pls 120.6 2006/05/04 03:19:21 rdsharma ship $ */
3:
4: -- Start of Comments
5: --

Line 7: -- PV_TERR_ASSIGN_PUB

3:
4: -- Start of Comments
5: --
6: -- NAME
7: -- PV_TERR_ASSIGN_PUB
8: --
9: -- PURPOSE
10: -- This package is a public API for manipulating Channel Team related info into
11: -- PRM. It contains specification for pl/sql records and tables and the

Line 30: g_pkg_name CONSTANT VARCHAR2(30):='PV_TERR_ASSIGN_PUB';

26: -- 07/24/03 RDSHARMA Created
27: --
28: -- End of Comments
29:
30: g_pkg_name CONSTANT VARCHAR2(30):='PV_TERR_ASSIGN_PUB';
31:
32: PROCEDURE Write_Log(p_which number, p_mssg varchar2) IS
33: BEGIN
34: FND_FILE.put(p_which, p_mssg);

Line 292: -- X_RESOURCE_REC OUT PV_TERR_ASSIGN_PUB.ResourceRec

288: -- IN :
289: -- P_RESOURCE_ID IN NUMBER,
290: -- P_RESOURCE_TYPE IN VARCHAR2,
291: -- OUT :
292: -- X_RESOURCE_REC OUT PV_TERR_ASSIGN_PUB.ResourceRec
293: --
294: -- Version :
295: -- Initial version 1.0
296: --

Line 305: X_RESOURCE_REC OUT NOCOPY PV_TERR_ASSIGN_PUB.ResourceRec

301: -- End of Comments
302: PROCEDURE GET_RES_FROM_TEAM_GROUP(
303: P_RESOURCE_ID IN NUMBER,
304: P_RESOURCE_TYPE IN VARCHAR2,
305: X_RESOURCE_REC OUT NOCOPY PV_TERR_ASSIGN_PUB.ResourceRec
306: )
307: IS
308:
309: l_resource_group_id number;

Line 1551: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;

1547: l_tap_created_flg VARCHAR2(1);
1548: l_partner_access_id NUMBER;
1549: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
1550: l_resource_cnt NUMBER ;
1551: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;
1552: l_partner_type VARCHAR2(500) ;
1553: j_index NUMBER;
1554:
1555:

Line 2291: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;

2287: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
2288: l_resource_cnt NUMBER := 0;
2289: l_cm_added VARCHAR2(1) := 'N' ;
2290: l_partner_level VARCHAR2(30);
2291: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;
2292: l_partner_access_id_tbl prtnr_aces_tbl_type;
2293: l_partner_qualifiers_tbl partner_qualifiers_tbl_type;
2294:
2295: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.

Line 2464: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.TAP_Get_Channel_Team');

2460: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2461: RAISE FND_API.G_EXC_ERROR;
2462: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2463: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2464: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.TAP_Get_Channel_Team');
2465: -- FND_MSG_PUB.Add;
2466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2467: END IF;
2468: END IF;

Line 2747: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_VAD_Channel_Team');

2743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2744: RAISE FND_API.G_EXC_ERROR;
2745: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2746: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2747: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_VAD_Channel_Team');
2748: FND_MSG_PUB.Add;
2749: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2750: END IF;
2751: END IF;

Line 2917: -- PV_TERR_ASSIGN_PUB

2913:
2914: -- Start of Comments
2915: --
2916: -- NAME
2917: -- PV_TERR_ASSIGN_PUB
2918: --
2919: -- PURPOSE
2920: -- This package is a public API to create the channel team based on the user as well
2921: -- as the pre defined qualifiers for the partner. This API inturn calls apis to create

Line 2950: -- x_prtnr_access_id_tbl OUT PV_TERR_ASSIGN_PUB.PartnerAccessRec

2946: -- OUT :
2947: -- x_return_status OUT VARCHAR2(1)
2948: -- x_msg_count OUT NUMBER
2949: -- x_msg_data OUT VARCHAR2(2000)
2950: -- x_prtnr_access_id_tbl OUT PV_TERR_ASSIGN_PUB.PartnerAccessRec
2951: --
2952: -- Version :
2953: -- Initial version 1.0
2954: --

Line 3103: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_Terr_Channel_Team');

3099: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3100: RAISE FND_API.G_EXC_ERROR;
3101: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3102: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3103: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_Terr_Channel_Team');
3104: FND_MSG_PUB.Add;
3105: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3106: END IF;
3107: END IF;

Line 3290: -- PV_TERR_ASSIGN_PUB

3286:
3287: -- Start of Comments
3288: --
3289: -- NAME
3290: -- PV_TERR_ASSIGN_PUB
3291: --
3292: -- PURPOSE
3293: -- This package is a public API to create the channel team based on the user as well
3294: -- as the pre defined qualifiers for the partner. This API will call the Do_Create_channel_team

Line 3322: -- x_prtnr_access_id_tbl OUT PV_TERR_ASSIGN_PUB.PartnerAccessRec

3318: -- OUT :
3319: -- x_return_status OUT VARCHAR2(1)
3320: -- x_msg_count OUT NUMBER
3321: -- x_msg_data OUT VARCHAR2(2000)
3322: -- x_prtnr_access_id_tbl OUT PV_TERR_ASSIGN_PUB.PartnerAccessRec
3323: --
3324: -- Version :
3325: -- Initial version 1.0
3326: --

Line 3431: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Do_Create_Channel_Team');

3427: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
3428: RAISE FND_API.G_EXC_ERROR;
3429: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3430: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3431: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Do_Create_Channel_Team');
3432: FND_MSG_PUB.Add;
3433: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3434: END IF;
3435: END IF;

Line 3552: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;

3548: l_res_created_flg VARCHAR2(1) := 'N' ;
3549: l_tap_created_flg VARCHAR2(1) := 'N' ;
3550: l_login_user_id NUMBER;
3551: l_partner_level VARCHAR2(30);
3552: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;
3553: l_partner_access_id_tbl prtnr_aces_tbl_type;
3554: l_partner_qualifiers_tbl partner_qualifiers_tbl_type;
3555:
3556: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.

Line 3793: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.TAP_Get_Channel_Team');

3789: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3790: RAISE FND_API.G_EXC_ERROR;
3791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3792: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3793: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.TAP_Get_Channel_Team');
3794: FND_MSG_PUB.Add;
3795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3796: END IF;
3797: END IF;

Line 3863: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_VAD_Channel_Team');

3859: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3860: RAISE FND_API.G_EXC_ERROR;
3861: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3862: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3863: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_VAD_Channel_Team');
3864: FND_MSG_PUB.Add;
3865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3866: END IF;
3867: END IF;

Line 4041: -- x_prtnr_access_id_tbl OUT NOCOPY PV_TERR_ASSIGN_PUB.prtnr_aces_tbl_type

4037: -- OUT :
4038: -- x_return_status OUT VARCHAR2(1)
4039: -- x_msg_count OUT NUMBER
4040: -- x_msg_data OUT VARCHAR2(2000)
4041: -- x_prtnr_access_id_tbl OUT NOCOPY PV_TERR_ASSIGN_PUB.prtnr_aces_tbl_type
4042: --
4043: -- Version :
4044: -- Initial version 1.0
4045: --

Line 4118: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;

4114: l_res_created_flg VARCHAR2(1) := 'N' ;
4115: l_tap_created_flg VARCHAR2(1) := 'N' ;
4116: l_login_user_id NUMBER;
4117: l_partner_level VARCHAR2(30);
4118: l_resource_rec PV_TERR_ASSIGN_PUB.ResourceRec;
4119: l_partner_access_id_tbl prtnr_aces_tbl_type;
4120: l_partner_qualifiers_tbl partner_qualifiers_tbl_type;
4121:
4122: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.

Line 4345: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.TAP_Get_Channel_Team');

4341: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4342: RAISE FND_API.G_EXC_ERROR;
4343: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4344: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4345: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.TAP_Get_Channel_Team');
4346: FND_MSG_PUB.Add;
4347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4348: END IF;
4349: END IF;

Line 4415: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_VAD_Channel_Team');

4411: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4412: RAISE FND_API.G_EXC_ERROR;
4413: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4414: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4415: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_VAD_Channel_Team');
4416: FND_MSG_PUB.Add;
4417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4418: END IF;
4419: END IF;

Line 5045: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_Channel_Team');

5041: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5042: RAISE FND_API.G_EXC_ERROR;
5043: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5044: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
5045: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_Channel_Team');
5046: FND_MSG_PUB.Add;
5047: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5048: END IF;
5049: END IF;

Line 5208: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Delete_Channel_Team');

5204: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5205: RAISE FND_API.G_EXC_ERROR;
5206: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5207: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
5208: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Delete_Channel_Team');
5209: FND_MSG_PUB.Add;
5210: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5211: END IF;
5212: END IF;

Line 5267: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_Terr_Channel_Team');

5263: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
5264: RAISE FND_API.G_EXC_ERROR;
5265: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5266: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
5267: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TERR_ASSIGN_PUB.Create_Terr_Channel_Team');
5268: FND_MSG_PUB.Add;
5269: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5270: END IF;
5271: END IF;

Line 6529: END PV_TERR_ASSIGN_PUB;

6525: Write_log (1, l_err_mesg);
6526:
6527: END Process_Sub_Territories;
6528:
6529: END PV_TERR_ASSIGN_PUB;