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

1466: x_sql_select := x_sql_select || l_sql_select;
1467: END IF;
1468: exception
1469: when others then
1470: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1472: 'cn.plsql.cn_formula_gen_pkg.handle_bonus_ex_tbl_orderby.exception',
1473: sqlerrm);
1474: end if;

Line 1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1467: END IF;
1468: exception
1469: when others then
1470: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1471: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1472: 'cn.plsql.cn_formula_gen_pkg.handle_bonus_ex_tbl_orderby.exception',
1473: sqlerrm);
1474: end if;
1475: raise;

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

1925: cn_utils.appendcr(body_code);
1926: cn_utils.appindcr(body_code, ' l_input := nvl(l_input, 0); ');
1927: cn_utils.appendcr(body_code);
1928: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
1929: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

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

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

1966: cn_utils.appindcr(body_code, 'g_input_achieved := x_mul_input_tbl(1).input_amount; ');
1967: end if;
1968:
1969: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
1970: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

1967: end if;
1968:
1969: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
1970: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

1978:
1979: cn_utils.proc_end( procedure_name, 'N', body_code );
1980: EXCEPTION
1981: when others then
1982: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1983: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1984: 'cn.plsql.cn_formula_gen_pkg.get_input.exception',
1985: sqlerrm);
1986: end if;

Line 1983: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

1979: cn_utils.proc_end( procedure_name, 'N', body_code );
1980: EXCEPTION
1981: when others then
1982: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1983: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1984: 'cn.plsql.cn_formula_gen_pkg.get_input.exception',
1985: sqlerrm);
1986: end if;
1987: raise;

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

2190: cn_utils.appendcr(body_code);
2191: cn_utils.appindcr(body_code, 'EXCEPTION WHEN NO_DATA_FOUND THEN ');
2192: cn_utils.appindcr(body_code, ' l_commission := nvl(l_commission,0); ');
2193: cn_utils.appindcr(body_code, ' when others then ');
2194: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

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

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

2209:
2210: cn_utils.appindcr(body_code, ' return l_commission; ' );
2211:
2212: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2213: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

2210: cn_utils.appindcr(body_code, ' return l_commission; ' );
2211:
2212: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2213: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

2221:
2222: cn_utils.proc_end( procedure_name, 'N', body_code );
2223: EXCEPTION
2224: when others then
2225: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2226: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2227: 'cn.plsql.cn_formula_gen_pkg.get_commission.exception',
2228: sqlerrm);
2229: end if;

Line 2226: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2222: cn_utils.proc_end( procedure_name, 'N', body_code );
2223: EXCEPTION
2224: when others then
2225: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2226: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2227: 'cn.plsql.cn_formula_gen_pkg.get_commission.exception',
2228: sqlerrm);
2229: end if;
2230: raise;

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

2450: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf, 0); ');
2451: cn_utils.appindcr(body_code, ' EXCEPTION WHEN NO_DATA_FOUND THEN ');
2452: cn_utils.appindcr(body_code, ' l_perf := nvl(l_perf,0); ');
2453: cn_utils.appindcr(body_code, ' WHEN others then ');
2454: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

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

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

2466: cn_utils.appendcr(body_code);
2467: cn_utils.appindcr(body_code, ' return l_perf; ');
2468:
2469: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2470: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

2467: cn_utils.appindcr(body_code, ' return l_perf; ');
2468:
2469: cn_utils.appindcr(body_code, 'EXCEPTION WHEN OTHERS THEN ');
2470: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

2478:
2479: cn_utils.proc_end( procedure_name, 'N', body_code );
2480: EXCEPTION
2481: when others then
2482: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2483: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2484: 'cn.plsql.cn_formula_gen_pkg.get_perf.exception',
2485: sqlerrm);
2486: end if;

Line 2483: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

2479: cn_utils.proc_end( procedure_name, 'N', body_code );
2480: EXCEPTION
2481: when others then
2482: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2483: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
2484: 'cn.plsql.cn_formula_gen_pkg.get_perf.exception',
2485: sqlerrm);
2486: end if;
2487: raise;

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

3165: cn_utils.appendcr(body_code);
3166: cn_utils.appindcr(body_code, ' g_commission_payed_ptd := g_commission_payed_ptd + l_commission; ');
3167: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3168: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3169: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

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

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

3478: cn_utils.appindcr(body_code, ' g_commission_payed_ptd := g_commission_payed_ptd + l_commission; ');
3479: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3480: */
3481: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3482: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
3483: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
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; ');

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

3479: cn_utils.appindcr(body_code, ' g_commission_payed_itd := g_commission_payed_itd + l_commission; ');
3480: */
3481: cn_utils.appindcr(body_code, ' EXCEPTION WHEN OTHERS THEN ');
3482: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
3483: cn_utils.appindcr(body_code, ' FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, ');
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:

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

3497: cn_utils.appindcr(body_code, ' IF l_lines_csr%isopen THEN ' );
3498: cn_utils.appindcr(body_code, ' CLOSE l_lines_csr; ');
3499: cn_utils.appindcr(body_code, ' END IF; ');
3500: END IF;
3501: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

3498: cn_utils.appindcr(body_code, ' CLOSE l_lines_csr; ');
3499: cn_utils.appindcr(body_code, ' END IF; ');
3500: END IF;
3501: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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:''); ');

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

3508: cn_utils.appindcr(body_code, ' raise; ');
3509: cn_utils.proc_end( procedure_name, 'N', body_code );
3510: EXCEPTION
3511: when others then
3512: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3513: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3514: 'cn.plsql.cn_formula_gen_pkg.calculate_quota.exception',
3515: sqlerrm);
3516: end if;

Line 3513: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3509: cn_utils.proc_end( procedure_name, 'N', body_code );
3510: EXCEPTION
3511: when others then
3512: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3513: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3514: 'cn.plsql.cn_formula_gen_pkg.calculate_quota.exception',
3515: sqlerrm);
3516: end if;
3517: raise;

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

3673: cn_utils.proc_end( procedure_name, 'N', body_code );
3674:
3675: EXCEPTION
3676: when others then
3677: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3678: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3679: 'cn.plsql.cn_formula_gen_pkg.get_result.exception',
3680: sqlerrm);
3681: end if;

Line 3678: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3674:
3675: EXCEPTION
3676: when others then
3677: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3678: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3679: 'cn.plsql.cn_formula_gen_pkg.get_result.exception',
3680: sqlerrm);
3681: end if;
3682: raise;

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

3818:
3819: cn_utils.proc_end( procedure_name, 'N', body_code );
3820: EXCEPTION
3821: when others then
3822: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3823: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3824: 'cn.plsql.cn_formula_gen_pkg.update_revclass_perf.exception',
3825: sqlerrm);
3826: end if;

Line 3823: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3819: cn_utils.proc_end( procedure_name, 'N', body_code );
3820: EXCEPTION
3821: when others then
3822: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3823: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3824: 'cn.plsql.cn_formula_gen_pkg.update_revclass_perf.exception',
3825: sqlerrm);
3826: end if;
3827: raise;

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

4269: cn_utils.appindcr(body_code, ' IF l_perf_csr%isopen THEN ' );
4270: cn_utils.appindcr(body_code, ' CLOSE l_perf_csr; ');
4271: cn_utils.appindcr(body_code, ' END IF; ');
4272: cn_utils.appendcr(body_code);
4273: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

4270: cn_utils.appindcr(body_code, ' CLOSE l_perf_csr; ');
4271: cn_utils.appindcr(body_code, ' END IF; ');
4272: cn_utils.appendcr(body_code);
4273: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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:''); ');

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

4281:
4282: cn_utils.proc_end( procedure_name, 'N', body_code );
4283: EXCEPTION
4284: when others then
4285: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4286: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4287: 'cn.plsql.cn_formula_gen_pkg.calculate_bonus_quota.exception',
4288: sqlerrm);
4289: end if;

Line 4286: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

4282: cn_utils.proc_end( procedure_name, 'N', body_code );
4283: EXCEPTION
4284: when others then
4285: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4286: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4287: 'cn.plsql.cn_formula_gen_pkg.calculate_bonus_quota.exception',
4288: sqlerrm);
4289: end if;
4290: raise;

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

4580: cn_utils.appindcr(body_code, ' x_projected_commission := l_commission;' );
4581:
4582: cn_utils.appindcr(body_code, 'EXCEPTION ' );
4583: cn_utils.appindcr(body_code, ' when others then ');
4584: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

4581:
4582: cn_utils.appindcr(body_code, 'EXCEPTION ' );
4583: cn_utils.appindcr(body_code, ' when others then ');
4584: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

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
4595: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4596: 'cn.plsql.cn_formula_gen_pkg.get_forecast_commission.exception',
4597: sqlerrm);
4598: end if;

Line 4595: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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
4595: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4596: 'cn.plsql.cn_formula_gen_pkg.get_forecast_commission.exception',
4597: sqlerrm);
4598: end if;
4599: raise;

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

4674: RETURN l_sql_select;
4675:
4676: EXCEPTION
4677: WHEN OTHERS THEN
4678: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4679: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4680: 'cn.plsql.cn_formula_gen_pkg.get_sql_select.exception',
4681: sqlerrm);
4682: end if;

Line 4679: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

4675:
4676: EXCEPTION
4677: WHEN OTHERS THEN
4678: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4679: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4680: 'cn.plsql.cn_formula_gen_pkg.get_sql_select.exception',
4681: sqlerrm);
4682: end if;
4683: raise;

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

4798: cn_utils.appindcr(body_code, ' when zero_divide then ');
4799: cn_utils.appindcr(body_code, ' x_return_status := ''Z''; ');
4800: cn_utils.appindcr(body_code, ' when others then ');
4801: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');
4802: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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; ');

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

4799: cn_utils.appindcr(body_code, ' x_return_status := ''Z''; ');
4800: cn_utils.appindcr(body_code, ' when others then ');
4801: cn_utils.appindcr(body_code, ' x_return_status := fnd_api.g_ret_sts_error; ');
4802: cn_utils.appindcr(body_code, ' if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then ');
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: ''); ');

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

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
4813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4814: 'cn.plsql.cn_formula_gen_pkg.get_estimated_payout.exception',
4815: sqlerrm);
4816: end if;

Line 4813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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
4813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4814: 'cn.plsql.cn_formula_gen_pkg.get_estimated_payout.exception',
4815: sqlerrm);
4816: end if;
4817: raise;

Line 4837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

4833: BEGIN
4834:
4835: -- ADDED for bug 14230033
4836: IF ( ad_zd.get_edition('PATCH') IS NOT NULL ) THEN
4837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4839: 'cn.plsql.cn_formula_gen_pkg.create_formula',
4840: 'AD_ZD_DISABLED_FEATURE');
4841: END IF;

Line 4838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4834:
4835: -- ADDED for bug 14230033
4836: IF ( ad_zd.get_edition('PATCH') IS NOT NULL ) THEN
4837: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4838: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4839: 'cn.plsql.cn_formula_gen_pkg.create_formula',
4840: 'AD_ZD_DISABLED_FEATURE');
4841: END IF;
4842: RETURN FALSE;

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

4841: END IF;
4842: RETURN FALSE;
4843: END IF;
4844:
4845: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4847: 'cn.plsql.cn_formula_gen_pkg.create_formula.begin',
4848: 'Beginning of create_formula procedure ...');
4849: end if;

Line 4846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4842: RETURN FALSE;
4843: END IF;
4844:
4845: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4846: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4847: 'cn.plsql.cn_formula_gen_pkg.create_formula.begin',
4848: 'Beginning of create_formula procedure ...');
4849: end if;
4850:

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

4858:
4859: check_create_object(package_name, 'PKS', package_spec_id, l_repository_id);
4860: check_create_object(package_name, 'PKB', package_body_id, l_repository_id);
4861:
4862: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4864: 'cn.plsql.cn_formula_gen_pkg.create_formula.statement',
4865: 'The formula package name is '||package_name);
4866: end if;

Line 4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

4859: check_create_object(package_name, 'PKS', package_spec_id, l_repository_id);
4860: check_create_object(package_name, 'PKB', package_body_id, l_repository_id);
4861:
4862: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4863: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4864: 'cn.plsql.cn_formula_gen_pkg.create_formula.statement',
4865: 'The formula package name is '||package_name);
4866: end if;
4867:

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

4874: -- of tables and columns used in all the expressions
4875: -- of this formula
4876: init_tab_column_list(p_formula_id);
4877:
4878: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4880: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4881: 'After generate_init in create_formula');
4882: end if;

Line 4879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4875: -- of this formula
4876: init_tab_column_list(p_formula_id);
4877:
4878: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4879: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4880: 'cn.plsql.cn_formula_gen_pkg.create_formula.progress',
4881: 'After generate_init in create_formula');
4882: end if;
4883:

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

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

Line 4896: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4905: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4913: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4923: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4931: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4941: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

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

Line 4961: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

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

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

4970:
4971: cn_utils.unset_org_id;
4972: RETURN TRUE;
4973:
4974: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4975: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4976: 'cn.plsql.cn_formula_gen_pkg.create_formula.end',
4977: 'End of create_formula');
4978: end if;

Line 4975: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

4971: cn_utils.unset_org_id;
4972: RETURN TRUE;
4973:
4974: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4975: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4976: 'cn.plsql.cn_formula_gen_pkg.create_formula.end',
4977: 'End of create_formula');
4978: end if;
4979: EXCEPTION

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

4978: end if;
4979: EXCEPTION
4980: when others then
4981: cn_utils.unset_org_id;
4982: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4983: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4984: 'cn.plsql.cn_formula_gen_pkg.parse.exception',
4985: sqlerrm);
4986: end if;

Line 4983: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

4979: EXCEPTION
4980: when others then
4981: cn_utils.unset_org_id;
4982: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4983: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
4984: 'cn.plsql.cn_formula_gen_pkg.parse.exception',
4985: sqlerrm);
4986: end if;
4987: raise;

Line 5104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

5100: SAVEPOINT generate_formula;
5101:
5102: -- ADDED for bug 14230033
5103: IF ( ad_zd.get_edition('PATCH') IS NOT NULL ) THEN
5104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5106: 'cn.plsql.cn_formula_gen_pkg.generate_formula',
5107: 'AD_ZD_DISABLED_FEATURE ...');
5108: END IF;

Line 5105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5101:
5102: -- ADDED for bug 14230033
5103: IF ( ad_zd.get_edition('PATCH') IS NOT NULL ) THEN
5104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5106: 'cn.plsql.cn_formula_gen_pkg.generate_formula',
5107: 'AD_ZD_DISABLED_FEATURE ...');
5108: END IF;
5109: x_return_status := 'E';

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

5130:
5131:
5132: -- Codes start here
5133:
5134: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5136: 'cn.plsql.cn_formula_gen_pkg.generate_formula.begin',
5137: 'Beginning of generate_formula ...');
5138: end if;

Line 5135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5131:
5132: -- Codes start here
5133:
5134: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5135: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5136: 'cn.plsql.cn_formula_gen_pkg.generate_formula.begin',
5137: 'Beginning of generate_formula ...');
5138: end if;
5139:

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

5143:
5144: l_status := create_formula(p_formula_id);
5145:
5146: IF l_status THEN /* formula created successfully. Continue to install it. */
5147: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5149: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5150: 'Generate the PL/SQL code successfully in generate_formula');
5151: end if;

Line 5148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5144: l_status := create_formula(p_formula_id);
5145:
5146: IF l_status THEN /* formula created successfully. Continue to install it. */
5147: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5148: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5149: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5150: 'Generate the PL/SQL code successfully in generate_formula');
5151: end if;
5152:

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

5210: SET formula_status = 'COMPLETE'
5211: WHERE calc_formula_id = p_formula_id
5212: AND org_id = g_org_id;
5213:
5214: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5216: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5217: 'Compiled formula package successfullly in generate_formula');
5218: end if;

Line 5215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5211: WHERE calc_formula_id = p_formula_id
5212: AND org_id = g_org_id;
5213:
5214: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5215: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5216: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5217: 'Compiled formula package successfullly in generate_formula');
5218: end if;
5219: ELSE

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

5226: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5227: THEN
5228: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5229: FND_MSG_PUB.ADD;
5230: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5231: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
5232: 'cn.plsql.cn_formula_gen_pkg.generate_formula.error',
5233: FALSE);
5234: end if;

Line 5231: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,

5227: THEN
5228: fnd_message.set_name('CN', 'CN_FORMULA_COMPILE_ERR');
5229: FND_MSG_PUB.ADD;
5230: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5231: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
5232: 'cn.plsql.cn_formula_gen_pkg.generate_formula.error',
5233: FALSE);
5234: end if;
5235:

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

5234: end if;
5235:
5236: END IF;
5237:
5238: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5240: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5241: 'Failed to Compile formula package in generate_formula');
5242: end if;

Line 5239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5235:
5236: END IF;
5237:
5238: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5240: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5241: 'Failed to Compile formula package in generate_formula');
5242: end if;
5243:

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

5242: end if;
5243:
5244: END IF;
5245: ELSE -- failed to created formula package
5246: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5248: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5249: 'Failed to generate the PL/SQL code in generate_formula');
5250: end if;

Line 5247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5243:
5244: END IF;
5245: ELSE -- failed to created formula package
5246: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5247: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5248: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5249: 'Failed to generate the PL/SQL code in generate_formula');
5250: end if;
5251:

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

5264:
5265: END IF;
5266:
5267:
5268: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5270: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5271: 'End of generate_formula');
5272: end if;

Line 5269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

5265: END IF;
5266:
5267:
5268: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
5270: 'cn.plsql.cn_formula_gen_pkg.generate_formula.progress',
5271: 'End of generate_formula');
5272: end if;
5273:

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

5311: p_data => x_msg_data ,
5312: p_encoded => FND_API.G_FALSE
5313: );
5314:
5315: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5316: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
5317: 'cn.plsql.cn_formula_gen_pkg.generate_formula.exception',
5318: sqlerrm);
5319: end if;

Line 5316: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

5312: p_encoded => FND_API.G_FALSE
5313: );
5314:
5315: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
5316: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
5317: 'cn.plsql.cn_formula_gen_pkg.generate_formula.exception',
5318: sqlerrm);
5319: end if;
5320: END generate_formula;