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.60.12020000.6 2013/04/10 11:59:08 dgaurab 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 802: debug('EXCEPTION: arp_auto_accounting.dump_info()', MSG_LEVEL_BASIC);

798: debug( ' delim='||flex_info.delim, MSG_LEVEL_DEBUG);
799:
800: EXCEPTION
801: WHEN OTHERS THEN
802: debug('EXCEPTION: arp_auto_accounting.dump_info()', MSG_LEVEL_BASIC);
803: debug(SQLERRM, MSG_LEVEL_BASIC);
804: RAISE;
805: END dump_info;
806:

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

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

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

871: to_char(p_ccid_record.agreecat_ccid_rev ), MSG_LEVEL_DEBUG );
872: debug( ' interim_tax_ccid=' ||
873: to_char(p_ccid_record.interim_tax_ccid ), MSG_LEVEL_DEBUG );
874:
875: print_fcn_label( 'arp_auto_accounting.dump_ccid_record()-' );
876:
877: END dump_ccid_record;
878:
879: ----------------------------------------------------------------------------

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

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

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

991: load(l_suspense_index, suspense_count, autoacc_rec);
992: END IF;
993: END LOOP;
994:
995: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()-' );
996:
997: EXCEPTION
998: WHEN OTHERS THEN
999: debug('EXCEPTION: arp_auto_accounting.load_autoacc_def()',

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

995: print_fcn_label( 'arp_auto_accounting.load_autoacc_def()-' );
996:
997: EXCEPTION
998: WHEN OTHERS THEN
999: debug('EXCEPTION: arp_auto_accounting.load_autoacc_def()',
1000: MSG_LEVEL_BASIC);
1001: debug(SQLERRM, MSG_LEVEL_BASIC);
1002: RAISE;
1003: END load_autoacc_def ;

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

1052: RETURN false;
1053: END;
1054:
1055: BEGIN
1056: print_fcn_label( 'arp_auto_accounting.query_autoacc_def()+' );
1057:
1058: g_error_buffer := NULL;
1059:
1060: --

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

1092: RAISE invalid_account_class;
1093: END IF;
1094: END IF;
1095:
1096: print_fcn_label( 'arp_auto_accounting.query_autoacc_def()-' );
1097:
1098: RETURN retval;
1099:
1100:

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

1099:
1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: debug('EXCEPTION: arp_auto_accounting.query_autoacc_def('
1104: || p_account_class || ', '
1105: || p_table_name ||')', MSG_LEVEL_BASIC);
1106: debug(SQLERRM, MSG_LEVEL_BASIC);
1107: RAISE;

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

1143: p_ccid_unbill IN OUT NOCOPY BINARY_INTEGER,
1144: p_ccid_unearn IN OUT NOCOPY BINARY_INTEGER,
1145: p_ccid_suspense IN OUT NOCOPY BINARY_INTEGER) IS
1146: BEGIN
1147: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()+' );
1148:
1149: --
1150: -- initialize
1151: --

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

1208: trx_type_suspense_t( p_trx_type_id ) := p_ccid_suspense;
1209: END;
1210:
1211:
1212: print_fcn_label2( 'arp_auto_accounting.get_trx_type_ccids()-' );
1213:
1214: EXCEPTION
1215: WHEN NO_DATA_FOUND THEN
1216: debug('arp_auto_accounting.get_trx_type_ccids(): no data found',

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

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

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

1215: WHEN NO_DATA_FOUND THEN
1216: debug('arp_auto_accounting.get_trx_type_ccids(): no data found',
1217: MSG_LEVEL_DEBUG);
1218: WHEN OTHERS THEN
1219: debug('EXCEPTION: arp_auto_accounting.get_trx_type_ccids('
1220: || to_char(p_trx_type_id) ||')', MSG_LEVEL_BASIC);
1221: debug(SQLERRM, MSG_LEVEL_BASIC);
1222: RAISE;
1223: END get_trx_type_ccids;

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

1258: p_ccid_unbill IN OUT NOCOPY BINARY_INTEGER,
1259: p_ccid_unearn IN OUT NOCOPY BINARY_INTEGER,
1260: p_ccid_suspense IN OUT NOCOPY BINARY_INTEGER) IS
1261: BEGIN
1262: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()+' );
1263:
1264: --
1265: -- initialize
1266: --

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

1323: site_use_suspense_t( p_site_use_id ) := p_ccid_suspense;
1324: END;
1325:
1326:
1327: print_fcn_label2( 'arp_auto_accounting.get_site_use_ccids()-' );
1328:
1329: EXCEPTION
1330: WHEN NO_DATA_FOUND THEN
1331: debug('arp_auto_accounting.get_site_use_ccids(): no data found',

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

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

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

1330: WHEN NO_DATA_FOUND THEN
1331: debug('arp_auto_accounting.get_site_use_ccids(): no data found',
1332: MSG_LEVEL_DEBUG);
1333: WHEN OTHERS THEN
1334: debug('EXCEPTION: arp_auto_accounting.get_site_use_ccids('
1335: || to_char(p_site_use_id) ||')', MSG_LEVEL_BASIC);
1336: debug(SQLERRM, MSG_LEVEL_BASIC);
1337: RAISE;
1338: END get_site_use_ccids;

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

1366: p_ccid_rec IN OUT NOCOPY BINARY_INTEGER,
1367: p_ccid_frt IN OUT NOCOPY BINARY_INTEGER ) IS
1368: BEGIN
1369:
1370: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()+' );
1371:
1372: p_ccid_rev := -1;
1373: p_ccid_rec := -1;
1374: p_ccid_frt := -1;

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

1404: salesrep_frt_t( p_salesrep_id ) := p_ccid_frt;
1405:
1406: END;
1407:
1408: print_fcn_label2( 'arp_auto_accounting.get_salesrep_ccids()-' );
1409:
1410: EXCEPTION
1411: WHEN NO_DATA_FOUND THEN
1412: debug('arp_auto_accounting.get_salesrep_ccids(): no data found',

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

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

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

1411: WHEN NO_DATA_FOUND THEN
1412: debug('arp_auto_accounting.get_salesrep_ccids(): no data found',
1413: MSG_LEVEL_DEBUG);
1414: WHEN OTHERS THEN
1415: debug('EXCEPTION: arp_auto_accounting.get_salesrep_ccids('
1416: || to_char(p_salesrep_id) ||')', MSG_LEVEL_BASIC);
1417: debug(SQLERRM, MSG_LEVEL_BASIC);
1418: RAISE;
1419: END get_salesrep_ccids;

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

1454: t_warehouse_id BINARY_INTEGER;
1455:
1456: BEGIN
1457:
1458: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()+' );
1459:
1460: p_ccid_rev := -1;
1461: p_inv_item_type := NULL;
1462: t_warehouse_id := nvl(p_warehouse_id,

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

1530: --debug('Sales Account: ' || p_ccid_rev);
1531:
1532: END;
1533:
1534: print_fcn_label2( 'arp_auto_accounting.get_inv_item_ccids()-' );
1535:
1536: EXCEPTION
1537: WHEN NO_DATA_FOUND THEN
1538: debug('arp_auto_accounting.get_inv_item_ccids(): no data found',

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

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

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

1537: WHEN NO_DATA_FOUND THEN
1538: debug('arp_auto_accounting.get_inv_item_ccids(): no data found',
1539: MSG_LEVEL_DEBUG);
1540: WHEN OTHERS THEN
1541: debug('EXCEPTION: arp_auto_accounting.get_inv_item_ccids('
1542: || to_char(p_inv_item_id) ||')', MSG_LEVEL_BASIC);
1543: debug(SQLERRM, MSG_LEVEL_BASIC);
1544: RAISE;
1545: END get_inv_item_ccids;

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

1569: PROCEDURE get_memo_line_ccids( p_memo_line_id IN BINARY_INTEGER,
1570: p_ccid_rev IN OUT NOCOPY BINARY_INTEGER ) IS
1571: BEGIN
1572:
1573: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()+' );
1574:
1575: p_ccid_rev := -1;
1576:
1577: BEGIN

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

1598: memo_line_rev_t( p_memo_line_id ) := p_ccid_rev;
1599:
1600: END;
1601:
1602: print_fcn_label2( 'arp_auto_accounting.get_memo_line_ccids()-' );
1603:
1604: EXCEPTION
1605: WHEN NO_DATA_FOUND THEN
1606: debug('arp_auto_accounting.get_memo_line_ccids(): no data found',

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

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

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

1605: WHEN NO_DATA_FOUND THEN
1606: debug('arp_auto_accounting.get_memo_line_ccids(): no data found',
1607: MSG_LEVEL_DEBUG);
1608: WHEN OTHERS THEN
1609: debug('EXCEPTION: arp_auto_accounting.get_memo_line_ccids('
1610: || to_char(p_memo_line_id) ||')', MSG_LEVEL_BASIC);
1611: debug(SQLERRM, MSG_LEVEL_BASIC);
1612: RAISE;
1613: END get_memo_line_ccids;

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

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

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

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

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

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

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

1671: WHEN NO_DATA_FOUND THEN
1672: debug('arp_auto_accounting.get_agreecat_ccids(): no data found',
1673: MSG_LEVEL_DEBUG);
1674: WHEN OTHERS THEN
1675: debug('EXCEPTION: arp_auto_accounting.get_agreecat_ccids('
1676: || to_char(p_line_id) ||')', MSG_LEVEL_BASIC);
1677: debug(SQLERRM, MSG_LEVEL_BASIC);
1678: RAISE;
1679: END get_agreecat_ccids;

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

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

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

1703: concat_segments, 'V',
1704: validation_date);
1705: if( r_value ) then
1706: combination_id := FND_FLEX_KEYVAL.combination_id;
1707: print_fcn_label( 'arp_auto_accounting.get_combination_id()-' );
1708: return(r_value);
1709: end if;
1710:
1711: return(r_value);

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

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

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

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

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

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

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

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

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

1797:
1798: print_fcn_label2( 'arp_auto_accounting.define_columns()-' );
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: debug('EXCEPTION: arp_auto_accounting.define_columns()',
1802: MSG_LEVEL_BASIC);
1803: debug(SQLERRM, MSG_LEVEL_BASIC);
1804: RAISE;
1805: END define_columns;

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

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

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

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

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

1846:
1847: print_fcn_label2( 'arp_auto_accounting.define_arrays()-' );
1848: EXCEPTION
1849: WHEN OTHERS THEN
1850: debug('EXCEPTION: arp_auto_accounting.define_arrays()',
1851: MSG_LEVEL_BASIC);
1852: debug(SQLERRM, MSG_LEVEL_BASIC);
1853: RAISE;
1854: END define_arrays;

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

1951: l_base_min_acc_unit VARCHAR2(20);
1952:
1953: BEGIN
1954:
1955: print_fcn_label( 'arp_auto_accounting.build_select_sql()+' );
1956:
1957: l_base_precision := ARP_GLOBAL.base_precision;
1958:
1959: /* 9222866 - this variable used as a literal in dynamic sql.

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

2725: debug( l_select_stmt, MSG_LEVEL_DEBUG );
2726: debug( ' len(l_select_stmt)=' ||
2727: to_char(LENGTHB(l_select_stmt)), MSG_LEVEL_DEBUG );
2728:
2729: print_fcn_label( 'arp_auto_accounting.build_select_sql()-' );
2730: RETURN l_select_stmt;
2731:
2732:
2733:

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

2732:
2733:
2734: EXCEPTION
2735: WHEN OTHERS THEN
2736: debug('EXCEPTION: arp_auto_accounting.build_select_sql()',
2737: MSG_LEVEL_BASIC);
2738: debug(SQLERRM);
2739: RAISE;
2740: END build_select_sql;

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

2805: l_segment30 varchar2(30);
2806:
2807: BEGIN
2808:
2809: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()+' );
2810:
2811: SELECT segment1,
2812: segment2,
2813: segment3,

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

2942: segment29_cache(p_ccid) := l_segment29;
2943: segment30_cache(p_ccid) := l_segment30;
2944: END IF;
2945:
2946: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()-' );
2947:
2948: EXCEPTION
2949: WHEN OTHERS THEN
2950: debug( 'EXCEPTION: arp_auto_accounting.add_segments_to_cache()',

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

2946: print_fcn_label2( 'arp_auto_accounting.add_segments_to_cache()-' );
2947:
2948: EXCEPTION
2949: WHEN OTHERS THEN
2950: debug( 'EXCEPTION: arp_auto_accounting.add_segments_to_cache()',
2951: MSG_LEVEL_BASIC );
2952: debug(SQLERRM, MSG_LEVEL_BASIC);
2953: RAISE;
2954:

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

2992: l_desired_segment varchar2(30);
2993:
2994: BEGIN
2995:
2996: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()+' );
2997:
2998: BEGIN
2999:
3000: if (p_segment_number = 1)

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

3075: debug('getting segment ' || p_segment_number ||
3076: 'for ccid ' || p_ccid ||
3077: ' from gl_code_combinations', MSG_LEVEL_DEBUG);
3078:
3079: print_fcn_label2( 'arp_auto_accounting.get_segment_from_glcc()-' );
3080: RETURN(l_desired_segment);
3081:
3082: WHEN OTHERS THEN RAISE;
3083:

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

3085:
3086:
3087: EXCEPTION
3088: WHEN NO_DATA_FOUND THEN
3089: debug('arp_auto_accounting.get_segment_from_glcc(): no data found',
3090: MSG_LEVEL_DEBUG);
3091: RETURN NULL;
3092: WHEN OTHERS THEN
3093: /* debug('EXCEPTION: arp_auto_accounting.get_segment_from_glcc('

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

3089: debug('arp_auto_accounting.get_segment_from_glcc(): no data found',
3090: MSG_LEVEL_DEBUG);
3091: RETURN NULL;
3092: WHEN OTHERS THEN
3093: /* debug('EXCEPTION: arp_auto_accounting.get_segment_from_glcc('
3094: || to_char(p_ccid) || ', '
3095: || to_char(p_segment_number) || ')', MSG_LEVEL_BASIC); */
3096: debug(SQLERRM, MSG_LEVEL_BASIC);
3097: RAISE;

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

3153: l_ccid BINARY_INTEGER;
3154:
3155: BEGIN
3156:
3157: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()+' );
3158:
3159: /*----------------------------------------------------------------+
3160: | Rewritten for bug 2142306 (23-Jan-02) - performance issues |
3161: | |

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

3251: debug('found ccid ' || l_ccid || ' for concatenated segs: ' ||
3252: p_concat_segments || ' in the cache', MSG_LEVEL_DEBUG);
3253: IF VALID THEN
3254: p_result := TRUE;
3255: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3256: RETURN( l_ccid );
3257: ELSE
3258: debug(' ccid ' || l_ccid || ' not valid for date ' ||
3259: validation_date );

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

3257: ELSE
3258: debug(' ccid ' || l_ccid || ' not valid for date ' ||
3259: validation_date );
3260: p_result := FALSE;
3261: print_fcn_label2('arp_auto_accounting.get_ccid_from_cache()-');
3262: RETURN(NULL);
3263: END IF;
3264: ELSE
3265: debug('Getting concatenated segs: ' ||

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

3306: nvl(fnd_flex_keyval.end_date, g_max_date);
3307: END IF;
3308: END IF;
3309: p_result := TRUE;
3310: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3311: RETURN(l_ccid);
3312: ELSE
3313: p_result := FALSE;
3314: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );

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

3310: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3311: RETURN(l_ccid);
3312: ELSE
3313: p_result := FALSE;
3314: print_fcn_label2( 'arp_auto_accounting.get_ccid_from_cache()-' );
3315: RETURN(NULL);
3316: END IF;
3317: END IF;
3318: EXCEPTION

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

3316: END IF;
3317: END IF;
3318: EXCEPTION
3319: WHEN OTHERS THEN
3320: debug( 'EXCEPTION: arp_auto_accounting.get_ccid_from_cache_cache()',
3321: MSG_LEVEL_BASIC );
3322: debug(SQLERRM, MSG_LEVEL_BASIC);
3323: RAISE;
3324: END;

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

3368: l_bool BOOLEAN;
3369:
3370: BEGIN
3371:
3372: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()+' );
3373:
3374: --
3375: -- part 1: call the ccid cache or the AOL api to validate and dynamically
3376: -- insert ccid

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

3416: ------------------------------------------------------------------
3417: g_error_buffer := fnd_message.get;
3418: debug( g_error_buffer, MSG_LEVEL_BASIC );
3419:
3420: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3421: RETURN -1;
3422:
3423: END IF;
3424:

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

3451: IF( l_detail_posting_flag = NO ) THEN
3452:
3453: g_error_buffer := MSG_FLEX_POSTING_NOT_ALLOWED;
3454: debug( MSG_FLEX_POSTING_NOT_ALLOWED, MSG_LEVEL_BASIC);
3455: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3456: RETURN -1;
3457:
3458: ELSIF( l_summary_flag = YES ) THEN
3459:

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

3458: ELSIF( l_summary_flag = YES ) THEN
3459:
3460: g_error_buffer := MSG_FLEX_NO_PARENT_ALLOWED;
3461: debug( MSG_FLEX_NO_PARENT_ALLOWED, MSG_LEVEL_BASIC);
3462: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3463: RETURN -1;
3464:
3465: END IF;
3466:

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

3463: RETURN -1;
3464:
3465: END IF;
3466:
3467: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3468: RETURN l_ccid;
3469:
3470: EXCEPTION
3471: WHEN NO_DATA_FOUND THEN

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

3475: debug(SQLERRM, MSG_LEVEL_BASIC);
3476: RAISE;
3477: END;
3478:
3479: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3480:
3481: EXCEPTION
3482: WHEN OTHERS THEN
3483: debug('EXCEPTION: arp_auto_accounting.search_glcc_for_ccid('

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

3479: print_fcn_label2( 'arp_auto_accounting.search_glcc_for_ccid()-' );
3480:
3481: EXCEPTION
3482: WHEN OTHERS THEN
3483: debug('EXCEPTION: arp_auto_accounting.search_glcc_for_ccid('
3484: || to_char(p_segment_cnt) ||')', MSG_LEVEL_BASIC);
3485: debug(SQLERRM, MSG_LEVEL_BASIC);
3486: RAISE;
3487: END search_glcc_for_ccid;

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

3540:
3541: FUNCTION Find_Cursor_In_Cache ( p_key IN VARCHAR2 ) RETURN BINARY_INTEGER IS
3542: BEGIN
3543:
3544: print_fcn_label2( 'arp_auto_accounting.Find_Cursor_In_Cache()+' );
3545:
3546: FOR l_index IN 1..cursor_attr_cache.count LOOP
3547:
3548: IF ( cursor_attr_cache(l_index) = p_key )

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

3547:
3548: IF ( cursor_attr_cache(l_index) = p_key )
3549: THEN
3550: print_fcn_label2(
3551: 'arp_auto_accounting.Find_Cursor_In_Cache()-' );
3552: RETURN( l_index );
3553: END IF;
3554:
3555: END LOOP;

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

3554:
3555: END LOOP;
3556:
3557:
3558: print_fcn_label2( 'arp_auto_accounting.Find_Cursor_In_Cache()-' );
3559:
3560: RETURN(NULL);
3561:
3562: EXCEPTION

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

3560: RETURN(NULL);
3561:
3562: EXCEPTION
3563: WHEN OTHERS THEN
3564: debug('EXCEPTION: arp_auto_accounting.Find_Cursor_In_Cache()',
3565: MSG_LEVEL_BASIC);
3566: debug(SQLERRM, MSG_LEVEL_BASIC);
3567: RAISE;
3568: END;

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

3647: l_ignore INTEGER;
3648:
3649: BEGIN
3650:
3651: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()+' );
3652:
3653: p_keep_cursor_open_flag := TRUE;
3654:
3655: /*----------------------------------+

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

3708:
3709: IF (l_cursor_index IS NOT NULL)
3710: THEN
3711:
3712: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()-' );
3713:
3714: l_cursor := cursor_cache( l_cursor_index );
3715:
3716: debug('Found cursor in cache: key ' || l_key ||

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

3805: RAISE;
3806:
3807: END;
3808:
3809: print_fcn_label2( 'arp_auto_accounting.Get_Select_Cursor()-' );
3810:
3811: RETURN( l_select_c );
3812:
3813:

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

3813:
3814: EXCEPTION
3815: WHEN OTHERS THEN
3816:
3817: debug('EXCEPTION: arp_auto_accounting.Get_Select_Cursor()',
3818: MSG_LEVEL_BASIC);
3819: debug(SQLERRM, MSG_LEVEL_BASIC);
3820: RAISE;
3821:

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

3972: ) IS
3973:
3974: BEGIN
3975:
3976: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()+' );
3977:
3978: BEGIN
3979: Bind_Variable(
3980: p_cursor,

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

4091: p_system_info.base_currency
4092: );
4093:
4094:
4095: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()-' );
4096:
4097: EXCEPTION
4098: WHEN OTHERS THEN
4099: debug('EXCEPTION: arp_auto_accounting.Bind_All_Variables()',

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

4095: print_fcn_label2( 'arp_auto_accounting.Bind_All_Variables()-' );
4096:
4097: EXCEPTION
4098: WHEN OTHERS THEN
4099: debug('EXCEPTION: arp_auto_accounting.Bind_All_Variables()',
4100: MSG_LEVEL_BASIC);
4101: debug(SQLERRM, MSG_LEVEL_BASIC);
4102: RAISE;
4103: END;

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

4145: mtl_system_items.item_type%TYPE ) IS
4146:
4147:
4148: BEGIN
4149: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()+' );
4150:
4151: --
4152: -- trx type
4153: --

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

4218: p_warehouse_id, --Bug#1639334
4219: p_ccid_record.agreecat_ccid_rev );
4220: END IF;
4221:
4222: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()-' );
4223:
4224: EXCEPTION
4225: WHEN OTHERS THEN
4226: debug('EXCEPTION: arp_auto_accounting.get_default_ccids('

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

4222: print_fcn_label2( 'arp_auto_accounting.get_default_ccids()-' );
4223:
4224: EXCEPTION
4225: WHEN OTHERS THEN
4226: debug('EXCEPTION: arp_auto_accounting.get_default_ccids('
4227: || p_account_class || ', '
4228: || to_char(p_line_id) || ', '
4229: || to_char(p_trx_type_id) || ', '
4230: || to_char(p_salesrep_id) || ', '

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

4294: l_int_seg_table fnd_flex_ext.SegmentArray;
4295:
4296: BEGIN
4297:
4298: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()+' );
4299:
4300: -- get offset, count for account class (to access plsql tables)
4301: --
4302: IF( p_account_class in (REV, CHARGES) ) then

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

4579: -- return concat segs, and ccid for interim tax account
4580: p_int_concat_segments := l_int_concat_segments;
4581: END IF;
4582:
4583: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()-' );
4584:
4585: EXCEPTION
4586: WHEN OTHERS THEN
4587: debug('EXCEPTION: arp_auto_accounting.assemble_code_combination('

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

4583: print_fcn_label2( 'arp_auto_accounting.assemble_code_combination()-' );
4584:
4585: EXCEPTION
4586: WHEN OTHERS THEN
4587: debug('EXCEPTION: arp_auto_accounting.assemble_code_combination('
4588: || p_account_class || ')', MSG_LEVEL_BASIC);
4589: debug(SQLERRM, MSG_LEVEL_BASIC);
4590: RAISE;
4591: END assemble_code_combination;

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

4641: l_inv_item_type mtl_system_items.item_type%TYPE;
4642:
4643: PROCEDURE print_params IS
4644: BEGIN
4645: debug('EXCEPTION: arp_auto_accounting.flex_manager('
4646: || p_account_class || ', '
4647: || to_char(p_line_id) || ', '
4648: || to_char(p_trx_type_id) || ', '
4649: || to_char(p_salesrep_id) || ', '

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

4658: END;
4659:
4660: BEGIN
4661:
4662: print_fcn_label( 'arp_auto_accounting.flex_manager()+' );
4663:
4664: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
4665: debug( ' line_id='||to_char(p_line_id), MSG_LEVEL_DEBUG );
4666: debug( ' trx_type_id='||to_char(p_trx_type_id), MSG_LEVEL_DEBUG );

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

4751:
4752: debug( ' interim_tax_ccid= '||to_char(p_int_ccid), MSG_LEVEL_DEBUG );
4753: debug( ' interim_tax_concat_segs= '||p_int_concat_segments, MSG_LEVEL_DEBUG );
4754:
4755: print_fcn_label( 'arp_auto_accounting.flex_manager()-' );
4756:
4757: EXCEPTION
4758: WHEN OTHERS THEN
4759: print_params;

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

4808: l_ctlid_pred VARCHAR2(500);
4809: l_ctlsid_pred VARCHAR2(500);
4810:
4811: BEGIN
4812: print_fcn_label( 'arp_auto_accounting.build_delete_sql()+' );
4813:
4814: --
4815: -- account_class
4816: --

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

4934: debug( l_delete_stmt, MSG_LEVEL_DEBUG );
4935: debug( ' len(l_delete_stmt)=' || to_char(LENGTHB(l_delete_stmt)),
4936: MSG_LEVEL_DEBUG );
4937:
4938: print_fcn_label( 'arp_auto_accounting.build_delete_sql()-' );
4939:
4940: RETURN l_delete_stmt;
4941:
4942:

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

4941:
4942:
4943: EXCEPTION
4944: WHEN OTHERS THEN
4945: debug('EXCEPTION: arp_auto_accounting.build_delete_sql()',
4946: MSG_LEVEL_BASIC);
4947: debug(SQLERRM, MSG_LEVEL_BASIC);
4948: RAISE;
4949: END build_delete_sql;

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

4952: ----------------------------------------------------------------------------
4953: PROCEDURE get_column_values( p_select_c IN INTEGER,
4954: p_select_rec OUT NOCOPY select_rec_type ) IS
4955: BEGIN
4956: print_fcn_label2( 'arp_auto_accounting.get_column_values()+' );
4957:
4958: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
4959: dbms_sql.column_value( p_select_c, 2, p_select_rec.customer_trx_line_id );
4960: dbms_sql.column_value( p_select_c, 3,

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

4994: THEN
4995: p_select_rec.interim_tax_ccid := NULL;
4996: END IF;
4997:
4998: print_fcn_label2( 'arp_auto_accounting.get_column_values()-' );
4999: EXCEPTION
5000: WHEN OTHERS THEN
5001: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
5002: MSG_LEVEL_BASIC);

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

4997:
4998: print_fcn_label2( 'arp_auto_accounting.get_column_values()-' );
4999: EXCEPTION
5000: WHEN OTHERS THEN
5001: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
5002: MSG_LEVEL_BASIC);
5003: debug(SQLERRM, MSG_LEVEL_BASIC);
5004: RAISE;
5005: END get_column_values;

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

5007: ----------------------------------------------------------------------------
5008: PROCEDURE get_column_values( p_select_c IN INTEGER,
5009: p_select_tab OUT NOCOPY select_rec_tab ) IS
5010: BEGIN
5011: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)+' );
5012:
5013: dbms_sql.column_value( p_select_c, 1, p_select_tab.customer_trx_id );
5014: dbms_sql.column_value( p_select_c, 2, p_select_tab.customer_trx_line_id );
5015: dbms_sql.column_value( p_select_c, 3,

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

5042: dbms_sql.column_value( p_select_c, 25, p_select_tab.warehouse_id );
5043: -- 1651593
5044: dbms_sql.column_value( p_select_c, 26, p_select_tab.link_to_cust_trx_line_id);
5045:
5046: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
5047: EXCEPTION
5048: WHEN OTHERS THEN
5049: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
5050: MSG_LEVEL_BASIC);

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

5045:
5046: print_fcn_label2( 'arp_auto_accounting.get_column_values(tab)-' );
5047: EXCEPTION
5048: WHEN OTHERS THEN
5049: debug('EXCEPTION: arp_auto_accounting.get_column_values()',
5050: MSG_LEVEL_BASIC);
5051: debug(SQLERRM, MSG_LEVEL_BASIC);
5052: RAISE;
5053: END get_column_values;

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

5058: total_percent IN OUT NOCOPY NUMBER,
5059: total_amount IN OUT NOCOPY NUMBER,
5060: total_acctd_amount IN OUT NOCOPY NUMBER) IS
5061: BEGIN
5062: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()+' );
5063:
5064: -- update totals
5065:
5066: total_percent := total_percent + select_record.percent;

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

5096: total_acctd_amount := 0;
5097:
5098: END IF;
5099:
5100: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()-' );
5101:
5102: EXCEPTION
5103: WHEN OTHERS THEN
5104: debug('EXCEPTION: arp_auto_accounting.correct_rounding_errors()',

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

5100: print_fcn_label2( 'arp_auto_accounting.correct_rounding_errors()-' );
5101:
5102: EXCEPTION
5103: WHEN OTHERS THEN
5104: debug('EXCEPTION: arp_auto_accounting.correct_rounding_errors()',
5105: MSG_LEVEL_BASIC);
5106: debug(SQLERRM, MSG_LEVEL_BASIC);
5107: RAISE;
5108: END correct_rounding_errors;

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

5124: inext NUMBER := 0;
5125: inow NUMBER := 0;
5126:
5127: BEGIN
5128: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()+' );
5129:
5130: /* Bug 2560036 - modified insert to set rec_offset_flag in
5131: support of directly inserted UNEARN rows for RAM-C */
5132:

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

5246: END IF;
5247: END LOOP;
5248: END IF;
5249:
5250: print_fcn_label2( 'arp_auto_accounting.insert_dist_row()-' );
5251: EXCEPTION
5252: WHEN OTHERS THEN
5253: debug('EXCEPTION: arp_auto_accounting.insert_dist_row()',
5254: MSG_LEVEL_BASIC);

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

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

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

5258:
5259: ----------------------------------------------------------------------------
5260: PROCEDURE dump_select_rec( p_select_rec IN select_rec_type ) IS
5261: BEGIN
5262: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()+' );
5263:
5264: debug( ' Dumping select record: ', MSG_LEVEL_DEBUG );
5265: debug( ' customer_trx_id='
5266: || to_char( p_select_rec.customer_trx_id ), MSG_LEVEL_DEBUG );

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

5310: || to_char( p_select_rec.site_use_id ), MSG_LEVEL_DEBUG );
5311: debug( ' warehouse_id='
5312: || to_char( p_select_rec.warehouse_id ), MSG_LEVEL_DEBUG );
5313:
5314: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()-' );
5315:
5316: EXCEPTION
5317: WHEN OTHERS THEN
5318: debug('EXCEPTION: arp_auto_accounting.dump_select_rec()',

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

5314: print_fcn_label2( 'arp_auto_accounting.dump_select_rec()-' );
5315:
5316: EXCEPTION
5317: WHEN OTHERS THEN
5318: debug('EXCEPTION: arp_auto_accounting.dump_select_rec()',
5319: MSG_LEVEL_BASIC);
5320: debug(SQLERRM, MSG_LEVEL_BASIC);
5321: END dump_select_rec;
5322:

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

5322:
5323: ----------------------------------------------------------------------------
5324: PROCEDURE dump_select_tab( p_select_tab IN select_rec_tab, p_low IN NUMBER, p_high IN NUMBER ) IS
5325: BEGIN
5326: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()+' );
5327:
5328: /* bug 1532372 - changed parameter from l_rows_fetched to l_low and l_high
5329: this apparently corrects the 1000 REC row limit that
5330: we encountered during benchmarking. */

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

5380: debug( ' warehouse_id='
5381: || to_char( p_select_tab.warehouse_id (i)), MSG_LEVEL_DEBUG );
5382: END LOOP;
5383:
5384: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()-' );
5385:
5386: EXCEPTION
5387: WHEN OTHERS THEN
5388: debug('EXCEPTION: arp_auto_accounting.dump_select_tab()',

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

5384: print_fcn_label2( 'arp_auto_accounting.dump_select_tab()-' );
5385:
5386: EXCEPTION
5387: WHEN OTHERS THEN
5388: debug('EXCEPTION: arp_auto_accounting.dump_select_tab()',
5389: MSG_LEVEL_BASIC);
5390: debug(SQLERRM, MSG_LEVEL_BASIC);
5391: END dump_select_tab;
5392: ----------------------------------------------------------------------------

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

5398: i INTEGER:=0;
5399:
5400: BEGIN
5401:
5402: print_fcn_label2( 'arp_auto_accounting.get_select_rec(tab)+' );
5403: debug( ' p_cnt='
5404: || p_cnt, MSG_LEVEL_DEBUG );
5405: i := 1;
5406: p_select_rec.customer_trx_id := p_select_tab.customer_trx_id(p_cnt);

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

5472: return(p_select_rec);
5473:
5474: EXCEPTION
5475: WHEN OTHERS THEN
5476: debug('EXCEPTION: arp_auto_accounting.get_select_rec():'|| i, MSG_LEVEL_BASIC);
5477: debug(SQLERRM, MSG_LEVEL_BASIC);
5478: RAISE;
5479:
5480: END;

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

5720: --------------------------------------------------------------------------
5721: system_info.msg_level := p_msg_level;
5722: arp_global.msg_level := p_msg_level;
5723:
5724: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()+ ' );
5725:
5726: --------------------------------------------------------------------------
5727: -- Initialize
5728: --------------------------------------------------------------------------

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

5747: p_concat_segments,
5748: p_num_failed_dist_rows );
5749:
5750:
5751: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_cover()- ' );
5752:
5753: IF (( p_mode = G AND p_ccid = -1 )
5754: OR
5755: ( p_request_id IS NOT NULL AND p_num_failed_dist_rows > 0)) THEN

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

5839: and line_type = 'LINE';
5840:
5841: BEGIN
5842:
5843: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()+' );
5844: --begin anuj
5845: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
5846: init;
5847: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/

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

6105: IF p_passed_ccid IS NOT NULL AND
6106: p_account_class in('REC','FREIGHT') THEN
6107: p_ccid := p_passed_ccid;
6108: END IF;
6109: IF arp_auto_accounting.g_deposit_flag = 'Y' and
6110: p_account_class = 'REV' THEN
6111: p_ccid := p_passed_ccid;
6112: END IF;
6113:

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

6423:
6424: close_cursor( l_delete_c );
6425:
6426:
6427: print_fcn_label( 'arp_auto_accounting.do_autoaccounting_internal()-' );
6428:
6429:
6430: EXCEPTION
6431: WHEN NO_DATA_FOUND THEN

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

6444: RAISE;
6445: END IF;
6446:
6447: WHEN OTHERS THEN
6448: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting_internal()',
6449: MSG_LEVEL_BASIC );
6450: debug(SQLERRM, MSG_LEVEL_BASIC);
6451:
6452: close_cursor( l_select_c );

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

6491: -- OUT:
6492: --
6493: -- NOTES:
6494: -- If mode is not (G)et, raises the exception
6495: -- arp_auto_accounting.no_ccid if autoaccounting could not derive a
6496: -- valid code combination. The public variable g_error_buffer is
6497: -- populated for more information. In (G)et mode, check the value
6498: -- assigned to p_ccid. If it is -1, then no ccid was found.
6499: --

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

6538: l_account_class VARCHAR2(20);
6539:
6540: BEGIN
6541:
6542: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()+' );
6543:
6544: /*
6545: ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()+',
6546: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);

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

6541:
6542: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()+' );
6543:
6544: /*
6545: ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()+',
6546: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
6547: */
6548: g_error_buffer := NULL;
6549:

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

6920: RAISE no_ccid;
6921:
6922: END IF;
6923:
6924: /*ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()-',
6925: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
6926: */
6927: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()-' );
6928:

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

6923:
6924: /*ar_transaction_pub.debug('arp_auto_accounting.do_autoaccounting()-',
6925: FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR);
6926: */
6927: print_fcn_label( 'arp_auto_accounting.do_autoaccounting()-' );
6928:
6929:
6930: EXCEPTION
6931: WHEN no_ccid OR NO_DATA_FOUND THEN

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

6941: RAISE;
6942: END IF;
6943:
6944: WHEN OTHERS THEN
6945: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting()',
6946: MSG_LEVEL_BASIC );
6947: debug(SQLERRM, MSG_LEVEL_BASIC);
6948:
6949: IF( sqlcode = 1 ) THEN

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

7004: -- OUT:
7005: --
7006: -- NOTES:
7007: -- If mode is not (G)et, raises the exception
7008: -- arp_auto_accounting.no_ccid if autoaccounting could not derive a
7009: -- valid code combination. The public variable g_error_buffer is
7010: -- populated for more information. In (G)et mode, check the value
7011: -- assigned to p_ccid. If it is -1, then no ccid was found.
7012: --

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

7049: l_bill_to_site_use_id NUMBER;
7050:
7051: BEGIN
7052:
7053: print_fcn_label( 'arp_auto_accounting.do_autoaccounting overloaded get mode()+' );
7054:
7055: g_error_buffer := NULL;
7056:
7057: l_bill_to_site_use_id := '';

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

7141: RAISE no_ccid;
7142:
7143: END IF;
7144:
7145: print_fcn_label( 'arp_auto_accounting.do_autoaccounting() overloaded get mode -' );
7146:
7147:
7148: EXCEPTION
7149: WHEN no_ccid OR NO_DATA_FOUND THEN

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

7159: RAISE;
7160: END IF;
7161:
7162: WHEN OTHERS THEN
7163: debug( 'EXCEPTION: arp_auto_accounting.do_autoaccounting()',
7164: MSG_LEVEL_BASIC );
7165: debug(SQLERRM, MSG_LEVEL_BASIC);
7166:
7167: IF( sqlcode = 1 ) THEN

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

7256:
7257: EXCEPTION
7258: WHEN OTHERS THEN
7259: debug(SQLERRM);
7260: debug('arp_auto_accounting.test_load()');
7261: RAISE;
7262: END test_load;
7263:
7264: ----------------------------------------------------------------------------

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

7273: END IF;
7274:
7275: EXCEPTION
7276: WHEN OTHERS THEN
7277: debug('arp_auto_accounting.test_query()');
7278: debug(SQLERRM);
7279: RAISE;
7280: END test_query;
7281:

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

7336: end if;
7337:
7338: EXCEPTION
7339: WHEN OTHERS THEN
7340: debug('arp_auto_accounting.test_find()');
7341: debug(SQLERRM);
7342: RAISE;
7343: END test_find;
7344:

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

7386: debug(to_char(l_int_ccid));
7387:
7388: EXCEPTION
7389: WHEN OTHERS THEN
7390: debug('arp_auto_accounting.test_assembly()');
7391: debug(SQLERRM);
7392: RAISE;
7393: END test_assembly;
7394:

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

7723: END;
7724:
7725: EXCEPTION
7726: WHEN OTHERS THEN
7727: debug('arp_auto_accounting.test_harness()');
7728: debug(SQLERRM);
7729: RAISE;
7730: END test_harness;
7731:

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

7760:
7761:
7762: EXCEPTION
7763: WHEN OTHERS THEN
7764: debug('arp_auto_accounting.test_harness()');
7765: debug(SQLERRM);
7766: RAISE;
7767: END test_wes ;
7768:

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

7786: disable_debug;
7787:
7788: EXCEPTION
7789: WHEN OTHERS THEN
7790: debug('EXCEPTION: arp_auto_accounting.test_build_sql()');
7791: debug(SQLERRM);
7792: RAISE;
7793: END test_build_sql;
7794:

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

7833: disable_debug;
7834:
7835: EXCEPTION
7836: WHEN OTHERS THEN
7837: debug('EXCEPTION: arp_auto_accounting.test_do_autoacc()');
7838: debug(SQLERRM);
7839: RAISE;
7840: END test_do_autoacc;
7841:

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

7848: --begin anuj
7849: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
7850: PROCEDURE init is
7851: BEGIN
7852: print_fcn_label( 'arp_auto_accounting.constructor()+' );
7853:
7854: ------------------------------------------------------------------------
7855: -- Load autoaccounting definition into plsql tables
7856: ------------------------------------------------------------------------

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

7892: get_error_message_text;
7893:
7894: dump_info;
7895:
7896: print_fcn_label( 'arp_auto_accounting.constructor()-' );
7897:
7898: EXCEPTION
7899: WHEN OTHERS THEN
7900: debug('EXCEPTION: arp_auto_accounting.constructor');

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

7896: print_fcn_label( 'arp_auto_accounting.constructor()-' );
7897:
7898: EXCEPTION
7899: WHEN OTHERS THEN
7900: debug('EXCEPTION: arp_auto_accounting.constructor');
7901: debug(SQLERRM);
7902: RAISE;
7903: END init;
7904: BEGIN

Line 7907: END arp_auto_accounting;

7903: END init;
7904: BEGIN
7905: init;
7906:
7907: END arp_auto_accounting;