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

Line 292: APP_EXCEPTION.Raise_Exception;

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

Line 300: x_oracle_error := APP_EXCEPTION.Get_Code;

296:
297: WHEN Item_Exists_Error THEN
298: ROLLBACK TO SAVEPOINT Insert_Row;
299: x_return_status := 'E';
300: x_oracle_error := APP_EXCEPTION.Get_Code;
301: FND_MESSAGE.SET_NAME('GR',
302: 'GR_RECORD_EXISTS');
303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_item_code,

Line 307: APP_EXCEPTION.Raise_Exception;

303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_item_code,
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 315: x_oracle_error := APP_EXCEPTION.Get_Code;

311:
312: WHEN Row_Missing_Error THEN
313: ROLLBACK TO SAVEPOINT Insert_Row;
314: x_return_status := 'E';
315: x_oracle_error := APP_EXCEPTION.Get_Code;
316: FND_MESSAGE.SET_NAME('GR',
317: 'GR_NO_RECORD_INSERTED');
318: FND_MESSAGE.SET_TOKEN('CODE',
319: p_item_code,

Line 322: APP_EXCEPTION.Raise_Exception;

318: FND_MESSAGE.SET_TOKEN('CODE',
319: p_item_code,
320: FALSE);
321: IF FND_API.To_Boolean(p_called_by_form) THEN
322: APP_EXCEPTION.Raise_Exception;
323: ELSE
324: x_msg_data := FND_MESSAGE.Get;
325: END IF;
326:

Line 330: x_oracle_error := APP_EXCEPTION.Get_Code;

326:
327: WHEN OTHERS THEN
328: ROLLBACK TO SAVEPOINT Insert_Row;
329: x_return_status := 'U';
330: x_oracle_error := APP_EXCEPTION.Get_Code;
331: l_msg_data := APP_EXCEPTION.Get_Text;
332: FND_MESSAGE.SET_NAME('GR',
333: 'GR_UNEXPECTED_ERROR');
334: FND_MESSAGE.SET_TOKEN('TEXT',

Line 331: l_msg_data := APP_EXCEPTION.Get_Text;

327: WHEN OTHERS THEN
328: ROLLBACK TO SAVEPOINT Insert_Row;
329: x_return_status := 'U';
330: x_oracle_error := APP_EXCEPTION.Get_Code;
331: l_msg_data := APP_EXCEPTION.Get_Text;
332: FND_MESSAGE.SET_NAME('GR',
333: 'GR_UNEXPECTED_ERROR');
334: FND_MESSAGE.SET_TOKEN('TEXT',
335: l_msg_data,

Line 338: APP_EXCEPTION.Raise_Exception;

334: FND_MESSAGE.SET_TOKEN('TEXT',
335: l_msg_data,
336: FALSE);
337: IF FND_API.To_Boolean(p_called_by_form) THEN
338: APP_EXCEPTION.Raise_Exception;
339: ELSE
340: x_msg_data := FND_MESSAGE.Get;
341: END IF;
342:

Line 556: APP_EXCEPTION.Raise_Exception;

552: FND_MESSAGE.SET_TOKEN('TEXT',
553: l_msg_data,
554: FALSE);
555: IF FND_API.To_Boolean(p_called_by_form) THEN
556: APP_EXCEPTION.Raise_Exception;
557: ELSE
558: x_msg_data := FND_MESSAGE.Get;
559: END IF;
560:

Line 564: x_oracle_error := APP_EXCEPTION.Get_Code;

560:
561: WHEN Row_Missing_Error THEN
562: ROLLBACK TO SAVEPOINT Update_Row;
563: x_return_status := 'E';
564: x_oracle_error := APP_EXCEPTION.Get_Code;
565: FND_MESSAGE.SET_NAME('GR',
566: 'GR_NO_RECORD_INSERTED');
567: FND_MESSAGE.SET_TOKEN('CODE',
568: p_item_code,

Line 571: APP_EXCEPTION.Raise_Exception;

567: FND_MESSAGE.SET_TOKEN('CODE',
568: p_item_code,
569: FALSE);
570: IF FND_API.To_Boolean(p_called_by_form) THEN
571: APP_EXCEPTION.Raise_Exception;
572: ELSE
573: x_msg_data := FND_MESSAGE.Get;
574: END IF;
575:

Line 579: x_oracle_error := APP_EXCEPTION.Get_Code;

575:
576: WHEN OTHERS THEN
577: ROLLBACK TO SAVEPOINT Update_Row;
578: x_return_status := 'U';
579: x_oracle_error := APP_EXCEPTION.Get_Code;
580: l_msg_data := APP_EXCEPTION.Get_Text;
581: FND_MESSAGE.SET_NAME('GR',
582: 'GR_UNEXPECTED_ERROR');
583: FND_MESSAGE.SET_TOKEN('TEXT',

Line 580: l_msg_data := APP_EXCEPTION.Get_Text;

576: WHEN OTHERS THEN
577: ROLLBACK TO SAVEPOINT Update_Row;
578: x_return_status := 'U';
579: x_oracle_error := APP_EXCEPTION.Get_Code;
580: l_msg_data := APP_EXCEPTION.Get_Text;
581: FND_MESSAGE.SET_NAME('GR',
582: 'GR_UNEXPECTED_ERROR');
583: FND_MESSAGE.SET_TOKEN('TEXT',
584: l_msg_data,

Line 587: APP_EXCEPTION.Raise_Exception;

583: FND_MESSAGE.SET_TOKEN('TEXT',
584: l_msg_data,
585: FALSE);
586: IF FND_API.To_Boolean(p_called_by_form) THEN
587: APP_EXCEPTION.Raise_Exception;
588: ELSE
589: x_msg_data := FND_MESSAGE.Get;
590: END IF;
591:

Line 711: APP_EXCEPTION.Raise_Exception;

707: FND_MESSAGE.SET_TOKEN('CODE',
708: p_item_code,
709: FALSE);
710: IF FND_API.To_Boolean(p_called_by_form) THEN
711: APP_EXCEPTION.Raise_Exception;
712: ELSE
713: x_msg_data := FND_MESSAGE.Get;
714: END IF;
715:

Line 719: x_oracle_error := APP_EXCEPTION.Get_Code;

715:
716: WHEN Row_Already_Locked_Error THEN
717: ROLLBACK TO SAVEPOINT Lock_Row;
718: x_return_status := 'E';
719: x_oracle_error := APP_EXCEPTION.Get_Code;
720: FND_MESSAGE.SET_NAME('GR',
721: 'GR_ROW_IS_LOCKED');
722: IF FND_API.To_Boolean(p_called_by_form) THEN
723: APP_EXCEPTION.Raise_Exception;

Line 723: APP_EXCEPTION.Raise_Exception;

719: x_oracle_error := APP_EXCEPTION.Get_Code;
720: FND_MESSAGE.SET_NAME('GR',
721: 'GR_ROW_IS_LOCKED');
722: IF FND_API.To_Boolean(p_called_by_form) THEN
723: APP_EXCEPTION.Raise_Exception;
724: ELSE
725: x_msg_data := FND_MESSAGE.Get;
726: END IF;
727:

Line 731: x_oracle_error := APP_EXCEPTION.Get_Code;

727:
728: WHEN OTHERS THEN
729: ROLLBACK TO SAVEPOINT Lock_Row;
730: x_return_status := 'U';
731: x_oracle_error := APP_EXCEPTION.Get_Code;
732: l_msg_data := APP_EXCEPTION.Get_Text;
733: FND_MESSAGE.SET_NAME('GR',
734: 'GR_UNEXPECTED_ERROR');
735: FND_MESSAGE.SET_TOKEN('TEXT',

Line 732: l_msg_data := APP_EXCEPTION.Get_Text;

728: WHEN OTHERS THEN
729: ROLLBACK TO SAVEPOINT Lock_Row;
730: x_return_status := 'U';
731: x_oracle_error := APP_EXCEPTION.Get_Code;
732: l_msg_data := APP_EXCEPTION.Get_Text;
733: FND_MESSAGE.SET_NAME('GR',
734: 'GR_UNEXPECTED_ERROR');
735: FND_MESSAGE.SET_TOKEN('TEXT',
736: l_msg_data,

Line 739: APP_EXCEPTION.Raise_Exception;

735: FND_MESSAGE.SET_TOKEN('TEXT',
736: l_msg_data,
737: FALSE);
738: IF FND_API.To_Boolean(p_called_by_form) THEN
739: APP_EXCEPTION.Raise_Exception;
740: ELSE
741: x_msg_data := FND_MESSAGE.Get;
742: END IF;
743:

Line 904: APP_EXCEPTION.Raise_Exception;

900: ROLLBACK TO SAVEPOINT Delete_Row;
901: x_return_status := l_return_status;
902: x_oracle_error := l_oracle_error;
903: IF FND_API.To_Boolean(p_called_by_form) THEN
904: APP_EXCEPTION.Raise_Exception;
905: ELSE
906: x_msg_data := FND_MESSAGE.Get;
907: END IF;
908:

Line 912: x_oracle_error := APP_EXCEPTION.Get_Code;

908:
909: WHEN Row_Missing_Error THEN
910: ROLLBACK TO SAVEPOINT Delete_Row;
911: x_return_status := 'E';
912: x_oracle_error := APP_EXCEPTION.Get_Code;
913: FND_MESSAGE.SET_NAME('GR',
914: 'GR_RECORD_NOT_FOUND');
915: FND_MESSAGE.SET_TOKEN('CODE',
916: p_item_code,

Line 919: APP_EXCEPTION.Raise_Exception;

915: FND_MESSAGE.SET_TOKEN('CODE',
916: p_item_code,
917: FALSE);
918: IF FND_API.To_Boolean(p_called_by_form) THEN
919: APP_EXCEPTION.Raise_Exception;
920: ELSE
921: x_msg_data := FND_MESSAGE.Get;
922: END IF;
923:

Line 927: x_oracle_error := APP_EXCEPTION.Get_Code;

923:
924: WHEN OTHERS THEN
925: ROLLBACK TO SAVEPOINT Delete_Row;
926: x_return_status := 'U';
927: x_oracle_error := APP_EXCEPTION.Get_Code;
928: l_msg_data := APP_EXCEPTION.Get_Text;
929: l_msg_data := APP_EXCEPTION.Get_Text;
930: FND_MESSAGE.SET_NAME('GR',
931: 'GR_UNEXPECTED_ERROR');

Line 928: l_msg_data := APP_EXCEPTION.Get_Text;

924: WHEN OTHERS THEN
925: ROLLBACK TO SAVEPOINT Delete_Row;
926: x_return_status := 'U';
927: x_oracle_error := APP_EXCEPTION.Get_Code;
928: l_msg_data := APP_EXCEPTION.Get_Text;
929: l_msg_data := APP_EXCEPTION.Get_Text;
930: FND_MESSAGE.SET_NAME('GR',
931: 'GR_UNEXPECTED_ERROR');
932: FND_MESSAGE.SET_TOKEN('TEXT',

Line 929: l_msg_data := APP_EXCEPTION.Get_Text;

925: ROLLBACK TO SAVEPOINT Delete_Row;
926: x_return_status := 'U';
927: x_oracle_error := APP_EXCEPTION.Get_Code;
928: l_msg_data := APP_EXCEPTION.Get_Text;
929: l_msg_data := APP_EXCEPTION.Get_Text;
930: FND_MESSAGE.SET_NAME('GR',
931: 'GR_UNEXPECTED_ERROR');
932: FND_MESSAGE.SET_TOKEN('TEXT',
933: l_msg_data,

Line 936: APP_EXCEPTION.Raise_Exception;

932: FND_MESSAGE.SET_TOKEN('TEXT',
933: l_msg_data,
934: FALSE);
935: IF FND_API.To_Boolean(p_called_by_form) THEN
936: APP_EXCEPTION.Raise_Exception;
937: ELSE
938: x_msg_data := FND_MESSAGE.Get;
939: END IF;
940:

Line 1113: x_oracle_error := APP_EXCEPTION.Get_Code;

1109:
1110: WHEN OTHERS THEN
1111: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1112: x_return_status := 'U';
1113: x_oracle_error := APP_EXCEPTION.Get_Code;
1114: l_msg_data := APP_EXCEPTION.Get_Text;
1115: FND_MESSAGE.SET_NAME('GR',
1116: 'GR_UNEXPECTED_ERROR');
1117: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1114: l_msg_data := APP_EXCEPTION.Get_Text;

1110: WHEN OTHERS THEN
1111: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1112: x_return_status := 'U';
1113: x_oracle_error := APP_EXCEPTION.Get_Code;
1114: l_msg_data := APP_EXCEPTION.Get_Text;
1115: FND_MESSAGE.SET_NAME('GR',
1116: 'GR_UNEXPECTED_ERROR');
1117: FND_MESSAGE.SET_TOKEN('TEXT',
1118: l_msg_data,

Line 1579: APP_EXCEPTION.Raise_Exception;

1575: FND_MESSAGE.SET_TOKEN('TABLES',
1576: SUBSTR(l_msg_data,1,LENGTH(l_msg_data)-1),
1577: FALSE);
1578: IF FND_API.To_Boolean(p_called_by_form) THEN
1579: APP_EXCEPTION.Raise_Exception;
1580: ELSE
1581: x_msg_data := FND_MESSAGE.Get;
1582: END IF;
1583: WHEN OTHERS THEN

Line 1586: x_oracle_error := APP_EXCEPTION.Get_Code;

1582: END IF;
1583: WHEN OTHERS THEN
1584: ROLLBACK TO SAVEPOINT Check_Integrity;
1585: x_return_status := 'U';
1586: x_oracle_error := APP_EXCEPTION.Get_Code;
1587: l_msg_data := APP_EXCEPTION.Get_Text;
1588: FND_MESSAGE.SET_NAME('GR',
1589: 'GR_UNEXPECTED_ERROR');
1590: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1587: l_msg_data := APP_EXCEPTION.Get_Text;

1583: WHEN OTHERS THEN
1584: ROLLBACK TO SAVEPOINT Check_Integrity;
1585: x_return_status := 'U';
1586: x_oracle_error := APP_EXCEPTION.Get_Code;
1587: l_msg_data := APP_EXCEPTION.Get_Text;
1588: FND_MESSAGE.SET_NAME('GR',
1589: 'GR_UNEXPECTED_ERROR');
1590: FND_MESSAGE.SET_TOKEN('TEXT',
1591: l_msg_data,

Line 1594: APP_EXCEPTION.Raise_Exception;

1590: FND_MESSAGE.SET_TOKEN('TEXT',
1591: l_msg_data,
1592: FALSE);
1593: IF FND_API.To_Boolean(p_called_by_form) THEN
1594: APP_EXCEPTION.Raise_Exception;
1595: ELSE
1596: x_msg_data := FND_MESSAGE.Get;
1597: END IF;
1598:

Line 1644: l_msg_data := APP_EXCEPTION.Get_Text;

1640:
1641: EXCEPTION
1642:
1643: WHEN Others THEN
1644: l_msg_data := APP_EXCEPTION.Get_Text;
1645: FND_MESSAGE.SET_NAME('GR',
1646: 'GR_UNEXPECTED_ERROR');
1647: FND_MESSAGE.SET_TOKEN('TEXT',
1648: l_msg_data,

Line 1651: APP_EXCEPTION.Raise_Exception;

1647: FND_MESSAGE.SET_TOKEN('TEXT',
1648: l_msg_data,
1649: FALSE);
1650: IF FND_API.To_Boolean(p_called_by_form) THEN
1651: APP_EXCEPTION.Raise_Exception;
1652: END IF;
1653:
1654: END Check_Primary_Key;
1655: