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_HAZARD_GROUPS_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 129: FND_MESSAGE.SET_NAME('GR',

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

Line 131: FND_MESSAGE.SET_TOKEN('CODE',

127: x_return_status := 'E';
128: x_oracle_error := APP_EXCEPTION.Get_Code;
129: FND_MESSAGE.SET_NAME('GR',
130: 'GR_RECORD_EXISTS');
131: FND_MESSAGE.SET_TOKEN('CODE',
132: p_hazard_group_code,
133: FALSE);
134: IF FND_API.To_Boolean(p_called_by_form) THEN
135: APP_EXCEPTION.Raise_Exception;

Line 137: x_msg_data := FND_MESSAGE.Get;

133: FALSE);
134: IF FND_API.To_Boolean(p_called_by_form) THEN
135: APP_EXCEPTION.Raise_Exception;
136: ELSE
137: x_msg_data := FND_MESSAGE.Get;
138: END IF;
139:
140: WHEN Row_Missing_Error THEN
141: ROLLBACK TO SAVEPOINT Insert_Row;

Line 144: FND_MESSAGE.SET_NAME('GR',

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

Line 146: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 152: x_msg_data := FND_MESSAGE.Get;

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

Line 160: FND_MESSAGE.SET_NAME('GR',

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

Line 162: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 168: x_msg_data := FND_MESSAGE.Get;

164: FALSE);
165: IF FND_API.To_Boolean(p_called_by_form) THEN
166: APP_EXCEPTION.Raise_Exception;
167: ELSE
168: x_msg_data := FND_MESSAGE.Get;
169: END IF;
170:
171: END Insert_Row;
172:

Line 250: FND_MESSAGE.SET_NAME('GR',

246: WHEN Foreign_Key_Error THEN
247: ROLLBACK TO SAVEPOINT Update_Row;
248: x_return_status := l_return_status;
249: x_oracle_error := l_oracle_error;
250: FND_MESSAGE.SET_NAME('GR',
251: 'GR_FOREIGN_KEY_ERROR');
252: FND_MESSAGE.SET_TOKEN('TEXT',
253: l_msg_data,
254: FALSE);

Line 252: FND_MESSAGE.SET_TOKEN('TEXT',

248: x_return_status := l_return_status;
249: x_oracle_error := l_oracle_error;
250: FND_MESSAGE.SET_NAME('GR',
251: 'GR_FOREIGN_KEY_ERROR');
252: FND_MESSAGE.SET_TOKEN('TEXT',
253: l_msg_data,
254: FALSE);
255: IF FND_API.To_Boolean(p_called_by_form) THEN
256: APP_EXCEPTION.Raise_Exception;

Line 258: x_msg_data := FND_MESSAGE.Get;

254: FALSE);
255: IF FND_API.To_Boolean(p_called_by_form) THEN
256: APP_EXCEPTION.Raise_Exception;
257: ELSE
258: x_msg_data := FND_MESSAGE.Get;
259: END IF;
260:
261: WHEN Row_Missing_Error THEN
262: ROLLBACK TO SAVEPOINT Update_Row;

Line 265: FND_MESSAGE.SET_NAME('GR',

261: WHEN Row_Missing_Error THEN
262: ROLLBACK TO SAVEPOINT Update_Row;
263: x_return_status := 'E';
264: x_oracle_error := APP_EXCEPTION.Get_Code;
265: FND_MESSAGE.SET_NAME('GR',
266: 'GR_NO_RECORD_INSERTED');
267: FND_MESSAGE.SET_TOKEN('CODE',
268: p_hazard_group_code,
269: FALSE);

Line 267: FND_MESSAGE.SET_TOKEN('CODE',

263: x_return_status := 'E';
264: x_oracle_error := APP_EXCEPTION.Get_Code;
265: FND_MESSAGE.SET_NAME('GR',
266: 'GR_NO_RECORD_INSERTED');
267: FND_MESSAGE.SET_TOKEN('CODE',
268: p_hazard_group_code,
269: FALSE);
270: IF FND_API.To_Boolean(p_called_by_form) THEN
271: APP_EXCEPTION.Raise_Exception;

Line 273: x_msg_data := FND_MESSAGE.Get;

269: FALSE);
270: IF FND_API.To_Boolean(p_called_by_form) THEN
271: APP_EXCEPTION.Raise_Exception;
272: ELSE
273: x_msg_data := FND_MESSAGE.Get;
274: END IF;
275:
276: WHEN OTHERS THEN
277: ROLLBACK TO SAVEPOINT Update_Row;

Line 281: FND_MESSAGE.SET_NAME('GR',

277: ROLLBACK TO SAVEPOINT Update_Row;
278: x_return_status := 'U';
279: x_oracle_error := APP_EXCEPTION.Get_Code;
280: l_msg_data := APP_EXCEPTION.Get_Text;
281: FND_MESSAGE.SET_NAME('GR',
282: 'GR_UNEXPECTED_ERROR');
283: FND_MESSAGE.SET_TOKEN('TEXT',
284: l_msg_data,
285: FALSE);

Line 283: FND_MESSAGE.SET_TOKEN('TEXT',

279: x_oracle_error := APP_EXCEPTION.Get_Code;
280: l_msg_data := APP_EXCEPTION.Get_Text;
281: FND_MESSAGE.SET_NAME('GR',
282: 'GR_UNEXPECTED_ERROR');
283: FND_MESSAGE.SET_TOKEN('TEXT',
284: l_msg_data,
285: FALSE);
286: IF FND_API.To_Boolean(p_called_by_form) THEN
287: APP_EXCEPTION.Raise_Exception;

Line 289: x_msg_data := FND_MESSAGE.Get;

285: FALSE);
286: IF FND_API.To_Boolean(p_called_by_form) THEN
287: APP_EXCEPTION.Raise_Exception;
288: ELSE
289: x_msg_data := FND_MESSAGE.Get;
290: END IF;
291:
292: END Update_Row;
293:

Line 362: FND_MESSAGE.SET_NAME('GR',

358:
359: WHEN No_Data_Found_Error THEN
360: ROLLBACK TO SAVEPOINT Lock_Row;
361: x_return_status := 'E';
362: FND_MESSAGE.SET_NAME('GR',
363: 'GR_RECORD_NOT_FOUND');
364: FND_MESSAGE.SET_TOKEN('CODE',
365: p_hazard_group_code,
366: FALSE);

Line 364: FND_MESSAGE.SET_TOKEN('CODE',

360: ROLLBACK TO SAVEPOINT Lock_Row;
361: x_return_status := 'E';
362: FND_MESSAGE.SET_NAME('GR',
363: 'GR_RECORD_NOT_FOUND');
364: FND_MESSAGE.SET_TOKEN('CODE',
365: p_hazard_group_code,
366: FALSE);
367: IF FND_API.To_Boolean(p_called_by_form) THEN
368: APP_EXCEPTION.Raise_Exception;

Line 370: x_msg_data := FND_MESSAGE.Get;

366: FALSE);
367: IF FND_API.To_Boolean(p_called_by_form) THEN
368: APP_EXCEPTION.Raise_Exception;
369: ELSE
370: x_msg_data := FND_MESSAGE.Get;
371: END IF;
372:
373: WHEN Row_Already_Locked_Error THEN
374: ROLLBACK TO SAVEPOINT Lock_Row;

Line 377: FND_MESSAGE.SET_NAME('GR',

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

Line 382: x_msg_data := FND_MESSAGE.Get;

378: 'GR_ROW_IS_LOCKED');
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 OTHERS THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;

Line 390: FND_MESSAGE.SET_NAME('GR',

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

Line 392: FND_MESSAGE.SET_TOKEN('TEXT',

388: x_oracle_error := APP_EXCEPTION.Get_Code;
389: l_msg_data := APP_EXCEPTION.Get_Text;
390: FND_MESSAGE.SET_NAME('GR',
391: 'GR_UNEXPECTED_ERROR');
392: FND_MESSAGE.SET_TOKEN('TEXT',
393: l_msg_data,
394: FALSE);
395: IF FND_API.To_Boolean(p_called_by_form) THEN
396: APP_EXCEPTION.Raise_Exception;

Line 398: x_msg_data := FND_MESSAGE.Get;

394: FALSE);
395: IF FND_API.To_Boolean(p_called_by_form) THEN
396: APP_EXCEPTION.Raise_Exception;
397: ELSE
398: x_msg_data := FND_MESSAGE.Get;
399: END IF;
400:
401: END Lock_Row;
402:

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_hazard_group_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_hazard_group_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 557: FND_MESSAGE.SET_NAME('GR',

553: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
554: x_return_status := 'U';
555: x_oracle_error := APP_EXCEPTION.Get_Code;
556: l_msg_data := APP_EXCEPTION.Get_Text;
557: FND_MESSAGE.SET_NAME('GR',
558: 'GR_UNEXPECTED_ERROR');
559: FND_MESSAGE.SET_TOKEN('TEXT',
560: l_msg_data,
561: FALSE);

Line 559: FND_MESSAGE.SET_TOKEN('TEXT',

555: x_oracle_error := APP_EXCEPTION.Get_Code;
556: l_msg_data := APP_EXCEPTION.Get_Text;
557: FND_MESSAGE.SET_NAME('GR',
558: 'GR_UNEXPECTED_ERROR');
559: FND_MESSAGE.SET_TOKEN('TEXT',
560: l_msg_data,
561: FALSE);
562: x_msg_data := FND_MESSAGE.Get;
563:

Line 562: x_msg_data := FND_MESSAGE.Get;

558: 'GR_UNEXPECTED_ERROR');
559: FND_MESSAGE.SET_TOKEN('TEXT',
560: l_msg_data,
561: FALSE);
562: x_msg_data := FND_MESSAGE.Get;
563:
564: END Check_Foreign_Keys;
565:
566: PROCEDURE Check_Integrity

Line 630: FND_MESSAGE.SET_NAME('GR',

626: EXCEPTION
627:
628: WHEN INTEGRITY_ERROR THEN
629: x_return_status := 'E';
630: FND_MESSAGE.SET_NAME('GR',
631: 'GR_INTEGRITY_HEADER');
632: FND_MESSAGE.SET_TOKEN('CODE',
633: p_hazard_group_code,
634: FALSE);

Line 632: FND_MESSAGE.SET_TOKEN('CODE',

628: WHEN INTEGRITY_ERROR THEN
629: x_return_status := 'E';
630: FND_MESSAGE.SET_NAME('GR',
631: 'GR_INTEGRITY_HEADER');
632: FND_MESSAGE.SET_TOKEN('CODE',
633: p_hazard_group_code,
634: FALSE);
635: FND_MESSAGE.SET_TOKEN('TABLES',
636: l_msg_data,

Line 635: FND_MESSAGE.SET_TOKEN('TABLES',

631: 'GR_INTEGRITY_HEADER');
632: FND_MESSAGE.SET_TOKEN('CODE',
633: p_hazard_group_code,
634: FALSE);
635: FND_MESSAGE.SET_TOKEN('TABLES',
636: l_msg_data,
637: FALSE);
638: IF FND_API.To_Boolean(p_called_by_form) THEN
639: APP_EXCEPTION.Raise_Exception;

Line 641: x_msg_data := FND_MESSAGE.Get;

637: FALSE);
638: IF FND_API.To_Boolean(p_called_by_form) THEN
639: APP_EXCEPTION.Raise_Exception;
640: ELSE
641: x_msg_data := FND_MESSAGE.Get;
642: END IF;
643: WHEN OTHERS THEN
644: ROLLBACK TO SAVEPOINT Check_Integrity;
645: x_return_status := 'U';

Line 648: FND_MESSAGE.SET_NAME('GR',

644: ROLLBACK TO SAVEPOINT Check_Integrity;
645: x_return_status := 'U';
646: x_oracle_error := APP_EXCEPTION.Get_Code;
647: l_msg_data := APP_EXCEPTION.Get_Text;
648: FND_MESSAGE.SET_NAME('GR',
649: 'GR_UNEXPECTED_ERROR');
650: FND_MESSAGE.SET_TOKEN('TEXT',
651: l_msg_data,
652: FALSE);

Line 650: FND_MESSAGE.SET_TOKEN('TEXT',

646: x_oracle_error := APP_EXCEPTION.Get_Code;
647: l_msg_data := APP_EXCEPTION.Get_Text;
648: FND_MESSAGE.SET_NAME('GR',
649: 'GR_UNEXPECTED_ERROR');
650: FND_MESSAGE.SET_TOKEN('TEXT',
651: l_msg_data,
652: FALSE);
653: IF FND_API.To_Boolean(p_called_by_form) THEN
654: APP_EXCEPTION.Raise_Exception;

Line 656: x_msg_data := FND_MESSAGE.Get;

652: FALSE);
653: IF FND_API.To_Boolean(p_called_by_form) THEN
654: APP_EXCEPTION.Raise_Exception;
655: ELSE
656: x_msg_data := FND_MESSAGE.Get;
657: END IF;
658:
659: END Check_Integrity;
660:

Line 703: FND_MESSAGE.SET_NAME('GR',

699: EXCEPTION
700:
701: WHEN Others THEN
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GR',
704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_data,
707: FALSE);

Line 705: FND_MESSAGE.SET_TOKEN('TEXT',

701: WHEN Others THEN
702: l_msg_data := APP_EXCEPTION.Get_Text;
703: FND_MESSAGE.SET_NAME('GR',
704: 'GR_UNEXPECTED_ERROR');
705: FND_MESSAGE.SET_TOKEN('TEXT',
706: l_msg_data,
707: FALSE);
708: IF FND_API.To_Boolean(p_called_by_form) THEN
709: APP_EXCEPTION.Raise_Exception;