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 FND_MESSAGE

Line 114: FND_MESSAGE.SET_NAME('GR',

110: WHEN Foreign_Key_Error THEN
111: ROLLBACK TO SAVEPOINT Insert_Row;
112: x_return_status := l_return_status;
113: x_oracle_error := l_oracle_error;
114: FND_MESSAGE.SET_NAME('GR',
115: 'GR_FOREIGN_KEY_ERROR');
116: FND_MESSAGE.SET_TOKEN('TEXT',
117: l_msg_data,
118: FALSE);

Line 116: FND_MESSAGE.SET_TOKEN('TEXT',

112: x_return_status := l_return_status;
113: x_oracle_error := l_oracle_error;
114: FND_MESSAGE.SET_NAME('GR',
115: 'GR_FOREIGN_KEY_ERROR');
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;

Line 122: x_msg_data := FND_MESSAGE.Get;

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:
125: WHEN Item_Exists_Error THEN
126: ROLLBACK TO SAVEPOINT Insert_Row;

Line 130: FND_MESSAGE.SET_NAME('GR',

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,
134: FALSE);

Line 132: FND_MESSAGE.SET_TOKEN('CODE',

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,
134: FALSE);
135: IF FND_API.To_Boolean(p_called_by_form) THEN
136: APP_EXCEPTION.Raise_Exception;

Line 138: x_msg_data := FND_MESSAGE.Get;

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:
141: WHEN Row_Missing_Error THEN
142: ROLLBACK TO SAVEPOINT Insert_Row;

Line 146: FND_MESSAGE.SET_NAME('GR',

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,
150: FALSE);

Line 148: FND_MESSAGE.SET_TOKEN('CODE',

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,
150: FALSE);
151: IF FND_API.To_Boolean(p_called_by_form) THEN
152: APP_EXCEPTION.Raise_Exception;

Line 154: x_msg_data := FND_MESSAGE.Get;

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:
157: WHEN OTHERS THEN
158: ROLLBACK TO SAVEPOINT Insert_Row;

Line 163: FND_MESSAGE.SET_NAME('GR',

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,
167: FALSE);

Line 165: FND_MESSAGE.SET_TOKEN('TEXT',

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,
167: FALSE);
168: IF FND_API.To_Boolean(p_called_by_form) THEN
169: APP_EXCEPTION.Raise_Exception;

Line 171: x_msg_data := FND_MESSAGE.Get;

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:
174: END Insert_Row;
175:

Line 255: FND_MESSAGE.SET_NAME('GR',

251: WHEN Foreign_Key_Error THEN
252: ROLLBACK TO SAVEPOINT Update_Row;
253: x_return_status := l_return_status;
254: x_oracle_error := l_oracle_error;
255: FND_MESSAGE.SET_NAME('GR',
256: 'GR_FOREIGN_KEY_ERROR');
257: FND_MESSAGE.SET_TOKEN('TEXT',
258: l_msg_data,
259: FALSE);

Line 257: FND_MESSAGE.SET_TOKEN('TEXT',

253: x_return_status := l_return_status;
254: x_oracle_error := l_oracle_error;
255: FND_MESSAGE.SET_NAME('GR',
256: 'GR_FOREIGN_KEY_ERROR');
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;

Line 263: x_msg_data := FND_MESSAGE.Get;

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:
266: WHEN Row_Missing_Error THEN
267: ROLLBACK TO SAVEPOINT Update_Row;

Line 270: FND_MESSAGE.SET_NAME('GR',

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,
274: FALSE);

Line 272: FND_MESSAGE.SET_TOKEN('CODE',

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,
274: FALSE);
275: IF FND_API.To_Boolean(p_called_by_form) THEN
276: APP_EXCEPTION.Raise_Exception;

Line 278: x_msg_data := FND_MESSAGE.Get;

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:
281: WHEN OTHERS THEN
282: ROLLBACK TO SAVEPOINT Update_Row;

Line 286: FND_MESSAGE.SET_NAME('GR',

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,
290: FALSE);

Line 288: FND_MESSAGE.SET_TOKEN('TEXT',

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,
290: FALSE);
291: IF FND_API.To_Boolean(p_called_by_form) THEN
292: APP_EXCEPTION.Raise_Exception;

Line 294: x_msg_data := FND_MESSAGE.Get;

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:
297: END Update_Row;
298: /*

Line 374: FND_MESSAGE.SET_NAME('GR',

370:
371: WHEN No_Data_Found_Error THEN
372: ROLLBACK TO SAVEPOINT Lock_Row;
373: x_return_status := 'E';
374: FND_MESSAGE.SET_NAME('GR',
375: 'GR_RECORD_NOT_FOUND');
376: FND_MESSAGE.SET_TOKEN('CODE',
377: l_msg_token,
378: FALSE);

Line 376: FND_MESSAGE.SET_TOKEN('CODE',

372: ROLLBACK TO SAVEPOINT Lock_Row;
373: x_return_status := 'E';
374: FND_MESSAGE.SET_NAME('GR',
375: 'GR_RECORD_NOT_FOUND');
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;

Line 382: x_msg_data := FND_MESSAGE.Get;

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:
385: WHEN Row_Already_Locked_Error THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;

Line 389: FND_MESSAGE.SET_NAME('GR',

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;
393: ELSE

Line 394: x_msg_data := FND_MESSAGE.Get;

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:
397: WHEN OTHERS THEN
398: ROLLBACK TO SAVEPOINT Lock_Row;

Line 402: FND_MESSAGE.SET_NAME('GR',

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,
406: FALSE);

Line 404: FND_MESSAGE.SET_TOKEN('TEXT',

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,
406: FALSE);
407: IF FND_API.To_Boolean(p_called_by_form) THEN
408: APP_EXCEPTION.Raise_Exception;

Line 410: x_msg_data := FND_MESSAGE.Get;

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:
413: END Lock_Row;
414:

Line 493: x_msg_data := FND_MESSAGE.Get;

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:
496: WHEN Row_Missing_Error THEN
497: ROLLBACK TO SAVEPOINT Delete_Row;

Line 500: FND_MESSAGE.SET_NAME('GR',

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,
504: FALSE);

Line 502: FND_MESSAGE.SET_TOKEN('CODE',

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,
504: FALSE);
505: IF FND_API.To_Boolean(p_called_by_form) THEN
506: APP_EXCEPTION.Raise_Exception;

Line 508: x_msg_data := FND_MESSAGE.Get;

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:
511: WHEN OTHERS THEN
512: ROLLBACK TO SAVEPOINT Delete_Row;

Line 516: FND_MESSAGE.SET_NAME('GR',

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,
520: FALSE);

Line 518: FND_MESSAGE.SET_TOKEN('TEXT',

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,
520: FALSE);
521: IF FND_API.To_Boolean(p_called_by_form) THEN
522: APP_EXCEPTION.Raise_Exception;

Line 524: x_msg_data := FND_MESSAGE.Get;

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:
527: END Delete_Row;
528:

Line 588: FND_MESSAGE.SET_NAME('GR',

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,
592: FALSE);

Line 590: FND_MESSAGE.SET_TOKEN('CODE',

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,
592: FALSE);
593: x_msg_data := FND_MESSAGE.Get;
594:

Line 593: x_msg_data := FND_MESSAGE.Get;

589: 'GR_RECORD_NOT_FOUND');
590: FND_MESSAGE.SET_TOKEN('CODE',
591: p_orgn_code,
592: FALSE);
593: x_msg_data := FND_MESSAGE.Get;
594:
595: WHEN OTHERS THEN
596: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
597: x_return_status := 'U';

Line 600: FND_MESSAGE.SET_NAME('GR',

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,
604: FALSE);

Line 602: FND_MESSAGE.SET_TOKEN('TEXT',

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,
604: FALSE);
605: x_msg_data := FND_MESSAGE.Get;
606:

Line 605: x_msg_data := FND_MESSAGE.Get;

601: 'GR_UNEXPECTED_ERROR');
602: FND_MESSAGE.SET_TOKEN('TEXT',
603: l_msg_token,
604: FALSE);
605: x_msg_data := FND_MESSAGE.Get;
606:
607: END Check_Foreign_Keys;
608:
609: PROCEDURE Check_Integrity

Line 664: FND_MESSAGE.SET_NAME('GR',

660: END IF;
661: EXCEPTION
662: WHEN INTEGRITY_ERROR THEN
663: x_return_status := 'E';
664: FND_MESSAGE.SET_NAME('GR',
665: 'GR_INTEGRITY_HEADER');
666: FND_MESSAGE.SET_TOKEN('CODE',
667: p_orgn_code,
668: FALSE);

Line 666: FND_MESSAGE.SET_TOKEN('CODE',

662: WHEN INTEGRITY_ERROR THEN
663: x_return_status := 'E';
664: FND_MESSAGE.SET_NAME('GR',
665: 'GR_INTEGRITY_HEADER');
666: FND_MESSAGE.SET_TOKEN('CODE',
667: p_orgn_code,
668: FALSE);
669: FND_MESSAGE.SET_TOKEN('TABLES',
670: l_msg_data,

Line 669: FND_MESSAGE.SET_TOKEN('TABLES',

665: 'GR_INTEGRITY_HEADER');
666: FND_MESSAGE.SET_TOKEN('CODE',
667: p_orgn_code,
668: FALSE);
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;

Line 675: x_msg_data := FND_MESSAGE.Get;

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
678: ROLLBACK TO SAVEPOINT Check_Integrity;
679: x_return_status := 'U';

Line 682: FND_MESSAGE.SET_NAME('GR',

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,
686: FALSE);

Line 684: FND_MESSAGE.SET_TOKEN('TEXT',

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,
686: FALSE);
687: IF FND_API.To_Boolean(p_called_by_form) THEN
688: APP_EXCEPTION.Raise_Exception;

Line 690: x_msg_data := FND_MESSAGE.Get;

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:
693: END Check_Integrity;
694:

Line 739: FND_MESSAGE.SET_NAME('GR',

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,
743: FALSE);

Line 741: FND_MESSAGE.SET_TOKEN('TEXT',

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,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;