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.ARP_UTIL dependencies on ARP_UTIL

Line 1: PACKAGE BODY arp_util AS

1: PACKAGE BODY arp_util AS
2: /*$Header: ARCUTILB.pls 120.20 2006/06/30 14:45:18 shveeram ship $*/
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
5: -----------------------------------------------------------------------------

Line 210: debug('arp_util.calc_dynamic_amount()+' );

206:
207: BEGIN
208: --
209: IF PG_DEBUG in ('Y', 'C') THEN
210: debug('arp_util.calc_dynamic_amount()+' );
211: END IF;
212:
213: /*
214: FND_CURRENCY.get_info( nvl(P_currency_code,ARP_GLOBAL.functional_currency),

Line 222: debug('arp_util.calc_dynamic_amount()-' );

218: l_min_acct_unit,FALSE,'-XXX','XXX');
219: */
220:
221: IF PG_DEBUG in ('Y', 'C') THEN
222: debug('arp_util.calc_dynamic_amount()-' );
223: END IF;
224:
225: return( TO_NUMBER( TO_CHAR( P_amount*nvl(P_exchange_rate,1),
226: l_format_mask ) ) );

Line 231: debug( 'Exception: arp_util.calc_dynamic_amount' );

227:
228: EXCEPTION
229: WHEN OTHERS THEN
230: IF PG_DEBUG in ('Y', 'C') THEN
231: debug( 'Exception: arp_util.calc_dynamic_amount' );
232: END IF;
233: RAISE;
234:
235: END calc_dynamic_amount;

Line 322: | call to arp_util.functional_amount().

318: | 2/23/1996 H.Kaukovuo Fixed own bug, was returing ORA6512.
319: | 3/1/1996 H.Kaukovuo Fixed bug where p_master_from was null and
320: | caused ORA6512
321: | 8/28/1996 H.Kaukovuo Added parameters p_precision and p_mau to
322: | call to arp_util.functional_amount().
323: | 7/26/2000 skoukunt Fix 1353061, comment code which assume
324: | If a rate <> 1 is given, the currency to be
325: | foreign
326: +===========================================================================*/

Line 354: debug( 'arp_util.calc_acctd_amount()+');

350:
351: BEGIN
352:
353: IF PG_DEBUG in ('Y', 'C') THEN
354: debug( 'arp_util.calc_acctd_amount()+');
355: debug( '-- p_currency = '||p_currency);
356: debug( '-- p_precision = '||to_number(p_precision));
357: debug( '-- p_mau = '||TO_NUMBER(p_mau));
358: debug( '-- p_rate = '||TO_NUMBER(p_rate));

Line 450: p_acctd_master_to := arp_util.functional_amount(

446: END IF;
447:
448: IF (p_master_to IS NOT NULL)
449: THEN
450: p_acctd_master_to := arp_util.functional_amount(
451: amount => p_master_to
452: , currency_code => lc_currency_code
453: , exchange_rate => ln_exchange_rate
454: , precision => p_precision

Line 473: p_acctd_master_from := arp_util.functional_amount(

469: THEN
470: IF PG_DEBUG in ('Y', 'C') THEN
471: debug( 'Second functional_amount call');
472: END IF;
473: p_acctd_master_from := arp_util.functional_amount(
474: amount => p_master_from
475: , currency_code => lc_currency_code
476: , exchange_rate => ln_exchange_rate
477: , precision => p_precision

Line 525: debug( 'arp_util.calc_acctd_amount()-');

521: debug( '-- ** Procedure returns values:');
522: debug( '-- p_master_to : '||to_char(p_master_to));
523: debug( '-- p_acctd_master_to : '||to_char(p_acctd_master_to));
524: debug( '-- p_acctd_detail : '||to_char(p_acctd_detail));
525: debug( 'arp_util.calc_acctd_amount()-');
526: END IF;
527:
528: EXCEPTION
529: WHEN OTHERS THEN

Line 531: debug( 'Exception: arp_util.calc_acctd_amount()');

527:
528: EXCEPTION
529: WHEN OTHERS THEN
530: IF PG_DEBUG in ('Y', 'C') THEN
531: debug( 'Exception: arp_util.calc_acctd_amount()');
532: END IF;
533: RAISE;
534:
535: END; -- calc_acctd_amount()

Line 585: p_acctd_master_to := arp_util.func_amount(

581:
582:
583: IF (p_master_to IS NOT NULL)
584: THEN
585: p_acctd_master_to := arp_util.func_amount(
586: amount => p_master_to
587: , currency_code => lc_currency_code
588: , exchange_rate => ln_exchange_rate
589: , precision => p_precision

Line 609: p_acctd_master_from := arp_util.func_amount(

605: IF PG_DEBUG in ('Y', 'C') THEN
606: debug( 'Second functional_amount call');
607: END IF;
608:
609: p_acctd_master_from := arp_util.func_amount(
610: amount => p_master_from
611: , currency_code => lc_currency_code
612: , exchange_rate => ln_exchange_rate
613: , precision => p_precision

Line 639: debug( 'Exception: arp_util.calc_accounted_amount()');

635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: IF PG_DEBUG in ('Y', 'C') THEN
639: debug( 'Exception: arp_util.calc_accounted_amount()');
640: END IF;
641: RAISE;
642:
643: END; -- calc_accounted_amount()

Line 660: debug( 'arp_util.calc_amount_test()+');

656: --
657: BEGIN
658:
659: IF PG_DEBUG in ('Y', 'C') THEN
660: debug( 'arp_util.calc_amount_test()+');
661: debug( 'Test 1:');
662: END IF;
663:
664: acctd_master_from := NULL;

Line 749: debug( 'arp_util.validate_and_default_gl_date()+' );

745: ) RETURN BOOLEAN IS
746: l_result BOOLEAN;
747: BEGIN
748: IF PG_DEBUG in ('Y', 'C') THEN
749: debug( 'arp_util.validate_and_default_gl_date()+' );
750: END IF;
751: --
752: l_result := arp_standard.validate_and_default_gl_date(
753: gl_date, trx_date,

Line 761: debug( 'arp_util.validate_and_default_gl_date()-' );

757: p_set_of_books_id, p_application_id,
758: default_gl_date, defaulting_rule_used, error_message );
759: --
760: IF PG_DEBUG in ('Y', 'C') THEN
761: debug( 'arp_util.validate_and_default_gl_date()-' );
762: END IF;
763: --
764: RETURN l_result;
765: --

Line 769: debug( 'EXCEPTION: arp_util.validate_and_default_gl_date' );

765: --
766: EXCEPTION
767: WHEN OTHERS THEN
768: IF PG_DEBUG in ('Y', 'C') THEN
769: debug( 'EXCEPTION: arp_util.validate_and_default_gl_date' );
770: END IF;
771: RAISE;
772: END validate_and_default_gl_date;
773:

Line 819: debug( 'arp_util.validate_and_default_gl_date()+' );

815: l_result BOOLEAN;
816: l_default_gl_date date;
817: BEGIN
818: IF PG_DEBUG in ('Y', 'C') THEN
819: debug( 'arp_util.validate_and_default_gl_date()+' );
820: END IF;
821: --
822: l_result := arp_standard.validate_and_default_gl_date(
823: gl_date, trx_date,

Line 838: debug( 'arp_util.validate_and_default_gl_date()-' );

834: --
835: p_period_name := arp_standard.gl_period_name(l_default_gl_date);
836:
837: IF PG_DEBUG in ('Y', 'C') THEN
838: debug( 'arp_util.validate_and_default_gl_date()-' );
839: END IF;
840: --
841: RETURN l_result;
842: --

Line 847: debug( 'EXCEPTION: arp_util.validate_and_default_gl_date' );

843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: IF PG_DEBUG in ('Y', 'C') THEN
847: debug( 'EXCEPTION: arp_util.validate_and_default_gl_date' );
848: END IF;
849: RAISE;
850:
851: END validate_and_default_gl_date;

Line 864: debug( 'arp_util.is_gl_date_valid()+' );

860: l_bool BOOLEAN;
861:
862: BEGIN
863: IF PG_DEBUG in ('Y', 'C') THEN
864: debug( 'arp_util.is_gl_date_valid()+' );
865: END IF;
866:
867: IF ( p_gl_date is NULL ) THEN
868:

Line 870: debug( 'arp_util.is_gl_date_valid()-' );

866:
867: IF ( p_gl_date is NULL ) THEN
868:
869: IF PG_DEBUG in ('Y', 'C') THEN
870: debug( 'arp_util.is_gl_date_valid()-' );
871: END IF;
872: RETURN FALSE;
873:
874: END IF;

Line 888: debug( 'arp_util.is_gl_date_valid()-' );

884: TRUE -- check_period_status
885: );
886:
887: IF PG_DEBUG in ('Y', 'C') THEN
888: debug( 'arp_util.is_gl_date_valid()-' );
889: END IF;
890: RETURN l_bool;
891:
892: EXCEPTION

Line 895: debug( 'EXCEPTION: arp_util.is_gl_date_valid()' );

891:
892: EXCEPTION
893: WHEN OTHERS THEN
894: IF PG_DEBUG in ('Y', 'C') THEN
895: debug( 'EXCEPTION: arp_util.is_gl_date_valid()' );
896: END IF;
897: RAISE;
898: END is_gl_date_valid;
899: --

Line 910: debug( 'arp_util.is_gl_date_valid()+' );

906: l_bool BOOLEAN;
907:
908: BEGIN
909: IF PG_DEBUG in ('Y', 'C') THEN
910: debug( 'arp_util.is_gl_date_valid()+' );
911: END IF;
912:
913: IF( p_gl_date is NULL ) THEN
914:

Line 916: debug( 'arp_util.is_gl_date_valid()-' );

912:
913: IF( p_gl_date is NULL ) THEN
914:
915: IF PG_DEBUG in ('Y', 'C') THEN
916: debug( 'arp_util.is_gl_date_valid()-' );
917: END IF;
918: RETURN FALSE;
919:
920: END IF;

Line 934: debug( 'arp_util.is_gl_date_valid()-' );

930: TRUE -- check_period_status
931: );
932:
933: IF PG_DEBUG in ('Y', 'C') THEN
934: debug( 'arp_util.is_gl_date_valid()-' );
935: END IF;
936: RETURN l_bool;
937:
938: EXCEPTION

Line 941: debug( 'EXCEPTION: arp_util.is_gl_date_valid()' );

937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF PG_DEBUG in ('Y', 'C') THEN
941: debug( 'EXCEPTION: arp_util.is_gl_date_valid()' );
942: END IF;
943: RAISE;
944: END is_gl_date_valid;
945: --

Line 973: debug( 'arp_util.validate_gl_date()+' );

969: l_ret_code BOOLEAN;
970:
971: BEGIN
972: IF PG_DEBUG in ('Y', 'C') THEN
973: debug( 'arp_util.validate_gl_date()+' );
974: END IF;
975: --
976: l_ret_code := is_gl_date_valid( p_gl_date );
977: IF ( l_ret_code = FALSE ) THEN

Line 984: debug( 'arp_util.validate_gl_date()-' );

980: APP_EXCEPTION.raise_exception;
981: END IF;
982: --
983: IF PG_DEBUG in ('Y', 'C') THEN
984: debug( 'arp_util.validate_gl_date()-' );
985: END IF;
986: --
987: EXCEPTION
988: WHEN OTHERS THEN

Line 990: debug( 'EXCEPTION: arp_util.validate_gl_date' );

986: --
987: EXCEPTION
988: WHEN OTHERS THEN
989: IF PG_DEBUG in ('Y', 'C') THEN
990: debug( 'EXCEPTION: arp_util.validate_gl_date' );
991: END IF;
992: RAISE;
993: END validate_gl_date;
994:

Line 1028: debug( 'arp_util.validate_gl_date()+' );

1024: l_ret_code BOOLEAN;
1025:
1026: BEGIN
1027: IF PG_DEBUG in ('Y', 'C') THEN
1028: debug( 'arp_util.validate_gl_date()+' );
1029: END IF;
1030: --
1031: validate_gl_date(p_gl_date,
1032: p_module_name,

Line 1041: debug( 'arp_util.validate_gl_date()-' );

1037: --
1038: p_period_name := arp_standard.gl_period_name(p_gl_date);
1039:
1040: IF PG_DEBUG in ('Y', 'C') THEN
1041: debug( 'arp_util.validate_gl_date()-' );
1042: END IF;
1043:
1044: EXCEPTION
1045: WHEN OTHERS THEN

Line 1047: debug( 'EXCEPTION: arp_util.validate_gl_date' );

1043:
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: IF PG_DEBUG in ('Y', 'C') THEN
1047: debug( 'EXCEPTION: arp_util.validate_gl_date' );
1048: END IF;
1049: RAISE;
1050: END validate_gl_date;
1051:

Line 1066: debug('EXCEPTION: arp_util.close_cursor()', arp_global.MSG_LEVEL_BASIC);

1062: END IF;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: debug('EXCEPTION: arp_util.close_cursor()', arp_global.MSG_LEVEL_BASIC);
1067: RAISE;
1068: END close_cursor;
1069:
1070: /* ==================================================================================

Line 1141: debug( 'ARP_UTIL.Set_Buckets()+');

1137:
1138: BEGIN
1139:
1140: IF PG_DEBUG in ('Y', 'C') THEN
1141: debug( 'ARP_UTIL.Set_Buckets()+');
1142: END IF;
1143:
1144: l_run_amt_tot := 0;
1145: l_run_acctd_amt_tot := 0;

Line 1261: debug( 'ARP_UTIL.Set_Buckets()-');

1257: p_freight_acctd_amt := p_freight_acctd_amt - (l_run_acctd_amt_tot - p_header_acctd_amt);
1258: END IF;
1259:
1260: IF PG_DEBUG in ('Y', 'C') THEN
1261: debug( 'ARP_UTIL.Set_Buckets()-');
1262: END IF;
1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN

Line 1267: debug( 'EXCEPTION: ARP_UTIL.Set_Buckets');

1263:
1264: EXCEPTION
1265: WHEN OTHERS THEN
1266: IF PG_DEBUG in ('Y', 'C') THEN
1267: debug( 'EXCEPTION: ARP_UTIL.Set_Buckets');
1268: END IF;
1269: RAISE;
1270:
1271: END Set_Buckets;

Line 1308: p_desc_flex_rec IN OUT NOCOPY arp_util.attribute_rec_type,

1304:
1305: END;
1306:
1307: PROCEDURE Validate_Desc_Flexfield(
1308: p_desc_flex_rec IN OUT NOCOPY arp_util.attribute_rec_type,
1309: p_desc_flex_name IN VARCHAR2,
1310: p_return_status IN OUT NOCOPY varchar2
1311: ) IS
1312:

Line 1324: debug( 'arp_util.Validate_Desc_Flexfield()+');

1320: WHERE application_id = 222
1321: and descriptive_flexfield_name = p_desc_flex_name;
1322: BEGIN
1323: IF PG_DEBUG in ('Y', 'C') THEN
1324: debug( 'arp_util.Validate_Desc_Flexfield()+');
1325: END IF;
1326: p_return_status := FND_API.G_RET_STS_SUCCESS;
1327:
1328: OPEN desc_flex_exists;

Line 1426: debug( 'arp_util.Validate_Desc_Flexfield()-');

1422: debug( 'attribute12 : '||p_desc_flex_rec.attribute12);
1423: debug( 'attribute13 : '||p_desc_flex_rec.attribute13);
1424: debug( 'attribute14 : '||p_desc_flex_rec.attribute14);
1425: debug( 'attribute15 : '||p_desc_flex_rec.attribute15);
1426: debug( 'arp_util.Validate_Desc_Flexfield()-');
1427: END IF;
1428: END Validate_Desc_Flexfield;
1429:
1430: --

Line 1737: debug( 'arp_util.Substitute_Ccid()+');

1733:
1734: BEGIN
1735:
1736: IF PG_DEBUG in ('Y', 'C') THEN
1737: debug( 'arp_util.Substitute_Ccid()+');
1738: END IF;
1739:
1740: /*----------------------------------------------------------------------------+
1741: | Set other in out NOCOPY variables used by flex routine |

Line 1787: debug( 'arp_util.Substitute_Ccid()-');

1783:
1784: p_actual_ccid := l_actual_gain_loss_ccid;
1785:
1786: IF PG_DEBUG in ('Y', 'C') THEN
1787: debug( 'arp_util.Substitute_Ccid()-');
1788: END IF;
1789:
1790: EXCEPTION
1791: WHEN flex_subs_ccid_error THEN

Line 1838: debug( 'arp_util.Dynamic_Select()+');

1834: p_result OUT NOCOPY VARCHAR2)
1835: IS
1836: BEGIN
1837: IF PG_DEBUG in ('Y', 'C') THEN
1838: debug( 'arp_util.Dynamic_Select()+');
1839: END IF;
1840: EXECUTE IMMEDIATE p_query INTO p_result;
1841: IF PG_DEBUG in ('Y', 'C') THEN
1842: debug( 'arp_util.Dynamic_Select()-');

Line 1842: debug( 'arp_util.Dynamic_Select()-');

1838: debug( 'arp_util.Dynamic_Select()+');
1839: END IF;
1840: EXECUTE IMMEDIATE p_query INTO p_result;
1841: IF PG_DEBUG in ('Y', 'C') THEN
1842: debug( 'arp_util.Dynamic_Select()-');
1843: END IF;
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: IF PG_DEBUG in ('Y', 'C') THEN

Line 1847: debug('EXCEPTION: ARP_UTIL.Dynamic_Select');

1843: END IF;
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: IF PG_DEBUG in ('Y', 'C') THEN
1847: debug('EXCEPTION: ARP_UTIL.Dynamic_Select');
1848: debug('Dynamic_Select: ' || 'SELECT stmt : '||p_query);
1849: END IF;
1850: END Dynamic_Select;
1851:

Line 1874: debug( 'arp_util.get_txn_start_end_dates()+' );

1870: l_previous_customer_trx_id NUMBER;
1871:
1872: BEGIN
1873: IF PG_DEBUG in ('Y', 'C') THEN
1874: debug( 'arp_util.get_txn_start_end_dates()+' );
1875: debug( 'p_customer_trx_id=' || to_char(p_customer_trx_id));
1876: END IF;
1877:
1878: p_start_date := null;

Line 1925: debug( 'arp_util.get_txn_start_end_dates()-' );

1921: end if;
1922: end if;
1923:
1924: IF PG_DEBUG in ('Y', 'C') THEN
1925: debug( 'arp_util.get_txn_start_end_dates()-' );
1926: END IF;
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: IF PG_DEBUG in ('Y', 'C') THEN

Line 1930: debug( 'Exception: arp_util.get_txn_start_end_dates');

1926: END IF;
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: IF PG_DEBUG in ('Y', 'C') THEN
1930: debug( 'Exception: arp_util.get_txn_start_end_dates');
1931: END IF;
1932: RAISE;
1933: END Get_Txn_Start_End_Dates;
1934:

Line 1948: debug( 'arp_util.get_default_salesgroup()+' );

1944:
1945: l_group_id NUMBER;
1946: BEGIN
1947: IF PG_DEBUG in ('Y', 'C') THEN
1948: debug( 'arp_util.get_default_salesgroup()+' );
1949: END IF;
1950:
1951: -- here, we need to make the call to the JTF function
1952: -- jtf_rs_integration_pub.get_default_sales_group

Line 1967: debug( 'arp_util.get_default_salesgroup()-' );

1963:
1964: return l_group_id;
1965:
1966: IF PG_DEBUG in ('Y', 'C') THEN
1967: debug( 'arp_util.get_default_salesgroup()-' );
1968: END IF;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF PG_DEBUG in ('Y', 'C') THEN

Line 1972: debug( 'Exception: arp_util.get_default_salesgroup');

1968: END IF;
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF PG_DEBUG in ('Y', 'C') THEN
1972: debug( 'Exception: arp_util.get_default_salesgroup');
1973: END IF;
1974: RAISE;
1975: END Get_Default_SalesGroup;
1976:

Line 1985: debug( 'arp_util.get_default_salesgroup()+' );

1981: l_date DATE;
1982: l_org_id NUMBER;
1983: BEGIN
1984: IF PG_DEBUG in ('Y', 'C') THEN
1985: debug( 'arp_util.get_default_salesgroup()+' );
1986: END IF;
1987:
1988: l_date := null;
1989:

Line 1998: debug( 'arp_util.get_default_salesgroup()-' );

1994:
1995: return Get_Default_SalesGroup(p_salesrep_id, l_org_id, l_date);
1996:
1997: IF PG_DEBUG in ('Y', 'C') THEN
1998: debug( 'arp_util.get_default_salesgroup()-' );
1999: END IF;
2000: EXCEPTION
2001: WHEN NO_DATA_FOUND THEN
2002: IF PG_DEBUG in ('Y', 'C') THEN

Line 2003: debug( 'Exception: arp_util.get_default_salesgroup');

1999: END IF;
2000: EXCEPTION
2001: WHEN NO_DATA_FOUND THEN
2002: IF PG_DEBUG in ('Y', 'C') THEN
2003: debug( 'Exception: arp_util.get_default_salesgroup');
2004: debug( 'NO_DATA_FOUND: p_customer_trx_id=' || to_char(p_customer_trx_id));
2005: END IF;
2006: RAISE;
2007: WHEN OTHERS THEN

Line 2009: debug( 'Exception: arp_util.get_default_salesgroup');

2005: END IF;
2006: RAISE;
2007: WHEN OTHERS THEN
2008: IF PG_DEBUG in ('Y', 'C') THEN
2009: debug( 'Exception: arp_util.get_default_salesgroup');
2010: debug( 'p_customer_trx_id=' || to_char(p_customer_trx_id));
2011: END IF;
2012: RAISE;
2013: END Get_Default_SalesGroup;

Line 2032: debug('arp_util.Open_Period_Exists()+');

2028: l_sysparam_org_where VARCHAR2(2000);
2029: l_select_stmt VARCHAR2(10000);
2030: BEGIN
2031: IF PG_DEBUG in ('Y', 'C') THEN
2032: debug('arp_util.Open_Period_Exists()+');
2033: END IF;
2034:
2035: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
2036: l_value := 1;

Line 2039: IF arp_util.Open_Period_Exists(p_reporting_level,

2035: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
2036: l_value := 1;
2037:
2038: ELSIF p_gl_date_from IS NULL and p_gl_date_to IS NOT NULL THEN
2039: IF arp_util.Open_Period_Exists(p_reporting_level,
2040: p_reporting_entity_id,
2041: p_gl_date_to) THEN
2042: l_value := 1;
2043: END IF;

Line 2046: IF arp_util.Open_Period_Exists(p_reporting_level,

2042: l_value := 1;
2043: END IF;
2044:
2045: ELSIF p_gl_date_from IS NOT NULL and p_gl_date_to IS NULL THEN
2046: IF arp_util.Open_Period_Exists(p_reporting_level,
2047: p_reporting_entity_id,
2048: p_gl_date_from) THEN
2049: l_value := 1;
2050: END IF;

Line 2090: debug('arp_util.Open_Period_Exists()-');

2086: return FALSE;
2087: END IF;
2088:
2089: IF PG_DEBUG in ('Y', 'C') THEN
2090: debug('arp_util.Open_Period_Exists()-');
2091: END IF;
2092:
2093: EXCEPTION
2094: WHEN OTHERS THEN

Line 2096: debug('arp_util.Open_Period_Exists: Exception');

2092:
2093: EXCEPTION
2094: WHEN OTHERS THEN
2095: IF PG_DEBUG in ('Y', 'C') THEN
2096: debug('arp_util.Open_Period_Exists: Exception');
2097: END IF;
2098: return FALSE;
2099: END Open_Period_Exists;
2100:

Line 2112: debug('arp_util.Open_Period_Exists()+');

2108: l_sysparam_org_where VARCHAR2(2000);
2109: l_select_stmt VARCHAR2(10000);
2110: BEGIN
2111: IF PG_DEBUG in ('Y', 'C') THEN
2112: debug('arp_util.Open_Period_Exists()+');
2113: END IF;
2114:
2115: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2116:

Line 2151: debug('arp_util.Open_Period_Exists()-');

2147: RETURN FALSE;
2148: END IF;
2149:
2150: IF PG_DEBUG in ('Y', 'C') THEN
2151: debug('arp_util.Open_Period_Exists()-');
2152: END IF;
2153:
2154: EXCEPTION
2155: WHEN OTHERS THEN

Line 2157: debug('arp_util.Open_Period_Exists: Exception');

2153:
2154: EXCEPTION
2155: WHEN OTHERS THEN
2156: IF PG_DEBUG in ('Y', 'C') THEN
2157: debug('arp_util.Open_Period_Exists: Exception');
2158: END IF;
2159: RETURN FALSE;
2160: END Open_Period_Exists;
2161:

Line 2162: END arp_util;

2158: END IF;
2159: RETURN FALSE;
2160: END Open_Period_Exists;
2161:
2162: END arp_util;