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 1447: /*FND_FILE.put_line(FND_FILE.output,

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

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

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

Line 1580: FND_FILE.put_line(FND_FILE.output,

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

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

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

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

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

Line 1721: FND_FILE.put_line(FND_FILE.output,

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

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

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

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

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

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

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

Line 1863: FND_FILE.put_line(FND_FILE.output,

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

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

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

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

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

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

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

Line 1978: FND_FILE.put_line(FND_FILE.output,

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

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

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