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

Line 35: x_return_status := FND_API.G_RET_STS_SUCCESS;

31: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
32:
33:
34: -- Initialize API return status to success
35: x_return_status := FND_API.G_RET_STS_SUCCESS;
36:
37:
38: -- Get parameters for security settings
39: l_progress := '010';

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

48: AND U.employee_id = PAP.person_id
49: AND PAP.party_id = HZP.party_id;
50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
54: RAISE;
55: END;
56: FUN_UTIL.log_conc_stmt(

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

267: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FUN_UTIL.log_conc_unexp(
273: g_pkg_name, l_api_name, l_progress);
274: RAISE;
275: END build_summary_outquery;

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
303:
304:
305: -- Initialize API return status to success
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308:
309: -- Get parameters for security settings
310: l_progress := '010';

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

333:
334:
335: EXCEPTION
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
339: RAISE;
340: END;
341: FUN_UTIL.log_conc_stmt(

Line 661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

657: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
658:
659: EXCEPTION
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: FUN_UTIL.log_conc_unexp(
663: g_pkg_name, l_api_name, l_progress);
664: RAISE;
665: END build_account_outquery;

Line 698: x_return_status := FND_API.G_RET_STS_SUCCESS;

694: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
695:
696:
697: -- Initialize API return status to success
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700:
701: -- Get parameters for security settings
702: l_progress := '010';

Line 715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

711: AND U.employee_id = PAP.person_id
712: AND PAP.party_id = HZP.party_id;
713: EXCEPTION
714: WHEN OTHERS THEN
715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
717: RAISE;
718: END;
719: FUN_UTIL.log_conc_stmt(

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

913: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
914:
915: EXCEPTION
916: WHEN OTHERS THEN
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
918: FUN_UTIL.log_conc_unexp(
919: g_pkg_name, l_api_name, l_progress);
920: RAISE;
921: END build_summary_inquery;

Line 953: x_return_status := FND_API.G_RET_STS_SUCCESS;

949: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
950:
951:
952: -- Initialize API return status to success
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
955:
956: -- Get parameters for security settings
957: l_progress := '010';

Line 983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

979: end if;
980:
981: EXCEPTION
982: WHEN OTHERS THEN
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
985: RAISE;
986: END;
987: FUN_UTIL.log_conc_stmt(

Line 1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1281: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
1282:
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: FUN_UTIL.log_conc_unexp(
1287: g_pkg_name, l_api_name, l_progress);
1288: RAISE;
1289: END build_account_inquery;

Line 1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

1316:
1317: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1318:
1319: -- Initialize API return status to success
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321:
1322: l_progress := '010';
1323: l_ctx := DBMS_XMLGEN.newcontext(p_query);
1324: FUN_UTIL.log_conc_stmt(

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1342: DBMS_XMLGEN.closecontext(l_ctx);
1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: DBMS_XMLGEN.closecontext(l_ctx);
1348: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
1349: RAISE;
1350: END get_xml;

Line 1390: x_return_status := FND_API.G_RET_STS_SUCCESS;

1386: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1387:
1388:
1389: -- Initialize API return status to success
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1391:
1392:
1393: -- Construct the parameter list section
1394: l_progress := '010';

Line 1500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1496: p_trxs => p_outbound_trxs,
1497: p_offset => l_offset+2);
1498: END IF;
1499:
1500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;

Line 1501: RAISE FND_API.G_EXC_ERROR;

1497: p_offset => l_offset+2);
1498: END IF;
1499:
1500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505:

Line 1502: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1498: END IF;
1499:
1500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505:
1506:

Line 1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1499:
1500: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1501: RAISE FND_API.G_EXC_ERROR;
1502: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1504: END IF;
1505:
1506:
1507: IF DBMS_LOB.getlength(p_inbound_trxs) IS NULL THEN

Line 1580: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1576: FND_FILE.put_line(FND_FILE.output, ' ');
1577:
1578: END IF;
1579:
1580: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1581: RAISE FND_API.G_EXC_ERROR;
1582: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1584: END IF;

Line 1581: RAISE FND_API.G_EXC_ERROR;

1577:
1578: END IF;
1579:
1580: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1581: RAISE FND_API.G_EXC_ERROR;
1582: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1584: END IF;
1585:

Line 1582: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1578: END IF;
1579:
1580: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1581: RAISE FND_API.G_EXC_ERROR;
1582: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1584: END IF;
1585:
1586:

Line 1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1579:
1580: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1581: RAISE FND_API.G_EXC_ERROR;
1582: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1584: END IF;
1585:
1586:
1587: FND_FILE.put_line(FND_FILE.output, '');

Line 1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1589:
1590: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
1591:
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FUN_UTIL.log_conc_err(
1596: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1590: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
1591:
1592: EXCEPTION
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FUN_UTIL.log_conc_err(
1596: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598: WHEN FND_API.G_EXC_ERROR THEN

Line 1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FUN_UTIL.log_conc_err(
1596: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FUN_UTIL.log_conc_err(
1601: g_pkg_name, l_api_name, l_progress, 'error in construct_output');

Line 1598: WHEN FND_API.G_EXC_ERROR THEN

1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FUN_UTIL.log_conc_err(
1596: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FUN_UTIL.log_conc_err(
1601: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1602: RAISE FND_API.G_EXC_ERROR;

Line 1599: x_return_status := FND_API.G_RET_STS_ERROR;

1595: FUN_UTIL.log_conc_err(
1596: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FUN_UTIL.log_conc_err(
1601: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1602: RAISE FND_API.G_EXC_ERROR;
1603: WHEN OTHERS THEN

Line 1602: RAISE FND_API.G_EXC_ERROR;

1598: WHEN FND_API.G_EXC_ERROR THEN
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: FUN_UTIL.log_conc_err(
1601: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1602: RAISE FND_API.G_EXC_ERROR;
1603: WHEN OTHERS THEN
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FUN_UTIL.log_conc_unexp(
1606: g_pkg_name, l_api_name, l_progress);

Line 1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1600: FUN_UTIL.log_conc_err(
1601: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1602: RAISE FND_API.G_EXC_ERROR;
1603: WHEN OTHERS THEN
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FUN_UTIL.log_conc_unexp(
1606: g_pkg_name, l_api_name, l_progress);
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END construct_output;

Line 1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1603: WHEN OTHERS THEN
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1605: FUN_UTIL.log_conc_unexp(
1606: g_pkg_name, l_api_name, l_progress);
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: END construct_output;
1609:
1610:
1611:

Line 1651: x_return_status := FND_API.G_RET_STS_SUCCESS;

1647: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1648:
1649:
1650: -- Initialize API return status to success
1651: x_return_status := FND_API.G_RET_STS_SUCCESS;
1652:
1653:
1654: -- Construct the parameter list section
1655: l_progress := '010';

Line 1784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1780: p_trxs => p_trxs,
1781: p_offset => l_offset+2);
1782: END IF;
1783:
1784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;

Line 1785: RAISE FND_API.G_EXC_ERROR;

1781: p_offset => l_offset+2);
1782: END IF;
1783:
1784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:

Line 1786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1782: END IF;
1783:
1784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:
1790:

Line 1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1783:
1784: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1785: RAISE FND_API.G_EXC_ERROR;
1786: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1788: END IF;
1789:
1790:
1791:

Line 1795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1791:
1792:
1793:
1794:
1795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1796: RAISE FND_API.G_EXC_ERROR;
1797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1799: END IF;

Line 1796: RAISE FND_API.G_EXC_ERROR;

1792:
1793:
1794:
1795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1796: RAISE FND_API.G_EXC_ERROR;
1797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1799: END IF;
1800:

Line 1797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1793:
1794:
1795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1796: RAISE FND_API.G_EXC_ERROR;
1797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1799: END IF;
1800:
1801:

Line 1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1794:
1795: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1796: RAISE FND_API.G_EXC_ERROR;
1797: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1799: END IF;
1800:
1801:
1802: FND_FILE.put_line(FND_FILE.output, '');

Line 1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1804:
1805: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
1806:
1807: EXCEPTION
1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FUN_UTIL.log_conc_err(
1811: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1805: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
1806:
1807: EXCEPTION
1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FUN_UTIL.log_conc_err(
1811: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1813: WHEN FND_API.G_EXC_ERROR THEN

Line 1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1808: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FUN_UTIL.log_conc_err(
1811: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1813: WHEN FND_API.G_EXC_ERROR THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: FUN_UTIL.log_conc_err(
1816: g_pkg_name, l_api_name, l_progress, 'error in construct_output');

Line 1813: WHEN FND_API.G_EXC_ERROR THEN

1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1810: FUN_UTIL.log_conc_err(
1811: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1813: WHEN FND_API.G_EXC_ERROR THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: FUN_UTIL.log_conc_err(
1816: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1817: RAISE FND_API.G_EXC_ERROR;

Line 1814: x_return_status := FND_API.G_RET_STS_ERROR;

1810: FUN_UTIL.log_conc_err(
1811: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1813: WHEN FND_API.G_EXC_ERROR THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: FUN_UTIL.log_conc_err(
1816: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1817: RAISE FND_API.G_EXC_ERROR;
1818: WHEN OTHERS THEN

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: WHEN FND_API.G_EXC_ERROR THEN
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: FUN_UTIL.log_conc_err(
1816: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1817: RAISE FND_API.G_EXC_ERROR;
1818: WHEN OTHERS THEN
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820: FUN_UTIL.log_conc_unexp(
1821: g_pkg_name, l_api_name, l_progress);

Line 1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1815: FUN_UTIL.log_conc_err(
1816: g_pkg_name, l_api_name, l_progress, 'error in construct_output');
1817: RAISE FND_API.G_EXC_ERROR;
1818: WHEN OTHERS THEN
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820: FUN_UTIL.log_conc_unexp(
1821: g_pkg_name, l_api_name, l_progress);
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: END construct_account_output;

Line 1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1818: WHEN OTHERS THEN
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1820: FUN_UTIL.log_conc_unexp(
1821: g_pkg_name, l_api_name, l_progress);
1822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1823: END construct_account_output;
1824:
1825:
1826:

Line 1856: x_return_status := FND_API.G_RET_STS_SUCCESS;

1852: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1853:
1854:
1855: -- Initialize API return status to success
1856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1857:
1858: l_progress := '010';
1859: l_length := DBMS_LOB.getlength(p_trxs);
1860: FUN_UTIL.log_conc_stmt(

Line 1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1871: l_pos := l_pos + l_amount;
1872: END LOOP;
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1876: FUN_UTIL.log_conc_unexp(
1877: g_pkg_name, l_api_name, l_progress);
1878: RAISE;
1879: END save_xml;

Line 2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2016: );
2017: ELSE
2018: FUN_UTIL.log_conc_stmt(
2019: g_pkg_name, l_api_name, l_progress, 'batch type is incorrect');
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022:
2023: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2024: RAISE FND_API.G_EXC_ERROR;

Line 2023: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2019: g_pkg_name, l_api_name, l_progress, 'batch type is incorrect');
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022:
2023: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2024: RAISE FND_API.G_EXC_ERROR;
2025: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: END IF;

Line 2024: RAISE FND_API.G_EXC_ERROR;

2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: END IF;
2022:
2023: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2024: RAISE FND_API.G_EXC_ERROR;
2025: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: END IF;
2028:

Line 2025: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2021: END IF;
2022:
2023: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2024: RAISE FND_API.G_EXC_ERROR;
2025: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: END IF;
2028:
2029:

Line 2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2022:
2023: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2024: RAISE FND_API.G_EXC_ERROR;
2025: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2027: END IF;
2028:
2029:
2030: -- Get the XML data source

Line 2074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2070: x_xml => l_outbound_trxs
2071: );
2072: END IF;
2073:
2074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;
2077:
2078:

Line 2075: RAISE FND_API.G_EXC_ERROR;

2071: );
2072: END IF;
2073:
2074: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2075: RAISE FND_API.G_EXC_ERROR;
2076: END IF;
2077:
2078:
2079: -- Manupulate XML data source to XML Publisher compatiable format

Line 2091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2087: p_outbound_trxs => l_outbound_trxs,
2088: p_inbound_trxs => l_inbound_trxs
2089: );
2090:
2091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094:
2095: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

Line 2092: RAISE FND_API.G_EXC_ERROR;

2088: p_inbound_trxs => l_inbound_trxs
2089: );
2090:
2091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2092: RAISE FND_API.G_EXC_ERROR;
2093: END IF;
2094:
2095: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
2096:

Line 2098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2094:
2095: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
2096:
2097: EXCEPTION
2098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2099: retcode := 2;
2100: FUN_UTIL.log_conc_err(
2101: g_pkg_name, l_api_name, l_progress, 'error in create_summaryreport');
2102: WHEN FND_API.G_EXC_ERROR THEN

Line 2102: WHEN FND_API.G_EXC_ERROR THEN

2098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2099: retcode := 2;
2100: FUN_UTIL.log_conc_err(
2101: g_pkg_name, l_api_name, l_progress, 'error in create_summaryreport');
2102: WHEN FND_API.G_EXC_ERROR THEN
2103: retcode := 2;
2104: FUN_UTIL.log_conc_unexp(
2105: g_pkg_name, l_api_name, l_progress);
2106: FUN_UTIL.log_conc_err(

Line 2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2273: );
2274: ELSE
2275: FUN_UTIL.log_conc_stmt(
2276: g_pkg_name, l_api_name, l_progress, 'batch type is incorrect');
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: END IF;
2279:
2280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;

Line 2280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2276: g_pkg_name, l_api_name, l_progress, 'batch type is incorrect');
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: END IF;
2279:
2280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;

Line 2281: RAISE FND_API.G_EXC_ERROR;

2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278: END IF;
2279:
2280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;
2285:

Line 2282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2278: END IF;
2279:
2280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;
2285:
2286: if (l_outbound_query IS NULL) THEN

Line 2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2279:
2280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2281: RAISE FND_API.G_EXC_ERROR;
2282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2284: END IF;
2285:
2286: if (l_outbound_query IS NULL) THEN
2287: l_query:=l_inbound_query;

Line 2305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2301: p_rowset_tag => 'TRANSACTION_BATCHES',
2302: p_row_tag => 'BATCH',
2303: x_xml => l_trxs
2304: );
2305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2306: RAISE FND_API.G_EXC_ERROR;
2307: END IF;
2308:
2309:

Line 2306: RAISE FND_API.G_EXC_ERROR;

2302: p_row_tag => 'BATCH',
2303: x_xml => l_trxs
2304: );
2305: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2306: RAISE FND_API.G_EXC_ERROR;
2307: END IF;
2308:
2309:
2310: -- Manupulate XML data source to XML Publisher compatiable format

Line 2321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2317: p_para_rec => l_para_rec,
2318: p_trxs => l_trxs
2319: );
2320:
2321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;
2324:
2325: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

Line 2322: RAISE FND_API.G_EXC_ERROR;

2318: p_trxs => l_trxs
2319: );
2320:
2321: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2322: RAISE FND_API.G_EXC_ERROR;
2323: END IF;
2324:
2325: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
2326:

Line 2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2324:
2325: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
2326:
2327: EXCEPTION
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: retcode := 2;
2330: FUN_UTIL.log_conc_err(
2331: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2332: WHEN FND_API.G_EXC_ERROR THEN

Line 2332: WHEN FND_API.G_EXC_ERROR THEN

2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: retcode := 2;
2330: FUN_UTIL.log_conc_err(
2331: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2332: WHEN FND_API.G_EXC_ERROR THEN
2333: retcode := 2;
2334: FUN_UTIL.log_conc_unexp(
2335: g_pkg_name, l_api_name, l_progress);
2336: FUN_UTIL.log_conc_err(