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.43 2011/07/19 02:39:06 dgaurab 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 1618: ' at AR_RAAPI_UTIL.Validate_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;
1622:

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

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

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

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

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

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

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

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

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

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

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

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

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

2696: default_date3 => NULL,
2697: p_allow_not_open_flag => 'Y',
2698: p_invoicing_rule_id => g_invoicing_rule_id,
2699: p_set_of_books_id => arp_global.sysparam.set_of_books_id,
2700: p_application_id => AR_RAAPI_UTIL.application_id,
2701: default_gl_date => l_gl_date,
2702: defaulting_rule_used => l_default_rule,
2703: error_message => l_err_mesg)
2704: THEN

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

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

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

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

Line 3005: END AR_RAAPI_UTIL;

3001: RETURN FALSE;
3002:
3003: END unearned_zero_lines;
3004:
3005: END AR_RAAPI_UTIL;