DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on FND_FILE

Line 1013: fnd_file.put_line(FND_FILE.LOG,

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

Line 1017: fnd_file.put_line(FND_FILE.LOG,

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

Line 1030: fnd_file.put_line(FND_FILE.LOG,

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

Line 1032: fnd_file.put_line(FND_FILE.LOG,

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

Line 1046: fnd_file.put_line(FND_FILE.LOG,

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