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

Line 126: APP_EXCEPTION.Raise_Exception;

122: l_msg_data,
123: FALSE);
124: x_msg_data := FND_MESSAGE.Get;
125: IF FND_API.To_Boolean(p_called_by_form) THEN
126: APP_EXCEPTION.Raise_Exception;
127: END IF;
128:
129: WHEN Item_Exists_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;

Line 132: x_oracle_error := APP_EXCEPTION.Get_Code;

128:
129: WHEN Item_Exists_Error THEN
130: ROLLBACK TO SAVEPOINT Insert_Row;
131: x_return_status := 'E';
132: x_oracle_error := APP_EXCEPTION.Get_Code;
133: FND_MESSAGE.SET_NAME('GR',
134: 'GR_RECORD_EXISTS');
135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_item_group_code,

Line 139: APP_EXCEPTION.Raise_Exception;

135: FND_MESSAGE.SET_TOKEN('CODE',
136: p_item_group_code,
137: FALSE);
138: IF FND_API.To_Boolean(p_called_by_form) THEN
139: APP_EXCEPTION.Raise_Exception;
140: ELSE
141: x_msg_data := FND_MESSAGE.Get;
142: END IF;
143:

Line 147: x_oracle_error := APP_EXCEPTION.Get_Code;

143:
144: WHEN Row_Missing_Error THEN
145: ROLLBACK TO SAVEPOINT Insert_Row;
146: x_return_status := 'E';
147: x_oracle_error := APP_EXCEPTION.Get_Code;
148: FND_MESSAGE.SET_NAME('GR',
149: 'GR_NO_RECORD_INSERTED');
150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_item_group_code,

Line 154: APP_EXCEPTION.Raise_Exception;

150: FND_MESSAGE.SET_TOKEN('CODE',
151: p_item_group_code,
152: FALSE);
153: IF FND_API.To_Boolean(p_called_by_form) THEN
154: APP_EXCEPTION.Raise_Exception;
155: ELSE
156: x_msg_data := FND_MESSAGE.Get;
157: END IF;
158:

Line 162: x_oracle_error := APP_EXCEPTION.Get_Code;

158:
159: WHEN OTHERS THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'U';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: l_msg_data := APP_EXCEPTION.Get_Text;
164: FND_MESSAGE.SET_NAME('GR',
165: 'GR_UNEXPECTED_ERROR');
166: FND_MESSAGE.SET_TOKEN('TEXT',

Line 163: l_msg_data := APP_EXCEPTION.Get_Text;

159: WHEN OTHERS THEN
160: ROLLBACK TO SAVEPOINT Insert_Row;
161: x_return_status := 'U';
162: x_oracle_error := APP_EXCEPTION.Get_Code;
163: l_msg_data := APP_EXCEPTION.Get_Text;
164: FND_MESSAGE.SET_NAME('GR',
165: 'GR_UNEXPECTED_ERROR');
166: FND_MESSAGE.SET_TOKEN('TEXT',
167: l_msg_data,

Line 170: APP_EXCEPTION.Raise_Exception;

166: FND_MESSAGE.SET_TOKEN('TEXT',
167: l_msg_data,
168: FALSE);
169: IF FND_API.To_Boolean(p_called_by_form) THEN
170: APP_EXCEPTION.Raise_Exception;
171: ELSE
172: x_msg_data := FND_MESSAGE.Get;
173: END IF;
174:

Line 264: APP_EXCEPTION.Raise_Exception;

260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;
265: ELSE
266: x_msg_data := FND_MESSAGE.Get;
267: END IF;
268:

Line 272: x_oracle_error := APP_EXCEPTION.Get_Code;

268:
269: WHEN Row_Missing_Error THEN
270: ROLLBACK TO SAVEPOINT Update_Row;
271: x_return_status := 'E';
272: x_oracle_error := APP_EXCEPTION.Get_Code;
273: FND_MESSAGE.SET_NAME('GR',
274: 'GR_NO_RECORD_INSERTED');
275: FND_MESSAGE.SET_TOKEN('CODE',
276: p_item_group_code,

Line 279: APP_EXCEPTION.Raise_Exception;

275: FND_MESSAGE.SET_TOKEN('CODE',
276: p_item_group_code,
277: FALSE);
278: IF FND_API.To_Boolean(p_called_by_form) THEN
279: APP_EXCEPTION.Raise_Exception;
280: ELSE
281: x_msg_data := FND_MESSAGE.Get;
282: END IF;
283:

Line 287: x_oracle_error := APP_EXCEPTION.Get_Code;

283:
284: WHEN OTHERS THEN
285: ROLLBACK TO SAVEPOINT Update_Row;
286: x_return_status := 'U';
287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: l_msg_data := APP_EXCEPTION.Get_Text;
289: FND_MESSAGE.SET_NAME('GR',
290: 'GR_UNEXPECTED_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',

Line 288: l_msg_data := APP_EXCEPTION.Get_Text;

284: WHEN OTHERS THEN
285: ROLLBACK TO SAVEPOINT Update_Row;
286: x_return_status := 'U';
287: x_oracle_error := APP_EXCEPTION.Get_Code;
288: l_msg_data := APP_EXCEPTION.Get_Text;
289: FND_MESSAGE.SET_NAME('GR',
290: 'GR_UNEXPECTED_ERROR');
291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,

Line 295: APP_EXCEPTION.Raise_Exception;

291: FND_MESSAGE.SET_TOKEN('TEXT',
292: l_msg_data,
293: FALSE);
294: IF FND_API.To_Boolean(p_called_by_form) THEN
295: APP_EXCEPTION.Raise_Exception;
296: ELSE
297: x_msg_data := FND_MESSAGE.Get;
298: END IF;
299:

Line 378: APP_EXCEPTION.Raise_Exception;

374: FND_MESSAGE.SET_TOKEN('CODE',
375: p_item_group_code,
376: FALSE);
377: IF FND_API.To_Boolean(p_called_by_form) THEN
378: APP_EXCEPTION.Raise_Exception;
379: ELSE
380: x_msg_data := FND_MESSAGE.Get;
381: END IF;
382:

Line 386: x_oracle_error := APP_EXCEPTION.Get_Code;

382:
383: WHEN Row_Already_Locked_Error THEN
384: ROLLBACK TO SAVEPOINT Lock_Row;
385: x_return_status := 'E';
386: x_oracle_error := APP_EXCEPTION.Get_Code;
387: FND_MESSAGE.SET_NAME('GR',
388: 'GR_ROW_IS_LOCKED');
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;

Line 390: APP_EXCEPTION.Raise_Exception;

386: x_oracle_error := APP_EXCEPTION.Get_Code;
387: FND_MESSAGE.SET_NAME('GR',
388: 'GR_ROW_IS_LOCKED');
389: IF FND_API.To_Boolean(p_called_by_form) THEN
390: APP_EXCEPTION.Raise_Exception;
391: ELSE
392: x_msg_data := FND_MESSAGE.Get;
393: END IF;
394:

Line 398: x_oracle_error := APP_EXCEPTION.Get_Code;

394:
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 484: APP_EXCEPTION.Raise_Exception;

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

Line 492: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 499: APP_EXCEPTION.Raise_Exception;

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

Line 507: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 508: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 509: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 516: APP_EXCEPTION.Raise_Exception;

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

Line 560: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 561: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 634: APP_EXCEPTION.Raise_Exception;

630: FND_MESSAGE.SET_TOKEN('TABLES',
631: l_msg_data,
632: FALSE);
633: IF FND_API.To_Boolean(p_called_by_form) THEN
634: APP_EXCEPTION.Raise_Exception;
635: ELSE
636: x_msg_data := FND_MESSAGE.Get;
637: END IF;
638: WHEN OTHERS THEN

Line 641: x_oracle_error := APP_EXCEPTION.Get_Code;

637: END IF;
638: WHEN OTHERS THEN
639: ROLLBACK TO SAVEPOINT Check_Integrity;
640: x_return_status := 'U';
641: x_oracle_error := APP_EXCEPTION.Get_Code;
642: l_msg_data := APP_EXCEPTION.Get_Text;
643: FND_MESSAGE.SET_NAME('GR',
644: 'GR_UNEXPECTED_ERROR');
645: FND_MESSAGE.SET_TOKEN('TEXT',

Line 642: l_msg_data := APP_EXCEPTION.Get_Text;

638: WHEN OTHERS THEN
639: ROLLBACK TO SAVEPOINT Check_Integrity;
640: x_return_status := 'U';
641: x_oracle_error := APP_EXCEPTION.Get_Code;
642: l_msg_data := APP_EXCEPTION.Get_Text;
643: FND_MESSAGE.SET_NAME('GR',
644: 'GR_UNEXPECTED_ERROR');
645: FND_MESSAGE.SET_TOKEN('TEXT',
646: l_msg_data,

Line 649: APP_EXCEPTION.Raise_Exception;

645: FND_MESSAGE.SET_TOKEN('TEXT',
646: l_msg_data,
647: FALSE);
648: IF FND_API.To_Boolean(p_called_by_form) THEN
649: APP_EXCEPTION.Raise_Exception;
650: ELSE
651: x_msg_data := FND_MESSAGE.Get;
652: END IF;
653:

Line 689: l_msg_data := APP_EXCEPTION.Get_Text;

685:
686: EXCEPTION
687:
688: WHEN Others THEN
689: l_msg_data := APP_EXCEPTION.Get_Text;
690: FND_MESSAGE.SET_NAME('GR',
691: 'GR_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('TEXT',
693: l_msg_data,

Line 696: APP_EXCEPTION.Raise_Exception;

692: FND_MESSAGE.SET_TOKEN('TEXT',
693: l_msg_data,
694: FALSE);
695: IF FND_API.To_Boolean(p_called_by_form) THEN
696: APP_EXCEPTION.Raise_Exception;
697: END IF;
698:
699: END Check_Primary_Key;
700: