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

Line 132: APP_EXCEPTION.Raise_Exception;

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

Line 141: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 148: APP_EXCEPTION.Raise_Exception;

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

Line 157: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 164: APP_EXCEPTION.Raise_Exception;

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

Line 173: x_oracle_error := APP_EXCEPTION.Get_Code;

169: WHEN OTHERS THEN
170: ROLLBACK TO SAVEPOINT Insert_Row;
171: l_msg_token := p_product_item_id;
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: ROLLBACK TO SAVEPOINT Insert_Row;
171: l_msg_token := p_product_item_id;
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_token,

Line 181: APP_EXCEPTION.Raise_Exception;

177: FND_MESSAGE.SET_TOKEN('TEXT',
178: l_msg_token,
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 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 506: APP_EXCEPTION.Raise_Exception;

502: ROLLBACK TO SAVEPOINT Delete_Row;
503: x_return_status := l_return_status;
504: x_oracle_error := l_oracle_error;
505: IF FND_API.To_Boolean(p_called_by_form) THEN
506: APP_EXCEPTION.Raise_Exception;
507: ELSE
508: x_msg_data := FND_MESSAGE.Get;
509: END IF;
510:

Line 514: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 521: APP_EXCEPTION.Raise_Exception;

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

Line 529: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 530: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 531: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 538: APP_EXCEPTION.Raise_Exception;

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

Line 590: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 591: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 598: APP_EXCEPTION.Raise_Exception;

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

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 699: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 700: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 707: APP_EXCEPTION.Raise_Exception;

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

Line 762: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 769: APP_EXCEPTION.Raise_Exception;

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