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

Line 110: FND_MESSAGE.SET_NAME('GR',

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

Line 112: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 118: x_msg_data := FND_MESSAGE.Get;

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

Line 126: FND_MESSAGE.SET_NAME('GR',

122: ROLLBACK TO SAVEPOINT Insert_Row;
123: l_msg_token := p_safety_category_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: l_msg_token,
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: l_msg_token,
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 142: FND_MESSAGE.SET_NAME('GR',

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

Line 144: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 150: x_msg_data := FND_MESSAGE.Get;

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

Line 159: FND_MESSAGE.SET_NAME('GR',

155: l_msg_token := p_safety_category_code;
156: x_return_status := 'U';
157: x_oracle_error := APP_EXCEPTION.Get_Code;
158: l_msg_data := APP_EXCEPTION.Get_Text;
159: FND_MESSAGE.SET_NAME('GR',
160: 'GR_UNEXPECTED_ERROR');
161: FND_MESSAGE.SET_TOKEN('TEXT',
162: l_msg_token,
163: FALSE);

Line 161: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 167: x_msg_data := FND_MESSAGE.Get;

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

Line 248: FND_MESSAGE.SET_NAME('GR',

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

Line 250: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 256: x_msg_data := FND_MESSAGE.Get;

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

Line 263: FND_MESSAGE.SET_NAME('GR',

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

Line 265: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 271: x_msg_data := FND_MESSAGE.Get;

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

Line 279: FND_MESSAGE.SET_NAME('GR',

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

Line 281: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 287: x_msg_data := FND_MESSAGE.Get;

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

Line 366: FND_MESSAGE.SET_NAME('GR',

362:
363: WHEN No_Data_Found_Error THEN
364: ROLLBACK TO SAVEPOINT Lock_Row;
365: x_return_status := 'E';
366: FND_MESSAGE.SET_NAME('GR',
367: 'GR_RECORD_NOT_FOUND');
368: FND_MESSAGE.SET_TOKEN('CODE',
369: l_msg_token,
370: FALSE);

Line 368: FND_MESSAGE.SET_TOKEN('CODE',

364: ROLLBACK TO SAVEPOINT Lock_Row;
365: x_return_status := 'E';
366: FND_MESSAGE.SET_NAME('GR',
367: 'GR_RECORD_NOT_FOUND');
368: FND_MESSAGE.SET_TOKEN('CODE',
369: l_msg_token,
370: FALSE);
371: IF FND_API.To_Boolean(p_called_by_form) THEN
372: APP_EXCEPTION.Raise_Exception;

Line 374: x_msg_data := FND_MESSAGE.Get;

370: FALSE);
371: IF FND_API.To_Boolean(p_called_by_form) THEN
372: APP_EXCEPTION.Raise_Exception;
373: ELSE
374: x_msg_data := FND_MESSAGE.Get;
375: END IF;
376:
377: WHEN Row_Already_Locked_Error THEN
378: ROLLBACK TO SAVEPOINT Lock_Row;

Line 381: FND_MESSAGE.SET_NAME('GR',

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

Line 386: x_msg_data := FND_MESSAGE.Get;

382: 'GR_ROW_IS_LOCKED');
383: IF FND_API.To_Boolean(p_called_by_form) THEN
384: APP_EXCEPTION.Raise_Exception;
385: ELSE
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_token,
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_token,
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 483: x_msg_data := FND_MESSAGE.Get;

479: x_oracle_error := l_oracle_error;
480: IF FND_API.To_Boolean(p_called_by_form) THEN
481: APP_EXCEPTION.Raise_Exception;
482: ELSE
483: x_msg_data := FND_MESSAGE.Get;
484: END IF;
485:
486: WHEN Row_Missing_Error THEN
487: ROLLBACK TO SAVEPOINT Delete_Row;

Line 490: FND_MESSAGE.SET_NAME('GR',

486: WHEN Row_Missing_Error THEN
487: ROLLBACK TO SAVEPOINT Delete_Row;
488: x_return_status := 'E';
489: x_oracle_error := APP_EXCEPTION.Get_Code;
490: FND_MESSAGE.SET_NAME('GR',
491: 'GR_RECORD_NOT_FOUND');
492: FND_MESSAGE.SET_TOKEN('CODE',
493: l_msg_token,
494: FALSE);

Line 492: FND_MESSAGE.SET_TOKEN('CODE',

488: x_return_status := 'E';
489: x_oracle_error := APP_EXCEPTION.Get_Code;
490: FND_MESSAGE.SET_NAME('GR',
491: 'GR_RECORD_NOT_FOUND');
492: FND_MESSAGE.SET_TOKEN('CODE',
493: l_msg_token,
494: FALSE);
495: IF FND_API.To_Boolean(p_called_by_form) THEN
496: APP_EXCEPTION.Raise_Exception;

Line 498: x_msg_data := FND_MESSAGE.Get;

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

Line 506: FND_MESSAGE.SET_NAME('GR',

502: ROLLBACK TO SAVEPOINT Delete_Row;
503: x_return_status := 'U';
504: x_oracle_error := APP_EXCEPTION.Get_Code;
505: l_msg_data := APP_EXCEPTION.Get_Text;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_UNEXPECTED_ERROR');
508: FND_MESSAGE.SET_TOKEN('TEXT',
509: l_msg_data,
510: FALSE);

Line 508: FND_MESSAGE.SET_TOKEN('TEXT',

504: x_oracle_error := APP_EXCEPTION.Get_Code;
505: l_msg_data := APP_EXCEPTION.Get_Text;
506: FND_MESSAGE.SET_NAME('GR',
507: 'GR_UNEXPECTED_ERROR');
508: FND_MESSAGE.SET_TOKEN('TEXT',
509: l_msg_data,
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: END Delete_Row;
518:

Line 564: FND_MESSAGE.SET_NAME('GR',

560: WHEN Row_Missing_Error THEN
561: ROLLBACK TO SAVEPOINT Delete_Row;
562: x_return_status := 'E';
563: x_oracle_error := APP_EXCEPTION.Get_Code;
564: FND_MESSAGE.SET_NAME('GR',
565: 'GR_RECORD_NOT_FOUND');
566: FND_MESSAGE.SET_TOKEN('CODE',
567: p_safety_category_code,
568: FALSE);

Line 566: FND_MESSAGE.SET_TOKEN('CODE',

562: x_return_status := 'E';
563: x_oracle_error := APP_EXCEPTION.Get_Code;
564: FND_MESSAGE.SET_NAME('GR',
565: 'GR_RECORD_NOT_FOUND');
566: FND_MESSAGE.SET_TOKEN('CODE',
567: p_safety_category_code,
568: FALSE);
569: x_msg_data := FND_MESSAGE.Get;
570:

Line 569: x_msg_data := FND_MESSAGE.Get;

565: 'GR_RECORD_NOT_FOUND');
566: FND_MESSAGE.SET_TOKEN('CODE',
567: p_safety_category_code,
568: FALSE);
569: x_msg_data := FND_MESSAGE.Get;
570:
571: WHEN OTHERS THEN
572: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
573: x_return_status := 'U';

Line 576: FND_MESSAGE.SET_NAME('GR',

572: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
573: x_return_status := 'U';
574: x_oracle_error := APP_EXCEPTION.Get_Code;
575: l_msg_data := APP_EXCEPTION.Get_Text;
576: FND_MESSAGE.SET_NAME('GR',
577: 'GR_UNEXPECTED_ERROR');
578: FND_MESSAGE.SET_TOKEN('TEXT',
579: l_msg_token,
580: FALSE);

Line 578: FND_MESSAGE.SET_TOKEN('TEXT',

574: x_oracle_error := APP_EXCEPTION.Get_Code;
575: l_msg_data := APP_EXCEPTION.Get_Text;
576: FND_MESSAGE.SET_NAME('GR',
577: 'GR_UNEXPECTED_ERROR');
578: FND_MESSAGE.SET_TOKEN('TEXT',
579: l_msg_token,
580: FALSE);
581: x_msg_data := FND_MESSAGE.Get;
582:

Line 581: x_msg_data := FND_MESSAGE.Get;

577: 'GR_UNEXPECTED_ERROR');
578: FND_MESSAGE.SET_TOKEN('TEXT',
579: l_msg_token,
580: FALSE);
581: x_msg_data := FND_MESSAGE.Get;
582:
583: END Check_Foreign_Keys;
584:
585: PROCEDURE Check_Integrity

Line 667: FND_MESSAGE.SET_NAME('GR',

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

Line 669: FND_MESSAGE.SET_TOKEN('CODE',

665: WHEN INTEGRITY_ERROR THEN
666: x_return_status := 'E';
667: FND_MESSAGE.SET_NAME('GR',
668: 'GR_INTEGRITY_HEADER');
669: FND_MESSAGE.SET_TOKEN('CODE',
670: p_safety_category_code,
671: FALSE);
672: FND_MESSAGE.SET_TOKEN('TABLES',
673: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 672: FND_MESSAGE.SET_TOKEN('TABLES',

668: 'GR_INTEGRITY_HEADER');
669: FND_MESSAGE.SET_TOKEN('CODE',
670: p_safety_category_code,
671: FALSE);
672: FND_MESSAGE.SET_TOKEN('TABLES',
673: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
674: FALSE);
675: IF FND_API.To_Boolean(p_called_by_form) THEN
676: APP_EXCEPTION.Raise_Exception;

Line 678: x_msg_data := FND_MESSAGE.Get;

674: FALSE);
675: IF FND_API.To_Boolean(p_called_by_form) THEN
676: APP_EXCEPTION.Raise_Exception;
677: ELSE
678: x_msg_data := FND_MESSAGE.Get;
679: END IF;
680: WHEN OTHERS THEN
681: ROLLBACK TO SAVEPOINT Check_Integrity;
682: x_return_status := 'U';

Line 685: FND_MESSAGE.SET_NAME('GR',

681: ROLLBACK TO SAVEPOINT Check_Integrity;
682: x_return_status := 'U';
683: x_oracle_error := APP_EXCEPTION.Get_Code;
684: l_msg_data := APP_EXCEPTION.Get_Text;
685: FND_MESSAGE.SET_NAME('GR',
686: 'GR_UNEXPECTED_ERROR');
687: FND_MESSAGE.SET_TOKEN('TEXT',
688: l_msg_data,
689: FALSE);

Line 687: FND_MESSAGE.SET_TOKEN('TEXT',

683: x_oracle_error := APP_EXCEPTION.Get_Code;
684: l_msg_data := APP_EXCEPTION.Get_Text;
685: FND_MESSAGE.SET_NAME('GR',
686: 'GR_UNEXPECTED_ERROR');
687: FND_MESSAGE.SET_TOKEN('TEXT',
688: l_msg_data,
689: FALSE);
690: IF FND_API.To_Boolean(p_called_by_form) THEN
691: APP_EXCEPTION.Raise_Exception;

Line 693: x_msg_data := FND_MESSAGE.Get;

689: FALSE);
690: IF FND_API.To_Boolean(p_called_by_form) THEN
691: APP_EXCEPTION.Raise_Exception;
692: ELSE
693: x_msg_data := FND_MESSAGE.Get;
694: END IF;
695:
696: END Check_Integrity;
697:

Line 742: FND_MESSAGE.SET_NAME('GR',

738: EXCEPTION
739:
740: WHEN Others THEN
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);

Line 744: FND_MESSAGE.SET_TOKEN('TEXT',

740: WHEN Others THEN
741: l_msg_data := APP_EXCEPTION.Get_Text;
742: FND_MESSAGE.SET_NAME('GR',
743: 'GR_UNEXPECTED_ERROR');
744: FND_MESSAGE.SET_TOKEN('TEXT',
745: l_msg_data,
746: FALSE);
747: IF FND_API.To_Boolean(p_called_by_form) THEN
748: APP_EXCEPTION.Raise_Exception;