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_EXPOSURE_TYPES_B_PKG dependencies on FND_MESSAGE

Line 111: FND_MESSAGE.SET_NAME('GR',

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

Line 113: FND_MESSAGE.SET_TOKEN('TEXT',

109: x_return_status := l_return_status;
110: x_oracle_error := l_oracle_error;
111: FND_MESSAGE.SET_NAME('GR',
112: 'GR_FOREIGN_KEY_ERROR');
113: FND_MESSAGE.SET_TOKEN('TEXT',
114: l_msg_data,
115: FALSE);
116: IF FND_API.To_Boolean(p_called_by_form) THEN
117: APP_EXCEPTION.Raise_Exception;

Line 119: x_msg_data := FND_MESSAGE.Get;

115: FALSE);
116: IF FND_API.To_Boolean(p_called_by_form) THEN
117: APP_EXCEPTION.Raise_Exception;
118: ELSE
119: x_msg_data := FND_MESSAGE.Get;
120: END IF;
121:
122: WHEN Item_Exists_Error THEN
123: ROLLBACK TO SAVEPOINT Insert_Row;

Line 126: FND_MESSAGE.SET_NAME('GR',

122: WHEN Item_Exists_Error THEN
123: ROLLBACK TO SAVEPOINT Insert_Row;
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: p_exposure_type_code,
130: FALSE);

Line 128: FND_MESSAGE.SET_TOKEN('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: p_exposure_type_code,
130: FALSE);
131: IF FND_API.To_Boolean(p_called_by_form) THEN
132: APP_EXCEPTION.Raise_Exception;

Line 134: x_msg_data := FND_MESSAGE.Get;

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

Line 141: FND_MESSAGE.SET_NAME('GR',

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

Line 143: FND_MESSAGE.SET_TOKEN('CODE',

139: x_return_status := 'E';
140: x_oracle_error := APP_EXCEPTION.Get_Code;
141: FND_MESSAGE.SET_NAME('GR',
142: 'GR_NO_RECORD_INSERTED');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: p_exposure_type_code,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;

Line 149: x_msg_data := FND_MESSAGE.Get;

145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;
148: ELSE
149: x_msg_data := FND_MESSAGE.Get;
150: END IF;
151:
152: WHEN OTHERS THEN
153: ROLLBACK TO SAVEPOINT Insert_Row;

Line 157: FND_MESSAGE.SET_NAME('GR',

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

Line 159: FND_MESSAGE.SET_TOKEN('TEXT',

155: x_oracle_error := APP_EXCEPTION.Get_Code;
156: l_msg_data := APP_EXCEPTION.Get_Text;
157: FND_MESSAGE.SET_NAME('GR',
158: 'GR_UNEXPECTED_ERROR');
159: FND_MESSAGE.SET_TOKEN('TEXT',
160: l_msg_data,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;

Line 165: x_msg_data := FND_MESSAGE.Get;

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:
168: END Insert_Row;
169:

Line 244: FND_MESSAGE.SET_NAME('GR',

240: WHEN Foreign_Key_Error THEN
241: ROLLBACK TO SAVEPOINT Update_Row;
242: x_return_status := l_return_status;
243: x_oracle_error := l_oracle_error;
244: FND_MESSAGE.SET_NAME('GR',
245: 'GR_FOREIGN_KEY_ERROR');
246: FND_MESSAGE.SET_TOKEN('TEXT',
247: l_msg_data,
248: FALSE);

Line 246: FND_MESSAGE.SET_TOKEN('TEXT',

242: x_return_status := l_return_status;
243: x_oracle_error := l_oracle_error;
244: FND_MESSAGE.SET_NAME('GR',
245: 'GR_FOREIGN_KEY_ERROR');
246: FND_MESSAGE.SET_TOKEN('TEXT',
247: l_msg_data,
248: FALSE);
249: IF FND_API.To_Boolean(p_called_by_form) THEN
250: APP_EXCEPTION.Raise_Exception;

Line 252: x_msg_data := FND_MESSAGE.Get;

248: FALSE);
249: IF FND_API.To_Boolean(p_called_by_form) THEN
250: APP_EXCEPTION.Raise_Exception;
251: ELSE
252: x_msg_data := FND_MESSAGE.Get;
253: END IF;
254:
255: WHEN Row_Missing_Error THEN
256: ROLLBACK TO SAVEPOINT Update_Row;

Line 259: FND_MESSAGE.SET_NAME('GR',

255: WHEN Row_Missing_Error THEN
256: ROLLBACK TO SAVEPOINT Update_Row;
257: x_return_status := 'E';
258: x_oracle_error := APP_EXCEPTION.Get_Code;
259: FND_MESSAGE.SET_NAME('GR',
260: 'GR_NO_RECORD_INSERTED');
261: FND_MESSAGE.SET_TOKEN('CODE',
262: p_exposure_type_code,
263: FALSE);

Line 261: FND_MESSAGE.SET_TOKEN('CODE',

257: x_return_status := 'E';
258: x_oracle_error := APP_EXCEPTION.Get_Code;
259: FND_MESSAGE.SET_NAME('GR',
260: 'GR_NO_RECORD_INSERTED');
261: FND_MESSAGE.SET_TOKEN('CODE',
262: p_exposure_type_code,
263: FALSE);
264: IF FND_API.To_Boolean(p_called_by_form) THEN
265: APP_EXCEPTION.Raise_Exception;

Line 267: x_msg_data := FND_MESSAGE.Get;

263: FALSE);
264: IF FND_API.To_Boolean(p_called_by_form) THEN
265: APP_EXCEPTION.Raise_Exception;
266: ELSE
267: x_msg_data := FND_MESSAGE.Get;
268: END IF;
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO SAVEPOINT Update_Row;

Line 275: FND_MESSAGE.SET_NAME('GR',

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

Line 277: FND_MESSAGE.SET_TOKEN('TEXT',

273: x_oracle_error := APP_EXCEPTION.Get_Code;
274: l_msg_data := APP_EXCEPTION.Get_Text;
275: FND_MESSAGE.SET_NAME('GR',
276: 'GR_UNEXPECTED_ERROR');
277: FND_MESSAGE.SET_TOKEN('TEXT',
278: l_msg_data,
279: FALSE);
280: IF FND_API.To_Boolean(p_called_by_form) THEN
281: APP_EXCEPTION.Raise_Exception;

Line 283: x_msg_data := FND_MESSAGE.Get;

279: FALSE);
280: IF FND_API.To_Boolean(p_called_by_form) THEN
281: APP_EXCEPTION.Raise_Exception;
282: ELSE
283: x_msg_data := FND_MESSAGE.Get;
284: END IF;
285:
286: END Update_Row;
287:

Line 358: FND_MESSAGE.SET_NAME('GR',

354:
355: WHEN No_Data_Found_Error THEN
356: ROLLBACK TO SAVEPOINT Lock_Row;
357: x_return_status := 'E';
358: FND_MESSAGE.SET_NAME('GR',
359: 'GR_RECORD_NOT_FOUND');
360: FND_MESSAGE.SET_TOKEN('CODE',
361: p_exposure_type_code,
362: FALSE);

Line 360: FND_MESSAGE.SET_TOKEN('CODE',

356: ROLLBACK TO SAVEPOINT Lock_Row;
357: x_return_status := 'E';
358: FND_MESSAGE.SET_NAME('GR',
359: 'GR_RECORD_NOT_FOUND');
360: FND_MESSAGE.SET_TOKEN('CODE',
361: p_exposure_type_code,
362: FALSE);
363: IF FND_API.To_Boolean(p_called_by_form) THEN
364: APP_EXCEPTION.Raise_Exception;

Line 366: x_msg_data := FND_MESSAGE.Get;

362: FALSE);
363: IF FND_API.To_Boolean(p_called_by_form) THEN
364: APP_EXCEPTION.Raise_Exception;
365: ELSE
366: x_msg_data := FND_MESSAGE.Get;
367: END IF;
368:
369: WHEN RECORD_CHANGED_ERROR THEN
370: ROLLBACK TO SAVEPOINT Lock_Row;

Line 372: FND_MESSAGE.SET_NAME('FND',

368:
369: WHEN RECORD_CHANGED_ERROR THEN
370: ROLLBACK TO SAVEPOINT Lock_Row;
371: X_return_status := 'E';
372: FND_MESSAGE.SET_NAME('FND',
373: 'FORM_RECORD_CHANGED');
374: IF FND_API.To_Boolean(p_called_by_form) THEN
375: APP_EXCEPTION.Raise_Exception;
376: ELSE

Line 377: x_msg_data := FND_MESSAGE.Get;

373: 'FORM_RECORD_CHANGED');
374: IF FND_API.To_Boolean(p_called_by_form) THEN
375: APP_EXCEPTION.Raise_Exception;
376: ELSE
377: x_msg_data := FND_MESSAGE.Get;
378: END IF;
379: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
380: ROLLBACK TO SAVEPOINT Lock_Row;
381: x_return_status := 'L';

Line 384: FND_MESSAGE.SET_NAME('GR',

380: ROLLBACK TO SAVEPOINT Lock_Row;
381: x_return_status := 'L';
382: x_oracle_error := APP_EXCEPTION.Get_Code;
383: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
384: FND_MESSAGE.SET_NAME('GR',
385: 'GR_ROW_IS_LOCKED');
386: x_msg_data := FND_MESSAGE.Get;
387: END IF;
388:

Line 386: x_msg_data := FND_MESSAGE.Get;

382: x_oracle_error := APP_EXCEPTION.Get_Code;
383: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
384: FND_MESSAGE.SET_NAME('GR',
385: 'GR_ROW_IS_LOCKED');
386: x_msg_data := FND_MESSAGE.Get;
387: END IF;
388:
389: WHEN OTHERS THEN
390: ROLLBACK TO SAVEPOINT Lock_Row;

Line 394: FND_MESSAGE.SET_NAME('GR',

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

Line 396: FND_MESSAGE.SET_TOKEN('TEXT',

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_data,
398: FALSE);
399: IF FND_API.To_Boolean(p_called_by_form) THEN
400: APP_EXCEPTION.Raise_Exception;

Line 402: x_msg_data := FND_MESSAGE.Get;

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:
405: END Lock_Row;
406:

Line 476: x_msg_data := FND_MESSAGE.Get;

472: x_oracle_error := l_oracle_error;
473: IF FND_API.To_Boolean(p_called_by_form) THEN
474: APP_EXCEPTION.Raise_Exception;
475: ELSE
476: x_msg_data := FND_MESSAGE.Get;
477: END IF;
478:
479: WHEN Row_Missing_Error THEN
480: ROLLBACK TO SAVEPOINT Delete_Row;

Line 483: FND_MESSAGE.SET_NAME('GR',

479: WHEN Row_Missing_Error THEN
480: ROLLBACK TO SAVEPOINT Delete_Row;
481: x_return_status := 'E';
482: x_oracle_error := APP_EXCEPTION.Get_Code;
483: FND_MESSAGE.SET_NAME('GR',
484: 'GR_RECORD_NOT_FOUND');
485: FND_MESSAGE.SET_TOKEN('CODE',
486: p_exposure_type_code,
487: FALSE);

Line 485: FND_MESSAGE.SET_TOKEN('CODE',

481: x_return_status := 'E';
482: x_oracle_error := APP_EXCEPTION.Get_Code;
483: FND_MESSAGE.SET_NAME('GR',
484: 'GR_RECORD_NOT_FOUND');
485: FND_MESSAGE.SET_TOKEN('CODE',
486: p_exposure_type_code,
487: FALSE);
488: IF FND_API.To_Boolean(p_called_by_form) THEN
489: APP_EXCEPTION.Raise_Exception;

Line 491: x_msg_data := FND_MESSAGE.Get;

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

Line 500: FND_MESSAGE.SET_NAME('GR',

496: x_return_status := 'U';
497: x_oracle_error := APP_EXCEPTION.Get_Code;
498: l_msg_data := APP_EXCEPTION.Get_Text;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_data,
504: FALSE);

Line 502: FND_MESSAGE.SET_TOKEN('TEXT',

498: l_msg_data := APP_EXCEPTION.Get_Text;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: FND_MESSAGE.SET_NAME('GR',
501: 'GR_UNEXPECTED_ERROR');
502: FND_MESSAGE.SET_TOKEN('TEXT',
503: l_msg_data,
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: END Delete_Row;
512:

Line 550: FND_MESSAGE.SET_NAME('GR',

546: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
547: x_return_status := 'U';
548: x_oracle_error := APP_EXCEPTION.Get_Code;
549: l_msg_data := APP_EXCEPTION.Get_Text;
550: FND_MESSAGE.SET_NAME('GR',
551: 'GR_UNEXPECTED_ERROR');
552: FND_MESSAGE.SET_TOKEN('TEXT',
553: l_msg_data,
554: FALSE);

Line 552: FND_MESSAGE.SET_TOKEN('TEXT',

548: x_oracle_error := APP_EXCEPTION.Get_Code;
549: l_msg_data := APP_EXCEPTION.Get_Text;
550: FND_MESSAGE.SET_NAME('GR',
551: 'GR_UNEXPECTED_ERROR');
552: FND_MESSAGE.SET_TOKEN('TEXT',
553: l_msg_data,
554: FALSE);
555: x_msg_data := FND_MESSAGE.Get;
556:

Line 555: x_msg_data := FND_MESSAGE.Get;

551: 'GR_UNEXPECTED_ERROR');
552: FND_MESSAGE.SET_TOKEN('TEXT',
553: l_msg_data,
554: FALSE);
555: x_msg_data := FND_MESSAGE.Get;
556:
557: END Check_Foreign_Keys;
558:
559: PROCEDURE Check_Integrity

Line 618: FND_MESSAGE.SET_NAME('GR',

614: EXCEPTION
615:
616: WHEN INTEGRITY_ERROR THEN
617: x_return_status := 'E';
618: FND_MESSAGE.SET_NAME('GR',
619: 'GR_INTEGRITY_HEADER');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: p_exposure_type_code,
622: FALSE);

Line 620: FND_MESSAGE.SET_TOKEN('CODE',

616: WHEN INTEGRITY_ERROR THEN
617: x_return_status := 'E';
618: FND_MESSAGE.SET_NAME('GR',
619: 'GR_INTEGRITY_HEADER');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: p_exposure_type_code,
622: FALSE);
623: FND_MESSAGE.SET_TOKEN('TABLES',
624: l_msg_data,

Line 623: FND_MESSAGE.SET_TOKEN('TABLES',

619: 'GR_INTEGRITY_HEADER');
620: FND_MESSAGE.SET_TOKEN('CODE',
621: p_exposure_type_code,
622: FALSE);
623: FND_MESSAGE.SET_TOKEN('TABLES',
624: l_msg_data,
625: FALSE);
626: IF FND_API.To_Boolean(p_called_by_form) THEN
627: APP_EXCEPTION.Raise_Exception;

Line 629: x_msg_data := FND_MESSAGE.Get;

625: FALSE);
626: IF FND_API.To_Boolean(p_called_by_form) THEN
627: APP_EXCEPTION.Raise_Exception;
628: ELSE
629: x_msg_data := FND_MESSAGE.Get;
630: END IF;
631: WHEN OTHERS THEN
632: ROLLBACK TO SAVEPOINT Check_Integrity;
633: x_return_status := 'U';

Line 636: FND_MESSAGE.SET_NAME('GR',

632: ROLLBACK TO SAVEPOINT Check_Integrity;
633: x_return_status := 'U';
634: x_oracle_error := APP_EXCEPTION.Get_Code;
635: l_msg_data := APP_EXCEPTION.Get_Text;
636: FND_MESSAGE.SET_NAME('GR',
637: 'GR_UNEXPECTED_ERROR');
638: FND_MESSAGE.SET_TOKEN('TEXT',
639: l_msg_data,
640: FALSE);

Line 638: FND_MESSAGE.SET_TOKEN('TEXT',

634: x_oracle_error := APP_EXCEPTION.Get_Code;
635: l_msg_data := APP_EXCEPTION.Get_Text;
636: FND_MESSAGE.SET_NAME('GR',
637: 'GR_UNEXPECTED_ERROR');
638: FND_MESSAGE.SET_TOKEN('TEXT',
639: l_msg_data,
640: FALSE);
641: IF FND_API.To_Boolean(p_called_by_form) THEN
642: APP_EXCEPTION.Raise_Exception;

Line 644: x_msg_data := FND_MESSAGE.Get;

640: FALSE);
641: IF FND_API.To_Boolean(p_called_by_form) THEN
642: APP_EXCEPTION.Raise_Exception;
643: ELSE
644: x_msg_data := FND_MESSAGE.Get;
645: END IF;
646:
647: END Check_Integrity;
648:

Line 683: FND_MESSAGE.SET_NAME('GR',

679: EXCEPTION
680:
681: WHEN Others THEN
682: l_msg_data := APP_EXCEPTION.Get_Text;
683: FND_MESSAGE.SET_NAME('GR',
684: 'GR_UNEXPECTED_ERROR');
685: FND_MESSAGE.SET_TOKEN('TEXT',
686: l_msg_data,
687: FALSE);

Line 685: FND_MESSAGE.SET_TOKEN('TEXT',

681: WHEN Others THEN
682: l_msg_data := APP_EXCEPTION.Get_Text;
683: FND_MESSAGE.SET_NAME('GR',
684: 'GR_UNEXPECTED_ERROR');
685: FND_MESSAGE.SET_TOKEN('TEXT',
686: l_msg_data,
687: FALSE);
688: IF FND_API.To_Boolean(p_called_by_form) THEN
689: APP_EXCEPTION.Raise_Exception;