eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FACTS_EDIT_CHECK dependencies on FND_FILE

Line 862: fnd_file.put_line(fnd_file.log , 'Ending disbursement ' || l_disbursements_amt);

858: l_disbursements_amt := NVL(l_disbursements_amt, 0) + NVL(check8_disb_colla_rec.disbursements_amt, 0);
859: l_collections_amt := NVL(l_collections_amt, 0) + NVL(check8_disb_colla_rec.collections_amt, 0);
860: END LOOP;
861:
862: fnd_file.put_line(fnd_file.log , 'Ending disbursement ' || l_disbursements_amt);
863: fnd_file.put_line(fnd_file.log , 'Ending collection ' || l_collections_amt);
864:
865: FOR check8_disbb_rec IN check8_disbb_cur (g_treasury_symbol_id) LOOP
866: l_beg_disbursements_amt := NVL(check8_disbb_rec.beg_disbursements_amt, 0);

Line 863: fnd_file.put_line(fnd_file.log , 'Ending collection ' || l_collections_amt);

859: l_collections_amt := NVL(l_collections_amt, 0) + NVL(check8_disb_colla_rec.collections_amt, 0);
860: END LOOP;
861:
862: fnd_file.put_line(fnd_file.log , 'Ending disbursement ' || l_disbursements_amt);
863: fnd_file.put_line(fnd_file.log , 'Ending collection ' || l_collections_amt);
864:
865: FOR check8_disbb_rec IN check8_disbb_cur (g_treasury_symbol_id) LOOP
866: l_beg_disbursements_amt := NVL(check8_disbb_rec.beg_disbursements_amt, 0);
867: END LOOP;

Line 876: fnd_file.put_line(fnd_file.log , 'beg disbursement ' || l_beg_disbursements_amt);

872:
873: --- since we want to get only the acvity or ending_balances , we need to
874: -- substract any begining disbursement or collection from ending_balaces;
875:
876: fnd_file.put_line(fnd_file.log , 'beg disbursement ' || l_beg_disbursements_amt);
877: fnd_file.put_line(fnd_file.log , 'beg collection ' || l_beg_collections_amt);
878: l_disbursements_amt := NVL(l_disbursements_amt, 0) + NVL(l_beg_disbursements_amt, 0);
879: l_collections_amt := NVL(l_collections_amt, 0) + NVL(l_beg_collections_amt, 0);
880:

Line 877: fnd_file.put_line(fnd_file.log , 'beg collection ' || l_beg_collections_amt);

873: --- since we want to get only the acvity or ending_balances , we need to
874: -- substract any begining disbursement or collection from ending_balaces;
875:
876: fnd_file.put_line(fnd_file.log , 'beg disbursement ' || l_beg_disbursements_amt);
877: fnd_file.put_line(fnd_file.log , 'beg collection ' || l_beg_collections_amt);
878: l_disbursements_amt := NVL(l_disbursements_amt, 0) + NVL(l_beg_disbursements_amt, 0);
879: l_collections_amt := NVL(l_collections_amt, 0) + NVL(l_beg_collections_amt, 0);
880:
881: l_obligations_incurred_amt := -1*l_obligations_incurred_amt; --Cr balance report as + and Dr balance report as -

Line 1472: --fnd_file.put_line(fnd_file.log , '********** EDIT CHEK 13 BEGIN ');

1468: BEGIN
1469: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1470: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Entering Edit Check 13');
1471: END IF;
1472: --fnd_file.put_line(fnd_file.log , '********************** EDIT CHEK 13 BEGIN ************');
1473: init_vars;
1474: v_edit_check_number :=13;
1475:
1476: v_edit_check_status := 'Failed';

Line 1487: -- fnd_file.put_line(fnd_file.log , 'exp_date ::' || exp_date);

1483:
1484: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'Expiration date for treasury id '||g_treasury_symbol_id||' is '||exp_date);
1486: END IF;
1487: -- fnd_file.put_line(fnd_file.log , 'exp_date ::' || exp_date);
1488:
1489: IF (exp_date IS NOT NULL) THEN
1490: SELECT start_date,
1491: end_date

Line 1509: -- fnd_file.put_line(fnd_file.log , 'whether_Exp ::' || whether_Exp);

1505:
1506: ELSE
1507: whether_Exp := 'U';
1508: END IF;
1509: -- fnd_file.put_line(fnd_file.log , 'whether_Exp ::' || whether_Exp);
1510:
1511: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Expired / Unexpired -'||whether_Exp);
1513: END IF;

Line 1527: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_temp_count ::'||l_temp_count) ;

1523: AND clos.closing_grp IS NOT NULL
1524: AND clos.closing_acct_flag ='Y'
1525: AND tmp.begin_end = 'B';
1526:
1527: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'l_temp_count ::'||l_temp_count) ;
1528: -- Check whether the hard edit check 13 checkbox selected in Federal Financial options
1529: -- Form
1530: BEGIN
1531: SELECT hard_edit_13_flag

Line 1544: --fnd_file.put_line(fnd_file.log , 'flg ::' || flg);

1540:
1541: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1542: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Is hard edit 13 flag on Federal financial options form selected ? '||flg);
1543: END IF;
1544: --fnd_file.put_line(fnd_file.log , 'flg ::' || flg);
1545: /* Iterating over the closing_act_c and calculating the begining bal and end balance
1546: * Also populating the FV_FACTS_TEMP table.
1547: * Report will use this table to show data.
1548: */

Line 1559: --fnd_file.put_line(fnd_file.log , 'beginning sgl account number ::Begining balance ::l_auth_type::l_closing_gp' || l_control_acct_num||

1555: l_closing_gp := get_all_closing_rec.closing_grp;
1556: v_beg_bal_sggl_acc :=l_control_acct_num;
1557: v_closing_grp := l_closing_gp;
1558:
1559: --fnd_file.put_line(fnd_file.log , 'beginning sgl account number ::Begining balance ::l_auth_type::l_closing_gp' || l_control_acct_num||
1560: --'::'||l_beg_bal||'::'||l_auth_type||'::'||l_closing_gp);
1561:
1562: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_control_acct_num ::l_closing_gp -- '|| l_control_acct_num||

Line 1593: -- fnd_file.put_line(fnd_file.log ,'sum_ending_bal ::l_auth_type ::end_bal_rec.authority_type ::'||sum_ending_bal||'::'||l_auth_type||'::'||end_bal_rec.authority_type);

1589: IF (l_auth_type IS NOT NULL) THEN
1590: IF(l_auth_type =end_bal_rec.authority_type) THEN
1591: sum_ending_bal:=sum_ending_bal + end_bal_rec.ending_bal;
1592: l_facts_insert_flg:='Y';
1593: -- fnd_file.put_line(fnd_file.log ,'sum_ending_bal ::l_auth_type ::end_bal_rec.authority_type ::'||sum_ending_bal||'::'||l_auth_type||'::'||end_bal_rec.authority_type);
1594: END IF;
1595: ELSE
1596: sum_ending_bal:=sum_ending_bal + end_bal_rec.ending_bal;
1597: l_facts_insert_flg:='Y';

Line 1598: --fnd_file.put_line(fnd_file.log ,'sum_ending_bal ::l_auth_type ::'||sum_ending_bal||':: null');

1594: END IF;
1595: ELSE
1596: sum_ending_bal:=sum_ending_bal + end_bal_rec.ending_bal;
1597: l_facts_insert_flg:='Y';
1598: --fnd_file.put_line(fnd_file.log ,'sum_ending_bal ::l_auth_type ::'||sum_ending_bal||':: null');
1599: END IF;
1600:
1601: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1602: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' l_facts_insert_flg :: Total Ending Balance -- '|| l_facts_insert_flg||

Line 1609: -- fnd_file.put_line(fnd_file.log ,'v_sgl_acct_number ::v_amount::'||v_sgl_acct_number||'::'||v_amount);

1605:
1606: IF l_facts_insert_flg = 'Y' THEN
1607: v_sgl_acct_number:=end_bal_rec.ussgl_account;
1608: v_amount :=end_bal_rec.ending_bal;
1609: -- fnd_file.put_line(fnd_file.log ,'v_sgl_acct_number ::v_amount::'||v_sgl_acct_number||'::'||v_amount);
1610: create_log_record(v_log_text);
1611: END IF ;
1612: END LOOP;
1613:

Line 1647: -- fnd_file.put_line(fnd_file.log ,'v_edit_check_status ::g_error_flag::'||v_edit_check_status||'::'||g_error_flag);

1643: v_amount:=0;
1644: create_log_record(v_log_text);
1645: END IF;
1646:
1647: -- fnd_file.put_line(fnd_file.log ,'v_edit_check_status ::g_error_flag::'||v_edit_check_status||'::'||g_error_flag);
1648: END LOOP;
1649:
1650: IF l_edit_check_status='N' THEN
1651: v_edit_check_status := 'Failed';

Line 1657: --fnd_file.put_line(fnd_file.log , '********** EDIT CHEK 13 END ');

1653: v_edit_check_status := 'Passed';
1654: END IF;
1655:
1656: create_status_record(v_edit_check_number, v_edit_check_status);
1657: --fnd_file.put_line(fnd_file.log , '********************** EDIT CHEK 13 END ************');
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: v_log_text := 'Exception when others in Edit Check 13. SQLCODE: '|| SQLCODE ;
1661: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

Line 1661: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1657: --fnd_file.put_line(fnd_file.log , '********************** EDIT CHEK 13 END ************');
1658: EXCEPTION
1659: WHEN OTHERS THEN
1660: v_log_text := 'Exception when others in Edit Check 13. SQLCODE: '|| SQLCODE ;
1661: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1662: v_log_text := 'SQLERRM: '|| SQLERRM ;
1663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1664: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||

Line 1663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1659: WHEN OTHERS THEN
1660: v_log_text := 'Exception when others in Edit Check 13. SQLCODE: '|| SQLCODE ;
1661: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1662: v_log_text := 'SQLERRM: '|| SQLERRM ;
1663: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1664: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,' Error flag(1- optional edit fail,2- failed,3-passed) :: Total Ending Balance -- '|| g_error_flag||
1666: '::'||sum_ending_bal);
1667: END IF;

Line 1751: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1747: create_status_record(v_edit_check_number, v_edit_check_status) ;
1748:
1749: EXCEPTION WHEN OTHERS THEN
1750: v_log_text := 'Exception when others in Edit Check 14. SQLCODE: '|| SQLCODE ;
1751: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1752:
1753: v_log_text := 'SQLERRM: '|| SQLERRM ;
1754: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1755:

Line 1754: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1750: v_log_text := 'Exception when others in Edit Check 14. SQLCODE: '|| SQLCODE ;
1751: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1752:
1753: v_log_text := 'SQLERRM: '|| SQLERRM ;
1754: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1755:
1756: g_error_flag := 2;
1757: END; --edit_check_14
1758:

Line 1844: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1840: END IF;
1841: create_status_record(v_edit_check_number, v_edit_check_status) ;
1842: EXCEPTION WHEN OTHERS THEN
1843: v_log_text := 'Exception when others in Edit Check 15. SQLCODE: '|| SQLCODE ;
1844: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1845: v_log_text := 'SQLERRM: '|| SQLERRM ;
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1847: g_error_flag := 2;
1848: END; --edit_check_15

Line 1846: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1842: EXCEPTION WHEN OTHERS THEN
1843: v_log_text := 'Exception when others in Edit Check 15. SQLCODE: '|| SQLCODE ;
1844: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1845: v_log_text := 'SQLERRM: '|| SQLERRM ;
1846: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1847: g_error_flag := 2;
1848: END; --edit_check_15
1849:
1850: -- Edit Check 16.

Line 1935: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1931: create_status_record(v_edit_check_number, v_edit_check_status) ;
1932:
1933: EXCEPTION WHEN OTHERS THEN
1934: v_log_text := 'Exception when others in Edit Check 16. SQLCODE: '|| SQLCODE ;
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1936: v_log_text := 'SQLERRM: '|| SQLERRM ;
1937: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1938: g_error_flag := 2;
1939: END; --edit_check_16

Line 1937: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

1933: EXCEPTION WHEN OTHERS THEN
1934: v_log_text := 'Exception when others in Edit Check 16. SQLCODE: '|| SQLCODE ;
1935: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1936: v_log_text := 'SQLERRM: '|| SQLERRM ;
1937: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
1938: g_error_flag := 2;
1939: END; --edit_check_16
1940:
1941: -- Edit Check 17

Line 2039: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2035: create_status_record(v_edit_check_number, v_edit_check_status) ;
2036:
2037: EXCEPTION WHEN OTHERS THEN
2038: v_log_text := 'Exception when others in Edit Check 17. SQLCODE: '|| SQLCODE ;
2039: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2040: v_log_text := 'SQLERRM: '|| SQLERRM ;
2041: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2042: g_error_flag := 2;
2043: END; --edit_check_17

Line 2041: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2037: EXCEPTION WHEN OTHERS THEN
2038: v_log_text := 'Exception when others in Edit Check 17. SQLCODE: '|| SQLCODE ;
2039: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2040: v_log_text := 'SQLERRM: '|| SQLERRM ;
2041: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2042: g_error_flag := 2;
2043: END; --edit_check_17
2044:
2045: -- Edit Check Non Federal Exception

Line 2104: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2100: create_status_record(v_edit_check_number, v_edit_check_status) ;
2101:
2102: EXCEPTION WHEN OTHERS THEN
2103: v_log_text := 'Exception when others in Edit Check NFE SQLCODE: '|| SQLCODE ;
2104: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2105:
2106: v_log_text := 'SQLERRM: '|| SQLERRM ;
2107: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2108:

Line 2107: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2103: v_log_text := 'Exception when others in Edit Check NFE SQLCODE: '|| SQLCODE ;
2104: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2105:
2106: v_log_text := 'SQLERRM: '|| SQLERRM ;
2107: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2108:
2109: g_error_flag := 2;
2110: END; --edit_check_nfe
2111:

Line 2339: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2335: create_status_record(v_edit_check_number, v_edit_check_status) ;
2336:
2337: EXCEPTION WHEN OTHERS THEN
2338: v_log_text := 'Exception when others in Edit Check 18. SQLCODE: '|| SQLCODE ;
2339: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2340: v_log_text := 'SQLERRM: '|| SQLERRM ;
2341: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2342: g_error_flag := 2;
2343: END; --edit_check_18

Line 2341: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2337: EXCEPTION WHEN OTHERS THEN
2338: v_log_text := 'Exception when others in Edit Check 18. SQLCODE: '|| SQLCODE ;
2339: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2340: v_log_text := 'SQLERRM: '|| SQLERRM ;
2341: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2342: g_error_flag := 2;
2343: END; --edit_check_18
2344:
2345: -- Bug 12985834: FACTS II 2012 enhancement

Line 2551: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2547: create_status_record(v_edit_check_number, v_edit_check_status) ;
2548:
2549: EXCEPTION WHEN OTHERS THEN
2550: v_log_text := 'Exception when others in Edit Check 19. SQLCODE: '|| SQLCODE ;
2551: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2552: v_log_text := 'SQLERRM: '|| SQLERRM ;
2553: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2554: g_error_flag := 2;
2555: END; --edit_check_19

Line 2553: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2549: EXCEPTION WHEN OTHERS THEN
2550: v_log_text := 'Exception when others in Edit Check 19. SQLCODE: '|| SQLCODE ;
2551: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2552: v_log_text := 'SQLERRM: '|| SQLERRM ;
2553: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2554: g_error_flag := 2;
2555: END; --edit_check_19
2556:
2557: -- Edit Check 20

Line 2656: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2652: create_status_record(v_edit_check_number, v_edit_check_status) ;
2653:
2654: EXCEPTION WHEN OTHERS THEN
2655: v_log_text := 'Exception when others in Edit Check 20. SQLCODE: '|| SQLCODE ;
2656: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2657: v_log_text := 'SQLERRM: '|| SQLERRM ;
2658: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2659: g_error_flag := 2;
2660: END; --edit_check_20

Line 2658: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;

2654: EXCEPTION WHEN OTHERS THEN
2655: v_log_text := 'Exception when others in Edit Check 20. SQLCODE: '|| SQLCODE ;
2656: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2657: v_log_text := 'SQLERRM: '|| SQLERRM ;
2658: FND_FILE.PUT_LINE(FND_FILE.LOG, v_log_text) ;
2659: g_error_flag := 2;
2660: END; --edit_check_20
2661:
2662:

Line 2682: fnd_file.put_line(FND_file.LOG,'Running 7/24 debug version');

2678: hard_edit_failed_flg VARCHAR2(1) DEFAULT 'N';
2679:
2680: begin
2681:
2682: fnd_file.put_line(FND_file.LOG,'Running 7/24 debug version');
2683: g_error_flag := 0;
2684: g_treasury_symbol_id := p_treasury_symbol_id;
2685: g_ledger_id := p_ledger_id;
2686: g_period_num := p_period_num;

Line 3055: --fnd_file.put_line(fnd_file.log , '**********POPULATE RETAIN BAL 13 BEGIN ');

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
3058: FROM fv_Facts2_edit_params
3059: WHERE set_of_books_id = g_ledger_id

Line 3066: --fnd_file.put_line(fnd_file.log , '**********************l_rec_exists ::'||l_rec_exists);

3062: -- Getting the
3063: /*select period_name into l_period_name from gl_period_statuses
3064: where period_name = p_rep_fiscal_yr and period_num = p_period_num
3065: and application_id=101 and set_of_books_id = p_ledger_id;*/
3066: --fnd_file.put_line(fnd_file.log , '**********************l_rec_exists ::'||l_rec_exists);
3067: IF (l_rec_exists = 1) THEN
3068: BEGIN
3069: DELETE
3070: FROM FV_FACTS2_RETAIN_BAL

Line 3087: --fnd_file.put_line(fnd_file.log , l_module_name||'l_count ::'||l_count);

3083: AND tmp.begin_end = 'E'
3084: AND tmp.sgl_acct_number = att.ussgl_acct_number
3085: AND tmp.sgl_acct_number = clos.ussgl_Account
3086: AND clos.closing_grp IS NOT NULL;*/
3087: --fnd_file.put_line(fnd_file.log , l_module_name||'l_count ::'||l_count);
3088: -- Using cursor ret_bal_c to populate the fv_facts2_retain_bal table
3089: FOR ret_bal_rec IN ret_bal_c
3090: LOOP
3091: l_end_bal :=ret_bal_rec.amount;

Line 3097: /*fnd_file.put_line(fnd_file.log , l_module_name||'l_end_bal ::'||l_end_bal);

3093: l_treasury_symb:=ret_bal_rec.treasury_symbol_id;
3094: l_auth_type :=ret_bal_rec.authority_type;
3095: l_closing_grp :=ret_bal_rec.closing_grp;
3096:
3097: /*fnd_file.put_line(fnd_file.log , l_module_name||'l_end_bal ::'||l_end_bal);
3098: fnd_file.put_line(fnd_file.log , l_module_name||'l_ussgl_account ::'||l_ussgl_account);
3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);
3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/
3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table

Line 3098: fnd_file.put_line(fnd_file.log , l_module_name||'l_ussgl_account ::'||l_ussgl_account);

3094: l_auth_type :=ret_bal_rec.authority_type;
3095: l_closing_grp :=ret_bal_rec.closing_grp;
3096:
3097: /*fnd_file.put_line(fnd_file.log , l_module_name||'l_end_bal ::'||l_end_bal);
3098: fnd_file.put_line(fnd_file.log , l_module_name||'l_ussgl_account ::'||l_ussgl_account);
3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);
3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/
3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table
3102: INSERT

Line 3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);

3095: l_closing_grp :=ret_bal_rec.closing_grp;
3096:
3097: /*fnd_file.put_line(fnd_file.log , l_module_name||'l_end_bal ::'||l_end_bal);
3098: fnd_file.put_line(fnd_file.log , l_module_name||'l_ussgl_account ::'||l_ussgl_account);
3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);
3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/
3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table
3102: INSERT
3103: INTO FV_FACTS2_RETAIN_BAL

Line 3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/

3096:
3097: /*fnd_file.put_line(fnd_file.log , l_module_name||'l_end_bal ::'||l_end_bal);
3098: fnd_file.put_line(fnd_file.log , l_module_name||'l_ussgl_account ::'||l_ussgl_account);
3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);
3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/
3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table
3102: INSERT
3103: INTO FV_FACTS2_RETAIN_BAL
3104: (