APPS.CN_FORMULA_COMMON_PKG dependencies on FND_PROFILE

Line 205: If (fnd_profile.value('CN_PAY_BY_TRANSACTION') = 'Y') THEN

201: AND cl.quota_id = pe.quota_id
202: AND cl.srp_payee_assign_id IS NOT NULL
203: AND payee.srp_payee_assign_id = cl.srp_payee_assign_id);
204: BEGIN
205: If (fnd_profile.value('CN_PAY_BY_TRANSACTION') = 'Y') THEN
206: -- Build Payment Record record from Commission Line
207: OPEN get_comm_line_rec;
208: FETCH get_comm_line_rec INTO l_pmt_trans_rec;
209: IF get_comm_line_rec%ROWCOUNT <> 1 THEN

Line 1580: l_debug_flag VARCHAR2(1) := fnd_profile.value('CN_DEBUG');

1576: l_credit_type_id NUMBER;
1577: l_bonus_credit_type_id NUMBER;
1578: l_org_id NUMBER;
1579: l_statement VARCHAR2(1000);
1580: l_debug_flag VARCHAR2(1) := fnd_profile.value('CN_DEBUG');
1581: BEGIN
1582: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1584: 'cn.plsql.cn_formula_common_pkg.calculate_quota.begin',

Line 3166: if (fnd_profile.value('CN_PAY_BY_TRANSACTION') = 'Y') then

3162: where physical_batch_id = p_batch_id
3163: and salesrep_id = a.salesrep_id);
3164:
3165: -- create reversal of posting line
3166: if (fnd_profile.value('CN_PAY_BY_TRANSACTION') = 'Y') then
3167: FOR l_line IN l_post_lines_csr LOOP
3168: revert_posting_line( l_line.commission_line_id);
3169: END LOOP;
3170: end if;

Line 3659: IF Nvl(fnd_profile.value('CN_SRP_VALIDATION'), 'N') = 'N' THEN

3655: ELSIF p_trx_rec.trx_type = 'BONUS' THEN
3656: l_srp_pe_rec.salesrep_id := p_trx_rec.salesrep_id;
3657: l_srp_pe_rec.quota_id := p_trx_rec.quota_id;
3658:
3659: IF Nvl(fnd_profile.value('CN_SRP_VALIDATION'), 'N') = 'N' THEN
3660: --no need of validation
3661: p_trx_rec.pending_status := 'N';
3662: ELSE -- need to validate
3663: