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 1570: x_return_status := FND_API.G_RET_STS_SUCCESS;

1566: -- Standard Start of API savepoint
1567: SAVEPOINT CTeam_PartySite_Update_pub;
1568:
1569: -- Initialize API return status to SUCCESS
1570: x_return_status := FND_API.G_RET_STS_SUCCESS;
1571:
1572: -- Check if the supplied party_site_id point to a Partner or a Customer.
1573: -- If it's point to a PARTNER Org, then there should be a record exists in
1574: -- PV_PARTNER_PROFILES table.

Line 1592: p_init_msg_list => FND_API.G_FALSE,

1588:
1589: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1590: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1591: p_api_version_number => 1.0 ,
1592: p_init_msg_list => FND_API.G_FALSE,
1593: p_commit => FND_API.G_FALSE,
1594: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1595: x_return_status => l_return_status,
1596: x_msg_count => l_msg_count,

Line 1593: p_commit => FND_API.G_FALSE,

1589: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1590: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1591: p_api_version_number => 1.0 ,
1592: p_init_msg_list => FND_API.G_FALSE,
1593: p_commit => FND_API.G_FALSE,
1594: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1595: x_return_status => l_return_status,
1596: x_msg_count => l_msg_count,
1597: x_msg_data => l_msg_data,

Line 1594: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1590: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1591: p_api_version_number => 1.0 ,
1592: p_init_msg_list => FND_API.G_FALSE,
1593: p_commit => FND_API.G_FALSE,
1594: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1595: x_return_status => l_return_status,
1596: x_msg_count => l_msg_count,
1597: x_msg_data => l_msg_data,
1598: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

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

1597: x_msg_data => l_msg_data,
1598: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1599: x_partner_id => l_partner_id );
1600:
1601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1603: RAISE FND_API.G_EXC_ERROR;
1604: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1598: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1599: x_partner_id => l_partner_id );
1600:
1601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1603: RAISE FND_API.G_EXC_ERROR;
1604: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;

Line 1603: RAISE FND_API.G_EXC_ERROR;

1599: x_partner_id => l_partner_id );
1600:
1601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1603: RAISE FND_API.G_EXC_ERROR;
1604: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: END IF;

Line 1604: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1600:
1601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1603: RAISE FND_API.G_EXC_ERROR;
1604: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: END IF;
1608: ELSE

Line 1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1601: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1602: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1603: RAISE FND_API.G_EXC_ERROR;
1604: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1606: END IF;
1607: END IF;
1608: ELSE
1609: CLOSE l_chng_partner_exist_csr;

Line 1614: ,p_init_msg_list => FND_API.G_FALSE

1610: IF (l_processed_flag <> 'P') THEN
1611: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1612: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1613: p_api_version_number => 1.0
1614: ,p_init_msg_list => FND_API.G_FALSE
1615: ,p_commit => FND_API.G_FALSE
1616: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1617: ,x_return_status => l_return_status
1618: ,x_msg_count => l_msg_count

Line 1615: ,p_commit => FND_API.G_FALSE

1611: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1612: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1613: p_api_version_number => 1.0
1614: ,p_init_msg_list => FND_API.G_FALSE
1615: ,p_commit => FND_API.G_FALSE
1616: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1617: ,x_return_status => l_return_status
1618: ,x_msg_count => l_msg_count
1619: ,x_msg_data => l_msg_data

Line 1616: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1612: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1613: p_api_version_number => 1.0
1614: ,p_init_msg_list => FND_API.G_FALSE
1615: ,p_commit => FND_API.G_FALSE
1616: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1617: ,x_return_status => l_return_status
1618: ,x_msg_count => l_msg_count
1619: ,x_msg_data => l_msg_data
1620: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

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

1618: ,x_msg_count => l_msg_count
1619: ,x_msg_data => l_msg_data
1620: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1621:
1622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1619: ,x_msg_data => l_msg_data
1620: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1621:
1622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 1624: RAISE FND_API.G_EXC_ERROR;

1620: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1621:
1622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1628: FND_MSG_PUB.Add;

Line 1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1621:
1622: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1623: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1628: FND_MSG_PUB.Add;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1625: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1626: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1627: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1628: FND_MSG_PUB.Add;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END IF;
1631: END IF;
1632:
1633: END IF; --l_processed_flag <> 'P'

Line 1640: WHEN FND_API.g_exc_error THEN

1636: CLOSE l_cust_is_partner_csr;
1637: END IF; -- l_cust_is_partner_csr%FOUND
1638:
1639: EXCEPTION
1640: WHEN FND_API.g_exc_error THEN
1641: ROLLBACK TO CTeam_PartySite_Update_pub;
1642: x_return_status := FND_API.g_ret_sts_error;
1643:
1644: FND_MSG_PUB.count_and_get (

Line 1642: x_return_status := FND_API.g_ret_sts_error;

1638:
1639: EXCEPTION
1640: WHEN FND_API.g_exc_error THEN
1641: ROLLBACK TO CTeam_PartySite_Update_pub;
1642: x_return_status := FND_API.g_ret_sts_error;
1643:
1644: FND_MSG_PUB.count_and_get (
1645: p_encoded => FND_API.g_false
1646: ,p_count => x_msg_count

Line 1645: p_encoded => FND_API.g_false

1641: ROLLBACK TO CTeam_PartySite_Update_pub;
1642: x_return_status := FND_API.g_ret_sts_error;
1643:
1644: FND_MSG_PUB.count_and_get (
1645: p_encoded => FND_API.g_false
1646: ,p_count => x_msg_count
1647: ,p_data => x_msg_data
1648: );
1649:

Line 1657: WHEN FND_API.g_exc_unexpected_error THEN

1653: x_msg_count, x_msg_data, 'ERROR');
1654: hz_utility_v2pub.debug('CTeam_PartySite_Update (-)');
1655: END IF;
1656:
1657: WHEN FND_API.g_exc_unexpected_error THEN
1658: ROLLBACK TO CTeam_PartySite_Update_pub;
1659: x_return_status := FND_API.g_ret_sts_unexp_error ;
1660:
1661: FND_MSG_PUB.count_and_get (

Line 1659: x_return_status := FND_API.g_ret_sts_unexp_error ;

1655: END IF;
1656:
1657: WHEN FND_API.g_exc_unexpected_error THEN
1658: ROLLBACK TO CTeam_PartySite_Update_pub;
1659: x_return_status := FND_API.g_ret_sts_unexp_error ;
1660:
1661: FND_MSG_PUB.count_and_get (
1662: p_encoded => FND_API.g_false
1663: ,p_count => x_msg_count

Line 1662: p_encoded => FND_API.g_false

1658: ROLLBACK TO CTeam_PartySite_Update_pub;
1659: x_return_status := FND_API.g_ret_sts_unexp_error ;
1660:
1661: FND_MSG_PUB.count_and_get (
1662: p_encoded => FND_API.g_false
1663: ,p_count => x_msg_count
1664: ,p_data => x_msg_data
1665: );
1666: -- Debug Message

Line 1675: x_return_status := FND_API.g_ret_sts_unexp_error ;

1671: END IF;
1672:
1673: WHEN OTHERS THEN
1674: ROLLBACK TO Update_Channel_Team_pub;
1675: x_return_status := FND_API.g_ret_sts_unexp_error ;
1676:
1677: FND_MSG_PUB.count_and_get(
1678: p_encoded => FND_API.g_false
1679: ,p_count => x_msg_count

Line 1678: p_encoded => FND_API.g_false

1674: ROLLBACK TO Update_Channel_Team_pub;
1675: x_return_status := FND_API.g_ret_sts_unexp_error ;
1676:
1677: FND_MSG_PUB.count_and_get(
1678: p_encoded => FND_API.g_false
1679: ,p_count => x_msg_count
1680: ,p_data => x_msg_data
1681: );
1682:

Line 1769: x_return_status := FND_API.G_RET_STS_SUCCESS;

1765:
1766: BEGIN
1767:
1768: -- Initialize API return status to SUCCESS
1769: x_return_status := FND_API.G_RET_STS_SUCCESS;
1770:
1771: -- Check if the supplied party_id point to a Partner or a Customer.
1772: -- If it's point to a PARTNER Org, then there should be a record exists in
1773: -- PV_PARTNER_PROFILES table.

Line 1800: p_init_msg_list => FND_API.G_FALSE,

1796:
1797: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1798: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1799: p_api_version_number => 1.0 ,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1803: x_return_status => l_return_status,
1804: x_msg_count => l_msg_count,

Line 1801: p_commit => FND_API.G_FALSE,

1797: -- Call Channel_Team_Organization_Update to re-assign the Channel team
1798: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1799: p_api_version_number => 1.0 ,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1803: x_return_status => l_return_status,
1804: x_msg_count => l_msg_count,
1805: x_msg_data => l_msg_data,

Line 1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1798: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
1799: p_api_version_number => 1.0 ,
1800: p_init_msg_list => FND_API.G_FALSE,
1801: p_commit => FND_API.G_FALSE,
1802: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1803: x_return_status => l_return_status,
1804: x_msg_count => l_msg_count,
1805: x_msg_data => l_msg_data,
1806: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

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

1805: x_msg_data => l_msg_data,
1806: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1807: x_partner_id => l_partner_id );
1808:
1809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1806: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
1807: x_partner_id => l_partner_id );
1808:
1809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;

Line 1811: RAISE FND_API.G_EXC_ERROR;

1807: x_partner_id => l_partner_id );
1808:
1809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;
1815: END IF;

Line 1812: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1808:
1809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;
1815: END IF;
1816: ELSE

Line 1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1809: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1811: RAISE FND_API.G_EXC_ERROR;
1812: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814: END IF;
1815: END IF;
1816: ELSE
1817: CLOSE l_chng_partner_exist_csr;

Line 1822: ,p_init_msg_list => FND_API.G_FALSE

1818: IF (l_processed_flag <> 'P') THEN
1819: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1820: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1821: p_api_version_number => 1.0
1822: ,p_init_msg_list => FND_API.G_FALSE
1823: ,p_commit => FND_API.G_FALSE
1824: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1825: ,x_return_status => l_return_status
1826: ,x_msg_count => l_msg_count

Line 1823: ,p_commit => FND_API.G_FALSE

1819: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
1820: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1821: p_api_version_number => 1.0
1822: ,p_init_msg_list => FND_API.G_FALSE
1823: ,p_commit => FND_API.G_FALSE
1824: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1825: ,x_return_status => l_return_status
1826: ,x_msg_count => l_msg_count
1827: ,x_msg_data => l_msg_data

Line 1824: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1820: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
1821: p_api_version_number => 1.0
1822: ,p_init_msg_list => FND_API.G_FALSE
1823: ,p_commit => FND_API.G_FALSE
1824: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1825: ,x_return_status => l_return_status
1826: ,x_msg_count => l_msg_count
1827: ,x_msg_data => l_msg_data
1828: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

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

1826: ,x_msg_count => l_msg_count
1827: ,x_msg_data => l_msg_data
1828: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1829:
1830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1827: ,x_msg_data => l_msg_data
1828: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1829:
1830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 1832: RAISE FND_API.G_EXC_ERROR;

1828: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
1829:
1830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1836: FND_MSG_PUB.Add;

Line 1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1829:
1830: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1831: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1832: RAISE FND_API.G_EXC_ERROR;
1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1836: FND_MSG_PUB.Add;
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1833: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1834: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
1835: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
1836: FND_MSG_PUB.Add;
1837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1838: END IF;
1839: END IF;
1840:
1841: END IF; --l_processed_flag <> 'P'

Line 1848: WHEN FND_API.g_exc_error THEN

1844: ELSE
1845: CLOSE l_cust_is_partner_csr;
1846: END IF; -- l_cust_is_partner_csr%FOUND
1847: EXCEPTION
1848: WHEN FND_API.g_exc_error THEN
1849: ROLLBACK TO Update_Channel_Team_pub;
1850: x_return_status := FND_API.g_ret_sts_error;
1851:
1852: FND_MSG_PUB.count_and_get (

Line 1850: x_return_status := FND_API.g_ret_sts_error;

1846: END IF; -- l_cust_is_partner_csr%FOUND
1847: EXCEPTION
1848: WHEN FND_API.g_exc_error THEN
1849: ROLLBACK TO Update_Channel_Team_pub;
1850: x_return_status := FND_API.g_ret_sts_error;
1851:
1852: FND_MSG_PUB.count_and_get (
1853: p_encoded => FND_API.g_false
1854: ,p_count => x_msg_count

Line 1853: p_encoded => FND_API.g_false

1849: ROLLBACK TO Update_Channel_Team_pub;
1850: x_return_status := FND_API.g_ret_sts_error;
1851:
1852: FND_MSG_PUB.count_and_get (
1853: p_encoded => FND_API.g_false
1854: ,p_count => x_msg_count
1855: ,p_data => x_msg_data
1856: );
1857:

Line 1865: WHEN FND_API.g_exc_unexpected_error THEN

1861: x_msg_count, x_msg_data, 'ERROR');
1862: hz_utility_v2pub.debug('CTeam_Location_Update (-)');
1863: END IF;
1864:
1865: WHEN FND_API.g_exc_unexpected_error THEN
1866: ROLLBACK TO Update_Channel_Team_pub;
1867: x_return_status := FND_API.g_ret_sts_unexp_error ;
1868:
1869: FND_MSG_PUB.count_and_get (

Line 1867: x_return_status := FND_API.g_ret_sts_unexp_error ;

1863: END IF;
1864:
1865: WHEN FND_API.g_exc_unexpected_error THEN
1866: ROLLBACK TO Update_Channel_Team_pub;
1867: x_return_status := FND_API.g_ret_sts_unexp_error ;
1868:
1869: FND_MSG_PUB.count_and_get (
1870: p_encoded => FND_API.g_false
1871: ,p_count => x_msg_count

Line 1870: p_encoded => FND_API.g_false

1866: ROLLBACK TO Update_Channel_Team_pub;
1867: x_return_status := FND_API.g_ret_sts_unexp_error ;
1868:
1869: FND_MSG_PUB.count_and_get (
1870: p_encoded => FND_API.g_false
1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data
1873: );
1874: -- Debug Message

Line 1883: x_return_status := FND_API.g_ret_sts_unexp_error ;

1879: END IF;
1880:
1881: WHEN OTHERS THEN
1882: ROLLBACK TO Update_Channel_Team_pub;
1883: x_return_status := FND_API.g_ret_sts_unexp_error ;
1884:
1885: FND_MSG_PUB.count_and_get(
1886: p_encoded => FND_API.g_false
1887: ,p_count => x_msg_count

Line 1886: p_encoded => FND_API.g_false

1882: ROLLBACK TO Update_Channel_Team_pub;
1883: x_return_status := FND_API.g_ret_sts_unexp_error ;
1884:
1885: FND_MSG_PUB.count_and_get(
1886: p_encoded => FND_API.g_false
1887: ,p_count => x_msg_count
1888: ,p_data => x_msg_data
1889: );
1890:

Line 2005: x_return_status := FND_API.G_RET_STS_SUCCESS;

2001:
2002: BEGIN
2003:
2004: -- Initialize API return status to SUCCESS
2005: x_return_status := FND_API.G_RET_STS_SUCCESS;
2006:
2007: -- Check if the supplied party_id point to a Partner or a Customer.
2008: -- If it's point to a PARTNER Org, then there should be a record exists in
2009: -- PV_PARTNER_PROFILES table.

Line 2029: p_init_msg_list => FND_API.G_FALSE,

2025:
2026: -- Call Channel_Team_Organization_Update to re-assign the Channel team
2027: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2028: p_api_version_number => 1.0 ,
2029: p_init_msg_list => FND_API.G_FALSE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: x_return_status => l_return_status,
2033: x_msg_count => l_msg_count,

Line 2030: p_commit => FND_API.G_FALSE,

2026: -- Call Channel_Team_Organization_Update to re-assign the Channel team
2027: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2028: p_api_version_number => 1.0 ,
2029: p_init_msg_list => FND_API.G_FALSE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: x_return_status => l_return_status,
2033: x_msg_count => l_msg_count,
2034: x_msg_data => l_msg_data,

Line 2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2027: PV_BATCH_CHG_PRTNR_PVT.Create_Batch_Chg_Partners(
2028: p_api_version_number => 1.0 ,
2029: p_init_msg_list => FND_API.G_FALSE,
2030: p_commit => FND_API.G_FALSE,
2031: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2032: x_return_status => l_return_status,
2033: x_msg_count => l_msg_count,
2034: x_msg_data => l_msg_data,
2035: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,

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

2034: x_msg_data => l_msg_data,
2035: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
2036: x_partner_id => l_partner_id );
2037:
2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: RAISE FND_API.G_EXC_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2039: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2035: p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec,
2036: x_partner_id => l_partner_id );
2037:
2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: RAISE FND_API.G_EXC_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2043: END IF;

Line 2040: RAISE FND_API.G_EXC_ERROR;

2036: x_partner_id => l_partner_id );
2037:
2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: RAISE FND_API.G_EXC_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2043: END IF;
2044: END IF;

Line 2041: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2037:
2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: RAISE FND_API.G_EXC_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2043: END IF;
2044: END IF;
2045: ELSE

Line 2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2038: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2039: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2040: RAISE FND_API.G_EXC_ERROR;
2041: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2043: END IF;
2044: END IF;
2045: ELSE
2046: CLOSE l_chng_partner_exist_csr;

Line 2053: ,p_init_msg_list => FND_API.G_FALSE

2049: l_batch_chg_prtnrs_rec.object_version_number := l_object_version;
2050:
2051: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2052: p_api_version_number => 1.0
2053: ,p_init_msg_list => FND_API.G_FALSE
2054: ,p_commit => FND_API.G_FALSE
2055: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2056: ,x_return_status => l_return_status
2057: ,x_msg_count => l_msg_count

Line 2054: ,p_commit => FND_API.G_FALSE

2050:
2051: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2052: p_api_version_number => 1.0
2053: ,p_init_msg_list => FND_API.G_FALSE
2054: ,p_commit => FND_API.G_FALSE
2055: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2056: ,x_return_status => l_return_status
2057: ,x_msg_count => l_msg_count
2058: ,x_msg_data => l_msg_data

Line 2055: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2051: PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners(
2052: p_api_version_number => 1.0
2053: ,p_init_msg_list => FND_API.G_FALSE
2054: ,p_commit => FND_API.G_FALSE
2055: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2056: ,x_return_status => l_return_status
2057: ,x_msg_count => l_msg_count
2058: ,x_msg_data => l_msg_data
2059: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);

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

2057: ,x_msg_count => l_msg_count
2058: ,x_msg_data => l_msg_data
2059: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2060:
2061: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');

Line 2062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2058: ,x_msg_data => l_msg_data
2059: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2060:
2061: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');

Line 2063: RAISE FND_API.G_EXC_ERROR;

2059: ,p_batch_chg_prtnrs_rec => l_batch_chg_prtnrs_rec);
2060:
2061: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2067: FND_MSG_PUB.Add;

Line 2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2060:
2061: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2062: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2063: RAISE FND_API.G_EXC_ERROR;
2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2067: FND_MSG_PUB.Add;
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2064: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2065: FND_MESSAGE.SET_NAME('PV', 'PV_API_FAILED');
2066: FND_MESSAGE.SET_TOKEN('API_NAME', 'PV_BATCH_CHG_PRTNR_PVT.Update_Batch_Chg_Partners');
2067: FND_MSG_PUB.Add;
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2069: END IF;
2070: END IF;
2071:
2072: END IF; --l_processed_flag <> 'P'

Line 2081: WHEN FND_API.g_exc_error THEN

2077: ELSE
2078: CLOSE l_cust_is_partner_csr;
2079: END IF; -- l_cust_is_partner_csr%FOUND
2080: EXCEPTION
2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO Update_Channel_Team_pub;
2083: x_return_status := FND_API.g_ret_sts_error;
2084:
2085: FND_MSG_PUB.count_and_get (

Line 2083: x_return_status := FND_API.g_ret_sts_error;

2079: END IF; -- l_cust_is_partner_csr%FOUND
2080: EXCEPTION
2081: WHEN FND_API.g_exc_error THEN
2082: ROLLBACK TO Update_Channel_Team_pub;
2083: x_return_status := FND_API.g_ret_sts_error;
2084:
2085: FND_MSG_PUB.count_and_get (
2086: p_encoded => FND_API.g_false
2087: ,p_count => x_msg_count

Line 2086: p_encoded => FND_API.g_false

2082: ROLLBACK TO Update_Channel_Team_pub;
2083: x_return_status := FND_API.g_ret_sts_error;
2084:
2085: FND_MSG_PUB.count_and_get (
2086: p_encoded => FND_API.g_false
2087: ,p_count => x_msg_count
2088: ,p_data => x_msg_data
2089: );
2090:

Line 2098: WHEN FND_API.g_exc_unexpected_error THEN

2094: x_msg_count, x_msg_data, 'ERROR');
2095: hz_utility_v2pub.debug('CTeam_ContPoint_Update (-)');
2096: END IF;
2097:
2098: WHEN FND_API.g_exc_unexpected_error THEN
2099: ROLLBACK TO Update_Channel_Team_pub;
2100: x_return_status := FND_API.g_ret_sts_unexp_error ;
2101:
2102: FND_MSG_PUB.count_and_get (

Line 2100: x_return_status := FND_API.g_ret_sts_unexp_error ;

2096: END IF;
2097:
2098: WHEN FND_API.g_exc_unexpected_error THEN
2099: ROLLBACK TO Update_Channel_Team_pub;
2100: x_return_status := FND_API.g_ret_sts_unexp_error ;
2101:
2102: FND_MSG_PUB.count_and_get (
2103: p_encoded => FND_API.g_false
2104: ,p_count => x_msg_count

Line 2103: p_encoded => FND_API.g_false

2099: ROLLBACK TO Update_Channel_Team_pub;
2100: x_return_status := FND_API.g_ret_sts_unexp_error ;
2101:
2102: FND_MSG_PUB.count_and_get (
2103: p_encoded => FND_API.g_false
2104: ,p_count => x_msg_count
2105: ,p_data => x_msg_data
2106: );
2107: -- Debug Message

Line 2116: x_return_status := FND_API.g_ret_sts_unexp_error ;

2112: END IF;
2113:
2114: WHEN OTHERS THEN
2115: ROLLBACK TO Update_Channel_Team_pub;
2116: x_return_status := FND_API.g_ret_sts_unexp_error ;
2117:
2118: FND_MSG_PUB.count_and_get(
2119: p_encoded => FND_API.g_false
2120: ,p_count => x_msg_count

Line 2119: p_encoded => FND_API.g_false

2115: ROLLBACK TO Update_Channel_Team_pub;
2116: x_return_status := FND_API.g_ret_sts_unexp_error ;
2117:
2118: FND_MSG_PUB.count_and_get(
2119: p_encoded => FND_API.g_false
2120: ,p_count => x_msg_count
2121: ,p_data => x_msg_data
2122: );
2123: