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 FND_MESSAGE

Line 1722: -- fnd_message.Set_Name('PV', 'PV_VAD_CANNOT_CREATE_VAD_PTYPE');

1718: l_resource_cnt := l_resource_cnt + 1;
1719: x_prtnr_access_id_tbl(l_resource_cnt).partner_access_id := l_partner_access_id;
1720: ELSIF (l_res_created_flg = 'E') THEN
1721: -- Raise and Error that a VAD cannot create another VAD partner_type
1722: -- fnd_message.Set_Name('PV', 'PV_VAD_CANNOT_CREATE_VAD_PTYPE');
1723: -- fnd_msg_pub.Add;
1724: RAISE FND_API.G_EXC_ERROR;
1725: END IF; /* l_resource_create_flg = 'E' */
1726: ELSE

Line 1932: fnd_message.Set_Name('PV', 'PV_API_NO_PARTNER_PARTY_ID');

1928: END LOOP;
1929: CLOSE l_partner_details_csr;
1930:
1931: IF ( rec_index = 0 ) THEN
1932: fnd_message.Set_Name('PV', 'PV_API_NO_PARTNER_PARTY_ID');
1933: fnd_msg_pub.Add;
1934: RAISE FND_API.G_EXC_ERROR;
1935: END IF;
1936:

Line 2107: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2103: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2104: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2105: RAISE FND_API.G_EXC_ERROR;
2106: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2107: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2108: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs');
2109: -- FND_MSG_PUB.Add;
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;

Line 2108: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs');

2104: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2105: RAISE FND_API.G_EXC_ERROR;
2106: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2107: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2108: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_TAP_ACCESS_TERRS_PVT.Delete_Tap_Access_Terrs');
2109: -- FND_MSG_PUB.Add;
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111: END IF;
2112: END IF;

Line 2133: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2129: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 2352: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

2348: -- Validate Environment
2349: -- =========================================================================
2350:
2351: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
2352: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
2353: fnd_message.set_token('FIELD', 'PARTNER_ID');
2354: fnd_msg_pub.Add;
2355: RAISE FND_API.G_EXC_ERROR;
2356: ELSE

Line 2353: fnd_message.set_token('FIELD', 'PARTNER_ID');

2349: -- =========================================================================
2350:
2351: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
2352: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
2353: fnd_message.set_token('FIELD', 'PARTNER_ID');
2354: fnd_msg_pub.Add;
2355: RAISE FND_API.G_EXC_ERROR;
2356: ELSE
2357: l_partner_id := p_partner_id;

Line 2374: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

2370: FETCH l_party_id_csr INTO l_partner_party_id, l_partner_level;
2371: IF l_party_id_csr%NOTFOUND THEN
2372: CLOSE l_party_id_csr;
2373: -- Raise an error saying partner is not active
2374: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
2375: fnd_msg_pub.Add;
2376: RAISE FND_API.G_EXC_ERROR;
2377: ELSE
2378: CLOSE l_party_id_csr;

Line 2463: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2459: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 2667: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

2663: -- Validate Environment
2664: -- =========================================================================
2665:
2666: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
2667: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
2668: fnd_message.set_token('FIELD', 'PARTNER_ID');
2669: fnd_msg_pub.Add;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE

Line 2668: fnd_message.set_token('FIELD', 'PARTNER_ID');

2664: -- =========================================================================
2665:
2666: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
2667: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
2668: fnd_message.set_token('FIELD', 'PARTNER_ID');
2669: fnd_msg_pub.Add;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSE
2672: l_partner_id := p_partner_id;

Line 2702: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2698: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2700: RAISE FND_API.G_EXC_ERROR;
2701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2702: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2703: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');
2704: -- FND_MSG_PUB.Add;
2705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2706: END IF;

Line 2703: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');

2699: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2700: RAISE FND_API.G_EXC_ERROR;
2701: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2702: -- FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2703: -- FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');
2704: -- FND_MSG_PUB.Add;
2705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2706: END IF;
2707: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 2746: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2742: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 2792: FND_MESSAGE.SET_NAME('PV', 'PV_NO_DEFAULT_CMM');

2788: FETCH l_get_default_cm_csr INTO l_def_cm;
2789: CLOSE l_get_default_cm_csr;
2790:
2791: IF (l_def_cm = 0 ) THEN
2792: FND_MESSAGE.SET_NAME('PV', 'PV_NO_DEFAULT_CMM');
2793: FND_MSG_PUB.Add;
2794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2795: END IF;
2796: -- Set the p_partner_access_rec record

Line 2827: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

2823: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 3039: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

3035: -- =========================================================================
3036:
3037: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num
3038: THEN
3039: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
3040: fnd_message.set_token('FIELD', 'PARTNER_ID');
3041: fnd_msg_pub.Add;
3042: RAISE FND_API.G_EXC_ERROR;
3043: ELSE

Line 3040: fnd_message.set_token('FIELD', 'PARTNER_ID');

3036:
3037: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num
3038: THEN
3039: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
3040: fnd_message.set_token('FIELD', 'PARTNER_ID');
3041: fnd_msg_pub.Add;
3042: RAISE FND_API.G_EXC_ERROR;
3043: ELSE
3044: l_partner_id := p_partner_id;

Line 3102: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3098: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 3146: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3142: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3147: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');
3148: FND_MSG_PUB.Add;
3149: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3150: END IF;

Line 3147: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');

3143: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3144: RAISE FND_API.G_EXC_ERROR;
3145: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3146: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3147: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');
3148: FND_MSG_PUB.Add;
3149: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3150: END IF;
3151: END IF;

Line 3175: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3171:
3172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3173: RAISE FND_API.G_EXC_ERROR;
3174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3175: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3176: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
3177: FND_MSG_PUB.Add;
3178: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;

Line 3176: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

3172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3173: RAISE FND_API.G_EXC_ERROR;
3174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3175: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3176: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
3177: FND_MSG_PUB.Add;
3178: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3179: END IF;
3180: END IF;

Line 3205: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3201:
3202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3205: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3206: FND_MESSAGE.SET_TOKEN('API_NAME', 'Create_User_Channel_Team');
3207: FND_MSG_PUB.Add;
3208: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: END IF;

Line 3206: FND_MESSAGE.SET_TOKEN('API_NAME', 'Create_User_Channel_Team');

3202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3205: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3206: FND_MESSAGE.SET_TOKEN('API_NAME', 'Create_User_Channel_Team');
3207: FND_MSG_PUB.Add;
3208: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: END IF;
3210:

Line 3388: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

3384: FETCH l_party_id_csr INTO l_partner_party_id, l_partner_level;
3385: IF l_party_id_csr%NOTFOUND THEN
3386: CLOSE l_party_id_csr;
3387: -- Raise an error saying partner is not active
3388: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
3389: fnd_msg_pub.Add;
3390: RAISE FND_API.G_EXC_ERROR;
3391: ELSE
3392: CLOSE l_party_id_csr;

Line 3430: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3426: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 3619: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

3615: -- Validate Environment
3616: -- =========================================================================
3617:
3618: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
3619: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
3620: fnd_message.set_token('FIELD', 'PARTNER_ID');
3621: fnd_msg_pub.Add;
3622: RAISE FND_API.G_EXC_ERROR;
3623: ELSE

Line 3620: fnd_message.set_token('FIELD', 'PARTNER_ID');

3616: -- =========================================================================
3617:
3618: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
3619: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
3620: fnd_message.set_token('FIELD', 'PARTNER_ID');
3621: fnd_msg_pub.Add;
3622: RAISE FND_API.G_EXC_ERROR;
3623: ELSE
3624: l_partner_id := p_partner_id;

Line 3654: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3650: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3652: RAISE FND_API.G_EXC_ERROR;
3653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3654: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3655: FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');
3656: FND_MSG_PUB.Add;
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: END IF;

Line 3655: FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');

3651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3652: RAISE FND_API.G_EXC_ERROR;
3653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3654: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3655: FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');
3656: FND_MSG_PUB.Add;
3657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3658: END IF;
3659: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 3680: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

3676: FETCH l_party_id_csr INTO l_partner_party_id, l_partner_level;
3677: IF l_party_id_csr%NOTFOUND THEN
3678: CLOSE l_party_id_csr;
3679: -- Raise an error saying partner is not active
3680: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
3681: fnd_msg_pub.Add;
3682: RAISE FND_API.G_EXC_ERROR;
3683: ELSE
3684: CLOSE l_party_id_csr;

Line 3709: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3707: RAISE FND_API.G_EXC_ERROR;
3708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3709: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3710: FND_MESSAGE.SET_TOKEN('API_NAME', 'get_partner_details');
3711: FND_MSG_PUB.Add;
3712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3713: END IF;

Line 3710: FND_MESSAGE.SET_TOKEN('API_NAME', 'get_partner_details');

3706: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3707: RAISE FND_API.G_EXC_ERROR;
3708: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3709: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
3710: FND_MESSAGE.SET_TOKEN('API_NAME', 'get_partner_details');
3711: FND_MSG_PUB.Add;
3712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3713: END IF;
3714: END IF;

Line 3792: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3788: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 3862: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 3929: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

3925: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 4179: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

4175: -- Validate Environment
4176: -- =========================================================================
4177:
4178: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
4179: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4180: fnd_message.set_token('FIELD', 'PARTNER_ID');
4181: fnd_msg_pub.Add;
4182: RAISE FND_API.G_EXC_ERROR;
4183: ELSE

Line 4180: fnd_message.set_token('FIELD', 'PARTNER_ID');

4176: -- =========================================================================
4177:
4178: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
4179: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4180: fnd_message.set_token('FIELD', 'PARTNER_ID');
4181: fnd_msg_pub.Add;
4182: RAISE FND_API.G_EXC_ERROR;
4183: ELSE
4184: l_partner_id := p_partner_id;

Line 4214: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

4210: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4212: RAISE FND_API.G_EXC_ERROR;
4213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4214: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4215: FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');
4216: FND_MSG_PUB.Add;
4217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4218: END IF;

Line 4215: FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');

4211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4212: RAISE FND_API.G_EXC_ERROR;
4213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4214: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4215: FND_MESSAGE.SET_TOKEN('API_NAME', 'Cr_Login_User_Access_Rec');
4216: FND_MSG_PUB.Add;
4217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4218: END IF;
4219: END IF; -- l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 4240: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

4236: FETCH l_party_id_csr INTO l_partner_party_id, l_partner_level;
4237: IF l_party_id_csr%NOTFOUND THEN
4238: CLOSE l_party_id_csr;
4239: -- Raise an error saying partner is not active
4240: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
4241: fnd_msg_pub.Add;
4242: RAISE FND_API.G_EXC_ERROR;
4243: ELSE
4244: CLOSE l_party_id_csr;

Line 4267: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

4263: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4264: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4265: RAISE FND_API.G_EXC_ERROR;
4266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4267: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4268: FND_MESSAGE.SET_TOKEN('API_NAME', 'get_partner_details');
4269: FND_MSG_PUB.Add;
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: END IF;

Line 4268: FND_MESSAGE.SET_TOKEN('API_NAME', 'get_partner_details');

4264: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4265: RAISE FND_API.G_EXC_ERROR;
4266: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4267: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
4268: FND_MESSAGE.SET_TOKEN('API_NAME', 'get_partner_details');
4269: FND_MSG_PUB.Add;
4270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4271: END IF;
4272: END IF;

Line 4344: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

4340: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 4414: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

4410: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 4481: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

4477: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 4715: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

4711: -- Validate Environment
4712: -- =========================================================================
4713:
4714: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
4715: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4716: fnd_message.set_token('FIELD', 'PARTNER_ID');
4717: fnd_msg_pub.Add;
4718: RAISE FND_API.G_EXC_ERROR;
4719: ELSE

Line 4716: fnd_message.set_token('FIELD', 'PARTNER_ID');

4712: -- =========================================================================
4713:
4714: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
4715: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4716: fnd_message.set_token('FIELD', 'PARTNER_ID');
4717: fnd_msg_pub.Add;
4718: RAISE FND_API.G_EXC_ERROR;
4719: ELSE
4720: l_partner_id := p_partner_id;

Line 4725: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

4721: END IF;
4722:
4723: -- Initialize the l_vad_partner_id.
4724: IF p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num THEN
4725: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4726: fnd_message.set_token('FIELD', 'VAD_PARTNER_ID');
4727: fnd_msg_pub.Add;
4728: RAISE FND_API.G_EXC_ERROR;
4729: ELSE

Line 4726: fnd_message.set_token('FIELD', 'VAD_PARTNER_ID');

4722:
4723: -- Initialize the l_vad_partner_id.
4724: IF p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num THEN
4725: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4726: fnd_message.set_token('FIELD', 'VAD_PARTNER_ID');
4727: fnd_msg_pub.Add;
4728: RAISE FND_API.G_EXC_ERROR;
4729: ELSE
4730: l_vad_partner_id := p_vad_partner_id;

Line 4740: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

4736:
4737: IF ( l_VAD_party_id_csr%NOTFOUND ) THEN
4738: CLOSE l_VAD_party_id_csr;
4739: -- Raise an error ;
4740: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
4741: fnd_msg_pub.Add;
4742: RAISE FND_API.G_EXC_ERROR;
4743: ELSE
4744: CLOSE l_VAD_party_id_csr;

Line 4787: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

4783: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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;

Line 4993: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');

4989: PVX_Utility_PVT.debug_message('Validating the supplied partner Id.');
4990: END IF;
4991:
4992: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
4993: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4994: fnd_message.set_token('FIELD', 'PARTNER_ID');
4995: fnd_msg_pub.Add;
4996: RAISE FND_API.G_EXC_ERROR;
4997: ELSE

Line 4994: fnd_message.set_token('FIELD', 'PARTNER_ID');

4990: END IF;
4991:
4992: IF p_partner_id IS NULL OR p_partner_id = FND_API.g_miss_num THEN
4993: fnd_message.Set_Name('PV', 'PV_REQUIRED_VALIDATION');
4994: fnd_message.set_token('FIELD', 'PARTNER_ID');
4995: fnd_msg_pub.Add;
4996: RAISE FND_API.G_EXC_ERROR;
4997: ELSE
4998: l_partner_id := p_partner_id;

Line 5015: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

5011: FETCH l_party_id_csr INTO l_partner_party_id, l_partner_level;
5012: IF l_party_id_csr%NOTFOUND THEN
5013: CLOSE l_party_id_csr;
5014: -- Raise an error saying partner is not active
5015: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
5016: fnd_msg_pub.Add;
5017: RAISE FND_API.G_EXC_ERROR;
5018: ELSE
5019: CLOSE l_party_id_csr;

Line 5044: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

5040: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 5207: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

5203: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 5222: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');

5218: FETCH l_party_id_csr INTO l_partner_party_id, l_partner_level;
5219: IF l_party_id_csr%NOTFOUND THEN
5220: CLOSE l_party_id_csr;
5221: -- Raise an error saying partner is not active
5222: fnd_message.Set_Name('PV', 'PV_PARTNER_NOT_ACTIVE');
5223: fnd_msg_pub.Add;
5224: RAISE FND_API.G_EXC_ERROR;
5225: ELSE
5226: CLOSE l_party_id_csr;

Line 5266: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

5262: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
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;

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 5293: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

5289:
5290: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5291: RAISE FND_API.G_EXC_ERROR;
5292: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5293: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
5294: FND_MESSAGE.SET_TOKEN('API_NAME', 'Create_User_Channel_Team');
5295: FND_MSG_PUB.Add;
5296: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5297: END IF;

Line 5294: FND_MESSAGE.SET_TOKEN('API_NAME', 'Create_User_Channel_Team');

5290: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
5291: RAISE FND_API.G_EXC_ERROR;
5292: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5293: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
5294: FND_MESSAGE.SET_TOKEN('API_NAME', 'Create_User_Channel_Team');
5295: FND_MSG_PUB.Add;
5296: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5297: END IF;
5298:

Line 5493: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');

5489:
5490: -- RETCODE := FND_API.G_RET_STS_SUCCESS;
5491:
5492: -- Header Message for Processing starts
5493: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');
5494: fnd_message.set_token( 'P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5495: Write_log (1, substrb(fnd_message.get, 1, 1000));
5496:
5497: rec_index := 0;

Line 5494: fnd_message.set_token( 'P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

5490: -- RETCODE := FND_API.G_RET_STS_SUCCESS;
5491:
5492: -- Header Message for Processing starts
5493: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');
5494: fnd_message.set_token( 'P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5495: Write_log (1, substrb(fnd_message.get, 1, 1000));
5496:
5497: rec_index := 0;
5498: IF ( l_mode = 'TOTAL' ) THEN

Line 5495: Write_log (1, substrb(fnd_message.get, 1, 1000));

5491:
5492: -- Header Message for Processing starts
5493: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');
5494: fnd_message.set_token( 'P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5495: Write_log (1, substrb(fnd_message.get, 1, 1000));
5496:
5497: rec_index := 0;
5498: IF ( l_mode = 'TOTAL' ) THEN
5499: FOR l_profile_partner_rec IN l_profile_partners_csr(l_first_partner_id, l_last_partner_id)

Line 5663: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');

5659:
5660: COMMIT;
5661:
5662: -- Debug statement for each partner_id
5663: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
5664: ---New
5665: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5666: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5667: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

Line 5665: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

5661:
5662: -- Debug statement for each partner_id
5663: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
5664: ---New
5665: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5666: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5667: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5668: Write_log (1, substrb(fnd_message.get, 1, 255));
5669:

Line 5666: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

5662: -- Debug statement for each partner_id
5663: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
5664: ---New
5665: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5666: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5667: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5668: Write_log (1, substrb(fnd_message.get, 1, 255));
5669:
5670: EXCEPTION

Line 5667: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

5663: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
5664: ---New
5665: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5666: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5667: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5668: Write_log (1, substrb(fnd_message.get, 1, 255));
5669:
5670: EXCEPTION
5671: WHEN FND_API.G_EXC_ERROR THEN

Line 5668: Write_log (1, substrb(fnd_message.get, 1, 255));

5664: ---New
5665: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5666: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5667: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5668: Write_log (1, substrb(fnd_message.get, 1, 255));
5669:
5670: EXCEPTION
5671: WHEN FND_API.G_EXC_ERROR THEN
5672: FND_MSG_PUB.count_and_get (

Line 5680: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

5676: );
5677: --new
5678: -- RETCODE := FND_API.G_RET_STS_ERROR;
5679: l_partner_err_cnt := l_partner_err_cnt +1;
5680: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5681: l_msg_data := substr(apps.fnd_message.get,1,254);
5682:
5683: -- Debug statement for each partner_id
5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

Line 5681: l_msg_data := substr(apps.fnd_message.get,1,254);

5677: --new
5678: -- RETCODE := FND_API.G_RET_STS_ERROR;
5679: l_partner_err_cnt := l_partner_err_cnt +1;
5680: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5681: l_msg_data := substr(apps.fnd_message.get,1,254);
5682:
5683: -- Debug statement for each partner_id
5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5685: --new

Line 5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

5680: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5681: l_msg_data := substr(apps.fnd_message.get,1,254);
5682:
5683: -- Debug statement for each partner_id
5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5685: --new
5686: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

Line 5686: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

5682:
5683: -- Debug statement for each partner_id
5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5685: --new
5686: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5689:
5690: fnd_message.set_token('ERROR', l_msg_data);

Line 5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

5683: -- Debug statement for each partner_id
5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5685: --new
5686: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5689:
5690: fnd_message.set_token('ERROR', l_msg_data);
5691: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

5684: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5685: --new
5686: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5689:
5690: fnd_message.set_token('ERROR', l_msg_data);
5691: Write_log (1, substrb(fnd_message.get, 1, 255));
5692: ROLLBACK TO Process_Partner_Channel_Team;

Line 5690: fnd_message.set_token('ERROR', l_msg_data);

5686: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5689:
5690: fnd_message.set_token('ERROR', l_msg_data);
5691: Write_log (1, substrb(fnd_message.get, 1, 255));
5692: ROLLBACK TO Process_Partner_Channel_Team;
5693: fnd_msg_pub.Delete_Msg;
5694:

Line 5691: Write_log (1, substrb(fnd_message.get, 1, 255));

5687: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5688: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5689:
5690: fnd_message.set_token('ERROR', l_msg_data);
5691: Write_log (1, substrb(fnd_message.get, 1, 255));
5692: ROLLBACK TO Process_Partner_Channel_Team;
5693: fnd_msg_pub.Delete_Msg;
5694:
5695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5704: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

5700: );
5701: --new
5702: -- RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
5703: l_partner_err_cnt := l_partner_err_cnt +1;
5704: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5705: l_msg_data := substr(apps.fnd_message.get,1,254);
5706:
5707: -- Debug statement for each partner_id
5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

Line 5705: l_msg_data := substr(apps.fnd_message.get,1,254);

5701: --new
5702: -- RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
5703: l_partner_err_cnt := l_partner_err_cnt +1;
5704: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5705: l_msg_data := substr(apps.fnd_message.get,1,254);
5706:
5707: -- Debug statement for each partner_id
5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5709: --new

Line 5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

5704: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5705: l_msg_data := substr(apps.fnd_message.get,1,254);
5706:
5707: -- Debug statement for each partner_id
5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5709: --new
5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

Line 5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

5706:
5707: -- Debug statement for each partner_id
5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5709: --new
5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5713: fnd_message.set_token('ERROR', l_msg_data);
5714: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

5707: -- Debug statement for each partner_id
5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5709: --new
5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5713: fnd_message.set_token('ERROR', l_msg_data);
5714: Write_log (1, substrb(fnd_message.get, 1, 255));
5715: ROLLBACK TO Process_Partner_Channel_Team;

Line 5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

5708: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5709: --new
5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5713: fnd_message.set_token('ERROR', l_msg_data);
5714: Write_log (1, substrb(fnd_message.get, 1, 255));
5715: ROLLBACK TO Process_Partner_Channel_Team;
5716: fnd_msg_pub.Delete_Msg;

Line 5713: fnd_message.set_token('ERROR', l_msg_data);

5709: --new
5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5713: fnd_message.set_token('ERROR', l_msg_data);
5714: Write_log (1, substrb(fnd_message.get, 1, 255));
5715: ROLLBACK TO Process_Partner_Channel_Team;
5716: fnd_msg_pub.Delete_Msg;
5717:

Line 5714: Write_log (1, substrb(fnd_message.get, 1, 255));

5710: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5711: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5712: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5713: fnd_message.set_token('ERROR', l_msg_data);
5714: Write_log (1, substrb(fnd_message.get, 1, 255));
5715: ROLLBACK TO Process_Partner_Channel_Team;
5716: fnd_msg_pub.Delete_Msg;
5717:
5718: WHEN OTHERS THEN

Line 5727: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

5723: );
5724:
5725: -- RETCODE := '2';
5726: l_partner_err_cnt := l_partner_err_cnt +1;
5727: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5728: l_msg_data := substr(apps.fnd_message.get,1,254);
5729:
5730: -- Debug statement for each partner_id
5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

Line 5728: l_msg_data := substr(apps.fnd_message.get,1,254);

5724:
5725: -- RETCODE := '2';
5726: l_partner_err_cnt := l_partner_err_cnt +1;
5727: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5728: l_msg_data := substr(apps.fnd_message.get,1,254);
5729:
5730: -- Debug statement for each partner_id
5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5732: --new

Line 5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

5727: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
5728: l_msg_data := substr(apps.fnd_message.get,1,254);
5729:
5730: -- Debug statement for each partner_id
5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5732: --new
5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

Line 5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

5729:
5730: -- Debug statement for each partner_id
5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5732: --new
5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5736: fnd_message.set_token('ERROR', l_msg_data);
5737: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

5730: -- Debug statement for each partner_id
5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5732: --new
5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5736: fnd_message.set_token('ERROR', l_msg_data);
5737: Write_log (1, substrb(fnd_message.get, 1, 255));
5738: ROLLBACK TO Process_Partner_Channel_Team;

Line 5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

5731: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
5732: --new
5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5736: fnd_message.set_token('ERROR', l_msg_data);
5737: Write_log (1, substrb(fnd_message.get, 1, 255));
5738: ROLLBACK TO Process_Partner_Channel_Team;
5739: fnd_msg_pub.Delete_Msg;

Line 5736: fnd_message.set_token('ERROR', l_msg_data);

5732: --new
5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5736: fnd_message.set_token('ERROR', l_msg_data);
5737: Write_log (1, substrb(fnd_message.get, 1, 255));
5738: ROLLBACK TO Process_Partner_Channel_Team;
5739: fnd_msg_pub.Delete_Msg;
5740: END ;

Line 5737: Write_log (1, substrb(fnd_message.get, 1, 255));

5733: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
5734: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
5735: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
5736: fnd_message.set_token('ERROR', l_msg_data);
5737: Write_log (1, substrb(fnd_message.get, 1, 255));
5738: ROLLBACK TO Process_Partner_Channel_Team;
5739: fnd_msg_pub.Delete_Msg;
5740: END ;
5741: END LOOP;

Line 5748: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');

5744:
5745: --New
5746: x_error_count := l_partner_err_cnt;
5747: -- Footer Message for Processing End.
5748: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

Line 5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );

5745: --New
5746: x_error_count := l_partner_err_cnt;
5747: -- Footer Message for Processing End.
5748: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5753: Write_log (1, substrb(fnd_message.get, 1, 1000));

Line 5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );

5746: x_error_count := l_partner_err_cnt;
5747: -- Footer Message for Processing End.
5748: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5753: Write_log (1, substrb(fnd_message.get, 1, 1000));
5754:

Line 5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );

5747: -- Footer Message for Processing End.
5748: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5753: Write_log (1, substrb(fnd_message.get, 1, 1000));
5754:
5755:

Line 5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

5748: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5753: Write_log (1, substrb(fnd_message.get, 1, 1000));
5754:
5755:
5756: --till here

Line 5753: Write_log (1, substrb(fnd_message.get, 1, 1000));

5749: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
5750: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
5751: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
5752: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
5753: Write_log (1, substrb(fnd_message.get, 1, 1000));
5754:
5755:
5756: --till here
5757:

Line 6062: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');

6058: END IF; --- l_total_records > 0
6059: END IF; --- p_first_partner_id is NULL
6060:
6061: -- Footer Message for Main Processing End.
6062: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6063: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6064: Write_log (1, substrb(fnd_message.get, 1, 255));
6065:
6066: EXCEPTION

Line 6063: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

6059: END IF; --- p_first_partner_id is NULL
6060:
6061: -- Footer Message for Main Processing End.
6062: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6063: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6064: Write_log (1, substrb(fnd_message.get, 1, 255));
6065:
6066: EXCEPTION
6067: WHEN OTHERS THEN

Line 6064: Write_log (1, substrb(fnd_message.get, 1, 255));

6060:
6061: -- Footer Message for Main Processing End.
6062: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6063: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6064: Write_log (1, substrb(fnd_message.get, 1, 255));
6065:
6066: EXCEPTION
6067: WHEN OTHERS THEN
6068: ROLLBACK TO Assign_Channel_Team_Pvt;

Line 6233: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');

6229: -- initialize the error count to zero.
6230: l_partner_err_cnt := 0;
6231:
6232: -- Header Message for Processing starts
6233: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');
6234: fnd_message.set_token('P_DATE_TIME', to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6235: Write_log (1, substrb(fnd_message.get, 1, 1000));
6236:
6237: rec_index := 0;

Line 6234: fnd_message.set_token('P_DATE_TIME', to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

6230: l_partner_err_cnt := 0;
6231:
6232: -- Header Message for Processing starts
6233: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');
6234: fnd_message.set_token('P_DATE_TIME', to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6235: Write_log (1, substrb(fnd_message.get, 1, 1000));
6236:
6237: rec_index := 0;
6238: -- FOR l_change_partner_rec IN l_terr_chng_prtnrs_csr(l_return_terr_str)

Line 6235: Write_log (1, substrb(fnd_message.get, 1, 1000));

6231:
6232: -- Header Message for Processing starts
6233: fnd_message.set_name('PV', 'PV_TAP_CTEAM_HDR');
6234: fnd_message.set_token('P_DATE_TIME', to_char(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6235: Write_log (1, substrb(fnd_message.get, 1, 1000));
6236:
6237: rec_index := 0;
6238: -- FOR l_change_partner_rec IN l_terr_chng_prtnrs_csr(l_return_terr_str)
6239: FOR l_change_partner_rec IN l_terr_chng_prtnrs_csr(

Line 6332: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

6328: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6329: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6330: RAISE FND_API.G_EXC_ERROR;
6331: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6332: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
6333: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');
6334: FND_MSG_PUB.Add;
6335: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: END IF;

Line 6333: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');

6329: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6330: RAISE FND_API.G_EXC_ERROR;
6331: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6332: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
6333: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners');
6334: FND_MSG_PUB.Add;
6335: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6336: END IF;
6337: END IF;

Line 6377: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

6373: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6375: RAISE FND_API.G_EXC_ERROR;
6376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6377: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
6378: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
6379: FND_MSG_PUB.Add;
6380: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6381: END IF;

Line 6378: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

6374: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6375: RAISE FND_API.G_EXC_ERROR;
6376: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
6377: /* FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
6378: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
6379: FND_MSG_PUB.Add;
6380: */ RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6381: END IF;
6382: END IF;

Line 6386: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');

6382: END IF;
6383: END IF; -- l_chk_partner_exists_csr%FOUND
6384:
6385: -- Debug statement for each partner_id
6386: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
6387: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6388: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6389: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6390: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 6387: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

6383: END IF; -- l_chk_partner_exists_csr%FOUND
6384:
6385: -- Debug statement for each partner_id
6386: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
6387: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6388: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6389: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6390: Write_log (1, substrb(fnd_message.get, 1, 255));
6391:

Line 6388: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

6384:
6385: -- Debug statement for each partner_id
6386: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
6387: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6388: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6389: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6390: Write_log (1, substrb(fnd_message.get, 1, 255));
6391:
6392: EXCEPTION

Line 6389: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

6385: -- Debug statement for each partner_id
6386: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
6387: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6388: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6389: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6390: Write_log (1, substrb(fnd_message.get, 1, 255));
6391:
6392: EXCEPTION
6393: WHEN FND_API.G_EXC_ERROR THEN

Line 6390: Write_log (1, substrb(fnd_message.get, 1, 255));

6386: fnd_message.set_name('PV', 'PV_TAP_CTEAM_MSG');
6387: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6388: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6389: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6390: Write_log (1, substrb(fnd_message.get, 1, 255));
6391:
6392: EXCEPTION
6393: WHEN FND_API.G_EXC_ERROR THEN
6394:

Line 6406: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

6402: ,p_data => l_msg_data
6403: );
6404:
6405: l_partner_err_cnt := l_partner_err_cnt +1;
6406: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6407: l_msg_data := substr(apps.fnd_message.get,1,254);
6408:
6409:
6410: -- Debug statement for each partner_id

Line 6407: l_msg_data := substr(apps.fnd_message.get,1,254);

6403: );
6404:
6405: l_partner_err_cnt := l_partner_err_cnt +1;
6406: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6407: l_msg_data := substr(apps.fnd_message.get,1,254);
6408:
6409:
6410: -- Debug statement for each partner_id
6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

Line 6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

6407: l_msg_data := substr(apps.fnd_message.get,1,254);
6408:
6409:
6410: -- Debug statement for each partner_id
6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6415: fnd_message.set_token('ERROR', l_msg_data);

Line 6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

6408:
6409:
6410: -- Debug statement for each partner_id
6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6415: fnd_message.set_token('ERROR', l_msg_data);
6416: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

6409:
6410: -- Debug statement for each partner_id
6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6415: fnd_message.set_token('ERROR', l_msg_data);
6416: Write_log (1, substrb(fnd_message.get, 1, 255));
6417: ROLLBACK TO Process_Partner_Channel_Team;

Line 6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

6410: -- Debug statement for each partner_id
6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6415: fnd_message.set_token('ERROR', l_msg_data);
6416: Write_log (1, substrb(fnd_message.get, 1, 255));
6417: ROLLBACK TO Process_Partner_Channel_Team;
6418: fnd_msg_pub.Delete_Msg;

Line 6415: fnd_message.set_token('ERROR', l_msg_data);

6411: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6415: fnd_message.set_token('ERROR', l_msg_data);
6416: Write_log (1, substrb(fnd_message.get, 1, 255));
6417: ROLLBACK TO Process_Partner_Channel_Team;
6418: fnd_msg_pub.Delete_Msg;
6419:

Line 6416: Write_log (1, substrb(fnd_message.get, 1, 255));

6412: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6413: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6414: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6415: fnd_message.set_token('ERROR', l_msg_data);
6416: Write_log (1, substrb(fnd_message.get, 1, 255));
6417: ROLLBACK TO Process_Partner_Channel_Team;
6418: fnd_msg_pub.Delete_Msg;
6419:
6420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6432: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

6428: ,p_data => l_msg_data
6429: );
6430:
6431: l_partner_err_cnt := l_partner_err_cnt +1;
6432: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6433: l_msg_data := substr(apps.fnd_message.get,1,254);
6434:
6435: -- Debug statement for each partner_id
6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

Line 6433: l_msg_data := substr(apps.fnd_message.get,1,254);

6429: );
6430:
6431: l_partner_err_cnt := l_partner_err_cnt +1;
6432: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6433: l_msg_data := substr(apps.fnd_message.get,1,254);
6434:
6435: -- Debug statement for each partner_id
6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

Line 6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

6432: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6433: l_msg_data := substr(apps.fnd_message.get,1,254);
6434:
6435: -- Debug statement for each partner_id
6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6440: fnd_message.set_token('ERROR', l_msg_data);

Line 6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

6433: l_msg_data := substr(apps.fnd_message.get,1,254);
6434:
6435: -- Debug statement for each partner_id
6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6440: fnd_message.set_token('ERROR', l_msg_data);
6441: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

6434:
6435: -- Debug statement for each partner_id
6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6440: fnd_message.set_token('ERROR', l_msg_data);
6441: Write_log (1, substrb(fnd_message.get, 1, 255));
6442: ROLLBACK TO Process_Partner_Channel_Team;

Line 6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

6435: -- Debug statement for each partner_id
6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6440: fnd_message.set_token('ERROR', l_msg_data);
6441: Write_log (1, substrb(fnd_message.get, 1, 255));
6442: ROLLBACK TO Process_Partner_Channel_Team;
6443: fnd_msg_pub.Delete_Msg;

Line 6440: fnd_message.set_token('ERROR', l_msg_data);

6436: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6440: fnd_message.set_token('ERROR', l_msg_data);
6441: Write_log (1, substrb(fnd_message.get, 1, 255));
6442: ROLLBACK TO Process_Partner_Channel_Team;
6443: fnd_msg_pub.Delete_Msg;
6444:

Line 6441: Write_log (1, substrb(fnd_message.get, 1, 255));

6437: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6438: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6439: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6440: fnd_message.set_token('ERROR', l_msg_data);
6441: Write_log (1, substrb(fnd_message.get, 1, 255));
6442: ROLLBACK TO Process_Partner_Channel_Team;
6443: fnd_msg_pub.Delete_Msg;
6444:
6445: WHEN OTHERS THEN

Line 6458: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));

6454: ,p_data => l_msg_data
6455: );
6456:
6457: l_partner_err_cnt := l_partner_err_cnt +1;
6458: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6459: l_msg_data := substr(apps.fnd_message.get,1,254);
6460:
6461:
6462: -- Debug statement for each partner_id

Line 6459: l_msg_data := substr(apps.fnd_message.get,1,254);

6455: );
6456:
6457: l_partner_err_cnt := l_partner_err_cnt +1;
6458: apps.fnd_message.set_encoded(apps.fnd_msg_pub.get(l_msg_count));
6459: l_msg_data := substr(apps.fnd_message.get,1,254);
6460:
6461:
6462: -- Debug statement for each partner_id
6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

Line 6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');

6459: l_msg_data := substr(apps.fnd_message.get,1,254);
6460:
6461:
6462: -- Debug statement for each partner_id
6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6467: fnd_message.set_token('ERROR', l_msg_data);

Line 6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));

6460:
6461:
6462: -- Debug statement for each partner_id
6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6467: fnd_message.set_token('ERROR', l_msg_data);
6468: Write_log (1, substrb(fnd_message.get, 1, 255));

Line 6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));

6461:
6462: -- Debug statement for each partner_id
6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6467: fnd_message.set_token('ERROR', l_msg_data);
6468: Write_log (1, substrb(fnd_message.get, 1, 255));
6469: ROLLBACK TO Process_Partner_Channel_Team;

Line 6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);

6462: -- Debug statement for each partner_id
6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6467: fnd_message.set_token('ERROR', l_msg_data);
6468: Write_log (1, substrb(fnd_message.get, 1, 255));
6469: ROLLBACK TO Process_Partner_Channel_Team;
6470: fnd_msg_pub.Delete_Msg;

Line 6467: fnd_message.set_token('ERROR', l_msg_data);

6463: fnd_message.set_name('PV', 'PV_TAP_CTEAM_ERR');
6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6467: fnd_message.set_token('ERROR', l_msg_data);
6468: Write_log (1, substrb(fnd_message.get, 1, 255));
6469: ROLLBACK TO Process_Partner_Channel_Team;
6470: fnd_msg_pub.Delete_Msg;
6471:

Line 6468: Write_log (1, substrb(fnd_message.get, 1, 255));

6464: fnd_message.set_token('PARTNER_NAME', rpad(l_partner_name,40));
6465: fnd_message.set_token('PARTNER_ID', rpad(l_partner_id,15));
6466: -- fnd_message.set_token('PARTNER_ID', l_partner_id);
6467: fnd_message.set_token('ERROR', l_msg_data);
6468: Write_log (1, substrb(fnd_message.get, 1, 255));
6469: ROLLBACK TO Process_Partner_Channel_Team;
6470: fnd_msg_pub.Delete_Msg;
6471:
6472: END ;

Line 6477: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');

6473: END LOOP; --FOR i IN 1..l_partner_list_tbl.last
6474: END IF ; -- l_partner_list_tbl.count > 0
6475:
6476: -- Footer Message for Processing End.
6477: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

Line 6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );

6474: END IF ; -- l_partner_list_tbl.count > 0
6475:
6476: -- Footer Message for Processing End.
6477: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6482: Write_log (1, substrb(fnd_message.get, 1, 1000));

Line 6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );

6475:
6476: -- Footer Message for Processing End.
6477: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6482: Write_log (1, substrb(fnd_message.get, 1, 1000));
6483:

Line 6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );

6476: -- Footer Message for Processing End.
6477: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6482: Write_log (1, substrb(fnd_message.get, 1, 1000));
6483:
6484: IF (l_partner_err_cnt > 0) THEN

Line 6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );

6477: fnd_message.set_name('PV', 'PV_TAP_CTEAM_FOOTER');
6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6482: Write_log (1, substrb(fnd_message.get, 1, 1000));
6483:
6484: IF (l_partner_err_cnt > 0) THEN
6485: RETCODE := FND_API.G_RET_STS_ERROR;

Line 6482: Write_log (1, substrb(fnd_message.get, 1, 1000));

6478: fnd_message.set_token('TOT_PRTNR_CNT', to_char(l_partner_list_tbl.count) );
6479: fnd_message.set_token('SUC_PRTNR_CNT', to_char(l_partner_list_tbl.count-l_partner_err_cnt) );
6480: fnd_message.set_token('ERR_PRTNR_CNT', to_char(l_partner_err_cnt) );
6481: fnd_message.set_token('P_DATE_TIME', TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') );
6482: Write_log (1, substrb(fnd_message.get, 1, 1000));
6483:
6484: IF (l_partner_err_cnt > 0) THEN
6485: RETCODE := FND_API.G_RET_STS_ERROR;
6486: l_status := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', SQLERRM);