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_TOXIC_PKG dependencies on FND_API

Line 154: IF FND_API.To_Boolean(l_key_exists) THEN

150: 'F',
151: l_rowid,
152: l_key_exists);
153:
154: IF FND_API.To_Boolean(l_key_exists) THEN
155: RAISE Item_Exists_Error;
156: END IF;
157:
158: INSERT INTO gr_item_toxic

Line 265: IF FND_API.To_Boolean(l_key_exists) THEN

261: 'F',
262: l_rowid,
263: l_key_exists);
264:
265: IF FND_API.To_Boolean(l_key_exists) THEN
266: x_rowid := l_rowid;
267: ELSE
268: RAISE Row_Missing_Error;
269: END IF;

Line 273: IF FND_API.To_Boolean(p_commit) THEN

269: END IF;
270:
271: /* Check the commit flag and if set, then commit the work. */
272:
273: IF FND_API.To_Boolean(p_commit) THEN
274: COMMIT WORK;
275: END IF;
276:
277: EXCEPTION

Line 288: IF FND_API.To_Boolean(p_called_by_form) THEN

284: 'GR_FOREIGN_KEY_ERROR');
285: FND_MESSAGE.SET_TOKEN('TEXT',
286: l_msg_data,
287: FALSE);
288: IF FND_API.To_Boolean(p_called_by_form) THEN
289: APP_EXCEPTION.Raise_Exception;
290: ELSE
291: x_msg_data := FND_MESSAGE.Get;
292: END IF;

Line 303: IF FND_API.To_Boolean(p_called_by_form) THEN

299: 'GR_RECORD_EXISTS');
300: FND_MESSAGE.SET_TOKEN('CODE',
301: l_msg_token,
302: FALSE);
303: IF FND_API.To_Boolean(p_called_by_form) THEN
304: APP_EXCEPTION.Raise_Exception;
305: ELSE
306: x_msg_data := FND_MESSAGE.Get;
307: END IF;

Line 318: IF FND_API.To_Boolean(p_called_by_form) THEN

314: 'GR_NO_RECORD_INSERTED');
315: FND_MESSAGE.SET_TOKEN('CODE',
316: l_msg_token,
317: FALSE);
318: IF FND_API.To_Boolean(p_called_by_form) THEN
319: APP_EXCEPTION.Raise_Exception;
320: ELSE
321: x_msg_data := FND_MESSAGE.Get;
322: END IF;

Line 334: IF FND_API.To_Boolean(p_called_by_form) THEN

330: 'GR_UNEXPECTED_ERROR');
331: FND_MESSAGE.SET_TOKEN('TEXT',
332: l_msg_token,
333: FALSE);
334: IF FND_API.To_Boolean(p_called_by_form) THEN
335: APP_EXCEPTION.Raise_Exception;
336: ELSE
337: x_msg_data := FND_MESSAGE.Get;
338: END IF;

Line 531: IF FND_API.To_Boolean(p_commit) THEN

527: END IF;
528:
529: /* Check the commit flag and if set, then commit the work. */
530:
531: IF FND_API.To_Boolean(p_commit) THEN
532: COMMIT WORK;
533: END IF;
534:
535: EXCEPTION

Line 546: IF FND_API.To_Boolean(p_called_by_form) THEN

542: 'GR_FOREIGN_KEY_ERROR');
543: FND_MESSAGE.SET_TOKEN('TEXT',
544: l_msg_data,
545: FALSE);
546: IF FND_API.To_Boolean(p_called_by_form) THEN
547: APP_EXCEPTION.Raise_Exception;
548: ELSE
549: x_msg_data := FND_MESSAGE.Get;
550: END IF;

Line 561: IF FND_API.To_Boolean(p_called_by_form) THEN

557: 'GR_NO_RECORD_INSERTED');
558: FND_MESSAGE.SET_TOKEN('CODE',
559: l_msg_token,
560: FALSE);
561: IF FND_API.To_Boolean(p_called_by_form) THEN
562: APP_EXCEPTION.Raise_Exception;
563: ELSE
564: x_msg_data := FND_MESSAGE.Get;
565: END IF;

Line 577: IF FND_API.To_Boolean(p_called_by_form) THEN

573: 'GR_UNEXPECTED_ERROR');
574: FND_MESSAGE.SET_TOKEN('TEXT',
575: l_msg_token,
576: FALSE);
577: IF FND_API.To_Boolean(p_called_by_form) THEN
578: APP_EXCEPTION.Raise_Exception;
579: ELSE
580: x_msg_data := FND_MESSAGE.Get;
581: END IF;

Line 689: IF FND_API.To_Boolean(p_commit) THEN

685: RAISE No_Data_Found_Error;
686: END IF;
687: CLOSE c_lock_item_toxic;
688:
689: IF FND_API.To_Boolean(p_commit) THEN
690: COMMIT WORK;
691: END IF;
692:
693: EXCEPTION

Line 703: IF FND_API.To_Boolean(p_called_by_form) THEN

699: 'GR_RECORD_NOT_FOUND');
700: FND_MESSAGE.SET_TOKEN('CODE',
701: l_msg_token,
702: FALSE);
703: IF FND_API.To_Boolean(p_called_by_form) THEN
704: APP_EXCEPTION.Raise_Exception;
705: ELSE
706: x_msg_data := FND_MESSAGE.Get;
707: END IF;

Line 715: IF FND_API.To_Boolean(p_called_by_form) THEN

711: x_return_status := 'E';
712: x_oracle_error := APP_EXCEPTION.Get_Code;
713: FND_MESSAGE.SET_NAME('GR',
714: 'GR_ROW_IS_LOCKED');
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;

Line 731: IF FND_API.To_Boolean(p_called_by_form) THEN

727: 'GR_UNEXPECTED_ERROR');
728: FND_MESSAGE.SET_TOKEN('TEXT',
729: l_msg_token,
730: FALSE);
731: IF FND_API.To_Boolean(p_called_by_form) THEN
732: APP_EXCEPTION.Raise_Exception;
733: ELSE
734: x_msg_data := FND_MESSAGE.Get;
735: END IF;

Line 882: IF FND_API.TO_Boolean(p_commit) THEN

878: WHERE rowid = p_rowid;
879:
880: /* Check the commit flag and if set, then commit the work. */
881:
882: IF FND_API.TO_Boolean(p_commit) THEN
883: COMMIT WORK;
884: END IF;
885:
886: EXCEPTION

Line 892: IF FND_API.To_Boolean(p_called_by_form) THEN

888: WHEN Check_Integrity_Error THEN
889: ROLLBACK TO SAVEPOINT Delete_Row;
890: x_return_status := l_return_status;
891: x_oracle_error := l_oracle_error;
892: IF FND_API.To_Boolean(p_called_by_form) THEN
893: APP_EXCEPTION.Raise_Exception;
894: ELSE
895: x_msg_data := FND_MESSAGE.Get;
896: END IF;

Line 907: IF FND_API.To_Boolean(p_called_by_form) THEN

903: 'GR_RECORD_NOT_FOUND');
904: FND_MESSAGE.SET_TOKEN('CODE',
905: l_msg_token,
906: FALSE);
907: IF FND_API.To_Boolean(p_called_by_form) THEN
908: APP_EXCEPTION.Raise_Exception;
909: ELSE
910: x_msg_data := FND_MESSAGE.Get;
911: END IF;

Line 924: IF FND_API.To_Boolean(p_called_by_form) THEN

920: 'GR_UNEXPECTED_ERROR');
921: FND_MESSAGE.SET_TOKEN('TEXT',
922: l_msg_token,
923: FALSE);
924: IF FND_API.To_Boolean(p_called_by_form) THEN
925: APP_EXCEPTION.Raise_Exception;
926: ELSE
927: x_msg_data := FND_MESSAGE.Get;
928: END IF;

Line 1054: IF FND_API.To_Boolean(p_commit) THEN

1050: AND toxic_species_code = p_toxic_species_code;
1051: END IF;
1052: END IF;
1053:
1054: IF FND_API.To_Boolean(p_commit) THEN
1055: COMMIT WORK;
1056: END IF;
1057:
1058: EXCEPTION

Line 1068: IF FND_API.To_Boolean(p_called_by_form) THEN

1064: 'GR_NULL_VALUE');
1065: FND_MESSAGE.SET_TOKEN('CODE',
1066: l_msg_token,
1067: FALSE);
1068: IF FND_API.To_Boolean(p_called_by_form) THEN
1069: APP_EXCEPTION.Raise_Exception;
1070: ELSE
1071: x_msg_data := FND_MESSAGE.Get;
1072: END IF;

Line 1084: IF FND_API.To_Boolean(p_called_by_form) THEN

1080: 'GR_UNEXPECTED_ERROR');
1081: FND_MESSAGE.SET_TOKEN('TEXT',
1082: l_msg_token,
1083: FALSE);
1084: IF FND_API.To_Boolean(p_called_by_form) THEN
1085: APP_EXCEPTION.Raise_Exception;
1086: ELSE
1087: x_msg_data := FND_MESSAGE.Get;
1088: END IF;

Line 1173: IF NOT FND_API.To_Boolean(l_key_exists) THEN

1169: 'F',
1170: l_rowid,
1171: l_key_exists);
1172:
1173: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1174: l_return_status := 'E';
1175: l_msg_token := l_msg_token || ' ' || p_item_code;
1176: END IF;
1177:

Line 1186: IF NOT FND_API.To_Boolean(l_key_exists) THEN

1182: 'F',
1183: l_rowid,
1184: l_key_exists);
1185:
1186: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1187: l_return_status := 'E';
1188: l_msg_token := l_msg_token || ' ' || p_label_code;
1189: END IF;
1190:

Line 1199: IF NOT FND_API.To_Boolean(l_key_exists) THEN

1195: 'F',
1196: l_rowid,
1197: l_key_exists);
1198:
1199: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1200: l_return_status := 'E';
1201: l_msg_token := l_msg_token || ' ' || p_toxic_route_code;
1202: END IF;
1203:

Line 1212: IF NOT FND_API.To_Boolean(l_key_exists) THEN

1208: 'F',
1209: l_rowid,
1210: l_key_exists);
1211:
1212: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1213: l_return_status := 'E';
1214: l_msg_token := l_msg_token || ' ' || p_toxic_species_code;
1215: END IF;
1216:

Line 1226: IF NOT FND_API.To_Boolean(l_key_exists) THEN

1222: 'F',
1223: l_rowid,
1224: l_key_exists);
1225:
1226: IF NOT FND_API.To_Boolean(l_key_exists) THEN
1227: l_return_status := 'E';
1228: l_msg_token := l_msg_token || ' ' || p_toxic_effect_code;
1229: END IF;
1230: END IF;

Line 1348: IF FND_API.To_Boolean(p_called_by_form) THEN

1344: 'GR_UNEXPECTED_ERROR');
1345: FND_MESSAGE.SET_TOKEN('TEXT',
1346: l_msg_data,
1347: FALSE);
1348: IF FND_API.To_Boolean(p_called_by_form) THEN
1349: APP_EXCEPTION.Raise_Exception;
1350: ELSE
1351: x_msg_data := FND_MESSAGE.Get;
1352: END IF;

Line 1420: IF FND_API.To_Boolean(p_called_by_form) THEN

1416: 'GR_UNEXPECTED_ERROR');
1417: FND_MESSAGE.SET_TOKEN('TEXT',
1418: l_msg_data,
1419: FALSE);
1420: IF FND_API.To_Boolean(p_called_by_form) THEN
1421: APP_EXCEPTION.Raise_Exception;
1422: END IF;
1423:
1424: END Check_Primary_Key;