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: arp_util.debug(' p_rev_adj_rec.sales_credit_type = ' ||
228: p_rev_adj_rec.sales_credit_type);
229: END IF;
230: -- Standard Start of API savepoint

Line 227: arp_util.debug(' p_rev_adj_rec.sales_credit_type = ' ||

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

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

235: l_api_name ,
236: G_PKG_NAME )
237: THEN
238: IF PG_DEBUG in ('Y', 'C') THEN
239: arp_util.debug('Earn_Revenue: ' || 'Unexpected error '||sqlerrm||
240: ' at AR_Revenue_Adjustment_PVT.Earn_Revenue()+');
241: END IF;
242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
243: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 516: arp_util.debug(' p_rev_adj_rec.sales_credit_type = ' ||

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

Line 568: arp_util.debug('original gl_date = ' || l_rev_adj_rec.gl_date);

564: (p_gl_date => l_rev_adj_rec.gl_date);
565:
566: IF PG_DEBUG in ('Y','C')
567: THEN
568: arp_util.debug('original gl_date = ' || l_rev_adj_rec.gl_date);
569: arp_util.debug('new gl_date = ' || l_gl_date_valid);
570: END IF;
571:
572: IF l_gl_date_valid IS NULL

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

565:
566: IF PG_DEBUG in ('Y','C')
567: THEN
568: arp_util.debug('original gl_date = ' || l_rev_adj_rec.gl_date);
569: arp_util.debug('new gl_date = ' || l_gl_date_valid);
570: END IF;
571:
572: IF l_gl_date_valid IS NULL
573: THEN

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

586: (p_rev_adj_rec => l_rev_adj_rec
587: ,x_adjustment_id => x_adjustment_id
588: ,x_adjustment_number => x_adjustment_number);
589: IF PG_DEBUG in ('Y', 'C') THEN
590: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
591: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
592: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
593: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
594: END IF;

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

587: ,x_adjustment_id => x_adjustment_id
588: ,x_adjustment_number => x_adjustment_number);
589: IF PG_DEBUG in ('Y', 'C') THEN
590: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
591: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
592: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
593: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
594: END IF;
595: /* Bug 2560048 RAM-C - if api call not from collectibility engine

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

588: ,x_adjustment_number => x_adjustment_number);
589: IF PG_DEBUG in ('Y', 'C') THEN
590: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
591: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
592: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
593: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
594: END IF;
595: /* Bug 2560048 RAM-C - if api call not from collectibility engine
596: then the transaction must be recorded as manually overridden */

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

589: IF PG_DEBUG in ('Y', 'C') THEN
590: arp_util.debug('revenue_adjustment_id : '||x_adjustment_id);
591: arp_util.debug('revenue_adjustment_number : '||x_adjustment_number);
592: arp_util.debug('g_rev_mgt_installed : '||g_rev_mgt_installed);
593: arp_util.debug('p_rev_adj_rec.source : '||p_rev_adj_rec.source);
594: END IF;
595: /* Bug 2560048 RAM-C - if api call not from collectibility engine
596: then the transaction must be recorded as manually overridden */
597: /* Bug 2650708 - cater for null source value, and only call if

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

623: x_adjustment_id := NULL;
624: x_adjustment_number := NULL;
625: END IF;
626: IF PG_DEBUG in ('Y', 'C') THEN
627: arp_util.debug('x_return_status : '||x_return_status);
628: END IF;
629: /* Bug 2651996 - a null return status is being passed back from revenue
630: synchronizer - assume successful */
631: IF x_return_status IS NULL

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

632: THEN
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634: END IF;
635: IF PG_DEBUG in ('Y', 'C') THEN
636: arp_util.debug('x_return_status : '||x_return_status);
637: END IF;
638:
639: IF p_rev_adj_rec.adjustment_type = 'EA'
640: THEN

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

887: /* This call will round each adjustment that has be
888: previously recorded in ar_rev_line_adj_gt */
889: IF (arp_rounding.correct_rev_adj_by_line = 0)
890: THEN
891: arp_util.debug('ERROR: arp_rounding.correct_rev_adj_by_line');
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893: END IF;
894: END IF;
895:

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

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

Line 907: arp_util.debug

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

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

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

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

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

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

1293: l_api_name ,
1294: G_PKG_NAME )
1295: THEN
1296: IF PG_DEBUG in ('Y', 'C') THEN
1297: arp_util.debug('Transfer_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1298: ' at AR_Revenue_Adjustment_PVT.Transfer_Sales_Credits()+');
1299: END IF;
1300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1301: END IF;

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

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

Line 1582: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');

1578: (l_line_percent + l_revenue_percent_split_new > 100 OR
1579: l_line_percent + l_revenue_percent_split_new < -100)
1580: THEN
1581: IF PG_DEBUG in ('Y', 'C') THEN
1582: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1583: arp_util.debug(' l_line_amount = ' || l_line_amount);
1584: arp_util.debug(' l_revenue_percent_split = ' ||
1585: l_revenue_percent_split);
1586: arp_util.debug(' l_line_percent = ' || l_line_percent);

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

1579: l_line_percent + l_revenue_percent_split_new < -100)
1580: THEN
1581: IF PG_DEBUG in ('Y', 'C') THEN
1582: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1583: arp_util.debug(' l_line_amount = ' || l_line_amount);
1584: arp_util.debug(' l_revenue_percent_split = ' ||
1585: l_revenue_percent_split);
1586: arp_util.debug(' l_line_percent = ' || l_line_percent);
1587: arp_util.debug(' l_revenue_percent_split_new = ' ||

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

1580: THEN
1581: IF PG_DEBUG in ('Y', 'C') THEN
1582: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1583: arp_util.debug(' l_line_amount = ' || l_line_amount);
1584: arp_util.debug(' l_revenue_percent_split = ' ||
1585: l_revenue_percent_split);
1586: arp_util.debug(' l_line_percent = ' || l_line_percent);
1587: arp_util.debug(' l_revenue_percent_split_new = ' ||
1588: l_revenue_percent_split_new);

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

1582: arp_util.debug('pseudo-EXCEPTION: Percent <> 100');
1583: arp_util.debug(' l_line_amount = ' || l_line_amount);
1584: arp_util.debug(' l_revenue_percent_split = ' ||
1585: l_revenue_percent_split);
1586: arp_util.debug(' l_line_percent = ' || l_line_percent);
1587: arp_util.debug(' l_revenue_percent_split_new = ' ||
1588: l_revenue_percent_split_new);
1589: END IF;
1590: -- RAISE invalid_percent;

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

1583: arp_util.debug(' l_line_amount = ' || l_line_amount);
1584: arp_util.debug(' l_revenue_percent_split = ' ||
1585: l_revenue_percent_split);
1586: arp_util.debug(' l_line_percent = ' || l_line_percent);
1587: arp_util.debug(' l_revenue_percent_split_new = ' ||
1588: l_revenue_percent_split_new);
1589: END IF;
1590: -- RAISE invalid_percent;
1591: END IF;

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

1725: l_percent_prorata :=
1726: ROUND((l_amount_prorata / c1.amount) * 100,4);
1727: /* Added these debug messages as part of bug 6932079 */
1728: IF PG_DEBUG in ('Y', 'C') THEN
1729: arp_util.debug('l_amount_prorata = ' || l_amount_prorata);
1730: arp_util.debug('l_percent_prorata = ' || l_percent_prorata);
1731: END IF;
1732:
1733: IF l_amount_prorata <> 0

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

1726: ROUND((l_amount_prorata / c1.amount) * 100,4);
1727: /* Added these debug messages as part of bug 6932079 */
1728: IF PG_DEBUG in ('Y', 'C') THEN
1729: arp_util.debug('l_amount_prorata = ' || l_amount_prorata);
1730: arp_util.debug('l_percent_prorata = ' || l_percent_prorata);
1731: END IF;
1732:
1733: IF l_amount_prorata <> 0
1734: THEN

Line 1984: arp_util.debug

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2221: l_api_name ,
2222: G_PKG_NAME )
2223: THEN
2224: IF PG_DEBUG in ('Y', 'C') THEN
2225: arp_util.debug('Add_Non_Revenue_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
2226: ' at AR_Revenue_Adjustment_PVT.Add_Non_Revenue_Sales_Credits()+');
2227: END IF;
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;

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

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

Line 2398: arp_util.debug

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2556: BEGIN
2557: IF PG_DEBUG in ('Y', 'C') THEN
2558: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2559: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2560: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2563: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2564: arp_util.debug(' p_line_amount = ' || p_line_amount);

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

2557: IF PG_DEBUG in ('Y', 'C') THEN
2558: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2559: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2560: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2563: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2564: arp_util.debug(' p_line_amount = ' || p_line_amount);
2565: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);

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

2558: arp_util.debug('AR_Revenue_Adjustment_PVT.transfer_salesrep_revenue()+');
2559: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2560: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2563: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2564: arp_util.debug(' p_line_amount = ' || p_line_amount);
2565: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2566: END IF;

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

2559: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2560: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2563: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2564: arp_util.debug(' p_line_amount = ' || p_line_amount);
2565: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2566: END IF;
2567:

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

2560: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2563: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2564: arp_util.debug(' p_line_amount = ' || p_line_amount);
2565: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2566: END IF;
2567:
2568: FND_PROFILE.get('USER_ID',l_user_id);

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

2561: arp_util.debug(' p_sales_credit_id = ' || p_sales_credit_id);
2562: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
2563: arp_util.debug(' p_revenue_acctd_amount = ' || p_revenue_acctd_amount);
2564: arp_util.debug(' p_line_amount = ' || p_line_amount);
2565: arp_util.debug(' p_line_amount_acctd = ' || p_line_amount_acctd);
2566: END IF;
2567:
2568: FND_PROFILE.get('USER_ID',l_user_id);
2569: IF l_user_id IS NULL

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

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

Line 2743: arp_util.debug

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

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

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

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

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

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

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

Line 2897: arp_util.debug('Setting RSD from ' || p_rule_start_date ||

2893: p_deferred_revenue_flag = 'Y' AND
2894: p_original_gl_date <> p_rule_start_date
2895: THEN
2896: IF PG_DEBUG in ('Y', 'C') THEN
2897: arp_util.debug('Setting RSD from ' || p_rule_start_date ||
2898: ' to ' || p_original_gl_date);
2899: END IF;
2900: /* update ra_customer_trx_lines to set RSD to override */
2901: UPDATE ra_customer_trx_lines

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

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

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

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

Line 3021: arp_util.debug('Setting RSD back from ' || p_original_gl_date ||

3017: p_deferred_revenue_flag = 'Y' AND
3018: p_original_gl_date <> p_rule_start_date
3019: THEN
3020: IF PG_DEBUG in ('Y', 'C') THEN
3021: arp_util.debug('Setting RSD back from ' || p_original_gl_date ||
3022: ' to ' || p_rule_start_date);
3023: END IF;
3024: /* update ra_customer_trx_lines to return RSD to original */
3025: UPDATE ra_customer_trx_lines

Line 3031: arp_util.debug('Total lines inserted: ' || rows);

3027: WHERE customer_trx_line_id = p_customer_trx_line_id;
3028: END IF;
3029:
3030: IF PG_DEBUG in ('Y', 'C') THEN
3031: arp_util.debug('Total lines inserted: ' || rows);
3032: arp_util.debug('AR_Revenue_Adjustment_PVT.dists_by_model()+');
3033: END IF;
3034:
3035: /* Note: rounding will be handled at the transaction level

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

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

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

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

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

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

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

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

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

3162: IF PG_DEBUG in ('Y', 'C') THEN
3163: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()+');
3164: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3165: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3166: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3167: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3168: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3169: END IF;
3170: FND_PROFILE.get('USER_ID',l_user_id);

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

3163: arp_util.debug('AR_Revenue_Adjustment_PVT.debit_credit()+');
3164: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3165: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3166: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3167: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3168: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3169: END IF;
3170: FND_PROFILE.get('USER_ID',l_user_id);
3171: IF l_user_id IS NULL

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

3164: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3165: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3166: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3167: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3168: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3169: END IF;
3170: FND_PROFILE.get('USER_ID',l_user_id);
3171: IF l_user_id IS NULL
3172: THEN

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

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

Line 3489: arp_util.debug

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

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

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

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

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

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

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

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

3590: BEGIN
3591: IF PG_DEBUG in ('Y', 'C') THEN
3592: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3593: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3594: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3595: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3596: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3597: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3598: END IF;

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

3591: IF PG_DEBUG in ('Y', 'C') THEN
3592: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3593: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3594: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3595: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3596: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3597: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3598: END IF;
3599: FND_PROFILE.get('USER_ID',l_user_id);

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

3592: arp_util.debug('AR_Revenue_Adjustment_PVT.no_rule_debit_credit()+');
3593: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3594: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3595: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3596: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3597: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3598: END IF;
3599: FND_PROFILE.get('USER_ID',l_user_id);
3600: IF l_user_id IS NULL

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

3593: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
3594: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
3595: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
3596: arp_util.debug(' p_revenue_amount = ' || p_revenue_amount);
3597: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
3598: END IF;
3599: FND_PROFILE.get('USER_ID',l_user_id);
3600: IF l_user_id IS NULL
3601: THEN

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

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

Line 3840: arp_util.debug

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

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

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

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

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

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

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

Line 4116: arp_util.debug

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

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

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

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

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

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

4378: l_api_name ,
4379: G_PKG_NAME )
4380: THEN
4381: IF PG_DEBUG in ('Y', 'C') THEN
4382: arp_util.debug('Transfer_Revenue_Between_Lines: ' || 'Unexpected error '||sqlerrm||
4383: ' at AR_Revenue_Adjustment_PVT.Transfer_Revenue_Between_Lines()+');
4384: END IF;
4385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4386: END IF;

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

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

Line 4648: arp_util.debug

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4791: arp_util.debug

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

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

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

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

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

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

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

Line 4935: arp_util.debug

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

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

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

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

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

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

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

Line 5143: arp_util.debug

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

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

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

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

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

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

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

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

5184: BEGIN
5185: IF PG_DEBUG in ('Y', 'C') THEN
5186: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()+');
5187: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
5188: arp_util.debug(' p_amount = ' || p_amount);
5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);
5191: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
5192: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);

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

5185: IF PG_DEBUG in ('Y', 'C') THEN
5186: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()+');
5187: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
5188: arp_util.debug(' p_amount = ' || p_amount);
5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);
5191: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
5192: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
5193: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);

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

5186: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_distribution()+');
5187: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
5188: arp_util.debug(' p_amount = ' || p_amount);
5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);
5191: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
5192: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
5193: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
5194: END IF;

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

5187: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
5188: arp_util.debug(' p_amount = ' || p_amount);
5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);
5191: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
5192: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
5193: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
5194: END IF;
5195:

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

5188: arp_util.debug(' p_amount = ' || p_amount);
5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);
5191: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
5192: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
5193: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
5194: END IF;
5195:
5196: FND_PROFILE.get('USER_ID',l_user_id);

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

5189: arp_util.debug(' p_acctd_amount = ' || p_acctd_amount);
5190: arp_util.debug(' p_cust_trx_line_salesrep_id = ' || p_cust_trx_line_salesrep_id);
5191: arp_util.debug(' p_adjustment_id = ' || p_adjustment_id);
5192: arp_util.debug(' g_update_db_flag = ' || g_update_db_flag);
5193: arp_util.debug(' p_rounding_flag = ' || p_rounding_flag);
5194: END IF;
5195:
5196: FND_PROFILE.get('USER_ID',l_user_id);
5197: IF l_user_id IS NULL

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

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

Line 5307: arp_util.debug

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

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

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

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

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

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

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

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

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

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

5353: IF PG_DEBUG in ('Y', 'C') THEN
5354: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5355: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
5356: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);
5357: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5358: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
5359: arp_util.debug(' p_type = ' || p_type);
5360: arp_util.debug(' p_amount = ' || p_amount);
5361: arp_util.debug(' p_percent = ' || p_percent);

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

5354: arp_util.debug('AR_Revenue_Adjustment_PVT.insert_sales_credit()+');
5355: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
5356: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);
5357: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5358: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
5359: arp_util.debug(' p_type = ' || p_type);
5360: arp_util.debug(' p_amount = ' || p_amount);
5361: arp_util.debug(' p_percent = ' || p_percent);
5362: END IF;

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

5355: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
5356: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);
5357: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5358: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
5359: arp_util.debug(' p_type = ' || p_type);
5360: arp_util.debug(' p_amount = ' || p_amount);
5361: arp_util.debug(' p_percent = ' || p_percent);
5362: END IF;
5363: OPEN get_salesrep_line_id;

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

5356: arp_util.debug(' p_cust_trx_line_id = ' || p_cust_trx_line_id);
5357: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5358: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
5359: arp_util.debug(' p_type = ' || p_type);
5360: arp_util.debug(' p_amount = ' || p_amount);
5361: arp_util.debug(' p_percent = ' || p_percent);
5362: END IF;
5363: OPEN get_salesrep_line_id;
5364: FETCH get_salesrep_line_id INTO p_sales_credit_id;

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

5357: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
5358: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
5359: arp_util.debug(' p_type = ' || p_type);
5360: arp_util.debug(' p_amount = ' || p_amount);
5361: arp_util.debug(' p_percent = ' || p_percent);
5362: END IF;
5363: OPEN get_salesrep_line_id;
5364: FETCH get_salesrep_line_id INTO p_sales_credit_id;
5365: CLOSE get_salesrep_line_id;

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

5406: ,p_adjustment_id
5407: ,arp_standard.sysparm.org_id);
5408:
5409: IF PG_DEBUG in ('Y', 'C') THEN
5410: arp_util.debug(' Inserted salescredit row w/ ID = ' ||
5411: p_sales_credit_id);
5412: END IF;
5413:
5414: /* 6615118 - create model distribution if srep is revenue type

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

5421: IF NVL(g_line_id, -99) = p_cust_trx_line_id
5422: THEN
5423: /* already fetched these values, no nothing */
5424: IF PG_DEBUG in ('Y', 'C') THEN
5425: arp_util.debug(' cached values = ' || g_inventory_item_id ||
5426: ':' || g_memo_line_id || ':' || g_warehouse_id);
5427: END IF;
5428: ELSE
5429: /* fetch warehouse, etc for this line */

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

5434:
5435: g_line_id := p_cust_trx_line_id;
5436:
5437: IF PG_DEBUG in ('Y', 'C') THEN
5438: arp_util.debug(' retrieved values = ' || g_inventory_item_id ||
5439: ':' || g_memo_line_id || ':' || g_warehouse_id);
5440: END IF;
5441: END IF;
5442:

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

5546: arp_standard.sysparm.org_id
5547: );
5548:
5549: IF PG_DEBUG in ('Y', 'C') THEN
5550: arp_util.debug(' Inserted ' || l_account_class ||
5551: ' model dist with gl_dist_id = ' || l_gl_dist_id ||
5552: ' ccid = ' || l_ccid);
5553: END IF;
5554: END LOOP;

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

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

Line 5573: arp_util.debug

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

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

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

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

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

Line 5760: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);

5756: FROM ar_revenue_adjustments
5757: WHERE revenue_adjustment_number = l_last_adj_num;
5758: END IF;
5759: IF PG_DEBUG in ('Y', 'C') THEN
5760: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);
5761: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);
5762: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);
5763: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);
5764: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');

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

5757: WHERE revenue_adjustment_number = l_last_adj_num;
5758: END IF;
5759: IF PG_DEBUG in ('Y', 'C') THEN
5760: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);
5761: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);
5762: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);
5763: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);
5764: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');
5765: END IF;

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

5758: END IF;
5759: IF PG_DEBUG in ('Y', 'C') THEN
5760: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);
5761: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);
5762: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);
5763: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);
5764: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');
5765: END IF;
5766: EXCEPTION

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

5759: IF PG_DEBUG in ('Y', 'C') THEN
5760: arp_util.debug('Record_Acceptance: ' || 'l_first_adj_num = '||l_first_adj_num);
5761: arp_util.debug('Record_Acceptance: ' || 'l_last_adj_num = '||l_last_adj_num);
5762: arp_util.debug('Record_Acceptance: ' || 'x_first_rev_adj_id = '||x_first_rev_adj_id);
5763: arp_util.debug('Record_Acceptance: ' || 'x_last_rev_adj_id = '||x_last_rev_adj_id);
5764: arp_util.debug('AR_Revenue_Adjustment_PVT.record_acceptance()-');
5765: END IF;
5766: EXCEPTION
5767: WHEN OTHERS THEN

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

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

Line 5771: arp_util.debug

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

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

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