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_EXPLOSION_PROP_PKG dependencies on FND_MESSAGE

Line 128: FND_MESSAGE.SET_NAME('GR',

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

Line 130: FND_MESSAGE.SET_TOKEN('TEXT',

126: x_return_status := l_return_status;
127: x_oracle_error := l_oracle_error;
128: FND_MESSAGE.SET_NAME('GR',
129: 'GR_FOREIGN_KEY_ERROR');
130: FND_MESSAGE.SET_TOKEN('TEXT',
131: l_msg_data,
132: FALSE);
133: IF FND_API.To_Boolean(p_called_by_form) THEN
134: APP_EXCEPTION.Raise_Exception;

Line 136: x_msg_data := FND_MESSAGE.Get;

132: FALSE);
133: IF FND_API.To_Boolean(p_called_by_form) THEN
134: APP_EXCEPTION.Raise_Exception;
135: ELSE
136: x_msg_data := FND_MESSAGE.Get;
137: END IF;
138:
139: WHEN Item_Exists_Error THEN
140: ROLLBACK TO SAVEPOINT Insert_Row;

Line 143: FND_MESSAGE.SET_NAME('GR',

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

Line 145: FND_MESSAGE.SET_TOKEN('CODE',

141: x_return_status := 'E';
142: x_oracle_error := APP_EXCEPTION.Get_Code;
143: FND_MESSAGE.SET_NAME('GR',
144: 'GR_RECORD_EXISTS');
145: FND_MESSAGE.SET_TOKEN('CODE',
146: p_inventory_item_id,
147: FALSE);
148: IF FND_API.To_Boolean(p_called_by_form) THEN
149: APP_EXCEPTION.Raise_Exception;

Line 151: x_msg_data := FND_MESSAGE.Get;

147: FALSE);
148: IF FND_API.To_Boolean(p_called_by_form) THEN
149: APP_EXCEPTION.Raise_Exception;
150: ELSE
151: x_msg_data := FND_MESSAGE.Get;
152: END IF;
153:
154: WHEN Row_Missing_Error THEN
155: ROLLBACK TO SAVEPOINT Insert_Row;

Line 158: FND_MESSAGE.SET_NAME('GR',

154: WHEN Row_Missing_Error THEN
155: ROLLBACK TO SAVEPOINT Insert_Row;
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: p_inventory_item_id,
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: p_inventory_item_id,
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 174: FND_MESSAGE.SET_NAME('GR',

170: ROLLBACK TO SAVEPOINT Insert_Row;
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_data,
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_data,
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: p_inventory_item_id,
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: p_inventory_item_id,
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_data,
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_data,
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 387: FND_MESSAGE.SET_NAME('GR',

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

Line 389: FND_MESSAGE.SET_TOKEN('CODE',

385: ROLLBACK TO SAVEPOINT Lock_Row;
386: x_return_status := 'E';
387: FND_MESSAGE.SET_NAME('GR',
388: 'GR_RECORD_NOT_FOUND');
389: FND_MESSAGE.SET_TOKEN('CODE',
390: p_inventory_item_id,
391: FALSE);
392: IF FND_API.To_Boolean(p_called_by_form) THEN
393: APP_EXCEPTION.Raise_Exception;

Line 395: x_msg_data := FND_MESSAGE.Get;

391: FALSE);
392: IF FND_API.To_Boolean(p_called_by_form) THEN
393: APP_EXCEPTION.Raise_Exception;
394: ELSE
395: x_msg_data := FND_MESSAGE.Get;
396: END IF;
397:
398: WHEN Row_Already_Locked_Error THEN
399: ROLLBACK TO SAVEPOINT Lock_Row;

Line 402: FND_MESSAGE.SET_NAME('GR',

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

Line 407: x_msg_data := FND_MESSAGE.Get;

403: 'GR_ROW_IS_LOCKED');
404: IF FND_API.To_Boolean(p_called_by_form) THEN
405: APP_EXCEPTION.Raise_Exception;
406: ELSE
407: x_msg_data := FND_MESSAGE.Get;
408: END IF;
409:
410: WHEN OTHERS THEN
411: ROLLBACK TO SAVEPOINT Lock_Row;

Line 415: FND_MESSAGE.SET_NAME('GR',

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

Line 417: FND_MESSAGE.SET_TOKEN('TEXT',

413: x_oracle_error := APP_EXCEPTION.Get_Code;
414: l_msg_data := APP_EXCEPTION.Get_Text;
415: FND_MESSAGE.SET_NAME('GR',
416: 'GR_UNEXPECTED_ERROR');
417: FND_MESSAGE.SET_TOKEN('TEXT',
418: l_msg_data,
419: FALSE);
420: IF FND_API.To_Boolean(p_called_by_form) THEN
421: APP_EXCEPTION.Raise_Exception;

Line 423: x_msg_data := FND_MESSAGE.Get;

419: FALSE);
420: IF FND_API.To_Boolean(p_called_by_form) THEN
421: APP_EXCEPTION.Raise_Exception;
422: ELSE
423: x_msg_data := FND_MESSAGE.Get;
424: END IF;
425:
426: END Lock_Row;
427:

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

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

Line 585: FND_MESSAGE.SET_TOKEN('TEXT',

581: x_oracle_error := APP_EXCEPTION.Get_Code;
582: l_msg_data := APP_EXCEPTION.Get_Text;
583: FND_MESSAGE.SET_NAME('GR',
584: 'GR_UNEXPECTED_ERROR');
585: FND_MESSAGE.SET_TOKEN('TEXT',
586: l_msg_data,
587: FALSE);
588: x_msg_data := FND_MESSAGE.Get;
589:

Line 588: x_msg_data := FND_MESSAGE.Get;

584: 'GR_UNEXPECTED_ERROR');
585: FND_MESSAGE.SET_TOKEN('TEXT',
586: l_msg_data,
587: FALSE);
588: x_msg_data := FND_MESSAGE.Get;
589:
590: END Check_Foreign_Keys;
591:
592: PROCEDURE Check_Integrity

Line 662: FND_MESSAGE.SET_NAME('GR',

658: EXCEPTION
659:
660: WHEN INTEGRITY_ERROR THEN
661: x_return_status := 'E';
662: FND_MESSAGE.SET_NAME('GR',
663: 'GR_INTEGRITY_HEADER');
664: FND_MESSAGE.SET_TOKEN('CODE',
665: p_inventory_item_id,
666: FALSE);

Line 664: FND_MESSAGE.SET_TOKEN('CODE',

660: WHEN INTEGRITY_ERROR THEN
661: x_return_status := 'E';
662: FND_MESSAGE.SET_NAME('GR',
663: 'GR_INTEGRITY_HEADER');
664: FND_MESSAGE.SET_TOKEN('CODE',
665: p_inventory_item_id,
666: FALSE);
667: FND_MESSAGE.SET_TOKEN('TABLES',
668: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),

Line 667: FND_MESSAGE.SET_TOKEN('TABLES',

663: 'GR_INTEGRITY_HEADER');
664: FND_MESSAGE.SET_TOKEN('CODE',
665: p_inventory_item_id,
666: FALSE);
667: FND_MESSAGE.SET_TOKEN('TABLES',
668: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
669: FALSE);
670: IF FND_API.To_Boolean(p_called_by_form) THEN
671: APP_EXCEPTION.Raise_Exception;

Line 673: x_msg_data := FND_MESSAGE.Get;

669: FALSE);
670: IF FND_API.To_Boolean(p_called_by_form) THEN
671: APP_EXCEPTION.Raise_Exception;
672: ELSE
673: x_msg_data := FND_MESSAGE.Get;
674: END IF;
675: WHEN OTHERS THEN
676: ROLLBACK TO SAVEPOINT Check_Integrity;
677: x_return_status := 'U';

Line 680: FND_MESSAGE.SET_NAME('GR',

676: ROLLBACK TO SAVEPOINT Check_Integrity;
677: x_return_status := 'U';
678: x_oracle_error := APP_EXCEPTION.Get_Code;
679: l_msg_data := APP_EXCEPTION.Get_Text;
680: FND_MESSAGE.SET_NAME('GR',
681: 'GR_UNEXPECTED_ERROR');
682: FND_MESSAGE.SET_TOKEN('TEXT',
683: l_msg_data,
684: FALSE);

Line 682: FND_MESSAGE.SET_TOKEN('TEXT',

678: x_oracle_error := APP_EXCEPTION.Get_Code;
679: l_msg_data := APP_EXCEPTION.Get_Text;
680: FND_MESSAGE.SET_NAME('GR',
681: 'GR_UNEXPECTED_ERROR');
682: FND_MESSAGE.SET_TOKEN('TEXT',
683: l_msg_data,
684: FALSE);
685: IF FND_API.To_Boolean(p_called_by_form) THEN
686: APP_EXCEPTION.Raise_Exception;

Line 688: x_msg_data := FND_MESSAGE.Get;

684: FALSE);
685: IF FND_API.To_Boolean(p_called_by_form) THEN
686: APP_EXCEPTION.Raise_Exception;
687: ELSE
688: x_msg_data := FND_MESSAGE.Get;
689: END IF;
690:
691: END Check_Integrity;
692:

Line 739: FND_MESSAGE.SET_NAME('GR',

735: EXCEPTION
736:
737: WHEN Others THEN
738: l_msg_data := APP_EXCEPTION.Get_Text;
739: FND_MESSAGE.SET_NAME('GR',
740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_data,
743: FALSE);

Line 741: FND_MESSAGE.SET_TOKEN('TEXT',

737: WHEN Others THEN
738: l_msg_data := APP_EXCEPTION.Get_Text;
739: FND_MESSAGE.SET_NAME('GR',
740: 'GR_UNEXPECTED_ERROR');
741: FND_MESSAGE.SET_TOKEN('TEXT',
742: l_msg_data,
743: FALSE);
744: IF FND_API.To_Boolean(p_called_by_form) THEN
745: APP_EXCEPTION.Raise_Exception;