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

Line 161: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure start time: ' || l_sql_time);

157: (p_msg => 'UPG_MAIN procedure start time: ' || l_sql_time
158: ,p_level => C_LEVEL_PROCEDURE
159: ,p_module => l_log_module);
160: END IF;
161: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure start time: ' || l_sql_time);
162:
163: l_upgrade_id := fnd_global.conc_request_id();
164: l_primary_ledger_id := p_primary_ledger_id;
165: l_secondary_alc_ledger_id := p_reporting_ledger_id;

Line 209: fnd_file.put_line(fnd_file.log, 'Upgrade Recovery Completed Successfully');

205: crash_recovery();
206: IF l_upgrade_status = 0 THEN
207: p_retcode := 0;
208: p_errbuf := 'Upgrade Recovery Completed Successfully';
209: fnd_file.put_line(fnd_file.log, 'Upgrade Recovery Completed Successfully');
210: ELSE
211: p_retcode := 1;
212: p_errbuf := 'Upgrade Recovery Run Unsuccessful';
213: fnd_file.put_line(fnd_file.log, 'Upgrade Recovery Run Unsuccessful');

Line 213: fnd_file.put_line(fnd_file.log, 'Upgrade Recovery Run Unsuccessful');

209: fnd_file.put_line(fnd_file.log, 'Upgrade Recovery Completed Successfully');
210: ELSE
211: p_retcode := 1;
212: p_errbuf := 'Upgrade Recovery Run Unsuccessful';
213: fnd_file.put_line(fnd_file.log, 'Upgrade Recovery Run Unsuccessful');
214: END IF;
215:
216: RAISE validation_end;
217:

Line 235: fnd_file.put_line(fnd_file.log, 'Validation successful: end_date');

231: WHERE ledger_id = l_primary_ledger_id) -- removed l_secondary_alc_ledger_id
232: AND ledger_id = l_primary_ledger_id
233: AND application_id = 101;
234:
235: fnd_file.put_line(fnd_file.log, 'Validation successful: end_date');
236: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
237: trace
238: (p_msg => 'End date of last open period of sec/alc ledger = ' || l_sec_alc_end_date
239: ,p_level => C_LEVEL_PROCEDURE

Line 253: fnd_file.put_line(fnd_file.log, 'Validation failed: end_date');

249: ,p_level => C_LEVEL_PROCEDURE
250: ,p_module => l_log_module);
251: END IF;
252: l_upgrade_status := 1;
253: fnd_file.put_line(fnd_file.log, 'Validation failed: end_date');
254: IF l_validation_mode = 'F' THEN
255: RAISE abnormal_termination;
256: END IF;
257:

Line 305: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

301: ,p_level => C_LEVEL_PROCEDURE
302: ,p_module => l_log_module);
303: END IF;
304: fnd_message.set_name('XLA','XLA_UPG_GL_LEDG_NULL');
305: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
306: l_upgrade_status := 1;
307:
308: IF l_validation_mode = 'F' THEN
309: RAISE abnormal_termination;

Line 383: fnd_file.put_line(fnd_file.log,'UPG_MAIN validation procedure end time: ' || l_sql_time);

379: (p_msg => 'UPG_MAIN validation procedure end time: ' || l_sql_time
380: ,p_level => C_LEVEL_PROCEDURE
381: ,p_module => l_log_module);
382: END IF;
383: fnd_file.put_line(fnd_file.log,'UPG_MAIN validation procedure end time: ' || l_sql_time);
384:
385: IF l_upgrade_status = 0 THEN
386: p_retcode := 0;
387: p_errbuf := 'Upgrade Validation Completed Successfully';

Line 485: fnd_file.put_line(fnd_file.log,'Upgrade Successfully Completed');

481: ,p_level => C_LEVEL_PROCEDURE
482: ,p_module => l_log_module);
483:
484: END IF;
485: fnd_file.put_line(fnd_file.log,'Upgrade Successfully Completed');
486:
487: COMMIT;
488:
489:

Line 501: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure end time: ' || l_sql_time);

497: (p_msg => 'UPG_MAIN procedure end time: ' || l_sql_time
498: ,p_level => C_LEVEL_PROCEDURE
499: ,p_module => l_log_module);
500: END IF;
501: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure end time: ' || l_sql_time);
502:
503:
504:
505: EXCEPTION

Line 575: fnd_file.put_line(fnd_file.log, 'sql exception raised in upg_main is = ' || l_error_text);

571: (p_msg => 'sql exception raised in upg_main is = ' || l_error_text
572: ,p_level => C_LEVEL_PROCEDURE
573: ,p_module => l_log_module);
574: END IF;
575: fnd_file.put_line(fnd_file.log, 'sql exception raised in upg_main is = ' || l_error_text);
576:
577:
578: upgrade_rollback;
579: p_retcode := 1;

Line 807: fnd_file.put_line(fnd_file.log, 'Validation successful: ledger relationship');

803: ,p_level => C_LEVEL_PROCEDURE
804: ,p_module => l_log_module);
805: END IF;
806:
807: fnd_file.put_line(fnd_file.log, 'Validation successful: ledger relationship');
808:
809:
810: EXCEPTION when OTHERS THEN
811:

Line 821: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

817: ,p_module => l_log_module);
818: END IF;
819:
820: fnd_message.set_name('XLA','XLA_UPG_GL_REL_FAIL');
821: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
822:
823: l_upgrade_status := 1;
824:
825: IF l_validation_mode = 'F' THEN

Line 851: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

847: ,p_module => l_log_module);
848: END IF;
849:
850: fnd_message.set_name('XLA', 'XLA_UPG_ALREADY_RUN');
851: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
852:
853:
854: l_upgrade_status := -1;
855: RETURN;

Line 898: fnd_file.put_line(fnd_file.log, 'Validation successful: start date');

894: (p_msg => 'User specified start period for sec/alc ledger is valid. Starting date of this start period = ' || l_start_date
895: ,p_level => C_LEVEL_PROCEDURE
896: ,p_module => l_log_module);
897: END IF;
898: fnd_file.put_line(fnd_file.log, 'Validation successful: start date');
899:
900:
901: EXCEPTION WHEN others THEN
902:

Line 911: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

907: ,p_level => C_LEVEL_PROCEDURE
908: ,p_module => l_log_module);
909: END IF;
910: fnd_message.set_name('XLA','XLA_UPG_PERIOD_INVAL');
911: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
912:
913: l_upgrade_status := 1;
914: IF l_validation_mode = 'F' THEN
915: RETURN;

Line 948: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

944: ,p_module => l_log_module);
945: END IF;
946:
947: fnd_message.set_name('XLA','XLA_UPG_UNTRANS_ENTRIES');
948: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
949:
950:
951: l_upgrade_status := 1;
952: IF l_validation_mode = 'F' THEN

Line 960: fnd_file.put_line(fnd_file.log, 'Validation successful: data transferred to GL');

956:
957:
958: EXCEPTION WHEN others THEN
959:
960: fnd_file.put_line(fnd_file.log, 'Validation successful: data transferred to GL');
961: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
962: trace
963: (p_msg => 'All valid entries for primary ledger have been transferred to GL'
964: ,p_level => C_LEVEL_PROCEDURE

Line 995: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

991: ,p_module => l_log_module);
992: END IF;
993:
994: fnd_message.set_name('XLA','XLA_UPG_PREEXISTING_DATA');
995: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
996:
997:
998:
999: l_upgrade_status := 1;

Line 1008: fnd_file.put_line(fnd_file.log, 'Validation successful: pre-existing data');

1004:
1005:
1006: EXCEPTION WHEN others THEN
1007:
1008: fnd_file.put_line(fnd_file.log, 'Validation successful: pre-existing data');
1009: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1010: trace
1011: (p_msg => 'No data in sec/alc before upgrade start'
1012: ,p_level => C_LEVEL_PROCEDURE

Line 1031: fnd_file.put_line(fnd_file.log,'inside pre_validation SQL error msg = ' || l_error_text);

1027: (p_msg => 'inside pre_validation SQL error msg = ' || l_error_text
1028: ,p_level => C_LEVEL_PROCEDURE
1029: ,p_module => l_log_module);
1030: END IF;
1031: fnd_file.put_line(fnd_file.log,'inside pre_validation SQL error msg = ' || l_error_text);
1032:
1033:
1034: l_upgrade_status := 1;
1035:

Line 1119: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

1115: END IF;
1116:
1117:
1118: fnd_message.set_name('XLA','XLA_UPG_RATES_EXIST');
1119: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1120:
1121:
1122: l_upgrade_status := 1;
1123: RETURN;

Line 1129: fnd_file.put_line(fnd_file.log, 'Validation successful: rates table consistency');

1125:
1126:
1127: EXCEPTION WHEN others THEN
1128:
1129: fnd_file.put_line(fnd_file.log, 'Validation successful: rates table consistency');
1130: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1131: trace
1132: (p_msg => 'Currency rates not already defined for this currency'
1133: ,p_level => C_LEVEL_PROCEDURE

Line 1170: --fnd_file.put_line(fnd_file.log, fnd_message.get);

1166: ,p_module => l_log_module);
1167: END IF;
1168:
1169: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1170: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1171:
1172:
1173: l_upgrade_status := 1;
1174: IF l_validation_mode = 'F' THEN

Line 1194: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || c_entered_currencies_rec.currency_code);

1190: ,p_module => l_log_module);
1191: END IF;
1192:
1193: fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1194: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || c_entered_currencies_rec.currency_code);
1195:
1196: l_upgrade_status := 1;
1197: IF l_validation_mode = 'F' THEN
1198: RETURN;

Line 1201: fnd_file.put_line(fnd_file.log, 'Validation successful: currency API ' || c_entered_currencies_rec.currency_code);

1197: IF l_validation_mode = 'F' THEN
1198: RETURN;
1199: END IF;
1200: ELSE
1201: fnd_file.put_line(fnd_file.log, 'Validation successful: currency API ' || c_entered_currencies_rec.currency_code);
1202: END IF;
1203:
1204:
1205:

Line 1285: --fnd_file.put_line(fnd_file.log, fnd_message.get);

1281: END IF;
1282:
1283:
1284: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1285: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1286:
1287: l_upgrade_status := 1;
1288: IF l_validation_mode = 'F' THEN
1289: RETURN;

Line 1309: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || l_primary_currency_code);

1305: ,p_module => l_log_module);
1306: END IF;
1307:
1308: fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1309: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || l_primary_currency_code);
1310:
1311: l_upgrade_status := 1;
1312: IF l_validation_mode = 'F' THEN
1313: RETURN;

Line 1316: fnd_file.put_line(fnd_file.log, 'Validation successful: currency API ' || l_primary_currency_code);

1312: IF l_validation_mode = 'F' THEN
1313: RETURN;
1314: END IF;
1315: ELSE
1316: fnd_file.put_line(fnd_file.log, 'Validation successful: currency API ' || l_primary_currency_code);
1317: END IF;
1318:
1319:
1320: IF l_validation_mode = 'F' THEN

Line 1473: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

1469:
1470:
1471:
1472: fnd_message.set_name('XLA','XLA_UPG_ALC_DISABLED');
1473: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1474:
1475: l_upgrade_status := 1;
1476: RETURN;
1477:

Line 1545: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

1541: ,p_module => l_log_module);
1542: END IF;
1543:
1544: fnd_message.set_name('XLA','XLA_UPG_DIFF_SLAM');
1545: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1546:
1547:
1548:
1549:

Line 1555: fnd_file.put_line(fnd_file.log, 'Validation successful: SLAMs are same');

1551: IF l_validation_mode = 'F' THEN
1552: RETURN;
1553: END IF;
1554: ELSE
1555: fnd_file.put_line(fnd_file.log, 'Validation successful: SLAMs are same');
1556: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1557: trace
1558: (p_msg => 'Primary and Secondary Ledger SLAM are the same'
1559: ,p_level => C_LEVEL_PROCEDURE

Line 1575: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

1571: ,p_module => l_log_module);
1572: END IF;
1573:
1574: fnd_message.set_name('XLA','XLA_UPG_SLAM_COA_FAIL');
1575: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1576:
1577:
1578:
1579:

Line 1611: fnd_file.put_line(fnd_file.log, 'Validation successful: mapping exists');

1607: (p_msg => 'Valid chart of accounts mapping exists = ' || l_mapping_relationship_id
1608: ,p_level => C_LEVEL_PROCEDURE
1609: ,p_module => l_log_module);
1610: END IF;
1611: fnd_file.put_line(fnd_file.log, 'Validation successful: mapping exists');
1612:
1613: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1614: trace
1615: (p_msg => 'Valid name for chart of accounts mapping exists = ' || l_coa_mapping_name

Line 1619: fnd_file.put_line(fnd_file.log, 'Validation successful: mapping name exists');

1615: (p_msg => 'Valid name for chart of accounts mapping exists = ' || l_coa_mapping_name
1616: ,p_level => C_LEVEL_PROCEDURE
1617: ,p_module => l_log_module);
1618: END IF;
1619: fnd_file.put_line(fnd_file.log, 'Validation successful: mapping name exists');
1620:
1621: EXCEPTION WHEN others THEN
1622:
1623: IF l_mapping_relationship_id IS NULL THEN

Line 1633: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

1629: END IF;
1630:
1631:
1632: fnd_message.set_name('XLA','XLA_UPG_NO_COA');
1633: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1634:
1635:
1636:
1637: l_upgrade_status := 1;

Line 1653: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

1649: ,p_module => l_log_module);
1650: END IF;
1651:
1652: fnd_message.set_name('XLA','XLA_UPG_COA_INV_NAME');
1653: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1654:
1655:
1656:
1657: l_upgrade_status := 1;

Line 1681: fnd_file.put_line(fnd_file.log, 'inside validate_secondary SQL error msg = ' || l_error_text);

1677: (p_msg => 'inside validate_secondary SQL error msg = ' || l_error_text
1678: ,p_level => C_LEVEL_PROCEDURE
1679: ,p_module => l_log_module);
1680: END IF;
1681: fnd_file.put_line(fnd_file.log, 'inside validate_secondary SQL error msg = ' || l_error_text);
1682:
1683: l_upgrade_status := 1;
1684:
1685: END;

Line 2696: fnd_file.put_line(fnd_file.log,'Not running ccid_check since chart of accounts are the same for both ledgers');

2692: (p_msg => 'Exiting ccid_check since chart of accounts are the same for both secondary ledgers'
2693: ,p_level => C_LEVEL_PROCEDURE
2694: ,p_module => l_log_module);
2695: END IF;
2696: fnd_file.put_line(fnd_file.log,'Not running ccid_check since chart of accounts are the same for both ledgers');
2697: RETURN;
2698: END IF;
2699:
2700:

Line 2786: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

2782: END IF;
2783:
2784:
2785: fnd_message.set_name('XLA','XLA_UPG_CCID_NEG_ONE');
2786: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
2787:
2788:
2789: FOR c_invalid_ccids_record IN c_invalid_ccids
2790: LOOP

Line 2792: fnd_file.put_line(fnd_file.log, ' Could not generate seconadary/alc code_combination_id for = ' || c_invalid_ccids_record.from_ccid);

2788:
2789: FOR c_invalid_ccids_record IN c_invalid_ccids
2790: LOOP
2791:
2792: fnd_file.put_line(fnd_file.log, ' Could not generate seconadary/alc code_combination_id for = ' || c_invalid_ccids_record.from_ccid);
2793:
2794:
2795: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2796: trace

Line 2823: fnd_file.put_line(fnd_file.log, 'Validation successful: No Headers Generated with CCID -1');

2819: ,p_level => C_LEVEL_PROCEDURE
2820: ,p_module => l_log_module);
2821: END IF;
2822:
2823: fnd_file.put_line(fnd_file.log, 'Validation successful: No Headers Generated with CCID -1');
2824:
2825:
2826: COMMIT;
2827:

Line 2991: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

2987: END IF;
2988:
2989:
2990: fnd_message.set_name('XLA','XLA_UPG_CCID_NEG_ONE');
2991: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
2992:
2993:
2994: FOR c_invalid_ccids_record IN c_invalid_ccids
2995: LOOP

Line 2997: fnd_file.put_line(fnd_file.log, ' Could not generate seconadary/alc code_combination_id for = ' || c_invalid_ccids_record.from_ccid);

2993:
2994: FOR c_invalid_ccids_record IN c_invalid_ccids
2995: LOOP
2996:
2997: fnd_file.put_line(fnd_file.log, ' Could not generate seconadary/alc code_combination_id for = ' || c_invalid_ccids_record.from_ccid);
2998:
2999:
3000: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3001: trace

Line 3028: fnd_file.put_line(fnd_file.log, 'Validation success: No Headers Generated with CCID -1');

3024: ,p_level => C_LEVEL_PROCEDURE
3025: ,p_module => l_log_module);
3026: END IF;
3027:
3028: fnd_file.put_line(fnd_file.log, 'Validation success: No Headers Generated with CCID -1');
3029:
3030:
3031: COMMIT;
3032:

Line 3739: fnd_file.put_line(fnd_file.log, fnd_message.get);

3735: END IF;
3736:
3737:
3738: fnd_message.set_name('XLA','XLA_UPG_MANUAL_ADJUSTMENT');
3739: fnd_file.put_line(fnd_file.log, fnd_message.get);
3740:
3741:
3742: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3743:

Line 3763: fnd_file.put_line(fnd_file.log, 'Manual Adjustment not needed for any lines');

3759: ,p_level => C_LEVEL_PROCEDURE
3760: ,p_module => l_log_module);
3761: END IF;
3762:
3763: fnd_file.put_line(fnd_file.log, 'Manual Adjustment not needed for any lines');
3764:
3765:
3766: END;
3767:

Line 3849: fnd_file.put_line(fnd_file.log, 'Validation successful: ledger relationship');

3845: ,p_level => C_LEVEL_PROCEDURE
3846: ,p_module => l_log_module);
3847: END IF;
3848:
3849: fnd_file.put_line(fnd_file.log, 'Validation successful: ledger relationship');
3850:
3851:
3852: EXCEPTION when OTHERS THEN
3853: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3861: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);

3857: ,p_module => l_log_module);
3858: END IF;
3859:
3860: fnd_message.set_name('XLA','XLA_UPG_GL_REL_FAIL');
3861: fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
3862: l_upgrade_status := 1;
3863: RETURN;
3864:
3865: END;

Line 3888: fnd_file.put_line(fnd_file.log, 'Recovery Not Needed. DB Tables Consistent');

3884: ,p_level => C_LEVEL_PROCEDURE
3885: ,p_module => l_log_module);
3886: END IF;
3887:
3888: fnd_file.put_line(fnd_file.log, 'Recovery Not Needed. DB Tables Consistent');
3889: RETURN;
3890:
3891: END;
3892:

Line 3904: fnd_file.put_line(fnd_file.log, 'Recovery Not Needed. DB Tables Consistent');

3900: ,p_level => C_LEVEL_PROCEDURE
3901: ,p_module => l_log_module);
3902: END IF;
3903:
3904: fnd_file.put_line(fnd_file.log, 'Recovery Not Needed. DB Tables Consistent');
3905: RETURN;
3906:
3907: END IF;
3908: