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 PVX_UTILITY_PVT

Line 502: PVX_UTILITY_PVT.debug_message('Exception: others in Get_resource_from_team_group');

498: end if;
499:
500: EXCEPTION
501: WHEN others THEN
502: PVX_UTILITY_PVT.debug_message('Exception: others in Get_resource_from_team_group');
503: PVX_UTILITY_PVT.debug_message('SQLCODE ' || to_char(SQLCODE) ||
504: 'SQLERRM ' || substr(SQLERRM, 1, 100));
505: END GET_RES_FROM_TEAM_GROUP;
506:

Line 503: PVX_UTILITY_PVT.debug_message('SQLCODE ' || to_char(SQLCODE) ||

499:
500: EXCEPTION
501: WHEN others THEN
502: PVX_UTILITY_PVT.debug_message('Exception: others in Get_resource_from_team_group');
503: PVX_UTILITY_PVT.debug_message('SQLCODE ' || to_char(SQLCODE) ||
504: 'SQLERRM ' || substr(SQLERRM, 1, 100));
505: END GET_RES_FROM_TEAM_GROUP;
506:
507: -- Start of Comments

Line 1114: PVX_Utility_PVT.debug_message('Procedure : Cr_Login_User_Access_Rec Start');

1110: l_cm_added := 'N';
1111: l_user_exists := 'N';
1112:
1113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1114: PVX_Utility_PVT.debug_message('Procedure : Cr_Login_User_Access_Rec Start');
1115: END IF;
1116:
1117: OPEN l_get_resource_id_csr(p_login_user_id) ;
1118: FETCH l_get_resource_id_csr INTO l_resource_id ;

Line 1167: PVX_Utility_PVT.debug_message('Procedure : Cr_Login_User_Access_Rec End');

1163: CLOSE l_get_resource_id_csr;
1164: END IF; /* (l_get_resource_id_csr%FOUND) */
1165:
1166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1167: PVX_Utility_PVT.debug_message('Procedure : Cr_Login_User_Access_Rec End');
1168: END IF;
1169:
1170: EXCEPTION
1171: WHEN FND_API.g_exc_error THEN

Line 1269: PVX_Utility_PVT.debug_message('Procedure TAP_Get_Channel_Managers Start.');

1265:
1266: BEGIN
1267: -- Debug Message
1268: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1269: PVX_Utility_PVT.debug_message('Procedure TAP_Get_Channel_Managers Start.');
1270: END IF;
1271:
1272: -- Initialize API return status to SUCCESS
1273: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1380: PVX_UTILITY_PVT.debug_message('Partner Details - Partner Type:'||p_prtnr_qualifier_rec.partner_type);

1376:
1377: l_gen_bulk_rec.SQUAL_CURC01(1) := l_curr_code;
1378:
1379: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1380: PVX_UTILITY_PVT.debug_message('Partner Details - Partner Type:'||p_prtnr_qualifier_rec.partner_type);
1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));
1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);

Line 1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));

1377: l_gen_bulk_rec.SQUAL_CURC01(1) := l_curr_code;
1378:
1379: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1380: PVX_UTILITY_PVT.debug_message('Partner Details - Partner Type:'||p_prtnr_qualifier_rec.partner_type);
1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));
1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);

Line 1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);

1378:
1379: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1380: PVX_UTILITY_PVT.debug_message('Partner Details - Partner Type:'||p_prtnr_qualifier_rec.partner_type);
1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));
1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);

Line 1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);

1379: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1380: PVX_UTILITY_PVT.debug_message('Partner Details - Partner Type:'||p_prtnr_qualifier_rec.partner_type);
1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));
1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);

Line 1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);

1380: PVX_UTILITY_PVT.debug_message('Partner Details - Partner Type:'||p_prtnr_qualifier_rec.partner_type);
1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));
1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);

Line 1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);

1381: PVX_UTILITY_PVT.debug_message('party_id = ' || to_char(p_prtnr_qualifier_rec.party_id));
1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);

Line 1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);

1382: PVX_UTILITY_PVT.debug_message('prtnr name Range= ' || p_prtnr_qualifier_rec.partner_name);
1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);

Line 1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);

1383: PVX_UTILITY_PVT.debug_message('city = ' || p_prtnr_qualifier_rec.city);
1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);

Line 1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);

1384: PVX_UTILITY_PVT.debug_message('county = ' || p_prtnr_qualifier_rec.county);
1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);
1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));

Line 1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);

1385: PVX_UTILITY_PVT.debug_message('country = ' || p_prtnr_qualifier_rec.country);
1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);
1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));
1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));

Line 1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);

1386: PVX_UTILITY_PVT.debug_message('state = ' || p_prtnr_qualifier_rec.state);
1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);
1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));
1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));
1394: END IF;

Line 1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);

1387: PVX_UTILITY_PVT.debug_message('postal_code = ' || p_prtnr_qualifier_rec.postal_code);
1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);
1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));
1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));
1394: END IF;
1395:

Line 1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));

1388: PVX_UTILITY_PVT.debug_message('area_code = ' || p_prtnr_qualifier_rec.area_code);
1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);
1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));
1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));
1394: END IF;
1395:
1396: JTF_TERR_ASSIGN_PUB.get_winners

Line 1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));

1389: PVX_UTILITY_PVT.debug_message('province = ' || p_prtnr_qualifier_rec.province);
1390: PVX_UTILITY_PVT.debug_message('Customer Catgy = ' || p_prtnr_qualifier_rec.customer_category_code);
1391: PVX_UTILITY_PVT.debug_message('Partner Level = ' || p_prtnr_qualifier_rec.partner_level);
1392: PVX_UTILITY_PVT.debug_message('employees_total = ' || to_char(p_prtnr_qualifier_rec.number_of_employee));
1393: PVX_UTILITY_PVT.debug_message('Annual_Revenue = ' || to_char(p_prtnr_qualifier_rec.Annual_Revenue));
1394: END IF;
1395:
1396: JTF_TERR_ASSIGN_PUB.get_winners
1397: ( p_api_version_number => 1.0,

Line 1424: PVX_UTILITY_PVT.debug_message('Resource Id = '||to_char(l_winners_rec.resource_id(k)));

1420: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1421: IF (l_winners_rec.resource_id.count > 0 ) THEN
1422: FOR k IN 1..l_winners_rec.resource_id.last
1423: LOOP
1424: PVX_UTILITY_PVT.debug_message('Resource Id = '||to_char(l_winners_rec.resource_id(k)));
1425: END LOOP;
1426: END IF;
1427: END IF;
1428: -- -------------------------------------------------------------------------

Line 1560: PVX_Utility_PVT.debug_message('Procedure Process_TAP_Resources Start.');

1556: BEGIN
1557: --------------- INSERTION OF THE LOGIC BEGIN ---------------------------
1558: -- Debug Message
1559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1560: PVX_Utility_PVT.debug_message('Procedure Process_TAP_Resources Start.');
1561: END IF;
1562:
1563: -- Initialize the return status
1564: x_return_status := FND_API.g_ret_sts_success;

Line 1939: PVX_Utility_PVT.debug_message('After successfully getting the Partner Details ***************');

1935: END IF;
1936:
1937: -- Debug Message
1938: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1939: PVX_Utility_PVT.debug_message('After successfully getting the Partner Details ***************');
1940: END IF;
1941:
1942: -- Store in the output variable.
1943: x_partner_qualifiers_tbl := l_partner_qualifiers_tbl;

Line 2074: PVX_UTILITY_PVT.debug_message('Private Procedure: ' || l_api_name || 'start');

2070: BEGIN
2071:
2072: -- Debug Message
2073: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2074: PVX_UTILITY_PVT.debug_message('Private Procedure: ' || l_api_name || 'start');
2075: END IF;
2076:
2077: -- Initialize API return status to SUCCESS
2078: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2143: PVX_UTILITY_PVT.debug_message('Private Procedure: ' || l_api_name || 'end.');

2139: END LOOP; /* FOR l_channel_team_rec IN l_channel_team_csr(p_partner_id) */
2140:
2141: -- Debug Message
2142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2143: PVX_UTILITY_PVT.debug_message('Private Procedure: ' || l_api_name || 'end.');
2144: END IF;
2145:
2146: -- Standard call to get message count and if count is 1, get message info.
2147: FND_MSG_PUB.Count_And_Get

Line 2341: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');

2337: END IF;
2338:
2339: -- Debug Message
2340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2341: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');
2342: END IF;
2343:
2344: -- Initialize API return status to SUCCESS
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2365: PVX_Utility_PVT.debug_message('START : Procesing of TAP returned resources with CHANNEL_MANAGER or CHANNEL_REP role.');

2361: -- Procesing of TAP returned resources with 'CHANNEL_MANAGER' or 'CHANNEL_REP' role.
2362: -- Debug Message
2363:
2364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2365: PVX_Utility_PVT.debug_message('START : Procesing of TAP returned resources with CHANNEL_MANAGER or CHANNEL_REP role.');
2366: END IF;
2367:
2368: -- Get the Partner Party Id for the given Partner_Id
2369: OPEN l_party_id_csr(l_partner_id);

Line 2434: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');

2430: l_partner_qualifier_rec.partner_level := l_partner_level;
2431:
2432: -- Debug Message
2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2434: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);

Line 2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);

2431:
2432: -- Debug Message
2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2434: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);

Line 2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);

2432: -- Debug Message
2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2434: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);

Line 2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);

2433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2434: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);

Line 2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);

2434: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);

Line 2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);

2435: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);

Line 2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);

2436: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);

Line 2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);

2437: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);

Line 2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);

2438: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);

Line 2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);

2439: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);

Line 2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);

2440: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
2448: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);

Line 2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);

2441: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
2448: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
2449: END IF;

Line 2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);

2442: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
2448: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
2449: END IF;
2450:

Line 2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);

2443: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
2448: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
2449: END IF;
2450:
2451: -- Call the TAP_Get_Channel_Team API

Line 2448: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);

2444: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
2445: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
2446: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
2447: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
2448: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
2449: END IF;
2450:
2451: -- Call the TAP_Get_Channel_Team API
2452: TAP_Get_Channel_Team(

Line 2472: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : -- TAP_Get_Channel_Team ');

2468: END IF;
2469:
2470: -- Debug Message
2471: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2472: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : -- TAP_Get_Channel_Team ');
2473: END IF;
2474:
2475:
2476: IF ( l_winners_rec.resource_id.count > 0) THEN

Line 2656: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');

2652: END IF;
2653:
2654: -- Debug Message
2655: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2656: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');
2657: END IF;
2658:
2659: -- Initialize API return status to SUCCESS
2660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2726: PVX_Utility_PVT.debug_message('START : Step3: If p_vad_partner_id is not null, then all the CMs( Employees of VAD Organization.');

2722: IF ( NOT(p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) ) THEN
2723:
2724: -- Debug Message
2725: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2726: PVX_Utility_PVT.debug_message('START : Step3: If p_vad_partner_id is not null, then all the CMs( Employees of VAD Organization.');
2727: END IF;
2728:
2729: -- Get the VAD Channel Team -
2730: Create_VAD_Channel_Team(

Line 2768: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : Step3.');

2764: END IF;
2765:
2766: -- Debug Message
2767: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2768: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : Step3.');
2769: END IF;
2770:
2771: END IF; -- l_vad_partner_id IS NOT NULL OR l_vad_partner_id <> FND_API.g_miss_num
2772:

Line 2778: PVX_Utility_PVT.debug_message('START : Step4: Assign Default Channel Manager as a Channel Team member : l_cm_added => '||l_cm_added );

2774: -- TAP procedure call failed to add any channel team member.
2775: -- Debug Message
2776:
2777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2778: PVX_Utility_PVT.debug_message('START : Step4: Assign Default Channel Manager as a Channel Team member : l_cm_added => '||l_cm_added );
2779: END IF;
2780:
2781: if x_prtnr_access_id_tbl.count > 0 then
2782: l_cm_added := 'Y';

Line 2849: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

2845: END IF;
2846:
2847: -- Debug Message
2848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2849: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
2850: END IF;
2851:
2852: -- Standard call to get message count and if count is 1, get message info.
2853: FND_MSG_PUB.Count_And_Get

Line 3027: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');

3023: END IF;
3024:
3025: -- Debug Message
3026: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
3027: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');
3028: END IF;
3029:
3030: -- Initialize API return status to SUCCESS
3031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3222: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End');

3218: END IF;
3219:
3220: -- Debug Message
3221: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3222: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' End');
3223: END IF;
3224:
3225: -- Standard call to get message count and if count is 1, get message info.
3226: FND_MSG_PUB.Count_And_Get

Line 3588: PVX_Utility_PVT.debug_message('This procedure is not in use');

3584: --PN Not in use, Replaced by TERR and User APIs
3585:
3586: -- dbms_output.put_line('Dummy stmt ');
3587: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3588: PVX_Utility_PVT.debug_message('This procedure is not in use');
3589: END IF;
3590: /*
3591: -- Standard call to check for call compatibility.
3592: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 3608: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');

3604: END IF;
3605:
3606: -- Debug Message
3607: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3608: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');
3609: END IF;
3610:
3611: -- Initialize API return status to SUCCESS
3612: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3671: PVX_Utility_PVT.debug_message('START : STEP (ii) : Procesing of TAP returned resources with CHANNEL_MANAGER or CHANNEL_REP role.');

3667:
3668: -- STEP (ii) : Procesing of TAP returned resources with 'CHANNEL_MANAGER' or 'CHANNEL_REP' role.
3669: -- Debug Message
3670: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3671: PVX_Utility_PVT.debug_message('START : STEP (ii) : Procesing of TAP returned resources with CHANNEL_MANAGER or CHANNEL_REP role.');
3672: END IF;
3673:
3674: -- Get the Partner Party Id for the given Partner_Id
3675: OPEN l_party_id_csr(l_partner_id);

Line 3763: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');

3759: l_partner_qualifier_rec.partner_level := l_partner_level;
3760:
3761: -- Debug Message
3762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3763: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);

Line 3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);

3760:
3761: -- Debug Message
3762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3763: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);

Line 3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);

3761: -- Debug Message
3762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3763: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);

Line 3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);

3762: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3763: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);

Line 3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);

3763: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);

Line 3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);

3764: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);

Line 3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);

3765: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);

Line 3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);

3766: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);

Line 3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);

3767: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);

Line 3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);

3768: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);

Line 3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);

3769: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
3777: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);

Line 3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);

3770: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
3777: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
3778: END IF;

Line 3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);

3771: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
3777: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
3778: END IF;
3779:

Line 3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);

3772: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
3777: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
3778: END IF;
3779:
3780: -- Call the TAP_Get_Channel_Team API

Line 3777: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);

3773: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
3774: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
3775: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
3776: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
3777: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
3778: END IF;
3779:
3780: -- Call the TAP_Get_Channel_Team API
3781: TAP_Get_Channel_Team(

Line 3801: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : -- TAP_Get_Channel_Team ');

3797: END IF;
3798:
3799: -- Debug Message
3800: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3801: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : -- TAP_Get_Channel_Team ');
3802: END IF;
3803:
3804:
3805: IF ( l_winners_rec.resource_id.count > 0) THEN

Line 3842: PVX_Utility_PVT.debug_message('START : Step3: If p_vad_partner_id is not null, then all the CMs( Employees of VAD Organization.');

3838: IF ( NOT(p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) ) THEN
3839:
3840: -- Debug Message
3841: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3842: PVX_Utility_PVT.debug_message('START : Step3: If p_vad_partner_id is not null, then all the CMs( Employees of VAD Organization.');
3843: END IF;
3844:
3845: -- Get the VAD Channel Team -
3846: Create_VAD_Channel_Team(

Line 3884: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : Step3.');

3880: END IF;
3881:
3882: -- Debug Message
3883: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3884: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : Step3.');
3885: END IF;
3886:
3887: END IF; -- l_vad_partner_id IS NOT NULL OR l_vad_partner_id <> FND_API.g_miss_num
3888:

Line 3893: PVX_Utility_PVT.debug_message('START : Step4: Assign Default Channel Manager as a Channel Team member : l_cm_added => '||l_cm_added );

3889: -- Assign Default Channel Manager as a Channel Team member, if both the above (Logged_in_User and
3890: -- TAP procedure call failed to add any channel team member.
3891: -- Debug Message
3892: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3893: PVX_Utility_PVT.debug_message('START : Step4: Assign Default Channel Manager as a Channel Team member : l_cm_added => '||l_cm_added );
3894: END IF;
3895:
3896: IF ( l_cm_added <> 'Y' ) THEN
3897: -- Set the p_partner_access_rec record

Line 3951: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

3947: END IF;
3948:
3949: -- Debug Message
3950: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3951: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
3952: END IF;
3953:
3954: -- Standard call to get message count and if count is 1, get message info.
3955: FND_MSG_PUB.Count_And_Get

Line 4072: PVX_Utility_PVT.debug_message('This procedure is not in use');

4068: begin
4069: --PN Not in use, Replaced by TERR and User APIs
4070: -- dbms_output.put_line('Dummy stmt ');
4071: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4072: PVX_Utility_PVT.debug_message('This procedure is not in use');
4073: END IF;
4074:
4075: /*
4076:

Line 4168: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');

4164: END IF;
4165:
4166: -- Debug Message
4167: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4168: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');
4169: END IF;
4170:
4171: -- Initialize API return status to SUCCESS
4172: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4231: PVX_Utility_PVT.debug_message('START : STEP (ii) : Procesing of TAP returned resources with CHANNEL_MANAGER or CHANNEL_REP role.');

4227:
4228: -- STEP (ii) : Procesing of TAP returned resources with 'CHANNEL_MANAGER' or 'CHANNEL_REP' role.
4229: -- Debug Message
4230: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4231: PVX_Utility_PVT.debug_message('START : STEP (ii) : Procesing of TAP returned resources with CHANNEL_MANAGER or CHANNEL_REP role.');
4232: END IF;
4233:
4234: -- Get the Partner Party Id for the given Partner_Id
4235: OPEN l_party_id_csr(l_partner_id);

Line 4315: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');

4311: l_partner_qualifier_rec.partner_level := l_partner_level;
4312:
4313: -- Debug Message
4314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4315: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);

Line 4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);

4312:
4313: -- Debug Message
4314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4315: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);

Line 4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);

4313: -- Debug Message
4314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4315: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);

Line 4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);

4314: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4315: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);

Line 4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);

4315: PVX_Utility_PVT.debug_message('START : -- Call the TAP_Get_Channel_Team API ');
4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);

Line 4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);

4316: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.party_site_id);
4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);

Line 4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);

4317: PVX_Utility_PVT.debug_message('('||to_char(i)||') city => '|| l_partner_qualifier_rec.city);
4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);

Line 4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);

4318: PVX_Utility_PVT.debug_message('('||to_char(i)||') country => '|| l_partner_qualifier_rec.country);
4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);

Line 4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);

4319: PVX_Utility_PVT.debug_message('('||to_char(i)||') county => '|| l_partner_qualifier_rec.county);
4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);

Line 4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);

4320: PVX_Utility_PVT.debug_message('('||to_char(i)||') state => '|| l_partner_qualifier_rec.state);
4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);

Line 4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);

4321: PVX_Utility_PVT.debug_message('('||to_char(i)||') province => '|| l_partner_qualifier_rec.province);
4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
4329: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);

Line 4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);

4322: PVX_Utility_PVT.debug_message('('||to_char(i)||') postal_code => '|| l_partner_qualifier_rec.postal_code);
4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
4329: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
4330: END IF;

Line 4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);

4323: PVX_Utility_PVT.debug_message('('||to_char(i)||') area_code => '|| l_partner_qualifier_rec.area_code);
4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
4329: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
4330: END IF;
4331:

Line 4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);

4324: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner_name => '|| l_partner_qualifier_rec.partner_name);
4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
4329: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
4330: END IF;
4331:
4332: -- Call the TAP_Get_Channel_Team API

Line 4329: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);

4325: PVX_Utility_PVT.debug_message('('||to_char(i)||') annual_revenue => '|| l_partner_qualifier_rec.annual_revenue);
4326: PVX_Utility_PVT.debug_message('('||to_char(i)||') number_of_employee => '|| l_partner_qualifier_rec.number_of_employee);
4327: PVX_Utility_PVT.debug_message('('||to_char(i)||') customer_category_code => '|| l_partner_qualifier_rec.customer_category_code);
4328: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner type => '|| l_partner_qualifier_rec.partner_type);
4329: PVX_Utility_PVT.debug_message('('||to_char(i)||') partner level => '|| l_partner_qualifier_rec.partner_level);
4330: END IF;
4331:
4332: -- Call the TAP_Get_Channel_Team API
4333: TAP_Get_Channel_Team(

Line 4353: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : -- TAP_Get_Channel_Team ');

4349: END IF;
4350:
4351: -- Debug Message
4352: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4353: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : -- TAP_Get_Channel_Team ');
4354: END IF;
4355:
4356:
4357: IF ( l_winners_rec.resource_id.count > 0) THEN

Line 4394: PVX_Utility_PVT.debug_message('START : Step3: If p_vad_partner_id is not null, then all the CMs( Employees of VAD Organization.');

4390: IF ( NOT(p_vad_partner_id IS NULL OR p_vad_partner_id = FND_API.g_miss_num) ) THEN
4391:
4392: -- Debug Message
4393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4394: PVX_Utility_PVT.debug_message('START : Step3: If p_vad_partner_id is not null, then all the CMs( Employees of VAD Organization.');
4395: END IF;
4396:
4397: -- Get the VAD Channel Team -
4398: Create_VAD_Channel_Team(

Line 4436: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : Step3.');

4432: END IF;
4433:
4434: -- Debug Message
4435: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4436: PVX_Utility_PVT.debug_message('SUCCESSFULLY END : Step3.');
4437: END IF;
4438:
4439: END IF; -- l_vad_partner_id IS NOT NULL OR l_vad_partner_id <> FND_API.g_miss_num
4440:

Line 4445: PVX_Utility_PVT.debug_message('START : Step4: Assign Default Channel Manager as a Channel Team member : l_cm_added => '||l_cm_added );

4441: -- Assign Default Channel Manager as a Channel Team member, if both the above (Logged_in_User and
4442: -- TAP procedure call failed to add any channel team member.
4443: -- Debug Message
4444: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4445: PVX_Utility_PVT.debug_message('START : Step4: Assign Default Channel Manager as a Channel Team member : l_cm_added => '||l_cm_added );
4446: END IF;
4447:
4448: IF ( l_cm_added <> 'Y' ) THEN
4449: -- Set the p_partner_access_rec record

Line 4503: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

4499: END IF;
4500:
4501: -- Debug Message
4502: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4503: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
4504: END IF;
4505:
4506: -- Standard call to get message count and if count is 1, get message info.
4507: FND_MSG_PUB.Count_And_Get

Line 4704: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');

4700: END IF;
4701:
4702: -- Debug Message
4703: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4704: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || ' Start');
4705: END IF;
4706:
4707: -- Initialize API return status to SUCCESS
4708: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4813: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

4809:
4810:
4811: -- Debug Message
4812: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4813: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
4814: END IF;
4815:
4816: -- Standard call to get message count and if count is 1, get message info.
4817: FND_MSG_PUB.Count_And_Get

Line 4977: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');

4973: END IF;
4974:
4975: -- Debug Message
4976: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
4977: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
4978: END IF;
4979:
4980: -- Initialize API return status to SUCCESS
4981: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4989: PVX_Utility_PVT.debug_message('Validating the supplied partner Id.');

4985: -- =========================================================================
4986:
4987: -- Debug Message
4988: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
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');

Line 5003: PVX_Utility_PVT.debug_message('After successful validating the supplied partner Id.');

4999: END IF;
5000:
5001: -- Debug Message
5002: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5003: PVX_Utility_PVT.debug_message('After successful validating the supplied partner Id.');
5004: END IF;
5005:
5006: -- Initialize the l_vad_partner_id.
5007: l_vad_partner_id := p_vad_partner_id;

Line 5065: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');

5061: END IF;
5062:
5063: -- Debug Message
5064: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5065: PVX_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
5066: END IF;
5067:
5068: -- Standard call to get message count and if count is 1, get message info.
5069: FND_MSG_PUB.Count_And_Get

Line 5190: PVX_UTILITY_PVT.debug_message('Private Procedure:Process_Channel_Team Start');

5186: BEGIN
5187:
5188: -- Debug Message
5189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5190: PVX_UTILITY_PVT.debug_message('Private Procedure:Process_Channel_Team Start');
5191: END IF;
5192:
5193: -- Initialize API return status to SUCCESS
5194: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5303: PVX_UTILITY_PVT.debug_message('Private Procedure:Process_Channel_Team End.');

5299: END IF;
5300:
5301: -- Debug Message
5302: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
5303: PVX_UTILITY_PVT.debug_message('Private Procedure:Process_Channel_Team End.');
5304: END IF;
5305:
5306: EXCEPTION
5307: WHEN FND_API.g_exc_error THEN