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.GR_EIN_ASL_CONCS_PKG dependencies on APP_EXCEPTION

Line 148: APP_EXCEPTION.Raise_Exception;

144: FND_MESSAGE.SET_TOKEN('TEXT',
145: l_msg_data,
146: FALSE);
147: IF FND_API.To_Boolean(p_called_by_form) THEN
148: APP_EXCEPTION.Raise_Exception;
149: ELSE
150: x_msg_data := FND_MESSAGE.Get;
151: END IF;
152:

Line 156: x_oracle_error := APP_EXCEPTION.Get_Code;

152:
153: WHEN Item_Exists_Error THEN
154: ROLLBACK TO SAVEPOINT Insert_Row;
155: x_return_status := 'E';
156: x_oracle_error := APP_EXCEPTION.Get_Code;
157: FND_MESSAGE.SET_NAME('GR',
158: 'GR_RECORD_EXISTS');
159: FND_MESSAGE.SET_TOKEN('CODE',
160: p_european_index_number||' '||p_hazard_classification_code,

Line 163: APP_EXCEPTION.Raise_Exception;

159: FND_MESSAGE.SET_TOKEN('CODE',
160: p_european_index_number||' '||p_hazard_classification_code,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;
164: ELSE
165: x_msg_data := FND_MESSAGE.Get;
166: END IF;
167:

Line 171: x_oracle_error := APP_EXCEPTION.Get_Code;

167:
168: WHEN Row_Missing_Error THEN
169: ROLLBACK TO SAVEPOINT Insert_Row;
170: x_return_status := 'E';
171: x_oracle_error := APP_EXCEPTION.Get_Code;
172: FND_MESSAGE.SET_NAME('GR',
173: 'GR_NO_RECORD_INSERTED');
174: FND_MESSAGE.SET_TOKEN('CODE',
175: p_european_index_number,

Line 179: APP_EXCEPTION.Raise_Exception;

175: p_european_index_number,
176: FALSE);
177: x_msg_data := FND_MESSAGE.Get;
178: IF FND_API.To_Boolean(p_called_by_form) THEN
179: APP_EXCEPTION.Raise_Exception;
180: ELSE
181: x_msg_data := FND_MESSAGE.Get;
182: END IF;
183:

Line 195: APP_EXCEPTION.Raise_Exception;

191: FND_MESSAGE.SET_TOKEN('TEXT',
192: l_msg_data,
193: FALSE);
194: IF FND_API.To_Boolean(p_called_by_form) THEN
195: APP_EXCEPTION.Raise_Exception;
196: ELSE
197: x_msg_data := FND_MESSAGE.Get;
198: END IF;
199:

Line 296: APP_EXCEPTION.Raise_Exception;

292: FND_MESSAGE.SET_TOKEN('TEXT',
293: l_msg_data,
294: FALSE);
295: IF FND_API.To_Boolean(p_called_by_form) THEN
296: APP_EXCEPTION.Raise_Exception;
297: ELSE
298: x_msg_data := FND_MESSAGE.Get;
299: END IF;
300:

Line 304: x_oracle_error := APP_EXCEPTION.Get_Code;

300:
301: WHEN Row_Missing_Error THEN
302: ROLLBACK TO SAVEPOINT Update_Row;
303: x_return_status := 'E';
304: x_oracle_error := APP_EXCEPTION.Get_Code;
305: FND_MESSAGE.SET_NAME('GR',
306: 'GR_NO_RECORD_INSERTED');
307: FND_MESSAGE.SET_TOKEN('CODE',
308: p_european_index_number||' '||TO_CHAR(p_concentration_low)||'-'||TO_CHAR(p_concentration_high),

Line 311: APP_EXCEPTION.Raise_Exception;

307: FND_MESSAGE.SET_TOKEN('CODE',
308: p_european_index_number||' '||TO_CHAR(p_concentration_low)||'-'||TO_CHAR(p_concentration_high),
309: FALSE);
310: IF FND_API.To_Boolean(p_called_by_form) THEN
311: APP_EXCEPTION.Raise_Exception;
312: ELSE
313: x_msg_data := FND_MESSAGE.Get;
314: END IF;
315:

Line 327: APP_EXCEPTION.Raise_Exception;

323: FND_MESSAGE.SET_TOKEN('TEXT',
324: l_msg_data,
325: FALSE);
326: IF FND_API.To_Boolean(p_called_by_form) THEN
327: APP_EXCEPTION.Raise_Exception;
328: ELSE
329: x_msg_data := FND_MESSAGE.Get;
330: END IF;
331:

Line 417: APP_EXCEPTION.Raise_Exception;

413: FND_MESSAGE.SET_TOKEN('CODE',
414: p_european_index_number||' '||TO_CHAR(p_concentration_low)||'-'||TO_CHAR(p_concentration_high),
415: FALSE);
416: IF FND_API.To_Boolean(p_called_by_form) THEN
417: APP_EXCEPTION.Raise_Exception;
418: ELSE
419: x_msg_data := FND_MESSAGE.Get;
420: END IF;
421: WHEN RECORD_CHANGED_ERROR THEN

Line 427: APP_EXCEPTION.Raise_Exception;

423: X_return_status := 'E';
424: FND_MESSAGE.SET_NAME('FND',
425: 'FORM_RECORD_CHANGED');
426: IF FND_API.To_Boolean(p_called_by_form) THEN
427: APP_EXCEPTION.Raise_Exception;
428: ELSE
429: x_msg_data := FND_MESSAGE.Get;
430: END IF;
431: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 431: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

427: APP_EXCEPTION.Raise_Exception;
428: ELSE
429: x_msg_data := FND_MESSAGE.Get;
430: END IF;
431: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
432: ROLLBACK TO SAVEPOINT Lock_Row;
433: x_return_status := 'L';
434: x_oracle_error := APP_EXCEPTION.Get_Code;
435: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 434: x_oracle_error := APP_EXCEPTION.Get_Code;

430: END IF;
431: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
432: ROLLBACK TO SAVEPOINT Lock_Row;
433: x_return_status := 'L';
434: x_oracle_error := APP_EXCEPTION.Get_Code;
435: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
436: FND_MESSAGE.SET_NAME('GR',
437: 'GR_ROW_IS_LOCKED');
438: x_msg_data := FND_MESSAGE.Get;

Line 451: APP_EXCEPTION.Raise_Exception;

447: FND_MESSAGE.SET_TOKEN('TEXT',
448: l_msg_data,
449: FALSE);
450: IF FND_API.To_Boolean(p_called_by_form) THEN
451: APP_EXCEPTION.Raise_Exception;
452: ELSE
453: x_msg_data := FND_MESSAGE.Get;
454: END IF;
455:

Line 532: APP_EXCEPTION.Raise_Exception;

528: ROLLBACK TO SAVEPOINT Delete_Row;
529: x_return_status := l_return_status;
530: x_oracle_error := l_oracle_error;
531: IF FND_API.To_Boolean(p_called_by_form) THEN
532: APP_EXCEPTION.Raise_Exception;
533: ELSE
534: x_msg_data := FND_MESSAGE.Get;
535: END IF;
536:

Line 540: x_oracle_error := APP_EXCEPTION.Get_Code;

536:
537: WHEN Row_Missing_Error THEN
538: ROLLBACK TO SAVEPOINT Delete_Row;
539: x_return_status := 'E';
540: x_oracle_error := APP_EXCEPTION.Get_Code;
541: FND_MESSAGE.SET_NAME('GR',
542: 'GR_RECORD_NOT_FOUND');
543: FND_MESSAGE.SET_TOKEN('CODE',
544: p_european_index_number||' '||TO_CHAR(p_concentration_low)||'-'||TO_CHAR(p_concentration_high),

Line 547: APP_EXCEPTION.Raise_Exception;

543: FND_MESSAGE.SET_TOKEN('CODE',
544: p_european_index_number||' '||TO_CHAR(p_concentration_low)||'-'||TO_CHAR(p_concentration_high),
545: FALSE);
546: IF FND_API.To_Boolean(p_called_by_form) THEN
547: APP_EXCEPTION.Raise_Exception;
548: ELSE
549: x_msg_data := FND_MESSAGE.Get;
550: END IF;
551:

Line 563: APP_EXCEPTION.Raise_Exception;

559: FND_MESSAGE.SET_TOKEN('TEXT',
560: l_msg_data,
561: FALSE);
562: IF FND_API.To_Boolean(p_called_by_form) THEN
563: APP_EXCEPTION.Raise_Exception;
564: ELSE
565: x_msg_data := FND_MESSAGE.Get;
566: END IF;
567:

Line 621: APP_EXCEPTION.Raise_Exception;

617: FND_MESSAGE.SET_TOKEN('TEXT',
618: l_msg_token,
619: FALSE);
620: IF FND_API.To_Boolean(p_called_by_form) THEN
621: APP_EXCEPTION.Raise_Exception;
622: ELSE
623: x_msg_data := FND_MESSAGE.Get;
624: END IF;
625:

Line 673: x_oracle_error := APP_EXCEPTION.Get_Code;

669: FETCH c_get_hazards INTO HazClassRecord;
670: IF c_get_hazards%NOTFOUND THEN
671: l_msg_token := p_hazard_classification_code;
672: x_return_status := 'E';
673: x_oracle_error := APP_EXCEPTION.Get_Code;
674: FND_MESSAGE.SET_NAME('GR',
675: 'GR_RECORD_NOT_FOUND');
676: FND_MESSAGE.SET_TOKEN('CODE',
677: l_msg_token,

Line 757: APP_EXCEPTION.Raise_Exception;

753: FND_MESSAGE.SET_TOKEN('TABLES',
754: l_msg_data,
755: FALSE);
756: IF FND_API.To_Boolean(p_called_by_form) THEN
757: APP_EXCEPTION.Raise_Exception;
758: ELSE
759: x_msg_data := FND_MESSAGE.Get;
760: END IF;
761: WHEN OTHERS THEN

Line 772: APP_EXCEPTION.Raise_Exception;

768: FND_MESSAGE.SET_TOKEN('TEXT',
769: l_msg_data,
770: FALSE);
771: IF FND_API.To_Boolean(p_called_by_form) THEN
772: APP_EXCEPTION.Raise_Exception;
773: ELSE
774: x_msg_data := FND_MESSAGE.Get;
775: END IF;
776:

Line 830: APP_EXCEPTION.Raise_Exception;

826: FND_MESSAGE.SET_TOKEN('TEXT',
827: l_msg_data,
828: FALSE);
829: IF FND_API.To_Boolean(p_called_by_form) THEN
830: APP_EXCEPTION.Raise_Exception;
831: END IF;
832:
833: END Check_Primary_Key;
834: