DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on FND_PROFILE

Line 3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1: PACKAGE BODY ARP_PROCESS_ADJUSTMENT AS
2: /* $Header: ARTEADJB.pls 120.44.12020000.5 2012/11/15 13:07:34 ashlkuma ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: pg_msg_level_debug binary_integer;
6: pg_user_id binary_integer;
7: pg_text_dummy varchar2(10);

Line 3496: IF (fnd_profile.value('UNIQUE:SEQ_NUMBERS') <> 'N')

3492: -- Profile option values:
3493: -- 'A' = always used
3494: -- 'P' = Partially Used
3495: -- 'N' = not used
3496: IF (fnd_profile.value('UNIQUE:SEQ_NUMBERS') <> 'N')
3497: THEN
3498: BEGIN
3499:
3500: /* Commented to fix bug #741725, as this does not handle gapless sequence

Line 3542: IF (fnd_profile.value('UNIQUE:SEQ_NUMBERS') = 'A') THEN

3538: set document number to null as adjustment reversal must have
3539: automatic sequence and cannot be entered manually */
3540: EXCEPTION
3541: WHEN NO_DATA_FOUND THEN
3542: IF (fnd_profile.value('UNIQUE:SEQ_NUMBERS') = 'A') THEN
3543: FND_MESSAGE.set_name ('AR', 'AR_TW_NO_DOC_SEQ' );
3544: APP_EXCEPTION.raise_exception;
3545: ELSE
3546: p_adj_rec.doc_sequence_value := NULL;