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_TAP_BES_PKG dependencies on FND_API

Line 1365: x_return_status := FND_API.G_RET_STS_SUCCESS;

1361:
1362: BEGIN
1363:
1364: -- Initialize API return status to SUCCESS
1365: x_return_status := FND_API.G_RET_STS_SUCCESS;
1366:
1367: -- Check if the supplied party_id point to a Partner or a Customer.
1368: -- If it's point to a PARTNER Org, then there should be a record exists in
1369: -- PV_PARTNER_PROFILES table.

Line 1395: p_init_msg_list => FND_API.G_FALSE,

1391: -- Store this partner_id in PV_TAP_BATCH_CHG_PARTNERS table for later processing
1392: -- for channel team assignment.
1393: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1394: p_api_version_number => 1.0 ,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: p_commit => FND_API.G_FALSE,
1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1398: x_return_status => l_return_status,
1399: x_msg_count => l_msg_count,

Line 1396: p_commit => FND_API.G_FALSE,

1392: -- for channel team assignment.
1393: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1394: p_api_version_number => 1.0 ,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: p_commit => FND_API.G_FALSE,
1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1398: x_return_status => l_return_status,
1399: x_msg_count => l_msg_count,
1400: x_msg_data => l_msg_data,

Line 1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1393: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1394: p_api_version_number => 1.0 ,
1395: p_init_msg_list => FND_API.G_FALSE,
1396: p_commit => FND_API.G_FALSE,
1397: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1398: x_return_status => l_return_status,
1399: x_msg_count => l_msg_count,
1400: x_msg_data => l_msg_data,
1401: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

Line 1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1400: x_msg_data => l_msg_data,
1401: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1402: x_partner_id => l_partner_id );
1403:
1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1401: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1402: x_partner_id => l_partner_id );
1403:
1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END IF;

Line 1406: RAISE FND_API.G_EXC_ERROR;

1402: x_partner_id => l_partner_id );
1403:
1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END IF;
1410: END IF;

Line 1407: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1403:
1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END IF;
1410: END IF;
1411: ELSE

Line 1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1404: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1405: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1406: RAISE FND_API.G_EXC_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1408: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1409: END IF;
1410: END IF;
1411: ELSE
1412: CLOSE l_chng_partner_exist_csr;

Line 1417: ,p_init_msg_list => FND_API.G_FALSE

1413: IF (l_processed_flag <> 'P') THEN
1414: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1415: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1416: p_api_version_number => 1.0
1417: ,p_init_msg_list => FND_API.G_FALSE
1418: ,p_commit => FND_API.G_FALSE
1419: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1420: ,x_return_status => l_return_status
1421: ,x_msg_count => l_msg_count

Line 1418: ,p_commit => FND_API.G_FALSE

1414: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1415: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1416: p_api_version_number => 1.0
1417: ,p_init_msg_list => FND_API.G_FALSE
1418: ,p_commit => FND_API.G_FALSE
1419: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1420: ,x_return_status => l_return_status
1421: ,x_msg_count => l_msg_count
1422: ,x_msg_data => l_msg_data

Line 1419: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1415: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1416: p_api_version_number => 1.0
1417: ,p_init_msg_list => FND_API.G_FALSE
1418: ,p_commit => FND_API.G_FALSE
1419: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1420: ,x_return_status => l_return_status
1421: ,x_msg_count => l_msg_count
1422: ,x_msg_data => l_msg_data
1423: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

Line 1425: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1421: ,x_msg_count => l_msg_count
1422: ,x_msg_data => l_msg_data
1423: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1424:
1425: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1426: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 1426: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1422: ,x_msg_data => l_msg_data
1423: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1424:
1425: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1426: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 1427: RAISE FND_API.G_EXC_ERROR;

1423: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1424:
1425: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1426: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1431: FND_MSG_PUB.Add;

Line 1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1424:
1425: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1426: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1427: RAISE FND_API.G_EXC_ERROR;
1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1431: FND_MSG_PUB.Add;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1428: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1429: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1430: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1431: FND_MSG_PUB.Add;
1432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1433: END IF;
1434: END IF;
1435:
1436: END IF; --l_processed_flag <> 'P'

Line 1444: WHEN FND_API.g_exc_error THEN

1440: ELSE
1441: CLOSE l_cust_is_partner_csr;
1442: END IF; -- l_cust_is_partner_csr%FOUND
1443: EXCEPTION
1444: WHEN FND_API.g_exc_error THEN
1445: ROLLBACK TO Update_Channel_Team_pub;
1446: x_return_status := FND_API.g_ret_sts_error;
1447:
1448: FND_MSG_PUB.count_and_get (

Line 1446: x_return_status := FND_API.g_ret_sts_error;

1442: END IF; -- l_cust_is_partner_csr%FOUND
1443: EXCEPTION
1444: WHEN FND_API.g_exc_error THEN
1445: ROLLBACK TO Update_Channel_Team_pub;
1446: x_return_status := FND_API.g_ret_sts_error;
1447:
1448: FND_MSG_PUB.count_and_get (
1449: p_encoded => FND_API.g_false
1450: ,p_count => x_msg_count

Line 1449: p_encoded => FND_API.g_false

1445: ROLLBACK TO Update_Channel_Team_pub;
1446: x_return_status := FND_API.g_ret_sts_error;
1447:
1448: FND_MSG_PUB.count_and_get (
1449: p_encoded => FND_API.g_false
1450: ,p_count => x_msg_count
1451: ,p_data => x_msg_data
1452: );
1453:

Line 1461: WHEN FND_API.g_exc_unexpected_error THEN

1457: x_msg_count, x_msg_data, 'ERROR');
1458: hz_utility_v2pub.debug('Update_Channel_Team (-)');
1459: END IF;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: ROLLBACK TO Update_Channel_Team_pub;
1463: x_return_status := FND_API.g_ret_sts_unexp_error ;
1464:
1465: FND_MSG_PUB.count_and_get (

Line 1463: x_return_status := FND_API.g_ret_sts_unexp_error ;

1459: END IF;
1460:
1461: WHEN FND_API.g_exc_unexpected_error THEN
1462: ROLLBACK TO Update_Channel_Team_pub;
1463: x_return_status := FND_API.g_ret_sts_unexp_error ;
1464:
1465: FND_MSG_PUB.count_and_get (
1466: p_encoded => FND_API.g_false
1467: ,p_count => x_msg_count

Line 1466: p_encoded => FND_API.g_false

1462: ROLLBACK TO Update_Channel_Team_pub;
1463: x_return_status := FND_API.g_ret_sts_unexp_error ;
1464:
1465: FND_MSG_PUB.count_and_get (
1466: p_encoded => FND_API.g_false
1467: ,p_count => x_msg_count
1468: ,p_data => x_msg_data
1469: );
1470: -- Debug Message

Line 1479: x_return_status := FND_API.g_ret_sts_unexp_error ;

1475: END IF;
1476:
1477: WHEN OTHERS THEN
1478: ROLLBACK TO Update_Channel_Team_pub;
1479: x_return_status := FND_API.g_ret_sts_unexp_error ;
1480:
1481: FND_MSG_PUB.count_and_get(
1482: p_encoded => FND_API.g_false
1483: ,p_count => x_msg_count

Line 1482: p_encoded => FND_API.g_false

1478: ROLLBACK TO Update_Channel_Team_pub;
1479: x_return_status := FND_API.g_ret_sts_unexp_error ;
1480:
1481: FND_MSG_PUB.count_and_get(
1482: p_encoded => FND_API.g_false
1483: ,p_count => x_msg_count
1484: ,p_data => x_msg_data
1485: );
1486:

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

1574:
1575: BEGIN
1576:
1577: -- Initialize API return status to SUCCESS
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1581: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,l_module,'Party Id: ' || p_party_id);
1582: END IF;

Line 1594: ,p_init_msg_list => FND_API.g_true

1590:
1591:
1592: JTF_RS_RESOURCE_PUB.Update_Resource(
1593: p_api_version => 1.0
1594: ,p_init_msg_list => FND_API.g_true
1595: ,p_resource_id => l_cust_partner_rec.resource_id
1596: ,p_resource_number => l_cust_partner_rec.resource_number
1597: ,p_resource_name => l_cust_partner_rec.PARTY_NAME -- resource_name
1598: ,p_source_name => l_cust_partner_rec.PARTY_NAME -- source_name

Line 1611: IF x_return_status = FND_API.g_ret_sts_error THEN

1607:
1608: );
1609:
1610:
1611: IF x_return_status = FND_API.g_ret_sts_error THEN
1612: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,l_module,x_msg_data);
1614: END IF;
1615: RAISE FND_API.g_exc_error;

Line 1615: RAISE FND_API.g_exc_error;

1611: IF x_return_status = FND_API.g_ret_sts_error THEN
1612: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,l_module,x_msg_data);
1614: END IF;
1615: RAISE FND_API.g_exc_error;
1616: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1617: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,l_module,x_msg_data);
1619: END IF;

Line 1616: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1612: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1613: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,l_module,x_msg_data);
1614: END IF;
1615: RAISE FND_API.g_exc_error;
1616: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1617: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,l_module,x_msg_data);
1619: END IF;
1620: RAISE FND_API.g_exc_unexpected_error;

Line 1620: RAISE FND_API.g_exc_unexpected_error;

1616: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1617: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1618: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,l_module,x_msg_data);
1619: END IF;
1620: RAISE FND_API.g_exc_unexpected_error;
1621: END IF;
1622:
1623: l_old_group_name_len := length(l_cust_partner_rec.SOURCE_NAME) - length(SUBSTR(l_cust_partner_rec.PARTY_NAME,length(l_cust_partner_rec.PARTY_NAME_R)+1));
1624: l_old_group_name := SUBSTR(l_cust_partner_rec.SOURCE_NAME, 0,l_old_group_name_len);

Line 1645: IF x_return_status = FND_API.g_ret_sts_error THEN

1641: X_MSG_COUNT => x_msg_count,
1642: X_MSG_DATA => x_msg_data
1643: );
1644:
1645: IF x_return_status = FND_API.g_ret_sts_error THEN
1646: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,l_module,x_msg_data);
1648: END IF;
1649: RAISE FND_API.g_exc_error;

Line 1649: RAISE FND_API.g_exc_error;

1645: IF x_return_status = FND_API.g_ret_sts_error THEN
1646: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,l_module,x_msg_data);
1648: END IF;
1649: RAISE FND_API.g_exc_error;
1650: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1651: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1652: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,l_module,x_msg_data);
1653: END IF;

Line 1650: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1646: IF(FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1647: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,l_module,x_msg_data);
1648: END IF;
1649: RAISE FND_API.g_exc_error;
1650: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1651: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1652: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,l_module,x_msg_data);
1653: END IF;
1654: RAISE FND_API.g_exc_unexpected_error;

Line 1654: RAISE FND_API.g_exc_unexpected_error;

1650: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1651: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1652: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,l_module,x_msg_data);
1653: END IF;
1654: RAISE FND_API.g_exc_unexpected_error;
1655: END IF;
1656: END LOOP;
1657:
1658: END LOOP;

Line 1741: x_return_status := FND_API.G_RET_STS_SUCCESS;

1737: -- Standard Start of API savepoint
1738: SAVEPOINT CTeam_PartySite_Update_pub;
1739:
1740: -- Initialize API return status to SUCCESS
1741: x_return_status := FND_API.G_RET_STS_SUCCESS;
1742:
1743: -- Check if the supplied party_site_id point to a Partner or a Customer.
1744: -- If it's point to a PARTNER Org, then there should be a record exists in
1745: -- PV_PARTNER_PROFILES table.

Line 1763: p_init_msg_list => FND_API.G_FALSE,

1759:
1760: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1761: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1762: p_api_version_number => 1.0 ,
1763: p_init_msg_list => FND_API.G_FALSE,
1764: p_commit => FND_API.G_FALSE,
1765: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1766: x_return_status => l_return_status,
1767: x_msg_count => l_msg_count,

Line 1764: p_commit => FND_API.G_FALSE,

1760: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1761: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1762: p_api_version_number => 1.0 ,
1763: p_init_msg_list => FND_API.G_FALSE,
1764: p_commit => FND_API.G_FALSE,
1765: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1766: x_return_status => l_return_status,
1767: x_msg_count => l_msg_count,
1768: x_msg_data => l_msg_data,

Line 1765: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1761: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1762: p_api_version_number => 1.0 ,
1763: p_init_msg_list => FND_API.G_FALSE,
1764: p_commit => FND_API.G_FALSE,
1765: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1766: x_return_status => l_return_status,
1767: x_msg_count => l_msg_count,
1768: x_msg_data => l_msg_data,
1769: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

Line 1772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1768: x_msg_data => l_msg_data,
1769: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1770: x_partner_id => l_partner_id );
1771:
1772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1769: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1770: x_partner_id => l_partner_id );
1771:
1772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777: END IF;

Line 1774: RAISE FND_API.G_EXC_ERROR;

1770: x_partner_id => l_partner_id );
1771:
1772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777: END IF;
1778: END IF;

Line 1775: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1771:
1772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777: END IF;
1778: END IF;
1779: ELSE

Line 1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1772: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1773: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1774: RAISE FND_API.G_EXC_ERROR;
1775: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1777: END IF;
1778: END IF;
1779: ELSE
1780: CLOSE l_chng_partner_exist_csr;

Line 1785: ,p_init_msg_list => FND_API.G_FALSE

1781: IF (l_processed_flag <> 'P') THEN
1782: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1783: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1784: p_api_version_number => 1.0
1785: ,p_init_msg_list => FND_API.G_FALSE
1786: ,p_commit => FND_API.G_FALSE
1787: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1788: ,x_return_status => l_return_status
1789: ,x_msg_count => l_msg_count

Line 1786: ,p_commit => FND_API.G_FALSE

1782: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1783: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1784: p_api_version_number => 1.0
1785: ,p_init_msg_list => FND_API.G_FALSE
1786: ,p_commit => FND_API.G_FALSE
1787: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1788: ,x_return_status => l_return_status
1789: ,x_msg_count => l_msg_count
1790: ,x_msg_data => l_msg_data

Line 1787: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1783: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1784: p_api_version_number => 1.0
1785: ,p_init_msg_list => FND_API.G_FALSE
1786: ,p_commit => FND_API.G_FALSE
1787: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1788: ,x_return_status => l_return_status
1789: ,x_msg_count => l_msg_count
1790: ,x_msg_data => l_msg_data
1791: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

Line 1793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1789: ,x_msg_count => l_msg_count
1790: ,x_msg_data => l_msg_data
1791: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1792:
1793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1794: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 1794: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1790: ,x_msg_data => l_msg_data
1791: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1792:
1793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1794: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1798: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 1795: RAISE FND_API.G_EXC_ERROR;

1791: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1792:
1793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1794: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1798: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1799: FND_MSG_PUB.Add;

Line 1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1792:
1793: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1794: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1795: RAISE FND_API.G_EXC_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1798: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1799: FND_MSG_PUB.Add;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1796: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1798: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1799: FND_MSG_PUB.Add;
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: END IF;
1802: END IF;
1803:
1804: END IF; --l_processed_flag <> 'P'

Line 1811: WHEN FND_API.g_exc_error THEN

1807: CLOSE l_cust_is_partner_csr;
1808: END IF; -- l_cust_is_partner_csr%FOUND
1809:
1810: EXCEPTION
1811: WHEN FND_API.g_exc_error THEN
1812: ROLLBACK TO CTeam_PartySite_Update_pub;
1813: x_return_status := FND_API.g_ret_sts_error;
1814:
1815: FND_MSG_PUB.count_and_get (

Line 1813: x_return_status := FND_API.g_ret_sts_error;

1809:
1810: EXCEPTION
1811: WHEN FND_API.g_exc_error THEN
1812: ROLLBACK TO CTeam_PartySite_Update_pub;
1813: x_return_status := FND_API.g_ret_sts_error;
1814:
1815: FND_MSG_PUB.count_and_get (
1816: p_encoded => FND_API.g_false
1817: ,p_count => x_msg_count

Line 1816: p_encoded => FND_API.g_false

1812: ROLLBACK TO CTeam_PartySite_Update_pub;
1813: x_return_status := FND_API.g_ret_sts_error;
1814:
1815: FND_MSG_PUB.count_and_get (
1816: p_encoded => FND_API.g_false
1817: ,p_count => x_msg_count
1818: ,p_data => x_msg_data
1819: );
1820:

Line 1828: WHEN FND_API.g_exc_unexpected_error THEN

1824: x_msg_count, x_msg_data, 'ERROR');
1825: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1826: END IF;
1827:
1828: WHEN FND_API.g_exc_unexpected_error THEN
1829: ROLLBACK TO CTeam_PartySite_Update_pub;
1830: x_return_status := FND_API.g_ret_sts_unexp_error ;
1831:
1832: FND_MSG_PUB.count_and_get (

Line 1830: x_return_status := FND_API.g_ret_sts_unexp_error ;

1826: END IF;
1827:
1828: WHEN FND_API.g_exc_unexpected_error THEN
1829: ROLLBACK TO CTeam_PartySite_Update_pub;
1830: x_return_status := FND_API.g_ret_sts_unexp_error ;
1831:
1832: FND_MSG_PUB.count_and_get (
1833: p_encoded => FND_API.g_false
1834: ,p_count => x_msg_count

Line 1833: p_encoded => FND_API.g_false

1829: ROLLBACK TO CTeam_PartySite_Update_pub;
1830: x_return_status := FND_API.g_ret_sts_unexp_error ;
1831:
1832: FND_MSG_PUB.count_and_get (
1833: p_encoded => FND_API.g_false
1834: ,p_count => x_msg_count
1835: ,p_data => x_msg_data
1836: );
1837: -- Debug Message

Line 1846: x_return_status := FND_API.g_ret_sts_unexp_error ;

1842: END IF;
1843:
1844: WHEN OTHERS THEN
1845: ROLLBACK TO Update_Channel_Team_pub;
1846: x_return_status := FND_API.g_ret_sts_unexp_error ;
1847:
1848: FND_MSG_PUB.count_and_get(
1849: p_encoded => FND_API.g_false
1850: ,p_count => x_msg_count

Line 1849: p_encoded => FND_API.g_false

1845: ROLLBACK TO Update_Channel_Team_pub;
1846: x_return_status := FND_API.g_ret_sts_unexp_error ;
1847:
1848: FND_MSG_PUB.count_and_get(
1849: p_encoded => FND_API.g_false
1850: ,p_count => x_msg_count
1851: ,p_data => x_msg_data
1852: );
1853:

Line 1940: x_return_status := FND_API.G_RET_STS_SUCCESS;

1936:
1937: BEGIN
1938:
1939: -- Initialize API return status to SUCCESS
1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: -- Check if the supplied party_id point to a Partner or a Customer.
1943: -- If it's point to a PARTNER Org, then there should be a record exists in
1944: -- PV_PARTNER_PROFILES table.

Line 1971: p_init_msg_list => FND_API.G_FALSE,

1967:
1968: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1969: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1970: p_api_version_number => 1.0 ,
1971: p_init_msg_list => FND_API.G_FALSE,
1972: p_commit => FND_API.G_FALSE,
1973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1974: x_return_status => l_return_status,
1975: x_msg_count => l_msg_count,

Line 1972: p_commit => FND_API.G_FALSE,

1968: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1969: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1970: p_api_version_number => 1.0 ,
1971: p_init_msg_list => FND_API.G_FALSE,
1972: p_commit => FND_API.G_FALSE,
1973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1974: x_return_status => l_return_status,
1975: x_msg_count => l_msg_count,
1976: x_msg_data => l_msg_data,

Line 1973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1969: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1970: p_api_version_number => 1.0 ,
1971: p_init_msg_list => FND_API.G_FALSE,
1972: p_commit => FND_API.G_FALSE,
1973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1974: x_return_status => l_return_status,
1975: x_msg_count => l_msg_count,
1976: x_msg_data => l_msg_data,
1977: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

Line 1980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1976: x_msg_data => l_msg_data,
1977: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1978: x_partner_id => l_partner_id );
1979:
1980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1977: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1978: x_partner_id => l_partner_id );
1979:
1980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1985: END IF;

Line 1982: RAISE FND_API.G_EXC_ERROR;

1978: x_partner_id => l_partner_id );
1979:
1980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1985: END IF;
1986: END IF;

Line 1983: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1979:
1980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1985: END IF;
1986: END IF;
1987: ELSE

Line 1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1980: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1981: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1982: RAISE FND_API.G_EXC_ERROR;
1983: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1985: END IF;
1986: END IF;
1987: ELSE
1988: CLOSE l_chng_partner_exist_csr;

Line 1993: ,p_init_msg_list => FND_API.G_FALSE

1989: IF (l_processed_flag <> 'P') THEN
1990: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1991: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1992: p_api_version_number => 1.0
1993: ,p_init_msg_list => FND_API.G_FALSE
1994: ,p_commit => FND_API.G_FALSE
1995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1996: ,x_return_status => l_return_status
1997: ,x_msg_count => l_msg_count

Line 1994: ,p_commit => FND_API.G_FALSE

1990: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1991: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1992: p_api_version_number => 1.0
1993: ,p_init_msg_list => FND_API.G_FALSE
1994: ,p_commit => FND_API.G_FALSE
1995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1996: ,x_return_status => l_return_status
1997: ,x_msg_count => l_msg_count
1998: ,x_msg_data => l_msg_data

Line 1995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1991: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1992: p_api_version_number => 1.0
1993: ,p_init_msg_list => FND_API.G_FALSE
1994: ,p_commit => FND_API.G_FALSE
1995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1996: ,x_return_status => l_return_status
1997: ,x_msg_count => l_msg_count
1998: ,x_msg_data => l_msg_data
1999: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

Line 2001: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1997: ,x_msg_count => l_msg_count
1998: ,x_msg_data => l_msg_data
1999: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2000:
2001: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 2002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1998: ,x_msg_data => l_msg_data
1999: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2000:
2001: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2006: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 2003: RAISE FND_API.G_EXC_ERROR;

1999: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2000:
2001: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2006: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2007: FND_MSG_PUB.Add;

Line 2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2000:
2001: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2003: RAISE FND_API.G_EXC_ERROR;
2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2006: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2007: FND_MSG_PUB.Add;
2008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2005: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2006: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2007: FND_MSG_PUB.Add;
2008: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2009: END IF;
2010: END IF;
2011:
2012: END IF; --l_processed_flag <> 'P'

Line 2019: WHEN FND_API.g_exc_error THEN

2015: ELSE
2016: CLOSE l_cust_is_partner_csr;
2017: END IF; -- l_cust_is_partner_csr%FOUND
2018: EXCEPTION
2019: WHEN FND_API.g_exc_error THEN
2020: ROLLBACK TO Update_Channel_Team_pub;
2021: x_return_status := FND_API.g_ret_sts_error;
2022:
2023: FND_MSG_PUB.count_and_get (

Line 2021: x_return_status := FND_API.g_ret_sts_error;

2017: END IF; -- l_cust_is_partner_csr%FOUND
2018: EXCEPTION
2019: WHEN FND_API.g_exc_error THEN
2020: ROLLBACK TO Update_Channel_Team_pub;
2021: x_return_status := FND_API.g_ret_sts_error;
2022:
2023: FND_MSG_PUB.count_and_get (
2024: p_encoded => FND_API.g_false
2025: ,p_count => x_msg_count

Line 2024: p_encoded => FND_API.g_false

2020: ROLLBACK TO Update_Channel_Team_pub;
2021: x_return_status := FND_API.g_ret_sts_error;
2022:
2023: FND_MSG_PUB.count_and_get (
2024: p_encoded => FND_API.g_false
2025: ,p_count => x_msg_count
2026: ,p_data => x_msg_data
2027: );
2028:

Line 2036: WHEN FND_API.g_exc_unexpected_error THEN

2032: x_msg_count, x_msg_data, 'ERROR');
2033: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
2034: END IF;
2035:
2036: WHEN FND_API.g_exc_unexpected_error THEN
2037: ROLLBACK TO Update_Channel_Team_pub;
2038: x_return_status := FND_API.g_ret_sts_unexp_error ;
2039:
2040: FND_MSG_PUB.count_and_get (

Line 2038: x_return_status := FND_API.g_ret_sts_unexp_error ;

2034: END IF;
2035:
2036: WHEN FND_API.g_exc_unexpected_error THEN
2037: ROLLBACK TO Update_Channel_Team_pub;
2038: x_return_status := FND_API.g_ret_sts_unexp_error ;
2039:
2040: FND_MSG_PUB.count_and_get (
2041: p_encoded => FND_API.g_false
2042: ,p_count => x_msg_count

Line 2041: p_encoded => FND_API.g_false

2037: ROLLBACK TO Update_Channel_Team_pub;
2038: x_return_status := FND_API.g_ret_sts_unexp_error ;
2039:
2040: FND_MSG_PUB.count_and_get (
2041: p_encoded => FND_API.g_false
2042: ,p_count => x_msg_count
2043: ,p_data => x_msg_data
2044: );
2045: -- Debug Message

Line 2054: x_return_status := FND_API.g_ret_sts_unexp_error ;

2050: END IF;
2051:
2052: WHEN OTHERS THEN
2053: ROLLBACK TO Update_Channel_Team_pub;
2054: x_return_status := FND_API.g_ret_sts_unexp_error ;
2055:
2056: FND_MSG_PUB.count_and_get(
2057: p_encoded => FND_API.g_false
2058: ,p_count => x_msg_count

Line 2057: p_encoded => FND_API.g_false

2053: ROLLBACK TO Update_Channel_Team_pub;
2054: x_return_status := FND_API.g_ret_sts_unexp_error ;
2055:
2056: FND_MSG_PUB.count_and_get(
2057: p_encoded => FND_API.g_false
2058: ,p_count => x_msg_count
2059: ,p_data => x_msg_data
2060: );
2061:

Line 2176: x_return_status := FND_API.G_RET_STS_SUCCESS;

2172:
2173: BEGIN
2174:
2175: -- Initialize API return status to SUCCESS
2176: x_return_status := FND_API.G_RET_STS_SUCCESS;
2177:
2178: -- Check if the supplied party_id point to a Partner or a Customer.
2179: -- If it's point to a PARTNER Org, then there should be a record exists in
2180: -- PV_PARTNER_PROFILES table.

Line 2200: p_init_msg_list => FND_API.G_FALSE,

2196:
2197: -- Call Channel_Team_Organization_Update to re-assign the Channel team
2198: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2199: p_api_version_number => 1.0 ,
2200: p_init_msg_list => FND_API.G_FALSE,
2201: p_commit => FND_API.G_FALSE,
2202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2203: x_return_status => l_return_status,
2204: x_msg_count => l_msg_count,

Line 2201: p_commit => FND_API.G_FALSE,

2197: -- Call Channel_Team_Organization_Update to re-assign the Channel team
2198: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2199: p_api_version_number => 1.0 ,
2200: p_init_msg_list => FND_API.G_FALSE,
2201: p_commit => FND_API.G_FALSE,
2202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2203: x_return_status => l_return_status,
2204: x_msg_count => l_msg_count,
2205: x_msg_data => l_msg_data,

Line 2202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2198: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2199: p_api_version_number => 1.0 ,
2200: p_init_msg_list => FND_API.G_FALSE,
2201: p_commit => FND_API.G_FALSE,
2202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2203: x_return_status => l_return_status,
2204: x_msg_count => l_msg_count,
2205: x_msg_data => l_msg_data,
2206: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

Line 2209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2205: x_msg_data => l_msg_data,
2206: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
2207: x_partner_id => l_partner_id );
2208:
2209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2206: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
2207: x_partner_id => l_partner_id );
2208:
2209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;

Line 2211: RAISE FND_API.G_EXC_ERROR;

2207: x_partner_id => l_partner_id );
2208:
2209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: END IF;

Line 2212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2208:
2209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: END IF;
2216: ELSE

Line 2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2209: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2211: RAISE FND_API.G_EXC_ERROR;
2212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2214: END IF;
2215: END IF;
2216: ELSE
2217: CLOSE l_chng_partner_exist_csr;

Line 2224: ,p_init_msg_list => FND_API.G_FALSE

2220: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
2221:
2222: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2223: p_api_version_number => 1.0
2224: ,p_init_msg_list => FND_API.G_FALSE
2225: ,p_commit => FND_API.G_FALSE
2226: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2227: ,x_return_status => l_return_status
2228: ,x_msg_count => l_msg_count

Line 2225: ,p_commit => FND_API.G_FALSE

2221:
2222: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2223: p_api_version_number => 1.0
2224: ,p_init_msg_list => FND_API.G_FALSE
2225: ,p_commit => FND_API.G_FALSE
2226: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2227: ,x_return_status => l_return_status
2228: ,x_msg_count => l_msg_count
2229: ,x_msg_data => l_msg_data

Line 2226: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2222: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2223: p_api_version_number => 1.0
2224: ,p_init_msg_list => FND_API.G_FALSE
2225: ,p_commit => FND_API.G_FALSE
2226: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2227: ,x_return_status => l_return_status
2228: ,x_msg_count => l_msg_count
2229: ,x_msg_data => l_msg_data
2230: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

Line 2232: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

2228: ,x_msg_count => l_msg_count
2229: ,x_msg_data => l_msg_data
2230: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2231:
2232: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2234: RAISE FND_API.G_EXC_ERROR;
2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 2233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2229: ,x_msg_data => l_msg_data
2230: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2231:
2232: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2234: RAISE FND_API.G_EXC_ERROR;
2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2237: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 2234: RAISE FND_API.G_EXC_ERROR;

2230: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2231:
2232: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2234: RAISE FND_API.G_EXC_ERROR;
2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2237: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2238: FND_MSG_PUB.Add;

Line 2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2231:
2232: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2233: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2234: RAISE FND_API.G_EXC_ERROR;
2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2237: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2238: FND_MSG_PUB.Add;
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2235: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2237: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2238: FND_MSG_PUB.Add;
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240: END IF;
2241: END IF;
2242:
2243: END IF; --l_processed_flag <> 'P'

Line 2252: WHEN FND_API.g_exc_error THEN

2248: ELSE
2249: CLOSE l_cust_is_partner_csr;
2250: END IF; -- l_cust_is_partner_csr%FOUND
2251: EXCEPTION
2252: WHEN FND_API.g_exc_error THEN
2253: ROLLBACK TO Update_Channel_Team_pub;
2254: x_return_status := FND_API.g_ret_sts_error;
2255:
2256: FND_MSG_PUB.count_and_get (

Line 2254: x_return_status := FND_API.g_ret_sts_error;

2250: END IF; -- l_cust_is_partner_csr%FOUND
2251: EXCEPTION
2252: WHEN FND_API.g_exc_error THEN
2253: ROLLBACK TO Update_Channel_Team_pub;
2254: x_return_status := FND_API.g_ret_sts_error;
2255:
2256: FND_MSG_PUB.count_and_get (
2257: p_encoded => FND_API.g_false
2258: ,p_count => x_msg_count

Line 2257: p_encoded => FND_API.g_false

2253: ROLLBACK TO Update_Channel_Team_pub;
2254: x_return_status := FND_API.g_ret_sts_error;
2255:
2256: FND_MSG_PUB.count_and_get (
2257: p_encoded => FND_API.g_false
2258: ,p_count => x_msg_count
2259: ,p_data => x_msg_data
2260: );
2261:

Line 2269: WHEN FND_API.g_exc_unexpected_error THEN

2265: x_msg_count, x_msg_data, 'ERROR');
2266: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2267: END IF;
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: ROLLBACK TO Update_Channel_Team_pub;
2271: x_return_status := FND_API.g_ret_sts_unexp_error ;
2272:
2273: FND_MSG_PUB.count_and_get (

Line 2271: x_return_status := FND_API.g_ret_sts_unexp_error ;

2267: END IF;
2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: ROLLBACK TO Update_Channel_Team_pub;
2271: x_return_status := FND_API.g_ret_sts_unexp_error ;
2272:
2273: FND_MSG_PUB.count_and_get (
2274: p_encoded => FND_API.g_false
2275: ,p_count => x_msg_count

Line 2274: p_encoded => FND_API.g_false

2270: ROLLBACK TO Update_Channel_Team_pub;
2271: x_return_status := FND_API.g_ret_sts_unexp_error ;
2272:
2273: FND_MSG_PUB.count_and_get (
2274: p_encoded => FND_API.g_false
2275: ,p_count => x_msg_count
2276: ,p_data => x_msg_data
2277: );
2278: -- Debug Message

Line 2287: x_return_status := FND_API.g_ret_sts_unexp_error ;

2283: END IF;
2284:
2285: WHEN OTHERS THEN
2286: ROLLBACK TO Update_Channel_Team_pub;
2287: x_return_status := FND_API.g_ret_sts_unexp_error ;
2288:
2289: FND_MSG_PUB.count_and_get(
2290: p_encoded => FND_API.g_false
2291: ,p_count => x_msg_count

Line 2290: p_encoded => FND_API.g_false

2286: ROLLBACK TO Update_Channel_Team_pub;
2287: x_return_status := FND_API.g_ret_sts_unexp_error ;
2288:
2289: FND_MSG_PUB.count_and_get(
2290: p_encoded => FND_API.g_false
2291: ,p_count => x_msg_count
2292: ,p_data => x_msg_data
2293: );
2294: