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_FACTS1_PKG dependencies on FND_FILE

Line 1137: --fnd_file.put_line(fnd_file.log , 'first other error raised due to check in

1133:
1134: WHEN OTHERS THEN
1135: gbl_error_code := -1;
1136: gbl_error_buf := l_module_name||' - When others error: '||SQLERRM;
1137: --fnd_file.put_line(fnd_file.log , 'first other error raised due to check in
1138: -- fv_facts_attributs or fund_parameter in [GET_USSGL_ACCOUNT_NUM]');
1139: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
1140: RETURN;
1141: END;

Line 1147: --fnd_file.put_line(fnd_file.log , 'Account is not USSGL ,

1143: ELSE -- account is not a ussgl_account
1144: -- Reset the holder variable
1145: l_exists := NULL;
1146:
1147: --fnd_file.put_line(fnd_file.log , 'Account is not USSGL ,
1148: --so checking facts_attributes for a/c itself') ;
1149: BEGIN
1150: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1151: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind

Line 1174: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);

1170: (SELECT ussgl_account
1171: FROM fv_facts_ussgl_accounts
1172: WHERE ussgl_account = parent_flex_value);
1173:
1174: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);
1175: -- Parent Found. Perform Validations
1176: -- fnd_file.put_line(fnd_file.log , 'checking whether USSGL enabled for ' || l_ussgl_acct_num);
1177: GET_USSGL_INFO (l_ussgl_acct_num, l_ussgl_enabled, l_reporting_type);
1178:

Line 1176: -- fnd_file.put_line(fnd_file.log , 'checking whether USSGL enabled for ' || l_ussgl_acct_num);

1172: WHERE ussgl_account = parent_flex_value);
1173:
1174: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);
1175: -- Parent Found. Perform Validations
1176: -- fnd_file.put_line(fnd_file.log , 'checking whether USSGL enabled for ' || l_ussgl_acct_num);
1177: GET_USSGL_INFO (l_ussgl_acct_num, l_ussgl_enabled, l_reporting_type);
1178:
1179: IF gbl_error_code <> 0 THEN
1180: return;

Line 1199: --fnd_file.put_line(fnd_file.log , 'USSGL exists and facts

1195: RETURN;
1196: END IF;
1197:
1198: IF l_exists IS NOT NULL THEN
1199: --fnd_file.put_line(fnd_file.log , 'USSGL exists and facts
1200: --attributes found for' || p_acct_num );
1201: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1202: p_govt_non_govt := l_g_ng_ind;
1203:

Line 1276: --fnd_file.put_line(fnd_file.log , 'facts-attibutes found for' || p_acct_num );

1272: FROM fv_facts_attributes
1273: WHERE facts_acct_number = l_ussgl_acct_num
1274: AND set_of_books_id = gbl_set_of_books_id;
1275:
1276: --fnd_file.put_line(fnd_file.log , 'facts-attibutes found for' || p_acct_num );
1277: -- Parent is Valid USSGL Acct. Return Values
1278: p_sgl_acct_num := l_ussgl_acct_num ;
1279: p_govt_non_govt := l_g_ng_ind;
1280:

Line 1351: --fnd_file.put_line(fnd_file.log , 'NO facts-attibutes found for'

1347: P_BSF_EXCEPTION := NULL;
1348: P_ENE_EXCEPTION := NULL;
1349: P_CNC_EXCEPTION := NULL;
1350: P_EXCEPTION_CATEGORY:= 'PROP_ACCT_NOT_SETUP';
1351: --fnd_file.put_line(fnd_file.log , 'NO facts-attibutes found for'
1352: --|| p_acct_num || 'So returning with prop_acct_not_setup');
1353: RETURN;
1354:
1355: WHEN INVALID_NUMBER THEN

Line 1376: --fnd_file.put_line(fnd_file.log , 'NO USSGL FOUND found for'

1372:
1373: ELSE -- Else for l_ussgl_enabled IS NOT NULL
1374: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.
1375: -- Raise the Exception NON_USSGL_ACCT
1376: --fnd_file.put_line(fnd_file.log , 'NO USSGL FOUND found for'
1377: --||p_acct_num||' So returning with NON_USSGL_ACCT');
1378:
1379: P_SGL_ACCT_NUM := NULL;
1380: P_GOVT_NON_GOVT := NULL;

Line 1394: --fnd_file.put_line(fnd_file.log , 'NO parent found found for'

1390: END IF; -- Else for l_ussgl_enabled IS NOT NULL
1391:
1392: EXCEPTION -- Finding Parent From GL
1393: WHEN NO_DATA_FOUND THEN
1394: --fnd_file.put_line(fnd_file.log , 'NO parent found found for'
1395: --||p_acct_num||' So returning with NON_USSGL_ACCT');
1396: -- No Parent found. Raise the Exception NON_USSGL_ACCT
1397: P_SGL_ACCT_NUM := NULL;
1398: P_GOVT_NON_GOVT := NULL;

Line 1421: --fnd_file.put_line(fnd_file.log , 'MULTIPLE USSGL parent found found for'

1417: P_BSF_EXCEPTION := NULL;
1418: P_ENE_EXCEPTION := NULL;
1419: P_CNC_EXCEPTION := NULL;
1420: P_EXCEPTION_CATEGORY := 'USSGL_MULTIPLE_PARENTS';
1421: --fnd_file.put_line(fnd_file.log , 'MULTIPLE USSGL parent found found for'
1422: --||p_acct_num||' So returning with MULTIPLE_USSGL');
1423: RETURN;
1424:
1425: WHEN INVALID_NUMBER THEN

Line 1437: -- fnd_file.put_line(fnd_file.log , 'INVALID NUMBER error

1433: P_BSF_EXCEPTION := NULL;
1434: P_ENE_EXCEPTION := NULL;
1435: P_CNC_EXCEPTION := NULL;
1436: P_EXCEPTION_CATEGORY := 'NON_USSGL_ACCT';
1437: -- fnd_file.put_line(fnd_file.log , 'INVALID NUMBER error
1438: -- 0for account :'||p_acct_num||' returing with NON_USSGL_ACCOUNT');
1439: RETURN;
1440: END; -- Finding Parent From GL
1441: END IF; -- Main acct No Validation

Line 1456: fnd_file.put_line(fnd_file.log , 'FINAL WHEN OTHERS FIRED

1452: P_BSF_EXCEPTION := NULL;
1453: P_ENE_EXCEPTION := NULL;
1454: P_CNC_EXCEPTION := NULL;
1455: P_EXCEPTION_CATEGORY := 'NON_USSGL_ACCT';
1456: fnd_file.put_line(fnd_file.log , 'FINAL WHEN OTHERS FIRED
1457: so will exit the process:' || p_acct_num );
1458: gbl_error_code := -1;
1459: gbl_error_buf := l_module_name||' - Final when others '||SQLERRM;
1460: RETURN;

Line 1567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');

1563: END;
1564: FV_UTILITY.LOG_MESG('EDIT_CHECK : l_ledger_name-> '||l_ledger_name);
1565: l_edit_check_passed := 'Y';
1566:
1567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' || l_ledger_name);
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1570: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' || l_ledger_name);

1564: FV_UTILITY.LOG_MESG('EDIT_CHECK : l_ledger_name-> '||l_ledger_name);
1565: l_edit_check_passed := 'Y';
1566:
1567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' || l_ledger_name);
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1570: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||

1565: l_edit_check_passed := 'Y';
1566:
1567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' || l_ledger_name);
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1570: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' || l_ledger_name);
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1570: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1574:
1575: FOR v_t2_record in edit_check_c

Line 1572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' || l_ledger_name);
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1570: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1574:
1575: FOR v_t2_record in edit_check_c
1576: LOOP

Line 1573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1570: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1571: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1572: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1573: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1574:
1575: FOR v_t2_record in edit_check_c
1576: LOOP
1577: l_debit_amount := v_t2_record.debit_amount;

Line 1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Main Account Code: ' ||

1579:
1580: -- Bug 9307787: CGAC
1581: -- Changed 'Treasury Account Code' to 'Main Account Code'
1582: -- Changed 'Dept Id.' to 'Agency ID'
1583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Main Account Code: ' ||
1584: to_char(v_t2_record.fund_group, '0999') ||
1585: ' Agency ID: ' || v_t2_record.dept_id ||
1586: ' Bureau Id.: ' ||
1587: v_t2_record.bureau_id);

Line 1589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Debit Amount: ' ||

1585: ' Agency ID: ' || v_t2_record.dept_id ||
1586: ' Bureau Id.: ' ||
1587: v_t2_record.bureau_id);
1588:
1589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Debit Amount: ' ||
1590: to_char(NVL(l_debit_amount, 0),
1591: '999,999,999,999,999,999,999,990.99'));
1592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit Amount: ' ||
1593: to_char(NVL((-1 * l_credit_amount), 0),

Line 1592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit Amount: ' ||

1588:
1589: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Debit Amount: ' ||
1590: to_char(NVL(l_debit_amount, 0),
1591: '999,999,999,999,999,999,999,990.99'));
1592: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit Amount: ' ||
1593: to_char(NVL((-1 * l_credit_amount), 0),
1594: '999,999,999,999,999,999,999,990.99'));
1595:
1596: IF (NVL(l_debit_amount ,0) = (-1 * NVL(l_credit_amount, 0)))

Line 1598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: PASSED');

1594: '999,999,999,999,999,999,999,990.99'));
1595:
1596: IF (NVL(l_debit_amount ,0) = (-1 * NVL(l_credit_amount, 0)))
1597: THEN
1598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: PASSED');
1599: ELSE
1600: l_edit_check_passed := 'N';
1601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');
1602: END IF;

Line 1601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');

1597: THEN
1598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: PASSED');
1599: ELSE
1600: l_edit_check_passed := 'N';
1601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');
1602: END IF;
1603:
1604: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1605:

Line 1604: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1600: l_edit_check_passed := 'N';
1601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');
1602: END IF;
1603:
1604: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1605:
1606: END LOOP;
1607:
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1604: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1605:
1606: END LOOP;
1607:
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');
1611:
1612: IF (l_edit_check_passed = 'N')

Line 1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1605:
1606: END LOOP;
1607:
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');
1611:
1612: IF (l_edit_check_passed = 'N')
1613: THEN

Line 1610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');

1606: END LOOP;
1607:
1608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');
1611:
1612: IF (l_edit_check_passed = 'N')
1613: THEN
1614: p_status := 'N';

Line 1751: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');

1747:
1748: BEGIN
1749:
1750:
1751: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');
1752:
1753: INSERT INTO fv_facts_report_t2
1754: (fund_group,
1755: account_number,

Line 1825: fnd_file.put_line(fnd_file.log , 'Completed inserting records into FV_FACTS_REPORT_T2 ' || SQL%ROWCOUNT);

1821: ccid,
1822: account_type,
1823: period_num;
1824:
1825: fnd_file.put_line(fnd_file.log , 'Completed inserting records into FV_FACTS_REPORT_T2 ' || SQL%ROWCOUNT);
1826:
1827: commit;
1828:
1829: EXCEPTION

Line 1834: fnd_file.put_line(fnd_file.log , gbl_error_buf);

1830:
1831: WHEN OTHERS THEN
1832: gbl_error_code := SQLCODE;
1833: gbl_error_buf := SQLERRM || '-- [JOURNAL_PROCESS]';
1834: fnd_file.put_line(fnd_file.log , gbl_error_buf);
1835: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',gbl_error_buf);
1836: END JOURNAL_PROCESSES;
1837:
1838: --------------------------------------------------------------------------------------------------------

Line 2456: fnd_file.put_line(fnd_file.log, l_select_stmt2);

2452: l_cy_cr_bal_n.extend(10000);
2453: l_ccid_n.extend(10000);
2454:
2455: l_select_stmt2 := ' SELECT ' || l_select_stmt2;
2456: fnd_file.put_line(fnd_file.log, l_select_stmt2);
2457: l_bal_segment_prv := '####';
2458: gbl_prev_acct := '####';
2459: gbl_bal_segment := '####';
2460: gbl_error_code := 0;

Line 2480: fnd_file.put_line(fnd_file.log,

2476: where set_of_books_id = gbl_set_of_books_id
2477: and fiscal_year = gbl_fiscal_year;
2478:
2479: -- To delete the erroneous record
2480: fnd_file.put_line(fnd_file.log,
2481: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');
2482:
2483: if l_diff_flag = 'N' then
2484: DELETE FROM fv_facts1_diff_balances

Line 3493: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');

3489: l_fed_non_fed := NULL;
3490: l_dummy_fed_non_fed := NULL;
3491:
3492: IF NOT gbl_header_printed THEN
3493: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');
3494: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');
3495: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');
3496: gbl_header_printed := TRUE;
3497: END IF;

Line 3494: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');

3490: l_dummy_fed_non_fed := NULL;
3491:
3492: IF NOT gbl_header_printed THEN
3493: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');
3494: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');
3495: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');
3496: gbl_header_printed := TRUE;
3497: END IF;
3498:

Line 3495: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');

3491:
3492: IF NOT gbl_header_printed THEN
3493: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');
3494: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');
3495: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');
3496: gbl_header_printed := TRUE;
3497: END IF;
3498:
3499: BEGIN

Line 3534: fnd_file.put_line(fnd_file.output, RPAD(vg_acct_number, 31) ||

3530: END;
3531:
3532: -- fv_utility.log_mesg('Account Flag for ' || vg_acct_number
3533: -- || ' moved from ' || vl_dummy || ' To ' || vg_fed_nonfed);
3534: fnd_file.put_line(fnd_file.output, RPAD(vg_acct_number, 31) ||
3535: l_dummy_fed_non_fed || l_fed_non_fed );
3536: End if;
3537:
3538:

Line 3568: fnd_file.put_line(fnd_file.output, RPAD(vg_acct_number,31) || l_fed_non_fed);

3564: WHEN 'F' THEN RPAD('Federal', 25)
3565: WHEN 'Y' THEN RPAD('Federal or Non-Federal', 25)
3566: END;
3567:
3568: fnd_file.put_line(fnd_file.output, RPAD(vg_acct_number,31) || l_fed_non_fed);
3569:
3570:
3571: gbl_error_code := 0;
3572: END;