26: * err_msg - (PRIVATE) shortcut for building standard gfm error message
27: */
28: PROCEDURE err_msg(name varchar2) is
29: begin
30: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
31: fnd_message.set_token('ROUTINE', 'FND_GFM.'||name);
32: fnd_message.set_token('ERRNO', SQLCODE);
33: fnd_message.set_token('REASON', SQLERRM);
34: end err_msg;
27: */
28: PROCEDURE err_msg(name varchar2) is
29: begin
30: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
31: fnd_message.set_token('ROUTINE', 'FND_GFM.'||name);
32: fnd_message.set_token('ERRNO', SQLCODE);
33: fnd_message.set_token('REASON', SQLERRM);
34: end err_msg;
35: /*--------------------------------------------------------------------------*/
28: PROCEDURE err_msg(name varchar2) is
29: begin
30: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
31: fnd_message.set_token('ROUTINE', 'FND_GFM.'||name);
32: fnd_message.set_token('ERRNO', SQLCODE);
33: fnd_message.set_token('REASON', SQLERRM);
34: end err_msg;
35: /*--------------------------------------------------------------------------*/
36: /*
29: begin
30: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
31: fnd_message.set_token('ROUTINE', 'FND_GFM.'||name);
32: fnd_message.set_token('ERRNO', SQLCODE);
33: fnd_message.set_token('REASON', SQLERRM);
34: end err_msg;
35: /*--------------------------------------------------------------------------*/
36: /*
37: * authenticate - validate the specified access key
690:
691: exception
692: when others then
693: retcode := '2'; -- (error)
694: fnd_message.retrieve(errbuf);
695: end;
696: /*--------------------------------------------------------------------------*/
697: /*
698: * file_create - create a new empty file
934: doc blob;
935: ct varchar2(100);
936: begin
937: if (fnd_gfm.authenticate(access, file_id) = FALSE) then
938: htp.p(Fnd_Message.Get_String('PAY','HR_51401_WEB_NOT_AUTHORIZED'));
939: else
940: fnd_gfm.download_blob(file_id);
941:
942: if (purge = 'yes') then
1078: htp.htmlOpen;
1079: htp.headOpen; htp.title('404 Not Found'); htp.headClose;
1080: htp.bodyOpen; htp.hr; htp.header(nsize=>1, cheader=>'HTTP Error 404');
1081: htp.hr;
1082: htp.p(Fnd_Message.Get_String('GMD','LM_BAD_FILENAME'));
1083: htp.bodyClose; htp.htmlClose;
1084: when others then
1085: fnd_gfm.err_msg('download_blob');
1086: raise;
1214: access := substr(p_path,instr(p_path,'/',1)+1,instr(p_path,'/',2)-2);
1215: l_file_id := substr(p_path,instr(p_path,'/',2)+1,(instr(p_path,'/',-1)-instr(p_path,'/',2)-1));
1216:
1217: if (fnd_gfm.authenticate(access, l_file_id) = FALSE) then
1218: htp.p(Fnd_Message.Get_String('PAY','HR_51401_WEB_NOT_AUTHORIZED'));
1219: else
1220:
1221: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL) then
1222: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source,'Downloading file_id '||to_char(l_file_id));
1400: BEGIN
1401:
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: if file_name is null then
1404: fnd_message.set_name('FND','GR_FILE_DATA_NULL');
1405: raise G_EXC_ERROR;
1406: end if;
1407:
1408: if fid is null then