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 197: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

193: (p_msg => 'UPG_MAIN procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
194: ,p_level => C_LEVEL_PROCEDURE
195: ,p_module => l_log_module);
196: END IF;
197: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
198:
199:
200: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
201: trace

Line 534: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

530: (p_msg => 'UPG_MAIN procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
531: ,p_level => C_LEVEL_PROCEDURE
532: ,p_module => l_log_module);
533: END IF;
534: fnd_file.put_line(fnd_file.log,'UPG_MAIN procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
535:
536:
537:
538:

Line 577: fnd_file.put_line(fnd_file.log, 'SQL exception raised in upg_main is = ' || g_error_text);

573: (p_msg => 'SQL exception raised in upg_main is = ' || g_error_text
574: ,p_level => C_LEVEL_PROCEDURE
575: ,p_module => l_log_module);
576: END IF;
577: fnd_file.put_line(fnd_file.log, 'SQL exception raised in upg_main is = ' || g_error_text);
578:
579:
580: p_retcode := 2;
581: p_errbuf := 'Upgrade Failed (2)';

Line 612: fnd_file.put_line(fnd_file.log,'validate_recovery_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

608: (p_msg => 'validate_recovery_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
609: ,p_level => C_LEVEL_PROCEDURE
610: ,p_module => l_log_module);
611: END IF;
612: fnd_file.put_line(fnd_file.log,'validate_recovery_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
613:
614:
615: -- these sqls are called before current run row is inserted into xla_historic_control
616:

Line 634: fnd_file.put_line(fnd_file.log, 'validation failed: recovery not needed, no failed run exists. please re-submit in final mode' );

630: (p_msg => 'Recovery not needed, no failed run. Please re-submit in Final Mode'
631: ,p_level => C_LEVEL_PROCEDURE
632: ,p_module => l_log_module);
633: END IF;
634: fnd_file.put_line(fnd_file.log, 'validation failed: recovery not needed, no failed run exists. please re-submit in final mode' );
635:
636: ROLLBACK;
637: RAISE g_validation_failed;
638:

Line 652: fnd_file.put_line(fnd_file.log, 'validation failed: multiple failed runs, recovery not feasible' );

648: (p_msg => 'internal error: multiple failed runs, recovery not feasible'
649: ,p_level => C_LEVEL_PROCEDURE
650: ,p_module => l_log_module);
651: END IF;
652: fnd_file.put_line(fnd_file.log, 'validation failed: multiple failed runs, recovery not feasible' );
653:
654: ROLLBACK;
655: RAISE g_validation_failed;
656:

Line 692: fnd_file.put_line(fnd_file.log,'validate_recovery_mode procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

688: (p_msg => 'validate_recovery_mode procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
689: ,p_level => C_LEVEL_PROCEDURE
690: ,p_module => l_log_module);
691: END IF;
692: fnd_file.put_line(fnd_file.log,'validate_recovery_mode procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
693:
694:
695: END;
696:

Line 718: fnd_file.put_line(fnd_file.log,'validate_final_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

714: (p_msg => 'validate_final_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
715: ,p_level => C_LEVEL_PROCEDURE
716: ,p_module => l_log_module);
717: END IF;
718: fnd_file.put_line(fnd_file.log,'validate_final_mode procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
719:
720:
721: -- these sqls are called before current run row is inserted into xla_historic_control
722:

Line 752: fnd_file.put_line(fnd_file.log, 'validation failed: failed run exists for specified input criteria, please run in recovery mode' );

748: (p_msg => 'Failed run exists for specified input criteria, please run in Recovery Mode'
749: ,p_level => C_LEVEL_PROCEDURE
750: ,p_module => l_log_module);
751: END IF;
752: fnd_file.put_line(fnd_file.log, 'validation failed: failed run exists for specified input criteria, please run in recovery mode' );
753:
754: ROLLBACK;
755: RAISE g_validation_failed;
756:

Line 829: fnd_file.put_line(fnd_file.log, 'validation failed: start date specified should be equal to or less than the retrieved end date of ' || to_char(g_sec_alc_end_date,'DD-MON-RRRR'));

825: (p_msg => 'start date specified should be equal to or less than the retrieved end date of ' || to_char(g_sec_alc_end_date, 'DD-MON-RRRR')
826: ,p_level => C_LEVEL_PROCEDURE
827: ,p_module => l_log_module);
828: END IF;
829: fnd_file.put_line(fnd_file.log, 'validation failed: start date specified should be equal to or less than the retrieved end date of ' || to_char(g_sec_alc_end_date,'DD-MON-RRRR'));
830:
831: ROLLBACK;
832: RAISE g_validation_failed;
833:

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

871: ,p_module => l_log_module);
872: END IF;
873:
874: --fnd_message.set_name('XLA','XLA_UPG_UNTRANS_ENTRIES');
875: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
876: fnd_file.put_line(fnd_file.log, 'validation failed: there are valid accounting entries that have not been transferred to GL');
877:
878: ROLLBACK;
879: RAISE g_validation_failed;

Line 876: fnd_file.put_line(fnd_file.log, 'validation failed: there are valid accounting entries that have not been transferred to GL');

872: END IF;
873:
874: --fnd_message.set_name('XLA','XLA_UPG_UNTRANS_ENTRIES');
875: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
876: fnd_file.put_line(fnd_file.log, 'validation failed: there are valid accounting entries that have not been transferred to GL');
877:
878: ROLLBACK;
879: RAISE g_validation_failed;
880:

Line 889: fnd_file.put_line(fnd_file.log,'validate_final_mode procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

885: (p_msg => 'validate_final_mode procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
886: ,p_level => C_LEVEL_PROCEDURE
887: ,p_module => l_log_module);
888: END IF;
889: fnd_file.put_line(fnd_file.log,'validate_final_mode procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
890:
891: END;
892:
893:

Line 913: fnd_file.put_line(fnd_file.log,'retrieve_validate procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

909: (p_msg => 'retrieve_validate procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
910: ,p_level => C_LEVEL_PROCEDURE
911: ,p_module => l_log_module);
912: END IF;
913: fnd_file.put_line(fnd_file.log,'retrieve_validate procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
914:
915:
916: -- g_upgrade_id := fnd_global.conc_request_id(); commented out
917:

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

959: ,p_level => C_LEVEL_PROCEDURE
960: ,p_module => l_log_module);
961: END IF;
962: --fnd_message.set_name('XLA','XLA_UPG_GL_LEDG_NULL');
963: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
964: fnd_file.put_line(fnd_file.log, 'validation failed: g_conversion_option, g_currency_conversion_type, or g_currency_conversion_date is NULL for ALC ledger');
965:
966: ROLLBACK;
967: RAISE g_validation_failed;

Line 964: fnd_file.put_line(fnd_file.log, 'validation failed: g_conversion_option, g_currency_conversion_type, or g_currency_conversion_date is NULL for ALC ledger');

960: ,p_module => l_log_module);
961: END IF;
962: --fnd_message.set_name('XLA','XLA_UPG_GL_LEDG_NULL');
963: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
964: fnd_file.put_line(fnd_file.log, 'validation failed: g_conversion_option, g_currency_conversion_type, or g_currency_conversion_date is NULL for ALC ledger');
965:
966: ROLLBACK;
967: RAISE g_validation_failed;
968:

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

1090: ,p_module => l_log_module);
1091: END IF;
1092:
1093: --fnd_message.set_name('XLA','XLA_UPG_ALC_DISABLED');
1094: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1095: fnd_file.put_line(fnd_file.log, 'validation failed: application is not ALC-enabled in SLA');
1096:
1097: ROLLBACK;
1098: RAISE g_validation_failed;

Line 1095: fnd_file.put_line(fnd_file.log, 'validation failed: application is not ALC-enabled in SLA');

1091: END IF;
1092:
1093: --fnd_message.set_name('XLA','XLA_UPG_ALC_DISABLED');
1094: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1095: fnd_file.put_line(fnd_file.log, 'validation failed: application is not ALC-enabled in SLA');
1096:
1097: ROLLBACK;
1098: RAISE g_validation_failed;
1099:

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

1158: ,p_module => l_log_module);
1159: END IF;
1160: ROLLBACK;
1161: --fnd_message.set_name('XLA','XLA_UPG_DIFF_SLAM');
1162: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1163: fnd_file.put_line(fnd_file.log, 'validation failed: primary and secondary ledger have different AAD or budegtary control');
1164:
1165: RAISE g_validation_failed;
1166:

Line 1163: fnd_file.put_line(fnd_file.log, 'validation failed: primary and secondary ledger have different AAD or budegtary control');

1159: END IF;
1160: ROLLBACK;
1161: --fnd_message.set_name('XLA','XLA_UPG_DIFF_SLAM');
1162: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1163: fnd_file.put_line(fnd_file.log, 'validation failed: primary and secondary ledger have different AAD or budegtary control');
1164:
1165: RAISE g_validation_failed;
1166:
1167: ELSE

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

1182: ,p_module => l_log_module);
1183: END IF;
1184:
1185: --fnd_message.set_name('XLA','XLA_UPG_SLAM_COA_FAIL');
1186: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1187: fnd_file.put_line(fnd_file.log, 'validation failed: AADs or COAs not retrieved');
1188:
1189: ROLLBACK;
1190: RAISE g_validation_failed;

Line 1187: fnd_file.put_line(fnd_file.log, 'validation failed: AADs or COAs not retrieved');

1183: END IF;
1184:
1185: --fnd_message.set_name('XLA','XLA_UPG_SLAM_COA_FAIL');
1186: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1187: fnd_file.put_line(fnd_file.log, 'validation failed: AADs or COAs not retrieved');
1188:
1189: ROLLBACK;
1190: RAISE g_validation_failed;
1191:

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

1240: ,p_level => C_LEVEL_PROCEDURE
1241: ,p_module => l_log_module);
1242: END IF;
1243: --fnd_message.set_name('XLA','XLA_UPG_NO_COA');
1244: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1245: fnd_file.put_line(fnd_file.log, 'validation failed: no chart of accounts mapping defined');
1246:
1247: ROLLBACK;
1248: RAISE g_validation_failed;

Line 1245: fnd_file.put_line(fnd_file.log, 'validation failed: no chart of accounts mapping defined');

1241: ,p_module => l_log_module);
1242: END IF;
1243: --fnd_message.set_name('XLA','XLA_UPG_NO_COA');
1244: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1245: fnd_file.put_line(fnd_file.log, 'validation failed: no chart of accounts mapping defined');
1246:
1247: ROLLBACK;
1248: RAISE g_validation_failed;
1249: END IF;

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

1255: ,p_level => C_LEVEL_PROCEDURE
1256: ,p_module => l_log_module);
1257: END IF;
1258: --fnd_message.set_name('XLA','XLA_UPG_COA_INV_NAME');
1259: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1260: fnd_file.put_line(fnd_file.log, 'validation failed: no name defined for chart of accounts mapping');
1261:
1262: ROLLBACK;
1263: RAISE g_validation_failed;

Line 1260: fnd_file.put_line(fnd_file.log, 'validation failed: no name defined for chart of accounts mapping');

1256: ,p_module => l_log_module);
1257: END IF;
1258: --fnd_message.set_name('XLA','XLA_UPG_COA_INV_NAME');
1259: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1260: fnd_file.put_line(fnd_file.log, 'validation failed: no name defined for chart of accounts mapping');
1261:
1262: ROLLBACK;
1263: RAISE g_validation_failed;
1264: END IF;

Line 1281: fnd_file.put_line(fnd_file.log,'retrieve_validate procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

1277: (p_msg => 'retrieve_validate procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1278: ,p_level => C_LEVEL_PROCEDURE
1279: ,p_module => l_log_module);
1280: END IF;
1281: fnd_file.put_line(fnd_file.log,'retrieve_validate procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1282:
1283:
1284: END;
1285:

Line 1329: fnd_file.put_line(fnd_file.log,'populate_rates procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

1325: (p_msg => 'populate_rates procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1326: ,p_level => C_LEVEL_PROCEDURE
1327: ,p_module => l_log_module);
1328: END IF;
1329: fnd_file.put_line(fnd_file.log,'populate_rates procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1330:
1331: -- Check if somehow exchange rates already exists for this relationship id/upgrade id
1332:
1333:

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

1352: END IF;
1353:
1354:
1355: --fnd_message.set_name('XLA','XLA_UPG_RATES_EXIST');
1356: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1357: fnd_file.put_line(fnd_file.log, 'validation failed: currency rates already defined for this upgrade_id and relationship_id');
1358:
1359: ROLLBACK;
1360: RAISE g_validation_failed;

Line 1357: fnd_file.put_line(fnd_file.log, 'validation failed: currency rates already defined for this upgrade_id and relationship_id');

1353:
1354:
1355: --fnd_message.set_name('XLA','XLA_UPG_RATES_EXIST');
1356: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get);
1357: fnd_file.put_line(fnd_file.log, 'validation failed: currency rates already defined for this upgrade_id and relationship_id');
1358:
1359: ROLLBACK;
1360: RAISE g_validation_failed;
1361: END IF;

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

1399: ,p_module => l_log_module);
1400: END IF;
1401:
1402: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1403: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1404: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || c_entered_currencies_rec.currency_code);
1405:
1406: /* ROLLBACK;
1407: RAISE g_validation_failed; */ -- commented by vgopiset

Line 1404: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || c_entered_currencies_rec.currency_code);

1400: END IF;
1401:
1402: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1403: --fnd_file.put_line(fnd_file.log, fnd_message.get);
1404: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || c_entered_currencies_rec.currency_code);
1405:
1406: /* ROLLBACK;
1407: RAISE g_validation_failed; */ -- commented by vgopiset
1408:

Line 1419: fnd_file.put_line(fnd_file.log, 'validation failed: undefined error in populate rates');

1415: ,p_level => C_LEVEL_PROCEDURE
1416: ,p_module => l_log_module);
1417: END IF;
1418:
1419: fnd_file.put_line(fnd_file.log, 'validation failed: undefined error in populate rates');
1420:
1421: ROLLBACK;
1422: RAISE g_validation_failed;
1423:

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

1438: ,p_module => l_log_module);
1439: END IF;
1440:
1441: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1442: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || c_entered_currencies_rec.currency_code);
1443: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || c_entered_currencies_rec.currency_code);
1444:
1445: /* ROLLBACK;
1446: RAISE g_validation_failed;

Line 1443: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || c_entered_currencies_rec.currency_code);

1439: END IF;
1440:
1441: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1442: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || c_entered_currencies_rec.currency_code);
1443: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || c_entered_currencies_rec.currency_code);
1444:
1445: /* ROLLBACK;
1446: RAISE g_validation_failed;
1447: */ -- commented by vgopiset

Line 1522: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || g_primary_currency_code);

1518: ,p_level => C_LEVEL_PROCEDURE
1519: ,p_module => l_log_module);
1520: END IF;
1521:
1522: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || g_primary_currency_code);
1523:
1524:
1525: ROLLBACK;
1526: RAISE g_validation_failed;

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

1541: ,p_module => l_log_module);
1542: END IF;
1543:
1544: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1545: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || g_primary_currency_code);
1546: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || g_primary_currency_code);
1547:
1548: ROLLBACK;
1549: RAISE g_validation_failed;

Line 1546: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || g_primary_currency_code);

1542: END IF;
1543:
1544: --fnd_message.set_name('XLA','XLA_UPG_CURRENCY_API');
1545: --fnd_file.put_line(fnd_file.log, 'Validation failed: ' || fnd_message.get || ' ' || g_primary_currency_code);
1546: fnd_file.put_line(fnd_file.log, 'validation failed: GL API returned a null value for the currency or threw back an EXCEPTION for currency = ' || g_primary_currency_code);
1547:
1548: ROLLBACK;
1549: RAISE g_validation_failed;
1550:

Line 1552: --fnd_file.put_line(fnd_file.log, 'Validation successful: currency API ' || g_primary_currency_code);

1548: ROLLBACK;
1549: RAISE g_validation_failed;
1550:
1551: ELSE
1552: --fnd_file.put_line(fnd_file.log, 'Validation successful: currency API ' || g_primary_currency_code);
1553: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1554: trace
1555: (p_msg => 'Validation successful: currency API ' || g_primary_currency_code
1556: ,p_level => C_LEVEL_PROCEDURE

Line 1619: fnd_file.put_line(fnd_file.log,'populate_rates procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

1615: (p_msg => 'populate_rates procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1616: ,p_level => C_LEVEL_PROCEDURE
1617: ,p_module => l_log_module);
1618: END IF;
1619: fnd_file.put_line(fnd_file.log,'populate_rates procedure end time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1620:
1621:
1622: END;
1623:

Line 1663: fnd_file.put_line(fnd_file.log,'insert_data procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

1659: (p_msg => 'insert_data procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
1660: ,p_level => C_LEVEL_PROCEDURE
1661: ,p_module => l_log_module);
1662: END IF;
1663: fnd_file.put_line(fnd_file.log,'insert_data procedure start time: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1664:
1665:
1666: SELECT DECODE(primary_coa, secondary_coa, 'N', 'Y'),
1667: DECODE(primary_cal_set_name, primary_sec_alc_set_name,

Line 1763: fnd_file.put_line(fnd_file.log, 'validation failed: invalid request_id, worker '|| i || ' generated REQUEST_ID ' || g_worker(i));

1759: ,p_level => C_LEVEL_PROCEDURE
1760: ,p_module => l_log_module);
1761: END IF;
1762:
1763: fnd_file.put_line(fnd_file.log, 'validation failed: invalid request_id, worker '|| i || ' generated REQUEST_ID ' || g_worker(i));
1764: ROLLBACK;
1765: RAISE G_CHILD_FAILED;
1766:
1767:

Line 1851: fnd_file.put_line(fnd_file.log, 'validation failed: atleast one child failed with an error');

1847: ,p_level => C_LEVEL_PROCEDURE
1848: ,p_module => l_log_module);
1849: END IF;
1850:
1851: fnd_file.put_line(fnd_file.log, 'validation failed: atleast one child failed with an error');
1852:
1853:
1854: ROLLBACK;
1855: RAISE G_CHILD_FAILED;

Line 1953: fnd_file.put_line(fnd_file.log, 'Started child worker request ' || l_child_request || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

1949:
1950: l_child_request := fnd_global.conc_request_id();
1951: l_iterations := 0;
1952:
1953: fnd_file.put_line(fnd_file.log, 'Started child worker request ' || l_child_request || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
1954:
1955: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1956:
1957: trace

Line 2033: fnd_file.put_line(fnd_file.log,to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Unable to derive table owner ');

2029:
2030: EXCEPTION
2031: --Added for 12349350
2032: WHEN e_no_table_owner THEN
2033: fnd_file.put_line(fnd_file.log,to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')||' - Unable to derive table owner ');
2034: RAISE;
2035: WHEN OTHERS THEN
2036: RAISE;
2037:

Line 3021: fnd_file.put_line(fnd_file.log, 'Child worker request completed successfully ' || l_child_request || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

3017: (p_msg => 'Child worker request completed successfully ' || l_child_request || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
3018: ,p_level => C_LEVEL_PROCEDURE
3019: ,p_module => l_log_module);
3020: END IF;
3021: fnd_file.put_line(fnd_file.log, 'Child worker request completed successfully ' || l_child_request || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));
3022:
3023:
3024: EXCEPTION WHEN GL_INVALID_MAPPING_NAME THEN
3025: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 3031: fnd_file.put_line(fnd_file.log, 'Exception: no mapping with the mapping name');

3027: (p_msg => 'Child worker failed with GL_INVALID_MAPPING_NAME'
3028: ,p_level => C_LEVEL_PROCEDURE
3029: ,p_module => l_log_module);
3030: END IF;
3031: fnd_file.put_line(fnd_file.log, 'Exception: no mapping with the mapping name');
3032: p_retcode := 2;
3033: p_errbuf := 'Subworker failed(0)';
3034:
3035:

Line 3043: fnd_file.put_line(fnd_file.log, 'Exception: mapping is disabled, current date is outside the active date range for the mapping');

3039: (p_msg => 'Child worker failed with GL_DISABLED_MAPPING'
3040: ,p_level => C_LEVEL_PROCEDURE
3041: ,p_module => l_log_module);
3042: END IF;
3043: fnd_file.put_line(fnd_file.log, 'Exception: mapping is disabled, current date is outside the active date range for the mapping');
3044: p_retcode := 2;
3045: p_errbuf := 'Subworker failed(0)';
3046:
3047:

Line 3055: fnd_file.put_line(fnd_file.log, 'Exception: mapping rules are incorrectly defined');

3051: (p_msg => 'Child worker failed with GL_INVALID_MAPPING_RULES'
3052: ,p_level => C_LEVEL_PROCEDURE
3053: ,p_module => l_log_module);
3054: END IF;
3055: fnd_file.put_line(fnd_file.log, 'Exception: mapping rules are incorrectly defined');
3056: p_retcode := 2;
3057: p_errbuf := 'Subworker failed(0)';
3058:
3059:

Line 3067: fnd_file.put_line(fnd_file.log, 'Exception: unexpected error');

3063: (p_msg => 'Child worker failed with GL_MAP_UNEXPECTED_ERROR'
3064: ,p_level => C_LEVEL_PROCEDURE
3065: ,p_module => l_log_module);
3066: END IF;
3067: fnd_file.put_line(fnd_file.log, 'Exception: unexpected error');
3068: p_retcode := 2;
3069: p_errbuf := 'Subworker failed(0)';
3070:
3071:

Line 3079: fnd_file.put_line(fnd_file.log, 'Exception: source chart of accounts has no balancing segment');

3075: (p_msg => 'Child worker failed with GL_BSV_MAP_NO_SOURCE_BAL_SEG'
3076: ,p_level => C_LEVEL_PROCEDURE
3077: ,p_module => l_log_module);
3078: END IF;
3079: fnd_file.put_line(fnd_file.log, 'Exception: source chart of accounts has no balancing segment');
3080: p_retcode := 2;
3081: p_errbuf := 'Subworker failed(0)';
3082:
3083:

Line 3091: fnd_file.put_line(fnd_file.log, 'Exception: target chart of accounts has no balancing segment');

3087: (p_msg => 'Child worker failed with GL_BSV_MAP_NO_TARGET_BAL_SEG'
3088: ,p_level => C_LEVEL_PROCEDURE
3089: ,p_module => l_log_module);
3090: END IF;
3091: fnd_file.put_line(fnd_file.log, 'Exception: target chart of accounts has no balancing segment');
3092: p_retcode := 2;
3093: p_errbuf := 'Subworker failed(0)';
3094:
3095:

Line 3103: fnd_file.put_line(fnd_file.log, 'Exception: no segment mapping for the balancing segment');

3099: (p_msg => 'Child worker failed with GL_BSV_MAP_NO_SEGMENT_MAP'
3100: ,p_level => C_LEVEL_PROCEDURE
3101: ,p_module => l_log_module);
3102: END IF;
3103: fnd_file.put_line(fnd_file.log, 'Exception: no segment mapping for the balancing segment');
3104: p_retcode := 2;
3105: p_errbuf := 'Subworker failed(0)';
3106:
3107: WHEN GL_BSV_MAP_NO_SINGLE_VALUE THEN

Line 3114: fnd_file.put_line(fnd_file.log, 'Exception: no single value to assign to the balancing segment');

3110: (p_msg => 'Child worker failed with GL_BSV_MAP_NO_SINGLE_VALUE'
3111: ,p_level => C_LEVEL_PROCEDURE
3112: ,p_module => l_log_module);
3113: END IF;
3114: fnd_file.put_line(fnd_file.log, 'Exception: no single value to assign to the balancing segment');
3115: p_retcode := 2;
3116: p_errbuf := 'Subworker failed(0)';
3117:
3118:

Line 3126: fnd_file.put_line(fnd_file.log, 'Exception: no derive-from segment');

3122: (p_msg => 'Child worker failed with GL_BSV_MAP_NO_FROM_SEGMENT'
3123: ,p_level => C_LEVEL_PROCEDURE
3124: ,p_module => l_log_module);
3125: END IF;
3126: fnd_file.put_line(fnd_file.log, 'Exception: no derive-from segment');
3127: p_retcode := 2;
3128: p_errbuf := 'Subworker failed(0)';
3129:
3130:

Line 3138: fnd_file.put_line(fnd_file.log, 'Exception: derive-from segment is not the balancing segment');

3134: (p_msg => 'Child worker failed with GL_BSV_MAP_NOT_BSV_DERIVED'
3135: ,p_level => C_LEVEL_PROCEDURE
3136: ,p_module => l_log_module);
3137: END IF;
3138: fnd_file.put_line(fnd_file.log, 'Exception: derive-from segment is not the balancing segment');
3139: p_retcode := 2;
3140: p_errbuf := 'Subworker failed(0)';
3141:
3142: WHEN GL_BSV_MAP_SETUP_ERROR THEN

Line 3149: fnd_file.put_line(fnd_file.log, 'Exception: mapping setup information could not be obtained');

3145: (p_msg => 'Child worker failed with GL_BSV_MAP_SETUP_ERROR'
3146: ,p_level => C_LEVEL_PROCEDURE
3147: ,p_module => l_log_module);
3148: END IF;
3149: fnd_file.put_line(fnd_file.log, 'Exception: mapping setup information could not be obtained');
3150: p_retcode := 2;
3151: p_errbuf := 'Subworker failed(0)';
3152:
3153:

Line 3161: fnd_file.put_line(fnd_file.log, 'Exception: mapping could not be performed');

3157: (p_msg => 'Child worker failed with GL_BSV_MAP_MAPPING_ERROR'
3158: ,p_level => C_LEVEL_PROCEDURE
3159: ,p_module => l_log_module);
3160: END IF;
3161: fnd_file.put_line(fnd_file.log, 'Exception: mapping could not be performed');
3162: p_retcode := 2;
3163: p_errbuf := 'Subworker failed(0)';
3164:
3165:

Line 3173: fnd_file.put_line(fnd_file.log, 'Exception: unexpected error in BSV mapping information');

3169: (p_msg => 'Child worker failed with GL_BSV_MAP_UNEXPECTED_ERROR'
3170: ,p_level => C_LEVEL_PROCEDURE
3171: ,p_module => l_log_module);
3172: END IF;
3173: fnd_file.put_line(fnd_file.log, 'Exception: unexpected error in BSV mapping information');
3174: p_retcode := 2;
3175: p_errbuf := 'Subworker failed(0)';
3176:
3177:

Line 3186: fnd_file.put_line(fnd_file.log, 'XAH rowcount and mapping GT rowcount mismatch');

3182: (p_msg => 'Child worker failed with g_sub_validation_failed'
3183: ,p_level => C_LEVEL_PROCEDURE
3184: ,p_module => l_log_module);
3185: END IF;
3186: fnd_file.put_line(fnd_file.log, 'XAH rowcount and mapping GT rowcount mismatch');
3187: p_retcode := 2;
3188: p_errbuf := 'Subworker failed(1)';
3189:
3190:

Line 3199: fnd_file.put_line(fnd_file.log, 'SQL exception child worker = ' || g_error_text);

3195: (p_msg => 'Child worker failed with ' || g_error_text
3196: ,p_level => C_LEVEL_PROCEDURE
3197: ,p_module => l_log_module);
3198: END IF;
3199: fnd_file.put_line(fnd_file.log, 'SQL exception child worker = ' || g_error_text);
3200: p_retcode := 2;
3201: p_errbuf := 'Subworker failed(2)';
3202:
3203: END;