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_ROUNDING dependencies on ARP_ROUNDING

Line 1: PACKAGE BODY ARP_ROUNDING AS

1: PACKAGE BODY ARP_ROUNDING AS
2: /* $Header: ARPLCREB.pls 120.38.12010000.5 2008/12/01 06:30:03 ankuagar ship $ */
3:
4: /*-------------------------------+
5: | Global variable declarations |

Line 126: arp_util.debug('arp_rounding.set_rec_offset_flag()+');

122: l_no_rof NUMBER;
123: l_count NUMBER;
124: BEGIN
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_util.debug('arp_rounding.set_rec_offset_flag()+');
127: END IF;
128:
129: p_result := 0; -- no action needed
130:

Line 314: arp_util.debug('arp_rounding.set_rec_offset_flag()-');

310: END IF;
311: END IF;
312:
313: IF PG_DEBUG in ('Y', 'C') THEN
314: arp_util.debug('arp_rounding.set_rec_offset_flag()-');
315: END IF;
316: EXCEPTION
317: WHEN OTHERS THEN
318: arp_util.debug('EXCEPTION: arp_process_dist.set_rec_offset_flag()');

Line 424: arp_util.debug('arp_rounding.true_lines_by_gl_date()+');

420:
421: l_rows_needing_truing NUMBER;
422:
423: BEGIN
424: arp_util.debug('arp_rounding.true_lines_by_gl_date()+');
425:
426: IF (p_customer_trx_id IS NOT NULL)
427: THEN
428: /* True the rows (if required) */

Line 519: arp_util.debug('arp_rounding.true_lines_by_gl_date()-');

515: END IF;
516:
517: END IF;
518:
519: arp_util.debug('arp_rounding.true_lines_by_gl_date()-');
520: EXCEPTION
521: WHEN OTHERS THEN
522: arp_util.debug('EXCEPTION: arp_rounding.true_lines_by_gl_date()');
523: RAISE;

Line 522: arp_util.debug('EXCEPTION: arp_rounding.true_lines_by_gl_date()');

518:
519: arp_util.debug('arp_rounding.true_lines_by_gl_date()-');
520: EXCEPTION
521: WHEN OTHERS THEN
522: arp_util.debug('EXCEPTION: arp_rounding.true_lines_by_gl_date()');
523: RAISE;
524: END;
525:
526: /*===========================================================================+

Line 567: arp_util.debug('arp_rounding.correct_suspense()+');

563:
564: l_acctd_correction ra_cust_trx_line_gl_dist.acctd_amount%type;
565: l_rows NUMBER;
566: BEGIN
567: arp_util.debug('arp_rounding.correct_suspense()+');
568:
569: IF (p_customer_trx_id is not NULL)
570: THEN
571:

Line 622: arp_util.debug('arp_rounding.correct_suspense-');

618: NULL, /*p_check_rules_flag*/
619: NULL /*p_period_set_name */
620: );
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_util.debug('arp_rounding.correct_suspense-');
623: END IF;
624: EXCEPTION
625: WHEN OTHERS THEN
626: arp_util.debug('EXCEPTION: arp_process_dist.correct_suspense()');

Line 711: arp_standard.debug(' arp_rounding.do_setup()+ ' ||

707: END IF;
708: END IF;
709:
710: IF PG_DEBUG in ('Y', 'C') THEN
711: arp_standard.debug(' arp_rounding.do_setup()+ ' ||
712: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
713: END IF;
714:
715: /*----------------------+

Line 735: p_error_message := 'arp_rounding - ' ||

731: if (
732: p_trx_header_level_rounding not in ('Y', 'N')
733: )
734: then
735: p_error_message := 'arp_rounding - ' ||
736: arp_standard.fnd_message('AR_CUST_INVALID_PARAMETER', 'PARAMETER', p_trx_header_level_rounding, 'P_TRX_HEADER_LEVEL_ROUNDING');
737:
738: return(iFALSE);
739: end if;

Line 779: p_error_message := 'arp_rounding - ' ||

775: p_customer_trx_id is null
776: )
777: )
778: THEN
779: p_error_message := 'arp_rounding - ' ||
780: arp_standard.fnd_message(arp_standard.MD_MSG_NUMBER,
781: 'AR-PLCRE-PARAM-ID') || ' - ' ||
782: arp_standard.fnd_message('AR-PLCRE-PARAM-ID');
783: RETURN( iFALSE );

Line 798: p_error_message := 'arp_rounding - ' ||

794: p_trx_class_to_process IS NOT NULL AND
795: p_trx_class_to_process NOT IN ('REGULAR_CM', 'INV', 'ALL')
796: )
797: THEN
798: p_error_message := 'arp_rounding - ' ||
799: arp_standard.fnd_message(arp_standard.MD_MSG_NUMBER,
800: 'AR-PLCRE-PARAM-CLASS') || ' - ' ||
801: arp_standard.fnd_message('AR-PLCRE-PARAM-CLASS');
802: RETURN( iFALSE );

Line 817: p_error_message := 'arp_rounding - ' ||

813: p_check_rules_flag IS NOT NULL AND
814: p_check_rules_flag NOT IN ('Y', 'N')
815: )
816: THEN
817: p_error_message := 'arp_rounding - ' ||
818: arp_standard.fnd_message(arp_standard.MD_MSG_NUMBER,
819: 'AR-PLCRE-PARAM-RULES') || ' - ' ||
820: arp_standard.fnd_message('AR-PLCRE-PARAM-RULES');
821: RETURN( iFALSE );

Line 835: p_error_message := 'arp_rounding - ' ||

831: p_activity_flag is not null AND
832: p_activity_flag not in ('Y', 'N','G')
833: )
834: then
835: p_error_message := 'arp_rounding - ' ||
836: arp_standard.fnd_message('AR_CUST_INVALID_PARAMETER', 'PARAMETER', p_activity_flag, 'PARAMETER', 'P_ACTIVITY_FLAG');
837:
838: return(iFALSE);
839: else

Line 908: p_error_message := 'arp_rounding - ' || fnd_message.get;

904: trx_header_round_ccid = -1)
905: )
906: then
907: FND_MESSAGE.set_name('AR','AR-PLCRE-THLR-CCID');
908: p_error_message := 'arp_rounding - ' || fnd_message.get;
909: return(iFALSE);
910: end if;
911:
912: IF PG_DEBUG in ('Y', 'C') THEN

Line 913: arp_standard.debug( 'arp_rounding.do_setup()- ' ||

909: return(iFALSE);
910: end if;
911:
912: IF PG_DEBUG in ('Y', 'C') THEN
913: arp_standard.debug( 'arp_rounding.do_setup()- ' ||
914: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
915: END IF;
916:
917: RETURN( iTRUE );

Line 980: arp_standard.debug('arp_rounding.insert_round_record()+ ' ||

976: begin
977:
978: rows := 0;
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_standard.debug('arp_rounding.insert_round_record()+ ' ||
981: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
982: END IF;
983:
984: if (p_request_id is not null )

Line 1295: arp_standard.debug('arp_rounding.insert_round_record()- ' ||

1291:
1292: p_rows_processed := p_rows_processed + rows;
1293:
1294: IF PG_DEBUG in ('Y', 'C') THEN
1295: arp_standard.debug('arp_rounding.insert_round_record()- ' ||
1296: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
1297: END IF;
1298:
1299: return(iTRUE);

Line 1302: p_error_message := 'arp_rounding - ' || SQLERRM;

1298:
1299: return(iTRUE);
1300: EXCEPTION
1301: WHEN others THEN
1302: p_error_message := 'arp_rounding - ' || SQLERRM;
1303: return(iFALSE);
1304: end insert_round_records;
1305:
1306: /* Bug 2736599 - this routine has been obsoleted due to problems with

Line 1449: arp_standard.debug('arp_rounding.correct_round_record()+ ' ||

1445:
1446: begin
1447:
1448: IF PG_DEBUG in ('Y', 'C') THEN
1449: arp_standard.debug('arp_rounding.correct_round_record()+ ' ||
1450: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
1451: arp_standard.debug('P_CUSTOMER_TRX_ID: ' || P_CUSTOMER_TRX_ID);
1452: END IF;
1453:

Line 1501: arp_standard.debug( 'arp_rounding.correct_round_record()- ' ||

1497: balanced_round_ccid
1498: );
1499:
1500: IF PG_DEBUG in ('Y', 'C') THEN
1501: arp_standard.debug( 'arp_rounding.correct_round_record()- ' ||
1502: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
1503: END IF;
1504:
1505: return(iTRUE);

Line 1550: arp_standard.debug('arp_rounding.correct_receivables_header()+ ' ||

1546:
1547: begin
1548:
1549: IF PG_DEBUG in ('Y', 'C') THEN
1550: arp_standard.debug('arp_rounding.correct_receivables_header()+ ' ||
1551: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
1552: END IF;
1553:
1554: if (p_request_id is not null)

Line 1831: arp_standard.debug( 'arp_rounding.correct_receivables_header()- ' ||

1827:
1828: p_rows_processed := p_rows_processed + l_count;
1829:
1830: IF PG_DEBUG in ('Y', 'C') THEN
1831: arp_standard.debug( 'arp_rounding.correct_receivables_header()- ' ||
1832: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
1833: END IF;
1834:
1835: /* MRC Processing */

Line 1895: arp_standard.debug('arp_rounding.correct_receivables_record()+ ' ||

1891: l_count number;
1892: BEGIN
1893:
1894: IF PG_DEBUG in ('Y', 'C') THEN
1895: arp_standard.debug('arp_rounding.correct_receivables_record()+ ' ||
1896: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1897: END IF;
1898:
1899: IF (p_request_id IS NOT NULL)

Line 2091: arp_standard.debug('arp_rounding.correct_receivables_record()- ' ||

2087:
2088: p_rows_processed := p_rows_processed + l_count;
2089:
2090: IF PG_DEBUG in ('Y', 'C') THEN
2091: arp_standard.debug('arp_rounding.correct_receivables_record()- ' ||
2092: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2093: END IF;
2094:
2095: /* MRC Processing */

Line 2112: arp_standard.debug('EXCEPTION: arp_rounding.correct_receivables_record()- '||

2108: EXCEPTION
2109: WHEN others THEN
2110: p_error_message := SQLERRM;
2111: IF PG_DEBUG in ('Y', 'C') THEN
2112: arp_standard.debug('EXCEPTION: arp_rounding.correct_receivables_record()- '||
2113: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2114: END IF;
2115: RETURN(iFALSE);
2116:

Line 2184: arp_standard.debug('arp_rounding.correct_nonrule_line_records()+ ' ||

2180:
2181: BEGIN
2182:
2183: IF PG_DEBUG in ('Y', 'C') THEN
2184: arp_standard.debug('arp_rounding.correct_nonrule_line_records()+ ' ||
2185: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2186: END IF;
2187:
2188: IF (p_request_id IS NOT NULL)

Line 3119: arp_standard.debug( 'arp_rounding.correct_nonrule_line_records()- ' ||

3115:
3116: p_rows_processed := p_rows_processed + l_count;
3117:
3118: IF PG_DEBUG in ('Y', 'C') THEN
3119: arp_standard.debug( 'arp_rounding.correct_nonrule_line_records()- ' ||
3120: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
3121: END IF;
3122:
3123: /* MRC Processing */

Line 3140: arp_standard.debug('EXCEPTION: arp_rounding.correct_nonrule_line_records failed()- '||

3136: EXCEPTION
3137: WHEN others THEN
3138: p_error_message := SQLERRM;
3139: IF PG_DEBUG in ('Y', 'C') THEN
3140: arp_standard.debug('EXCEPTION: arp_rounding.correct_nonrule_line_records failed()- '||
3141: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
3142: END IF;
3143: RETURN(iFALSE);
3144:

Line 3455: arp_standard.debug( 'arp_rounding.correct_rule_records_by_line()+ ' ||

3451:
3452: BEGIN
3453:
3454: IF PG_DEBUG in ('Y', 'C') THEN
3455: arp_standard.debug( 'arp_rounding.correct_rule_records_by_line()+ ' ||
3456: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
3457: END IF;
3458:
3459: IF (P_CUSTOMER_TRX_ID IS NOT NULL) THEN

Line 3852: p_error_message := 'arp.rounding: Error identifying rows for correction. trx_id = ' || p_customer_trx_id;

3848: END LOOP;
3849:
3850: END IF;
3851:
3852: p_error_message := 'arp.rounding: Error identifying rows for correction. trx_id = ' || p_customer_trx_id;
3853:
3854: RETURN(iFALSE);
3855:
3856: END IF;

Line 3896: p_error_message := ' arp_rounding: Error identifying rows for correction. ' ||

3892: END LOOP;
3893:
3894: END IF;
3895:
3896: p_error_message := ' arp_rounding: Error identifying rows for correction. ' ||
3897: ' trx_id = ' || p_customer_trx_id;
3898:
3899: RETURN(iFALSE);
3900: END IF;

Line 3926: arp_standard.debug('arp_rounding.correct_rule_records_by_line()- ' ||

3922:
3923: END IF;
3924:
3925: IF PG_DEBUG in ('Y', 'C') THEN
3926: arp_standard.debug('arp_rounding.correct_rule_records_by_line()- ' ||
3927: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
3928: END IF;
3929:
3930: RETURN(iTRUE);

Line 4038: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()+ ');

4034:
4035: BEGIN
4036:
4037: IF PG_DEBUG in ('Y', 'C') THEN
4038: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()+ ');
4039: END IF;
4040:
4041: /* This is phase 1 of rounding.
4042: Here, we make sure that debits equal credits (REV and UNEARN dists)

Line 4489: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()-');

4485: );
4486: END IF;
4487:
4488: IF PG_DEBUG in ('Y', 'C') THEN
4489: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()-');
4490: END IF;
4491:
4492: RETURN(iTRUE);
4493: END correct_rev_adj_by_line;

Line 4534: arp_standard.debug('arp_rounding.do_line_level_rounding()+ ' ||

4530:
4531: begin
4532:
4533: IF PG_DEBUG in ('Y', 'C') THEN
4534: arp_standard.debug('arp_rounding.do_line_level_rounding()+ ' ||
4535: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4536: END IF;
4537:
4538: /*--------------------------------------------------------------+

Line 4587: arp_standard.debug( 'arp_rounding.do_line_level_rounding()- ' ||

4583:
4584: correct_suspense(p_customer_trx_id);
4585:
4586: IF PG_DEBUG in ('Y', 'C') THEN
4587: arp_standard.debug( 'arp_rounding.do_line_level_rounding()- ' ||
4588: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4589: END IF;
4590:
4591: return(iTRUE);

Line 4636: arp_standard.debug( 'arp_rounding.replace_balancing_segment()+ ' ||

4632:
4633: begin
4634:
4635: IF PG_DEBUG in ('Y', 'C') THEN
4636: arp_standard.debug( 'arp_rounding.replace_balancing_segment()+ ' ||
4637: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4638: END IF;
4639:
4640: if not AR_FLEXBUILDER_WF_PKG.SUBSTITUTE_BALANCING_SEGMENT(

Line 4664: arp_standard.debug( 'arp_rounding.replace_balancing_segment()- ' ||

4660: ' balancing_ccid: ' || balancing_ccid ||
4661: ' return_ccid: ' || return_ccid ||
4662: ' concat_segs: ' || concat_segs
4663: );
4664: arp_standard.debug( 'arp_rounding.replace_balancing_segment()- ' ||
4665: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4666: END IF;
4667:
4668: return(iTRUE);

Line 4716: arp_standard.debug('arp_rounding.correct_header_level_rounding()+ ' ||

4712:
4713: begin
4714:
4715: IF PG_DEBUG in ('Y', 'C') THEN
4716: arp_standard.debug('arp_rounding.correct_header_level_rounding()+ ' ||
4717: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4718: END IF;
4719:
4720: /*--------------------------------------------------------------+

Line 4802: arp_standard.debug( 'arp_rounding.correct_header_level_rounding()- ' ||

4798: then return(iFALSE);
4799: end If;
4800:
4801: IF PG_DEBUG in ('Y', 'C') THEN
4802: arp_standard.debug( 'arp_rounding.correct_header_level_rounding()- ' ||
4803: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4804: END IF;
4805:
4806: return(iTRUE);

Line 4816: arp_standard.debug( 'arp_rounding.get_select_column_values()+' );

4812: P_SELECT_REC IN OUT NOCOPY SELECT_REC_TYPE ) IS
4813: BEGIN
4814:
4815: IF PG_DEBUG in ('Y', 'C') THEN
4816: arp_standard.debug( 'arp_rounding.get_select_column_values()+' );
4817: END IF;
4818:
4819: dbms_sql.column_value( p_select_sql_c, 1,
4820: p_select_rec.rec_customer_trx_id);

Line 4827: arp_standard.debug( 'arp_rounding.get_select_column_values()-' );

4823: dbms_sql.column_value( p_select_sql_c, 3,
4824: p_select_rec.round_customer_trx_id);
4825:
4826: IF PG_DEBUG in ('Y', 'C') THEN
4827: arp_standard.debug( 'arp_rounding.get_select_column_values()-' );
4828: END IF;
4829:
4830: EXCEPTION
4831: WHEN OTHERS THEN

Line 4833: arp_standard.debug('EXCEPTION: arp_rounding.get_select_column_values()');

4829:
4830: EXCEPTION
4831: WHEN OTHERS THEN
4832: IF PG_DEBUG in ('Y', 'C') THEN
4833: arp_standard.debug('EXCEPTION: arp_rounding.get_select_column_values()');
4834: END IF;
4835: RAISE;
4836: END get_select_column_values;
4837:

Line 4842: arp_standard.debug( 'arp_rounding.dump_select_rec()+' );

4838: PROCEDURE dump_select_rec( P_SELECT_REC IN SELECT_REC_TYPE ) IS
4839: BEGIN
4840:
4841: IF PG_DEBUG in ('Y', 'C') THEN
4842: arp_standard.debug( 'arp_rounding.dump_select_rec()+' );
4843: arp_standard.debug(' Dumping select record: ');
4844: arp_standard.debug(' rec_customer_trx_id=' ||
4845: p_select_rec.rec_customer_trx_id);
4846: arp_standard.debug(' rec_code_combination_id=' ||

Line 4850: arp_standard.debug( 'arp_rounding.dump_select_rec()-' );

4846: arp_standard.debug(' rec_code_combination_id=' ||
4847: p_select_rec.rec_code_combination_id);
4848: arp_standard.debug(' round_customer_trx_id=' ||
4849: p_select_rec.round_customer_trx_id);
4850: arp_standard.debug( 'arp_rounding.dump_select_rec()-' );
4851: END IF;
4852:
4853: EXCEPTION
4854: WHEN OTHERS THEN

Line 4856: arp_standard.debug( 'EXCEPTION: arp_rounding.dump_select_rec()' );

4852:
4853: EXCEPTION
4854: WHEN OTHERS THEN
4855: IF PG_DEBUG in ('Y', 'C') THEN
4856: arp_standard.debug( 'EXCEPTION: arp_rounding.dump_select_rec()' );
4857: END IF;
4858: RAISE;
4859: END dump_select_rec;
4860:

Line 4866: arp_standard.debug( 'arp_rounding.define_columns()+' );

4862: PROCEDURE define_columns( P_SELECT_SQL_C IN INTEGER,
4863: P_SELECT_REC IN SELECT_REC_TYPE) IS
4864: BEGIN
4865:
4866: arp_standard.debug( 'arp_rounding.define_columns()+' );
4867:
4868: ------------------------------------------------------------
4869: -- Define columns
4870: ------------------------------------------------------------

Line 4880: arp_standard.debug( 'arp_rounding.define_columns()-' );

4876: p_select_rec.rec_code_combination_id );
4877: dbms_sql.define_column( p_select_sql_c, 3,
4878: p_select_rec.round_customer_trx_id );
4879:
4880: arp_standard.debug( 'arp_rounding.define_columns()-' );
4881:
4882: EXCEPTION
4883: WHEN OTHERS THEN
4884: arp_standard.debug( 'EXCEPTION: Error defining columns for select_sql_c' );

Line 4900: arp_standard.debug( 'arp_rounding.build_select_sql()+' );

4896:
4897: BEGIN
4898:
4899: IF PG_DEBUG in ('Y', 'C') THEN
4900: arp_standard.debug( 'arp_rounding.build_select_sql()+' );
4901: END IF;
4902:
4903: ------------------------------------------------
4904: -- Construct where predicate

Line 4974: arp_standard.debug( 'arp_rounding.build_select_sql()-' );

4970: RAISE;
4971: END;
4972:
4973: IF PG_DEBUG in ('Y', 'C') THEN
4974: arp_standard.debug( 'arp_rounding.build_select_sql()-' );
4975: END IF;
4976:
4977:
4978: EXCEPTION

Line 4981: arp_standard.debug( 'EXCEPTION: arp_rounding.build_select_sql()' );

4977:
4978: EXCEPTION
4979: WHEN OTHERS THEN
4980: IF PG_DEBUG in ('Y', 'C') THEN
4981: arp_standard.debug( 'EXCEPTION: arp_rounding.build_select_sql()' );
4982: END IF;
4983:
4984: RAISE;
4985: END build_select_sql;

Line 4996: | Also if arp_rounding is called from revenue recognition program then |

4992: | ra_cust_trx_line_gl_dist table. If the transaction was created before |
4993: | setting the header level rounding option On then this function will |
4994: | insert the round record only if there is no activity on it otherwise |
4995: | it will do the release 10 rounding (do_line_level_rounding). |
4996: | Also if arp_rounding is called from revenue recognition program then |
4997: | this function will not insert the ROUND record but revenue recognition|
4998: | will insert it. |
4999: | |
5000: | REQUIRES |

Line 5173: arp_standard.debug( 'arp_rounding.do_header_level_rounding()- ' ||

5169: dbms_sql.close_cursor(select_sql_c);
5170: end;
5171:
5172: IF PG_DEBUG in ('Y', 'C') THEN
5173: arp_standard.debug( 'arp_rounding.do_header_level_rounding()- ' ||
5174: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
5175: END IF;
5176:
5177: return(iTRUE);

Line 5276: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()+ ' ||

5272: | Print out NOCOPY the parameters in debug mode only |
5273: +----------------------------------------------*/
5274:
5275: IF PG_DEBUG in ('Y', 'C') THEN
5276: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()+ ' ||
5277: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
5278: arp_standard.debug(' Request_id: ' || p_request_id ||
5279: ' ctid: '|| p_customer_trx_id ||' ctlid: '||
5280: p_customer_trx_line_id || ' class: ' ||

Line 5334: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()- ' ||

5330: end if;
5331: end if;
5332:
5333: IF PG_DEBUG in ('Y', 'C') THEN
5334: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()- ' ||
5335: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
5336: END IF;
5337:
5338: RETURN( iTRUE );

Line 5353: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()+ ' ||

5349:
5350: ROLLBACK TO SAVEPOINT ARPLBCRE_1;
5351:
5352: IF PG_DEBUG in ('Y', 'C') THEN
5353: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()+ ' ||
5354: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
5355: END IF;
5356:
5357: RETURN( iFALSE );

Line 5399: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()+ ');

5395: +-------------------------------------------------------*/
5396:
5397: SAVEPOINT ARPLBCRE_2;
5398:
5399: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()+ ');
5400:
5401: /*-------------------------------------------------------------------------+
5402: | Correct errors in the revenue_amount_split and revenue_percent_split |
5403: | columns: |

Line 5478: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()- ');

5474: END IF;
5475:
5476: p_rows_processed := l_count;
5477:
5478: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()- ');
5479:
5480: EXCEPTION
5481: WHEN OTHERS THEN
5482:

Line 5486: arp_util.debug('EXCEPTION: arp_rounding.correct_scredit_rounding_errs()');

5482:
5483: ROLLBACK TO SAVEPOINT ARPLBCRE_2;
5484:
5485: IF PG_DEBUG in ('Y', 'C') THEN
5486: arp_util.debug('EXCEPTION: arp_rounding.correct_scredit_rounding_errs()');
5487: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
5488: END IF;
5489:
5490:

Line 5522: END ARP_ROUNDING;

5518: EXCEPTION
5519: WHEN OTHERS THEN
5520: g_autoinv := FALSE;
5521: END;
5522: END ARP_ROUNDING;