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_AUTO_ACCOUNTING dependencies on ARP_AUTO_ACCOUNTING

Line 1: PACKAGE BODY arp_auto_accounting AS

1: PACKAGE BODY arp_auto_accounting AS
2: /* $Header: ARTEAACB.pls 120.44.12010000.4 2008/11/19 13:24:18 pbapna ship $ */
3:
4: ------------------------------------------------------------------------
5: -- Inherited from other packages

Line 641: print_fcn_label( 'arp_auto_accounting.get_error_message_text()+' );

637: l_msg_name VARCHAR2(100);
638:
639: BEGIN
640:
641: print_fcn_label( 'arp_auto_accounting.get_error_message_text()+' );
642:
643: l_msg_name := '1360';
644: fnd_message.set_name('AR', l_msg_name);
645: MSG_COMPLETE_REV_ACCOUNT := fnd_message.get;

Line 706: print_fcn_label( 'arp_auto_accounting.get_error_message_text()-' );

702: MSG_LEVEL_DEBUG );
703: debug( ' MSG_FLEX_NO_PARENT_ALLOWED='||MSG_FLEX_NO_PARENT_ALLOWED,
704: MSG_LEVEL_DEBUG );
705:
706: print_fcn_label( 'arp_auto_accounting.get_error_message_text()-' );
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: debug('EXCEPTION: arp_auto_accounting.get_error_message_text()');

Line 710: debug('EXCEPTION: arp_auto_accounting.get_error_message_text()');

706: print_fcn_label( 'arp_auto_accounting.get_error_message_text()-' );
707:
708: EXCEPTION
709: WHEN OTHERS THEN
710: debug('EXCEPTION: arp_auto_accounting.get_error_message_text()');
711: RAISE;
712: END get_error_message_text;
713:
714: ----------------------------------------------------------------------------

Line 798: debug('EXCEPTION: arp_auto_accounting.dump_info()', MSG_LEVEL_BASIC);

794: debug( ' delim='||flex_info.delim, MSG_LEVEL_DEBUG);
795:
796: EXCEPTION
797: WHEN OTHERS THEN
798: debug('EXCEPTION: arp_auto_accounting.dump_info()', MSG_LEVEL_BASIC);
799: debug(SQLERRM, MSG_LEVEL_BASIC);
800: RAISE;
801: END dump_info;
802:

Line 824: print_fcn_label( 'arp_auto_accounting.dump_ccid_record()+' );

820: -- HISTORY:
821: --
822: PROCEDURE dump_ccid_record( p_ccid_record IN ccid_rec_type ) IS
823: BEGIN
824: print_fcn_label( 'arp_auto_accounting.dump_ccid_record()+' );
825:
826: debug( ' Dumping CCID record:', MSG_LEVEL_DEBUG );
827:
828: debug( ' trx_type_ccid_rev=' ||

Line 871: print_fcn_label( 'arp_auto_accounting.dump_ccid_record()-' );

867: to_char(p_ccid_record.agreecat_ccid_rev ), MSG_LEVEL_DEBUG );
868: debug( ' interim_tax_ccid=' ||
869: to_char(p_ccid_record.interim_tax_ccid ), MSG_LEVEL_DEBUG );
870:
871: print_fcn_label( 'arp_auto_accounting.dump_ccid_record()-' );
872:
873: END dump_ccid_record;
874:
875: ----------------------------------------------------------------------------

Line 945: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()+' );

941: p_cnt := p_cnt + 1;
942: END;
943:
944: BEGIN
945: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()+' );
946: --begin anuj
947: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
948: rev_count := 0;
949: rec_count := 0;

Line 991: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()-' );

987: load(l_suspense_index, suspense_count, autoacc_rec);
988: END IF;
989: END LOOP;
990:
991: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()-' );
992:
993: EXCEPTION
994: WHEN OTHERS THEN
995: debug('EXCEPTION: arp_auto_accounting.load_autoacc_def()',

Line 995: debug('EXCEPTION: arp_auto_accounting.load_autoacc_def()',

991: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()-' );
992:
993: EXCEPTION
994: WHEN OTHERS THEN
995: debug('EXCEPTION: arp_auto_accounting.load_autoacc_def()',
996: MSG_LEVEL_BASIC);
997: debug(SQLERRM, MSG_LEVEL_BASIC);
998: RAISE;
999: END load_autoacc_def ;

Line 1052: print_fcn_label( 'arp_auto_accounting.query_autoacc_def()+' );

1048: RETURN false;
1049: END;
1050:
1051: BEGIN
1052: print_fcn_label( 'arp_auto_accounting.query_autoacc_def()+' );
1053:
1054: g_error_buffer := NULL;
1055:
1056: --

Line 1092: print_fcn_label( 'arp_auto_accounting.query_autoacc_def()-' );

1088: RAISE invalid_account_class;
1089: END IF;
1090: END IF;
1091:
1092: print_fcn_label( 'arp_auto_accounting.query_autoacc_def()-' );
1093:
1094: RETURN retval;
1095:
1096:

Line 1099: debug('EXCEPTION: arp_auto_accounting.query_autoacc_def('

1095:
1096:
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: debug('EXCEPTION: arp_auto_accounting.query_autoacc_def('
1100: || p_account_class || ', '
1101: || p_table_name ||')', MSG_LEVEL_BASIC);
1102: debug(SQLERRM, MSG_LEVEL_BASIC);
1103: RAISE;

Line 1143: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()+' );

1139: p_ccid_unbill IN OUT NOCOPY BINARY_INTEGER,
1140: p_ccid_unearn IN OUT NOCOPY BINARY_INTEGER,
1141: p_ccid_suspense IN OUT NOCOPY BINARY_INTEGER) IS
1142: BEGIN
1143: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()+' );
1144:
1145: --
1146: -- initialize
1147: --

Line 1208: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()-' );

1204: trx_type_suspense_t( p_trx_type_id ) := p_ccid_suspense;
1205: END;
1206:
1207:
1208: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()-' );
1209:
1210: EXCEPTION
1211: WHEN NO_DATA_FOUND THEN
1212: debug('arp_auto_accounting.get_trx_type_ccids(): no data found',

Line 1212: debug('arp_auto_accounting.get_trx_type_ccids(): no data found',

1208: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()-' );
1209:
1210: EXCEPTION
1211: WHEN NO_DATA_FOUND THEN
1212: debug('arp_auto_accounting.get_trx_type_ccids(): no data found',
1213: MSG_LEVEL_DEBUG);
1214: WHEN OTHERS THEN
1215: debug('EXCEPTION: arp_auto_accounting.get_trx_type_ccids('
1216: || to_char(p_trx_type_id) ||')', MSG_LEVEL_BASIC);

Line 1215: debug('EXCEPTION: arp_auto_accounting.get_trx_type_ccids('

1211: WHEN NO_DATA_FOUND THEN
1212: debug('arp_auto_accounting.get_trx_type_ccids(): no data found',
1213: MSG_LEVEL_DEBUG);
1214: WHEN OTHERS THEN
1215: debug('EXCEPTION: arp_auto_accounting.get_trx_type_ccids('
1216: || to_char(p_trx_type_id) ||')', MSG_LEVEL_BASIC);
1217: debug(SQLERRM, MSG_LEVEL_BASIC);
1218: RAISE;
1219: END get_trx_type_ccids;

Line 1258: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()+' );

1254: p_ccid_unbill IN OUT NOCOPY BINARY_INTEGER,
1255: p_ccid_unearn IN OUT NOCOPY BINARY_INTEGER,
1256: p_ccid_suspense IN OUT NOCOPY BINARY_INTEGER) IS
1257: BEGIN
1258: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()+' );
1259:
1260: --
1261: -- initialize
1262: --

Line 1323: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()-' );

1319: site_use_suspense_t( p_site_use_id ) := p_ccid_suspense;
1320: END;
1321:
1322:
1323: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()-' );
1324:
1325: EXCEPTION
1326: WHEN NO_DATA_FOUND THEN
1327: debug('arp_auto_accounting.get_site_use_ccids(): no data found',

Line 1327: debug('arp_auto_accounting.get_site_use_ccids(): no data found',

1323: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()-' );
1324:
1325: EXCEPTION
1326: WHEN NO_DATA_FOUND THEN
1327: debug('arp_auto_accounting.get_site_use_ccids(): no data found',
1328: MSG_LEVEL_DEBUG);
1329: WHEN OTHERS THEN
1330: debug('EXCEPTION: arp_auto_accounting.get_site_use_ccids('
1331: || to_char(p_site_use_id) ||')', MSG_LEVEL_BASIC);

Line 1330: debug('EXCEPTION: arp_auto_accounting.get_site_use_ccids('

1326: WHEN NO_DATA_FOUND THEN
1327: debug('arp_auto_accounting.get_site_use_ccids(): no data found',
1328: MSG_LEVEL_DEBUG);
1329: WHEN OTHERS THEN
1330: debug('EXCEPTION: arp_auto_accounting.get_site_use_ccids('
1331: || to_char(p_site_use_id) ||')', MSG_LEVEL_BASIC);
1332: debug(SQLERRM, MSG_LEVEL_BASIC);
1333: RAISE;
1334: END get_site_use_ccids;

Line 1366: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()+' );

1362: p_ccid_rec IN OUT NOCOPY BINARY_INTEGER,
1363: p_ccid_frt IN OUT NOCOPY BINARY_INTEGER ) IS
1364: BEGIN
1365:
1366: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()+' );
1367:
1368: p_ccid_rev := -1;
1369: p_ccid_rec := -1;
1370: p_ccid_frt := -1;

Line 1404: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()-' );

1400: salesrep_frt_t( p_salesrep_id ) := p_ccid_frt;
1401:
1402: END;
1403:
1404: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()-' );
1405:
1406: EXCEPTION
1407: WHEN NO_DATA_FOUND THEN
1408: debug('arp_auto_accounting.get_salesrep_ccids(): no data found',

Line 1408: debug('arp_auto_accounting.get_salesrep_ccids(): no data found',

1404: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()-' );
1405:
1406: EXCEPTION
1407: WHEN NO_DATA_FOUND THEN
1408: debug('arp_auto_accounting.get_salesrep_ccids(): no data found',
1409: MSG_LEVEL_DEBUG);
1410: WHEN OTHERS THEN
1411: debug('EXCEPTION: arp_auto_accounting.get_salesrep_ccids('
1412: || to_char(p_salesrep_id) ||')', MSG_LEVEL_BASIC);

Line 1411: debug('EXCEPTION: arp_auto_accounting.get_salesrep_ccids('

1407: WHEN NO_DATA_FOUND THEN
1408: debug('arp_auto_accounting.get_salesrep_ccids(): no data found',
1409: MSG_LEVEL_DEBUG);
1410: WHEN OTHERS THEN
1411: debug('EXCEPTION: arp_auto_accounting.get_salesrep_ccids('
1412: || to_char(p_salesrep_id) ||')', MSG_LEVEL_BASIC);
1413: debug(SQLERRM, MSG_LEVEL_BASIC);
1414: RAISE;
1415: END get_salesrep_ccids;

Line 1454: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()+' );

1450: t_warehouse_id BINARY_INTEGER;
1451:
1452: BEGIN
1453:
1454: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()+' );
1455:
1456: p_ccid_rev := -1;
1457: p_inv_item_type := NULL;
1458: t_warehouse_id := nvl(p_warehouse_id,

Line 1530: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()-' );

1526: --debug('Sales Account: ' || p_ccid_rev);
1527:
1528: END;
1529:
1530: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()-' );
1531:
1532: EXCEPTION
1533: WHEN NO_DATA_FOUND THEN
1534: debug('arp_auto_accounting.get_inv_item_ccids(): no data found',

Line 1534: debug('arp_auto_accounting.get_inv_item_ccids(): no data found',

1530: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()-' );
1531:
1532: EXCEPTION
1533: WHEN NO_DATA_FOUND THEN
1534: debug('arp_auto_accounting.get_inv_item_ccids(): no data found',
1535: MSG_LEVEL_DEBUG);
1536: WHEN OTHERS THEN
1537: debug('EXCEPTION: arp_auto_accounting.get_inv_item_ccids('
1538: || to_char(p_inv_item_id) ||')', MSG_LEVEL_BASIC);

Line 1537: debug('EXCEPTION: arp_auto_accounting.get_inv_item_ccids('

1533: WHEN NO_DATA_FOUND THEN
1534: debug('arp_auto_accounting.get_inv_item_ccids(): no data found',
1535: MSG_LEVEL_DEBUG);
1536: WHEN OTHERS THEN
1537: debug('EXCEPTION: arp_auto_accounting.get_inv_item_ccids('
1538: || to_char(p_inv_item_id) ||')', MSG_LEVEL_BASIC);
1539: debug(SQLERRM, MSG_LEVEL_BASIC);
1540: RAISE;
1541: END get_inv_item_ccids;

Line 1569: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()+' );

1565: PROCEDURE get_memo_line_ccids( p_memo_line_id IN BINARY_INTEGER,
1566: p_ccid_rev IN OUT NOCOPY BINARY_INTEGER ) IS
1567: BEGIN
1568:
1569: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()+' );
1570:
1571: p_ccid_rev := -1;
1572:
1573: BEGIN

Line 1598: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()-' );

1594: memo_line_rev_t( p_memo_line_id ) := p_ccid_rev;
1595:
1596: END;
1597:
1598: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()-' );
1599:
1600: EXCEPTION
1601: WHEN NO_DATA_FOUND THEN
1602: debug('arp_auto_accounting.get_memo_line_ccids(): no data found',

Line 1602: debug('arp_auto_accounting.get_memo_line_ccids(): no data found',

1598: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()-' );
1599:
1600: EXCEPTION
1601: WHEN NO_DATA_FOUND THEN
1602: debug('arp_auto_accounting.get_memo_line_ccids(): no data found',
1603: MSG_LEVEL_DEBUG);
1604: WHEN OTHERS THEN
1605: debug('EXCEPTION: arp_auto_accounting.get_memo_line_ccids('
1606: || to_char(p_memo_line_id) ||')', MSG_LEVEL_BASIC);

Line 1605: debug('EXCEPTION: arp_auto_accounting.get_memo_line_ccids('

1601: WHEN NO_DATA_FOUND THEN
1602: debug('arp_auto_accounting.get_memo_line_ccids(): no data found',
1603: MSG_LEVEL_DEBUG);
1604: WHEN OTHERS THEN
1605: debug('EXCEPTION: arp_auto_accounting.get_memo_line_ccids('
1606: || to_char(p_memo_line_id) ||')', MSG_LEVEL_BASIC);
1607: debug(SQLERRM, MSG_LEVEL_BASIC);
1608: RAISE;
1609: END get_memo_line_ccids;

Line 1641: print_fcn_label2( 'arp_auto_accounting.get_agreecat_ccids()+' );

1637: p_warehouse_id IN BINARY_INTEGER, --Bug#1639334
1638: p_ccid_rev OUT NOCOPY BINARY_INTEGER ) IS
1639: BEGIN
1640:
1641: print_fcn_label2( 'arp_auto_accounting.get_agreecat_ccids()+' );
1642:
1643: p_ccid_rev := -1;
1644:
1645: SELECT nvl(c.code_combination_id,-1)

Line 1664: print_fcn_label2( 'arp_auto_accounting.get_agreecat_ccids()-' );

1660: AND i.category_set_id(+) = 1
1661: AND to_char(nvl(i.category_id, -1)) = c.value1
1662: AND nvl(a.agreement_type_code, -1) = nvl(c.value2 , -1);
1663:
1664: print_fcn_label2( 'arp_auto_accounting.get_agreecat_ccids()-' );
1665:
1666: EXCEPTION
1667: WHEN NO_DATA_FOUND THEN
1668: debug('arp_auto_accounting.get_agreecat_ccids(): no data found',

Line 1668: debug('arp_auto_accounting.get_agreecat_ccids(): no data found',

1664: print_fcn_label2( 'arp_auto_accounting.get_agreecat_ccids()-' );
1665:
1666: EXCEPTION
1667: WHEN NO_DATA_FOUND THEN
1668: debug('arp_auto_accounting.get_agreecat_ccids(): no data found',
1669: MSG_LEVEL_DEBUG);
1670: WHEN OTHERS THEN
1671: debug('EXCEPTION: arp_auto_accounting.get_agreecat_ccids('
1672: || to_char(p_line_id) ||')', MSG_LEVEL_BASIC);

Line 1671: debug('EXCEPTION: arp_auto_accounting.get_agreecat_ccids('

1667: WHEN NO_DATA_FOUND THEN
1668: debug('arp_auto_accounting.get_agreecat_ccids(): no data found',
1669: MSG_LEVEL_DEBUG);
1670: WHEN OTHERS THEN
1671: debug('EXCEPTION: arp_auto_accounting.get_agreecat_ccids('
1672: || to_char(p_line_id) ||')', MSG_LEVEL_BASIC);
1673: debug(SQLERRM, MSG_LEVEL_BASIC);
1674: RAISE;
1675: END get_agreecat_ccids;

Line 1695: print_fcn_label( 'arp_auto_accounting.get_combination_id()+' );

1691: BEGIN
1692:
1693: -- Initialize messages, debugging, and number of sql strings
1694: --
1695: print_fcn_label( 'arp_auto_accounting.get_combination_id()+' );
1696:
1697: r_value := FND_FLEX_KEYVAL.validate_segs('CREATE_COMBINATION',
1698: application_short_name, key_flex_code, structure_number,
1699: concat_segments, 'V',

Line 1703: print_fcn_label( 'arp_auto_accounting.get_combination_id()-' );

1699: concat_segments, 'V',
1700: validation_date);
1701: if( r_value ) then
1702: combination_id := FND_FLEX_KEYVAL.combination_id;
1703: print_fcn_label( 'arp_auto_accounting.get_combination_id()-' );
1704: return(r_value);
1705: end if;
1706:
1707: return(r_value);

Line 1733: print_fcn_label( 'arp_auto_accounting.get_combination_id1()+' );

1729: sepchar VARCHAR2(1);
1730: catsegs VARCHAR2(2000);
1731:
1732: BEGIN
1733: print_fcn_label( 'arp_auto_accounting.get_combination_id1()+' );
1734:
1735: -- Concatenate the input segments, then send them to the other function.
1736: --
1737: sepchar := fnd_flex_ext.get_delimiter(application_short_name, key_flex_code,

Line 1740: print_fcn_label( 'arp_auto_accounting.get_combination_id1()-' );

1736: --
1737: sepchar := fnd_flex_ext.get_delimiter(application_short_name, key_flex_code,
1738: structure_number);
1739: if(sepchar is not null) then
1740: print_fcn_label( 'arp_auto_accounting.get_combination_id1()-' );
1741: return(get_combination_id(application_short_name, key_flex_code,
1742: structure_number, validation_date,
1743: FND_FLEX_EXT.concatenate_segments(n_segments, segments, sepchar),
1744: combination_id));

Line 1760: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );

1756: ----------------------------------------------------------------------------
1757: PROCEDURE define_columns( p_select_c IN INTEGER,
1758: p_select_rec IN select_rec_type) IS
1759: BEGIN
1760: print_fcn_label2( 'arp_auto_accounting.define_columns()+' );
1761:
1762: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1763: dbms_sql.define_column( p_select_c, 2, p_select_rec.customer_trx_line_id );
1764: dbms_sql.define_column( p_select_c, 3,

Line 1794: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );

1790: dbms_sql.define_column( p_select_c, 23, p_select_rec.interim_tax_ccid );
1791: dbms_sql.define_column( p_select_c, 24, p_select_rec.site_use_id);
1792: dbms_sql.define_column( p_select_c, 25, p_select_rec.warehouse_id);
1793:
1794: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: debug('EXCEPTION: arp_auto_accounting.define_columns()',
1798: MSG_LEVEL_BASIC);

Line 1797: debug('EXCEPTION: arp_auto_accounting.define_columns()',

1793:
1794: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: debug('EXCEPTION: arp_auto_accounting.define_columns()',
1798: MSG_LEVEL_BASIC);
1799: debug(SQLERRM, MSG_LEVEL_BASIC);
1800: RAISE;
1801: END define_columns;

Line 1807: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );

1803:
1804: PROCEDURE define_arrays( p_select_c IN INTEGER,
1805: p_select_tab IN select_rec_tab) IS
1806: BEGIN
1807: print_fcn_label2( 'arp_auto_accounting.define_arrays()+' );
1808:
1809: dbms_sql.define_array( p_select_c, 1, p_select_tab.customer_trx_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1810: dbms_sql.define_array( p_select_c, 2, p_select_tab.customer_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1811: dbms_sql.define_array( p_select_c, 3,

Line 1843: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );

1839: dbms_sql.define_array( p_select_c, 25, p_select_tab.warehouse_id, MAX_ARRAY_SIZE, STARTING_INDEX);
1840: -- 1651593
1841: dbms_sql.define_array( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id, MAX_ARRAY_SIZE, STARTING_INDEX );
1842:
1843: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: debug('EXCEPTION: arp_auto_accounting.define_arrays()',
1847: MSG_LEVEL_BASIC);

Line 1846: debug('EXCEPTION: arp_auto_accounting.define_arrays()',

1842:
1843: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: debug('EXCEPTION: arp_auto_accounting.define_arrays()',
1847: MSG_LEVEL_BASIC);
1848: debug(SQLERRM, MSG_LEVEL_BASIC);
1849: RAISE;
1850: END define_arrays;

Line 1950: print_fcn_label( 'arp_auto_accounting.build_select_sql()+' );

1946: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
1947:
1948: BEGIN
1949:
1950: print_fcn_label( 'arp_auto_accounting.build_select_sql()+' );
1951:
1952: l_base_precision := ARP_GLOBAL.base_precision;
1953: l_base_min_acc_unit := nvl(ARP_GLOBAL.base_min_acc_unit,1);
1954:

Line 2712: print_fcn_label( 'arp_auto_accounting.build_select_sql()-' );

2708: debug( ' len(l_select_stmt)=' ||
2709: to_char(LENGTHB(l_select_stmt)), MSG_LEVEL_DEBUG );
2710:
2711:
2712: print_fcn_label( 'arp_auto_accounting.build_select_sql()-' );
2713: RETURN l_select_stmt;
2714:
2715:
2716:

Line 2719: debug('EXCEPTION: arp_auto_accounting.build_select_sql()',

2715:
2716:
2717: EXCEPTION
2718: WHEN OTHERS THEN
2719: debug('EXCEPTION: arp_auto_accounting.build_select_sql()',
2720: MSG_LEVEL_BASIC);
2721: debug(SQLERRM);
2722: RAISE;
2723: END build_select_sql;

Line 2792: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()+' );

2788: l_segment30 varchar2(30);
2789:
2790: BEGIN
2791:
2792: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()+' );
2793:
2794: SELECT segment1,
2795: segment2,
2796: segment3,

Line 2929: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()-' );

2925: segment29_cache(p_ccid) := l_segment29;
2926: segment30_cache(p_ccid) := l_segment30;
2927: END IF;
2928:
2929: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()-' );
2930:
2931: EXCEPTION
2932: WHEN OTHERS THEN
2933: debug( 'EXCEPTION: arp_auto_accounting.add_segments_to_cache()',

Line 2933: debug( 'EXCEPTION: arp_auto_accounting.add_segments_to_cache()',

2929: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()-' );
2930:
2931: EXCEPTION
2932: WHEN OTHERS THEN
2933: debug( 'EXCEPTION: arp_auto_accounting.add_segments_to_cache()',
2934: MSG_LEVEL_BASIC );
2935: debug(SQLERRM, MSG_LEVEL_BASIC);
2936: RAISE;
2937:

Line 2979: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()+' );

2975: l_desired_segment varchar2(30);
2976:
2977: BEGIN
2978:
2979: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()+' );
2980:
2981: BEGIN
2982:
2983: if (p_segment_number = 1)

Line 3062: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()-' );

3058: debug('getting segment ' || p_segment_number ||
3059: 'for ccid ' || p_ccid ||
3060: ' from gl_code_combinations', MSG_LEVEL_DEBUG);
3061:
3062: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()-' );
3063: RETURN(l_desired_segment);
3064:
3065: WHEN OTHERS THEN RAISE;
3066:

Line 3072: debug('arp_auto_accounting.get_segment_from_glcc(): no data found',

3068:
3069:
3070: EXCEPTION
3071: WHEN NO_DATA_FOUND THEN
3072: debug('arp_auto_accounting.get_segment_from_glcc(): no data found',
3073: MSG_LEVEL_DEBUG);
3074: RETURN NULL;
3075: WHEN OTHERS THEN
3076: /* debug('EXCEPTION: arp_auto_accounting.get_segment_from_glcc('

Line 3076: /* debug('EXCEPTION: arp_auto_accounting.get_segment_from_glcc('

3072: debug('arp_auto_accounting.get_segment_from_glcc(): no data found',
3073: MSG_LEVEL_DEBUG);
3074: RETURN NULL;
3075: WHEN OTHERS THEN
3076: /* debug('EXCEPTION: arp_auto_accounting.get_segment_from_glcc('
3077: || to_char(p_ccid) || ', '
3078: || to_char(p_segment_number) || ')', MSG_LEVEL_BASIC); */
3079: debug(SQLERRM, MSG_LEVEL_BASIC);
3080: RAISE;

Line 3140: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()+' );

3136: l_ccid BINARY_INTEGER;
3137:
3138: BEGIN
3139:
3140: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()+' );
3141:
3142: /*----------------------------------------------------------------+
3143: | Rewritten for bug 2142306 (23-Jan-02) - performance issues |
3144: | |

Line 3238: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );

3234: debug('found ccid ' || l_ccid || ' for concatenated segs: ' ||
3235: p_concat_segments || ' in the cache', MSG_LEVEL_DEBUG);
3236: IF VALID THEN
3237: p_result := TRUE;
3238: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3239: RETURN( l_ccid );
3240: ELSE
3241: debug(' ccid ' || l_ccid || ' not valid for date ' ||
3242: validation_date );

Line 3244: print_fcn_label2('arp_auto_accounting.get_ccid_from_cache()-');

3240: ELSE
3241: debug(' ccid ' || l_ccid || ' not valid for date ' ||
3242: validation_date );
3243: p_result := FALSE;
3244: print_fcn_label2('arp_auto_accounting.get_ccid_from_cache()-');
3245: RETURN(NULL);
3246: END IF;
3247: ELSE
3248: debug('Getting concatenated segs: ' ||

Line 3293: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );

3289: nvl(fnd_flex_keyval.end_date, g_max_date);
3290: END IF;
3291: END IF;
3292: p_result := TRUE;
3293: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3294: RETURN(l_ccid);
3295: ELSE
3296: p_result := FALSE;
3297: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );

Line 3297: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );

3293: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3294: RETURN(l_ccid);
3295: ELSE
3296: p_result := FALSE;
3297: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3298: RETURN(NULL);
3299: END IF;
3300: END IF;
3301: EXCEPTION

Line 3303: debug( 'EXCEPTION: arp_auto_accounting.get_ccid_from_cache_cache()',

3299: END IF;
3300: END IF;
3301: EXCEPTION
3302: WHEN OTHERS THEN
3303: debug( 'EXCEPTION: arp_auto_accounting.get_ccid_from_cache_cache()',
3304: MSG_LEVEL_BASIC );
3305: debug(SQLERRM, MSG_LEVEL_BASIC);
3306: RAISE;
3307: END;

Line 3355: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()+' );

3351: l_bool BOOLEAN;
3352:
3353: BEGIN
3354:
3355: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()+' );
3356:
3357: --
3358: -- part 1: call the ccid cache or the AOL api to validate and dynamically
3359: -- insert ccid

Line 3403: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );

3399: ------------------------------------------------------------------
3400: g_error_buffer := fnd_message.get;
3401: debug( g_error_buffer, MSG_LEVEL_BASIC );
3402:
3403: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3404: RETURN -1;
3405:
3406: END IF;
3407:

Line 3438: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );

3434: IF( l_detail_posting_flag = NO ) THEN
3435:
3436: g_error_buffer := MSG_FLEX_POSTING_NOT_ALLOWED;
3437: debug( MSG_FLEX_POSTING_NOT_ALLOWED, MSG_LEVEL_BASIC);
3438: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3439: RETURN -1;
3440:
3441: ELSIF( l_summary_flag = YES ) THEN
3442:

Line 3445: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );

3441: ELSIF( l_summary_flag = YES ) THEN
3442:
3443: g_error_buffer := MSG_FLEX_NO_PARENT_ALLOWED;
3444: debug( MSG_FLEX_NO_PARENT_ALLOWED, MSG_LEVEL_BASIC);
3445: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3446: RETURN -1;
3447:
3448: END IF;
3449:

Line 3450: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );

3446: RETURN -1;
3447:
3448: END IF;
3449:
3450: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3451: RETURN l_ccid;
3452:
3453: EXCEPTION
3454: WHEN NO_DATA_FOUND THEN

Line 3462: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );

3458: debug(SQLERRM, MSG_LEVEL_BASIC);
3459: RAISE;
3460: END;
3461:
3462: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3463:
3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: debug('EXCEPTION: arp_auto_accounting.search_glcc_for_ccid('

Line 3466: debug('EXCEPTION: arp_auto_accounting.search_glcc_for_ccid('

3462: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3463:
3464: EXCEPTION
3465: WHEN OTHERS THEN
3466: debug('EXCEPTION: arp_auto_accounting.search_glcc_for_ccid('
3467: || to_char(p_segment_cnt) ||')', MSG_LEVEL_BASIC);
3468: debug(SQLERRM, MSG_LEVEL_BASIC);
3469: RAISE;
3470: END search_glcc_for_ccid;

Line 3527: print_fcn_label2( 'arp_auto_accounting.Find_Cursor_In_Cache()+' );

3523:
3524: FUNCTION Find_Cursor_In_Cache ( p_key IN VARCHAR2 ) RETURN BINARY_INTEGER IS
3525: BEGIN
3526:
3527: print_fcn_label2( 'arp_auto_accounting.Find_Cursor_In_Cache()+' );
3528:
3529: FOR l_index IN 1..cursor_attr_cache.count LOOP
3530:
3531: IF ( cursor_attr_cache(l_index) = p_key )

Line 3534: 'arp_auto_accounting.Find_Cursor_In_Cache()-' );

3530:
3531: IF ( cursor_attr_cache(l_index) = p_key )
3532: THEN
3533: print_fcn_label2(
3534: 'arp_auto_accounting.Find_Cursor_In_Cache()-' );
3535: RETURN( l_index );
3536: END IF;
3537:
3538: END LOOP;

Line 3541: print_fcn_label2( 'arp_auto_accounting.Find_Cursor_In_Cache()-' );

3537:
3538: END LOOP;
3539:
3540:
3541: print_fcn_label2( 'arp_auto_accounting.Find_Cursor_In_Cache()-' );
3542:
3543: RETURN(NULL);
3544:
3545: EXCEPTION

Line 3547: debug('EXCEPTION: arp_auto_accounting.Find_Cursor_In_Cache()',

3543: RETURN(NULL);
3544:
3545: EXCEPTION
3546: WHEN OTHERS THEN
3547: debug('EXCEPTION: arp_auto_accounting.Find_Cursor_In_Cache()',
3548: MSG_LEVEL_BASIC);
3549: debug(SQLERRM, MSG_LEVEL_BASIC);
3550: RAISE;
3551: END;

Line 3633: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()+' );

3629: l_ignore INTEGER;
3630:
3631: BEGIN
3632:
3633: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()+' );
3634:
3635: p_keep_cursor_open_flag := TRUE;
3636:
3637: /*----------------------------------+

Line 3687: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()-' );

3683:
3684: IF ( l_cursor_index IS NOT NULL )
3685: THEN
3686:
3687: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()-' );
3688:
3689: l_cursor := cursor_cache( l_cursor_index );
3690:
3691: debug('Found cursor in cache: key ' || l_key ||

Line 3783: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()-' );

3779: RAISE;
3780:
3781: END;
3782:
3783: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()-' );
3784:
3785: RETURN( l_select_c );
3786:
3787:

Line 3791: debug('EXCEPTION: arp_auto_accounting.Get_Select_Cursor()',

3787:
3788: EXCEPTION
3789: WHEN OTHERS THEN
3790:
3791: debug('EXCEPTION: arp_auto_accounting.Get_Select_Cursor()',
3792: MSG_LEVEL_BASIC);
3793: debug(SQLERRM, MSG_LEVEL_BASIC);
3794: RAISE;
3795:

Line 3950: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()+' );

3946: ) IS
3947:
3948: BEGIN
3949:
3950: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()+' );
3951:
3952: BEGIN
3953: Bind_Variable(
3954: p_cursor,

Line 4068: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()-' );

4064: p_system_info.base_currency
4065: );
4066:
4067:
4068: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()-' );
4069:
4070: EXCEPTION
4071: WHEN OTHERS THEN
4072: debug('EXCEPTION: arp_auto_accounting.Bind_All_Variables()',

Line 4072: debug('EXCEPTION: arp_auto_accounting.Bind_All_Variables()',

4068: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()-' );
4069:
4070: EXCEPTION
4071: WHEN OTHERS THEN
4072: debug('EXCEPTION: arp_auto_accounting.Bind_All_Variables()',
4073: MSG_LEVEL_BASIC);
4074: debug(SQLERRM, MSG_LEVEL_BASIC);
4075: RAISE;
4076: END;

Line 4122: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()+' );

4118: mtl_system_items.item_type%TYPE ) IS
4119:
4120:
4121: BEGIN
4122: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()+' );
4123:
4124: --
4125: -- trx type
4126: --

Line 4195: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()-' );

4191: p_warehouse_id, --Bug#1639334
4192: p_ccid_record.agreecat_ccid_rev );
4193: END IF;
4194:
4195: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()-' );
4196:
4197: EXCEPTION
4198: WHEN OTHERS THEN
4199: debug('EXCEPTION: arp_auto_accounting.get_default_ccids('

Line 4199: debug('EXCEPTION: arp_auto_accounting.get_default_ccids('

4195: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()-' );
4196:
4197: EXCEPTION
4198: WHEN OTHERS THEN
4199: debug('EXCEPTION: arp_auto_accounting.get_default_ccids('
4200: || p_account_class || ', '
4201: || to_char(p_line_id) || ', '
4202: || to_char(p_trx_type_id) || ', '
4203: || to_char(p_salesrep_id) || ', '

Line 4271: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()+' );

4267: l_int_seg_table fnd_flex_ext.SegmentArray;
4268:
4269: BEGIN
4270:
4271: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()+' );
4272:
4273: -- get offset, count for account class (to access plsql tables)
4274: --
4275: IF( p_account_class in (REV, CHARGES) ) then

Line 4556: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()-' );

4552: -- return concat segs, and ccid for interim tax account
4553: p_int_concat_segments := l_int_concat_segments;
4554: END IF;
4555:
4556: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()-' );
4557:
4558: EXCEPTION
4559: WHEN OTHERS THEN
4560: debug('EXCEPTION: arp_auto_accounting.assemble_code_combination('

Line 4560: debug('EXCEPTION: arp_auto_accounting.assemble_code_combination('

4556: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()-' );
4557:
4558: EXCEPTION
4559: WHEN OTHERS THEN
4560: debug('EXCEPTION: arp_auto_accounting.assemble_code_combination('
4561: || p_account_class || ')', MSG_LEVEL_BASIC);
4562: debug(SQLERRM, MSG_LEVEL_BASIC);
4563: RAISE;
4564: END assemble_code_combination;

Line 4618: debug('EXCEPTION: arp_auto_accounting.flex_manager('

4614: l_inv_item_type mtl_system_items.item_type%TYPE;
4615:
4616: PROCEDURE print_params IS
4617: BEGIN
4618: debug('EXCEPTION: arp_auto_accounting.flex_manager('
4619: || p_account_class || ', '
4620: || to_char(p_line_id) || ', '
4621: || to_char(p_trx_type_id) || ', '
4622: || to_char(p_salesrep_id) || ', '

Line 4635: print_fcn_label( 'arp_auto_accounting.flex_manager()+' );

4631: END;
4632:
4633: BEGIN
4634:
4635: print_fcn_label( 'arp_auto_accounting.flex_manager()+' );
4636:
4637: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
4638: debug( ' line_id='||to_char(p_line_id), MSG_LEVEL_DEBUG );
4639: debug( ' trx_type_id='||to_char(p_trx_type_id), MSG_LEVEL_DEBUG );

Line 4728: print_fcn_label( 'arp_auto_accounting.flex_manager()-' );

4724:
4725: debug( ' interim_tax_ccid= '||to_char(p_int_ccid), MSG_LEVEL_DEBUG );
4726: debug( ' interim_tax_concat_segs= '||p_int_concat_segments, MSG_LEVEL_DEBUG );
4727:
4728: print_fcn_label( 'arp_auto_accounting.flex_manager()-' );
4729:
4730: EXCEPTION
4731: WHEN OTHERS THEN
4732: print_params;

Line 4785: print_fcn_label( 'arp_auto_accounting.build_delete_sql()+' );

4781: l_ctlid_pred VARCHAR2(500);
4782: l_ctlsid_pred VARCHAR2(500);
4783:
4784: BEGIN
4785: print_fcn_label( 'arp_auto_accounting.build_delete_sql()+' );
4786:
4787: --
4788: -- account_class
4789: --

Line 4874: print_fcn_label( 'arp_auto_accounting.build_delete_sql()-' );

4870: debug( l_delete_stmt, MSG_LEVEL_DEBUG );
4871: debug( ' len(l_delete_stmt)=' || to_char(LENGTHB(l_delete_stmt)),
4872: MSG_LEVEL_DEBUG );
4873:
4874: print_fcn_label( 'arp_auto_accounting.build_delete_sql()-' );
4875:
4876: RETURN l_delete_stmt;
4877:
4878:

Line 4881: debug('EXCEPTION: arp_auto_accounting.build_delete_sql()',

4877:
4878:
4879: EXCEPTION
4880: WHEN OTHERS THEN
4881: debug('EXCEPTION: arp_auto_accounting.build_delete_sql()',
4882: MSG_LEVEL_BASIC);
4883: debug(SQLERRM, MSG_LEVEL_BASIC);
4884: RAISE;
4885: END build_delete_sql;

Line 4892: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );

4888: ----------------------------------------------------------------------------
4889: PROCEDURE get_column_values( p_select_c IN INTEGER,
4890: p_select_rec OUT NOCOPY select_rec_type ) IS
4891: BEGIN
4892: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4893:
4894: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4895: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4896: dbms_sql.column_value( p_select_c, 3,

Line 4934: print_fcn_label2( 'arp_auto_accounting.get_column_values()-' );

4930: THEN
4931: p_select_rec.interim_tax_ccid := NULL;
4932: END IF;
4933:
4934: print_fcn_label2( 'arp_auto_accounting.get_column_values()-' );
4935: EXCEPTION
4936: WHEN OTHERS THEN
4937: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
4938: MSG_LEVEL_BASIC);

Line 4937: debug('EXCEPTION: arp_auto_accounting.get_column_values()',

4933:
4934: print_fcn_label2( 'arp_auto_accounting.get_column_values()-' );
4935: EXCEPTION
4936: WHEN OTHERS THEN
4937: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
4938: MSG_LEVEL_BASIC);
4939: debug(SQLERRM, MSG_LEVEL_BASIC);
4940: RAISE;
4941: END get_column_values;

Line 4947: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );

4943: ----------------------------------------------------------------------------
4944: PROCEDURE get_column_values( p_select_c IN INTEGER,
4945: p_select_tab OUT NOCOPY select_rec_tab ) IS
4946: BEGIN
4947: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
4948:
4949: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
4950: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
4951: dbms_sql.column_value( p_select_c, 3,

Line 4982: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );

4978: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
4979: -- 1651593
4980: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
4981:
4982: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
4983: EXCEPTION
4984: WHEN OTHERS THEN
4985: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
4986: MSG_LEVEL_BASIC);

Line 4985: debug('EXCEPTION: arp_auto_accounting.get_column_values()',

4981:
4982: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
4983: EXCEPTION
4984: WHEN OTHERS THEN
4985: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
4986: MSG_LEVEL_BASIC);
4987: debug(SQLERRM, MSG_LEVEL_BASIC);
4988: RAISE;
4989: END get_column_values;

Line 4998: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()+' );

4994: total_percent IN OUT NOCOPY NUMBER,
4995: total_amount IN OUT NOCOPY NUMBER,
4996: total_acctd_amount IN OUT NOCOPY NUMBER) IS
4997: BEGIN
4998: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()+' );
4999:
5000: -- update totals
5001:
5002: total_percent := total_percent + select_record.percent;

Line 5036: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()-' );

5032: total_acctd_amount := 0;
5033:
5034: END IF;
5035:
5036: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()-' );
5037:
5038: EXCEPTION
5039: WHEN OTHERS THEN
5040: debug('EXCEPTION: arp_auto_accounting.correct_rounding_errors()',

Line 5040: debug('EXCEPTION: arp_auto_accounting.correct_rounding_errors()',

5036: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()-' );
5037:
5038: EXCEPTION
5039: WHEN OTHERS THEN
5040: debug('EXCEPTION: arp_auto_accounting.correct_rounding_errors()',
5041: MSG_LEVEL_BASIC);
5042: debug(SQLERRM, MSG_LEVEL_BASIC);
5043: RAISE;
5044: END correct_rounding_errors;

Line 5064: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()+' );

5060: inext NUMBER := 0;
5061: inow NUMBER := 0;
5062:
5063: BEGIN
5064: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()+' );
5065:
5066: /* Bug 2560036 - modified insert to set rec_offset_flag in
5067: support of directly inserted UNEARN rows for RAM-C */
5068:

Line 5186: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()-' );

5182: END IF;
5183: END LOOP;
5184: END IF;
5185:
5186: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()-' );
5187: EXCEPTION
5188: WHEN OTHERS THEN
5189: debug('EXCEPTION: arp_auto_accounting.insert_dist_row()',
5190: MSG_LEVEL_BASIC);

Line 5189: debug('EXCEPTION: arp_auto_accounting.insert_dist_row()',

5185:
5186: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()-' );
5187: EXCEPTION
5188: WHEN OTHERS THEN
5189: debug('EXCEPTION: arp_auto_accounting.insert_dist_row()',
5190: MSG_LEVEL_BASIC);
5191: debug(SQLERRM, MSG_LEVEL_BASIC);
5192: RAISE;
5193: END insert_dist_row;

Line 5198: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()+' );

5194:
5195: ----------------------------------------------------------------------------
5196: PROCEDURE dump_select_rec( p_select_rec IN select_rec_type ) IS
5197: BEGIN
5198: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()+' );
5199:
5200: debug( ' Dumping select record: ', MSG_LEVEL_DEBUG );
5201: debug( ' customer_trx_id='
5202: || to_char( p_select_rec.customer_trx_id ), MSG_LEVEL_DEBUG );

Line 5250: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()-' );

5246: || to_char( p_select_rec.site_use_id ), MSG_LEVEL_DEBUG );
5247: debug( ' warehouse_id='
5248: || to_char( p_select_rec.warehouse_id ), MSG_LEVEL_DEBUG );
5249:
5250: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()-' );
5251:
5252: EXCEPTION
5253: WHEN OTHERS THEN
5254: debug('EXCEPTION: arp_auto_accounting.dump_select_rec()',

Line 5254: debug('EXCEPTION: arp_auto_accounting.dump_select_rec()',

5250: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()-' );
5251:
5252: EXCEPTION
5253: WHEN OTHERS THEN
5254: debug('EXCEPTION: arp_auto_accounting.dump_select_rec()',
5255: MSG_LEVEL_BASIC);
5256: debug(SQLERRM, MSG_LEVEL_BASIC);
5257: END dump_select_rec;
5258:

Line 5262: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()+' );

5258:
5259: ----------------------------------------------------------------------------
5260: PROCEDURE dump_select_tab( p_select_tab IN select_rec_tab, p_low IN NUMBER, p_high IN NUMBER ) IS
5261: BEGIN
5262: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()+' );
5263:
5264: /* bug 1532372 - changed parameter from l_rows_fetched to l_low and l_high
5265: this apparently corrects the 1000 REC row limit that
5266: we encountered during benchmarking. */

Line 5320: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()-' );

5316: debug( ' warehouse_id='
5317: || to_char( p_select_tab.warehouse_id (i)), MSG_LEVEL_DEBUG );
5318: END LOOP;
5319:
5320: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()-' );
5321:
5322: EXCEPTION
5323: WHEN OTHERS THEN
5324: debug('EXCEPTION: arp_auto_accounting.dump_select_tab()',

Line 5324: debug('EXCEPTION: arp_auto_accounting.dump_select_tab()',

5320: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()-' );
5321:
5322: EXCEPTION
5323: WHEN OTHERS THEN
5324: debug('EXCEPTION: arp_auto_accounting.dump_select_tab()',
5325: MSG_LEVEL_BASIC);
5326: debug(SQLERRM, MSG_LEVEL_BASIC);
5327: END dump_select_tab;
5328: ----------------------------------------------------------------------------

Line 5338: print_fcn_label2( 'arp_auto_accounting.get_select_rec(tab)+' );

5334: i INTEGER:=0;
5335:
5336: BEGIN
5337:
5338: print_fcn_label2( 'arp_auto_accounting.get_select_rec(tab)+' );
5339: debug( ' p_cnt='
5340: || p_cnt, MSG_LEVEL_DEBUG );
5341: i := 1;
5342: p_select_rec.customer_trx_id := p_select_tab.customer_trx_id(p_cnt);

Line 5412: debug('EXCEPTION: arp_auto_accounting.get_select_rec():'|| i, MSG_LEVEL_BASIC);

5408: return(p_select_rec);
5409:
5410: EXCEPTION
5411: WHEN OTHERS THEN
5412: debug('EXCEPTION: arp_auto_accounting.get_select_rec():'|| i, MSG_LEVEL_BASIC);
5413: debug(SQLERRM, MSG_LEVEL_BASIC);
5414: RAISE;
5415:
5416: END;

Line 5659: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()+ ' );

5655: --------------------------------------------------------------------------
5656: system_info.msg_level := p_msg_level;
5657: arp_global.msg_level := p_msg_level;
5658:
5659: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()+ ' );
5660:
5661: --------------------------------------------------------------------------
5662: -- Initialize
5663: --------------------------------------------------------------------------

Line 5686: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()- ' );

5682: p_concat_segments,
5683: p_num_failed_dist_rows );
5684:
5685:
5686: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()- ' );
5687:
5688: IF (( p_mode = G AND p_ccid = -1 )
5689: OR
5690: ( p_request_id IS NOT NULL AND p_num_failed_dist_rows > 0)) THEN

Line 5769: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()+' );

5765: gl_dist_array dbms_sql.number_table; /* MRC */
5766: l_error_count NUMBER := 0;
5767: BEGIN
5768:
5769: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()+' );
5770: --begin anuj
5771: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
5772: init;
5773: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/

Line 6002: IF arp_auto_accounting.g_deposit_flag = 'Y' and

5998: IF p_passed_ccid IS NOT NULL AND
5999: p_account_class in('REC','FREIGHT') THEN
6000: p_ccid := p_passed_ccid;
6001: END IF;
6002: IF arp_auto_accounting.g_deposit_flag = 'Y' and
6003: p_account_class = 'REV' THEN
6004: p_ccid := p_passed_ccid;
6005: END IF;
6006:

Line 6319: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()-' );

6315:
6316: close_cursor( l_delete_c );
6317:
6318:
6319: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()-' );
6320:
6321:
6322: EXCEPTION
6323: WHEN NO_DATA_FOUND THEN

Line 6340: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting_internal()',

6336: RAISE;
6337: END IF;
6338:
6339: WHEN OTHERS THEN
6340: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting_internal()',
6341: MSG_LEVEL_BASIC );
6342: debug(SQLERRM, MSG_LEVEL_BASIC);
6343:
6344: close_cursor( l_select_c );

Line 6387: -- arp_auto_accounting.no_ccid if autoaccounting could not derive a

6383: -- OUT:
6384: --
6385: -- NOTES:
6386: -- If mode is not (G)et, raises the exception
6387: -- arp_auto_accounting.no_ccid if autoaccounting could not derive a
6388: -- valid code combination. The public variable g_error_buffer is
6389: -- populated for more information. In (G)et mode, check the value
6390: -- assigned to p_ccid. If it is -1, then no ccid was found.
6391: --

Line 6434: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()+' );

6430: l_account_class VARCHAR2(20);
6431:
6432: BEGIN
6433:
6434: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()+' );
6435:
6436: /*
6437: ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()+',
6438: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);

Line 6437: ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()+',

6433:
6434: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()+' );
6435:
6436: /*
6437: ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()+',
6438: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
6439: */
6440: g_error_buffer := NULL;
6441:

Line 6816: /*ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()-',

6812: RAISE no_ccid;
6813:
6814: END IF;
6815:
6816: /*ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()-',
6817: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
6818: */
6819: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()-' );
6820:

Line 6819: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()-' );

6815:
6816: /*ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()-',
6817: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
6818: */
6819: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()-' );
6820:
6821:
6822: EXCEPTION
6823: WHEN no_ccid OR NO_DATA_FOUND THEN

Line 6837: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting()',

6833: RAISE;
6834: END IF;
6835:
6836: WHEN OTHERS THEN
6837: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting()',
6838: MSG_LEVEL_BASIC );
6839: debug(SQLERRM, MSG_LEVEL_BASIC);
6840:
6841: IF( sqlcode = 1 ) THEN

Line 6900: -- arp_auto_accounting.no_ccid if autoaccounting could not derive a

6896: -- OUT:
6897: --
6898: -- NOTES:
6899: -- If mode is not (G)et, raises the exception
6900: -- arp_auto_accounting.no_ccid if autoaccounting could not derive a
6901: -- valid code combination. The public variable g_error_buffer is
6902: -- populated for more information. In (G)et mode, check the value
6903: -- assigned to p_ccid. If it is -1, then no ccid was found.
6904: --

Line 6945: print_fcn_label( 'arp_auto_accounting.do_autoaccounting overloaded get mode()+' );

6941: l_bill_to_site_use_id BINARY_INTEGER;
6942:
6943: BEGIN
6944:
6945: print_fcn_label( 'arp_auto_accounting.do_autoaccounting overloaded get mode()+' );
6946:
6947: g_error_buffer := NULL;
6948:
6949: l_bill_to_site_use_id := '';

Line 7037: print_fcn_label( 'arp_auto_accounting.do_autoaccounting() overloaded get mode -' );

7033: RAISE no_ccid;
7034:
7035: END IF;
7036:
7037: print_fcn_label( 'arp_auto_accounting.do_autoaccounting() overloaded get mode -' );
7038:
7039:
7040: EXCEPTION
7041: WHEN no_ccid OR NO_DATA_FOUND THEN

Line 7055: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting()',

7051: RAISE;
7052: END IF;
7053:
7054: WHEN OTHERS THEN
7055: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting()',
7056: MSG_LEVEL_BASIC );
7057: debug(SQLERRM, MSG_LEVEL_BASIC);
7058:
7059: IF( sqlcode = 1 ) THEN

Line 7152: debug('arp_auto_accounting.test_load()');

7148:
7149: EXCEPTION
7150: WHEN OTHERS THEN
7151: debug(SQLERRM);
7152: debug('arp_auto_accounting.test_load()');
7153: RAISE;
7154: END test_load;
7155:
7156: ----------------------------------------------------------------------------

Line 7169: debug('arp_auto_accounting.test_query()');

7165: END IF;
7166:
7167: EXCEPTION
7168: WHEN OTHERS THEN
7169: debug('arp_auto_accounting.test_query()');
7170: debug(SQLERRM);
7171: RAISE;
7172: END test_query;
7173:

Line 7232: debug('arp_auto_accounting.test_find()');

7228: end if;
7229:
7230: EXCEPTION
7231: WHEN OTHERS THEN
7232: debug('arp_auto_accounting.test_find()');
7233: debug(SQLERRM);
7234: RAISE;
7235: END test_find;
7236:

Line 7282: debug('arp_auto_accounting.test_assembly()');

7278: debug(to_char(l_int_ccid));
7279:
7280: EXCEPTION
7281: WHEN OTHERS THEN
7282: debug('arp_auto_accounting.test_assembly()');
7283: debug(SQLERRM);
7284: RAISE;
7285: END test_assembly;
7286:

Line 7619: debug('arp_auto_accounting.test_harness()');

7615: END;
7616:
7617: EXCEPTION
7618: WHEN OTHERS THEN
7619: debug('arp_auto_accounting.test_harness()');
7620: debug(SQLERRM);
7621: RAISE;
7622: END test_harness;
7623:

Line 7656: debug('arp_auto_accounting.test_harness()');

7652:
7653:
7654: EXCEPTION
7655: WHEN OTHERS THEN
7656: debug('arp_auto_accounting.test_harness()');
7657: debug(SQLERRM);
7658: RAISE;
7659: END test_wes ;
7660:

Line 7682: debug('EXCEPTION: arp_auto_accounting.test_build_sql()');

7678: disable_debug;
7679:
7680: EXCEPTION
7681: WHEN OTHERS THEN
7682: debug('EXCEPTION: arp_auto_accounting.test_build_sql()');
7683: debug(SQLERRM);
7684: RAISE;
7685: END test_build_sql;
7686:

Line 7729: debug('EXCEPTION: arp_auto_accounting.test_do_autoacc()');

7725: disable_debug;
7726:
7727: EXCEPTION
7728: WHEN OTHERS THEN
7729: debug('EXCEPTION: arp_auto_accounting.test_do_autoacc()');
7730: debug(SQLERRM);
7731: RAISE;
7732: END test_do_autoacc;
7733:

Line 7744: print_fcn_label( 'arp_auto_accounting.constructor()+' );

7740: --begin anuj
7741: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
7742: PROCEDURE init is
7743: BEGIN
7744: print_fcn_label( 'arp_auto_accounting.constructor()+' );
7745:
7746: ------------------------------------------------------------------------
7747: -- Load autoaccounting definition into plsql tables
7748: ------------------------------------------------------------------------

Line 7788: print_fcn_label( 'arp_auto_accounting.constructor()-' );

7784: get_error_message_text;
7785:
7786: dump_info;
7787:
7788: print_fcn_label( 'arp_auto_accounting.constructor()-' );
7789:
7790: EXCEPTION
7791: WHEN OTHERS THEN
7792: debug('EXCEPTION: arp_auto_accounting.constructor');

Line 7792: debug('EXCEPTION: arp_auto_accounting.constructor');

7788: print_fcn_label( 'arp_auto_accounting.constructor()-' );
7789:
7790: EXCEPTION
7791: WHEN OTHERS THEN
7792: debug('EXCEPTION: arp_auto_accounting.constructor');
7793: debug(SQLERRM);
7794: RAISE;
7795: END init;
7796: BEGIN

Line 7801: END arp_auto_accounting;

7797: init;
7798: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
7799: --end anuj
7800:
7801: END arp_auto_accounting;