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_RAAPI_UTIL dependencies on ARP_UTIL

Line 49: arp_util.debug('AR_RAAPI_UTIL.constant_system_values()+');

45: -- bug2117242 "meaning" is translatable column
46: -- AND ml.meaning = 'Inventory';
47:
48: BEGIN
49: arp_util.debug('AR_RAAPI_UTIL.constant_system_values()+');
50:
51: OPEN c_ar_app_id;
52: FETCH c_ar_app_id INTO g_ar_app_id;
53: CLOSE c_ar_app_id;

Line 85: arp_util.debug('Unexpected error '||sqlerrm||

81: g_system_cache_flag := 'Y';
82:
83: EXCEPTION
84: WHEN OTHERS THEN
85: arp_util.debug('Unexpected error '||sqlerrm||
86: ' at AR_RAAPI_UTIL.constant_system_values()+');
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88:
89: END Constant_System_Values;

Line 145: arp_util.debug('AR_RAAPI_UTIL.Constant_Trx_Values()+');

141: AND t.customer_trx_id = p_customer_trx_id;
142:
143: BEGIN
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_util.debug('AR_RAAPI_UTIL.Constant_Trx_Values()+');
146: END IF;
147:
148: OPEN c_trx;
149: FETCH c_trx INTO g_cust_trx_type_id

Line 168: arp_util.debug('Constant_Trx_Values: ' || 'Unexpected error '||sqlerrm||

164: EXCEPTION
165:
166: WHEN OTHERS then
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_util.debug('Constant_Trx_Values: ' || 'Unexpected error '||sqlerrm||
169: ' at AR_RAAPI_UTIL.constant_system_values()+');
170: END IF;
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172:

Line 186: arp_util.debug('AR_RAAPI_UTIL.Validate_Parameters()+');

182: IS
183: l_gl_date_valid DATE; -- Bug 2146970
184: BEGIN
185: IF PG_DEBUG in ('Y', 'C') THEN
186: arp_util.debug('AR_RAAPI_UTIL.Validate_Parameters()+');
187: END IF;
188: -- Initialize message list if p_init_msg_list is set to TRUE.
189: IF FND_API.to_Boolean( p_init_msg_list )
190: THEN

Line 269: arp_util.debug('Unexpected error '||sqlerrm||

265: END IF;
266: EXCEPTION
267: WHEN OTHERS THEN
268: IF PG_DEBUG in ('Y', 'C') THEN
269: arp_util.debug('Unexpected error '||sqlerrm||
270: ' at AR_RAAPI_UTIL.Validate_Parameters()+');
271: END IF;
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273:

Line 343: arp_util.debug('AR_RAAPI_UTIL.Validate_Transaction()+');

339: AND cm.previous_customer_trx_id = g_customer_trx_id;
340:
341: BEGIN
342: IF PG_DEBUG in ('Y', 'C') THEN
343: arp_util.debug('AR_RAAPI_UTIL.Validate_Transaction()+');
344: END IF;
345: -- Initialize message list if p_init_msg_list is set to TRUE.
346: IF FND_API.to_Boolean( p_init_msg_list )
347: THEN

Line 500: arp_util.debug('Validate_Transaction: ' || 'Unexpected error '||sqlerrm||

496: p_data => x_msg_data);
497: EXCEPTION
498: WHEN OTHERS THEN
499: IF PG_DEBUG in ('Y', 'C') THEN
500: arp_util.debug('Validate_Transaction: ' || 'Unexpected error '||sqlerrm||
501: ' at AR_RAAPI_UTIL.Validate_Transaction()+');
502: END IF;
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: END Validate_Transaction;

Line 609: arp_util.debug('AR_RAAPI_UTIL.Validate_Salesreps()+');

605: AND line_type = 'LINE';
606:
607: BEGIN
608: IF PG_DEBUG in ('Y', 'C') THEN
609: arp_util.debug('AR_RAAPI_UTIL.Validate_Salesreps()+');
610: END IF;
611: -- Initialize message list if p_init_msg_list is set to TRUE.
612: IF FND_API.to_Boolean( p_init_msg_list )
613: THEN

Line 809: arp_util.Get_Txn_Start_End_Dates(p_rev_adj_rec.customer_trx_id, l_group_start_date, l_group_end_date);

805: IF p_rev_adj_rec.adjustment_type IN ('NR','SA')
806: THEN
807: IF p_rev_adj_rec.to_salesgroup_id IS NOT NULL
808: THEN
809: arp_util.Get_Txn_Start_End_Dates(p_rev_adj_rec.customer_trx_id, l_group_start_date, l_group_end_date);
810: OPEN c_salesgroup_id(p_rev_adj_rec.to_salesgroup_id);
811: FETCH c_salesgroup_id INTO g_to_salesgroup_id;
812: IF c_salesgroup_id%NOTFOUND
813: THEN

Line 832: arp_util.debug('Validate_Salesreps: ' || 'Unexpected error '||sqlerrm||

828: p_data => x_msg_data);
829: EXCEPTION
830: WHEN OTHERS THEN
831: IF PG_DEBUG in ('Y', 'C') THEN
832: arp_util.debug('Validate_Salesreps: ' || 'Unexpected error '||sqlerrm||
833: ' at AR_RAAPI_UTIL.Validate_Salesreps()+');
834: END IF;
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END Validate_Salesreps;

Line 894: arp_util.debug('AR_RAAPI_UTIL.Validate_Category()+');

890: AND c.organization_id = g_inv_org_id;
891:
892: BEGIN
893: IF PG_DEBUG in ('Y', 'C') THEN
894: arp_util.debug('AR_RAAPI_UTIL.Validate_Category()+');
895: END IF;
896:
897: /* 5126974 - move initialization to this function
898: to avoid org-specific failure in constant_system_values */

Line 1156: arp_util.debug('Validate_Category: ' || 'Unexpected error '||sqlerrm||

1152: FND_MSG_PUB.Add;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: WHEN OTHERS THEN
1155: IF PG_DEBUG in ('Y', 'C') THEN
1156: arp_util.debug('Validate_Category: ' || 'Unexpected error '||sqlerrm||
1157: ' at AR_RAAPI_UTIL.Validate_Category()+');
1158: END IF;
1159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1160: END Validate_Category;

Line 1214: arp_util.debug('AR_RAAPI_UTIL.Validate_Item()+');

1210: AND line_type = 'LINE';
1211:
1212: BEGIN
1213: IF PG_DEBUG in ('Y', 'C') THEN
1214: arp_util.debug('AR_RAAPI_UTIL.Validate_Item()+');
1215: END IF;
1216: /* 5126974 - move initialization to this function
1217: to avoid org-specific failure in constant_system_values */
1218: IF g_inv_org_id IS NULL

Line 1475: arp_util.debug('Validate_Item: ' || 'Unexpected error '||sqlerrm||

1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_ERROR ;
1473: WHEN OTHERS THEN
1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: arp_util.debug('Validate_Item: ' || 'Unexpected error '||sqlerrm||
1476: ' at AR_RAAPI_UTIL.Validate_Item()+');
1477: END IF;
1478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1479: END Validate_Item;

Line 1505: arp_util.debug('AR_RAAPI_UTIL.Validate_Line()+');

1501: AND line_type = 'LINE';
1502:
1503: BEGIN
1504: IF PG_DEBUG in ('Y', 'C') THEN
1505: arp_util.debug('AR_RAAPI_UTIL.Validate_Line()+');
1506: END IF;
1507: -- Initialize message list if p_init_msg_list is set to TRUE.
1508: IF FND_API.to_Boolean( p_init_msg_list )
1509: THEN

Line 1559: arp_util.debug('Validate_Line: ' || 'Unexpected error '||sqlerrm||

1555: p_data => x_msg_data);
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: IF PG_DEBUG in ('Y', 'C') THEN
1559: arp_util.debug('Validate_Line: ' || 'Unexpected error '||sqlerrm||
1560: ' at AR_RAAPI_UTIL.Validate_Line()+');
1561: END IF;
1562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1563: END Validate_Line;

Line 1579: arp_util.debug('AR_RAAPI_UTIL.Validate_GL_Date()+');

1575: l_err_mesg VARCHAR2(2000);
1576:
1577: BEGIN
1578: IF PG_DEBUG in ('Y', 'C') THEN
1579: arp_util.debug('AR_RAAPI_UTIL.Validate_GL_Date()+');
1580: END IF;
1581: --
1582: -- Bug 2030914: need to allow NOT OPENNED periods
1583: -- changed p_allow_not_open_flag from 'N' to 'Y'

Line 1617: arp_util.debug('Validate_GL_Date: ' || 'Unexpected error '||sqlerrm||

1613: RETURN l_valid_gl_date;
1614: EXCEPTION
1615: WHEN OTHERS THEN
1616: IF PG_DEBUG in ('Y', 'C') THEN
1617: arp_util.debug('Validate_GL_Date: ' || 'Unexpected error '||sqlerrm||
1618: ' at AR_RAAPI_UTIL.Validate_GL_Date()+');
1619: END IF;
1620: RETURN NULL;
1621: END Validate_GL_Date;

Line 1630: arp_util.debug('AR_RAAPI_UTIL.bump_gl_date_if_closed()+');

1626: IS
1627:
1628: BEGIN
1629: IF PG_DEBUG in ('Y', 'C') THEN
1630: arp_util.debug('AR_RAAPI_UTIL.bump_gl_date_if_closed()+');
1631: END IF;
1632:
1633: /* Bug 3879222 - replaced proprietary logic with a call to
1634: arp_auto_rule.assign_gl_date. That routine caches

Line 1639: arp_util.debug('AR_RAAPI_UTIL.bump_gl_date_if_closed()-');

1635: dates and calendar to make for faster returns */
1636: RETURN arp_auto_rule.assign_gl_date(p_gl_date);
1637:
1638: IF PG_DEBUG in ('Y', 'C') THEN
1639: arp_util.debug('AR_RAAPI_UTIL.bump_gl_date_if_closed()-');
1640: END IF;
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: IF PG_DEBUG in ('Y', 'C') THEN

Line 1644: arp_util.debug('bump_gl_date_if_closed: ' || 'Unexpected error '||sqlerrm||

1640: END IF;
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: IF PG_DEBUG in ('Y', 'C') THEN
1644: arp_util.debug('bump_gl_date_if_closed: ' || 'Unexpected error '||sqlerrm||
1645: ' at AR_RAAPI_UTIL.bump_gl_date_if_closed()+');
1646: END IF;
1647: RETURN NULL;
1648: END bump_gl_date_if_closed;

Line 1663: arp_util.debug('AR_RAAPI_UTIL.Validate_Other()+');

1659: l_df_return_status VARCHAR2(1);
1660:
1661: BEGIN
1662: IF PG_DEBUG in ('Y', 'C') THEN
1663: arp_util.debug('AR_RAAPI_UTIL.Validate_Other()+');
1664: END IF;
1665: -- Initialize message list if p_init_msg_list is set to TRUE.
1666: IF FND_API.to_Boolean( p_init_msg_list )
1667: THEN

Line 1761: arp_util.debug('Validate_Other: ' || 'Unexpected error '||sqlerrm||

1757: p_data => x_msg_data);
1758: EXCEPTION
1759: WHEN OTHERS THEN
1760: IF PG_DEBUG in ('Y', 'C') THEN
1761: arp_util.debug('Validate_Other: ' || 'Unexpected error '||sqlerrm||
1762: ' at AR_RAAPI_UTIL.Validate_Other()+');
1763: END IF;
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765: END Validate_Other;

Line 1884: arp_util.debug('AR_RAAPI_UTIL.Validate_Sales_Credits()+');

1880: AND mic.category_set_id(+) = g_category_set_id;
1881:
1882: BEGIN
1883: IF PG_DEBUG in ('Y', 'C') THEN
1884: arp_util.debug('AR_RAAPI_UTIL.Validate_Sales_Credits()+');
1885: END IF;
1886: /* 5126974 - move initialization to this function
1887: to avoid org-specific failure in constant_system_values */
1888: IF g_inv_org_id IS NULL

Line 1918: arp_util.debug('Validate_Sales_Credits: ' || 'Unexpected error '||sqlerrm||

1914: p_data => x_msg_data);
1915: EXCEPTION
1916: WHEN OTHERS THEN
1917: IF PG_DEBUG in ('Y', 'C') THEN
1918: arp_util.debug('Validate_Sales_Credits: ' || 'Unexpected error '||sqlerrm||
1919: ' at AR_RAAPI_UTIL.Validate_Sales_Credits()+');
1920: END IF;
1921: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1922: END Validate_Sales_Credits;

Line 1969: arp_util.debug('AR_RAAPI_UTIL.Total_Selected_Line_Value()+');

1965: ls.non_revenue_percent_split,ls.revenue_percent_split),0)) <> 0));
1966:
1967: BEGIN
1968: IF PG_DEBUG in ('Y', 'C') THEN
1969: arp_util.debug('AR_RAAPI_UTIL.Total_Selected_Line_Value()+');
1970: END IF;
1971: /* 5126974 - move initialization to this function
1972: to avoid org-specific failure in constant_system_values */
1973: IF g_inv_org_id IS NULL

Line 1984: arp_util.debug('Total_Selected_Line_Value: ' || 'Unexpected error '||sqlerrm||

1980: RETURN l_all_line_total;
1981: EXCEPTION
1982: WHEN OTHERS THEN
1983: IF PG_DEBUG in ('Y', 'C') THEN
1984: arp_util.debug('Total_Selected_Line_Value: ' || 'Unexpected error '||sqlerrm||
1985: ' at AR_RAAPI_UTIL.Total_Selected_Line_Value()+');
1986: END IF;
1987: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1988: END Total_Selected_Line_Value ;

Line 2030: arp_util.debug('trx_id= ' || cm.customer_trx_id || ' dists=' ||

2026: p_trx_id => cm.customer_trx_id);
2027:
2028: IF PG_DEBUG in ('Y','C')
2029: THEN
2030: arp_util.debug('trx_id= ' || cm.customer_trx_id || ' dists=' ||
2031: l_dist_count);
2032: END IF;
2033: END LOOP;
2034:

Line 2227: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');

2223: NVL(s.revenue_salesgroup_id, -9999));
2224:
2225: BEGIN
2226: IF PG_DEBUG in ('Y', 'C') THEN
2227: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2228: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);

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

2224:
2225: BEGIN
2226: IF PG_DEBUG in ('Y', 'C') THEN
2227: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2228: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

Line 2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);

2225: BEGIN
2226: IF PG_DEBUG in ('Y', 'C') THEN
2227: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2228: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);

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

2226: IF PG_DEBUG in ('Y', 'C') THEN
2227: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2228: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);

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

2227: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2228: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);
2235: arp_util.debug(' p_category_id = ' || p_category_id);

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

2228: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);
2235: arp_util.debug(' p_category_id = ' || p_category_id);
2236: arp_util.debug(' p_revenue_adjustment_id = ' ||

Line 2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);

2229: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);
2235: arp_util.debug(' p_category_id = ' || p_category_id);
2236: arp_util.debug(' p_revenue_adjustment_id = ' ||
2237: p_revenue_adjustment_id);

Line 2234: arp_util.debug(' p_item_id = ' || p_item_id);

2230: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);
2235: arp_util.debug(' p_category_id = ' || p_category_id);
2236: arp_util.debug(' p_revenue_adjustment_id = ' ||
2237: p_revenue_adjustment_id);
2238: END IF;

Line 2235: arp_util.debug(' p_category_id = ' || p_category_id);

2231: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);
2235: arp_util.debug(' p_category_id = ' || p_category_id);
2236: arp_util.debug(' p_revenue_adjustment_id = ' ||
2237: p_revenue_adjustment_id);
2238: END IF;
2239:

Line 2236: arp_util.debug(' p_revenue_adjustment_id = ' ||

2232: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2233: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2234: arp_util.debug(' p_item_id = ' || p_item_id);
2235: arp_util.debug(' p_category_id = ' || p_category_id);
2236: arp_util.debug(' p_revenue_adjustment_id = ' ||
2237: p_revenue_adjustment_id);
2238: END IF;
2239:
2240: /* 5126974 - move initialization to this function

Line 2338: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);

2334:
2335: END LOOP;
2336:
2337: IF PG_DEBUG in ('Y', 'C') THEN
2338: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2339: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()-');
2340: END IF;
2341:
2342: RETURN l_adjustable_revenue;

Line 2339: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()-');

2335: END LOOP;
2336:
2337: IF PG_DEBUG in ('Y', 'C') THEN
2338: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2339: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()-');
2340: END IF;
2341:
2342: RETURN l_adjustable_revenue;
2343:

Line 2347: arp_util.debug('Adjustable_Revenue: ' || 'Unexpected error '||sqlerrm||

2343:
2344: EXCEPTION
2345: WHEN OTHERS THEN
2346: IF PG_DEBUG in ('Y', 'C') THEN
2347: arp_util.debug('Adjustable_Revenue: ' || 'Unexpected error '||sqlerrm||
2348: ' at AR_RAAPI_UTIL.Adjustable_Revenue()+');
2349: END IF;
2350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2351:

Line 2398: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()+');

2394: l_total_amt NUMBER;
2395:
2396: BEGIN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()+');
2399: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2400: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2401: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2402: arp_util.debug(' p_revenue_adjustment_id= ' || p_revenue_adjustment_id);

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

2395:
2396: BEGIN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()+');
2399: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2400: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2401: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2402: arp_util.debug(' p_revenue_adjustment_id= ' || p_revenue_adjustment_id);
2403: END IF;

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

2396: BEGIN
2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()+');
2399: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2400: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2401: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2402: arp_util.debug(' p_revenue_adjustment_id= ' || p_revenue_adjustment_id);
2403: END IF;
2404:

Line 2401: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);

2397: IF PG_DEBUG in ('Y', 'C') THEN
2398: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()+');
2399: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2400: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2401: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2402: arp_util.debug(' p_revenue_adjustment_id= ' || p_revenue_adjustment_id);
2403: END IF;
2404:
2405: /* DO not allow adjustments against certain regular credit memos */

Line 2402: arp_util.debug(' p_revenue_adjustment_id= ' || p_revenue_adjustment_id);

2398: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()+');
2399: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2400: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2401: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2402: arp_util.debug(' p_revenue_adjustment_id= ' || p_revenue_adjustment_id);
2403: END IF;
2404:
2405: /* DO not allow adjustments against certain regular credit memos */
2406: IF NOT check_credit_memos(p_customer_trx_id, p_adjustment_type)

Line 2425: arp_util.debug(' l_inv_amt = ' || l_inv_amt);

2421: l_total_amt := l_inv_amt + l_cm_amt;
2422:
2423: IF PG_DEBUG in ('Y', 'C') THEN
2424:
2425: arp_util.debug(' l_inv_amt = ' || l_inv_amt);
2426: arp_util.debug(' l_cm_amt = ' || l_cm_amt);
2427: arp_util.debug(' l_total_amt = ' || l_total_amt);
2428: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()-');
2429: END IF;

Line 2426: arp_util.debug(' l_cm_amt = ' || l_cm_amt);

2422:
2423: IF PG_DEBUG in ('Y', 'C') THEN
2424:
2425: arp_util.debug(' l_inv_amt = ' || l_inv_amt);
2426: arp_util.debug(' l_cm_amt = ' || l_cm_amt);
2427: arp_util.debug(' l_total_amt = ' || l_total_amt);
2428: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()-');
2429: END IF;
2430:

Line 2427: arp_util.debug(' l_total_amt = ' || l_total_amt);

2423: IF PG_DEBUG in ('Y', 'C') THEN
2424:
2425: arp_util.debug(' l_inv_amt = ' || l_inv_amt);
2426: arp_util.debug(' l_cm_amt = ' || l_cm_amt);
2427: arp_util.debug(' l_total_amt = ' || l_total_amt);
2428: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()-');
2429: END IF;
2430:
2431: RETURN l_total_amt;

Line 2428: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()-');

2424:
2425: arp_util.debug(' l_inv_amt = ' || l_inv_amt);
2426: arp_util.debug(' l_cm_amt = ' || l_cm_amt);
2427: arp_util.debug(' l_total_amt = ' || l_total_amt);
2428: arp_util.debug('AR_RAAPI_UTIL.revenue_amount_total()-');
2429: END IF;
2430:
2431: RETURN l_total_amt;
2432:

Line 2511: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');

2507:
2508:
2509: BEGIN
2510: IF PG_DEBUG in ('Y', 'C') THEN
2511: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2512: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

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

2508:
2509: BEGIN
2510: IF PG_DEBUG in ('Y', 'C') THEN
2511: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2512: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);

Line 2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);

2509: BEGIN
2510: IF PG_DEBUG in ('Y', 'C') THEN
2511: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2512: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);

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

2510: IF PG_DEBUG in ('Y', 'C') THEN
2511: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2512: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2518: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);

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

2511: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2512: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2518: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2519: END IF;

Line 2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);

2512: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2518: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2519: END IF;
2520:

Line 2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);

2513: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2518: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2519: END IF;
2520:
2521: /* 5126974 - move initialization to this function

Line 2518: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);

2514: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2515: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2516: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2517: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2518: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2519: END IF;
2520:
2521: /* 5126974 - move initialization to this function
2522: to avoid org-specific failure in constant_system_values */

Line 2575: arp_util.debug(' --- after internal validation/calcs ---');

2571: END IF;
2572:
2573: IF PG_DEBUG = 'Y'
2574: THEN
2575: arp_util.debug(' --- after internal validation/calcs ---');
2576: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2577: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2578: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2579: END IF;

Line 2576: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);

2572:
2573: IF PG_DEBUG = 'Y'
2574: THEN
2575: arp_util.debug(' --- after internal validation/calcs ---');
2576: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2577: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2578: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2579: END IF;
2580:

Line 2577: arp_util.debug(' l_revenue_total = ' || l_revenue_total);

2573: IF PG_DEBUG = 'Y'
2574: THEN
2575: arp_util.debug(' --- after internal validation/calcs ---');
2576: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2577: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2578: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2579: END IF;
2580:
2581: /* 7454302 - Allow adjustments of zero amounts

Line 2578: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);

2574: THEN
2575: arp_util.debug(' --- after internal validation/calcs ---');
2576: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2577: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2578: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2579: END IF;
2580:
2581: /* 7454302 - Allow adjustments of zero amounts
2582: IF p_revenue_amount_out = 0

Line 2658: arp_util.debug('Validate_Amount: ' || 'Unexpected error '||sqlerrm||

2654: p_count => x_msg_count,
2655: p_data => x_msg_data);
2656: WHEN OTHERS THEN
2657: IF PG_DEBUG in ('Y', 'C') THEN
2658: arp_util.debug('Validate_Amount: ' || 'Unexpected error '||sqlerrm||
2659: ' at AR_RAAPI_UTIL.Validate_Amount()+');
2660: END IF;
2661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2662:

Line 2684: arp_util.debug('AR_RAAPI_UTIL.Revalidate_GL_Dates()+');

2680: WHERE revenue_adjustment_id = p_revenue_adjustment_id;
2681:
2682: BEGIN
2683: IF PG_DEBUG in ('Y', 'C') THEN
2684: arp_util.debug('AR_RAAPI_UTIL.Revalidate_GL_Dates()+');
2685: END IF;
2686: l_change_count := 0;
2687: FOR c1 IN c_gl_date LOOP
2688: IF ARP_STANDARD.validate_and_default_gl_date

Line 2736: arp_util.debug('Revalidate_GL_Dates: ' || 'Unexpected error '||sqlerrm||

2732: END IF;
2733: EXCEPTION
2734: WHEN OTHERS THEN
2735: IF PG_DEBUG in ('Y', 'C') THEN
2736: arp_util.debug('Revalidate_GL_Dates: ' || 'Unexpected error '||sqlerrm||
2737: ' at AR_RAAPI_UTIL.Revalidate_GL_Dates()+');
2738: END IF;
2739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2740: END Revalidate_GL_Dates;

Line 2781: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()+');

2777: AND p.new_period_num = p_new_period_num;
2778:
2779: BEGIN
2780: IF PG_DEBUG in ('Y', 'C') THEN
2781: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()+');
2782: END IF;
2783: IF p_period_seq_no = 1
2784: THEN
2785: IF PG_DEBUG in ('Y', 'C') THEN

Line 2786: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()-');

2782: END IF;
2783: IF p_period_seq_no = 1
2784: THEN
2785: IF PG_DEBUG in ('Y', 'C') THEN
2786: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()-');
2787: END IF;
2788: RETURN p_start_date;
2789: ELSE
2790: -- Find the period relating to the start date of revenue recognition

Line 2804: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()-');

2800: l_current_gl_date := LEAST((p_start_date - l_init_start_date
2801: + l_current_start_date),
2802: l_current_end_date);
2803: IF PG_DEBUG in ('Y', 'C') THEN
2804: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()-');
2805: END IF;
2806: RETURN l_current_gl_date;
2807: END IF;
2808: EXCEPTION

Line 2811: arp_util.debug('Deferred_GL_Date: ' || 'Unexpected error '||sqlerrm||

2807: END IF;
2808: EXCEPTION
2809: WHEN OTHERS THEN
2810: IF PG_DEBUG in ('Y', 'C') THEN
2811: arp_util.debug('Deferred_GL_Date: ' || 'Unexpected error '||sqlerrm||
2812: ' at AR_RAAPI_UTIL.Deferred_GL_Date()+');
2813: END IF;
2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815: END Deferred_GL_Date;