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 STANDARD

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 117: arp_standard.debug('glp table index start = '||glp_index_start||', end = '||glp_index_end);

113: THEN
114: glp_index_end := g_rows;
115: END IF;
116:
117: arp_standard.debug('glp table index start = '||glp_index_start||', end = '||glp_index_end);
118:
119: /* bug 3477990 */
120: FOR i IN glp_index_start..glp_index_end
121: LOOP

Line 129: arp_standard.debug('Cannot process this transaction...');

125: AND
126: gl_bump_t(i-1) IS NULL
127: THEN
128: error_message := FND_MESSAGE.GET_STRING('AR','AR_RAXTRX-1783');
129: arp_standard.debug('Cannot process this transaction...');
130: arp_standard.debug('Closed or closed pending period exists at ' || i || 'with start date ' ||
131: TO_CHAR( gl_start_t( i) , 'DD-MON-YY HH:MI:SS'));
132: arp_standard.debug(error_message);
133:

Line 130: arp_standard.debug('Closed or closed pending period exists at ' || i || 'with start date ' ||

126: gl_bump_t(i-1) IS NULL
127: THEN
128: error_message := FND_MESSAGE.GET_STRING('AR','AR_RAXTRX-1783');
129: arp_standard.debug('Cannot process this transaction...');
130: arp_standard.debug('Closed or closed pending period exists at ' || i || 'with start date ' ||
131: TO_CHAR( gl_start_t( i) , 'DD-MON-YY HH:MI:SS'));
132: arp_standard.debug(error_message);
133:
134: RETURN -1;

Line 132: arp_standard.debug(error_message);

128: error_message := FND_MESSAGE.GET_STRING('AR','AR_RAXTRX-1783');
129: arp_standard.debug('Cannot process this transaction...');
130: arp_standard.debug('Closed or closed pending period exists at ' || i || 'with start date ' ||
131: TO_CHAR( gl_start_t( i) , 'DD-MON-YY HH:MI:SS'));
132: arp_standard.debug(error_message);
133:
134: RETURN -1;
135: END IF;
136: END IF;

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 185: arp_standard.debug('glp table index rec = '||glp_index_rec);

181: END IF;
182:
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:

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 259: arp_standard.debug('Populating gl_period_statuses table.');

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:
262: /* Bug 2133254 - only call this the first time in for a given SOB */
263: /* Bug 3879222 - moved this logic inside the procedure */

Line 266: sob_id <> arp_standard.sysparm.set_of_books_id)

262: /* Bug 2133254 - only call this the first time in for a given SOB */
263: /* Bug 3879222 - moved this logic inside the procedure */
264: /* NOTE: sob_id is a global that gets set the first time it executes */
265: IF (sob_id is null OR
266: sob_id <> arp_standard.sysparm.set_of_books_id)
267: THEN
268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_standard.debug( 'glp tables need to be built' ||
270: ' sob_id: ' || sob_id);

Line 269: arp_standard.debug( 'glp tables need to be built' ||

265: IF (sob_id is null OR
266: sob_id <> arp_standard.sysparm.set_of_books_id)
267: THEN
268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_standard.debug( 'glp tables need to be built' ||
270: ' sob_id: ' || sob_id);
271: END IF;
272:
273: sob_id := arp_standard.sysparm.set_of_books_id;

Line 273: sob_id := arp_standard.sysparm.set_of_books_id;

269: arp_standard.debug( 'glp tables need to be built' ||
270: ' sob_id: ' || sob_id);
271: END IF;
272:
273: sob_id := arp_standard.sysparm.set_of_books_id;
274:
275: /* Original logic starts here */
276: g_rows := 0;
277:

Line 285: arp_standard.debug('Row ['|| g_rows ||']: Start Dt <' ||

281: gl_start_t(g_rows) := gl_period_rec.start_date;
282: gl_end_t(g_rows) := gl_period_rec.end_date;
283: gl_status_t(g_rows) := gl_period_rec.closing_status;
284: IF PG_DEBUG in ('Y', 'C') THEN
285: arp_standard.debug('Row ['|| g_rows ||']: Start Dt <' ||
286: gl_period_rec.start_date || '> End Date <' || gl_period_rec.end_date
287: || '> Status <' || gl_period_rec.closing_status || '>');
288: END IF;
289:

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 356: arp_standard.debug('Updating ar_period_types: ');

352:
353: SAVEPOINT AR_PERIODS_1;
354:
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_standard.debug('Updating ar_period_types: ');
357: END IF;
358:
359: UPDATE ar_period_types apt
360: SET

Line 378: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));

374: AND g.adjustment_period_flag = 'N'
375: );
376:
377: IF PG_DEBUG in ('Y', 'C') THEN
378: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
379: arp_standard.debug('Inserting into ar_period_types: ');
380: END IF;
381:
382: INSERT

Line 379: arp_standard.debug('Inserting into ar_period_types: ');

375: );
376:
377: IF PG_DEBUG in ('Y', 'C') THEN
378: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
379: arp_standard.debug('Inserting into ar_period_types: ');
380: END IF;
381:
382: INSERT
383: INTO ar_period_types

Line 403: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));

399: GROUP BY period_type
400: );
401:
402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
404: arp_standard.debug('Deleting redundent ar_periods: ');
405: END IF;
406:
407: DELETE

Line 404: arp_standard.debug('Deleting redundent ar_periods: ');

400: );
401:
402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
404: arp_standard.debug('Deleting redundent ar_periods: ');
405: END IF;
406:
407: DELETE
408: FROM ar_periods ap

Line 420: arp_standard.debug('row(s) deleted: ' || TO_CHAR(sql%rowcount));

416: AND gp.adjustment_period_flag = 'N'
417: );
418:
419: IF PG_DEBUG in ('Y', 'C') THEN
420: arp_standard.debug('row(s) deleted: ' || TO_CHAR(sql%rowcount));
421: arp_standard.debug('Updating start, end dates in ar_periods: ');
422: END IF;
423:
424: UPDATE ar_periods ap

Line 421: arp_standard.debug('Updating start, end dates in ar_periods: ');

417: );
418:
419: IF PG_DEBUG in ('Y', 'C') THEN
420: arp_standard.debug('row(s) deleted: ' || TO_CHAR(sql%rowcount));
421: arp_standard.debug('Updating start, end dates in ar_periods: ');
422: END IF;
423:
424: UPDATE ar_periods ap
425: SET

Line 448: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));

444: )
445: );
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
449: arp_standard.debug('Inserting into ar_periods: ');
450: END IF;
451:
452: INSERT

Line 449: arp_standard.debug('Inserting into ar_periods: ');

445: );
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));
449: arp_standard.debug('Inserting into ar_periods: ');
450: END IF;
451:
452: INSERT
453: INTO ar_periods

Line 475: arp_standard.debug('row(s) inserted: ' || TO_CHAR(sql%rowcount));

471: )
472: );
473:
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_standard.debug('row(s) inserted: ' || TO_CHAR(sql%rowcount));
476: arp_standard.debug('Updating period sequence number in ar_periods: ');
477: END IF;
478:
479: UPDATE ar_periods p1

Line 476: arp_standard.debug('Updating period sequence number in ar_periods: ');

472: );
473:
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_standard.debug('row(s) inserted: ' || TO_CHAR(sql%rowcount));
476: arp_standard.debug('Updating period sequence number in ar_periods: ');
477: END IF;
478:
479: UPDATE ar_periods p1
480: SET

Line 500: arp_standard.debug('row(s) updated: ' || TO_CHAR(sql%rowcount));

496: AND p1.start_date >= p2.start_date
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:

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 558: populate_glp_table(arp_standard.sysparm.set_of_books_id,

554: l_temp_index NUMBER;
555:
556: BEGIN
557: /* Populate the GL periods PL/SQL table. */
558: populate_glp_table(arp_standard.sysparm.set_of_books_id,
559: arp_standard.application_id);
560:
561: /* 3879222 - Added NVLs to accomodate external
562: calls to this routine. Also attempt to set

Line 559: arp_standard.application_id);

555:
556: BEGIN
557: /* Populate the GL periods PL/SQL table. */
558: populate_glp_table(arp_standard.sysparm.set_of_books_id,
559: arp_standard.application_id);
560:
561: /* 3879222 - Added NVLs to accomodate external
562: calls to this routine. Also attempt to set
563: a start index for subsequent calls */

Line 598: arp_standard.debug('ERROR: Unable to find period for ' || p_gl_date);

594:
595: /* NOTE: This only executes if the loop falls through without
596: finding a period for the passed date. It is a soft error
597: condition */
598: arp_standard.debug('ERROR: Unable to find period for ' || p_gl_date);
599:
600: FOR i IN 1..g_rows LOOP
601:
602: IF PG_DEBUG in ('Y', 'C') THEN

Line 603: arp_standard.debug(

599:
600: FOR i IN 1..g_rows LOOP
601:
602: IF PG_DEBUG in ('Y', 'C') THEN
603: arp_standard.debug(
604: 'index = '||i||', '||
605: TO_CHAR(gl_start_t(i), 'DD-MON-RRRR')||', '||
606: TO_CHAR(gl_end_t(i), 'DD-MON-RRRR')||', '||
607: gl_status_t(i)||', '||

Line 652: populate_glp_table(arp_standard.sysparm.set_of_books_id,

648:
649: BEGIN
650:
651: /* Populate the GL periods PL/SQL table. */
652: populate_glp_table(arp_standard.sysparm.set_of_books_id,
653: arp_standard.application_id);
654:
655: IF (gl_status_t(glp_index_rec) IN ('O', 'F', 'N') )
656: THEN

Line 653: arp_standard.application_id);

649: BEGIN
650:
651: /* Populate the GL periods PL/SQL table. */
652: populate_glp_table(arp_standard.sysparm.set_of_books_id,
653: arp_standard.application_id);
654:
655: IF (gl_status_t(glp_index_rec) IN ('O', 'F', 'N') )
656: THEN
657: RETURN( p_gl_date );

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 739: arp_standard.debug('rec date: ' ||

735: AND account_set_flag = 'Y'
736: AND customer_trx_id = p_trx_id ;
737:
738: IF PG_DEBUG in ('Y', 'C') THEN
739: arp_standard.debug('rec date: ' ||
740: TO_CHAR(rec_gl_date));
741: END IF;
742:
743: /* Bug 2143064 - Added ORDERED hint */

Line 757: arp_standard.debug('min date: ' ||

753: customer_trx_id = p_trx_id
754: AND period_set_name = p_period_set_name ;
755:
756: IF PG_DEBUG in ('Y', 'C') THEN
757: arp_standard.debug('min date: ' ||
758: TO_CHAR(min_gl_date) || ', max date: '||
759: TO_CHAR(max_gl_date));
760: END IF;
761:

Line 765: arp_standard.debug('Min/Max gl_dates are NULL!!. Check trx..');

761:
762: IF ( min_gl_date IS NULL OR max_gl_date IS NULL )
763: THEN
764: IF PG_DEBUG in ('Y', 'C') THEN
765: arp_standard.debug('Min/Max gl_dates are NULL!!. Check trx..');
766: END IF;
767: RETURN ( -2 );
768: END IF;
769:

Line 779: arp_standard.debug('before insert....');

775: END IF;
776:
777: assign_glp_rec;
778: IF PG_DEBUG in ('Y', 'C') THEN
779: arp_standard.debug('before insert....');
780: arp_standard.debug('g_rev_mgt_installed : ' ||g_rev_mgt_installed);
781: END IF;
782: INSERT INTO ra_cust_trx_line_gl_dist /* REV lines */
783: (

Line 780: arp_standard.debug('g_rev_mgt_installed : ' ||g_rev_mgt_installed);

776:
777: assign_glp_rec;
778: IF PG_DEBUG in ('Y', 'C') THEN
779: arp_standard.debug('before insert....');
780: arp_standard.debug('g_rev_mgt_installed : ' ||g_rev_mgt_installed);
781: END IF;
782: INSERT INTO ra_cust_trx_line_gl_dist /* REV lines */
783: (
784: customer_trx_line_id,

Line 812: arp_standard.sysparm.set_of_books_id, /* set_of_books_id */

808: SELECT /*+ ORDERED */
809: ass.customer_trx_line_id, /* customer_trx_line_id */
810: lines.customer_trx_id, /* customer_trx_id */
811: dist.code_combination_id, /* code_combination_id */
812: arp_standard.sysparm.set_of_books_id, /* set_of_books_id */
813: ass.account_class, /* account_class */
814: 'N', /* account_set_flag */
815: ROUND(
816: (DECODE(fc.minimum_accountable_unit,

Line 886: arp_standard.profile.request_id,

882: ), /* derived gl_date */
883: DECODE(dist.customer_trx_id, header.customer_trx_id,
884: dist.cust_trx_line_salesrep_id,
885: cmsrep.cust_trx_line_salesrep_id), /* cust_trx_line_salesrep_id */
886: arp_standard.profile.request_id,
887: arp_standard.application_id,
888: arp_standard.profile.program_id,
889: sysdate,
890: sysdate,

Line 887: arp_standard.application_id,

883: DECODE(dist.customer_trx_id, header.customer_trx_id,
884: dist.cust_trx_line_salesrep_id,
885: cmsrep.cust_trx_line_salesrep_id), /* cust_trx_line_salesrep_id */
886: arp_standard.profile.request_id,
887: arp_standard.application_id,
888: arp_standard.profile.program_id,
889: sysdate,
890: sysdate,
891: arp_standard.profile.user_id,

Line 888: arp_standard.profile.program_id,

884: dist.cust_trx_line_salesrep_id,
885: cmsrep.cust_trx_line_salesrep_id), /* cust_trx_line_salesrep_id */
886: arp_standard.profile.request_id,
887: arp_standard.application_id,
888: arp_standard.profile.program_id,
889: sysdate,
890: sysdate,
891: arp_standard.profile.user_id,
892: sysdate,

Line 891: arp_standard.profile.user_id,

887: arp_standard.application_id,
888: arp_standard.profile.program_id,
889: sysdate,
890: sysdate,
891: arp_standard.profile.user_id,
892: sysdate,
893: arp_standard.profile.user_id,
894: -3,
895: ass.gl_date, /* original_gl_date */

Line 893: arp_standard.profile.user_id,

889: sysdate,
890: sysdate,
891: arp_standard.profile.user_id,
892: sysdate,
893: arp_standard.profile.user_id,
894: -3,
895: ass.gl_date, /* original_gl_date */
896: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
897: header.org_id

Line 978: arp_standard.debug('Revenue lines inserted: ' ||

974: final return */
975: l_rows := sql%rowcount;
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;

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 991: arp_standard.debug(SQLERRM);

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;
995:

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 1087: arp_standard.sysparm.set_of_books_id,

1083: RULE hint and changed subquery join (below) */
1084: SELECT
1085: rec.customer_trx_id,
1086: rec.code_combination_id,
1087: arp_standard.sysparm.set_of_books_id,
1088: rec.account_class,
1089: 'N', /* account_set_flag */
1090: 'Y', /* latest_rec_flag */
1091: rec.percent,

Line 1098: arp_standard.profile.request_id,

1094: DECODE(rec.gl_date,
1095: NULL, NULL,
1096: assign_gl_rec(rec.gl_date)
1097: ), /* derived gl_date */
1098: arp_standard.profile.request_id,
1099: arp_standard.profile.user_id,
1100: sysdate,
1101: arp_standard.profile.user_id,
1102: sysdate,

Line 1099: arp_standard.profile.user_id,

1095: NULL, NULL,
1096: assign_gl_rec(rec.gl_date)
1097: ), /* derived gl_date */
1098: arp_standard.profile.request_id,
1099: arp_standard.profile.user_id,
1100: sysdate,
1101: arp_standard.profile.user_id,
1102: sysdate,
1103: arp_standard.application_id,

Line 1101: arp_standard.profile.user_id,

1097: ), /* derived gl_date */
1098: arp_standard.profile.request_id,
1099: arp_standard.profile.user_id,
1100: sysdate,
1101: arp_standard.profile.user_id,
1102: sysdate,
1103: arp_standard.application_id,
1104: arp_standard.profile.program_id,
1105: sysdate,

Line 1103: arp_standard.application_id,

1099: arp_standard.profile.user_id,
1100: sysdate,
1101: arp_standard.profile.user_id,
1102: sysdate,
1103: arp_standard.application_id,
1104: arp_standard.profile.program_id,
1105: sysdate,
1106: -3, /* posting_control_id */
1107: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),

Line 1104: arp_standard.profile.program_id,

1100: sysdate,
1101: arp_standard.profile.user_id,
1102: sysdate,
1103: arp_standard.application_id,
1104: arp_standard.profile.program_id,
1105: sysdate,
1106: -3, /* posting_control_id */
1107: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),
1108: ra_cust_trx_line_gl_dist_s.NEXTVAL,

Line 1135: arp_standard.debug('REC lines inserted: ' ||

1131: );
1132: l_rows := sql%rowcount;
1133:
1134: IF PG_DEBUG in ('Y', 'C') THEN
1135: arp_standard.debug('REC lines inserted: ' ||
1136: l_rows);
1137: END IF;
1138:
1139: IF PG_DEBUG in ('Y', 'C') THEN

Line 1140: arp_standard.debug( 'create_other_receivable(-)');

1136: l_rows);
1137: END IF;
1138:
1139: IF PG_DEBUG in ('Y', 'C') THEN
1140: arp_standard.debug( 'create_other_receivable(-)');
1141: END IF;
1142:
1143:
1144: /* Erase the latest_rec_flag of the receivable account set

Line 1155: last_updated_by = arp_standard.profile.user_id,

1151:
1152: UPDATE ra_cust_trx_line_gl_dist
1153: SET
1154: latest_rec_flag = 'N',
1155: last_updated_by = arp_standard.profile.user_id,
1156: last_update_date = sysdate
1157: WHERE
1158: account_set_flag = 'Y'
1159: AND account_class = 'REC'

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 1183: last_updated_by = arp_standard.profile.user_id,

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,
1184: last_update_date = sysdate
1185: WHERE payment_schedule_id = i.ps_id;
1186: END LOOP;
1187:

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 1200: arp_standard.debug( SQLERRM);

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;
1204:

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 1288: arp_standard.sysparm.set_of_books_id,

1284: )
1285: SELECT
1286: rec.customer_trx_id,
1287: rec.code_combination_id,
1288: arp_standard.sysparm.set_of_books_id,
1289: rec.account_class,
1290: 'N', /* account_set_flag */
1291: null, /* latest_rec_flag */
1292: rec.percent,

Line 1296: arp_standard.profile.request_id,

1292: rec.percent,
1293: rec.amount,
1294: rec.acctd_amount,
1295: rrec.gl_date, /* 2172061 - now fetches date from REC row */
1296: arp_standard.profile.request_id,
1297: arp_standard.profile.user_id,
1298: sysdate,
1299: arp_standard.profile.user_id,
1300: sysdate,

Line 1297: arp_standard.profile.user_id,

1293: rec.amount,
1294: rec.acctd_amount,
1295: rrec.gl_date, /* 2172061 - now fetches date from REC row */
1296: arp_standard.profile.request_id,
1297: arp_standard.profile.user_id,
1298: sysdate,
1299: arp_standard.profile.user_id,
1300: sysdate,
1301: arp_standard.application_id,

Line 1299: arp_standard.profile.user_id,

1295: rrec.gl_date, /* 2172061 - now fetches date from REC row */
1296: arp_standard.profile.request_id,
1297: arp_standard.profile.user_id,
1298: sysdate,
1299: arp_standard.profile.user_id,
1300: sysdate,
1301: arp_standard.application_id,
1302: arp_standard.profile.program_id,
1303: sysdate,

Line 1301: arp_standard.application_id,

1297: arp_standard.profile.user_id,
1298: sysdate,
1299: arp_standard.profile.user_id,
1300: sysdate,
1301: arp_standard.application_id,
1302: arp_standard.profile.program_id,
1303: sysdate,
1304: -3, /* posting_control_id */
1305: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),

Line 1302: arp_standard.profile.program_id,

1298: sysdate,
1299: arp_standard.profile.user_id,
1300: sysdate,
1301: arp_standard.application_id,
1302: arp_standard.profile.program_id,
1303: sysdate,
1304: -3, /* posting_control_id */
1305: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),
1306: ra_cust_trx_line_gl_dist_s.nextval,

Line 1336: arp_standard.debug( 'ROUND lines inserted: ' ||

1332:
1333: l_rows := sql%rowcount;
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;

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 1349: arp_standard.debug( SQLERRM);

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;
1353:

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 1435: arp_standard.debug(' use_inv_acctg = ' || g_use_inv_acctg);

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:
1438: /* Bug 3550426 */
1439: SELECT cust_trx_type_id ,

Line 1448: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);

1444: l_prev_cust_trx_id
1445: FROM ra_customer_trx
1446: WHERE customer_trx_id = p_trx_id;
1447:
1448: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);
1449:
1450: l_ctt_type := arpt_sql_func_util.get_trx_type_details(l_ctt_id, 'TYPE') ;
1451: arp_standard.debug(' l_ctt_type ' || l_ctt_type);
1452:

Line 1451: arp_standard.debug(' l_ctt_type ' || l_ctt_type);

1447:
1448: arp_standard.debug(' prev ct id ' || l_prev_cust_trx_id);
1449:
1450: l_ctt_type := arpt_sql_func_util.get_trx_type_details(l_ctt_id, 'TYPE') ;
1451: arp_standard.debug(' l_ctt_type ' || l_ctt_type);
1452:
1453: IF l_ctt_type = 'CM' AND
1454: g_use_inv_acctg = 'Y'
1455: THEN

Line 1460: arp_standard.debug(' l_revrec_run_flag ' || l_revrec_run_flag);

1456: /* 5598773 - no reason to get the l_revrec_run_flag if
1457: use_inv_acctg is 'N' */
1458: l_revrec_run_flag := arpt_sql_func_util.get_revenue_recog_run_flag(l_prev_cust_trx_id,
1459: l_inv_rule_id);
1460: arp_standard.debug(' l_revrec_run_flag ' || l_revrec_run_flag);
1461: END IF;
1462:
1463: IF l_ctt_type in ('INV','DM') /*Bug 4547416*/
1464: OR

Line 1500: arp_standard.sysparm.set_of_books_id,

1496: SELECT
1497: lines.customer_trx_line_id,
1498: lines.customer_trx_id,
1499: psum.code_combination_id,
1500: arp_standard.sysparm.set_of_books_id,
1501: psum.account_class,
1502: 'N', /* account_set_flag */
1503: ROUND((DECODE(psum.account_class,
1504: 'SUSPENSE', (lines.extended_amount -

Line 1578: arp_standard.profile.request_id,

1574: ), /* derived gl_date */
1575: DECODE(psum.customer_trx_id, trx.customer_trx_id,
1576: psum.cust_trx_line_salesrep_id,
1577: cmsrep.cust_trx_line_salesrep_id), /* salescred ID */
1578: arp_standard.profile.request_id,
1579: arp_standard.profile.user_id,
1580: sysdate,
1581: arp_standard.profile.user_id,
1582: sysdate,

Line 1579: arp_standard.profile.user_id,

1575: DECODE(psum.customer_trx_id, trx.customer_trx_id,
1576: psum.cust_trx_line_salesrep_id,
1577: cmsrep.cust_trx_line_salesrep_id), /* salescred ID */
1578: arp_standard.profile.request_id,
1579: arp_standard.profile.user_id,
1580: sysdate,
1581: arp_standard.profile.user_id,
1582: sysdate,
1583: arp_standard.application_id,

Line 1581: arp_standard.profile.user_id,

1577: cmsrep.cust_trx_line_salesrep_id), /* salescred ID */
1578: arp_standard.profile.request_id,
1579: arp_standard.profile.user_id,
1580: sysdate,
1581: arp_standard.profile.user_id,
1582: sysdate,
1583: arp_standard.application_id,
1584: arp_standard.profile.program_id,
1585: sysdate,

Line 1583: arp_standard.application_id,

1579: arp_standard.profile.user_id,
1580: sysdate,
1581: arp_standard.profile.user_id,
1582: sysdate,
1583: arp_standard.application_id,
1584: arp_standard.profile.program_id,
1585: sysdate,
1586: -3, /* posting_control_id */
1587: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),

Line 1584: arp_standard.profile.program_id,

1580: sysdate,
1581: arp_standard.profile.user_id,
1582: sysdate,
1583: arp_standard.application_id,
1584: arp_standard.profile.program_id,
1585: sysdate,
1586: -3, /* posting_control_id */
1587: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
1588: ra_cust_trx_line_gl_dist_s.NEXTVAL,

Line 1703: arp_standard.sysparm.set_of_books_id,

1699: SELECT
1700: lines.customer_trx_line_id,
1701: lines.customer_trx_id,
1702: psum.code_combination_id,
1703: arp_standard.sysparm.set_of_books_id,
1704: psum.account_class,
1705: 'N', /* account_set_flag */
1706: ROUND((DECODE(psum.account_class,
1707: 'SUSPENSE', (lines.extended_amount -

Line 1781: arp_standard.profile.request_id,

1777: ), /* derived gl_date */
1778: DECODE(psum.customer_trx_id, trx.customer_trx_id,
1779: psum.cust_trx_line_salesrep_id,
1780: cmsrep.cust_trx_line_salesrep_id), /* salescred ID */
1781: arp_standard.profile.request_id,
1782: arp_standard.profile.user_id,
1783: sysdate,
1784: arp_standard.profile.user_id,
1785: sysdate,

Line 1782: arp_standard.profile.user_id,

1778: DECODE(psum.customer_trx_id, trx.customer_trx_id,
1779: psum.cust_trx_line_salesrep_id,
1780: cmsrep.cust_trx_line_salesrep_id), /* salescred ID */
1781: arp_standard.profile.request_id,
1782: arp_standard.profile.user_id,
1783: sysdate,
1784: arp_standard.profile.user_id,
1785: sysdate,
1786: arp_standard.application_id,

Line 1784: arp_standard.profile.user_id,

1780: cmsrep.cust_trx_line_salesrep_id), /* salescred ID */
1781: arp_standard.profile.request_id,
1782: arp_standard.profile.user_id,
1783: sysdate,
1784: arp_standard.profile.user_id,
1785: sysdate,
1786: arp_standard.application_id,
1787: arp_standard.profile.program_id,
1788: sysdate,

Line 1786: arp_standard.application_id,

1782: arp_standard.profile.user_id,
1783: sysdate,
1784: arp_standard.profile.user_id,
1785: sysdate,
1786: arp_standard.application_id,
1787: arp_standard.profile.program_id,
1788: sysdate,
1789: -3, /* posting_control_id */
1790: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),

Line 1787: arp_standard.profile.program_id,

1783: sysdate,
1784: arp_standard.profile.user_id,
1785: sysdate,
1786: arp_standard.application_id,
1787: arp_standard.profile.program_id,
1788: sysdate,
1789: -3, /* posting_control_id */
1790: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
1791: ra_cust_trx_line_gl_dist_s.NEXTVAL,

Line 1860: arp_standard.debug( 'Other plug lines inserted: ' ||

1856:
1857: END IF;
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;

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 1899: arp_standard.debug( 'set_rec_offset_flag unable to set flag properly');

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;
1903: RETURN( -1 );

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 1908: arp_standard.debug( SQLERRM);

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;
1912:

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 1999: arp_standard.sysparm.set_of_books_id,

1995: SELECT
1996: tax_line.customer_trx_line_id,
1997: tax_line.customer_trx_id,
1998: tax.code_combination_id,
1999: arp_standard.sysparm.set_of_books_id,
2000: tax.account_class,
2001: 'N',
2002: tax.percent,
2003: DECODE(fc.minimum_accountable_unit,

Line 2039: arp_standard.profile.request_id,

2035: NULL, NULL,
2036: assign_gl_rec(rec.gl_date)
2037: ), /* derived gl_date */
2038: tax.cust_trx_line_salesrep_id,
2039: arp_standard.profile.request_id,
2040: arp_standard.profile.user_id,
2041: sysdate,
2042: arp_standard.profile.user_id,
2043: sysdate,

Line 2040: arp_standard.profile.user_id,

2036: assign_gl_rec(rec.gl_date)
2037: ), /* derived gl_date */
2038: tax.cust_trx_line_salesrep_id,
2039: arp_standard.profile.request_id,
2040: arp_standard.profile.user_id,
2041: sysdate,
2042: arp_standard.profile.user_id,
2043: sysdate,
2044: arp_standard.application_id,

Line 2042: arp_standard.profile.user_id,

2038: tax.cust_trx_line_salesrep_id,
2039: arp_standard.profile.request_id,
2040: arp_standard.profile.user_id,
2041: sysdate,
2042: arp_standard.profile.user_id,
2043: sysdate,
2044: arp_standard.application_id,
2045: arp_standard.profile.program_id,
2046: sysdate,

Line 2044: arp_standard.application_id,

2040: arp_standard.profile.user_id,
2041: sysdate,
2042: arp_standard.profile.user_id,
2043: sysdate,
2044: arp_standard.application_id,
2045: arp_standard.profile.program_id,
2046: sysdate,
2047: -3,
2048: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),

Line 2045: arp_standard.profile.program_id,

2041: sysdate,
2042: arp_standard.profile.user_id,
2043: sysdate,
2044: arp_standard.application_id,
2045: arp_standard.profile.program_id,
2046: sysdate,
2047: -3,
2048: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
2049: ra_cust_trx_line_gl_dist_s.NEXTVAL,

Line 2109: arp_standard.debug( 'Tax lines inserted: ' ||

2105:
2106: l_rows := sql%rowcount;
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;

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 2122: arp_standard.debug( SQLERRM);

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;
2126:

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 2201: arp_standard.sysparm.set_of_books_id,

2197: SELECT
2198: lines.customer_trx_line_id,
2199: lines.customer_trx_id,
2200: freight.code_combination_id,
2201: arp_standard.sysparm.set_of_books_id,
2202: freight.account_class,
2203: 'N',
2204: freight.percent,
2205: DECODE(fc.minimum_accountable_unit,

Line 2238: arp_standard.profile.request_id,

2234: p_bmau) *
2235: p_bmau), /* acctd_amount */
2236: rec.gl_date,
2237: freight.cust_trx_line_salesrep_id,
2238: arp_standard.profile.request_id,
2239: arp_standard.profile.user_id,
2240: sysdate,
2241: arp_standard.profile.user_id,
2242: sysdate,

Line 2239: arp_standard.profile.user_id,

2235: p_bmau), /* acctd_amount */
2236: rec.gl_date,
2237: freight.cust_trx_line_salesrep_id,
2238: arp_standard.profile.request_id,
2239: arp_standard.profile.user_id,
2240: sysdate,
2241: arp_standard.profile.user_id,
2242: sysdate,
2243: arp_standard.application_id,

Line 2241: arp_standard.profile.user_id,

2237: freight.cust_trx_line_salesrep_id,
2238: arp_standard.profile.request_id,
2239: arp_standard.profile.user_id,
2240: sysdate,
2241: arp_standard.profile.user_id,
2242: sysdate,
2243: arp_standard.application_id,
2244: arp_standard.profile.program_id,
2245: sysdate,

Line 2243: arp_standard.application_id,

2239: arp_standard.profile.user_id,
2240: sysdate,
2241: arp_standard.profile.user_id,
2242: sysdate,
2243: arp_standard.application_id,
2244: arp_standard.profile.program_id,
2245: sysdate,
2246: -3,
2247: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),

Line 2244: arp_standard.profile.program_id,

2240: sysdate,
2241: arp_standard.profile.user_id,
2242: sysdate,
2243: arp_standard.application_id,
2244: arp_standard.profile.program_id,
2245: sysdate,
2246: -3,
2247: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
2248: ra_cust_trx_line_gl_dist_s.NEXTVAL,

Line 2311: arp_standard.debug( 'Freight lines inserted: ' ||

2307:
2308: l_rows := sql%rowcount;
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;

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 2324: arp_standard.debug( SQLERRM);

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;
2328:

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 2409: IF arp_standard.profile.request_id IS NOT NULL

2405: /* Bug 3416070/3403067 - Modified update to only be dependent on
2406: request_id when one is set. ARP_ALLOCATIONS_PKG calls this
2407: code without one. */
2408: /*4578927 suppressed the index on autorule_complete_flag*/
2409: IF arp_standard.profile.request_id IS NOT NULL
2410: THEN
2411: /* Existing logic - request_id is set */
2412:
2413: update ra_customer_trx_lines ul

Line 2418: last_updated_by = arp_standard.profile.user_id,

2414: set autorule_complete_flag = null,
2415: autorule_duration_processed =
2416: accounting_rule_duration,
2417: last_update_date = sysdate,
2418: last_updated_by = arp_standard.profile.user_id,
2419: program_application_id = arp_standard.application_id,
2420: program_update_date = sysdate,
2421: program_id = arp_standard.profile.program_id
2422: where customer_trx_id = p_trx_id

Line 2419: program_application_id = arp_standard.application_id,

2415: autorule_duration_processed =
2416: accounting_rule_duration,
2417: last_update_date = sysdate,
2418: last_updated_by = arp_standard.profile.user_id,
2419: program_application_id = arp_standard.application_id,
2420: program_update_date = sysdate,
2421: program_id = arp_standard.profile.program_id
2422: where customer_trx_id = p_trx_id
2423: and autorule_complete_flag||'' = 'N'

Line 2421: program_id = arp_standard.profile.program_id

2417: last_update_date = sysdate,
2418: last_updated_by = arp_standard.profile.user_id,
2419: program_application_id = arp_standard.application_id,
2420: program_update_date = sysdate,
2421: program_id = arp_standard.profile.program_id
2422: where customer_trx_id = p_trx_id
2423: and autorule_complete_flag||'' = 'N'
2424: and (exists (select 'at least one distribution'
2425: from ra_cust_trx_line_gl_dist gl

Line 2428: and gl.request_id = arp_standard.profile.request_id)

2424: and (exists (select 'at least one distribution'
2425: from ra_cust_trx_line_gl_dist gl
2426: where gl.customer_trx_line_id = ul.customer_trx_line_id
2427: and gl.account_set_flag = 'N'
2428: and gl.request_id = arp_standard.profile.request_id)
2429: or exists (select 'a distribution for a linked line'
2430: from ra_customer_trx_lines tl,
2431: ra_cust_trx_line_gl_dist tgl
2432: where tl.customer_trx_id = ul.customer_trx_id

Line 2436: and tgl.request_id = arp_standard.profile.request_id));

2432: where tl.customer_trx_id = ul.customer_trx_id
2433: and tl.link_to_cust_trx_line_id = ul.customer_trx_line_id
2434: and tgl.customer_trx_line_id = tl.customer_trx_line_id
2435: and tgl.account_set_flag = 'N'
2436: and tgl.request_id = arp_standard.profile.request_id));
2437:
2438: ELSE
2439: /* Request_id is not set */
2440: update ra_customer_trx_lines ul

Line 2445: last_updated_by = arp_standard.profile.user_id,

2441: set autorule_complete_flag = null,
2442: autorule_duration_processed =
2443: accounting_rule_duration,
2444: last_update_date = sysdate,
2445: last_updated_by = arp_standard.profile.user_id,
2446: program_application_id = arp_standard.application_id,
2447: program_update_date = sysdate,
2448: program_id = arp_standard.profile.program_id
2449: where customer_trx_id = p_trx_id

Line 2446: program_application_id = arp_standard.application_id,

2442: autorule_duration_processed =
2443: accounting_rule_duration,
2444: last_update_date = sysdate,
2445: last_updated_by = arp_standard.profile.user_id,
2446: program_application_id = arp_standard.application_id,
2447: program_update_date = sysdate,
2448: program_id = arp_standard.profile.program_id
2449: where customer_trx_id = p_trx_id
2450: and autorule_complete_flag||'' = 'N'

Line 2448: program_id = arp_standard.profile.program_id

2444: last_update_date = sysdate,
2445: last_updated_by = arp_standard.profile.user_id,
2446: program_application_id = arp_standard.application_id,
2447: program_update_date = sysdate,
2448: program_id = arp_standard.profile.program_id
2449: where customer_trx_id = p_trx_id
2450: and autorule_complete_flag||'' = 'N'
2451: and (exists (select 'at least one distribution'
2452: from ra_cust_trx_line_gl_dist gl

Line 2468: arp_standard.debug(' rows updated: ' ||

2464:
2465: l_rows := sql%rowcount;
2466:
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));

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 2481: arp_standard.debug(SQLERRM);

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:
2485: RETURN( -1 );

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 2645: arp_standard.enable_debug;

2641: BEGIN
2642:
2643: IF (p_debug = 'Y')
2644: THEN
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()+ ' ||

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 2651: arp_standard.debug( 'debug = '|| p_debug ||', commit = ' || p_commit);

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);
2654: END IF;
2655:

Line 2652: arp_standard.debug( 'round = ' || p_suppress_round || ', continue on error = ' ||

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);
2654: END IF;
2655:
2656: -- 11i OE/OM change

Line 2661: arp_standard.debug( 'org_id = '|| to_char(org_id));

2657: -- fnd_profile.get( 'SO_ORGANIZATION_ID', org_id );
2658: oe_profile.get( 'SO_ORGANIZATION_ID', org_id );
2659:
2660: IF PG_DEBUG in ('Y', 'C') THEN
2661: arp_standard.debug( 'org_id = '|| to_char(org_id));
2662: END IF;
2663:
2664: stats.round := 0;
2665: stats.receivables := 0;

Line 2675: IF arp_standard.profile.request_id IS NULL

2671: /*-----------------------------------------------------------------------+
2672: | Validate each of the extended who columns |
2673: +-----------------------------------------------------------------------*/
2674:
2675: IF arp_standard.profile.request_id IS NULL
2676: THEN
2677: IF PG_DEBUG in ('Y', 'C') THEN
2678: arp_standard.debug('create_distributions(): NULL Request_id');
2679: END IF;

Line 2678: arp_standard.debug('create_distributions(): NULL Request_id');

2674:
2675: IF arp_standard.profile.request_id IS NULL
2676: THEN
2677: IF PG_DEBUG in ('Y', 'C') THEN
2678: arp_standard.debug('create_distributions(): NULL Request_id');
2679: END IF;
2680: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2681: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2682: 'PARAMETER', 'ARP_STANDARD.PROFILE.REQUEST_ID' );

Line 2680: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',

2676: THEN
2677: IF PG_DEBUG in ('Y', 'C') THEN
2678: arp_standard.debug('create_distributions(): NULL Request_id');
2679: END IF;
2680: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2681: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2682: 'PARAMETER', 'ARP_STANDARD.PROFILE.REQUEST_ID' );
2683: END IF;
2684:

Line 2682: 'PARAMETER', 'ARP_STANDARD.PROFILE.REQUEST_ID' );

2678: arp_standard.debug('create_distributions(): NULL Request_id');
2679: END IF;
2680: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2681: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2682: 'PARAMETER', 'ARP_STANDARD.PROFILE.REQUEST_ID' );
2683: END IF;
2684:
2685: IF arp_standard.profile.program_id IS NULL
2686: THEN

Line 2685: IF arp_standard.profile.program_id IS NULL

2681: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2682: 'PARAMETER', 'ARP_STANDARD.PROFILE.REQUEST_ID' );
2683: END IF;
2684:
2685: IF arp_standard.profile.program_id IS NULL
2686: THEN
2687: IF PG_DEBUG in ('Y', 'C') THEN
2688: arp_standard.debug('create_distributions(): NULL Program_id');
2689: END IF;

Line 2688: arp_standard.debug('create_distributions(): NULL Program_id');

2684:
2685: IF arp_standard.profile.program_id IS NULL
2686: THEN
2687: IF PG_DEBUG in ('Y', 'C') THEN
2688: arp_standard.debug('create_distributions(): NULL Program_id');
2689: END IF;
2690: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2691: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2692: 'PARAMETER', 'ARP_STANDARD.PROFILE.PROGRAM_ID' );

Line 2690: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',

2686: THEN
2687: IF PG_DEBUG in ('Y', 'C') THEN
2688: arp_standard.debug('create_distributions(): NULL Program_id');
2689: END IF;
2690: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2691: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2692: 'PARAMETER', 'ARP_STANDARD.PROFILE.PROGRAM_ID' );
2693: END IF;
2694:

Line 2692: 'PARAMETER', 'ARP_STANDARD.PROFILE.PROGRAM_ID' );

2688: arp_standard.debug('create_distributions(): NULL Program_id');
2689: END IF;
2690: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2691: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2692: 'PARAMETER', 'ARP_STANDARD.PROFILE.PROGRAM_ID' );
2693: END IF;
2694:
2695: IF arp_standard.profile.user_id IS NULL
2696: THEN

Line 2695: IF arp_standard.profile.user_id IS NULL

2691: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2692: 'PARAMETER', 'ARP_STANDARD.PROFILE.PROGRAM_ID' );
2693: END IF;
2694:
2695: IF arp_standard.profile.user_id IS NULL
2696: THEN
2697: IF PG_DEBUG in ('Y', 'C') THEN
2698: arp_standard.debug('create_distributions(): NULL User_id');
2699: END IF;

Line 2698: arp_standard.debug('create_distributions(): NULL User_id');

2694:
2695: IF arp_standard.profile.user_id IS NULL
2696: THEN
2697: IF PG_DEBUG in ('Y', 'C') THEN
2698: arp_standard.debug('create_distributions(): NULL User_id');
2699: END IF;
2700: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2701: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2702: 'PARAMETER', 'ARP_STANDARD.PROFILE.USER_ID' );

Line 2700: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',

2696: THEN
2697: IF PG_DEBUG in ('Y', 'C') THEN
2698: arp_standard.debug('create_distributions(): NULL User_id');
2699: END IF;
2700: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2701: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2702: 'PARAMETER', 'ARP_STANDARD.PROFILE.USER_ID' );
2703: END IF;
2704:

Line 2702: 'PARAMETER', 'ARP_STANDARD.PROFILE.USER_ID' );

2698: arp_standard.debug('create_distributions(): NULL User_id');
2699: END IF;
2700: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2701: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2702: 'PARAMETER', 'ARP_STANDARD.PROFILE.USER_ID' );
2703: END IF;
2704:
2705: IF arp_standard.application_id IS NULL
2706: THEN

Line 2705: IF arp_standard.application_id IS NULL

2701: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2702: 'PARAMETER', 'ARP_STANDARD.PROFILE.USER_ID' );
2703: END IF;
2704:
2705: IF arp_standard.application_id IS NULL
2706: THEN
2707: IF PG_DEBUG in ('Y', 'C') THEN
2708: arp_standard.debug('create_distributions(): NULL Program_app_id');
2709: END IF;

Line 2708: arp_standard.debug('create_distributions(): NULL Program_app_id');

2704:
2705: IF arp_standard.application_id IS NULL
2706: THEN
2707: IF PG_DEBUG in ('Y', 'C') THEN
2708: arp_standard.debug('create_distributions(): NULL Program_app_id');
2709: END IF;
2710: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2711: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2712: 'PARAMETER', 'ARP_STANDARD.APPLICATION_ID' );

Line 2710: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',

2706: THEN
2707: IF PG_DEBUG in ('Y', 'C') THEN
2708: arp_standard.debug('create_distributions(): NULL Program_app_id');
2709: END IF;
2710: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2711: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2712: 'PARAMETER', 'ARP_STANDARD.APPLICATION_ID' );
2713: END IF;
2714:

Line 2712: 'PARAMETER', 'ARP_STANDARD.APPLICATION_ID' );

2708: arp_standard.debug('create_distributions(): NULL Program_app_id');
2709: END IF;
2710: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2711: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2712: 'PARAMETER', 'ARP_STANDARD.APPLICATION_ID' );
2713: END IF;
2714:
2715: IF arp_standard.profile.last_update_login IS NULL
2716: THEN

Line 2715: IF arp_standard.profile.last_update_login IS NULL

2711: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2712: 'PARAMETER', 'ARP_STANDARD.APPLICATION_ID' );
2713: END IF;
2714:
2715: IF arp_standard.profile.last_update_login IS NULL
2716: THEN
2717: IF PG_DEBUG in ('Y', 'C') THEN
2718: arp_standard.debug('create_distributions(): NULL Last_update_login');
2719: END IF;

Line 2718: arp_standard.debug('create_distributions(): NULL Last_update_login');

2714:
2715: IF arp_standard.profile.last_update_login IS NULL
2716: THEN
2717: IF PG_DEBUG in ('Y', 'C') THEN
2718: arp_standard.debug('create_distributions(): NULL Last_update_login');
2719: END IF;
2720: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2721: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2722: 'PARAMETER', 'ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN' );

Line 2720: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',

2716: THEN
2717: IF PG_DEBUG in ('Y', 'C') THEN
2718: arp_standard.debug('create_distributions(): NULL Last_update_login');
2719: END IF;
2720: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2721: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2722: 'PARAMETER', 'ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN' );
2723: END IF;
2724:

Line 2722: 'PARAMETER', 'ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN' );

2718: arp_standard.debug('create_distributions(): NULL Last_update_login');
2719: END IF;
2720: arp_standard.fnd_message( 'AR_PP_NULL_PARAMETER',
2721: 'OBJECT', 'AUTO_RULE.CREATE_DISTRIBUTIONS',
2722: 'PARAMETER', 'ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN' );
2723: END IF;
2724:
2725: IF PG_DEBUG in ('Y', 'C') THEN
2726: arp_standard.debug('create_distributions(): Passed validation');

Line 2726: arp_standard.debug('create_distributions(): Passed validation');

2722: 'PARAMETER', 'ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN' );
2723: END IF;
2724:
2725: IF PG_DEBUG in ('Y', 'C') THEN
2726: arp_standard.debug('create_distributions(): Passed validation');
2727: END IF;
2728:
2729: /*---------------------------------------------------+
2730: | Get the period_set_name and currency information |

Line 2750: arp_standard.debug(

2746: gsb.set_of_books_id = asp.set_of_books_id
2747: AND fc.currency_code = gsb.currency_code;
2748:
2749: IF PG_DEBUG in ('Y', 'C') THEN
2750: arp_standard.debug(
2751: 'create_distributions(): '||
2752: ' Period Set: '|| period_set_name ||
2753: ' Base Precision: '|| base_precision ||
2754: ' Base Minimum Accountable Unit: ' ||

Line 2759: populate_glp_table(arp_standard.sysparm.set_of_books_id,

2755: NVL(base_min_acc_unit, 0));
2756: END IF;
2757:
2758: /* Populate the GL periods PL/SQL table. */
2759: populate_glp_table(arp_standard.sysparm.set_of_books_id,
2760: arp_standard.application_id);
2761:
2762: /* DEBUG INFO. */
2763: /* FOR i IN 1..rows LOOP

Line 2760: arp_standard.application_id);

2756: END IF;
2757:
2758: /* Populate the GL periods PL/SQL table. */
2759: populate_glp_table(arp_standard.sysparm.set_of_books_id,
2760: arp_standard.application_id);
2761:
2762: /* DEBUG INFO. */
2763: /* FOR i IN 1..rows LOOP
2764:

Line 2766: arp_standard.debug(

2762: /* DEBUG INFO. */
2763: /* FOR i IN 1..rows LOOP
2764:
2765: IF PG_DEBUG in ('Y', 'C') THEN
2766: arp_standard.debug(
2767: 'index = '||i||', '||
2768: TO_CHAR(gl_start_t(i), 'DD-MON-RRRR')||', '||
2769: TO_CHAR(gl_end_t(i), 'DD-MON-RRRR')||', '||
2770: gl_status_t(i)||', '||

Line 2784: arp_standard.debug('p_trx_id is NOT null, using subquery');

2780:
2781: IF (p_trx_id IS NOT NULL) THEN
2782: /* This is the modified logic using a sub-query - bug 2122202 */
2783: IF PG_DEBUG in ('Y', 'C') THEN
2784: arp_standard.debug('p_trx_id is NOT null, using subquery');
2785: END IF;
2786:
2787: OPEN c_trx;
2788: ELSE

Line 2791: arp_standard.debug('p_trx_id is null, using joined tables');

2787: OPEN c_trx;
2788: ELSE
2789: /* This is almost exactly like original select */
2790: IF PG_DEBUG in ('Y', 'C') THEN
2791: arp_standard.debug('p_trx_id is null, using joined tables');
2792: END IF;
2793:
2794: OPEN c_trx_no_id;
2795: END IF;

Line 2811: arp_standard.debug(

2807: EXIT WHEN c_trx_no_id%NOTFOUND;
2808: END IF;
2809:
2810: IF PG_DEBUG in ('Y', 'C') THEN
2811: arp_standard.debug(
2812: 'Creating distributions for trx_number = '|| trx_num);
2813: END IF;
2814:
2815: /*------------------------------------------------------------------+

Line 2817: | and receivable accounts as well as standard distributions |

2813: END IF;
2814:
2815: /*------------------------------------------------------------------+
2816: | Generate new account distributions, building plug, tax, freight |
2817: | and receivable accounts as well as standard distributions |
2818: +------------------------------------------------------------------*/
2819:
2820: trx_dist_created := 0;
2821:

Line 2998: arp_standard.debug( 'trx_id = '|| trx_id ||

2994: IF ( trx_dist_created > 0 )
2995: THEN
2996:
2997: IF PG_DEBUG in ('Y', 'C') THEN
2998: arp_standard.debug( 'trx_id = '|| trx_id ||
2999: ', distributions created = '|| trx_dist_created);
3000: END IF;
3001:
3002: stats.durations := update_durations(trx_id);

Line 3045: arp_standard.debug('create_distributions(): '|| error_message);

3041:
3042: ROLLBACK TO SAVEPOINT AR_AUTORULE_1;
3043:
3044: IF PG_DEBUG in ('Y', 'C') THEN
3045: arp_standard.debug('create_distributions(): '|| error_message);
3046: END IF;
3047:
3048: /* Bug 2399504 - added handler for p_continue_on_error */
3049: IF (p_continue_on_error IS NULL) THEN

Line 3051: arp_standard.fnd_message( 'GENERIC_MESSAGE',

3047:
3048: /* Bug 2399504 - added handler for p_continue_on_error */
3049: IF (p_continue_on_error IS NULL) THEN
3050: /* This FND_MESSAGE call halts execution of program */
3051: arp_standard.fnd_message( 'GENERIC_MESSAGE',
3052: 'GENERIC_TEXT', error_message);
3053: RETURN( -1 );
3054: ELSE
3055: return_warning := TRUE;

Line 3062: arp_standard.debug(

3058:
3059: ELSE
3060:
3061: IF PG_DEBUG in ('Y', 'C') THEN
3062: arp_standard.debug(
3063: 'Rounding errors corrected for: '||
3064: num_round_err_corr || ' rows.');
3065: END IF;
3066:

Line 3071: arp_standard.debug( 'ROUNDING SUPPRESSED!');

3067: END IF; /* rounding */
3068:
3069: ELSE
3070: IF PG_DEBUG in ('Y', 'C') THEN
3071: arp_standard.debug( 'ROUNDING SUPPRESSED!');
3072: END IF;
3073: END IF;
3074:
3075: /* All the distributions are created, rounding done, so we can

Line 3094: arp_standard.debug( 'trx_id = '|| trx_id ||

3090:
3091: ELSE
3092:
3093: IF PG_DEBUG in ('Y', 'C') THEN
3094: arp_standard.debug( 'trx_id = '|| trx_id ||
3095: ', distributions created = '|| trx_dist_created);
3096: END IF;
3097:
3098: END IF; /* if (trx_dist_created > 0) */

Line 3109: arp_standard.debug( 'create_distributions(): ' ||

3105:
3106: END LOOP; /* Cursor trx_id loop */
3107:
3108: IF PG_DEBUG in ('Y', 'C') THEN
3109: arp_standard.debug( 'create_distributions(): ' ||
3110: 'Total number of create_distributions created = '||
3111: TO_CHAR(NVL(sum_dist_created, 0)));
3112: END IF;
3113:

Line 3126: arp_standard.debug('Attempting to set WARNING return status');

3122: least one transaction that was processed by this (single thread)
3123: run. */
3124: IF (return_warning AND p_trx_id IS NULL)
3125: THEN
3126: arp_standard.debug('Attempting to set WARNING return status');
3127: error_message := FND_MESSAGE.GET_STRING('AR','ARBARL_WARN_BAD_TRX');
3128:
3129: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', error_message) = FALSE)
3130: THEN

Line 3131: arp_standard.debug('Unable to set WARNING return status');

3127: error_message := FND_MESSAGE.GET_STRING('AR','ARBARL_WARN_BAD_TRX');
3128:
3129: IF (FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', error_message) = FALSE)
3130: THEN
3131: arp_standard.debug('Unable to set WARNING return status');
3132: END IF;
3133: END IF;
3134:
3135: IF PG_DEBUG in ('Y', 'C') THEN

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) );