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 FND_MESSAGE

Line 126: FND_MESSAGE.SET_NAME('GR',

122: WHEN Foreign_Key_Error THEN
123: ROLLBACK TO SAVEPOINT Insert_Row;
124: x_return_status := l_return_status;
125: x_oracle_error := l_oracle_error;
126: FND_MESSAGE.SET_NAME('GR',
127: 'GR_FOREIGN_KEY_ERROR');
128: FND_MESSAGE.SET_TOKEN('TEXT',
129: l_msg_data,
130: FALSE);

Line 128: FND_MESSAGE.SET_TOKEN('TEXT',

124: x_return_status := l_return_status;
125: x_oracle_error := l_oracle_error;
126: FND_MESSAGE.SET_NAME('GR',
127: 'GR_FOREIGN_KEY_ERROR');
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;

Line 134: x_msg_data := FND_MESSAGE.Get;

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:
137: WHEN Item_Exists_Error THEN
138: ROLLBACK TO SAVEPOINT Insert_Row;

Line 142: FND_MESSAGE.SET_NAME('GR',

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,
146: FALSE);

Line 144: FND_MESSAGE.SET_TOKEN('CODE',

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,
146: FALSE);
147: IF FND_API.To_Boolean(p_called_by_form) THEN
148: APP_EXCEPTION.Raise_Exception;

Line 150: x_msg_data := FND_MESSAGE.Get;

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:
153: WHEN Row_Missing_Error THEN
154: ROLLBACK TO SAVEPOINT Insert_Row;

Line 158: FND_MESSAGE.SET_NAME('GR',

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,
162: FALSE);

Line 160: FND_MESSAGE.SET_TOKEN('CODE',

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,
162: FALSE);
163: IF FND_API.To_Boolean(p_called_by_form) THEN
164: APP_EXCEPTION.Raise_Exception;

Line 166: x_msg_data := FND_MESSAGE.Get;

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:
169: WHEN OTHERS THEN
170: ROLLBACK TO SAVEPOINT Insert_Row;

Line 175: FND_MESSAGE.SET_NAME('GR',

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,
179: FALSE);

Line 177: FND_MESSAGE.SET_TOKEN('TEXT',

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,
179: FALSE);
180: IF FND_API.To_Boolean(p_called_by_form) THEN
181: APP_EXCEPTION.Raise_Exception;

Line 183: x_msg_data := FND_MESSAGE.Get;

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:
186: END Insert_Row;
187:

Line 272: FND_MESSAGE.SET_NAME('GR',

268: WHEN Foreign_Key_Error THEN
269: ROLLBACK TO SAVEPOINT Update_Row;
270: x_return_status := l_return_status;
271: x_oracle_error := l_oracle_error;
272: FND_MESSAGE.SET_NAME('GR',
273: 'GR_FOREIGN_KEY_ERROR');
274: FND_MESSAGE.SET_TOKEN('TEXT',
275: l_msg_data,
276: FALSE);

Line 274: FND_MESSAGE.SET_TOKEN('TEXT',

270: x_return_status := l_return_status;
271: x_oracle_error := l_oracle_error;
272: FND_MESSAGE.SET_NAME('GR',
273: 'GR_FOREIGN_KEY_ERROR');
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;

Line 280: x_msg_data := FND_MESSAGE.Get;

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:
283: WHEN Row_Missing_Error THEN
284: ROLLBACK TO SAVEPOINT Update_Row;

Line 287: FND_MESSAGE.SET_NAME('GR',

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,
291: FALSE);

Line 289: FND_MESSAGE.SET_TOKEN('CODE',

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,
291: FALSE);
292: IF FND_API.To_Boolean(p_called_by_form) THEN
293: APP_EXCEPTION.Raise_Exception;

Line 295: x_msg_data := FND_MESSAGE.Get;

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:
298: WHEN OTHERS THEN
299: ROLLBACK TO SAVEPOINT Update_Row;

Line 303: FND_MESSAGE.SET_NAME('GR',

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,
307: FALSE);

Line 305: FND_MESSAGE.SET_TOKEN('TEXT',

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,
307: FALSE);
308: IF FND_API.To_Boolean(p_called_by_form) THEN
309: APP_EXCEPTION.Raise_Exception;

Line 311: x_msg_data := FND_MESSAGE.Get;

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:
314: END Update_Row;
315:

Line 388: FND_MESSAGE.SET_NAME('GR',

384:
385: WHEN No_Data_Found_Error THEN
386: ROLLBACK TO SAVEPOINT Lock_Row;
387: x_return_status := 'E';
388: FND_MESSAGE.SET_NAME('GR',
389: 'GR_RECORD_NOT_FOUND');
390: FND_MESSAGE.SET_TOKEN('CODE',
391: l_msg_token,
392: FALSE);

Line 390: FND_MESSAGE.SET_TOKEN('CODE',

386: ROLLBACK TO SAVEPOINT Lock_Row;
387: x_return_status := 'E';
388: FND_MESSAGE.SET_NAME('GR',
389: 'GR_RECORD_NOT_FOUND');
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;

Line 396: x_msg_data := FND_MESSAGE.Get;

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:
399: WHEN Row_Already_Locked_Error THEN
400: ROLLBACK TO SAVEPOINT Lock_Row;

Line 403: FND_MESSAGE.SET_NAME('GR',

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;
407: ELSE

Line 408: x_msg_data := FND_MESSAGE.Get;

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:
411: WHEN OTHERS THEN
412: ROLLBACK TO SAVEPOINT Lock_Row;

Line 416: FND_MESSAGE.SET_NAME('GR',

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,
420: FALSE);

Line 418: FND_MESSAGE.SET_TOKEN('TEXT',

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,
420: FALSE);
421: IF FND_API.To_Boolean(p_called_by_form) THEN
422: APP_EXCEPTION.Raise_Exception;

Line 424: x_msg_data := FND_MESSAGE.Get;

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:
427: END Lock_Row;
428:

Line 508: x_msg_data := FND_MESSAGE.Get;

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:
511: WHEN Row_Missing_Error THEN
512: ROLLBACK TO SAVEPOINT Delete_Row;

Line 515: FND_MESSAGE.SET_NAME('GR',

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,
519: FALSE);

Line 517: FND_MESSAGE.SET_TOKEN('CODE',

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,
519: FALSE);
520: IF FND_API.To_Boolean(p_called_by_form) THEN
521: APP_EXCEPTION.Raise_Exception;

Line 523: x_msg_data := FND_MESSAGE.Get;

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:
526: WHEN OTHERS THEN
527: ROLLBACK TO SAVEPOINT Delete_Row;

Line 532: FND_MESSAGE.SET_NAME('GR',

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,
536: FALSE);

Line 534: FND_MESSAGE.SET_TOKEN('TEXT',

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,
536: FALSE);
537: IF FND_API.To_Boolean(p_called_by_form) THEN
538: APP_EXCEPTION.Raise_Exception;

Line 540: x_msg_data := FND_MESSAGE.Get;

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:
543: END Delete_Row;
544:

Line 592: FND_MESSAGE.SET_NAME('GR',

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,
596: FALSE);

Line 594: FND_MESSAGE.SET_TOKEN('TEXT',

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,
596: FALSE);
597: IF FND_API.To_Boolean(p_called_by_form) THEN
598: APP_EXCEPTION.Raise_Exception;

Line 600: x_msg_data := FND_MESSAGE.Get;

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:
603: END Delete_Rows;
604:

Line 651: FND_MESSAGE.SET_NAME('GR',

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,
655: FALSE);

Line 653: FND_MESSAGE.SET_TOKEN('TEXT',

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,
655: FALSE);
656: x_msg_data := FND_MESSAGE.Get;
657:

Line 656: x_msg_data := FND_MESSAGE.Get;

652: 'GR_UNEXPECTED_ERROR');
653: FND_MESSAGE.SET_TOKEN('TEXT',
654: l_msg_token,
655: FALSE);
656: x_msg_data := FND_MESSAGE.Get;
657:
658: END Check_Foreign_Keys;
659:
660: PROCEDURE Check_Integrity

Line 701: FND_MESSAGE.SET_NAME('GR',

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,
705: FALSE);

Line 703: FND_MESSAGE.SET_TOKEN('TEXT',

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,
705: FALSE);
706: IF FND_API.To_Boolean(p_called_by_form) THEN
707: APP_EXCEPTION.Raise_Exception;

Line 709: x_msg_data := FND_MESSAGE.Get;

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:
712: END Check_Integrity;
713:

Line 763: FND_MESSAGE.SET_NAME('GR',

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,
767: FALSE);

Line 765: FND_MESSAGE.SET_TOKEN('TEXT',

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,
767: FALSE);
768: IF FND_API.To_Boolean(p_called_by_form) THEN
769: APP_EXCEPTION.Raise_Exception;