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.ZX_PARTY_MERGE_PKG dependencies on FND_API

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: l_log_msg := l_procedure_name||' (+) ';
125: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
126: END IF;
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129:
130: --If it is a Site Merge, nothing to be done. Return the x_to_id.
131:
132: IF p_from_fk_id = p_to_fk_id THEN

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: WHEN OTHERS THEN
178: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
179: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: END;
183: END IF; -- p_from_fk_id <> p_to_fk_id
184:
185: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: l_log_msg := l_procedure_name||' (+) ';
253: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
254: END IF;
255:
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --If it is a Site Merge, nothing to be done. Return the x_to_id.
259:
260: IF p_from_fk_id = p_to_fk_id THEN

Line 324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

320: WHEN OTHERS THEN
321: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
322: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
323: FND_MSG_PUB.ADD;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: END;
326: END IF;
327:
328: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 363: x_return_status := FND_API.G_RET_STS_SUCCESS;

359: l_log_msg := l_procedure_name||' (+) ';
360: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
361: END IF;
362:
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: --If it is a Site Merge, nothing to be done. Return the x_to_id.
366:
367: if p_from_fk_id = p_to_fk_id THEN

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: WHEN OTHERS THEN
472: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
473: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
474: FND_MSG_PUB.ADD;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: END;
477: END IF;
478:
479: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 576: x_return_status := FND_API.G_RET_STS_SUCCESS;

572: l_log_msg := l_procedure_name||' (+) ';
573: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
574: END IF;
575:
576: x_return_status := FND_API.G_RET_STS_SUCCESS;
577:
578: --If it is a Site Merge, nothing to be done. Return the x_to_id.
579:
580: if p_from_fk_id = p_to_fk_id THEN

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

631: WHEN OTHERS THEN
632: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
633: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
634: FND_MSG_PUB.ADD;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: END;
637: END IF;
638:
639: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 747: x_return_status := FND_API.G_RET_STS_SUCCESS;

743: 'p_from_fk_id : '||p_from_fk_id||' , p_to_fk_id : '||p_to_fk_id
744: );
745: END IF;
746:
747: x_return_status := FND_API.G_RET_STS_SUCCESS;
748: --
749: -- Tax Applicability it is just for Suppliers
750: -- Commenting as per Nigel Updates 3511846
751: --

Line 848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

844: WHEN OTHERS THEN
845: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
846: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
847: FND_MSG_PUB.ADD;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: end ZX_CUSTOMER_VETO_PVT;
850:
851:
852: PROCEDURE ZX_MERGE (

Line 896: x_return_status := FND_API.G_RET_STS_SUCCESS;

892: l_log_msg := l_procedure_name||' (+) ';
893: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
894: END IF;
895:
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: --If it is a Site Merge, nothing to be done. Return the x_to_id.
899:
900: if p_from_fk_id = p_to_fk_id THEN

Line 1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1002: WHEN OTHERS THEN
1003: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
1004: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1005: FND_MSG_PUB.ADD;
1006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1007: END;
1008: END IF;
1009:
1010: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)

1366: AND NOT EXISTS
1367: (SELECT 1
1368: FROM zx_registrations ref_data
1369: WHERE ref_data.party_tax_profile_id = l_tbl_from_ptp_id(i)
1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)
1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)
1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1373: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_id(i),FND_API.G_MISS_NUM)
1374: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_site_id(i),FND_API.G_MISS_NUM)

Line 1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)

1367: (SELECT 1
1368: FROM zx_registrations ref_data
1369: WHERE ref_data.party_tax_profile_id = l_tbl_from_ptp_id(i)
1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)
1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)
1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1373: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_id(i),FND_API.G_MISS_NUM)
1374: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_site_id(i),FND_API.G_MISS_NUM)
1375: AND ref_data.effective_from = main_tbl.effective_from

Line 1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)

1368: FROM zx_registrations ref_data
1369: WHERE ref_data.party_tax_profile_id = l_tbl_from_ptp_id(i)
1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)
1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)
1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1373: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_id(i),FND_API.G_MISS_NUM)
1374: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_site_id(i),FND_API.G_MISS_NUM)
1375: AND ref_data.effective_from = main_tbl.effective_from
1376: );

Line 1373: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_id(i),FND_API.G_MISS_NUM)

1369: WHERE ref_data.party_tax_profile_id = l_tbl_from_ptp_id(i)
1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)
1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)
1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1373: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_id(i),FND_API.G_MISS_NUM)
1374: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_site_id(i),FND_API.G_MISS_NUM)
1375: AND ref_data.effective_from = main_tbl.effective_from
1376: );
1377: --

Line 1374: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_site_id(i),FND_API.G_MISS_NUM)

1370: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_regime_code,FND_API.G_MISS_CHAR)
1371: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax,FND_API.G_MISS_CHAR)
1372: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(main_tbl.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1373: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_id(i),FND_API.G_MISS_NUM)
1374: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(l_tbl_to_acct_site_id(i),FND_API.G_MISS_NUM)
1375: AND ref_data.effective_from = main_tbl.effective_from
1376: );
1377: --
1378: -- Processing for Registration records end

Line 1530: x_return_status := FND_API.G_RET_STS_SUCCESS;

1526: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_SITE_REGISTRATIONS_PVT';
1527:
1528: BEGIN
1529: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1530: x_return_status := FND_API.G_RET_STS_SUCCESS;
1531:
1532: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1533: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1534: 'Merge_Site_Registrations_Pvt(+)');

Line 1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)

1662: WHERE NOT EXISTS
1663: (SELECT 1
1664: FROM zx_registrations ref_data
1665: WHERE ref_data.party_tax_profile_id = p_to_ptp_id
1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)
1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)
1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1669: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(rec.account_id,FND_API.G_MISS_NUM)
1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)

Line 1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)

1663: (SELECT 1
1664: FROM zx_registrations ref_data
1665: WHERE ref_data.party_tax_profile_id = p_to_ptp_id
1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)
1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)
1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1669: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(rec.account_id,FND_API.G_MISS_NUM)
1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)
1671: AND ref_data.effective_from = rec.effective_from

Line 1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)

1664: FROM zx_registrations ref_data
1665: WHERE ref_data.party_tax_profile_id = p_to_ptp_id
1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)
1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)
1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1669: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(rec.account_id,FND_API.G_MISS_NUM)
1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)
1671: AND ref_data.effective_from = rec.effective_from
1672: );

Line 1669: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(rec.account_id,FND_API.G_MISS_NUM)

1665: WHERE ref_data.party_tax_profile_id = p_to_ptp_id
1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)
1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)
1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1669: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(rec.account_id,FND_API.G_MISS_NUM)
1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)
1671: AND ref_data.effective_from = rec.effective_from
1672: );
1673:

Line 1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)

1666: AND NVL(ref_data.tax_regime_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_regime_code,FND_API.G_MISS_CHAR)
1667: AND NVL(ref_data.tax,FND_API.G_MISS_CHAR) = NVL(rec.tax,FND_API.G_MISS_CHAR)
1668: AND NVL(ref_data.tax_jurisdiction_code,FND_API.G_MISS_CHAR) = NVL(rec.tax_jurisdiction_code,FND_API.G_MISS_CHAR)
1669: AND NVL(ref_data.account_id,FND_API.G_MISS_NUM) = NVL(rec.account_id,FND_API.G_MISS_NUM)
1670: AND NVL(ref_data.account_site_id,FND_API.G_MISS_NUM) = NVL(rec.account_site_id,FND_API.G_MISS_NUM)
1671: AND ref_data.effective_from = rec.effective_from
1672: );
1673:
1674: UPDATE zx_registrations

Line 1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1702: 'Merge_Site_Registrations_Pvt(Exception)');
1703: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1704: 'Error : '||SQLERRM);
1705: END IF;
1706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1707:
1708: END MERGE_SITE_REGISTRATIONS_PVT;
1709:
1710: ------------------------------

Line 1723: x_return_status := FND_API.G_RET_STS_SUCCESS;

1719: l_procedure_name CONSTANT VARCHAR2(30) := '.MERGE_SITE_EXEMPTIONS_PVT';
1720:
1721: BEGIN
1722: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1723: x_return_status := FND_API.G_RET_STS_SUCCESS;
1724:
1725: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1726: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1727: 'Merge_Site_Exemptions_Pvt(+)');

Line 1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1842: 'Merge_Site_Exemptions_Pvt(Exception)');
1843: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1844: 'Error : '||SQLERRM);
1845: END IF;
1846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1847:
1848: END MERGE_SITE_EXEMPTIONS_PVT;
1849:
1850: ------------------------------

Line 1895: x_return_status := FND_API.G_RET_STS_SUCCESS;

1891:
1892: BEGIN
1893:
1894: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1895: x_return_status := FND_API.G_RET_STS_SUCCESS;
1896:
1897: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1898: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
1899: 'Merge_Party_Sites_PTP_Pvt(+)');

Line 1908: x_return_status := FND_API.G_RET_STS_ERROR;

1904: ---------------------------
1905: OPEN c_party_type(p_from_party_type);
1906: FETCH c_party_type INTO l_party_type_code;
1907: IF c_party_type%NOTFOUND THEN
1908: x_return_status := FND_API.G_RET_STS_ERROR;
1909: CLOSE c_party_type;
1910: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1911: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1912: 'Error : From Party Type '||p_from_party_type||' is not valid');

Line 1921: x_return_status := FND_API.G_RET_STS_ERROR;

1917:
1918: OPEN c_party_type(p_to_party_type);
1919: FETCH c_party_type INTO l_party_type_code;
1920: IF c_party_type%NOTFOUND THEN
1921: x_return_status := FND_API.G_RET_STS_ERROR;
1922: CLOSE c_party_type;
1923: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1924: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1925: 'Error : To Party Type '||p_to_party_type||' is not valid');

Line 1937: x_return_status := FND_API.G_RET_STS_ERROR;

1933: OPEN get_ptp_info(p_from_fk_id, p_from_party_type);
1934: FETCH get_ptp_info INTO l_from_ptp_rec;
1935: IF get_ptp_info%NOTFOUND THEN
1936: CLOSE get_ptp_info;
1937: x_return_status := FND_API.G_RET_STS_ERROR;
1938: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1939: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1940: 'Error : From Party Info not available for Party-Id '||
1941: p_from_fk_id||' and Party-Type '||p_from_party_type);

Line 1954: -- x_return_status := FND_API.G_RET_STS_ERROR;

1950: FETCH get_ptp_info INTO l_to_ptp_rec;
1951: -- bug 10430488 handling the insert and update separately
1952: IF get_ptp_info%FOUND THEN
1953: l_insert_ptp := FALSE;
1954: -- x_return_status := FND_API.G_RET_STS_ERROR;
1955: -- IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1956: -- FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
1957: -- 'Error : To Party Info already available for Party-Id '||
1958: -- p_to_fk_id||' and Party-Type '||p_to_party_type);

Line 2073: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2069: ,p_country_code => l_from_ptp_rec.country_code
2070: );
2071: END IF;
2072:
2073: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2074: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2075: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2076: 'Incorrect status retuned by ZX_Party_Tax_Profile_Pkg.Insert_Row()');
2077: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2094: x_return_status := FND_API.G_RET_STS_ERROR ;

2090: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2091: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2092: 'Error : Party_Tax_Profile_Id of To-Site is NULL');
2093: END IF;
2094: x_return_status := FND_API.G_RET_STS_ERROR ;
2095: RETURN;
2096: ELSE
2097: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2098: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2116: (p_from_ptp_id => l_from_ptp_rec.party_tax_profile_id
2117: ,p_to_ptp_id => l_to_ptp_rec.party_tax_profile_id
2118: ,x_return_status => x_return_status);
2119:
2120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2121: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2122: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2123: 'Incorrect status retuned by Merge_Site_Registrations_Pvt()');
2124: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2140: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN

2136: (p_from_ptp_id => l_from_ptp_rec.party_tax_profile_id
2137: ,p_to_ptp_id => l_to_ptp_rec.party_tax_profile_id
2138: ,x_return_status => x_return_status);
2139:
2140: IF NVL(x_return_status,FND_API.G_RET_STS_SUCCESS) <> FND_API.G_RET_STS_SUCCESS THEN
2141: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2142: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2143: 'Incorrect status retuned by Merge_Site_Exemptions_Pvt()');
2144: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2165: 'Merge_Party_Sites_PTP_Pvt(Exception)');
2166: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2167: 'Error : '||SQLERRM);
2168: END IF;
2169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2170:
2171: END MERGE_PARTY_SITES_PTP_PVT;
2172:
2173: ------------------------------

Line 2193: x_return_status := FND_API.G_RET_STS_SUCCESS;

2189:
2190: BEGIN
2191:
2192: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194:
2195: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2196: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2197: 'Merge_PTP_Sites(+)');

Line 2213: x_return_status := FND_API.G_RET_STS_ERROR;

2209: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,'Batch_Party_Id : '||p_batch_party_id);
2210: END IF;
2211:
2212: IF p_from_fk_id IS NULL THEN
2213: x_return_status := FND_API.G_RET_STS_ERROR;
2214: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2215: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2216: 'Error : From-Party-Id is NULL');
2217: END IF;

Line 2222: x_return_status := FND_API.G_RET_STS_ERROR;

2218: RETURN;
2219: END IF;
2220:
2221: IF p_to_fk_id IS NULL THEN
2222: x_return_status := FND_API.G_RET_STS_ERROR;
2223: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2224: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2225: 'Error : To-Party-Id is NULL');
2226: END IF;

Line 2232: x_return_status := FND_API.G_RET_STS_ERROR;

2228: END IF;
2229:
2230: IF p_from_fk_id = p_to_fk_id THEN
2231: p_to_id := p_from_id;
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2234: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2235: 'Error : From-Party-Id and To-Party-Id are same');
2236: END IF;

Line 2248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2244: ,p_to_party_type => 'THIRD_PARTY_SITE'
2245: ,x_return_status => x_return_status
2246: );
2247:
2248: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2249: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2250: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,
2251: 'Incorrect status retuned by Merge_Party_Sites_PTP_Pvt()');
2252: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name,

Line 2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2269: 'Merge_PTP_Sites(Exception)');
2270: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_procedure_name,
2271: 'Error : '||SQLERRM);
2272: END IF;
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274: RAISE;
2275: END MERGE_PTP_SITES;
2276:
2277: END ZX_PARTY_MERGE_PKG;