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_BR dependencies on ARP_AUTO_ACCOUNTING_BR

Line 1: PACKAGE BODY ARP_AUTO_ACCOUNTING_BR AS

1: PACKAGE BODY ARP_AUTO_ACCOUNTING_BR AS
2: /* $Header: ARTEAABB.pls 120.9 2005/11/14 06:58:28 apandit ship $ */
3:
4: ------------------------------------------------------------------------
5: -- Inherited from other packages

Line 410: print_fcn_label( 'arp_auto_accounting_br.get_error_message_text()+' );

406: l_msg_name VARCHAR2(100);
407:
408: BEGIN
409:
410: print_fcn_label( 'arp_auto_accounting_br.get_error_message_text()+' );
411:
412: l_msg_name := 'AR_COMPLETE_BR_REC_ACCOUNT';
413: fnd_message.set_name('AR', l_msg_name);
414: MSG_COMPLETE_REC_ACCOUNT := fnd_message.get;

Line 458: print_fcn_label( 'arp_auto_accounting_br.get_error_message_text()-' );

454: debug( ' MSG_FLEX_NO_PARENT_ALLOWED='||MSG_FLEX_NO_PARENT_ALLOWED,
455: MSG_LEVEL_DEBUG );
456: debug( ' End List of messages used by Autoaccounting ');
457:
458: print_fcn_label( 'arp_auto_accounting_br.get_error_message_text()-' );
459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: debug('EXCEPTION: arp_auto_accounting_br.get_error_message_text()');

Line 462: debug('EXCEPTION: arp_auto_accounting_br.get_error_message_text()');

458: print_fcn_label( 'arp_auto_accounting_br.get_error_message_text()-' );
459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: debug('EXCEPTION: arp_auto_accounting_br.get_error_message_text()');
463: RAISE;
464: END get_error_message_text;
465:
466: ----------------------------------------------------------------------------

Line 488: debug('EXCEPTION: arp_auto_accounting_br.dump_info()', MSG_LEVEL_BASIC);

484: debug( ' delim='||flex_info.delim, MSG_LEVEL_DEBUG);
485:
486: EXCEPTION
487: WHEN OTHERS THEN
488: debug('EXCEPTION: arp_auto_accounting_br.dump_info()', MSG_LEVEL_BASIC);
489: debug(SQLERRM, MSG_LEVEL_BASIC);
490: RAISE;
491: END dump_info;
492:

Line 514: print_fcn_label( 'arp_auto_accounting_br.dump_ccid_record()+' );

510: -- HISTORY:
511: --
512: PROCEDURE dump_ccid_record( p_ccid_record IN ccid_rec_type ) IS
513: BEGIN
514: print_fcn_label( 'arp_auto_accounting_br.dump_ccid_record()+' );
515:
516: debug( ' Dumping CCID record:', MSG_LEVEL_DEBUG );
517:
518: debug( ' trx_type_ccid_rec=' ||

Line 539: print_fcn_label( 'arp_auto_accounting_br.dump_ccid_record()-' );

535: to_char(p_ccid_record.pym_bact_ccid_factor ), MSG_LEVEL_DEBUG );
536: debug( ' pym_bact_ccid_remittance=' ||
537: to_char(p_ccid_record.pym_bact_ccid_remittance ), MSG_LEVEL_DEBUG );
538:
539: print_fcn_label( 'arp_auto_accounting_br.dump_ccid_record()-' );
540:
541: END dump_ccid_record;
542:
543: ----------------------------------------------------------------------------

Line 609: print_fcn_label( 'arp_auto_accounting_br.load_autoacc_def()+' );

605: p_cnt := p_cnt + 1;
606: END;
607:
608: BEGIN
609: print_fcn_label( 'arp_auto_accounting_br.load_autoacc_def()+' );
610: --begin anuj
611: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/
612: rev_count := 0;
613: rec_count := 0;

Line 649: print_fcn_label( 'arp_auto_accounting_br.load_autoacc_def()-' );

645: load(l_remittance_index, remittance_count, autoacc_rec);
646: END IF;
647: END LOOP;
648:
649: print_fcn_label( 'arp_auto_accounting_br.load_autoacc_def()-' );
650:
651: EXCEPTION
652: WHEN OTHERS THEN
653: debug('EXCEPTION: arp_auto_accounting_br.load_autoacc_def()',

Line 653: debug('EXCEPTION: arp_auto_accounting_br.load_autoacc_def()',

649: print_fcn_label( 'arp_auto_accounting_br.load_autoacc_def()-' );
650:
651: EXCEPTION
652: WHEN OTHERS THEN
653: debug('EXCEPTION: arp_auto_accounting_br.load_autoacc_def()',
654: MSG_LEVEL_BASIC);
655: debug(SQLERRM, MSG_LEVEL_BASIC);
656: RAISE;
657: END load_autoacc_def ;

Line 709: print_fcn_label( 'arp_auto_accounting_br.query_autoacc_def()+' );

705: RETURN false;
706: END;
707:
708: BEGIN
709: print_fcn_label( 'arp_auto_accounting_br.query_autoacc_def()+' );
710:
711: g_error_buffer := NULL;
712:
713: --

Line 732: print_fcn_label( 'arp_auto_accounting_br.query_autoacc_def()-' );

728: debug( 'EXCEPTION: '||g_error_buffer, MSG_LEVEL_BASIC );
729: RAISE invalid_account_class;
730: END IF;
731:
732: print_fcn_label( 'arp_auto_accounting_br.query_autoacc_def()-' );
733:
734: RETURN retval;
735:
736:

Line 739: debug('EXCEPTION: arp_auto_accounting_br.query_autoacc_def('

735:
736:
737: EXCEPTION
738: WHEN OTHERS THEN
739: debug('EXCEPTION: arp_auto_accounting_br.query_autoacc_def('
740: || p_account_class || ', '
741: || p_table_name ||')', MSG_LEVEL_BASIC);
742: debug(SQLERRM, MSG_LEVEL_BASIC);
743: RAISE;

Line 777: print_fcn_label2( 'arp_auto_accounting_br.get_trx_type_ccids()+' );

773: p_ccid_unpaidrec IN OUT NOCOPY BINARY_INTEGER,
774: p_ccid_factor IN OUT NOCOPY BINARY_INTEGER,
775: p_ccid_remittance IN OUT NOCOPY BINARY_INTEGER) IS
776: BEGIN
777: print_fcn_label2( 'arp_auto_accounting_br.get_trx_type_ccids()+' );
778:
779: --
780: -- initialize
781: --

Line 829: print_fcn_label2( 'arp_auto_accounting_br.get_trx_type_ccids()-' );

825: MSG_LEVEL_DEBUG );
826: END;
827:
828:
829: print_fcn_label2( 'arp_auto_accounting_br.get_trx_type_ccids()-' );
830:
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: debug('arp_auto_accounting_br.get_trx_type_ccids(): no data found',

Line 833: debug('arp_auto_accounting_br.get_trx_type_ccids(): no data found',

829: print_fcn_label2( 'arp_auto_accounting_br.get_trx_type_ccids()-' );
830:
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN
833: debug('arp_auto_accounting_br.get_trx_type_ccids(): no data found',
834: MSG_LEVEL_DEBUG);
835: WHEN OTHERS THEN
836: debug('EXCEPTION: arp_auto_accounting_br.get_trx_type_ccids('
837: || to_char(p_trx_type_id) ||')', MSG_LEVEL_BASIC);

Line 836: debug('EXCEPTION: arp_auto_accounting_br.get_trx_type_ccids('

832: WHEN NO_DATA_FOUND THEN
833: debug('arp_auto_accounting_br.get_trx_type_ccids(): no data found',
834: MSG_LEVEL_DEBUG);
835: WHEN OTHERS THEN
836: debug('EXCEPTION: arp_auto_accounting_br.get_trx_type_ccids('
837: || to_char(p_trx_type_id) ||')', MSG_LEVEL_BASIC);
838: debug(SQLERRM, MSG_LEVEL_BASIC);
839: RAISE;
840: END get_trx_type_ccids;

Line 873: print_fcn_label2( 'arp_auto_accounting_br.get_site_use_ccids()+' );

869: p_ccid_unpaidrec IN OUT NOCOPY BINARY_INTEGER,
870: p_ccid_factor IN OUT NOCOPY BINARY_INTEGER,
871: p_ccid_remittance IN OUT NOCOPY BINARY_INTEGER) IS
872: BEGIN
873: print_fcn_label2( 'arp_auto_accounting_br.get_site_use_ccids()+' );
874:
875: --
876: -- initialize
877: --

Line 924: print_fcn_label2( 'arp_auto_accounting_br.get_site_use_ccids()-' );

920:
921: debug( ' cached: site_use_id='||to_char(p_site_use_id),
922: MSG_LEVEL_DEBUG );
923:
924: print_fcn_label2( 'arp_auto_accounting_br.get_site_use_ccids()-' );
925:
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN
928: debug('arp_auto_accounting_br.get_site_use_ccids(): no data found',

Line 928: debug('arp_auto_accounting_br.get_site_use_ccids(): no data found',

924: print_fcn_label2( 'arp_auto_accounting_br.get_site_use_ccids()-' );
925:
926: EXCEPTION
927: WHEN NO_DATA_FOUND THEN
928: debug('arp_auto_accounting_br.get_site_use_ccids(): no data found',
929: MSG_LEVEL_DEBUG);
930: WHEN OTHERS THEN
931: debug('EXCEPTION: arp_auto_accounting_br.get_site_use_ccids('
932: || to_char(p_site_use_id) ||')', MSG_LEVEL_BASIC);

Line 931: debug('EXCEPTION: arp_auto_accounting_br.get_site_use_ccids('

927: WHEN NO_DATA_FOUND THEN
928: debug('arp_auto_accounting_br.get_site_use_ccids(): no data found',
929: MSG_LEVEL_DEBUG);
930: WHEN OTHERS THEN
931: debug('EXCEPTION: arp_auto_accounting_br.get_site_use_ccids('
932: || to_char(p_site_use_id) ||')', MSG_LEVEL_BASIC);
933: debug(SQLERRM, MSG_LEVEL_BASIC);
934: RAISE;
935: END get_site_use_ccids;

Line 967: print_fcn_label2( 'arp_auto_accounting_br.get_pym_bact_ccids()+' );

963: p_ccid_factor IN OUT NOCOPY BINARY_INTEGER,
964: p_ccid_remittance IN OUT NOCOPY BINARY_INTEGER ) IS
965: BEGIN
966:
967: print_fcn_label2( 'arp_auto_accounting_br.get_pym_bact_ccids()+' );
968:
969: p_ccid_factor := -1;
970: p_ccid_remittance := -1;
971:

Line 1005: print_fcn_label2( 'arp_auto_accounting_br.get_pym_bact_ccids()-' );

1001: MSG_LEVEL_DEBUG );
1002:
1003: END;
1004:
1005: print_fcn_label2( 'arp_auto_accounting_br.get_pym_bact_ccids()-' );
1006:
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: debug('arp_auto_accounting_br.get_pym_bact_ccids(): no data found',

Line 1009: debug('arp_auto_accounting_br.get_pym_bact_ccids(): no data found',

1005: print_fcn_label2( 'arp_auto_accounting_br.get_pym_bact_ccids()-' );
1006:
1007: EXCEPTION
1008: WHEN NO_DATA_FOUND THEN
1009: debug('arp_auto_accounting_br.get_pym_bact_ccids(): no data found',
1010: MSG_LEVEL_DEBUG);
1011: WHEN OTHERS THEN
1012: debug('EXCEPTION: arp_auto_accounting_br.get_pym_bact_ccids('
1013: || to_char(p_receipt_method_id) || to_char(p_bank_account_id) ||')', MSG_LEVEL_BASIC);

Line 1012: debug('EXCEPTION: arp_auto_accounting_br.get_pym_bact_ccids('

1008: WHEN NO_DATA_FOUND THEN
1009: debug('arp_auto_accounting_br.get_pym_bact_ccids(): no data found',
1010: MSG_LEVEL_DEBUG);
1011: WHEN OTHERS THEN
1012: debug('EXCEPTION: arp_auto_accounting_br.get_pym_bact_ccids('
1013: || to_char(p_receipt_method_id) || to_char(p_bank_account_id) ||')', MSG_LEVEL_BASIC);
1014: debug(SQLERRM, MSG_LEVEL_BASIC);
1015: RAISE;
1016: END get_pym_bact_ccids;

Line 1036: print_fcn_label( 'arp_auto_accounting_br.get_combination_id()+' );

1032: BEGIN
1033:
1034: -- Initialize messages, debugging, and number of sql strings
1035: --
1036: print_fcn_label( 'arp_auto_accounting_br.get_combination_id()+' );
1037:
1038: r_value := FND_FLEX_KEYVAL.validate_segs('CREATE_COMBINATION',
1039: application_short_name, key_flex_code, structure_number,
1040: concat_segments, 'V',

Line 1044: print_fcn_label( 'arp_auto_accounting_br.get_combination_id()-' );

1040: concat_segments, 'V',
1041: validation_date);
1042: if( r_value ) then
1043: combination_id := FND_FLEX_KEYVAL.combination_id;
1044: print_fcn_label( 'arp_auto_accounting_br.get_combination_id()-' );
1045: return(r_value);
1046: end if;
1047:
1048: return(r_value);

Line 1074: print_fcn_label( 'arp_auto_accounting_br.get_combination_id1()+' );

1070: sepchar VARCHAR2(1);
1071: catsegs VARCHAR2(2000);
1072:
1073: BEGIN
1074: print_fcn_label( 'arp_auto_accounting_br.get_combination_id1()+' );
1075:
1076: -- Concatenate the input segments, then send them to the other function.
1077: --
1078: sepchar := fnd_flex_ext.get_delimiter(application_short_name, key_flex_code,

Line 1081: print_fcn_label( 'arp_auto_accounting_br.get_combination_id1()-' );

1077: --
1078: sepchar := fnd_flex_ext.get_delimiter(application_short_name, key_flex_code,
1079: structure_number);
1080: if(sepchar is not null) then
1081: print_fcn_label( 'arp_auto_accounting_br.get_combination_id1()-' );
1082: return(get_combination_id(application_short_name, key_flex_code,
1083: structure_number, validation_date,
1084: FND_FLEX_EXT.concatenate_segments(n_segments, segments, sepchar),
1085: combination_id));

Line 1101: print_fcn_label2( 'arp_auto_accounting_br.define_columns()+' );

1097: ----------------------------------------------------------------------------
1098: PROCEDURE define_columns( p_select_c IN INTEGER,
1099: p_select_rec IN select_rec_type) IS
1100: BEGIN
1101: print_fcn_label2( 'arp_auto_accounting_br.define_columns()+' );
1102:
1103: dbms_sql.define_column( p_select_c, 1, p_select_rec.customer_trx_id );
1104: dbms_sql.define_column( p_select_c, 2, p_select_rec.cust_trx_type_id);
1105: dbms_sql.define_column( p_select_c, 3, p_select_rec.site_use_id);

Line 1125: print_fcn_label2( 'arp_auto_accounting_br.define_columns()-' );

1121: dbms_sql.define_column( p_select_c, 19, p_select_rec.concatenated_segments,240);
1122: dbms_sql.define_column( p_select_c, 20, p_select_rec.code_combination_id);
1123: dbms_sql.define_column( p_select_c, 21, p_select_rec.br_unpaid_ccid);
1124:
1125: print_fcn_label2( 'arp_auto_accounting_br.define_columns()-' );
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: debug('EXCEPTION: arp_auto_accounting_br.define_columns()',
1129: MSG_LEVEL_BASIC);

Line 1128: debug('EXCEPTION: arp_auto_accounting_br.define_columns()',

1124:
1125: print_fcn_label2( 'arp_auto_accounting_br.define_columns()-' );
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: debug('EXCEPTION: arp_auto_accounting_br.define_columns()',
1129: MSG_LEVEL_BASIC);
1130: debug(SQLERRM, MSG_LEVEL_BASIC);
1131: RAISE;
1132: END define_columns;

Line 1187: print_fcn_label( 'arp_auto_accounting_br.build_select_sql()+' );

1183: l_alias VARCHAR2(4);
1184:
1185: BEGIN
1186:
1187: print_fcn_label( 'arp_auto_accounting_br.build_select_sql()+' );
1188:
1189: ------------------------------------------------------------------------
1190: -- Initialize building blocks columns
1191: ------------------------------------------------------------------------

Line 1397: print_fcn_label( 'arp_auto_accounting_br.build_select_sql()-' );

1393: debug( l_select_stmt, MSG_LEVEL_DEBUG );
1394: debug( ' len(l_select_stmt)=' ||
1395: to_char(length(l_select_stmt)), MSG_LEVEL_DEBUG );
1396:
1397: print_fcn_label( 'arp_auto_accounting_br.build_select_sql()-' );
1398:
1399: RETURN l_select_stmt;
1400:
1401: EXCEPTION

Line 1403: debug('EXCEPTION: arp_auto_accounting_br.build_select_sql()',

1399: RETURN l_select_stmt;
1400:
1401: EXCEPTION
1402: WHEN OTHERS THEN
1403: debug('EXCEPTION: arp_auto_accounting_br.build_select_sql()',
1404: MSG_LEVEL_BASIC);
1405: debug(SQLERRM);
1406: RAISE;
1407:

Line 1477: print_fcn_label2( 'arp_auto_accounting_br.add_segments_to_cache()+' );

1473: l_segment30 varchar2(30);
1474:
1475: BEGIN
1476:
1477: print_fcn_label2( 'arp_auto_accounting_br.add_segments_to_cache()+' );
1478:
1479: SELECT segment1,
1480: segment2,
1481: segment3,

Line 1614: print_fcn_label2( 'arp_auto_accounting_br.add_segments_to_cache()-' );

1610: segment29_cache(p_ccid) := l_segment29;
1611: segment30_cache(p_ccid) := l_segment30;
1612: END IF;
1613:
1614: print_fcn_label2( 'arp_auto_accounting_br.add_segments_to_cache()-' );
1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: debug( 'EXCEPTION: arp_auto_accounting_br.add_segments_to_cache()',

Line 1618: debug( 'EXCEPTION: arp_auto_accounting_br.add_segments_to_cache()',

1614: print_fcn_label2( 'arp_auto_accounting_br.add_segments_to_cache()-' );
1615:
1616: EXCEPTION
1617: WHEN OTHERS THEN
1618: debug( 'EXCEPTION: arp_auto_accounting_br.add_segments_to_cache()',
1619: MSG_LEVEL_BASIC );
1620: debug(SQLERRM, MSG_LEVEL_BASIC);
1621: RAISE;
1622:

Line 1664: print_fcn_label2( 'arp_auto_accounting_br.get_segment_from_glcc()+' );

1660: l_desired_segment varchar2(30);
1661:
1662: BEGIN
1663:
1664: print_fcn_label2( 'arp_auto_accounting_br.get_segment_from_glcc()+' );
1665:
1666: BEGIN
1667:
1668: if (p_segment_number = 1)

Line 1747: print_fcn_label2( 'arp_auto_accounting_br.get_segment_from_glcc()-' );

1743: debug('getting segment ' || p_segment_number ||
1744: 'for ccid ' || p_ccid ||
1745: ' from gl_code_combinations', MSG_LEVEL_DEBUG);
1746:
1747: print_fcn_label2( 'arp_auto_accounting_br.get_segment_from_glcc()-' );
1748: RETURN(l_desired_segment);
1749:
1750: WHEN OTHERS THEN RAISE;
1751:

Line 1757: debug('arp_auto_accounting_br.get_segment_from_glcc(): no data found',

1753:
1754:
1755: EXCEPTION
1756: WHEN NO_DATA_FOUND THEN
1757: debug('arp_auto_accounting_br.get_segment_from_glcc(): no data found',
1758: MSG_LEVEL_DEBUG);
1759: RETURN NULL;
1760: WHEN OTHERS THEN
1761: /* debug('EXCEPTION: arp_auto_accounting_br.get_segment_from_glcc('

Line 1761: /* debug('EXCEPTION: arp_auto_accounting_br.get_segment_from_glcc('

1757: debug('arp_auto_accounting_br.get_segment_from_glcc(): no data found',
1758: MSG_LEVEL_DEBUG);
1759: RETURN NULL;
1760: WHEN OTHERS THEN
1761: /* debug('EXCEPTION: arp_auto_accounting_br.get_segment_from_glcc('
1762: || to_char(p_ccid) || ', '
1763: || to_char(p_segment_number) || ')', MSG_LEVEL_BASIC); */
1764: debug(SQLERRM, MSG_LEVEL_BASIC);
1765: RAISE;

Line 1814: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()+' );

1810: l_ccid BINARY_INTEGER;
1811:
1812: BEGIN
1813:
1814: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()+' );
1815:
1816: /*----------------------------------------------------------------+
1817: | Search the cache for the account_class for the concatenated |
1818: | segments. Return the ccid if it is in the cache. |

Line 1880: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()-' );

1876: p_concat_segments || ' in the cache', MSG_LEVEL_DEBUG);
1877:
1878: p_result := TRUE;
1879:
1880: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()-' );
1881: RETURN( l_ccid );
1882: END IF;
1883:
1884: END LOOP;

Line 1957: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()-' );

1953:
1954: END IF;
1955:
1956: p_result := TRUE;
1957: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()-' );
1958:
1959: RETURN(l_ccid);
1960: ELSE
1961: p_result := FALSE;

Line 1962: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()-' );

1958:
1959: RETURN(l_ccid);
1960: ELSE
1961: p_result := FALSE;
1962: print_fcn_label2( 'arp_auto_accounting_br.get_ccid_from_cache()-' );
1963:
1964: RETURN(NULL);
1965: END IF;
1966:

Line 1968: debug( 'EXCEPTION: arp_auto_accounting_br.get_ccid_from_cache_cache()',

1964: RETURN(NULL);
1965: END IF;
1966:
1967: WHEN OTHERS THEN
1968: debug( 'EXCEPTION: arp_auto_accounting_br.get_ccid_from_cache_cache()',
1969: MSG_LEVEL_BASIC );
1970: debug(SQLERRM, MSG_LEVEL_BASIC);
1971: RAISE;
1972: END;

Line 2019: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()+' );

2015: l_bool BOOLEAN;
2016:
2017: BEGIN
2018:
2019: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()+' );
2020:
2021: --
2022: -- part 1: call the ccid cache or the AOL api to validate and dynamically
2023: -- insert ccid

Line 2067: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );

2063: ------------------------------------------------------------------
2064: g_error_buffer := fnd_message.get;
2065: debug( g_error_buffer, MSG_LEVEL_BASIC );
2066:
2067: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );
2068: RETURN -1;
2069:
2070: END IF;
2071:

Line 2107: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );

2103: IF( l_detail_posting_flag = NO ) THEN
2104:
2105: g_error_buffer := MSG_FLEX_POSTING_NOT_ALLOWED;
2106: debug( MSG_FLEX_POSTING_NOT_ALLOWED, MSG_LEVEL_BASIC);
2107: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );
2108: RETURN -1;
2109:
2110: ELSIF( l_summary_flag = YES ) THEN
2111:

Line 2114: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );

2110: ELSIF( l_summary_flag = YES ) THEN
2111:
2112: g_error_buffer := MSG_FLEX_NO_PARENT_ALLOWED;
2113: debug( MSG_FLEX_NO_PARENT_ALLOWED, MSG_LEVEL_BASIC);
2114: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );
2115: RETURN -1;
2116:
2117: END IF;
2118:

Line 2119: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );

2115: RETURN -1;
2116:
2117: END IF;
2118:
2119: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );
2120: RETURN l_ccid;
2121:
2122: ELSE
2123: --

Line 2138: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );

2134: debug(SQLERRM, MSG_LEVEL_BASIC);
2135: RAISE;
2136: END;
2137:
2138: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );
2139:
2140: EXCEPTION
2141: WHEN OTHERS THEN
2142: debug('EXCEPTION: arp_auto_accounting_br.search_glcc_for_ccid('

Line 2142: debug('EXCEPTION: arp_auto_accounting_br.search_glcc_for_ccid('

2138: print_fcn_label2( 'arp_auto_accounting_br.search_glcc_for_ccid()-' );
2139:
2140: EXCEPTION
2141: WHEN OTHERS THEN
2142: debug('EXCEPTION: arp_auto_accounting_br.search_glcc_for_ccid('
2143: || to_char(p_segment_cnt) ||')', MSG_LEVEL_BASIC);
2144: debug(SQLERRM, MSG_LEVEL_BASIC);
2145: RAISE;
2146: END search_glcc_for_ccid;

Line 2202: print_fcn_label2( 'arp_auto_accounting_br.Find_Cursor_In_Cache()+' );

2198:
2199: FUNCTION Find_Cursor_In_Cache ( p_key IN VARCHAR2 ) RETURN BINARY_INTEGER IS
2200: BEGIN
2201:
2202: print_fcn_label2( 'arp_auto_accounting_br.Find_Cursor_In_Cache()+' );
2203:
2204: FOR l_index IN 1..cursor_attr_cache.count LOOP
2205:
2206: IF ( cursor_attr_cache(l_index) = p_key )

Line 2209: 'arp_auto_accounting_br.Find_Cursor_In_Cache()-' );

2205:
2206: IF ( cursor_attr_cache(l_index) = p_key )
2207: THEN
2208: print_fcn_label2(
2209: 'arp_auto_accounting_br.Find_Cursor_In_Cache()-' );
2210: RETURN( l_index );
2211: END IF;
2212:
2213: END LOOP;

Line 2216: print_fcn_label2( 'arp_auto_accounting_br.Find_Cursor_In_Cache()-' );

2212:
2213: END LOOP;
2214:
2215:
2216: print_fcn_label2( 'arp_auto_accounting_br.Find_Cursor_In_Cache()-' );
2217:
2218: RETURN(NULL);
2219:
2220: EXCEPTION

Line 2222: debug('EXCEPTION: arp_auto_accounting_br.Find_Cursor_In_Cache()',

2218: RETURN(NULL);
2219:
2220: EXCEPTION
2221: WHEN OTHERS THEN
2222: debug('EXCEPTION: arp_auto_accounting_br.Find_Cursor_In_Cache()',
2223: MSG_LEVEL_BASIC);
2224: debug(SQLERRM, MSG_LEVEL_BASIC);
2225: RAISE;
2226: END;

Line 2284: print_fcn_label2( 'arp_auto_accounting_br.Get_Select_Cursor()+' );

2280: l_ignore INTEGER;
2281:
2282: BEGIN
2283:
2284: print_fcn_label2( 'arp_auto_accounting_br.Get_Select_Cursor()+' );
2285:
2286: p_keep_cursor_open_flag := TRUE;
2287:
2288: /*----------------------------------+

Line 2324: print_fcn_label2( 'arp_auto_accounting_br.Get_Select_Cursor()-' );

2320:
2321: IF ( l_cursor_index IS NOT NULL )
2322: THEN
2323:
2324: print_fcn_label2( 'arp_auto_accounting_br.Get_Select_Cursor()-' );
2325:
2326: l_cursor := cursor_cache( l_cursor_index );
2327:
2328: debug('Found cursor in cache: key ' || l_key ||

Line 2404: print_fcn_label2( 'arp_auto_accounting_br.Get_Select_Cursor()-' );

2400: RAISE;
2401:
2402: END;
2403:
2404: print_fcn_label2( 'arp_auto_accounting_br.Get_Select_Cursor()-' );
2405:
2406: RETURN( l_select_c );
2407:
2408:

Line 2412: debug('EXCEPTION: arp_auto_accounting_br.Get_Select_Cursor()',

2408:
2409: EXCEPTION
2410: WHEN OTHERS THEN
2411:
2412: debug('EXCEPTION: arp_auto_accounting_br.Get_Select_Cursor()',
2413: MSG_LEVEL_BASIC);
2414: debug(SQLERRM, MSG_LEVEL_BASIC);
2415: RAISE;
2416:

Line 2549: print_fcn_label2( 'arp_auto_accounting_br.Bind_All_Variables()+' );

2545: ) IS
2546:
2547: BEGIN
2548:
2549: print_fcn_label2( 'arp_auto_accounting_br.Bind_All_Variables()+' );
2550:
2551: BEGIN
2552: Bind_Variable(
2553: p_cursor,

Line 2608: print_fcn_label2( 'arp_auto_accounting_br.Bind_All_Variables()-' );

2604: ':account_class',
2605: p_account_class
2606: );
2607:
2608: print_fcn_label2( 'arp_auto_accounting_br.Bind_All_Variables()-' );
2609:
2610: EXCEPTION
2611: WHEN OTHERS THEN
2612: debug('EXCEPTION: arp_auto_accounting_br.Bind_All_Variables()',

Line 2612: debug('EXCEPTION: arp_auto_accounting_br.Bind_All_Variables()',

2608: print_fcn_label2( 'arp_auto_accounting_br.Bind_All_Variables()-' );
2609:
2610: EXCEPTION
2611: WHEN OTHERS THEN
2612: debug('EXCEPTION: arp_auto_accounting_br.Bind_All_Variables()',
2613: MSG_LEVEL_BASIC);
2614: debug(SQLERRM, MSG_LEVEL_BASIC);
2615: RAISE;
2616: END;

Line 2654: print_fcn_label2( 'arp_auto_accounting_br.get_default_ccids()+' );

2650: p_bank_account_id IN BINARY_INTEGER,
2651: p_ccid_record IN OUT NOCOPY ccid_rec_type ) IS
2652:
2653: BEGIN
2654: print_fcn_label2( 'arp_auto_accounting_br.get_default_ccids()+' );
2655:
2656: --
2657: -- trx type
2658: --

Line 2690: print_fcn_label2( 'arp_auto_accounting_br.get_default_ccids()-' );

2686: p_ccid_record.pym_bact_ccid_factor,
2687: p_ccid_record.pym_bact_ccid_remittance );
2688: END IF;
2689:
2690: print_fcn_label2( 'arp_auto_accounting_br.get_default_ccids()-' );
2691:
2692: EXCEPTION
2693: WHEN OTHERS THEN
2694: debug('EXCEPTION: arp_auto_accounting_br.get_default_ccids('

Line 2694: debug('EXCEPTION: arp_auto_accounting_br.get_default_ccids('

2690: print_fcn_label2( 'arp_auto_accounting_br.get_default_ccids()-' );
2691:
2692: EXCEPTION
2693: WHEN OTHERS THEN
2694: debug('EXCEPTION: arp_auto_accounting_br.get_default_ccids('
2695: || p_account_class || ', '
2696: || to_char(p_trx_type_id) || ', '
2697: || to_char(p_site_use_id) || ', '
2698: || to_char(p_receipt_method_id) || ', '

Line 2754: print_fcn_label2( 'arp_auto_accounting_br.assemble_code_combination()+' );

2750: l_seg_table fnd_flex_ext.SegmentArray;
2751:
2752: BEGIN
2753:
2754: print_fcn_label2( 'arp_auto_accounting_br.assemble_code_combination()+' );
2755:
2756: -- get offset, count for account class (to access plsql tables)
2757: --
2758: IF( p_account_class = REC ) then

Line 2876: print_fcn_label2( 'arp_auto_accounting_br.assemble_code_combination()-' );

2872:
2873: -- return concat segs, and ccid
2874: p_concat_segments := l_concat_segments;
2875:
2876: print_fcn_label2( 'arp_auto_accounting_br.assemble_code_combination()-' );
2877:
2878: EXCEPTION
2879: WHEN OTHERS THEN
2880: debug('EXCEPTION: arp_auto_accounting_br.assemble_code_combination('

Line 2880: debug('EXCEPTION: arp_auto_accounting_br.assemble_code_combination('

2876: print_fcn_label2( 'arp_auto_accounting_br.assemble_code_combination()-' );
2877:
2878: EXCEPTION
2879: WHEN OTHERS THEN
2880: debug('EXCEPTION: arp_auto_accounting_br.assemble_code_combination('
2881: || p_account_class || ')', MSG_LEVEL_BASIC);
2882: debug(SQLERRM, MSG_LEVEL_BASIC);
2883: RAISE;
2884: END assemble_code_combination;

Line 2924: debug('EXCEPTION: arp_auto_accounting_br.flex_manager('

2920: l_ccid_record ccid_rec_type;
2921:
2922: PROCEDURE print_params IS
2923: BEGIN
2924: debug('EXCEPTION: arp_auto_accounting_br.flex_manager('
2925: || p_account_class || ', '
2926: || to_char(p_trx_type_id) || ', '
2927: || to_char(p_site_use_id) || ', '
2928: || to_char(p_receipt_method_id) || ', '

Line 2936: print_fcn_label( 'arp_auto_accounting_br.flex_manager()+' );

2932: END;
2933:
2934: BEGIN
2935:
2936: print_fcn_label( 'arp_auto_accounting_br.flex_manager()+' );
2937:
2938: debug( ' account_class='||p_account_class, MSG_LEVEL_DEBUG );
2939: debug( ' trx_type_id='||to_char(p_trx_type_id), MSG_LEVEL_DEBUG );
2940: debug( ' site_use_id='||to_char(p_site_use_id), MSG_LEVEL_DEBUG );

Line 2978: print_fcn_label( 'arp_auto_accounting_br.flex_manager()-' );

2974:
2975: debug( ' ccid= '||to_char(p_ccid), MSG_LEVEL_DEBUG );
2976: debug( ' concat_segs= '||p_concat_segments, MSG_LEVEL_DEBUG );
2977:
2978: print_fcn_label( 'arp_auto_accounting_br.flex_manager()-' );
2979:
2980: EXCEPTION
2981: WHEN OTHERS THEN
2982: print_params;

Line 3024: print_fcn_label( 'arp_auto_accounting_br.build_delete_sql()+' );

3020:
3021: l_delete_stmt VARCHAR2(1000);
3022:
3023: BEGIN
3024: print_fcn_label( 'arp_auto_accounting_br.build_delete_sql()+' );
3025:
3026: --
3027: -- Construct the Delete Statement
3028: --

Line 3047: print_fcn_label( 'arp_auto_accounting_br.build_delete_sql()-' );

3043: debug( l_delete_stmt, MSG_LEVEL_DEBUG );
3044: debug( ' len(l_delete_stmt)=' || to_char(length(l_delete_stmt)),
3045: MSG_LEVEL_DEBUG );
3046:
3047: print_fcn_label( 'arp_auto_accounting_br.build_delete_sql()-' );
3048:
3049: RETURN l_delete_stmt;
3050:
3051:

Line 3054: debug('EXCEPTION: arp_auto_accounting_br.build_delete_sql()',

3050:
3051:
3052: EXCEPTION
3053: WHEN OTHERS THEN
3054: debug('EXCEPTION: arp_auto_accounting_br.build_delete_sql()',
3055: MSG_LEVEL_BASIC);
3056: debug(SQLERRM, MSG_LEVEL_BASIC);
3057: RAISE;
3058: END build_delete_sql;

Line 3065: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()+' );

3061: ----------------------------------------------------------------------------
3062: PROCEDURE get_column_values( p_select_c IN INTEGER,
3063: p_select_rec OUT NOCOPY select_rec_type ) IS
3064: BEGIN
3065: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()+' );
3066:
3067: dbms_sql.column_value( p_select_c, 1, p_select_rec.customer_trx_id );
3068: dbms_sql.column_value( p_select_c, 2, p_select_rec.cust_trx_type_id);
3069: dbms_sql.column_value( p_select_c, 3, p_select_rec.site_use_id);

Line 3089: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()-' );

3085: dbms_sql.column_value( p_select_c, 19, p_select_rec.concatenated_segments);
3086: dbms_sql.column_value( p_select_c, 20, p_select_rec.code_combination_id);
3087: dbms_sql.column_value( p_select_c, 21, p_select_rec.br_unpaid_ccid);
3088:
3089: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()-' );
3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: debug('EXCEPTION: arp_auto_accounting_br.get_column_values()',
3093: MSG_LEVEL_BASIC);

Line 3092: debug('EXCEPTION: arp_auto_accounting_br.get_column_values()',

3088:
3089: print_fcn_label2( 'arp_auto_accounting_br.get_column_values()-' );
3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: debug('EXCEPTION: arp_auto_accounting_br.get_column_values()',
3093: MSG_LEVEL_BASIC);
3094: debug(SQLERRM, MSG_LEVEL_BASIC);
3095: RAISE;
3096: END get_column_values;

Line 3117: print_fcn_label2( 'arp_auto_accounting_br.insert_dist_row()+' );

3113: l_ae_line_rec_empty ar_distributions%ROWTYPE;
3114: l_dummy NUMBER;
3115:
3116: BEGIN
3117: print_fcn_label2( 'arp_auto_accounting_br.insert_dist_row()+' );
3118:
3119: /*----------------------------------------------------------------------------+
3120: | The amounts and accounted amounts hit the same Dr or Cr buckets, |
3121: | hence the OR cond is used, for all account classes other than normal |

Line 3245: print_fcn_label2( 'arp_auto_accounting_br.insert_dist_row()-' );

3241: -- g_ae_sys_rec.set_of_books_id);
3242: END IF;
3243:
3244: END IF;
3245: print_fcn_label2( 'arp_auto_accounting_br.insert_dist_row()-' );
3246: EXCEPTION
3247: WHEN OTHERS THEN
3248: debug('EXCEPTION: arp_auto_accounting_br.insert_dist_row()',
3249: MSG_LEVEL_BASIC);

Line 3248: debug('EXCEPTION: arp_auto_accounting_br.insert_dist_row()',

3244: END IF;
3245: print_fcn_label2( 'arp_auto_accounting_br.insert_dist_row()-' );
3246: EXCEPTION
3247: WHEN OTHERS THEN
3248: debug('EXCEPTION: arp_auto_accounting_br.insert_dist_row()',
3249: MSG_LEVEL_BASIC);
3250: debug(SQLERRM, MSG_LEVEL_BASIC);
3251: RAISE;
3252: END insert_dist_row;

Line 3257: print_fcn_label2( 'arp_auto_accounting_br.dump_select_rec()+' );

3253:
3254: ----------------------------------------------------------------------------
3255: PROCEDURE dump_select_rec( p_select_rec IN select_rec_type ) IS
3256: BEGIN
3257: print_fcn_label2( 'arp_auto_accounting_br.dump_select_rec()+' );
3258:
3259: debug( ' Dumping select record: ', MSG_LEVEL_DEBUG );
3260: debug( ' customer_trx_id='
3261: || to_char( p_select_rec.customer_trx_id ), MSG_LEVEL_DEBUG );

Line 3302: print_fcn_label2( 'arp_auto_accounting_br.dump_select_rec()-' );

3298: || to_char( p_select_rec.code_combination_id ), MSG_LEVEL_DEBUG );
3299: debug( ' br_unpaid_ccid='
3300: || to_char( p_select_rec.br_unpaid_ccid), MSG_LEVEL_DEBUG );
3301:
3302: print_fcn_label2( 'arp_auto_accounting_br.dump_select_rec()-' );
3303:
3304: EXCEPTION
3305: WHEN OTHERS THEN
3306: debug('EXCEPTION: arp_auto_accounting_br.dump_select_rec()',

Line 3306: debug('EXCEPTION: arp_auto_accounting_br.dump_select_rec()',

3302: print_fcn_label2( 'arp_auto_accounting_br.dump_select_rec()-' );
3303:
3304: EXCEPTION
3305: WHEN OTHERS THEN
3306: debug('EXCEPTION: arp_auto_accounting_br.dump_select_rec()',
3307: MSG_LEVEL_BASIC);
3308: debug(SQLERRM, MSG_LEVEL_BASIC);
3309: RAISE;
3310: END dump_select_rec;

Line 3389: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting_internal()+' );

3385: l_keep_cursor_open_flag BOOLEAN := FALSE;
3386:
3387: BEGIN
3388:
3389: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting_internal()+' );
3390:
3391:
3392: SAVEPOINT ar_auto_accounting;
3393:

Line 3653: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting_internal()-' );

3649:
3650: close_cursor( l_delete_c );
3651:
3652:
3653: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting_internal()-' );
3654:
3655:
3656: EXCEPTION
3657: WHEN NO_DATA_FOUND THEN

Line 3674: debug( 'EXCEPTION: arp_auto_accounting_br.do_autoaccounting_internal()',

3670: RAISE;
3671: END IF;
3672:
3673: WHEN OTHERS THEN
3674: debug( 'EXCEPTION: arp_auto_accounting_br.do_autoaccounting_internal()',
3675: MSG_LEVEL_BASIC );
3676: debug(SQLERRM, MSG_LEVEL_BASIC);
3677:
3678: close_cursor( l_select_c );

Line 3713: -- arp_auto_accounting_br.no_ccid if autoaccounting could not derive a

3709: -- OUT:
3710: --
3711: -- NOTES:
3712: -- If mode is not (G)et, raises the exception
3713: -- arp_auto_accounting_br.no_ccid if autoaccounting could not derive a
3714: -- valid code combination. The public variable g_error_buffer is
3715: -- populated for more information. In (G)et mode, check the value
3716: -- assigned to p_ccid. If it is -1, then no ccid was found.
3717: --

Line 3754: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting()+' );

3750: l_account_class VARCHAR2(20);
3751:
3752: BEGIN
3753:
3754: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting()+' );
3755:
3756: g_error_buffer := NULL;
3757:
3758: --

Line 3811: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting()-' );

3807: RAISE no_ccid;
3808:
3809: END IF;
3810:
3811: print_fcn_label( 'arp_auto_accounting_br.do_autoaccounting()-' );
3812:
3813:
3814: EXCEPTION
3815: WHEN no_ccid OR NO_DATA_FOUND THEN

Line 3828: debug( 'EXCEPTION: arp_auto_accounting_br.do_autoaccounting()',

3824: RAISE;
3825: END IF;
3826:
3827: WHEN OTHERS THEN
3828: debug( 'EXCEPTION: arp_auto_accounting_br.do_autoaccounting()',
3829: MSG_LEVEL_BASIC );
3830: debug(SQLERRM, MSG_LEVEL_BASIC);
3831:
3832: IF( sqlcode = 1 ) THEN

Line 3861: print_fcn_label( 'arp_auto_accounting_br.test_build_sql()+' );

3857: mycursor integer;
3858:
3859: BEGIN
3860:
3861: print_fcn_label( 'arp_auto_accounting_br.test_build_sql()+' );
3862:
3863: -----Test REC account build--------------------------
3864:
3865: select_stmt :=

Line 3912: print_fcn_label( 'arp_auto_accounting_br.test_build_sql()+' );

3908: build_delete_sql(system_info, profile_info,
3909: FACTOR, 1234);
3910: debug(select_stmt);
3911:
3912: print_fcn_label( 'arp_auto_accounting_br.test_build_sql()+' );
3913:
3914: EXCEPTION
3915: WHEN OTHERS THEN
3916: debug('EXCEPTION: arp_auto_accounting.test_build_sql()');

Line 3929: print_fcn_label( 'arp_auto_accounting_br.constructor()+' );

3925: PROCEDURE INIT IS
3926: BEGIN
3927: --enable_debug;
3928:
3929: print_fcn_label( 'arp_auto_accounting_br.constructor()+' );
3930:
3931: ------------------------------------------------------------------------
3932: -- Load autoaccounting definition into plsql tables
3933: ------------------------------------------------------------------------

Line 3988: print_fcn_label( 'arp_auto_accounting_br.constructor()-' );

3984: get_error_message_text;
3985:
3986: dump_info;
3987:
3988: print_fcn_label( 'arp_auto_accounting_br.constructor()-' );
3989:
3990: EXCEPTION
3991: WHEN OTHERS THEN
3992: debug('EXCEPTION: arp_auto_accounting_br.constructor');

Line 3992: debug('EXCEPTION: arp_auto_accounting_br.constructor');

3988: print_fcn_label( 'arp_auto_accounting_br.constructor()-' );
3989:
3990: EXCEPTION
3991: WHEN OTHERS THEN
3992: debug('EXCEPTION: arp_auto_accounting_br.constructor');
3993: debug(SQLERRM);
3994: RAISE;
3995: END INIT;
3996: BEGIN

Line 3999: END ARP_AUTO_ACCOUNTING_BR;

3995: END INIT;
3996: BEGIN
3997: INIT;
3998:
3999: END ARP_AUTO_ACCOUNTING_BR;