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_ADJUST_PUB dependencies on AR_ADJUST_PUB

Line 1: PACKAGE BODY AR_ADJUST_PUB AS

1: PACKAGE BODY AR_ADJUST_PUB AS
2: /* $Header: ARXPADJB.pls 120.30.12020000.2 2012/07/03 22:38:00 dgaurab ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJUST_PUB';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJUST_PUB';

1: PACKAGE BODY AR_ADJUST_PUB AS
2: /* $Header: ARXPADJB.pls 120.30.12020000.2 2012/07/03 22:38:00 dgaurab ship $*/
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) :='AR_ADJUST_PUB';
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
8: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

Line 1636: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

1632: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
1633: p_org_id IN NUMBER DEFAULT NULL
1634: ) IS
1635:
1636: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
1637: l_api_version CONSTANT NUMBER := 1.0;
1638:
1639: l_hsec VARCHAR2(10);
1640: l_status number;

Line 1668: SAVEPOINT ar_adjust_PUB;

1664: /*------------------------------------+
1665: | Standard start of API savepoint |
1666: +------------------------------------*/
1667:
1668: SAVEPOINT ar_adjust_PUB;
1669:
1670: /*--------------------------------------------------+
1671: | Standard call to check for call compatibility |
1672: +--------------------------------------------------*/

Line 1837: ar_adjust_pub.Validate_Adj_Insert(

1833: IF (l_check_amount IS NULL) THEN
1834: l_check_amount := FND_API.G_TRUE;
1835: END IF;
1836:
1837: ar_adjust_pub.Validate_Adj_Insert(
1838: l_inp_adj_rec,
1839: l_chk_approval_limits,
1840: l_check_amount,
1841: l_return_status

Line 1872: ar_adjust_pub.Set_Remaining_Attributes (

1868: | Build up remaining data for the entity handler |
1869: | Reset attributes which should not be populated |
1870: +-----------------------------------------------*/
1871:
1872: ar_adjust_pub.Set_Remaining_Attributes (
1873: l_inp_adj_rec,
1874: l_return_status
1875: ) ;
1876:

Line 1938: ROLLBACK TO ar_adjust_PUB;

1934: /*---------------------------------------------------+
1935: | Rollback to the defined Savepoint |
1936: +---------------------------------------------------*/
1937:
1938: ROLLBACK TO ar_adjust_PUB;
1939: p_return_status := FND_API.G_RET_STS_ERROR ;
1940:
1941: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
1942: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.insert_adjustment exception: '||SQLERRM );

Line 2014: ROLLBACK TO ar_adjust_PUB;

2010: arp_util.debug('Create_Adjustment: ' || SQLCODE);
2011: arp_util.debug('Create_Adjustment: ' || SQLERRM);
2012: END IF;
2013:
2014: ROLLBACK TO ar_adjust_PUB;
2015: p_return_status := FND_API.G_RET_STS_ERROR ;
2016: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2017: p_count => p_msg_count,
2018: p_data => p_msg_data

Line 2026: ROLLBACK TO ar_adjust_PUB ;

2022:
2023: IF PG_DEBUG in ('Y', 'C') THEN
2024: arp_util.debug('Create_Adjustment: ' || SQLERRM);
2025: END IF;
2026: ROLLBACK TO ar_adjust_PUB ;
2027: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2029: p_count => p_msg_count,
2030: p_data => p_msg_data

Line 2044: ROLLBACK TO ar_adjust_PUB;

2040:
2041: IF (SQLCODE = -20001)
2042: THEN
2043: p_return_status := FND_API.G_RET_STS_ERROR ;
2044: ROLLBACK TO ar_adjust_PUB;
2045: IF PG_DEBUG in ('Y', 'C') THEN
2046: arp_util.debug('Create_Adjustment: ' ||
2047: 'Completion validation error(s) occurred. ' ||
2048: 'Rolling back and setting status to ERROR');

Line 2138: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

2134: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
2135: p_org_id IN NUMBER DEFAULT NULL
2136: ) IS
2137:
2138: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
2139: l_api_version CONSTANT NUMBER := 1.0;
2140:
2141: l_hsec VARCHAR2(10);
2142: l_status number;

Line 2451: ar_adjust_pub.Validate_Adj_Insert(

2447: l_line_return_status := FND_API.G_RET_STS_ERROR;
2448:
2449: ELSE
2450:
2451: ar_adjust_pub.Validate_Adj_Insert(
2452: l_inp_adj_rec,
2453: l_chk_approval_limits,
2454: l_check_amount,
2455: l_return_status,

Line 2476: ar_adjust_pub.Set_Remaining_Attributes (

2472: +-----------------------------------------------*/
2473:
2474:
2475: IF ( l_line_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2476: ar_adjust_pub.Set_Remaining_Attributes (
2477: l_inp_adj_rec,
2478: l_return_status
2479: ) ;
2480:

Line 2749: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

2745: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
2746: p_org_id IN NUMBER DEFAULT NULL
2747: ) IS
2748:
2749: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
2750: l_api_version CONSTANT NUMBER := 1.0;
2751: l_old_adj_rec ar_adjustments%rowtype;
2752: l_hsec VARCHAR2(10);
2753: l_status number;

Line 2772: SAVEPOINT ar_adjust_PUB;

2768: /*------------------------------------+
2769: | Standard start of API savepoint |
2770: +------------------------------------*/
2771:
2772: SAVEPOINT ar_adjust_PUB;
2773:
2774: /*--------------------------------------------------+
2775: | Standard call to check for call compatibility |
2776: +--------------------------------------------------*/

Line 2886: ROLLBACK TO ar_adjust_PUB;

2882: WHEN OTHERS THEN
2883: /*---------------------------------------------------+
2884: | Rollback to the defined Savepoint |
2885: +---------------------------------------------------*/
2886: ROLLBACK TO ar_adjust_PUB;
2887: p_return_status := FND_API.G_RET_STS_ERROR ;
2888: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');
2889: FND_MESSAGE.SET_TOKEN ( 'ADJUSTMENT_ID', to_char(p_old_adjust_id) ) ;
2890: FND_MSG_PUB.ADD ;

Line 2924: ar_adjust_pub.Validate_Adj_Modify (

2920: IF (l_chk_approval_limits IS NULL) THEN
2921: l_chk_approval_limits := FND_API.G_TRUE;
2922: END IF;
2923:
2924: ar_adjust_pub.Validate_Adj_Modify (
2925: l_inp_adj_rec,
2926: l_old_adj_rec,
2927: l_chk_approval_limits,
2928: l_return_status

Line 2973: ROLLBACK TO ar_adjust_PUB;

2969: /*---------------------------------------------------+
2970: | Rollback to the defined Savepoint |
2971: +---------------------------------------------------*/
2972:
2973: ROLLBACK TO ar_adjust_PUB;
2974:
2975: p_return_status := FND_API.G_RET_STS_ERROR ;
2976:
2977: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );

Line 3051: ROLLBACK TO ar_adjust_PUB;

3047: arp_util.debug('Modify_Adjustment: ' || SQLCODE);
3048: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3049: END IF;
3050:
3051: ROLLBACK TO ar_adjust_PUB;
3052: p_return_status := FND_API.G_RET_STS_ERROR ;
3053: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3054: p_count => p_msg_count,
3055: p_data => p_msg_data

Line 3063: ROLLBACK TO ar_adjust_PUB ;

3059:
3060: IF PG_DEBUG in ('Y', 'C') THEN
3061: arp_util.debug('Modify_Adjustment: ' || SQLERRM);
3062: END IF;
3063: ROLLBACK TO ar_adjust_PUB ;
3064: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3065: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3066: p_count => p_msg_count,
3067: p_data => p_msg_data

Line 3081: ROLLBACK TO ar_adjust_PUB;

3077:
3078: IF (SQLCODE = -20001)
3079: THEN
3080: p_return_status := FND_API.G_RET_STS_ERROR ;
3081: ROLLBACK TO ar_adjust_PUB;
3082: IF PG_DEBUG in ('Y', 'C') THEN
3083: arp_util.debug('Modify_Adjustment: ' ||
3084: 'Completion validation error(s) occurred. ' ||
3085: 'Rolling back and setting status to ERROR');

Line 3180: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

3176: p_called_from IN varchar2,
3177: p_org_id IN NUMBER DEFAULT NULL
3178: ) IS
3179:
3180: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
3181: l_api_version CONSTANT NUMBER := 1.0;
3182:
3183: l_reversal_date ar_adjustments.apply_date%type;
3184: l_reversal_gl_date ar_adjustments.gl_date%type;

Line 3199: l_llca_adj_trx_lines_tbl ar_adjust_pub.llca_adj_trx_line_tbl_type;

3195: l_org_return_status VARCHAR2(1);
3196: l_org_id NUMBER;
3197:
3198: -- Line Leve Reversal
3199: l_llca_adj_trx_lines_tbl ar_adjust_pub.llca_adj_trx_line_tbl_type;
3200: l_llca_adj_create_tbl_type ar_adjust_pub.llca_adj_create_tbl_type;
3201: l_count_chk NUMBER;
3202:
3203:

Line 3200: l_llca_adj_create_tbl_type ar_adjust_pub.llca_adj_create_tbl_type;

3196: l_org_id NUMBER;
3197:
3198: -- Line Leve Reversal
3199: l_llca_adj_trx_lines_tbl ar_adjust_pub.llca_adj_trx_line_tbl_type;
3200: l_llca_adj_create_tbl_type ar_adjust_pub.llca_adj_create_tbl_type;
3201: l_count_chk NUMBER;
3202:
3203:
3204:

Line 3216: SAVEPOINT ar_adjust_PUB;

3212: /*------------------------------------+
3213: | Standard start of API savepoint |
3214: +------------------------------------*/
3215:
3216: SAVEPOINT ar_adjust_PUB;
3217:
3218: /*--------------------------------------------------+
3219: | Standard call to check for call compatibility |
3220: +--------------------------------------------------*/

Line 3307: ROLLBACK TO ar_adjust_PUB;

3303: /*---------------------------------------------------+
3304: | Rollback to the defined Savepoint |
3305: +---------------------------------------------------*/
3306:
3307: ROLLBACK TO ar_adjust_PUB;
3308:
3309: p_return_status := FND_API.G_RET_STS_ERROR ;
3310:
3311: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');

Line 3349: ar_adjust_pub.Validate_Adj_Reverse (

3345: | Validate if the adjustment can be reversed |
3346: +------------------------------------------------*/
3347:
3348:
3349: ar_adjust_pub.Validate_Adj_Reverse (
3350: l_adj_rec,
3351: l_reversal_gl_date,
3352: l_reversal_date,
3353: l_return_status

Line 3489: ar_adjust_pub.create_linelevel_adjustment(

3485: IF NVL(l_count_chk,0) <> 0
3486: THEN
3487:
3488:
3489: ar_adjust_pub.create_linelevel_adjustment(
3490: p_api_name => 'AR_ADJUST_PUB',
3491: p_api_version => 1.0,
3492: p_msg_count => l_msg_count ,
3493: p_msg_data => l_msg_data,

Line 3490: p_api_name => 'AR_ADJUST_PUB',

3486: THEN
3487:
3488:
3489: ar_adjust_pub.create_linelevel_adjustment(
3490: p_api_name => 'AR_ADJUST_PUB',
3491: p_api_version => 1.0,
3492: p_msg_count => l_msg_count ,
3493: p_msg_data => l_msg_data,
3494: p_return_status => l_return_status,

Line 3516: ar_adjust_pub.Create_Adjustment(

3512: END IF;
3513: END IF;
3514:
3515: ELSE
3516: ar_adjust_pub.Create_Adjustment(
3517: p_api_name => 'AR_ADJUST_PUB',
3518: p_api_version => 1.0,
3519: p_msg_count => l_msg_count ,
3520: p_msg_data => l_msg_data,

Line 3517: p_api_name => 'AR_ADJUST_PUB',

3513: END IF;
3514:
3515: ELSE
3516: ar_adjust_pub.Create_Adjustment(
3517: p_api_name => 'AR_ADJUST_PUB',
3518: p_api_version => 1.0,
3519: p_msg_count => l_msg_count ,
3520: p_msg_data => l_msg_data,
3521: p_return_status => l_return_status,

Line 3551: ROLLBACK TO ar_adjust_PUB;

3547: /*---------------------------------------------------+
3548: | Rollback to the defined Savepoint |
3549: +---------------------------------------------------*/
3550:
3551: ROLLBACK TO ar_adjust_PUB;
3552: p_return_status := FND_API.G_RET_STS_ERROR ;
3553:
3554: /*--------------------------------------------------+
3555: | Get message count and if 1, return message data |

Line 3628: ROLLBACK TO ar_adjust_PUB;

3624: arp_util.debug('Reverse_Adjustment: ' || SQLCODE);
3625: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3626: END IF;
3627:
3628: ROLLBACK TO ar_adjust_PUB;
3629: p_return_status := FND_API.G_RET_STS_ERROR ;
3630: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3631: p_count => p_msg_count,
3632: p_data => p_msg_data

Line 3640: ROLLBACK TO ar_adjust_PUB ;

3636:
3637: IF PG_DEBUG in ('Y', 'C') THEN
3638: arp_util.debug('Reverse_Adjustment: ' || SQLERRM);
3639: END IF;
3640: ROLLBACK TO ar_adjust_PUB ;
3641: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3642: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
3643: p_count => p_msg_count,
3644: p_data => p_msg_data

Line 3658: ROLLBACK TO ar_adjust_PUB;

3654:
3655: IF (SQLCODE = -20001)
3656: THEN
3657: p_return_status := FND_API.G_RET_STS_ERROR ;
3658: ROLLBACK TO ar_adjust_PUB;
3659: IF PG_DEBUG in ('Y', 'C') THEN
3660: arp_util.debug('Reverse_Adjustment: ' ||
3661: 'Completion validation error(s) occurred. ' ||
3662: 'Rolling back and setting status to ERROR');

Line 3755: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';

3751: p_old_adjust_id IN ar_adjustments.adjustment_id%type,
3752: p_org_id IN NUMBER DEFAULT NULL
3753: ) IS
3754:
3755: l_api_name CONSTANT VARCHAR2(20) := 'AR_ADJUST_PUB';
3756: l_api_version CONSTANT NUMBER := 1.0;
3757: l_old_adj_rec ar_adjustments%rowtype;
3758:
3759: l_inp_adj_rec ar_adjustments%rowtype;

Line 3780: SAVEPOINT ar_adjust_PUB;

3776: /*------------------------------------+
3777: | Standard start of API savepoint |
3778: +------------------------------------*/
3779:
3780: SAVEPOINT ar_adjust_PUB;
3781:
3782: /*--------------------------------------------------+
3783: | Standard call to check for call compatibility |
3784: +--------------------------------------------------*/

Line 3902: ROLLBACK TO ar_adjust_PUB;

3898: /*---------------------------------------------------+
3899: | Rollback to the defined Savepoint |
3900: +---------------------------------------------------*/
3901:
3902: ROLLBACK TO ar_adjust_PUB;
3903:
3904: p_return_status := FND_API.G_RET_STS_ERROR ;
3905:
3906: FND_MESSAGE.SET_NAME ('AR', 'AR_AAPI_INVALID_ADJ_ID');

Line 3927: ar_adjust_pub.Validate_Adj_Approve (

3923: IF (l_chk_approval_limits IS NULL) THEN
3924: l_chk_approval_limits := FND_API.G_TRUE;
3925: END IF;
3926:
3927: ar_adjust_pub.Validate_Adj_Approve (
3928: l_inp_adj_rec,
3929: l_old_adj_rec,
3930: l_chk_approval_limits,
3931: l_return_status

Line 3984: ROLLBACK TO ar_adjust_PUB;

3980: /*---------------------------------------------------+
3981: | Rollback to the defined Savepoint |
3982: +---------------------------------------------------*/
3983:
3984: ROLLBACK TO ar_adjust_PUB;
3985:
3986: p_return_status := FND_API.G_RET_STS_ERROR ;
3987:
3988: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );

Line 4062: ROLLBACK TO ar_adjust_PUB;

4058: arp_util.debug('Approve_Adjustment: ' || SQLCODE);
4059: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4060: END IF;
4061:
4062: ROLLBACK TO ar_adjust_PUB;
4063: p_return_status := FND_API.G_RET_STS_ERROR ;
4064: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4065: p_count => p_msg_count,
4066: p_data => p_msg_data

Line 4074: ROLLBACK TO ar_adjust_PUB ;

4070:
4071: IF PG_DEBUG in ('Y', 'C') THEN
4072: arp_util.debug('Approve_Adjustment: ' || SQLERRM);
4073: END IF;
4074: ROLLBACK TO ar_adjust_PUB ;
4075: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4076: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
4077: p_count => p_msg_count,
4078: p_data => p_msg_data

Line 4092: ROLLBACK TO ar_adjust_PUB;

4088:
4089: IF (SQLCODE = -20001)
4090: THEN
4091: p_return_status := FND_API.G_RET_STS_ERROR ;
4092: ROLLBACK TO ar_adjust_PUB;
4093: IF PG_DEBUG in ('Y', 'C') THEN
4094: arp_util.debug('Approve_Adjustment: ' ||
4095: 'Completion validation error(s) occurred. ' ||
4096: 'Rolling back and setting status to ERROR');

Line 4113: END ar_adjust_PUB;

4109:
4110: END Approve_Adjustment;
4111:
4112:
4113: END ar_adjust_PUB;