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

Line 300: x_return_status := FND_API.G_RET_STS_SUCCESS;

296: OPEN c_get_item_code (p_paste_to_item);
297: FETCH c_get_item_code INTO l_paste_item;
298: CLOSE c_get_item_code;
299:
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301: /*
302: ** Check the copy from item exists.
303: */
304: OPEN c_get_item_general;

Line 322: IF FND_API.To_Boolean(l_key_exists) THEN

318: l_called_by_form,
319: l_rowid,
320: l_key_exists);
321:
322: IF FND_API.To_Boolean(l_key_exists) THEN
323: -- RAISE Paste_Item_Exists_Error;
324: /*
325: ** Now get the from info and write the to info
326: **

Line 331: l_return_status := FND_API.G_RET_STS_SUCCESS;

327: ** Item General -- data is already there from the earlier
328: ** cursor read
329: */
330: l_code_block := ' table - Update gr_item_explosion_properties';
331: l_return_status := FND_API.G_RET_STS_SUCCESS;
332: /*
333: ** Check the copy from item exists.
334: */
335: OPEN c_get_item_general_rowid;

Line 399: l_return_status := FND_API.G_RET_STS_SUCCESS;

395: FETCH c_get_item_properties INTO LocalItemPropRecord;
396: IF c_get_item_properties%FOUND THEN
397: WHILE c_get_item_properties%FOUND LOOP
398: l_code_block := ' table - gr_inv_item_properties ';
399: l_return_status := FND_API.G_RET_STS_SUCCESS;
400: /*B1319565 Added for Technical Parameters */
401:
402: OPEN c_get_item_properties_rowid (LocalItemPropRecord.label_code,
403: LocalItemPropRecord.property_id,

Line 694: l_return_status := FND_API.G_RET_STS_SUCCESS;

690: ELSE
691: CLOSE c_get_item_general;
692: END IF;
693:
694: l_return_status := FND_API.G_RET_STS_SUCCESS;
695: GR_ITEM_GENERAL_PKG.Lock_Row
696: (l_commit,
697: l_called_by_form,
698: LocalItemRecord.ROWID,

Line 760: l_return_status := FND_API.G_RET_STS_SUCCESS;

756: /*
757: ** Main row locked ok, now delete the subsidiary tables
758: */
759: l_delete_option := 'I';
760: l_return_status := FND_API.G_RET_STS_SUCCESS;
761: GR_OTHER_NAMES_TL_PKG.Delete_Rows
762: (l_commit,
763: l_called_by_form,
764: l_delete_option,

Line 776: l_return_status := FND_API.G_RET_STS_SUCCESS;

772: RAISE Other_API_ERROR;
773: END IF;
774:
775: l_delete_option := 'I';
776: l_return_status := FND_API.G_RET_STS_SUCCESS;
777: GR_MULTILINGUAL_NAME_TL_PKG.Delete_Rows
778: (l_commit,
779: l_called_by_form,
780: l_delete_option,

Line 792: l_return_status := FND_API.G_RET_STS_SUCCESS;

788: RAISE Other_API_ERROR;
789: END IF;
790:
791: l_delete_option := 'I';
792: l_return_status := FND_API.G_RET_STS_SUCCESS;
793: GR_ITEM_SAFETY_PHRASES_PKG.Delete_Rows
794: (l_commit,
795: l_called_by_form,
796: l_delete_option,

Line 812: l_return_status := FND_API.G_RET_STS_SUCCESS;

808: RAISE Other_API_ERROR;
809: END IF;
810:
811: l_delete_option := 'I';
812: l_return_status := FND_API.G_RET_STS_SUCCESS;
813: GR_ITEM_RISK_PHRASES_PKG.Delete_Rows
814: (l_commit,
815: l_called_by_form,
816: l_delete_option,

Line 827: l_return_status := FND_API.G_RET_STS_SUCCESS;

823: IF l_return_status <> 'S' THEN
824: RAISE Other_API_ERROR;
825: END IF;
826:
827: l_return_status := FND_API.G_RET_STS_SUCCESS;
828: GR_ITEM_RIGHT_TO_KNOW_PKG.Delete_Rows
829: (l_commit,
830: l_called_by_form,
831: p_delete_item,

Line 841: l_return_status := FND_API.G_RET_STS_SUCCESS;

837: RAISE Other_API_ERROR;
838: END IF;
839:
840: l_delete_option := 'I';
841: l_return_status := FND_API.G_RET_STS_SUCCESS;
842: GR_ITEM_SAFETY.Delete_item_document
843: (p_delete_item,
844: '',
845: l_delete_option,

Line 855: l_return_status := FND_API.G_RET_STS_SUCCESS;

851: RAISE Other_API_ERROR;
852: END IF;
853:
854: l_delete_option := 'I';
855: l_return_status := FND_API.G_RET_STS_SUCCESS;
856: GR_ITEM_CLASSNS_PKG.Delete_Rows
857: (l_commit,
858: l_called_by_form,
859: l_delete_option,

Line 870: l_return_status := FND_API.G_RET_STS_SUCCESS;

866: IF l_return_status <> 'S' THEN
867: RAISE Other_API_ERROR;
868: END IF;
869:
870: l_return_status := FND_API.G_RET_STS_SUCCESS;
871: GR_ITEM_DISCLOSURES_PKG.Delete_Rows
872: (l_commit,
873: l_called_by_form,
874: p_delete_item,

Line 883: l_return_status := FND_API.G_RET_STS_SUCCESS;

879: IF l_return_status <> 'S' THEN
880: RAISE Other_API_ERROR;
881: END IF;
882:
883: l_return_status := FND_API.G_RET_STS_SUCCESS;
884: GR_ITEM_CONC_DETAILS_PKG.Delete_Rows
885: (l_commit,
886: l_called_by_form,
887: p_delete_item,

Line 896: l_return_status := FND_API.G_RET_STS_SUCCESS;

892: IF l_return_status <> 'S' THEN
893: RAISE Other_API_ERROR;
894: END IF;
895:
896: l_return_status := FND_API.G_RET_STS_SUCCESS;
897: GR_ITEM_CONCENTRATIONS_PKG.Delete_Rows
898: (l_commit,
899: l_called_by_form,
900: p_delete_item,

Line 910: l_return_status := FND_API.G_RET_STS_SUCCESS;

906: RAISE Other_API_ERROR;
907: END IF;
908:
909: l_delete_option := 'I';
910: l_return_status := FND_API.G_RET_STS_SUCCESS;
911: GR_ITEM_PROPERTIES_PKG.Delete_Rows
912: (l_commit,
913: l_called_by_form,
914: l_delete_option,

Line 926: l_return_status := FND_API.G_RET_STS_SUCCESS;

922: RAISE Other_API_ERROR;
923: END IF;
924:
925: l_delete_option := 'I';
926: l_return_status := FND_API.G_RET_STS_SUCCESS;
927: GR_ITEM_TOXIC_PKG.Delete_Rows
928: (l_commit,
929: l_called_by_form,
930: l_delete_option,

Line 945: l_return_status := FND_API.G_RET_STS_SUCCESS;

941: RAISE Other_API_ERROR;
942: END IF;
943:
944: l_delete_option := 'I';
945: l_return_status := FND_API.G_RET_STS_SUCCESS;
946: GR_ITEM_EXPOSURE_PKG.Delete_Rows
947: (l_commit,
948: l_called_by_form,
949: l_delete_option,

Line 963: l_return_status := FND_API.G_RET_STS_SUCCESS;

959: RAISE Other_API_ERROR;
960: END IF;
961:
962: l_delete_option := 'G';
963: l_return_status := FND_API.G_RET_STS_SUCCESS;
964: GR_GENERIC_ML_NAME_TL_PKG.Delete_Rows
965: (l_commit,
966: l_called_by_form,
967: l_delete_option,

Line 979: l_return_status := FND_API.G_RET_STS_SUCCESS;

975: RAISE Other_API_ERROR;
976: END IF;
977:
978: l_delete_option := 'G';
979: l_return_status := FND_API.G_RET_STS_SUCCESS;
980: GR_GENERIC_ITEMS_B_PKG.Delete_Rows
981: (l_commit,
982: l_called_by_form,
983: l_delete_option,

Line 1003: l_return_status := FND_API.G_RET_STS_SUCCESS;

999: CLOSE c_get_item_emea;
1000: ELSE
1001: CLOSE c_get_item_emea;
1002:
1003: l_return_status := FND_API.G_RET_STS_SUCCESS;
1004: GR_EMEA_PKG.Delete_Row
1005: (l_commit,
1006: l_called_by_form,
1007: LocalEmeaRecord.ROWID,

Line 1061: l_return_status := FND_API.G_RET_STS_SUCCESS;

1057: END IF;
1058: /*
1059: ** Delete the item general row
1060: */
1061: l_return_status := FND_API.G_RET_STS_SUCCESS;
1062: GR_ITEM_GENERAL_PKG.Delete_Row
1063: (l_commit,
1064: l_called_by_form,
1065: LocalItemRecord.ROWID,

Line 1231: l_return_status := FND_API.G_RET_STS_SUCCESS;

1227: RAISE Item_Null_Error;
1228: END IF;
1229:
1230:
1231: l_return_status := FND_API.G_RET_STS_SUCCESS;
1232: GR_ITEM_DOCUMENT_DTLS_PKG.Delete_Rows
1233: (l_commit,
1234: l_called_by_form,
1235: p_delete_option,

Line 1247: l_return_status := FND_API.G_RET_STS_SUCCESS;

1243: IF l_return_status <> 'S' THEN
1244: RAISE Other_API_ERROR;
1245: END IF;
1246:
1247: l_return_status := FND_API.G_RET_STS_SUCCESS;
1248: GR_ITEM_DOC_STATUSES_PKG.Delete_Rows
1249: (l_commit,
1250: l_called_by_form,
1251: p_delete_option,

Line 1265: l_return_status := FND_API.G_RET_STS_SUCCESS;

1261:
1262: /*
1263: ** Delete from dispatch history
1264: */
1265: l_return_status := FND_API.G_RET_STS_SUCCESS;
1266: GR_DISPATCH_HISTORIES_PKG.Delete_Rows
1267: (l_commit,
1268: l_called_by_form,
1269: p_delete_option,

Line 1283: l_return_status := FND_API.G_RET_STS_SUCCESS;

1279: OPEN c_get_document_print;
1280: FETCH c_get_document_print INTO LocalDocumentPrint;
1281: IF c_get_document_print%FOUND THEN
1282: WHILE c_get_document_print%FOUND LOOP
1283: l_return_status := FND_API.G_RET_STS_SUCCESS;
1284: GR_DOCUMENT_DETAILS_PKG.Delete_Rows
1285: (l_commit,
1286: l_called_by_form,
1287: LocalDocumentPrint.document_text_id,

Line 1300: l_return_status := FND_API.G_RET_STS_SUCCESS;

1296: END LOOP;
1297: END IF;
1298: CLOSE c_get_document_print;
1299:
1300: l_return_status := FND_API.G_RET_STS_SUCCESS;
1301: GR_DOCUMENT_PRINT_PKG.Delete_Rows
1302: (l_commit,
1303: l_called_by_form,
1304: p_delete_option,