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 CN_MESSAGE_PKG

Line 237: cn_message_pkg.debug('Exception occurs in reversing posted line (ID='|| p_commission_line_id||')');

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||')');
238: cn_message_pkg.debug(sqlerrm);
239: RAISE;
240: END revert_posting_line;
241:

Line 238: cn_message_pkg.debug(sqlerrm);

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||')');
238: cn_message_pkg.debug(sqlerrm);
239: RAISE;
240: END revert_posting_line;
241:
242: PROCEDURE Select_Tier( p_rate_dim_sequence NUMBER,

Line 301: cn_message_pkg.debug('Exception occurs in identifying rate tier:');

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:');
302: cn_message_pkg.debug('p_direction=' || p_direction);
303: cn_message_pkg.debug('p_quota_achieved='|| p_quota_achieved);
304: cn_message_pkg.debug(sqlerrm);
305: RAISE;

Line 302: cn_message_pkg.debug('p_direction=' || p_direction);

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:');
302: cn_message_pkg.debug('p_direction=' || p_direction);
303: cn_message_pkg.debug('p_quota_achieved='|| p_quota_achieved);
304: cn_message_pkg.debug(sqlerrm);
305: RAISE;
306: END Select_Tier;

Line 303: cn_message_pkg.debug('p_quota_achieved='|| p_quota_achieved);

299: sqlerrm);
300: end if;
301: cn_message_pkg.debug('Exception occurs in identifying rate tier:');
302: cn_message_pkg.debug('p_direction=' || p_direction);
303: cn_message_pkg.debug('p_quota_achieved='|| p_quota_achieved);
304: cn_message_pkg.debug(sqlerrm);
305: RAISE;
306: END Select_Tier;
307:

Line 304: cn_message_pkg.debug(sqlerrm);

300: end if;
301: cn_message_pkg.debug('Exception occurs in identifying rate tier:');
302: cn_message_pkg.debug('p_direction=' || p_direction);
303: cn_message_pkg.debug('p_quota_achieved='|| p_quota_achieved);
304: cn_message_pkg.debug(sqlerrm);
305: RAISE;
306: END Select_Tier;
307:
308: PROCEDURE get_rate_sequence(p_number_dim NUMBER ,

Line 334: cn_message_pkg.debug('Exception occurs in getting rate sequence: ');

330: 'cn.plsql.cn_formula_common_pkg.get_rate_sequence.exception',
331: sqlerrm);
332: end if;
333:
334: cn_message_pkg.debug('Exception occurs in getting rate sequence: ');
335: cn_message_pkg.debug(sqlerrm);
336: RAISE;
337: END get_rate_sequence;
338:

Line 335: cn_message_pkg.debug(sqlerrm);

331: sqlerrm);
332: end if;
333:
334: cn_message_pkg.debug('Exception occurs in getting rate sequence: ');
335: cn_message_pkg.debug(sqlerrm);
336: RAISE;
337: END get_rate_sequence;
338:
339:

Line 801: cn_message_pkg.debug('Exception occurs in getting commission rate: ');

797: 'cn.plsql.cn_formula_common_pkg.get_rates.exception',
798: sqlerrm);
799: end if;
800:
801: cn_message_pkg.debug('Exception occurs in getting commission rate: ');
802: cn_message_pkg.debug(sqlerrm);
803: RAISE;
804: END get_rates;
805:

Line 802: cn_message_pkg.debug(sqlerrm);

798: sqlerrm);
799: end if;
800:
801: cn_message_pkg.debug('Exception occurs in getting commission rate: ');
802: cn_message_pkg.debug(sqlerrm);
803: RAISE;
804: END get_rates;
805:
806: PROCEDURE delete_itd_trx( p_salesrep_id NUMBER ,

Line 1137: cn_message_pkg.debug('Profile CN_PRIOR_ADJUSTMENT has value: No ');

1133: setting can be calculated incrementally.
1134: ******************************************************************************/
1135: IF (nvl(cn_system_parameters.value('CN_PRIOR_ADJUSTMENT', l_org_id), 'N') = 'N' ) THEN
1136: l_incremental_flag := 'Y';
1137: cn_message_pkg.debug('Profile CN_PRIOR_ADJUSTMENT has value: No ');
1138: END IF;
1139:
1140: /******************************************************************************
1141: 1). when process_all_flag = 'Y', do non incremental calc.

Line 1156: cn_message_pkg.debug('Parameters that control the calculation initialization');

1152: ELSE
1153: x_select_status_flag := 'P';
1154: END IF;
1155:
1156: cn_message_pkg.debug('Parameters that control the calculation initialization');
1157: cn_message_pkg.debug('--p_process_all_flag: ' || p_process_all_flag);
1158: cn_message_pkg.debug('--l_incremental_flag: ' || l_incremental_flag);
1159: cn_message_pkg.debug('--p_select_status_flag: ' || x_select_status_flag);
1160: cn_message_pkg.debug('--p_trx_group_code: ' || p_trx_group_code);

Line 1157: cn_message_pkg.debug('--p_process_all_flag: ' || p_process_all_flag);

1153: x_select_status_flag := 'P';
1154: END IF;
1155:
1156: cn_message_pkg.debug('Parameters that control the calculation initialization');
1157: cn_message_pkg.debug('--p_process_all_flag: ' || p_process_all_flag);
1158: cn_message_pkg.debug('--l_incremental_flag: ' || l_incremental_flag);
1159: cn_message_pkg.debug('--p_select_status_flag: ' || x_select_status_flag);
1160: cn_message_pkg.debug('--p_trx_group_code: ' || p_trx_group_code);
1161:

Line 1158: cn_message_pkg.debug('--l_incremental_flag: ' || l_incremental_flag);

1154: END IF;
1155:
1156: cn_message_pkg.debug('Parameters that control the calculation initialization');
1157: cn_message_pkg.debug('--p_process_all_flag: ' || p_process_all_flag);
1158: cn_message_pkg.debug('--l_incremental_flag: ' || l_incremental_flag);
1159: cn_message_pkg.debug('--p_select_status_flag: ' || x_select_status_flag);
1160: cn_message_pkg.debug('--p_trx_group_code: ' || p_trx_group_code);
1161:
1162: -- initialize ptd value to be 0, ptd = 0;

Line 1159: cn_message_pkg.debug('--p_select_status_flag: ' || x_select_status_flag);

1155:
1156: cn_message_pkg.debug('Parameters that control the calculation initialization');
1157: cn_message_pkg.debug('--p_process_all_flag: ' || p_process_all_flag);
1158: cn_message_pkg.debug('--l_incremental_flag: ' || l_incremental_flag);
1159: cn_message_pkg.debug('--p_select_status_flag: ' || x_select_status_flag);
1160: cn_message_pkg.debug('--p_trx_group_code: ' || p_trx_group_code);
1161:
1162: -- initialize ptd value to be 0, ptd = 0;
1163: x_input_achieved_ptd(1) := 0;

Line 1160: cn_message_pkg.debug('--p_trx_group_code: ' || p_trx_group_code);

1156: cn_message_pkg.debug('Parameters that control the calculation initialization');
1157: cn_message_pkg.debug('--p_process_all_flag: ' || p_process_all_flag);
1158: cn_message_pkg.debug('--l_incremental_flag: ' || l_incremental_flag);
1159: cn_message_pkg.debug('--p_select_status_flag: ' || x_select_status_flag);
1160: cn_message_pkg.debug('--p_trx_group_code: ' || p_trx_group_code);
1161:
1162: -- initialize ptd value to be 0, ptd = 0;
1163: x_input_achieved_ptd(1) := 0;
1164: x_output_achieved_ptd := 0;

Line 1253: cn_message_pkg.debug('p_trx_group_code: ' || p_trx_group_code );

1249:
1250: -- case3 : IF l_incremental_flag = 'Y' and trx_group_code = 'INDIVIDUAL'
1251: -- itd = itd, ptd = ptd
1252: IF l_incremental_flag = 'Y' AND p_trx_group_code = 'INDIVIDUAL' THEN
1253: cn_message_pkg.debug('p_trx_group_code: ' || p_trx_group_code );
1254:
1255: SELECT nvl(quota.input_achieved_itd,0), Nvl( quota.input_achieved_ptd, 0),
1256: nvl(quota.output_achieved_itd,0), Nvl(quota.output_achieved_ptd, 0),
1257: nvl(quota.perf_achieved_itd, 0), Nvl(quota.perf_achieved_ptd, 0),

Line 1288: cn_message_pkg.debug('Initialized values');

1284:
1285: END IF;
1286: END IF; -- end of p_process_all_flag check
1287:
1288: cn_message_pkg.debug('Initialized values');
1289: FOR i IN 1..x_input_achieved_itd.COUNT LOOP
1290: cn_message_pkg.debug('--x_input_achieved_itd: ' || x_input_achieved_itd(i));
1291: END LOOP;
1292:

Line 1290: cn_message_pkg.debug('--x_input_achieved_itd: ' || x_input_achieved_itd(i));

1286: END IF; -- end of p_process_all_flag check
1287:
1288: cn_message_pkg.debug('Initialized values');
1289: FOR i IN 1..x_input_achieved_itd.COUNT LOOP
1290: cn_message_pkg.debug('--x_input_achieved_itd: ' || x_input_achieved_itd(i));
1291: END LOOP;
1292:
1293: cn_message_pkg.debug('--x_output_achieved_itd: ' || x_output_achieved_itd);
1294: cn_message_pkg.debug('--x_perf_achieved_itd: ' || x_perf_achieved_itd);

Line 1293: cn_message_pkg.debug('--x_output_achieved_itd: ' || x_output_achieved_itd);

1289: FOR i IN 1..x_input_achieved_itd.COUNT LOOP
1290: cn_message_pkg.debug('--x_input_achieved_itd: ' || x_input_achieved_itd(i));
1291: END LOOP;
1292:
1293: cn_message_pkg.debug('--x_output_achieved_itd: ' || x_output_achieved_itd);
1294: cn_message_pkg.debug('--x_perf_achieved_itd: ' || x_perf_achieved_itd);
1295: cn_message_pkg.debug('--x_commission_payed_itd: ' || x_commission_payed_itd );
1296:
1297: FOR i IN 1..x_input_achieved_ptd.COUNT LOOP

Line 1294: cn_message_pkg.debug('--x_perf_achieved_itd: ' || x_perf_achieved_itd);

1290: cn_message_pkg.debug('--x_input_achieved_itd: ' || x_input_achieved_itd(i));
1291: END LOOP;
1292:
1293: cn_message_pkg.debug('--x_output_achieved_itd: ' || x_output_achieved_itd);
1294: cn_message_pkg.debug('--x_perf_achieved_itd: ' || x_perf_achieved_itd);
1295: cn_message_pkg.debug('--x_commission_payed_itd: ' || x_commission_payed_itd );
1296:
1297: FOR i IN 1..x_input_achieved_ptd.COUNT LOOP
1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));

Line 1295: cn_message_pkg.debug('--x_commission_payed_itd: ' || x_commission_payed_itd );

1291: END LOOP;
1292:
1293: cn_message_pkg.debug('--x_output_achieved_itd: ' || x_output_achieved_itd);
1294: cn_message_pkg.debug('--x_perf_achieved_itd: ' || x_perf_achieved_itd);
1295: cn_message_pkg.debug('--x_commission_payed_itd: ' || x_commission_payed_itd );
1296:
1297: FOR i IN 1..x_input_achieved_ptd.COUNT LOOP
1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));
1299: END LOOP;

Line 1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));

1294: cn_message_pkg.debug('--x_perf_achieved_itd: ' || x_perf_achieved_itd);
1295: cn_message_pkg.debug('--x_commission_payed_itd: ' || x_commission_payed_itd );
1296:
1297: FOR i IN 1..x_input_achieved_ptd.COUNT LOOP
1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));
1299: END LOOP;
1300: cn_message_pkg.debug('--x_output_achieved_ptd: ' || x_output_achieved_ptd);
1301: cn_message_pkg.debug('--x_perf_achieved_ptd: ' || x_perf_achieved_ptd);
1302: cn_message_pkg.debug('--x_commission_payed_ptd: ' || x_commission_payed_ptd );

Line 1300: cn_message_pkg.debug('--x_output_achieved_ptd: ' || x_output_achieved_ptd);

1296:
1297: FOR i IN 1..x_input_achieved_ptd.COUNT LOOP
1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));
1299: END LOOP;
1300: cn_message_pkg.debug('--x_output_achieved_ptd: ' || x_output_achieved_ptd);
1301: cn_message_pkg.debug('--x_perf_achieved_ptd: ' || x_perf_achieved_ptd);
1302: cn_message_pkg.debug('--x_commission_payed_ptd: ' || x_commission_payed_ptd );
1303:
1304: ELSIF p_calc_type = 'BONUS' THEN

Line 1301: cn_message_pkg.debug('--x_perf_achieved_ptd: ' || x_perf_achieved_ptd);

1297: FOR i IN 1..x_input_achieved_ptd.COUNT LOOP
1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));
1299: END LOOP;
1300: cn_message_pkg.debug('--x_output_achieved_ptd: ' || x_output_achieved_ptd);
1301: cn_message_pkg.debug('--x_perf_achieved_ptd: ' || x_perf_achieved_ptd);
1302: cn_message_pkg.debug('--x_commission_payed_ptd: ' || x_commission_payed_ptd );
1303:
1304: ELSIF p_calc_type = 'BONUS' THEN
1305: -- do nothing since we already initialize ptd =0 and itd = itd - ptd

Line 1302: cn_message_pkg.debug('--x_commission_payed_ptd: ' || x_commission_payed_ptd );

1298: cn_message_pkg.debug('--x_input_achieved_ptd: ' || x_input_achieved_ptd(i));
1299: END LOOP;
1300: cn_message_pkg.debug('--x_output_achieved_ptd: ' || x_output_achieved_ptd);
1301: cn_message_pkg.debug('--x_perf_achieved_ptd: ' || x_perf_achieved_ptd);
1302: cn_message_pkg.debug('--x_commission_payed_ptd: ' || x_commission_payed_ptd );
1303:
1304: ELSIF p_calc_type = 'BONUS' THEN
1305: -- do nothing since we already initialize ptd =0 and itd = itd - ptd
1306: -- because bonus type formula are guaranteed to be NON-cumulative, INDIVIDUAL, NON-itd

Line 1544: cn_message_pkg.debug( substr(FND_MSG_PUB.get(p_msg_index => l_counter,

1540: p_srp_pe_subledger => l_srp_pe_subledger);
1541:
1542:
1543: FOR l_counter IN 1..l_msg_count LOOP
1544: cn_message_pkg.debug( substr(FND_MSG_PUB.get(p_msg_index => l_counter,
1545: p_encoded => FND_API.G_FALSE), 1, 249 ));
1546: END LOOP;
1547: EXCEPTION
1548: WHEN OTHERS THEN

Line 1555: cn_message_pkg.debug('Exception occurs in calculate_roll ');

1551: 'cn.plsql.cn_formula_common_pkg.calculate_roll.exception',
1552: sqlerrm);
1553: end if;
1554:
1555: cn_message_pkg.debug('Exception occurs in calculate_roll ');
1556: cn_message_pkg.debug(sqlerrm);
1557: RAISE;
1558: END calculate_roll;
1559:

Line 1556: cn_message_pkg.debug(sqlerrm);

1552: sqlerrm);
1553: end if;
1554:
1555: cn_message_pkg.debug('Exception occurs in calculate_roll ');
1556: cn_message_pkg.debug(sqlerrm);
1557: RAISE;
1558: END calculate_roll;
1559:
1560: -- Work as a dispatcher to invoke the corresponding cn_formula_id_pkg.calculate_quota

Line 1619: cn_message_pkg.debug('Resource: '||l_statement);

1615: AND q.org_id = f.org_id(+);
1616:
1617: if (l_debug_flag = 'Y') then
1618: select name into l_statement from cn_salesreps where salesrep_id = p_salesrep_id and org_id = l_org_id;
1619: cn_message_pkg.debug('Resource: '||l_statement);
1620: cn_message_pkg.debug('Plan element: '||l_pe_name);
1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);

Line 1620: cn_message_pkg.debug('Plan element: '||l_pe_name);

1616:
1617: if (l_debug_flag = 'Y') then
1618: select name into l_statement from cn_salesreps where salesrep_id = p_salesrep_id and org_id = l_org_id;
1619: cn_message_pkg.debug('Resource: '||l_statement);
1620: cn_message_pkg.debug('Plan element: '||l_pe_name);
1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);

Line 1621: cn_message_pkg.debug('Formula: '||l_formula_name);

1617: if (l_debug_flag = 'Y') then
1618: select name into l_statement from cn_salesreps where salesrep_id = p_salesrep_id and org_id = l_org_id;
1619: cn_message_pkg.debug('Resource: '||l_statement);
1620: cn_message_pkg.debug('Plan element: '||l_pe_name);
1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);

Line 1622: cn_message_pkg.debug('Calculation parameters:');

1618: select name into l_statement from cn_salesreps where salesrep_id = p_salesrep_id and org_id = l_org_id;
1619: cn_message_pkg.debug('Resource: '||l_statement);
1620: cn_message_pkg.debug('Plan element: '||l_pe_name);
1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);

Line 1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);

1619: cn_message_pkg.debug('Resource: '||l_statement);
1620: cn_message_pkg.debug('Plan element: '||l_pe_name);
1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);

Line 1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);

1620: cn_message_pkg.debug('Plan element: '||l_pe_name);
1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);
1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);

Line 1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);

1621: cn_message_pkg.debug('Formula: '||l_formula_name);
1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);
1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);
1629: cn_message_pkg.debug('--p_calc_type: ' || p_calc_type);

Line 1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);

1622: cn_message_pkg.debug('Calculation parameters:');
1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);
1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);
1629: cn_message_pkg.debug('--p_calc_type: ' || p_calc_type);
1630: end if;

Line 1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);

1623: cn_message_pkg.debug('--p_srp_plan_assign_id: ' || p_srp_plan_assign_id);
1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);
1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);
1629: cn_message_pkg.debug('--p_calc_type: ' || p_calc_type);
1630: end if;
1631:

Line 1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);

1624: cn_message_pkg.debug('--p_salesrep_id: ' || p_salesrep_id);
1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);
1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);
1629: cn_message_pkg.debug('--p_calc_type: ' || p_calc_type);
1630: end if;
1631:
1632: IF l_quota_type = 'FORMULA' THEN

Line 1629: cn_message_pkg.debug('--p_calc_type: ' || p_calc_type);

1625: cn_message_pkg.debug('--p_period_id: ' || p_period_id);
1626: cn_message_pkg.debug('--p_start_date: ' || p_start_date);
1627: cn_message_pkg.debug('--p_quota_id: ' || p_quota_id);
1628: cn_message_pkg.debug('--p_intel_calc_flag: ' || p_intel_calc_flag);
1629: cn_message_pkg.debug('--p_calc_type: ' || p_calc_type);
1630: end if;
1631:
1632: IF l_quota_type = 'FORMULA' THEN
1633: l_statement := 'begin cn_formula_' || abs(l_formula_id) || '_' || abs(l_org_id) || '_pkg';

Line 1670: cn_message_pkg.debug('Finish caculating plan element: '||l_pe_name);

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);
1671: cn_message_pkg.debug(' ');
1672: EXCEPTION
1673: WHEN OTHERS THEN
1674: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1671: cn_message_pkg.debug(' ');

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);
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,

Line 1679: cn_message_pkg.debug('Excpetion occurs in calculate_quota dispatcher: ');

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: ');
1680: cn_message_pkg.debug(sqlerrm);
1681: RAISE;
1682: END calculate_quota;
1683:

Line 1680: cn_message_pkg.debug(sqlerrm);

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: ');
1680: cn_message_pkg.debug(sqlerrm);
1681: RAISE;
1682: END calculate_quota;
1683:
1684:

Line 1981: cn_message_pkg.debug('Process plan elements in notify log only (try incremental calc)');

1977: OPEN l_check_calc_entry_csr(spp.salesrep_id, spp.period_id);
1978: FETCH l_check_calc_entry_csr INTO l_counter;
1979:
1980: IF l_check_calc_entry_csr%found THEN
1981: cn_message_pkg.debug('Process plan elements in notify log only (try incremental calc)');
1982: FOR l_pe IN l_srp_quotas_csr(spp.srp_plan_assign_id, spp.salesrep_id, spp.period_id) LOOP
1983: if (l_quota_sequence > l_pe.quota_sequence) then
1984: l_quota_sequence := l_pe.quota_sequence;
1985: end if;

Line 2010: cn_message_pkg.debug('Process plan elements in notify log only (Non incremental calc)');

2006: swap_dates ( l_current_processed_date, l_next_processed_date);
2007:
2008: END LOOP;
2009: ELSE
2010: cn_message_pkg.debug('Process plan elements in notify log only (Non incremental calc)');
2011: FOR l_pe IN l_srp_quotas_csr(spp.srp_plan_assign_id, spp.salesrep_id, spp.period_id) LOOP
2012: open l_notify_log_csr(spp.salesrep_id, spp.period_id, l_pe.quota_id);
2013: fetch l_notify_log_csr into l_counter;
2014: if (l_notify_log_csr%found or l_pe.quota_sequence > l_quota_sequence) then

Line 2184: cn_message_pkg.debug('Exception occurs in updating subledgers:');

2180: x_msg_data => l_msg_data,
2181: p_srp_subledger => l_srp_subledger);
2182:
2183: IF l_return_status <> FND_API.g_ret_sts_success THEN
2184: cn_message_pkg.debug('Exception occurs in updating subledgers:');
2185: FOR l_counter IN 1..l_msg_count LOOP
2186: cn_message_pkg.debug(FND_MSG_PUB.get(p_msg_index => l_counter,
2187: p_encoded => FND_API.G_FALSE));
2188: fnd_file.put_line(fnd_file.Log, fnd_msg_pub.get(p_msg_index => l_counter,

Line 2186: cn_message_pkg.debug(FND_MSG_PUB.get(p_msg_index => l_counter,

2182:
2183: IF l_return_status <> FND_API.g_ret_sts_success THEN
2184: cn_message_pkg.debug('Exception occurs in updating subledgers:');
2185: FOR l_counter IN 1..l_msg_count LOOP
2186: cn_message_pkg.debug(FND_MSG_PUB.get(p_msg_index => l_counter,
2187: p_encoded => FND_API.G_FALSE));
2188: fnd_file.put_line(fnd_file.Log, fnd_msg_pub.get(p_msg_index => l_counter,
2189: p_encoded => FND_API.G_FALSE));
2190: END LOOP;

Line 2208: cn_message_pkg.debug('Exception occurs in calculate_batch: ');

2204: 'cn.plsql.cn_formula_common_pkg.calculate_batch.exception',
2205: sqlerrm);
2206: end if;
2207:
2208: cn_message_pkg.debug('Exception occurs in calculate_batch: ');
2209: cn_message_pkg.rollback_errormsg_commit(sqlerrm);
2210: raise;
2211: END calculate_batch;
2212:

Line 2209: cn_message_pkg.rollback_errormsg_commit(sqlerrm);

2205: sqlerrm);
2206: end if;
2207:
2208: cn_message_pkg.debug('Exception occurs in calculate_batch: ');
2209: cn_message_pkg.rollback_errormsg_commit(sqlerrm);
2210: raise;
2211: END calculate_batch;
2212:
2213: -- p_commission_header_id will be the commisson_header_id of the reversal trx created

Line 2701: cn_message_pkg.debug('Reversing transactions in physical batch (ID=' || p_physical_batch_id||')');

2697: AND cl.org_id = l_org_id
2698: AND cl.processed_date BETWEEN p_start_date AND p_end_date);
2699:
2700: BEGIN
2701: cn_message_pkg.debug('Reversing transactions in physical batch (ID=' || p_physical_batch_id||')');
2702:
2703: select org_id into l_org_id
2704: from cn_process_batches_all
2705: where physical_batch_id = p_physical_batch_id

Line 3117: cn_message_pkg.debug('Exception occurs in reversing transactions: ');

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: ');
3118: cn_message_pkg.debug(sqlerrm );
3119: RAISE;
3120: END revert_batch_intel_comm;
3121:

Line 3118: cn_message_pkg.debug(sqlerrm );

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: ');
3118: cn_message_pkg.debug(sqlerrm );
3119: RAISE;
3120: END revert_batch_intel_comm;
3121:
3122: -- do non intelligent revert. revert every system generated trxs

Line 3161: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');

3157: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
3158: l_prog_appl_id NUMBER(15) := fnd_global.prog_appl_id ;
3159:
3160: BEGIN
3161: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');
3162:
3163: select org_id into l_org_id
3164: from cn_process_batches_all
3165: where physical_batch_id = p_batch_id

Line 3343: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');

3339: cl.quota_id in (select quota_id from cn_calc_sub_quotas_all
3340: where calc_sub_batch_id = l_calc_sub_batch_id));
3341:
3342: BEGIN
3343: cn_message_pkg.debug('Reversing transactions in physical batch (ID='||p_batch_id||')');
3344:
3345: OPEN l_sub_batch_csr;
3346: FETCH l_sub_batch_csr INTO l_calc_sub_batch_id, l_interval_type_id, l_org_id;
3347: CLOSE l_sub_batch_csr;

Line 3433: cn_message_pkg.debug('Exception occurs in reversing transactions: ');

3429: 'cn.plsql.cn_formula_common_pkg.revert_batch.exception',
3430: sqlerrm);
3431: end if;
3432:
3433: cn_message_pkg.debug('Exception occurs in reversing transactions: ');
3434: cn_message_pkg.rollback_errormsg_commit(sqlerrm);
3435: raise;
3436: END revert_batch;
3437:

Line 3434: cn_message_pkg.rollback_errormsg_commit(sqlerrm);

3430: sqlerrm);
3431: end if;
3432:
3433: cn_message_pkg.debug('Exception occurs in reversing transactions: ');
3434: cn_message_pkg.rollback_errormsg_commit(sqlerrm);
3435: raise;
3436: END revert_batch;
3437:
3438: -- create a new group by trx if not existed update the existing group by trx if already existed

Line 3674: cn_message_pkg.debug('Creating or updating system-generated transaction ');

3670: 'cn.plsql.cn_formula_common_pkg.create_trx.begin',
3671: 'Within create_trx.');
3672: end if;
3673:
3674: cn_message_pkg.debug('Creating or updating system-generated transaction ');
3675:
3676: IF p_trx_rec.trx_type = 'GRP' THEN
3677: create_update_grp_trx(p_trx_rec);
3678: ELSIF p_trx_rec.trx_type = 'ITD' THEN

Line 3726: cn_message_pkg.debug('Exception occurs in creating or updating system-generated transaction: ');

3722: 'cn.plsql.cn_formula_common_pkg.create_trx.exception',
3723: sqlerrm);
3724: end if;
3725:
3726: cn_message_pkg.debug('Exception occurs in creating or updating system-generated transaction: ');
3727: cn_message_pkg.debug(sqlerrm);
3728: RAISE;
3729: END create_trx ;
3730:

Line 3727: cn_message_pkg.debug(sqlerrm);

3723: sqlerrm);
3724: end if;
3725:
3726: cn_message_pkg.debug('Exception occurs in creating or updating system-generated transaction: ');
3727: cn_message_pkg.debug(sqlerrm);
3728: RAISE;
3729: END create_trx ;
3730:
3731: -- populate the event_factor, payment_factor, quota_factor and payees