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_ADJUSTAPI_PUB dependencies on AR_ADJUSTAPI_PUB

Line 1: PACKAGE BODY AR_ADJUSTAPI_PUB AS

1: PACKAGE BODY AR_ADJUSTAPI_PUB AS
2: /* $Header: ARTAADJB.pls 115.3 2003/10/10 19:43:15 mraymond noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJUSTAPI_PUB';
4: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
5: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJUSTAPI_PUB';

1: PACKAGE BODY AR_ADJUSTAPI_PUB AS
2: /* $Header: ARTAADJB.pls 115.3 2003/10/10 19:43:15 mraymond noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJUSTAPI_PUB';
4: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
5: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
6: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
7: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

Line 963: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';

959: p_new_adjust_number OUT NOCOPY ar_adjustments.adjustment_number%type,
960: p_new_adjust_id OUT NOCOPY ar_adjustments.adjustment_id%type
961: ) IS
962:
963: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
964: l_api_version CONSTANT NUMBER := 1.0;
965:
966: l_hsec VARCHAR2(10);
967: l_status number;

Line 983: SAVEPOINT AR_ADJUSTAPI_PUB;

979: /*------------------------------------+
980: | Standard start of API savepoint |
981: +------------------------------------*/
982:
983: SAVEPOINT AR_ADJUSTAPI_PUB;
984:
985: /*--------------------------------------------------+
986: | Standard call to check for call compatibility |
987: +--------------------------------------------------*/

Line 1075: ROLLBACK TO AR_ADJUSTAPI_PUB;

1071: /*---------------------------------------------------+
1072: | Rollback to the defined Savepoint |
1073: +---------------------------------------------------*/
1074:
1075: ROLLBACK TO AR_ADJUSTAPI_PUB;
1076: p_return_status := l_return_status ;
1077: RETURN;
1078: END IF;
1079:

Line 1097: ROLLBACK TO AR_ADJUSTAPI_PUB;

1093: /*---------------------------------------------------+
1094: | Rollback to the defined Savepoint |
1095: +---------------------------------------------------*/
1096:
1097: ROLLBACK TO AR_ADJUSTAPI_PUB;
1098: p_return_status := l_return_status ;
1099: RETURN;
1100: END IF;
1101:

Line 1107: ar_adjustapi_pub.Validate_Adj_Insert(

1103: | Validate the input details |
1104: | Do not continue if there are errors. |
1105: +------------------------------------------*/
1106:
1107: ar_adjustapi_pub.Validate_Adj_Insert(
1108: l_inp_adj_rec,
1109: l_return_status
1110: );
1111:

Line 1119: ROLLBACK TO AR_ADJUSTAPI_PUB;

1115: /*---------------------------------------------------+
1116: | Rollback to the defined Savepoint |
1117: +---------------------------------------------------*/
1118:
1119: ROLLBACK TO AR_ADJUSTAPI_PUB;
1120:
1121: p_return_status := l_return_status ;
1122:
1123: /*--------------------------------------------------+

Line 1148: ar_adjustapi_pub.Set_Remaining_Attributes (

1144: | Build up remaining data for the entity handler |
1145: | Reset attributes which should not be populated |
1146: +-----------------------------------------------*/
1147:
1148: ar_adjustapi_pub.Set_Remaining_Attributes (
1149: l_inp_adj_rec,
1150: l_return_status
1151: ) ;
1152:

Line 1160: ROLLBACK TO AR_ADJUSTAPI_PUB;

1156: /*---------------------------------------------------+
1157: | Rollback to the defined Savepoint |
1158: +---------------------------------------------------*/
1159:
1160: ROLLBACK TO AR_ADJUSTAPI_PUB;
1161:
1162: p_return_status := l_return_status ;
1163:
1164: /*--------------------------------------------------+

Line 1202: ROLLBACK TO AR_ADJUSTAPI_PUB;

1198: /*---------------------------------------------------+
1199: | Rollback to the defined Savepoint |
1200: +---------------------------------------------------*/
1201:
1202: ROLLBACK TO AR_ADJUSTAPI_PUB;
1203:
1204: p_return_status := FND_API.G_RET_STS_ERROR ;
1205:
1206: /*--------------------------------------------------+

Line 1277: ROLLBACK TO AR_ADJUSTAPI_PUB;

1273: arp_util.debug(SQLCODE, G_MSG_ERROR);
1274: arp_util.debug(SQLERRM, G_MSG_ERROR);
1275: END IF;
1276:
1277: ROLLBACK TO AR_ADJUSTAPI_PUB;
1278: p_return_status := FND_API.G_RET_STS_ERROR ;
1279: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1280: p_count => p_msg_count,
1281: p_data => p_msg_data

Line 1289: ROLLBACK TO AR_ADJUSTAPI_PUB ;

1285:
1286: IF PG_DEBUG in ('Y', 'C') THEN
1287: arp_util.debug(SQLERRM, G_MSG_ERROR);
1288: END IF;
1289: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1290: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1291: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1292: p_count => p_msg_count,
1293: p_data => p_msg_data

Line 1307: ROLLBACK TO AR_ADJUSTAPI_PUB;

1303:
1304: IF (SQLCODE = -20001)
1305: THEN
1306: p_return_status := FND_API.G_RET_STS_ERROR ;
1307: ROLLBACK TO AR_ADJUSTAPI_PUB;
1308: IF PG_DEBUG in ('Y', 'C') THEN
1309: arp_util.debug('Create_Adjustment: ' ||
1310: 'Completion validation error(s) occurred. ' ||
1311: 'Rolling back and setting status to ERROR',

Line 1392: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';

1388: p_adj_rec IN ar_adjustments%rowtype,
1389: p_old_adjust_id IN ar_adjustments.adjustment_id%type
1390: ) IS
1391:
1392: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1393: l_api_version CONSTANT NUMBER := 1.0;
1394: l_old_adj_rec ar_adjustments%rowtype;
1395: l_hsec VARCHAR2(10);
1396: l_status number;

Line 1410: SAVEPOINT AR_ADJUSTAPI_PUB;

1406: /*------------------------------------+
1407: | Standard start of API savepoint |
1408: +------------------------------------*/
1409:
1410: SAVEPOINT AR_ADJUSTAPI_PUB;
1411:
1412: /*--------------------------------------------------+
1413: | Standard call to check for call compatibility |
1414: +--------------------------------------------------*/

Line 1502: ROLLBACK TO AR_ADJUSTAPI_PUB;

1498: /*---------------------------------------------------+
1499: | Rollback to the defined Savepoint |
1500: +---------------------------------------------------*/
1501:
1502: ROLLBACK TO AR_ADJUSTAPI_PUB;
1503: p_return_status := l_return_status ;
1504: RETURN;
1505: END IF;
1506:

Line 1524: ROLLBACK TO AR_ADJUSTAPI_PUB;

1520: /*---------------------------------------------------+
1521: | Rollback to the defined Savepoint |
1522: +---------------------------------------------------*/
1523:
1524: ROLLBACK TO AR_ADJUSTAPI_PUB;
1525: p_return_status := l_return_status ;
1526: RETURN;
1527: END IF;
1528:

Line 1545: ROLLBACK TO AR_ADJUSTAPI_PUB;

1541: /*---------------------------------------------------+
1542: | Rollback to the defined Savepoint |
1543: +---------------------------------------------------*/
1544:
1545: ROLLBACK TO AR_ADJUSTAPI_PUB;
1546:
1547: p_return_status := FND_API.G_RET_STS_ERROR ;
1548:
1549: ar_adjvalidate_pub.aapi_message (

Line 1564: ar_adjustapi_pub.Validate_Adj_Modify (

1560: | Validate the input details |
1561: | Do not continue if there are errors. |
1562: +------------------------------------------*/
1563:
1564: ar_adjustapi_pub.Validate_Adj_Modify (
1565: l_inp_adj_rec,
1566: l_old_adj_rec,
1567: l_return_status
1568: );

Line 1578: ROLLBACK TO AR_ADJUSTAPI_PUB;

1574: /*---------------------------------------------------+
1575: | Rollback to the defined Savepoint |
1576: +---------------------------------------------------*/
1577:
1578: ROLLBACK TO AR_ADJUSTAPI_PUB;
1579:
1580: p_return_status := l_return_status ;
1581:
1582: /*--------------------------------------------------+

Line 1621: ROLLBACK TO AR_ADJUSTAPI_PUB;

1617: /*---------------------------------------------------+
1618: | Rollback to the defined Savepoint |
1619: +---------------------------------------------------*/
1620:
1621: ROLLBACK TO AR_ADJUSTAPI_PUB;
1622:
1623: p_return_status := FND_API.G_RET_STS_ERROR ;
1624:
1625: /*--------------------------------------------------+

Line 1691: ROLLBACK TO AR_ADJUSTAPI_PUB;

1687: arp_util.debug('Modify_Adjustment: ' || SQLCODE, G_MSG_ERROR);
1688: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1689: END IF;
1690:
1691: ROLLBACK TO AR_ADJUSTAPI_PUB;
1692: p_return_status := FND_API.G_RET_STS_ERROR ;
1693: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1694: p_count => p_msg_count,
1695: p_data => p_msg_data

Line 1703: ROLLBACK TO AR_ADJUSTAPI_PUB ;

1699:
1700: IF PG_DEBUG in ('Y', 'C') THEN
1701: arp_util.debug('Modify_Adjustment: ' || SQLERRM, G_MSG_ERROR);
1702: END IF;
1703: ROLLBACK TO AR_ADJUSTAPI_PUB ;
1704: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1706: p_count => p_msg_count,
1707: p_data => p_msg_data

Line 1721: ROLLBACK TO AR_ADJUSTAPI_PUB;

1717:
1718: IF (SQLCODE = -20001)
1719: THEN
1720: p_return_status := FND_API.G_RET_STS_ERROR ;
1721: ROLLBACK TO AR_ADJUSTAPI_PUB;
1722: IF PG_DEBUG in ('Y', 'C') THEN
1723: arp_util.debug('Modify_Adjustment: ' ||
1724: 'Completion validation error(s) occurred. ' ||
1725: 'Rolling back and setting status to ERROR',

Line 1804: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';

1800: p_reversal_gl_date IN date,
1801: p_reversal_date IN date
1802: ) IS
1803:
1804: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
1805: l_api_version CONSTANT NUMBER := 1.0;
1806:
1807: l_reversal_date ar_adjustments.apply_date%type;
1808: l_reversal_gl_date ar_adjustments.gl_date%type;

Line 1824: SAVEPOINT AR_ADJUSTAPI_PUB;

1820: /*------------------------------------+
1821: | Standard start of API savepoint |
1822: +------------------------------------*/
1823:
1824: SAVEPOINT AR_ADJUSTAPI_PUB;
1825:
1826: /*--------------------------------------------------+
1827: | Standard call to check for call compatibility |
1828: +--------------------------------------------------*/

Line 1911: ROLLBACK TO AR_ADJUSTAPI_PUB;

1907: /*---------------------------------------------------+
1908: | Rollback to the defined Savepoint |
1909: +---------------------------------------------------*/
1910:
1911: ROLLBACK TO AR_ADJUSTAPI_PUB;
1912: p_return_status := l_return_status ;
1913: RETURN;
1914: END IF;
1915:

Line 1931: ROLLBACK TO AR_ADJUSTAPI_PUB;

1927: /*---------------------------------------------------+
1928: | Rollback to the defined Savepoint |
1929: +---------------------------------------------------*/
1930:
1931: ROLLBACK TO AR_ADJUSTAPI_PUB;
1932:
1933: p_return_status := FND_API.G_RET_STS_ERROR ;
1934:
1935: ar_adjvalidate_pub.aapi_message (

Line 1962: ROLLBACK TO AR_ADJUSTAPI_PUB;

1958: /*---------------------------------------------------+
1959: | Rollback to the defined Savepoint |
1960: +---------------------------------------------------*/
1961:
1962: ROLLBACK TO AR_ADJUSTAPI_PUB;
1963: p_return_status := l_return_status ;
1964: RETURN;
1965: END IF;
1966:

Line 1980: ar_adjustapi_pub.Validate_Adj_Reverse (

1976: | Validate if the adjustment can be reversed |
1977: +------------------------------------------------*/
1978:
1979:
1980: ar_adjustapi_pub.Validate_Adj_Reverse (
1981: l_old_adj_rec,
1982: l_reversal_gl_date,
1983: l_reversal_date,
1984: l_return_status

Line 1995: ROLLBACK TO AR_ADJUSTAPI_PUB;

1991: /*---------------------------------------------------+
1992: | Rollback to the defined Savepoint |
1993: +---------------------------------------------------*/
1994:
1995: ROLLBACK TO AR_ADJUSTAPI_PUB;
1996:
1997: p_return_status := l_return_status ;
1998:
1999: /*--------------------------------------------------+

Line 2038: ROLLBACK TO AR_ADJUSTAPI_PUB;

2034: /*---------------------------------------------------+
2035: | Rollback to the defined Savepoint |
2036: +---------------------------------------------------*/
2037:
2038: ROLLBACK TO AR_ADJUSTAPI_PUB;
2039:
2040: p_return_status := FND_API.G_RET_STS_ERROR ;
2041:
2042: /*--------------------------------------------------+

Line 2110: ROLLBACK TO AR_ADJUSTAPI_PUB;

2106: arp_util.debug('Reverse_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2107: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2108: END IF;
2109:
2110: ROLLBACK TO AR_ADJUSTAPI_PUB;
2111: p_return_status := FND_API.G_RET_STS_ERROR ;
2112: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2113: p_count => p_msg_count,
2114: p_data => p_msg_data

Line 2122: ROLLBACK TO AR_ADJUSTAPI_PUB ;

2118:
2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_util.debug('Reverse_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2121: END IF;
2122: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2123: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2124: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2125: p_count => p_msg_count,
2126: p_data => p_msg_data

Line 2140: ROLLBACK TO AR_ADJUSTAPI_PUB;

2136:
2137: IF (SQLCODE = -20001)
2138: THEN
2139: p_return_status := FND_API.G_RET_STS_ERROR ;
2140: ROLLBACK TO AR_ADJUSTAPI_PUB;
2141: IF PG_DEBUG in ('Y', 'C') THEN
2142: arp_util.debug('Reverse_Adjustment: ' ||
2143: 'Completion validation error(s) occurred. ' ||
2144: 'Rolling back and setting status to ERROR',

Line 2224: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';

2220: p_adj_rec IN ar_adjustments%rowtype,
2221: p_old_adjust_id IN ar_adjustments.adjustment_id%type
2222: ) IS
2223:
2224: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUSTAPI_PUB';
2225: l_api_version CONSTANT NUMBER := 1.0;
2226: l_old_adj_rec ar_adjustments%rowtype;
2227:
2228: l_inp_adj_rec ar_adjustments%rowtype;

Line 2244: SAVEPOINT AR_ADJUSTAPI_PUB;

2240: /*------------------------------------+
2241: | Standard start of API savepoint |
2242: +------------------------------------*/
2243:
2244: SAVEPOINT AR_ADJUSTAPI_PUB;
2245:
2246: /*--------------------------------------------------+
2247: | Standard call to check for call compatibility |
2248: +--------------------------------------------------*/

Line 2337: ROLLBACK TO AR_ADJUSTAPI_PUB;

2333: /*---------------------------------------------------+
2334: | Rollback to the defined Savepoint |
2335: +---------------------------------------------------*/
2336:
2337: ROLLBACK TO AR_ADJUSTAPI_PUB;
2338: p_return_status := l_return_status ;
2339: RETURN;
2340: END IF;
2341:

Line 2359: ROLLBACK TO AR_ADJUSTAPI_PUB;

2355: /*---------------------------------------------------+
2356: | Rollback to the defined Savepoint |
2357: +---------------------------------------------------*/
2358:
2359: ROLLBACK TO AR_ADJUSTAPI_PUB;
2360: p_return_status := l_return_status ;
2361: RETURN;
2362: END IF;
2363:

Line 2380: ROLLBACK TO AR_ADJUSTAPI_PUB;

2376: /*---------------------------------------------------+
2377: | Rollback to the defined Savepoint |
2378: +---------------------------------------------------*/
2379:
2380: ROLLBACK TO AR_ADJUSTAPI_PUB;
2381:
2382: p_return_status := FND_API.G_RET_STS_ERROR ;
2383:
2384: ar_adjvalidate_pub.aapi_message (

Line 2399: ar_adjustapi_pub.Validate_Adj_Approve (

2395: | Validate the input details |
2396: | Do not continue if there are errors. |
2397: +------------------------------------------*/
2398:
2399: ar_adjustapi_pub.Validate_Adj_Approve (
2400: l_inp_adj_rec,
2401: l_old_adj_rec,
2402: l_return_status
2403: );

Line 2413: ROLLBACK TO AR_ADJUSTAPI_PUB;

2409: /*---------------------------------------------------+
2410: | Rollback to the defined Savepoint |
2411: +---------------------------------------------------*/
2412:
2413: ROLLBACK TO AR_ADJUSTAPI_PUB;
2414:
2415: p_return_status := l_return_status ;
2416:
2417: /*--------------------------------------------------+

Line 2457: ROLLBACK TO AR_ADJUSTAPI_PUB;

2453: /*---------------------------------------------------+
2454: | Rollback to the defined Savepoint |
2455: +---------------------------------------------------*/
2456:
2457: ROLLBACK TO AR_ADJUSTAPI_PUB;
2458:
2459: p_return_status := FND_API.G_RET_STS_ERROR ;
2460:
2461: /*--------------------------------------------------+

Line 2529: ROLLBACK TO AR_ADJUSTAPI_PUB;

2525: arp_util.debug('Approve_Adjustment: ' || SQLCODE, G_MSG_ERROR);
2526: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2527: END IF;
2528:
2529: ROLLBACK TO AR_ADJUSTAPI_PUB;
2530: p_return_status := FND_API.G_RET_STS_ERROR ;
2531: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2532: p_count => p_msg_count,
2533: p_data => p_msg_data

Line 2541: ROLLBACK TO AR_ADJUSTAPI_PUB ;

2537:
2538: IF PG_DEBUG in ('Y', 'C') THEN
2539: arp_util.debug('Approve_Adjustment: ' || SQLERRM, G_MSG_ERROR);
2540: END IF;
2541: ROLLBACK TO AR_ADJUSTAPI_PUB ;
2542: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2543: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2544: p_count => p_msg_count,
2545: p_data => p_msg_data

Line 2559: ROLLBACK TO AR_ADJUSTAPI_PUB;

2555:
2556: IF (SQLCODE = -20001)
2557: THEN
2558: p_return_status := FND_API.G_RET_STS_ERROR ;
2559: ROLLBACK TO AR_ADJUSTAPI_PUB;
2560: IF PG_DEBUG in ('Y', 'C') THEN
2561: arp_util.debug('Approve_Adjustment: ' ||
2562: 'Completion validation error(s) occurred. ' ||
2563: 'Rolling back and setting status to ERROR',

Line 2581: END AR_ADJUSTAPI_PUB;

2577:
2578: END Approve_Adjustment;
2579:
2580:
2581: END AR_ADJUSTAPI_PUB;