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

Line 227: fnd_file.put_line(fnd_file.log, '*Migration status code Updated to NULL for ledger_id : '|| g_array_ledger_id(i)

223: AND gps.adjustment_period_flag = 'N'
224: -- AND gps.closing_status in ('F', 'O', 'C', 'N') -- commented for bug12917429
225: AND gps.ledger_id = g_array_ledger_id(i) ;
226:
227: fnd_file.put_line(fnd_file.log, '*Migration status code Updated to NULL for ledger_id : '|| g_array_ledger_id(i)
228: || ' are : '|| to_char(SQL%ROWCOUNT));
229: END LOOP;
230: */
231: ELSE

Line 241: fnd_file.Put_line(fnd_file.LOG,'*Migration status code Updated to NULL for ledger_id : '

237: AND gps.adjustment_period_flag = 'N'
238: -- AND gps.closing_status in ('F', 'O', 'C', 'N') -- commented for bug12917429
239: AND gps.ledger_id = g_array_ledger_id(i);
240:
241: fnd_file.Put_line(fnd_file.LOG,'*Migration status code Updated to NULL for ledger_id : '
242: ||G_array_ledger_id(i)
243: ||' are : '
244: ||To_char(SQL%ROWCOUNT));
245: END LOOP;

Line 1200: fnd_file.Put_line(fnd_file.LOG,'Previous Run for Upgrade for Application : '

1196: END;
1197:
1198: IF (l_prev_run_status NOT IN ( C_INITIAL_STATUS ,C_SUCCESS_STATUS ,C_ERROR_STATUS)) THEN
1199: IF (l_prev_run_status = C_PROGRESS_STATUS ) THEN
1200: fnd_file.Put_line(fnd_file.LOG,'Previous Run for Upgrade for Application : '
1201: ||l_application_name
1202: ||' is in PENDING STATUS.'
1203: ||'Marking it as ERROR and Proceeding ');
1204:

Line 1250: fnd_file.put_line(fnd_file.log, '*Start date : '|| to_char(l_start_date));

1246: WHERE gps.application_id IN (275, 8721)
1247: AND gps.ledger_id = p_ledger_id
1248: AND gps.period_name = p_period_name;
1249:
1250: fnd_file.put_line(fnd_file.log, '*Start date : '|| to_char(l_start_date));
1251:
1252: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1253: trace('Start date of upgrade '|| l_start_date,
1254: C_LEVEL_STATEMENT, l_Log_module);

Line 1264: fnd_file.put_line(fnd_file.log, '*End date : '|| to_char(l_end_date));

1260: WHERE gps.migration_status_code = 'U'
1261: AND gps.ledger_id = p_ledger_id
1262: AND gps.application_id IN (275, 8721) ;
1263:
1264: fnd_file.put_line(fnd_file.log, '*End date : '|| to_char(l_end_date));
1265:
1266: IF l_end_date IS NOT NULL THEN
1267:
1268: select distinct gps.period_name

Line 1307: fnd_file.Put_line(fnd_file.LOG,'*Start date : '||To_char(l_start_date));

1303: WHERE gps.application_id = l_application_id
1304: AND gps.ledger_id = p_ledger_id
1305: AND gps.period_name = p_period_name;
1306:
1307: fnd_file.Put_line(fnd_file.LOG,'*Start date : '||To_char(l_start_date));
1308:
1309: IF (c_level_statement >= g_log_level) THEN
1310: Trace('Start date of upgrade '||l_start_date,c_level_statement,l_log_module);
1311: END IF;

Line 1321: fnd_file.Put_line(fnd_file.LOG,'*End date : '||To_char(l_end_date));

1317: WHERE gps.migration_status_code = 'U'
1318: AND gps.ledger_id = p_ledger_id
1319: AND gps.application_id = l_application_id;
1320:
1321: fnd_file.Put_line(fnd_file.LOG,'*End date : '||To_char(l_end_date));
1322:
1323: IF l_end_date IS NOT NULL THEN
1324:
1325: select gps.period_name

Line 1516: fnd_file.put_line(fnd_file.log, '*Periods updated to P for ledger_id: '

1512: AND adjustment_period_flag = 'N'
1513: -- AND closing_status in ('F', 'O', 'C', 'N') -- commented for bug12917429
1514: AND migration_status_code IS NULL;
1515:
1516: fnd_file.put_line(fnd_file.log, '*Periods updated to P for ledger_id: '
1517: || i_ledger_periods.ledger_id || ' are : '|| to_char(SQL%ROWCOUNT));
1518:
1519: END LOOP ;
1520: */

Line 1536: fnd_file.Put_line(fnd_file.LOG,'*Periods updated to P for ledger_id: ' ||i_ledger_periods.ledger_id

1532: AND adjustment_period_flag = 'N'
1533: -- AND closing_status in ('F', 'O', 'C', 'N') -- commented for bug12917429
1534: AND migration_status_code IS NULL;
1535:
1536: fnd_file.Put_line(fnd_file.LOG,'*Periods updated to P for ledger_id: ' ||i_ledger_periods.ledger_id
1537: ||' are : ' ||To_char(SQL%ROWCOUNT));
1538: END LOOP;
1539: END IF;
1540:

Line 1596: fnd_file.Put_line(fnd_file.LOG,'*Return code from FA: '||To_char(l_retcode));

1592: l_step_value := 'Upgrade for Assets via FA Master API' ;
1593: fa_upgharness_pkg.Fa_master_upg(l_error_buf,l_retcode,l_number_of_workers,
1594: l_batch_size);
1595:
1596: fnd_file.Put_line(fnd_file.LOG,'*Return code from FA: '||To_char(l_retcode));
1597:
1598: ELSIF l_application_id = 200 THEN
1599: l_step_value := 'E-Tax Upgrade for Payables via E-Tax Master API' ;
1600: zx_on_demand_trx_upgrade_pkg.Zx_trx_update_mgr(

Line 1609: fnd_file.Put_line(fnd_file.LOG,'*Return code from ZX: '||To_char(l_retcode));

1605: p_application_id => l_application_id,
1606: p_ledger_id => l_ledger_id ,
1607: p_period_name => l_period_name);
1608:
1609: fnd_file.Put_line(fnd_file.LOG,'*Return code from ZX: '||To_char(l_retcode));
1610:
1611: IF l_retcode = 0 THEN
1612: -- resetting the return code to NON-ZERO so that the success of ZX is not propagated to Products run.
1613: -- Also, if Product API's donot initiliaze the recode correctly,then ZX retcode is treated as Products Retcode.

Line 1622: fnd_file.Put_line(fnd_file.LOG,'*Return code from AP: '||To_char(l_retcode));

1618: retcode => l_retcode,
1619: p_batch_size => l_batch_size,
1620: p_num_workers => l_number_of_workers);
1621:
1622: fnd_file.Put_line(fnd_file.LOG,'*Return code from AP: '||To_char(l_retcode));
1623: END IF;
1624: ELSIF l_application_id = 222 THEN
1625: l_step_value := 'E-Tax Upgrade for Receivables via E-Tax Master API' ;
1626: zx_on_demand_trx_upgrade_pkg.Zx_trx_update_mgr(

Line 1635: fnd_file.Put_line(fnd_file.LOG,'*Return code from ZX: '||To_char(l_retcode));

1631: p_application_id => l_application_id,
1632: p_ledger_id => l_ledger_id ,
1633: p_period_name => l_period_name );
1634:
1635: fnd_file.Put_line(fnd_file.LOG,'*Return code from ZX: '||To_char(l_retcode));
1636:
1637: IF l_retcode = 0 THEN
1638: -- resetting the return code to NON-ZERO so that the success of ZX is not propagated to Products run.
1639: -- Also, if Product API's donot initiliaze the recode correctly,then ZX retcode is treated as Products Retcode.

Line 1649: fnd_file.Put_line(fnd_file.LOG,'*Return code from AR: ' ||To_char(l_retcode));

1645: l_period_name,
1646: l_number_of_workers,
1647: l_batch_size);
1648:
1649: fnd_file.Put_line(fnd_file.LOG,'*Return code from AR: ' ||To_char(l_retcode));
1650: END IF;
1651: ELSIF l_application_id = 275 THEN
1652: NULL;
1653: -- Proect's is not participating in this upgrade. So, commented call for time being.

Line 1662: fnd_file.put_line(fnd_file.log, '*Return code from PA: '|| to_char(l_retcode));

1658: ,l_retcode
1659: ,l_number_of_workers
1660: ,l_batch_size);
1661:
1662: fnd_file.put_line(fnd_file.log, '*Return code from PA: '|| to_char(l_retcode));
1663: */
1664: ELSIF l_application_id IN (401) THEN
1665: l_retcode := -1 ;
1666: l_step_value := 'Upgrade for Inventory/WIP via Costing Master API' ;

Line 1675: fnd_file.Put_line(fnd_file.LOG,'*Return code from CST :' ||l_retcode_char ||' '||l_error_buf);

1671: X_Num_Workers => l_number_of_workers ,
1672: X_ledger_id => p_ledger_id ,
1673: X_application_id => l_application_id ) ;
1674:
1675: fnd_file.Put_line(fnd_file.LOG,'*Return code from CST :' ||l_retcode_char ||' '||l_error_buf);
1676:
1677: IF l_retcode_char = 'S' THEN
1678: l_retcode := 0;
1679: END IF;

Line 1691: fnd_file.Put_line(fnd_file.LOG,'*Return code from ZX: '||To_char(l_retcode));

1687: p_application_id => l_application_id,
1688: p_ledger_id => l_ledger_id ,
1689: p_period_name => l_period_name);
1690:
1691: fnd_file.Put_line(fnd_file.LOG,'*Return code from ZX: '||To_char(l_retcode));
1692:
1693: IF l_retcode = 0 THEN
1694: -- resetting the return code to NON-ZERO so that the success of ZX is not propagated to Products run.
1695: -- Also, if Product API's donot initiliaze the recode correctly,then ZX retcode is treated as Products Retcode.

Line 1707: fnd_file.Put_line(fnd_file.LOG,'*Return code from Receiving(PO): ' ||l_retcode_char);

1703: X_Num_Workers => l_number_of_workers ,
1704: X_ledger_id => p_ledger_id ,
1705: X_application_id => l_application_id ) ;
1706:
1707: fnd_file.Put_line(fnd_file.LOG,'*Return code from Receiving(PO): ' ||l_retcode_char);
1708:
1709: IF l_retcode_char = 'S' THEN
1710: l_retcode := 0;
1711: END IF;

Line 1720: fnd_file.Put_line(fnd_file.LOG,'Upgrade failed at: '||l_step_value );

1716: IF (c_level_statement >= g_log_level) THEN
1717: Trace('Upgrade failed at: '||l_step_value ,c_level_statement,l_log_module);
1718: END IF;
1719:
1720: fnd_file.Put_line(fnd_file.LOG,'Upgrade failed at: '||l_step_value );
1721: fnd_file.Put_line(fnd_file.LOG,'Updating the Return Code as 2(ERROR)');
1722: -- Set the Retcode as 2, so that it marks the product upgrade as ERROR
1723: l_retcode := 2 ; -- changes for 8834301
1724: END;

Line 1721: fnd_file.Put_line(fnd_file.LOG,'Updating the Return Code as 2(ERROR)');

1717: Trace('Upgrade failed at: '||l_step_value ,c_level_statement,l_log_module);
1718: END IF;
1719:
1720: fnd_file.Put_line(fnd_file.LOG,'Upgrade failed at: '||l_step_value );
1721: fnd_file.Put_line(fnd_file.LOG,'Updating the Return Code as 2(ERROR)');
1722: -- Set the Retcode as 2, so that it marks the product upgrade as ERROR
1723: l_retcode := 2 ; -- changes for 8834301
1724: END;
1725:

Line 1737: fnd_file.Put_line(fnd_file.LOG,'*Source name : '|| l_source_name);

1733: INTO l_source_name
1734: FROM xla_subledgers
1735: WHERE application_id = p_application_id;
1736:
1737: fnd_file.Put_line(fnd_file.LOG,'*Source name : '|| l_source_name);
1738:
1739: FORALL i IN 1..g_array_ledger_id.COUNT
1740: UPDATE gl_je_headers a
1741: SET a.je_from_sla_flag = decode(a.reversed_je_header_id,null,'U','N') ,

Line 1768: fnd_file.Put_line(fnd_file.LOG,'*Flags updated to U : '||To_char(SQL%ROWCOUNT));

1764: AND EXISTS (SELECT 1
1765: FROM xla_subledgers xsu
1766: WHERE xsu.je_source_name = a.je_source);
1767:
1768: fnd_file.Put_line(fnd_file.LOG,'*Flags updated to U : '||To_char(SQL%ROWCOUNT));
1769:
1770: IF (c_level_statement >= g_log_level) THEN
1771: Trace('Updated gl_je_headers',c_level_statement,l_log_module);
1772: END IF;

Line 1814: fnd_file.Put_line(fnd_file.LOG, l_error_buf) ;

1810: ,p_msg_name => 'XLA_OD_PROD_API_ERROR'
1811: ,p_token_1 => 'P_APPLICATION_NAME'
1812: ,p_value_1 => l_application_name
1813: );
1814: fnd_file.Put_line(fnd_file.LOG, l_error_buf) ;
1815: p_retcode := 2 ;
1816: p_errbuf := xla_messages_pkg.get_message ;
1817:
1818: WHEN incorrect_upg_date THEN

Line 2046: --fnd_file.put_line(fnd_file.log, '*Start date : '|| to_char(l_start_date));

2042: -- WHERE application_id = 401
2043: -- AND ledger_id = p_ledger_id
2044: -- AND period_name = p_period_name;
2045:
2046: --fnd_file.put_line(fnd_file.log, '*Start date : '|| to_char(l_start_date));
2047:
2048: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2049: -- trace('Start date of upgrade '|| l_start_date,
2050: -- C_LEVEL_STATEMENT, l_Log_module);

Line 2060: --fnd_file.put_line(fnd_file.log, '*End date : '|| to_char(l_end_date));

2056: -- WHERE migration_status_code = 'U'
2057: -- AND ledger_id = p_ledger_id
2058: -- AND application_id = 401;
2059:
2060: --fnd_file.put_line(fnd_file.log, '*End date : '|| to_char(l_end_date));
2061:
2062: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2063: -- trace('End date of upgrade '|| l_end_date,
2064: -- C_LEVEL_STATEMENT, l_Log_module);

Line 2086: --fnd_file.put_line(fnd_file.log, '*Periods updated to P : '|| to_char(SQL%ROWCOUNT));

2082: -- AND application_id in (201,401)
2083: -- AND adjustment_period_flag = 'N'
2084: -- AND migration_status_code IS NULL;
2085:
2086: --fnd_file.put_line(fnd_file.log, '*Periods updated to P : '|| to_char(SQL%ROWCOUNT));
2087:
2088: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2089: -- trace('Updated gl_period_statuses. '
2090: -- , C_LEVEL_STATEMENT, l_Log_module);

Line 2105: --fnd_file.put_line(fnd_file.log, '*Start date : '|| to_char(l_start_date));

2101: -- WHERE application_id = l_application_id
2102: -- AND ledger_id = p_ledger_id
2103: -- AND period_name = p_period_name;
2104:
2105: --fnd_file.put_line(fnd_file.log, '*Start date : '|| to_char(l_start_date));
2106:
2107: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2108: -- trace('Start date of upgrade '|| l_start_date,
2109: -- C_LEVEL_STATEMENT, l_Log_module);

Line 2122: --fnd_file.put_line(fnd_file.log, '*End date : '|| to_char(l_end_date));

2118: -- WHERE migration_status_code = 'U'
2119: -- AND ledger_id = p_ledger_id
2120: -- AND application_id = l_application_id;
2121:
2122: --fnd_file.put_line(fnd_file.log, '*End date : '|| to_char(l_end_date));
2123:
2124: -- IF l_end_date is NULL THEN
2125: -- RAISE NO_UPGRADE;
2126: -- END IF;

Line 2142: --fnd_file.put_line(fnd_file.log, '*Periods updated to P : '|| to_char(SQL%ROWCOUNT));

2138: -- AND end_date < l_end_date)
2139: -- AND adjustment_period_flag = 'N'
2140: -- AND migration_status_code IS NULL;
2141:
2142: --fnd_file.put_line(fnd_file.log, '*Periods updated to P : '|| to_char(SQL%ROWCOUNT));
2143:
2144: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2145: -- trace('Updated gl_period_statuses',
2146: -- C_LEVEL_STATEMENT, l_Log_module);

Line 2175: --fnd_file.put_line(fnd_file.log, '*Return code from FA: '|| to_char(l_retcode));

2171: -- l_retcode,
2172: -- l_number_of_workers,
2173: -- l_batch_size);
2174:
2175: --fnd_file.put_line(fnd_file.log, '*Return code from FA: '|| to_char(l_retcode));
2176:
2177: -- ELSIF l_application_id = 200 then
2178:
2179: -- AP_XLA_UPGRADE_PKG.AP_XLA_Upgrade_OnDemand(

Line 2185: --fnd_file.put_line(fnd_file.log, '*Return code from AP: '|| to_char(l_retcode));

2181: -- Retcode => l_retcode,
2182: -- P_Batch_Size => l_batch_size,
2183: -- P_Num_Workers => l_number_of_workers);
2184:
2185: --fnd_file.put_line(fnd_file.log, '*Return code from AP: '|| to_char(l_retcode));
2186:
2187: -- IF l_retcode = 0 THEN
2188: -- ZX_ON_DEMAND_TRX_UPGRADE_PKG.zx_trx_update_mgr(
2189: -- X_errbuf => l_error_buf,

Line 2195: -- fnd_file.put_line(fnd_file.log, '*Return code from ZX: '|| to_char(l_retcode));

2191: -- X_batch_size =>l_batch_size,
2192: -- X_Num_Workers =>l_number_of_workers,
2193: -- p_application_id => l_application_id);
2194:
2195: -- fnd_file.put_line(fnd_file.log, '*Return code from ZX: '|| to_char(l_retcode));
2196: -- END IF;
2197:
2198: -- ELSIF l_application_id = 222 then
2199: -- AR_UPGHARNESS_PKG.ar_master_upg(

Line 2207: --fnd_file.put_line(fnd_file.log, '*Return code from AR: '|| to_char(l_retcode));

2203: -- l_period_name,
2204: -- l_number_of_workers,
2205: -- l_batch_size);
2206:
2207: --fnd_file.put_line(fnd_file.log, '*Return code from AR: '|| to_char(l_retcode));
2208:
2209: -- IF l_retcode = 0 THEN
2210: -- ZX_ON_DEMAND_TRX_UPGRADE_PKG.zx_trx_update_mgr(
2211: -- X_errbuf => l_error_buf,

Line 2217: -- fnd_file.put_line(fnd_file.log, '*Return code from ZX: '|| to_char(l_retcode));

2213: -- X_batch_size =>l_batch_size,
2214: -- X_Num_Workers =>l_number_of_workers,
2215: -- p_application_id => l_application_id);
2216:
2217: -- fnd_file.put_line(fnd_file.log, '*Return code from ZX: '|| to_char(l_retcode));
2218: -- END IF;
2219: -- ELSIF l_application_id = 275 THEN
2220:
2221: -- PA_UPGHARNESS_PKG.pa_master_upg

Line 2227: --fnd_file.put_line(fnd_file.log, '*Return code from PA: '|| to_char(l_retcode));

2223: -- ,l_retcode
2224: -- ,l_number_of_workers
2225: -- ,l_batch_size);
2226:
2227: --fnd_file.put_line(fnd_file.log, '*Return code from PA: '|| to_char(l_retcode));
2228:
2229: -- ELSIF l_application_id = 707 THEN
2230:
2231: -- CST_SLA_UPDATE_PKG.Update_Proc_MGR (

Line 2246: --fnd_file.put_line(fnd_file.log, '*Return code from COST: '|| l_retcode_char);

2242: -- X_Argument8 => 'NULL',
2243: -- X_Argument9 => 'NULL',
2244: -- X_Argument10 => 'NULL');
2245:
2246: --fnd_file.put_line(fnd_file.log, '*Return code from COST: '|| l_retcode_char);
2247: -- IF l_retcode_char = 'S' THEN
2248: -- l_retcode := 0;
2249: -- END IF;
2250:

Line 2266: --fnd_file.put_line(fnd_file.log, '*Source name : '|| l_source_name);

2262: -- INTO l_source_name
2263: -- FROM XLA_SUBLEDGERS
2264: -- WHERE application_id = p_application_id;
2265:
2266: --fnd_file.put_line(fnd_file.log, '*Source name : '|| l_source_name);
2267:
2268: -- UPDATE gl_je_headers a
2269: -- SET a.je_from_sla_flag = 'U'
2270: -- WHERE (decode(a.je_source, l_source_name, p_application_id)

Line 2280: --fnd_file.put_line(fnd_file.log, '*Flags updated to U : '|| to_char(SQL%ROWCOUNT));

2276: -- AND b.ledger_id = l_ledger_id
2277: -- AND application_id = p_application_id)
2278: -- AND a.ledgeR_id = l_ledger_id;
2279:
2280: --fnd_file.put_line(fnd_file.log, '*Flags updated to U : '|| to_char(SQL%ROWCOUNT));
2281:
2282: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2283: -- trace('Updated gl_je_headers',
2284: -- C_LEVEL_STATEMENT, l_Log_module);

Line 2301: --fnd_file.put_line(fnd_file.log, '*Flags updated to U : '|| to_char(SQL%ROWCOUNT));

2297: -- AND b.ledger_id = l_ledger_id
2298: -- AND application_id in (201,401))
2299: -- AND a.ledgeR_id = l_ledger_id;
2300:
2301: --fnd_file.put_line(fnd_file.log, '*Flags updated to U : '|| to_char(SQL%ROWCOUNT));
2302:
2303: -- IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2304: -- trace('Updated gl_je_headers',
2305: -- C_LEVEL_STATEMENT, l_Log_module);

Line 2324: --fnd_file.put_line(fnd_file.log, '*Migration status code back to NULL : '|| to_char(SQL%ROWCOUNT));

2320: -- AND application_id in (201,401)
2321: -- AND adjustment_period_flag = 'N'
2322: -- AND migration_status_code = 'P';
2323:
2324: --fnd_file.put_line(fnd_file.log, '*Migration status code back to NULL : '|| to_char(SQL%ROWCOUNT));
2325:
2326: -- ELSE
2327:
2328: -- UPDATE gl_period_statuses

Line 2337: --fnd_file.put_line(fnd_file.log, '*Migration status code back to NULL : '|| to_char(SQL%ROWCOUNT));

2333: -- AND end_date < l_end_date)
2334: -- AND adjustment_period_flag = 'N'
2335: -- AND migration_status_code = 'P';
2336:
2337: --fnd_file.put_line(fnd_file.log, '*Migration status code back to NULL : '|| to_char(SQL%ROWCOUNT));
2338:
2339: -- END IF;
2340:
2341: -- RAISE UPGRADE_ERROR;

Line 2357: -- fnd_file.put_line(fnd_file.log, 'This is either a fresh R12

2353: -- an existing 11i instance has not taken place.',
2354: -- C_LEVEL_ERROR, l_Log_module);
2355: -- END IF;
2356:
2357: -- fnd_file.put_line(fnd_file.log, 'This is either a fresh R12
2358: -- installation or upgrade
2359: -- from an existing 11i instance
2360: -- has not taken place.');
2361:

Line 2372: -- fnd_file.put_line(fnd_file.log, 'Product Team API Failed');

2368: -- trace('There has been an error in the Product Upgrade',
2369: -- C_LEVEL_ERROR, l_Log_module);
2370: -- END IF;
2371:
2372: -- fnd_file.put_line(fnd_file.log, 'Product Team API Failed');
2373:
2374: -- l_temp := fnd_concurrent.set_completion_status
2375: -- (status => 'ERROR'
2376: -- ,message => NULL);