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

Line 130: APP_EXCEPTION.Raise_Exception;

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

Line 139: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 146: APP_EXCEPTION.Raise_Exception;

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

Line 155: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 162: APP_EXCEPTION.Raise_Exception;

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

Line 171: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 172: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 179: APP_EXCEPTION.Raise_Exception;

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

Line 276: APP_EXCEPTION.Raise_Exception;

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

Line 284: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 291: APP_EXCEPTION.Raise_Exception;

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

Line 299: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 300: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 307: APP_EXCEPTION.Raise_Exception;

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

Line 390: APP_EXCEPTION.Raise_Exception;

386: FND_MESSAGE.SET_TOKEN('CODE',
387: l_msg_token,
388: FALSE);
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 Row_Already_Locked_Error THEN
396: ROLLBACK TO SAVEPOINT Lock_Row;
397: x_return_status := 'E';
398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: FND_MESSAGE.SET_NAME('GR',
400: 'GR_ROW_IS_LOCKED');
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;

Line 402: APP_EXCEPTION.Raise_Exception;

398: x_oracle_error := APP_EXCEPTION.Get_Code;
399: FND_MESSAGE.SET_NAME('GR',
400: 'GR_ROW_IS_LOCKED');
401: IF FND_API.To_Boolean(p_called_by_form) THEN
402: APP_EXCEPTION.Raise_Exception;
403: ELSE
404: x_msg_data := FND_MESSAGE.Get;
405: END IF;
406:

Line 410: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 411: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 418: APP_EXCEPTION.Raise_Exception;

414: FND_MESSAGE.SET_TOKEN('TEXT',
415: l_msg_token,
416: FALSE);
417: IF FND_API.To_Boolean(p_called_by_form) THEN
418: APP_EXCEPTION.Raise_Exception;
419: ELSE
420: x_msg_data := FND_MESSAGE.Get;
421: END IF;
422:

Line 502: APP_EXCEPTION.Raise_Exception;

498: ROLLBACK TO SAVEPOINT Delete_Row;
499: x_return_status := l_return_status;
500: x_oracle_error := l_oracle_error;
501: IF FND_API.To_Boolean(p_called_by_form) THEN
502: APP_EXCEPTION.Raise_Exception;
503: ELSE
504: x_msg_data := FND_MESSAGE.Get;
505: END IF;
506:

Line 510: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 517: APP_EXCEPTION.Raise_Exception;

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

Line 525: x_oracle_error := APP_EXCEPTION.Get_Code;

521:
522: WHEN OTHERS THEN
523: ROLLBACK TO SAVEPOINT Delete_Row;
524: x_return_status := 'U';
525: x_oracle_error := APP_EXCEPTION.Get_Code;
526: l_msg_data := APP_EXCEPTION.Get_Text;
527: l_msg_data := APP_EXCEPTION.Get_Text;
528: FND_MESSAGE.SET_NAME('GR',
529: 'GR_UNEXPECTED_ERROR');

Line 526: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 527: l_msg_data := APP_EXCEPTION.Get_Text;

523: ROLLBACK TO SAVEPOINT Delete_Row;
524: x_return_status := 'U';
525: x_oracle_error := APP_EXCEPTION.Get_Code;
526: l_msg_data := APP_EXCEPTION.Get_Text;
527: l_msg_data := APP_EXCEPTION.Get_Text;
528: FND_MESSAGE.SET_NAME('GR',
529: 'GR_UNEXPECTED_ERROR');
530: FND_MESSAGE.SET_TOKEN('TEXT',
531: l_msg_token,

Line 534: APP_EXCEPTION.Raise_Exception;

530: FND_MESSAGE.SET_TOKEN('TEXT',
531: l_msg_token,
532: FALSE);
533: IF FND_API.To_Boolean(p_called_by_form) THEN
534: APP_EXCEPTION.Raise_Exception;
535: ELSE
536: x_msg_data := FND_MESSAGE.Get;
537: END IF;
538:

Line 584: x_oracle_error := APP_EXCEPTION.Get_Code;

580:
581: WHEN OTHERS THEN
582: ROLLBACK TO SAVEPOINT Delete_Rows;
583: x_return_status := 'U';
584: x_oracle_error := APP_EXCEPTION.Get_Code;
585: l_msg_data := APP_EXCEPTION.Get_Text;
586: FND_MESSAGE.SET_NAME('GR',
587: 'GR_UNEXPECTED_ERROR');
588: FND_MESSAGE.SET_TOKEN('TEXT',

Line 585: l_msg_data := APP_EXCEPTION.Get_Text;

581: WHEN OTHERS THEN
582: ROLLBACK TO SAVEPOINT Delete_Rows;
583: x_return_status := 'U';
584: x_oracle_error := APP_EXCEPTION.Get_Code;
585: l_msg_data := APP_EXCEPTION.Get_Text;
586: FND_MESSAGE.SET_NAME('GR',
587: 'GR_UNEXPECTED_ERROR');
588: FND_MESSAGE.SET_TOKEN('TEXT',
589: l_msg_token,

Line 592: APP_EXCEPTION.Raise_Exception;

588: FND_MESSAGE.SET_TOKEN('TEXT',
589: l_msg_token,
590: FALSE);
591: IF FND_API.To_Boolean(p_called_by_form) THEN
592: APP_EXCEPTION.Raise_Exception;
593: ELSE
594: x_msg_data := FND_MESSAGE.Get;
595: END IF;
596:

Line 645: x_oracle_error := APP_EXCEPTION.Get_Code;

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

Line 646: l_msg_data := APP_EXCEPTION.Get_Text;

642: WHEN OTHERS THEN
643: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
644: x_return_status := 'U';
645: x_oracle_error := APP_EXCEPTION.Get_Code;
646: l_msg_data := APP_EXCEPTION.Get_Text;
647: FND_MESSAGE.SET_NAME('GR',
648: 'GR_UNEXPECTED_ERROR');
649: FND_MESSAGE.SET_TOKEN('TEXT',
650: 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 763: l_msg_data := APP_EXCEPTION.Get_Text;

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

Line 770: APP_EXCEPTION.Raise_Exception;

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