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 1124: --fnd_file.put_line(fnd_file.log , 'first other error raised due to check in

1120:
1121: WHEN OTHERS THEN
1122: gbl_error_code := -1;
1123: gbl_error_buf := l_module_name||' - When others error: '||SQLERRM;
1124: --fnd_file.put_line(fnd_file.log , 'first other error raised due to check in
1125: -- fv_facts_attributs or fund_parameter in [GET_USSGL_ACCOUNT_NUM]');
1126: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
1127: RETURN;
1128: END;

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

1130: ELSE -- account is not a ussgl_account
1131: -- Reset the holder variable
1132: l_exists := NULL;
1133:
1134: --fnd_file.put_line(fnd_file.log , 'Account is not USSGL ,
1135: --so checking facts_attributes for a/c itself') ;
1136: BEGIN
1137: SELECT 'X', govt_non_govt, exch_non_exch, cust_non_cust, budget_subfunction
1138: INTO l_exists, l_g_ng_ind, l_e_ne_ind, l_c_nc_ind, l_budget_sub_ind

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

1157: (SELECT ussgl_account
1158: FROM fv_facts_ussgl_accounts
1159: WHERE ussgl_account = parent_flex_value);
1160:
1161: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);
1162: -- Parent Found. Perform Validations
1163: -- fnd_file.put_line(fnd_file.log , 'checking whether USSGL enabled for ' || l_ussgl_acct_num);
1164: GET_USSGL_INFO (l_ussgl_acct_num, l_ussgl_enabled, l_reporting_type);
1165:

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

1159: WHERE ussgl_account = parent_flex_value);
1160:
1161: -- fnd_file.put_line(fnd_file.log , 'Parent and USSGL found for ' || p_acct_num || ' as ' || l_ussgl_acct_num);
1162: -- Parent Found. Perform Validations
1163: -- fnd_file.put_line(fnd_file.log , 'checking whether USSGL enabled for ' || l_ussgl_acct_num);
1164: GET_USSGL_INFO (l_ussgl_acct_num, l_ussgl_enabled, l_reporting_type);
1165:
1166: IF gbl_error_code <> 0 THEN
1167: return;

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

1182: RETURN;
1183: END IF;
1184:
1185: IF l_exists IS NOT NULL THEN
1186: --fnd_file.put_line(fnd_file.log , 'USSGL exists and facts
1187: --attributes found for' || p_acct_num );
1188: -- Parent is Valid USSGL Acct. Child exists on FV_FACTS_ATTRIBUTES
1189: p_govt_non_govt := l_g_ng_ind;
1190:

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

1252: FROM fv_facts_attributes
1253: WHERE facts_acct_number = l_ussgl_acct_num
1254: AND set_of_books_id = gbl_set_of_books_id;
1255:
1256: --fnd_file.put_line(fnd_file.log , 'facts-attibutes found for' || p_acct_num );
1257: -- Parent is Valid USSGL Acct. Return Values
1258: p_sgl_acct_num := l_ussgl_acct_num ;
1259: p_govt_non_govt := l_g_ng_ind;
1260:

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

1320: P_BSF_EXCEPTION := NULL;
1321: P_ENE_EXCEPTION := NULL;
1322: P_CNC_EXCEPTION := NULL;
1323: P_EXCEPTION_CATEGORY:= 'PROP_ACCT_NOT_SETUP';
1324: --fnd_file.put_line(fnd_file.log , 'NO facts-attibutes found for'
1325: --|| p_acct_num || 'So returning with prop_acct_not_setup');
1326: RETURN;
1327:
1328: WHEN INVALID_NUMBER THEN

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

1345:
1346: ELSE -- Else for l_ussgl_enabled IS NOT NULL
1347: -- Parent not exist in FV_FACTS_USSGL_ACCOUNTS table.
1348: -- Raise the Exception NON_USSGL_ACCT
1349: --fnd_file.put_line(fnd_file.log , 'NO USSGL FOUND found for'
1350: --||p_acct_num||' So returning with NON_USSGL_ACCT');
1351:
1352: P_SGL_ACCT_NUM := NULL;
1353: P_GOVT_NON_GOVT := NULL;

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

1363: END IF; -- Else for l_ussgl_enabled IS NOT NULL
1364:
1365: EXCEPTION -- Finding Parent From GL
1366: WHEN NO_DATA_FOUND THEN
1367: --fnd_file.put_line(fnd_file.log , 'NO parent found found for'
1368: --||p_acct_num||' So returning with NON_USSGL_ACCT');
1369: -- No Parent found. Raise the Exception NON_USSGL_ACCT
1370: P_SGL_ACCT_NUM := NULL;
1371: P_GOVT_NON_GOVT := NULL;

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

1390: P_BSF_EXCEPTION := NULL;
1391: P_ENE_EXCEPTION := NULL;
1392: P_CNC_EXCEPTION := NULL;
1393: P_EXCEPTION_CATEGORY := 'USSGL_MULTIPLE_PARENTS';
1394: --fnd_file.put_line(fnd_file.log , 'MULTIPLE USSGL parent found found for'
1395: --||p_acct_num||' So returning with MULTIPLE_USSGL');
1396: RETURN;
1397:
1398: WHEN INVALID_NUMBER THEN

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

1406: P_BSF_EXCEPTION := NULL;
1407: P_ENE_EXCEPTION := NULL;
1408: P_CNC_EXCEPTION := NULL;
1409: P_EXCEPTION_CATEGORY := 'NON_USSGL_ACCT';
1410: -- fnd_file.put_line(fnd_file.log , 'INVALID NUMBER error
1411: -- 0for account :'||p_acct_num||' returing with NON_USSGL_ACCOUNT');
1412: RETURN;
1413: END; -- Finding Parent From GL
1414: END IF; -- Main acct No Validation

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

1425: P_BSF_EXCEPTION := NULL;
1426: P_ENE_EXCEPTION := NULL;
1427: P_CNC_EXCEPTION := NULL;
1428: P_EXCEPTION_CATEGORY := 'NON_USSGL_ACCT';
1429: fnd_file.put_line(fnd_file.log , 'FINAL WHEN OTHERS FIRED
1430: so will exit the process:' || p_acct_num );
1431: gbl_error_code := -1;
1432: gbl_error_buf := l_module_name||' - Final when others '||SQLERRM;
1433: RETURN;

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

1525: FV_UTILITY.LOG_MESG('In '||l_module_name);
1526:
1527: l_edit_check_passed := 'Y';
1528:
1529: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' ||
1531: FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME'));
1532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1533: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));

Line 1530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' ||

1526:
1527: l_edit_check_passed := 'Y';
1528:
1529: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' ||
1531: FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME'));
1532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1533: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

1528:
1529: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks');
1530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' ||
1531: FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME'));
1532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1533: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

1530: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Set of Books: ' ||
1531: FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME'));
1532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1533: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1537:
1538: FOR v_t2_record in edit_check_c

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

1531: FND_PROFILE.VALUE('GL_SET_OF_BKS_NAME'));
1532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1533: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1537:
1538: FOR v_t2_record in edit_check_c
1539: LOOP

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

1532: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Date: ' ||
1533: to_char(SYSDATE,'YYYY/MM/DD HH24:MI'));
1534: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1535: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1536: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1537:
1538: FOR v_t2_record in edit_check_c
1539: LOOP
1540: l_debit_amount := v_t2_record.debit_amount;

Line 1543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Treasury Account Code: ' ||

1539: LOOP
1540: l_debit_amount := v_t2_record.debit_amount;
1541: l_credit_amount := v_t2_record.credit_amount;
1542:
1543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Treasury Account Code: ' ||
1544: to_char(v_t2_record.fund_group, '0999') ||
1545: ' Dept. Id.: ' || v_t2_record.dept_id ||
1546: ' Bureau Id.: ' ||
1547: v_t2_record.bureau_id);

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

1545: ' Dept. Id.: ' || v_t2_record.dept_id ||
1546: ' Bureau Id.: ' ||
1547: v_t2_record.bureau_id);
1548:
1549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Debit Amount: ' ||
1550: to_char(NVL(l_debit_amount, 0),
1551: '999,999,999,999,999,999,999,990.99'));
1552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit Amount: ' ||
1553: to_char(NVL((-1 * l_credit_amount), 0),

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

1548:
1549: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Debit Amount: ' ||
1550: to_char(NVL(l_debit_amount, 0),
1551: '999,999,999,999,999,999,999,990.99'));
1552: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Credit Amount: ' ||
1553: to_char(NVL((-1 * l_credit_amount), 0),
1554: '999,999,999,999,999,999,999,990.99'));
1555:
1556: IF (NVL(l_debit_amount ,0) = (-1 * NVL(l_credit_amount, 0)))

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

1554: '999,999,999,999,999,999,999,990.99'));
1555:
1556: IF (NVL(l_debit_amount ,0) = (-1 * NVL(l_credit_amount, 0)))
1557: THEN
1558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: PASSED');
1559: ELSE
1560: l_edit_check_passed := 'N';
1561: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');
1562: END IF;

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

1557: THEN
1558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: PASSED');
1559: ELSE
1560: l_edit_check_passed := 'N';
1561: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');
1562: END IF;
1563:
1564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1565:

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

1560: l_edit_check_passed := 'N';
1561: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Edit Check Status: FAILED');
1562: END IF;
1563:
1564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1565:
1566: END LOOP;
1567:
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

1564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1565:
1566: END LOOP;
1567:
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1570: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');
1571:
1572: IF (l_edit_check_passed = 'N')

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

1565:
1566: END LOOP;
1567:
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1570: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');
1571:
1572: IF (l_edit_check_passed = 'N')
1573: THEN

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

1566: END LOOP;
1567:
1568: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1569: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1570: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FACTS I Edit Checks Completed');
1571:
1572: IF (l_edit_check_passed = 'N')
1573: THEN
1574: p_status := 'N';

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

1706:
1707: BEGIN
1708:
1709:
1710: fnd_file.put_line(fnd_file.log , 'Inserting records into FV_FACTS_REPORT_T2');
1711:
1712: INSERT INTO fv_facts_report_t2
1713: (fund_group,
1714: account_number,

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

1780: ccid,
1781: account_type,
1782: period_num;
1783:
1784: fnd_file.put_line(fnd_file.log , 'Completed inserting records into FV_FACTS_REPORT_T2 ' || SQL%ROWCOUNT);
1785:
1786: commit;
1787:
1788: EXCEPTION

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

1789:
1790: WHEN OTHERS THEN
1791: gbl_error_code := SQLCODE;
1792: gbl_error_buf := SQLERRM || '-- [JOURNAL_PROCESS]';
1793: fnd_file.put_line(fnd_file.log , gbl_error_buf);
1794: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',gbl_error_buf);
1795: END JOURNAL_PROCESSES;
1796:
1797: --------------------------------------------------------------------------------------------------------

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

2396: l_cy_cr_bal_n.extend(10000);
2397: l_ccid_n.extend(10000);
2398:
2399: l_select_stmt2 := ' SELECT ' || l_select_stmt2;
2400: fnd_file.put_line(fnd_file.log, l_select_stmt2);
2401: l_bal_segment_prv := '####';
2402: gbl_prev_acct := '####';
2403: gbl_bal_segment := '####';
2404: gbl_error_code := 0;

Line 2424: fnd_file.put_line(fnd_file.log,

2420: where set_of_books_id = gbl_set_of_books_id
2421: and fiscal_year = gbl_fiscal_year;
2422:
2423: -- To delete the erroneous record
2424: fnd_file.put_line(fnd_file.log,
2425: 'Deleting the begin balance difference records from fv_facts1_diff_balances.');
2426:
2427: if l_diff_flag = 'N' then
2428: DELETE FROM fv_facts1_diff_balances

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

3411: l_fed_non_fed := NULL;
3412: l_dummy_fed_non_fed := NULL;
3413:
3414: IF NOT gbl_header_printed THEN
3415: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');
3416: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');
3417: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');
3418: gbl_header_printed := TRUE;
3419: END IF;

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

3412: l_dummy_fed_non_fed := NULL;
3413:
3414: IF NOT gbl_header_printed THEN
3415: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');
3416: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');
3417: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');
3418: gbl_header_printed := TRUE;
3419: END IF;
3420:

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

3413:
3414: IF NOT gbl_header_printed THEN
3415: fnd_file.put_line(fnd_file.output,'Account Number '||rpad(' ', 16)||'Identified as/ Moved to');
3416: fnd_file.put_line(fnd_file.output,lpad(' ', 31)||'Moved from ');
3417: fnd_file.put_line(fnd_file.output,'------------------------------ '||'------------------------ ------------------------');
3418: gbl_header_printed := TRUE;
3419: END IF;
3420:
3421: BEGIN

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

3452: END;
3453:
3454: -- fv_utility.log_mesg('Account Flag for ' || vg_acct_number
3455: -- || ' moved from ' || vl_dummy || ' To ' || vg_fed_nonfed);
3456: fnd_file.put_line(fnd_file.output, RPAD(vg_acct_number, 31) ||
3457: l_dummy_fed_non_fed || l_fed_non_fed );
3458: End if;
3459:
3460:

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

3486: WHEN 'F' THEN RPAD('Federal', 25)
3487: WHEN 'Y' THEN RPAD('Federal or Non-Federal', 25)
3488: END;
3489:
3490: fnd_file.put_line(fnd_file.output, RPAD(vg_acct_number,31) || l_fed_non_fed);
3491:
3492:
3493: gbl_error_code := 0;
3494: END;