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.41 2012/03/12 10:56:53 dgaurab 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 81: arp_debug.debug( 'ar_match_rev_cogs_grp.period_status()+ ');

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

Line 111: arp_debug.debug( 'ar_match_rev_cogs_grp.period_status()- ');

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

Line 166: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()+ ');

162:
163: BEGIN
164:
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()+ ');
167: END IF;
168:
169: OPEN epm;
170: FETCH epm INTO l_eff_period_num, l_set_of_books_id;

Line 189: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()- ');

185:
186: --l_status := 'C';
187:
188: IF PG_DEBUG in ('Y', 'C') THEN
189: arp_debug.debug( 'ar_match_rev_cogs_grp.get_costing_period_status()- ');
190: END IF;
191:
192: RETURN l_status;
193:

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

336:
337: BEGIN
338:
339: IF PG_DEBUG in ('Y', 'C') THEN
340: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()+ ');
341: arp_debug.debug(' p_ledger_id = ' || p_ledger_id);
342: arp_debug.debug(' p_gl_date = ' || p_from_gl_date ||
343: ' to ' || p_to_gl_date);
344:

Line 728: DECODE(ar_match_rev_cogs_grp.potential_revenue(

724: SELECT
725: rev.so_line_id,
726: max(rev.latest_gl_date) gl_date,
727: gps.effective_period_num period_number,
728: DECODE(ar_match_rev_cogs_grp.potential_revenue(
729: rev.so_line_id,gps.effective_period_num),0,
730: DECODE(SUM(rev.revenue_line_amount),0,0,1),
731: DECODE(SUM(rev.revenue_dist_amount),0,0,
732: ROUND(SUM(rev.revenue_dist_amount) /

Line 733: ar_match_rev_cogs_grp.potential_revenue(rev.so_line_id,

729: rev.so_line_id,gps.effective_period_num),0,
730: DECODE(SUM(rev.revenue_line_amount),0,0,1),
731: DECODE(SUM(rev.revenue_dist_amount),0,0,
732: ROUND(SUM(rev.revenue_dist_amount) /
733: ar_match_rev_cogs_grp.potential_revenue(rev.so_line_id,
734: gps.effective_period_num),4)))
735: rev_percent,
736: max(rev.org_id) org_id,
737: gps.set_of_books_id set_of_books_id

Line 806: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');

802: , p_data => x_msg_data
803: );
804:
805: IF PG_DEBUG in ('Y', 'C') THEN
806: arp_debug.debug( 'ar_match_rev_cogs_grp.populate_cst_tables()- ');
807: END IF;
808:
809: EXCEPTION
810: WHEN fnd_api.g_exc_error THEN

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

827: IF (SQLCODE = -20001) THEN
828: ROLLBACK TO populate_cst_tables_grp;
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
832: FND_MSG_PUB.Add;
833:
834: fnd_msg_pub.count_and_get (
835: p_encoded => fnd_api.g_false,

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

838: RETURN;
839: ELSE
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
843: FND_MSG_PUB.Add;
844: END IF;
845:
846: IF PG_DEBUG in ('Y', 'C') THEN

Line 861: END ar_match_rev_cogs_grp;

857: END populate_cst_tables;
858:
859: BEGIN
860: g_om_context := NVL(fnd_profile.value('ONT_SOURCE_CODE'),'###NOT_SET###');
861: END ar_match_rev_cogs_grp;