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 428: x_return_status := FND_API.G_RET_STS_SUCCESS;

424: l_catch_weight_acc_id Number ; --MUOM Fulfillment Project
425:
426: BEGIN
427:
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429:
430:
431: SAVEPOINT PROCESS_CONVERSION_DATA;
432:

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

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

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

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

Line 696: IF l_return_status <> fnd_api.g_ret_sts_success THEN

692: (p_mmt_rec => x_batch_txns
693: ,p_mmln_tbl => l_lot_transactions_tbl
694: ,x_return_status => l_return_status);
695:
696: IF l_return_status <> fnd_api.g_ret_sts_success THEN
697: RAISE BATCH_UPDATE_ERROR;
698: END IF;
699:
700: l_batch_updated := 1;

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

735: x_msg_count,
736: x_msg_data);
737:
738:
739: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
740: RAISE INSERT_ERROR;
741: END IF;
742:
743: -- SCHANDRU INVERES START

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

1153: p_table => 1,
1154: p_commit => 'F',
1155: p_clear_qty_cache => 'T');
1156:
1157: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1158: RAISE BATCH_SAVE_ERROR;
1159: END IF;
1160:
1161:

Line 1167: x_return_status := FND_API.G_RET_STS_ERROR;

1163:
1164: WHEN GENERIC_ERROR THEN
1165: ROLLBACK;
1166: FND_MSG_PUB.Add;
1167: x_return_status := FND_API.G_RET_STS_ERROR;
1168:
1169: WHEN CONV_GET_ERR THEN
1170: ROLLBACK;
1171: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');

Line 1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1171: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
1172: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1173: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
1174: FND_MSG_PUB.Add;
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176:
1177:
1178: WHEN INSERT_ERROR THEN
1179: ROLLBACK;

Line 1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1180: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');
1181: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1182: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
1183: FND_MSG_PUB.Add;
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185:
1186:
1187: WHEN OPEN_PERIOD_ERROR THEN
1188: ROLLBACK;

Line 1191: x_return_status := FND_API.G_RET_STS_ERROR;

1187: WHEN OPEN_PERIOD_ERROR THEN
1188: ROLLBACK;
1189: FND_MESSAGE.SET_NAME('INV','INV_NO_OPEN_PERIOD');
1190: FND_MSG_PUB.Add;
1191: x_return_status := FND_API.G_RET_STS_ERROR;
1192:
1193: -- Bug 5533886
1194: -- Added next 3 exceptions.
1195: WHEN UM_CONVERT_ERROR THEN

Line 1198: x_return_status := FND_API.G_RET_STS_ERROR;

1194: -- Added next 3 exceptions.
1195: WHEN UM_CONVERT_ERROR THEN
1196: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR');
1197: fnd_msg_pub.ADD;
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199:
1200: WHEN BATCH_UPDATE_ERROR THEN
1201: x_return_status := l_return_status;
1202:

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1212: ELSE
1213: FND_MESSAGE.SET_NAME('INV','INV_BUSRULES_GENERIC_ERR');
1214: END IF;
1215: FND_MSG_PUB.Add;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217:
1218: ROLLBACK;
1219: IF (SQLCODE IS NOT NULL) THEN
1220: FND_MESSAGE.SET_NAME('INV','INV_LOTC_SQL_ERROR');

Line 1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1223: ELSE
1224: FND_MESSAGE.SET_NAME('INV','INV_BUSRULES_GENERIC_ERR');
1225: END IF;
1226: FND_MSG_PUB.Add;
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228:
1229:
1230: END process_conversion_data;
1231:

Line 1342: x_return_status := FND_API.G_RET_STS_SUCCESS;

1338: IF (p_creation_date IS NULL) THEN
1339: l_creation_date := SYSDATE;
1340: END IF;
1341:
1342: x_return_status := FND_API.G_RET_STS_SUCCESS;
1343: OPEN c_get_conversions;
1344: FETCH c_get_conversions INTO l_lot_uom_conv_rec;
1345: IF (c_get_conversions%NOTFOUND) THEN
1346: CLOSE c_get_conversions;

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

1388: IF (l_exists_cnt = 0) THEN
1389: process_conversion_data(
1390: 'I',5,l_reason_id,NULL,l_lot_uom_conv_rec,
1391: l_qty_update_tbl,l_return_status,l_msg_count,l_error_message,l_seq);
1392: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1393: CLOSE c_get_conversions;
1394: RAISE CONVERSION_INSERT_ERROR;
1395: END IF;
1396: END IF;

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

1405:
1406: /*=============================
1407: Issue commit if required.
1408: ============================*/
1409: IF (p_commit = FND_API.G_TRUE) THEN
1410: COMMIT;
1411: END IF;
1412:
1413: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1413: x_return_status := FND_API.G_RET_STS_SUCCESS;

1409: IF (p_commit = FND_API.G_TRUE) THEN
1410: COMMIT;
1411: END IF;
1412:
1413: x_return_status := FND_API.G_RET_STS_SUCCESS;
1414:
1415: EXCEPTION
1416:
1417: WHEN NO_CONVERSIONS_FOUND THEN

Line 1420: x_return_status := FND_API.G_RET_STS_ERROR;

1416:
1417: WHEN NO_CONVERSIONS_FOUND THEN
1418: FND_MESSAGE.SET_NAME('INV','INV_LOTC_NO_CONV_FOUND');
1419: FND_MSG_PUB.Add;
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421:
1422: WHEN CONVERSION_INSERT_ERROR THEN
1423: ROLLBACK TO COPY_CONVERSION;
1424: FND_MESSAGE.SET_NAME('INV','INV_LOTC_CONV_INSERT_ERROR');

Line 1432: x_return_status := FND_API.G_RET_STS_ERROR;

1428: FND_MESSAGE.SET_TOKEN('ERRCODE',SQLCODE);
1429: FND_MESSAGE.SET_TOKEN('ERRM',SQLERRM(SQLCODE));
1430: FND_MSG_PUB.Add;
1431: END IF;
1432: x_return_status := FND_API.G_RET_STS_ERROR;
1433:
1434: WHEN OTHERS THEN
1435: ROLLBACK TO COPY_CONVERSION;
1436: IF (SQLCODE IS NOT NULL) THEN

Line 1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1440: ELSE
1441: FND_MESSAGE.SET_NAME('INV','INV_BUSRULES_GENERIC_ERR');
1442: END IF;
1443: FND_MSG_PUB.Add;
1444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1445:
1446: END copy_lot_uom_conversions;
1447:
1448: