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 FND_MESSAGE

Line 125: FND_MESSAGE.SET_NAME('GR',

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

Line 127: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 133: x_msg_data := FND_MESSAGE.Get;

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

Line 141: FND_MESSAGE.SET_NAME('GR',

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

Line 143: FND_MESSAGE.SET_TOKEN('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,
145: FALSE);
146: IF FND_API.To_Boolean(p_called_by_form) THEN
147: APP_EXCEPTION.Raise_Exception;

Line 149: x_msg_data := FND_MESSAGE.Get;

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

Line 157: FND_MESSAGE.SET_NAME('GR',

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

Line 159: FND_MESSAGE.SET_TOKEN('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,
161: FALSE);
162: IF FND_API.To_Boolean(p_called_by_form) THEN
163: APP_EXCEPTION.Raise_Exception;

Line 165: x_msg_data := FND_MESSAGE.Get;

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

Line 174: FND_MESSAGE.SET_NAME('GR',

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

Line 176: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 182: x_msg_data := FND_MESSAGE.Get;

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

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 509: x_msg_data := FND_MESSAGE.Get;

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

Line 516: FND_MESSAGE.SET_NAME('GR',

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

Line 518: FND_MESSAGE.SET_TOKEN('CODE',

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

Line 524: x_msg_data := FND_MESSAGE.Get;

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

Line 533: FND_MESSAGE.SET_NAME('GR',

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

Line 535: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 541: x_msg_data := FND_MESSAGE.Get;

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

Line 591: FND_MESSAGE.SET_NAME('GR',

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

Line 593: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 599: x_msg_data := FND_MESSAGE.Get;

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

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 702: FND_MESSAGE.SET_NAME('GR',

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

Line 704: FND_MESSAGE.SET_TOKEN('TEXT',

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

Line 710: x_msg_data := FND_MESSAGE.Get;

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

Line 762: FND_MESSAGE.SET_NAME('GR',

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

Line 764: FND_MESSAGE.SET_TOKEN('TEXT',

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