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 1921: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');

1917: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
1918: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1919: cn_utils.appindcr(body_code, ' sqlerrm); ');
1920: cn_utils.appindcr(body_code, ' end if; ');
1921: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1922: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1923: cn_utils.appindcr(body_code, ' raise; ');
1924: cn_utils.appindcr(body_code, ' END; ');
1925: cn_utils.appendcr(body_code);

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

1918: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1919: cn_utils.appindcr(body_code, ' sqlerrm); ');
1920: cn_utils.appindcr(body_code, ' end if; ');
1921: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1922: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1923: cn_utils.appindcr(body_code, ' raise; ');
1924: cn_utils.appindcr(body_code, ' END; ');
1925: cn_utils.appendcr(body_code);
1926: cn_utils.appindcr(body_code, ' l_input := nvl(l_input,0); ');

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

1958: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
1959: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1960: cn_utils.appindcr(body_code, ' sqlerrm); ');
1961: cn_utils.appindcr(body_code, ' end if; ');
1962: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1963: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1964: cn_utils.appindcr(body_code, ' raise; ');
1965:
1966: cn_utils.proc_end( procedure_name, 'N', body_code );

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

1959: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_input.exception'', ');
1960: cn_utils.appindcr(body_code, ' sqlerrm); ');
1961: cn_utils.appindcr(body_code, ' end if; ');
1962: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_input: ''); ');
1963: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
1964: cn_utils.appindcr(body_code, ' raise; ');
1965:
1966: cn_utils.proc_end( procedure_name, 'N', body_code );
1967: EXCEPTION

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

2182: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2183: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2184: cn_utils.appindcr(body_code, ' sqlerrm); ');
2185: cn_utils.appindcr(body_code, ' end if; ');
2186: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2187: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2188: cn_utils.appindcr(body_code, ' raise; ');
2189: cn_utils.appindcr(body_code, 'END;');
2190: cn_utils.appendcr(body_code);

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

2183: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2184: cn_utils.appindcr(body_code, ' sqlerrm); ');
2185: cn_utils.appindcr(body_code, ' end if; ');
2186: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2187: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2188: cn_utils.appindcr(body_code, ' raise; ');
2189: cn_utils.appindcr(body_code, 'END;');
2190: cn_utils.appendcr(body_code);
2191: cn_utils.appindcr(body_code, ' g_output_achieved_ptd := '||'l_commission - g_output_achieved_itd ;' );

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

2201: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2202: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2203: cn_utils.appindcr(body_code, ' sqlerrm); ');
2204: cn_utils.appindcr(body_code, ' end if; ');
2205: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2206: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2207: cn_utils.appindcr(body_code, ' raise; ');
2208:
2209: cn_utils.proc_end( procedure_name, 'N', body_code );

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

2202: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_commission.exception'', ');
2203: cn_utils.appindcr(body_code, ' sqlerrm); ');
2204: cn_utils.appindcr(body_code, ' end if; ');
2205: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_commission: ''); ');
2206: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2207: cn_utils.appindcr(body_code, ' raise; ');
2208:
2209: cn_utils.proc_end( procedure_name, 'N', body_code );
2210: EXCEPTION

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

2442: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2443: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2444: cn_utils.appindcr(body_code, ' sqlerrm); ');
2445: cn_utils.appindcr(body_code, ' end if; ');
2446: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2447: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2448: cn_utils.appindcr(body_code, ' raise; ');
2449: cn_utils.appindcr(body_code, ' END;');
2450: cn_utils.appendcr(body_code);

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

2443: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2444: cn_utils.appindcr(body_code, ' sqlerrm); ');
2445: cn_utils.appindcr(body_code, ' end if; ');
2446: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2447: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2448: cn_utils.appindcr(body_code, ' raise; ');
2449: cn_utils.appindcr(body_code, ' END;');
2450: cn_utils.appendcr(body_code);
2451: cn_utils.appindcr(body_code, ' END IF; ');

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

2458: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
2459: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2460: cn_utils.appindcr(body_code, ' sqlerrm); ');
2461: cn_utils.appindcr(body_code, ' end if; ');
2462: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2463: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2464: cn_utils.appindcr(body_code, ' raise; ');
2465:
2466: cn_utils.proc_end( procedure_name, 'N', body_code );

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

2459: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_perf.exception'', ');
2460: cn_utils.appindcr(body_code, ' sqlerrm); ');
2461: cn_utils.appindcr(body_code, ' end if; ');
2462: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_perf: ''); ');
2463: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2464: cn_utils.appindcr(body_code, ' raise; ');
2465:
2466: cn_utils.proc_end( procedure_name, 'N', body_code );
2467: EXCEPTION

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

2847: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date, ');
2848: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');
2849:
2850: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2851: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');
2852: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');
2853: FOR i IN 1..g_number_dim LOOP
2854: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2855: END LOOP;

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

2848: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');
2849:
2850: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2851: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');
2852: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');
2853: FOR i IN 1..g_number_dim LOOP
2854: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2855: END LOOP;
2856: cn_utils.appindcr(body_code, ' end if; ');

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

2850: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2851: cn_utils.appindcr(body_code, ' cn_message_pkg.debug('' ''); ');
2852: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Transaction (line ID='' || l_trx_rec_old.commission_line_id||'')'' );');
2853: FOR i IN 1..g_number_dim LOOP
2854: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2855: END LOOP;
2856: cn_utils.appindcr(body_code, ' end if; ');
2857: cn_utils.appendcr(body_code);
2858:

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

2862: cn_utils.appindcr(body_code, ' l_trx_rec_old.processed_date, g_number_dim,l_mul_input_tbl, ');
2863: cn_utils.appindcr(body_code, ' g_formula_id,l_rate, l_rate_tier_id, l_tier_split ); ');
2864:
2865: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2866: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate='' || l_rate);');
2867: cn_utils.appindcr(body_code, ' end if; ');
2868: END IF;
2869:
2870: cn_utils.appendcr(body_code);

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

2871: cn_utils.appindcr(body_code, ' l_commission := get_commission( l_trx_rec_old.commission_line_id,');
2872: cn_utils.appindcr(body_code, ' p_salesrep_id, p_period_id, p_quota_id, ');
2873: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_rate); ');
2874: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2875: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output='' || l_commission);');
2876: cn_utils.appindcr(body_code, ' end if; ');
2877:
2878: IF g_perf_input_expr_seq >0 THEN
2879: cn_utils.appindcr(body_code,' l_perf :=l_mul_input_tbl('||g_perf_input_expr_seq||').input_amount; ');

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

2886: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
2887: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date);');
2888:
2889: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
2890: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
2891: cn_utils.appindcr(body_code, ' end if; ');
2892: END IF;
2893:
2894: FOR i IN 1..g_number_dim LOOP

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

2920: update_variables(spec_code, body_code);
2921: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
2922: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
2923: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
2924: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
2925: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2926: cn_utils.appindcr(body_code, ' END; ');
2927: cn_utils.appendcr(body_code);
2928: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');

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

2921: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
2922: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
2923: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
2924: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
2925: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
2926: cn_utils.appindcr(body_code, ' END; ');
2927: cn_utils.appendcr(body_code);
2928: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');
2929: cn_utils.appindcr(body_code, ' END LOOP;');

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

2946: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date, ');
2947: cn_utils.appindcr(body_code, ' l_mul_input_tbl );');
2948:
2949: FOR i IN 1..g_number_dim LOOP
2950: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount || l_mul_input_tbl('||i||').input_string );');
2951: END LOOP;
2952: cn_utils.appendcr(body_code);
2953: END IF;
2954:

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

3157: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
3158: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3159: cn_utils.appindcr(body_code, ' sqlerrm); ');
3160: cn_utils.appindcr(body_code, ' end if; ');
3161: cn_utils.appindcr(body_code, ' cn_message_pkg.debug( ''Failed to create ITD commission line'' ); ');
3162: cn_utils.appindcr(body_code, ' END ; ');
3163: cn_utils.appindcr(body_code, ' END IF; ');
3164: cn_utils.appendcr(body_code);
3165: END IF;

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

3215: cn_utils.appindcr(body_code, ' p_period_id,p_quota_id, p_srp_plan_assign_id, ');
3216: cn_utils.appindcr(body_code, ' p_start_date, l_endofinterval_flag, null);');
3217:
3218: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3219: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3220: cn_utils.appindcr(body_code, ' end if; ');
3221: END IF;
3222:
3223: cn_utils.appindcr(body_code, ' x_latest_processed_date := l_trx_rec_old.processed_date; ');

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

3227: cn_utils.appendcr(body_code);
3228: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
3229: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
3230: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
3231: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3232: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3233: cn_utils.appindcr(body_code, ' END; ');
3234: cn_utils.appendcr(body_code);
3235: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');

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

3228: cn_utils.appindcr(body_code, ' EXCEPTION when others then ');
3229: cn_utils.appindcr(body_code, ' l_trx_rec_new.error_reason := substr(sqlerrm,1,150); ');
3230: cn_utils.appindcr(body_code, ' l_trx_rec_new.status := ''XCALC'' ; ');
3231: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3232: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3233: cn_utils.appindcr(body_code, ' END; ');
3234: cn_utils.appendcr(body_code);
3235: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.update_trx(l_trx_rec_old, l_trx_rec_new) ; ');
3236: cn_utils.appindcr(body_code, ' END LOOP; ');

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

3263: cn_utils.appindcr(body_code, ' l_endofinterval_flag,l_start_period_id );');
3264:
3265: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3266: FOR i IN 1..g_number_dim LOOP
3267: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input=''||l_mul_input_tbl('||i||').amount);');
3268: cn_utils.appindcr(body_code, ' l_input('||i||') := l_mul_input_tbl('||i||').input_amount; ');
3269: END LOOP;
3270: cn_utils.appindcr(body_code, ' end if; ');
3271:

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

3275: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id , g_split_flag,g_itd_flag, ');
3276: cn_utils.appindcr(body_code, ' l_processed_date, g_number_dim,l_mul_input_tbl, ' );
3277: cn_utils.appindcr(body_code, ' g_formula_id, l_rate, l_rate_tier_id, l_tier_split ); ');
3278: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3279: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate='' || l_rate);');
3280: cn_utils.appindcr(body_code, ' end if; ');
3281: END IF;
3282: cn_utils.appendcr(body_code);
3283: cn_utils.appindcr(body_code, ' l_commission := get_commission(null,p_salesrep_id, ');

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

3284: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
3285: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_rate, ' );
3286: cn_utils.appindcr(body_code, ' l_endofinterval_flag,l_start_period_id ); ');
3287: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3288: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output='' || l_commission);');
3289: cn_utils.appindcr(body_code, ' end if; ');
3290:
3291: cn_utils.appendcr(body_code);
3292:

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

3300: cn_utils.appindcr(body_code, ' l_perf := get_perf(null, p_salesrep_id, p_period_id, ');
3301: cn_utils.appindcr(body_code, ' p_quota_id, p_srp_plan_assign_id, null,');
3302: cn_utils.appindcr(body_code, ' l_endofinterval_flag, l_start_period_id );');
3303: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3304: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3305: cn_utils.appindcr(body_code, ' end if; ');
3306: END IF;
3307: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3308: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');

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

3304: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3305: cn_utils.appindcr(body_code, ' end if; ');
3306: END IF;
3307: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3308: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3309: cn_utils.appindcr(body_code, ' end if; ');
3310: cn_utils.appindcr(body_code, ' l_grp_trx_rec.status := ''CALC''; ');
3311: cn_utils.appindcr(body_code, ' l_grp_trx_rec.credit_type_id := p_credit_type_id; ');
3312: cn_utils.appindcr(body_code, ' l_grp_trx_rec.commission_amount := l_commission ;');

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

3318: cn_utils.appindcr(body_code, ' l_grp_trx_rec.perf_achieved := l_perf; ');
3319: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3320: cn_utils.appindcr(body_code, ' l_grp_trx_rec.status := ''XCALC''; ');
3321: cn_utils.appindcr(body_code, ' l_grp_trx_rec.error_reason := substr(sqlerrm, 1, 150); ');
3322: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3323: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3324: cn_utils.appindcr(body_code, ' END ; ');
3325: cn_utils.appendcr(body_code);
3326: cn_utils.appindcr(body_code, ' IF l_endofinterval_flag = ''Y'' THEN ');

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

3319: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3320: cn_utils.appindcr(body_code, ' l_grp_trx_rec.status := ''XCALC''; ');
3321: cn_utils.appindcr(body_code, ' l_grp_trx_rec.error_reason := substr(sqlerrm, 1, 150); ');
3322: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs while calculating commission line: ''); ');
3323: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3324: cn_utils.appindcr(body_code, ' END ; ');
3325: cn_utils.appendcr(body_code);
3326: cn_utils.appindcr(body_code, ' IF l_endofinterval_flag = ''Y'' THEN ');
3327: cn_utils.appindcr(body_code, ' l_grp_trx_rec.salesrep_id := p_salesrep_id; ');

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

3353: cn_utils.appindcr(body_code, ' get_input(null, p_salesrep_id, p_period_id, p_quota_id, ');
3354: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, l_trx_rec_old.processed_date, l_mul_input_tbl );');
3355: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3356: FOR i IN 1..g_number_dim LOOP
3357: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Input='' || l_mul_input_tbl('||i||').amount);');
3358: END LOOP;
3359: cn_utils.appindcr(body_code, ' end if; ');
3360: cn_utils.appendcr(body_code);
3361:

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

3394: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id, ');
3395: cn_utils.appindcr(body_code, ' p_srp_plan_assign_id, null);');
3396:
3397: cn_utils.appindcr(body_code, ' if (l_debug_flag = ''Y'') then');
3398: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure='' || l_perf);');
3399: cn_utils.appindcr(body_code, ' end if; ');
3400: END IF;
3401:
3402: -- create itd trx

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

3471: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3472: cn_utils.appindcr(body_code, ' sqlerrm); ');
3473: cn_utils.appindcr(body_code, ' end if; ');
3474:
3475: cn_utils.appindcr(body_code, ' cn_message_pkg.debug( ''Failed to create ITD commission line'' ); ');
3476: cn_utils.appindcr(body_code, ' END ; ');
3477: END IF;
3478:
3479: calc_roll(spec_code, body_code);

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

3489: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
3490: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3491: cn_utils.appindcr(body_code, ' sqlerrm); ');
3492: cn_utils.appindcr(body_code, ' end if; ');
3493: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_quota:''); ');
3494: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3495: cn_utils.appindcr(body_code, ' raise; ');
3496: cn_utils.proc_end( procedure_name, 'N', body_code );
3497: EXCEPTION

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

3490: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_quota.exception'', ');
3491: cn_utils.appindcr(body_code, ' sqlerrm); ');
3492: cn_utils.appindcr(body_code, ' end if; ');
3493: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_quota:''); ');
3494: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
3495: cn_utils.appindcr(body_code, ' raise; ');
3496: cn_utils.proc_end( procedure_name, 'N', body_code );
3497: EXCEPTION
3498: when others then

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

4160: cn_utils.appindcr(body_code, ' cn_formula_common_pkg.get_rates( p_salesrep_id, p_srp_plan_assign_id,');
4161: cn_utils.appindcr(body_code, ' p_period_id, p_quota_id , g_split_flag, g_itd_flag,');
4162: cn_utils.appindcr(body_code, ' p_start_date, g_number_dim,l_mul_input_tbl, ');
4163: cn_utils.appindcr(body_code, ' g_formula_id, p_rate, l_rate_tier_id, l_tier_split ); ');
4164: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Commission rate=''|| p_rate);');
4165: END IF;
4166: cn_utils.appendcr(body_code);
4167: -- get_commission
4168: cn_utils.appindcr(body_code, ' OPEN l_output_csr; ');

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

4170: cn_utils.appindcr(body_code, ' IF l_output_csr%notfound THEN ');
4171: cn_utils.appindcr(body_code, ' raise no_data_found; ');
4172: cn_utils.appindcr(body_code, ' END IF; ');
4173: cn_utils.appindcr(body_code, ' CLOSE l_output_csr; ');
4174: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Output=''||l_commission);');
4175: cn_utils.appendcr(body_code);
4176: -- get perf need more thought
4177: cn_utils.appindcr(body_code, ' OPEN l_perf_csr; ');
4178: cn_utils.appindcr(body_code, ' FETCH l_perf_csr INTO l_perf; ');

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

4179: cn_utils.appindcr(body_code, ' IF l_perf_csr%notfound THEN ');
4180: cn_utils.appindcr(body_code, ' raise no_data_found; ');
4181: cn_utils.appindcr(body_code, ' END IF; ');
4182: cn_utils.appindcr(body_code, ' CLOSE l_perf_csr; ');
4183: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Performance measure=''||l_perf);');
4184: cn_utils.appendcr(body_code);
4185: cn_utils.appindcr(body_code, ' x_latest_processed_date := p_start_date; ');
4186: cn_utils.appendcr(body_code);
4187: -- update all global variables

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

4216: -- how to handle exception -->create a trx with status 'XCALC' that has the error_reason
4217: cn_utils.appindcr(body_code, ' l_trx_rec.error_reason := substr(sqlerrm,1,150); ');
4218: cn_utils.appindcr(body_code, ' l_trx_rec.status := ''XCALC''; ');
4219: cn_utils.appindcr(body_code, ' l_trx_rec.commission_amount := 0 ;');
4220: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_bonus_quota:''); ' );
4221: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4222: cn_utils.appindcr(body_code, ' END; ');
4223: cn_utils.appendcr(body_code);
4224: cn_utils.appindcr(body_code, ' l_trx_rec.salesrep_id := p_salesrep_id; ');

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

4217: cn_utils.appindcr(body_code, ' l_trx_rec.error_reason := substr(sqlerrm,1,150); ');
4218: cn_utils.appindcr(body_code, ' l_trx_rec.status := ''XCALC''; ');
4219: cn_utils.appindcr(body_code, ' l_trx_rec.commission_amount := 0 ;');
4220: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in formula calculate_bonus_quota:''); ' );
4221: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4222: cn_utils.appindcr(body_code, ' END; ');
4223: cn_utils.appendcr(body_code);
4224: cn_utils.appindcr(body_code, ' l_trx_rec.salesrep_id := p_salesrep_id; ');
4225: cn_utils.appindcr(body_code, ' l_trx_rec.srp_plan_assign_id := p_srp_plan_assign_id; ');

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

4261: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4262: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_bonus_quota.exception'', ');
4263: cn_utils.appindcr(body_code, ' sqlerrm); ');
4264: cn_utils.appindcr(body_code, ' end if; ');
4265: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in calculate_bonsu_quota:''); ');
4266: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4267: cn_utils.appindcr(body_code, ' raise; ');
4268:
4269: cn_utils.proc_end( procedure_name, 'N', body_code );

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

4262: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.calculate_bonus_quota.exception'', ');
4263: cn_utils.appindcr(body_code, ' sqlerrm); ');
4264: cn_utils.appindcr(body_code, ' end if; ');
4265: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in calculate_bonsu_quota:''); ');
4266: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ' );
4267: cn_utils.appindcr(body_code, ' raise; ');
4268:
4269: cn_utils.proc_end( procedure_name, 'N', body_code );
4270: EXCEPTION

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

4572: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4573: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_forecast_commission.exception'', ');
4574: cn_utils.appindcr(body_code, ' sqlerrm); ');
4575: cn_utils.appindcr(body_code, ' end if; ');
4576: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_forecast_commission: ''); ');
4577: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4578: cn_utils.proc_end(procedure_name, 'N', body_code );
4579: EXCEPTION
4580: WHEN OTHERS THEN

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

4573: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_forecast_commission.exception'', ');
4574: cn_utils.appindcr(body_code, ' sqlerrm); ');
4575: cn_utils.appindcr(body_code, ' end if; ');
4576: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_forecast_commission: ''); ');
4577: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4578: cn_utils.proc_end(procedure_name, 'N', body_code );
4579: EXCEPTION
4580: WHEN OTHERS THEN
4581: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

4790: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
4791: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_estimated_payout.exception'', ');
4792: cn_utils.appindcr(body_code, ' sqlerrm); ');
4793: cn_utils.appindcr(body_code, ' end if; ');
4794: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_estimated_payout: ''); ');
4795: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4796: cn_utils.proc_end(procedure_name, 'N', body_code );
4797: EXCEPTION
4798: WHEN OTHERS THEN

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

4791: cn_utils.appindcr(body_code, ' ''cn.plsql.cn_formula_'||g_formula_id||'_pkg.get_estimated_payout.exception'', ');
4792: cn_utils.appindcr(body_code, ' sqlerrm); ');
4793: cn_utils.appindcr(body_code, ' end if; ');
4794: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(''Exception occurs in get_estimated_payout: ''); ');
4795: cn_utils.appindcr(body_code, ' cn_message_pkg.debug(sqlerrm); ');
4796: cn_utils.proc_end(procedure_name, 'N', body_code );
4797: EXCEPTION
4798: WHEN OTHERS THEN
4799: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

4840: 'cn.plsql.cn_formula_gen_pkg.create_formula.statement',
4841: 'The formula package name is '||package_name);
4842: end if;
4843:
4844: cn_message_pkg.debug('The formula package name is ' ||package_name);
4845:
4846: generate_init(p_formula_id);
4847:
4848: -- Added for 11.5.10 formula performance Enhancment

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

4856: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4857: 'After generate_init in create_formula');
4858: end if;
4859:
4860: cn_message_pkg.debug( 'after generate_init ');
4861:
4862: cn_utils.pkg_init(l_module_id, package_name, null, package_type, 'FORMULA',
4863: package_spec_id, package_body_id, package_spec_desc,
4864: package_body_desc, spec_code, body_code);

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

4866: pkg_variables(spec_code, body_code);
4867:
4868: IF g_formula_type = 'C' THEN
4869: get_input(spec_code, body_code);
4870: cn_message_pkg.debug( 'after get_input');
4871: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4873: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4874: 'After generating get_input in create_formula');

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

4875: end if;
4876:
4877:
4878: get_perf(spec_code, body_code);
4879: cn_message_pkg.debug( 'after get_perf ');
4880: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4882: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4883: 'After generating get_perf in create_formula');

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

4883: 'After generating get_perf in create_formula');
4884: end if;
4885:
4886: get_commission(spec_code, body_code);
4887: cn_message_pkg.debug( 'after get_commission');
4888: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4890: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4891: 'After generating get_commission in create_formula');

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

4893: END IF;
4894:
4895: IF g_formula_type = 'C' THEN
4896: calculate_quota(spec_code, body_code);
4897: cn_message_pkg.debug( 'after calculate_quota ');
4898: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4900: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4901: 'After generating calculate_quota in create_formula');

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

4901: 'After generating calculate_quota in create_formula');
4902: end if;
4903: ELSIF g_formula_type = 'B' THEN
4904: calculate_bonus_quota(spec_code, body_code);
4905: cn_message_pkg.debug( 'after calculate_bonus_quota ');
4906: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4907: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4908: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4909: 'After generating calculate_bonus_quota in create_formula');

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

4911: END IF;
4912:
4913: IF (g_trx_group_code = 'INDIVIDUAL' AND g_itd_flag = 'N' AND g_cumulative_flag = 'N' AND g_formula_type = 'C') THEN
4914: get_result(spec_code, body_code);
4915: cn_message_pkg.debug( 'after get_result ');
4916: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4917: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4918: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4919: 'After generating get_result in create_formula');

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

4921: END IF;
4922:
4923: IF g_trx_group_code = 'GROUP' THEN
4924: update_revclass_perf(spec_code, body_code);
4925: cn_message_pkg.debug( 'after update_revclass_perf ');
4926: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4928: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4929: 'After generating update_revclass_perf in create_formula');

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

4931: END IF;
4932:
4933: IF (g_formula_type = 'C') THEN
4934: get_forecast_commission(spec_code, body_code);
4935: cn_message_pkg.debug( 'after get_forecast_commission');
4936: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4937: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4938: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4939: 'After generating get_forecast_commission in create_formula');