DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on FND_CONCURRENT

Line 1037: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

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

Line 1051: l_return := FND_CONCURRENT.SET_COMPLETION_STATUS(

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

Line 1069: FROM fnd_concurrent_requests fcr,

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

Line 1070: fnd_concurrent_programs fcp,

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