APPS.CN_FORMULA_GEN_PKG dependencies on FND_LOG

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

134: END IF ;
135: END LOOP;
136: exception
137: when others then
138: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
139: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
140: 'cn.plsql.cn_formula_gen_pkg.parse.exception',
141: sqlerrm);
142: end if;

Line 139: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

135: END LOOP;
136: exception
137: when others then
138: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
139: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
140: 'cn.plsql.cn_formula_gen_pkg.parse.exception',
141: sqlerrm);
142: end if;
143: raise;

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

424: END LOOP;
425:
426: exception
427: when others then
428: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
429: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
430: 'cn.plsql.cn_formula_gen_pkg.init_tab_column_list.exception',
431: sqlerrm);
432: end if;

Line 429: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

425:
426: exception
427: when others then
428: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
429: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
430: 'cn.plsql.cn_formula_gen_pkg.init_tab_column_list.exception',
431: sqlerrm);
432: end if;
433: raise;

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

464: x_str := x_str || lower(l_str);
465: return x_str;
466: exception
467: when others then
468: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
469: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
470: 'cn.plsql.cn_formula_gen_pkg.lower_str.exception',
471: sqlerrm);
472: end if;

Line 469: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

465: return x_str;
466: exception
467: when others then
468: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
469: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
470: 'cn.plsql.cn_formula_gen_pkg.lower_str.exception',
471: sqlerrm);
472: end if;
473: raise;

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

797: END LOOP;
798: END IF;
799: EXCEPTION
800: WHEN OTHERS THEN
801: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
802: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
803: 'cn.plsql.cn_formula_gen_pkg.generate_init.exception',
804: sqlerrm);
805: end if;

Line 802: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

798: END IF;
799: EXCEPTION
800: WHEN OTHERS THEN
801: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
802: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
803: 'cn.plsql.cn_formula_gen_pkg.generate_init.exception',
804: sqlerrm);
805: end if;
806: raise;

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

847: AND org_id = g_org_id;
848: END IF;
849: EXCEPTION
850: WHEN OTHERS THEN
851: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
852: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
853: 'cn.plsql.cn_formula_gen_pkg.check_create_object.exception',
854: sqlerrm);
855: end if;

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

848: END IF;
849: EXCEPTION
850: WHEN OTHERS THEN
851: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
852: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
853: 'cn.plsql.cn_formula_gen_pkg.check_create_object.exception',
854: sqlerrm);
855: end if;
856: raise;

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

1459: x_sql_select := x_sql_select || l_sql_select;
1460: END IF;
1461: exception
1462: when others then
1463: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1464: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1465: 'cn.plsql.cn_formula_gen_pkg.handle_bonus_ex_tbl_orderby.exception',
1466: sqlerrm);
1467: end if;

Line 1464: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1460: END IF;
1461: exception
1462: when others then
1463: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1464: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1465: 'cn.plsql.cn_formula_gen_pkg.handle_bonus_ex_tbl_orderby.exception',
1466: sqlerrm);
1467: end if;
1468: raise;

Line 1916: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

1912: cn_utils.appendcr(body_code);
1913: cn_utils.appindcr(body_code, ' l_input := nvl(l_input, 0); ');
1914: cn_utils.appendcr(body_code);
1915: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
1916: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 1917: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

1913: cn_utils.appindcr(body_code, ' l_input := nvl(l_input, 0); ');
1914: cn_utils.appendcr(body_code);
1915: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
1916: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

Line 1957: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

1953: cn_utils.appindcr(body_code, 'g_input_achieved := x_mul_input_tbl(1).input_amount; ');
1954: end if;
1955:
1956: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
1957: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 1958: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

1954: end if;
1955:
1956: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
1957: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

1965:
1966: cn_utils.proc_end( procedure_name, 'N', body_code );
1967: EXCEPTION
1968: when others then
1969: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1970: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1971: 'cn.plsql.cn_formula_gen_pkg.get_input.exception',
1972: sqlerrm);
1973: end if;

Line 1970: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1966: cn_utils.proc_end( procedure_name, 'N', body_code );
1967: EXCEPTION
1968: when others then
1969: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1970: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1971: 'cn.plsql.cn_formula_gen_pkg.get_input.exception',
1972: sqlerrm);
1973: end if;
1974: raise;

Line 2181: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

2177: cn_utils.appendcr(body_code);
2178: cn_utils.appindcr(body_code, 'EXCEPTION WHEN NO_DATA_FOUND THEN ');
2179: cn_utils.appindcr(body_code, ' l_commission := nvl(l_commission,0); ');
2180: cn_utils.appindcr(body_code, ' when others then ');
2181: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 2182: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

2178: cn_utils.appindcr(body_code, 'EXCEPTION WHEN NO_DATA_FOUND THEN ');
2179: cn_utils.appindcr(body_code, ' l_commission := nvl(l_commission,0); ');
2180: cn_utils.appindcr(body_code, ' when others then ');
2181: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

Line 2200: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

2196:
2197: cn_utils.appindcr(body_code, ' return l_commission; ' );
2198:
2199: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2200: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 2201: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

2197: cn_utils.appindcr(body_code, ' return l_commission; ' );
2198:
2199: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2200: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

2208:
2209: cn_utils.proc_end( procedure_name, 'N', body_code );
2210: EXCEPTION
2211: when others then
2212: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2213: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2214: 'cn.plsql.cn_formula_gen_pkg.get_commission.exception',
2215: sqlerrm);
2216: end if;

Line 2213: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2209: cn_utils.proc_end( procedure_name, 'N', body_code );
2210: EXCEPTION
2211: when others then
2212: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2213: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2214: 'cn.plsql.cn_formula_gen_pkg.get_commission.exception',
2215: sqlerrm);
2216: end if;
2217: raise;

Line 2441: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

2437: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf, 0); ');
2438: cn_utils.appindcr(body_code, ' EXCEPTION WHEN NO_DATA_FOUND THEN ');
2439: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf,0); ');
2440: cn_utils.appindcr(body_code, ' WHEN others then ');
2441: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 2442: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

2438: cn_utils.appindcr(body_code, ' EXCEPTION WHEN NO_DATA_FOUND THEN ');
2439: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf,0); ');
2440: cn_utils.appindcr(body_code, ' WHEN others then ');
2441: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

Line 2457: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

2453: cn_utils.appendcr(body_code);
2454: cn_utils.appindcr(body_code, ' return l_perf; ');
2455:
2456: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2457: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 2458: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

2454: cn_utils.appindcr(body_code, ' return l_perf; ');
2455:
2456: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2457: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

2465:
2466: cn_utils.proc_end( procedure_name, 'N', body_code );
2467: EXCEPTION
2468: when others then
2469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2470: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2471: 'cn.plsql.cn_formula_gen_pkg.get_perf.exception',
2472: sqlerrm);
2473: end if;

Line 2470: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2466: cn_utils.proc_end( procedure_name, 'N', body_code );
2467: EXCEPTION
2468: when others then
2469: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2470: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2471: 'cn.plsql.cn_formula_gen_pkg.get_perf.exception',
2472: sqlerrm);
2473: end if;
2474: raise;

Line 3156: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

3152: cn_utils.appendcr(body_code);
3153: cn_utils.appindcr(body_code, ' g_commission_payed_ptd := g_commission_payed_ptd + l_commission; ');
3154: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3155: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3156: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 3157: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

3153: cn_utils.appindcr(body_code, ' g_commission_payed_ptd := g_commission_payed_ptd + l_commission; ');
3154: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3155: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3156: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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'' ); ');

Line 3469: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

3465: cn_utils.appindcr(body_code, ' g_commission_payed_ptd := g_commission_payed_ptd + l_commission; ');
3466: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3467: */
3468: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3469: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
3470: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
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; ');

Line 3470: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

3466: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3467: */
3468: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3469: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
3470: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
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:

Line 3488: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

3484: cn_utils.appindcr(body_code, ' IF l_lines_csr%isopen THEN ' );
3485: cn_utils.appindcr(body_code, ' CLOSE l_lines_csr; ');
3486: cn_utils.appindcr(body_code, ' END IF; ');
3487: END IF;
3488: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 3489: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

3485: cn_utils.appindcr(body_code, ' CLOSE l_lines_csr; ');
3486: cn_utils.appindcr(body_code, ' END IF; ');
3487: END IF;
3488: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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:''); ');

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

3495: cn_utils.appindcr(body_code, ' raise; ');
3496: cn_utils.proc_end( procedure_name, 'N', body_code );
3497: EXCEPTION
3498: when others then
3499: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3500: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3501: 'cn.plsql.cn_formula_gen_pkg.calculate_quota.exception',
3502: sqlerrm);
3503: end if;

Line 3500: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3496: cn_utils.proc_end( procedure_name, 'N', body_code );
3497: EXCEPTION
3498: when others then
3499: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3500: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3501: 'cn.plsql.cn_formula_gen_pkg.calculate_quota.exception',
3502: sqlerrm);
3503: end if;
3504: raise;

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

3660: cn_utils.proc_end( procedure_name, 'N', body_code );
3661:
3662: EXCEPTION
3663: when others then
3664: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3665: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3666: 'cn.plsql.cn_formula_gen_pkg.get_result.exception',
3667: sqlerrm);
3668: end if;

Line 3665: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3661:
3662: EXCEPTION
3663: when others then
3664: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3665: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3666: 'cn.plsql.cn_formula_gen_pkg.get_result.exception',
3667: sqlerrm);
3668: end if;
3669: raise;

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

3805:
3806: cn_utils.proc_end( procedure_name, 'N', body_code );
3807: EXCEPTION
3808: when others then
3809: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3810: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3811: 'cn.plsql.cn_formula_gen_pkg.update_revclass_perf.exception',
3812: sqlerrm);
3813: end if;

Line 3810: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3806: cn_utils.proc_end( procedure_name, 'N', body_code );
3807: EXCEPTION
3808: when others then
3809: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3810: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3811: 'cn.plsql.cn_formula_gen_pkg.update_revclass_perf.exception',
3812: sqlerrm);
3813: end if;
3814: raise;

Line 4260: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

4256: cn_utils.appindcr(body_code, ' IF l_perf_csr%isopen THEN ' );
4257: cn_utils.appindcr(body_code, ' CLOSE l_perf_csr; ');
4258: cn_utils.appindcr(body_code, ' END IF; ');
4259: cn_utils.appendcr(body_code);
4260: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 4261: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

4257: cn_utils.appindcr(body_code, ' CLOSE l_perf_csr; ');
4258: cn_utils.appindcr(body_code, ' END IF; ');
4259: cn_utils.appendcr(body_code);
4260: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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:''); ');

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

4268:
4269: cn_utils.proc_end( procedure_name, 'N', body_code );
4270: EXCEPTION
4271: when others then
4272: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4273: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4274: 'cn.plsql.cn_formula_gen_pkg.calculate_bonus_quota.exception',
4275: sqlerrm);
4276: end if;

Line 4273: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

4269: cn_utils.proc_end( procedure_name, 'N', body_code );
4270: EXCEPTION
4271: when others then
4272: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4273: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4274: 'cn.plsql.cn_formula_gen_pkg.calculate_bonus_quota.exception',
4275: sqlerrm);
4276: end if;
4277: raise;

Line 4571: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

4567: cn_utils.appindcr(body_code, ' x_projected_commission := l_commission;' );
4568:
4569: cn_utils.appindcr(body_code, 'EXCEPTION ' );
4570: cn_utils.appindcr(body_code, ' when others then ');
4571: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 4572: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

4568:
4569: cn_utils.appindcr(body_code, 'EXCEPTION ' );
4570: cn_utils.appindcr(body_code, ' when others then ');
4571: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

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
4582: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4583: 'cn.plsql.cn_formula_gen_pkg.get_forecast_commission.exception',
4584: sqlerrm);
4585: end if;

Line 4582: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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
4582: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4583: 'cn.plsql.cn_formula_gen_pkg.get_forecast_commission.exception',
4584: sqlerrm);
4585: end if;
4586: raise;

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

4661: RETURN l_sql_select;
4662:
4663: EXCEPTION
4664: WHEN OTHERS THEN
4665: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4666: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4667: 'cn.plsql.cn_formula_gen_pkg.get_sql_select.exception',
4668: sqlerrm);
4669: end if;

Line 4666: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

4662:
4663: EXCEPTION
4664: WHEN OTHERS THEN
4665: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4666: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4667: 'cn.plsql.cn_formula_gen_pkg.get_sql_select.exception',
4668: sqlerrm);
4669: end if;
4670: raise;

Line 4789: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');

4785: cn_utils.appindcr(body_code, ' when zero_divide then ');
4786: cn_utils.appindcr(body_code, ' x_return_status := ''Z''; ');
4787: cn_utils.appindcr(body_code, ' when others then ');
4788: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');
4789: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

Line 4790: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');

4786: cn_utils.appindcr(body_code, ' x_return_status := ''Z''; ');
4787: cn_utils.appindcr(body_code, ' when others then ');
4788: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');
4789: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

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
4800: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4801: 'cn.plsql.cn_formula_gen_pkg.get_estimated_payout.exception',
4802: sqlerrm);
4803: end if;

Line 4800: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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
4800: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4801: 'cn.plsql.cn_formula_gen_pkg.get_estimated_payout.exception',
4802: sqlerrm);
4803: end if;
4804: raise;

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

4817: dummy NUMBER(7);
4818: l_module_id number(15);
4819: l_repository_id cn_repositories.repository_id%TYPE;
4820: BEGIN
4821: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4823: 'cn.plsql.cn_formula_gen_pkg.create_formula.begin',
4824: 'Beginning of create_formula procedure ...');
4825: end if;

Line 4822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4818: l_module_id number(15);
4819: l_repository_id cn_repositories.repository_id%TYPE;
4820: BEGIN
4821: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4823: 'cn.plsql.cn_formula_gen_pkg.create_formula.begin',
4824: 'Beginning of create_formula procedure ...');
4825: end if;
4826:

Line 4838: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4834:
4835: check_create_object(package_name, 'PKS', package_spec_id, l_repository_id);
4836: check_create_object(package_name, 'PKB', package_body_id, l_repository_id);
4837:
4838: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4839: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4840: 'cn.plsql.cn_formula_gen_pkg.create_formula.statement',
4841: 'The formula package name is '||package_name);
4842: end if;

Line 4839: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4835: check_create_object(package_name, 'PKS', package_spec_id, l_repository_id);
4836: check_create_object(package_name, 'PKB', package_body_id, l_repository_id);
4837:
4838: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4839: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4840: 'cn.plsql.cn_formula_gen_pkg.create_formula.statement',
4841: 'The formula package name is '||package_name);
4842: end if;
4843:

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

4850: -- of tables and columns used in all the expressions
4851: -- of this formula
4852: init_tab_column_list(p_formula_id);
4853:
4854: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4855: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4856: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4857: 'After generate_init in create_formula');
4858: end if;

Line 4855: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4851: -- of this formula
4852: init_tab_column_list(p_formula_id);
4853:
4854: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4855: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4856: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4857: 'After generate_init in create_formula');
4858: end if;
4859:

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

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');
4875: end if;

Line 4872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4875: end if;
4876:

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

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');
4884: end if;

Line 4881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4884: end if;
4885:

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

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');
4892: end if;

Line 4889: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4892: end if;
4893: END IF;

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

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');
4902: end if;

Line 4899: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4902: end if;
4903: ELSIF g_formula_type = 'B' THEN

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

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');
4910: end if;

Line 4907: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4910: end if;
4911: END IF;

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

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');
4920: end if;

Line 4917: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4920: end if;
4921: END IF;

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

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');
4930: end if;

Line 4927: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4930: end if;
4931: END IF;

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

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');
4940: end if;

Line 4937: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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');
4940: end if;
4941: END IF;

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

4946:
4947: cn_utils.unset_org_id;
4948: RETURN TRUE;
4949:
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.end',
4953: 'End of create_formula');
4954: end if;

Line 4951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4947: cn_utils.unset_org_id;
4948: RETURN TRUE;
4949:
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.end',
4953: 'End of create_formula');
4954: end if;
4955: EXCEPTION

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

4954: end if;
4955: EXCEPTION
4956: when others then
4957: cn_utils.unset_org_id;
4958: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4959: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4960: 'cn.plsql.cn_formula_gen_pkg.parse.exception',
4961: sqlerrm);
4962: end if;

Line 4959: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

4955: EXCEPTION
4956: when others then
4957: cn_utils.unset_org_id;
4958: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4959: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4960: 'cn.plsql.cn_formula_gen_pkg.parse.exception',
4961: sqlerrm);
4962: end if;
4963: raise;

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

5051:
5052:
5053: -- Codes start here
5054:
5055: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5056: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5057: 'cn.plsql.cn_formula_gen_pkg.generate_formula.begin',
5058: 'Beginning of generate_formula ...');
5059: end if;

Line 5056: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5052:
5053: -- Codes start here
5054:
5055: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5056: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5057: 'cn.plsql.cn_formula_gen_pkg.generate_formula.begin',
5058: 'Beginning of generate_formula ...');
5059: end if;
5060:

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

5064:
5065: l_status := create_formula(p_formula_id);
5066:
5067: IF l_status THEN /* formula created successfully. Continue to install it. */
5068: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5070: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5071: 'Generate the PL/SQL code successfully in generate_formula');
5072: end if;

Line 5069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5065: l_status := create_formula(p_formula_id);
5066:
5067: IF l_status THEN /* formula created successfully. Continue to install it. */
5068: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5069: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5070: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5071: 'Generate the PL/SQL code successfully in generate_formula');
5072: end if;
5073:

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

5127: SET formula_status = 'COMPLETE'
5128: WHERE calc_formula_id = p_formula_id
5129: AND org_id = g_org_id;
5130:
5131: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5132: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5133: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5134: 'Compiled formula package successfullly in generate_formula');
5135: end if;

Line 5132: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5128: WHERE calc_formula_id = p_formula_id
5129: AND org_id = g_org_id;
5130:
5131: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5132: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5133: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5134: 'Compiled formula package successfullly in generate_formula');
5135: end if;
5136: ELSE

Line 5147: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5143: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5144: THEN
5145: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5146: FND_MSG_PUB.ADD;
5147: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5148: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
5149: 'cn.plsql.cn_formula_gen_pkg.generate_formula.error',
5150: FALSE);
5151: end if;

Line 5148: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

5144: THEN
5145: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5146: FND_MSG_PUB.ADD;
5147: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5148: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
5149: 'cn.plsql.cn_formula_gen_pkg.generate_formula.error',
5150: FALSE);
5151: end if;
5152:

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

5151: end if;
5152:
5153: END IF;
5154:
5155: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5157: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5158: 'Failed to Compile formula package in generate_formula');
5159: end if;

Line 5156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5152:
5153: END IF;
5154:
5155: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5157: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5158: 'Failed to Compile formula package in generate_formula');
5159: end if;
5160:

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

5159: end if;
5160:
5161: END IF;
5162: ELSE -- failed to created formula package
5163: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5165: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5166: 'Failed to generate the PL/SQL code in generate_formula');
5167: end if;

Line 5164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5160:
5161: END IF;
5162: ELSE -- failed to created formula package
5163: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5164: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5165: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5166: 'Failed to generate the PL/SQL code in generate_formula');
5167: end if;
5168:

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

5181:
5182: END IF;
5183:
5184:
5185: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5187: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5188: 'End of generate_formula');
5189: end if;

Line 5186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5182: END IF;
5183:
5184:
5185: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5186: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5187: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5188: 'End of generate_formula');
5189: end if;
5190:

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

5228: p_data => x_msg_data ,
5229: p_encoded => FND_API.G_FALSE
5230: );
5231:
5232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
5234: 'cn.plsql.cn_formula_gen_pkg.generate_formula.exception',
5235: sqlerrm);
5236: end if;

Line 5233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

5229: p_encoded => FND_API.G_FALSE
5230: );
5231:
5232: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5233: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
5234: 'cn.plsql.cn_formula_gen_pkg.generate_formula.exception',
5235: sqlerrm);
5236: end if;
5237: END generate_formula;