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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2140: AND cmtl.autorule_complete_flag = 'N');
2141:
2142: BEGIN
2143: IF PG_DEBUG in ('Y', 'C') THEN
2144: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2145: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);

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

2141:
2142: BEGIN
2143: IF PG_DEBUG in ('Y', 'C') THEN
2144: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2145: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

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

2142: BEGIN
2143: IF PG_DEBUG in ('Y', 'C') THEN
2144: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2145: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);

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

2143: IF PG_DEBUG in ('Y', 'C') THEN
2144: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2145: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);

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

2144: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()+');
2145: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);
2152: arp_util.debug(' p_category_id = ' || p_category_id);

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

2145: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);
2152: arp_util.debug(' p_category_id = ' || p_category_id);
2153: arp_util.debug(' p_revenue_adjustment_id = ' ||

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

2146: arp_util.debug(' p_adjustment_type = ' || p_adjustment_type);
2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);
2152: arp_util.debug(' p_category_id = ' || p_category_id);
2153: arp_util.debug(' p_revenue_adjustment_id = ' ||
2154: p_revenue_adjustment_id);

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

2147: arp_util.debug(' p_customer_trx_id = ' || p_customer_trx_id);
2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);
2152: arp_util.debug(' p_category_id = ' || p_category_id);
2153: arp_util.debug(' p_revenue_adjustment_id = ' ||
2154: p_revenue_adjustment_id);
2155: END IF;

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

2148: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);
2152: arp_util.debug(' p_category_id = ' || p_category_id);
2153: arp_util.debug(' p_revenue_adjustment_id = ' ||
2154: p_revenue_adjustment_id);
2155: END IF;
2156:

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

2149: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2150: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2151: arp_util.debug(' p_item_id = ' || p_item_id);
2152: arp_util.debug(' p_category_id = ' || p_category_id);
2153: arp_util.debug(' p_revenue_adjustment_id = ' ||
2154: p_revenue_adjustment_id);
2155: END IF;
2156:
2157: /* 5126974 - move initialization to this function

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

2174: p_trx_id => cm.customer_trx_id);
2175:
2176: IF PG_DEBUG in ('Y','C')
2177: THEN
2178: arp_util.debug('trx_id= ' || cm.customer_trx_id || ' dists=' ||
2179: l_dist_count);
2180: END IF;
2181: END LOOP;
2182:

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

2257:
2258: END LOOP;
2259:
2260: IF PG_DEBUG in ('Y', 'C') THEN
2261: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2262: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()-');
2263: END IF;
2264:
2265: RETURN l_adjustable_revenue;

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

2258: END LOOP;
2259:
2260: IF PG_DEBUG in ('Y', 'C') THEN
2261: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2262: arp_util.debug('AR_RAAPI_UTIL.Adjustable_Revenue()-');
2263: END IF;
2264:
2265: RETURN l_adjustable_revenue;
2266:

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

2266:
2267: EXCEPTION
2268: WHEN OTHERS THEN
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: arp_util.debug('Adjustable_Revenue: ' || 'Unexpected error '||sqlerrm||
2271: ' at AR_RAAPI_UTIL.Adjustable_Revenue()+');
2272: END IF;
2273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2274:

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

2349:
2350:
2351: BEGIN
2352: IF PG_DEBUG in ('Y', 'C') THEN
2353: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2354: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);

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

2350:
2351: BEGIN
2352: IF PG_DEBUG in ('Y', 'C') THEN
2353: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2354: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);

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

2351: BEGIN
2352: IF PG_DEBUG in ('Y', 'C') THEN
2353: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2354: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2359: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);

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

2352: IF PG_DEBUG in ('Y', 'C') THEN
2353: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2354: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2359: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2360: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);

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

2353: arp_util.debug('AR_RAAPI_UTIL.Validate_Amount()+');
2354: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2359: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2360: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2361: END IF;

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

2354: arp_util.debug(' p_customer_trx_line_id = ' || p_customer_trx_line_id);
2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2359: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2360: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2361: END IF;
2362:

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

2355: arp_util.debug(' p_amount_mode = ' || p_amount_mode);
2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2359: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2360: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2361: END IF;
2362:
2363: /* 5126974 - move initialization to this function

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

2356: arp_util.debug(' p_salesrep_id = ' || p_salesrep_id);
2357: arp_util.debug(' p_salesgroup_id = ' || p_salesgroup_id);
2358: arp_util.debug(' p_sales_credit_type = ' || p_sales_credit_type);
2359: arp_util.debug(' p_revenue_amount_in = ' || p_revenue_amount_in);
2360: arp_util.debug(' p_revenue_percent = ' || p_revenue_percent);
2361: END IF;
2362:
2363: /* 5126974 - move initialization to this function
2364: to avoid org-specific failure in constant_system_values */

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

2413: END IF;
2414:
2415: IF PG_DEBUG = 'Y'
2416: THEN
2417: arp_util.debug(' --- after internal validation/calcs ---');
2418: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2419: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2420: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2421: END IF;

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

2414:
2415: IF PG_DEBUG = 'Y'
2416: THEN
2417: arp_util.debug(' --- after internal validation/calcs ---');
2418: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2419: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2420: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2421: END IF;
2422:

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

2415: IF PG_DEBUG = 'Y'
2416: THEN
2417: arp_util.debug(' --- after internal validation/calcs ---');
2418: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2419: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2420: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2421: END IF;
2422:
2423: IF p_revenue_amount_out = 0

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

2416: THEN
2417: arp_util.debug(' --- after internal validation/calcs ---');
2418: arp_util.debug(' l_adjustable_revenue = ' || l_adjustable_revenue);
2419: arp_util.debug(' l_revenue_total = ' || l_revenue_total);
2420: arp_util.debug(' p_revenue_amount_out = ' || p_revenue_amount_out);
2421: END IF;
2422:
2423: IF p_revenue_amount_out = 0
2424: THEN

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

2495: p_count => x_msg_count,
2496: p_data => x_msg_data);
2497: WHEN OTHERS THEN
2498: IF PG_DEBUG in ('Y', 'C') THEN
2499: arp_util.debug('Validate_Amount: ' || 'Unexpected error '||sqlerrm||
2500: ' at AR_RAAPI_UTIL.Validate_Amount()+');
2501: END IF;
2502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2503:

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

2521: WHERE revenue_adjustment_id = p_revenue_adjustment_id;
2522:
2523: BEGIN
2524: IF PG_DEBUG in ('Y', 'C') THEN
2525: arp_util.debug('AR_RAAPI_UTIL.Revalidate_GL_Dates()+');
2526: END IF;
2527: l_change_count := 0;
2528: FOR c1 IN c_gl_date LOOP
2529: IF ARP_STANDARD.validate_and_default_gl_date

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

2572: END IF;
2573: EXCEPTION
2574: WHEN OTHERS THEN
2575: IF PG_DEBUG in ('Y', 'C') THEN
2576: arp_util.debug('Revalidate_GL_Dates: ' || 'Unexpected error '||sqlerrm||
2577: ' at AR_RAAPI_UTIL.Revalidate_GL_Dates()+');
2578: END IF;
2579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2580: END Revalidate_GL_Dates;

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

2617: AND p.new_period_num = p_new_period_num;
2618:
2619: BEGIN
2620: IF PG_DEBUG in ('Y', 'C') THEN
2621: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()+');
2622: END IF;
2623: IF p_period_seq_no = 1
2624: THEN
2625: IF PG_DEBUG in ('Y', 'C') THEN

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

2622: END IF;
2623: IF p_period_seq_no = 1
2624: THEN
2625: IF PG_DEBUG in ('Y', 'C') THEN
2626: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()-');
2627: END IF;
2628: RETURN p_start_date;
2629: ELSE
2630: -- Find the period relating to the start date of revenue recognition

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

2640: l_current_gl_date := LEAST((p_start_date - l_init_start_date
2641: + l_current_start_date),
2642: l_current_end_date);
2643: IF PG_DEBUG in ('Y', 'C') THEN
2644: arp_util.debug('AR_RAAPI_UTIL.Deferred_GL_Date()-');
2645: END IF;
2646: RETURN l_current_gl_date;
2647: END IF;
2648: EXCEPTION

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

2647: END IF;
2648: EXCEPTION
2649: WHEN OTHERS THEN
2650: IF PG_DEBUG in ('Y', 'C') THEN
2651: arp_util.debug('Deferred_GL_Date: ' || 'Unexpected error '||sqlerrm||
2652: ' at AR_RAAPI_UTIL.Deferred_GL_Date()+');
2653: END IF;
2654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2655: END Deferred_GL_Date;