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.JA_CN_COA_EXP_PKG dependencies on FND_FILE

Line 751: FND_FILE.put_line(FND_FILE.output,'==Get_Acc_Subs_View:P_COA_ID=='||P_COA_ID ||'==P_LEDGER_ID='||P_LEDGER_ID);

747: Get_Acc_Subs_View(P_LEDGER_ID => l_ledger_id
748: ,P_COA_ID => l_coa_id);
749:
750: /*-----for test----------------------------------------
751: FND_FILE.put_line(FND_FILE.output,'==Get_Acc_Subs_View:P_COA_ID=='||P_COA_ID ||'==P_LEDGER_ID='||P_LEDGER_ID);
752: -----for test----------------------------------------*/
753:
754: --4. Go through all the natural accounts with a natural number marked in
755: -- "Level" field and lists all invalid accounts in invalid account table

Line 849: FND_FILE.put_line(FND_FILE.output,'===='||l_na_curr_req_id ||'==='||l_na_req_id||'=--'||l_exceptions_count||'-----------submit request');

845: );
846: COMMIT;
847:
848: /*------------for test---------------------------------
849: FND_FILE.put_line(FND_FILE.output,'===='||l_na_curr_req_id ||'==='||l_na_req_id||'=--'||l_exceptions_count||'-----------submit request');
850: ------------for test---------------------------------*/
851:
852: --Waiting for the 'Generating Natural Account Export Exception Report' completed.
853: IF l_na_req_id <> 0

Line 873: FND_FILE.put_line(FND_FILE.output,l_na_req_phase ||'-----------Wait_For_Request');

869: END IF; -- FND_CONCURRENT.Wait_For_Request ...
870: END IF; --l_na_req_id<>0
871:
872: /* ------------for test---------------------------------
873: FND_FILE.put_line(FND_FILE.output,l_na_req_phase ||'-----------Wait_For_Request');
874: ------------for test---------------------------------*/
875:
876: --DELETE rows with l_na_curr_req_id in TABLE JA_CN_COA_NA_EXCEPTIONS;
877: DELETE

Line 886: /*FND_FILE.put_line(FND_FILE.output,

882: --Report that there have invalid accounts
883: RAISE JA_CN_INVALID_ACCOUNT_STRU;
884:
885: ELSE --The invalid account table has no row, so outputs all natural accounts
886: /*FND_FILE.put_line(FND_FILE.output,
887: RPAD('Number',10, ' ')
888: ||'| '|| RPAD('Name',40,' ')
889: ||'| '|| RPAD('Level',10,' ')
890: ||'| '|| RPAD('Subsidiary account flag',1,' ')

Line 992: /*FND_FILE.put_line(FND_FILE.output,

988: END IF; --l_acc_type_code is null or not
989:
990: --Output a row of account in TXT file with columns account number,
991: -- name, level, sub flag, sub item, type, measurement, balance side
992: /*FND_FILE.put_line(FND_FILE.output,
993: RPAD(l_na_number,10, ' ')
994: ||'| '|| RPAD(nvl(l_na_name,' '),40,' ')
995: ||'| '|| RPAD(nvl(l_na_level,' '),10,' ')
996: ||'| '|| RPAD(nvl(l_na_sub_flag,' '),1,' ')

Line 1001: FND_FILE.put_line(FND_FILE.output,

997: ||'| '|| RPAD(nvl(l_na_sub_item,' '),50,' ')
998: ||'| '|| RPAD(nvl(l_na_type,' '),20,' ')
999: ||'| '|| RPAD(nvl(l_na_mea,' '),20,' ')
1000: ||'| '|| RPAD(nvl(l_na_bal,' '),10,' '));*/
1001: FND_FILE.put_line(FND_FILE.output,
1002: '"' ||l_na_number || '"'
1003: ||l_seperator|| '"' ||l_na_name || '"'
1004: ||l_seperator|| l_na_level
1005: ||l_seperator|| '"' ||l_na_sub_flag || '"'

Line 1026: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);

1022: retcode := 0;
1023: errbuf := '';
1024: EXCEPTION
1025: WHEN JA_CN_NO_DATA_FOUND THEN
1026: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);
1027: IF (l_proc_level >= l_dbg_level)
1028: THEN
1029: FND_LOG.String( l_proc_level
1030: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_NO_DATA_FOUND '

Line 1042: FND_FILE.put_line(FND_FILE.output, l_msg_incomplete_dff_assign);

1038: ,NAME => 'JA_CN_INCOMPLETE_DFF_ASSIGN'
1039: );
1040: l_msg_incomplete_dff_assign := FND_MESSAGE.Get;
1041:
1042: FND_FILE.put_line(FND_FILE.output, l_msg_incomplete_dff_assign);
1043: IF (l_proc_level >= l_dbg_level)
1044: THEN
1045: FND_LOG.String( l_proc_level
1046: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_INCOMPLETE_DFF_ASSIGN '

Line 1059: FND_FILE.put_line(FND_FILE.output, l_msg_invalid_account_stru);

1055: );
1056: FND_MESSAGE.SET_TOKEN('REQUEST_ID', TO_CHAR(l_na_req_id));
1057: l_msg_invalid_account_stru := FND_MESSAGE.Get;
1058:
1059: FND_FILE.put_line(FND_FILE.output, l_msg_invalid_account_stru);
1060: IF (l_proc_level >= l_dbg_level)
1061: THEN
1062: FND_LOG.String( l_proc_level
1063: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_INVALID_ACCOUNT_STRU '

Line 1070: FND_FILE.put_line(FND_FILE.output,l_msg_invalid_account_stru ||'-----------exception');

1066: retcode := 1;
1067: errbuf := l_msg_invalid_account_stru;
1068:
1069: /* ------------for test---------------------------------
1070: FND_FILE.put_line(FND_FILE.output,l_msg_invalid_account_stru ||'-----------exception');
1071: ------------for test---------------------------------
1072: */
1073: WHEN OTHERS THEN
1074: IF (l_proc_level >= l_dbg_level)

Line 1220: /*FND_FILE.put_line(FND_FILE.output,

1216: RAISE JA_CN_NO_PROJ_DEFINED;
1217: END IF;*\
1218: END IF;*/
1219:
1220: /*FND_FILE.put_line(FND_FILE.output,
1221: RPAD('Number',10, ' ')
1222: ||'| '|| RPAD('Description',40,' '));*/
1223:
1224: --2. Export all projects into the format predefined flat file

Line 1234: /*FND_FILE.put_line(FND_FILE.output,

1230: ;
1231: EXIT WHEN c_pj%NOTFOUND;
1232: l_row_count := l_row_count+1;
1233: --Output a row of project in TXT file with columns project number, description
1234: /*FND_FILE.put_line(FND_FILE.output,
1235: RPAD(l_pj_number,10, ' ')
1236: ||'| '|| RPAD(l_pj_name,40,' '));*/
1237: FND_FILE.put_line(FND_FILE.output,
1238: '"' ||l_pj_number || '"'

Line 1237: FND_FILE.put_line(FND_FILE.output,

1233: --Output a row of project in TXT file with columns project number, description
1234: /*FND_FILE.put_line(FND_FILE.output,
1235: RPAD(l_pj_number,10, ' ')
1236: ||'| '|| RPAD(l_pj_name,40,' '));*/
1237: FND_FILE.put_line(FND_FILE.output,
1238: '"' ||l_pj_number || '"'
1239: ||l_seperator|| '"' ||l_pj_name || '"'
1240: );
1241: END LOOP;

Line 1252: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);

1248: retcode := 0;
1249: errbuf := '';
1250: EXCEPTION
1251: WHEN JA_CN_NO_DATA_FOUND THEN
1252: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);
1253: IF (l_proc_level >= l_dbg_level)
1254: THEN
1255: FND_LOG.String( l_proc_level
1256: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_NO_DATA_FOUND '

Line 1267: FND_FILE.put_line(FND_FILE.output, l_msg_proj_not_consider);

1263: ,NAME => 'JA_CN_PROJ_NOT_CONSIDER'
1264: );
1265: l_msg_proj_not_consider := FND_MESSAGE.Get;
1266:
1267: FND_FILE.put_line(FND_FILE.output, l_msg_proj_not_consider);
1268: IF (l_proc_level >= l_dbg_level)
1269: THEN
1270: FND_LOG.String( l_proc_level
1271: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_PROJ_NOT_CONSIDER '

Line 1449: /*FND_FILE.put_line(FND_FILE.output,

1445: order by tmp_cst_tbl.cust_number
1446: ;
1447:
1448: BEGIN
1449: /*FND_FILE.put_line(FND_FILE.output,
1450: RPAD('Number',10, ' ')
1451: ||'| '|| RPAD('Name',40,' ')
1452: ||'| '|| RPAD('Category',20,' ')
1453: ||'| '|| RPAD('Territory',20,' ')

Line 1574: /*FND_FILE.put_line(FND_FILE.output,

1570:
1571: l_row_count := l_row_count+1;
1572: --Output a row of third party in TXT file with columns number, name,
1573: -- category, territory, phone number, address, credit_level
1574: /*FND_FILE.put_line(FND_FILE.output,
1575: RPAD(l_tp_number,10, ' ')
1576: ||'| '|| RPAD(nvl(l_tp_name, ' '),40,' ')
1577: ||'| '|| RPAD(nvl(l_tp_ctg_number, ' '),20,' ')
1578: ||'| '|| RPAD(nvl(l_tp_territory, ' '),20,' ')

Line 1582: FND_FILE.put_line(FND_FILE.output,

1578: ||'| '|| RPAD(nvl(l_tp_territory, ' '),20,' ')
1579: ||'| '|| RPAD(nvl(l_tp_phonenumber, ' '),20,' ')
1580: ||'| '|| RPAD(nvl(l_tp_address, ' '),40,' ')
1581: ||'| '|| l_tp_credit_level);*/
1582: FND_FILE.put_line(FND_FILE.output,
1583: '"' ||l_tp_number || '"'
1584: ||l_seperator|| '"' ||l_tp_name || '"'
1585: ||l_seperator|| '"' ||l_tp_ctg_number || '"'
1586: ||l_seperator|| '"' ||l_tp_territory || '"'

Line 1712: /*FND_FILE.put_line(FND_FILE.output, l_tp_number ||'| '|| l_tp_name ||'| '|| l_tp_ctg_number

1708:
1709: l_row_count := l_row_count+1;
1710: --Output a row of l_tp_number, l_tp_name, l_tp_ctg_number,
1711: -- l_tp_territory, l_tp_phonenumber, l_tp_address, l_tp_credit_level in TXT file;
1712: /*FND_FILE.put_line(FND_FILE.output, l_tp_number ||'| '|| l_tp_name ||'| '|| l_tp_ctg_number
1713: ||'| '|| l_tp_territory ||'| '|| l_tp_phonenumber ||'| '|| l_tp_address
1714: ||'| '|| l_tp_credit_level);*/
1715: /*FND_FILE.put_line(FND_FILE.output,
1716: RPAD(l_tp_number,10, ' ')

Line 1715: /*FND_FILE.put_line(FND_FILE.output,

1711: -- l_tp_territory, l_tp_phonenumber, l_tp_address, l_tp_credit_level in TXT file;
1712: /*FND_FILE.put_line(FND_FILE.output, l_tp_number ||'| '|| l_tp_name ||'| '|| l_tp_ctg_number
1713: ||'| '|| l_tp_territory ||'| '|| l_tp_phonenumber ||'| '|| l_tp_address
1714: ||'| '|| l_tp_credit_level);*/
1715: /*FND_FILE.put_line(FND_FILE.output,
1716: RPAD(l_tp_number,10, ' ')
1717: ||'| '|| RPAD(nvl(l_tp_name, ' '),40,' ')
1718: ||'| '|| RPAD(nvl(l_tp_ctg_number, ' '),20,' ')
1719: ||'| '|| RPAD(nvl(l_tp_territory, ' '),20,' ')

Line 1723: FND_FILE.put_line(FND_FILE.output,

1719: ||'| '|| RPAD(nvl(l_tp_territory, ' '),20,' ')
1720: ||'| '|| RPAD(nvl(l_tp_phonenumber, ' '),20,' ')
1721: ||'| '|| RPAD(nvl(l_tp_address, ' '),40,' ')
1722: ||'| '|| l_tp_credit_level);*/
1723: FND_FILE.put_line(FND_FILE.output,
1724: '"' ||l_tp_number || '"'
1725: ||l_seperator|| '"' ||l_tp_name || '"'
1726: ||l_seperator|| '"' ||l_tp_ctg_number || '"'
1727: ||l_seperator|| '"' ||l_tp_territory || '"'

Line 1744: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);

1740: retcode := 0;
1741: errbuf := '';
1742: EXCEPTION
1743: WHEN JA_CN_NO_DATA_FOUND THEN
1744: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);
1745: IF (l_proc_level >= l_dbg_level)
1746: THEN
1747: FND_LOG.String( l_proc_level
1748: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_NO_DATA_FOUND '

Line 1848: /*FND_FILE.put_line(FND_FILE.output,

1844: ORDER BY tmp_cc_tbl.cc_number
1845: ;
1846:
1847: BEGIN
1848: /*FND_FILE.put_line(FND_FILE.output,
1849: RPAD('Department number',20, ' ')
1850: ||'| '|| RPAD('Department name',40,' '));*/
1851:
1852: --Export all cost centers into the format predefined flat file

Line 1862: /*FND_FILE.put_line(FND_FILE.output,

1858: ;
1859: EXIT WHEN c_cc%NOTFOUND;
1860: l_row_count := l_row_count+1;
1861: --Output a row of cost center in TXT file with columns number, name
1862: /*FND_FILE.put_line(FND_FILE.output,
1863: RPAD(l_cc_number,20, ' ')
1864: ||'| '|| RPAD(l_cc_name,40,' '));*/
1865: FND_FILE.put_line(FND_FILE.output,
1866: '"' ||l_cc_number || '"'

Line 1865: FND_FILE.put_line(FND_FILE.output,

1861: --Output a row of cost center in TXT file with columns number, name
1862: /*FND_FILE.put_line(FND_FILE.output,
1863: RPAD(l_cc_number,20, ' ')
1864: ||'| '|| RPAD(l_cc_name,40,' '));*/
1865: FND_FILE.put_line(FND_FILE.output,
1866: '"' ||l_cc_number || '"'
1867: ||l_seperator|| '"' ||l_cc_name || '"'
1868: );
1869: END LOOP;

Line 1881: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);

1877: retcode := 0;
1878: errbuf := '';
1879: EXCEPTION
1880: WHEN JA_CN_NO_DATA_FOUND THEN
1881: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);
1882: IF (l_proc_level >= l_dbg_level)
1883: THEN
1884: FND_LOG.String( l_proc_level
1885: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_NO_DATA_FOUND '

Line 1963: /*FND_FILE.put_line(FND_FILE.output,

1959: ORDER BY tmp_psn_tbl.person_number
1960: ;
1961:
1962: BEGIN
1963: /*FND_FILE.put_line(FND_FILE.output,
1964: RPAD('Number',10, ' ')
1965: ||'| '|| RPAD('Name',40,' '));*/
1966:
1967: --Export all persons into the format predefined flat file

Line 1977: /*FND_FILE.put_line(FND_FILE.output,

1973: ;
1974: EXIT WHEN c_person%NOTFOUND;
1975: l_row_count := l_row_count+1;
1976: --Output a row of person in TXT file with columns number, name;
1977: /*FND_FILE.put_line(FND_FILE.output,
1978: RPAD(l_person_number,10, ' ')
1979: ||'| '|| l_person_name);*/
1980: FND_FILE.put_line(FND_FILE.output,
1981: '"' ||l_person_number || '"'

Line 1980: FND_FILE.put_line(FND_FILE.output,

1976: --Output a row of person in TXT file with columns number, name;
1977: /*FND_FILE.put_line(FND_FILE.output,
1978: RPAD(l_person_number,10, ' ')
1979: ||'| '|| l_person_name);*/
1980: FND_FILE.put_line(FND_FILE.output,
1981: '"' ||l_person_number || '"'
1982: ||l_seperator|| '"' ||l_person_name || '"'
1983: );
1984: END LOOP;

Line 1996: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);

1992: retcode := 0;
1993: errbuf := '';
1994: EXCEPTION
1995: WHEN JA_CN_NO_DATA_FOUND THEN
1996: --FND_FILE.put_line(FND_FILE.output, l_msg_no_data_found);
1997: IF (l_proc_level >= l_dbg_level)
1998: THEN
1999: FND_LOG.String( l_proc_level
2000: ,l_module_prefix||'.'||l_proc_name||'.JA_CN_NO_DATA_FOUND '