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

Line 310: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN

306: gme_transactions_pvt.get_mat_trans (p_mat_det_id => l_batch_rec.material_detail_id
307: ,p_batch_id => V_batch_id
308: ,x_mmt_tbl => l_mmt_tbl
309: ,x_return_status => l_status);
310: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
311: FOR i in 1..l_mmt_tbl.COUNT LOOP
312: gme_transactions_pvt.get_lot_trans (p_transaction_id => l_mmt_tbl(i).transaction_id
313: ,x_mmln_tbl => l_mmln_tbl
314: ,x_return_status => x_return_status);

Line 315: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

311: FOR i in 1..l_mmt_tbl.COUNT LOOP
312: gme_transactions_pvt.get_lot_trans (p_transaction_id => l_mmt_tbl(i).transaction_id
313: ,x_mmln_tbl => l_mmln_tbl
314: ,x_return_status => x_return_status);
315: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
316: FOR j IN 1..l_mmln_tbl.COUNT LOOP
317: IF (l_mmln_tbl(j).lot_number IS NOT NULL) THEN
318: l_line_id := l_line_id + 1;
319: IF l_material_detail_id <> l_mmt_tbl(i).transaction_source_id THEN

Line 364: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN

360: ,p_batch_id => V_batch_id
361: ,p_material_detail_id => l_batch_rec.material_detail_id
362: ,x_return_status => l_status
363: ,x_reservations_tbl => l_reservations_tbl);
364: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
365: FOR i IN 1..l_reservations_tbl.COUNT LOOP
366: IF (l_reservations_tbl(i).lot_number IS NOT NULL) THEN
367: l_line_id := l_line_id + 1;
368: IF l_material_detail_id <> l_reservations_tbl(i).demand_source_line_id THEN

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

1038: ,p_material_details_tbl => l_materials
1039: ,x_material_details_tbl => l_materials_out
1040: ,x_trolin_tbl => l_trolin
1041: ,x_return_status => l_return_status);
1042: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1043: RAISE create_mo_line_err;
1044: ELSE
1045: X_move_order_line_id := l_materials_out(1).move_order_line_id;
1046: END IF;

Line 1064: x_return_status := fnd_api.g_ret_sts_error;

1060: l_msg_data := fnd_msg_pub.get (p_msg_index => i
1061: ,p_encoded => 'T');
1062: END LOOP;
1063: WHEN setup_failure THEN
1064: x_return_status := fnd_api.g_ret_sts_error;
1065: WHEN OTHERS THEN
1066: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Add_New_line');
1067: END add_new_line;
1068:

Line 1409: X_return_status := FND_API.g_ret_sts_success;

1405: l_error NUMBER(5) := 0;
1406: l_rec Cur_line_qty%ROWTYPE;
1407: LINE_NOT_FOUND EXCEPTION;
1408: BEGIN
1409: X_return_status := FND_API.g_ret_sts_success;
1410:
1411: l_conv_factor := get_density_value (V_line_id => V_line_id,
1412: V_density_parameter => V_density_parameter);
1413: OPEN Cur_line_qty;

Line 1497: X_return_status := FND_API.g_ret_sts_error;

1493:
1494:
1495:
1496: IF l_error = 1 THEN
1497: X_return_status := FND_API.g_ret_sts_error;
1498: -- comment in bug15886166
1499: --gmd_api_grp.log_message('LM_BAD_UOMCV', 'ITEM_NO',l_item_no, 'DENSITY',V_density_parameter);
1500: END IF;
1501:

Line 1504: X_return_status := FND_API.g_ret_sts_error;

1500: END IF;
1501:
1502: EXCEPTION
1503: WHEN line_not_found THEN
1504: X_return_status := FND_API.g_ret_sts_error;
1505: WHEN OTHERS THEN
1506: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: END update_line_mass_vol_qty;

Line 1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1503: WHEN line_not_found THEN
1504: X_return_status := FND_API.g_ret_sts_error;
1505: WHEN OTHERS THEN
1506: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: END update_line_mass_vol_qty;
1509:
1510: /*##############################################################
1511: # NAME

Line 1534: X_return_status := FND_API.g_ret_sts_success;

1530: AND entity_id = V_entity_id;
1531:
1532: l_return_status VARCHAR2(1);
1533: BEGIN
1534: X_return_status := FND_API.g_ret_sts_success;
1535:
1536: FOR l_rec IN Cur_get_lines LOOP
1537: l_return_status := FND_API.g_ret_sts_success;
1538: update_line_mass_vol_qty (V_orgn_id => V_orgn_id,

Line 1537: l_return_status := FND_API.g_ret_sts_success;

1533: BEGIN
1534: X_return_status := FND_API.g_ret_sts_success;
1535:
1536: FOR l_rec IN Cur_get_lines LOOP
1537: l_return_status := FND_API.g_ret_sts_success;
1538: update_line_mass_vol_qty (V_orgn_id => V_orgn_id,
1539: V_line_id => l_rec.line_id,
1540: V_density_parameter => V_density_parameter,
1541: V_mass_uom => V_mass_uom,

Line 1544: IF l_return_status <> FND_API.g_ret_sts_success THEN

1540: V_density_parameter => V_density_parameter,
1541: V_mass_uom => V_mass_uom,
1542: V_vol_uom => V_vol_uom,
1543: X_return_status => l_return_status);
1544: IF l_return_status <> FND_API.g_ret_sts_success THEN
1545: X_return_status := l_return_status;
1546: END IF;
1547: END LOOP;
1548: END update_mass_vol_qty;

Line 1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1650: END LOOP;
1651: EXCEPTION
1652: WHEN OTHERS THEN
1653: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'load_quality_data');
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: NULL;
1656: END load_quality_data;
1657:
1658: /**#############################################################