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 AR_RAAPI_UTIL

Line 1: PACKAGE BODY AR_RAAPI_UTIL AS

1: PACKAGE BODY AR_RAAPI_UTIL AS
2: /*$Header: ARXRAAUB.pls 120.28.12010000.8 2008/10/30 10:30:21 nproddut ship $*/
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: /* 5011151 - global for use_inv_acctg */

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 86: ' at AR_RAAPI_UTIL.constant_system_values()+');

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;
90:

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 169: ' at AR_RAAPI_UTIL.constant_system_values()+');

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:
173: END Constant_Trx_Values;

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 202: IF NVL(AR_RAAPI_UTIL.g_last_customer_trx_id,

198: ,x_msg_count => x_msg_count
199: ,x_msg_data => x_msg_data);
200: IF x_return_status = FND_API.G_RET_STS_SUCCESS
201: THEN
202: IF NVL(AR_RAAPI_UTIL.g_last_customer_trx_id,
203: AR_RAAPI_UTIL.g_customer_trx_id - 1) <> AR_RAAPI_UTIL.g_customer_trx_id
204: THEN
205: Constant_Trx_Values(AR_RAAPI_UTIL.g_customer_trx_id);
206: END IF;

Line 203: AR_RAAPI_UTIL.g_customer_trx_id - 1) <> AR_RAAPI_UTIL.g_customer_trx_id

199: ,x_msg_data => x_msg_data);
200: IF x_return_status = FND_API.G_RET_STS_SUCCESS
201: THEN
202: IF NVL(AR_RAAPI_UTIL.g_last_customer_trx_id,
203: AR_RAAPI_UTIL.g_customer_trx_id - 1) <> AR_RAAPI_UTIL.g_customer_trx_id
204: THEN
205: Constant_Trx_Values(AR_RAAPI_UTIL.g_customer_trx_id);
206: END IF;
207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL

Line 205: Constant_Trx_Values(AR_RAAPI_UTIL.g_customer_trx_id);

201: THEN
202: IF NVL(AR_RAAPI_UTIL.g_last_customer_trx_id,
203: AR_RAAPI_UTIL.g_customer_trx_id - 1) <> AR_RAAPI_UTIL.g_customer_trx_id
204: THEN
205: Constant_Trx_Values(AR_RAAPI_UTIL.g_customer_trx_id);
206: END IF;
207: IF p_validation_level = FND_API.G_VALID_LEVEL_FULL
208: THEN
209: Validate_Salesreps (p_init_msg_list => FND_API.G_FALSE

Line 270: ' at AR_RAAPI_UTIL.Validate_Parameters()+');

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:
274: END Validate_Parameters;

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 501: ' at AR_RAAPI_UTIL.Validate_Transaction()+');

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;
505:

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 833: ' at AR_RAAPI_UTIL.Validate_Salesreps()+');

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;
837:

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 1157: ' at AR_RAAPI_UTIL.Validate_Category()+');

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;
1161:

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 1476: ' at AR_RAAPI_UTIL.Validate_Item()+');

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;
1480:

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 1560: ' at AR_RAAPI_UTIL.Validate_Line()+');

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;
1564:

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 1599: p_application_id => AR_RAAPI_UTIL.application_id,

1595: default_date3 => NULL,
1596: p_allow_not_open_flag => 'Y',
1597: p_invoicing_rule_id => g_invoicing_rule_id,
1598: p_set_of_books_id => arp_global.sysparam.set_of_books_id,
1599: p_application_id => AR_RAAPI_UTIL.application_id,
1600: default_gl_date => l_valid_gl_date,
1601: defaulting_rule_used => l_default_rule,
1602: error_message => l_err_mesg)
1603: THEN

Line 1617: ' at AR_RAAPI_UTIL.Validate_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;
1621:

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 1644: ' at AR_RAAPI_UTIL.bump_gl_date_if_closed()+');

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;
1648:

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 1761: ' at AR_RAAPI_UTIL.Validate_Other()+');

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;
1765:

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 1918: ' at AR_RAAPI_UTIL.Validate_Sales_Credits()+');

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;
1922:

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 1984: ' at AR_RAAPI_UTIL.Total_Selected_Line_Value()+');

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 ;
1988:

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 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 2271: ' at AR_RAAPI_UTIL.Adjustable_Revenue()+');

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:
2275: END Adjustable_Revenue;

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 2500: ' at AR_RAAPI_UTIL.Validate_Amount()+');

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:
2504: END Validate_Amount;

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 2541: p_application_id => AR_RAAPI_UTIL.application_id,

2537: default_date3 => NULL,
2538: p_allow_not_open_flag => 'Y',
2539: p_invoicing_rule_id => g_invoicing_rule_id,
2540: p_set_of_books_id => arp_global.sysparam.set_of_books_id,
2541: p_application_id => AR_RAAPI_UTIL.application_id,
2542: default_gl_date => l_gl_date,
2543: defaulting_rule_used => l_default_rule,
2544: error_message => l_err_mesg)
2545: THEN

Line 2577: ' at AR_RAAPI_UTIL.Revalidate_GL_Dates()+');

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;
2581:

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 2652: ' at AR_RAAPI_UTIL.Deferred_GL_Date()+');

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;
2656:

Line 2774: END AR_RAAPI_UTIL;

2770: END IF;
2771: RETURN g_inv_org_id;
2772: END inv_org_id;
2773:
2774: END AR_RAAPI_UTIL;