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_REGIONS_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_region_code,

Line 135: APP_EXCEPTION.Raise_Exception;

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

Line 150: APP_EXCEPTION.Raise_Exception;

146: FND_MESSAGE.SET_TOKEN('CODE',
147: p_region_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_region_code,

Line 271: APP_EXCEPTION.Raise_Exception;

267: FND_MESSAGE.SET_TOKEN('CODE',
268: p_region_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 368: APP_EXCEPTION.Raise_Exception;

364: FND_MESSAGE.SET_TOKEN('CODE',
365: p_region_code,
366: FALSE);
367: IF FND_API.To_Boolean(p_called_by_form) THEN
368: APP_EXCEPTION.Raise_Exception;
369: ELSE
370: x_msg_data := FND_MESSAGE.Get;
371: END IF;
372:

Line 376: x_oracle_error := APP_EXCEPTION.Get_Code;

372:
373: WHEN Row_Already_Locked_Error THEN
374: ROLLBACK TO SAVEPOINT Lock_Row;
375: x_return_status := 'E';
376: x_oracle_error := APP_EXCEPTION.Get_Code;
377: FND_MESSAGE.SET_NAME('GR',
378: 'GR_ROW_IS_LOCKED');
379: IF FND_API.To_Boolean(p_called_by_form) THEN
380: APP_EXCEPTION.Raise_Exception;

Line 380: APP_EXCEPTION.Raise_Exception;

376: x_oracle_error := APP_EXCEPTION.Get_Code;
377: FND_MESSAGE.SET_NAME('GR',
378: 'GR_ROW_IS_LOCKED');
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:

Line 388: x_oracle_error := APP_EXCEPTION.Get_Code;

384:
385: WHEN OTHERS THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;
387: x_return_status := 'U';
388: x_oracle_error := APP_EXCEPTION.Get_Code;
389: l_msg_data := APP_EXCEPTION.Get_Text;
390: FND_MESSAGE.SET_NAME('GR',
391: 'GR_UNEXPECTED_ERROR');
392: FND_MESSAGE.SET_TOKEN('TEXT',

Line 389: l_msg_data := APP_EXCEPTION.Get_Text;

385: WHEN OTHERS THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;
387: x_return_status := 'U';
388: x_oracle_error := APP_EXCEPTION.Get_Code;
389: l_msg_data := APP_EXCEPTION.Get_Text;
390: FND_MESSAGE.SET_NAME('GR',
391: 'GR_UNEXPECTED_ERROR');
392: FND_MESSAGE.SET_TOKEN('TEXT',
393: l_msg_data,

Line 396: APP_EXCEPTION.Raise_Exception;

392: FND_MESSAGE.SET_TOKEN('TEXT',
393: l_msg_data,
394: FALSE);
395: IF FND_API.To_Boolean(p_called_by_form) THEN
396: APP_EXCEPTION.Raise_Exception;
397: ELSE
398: x_msg_data := FND_MESSAGE.Get;
399: END IF;
400:

Line 475: APP_EXCEPTION.Raise_Exception;

471: ROLLBACK TO SAVEPOINT Delete_Row;
472: x_return_status := l_return_status;
473: x_oracle_error := l_oracle_error;
474: IF FND_API.To_Boolean(p_called_by_form) THEN
475: APP_EXCEPTION.Raise_Exception;
476: ELSE
477: x_msg_data := FND_MESSAGE.Get;
478: END IF;
479:

Line 483: x_oracle_error := APP_EXCEPTION.Get_Code;

479:
480: WHEN Row_Missing_Error THEN
481: ROLLBACK TO SAVEPOINT Delete_Row;
482: x_return_status := 'E';
483: x_oracle_error := APP_EXCEPTION.Get_Code;
484: FND_MESSAGE.SET_NAME('GR',
485: 'GR_RECORD_NOT_FOUND');
486: FND_MESSAGE.SET_TOKEN('CODE',
487: p_region_code,

Line 490: APP_EXCEPTION.Raise_Exception;

486: FND_MESSAGE.SET_TOKEN('CODE',
487: p_region_code,
488: FALSE);
489: IF FND_API.To_Boolean(p_called_by_form) THEN
490: APP_EXCEPTION.Raise_Exception;
491: ELSE
492: x_msg_data := FND_MESSAGE.Get;
493: END IF;
494:

Line 498: x_oracle_error := APP_EXCEPTION.Get_Code;

494:
495: WHEN OTHERS THEN
496: ROLLBACK TO SAVEPOINT Delete_Row;
497: x_return_status := 'U';
498: x_oracle_error := APP_EXCEPTION.Get_Code;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: l_msg_data := APP_EXCEPTION.Get_Text;
501: FND_MESSAGE.SET_NAME('GR',
502: 'GR_UNEXPECTED_ERROR');

Line 499: l_msg_data := APP_EXCEPTION.Get_Text;

495: WHEN OTHERS THEN
496: ROLLBACK TO SAVEPOINT Delete_Row;
497: x_return_status := 'U';
498: x_oracle_error := APP_EXCEPTION.Get_Code;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: l_msg_data := APP_EXCEPTION.Get_Text;
501: FND_MESSAGE.SET_NAME('GR',
502: 'GR_UNEXPECTED_ERROR');
503: FND_MESSAGE.SET_TOKEN('TEXT',

Line 500: l_msg_data := APP_EXCEPTION.Get_Text;

496: ROLLBACK TO SAVEPOINT Delete_Row;
497: x_return_status := 'U';
498: x_oracle_error := APP_EXCEPTION.Get_Code;
499: l_msg_data := APP_EXCEPTION.Get_Text;
500: l_msg_data := APP_EXCEPTION.Get_Text;
501: FND_MESSAGE.SET_NAME('GR',
502: 'GR_UNEXPECTED_ERROR');
503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_data,

Line 507: APP_EXCEPTION.Raise_Exception;

503: FND_MESSAGE.SET_TOKEN('TEXT',
504: l_msg_data,
505: FALSE);
506: IF FND_API.To_Boolean(p_called_by_form) THEN
507: APP_EXCEPTION.Raise_Exception;
508: ELSE
509: x_msg_data := FND_MESSAGE.Get;
510: END IF;
511:

Line 556: x_oracle_error := APP_EXCEPTION.Get_Code;

552:
553: WHEN OTHERS THEN
554: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
555: x_return_status := 'U';
556: x_oracle_error := APP_EXCEPTION.Get_Code;
557: l_msg_data := APP_EXCEPTION.Get_Text;
558: FND_MESSAGE.SET_NAME('GR',
559: 'GR_UNEXPECTED_ERROR');
560: FND_MESSAGE.SET_TOKEN('TEXT',

Line 557: l_msg_data := APP_EXCEPTION.Get_Text;

553: WHEN OTHERS THEN
554: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
555: x_return_status := 'U';
556: x_oracle_error := APP_EXCEPTION.Get_Code;
557: l_msg_data := APP_EXCEPTION.Get_Text;
558: FND_MESSAGE.SET_NAME('GR',
559: 'GR_UNEXPECTED_ERROR');
560: FND_MESSAGE.SET_TOKEN('TEXT',
561: l_msg_data,

Line 660: APP_EXCEPTION.Raise_Exception;

656: FND_MESSAGE.SET_TOKEN('TABLES',
657: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
658: FALSE);
659: IF FND_API.To_Boolean(p_called_by_form) THEN
660: APP_EXCEPTION.Raise_Exception;
661: ELSE
662: x_msg_data := FND_MESSAGE.Get;
663: END IF;
664: WHEN OTHERS THEN

Line 667: x_oracle_error := APP_EXCEPTION.Get_Code;

663: END IF;
664: WHEN OTHERS THEN
665: ROLLBACK TO SAVEPOINT Check_Integrity;
666: x_return_status := 'U';
667: x_oracle_error := APP_EXCEPTION.Get_Code;
668: l_msg_data := APP_EXCEPTION.Get_Text;
669: FND_MESSAGE.SET_NAME('GR',
670: 'GR_UNEXPECTED_ERROR');
671: FND_MESSAGE.SET_TOKEN('TEXT',

Line 668: l_msg_data := APP_EXCEPTION.Get_Text;

664: WHEN OTHERS THEN
665: ROLLBACK TO SAVEPOINT Check_Integrity;
666: x_return_status := 'U';
667: x_oracle_error := APP_EXCEPTION.Get_Code;
668: l_msg_data := APP_EXCEPTION.Get_Text;
669: FND_MESSAGE.SET_NAME('GR',
670: 'GR_UNEXPECTED_ERROR');
671: FND_MESSAGE.SET_TOKEN('TEXT',
672: l_msg_data,

Line 675: APP_EXCEPTION.Raise_Exception;

671: FND_MESSAGE.SET_TOKEN('TEXT',
672: l_msg_data,
673: FALSE);
674: IF FND_API.To_Boolean(p_called_by_form) THEN
675: APP_EXCEPTION.Raise_Exception;
676: ELSE
677: x_msg_data := FND_MESSAGE.Get;
678: END IF;
679:

Line 724: l_msg_data := APP_EXCEPTION.Get_Text;

720:
721: EXCEPTION
722:
723: WHEN Others THEN
724: l_msg_data := APP_EXCEPTION.Get_Text;
725: FND_MESSAGE.SET_NAME('GR',
726: 'GR_UNEXPECTED_ERROR');
727: FND_MESSAGE.SET_TOKEN('TEXT',
728: l_msg_data,

Line 731: APP_EXCEPTION.Raise_Exception;

727: FND_MESSAGE.SET_TOKEN('TEXT',
728: l_msg_data,
729: FALSE);
730: IF FND_API.To_Boolean(p_called_by_form) THEN
731: APP_EXCEPTION.Raise_Exception;
732: END IF;
733:
734: END Check_Primary_Key;
735: