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_SAFETY_CATEGORIES_B_PKG dependencies on APP_EXCEPTION

Line 116: APP_EXCEPTION.Raise_Exception;

112: FND_MESSAGE.SET_TOKEN('TEXT',
113: l_msg_data,
114: FALSE);
115: IF FND_API.To_Boolean(p_called_by_form) THEN
116: APP_EXCEPTION.Raise_Exception;
117: ELSE
118: x_msg_data := FND_MESSAGE.Get;
119: END IF;
120:

Line 125: x_oracle_error := APP_EXCEPTION.Get_Code;

121: WHEN Item_Exists_Error THEN
122: ROLLBACK TO SAVEPOINT Insert_Row;
123: l_msg_token := p_safety_category_code;
124: x_return_status := 'E';
125: x_oracle_error := APP_EXCEPTION.Get_Code;
126: FND_MESSAGE.SET_NAME('GR',
127: 'GR_RECORD_EXISTS');
128: FND_MESSAGE.SET_TOKEN('CODE',
129: l_msg_token,

Line 132: APP_EXCEPTION.Raise_Exception;

128: FND_MESSAGE.SET_TOKEN('CODE',
129: l_msg_token,
130: FALSE);
131: IF FND_API.To_Boolean(p_called_by_form) THEN
132: APP_EXCEPTION.Raise_Exception;
133: ELSE
134: x_msg_data := FND_MESSAGE.Get;
135: END IF;
136:

Line 141: x_oracle_error := APP_EXCEPTION.Get_Code;

137: WHEN Row_Missing_Error THEN
138: ROLLBACK TO SAVEPOINT Insert_Row;
139: l_msg_token := p_safety_category_code;
140: x_return_status := 'E';
141: x_oracle_error := APP_EXCEPTION.Get_Code;
142: FND_MESSAGE.SET_NAME('GR',
143: 'GR_NO_RECORD_INSERTED');
144: FND_MESSAGE.SET_TOKEN('CODE',
145: l_msg_token,

Line 148: APP_EXCEPTION.Raise_Exception;

144: FND_MESSAGE.SET_TOKEN('CODE',
145: l_msg_token,
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 157: x_oracle_error := APP_EXCEPTION.Get_Code;

153: WHEN OTHERS THEN
154: ROLLBACK TO SAVEPOINT Insert_Row;
155: l_msg_token := p_safety_category_code;
156: x_return_status := 'U';
157: x_oracle_error := APP_EXCEPTION.Get_Code;
158: l_msg_data := APP_EXCEPTION.Get_Text;
159: FND_MESSAGE.SET_NAME('GR',
160: 'GR_UNEXPECTED_ERROR');
161: FND_MESSAGE.SET_TOKEN('TEXT',

Line 158: l_msg_data := APP_EXCEPTION.Get_Text;

154: ROLLBACK TO SAVEPOINT Insert_Row;
155: l_msg_token := p_safety_category_code;
156: x_return_status := 'U';
157: x_oracle_error := APP_EXCEPTION.Get_Code;
158: l_msg_data := APP_EXCEPTION.Get_Text;
159: FND_MESSAGE.SET_NAME('GR',
160: 'GR_UNEXPECTED_ERROR');
161: FND_MESSAGE.SET_TOKEN('TEXT',
162: l_msg_token,

Line 165: APP_EXCEPTION.Raise_Exception;

161: FND_MESSAGE.SET_TOKEN('TEXT',
162: l_msg_token,
163: FALSE);
164: IF FND_API.To_Boolean(p_called_by_form) THEN
165: APP_EXCEPTION.Raise_Exception;
166: ELSE
167: x_msg_data := FND_MESSAGE.Get;
168: END IF;
169:

Line 254: APP_EXCEPTION.Raise_Exception;

250: FND_MESSAGE.SET_TOKEN('TEXT',
251: l_msg_data,
252: FALSE);
253: IF FND_API.To_Boolean(p_called_by_form) THEN
254: APP_EXCEPTION.Raise_Exception;
255: ELSE
256: x_msg_data := FND_MESSAGE.Get;
257: END IF;
258:

Line 262: x_oracle_error := APP_EXCEPTION.Get_Code;

258:
259: WHEN Row_Missing_Error THEN
260: ROLLBACK TO SAVEPOINT Update_Row;
261: x_return_status := 'E';
262: x_oracle_error := APP_EXCEPTION.Get_Code;
263: FND_MESSAGE.SET_NAME('GR',
264: 'GR_NO_RECORD_INSERTED');
265: FND_MESSAGE.SET_TOKEN('CODE',
266: l_msg_token,

Line 269: APP_EXCEPTION.Raise_Exception;

265: FND_MESSAGE.SET_TOKEN('CODE',
266: l_msg_token,
267: FALSE);
268: IF FND_API.To_Boolean(p_called_by_form) THEN
269: APP_EXCEPTION.Raise_Exception;
270: ELSE
271: x_msg_data := FND_MESSAGE.Get;
272: END IF;
273:

Line 277: x_oracle_error := APP_EXCEPTION.Get_Code;

273:
274: WHEN OTHERS THEN
275: ROLLBACK TO SAVEPOINT Update_Row;
276: x_return_status := 'U';
277: x_oracle_error := APP_EXCEPTION.Get_Code;
278: l_msg_data := APP_EXCEPTION.Get_Text;
279: FND_MESSAGE.SET_NAME('GR',
280: 'GR_UNEXPECTED_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',

Line 278: l_msg_data := APP_EXCEPTION.Get_Text;

274: WHEN OTHERS THEN
275: ROLLBACK TO SAVEPOINT Update_Row;
276: x_return_status := 'U';
277: x_oracle_error := APP_EXCEPTION.Get_Code;
278: l_msg_data := APP_EXCEPTION.Get_Text;
279: FND_MESSAGE.SET_NAME('GR',
280: 'GR_UNEXPECTED_ERROR');
281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_token,

Line 285: APP_EXCEPTION.Raise_Exception;

281: FND_MESSAGE.SET_TOKEN('TEXT',
282: l_msg_token,
283: FALSE);
284: IF FND_API.To_Boolean(p_called_by_form) THEN
285: APP_EXCEPTION.Raise_Exception;
286: ELSE
287: x_msg_data := FND_MESSAGE.Get;
288: END IF;
289:

Line 372: APP_EXCEPTION.Raise_Exception;

368: FND_MESSAGE.SET_TOKEN('CODE',
369: l_msg_token,
370: FALSE);
371: IF FND_API.To_Boolean(p_called_by_form) THEN
372: APP_EXCEPTION.Raise_Exception;
373: ELSE
374: x_msg_data := FND_MESSAGE.Get;
375: END IF;
376:

Line 380: x_oracle_error := APP_EXCEPTION.Get_Code;

376:
377: WHEN Row_Already_Locked_Error THEN
378: ROLLBACK TO SAVEPOINT Lock_Row;
379: x_return_status := 'E';
380: x_oracle_error := APP_EXCEPTION.Get_Code;
381: FND_MESSAGE.SET_NAME('GR',
382: 'GR_ROW_IS_LOCKED');
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;

Line 384: APP_EXCEPTION.Raise_Exception;

380: x_oracle_error := APP_EXCEPTION.Get_Code;
381: FND_MESSAGE.SET_NAME('GR',
382: 'GR_ROW_IS_LOCKED');
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;
385: ELSE
386: x_msg_data := FND_MESSAGE.Get;
387: END IF;
388:

Line 392: x_oracle_error := APP_EXCEPTION.Get_Code;

388:
389: WHEN OTHERS THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'U';
392: x_oracle_error := APP_EXCEPTION.Get_Code;
393: l_msg_data := APP_EXCEPTION.Get_Text;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_UNEXPECTED_ERROR');
396: FND_MESSAGE.SET_TOKEN('TEXT',

Line 393: l_msg_data := APP_EXCEPTION.Get_Text;

389: WHEN OTHERS THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;
391: x_return_status := 'U';
392: x_oracle_error := APP_EXCEPTION.Get_Code;
393: l_msg_data := APP_EXCEPTION.Get_Text;
394: FND_MESSAGE.SET_NAME('GR',
395: 'GR_UNEXPECTED_ERROR');
396: FND_MESSAGE.SET_TOKEN('TEXT',
397: l_msg_token,

Line 400: APP_EXCEPTION.Raise_Exception;

396: FND_MESSAGE.SET_TOKEN('TEXT',
397: l_msg_token,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;
401: ELSE
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;
404:

Line 481: APP_EXCEPTION.Raise_Exception;

477: ROLLBACK TO SAVEPOINT Delete_Row;
478: x_return_status := l_return_status;
479: x_oracle_error := l_oracle_error;
480: IF FND_API.To_Boolean(p_called_by_form) THEN
481: APP_EXCEPTION.Raise_Exception;
482: ELSE
483: x_msg_data := FND_MESSAGE.Get;
484: END IF;
485:

Line 489: x_oracle_error := APP_EXCEPTION.Get_Code;

485:
486: WHEN Row_Missing_Error THEN
487: ROLLBACK TO SAVEPOINT Delete_Row;
488: x_return_status := 'E';
489: x_oracle_error := APP_EXCEPTION.Get_Code;
490: FND_MESSAGE.SET_NAME('GR',
491: 'GR_RECORD_NOT_FOUND');
492: FND_MESSAGE.SET_TOKEN('CODE',
493: l_msg_token,

Line 496: APP_EXCEPTION.Raise_Exception;

492: FND_MESSAGE.SET_TOKEN('CODE',
493: l_msg_token,
494: FALSE);
495: IF FND_API.To_Boolean(p_called_by_form) THEN
496: APP_EXCEPTION.Raise_Exception;
497: ELSE
498: x_msg_data := FND_MESSAGE.Get;
499: END IF;
500:

Line 504: x_oracle_error := APP_EXCEPTION.Get_Code;

500:
501: WHEN OTHERS THEN
502: ROLLBACK TO SAVEPOINT Delete_Row;
503: x_return_status := 'U';
504: x_oracle_error := APP_EXCEPTION.Get_Code;
505: l_msg_data := APP_EXCEPTION.Get_Text;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_UNEXPECTED_ERROR');
508: FND_MESSAGE.SET_TOKEN('TEXT',

Line 505: l_msg_data := APP_EXCEPTION.Get_Text;

501: WHEN OTHERS THEN
502: ROLLBACK TO SAVEPOINT Delete_Row;
503: x_return_status := 'U';
504: x_oracle_error := APP_EXCEPTION.Get_Code;
505: l_msg_data := APP_EXCEPTION.Get_Text;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_UNEXPECTED_ERROR');
508: FND_MESSAGE.SET_TOKEN('TEXT',
509: l_msg_data,

Line 512: APP_EXCEPTION.Raise_Exception;

508: FND_MESSAGE.SET_TOKEN('TEXT',
509: l_msg_data,
510: FALSE);
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;
513: ELSE
514: x_msg_data := FND_MESSAGE.Get;
515: END IF;
516:

Line 563: x_oracle_error := APP_EXCEPTION.Get_Code;

559:
560: WHEN Row_Missing_Error THEN
561: ROLLBACK TO SAVEPOINT Delete_Row;
562: x_return_status := 'E';
563: x_oracle_error := APP_EXCEPTION.Get_Code;
564: FND_MESSAGE.SET_NAME('GR',
565: 'GR_RECORD_NOT_FOUND');
566: FND_MESSAGE.SET_TOKEN('CODE',
567: p_safety_category_code,

Line 574: x_oracle_error := APP_EXCEPTION.Get_Code;

570:
571: WHEN OTHERS THEN
572: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
573: x_return_status := 'U';
574: x_oracle_error := APP_EXCEPTION.Get_Code;
575: l_msg_data := APP_EXCEPTION.Get_Text;
576: FND_MESSAGE.SET_NAME('GR',
577: 'GR_UNEXPECTED_ERROR');
578: FND_MESSAGE.SET_TOKEN('TEXT',

Line 575: l_msg_data := APP_EXCEPTION.Get_Text;

571: WHEN OTHERS THEN
572: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
573: x_return_status := 'U';
574: x_oracle_error := APP_EXCEPTION.Get_Code;
575: l_msg_data := APP_EXCEPTION.Get_Text;
576: FND_MESSAGE.SET_NAME('GR',
577: 'GR_UNEXPECTED_ERROR');
578: FND_MESSAGE.SET_TOKEN('TEXT',
579: l_msg_token,

Line 676: APP_EXCEPTION.Raise_Exception;

672: FND_MESSAGE.SET_TOKEN('TABLES',
673: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
674: FALSE);
675: IF FND_API.To_Boolean(p_called_by_form) THEN
676: APP_EXCEPTION.Raise_Exception;
677: ELSE
678: x_msg_data := FND_MESSAGE.Get;
679: END IF;
680: WHEN OTHERS THEN

Line 683: x_oracle_error := APP_EXCEPTION.Get_Code;

679: END IF;
680: WHEN OTHERS THEN
681: ROLLBACK TO SAVEPOINT Check_Integrity;
682: x_return_status := 'U';
683: x_oracle_error := APP_EXCEPTION.Get_Code;
684: l_msg_data := APP_EXCEPTION.Get_Text;
685: FND_MESSAGE.SET_NAME('GR',
686: 'GR_UNEXPECTED_ERROR');
687: FND_MESSAGE.SET_TOKEN('TEXT',

Line 684: l_msg_data := APP_EXCEPTION.Get_Text;

680: WHEN OTHERS THEN
681: ROLLBACK TO SAVEPOINT Check_Integrity;
682: x_return_status := 'U';
683: x_oracle_error := APP_EXCEPTION.Get_Code;
684: l_msg_data := APP_EXCEPTION.Get_Text;
685: FND_MESSAGE.SET_NAME('GR',
686: 'GR_UNEXPECTED_ERROR');
687: FND_MESSAGE.SET_TOKEN('TEXT',
688: l_msg_data,

Line 691: APP_EXCEPTION.Raise_Exception;

687: FND_MESSAGE.SET_TOKEN('TEXT',
688: l_msg_data,
689: FALSE);
690: IF FND_API.To_Boolean(p_called_by_form) THEN
691: APP_EXCEPTION.Raise_Exception;
692: ELSE
693: x_msg_data := FND_MESSAGE.Get;
694: END IF;
695:

Line 741: l_msg_data := APP_EXCEPTION.Get_Text;

737:
738: EXCEPTION
739:
740: WHEN Others THEN
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,

Line 748: APP_EXCEPTION.Raise_Exception;

744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;
749: END IF;
750:
751: END Check_Primary_Key;
752: