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

Line 131: APP_EXCEPTION.Raise_Exception;

127: FND_MESSAGE.SET_TOKEN('TEXT',
128: l_msg_data,
129: FALSE);
130: IF FND_API.To_Boolean(p_called_by_form) THEN
131: APP_EXCEPTION.Raise_Exception;
132: ELSE
133: x_msg_data := FND_MESSAGE.Get;
134: END IF;
135:

Line 140: x_oracle_error := APP_EXCEPTION.Get_Code;

136: WHEN Item_Exists_Error THEN
137: ROLLBACK TO SAVEPOINT Insert_Row;
138: l_msg_token := p_item_code;
139: x_return_status := 'E';
140: x_oracle_error := APP_EXCEPTION.Get_Code;
141: FND_MESSAGE.SET_NAME('GR',
142: 'GR_RECORD_EXISTS');
143: FND_MESSAGE.SET_TOKEN('CODE',
144: l_msg_token,

Line 147: APP_EXCEPTION.Raise_Exception;

143: FND_MESSAGE.SET_TOKEN('CODE',
144: l_msg_token,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;
148: ELSE
149: x_msg_data := FND_MESSAGE.Get;
150: END IF;
151:

Line 156: x_oracle_error := APP_EXCEPTION.Get_Code;

152: WHEN Row_Missing_Error THEN
153: ROLLBACK TO SAVEPOINT Insert_Row;
154: l_msg_token := p_item_code;
155: x_return_status := 'E';
156: x_oracle_error := APP_EXCEPTION.Get_Code;
157: FND_MESSAGE.SET_NAME('GR',
158: 'GR_NO_RECORD_INSERTED');
159: FND_MESSAGE.SET_TOKEN('CODE',
160: l_msg_token,

Line 163: APP_EXCEPTION.Raise_Exception;

159: FND_MESSAGE.SET_TOKEN('CODE',
160: l_msg_token,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;
164: ELSE
165: x_msg_data := FND_MESSAGE.Get;
166: END IF;
167:

Line 172: x_oracle_error := APP_EXCEPTION.Get_Code;

168: WHEN OTHERS THEN
169: ROLLBACK TO SAVEPOINT Insert_Row;
170: l_msg_token := p_item_code;
171: x_return_status := 'U';
172: x_oracle_error := APP_EXCEPTION.Get_Code;
173: l_msg_data := APP_EXCEPTION.Get_Text;
174: FND_MESSAGE.SET_NAME('GR',
175: 'GR_UNEXPECTED_ERROR');
176: FND_MESSAGE.SET_TOKEN('TEXT',

Line 173: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 180: APP_EXCEPTION.Raise_Exception;

176: FND_MESSAGE.SET_TOKEN('TEXT',
177: l_msg_token,
178: FALSE);
179: IF FND_API.To_Boolean(p_called_by_form) THEN
180: APP_EXCEPTION.Raise_Exception;
181: ELSE
182: x_msg_data := FND_MESSAGE.Get;
183: END IF;
184:

Line 278: APP_EXCEPTION.Raise_Exception;

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

Line 286: x_oracle_error := APP_EXCEPTION.Get_Code;

282:
283: WHEN Row_Missing_Error THEN
284: ROLLBACK TO SAVEPOINT Update_Row;
285: x_return_status := 'E';
286: x_oracle_error := APP_EXCEPTION.Get_Code;
287: FND_MESSAGE.SET_NAME('GR',
288: 'GR_NO_RECORD_INSERTED');
289: FND_MESSAGE.SET_TOKEN('CODE',
290: l_msg_token,

Line 293: APP_EXCEPTION.Raise_Exception;

289: FND_MESSAGE.SET_TOKEN('CODE',
290: l_msg_token,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;
294: ELSE
295: x_msg_data := FND_MESSAGE.Get;
296: END IF;
297:

Line 301: x_oracle_error := APP_EXCEPTION.Get_Code;

297:
298: WHEN OTHERS THEN
299: ROLLBACK TO SAVEPOINT Update_Row;
300: x_return_status := 'U';
301: x_oracle_error := APP_EXCEPTION.Get_Code;
302: l_msg_data := APP_EXCEPTION.Get_Text;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_UNEXPECTED_ERROR');
305: FND_MESSAGE.SET_TOKEN('TEXT',

Line 302: l_msg_data := APP_EXCEPTION.Get_Text;

298: WHEN OTHERS THEN
299: ROLLBACK TO SAVEPOINT Update_Row;
300: x_return_status := 'U';
301: x_oracle_error := APP_EXCEPTION.Get_Code;
302: l_msg_data := APP_EXCEPTION.Get_Text;
303: FND_MESSAGE.SET_NAME('GR',
304: 'GR_UNEXPECTED_ERROR');
305: FND_MESSAGE.SET_TOKEN('TEXT',
306: l_msg_token,

Line 309: APP_EXCEPTION.Raise_Exception;

305: FND_MESSAGE.SET_TOKEN('TEXT',
306: l_msg_token,
307: FALSE);
308: IF FND_API.To_Boolean(p_called_by_form) THEN
309: APP_EXCEPTION.Raise_Exception;
310: ELSE
311: x_msg_data := FND_MESSAGE.Get;
312: END IF;
313:

Line 394: APP_EXCEPTION.Raise_Exception;

390: FND_MESSAGE.SET_TOKEN('CODE',
391: l_msg_token,
392: FALSE);
393: IF FND_API.To_Boolean(p_called_by_form) THEN
394: APP_EXCEPTION.Raise_Exception;
395: ELSE
396: x_msg_data := FND_MESSAGE.Get;
397: END IF;
398:

Line 402: x_oracle_error := APP_EXCEPTION.Get_Code;

398:
399: WHEN Row_Already_Locked_Error THEN
400: ROLLBACK TO SAVEPOINT Lock_Row;
401: x_return_status := 'E';
402: x_oracle_error := APP_EXCEPTION.Get_Code;
403: FND_MESSAGE.SET_NAME('GR',
404: 'GR_ROW_IS_LOCKED');
405: IF FND_API.To_Boolean(p_called_by_form) THEN
406: APP_EXCEPTION.Raise_Exception;

Line 406: APP_EXCEPTION.Raise_Exception;

402: x_oracle_error := APP_EXCEPTION.Get_Code;
403: FND_MESSAGE.SET_NAME('GR',
404: 'GR_ROW_IS_LOCKED');
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 414: x_oracle_error := APP_EXCEPTION.Get_Code;

410:
411: WHEN OTHERS THEN
412: ROLLBACK TO SAVEPOINT Lock_Row;
413: x_return_status := 'U';
414: x_oracle_error := APP_EXCEPTION.Get_Code;
415: l_msg_data := APP_EXCEPTION.Get_Text;
416: FND_MESSAGE.SET_NAME('GR',
417: 'GR_UNEXPECTED_ERROR');
418: FND_MESSAGE.SET_TOKEN('TEXT',

Line 415: l_msg_data := APP_EXCEPTION.Get_Text;

411: WHEN OTHERS THEN
412: ROLLBACK TO SAVEPOINT Lock_Row;
413: x_return_status := 'U';
414: x_oracle_error := APP_EXCEPTION.Get_Code;
415: l_msg_data := APP_EXCEPTION.Get_Text;
416: FND_MESSAGE.SET_NAME('GR',
417: 'GR_UNEXPECTED_ERROR');
418: FND_MESSAGE.SET_TOKEN('TEXT',
419: l_msg_token,

Line 422: APP_EXCEPTION.Raise_Exception;

418: FND_MESSAGE.SET_TOKEN('TEXT',
419: l_msg_token,
420: FALSE);
421: IF FND_API.To_Boolean(p_called_by_form) THEN
422: APP_EXCEPTION.Raise_Exception;
423: ELSE
424: x_msg_data := FND_MESSAGE.Get;
425: END IF;
426:

Line 507: APP_EXCEPTION.Raise_Exception;

503: ROLLBACK TO SAVEPOINT Delete_Row;
504: x_return_status := l_return_status;
505: x_oracle_error := l_oracle_error;
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 515: x_oracle_error := APP_EXCEPTION.Get_Code;

511:
512: WHEN Row_Missing_Error THEN
513: ROLLBACK TO SAVEPOINT Delete_Row;
514: x_return_status := 'E';
515: x_oracle_error := APP_EXCEPTION.Get_Code;
516: FND_MESSAGE.SET_NAME('GR',
517: 'GR_RECORD_NOT_FOUND');
518: FND_MESSAGE.SET_TOKEN('CODE',
519: l_msg_token,

Line 522: APP_EXCEPTION.Raise_Exception;

518: FND_MESSAGE.SET_TOKEN('CODE',
519: l_msg_token,
520: FALSE);
521: IF FND_API.To_Boolean(p_called_by_form) THEN
522: APP_EXCEPTION.Raise_Exception;
523: ELSE
524: x_msg_data := FND_MESSAGE.Get;
525: END IF;
526:

Line 530: x_oracle_error := APP_EXCEPTION.Get_Code;

526:
527: WHEN OTHERS THEN
528: ROLLBACK TO SAVEPOINT Delete_Row;
529: x_return_status := 'U';
530: x_oracle_error := APP_EXCEPTION.Get_Code;
531: l_msg_data := APP_EXCEPTION.Get_Text;
532: l_msg_data := APP_EXCEPTION.Get_Text;
533: FND_MESSAGE.SET_NAME('GR',
534: 'GR_UNEXPECTED_ERROR');

Line 531: l_msg_data := APP_EXCEPTION.Get_Text;

527: WHEN OTHERS THEN
528: ROLLBACK TO SAVEPOINT Delete_Row;
529: x_return_status := 'U';
530: x_oracle_error := APP_EXCEPTION.Get_Code;
531: l_msg_data := APP_EXCEPTION.Get_Text;
532: l_msg_data := APP_EXCEPTION.Get_Text;
533: FND_MESSAGE.SET_NAME('GR',
534: 'GR_UNEXPECTED_ERROR');
535: FND_MESSAGE.SET_TOKEN('TEXT',

Line 532: l_msg_data := APP_EXCEPTION.Get_Text;

528: ROLLBACK TO SAVEPOINT Delete_Row;
529: x_return_status := 'U';
530: x_oracle_error := APP_EXCEPTION.Get_Code;
531: l_msg_data := APP_EXCEPTION.Get_Text;
532: l_msg_data := APP_EXCEPTION.Get_Text;
533: FND_MESSAGE.SET_NAME('GR',
534: 'GR_UNEXPECTED_ERROR');
535: FND_MESSAGE.SET_TOKEN('TEXT',
536: l_msg_token,

Line 539: APP_EXCEPTION.Raise_Exception;

535: FND_MESSAGE.SET_TOKEN('TEXT',
536: l_msg_token,
537: FALSE);
538: IF FND_API.To_Boolean(p_called_by_form) THEN
539: APP_EXCEPTION.Raise_Exception;
540: ELSE
541: x_msg_data := FND_MESSAGE.Get;
542: END IF;
543:

Line 589: x_oracle_error := APP_EXCEPTION.Get_Code;

585:
586: WHEN OTHERS THEN
587: ROLLBACK TO SAVEPOINT Delete_Rows;
588: x_return_status := 'U';
589: x_oracle_error := APP_EXCEPTION.Get_Code;
590: l_msg_data := APP_EXCEPTION.Get_Text;
591: FND_MESSAGE.SET_NAME('GR',
592: 'GR_UNEXPECTED_ERROR');
593: FND_MESSAGE.SET_TOKEN('TEXT',

Line 590: l_msg_data := APP_EXCEPTION.Get_Text;

586: WHEN OTHERS THEN
587: ROLLBACK TO SAVEPOINT Delete_Rows;
588: x_return_status := 'U';
589: x_oracle_error := APP_EXCEPTION.Get_Code;
590: l_msg_data := APP_EXCEPTION.Get_Text;
591: FND_MESSAGE.SET_NAME('GR',
592: 'GR_UNEXPECTED_ERROR');
593: FND_MESSAGE.SET_TOKEN('TEXT',
594: l_msg_token,

Line 597: APP_EXCEPTION.Raise_Exception;

593: FND_MESSAGE.SET_TOKEN('TEXT',
594: l_msg_token,
595: FALSE);
596: IF FND_API.To_Boolean(p_called_by_form) THEN
597: APP_EXCEPTION.Raise_Exception;
598: ELSE
599: x_msg_data := FND_MESSAGE.Get;
600: END IF;
601:

Line 649: x_oracle_error := APP_EXCEPTION.Get_Code;

645:
646: WHEN OTHERS THEN
647: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
648: x_return_status := 'U';
649: x_oracle_error := APP_EXCEPTION.Get_Code;
650: l_msg_data := APP_EXCEPTION.Get_Text;
651: FND_MESSAGE.SET_NAME('GR',
652: 'GR_UNEXPECTED_ERROR');
653: FND_MESSAGE.SET_TOKEN('TEXT',

Line 650: l_msg_data := APP_EXCEPTION.Get_Text;

646: WHEN OTHERS THEN
647: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
648: x_return_status := 'U';
649: x_oracle_error := APP_EXCEPTION.Get_Code;
650: l_msg_data := APP_EXCEPTION.Get_Text;
651: FND_MESSAGE.SET_NAME('GR',
652: 'GR_UNEXPECTED_ERROR');
653: FND_MESSAGE.SET_TOKEN('TEXT',
654: l_msg_token,

Line 700: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 701: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 708: APP_EXCEPTION.Raise_Exception;

704: FND_MESSAGE.SET_TOKEN('TEXT',
705: l_msg_data,
706: FALSE);
707: IF FND_API.To_Boolean(p_called_by_form) THEN
708: APP_EXCEPTION.Raise_Exception;
709: ELSE
710: x_msg_data := FND_MESSAGE.Get;
711: END IF;
712:

Line 761: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 768: APP_EXCEPTION.Raise_Exception;

764: FND_MESSAGE.SET_TOKEN('TEXT',
765: l_msg_data,
766: FALSE);
767: IF FND_API.To_Boolean(p_called_by_form) THEN
768: APP_EXCEPTION.Raise_Exception;
769: END IF;
770:
771: END Check_Primary_Key;
772: