47: WHERE formula_id = p_formula_id
48: AND line_type <> -1
49: AND i.inventory_item_id = d.inventory_item_id;
50:
51: X_user NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
52: X_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
53: X_row NUMBER := 0;
54: X_item VARCHAR2(32);
55: l_orgn_code VARCHAR2(4);
48: AND line_type <> -1
49: AND i.inventory_item_id = d.inventory_item_id;
50:
51: X_user NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
52: X_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
53: X_row NUMBER := 0;
54: X_item VARCHAR2(32);
55: l_orgn_code VARCHAR2(4);
56: X_from_um mtl_units_of_measure.uom_code%TYPE;
87: P_parm_name => 'GMD_VOLUME_UM_TYPE' ,
88: P_parm_value => P_vol_um_type ,
89: X_return_status => l_return_status );
90:
91: /*P_mass_um_type := FND_PROFILE.VALUE('LM$UOM_MASS_TYPE');
92: P_vol_um_type := FND_PROFILE.VALUE('LM$UOM_VOLUME_TYPE');*/
93:
94: P_density := FND_PROFILE.VALUE('LM$DENSITY');
95:
88: P_parm_value => P_vol_um_type ,
89: X_return_status => l_return_status );
90:
91: /*P_mass_um_type := FND_PROFILE.VALUE('LM$UOM_MASS_TYPE');
92: P_vol_um_type := FND_PROFILE.VALUE('LM$UOM_VOLUME_TYPE');*/
93:
94: P_density := FND_PROFILE.VALUE('LM$DENSITY');
95:
96: FND_MESSAGE.SET_NAME('FND', 'FND_MESSAGE_TYPE_ERROR');
90:
91: /*P_mass_um_type := FND_PROFILE.VALUE('LM$UOM_MASS_TYPE');
92: P_vol_um_type := FND_PROFILE.VALUE('LM$UOM_VOLUME_TYPE');*/
93:
94: P_density := FND_PROFILE.VALUE('LM$DENSITY');
95:
96: FND_MESSAGE.SET_NAME('FND', 'FND_MESSAGE_TYPE_ERROR');
97: P_error := UPPER(FND_MESSAGE.GET)||' : ';
98: FND_MESSAGE.SET_NAME('FND', 'FND_MESSAGE_TYPE_WARNING');
1218: /* Determine if organization is a lab. If not get the default lab type for the user */
1219: OPEN Cur_check_orgn;
1220: FETCH Cur_check_orgn INTO X_temp;
1221: IF (Cur_check_orgn%NOTFOUND) THEN
1222: X_orgn_id := p_laboratory_id; -- FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');
1223: ELSE
1224: X_orgn_id := p_organization_id;
1225: END IF;
1226: CLOSE Cur_check_orgn;