141: p_RunningTotalAcctdAmount := p_RunningTotalAcctdAmount + l_AcctdChildAmount;
142: RETURN l_AcctdChildAmount;
143: EXCEPTION
144: WHEN OTHERS THEN
145: arp_standard.debug( 'arpcurr.ReconcileAcctdAmounts: $Revision: 120.9.12010000.2 $' );
146: arp_standard.debug( 'l_AcctdChildAmount:'||l_AcctdChildAmount );
147: RAISE;
148: END;
149:
142: RETURN l_AcctdChildAmount;
143: EXCEPTION
144: WHEN OTHERS THEN
145: arp_standard.debug( 'arpcurr.ReconcileAcctdAmounts: $Revision: 120.9.12010000.2 $' );
146: arp_standard.debug( 'l_AcctdChildAmount:'||l_AcctdChildAmount );
147: RAISE;
148: END;
149:
150:
353: | If not found above then get it from gl_currency_api.get_rate |
354: +----------------------------------------------------------------*/
355:
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_standard.debug('arpcurr.getrate');
358: arp_standard.debug('GetRate: ' || 'p_from_curr_code' || p_from_curr_code);
359: arp_standard.debug('GetRate: ' || 'p_to_curr_code' || p_to_curr_code);
360: arp_standard.debug('GetRate: ' || 'date ' || to_char(p_conversion_date));
361: arp_standard.debug('GetRate: ' || 'type = ' || p_conversion_type);
354: +----------------------------------------------------------------*/
355:
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_standard.debug('arpcurr.getrate');
358: arp_standard.debug('GetRate: ' || 'p_from_curr_code' || p_from_curr_code);
359: arp_standard.debug('GetRate: ' || 'p_to_curr_code' || p_to_curr_code);
360: arp_standard.debug('GetRate: ' || 'date ' || to_char(p_conversion_date));
361: arp_standard.debug('GetRate: ' || 'type = ' || p_conversion_type);
362: END IF;
355:
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_standard.debug('arpcurr.getrate');
358: arp_standard.debug('GetRate: ' || 'p_from_curr_code' || p_from_curr_code);
359: arp_standard.debug('GetRate: ' || 'p_to_curr_code' || p_to_curr_code);
360: arp_standard.debug('GetRate: ' || 'date ' || to_char(p_conversion_date));
361: arp_standard.debug('GetRate: ' || 'type = ' || p_conversion_type);
362: END IF;
363:
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_standard.debug('arpcurr.getrate');
358: arp_standard.debug('GetRate: ' || 'p_from_curr_code' || p_from_curr_code);
359: arp_standard.debug('GetRate: ' || 'p_to_curr_code' || p_to_curr_code);
360: arp_standard.debug('GetRate: ' || 'date ' || to_char(p_conversion_date));
361: arp_standard.debug('GetRate: ' || 'type = ' || p_conversion_type);
362: END IF;
363:
364: IF (p_from_curr_code IS NOT NULL AND
357: arp_standard.debug('arpcurr.getrate');
358: arp_standard.debug('GetRate: ' || 'p_from_curr_code' || p_from_curr_code);
359: arp_standard.debug('GetRate: ' || 'p_to_curr_code' || p_to_curr_code);
360: arp_standard.debug('GetRate: ' || 'date ' || to_char(p_conversion_date));
361: arp_standard.debug('GetRate: ' || 'type = ' || p_conversion_type);
362: END IF;
363:
364: IF (p_from_curr_code IS NOT NULL AND
365: p_to_curr_code IS NOT NULL AND
396: ELSE
397: l_user_conversion_rate := gl_currency_api.get_rate(p_from_curr_code,p_to_curr_code,p_conversion_date,p_conversion_type);
398:
399: IF PG_DEBUG in ('Y', 'C') THEN
400: arp_standard.debug('GetRate: ' || 'after call to gl_currency_api');
401: END IF;
402: IF pg_getrate_hash_seg_cache.exists(l_hash_value) then
403: tab_size := tab_size + 1;
404: pg_getrate_line_id_cache(tab_size) := l_user_conversion_rate;
437: return 'Y';
438: END IF;
439: EXCEPTION
440: WHEN GL_CURRENCY_API.NO_RATE THEN
441: arp_standard.debug('EXCEPTION: No Rate Exception In arpcurr.rateexists()');
442: return 'N';
443: WHEN OTHERS THEN
444: arp_standard.debug('EXCEPTION: Others Exception In arpcurr.rateexists()');
445: arp_standard.debug('EXCEPTION: '||SQLERRM);
440: WHEN GL_CURRENCY_API.NO_RATE THEN
441: arp_standard.debug('EXCEPTION: No Rate Exception In arpcurr.rateexists()');
442: return 'N';
443: WHEN OTHERS THEN
444: arp_standard.debug('EXCEPTION: Others Exception In arpcurr.rateexists()');
445: arp_standard.debug('EXCEPTION: '||SQLERRM);
446: RETURN 'N' ;
447: END RateExists;
448:
441: arp_standard.debug('EXCEPTION: No Rate Exception In arpcurr.rateexists()');
442: return 'N';
443: WHEN OTHERS THEN
444: arp_standard.debug('EXCEPTION: Others Exception In arpcurr.rateexists()');
445: arp_standard.debug('EXCEPTION: '||SQLERRM);
446: RETURN 'N' ;
447: END RateExists;
448:
449:
507: gl_sets_of_books sob
508: WHERE sob.set_of_books_id = sp.set_of_books_id;
509: EXCEPTION
510: WHEN OTHERS THEN
511: arp_standard.debug( 'arpcurr.constructor' );
512: RAISE;
513: END init;
514:
515: /* 5885313 - call init in constructor code */