APPS.AR_MATCH_REV_COGS_GRP dependencies on AR_MATCH_REV_COGS_GRP

Line 1: PACKAGE BODY ar_match_rev_cogs_grp AS

1: PACKAGE BODY ar_match_rev_cogs_grp AS
2: /* $Header: ARCGSRVB.pls 120.17.12010000.10 2008/11/05 14:22:39 mraymond ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'Y');
5:

Line 10: g_pkg_name CONSTANT VARCHAR2(30):= 'ar_match_rev_cogs_grp';

6: /*=======================================================================+
7: | Global Constants
8: +=======================================================================*/
9:
10: g_pkg_name CONSTANT VARCHAR2(30):= 'ar_match_rev_cogs_grp';
11: g_om_context ra_interface_lines.interface_line_context%type;
12:
13: g_so_line_id NUMBER := 0;
14: g_period_number NUMBER := 0;

Line 78: arp_util.debug( 'ar_match_rev_cogs_grp.period_status()+ ');

74:
75: BEGIN
76:
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_util.debug( 'ar_match_rev_cogs_grp.period_status()+ ');
79: END IF;
80:
81: -- Standard Start of API savepoint
82: SAVEPOINT period_status_grp;

Line 108: arp_util.debug( 'ar_match_rev_cogs_grp.period_status()- ');

104: FETCH status INTO x_status;
105: CLOSE status;
106:
107: IF PG_DEBUG in ('Y', 'C') THEN
108: arp_util.debug( 'ar_match_rev_cogs_grp.period_status()- ');
109: END IF;
110:
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN

Line 163: arp_util.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()+ ');

159:
160: BEGIN
161:
162: IF PG_DEBUG in ('Y', 'C') THEN
163: arp_util.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()+ ');
164: END IF;
165:
166: OPEN epm;
167: FETCH epm INTO l_eff_period_num, l_set_of_books_id;

Line 186: arp_util.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()- ');

182:
183: --l_status := 'C';
184:
185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()- ');
187: END IF;
188:
189: RETURN l_status;
190:

Line 266: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');

262:
263: BEGIN
264:
265: IF PG_DEBUG in ('Y', 'C') THEN
266: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');
267: arp_debug.debug(' p_ledger_id = ' || p_ledger_id);
268: arp_debug.debug(' p_gl_date = ' || p_from_gl_date ||
269: ' to ' || p_to_gl_date);
270:

Line 445: DECODE(ar_match_rev_cogs_grp.potential_revenue(

441: SELECT
442: rev.so_line_id,
443: max(rev.latest_gl_date) gl_date,
444: gps.effective_period_num period_number,
445: DECODE(ar_match_rev_cogs_grp.potential_revenue(
446: rev.so_line_id,gps.effective_period_num),0,1,
447: DECODE(SUM(rev.revenue_dist_amount),0,0,
448: ROUND(SUM(rev.revenue_dist_amount) /
449: ar_match_rev_cogs_grp.potential_revenue(rev.so_line_id,

Line 449: ar_match_rev_cogs_grp.potential_revenue(rev.so_line_id,

445: DECODE(ar_match_rev_cogs_grp.potential_revenue(
446: rev.so_line_id,gps.effective_period_num),0,1,
447: DECODE(SUM(rev.revenue_dist_amount),0,0,
448: ROUND(SUM(rev.revenue_dist_amount) /
449: ar_match_rev_cogs_grp.potential_revenue(rev.so_line_id,
450: gps.effective_period_num),4)))
451: rev_percent,
452: max(rev.org_id) org_id,
453: gps.set_of_books_id set_of_books_id

Line 516: arp_util.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');

512: , p_data => x_msg_data
513: );
514:
515: IF PG_DEBUG in ('Y', 'C') THEN
516: arp_util.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');
517: END IF;
518:
519: EXCEPTION
520: WHEN fnd_api.g_exc_error THEN

Line 541: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);

537: IF (SQLCODE = -20001) THEN
538: ROLLBACK TO populate_cst_tables_grp;
539: x_return_status := FND_API.G_RET_STS_ERROR ;
540: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
541: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
542: FND_MSG_PUB.Add;
543:
544: fnd_msg_pub.count_and_get (
545: p_encoded => fnd_api.g_false,

Line 552: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);

548: RETURN;
549: ELSE
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
551: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
552: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
553: FND_MSG_PUB.Add;
554: END IF;
555:
556: IF PG_DEBUG in ('Y', 'C') THEN

Line 571: END ar_match_rev_cogs_grp;

567: END populate_cst_tables;
568:
569: BEGIN
570: g_om_context := NVL(fnd_profile.value('ONT_SOURCE_CODE'),'###NOT_SET###');
571: END ar_match_rev_cogs_grp;