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_GEN_PKG dependencies on CN_MESSAGE_PKG

Line 1934: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');

1930: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
1931: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1932: cn_utils.appindcr(body_code, ' sqlerrm); ');
1933: cn_utils.appindcr(body_code, ' end if; ');
1934: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1935: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1936: cn_utils.appindcr(body_code, ' raise; ');
1937: cn_utils.appindcr(body_code, ' END; ');
1938: cn_utils.appendcr(body_code);

Line 1935: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

1931: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1932: cn_utils.appindcr(body_code, ' sqlerrm); ');
1933: cn_utils.appindcr(body_code, ' end if; ');
1934: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1935: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1936: cn_utils.appindcr(body_code, ' raise; ');
1937: cn_utils.appindcr(body_code, ' END; ');
1938: cn_utils.appendcr(body_code);
1939: cn_utils.appindcr(body_code, ' l_input := nvl(l_input,0); ');

Line 1975: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');

1971: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
1972: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1973: cn_utils.appindcr(body_code, ' sqlerrm); ');
1974: cn_utils.appindcr(body_code, ' end if; ');
1975: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1976: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1977: cn_utils.appindcr(body_code, ' raise; ');
1978:
1979: cn_utils.proc_end( procedure_name, 'N', body_code );

Line 1976: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

1972: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1973: cn_utils.appindcr(body_code, ' sqlerrm); ');
1974: cn_utils.appindcr(body_code, ' end if; ');
1975: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1976: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1977: cn_utils.appindcr(body_code, ' raise; ');
1978:
1979: cn_utils.proc_end( procedure_name, 'N', body_code );
1980: EXCEPTION

Line 2199: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');

2195: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2196: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2197: cn_utils.appindcr(body_code, ' sqlerrm); ');
2198: cn_utils.appindcr(body_code, ' end if; ');
2199: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2200: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2201: cn_utils.appindcr(body_code, ' raise; ');
2202: cn_utils.appindcr(body_code, 'END;');
2203: cn_utils.appendcr(body_code);

Line 2200: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

2196: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2197: cn_utils.appindcr(body_code, ' sqlerrm); ');
2198: cn_utils.appindcr(body_code, ' end if; ');
2199: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2200: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2201: cn_utils.appindcr(body_code, ' raise; ');
2202: cn_utils.appindcr(body_code, 'END;');
2203: cn_utils.appendcr(body_code);
2204: cn_utils.appindcr(body_code, ' g_output_achieved_ptd := '||'l_commission - g_output_achieved_itd ;' );

Line 2218: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');

2214: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2215: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2216: cn_utils.appindcr(body_code, ' sqlerrm); ');
2217: cn_utils.appindcr(body_code, ' end if; ');
2218: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2219: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2220: cn_utils.appindcr(body_code, ' raise; ');
2221:
2222: cn_utils.proc_end( procedure_name, 'N', body_code );

Line 2219: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

2215: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2216: cn_utils.appindcr(body_code, ' sqlerrm); ');
2217: cn_utils.appindcr(body_code, ' end if; ');
2218: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2219: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2220: cn_utils.appindcr(body_code, ' raise; ');
2221:
2222: cn_utils.proc_end( procedure_name, 'N', body_code );
2223: EXCEPTION

Line 2459: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');

2455: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2456: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2457: cn_utils.appindcr(body_code, ' sqlerrm); ');
2458: cn_utils.appindcr(body_code, ' end if; ');
2459: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2460: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2461: cn_utils.appindcr(body_code, ' raise; ');
2462: cn_utils.appindcr(body_code, ' END;');
2463: cn_utils.appendcr(body_code);

Line 2460: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

2456: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2457: cn_utils.appindcr(body_code, ' sqlerrm); ');
2458: cn_utils.appindcr(body_code, ' end if; ');
2459: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2460: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2461: cn_utils.appindcr(body_code, ' raise; ');
2462: cn_utils.appindcr(body_code, ' END;');
2463: cn_utils.appendcr(body_code);
2464: cn_utils.appindcr(body_code, ' END IF; ');

Line 2475: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');

2471: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2472: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2473: cn_utils.appindcr(body_code, ' sqlerrm); ');
2474: cn_utils.appindcr(body_code, ' end if; ');
2475: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2476: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2477: cn_utils.appindcr(body_code, ' raise; ');
2478:
2479: cn_utils.proc_end( procedure_name, 'N', body_code );

Line 2476: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

2472: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2473: cn_utils.appindcr(body_code, ' sqlerrm); ');
2474: cn_utils.appindcr(body_code, ' end if; ');
2475: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2476: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2477: cn_utils.appindcr(body_code, ' raise; ');
2478:
2479: cn_utils.proc_end( procedure_name, 'N', body_code );
2480: EXCEPTION

Line 2864: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');

2860: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date, ');
2861: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');
2862:
2863: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2864: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');
2865: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');
2866: FOR i IN 1..g_number_dim LOOP
2867: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2868: END LOOP;

Line 2865: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');

2861: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');
2862:
2863: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2864: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');
2865: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');
2866: FOR i IN 1..g_number_dim LOOP
2867: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2868: END LOOP;
2869: cn_utils.appindcr(body_code, ' end if; ');

Line 2867: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');

2863: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2864: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');
2865: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');
2866: FOR i IN 1..g_number_dim LOOP
2867: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2868: END LOOP;
2869: cn_utils.appindcr(body_code, ' end if; ');
2870: cn_utils.appendcr(body_code);
2871:

Line 2879: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate='' || l_rate);');

2875: cn_utils.appindcr(body_code, ' l_trx_rec_old.processed_date, g_number_dim,l_mul_input_tbl, ');
2876: cn_utils.appindcr(body_code, ' g_formula_id,l_rate, l_rate_tier_id, l_tier_split ); ');
2877:
2878: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2879: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate='' || l_rate);');
2880: cn_utils.appindcr(body_code, ' end if; ');
2881: END IF;
2882:
2883: cn_utils.appendcr(body_code);

Line 2888: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output='' || l_commission);');

2884: cn_utils.appindcr(body_code, ' l_commission := get_commission( l_trx_rec_old.commission_line_id,');
2885: cn_utils.appindcr(body_code, ' p_salesrep_id, p_period_id, p_quota_id, ');
2886: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_rate); ');
2887: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2888: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output='' || l_commission);');
2889: cn_utils.appindcr(body_code, ' end if; ');
2890:
2891: IF g_perf_input_expr_seq >0 THEN
2892: cn_utils.appindcr(body_code,' l_perf :=l_mul_input_tbl('||g_perf_input_expr_seq||').input_amount; ');

Line 2903: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

2899: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
2900: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date);');
2901:
2902: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2903: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
2904: cn_utils.appindcr(body_code, ' end if; ');
2905: END IF;
2906:
2907: FOR i IN 1..g_number_dim LOOP

Line 2937: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');

2933: update_variables(spec_code, body_code);
2934: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
2935: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
2936: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
2937: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
2938: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2939: cn_utils.appindcr(body_code, ' END; ');
2940: cn_utils.appendcr(body_code);
2941: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');

Line 2938: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

2934: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
2935: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
2936: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
2937: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
2938: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2939: cn_utils.appindcr(body_code, ' END; ');
2940: cn_utils.appendcr(body_code);
2941: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');
2942: cn_utils.appindcr(body_code, ' END LOOP;');

Line 2963: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');

2959: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date, ');
2960: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');
2961:
2962: FOR i IN 1..g_number_dim LOOP
2963: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2964: END LOOP;
2965: cn_utils.appendcr(body_code);
2966: END IF;
2967:

Line 3174: cn_utils.appindcr(body_code, ' cn_message_pkg.debug( ''Failed to create ITD commission line'' ); ');

3170: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
3171: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3172: cn_utils.appindcr(body_code, ' sqlerrm); ');
3173: cn_utils.appindcr(body_code, ' end if; ');
3174: cn_utils.appindcr(body_code, ' cn_message_pkg.debug( ''Failed to create ITD commission line'' ); ');
3175: cn_utils.appindcr(body_code, ' END ; ');
3176: cn_utils.appindcr(body_code, ' END IF; ');
3177: cn_utils.appendcr(body_code);
3178: END IF;

Line 3232: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

3228: cn_utils.appindcr(body_code, ' p_period_id,p_quota_id, p_srp_plan_assign_id, ');
3229: cn_utils.appindcr(body_code, ' p_start_date, l_endofinterval_flag, null);');
3230:
3231: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3232: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3233: cn_utils.appindcr(body_code, ' end if; ');
3234: END IF;
3235:
3236: cn_utils.appindcr(body_code, ' x_latest_processed_date := l_trx_rec_old.processed_date; ');

Line 3244: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');

3240: cn_utils.appendcr(body_code);
3241: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
3242: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
3243: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
3244: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3245: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3246: cn_utils.appindcr(body_code, ' END; ');
3247: cn_utils.appendcr(body_code);
3248: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');

Line 3245: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

3241: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
3242: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
3243: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
3244: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3245: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3246: cn_utils.appindcr(body_code, ' END; ');
3247: cn_utils.appendcr(body_code);
3248: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');
3249: cn_utils.appindcr(body_code, ' END LOOP; ');

Line 3280: -- cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input=''||l_mul_input_tbl('||i||').amount);');

3276: cn_utils.appindcr(body_code, ' l_endofinterval_flag,l_start_period_id );');
3277: -- commented for the Bug 12383021
3278: -- cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3279: FOR i IN 1..g_number_dim LOOP
3280: -- cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input=''||l_mul_input_tbl('||i||').amount);');
3281: cn_utils.appindcr(body_code, ' l_input('||i||') := l_mul_input_tbl('||i||').input_amount; ');
3282: END LOOP;
3283: -- cn_utils.appindcr(body_code, ' end if; ');
3284:

Line 3292: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate='' || l_rate);');

3288: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id , g_split_flag,g_itd_flag, ');
3289: cn_utils.appindcr(body_code, ' l_processed_date, g_number_dim,l_mul_input_tbl, ' );
3290: cn_utils.appindcr(body_code, ' g_formula_id, l_rate, l_rate_tier_id, l_tier_split ); ');
3291: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3292: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate='' || l_rate);');
3293: cn_utils.appindcr(body_code, ' end if; ');
3294: END IF;
3295: cn_utils.appendcr(body_code);
3296: cn_utils.appindcr(body_code, ' l_commission := get_commission(null,p_salesrep_id, ');

Line 3301: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output='' || l_commission);');

3297: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
3298: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_rate, ' );
3299: cn_utils.appindcr(body_code, ' l_endofinterval_flag,l_start_period_id ); ');
3300: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3301: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output='' || l_commission);');
3302: cn_utils.appindcr(body_code, ' end if; ');
3303:
3304: cn_utils.appendcr(body_code);
3305:

Line 3317: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

3313: cn_utils.appindcr(body_code, ' l_perf := get_perf(null, p_salesrep_id, p_period_id, ');
3314: cn_utils.appindcr(body_code, ' p_quota_id, p_srp_plan_assign_id, null,');
3315: cn_utils.appindcr(body_code, ' l_endofinterval_flag, l_start_period_id );');
3316: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3317: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3318: cn_utils.appindcr(body_code, ' end if; ');
3319: END IF;
3320: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3321: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

Line 3321: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

3317: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3318: cn_utils.appindcr(body_code, ' end if; ');
3319: END IF;
3320: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3321: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3322: cn_utils.appindcr(body_code, ' end if; ');
3323: cn_utils.appindcr(body_code, ' l_grp_trx_rec.status := ''CALC''; ');
3324: cn_utils.appindcr(body_code, ' l_grp_trx_rec.credit_type_id := p_credit_type_id; ');
3325: cn_utils.appindcr(body_code, ' l_grp_trx_rec.commission_amount := l_commission ;');

Line 3335: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');

3331: cn_utils.appindcr(body_code, ' l_grp_trx_rec.perf_achieved := l_perf; ');
3332: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3333: cn_utils.appindcr(body_code, ' l_grp_trx_rec.status := ''XCALC''; ');
3334: cn_utils.appindcr(body_code, ' l_grp_trx_rec.error_reason := substr(sqlerrm, 1, 150); ');
3335: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3336: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3337: cn_utils.appindcr(body_code, ' END ; ');
3338: cn_utils.appendcr(body_code);
3339: cn_utils.appindcr(body_code, ' IF l_endofinterval_flag = ''Y'' THEN ');

Line 3336: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

3332: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3333: cn_utils.appindcr(body_code, ' l_grp_trx_rec.status := ''XCALC''; ');
3334: cn_utils.appindcr(body_code, ' l_grp_trx_rec.error_reason := substr(sqlerrm, 1, 150); ');
3335: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3336: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3337: cn_utils.appindcr(body_code, ' END ; ');
3338: cn_utils.appendcr(body_code);
3339: cn_utils.appindcr(body_code, ' IF l_endofinterval_flag = ''Y'' THEN ');
3340: cn_utils.appindcr(body_code, ' l_grp_trx_rec.salesrep_id := p_salesrep_id; ');

Line 3370: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount);');

3366: cn_utils.appindcr(body_code, ' get_input(null, p_salesrep_id, p_period_id, p_quota_id, ');
3367: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date, l_mul_input_tbl );');
3368: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3369: FOR i IN 1..g_number_dim LOOP
3370: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount);');
3371: END LOOP;
3372: cn_utils.appindcr(body_code, ' end if; ');
3373: cn_utils.appendcr(body_code);
3374:

Line 3411: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

3407: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
3408: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, null);');
3409:
3410: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3411: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3412: cn_utils.appindcr(body_code, ' end if; ');
3413: END IF;
3414:
3415: -- create itd trx

Line 3488: cn_utils.appindcr(body_code, ' cn_message_pkg.debug( ''Failed to create ITD commission line'' ); ');

3484: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3485: cn_utils.appindcr(body_code, ' sqlerrm); ');
3486: cn_utils.appindcr(body_code, ' end if; ');
3487:
3488: cn_utils.appindcr(body_code, ' cn_message_pkg.debug( ''Failed to create ITD commission line'' ); ');
3489: cn_utils.appindcr(body_code, ' END ; ');
3490: END IF;
3491:
3492: calc_roll(spec_code, body_code);

Line 3506: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_quota:''); ');

3502: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
3503: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3504: cn_utils.appindcr(body_code, ' sqlerrm); ');
3505: cn_utils.appindcr(body_code, ' end if; ');
3506: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_quota:''); ');
3507: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3508: cn_utils.appindcr(body_code, ' raise; ');
3509: cn_utils.proc_end( procedure_name, 'N', body_code );
3510: EXCEPTION

Line 3507: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

3503: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3504: cn_utils.appindcr(body_code, ' sqlerrm); ');
3505: cn_utils.appindcr(body_code, ' end if; ');
3506: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_quota:''); ');
3507: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3508: cn_utils.appindcr(body_code, ' raise; ');
3509: cn_utils.proc_end( procedure_name, 'N', body_code );
3510: EXCEPTION
3511: when others then

Line 4177: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate=''|| p_rate);');

4173: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.get_rates( p_salesrep_id, p_srp_plan_assign_id,');
4174: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id , g_split_flag, g_itd_flag,');
4175: cn_utils.appindcr(body_code, ' p_start_date, g_number_dim,l_mul_input_tbl, ');
4176: cn_utils.appindcr(body_code, ' g_formula_id, p_rate, l_rate_tier_id, l_tier_split ); ');
4177: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate=''|| p_rate);');
4178: END IF;
4179: cn_utils.appendcr(body_code);
4180: -- get_commission
4181: cn_utils.appindcr(body_code, ' OPEN l_output_csr; ');

Line 4187: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output=''||l_commission);');

4183: cn_utils.appindcr(body_code, ' IF l_output_csr%notfound THEN ');
4184: cn_utils.appindcr(body_code, ' raise no_data_found; ');
4185: cn_utils.appindcr(body_code, ' END IF; ');
4186: cn_utils.appindcr(body_code, ' CLOSE l_output_csr; ');
4187: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output=''||l_commission);');
4188: cn_utils.appendcr(body_code);
4189: -- get perf need more thought
4190: cn_utils.appindcr(body_code, ' OPEN l_perf_csr; ');
4191: cn_utils.appindcr(body_code, ' FETCH l_perf_csr INTO l_perf; ');

Line 4196: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure=''||l_perf);');

4192: cn_utils.appindcr(body_code, ' IF l_perf_csr%notfound THEN ');
4193: cn_utils.appindcr(body_code, ' raise no_data_found; ');
4194: cn_utils.appindcr(body_code, ' END IF; ');
4195: cn_utils.appindcr(body_code, ' CLOSE l_perf_csr; ');
4196: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure=''||l_perf);');
4197: cn_utils.appendcr(body_code);
4198: cn_utils.appindcr(body_code, ' x_latest_processed_date := p_start_date; ');
4199: cn_utils.appendcr(body_code);
4200: -- update all global variables

Line 4233: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_bonus_quota:''); ' );

4229: -- how to handle exception -->create a trx with status 'XCALC' that has the error_reason
4230: cn_utils.appindcr(body_code, ' l_trx_rec.error_reason := substr(sqlerrm,1,150); ');
4231: cn_utils.appindcr(body_code, ' l_trx_rec.status := ''XCALC''; ');
4232: cn_utils.appindcr(body_code, ' l_trx_rec.commission_amount := 0 ;');
4233: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_bonus_quota:''); ' );
4234: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4235: cn_utils.appindcr(body_code, ' END; ');
4236: cn_utils.appendcr(body_code);
4237: cn_utils.appindcr(body_code, ' l_trx_rec.salesrep_id := p_salesrep_id; ');

Line 4234: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );

4230: cn_utils.appindcr(body_code, ' l_trx_rec.error_reason := substr(sqlerrm,1,150); ');
4231: cn_utils.appindcr(body_code, ' l_trx_rec.status := ''XCALC''; ');
4232: cn_utils.appindcr(body_code, ' l_trx_rec.commission_amount := 0 ;');
4233: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_bonus_quota:''); ' );
4234: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4235: cn_utils.appindcr(body_code, ' END; ');
4236: cn_utils.appendcr(body_code);
4237: cn_utils.appindcr(body_code, ' l_trx_rec.salesrep_id := p_salesrep_id; ');
4238: cn_utils.appindcr(body_code, ' l_trx_rec.srp_plan_assign_id := p_srp_plan_assign_id; ');

Line 4278: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in calculate_bonsu_quota:''); ');

4274: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4275: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_bonus_quota.exception'', ');
4276: cn_utils.appindcr(body_code, ' sqlerrm); ');
4277: cn_utils.appindcr(body_code, ' end if; ');
4278: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in calculate_bonsu_quota:''); ');
4279: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4280: cn_utils.appindcr(body_code, ' raise; ');
4281:
4282: cn_utils.proc_end( procedure_name, 'N', body_code );

Line 4279: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );

4275: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_bonus_quota.exception'', ');
4276: cn_utils.appindcr(body_code, ' sqlerrm); ');
4277: cn_utils.appindcr(body_code, ' end if; ');
4278: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in calculate_bonsu_quota:''); ');
4279: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4280: cn_utils.appindcr(body_code, ' raise; ');
4281:
4282: cn_utils.proc_end( procedure_name, 'N', body_code );
4283: EXCEPTION

Line 4589: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_forecast_commission: ''); ');

4585: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4586: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_forecast_commission.exception'', ');
4587: cn_utils.appindcr(body_code, ' sqlerrm); ');
4588: cn_utils.appindcr(body_code, ' end if; ');
4589: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_forecast_commission: ''); ');
4590: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4591: cn_utils.proc_end(procedure_name, 'N', body_code );
4592: EXCEPTION
4593: WHEN OTHERS THEN

Line 4590: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

4586: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_forecast_commission.exception'', ');
4587: cn_utils.appindcr(body_code, ' sqlerrm); ');
4588: cn_utils.appindcr(body_code, ' end if; ');
4589: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_forecast_commission: ''); ');
4590: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4591: cn_utils.proc_end(procedure_name, 'N', body_code );
4592: EXCEPTION
4593: WHEN OTHERS THEN
4594: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4807: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_estimated_payout: ''); ');

4803: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4804: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_estimated_payout.exception'', ');
4805: cn_utils.appindcr(body_code, ' sqlerrm); ');
4806: cn_utils.appindcr(body_code, ' end if; ');
4807: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_estimated_payout: ''); ');
4808: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4809: cn_utils.proc_end(procedure_name, 'N', body_code );
4810: EXCEPTION
4811: WHEN OTHERS THEN

Line 4808: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');

4804: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_estimated_payout.exception'', ');
4805: cn_utils.appindcr(body_code, ' sqlerrm); ');
4806: cn_utils.appindcr(body_code, ' end if; ');
4807: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_estimated_payout: ''); ');
4808: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4809: cn_utils.proc_end(procedure_name, 'N', body_code );
4810: EXCEPTION
4811: WHEN OTHERS THEN
4812: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4868: cn_message_pkg.debug('The formula package name is ' ||package_name);

4864: 'cn.plsql.cn_formula_gen_pkg.create_formula.statement',
4865: 'The formula package name is '||package_name);
4866: end if;
4867:
4868: cn_message_pkg.debug('The formula package name is ' ||package_name);
4869:
4870: generate_init(p_formula_id);
4871:
4872: -- Added for 11.5.10 formula performance Enhancment

Line 4884: cn_message_pkg.debug( 'after generate_init ');

4880: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4881: 'After generate_init in create_formula');
4882: end if;
4883:
4884: cn_message_pkg.debug( 'after generate_init ');
4885:
4886: cn_utils.pkg_init(l_module_id, package_name, null, package_type, 'FORMULA',
4887: package_spec_id, package_body_id, package_spec_desc,
4888: package_body_desc, spec_code, body_code);

Line 4894: cn_message_pkg.debug( 'after get_input');

4890: pkg_variables(spec_code, body_code);
4891:
4892: IF g_formula_type = 'C' THEN
4893: get_input(spec_code, body_code);
4894: cn_message_pkg.debug( 'after get_input');
4895: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4896: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4897: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4898: 'After generating get_input in create_formula');

Line 4903: cn_message_pkg.debug( 'after get_perf ');

4899: end if;
4900:
4901:
4902: get_perf(spec_code, body_code);
4903: cn_message_pkg.debug( 'after get_perf ');
4904: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4905: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4906: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4907: 'After generating get_perf in create_formula');

Line 4911: cn_message_pkg.debug( 'after get_commission');

4907: 'After generating get_perf in create_formula');
4908: end if;
4909:
4910: get_commission(spec_code, body_code);
4911: cn_message_pkg.debug( 'after get_commission');
4912: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4913: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4914: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4915: 'After generating get_commission in create_formula');

Line 4921: cn_message_pkg.debug( 'after calculate_quota ');

4917: END IF;
4918:
4919: IF g_formula_type = 'C' THEN
4920: calculate_quota(spec_code, body_code);
4921: cn_message_pkg.debug( 'after calculate_quota ');
4922: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4923: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4924: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4925: 'After generating calculate_quota in create_formula');

Line 4929: cn_message_pkg.debug( 'after calculate_bonus_quota ');

4925: 'After generating calculate_quota in create_formula');
4926: end if;
4927: ELSIF g_formula_type = 'B' THEN
4928: calculate_bonus_quota(spec_code, body_code);
4929: cn_message_pkg.debug( 'after calculate_bonus_quota ');
4930: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4932: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4933: 'After generating calculate_bonus_quota in create_formula');

Line 4939: cn_message_pkg.debug( 'after get_result ');

4935: END IF;
4936:
4937: IF (g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' AND g_formula_type = 'C') THEN
4938: get_result(spec_code, body_code);
4939: cn_message_pkg.debug( 'after get_result ');
4940: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4941: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4942: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4943: 'After generating get_result in create_formula');

Line 4949: cn_message_pkg.debug( 'after update_revclass_perf ');

4945: END IF;
4946:
4947: IF g_trx_group_code = 'GROUP' THEN
4948: update_revclass_perf(spec_code, body_code);
4949: cn_message_pkg.debug( 'after update_revclass_perf ');
4950: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4952: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4953: 'After generating update_revclass_perf in create_formula');

Line 4959: cn_message_pkg.debug( 'after get_forecast_commission');

4955: END IF;
4956:
4957: IF (g_formula_type = 'C') THEN
4958: get_forecast_commission(spec_code, body_code);
4959: cn_message_pkg.debug( 'after get_forecast_commission');
4960: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4961: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4962: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4963: 'After generating get_forecast_commission in create_formula');