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_PHRASE_GROUP_CODES_PKG dependencies on APP_EXCEPTION

Line 120: APP_EXCEPTION.Raise_Exception;

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;
121: ELSE
122: x_msg_data := FND_MESSAGE.Get;
123: END IF;
124:

Line 128: x_oracle_error := APP_EXCEPTION.Get_Code;

124:
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_phrase_group_code,

Line 135: APP_EXCEPTION.Raise_Exception;

131: FND_MESSAGE.SET_TOKEN('CODE',
132: p_phrase_group_code,
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 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_phrase_group_code,

Line 150: APP_EXCEPTION.Raise_Exception;

146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_phrase_group_code,
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 OTHERS THEN
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',

Line 159: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 166: APP_EXCEPTION.Raise_Exception;

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

Line 256: APP_EXCEPTION.Raise_Exception;

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;
257: ELSE
258: x_msg_data := FND_MESSAGE.Get;
259: END IF;
260:

Line 264: x_oracle_error := APP_EXCEPTION.Get_Code;

260:
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_phrase_group_code,

Line 271: APP_EXCEPTION.Raise_Exception;

267: FND_MESSAGE.SET_TOKEN('CODE',
268: p_phrase_group_code,
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:

Line 279: x_oracle_error := APP_EXCEPTION.Get_Code;

275:
276: WHEN OTHERS THEN
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',

Line 280: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 287: APP_EXCEPTION.Raise_Exception;

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;
288: ELSE
289: x_msg_data := FND_MESSAGE.Get;
290: END IF;
291:

Line 372: APP_EXCEPTION.Raise_Exception;

368: FND_MESSAGE.SET_TOKEN('CODE',
369: p_phrase_group_code,
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: WHEN RECORD_CHANGED_ERROR THEN

Line 382: APP_EXCEPTION.Raise_Exception;

378: X_return_status := 'E';
379: FND_MESSAGE.SET_NAME('FND',
380: 'FORM_RECORD_CHANGED');
381: IF FND_API.To_Boolean(p_called_by_form) THEN
382: APP_EXCEPTION.Raise_Exception;
383: ELSE
384: x_msg_data := FND_MESSAGE.Get;
385: END IF;
386: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 386: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

382: APP_EXCEPTION.Raise_Exception;
383: ELSE
384: x_msg_data := FND_MESSAGE.Get;
385: END IF;
386: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
387: ROLLBACK TO SAVEPOINT Lock_Row;
388: x_return_status := 'L';
389: x_oracle_error := APP_EXCEPTION.Get_Code;
390: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 389: x_oracle_error := APP_EXCEPTION.Get_Code;

385: END IF;
386: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
387: ROLLBACK TO SAVEPOINT Lock_Row;
388: x_return_status := 'L';
389: x_oracle_error := APP_EXCEPTION.Get_Code;
390: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
391: FND_MESSAGE.SET_NAME('GR',
392: 'GR_ROW_IS_LOCKED');
393: x_msg_data := FND_MESSAGE.Get;

Line 398: x_oracle_error := APP_EXCEPTION.Get_Code;

394: END IF;
395: WHEN OTHERS THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'U';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: l_msg_data := APP_EXCEPTION.Get_Text;
400: FND_MESSAGE.SET_NAME('GR',
401: 'GR_UNEXPECTED_ERROR');
402: FND_MESSAGE.SET_TOKEN('TEXT',

Line 399: l_msg_data := APP_EXCEPTION.Get_Text;

395: WHEN OTHERS THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'U';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: l_msg_data := APP_EXCEPTION.Get_Text;
400: FND_MESSAGE.SET_NAME('GR',
401: 'GR_UNEXPECTED_ERROR');
402: FND_MESSAGE.SET_TOKEN('TEXT',
403: l_msg_data,

Line 406: APP_EXCEPTION.Raise_Exception;

402: FND_MESSAGE.SET_TOKEN('TEXT',
403: l_msg_data,
404: FALSE);
405: IF FND_API.To_Boolean(p_called_by_form) THEN
406: APP_EXCEPTION.Raise_Exception;
407: ELSE
408: x_msg_data := FND_MESSAGE.Get;
409: END IF;
410:

Line 485: APP_EXCEPTION.Raise_Exception;

481: ROLLBACK TO SAVEPOINT Delete_Row;
482: x_return_status := l_return_status;
483: x_oracle_error := l_oracle_error;
484: IF FND_API.To_Boolean(p_called_by_form) THEN
485: APP_EXCEPTION.Raise_Exception;
486: ELSE
487: x_msg_data := FND_MESSAGE.Get;
488: END IF;
489:

Line 493: x_oracle_error := APP_EXCEPTION.Get_Code;

489:
490: WHEN Row_Missing_Error THEN
491: ROLLBACK TO SAVEPOINT Delete_Row;
492: x_return_status := 'E';
493: x_oracle_error := APP_EXCEPTION.Get_Code;
494: FND_MESSAGE.SET_NAME('GR',
495: 'GR_RECORD_NOT_FOUND');
496: FND_MESSAGE.SET_TOKEN('CODE',
497: p_phrase_group_code,

Line 500: APP_EXCEPTION.Raise_Exception;

496: FND_MESSAGE.SET_TOKEN('CODE',
497: p_phrase_group_code,
498: FALSE);
499: IF FND_API.To_Boolean(p_called_by_form) THEN
500: APP_EXCEPTION.Raise_Exception;
501: ELSE
502: x_msg_data := FND_MESSAGE.Get;
503: END IF;
504:

Line 508: x_oracle_error := APP_EXCEPTION.Get_Code;

504:
505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT Delete_Row;
507: x_return_status := 'U';
508: x_oracle_error := APP_EXCEPTION.Get_Code;
509: l_msg_data := APP_EXCEPTION.Get_Text;
510: l_msg_data := APP_EXCEPTION.Get_Text;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_UNEXPECTED_ERROR');

Line 509: l_msg_data := APP_EXCEPTION.Get_Text;

505: WHEN OTHERS THEN
506: ROLLBACK TO SAVEPOINT Delete_Row;
507: x_return_status := 'U';
508: x_oracle_error := APP_EXCEPTION.Get_Code;
509: l_msg_data := APP_EXCEPTION.Get_Text;
510: l_msg_data := APP_EXCEPTION.Get_Text;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_UNEXPECTED_ERROR');
513: FND_MESSAGE.SET_TOKEN('TEXT',

Line 510: l_msg_data := APP_EXCEPTION.Get_Text;

506: ROLLBACK TO SAVEPOINT Delete_Row;
507: x_return_status := 'U';
508: x_oracle_error := APP_EXCEPTION.Get_Code;
509: l_msg_data := APP_EXCEPTION.Get_Text;
510: l_msg_data := APP_EXCEPTION.Get_Text;
511: FND_MESSAGE.SET_NAME('GR',
512: 'GR_UNEXPECTED_ERROR');
513: FND_MESSAGE.SET_TOKEN('TEXT',
514: l_msg_data,

Line 517: APP_EXCEPTION.Raise_Exception;

513: FND_MESSAGE.SET_TOKEN('TEXT',
514: l_msg_data,
515: FALSE);
516: IF FND_API.To_Boolean(p_called_by_form) THEN
517: APP_EXCEPTION.Raise_Exception;
518: ELSE
519: x_msg_data := FND_MESSAGE.Get;
520: END IF;
521:

Line 566: x_oracle_error := APP_EXCEPTION.Get_Code;

562:
563: WHEN OTHERS THEN
564: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
565: x_return_status := 'U';
566: x_oracle_error := APP_EXCEPTION.Get_Code;
567: l_msg_data := APP_EXCEPTION.Get_Text;
568: FND_MESSAGE.SET_NAME('GR',
569: 'GR_UNEXPECTED_ERROR');
570: FND_MESSAGE.SET_TOKEN('TEXT',

Line 567: l_msg_data := APP_EXCEPTION.Get_Text;

563: WHEN OTHERS THEN
564: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
565: x_return_status := 'U';
566: x_oracle_error := APP_EXCEPTION.Get_Code;
567: l_msg_data := APP_EXCEPTION.Get_Text;
568: FND_MESSAGE.SET_NAME('GR',
569: 'GR_UNEXPECTED_ERROR');
570: FND_MESSAGE.SET_TOKEN('TEXT',
571: l_msg_data,

Line 689: APP_EXCEPTION.Raise_Exception;

685: FND_MESSAGE.SET_TOKEN('TABLES',
686: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
687: FALSE);
688: IF FND_API.To_Boolean(p_called_by_form) THEN
689: APP_EXCEPTION.Raise_Exception;
690: ELSE
691: x_msg_data := FND_MESSAGE.Get;
692: END IF;
693: WHEN OTHERS THEN

Line 696: x_oracle_error := APP_EXCEPTION.Get_Code;

692: END IF;
693: WHEN OTHERS THEN
694: ROLLBACK TO SAVEPOINT Check_Integrity;
695: x_return_status := 'U';
696: x_oracle_error := APP_EXCEPTION.Get_Code;
697: l_msg_data := APP_EXCEPTION.Get_Text;
698: FND_MESSAGE.SET_NAME('GR',
699: 'GR_UNEXPECTED_ERROR');
700: FND_MESSAGE.SET_TOKEN('TEXT',

Line 697: l_msg_data := APP_EXCEPTION.Get_Text;

693: WHEN OTHERS THEN
694: ROLLBACK TO SAVEPOINT Check_Integrity;
695: x_return_status := 'U';
696: x_oracle_error := APP_EXCEPTION.Get_Code;
697: l_msg_data := APP_EXCEPTION.Get_Text;
698: FND_MESSAGE.SET_NAME('GR',
699: 'GR_UNEXPECTED_ERROR');
700: FND_MESSAGE.SET_TOKEN('TEXT',
701: l_msg_data,

Line 704: APP_EXCEPTION.Raise_Exception;

700: FND_MESSAGE.SET_TOKEN('TEXT',
701: l_msg_data,
702: FALSE);
703: IF FND_API.To_Boolean(p_called_by_form) THEN
704: APP_EXCEPTION.Raise_Exception;
705: ELSE
706: x_msg_data := FND_MESSAGE.Get;
707: END IF;
708:

Line 752: l_msg_data := APP_EXCEPTION.Get_Text;

748:
749: EXCEPTION
750:
751: WHEN Others THEN
752: l_msg_data := APP_EXCEPTION.Get_Text;
753: FND_MESSAGE.SET_NAME('GR',
754: 'GR_UNEXPECTED_ERROR');
755: FND_MESSAGE.SET_TOKEN('TEXT',
756: l_msg_data,

Line 759: APP_EXCEPTION.Raise_Exception;

755: FND_MESSAGE.SET_TOKEN('TEXT',
756: l_msg_data,
757: FALSE);
758: IF FND_API.To_Boolean(p_called_by_form) THEN
759: APP_EXCEPTION.Raise_Exception;
760: END IF;
761:
762: END Check_Primary_Key;
763: