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 1012: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1008: ,p_material_details_tbl => l_materials
1009: ,x_material_details_tbl => l_materials_out
1010: ,x_trolin_tbl => l_trolin
1011: ,x_return_status => l_return_status);
1012: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1013: RAISE create_mo_line_err;
1014: ELSE
1015: X_move_order_line_id := l_materials_out(1).move_order_line_id;
1016: END IF;

Line 1031: x_return_status := fnd_api.g_ret_sts_error;

1027: l_msg_data := fnd_msg_pub.get (p_msg_index => i
1028: ,p_encoded => 'T');
1029: END LOOP;
1030: WHEN setup_failure THEN
1031: x_return_status := fnd_api.g_ret_sts_error;
1032: WHEN OTHERS THEN
1033: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Add_New_line');
1034: END add_new_line;
1035:

Line 1375: X_return_status := FND_API.g_ret_sts_success;

1371: l_error NUMBER(5) := 0;
1372: l_rec Cur_line_qty%ROWTYPE;
1373: LINE_NOT_FOUND EXCEPTION;
1374: BEGIN
1375: X_return_status := FND_API.g_ret_sts_success;
1376:
1377: l_conv_factor := get_density_value (V_line_id => V_line_id,
1378: V_density_parameter => V_density_parameter);
1379: OPEN Cur_line_qty;

Line 1454: X_return_status := FND_API.g_ret_sts_error;

1450: FETCH Cur_line_item_number INTO l_item_no;
1451: CLOSE Cur_line_item_number;
1452:
1453: IF l_error = 1 THEN
1454: X_return_status := FND_API.g_ret_sts_error;
1455: gmd_api_grp.log_message('LM_BAD_UOMCV', 'ITEM_NO',l_item_no, 'DENSITY',V_density_parameter);
1456: END IF;
1457:
1458: EXCEPTION

Line 1460: X_return_status := FND_API.g_ret_sts_error;

1456: END IF;
1457:
1458: EXCEPTION
1459: WHEN line_not_found THEN
1460: X_return_status := FND_API.g_ret_sts_error;
1461: WHEN OTHERS THEN
1462: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: END update_line_mass_vol_qty;

Line 1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1459: WHEN line_not_found THEN
1460: X_return_status := FND_API.g_ret_sts_error;
1461: WHEN OTHERS THEN
1462: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: END update_line_mass_vol_qty;
1465:
1466: /*##############################################################
1467: # NAME

Line 1490: X_return_status := FND_API.g_ret_sts_success;

1486: AND entity_id = V_entity_id;
1487:
1488: l_return_status VARCHAR2(1);
1489: BEGIN
1490: X_return_status := FND_API.g_ret_sts_success;
1491:
1492: FOR l_rec IN Cur_get_lines LOOP
1493: l_return_status := FND_API.g_ret_sts_success;
1494: update_line_mass_vol_qty (V_orgn_id => V_orgn_id,

Line 1493: l_return_status := FND_API.g_ret_sts_success;

1489: BEGIN
1490: X_return_status := FND_API.g_ret_sts_success;
1491:
1492: FOR l_rec IN Cur_get_lines LOOP
1493: l_return_status := FND_API.g_ret_sts_success;
1494: update_line_mass_vol_qty (V_orgn_id => V_orgn_id,
1495: V_line_id => l_rec.line_id,
1496: V_density_parameter => V_density_parameter,
1497: V_mass_uom => V_mass_uom,

Line 1500: IF l_return_status <> FND_API.g_ret_sts_success THEN

1496: V_density_parameter => V_density_parameter,
1497: V_mass_uom => V_mass_uom,
1498: V_vol_uom => V_vol_uom,
1499: X_return_status => l_return_status);
1500: IF l_return_status <> FND_API.g_ret_sts_success THEN
1501: X_return_status := l_return_status;
1502: END IF;
1503: END LOOP;
1504: END update_mass_vol_qty;

Line 1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1606: END LOOP;
1607: EXCEPTION
1608: WHEN OTHERS THEN
1609: fnd_msg_pub.add_exc_msg ('GMD_SPREAD_FETCH_PKG', 'load_quality_data');
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611: NULL;
1612: END load_quality_data;
1613:
1614: /**#############################################################