DBA Data[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on FND_PROFILE

Line 145: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');

141: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');
142: --fnd_global.apps_initialize(FND_GLOBAL.USER_ID, FND_GLOBAL.RESP_ID, FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.SECURITY_GROUP_ID);
143:
144: /* getting msg logging info */
145: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
146: G_MSG_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
147: /*
148: if (G_LOG_ENABLED = 'N') then
149: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;

Line 151: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

147: /*
148: if (G_LOG_ENABLED = 'N') then
149: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
150: else
151: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
152: end if;
153: */
154:
155: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);

Line 159: -- g_org_id := to_number(fnd_profile.value('ORG_ID'));

155: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
156: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);
157:
158: /* getting org_id */
159: -- g_org_id := to_number(fnd_profile.value('ORG_ID'));
160: g_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
161: LogMessage(FND_LOG.LEVEL_STATEMENT, 'g_org_id: ' || g_org_id);
162: l_org_status := MO_GLOBAL.check_valid_org(g_org_id);
163: LogMessage(FND_LOG.LEVEL_STATEMENT, 'MO_GLOBAL.check_valid_org(' || g_org_id || '): ' || l_org_status);

Line 1302: l_bill_0_prin_inv := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_PRIN_INV'), 'N');

1298: l_phase := 'Term';
1299: end if;
1300:
1301: -- fix for bug 5840180: get LNS_CREATE_ZERO_PRIN_INV profile value to see if we need to bill 0 amount principal invoices
1302: l_bill_0_prin_inv := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_PRIN_INV'), 'N');
1303: LogMessage(FND_LOG.LEVEL_STATEMENT, 'The profile LNS_CREATE_ZERO_PRIN_INV value is : '||l_bill_0_prin_inv);
1304:
1305: select LNS_AMORTIZATION_SCHEDS_S.NEXTVAL into P_LOAN_REC.NEXT_AMORTIZATION_ID from dual;
1306:

Line 4127: l_create_zero_instal := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_INSTAL'), 'N');

4123:
4124: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0. ');
4125:
4126: -- fix for bug 7000066: get LNS_CREATE_ZERO_INSTAL profile value to see if we need to create 0 amount installment
4127: l_create_zero_instal := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_INSTAL'), 'N');
4128: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CREATE_ZERO_INSTAL profile: ' || l_create_zero_instal);
4129:
4130: if l_create_zero_instal = 'N' then
4131:

Line 4133: from FND_PROFILE_OPTIONS_VL

4129:
4130: if l_create_zero_instal = 'N' then
4131:
4132: select USER_PROFILE_OPTION_NAME into l_profile_name
4133: from FND_PROFILE_OPTIONS_VL
4134: where PROFILE_OPTION_NAME = 'LNS_CREATE_ZERO_INSTAL';
4135:
4136: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');
4137: FND_MESSAGE.SET_TOKEN('PROFILE', l_profile_name);

Line 7657: l_ussgl_flag := NVL(FND_PROFILE.VALUE('USSGL_OPTION'), 'N');

7653:
7654:
7655: /* based on profile USSGL_OPTION value verify value for USSGL_TRANSACTION_CODE */
7656: /* commented out by raverma 07-29-2005
7657: l_ussgl_flag := NVL(FND_PROFILE.VALUE('USSGL_OPTION'), 'N');
7658:
7659: if l_ussgl_flag = 'Y' then
7660:
7661: if g_USSGL_TRANSACTION_CODE is null then

Line 8819: l_create_zero_instal := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_INSTAL'), 'N');

8815:
8816: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'All amounts returned from lns_financials.getInstallment = 0.');
8817:
8818: -- fix for bug 7000066: get LNS_CREATE_ZERO_INSTAL profile value to see if we need to create 0 amount installment
8819: l_create_zero_instal := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_INSTAL'), 'N');
8820: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LNS_CREATE_ZERO_INSTAL profile: ' || l_create_zero_instal);
8821:
8822: if l_create_zero_instal = 'N' then
8823:

Line 8825: from FND_PROFILE_OPTIONS_VL

8821:
8822: if l_create_zero_instal = 'N' then
8823:
8824: select USER_PROFILE_OPTION_NAME into l_profile_name
8825: from FND_PROFILE_OPTIONS_VL
8826: where PROFILE_OPTION_NAME = 'LNS_CREATE_ZERO_INSTAL';
8827:
8828: --LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Billing of zero amount installments is disallowed by profile LNS: Create Zero Amount Installments.');
8829: FND_MESSAGE.SET_NAME('LNS', 'LNS_CANT_BILL_ZERO_AMOUNT');

Line 8847: if (l_amortization_rec.PRINCIPAL_AMOUNT = 0 and NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_PRIN_INV'), 'N') = 'Y') or

8843: X_RA_TERM_ID => l_term_id);
8844:
8845: i := 0;
8846:
8847: if (l_amortization_rec.PRINCIPAL_AMOUNT = 0 and NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_PRIN_INV'), 'N') = 'Y') or
8848: l_amortization_rec.PRINCIPAL_AMOUNT > 0
8849: then
8850: i := i + 1;
8851: l_invoices_tbl(i).CUST_TRX_ID := null;

Line 11140: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');

11136: G_LOG_ENABLED := 'N';
11137: G_MSG_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11138:
11139: /* getting msg logging info */
11140: G_LOG_ENABLED := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'), 'N');
11141: /*
11142: if (G_LOG_ENABLED = 'N') then
11143: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
11144: else

Line 11145: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);

11141: /*
11142: if (G_LOG_ENABLED = 'N') then
11143: G_MSG_LEVEL := FND_LOG.LEVEL_UNEXPECTED;
11144: else
11145: G_MSG_LEVEL := NVL(to_number(FND_PROFILE.VALUE('AFLOG_LEVEL')), FND_LOG.LEVEL_UNEXPECTED);
11146: end if;
11147: */
11148: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_LOG_ENABLED: ' || G_LOG_ENABLED);
11149: LogMessage(FND_LOG.LEVEL_STATEMENT, 'G_MSG_LEVEL: ' || G_MSG_LEVEL);