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_PARTNER_ACCESSES_PVT

Line 872: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

868: l_res_created_flg VARCHAR2(1) ;
869: l_tap_created_flg VARCHAR2(1) ;
870: l_partner_access_id NUMBER;
871: l_VAD_partner_id NUMBER;
872: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
873:
874: l_return_status VARCHAR2(1);
875: l_msg_count NUMBER;
876: l_msg_data VARCHAR(2000);

Line 969: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

965: l_partner_access_rec.keep_flag := 'N';
966: l_partner_access_rec.created_by_tap_flag := 'Y';
967: l_partner_access_rec.access_type := 'F';
968:
969: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
970: p_api_version_number => 1.0,
971: p_init_msg_list => FND_API.G_FALSE,
972: p_commit => FND_API.G_FALSE,
973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 1105: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

1101: l_res_created_flg VARCHAR2(1) ;
1102: l_partner_access_id NUMBER;
1103: l_cm_added VARCHAR2(1) ;
1104: l_user_exists VARCHAR2(1) ;
1105: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
1106:
1107: BEGIN
1108:
1109: l_res_created_flg := 'N';

Line 1136: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

1132: l_partner_access_rec.keep_flag := 'Y';
1133: l_partner_access_rec.created_by_tap_flag := 'N';
1134: l_partner_access_rec.access_type := 'F';
1135:
1136: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
1137: p_api_version_number => 1.0,
1138: p_init_msg_list => FND_API.G_FALSE,
1139: p_commit => FND_API.G_FALSE,
1140: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2118: PV_Partner_Accesses_PVT.Delete_Partner_Accesses(

2114: END LOOP; /* FOR l_territory_rec IN l_territory_csr( l_channel_team_rec.partner_access_id) */
2115:
2116: -- Delete the Partner Access record for the given PARTNER_ACCESS_ID
2117: -- from PV_PARTNER_ACCESSES table.
2118: PV_Partner_Accesses_PVT.Delete_Partner_Accesses(
2119: p_api_version_number => 1.0,
2120: p_init_msg_list => FND_API.G_FALSE,
2121: p_commit => FND_API.G_FALSE,
2122: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2134: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Delete_Partner_Accesses');

2130: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2131: RAISE FND_API.G_EXC_ERROR;
2132: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2133: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2134: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Delete_Partner_Accesses');
2135: -- FND_MSG_PUB.Add;
2136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2137: END IF;
2138: END IF;

Line 2625: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

2621: l_vad_prtnr_access_id_tbl prtnr_aces_tbl_type;
2622: l_partner_id NUMBER;
2623: i NUMBER := 0;
2624: l_partner_access_id NUMBER := 0;
2625: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
2626: l_resource_cnt NUMBER := 0;
2627: l_cm_added VARCHAR2(1) := 'N' ;
2628: l_res_created_flg VARCHAR2(1) := 'N' ;
2629: l_login_user_id NUMBER;

Line 2812: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

2808: IF (check_channel_team_exist(
2809: p_partner_id => l_partner_id) = 'N') THEN
2810:
2811:
2812: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
2813: p_api_version_number => 1.0,
2814: p_init_msg_list => FND_API.G_FALSE,
2815: p_commit => FND_API.G_FALSE,
2816: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 2828: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');

2824: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2825: RAISE FND_API.G_EXC_ERROR;
2826: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2827: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2828: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');
2829: FND_MSG_PUB.Add;
2830: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2831: END IF;
2832: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 3542: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

3538: l_partner_qualifier_rec partner_qualifiers_rec_type ;
3539: l_partner_exist VARCHAR2(1) := 'N';
3540: l_territory_exist VARCHAR2(1) := 'N';
3541: l_partner_access_id NUMBER := 0;
3542: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
3543: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3544: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
3545: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
3546: l_resource_cnt NUMBER := 0;

Line 3914: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

3910: p_partner_id => l_partner_id
3911: ,p_resource_id => l_partner_access_rec.resource_id ) = 'N') THEN
3912:
3913:
3914: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
3915: p_api_version_number => 1.0,
3916: p_init_msg_list => FND_API.G_FALSE,
3917: p_commit => FND_API.G_FALSE,
3918: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3930: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');

3926: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3927: RAISE FND_API.G_EXC_ERROR;
3928: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3929: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3930: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');
3931: FND_MSG_PUB.Add;
3932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3933: END IF;
3934: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 4108: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;

4104: l_partner_qualifier_rec partner_qualifiers_rec_type ;
4105: l_partner_exist VARCHAR2(1) := 'N';
4106: l_territory_exist VARCHAR2(1) := 'N';
4107: l_partner_access_id NUMBER := 0;
4108: l_partner_access_rec PV_Partner_Accesses_PVT.partner_access_rec_type;
4109: l_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4110: l_ind_winners_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
4111: l_territory_access_rec PV_TAP_ACCESS_TERRS_PVT.TAP_ACCESS_TERRS_REC_TYPE ;
4112: l_resource_cnt NUMBER := 0;

Line 4466: PV_Partner_Accesses_PVT.Create_Partner_Accesses(

4462: p_partner_id => l_partner_id
4463: ,p_resource_id => l_partner_access_rec.resource_id ) = 'N') THEN
4464:
4465:
4466: PV_Partner_Accesses_PVT.Create_Partner_Accesses(
4467: p_api_version_number => 1.0,
4468: p_init_msg_list => FND_API.G_FALSE,
4469: p_commit => FND_API.G_FALSE,
4470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4482: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');

4478: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4479: RAISE FND_API.G_EXC_ERROR;
4480: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4481: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4482: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_Partner_Accesses_PVT.Create_Partner_Accesses');
4483: FND_MSG_PUB.Add;
4484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4485: END IF;
4486: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 4628: l_partner_access_rec PV_PARTNER_ACCESSES_PVT.partner_access_rec_type;

4624: l_vad_partner_id NUMBER;
4625: l_vad_party_id NUMBER;
4626: l_resource_id NUMBER;
4627: l_partner_access_id NUMBER;
4628: l_partner_access_rec PV_PARTNER_ACCESSES_PVT.partner_access_rec_type;
4629:
4630: -- Cursor l_party_id_csr to get the VAD Partner Org Id by supplying the
4631: -- VAD Partner id.
4632: CURSOR l_VAD_party_id_csr (cv_vad_partner_id NUMBER) IS

Line 4772: PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses(

4768: -- set the resourse_id
4769: l_partner_access_rec.resource_id := l_resource_id;
4770:
4771: -- call the API
4772: PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses(
4773: p_api_version_number => 1.0,
4774: p_init_msg_list => FND_API.G_FALSE,
4775: p_commit => FND_API.G_FALSE,
4776: x_return_status => l_return_status,

Line 4788: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses');

4784: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4785: RAISE FND_API.G_EXC_ERROR;
4786: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4787: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4788: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_PARTNER_ACCESSES_PVT.Create_Partner_Accesses');
4789: FND_MSG_PUB.Add;
4790: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4791: END IF;
4792: END IF;