eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_GRIDDB dependencies on JTF_GRIDDB

Line 1: PACKAGE BODY jtf_gridDB as

1: PACKAGE BODY jtf_gridDB as
2: /* $Header: JTFGRDDB.pls 120.2 2006/01/19 03:14:44 snellepa ship $ */
3: -----------------------
4: -- Version 11.5.3 - 2.03 09-Aug-2000
5: -----------------------

Line 125: fnd_message.set_token('SOURCE','JTF_GRIDDB');

121: if errorType = INVALID_GRID_ERROR
122: or tableIndex is null
123: or tableIndex = 0 then
124: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
125: fnd_message.set_token('SOURCE','JTF_GRIDDB');
126: fnd_message.set_token('MSG','Internal Error: jtf_grid.handleErrors() was called from jtf_griddb.'||method||' with the following information:'
127: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
128: ||lineFeed||lineFeed||'The error is in the form or the JTF_GRID package.');
129: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

Line 126: fnd_message.set_token('MSG','Internal Error: jtf_grid.handleErrors() was called from jtf_griddb.'||method||' with the following information:'

122: or tableIndex is null
123: or tableIndex = 0 then
124: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
125: fnd_message.set_token('SOURCE','JTF_GRIDDB');
126: fnd_message.set_token('MSG','Internal Error: jtf_grid.handleErrors() was called from jtf_griddb.'||method||' with the following information:'
127: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
128: ||lineFeed||lineFeed||'The error is in the form or the JTF_GRID package.');
129: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
130: elsif errorType = INTERNAL_ERROR then

Line 132: fnd_message.set_token('SOURCE','JTF_GRIDDB');

128: ||lineFeed||lineFeed||'The error is in the form or the JTF_GRID package.');
129: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
130: elsif errorType = INTERNAL_ERROR then
131: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
132: fnd_message.set_token('SOURCE','JTF_GRIDDB');
133: fnd_message.set_token('MSG','An unexpected error occurred in jtf_griddb.'||method
134: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
135: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
136: ||lineFeed||lineFeed||'The following information is available:'

Line 133: fnd_message.set_token('MSG','An unexpected error occurred in jtf_griddb.'||method

129: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
130: elsif errorType = INTERNAL_ERROR then
131: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
132: fnd_message.set_token('SOURCE','JTF_GRIDDB');
133: fnd_message.set_token('MSG','An unexpected error occurred in jtf_griddb.'||method
134: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
135: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
136: ||lineFeed||lineFeed||'The following information is available:'
137: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')

Line 142: fnd_message.set_token('SOURCE','JTF_GRIDDB');

138: ||lineFeed||lineFeed||'The error is in the form or the JTF_GRID package.');
139: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
140: elsif errorType = INVALID_PROPERTY_ERROR then
141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
142: fnd_message.set_token('SOURCE','JTF_GRIDDB');
143: fnd_message.set_token('MSG','Application Error: An invalid propertyType was passed to jtf_griddb.'||method
144: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
145: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
146: ||lineFeed||lineFeed||'The following information is available:'

Line 143: fnd_message.set_token('MSG','Application Error: An invalid propertyType was passed to jtf_griddb.'||method

139: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
140: elsif errorType = INVALID_PROPERTY_ERROR then
141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
142: fnd_message.set_token('SOURCE','JTF_GRIDDB');
143: fnd_message.set_token('MSG','Application Error: An invalid propertyType was passed to jtf_griddb.'||method
144: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
145: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
146: ||lineFeed||lineFeed||'The following information is available:'
147: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')

Line 152: fnd_message.set_token('SOURCE','JTF_GRIDDB');

148: ||lineFeed||lineFeed||' The error is in the form.');
149: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
150: elsif errorType = APPLICATION_ERROR then
151: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
152: fnd_message.set_token('SOURCE','JTF_GRIDDB');
153: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports that an Application Error has occurred for:'
154: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
155: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
156: ||lineFeed||lineFeed||'The following information is available:'

Line 153: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports that an Application Error has occurred for:'

149: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
150: elsif errorType = APPLICATION_ERROR then
151: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
152: fnd_message.set_token('SOURCE','JTF_GRIDDB');
153: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports that an Application Error has occurred for:'
154: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
155: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
156: ||lineFeed||lineFeed||'The following information is available:'
157: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')

Line 162: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports: A record of data for:'

158: ||lineFeed||lineFeed||'The error is either in the form or the metadata definition.');
159: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
160: elsif errorType = MAXLENGTH_EXCEEDED_ERROR then
161: fnd_message.set_name('JTF','JTF_GRID_EXCEED_MAXLENGTH');
162: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports: A record of data for:'
163: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
164: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_dataSource_name||'>'
165: ||lineFeed||lineFeed||'exceeds the current maxlength ('||to_char(jtf_dbstring_utils.getMaxStringLength)||' bytes / record). Reduce the number of columns defined in the datasource (metadata definition) or display partial column values.');
166: elsif errorType = MISSING_SORT_COL_ERROR then

Line 168: fnd_message.set_token('SOURCE','jtf_griddb.'||method);

164: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_dataSource_name||'>'
165: ||lineFeed||lineFeed||'exceeds the current maxlength ('||to_char(jtf_dbstring_utils.getMaxStringLength)||' bytes / record). Reduce the number of columns defined in the datasource (metadata definition) or display partial column values.');
166: elsif errorType = MISSING_SORT_COL_ERROR then
167: fnd_message.set_name('JTF','JTF_GRID_MISSING_SORT_COLUMN');
168: fnd_message.set_token('SOURCE','jtf_griddb.'||method);
169: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);
170: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);
171: elsif errorType = INVALID_COLUMNALIAS_ERROR then
172: fnd_message.set_name('JTF','JTF_GRID_INVALID_COLUMNALIAS');

Line 173: fnd_message.set_token('SOURCE','jtf_griddb.'||method);

169: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);
170: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);
171: elsif errorType = INVALID_COLUMNALIAS_ERROR then
172: fnd_message.set_name('JTF','JTF_GRID_INVALID_COLUMNALIAS');
173: fnd_message.set_token('SOURCE','jtf_griddb.'||method);
174: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);
175: fnd_message.set_token('COLUMN_ALIAS',nvl(message,'<'||nullValue||'>'));
176: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);
177: elsif errorType = ILLEGAL_SORT_COLUMN_ERROR then

Line 179: fnd_message.set_token('SOURCE','jtf_griddb.'||method);

175: fnd_message.set_token('COLUMN_ALIAS',nvl(message,'<'||nullValue||'>'));
176: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);
177: elsif errorType = ILLEGAL_SORT_COLUMN_ERROR then
178: fnd_message.set_name('JTF','JTF_GRID_ILLEGAL_SORT_COLUMN');
179: fnd_message.set_token('SOURCE','jtf_griddb.'||method);
180: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);
181: fnd_message.set_token('COLUMN_ALIAS',nvl(message,'<'||nullValue||'>'));
182: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);
183: else

Line 186: fnd_message.set_token('SOURCE','JTF_GRIDDB');

182: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);
183: else
184: -- We should never get this message
185: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
186: fnd_message.set_token('SOURCE','JTF_GRIDDB');
187: fnd_message.set_token('MSG','Internal Error: jtf_gridd.handleErrors() was called from jtf_griddb.'||method||' with an invalid errorType for:'
188: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
189: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_dataSource_name||'>'
190: ||lineFeed||lineFeed||'The following information is available:'

Line 187: fnd_message.set_token('MSG','Internal Error: jtf_gridd.handleErrors() was called from jtf_griddb.'||method||' with an invalid errorType for:'

183: else
184: -- We should never get this message
185: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
186: fnd_message.set_token('SOURCE','JTF_GRIDDB');
187: fnd_message.set_token('MSG','Internal Error: jtf_gridd.handleErrors() was called from jtf_griddb.'||method||' with an invalid errorType for:'
188: ||lineFeed||lineFeed||'grid: <'||tableDefs(tableIndex).gridName|| '>'
189: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_dataSource_name||'>'
190: ||lineFeed||lineFeed||'The following information is available:'
191: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')

Line 220: fnd_message.set_token('SOURCE','JTF_GRIDDB');

216: tableIndex pls_integer;
217: begin
218: if errorType = INVALID_GRID_ERROR then
219: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
220: fnd_message.set_token('SOURCE','JTF_GRIDDB');
221: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports that'
222: ||lineFeed||lineFeed||'grid: <'||nvl(rtrim(gridName),nullValue)||'>'
223: ||lineFeed||lineFeed||'has not been initialized. A grid must be specified using BLOCK.ITEM_NAME in UPPERCASE. The error is in the form.');
224: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

Line 221: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports that'

217: begin
218: if errorType = INVALID_GRID_ERROR then
219: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
220: fnd_message.set_token('SOURCE','JTF_GRIDDB');
221: fnd_message.set_token('MSG','Application Error: jtf_griddb.'||method||' reports that'
222: ||lineFeed||lineFeed||'grid: <'||nvl(rtrim(gridName),nullValue)||'>'
223: ||lineFeed||lineFeed||'has not been initialized. A grid must be specified using BLOCK.ITEM_NAME in UPPERCASE. The error is in the form.');
224: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
225: raise_error;

Line 228: fnd_message.set_token('SOURCE','JTF_GRIDDB');

224: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
225: raise_error;
226: elsif errorType = INIT_ERROR then
227: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
228: fnd_message.set_token('SOURCE','JTF_GRIDDB');
229: fnd_message.set_token('MSG','An unexpected error occurred in jtf_griddb.'||method||' for:'
230: ||lineFeed||lineFeed||'grid: <'||nvl(rtrim(gridName),nullValue)|| '>'
231: ||lineFeed||lineFeed||'The following information is available:'
232: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')

Line 229: fnd_message.set_token('MSG','An unexpected error occurred in jtf_griddb.'||method||' for:'

225: raise_error;
226: elsif errorType = INIT_ERROR then
227: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
228: fnd_message.set_token('SOURCE','JTF_GRIDDB');
229: fnd_message.set_token('MSG','An unexpected error occurred in jtf_griddb.'||method||' for:'
230: ||lineFeed||lineFeed||'grid: <'||nvl(rtrim(gridName),nullValue)|| '>'
231: ||lineFeed||lineFeed||'The following information is available:'
232: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
233: ||lineFeed||lineFeed||'The error is either in the form or the metadata definition.');

Line 238: fnd_message.set_token('SOURCE','jtf_griddb.'||method);

234: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
235: raise_error;
236: elsif errorType = INVALID_DATASOURCE_ERROR then
237: fnd_message.set_name('JTF','JTF_GRID_INVALID_DATASOURCE');
238: fnd_message.set_token('SOURCE','jtf_griddb.'||method);
239: fnd_message.set_token('DATASOURCE',nvl(message,'<'||nullValue||'>'));
240: fnd_message.set_token('GRIDNAME',nvl(rtrim(gridName),nullValue||'>'));
241: raise_error;
242: else

Line 2716: l_debug_tbl(i).debug_message := JTF_GRIDDB.getVersion;

2712: l_debug_tbl(i).debug_message := ' ';
2713: i := i + 1;
2714: l_debug_tbl(i).debug_message := 'SOURCE CODE INFORMATION';
2715: i := i + 1;
2716: l_debug_tbl(i).debug_message := JTF_GRIDDB.getVersion;
2717: i := i + 1;
2718: l_debug_tbl(i).debug_message := JTF_DBSTRING_UTILS.getVersion;
2719: i := i + 1;
2720: l_debug_tbl(i).debug_message := JTF_DBSTREAM_UTILS.getVersion;

Line 2936: END jtf_gridDB;

2932: raise;
2933: end if;
2934: end;
2935:
2936: END jtf_gridDB;