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

Line 129: FND_MESSAGE.SET_NAME('GR',

125: WHEN Foreign_Key_Error THEN
126: ROLLBACK TO SAVEPOINT Insert_Row;
127: x_return_status := l_return_status;
128: x_oracle_error := l_oracle_error;
129: FND_MESSAGE.SET_NAME('GR',
130: 'GR_FOREIGN_KEY_ERROR');
131: FND_MESSAGE.SET_TOKEN('TEXT',
132: l_msg_data,
133: FALSE);

Line 131: FND_MESSAGE.SET_TOKEN('TEXT',

127: x_return_status := l_return_status;
128: x_oracle_error := l_oracle_error;
129: FND_MESSAGE.SET_NAME('GR',
130: 'GR_FOREIGN_KEY_ERROR');
131: FND_MESSAGE.SET_TOKEN('TEXT',
132: l_msg_data,
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 Item_Exists_Error THEN
141: ROLLBACK TO SAVEPOINT Insert_Row;

Line 144: FND_MESSAGE.SET_NAME('GR',

140: WHEN Item_Exists_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_RECORD_EXISTS');
146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_property_id,
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_RECORD_EXISTS');
146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_property_id,
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 Row_Missing_Error THEN
156: ROLLBACK TO SAVEPOINT Insert_Row;

Line 159: FND_MESSAGE.SET_NAME('GR',

155: WHEN Row_Missing_Error THEN
156: ROLLBACK TO SAVEPOINT Insert_Row;
157: x_return_status := 'E';
158: x_oracle_error := APP_EXCEPTION.Get_Code;
159: FND_MESSAGE.SET_NAME('GR',
160: 'GR_NO_RECORD_INSERTED');
161: FND_MESSAGE.SET_TOKEN('CODE',
162: p_property_id,
163: FALSE);

Line 161: FND_MESSAGE.SET_TOKEN('CODE',

157: x_return_status := 'E';
158: x_oracle_error := APP_EXCEPTION.Get_Code;
159: FND_MESSAGE.SET_NAME('GR',
160: 'GR_NO_RECORD_INSERTED');
161: FND_MESSAGE.SET_TOKEN('CODE',
162: p_property_id,
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: WHEN OTHERS THEN
171: ROLLBACK TO SAVEPOINT Insert_Row;

Line 175: FND_MESSAGE.SET_NAME('GR',

171: ROLLBACK TO SAVEPOINT Insert_Row;
172: x_return_status := 'U';
173: x_oracle_error := APP_EXCEPTION.Get_Code;
174: l_msg_data := APP_EXCEPTION.Get_Text;
175: FND_MESSAGE.SET_NAME('GR',
176: 'GR_UNEXPECTED_ERROR');
177: FND_MESSAGE.SET_TOKEN('TEXT',
178: l_msg_data,
179: FALSE);

Line 177: FND_MESSAGE.SET_TOKEN('TEXT',

173: x_oracle_error := APP_EXCEPTION.Get_Code;
174: l_msg_data := APP_EXCEPTION.Get_Text;
175: FND_MESSAGE.SET_NAME('GR',
176: 'GR_UNEXPECTED_ERROR');
177: FND_MESSAGE.SET_TOKEN('TEXT',
178: l_msg_data,
179: FALSE);
180: IF FND_API.To_Boolean(p_called_by_form) THEN
181: APP_EXCEPTION.Raise_Exception;

Line 183: x_msg_data := FND_MESSAGE.Get;

179: FALSE);
180: IF FND_API.To_Boolean(p_called_by_form) THEN
181: APP_EXCEPTION.Raise_Exception;
182: ELSE
183: x_msg_data := FND_MESSAGE.Get;
184: END IF;
185:
186: END Insert_Row;
187:

Line 277: FND_MESSAGE.SET_NAME('GR',

273: WHEN Foreign_Key_Error THEN
274: ROLLBACK TO SAVEPOINT Update_Row;
275: x_return_status := l_return_status;
276: x_oracle_error := l_oracle_error;
277: FND_MESSAGE.SET_NAME('GR',
278: 'GR_FOREIGN_KEY_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);

Line 279: FND_MESSAGE.SET_TOKEN('TEXT',

275: x_return_status := l_return_status;
276: x_oracle_error := l_oracle_error;
277: FND_MESSAGE.SET_NAME('GR',
278: 'GR_FOREIGN_KEY_ERROR');
279: FND_MESSAGE.SET_TOKEN('TEXT',
280: l_msg_data,
281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;

Line 285: x_msg_data := FND_MESSAGE.Get;

281: FALSE);
282: IF FND_API.To_Boolean(p_called_by_form) THEN
283: APP_EXCEPTION.Raise_Exception;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;
287:
288: WHEN Row_Missing_Error THEN
289: ROLLBACK TO SAVEPOINT Update_Row;

Line 292: FND_MESSAGE.SET_NAME('GR',

288: WHEN Row_Missing_Error THEN
289: ROLLBACK TO SAVEPOINT Update_Row;
290: x_return_status := 'E';
291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: FND_MESSAGE.SET_NAME('GR',
293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_property_id,
296: FALSE);

Line 294: FND_MESSAGE.SET_TOKEN('CODE',

290: x_return_status := 'E';
291: x_oracle_error := APP_EXCEPTION.Get_Code;
292: FND_MESSAGE.SET_NAME('GR',
293: 'GR_NO_RECORD_INSERTED');
294: FND_MESSAGE.SET_TOKEN('CODE',
295: p_property_id,
296: FALSE);
297: IF FND_API.To_Boolean(p_called_by_form) THEN
298: APP_EXCEPTION.Raise_Exception;

Line 300: x_msg_data := FND_MESSAGE.Get;

296: FALSE);
297: IF FND_API.To_Boolean(p_called_by_form) THEN
298: APP_EXCEPTION.Raise_Exception;
299: ELSE
300: x_msg_data := FND_MESSAGE.Get;
301: END IF;
302:
303: WHEN OTHERS THEN
304: ROLLBACK TO SAVEPOINT Update_Row;

Line 308: FND_MESSAGE.SET_NAME('GR',

304: ROLLBACK TO SAVEPOINT Update_Row;
305: x_return_status := 'U';
306: x_oracle_error := APP_EXCEPTION.Get_Code;
307: l_msg_data := APP_EXCEPTION.Get_Text;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);

Line 310: FND_MESSAGE.SET_TOKEN('TEXT',

306: x_oracle_error := APP_EXCEPTION.Get_Code;
307: l_msg_data := APP_EXCEPTION.Get_Text;
308: FND_MESSAGE.SET_NAME('GR',
309: 'GR_UNEXPECTED_ERROR');
310: FND_MESSAGE.SET_TOKEN('TEXT',
311: l_msg_data,
312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;

Line 316: x_msg_data := FND_MESSAGE.Get;

312: FALSE);
313: IF FND_API.To_Boolean(p_called_by_form) THEN
314: APP_EXCEPTION.Raise_Exception;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;
318:
319: END Update_Row;
320:

Line 393: FND_MESSAGE.SET_NAME('GR',

389:
390: WHEN No_Data_Found_Error THEN
391: ROLLBACK TO SAVEPOINT Lock_Row;
392: x_return_status := 'E';
393: FND_MESSAGE.SET_NAME('GR',
394: 'GR_RECORD_NOT_FOUND');
395: FND_MESSAGE.SET_TOKEN('CODE',
396: p_property_id,
397: FALSE);

Line 395: FND_MESSAGE.SET_TOKEN('CODE',

391: ROLLBACK TO SAVEPOINT Lock_Row;
392: x_return_status := 'E';
393: FND_MESSAGE.SET_NAME('GR',
394: 'GR_RECORD_NOT_FOUND');
395: FND_MESSAGE.SET_TOKEN('CODE',
396: p_property_id,
397: FALSE);
398: IF FND_API.To_Boolean(p_called_by_form) THEN
399: APP_EXCEPTION.Raise_Exception;

Line 401: x_msg_data := FND_MESSAGE.Get;

397: FALSE);
398: IF FND_API.To_Boolean(p_called_by_form) THEN
399: APP_EXCEPTION.Raise_Exception;
400: ELSE
401: x_msg_data := FND_MESSAGE.Get;
402: END IF;
403:
404: WHEN Row_Already_Locked_Error THEN
405: ROLLBACK TO SAVEPOINT Lock_Row;

Line 408: FND_MESSAGE.SET_NAME('GR',

404: WHEN Row_Already_Locked_Error THEN
405: ROLLBACK TO SAVEPOINT Lock_Row;
406: x_return_status := 'E';
407: x_oracle_error := APP_EXCEPTION.Get_Code;
408: FND_MESSAGE.SET_NAME('GR',
409: 'GR_ROW_IS_LOCKED');
410: IF FND_API.To_Boolean(p_called_by_form) THEN
411: APP_EXCEPTION.Raise_Exception;
412: ELSE

Line 413: x_msg_data := FND_MESSAGE.Get;

409: 'GR_ROW_IS_LOCKED');
410: IF FND_API.To_Boolean(p_called_by_form) THEN
411: APP_EXCEPTION.Raise_Exception;
412: ELSE
413: x_msg_data := FND_MESSAGE.Get;
414: END IF;
415:
416: WHEN OTHERS THEN
417: ROLLBACK TO SAVEPOINT Lock_Row;

Line 421: FND_MESSAGE.SET_NAME('GR',

417: ROLLBACK TO SAVEPOINT Lock_Row;
418: x_return_status := 'U';
419: x_oracle_error := APP_EXCEPTION.Get_Code;
420: l_msg_data := APP_EXCEPTION.Get_Text;
421: FND_MESSAGE.SET_NAME('GR',
422: 'GR_UNEXPECTED_ERROR');
423: FND_MESSAGE.SET_TOKEN('TEXT',
424: l_msg_data,
425: FALSE);

Line 423: FND_MESSAGE.SET_TOKEN('TEXT',

419: x_oracle_error := APP_EXCEPTION.Get_Code;
420: l_msg_data := APP_EXCEPTION.Get_Text;
421: FND_MESSAGE.SET_NAME('GR',
422: 'GR_UNEXPECTED_ERROR');
423: FND_MESSAGE.SET_TOKEN('TEXT',
424: l_msg_data,
425: FALSE);
426: IF FND_API.To_Boolean(p_called_by_form) THEN
427: APP_EXCEPTION.Raise_Exception;

Line 429: x_msg_data := FND_MESSAGE.Get;

425: FALSE);
426: IF FND_API.To_Boolean(p_called_by_form) THEN
427: APP_EXCEPTION.Raise_Exception;
428: ELSE
429: x_msg_data := FND_MESSAGE.Get;
430: END IF;
431:
432: END Lock_Row;
433:

Line 516: x_msg_data := FND_MESSAGE.Get;

512: x_oracle_error := l_oracle_error;
513: IF FND_API.To_Boolean(p_called_by_form) THEN
514: APP_EXCEPTION.Raise_Exception;
515: ELSE
516: x_msg_data := FND_MESSAGE.Get;
517: END IF;
518:
519: WHEN Row_Missing_Error THEN
520: ROLLBACK TO SAVEPOINT Delete_Row;

Line 523: FND_MESSAGE.SET_NAME('GR',

519: WHEN Row_Missing_Error THEN
520: ROLLBACK TO SAVEPOINT Delete_Row;
521: x_return_status := 'E';
522: x_oracle_error := APP_EXCEPTION.Get_Code;
523: FND_MESSAGE.SET_NAME('GR',
524: 'GR_RECORD_NOT_FOUND');
525: FND_MESSAGE.SET_TOKEN('CODE',
526: p_property_id,
527: FALSE);

Line 525: FND_MESSAGE.SET_TOKEN('CODE',

521: x_return_status := 'E';
522: x_oracle_error := APP_EXCEPTION.Get_Code;
523: FND_MESSAGE.SET_NAME('GR',
524: 'GR_RECORD_NOT_FOUND');
525: FND_MESSAGE.SET_TOKEN('CODE',
526: p_property_id,
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: WHEN OTHERS THEN
535: ROLLBACK TO SAVEPOINT Delete_Row;

Line 540: FND_MESSAGE.SET_NAME('GR',

536: x_return_status := 'U';
537: x_oracle_error := APP_EXCEPTION.Get_Code;
538: l_msg_data := APP_EXCEPTION.Get_Text;
539: l_msg_data := APP_EXCEPTION.Get_Text;
540: FND_MESSAGE.SET_NAME('GR',
541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_data,
544: FALSE);

Line 542: FND_MESSAGE.SET_TOKEN('TEXT',

538: l_msg_data := APP_EXCEPTION.Get_Text;
539: l_msg_data := APP_EXCEPTION.Get_Text;
540: FND_MESSAGE.SET_NAME('GR',
541: 'GR_UNEXPECTED_ERROR');
542: FND_MESSAGE.SET_TOKEN('TEXT',
543: l_msg_data,
544: FALSE);
545: IF FND_API.To_Boolean(p_called_by_form) THEN
546: APP_EXCEPTION.Raise_Exception;

Line 548: x_msg_data := FND_MESSAGE.Get;

544: FALSE);
545: IF FND_API.To_Boolean(p_called_by_form) THEN
546: APP_EXCEPTION.Raise_Exception;
547: ELSE
548: x_msg_data := FND_MESSAGE.Get;
549: END IF;
550:
551: END Delete_Row;
552:

Line 610: FND_MESSAGE.SET_NAME('GR',

606: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
607: x_return_status := 'U';
608: x_oracle_error := APP_EXCEPTION.Get_Code;
609: l_msg_data := APP_EXCEPTION.Get_Text;
610: FND_MESSAGE.SET_NAME('GR',
611: 'GR_UNEXPECTED_ERROR');
612: FND_MESSAGE.SET_TOKEN('TEXT',
613: l_msg_data,
614: FALSE);

Line 612: FND_MESSAGE.SET_TOKEN('TEXT',

608: x_oracle_error := APP_EXCEPTION.Get_Code;
609: l_msg_data := APP_EXCEPTION.Get_Text;
610: FND_MESSAGE.SET_NAME('GR',
611: 'GR_UNEXPECTED_ERROR');
612: FND_MESSAGE.SET_TOKEN('TEXT',
613: l_msg_data,
614: FALSE);
615: x_msg_data := FND_MESSAGE.Get;
616:

Line 615: x_msg_data := FND_MESSAGE.Get;

611: 'GR_UNEXPECTED_ERROR');
612: FND_MESSAGE.SET_TOKEN('TEXT',
613: l_msg_data,
614: FALSE);
615: x_msg_data := FND_MESSAGE.Get;
616:
617: END Check_Foreign_Keys;
618:
619: PROCEDURE Check_Integrity

Line 686: FND_MESSAGE.SET_NAME('GR',

682: EXCEPTION
683:
684: WHEN INTEGRITY_ERROR THEN
685: x_return_status := 'E';
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_INTEGRITY_HEADER');
688: FND_MESSAGE.SET_TOKEN('CODE',
689: p_property_id,
690: FALSE);

Line 688: FND_MESSAGE.SET_TOKEN('CODE',

684: WHEN INTEGRITY_ERROR THEN
685: x_return_status := 'E';
686: FND_MESSAGE.SET_NAME('GR',
687: 'GR_INTEGRITY_HEADER');
688: FND_MESSAGE.SET_TOKEN('CODE',
689: p_property_id,
690: FALSE);
691: FND_MESSAGE.SET_TOKEN('TABLES',
692: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 691: FND_MESSAGE.SET_TOKEN('TABLES',

687: 'GR_INTEGRITY_HEADER');
688: FND_MESSAGE.SET_TOKEN('CODE',
689: p_property_id,
690: FALSE);
691: FND_MESSAGE.SET_TOKEN('TABLES',
692: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
693: FALSE);
694: IF FND_API.To_Boolean(p_called_by_form) THEN
695: APP_EXCEPTION.Raise_Exception;

Line 697: x_msg_data := FND_MESSAGE.Get;

693: FALSE);
694: IF FND_API.To_Boolean(p_called_by_form) THEN
695: APP_EXCEPTION.Raise_Exception;
696: ELSE
697: x_msg_data := FND_MESSAGE.Get;
698: END IF;
699: WHEN OTHERS THEN
700: ROLLBACK TO SAVEPOINT Check_Integrity;
701: x_return_status := 'U';

Line 704: FND_MESSAGE.SET_NAME('GR',

700: ROLLBACK TO SAVEPOINT Check_Integrity;
701: x_return_status := 'U';
702: x_oracle_error := APP_EXCEPTION.Get_Code;
703: l_msg_data := APP_EXCEPTION.Get_Text;
704: FND_MESSAGE.SET_NAME('GR',
705: 'GR_UNEXPECTED_ERROR');
706: FND_MESSAGE.SET_TOKEN('TEXT',
707: l_msg_data,
708: FALSE);

Line 706: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 712: x_msg_data := FND_MESSAGE.Get;

708: FALSE);
709: IF FND_API.To_Boolean(p_called_by_form) THEN
710: APP_EXCEPTION.Raise_Exception;
711: ELSE
712: x_msg_data := FND_MESSAGE.Get;
713: END IF;
714:
715:
716: END Check_Integrity;

Line 760: FND_MESSAGE.SET_NAME('GR',

756: EXCEPTION
757:
758: WHEN Others THEN
759: l_msg_data := APP_EXCEPTION.Get_Text;
760: FND_MESSAGE.SET_NAME('GR',
761: 'GR_UNEXPECTED_ERROR');
762: FND_MESSAGE.SET_TOKEN('TEXT',
763: l_msg_data,
764: FALSE);

Line 762: FND_MESSAGE.SET_TOKEN('TEXT',

758: WHEN Others THEN
759: l_msg_data := APP_EXCEPTION.Get_Text;
760: FND_MESSAGE.SET_NAME('GR',
761: 'GR_UNEXPECTED_ERROR');
762: FND_MESSAGE.SET_TOKEN('TEXT',
763: l_msg_data,
764: FALSE);
765: IF FND_API.To_Boolean(p_called_by_form) THEN
766: APP_EXCEPTION.Raise_Exception;