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 APP_EXCEPTION

Line 135: APP_EXCEPTION.Raise_Exception;

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;
136: ELSE
137: x_msg_data := FND_MESSAGE.Get;
138: END IF;
139:

Line 143: x_oracle_error := APP_EXCEPTION.Get_Code;

139:
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,

Line 150: APP_EXCEPTION.Raise_Exception;

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;
151: ELSE
152: x_msg_data := FND_MESSAGE.Get;
153: END IF;
154:

Line 158: x_oracle_error := APP_EXCEPTION.Get_Code;

154:
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,

Line 165: APP_EXCEPTION.Raise_Exception;

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;
166: ELSE
167: x_msg_data := FND_MESSAGE.Get;
168: END IF;
169:

Line 173: x_oracle_error := APP_EXCEPTION.Get_Code;

169:
170: WHEN OTHERS THEN
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',

Line 174: l_msg_data := APP_EXCEPTION.Get_Text;

170: WHEN OTHERS THEN
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,

Line 181: APP_EXCEPTION.Raise_Exception;

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;
182: ELSE
183: x_msg_data := FND_MESSAGE.Get;
184: END IF;
185:

Line 283: APP_EXCEPTION.Raise_Exception;

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;
284: ELSE
285: x_msg_data := FND_MESSAGE.Get;
286: END IF;
287:

Line 291: x_oracle_error := APP_EXCEPTION.Get_Code;

287:
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,

Line 298: APP_EXCEPTION.Raise_Exception;

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;
299: ELSE
300: x_msg_data := FND_MESSAGE.Get;
301: END IF;
302:

Line 306: x_oracle_error := APP_EXCEPTION.Get_Code;

302:
303: WHEN OTHERS THEN
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',

Line 307: l_msg_data := APP_EXCEPTION.Get_Text;

303: WHEN OTHERS THEN
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,

Line 314: APP_EXCEPTION.Raise_Exception;

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;
315: ELSE
316: x_msg_data := FND_MESSAGE.Get;
317: END IF;
318:

Line 399: APP_EXCEPTION.Raise_Exception;

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;
400: ELSE
401: x_msg_data := FND_MESSAGE.Get;
402: END IF;
403:

Line 407: x_oracle_error := APP_EXCEPTION.Get_Code;

403:
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;

Line 411: APP_EXCEPTION.Raise_Exception;

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
413: x_msg_data := FND_MESSAGE.Get;
414: END IF;
415:

Line 419: x_oracle_error := APP_EXCEPTION.Get_Code;

415:
416: WHEN OTHERS THEN
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',

Line 420: l_msg_data := APP_EXCEPTION.Get_Text;

416: WHEN OTHERS THEN
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,

Line 427: APP_EXCEPTION.Raise_Exception;

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;
428: ELSE
429: x_msg_data := FND_MESSAGE.Get;
430: END IF;
431:

Line 514: APP_EXCEPTION.Raise_Exception;

510: ROLLBACK TO SAVEPOINT Delete_Row;
511: x_return_status := l_return_status;
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:

Line 522: x_oracle_error := APP_EXCEPTION.Get_Code;

518:
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,

Line 529: APP_EXCEPTION.Raise_Exception;

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;
530: ELSE
531: x_msg_data := FND_MESSAGE.Get;
532: END IF;
533:

Line 537: x_oracle_error := APP_EXCEPTION.Get_Code;

533:
534: WHEN OTHERS THEN
535: ROLLBACK TO SAVEPOINT Delete_Row;
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');

Line 538: l_msg_data := APP_EXCEPTION.Get_Text;

534: WHEN OTHERS THEN
535: ROLLBACK TO SAVEPOINT Delete_Row;
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',

Line 539: l_msg_data := APP_EXCEPTION.Get_Text;

535: ROLLBACK TO SAVEPOINT Delete_Row;
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,

Line 546: APP_EXCEPTION.Raise_Exception;

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;
547: ELSE
548: x_msg_data := FND_MESSAGE.Get;
549: END IF;
550:

Line 608: x_oracle_error := APP_EXCEPTION.Get_Code;

604:
605: WHEN OTHERS THEN
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',

Line 609: l_msg_data := APP_EXCEPTION.Get_Text;

605: WHEN OTHERS THEN
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,

Line 695: APP_EXCEPTION.Raise_Exception;

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;
696: ELSE
697: x_msg_data := FND_MESSAGE.Get;
698: END IF;
699: WHEN OTHERS THEN

Line 702: x_oracle_error := APP_EXCEPTION.Get_Code;

698: END IF;
699: WHEN OTHERS THEN
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',

Line 703: l_msg_data := APP_EXCEPTION.Get_Text;

699: WHEN OTHERS THEN
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,

Line 710: APP_EXCEPTION.Raise_Exception;

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;
711: ELSE
712: x_msg_data := FND_MESSAGE.Get;
713: END IF;
714:

Line 759: l_msg_data := APP_EXCEPTION.Get_Text;

755:
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,

Line 766: APP_EXCEPTION.Raise_Exception;

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;
767: END IF;
768:
769: END Check_Primary_Key;
770: