DBA Data[Home] [Help]

APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on STANDARD

Line 74: -- Standard Start of API savepoint

70: BEGIN
71: IF PG_DEBUG in ('Y', 'C') THEN
72: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
73: END IF;
74: -- Standard Start of API savepoint
75: SAVEPOINT Unearn_Revenue_PVT;
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
78: p_api_version ,

Line 76: -- Standard call to check for call compatibility.

72: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
73: END IF;
74: -- Standard Start of API savepoint
75: SAVEPOINT Unearn_Revenue_PVT;
76: -- Standard call to check for call compatibility.
77: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
78: p_api_version ,
79: l_api_name ,
80: G_PKG_NAME )

Line 118: -- Standard check of p_commit.

114: THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: -- Standard check of p_commit.
119: IF FND_API.To_Boolean( p_commit )
120: THEN
121: COMMIT WORK;
122: END IF;

Line 123: -- Standard call to get message count and if count is 1, get message info.

119: IF FND_API.To_Boolean( p_commit )
120: THEN
121: COMMIT WORK;
122: END IF;
123: -- Standard call to get message count and if count is 1, get message info.
124: FND_MSG_PUB.Count_And_Get
125: (p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data);

Line 228: -- Standard Start of API savepoint

224: BEGIN
225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
227: END IF;
228: -- Standard Start of API savepoint
229: SAVEPOINT Earn_Revenue_PVT;
230: -- Standard call to check for call compatibility.
231: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
232: p_api_version ,

Line 230: -- Standard call to check for call compatibility.

226: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
227: END IF;
228: -- Standard Start of API savepoint
229: SAVEPOINT Earn_Revenue_PVT;
230: -- Standard call to check for call compatibility.
231: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
232: p_api_version ,
233: l_api_name ,
234: G_PKG_NAME )

Line 271: -- Standard check of p_commit.

267: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
268: THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: END IF;
271: -- Standard check of p_commit.
272: IF FND_API.To_Boolean( p_commit )
273: THEN
274: COMMIT WORK;
275: END IF;

Line 276: -- Standard call to get message count and if count is 1, get message info.

272: IF FND_API.To_Boolean( p_commit )
273: THEN
274: COMMIT WORK;
275: END IF;
276: -- Standard call to get message count and if count is 1, get message info.
277: FND_MSG_PUB.Count_And_Get
278: (p_encoded => FND_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data);

Line 363: -- This procedure is an overlay of the standard Unearn_Revenue

359: -- Version : Current version 2.0
360: -- Initial version 1.0
361: --
362: -- Notes : AutoAccounting used for both debits and credits
363: -- This procedure is an overlay of the standard Unearn_Revenue
364: -- API which does not write out NOCOPY a revenue adjustment record or
365: -- entries into ra_cust_trx_line_gl_dist. Instead it outputs
366: -- the distributions to a pl/sql table which is passed out NOCOPY to
367: -- the calling routine

Line 1211: -- Standard Start of API savepoint

1207: BEGIN
1208: IF PG_DEBUG in ('Y', 'C') THEN
1209: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1210: END IF;
1211: -- Standard Start of API savepoint
1212: SAVEPOINT Transfer_Sales_Credits_PVT;
1213: -- Standard call to check for call compatibility.
1214: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1215: p_api_version ,

Line 1213: -- Standard call to check for call compatibility.

1209: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1210: END IF;
1211: -- Standard Start of API savepoint
1212: SAVEPOINT Transfer_Sales_Credits_PVT;
1213: -- Standard call to check for call compatibility.
1214: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1215: p_api_version ,
1216: l_api_name ,
1217: G_PKG_NAME )

Line 1923: -- Standard check of p_commit.

1919: --
1920: -- End of Inner Block
1921: --
1922:
1923: -- Standard check of p_commit.
1924: IF FND_API.To_Boolean( p_commit )
1925: THEN
1926: COMMIT WORK;
1927: END IF;

Line 1928: -- Standard call to get message count and if count is 1, get message info.

1924: IF FND_API.To_Boolean( p_commit )
1925: THEN
1926: COMMIT WORK;
1927: END IF;
1928: -- Standard call to get message count and if count is 1, get message info.
1929: FND_MSG_PUB.Count_And_Get
1930: (p_encoded => FND_API.G_FALSE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data);

Line 2139: -- Standard Start of API savepoint

2135:
2136: IF PG_DEBUG in ('Y', 'C') THEN
2137: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2138: END IF;
2139: -- Standard Start of API savepoint
2140: SAVEPOINT Add_Non_Rev_Sales_Credits_PVT;
2141: -- Standard call to check for call compatibility.
2142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2143: p_api_version ,

Line 2141: -- Standard call to check for call compatibility.

2137: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2138: END IF;
2139: -- Standard Start of API savepoint
2140: SAVEPOINT Add_Non_Rev_Sales_Credits_PVT;
2141: -- Standard call to check for call compatibility.
2142: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2143: p_api_version ,
2144: l_api_name ,
2145: G_PKG_NAME )

Line 2338: -- Standard check of p_commit.

2334: --
2335: -- End of Inner Block
2336: --
2337:
2338: -- Standard check of p_commit.
2339: IF FND_API.To_Boolean( p_commit )
2340: THEN
2341: COMMIT WORK;
2342: END IF;

Line 2343: -- Standard call to get message count and if count is 1, get message info.

2339: IF FND_API.To_Boolean( p_commit )
2340: THEN
2341: COMMIT WORK;
2342: END IF;
2343: -- Standard call to get message count and if count is 1, get message info.
2344: FND_MSG_PUB.Count_And_Get
2345: (p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data);

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

2776: SELECT /*+ ORDERED push_pred(ra.lgd) index(dist ra_cust_trx_line_gl_dist_n1)*/
2777: ra.customer_trx_line_id, /* customer_trx_line_id */
2778: l.customer_trx_id, /* customer_trx_id */
2779: dist.code_combination_id, /* code_combination_id */
2780: arp_standard.sysparm.set_of_books_id, /* set_of_books_id */
2781: ra.account_class, /* account_class */
2782: 'N', /* account_set_flag */
2783: ROUND((((ra.amount * dist.percent
2784: * p_revenue_amount)

Line 2812: arp_standard.profile.request_id,

2808: * g_bmau)), /* Acctd_amount */
2809: DECODE(l.accounting_rule_duration, 1, p_gl_date,
2810: arp_auto_rule.assign_gl_date(ra.gl_date)),/* Derived gl_date */
2811: dist.cust_trx_line_salesrep_id, /* Srep ID */
2812: arp_standard.profile.request_id,
2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,

Line 2813: arp_standard.application_id,

2809: DECODE(l.accounting_rule_duration, 1, p_gl_date,
2810: arp_auto_rule.assign_gl_date(ra.gl_date)),/* Derived gl_date */
2811: dist.cust_trx_line_salesrep_id, /* Srep ID */
2812: arp_standard.profile.request_id,
2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,

Line 2814: arp_standard.profile.program_id,

2810: arp_auto_rule.assign_gl_date(ra.gl_date)),/* Derived gl_date */
2811: dist.cust_trx_line_salesrep_id, /* Srep ID */
2812: arp_standard.profile.request_id,
2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,
2818: sysdate,

Line 2817: arp_standard.profile.user_id,

2813: arp_standard.application_id,
2814: arp_standard.profile.program_id,
2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,
2818: sysdate,
2819: arp_standard.profile.user_id,
2820: -3,
2821: ra.gl_date, /* original_gl_date */

Line 2819: arp_standard.profile.user_id,

2815: sysdate,
2816: sysdate,
2817: arp_standard.profile.user_id,
2818: sysdate,
2819: arp_standard.profile.user_id,
2820: -3,
2821: ra.gl_date, /* original_gl_date */
2822: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
2823: p_adjustment_id,

Line 2825: arp_standard.sysparm.org_id

2821: ra.gl_date, /* original_gl_date */
2822: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
2823: p_adjustment_id,
2824: p_user_generated_flag,
2825: arp_standard.sysparm.org_id
2826: FROM
2827: ra_customer_trx_lines l,
2828: ra_customer_trx h,
2829: fnd_currencies fc,

Line 2848: arp_standard.debug('Total lines inserted: ' || rows);

2844: rows := sql%rowcount;
2845:
2846:
2847: IF PG_DEBUG in ('Y', 'C') THEN
2848: arp_standard.debug('Total lines inserted: ' || rows);
2849: END IF;
2850:
2851: /* Note: rounding will be handled at the transaction level
2852: in a call to arp_rounding.correct_rev_adj_by_line */

Line 4157: -- Standard Start of API savepoint

4153: BEGIN
4154: IF PG_DEBUG in ('Y', 'C') THEN
4155: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4156: END IF;
4157: -- Standard Start of API savepoint
4158: SAVEPOINT Transfer_Rev_Between_Lines_PVT;
4159: -- Standard call to check for call compatibility.
4160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4161: p_api_version ,

Line 4159: -- Standard call to check for call compatibility.

4155: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4156: END IF;
4157: -- Standard Start of API savepoint
4158: SAVEPOINT Transfer_Rev_Between_Lines_PVT;
4159: -- Standard call to check for call compatibility.
4160: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4161: p_api_version ,
4162: l_api_name ,
4163: G_PKG_NAME )

Line 4439: -- Standard check of p_commit.

4435: --
4436: -- End of Inner Block
4437: --
4438:
4439: -- Standard check of p_commit.
4440: IF FND_API.To_Boolean( p_commit )
4441: THEN
4442: COMMIT WORK;
4443: END IF;

Line 4444: -- Standard call to get message count and if count is 1, get message info.

4440: IF FND_API.To_Boolean( p_commit )
4441: THEN
4442: COMMIT WORK;
4443: END IF;
4444: -- Standard call to get message count and if count is 1, get message info.
4445: FND_MSG_PUB.Count_And_Get
4446: (p_encoded => FND_API.G_FALSE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data);

Line 4700: ,arp_standard.sysparm.org_id ); -- Bug 4607673

4696: ,SYSDATE
4697: ,FND_GLOBAL.user_id
4698: ,SYSDATE
4699: ,FND_GLOBAL.user_id
4700: ,arp_standard.sysparm.org_id ); -- Bug 4607673
4701: IF PG_DEBUG in ('Y', 'C') THEN
4702: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()-');
4703: END IF;
4704:

Line 5034: ,arp_standard.sysparm.org_id

5030: ,p_acctd_amount
5031: ,-3
5032: ,p_adjustment_id
5033: ,p_user_generated_flag
5034: ,arp_standard.sysparm.org_id
5035: ,p_rounding_flag); -- Bug 4607673
5036:
5037: --{BUG#5064609 call XLA event
5038: OPEN cu_trx;

Line 5186: ,arp_standard.sysparm.org_id);

5182: ,DECODE(p_type,'N',p_amount,NULL)
5183: ,DECODE(p_type,'R',p_percent,NULL)
5184: ,DECODE(p_type,'N',p_percent,NULL)
5185: ,p_adjustment_id
5186: ,arp_standard.sysparm.org_id);
5187:
5188: IF PG_DEBUG in ('Y', 'C') THEN
5189: arp_util.debug(' Inserted salescredit row w/ ID = ' ||
5190: p_sales_credit_id);

Line 5304: arp_standard.sysparm.set_of_books_id,

5300: VALUES
5301: ( p_cust_trx_line_id,
5302: p_customer_trx_id,
5303: l_ccid,
5304: arp_standard.sysparm.set_of_books_id,
5305: l_account_class,
5306: 'Y',
5307: p_percent,
5308: NULL,

Line 5312: arp_standard.profile.request_id,

5308: NULL,
5309: NULL,
5310: NULL,
5311: p_sales_credit_id,
5312: arp_standard.profile.request_id,
5313: arp_standard.application_id,
5314: arp_standard.profile.program_id,
5315: sysdate,
5316: sysdate,

Line 5313: arp_standard.application_id,

5309: NULL,
5310: NULL,
5311: p_sales_credit_id,
5312: arp_standard.profile.request_id,
5313: arp_standard.application_id,
5314: arp_standard.profile.program_id,
5315: sysdate,
5316: sysdate,
5317: l_user_id,

Line 5314: arp_standard.profile.program_id,

5310: NULL,
5311: p_sales_credit_id,
5312: arp_standard.profile.request_id,
5313: arp_standard.application_id,
5314: arp_standard.profile.program_id,
5315: sysdate,
5316: sysdate,
5317: l_user_id,
5318: sysdate,

Line 5325: arp_standard.sysparm.org_id

5321: NULL,
5322: l_gl_dist_id,
5323: p_adjustment_id,
5324: 'Y',
5325: arp_standard.sysparm.org_id
5326: );
5327:
5328: IF PG_DEBUG in ('Y', 'C') THEN
5329: arp_util.debug(' Inserted ' || l_account_class ||