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 FUN_UTIL

Line 31: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

27: BEGIN
28: l_api_name := 'build_summary_outquery';
29: l_progress := '000';
30:
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;

Line 53: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

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(
57: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);

Line 56: FUN_UTIL.log_conc_stmt(

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(
57: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
58:
59: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
60: FUN_UTIL.log_conc_stmt(

Line 60: FUN_UTIL.log_conc_stmt(

56: FUN_UTIL.log_conc_stmt(
57: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
58:
59: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
60: FUN_UTIL.log_conc_stmt(
61: g_pkg_name, l_api_name, l_progress, 'l_grantee_key', l_grantee_key);
62:
63:
64: -- Build query string for outbound transactions

Line 265: FUN_UTIL.log_conc_stmt(

261: ' AND FTH.ar_invoice_number = ''' || p_para_rec.ar_invoice_number
262: || '''';
263: END IF;
264:
265: FUN_UTIL.log_conc_stmt(
266: g_pkg_name, l_api_name, l_progress, 'x_outbound_query', x_outbound_query);
267: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
268:
269: EXCEPTION

Line 267: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

263: END IF;
264:
265: FUN_UTIL.log_conc_stmt(
266: g_pkg_name, l_api_name, l_progress, 'x_outbound_query', x_outbound_query);
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;

Line 272: FUN_UTIL.log_conc_unexp(

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;
276:

Line 302: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

298: BEGIN
299: l_api_name := 'build_account_outquery';
300: l_progress := '000';
301:
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;

Line 338: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

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(
342: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);

Line 341: FUN_UTIL.log_conc_stmt(

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(
342: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
343:
344: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
345: FUN_UTIL.log_conc_stmt(

Line 345: FUN_UTIL.log_conc_stmt(

341: FUN_UTIL.log_conc_stmt(
342: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
343:
344: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
345: FUN_UTIL.log_conc_stmt(
346: g_pkg_name, l_api_name, l_progress, 'l_grantee_key', l_grantee_key);
347:
348:
349: -- Build query string for outbound transactions

Line 655: FUN_UTIL.log_conc_stmt(

651: ' AND FTH.ar_invoice_number = ''' || p_para_rec.ar_invoice_number
652: || '''';
653: END IF;
654:
655: FUN_UTIL.log_conc_stmt(
656: g_pkg_name, l_api_name, l_progress, 'x_outbound_query', x_outbound_query);
657: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
658:
659: EXCEPTION

Line 657: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

653: END IF;
654:
655: FUN_UTIL.log_conc_stmt(
656: g_pkg_name, l_api_name, l_progress, 'x_outbound_query', x_outbound_query);
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;

Line 662: FUN_UTIL.log_conc_unexp(

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;
666:

Line 694: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

690: BEGIN
691: l_api_name := 'build_summary_inquery';
692: l_progress := '000';
693:
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;

Line 716: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

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(
720: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);

Line 719: FUN_UTIL.log_conc_stmt(

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(
720: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
721:
722: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
723: FUN_UTIL.log_conc_stmt(

Line 723: FUN_UTIL.log_conc_stmt(

719: FUN_UTIL.log_conc_stmt(
720: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
721:
722: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
723: FUN_UTIL.log_conc_stmt(
724: g_pkg_name, l_api_name, l_progress, 'l_grantee_key', l_grantee_key);
725:
726:
727: -- Build query string for inbound transactions

Line 911: FUN_UTIL.log_conc_stmt(

907: ' AND FTH.ar_invoice_number = ''' || p_para_rec.ar_invoice_number
908: || '''';
909: END IF;
910:
911: FUN_UTIL.log_conc_stmt(
912: g_pkg_name, l_api_name, l_progress, 'x_inbound_query', x_inbound_query);
913: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
914:
915: EXCEPTION

Line 913: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

909: END IF;
910:
911: FUN_UTIL.log_conc_stmt(
912: g_pkg_name, l_api_name, l_progress, 'x_inbound_query', x_inbound_query);
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;

Line 918: FUN_UTIL.log_conc_unexp(

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;
922:

Line 949: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

945: BEGIN
946: l_api_name := 'build_account_inquery';
947: l_progress := '000';
948:
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;

Line 984: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

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(
988: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);

Line 987: FUN_UTIL.log_conc_stmt(

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(
988: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
989:
990: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
991: FUN_UTIL.log_conc_stmt(

Line 991: FUN_UTIL.log_conc_stmt(

987: FUN_UTIL.log_conc_stmt(
988: g_pkg_name, l_api_name, l_progress, 'l_person_id', l_person_id);
989:
990: l_grantee_key := 'HZ_PARTY:' || TO_CHAR(l_person_id);
991: FUN_UTIL.log_conc_stmt(
992: g_pkg_name, l_api_name, l_progress, 'l_grantee_key', l_grantee_key);
993:
994:
995: -- Build query string for inbound transactions

Line 1279: FUN_UTIL.log_conc_stmt(

1275:
1276:
1277:
1278:
1279: FUN_UTIL.log_conc_stmt(
1280: g_pkg_name, l_api_name, l_progress, 'x_inbound_query', x_inbound_query);
1281: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);
1282:
1283: EXCEPTION

Line 1281: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

1277:
1278:
1279: FUN_UTIL.log_conc_stmt(
1280: g_pkg_name, l_api_name, l_progress, 'x_inbound_query', x_inbound_query);
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;

Line 1286: FUN_UTIL.log_conc_unexp(

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;
1290:

Line 1317: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

1313: BEGIN
1314: l_api_name := 'get_xml';
1315: l_progress := '000';
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:

Line 1324: FUN_UTIL.log_conc_stmt(

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(
1325: g_pkg_name, l_api_name, l_progress, 'l_ctx', l_ctx);
1326:
1327:
1328: -- change rowset tag

Line 1348: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

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;
1351:
1352:

Line 1386: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

1382: BEGIN
1383: l_api_name := 'construct_output';
1384: l_progress := '000';
1385:
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;

Line 1444: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

1440: WHERE currency_code = p_para_rec.currency_code;
1441: END IF;
1442: EXCEPTION
1443: WHEN OTHERS THEN
1444: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
1445: END;
1446: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1447: l_para_meaning_list :=
1448: '' ||

Line 1477: FUN_UTIL.log_conc_stmt(

1473:
1474: -- Process the XML data source and save to output file
1475: l_progress := '030';
1476: IF (p_para_rec.batch_type = 'BOTH') THEN
1477: FUN_UTIL.log_conc_stmt(
1478: g_pkg_name, l_api_name, l_progress, 'construct both', '');
1479: IF DBMS_LOB.getlength(p_outbound_trxs) IS NULL THEN
1480: l_progress := '030.a';
1481: FND_FILE.put_line(FND_FILE.output, ' ');

Line 1491: FUN_UTIL.log_conc_stmt(

1487: lob_loc => p_outbound_trxs,
1488: pattern => '?>',
1489: offset => 1,
1490: nth => 1);
1491: FUN_UTIL.log_conc_stmt(
1492: g_pkg_name, l_api_name, l_progress, 'l_offset', l_offset);
1493:
1494: save_xml(
1495: x_return_status => x_return_status,

Line 1519: FUN_UTIL.log_conc_stmt(

1515: lob_loc => p_inbound_trxs,
1516: pattern => '?>',
1517: offset => 1,
1518: nth => 1);
1519: FUN_UTIL.log_conc_stmt(
1520: g_pkg_name, l_api_name, l_progress, 'l_offset', l_offset);
1521:
1522: save_xml(
1523: x_return_status => x_return_status,

Line 1545: FUN_UTIL.log_conc_stmt(

1541: lob_loc => p_inbound_trxs,
1542: pattern => '?>',
1543: offset => 1,
1544: nth => 1);
1545: FUN_UTIL.log_conc_stmt(
1546: g_pkg_name, l_api_name, l_progress, 'l_offset', l_offset);
1547:
1548: save_xml(
1549: x_return_status => x_return_status,

Line 1567: FUN_UTIL.log_conc_stmt(

1563: lob_loc => p_outbound_trxs,
1564: pattern => '?>',
1565: offset => 1,
1566: nth => 1);
1567: FUN_UTIL.log_conc_stmt(
1568: g_pkg_name, l_api_name, l_progress, 'l_offset', l_offset);
1569:
1570: save_xml(
1571: x_return_status => x_return_status,

Line 1590: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

1586:
1587: FND_FILE.put_line(FND_FILE.output, '');
1588:
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;

Line 1595: FUN_UTIL.log_conc_err(

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
1599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1600: 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
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1605: FUN_UTIL.log_conc_unexp(

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;
1609:

Line 1647: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

1643: BEGIN
1644: l_api_name := 'construct_account_output';
1645: l_progress := '000';
1646:
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;

Line 1711: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);

1707: WHERE ledger_id = p_para_rec.trading_ledger;
1708: END IF;
1709: EXCEPTION
1710: WHEN OTHERS THEN
1711: FUN_UTIL.log_conc_unexp(g_pkg_name, l_api_name, l_progress);
1712: END;
1713: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1714: l_para_meaning_list :=
1715: '' ||

Line 1753: FUN_UTIL.log_conc_stmt(

1749:
1750: -- Save the parameter list to output file
1751: l_progress := '020';
1752: FND_FILE.put_line(FND_FILE.output, l_para_meaning_list);
1753: FUN_UTIL.log_conc_stmt(
1754: g_pkg_name, l_api_name, l_progress, 'xml_parameters',l_para_meaning_list);
1755:
1756:
1757:

Line 1762: FUN_UTIL.log_conc_stmt(

1758: -- Process the XML data source and save to output file
1759: l_progress := '030';
1760:
1761:
1762: FUN_UTIL.log_conc_stmt(
1763: g_pkg_name, l_api_name, l_progress, 'construct both', '');
1764: IF DBMS_LOB.getlength(p_trxs) IS NULL THEN
1765: l_progress := '030.a';
1766: ELSE

Line 1775: FUN_UTIL.log_conc_stmt(

1771: lob_loc => p_trxs,
1772: pattern => '?>',
1773: offset => 1,
1774: nth => 1);
1775: FUN_UTIL.log_conc_stmt(
1776: g_pkg_name, l_api_name, l_progress, 'l_offset', l_offset);
1777:
1778: save_xml(
1779: x_return_status => x_return_status,

Line 1805: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

1801:
1802: FND_FILE.put_line(FND_FILE.output, '');
1803:
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;

Line 1810: FUN_UTIL.log_conc_err(

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
1814: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1815: 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
1819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1820: FUN_UTIL.log_conc_unexp(

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;
1824:

Line 1852: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

1848: l_api_name := 'save_xml';
1849: l_progress := '000';
1850: l_pos := p_offset;
1851:
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;

Line 1860: FUN_UTIL.log_conc_stmt(

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(
1861: g_pkg_name, l_api_name, l_progress, 'l_length', l_length);
1862:
1863: WHILE (l_pos <= l_length)
1864: LOOP

Line 1868: -- FUN_UTIL.log_conc_stmt(g_pkg_name, l_api_name, l_progress, 'xml_date',l_buffer);

1864: LOOP
1865: DBMS_LOB.read(p_trxs, l_amount, l_pos, l_buffer);
1866: FND_FILE.put(FND_FILE.output, l_buffer);
1867:
1868: -- FUN_UTIL.log_conc_stmt(g_pkg_name, l_api_name, l_progress, 'xml_date',l_buffer);
1869: -- l_buffer:=NULL;
1870:
1871: l_pos := l_pos + l_amount;
1872: END LOOP;

Line 1876: FUN_UTIL.log_conc_unexp(

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;
1880:

Line 1930: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

1926: retcode := 0;
1927:
1928:
1929: -- Save the in parameters in fnd log file
1930: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1931: FUN_UTIL.log_conc_stmt(
1932: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
1933: FUN_UTIL.log_conc_stmt(
1934: g_pkg_name, l_api_name, l_progress, 'p_initiator_id', p_initiator_id);

Line 1931: FUN_UTIL.log_conc_stmt(

1927:
1928:
1929: -- Save the in parameters in fnd log file
1930: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1931: FUN_UTIL.log_conc_stmt(
1932: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
1933: FUN_UTIL.log_conc_stmt(
1934: g_pkg_name, l_api_name, l_progress, 'p_initiator_id', p_initiator_id);
1935: FUN_UTIL.log_conc_stmt(

Line 1933: FUN_UTIL.log_conc_stmt(

1929: -- Save the in parameters in fnd log file
1930: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
1931: FUN_UTIL.log_conc_stmt(
1932: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
1933: FUN_UTIL.log_conc_stmt(
1934: g_pkg_name, l_api_name, l_progress, 'p_initiator_id', p_initiator_id);
1935: FUN_UTIL.log_conc_stmt(
1936: g_pkg_name, l_api_name, l_progress, 'p_recipient_id', p_recipient_id);
1937: FUN_UTIL.log_conc_stmt(

Line 1935: FUN_UTIL.log_conc_stmt(

1931: FUN_UTIL.log_conc_stmt(
1932: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
1933: FUN_UTIL.log_conc_stmt(
1934: g_pkg_name, l_api_name, l_progress, 'p_initiator_id', p_initiator_id);
1935: FUN_UTIL.log_conc_stmt(
1936: g_pkg_name, l_api_name, l_progress, 'p_recipient_id', p_recipient_id);
1937: FUN_UTIL.log_conc_stmt(
1938: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
1939: FUN_UTIL.log_conc_stmt(

Line 1937: FUN_UTIL.log_conc_stmt(

1933: FUN_UTIL.log_conc_stmt(
1934: g_pkg_name, l_api_name, l_progress, 'p_initiator_id', p_initiator_id);
1935: FUN_UTIL.log_conc_stmt(
1936: g_pkg_name, l_api_name, l_progress, 'p_recipient_id', p_recipient_id);
1937: FUN_UTIL.log_conc_stmt(
1938: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
1939: FUN_UTIL.log_conc_stmt(
1940: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
1941: FUN_UTIL.log_conc_stmt(

Line 1939: FUN_UTIL.log_conc_stmt(

1935: FUN_UTIL.log_conc_stmt(
1936: g_pkg_name, l_api_name, l_progress, 'p_recipient_id', p_recipient_id);
1937: FUN_UTIL.log_conc_stmt(
1938: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
1939: FUN_UTIL.log_conc_stmt(
1940: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
1941: FUN_UTIL.log_conc_stmt(
1942: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
1943: FUN_UTIL.log_conc_stmt(

Line 1941: FUN_UTIL.log_conc_stmt(

1937: FUN_UTIL.log_conc_stmt(
1938: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
1939: FUN_UTIL.log_conc_stmt(
1940: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
1941: FUN_UTIL.log_conc_stmt(
1942: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
1943: FUN_UTIL.log_conc_stmt(
1944: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
1945: FUN_UTIL.log_conc_stmt(

Line 1943: FUN_UTIL.log_conc_stmt(

1939: FUN_UTIL.log_conc_stmt(
1940: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
1941: FUN_UTIL.log_conc_stmt(
1942: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
1943: FUN_UTIL.log_conc_stmt(
1944: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
1945: FUN_UTIL.log_conc_stmt(
1946: g_pkg_name, l_api_name, l_progress, 'p_batch_date_from', p_batch_date_from);
1947: FUN_UTIL.log_conc_stmt(

Line 1945: FUN_UTIL.log_conc_stmt(

1941: FUN_UTIL.log_conc_stmt(
1942: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
1943: FUN_UTIL.log_conc_stmt(
1944: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
1945: FUN_UTIL.log_conc_stmt(
1946: g_pkg_name, l_api_name, l_progress, 'p_batch_date_from', p_batch_date_from);
1947: FUN_UTIL.log_conc_stmt(
1948: g_pkg_name, l_api_name, l_progress, 'p_batch_date_to', p_batch_date_to);
1949: FUN_UTIL.log_conc_stmt(

Line 1947: FUN_UTIL.log_conc_stmt(

1943: FUN_UTIL.log_conc_stmt(
1944: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
1945: FUN_UTIL.log_conc_stmt(
1946: g_pkg_name, l_api_name, l_progress, 'p_batch_date_from', p_batch_date_from);
1947: FUN_UTIL.log_conc_stmt(
1948: g_pkg_name, l_api_name, l_progress, 'p_batch_date_to', p_batch_date_to);
1949: FUN_UTIL.log_conc_stmt(
1950: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
1951: FUN_UTIL.log_conc_stmt(

Line 1949: FUN_UTIL.log_conc_stmt(

1945: FUN_UTIL.log_conc_stmt(
1946: g_pkg_name, l_api_name, l_progress, 'p_batch_date_from', p_batch_date_from);
1947: FUN_UTIL.log_conc_stmt(
1948: g_pkg_name, l_api_name, l_progress, 'p_batch_date_to', p_batch_date_to);
1949: FUN_UTIL.log_conc_stmt(
1950: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
1951: FUN_UTIL.log_conc_stmt(
1952: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
1953: FUN_UTIL.log_conc_stmt(

Line 1951: FUN_UTIL.log_conc_stmt(

1947: FUN_UTIL.log_conc_stmt(
1948: g_pkg_name, l_api_name, l_progress, 'p_batch_date_to', p_batch_date_to);
1949: FUN_UTIL.log_conc_stmt(
1950: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
1951: FUN_UTIL.log_conc_stmt(
1952: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
1953: FUN_UTIL.log_conc_stmt(
1954: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
1955: FUN_UTIL.log_conc_stmt(

Line 1953: FUN_UTIL.log_conc_stmt(

1949: FUN_UTIL.log_conc_stmt(
1950: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
1951: FUN_UTIL.log_conc_stmt(
1952: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
1953: FUN_UTIL.log_conc_stmt(
1954: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
1955: FUN_UTIL.log_conc_stmt(
1956: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
1957: FUN_UTIL.log_conc_stmt(

Line 1955: FUN_UTIL.log_conc_stmt(

1951: FUN_UTIL.log_conc_stmt(
1952: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
1953: FUN_UTIL.log_conc_stmt(
1954: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
1955: FUN_UTIL.log_conc_stmt(
1956: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
1957: FUN_UTIL.log_conc_stmt(
1958: g_pkg_name, l_api_name, l_progress, 'p_invoice_flag', p_invoice_flag);
1959: FUN_UTIL.log_conc_stmt(

Line 1957: FUN_UTIL.log_conc_stmt(

1953: FUN_UTIL.log_conc_stmt(
1954: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
1955: FUN_UTIL.log_conc_stmt(
1956: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
1957: FUN_UTIL.log_conc_stmt(
1958: g_pkg_name, l_api_name, l_progress, 'p_invoice_flag', p_invoice_flag);
1959: FUN_UTIL.log_conc_stmt(
1960: g_pkg_name, l_api_name, l_progress, 'p_ar_invoice_number', p_ar_invoice_number);
1961:

Line 1959: FUN_UTIL.log_conc_stmt(

1955: FUN_UTIL.log_conc_stmt(
1956: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
1957: FUN_UTIL.log_conc_stmt(
1958: g_pkg_name, l_api_name, l_progress, 'p_invoice_flag', p_invoice_flag);
1959: FUN_UTIL.log_conc_stmt(
1960: g_pkg_name, l_api_name, l_progress, 'p_ar_invoice_number', p_ar_invoice_number);
1961:
1962:
1963: -- initialize summaryreport parameters record

Line 1986: FUN_UTIL.log_conc_stmt(

1982: -- Based on batch type, build the query to get inbound, outbound or both
1983: -- transactions
1984: l_progress := '030';
1985: IF (p_batch_type = 'BOTH') THEN
1986: FUN_UTIL.log_conc_stmt(
1987: g_pkg_name, l_api_name, l_progress, '', 'call build_summary_outquery');
1988: build_summary_outquery(
1989: x_return_status => l_return_status,
1990: p_para_rec => l_para_rec,

Line 1994: FUN_UTIL.log_conc_stmt(

1990: p_para_rec => l_para_rec,
1991: x_outbound_query => l_outbound_query
1992: );
1993:
1994: FUN_UTIL.log_conc_stmt(
1995: g_pkg_name, l_api_name, l_progress, '', 'call build_summary_inquery');
1996: build_summary_inquery(
1997: x_return_status => l_return_status,
1998: p_para_rec => l_para_rec,

Line 2002: FUN_UTIL.log_conc_stmt(

1998: p_para_rec => l_para_rec,
1999: x_inbound_query => l_inbound_query
2000: );
2001: ELSIF (p_batch_type = 'IN') THEN
2002: FUN_UTIL.log_conc_stmt(
2003: g_pkg_name, l_api_name, l_progress, '', 'call build_summary_inquery');
2004: build_summary_inquery(
2005: x_return_status => l_return_status,
2006: p_para_rec => l_para_rec,

Line 2010: FUN_UTIL.log_conc_stmt(

2006: p_para_rec => l_para_rec,
2007: x_inbound_query => l_inbound_query
2008: );
2009: ELSIF (p_batch_type = 'OUT') THEN
2010: FUN_UTIL.log_conc_stmt(
2011: g_pkg_name, l_api_name, l_progress, '', 'call build_summary_outquery');
2012: build_summary_outquery(
2013: x_return_status => l_return_status,
2014: p_para_rec => l_para_rec,

Line 2018: FUN_UTIL.log_conc_stmt(

2014: p_para_rec => l_para_rec,
2015: x_outbound_query => l_outbound_query
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:

Line 2033: FUN_UTIL.log_conc_stmt(

2029:
2030: -- Get the XML data source
2031: l_progress := '040';
2032: IF (p_batch_type = 'BOTH') THEN
2033: FUN_UTIL.log_conc_stmt(
2034: g_pkg_name, l_api_name, l_progress, '', 'call get_xml for outbound');
2035: get_xml(
2036: x_return_status => l_return_status,
2037: p_query => l_outbound_query,

Line 2043: FUN_UTIL.log_conc_stmt(

2039: p_row_tag => 'OUTBOUND_BATCH',
2040: x_xml => l_outbound_trxs
2041: );
2042:
2043: FUN_UTIL.log_conc_stmt(
2044: g_pkg_name, l_api_name, l_progress, '', 'call get_xml for inbound');
2045: get_xml(
2046: x_return_status => l_return_status,
2047: p_query => l_inbound_query,

Line 2053: FUN_UTIL.log_conc_stmt(

2049: p_row_tag => 'INBOUND_BATCH',
2050: x_xml => l_inbound_trxs
2051: );
2052: ELSIF (p_batch_type = 'IN') THEN
2053: FUN_UTIL.log_conc_stmt(
2054: g_pkg_name, l_api_name, l_progress, '', 'call get_xml for inbound');
2055: get_xml(
2056: x_return_status => l_return_status,
2057: p_query => l_inbound_query,

Line 2063: FUN_UTIL.log_conc_stmt(

2059: p_row_tag => 'INBOUND_BATCH',
2060: x_xml => l_inbound_trxs
2061: );
2062: ELSIF (p_batch_type = 'OUT') THEN
2063: FUN_UTIL.log_conc_stmt(
2064: g_pkg_name, l_api_name, l_progress, '', 'call get_xml for outbound');
2065: get_xml(
2066: x_return_status => l_return_status,
2067: p_query => l_outbound_query,

Line 2082: FUN_UTIL.log_conc_stmt(

2078:
2079: -- Manupulate XML data source to XML Publisher compatiable format
2080: -- and save it to output file
2081: l_progress := '050';
2082: FUN_UTIL.log_conc_stmt(
2083: g_pkg_name, l_api_name, l_progress, '', 'call construct_output');
2084: construct_output(
2085: x_return_status => l_return_status,
2086: p_para_rec => l_para_rec,

Line 2095: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

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:
2097: EXCEPTION
2098: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2099: retcode := 2;

Line 2100: FUN_UTIL.log_conc_err(

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
2103: retcode := 2;
2104: FUN_UTIL.log_conc_unexp(

Line 2104: FUN_UTIL.log_conc_unexp(

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(
2107: g_pkg_name, l_api_name, l_progress, 'error in create_summaryreport');
2108: WHEN OTHERS THEN

Line 2106: FUN_UTIL.log_conc_err(

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(
2107: g_pkg_name, l_api_name, l_progress, 'error in create_summaryreport');
2108: WHEN OTHERS THEN
2109: retcode := 2;
2110: FUN_UTIL.log_conc_err(

Line 2110: FUN_UTIL.log_conc_err(

2106: FUN_UTIL.log_conc_err(
2107: g_pkg_name, l_api_name, l_progress, 'error in create_summaryreport');
2108: WHEN OTHERS THEN
2109: retcode := 2;
2110: FUN_UTIL.log_conc_err(
2111: g_pkg_name, l_api_name, l_progress, 'error in create_summaryreport');
2112: END create_summaryreport;
2113:
2114:

Line 2174: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);

2170: retcode := 0;
2171:
2172:
2173: -- Save the in parameters in fnd log file
2174: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
2175: FUN_UTIL.log_conc_stmt(
2176: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
2177: FUN_UTIL.log_conc_stmt(
2178: g_pkg_name, l_api_name, l_progress, 'p_initiator_from', p_initiator_from);

Line 2175: FUN_UTIL.log_conc_stmt(

2171:
2172:
2173: -- Save the in parameters in fnd log file
2174: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
2175: FUN_UTIL.log_conc_stmt(
2176: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
2177: FUN_UTIL.log_conc_stmt(
2178: g_pkg_name, l_api_name, l_progress, 'p_initiator_from', p_initiator_from);
2179: FUN_UTIL.log_conc_stmt(

Line 2177: FUN_UTIL.log_conc_stmt(

2173: -- Save the in parameters in fnd log file
2174: FUN_UTIL.log_conc_start(g_pkg_name, l_api_name);
2175: FUN_UTIL.log_conc_stmt(
2176: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
2177: FUN_UTIL.log_conc_stmt(
2178: g_pkg_name, l_api_name, l_progress, 'p_initiator_from', p_initiator_from);
2179: FUN_UTIL.log_conc_stmt(
2180: g_pkg_name, l_api_name, l_progress, 'p_recipient_from', p_recipient_from);
2181: FUN_UTIL.log_conc_stmt(

Line 2179: FUN_UTIL.log_conc_stmt(

2175: FUN_UTIL.log_conc_stmt(
2176: g_pkg_name, l_api_name, l_progress, 'p_batch_type', p_batch_type);
2177: FUN_UTIL.log_conc_stmt(
2178: g_pkg_name, l_api_name, l_progress, 'p_initiator_from', p_initiator_from);
2179: FUN_UTIL.log_conc_stmt(
2180: g_pkg_name, l_api_name, l_progress, 'p_recipient_from', p_recipient_from);
2181: FUN_UTIL.log_conc_stmt(
2182: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
2183: FUN_UTIL.log_conc_stmt(

Line 2181: FUN_UTIL.log_conc_stmt(

2177: FUN_UTIL.log_conc_stmt(
2178: g_pkg_name, l_api_name, l_progress, 'p_initiator_from', p_initiator_from);
2179: FUN_UTIL.log_conc_stmt(
2180: g_pkg_name, l_api_name, l_progress, 'p_recipient_from', p_recipient_from);
2181: FUN_UTIL.log_conc_stmt(
2182: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
2183: FUN_UTIL.log_conc_stmt(
2184: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
2185: FUN_UTIL.log_conc_stmt(

Line 2183: FUN_UTIL.log_conc_stmt(

2179: FUN_UTIL.log_conc_stmt(
2180: g_pkg_name, l_api_name, l_progress, 'p_recipient_from', p_recipient_from);
2181: FUN_UTIL.log_conc_stmt(
2182: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
2183: FUN_UTIL.log_conc_stmt(
2184: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
2185: FUN_UTIL.log_conc_stmt(
2186: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
2187: FUN_UTIL.log_conc_stmt(

Line 2185: FUN_UTIL.log_conc_stmt(

2181: FUN_UTIL.log_conc_stmt(
2182: g_pkg_name, l_api_name, l_progress, 'p_batch_number_from', p_batch_number_from);
2183: FUN_UTIL.log_conc_stmt(
2184: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
2185: FUN_UTIL.log_conc_stmt(
2186: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
2187: FUN_UTIL.log_conc_stmt(
2188: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
2189: FUN_UTIL.log_conc_stmt(

Line 2187: FUN_UTIL.log_conc_stmt(

2183: FUN_UTIL.log_conc_stmt(
2184: g_pkg_name, l_api_name, l_progress, 'p_batch_number_to', p_batch_number_to);
2185: FUN_UTIL.log_conc_stmt(
2186: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
2187: FUN_UTIL.log_conc_stmt(
2188: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
2189: FUN_UTIL.log_conc_stmt(
2190: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
2191: FUN_UTIL.log_conc_stmt(

Line 2189: FUN_UTIL.log_conc_stmt(

2185: FUN_UTIL.log_conc_stmt(
2186: g_pkg_name, l_api_name, l_progress, 'p_gl_date_from', p_gl_date_from);
2187: FUN_UTIL.log_conc_stmt(
2188: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
2189: FUN_UTIL.log_conc_stmt(
2190: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
2191: FUN_UTIL.log_conc_stmt(
2192: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
2193: FUN_UTIL.log_conc_stmt(

Line 2191: FUN_UTIL.log_conc_stmt(

2187: FUN_UTIL.log_conc_stmt(
2188: g_pkg_name, l_api_name, l_progress, 'p_gl_date_to', p_gl_date_to);
2189: FUN_UTIL.log_conc_stmt(
2190: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
2191: FUN_UTIL.log_conc_stmt(
2192: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
2193: FUN_UTIL.log_conc_stmt(
2194: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
2195: FUN_UTIL.log_conc_stmt(

Line 2193: FUN_UTIL.log_conc_stmt(

2189: FUN_UTIL.log_conc_stmt(
2190: g_pkg_name, l_api_name, l_progress, 'p_batch_status', p_batch_status);
2191: FUN_UTIL.log_conc_stmt(
2192: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
2193: FUN_UTIL.log_conc_stmt(
2194: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
2195: FUN_UTIL.log_conc_stmt(
2196: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
2197: FUN_UTIL.log_conc_stmt(

Line 2195: FUN_UTIL.log_conc_stmt(

2191: FUN_UTIL.log_conc_stmt(
2192: g_pkg_name, l_api_name, l_progress, 'p_transaction_status', p_transaction_status);
2193: FUN_UTIL.log_conc_stmt(
2194: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
2195: FUN_UTIL.log_conc_stmt(
2196: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
2197: FUN_UTIL.log_conc_stmt(
2198: g_pkg_name, l_api_name, l_progress, 'p_acc_type', p_acc_type);
2199: FUN_UTIL.log_conc_stmt(

Line 2197: FUN_UTIL.log_conc_stmt(

2193: FUN_UTIL.log_conc_stmt(
2194: g_pkg_name, l_api_name, l_progress, 'p_trx_type_id', p_trx_type_id);
2195: FUN_UTIL.log_conc_stmt(
2196: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
2197: FUN_UTIL.log_conc_stmt(
2198: g_pkg_name, l_api_name, l_progress, 'p_acc_type', p_acc_type);
2199: FUN_UTIL.log_conc_stmt(
2200: g_pkg_name, l_api_name, l_progress, 'p_ar_invoice_number', p_ar_invoice_number);
2201:

Line 2199: FUN_UTIL.log_conc_stmt(

2195: FUN_UTIL.log_conc_stmt(
2196: g_pkg_name, l_api_name, l_progress, 'p_currency_code', p_currency_code);
2197: FUN_UTIL.log_conc_stmt(
2198: g_pkg_name, l_api_name, l_progress, 'p_acc_type', p_acc_type);
2199: FUN_UTIL.log_conc_stmt(
2200: g_pkg_name, l_api_name, l_progress, 'p_ar_invoice_number', p_ar_invoice_number);
2201:
2202:
2203: -- initialize accountreport parameters record

Line 2243: FUN_UTIL.log_conc_stmt(

2239:
2240:
2241:
2242: IF (p_batch_type = 'BOTH') THEN
2243: FUN_UTIL.log_conc_stmt(
2244: g_pkg_name, l_api_name, l_progress, '', 'call build_account_outquery');
2245: build_account_outquery(
2246: x_return_status => l_return_status,
2247: p_para_rec => l_para_rec,

Line 2251: FUN_UTIL.log_conc_stmt(

2247: p_para_rec => l_para_rec,
2248: x_outbound_query => l_outbound_query
2249: );
2250:
2251: FUN_UTIL.log_conc_stmt(
2252: g_pkg_name, l_api_name, l_progress, '', 'call build_account_inquery');
2253: build_account_inquery(
2254: x_return_status => l_return_status,
2255: p_para_rec => l_para_rec,

Line 2259: FUN_UTIL.log_conc_stmt(

2255: p_para_rec => l_para_rec,
2256: x_inbound_query => l_inbound_query
2257: );
2258: ELSIF (p_batch_type = 'IN') THEN
2259: FUN_UTIL.log_conc_stmt(
2260: g_pkg_name, l_api_name, l_progress, '', 'call build_account_inquery');
2261: build_account_inquery(
2262: x_return_status => l_return_status,
2263: p_para_rec => l_para_rec,

Line 2267: FUN_UTIL.log_conc_stmt(

2263: p_para_rec => l_para_rec,
2264: x_inbound_query => l_inbound_query
2265: );
2266: ELSIF (p_batch_type = 'OUT') THEN
2267: FUN_UTIL.log_conc_stmt(
2268: g_pkg_name, l_api_name, l_progress, '', 'call build_account_outquery');
2269: build_account_outquery(
2270: x_return_status => l_return_status,
2271: p_para_rec => l_para_rec,

Line 2275: FUN_UTIL.log_conc_stmt(

2271: p_para_rec => l_para_rec,
2272: x_outbound_query => l_outbound_query
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:

Line 2313: FUN_UTIL.log_conc_stmt(

2309:
2310: -- Manupulate XML data source to XML Publisher compatiable format
2311: -- and save it to output file
2312: l_progress := '050';
2313: FUN_UTIL.log_conc_stmt(
2314: g_pkg_name, l_api_name, l_progress, '', 'call construct_account_output');
2315: construct_account_output(
2316: x_return_status => l_return_status,
2317: p_para_rec => l_para_rec,

Line 2325: FUN_UTIL.log_conc_end(g_pkg_name, l_api_name);

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:
2327: EXCEPTION
2328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2329: retcode := 2;

Line 2330: FUN_UTIL.log_conc_err(

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
2333: retcode := 2;
2334: FUN_UTIL.log_conc_unexp(

Line 2334: FUN_UTIL.log_conc_unexp(

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(
2337: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2338: WHEN OTHERS THEN

Line 2336: FUN_UTIL.log_conc_err(

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(
2337: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2338: WHEN OTHERS THEN
2339: retcode := 2;
2340: FUN_UTIL.log_conc_err(

Line 2340: FUN_UTIL.log_conc_err(

2336: FUN_UTIL.log_conc_err(
2337: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2338: WHEN OTHERS THEN
2339: retcode := 2;
2340: FUN_UTIL.log_conc_err(
2341: g_pkg_name, l_api_name, l_progress, 'error in create_accountreport');
2342: END create_accountreport;
2343:
2344: END FUN_REPORT_PVT;