DBA Data[Home] [Help]

APPS.EDW_VBH_SETUP dependencies on FND_MESSAGE

Line 315: fnd_message.set_name('BIS','EDW_NODATA_SET_OF_BOOKS');

311: dbms_sql.define_column(l_cursor_id,3,l_description,240);
312: l_rows_selected:= dbms_sql.execute(l_cursor_id);
313: if(dbms_sql.fetch_rows(l_cursor_id)=0) then
314: p_status:=false;
315: fnd_message.set_name('BIS','EDW_NODATA_SET_OF_BOOKS');
316: fnd_message.set_token('NAME', p_sob_name);
317: p_errMsg:=fnd_message.get;
318: --p_errMsg:='Cannot find '||p_sob_name||' in gl_sets_of_books';
319: else

Line 316: fnd_message.set_token('NAME', p_sob_name);

312: l_rows_selected:= dbms_sql.execute(l_cursor_id);
313: if(dbms_sql.fetch_rows(l_cursor_id)=0) then
314: p_status:=false;
315: fnd_message.set_name('BIS','EDW_NODATA_SET_OF_BOOKS');
316: fnd_message.set_token('NAME', p_sob_name);
317: p_errMsg:=fnd_message.get;
318: --p_errMsg:='Cannot find '||p_sob_name||' in gl_sets_of_books';
319: else
320: dbms_sql.column_value(l_cursor_id,1,l_sob_id);

Line 317: p_errMsg:=fnd_message.get;

313: if(dbms_sql.fetch_rows(l_cursor_id)=0) then
314: p_status:=false;
315: fnd_message.set_name('BIS','EDW_NODATA_SET_OF_BOOKS');
316: fnd_message.set_token('NAME', p_sob_name);
317: p_errMsg:=fnd_message.get;
318: --p_errMsg:='Cannot find '||p_sob_name||' in gl_sets_of_books';
319: else
320: dbms_sql.column_value(l_cursor_id,1,l_sob_id);
321: dbms_sql.column_value(l_cursor_id,2,l_coa_id);