DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on FND_FILE

Line 1014: fnd_file.put_line(FND_FILE.LOG,

1010: CLOSE Check_MV_Exists;
1011:
1012: if (l_mv_name is not null) then
1013:
1014: fnd_file.put_line(FND_FILE.LOG,
1015: 'Begin dbms_mview.refresh call to refresh data in '|| l_entity_name);
1016: dbms_mview.refresh(l_entity_name, 'C', '', TRUE, FALSE, 0,0,0, TRUE);
1017:
1018: fnd_file.put_line(FND_FILE.LOG,

Line 1018: fnd_file.put_line(FND_FILE.LOG,

1014: fnd_file.put_line(FND_FILE.LOG,
1015: 'Begin dbms_mview.refresh call to refresh data in '|| l_entity_name);
1016: dbms_mview.refresh(l_entity_name, 'C', '', TRUE, FALSE, 0,0,0, TRUE);
1017:
1018: fnd_file.put_line(FND_FILE.LOG,
1019: 'Completed dbms_mview.refresh call to refresh data in '|| l_entity_name);
1020:
1021: --This statement added as workaround for bug#2695199/2639679
1022: --MATERIALIZED VIEWS BECOME INVALID AFTER ALTER OR REFRESH

Line 1031: fnd_file.put_line(FND_FILE.LOG,

1027:
1028: else
1029:
1030: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' : Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1031: fnd_file.put_line(FND_FILE.LOG,
1032: 'Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1033: fnd_file.put_line(FND_FILE.LOG,
1034: 'Exiting program without performing any action');
1035: RETCODE := 'E';

Line 1033: fnd_file.put_line(FND_FILE.LOG,

1029:
1030: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' : Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1031: fnd_file.put_line(FND_FILE.LOG,
1032: 'Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1033: fnd_file.put_line(FND_FILE.LOG,
1034: 'Exiting program without performing any action');
1035: RETCODE := 'E';
1036: ERRBUF := 'Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh';
1037: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

Line 1047: fnd_file.put_line(FND_FILE.LOG,

1043: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1044:
1045: EXCEPTION
1046: when others then
1047: fnd_file.put_line(FND_FILE.LOG,
1048: 'Exception in refreshing MVs: '||sqlerrm);
1049: RETCODE := 'E';
1050: ERRBUF := 'Exception in refreshing MVs: '||sqlerrm;
1051: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(