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 FND_MESSAGE

Line 75: FND_MESSAGE.SET_NAME('JTF', 'JTF_GRID_SERVER_VALIDATION');

71: begin
72: if p_date is not NULL then
73: if serverInitDate > p_date then
74: -- dbms_output.put_line('in validation server');
75: FND_MESSAGE.SET_NAME('JTF', 'JTF_GRID_SERVER_VALIDATION');
76: FND_MESSAGE.SET_TOKEN('GRID', gridName, FALSE);
77: -- FND_MSG_PUB.ADD;
78: raise_error;
79: end if;

Line 76: FND_MESSAGE.SET_TOKEN('GRID', gridName, FALSE);

72: if p_date is not NULL then
73: if serverInitDate > p_date then
74: -- dbms_output.put_line('in validation server');
75: FND_MESSAGE.SET_NAME('JTF', 'JTF_GRID_SERVER_VALIDATION');
76: FND_MESSAGE.SET_TOKEN('GRID', gridName, FALSE);
77: -- FND_MSG_PUB.ADD;
78: raise_error;
79: end if;
80: end if;

Line 124: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

120: begin
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.');

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 129: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

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
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

Line 131: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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
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||'>'

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 139: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

135: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
136: ||lineFeed||lineFeed||'The following information is available:'
137: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
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

Line 141: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

137: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
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||'>'

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 149: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

145: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
146: ||lineFeed||lineFeed||'The following information is available:'
147: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
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:'

Line 151: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

147: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
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||'>'

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 159: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

155: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_datasource_name||'>'
156: ||lineFeed||lineFeed||'The following information is available:'
157: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
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|| '>'

Line 161: fnd_message.set_name('JTF','JTF_GRID_EXCEED_MAXLENGTH');

157: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
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.');

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 167: fnd_message.set_name('JTF','JTF_GRID_MISSING_SORT_COLUMN');

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
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

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 169: fnd_message.set_token('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');
173: fnd_message.set_token('SOURCE','jtf_griddb.'||method);

Line 170: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);

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');
173: fnd_message.set_token('SOURCE','jtf_griddb.'||method);
174: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);

Line 172: fnd_message.set_name('JTF','JTF_GRID_INVALID_COLUMNALIAS');

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');
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);

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 174: 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
178: fnd_message.set_name('JTF','JTF_GRID_ILLEGAL_SORT_COLUMN');

Line 175: fnd_message.set_token('COLUMN_ALIAS',nvl(message,'<'||nullValue||'>'));

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
178: fnd_message.set_name('JTF','JTF_GRID_ILLEGAL_SORT_COLUMN');
179: fnd_message.set_token('SOURCE','jtf_griddb.'||method);

Line 176: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);

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
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);

Line 178: fnd_message.set_name('JTF','JTF_GRID_ILLEGAL_SORT_COLUMN');

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
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);

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 180: fnd_message.set_token('DATASOURCE',tableDefs(tableIndex).grid_dataSource_name);

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
184: -- We should never get this message

Line 181: fnd_message.set_token('COLUMN_ALIAS',nvl(message,'<'||nullValue||'>'));

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
184: -- We should never get this message
185: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

Line 182: fnd_message.set_token('GRIDNAME',tableDefs(tableIndex).gridName);

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
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');

Line 185: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

181: fnd_message.set_token('COLUMN_ALIAS',nvl(message,'<'||nullValue||'>'));
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||'>'

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 193: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

189: ||lineFeed||'datasource: <'||tableDefs(tableIndex).grid_dataSource_name||'>'
190: ||lineFeed||lineFeed||'The following information is available:'
191: ||lineFeed||lineFeed||nvl(message,'<'||nullValue||'>')
192: ||lineFeed||lineFeed||'The error is in the form or the JTF_GRID package.');
193: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));
194: end if;
195: raise_error;
196: end handleErrors;
197:

Line 219: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

215: ,SQLError in varchar2) is
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.');

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 224: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

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;
226: elsif errorType = INIT_ERROR then
227: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');
228: fnd_message.set_token('SOURCE','JTF_GRIDDB');

Line 227: fnd_message.set_name('JTF','JTF_GRID_DB_ERRORS');

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;
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:'

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 234: fnd_message.set_token('SQLERROR',nvl(SQLError,'<'||nullValue||'>'));

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.');
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);

Line 237: fnd_message.set_name('JTF','JTF_GRID_INVALID_DATASOURCE');

233: ||lineFeed||lineFeed||'The error is either in the form or the metadata definition.');
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;

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 239: fnd_message.set_token('DATASOURCE',nvl(message,'<'||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
243: tableIndex := findTableDefIndex(gridName);

Line 240: fnd_message.set_token('GRIDNAME',nvl(rtrim(gridName),nullValue||'>'));

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
243: tableIndex := findTableDefIndex(gridName);
244: if tableIndex is null