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 231: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

Line 232: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 296: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 328: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 795: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 947: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1310: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1334: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 1435: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 1549: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 1583: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1665: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 1674: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 1846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

2175:
2176: RAISE api_call_failed;
2177: END IF;
2178:
2179: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2181: 'cn.plsql.cn_formula_common_pkg.calculate_batch.end',
2182: 'End of calculate_batch ...');
2183: end if;

Line 2180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

2176: RAISE api_call_failed;
2177: END IF;
2178:
2179: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2181: 'cn.plsql.cn_formula_common_pkg.calculate_batch.end',
2182: 'End of calculate_batch ...');
2183: end if;
2184: EXCEPTION

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

2182: 'End of calculate_batch ...');
2183: end if;
2184: EXCEPTION
2185: WHEN others THEN
2186: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2188: 'cn.plsql.cn_formula_common_pkg.calculate_batch.exception',
2189: sqlerrm);
2190: end if;

Line 2187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2183: end if;
2184: EXCEPTION
2185: WHEN others THEN
2186: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2187: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2188: 'cn.plsql.cn_formula_common_pkg.calculate_batch.exception',
2189: sqlerrm);
2190: end if;
2191:

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

3092:
3093: END LOOP;
3094: EXCEPTION
3095: WHEN OTHERS THEN
3096: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3098: 'cn.plsql.cn_formula_common_pkg.revert_batch_intel_comm.exception',
3099: sqlerrm);
3100: end if;

Line 3097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3093: END LOOP;
3094: EXCEPTION
3095: WHEN OTHERS THEN
3096: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3097: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3098: 'cn.plsql.cn_formula_common_pkg.revert_batch_intel_comm.exception',
3099: sqlerrm);
3100: end if;
3101: cn_message_pkg.debug('Exception occurs in reversing transactions: ');

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

3407: revert_batch_nonintel_bonus(p_batch_id);
3408: END IF;
3409: EXCEPTION
3410: when others then
3411: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3412: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3413: 'cn.plsql.cn_formula_common_pkg.revert_batch.exception',
3414: sqlerrm);
3415: end if;

Line 3412: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3408: END IF;
3409: EXCEPTION
3410: when others then
3411: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3412: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3413: 'cn.plsql.cn_formula_common_pkg.revert_batch.exception',
3414: sqlerrm);
3415: end if;
3416:

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

3635: l_return_status VARCHAR2(30);
3636: l_validation_status VARCHAR2(1);
3637: l_srp_pe_rec cn_srp_validation_pub.srp_pe_rec_type ;
3638: BEGIN
3639: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3640: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3641: 'cn.plsql.cn_formula_common_pkg.create_trx.begin',
3642: 'Within create_trx.');
3643: end if;

Line 3640: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

3636: l_validation_status VARCHAR2(1);
3637: l_srp_pe_rec cn_srp_validation_pub.srp_pe_rec_type ;
3638: BEGIN
3639: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3640: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
3641: 'cn.plsql.cn_formula_common_pkg.create_trx.begin',
3642: 'Within create_trx.');
3643: end if;
3644:

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

3687: create_new_trx(p_trx_rec);
3688: END IF;
3689: EXCEPTION
3690: WHEN OTHERS THEN
3691: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3692: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3693: 'cn.plsql.cn_formula_common_pkg.create_trx.exception',
3694: sqlerrm);
3695: end if;

Line 3692: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3688: END IF;
3689: EXCEPTION
3690: WHEN OTHERS THEN
3691: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3692: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3693: 'cn.plsql.cn_formula_common_pkg.create_trx.exception',
3694: sqlerrm);
3695: end if;
3696: