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 ARP_UTIL

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 83: arp_util.debug('Unearn_Revenue: ' || '.Unexpected error '||sqlerrm||

79: l_api_name ,
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;

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 141: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||

137: p_count => x_msg_count,
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 ;

Line 154: arp_util.debug('Unearn_Revenue: ' || '20001 error '||

150: WHEN OTHERS THEN
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

Line 160: arp_util.debug('Unearn_Revenue: ' || 'Unexpected error '||sqlerrm||

156: END IF;
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

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 237: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||

233: l_api_name ,
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;

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 294: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||

290: p_count => x_msg_count,
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 ;

Line 307: arp_util.debug('Earn_Revenue: ' || '20001 error '||

303: WHEN OTHERS THEN
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

Line 313: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||

309: END IF;
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

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 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 557: arp_util.debug('original gl_date = ' || l_rev_adj_rec.gl_date);

553: (p_gl_date => l_rev_adj_rec.gl_date);
554:
555: IF PG_DEBUG in ('Y','C')
556: THEN
557: arp_util.debug('original gl_date = ' || l_rev_adj_rec.gl_date);
558: arp_util.debug('new gl_date = ' || l_gl_date_valid);
559: END IF;
560:
561: IF l_gl_date_valid IS NULL

Line 558: arp_util.debug('new gl_date = ' || l_gl_date_valid);

554:
555: IF PG_DEBUG in ('Y','C')
556: THEN
557: arp_util.debug('original gl_date = ' || l_rev_adj_rec.gl_date);
558: arp_util.debug('new gl_date = ' || l_gl_date_valid);
559: END IF;
560:
561: IF l_gl_date_valid IS NULL
562: THEN

Line 572: arp_util.debug('gl_date set to = ' || l_rev_adj_rec.gl_date);

568: l_rev_adj_rec.gl_date := l_gl_date_valid;
569:
570: IF PG_DEBUG in ('Y','C')
571: THEN
572: arp_util.debug('gl_date set to = ' || l_rev_adj_rec.gl_date);
573: END IF;
574: END IF;
575:
576: IF g_update_db_flag = 'Y'

Line 583: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);

579: (p_rev_adj_rec => l_rev_adj_rec
580: ,x_adjustment_id => x_adjustment_id
581: ,x_adjustment_number => x_adjustment_number);
582: IF PG_DEBUG in ('Y', 'C') THEN
583: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
584: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
585: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
586: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
587: END IF;

Line 584: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);

580: ,x_adjustment_id => x_adjustment_id
581: ,x_adjustment_number => x_adjustment_number);
582: IF PG_DEBUG in ('Y', 'C') THEN
583: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
584: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
585: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
586: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
587: END IF;
588: /* Bug 2560048 RAM-C - if api call not from collectibility engine

Line 585: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);

581: ,x_adjustment_number => x_adjustment_number);
582: IF PG_DEBUG in ('Y', 'C') THEN
583: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
584: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
585: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
586: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
587: END IF;
588: /* Bug 2560048 RAM-C - if api call not from collectibility engine
589: then the transaction must be recorded as manually overridden */

Line 586: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);

582: IF PG_DEBUG in ('Y', 'C') THEN
583: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
584: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
585: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
586: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
587: END IF;
588: /* Bug 2560048 RAM-C - if api call not from collectibility engine
589: then the transaction must be recorded as manually overridden */
590: /* Bug 2650708 - cater for null source value, and only call if

Line 620: arp_util.debug('x_return_status : '||x_return_status);

616: x_adjustment_id := NULL;
617: x_adjustment_number := NULL;
618: END IF;
619: IF PG_DEBUG in ('Y', 'C') THEN
620: arp_util.debug('x_return_status : '||x_return_status);
621: END IF;
622: /* Bug 2651996 - a null return status is being passed back from revenue
623: synchronizer - assume successful */
624: IF x_return_status IS NULL

Line 629: arp_util.debug('x_return_status : '||x_return_status);

625: THEN
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627: END IF;
628: IF PG_DEBUG in ('Y', 'C') THEN
629: arp_util.debug('x_return_status : '||x_return_status);
630: END IF;
631:
632: IF p_rev_adj_rec.adjustment_type = 'EA'
633: THEN

Line 814: arp_util.debug('ERROR: arp_rounding.correct_rev_adj_by_line');

810: /* This call will round each adjustment that has be
811: previously recorded in ar_rev_line_adj_gt */
812: IF (arp_rounding.correct_rev_adj_by_line = 0)
813: THEN
814: arp_util.debug('ERROR: arp_rounding.correct_rev_adj_by_line');
815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
816: END IF;
817: END IF;
818:

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 830: arp_util.debug

826: WHEN OTHERS then
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

Line 836: arp_util.debug('earn_or_unearn: ' || 'Unexpected error '||sqlerrm||

832: END IF;
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;

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 1220: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

1216: l_api_name ,
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;

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 1505: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');

1501: (l_line_percent + l_revenue_percent_split_new > 100 OR
1502: l_line_percent + l_revenue_percent_split_new < -100)
1503: THEN
1504: IF PG_DEBUG in ('Y', 'C') THEN
1505: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1506: arp_util.debug(' l_line_amount = ' || l_line_amount);
1507: arp_util.debug(' l_revenue_percent_split = ' ||
1508: l_revenue_percent_split);
1509: arp_util.debug(' l_line_percent = ' || l_line_percent);

Line 1506: arp_util.debug(' l_line_amount = ' || l_line_amount);

1502: l_line_percent + l_revenue_percent_split_new < -100)
1503: THEN
1504: IF PG_DEBUG in ('Y', 'C') THEN
1505: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1506: arp_util.debug(' l_line_amount = ' || l_line_amount);
1507: arp_util.debug(' l_revenue_percent_split = ' ||
1508: l_revenue_percent_split);
1509: arp_util.debug(' l_line_percent = ' || l_line_percent);
1510: arp_util.debug(' l_revenue_percent_split_new = ' ||

Line 1507: arp_util.debug(' l_revenue_percent_split = ' ||

1503: THEN
1504: IF PG_DEBUG in ('Y', 'C') THEN
1505: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1506: arp_util.debug(' l_line_amount = ' || l_line_amount);
1507: arp_util.debug(' l_revenue_percent_split = ' ||
1508: l_revenue_percent_split);
1509: arp_util.debug(' l_line_percent = ' || l_line_percent);
1510: arp_util.debug(' l_revenue_percent_split_new = ' ||
1511: l_revenue_percent_split_new);

Line 1509: arp_util.debug(' l_line_percent = ' || l_line_percent);

1505: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1506: arp_util.debug(' l_line_amount = ' || l_line_amount);
1507: arp_util.debug(' l_revenue_percent_split = ' ||
1508: l_revenue_percent_split);
1509: arp_util.debug(' l_line_percent = ' || l_line_percent);
1510: arp_util.debug(' l_revenue_percent_split_new = ' ||
1511: l_revenue_percent_split_new);
1512: END IF;
1513: -- RAISE invalid_percent;

Line 1510: arp_util.debug(' l_revenue_percent_split_new = ' ||

1506: arp_util.debug(' l_line_amount = ' || l_line_amount);
1507: arp_util.debug(' l_revenue_percent_split = ' ||
1508: l_revenue_percent_split);
1509: arp_util.debug(' l_line_percent = ' || l_line_percent);
1510: arp_util.debug(' l_revenue_percent_split_new = ' ||
1511: l_revenue_percent_split_new);
1512: END IF;
1513: -- RAISE invalid_percent;
1514: END IF;

Line 1652: arp_util.debug('l_amount_prorata = ' || l_amount_prorata);

1648: l_percent_prorata :=
1649: ROUND((l_amount_prorata / c1.amount) * 100,4);
1650: /* Added these debug messages as part of bug 6932079 */
1651: IF PG_DEBUG in ('Y', 'C') THEN
1652: arp_util.debug('l_amount_prorata = ' || l_amount_prorata);
1653: arp_util.debug('l_percent_prorata = ' || l_percent_prorata);
1654: END IF;
1655:
1656: IF l_amount_prorata <> 0

Line 1653: arp_util.debug('l_percent_prorata = ' || l_percent_prorata);

1649: ROUND((l_amount_prorata / c1.amount) * 100,4);
1650: /* Added these debug messages as part of bug 6932079 */
1651: IF PG_DEBUG in ('Y', 'C') THEN
1652: arp_util.debug('l_amount_prorata = ' || l_amount_prorata);
1653: arp_util.debug('l_percent_prorata = ' || l_percent_prorata);
1654: END IF;
1655:
1656: IF l_amount_prorata <> 0
1657: THEN

Line 1907: arp_util.debug

1903: WHEN OTHERS then
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

Line 1913: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

1909: END IF;
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;

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 1946: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

1942: p_count => x_msg_count,
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 ;

Line 1959: arp_util.debug('Transfer_Sales_Credits: ' || '20001 error '||

1955: WHEN OTHERS THEN
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

Line 1965: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

1961: END IF;
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

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 2148: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

2144: l_api_name ,
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;

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 2321: arp_util.debug

2317: WHEN OTHERS then
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

Line 2327: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

2323: END IF;
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;

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 2361: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

2357: p_count => x_msg_count,
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 ;

Line 2374: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || '20001 error '||

2370: WHEN OTHERS THEN
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

Line 2380: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

2376: END IF;
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

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 2482: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);

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);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);

Line 2483: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);

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);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2487: arp_util.debug(' p_line_amount = ' || p_line_amount);

Line 2484: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);

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);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2487: arp_util.debug(' p_line_amount = ' || p_line_amount);
2488: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);

Line 2485: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

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);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2487: arp_util.debug(' p_line_amount = ' || p_line_amount);
2488: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2489: END IF;

Line 2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);

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);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2487: arp_util.debug(' p_line_amount = ' || p_line_amount);
2488: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2489: END IF;
2490:

Line 2487: arp_util.debug(' p_line_amount = ' || p_line_amount);

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);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2487: arp_util.debug(' p_line_amount = ' || p_line_amount);
2488: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2489: END IF;
2490:
2491: FND_PROFILE.get('USER_ID',l_user_id);

Line 2488: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);

2484: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2485: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2486: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2487: arp_util.debug(' p_line_amount = ' || p_line_amount);
2488: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2489: END IF;
2490:
2491: FND_PROFILE.get('USER_ID',l_user_id);
2492: IF l_user_id IS NULL

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 2666: arp_util.debug

2662: WHEN OTHERS then
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

Line 2672: arp_util.debug('transfer_salesrep_revenue: ' || 'Unexpected error '||sqlerrm||

2668: END IF;
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;

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 2728: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

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 */
2732: IF g_period_set_name IS NULL

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 2979: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);

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);
2983: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

Line 2980: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);

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);
2983: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
2984: END IF;

Line 2981: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);

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);
2983: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
2984: END IF;
2985: FND_PROFILE.get('USER_ID',l_user_id);

Line 2982: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

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);
2983: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
2984: END IF;
2985: FND_PROFILE.get('USER_ID',l_user_id);
2986: IF l_user_id IS NULL

Line 2983: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

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);
2983: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
2984: END IF;
2985: FND_PROFILE.get('USER_ID',l_user_id);
2986: IF l_user_id IS NULL
2987: THEN

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 3297: arp_util.debug

3293: WHEN OTHERS then
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

Line 3303: arp_util.debug('debit_credit: ' || 'Unexpected error '||sqlerrm||

3299: END IF;
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;

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 3400: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);

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);
3404: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

Line 3401: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);

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);
3404: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3405: END IF;

Line 3402: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);

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);
3404: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3405: END IF;
3406: FND_PROFILE.get('USER_ID',l_user_id);

Line 3403: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);

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);
3404: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3405: END IF;
3406: FND_PROFILE.get('USER_ID',l_user_id);
3407: IF l_user_id IS NULL

Line 3404: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

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);
3404: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3405: END IF;
3406: FND_PROFILE.get('USER_ID',l_user_id);
3407: IF l_user_id IS NULL
3408: THEN

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 3639: arp_util.debug

3635: WHEN OTHERS then
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

Line 3645: arp_util.debug('no_rule_debit_credit: ' || 'Unexpected error '||sqlerrm||

3641: END IF;
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;

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 3901: arp_util.debug

3897: WHEN OTHERS then
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

Line 3907: arp_util.debug('no_rule_debit_credit_no_sr: ' || 'Unexpected error '||sqlerrm||

3903: END IF;
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;

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 4166: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||

4162: l_api_name ,
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;

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 4423: arp_util.debug

4419: WHEN OTHERS then
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

Line 4429: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||

4425: END IF;
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;

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 4462: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||

4458: p_count => x_msg_count,
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 ;

Line 4475: arp_util.debug('Transfer_Revenue_Between_Lines: ' || '20001 error '||

4471: WHEN OTHERS THEN
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

Line 4481: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||

4477: END IF;
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

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 4566: arp_util.debug

4562: WHEN OTHERS THEN
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

Line 4572: arp_util.debug('reset_dist_percent: ' || 'Unexpected error '||sqlerrm||

4568: END IF;
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;

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 4710: arp_util.debug

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

Line 4716: arp_util.debug('create_adjustment: ' || 'Unexpected error '||sqlerrm||

4712: END IF;
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;

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 4918: arp_util.debug

4914: WHEN OTHERS THEN
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

Line 4924: arp_util.debug('cr_target_line_unearned: ' || 'Unexpected error '||sqlerrm||

4920: END IF;
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;

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 4962: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

Line 4963: arp_util.debug(' p_amount = ' || p_amount);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);

Line 4964: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
4968: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);

Line 4965: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
4968: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
4969: END IF;

Line 4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
4968: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
4969: END IF;
4970: IF p_amount <> 0 OR

Line 4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
4968: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
4969: END IF;
4970: IF p_amount <> 0 OR
4971: p_acctd_amount <> 0 /* 6325023 - rounding */

Line 4968: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);

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);
4966: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
4967: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
4968: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
4969: END IF;
4970: IF p_amount <> 0 OR
4971: p_acctd_amount <> 0 /* 6325023 - rounding */
4972: THEN

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 5086: arp_util.debug

5082: WHEN OTHERS THEN
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

Line 5092: arp_util.debug('insert_distribution: ' || 'Unexpected error '||sqlerrm||

5088: END IF;
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;

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 5134: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);

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);
5138: arp_util.debug(' p_type = ' || p_type);

Line 5135: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);

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);
5138: arp_util.debug(' p_type = ' || p_type);
5139: arp_util.debug(' p_amount = ' || p_amount);

Line 5136: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);

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);
5138: arp_util.debug(' p_type = ' || p_type);
5139: arp_util.debug(' p_amount = ' || p_amount);
5140: arp_util.debug(' p_percent = ' || p_percent);

Line 5137: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

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);
5138: arp_util.debug(' p_type = ' || p_type);
5139: arp_util.debug(' p_amount = ' || p_amount);
5140: arp_util.debug(' p_percent = ' || p_percent);
5141: END IF;

Line 5138: arp_util.debug(' p_type = ' || p_type);

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);
5138: arp_util.debug(' p_type = ' || p_type);
5139: arp_util.debug(' p_amount = ' || p_amount);
5140: arp_util.debug(' p_percent = ' || p_percent);
5141: END IF;
5142: OPEN get_salesrep_line_id;

Line 5139: arp_util.debug(' p_amount = ' || p_amount);

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);
5138: arp_util.debug(' p_type = ' || p_type);
5139: arp_util.debug(' p_amount = ' || p_amount);
5140: arp_util.debug(' p_percent = ' || p_percent);
5141: END IF;
5142: OPEN get_salesrep_line_id;
5143: FETCH get_salesrep_line_id INTO p_sales_credit_id;

Line 5140: arp_util.debug(' p_percent = ' || p_percent);

5136: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5137: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
5138: arp_util.debug(' p_type = ' || p_type);
5139: arp_util.debug(' p_amount = ' || p_amount);
5140: arp_util.debug(' p_percent = ' || p_percent);
5141: END IF;
5142: OPEN get_salesrep_line_id;
5143: FETCH get_salesrep_line_id INTO p_sales_credit_id;
5144: CLOSE get_salesrep_line_id;

Line 5189: arp_util.debug(' Inserted salescredit row w/ ID = ' ||

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);
5191: END IF;
5192:
5193: /* 6615118 - create model distribution if srep is revenue type

Line 5204: arp_util.debug(' cached values = ' || g_inventory_item_id ||

5200: IF NVL(g_line_id, -99) = p_cust_trx_line_id
5201: THEN
5202: /* already fetched these values, no nothing */
5203: IF PG_DEBUG in ('Y', 'C') THEN
5204: arp_util.debug(' cached values = ' || g_inventory_item_id ||
5205: ':' || g_memo_line_id || ':' || g_warehouse_id);
5206: END IF;
5207: ELSE
5208: /* fetch warehouse, etc for this line */

Line 5217: arp_util.debug(' retrieved values = ' || g_inventory_item_id ||

5213:
5214: g_line_id := p_cust_trx_line_id;
5215:
5216: IF PG_DEBUG in ('Y', 'C') THEN
5217: arp_util.debug(' retrieved values = ' || g_inventory_item_id ||
5218: ':' || g_memo_line_id || ':' || g_warehouse_id);
5219: END IF;
5220: END IF;
5221:

Line 5329: arp_util.debug(' Inserted ' || l_account_class ||

5325: arp_standard.sysparm.org_id
5326: );
5327:
5328: IF PG_DEBUG in ('Y', 'C') THEN
5329: arp_util.debug(' Inserted ' || l_account_class ||
5330: ' model dist with gl_dist_id = ' || l_gl_dist_id ||
5331: ' ccid = ' || l_ccid);
5332: END IF;
5333: END LOOP;

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 5352: arp_util.debug

5348: WHEN OTHERS THEN
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

Line 5358: arp_util.debug('insert_sales_credit: ' || 'Unexpected error '||sqlerrm||

5354: END IF;
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;

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 5539: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);

5535: FROM ar_revenue_adjustments
5536: WHERE revenue_adjustment_number = l_last_adj_num;
5537: END IF;
5538: IF PG_DEBUG in ('Y', 'C') THEN
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()-');

Line 5540: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);

5536: WHERE revenue_adjustment_number = l_last_adj_num;
5537: END IF;
5538: IF PG_DEBUG in ('Y', 'C') THEN
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;

Line 5541: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);

5537: END IF;
5538: IF PG_DEBUG in ('Y', 'C') THEN
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

Line 5542: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);

5538: IF PG_DEBUG in ('Y', 'C') THEN
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

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 5550: arp_util.debug

5546: WHEN OTHERS THEN
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

Line 5556: arp_util.debug('Record_Acceptance: ' || 'Unexpected error '||sqlerrm||

5552: END IF;
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;