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_GENERIC_ITEMS_B_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 Label_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 || ' ' || p_item_no,

Line 307: APP_EXCEPTION.Raise_Exception;

303: FND_MESSAGE.SET_TOKEN('CODE',
304: p_item_code || ' ' || p_item_no,
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 || ' ' || p_item_no,

Line 322: APP_EXCEPTION.Raise_Exception;

318: FND_MESSAGE.SET_TOKEN('CODE',
319: p_item_code || ' ' || p_item_no,
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 336: x_oracle_error := APP_EXCEPTION.Get_Code;

332: */
333: WHEN Reg_Item_Error THEN
334: ROLLBACK TO SAVEPOINT Insert_Row;
335: x_return_status := 'E';
336: x_oracle_error := APP_EXCEPTION.Get_Code;
337: FND_MESSAGE.SET_NAME('GR',
338: 'GR_REG_ITEM');
339: FND_MESSAGE.SET_TOKEN('ITEM',
340: p_item_no,

Line 343: APP_EXCEPTION.Raise_Exception;

339: FND_MESSAGE.SET_TOKEN('ITEM',
340: p_item_no,
341: FALSE);
342: IF FND_API.To_Boolean(p_called_by_form) THEN
343: APP_EXCEPTION.Raise_Exception;
344: ELSE
345: x_msg_data := FND_MESSAGE.Get;
346: END IF;
347:

Line 351: x_oracle_error := APP_EXCEPTION.Get_Code;

347:
348: WHEN Already_Linked_Error THEN
349: ROLLBACK TO SAVEPOINT Insert_Row;
350: x_return_status := 'E';
351: x_oracle_error := APP_EXCEPTION.Get_Code;
352: FND_MESSAGE.SET_NAME('GR',
353: 'GR_ALREADY_LINKED');
354: FND_MESSAGE.SET_TOKEN('INV_ITEM',
355: p_item_no,

Line 361: APP_EXCEPTION.Raise_Exception;

357: FND_MESSAGE.SET_TOKEN('REG_ITEM',
358: p_item_code,
359: FALSE);
360: IF FND_API.To_Boolean(p_called_by_form) THEN
361: APP_EXCEPTION.Raise_Exception;
362: ELSE
363: x_msg_data := FND_MESSAGE.Get;
364: END IF;
365: /* Melanie Grosser 23-Jan-2003 BUG 2761024 - End of changes */

Line 370: x_oracle_error := APP_EXCEPTION.Get_Code;

366:
367: WHEN OTHERS THEN
368: ROLLBACK TO SAVEPOINT Insert_Row;
369: x_return_status := 'U';
370: x_oracle_error := APP_EXCEPTION.Get_Code;
371: l_msg_data := APP_EXCEPTION.Get_Text;
372: FND_MESSAGE.SET_NAME('GR',
373: 'GR_UNEXPECTED_ERROR');
374: FND_MESSAGE.SET_TOKEN('TEXT',

Line 371: l_msg_data := APP_EXCEPTION.Get_Text;

367: WHEN OTHERS THEN
368: ROLLBACK TO SAVEPOINT Insert_Row;
369: x_return_status := 'U';
370: x_oracle_error := APP_EXCEPTION.Get_Code;
371: l_msg_data := APP_EXCEPTION.Get_Text;
372: FND_MESSAGE.SET_NAME('GR',
373: 'GR_UNEXPECTED_ERROR');
374: FND_MESSAGE.SET_TOKEN('TEXT',
375: l_msg_data,

Line 378: APP_EXCEPTION.Raise_Exception;

374: FND_MESSAGE.SET_TOKEN('TEXT',
375: l_msg_data,
376: FALSE);
377: IF FND_API.To_Boolean(p_called_by_form) THEN
378: APP_EXCEPTION.Raise_Exception;
379: ELSE
380: x_msg_data := FND_MESSAGE.Get;
381: END IF;
382:

Line 567: APP_EXCEPTION.Raise_Exception;

563: FND_MESSAGE.SET_TOKEN('TEXT',
564: l_msg_data,
565: FALSE);
566: IF FND_API.To_Boolean(p_called_by_form) THEN
567: APP_EXCEPTION.Raise_Exception;
568: ELSE
569: x_msg_data := FND_MESSAGE.Get;
570: END IF;
571:

Line 575: x_oracle_error := APP_EXCEPTION.Get_Code;

571:
572: WHEN Row_Missing_Error THEN
573: ROLLBACK TO SAVEPOINT Update_Row;
574: x_return_status := 'E';
575: x_oracle_error := APP_EXCEPTION.Get_Code;
576: FND_MESSAGE.SET_NAME('GR',
577: 'GR_NO_RECORD_INSERTED');
578: FND_MESSAGE.SET_TOKEN('CODE',
579: p_item_code || ' ' || p_item_no,

Line 582: APP_EXCEPTION.Raise_Exception;

578: FND_MESSAGE.SET_TOKEN('CODE',
579: p_item_code || ' ' || p_item_no,
580: FALSE);
581: IF FND_API.To_Boolean(p_called_by_form) THEN
582: APP_EXCEPTION.Raise_Exception;
583: ELSE
584: x_msg_data := FND_MESSAGE.Get;
585: END IF;
586:

Line 590: x_oracle_error := APP_EXCEPTION.Get_Code;

586:
587: WHEN OTHERS THEN
588: ROLLBACK TO SAVEPOINT Update_Row;
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',

Line 591: l_msg_data := APP_EXCEPTION.Get_Text;

587: WHEN OTHERS THEN
588: ROLLBACK TO SAVEPOINT Update_Row;
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_data,

Line 598: APP_EXCEPTION.Raise_Exception;

594: FND_MESSAGE.SET_TOKEN('TEXT',
595: l_msg_data,
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:

Line 716: APP_EXCEPTION.Raise_Exception;

712: FND_MESSAGE.SET_TOKEN('CODE',
713: p_item_code || ' ' || p_item_no,
714: FALSE);
715: IF FND_API.To_Boolean(p_called_by_form) THEN
716: APP_EXCEPTION.Raise_Exception;
717: ELSE
718: x_msg_data := FND_MESSAGE.Get;
719: END IF;
720:

Line 727: APP_EXCEPTION.Raise_Exception;

723: X_return_status := 'E';
724: FND_MESSAGE.SET_NAME('FND',
725: 'FORM_RECORD_CHANGED');
726: IF FND_API.To_Boolean(p_called_by_form) THEN
727: APP_EXCEPTION.Raise_Exception;
728: ELSE
729: x_msg_data := FND_MESSAGE.Get;
730: END IF;
731: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

Line 731: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN

727: APP_EXCEPTION.Raise_Exception;
728: ELSE
729: x_msg_data := FND_MESSAGE.Get;
730: END IF;
731: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
732: ROLLBACK TO SAVEPOINT Lock_Row;
733: x_return_status := 'L';
734: x_oracle_error := APP_EXCEPTION.Get_Code;
735: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN

Line 734: x_oracle_error := APP_EXCEPTION.Get_Code;

730: END IF;
731: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
732: ROLLBACK TO SAVEPOINT Lock_Row;
733: x_return_status := 'L';
734: x_oracle_error := APP_EXCEPTION.Get_Code;
735: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
736: FND_MESSAGE.SET_NAME('GR',
737: 'GR_ROW_IS_LOCKED');
738: x_msg_data := FND_MESSAGE.Get;

Line 745: x_oracle_error := APP_EXCEPTION.Get_Code;

741:
742: WHEN OTHERS THEN
743: ROLLBACK TO SAVEPOINT Lock_Row;
744: x_return_status := 'U';
745: x_oracle_error := APP_EXCEPTION.Get_Code;
746: l_msg_data := APP_EXCEPTION.Get_Text;
747: FND_MESSAGE.SET_NAME('GR',
748: 'GR_UNEXPECTED_ERROR');
749: FND_MESSAGE.SET_TOKEN('TEXT',

Line 746: l_msg_data := APP_EXCEPTION.Get_Text;

742: WHEN OTHERS THEN
743: ROLLBACK TO SAVEPOINT Lock_Row;
744: x_return_status := 'U';
745: x_oracle_error := APP_EXCEPTION.Get_Code;
746: l_msg_data := APP_EXCEPTION.Get_Text;
747: FND_MESSAGE.SET_NAME('GR',
748: 'GR_UNEXPECTED_ERROR');
749: FND_MESSAGE.SET_TOKEN('TEXT',
750: l_msg_data,

Line 753: APP_EXCEPTION.Raise_Exception;

749: FND_MESSAGE.SET_TOKEN('TEXT',
750: l_msg_data,
751: FALSE);
752: IF FND_API.To_Boolean(p_called_by_form) THEN
753: APP_EXCEPTION.Raise_Exception;
754: ELSE
755: x_msg_data := FND_MESSAGE.Get;
756: END IF;
757:

Line 898: APP_EXCEPTION.Raise_Exception;

894: ROLLBACK TO SAVEPOINT Delete_Row;
895: x_return_status := l_return_status;
896: x_oracle_error := l_oracle_error;
897: IF FND_API.To_Boolean(p_called_by_form) THEN
898: APP_EXCEPTION.Raise_Exception;
899: ELSE
900: x_msg_data := FND_MESSAGE.Get;
901: END IF;
902:

Line 906: x_oracle_error := APP_EXCEPTION.Get_Code;

902:
903: WHEN Row_Missing_Error THEN
904: ROLLBACK TO SAVEPOINT Delete_Row;
905: x_return_status := 'E';
906: x_oracle_error := APP_EXCEPTION.Get_Code;
907: FND_MESSAGE.SET_NAME('GR',
908: 'GR_RECORD_NOT_FOUND');
909: FND_MESSAGE.SET_TOKEN('CODE',
910: p_item_code || ' ' || p_item_no,

Line 913: APP_EXCEPTION.Raise_Exception;

909: FND_MESSAGE.SET_TOKEN('CODE',
910: p_item_code || ' ' || p_item_no,
911: FALSE);
912: IF FND_API.To_Boolean(p_called_by_form) THEN
913: APP_EXCEPTION.Raise_Exception;
914: ELSE
915: x_msg_data := FND_MESSAGE.Get;
916: END IF;
917:

Line 921: x_oracle_error := APP_EXCEPTION.Get_Code;

917:
918: WHEN OTHERS THEN
919: ROLLBACK TO SAVEPOINT Delete_Row;
920: x_return_status := 'U';
921: x_oracle_error := APP_EXCEPTION.Get_Code;
922: l_msg_data := APP_EXCEPTION.Get_Text;
923: l_msg_data := APP_EXCEPTION.Get_Text;
924: FND_MESSAGE.SET_NAME('GR',
925: 'GR_UNEXPECTED_ERROR');

Line 922: l_msg_data := APP_EXCEPTION.Get_Text;

918: WHEN OTHERS THEN
919: ROLLBACK TO SAVEPOINT Delete_Row;
920: x_return_status := 'U';
921: x_oracle_error := APP_EXCEPTION.Get_Code;
922: l_msg_data := APP_EXCEPTION.Get_Text;
923: l_msg_data := APP_EXCEPTION.Get_Text;
924: FND_MESSAGE.SET_NAME('GR',
925: 'GR_UNEXPECTED_ERROR');
926: FND_MESSAGE.SET_TOKEN('TEXT',

Line 923: l_msg_data := APP_EXCEPTION.Get_Text;

919: ROLLBACK TO SAVEPOINT Delete_Row;
920: x_return_status := 'U';
921: x_oracle_error := APP_EXCEPTION.Get_Code;
922: l_msg_data := APP_EXCEPTION.Get_Text;
923: l_msg_data := APP_EXCEPTION.Get_Text;
924: FND_MESSAGE.SET_NAME('GR',
925: 'GR_UNEXPECTED_ERROR');
926: FND_MESSAGE.SET_TOKEN('TEXT',
927: l_msg_data,

Line 930: APP_EXCEPTION.Raise_Exception;

926: FND_MESSAGE.SET_TOKEN('TEXT',
927: l_msg_data,
928: FALSE);
929: IF FND_API.To_Boolean(p_called_by_form) THEN
930: APP_EXCEPTION.Raise_Exception;
931: ELSE
932: x_msg_data := FND_MESSAGE.Get;
933: END IF;
934:

Line 1007: x_oracle_error := APP_EXCEPTION.Get_Code;

1003: EXCEPTION
1004:
1005: WHEN Null_Delete_Option_Error THEN
1006: x_return_status := 'E';
1007: x_oracle_error := APP_EXCEPTION.Get_Code;
1008: FND_MESSAGE.SET_NAME('GR',
1009: 'GR_NULL_VALUE');
1010: FND_MESSAGE.SET_TOKEN('CODE',
1011: l_msg_token,

Line 1014: APP_EXCEPTION.Raise_Exception;

1010: FND_MESSAGE.SET_TOKEN('CODE',
1011: l_msg_token,
1012: FALSE);
1013: IF FND_API.To_Boolean(p_called_by_form) THEN
1014: APP_EXCEPTION.Raise_Exception;
1015: ELSE
1016: x_msg_data := FND_MESSAGE.Get;
1017: END IF;
1018:

Line 1022: x_oracle_error := APP_EXCEPTION.Get_Code;

1018:
1019: WHEN OTHERS THEN
1020: ROLLBACK TO SAVEPOINT Delete_Rows;
1021: x_return_status := 'U';
1022: x_oracle_error := APP_EXCEPTION.Get_Code;
1023: l_msg_data := APP_EXCEPTION.Get_Text;
1024: FND_MESSAGE.SET_NAME('GR',
1025: 'GR_UNEXPECTED_ERROR');
1026: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1023: l_msg_data := APP_EXCEPTION.Get_Text;

1019: WHEN OTHERS THEN
1020: ROLLBACK TO SAVEPOINT Delete_Rows;
1021: x_return_status := 'U';
1022: x_oracle_error := APP_EXCEPTION.Get_Code;
1023: l_msg_data := APP_EXCEPTION.Get_Text;
1024: FND_MESSAGE.SET_NAME('GR',
1025: 'GR_UNEXPECTED_ERROR');
1026: FND_MESSAGE.SET_TOKEN('TEXT',
1027: l_msg_token,

Line 1030: APP_EXCEPTION.Raise_Exception;

1026: FND_MESSAGE.SET_TOKEN('TEXT',
1027: l_msg_token,
1028: FALSE);
1029: IF FND_API.To_Boolean(p_called_by_form) THEN
1030: APP_EXCEPTION.Raise_Exception;
1031: ELSE
1032: x_msg_data := FND_MESSAGE.Get;
1033: END IF;
1034:

Line 1174: x_oracle_error := APP_EXCEPTION.Get_Code;

1170:
1171: WHEN OTHERS THEN
1172: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1173: x_return_status := 'U';
1174: x_oracle_error := APP_EXCEPTION.Get_Code;
1175: l_msg_data := APP_EXCEPTION.Get_Text;
1176: FND_MESSAGE.SET_NAME('GR',
1177: 'GR_UNEXPECTED_ERROR');
1178: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1175: l_msg_data := APP_EXCEPTION.Get_Text;

1171: WHEN OTHERS THEN
1172: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1173: x_return_status := 'U';
1174: x_oracle_error := APP_EXCEPTION.Get_Code;
1175: l_msg_data := APP_EXCEPTION.Get_Text;
1176: FND_MESSAGE.SET_NAME('GR',
1177: 'GR_UNEXPECTED_ERROR');
1178: FND_MESSAGE.SET_TOKEN('TEXT',
1179: l_msg_data,

Line 1271: x_oracle_error := APP_EXCEPTION.Get_Code;

1267:
1268: WHEN OTHERS THEN
1269: ROLLBACK TO SAVEPOINT Check_Integrity;
1270: x_return_status := 'U';
1271: x_oracle_error := APP_EXCEPTION.Get_Code;
1272: l_msg_data := APP_EXCEPTION.Get_Text;
1273: FND_MESSAGE.SET_NAME('GR',
1274: 'GR_UNEXPECTED_ERROR');
1275: FND_MESSAGE.SET_TOKEN('TEXT',

Line 1272: l_msg_data := APP_EXCEPTION.Get_Text;

1268: WHEN OTHERS THEN
1269: ROLLBACK TO SAVEPOINT Check_Integrity;
1270: x_return_status := 'U';
1271: x_oracle_error := APP_EXCEPTION.Get_Code;
1272: l_msg_data := APP_EXCEPTION.Get_Text;
1273: FND_MESSAGE.SET_NAME('GR',
1274: 'GR_UNEXPECTED_ERROR');
1275: FND_MESSAGE.SET_TOKEN('TEXT',
1276: l_msg_data,

Line 1279: APP_EXCEPTION.Raise_Exception;

1275: FND_MESSAGE.SET_TOKEN('TEXT',
1276: l_msg_data,
1277: FALSE);
1278: IF FND_API.To_Boolean(p_called_by_form) THEN
1279: APP_EXCEPTION.Raise_Exception;
1280: ELSE
1281: x_msg_data := FND_MESSAGE.Get;
1282: END IF;
1283:

Line 1331: l_msg_data := APP_EXCEPTION.Get_Text;

1327:
1328: EXCEPTION
1329:
1330: WHEN Others THEN
1331: l_msg_data := APP_EXCEPTION.Get_Text;
1332: FND_MESSAGE.SET_NAME('GR',
1333: 'GR_UNEXPECTED_ERROR');
1334: FND_MESSAGE.SET_TOKEN('TEXT',
1335: l_msg_data,

Line 1338: APP_EXCEPTION.Raise_Exception;

1334: FND_MESSAGE.SET_TOKEN('TEXT',
1335: l_msg_data,
1336: FALSE);
1337: IF FND_API.To_Boolean(p_called_by_form) THEN
1338: APP_EXCEPTION.Raise_Exception;
1339: END IF;
1340:
1341: END Check_Primary_Key;
1342:

Line 1399: l_msg_data := APP_EXCEPTION.Get_Text;

1395: CLOSE c_check_master_item_assoc;
1396:
1397: EXCEPTION
1398: WHEN Others THEN
1399: l_msg_data := APP_EXCEPTION.Get_Text;
1400: FND_MESSAGE.SET_NAME('GR',
1401: 'GR_UNEXPECTED_ERROR');
1402: FND_MESSAGE.SET_TOKEN('TEXT',
1403: l_msg_data,

Line 1406: APP_EXCEPTION.Raise_Exception;

1402: FND_MESSAGE.SET_TOKEN('TEXT',
1403: l_msg_data,
1404: FALSE);
1405: IF FND_API.To_Boolean(p_called_by_form) THEN
1406: APP_EXCEPTION.Raise_Exception;
1407: END IF;
1408:
1409: END Check_Master_Item_Assoc;
1410: