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.CN_FORMULA_COMMON_PKG dependencies on FND_LOG

Line 232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

228: where commission_line_id = p_commission_line_id;
229: END IF;
230: EXCEPTION
231: WHEN OTHERS THEN
232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
234: 'cn.plsql.cn_formula_common_pkg.revert_posting_line.exception',
235: sqlerrm);
236: end if;

Line 233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

229: END IF;
230: EXCEPTION
231: WHEN OTHERS THEN
232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
234: 'cn.plsql.cn_formula_common_pkg.revert_posting_line.exception',
235: sqlerrm);
236: end if;
237: cn_message_pkg.debug('Exception occurs in reversing posted line (ID='|| p_commission_line_id||')');

Line 296: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

292: END LOOP;
293: END IF;
294: EXCEPTION
295: WHEN OTHERS THEN
296: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
297: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
298: 'cn.plsql.cn_formula_common_pkg.select_tier.exception',
299: sqlerrm);
300: end if;

Line 297: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

293: END IF;
294: EXCEPTION
295: WHEN OTHERS THEN
296: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
297: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
298: 'cn.plsql.cn_formula_common_pkg.select_tier.exception',
299: sqlerrm);
300: end if;
301: cn_message_pkg.debug('Exception occurs in identifying rate tier:');

Line 328: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

324:
325: x_rate_sequence := l_rate_sequence;
326: EXCEPTION
327: WHEN OTHERS THEN
328: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
329: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
330: 'cn.plsql.cn_formula_common_pkg.get_rate_sequence.exception',
331: sqlerrm);
332: end if;

Line 329: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

325: x_rate_sequence := l_rate_sequence;
326: EXCEPTION
327: WHEN OTHERS THEN
328: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
329: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
330: 'cn.plsql.cn_formula_common_pkg.get_rate_sequence.exception',
331: sqlerrm);
332: end if;
333:

Line 795: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

791: RAISE no_data_found;
792: END IF;
793: EXCEPTION
794: WHEN OTHERS THEN
795: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
796: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
797: 'cn.plsql.cn_formula_common_pkg.get_rates.exception',
798: sqlerrm);
799: end if;

Line 796: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

792: END IF;
793: EXCEPTION
794: WHEN OTHERS THEN
795: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
796: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
797: 'cn.plsql.cn_formula_common_pkg.get_rates.exception',
798: sqlerrm);
799: end if;
800:

Line 947: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

943: WHERE srp_period_quota_id = p_srp_period_quota_id
944: ORDER BY input_sequence;
945:
946: BEGIN
947: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'cn.plsql.cn_formula_common_pkg.calculate_init.begin',
950: 'Beginning of calculate_init ...');
951: end if;

Line 948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

944: ORDER BY input_sequence;
945:
946: BEGIN
947: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
949: 'cn.plsql.cn_formula_common_pkg.calculate_init.begin',
950: 'Beginning of calculate_init ...');
951: end if;
952:

Line 1310: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1306: -- because bonus type formula are guaranteed to be NON-cumulative, INDIVIDUAL, NON-itd
1307: NULL;
1308: END IF;
1309:
1310: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1312: 'cn.plsql.cn_formula_common_pkg.calculate_init.end',
1313: 'End of calculate_init');
1314: end if;

Line 1311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1307: NULL;
1308: END IF;
1309:
1310: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1312: 'cn.plsql.cn_formula_common_pkg.calculate_init.end',
1313: 'End of calculate_init');
1314: end if;
1315:

Line 1334: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1330: RETURN l_end_period_id;
1331: EXCEPTION
1332: WHEN OTHERS THEN
1333:
1334: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1335: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1336: 'cn.plsql.cn_formula_common_pkg.get_end_period_id.exception',
1337: sqlerrm);
1338: end if;

Line 1335: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1331: EXCEPTION
1332: WHEN OTHERS THEN
1333:
1334: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1335: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1336: 'cn.plsql.cn_formula_common_pkg.get_end_period_id.exception',
1337: sqlerrm);
1338: end if;
1339:

Line 1435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1431: RETURN l_end_period_id;
1432: EXCEPTION
1433: WHEN OTHERS THEN
1434:
1435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1436: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1437: 'cn.plsql.cn_formula_common_pkg.get_end_period_id.exception',
1438: sqlerrm);
1439: end if;

Line 1436: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1432: EXCEPTION
1433: WHEN OTHERS THEN
1434:
1435: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1436: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1437: 'cn.plsql.cn_formula_common_pkg.get_end_period_id.exception',
1438: sqlerrm);
1439: end if;
1440:

Line 1549: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1545: p_encoded => FND_API.G_FALSE), 1, 249 ));
1546: END LOOP;
1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1550: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1551: 'cn.plsql.cn_formula_common_pkg.calculate_roll.exception',
1552: sqlerrm);
1553: end if;

Line 1550: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1546: END LOOP;
1547: EXCEPTION
1548: WHEN OTHERS THEN
1549: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1550: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1551: 'cn.plsql.cn_formula_common_pkg.calculate_roll.exception',
1552: sqlerrm);
1553: end if;
1554:

Line 1583: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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',
1586: 'Begin of Calculate_Quota:'||' p_srp_plan_assign_id ' || p_srp_plan_assign_id ||
1587: ' p_salesrep_id ' || p_salesrep_id ||

Line 1584: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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',
1586: 'Begin of Calculate_Quota:'||' p_srp_plan_assign_id ' || p_srp_plan_assign_id ||
1587: ' p_salesrep_id ' || p_salesrep_id ||
1588: ' p_period_id ' || p_period_id ||

Line 1665: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1661: p_start_date, p_quota_id, p_process_all_flag, p_intel_calc_flag, p_calc_type,
1662: l_credit_type_id, l_role_id, IN OUT p_latest_processed_date ;
1663: END IF;
1664:
1665: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1667: 'cn.plsql.cn_formula_common_pkg.calculate_quota.end',
1668: 'End of Calculate_Quota.');
1669: end if;

Line 1666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1662: l_credit_type_id, l_role_id, IN OUT p_latest_processed_date ;
1663: END IF;
1664:
1665: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1666: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1667: 'cn.plsql.cn_formula_common_pkg.calculate_quota.end',
1668: 'End of Calculate_Quota.');
1669: end if;
1670: cn_message_pkg.debug('Finish caculating plan element: '||l_pe_name);

Line 1674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1670: cn_message_pkg.debug('Finish caculating plan element: '||l_pe_name);
1671: cn_message_pkg.debug(' ');
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1676: 'cn.plsql.cn_formula_common_pkg.calculate_quota.exception',
1677: sqlerrm);
1678: end if;

Line 1675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1671: cn_message_pkg.debug(' ');
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1675: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1676: 'cn.plsql.cn_formula_common_pkg.calculate_quota.exception',
1677: sqlerrm);
1678: end if;
1679: cn_message_pkg.debug('Excpetion occurs in calculate_quota dispatcher: ');

Line 1846: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1842: ORDER BY inlv.salesrep_id, inlv.end_date, inlv.quota_sequence;
1843:
1844:
1845: BEGIN
1846: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1848: 'cn.plsql.cn_formula_common_pkg.calculate_batch.begin',
1849: 'Beginning of calculate_batch ...');
1850: end if;

Line 1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1843:
1844:
1845: BEGIN
1846: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1848: 'cn.plsql.cn_formula_common_pkg.calculate_batch.begin',
1849: 'Beginning of calculate_batch ...');
1850: end if;
1851:

Line 2195: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2191:
2192: RAISE api_call_failed;
2193: END IF;
2194:
2195: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2197: 'cn.plsql.cn_formula_common_pkg.calculate_batch.end',
2198: 'End of calculate_batch ...');
2199: end if;

Line 2196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2192: RAISE api_call_failed;
2193: END IF;
2194:
2195: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2196: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2197: 'cn.plsql.cn_formula_common_pkg.calculate_batch.end',
2198: 'End of calculate_batch ...');
2199: end if;
2200: EXCEPTION

Line 2202: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

2198: 'End of calculate_batch ...');
2199: end if;
2200: EXCEPTION
2201: WHEN others THEN
2202: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2203: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2204: 'cn.plsql.cn_formula_common_pkg.calculate_batch.exception',
2205: sqlerrm);
2206: end if;

Line 2203: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2199: end if;
2200: EXCEPTION
2201: WHEN others THEN
2202: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2203: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2204: 'cn.plsql.cn_formula_common_pkg.calculate_batch.exception',
2205: sqlerrm);
2206: end if;
2207:

Line 3112: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3108:
3109: END LOOP;
3110: EXCEPTION
3111: WHEN OTHERS THEN
3112: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3113: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3114: 'cn.plsql.cn_formula_common_pkg.revert_batch_intel_comm.exception',
3115: sqlerrm);
3116: end if;

Line 3113: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3109: END LOOP;
3110: EXCEPTION
3111: WHEN OTHERS THEN
3112: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3113: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3114: 'cn.plsql.cn_formula_common_pkg.revert_batch_intel_comm.exception',
3115: sqlerrm);
3116: end if;
3117: cn_message_pkg.debug('Exception occurs in reversing transactions: ');

Line 3427: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3423: revert_batch_nonintel_bonus(p_batch_id);
3424: END IF;
3425: EXCEPTION
3426: when others then
3427: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3428: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3429: 'cn.plsql.cn_formula_common_pkg.revert_batch.exception',
3430: sqlerrm);
3431: end if;

Line 3428: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3424: END IF;
3425: EXCEPTION
3426: when others then
3427: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3428: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3429: 'cn.plsql.cn_formula_common_pkg.revert_batch.exception',
3430: sqlerrm);
3431: end if;
3432:

Line 3668: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3664: l_return_status VARCHAR2(30);
3665: l_validation_status VARCHAR2(1);
3666: l_srp_pe_rec cn_srp_validation_pub.srp_pe_rec_type ;
3667: BEGIN
3668: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3670: 'cn.plsql.cn_formula_common_pkg.create_trx.begin',
3671: 'Within create_trx.');
3672: end if;

Line 3669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3665: l_validation_status VARCHAR2(1);
3666: l_srp_pe_rec cn_srp_validation_pub.srp_pe_rec_type ;
3667: BEGIN
3668: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3669: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3670: 'cn.plsql.cn_formula_common_pkg.create_trx.begin',
3671: 'Within create_trx.');
3672: end if;
3673:

Line 3720: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

3716: create_new_trx(p_trx_rec);
3717: END IF;
3718: EXCEPTION
3719: WHEN OTHERS THEN
3720: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3721: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3722: 'cn.plsql.cn_formula_common_pkg.create_trx.exception',
3723: sqlerrm);
3724: end if;

Line 3721: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3717: END IF;
3718: EXCEPTION
3719: WHEN OTHERS THEN
3720: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3721: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3722: 'cn.plsql.cn_formula_common_pkg.create_trx.exception',
3723: sqlerrm);
3724: end if;
3725: