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.26.12020000.2 2012/07/28 00:49:14 dgaurab 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 356: debug( 'arp_util.calc_acctd_amount()+');

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

Line 373: l_overapp_allow_flag := NVL(arp_util.PG_OVERAPP_ALLOW_FLAG, 'N');

369:
370: -- If detail not passed default to zero
371: ln_detail_amount := NVL(p_detail,0);
372: ln_exchange_rate := NVL(p_rate,1);
373: l_overapp_allow_flag := NVL(arp_util.PG_OVERAPP_ALLOW_FLAG, 'N');
374:
375: -- Determine if currency is functional currency.
376: -- If a rate <> 1 is given, assume the currency to be
377: -- foreign.

Line 453: p_acctd_master_to := arp_util.functional_amount(

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

Line 476: p_acctd_master_from := arp_util.functional_amount(

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

Line 518: p_acctd_master_to := p_acctd_master_from + arp_util.functional_amount(

514: OR
515: (l_acctd_detail <> 0) AND (ln_detail_amount = 0)
516: THEN
517: IF (p_type = '+') THEN
518: p_acctd_master_to := p_acctd_master_from + arp_util.functional_amount(
519: amount => ln_detail_amount
520: , currency_code => lc_currency_code
521: , exchange_rate => ln_exchange_rate
522: , PRECISION => p_precision

Line 525: p_acctd_master_to := p_acctd_master_from - arp_util.functional_amount(

521: , exchange_rate => ln_exchange_rate
522: , PRECISION => p_precision
523: , min_acc_unit => p_mau);
524: ELSE
525: p_acctd_master_to := p_acctd_master_from - arp_util.functional_amount(
526: amount => ln_detail_amount
527: , currency_code => lc_currency_code
528: , exchange_rate => ln_exchange_rate
529: , PRECISION => p_precision

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

580: debug( '-- p_acctd_master_to : '||to_char(p_acctd_master_to));
581: debug( '-- p_master_from : '||to_char(p_master_from));
582: debug( '-- p_acctd_master_from : '||to_char(p_acctd_master_from));
583: debug( '-- p_acctd_detail : '||to_char(p_acctd_detail));
584: debug( 'arp_util.calc_acctd_amount()-');
585: END IF;
586:
587: EXCEPTION
588: WHEN OTHERS THEN

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

586:
587: EXCEPTION
588: WHEN OTHERS THEN
589: IF PG_DEBUG in ('Y', 'C') THEN
590: debug( 'Exception: arp_util.calc_acctd_amount()');
591: END IF;
592: RAISE;
593:
594: END; -- calc_acctd_amount()

Line 644: p_acctd_master_to := arp_util.func_amount(

640:
641:
642: IF (p_master_to IS NOT NULL)
643: THEN
644: p_acctd_master_to := arp_util.func_amount(
645: amount => p_master_to
646: , currency_code => lc_currency_code
647: , exchange_rate => ln_exchange_rate
648: , precision => p_precision

Line 668: p_acctd_master_from := arp_util.func_amount(

664: IF PG_DEBUG in ('Y', 'C') THEN
665: debug( 'Second functional_amount call');
666: END IF;
667:
668: p_acctd_master_from := arp_util.func_amount(
669: amount => p_master_from
670: , currency_code => lc_currency_code
671: , exchange_rate => ln_exchange_rate
672: , precision => p_precision

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

694:
695: EXCEPTION
696: WHEN OTHERS THEN
697: IF PG_DEBUG in ('Y', 'C') THEN
698: debug( 'Exception: arp_util.calc_accounted_amount()');
699: END IF;
700: RAISE;
701:
702: END; -- calc_accounted_amount()

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

715: --
716: BEGIN
717:
718: IF PG_DEBUG in ('Y', 'C') THEN
719: debug( 'arp_util.calc_amount_test()+');
720: debug( 'Test 1:');
721: END IF;
722:
723: acctd_master_from := NULL;

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

804: ) RETURN BOOLEAN IS
805: l_result BOOLEAN;
806: BEGIN
807: IF PG_DEBUG in ('Y', 'C') THEN
808: debug( 'arp_util.validate_and_default_gl_date()+' );
809: END IF;
810: --
811: l_result := arp_standard.validate_and_default_gl_date(
812: gl_date, trx_date,

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

816: p_set_of_books_id, p_application_id,
817: default_gl_date, defaulting_rule_used, error_message );
818: --
819: IF PG_DEBUG in ('Y', 'C') THEN
820: debug( 'arp_util.validate_and_default_gl_date()-' );
821: END IF;
822: --
823: RETURN l_result;
824: --

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

824: --
825: EXCEPTION
826: WHEN OTHERS THEN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: debug( 'EXCEPTION: arp_util.validate_and_default_gl_date' );
829: END IF;
830: RAISE;
831: END validate_and_default_gl_date;
832:

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

874: l_result BOOLEAN;
875: l_default_gl_date date;
876: BEGIN
877: IF PG_DEBUG in ('Y', 'C') THEN
878: debug( 'arp_util.validate_and_default_gl_date()+' );
879: END IF;
880: --
881: l_result := arp_standard.validate_and_default_gl_date(
882: gl_date, trx_date,

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

893: --
894: p_period_name := arp_standard.gl_period_name(l_default_gl_date);
895:
896: IF PG_DEBUG in ('Y', 'C') THEN
897: debug( 'arp_util.validate_and_default_gl_date()-' );
898: END IF;
899: --
900: RETURN l_result;
901: --

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

902:
903: EXCEPTION
904: WHEN OTHERS THEN
905: IF PG_DEBUG in ('Y', 'C') THEN
906: debug( 'EXCEPTION: arp_util.validate_and_default_gl_date' );
907: END IF;
908: RAISE;
909:
910: END validate_and_default_gl_date;

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

919: l_bool BOOLEAN;
920:
921: BEGIN
922: IF PG_DEBUG in ('Y', 'C') THEN
923: debug( 'arp_util.is_gl_date_valid()+' );
924: END IF;
925:
926: IF ( p_gl_date is NULL ) THEN
927:

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

925:
926: IF ( p_gl_date is NULL ) THEN
927:
928: IF PG_DEBUG in ('Y', 'C') THEN
929: debug( 'arp_util.is_gl_date_valid()-' );
930: END IF;
931: RETURN FALSE;
932:
933: END IF;

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

943: TRUE -- check_period_status
944: );
945:
946: IF PG_DEBUG in ('Y', 'C') THEN
947: debug( 'arp_util.is_gl_date_valid()-' );
948: END IF;
949: RETURN l_bool;
950:
951: EXCEPTION

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

950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: IF PG_DEBUG in ('Y', 'C') THEN
954: debug( 'EXCEPTION: arp_util.is_gl_date_valid()' );
955: END IF;
956: RAISE;
957: END is_gl_date_valid;
958: --

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

965: l_bool BOOLEAN;
966:
967: BEGIN
968: IF PG_DEBUG in ('Y', 'C') THEN
969: debug( 'arp_util.is_gl_date_valid()+' );
970: END IF;
971:
972: IF( p_gl_date is NULL ) THEN
973:

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

971:
972: IF( p_gl_date is NULL ) THEN
973:
974: IF PG_DEBUG in ('Y', 'C') THEN
975: debug( 'arp_util.is_gl_date_valid()-' );
976: END IF;
977: RETURN FALSE;
978:
979: END IF;

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

989: TRUE -- check_period_status
990: );
991:
992: IF PG_DEBUG in ('Y', 'C') THEN
993: debug( 'arp_util.is_gl_date_valid()-' );
994: END IF;
995: RETURN l_bool;
996:
997: EXCEPTION

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

996:
997: EXCEPTION
998: WHEN OTHERS THEN
999: IF PG_DEBUG in ('Y', 'C') THEN
1000: debug( 'EXCEPTION: arp_util.is_gl_date_valid()' );
1001: END IF;
1002: RAISE;
1003: END is_gl_date_valid;
1004: --

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

1028: l_ret_code BOOLEAN;
1029:
1030: BEGIN
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: debug( 'arp_util.validate_gl_date()+' );
1033: END IF;
1034: --
1035: l_ret_code := is_gl_date_valid( p_gl_date );
1036: IF ( l_ret_code = FALSE ) THEN

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

1039: APP_EXCEPTION.raise_exception;
1040: END IF;
1041: --
1042: IF PG_DEBUG in ('Y', 'C') THEN
1043: debug( 'arp_util.validate_gl_date()-' );
1044: END IF;
1045: --
1046: EXCEPTION
1047: WHEN OTHERS THEN

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

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

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

1083: l_ret_code BOOLEAN;
1084:
1085: BEGIN
1086: IF PG_DEBUG in ('Y', 'C') THEN
1087: debug( 'arp_util.validate_gl_date()+' );
1088: END IF;
1089: --
1090: validate_gl_date(p_gl_date,
1091: p_module_name,

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

1096: --
1097: p_period_name := arp_standard.gl_period_name(p_gl_date);
1098:
1099: IF PG_DEBUG in ('Y', 'C') THEN
1100: debug( 'arp_util.validate_gl_date()-' );
1101: END IF;
1102:
1103: EXCEPTION
1104: WHEN OTHERS THEN

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

1102:
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: IF PG_DEBUG in ('Y', 'C') THEN
1106: debug( 'EXCEPTION: arp_util.validate_gl_date' );
1107: END IF;
1108: RAISE;
1109: END validate_gl_date;
1110:

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

1121: END IF;
1122:
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: debug('EXCEPTION: arp_util.close_cursor()', arp_global.MSG_LEVEL_BASIC);
1126: RAISE;
1127: END close_cursor;
1128:
1129: /* ==================================================================================

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

1196:
1197: BEGIN
1198:
1199: IF PG_DEBUG in ('Y', 'C') THEN
1200: debug( 'ARP_UTIL.Set_Buckets()+');
1201: END IF;
1202:
1203: l_run_amt_tot := 0;
1204: l_run_acctd_amt_tot := 0;

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

1316: p_freight_acctd_amt := p_freight_acctd_amt - (l_run_acctd_amt_tot - p_header_acctd_amt);
1317: END IF;
1318:
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: debug( 'ARP_UTIL.Set_Buckets()-');
1321: END IF;
1322:
1323: EXCEPTION
1324: WHEN OTHERS THEN

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

1322:
1323: EXCEPTION
1324: WHEN OTHERS THEN
1325: IF PG_DEBUG in ('Y', 'C') THEN
1326: debug( 'EXCEPTION: ARP_UTIL.Set_Buckets');
1327: END IF;
1328: RAISE;
1329:
1330: END Set_Buckets;

Line 1367: p_desc_flex_rec IN OUT NOCOPY arp_util.attribute_rec_type,

1363:
1364: END;
1365:
1366: PROCEDURE Validate_Desc_Flexfield(
1367: p_desc_flex_rec IN OUT NOCOPY arp_util.attribute_rec_type,
1368: p_desc_flex_name IN VARCHAR2,
1369: p_return_status IN OUT NOCOPY varchar2
1370: ) IS
1371:

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

1379: WHERE application_id = 222
1380: and descriptive_flexfield_name = p_desc_flex_name;
1381: BEGIN
1382: IF PG_DEBUG in ('Y', 'C') THEN
1383: debug( 'arp_util.Validate_Desc_Flexfield()+');
1384: END IF;
1385: p_return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: OPEN desc_flex_exists;

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

1481: debug( 'attribute12 : '||p_desc_flex_rec.attribute12);
1482: debug( 'attribute13 : '||p_desc_flex_rec.attribute13);
1483: debug( 'attribute14 : '||p_desc_flex_rec.attribute14);
1484: debug( 'attribute15 : '||p_desc_flex_rec.attribute15);
1485: debug( 'arp_util.Validate_Desc_Flexfield()-');
1486: END IF;
1487: END Validate_Desc_Flexfield;
1488:
1489: --

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

1792:
1793: BEGIN
1794:
1795: IF PG_DEBUG in ('Y', 'C') THEN
1796: debug( 'arp_util.Substitute_Ccid()+');
1797: END IF;
1798:
1799: /*----------------------------------------------------------------------------+
1800: | Set other in out NOCOPY variables used by flex routine |

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

1842:
1843: p_actual_ccid := l_actual_gain_loss_ccid;
1844:
1845: IF PG_DEBUG in ('Y', 'C') THEN
1846: debug( 'arp_util.Substitute_Ccid()-');
1847: END IF;
1848:
1849: EXCEPTION
1850: WHEN flex_subs_ccid_error THEN

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

1893: p_result OUT NOCOPY VARCHAR2)
1894: IS
1895: BEGIN
1896: IF PG_DEBUG in ('Y', 'C') THEN
1897: debug( 'arp_util.Dynamic_Select()+');
1898: END IF;
1899: EXECUTE IMMEDIATE p_query INTO p_result;
1900: IF PG_DEBUG in ('Y', 'C') THEN
1901: debug( 'arp_util.Dynamic_Select()-');

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

1897: debug( 'arp_util.Dynamic_Select()+');
1898: END IF;
1899: EXECUTE IMMEDIATE p_query INTO p_result;
1900: IF PG_DEBUG in ('Y', 'C') THEN
1901: debug( 'arp_util.Dynamic_Select()-');
1902: END IF;
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: IF PG_DEBUG in ('Y', 'C') THEN

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

1902: END IF;
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: IF PG_DEBUG in ('Y', 'C') THEN
1906: debug('EXCEPTION: ARP_UTIL.Dynamic_Select');
1907: debug('Dynamic_Select: ' || 'SELECT stmt : '||p_query);
1908: END IF;
1909: END Dynamic_Select;
1910:

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

1929: l_previous_customer_trx_id NUMBER;
1930:
1931: BEGIN
1932: IF PG_DEBUG in ('Y', 'C') THEN
1933: debug( 'arp_util.get_txn_start_end_dates()+' );
1934: debug( 'p_customer_trx_id=' || to_char(p_customer_trx_id));
1935: END IF;
1936:
1937: p_start_date := null;

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

1980: end if;
1981: end if;
1982:
1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: debug( 'arp_util.get_txn_start_end_dates()-' );
1985: END IF;
1986: EXCEPTION
1987: WHEN OTHERS THEN
1988: IF PG_DEBUG in ('Y', 'C') THEN

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

1985: END IF;
1986: EXCEPTION
1987: WHEN OTHERS THEN
1988: IF PG_DEBUG in ('Y', 'C') THEN
1989: debug( 'Exception: arp_util.get_txn_start_end_dates');
1990: END IF;
1991: RAISE;
1992: END Get_Txn_Start_End_Dates;
1993:

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

2003:
2004: l_group_id NUMBER;
2005: BEGIN
2006: IF PG_DEBUG in ('Y', 'C') THEN
2007: debug( 'arp_util.get_default_salesgroup()+' );
2008: END IF;
2009:
2010: -- here, we need to make the call to the JTF function
2011: -- jtf_rs_integration_pub.get_default_sales_group

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

2022:
2023: return l_group_id;
2024:
2025: IF PG_DEBUG in ('Y', 'C') THEN
2026: debug( 'arp_util.get_default_salesgroup()-' );
2027: END IF;
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: IF PG_DEBUG in ('Y', 'C') THEN

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

2027: END IF;
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: IF PG_DEBUG in ('Y', 'C') THEN
2031: debug( 'Exception: arp_util.get_default_salesgroup');
2032: END IF;
2033: RAISE;
2034: END Get_Default_SalesGroup;
2035:

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

2040: l_date DATE;
2041: l_org_id NUMBER;
2042: BEGIN
2043: IF PG_DEBUG in ('Y', 'C') THEN
2044: debug( 'arp_util.get_default_salesgroup()+' );
2045: END IF;
2046:
2047: l_date := null;
2048:

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

2053:
2054: return Get_Default_SalesGroup(p_salesrep_id, l_org_id, l_date);
2055:
2056: IF PG_DEBUG in ('Y', 'C') THEN
2057: debug( 'arp_util.get_default_salesgroup()-' );
2058: END IF;
2059: EXCEPTION
2060: WHEN NO_DATA_FOUND THEN
2061: IF PG_DEBUG in ('Y', 'C') THEN

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

2058: END IF;
2059: EXCEPTION
2060: WHEN NO_DATA_FOUND THEN
2061: IF PG_DEBUG in ('Y', 'C') THEN
2062: debug( 'Exception: arp_util.get_default_salesgroup');
2063: debug( 'NO_DATA_FOUND: p_customer_trx_id=' || to_char(p_customer_trx_id));
2064: END IF;
2065: RAISE;
2066: WHEN OTHERS THEN

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

2064: END IF;
2065: RAISE;
2066: WHEN OTHERS THEN
2067: IF PG_DEBUG in ('Y', 'C') THEN
2068: debug( 'Exception: arp_util.get_default_salesgroup');
2069: debug( 'p_customer_trx_id=' || to_char(p_customer_trx_id));
2070: END IF;
2071: RAISE;
2072: END Get_Default_SalesGroup;

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

2087: l_sysparam_org_where VARCHAR2(2000);
2088: l_select_stmt VARCHAR2(10000);
2089: BEGIN
2090: IF PG_DEBUG in ('Y', 'C') THEN
2091: debug('arp_util.Open_Period_Exists()+');
2092: END IF;
2093:
2094: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
2095: l_value := 1;

Line 2098: IF arp_util.Open_Period_Exists(p_reporting_level,

2094: IF p_gl_date_from IS NULL and p_gl_date_to IS NULL THEN
2095: l_value := 1;
2096:
2097: ELSIF p_gl_date_from IS NULL and p_gl_date_to IS NOT NULL THEN
2098: IF arp_util.Open_Period_Exists(p_reporting_level,
2099: p_reporting_entity_id,
2100: p_gl_date_to) THEN
2101: l_value := 1;
2102: END IF;

Line 2105: IF arp_util.Open_Period_Exists(p_reporting_level,

2101: l_value := 1;
2102: END IF;
2103:
2104: ELSIF p_gl_date_from IS NOT NULL and p_gl_date_to IS NULL THEN
2105: IF arp_util.Open_Period_Exists(p_reporting_level,
2106: p_reporting_entity_id,
2107: p_gl_date_from) THEN
2108: l_value := 1;
2109: END IF;

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

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

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

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

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

2167: l_sysparam_org_where VARCHAR2(2000);
2168: l_select_stmt VARCHAR2(10000);
2169: BEGIN
2170: IF PG_DEBUG in ('Y', 'C') THEN
2171: debug('arp_util.Open_Period_Exists()+');
2172: END IF;
2173:
2174: XLA_MO_REPORTING_API.Initialize(p_reporting_level, p_reporting_entity_id, 'AUTO');
2175:

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

2206: RETURN FALSE;
2207: END IF;
2208:
2209: IF PG_DEBUG in ('Y', 'C') THEN
2210: debug('arp_util.Open_Period_Exists()-');
2211: END IF;
2212:
2213: EXCEPTION
2214: WHEN OTHERS THEN

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

2212:
2213: EXCEPTION
2214: WHEN OTHERS THEN
2215: IF PG_DEBUG in ('Y', 'C') THEN
2216: debug('arp_util.Open_Period_Exists: Exception');
2217: END IF;
2218: RETURN FALSE;
2219: END Open_Period_Exists;
2220:

Line 2227: debug('arp_util.automatch_enabled()+');

2223: FUNCTION AUTOMATCH_ENABLED RETURN VARCHAR2 is
2224: l_automatch_enabled_flag VARCHAR2(1) := 'F';
2225: BEGIN
2226: IF PG_DEBUG in ('Y', 'C') THEN
2227: debug('arp_util.automatch_enabled()+');
2228: END IF;
2229: begin
2230: select NVL(automatch_enabled_flag,'F')
2231: into l_automatch_enabled_flag

Line 2247: debug('arp_util.automatch_enabled()-');

2243: RETURN 'FALSE';
2244: END IF;
2245:
2246: IF PG_DEBUG in ('Y', 'C') THEN
2247: debug('arp_util.automatch_enabled()-');
2248: END IF;
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: IF PG_DEBUG in ('Y', 'C') THEN

Line 2252: debug('arp_util.automatch_enabled: Exception');

2248: END IF;
2249: EXCEPTION
2250: WHEN OTHERS THEN
2251: IF PG_DEBUG in ('Y', 'C') THEN
2252: debug('arp_util.automatch_enabled: Exception');
2253: END IF;
2254: RETURN 'FALSE';
2255: END automatch_enabled;
2256: /* ER Automatch Cash Application END */

Line 2258: END arp_util;

2254: RETURN 'FALSE';
2255: END automatch_enabled;
2256: /* ER Automatch Cash Application END */
2257:
2258: END arp_util;