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

Line 1346: l_return_status := FND_API.G_RET_STS_SUCCESS;

1342:
1343: savepoint get_compl_count_pvt;
1344: FND_MSG_PUB.initialize;
1345:
1346: l_return_status := FND_API.G_RET_STS_SUCCESS;
1347: l_system_date := sysdate;
1348:
1349: write_log('Start collecting data for completeness report at: '||l_system_date);
1350:

Line 1426: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1422: insert_daily_score(l_report_name, l_total_party, l_party_type
1423: , l_attribute, l_attr_code, l_table_name
1424: , l_system_date, l_parent_cat
1425: , l_return_status, l_msg_count, l_msg_data);
1426: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1427: l_attribute_count := l_attribute_count + 1;
1428: END IF;
1429: END LOOP;
1430: CLOSE get_all_attributes;

Line 1477: WHEN FND_API.G_EXC_ERROR THEN

1473: write_log('Finish collecting data for completeness report');
1474:
1475: EXCEPTION
1476:
1477: WHEN FND_API.G_EXC_ERROR THEN
1478: ROLLBACK TO get_compl_count_pvt;
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: FND_MSG_PUB.Count_And_Get(
1481: p_encoded => FND_API.G_FALSE,

Line 1479: x_return_status := FND_API.G_RET_STS_ERROR;

1475: EXCEPTION
1476:
1477: WHEN FND_API.G_EXC_ERROR THEN
1478: ROLLBACK TO get_compl_count_pvt;
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: FND_MSG_PUB.Count_And_Get(
1481: p_encoded => FND_API.G_FALSE,
1482: p_count => x_msg_count,
1483: p_data => x_msg_data);

Line 1481: p_encoded => FND_API.G_FALSE,

1477: WHEN FND_API.G_EXC_ERROR THEN
1478: ROLLBACK TO get_compl_count_pvt;
1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: FND_MSG_PUB.Count_And_Get(
1481: p_encoded => FND_API.G_FALSE,
1482: p_count => x_msg_count,
1483: p_data => x_msg_data);
1484:
1485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1481: p_encoded => FND_API.G_FALSE,
1482: p_count => x_msg_count,
1483: p_data => x_msg_data);
1484:
1485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1486: ROLLBACK TO get_compl_count_pvt;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MSG_PUB.Count_And_Get(
1489: p_encoded => FND_API.G_FALSE,

Line 1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1483: p_data => x_msg_data);
1484:
1485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1486: ROLLBACK TO get_compl_count_pvt;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MSG_PUB.Count_And_Get(
1489: p_encoded => FND_API.G_FALSE,
1490: p_count => x_msg_count,
1491: p_data => x_msg_data);

Line 1489: p_encoded => FND_API.G_FALSE,

1485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1486: ROLLBACK TO get_compl_count_pvt;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: FND_MSG_PUB.Count_And_Get(
1489: p_encoded => FND_API.G_FALSE,
1490: p_count => x_msg_count,
1491: p_data => x_msg_data);
1492:
1493: WHEN OTHERS THEN

Line 1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1491: p_data => x_msg_data);
1492:
1493: WHEN OTHERS THEN
1494: ROLLBACK TO get_compl_count_pvt;
1495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1498: FND_MSG_PUB.ADD;
1499: FND_MSG_PUB.Count_And_Get(

Line 1500: p_encoded => FND_API.G_FALSE,

1496: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1497: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1498: FND_MSG_PUB.ADD;
1499: FND_MSG_PUB.Count_And_Get(
1500: p_encoded => FND_API.G_FALSE,
1501: p_count => x_msg_count,
1502: p_data => x_msg_data);
1503:
1504: END get_compl_count;

Line 1518: l_return_status := FND_API.G_RET_STS_SUCCESS;

1514: l_return_status VARCHAR2(30);
1515: BEGIN
1516:
1517: savepoint delete_daily_score_pvt;
1518: l_return_status := FND_API.G_RET_STS_SUCCESS;
1519:
1520: write_log('Start removing daily record for completeness report: '||p_report_name);
1521:
1522: -- remove day record

Line 1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1532: EXCEPTION
1533:
1534: WHEN OTHERS THEN
1535: ROLLBACK TO delete_daily_score_pvt;
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1537: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1539: FND_MSG_PUB.ADD;
1540: FND_MSG_PUB.Count_And_Get(

Line 1541: p_encoded => FND_API.G_FALSE,

1537: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1538: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1539: FND_MSG_PUB.ADD;
1540: FND_MSG_PUB.Count_And_Get(
1541: p_encoded => FND_API.G_FALSE,
1542: p_count => x_msg_count,
1543: p_data => x_msg_data);
1544:
1545: END delete_daily_score;

Line 1568: l_return_status := FND_API.G_RET_STS_SUCCESS;

1564: l_perf_hint VARCHAR2(60); -- Perf Bug 6322629
1565: BEGIN
1566:
1567: savepoint insert_daily_score_pvt;
1568: l_return_status := FND_API.G_RET_STS_SUCCESS;
1569: l_perf_hint := '';
1570:
1571: write_log('Start inserting daily score for completeness report: '||p_report_name);
1572: write_log('>> p_total_party:'||p_total_party||' p_party_type:'||p_party_type||' p_attribute: '||p_attribute);

Line 1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1636: EXCEPTION
1637:
1638: WHEN OTHERS THEN
1639: ROLLBACK TO insert_daily_score_pvt;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1643: FND_MSG_PUB.ADD;
1644: FND_MSG_PUB.Count_And_Get(

Line 1645: p_encoded => FND_API.G_FALSE,

1641: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1642: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1643: FND_MSG_PUB.ADD;
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: write_log('Error: '||sqlerrm);
1649:

Line 1667: l_return_status := FND_API.G_RET_STS_SUCCESS;

1663:
1664: BEGIN
1665:
1666: savepoint insert_monthly_score_pvt;
1667: l_return_status := FND_API.G_RET_STS_SUCCESS;
1668:
1669: write_log('Start inserting monthly score for completeness report: '||p_report_name);
1670: write_log('>> p_total_party:'||p_total_party||' p_total_attribute: '||p_total_attribute);
1671:

Line 1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1699: EXCEPTION
1700:
1701: WHEN OTHERS THEN
1702: ROLLBACK TO insert_monthly_score_pvt;
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1706: FND_MSG_PUB.ADD;
1707: FND_MSG_PUB.Count_And_Get(

Line 1708: p_encoded => FND_API.G_FALSE,

1704: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1705: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1706: FND_MSG_PUB.ADD;
1707: FND_MSG_PUB.Count_And_Get(
1708: p_encoded => FND_API.G_FALSE,
1709: p_count => x_msg_count,
1710: p_data => x_msg_data);
1711: write_log('Error: '||sqlerrm);
1712:

Line 1730: l_return_status := FND_API.G_RET_STS_SUCCESS;

1726:
1727: BEGIN
1728:
1729: savepoint update_monthly_score_pvt;
1730: l_return_status := FND_API.G_RET_STS_SUCCESS;
1731:
1732: write_log('Start updating monthly score for completeness report: '||p_report_name);
1733: write_log('>> p_total_party:'||p_total_party||' p_total_attribute: '||p_total_attribute);
1734:

Line 1755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1751: EXCEPTION
1752:
1753: WHEN OTHERS THEN
1754: ROLLBACK TO update_monthly_score_pvt;
1755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1756: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1758: FND_MSG_PUB.ADD;
1759: FND_MSG_PUB.Count_And_Get(

Line 1760: p_encoded => FND_API.G_FALSE,

1756: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1757: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1758: FND_MSG_PUB.ADD;
1759: FND_MSG_PUB.Count_And_Get(
1760: p_encoded => FND_API.G_FALSE,
1761: p_count => x_msg_count,
1762: p_data => x_msg_data);
1763: write_log('Error: '||sqlerrm);
1764:

Line 1782: l_return_status := FND_API.G_RET_STS_SUCCESS;

1778:
1779: BEGIN
1780:
1781: savepoint insert_quarterly_score_pvt;
1782: l_return_status := FND_API.G_RET_STS_SUCCESS;
1783:
1784: write_log('Start inserting quarterly score for completeness report: '||p_report_name);
1785: write_log('>> p_total_party:'||p_total_party||' p_total_attribute: '||p_total_attribute);
1786:

Line 1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1812: EXCEPTION
1813:
1814: WHEN OTHERS THEN
1815: ROLLBACK TO insert_quarterly_score_pvt;
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1817: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1818: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1819: FND_MSG_PUB.ADD;
1820: FND_MSG_PUB.Count_And_Get(

Line 1821: p_encoded => FND_API.G_FALSE,

1817: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1818: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1819: FND_MSG_PUB.ADD;
1820: FND_MSG_PUB.Count_And_Get(
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data);
1824: write_log('Error: '||sqlerrm);
1825:

Line 1843: l_return_status := FND_API.G_RET_STS_SUCCESS;

1839:
1840: BEGIN
1841:
1842: savepoint update_quarterly_score_pvt;
1843: l_return_status := FND_API.G_RET_STS_SUCCESS;
1844:
1845: write_log('Start updating quarterly score for completeness report: '||p_report_name);
1846: write_log('>> p_total_party:'||p_total_party||' p_total_attribute: '||p_total_attribute);
1847:

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1861: EXCEPTION
1862:
1863: WHEN OTHERS THEN
1864: ROLLBACK TO update_quarterly_score_pvt;
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1867: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1868: FND_MSG_PUB.ADD;
1869: FND_MSG_PUB.Count_And_Get(

Line 1870: p_encoded => FND_API.G_FALSE,

1866: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1867: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1868: FND_MSG_PUB.ADD;
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: write_log('Error: '||sqlerrm);
1874:

Line 2093: WHEN FND_API.G_EXC_ERROR THEN

2089: write_log('Finish collecting data for enrichment report at: '||l_system_date);
2090:
2091: EXCEPTION
2092:
2093: WHEN FND_API.G_EXC_ERROR THEN
2094: ROLLBACK TO get_enrich_count_pvt;
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: FND_MSG_PUB.Count_And_Get(
2097: p_encoded => FND_API.G_FALSE,

Line 2095: x_return_status := FND_API.G_RET_STS_ERROR;

2091: EXCEPTION
2092:
2093: WHEN FND_API.G_EXC_ERROR THEN
2094: ROLLBACK TO get_enrich_count_pvt;
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: FND_MSG_PUB.Count_And_Get(
2097: p_encoded => FND_API.G_FALSE,
2098: p_count => x_msg_count,
2099: p_data => x_msg_data);

Line 2097: p_encoded => FND_API.G_FALSE,

2093: WHEN FND_API.G_EXC_ERROR THEN
2094: ROLLBACK TO get_enrich_count_pvt;
2095: x_return_status := FND_API.G_RET_STS_ERROR;
2096: FND_MSG_PUB.Count_And_Get(
2097: p_encoded => FND_API.G_FALSE,
2098: p_count => x_msg_count,
2099: p_data => x_msg_data);
2100:
2101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2097: p_encoded => FND_API.G_FALSE,
2098: p_count => x_msg_count,
2099: p_data => x_msg_data);
2100:
2101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2102: ROLLBACK TO get_enrich_count_pvt;
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(
2105: p_encoded => FND_API.G_FALSE,

Line 2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2099: p_data => x_msg_data);
2100:
2101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2102: ROLLBACK TO get_enrich_count_pvt;
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(
2105: p_encoded => FND_API.G_FALSE,
2106: p_count => x_msg_count,
2107: p_data => x_msg_data);

Line 2105: p_encoded => FND_API.G_FALSE,

2101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2102: ROLLBACK TO get_enrich_count_pvt;
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: FND_MSG_PUB.Count_And_Get(
2105: p_encoded => FND_API.G_FALSE,
2106: p_count => x_msg_count,
2107: p_data => x_msg_data);
2108:
2109: WHEN OTHERS THEN

Line 2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2107: p_data => x_msg_data);
2108:
2109: WHEN OTHERS THEN
2110: ROLLBACK TO get_enrich_count_pvt;
2111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2112: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2114: FND_MSG_PUB.ADD;
2115: FND_MSG_PUB.Count_And_Get(

Line 2116: p_encoded => FND_API.G_FALSE,

2112: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2113: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2114: FND_MSG_PUB.ADD;
2115: FND_MSG_PUB.Count_And_Get(
2116: p_encoded => FND_API.G_FALSE,
2117: p_count => x_msg_count,
2118: p_data => x_msg_data);
2119: write_log('Error: '||sqlerrm);
2120:

Line 2137: l_return_status := FND_API.G_RET_STS_SUCCESS;

2133:
2134: BEGIN
2135:
2136: savepoint insert_menrich_score_pvt;
2137: l_return_status := FND_API.G_RET_STS_SUCCESS;
2138:
2139: write_log('Start inserting monthly data for enrichment report: '||p_system_date);
2140:
2141: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2210: EXCEPTION
2211:
2212: WHEN OTHERS THEN
2213: ROLLBACK TO insert_menrich_score_pvt;
2214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2215: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2217: FND_MSG_PUB.ADD;
2218: FND_MSG_PUB.Count_And_Get(

Line 2219: p_encoded => FND_API.G_FALSE,

2215: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2216: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2217: FND_MSG_PUB.ADD;
2218: FND_MSG_PUB.Count_And_Get(
2219: p_encoded => FND_API.G_FALSE,
2220: p_count => x_msg_count,
2221: p_data => x_msg_data);
2222: write_log('Error: '||sqlerrm);
2223:

Line 2240: l_return_status := FND_API.G_RET_STS_SUCCESS;

2236:
2237: BEGIN
2238:
2239: savepoint update_menrich_score_pvt;
2240: l_return_status := FND_API.G_RET_STS_SUCCESS;
2241:
2242: write_log('Start updating monthly data for enrichment report: '||p_system_date);
2243:
2244: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2291: EXCEPTION
2292:
2293: WHEN OTHERS THEN
2294: ROLLBACK TO update_menrich_score_pvt;
2295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2298: FND_MSG_PUB.ADD;
2299: FND_MSG_PUB.Count_And_Get(

Line 2300: p_encoded => FND_API.G_FALSE,

2296: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2297: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2298: FND_MSG_PUB.ADD;
2299: FND_MSG_PUB.Count_And_Get(
2300: p_encoded => FND_API.G_FALSE,
2301: p_count => x_msg_count,
2302: p_data => x_msg_data);
2303: write_log('Error: '||sqlerrm);
2304:

Line 2321: l_return_status := FND_API.G_RET_STS_SUCCESS;

2317:
2318: BEGIN
2319:
2320: savepoint insert_qenrich_score_pvt;
2321: l_return_status := FND_API.G_RET_STS_SUCCESS;
2322:
2323: write_log('Start inserting quarterly data for enrichment report: '||p_system_date);
2324:
2325: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2394: EXCEPTION
2395:
2396: WHEN OTHERS THEN
2397: ROLLBACK TO insert_qenrich_score_pvt;
2398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2401: FND_MSG_PUB.ADD;
2402: FND_MSG_PUB.Count_And_Get(

Line 2403: p_encoded => FND_API.G_FALSE,

2399: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2400: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2401: FND_MSG_PUB.ADD;
2402: FND_MSG_PUB.Count_And_Get(
2403: p_encoded => FND_API.G_FALSE,
2404: p_count => x_msg_count,
2405: p_data => x_msg_data);
2406: write_log('Error: '||sqlerrm);
2407:

Line 2424: l_return_status := FND_API.G_RET_STS_SUCCESS;

2420:
2421: BEGIN
2422:
2423: savepoint update_qenrich_score_pvt;
2424: l_return_status := FND_API.G_RET_STS_SUCCESS;
2425:
2426: write_log('Start updating quarterly data for enrichment report: '||p_system_date);
2427:
2428: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2474: EXCEPTION
2475:
2476: WHEN OTHERS THEN
2477: ROLLBACK TO update_qenrich_score_pvt;
2478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2479: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2481: FND_MSG_PUB.ADD;
2482: FND_MSG_PUB.Count_And_Get(

Line 2483: p_encoded => FND_API.G_FALSE,

2479: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2480: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2481: FND_MSG_PUB.ADD;
2482: FND_MSG_PUB.Count_And_Get(
2483: p_encoded => FND_API.G_FALSE,
2484: p_count => x_msg_count,
2485: p_data => x_msg_data);
2486: write_log('Error: '||sqlerrm);
2487:

Line 2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2537: RETURN l_party_count;
2538:
2539: EXCEPTION
2540: WHEN OTHERS THEN
2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2542: RETURN NULL;
2543: END get_party_count;
2544:
2545: FUNCTION get_enrich_party_count (

Line 2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2591: RETURN l_enpty_count;
2592:
2593: EXCEPTION
2594: WHEN OTHERS THEN
2595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2596: RETURN NULL;
2597: END get_enrich_party_count;
2598:
2599: FUNCTION get_party_clause(

Line 2634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2630: RETURN str;
2631:
2632: EXCEPTION
2633: WHEN OTHERS THEN
2634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2635: RETURN NULL;
2636: END get_party_clause;
2637:
2638: FUNCTION get_code_assign_clause(

Line 2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2658: RETURN str;
2659:
2660: EXCEPTION
2661: WHEN OTHERS THEN
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2663: RETURN NULL;
2664: END get_code_assign_clause;
2665:
2666: FUNCTION get_profile_clause(

Line 2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2689: RETURN str;
2690:
2691: EXCEPTION
2692: WHEN OTHERS THEN
2693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2694: RETURN NULL;
2695: END get_profile_clause;
2696:
2697: FUNCTION get_contactpoint_clause(

Line 2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2752: RETURN str;
2753:
2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2757: RETURN NULL;
2758: END get_contactpoint_clause;
2759:
2760: FUNCTION get_org_contact_clause(

Line 2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2786: RETURN str;
2787:
2788: EXCEPTION
2789: WHEN OTHERS THEN
2790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2791: RETURN NULL;
2792: END get_org_contact_clause;
2793:
2794: FUNCTION get_org_contact_role_clause(

Line 2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2824: RETURN str;
2825:
2826: EXCEPTION
2827: WHEN OTHERS THEN
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: RETURN NULL;
2830: END get_org_contact_role_clause;
2831:
2832: -- main PROCEDURE that collect data for quality reports

Line 2868: x_return_status := FND_API.G_RET_STS_SUCCESS;

2864: l_mean VARCHAR2(80);
2865: l_desc VARCHAR2(240);
2866: l_start_date DATE;
2867: BEGIN
2868: x_return_status := FND_API.G_RET_STS_SUCCESS;
2869:
2870: OPEN get_meaning;
2871: FETCh get_meaning INTO l_mean, l_desc, l_start_date;
2872: CLOSE get_meaning;

Line 2907: x_return_status := FND_API.G_RET_STS_ERROR;

2903: x_last_updated_by => fnd_global.user_id,
2904: x_last_update_login => fnd_global.login_id);
2905: EXCEPTION
2906: WHEN OTHERS THEN
2907: x_return_status := FND_API.G_RET_STS_ERROR;
2908: RAISE;
2909: END archive_compl_report;
2910:
2911: END imc_reports_summary_pkg;