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

Line 98: x_return_status := FND_API.g_ret_sts_unexp_error;

94: CLOSE Cur_get_ingred;
95: EXCEPTION
96: WHEN OTHERS THEN
97: fnd_msg_pub.add_exc_msg ('GMD_OPTIMZE_FETCH_PKG', 'Load_Optimizer_Details');
98: x_return_status := FND_API.g_ret_sts_unexp_error;
99: END load_optimizer_details;
100:
101: /*##############################################################
102: # NAME

Line 196: X_return_status := FND_API.g_ret_sts_success;

192: X_byprod_wt NUMBER ;
193: X_byprod_wtpct NUMBER ;
194: X_rollup NUMBER;
195: BEGIN
196: X_return_status := FND_API.g_ret_sts_success;
197:
198: OPEN Cur_get_line_ingred;
199: FETCH Cur_get_line_ingred INTO X_ingred_wt, X_ingred_wtpct;
200: CLOSE Cur_get_line_ingred;

Line 230: X_return_status := FND_API.g_ret_sts_error;

226: END IF;
227:
228: IF X_rollup IS NULL THEN
229: gmd_api_grp.log_message('GMD_WEIGHT_CALCULATE','V_PARM_NAME', V_parm_name);
230: X_return_status := FND_API.g_ret_sts_error;
231: END IF;
232:
233: EXCEPTION
234: WHEN OTHERS THEN

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Rollup_Wt_Pct');
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: END rollup_wt_pct;
238:
239: /*##############################################################
240: # NAME

Line 287: X_return_status := FND_API.g_ret_sts_success;

283: X_byprod_vol NUMBER ;
284: X_byprod_volpct NUMBER ;
285: X_rollup NUMBER;
286: BEGIN
287: X_return_status := FND_API.g_ret_sts_success;
288:
289: OPEN Cur_get_line_ing;
290: FETCH Cur_get_line_ing INTO X_ingred_vol, X_ingred_volpct;
291: CLOSE Cur_get_line_ing;

Line 320: X_return_status := FND_API.g_ret_sts_error;

316: END IF;
317:
318: IF X_rollup IS NULL THEN
319: gmd_api_grp.log_message('GMD_VOLUME_CALCULATE','V_PARM_NAME', V_parm_name);
320: X_return_status := FND_API.g_ret_sts_error;
321: END IF;
322: EXCEPTION
323: WHEN OTHERS THEN
324: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Rollup_Vol_Pct');

Line 325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

321: END IF;
322: EXCEPTION
323: WHEN OTHERS THEN
324: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Rollup_Vol_Pct');
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: END rollup_vol_pct;
327:
328: /*##############################################################
329: # NAME

Line 411: X_return_status := FND_API.g_ret_sts_success;

407: X_ingred_volpct NUMBER ;
408: X_byprod_volpct NUMBER ;
409: X_rollup NUMBER;
410: BEGIN
411: X_return_status := FND_API.g_ret_sts_success;
412:
413: OPEN Cur_get_line_ing2;
414: FETCH Cur_get_line_ing2 INTO X_ingred_volpct;
415: CLOSE Cur_get_line_ing2;

Line 428: X_return_status := FND_API.g_ret_sts_error;

424: RETURN(X_rollup);
425:
426: IF X_rollup IS NULL THEN
427: gmd_api_grp.log_message('GMD_COST_CALCULATE','V_PARM_NAME', V_parm_name);
428: X_return_status := FND_API.g_ret_sts_error;
429: END IF;
430: EXCEPTION
431: WHEN OTHERS THEN
432: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Rollup_Cost_Units');

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

429: END IF;
430: EXCEPTION
431: WHEN OTHERS THEN
432: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Rollup_Cost_Units');
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: END rollup_cost_units;
435:
436: /*##############################################################
437: # NAME

Line 488: X_return_status := FND_API.g_ret_sts_success;

484: l_equiv_qty NUMBER;
485: X_rollup NUMBER;
486: l_error NUMBER;
487: BEGIN
488: X_return_status := FND_API.g_ret_sts_success;
489: FOR l_rec IN Cur_get_line_ing3 LOOP
490: IF (l_rec.detail_uom <> V_unit_code) THEN
491: l_equiv_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
492: pformula_id => NVL(l_rec.tpformula_id,0),

Line 537: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

533: IF(l_error = 1) THEN
534: UPDATE gmd_optimizer_prm_gtmp
535: SET value = NULL
536: WHERE tech_parm_id = V_parm_id;
537: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
538: ELSE
539: IF (X_ingred_mass - X_byprod_mass) <> 0 THEN
540: X_rollup := (X_ingred_equiv - X_byprod_equiv) / (X_ingred_mass - X_byprod_mass);
541: END IF;

Line 562: X_return_status := FND_API.g_ret_sts_error;

558: END IF;
559:
560: IF X_rollup IS NULL THEN
561: gmd_api_grp.log_message('GMD_EQUIV_WEIGHT_CALCULATE','V_PARM_NAME', V_parm_name);
562: X_return_status := FND_API.g_ret_sts_error;
563: END IF;
564:
565: EXCEPTION
566: WHEN OTHERS THEN

Line 568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Rollup_Equiv_Wt');
568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
569: END rollup_equiv_wt;
570:
571: /*##############################################################
572: # NAME

Line 697: X_return_status := FND_API.g_ret_sts_success;

693: l_error NUMBER(5) := 0;
694: l_rec Cur_line_qty%ROWTYPE;
695: LINE_NOT_FOUND EXCEPTION;
696: BEGIN
697: X_return_status := FND_API.g_ret_sts_success;
698:
699: l_conv_factor := get_density_value (V_line_id => V_line_id,
700: V_density_parameter => V_density_parameter);
701:

Line 777: X_return_status := FND_API.g_ret_sts_error;

773: FETCH Cur_line_item_number INTO l_item_no;
774: CLOSE Cur_line_item_number;
775:
776: IF l_error = 1 THEN
777: X_return_status := FND_API.g_ret_sts_error;
778: gmd_api_grp.log_message('LM_BAD_UOMCV', 'ITEM_NO',l_item_no);
779: END IF;
780:
781: EXCEPTION

Line 783: X_return_status := FND_API.g_ret_sts_error;

779: END IF;
780:
781: EXCEPTION
782: WHEN line_not_found THEN
783: X_return_status := FND_API.g_ret_sts_error;
784: WHEN OTHERS THEN
785: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: END update_line_mass_vol_qty;

Line 786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782: WHEN line_not_found THEN
783: X_return_status := FND_API.g_ret_sts_error;
784: WHEN OTHERS THEN
785: fnd_msg_pub.add_exc_msg ('GMD_OPTIMIZE_FETCH_PKG', 'Update_Line_Mass_Vol_Qty');
786: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: END update_line_mass_vol_qty;
788:
789: /*##############################################################
790: # NAME

Line 812: X_return_status := FND_API.g_ret_sts_success;

808: AND entity_id = V_entity_id;
809:
810: l_return_status VARCHAR2(1);
811: BEGIN
812: X_return_status := FND_API.g_ret_sts_success;
813:
814: FOR l_rec IN Cur_get_lines LOOP
815: l_return_status := FND_API.g_ret_sts_success;
816:

Line 815: l_return_status := FND_API.g_ret_sts_success;

811: BEGIN
812: X_return_status := FND_API.g_ret_sts_success;
813:
814: FOR l_rec IN Cur_get_lines LOOP
815: l_return_status := FND_API.g_ret_sts_success;
816:
817: update_line_mass_vol_qty (V_orgn_id => V_orgn_id,
818: V_line_id => l_rec.line_id,
819: V_density_parameter => V_density_parameter,