[Home] [Help]
1529: -- Form
1530: BEGIN
1531: SELECT hard_edit_13_flag
1532: INTO flg
1533: FROM fv_facts2_Edit_params
1534: WHERE set_of_books_id = g_ledger_id;
1535: EXCEPTION
1536: WHEN NO_DATA_FOUND THEN
1537: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name||'No data found for hard edit check flag for period year-'||g_period_year,v_log_text);
1722: end loop;
1723: IF (abs(summation_sum) < abs(control_sum)) THEN
1724: v_edit_check_status := 'Failed';
1725:
1726: select hard_edit_14_flag into flg from fv_facts2_Edit_params where set_of_books_id = g_ledger_id ;
1727:
1728:
1729: IF (flg ='Y' or g_error_flag = 2) THEN
1730: g_error_flag := 2; -- Hard edit failed, so bulk file cannot be generated
2785: edit_check_12(p_facts_run_quarter);
2786:
2787: SELECT COUNT(*)
2788: INTO no_rec
2789: FROM fv_facts2_edit_params
2790: WHERE set_of_books_id = p_ledger_id
2791: AND period_year = p_rep_fiscal_yr
2792: AND period_num = p_period_num;
2793:
3049: l_user_id NUMBER(15):=FND_GLOBAL.USER_ID;
3050: l_closing_grp VARCHAR2(2);
3051: BEGIN
3052: l_module_name := g_module_name || 'populate_bal_ret_tbl';
3053: -- Checking for the period entry in fv_Facts2_edit_params table
3054: -- If there is an entry then empty the FV_FACTS2_RETAIN_BAL table
3055: --fnd_file.put_line(fnd_file.log , '**********************POPULATE RETAIN BAL 13 BEGIN ************');
3056: SELECT COUNT(*)
3057: INTO l_rec_exists
3054: -- If there is an entry then empty the FV_FACTS2_RETAIN_BAL table
3055: --fnd_file.put_line(fnd_file.log , '**********************POPULATE RETAIN BAL 13 BEGIN ************');
3056: SELECT COUNT(*)
3057: INTO l_rec_exists
3058: FROM fv_Facts2_edit_params
3059: WHERE set_of_books_id = g_ledger_id
3060: AND period_year = g_period_year
3061: AND period_num = g_period_num;
3062: -- Getting the