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_RULE dependencies on ARP_AUTO_RULE

Line 1: PACKAGE BODY arp_auto_rule AS

1: PACKAGE BODY arp_auto_rule AS
2: /* $Header: ARPLARLB.pls 120.45.12010000.3 2008/11/13 20:12:56 mraymond ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'Y');
4:
5: cr CONSTANT char(1) := '

Line 83: arp_standard.debug('arp_auto_rule.assign_glp_index()+ ' ||

79:
80: FUNCTION assign_glp_index RETURN NUMBER IS
81: error_message FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE; -- bug 4194220
82: BEGIN
83: arp_standard.debug('arp_auto_rule.assign_glp_index()+ ' ||
84: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
85:
86: /* Set glp_index_start to the period having MIN GL date for the trx. */
87:

Line 140: arp_standard.debug('arp_auto_rule.assign_glp_index()- ' ||

136: END IF;
137: END LOOP;
138:
139: RETURN 0;
140: arp_standard.debug('arp_auto_rule.assign_glp_index()- ' ||
141: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
142:
143: END assign_glp_index;
144:

Line 169: arp_standard.debug('arp_auto_rule.assign_glp_rec()+ ' ||

165: +-------------------------------------------------------------------------*/
166: PROCEDURE assign_glp_rec IS
167:
168: BEGIN
169: arp_standard.debug('arp_auto_rule.assign_glp_rec()+ ' ||
170: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
171:
172: /* Set glp_index_rec to the period having REC record's gl date */
173:

Line 187: arp_standard.debug('arp_auto_rule.assign_glp_rec()- ' ||

183: END LOOP;
184:
185: arp_standard.debug('glp table index rec = '||glp_index_rec);
186:
187: arp_standard.debug('arp_auto_rule.assign_glp_rec()- ' ||
188: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
189:
190: END assign_glp_rec;
191:

Line 257: arp_standard.debug('arp_auto_rule.populate_glp_table()+ ' ||

253: last_good_date DATE;
254:
255: BEGIN
256: IF PG_DEBUG in ('Y', 'C') THEN
257: arp_standard.debug('arp_auto_rule.populate_glp_table()+ ' ||
258: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
259: arp_standard.debug('Populating gl_period_statuses table.');
260: END IF;
261:

Line 313: arp_standard.debug('arp_auto_rule.populate_glp_table()- ');

309:
310: END IF; /* end of call-once case */
311:
312: IF PG_DEBUG in ('Y', 'C') THEN
313: arp_standard.debug('arp_auto_rule.populate_glp_table()- ');
314: END IF;
315:
316: END populate_glp_table;
317:

Line 349: arp_standard.debug( 'arp_auto_rule.refresh()+ ' ||

345: Retcode OUT NOCOPY VARCHAR2) IS
346: BEGIN
347:
348: IF PG_DEBUG in ('Y', 'C') THEN
349: arp_standard.debug( 'arp_auto_rule.refresh()+ ' ||
350: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
351: END IF;
352:
353: SAVEPOINT AR_PERIODS_1;

Line 501: arp_standard.debug( 'arp_auto_rule.refresh()- ' ||

497: );
498:
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
501: arp_standard.debug( 'arp_auto_rule.refresh()- ' ||
502: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
503: END IF;
504:
505: EXCEPTION

Line 509: arp_standard.debug('Exception occured in: arp_auto_rule.refresh()');

505: EXCEPTION
506: WHEN OTHERS THEN
507:
508: IF PG_DEBUG in ('Y', 'C') THEN
509: arp_standard.debug('Exception occured in: arp_auto_rule.refresh()');
510: END IF;
511:
512: ROLLBACK TO SAVEPOINT AR_PERIODS_1;
513: RAISE;

Line 723: arp_standard.debug( 'arp_auto_rule.create_assignments()+ ' ||

719: l_return_status NUMBER;
720: BEGIN
721:
722: IF PG_DEBUG in ('Y', 'C') THEN
723: arp_standard.debug( 'arp_auto_rule.create_assignments()+ ' ||
724: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
725: END IF;
726:
727: SELECT

Line 980: arp_standard.debug('arp_auto_rule.create_assignments()- ' ||

976:
977: IF PG_DEBUG in ('Y', 'C') THEN
978: arp_standard.debug('Revenue lines inserted: ' ||
979: l_rows);
980: arp_standard.debug('arp_auto_rule.create_assignments()- ' ||
981: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
982: END IF;
983:
984: RETURN( l_rows);

Line 990: arp_standard.debug('EXCEPTION: arp_auto_rule.create_assignments()');

986: EXCEPTION
987: WHEN OTHERS THEN
988:
989: IF PG_DEBUG in ('Y', 'C') THEN
990: arp_standard.debug('EXCEPTION: arp_auto_rule.create_assignments()');
991: arp_standard.debug(SQLERRM);
992: arp_standard.debug( 'arp_auto_rule.create_assignments()- ' ||
993: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
994: END IF;

Line 992: arp_standard.debug( 'arp_auto_rule.create_assignments()- ' ||

988:
989: IF PG_DEBUG in ('Y', 'C') THEN
990: arp_standard.debug('EXCEPTION: arp_auto_rule.create_assignments()');
991: arp_standard.debug(SQLERRM);
992: arp_standard.debug( 'arp_auto_rule.create_assignments()- ' ||
993: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
994: END IF;
995:
996: RETURN( -1 );

Line 1054: arp_standard.debug( 'arp_auto_rule.create_other_receivable()+ ' ||

1050:
1051: BEGIN
1052:
1053: IF PG_DEBUG in ('Y', 'C') THEN
1054: arp_standard.debug( 'arp_auto_rule.create_other_receivable()+ ' ||
1055: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1056: END IF;
1057:
1058: INSERT INTO ra_cust_trx_line_gl_dist /* REC line */

Line 1179: arp_standard.debug('arp_auto_rule.create_other_receivable(): Change Payment Schedule Gl Date');

1175:
1176: /* bug 1947192 */
1177: FOR i IN c_update_ps(p_trx_id) LOOP
1178: IF PG_DEBUG in ('Y', 'C') THEN
1179: arp_standard.debug('arp_auto_rule.create_other_receivable(): Change Payment Schedule Gl Date');
1180: END IF;
1181: UPDATE ar_payment_schedules
1182: SET gl_date = i.gl_date ,
1183: last_updated_by = arp_standard.profile.user_id,

Line 1189: arp_standard.debug( 'arp_auto_rule.create_other_receivable()- ' ||

1185: WHERE payment_schedule_id = i.ps_id;
1186: END LOOP;
1187:
1188: IF PG_DEBUG in ('Y', 'C') THEN
1189: arp_standard.debug( 'arp_auto_rule.create_other_receivable()- ' ||
1190: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1191: END IF;
1192:
1193: RETURN( l_rows );

Line 1199: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_receivable()');

1195: EXCEPTION
1196: WHEN OTHERS THEN
1197:
1198: IF PG_DEBUG in ('Y', 'C') THEN
1199: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_receivable()');
1200: arp_standard.debug( SQLERRM);
1201: arp_standard.debug( 'arp_auto_rule.create_other_receivable()- ' ||
1202: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1203: END IF;

Line 1201: arp_standard.debug( 'arp_auto_rule.create_other_receivable()- ' ||

1197:
1198: IF PG_DEBUG in ('Y', 'C') THEN
1199: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_receivable()');
1200: arp_standard.debug( SQLERRM);
1201: arp_standard.debug( 'arp_auto_rule.create_other_receivable()- ' ||
1202: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1203: END IF;
1204:
1205: RETURN( -1 );

Line 1255: arp_standard.debug( 'arp_auto_rule.create_round()+ ' ||

1251:
1252: BEGIN
1253:
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_standard.debug( 'arp_auto_rule.create_round()+ ' ||
1256: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1257: END IF;
1258:
1259:

Line 1338: arp_standard.debug( 'arp_auto_rule.create_round()- ' ||

1334:
1335: IF PG_DEBUG in ('Y', 'C') THEN
1336: arp_standard.debug( 'ROUND lines inserted: ' ||
1337: l_rows);
1338: arp_standard.debug( 'arp_auto_rule.create_round()- ' ||
1339: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1340: END IF;
1341:
1342: RETURN( l_rows);

Line 1348: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_round()');

1344: EXCEPTION
1345: WHEN OTHERS THEN
1346:
1347: IF PG_DEBUG in ('Y', 'C') THEN
1348: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_round()');
1349: arp_standard.debug( SQLERRM);
1350: arp_standard.debug( 'arp_auto_rule.create_round()- ' ||
1351: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1352: END IF;

Line 1350: arp_standard.debug( 'arp_auto_rule.create_round()- ' ||

1346:
1347: IF PG_DEBUG in ('Y', 'C') THEN
1348: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_round()');
1349: arp_standard.debug( SQLERRM);
1350: arp_standard.debug( 'arp_auto_rule.create_round()- ' ||
1351: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1352: END IF;
1353:
1354: RETURN( -1 );

Line 1433: arp_standard.debug( 'arp_auto_rule.create_other_plug()+ ' ||

1429:
1430: BEGIN
1431:
1432: IF PG_DEBUG in ('Y', 'C') THEN
1433: arp_standard.debug( 'arp_auto_rule.create_other_plug()+ ' ||
1434: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1435: arp_standard.debug(' use_inv_acctg = ' || g_use_inv_acctg);
1436: END IF;
1437:

Line 1862: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||

1858:
1859: IF PG_DEBUG in ('Y', 'C') THEN
1860: arp_standard.debug( 'Other plug lines inserted: ' ||
1861: l_rows);
1862: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||
1863: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1864: END IF;
1865:
1866: /*Bug 5450534 FP of bug 5260489*/

Line 1898: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_plug()');

1894:
1895: EXCEPTION
1896: WHEN NO_ROF_EXCEPTION THEN
1897: IF PG_DEBUG in ('Y', 'C') THEN
1898: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_plug()');
1899: arp_standard.debug( 'set_rec_offset_flag unable to set flag properly');
1900: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||
1901: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1902: END IF;

Line 1900: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||

1896: WHEN NO_ROF_EXCEPTION THEN
1897: IF PG_DEBUG in ('Y', 'C') THEN
1898: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_plug()');
1899: arp_standard.debug( 'set_rec_offset_flag unable to set flag properly');
1900: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||
1901: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1902: END IF;
1903: RETURN( -1 );
1904: WHEN OTHERS THEN

Line 1907: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_plug()');

1903: RETURN( -1 );
1904: WHEN OTHERS THEN
1905:
1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_plug()');
1908: arp_standard.debug( SQLERRM);
1909: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||
1910: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1911: END IF;

Line 1909: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||

1905:
1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_plug()');
1908: arp_standard.debug( SQLERRM);
1909: arp_standard.debug( 'arp_auto_rule.create_other_plug()- ' ||
1910: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1911: END IF;
1912:
1913: RETURN( -1 );

Line 1955: arp_standard.debug( 'arp_auto_rule.create_other_tax()+ ' ||

1951:
1952: BEGIN
1953:
1954: IF PG_DEBUG in ('Y', 'C') THEN
1955: arp_standard.debug( 'arp_auto_rule.create_other_tax()+ ' ||
1956: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
1957: END IF;
1958:
1959: /* 7131147 - ignore autorule_complete_flag on an

Line 2111: arp_standard.debug( 'arp_auto_rule.create_other_tax()- ' ||

2107:
2108: IF PG_DEBUG in ('Y', 'C') THEN
2109: arp_standard.debug( 'Tax lines inserted: ' ||
2110: l_rows);
2111: arp_standard.debug( 'arp_auto_rule.create_other_tax()- ' ||
2112: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2113: END IF;
2114:
2115: RETURN( l_rows );

Line 2121: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_tax()');

2117: EXCEPTION
2118: WHEN OTHERS THEN
2119:
2120: IF PG_DEBUG in ('Y', 'C') THEN
2121: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_tax()');
2122: arp_standard.debug( SQLERRM);
2123: arp_standard.debug( 'arp_auto_rule.create_other_tax()- ' ||
2124: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2125: END IF;

Line 2123: arp_standard.debug( 'arp_auto_rule.create_other_tax()- ' ||

2119:
2120: IF PG_DEBUG in ('Y', 'C') THEN
2121: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_tax()');
2122: arp_standard.debug( SQLERRM);
2123: arp_standard.debug( 'arp_auto_rule.create_other_tax()- ' ||
2124: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2125: END IF;
2126:
2127: RETURN( -1 );

Line 2167: arp_standard.debug( 'arp_auto_rule.create_other_freight()+ ' ||

2163:
2164: BEGIN
2165:
2166: IF PG_DEBUG in ('Y', 'C') THEN
2167: arp_standard.debug( 'arp_auto_rule.create_other_freight()+ ' ||
2168: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2169: END IF;
2170:
2171: INSERT INTO ra_cust_trx_line_gl_dist /* FREIGHT Lines */

Line 2313: arp_standard.debug( 'arp_auto_rule.create_other_freight()- ' ||

2309:
2310: IF PG_DEBUG in ('Y', 'C') THEN
2311: arp_standard.debug( 'Freight lines inserted: ' ||
2312: l_rows);
2313: arp_standard.debug( 'arp_auto_rule.create_other_freight()- ' ||
2314: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2315: END IF;
2316:
2317: RETURN( l_rows );

Line 2323: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_freight()');

2319: EXCEPTION
2320: WHEN OTHERS THEN
2321:
2322: IF PG_DEBUG in ('Y', 'C') THEN
2323: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_freight()');
2324: arp_standard.debug( SQLERRM);
2325: arp_standard.debug( 'arp_auto_rule.create_other_freight()- ' ||
2326: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2327: END IF;

Line 2325: arp_standard.debug( 'arp_auto_rule.create_other_freight()- ' ||

2321:
2322: IF PG_DEBUG in ('Y', 'C') THEN
2323: arp_standard.debug( 'EXCEPTION: arp_auto_rule.create_other_freight()');
2324: arp_standard.debug( SQLERRM);
2325: arp_standard.debug( 'arp_auto_rule.create_other_freight()- ' ||
2326: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2327: END IF;
2328:
2329: RETURN( -1 );

Line 2383: arp_standard.debug( 'arp_auto_rule.update_durations()+ ' ||

2379:
2380: BEGIN
2381: IF PG_DEBUG in ('Y', 'C') THEN
2382:
2383: arp_standard.debug( 'arp_auto_rule.update_durations()+ ' ||
2384: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2385: END IF;
2386:
2387: /* This statement needs to update the autorule_complete_flag

Line 2471: arp_standard.debug( 'arp_auto_rule.update_durations()- ' ||

2467: IF (PG_DEBUG = 'Y') THEN
2468: arp_standard.debug(' rows updated: ' ||
2469: l_rows);
2470:
2471: arp_standard.debug( 'arp_auto_rule.update_durations()- ' ||
2472: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS' || cr));
2473: END IF;
2474:
2475: RETURN( l_rows );

Line 2480: arp_standard.debug('EXCEPTION: arp_auto_rule.update_durations()');

2476:
2477: EXCEPTION
2478: WHEN OTHERS THEN
2479:
2480: arp_standard.debug('EXCEPTION: arp_auto_rule.update_durations()');
2481: arp_standard.debug(SQLERRM);
2482: arp_standard.debug( 'arp_auto_rule.update_durations()- ' ||
2483: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2484:

Line 2482: arp_standard.debug( 'arp_auto_rule.update_durations()- ' ||

2478: WHEN OTHERS THEN
2479:
2480: arp_standard.debug('EXCEPTION: arp_auto_rule.update_durations()');
2481: arp_standard.debug(SQLERRM);
2482: arp_standard.debug( 'arp_auto_rule.update_durations()- ' ||
2483: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2484:
2485: RETURN( -1 );
2486:

Line 2649: arp_standard.debug( 'arp_auto_rule.create_distributions()+ ' ||

2645: arp_standard.enable_debug;
2646: END IF;
2647:
2648: IF PG_DEBUG in ('Y', 'C') THEN
2649: arp_standard.debug( 'arp_auto_rule.create_distributions()+ ' ||
2650: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
2651: arp_standard.debug( 'debug = '|| p_debug ||', commit = ' || p_commit);
2652: arp_standard.debug( 'round = ' || p_suppress_round || ', continue on error = ' ||
2653: p_continue_on_error);

Line 3136: arp_standard.debug( 'arp_auto_rule.create_distributions()- ' ||

3132: END IF;
3133: END IF;
3134:
3135: IF PG_DEBUG in ('Y', 'C') THEN
3136: arp_standard.debug( 'arp_auto_rule.create_distributions()- ' ||
3137: TO_CHAR(sysdate, 'DD-MON-YY HH:MI:SS'));
3138: END IF;
3139:
3140: RETURN( NVL(sum_dist_created, 0) );

Line 3161: END ARP_AUTO_RULE;

3157: THEN
3158: g_use_inv_acctg := 'N';
3159: END IF;
3160:
3161: END ARP_AUTO_RULE;