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.49.12020000.7 2012/09/11 14:37:20 ashlkuma 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 1832: arp_standard.debug( 'arp_rounding.correct_receivables_header()- ' ||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

3857: END LOOP;
3858:
3859: END IF;
3860:
3861: p_error_message := 'arp.rounding: Error identifying rows for correction. trx_id = ' || p_customer_trx_id;
3862:
3863: RETURN(iFALSE);
3864:
3865: END IF;

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

3901: END LOOP;
3902:
3903: END IF;
3904:
3905: p_error_message := ' arp_rounding: Error identifying rows for correction. ' ||
3906: ' trx_id = ' || p_customer_trx_id;
3907:
3908: RETURN(iFALSE);
3909: END IF;

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

3931:
3932: END IF;
3933:
3934: IF PG_DEBUG in ('Y', 'C') THEN
3935: arp_standard.debug('arp_rounding.correct_rule_records_by_line()- ' ||
3936: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
3937: END IF;
3938:
3939: RETURN(iTRUE);

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

4043:
4044: BEGIN
4045:
4046: IF PG_DEBUG in ('Y', 'C') THEN
4047: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()+ ');
4048: END IF;
4049:
4050: /* This is phase 1 of rounding.
4051: Here, we make sure that debits equal credits (REV and UNEARN dists)

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

4497: /* 9317102 - purge GT table to prevent re-processing of lines */
4498: DELETE from ar_line_rev_adj_gt;
4499:
4500: IF PG_DEBUG in ('Y', 'C') THEN
4501: arp_standard.debug('arp_rounding.correct_rev_adj_by_line()-');
4502: END IF;
4503:
4504: RETURN(iTRUE);
4505: END correct_rev_adj_by_line;

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

4542:
4543: begin
4544:
4545: IF PG_DEBUG in ('Y', 'C') THEN
4546: arp_standard.debug('arp_rounding.do_line_level_rounding()+ ' ||
4547: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4548: END IF;
4549:
4550: /*--------------------------------------------------------------+

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

4595:
4596: correct_suspense(p_customer_trx_id);
4597:
4598: IF PG_DEBUG in ('Y', 'C') THEN
4599: arp_standard.debug( 'arp_rounding.do_line_level_rounding()- ' ||
4600: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4601: END IF;
4602:
4603: return(iTRUE);

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

4644:
4645: begin
4646:
4647: IF PG_DEBUG in ('Y', 'C') THEN
4648: arp_standard.debug( 'arp_rounding.replace_balancing_segment()+ ' ||
4649: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4650: END IF;
4651:
4652: if not AR_FLEXBUILDER_WF_PKG.SUBSTITUTE_BALANCING_SEGMENT(

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

4672: ' balancing_ccid: ' || balancing_ccid ||
4673: ' return_ccid: ' || return_ccid ||
4674: ' concat_segs: ' || concat_segs
4675: );
4676: arp_standard.debug( 'arp_rounding.replace_balancing_segment()- ' ||
4677: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4678: END IF;
4679:
4680: return(iTRUE);

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

4724:
4725: begin
4726:
4727: IF PG_DEBUG in ('Y', 'C') THEN
4728: arp_standard.debug('arp_rounding.correct_header_level_rounding()+ ' ||
4729: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4730: END IF;
4731:
4732: /*--------------------------------------------------------------+

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

4810: then return(iFALSE);
4811: end If;
4812:
4813: IF PG_DEBUG in ('Y', 'C') THEN
4814: arp_standard.debug( 'arp_rounding.correct_header_level_rounding()- ' ||
4815: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
4816: END IF;
4817:
4818: return(iTRUE);

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

4824: P_SELECT_REC IN OUT NOCOPY SELECT_REC_TYPE ) IS
4825: BEGIN
4826:
4827: IF PG_DEBUG in ('Y', 'C') THEN
4828: arp_standard.debug( 'arp_rounding.get_select_column_values()+' );
4829: END IF;
4830:
4831: dbms_sql.column_value( p_select_sql_c, 1,
4832: p_select_rec.rec_customer_trx_id);

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

4835: dbms_sql.column_value( p_select_sql_c, 3,
4836: p_select_rec.round_customer_trx_id);
4837:
4838: IF PG_DEBUG in ('Y', 'C') THEN
4839: arp_standard.debug( 'arp_rounding.get_select_column_values()-' );
4840: END IF;
4841:
4842: EXCEPTION
4843: WHEN OTHERS THEN

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

4841:
4842: EXCEPTION
4843: WHEN OTHERS THEN
4844: IF PG_DEBUG in ('Y', 'C') THEN
4845: arp_standard.debug('EXCEPTION: arp_rounding.get_select_column_values()');
4846: END IF;
4847: RAISE;
4848: END get_select_column_values;
4849:

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

4850: PROCEDURE dump_select_rec( P_SELECT_REC IN SELECT_REC_TYPE ) IS
4851: BEGIN
4852:
4853: IF PG_DEBUG in ('Y', 'C') THEN
4854: arp_standard.debug( 'arp_rounding.dump_select_rec()+' );
4855: arp_standard.debug(' Dumping select record: ');
4856: arp_standard.debug(' rec_customer_trx_id=' ||
4857: p_select_rec.rec_customer_trx_id);
4858: arp_standard.debug(' rec_code_combination_id=' ||

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

4858: arp_standard.debug(' rec_code_combination_id=' ||
4859: p_select_rec.rec_code_combination_id);
4860: arp_standard.debug(' round_customer_trx_id=' ||
4861: p_select_rec.round_customer_trx_id);
4862: arp_standard.debug( 'arp_rounding.dump_select_rec()-' );
4863: END IF;
4864:
4865: EXCEPTION
4866: WHEN OTHERS THEN

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

4864:
4865: EXCEPTION
4866: WHEN OTHERS THEN
4867: IF PG_DEBUG in ('Y', 'C') THEN
4868: arp_standard.debug( 'EXCEPTION: arp_rounding.dump_select_rec()' );
4869: END IF;
4870: RAISE;
4871: END dump_select_rec;
4872:

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

4874: PROCEDURE define_columns( P_SELECT_SQL_C IN INTEGER,
4875: P_SELECT_REC IN SELECT_REC_TYPE) IS
4876: BEGIN
4877:
4878: arp_standard.debug( 'arp_rounding.define_columns()+' );
4879:
4880: ------------------------------------------------------------
4881: -- Define columns
4882: ------------------------------------------------------------

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

4888: p_select_rec.rec_code_combination_id );
4889: dbms_sql.define_column( p_select_sql_c, 3,
4890: p_select_rec.round_customer_trx_id );
4891:
4892: arp_standard.debug( 'arp_rounding.define_columns()-' );
4893:
4894: EXCEPTION
4895: WHEN OTHERS THEN
4896: arp_standard.debug( 'EXCEPTION: Error defining columns for select_sql_c' );

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

4908:
4909: BEGIN
4910:
4911: IF PG_DEBUG in ('Y', 'C') THEN
4912: arp_standard.debug( 'arp_rounding.build_select_sql()+' );
4913: END IF;
4914:
4915: ------------------------------------------------
4916: -- Construct where predicate

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

4982: RAISE;
4983: END;
4984:
4985: IF PG_DEBUG in ('Y', 'C') THEN
4986: arp_standard.debug( 'arp_rounding.build_select_sql()-' );
4987: END IF;
4988:
4989:
4990: EXCEPTION

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

4989:
4990: EXCEPTION
4991: WHEN OTHERS THEN
4992: IF PG_DEBUG in ('Y', 'C') THEN
4993: arp_standard.debug( 'EXCEPTION: arp_rounding.build_select_sql()' );
4994: END IF;
4995:
4996: RAISE;
4997: END build_select_sql;

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

5004: | ra_cust_trx_line_gl_dist table. If the transaction was created before |
5005: | setting the header level rounding option On then this function will |
5006: | insert the round record only if there is no activity on it otherwise |
5007: | it will do the release 10 rounding (do_line_level_rounding). |
5008: | Also if arp_rounding is called from revenue recognition program then |
5009: | this function will not insert the ROUND record but revenue recognition|
5010: | will insert it. |
5011: | |
5012: | REQUIRES |

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

5181: dbms_sql.close_cursor(select_sql_c);
5182: end;
5183:
5184: IF PG_DEBUG in ('Y', 'C') THEN
5185: arp_standard.debug( 'arp_rounding.do_header_level_rounding()- ' ||
5186: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
5187: END IF;
5188:
5189: return(iTRUE);

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

5287: | Print out NOCOPY the parameters in debug mode only |
5288: +----------------------------------------------*/
5289:
5290: IF PG_DEBUG in ('Y', 'C') THEN
5291: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()+ ' ||
5292: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
5293: arp_standard.debug(' Request_id: ' || p_request_id ||
5294: ' ctid: '|| p_customer_trx_id ||' ctlid: '||
5295: p_customer_trx_line_id || ' class: ' ||

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

5400: /* End - Bug 13090600 */
5401: end if;
5402:
5403: IF PG_DEBUG in ('Y', 'C') THEN
5404: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()- ' ||
5405: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
5406: END IF;
5407:
5408: RETURN( iTRUE );

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

5419:
5420: ROLLBACK TO SAVEPOINT ARPLBCRE_1;
5421:
5422: IF PG_DEBUG in ('Y', 'C') THEN
5423: arp_standard.debug( 'arp_rounding.correct_dist_rounding_errors()+ ' ||
5424: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
5425: END IF;
5426:
5427: RETURN( iFALSE );

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

5465: +-------------------------------------------------------*/
5466:
5467: SAVEPOINT ARPLBCRE_2;
5468:
5469: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()+ ');
5470:
5471: /*-------------------------------------------------------------------------+
5472: | Correct errors in the revenue_amount_split and revenue_percent_split |
5473: | columns: |

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

5544: END IF;
5545:
5546: p_rows_processed := l_count;
5547:
5548: arp_util.print_fcn_label( 'arp_rounding.correct_scredit_rounding_errs()- ');
5549:
5550: EXCEPTION
5551: WHEN OTHERS THEN
5552:

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

5552:
5553: ROLLBACK TO SAVEPOINT ARPLBCRE_2;
5554:
5555: IF PG_DEBUG in ('Y', 'C') THEN
5556: arp_util.debug('EXCEPTION: arp_rounding.correct_scredit_rounding_errs()');
5557: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
5558: END IF;
5559:
5560:

Line 5592: END ARP_ROUNDING;

5588: EXCEPTION
5589: WHEN OTHERS THEN
5590: g_autoinv := FALSE;
5591: END;
5592: END ARP_ROUNDING;