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

Line 118: FND_MESSAGE.SET_NAME('GR',

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

Line 120: FND_MESSAGE.SET_TOKEN('TEXT',

116: x_return_status := l_return_status;
117: x_oracle_error := l_oracle_error;
118: FND_MESSAGE.SET_NAME('GR',
119: 'GR_FOREIGN_KEY_ERROR');
120: FND_MESSAGE.SET_TOKEN('TEXT',
121: l_msg_data,
122: FALSE);
123: IF FND_API.To_Boolean(p_called_by_form) THEN
124: APP_EXCEPTION.Raise_Exception;

Line 126: x_msg_data := FND_MESSAGE.Get;

122: FALSE);
123: IF FND_API.To_Boolean(p_called_by_form) THEN
124: APP_EXCEPTION.Raise_Exception;
125: ELSE
126: x_msg_data := FND_MESSAGE.Get;
127: END IF;
128:
129: WHEN Item_Exists_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;

Line 133: FND_MESSAGE.SET_NAME('GR',

129: WHEN Item_Exists_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;
131: x_return_status := 'E';
132: x_oracle_error := APP_EXCEPTION.Get_Code;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_RECORD_EXISTS');
135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_hazard_classification_code,
137: FALSE);

Line 135: FND_MESSAGE.SET_TOKEN('CODE',

131: x_return_status := 'E';
132: x_oracle_error := APP_EXCEPTION.Get_Code;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_RECORD_EXISTS');
135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_hazard_classification_code,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;

Line 141: x_msg_data := FND_MESSAGE.Get;

137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;
140: ELSE
141: x_msg_data := FND_MESSAGE.Get;
142: END IF;
143:
144: WHEN Row_Missing_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;

Line 148: FND_MESSAGE.SET_NAME('GR',

144: WHEN Row_Missing_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_NO_RECORD_INSERTED');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_hazard_classification_code,
152: FALSE);

Line 150: FND_MESSAGE.SET_TOKEN('CODE',

146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_NO_RECORD_INSERTED');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_hazard_classification_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;

Line 156: x_msg_data := FND_MESSAGE.Get;

152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;
155: ELSE
156: x_msg_data := FND_MESSAGE.Get;
157: END IF;
158:
159: WHEN OTHERS THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;

Line 164: FND_MESSAGE.SET_NAME('GR',

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

Line 166: FND_MESSAGE.SET_TOKEN('TEXT',

162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: l_msg_data := APP_EXCEPTION.Get_Text;
164: FND_MESSAGE.SET_NAME('GR',
165: 'GR_UNEXPECTED_ERROR');
166: FND_MESSAGE.SET_TOKEN('TEXT',
167: l_msg_data,
168: FALSE);
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;

Line 172: x_msg_data := FND_MESSAGE.Get;

168: FALSE);
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;
171: ELSE
172: x_msg_data := FND_MESSAGE.Get;
173: END IF;
174:
175: END Insert_Row;
176:

Line 257: FND_MESSAGE.SET_NAME('GR',

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

Line 259: FND_MESSAGE.SET_TOKEN('TEXT',

255: x_return_status := l_return_status;
256: x_oracle_error := l_oracle_error;
257: FND_MESSAGE.SET_NAME('GR',
258: 'GR_FOREIGN_KEY_ERROR');
259: FND_MESSAGE.SET_TOKEN('TEXT',
260: l_msg_data,
261: FALSE);
262: IF FND_API.To_Boolean(p_called_by_form) THEN
263: APP_EXCEPTION.Raise_Exception;

Line 265: x_msg_data := FND_MESSAGE.Get;

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

Line 272: FND_MESSAGE.SET_NAME('GR',

268: WHEN Row_Missing_Error THEN
269: ROLLBACK TO SAVEPOINT Update_Row;
270: x_return_status := 'E';
271: x_oracle_error := APP_EXCEPTION.Get_Code;
272: FND_MESSAGE.SET_NAME('GR',
273: 'GR_NO_RECORD_INSERTED');
274: FND_MESSAGE.SET_TOKEN('CODE',
275: p_hazard_group_code,
276: FALSE);

Line 274: FND_MESSAGE.SET_TOKEN('CODE',

270: x_return_status := 'E';
271: x_oracle_error := APP_EXCEPTION.Get_Code;
272: FND_MESSAGE.SET_NAME('GR',
273: 'GR_NO_RECORD_INSERTED');
274: FND_MESSAGE.SET_TOKEN('CODE',
275: p_hazard_group_code,
276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;

Line 280: x_msg_data := FND_MESSAGE.Get;

276: FALSE);
277: IF FND_API.To_Boolean(p_called_by_form) THEN
278: APP_EXCEPTION.Raise_Exception;
279: ELSE
280: x_msg_data := FND_MESSAGE.Get;
281: END IF;
282:
283: WHEN OTHERS THEN
284: ROLLBACK TO SAVEPOINT Update_Row;

Line 288: FND_MESSAGE.SET_NAME('GR',

284: ROLLBACK TO SAVEPOINT Update_Row;
285: x_return_status := 'U';
286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: l_msg_data := APP_EXCEPTION.Get_Text;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_UNEXPECTED_ERROR');
290: FND_MESSAGE.SET_TOKEN('TEXT',
291: l_msg_data,
292: FALSE);

Line 290: FND_MESSAGE.SET_TOKEN('TEXT',

286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: l_msg_data := APP_EXCEPTION.Get_Text;
288: FND_MESSAGE.SET_NAME('GR',
289: 'GR_UNEXPECTED_ERROR');
290: FND_MESSAGE.SET_TOKEN('TEXT',
291: l_msg_data,
292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;

Line 296: x_msg_data := FND_MESSAGE.Get;

292: FALSE);
293: IF FND_API.To_Boolean(p_called_by_form) THEN
294: APP_EXCEPTION.Raise_Exception;
295: ELSE
296: x_msg_data := FND_MESSAGE.Get;
297: END IF;
298:
299: END Update_Row;
300:

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: p_hazard_classification_code,
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: p_hazard_classification_code,
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 RECORD_CHANGED_ERROR THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;

Line 388: FND_MESSAGE.SET_NAME('FND',

384:
385: WHEN RECORD_CHANGED_ERROR THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;
387: X_return_status := 'E';
388: FND_MESSAGE.SET_NAME('FND',
389: 'FORM_RECORD_CHANGED');
390: IF FND_API.To_Boolean(p_called_by_form) THEN
391: APP_EXCEPTION.Raise_Exception;
392: ELSE

Line 393: x_msg_data := FND_MESSAGE.Get;

389: 'FORM_RECORD_CHANGED');
390: IF FND_API.To_Boolean(p_called_by_form) THEN
391: APP_EXCEPTION.Raise_Exception;
392: ELSE
393: x_msg_data := FND_MESSAGE.Get;
394: END IF;
395: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'L';

Line 400: FND_MESSAGE.SET_NAME('GR',

396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'L';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
400: FND_MESSAGE.SET_NAME('GR',
401: 'GR_ROW_IS_LOCKED');
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;
404:

Line 402: x_msg_data := FND_MESSAGE.Get;

398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
400: FND_MESSAGE.SET_NAME('GR',
401: 'GR_ROW_IS_LOCKED');
402: x_msg_data := FND_MESSAGE.Get;
403: END IF;
404:
405:
406: WHEN OTHERS THEN

Line 411: FND_MESSAGE.SET_NAME('GR',

407: ROLLBACK TO SAVEPOINT Lock_Row;
408: x_return_status := 'U';
409: x_oracle_error := APP_EXCEPTION.Get_Code;
410: l_msg_data := APP_EXCEPTION.Get_Text;
411: FND_MESSAGE.SET_NAME('GR',
412: 'GR_UNEXPECTED_ERROR');
413: FND_MESSAGE.SET_TOKEN('TEXT',
414: l_msg_data,
415: FALSE);

Line 413: FND_MESSAGE.SET_TOKEN('TEXT',

409: x_oracle_error := APP_EXCEPTION.Get_Code;
410: l_msg_data := APP_EXCEPTION.Get_Text;
411: FND_MESSAGE.SET_NAME('GR',
412: 'GR_UNEXPECTED_ERROR');
413: FND_MESSAGE.SET_TOKEN('TEXT',
414: l_msg_data,
415: FALSE);
416: IF FND_API.To_Boolean(p_called_by_form) THEN
417: APP_EXCEPTION.Raise_Exception;

Line 419: x_msg_data := FND_MESSAGE.Get;

415: FALSE);
416: IF FND_API.To_Boolean(p_called_by_form) THEN
417: APP_EXCEPTION.Raise_Exception;
418: ELSE
419: x_msg_data := FND_MESSAGE.Get;
420: END IF;
421:
422: END Lock_Row;
423:

Line 499: x_msg_data := FND_MESSAGE.Get;

495: x_oracle_error := l_oracle_error;
496: IF FND_API.To_Boolean(p_called_by_form) THEN
497: APP_EXCEPTION.Raise_Exception;
498: ELSE
499: x_msg_data := FND_MESSAGE.Get;
500: END IF;
501:
502: WHEN Row_Missing_Error THEN
503: ROLLBACK TO SAVEPOINT Delete_Row;

Line 506: FND_MESSAGE.SET_NAME('GR',

502: WHEN Row_Missing_Error THEN
503: ROLLBACK TO SAVEPOINT Delete_Row;
504: x_return_status := 'E';
505: x_oracle_error := APP_EXCEPTION.Get_Code;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_RECORD_NOT_FOUND');
508: FND_MESSAGE.SET_TOKEN('CODE',
509: p_hazard_classification_code,
510: FALSE);

Line 508: FND_MESSAGE.SET_TOKEN('CODE',

504: x_return_status := 'E';
505: x_oracle_error := APP_EXCEPTION.Get_Code;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_RECORD_NOT_FOUND');
508: FND_MESSAGE.SET_TOKEN('CODE',
509: p_hazard_classification_code,
510: FALSE);
511: IF FND_API.To_Boolean(p_called_by_form) THEN
512: APP_EXCEPTION.Raise_Exception;

Line 514: x_msg_data := FND_MESSAGE.Get;

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

Line 523: FND_MESSAGE.SET_NAME('GR',

519: x_return_status := 'U';
520: x_oracle_error := APP_EXCEPTION.Get_Code;
521: l_msg_data := APP_EXCEPTION.Get_Text;
522: l_msg_data := APP_EXCEPTION.Get_Text;
523: FND_MESSAGE.SET_NAME('GR',
524: 'GR_UNEXPECTED_ERROR');
525: FND_MESSAGE.SET_TOKEN('TEXT',
526: l_msg_data,
527: FALSE);

Line 525: FND_MESSAGE.SET_TOKEN('TEXT',

521: l_msg_data := APP_EXCEPTION.Get_Text;
522: l_msg_data := APP_EXCEPTION.Get_Text;
523: FND_MESSAGE.SET_NAME('GR',
524: 'GR_UNEXPECTED_ERROR');
525: FND_MESSAGE.SET_TOKEN('TEXT',
526: l_msg_data,
527: FALSE);
528: IF FND_API.To_Boolean(p_called_by_form) THEN
529: APP_EXCEPTION.Raise_Exception;

Line 531: x_msg_data := FND_MESSAGE.Get;

527: FALSE);
528: IF FND_API.To_Boolean(p_called_by_form) THEN
529: APP_EXCEPTION.Raise_Exception;
530: ELSE
531: x_msg_data := FND_MESSAGE.Get;
532: END IF;
533:
534: END Delete_Row;
535:

Line 580: FND_MESSAGE.SET_NAME('GR',

576: l_key_exists);
577:
578: IF NOT FND_API.To_Boolean(l_key_exists) THEN
579: x_return_status := 'E';
580: FND_MESSAGE.SET_NAME('GR',
581: 'GR_RECORD_NOT_FOUND');
582: FND_MESSAGE.SET_TOKEN('CODE',
583: p_hazard_group_code,
584: FALSE);

Line 582: FND_MESSAGE.SET_TOKEN('CODE',

578: IF NOT FND_API.To_Boolean(l_key_exists) THEN
579: x_return_status := 'E';
580: FND_MESSAGE.SET_NAME('GR',
581: 'GR_RECORD_NOT_FOUND');
582: FND_MESSAGE.SET_TOKEN('CODE',
583: p_hazard_group_code,
584: FALSE);
585: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
586: END IF;

Line 585: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

581: 'GR_RECORD_NOT_FOUND');
582: FND_MESSAGE.SET_TOKEN('CODE',
583: p_hazard_group_code,
584: FALSE);
585: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
586: END IF;
587:
588: IF x_return_status <> 'S' THEN
589: x_msg_data := l_msg_data;

Line 599: FND_MESSAGE.SET_NAME('GR',

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

Line 601: FND_MESSAGE.SET_TOKEN('TEXT',

597: x_oracle_error := APP_EXCEPTION.Get_Code;
598: l_msg_data := APP_EXCEPTION.Get_Text;
599: FND_MESSAGE.SET_NAME('GR',
600: 'GR_UNEXPECTED_ERROR');
601: FND_MESSAGE.SET_TOKEN('TEXT',
602: l_msg_data,
603: FALSE);
604: x_msg_data := FND_MESSAGE.Get;
605:

Line 604: x_msg_data := FND_MESSAGE.Get;

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

Line 664: FND_MESSAGE.SET_NAME('GR',

660: x_oracle_error := 0;
661: x_msg_data := NULL;
662: l_msg_data := NULL;
663:
664: FND_MESSAGE.SET_NAME('GR',
665: 'GR_INTEGRITY_HEADER');
666: FND_MESSAGE.SET_TOKEN('CODE',
667: p_hazard_classification_code,
668: FALSE);

Line 666: FND_MESSAGE.SET_TOKEN('CODE',

662: l_msg_data := NULL;
663:
664: FND_MESSAGE.SET_NAME('GR',
665: 'GR_INTEGRITY_HEADER');
666: FND_MESSAGE.SET_TOKEN('CODE',
667: p_hazard_classification_code,
668: FALSE);
669: l_msg_data := FND_MESSAGE.Get;
670:

Line 669: l_msg_data := FND_MESSAGE.Get;

665: 'GR_INTEGRITY_HEADER');
666: FND_MESSAGE.SET_TOKEN('CODE',
667: p_hazard_classification_code,
668: FALSE);
669: l_msg_data := FND_MESSAGE.Get;
670:
671: /* Start with the European Default Concentrations table */
672:
673: l_record_count := 0;

Line 721: FND_MESSAGE.SET_NAME('GR',

717: ROLLBACK TO SAVEPOINT Check_Integrity;
718: x_return_status := 'U';
719: x_oracle_error := APP_EXCEPTION.Get_Code;
720: l_msg_data := APP_EXCEPTION.Get_Text;
721: FND_MESSAGE.SET_NAME('GR',
722: 'GR_UNEXPECTED_ERROR');
723: FND_MESSAGE.SET_TOKEN('TEXT',
724: l_msg_data,
725: FALSE);

Line 723: FND_MESSAGE.SET_TOKEN('TEXT',

719: x_oracle_error := APP_EXCEPTION.Get_Code;
720: l_msg_data := APP_EXCEPTION.Get_Text;
721: FND_MESSAGE.SET_NAME('GR',
722: 'GR_UNEXPECTED_ERROR');
723: FND_MESSAGE.SET_TOKEN('TEXT',
724: l_msg_data,
725: FALSE);
726: IF FND_API.To_Boolean(p_called_by_form) THEN
727: APP_EXCEPTION.Raise_Exception;

Line 729: x_msg_data := FND_MESSAGE.Get;

725: FALSE);
726: IF FND_API.To_Boolean(p_called_by_form) THEN
727: APP_EXCEPTION.Raise_Exception;
728: ELSE
729: x_msg_data := FND_MESSAGE.Get;
730: END IF;
731:
732: END Check_Integrity;
733:

Line 776: FND_MESSAGE.SET_NAME('GR',

772: EXCEPTION
773:
774: WHEN Others THEN
775: l_msg_data := APP_EXCEPTION.Get_Text;
776: FND_MESSAGE.SET_NAME('GR',
777: 'GR_UNEXPECTED_ERROR');
778: FND_MESSAGE.SET_TOKEN('TEXT',
779: l_msg_data,
780: FALSE);

Line 778: FND_MESSAGE.SET_TOKEN('TEXT',

774: WHEN Others THEN
775: l_msg_data := APP_EXCEPTION.Get_Text;
776: FND_MESSAGE.SET_NAME('GR',
777: 'GR_UNEXPECTED_ERROR');
778: FND_MESSAGE.SET_TOKEN('TEXT',
779: l_msg_data,
780: FALSE);
781: IF FND_API.To_Boolean(p_called_by_form) THEN
782: APP_EXCEPTION.Raise_Exception;