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.ARP_PROCESS_ADJUSTMENT dependencies on ARP_STANDARD

Line 944: arp_standard.gl_period_info( p_adj_rec.gl_date,

940: /*-------------------------------------------------------------------+
941: | validate that GL Date is in an open or future enterable period |
942: +-------------------------------------------------------------------*/
943:
944: arp_standard.gl_period_info( p_adj_rec.gl_date,
945: l_varchar_dummy,
946: l_date_dummy,
947: l_date_dummy,
948: l_closing_status,

Line 2331: arp_standard.debug('l_old_adj_rec.code_combination_id ' || l_old_adj_rec.code_combination_id);

2327: | Bug 1787087 : When an adjustment is approved, the newly created |
2328: | distributions should always reflect the account from adj record |
2329: | and not the defaulted account only if they are not the same. |
2330: +------------------------------------------------------------------*/
2331: arp_standard.debug('l_old_adj_rec.code_combination_id ' || l_old_adj_rec.code_combination_id);
2332: arp_standard.debug('l_adj_rec.code_combination_id ' || l_adj_rec.code_combination_id);
2333:
2334: IF l_adj_rec.code_combination_id IS NOT NULL THEN
2335: l_ae_doc_rec.source_id_old := l_adj_rec.code_combination_id;

Line 2332: arp_standard.debug('l_adj_rec.code_combination_id ' || l_adj_rec.code_combination_id);

2328: | distributions should always reflect the account from adj record |
2329: | and not the defaulted account only if they are not the same. |
2330: +------------------------------------------------------------------*/
2331: arp_standard.debug('l_old_adj_rec.code_combination_id ' || l_old_adj_rec.code_combination_id);
2332: arp_standard.debug('l_adj_rec.code_combination_id ' || l_adj_rec.code_combination_id);
2333:
2334: IF l_adj_rec.code_combination_id IS NOT NULL THEN
2335: l_ae_doc_rec.source_id_old := l_adj_rec.code_combination_id;
2336: l_ae_doc_rec.other_flag := 'OVERRIDE';

Line 2375: arp_standard.debug('before call to the business events');

2371: /* 4544013 - removed call to sync_vendor_f_ct_adj_id. */
2372: NULL;
2373: END IF;
2374:
2375: arp_standard.debug('before call to the business events');
2376:
2377: IF l_app_ps_status <> l_ps_rec.status THEN
2378: l_app_ps_status := l_ps_rec.status;
2379: ELSE

Line 3061: arp_standard.debug( 'arp_process_adjustment.reverse_adjustment()+' );

3057: l_adj_post_to_gl ra_cust_trx_types.adj_post_to_gl%TYPE := 'Y' ;
3058:
3059: BEGIN
3060: IF PG_DEBUG in ('Y', 'C') THEN
3061: arp_standard.debug( 'arp_process_adjustment.reverse_adjustment()+' );
3062: arp_standard.debug( 'p_adj_id = '||to_char( p_adj_id ) );
3063: END IF;
3064:
3065: IF (p_module_name IS NOT NULL

Line 3062: arp_standard.debug( 'p_adj_id = '||to_char( p_adj_id ) );

3058:
3059: BEGIN
3060: IF PG_DEBUG in ('Y', 'C') THEN
3061: arp_standard.debug( 'arp_process_adjustment.reverse_adjustment()+' );
3062: arp_standard.debug( 'p_adj_id = '||to_char( p_adj_id ) );
3063: END IF;
3064:
3065: IF (p_module_name IS NOT NULL
3066: AND p_module_version IS NOT NULL )

Line 3168: arp_standard.debug(

3164:
3165: EXCEPTION
3166: WHEN NO_DATA_FOUND THEN
3167: IF PG_DEBUG in ('Y', 'C') THEN
3168: arp_standard.debug(
3169: 'NO_DATA_FOUND: arp_process_adjustment.reverse_adjustment' );
3170: END IF;
3171:
3172: WHEN OTHERS THEN

Line 3174: arp_standard.debug(

3170: END IF;
3171:
3172: WHEN OTHERS THEN
3173: IF PG_DEBUG in ('Y', 'C') THEN
3174: arp_standard.debug(
3175: 'EXCEPTION: arp_process_adjustment.reverse_adjustment:SELECT' );
3176: END IF;
3177: RAISE;
3178: END;

Line 3210: arp_standard.debug( 'arp_process_adjustment.reverse_adjustment()-' );

3206: , p_reversal_date );
3207:
3208:
3209: IF PG_DEBUG in ('Y', 'C') THEN
3210: arp_standard.debug( 'arp_process_adjustment.reverse_adjustment()-' );
3211: END IF;
3212:
3213: EXCEPTION
3214: WHEN OTHERS THEN

Line 3216: arp_standard.debug(

3212:
3213: EXCEPTION
3214: WHEN OTHERS THEN
3215: IF PG_DEBUG in ('Y', 'C') THEN
3216: arp_standard.debug(
3217: 'EXCEPTION: arp_process_adjustment.reverse_adjustment' );
3218: END IF;
3219: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
3220: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.reverse_adjustment exception: '||SQLERRM );

Line 3223: arp_standard.debug ( 'p_adj_id = '|| TO_CHAR(p_adj_id ) );

3219: FND_MESSAGE.set_name( 'AR', 'GENERIC_MESSAGE' );
3220: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.reverse_adjustment exception: '||SQLERRM );
3221:
3222: IF PG_DEBUG in ('Y', 'C') THEN
3223: arp_standard.debug ( 'p_adj_id = '|| TO_CHAR(p_adj_id ) );
3224: arp_standard.debug ( 'p_reversal_gl_date = '|| TO_CHAR(p_reversal_gl_date));
3225: arp_standard.debug ( 'p_reversal_date = '|| TO_CHAR(p_reversal_date));
3226: arp_standard.debug ( 'p_module_name = '|| p_module_name);
3227: arp_standard.debug ( 'p_module_version = '|| p_module_version);

Line 3224: arp_standard.debug ( 'p_reversal_gl_date = '|| TO_CHAR(p_reversal_gl_date));

3220: FND_MESSAGE.set_token( 'GENERIC_TEXT', 'arp_process_adjustment.reverse_adjustment exception: '||SQLERRM );
3221:
3222: IF PG_DEBUG in ('Y', 'C') THEN
3223: arp_standard.debug ( 'p_adj_id = '|| TO_CHAR(p_adj_id ) );
3224: arp_standard.debug ( 'p_reversal_gl_date = '|| TO_CHAR(p_reversal_gl_date));
3225: arp_standard.debug ( 'p_reversal_date = '|| TO_CHAR(p_reversal_date));
3226: arp_standard.debug ( 'p_module_name = '|| p_module_name);
3227: arp_standard.debug ( 'p_module_version = '|| p_module_version);
3228: END IF;

Line 3225: arp_standard.debug ( 'p_reversal_date = '|| TO_CHAR(p_reversal_date));

3221:
3222: IF PG_DEBUG in ('Y', 'C') THEN
3223: arp_standard.debug ( 'p_adj_id = '|| TO_CHAR(p_adj_id ) );
3224: arp_standard.debug ( 'p_reversal_gl_date = '|| TO_CHAR(p_reversal_gl_date));
3225: arp_standard.debug ( 'p_reversal_date = '|| TO_CHAR(p_reversal_date));
3226: arp_standard.debug ( 'p_module_name = '|| p_module_name);
3227: arp_standard.debug ( 'p_module_version = '|| p_module_version);
3228: END IF;
3229:

Line 3226: arp_standard.debug ( 'p_module_name = '|| p_module_name);

3222: IF PG_DEBUG in ('Y', 'C') THEN
3223: arp_standard.debug ( 'p_adj_id = '|| TO_CHAR(p_adj_id ) );
3224: arp_standard.debug ( 'p_reversal_gl_date = '|| TO_CHAR(p_reversal_gl_date));
3225: arp_standard.debug ( 'p_reversal_date = '|| TO_CHAR(p_reversal_date));
3226: arp_standard.debug ( 'p_module_name = '|| p_module_name);
3227: arp_standard.debug ( 'p_module_version = '|| p_module_version);
3228: END IF;
3229:
3230: RAISE;

Line 3227: arp_standard.debug ( 'p_module_version = '|| p_module_version);

3223: arp_standard.debug ( 'p_adj_id = '|| TO_CHAR(p_adj_id ) );
3224: arp_standard.debug ( 'p_reversal_gl_date = '|| TO_CHAR(p_reversal_gl_date));
3225: arp_standard.debug ( 'p_reversal_date = '|| TO_CHAR(p_reversal_date));
3226: arp_standard.debug ( 'p_module_name = '|| p_module_name);
3227: arp_standard.debug ( 'p_module_version = '|| p_module_version);
3228: END IF;
3229:
3230: RAISE;
3231: END;

Line 3263: arp_standard.debug( 'arp_process_adjustment.validate_args_radj()+' );

3259: p_reversal_gl_date IN DATE,
3260: p_reversal_date IN DATE ) IS
3261: BEGIN
3262: IF PG_DEBUG in ('Y', 'C') THEN
3263: arp_standard.debug( 'arp_process_adjustment.validate_args_radj()+' );
3264: END IF;
3265: IF ( p_adj_id is NULL OR p_reversal_gl_date is NULL OR
3266: p_reversal_date is NULL ) THEN
3267: IF PG_DEBUG in ('Y', 'C') THEN

Line 3268: arp_standard.debug( ' Null values found in input variable' );

3264: END IF;
3265: IF ( p_adj_id is NULL OR p_reversal_gl_date is NULL OR
3266: p_reversal_date is NULL ) THEN
3267: IF PG_DEBUG in ('Y', 'C') THEN
3268: arp_standard.debug( ' Null values found in input variable' );
3269: END IF;
3270: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3271: APP_EXCEPTION.raise_exception;
3272: END IF;

Line 3275: arp_standard.debug( 'arp_process_adjustment.validate_args_radj()-' );

3271: APP_EXCEPTION.raise_exception;
3272: END IF;
3273: --
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: arp_standard.debug( 'arp_process_adjustment.validate_args_radj()-' );
3276: END IF;
3277: EXCEPTION
3278: WHEN OTHERS THEN
3279: IF PG_DEBUG in ('Y', 'C') THEN

Line 3280: arp_standard.debug(

3276: END IF;
3277: EXCEPTION
3278: WHEN OTHERS THEN
3279: IF PG_DEBUG in ('Y', 'C') THEN
3280: arp_standard.debug(
3281: 'EXCEPTION: arp_process_adjustment.validate_args_radj' );
3282: END IF;
3283: RAISE;
3284: END;

Line 3321: arp_standard.debug( 'arp_process_adjustment.modify_adj_rec()+' );

3317: l_defaulting_rule_used VARCHAR2(100);
3318: l_default_gl_date DATE;
3319: BEGIN
3320: IF PG_DEBUG in ('Y', 'C') THEN
3321: arp_standard.debug( 'arp_process_adjustment.modify_adj_rec()+' );
3322: arp_standard.debug( 'p_adj_id = '||to_char( p_adj_id ) );
3323: END IF;
3324:
3325: arp_adj_pkg.fetch_p( p_adj_id, l_adj_rec );

Line 3322: arp_standard.debug( 'p_adj_id = '||to_char( p_adj_id ) );

3318: l_default_gl_date DATE;
3319: BEGIN
3320: IF PG_DEBUG in ('Y', 'C') THEN
3321: arp_standard.debug( 'arp_process_adjustment.modify_adj_rec()+' );
3322: arp_standard.debug( 'p_adj_id = '||to_char( p_adj_id ) );
3323: END IF;
3324:
3325: arp_adj_pkg.fetch_p( p_adj_id, l_adj_rec );
3326:

Line 3334: IF (arp_standard.validate_and_default_gl_date(

3330: IF p_reversal_gl_date > l_adj_rec.gl_date THEN
3331: l_adj_rec.gl_date := p_reversal_gl_date;
3332: ELSE
3333: l_rev_gl_date := l_adj_rec.gl_date;
3334: IF (arp_standard.validate_and_default_gl_date(
3335: l_rev_gl_date,
3336: NULL,
3337: l_rev_gl_date,
3338: NULL,

Line 3354: arp_standard.debug(' Adjustment Reversal GL Date '|| l_default_gl_date);

3350: THEN
3351: l_adj_rec.gl_date := l_default_gl_date;
3352: END IF;
3353: END IF;
3354: arp_standard.debug(' Adjustment Reversal GL Date '|| l_default_gl_date);
3355:
3356: l_adj_rec.amount := -l_adj_rec.amount;
3357: l_adj_rec.acctd_amount := -l_adj_rec.acctd_amount;
3358: IF ( l_adj_rec.chargeback_customer_trx_id is NULL ) THEN

Line 3379: arp_standard.debug( 'arp_process_adjustment.modify_adj_rec()-' );

3375:
3376: insert_reverse_actions( l_adj_rec, NULL, NULL );
3377:
3378: IF PG_DEBUG in ('Y', 'C') THEN
3379: arp_standard.debug( 'arp_process_adjustment.modify_adj_rec()-' );
3380: END IF;
3381:
3382: EXCEPTION
3383: WHEN OTHERS THEN

Line 3385: arp_standard.debug(

3381:
3382: EXCEPTION
3383: WHEN OTHERS THEN
3384: IF PG_DEBUG in ('Y', 'C') THEN
3385: arp_standard.debug(
3386: 'EXCEPTION: arp_process_adjustment.modify_adj_rec' );
3387: END IF;
3388: RAISE;
3389:

Line 3456: arp_standard.debug( 'arp_process_adjustment.insert_reverse_actions()+');

3452:
3453:
3454: BEGIN
3455: IF PG_DEBUG in ('Y', 'C') THEN
3456: arp_standard.debug( 'arp_process_adjustment.insert_reverse_actions()+');
3457: END IF;
3458:
3459: /* VAT changes: save p_adj_rec.adjustment_id in l_old_adj_id
3460: to be passed to accounting library. Clear p_adj_rec.adjustment_id

Line 3486: arp_standard.debug( 'after select in insert_revers_actions in app_delete' );

3482: FROM ar_receivables_trx rt
3483: WHERE rt.receivables_trx_id = p_adj_rec.receivables_trx_id;
3484:
3485: IF PG_DEBUG in ('Y', 'C') THEN
3486: arp_standard.debug( 'after select in insert_revers_actions in app_delete' );
3487: END IF;
3488:
3489: -- -----------------------------------------------------------------
3490: -- Get document numbers only if customer is using document numbering

Line 3503: arp_standard.application_id

3499:
3500: /* Commented to fix bug #741725, as this does not handle gapless sequence
3501: -- numbering.
3502: FND_SEQNUM.GET_SEQ_NAME(
3503: arp_standard.application_id
3504: , l_rec_name -- category code
3505: , arp_global.set_of_books_id
3506: , 'A'
3507: , p_adj_rec.apply_date

Line 3521: appid => arp_standard.application_id,

3517: -- Bug fix #741725: Use AOL API get_next_sequence() instead of
3518: -- get_seq_name.
3519: p_adj_rec.doc_sequence_value :=
3520: FND_SEQNUM.GET_NEXT_SEQUENCE(
3521: appid => arp_standard.application_id,
3522: cat_code => l_rec_name,
3523: sobid => arp_global.set_of_books_id,
3524: met_code => 'A',
3525: trx_date => p_adj_rec.apply_date,

Line 3530: arp_standard.debug( 'doc sequence name = '|| l_sequence_name);

3526: dbseqnm => l_sequence_name,
3527: dbseqid => p_adj_rec.doc_sequence_id);
3528:
3529: IF PG_DEBUG in ('Y', 'C') THEN
3530: arp_standard.debug( 'doc sequence name = '|| l_sequence_name);
3531: arp_standard.debug( 'doc sequence id = '|| p_adj_rec.doc_sequence_id);
3532: arp_standard.debug( 'doc sequence value = '||p_adj_rec.doc_sequence_value);
3533: END IF;
3534: -- End fix for bug #741725

Line 3531: arp_standard.debug( 'doc sequence id = '|| p_adj_rec.doc_sequence_id);

3527: dbseqid => p_adj_rec.doc_sequence_id);
3528:
3529: IF PG_DEBUG in ('Y', 'C') THEN
3530: arp_standard.debug( 'doc sequence name = '|| l_sequence_name);
3531: arp_standard.debug( 'doc sequence id = '|| p_adj_rec.doc_sequence_id);
3532: arp_standard.debug( 'doc sequence value = '||p_adj_rec.doc_sequence_value);
3533: END IF;
3534: -- End fix for bug #741725
3535:

Line 3532: arp_standard.debug( 'doc sequence value = '||p_adj_rec.doc_sequence_value);

3528:
3529: IF PG_DEBUG in ('Y', 'C') THEN
3530: arp_standard.debug( 'doc sequence name = '|| l_sequence_name);
3531: arp_standard.debug( 'doc sequence id = '|| p_adj_rec.doc_sequence_id);
3532: arp_standard.debug( 'doc sequence value = '||p_adj_rec.doc_sequence_value);
3533: END IF;
3534: -- End fix for bug #741725
3535:
3536: /* Bug 631699: If no document sequence is defined, gives an error

Line 3552: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);

3548: END IF;
3549: END;
3550:
3551: IF PG_DEBUG in ('Y', 'C') THEN
3552: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
3553: arp_standard.debug( 'doc sequence id = ' || l_sequence_id);
3554: arp_standard.debug( 'doc sequence value = ' || l_sequence_value);
3555: END IF;
3556: ELSE

Line 3553: arp_standard.debug( 'doc sequence id = ' || l_sequence_id);

3549: END;
3550:
3551: IF PG_DEBUG in ('Y', 'C') THEN
3552: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
3553: arp_standard.debug( 'doc sequence id = ' || l_sequence_id);
3554: arp_standard.debug( 'doc sequence value = ' || l_sequence_value);
3555: END IF;
3556: ELSE
3557: p_adj_rec.doc_sequence_value := NULL;

Line 3554: arp_standard.debug( 'doc sequence value = ' || l_sequence_value);

3550:
3551: IF PG_DEBUG in ('Y', 'C') THEN
3552: arp_standard.debug( 'doc sequence name = ' || l_sequence_name);
3553: arp_standard.debug( 'doc sequence id = ' || l_sequence_id);
3554: arp_standard.debug( 'doc sequence value = ' || l_sequence_value);
3555: END IF;
3556: ELSE
3557: p_adj_rec.doc_sequence_value := NULL;
3558: p_adj_rec.doc_sequence_id := NULL;

Line 3565: arp_standard.application_id

3561:
3562: /*
3563: p_adj_rec.doc_sequence_value :=
3564: FND_SEQNUM.get_next_auto_sequence (
3565: arp_standard.application_id
3566: , l_rec_name
3567: , arp_standard.sysparm.set_of_books_id
3568: , 'A'
3569: , to_char(p_adj_rec.apply_date,'YYYY/MM/DD'));

Line 3567: , arp_standard.sysparm.set_of_books_id

3563: p_adj_rec.doc_sequence_value :=
3564: FND_SEQNUM.get_next_auto_sequence (
3565: arp_standard.application_id
3566: , l_rec_name
3567: , arp_standard.sysparm.set_of_books_id
3568: , 'A'
3569: , to_char(p_adj_rec.apply_date,'YYYY/MM/DD'));
3570: */
3571: p_adj_rec.set_of_books_id := arp_standard.sysparm.set_of_books_id;

Line 3571: p_adj_rec.set_of_books_id := arp_standard.sysparm.set_of_books_id;

3567: , arp_standard.sysparm.set_of_books_id
3568: , 'A'
3569: , to_char(p_adj_rec.apply_date,'YYYY/MM/DD'));
3570: */
3571: p_adj_rec.set_of_books_id := arp_standard.sysparm.set_of_books_id;
3572: p_adj_rec.batch_id := NULL;
3573: p_adj_rec.distribution_set_id := NULL;
3574: p_adj_rec.gl_posted_date := NULL;
3575: p_adj_rec.comments := 'XXXXXXX';

Line 3587: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );

3583:
3584: -- Insert opposing adjustment
3585:
3586: IF PG_DEBUG in ('Y', 'C') THEN
3587: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );
3588: END IF;
3589: arp_adj_pkg.insert_p( p_adj_rec, l_new_adj_id );
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );

Line 3591: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );

3587: arp_standard.debug( 'before ar_adjustments_pkg.insert_p in app_delete' );
3588: END IF;
3589: arp_adj_pkg.insert_p( p_adj_rec, l_new_adj_id );
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: arp_standard.debug( 'after ar_adjustments_pkg.insert_p in app_delete' );
3592: END IF;
3593:
3594:
3595: /* VAT changes: create acct entry */

Line 3697: * arp_standard.debug( 'before arp_process_tax.sync_vendor_f_ct_adj_id' );

3693: * /o VAT changes o/
3694: *
3695: * THEN
3696: * IF PG_DEBUG in ('Y', 'C') THEN
3697: * arp_standard.debug( 'before arp_process_tax.sync_vendor_f_ct_adj_id' );
3698: * END IF;
3699: *
3700: * /o--------------------------------------------------------+
3701: * | Synchronize Tax Vendor. |

Line 3714: * arp_standard.debug( 'after arp_process_tax.sync_vendor_f_ct_adj_id' );

3710: * null;
3711: * END;
3712: *
3713: * IF PG_DEBUG in ('Y', 'C') THEN
3714: * arp_standard.debug( 'after arp_process_tax.sync_vendor_f_ct_adj_id' );
3715: * END IF;
3716: *
3717: * END IF;
3718: *********************************************************************/

Line 3721: arp_standard.debug( 'arp_process_adjustment.insert_reverse_actions()-');

3717: * END IF;
3718: *********************************************************************/
3719:
3720: IF PG_DEBUG in ('Y', 'C') THEN
3721: arp_standard.debug( 'arp_process_adjustment.insert_reverse_actions()-');
3722: END IF;
3723:
3724: EXCEPTION
3725: WHEN OTHERS THEN

Line 3727: arp_standard.debug(

3723:
3724: EXCEPTION
3725: WHEN OTHERS THEN
3726: IF PG_DEBUG in ('Y', 'C') THEN
3727: arp_standard.debug(
3728: 'EXCEPTION: arp_process_adjustment.insert_reverse_actions');
3729: END IF;
3730: RAISE;
3731: END insert_reverse_actions;

Line 3759: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()+' );

3755: PROCEDURE val_insert_rev_actions(
3756: p_adj_id IN ar_adjustments.adjustment_id%TYPE ) IS
3757: BEGIN
3758: IF PG_DEBUG in ('Y', 'C') THEN
3759: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()+' );
3760: END IF;
3761: IF ( p_adj_id IS NULL ) THEN
3762: IF PG_DEBUG in ('Y', 'C') THEN
3763: arp_standard.debug( ' Null values found in input variable' );

Line 3763: arp_standard.debug( ' Null values found in input variable' );

3759: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()+' );
3760: END IF;
3761: IF ( p_adj_id IS NULL ) THEN
3762: IF PG_DEBUG in ('Y', 'C') THEN
3763: arp_standard.debug( ' Null values found in input variable' );
3764: END IF;
3765: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );
3766: APP_EXCEPTION.raise_exception;
3767: END IF;

Line 3770: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()-' );

3766: APP_EXCEPTION.raise_exception;
3767: END IF;
3768: --
3769: IF PG_DEBUG in ('Y', 'C') THEN
3770: arp_standard.debug( 'arp_process_adjustment.val_insert_rev_actions()-' );
3771: END IF;
3772: EXCEPTION
3773: WHEN OTHERS THEN
3774: IF PG_DEBUG in ('Y', 'C') THEN

Line 3775: arp_standard.debug(

3771: END IF;
3772: EXCEPTION
3773: WHEN OTHERS THEN
3774: IF PG_DEBUG in ('Y', 'C') THEN
3775: arp_standard.debug(
3776: 'EXCEPTION: arp_process_adjustment.val_insert_rev_actions' );
3777: END IF;
3778: RAISE;
3779: END val_insert_rev_actions;

Line 3992: p_internal_org_id => arp_standard.sysparm.org_id,

3988: p_validation_level => NULL,
3989: x_return_status => l_return_status,
3990: x_msg_count => l_msg_count,
3991: x_msg_data => l_msg_data,
3992: p_internal_org_id => arp_standard.sysparm.org_id,
3993: p_legal_entity_id => l_le_id,
3994: p_transaction_date => p_apply_date,
3995: p_related_doc_date => NULL,
3996: p_adjusted_doc_date=> NULL,

Line 4014: AND (zxa.internal_organization_id = arp_standard.sysparm.org_id

4010: AND p_apply_date
4011: BETWEEN nvl(zxr.effective_from, p_apply_date)
4012: AND nvl(zxr.effective_to, p_apply_date)
4013: AND zxr.tax_rate_code = l_asset_tax_code
4014: AND (zxa.internal_organization_id = arp_standard.sysparm.org_id
4015: OR zxa.internal_organization_id IS NULL)
4016: AND active_flag = 'Y';
4017:
4018: