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

Line 258: FND_MESSAGE.SET_NAME('GR',

254: WHEN Foreign_Key_Error THEN
255: ROLLBACK TO SAVEPOINT Insert_Row;
256: x_return_status := l_return_status;
257: x_oracle_error := l_oracle_error;
258: FND_MESSAGE.SET_NAME('GR',
259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);

Line 260: FND_MESSAGE.SET_TOKEN('TEXT',

256: x_return_status := l_return_status;
257: x_oracle_error := l_oracle_error;
258: FND_MESSAGE.SET_NAME('GR',
259: 'GR_FOREIGN_KEY_ERROR');
260: FND_MESSAGE.SET_TOKEN('TEXT',
261: l_msg_data,
262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;

Line 266: x_msg_data := FND_MESSAGE.Get;

262: FALSE);
263: IF FND_API.To_Boolean(p_called_by_form) THEN
264: APP_EXCEPTION.Raise_Exception;
265: ELSE
266: x_msg_data := FND_MESSAGE.Get;
267: END IF;
268:
269: WHEN Item_Exists_Error THEN
270: ROLLBACK TO SAVEPOINT Insert_Row;

Line 274: FND_MESSAGE.SET_NAME('GR',

270: ROLLBACK TO SAVEPOINT Insert_Row;
271: l_msg_token := p_item_code || ' ' || p_item_no || ' ' || p_language;
272: x_return_status := 'E';
273: x_oracle_error := APP_EXCEPTION.Get_Code;
274: FND_MESSAGE.SET_NAME('GR',
275: 'GR_RECORD_EXISTS');
276: FND_MESSAGE.SET_TOKEN('CODE',
277: l_msg_token,
278: FALSE);

Line 276: FND_MESSAGE.SET_TOKEN('CODE',

272: x_return_status := 'E';
273: x_oracle_error := APP_EXCEPTION.Get_Code;
274: FND_MESSAGE.SET_NAME('GR',
275: 'GR_RECORD_EXISTS');
276: FND_MESSAGE.SET_TOKEN('CODE',
277: l_msg_token,
278: FALSE);
279: IF FND_API.To_Boolean(p_called_by_form) THEN
280: APP_EXCEPTION.Raise_Exception;

Line 282: x_msg_data := FND_MESSAGE.Get;

278: FALSE);
279: IF FND_API.To_Boolean(p_called_by_form) THEN
280: APP_EXCEPTION.Raise_Exception;
281: ELSE
282: x_msg_data := FND_MESSAGE.Get;
283: END IF;
284:
285: WHEN Row_Missing_Error THEN
286: ROLLBACK TO SAVEPOINT Insert_Row;

Line 290: FND_MESSAGE.SET_NAME('GR',

286: ROLLBACK TO SAVEPOINT Insert_Row;
287: l_msg_token := p_item_code || ' ' || p_item_no || ' ' || p_language;
288: x_return_status := 'E';
289: x_oracle_error := APP_EXCEPTION.Get_Code;
290: FND_MESSAGE.SET_NAME('GR',
291: 'GR_NO_RECORD_INSERTED');
292: FND_MESSAGE.SET_TOKEN('CODE',
293: l_msg_token,
294: FALSE);

Line 292: FND_MESSAGE.SET_TOKEN('CODE',

288: x_return_status := 'E';
289: x_oracle_error := APP_EXCEPTION.Get_Code;
290: FND_MESSAGE.SET_NAME('GR',
291: 'GR_NO_RECORD_INSERTED');
292: FND_MESSAGE.SET_TOKEN('CODE',
293: l_msg_token,
294: FALSE);
295: IF FND_API.To_Boolean(p_called_by_form) THEN
296: APP_EXCEPTION.Raise_Exception;

Line 298: x_msg_data := FND_MESSAGE.Get;

294: FALSE);
295: IF FND_API.To_Boolean(p_called_by_form) THEN
296: APP_EXCEPTION.Raise_Exception;
297: ELSE
298: x_msg_data := FND_MESSAGE.Get;
299: END IF;
300:
301: WHEN OTHERS THEN
302: ROLLBACK TO SAVEPOINT Insert_Row;

Line 307: FND_MESSAGE.SET_NAME('GR',

303: l_msg_token := p_item_code || ' ' || p_item_no || ' ' || p_language;
304: x_return_status := 'U';
305: x_oracle_error := APP_EXCEPTION.Get_Code;
306: l_msg_data := APP_EXCEPTION.Get_Text;
307: FND_MESSAGE.SET_NAME('GR',
308: 'GR_UNEXPECTED_ERROR');
309: FND_MESSAGE.SET_TOKEN('TEXT',
310: l_msg_token,
311: FALSE);

Line 309: FND_MESSAGE.SET_TOKEN('TEXT',

305: x_oracle_error := APP_EXCEPTION.Get_Code;
306: l_msg_data := APP_EXCEPTION.Get_Text;
307: FND_MESSAGE.SET_NAME('GR',
308: 'GR_UNEXPECTED_ERROR');
309: FND_MESSAGE.SET_TOKEN('TEXT',
310: l_msg_token,
311: FALSE);
312: IF FND_API.To_Boolean(p_called_by_form) THEN
313: APP_EXCEPTION.Raise_Exception;

Line 315: x_msg_data := FND_MESSAGE.Get;

311: FALSE);
312: IF FND_API.To_Boolean(p_called_by_form) THEN
313: APP_EXCEPTION.Raise_Exception;
314: ELSE
315: x_msg_data := FND_MESSAGE.Get;
316: END IF;
317:
318: END Insert_Row;
319:

Line 504: FND_MESSAGE.SET_NAME('GR',

500: WHEN Foreign_Key_Error THEN
501: ROLLBACK TO SAVEPOINT Update_Row;
502: x_return_status := l_return_status;
503: x_oracle_error := l_oracle_error;
504: FND_MESSAGE.SET_NAME('GR',
505: 'GR_FOREIGN_KEY_ERROR');
506: FND_MESSAGE.SET_TOKEN('TEXT',
507: l_msg_data,
508: FALSE);

Line 506: FND_MESSAGE.SET_TOKEN('TEXT',

502: x_return_status := l_return_status;
503: x_oracle_error := l_oracle_error;
504: FND_MESSAGE.SET_NAME('GR',
505: 'GR_FOREIGN_KEY_ERROR');
506: FND_MESSAGE.SET_TOKEN('TEXT',
507: l_msg_data,
508: FALSE);
509: IF FND_API.To_Boolean(p_called_by_form) THEN
510: APP_EXCEPTION.Raise_Exception;

Line 512: x_msg_data := FND_MESSAGE.Get;

508: FALSE);
509: IF FND_API.To_Boolean(p_called_by_form) THEN
510: APP_EXCEPTION.Raise_Exception;
511: ELSE
512: x_msg_data := FND_MESSAGE.Get;
513: END IF;
514:
515: WHEN Row_Missing_Error THEN
516: ROLLBACK TO SAVEPOINT Update_Row;

Line 519: FND_MESSAGE.SET_NAME('GR',

515: WHEN Row_Missing_Error THEN
516: ROLLBACK TO SAVEPOINT Update_Row;
517: x_return_status := 'E';
518: x_oracle_error := APP_EXCEPTION.Get_Code;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_NO_RECORD_INSERTED');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: l_msg_token,
523: FALSE);

Line 521: FND_MESSAGE.SET_TOKEN('CODE',

517: x_return_status := 'E';
518: x_oracle_error := APP_EXCEPTION.Get_Code;
519: FND_MESSAGE.SET_NAME('GR',
520: 'GR_NO_RECORD_INSERTED');
521: FND_MESSAGE.SET_TOKEN('CODE',
522: l_msg_token,
523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;

Line 527: x_msg_data := FND_MESSAGE.Get;

523: FALSE);
524: IF FND_API.To_Boolean(p_called_by_form) THEN
525: APP_EXCEPTION.Raise_Exception;
526: ELSE
527: x_msg_data := FND_MESSAGE.Get;
528: END IF;
529:
530: WHEN OTHERS THEN
531: ROLLBACK TO SAVEPOINT Update_Row;

Line 535: FND_MESSAGE.SET_NAME('GR',

531: ROLLBACK TO SAVEPOINT Update_Row;
532: x_return_status := 'U';
533: x_oracle_error := APP_EXCEPTION.Get_Code;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: FND_MESSAGE.SET_NAME('GR',
536: 'GR_UNEXPECTED_ERROR');
537: FND_MESSAGE.SET_TOKEN('TEXT',
538: l_msg_token,
539: FALSE);

Line 537: FND_MESSAGE.SET_TOKEN('TEXT',

533: x_oracle_error := APP_EXCEPTION.Get_Code;
534: l_msg_data := APP_EXCEPTION.Get_Text;
535: FND_MESSAGE.SET_NAME('GR',
536: 'GR_UNEXPECTED_ERROR');
537: FND_MESSAGE.SET_TOKEN('TEXT',
538: l_msg_token,
539: FALSE);
540: IF FND_API.To_Boolean(p_called_by_form) THEN
541: APP_EXCEPTION.Raise_Exception;

Line 543: x_msg_data := FND_MESSAGE.Get;

539: FALSE);
540: IF FND_API.To_Boolean(p_called_by_form) THEN
541: APP_EXCEPTION.Raise_Exception;
542: ELSE
543: x_msg_data := FND_MESSAGE.Get;
544: END IF;
545:
546: END Update_Row;
547:

Line 888: FND_MESSAGE.SET_NAME('GR',

884: WHEN Language_Missing_Error THEN
885: ROLLBACK TO SAVEPOINT Add_Language;
886: x_return_status := 'E';
887: x_oracle_error := APP_EXCEPTION.Get_Code;
888: FND_MESSAGE.SET_NAME('GR',
889: 'GR_RECORD_NOT_FOUND');
890: FND_MESSAGE.SET_TOKEN('CODE',
891: l_msg_token,
892: FALSE);

Line 890: FND_MESSAGE.SET_TOKEN('CODE',

886: x_return_status := 'E';
887: x_oracle_error := APP_EXCEPTION.Get_Code;
888: FND_MESSAGE.SET_NAME('GR',
889: 'GR_RECORD_NOT_FOUND');
890: FND_MESSAGE.SET_TOKEN('CODE',
891: l_msg_token,
892: FALSE);
893: IF FND_API.To_Boolean(p_called_by_form) THEN
894: APP_EXCEPTION.Raise_Exception;

Line 896: x_msg_data := FND_MESSAGE.Get;

892: FALSE);
893: IF FND_API.To_Boolean(p_called_by_form) THEN
894: APP_EXCEPTION.Raise_Exception;
895: ELSE
896: x_msg_data := FND_MESSAGE.Get;
897: END IF;
898:
899: WHEN OTHERS THEN
900: ROLLBACK TO SAVEPOINT Add_Language;

Line 903: FND_MESSAGE.SET_NAME('GR',

899: WHEN OTHERS THEN
900: ROLLBACK TO SAVEPOINT Add_Language;
901: x_return_status := 'U';
902: x_oracle_error := APP_EXCEPTION.Get_Code;
903: FND_MESSAGE.SET_NAME('GR',
904: 'GR_UNEXPECTED_ERROR');
905: FND_MESSAGE.SET_TOKEN('TEXT',
906: l_msg_token,
907: FALSE);

Line 905: FND_MESSAGE.SET_TOKEN('TEXT',

901: x_return_status := 'U';
902: x_oracle_error := APP_EXCEPTION.Get_Code;
903: FND_MESSAGE.SET_NAME('GR',
904: 'GR_UNEXPECTED_ERROR');
905: FND_MESSAGE.SET_TOKEN('TEXT',
906: l_msg_token,
907: FALSE);
908: IF FND_API.To_Boolean(p_called_by_form) THEN
909: APP_EXCEPTION.Raise_Exception;

Line 911: x_msg_data := FND_MESSAGE.Get;

907: FALSE);
908: IF FND_API.To_Boolean(p_called_by_form) THEN
909: APP_EXCEPTION.Raise_Exception;
910: ELSE
911: x_msg_data := FND_MESSAGE.Get;
912: END IF;
913:
914: END Add_Language;
915:

Line 1025: FND_MESSAGE.SET_NAME('GR',

1021:
1022: WHEN No_Data_Found_Error THEN
1023: ROLLBACK TO SAVEPOINT Lock_Row;
1024: x_return_status := 'E';
1025: FND_MESSAGE.SET_NAME('GR',
1026: 'GR_RECORD_NOT_FOUND');
1027: FND_MESSAGE.SET_TOKEN('CODE',
1028: l_msg_token,
1029: FALSE);

Line 1027: FND_MESSAGE.SET_TOKEN('CODE',

1023: ROLLBACK TO SAVEPOINT Lock_Row;
1024: x_return_status := 'E';
1025: FND_MESSAGE.SET_NAME('GR',
1026: 'GR_RECORD_NOT_FOUND');
1027: FND_MESSAGE.SET_TOKEN('CODE',
1028: l_msg_token,
1029: FALSE);
1030: IF FND_API.To_Boolean(p_called_by_form) THEN
1031: APP_EXCEPTION.Raise_Exception;

Line 1033: x_msg_data := FND_MESSAGE.Get;

1029: FALSE);
1030: IF FND_API.To_Boolean(p_called_by_form) THEN
1031: APP_EXCEPTION.Raise_Exception;
1032: ELSE
1033: x_msg_data := FND_MESSAGE.Get;
1034: END IF;
1035:
1036: WHEN RECORD_CHANGED_ERROR THEN
1037: ROLLBACK TO SAVEPOINT Lock_Row;

Line 1039: FND_MESSAGE.SET_NAME('FND',

1035:
1036: WHEN RECORD_CHANGED_ERROR THEN
1037: ROLLBACK TO SAVEPOINT Lock_Row;
1038: X_return_status := 'E';
1039: FND_MESSAGE.SET_NAME('FND',
1040: 'FORM_RECORD_CHANGED');
1041: IF FND_API.To_Boolean(p_called_by_form) THEN
1042: APP_EXCEPTION.Raise_Exception;
1043: ELSE

Line 1044: x_msg_data := FND_MESSAGE.Get;

1040: 'FORM_RECORD_CHANGED');
1041: IF FND_API.To_Boolean(p_called_by_form) THEN
1042: APP_EXCEPTION.Raise_Exception;
1043: ELSE
1044: x_msg_data := FND_MESSAGE.Get;
1045: END IF;
1046: WHEN APP_EXCEPTION.RECORD_LOCK_EXCEPTION THEN
1047: ROLLBACK TO SAVEPOINT Lock_Row;
1048: x_return_status := 'L';

Line 1051: FND_MESSAGE.SET_NAME('GR',

1047: ROLLBACK TO SAVEPOINT Lock_Row;
1048: x_return_status := 'L';
1049: x_oracle_error := APP_EXCEPTION.Get_Code;
1050: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
1051: FND_MESSAGE.SET_NAME('GR',
1052: 'GR_ROW_IS_LOCKED');
1053: x_msg_data := FND_MESSAGE.Get;
1054: END IF;
1055:

Line 1053: x_msg_data := FND_MESSAGE.Get;

1049: x_oracle_error := APP_EXCEPTION.Get_Code;
1050: IF NOT (FND_API.To_Boolean(p_called_by_form)) THEN
1051: FND_MESSAGE.SET_NAME('GR',
1052: 'GR_ROW_IS_LOCKED');
1053: x_msg_data := FND_MESSAGE.Get;
1054: END IF;
1055:
1056:
1057: WHEN OTHERS THEN

Line 1062: FND_MESSAGE.SET_NAME('GR',

1058: ROLLBACK TO SAVEPOINT Lock_Row;
1059: x_return_status := 'U';
1060: x_oracle_error := APP_EXCEPTION.Get_Code;
1061: l_msg_data := APP_EXCEPTION.Get_Text;
1062: FND_MESSAGE.SET_NAME('GR',
1063: 'GR_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('TEXT',
1065: l_msg_token,
1066: FALSE);

Line 1064: FND_MESSAGE.SET_TOKEN('TEXT',

1060: x_oracle_error := APP_EXCEPTION.Get_Code;
1061: l_msg_data := APP_EXCEPTION.Get_Text;
1062: FND_MESSAGE.SET_NAME('GR',
1063: 'GR_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('TEXT',
1065: l_msg_token,
1066: FALSE);
1067: IF FND_API.To_Boolean(p_called_by_form) THEN
1068: APP_EXCEPTION.Raise_Exception;

Line 1070: x_msg_data := FND_MESSAGE.Get;

1066: FALSE);
1067: IF FND_API.To_Boolean(p_called_by_form) THEN
1068: APP_EXCEPTION.Raise_Exception;
1069: ELSE
1070: x_msg_data := FND_MESSAGE.Get;
1071: END IF;
1072:
1073: END Lock_Row;
1074:

Line 1223: x_msg_data := FND_MESSAGE.Get;

1219: x_oracle_error := l_oracle_error;
1220: IF FND_API.To_Boolean(p_called_by_form) THEN
1221: APP_EXCEPTION.Raise_Exception;
1222: ELSE
1223: x_msg_data := FND_MESSAGE.Get;
1224: END IF;
1225:
1226: WHEN Row_Missing_Error THEN
1227: ROLLBACK TO SAVEPOINT Delete_Row;

Line 1230: FND_MESSAGE.SET_NAME('GR',

1226: WHEN Row_Missing_Error THEN
1227: ROLLBACK TO SAVEPOINT Delete_Row;
1228: x_return_status := 'E';
1229: x_oracle_error := APP_EXCEPTION.Get_Code;
1230: FND_MESSAGE.SET_NAME('GR',
1231: 'GR_RECORD_NOT_FOUND');
1232: FND_MESSAGE.SET_TOKEN('CODE',
1233: l_msg_token,
1234: FALSE);

Line 1232: FND_MESSAGE.SET_TOKEN('CODE',

1228: x_return_status := 'E';
1229: x_oracle_error := APP_EXCEPTION.Get_Code;
1230: FND_MESSAGE.SET_NAME('GR',
1231: 'GR_RECORD_NOT_FOUND');
1232: FND_MESSAGE.SET_TOKEN('CODE',
1233: l_msg_token,
1234: FALSE);
1235: IF FND_API.To_Boolean(p_called_by_form) THEN
1236: APP_EXCEPTION.Raise_Exception;

Line 1238: x_msg_data := FND_MESSAGE.Get;

1234: FALSE);
1235: IF FND_API.To_Boolean(p_called_by_form) THEN
1236: APP_EXCEPTION.Raise_Exception;
1237: ELSE
1238: x_msg_data := FND_MESSAGE.Get;
1239: END IF;
1240:
1241: WHEN OTHERS THEN
1242: ROLLBACK TO SAVEPOINT Delete_Row;

Line 1247: FND_MESSAGE.SET_NAME('GR',

1243: x_return_status := 'U';
1244: x_oracle_error := APP_EXCEPTION.Get_Code;
1245: l_msg_data := APP_EXCEPTION.Get_Text;
1246: l_msg_data := APP_EXCEPTION.Get_Text;
1247: FND_MESSAGE.SET_NAME('GR',
1248: 'GR_UNEXPECTED_ERROR');
1249: FND_MESSAGE.SET_TOKEN('TEXT',
1250: l_msg_token,
1251: FALSE);

Line 1249: FND_MESSAGE.SET_TOKEN('TEXT',

1245: l_msg_data := APP_EXCEPTION.Get_Text;
1246: l_msg_data := APP_EXCEPTION.Get_Text;
1247: FND_MESSAGE.SET_NAME('GR',
1248: 'GR_UNEXPECTED_ERROR');
1249: FND_MESSAGE.SET_TOKEN('TEXT',
1250: l_msg_token,
1251: FALSE);
1252: IF FND_API.To_Boolean(p_called_by_form) THEN
1253: APP_EXCEPTION.Raise_Exception;

Line 1255: x_msg_data := FND_MESSAGE.Get;

1251: FALSE);
1252: IF FND_API.To_Boolean(p_called_by_form) THEN
1253: APP_EXCEPTION.Raise_Exception;
1254: ELSE
1255: x_msg_data := FND_MESSAGE.Get;
1256: END IF;
1257:
1258: END Delete_Row;
1259:

Line 1346: FND_MESSAGE.SET_NAME('GR',

1342:
1343: WHEN Null_Delete_Option_Error THEN
1344: x_return_status := 'E';
1345: x_oracle_error := APP_EXCEPTION.Get_Code;
1346: FND_MESSAGE.SET_NAME('GR',
1347: 'GR_NULL_VALUE');
1348: FND_MESSAGE.SET_TOKEN('CODE',
1349: l_msg_token,
1350: FALSE);

Line 1348: FND_MESSAGE.SET_TOKEN('CODE',

1344: x_return_status := 'E';
1345: x_oracle_error := APP_EXCEPTION.Get_Code;
1346: FND_MESSAGE.SET_NAME('GR',
1347: 'GR_NULL_VALUE');
1348: FND_MESSAGE.SET_TOKEN('CODE',
1349: l_msg_token,
1350: FALSE);
1351: IF FND_API.To_Boolean(p_called_by_form) THEN
1352: APP_EXCEPTION.Raise_Exception;

Line 1354: x_msg_data := FND_MESSAGE.Get;

1350: FALSE);
1351: IF FND_API.To_Boolean(p_called_by_form) THEN
1352: APP_EXCEPTION.Raise_Exception;
1353: ELSE
1354: x_msg_data := FND_MESSAGE.Get;
1355: END IF;
1356:
1357: WHEN OTHERS THEN
1358: ROLLBACK TO SAVEPOINT Delete_Rows;

Line 1362: FND_MESSAGE.SET_NAME('GR',

1358: ROLLBACK TO SAVEPOINT Delete_Rows;
1359: x_return_status := 'U';
1360: x_oracle_error := APP_EXCEPTION.Get_Code;
1361: l_msg_data := APP_EXCEPTION.Get_Text;
1362: FND_MESSAGE.SET_NAME('GR',
1363: 'GR_UNEXPECTED_ERROR');
1364: FND_MESSAGE.SET_TOKEN('TEXT',
1365: l_msg_token,
1366: FALSE);

Line 1364: FND_MESSAGE.SET_TOKEN('TEXT',

1360: x_oracle_error := APP_EXCEPTION.Get_Code;
1361: l_msg_data := APP_EXCEPTION.Get_Text;
1362: FND_MESSAGE.SET_NAME('GR',
1363: 'GR_UNEXPECTED_ERROR');
1364: FND_MESSAGE.SET_TOKEN('TEXT',
1365: l_msg_token,
1366: FALSE);
1367: IF FND_API.To_Boolean(p_called_by_form) THEN
1368: APP_EXCEPTION.Raise_Exception;

Line 1370: x_msg_data := FND_MESSAGE.Get;

1366: FALSE);
1367: IF FND_API.To_Boolean(p_called_by_form) THEN
1368: APP_EXCEPTION.Raise_Exception;
1369: ELSE
1370: x_msg_data := FND_MESSAGE.Get;
1371: END IF;
1372:
1373: END Delete_Rows;
1374:

Line 1473: FND_MESSAGE.SET_NAME('GR',

1469: l_rowid,
1470: l_key_exists);
1471: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1472: x_return_status := 'E';
1473: FND_MESSAGE.SET_NAME('GR',
1474: 'GR_RECORD_NOT_FOUND');
1475: FND_MESSAGE.SET_TOKEN('CODE',
1476: p_item_code,
1477: FALSE);

Line 1475: FND_MESSAGE.SET_TOKEN('CODE',

1471: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1472: x_return_status := 'E';
1473: FND_MESSAGE.SET_NAME('GR',
1474: 'GR_RECORD_NOT_FOUND');
1475: FND_MESSAGE.SET_TOKEN('CODE',
1476: p_item_code,
1477: FALSE);
1478: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1479: END IF;

Line 1478: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

1474: 'GR_RECORD_NOT_FOUND');
1475: FND_MESSAGE.SET_TOKEN('CODE',
1476: p_item_code,
1477: FALSE);
1478: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1479: END IF;
1480:
1481: /* Check the item no */
1482:

Line 1487: FND_MESSAGE.SET_NAME('GR',

1483: OPEN c_get_ic_item;
1484: FETCH c_get_ic_item INTO ICItemRecord;
1485: IF c_get_ic_item%NOTFOUND THEN
1486: x_return_status := 'E';
1487: FND_MESSAGE.SET_NAME('GR',
1488: 'GR_RECORD_NOT_FOUND');
1489: FND_MESSAGE.SET_TOKEN('CODE',
1490: p_item_no,
1491: FALSE);

Line 1489: FND_MESSAGE.SET_TOKEN('CODE',

1485: IF c_get_ic_item%NOTFOUND THEN
1486: x_return_status := 'E';
1487: FND_MESSAGE.SET_NAME('GR',
1488: 'GR_RECORD_NOT_FOUND');
1489: FND_MESSAGE.SET_TOKEN('CODE',
1490: p_item_no,
1491: FALSE);
1492: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1493: END IF;

Line 1492: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

1488: 'GR_RECORD_NOT_FOUND');
1489: FND_MESSAGE.SET_TOKEN('CODE',
1490: p_item_no,
1491: FALSE);
1492: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1493: END IF;
1494:
1495: /* Check the label code */
1496:

Line 1504: FND_MESSAGE.SET_NAME('GR',

1500: l_rowid,
1501: l_key_exists);
1502: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1503: x_return_status := 'E';
1504: FND_MESSAGE.SET_NAME('GR',
1505: 'GR_RECORD_NOT_FOUND');
1506: FND_MESSAGE.SET_TOKEN('CODE',
1507: p_label_code,
1508: FALSE);

Line 1506: FND_MESSAGE.SET_TOKEN('CODE',

1502: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1503: x_return_status := 'E';
1504: FND_MESSAGE.SET_NAME('GR',
1505: 'GR_RECORD_NOT_FOUND');
1506: FND_MESSAGE.SET_TOKEN('CODE',
1507: p_label_code,
1508: FALSE);
1509: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1510: END IF;

Line 1509: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';

1505: 'GR_RECORD_NOT_FOUND');
1506: FND_MESSAGE.SET_TOKEN('CODE',
1507: p_label_code,
1508: FALSE);
1509: l_msg_data := l_msg_data || FND_MESSAGE.Get || ' ';
1510: END IF;
1511:
1512: /* Check the language codes */
1513:

Line 1540: FND_MESSAGE.SET_NAME('GR',

1536: WHEN Row_Missing_Error THEN
1537: ROLLBACK TO SAVEPOINT Delete_Row;
1538: x_return_status := 'E';
1539: x_oracle_error := APP_EXCEPTION.Get_Code;
1540: FND_MESSAGE.SET_NAME('GR',
1541: 'GR_RECORD_NOT_FOUND');
1542: FND_MESSAGE.SET_TOKEN('CODE',
1543: l_msg_token,
1544: FALSE);

Line 1542: FND_MESSAGE.SET_TOKEN('CODE',

1538: x_return_status := 'E';
1539: x_oracle_error := APP_EXCEPTION.Get_Code;
1540: FND_MESSAGE.SET_NAME('GR',
1541: 'GR_RECORD_NOT_FOUND');
1542: FND_MESSAGE.SET_TOKEN('CODE',
1543: l_msg_token,
1544: FALSE);
1545: x_msg_data := FND_MESSAGE.Get;
1546:

Line 1545: x_msg_data := FND_MESSAGE.Get;

1541: 'GR_RECORD_NOT_FOUND');
1542: FND_MESSAGE.SET_TOKEN('CODE',
1543: l_msg_token,
1544: FALSE);
1545: x_msg_data := FND_MESSAGE.Get;
1546:
1547: WHEN OTHERS THEN
1548: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1549: x_return_status := 'U';

Line 1552: FND_MESSAGE.SET_NAME('GR',

1548: ROLLBACK TO SAVEPOINT Check_Foreign_Keys;
1549: x_return_status := 'U';
1550: x_oracle_error := APP_EXCEPTION.Get_Code;
1551: l_msg_data := APP_EXCEPTION.Get_Text;
1552: FND_MESSAGE.SET_NAME('GR',
1553: 'GR_UNEXPECTED_ERROR');
1554: FND_MESSAGE.SET_TOKEN('TEXT',
1555: l_msg_token,
1556: FALSE);

Line 1554: FND_MESSAGE.SET_TOKEN('TEXT',

1550: x_oracle_error := APP_EXCEPTION.Get_Code;
1551: l_msg_data := APP_EXCEPTION.Get_Text;
1552: FND_MESSAGE.SET_NAME('GR',
1553: 'GR_UNEXPECTED_ERROR');
1554: FND_MESSAGE.SET_TOKEN('TEXT',
1555: l_msg_token,
1556: FALSE);
1557: x_msg_data := FND_MESSAGE.Get;
1558:

Line 1557: x_msg_data := FND_MESSAGE.Get;

1553: 'GR_UNEXPECTED_ERROR');
1554: FND_MESSAGE.SET_TOKEN('TEXT',
1555: l_msg_token,
1556: FALSE);
1557: x_msg_data := FND_MESSAGE.Get;
1558:
1559: END Check_Foreign_Keys;
1560:
1561: PROCEDURE Check_Integrity

Line 1655: FND_MESSAGE.SET_NAME('GR',

1651:
1652: WHEN Installed_Language_Error THEN
1653: ROLLBACK TO SAVEPOINT Check_Integrity;
1654: x_return_status := 'E';
1655: FND_MESSAGE.SET_NAME('GR',
1656: 'GR_INSTALLED_LANG');
1657: FND_MESSAGE.SET_TOKEN('CODE',
1658: p_language,
1659: FALSE);

Line 1657: FND_MESSAGE.SET_TOKEN('CODE',

1653: ROLLBACK TO SAVEPOINT Check_Integrity;
1654: x_return_status := 'E';
1655: FND_MESSAGE.SET_NAME('GR',
1656: 'GR_INSTALLED_LANG');
1657: FND_MESSAGE.SET_TOKEN('CODE',
1658: p_language,
1659: FALSE);
1660: IF FND_API.To_Boolean(p_called_by_form) THEN
1661: APP_EXCEPTION.Raise_Exception;

Line 1663: x_msg_data := FND_MESSAGE.Get;

1659: FALSE);
1660: IF FND_API.To_Boolean(p_called_by_form) THEN
1661: APP_EXCEPTION.Raise_Exception;
1662: ELSE
1663: x_msg_data := FND_MESSAGE.Get;
1664: END IF;
1665:
1666: WHEN OTHERS THEN
1667: ROLLBACK TO SAVEPOINT Check_Integrity;

Line 1671: FND_MESSAGE.SET_NAME('GR',

1667: ROLLBACK TO SAVEPOINT Check_Integrity;
1668: x_return_status := 'U';
1669: x_oracle_error := APP_EXCEPTION.Get_Code;
1670: l_msg_data := APP_EXCEPTION.Get_Text;
1671: FND_MESSAGE.SET_NAME('GR',
1672: 'GR_UNEXPECTED_ERROR');
1673: FND_MESSAGE.SET_TOKEN('TEXT',
1674: l_msg_data,
1675: FALSE);

Line 1673: FND_MESSAGE.SET_TOKEN('TEXT',

1669: x_oracle_error := APP_EXCEPTION.Get_Code;
1670: l_msg_data := APP_EXCEPTION.Get_Text;
1671: FND_MESSAGE.SET_NAME('GR',
1672: 'GR_UNEXPECTED_ERROR');
1673: FND_MESSAGE.SET_TOKEN('TEXT',
1674: l_msg_data,
1675: FALSE);
1676: IF FND_API.To_Boolean(p_called_by_form) THEN
1677: APP_EXCEPTION.Raise_Exception;

Line 1679: x_msg_data := FND_MESSAGE.Get;

1675: FALSE);
1676: IF FND_API.To_Boolean(p_called_by_form) THEN
1677: APP_EXCEPTION.Raise_Exception;
1678: ELSE
1679: x_msg_data := FND_MESSAGE.Get;
1680: END IF;
1681:
1682: END Check_Integrity;
1683:

Line 1734: FND_MESSAGE.SET_NAME('GR',

1730: EXCEPTION
1731:
1732: WHEN Others THEN
1733: l_msg_data := APP_EXCEPTION.Get_Text;
1734: FND_MESSAGE.SET_NAME('GR',
1735: 'GR_UNEXPECTED_ERROR');
1736: FND_MESSAGE.SET_TOKEN('TEXT',
1737: l_msg_data,
1738: FALSE);

Line 1736: FND_MESSAGE.SET_TOKEN('TEXT',

1732: WHEN Others THEN
1733: l_msg_data := APP_EXCEPTION.Get_Text;
1734: FND_MESSAGE.SET_NAME('GR',
1735: 'GR_UNEXPECTED_ERROR');
1736: FND_MESSAGE.SET_TOKEN('TEXT',
1737: l_msg_data,
1738: FALSE);
1739: IF FND_API.To_Boolean(p_called_by_form) THEN
1740: APP_EXCEPTION.Raise_Exception;