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.38.12010000.8 2008/12/01 06:35:28 ankuagar 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: END IF;
228: -- Standard Start of API savepoint
229: SAVEPOINT Earn_Revenue_PVT;
230: -- Standard call to check for call compatibility.

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

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

Line 256: AR_Revenue_Adjustment_PVT.earn_or_unearn

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 431: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

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

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

502:
503:
504: BEGIN
505: IF PG_DEBUG in ('Y', 'C') THEN
506: arp_util.debug('AR_Revenue_Adjustment_PVT.earn_or_unearn()+');
507: END IF;
508: l_rev_adj_rec := p_rev_adj_rec;
509:
510: /*Bug 6731185 JVARKEY Making sure GL date has no timestamp*/

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

817: END IF;
818:
819: END IF;
820: IF PG_DEBUG in ('Y', 'C') THEN
821: arp_util.debug('AR_Revenue_Adjustment_PVT.earn_or_unearn()-');
822: END IF;
823:
824: EXCEPTION
825:

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

827: IF (SQLCODE = -20001)
828: THEN
829: IF PG_DEBUG in ('Y', 'C') THEN
830: arp_util.debug
831: ('20001 error at AR_Revenue_Adjustment_PVT.earn_or_unearn');
832: END IF;
833: RAISE FND_API.G_EXC_ERROR;
834: ELSE
835: IF PG_DEBUG in ('Y', 'C') THEN

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

833: RAISE FND_API.G_EXC_ERROR;
834: ELSE
835: IF PG_DEBUG in ('Y', 'C') THEN
836: arp_util.debug('earn_or_unearn: ' || 'Unexpected error '||sqlerrm||
837: ' at AR_Revenue_Adjustment_PVT.earn_or_unearn()+');
838: END IF;
839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
840: END IF;
841: END earn_or_unearn;

Line 888: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

884: ,x_adjustment_number OUT NOCOPY VARCHAR2)
885: IS
886: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Sales_Credits';
887: l_api_version CONSTANT NUMBER := 2.0;
888: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
889:
890: l_trx_total NUMBER := 0;
891: l_line_count NUMBER := 0;
892: l_salesrep_count NUMBER := 0;

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

1205: WHERE salesrep_id = AR_RAAPI_UTIL.g_to_salesrep_id;
1206:
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.

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

1217: G_PKG_NAME )
1218: THEN
1219: IF PG_DEBUG in ('Y', 'C') THEN
1220: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1221: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1222: END IF;
1223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1224: END IF;
1225: -- Initialize message list if p_init_msg_list is set to TRUE.

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

1254: -- Inner PL/SQL Block to optimize error handling
1255: --
1256: BEGIN
1257: IF PG_DEBUG in ('Y', 'C') THEN
1258: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits(2)+');
1259: END IF;
1260:
1261: l_revenue_amount := 0;
1262: l_nonrev_amount := 0;

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

1904: IF (SQLCODE = -20001)
1905: THEN
1906: IF PG_DEBUG in ('Y', 'C') THEN
1907: arp_util.debug
1908: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()');
1909: END IF;
1910: RAISE FND_API.G_EXC_ERROR;
1911: ELSE
1912: IF PG_DEBUG in ('Y', 'C') THEN

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

1910: RAISE FND_API.G_EXC_ERROR;
1911: ELSE
1912: IF PG_DEBUG in ('Y', 'C') THEN
1913: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1914: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1915: END IF;
1916: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1917: END IF;
1918: END;

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

1930: (p_encoded => FND_API.G_FALSE,
1931: p_count => x_msg_count,
1932: p_data => x_msg_data);
1933: IF PG_DEBUG in ('Y', 'C') THEN
1934: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()-');
1935: END IF;
1936: EXCEPTION
1937: WHEN FND_API.G_EXC_ERROR THEN
1938: ROLLBACK TO Transfer_Sales_Credits_PVT;

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

1943: p_data => x_msg_data);
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: IF PG_DEBUG in ('Y', 'C') THEN
1946: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1947: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1948: END IF;
1949: ROLLBACK TO Transfer_Sales_Credits_PVT;
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951: FND_MSG_PUB.Count_And_Get

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

1956: IF (SQLCODE = -20001)
1957: THEN
1958: IF PG_DEBUG in ('Y', 'C') THEN
1959: arp_util.debug('Transfer_Sales_Credits: ' || '20001 error '||
1960: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1961: END IF;
1962: x_return_status := FND_API.G_RET_STS_ERROR ;
1963: ELSE
1964: IF PG_DEBUG in ('Y', 'C') THEN

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

1962: x_return_status := FND_API.G_RET_STS_ERROR ;
1963: ELSE
1964: IF PG_DEBUG in ('Y', 'C') THEN
1965: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1966: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1967: END IF;
1968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1969: IF FND_MSG_PUB.Check_Msg_Level
1970: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 2032: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

2028: IS
2029: l_api_name CONSTANT VARCHAR2(30) :=
2030: 'Add_Non_Revenue_Sales_Credits';
2031: l_api_version CONSTANT NUMBER := 2.0;
2032: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
2033:
2034: l_trx_total NUMBER;
2035: l_line_count NUMBER;
2036: l_no_of_lines NUMBER;

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

2133:
2134: BEGIN
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.

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

2145: G_PKG_NAME )
2146: THEN
2147: IF PG_DEBUG in ('Y', 'C') THEN
2148: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2149: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2150: END IF;
2151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2152: END IF;
2153: -- Initialize message list if p_init_msg_list is set to TRUE.

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

2182: -- Inner PL/SQL block to ensure consistent error handling
2183: --
2184: BEGIN
2185: IF PG_DEBUG in ('Y', 'C') THEN
2186: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits(2)+');
2187: END IF;
2188: l_amount := 0;
2189: l_line_count := 0;
2190: l_total_adjusted := 0;

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

2318: IF (SQLCODE = -20001)
2319: THEN
2320: IF PG_DEBUG in ('Y', 'C') THEN
2321: arp_util.debug
2322: ('20001 error at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()');
2323: END IF;
2324: RAISE FND_API.G_EXC_ERROR;
2325: ELSE
2326: IF PG_DEBUG in ('Y', 'C') THEN

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

2324: RAISE FND_API.G_EXC_ERROR;
2325: ELSE
2326: IF PG_DEBUG in ('Y', 'C') THEN
2327: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2328: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2329: END IF;
2330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2331: END IF;
2332:

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

2345: (p_encoded => FND_API.G_FALSE,
2346: p_count => x_msg_count,
2347: p_data => x_msg_data);
2348: IF PG_DEBUG in ('Y', 'C') THEN
2349: arp_util.debug('AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()-');
2350: END IF;
2351: EXCEPTION
2352: WHEN FND_API.G_EXC_ERROR THEN
2353: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;

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

2358: p_data => x_msg_data);
2359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2360: IF PG_DEBUG in ('Y', 'C') THEN
2361: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2362: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2363: END IF;
2364: ROLLBACK TO Add_Non_Rev_Sales_Credits_PVT;
2365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2366: FND_MSG_PUB.Count_And_Get

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

2371: IF (SQLCODE = -20001)
2372: THEN
2373: IF PG_DEBUG in ('Y', 'C') THEN
2374: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || '20001 error '||
2375: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2376: END IF;
2377: x_return_status := FND_API.G_RET_STS_ERROR ;
2378: ELSE
2379: IF PG_DEBUG in ('Y', 'C') THEN

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

2377: x_return_status := FND_API.G_RET_STS_ERROR ;
2378: ELSE
2379: IF PG_DEBUG in ('Y', 'C') THEN
2380: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2381: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2382: END IF;
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2384: IF FND_MSG_PUB.Check_Msg_Level
2385: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

2477: AND l.line_type = 'LINE';
2478:
2479: BEGIN
2480: IF PG_DEBUG in ('Y', 'C') THEN
2481: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2482: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2483: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2484: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2485: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

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

2653: END IF;
2654:
2655: END LOOP; -- assignments loop
2656: IF PG_DEBUG in ('Y', 'C') THEN
2657: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()-');
2658: END IF;
2659:
2660: EXCEPTION
2661:

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

2663: IF (SQLCODE = -20001)
2664: THEN
2665: IF PG_DEBUG in ('Y', 'C') THEN
2666: arp_util.debug
2667: ('20001 error at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()');
2668: END IF;
2669: RAISE FND_API.G_EXC_ERROR;
2670: ELSE
2671: IF PG_DEBUG in ('Y', 'C') THEN

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

2669: RAISE FND_API.G_EXC_ERROR;
2670: ELSE
2671: IF PG_DEBUG in ('Y', 'C') THEN
2672: arp_util.debug('transfer_salesrep_revenue: ' || 'Unexpected error '||sqlerrm||
2673: ' at AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2674: END IF;
2675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2676: END IF;
2677:

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

2723:
2724: BEGIN
2725: IF PG_DEBUG in ('Y', 'C')
2726: THEN
2727: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model()+');
2728: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
2729: END IF;
2730:
2731: /* Initialize globals for this package */

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

2974:
2975: BEGIN
2976:
2977: IF PG_DEBUG in ('Y', 'C') THEN
2978: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()+');
2979: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2980: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2981: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2982: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

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

3271: END LOOP; -- assignments loop
3272:
3273: END LOOP; -- sales credit loop
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()-');
3276: END IF;
3277:
3278: EXCEPTION
3279:

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

3294: IF (SQLCODE = -20001)
3295: THEN
3296: IF PG_DEBUG in ('Y', 'C') THEN
3297: arp_util.debug
3298: ('20001 error at AR_Revenue_Adjustment_PVT.debit_credit()');
3299: END IF;
3300: RAISE FND_API.G_EXC_ERROR;
3301: ELSE
3302: IF PG_DEBUG in ('Y', 'C') THEN

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

3300: RAISE FND_API.G_EXC_ERROR;
3301: ELSE
3302: IF PG_DEBUG in ('Y', 'C') THEN
3303: arp_util.debug('debit_credit: ' || 'Unexpected error '||sqlerrm||
3304: ' at AR_Revenue_Adjustment_PVT.debit_credit()+');
3305: END IF;
3306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3307: END IF;
3308:

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

3395: AND line_type = 'LINE';
3396:
3397: BEGIN
3398: IF PG_DEBUG in ('Y', 'C') THEN
3399: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3400: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3401: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3402: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3403: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

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

3613:
3614: END LOOP; -- sales credit loop
3615:
3616: IF PG_DEBUG in ('Y', 'C') THEN
3617: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()-');
3618: END IF;
3619:
3620: EXCEPTION
3621:

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

3636: IF (SQLCODE = -20001)
3637: THEN
3638: IF PG_DEBUG in ('Y', 'C') THEN
3639: arp_util.debug
3640: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()');
3641: END IF;
3642: RAISE FND_API.G_EXC_ERROR;
3643: ELSE
3644: IF PG_DEBUG in ('Y', 'C') THEN

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

3642: RAISE FND_API.G_EXC_ERROR;
3643: ELSE
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: arp_util.debug('no_rule_debit_credit: ' || 'Unexpected error '||sqlerrm||
3646: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3647: END IF;
3648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3649: END IF;
3650:

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

3713: gl.code_combination_id;
3714:
3715: BEGIN
3716: IF PG_DEBUG in ('Y', 'C') THEN
3717: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()+');
3718: END IF;
3719: FND_PROFILE.get('USER_ID',l_user_id);
3720: IF l_user_id IS NULL
3721: THEN

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

3882:
3883: END LOOP;
3884:
3885: IF PG_DEBUG in ('Y', 'C') THEN
3886: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()-');
3887: END IF;
3888:
3889: EXCEPTION
3890: WHEN invalid_ccid THEN

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

3898: IF (SQLCODE = -20001)
3899: THEN
3900: IF PG_DEBUG in ('Y', 'C') THEN
3901: arp_util.debug
3902: ('20001 error at AR_Revenue_Adjustment_PVT.no_rule_debit_credit_no_sr()');
3903: END IF;
3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSE
3906: IF PG_DEBUG in ('Y', 'C') THEN

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

3904: RAISE FND_API.G_EXC_ERROR;
3905: ELSE
3906: IF PG_DEBUG in ('Y', 'C') THEN
3907: arp_util.debug('no_rule_debit_credit_no_sr: ' || 'Unexpected error '||sqlerrm||
3908: ' at AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3909: END IF;
3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3911: END IF;
3912:

Line 3961: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;

3957: IS
3958: l_api_name CONSTANT VARCHAR2(30)
3959: := 'Transfer_Revenue_Between_Lines';
3960: l_api_version CONSTANT NUMBER := 2.0;
3961: l_rev_adj_rec AR_Revenue_Adjustment_PVT.Rev_Adj_Rec_Type;
3962: l_tax_rate_count NUMBER := 0;
3963: l_lines_from_total NUMBER := 0;
3964: l_line_from_count NUMBER := 0;
3965: l_no_of_lines_from NUMBER := 0;

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

4151: ,l.accounting_rule_duration;
4152:
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.

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

4163: G_PKG_NAME )
4164: THEN
4165: IF PG_DEBUG in ('Y', 'C') THEN
4166: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4167: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4168: END IF;
4169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4170: END IF;
4171: -- Initialize message list if p_init_msg_list is set to TRUE.

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

4177: x_return_status := FND_API.G_RET_STS_SUCCESS;
4178:
4179: BEGIN
4180: IF PG_DEBUG in ('Y', 'C') THEN
4181: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines(2)+');
4182: END IF;
4183:
4184: l_rev_adj_rec := p_rev_adj_rec;
4185:

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

4420: IF (SQLCODE = -20001)
4421: THEN
4422: IF PG_DEBUG in ('Y', 'C') THEN
4423: arp_util.debug
4424: ('20001 error at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()');
4425: END IF;
4426: RAISE FND_API.G_EXC_ERROR;
4427: ELSE
4428: IF PG_DEBUG in ('Y', 'C') THEN

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

4426: RAISE FND_API.G_EXC_ERROR;
4427: ELSE
4428: IF PG_DEBUG in ('Y', 'C') THEN
4429: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4430: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4431: END IF;
4432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4433: END IF;
4434: END;

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

4446: (p_encoded => FND_API.G_FALSE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data);
4449: IF PG_DEBUG in ('Y', 'C') THEN
4450: arp_util.debug('AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()-');
4451: END IF;
4452: EXCEPTION
4453: WHEN FND_API.G_EXC_ERROR THEN
4454: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;

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

4459: p_data => x_msg_data);
4460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4461: IF PG_DEBUG in ('Y', 'C') THEN
4462: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4463: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4464: END IF;
4465: ROLLBACK TO Transfer_Rev_Between_Lines_PVT;
4466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4467: FND_MSG_PUB.Count_And_Get

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

4472: IF (SQLCODE = -20001)
4473: THEN
4474: IF PG_DEBUG in ('Y', 'C') THEN
4475: arp_util.debug('Transfer_Revenue_Between_Lines: ' || '20001 error '||
4476: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4477: END IF;
4478: x_return_status := FND_API.G_RET_STS_ERROR ;
4479: ELSE
4480: IF PG_DEBUG in ('Y', 'C') THEN

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

4478: x_return_status := FND_API.G_RET_STS_ERROR ;
4479: ELSE
4480: IF PG_DEBUG in ('Y', 'C') THEN
4481: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4482: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4483: END IF;
4484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4485: IF FND_MSG_PUB.Check_Msg_Level
4486: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

4531: AND NVL(amount,0) <> 0;
4532:
4533: BEGIN
4534: IF PG_DEBUG in ('Y', 'C') THEN
4535: arp_util.debug('AR_Revenue_Adjustment_PVT.reset_dist_percent()+');
4536: END IF;
4537: OPEN c_total;
4538: FETCH c_total into l_total;
4539: CLOSE c_total;

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

4555: SET percent = l_percent
4556: WHERE rowid = c1.rowid;
4557: END LOOP;
4558: IF PG_DEBUG in ('Y', 'C') THEN
4559: arp_util.debug('AR_Revenue_Adjustment_PVT.reset_dist_percent()-');
4560: END IF;
4561: EXCEPTION
4562: WHEN OTHERS THEN
4563: IF (SQLCODE = -20001)

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

4563: IF (SQLCODE = -20001)
4564: THEN
4565: IF PG_DEBUG in ('Y', 'C') THEN
4566: arp_util.debug
4567: ('20001 error at AR_Revenue_Adjustment_PVT.reset_dist_percent()');
4568: END IF;
4569: RAISE FND_API.G_EXC_ERROR;
4570: ELSE
4571: IF PG_DEBUG in ('Y', 'C') THEN

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

4569: RAISE FND_API.G_EXC_ERROR;
4570: ELSE
4571: IF PG_DEBUG in ('Y', 'C') THEN
4572: arp_util.debug('reset_dist_percent: ' || 'Unexpected error '||sqlerrm||
4573: ' at AR_Revenue_Adjustment_PVT.reset_dist_percent()+');
4574: END IF;
4575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4576: END IF;
4577: END reset_dist_percent;

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

4592: FROM dual;
4593:
4594: BEGIN
4595: IF PG_DEBUG in ('Y', 'C') THEN
4596: arp_util.debug('AR_Revenue_Adjustment_PVT.create_adjustment()+');
4597: END IF;
4598:
4599: OPEN c_adjustment_id;
4600: FETCH c_adjustment_id INTO x_adjustment_id;

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

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:
4705: EXCEPTION
4706: WHEN OTHERS THEN

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

4707: IF (SQLCODE = -20001)
4708: THEN
4709: IF PG_DEBUG in ('Y', 'C') THEN
4710: arp_util.debug
4711: ('20001 error at AR_Revenue_Adjustment_PVT.create_adjustment()');
4712: END IF;
4713: RAISE FND_API.G_EXC_ERROR;
4714: ELSE
4715: IF PG_DEBUG in ('Y', 'C') THEN

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

4713: RAISE FND_API.G_EXC_ERROR;
4714: ELSE
4715: IF PG_DEBUG in ('Y', 'C') THEN
4716: arp_util.debug('create_adjustment: ' || 'Unexpected error '||sqlerrm||
4717: ' at AR_Revenue_Adjustment_PVT.create_adjustment()+');
4718: END IF;
4719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4720: END IF;
4721: END create_adjustment;

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

4775: HAVING SUM(NVL(revenue_percent_split,0)) <> 0;
4776:
4777: BEGIN
4778: IF PG_DEBUG in ('Y', 'C') THEN
4779: arp_util.debug('AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');
4780: END IF;
4781: FND_PROFILE.get('USER_ID',l_user_id);
4782: IF l_user_id IS NULL
4783: THEN

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

4898: p_adjustment_id);
4899:
4900: END LOOP; -- sales credit loop
4901: IF PG_DEBUG in ('Y', 'C') THEN
4902: arp_util.debug('AR_Revenue_Adjustment_PVT.cr_target_line_unearned()-');
4903: END IF;
4904:
4905: EXCEPTION
4906:

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

4915: IF (SQLCODE = -20001)
4916: THEN
4917: IF PG_DEBUG in ('Y', 'C') THEN
4918: arp_util.debug
4919: ('20001 error at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()');
4920: END IF;
4921: RAISE FND_API.G_EXC_ERROR;
4922: ELSE
4923: IF PG_DEBUG in ('Y', 'C') THEN

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

4921: RAISE FND_API.G_EXC_ERROR;
4922: ELSE
4923: IF PG_DEBUG in ('Y', 'C') THEN
4924: arp_util.debug('cr_target_line_unearned: ' || 'Unexpected error '||sqlerrm||
4925: ' at AR_Revenue_Adjustment_PVT.cr_target_line_unearned()+');
4926: END IF;
4927: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4928: END IF;
4929:

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

4957: l_xla_event arp_xla_events.xla_events_type;
4958:
4959: BEGIN
4960: IF PG_DEBUG in ('Y', 'C') THEN
4961: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()+');
4962: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
4963: arp_util.debug(' p_amount = ' || p_amount);
4964: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
4965: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);

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

5075: END IF;
5076:
5077: END IF;
5078: IF PG_DEBUG in ('Y', 'C') THEN
5079: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()-');
5080: END IF;
5081: EXCEPTION
5082: WHEN OTHERS THEN
5083: IF (SQLCODE = -20001)

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

5083: IF (SQLCODE = -20001)
5084: THEN
5085: IF PG_DEBUG in ('Y', 'C') THEN
5086: arp_util.debug
5087: ('20001 error at AR_Revenue_Adjustment_PVT.insert_distribution()');
5088: END IF;
5089: RAISE;
5090: ELSE
5091: IF PG_DEBUG in ('Y', 'C') THEN

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

5089: RAISE;
5090: ELSE
5091: IF PG_DEBUG in ('Y', 'C') THEN
5092: arp_util.debug('insert_distribution: ' || 'Unexpected error '||sqlerrm||
5093: ' at AR_Revenue_Adjustment_PVT.insert_distribution()+');
5094: END IF;
5095: RAISE;
5096: END IF;
5097: END insert_distribution;

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

5129: invalid_ccid EXCEPTION;
5130:
5131: BEGIN
5132: IF PG_DEBUG in ('Y', 'C') THEN
5133: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5134: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
5135: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);
5136: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5137: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

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

5333: END LOOP;
5334: END IF;
5335:
5336: IF PG_DEBUG in ('Y', 'C') THEN
5337: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()-');
5338: END IF;
5339:
5340: EXCEPTION
5341: WHEN invalid_ccid THEN

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

5349: IF (SQLCODE = -20001)
5350: THEN
5351: IF PG_DEBUG in ('Y', 'C') THEN
5352: arp_util.debug
5353: ('20001 error at AR_Revenue_Adjustment_PVT.insert_sales_credit()');
5354: END IF;
5355: RAISE FND_API.G_EXC_ERROR;
5356: ELSE
5357: IF PG_DEBUG in ('Y', 'C') THEN

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

5355: RAISE FND_API.G_EXC_ERROR;
5356: ELSE
5357: IF PG_DEBUG in ('Y', 'C') THEN
5358: arp_util.debug('insert_sales_credit: ' || 'Unexpected error '||sqlerrm||
5359: ' at AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5360: END IF;
5361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5362: END IF;
5363:

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

5428: AND NVL(r.deferred_revenue_flag,'N') <> 'Y';
5429:
5430: BEGIN
5431: IF PG_DEBUG in ('Y', 'C') THEN
5432: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()+');
5433: END IF;
5434: AR_RAAPI_UTIL.Constant_System_Values;
5435: AR_RAAPI_UTIL.Initialize_Globals;
5436: x_first_rev_adj_id := NULL;

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

5539: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);
5540: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);
5541: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);
5542: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);
5543: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');
5544: END IF;
5545: EXCEPTION
5546: WHEN OTHERS THEN
5547: IF (SQLCODE = -20001)

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

5547: IF (SQLCODE = -20001)
5548: THEN
5549: IF PG_DEBUG in ('Y', 'C') THEN
5550: arp_util.debug
5551: ('20001 error at AR_Revenue_Adjustment_PVT.record_acceptance()');
5552: END IF;
5553: RAISE FND_API.G_EXC_ERROR;
5554: ELSE
5555: IF PG_DEBUG in ('Y', 'C') THEN

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

5553: RAISE FND_API.G_EXC_ERROR;
5554: ELSE
5555: IF PG_DEBUG in ('Y', 'C') THEN
5556: arp_util.debug('Record_Acceptance: ' || 'Unexpected error '||sqlerrm||
5557: ' at AR_Revenue_Adjustment_PVT.record_acceptance()+');
5558: END IF;
5559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5560: END IF;
5561: END Record_Acceptance;

Line 5573: END AR_Revenue_Adjustment_PVT;

5569: ELSE
5570: g_rev_mgt_installed := 'N';
5571: END IF;
5572:
5573: END AR_Revenue_Adjustment_PVT;