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 1581: l_debug_flag VARCHAR2(1) := fnd_profile.value('CN_DEBUG');

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

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

3178: where physical_batch_id = p_batch_id
3179: and salesrep_id = a.salesrep_id);
3180:
3181: -- create reversal of posting line
3182: if (fnd_profile.value('CN_PAY_BY_TRANSACTION') = 'Y') then
3183: FOR l_line IN l_post_lines_csr LOOP
3184: revert_posting_line( l_line.commission_line_id);
3185: END LOOP;
3186: end if;

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

3684: ELSIF p_trx_rec.trx_type = 'BONUS' THEN
3685: l_srp_pe_rec.salesrep_id := p_trx_rec.salesrep_id;
3686: l_srp_pe_rec.quota_id := p_trx_rec.quota_id;
3687:
3688: IF Nvl(fnd_profile.value('CN_SRP_VALIDATION'), 'N') = 'N' THEN
3689: --no need of validation
3690: p_trx_rec.pending_status := 'N';
3691: ELSE -- need to validate
3692: