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 2105: WHEN FND_API.G_EXC_ERROR THEN

2101: write_log('Finish collecting data for enrichment report at: '||l_system_date);
2102:
2103: EXCEPTION
2104:
2105: WHEN FND_API.G_EXC_ERROR THEN
2106: ROLLBACK TO get_enrich_count_pvt;
2107: x_return_status := FND_API.G_RET_STS_ERROR;
2108: FND_MSG_PUB.Count_And_Get(
2109: p_encoded => FND_API.G_FALSE,

Line 2107: x_return_status := FND_API.G_RET_STS_ERROR;

2103: EXCEPTION
2104:
2105: WHEN FND_API.G_EXC_ERROR THEN
2106: ROLLBACK TO get_enrich_count_pvt;
2107: x_return_status := FND_API.G_RET_STS_ERROR;
2108: FND_MSG_PUB.Count_And_Get(
2109: p_encoded => FND_API.G_FALSE,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);

Line 2109: p_encoded => FND_API.G_FALSE,

2105: WHEN FND_API.G_EXC_ERROR THEN
2106: ROLLBACK TO get_enrich_count_pvt;
2107: x_return_status := FND_API.G_RET_STS_ERROR;
2108: FND_MSG_PUB.Count_And_Get(
2109: p_encoded => FND_API.G_FALSE,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);
2112:
2113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2109: p_encoded => FND_API.G_FALSE,
2110: p_count => x_msg_count,
2111: p_data => x_msg_data);
2112:
2113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2114: ROLLBACK TO get_enrich_count_pvt;
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2116: FND_MSG_PUB.Count_And_Get(
2117: p_encoded => FND_API.G_FALSE,

Line 2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2111: p_data => x_msg_data);
2112:
2113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2114: ROLLBACK TO get_enrich_count_pvt;
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2116: FND_MSG_PUB.Count_And_Get(
2117: p_encoded => FND_API.G_FALSE,
2118: p_count => x_msg_count,
2119: p_data => x_msg_data);

Line 2117: p_encoded => FND_API.G_FALSE,

2113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2114: ROLLBACK TO get_enrich_count_pvt;
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2116: FND_MSG_PUB.Count_And_Get(
2117: p_encoded => FND_API.G_FALSE,
2118: p_count => x_msg_count,
2119: p_data => x_msg_data);
2120:
2121: WHEN OTHERS THEN

Line 2123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2119: p_data => x_msg_data);
2120:
2121: WHEN OTHERS THEN
2122: ROLLBACK TO get_enrich_count_pvt;
2123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2124: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2126: FND_MSG_PUB.ADD;
2127: FND_MSG_PUB.Count_And_Get(

Line 2128: p_encoded => FND_API.G_FALSE,

2124: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2125: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2126: FND_MSG_PUB.ADD;
2127: FND_MSG_PUB.Count_And_Get(
2128: p_encoded => FND_API.G_FALSE,
2129: p_count => x_msg_count,
2130: p_data => x_msg_data);
2131: write_log('Error: '||sqlerrm);
2132:

Line 2149: l_return_status := FND_API.G_RET_STS_SUCCESS;

2145:
2146: BEGIN
2147:
2148: savepoint insert_menrich_score_pvt;
2149: l_return_status := FND_API.G_RET_STS_SUCCESS;
2150:
2151: write_log('Start inserting monthly data for enrichment report: '||p_system_date);
2152:
2153: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2222: EXCEPTION
2223:
2224: WHEN OTHERS THEN
2225: ROLLBACK TO insert_menrich_score_pvt;
2226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2227: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2229: FND_MSG_PUB.ADD;
2230: FND_MSG_PUB.Count_And_Get(

Line 2231: p_encoded => FND_API.G_FALSE,

2227: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2228: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2229: FND_MSG_PUB.ADD;
2230: FND_MSG_PUB.Count_And_Get(
2231: p_encoded => FND_API.G_FALSE,
2232: p_count => x_msg_count,
2233: p_data => x_msg_data);
2234: write_log('Error: '||sqlerrm);
2235:

Line 2252: l_return_status := FND_API.G_RET_STS_SUCCESS;

2248:
2249: BEGIN
2250:
2251: savepoint update_menrich_score_pvt;
2252: l_return_status := FND_API.G_RET_STS_SUCCESS;
2253:
2254: write_log('Start updating monthly data for enrichment report: '||p_system_date);
2255:
2256: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2303: EXCEPTION
2304:
2305: WHEN OTHERS THEN
2306: ROLLBACK TO update_menrich_score_pvt;
2307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2310: FND_MSG_PUB.ADD;
2311: FND_MSG_PUB.Count_And_Get(

Line 2312: p_encoded => FND_API.G_FALSE,

2308: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2309: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2310: FND_MSG_PUB.ADD;
2311: FND_MSG_PUB.Count_And_Get(
2312: p_encoded => FND_API.G_FALSE,
2313: p_count => x_msg_count,
2314: p_data => x_msg_data);
2315: write_log('Error: '||sqlerrm);
2316:

Line 2333: l_return_status := FND_API.G_RET_STS_SUCCESS;

2329:
2330: BEGIN
2331:
2332: savepoint insert_qenrich_score_pvt;
2333: l_return_status := FND_API.G_RET_STS_SUCCESS;
2334:
2335: write_log('Start inserting quarterly data for enrichment report: '||p_system_date);
2336:
2337: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2406: EXCEPTION
2407:
2408: WHEN OTHERS THEN
2409: ROLLBACK TO insert_qenrich_score_pvt;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2411: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2413: FND_MSG_PUB.ADD;
2414: FND_MSG_PUB.Count_And_Get(

Line 2415: p_encoded => FND_API.G_FALSE,

2411: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2412: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2413: FND_MSG_PUB.ADD;
2414: FND_MSG_PUB.Count_And_Get(
2415: p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,
2417: p_data => x_msg_data);
2418: write_log('Error: '||sqlerrm);
2419:

Line 2436: l_return_status := FND_API.G_RET_STS_SUCCESS;

2432:
2433: BEGIN
2434:
2435: savepoint update_qenrich_score_pvt;
2436: l_return_status := FND_API.G_RET_STS_SUCCESS;
2437:
2438: write_log('Start updating quarterly data for enrichment report: '||p_system_date);
2439:
2440: l_party_count := get_party_count('ORGANIZATION', p_system_date, l_return_status);

Line 2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2486: EXCEPTION
2487:
2488: WHEN OTHERS THEN
2489: ROLLBACK TO update_qenrich_score_pvt;
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2492: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2493: FND_MSG_PUB.ADD;
2494: FND_MSG_PUB.Count_And_Get(

Line 2495: p_encoded => FND_API.G_FALSE,

2491: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
2492: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
2493: FND_MSG_PUB.ADD;
2494: FND_MSG_PUB.Count_And_Get(
2495: p_encoded => FND_API.G_FALSE,
2496: p_count => x_msg_count,
2497: p_data => x_msg_data);
2498: write_log('Error: '||sqlerrm);
2499:

Line 2553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2549: RETURN l_party_count;
2550:
2551: EXCEPTION
2552: WHEN OTHERS THEN
2553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2554: RETURN NULL;
2555: END get_party_count;
2556:
2557: FUNCTION get_enrich_party_count (

Line 2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2603: RETURN l_enpty_count;
2604:
2605: EXCEPTION
2606: WHEN OTHERS THEN
2607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2608: RETURN NULL;
2609: END get_enrich_party_count;
2610:
2611: FUNCTION get_party_clause(

Line 2646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2642: RETURN str;
2643:
2644: EXCEPTION
2645: WHEN OTHERS THEN
2646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2647: RETURN NULL;
2648: END get_party_clause;
2649:
2650: FUNCTION get_code_assign_clause(

Line 2674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2670: RETURN str;
2671:
2672: EXCEPTION
2673: WHEN OTHERS THEN
2674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2675: RETURN NULL;
2676: END get_code_assign_clause;
2677:
2678: FUNCTION get_profile_clause(

Line 2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2701: RETURN str;
2702:
2703: EXCEPTION
2704: WHEN OTHERS THEN
2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2706: RETURN NULL;
2707: END get_profile_clause;
2708:
2709: FUNCTION get_contactpoint_clause(

Line 2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2764: RETURN str;
2765:
2766: EXCEPTION
2767: WHEN OTHERS THEN
2768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2769: RETURN NULL;
2770: END get_contactpoint_clause;
2771:
2772: FUNCTION get_org_contact_clause(

Line 2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2798: RETURN str;
2799:
2800: EXCEPTION
2801: WHEN OTHERS THEN
2802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2803: RETURN NULL;
2804: END get_org_contact_clause;
2805:
2806: FUNCTION get_org_contact_role_clause(

Line 2840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2836: RETURN str;
2837:
2838: EXCEPTION
2839: WHEN OTHERS THEN
2840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2841: RETURN NULL;
2842: END get_org_contact_role_clause;
2843:
2844: -- main PROCEDURE that collect data for quality reports

Line 2880: x_return_status := FND_API.G_RET_STS_SUCCESS;

2876: l_mean VARCHAR2(80);
2877: l_desc VARCHAR2(240);
2878: l_start_date DATE;
2879: BEGIN
2880: x_return_status := FND_API.G_RET_STS_SUCCESS;
2881:
2882: OPEN get_meaning;
2883: FETCh get_meaning INTO l_mean, l_desc, l_start_date;
2884: CLOSE get_meaning;

Line 2919: x_return_status := FND_API.G_RET_STS_ERROR;

2915: x_last_updated_by => fnd_global.user_id,
2916: x_last_update_login => fnd_global.login_id);
2917: EXCEPTION
2918: WHEN OTHERS THEN
2919: x_return_status := FND_API.G_RET_STS_ERROR;
2920: RAISE;
2921: END archive_compl_report;
2922:
2923: END imc_reports_summary_pkg;