DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on FND_CONCURRENT

Line 1036: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

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(
1037: status => 'ERROR',
1038: message => 'Materialized View Refresh has failed. Please review log file.');
1039:
1040: end if; --if (l_mv_name is not null) then

Line 1050: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

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(
1051: status => 'ERROR',
1052: message => 'Materialized View Refresh has failed. Please review log file.');
1053: --raise;
1054: END refresh_mviews;

Line 1068: FROM fnd_concurrent_requests fcr,

1064: l_is_pending Varchar2(1);
1065: l_request_id NUMBER;
1066: CURSOR C_CHECK_CP_REQ IS
1067: select request_id
1068: FROM fnd_concurrent_requests fcr,
1069: fnd_concurrent_programs fcp,
1070: fnd_application fa
1071: WHERE fa.application_short_name = p_application_short_name
1072: AND fcp.application_id = fa.application_id

Line 1069: fnd_concurrent_programs fcp,

1065: l_request_id NUMBER;
1066: CURSOR C_CHECK_CP_REQ IS
1067: select request_id
1068: FROM fnd_concurrent_requests fcr,
1069: fnd_concurrent_programs fcp,
1070: fnd_application fa
1071: WHERE fa.application_short_name = p_application_short_name
1072: AND fcp.application_id = fa.application_id
1073: AND fcp.concurrent_program_name = p_concurrent_program_name