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.MTL_LOT_UOM_CONV_PVT dependencies on FND_API

Line 427: x_return_status := FND_API.G_RET_STS_SUCCESS;

423: l_transaction_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
424:
425: BEGIN
426:
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428:
429:
430: SAVEPOINT PROCESS_CONVERSION_DATA;
431:

Line 510: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

506: x_msg_data
507: );
508: END IF;
509:
510: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
511: RAISE INSERT_ERROR;
512: END IF;
513:
514:

Line 521: gme_common_pvt.g_move_to_temp := fnd_api.g_false;

517: OPEN get_uom_codes;
518: FETCH get_uom_codes INTO l_primary_uom, l_secondary_uom;
519: CLOSE get_uom_codes;
520:
521: gme_common_pvt.g_move_to_temp := fnd_api.g_false;
522:
523: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_lot_uom_conv_rec.organization_id);
524: gme_common_pvt.set_who;
525:

Line 691: IF l_return_status <> fnd_api.g_ret_sts_success THEN

687: (p_mmt_rec => x_batch_txns
688: ,p_mmln_tbl => l_lot_transactions_tbl
689: ,x_return_status => l_return_status);
690:
691: IF l_return_status <> fnd_api.g_ret_sts_success THEN
692: RAISE BATCH_UPDATE_ERROR;
693: END IF;
694:
695: l_batch_updated := 1;

Line 734: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

730: x_msg_count,
731: x_msg_data);
732:
733:
734: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
735: RAISE INSERT_ERROR;
736: END IF;
737:
738: -- SCHANDRU INVERES START

Line 1139: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1135: p_table => 1,
1136: p_commit => 'F',
1137: p_clear_qty_cache => 'T');
1138:
1139: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1140: RAISE BATCH_SAVE_ERROR;
1141: END IF;
1142:
1143:

Line 1149: x_return_status := FND_API.G_RET_STS_ERROR;

1145:
1146: WHEN GENERIC_ERROR THEN
1147: ROLLBACK;
1148: FND_MSG_PUB.Add;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150:
1151: WHEN CONV_GET_ERR THEN
1152: ROLLBACK;
1153: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');

Line 1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1153: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
1154: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1155: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
1156: FND_MSG_PUB.Add;
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1158:
1159:
1160: WHEN INSERT_ERROR THEN
1161: ROLLBACK;

Line 1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1162: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
1163: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1164: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
1165: FND_MSG_PUB.Add;
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167:
1168:
1169: WHEN OPEN_PERIOD_ERROR THEN
1170: ROLLBACK;

Line 1173: x_return_status := FND_API.G_RET_STS_ERROR;

1169: WHEN OPEN_PERIOD_ERROR THEN
1170: ROLLBACK;
1171: FND_MESSAGE.SET_NAME('INV','INV_NO_OPEN_PERIOD');
1172: FND_MSG_PUB.Add;
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174:
1175: -- Bug 5533886
1176: -- Added next 3 exceptions.
1177: WHEN UM_CONVERT_ERROR THEN

Line 1180: x_return_status := FND_API.G_RET_STS_ERROR;

1176: -- Added next 3 exceptions.
1177: WHEN UM_CONVERT_ERROR THEN
1178: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1179: fnd_msg_pub.ADD;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181:
1182: WHEN BATCH_UPDATE_ERROR THEN
1183: x_return_status := l_return_status;
1184:

Line 1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1194: ELSE
1195: FND_MESSAGE.SET_NAME('INV','INV_BUSRULES_GENERIC_ERR');
1196: END IF;
1197: FND_MSG_PUB.Add;
1198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1199:
1200: ROLLBACK;
1201: IF (SQLCODE IS NOT NULL) THEN
1202: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');

Line 1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1205: ELSE
1206: FND_MESSAGE.SET_NAME('INV','INV_BUSRULES_GENERIC_ERR');
1207: END IF;
1208: FND_MSG_PUB.Add;
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210:
1211:
1212: END process_conversion_data;
1213:

Line 1324: x_return_status := FND_API.G_RET_STS_SUCCESS;

1320: IF (p_creation_date IS NULL) THEN
1321: l_creation_date := SYSDATE;
1322: END IF;
1323:
1324: x_return_status := FND_API.G_RET_STS_SUCCESS;
1325: OPEN c_get_conversions;
1326: FETCH c_get_conversions INTO l_lot_uom_conv_rec;
1327: IF (c_get_conversions%NOTFOUND) THEN
1328: CLOSE c_get_conversions;

Line 1374: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1370: IF (l_exists_cnt = 0) THEN
1371: process_conversion_data(
1372: 'I',5,l_reason_id,NULL,l_lot_uom_conv_rec,
1373: l_qty_update_tbl,l_return_status,l_msg_count,l_error_message,l_seq);
1374: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1375: CLOSE c_get_conversions;
1376: RAISE CONVERSION_INSERT_ERROR;
1377: END IF;
1378: END IF;

Line 1391: IF (p_commit = FND_API.G_TRUE) THEN

1387:
1388: /*=============================
1389: Issue commit if required.
1390: ============================*/
1391: IF (p_commit = FND_API.G_TRUE) THEN
1392: COMMIT;
1393: END IF;
1394:
1395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1395: x_return_status := FND_API.G_RET_STS_SUCCESS;

1391: IF (p_commit = FND_API.G_TRUE) THEN
1392: COMMIT;
1393: END IF;
1394:
1395: x_return_status := FND_API.G_RET_STS_SUCCESS;
1396:
1397: EXCEPTION
1398:
1399: WHEN NO_CONVERSIONS_FOUND THEN

Line 1402: x_return_status := FND_API.G_RET_STS_ERROR;

1398:
1399: WHEN NO_CONVERSIONS_FOUND THEN
1400: FND_MESSAGE.SET_NAME('INV','INV_LOTC_NO_CONV_FOUND');
1401: FND_MSG_PUB.Add;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403:
1404: WHEN CONVERSION_INSERT_ERROR THEN
1405: ROLLBACK TO COPY_CONVERSION;
1406: FND_MESSAGE.SET_NAME('INV','INV_LOTC_CONV_INSERT_ERROR');

Line 1414: x_return_status := FND_API.G_RET_STS_ERROR;

1410: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1411: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
1412: FND_MSG_PUB.Add;
1413: END IF;
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415:
1416: WHEN OTHERS THEN
1417: ROLLBACK TO COPY_CONVERSION;
1418: IF (SQLCODE IS NOT NULL) THEN

Line 1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1422: ELSE
1423: FND_MESSAGE.SET_NAME('INV','INV_BUSRULES_GENERIC_ERR');
1424: END IF;
1425: FND_MSG_PUB.Add;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427:
1428: END copy_lot_uom_conversions;
1429:
1430: