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.AR_REVENUE_ADJUSTMENT_PVT dependencies on AR_REVENUE_ADJUSTMENT_PVT

Line 1: PACKAGE BODY AR_Revenue_Adjustment_PVT AS

1: PACKAGE BODY AR_Revenue_Adjustment_PVT AS
2: /*$Header: ARXVRADB.pls 120.60.12020000.3 2012/10/18 05:36:28 naneja ship $*/
3:
4: /*=======================================================================+
5: | Global Constants

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AR_Revenue_Adjustment_PVT';

18: g_memo_line_id NUMBER;
19: g_inventory_item_id NUMBER;
20: g_line_id NUMBER;
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AR_Revenue_Adjustment_PVT';
23:
24: -----------------------------------------------------------------------
25: -- API name : Unearn_Revenue
26: -- Type : Private

Line 68: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

64: ,x_adjustment_number OUT NOCOPY VARCHAR2)
65: IS
66: l_api_name CONSTANT VARCHAR2(30) := 'Unearn_Revenue';
67: l_api_version CONSTANT NUMBER := 2.0;
68: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
69:
70: BEGIN
71: IF PG_DEBUG in ('Y', 'C') THEN
72: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

Line 72: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

68: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
69:
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.

Line 84: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

80: G_PKG_NAME )
81: THEN
82: IF PG_DEBUG in ('Y', 'C') THEN
83: arp_util.debug('Unearn_Revenue: ' || '.Unexpected error '||sqlerrm||
84: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
85: END IF;
86: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
87: END IF;
88: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 102: AR_Revenue_Adjustment_PVT.earn_or_unearn

98: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/
99: l_rev_adj_rec.gl_date := trunc(p_rev_adj_rec.gl_date);
100:
101: l_rev_adj_rec.adjustment_type := 'UN';
102: AR_Revenue_Adjustment_PVT.earn_or_unearn
103: (p_rev_adj_rec => l_rev_adj_rec
104: ,p_validation_level => p_validation_level
105: ,x_return_status => x_return_status
106: ,x_msg_count => x_msg_count

Line 129: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()-');

125: (p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data);
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('AR_Revenue_Adjustment_PVT.Unearn_Revenue()-');
130: END IF;
131: EXCEPTION
132: WHEN FND_API.G_EXC_ERROR THEN
133: ROLLBACK TO Unearn_Revenue_PVT;

Line 142: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

138: p_data => x_msg_data);
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: IF PG_DEBUG in ('Y', 'C') THEN
141: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
142: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
143: END IF;
144: ROLLBACK TO Unearn_Revenue_PVT;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: FND_MSG_PUB.Count_And_Get

Line 155: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

151: IF (SQLCODE = -20001)
152: THEN
153: IF PG_DEBUG in ('Y', 'C') THEN
154: arp_util.debug('Unearn_Revenue: ' || '20001 error '||
155: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
156: END IF;
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: ELSE
159: IF PG_DEBUG in ('Y', 'C') THEN

Line 161: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');

157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: ELSE
159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||
161: ' at AR_Revenue_Adjustment_PVT.Unearn_Revenue()+');
162: END IF;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: IF FND_MSG_PUB.Check_Msg_Level
165: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 222: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

218: ,x_adjustment_number OUT NOCOPY VARCHAR2)
219: IS
220: l_api_name CONSTANT VARCHAR2(30) := 'Earn_Revenue';
221: l_api_version CONSTANT NUMBER := 2.0;
222: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
223:
224: BEGIN
225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

Line 226: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

222: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
223:
224: BEGIN
225: IF PG_DEBUG in ('Y', 'C') THEN
226: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
227: arp_util.debug(' p_rev_adj_rec.sales_credit_type = ' ||
228: p_rev_adj_rec.sales_credit_type);
229: END IF;
230: -- Standard Start of API savepoint

Line 240: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

236: G_PKG_NAME )
237: THEN
238: IF PG_DEBUG in ('Y', 'C') THEN
239: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
240: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
241: END IF;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;
244: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 258: AR_Revenue_Adjustment_PVT.earn_or_unearn

254: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/
255: l_rev_adj_rec.gl_date := trunc(p_rev_adj_rec.gl_date);
256:
257: l_rev_adj_rec.adjustment_type := 'EA';
258: AR_Revenue_Adjustment_PVT.earn_or_unearn
259: (p_rev_adj_rec => l_rev_adj_rec
260: ,p_validation_level => p_validation_level
261: ,x_return_status => x_return_status
262: ,x_msg_count => x_msg_count

Line 284: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()-');

280: (p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,
282: p_data => x_msg_data);
283: IF PG_DEBUG in ('Y', 'C') THEN
284: arp_util.debug('AR_Revenue_Adjustment_PVT.Earn_Revenue()-');
285: END IF;
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO Earn_Revenue_PVT;

Line 297: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

293: p_data => x_msg_data);
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: IF PG_DEBUG in ('Y', 'C') THEN
296: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
297: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
298: END IF;
299: ROLLBACK TO Earn_Revenue_PVT;
300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
301: FND_MSG_PUB.Count_And_Get

Line 310: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

306: IF (SQLCODE = -20001)
307: THEN
308: IF PG_DEBUG in ('Y', 'C') THEN
309: arp_util.debug('Earn_Revenue: ' || '20001 error '||
310: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
311: END IF;
312: x_return_status := FND_API.G_RET_STS_ERROR ;
313: ELSE
314: IF PG_DEBUG in ('Y', 'C') THEN

Line 316: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');

312: x_return_status := FND_API.G_RET_STS_ERROR ;
313: ELSE
314: IF PG_DEBUG in ('Y', 'C') THEN
315: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
316: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
317: END IF;
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319: IF FND_MSG_PUB.Check_Msg_Level
320: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 388: arp_util.debug('AR_Revenue_Adjustment_PVT.(OVERLOADED)Earn_Revenue()+');

384: IS
385:
386: BEGIN
387: IF PG_DEBUG in ('Y', 'C') THEN
388: arp_util.debug('AR_Revenue_Adjustment_PVT.(OVERLOADED)Earn_Revenue()+');
389: END IF;
390:
391: --initialize the global gl distributions table
392: g_ra_dist_tbl := g_ra_empty_dist_tbl ;

Line 420: arp_util.debug('AR_Revenue_Adjustment_PVT.(OVERLOADED)Earn_Revenue()-');

416: --for all other calls to the API
417: g_update_db_flag := 'Y';
418:
419: IF PG_DEBUG in ('Y', 'C') THEN
420: arp_util.debug('AR_Revenue_Adjustment_PVT.(OVERLOADED)Earn_Revenue()-');
421: END IF;
422: END Earn_Revenue;
423:
424: PROCEDURE earn_or_unearn

Line 433: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

429: ,x_msg_data OUT NOCOPY VARCHAR2
430: ,x_adjustment_id OUT NOCOPY NUMBER
431: ,x_adjustment_number OUT NOCOPY VARCHAR2)
432: IS
433: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
434: l_line_id NUMBER;
435: l_line_amount NUMBER;
436: l_line_acctd_amount NUMBER;
437: l_cm_line_amount NUMBER;

Line 515: arp_util.debug('AR_Revenue_Adjustment_PVT.earn_or_unearn()+');

511:
512:
513: BEGIN
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_util.debug('AR_Revenue_Adjustment_PVT.earn_or_unearn()+');
516: arp_util.debug(' p_rev_adj_rec.sales_credit_type = ' ||
517: p_rev_adj_rec.sales_credit_type);
518: END IF;
519: l_rev_adj_rec := p_rev_adj_rec;

Line 898: arp_util.debug('AR_Revenue_Adjustment_PVT.earn_or_unearn()-');

894: END IF;
895:
896: END IF;
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_util.debug('AR_Revenue_Adjustment_PVT.earn_or_unearn()-');
899: END IF;
900:
901: EXCEPTION
902:

Line 908: ('20001 error at AR_Revenue_Adjustment_PVT.earn_or_unearn');

904: IF (SQLCODE = -20001)
905: THEN
906: IF PG_DEBUG in ('Y', 'C') THEN
907: arp_util.debug
908: ('20001 error at AR_Revenue_Adjustment_PVT.earn_or_unearn');
909: END IF;
910: RAISE FND_API.G_EXC_ERROR;
911: ELSE
912: IF PG_DEBUG in ('Y', 'C') THEN

Line 914: ' at AR_Revenue_Adjustment_PVT.earn_or_unearn()+');

910: RAISE FND_API.G_EXC_ERROR;
911: ELSE
912: IF PG_DEBUG in ('Y', 'C') THEN
913: arp_util.debug('earn_or_unearn: ' || 'Unexpected error '||sqlerrm||
914: ' at AR_Revenue_Adjustment_PVT.earn_or_unearn()+');
915: END IF;
916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
917: END IF;
918: END earn_or_unearn;

Line 965: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

961: ,x_adjustment_number OUT NOCOPY VARCHAR2)
962: IS
963: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Sales_Credits';
964: l_api_version CONSTANT NUMBER := 2.0;
965: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
966:
967: l_trx_total NUMBER := 0;
968: l_line_count NUMBER := 0;
969: l_salesrep_count NUMBER := 0;

Line 1286: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

1282: WHERE salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id;
1283:
1284: BEGIN
1285: IF PG_DEBUG in ('Y', 'C') THEN
1286: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1287: END IF;
1288: -- Standard Start of API savepoint
1289: SAVEPOINT Transfer_Sales_Credits_PVT;
1290: -- Standard call to check for call compatibility.

Line 1298: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

1294: G_PKG_NAME )
1295: THEN
1296: IF PG_DEBUG in ('Y', 'C') THEN
1297: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1298: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1299: END IF;
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;
1302: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1335: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits(2)+');

1331: -- Inner PL/SQL Block to optimize error handling
1332: --
1333: BEGIN
1334: IF PG_DEBUG in ('Y', 'C') THEN
1335: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits(2)+');
1336: END IF;
1337:
1338: l_revenue_amount := 0;
1339: l_nonrev_amount := 0;

Line 1985: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()');

1981: IF (SQLCODE = -20001)
1982: THEN
1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: arp_util.debug
1985: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()');
1986: END IF;
1987: RAISE FND_API.G_EXC_ERROR;
1988: ELSE
1989: IF PG_DEBUG in ('Y', 'C') THEN

Line 1991: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

1987: RAISE FND_API.G_EXC_ERROR;
1988: ELSE
1989: IF PG_DEBUG in ('Y', 'C') THEN
1990: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1991: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1992: END IF;
1993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1994: END IF;
1995: END;

Line 2011: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()-');

2007: (p_encoded => FND_API.G_FALSE,
2008: p_count => x_msg_count,
2009: p_data => x_msg_data);
2010: IF PG_DEBUG in ('Y', 'C') THEN
2011: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()-');
2012: END IF;
2013: EXCEPTION
2014: WHEN FND_API.G_EXC_ERROR THEN
2015: ROLLBACK TO Transfer_Sales_Credits_PVT;

Line 2024: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

2020: p_data => x_msg_data);
2021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2022: IF PG_DEBUG in ('Y', 'C') THEN
2023: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2024: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
2025: END IF;
2026: ROLLBACK TO Transfer_Sales_Credits_PVT;
2027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: FND_MSG_PUB.Count_And_Get

Line 2037: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

2033: IF (SQLCODE = -20001)
2034: THEN
2035: IF PG_DEBUG in ('Y', 'C') THEN
2036: arp_util.debug('Transfer_Sales_Credits: ' || '20001 error '||
2037: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
2038: END IF;
2039: x_return_status := FND_API.G_RET_STS_ERROR ;
2040: ELSE
2041: IF PG_DEBUG in ('Y', 'C') THEN

Line 2043: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');

2039: x_return_status := FND_API.G_RET_STS_ERROR ;
2040: ELSE
2041: IF PG_DEBUG in ('Y', 'C') THEN
2042: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2043: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
2044: END IF;
2045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2046: IF FND_MSG_PUB.Check_Msg_Level
2047: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2109: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

2105: IS
2106: l_api_name CONSTANT VARCHAR2(30) :=
2107: 'Add_Non_Revenue_Sales_Credits';
2108: l_api_version CONSTANT NUMBER := 2.0;
2109: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
2110:
2111: l_trx_total NUMBER;
2112: l_line_count NUMBER;
2113: l_no_of_lines NUMBER;

Line 2214: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

2210:
2211: BEGIN
2212:
2213: IF PG_DEBUG in ('Y', 'C') THEN
2214: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2215: END IF;
2216: -- Standard Start of API savepoint
2217: SAVEPOINT Add_Non_Rev_Sales_Credits_PVT;
2218: -- Standard call to check for call compatibility.

Line 2226: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

2222: G_PKG_NAME )
2223: THEN
2224: IF PG_DEBUG in ('Y', 'C') THEN
2225: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2226: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2227: END IF;
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2263: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits(2)+');

2259: -- Inner PL/SQL block to ensure consistent error handling
2260: --
2261: BEGIN
2262: IF PG_DEBUG in ('Y', 'C') THEN
2263: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits(2)+');
2264: END IF;
2265: l_amount := 0;
2266: l_line_count := 0;
2267: l_total_adjusted := 0;

Line 2399: ('20001 error at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()');

2395: IF (SQLCODE = -20001)
2396: THEN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug
2399: ('20001 error at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()');
2400: END IF;
2401: RAISE FND_API.G_EXC_ERROR;
2402: ELSE
2403: IF PG_DEBUG in ('Y', 'C') THEN

Line 2405: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

2401: RAISE FND_API.G_EXC_ERROR;
2402: ELSE
2403: IF PG_DEBUG in ('Y', 'C') THEN
2404: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2405: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2406: END IF;
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: END IF;
2409:

Line 2426: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()-');

2422: (p_encoded => FND_API.G_FALSE,
2423: p_count => x_msg_count,
2424: p_data => x_msg_data);
2425: IF PG_DEBUG in ('Y', 'C') THEN
2426: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()-');
2427: END IF;
2428: EXCEPTION
2429: WHEN FND_API.G_EXC_ERROR THEN
2430: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;

Line 2439: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

2435: p_data => x_msg_data);
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: IF PG_DEBUG in ('Y', 'C') THEN
2438: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2439: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2440: END IF;
2441: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2443: FND_MSG_PUB.Count_And_Get

Line 2452: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

2448: IF (SQLCODE = -20001)
2449: THEN
2450: IF PG_DEBUG in ('Y', 'C') THEN
2451: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || '20001 error '||
2452: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2453: END IF;
2454: x_return_status := FND_API.G_RET_STS_ERROR ;
2455: ELSE
2456: IF PG_DEBUG in ('Y', 'C') THEN

Line 2458: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');

2454: x_return_status := FND_API.G_RET_STS_ERROR ;
2455: ELSE
2456: IF PG_DEBUG in ('Y', 'C') THEN
2457: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2458: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2459: END IF;
2460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2461: IF FND_MSG_PUB.Check_Msg_Level
2462: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2558: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');

2554: AND l.line_type = 'LINE';
2555:
2556: BEGIN
2557: IF PG_DEBUG in ('Y', 'C') THEN
2558: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2559: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2560: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

Line 2734: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()-');

2730: END IF;
2731:
2732: END LOOP; -- assignments loop
2733: IF PG_DEBUG in ('Y', 'C') THEN
2734: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()-');
2735: END IF;
2736:
2737: EXCEPTION
2738:

Line 2744: ('20001 error at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()');

2740: IF (SQLCODE = -20001)
2741: THEN
2742: IF PG_DEBUG in ('Y', 'C') THEN
2743: arp_util.debug
2744: ('20001 error at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()');
2745: END IF;
2746: RAISE FND_API.G_EXC_ERROR;
2747: ELSE
2748: IF PG_DEBUG in ('Y', 'C') THEN

Line 2750: ' at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');

2746: RAISE FND_API.G_EXC_ERROR;
2747: ELSE
2748: IF PG_DEBUG in ('Y', 'C') THEN
2749: arp_util.debug('transfer_salesrep_revenue: ' || 'Unexpected error '||sqlerrm||
2750: ' at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2751: END IF;
2752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2753: END IF;
2754:

Line 2868: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model()+');

2864:
2865: BEGIN
2866: IF PG_DEBUG in ('Y', 'C')
2867: THEN
2868: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model()+');
2869: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
2870: END IF;
2871:
2872: /* Initialize globals for this package */

Line 2950: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() ra.ccid' || rec.code_combination_id);

2946: end if;
2947:
2948: IF PG_DEBUG in ('Y', 'C')
2949: THEN
2950: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() ra.ccid' || rec.code_combination_id);
2951: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() final ccid' || l_ccid);
2952: END IF;
2953:
2954: INSERT INTO ra_cust_trx_line_gl_dist

Line 2951: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() final ccid' || l_ccid);

2947:
2948: IF PG_DEBUG in ('Y', 'C')
2949: THEN
2950: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() ra.ccid' || rec.code_combination_id);
2951: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model() final ccid' || l_ccid);
2952: END IF;
2953:
2954: INSERT INTO ra_cust_trx_line_gl_dist
2955: (

Line 3032: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model()+');

3028: END IF;
3029:
3030: IF PG_DEBUG in ('Y', 'C') THEN
3031: arp_util.debug('Total lines inserted: ' || rows);
3032: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model()+');
3033: END IF;
3034:
3035: /* Note: rounding will be handled at the transaction level
3036: in a call to arp_rounding.correct_rev_adj_by_line */

Line 3163: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()+');

3159:
3160: BEGIN
3161:
3162: IF PG_DEBUG in ('Y', 'C') THEN
3163: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()+');
3164: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3165: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3166: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3167: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

Line 3467: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()-');

3463: END LOOP; -- assignments loop
3464:
3465: END LOOP; -- sales credit loop
3466: IF PG_DEBUG in ('Y', 'C') THEN
3467: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()-');
3468: END IF;
3469:
3470: EXCEPTION
3471:

Line 3490: ('20001 error at AR_Revenue_Adjustment_PVT.debit_credit()');

3486: IF (SQLCODE = -20001)
3487: THEN
3488: IF PG_DEBUG in ('Y', 'C') THEN
3489: arp_util.debug
3490: ('20001 error at AR_Revenue_Adjustment_PVT.debit_credit()');
3491: END IF;
3492: RAISE FND_API.G_EXC_ERROR;
3493: ELSE
3494: IF PG_DEBUG in ('Y', 'C') THEN

Line 3496: ' at AR_Revenue_Adjustment_PVT.debit_credit()+');

3492: RAISE FND_API.G_EXC_ERROR;
3493: ELSE
3494: IF PG_DEBUG in ('Y', 'C') THEN
3495: arp_util.debug('debit_credit: ' || 'Unexpected error '||sqlerrm||
3496: ' at AR_Revenue_Adjustment_PVT.debit_credit()+');
3497: END IF;
3498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3499: END IF;
3500:

Line 3592: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');

3588: AND line_type = 'LINE';
3589:
3590: BEGIN
3591: IF PG_DEBUG in ('Y', 'C') THEN
3592: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3593: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3594: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3595: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3596: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

Line 3818: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()-');

3814:
3815: END LOOP; -- sales credit loop
3816:
3817: IF PG_DEBUG in ('Y', 'C') THEN
3818: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()-');
3819: END IF;
3820:
3821: EXCEPTION
3822:

Line 3841: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()');

3837: IF (SQLCODE = -20001)
3838: THEN
3839: IF PG_DEBUG in ('Y', 'C') THEN
3840: arp_util.debug
3841: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()');
3842: END IF;
3843: RAISE FND_API.G_EXC_ERROR;
3844: ELSE
3845: IF PG_DEBUG in ('Y', 'C') THEN

Line 3847: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');

3843: RAISE FND_API.G_EXC_ERROR;
3844: ELSE
3845: IF PG_DEBUG in ('Y', 'C') THEN
3846: arp_util.debug('no_rule_debit_credit: ' || 'Unexpected error '||sqlerrm||
3847: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3848: END IF;
3849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3850: END IF;
3851:

Line 3919: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()+');

3915: gl.code_combination_id;
3916:
3917: BEGIN
3918: IF PG_DEBUG in ('Y', 'C') THEN
3919: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()+');
3920: END IF;
3921: FND_PROFILE.get('USER_ID',l_user_id);
3922: IF l_user_id IS NULL
3923: THEN

Line 4101: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()-');

4097:
4098: END LOOP;
4099:
4100: IF PG_DEBUG in ('Y', 'C') THEN
4101: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()-');
4102: END IF;
4103:
4104: EXCEPTION
4105: WHEN invalid_ccid THEN

Line 4117: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()');

4113: IF (SQLCODE = -20001)
4114: THEN
4115: IF PG_DEBUG in ('Y', 'C') THEN
4116: arp_util.debug
4117: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()');
4118: END IF;
4119: RAISE FND_API.G_EXC_ERROR;
4120: ELSE
4121: IF PG_DEBUG in ('Y', 'C') THEN

Line 4123: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');

4119: RAISE FND_API.G_EXC_ERROR;
4120: ELSE
4121: IF PG_DEBUG in ('Y', 'C') THEN
4122: arp_util.debug('no_rule_debit_credit_no_sr: ' || 'Unexpected error '||sqlerrm||
4123: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
4124: END IF;
4125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4126: END IF;
4127:

Line 4176: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

4172: IS
4173: l_api_name CONSTANT VARCHAR2(30)
4174: := 'Transfer_Revenue_Between_Lines';
4175: l_api_version CONSTANT NUMBER := 2.0;
4176: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
4177: l_tax_rate_count NUMBER := 0;
4178: l_lines_from_total NUMBER := 0;
4179: l_line_from_count NUMBER := 0;
4180: l_no_of_lines_from NUMBER := 0;

Line 4371: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

4367: ,l.accounting_rule_duration;
4368:
4369: BEGIN
4370: IF PG_DEBUG in ('Y', 'C') THEN
4371: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4372: END IF;
4373: -- Standard Start of API savepoint
4374: SAVEPOINT Transfer_Rev_Between_Lines_PVT;
4375: -- Standard call to check for call compatibility.

Line 4383: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

4379: G_PKG_NAME )
4380: THEN
4381: IF PG_DEBUG in ('Y', 'C') THEN
4382: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4383: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4384: END IF;
4385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4386: END IF;
4387: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4397: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines(2)+');

4393: x_return_status := FND_API.G_RET_STS_SUCCESS;
4394:
4395: BEGIN
4396: IF PG_DEBUG in ('Y', 'C') THEN
4397: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines(2)+');
4398: END IF;
4399:
4400: l_rev_adj_rec := p_rev_adj_rec;
4401:

Line 4649: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()');

4645: IF (SQLCODE = -20001)
4646: THEN
4647: IF PG_DEBUG in ('Y', 'C') THEN
4648: arp_util.debug
4649: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()');
4650: END IF;
4651: RAISE FND_API.G_EXC_ERROR;
4652: ELSE
4653: IF PG_DEBUG in ('Y', 'C') THEN

Line 4655: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

4651: RAISE FND_API.G_EXC_ERROR;
4652: ELSE
4653: IF PG_DEBUG in ('Y', 'C') THEN
4654: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4655: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4656: END IF;
4657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4658: END IF;
4659: END;

Line 4675: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()-');

4671: (p_encoded => FND_API.G_FALSE,
4672: p_count => x_msg_count,
4673: p_data => x_msg_data);
4674: IF PG_DEBUG in ('Y', 'C') THEN
4675: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()-');
4676: END IF;
4677: EXCEPTION
4678: WHEN FND_API.G_EXC_ERROR THEN
4679: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;

Line 4688: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

4684: p_data => x_msg_data);
4685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4686: IF PG_DEBUG in ('Y', 'C') THEN
4687: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4688: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4689: END IF;
4690: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4692: FND_MSG_PUB.Count_And_Get

Line 4701: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

4697: IF (SQLCODE = -20001)
4698: THEN
4699: IF PG_DEBUG in ('Y', 'C') THEN
4700: arp_util.debug('Transfer_Revenue_Between_Lines: ' || '20001 error '||
4701: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4702: END IF;
4703: x_return_status := FND_API.G_RET_STS_ERROR ;
4704: ELSE
4705: IF PG_DEBUG in ('Y', 'C') THEN

Line 4707: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');

4703: x_return_status := FND_API.G_RET_STS_ERROR ;
4704: ELSE
4705: IF PG_DEBUG in ('Y', 'C') THEN
4706: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4707: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4708: END IF;
4709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4710: IF FND_MSG_PUB.Check_Msg_Level
4711: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 4760: arp_util.debug('AR_Revenue_Adjustment_PVT.reset_dist_percent()+');

4756: AND NVL(amount,0) <> 0;
4757:
4758: BEGIN
4759: IF PG_DEBUG in ('Y', 'C') THEN
4760: arp_util.debug('AR_Revenue_Adjustment_PVT.reset_dist_percent()+');
4761: END IF;
4762: OPEN c_total;
4763: FETCH c_total into l_total;
4764: CLOSE c_total;

Line 4784: arp_util.debug('AR_Revenue_Adjustment_PVT.reset_dist_percent()-');

4780: SET percent = l_percent
4781: WHERE rowid = c1.rowid;
4782: END LOOP;
4783: IF PG_DEBUG in ('Y', 'C') THEN
4784: arp_util.debug('AR_Revenue_Adjustment_PVT.reset_dist_percent()-');
4785: END IF;
4786: EXCEPTION
4787: WHEN OTHERS THEN
4788: IF (SQLCODE = -20001)

Line 4792: ('20001 error at AR_Revenue_Adjustment_PVT.reset_dist_percent()');

4788: IF (SQLCODE = -20001)
4789: THEN
4790: IF PG_DEBUG in ('Y', 'C') THEN
4791: arp_util.debug
4792: ('20001 error at AR_Revenue_Adjustment_PVT.reset_dist_percent()');
4793: END IF;
4794: RAISE FND_API.G_EXC_ERROR;
4795: ELSE
4796: IF PG_DEBUG in ('Y', 'C') THEN

Line 4798: ' at AR_Revenue_Adjustment_PVT.reset_dist_percent()+');

4794: RAISE FND_API.G_EXC_ERROR;
4795: ELSE
4796: IF PG_DEBUG in ('Y', 'C') THEN
4797: arp_util.debug('reset_dist_percent: ' || 'Unexpected error '||sqlerrm||
4798: ' at AR_Revenue_Adjustment_PVT.reset_dist_percent()+');
4799: END IF;
4800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4801: END IF;
4802: END reset_dist_percent;

Line 4821: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()+');

4817: FROM dual;
4818:
4819: BEGIN
4820: IF PG_DEBUG in ('Y', 'C') THEN
4821: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()+');
4822: END IF;
4823:
4824: OPEN c_adjustment_id;
4825: FETCH c_adjustment_id INTO x_adjustment_id;

Line 4927: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()-');

4923: ,SYSDATE
4924: ,FND_GLOBAL.user_id
4925: ,arp_standard.sysparm.org_id ); -- Bug 4607673
4926: IF PG_DEBUG in ('Y', 'C') THEN
4927: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()-');
4928: END IF;
4929:
4930: EXCEPTION
4931: WHEN OTHERS THEN

Line 4936: ('20001 error at AR_Revenue_Adjustment_PVT.create_adjustment()');

4932: IF (SQLCODE = -20001)
4933: THEN
4934: IF PG_DEBUG in ('Y', 'C') THEN
4935: arp_util.debug
4936: ('20001 error at AR_Revenue_Adjustment_PVT.create_adjustment()');
4937: END IF;
4938: RAISE FND_API.G_EXC_ERROR;
4939: ELSE
4940: IF PG_DEBUG in ('Y', 'C') THEN

Line 4942: ' at AR_Revenue_Adjustment_PVT.create_adjustment()+');

4938: RAISE FND_API.G_EXC_ERROR;
4939: ELSE
4940: IF PG_DEBUG in ('Y', 'C') THEN
4941: arp_util.debug('create_adjustment: ' || 'Unexpected error '||sqlerrm||
4942: ' at AR_Revenue_Adjustment_PVT.create_adjustment()+');
4943: END IF;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END IF;
4946: END create_adjustment;

Line 5004: arp_util.debug('AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');

5000: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;
5001:
5002: BEGIN
5003: IF PG_DEBUG in ('Y', 'C') THEN
5004: arp_util.debug('AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');
5005: END IF;
5006: FND_PROFILE.get('USER_ID',l_user_id);
5007: IF l_user_id IS NULL
5008: THEN

Line 5127: arp_util.debug('AR_Revenue_Adjustment_PVT.cr_target_line_unearned()-');

5123: p_adjustment_id);
5124:
5125: END LOOP; -- sales credit loop
5126: IF PG_DEBUG in ('Y', 'C') THEN
5127: arp_util.debug('AR_Revenue_Adjustment_PVT.cr_target_line_unearned()-');
5128: END IF;
5129:
5130: EXCEPTION
5131:

Line 5144: ('20001 error at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()');

5140: IF (SQLCODE = -20001)
5141: THEN
5142: IF PG_DEBUG in ('Y', 'C') THEN
5143: arp_util.debug
5144: ('20001 error at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()');
5145: END IF;
5146: RAISE FND_API.G_EXC_ERROR;
5147: ELSE
5148: IF PG_DEBUG in ('Y', 'C') THEN

Line 5150: ' at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');

5146: RAISE FND_API.G_EXC_ERROR;
5147: ELSE
5148: IF PG_DEBUG in ('Y', 'C') THEN
5149: arp_util.debug('cr_target_line_unearned: ' || 'Unexpected error '||sqlerrm||
5150: ' at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');
5151: END IF;
5152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5153: END IF;
5154:

Line 5186: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()+');

5182: l_xla_event arp_xla_events.xla_events_type;
5183:
5184: BEGIN
5185: IF PG_DEBUG in ('Y', 'C') THEN
5186: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()+');
5187: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
5188: arp_util.debug(' p_amount = ' || p_amount);
5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);

Line 5300: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()-');

5296: g_ra_dist_tbl(g_dist_count).posting_control_id := -3;
5297: END IF;
5298:
5299: IF PG_DEBUG in ('Y', 'C') THEN
5300: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()-');
5301: END IF;
5302: EXCEPTION
5303: WHEN OTHERS THEN
5304: IF (SQLCODE = -20001)

Line 5308: ('20001 error at AR_Revenue_Adjustment_PVT.insert_distribution()');

5304: IF (SQLCODE = -20001)
5305: THEN
5306: IF PG_DEBUG in ('Y', 'C') THEN
5307: arp_util.debug
5308: ('20001 error at AR_Revenue_Adjustment_PVT.insert_distribution()');
5309: END IF;
5310: RAISE;
5311: ELSE
5312: IF PG_DEBUG in ('Y', 'C') THEN

Line 5314: ' at AR_Revenue_Adjustment_PVT.insert_distribution()+');

5310: RAISE;
5311: ELSE
5312: IF PG_DEBUG in ('Y', 'C') THEN
5313: arp_util.debug('insert_distribution: ' || 'Unexpected error '||sqlerrm||
5314: ' at AR_Revenue_Adjustment_PVT.insert_distribution()+');
5315: END IF;
5316: RAISE;
5317: END IF;
5318: END insert_distribution;

Line 5354: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()+');

5350: invalid_ccid EXCEPTION;
5351:
5352: BEGIN
5353: IF PG_DEBUG in ('Y', 'C') THEN
5354: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5355: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
5356: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);
5357: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5358: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

Line 5558: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()-');

5554: END LOOP;
5555: END IF;
5556:
5557: IF PG_DEBUG in ('Y', 'C') THEN
5558: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()-');
5559: END IF;
5560:
5561: EXCEPTION
5562: WHEN invalid_ccid THEN

Line 5574: ('20001 error at AR_Revenue_Adjustment_PVT.insert_sales_credit()');

5570: IF (SQLCODE = -20001)
5571: THEN
5572: IF PG_DEBUG in ('Y', 'C') THEN
5573: arp_util.debug
5574: ('20001 error at AR_Revenue_Adjustment_PVT.insert_sales_credit()');
5575: END IF;
5576: RAISE FND_API.G_EXC_ERROR;
5577: ELSE
5578: IF PG_DEBUG in ('Y', 'C') THEN

Line 5580: ' at AR_Revenue_Adjustment_PVT.insert_sales_credit()+');

5576: RAISE FND_API.G_EXC_ERROR;
5577: ELSE
5578: IF PG_DEBUG in ('Y', 'C') THEN
5579: arp_util.debug('insert_sales_credit: ' || 'Unexpected error '||sqlerrm||
5580: ' at AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5581: END IF;
5582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5583: END IF;
5584:

Line 5653: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()+');

5649: AND NVL(r.deferred_revenue_flag,'N') <> 'Y';
5650:
5651: BEGIN
5652: IF PG_DEBUG in ('Y', 'C') THEN
5653: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()+');
5654: END IF;
5655: AR_RAAPI_UTIL.Constant_System_Values;
5656: AR_RAAPI_UTIL.Initialize_Globals;
5657: x_first_rev_adj_id := NULL;

Line 5764: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');

5760: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);
5761: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);
5762: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);
5763: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);
5764: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');
5765: END IF;
5766: EXCEPTION
5767: WHEN OTHERS THEN
5768: IF (SQLCODE = -20001)

Line 5772: ('20001 error at AR_Revenue_Adjustment_PVT.record_acceptance()');

5768: IF (SQLCODE = -20001)
5769: THEN
5770: IF PG_DEBUG in ('Y', 'C') THEN
5771: arp_util.debug
5772: ('20001 error at AR_Revenue_Adjustment_PVT.record_acceptance()');
5773: END IF;
5774: RAISE FND_API.G_EXC_ERROR;
5775: ELSE
5776: IF PG_DEBUG in ('Y', 'C') THEN

Line 5778: ' at AR_Revenue_Adjustment_PVT.record_acceptance()+');

5774: RAISE FND_API.G_EXC_ERROR;
5775: ELSE
5776: IF PG_DEBUG in ('Y', 'C') THEN
5777: arp_util.debug('Record_Acceptance: ' || 'Unexpected error '||sqlerrm||
5778: ' at AR_Revenue_Adjustment_PVT.record_acceptance()+');
5779: END IF;
5780: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5781: END IF;
5782: END Record_Acceptance;

Line 5794: END AR_Revenue_Adjustment_PVT;

5790: ELSE
5791: g_rev_mgt_installed := 'N';
5792: END IF;
5793:
5794: END AR_Revenue_Adjustment_PVT;