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

Line 120: APP_EXCEPTION.Raise_Exception;

116: FND_MESSAGE.SET_TOKEN('TEXT',
117: l_msg_data,
118: FALSE);
119: IF FND_API.To_Boolean(p_called_by_form) THEN
120: APP_EXCEPTION.Raise_Exception;
121: ELSE
122: x_msg_data := FND_MESSAGE.Get;
123: END IF;
124:

Line 129: x_oracle_error := APP_EXCEPTION.Get_Code;

125: WHEN Item_Exists_Error THEN
126: ROLLBACK TO SAVEPOINT Insert_Row;
127: l_msg_token := p_cover_letter_id;
128: x_return_status := 'E';
129: x_oracle_error := APP_EXCEPTION.Get_Code;
130: FND_MESSAGE.SET_NAME('GR',
131: 'GR_RECORD_EXISTS');
132: FND_MESSAGE.SET_TOKEN('CODE',
133: l_msg_token,

Line 136: APP_EXCEPTION.Raise_Exception;

132: FND_MESSAGE.SET_TOKEN('CODE',
133: l_msg_token,
134: FALSE);
135: IF FND_API.To_Boolean(p_called_by_form) THEN
136: APP_EXCEPTION.Raise_Exception;
137: ELSE
138: x_msg_data := FND_MESSAGE.Get;
139: END IF;
140:

Line 145: x_oracle_error := APP_EXCEPTION.Get_Code;

141: WHEN Row_Missing_Error THEN
142: ROLLBACK TO SAVEPOINT Insert_Row;
143: l_msg_token := p_cover_letter_id;
144: x_return_status := 'E';
145: x_oracle_error := APP_EXCEPTION.Get_Code;
146: FND_MESSAGE.SET_NAME('GR',
147: 'GR_NO_RECORD_INSERTED');
148: FND_MESSAGE.SET_TOKEN('CODE',
149: l_msg_token,

Line 152: APP_EXCEPTION.Raise_Exception;

148: FND_MESSAGE.SET_TOKEN('CODE',
149: l_msg_token,
150: FALSE);
151: IF FND_API.To_Boolean(p_called_by_form) THEN
152: APP_EXCEPTION.Raise_Exception;
153: ELSE
154: x_msg_data := FND_MESSAGE.Get;
155: END IF;
156:

Line 161: x_oracle_error := APP_EXCEPTION.Get_Code;

157: WHEN OTHERS THEN
158: ROLLBACK TO SAVEPOINT Insert_Row;
159: l_msg_token := p_cover_letter_id;
160: x_return_status := 'U';
161: x_oracle_error := APP_EXCEPTION.Get_Code;
162: l_msg_data := APP_EXCEPTION.Get_Text;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('TEXT',

Line 162: l_msg_data := APP_EXCEPTION.Get_Text;

158: ROLLBACK TO SAVEPOINT Insert_Row;
159: l_msg_token := p_cover_letter_id;
160: x_return_status := 'U';
161: x_oracle_error := APP_EXCEPTION.Get_Code;
162: l_msg_data := APP_EXCEPTION.Get_Text;
163: FND_MESSAGE.SET_NAME('GR',
164: 'GR_UNEXPECTED_ERROR');
165: FND_MESSAGE.SET_TOKEN('TEXT',
166: l_msg_token,

Line 169: APP_EXCEPTION.Raise_Exception;

165: FND_MESSAGE.SET_TOKEN('TEXT',
166: l_msg_token,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;
170: ELSE
171: x_msg_data := FND_MESSAGE.Get;
172: END IF;
173:

Line 261: APP_EXCEPTION.Raise_Exception;

257: FND_MESSAGE.SET_TOKEN('TEXT',
258: l_msg_data,
259: FALSE);
260: IF FND_API.To_Boolean(p_called_by_form) THEN
261: APP_EXCEPTION.Raise_Exception;
262: ELSE
263: x_msg_data := FND_MESSAGE.Get;
264: END IF;
265:

Line 269: x_oracle_error := APP_EXCEPTION.Get_Code;

265:
266: WHEN Row_Missing_Error THEN
267: ROLLBACK TO SAVEPOINT Update_Row;
268: x_return_status := 'E';
269: x_oracle_error := APP_EXCEPTION.Get_Code;
270: FND_MESSAGE.SET_NAME('GR',
271: 'GR_NO_RECORD_INSERTED');
272: FND_MESSAGE.SET_TOKEN('CODE',
273: l_msg_token,

Line 276: APP_EXCEPTION.Raise_Exception;

272: FND_MESSAGE.SET_TOKEN('CODE',
273: l_msg_token,
274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;
277: ELSE
278: x_msg_data := FND_MESSAGE.Get;
279: END IF;
280:

Line 284: x_oracle_error := APP_EXCEPTION.Get_Code;

280:
281: WHEN OTHERS THEN
282: ROLLBACK TO SAVEPOINT Update_Row;
283: x_return_status := 'U';
284: x_oracle_error := APP_EXCEPTION.Get_Code;
285: l_msg_data := APP_EXCEPTION.Get_Text;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_UNEXPECTED_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',

Line 285: l_msg_data := APP_EXCEPTION.Get_Text;

281: WHEN OTHERS THEN
282: ROLLBACK TO SAVEPOINT Update_Row;
283: x_return_status := 'U';
284: x_oracle_error := APP_EXCEPTION.Get_Code;
285: l_msg_data := APP_EXCEPTION.Get_Text;
286: FND_MESSAGE.SET_NAME('GR',
287: 'GR_UNEXPECTED_ERROR');
288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_token,

Line 292: APP_EXCEPTION.Raise_Exception;

288: FND_MESSAGE.SET_TOKEN('TEXT',
289: l_msg_token,
290: FALSE);
291: IF FND_API.To_Boolean(p_called_by_form) THEN
292: APP_EXCEPTION.Raise_Exception;
293: ELSE
294: x_msg_data := FND_MESSAGE.Get;
295: END IF;
296:

Line 380: APP_EXCEPTION.Raise_Exception;

376: FND_MESSAGE.SET_TOKEN('CODE',
377: l_msg_token,
378: FALSE);
379: IF FND_API.To_Boolean(p_called_by_form) THEN
380: APP_EXCEPTION.Raise_Exception;
381: ELSE
382: x_msg_data := FND_MESSAGE.Get;
383: END IF;
384:

Line 388: x_oracle_error := APP_EXCEPTION.Get_Code;

384:
385: WHEN Row_Already_Locked_Error THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;
387: x_return_status := 'E';
388: x_oracle_error := APP_EXCEPTION.Get_Code;
389: FND_MESSAGE.SET_NAME('GR',
390: 'GR_ROW_IS_LOCKED');
391: IF FND_API.To_Boolean(p_called_by_form) THEN
392: APP_EXCEPTION.Raise_Exception;

Line 392: APP_EXCEPTION.Raise_Exception;

388: x_oracle_error := APP_EXCEPTION.Get_Code;
389: FND_MESSAGE.SET_NAME('GR',
390: 'GR_ROW_IS_LOCKED');
391: IF FND_API.To_Boolean(p_called_by_form) THEN
392: APP_EXCEPTION.Raise_Exception;
393: ELSE
394: x_msg_data := FND_MESSAGE.Get;
395: END IF;
396:

Line 400: x_oracle_error := APP_EXCEPTION.Get_Code;

396:
397: WHEN OTHERS THEN
398: ROLLBACK TO SAVEPOINT Lock_Row;
399: x_return_status := 'U';
400: x_oracle_error := APP_EXCEPTION.Get_Code;
401: l_msg_data := APP_EXCEPTION.Get_Text;
402: FND_MESSAGE.SET_NAME('GR',
403: 'GR_UNEXPECTED_ERROR');
404: FND_MESSAGE.SET_TOKEN('TEXT',

Line 401: l_msg_data := APP_EXCEPTION.Get_Text;

397: WHEN OTHERS THEN
398: ROLLBACK TO SAVEPOINT Lock_Row;
399: x_return_status := 'U';
400: x_oracle_error := APP_EXCEPTION.Get_Code;
401: l_msg_data := APP_EXCEPTION.Get_Text;
402: FND_MESSAGE.SET_NAME('GR',
403: 'GR_UNEXPECTED_ERROR');
404: FND_MESSAGE.SET_TOKEN('TEXT',
405: l_msg_token,

Line 408: APP_EXCEPTION.Raise_Exception;

404: FND_MESSAGE.SET_TOKEN('TEXT',
405: l_msg_token,
406: FALSE);
407: IF FND_API.To_Boolean(p_called_by_form) THEN
408: APP_EXCEPTION.Raise_Exception;
409: ELSE
410: x_msg_data := FND_MESSAGE.Get;
411: END IF;
412:

Line 491: APP_EXCEPTION.Raise_Exception;

487: ROLLBACK TO SAVEPOINT Delete_Row;
488: x_return_status := l_return_status;
489: x_oracle_error := l_oracle_error;
490: IF FND_API.To_Boolean(p_called_by_form) THEN
491: APP_EXCEPTION.Raise_Exception;
492: ELSE
493: x_msg_data := FND_MESSAGE.Get;
494: END IF;
495:

Line 499: x_oracle_error := APP_EXCEPTION.Get_Code;

495:
496: WHEN Row_Missing_Error THEN
497: ROLLBACK TO SAVEPOINT Delete_Row;
498: x_return_status := 'E';
499: x_oracle_error := APP_EXCEPTION.Get_Code;
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_RECORD_NOT_FOUND');
502: FND_MESSAGE.SET_TOKEN('CODE',
503: l_msg_token,

Line 506: APP_EXCEPTION.Raise_Exception;

502: FND_MESSAGE.SET_TOKEN('CODE',
503: l_msg_token,
504: FALSE);
505: IF FND_API.To_Boolean(p_called_by_form) THEN
506: APP_EXCEPTION.Raise_Exception;
507: ELSE
508: x_msg_data := FND_MESSAGE.Get;
509: END IF;
510:

Line 514: x_oracle_error := APP_EXCEPTION.Get_Code;

510:
511: WHEN OTHERS THEN
512: ROLLBACK TO SAVEPOINT Delete_Row;
513: x_return_status := 'U';
514: x_oracle_error := APP_EXCEPTION.Get_Code;
515: l_msg_data := APP_EXCEPTION.Get_Text;
516: FND_MESSAGE.SET_NAME('GR',
517: 'GR_UNEXPECTED_ERROR');
518: FND_MESSAGE.SET_TOKEN('TEXT',

Line 515: l_msg_data := APP_EXCEPTION.Get_Text;

511: WHEN OTHERS THEN
512: ROLLBACK TO SAVEPOINT Delete_Row;
513: x_return_status := 'U';
514: x_oracle_error := APP_EXCEPTION.Get_Code;
515: l_msg_data := APP_EXCEPTION.Get_Text;
516: FND_MESSAGE.SET_NAME('GR',
517: 'GR_UNEXPECTED_ERROR');
518: FND_MESSAGE.SET_TOKEN('TEXT',
519: l_msg_data,

Line 522: APP_EXCEPTION.Raise_Exception;

518: FND_MESSAGE.SET_TOKEN('TEXT',
519: l_msg_data,
520: FALSE);
521: IF FND_API.To_Boolean(p_called_by_form) THEN
522: APP_EXCEPTION.Raise_Exception;
523: ELSE
524: x_msg_data := FND_MESSAGE.Get;
525: END IF;
526:

Line 587: x_oracle_error := APP_EXCEPTION.Get_Code;

583:
584: WHEN Row_Missing_Error THEN
585: ROLLBACK TO SAVEPOINT Delete_Row;
586: x_return_status := 'E';
587: x_oracle_error := APP_EXCEPTION.Get_Code;
588: FND_MESSAGE.SET_NAME('GR',
589: 'GR_RECORD_NOT_FOUND');
590: FND_MESSAGE.SET_TOKEN('CODE',
591: p_orgn_code,

Line 598: x_oracle_error := APP_EXCEPTION.Get_Code;

594:
595: WHEN OTHERS THEN
596: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
597: x_return_status := 'U';
598: x_oracle_error := APP_EXCEPTION.Get_Code;
599: l_msg_data := APP_EXCEPTION.Get_Text;
600: FND_MESSAGE.SET_NAME('GR',
601: 'GR_UNEXPECTED_ERROR');
602: FND_MESSAGE.SET_TOKEN('TEXT',

Line 599: l_msg_data := APP_EXCEPTION.Get_Text;

595: WHEN OTHERS THEN
596: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
597: x_return_status := 'U';
598: x_oracle_error := APP_EXCEPTION.Get_Code;
599: l_msg_data := APP_EXCEPTION.Get_Text;
600: FND_MESSAGE.SET_NAME('GR',
601: 'GR_UNEXPECTED_ERROR');
602: FND_MESSAGE.SET_TOKEN('TEXT',
603: l_msg_token,

Line 673: APP_EXCEPTION.Raise_Exception;

669: FND_MESSAGE.SET_TOKEN('TABLES',
670: l_msg_data,
671: FALSE);
672: IF FND_API.To_Boolean(p_called_by_form) THEN
673: APP_EXCEPTION.Raise_Exception;
674: ELSE
675: x_msg_data := FND_MESSAGE.Get;
676: END IF;
677: WHEN OTHERS THEN

Line 680: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 681: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 688: APP_EXCEPTION.Raise_Exception;

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

Line 738: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 745: APP_EXCEPTION.Raise_Exception;

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